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