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);
