public async Task <List <TerStatusEntity> > GetList(TerStatusListParam param) { var expression = ListFilter(param); var list = await this.BaseRepository().FindList(expression); return(list.ToList()); }
private Expression <Func <TerStatusEntity, bool> > ListFilter(TerStatusListParam param) { var expression = LinqExtensions.True <TerStatusEntity>(); if (param != null) { } return(expression); }
public async Task <TData <List <TerStatusEntity> > > GetPageList(TerStatusListParam param, Pagination pagination) { TData <List <TerStatusEntity> > obj = new TData <List <TerStatusEntity> >(); obj.Data = await terStatusService.GetPageList(param, pagination); obj.Total = pagination.TotalCount; obj.Tag = 1; return(obj); }
public async Task <TData <List <TerStatusEntity> > > GetList(TerStatusListParam param) { TData <List <TerStatusEntity> > obj = new TData <List <TerStatusEntity> >(); obj.Data = await terStatusService.GetList(param); obj.Total = obj.Data.Count; obj.Tag = 1; return(obj); }
public async Task <List <TerStatusEntity> > GetPageList(TerStatusListParam param, Pagination pagination) { /* * var expression = ListFilter(param); * var list= await this.BaseRepository().FindList(expression, pagination); * return list.ToList(); */ StringBuilder sql = CreateListSql(param); var data = await this.BaseRepository().FindList <TerStatusEntity>(sql.ToString(), pagination); return(data.list.ToList <TerStatusEntity>()); }
/// <summary> /// 创建查询sql /// </summary> /// <param name="param">查询条件数据</param> /// <returns></returns> private StringBuilder CreateListSql(TerStatusListParam param) { StringBuilder sql = new StringBuilder(); sql.AppendFormat(" select a.*,b.TerNumber,b.TerName from "); sql.AppendFormat(" ("); sql.AppendFormat(" select * from ter_status "); sql.AppendFormat(" where 1=1 "); if (param != null) { if (!string.IsNullOrEmpty(param.CloseStatus) && param.CloseStatus != "-1") { sql.AppendFormat(" and CloseStatus={0}", param.CloseStatus); } if (!string.IsNullOrEmpty(param.RunStatus) && param.RunStatus != "-1") { sql.AppendFormat(" and RunStatus={0}", param.RunStatus); } } sql.AppendFormat(" ) a "); sql.AppendFormat(" join "); sql.AppendFormat(" ( "); sql.AppendFormat(" select Id,TerNumber,TerName from ter_infor "); sql.AppendFormat(" where 1=1 "); if (param != null) { if (!string.IsNullOrEmpty(param.TerNumber)) { sql.AppendFormat(" and TerNumber like '%{0}%'", param.TerNumber); } if (!string.IsNullOrEmpty(param.TerName)) { sql.AppendFormat(" and TerName like '%{0}%'", param.TerName); } } sql.AppendFormat(" ) b"); sql.AppendFormat(" on a.TerId=b.Id "); return(sql); }
public async Task <ActionResult> GetPageListJson(TerStatusListParam param, Pagination pagination) { TData <List <TerStatusEntity> > obj = await terStatusBLL.GetPageList(param, pagination); return(Json(obj)); }