public HttpResponseMessage UpdateArea(AreaOperateDTO AreaOperateDTO)
{
ResultDTO <object> actionresult = new ResultDTO <object>();
try
{
if (AreaOperateDTO.AreaRegionID == null)
{
actionresult.SubmitResult = _IRegionServices.UpdateArea(AreaOperateDTO);
}
else
{
actionresult.SubmitResult = _IRegionServices.UpdateAreaRegion(AreaOperateDTO);
}
}
catch (Exception ex)
{
actionresult.SubmitResult = false;
actionresult.Message = ex.Message;
}
HttpResponseMessage result = new HttpResponseMessage
{
Content = new StringContent(JsonConvert.SerializeObject(actionresult),
System.Text.Encoding.GetEncoding("UTF-8"),
"application/json")
};
return(result);
}
/// <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);
}
public void TestMethod1()
{
#region 大小区
//新增
AreaSearchDTO searchdto = new AreaSearchDTO();
testservice.GetAreaTree(searchdto);
AreaOperateDTO adddto = new AreaOperateDTO();
adddto.AreaName = "单元测试大小区";
var addresult = testservice.AddArea(adddto);
var resultlist1 = testservice.GetAreaTree(searchdto);
var target = resultlist1.Where(m => m.AreaName == "单元测试大小区").FirstOrDefault();
Assert.IsNotNull(target);
//修改
adddto.AreaID = target.AreaID;
adddto.AreaName = "修改单元测试大小区";
var updateresult = testservice.UpdateArea(adddto);
var resultlist2 = testservice.GetAreaTree(searchdto);
target = resultlist2.Where(m => m.AreaName == "修改单元测试大小区").FirstOrDefault();
Assert.IsNotNull(target);
//删除
AreaOperateDTO deletedto = new AreaOperateDTO();
deletedto.AreaID = target.AreaID;
var deleteresult = testservice.DeleteArea(deletedto);
var resultlist3 = testservice.GetAreaTree(searchdto);
target = resultlist3.Where(m => m.AreaID == target.AreaID).FirstOrDefault();
Assert.IsNull(target);
#endregion
}
/// <summary>
/// 大小区修改/小区省份修改
/// </summary>
/// <param name="dto"></param>
/// <returns></returns>
public static ResultData <object> UpdateArea(AreaOperateDTO dto)
{
ResultData <object> blResult = new ResultData <object>();
blResult = PutAPI <ResultData <object> >(WebConfiger.MasterDataServicesUrl + "Area", dto);
return(blResult);
}
/// <summary>
/// 大小区删除/小区省份删除
/// </summary>
/// <param name="dto"></param>
/// <returns></returns>
public static ResultData <object> DeleteArea(AreaOperateDTO dto)
{
ResultData <object> blResult = new ResultData <object>();
blResult = DeleteAPI <ResultData <object> >(WebConfiger.MasterDataServicesUrl + "Area?AreaOperateDTO=" + TransformHelper.ConvertDTOTOBase64JsonString(dto));
return(blResult);
}
/// <summary>
/// 大小区删除/小区省份删除
/// </summary>
/// <param name="dto"></param>
/// <returns></returns>
public ActionResult DeleteArea(AreaOperateDTO dto)
{
ResultData <object> result = new ResultData <object>();
UserLoginDTO user = (UserLoginDTO)Session["UserLoginInfo"];
dto.ModifyUser = user.FullName;
try
{
result = AreaRegionProvider.DeleteArea(dto);
}
catch (Exception ex)
{
result.SubmitResult = false;
result.Message = ex.Message;
}
return(Json(result, JsonRequestBehavior.AllowGet));
}
/// <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>
/// <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 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>
/// <param name="dto"></param>
/// <returns></returns>
public bool DeleteAreaRegion(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 mm = tcdmse.master_DistributorRegionInfo.AsNoTracking().Where(m => m.RegionID == pp.RegionID && m.DistrictID == pp.AreaID).FirstOrDefault();
if (mm != null)
{
throw new Exception("此条信息已使用不可删除！");
}
tcdmse.master_AreaRegionInfo.Remove(pp);
}
blResult = tcdmse.SaveChanges() > 0;
}
return(blResult);
}
/// <summary>
/// 大小区修改
/// </summary>
/// <param name="dto"></param>
/// <returns></returns>
public bool UpdateArea(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)
{
if (pp.AreaPID == null)
{
var dumplicated = tcdmse.master_AreaInfo.AsNoTracking().Where(p => p.DepartID == pp.DepartID && p.AreaPID == null && p.AreaName == dto.AreaName && p.AreaID != pp.AreaID).FirstOrDefault();
if (dumplicated != null)
{
throw new Exception("相同部门下大区名称不可重复！");
}
}
else
{
var dumplicated = tcdmse.master_AreaInfo.AsNoTracking().Where(p => p.AreaPID == pp.AreaPID && p.AreaID != pp.AreaID && p.AreaName == dto.AreaName).FirstOrDefault();
if (dumplicated != null)
{
throw new Exception("相同大区下小区名称不可重复！");
}
}
pp.AreaName = dto.AreaName;
pp.ModifyUser = dto.ModifyUser;
pp.ModifyTime = dto.ModifyTime;
}
blResult = tcdmse.SaveChanges() > 0;
blResult = true;
}
return(blResult);
}
public void TestMethod1()
{
//大小区
//新增
AreaSearchDTO searchdto = new AreaSearchDTO();
var searchdtostr = TransformHelper.ConvertDTOTOBase64JsonString(searchdto);
testcontroller.GetAreaTree(searchdtostr);
AreaOperateDTO adddto = new AreaOperateDTO();
adddto.AreaName = "单元测试大小区";
var addresult = JsonConvert.DeserializeObject <ResultDTO <object> >(testcontroller.AddArea(adddto).Content.ReadAsStringAsync().Result);
var resultlist1 = JsonConvert.DeserializeObject <List <AreaResultDTO> >(testcontroller.GetAreaTree(searchdtostr).Content.ReadAsStringAsync().Result);
var target = resultlist1.Where(m => m.AreaName == "单元测试大小区").FirstOrDefault();
Assert.IsNotNull(target);
//修改
adddto.AreaID = target.AreaID;
adddto.AreaName = "修改单元测试大小区";
var updateresult = JsonConvert.DeserializeObject <ResultDTO <object> >(testcontroller.UpdateArea(adddto).Content.ReadAsStringAsync().Result);
var resultlist2 = JsonConvert.DeserializeObject <List <AreaResultDTO> >(testcontroller.GetAreaTree(searchdtostr).Content.ReadAsStringAsync().Result);
target = resultlist2.Where(m => m.AreaName == "修改单元测试大小区").FirstOrDefault();
Assert.IsNotNull(target);
//删除
AreaOperateDTO deletedto = new AreaOperateDTO();
deletedto.AreaID = target.AreaID;
var deletedtostr = TransformHelper.ConvertDTOTOBase64JsonString(deletedto);
var deleteresult = JsonConvert.DeserializeObject <bool>(testcontroller.DeleteArea(deletedtostr).Content.ReadAsStringAsync().Result);
var resultlist3 = JsonConvert.DeserializeObject <List <AreaResultDTO> >(testcontroller.GetAreaTree(searchdtostr).Content.ReadAsStringAsync().Result);
target = resultlist3.Where(m => m.AreaID == target.AreaID).FirstOrDefault();
Assert.IsNull(target);
}
public HttpResponseMessage DeleteArea(string AreaOperateDTO)
{
AreaOperateDTO dto = TransformHelper.ConvertBase64JsonStringToDTO <AreaOperateDTO>(AreaOperateDTO);
ResultDTO <object> actionresult = new ResultDTO <object>();
try
{
if (dto.AreaRegionID == null)
{
actionresult.SubmitResult = _IRegionServices.DeleteArea(dto);
}
else
{
actionresult.SubmitResult = _IRegionServices.DeleteAreaRegion(dto);
}
}
catch (DbUpdateException)
{
actionresult.SubmitResult = false;
actionresult.Message = "此条信息已使用不可删除！";
}
catch (Exception ex)
{
actionresult.SubmitResult = false;
actionresult.Message = ex.Message;
}
HttpResponseMessage result = new HttpResponseMessage
{
Content = new StringContent(JsonConvert.SerializeObject(actionresult),
System.Text.Encoding.GetEncoding("UTF-8"),
"application/json")
};
return(result);
}
