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