protected void Button1_Click(object sender, EventArgs e) { sys_SystemInfoTable st = FrameSystemInfo.GetSystemInfoTable; st.DB_Option_Action_ = "Update"; sys_ConfigDataTable dt = new sys_ConfigDataTable(); dt.C_RequestLog = Convert.ToBoolean((string)Common.sink(ddl_C_RequestLog.UniqueID, MethodType.Post, 5, 1, DataType.Str)); dt.C_UpImgHeight = (int)Common.sink(tb_C_UpImgHeight.UniqueID, MethodType.Post, 255, 1, DataType.Int); dt.C_UpImgWidth = (int)Common.sink(tb_C_UpImgWidth.UniqueID, MethodType.Post, 255, 1, DataType.Int); dt.C_IPLookUrl = (string)Common.sink(tb_C_IPLookUrl.UniqueID, MethodType.Post, 255, 1, DataType.Str); dt.C_UploadFileExt = (string)Common.sink(tb_C_UploadFileExt.UniqueID, MethodType.Post, 255, 1, DataType.Str); dt.C_UploadSizeKb = (int)Common.sink(tb_C_UploadSizeKb.UniqueID, MethodType.Post, 255, 1, DataType.Int); dt.C_LoginErrorDisableMinute = (int)Common.sink(tb_C_LoginErrorDisableMinute.UniqueID, MethodType.Post, 255, 1, DataType.Int); dt.C_LoginErrorMaxNum = (int)Common.sink(tb_C_LoginErrorMaxNum.UniqueID, MethodType.Post, 255, 1, DataType.Int); dt.C_HttpGZip = Convert.ToBoolean((string)Common.sink(ddl_C_HttpGZip.UniqueID, MethodType.Post, 5, 1, DataType.Str)); dt.C_UploadPath = (string)Common.sink(tb_C_UploadPath.UniqueID, MethodType.Post, 255, 1, DataType.Str); dt.C_CheckUpdate = Convert.ToBoolean((string)Common.sink(ddl_C_CheckUpdate.UniqueID, MethodType.Post, 5, 1, DataType.Str)); dt.C_DisableIp = (string)Common.sink(tb_C_DisableIp.UniqueID, MethodType.Post, 2000, 0, DataType.Str); dt.C_Enable_Ldap = Convert.ToBoolean((string)Common.sink(ddl_C_Enable_Ldap.UniqueID, MethodType.Post, 5, 1, DataType.Str)); dt.C_Ldap_Path = (string)Common.sink(tb_C_Ldap_Path.UniqueID, MethodType.Post, 200, 0, DataType.Str); dt.C_Ldap_Domain = (string)Common.sink(tb_C_Ldap_Domain.UniqueID, MethodType.Post, 200, 0, DataType.Str); st.S_Name = (string)Common.sink(tb_S_Name.UniqueID, MethodType.Post, 255, 1, DataType.Str); st.S_Version = (string)Common.sink(tb_S_Version.UniqueID, MethodType.Post, 20, 1, DataType.Str); st.S_SystemConfigData = dt; BusinessFacade.sys_SystemInfoInsertUpdate(st); EventMessage.MessageBox(1, "修改环境配置", "修改环境配置成功!", Icon_Type.OK, Common.GetHomeBaseUrl("default.aspx")); }
/// <summary> /// 构造函数 /// </summary> static FrameSystemInfo() { if (GetSystemInfoTable == null) { sys_SystemInfoTable si = new sys_SystemInfoTable(); QueryParam qp = new QueryParam(); qp.PageIndex = 1; qp.PageSize = 1; qp.OrderType = 0; int Recount = 0; ArrayList lst = BusinessFacade.sys_SystemInfoList(qp, out Recount); if (Recount == 0) { si.DB_Option_Action_ = "Insert"; si.SystemID = BusinessFacade.sys_SystemInfoInsertUpdate(si); } else { si = lst[0] as sys_SystemInfoTable; //更新新加配置 sys_ConfigDataTable sys_ConfigDB = si.S_SystemConfigData; sys_ConfigDataTable sys_Config = new sys_ConfigDataTable(); //foreach (PropertyInfo pi in new sys_ConfigDataTable().GetType().GetProperties(BindingFlags.Public | BindingFlags.NonPublic | BindingFlags.Instance)) foreach (PropertyInfo pi in sys_ConfigDB.GetType().GetProperties(BindingFlags.Public | BindingFlags.NonPublic | BindingFlags.Instance)) { if (pi.GetValue(sys_ConfigDB, null) == null) { pi.SetValue(sys_ConfigDB, pi.GetValue(sys_Config, null), null); } } //从Dll中更新版本 //sys_FrameWorkInfoTable sys_Db = si.S_FrameWorkInfo; //sys_FrameWorkInfoTable sys_Dll = new sys_FrameWorkInfoTable(); //foreach (PropertyInfo pi in sys_Db.GetType().GetProperties(BindingFlags.Public | BindingFlags.NonPublic | BindingFlags.Instance)) //{ // if (pi.Name != "S_Licensed") // { // pi.SetValue(sys_Db, pi.GetValue(sys_Dll, null), null); // } //} } GetSystemInfoTable = si; } FrameWorkPermission.InitStat = true; }
/// <summary> /// 将记录集转为sys_SystemInfoTable实体类 /// </summary> /// <param name="dr">记录集</param> /// <returns>sys_SystemInfoTable</returns> protected object Populatesys_SystemInfo(IDataReader dr) { sys_SystemInfoTable nc = new sys_SystemInfoTable(); if (!Convert.IsDBNull(dr["SystemID"])) { nc.SystemID = Convert.ToInt32(dr["SystemID"]); // 自动ID } if (!Convert.IsDBNull(dr["S_Name"])) { nc.S_Name = Convert.ToString(dr["S_Name"]).Trim(); // 系统名称 } if (!Convert.IsDBNull(dr["S_Version"])) { nc.S_Version = Convert.ToString(dr["S_Version"]).Trim(); // 版本号 } if (!Convert.IsDBNull(dr["S_Licensed"])) { nc.S_Licensed = Convert.ToString(dr["S_Licensed"]).Trim(); // 序列号 } if (!Convert.IsDBNull(dr["S_SystemConfigData"])) { nc.S_SystemConfigData = FrameSystemInfo.Deserialize_sys_ConfigDataTable((byte[])dr["S_SystemConfigData"]); // 系统配置信息 } if (nc.S_SystemConfigData.C_UploadSizeKb == 0) { nc.S_SystemConfigData.C_UploadSizeKb = 512; } if (nc.S_SystemConfigData.C_LoginErrorDisableMinute == 0) { nc.S_SystemConfigData.C_LoginErrorDisableMinute = 30; } if (nc.S_SystemConfigData.C_LoginErrorMaxNum == 0) { nc.S_SystemConfigData.C_LoginErrorMaxNum = 5; } return(nc); }
/// <summary> /// 新增/删除/修改 sys_SystemInfo /// </summary> /// <param name="fam">sys_SystemInfoTable实体类</param> /// <returns>返回0操正常</returns> public override int sys_SystemInfoInsertUpdate(sys_SystemInfoTable fam) { int rInt = 0; using (SqlConnection Conn = GetSqlConnection()) { SqlCommand cmd = new SqlCommand("sys_SystemInfoInsertUpdateDelete", Conn); cmd.CommandType = CommandType.StoredProcedure; //设置参数 cmd.Parameters.Add("@DB_Option_Action_", SqlDbType.NVarChar).Value = fam.DB_Option_Action_; //操作方法 Insert:增加 Update:修改 Delete:删除 Disp:显示单笔记录 cmd.Parameters.Add("@SystemID", SqlDbType.Int).Value = fam.SystemID; //自动ID cmd.Parameters.Add("@S_Name", SqlDbType.NVarChar).Value = fam.S_Name; //系统名称 cmd.Parameters.Add("@S_Version", SqlDbType.NVarChar).Value = fam.S_Version; //版本号 cmd.Parameters.Add("@S_Licensed", SqlDbType.VarChar).Value = fam.S_Licensed; //序列号 cmd.Parameters.Add("@S_SystemConfigData", SqlDbType.Image).Value = FrameSystemInfo.Serializable_sys_ConfigDataTable(fam.S_SystemConfigData); //系统配置信息 Conn.Open(); rInt = Convert.ToInt32(cmd.ExecuteScalar()); cmd.Dispose(); Conn.Dispose(); Conn.Close(); } return(rInt); }
/// <summary> /// 新增/删除/修改 sys_SystemInfo /// </summary> /// <param name="fam">sys_SystemInfoTable实体类</param> /// <returns>返回0操正常</returns> public abstract int sys_SystemInfoInsertUpdate(sys_SystemInfoTable fam);