/// <summary> /// 小区省份新增 /// </summary> /// <param name="dto"></param> /// <returns></returns> public bool AddAreaRegion(AreaOperateDTO dto) { bool blResult = false; using (var tcdmse = new Entities.TCDMS_MasterDataEntities()) { foreach (var a in dto.RegionIDList) { var pp = tcdmse.master_AreaRegionInfo.Where(p => p.AreaID == dto.AreaID && p.RegionID == a).FirstOrDefault(); if (pp == null) { master_AreaRegionInfo addarearegion = new master_AreaRegionInfo(); addarearegion.AreaID = dto.AreaID; addarearegion.RegionID = a; tcdmse.master_AreaRegionInfo.Add(addarearegion); } } blResult = tcdmse.SaveChanges() > 0; blResult = true; } return(blResult); }
/// <summary> /// 新增角色信息 /// </summary> /// <returns></returns> public bool AddRole(RoleOperateDTO dto) { var result = false; using (var tcdmse = new Entities.TCDMS_MasterDataEntities()) { var pp = tcdmse.master_RoleInfo.AsNoTracking().Where(p => p.RoleName == dto.RoleName).FirstOrDefault(); if (pp != null) { throw new Exception("角色名不能重复!"); } var newrole = new master_RoleInfo(); newrole = Mapper.Map <RoleOperateDTO, master_RoleInfo>(dto); tcdmse.master_RoleInfo.Add(newrole); tcdmse.SaveChanges(); if (dto.RoleAuthority != null && dto.RoleAuthority.Count > 0) { for (int i = 0; i < dto.RoleAuthority.Count; i++) { var newauth = new master_RoleAuthority() { RoleButtonAuthority = dto.RoleAuthority[i].RoleButtonAuthority, StructureID = dto.RoleAuthority[i].StructureID, RoleID = newrole.RoleID }; tcdmse.master_RoleAuthority.Add(newauth); } } result = tcdmse.SaveChanges() >= 0; } return(result); }
/// <summary> /// 用户信息删除 /// </summary> /// <param name="dto"></param> /// <returns></returns> public bool DeleteUser(UserOperate dto) { bool blResult = false; using (var tcdmse = new Entities.TCDMS_MasterDataEntities()) { var pp = tcdmse.master_UserInfo.Where(p => p.UserID == dto.UserID).FirstOrDefault(); if (pp == null) { throw new Exception("此条信息不存在!"); } //用户权限 var ww = tcdmse.master_UserCustomerAuthority.Where(w => w.UserID == pp.UserID); tcdmse.master_UserCustomerAuthority.RemoveRange(ww); //用户角色 pp.master_RoleInfo.Clear(); //关联经销商 pp.master_DistributorInfo.Clear(); //用户 tcdmse.master_UserInfo.Remove(pp); // 记录日志 this.AddLog(tcdmse, new LogData { CurrentLogType = LogType.DELETE, LogDetails = "删除用户" + pp.FullName, OpratorName = dto.ModifyUser }); blResult = tcdmse.SaveChanges() > 0; } return(blResult); }
/// <summary> /// 新增部门信息 /// </summary> /// <returns></returns> public bool AddDepartment(DepartmentOperateDTO dto) { var result = false; using (var tcdmse = new Entities.TCDMS_MasterDataEntities()) { var pp = tcdmse.master_DepartmentInfo.AsNoTracking().Where(p => p.DepartParentID == dto.DepartParentID && p.DepartName == dto.DepartName).FirstOrDefault(); if (pp != null) { throw new Exception("部门名称不能重复!"); } var newdepart = new master_DepartmentInfo(); newdepart = Mapper.Map <DepartmentOperateDTO, master_DepartmentInfo>(dto); tcdmse.master_DepartmentInfo.Add(newdepart); // 记录日志 this.AddLog(tcdmse, new LogData { CurrentLogType = LogType.ADD, LogDetails = "新增部门" + dto.DepartName, OpratorName = dto.CreateUser }); result = tcdmse.SaveChanges() > 0; newdepart.DepartPath = dto.DepartPath + newdepart.DepartID + "/"; tcdmse.SaveChanges(); } return(result); }
/// <summary> /// 新增经销商公告授权 /// </summary> /// <returns></returns> public bool AddDistributorAnnounceAuthority(DistributorAnnounceAuthorityOperateDTO dto) { bool result = false; using (var tcdmse = new Entities.TCDMS_MasterDataEntities()) { var pp = tcdmse.master_DistributorInfo.AsNoTracking().Where(p => p.DistributorID == dto.DistributorID).FirstOrDefault(); if (pp == null) { pp = tcdmse.master_DistributorInfo.Where(p => p.DistributorName == dto.DistributorName).FirstOrDefault(); if (pp == null) { throw new Exception("经销商不存在!"); } } var remove = tcdmse.master_DistributorADInfo.Where(p => p.DistributorID == pp.DistributorID); tcdmse.master_DistributorADInfo.RemoveRange(remove); if (dto.ProductLineIDList.Count > 0) { foreach (var id in dto.ProductLineIDList) { master_DistributorADInfo newitem = new master_DistributorADInfo(); newitem.DistributorID = pp.DistributorID; newitem.ProductLineID = id; newitem.CreateTime = dto.CreateTime; newitem.CreateUser = dto.CreateUser; tcdmse.master_DistributorADInfo.Add(newitem); } } result = tcdmse.SaveChanges() > 0; } return(result); }
/// <summary> /// 删除客户管理员 /// </summary> /// <param name="dto"></param> /// <returns></returns> public bool DeleteCustomerAdmin(UserOperate dto) { bool blResult = false; using (var tcdmse = new Entities.TCDMS_MasterDataEntities()) { var pp = tcdmse.master_UserInfo.Where(p => p.UserID == dto.UserID).FirstOrDefault(); if (pp == null) { throw new Exception("此条信息不存在!"); } pp.ModifyUser = dto.ModifyUser; pp.ModifyTime = dto.ModifyTime; var aui = pp.master_AreaInfo.Where(g => g.AreaID == dto.AreaID).ToList(); if (aui.Count() > 0) { aui.ForEach(g => { pp.master_AreaInfo.Remove(g); }); } blResult = tcdmse.SaveChanges() > 0; } return(blResult); }
/// <summary> /// 删除经销商运输方式 /// </summary> /// <param name="dto"></param> /// <returns></returns> public bool DeleteDistributorTransportAuthority(DistributorAuthorityOperateDTO dto) { bool blResult = false; using (var tcdmse = new Entities.TCDMS_MasterDataEntities()) { var qq = tcdmse.master_DistributorTransport.Where(p => p.DistributorTransportID == dto.DistributorTransportID).FirstOrDefault(); var mm = qq.master_DistributorInfo.DistributorName; var ww = qq.master_TransportInfo.TransportName; tcdmse.master_DistributorTransport.Remove(qq); // 记录日志 this.AddLog(tcdmse, new LogData { CurrentLogType = LogType.DELETE, LogDetails = "删除授权运输方式 经销商:" + mm + "授权运输方式:" + ww, OpratorName = dto.ModifyUser }); blResult = tcdmse.SaveChanges() > 0; } return(blResult); }
/// <summary> /// 删除经销商产品线区域 /// </summary> /// <param name="dto"></param> /// <returns></returns> public bool DeleteDistributorProductLineRegionAuthority(DistributorAuthorityOperateDTO dto) { bool blResult = false; using (var tcdmse = new Entities.TCDMS_MasterDataEntities()) { var qq = tcdmse.master_DistributorRegionInfo.Where(p => p.DistributorRegionID == dto.DistributorRegionID).FirstOrDefault(); var mm = qq.master_DistributorProductLineInfo.master_DistributorInfo.DistributorName; var ww = tcdmse.dict_RegionInfo.Where(w => w.RegionID == qq.RegionID).Select(s => s.RegionName).FirstOrDefault(); tcdmse.master_DistributorRegionInfo.Remove(qq); // 记录日志 this.AddLog(tcdmse, new LogData { CurrentLogType = LogType.DELETE, LogDetails = "删除授权区域 经销商:" + mm + "授权区域:" + ww, OpratorName = dto.ModifyUser }); blResult = tcdmse.SaveChanges() > 0; } return(blResult); }
/// <summary> /// 授权经销商产品线 /// </summary> /// <param name="dto"></param> /// <returns></returns> public bool DistributorProductLineAuthority(DistributorAuthorityOperateDTO dto) { bool blResult = false; using (var tcdmse = new Entities.TCDMS_MasterDataEntities()) { var pp = tcdmse.master_DistributorInfo.Where(p => p.DistributorID == dto.DistributorID).FirstOrDefault(); if (pp == null) { throw new Exception("该经销商已不存在"); } foreach (var line in dto.ProductLineRegion) { master_DistributorProductLineInfo displine = new master_DistributorProductLineInfo(); displine.DistributorID = pp.DistributorID; displine.ProductLineID = line.ProductLineID; tcdmse.master_DistributorProductLineInfo.Add(displine); var qq = tcdmse.master_ProductLine.Where(q => q.ProductLineID == line.ProductLineID).Select(s => s.ProductLineName).FirstOrDefault(); // 记录日志 this.AddLog(tcdmse, new LogData { CurrentLogType = LogType.ADD, LogDetails = "经销商授权 经销商:" + pp.DistributorName + "授权产品线:" + qq, OpratorName = dto.CreateUser }); } blResult = tcdmse.SaveChanges() > 0; } return(blResult); }
/// <summary> /// 删除附件 /// </summary> /// <param name="dtolist"></param> /// <returns></returns> public bool DeleteAttachFile(AttachFileOperateDTO dto) { bool result = false; using (var tcdmse = new Entities.TCDMS_MasterDataEntities()) { if (dto.AttachFileID != null) { var pp = tcdmse.common_AttachFileInfo.Where(p => p.AttachFileID == dto.AttachFileID).FirstOrDefault(); if (pp == null) { throw new Exception("此条信息不存在!"); } tcdmse.common_AttachFileInfo.Remove(pp); } else if ((dto.BelongModule != null) && (!string.IsNullOrEmpty(dto.BelongModulePrimaryKey))) { var pp = tcdmse.common_AttachFileInfo.Where(p => p.BelongModule == dto.BelongModule && p.BelongModulePrimaryKey == dto.BelongModulePrimaryKey); tcdmse.common_AttachFileInfo.RemoveRange(pp); } else if (dto.BelongModule != null) { var pp = tcdmse.common_AttachFileInfo.Where(p => p.BelongModule == dto.BelongModule); tcdmse.common_AttachFileInfo.RemoveRange(pp); } result = tcdmse.SaveChanges() > 0; } return(result); }
/// <summary> /// 删除经销商信息 /// </summary> /// <returns></returns> public bool DeleteDistributor(DistributorOperateDTO dto) { bool result = false; using (var tcdmse = new Entities.TCDMS_MasterDataEntities()) { var pp = tcdmse.master_DistributorInfo.Where(p => p.DistributorID == dto.DistributorID).FirstOrDefault(); if (pp == null) { throw new Exception("此条信息不存在!"); } tcdmse.master_DistributorInfo.Remove(pp); // 记录日志 this.AddLog(tcdmse, new LogData { CurrentLogType = LogType.DELETE, LogDetails = "删除经销商" + pp.DistributorName, OpratorName = dto.ModifyUser }); result = tcdmse.SaveChanges() > 0; } return(result); }
/// <summary> /// 修改部门信息 /// </summary> /// <returns></returns> public bool UpdateDepartment(DepartmentOperateDTO dto) { var result = false; using (var tcdmse = new Entities.TCDMS_MasterDataEntities()) { var pp = tcdmse.master_DepartmentInfo.Where(p => p.DepartID == dto.DepartID).FirstOrDefault(); if (pp == null) { throw new Exception("此条信息不存在"); } var ss = tcdmse.master_DepartmentInfo.AsNoTracking().Where(p => p.DepartParentID == dto.DepartParentID && p.DepartName == dto.DepartName && p.DepartID != dto.DepartID).FirstOrDefault(); if (ss != null) { throw new Exception("部门名称不能重复!"); } dto.CreateTime = pp.CreateTime; dto.CreateUser = pp.CreateUser; dto.DepartPath = pp.DepartPath; Mapper.Map <DepartmentOperateDTO, master_DepartmentInfo>(dto, pp); result = tcdmse.SaveChanges() > 0; } return(result); }
/// <summary> /// 停/启用经销商 /// </summary> /// <returns></returns> public bool StartOrStopDistributor(DistributorOperateDTO dto) { bool result = false; using (var tcdmse = new Entities.TCDMS_MasterDataEntities()) { var pp = tcdmse.master_DistributorInfo.Where(p => p.DistributorID == dto.DistributorID).FirstOrDefault(); if (pp == null) { throw new Exception("此条信息不存在!"); } pp.IsActive = dto.IsActive; pp.NoActiveTime = dto.NoActiveTime; pp.NoActiveReason = dto.NoActiveReason; pp.ModifyTime = dto.ModifyTime; pp.ModifyUser = dto.ModifyUser; var qq = pp.master_UserInfo; if (dto.IsActive == true) { foreach (var q in qq) { q.IsActive = dto.IsActive; } } else { foreach (var q in qq) { if (q.master_DistributorInfo.Where(w => w.IsActive == true).Count() == 0) { q.IsActive = dto.IsActive; } } } if (dto.IsActive == false) { // 记录日志 this.AddLog(tcdmse, new LogData { CurrentLogType = LogType.UNENABLE, LogDetails = "停用经销商" + pp.DistributorName, OpratorName = dto.ModifyUser }); } result = tcdmse.SaveChanges() > 0; } return(result); }
/// <summary> /// 新增反馈信息 /// </summary> /// <param name="dto"></param> /// <returns></returns> public int AddFeedback(FeedbackOperateDTO dto) { int result = -1; using (var tcdmse = new Entities.TCDMS_MasterDataEntities()) { master_FeedbackStat newitem = new master_FeedbackStat(); newitem = Mapper.Map <FeedbackOperateDTO, master_FeedbackStat>(dto); tcdmse.master_FeedbackStat.Add(newitem); tcdmse.SaveChanges(); result = newitem.FeedbackStatID; } return(result); }
/// <summary> /// 新增提醒管理 /// </summary> /// <returns></returns> public bool AddWarningInfo(WarningDTO dto) { bool result = false; using (var tcdmse = new Entities.TCDMS_MasterDataEntities()) { common_WarningInfo warning = new common_WarningInfo(); Mapper.Map <WarningDTO, common_WarningInfo>(dto, warning); tcdmse.common_WarningInfo.Add(warning); result = tcdmse.SaveChanges() > 0; } return(result); }
/// <summary> /// 删除一条提醒信息 /// </summary> /// <returns></returns> public bool DeleteWarningInfo(WarningSearchDTO dto) { bool result = false; using (var tcdmse = new Entities.TCDMS_MasterDataEntities()) { var pp = tcdmse.common_WarningInfo.Where(p => p.WarningID == dto.WarningID).FirstOrDefault(); if (pp == null) { throw new Exception("此条信息不存在!"); } tcdmse.common_WarningInfo.Remove(pp); result = tcdmse.SaveChanges() > 0; } return(result); }
/// <summary> /// 新增多个附件 /// </summary> /// <param name="dtolist"></param> /// <returns></returns> public bool AddAttachFileList(List <AttachFileOperateDTO> dtolist) { bool result = false; using (var tcdmse = new Entities.TCDMS_MasterDataEntities()) { if (dtolist.Count > 0) { List <common_AttachFileInfo> newitemlist = new List <common_AttachFileInfo>(); Mapper.Map <List <AttachFileOperateDTO>, List <common_AttachFileInfo> >(dtolist, newitemlist); tcdmse.common_AttachFileInfo.AddRange(newitemlist); result = tcdmse.SaveChanges() > 0; } } return(result); }
/// <summary> /// 新增行政区划 /// </summary> /// <param name="dto"></param> /// <returns></returns> public bool AddRegion(RegionOperateDTO dto) { var result = false; using (var tcdmse = new Entities.TCDMS_MasterDataEntities()) { var dumplicated = tcdmse.dict_RegionInfo.AsNoTracking().Where(p => p.RegionPID == dto.RegionPID && p.RegionName == dto.RegionName).FirstOrDefault(); if (dumplicated != null) { throw new Exception("新增行政区域不可同名!"); } var newregion = new dict_RegionInfo(); newregion = Mapper.Map <RegionOperateDTO, dict_RegionInfo>(dto); tcdmse.dict_RegionInfo.Add(newregion); result = tcdmse.SaveChanges() > 0; } return(result); }
/// <summary> /// 修改反馈信息(修改状态) /// </summary> /// <param name="dto"></param> /// <returns></returns> public bool UpdateFeedback(FeedbackOperateDTO dto) { bool result = false; using (var tcdmse = new Entities.TCDMS_MasterDataEntities()) { var pp = tcdmse.master_FeedbackStat.Where(p => p.FeedbackStatID == dto.FeedbackStatID).FirstOrDefault(); if (pp == null) { throw new Exception("此条信息不存在!"); } pp.FeedbackStaus = dto.FeedbackStaus; pp.DealUser = dto.DealUser; pp.DealDatetime = dto.DealDatetime; result = tcdmse.SaveChanges() > 0; } return(result); }
/// <summary> /// 修改经销商信息 /// </summary> /// <returns></returns> public bool UpdateDistributor(DistributorOperateDTO dto) { bool result = false; using (var tcdmse = new Entities.TCDMS_MasterDataEntities()) { var pp = tcdmse.master_DistributorInfo.Where(p => p.DistributorID == dto.DistributorID).FirstOrDefault(); if (pp == null) { throw new Exception("此条信息不存在!"); } dto.IsActive = pp.IsActive; dto.CreateTime = pp.CreateTime; dto.CreateUser = pp.CreateUser; Mapper.Map <DistributorOperateDTO, master_DistributorInfo>(dto, pp); result = tcdmse.SaveChanges() > 0; } return(result); }
/// <summary> /// 授权经销商订货权限 /// </summary> /// <param name="dto"></param> /// <returns></returns> public bool DistributorOrderGoodsAuthority(DistributorAuthorityOperateDTO dto) { bool blResult = false; using (var tcdmse = new Entities.TCDMS_MasterDataEntities()) { var pp = tcdmse.master_DistributorInfo.Where(p => p.DistributorID == dto.DistributorID).FirstOrDefault(); if (pp == null) { throw new Exception("该经销商已不存在"); } pp.IsOrderGoods = dto.IsOrderGoods; pp.ModifyTime = dto.ModifyTime; pp.ModifyUser = dto.ModifyUser; blResult = tcdmse.SaveChanges() > 0; } return(blResult); }
/// <summary> /// 经销商类别修改 /// </summary> /// <returns></returns> public bool UpdateDistributorType(DistributorTypeOperateDTO dto) { bool blResult = false; using (var tcdmse = new Entities.TCDMS_MasterDataEntities()) { var pp = tcdmse.master_DistributorType.Where(p => p.DistributorTypeID == dto.DistributorTypeID).FirstOrDefault(); if (pp == null) { throw new Exception("此条信息不存在!"); } pp.DistributorTypeName = dto.DistributorTypeName; pp.ModifyUser = dto.ModifyUser; pp.ModifyTime = dto.ModifyTime; blResult = tcdmse.SaveChanges() > 0; } return(blResult); }
/// <summary> /// 修改模块管理员邮箱 /// </summary> /// <param name="dto"></param> /// <returns></returns> public bool UpdateModularAdmin(UserOperate dto) { bool blResult = false; using (var tcdmse = new Entities.TCDMS_MasterDataEntities()) { var pp = tcdmse.master_UserInfo.Where(p => p.UserID == dto.UserID).FirstOrDefault(); if (pp == null) { throw new Exception("此条信息不存在!"); } pp.ModifyUser = dto.ModifyUser; pp.ModifyTime = dto.ModifyTime; pp.Email = dto.Email; blResult = tcdmse.SaveChanges() > 0; } return(blResult); }
/// <summary> /// 大小区删除 /// </summary> /// <param name="dto"></param> /// <returns></returns> public bool DeleteArea(AreaOperateDTO dto) { bool blResult = false; using (var tcdmse = new Entities.TCDMS_MasterDataEntities()) { var pp = tcdmse.master_AreaInfo.Where(p => p.AreaID == dto.AreaID).FirstOrDefault(); if (pp != null) { var mm = tcdmse.master_DistributorRegionInfo.AsNoTracking().Where(m => m.AreaID == pp.AreaID || m.DistrictID == pp.AreaID).FirstOrDefault(); if (mm != null) { throw new Exception("此条信息已使用不可删除!"); } var qq = tcdmse.master_AreaInfo.Where(q => q.AreaPID == pp.AreaID); foreach (var q in qq) { var ww = tcdmse.master_AreaRegionInfo.Where(s => s.AreaID == q.AreaID); tcdmse.master_AreaRegionInfo.RemoveRange(ww); } var qw = tcdmse.master_AreaRegionInfo.Where(s => s.AreaID == pp.AreaID); tcdmse.master_AreaRegionInfo.RemoveRange(qw); tcdmse.master_AreaInfo.RemoveRange(qq); tcdmse.master_AreaInfo.Remove(pp); // 记录日志 this.AddLog(tcdmse, new LogData { CurrentLogType = LogType.DELETE, LogDetails = "删除大小区" + pp.AreaName, OpratorName = dto.ModifyUser }); } blResult = tcdmse.SaveChanges() > 0; } return(blResult); }
/// <summary> /// 大小区新增 /// </summary> /// <param name="dto"></param> /// <returns></returns> public bool AddArea(AreaOperateDTO dto) { bool blResult = false; using (var tcdmse = new Entities.TCDMS_MasterDataEntities()) { if (dto.AreaPID == null) { var dumplicated = tcdmse.master_AreaInfo.AsNoTracking().Where(p => p.DepartID == dto.DepartID && p.AreaPID == null && p.AreaName == dto.AreaName).FirstOrDefault(); if (dumplicated != null) { throw new Exception("相同部门下大区名称不可重复!"); } } else { var dumplicated = tcdmse.master_AreaInfo.AsNoTracking().Where(p => p.AreaPID == dto.AreaPID && p.AreaName == dto.AreaName).FirstOrDefault(); if (dumplicated != null) { throw new Exception("相同大区下小区名称不可重复!"); } } master_AreaInfo addarea = new master_AreaInfo(); Mapper.Map <AreaOperateDTO, master_AreaInfo>(dto, addarea); tcdmse.master_AreaInfo.Add(addarea); // 记录日志 this.AddLog(tcdmse, new LogData { CurrentLogType = LogType.ADD, LogDetails = "新增大小区" + dto.AreaName, OpratorName = dto.CreateUser }); blResult = tcdmse.SaveChanges() > 0; } return(blResult); }
/// <summary> /// 修改角色信息 /// </summary> /// <returns></returns> public bool UpdateRole(RoleOperateDTO dto) { var result = false; using (var tcdmse = new Entities.TCDMS_MasterDataEntities()) { var pp = tcdmse.master_RoleInfo.Where(p => p.RoleID == dto.RoleID).FirstOrDefault(); if (pp == null) { throw new Exception("此条信息不存在"); } var ss = tcdmse.master_RoleInfo.AsNoTracking().Where(p => p.RoleName == dto.RoleName && p.RoleID != dto.RoleID).FirstOrDefault(); if (ss != null) { throw new Exception("角色名不能重复!"); } dto.CreateTime = pp.CreateTime; dto.CreateUser = pp.CreateUser; Mapper.Map <RoleOperateDTO, master_RoleInfo>(dto, pp); var remove = tcdmse.master_RoleAuthority.Where(p => p.RoleID == pp.RoleID).ToList(); tcdmse.master_RoleAuthority.RemoveRange(remove); if (dto.RoleAuthority != null && dto.RoleAuthority.Count > 0) { for (int i = 0; i < dto.RoleAuthority.Count; i++) { var newauth = new master_RoleAuthority() { RoleButtonAuthority = dto.RoleAuthority[i].RoleButtonAuthority, StructureID = dto.RoleAuthority[i].StructureID, RoleID = pp.RoleID }; tcdmse.master_RoleAuthority.Add(newauth); } } result = tcdmse.SaveChanges() > 0; } return(result); }
/// <summary> /// 修改行政区划信息 /// </summary> /// <param name="dto"></param> /// <returns></returns> public bool UpdateRegion(RegionOperateDTO dto) { var result = false; using (var tcdmse = new Entities.TCDMS_MasterDataEntities()) { var pp = tcdmse.dict_RegionInfo.Where(p => p.RegionID == dto.RegionID).FirstOrDefault(); if (pp == null) { throw new Exception("此条信息不存在!"); } var dumplicated = tcdmse.dict_RegionInfo.AsNoTracking().Where(p => p.RegionPID == dto.RegionPID && p.RegionID != dto.RegionID && p.RegionName == dto.RegionName).FirstOrDefault(); if (dumplicated != null) { throw new Exception("修改行政区域不可同名!"); } Mapper.Map <RegionOperateDTO, dict_RegionInfo>(dto, pp); result = tcdmse.SaveChanges() > 0; } return(result); }
/// <summary> /// 小区省份修改 /// </summary> /// <param name="dto"></param> /// <returns></returns> public bool UpdateAreaRegion(AreaOperateDTO dto) { bool blResult = false; using (var tcdmse = new Entities.TCDMS_MasterDataEntities()) { var pp = tcdmse.master_AreaRegionInfo.Where(p => p.AreaRegionID == dto.AreaRegionID).FirstOrDefault(); if (pp != null) { var qq = tcdmse.master_AreaRegionInfo.Where(p => p.AreaID == dto.AreaID && p.RegionID == dto.RegionID).FirstOrDefault(); if (qq == null) { pp.RegionID = dto.RegionID; } } blResult = tcdmse.SaveChanges() > 0; blResult = true; } return(blResult); }
/// <summary> /// 经销商类别新增 /// </summary> /// <returns></returns> public bool AddDistributorType(DistributorTypeOperateDTO dto) { bool blResult = false; using (var tcdmse = new Entities.TCDMS_MasterDataEntities()) { master_DistributorType distype = new master_DistributorType(); Mapper.Map <DistributorTypeOperateDTO, master_DistributorType>(dto, distype); tcdmse.master_DistributorType.Add(distype); // 记录日志 this.AddLog(tcdmse, new LogData { CurrentLogType = LogType.ADD, LogDetails = "新增经销商类别" + dto.DistributorTypeName, OpratorName = dto.CreateUser }); blResult = tcdmse.SaveChanges() > 0; } return(blResult); }
/// <summary> /// 删除部门信息 /// </summary> /// <returns></returns> public bool DeleteDepartment(DepartmentSearchDTO dto) { var result = false; List <int> idlist = new List <int>(); using (var tcdmse = new Entities.TCDMS_MasterDataEntities()) { var pp = tcdmse.master_DepartmentInfo.Where(p => p.DepartID == dto.DepartID).FirstOrDefault(); if (pp == null) { throw new Exception("此条信息不存在"); } if (pp.master_AreaInfo.Count > 0 || pp.master_UserInfo.Count > 0) { throw new Exception("信息已被使用不可删除!"); } idlist.Add(pp.DepartID); var children = tcdmse.master_DepartmentInfo.AsNoTracking().Where(p => p.DepartParentID == pp.DepartID).Select(m => m.DepartID).ToList(); foreach (var child in children) { idlist.AddRange(GetDepartIDList(child).ToList()); } var remo = tcdmse.master_DepartmentInfo.Where(p => idlist.Contains(p.DepartID)).ToList(); foreach (var r in remo) { tcdmse.master_DepartmentInfo.Remove(r); this.AddLog(tcdmse, new LogData { CurrentLogType = LogType.DELETE, LogDetails = "删除部门" + r.DepartName, OpratorName = dto.ModifyUser }); } result = tcdmse.SaveChanges() > 0; } return(result); }