//部门 private void lbHYList_BM() { HY_BLL.HY_DepartmentBLL hydep = new HY_DepartmentBLL(); string sql = "select * from HY_Department"; this.lbHY.DataSource = hydep.ExecuteQuery(sql); this.lbHY.DisplayMember = "d_Name"; this.lbHY.ValueMember = "d_ID"; }
private void B_DEL_Click(object sender, EventArgs e) { //实例化部门实体类 HY_Model.HY_Department del = new HY_Model.HY_Department(); del.D_ID = int.Parse(this.lbHY.SelectedValue.ToString());//选择部门项值 HY_BLL.HY_DepartmentBLL hydep = new HY_DepartmentBLL(); int res = hydep.del_Department(del); if (res > 0) { MessageBoxEx.Show("提示:成功删除部门!"); lbHYList_BM(); } }
/// <summary> /// 添加部门类别信息 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void dnADD_Click(object sender, EventArgs e) { string dName = this.d_Name.Text.Trim(); if (dName == string.Empty) { MessageBox.Show("部门名称不能为空!", "操作提示", MessageBoxButtons.OK, MessageBoxIcon.Error); this.d_Name.Focus(); return; } //实例化部门实体类 HY_Model.HY_Department d = new HY_Model.HY_Department(); d.D_Name = this.d_Name.Text.Trim(); //执行操作 HY_BLL.HY_DepartmentBLL hydep = new HY_DepartmentBLL(); int res = hydep.com_Department(d); if (res > 0) { MessageBox.Show("添加成功!"); lbHYList_BM(); } }