コード例 #1
0
        public bool EmployeeListAdd(List <EmployeeAddExcle> empList, string createPerson)
        {
            using (SysEntities db = new SysEntities())
            {
                using (var tran = db.Database.BeginTransaction())
                {
                    try
                    {
                        if (empList != null)
                        {
                            foreach (EmployeeAddExcle employ in empList)
                            {
                                Employee                employee                = new Employee();                //员工表
                                EmployeeContact         employeeContact         = new EmployeeContact();         //联系人表
                                CompanyEmployeeRelation companyEmployeeRelation = new CompanyEmployeeRelation(); //员工企业关系表
                                EmployeeBank            employeebank            = new EmployeeBank();            //员工银行


                                //员工基本
                                employee.Name              = employ.Empname;
                                employee.CertificateType   = employ.CertificateType;
                                employee.CertificateNumber = employ.CertificateNumber;
                                employee.AccountType       = employ.AccountType;
                                employee.Sex          = Common.CardCommon.Getsex(employ.CertificateNumber) == 1 ? "男" : "女";
                                employee.Birthday     = Common.CardCommon.GetShengRi(employ.CertificateNumber);
                                employee.CreateTime   = DateTime.Now;
                                employee.CreatePerson = createPerson;
                                db.Employee.Add(employee);


                                //联系人
                                employeeContact.Telephone    = employ.Telephone;
                                employeeContact.MobilePhone  = employ.MobilePhone;
                                employeeContact.Address      = employ.Address;
                                employeeContact.Email        = employ.Email;
                                employeeContact.EmployeeId   = employee.Id;
                                employeeContact.State        = "启用";
                                employeeContact.CreateTime   = DateTime.Now;
                                employeeContact.CreatePerson = createPerson;
                                db.EmployeeContact.Add(employeeContact);
                                db.SaveChanges();

                                // 银行信息
                                //if (!string.IsNullOrWhiteSpace(employeebank.AccountName))
                                {
                                    employeebank.EmployeeId   = employee.Id;
                                    employeebank.AccountName  = employ.AccountName;
                                    employeebank.Bank         = employ.Bank;
                                    employeebank.BranchBank   = employ.BranchBank;
                                    employeebank.Account      = employ.Account;
                                    employeebank.IsDefault    = employ.Account;
                                    employeebank.State        = "启用";
                                    employeebank.CreateTime   = DateTime.Now;
                                    employeebank.CreatePerson = createPerson;
                                    db.EmployeeBank.Add(employeebank);
                                    db.SaveChanges();
                                }


                                //员工关系表
                                companyEmployeeRelation.CityId                = employ.City;
                                companyEmployeeRelation.CompanyId             = employ.CompanyId;
                                companyEmployeeRelation.EmployeeId            = employee.Id;
                                companyEmployeeRelation.State                 = "在职";
                                companyEmployeeRelation.Station               = employ.Station;
                                companyEmployeeRelation.PoliceAccountNatureId = employ.PoliceAccountNature;
                                companyEmployeeRelation.CreateTime            = DateTime.Now;
                                companyEmployeeRelation.CreatePerson          = createPerson;
                                db.CompanyEmployeeRelation.Add(companyEmployeeRelation);
                                db.SaveChanges();
                            }
                        }


                        tran.Commit();
                        return(true);
                    }
                    //catch
                    //{
                    //    tran.Rollback();

                    //    return false;
                    //}

                    catch (System.Data.Entity.Validation.DbEntityValidationException ex)
                    {
                        tran.Rollback();
                        foreach (var errors in ex.EntityValidationErrors)
                        {
                            foreach (var item in errors.ValidationErrors)
                            {
                                Console.WriteLine(item.ErrorMessage + item.PropertyName);
                            }
                        }
                        return(false);
                    }
                }
            }
        }
コード例 #2
0
        /// <summary>
        /// 添加员工
        /// </summary>
        /// <param name="baseModel"></param>
        /// <param name="contactModel"></param>
        /// <param name="bankModel"></param>
        /// <returns></returns>
        public int EmployeeAdd(Employee baseModel, EmployeeContact contactModel, EmployeeBank bankModel, CompanyEmployeeRelation relationModel)
        {
            using (SysEntities db = new SysEntities())
            {
                using (var tran = db.Database.BeginTransaction())
                {
                    try
                    {
                        //创建公司
                        db.Employee.Add(baseModel);
                        db.SaveChanges();

                        //添加联系方式
                        contactModel.EmployeeId = baseModel.Id;
                        db.EmployeeContact.Add(contactModel);

                        //添加银行信息
                        if (bankModel != null)
                        {
                            bankModel.EmployeeId = baseModel.Id;
                            db.EmployeeBank.Add(bankModel);
                        }

                        //企业员工关系
                        relationModel.EmployeeId = baseModel.Id;
                        db.CompanyEmployeeRelation.Add(relationModel);

                        db.SaveChanges();
                        tran.Commit();
                        return(1);
                    }
                    catch (Exception ex)
                    {
                        tran.Rollback();
                        return(0);
                    }
                }
            }
        }