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