private void confirmBtn_Click(object sender, EventArgs e)
{
// 一般性非法输入
String EmpNo = textBox1.Text;
String EmpName = textBox2.Text;
String EmpSex = radioMale.Checked == true ? "男" : "女";
String EmpAge = textBox3.Text;
if (EmpNo == "" || EmpName == "" || !(radioFemale.Checked || radioMale.Checked) || EmpAge == "")
{
MessageBox.Show("Error", "某些项目没有填写");
return;
}
Regex regex = new Regex(@"^[0-9]{1,3}$");
if (!(regex.IsMatch(EmpAge) && Convert.ToInt32(EmpAge) > 0))
{
MessageBox.Show("年龄填写错误", "Error");
return;
}
if (Intent.dict["FLAG"].ToString() == "ADD")
{
sqlString = @"SELECT * FROM [EMPLOYEE]" +
" WHERE [EmpNo]='" + EmpNo + "'";
table = db.GetBySQL(sqlString);
if (table.Rows.Count != 0)
{
MessageBox.Show("员工号已经存在，请换一个!", "ERROR");
return;
}
}
else //修改
{
if (EmpNo != Intent.dict["EmpNo"].ToString())
{
sqlString = @"SELECT * FROM [EMPLOYEE]" +
" WHERE [EmpNo]='" + EmpNo + "'";
table = db.GetBySQL(sqlString);
if (table.Rows.Count != 0)
{
MessageBox.Show("员工号已经存在，请换一个!", "ERROR");
return;
}
}
}
Intent.dict["EmpNo"] = EmpNo;
Intent.dict["EmpName"] = EmpName;
Intent.dict["EmpSex"] = EmpSex;
Intent.dict["EmpAge"] = EmpAge;
this.DialogResult = DialogResult.OK;
this.Close();
}
// 读取员工表
private void LoadMainTab()
{
listView1.Clear();
//生成表头
listView1.Columns.Add("员工号", listView1.Width / 4 - 1, HorizontalAlignment.Left);
listView1.Columns.Add("员工姓名", listView1.Width / 4 - 1, HorizontalAlignment.Left);
listView1.Columns.Add("性别", listView1.Width / 4 - 1, HorizontalAlignment.Left);
listView1.Columns.Add("年龄", listView1.Width / 4 - 1, HorizontalAlignment.Left);
sqlString = @"SELECT * FROM [EMPLOYEE]";
DataTable table = db.GetBySQL(sqlString);
listView1.BeginUpdate();
FillListView(listView1, table);
listView1.EndUpdate();
}