//Load du lieu len luoi theo id nhan vien //private void load_data_2_grid(decimal ip_dc_id_nv) //{ // CHRMCommon.make_stt(m_grv_v_gd_loai_lao_dong); // US_DUNG_CHUNG v_us = new US_DUNG_CHUNG(); // DataSet v_ds = new DataSet(); // v_ds.Tables.Add(new DataTable()); // v_us.FillDatasetWithQuery(v_ds, "Select * from V_GD_LOAI_LAO_DONG WHERE ID = " + ip_dc_id_nv); // m_grc_v_gd_loai_lao_dong.DataSource = v_ds.Tables[0]; //} //Load du lieu len luoi theo id_loai_lao_dong //private void load_data_2_grid_with_id_loai_lao_dong(decimal ip_dc_id_loai_ld) //{ // CHRMCommon.make_stt(m_grv_v_gd_loai_lao_dong); // US_DUNG_CHUNG v_us = new US_DUNG_CHUNG(); // DataSet v_ds = new DataSet(); // v_ds.Tables.Add(new DataTable()); // v_us.FillDatasetWithQuery(v_ds, "Select * from V_GD_LOAI_LAO_DONG WHERE ID_LOAI_LAO_DONG = " + ip_dc_id_loai_ld); // m_grc_v_gd_loai_lao_dong.DataSource = v_ds.Tables[0]; //} //Load du lieu len luoi theo id nhan vien va id loai lao dong //private void load_data_2_grid(decimal ip_dc_id_nv, decimal ip_dc_id_loai_ld) //{ // CHRMCommon.make_stt(m_grv_v_gd_loai_lao_dong); // US_DUNG_CHUNG v_us = new US_DUNG_CHUNG(); // DataSet v_ds = new DataSet(); // v_ds.Tables.Add(new DataTable()); // v_us.FillDatasetWithQuery(v_ds, "select * from V_GD_LOAI_LAO_DONG WHere ID = " + ip_dc_id_nv + " AND ID_LOAI_LAO_DONG = " + ip_dc_id_loai_ld); // m_grc_v_gd_loai_lao_dong.DataSource = v_ds.Tables[0]; //} public void import_excel() { m_txt_path = WinFormControls.openFileDialog(); if (m_txt_path != "") { f372_nhan_vien_loai_lao_dong_excel v_f = new f372_nhan_vien_loai_lao_dong_excel(); v_f.displayToInsertExcel(m_txt_path); } load_data_2_grid(); }