private static int GetListWhiteCount(SqlDbHelper dbHelper, WhiteRequest model)
{
return(Convert.ToInt32(dbHelper.ExecuteScalar(TireSql.StockoutWhite.select_count, CommandType.Text, new SqlParameter[] {
new SqlParameter("@PID", model.PID),
new SqlParameter("@ProductName", model.DisplayName),
new SqlParameter("@OnSale", model.OnSale),
new SqlParameter("@stuckout", model.Stuckout),
new SqlParameter("@TireSize", model.TireSize),
new SqlParameter("@SystemStuckout", model.SystemStuckout),
new SqlParameter("@Status", model.Status),
new SqlParameter("@CityId", model.CityId),
new SqlParameter("@RegionalStockout", model.RegionalStockout),
new SqlParameter("@isShow", model.IsShow)
})));
}
public static IEnumerable <StockoutStatusWhiteModel> SelectWhiteList(WhiteRequest model, PagerModel pager)
{
using (var dbHelper = new SqlDbHelper(ConnectionHelper.GetDecryptConn("Tuhu_Gungnir_BI")))
{
pager.TotalItem = GetListWhiteCount(dbHelper, model);
return(dbHelper.ExecuteDataTable(TireSql.StockoutWhite.select, CommandType.Text, new SqlParameter[] {
new SqlParameter("@PID", model.PID),
new SqlParameter("@ProductName", model.DisplayName),
new SqlParameter("@OnSale", model.OnSale),
new SqlParameter("@TireSize", model.TireSize),
new SqlParameter("@stuckout", model.Stuckout),
new SqlParameter("@SystemStuckout", model.SystemStuckout),
new SqlParameter("@Status", model.Status),
new SqlParameter("@CityId", model.CityId),
new SqlParameter("@PageIndex", pager.CurrentPage),
new SqlParameter("@PageSize", pager.PageSize),
new SqlParameter("@RegionalStockout", model.RegionalStockout),
new SqlParameter("@isShow", model.IsShow)
}).ConvertTo <StockoutStatusWhiteModel>());
}
}
public static IEnumerable <StockoutStatusWhiteModel> SelectWhiteList(WhiteRequest model, PagerModel pager) => DalStockoutStatus.SelectWhiteList(model, pager);
