public ActionResult SummarySaleListJson(Pagination pagination, SaleQueryEntity queryAgrs)
{
var res = ReportBLL.Instance.RptGetSummarySaleList(queryAgrs);
if (res != null)
{
return(Content(GetPagingJson(res.ToList(), pagination)));
}
else
{
return(Error("未找到符合条件的记录!"));
}
}
/// <summary>
/// 销售明细报表
/// </summary>
/// <param name="queryAgrs"></param>
/// <returns></returns>
public static List <SummerSaleList> RptGetSummarySaleList(SaleQueryEntity queryAgrs)
{
return(utity.ExecuteListSp <SummerSaleList>("rpt_SaleList", new object[] {
queryAgrs.StoreID,
queryAgrs.SaleStartTime,
queryAgrs.SaleEndTime,
queryAgrs.Guider,
queryAgrs.Category,
queryAgrs.GoodsName,
queryAgrs.TicketCode,
queryAgrs.RecordStatus
}));
}
/// <summary>
/// 销售汇总报表
/// </summary>
/// <param name="queryAgrs"></param>
/// <returns></returns>
public List <SummarySale> RptGetSummarySale(SaleQueryEntity queryAgrs)
{
var data = ReportDAL.RptGetSummarySale(queryAgrs);
if (data != null && data.Any())
{
var cnt = data.Count;
var tag = "合计";
if (data[cnt - 1].TicketCode == tag)
{
var castData = new List <SummarySale>();
castData.Add(data[cnt - 1]);
castData.AddRange(data.Where(s => s.TicketCode != tag).ToList());
return(castData);
}
return(data);
}
return(data);
}
/// <summary>
/// 销售汇总报表
/// </summary>
/// <param name="queryAgrs"></param>
/// <returns></returns>
public static List <SummarySale> RptGetSummarySale(SaleQueryEntity queryAgrs)
{
return(utity.ExecuteListSp <SummarySale>("rpt_SummarySale", new object[] { queryAgrs.StoreID, queryAgrs.SaleStartTime, queryAgrs.SaleEndTime, queryAgrs.PayType, queryAgrs.Guider }));
}
/// <summary>
/// 销售明细报表
/// </summary>
/// <param name="queryAgrs"></param>
/// <returns></returns>
public List <SummerSaleList> RptGetSummarySaleList(SaleQueryEntity queryAgrs)
{
return(ReportDAL.RptGetSummarySaleList(queryAgrs));
}
public static List <PosSaleExtend> GetAdminPostList(SaleQueryEntity saleQueryEntity)
{
return(utity.ExecuteListSp <PosSaleExtend>("usp_GetPosList", new object[] { saleQueryEntity.StoreID, ConvertHelper.ToNullableDt(saleQueryEntity.SaleStartTime), ConvertHelper.ToNullableDt(saleQueryEntity.SaleEndTime, true), saleQueryEntity.PayType, saleQueryEntity.Guider, saleQueryEntity.TicketCode }));
}
public List <PosSaleExtend> GetAdminPostList(SaleQueryEntity saleQueryEntity)
{
return(PosDAL.GetAdminPostList(saleQueryEntity));
}