/// <summary>
/// 获取导出的数据
/// </summary>
/// <param name="procName"></param>
/// <param name="model"></param>
/// <returns></returns>
public DataTable GetExportDataProc(string procName, SalesRebateReportQueryParameterModel model)
{
return(SqlHelper.ExecuteDataTableProcedure(procName, new SqlParameter[]
{
new SqlParameter("@BillDate1", model.BillDate1),
new SqlParameter("@BillDate2", model.BillDate2),
new SqlParameter("@OrgName", model.OrgName ?? ""),
new SqlParameter("@CaseName", model.CaseName ?? ""),
new SqlParameter("@BrandName", model.BrandName ?? ""),
}));
}
/// <summary>
/// 获取查询报表
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public List <SalesRebateOrgCaseReportModel> GetCaseAmountReport(SalesRebateReportQueryParameterModel model)
{
DynamicParameters dp = new DynamicParameters();
dp.Add("@BillDate1", model.BillDate1, DbType.Date, ParameterDirection.Input);
dp.Add("@BillDate2", model.BillDate2, DbType.Date, ParameterDirection.Input);
dp.Add("@OrgName", model.OrgName ?? "", DbType.String, ParameterDirection.Input);
dp.Add("@CaseName", model.CaseName ?? "", DbType.String, ParameterDirection.Input);
dp.Add("@BrandName", model.BrandName ?? "", DbType.String, ParameterDirection.Input);
using (var connection = SqlDb.UpdateConnection)
{
return(connection.Query <SalesRebateOrgCaseReportModel>("SJSalesRebateShowOrgCaseAmountProc", dp, null, true, null, CommandType.StoredProcedure).ToList());
}
}
