private void btnAdd_Click(object sender, EventArgs e)
{
Intent intent = new Intent();
intent.dict["type"] = "add";
List <string> empNos = new List <string>(listView1.Items.Count);
foreach (ListViewItem item in listView1.Items)
{
empNos.Add(item.SubItems[0].Text);
}
intent.dict["empNos"] = empNos;
InputForm inputForm = new InputForm(intent);
if (inputForm.ShowDialog() == DialogResult.OK)
{
string sql = string.Format(@"INSERT INTO [Employee] VALUES ('{0}','{1}','{2}',{3})",
intent.dict["empNo"], intent.dict["empName"], intent.dict["empSex"], intent.dict["empAge"]);
DBUtil.execCommand(sql);
populateEmployee();
}
inputForm.Dispose();
}
private void btnUpdate_Click(object sender, EventArgs e)
{
if (listView1.SelectedItems.Count != 1)
{
MessageBox.Show("所选择的员工不为1");
return;
}
ListViewItem selectedItem = listView1.SelectedItems[0];
string originNo = selectedItem.SubItems[0].Text;
Intent intent = new Intent();
intent.dict["type"] = "update";
intent.dict["selectedItem"] = selectedItem;
List <string> empNos = new List <string>(listView1.Items.Count - 1);
foreach (ListViewItem item in listView1.Items)
{
if (item.Equals(selectedItem))
{
continue;
}
empNos.Add(item.SubItems[0].Text);
}
intent.dict["empNos"] = empNos;
InputForm inputForm = new InputForm(intent);
if (inputForm.ShowDialog() == DialogResult.OK)
{
string valueStr = "";
if (!intent.dict["empNo"].ToString().Equals(selectedItem.SubItems[0].Text))
{
valueStr += string.Format(@"[EmpNo] = '{0}',", intent.dict["empNo"]);
selectedItem.SubItems[0].Text = intent.dict["empNo"].ToString();
}
else if (!intent.dict["empName"].ToString().Equals(selectedItem.SubItems[1].Text))
{
valueStr += string.Format(@"[EmpName] = '{0}',", intent.dict["empName"]);
selectedItem.SubItems[1].Text = intent.dict["empName"].ToString();
}
else if (!intent.dict["empSex"].ToString().Equals(selectedItem.SubItems[2].Text))
{
valueStr += string.Format(@"[EmpSex] = '{0}',", intent.dict["empSex"]);
selectedItem.SubItems[2].Text = intent.dict["empSex"].ToString();
}
else if (!intent.dict["empAge"].ToString().Equals(selectedItem.SubItems[3].Text))
{
valueStr += string.Format(@"[EmpAge] = '{0}',", intent.dict["empAge"]);
selectedItem.SubItems[3].Text = intent.dict["empAge"].ToString();
}
if (valueStr.Length == 0)
{
MessageBox.Show("没有修改");
return;
}
else
{
valueStr = valueStr.Substring(0, valueStr.Length - 1);
}
string sql = string.Format(@"UPDATE [Employee] SET {0} WHERE [EmpNo]='{1}'",
valueStr, originNo);
DBUtil.execCommand(sql);
//populateEmployee();
}
inputForm.Dispose();
}
