public Core.Business.SystemSetting Select(String id)
{
SqlServerUtility sql = new SqlServerUtility(connectionString);
sql.AddParameter("@Key", SqlDbType.NVarChar, id);
SqlDataReader reader = sql.ExecuteSPReader("USP_SysSetting_Select_By_Id");
if (reader != null && !reader.IsClosed && reader.Read())
{
Core.Business.SystemSetting systemSetting = new Core.Business.SystemSetting();
if (!reader.IsDBNull(0)) systemSetting.Id = reader.GetString(0);
if (!reader.IsDBNull(1)) systemSetting.Value = reader.GetString(1);
reader.Close();
return systemSetting;
}
else
{
if (reader != null && !reader.IsClosed)
reader.Close();
return null;
}
}
protected void Button1_Click(object sender, EventArgs e)
{
CY.UME.Core.Business.SystemSetting ss = new Core.Business.SystemSetting();
ss.Id = TextBox1.Text;
ss.Value = TextBox2.Text;
ss.Save();
}
public IList<Core.Business.SystemSetting> GetAllSystemSetting()
{
IList<Core.Business.SystemSetting> systemSettinglist = new List<Core.Business.SystemSetting>();
SqlServerUtility sql = new SqlServerUtility(connectionString);
SqlDataReader reader = sql.ExecuteSPReader("USP_SysSetting_SelectAll");
if (reader != null)
{
while (reader.Read())
{
Core.Business.SystemSetting systemSetting = new Core.Business.SystemSetting();
if (!reader.IsDBNull(0)) systemSetting.Id = reader.GetString(0);
if (!reader.IsDBNull(1)) systemSetting.Value = reader.GetString(1);
systemSetting.MarkOld();
systemSettinglist.Add(systemSetting);
}
reader.Close();
}
return systemSettinglist;
}
