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