public ActionResult GetOrderPageList(TxnSoMstrQuery query)
{
try
{
var result = _txnSoMstrRepository.GetOrderPageList(query);
return(Page(result.Data, result.Page));
}
catch (Exception ex)
{
return(Fail("获取失败：" + ex.Message));
}
}
/// <summary>
/// 获取订单分页数据
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public dynamic GetOrderPageList(TxnSoMstrQuery query)
{
string where = _permissionHelper.GetCondition(AbpSession.USR_TYPE, AbpSession.USR_SCOPE, "so.CREATE_ORG_NO", AbpSession.ORG_NO, AbpSession.BG_NO);
if (!string.IsNullOrEmpty(query.START_DATE))
{
where += string.IsNullOrEmpty(where) ? " and TO_char(so.CREATE_DATE,'yyyy-mm-dd') >= '" + query.START_DATE + "'" : "TO_char(so.CREATE_DATE, 'yyyy-mm-dd') >= '" + query.START_DATE + "'";
}
if (!string.IsNullOrEmpty(query.END_DATE))
{
where += string.IsNullOrEmpty(where) ? " and TO_char(so.CREATE_DATE,'yyyy-mm-dd') <= '" + query.END_DATE + "'" : "TO_char(so.CREATE_DATE,'yyyy-mm-dd') <= '" + query.END_DATE + "'";
}
return(_sqlQuery.Select(@"so.*,cus.ERP_MEMBER_NO,bu.bu_name,mbm.bu_name as BG_NAME")
.Filter("so.DEL_FLAG", 1)
.Filter("so.STATUS", query.STATUS)
.Filter("so.SO_NO", query.SO_NO)
.Filter("cus.ERP_MEMBER_NO", query.ERP_MEMBER_NO)
.Filter("so.QUEUE_NO", query.QUEUE_NO)
.Filter("so.CUS_NAME", query.CUS_NAME)
.Filter("so.EXPRESS_NO", query.EXPRESS_NO)
.In("so.biz_type", new string[] { "DS", "MS" })
.And(where)
.OrderBy("so.CREATE_DATE desc")
.GetPageList <dynamic>(@"TXN_SO_MSTR so left join sys_usr_mstr cus on so.CREATE_PSN = cus.usr_id left join MDM_BU_MSTR bu on bu.bu_no = so.ORG_NO left join MDM_BU_MSTR mbm on mbm.bu_no = bu.parent_bu_no", Context.Database.GetDbConnection(), query));
}
