public async Task <List <OrderTerIssueEntity> > GetList(OrderTerIssueListParam param, OperatorInfo user)
{
var expression = ListFilter(param);
var list = await this.BaseRepository().FindList(expression);
return(list.ToList());
}
public async Task <ActionResult> GetPageListJson(OrderTerIssueListParam param, Pagination pagination)
{
OperatorInfo user = await Operator.Instance.Current();
TData <List <OrderTerIssueEntity> > obj = await orderTerIssueBLL.GetPageList(param, pagination, user);
return(Json(obj));
}
private Expression <Func <OrderTerIssueEntity, bool> > ListFilter(OrderTerIssueListParam param)
{
var expression = LinqExtensions.True <OrderTerIssueEntity>();
if (param != null)
{
}
return(expression);
}
public async Task <TData <List <OrderTerIssueEntity> > > GetPageList(OrderTerIssueListParam param, Pagination pagination, OperatorInfo user)
{
TData <List <OrderTerIssueEntity> > obj = new TData <List <OrderTerIssueEntity> >();
obj.Data = await orderTerIssueService.GetPageList(param, pagination, user);
obj.Total = pagination.TotalCount;
obj.PageTotal = pagination.TotalPage;
obj.Tag = 1;
return(obj);
}
public async Task <List <Response_OrderTerIssue_ChartLine> > GetListGroup(OrderTerIssueListParam param, OperatorInfo user)
{
/*
* var expression = ListFilter(param);
* var list= await this.BaseRepository().FindList(expression, pagination);
* return list.ToList();
*/
StringBuilder sql = CreateListGropuSql(param, user);
var data = await this.BaseRepository().FindList <Response_OrderTerIssue_ChartLine>(sql.ToString());
return(data.ToList <Response_OrderTerIssue_ChartLine>());
}
// private OrderPrintIssueBLL orderPrintIssueBLL = new OrderPrintIssueBLL();
#region 获取数据
public async Task <TData <List <OrderTerIssueEntity> > > GetList(OrderTerIssueListParam param)
{
OperatorInfo user = await Operator.Instance.Current();
TData <List <OrderTerIssueEntity> > obj = new TData <List <OrderTerIssueEntity> >();
obj.Data = await orderTerIssueService.GetList(param, user);
obj.Total = obj.Data.Count;
obj.Tag = 1;
return(obj);
}
public async Task <List <OrderTerIssueEntity> > GetPageList(OrderTerIssueListParam 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);
//LogHelper.Info(" sql:"+sql.ToString());
var data = await this.BaseRepository().FindList <OrderTerIssueEntity>(sql.ToString(), pagination);
return(data.list.ToList <OrderTerIssueEntity>());
}
/// <summary>
/// 创建查询sql
/// </summary>
/// <param name="param">查询条件数据</param>
/// <returns></returns>
private StringBuilder CreateListGropuSql(OrderTerIssueListParam param, OperatorInfo user)
{
StringBuilder sql = new StringBuilder();
sql.AppendFormat(" SELECT a.*");
sql.AppendFormat(" ,e.MaterielName as MaterielTxt");
sql.AppendFormat(" ,e.MaterielType as MaterielType");
sql.AppendFormat(" ,e.MaterielDesc as MaterielDesc");
sql.AppendFormat(" ,e.MaterielUnite as MaterielUnite");
sql.AppendFormat(" from (");
sql.AppendFormat(" SELECT SUM(SaleNum) SaleNum,MaterielId,BuyDay FROM order_ter_issue ");
sql.AppendFormat(" where 1=1 ");
if (param != null)
{
if (!user.IsAdminOrDev)
{
sql.AppendFormat(" AND SaleId ={0}", user.UserIdStr);
}
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(" GROUP BY BuyDay,MaterielId");
sql.AppendFormat(" ) a ");
sql.AppendFormat(" JOIN ");
sql.AppendFormat(" ( ");
sql.AppendFormat(" SELECT Id,MaterielName,MaterielType,MaterielDesc,MaterielUnite from order_materiel ");
sql.AppendFormat(" WHERE 1=1 ");
sql.AppendFormat(" ) e");
sql.AppendFormat(" on a.MaterielId = e.Id ");
sql.AppendFormat(" ORDER BY a.BuyDay");
return(sql);
}
/// <summary>
/// 创建查询sql
/// </summary>
/// <param name="param">查询条件数据</param>
/// <returns></returns>
private StringBuilder CreateListSql(OrderTerIssueListParam param, OperatorInfo user)
{
StringBuilder sql = new StringBuilder();
sql.AppendFormat(" SELECT a.*");
sql.AppendFormat(" ,b.RealName AS BaseCreatorTxt");
sql.AppendFormat(" ,c.RealName AS ShenHeManTxt");
sql.AppendFormat(" ,d.RealName AS SentManTxt");
sql.AppendFormat(" ,e.MaterielName as MaterielTxt");
sql.AppendFormat(" ,e.MaterielType as MaterielType");
sql.AppendFormat(" ,e.MaterielDesc as MaterielDesc");
sql.AppendFormat(" ,e.MaterielUnite as MaterielUnite");
sql.AppendFormat(" from (");
sql.AppendFormat(" SELECT * FROM order_ter_issue ");
sql.AppendFormat(" where 1=1 ");
if (param != null)
{
if (param.Step >= 0)
{
sql.AppendFormat(" AND Step={0}", param.Step);
}
if (param.ShenHeStatus >= 0)
{
sql.AppendFormat(" AND ShenHeStatus={0}", param.ShenHeStatus);
}
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 Id,RealName from sysuser ");
sql.AppendFormat(" WHERE 1=1 ");
sql.AppendFormat(" ) b");
sql.AppendFormat(" on a.SaleId = b.Id ");
sql.AppendFormat(" LEFT JOIN ");
sql.AppendFormat(" ( ");
sql.AppendFormat(" SELECT Id,RealName from sysuser ");
sql.AppendFormat(" WHERE 1=1 ");
sql.AppendFormat(" ) c");
sql.AppendFormat(" on a.ShenHeManId = c.Id ");
sql.AppendFormat(" LEFT JOIN ");
sql.AppendFormat(" ( ");
sql.AppendFormat(" SELECT Id,RealName from sysuser ");
sql.AppendFormat(" WHERE 1=1 ");
sql.AppendFormat(" ) d");
sql.AppendFormat(" on a.SentManId = d.Id ");
sql.AppendFormat(" JOIN ");
sql.AppendFormat(" ( ");
sql.AppendFormat(" SELECT Id,MaterielName,MaterielType,MaterielDesc,MaterielUnite from order_materiel ");
sql.AppendFormat(" WHERE 1=1 ");
sql.AppendFormat(" ) e");
sql.AppendFormat(" on a.MaterielId = e.Id ");
return(sql);
}
public async Task <TData <List <Response_OrderTerIssue_ChartLine> > > GetListGroupChart(OrderTerIssueListParam param, OperatorInfo user)
{
TData <List <Response_OrderTerIssue_ChartLine> > obj = new TData <List <Response_OrderTerIssue_ChartLine> >();
List <Response_OrderTerIssue_ChartLine> list = await orderTerIssueService.GetListGroup(param, user);
obj.Total = list.Count;
obj.Data = list;
obj.Tag = 1;
if (obj.Total <= 0)
{
obj.Message = "没有查询到数据";
}
return(obj);
}
public async Task <ActionResult> GetListJson(OrderTerIssueListParam param)
{
TData <List <OrderTerIssueEntity> > obj = await orderTerIssueBLL.GetList(param);
return(Json(obj));
}
