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