예제 #1
0
 public static Employee ToMedel(DataRow row)
 {
     Employee employee = new Employee();
     employee.Address = (string)row["Address"];
     employee.BaseSalary = (int)row["BaseSalary"];
     employee.BirthDay = (DateTime)row["BirthDay"];
     employee.ContractEndDay = (DateTime)row["ContractEndDay"];
     employee.ContractStartDay = (DateTime)row["ContractStartDay"];
     employee.DepartmentId = (Guid)row["DepartmentId"];
     employee.EducationId = (Guid)row["EducationId"];
     employee.Email = (string)row["Email"];
     employee.EmergencyContact = (string)SqlHelper.FromDbValue(row["EmergencyContact"]);
     employee.GenderId = (Guid)row["GenderId"];
     employee.Id = (Guid)row["Id"];
     employee.IdNum = (string)row["IdNum"];
     employee.InDate = (DateTime)row["InDate"];
     employee.Major = (string)row["Major"];
     employee.MarriageId = (Guid)row["MarriageId"];
     employee.Name = (string)row["Name"];
     employee.Nationality = (string)row["Nationality"];
     employee.NativeAddr = (string)row["NativeAddr"];
     employee.Number = (string)row["Number"];
     employee.PartyStatusId = (Guid)row["PartyStatusId"];
     employee.Position = (string)row["Position"];
     employee.Remarks = (string)SqlHelper.FromDbValue(row["Remarks"]);
     employee.Resume = (string)SqlHelper.FromDbValue(row["Resume"]);
     employee.School = (string)SqlHelper.FromDbValue(row["School"]);
     employee.TelNum = (string)row["TelNum"];
     //todo:如果员工非常多,那么Photo会增加内存占用
     employee.Photo = (byte[])SqlHelper.FromDbValue(row["Photo"]);
     return employee;
 }
예제 #2
0
        private void Window_Loaded(object sender, RoutedEventArgs e)
        {
            cbDepartment.ItemsSource = DepartmentDAL.ListALL();
            cbEducation.ItemsSource = IdNameDAL.GetByCatagory("学历");
            cbGender.ItemsSource = IdNameDAL.GetByCatagory("性别");
            cbMarriage.ItemsSource = IdNameDAL.GetByCatagory("婚姻状况");
            cbPartyStatus.ItemsSource = IdNameDAL.GetByCatagory("政治面貌");
            if (IsAddNew)
            {
                Employee employee = new Employee();
                employee.InDate = DateTime.Today;
                employee.ContractStartDay = DateTime.Today;
                employee.ContractEndDay = DateTime.Today.AddYears(1);
                employee.Nationality = "汉族";
                employee.Email = "*****@*****.**";
                //employee.Number = "Ideas";
                employee.Number = SettingDAL.GetValue("员工工号前缀");
                gridEmployee.DataContext = employee;

            }
            else
            {
                Employee employee = EmployeeDAL.GetById(EditingId);
                gridEmployee.DataContext = employee;

                if (employee.Photo!= null)
                {
                    ShowImage(employee.Photo);
                }
            }
        }
예제 #3
0
 public static Employee[] ListAll()
 {
     DataTable dt = SqlHelper.ExecuteDataTable("select * from T_Employee where IsStopped=0");
     Employee[] employees = new Employee[dt.Rows.Count];
     for (int i = 0; i < dt.Rows.Count; i++)
     {
         employees[i] = ToMedel(dt.Rows[i]);
     }
     return employees;
 }
예제 #4
0
        public static void Insert(Employee employee)
        {
            SqlHelper.ExcuteNonQuery(@"INSERT INTO [T_Employee]
           ([Id],[Number],[Name],[BirthDay],[InDate],[MarriageId],[PartyStatusId],[Nationality]
           ,[NativeAddr],[EducationId],[Major],[School],[Address],[BaseSalary],[Email]
           ,[IdNum],[TelNum],[EmergencyContact],[DepartmentId],[Position],[ContractStartDay]
           ,[ContractEndDay],[Resume],[Remarks],[IsStopped],[GenderId],Photo)
            VALUES(newid(),@Number,@Name,@BirthDay,@InDate,@MarriageId,@PartyStatusId,@Nationality
           ,@NativeAddr,@EducationId,@Major,@School,@Address,@BaseSalary,@Email
           ,@IdNum,@TelNum,@EmergencyContact,@DepartmentId,@Position,@ContractStartDay
           ,@ContractEndDay,@Resume,@Remarks,0,@GenderId,@Photo)", new SqlParameter("@Number", employee.Number)
                                                         , new SqlParameter("@Name", employee.Name)
                                                         , new SqlParameter("@BirthDay", employee.BirthDay)
                                                         , new SqlParameter("@InDate", employee.InDate)
                                                         , new SqlParameter("@MarriageId", employee.MarriageId)
                                                         , new SqlParameter("@PartyStatusId", employee.PartyStatusId)
                                                         , new SqlParameter("@Nationality", employee.Nationality)
                                                         , new SqlParameter("@NativeAddr", employee.NativeAddr)
                                                         , new SqlParameter("@EducationId", employee.EducationId)
                                                         , new SqlParameter("@Major", SqlHelper.ToDbValue(employee.Major))
                                                         , new SqlParameter("@School", SqlHelper.ToDbValue(employee.School))
                                                         , new SqlParameter("@Address", employee.Address)
                                                         , new SqlParameter("@BaseSalary", employee.BaseSalary)
                                                         , new SqlParameter("@Email", SqlHelper.ToDbValue(employee.Email))
                                                         , new SqlParameter("@IdNum", employee.IdNum)
                                                         , new SqlParameter("@TelNum", employee.TelNum)
                                                         , new SqlParameter("@EmergencyContact", SqlHelper.ToDbValue(employee.EmergencyContact))
                                                         , new SqlParameter("@DepartmentId", employee.DepartmentId)
                                                         , new SqlParameter("@Position", employee.Position)
                                                         , new SqlParameter("@ContractStartDay", employee.ContractStartDay)
                                                         , new SqlParameter("@ContractEndDay", employee.ContractEndDay)
                                                         , new SqlParameter("@Resume", SqlHelper.ToDbValue(employee.Resume))
                                                         , new SqlParameter("@Remarks", SqlHelper.ToDbValue(employee.Remarks))
                                                         , new SqlParameter("@GenderId", employee.GenderId)
                                                         ,new SqlParameter("@Photo",employee.Photo));

        }
예제 #5
0
 public static Employee[] GetEmployeeByDept(Guid DeptId)
 {
     DataTable table = SqlHelper.ExecuteDataTable(@"select * from T_Employee where DepartmentId=@DeptId",
         new SqlParameter("@DeptId", DeptId));
     Employee[] items = new Employee[table.Rows.Count];
     for (int i = 0; i < table.Rows.Count; i++)
     {
         items[i] = ToMedel(table.Rows[i]);
     }
     return items;
 }
예제 #6
0
        public static Employee[] Search(string sql, List<SqlParameter> sqlParameters)
        {
            DataTable table = SqlHelper.ExecuteDataTable(sql, sqlParameters.ToArray());
            Employee[] items = new Employee[table.Rows.Count];
            for (int i = 0; i < table.Rows.Count; i++)
            {
                items[i] = ToMedel(table.Rows[i]);
            }
            return items;

        }
예제 #7
0
 public static  void UpdateImageNull(Employee employee)
 {
     SqlHelper.ExcuteNonQuery(@"Update T_Employee set 
     [Number]=@Number,[Name]=@Name,[BirthDay]=@BirthDay,[InDate]=@InDate,
     [MarriageId]=@MarriageId,[PartyStatusId]=@PartyStatusId,[Nationality]=@Nationality,
     [NativeAddr]=@NativeAddr,[EducationId]=@EducationId,[Major]=@Major,[School]=@School,
     [Address]=@Address,[BaseSalary]=@BaseSalary,[Email]=@Email,
     [IdNum]=@IdNum,[TelNum]=@TelNum,[EmergencyContact]=@EmergencyContact,
     [DepartmentId]=@DepartmentId,[Position]=@Position,[ContractStartDay]=@ContractStartDay,
     [ContractEndDay]=@ContractEndDay,[Resume]=@Resume,[Remarks]=@Remarks,[GenderId]=@GenderId
     ,Photo=@Photo
     Where Id=@Id", new SqlParameter("@Number", employee.Number)
                                                  , new SqlParameter("@Name", employee.Name)
                                                  , new SqlParameter("@BirthDay", employee.BirthDay)
                                                  , new SqlParameter("@InDate", employee.InDate)
                                                  , new SqlParameter("@MarriageId", employee.MarriageId)
                                                  , new SqlParameter("@PartyStatusId", employee.PartyStatusId)
                                                  , new SqlParameter("@Nationality", employee.Nationality)
                                                  , new SqlParameter("@NativeAddr", employee.NativeAddr)
                                                  , new SqlParameter("@EducationId", employee.EducationId)
                                                  , new SqlParameter("@Major", SqlHelper.ToDbValue(employee.Major))
                                                  , new SqlParameter("@School", SqlHelper.ToDbValue(employee.School))
                                                  , new SqlParameter("@Address", employee.Address)
                                                  , new SqlParameter("@BaseSalary", employee.BaseSalary)
                                                  , new SqlParameter("@Email", SqlHelper.ToDbValue(employee.Email))
                                                  , new SqlParameter("@IdNum", employee.IdNum)
                                                  , new SqlParameter("@TelNum", employee.TelNum)
                                                  , new SqlParameter("@EmergencyContact", SqlHelper.ToDbValue(employee.EmergencyContact))
                                                  , new SqlParameter("@DepartmentId", employee.DepartmentId)
                                                  , new SqlParameter("@Position", employee.Position)
                                                  , new SqlParameter("@ContractStartDay", employee.ContractStartDay)
                                                  , new SqlParameter("@ContractEndDay", employee.ContractEndDay)
                                                  , new SqlParameter("@Resume", SqlHelper.ToDbValue(employee.Resume))
                                                  , new SqlParameter("@Remarks", SqlHelper.ToDbValue(employee.Remarks))
                                                  , new SqlParameter("@GenderId", employee.GenderId)
                                                  , new SqlParameter("@Photo", SqlDbType.Image) { Value = DBNull.Value }
                                                  , new SqlParameter("@Id", employee.Id));
 }