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