public List <Budget_ContentOnPage> SelectByOID(Guid guidContentOID) { List <Budget_ContentOnPage> ContentOnPageList = null; try { string sSQL = "SELECT * FROM ContentOnPage WHERE ContentOID=@ContentOID"; SqlParameter[] sqlParam = new SqlParameter[1]; sqlParam[0] = new SqlParameter("@ContentOID", SqlDbType.UniqueIdentifier); sqlParam[0].Value = guidContentOID; DataSet ds = SqlHelper.ExecuteDataset(ConnectionString, CommandType.Text, sSQL, sqlParam); if (ds.Tables[0].Rows.Count > 0) { ContentOnPageList = new List <Budget_ContentOnPage>(); Budget_ContentOnPage content = null; for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { content = new Budget_ContentOnPage(); content.ContentOID = new Guid(ds.Tables[0].Rows[i]["ContentOID"].ToString()); content.Culture = ds.Tables[0].Rows[i]["Culture"].ToString(); content.CategoriesCode = ds.Tables[0].Rows[i]["ContentOnPage"].ToString(); content.ContentValue = ds.Tables[0].Rows[i]["ContentValue"].ToString(); ContentOnPageList.Add(content); } } } catch (Exception ex) { } return(ContentOnPageList); }
public Budget_ContentOnPage getContentOnPage(string sOnPage, string sCulture) { Budget_ContentOnPage content = null; try { string sSQL = "SELECT * FROM ContentOnPage WHERE ContentOnPage=@ContentOnPage AND Culture=@Culture"; SqlParameter[] sqlParam = new SqlParameter[2]; sqlParam[0] = new SqlParameter("@ContentOnPage", SqlDbType.NVarChar); sqlParam[0].Value = sOnPage; sqlParam[1] = new SqlParameter("@Culture", SqlDbType.NVarChar); sqlParam[1].Value = sCulture; DataSet ds = SqlHelper.ExecuteDataset(ConnectionString, CommandType.Text, sSQL, sqlParam); if (ds.Tables[0].Rows.Count > 0) { content = new Budget_ContentOnPage(); content.ContentOID = new Guid(ds.Tables[0].Rows[0]["ContentOID"].ToString()); content.Culture = ds.Tables[0].Rows[0]["Culture"].ToString(); content.CategoriesCode = ds.Tables[0].Rows[0]["ContentOnPage"].ToString(); content.ContentValue = ds.Tables[0].Rows[0]["ContentValue"].ToString(); } } catch (Exception ex) { } return(content); }
public List <Budget_ContentOnPage> SelectAll() { List <Budget_ContentOnPage> ContentOnPageList = null; try { string sSQL = "SELECT * FROM ContentOnPage"; DataSet ds = SqlHelper.ExecuteDataset(ConnectionString, CommandType.Text, sSQL); if (ds.Tables[0].Rows.Count > 0) { ContentOnPageList = new List <Budget_ContentOnPage>(); Budget_ContentOnPage content = null; for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { content = new Budget_ContentOnPage(); content.ContentOID = new Guid(ds.Tables[0].Rows[i]["ContentOID"].ToString()); content.Culture = ds.Tables[0].Rows[i]["Culture"].ToString(); content.CategoriesCode = ds.Tables[0].Rows[i]["ContentOnPage"].ToString(); content.ContentValue = ds.Tables[0].Rows[i]["ContentValue"].ToString(); ContentOnPageList.Add(content); } } } catch (Exception ex) { } return(ContentOnPageList); }