/// <summary>
/// 大小区显示一条/小区省份显示一条
/// </summary>
/// <param name="dto"></param>
/// <returns></returns>
public static AreaResultDTO GetOneArea(AreaSearchDTO dto)
{
AreaResultDTO area = null;
var pp = GetAPI <List <AreaResultDTO> >(WebConfiger.MasterDataServicesUrl + "Area?AreaSearchDTO=" + TransformHelper.ConvertDTOTOBase64JsonString(dto));
if (dto.AreaRegionID == null)
{
if (dto.AreaPID == null)
{
//大区
area = pp.Where(p => p.AreaID == dto.AreaID).FirstOrDefault();
}
else
{
//小区
var qq = pp.Where(p => p.AreaID == dto.AreaPID).FirstOrDefault();
area = qq.children.Where(q => q.AreaID == dto.AreaID).FirstOrDefault();
}
}
else
{
//省
foreach (var p in pp)
{
var qq = p.children.Where(q => q.AreaID == dto.AreaPID).FirstOrDefault();
if (qq != null)
{
area = qq.children.Where(q => q.AreaID == dto.AreaRegionID).FirstOrDefault();
}
}
}
return(area);
}
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
}
public ActionResult GetAreas(AreaSearchDTO req)
{
int total = 0;
var list = AreaRepository.GetList(out total, req);
return(NewtonSoftJson(new { rows = list, total = total }, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 大小区显示/小区省份显示
/// </summary>
/// <param name="dto"></param>
/// <returns></returns>
public ActionResult GetArea(AreaSearchDTO dto)
{
List <AreaResultDTO> result = null;
result = AreaRegionProvider.GetArea(dto);
return(Json(result, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 大小区显示/小区省份显示
/// </summary>
/// <param name="dto"></param>
/// <returns></returns>
public static List <AreaResultDTO> GetArea(AreaSearchDTO dto)
{
List <AreaResultDTO> arealist = null;
arealist = GetAPI <List <AreaResultDTO> >(WebConfiger.MasterDataServicesUrl + "Area?AreaSearchDTO=" + TransformHelper.ConvertDTOTOBase64JsonString(dto));
return(arealist);
}
/// <summary>
/// 大小区显示
/// </summary>
/// <param name="lngdto"></param>
/// <returns></returns>
public List <AreaResultDTO> GetAreaTree(AreaSearchDTO dto)
{
List <AreaResultDTO> result = new List <AreaResultDTO>();
var tcdmse = SingleQueryObject.GetObj();
int i = 0;
var pp = tcdmse.master_AreaInfo.AsNoTracking().Where(p => p.AreaID != null);
if (dto.DepartID != null)
{
pp = pp.Where(p => p.DepartID == dto.DepartID);
}
var qq = pp.ToList();
var mm = qq.Where(p => p.AreaPID == null);
foreach (var m in mm)
{
i++;
AreaResultDTO One = new AreaResultDTO();
One = Mapper.Map <master_AreaInfo, AreaResultDTO>(m);
One.FictitiousID = i;
One.children = new List <AreaResultDTO>();
var nn = qq.Where(p => p.AreaPID == m.AreaID);
foreach (var n in nn)
{
i++;
AreaResultDTO Two = new AreaResultDTO();
Two = Mapper.Map <master_AreaInfo, AreaResultDTO>(n);
Two.FictitiousID = i;
One.children.Add(Two);
var ww = tcdmse.master_AreaRegionInfo.AsNoTracking().Where(w => w.AreaID == n.AreaID);
List <AreaResultDTO> region = null;
region = Mapper.Map <List <master_AreaRegionInfo>, List <AreaResultDTO> >(ww.ToList());
foreach (var r in region)
{
i++;
r.FictitiousID = i;
r.AreaPID = n.AreaID;
}
Two.children = region;
}
result.Add(One);
}
//if (dto.DepartID != null)
//{
// List<int> Depat = new List<int>();
// UserAuthorityServices.GetDepare(tcdmse, Depat, dto.DepartID);
// Depat = Depat.Distinct().ToList();
// result = result.Where(p => Depat.Contains(p.DepartID.Value)).ToList();
//}
return(result);
}
public ActionResult GetAreas(AreaSearchDTO req)
{
if (req.ListType == 1)
{
req.offset = (req.offset - 1) * req.limit;
}
var list = _areaRepository.GetList(out int total, req);
return(NewtonSoftJson(new { rows = list, total = total, code = 0, msg = "" }, JsonRequestBehavior.AllowGet));
}
public static List <AreaResultDTO> GetDepAreaByDepartID(int?id)
{
List <AreaResultDTO> arealist = null;
AreaSearchDTO dto = new AreaSearchDTO();
arealist = GetAPI <List <AreaResultDTO> >(WebConfiger.MasterDataServicesUrl + "Area?AreaSearchDTO=" + TransformHelper.ConvertDTOTOBase64JsonString(dto));
arealist = arealist.Where(m => m.DepartID == id).ToList();
foreach (var area in arealist)
{
area.children = null;
}
return(arealist);
}
/// <summary>
/// 大小区显示/小区省份显示
/// </summary>
/// <param name="dto"></param>
/// <returns></returns>
public static List <AreaResultDTO> GetArea(AreaSearchDTO dto)
{
List <AreaResultDTO> arealist = null;
arealist = GetAPI <List <AreaResultDTO> >(WebConfiger.MasterDataServicesUrl + "Area?AreaSearchDTO=" + TransformHelper.ConvertDTOTOBase64JsonString(dto));
foreach (var a in arealist)
{
foreach (var b in a.children)
{
b.children.ForEach(f => { f.Ckid = true; });
}
}
return(arealist);
}
public HttpResponseMessage GetAreaTree(string AreaSearchDTO)
{
AreaSearchDTO dto = TransformHelper.ConvertBase64JsonStringToDTO <AreaSearchDTO>(AreaSearchDTO);
List <AreaResultDTO> arealist = null;
arealist = _IRegionServices.GetAreaTree(dto);
HttpResponseMessage result = new HttpResponseMessage
{
Content = new StringContent(JsonConvert.SerializeObject(arealist),
System.Text.Encoding.GetEncoding("UTF-8"),
"application/json")
};
return(result);
}
/// <summary>
/// 大小区显示一条/小区省份显示一条
/// </summary>
/// <param name="dto"></param>
/// <returns></returns>
public ActionResult GetOneArea(AreaSearchDTO dto)
{
ResultData <AreaResultDTO> result = new ResultData <AreaResultDTO>();
try
{
result.Object = AreaRegionProvider.GetOneArea(dto);
result.SubmitResult = true;
}
catch (Exception ex)
{
result.SubmitResult = false;
result.Message = ex.Message;
}
return(Json(result, JsonRequestBehavior.AllowGet));
}
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 List <AreaListDTO> GetList(out int total, AreaSearchDTO req)
{
using (var db = new SqlSugarClient(Connection))
{
int totalCount = 0;
string order = "Id desc";
List <AreaListDTO> list = new List <AreaListDTO>();
if (!string.IsNullOrEmpty(req.Sort))
{
if (req.Sort.Equals("id", StringComparison.OrdinalIgnoreCase))
{
order = "Id desc";
}
else
{
order = string.Format("{0} {1}", req.Sort, req.Order);
}
}
var sql = db.Queryable <R_Area>()
.JoinTable <R_Restaurant>((s1, s2) => s1.R_Restaurant_Id == s2.Id && s2.IsDelete == false)
.Select(@"s1.*,Restaurant=s2.Name,
BoxNum=(select COUNT(0) from R_Box where IsDelete=0 and R_Area_Id=s1.id),
TableNum=(select COUNT(0) from R_Table where IsDelete=0 and R_Area_Id=s1.id)").Where(" s1.IsDelete = 0 ");
if (req.Restaurant > 0)
{
sql.Where(" s1.R_Restaurant_Id=" + req.Restaurant);
}
var data = sql.ToDataTable();
/*性能问题*/
//if (req.Restaurant > 0)
//{
// DataRow[] dr = data.Select(" R_Restaurant_Id=" + req.Restaurant);
// DataTable dtNew = data.Clone();
// for (int i = 0; i < dr.Length; i++)
// {
// dtNew.ImportRow(dr[i]);
// }
// data = dtNew;//重新赋值
//}
if (data != null && data.Rows.Count > 0)
{
DataView dtv = data.DefaultView;
dtv.Sort = order;
data = dtv.ToTable();
totalCount = data.Rows.Count;
var rows = data.Rows.Cast <DataRow>();
var curRows = rows.Skip(req.offset).Take(req.limit).ToArray();
foreach (DataRow item in curRows)
{
list.Add(new AreaListDTO()
{
Id = Convert.ToInt32(item["id"]),
Name = item["Name"].ToString(),
Description = item["Description"].ToString(),
Restaurant = item["Restaurant"].ToString(),
ServerRate = Convert.ToDecimal(item["ServerRate"]),
BoxNum = Convert.ToInt32(item["BoxNum"]),
TableNum = Convert.ToInt32(item["TableNum"])
});
}
}
total = totalCount;
return(list);
}
}
