public IList <CountryModel> GetCountryList(Models.LanguageEnum languageVersion)
{
var sql = @"SELECT KeyName as CountryID
,KeyValue as CountryName
FROM dbo.Dics
WHERE LanguageVersion=@LanguageVersion and DicType='CountryOfManufacture'";
var db = DbSFO2OMain;
var parameters = db.CreateParameterCollection();
parameters.Append("LanguageVersion", (int)languageVersion);
return(db.ExecuteSqlList <Models.CountryModel>(sql, parameters));
}
public IList <Models.DicsModel> GetAllDicsInfo(Models.LanguageEnum languageVersion)
{
var sql = @"SELECT Id
,KeyName
,KeyValue
,DicType
,LanguageVersion
FROM Dics
WHERE LanguageVersion=@LanguageVersion";
var db = DbSFO2OMain;
var parameters = db.CreateParameterCollection();
parameters.Append("LanguageVersion", (int)languageVersion);
return(db.ExecuteSqlList <Models.DicsModel>(sql, parameters));
}
public IList <ProvinceModel> GetProvinceList(int countryId, Models.LanguageEnum languageVersion)
{
var sql = @"SELECT ID
,ProvinceId
,ProvinceName
,LanguageVersion
,CreateTime
FROM Province
WHERE LanguageVersion=@LanguageVersion and IsDelete=0 and ParentId=@ParentId";
var db = DbSFO2OMain;
var parameters = db.CreateParameterCollection();
parameters.Append("LanguageVersion", (int)languageVersion);
parameters.Append("ParentId", countryId);
return(db.ExecuteSqlList <Models.ProvinceModel>(sql, parameters));
}
public static IList <ProvinceModel> GetProvinceList(int countryId, Models.LanguageEnum languageEnum)
{
return(dal.GetProvinceList(countryId, languageEnum));
}
public static IList <CountryModel> GetCountryList(Models.LanguageEnum languageEnum)
{
return(dal.GetCountryList(languageEnum));
}
public PageOf <OrderListInfoModel> GetOrderList(Models.OrderQueryInfo queryInfo, Models.PageDTO page, Models.LanguageEnum languageVersion, int receiptCountry)
{
return(dal.GetOrderList(queryInfo, page, languageVersion, receiptCountry));
}
public PageOf <StoreModel> GetStoreListByBrandId(int brandId, int areaId, Models.LanguageEnum languageEnum, PageDTO page)
{
return(dal.GetStoreListByBrandId(brandId, areaId, languageEnum, page));
}
public IList <ProductBrandModel> GetBrandBySupplierId(int supplierId, Models.LanguageEnum languageEnum)
{
return(dal.GetBrandBySupplierId(supplierId, languageEnum));
}
