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)); }