public async Task <List <TerCollusionEntity> > GetList(TerCollusionListParam param) { var expression = ListFilter(param); var list = await this.BaseRepository().FindList(expression); return(list.ToList()); }
private Expression <Func <TerCollusionEntity, bool> > ListFilter(TerCollusionListParam param) { var expression = LinqExtensions.True <TerCollusionEntity>(); if (param != null) { } return(expression); }
public async Task <TData <List <TerCollusionEntity> > > GetPageList(TerCollusionListParam param, Pagination pagination) { TData <List <TerCollusionEntity> > obj = new TData <List <TerCollusionEntity> >(); obj.Data = await terCollusionService.GetPageList(param, pagination); obj.Total = pagination.TotalCount; obj.Tag = 1; return(obj); }
public async Task <TData <List <TerCollusionEntity> > > GetList(TerCollusionListParam param) { TData <List <TerCollusionEntity> > obj = new TData <List <TerCollusionEntity> >(); obj.Data = await terCollusionService.GetList(param); obj.Total = obj.Data.Count; obj.Tag = 1; return(obj); }
/// <summary> /// 创建查询sql /// </summary> /// <param name="param">查询条件数据</param> /// <returns></returns> private StringBuilder CreateListSql(TerCollusionListParam param, OperatorInfo user) { StringBuilder sql = new StringBuilder(); sql.AppendFormat(" SELECT a.*, "); sql.AppendFormat(" b.TerName, "); sql.AppendFormat(" b.TerNumber, "); sql.AppendFormat(" c.RealName AS SaleTxt"); sql.AppendFormat(" FROM ( "); sql.AppendFormat(" SELECT * FROM ter_collusion WHERE 1=1"); if (param != null) { if (user != null) { if (!user.IsAdminOrDev) { sql.AppendFormat(" AND SaleId = {0}", user.UserId); } } if (!string.IsNullOrEmpty(param.SaleTxt)) { sql.AppendFormat(" AND SaleTxt LIKE '%{0}%'", param.SaleTxt); } if (!string.IsNullOrEmpty(param.StartTime)) { sql.AppendFormat(" AND BaseCreateTime >'{0} 00:00:00'", param.StartTime); } if (!string.IsNullOrEmpty(param.EndTime)) { sql.AppendFormat(" AND BaseCreateTime <'{0} 23:59:59'", param.EndTime); } } sql.AppendFormat(" ) a "); sql.AppendFormat(" JOIN "); sql.AppendFormat(" ("); sql.AppendFormat(" SELECT TerName,TerNumber FROM ter_infor WHERE 1=1"); if (param != null) { if (!string.IsNullOrEmpty(param.TerNumber)) { sql.AppendFormat(" AND Id,TerNumber LIKE '%{0}%'", param.TerNumber); } } sql.AppendFormat(" ) b"); sql.AppendFormat(" ON a.TerId =b.Id"); sql.AppendFormat(" LEFT JOIN sysuser C ON a.SaleId = C.Id "); return(sql); }
public async Task <List <TerCollusionEntity> > GetPageList(TerCollusionListParam param, Pagination pagination) { /* * var expression = ListFilter(param); * var list = await this.BaseRepository().FindList(expression, pagination); * return list.ToList(); */ OperatorInfo user = await Operator.Instance.Current(); StringBuilder sql = CreateListSql(param, user); var data = await this.BaseRepository().FindList <TerCollusionEntity>(sql.ToString(), pagination); return(data.list.ToList <TerCollusionEntity>()); }
public async Task <ActionResult> GetPageListJson(TerCollusionListParam param, Pagination pagination) { TData <List <TerCollusionEntity> > obj = await terCollusionBLL.GetPageList(param, pagination); return(Json(obj)); }