private void SystemSetting_Load(object sender, EventArgs e)
{
label18.ForeColor = Color.Red;
label2.ForeColor = Color.LightBlue;
//填充数据
SystemSet ss = null;
if (GlobalPars.GloPars.ContainsKey("systemset"))
{
ss = (SystemSet)GlobalPars.GloPars["systemset"];
}
else
{
string sql = "select Id,EvidenceImgSavePath from systemset";
DataTable dt = cmd.GetTabel(sql);
ss = new SystemSet();
ss.Id = dt.Rows[0]["Id"].ToString();
ss.EvidenceImgSavePath = dt.Rows[0]["EvidenceImgSavePath"].ToString();
GlobalPars.GloPars.Add("systemset", ss);
}
tb_choosedimgpath.Text = ss.EvidenceImgSavePath;
}
/// <summary>
/// 生成缓存数据
/// </summary>
private void GenCacheData()
{
//以下缓存报警信息
DataBaseServer.MySqlCmd dbobj = new DataBaseServer.MySqlCmd();
string sql = "select Id,EvidenceImgSavePath from systemset";
DataTable dt = dbobj.GetTabel(sql);
SystemSet ss = new SystemSet();
if (dt != null && dt.Rows.Count > 0)
{
ss.Id = dt.Rows[0]["Id"].ToString();
string path = dt.Rows[0]["EvidenceImgSavePath"].ToString();
if (!Path.IsPathRooted(path))
{
path = Path.GetFullPath(path);
}
ss.EvidenceImgSavePath = path;
}
else
{
//向数据库插入一条数据
string path = Path.Combine(Directory.GetCurrentDirectory(), "EvidenceImgSavePath");
if (!Directory.Exists(path))
{
Directory.CreateDirectory(path);
}
sql = "insert into systemset values('1', 'EvidenceImgSavePath')";
if (dbobj.ExecuteNonQueryInt(sql) > 0)
{
ss.Id = "1";
ss.EvidenceImgSavePath = path;
}
}
GlobalPars.GloPars.Add("systemset", ss);
}
