BKI_DichVuMatDat.NghiepVu.f372_nhan_vien_loai_lao_dong_excel.displayToInsertExcel C# (CSharp) Метод

displayToInsertExcel() публичный Метод

public displayToInsertExcel ( string m_txt_path ) : void
m_txt_path string
Результат void
        public void displayToInsertExcel(string m_txt_path)
        {
            WinFormControls.load_xls_to_gridview(m_txt_path, m_grc);
            foreach (DevExpress.XtraGrid.Columns.GridColumn col in ((DevExpress.XtraGrid.Views.Base.ColumnView)m_grc.Views[0]).Columns)
            {
                col.MaxWidth = 100;
                col.MinWidth = 100;
            }
            this.ShowDialog();
        }

Usage Example

 //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();
 }