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