private void Record() { string sql = "insert into RecordTest (Red,Black,TestValue,TestTime,ValueType,TestID,IsLine) values ('" + RbValue.BaseValue + "','" + BbValue.BaseValue + "','" + TipValue + "','" + DateTime.Now.ToLocalTime().ToString() + "','" + ValueType + "','" + Manager.GetInstance().User.PracticID + "','" + Manager.GetInstance().Car.IsLine + "')"; AccessHelper.GetInstance().ExcuteSql(sql); string eName = ""; if (Target != null && RbValue.BaseValue != "0" && BbValue.BaseValue != "0") { eName = (string)Target["LineName"] + " "; } sql = "insert into SubmitReport (ID,Oper,SubMit,TestID) values ('" + DateTime.Now.ToLocalTime().ToString() + "','" + "测量元件" + "','" + eName + "电压值:" + TipValue + "','" + Manager.GetInstance().User.PracticID + "')"; AccessHelper.GetInstance().ExcuteSql(sql); }
private void ItemChecked(object sender, ItemCheckedEventArgs e) { ListViewItem lvi = e.Item; if (lvi.Checked) { if (Manager.GetInstance().SelectSubjects.Count >= Manager.GetInstance().SubjectRows.Length) { lvi.Checked = false; MessageBox.Show("答案个数已超过故障数", "虚拟仿真教学-卡罗拉", MessageBoxButtons.OK, MessageBoxIcon.Warning, MessageBoxDefaultButton.Button1); return; } string sql = "insert into RecordOper (OPeration,TestID,OperTime) values ('" + lvi.SubItems[3].Text + "','" + Manager.GetInstance().User.PracticID + "','" + DateTime.Now.ToLocalTime().ToString() + "')"; AccessHelper.GetInstance().ExcuteSql(sql); Manager.GetInstance().SelectSubjects.Add((int)lvi.Tag); } else { Manager.GetInstance().SelectSubjects.Remove((int)lvi.Tag); } }
private void InitData() { if (listViewDATA.Items.Count > 0) { return; } dataRows = AccessHelper.GetInstance().GetDataTableFromDB("SELECT * FROM zdy ORDER BY ID").Select(); UpdateData(); DataRow[] rows = AccessHelper.GetInstance().GetDataTableFromDB("SELECT * FROM GzInfo").Select(); for (int i = 0; i < rows.Length; i++) { if (rows[i]["Choice"].ToString() == "选择") { ListViewItem lvi = new ListViewItem(); lvi.Text = (string)rows[i]["DTID"]; lvi.SubItems.Add((string)rows[i]["DTC"]); this.listViewDTC.Items.Add(lvi); } } Timer timer = new Timer(); //实例化Timer类,设置间隔时间为10000毫秒; timer.Enabled = true; //是否执行System.Timers.Timer.Elapsed事件; timer.Tick += new EventHandler(UpdateTimerMethod); //到达时间的时候执行事件 timer.Interval = 1000; }
private void Init() { DataTable dataTable = AccessHelper.GetInstance().GetDataTableFromDB("SELECT * FROM GzInfo ORDER BY GZID"); DataRow[] dataRows = dataTable.Select(); listView1.BeginUpdate(); //数据更新,UI暂时挂起,直到EndUpdate绘制控件,可以有效避免闪烁并大大提高加载速度 for (int i = 0; i < dataRows.Length; i++) //添加10行数据 { ListViewItem lvi = new ListViewItem(); lvi.Text = ""; lvi.SubItems.Add((string)dataRows[i]["DTID"]); lvi.SubItems.Add((string)dataRows[i]["EName"]); lvi.SubItems.Add((string)dataRows[i]["GZName"]); lvi.SubItems.Add((string)dataRows[i]["XF"]); lvi.Tag = (int)dataRows[i]["GZID"]; if (Manager.GetInstance().SelectSubjects.Contains((int)dataRows[i]["GZID"])) { lvi.Checked = true; } listView1.Items.Add(lvi); } listView1.EndUpdate(); //结束数据处理,UI界面一次性绘制。 }
private void ExcuteOper(string operID, string eID) { DataTable dataTable = AccessHelper.GetInstance().GetDataTableFromDB("SELECT * FROM Element WHERE ID ='" + eID + "'"); DataRow[] rows = dataTable.Select(); string oper = GetOperName(operID); string sql = "insert into RecordOper (EID,OPeration,TestID,OperTime,Ename) values ('" + eID + "','" + oper + "','" + Manager.GetInstance().User.PracticID + "','" + DateTime.Now.ToLocalTime().ToString() + "','" + rows[0]["Ename"] + "')"; AccessHelper.GetInstance().ExcuteSql(sql); sql = "insert into SubmitReport (ID,Ename,Oper,TestID) values ('" + DateTime.Now.ToLocalTime().ToString() + "','" + rows[0]["Ename"] + "','" + oper + "','" + Manager.GetInstance().User.PracticID + "')"; AccessHelper.GetInstance().ExcuteSql(sql); }
private void ExcuteWGCZ(string id) { if (id == "") { return; } Manager.GetInstance().User.AddWgczCount(); DataTable dataTable = AccessHelper.GetInstance().GetDataTableFromDB("SELECT * FROM WGCZ WHERE ID =" + id); DataRow[] rows = dataTable.Select(); string sql = "insert into RecordOper (OPeration,TestID,OperTime,wgcz,Ename) values ('" + rows[0]["Dist"] + "','" + Manager.GetInstance().User.PracticID + "','" + DateTime.Now.ToLocalTime().ToString() + "','" + 1 + "','" + rows[0]["Ename"] + "')"; AccessHelper.GetInstance().ExcuteSql(sql); sql = "insert into SubmitReport (ID,Ename,Oper,wgcz,TestID) values ('" + DateTime.Now.ToLocalTime().ToString() + "','" + rows[0]["Ename"] + "','" + rows[0]["Dist"] + "','" + 1 + "','" + Manager.GetInstance().User.PracticID + "')"; AccessHelper.GetInstance().ExcuteSql(sql); }
private void Exit() { DialogResult dr; dr = MessageBox.Show("您真的要退出系统吗?", "虚拟仿真教学-卡罗拉", MessageBoxButtons.YesNo, MessageBoxIcon.Warning, MessageBoxDefaultButton.Button1); if (dr == DialogResult.Yes) { AccessHelper.GetInstance().Release(); Environment.Exit(0); } }
private void InitData() { DataRow[] rows = AccessHelper.GetInstance().GetDataTableFromDB("SELECT * FROM zdy").Select(); for (int i = 0; i < rows.Length; i++) { ListViewItem lvi = new ListViewItem(); if (rows[i]["Choice"].GetType().Name == "DBNull") { lvi.Text = " "; } else { lvi.Text = (string)rows[i]["Choice"]; } lvi.SubItems.Add((string)rows[i]["ProName"]); lvi.SubItems.Add((string)rows[i]["PValues"]); if (rows[i]["Units"].GetType().Name == "DBNull") { lvi.SubItems.Add(" "); } else { lvi.SubItems.Add((string)rows[i]["Units"]); } this.listView1.Items.Add(lvi); } rows = AccessHelper.GetInstance().GetDataTableFromDB("SELECT * FROM GzInfo").Select(); for (int i = 0; i < rows.Length; i++) { if (rows[i]["Choice"].ToString() == "选择") { string id = (string)rows[i]["DTID"]; string value = (string)rows[i]["DTC"]; this.listBox1.Items.Add(id + " " + value); } } }
private void Record(string id, string value) { string sql = "insert into RecordZdy (ElementName,EValue,TestTime,TestID) values ('" + id + "','" + value + "','" + DateTime.Now.ToLocalTime().ToString() + "','" + Manager.GetInstance().User.PracticID + "')"; AccessHelper.GetInstance().ExcuteSql(sql); sql = "insert into SubmitReport (ID,Ename,Oper,TestID) values ('" + DateTime.Now.ToLocalTime().ToString() + "','" + "诊断仪记录:" + "','" + id + ":" + value + "','" + Manager.GetInstance().User.PracticID + "')"; AccessHelper.GetInstance().ExcuteSql(sql); }
public void FlashFlashCommand(object sender, AxShockwaveFlashObjects._IShockwaveFlashEvents_FSCommandEvent e) { if (e.command == "power" || e.command == "sc" || e.command == "youmeng" || e.command == "speed") { if (BbValue.BaseValue != "" && RbValue.BaseValue != "") { UpdateRBValue(); } } else if (e.command == "vt") { ValueType = int.Parse(e.args); SetTipValue(0); if (ValueType == 1) { if (BbValue.BaseValue != "" && RbValue.BaseValue != "") { UpdateRBValue(); } } if (ValueType == 0) { StopTime(); } else { StartTime(); } } else if (e.command == "BB") { if (e.args != "") { BbValue.BaseValue = e.args; UpdateRBValue(); } else { BbValue.Reset(); SetTipValue(0); } } else if (e.command == "RB") { if (e.args != "") { RbValue.BaseValue = e.args; UpdateRBValue(); } else { RbValue.Reset(); SetTipValue(0); } } else if (e.command == "ZL") { Record(); } else if (e.args == "ZXJC" || e.args == "JC") { DataTable dataTable = AccessHelper.GetInstance().GetDataTableFromDB("SELECT * FROM Element WHERE ID ='" + e.command + "'"); DataRow[] rows = dataTable.Select(); Target = rows[0]; } ShowValue(); }