public StaffBean() { post = new PostBean(); performance = new PerformanceBean(); benefit = new BenefitBean(); department = new DepartmentBean(); }
private void buttonDelete_Click(object sender, EventArgs e) { if (!CheckData()) { return; } DepartmentBean b = new DepartmentBean(); b.Id = (int)treeList.FocusedNode["Id"]; DepartmentDAO dao = new DepartmentDAO(); dao.DeleteDepartment(b); LoadData(); }
private void buttonUpdate_Click(object sender, EventArgs e) { if (!CheckData()) { return; } if (id == -1) { MessageBox.Show("请选择", "信息提示", MessageBoxButtons.OK); return; } DataRow[] matches = tabData.Select("Name='" + name + "' and Id<>" + id); if (matches.Length > 0) { MessageBox.Show("该部门已经存在", "信息提示", MessageBoxButtons.OK); return; } int parentId = 0; if (comboBoxEditParent.SelectedItem != null) { matches = tabData.Select("Name='" + comboBoxEditParent.Text + "'"); if (matches.Length == 0) { return; } parentId = (int)matches[0]["Id"]; } DepartmentBean b = new DepartmentBean(); b.Id = id; b.Name = name; b.ParentId = parentId; b.Code = code; DepartmentDAO dao = new DepartmentDAO(); dao.UpdateDepartment(b); LoadData(); }
public int DeleteDepartment(DepartmentBean b) { int count = 0; try { SqlParameter[] sp = { para = new SqlParameter("@Id", b.Id), }; count = sh.RunSql("PR_Department_Delete", sp); } catch (Exception ex) { throw ex; } return(count); }
private SqlParameter para; //参数 public int AddDepartment(DepartmentBean b) { int count = 0; try { SqlParameter[] sp = { para = new SqlParameter("@Name", b.Name), para = new SqlParameter("@Code", b.Code), para = new SqlParameter("@ParentId", b.ParentId), }; count = sh.RunSql("PR_Department_Add", sp); } catch (Exception ex) { throw ex; } return(count); }