public DataTable LoadLoaiQuyetDinhFromHoSoNhanVien(LoaiQuyetDinhDTO loaiQuyetDinhDTO)
{
string sql = LoaiQuyetDinhDAO.Instance.LoadLoaiQuyetDinhFromHoSoNhanVien(loaiQuyetDinhDTO);
DataTable dt = Core.GetData(sql);
return(dt);
}
private void btnCapNhat_Click(object sender, EventArgs e)
{
LoaiQuyetDinhDTO loaiQuyetDinhDTO = new LoaiQuyetDinhDTO();
loaiQuyetDinhDTO.LoaiQuyetDinhID = LoaiQuyetDinhID;
loaiQuyetDinhDTO.TenLoaiQuyetDinh = txtLoaiQD.Text.Trim();
if (kt == 1)
{
if (txtLoaiQD.Text == "")
{
MessageBox.Show("Bạn chưa nhập tên loại quyết định");
}
else
{
if (LoaiQuyetDinhBUS.Instance.ThemLoaiQuyetDinh(loaiQuyetDinhDTO) == -1)
{
MessageBox.Show("Lỗi khi thêm mới");
}
else
{
Load_DL();
}
}
}
else
{
LoaiQuyetDinhBUS.Instance.UpdateLoaiQuyetDinh(loaiQuyetDinhDTO);
Load_DL();
}
Reset();
}
private void btnXoa_Click(object sender, EventArgs e)
{
LoaiQuyetDinhDTO loaiQuyetDinhDTO = new LoaiQuyetDinhDTO();
loaiQuyetDinhDTO.LoaiQuyetDinhID = LoaiQuyetDinhID;
DataTable dt = LoaiQuyetDinhBUS.Instance.LoadLoaiQuyetDinhFromHoSoNhanVien(loaiQuyetDinhDTO);
if (dt.Rows.Count > 0)
{
MessageBox.Show("Bạn phải xóa bản ghi trong KhenThuongKyLuat");
}
else
{
LoaiQuyetDinhBUS.Instance.DeleteLoaiQuyetDinh(loaiQuyetDinhDTO);
Load_DL();
Reset();
}
}
public string DeleteLoaiQuyetDinh(LoaiQuyetDinhDTO loaiQuyetDinhDTO)
{
string sql = "Delete LoaiQuyetDinh where LoaiQuyetDinhID ='" + loaiQuyetDinhDTO.LoaiQuyetDinhID + "'";
return(sql);
}
public string LoadLoaiQuyetDinhFromHoSoNhanVien(LoaiQuyetDinhDTO loaiQuyetDinhDTO)
{
string sql = "Select * from KhenThuongKyLuat where LoaiQuyetDinhID ='" + loaiQuyetDinhDTO.LoaiQuyetDinhID + "'";
return(sql);
}
public string UpdateLoaiQuyetDinh(LoaiQuyetDinhDTO loaiQuyetDinhDTO)
{
string sql = "Update LoaiQuyetDinh set TenLoaiQuyetDinh =N'" + loaiQuyetDinhDTO.TenLoaiQuyetDinh + "' where LoaiQuyetDinhID ='" + loaiQuyetDinhDTO.LoaiQuyetDinhID + "'";
return(sql);
}
public string ThemLoaiQuyetDinh(LoaiQuyetDinhDTO loaiQuyetDinhDTO)
{
string sql = "Insert into LoaiQuyetDinh(TenLoaiQuyetDinh) values(N'" + loaiQuyetDinhDTO.TenLoaiQuyetDinh + "')";
return(sql);
}
public void DeleteLoaiQuyetDinh(LoaiQuyetDinhDTO loaiQuyetDinhDTO)
{
Core.RunSql(LoaiQuyetDinhDAO.Instance.DeleteLoaiQuyetDinh(loaiQuyetDinhDTO));
}
public void UpdateLoaiQuyetDinh(LoaiQuyetDinhDTO loaiQuyetDinhDTO)
{
Core.RunSql(LoaiQuyetDinhDAO.Instance.UpdateLoaiQuyetDinh(loaiQuyetDinhDTO));
}
public int ThemLoaiQuyetDinh(LoaiQuyetDinhDTO loaiQuyetDinhDTO)
{
return(Core.RunSql(LoaiQuyetDinhDAO.Instance.ThemLoaiQuyetDinh(loaiQuyetDinhDTO)));
}
