/// <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);
}
