public async Task <List <AreaEntity> > GetPageList(AreaListParam param, Pagination pagination)
{
var expression = ListFilter(param);
var list = await this.BaseRepository().FindList(expression, pagination);
return(list.ToList());
}
/// <summary>
/// 获取wdtree数据
/// </summary>
/// <returns></returns>
public async Task <TData <DataTable> > GetAreaList(string parentCode, string curUserId)
{
AreaListParam param = new AreaListParam();
param.ParentAreaCode = parentCode;
long longUserId = 0;
long.TryParse(curUserId, out longUserId);
if (longUserId > 0)
{
var userModel = userBll.GetEntity(longUserId);
if (!string.IsNullOrEmpty(userModel.Result.Data.DelegetZoneId))
{
String[] ids = userModel.Result.Data.DelegetZoneId.Replace("-", ",").Split(',');
param.AreaCodes = string.Format("'{0}'", string.Join("','", ids));
}
}
TData <DataTable> obj = new TData <DataTable>();
obj.Data = await areaService.GetData(param);
obj.Tag = 1;
return(obj);
}
public async Task <TData <List <AreaEntity> > > GetPageList(AreaListParam param, Pagination pagination)
{
TData <List <AreaEntity> > obj = new TData <List <AreaEntity> >();
obj.Data = await areaService.GetPageList(param, pagination);
obj.Total = pagination.TotalCount;
obj.Tag = 1;
return(obj);
}
public async Task <DataTable> GetData(AreaListParam param)
{
/*Task<DataTable> FindTable
* var expression = ListFilter(param);
* var list= await this.BaseRepository().FindList(expression, pagination);
* return list.ToList();
*/
StringBuilder sql = CreateSql(param);
var data = await this.BaseRepository().FindTable(sql.ToString());
return(data);
}
private Expression <Func <AreaEntity, bool> > ListFilter(AreaListParam param)
{
var expression = LinqExtensions.True <AreaEntity>();
if (param != null)
{
if (!param.AreaName.IsEmpty())
{
expression = expression.And(t => t.AreaName.Contains(param.AreaName));
}
}
return(expression);
}
public async Task <TData <List <AreaEntity> > > GetList(AreaListParam param)
{
TData <List <AreaEntity> > obj = new TData <List <AreaEntity> >();
List <AreaEntity> areaList = await areaCache.GetList();
if (param != null)
{
if (!param.AreaName.IsEmpty())
{
areaList = areaList.Where(t => t.AreaName.Contains(param.AreaName)).ToList();
}
}
obj.Data = areaList;
obj.Tag = 1;
return(obj);
}
public async Task <TData <List <ZtreeInfo> > > GetZtreeAreaList(AreaListParam param)
{
var obj = new TData <List <ZtreeInfo> >();
obj.Data = new List <ZtreeInfo>();
List <AreaEntity> list = await areaCache.GetList();
foreach (AreaEntity area in list)
{
obj.Data.Add(new ZtreeInfo
{
id = area.AreaCode.ParseToLong(),
pId = area.ParentAreaCode.ParseToLong(),
name = area.AreaName
});
}
obj.Tag = 1;
return(obj);
}
/// <summary>
/// 创建查询sql
/// </summary>
/// <returns></returns>
private StringBuilder CreateSql(AreaListParam param)
{
StringBuilder sql = new StringBuilder();
sql.AppendFormat(" SELECT AreaCode,ParentAreaCode,AreaName,AreaLevel FROM sysarea");
sql.AppendFormat(" WHERE 1=1");
if (param != null)
{
if (!param.AreaCodes.IsEmpty())
{
//expression = expression.And(t => t.AreaName.Contains(param.AreaName));
sql.AppendFormat(" AND AreaCode in({0})", param.AreaCodes);
}
if (!param.ParentAreaCode.IsEmpty())
{
//expression = expression.And(t => t.AreaName.Contains(param.AreaName));
sql.AppendFormat(" AND ParentAreaCode='{0}'", param.ParentAreaCode);
}
}
return(sql);
}
public async Task <IActionResult> GetZtreeAreaListJson(AreaListParam param)
{
TData <List <ZtreeInfo> > obj = await areaBLL.GetZtreeAreaList(param);
return(Json(obj));
}
public async Task <IActionResult> GetPageListJson(AreaListParam param, Pagination pagination)
{
TData <List <AreaEntity> > obj = await areaBLL.GetPageList(param, pagination);
return(Json(obj));
}
