public async Task <List <OrderMaterielEntity> > GetList(OrderMaterielListParam param)
{
var expression = ListFilter(param);
var list = await this.BaseRepository().FindList(expression);
return(list.ToList());
}
private Expression <Func <OrderMaterielEntity, bool> > ListFilter(OrderMaterielListParam param)
{
var expression = LinqExtensions.True <OrderMaterielEntity>();
if (param != null)
{
}
return(expression);
}
public async Task <TData <List <OrderMaterielEntity> > > GetPageList(OrderMaterielListParam param, Pagination pagination)
{
TData <List <OrderMaterielEntity> > obj = new TData <List <OrderMaterielEntity> >();
obj.Data = await orderMaterielService.GetPageList(param, pagination);
obj.Total = pagination.TotalCount;
obj.Tag = 1;
return(obj);
}
public async Task <List <OrderMaterielEntity> > GetPageList(OrderMaterielListParam 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 <OrderMaterielEntity>(sql.ToString(), pagination);
return(data.list.ToList <OrderMaterielEntity>());
}
public async Task <TData <List <OrderMaterielEntity> > > GetListJson(
OrderMaterielListParam param)
{
TData <List <OrderMaterielEntity> > obj = new TData <List <OrderMaterielEntity> >();
try
{
obj = await new OrderMaterielBLL().GetList(param);
}
catch (Exception ex)
{
LogHelper.Info("GetPageListJson ex:" + ex.ToString());
}
return(obj);
}
/// <summary>
/// 创建查询sql
/// </summary>
/// <param name="param">查询条件数据</param>
/// <returns></returns>
private StringBuilder CreateListSql(OrderMaterielListParam param)
{
StringBuilder sql = new StringBuilder();
sql.AppendFormat(" SELECT * FROM (");
sql.AppendFormat(" SELECT a.*,b.RealName AS BaseCreatorTxt ");
sql.AppendFormat(" FROM order_materiel a ");
sql.AppendFormat(" JOIN sysuser b ON a.BaseCreatorId = b.Id ");
sql.AppendFormat(" ) T WHERE 1=1 ");
if (param != null)
{
if (!string.IsNullOrEmpty(param.MaterielName))
{
sql.AppendFormat(" AND MaterielName LIKE '%{0}%'", param.MaterielName);
}
}
return(sql);
}
public async Task <TData <List <OrderMaterielEntity> > > GetList(OrderMaterielListParam param)
{
TData <List <OrderMaterielEntity> > obj = new TData <List <OrderMaterielEntity> >();
obj.SetDefault();
List <OrderMaterielEntity> list = await orderMaterielService.GetList(param);
if (list.Count > 0)
{
obj.Data = list;
obj.Total = obj.Data.Count;
obj.Tag = 1;
obj.Refresh();
}
else
{
obj.Message = "没有数据";
}
return(obj);
}
public async Task <ActionResult> GetPageListJson(OrderMaterielListParam param, Pagination pagination)
{
TData <List <OrderMaterielEntity> > obj = await orderMaterielBLL.GetPageList(param, pagination);
return(Json(obj));
}
