private void btnCreate_Click(object sender, EventArgs e) { DepartmentService service = new DepartmentService(); if (Department_id == 0) { DepartmentVO vo = new DepartmentVO() { department_name = txtDeptName.Text, department_comment = txtComment.Text }; if (service.InsertDept(vo) != 0) { MessageBox.Show("등록 완료"); this.Close(); } } else { DepartmentVO vo = new DepartmentVO() { department_id = Department_id, department_name = txtDeptName.Text, department_uadmin = LoginVO.user.Name, department_comment = txtComment.Text }; if (service.UpdateDept(vo) != 0) { MessageBox.Show("수정 완료"); this.Close(); } } }
private void frmDepartmentPopUp_Load(object sender, EventArgs e) { if (Department_id != 0) { label1.Text = "부서 정보 - 수정"; DepartmentService service = new DepartmentService(); DepartmentVO vo = service.DetailDepartment(Department_id); txtDeptName.Text = vo.department_name; txtComment.Text = vo.department_comment; } }
/// <summary> /// 부서 콤보박스 바인딩 /// </summary> /// <param name="cbo"></param> /// <param name="list"></param> /// <param name="blankItem"></param> /// <param name="blankText"></param> public void DepartmentBinding(ComboBox cbo, List <DepartmentVO> list, bool blankItem = true, string blankText = "") { var codeList = (from item in list select item).ToList(); if (blankItem) { DepartmentVO blank = new DepartmentVO { department_id = 0, department_name = blankText }; codeList.Insert(0, blank); } cbo.DisplayMember = "department_name"; cbo.ValueMember = "department_id"; cbo.DataSource = codeList; }
public DepartmentVO DetailDepartment(int department_id) { string sql = "select department_name, department_comment from TBL_DEPARTMENT where department_id = @department_id"; using (SqlCommand cmd = new SqlCommand(sql, conn)) { cmd.Parameters.AddWithValue("@department_id", department_id); SqlDataReader reader = cmd.ExecuteReader(); reader.Read(); DepartmentVO vo = new DepartmentVO() { department_name = reader["department_name"].ToString(), department_comment = reader["department_comment"].ToString() }; return(vo); } }
public int InsertDept(DepartmentVO vo) { string sql = "insert into TBL_DEPARTMENT (department_name, department_comment) values(@department_name, @department_comment)"; try { using (SqlCommand cmd = new SqlCommand(sql, conn)) { cmd.Parameters.AddWithValue("@department_name", vo.department_name); cmd.Parameters.AddWithValue("@department_comment", vo.department_comment); int iRow = cmd.ExecuteNonQuery(); return(iRow); } } catch (Exception err) { string msg = err.Message; return(0); } }
public int UpdateDept(DepartmentVO vo) { string sql = "update TBL_DEPARTMENT set department_name = @department_name, department_comment = @department_comment, department_udate = replace(convert(varchar(10), getdate(), 120), '-', '-'), department_uadmin = @department_uadmin where department_id = @department_id"; try { using (SqlCommand cmd = new SqlCommand(sql, conn)) { cmd.Parameters.AddWithValue("@department_id", vo.department_id); cmd.Parameters.AddWithValue("@department_name", vo.department_name); cmd.Parameters.AddWithValue("@department_comment", vo.department_comment); cmd.Parameters.AddWithValue("@department_uadmin", vo.department_uadmin); int iRow = cmd.ExecuteNonQuery(); return(iRow); } } catch (Exception err) { string msg = err.Message; return(0); } }
public int UpdateDept(DepartmentVO vo) { DepartmentDAC dac = new DepartmentDAC(); return(dac.UpdateDept(vo)); }
public int InsertDept(DepartmentVO vo) { DepartmentDAC dac = new DepartmentDAC(); return(dac.InsertDept(vo)); }