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