/// <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()); } }