private void m_cmd_nhap_thong_tin_nhan_vien_Click(object sender, EventArgs e)
 {
     try
     {
         f151_Danh_sach_nhan_vien_master v_frm = new f151_Danh_sach_nhan_vien_master();
         v_frm.import_excel();
         if (chuyen_buoc_tiep_theo())
         {
             v_frm.ShowDialog();
         }
         //v_frm.Show();
         //m_e_buoc_hien_tai++;
         set_init_form_load();
     }
     catch (Exception v_e)
     {
         CSystemLog_301.ExceptionHandle(v_e);
     }
 }
 private void m_cmd_ds_nhan_vien_ItemClick(object sender, ItemClickEventArgs e)
 {
     try
     {
         f151_Danh_sach_nhan_vien_master v_f = new f151_Danh_sach_nhan_vien_master();
         if(IsExistFormName(v_f)) return;
         v_f.MdiParent = this;
         v_f.Show();
     }
     catch(Exception v_e)
     {
         CSystemLog_301.ExceptionHandle(v_e);
     }
 }
        private void hien_thi_detail(decimal ip_dc_id_don_vi, string ip_str_focused_column_name)
        {
            f329_lap_hop_dong_v5 v_frm_hd = new f329_lap_hop_dong_v5();
            f151_Danh_sach_nhan_vien_master v_frm_nv = new f151_Danh_sach_nhan_vien_master();
            string v_str_filter = "";
            switch(ip_str_focused_column_name)
            {
                case CONST_COL_PHAN_LOAI_LD_NAME.TONG_SO_HD:
                    v_str_filter = "[ID_DON_VI] = " + ip_dc_id_don_vi +
                                            " and NGAY_BAT_DAU <= #" + m_dat_tai_ngay.DateTime.ToString("MM/dd/yyyy") + "#" +
                                            " and (NGAY_KET_THUC IS NULL or NGAY_KET_THUC > #" + m_dat_tai_ngay.DateTime.ToString("MM/dd/yyyy") + "#" + ")";
                    v_frm_hd.display_for_phan_loai_lao_dong(v_str_filter);
                    break;
                case CONST_COL_PHAN_LOAI_LD_NAME.HDHV:
                    v_str_filter = "[ID_DON_VI] = " + ip_dc_id_don_vi +
                                            "and ID_LOAI_HOP_DONG = " + CONST_ID_LOAI_HOP_DONG.HOP_DONG_HOC_VIEC +
                                            " and NGAY_BAT_DAU <= #" + m_dat_tai_ngay.DateTime.ToString("MM/dd/yyyy") + "#" +
                                            " and (NGAY_KET_THUC IS NULL or NGAY_KET_THUC > #" + m_dat_tai_ngay.DateTime.ToString("MM/dd/yyyy") + "#" + ")";
                    v_frm_hd.display_for_phan_loai_lao_dong(v_str_filter);
                    break;
                case CONST_COL_PHAN_LOAI_LD_NAME.HDTV:
                    v_str_filter = "[ID_DON_VI] = " + ip_dc_id_don_vi +
                                            "and ID_LOAI_HOP_DONG = " + CONST_ID_LOAI_HOP_DONG.HOP_DONG_THU_VIEC +
                                            " and NGAY_BAT_DAU <= #" + m_dat_tai_ngay.DateTime.ToString("MM/dd/yyyy") + "#" +
                                            " and (NGAY_KET_THUC IS NULL or NGAY_KET_THUC > #" + m_dat_tai_ngay.DateTime.ToString("MM/dd/yyyy") + "#" + ")";
                    v_frm_hd.display_for_phan_loai_lao_dong(v_str_filter);
                    break;
                case CONST_COL_PHAN_LOAI_LD_NAME.HD1N:
                    v_str_filter = "[ID_DON_VI] = " + ip_dc_id_don_vi +
                                            "and ID_LOAI_HOP_DONG = " + CONST_ID_LOAI_HOP_DONG.HOP_DONG_MOT_NAM +
                                            " and NGAY_BAT_DAU <= #" + m_dat_tai_ngay.DateTime.ToString("MM/dd/yyyy") + "#" +
                                            " and (NGAY_KET_THUC IS NULL or NGAY_KET_THUC > #" + m_dat_tai_ngay.DateTime.ToString("MM/dd/yyyy") + "#" + ")";
                    v_frm_hd.display_for_phan_loai_lao_dong(v_str_filter);
                    break;
                case CONST_COL_PHAN_LOAI_LD_NAME.HD1N2016:
                    v_str_filter = "[ID_DON_VI] = " + ip_dc_id_don_vi +
                                            "and ID_LOAI_HOP_DONG = " + CONST_ID_LOAI_HOP_DONG.HOP_DONG_1N_2016 +
                                            " and NGAY_BAT_DAU <= #" + m_dat_tai_ngay.DateTime.ToString("MM/dd/yyyy") + "#" +
                                            " and (NGAY_KET_THUC IS NULL or NGAY_KET_THUC > #" + m_dat_tai_ngay.DateTime.ToString("MM/dd/yyyy") + "#" + ")";
                    v_frm_hd.display_for_phan_loai_lao_dong(v_str_filter);
                    break;
                case CONST_COL_PHAN_LOAI_LD_NAME.HD3N:
                    v_str_filter = "[ID_DON_VI] = " + ip_dc_id_don_vi +
                                             "and ID_LOAI_HOP_DONG = " + CONST_ID_LOAI_HOP_DONG.HOP_DONG_3_NAM +
                                             " and NGAY_BAT_DAU <= #" + m_dat_tai_ngay.DateTime.ToString("MM/dd/yyyy") + "#" +
                                             " and (NGAY_KET_THUC IS NULL or NGAY_KET_THUC > #" + m_dat_tai_ngay.DateTime.ToString("MM/dd/yyyy") + "#" + ")";
                    v_frm_hd.display_for_phan_loai_lao_dong(v_str_filter);
                    break;
                case CONST_COL_PHAN_LOAI_LD_NAME.HDKX:
                    v_str_filter = "[ID_DON_VI] = " + ip_dc_id_don_vi +
                                            "and ID_LOAI_HOP_DONG = " + CONST_ID_LOAI_HOP_DONG.HOP_DONG_KHONG_XAC_DINH +
                                            " and NGAY_BAT_DAU <= #" + m_dat_tai_ngay.DateTime.ToString("MM/dd/yyyy") + "#" +
                                            " and (NGAY_KET_THUC IS NULL or NGAY_KET_THUC > #" + m_dat_tai_ngay.DateTime.ToString("MM/dd/yyyy") + "#" + ")";
                    v_frm_hd.display_for_phan_loai_lao_dong(v_str_filter);
                    break;

                case CONST_COL_PHAN_LOAI_LD_NAME.SAU_DAI_HOC:
                    v_frm_nv.display_for_phan_loai_lao_dong(CONST_COL_PHAN_LOAI_LD_NAME.SAU_DAI_HOC, m_dat_tai_ngay.DateTime.Date, ip_dc_id_don_vi);
                    break;
                case CONST_COL_PHAN_LOAI_LD_NAME.DAI_HOC:
                    v_frm_nv.display_for_phan_loai_lao_dong(CONST_COL_PHAN_LOAI_LD_NAME.DAI_HOC, m_dat_tai_ngay.DateTime.Date, ip_dc_id_don_vi);
                    break;
                case CONST_COL_PHAN_LOAI_LD_NAME.CAO_DANG:
                    v_frm_nv.display_for_phan_loai_lao_dong(CONST_COL_PHAN_LOAI_LD_NAME.CAO_DANG, m_dat_tai_ngay.DateTime.Date, ip_dc_id_don_vi);
                    break;
                case CONST_COL_PHAN_LOAI_LD_NAME.TRUNG_CAP:
                    v_frm_nv.display_for_phan_loai_lao_dong(CONST_COL_PHAN_LOAI_LD_NAME.TRUNG_CAP, m_dat_tai_ngay.DateTime.Date, ip_dc_id_don_vi);
                    break;
                case CONST_COL_PHAN_LOAI_LD_NAME.KHAC:
                    v_frm_nv.display_for_phan_loai_lao_dong(CONST_COL_PHAN_LOAI_LD_NAME.KHAC, m_dat_tai_ngay.DateTime.Date, ip_dc_id_don_vi);
                    break;
                case CONST_COL_PHAN_LOAI_LD_NAME.NAM:
                    v_frm_nv.display_for_phan_loai_gioi_tinh("Y", m_dat_tai_ngay.DateTime.Date, ip_dc_id_don_vi);
                    break;
                case CONST_COL_PHAN_LOAI_LD_NAME.NU:
                    v_frm_nv.display_for_phan_loai_gioi_tinh("N", m_dat_tai_ngay.DateTime.Date, ip_dc_id_don_vi);
                    break;
                case CONST_COL_PHAN_LOAI_LD_NAME.T26:
                    v_frm_nv.display_for_phan_loai_do_tuoi(CONST_COL_PHAN_LOAI_LD_NAME.T26, m_dat_tai_ngay.DateTime.Date, ip_dc_id_don_vi);
                    break;
                case CONST_COL_PHAN_LOAI_LD_NAME.T26to30:
                    v_frm_nv.display_for_phan_loai_do_tuoi(CONST_COL_PHAN_LOAI_LD_NAME.T26to30, m_dat_tai_ngay.DateTime.Date, ip_dc_id_don_vi);
                    break;
                case CONST_COL_PHAN_LOAI_LD_NAME.T31to35:
                    v_frm_nv.display_for_phan_loai_do_tuoi(CONST_COL_PHAN_LOAI_LD_NAME.T31to35, m_dat_tai_ngay.DateTime.Date, ip_dc_id_don_vi);
                    break;
                case CONST_COL_PHAN_LOAI_LD_NAME.T36to40:
                    v_frm_nv.display_for_phan_loai_do_tuoi(CONST_COL_PHAN_LOAI_LD_NAME.T36to40, m_dat_tai_ngay.DateTime.Date, ip_dc_id_don_vi);
                    break;
                case CONST_COL_PHAN_LOAI_LD_NAME.T41to45:
                    v_frm_nv.display_for_phan_loai_do_tuoi(CONST_COL_PHAN_LOAI_LD_NAME.T41to45, m_dat_tai_ngay.DateTime.Date, ip_dc_id_don_vi);
                    break;
                case CONST_COL_PHAN_LOAI_LD_NAME.T46to50:
                    v_frm_nv.display_for_phan_loai_do_tuoi(CONST_COL_PHAN_LOAI_LD_NAME.T46to50, m_dat_tai_ngay.DateTime.Date, ip_dc_id_don_vi);
                    break;
                case CONST_COL_PHAN_LOAI_LD_NAME.T51to55:
                    v_frm_nv.display_for_phan_loai_do_tuoi(CONST_COL_PHAN_LOAI_LD_NAME.T51to55, m_dat_tai_ngay.DateTime.Date, ip_dc_id_don_vi);
                    break;
                case CONST_COL_PHAN_LOAI_LD_NAME.T55:
                    v_frm_nv.display_for_phan_loai_do_tuoi(CONST_COL_PHAN_LOAI_LD_NAME.T55, m_dat_tai_ngay.DateTime.Date, ip_dc_id_don_vi);
                    break;
                default:
                    break;
            }
        }