//对应菜单项删除考生事件处理
public void Menu_del(int devnum, string zkzhm)
{
CStudent stu = model.devmanager.GetStudent(devnum, zkzhm);
if (stu != null)
{
DisplayStrings.DeleteString(stu.DisplayString(devnum));
}
model.devmanager.DeleteStudent(devnum, zkzhm);
mainform.UpdateStudentlist(devnum, (CStuDevlist)model.devmanager.DevList[devnum]);
CStudent stu2and3;
for (int i = 1; i < 3; i++)
{
stu2and3 = model.devmanager.GetStudent(devnum, i);
if (stu2and3 != null)
{
DisplayStrings.AddString(stu2and3.DisplayString(devnum), "排队");
}
else
{
break;
}
}
//displaycomm.ShowText(DisplayStrings.GetAllStrings());
//删除对应的远端设备列表中的排队考生
CNetData tmpdata = new CNetData();
tmpdata.cmdCommand = Command.DeleteStudent;
tmpdata.intDevnum = devnum;
tmpdata.strZjbh = zkzhm;
Server.SendData(devnum, tmpdata);
}
private void buttonX2_Click(object sender, EventArgs e)
{
initlabel();
Inputstudent = null;
buttonX1.Enabled = false;
comboBox1.Text = model.devmanager.GetMinnum().ToString();
}
//将数据存入本地的drv_preasign数据表中
public bool SaveStudent(CStudent student)
{
string sqlstr = "delete from drv_preasign where ZKZMBH='" + student.zkzmbh.Trim() + "'";
SqlCommand cmd = new SqlCommand(sqlstr, sqlconn);
try
{
cmd.ExecuteNonQuery();
}
catch
{
}
sqlstr = "insert into drv_preasign (LSH,ZKZMBH,SFZMHM,XM,KSCX,JBR,YYRQ,KSCS,ZT) values (@LSH,@ZKZMBH,@SFZMHM,@XM,@KSCX,@JBR,@YYRQ,@KSCS,@ZT)";
cmd.CommandText = sqlstr;
cmd.Parameters.Add("@LSH", SqlDbType.NVarChar, 11).Value = student.lsh;
cmd.Parameters.Add("@ZKZMBH", SqlDbType.NVarChar, 12).Value = student.zkzmbh;
cmd.Parameters.Add("@SFZMHM", SqlDbType.NVarChar, 18).Value = student.sfzmhm;
cmd.Parameters.Add("@XM", SqlDbType.NVarChar, 30).Value = student.xm;
cmd.Parameters.Add("@KSCX", SqlDbType.NVarChar, 2).Value = student.kscx;
cmd.Parameters.Add("@JBR", SqlDbType.NVarChar, 30).Value = student.jbr;
cmd.Parameters.Add("@YYRQ", SqlDbType.SmallDateTime, 4).Value = student.yyrq;
cmd.Parameters.Add("@KSCS", SqlDbType.SmallInt, 2).Value = student.kscs;
cmd.Parameters.Add("@ZT", SqlDbType.NVarChar, 1).Value = student.zt;
cmd.ExecuteNonQuery();
cmd.Dispose();
return(true);
}
//public bool RemoteDBlink() //远程数据连接
//{
// oraconn = new OracleConnection();
// oraconn.ConnectionString = "Data Source=oraclelan;Persist Security Info=True;User ID=DRV_KM2;Password=cgcsxb;Unicode=True";
// try
// {
// oraconn.Open();
// OracleCommand oracmd = new OracleCommand("select count(*) from \"DRV_KM2\".\"drv_preasign\"");
// oracmd.Connection = oraconn;
// _remotedbnum=Convert.ToInt16(oracmd.ExecuteScalar());
// }
// catch
// {
// _event_oraclelink(false);
// return false;
// }
// _event_oraclelink(true);
// return true;
//}
//从远程的oracle数据库中读取考生信息
public CStudent FindStudent(string zjhm)
{
string sqlstr = null;
CStudent student = new CStudent();
switch (zjhm.Length)
{
case 11: //流水号
sqlstr = "select * from [dbo].[drv_preasign] where LSH='" + zjhm.Trim() + "'";
break;
case 12: //准考证
sqlstr = "select * from [dbo].[drv_preasign] where ZKZMBH='" + zjhm.Trim() + "'";
break;
default: //身份证军官证等
sqlstr = "select * from [dbo].[drv_preasign] where SFZMHM='" + zjhm.Trim() + "'";
break;
}
//OracleCommand oracmd = new OracleCommand(sqlstr);
//oracmd.Connection = oraconn;
//OracleDataReader dr = oracmd.ExecuteReader();
SqlCommand sqlcmd = new SqlCommand(sqlstr, rmtSqlconn);
SqlDataReader dr = sqlcmd.ExecuteReader();
try
{
if (dr.Read())
{
student.xm = dr["XM"].ToString();
student.sfzmhm = dr["SFZMHM"].ToString();
student.zkzmbh = dr["ZKZMBH"].ToString();
student.kscs = Convert.ToInt16(dr["KSCS"]);
student.kscx = dr["KSCX"].ToString();
student.lsh = dr["LSH"].ToString();
student.jbr = dr["JBR"].ToString();
student.yyrq = (DateTime)dr["YYRQ"];
student.zt = dr["ZT"].ToString();
dr.Close();
dr.Dispose();
return(student);
}
}
catch
{
System.Windows.Forms.MessageBox.Show("搜索考生时数据库出错！");
}
dr.Close();
dr.Dispose();
return(null);
}
private void Server_Event_Devlogout(int devnum)
{
CStuDevlist tmpDevList = (CStuDevlist)(model.devmanager.DevList[devnum]);
if (tmpDevList == null)
{
return;
}
for (int i = 0; i < ((CStuDevlist)(model.devmanager.DevList[devnum])).Stumum; i++)
{
CStudent stu = model.devmanager.GetStudent(devnum, i);
if (stu != null)
{
DisplayStrings.DeleteString(stu.DisplayString(devnum));
}
}
//displaycomm.ShowText(DisplayStrings.GetAllStrings());
mainform.ReUpdateStuColor(devnum);
mainform.ChangeDevStatus(devnum, DevStatus.未连接);
}
//对应菜单项清除所有考生事件处理
public void Menu_clear(int devnum)
{
for (int i = 0; i < ((CStuDevlist)(model.devmanager.DevList[devnum])).Stumum; i++)
{
CStudent stu = model.devmanager.GetStudent(devnum, i);
if (stu != null)
{
DisplayStrings.DeleteString(stu.DisplayString(devnum));
}
}
//displaycomm.ShowText(DisplayStrings.GetAllStrings());
model.devmanager.ClearStudent(devnum);
mainform.UpdateStudentlist(devnum, (CStuDevlist)model.devmanager.DevList[devnum]);
//清除对应的远端设备列表中的排队考生
CNetData tmpdata = new CNetData();
tmpdata.cmdCommand = Command.ClearStudent;
tmpdata.intDevnum = devnum;
Server.SendData(devnum, tmpdata);
}
private void textBoxX1_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.Enter)
{
Inputstudent = null;
if (textBoxX1.Text != string.Empty)
{
Inputstudent = model.FindStudent(textBoxX1.Text);
if (Inputstudent != null)
{
label_xm.Text = "姓名：" + Inputstudent.xm;
label_lsh.Text = "流水号：" + Inputstudent.lsh;
label_zkzhm.Text = "准考证：" + Inputstudent.zkzmbh;
label_sfzhm.Text = "身份证：" + Inputstudent.sfzmhm;
label_kscx.Text = "考试车型：" + Inputstudent.kscx;
label_kscs.Text = "考试次数：" + Inputstudent.kscs.ToString();
buttonX1.Enabled = true;
buttonX1.Focus();
}
}
}
}
private void buttonX1_Click_1(object sender, EventArgs e)
{
int redevnum = model.devmanager.FindStudent(Inputstudent.zkzmbh);
if (redevnum > 0)
{
MessageBox.Show("考生（" + Inputstudent.xm + "）已经在设备" + redevnum.ToString() + "中排队了！");
initlabel();
Inputstudent = null;
buttonX1.Enabled = false;
comboBox1.Text = model.devmanager.GetMinnum().ToString();
return;
}
//给devmanager设备列表增加考生
((CStuDevlist)model.devmanager.DevList[int.Parse(comboBox1.Text)]).AddStudent(Inputstudent);
ViewManage.UpdateStudentlist(int.Parse(comboBox1.Text), ((CStuDevlist)model.devmanager.DevList[int.Parse(comboBox1.Text)]));
model.SaveStudent(Inputstudent);
//************************************
CNetData tmpdata = new CNetData();
tmpdata.cmdCommand = Command.AddStudent;
tmpdata.intDevnum = int.Parse(comboBox1.Text);
tmpdata.strZjbh = Inputstudent.zkzmbh;
tmpdata.Xm = Inputstudent.xm;
ctrl.Server.SendData(int.Parse(comboBox1.Text), tmpdata);
//************************************
initlabel();
Inputstudent = null;
buttonX1.Enabled = false;
comboBox1.Text = model.devmanager.GetMinnum().ToString();
textBoxX1.Focus();
}
public void RemoveStudent(CStudent student)
{
StudentList.Remove(student);
}
public void AddStudent(CStudent student)
{
StudentList.Add(student);
}
public ShowStudentInfo_Form(CStudent student)
{
InitializeComponent();
this.student = student;
}
private void Server_Event_Devnetdata(CNetData data)
{
CNetData tmpdata = new CNetData();
switch (data.cmdCommand)
{
case Command.GetStudent:
CStudent stu = model.devmanager.GetStudent(data.intDevnum);
if (stu != null)
{
tmpdata.Clear();
tmpdata.cmdCommand = Command.Zkzhm;
tmpdata.strZjbh = stu.zkzmbh;
Server.SendData(data.intDevnum, tmpdata);
mainform.ChangeDevStatus(data.intDevnum, DevStatus.身份验证);
mainform.UpdateStuColor(data.intDevnum);
if (DisplayStrings.GetValue(stu.DisplayString(data.intDevnum)) == null)
{
DisplayStrings.AddString(stu.DisplayString(data.intDevnum), "考试");
}
else
{
DisplayStrings.UpdateString(stu.DisplayString(data.intDevnum), "考试");
}
CVoice.Play(stu.DisplayString(data.intDevnum) + "考试。");
CStudent stu2 = model.devmanager.GetStudent(data.intDevnum, 1);
if (stu2 != null)
{
DisplayStrings.AddString(stu2.DisplayString(data.intDevnum), "排队");
//CVoice.Play(stu2.DisplayString(data.intDevnum) + "排队。");
}
//displaycomm.ShowText(DisplayStrings.GetAllStrings());
}
break;
case Command.Ksks:
if (mainform.GetDeviceStatus(data.intDevnum) != DevStatus.正在考试)
{
mainform.ChangeDevStatus(data.intDevnum, DevStatus.正在考试);
//把设备列表中第一个考生显示颜色改为红色，表示正在考试
mainform.UpdateStuColor(data.intDevnum);
CStudent stu1 = model.devmanager.GetStudent(data.intDevnum, 0);
if (stu1 != null)
{
DisplayStrings.DeleteString(stu1.DisplayString(data.intDevnum));
}
CStudent stu2and3;
for (int i = 1; i < 3; i++)
{
stu2and3 = model.devmanager.GetStudent(data.intDevnum, i);
if (stu2and3 != null)
{
DisplayStrings.AddString(stu2and3.DisplayString(data.intDevnum), "排队");
}
else
{
break;
}
}
//displaycomm.ShowText(DisplayStrings.GetAllStrings());
}
break;
case Command.Kswc:
mainform.ChangeDevStatus(data.intDevnum, DevStatus.设备就绪);
mainform.ReUpdateStuColor(data.intDevnum);
//把设备列表中第一个考生删除掉
mainform.DeleteFirstStudent(data.intDevnum);
tmpdata.Clear();
tmpdata.cmdCommand = Command.DeleteStudent;
tmpdata.intDevnum = data.intDevnum;
tmpdata.strZjbh = data.strZjbh;
Server.SendData(data.intDevnum, tmpdata);
break;
case Command.Jjks:
System.Windows.Forms.MessageBox.Show("考生" + ((CStudent)(model.devmanager.GetStudent(data.intDevnum))).zkzmbh + "被" + data.intDevnum.ToString() + "号考库拒绝！");
mainform.ReUpdateStuColor(data.intDevnum);
CStudent stu3 = model.devmanager.GetStudent(data.intDevnum, 0);
if (stu3 != null)
{
DisplayStrings.UpdateString(stu3.DisplayString(data.intDevnum), "排队");
}
//displaycomm.ShowText(DisplayStrings.GetAllStrings());
mainform.ChangeDevStatus(data.intDevnum, DevStatus.设备就绪);
////把设备列表中第一个考生删除掉
//mainform.DeleteFirstStudent(data.intDevnum);
////删除对应的远端设备列表中的排队考生
//tmpdata.Clear();
//tmpdata.cmdCommand = Command.DeleteStudent;
//tmpdata.intDevnum = data.intDevnum;
//tmpdata.strZjbh = data.strZjbh;
//Server.SendData(data.intDevnum, tmpdata);
break;
case Command.Updatelist:
//同步更新远程设备排队考生列表
UpdateRemoteListview(data.intDevnum);
break;
}
}
