private void grid_to_us_gd_cong_tac(US_GD_HE_SO_LNS v_us_gd_ct, DataRow data) { v_us_gd_ct.dcID_NHAN_VIEN = find_id_nv_by_ma_nv(data[ExcelLNS.MA_NHAN_VIEN].ToString()); v_us_gd_ct.dcID_HE_SO_LNS = find_id_hs_lns_by_ma_muc(data[ExcelLNS.MA_LNS].ToString(), data[ExcelLNS.MUC_LNS].ToString()); v_us_gd_ct.dcHE_SO = find_he_so_lns_by_id(v_us_gd_ct.dcID_HE_SO_LNS); v_us_gd_ct.strNGUOI_LAP = CAppContext_201.getCurrentUserName(); v_us_gd_ct.datNGAY_BAT_DAU = WinFormControls.FormatPostingDate(data[ExcelLNS.NGAY_BAT_DAU].ToString()); if(String.IsNullOrEmpty(data[ExcelLNS.NGAY_KET_THUC].ToString())) { v_us_gd_ct.SetNGAY_KET_THUCNull(); } else { v_us_gd_ct.datNGAY_KET_THUC = WinFormControls.FormatPostingDate(data[ExcelLNS.NGAY_KET_THUC].ToString()); } v_us_gd_ct.datNGAY_LAP = DateTime.Now.Date; }