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