public void display_4_update(US_GD_KHONG_DONG_BAO_HIEM ip_us_ko_bh)
{
m_e_form_mode = DataEntryFormMode.UpdateDataState;
v_us_dang_sua = ip_us_ko_bh;
us_obj_2_form(ip_us_ko_bh);
this.ShowDialog();
}
private void us_obj_2_form(US_GD_KHONG_DONG_BAO_HIEM ip_us)
{
m_sle_chon_nhan_vien.EditValue = ip_us.dcID_NHAN_VIEN;
m_txt_chon_thang.Text = ip_us.dcTHANG.ToString();
m_txt_chon_nam.Text = ip_us.dcNAM.ToString();
m_txt_ly_do.Text = ip_us.strLY_DO;
}
private void save_data()
{
US_GD_KHONG_DONG_BAO_HIEM v_us_gd_khong_dong_bao_hiem = new US_GD_KHONG_DONG_BAO_HIEM();
form_2_us_luong_cung(v_us_gd_khong_dong_bao_hiem);
try
{
switch (m_e_form_mode)
{
case DataEntryFormMode.InsertDataState:
v_us_gd_khong_dong_bao_hiem.BeginTransaction();
v_us_gd_khong_dong_bao_hiem.Insert();
v_us_gd_khong_dong_bao_hiem.CommitTransaction();
CHRM_BaseMessages.MsgBox_Infor(CONST_ID_MSGBOX.INFOR_LUU_DU_LIEU_THANH_CONG);
break;
case DataEntryFormMode.UpdateDataState:
v_us_gd_khong_dong_bao_hiem.BeginTransaction();
v_us_gd_khong_dong_bao_hiem.Update();
v_us_gd_khong_dong_bao_hiem.CommitTransaction();
CHRM_BaseMessages.MsgBox_Infor(CONST_ID_MSGBOX.INFOR_DU_LIEU_DA_DUOC_CAP_NHAT);
break;
default:
break;
}
}
catch (Exception v_e)
{
//DevExpress.XtraEditors.XtraMessageBox.Show("Đã xẩy ra lỗi trong quá trình lưu dữ liệu", "THÔNG BÁO");
throw v_e;
}
}
private void load_data_2_form_4_udate()
{
decimal v_id_nv = CIPConvert.ToDecimal(m_grv_luong_cung_cua_nhan_vien.GetRowCellValue(m_grv_luong_cung_cua_nhan_vien.FocusedRowHandle, "ID_NHAN_VIEN"));
if (check_id_khong_dong_bao_hiem_is_exist(v_id_nv))
{
decimal v_id_gd_khong_dong_bao_hiem = CIPConvert.ToDecimal(m_grv_luong_cung_cua_nhan_vien.GetRowCellValue(m_grv_luong_cung_cua_nhan_vien.FocusedRowHandle, "ID"));
US_GD_KHONG_DONG_BAO_HIEM v_us = new US_GD_KHONG_DONG_BAO_HIEM(v_id_gd_khong_dong_bao_hiem);
m_e_form_mode = DataEntryFormMode.UpdateDataState;
us_obj_2_form(v_us);
}
else
{
CHRM_BaseMessages.MsgBox_Infor("Nhân viên này chưa có thông tin trong tháng " + m_txt_chon_thang.Text.Trim() + " năm " + m_txt_chon_nam.Text.Trim());
m_sle_chon_nhan_vien.EditValue = v_id_nv;
return;
}
}
//save data
private void form_2_us_luong_cung(US_GD_KHONG_DONG_BAO_HIEM ip_us)
{
if (m_e_form_mode == DataEntryFormMode.UpdateDataState)
{
ip_us.dcID = CIPConvert.ToDecimal(m_grv_luong_cung_cua_nhan_vien.GetRowCellValue(m_grv_luong_cung_cua_nhan_vien.FocusedRowHandle, "ID"));
//nguoi sua
ip_us.strNGUOI_LAP = CAppContext_201.getCurrentUserName();
}
else
{
ip_us.datNGAY_LAP = DateTime.Now.Date;
//nguoi lap
ip_us.strNGUOI_LAP = CAppContext_201.getCurrentUserName();
}
ip_us.dcTHANG = CIPConvert.ToDecimal(m_txt_chon_thang.Text.Trim());
ip_us.dcNAM = CIPConvert.ToDecimal(m_txt_chon_nam.Text.Trim());
ip_us.dcID_NHAN_VIEN = CIPConvert.ToDecimal(m_sle_chon_nhan_vien.EditValue);
ip_us.strLY_DO = m_txt_ly_do.Text.Trim();
}
private void luu_khong_dong_bao_hiem()
{
try
{
US_GD_KHONG_DONG_BAO_HIEM v_us = new US_GD_KHONG_DONG_BAO_HIEM();
v_us.dcID_NHAN_VIEN = v_us.dcID_NHAN_VIEN = CIPConvert.ToDecimal(m_dc_id_nhan_vien.ToString());
v_us.dcTHANG = CIPConvert.ToDecimal(m_txt_thang.Text);
v_us.dcNAM = CIPConvert.ToDecimal(m_txt_nam.Text);
v_us.strLY_DO = m_txt_ly_do.Text;
switch (m_e_form_mode)
{
case DataEntryFormMode.UpdateDataState:
break;
case DataEntryFormMode.InsertDataState:
v_us.Insert();
break;
default:
break;
}
}
catch (Exception)
{
MessageBox.Show("Sai bảo hiểm!");
}
}
private void load_khong_dong_bao_hiem(int id_nhan_vien)
{
US_GD_KHONG_DONG_BAO_HIEM v_us = new US_GD_KHONG_DONG_BAO_HIEM(id_nhan_vien);
m_txt_nam.Text = v_us.dcNAM.ToString();
m_txt_thang.Text = v_us.dcTHANG.ToString();
m_txt_ly_do.Text = v_us.strLY_DO;
}
private void us_obj_2_form(US_GD_KHONG_DONG_BAO_HIEM ip_us)
{
m_sle_chon_nhan_vien.EditValue = ip_us.dcID_NHAN_VIEN;
DateTime working = new DateTime(Convert.ToInt16(ip_us.dcNAM), Convert.ToInt16(ip_us.dcTHANG), 15);
//m_txt_chon_thang.Text = ip_us.dcTHANG.ToString();
//m_txt_chon_nam.Text = ip_us.dcNAM.ToString();
m_dat_thang.EditValue = working;
m_txt_ly_do.Text = ip_us.strLY_DO;
}
private void save_data()
{
US_GD_KHONG_DONG_BAO_HIEM v_us_gd_khong_dong_bao_hiem = new US_GD_KHONG_DONG_BAO_HIEM();
form_2_us_luong_cung(v_us_gd_khong_dong_bao_hiem);
try
{
switch (m_e_form_mode)
{
case DataEntryFormMode.InsertDataState:
v_us_gd_khong_dong_bao_hiem.BeginTransaction();
v_us_gd_khong_dong_bao_hiem.Insert();
v_us_gd_khong_dong_bao_hiem.CommitTransaction();
CHRM_BaseMessages.MsgBox_Infor(CONST_ID_MSGBOX.INFOR_LUU_DU_LIEU_THANH_CONG);
break;
case DataEntryFormMode.UpdateDataState:
v_us_gd_khong_dong_bao_hiem.BeginTransaction();
v_us_gd_khong_dong_bao_hiem.Update();
v_us_gd_khong_dong_bao_hiem.CommitTransaction();
CHRM_BaseMessages.MsgBox_Infor(CONST_ID_MSGBOX.INFOR_DU_LIEU_DA_DUOC_CAP_NHAT);
break;
default:
break;
}
}
catch (Exception v_e)
{
v_us_gd_khong_dong_bao_hiem.Rollback();
CSystemLog_301.ExceptionHandle(v_e);
}
}
private void M_sle_chon_nhan_vien_EditValueChanged(object sender, EventArgs e)
{
try
{
if (m_sle_chon_nhan_vien.EditValue == null | m_sle_chon_nhan_vien.EditValue == "")
{
clear_data_in_form();
return;
}
else
{
decimal id_nv = CIPConvert.ToDecimal(m_sle_chon_nhan_vien.EditValue);
decimal id_gd_ko_dong_bh = find_id_gd_khong_dong_bao_hiem(id_nv, m_dat_thang.DateTime.Month.ToString(), m_dat_thang.DateTime.Year.ToString());
if (id_gd_ko_dong_bh == -1)
{
return;
}
else
{
if (CHRM_BaseMessages.MsgBox_Confirm("Nhân viên đã có thông tin không đóng bảo hiểm tháng " + CIPConvert.ToDecimal(m_dat_thang.DateTime.Month.ToString()) + " năm " + CIPConvert.ToDecimal(m_dat_thang.DateTime.Year.ToString()) + ". Bạn có muốn sửa?") == true)
{
m_e_form_mode = DataEntryFormMode.UpdateDataState;
US_GD_KHONG_DONG_BAO_HIEM v_us = new US_GD_KHONG_DONG_BAO_HIEM(id_gd_ko_dong_bh);
v_us_dang_sua.dcID = v_us.dcID;
DateTime working = new DateTime(Convert.ToInt16(v_us.dcNAM), Convert.ToInt16(v_us.dcTHANG), 15);
m_dat_thang.EditValue = working;
m_txt_ly_do.Text = v_us.strLY_DO;
}
else
{
clear_data_in_form();
}
}
}
}
catch (Exception v_e)
{
CSystemLog_301.ExceptionHandle(v_e);
}
}
private void form_2_us_luong_cung(US_GD_KHONG_DONG_BAO_HIEM ip_us)
{
if (m_e_form_mode == DataEntryFormMode.UpdateDataState)
{
ip_us.dcID = v_us_dang_sua.dcID;
//nguoi sua
ip_us.strNGUOI_LAP = CAppContext_201.getCurrentUserName();
ip_us.datNGAY_LAP = DateTime.Now;
}
else
{
ip_us.datNGAY_LAP = DateTime.Now.Date;
//nguoi lap
ip_us.strNGUOI_LAP = CAppContext_201.getCurrentUserName();
}
ip_us.dcTHANG = CIPConvert.ToDecimal(m_dat_thang.DateTime.Month.ToString());
ip_us.dcNAM = CIPConvert.ToDecimal(m_dat_thang.DateTime.Year.ToString());
ip_us.dcID_NHAN_VIEN = CIPConvert.ToDecimal(m_sle_chon_nhan_vien.EditValue);
ip_us.strLY_DO = m_txt_ly_do.Text.Trim();
}
private decimal find_id_gd_khong_dong_bao_hiem(decimal id_nv, string thang, string nam)
{
try
{
US_GD_KHONG_DONG_BAO_HIEM v_us = new US_GD_KHONG_DONG_BAO_HIEM();
DS_GD_KHONG_DONG_BAO_HIEM v_ds = new DS_GD_KHONG_DONG_BAO_HIEM();
v_us.FillDataset(v_ds);
string v_str_filter = "ID_NHAN_VIEN =" + id_nv + " AND THANG = " + thang + "AND NAM = " + nam;
DataRow[] v_dr = v_ds.GD_KHONG_DONG_BAO_HIEM.Select(v_str_filter);
if (v_dr.Count() == 0)
{
return -1;
}
else
{
return CIPConvert.ToDecimal(v_dr.First()["ID"].ToString());
}
}
catch (Exception v_e)
{
CSystemLog_301.ExceptionHandle(v_e);
return -1;
}
}
