public Budget_BannerConfig SelectByCategoriesCode(string CategoriesCode) { Budget_BannerConfig banner = null; try { string sSQL = @"SELECT [Categories_Banner].CategoriesCode,[Categories_Banner].CategoriesName ,[BannerConfig].BannerOID,[BannerConfig].BannerFileName,[BannerConfig].BannerURL,[BannerConfig].BannerTitle FROM [Categories_Banner] LEFT JOIN [BannerConfig] ON [Categories_Banner].CategoriesCode =[BannerConfig].CategoriesCode WHERE [Categories_Banner].CategoriesCode=@CategoriesCode"; SqlParameter[] sqlParam = new SqlParameter[1]; sqlParam[0] = new SqlParameter("@CategoriesCode", SqlDbType.NVarChar); sqlParam[0].Value = CategoriesCode; DataSet ds = SqlHelper.ExecuteDataset(ConnectionString, CommandType.Text, sSQL, sqlParam); if (ds != null && ds.Tables[0].Rows.Count > 0) { banner = new Budget_BannerConfig(); banner.CategoriesCode = ds.Tables[0].Rows[0]["CategoriesCode"].ToString(); banner.CategoriesName = ds.Tables[0].Rows[0]["CategoriesName"].ToString(); banner.BannerOID = (ds.Tables[0].Rows[0]["BannerOID"].Equals(DBNull.Value) == false) ? new Guid(ds.Tables[0].Rows[0]["BannerOID"].ToString()) : Guid.Empty; banner.BannerFileName = (ds.Tables[0].Rows[0]["BannerFileName"].Equals(DBNull.Value) == false) ? ds.Tables[0].Rows[0]["BannerFileName"].ToString() : ""; banner.BannerURL = (ds.Tables[0].Rows[0]["BannerURL"].Equals(DBNull.Value) == false) ? ds.Tables[0].Rows[0]["BannerURL"].ToString() : ""; banner.BannerTitle = (ds.Tables[0].Rows[0]["BannerTitle"].Equals(DBNull.Value) == false) ? ds.Tables[0].Rows[0]["BannerTitle"].ToString() : ""; } } catch (Exception ex) { } return(banner); }
public List <Budget_BannerConfig> SelectAll() { List <Budget_BannerConfig> BannerConfigList = null; try { string sSQL = @"SELECT [Categories_Banner].CategoriesCode,[Categories_Banner].CategoriesName ,[BannerConfig].BannerOID,[BannerConfig].BannerFileName,[BannerConfig].BannerURL,[BannerConfig].BannerTitle ,[ContentOnPage].* FROM [Categories_Banner] LEFT JOIN [BannerConfig] ON [Categories_Banner].CategoriesCode =[BannerConfig].CategoriesCode LEFT JOIN [ContentOnPage] ON [BannerConfig].CategoriesCode = [ContentOnPage].ContentOnPage AND [ContentOnPage].Culture = 'en'"; DataSet ds = SqlHelper.ExecuteDataset(ConnectionString, CommandType.Text, sSQL); if (ds.Tables[0].Rows.Count > 0) { BannerConfigList = new List <Budget_BannerConfig>(); Budget_BannerConfig banner = new Budget_BannerConfig(); for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { banner = new Budget_BannerConfig(); banner.CategoriesCode = ds.Tables[0].Rows[i]["CategoriesCode"].ToString(); banner.CategoriesName = ds.Tables[0].Rows[i]["CategoriesName"].ToString(); banner.BannerOID = (ds.Tables[0].Rows[i]["BannerOID"].Equals(DBNull.Value) == false) ? new Guid(ds.Tables[0].Rows[i]["BannerOID"].ToString()) : Guid.Empty; banner.BannerFileName = (ds.Tables[0].Rows[i]["BannerFileName"].Equals(DBNull.Value) == false) ? ds.Tables[0].Rows[i]["BannerFileName"].ToString() : ""; banner.BannerURL = (ds.Tables[0].Rows[i]["BannerURL"].Equals(DBNull.Value) == false) ? ds.Tables[0].Rows[i]["BannerURL"].ToString() : ""; banner.BannerTitle = (ds.Tables[0].Rows[i]["BannerTitle"].Equals(DBNull.Value) == false) ? ds.Tables[0].Rows[i]["BannerTitle"].ToString() : ""; banner.ContentOID = (ds.Tables[0].Rows[i]["ContentOID"].Equals(DBNull.Value) == false) ? ds.Tables[0].Rows[i]["ContentOID"].ToString() : ""; banner.ContentValue = (ds.Tables[0].Rows[i]["ContentValue"].Equals(DBNull.Value) == false) ? ds.Tables[0].Rows[i]["ContentValue"].ToString() : ""; BannerConfigList.Add(banner); } } } catch (Exception ex) { } return(BannerConfigList); }