public PageOf <Models.StoreModel> GetStoreListByBrandId(int brandId, int areaId, Models.Enums.LanguageEnum languageEnum, int pageSize, int pageIndex)
{
var query = @" (SELECT s.Id
,s.BrandId
,s.AreaId
,p.ProvinceName as AreaName
,s.AddressCN
,s.AddressEN
,s.AddressHK
,s.Status
FROM Store s(nolock) inner join Province p(nolock) on s.AreaId = p.ProvinceId and p.LanguageVersion=@LanguageVersion
WHERE s.BrandId=@BrandId and s.Status=1";
if (areaId > 0)
{
query += " and s.AreaId=@AreaId";
}
query += ") pp ";
string sql = string.Format(@" select * from (select ROW_NUMBER() OVER(order by pp.Id desc) AS RowNum,* from {0}
) as A where A.RowNum BETWEEN (@PageIndex-1)* @PageSize+1 AND @PageIndex*@PageSize ORDER BY RowNum;" ,
query);
sql += string.Format(@" SELECT COUNT(1) FROM {0};", query);
var db = DbSFO2OMain;
var parameters = db.CreateParameterCollection();
parameters.Append("BrandId", brandId);
parameters.Append("AreaId", areaId);
parameters.Append("LanguageVersion", (int)languageEnum);
parameters.Append("PageIndex", pageIndex);
parameters.Append("PageSize", pageSize);
DataSet ds = db.ExecuteSqlDataSet(sql, parameters);
return(new PageOf <StoreModel>()
{
PageIndex = pageIndex,
PageSize = pageSize,
Total = Convert.ToInt32(ds.Tables[1].Rows[0][0]),
Items = DataMapHelper.DataSetToList <StoreModel>(ds)
});
}
public PageOf <Models.StoreModel> GetStoreListByBrandId(int brandId, int areaId, Models.Enums.LanguageEnum languageEnum, int pageSize, int pageIndex)
{
return(supplierInfoDAL.GetStoreListByBrandId(brandId, areaId, languageEnum, pageSize, pageIndex));
}
