public async Task <List <CustWorkSheetEntity> > GetList(CustWorkSheetListParam param) { var expression = ListFilter(param); var list = await this.BaseRepository().FindList(expression); return(list.ToList()); }
public async Task <ActionResult> GetPageListJson(CustWorkSheetListParam param, Pagination pagination) { OperatorInfo user = await Operator.Instance.Current(); TData <List <CustWorkSheetEntity> > obj = await custWorkSheetBLL.GetPageList(param, pagination, user); return(Json(obj)); }
private Expression <Func <CustWorkSheetEntity, bool> > ListFilter(CustWorkSheetListParam param) { var expression = LinqExtensions.True <CustWorkSheetEntity>(); if (param != null) { } return(expression); }
public async Task <TData <List <CustWorkSheetEntity> > > GetPageList(CustWorkSheetListParam param, Pagination pagination, OperatorInfo user) { TData <List <CustWorkSheetEntity> > obj = new TData <List <CustWorkSheetEntity> >(); obj.Data = await custWorkSheetService.GetPageList(param, pagination, user); obj.Total = pagination.TotalCount; obj.Tag = 1; return(obj); }
public async Task <TData <List <CustWorkSheetEntity> > > GetList(CustWorkSheetListParam param) { TData <List <CustWorkSheetEntity> > obj = new TData <List <CustWorkSheetEntity> >(); obj.Data = await custWorkSheetService.GetList(param); obj.Total = obj.Data.Count; obj.Tag = 1; return(obj); }
public async Task <List <CustWorkSheetEntity> > GetPageList(CustWorkSheetListParam param, Pagination pagination, OperatorInfo user) { /* * var expression = ListFilter(param); * var list = await this.BaseRepository().FindList(expression, pagination); * return list.ToList(); */ StringBuilder sql = CreateListSql(param, user); var data = await this.BaseRepository().FindList <CustWorkSheetEntity>(sql.ToString(), pagination); return(data.list.ToList <CustWorkSheetEntity>()); }
public async Task <ActionResult> GetListJson(CustWorkSheetListParam param) { TData <List <CustWorkSheetEntity> > obj = await custWorkSheetBLL.GetList(param); return(Json(obj)); }
/// <summary> /// 创建查询sql /// </summary> /// <param name="param">查询条件数据</param> /// <returns></returns> private StringBuilder CreateListSql(CustWorkSheetListParam param, OperatorInfo user) { StringBuilder sql = new StringBuilder(); sql.AppendFormat(" SELECT a.*,"); sql.AppendFormat(" b.TerNumber,b.TerName,"); sql.AppendFormat(" c.RealName AS DoManTxt,"); sql.AppendFormat(" d.RealName AS BaseCreatorTxt"); sql.AppendFormat(" from "); sql.AppendFormat(" ("); sql.AppendFormat(" select * from cust_work_sheet "); sql.AppendFormat(" where 1=1 "); if (param != null) { if (!user.IsAdminOrDev) { sql.AppendFormat(" AND (BaseCreatorId={0} OR DoManId={0})", user.UserIdStr); } if (param.Step >= 0) { sql.AppendFormat(" AND Step={0}", param.Step); } 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 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 "); sql.AppendFormat(" JOIN "); sql.AppendFormat(" ( "); sql.AppendFormat(" SELECT Id,RealName from sysuser "); sql.AppendFormat(" WHERE 1=1 "); sql.AppendFormat(" ) c"); sql.AppendFormat(" on a.DoManId = c.Id "); sql.AppendFormat(" JOIN "); sql.AppendFormat(" ( "); sql.AppendFormat(" SELECT Id,RealName from sysuser "); sql.AppendFormat(" WHERE 1=1 "); sql.AppendFormat(" ) d"); sql.AppendFormat(" on a.BaseCreatorId = d.Id "); return(sql); }