Exemple #1
0
 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>());
     }
 }
Exemple #2
0
 public static IEnumerable <StockoutStatusModel> SelectList(StockoutStatusRequest request, PagerModel pager)
 => DalStockoutStatus.SelectList(request, pager);