public List <Budget_ConfigSite> SelectAll() { List <Budget_ConfigSite> configList = null; try { string sSQL = "SELECT * FROM ConfigSite"; DataSet ds = SqlHelper.ExecuteDataset(ConnectionString, CommandType.Text, sSQL); if (ds.Tables[0].Rows.Count > 0) { configList = new List <Budget_ConfigSite>(); Budget_ConfigSite config = null; for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { config = new Budget_ConfigSite(); config.ConfigKey = ds.Tables[0].Rows[i]["ConfigKey"].ToString(); config.ConfigValue = ds.Tables[0].Rows[i]["ConfigValue"].ToString(); configList.Add(config); } } } catch (Exception ex) { } return(configList); }
public Budget_ConfigSite SelectByConfigKey(string ConfigKey) { Budget_ConfigSite config = null; try { string sSQL = "SELECT * FROM ConfigSite WHERE ConfigKey=@ConfigKey"; SqlParameter[] sqlParam = new SqlParameter[1]; sqlParam[0] = new SqlParameter("@ConfigKey", SqlDbType.NVarChar); sqlParam[0].Value = ConfigKey; DataSet ds = SqlHelper.ExecuteDataset(ConnectionString, CommandType.Text, sSQL, sqlParam); if (ds.Tables[0].Rows.Count > 0) { config = new Budget_ConfigSite(); config.ConfigKey = ds.Tables[0].Rows[0]["ConfigKey"].ToString(); config.ConfigValue = ds.Tables[0].Rows[0]["ConfigValue"].ToString(); } } catch (Exception ex) { } return(config); }