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()); }
private SysGlobalSettingEntity PrepareFormData() { //校验参数的合法性 txtSysName.Text.InitValidation("系统名称").NotEmpty(); txtSysDescription.Text.InitValidation("系统说明").NotEmpty(); txtErrorPage.Text.InitValidation("错误页面").NotEmpty(); txtBuildingPage.Text.InitValidation("建设页面").NotEmpty(); txtSuperAdmins.Text.InitValidation("超级管理员").NotEmpty(); txtErrorLogPath.Text.InitValidation("错误日志路径").NotEmpty(); txtGridviewPageSize.Text.InitValidation("默认分页数").IsNum().LargerThan(5); var entity = new SysGlobalSettingEntity(); entity.SysName = txtSysName.Text; entity.SysDescription = txtSysDescription.Text; entity.ErrorPage = txtErrorPage.Text; entity.BuildingPage = txtBuildingPage.Text; entity.ErrorLogPath = txtErrorLogPath.Text; entity.SuperAdmins = txtSuperAdmins.Text; entity.GridViewPageSize = txtGridviewPageSize.Text; return entity; }
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 ExcuteResultEnum UpdateSysSettingEntity(SysGlobalSettingEntity entity) { SaveSysSettingEntity(entity); DataCache.SetCache(CacheKey, entity); return ExcuteResultEnum.Success; }