//新增
private void btn_Save_Click(object sender, EventArgs e)
{
db_kaochang manage = new db_kaochang();
if (!manage.Exists(txtKCMC.Text.Trim(), publicModel.examName) && !string.IsNullOrEmpty(txtKCMC.Text.Trim()))
{
try
{
manage.kcName = txtKCMC.Text.ToString().Trim();
manage.examNameID = publicModel.examName;
manage.remark = "";
manage.Add();
DialogResult dialogres = MessageBox.Show("添加考场名称成功！", "系统提示！", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
if (dialogres == DialogResult.OK)
{
showAll();
txtKCMC.Text = String.Empty;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
//删除
private void btn_Del_Click(object sender, EventArgs e)
{
db_kaochang manage = new db_kaochang();
string idString = "";
for (int i = 0; i < ckListBoxCydw.CheckedItems.Count; i++)
{
string name = ckListBoxCydw.GetItemText(ckListBoxCydw.CheckedItems[i]);
string id = new db_kaochang(name).ID.ToString();
idString += id + ",";
}
if (!string.IsNullOrEmpty(idString))
{
if (MessageBox.Show("确定删除?", "提示", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
if (manage.DeleteList(idString.Remove(idString.Length - 1)))
{
showAll();
MessageBox.Show("成功删除" + idString.Remove(idString.Length - 1).Split(',').Length + "个考场！");
txtKCMC.Text = String.Empty;
}
}
}
else
{
MessageBox.Show("请选择考场再点删除");
}
}
//单击checkListBox的项
private void ckListBoxCydw_SelectedIndexChanged(object sender, EventArgs e)
{
if (ckListBoxCydw.SelectedItem != null)
{
string name = ckListBoxCydw.SelectedItem.ToString();
db_kaochang manage = new db_kaochang(name);
varID = manage.ID;
txtKCMC.Text = name;
}
}
/// <summary>
/// 绑定考场
/// </summary>
private void BindCmbKCMC()
{
DataTable dtDicCydw = new db_kaochang().GetList(" examnameid='" + publicModel.examName + "'").Tables[0];
DataRow dr = dtDicCydw.NewRow();
dr["ID"] = "0";
dr["kcName"] = "--请选择--";
dtDicCydw.Rows.InsertAt(dr, 0);
cmbKaochang.DisplayMember = "kcName";
cmbKaochang.ValueMember = "ID";
cmbKaochang.DataSource = dtDicCydw.DefaultView;
}
/// <summary>
/// 在CheckListBox中显示所有考场
/// </summary>
private void showAll()
{
#region 先清空CheckListBox列表
for (int i = 0; i < ckListBoxCydw.Items.Count; i++)
{
ckListBoxCydw.Items.Clear();
}
#endregion
db_kaochang manage = new db_kaochang();
DataTable dtList = manage.GetList(" examnameid='" + publicModel.examName + "'").Tables[0];
for (int i = 0; i < dtList.Rows.Count; i++)
{
ckListBoxCydw.Items.Insert(i, dtList.Rows[i]["kcName"].ToString());
}
}
string lujing = Application.StartupPath; //F:\\MyProjects\\CVR100A_U_DSDK_Demo\\bin\\Debug
//string lujing = "http://192.168.1.118\\d:";
/// <summary>
/// 配置各考场随机数
/// </summary>
private void setRandomNum()
{
DataTable dtDicCydw = new db_kaochang().GetList(" examnameid='" + publicModel.examName + "'").Tables[0];
for (int i = 0; i < dtDicCydw.Rows.Count; i++)
{
StreamWriter swno = new StreamWriter(@lujing + "\\" + dtDicCydw.Rows[i]["kcname"].ToString() + "（" + publicModel.examName + "）" + ".txt");
DataTable dtTheExam = new db_theExamNo().GetList("kaochangname='" + dtDicCydw.Rows[i]["kcname"].ToString() + "'").Tables[0];
//循环每个考场有几组
for (int j = 0; j < dtTheExam.Rows.Count; j++)
{
for (int n = Convert.ToInt32(dtTheExam.Rows[j]["startnum"]); n <= Convert.ToInt32(dtTheExam.Rows[j]["endnum"]); n++)
{
swno.Write(n.ToString() + "\r\n");
}
}
swno.Close();
}
}
//修改
private void btn_Modify_Click(object sender, EventArgs e)
{
db_kaochang manage = new db_kaochang();
string name = txtKCMC.Text.Trim();
manage.ID = varID;
manage.kcName = name;
manage.examNameID = publicModel.examName;
manage.remark = "";
if (manage.Update())
{
MessageBox.Show("修改考场名称成功！");
showAll();
txtKCMC.Text = String.Empty;
}
else
{
MessageBox.Show("操作失败！");
}
}
/// <summary>
/// 重置各考场随机数
/// </summary>
private void clearRandom()
{
try
{
DataTable dtDicCydw = new db_kaochang().GetList(" examnameid='" + publicModel.examName + "'").Tables[0];
for (int i = 0; i < dtDicCydw.Rows.Count; i++)
{
//StreamWriter swno = new StreamWriter(lujing + "\\" + dtDicCydw.Rows[i]["kcname"].ToString() + "（" + publicModel.examName + "）" + ".txt");
//swno.Write("");
//swno.Close();
string delFile = lujing + "\\" + dtDicCydw.Rows[i]["kcname"].ToString() + "（" + publicModel.examName + "）" + ".txt";
File.Delete(delFile);
}
StreamWriter swno1 = new StreamWriter(lujing + "\\idcard.txt");
swno1.Write("");
swno1.Close();
MessageBox.Show("已成功清空各考场准考证号！", "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
catch
{
MessageBox.Show("抛锚了！", "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
