/// <summary> /// 审核通过新建数据 /// </summary> /// <param name="companyID">企业ID</param> /// <param name="cityID">缴纳地ID</param> /// <returns></returns> public bool PassAdd(SysEntities db, int companyID, string cityID) { try { int operateType = (int)Common.OperateType.添加; int operateState = (int)Common.AuditStatus.待处理; //DateTime dtnow = DateTime.Now; var updI = db.CRM_Company_Insurance_Audit.Where(c => c.CRM_Company_ID == companyID && c.City == cityID && c.OperateType == operateType && c.OperateStatus == operateState && c.OperateNode == 2); var updPI = db.CRM_Company_PoliceInsurance_Audit.Where(c => c.CRM_Company_ID == companyID && c.City == cityID && c.OperateType == operateType && c.OperateStatus == operateState && c.OperateNode == 2); List <CRM_Company_Insurance> ListI = new List <CRM_Company_Insurance>(); List <CRM_Company_PoliceInsurance> ListPI = new List <CRM_Company_PoliceInsurance>(); foreach (var modelI in updI) { //设置成功 modelI.OperateStatus = (int)Common.AuditStatus.成功; //数据复制到正式表 CRM_Company_Insurance entityI = new CRM_Company_Insurance(); entityI.Account = modelI.Account; entityI.City = modelI.City; entityI.CreatePerson = modelI.CreatePerson; entityI.CreateTime = modelI.CreateTime; entityI.CRM_Company_ID = companyID; entityI.InsuranceKind = modelI.InsuranceKind; entityI.State = modelI.State; ListI.Add(entityI); } foreach (var modelPI in updPI) { //设置成功 modelPI.OperateStatus = (int)Common.AuditStatus.成功; //数据复制到正式表 CRM_Company_PoliceInsurance entityPI = new CRM_Company_PoliceInsurance(); entityPI.City = modelPI.City; entityPI.CreatePerson = modelPI.CreatePerson; entityPI.CreateTime = modelPI.CreateTime; entityPI.CRM_Company_ID = companyID; entityPI.InsuranceKind = modelPI.InsuranceKind; entityPI.PoliceInsurance = modelPI.PoliceInsurance; entityPI.State = modelPI.State; ListPI.Add(entityPI); } db.CRM_Company_Insurance.AddRange(ListI); db.CRM_Company_PoliceInsurance.AddRange(ListPI); db.SaveChanges(); return(true); } catch { return(false); } }
/// <summary> /// 修改企业社保信息 /// </summary> /// <param name="db"></param> /// <param name="model">社保信息实体</param> /// <param name="userID">操作人ID</param> /// <param name="userName">操作人姓名</param> /// <param name="branchID">所属分支机构</param> /// <returns></returns> public bool UpdateCRM_Company_Insurance(SysEntities db, CompanyInsurance model, int userID, string userName, int branchID) { try { DateTime dtnow = DateTime.Now; List <CRM_Company_Insurance_Audit> ListI = new List <CRM_Company_Insurance_Audit>(); CRM_Company_Insurance_Audit ModelI = new CRM_Company_Insurance_Audit(); List <CRM_Company_PoliceInsurance_Audit> ListPI = new List <CRM_Company_PoliceInsurance_Audit>(); CRM_Company_PoliceInsurance_Audit ModelPI = new CRM_Company_PoliceInsurance_Audit(); string[] Accounts = model.Account1 == null ? null : model.Account1.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries); string[] Polices1 = model.PoliceID1 == null ? null : model.PoliceID1.Split(new char[] { ';' }, StringSplitOptions.RemoveEmptyEntries); string[] Polices2 = model.PoliceID2 == null ? null : model.PoliceID2.Split(new char[] { ';' }, StringSplitOptions.RemoveEmptyEntries); List <CRM_Company_Insurance> ListI_Old = db.CRM_Company_Insurance.Where(c => c.City == model.CityId && c.CRM_Company_ID == model.CRM_Company_ID).OrderBy(c => c.InsuranceKind).ToList(); List <CRM_Company_PoliceInsurance> ListPI_Old = db.CRM_Company_PoliceInsurance.Where(c => c.City == model.CityId && c.CRM_Company_ID == model.CRM_Company_ID).OrderBy(c => c.InsuranceKind).ToList(); //公积金账户 if (!string.IsNullOrEmpty(model.Account2)) { ModelI = new CRM_Company_Insurance_Audit(); ModelI.Account = model.Account2; ModelI.InsuranceKind = (int)Common.EmployeeAdd_InsuranceKindId.公积金; ModelI.CRM_Company_ID = model.CRM_Company_ID; ModelI.City = model.CityId; CRM_Company_Insurance oldGGJ = ListI_Old.Where(c => c.InsuranceKind == ModelI.InsuranceKind).ToList().FirstOrDefault(); if (oldGGJ != null) { ModelI.CRM_Company_Insurance_ID = oldGGJ.ID; } ModelI.State = Common.Status.启用.ToString(); ModelI.CreateTime = dtnow; ModelI.CreateUserID = userID; ModelI.CreatePerson = userName; ModelI.OperateStatus = (int)Common.AuditStatus.待处理; //待处理 ModelI.OperateNode = 2; //质控 ModelI.BranchID = branchID; ModelI.OperateType = (int)Common.OperateType.修改; ListI.Add(ModelI); } //社保账户 if (!string.IsNullOrEmpty(model.Account1)) { foreach (string acc in Accounts) { string[] account = acc.Split(new char[] { ':' }, StringSplitOptions.RemoveEmptyEntries); if (account.Length == 2 && !string.IsNullOrEmpty(account[1])) { Common.EmployeeAdd_InsuranceKindId getType = (Common.EmployeeAdd_InsuranceKindId)Enum.Parse(typeof(Common.EmployeeAdd_InsuranceKindId), account[0]); ModelI = new CRM_Company_Insurance_Audit(); ModelI.Account = account[1]; ModelI.InsuranceKind = (int)getType; ModelI.CRM_Company_ID = model.CRM_Company_ID; ModelI.City = model.CityId; CRM_Company_Insurance oldInsurance = ListI_Old.Where(c => c.InsuranceKind == ModelI.InsuranceKind).ToList().FirstOrDefault(); if (oldInsurance != null) { ModelI.CRM_Company_Insurance_ID = oldInsurance.ID; } //ModelI.CRM_Company_Insurance_ID = ListI_Old.Where(c => c.InsuranceKind == ModelI.InsuranceKind).ToList().FirstOrDefault().ID; ModelI.State = Common.Status.启用.ToString(); ModelI.CreateTime = dtnow; ModelI.CreateUserID = userID; ModelI.CreatePerson = userName; ModelI.OperateStatus = (int)Common.AuditStatus.待处理; //待处理 ModelI.OperateNode = 2; //质控 ModelI.BranchID = branchID; ModelI.OperateType = (int)Common.OperateType.修改; ListI.Add(ModelI); } } } //公积金政策 if (!string.IsNullOrEmpty(model.PoliceID2)) { foreach (string po in Polices2) { ModelPI = new CRM_Company_PoliceInsurance_Audit(); ModelPI.PoliceInsurance = Convert.ToInt32(po); ModelPI.InsuranceKind = (int)Common.EmployeeAdd_InsuranceKindId.公积金; ModelPI.CRM_Company_ID = model.CRM_Company_ID; ModelPI.City = model.CityId; CRM_Company_PoliceInsurance oldPiGGJ = ListPI_Old.Where(c => c.InsuranceKind == ModelPI.InsuranceKind).ToList().FirstOrDefault(); if (oldPiGGJ != null) { ModelPI.CRM_Company_PoliceInsurance_ID = oldPiGGJ.ID; } //ModelPI.CRM_Company_PoliceInsurance_ID = ListPI_Old.Where(c => c.InsuranceKind == ModelPI.InsuranceKind).ToList().FirstOrDefault().ID; ModelPI.State = Common.Status.启用.ToString(); ModelPI.CreateTime = dtnow; ModelPI.CreateUserID = userID; ModelPI.CreatePerson = userName; ModelPI.OperateStatus = (int)Common.AuditStatus.待处理; //待处理 ModelPI.OperateNode = 2; //质控 ModelPI.BranchID = branchID; ModelPI.OperateType = (int)Common.OperateType.修改; ListPI.Add(ModelPI); } } //工伤政策 if (!string.IsNullOrEmpty(model.PoliceID1)) { foreach (string po in Polices1) { ModelPI = new CRM_Company_PoliceInsurance_Audit(); ModelPI.PoliceInsurance = Convert.ToInt32(po); ModelPI.InsuranceKind = (int)Common.EmployeeAdd_InsuranceKindId.工伤; ModelPI.CRM_Company_ID = model.CRM_Company_ID; ModelPI.City = model.CityId; CRM_Company_PoliceInsurance oldPiGS = ListPI_Old.Where(c => c.InsuranceKind == ModelPI.InsuranceKind).ToList().FirstOrDefault(); if (oldPiGS != null) { ModelPI.CRM_Company_PoliceInsurance_ID = oldPiGS.ID; } ModelPI.State = Common.Status.启用.ToString(); ModelPI.CreateTime = dtnow; ModelPI.CreateUserID = userID; ModelPI.CreatePerson = userName; ModelPI.OperateStatus = (int)Common.AuditStatus.待处理; //待处理 ModelPI.OperateNode = 2; //质控 ModelPI.BranchID = branchID; ModelPI.OperateType = (int)Common.OperateType.修改; ListPI.Add(ModelPI); } } db.CRM_Company_Insurance_Audit.AddRange(ListI); db.CRM_Company_PoliceInsurance_Audit.AddRange(ListPI); foreach (var Iold in ListI_Old) { Iold.State = Common.Status.修改中.ToString(); } foreach (var PIold in ListPI_Old) { PIold.State = Common.Status.修改中.ToString(); } db.SaveChanges(); return(true); } catch { return(false); } }