private void barButtonItem删除_ItemClick(object sender, ItemClickEventArgs e) { bool right = TempEmpUpdate.ModifyRight(); if (right) { TempEmpQuery.Delete(); TempEmpQuery.RefreshEX(); } else { MessageBox.Show("没有权限!"); } }
private void simpleButtonOK_Click(object sender, EventArgs e) { ConnDB conn = new ConnDB(); string leave_date, sql; if ((comboBoxStatus.Text.ToString() == "离职" || comboBoxStatus.Text.ToString() == "转正") && textEditLeaveDate.Text.ToString() == "") { MessageBox.Show("请先填写离职日期!"); } else if (comboBoxStatus.Text.ToString() == "在职" && textEditLeaveDate.Text.ToString() != "") { MessageBox.Show("请去掉离职日期!"); } else { if (textEditLeaveDate.Text.ToString() == "") { sql = "update COST_TEMP_EMPLOYEE set cname = '" + textEditName.Text.ToString().Trim() + "',sex = '" + comboBoxSex.Text + "',register_date='" + dateTimePickerRegister.Text + "',leave_date=NULL,cfrom = '" + textEditFrom.Text.ToString().Trim() + "',from_type = '" + comboBoxType.SelectedValue.ToString() + "',dept1 = '" + comboBoxDept1.Text + "',dept2 = '" + comboBoxDept2.Text + "',dept3 = '" + comboBoxDept3.Text + "',dept = '" + comboBoxDept.Text + "',id_number = '" + textEditIdNumber.Text.ToString().Trim() + "',phone_no = '" + textEditPhone.Text.ToString().Trim() + "',shift = '" + comboBoxShift.Text + "',status = '" + comboBoxStatus.SelectedItem + "'"; sql = sql + " where cno = '" + textEditCno.Text.ToString() + "'"; } else { leave_date = textEditLeaveDate.Text.ToString(); sql = "update COST_TEMP_EMPLOYEE set cname = '" + textEditName.Text.ToString().Trim() + "',sex = '" + comboBoxSex.Text + "',register_date='" + dateTimePickerRegister.Text + "',leave_date='" + leave_date + "',cfrom = '" + textEditFrom.Text.ToString().Trim() + "',from_type = '" + comboBoxType.SelectedValue.ToString() + "',dept1 = '" + comboBoxDept1.Text + "',dept2 = '" + comboBoxDept2.Text + "',dept3 = '" + comboBoxDept3.Text + "',dept = '" + comboBoxDept.Text + "',id_number = '" + textEditIdNumber.Text.ToString().Trim() + "',phone_no = '" + textEditPhone.Text.ToString().Trim() + "',shift = '" + comboBoxShift.Text + "',status = '" + comboBoxStatus.SelectedItem + "'"; sql = sql + " where cno = '" + textEditCno.Text.ToString() + "'"; } bool isok = conn.EditDatabase(sql); if (isok) { MessageBox.Show("修改成功!"); TempEmpQuery.RefreshEX(); this.Close(); } else { MessageBox.Show("失败!"); } } conn.Close(); }
private void simpleButtonOK_Click(object sender, EventArgs e) { ConnDB conn = new ConnDB(); string strsql, strsql2; int rows; string cno = GenerateNo(); strsql = "insert into COST_TEMP_EMPLOYEE(cno,cname,sex,register_date,cfrom,from_type,dept1,dept2,dept3,dept,id_number,phone_no,shift,status) values('" + cno + "','" + textEditName.Text.ToString().Trim() + "','" + comboBoxSex.Text.ToString() + "','" + dateTimePicker1.Text.ToString() + "','" + textEditFrom.Text.ToString().Trim() + "','" + comboBoxType.SelectedValue + "','" + comboBoxDept1.SelectedValue + "','" + comboBoxDept2.SelectedValue + "','" + comboBoxDept3.SelectedValue + "','" + comboBoxDept.SelectedValue + "','" + textEditIDNumber.Text.ToString().Trim() + "','" + textEditPhone.Text.ToString().Trim() + "','" + comboBoxShift.SelectedValue.ToString() + "','在职')"; strsql2 = "select cno from COST_TEMP_EMPLOYEE where cno ='" + cno + "'"; if (textEditIDNumber.Text.ToString().Trim() != "" && textEditName.Text.ToString().Trim() != "") { rows = conn.ReturnRecordCount(strsql2); if (rows > 0) { MessageBox.Show("该工号已经存在!"); } else { bool isok = conn.EditDatabase(strsql); if (isok) { MessageBox.Show("添加成功!"); TempEmpQuery.RefreshEX(); this.Close(); } else { MessageBox.Show("失败!"); } } } else { MessageBox.Show("姓名和身份证号不能为空!"); } conn.Close(); }
private void barButtonItem刷新_ItemClick(object sender, ItemClickEventArgs e) { TempEmpQuery.RefreshEX(); }