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