private void grid_to_us_gd_hop_dong(US_GD_HOP_DONG v_us_gd_hd, DataRow data) { v_us_gd_hd.dcID_NHAN_VIEN = find_id_nv_by_ma_nv(data[ExcelHopDong.MA_NHAN_VIEN].ToString()); v_us_gd_hd.dcID_LOAI_HOP_DONG = find_id_loai_hop_dong_by_ma(data[ExcelHopDong.MA_LOAI_HOP_DONG].ToString()); v_us_gd_hd.dcID_CHUC_VU = find_id_chuc_vu(data[ExcelHopDong.MA_CHUC_VU].ToString()); v_us_gd_hd.dcID_DON_VI = find_id_don_vi(data[ExcelHopDong.MA_DON_VI].ToString()); if(!is_not_null(data[ExcelHopDong.MA_CHUC_DANH_LCD]) || !is_not_null(data[ExcelHopDong.MA_MUC_LCD])) { v_us_gd_hd.SetID_LUONG_CHE_DONull(); v_us_gd_hd.dcSO_TIEN_LCD = 0; } else { v_us_gd_hd.dcID_LUONG_CHE_DO = find_id_lcd_by_ma_lcd(data[ExcelHopDong.MA_CHUC_DANH_LCD].ToString(), data[ExcelHopDong.MA_MUC_LCD].ToString()); v_us_gd_hd.dcSO_TIEN_LCD = find_so_tien_lcd(find_id_lcd_by_ma_lcd(data[ExcelHopDong.MA_CHUC_DANH_LCD].ToString(), data[ExcelHopDong.MA_MUC_LCD].ToString())); } v_us_gd_hd.dcID_LOAI_LAO_DONG = find_id_tu_dien_by_ma_tu_dien(data[ExcelHopDong.MA_LOAI_LAO_DONG].ToString()); //v_us_gd_hd.strMA_HOP_DONG = data[ExcelHopDong.MA_HOP_DONG].ToString(); v_us_gd_hd.strNGUOI_LAP = CAppContext_201.getCurrentUserName(); v_us_gd_hd.datNGAY_BAT_DAU = WinFormControls.FormatPostingDate(data[ExcelHopDong.NGAY_BAT_DAU].ToString()); if(String.IsNullOrEmpty(data[ExcelHopDong.NGAY_KET_THUC].ToString())) { v_us_gd_hd.SetNGAY_KET_THUCNull(); } else { v_us_gd_hd.datNGAY_KET_THUC = WinFormControls.FormatPostingDate(data[ExcelHopDong.NGAY_KET_THUC].ToString()); } if(String.IsNullOrEmpty(data[ExcelHopDong.NGAY_KI_HOP_DONG].ToString())) { v_us_gd_hd.SetNGAY_KY_HOP_DONGNull(); } else { v_us_gd_hd.datNGAY_KY_HOP_DONG = WinFormControls.FormatPostingDate(data[ExcelHopDong.NGAY_KI_HOP_DONG].ToString()); } v_us_gd_hd.datNGAY_LAP = DateTime.Now.Date; }