public static IEnumerable <StockoutStatusModel> SelectList(StockoutStatusRequest request, PagerModel pager)
{
using (var dbHelper = new SqlDbHelper(ConnectionHelper.GetDecryptConn("Tuhu_Gungnir_BI")))
{
var para = new SqlParameter[] {
new SqlParameter("@CityId", request.CityId),
new SqlParameter("@PID", string.IsNullOrWhiteSpace(request.PID)?null:request.PID),
new SqlParameter("@Status", request.Status),
new SqlParameter("@TireSize", request.TireSize),
new SqlParameter("@PageIndex", pager.CurrentPage),
new SqlParameter("@PageSize", pager.PageSize),
};
var para_temp = new SqlParameter[] {
new SqlParameter("@CityId", request.CityId),
new SqlParameter("@PID", string.IsNullOrWhiteSpace(request.PID)?null:request.PID),
new SqlParameter("@Status", request.Status),
new SqlParameter("@TireSize", request.TireSize),
};
pager.TotalItem = GetListCount(dbHelper, para_temp);
return(dbHelper.ExecuteDataTable(TireSql.StockoutWgite.select, CommandType.Text, para).ConvertTo <StockoutStatusModel>());
}
}
public static IEnumerable <StockoutStatusModel> SelectList(StockoutStatusRequest request, PagerModel pager) => DalStockoutStatus.SelectList(request, pager);