(27-07-23, 12:55 PM)ahmed_king2023 كتب : اخي توجد مشكلة في موقع
قمت برفعه علي ميديا فاير
https://www.mediafire.com/file/j2qjegwtedue9rt/emploesss.rar/file

(27-07-23, 07:24 PM)ahmed_king2023 كتب : عملت مشروع قاعدة بيانات اسمه HR
http://www.mediafire.com/file/20c0aam0tkv29v9/WindowsFormsApplication24.rar

(27-07-23, 08:28 PM)ahmed_king2023 كتب : USE [master]
GO

/****** Object: Database

---

Script Date: 27/07/2023 06:13:23 م ******/
CREATE DATABASE

---

CONTAINMENT = NONE
ON PRIMARY
( NAME = N'HR', FILENAME = N'D:\Microsoft SQL Server\MSSQL12.AYMEN\MSSQL\DATA\HR.mdf' , SIZE = 3072KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )
LOG ON
( NAME = N'HR_log', FILENAME = N'D:\Microsoft SQL Server\MSSQL12.AYMEN\MSSQL\DATA\HR_log.ldf' , SIZE = 1024KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)
GO
USE

---

GO
/****** Object: Table [dbo].[dept] Script Date: 27/07/2023 06:20:43 م ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[dept](
[dept_id] [int] IDENTITY(1,1) NOT NULL,
[dept_name] [nvarchar](150) NULL,
[id_mange] [int] NULL,
[employee_id] [int] NULL,
CONSTRAINT [PK_dept] PRIMARY KEY CLUSTERED
(
[dept_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
/****** Object: Table [dbo].[Employees] Script Date: 27/07/2023 06:20:43 م ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Employees](
[id] [int] IDENTITY(1,1) NOT NULL,
[EmployeeID] [int] NOT NULL,
[EmployeeName] [nvarchar](150) NULL,
[Nationality] [nvarchar](150) NULL,
[Gender] [nvarchar](50) NULL,
[phone] [varchar](150) NULL,
CONSTRAINT [PK_Employees] PRIMARY KEY CLUSTERED
(
[EmployeeID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[management] Script Date: 27/07/2023 06:20:43 م ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[management](
[id] [int] IDENTITY(1,1) NOT NULL,
[manage_name] [nvarchar](150) NULL,
[employee_id] [int] NULL,
CONSTRAINT [PK_management] PRIMARY KEY CLUSTERED
(
[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
/****** Object: Table [dbo].[unit] Script Date: 27/07/2023 06:20:43 م ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[unit](
[id] [int] IDENTITY(1,1) NOT NULL,
[unit_name] [nvarchar](150) NULL,
[dept_id] [int] NULL,
[employee_id] [int] NULL,
CONSTRAINT [PK_unit] PRIMARY KEY CLUSTERED
(
[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

(27-07-23, 09:15 PM)ahmed_king2023 كتب : CREATE TABLE [dbo].[dept](
[dept_id] [int] IDENTITY(1,1) NOT NULL,
[dept_name] [nvarchar](150) NULL,
[id_mange] [int] NULL,
[employee_id] [int] NULL,
CONSTRAINT [PK_dept] PRIMARY KEY CLUSTERED
(
[dept_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
CREATE TABLE [dbo].[Employees](
[id] [int] IDENTITY(1,1) NOT NULL,
[EmployeeID] [int] NOT NULL,
[EmployeeName] [nvarchar](150) NULL,
[Nationality] [nvarchar](150) NULL,
[Gender] [nvarchar](50) NULL,
[phone] [varchar](150) NULL,
CONSTRAINT [PK_Employees] PRIMARY KEY CLUSTERED
(
[EmployeeID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
CREATE TABLE [dbo].[management](
[id] [int] IDENTITY(1,1) NOT NULL,
[manage_name] [nvarchar](150) NULL,
[employee_id] [int] NULL,
CONSTRAINT [PK_management] PRIMARY KEY CLUSTERED
(
[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
CREATE TABLE [dbo].[unit](
[id] [int] IDENTITY(1,1) NOT NULL,
[unit_name] [nvarchar](150) NULL,
[dept_id] [int] NULL,
[employee_id] [int] NULL,
CONSTRAINT [PK_unit] PRIMARY KEY CLUSTERED
(
[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

---

اخي لديك اسماء جدوال وحقوله في سكربت فوق

(28-07-23, 12:42 AM)ahmed_king2023 كتب : اخي قاعده بيانات جديده تعتبر لايوجد لدي اي اجراء مخزن او بيانات جديده قاعده
انا اريد مثلا كيفية بحيث عندما ابحث عن موظف يظهر لي اي ادارة يتبع واي قسم واي وحدة
موظف عبد الخالق ادارة موارد بشرية قسم شؤون موظفين وحدة ملاك وظيفي
هدا سكربت
USE

---

GO
/****** Object:  Table [dbo].[dept]    Script Date: 27/07/2023 10:40:13 م ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[dept](
[dept_id] [int] IDENTITY(1,1) NOT NULL,
[dept_name] [nvarchar](150) NULL,
[id_mange] [int] NULL,
[employee_id] [int] NULL,
CONSTRAINT [PK_dept] PRIMARY KEY CLUSTERED
(
[dept_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[Employees]    Script Date: 27/07/2023 10:40:13 م ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Employees](
[id] [int] IDENTITY(1,1) NOT NULL,
[EmployeeID] [int] NOT NULL,
[EmployeeName] [nvarchar](150) NULL,
[Nationality] [nvarchar](150) NULL,
[Gender] [nvarchar](50) NULL,
[phone] [varchar](150) NULL,
CONSTRAINT [PK_Employees] PRIMARY KEY CLUSTERED
(
[EmployeeID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[management]    Script Date: 27/07/2023 10:40:13 م ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[management](
[id] [int] IDENTITY(1,1) NOT NULL,
[manage_name] [nvarchar](150) NULL,
[employee_id] [int] NULL,
CONSTRAINT [PK_management] PRIMARY KEY CLUSTERED
(
[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[unit]    Script Date: 27/07/2023 10:40:13 م ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[unit](
[id] [int] IDENTITY(1,1) NOT NULL,
[unit_name] [nvarchar](150) NULL,
[dept_id] [int] NULL,
[employee_id] [int] NULL,
CONSTRAINT [PK_unit] PRIMARY KEY CLUSTERED
(
[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
SET IDENTITY_INSERT [dbo].[management] ON

INSERT [dbo].[management] ([id], [manage_name], [employee_id]) VALUES (2, N'ادارة الموارد البشرية', NULL)
INSERT [dbo].[management] ([id], [manage_name], [employee_id]) VALUES (4, N'ادارة الشؤون الادارية', NULL)
SET IDENTITY_INSERT [dbo].[management] OFF

---

رقم وظيفي هو employee_id
بحيث يميز موظف عن الاخر
عندما ابحث عن موظف يكون هو يميزه عن موظف اخر