public SysGlobalSettingEntity GetSysSettingEntity2()
{
DataTable dt = Db.ExecuteDataTable(" select * from Sys_GlobalSetting ");
if (dt == null || dt.Rows.Count == 0)
return null;
SysGlobalSettingEntity entity = new SysGlobalSettingEntity();
PropertyInfo[] pis = entity.GetType().GetProperties();
foreach (PropertyInfo pi in pis)
{
object[] attributes = pi.GetCustomAttributes(typeof (Field), false);
if (attributes.Length == 0)
continue;
Field theAttribute = (Field) attributes[0];
DataRow[] drs = dt.Select("SysKey='" + theAttribute.FieldName + "'");
if (drs.Length == 0)
continue;
pi.SetValue(entity, drs[0]["SysValue"], null);
}
return entity;
}
public void SaveSysSettingEntity(SysGlobalSettingEntity entity)
{
var sb = new StringBuilder();
sb.AppendLine(" delete from Sys_GlobalSetting ");
PropertyInfo[] pis = entity.GetType().GetProperties();
foreach (PropertyInfo pi in pis)
{
object[] attributes = pi.GetCustomAttributes(typeof (Field), false);
if (attributes.Length == 0)
continue;
Field theAttribute = (Field) attributes[0];
sb.AppendFormat(" insert into Sys_GlobalSetting values ('{0}','{1}') ", theAttribute.FieldName,
pi.GetValue(entity, null));
}
Db.ExecuteNonQuery(sb.ToString());
}
