private void grid_to_us_gd_cong_tac(US_GD_CONG_TAC v_us_gd_ct, DataRow data)
{
v_us_gd_ct.dcID_NHAN_VIEN = find_id_nv_by_ma_nv(data[ExcelCongTac.MA_NHAN_VIEN].ToString());
v_us_gd_ct.dcID_LOAI_CONG_TAC = find_id_tu_dien_by_ma_tu_dien(data[ExcelCongTac.LOAI_CONG_TAC].ToString());
v_us_gd_ct.dcID_VI_TRI = find_id_chuc_vu(data[ExcelCongTac.MA_CHUC_VU].ToString());
v_us_gd_ct.dcID_DON_VI = find_id_don_vi(data[ExcelCongTac.MA_DON_VI].ToString());
v_us_gd_ct.strNGUOI_LAP = CAppContext_201.getCurrentUserName();
v_us_gd_ct.datNGAY_BAT_DAU = WinFormControls.FormatPostingDate(data[ExcelCongTac.NGAY_BAT_DAU].ToString());
if(String.IsNullOrEmpty(data[ExcelCongTac.NGAY_KET_THUC].ToString()))
{
v_us_gd_ct.SetNGAY_KET_THUCNull();
}
else
{
v_us_gd_ct.datNGAY_KET_THUC = WinFormControls.FormatPostingDate(data[ExcelCongTac.NGAY_KET_THUC].ToString());
}
v_us_gd_ct.datNGAY_LAP = DateTime.Now.Date;
v_us_gd_ct.strDA_XOA = "N";
v_us_gd_ct.dcSO_HO_SO = ExecuteFuntion.GetSoHoSoNext(v_us_gd_ct.dcID_DON_VI, v_us_gd_ct.dcID_VI_TRI, v_us_gd_ct.dcID_NHAN_VIEN);
}