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