using HH.WMS.DAL.AllQuery;
|
using HH.WMS.Entitys;
|
using HH.WMS.Entitys.Common;
|
/********************************************************************************
|
|
** auth: DBS
|
|
** date: 2019/1/17 16:14:01
|
|
** desc: 尚未编写描述
|
|
** Ver.: V1.0.0
|
|
*********************************************************************************/
|
using System;
|
using System.Collections.Generic;
|
using System.Data;
|
using System.Linq;
|
using System.Text;
|
using System.Threading.Tasks;
|
|
namespace HH.WMS.BLL.AllQuery
|
{
|
public class ReportBll : DapperBaseBLL
|
{
|
#region 获取KPI报表
|
/// <summary>
|
/// 获取KPI报表
|
/// </summary>
|
/// <param name="searchModel"></param>
|
/// <returns></returns>
|
/// <History>[Hanhe(DBS)] created by 2019/1/3</History>
|
public Entitys.OperateResult GetKpiList(Entitys.Common.SearchModel searchModel)
|
{
|
long total = 0;
|
DataTable dt = CreateDAL<ReportDal>().GetKpiList(searchModel, out total);
|
//dt.Columns["CN_S_STOCK_CODE"].ReadOnly = false;
|
//foreach (DataRow dr in dt.Rows)
|
//{
|
// dr["CN_S_STOCK_CODE"] = GetStock().Find(x => x.CN_S_STOCK_CODE.Equals(dr["CN_S_STOCK_CODE"].ToString().Trim())).CN_S_STOCK_NAME;
|
//}
|
return OperateResult.Succeed(null, new
|
{
|
rows = dt,
|
total = total
|
});
|
}
|
#endregion
|
|
|
#region 物流公司统计
|
/// <summary>
|
/// 物流公司统计
|
/// </summary>
|
/// <param name="searchModel"></param>
|
/// <param name="total"></param>
|
/// <returns></returns>
|
public DataTable GetLogisticsReport(SearchModel searchModel, out long total)
|
{
|
return CreateDAL<ReportDal>().GetLogisticsReport(searchModel, out total);
|
}
|
#endregion
|
|
#region 物流出库详情
|
/// <summary>
|
/// 物流出库详情
|
/// </summary>
|
/// <param name="searchModel"></param>
|
/// <returns></returns>
|
public DataTable GetLogisticsDetail(SearchModel searchModel)
|
{
|
return CreateDAL<ReportDal>().GetLogisticsDetail(searchModel);
|
}
|
|
public DataTable GetStockCompareReport(SearchModel searchModel, out long total)
|
{
|
return CreateDAL<ReportDal>().GetStockCompareReport(searchModel, out total);
|
}
|
#endregion
|
}
|
}
|