/// <summary> /// 编辑一个部门 /// </summary> /// <param name="validationErrors">返回的错误信息</param> /// <param name="db">数据上下文</param> /// <param name="entity">一个部门</param> /// <returns>是否编辑成功</returns> public bool Edit(ref ValidationErrors validationErrors, SysEntities db, SysDepartment entity) { /* * 不操作 原有 现有 * 增加 原没 现有 * 删除 原有 现没 */ if (entity == null) { return(false); } int count = 1; List <string> addSysDocumentId = new List <string>(); List <string> deleteSysDocumentId = new List <string>(); DataOfDiffrent.GetDiffrent(entity.SysDocumentId.GetIdSort(), entity.SysDocumentIdOld.GetIdSort(), ref addSysDocumentId, ref deleteSysDocumentId); SysDepartment editEntity = repository.Edit(db, entity); if (count == repository.Save(db)) { return(true); } else { validationErrors.Add("编辑部门出错了"); } return(false); }
/// <summary> /// 编辑一个角色 /// </summary> /// <param name="validationErrors">返回的错误信息</param> /// <param name="db">数据上下文</param> /// <param name="entity">一个角色</param> /// <returns>是否编辑成功</returns> public bool Edit(ref ValidationErrors validationErrors, SysEntities db, SysRole entity) { /* * 不操作 原有 现有 * 增加 原没 现有 * 删除 原有 现没 */ if (entity == null) { return(false); } int count = 1; SysRole editEntity = repository.Edit(db, entity); List <string> addSysPersonId = new List <string>(); List <string> deleteSysPersonId = new List <string>(); DataOfDiffrent.GetDiffrent(entity.SysPersonId.GetIdSort(), entity.SysPersonIdOld.GetIdSort(), ref addSysPersonId, ref deleteSysPersonId); if (addSysPersonId != null && addSysPersonId.Count() > 0) { foreach (var item in addSysPersonId) { SysPerson sys = new SysPerson { Id = item }; db.SysPerson.Attach(sys); editEntity.SysPerson.Add(sys); count++; } } if (deleteSysPersonId != null && deleteSysPersonId.Count() > 0) { List <SysPerson> listEntity = new List <SysPerson>(); foreach (var item in deleteSysPersonId) { SysPerson sys = new SysPerson { Id = item }; listEntity.Add(sys); db.SysPerson.Attach(sys); } foreach (SysPerson item in listEntity) { editEntity.SysPerson.Remove(item);//查询数据库 count++; } } if (count == repository.Save(db)) { return(true); } else { validationErrors.Add("编辑角色出错了"); } return(false); }
/// <summary> /// 编辑一个菜单 /// </summary> /// <param name="validationErrors">返回的错误信息</param> /// <param name="db">数据上下文</param> /// <param name="entity">一个菜单</param> /// <returns>是否编辑成功</returns> public bool Edit(ref ValidationErrors validationErrors, SysEntities db, SysMenu entity) { /* * 不操作 原有 现有 * 增加 原没 现有 * 删除 原有 现没 */ if (entity == null) { return(false); } int count = 1; List <string> addSysOperationId = new List <string>(); List <string> deleteSysOperationId = new List <string>(); DataOfDiffrent.GetDiffrent(entity.SysOperationId.GetIdSort(), entity.SysOperationIdOld.GetIdSort(), ref addSysOperationId, ref deleteSysOperationId); List <SysOperation> listEntitySysOperation = new List <SysOperation>(); if (deleteSysOperationId != null && deleteSysOperationId.Count() > 0) { foreach (var item in deleteSysOperationId) { SysOperation sys = new SysOperation { Id = item }; listEntitySysOperation.Add(sys); entity.SysOperation.Add(sys); } } SysMenu editEntity = repository.Edit(db, entity); if (addSysOperationId != null && addSysOperationId.Count() > 0) { foreach (var item in addSysOperationId) { SysOperation sys = new SysOperation { Id = item }; db.SysOperation.Attach(sys); editEntity.SysOperation.Add(sys); count++; } } if (deleteSysOperationId != null && deleteSysOperationId.Count() > 0) { foreach (SysOperation item in listEntitySysOperation) { editEntity.SysOperation.Remove(item); count++; } } if (count == repository.Save(db)) { //修改后重置菜单编码 List <int> flags = new List <int>();//层级 GetMenus2(null, flags); db.SaveChanges(); return(true); } else { validationErrors.Add("编辑菜单出错了"); } return(false); }
/// <summary> /// 设置一个部门 /// </summary> /// <param name="validationErrors">返回的错误信息</param> /// <param name="entity">一个部门</param> /// <returns>是否设置成功</returns> public bool SetSysDepartment(ref ValidationErrors validationErrors, SysDocument entity) { bool bResult = false; int count = 0; using (TransactionScope transactionScope = new TransactionScope()) { try { SysDocument editEntity = repository.GetById(db, entity.Id); List <string> addSysDepartmentId = new List <string>(); List <string> deleteSysDepartmentId = new List <string>(); if (entity.SysDepartmentId != null) { addSysDepartmentId = entity.SysDepartmentId.Split(',').ToList(); } if (entity.SysDepartmentIdOld != null) { deleteSysDepartmentId = entity.SysDepartmentIdOld.Split(',').ToList(); } DataOfDiffrent.GetDiffrent(addSysDepartmentId, deleteSysDepartmentId, ref addSysDepartmentId, ref deleteSysDepartmentId); if (addSysDepartmentId != null && addSysDepartmentId.Count() > 0) { foreach (var item in addSysDepartmentId) { SysDepartment sys = new SysDepartment { Id = item }; db.SysDepartment.Attach(sys); editEntity.SysDepartment.Add(sys); count++; } } if (deleteSysDepartmentId != null && deleteSysDepartmentId.Count() > 0) { List <SysDepartment> listEntity = new List <SysDepartment>(); foreach (var item in deleteSysDepartmentId) { SysDepartment sys = new SysDepartment { Id = item }; listEntity.Add(sys); db.SysDepartment.Attach(sys); } foreach (SysDepartment item in listEntity) { editEntity.SysDepartment.Remove(item);//查询数据库 count++; } } if (count > 0 && count == repository.Save(db)) { transactionScope.Complete(); bResult = true; } else if (count == 0) { validationErrors.Add("数据没有改变"); } } catch (Exception ex) { Transaction.Current.Rollback(); ExceptionsHander.WriteExceptions(ex); validationErrors.Add("编辑出错了。原因" + ex.Message); } } return(bResult); }
/// <summary> /// 编辑一个部门 /// </summary> /// <param name="validationErrors">返回的错误信息</param> /// <param name="db">数据上下文</param> /// <param name="entity">一个部门</param> /// <returns>是否编辑成功</returns> public bool Edit(ref ValidationErrors validationErrors, SysEntities db, SysDepartment entity) { /* * 不操作 原有 现有 * 增加 原没 现有 * 删除 原有 现没 */ if (entity == null) { return(false); } int count = 1; List <string> addSysDocumentId = new List <string>(); List <string> deleteSysDocumentId = new List <string>(); DataOfDiffrent.GetDiffrent(entity.SysDocumentId.GetIdSort(), entity.SysDocumentIdOld.GetIdSort(), ref addSysDocumentId, ref deleteSysDocumentId); List <SysDocument> listEntitySysDocument = new List <SysDocument>(); if (deleteSysDocumentId != null && deleteSysDocumentId.Count() > 0) { foreach (var item in deleteSysDocumentId) { SysDocument sys = new SysDocument { Id = item }; listEntitySysDocument.Add(sys); entity.SysDocument.Add(sys); } } SysDepartment editEntity = repository.Edit(db, entity); if (addSysDocumentId != null && addSysDocumentId.Count() > 0) { foreach (var item in addSysDocumentId) { SysDocument sys = new SysDocument { Id = item }; db.SysDocument.Attach(sys); editEntity.SysDocument.Add(sys); count++; } } if (deleteSysDocumentId != null && deleteSysDocumentId.Count() > 0) { foreach (SysDocument item in listEntitySysDocument) { editEntity.SysDocument.Remove(item); count++; } } if (count == repository.Save(db)) { return(true); } else { validationErrors.Add("编辑部门出错了"); } return(false); }
/// <summary> /// 建立方案保存下一步 /// </summary> /// <param name="validationErrors"></param> /// <param name="entity"></param> /// <returns></returns> public bool EditInst(ref ValidationErrors validationErrors, PREPARE_SCHEME entity) { try { if (entity == null) { return(false); } List <string> addMETERING_STANDARD_DEVICEID = new List <string>(); List <string> deleteMETERING_STANDARD_DEVICEID = new List <string>(); PREPARE_SCHEME prepare = null; if (entity != null) { prepare = repository.GetById(entity.ID); } DataOfDiffrent.GetDiffrent(entity.METERING_STANDARD_DEVICEID.GetIdSort(), entity.METERING_STANDARD_DEVICEIDOld.GetIdSort(), ref addMETERING_STANDARD_DEVICEID, ref deleteMETERING_STANDARD_DEVICEID); PREPARE_SCHEME editEntity = repository.EditInst(db, entity); if (addMETERING_STANDARD_DEVICEID != null && addMETERING_STANDARD_DEVICEID.Count() > 0) { foreach (var item in addMETERING_STANDARD_DEVICEID) { STANDARDCHOICE sys = new STANDARDCHOICE { ID = Result.GetNewId(), PREPARE_SCHEMEID = entity.ID, METERING_STANDARD_DEVICEID = item.Split('*')[0], GROUPS = item.Split('*')[1], TYPE = item.Split('*')[2], NAMES = item.Split('*')[3], CREATEPERSON = entity.CREATEPERSON, CREATETIME = entity.CREATETIME }; //db.STANDARDCHOICE.Attach(sys); editEntity.STANDARDCHOICE.Add(sys); } } if (deleteMETERING_STANDARD_DEVICEID != null && deleteMETERING_STANDARD_DEVICEID.Count() > 0) { foreach (var item in deleteMETERING_STANDARD_DEVICEID) { string ID = item.Split('*')[0]; STANDARDCHOICE sys = new STANDARDCHOICE() { ID = ID }; db.STANDARDCHOICE.Attach(sys); editEntity.STANDARDCHOICE.Remove(sys); db.STANDARDCHOICE.Remove(sys); } } #region 更新了引用方案,需要删除原方案数据所录入的数据 if (prepare != null && !string.IsNullOrWhiteSpace(prepare.SCHEMEID) && prepare.SCHEMEID != entity.SCHEMEID) { List <QUALIFIED_UNQUALIFIED_TEST_ITE> deleteQUALIFIED_UNQUALIFIED_TEST_ITEList = (from f in db.QUALIFIED_UNQUALIFIED_TEST_ITE where f.PREPARE_SCHEMEID == entity.ID select f).ToList(); db.QUALIFIED_UNQUALIFIED_TEST_ITE.RemoveRange(deleteQUALIFIED_UNQUALIFIED_TEST_ITEList); } #endregion repository.Save(db); return(true); } catch (Exception ex) { validationErrors.Add(ex.Message); ExceptionsHander.WriteExceptions(ex); } return(false); }
/// <summary> /// 编辑一个社保种类 /// </summary> /// <param name="validationErrors">返回的错误信息</param> /// <param name="db">数据上下文</param> /// <param name="entity">一个社保种类</param> /// <returns>是否编辑成功</returns> public bool Edit(ref ValidationErrors validationErrors, SysEntities db, InsuranceKind entity) { /* * 不操作 原有 现有 * 增加 原没 现有 * 删除 原有 现没 */ if (entity == null) { return(false); } int count = 1; List <string> addPoliceOperationId = new List <string>(); List <string> deletePoliceOperationId = new List <string>(); DataOfDiffrent.GetDiffrent(entity.PoliceOperationId.GetIdSort(), entity.PoliceOperationIdOld.GetIdSort(), ref addPoliceOperationId, ref deletePoliceOperationId); List <PoliceOperation> listEntityPoliceOperation = new List <PoliceOperation>(); if (deletePoliceOperationId != null && deletePoliceOperationId.Count() > 0) { foreach (var item in deletePoliceOperationId) { PoliceOperation sys = new PoliceOperation { Id = Convert.ToInt32(item) }; listEntityPoliceOperation.Add(sys); entity.PoliceOperation.Add(sys); } } InsuranceKind editEntity = repository.Edit(db, entity); if (addPoliceOperationId != null && addPoliceOperationId.Count() > 0) { foreach (var item in addPoliceOperationId) { PoliceOperation sys = new PoliceOperation { Id = Convert.ToInt32(item) }; db.PoliceOperation.Attach(sys); editEntity.PoliceOperation.Add(sys); count++; } } if (deletePoliceOperationId != null && deletePoliceOperationId.Count() > 0) { foreach (PoliceOperation item in listEntityPoliceOperation) { editEntity.PoliceOperation.Remove(item); count++; } } if (count == repository.Save(db)) { return(true); } else { validationErrors.Add("编辑社保种类出错了"); } return(false); }
/// <summary> /// 编辑一个户口性质 /// </summary> /// <param name="validationErrors">返回的错误信息</param> /// <param name="db">数据上下文</param> /// <param name="entity">一个户口性质</param> /// <returns>是否编辑成功</returns> public bool Edit(ref ValidationErrors validationErrors, SysEntities db, PoliceAccountNature entity) { /* * 不操作 原有 现有 * 增加 原没 现有 * 删除 原有 现没 */ if (entity == null) { return(false); } int count = 1; List <string> addCityId = new List <string>(); List <string> deleteCityId = new List <string>(); DataOfDiffrent.GetDiffrent(entity.CityId.GetIdSort(), entity.CityIdOld.GetIdSort(), ref addCityId, ref deleteCityId); List <City> listEntityCity = new List <City>(); if (deleteCityId != null && deleteCityId.Count() > 0) { foreach (var item in deleteCityId) { City sys = new City { Id = item }; listEntityCity.Add(sys); entity.City.Add(sys); } } PoliceAccountNature editEntity = repository.Edit(db, entity); if (addCityId != null && addCityId.Count() > 0) { foreach (var item in addCityId) { City sys = new City { Id = item }; db.City.Attach(sys); editEntity.City.Add(sys); count++; } } if (deleteCityId != null && deleteCityId.Count() > 0) { foreach (City item in listEntityCity) { editEntity.City.Remove(item); count++; } } if (count == repository.Save(db)) { return(true); } else { validationErrors.Add("编辑户口性质出错了"); } return(false); }
/// <summary> /// 编辑一个标准装置/计量标准器信息 /// </summary> /// <param name="validationErrors">返回的错误信息</param> /// <param name="db">数据上下文</param> /// <param name="entity">一个标准装置/计量标准器信息</param> /// <returns>是否编辑成功</returns> public bool Edit(ref ValidationErrors validationErrors, SysEntities db, METERING_STANDARD_DEVICE entity) { /* * 不操作 原有 现有 * 增加 原没 现有 * 删除 原有 现没 */ if (entity == null) { return(false); } int count = 1; var data = (from m in db.METERING_STANDARD_DEVICE where m.ID == entity.ID select m).FirstOrDefault();//在数据的原始数据 data.NAME = entity.NAME; List <string> addPREPARE_SCHEMEID = new List <string>(); List <string> deletePREPARE_SCHEMEID = new List <string>(); DataOfDiffrent.GetDiffrent(entity.PREPARE_SCHEMEID.GetIdSort(), entity.PREPARE_SCHEMEIDOld.GetIdSort(), ref addPREPARE_SCHEMEID, ref deletePREPARE_SCHEMEID); List <PREPARE_SCHEME> listEntityPREPARE_SCHEME = new List <PREPARE_SCHEME>(); if (deletePREPARE_SCHEMEID != null && deletePREPARE_SCHEMEID.Count() > 0) { foreach (var item in deletePREPARE_SCHEMEID) { PREPARE_SCHEME sys = new PREPARE_SCHEME { ID = item }; listEntityPREPARE_SCHEME.Add(sys); entity.PREPARE_SCHEME.Add(sys); } } METERING_STANDARD_DEVICE editEntity = repository.Edit(db, entity); if (addPREPARE_SCHEMEID != null && addPREPARE_SCHEMEID.Count() > 0) { foreach (var item in addPREPARE_SCHEMEID) { PREPARE_SCHEME sys = new PREPARE_SCHEME { ID = item }; db.PREPARE_SCHEME.Attach(sys); editEntity.PREPARE_SCHEME.Add(sys); count++; } } if (deletePREPARE_SCHEMEID != null && deletePREPARE_SCHEMEID.Count() > 0) { foreach (PREPARE_SCHEME item in listEntityPREPARE_SCHEME) { editEntity.PREPARE_SCHEME.Remove(item); count++; } } if (count == repository.Save(db)) { return(true); } else { validationErrors.Add("编辑标准装置/计量标准器信息出错了"); } return(false); }
/// <summary> /// 编辑一个预备方案 /// </summary> /// <param name="validationErrors">返回的错误信息</param> /// <param name="db">数据上下文</param> /// <param name="entity">一个预备方案</param> /// <returns>是否编辑成功</returns> public bool Edit(ref ValidationErrors validationErrors, SysEntities db, PREPARE_SCHEME entity) { /* * 不操作 原有 现有 * 增加 原没 现有 * 删除 原有 现没 */ if (entity == null) { return(false); } int count = 1; List <string> addMETERING_STANDARD_DEVICEID = new List <string>(); List <string> deleteMETERING_STANDARD_DEVICEID = new List <string>(); DataOfDiffrent.GetDiffrent(entity.METERING_STANDARD_DEVICEID.GetIdSort(), entity.METERING_STANDARD_DEVICEIDOld.GetIdSort(), ref addMETERING_STANDARD_DEVICEID, ref deleteMETERING_STANDARD_DEVICEID); List <METERING_STANDARD_DEVICE> listEntityMETERING_STANDARD_DEVICE = new List <METERING_STANDARD_DEVICE>(); if (deleteMETERING_STANDARD_DEVICEID != null && deleteMETERING_STANDARD_DEVICEID.Count() > 0) { foreach (var item in deleteMETERING_STANDARD_DEVICEID) { METERING_STANDARD_DEVICE sys = new METERING_STANDARD_DEVICE { ID = item }; listEntityMETERING_STANDARD_DEVICE.Add(sys); entity.METERING_STANDARD_DEVICE.Add(sys); } } PREPARE_SCHEME editEntity = repository.Edit(db, entity); if (addMETERING_STANDARD_DEVICEID != null && addMETERING_STANDARD_DEVICEID.Count() > 0) { foreach (var item in addMETERING_STANDARD_DEVICEID) { METERING_STANDARD_DEVICE sys = new METERING_STANDARD_DEVICE { ID = item }; db.METERING_STANDARD_DEVICE.Attach(sys); editEntity.METERING_STANDARD_DEVICE.Add(sys); count++; } } if (deleteMETERING_STANDARD_DEVICEID != null && deleteMETERING_STANDARD_DEVICEID.Count() > 0) { foreach (METERING_STANDARD_DEVICE item in listEntityMETERING_STANDARD_DEVICE) { editEntity.METERING_STANDARD_DEVICE.Remove(item); count++; } } if (count == repository.Save(db)) { return(true); } else { validationErrors.Add("编辑预备方案出错了"); } return(false); }