private void load_excel_2_grid(C1.Win.C1FlexGrid.C1FlexGrid m_fg)
{
var m_obj_dialog = new System.Windows.Forms.OpenFileDialog();
DialogResult v_result = new DialogResult();
v_result = m_obj_dialog.ShowDialog();
if(v_result == DialogResult.Cancel) {
BaseMessages.MsgBox_Infor("Bạn chưa chọn file Excel!");
m_obj_dialog.Dispose();
return;
}
Workbook wb = null;
wb = Workbook.getWorkbook(m_obj_dialog.FileName);
Sheet sheet = wb.getSheet(0);
//Cái này để thêm hàng vào grid
int v_count_row = 7;
while(sheet.getCell(2, v_count_row).Contents != "") {
v_count_row = v_count_row + 1;
m_fg.Rows.Add();
}
wb.close();
Hashtable v_hst_excel_col = get_mapping_col_excel_grid();
CExcelReport v_obj_excel_rpt = new CExcelReport(m_obj_dialog.FileName);
int v_i_start_excel_row = 7;
for(int v_i_cur_col = m_fg.Cols.Fixed; v_i_cur_col < m_fg.Cols.Count; v_i_cur_col++) {
m_lbl_loading.Visible = true;
progressBar1.Visible = true;
progressBar1.Minimum = m_fg.Cols.Fixed;
progressBar1.Maximum = m_fg.Cols.Count;
progressBar1.Value = v_i_cur_col;
v_obj_excel_rpt.Export2Grid(m_fg,
v_i_start_excel_row
, (int)v_hst_excel_col[v_i_cur_col]
, v_i_cur_col);
}
m_lbl_tong_so_bill.Text = CIPConvert.ToStr(count_record_in_grid(m_fg));
make_stt(m_fg);
m_lbl_loading.Visible = false;
progressBar1.Visible = false;
m_fg.Select(0, 0);
}
private void load_excel_2_grid_excel(string ip_str_file_name)
{
IP.Core.IPExcelReport.CExcelReport v_obj_excel_report
= new IP.Core.IPExcelReport.CExcelReport(ip_str_file_name);
int v_int_row_count = v_obj_excel_report.GetCountRow();
m_fg_oto.Rows.Count = v_int_row_count;
m_fg_oto_excel.Rows.Count = v_int_row_count;
for (int v_i_grid_col = 1; v_i_grid_col < m_fg_oto_excel.Cols.Count; v_i_grid_col++)
{
v_obj_excel_report.Export2Grid(
m_fg_oto_excel
, 5
, v_i_grid_col
, v_i_grid_col);
}
for (int v_i_cur_row = m_fg_oto_excel.Rows.Count - 1; v_i_cur_row > m_fg_oto_excel.Rows.Fixed; v_i_cur_row--)
{
if (m_fg_oto_excel[v_i_cur_row, 1] == null)
{
m_fg_oto_excel.Rows.Remove(v_i_cur_row);
}
else
if (m_fg_oto_excel[v_i_cur_row, 1].ToString().Trim().Length == 0)
{
m_fg_oto_excel.Rows.Remove(v_i_cur_row);
}
}
}
private void load_excel_2_grid_excel()
{
IP.Core.IPExcelReport.CExcelReport v_obj_excel_report
= new IP.Core.IPExcelReport.CExcelReport(m_txt_file_path.Text);
int v_int_excel_row_cout = v_obj_excel_report.GetCountRow();
m_fg_nha.Rows.Count = v_int_excel_row_cout;
m_fg_excel_nha.Rows.Count = v_int_excel_row_cout;
for (int v_i_grid_col = 1; v_i_grid_col < m_fg_excel_nha.Cols.Count; v_i_grid_col++)
{
v_obj_excel_report.Export2Grid(
m_fg_excel_nha
, 5
, v_i_grid_col
, v_i_grid_col);
}
for (int v_i_cur_row = m_fg_excel_nha.Rows.Count - 1; v_i_cur_row > m_fg_excel_nha.Rows.Fixed; v_i_cur_row--)
{
if (m_fg_excel_nha[v_i_cur_row, 1] == null)
{
m_fg_excel_nha.Rows.Remove(v_i_cur_row);
}
else
if (m_fg_excel_nha[v_i_cur_row, 1].ToString().Trim().Length == 0)
{
m_fg_excel_nha.Rows.Remove(v_i_cur_row);
}
}
}
private void load_danh_sach_excel()
{
//Chọn đường dẫn tới file excel
var m_obj_dialog = new System.Windows.Forms.OpenFileDialog();
m_obj_dialog.ShowDialog();
//Mở sheet đầu tiên
Workbook wb = null;
wb = Workbook.getWorkbook(m_obj_dialog.FileName);
Sheet sheet = wb.getSheet(0);
//->Cái này để thêm hàng vào grid, cho tới khi row ở cột barcode rỗng
int v_count_row = 1;
while(sheet.getCell(3, v_count_row).Contents != "") {
v_count_row = v_count_row + 1;
//m_fg.Rows.Add();
}
m_fg.Rows.Count = v_count_row + 1;
wb.close();//Đóng connection khi sử dụng NExcel
//Load dữ liệu lên lưới
CExcelReport v_obj_excel_rpt = new CExcelReport(m_obj_dialog.FileName);
m_lbl_loading.Visible = true;
int v_i_start_excel_row = 2;
int v_i_sheet_col = 1;
for(int v_i_cur_col = m_fg.Cols.Fixed; v_i_cur_col < m_fg.Cols.Count; v_i_cur_col++) {
progressBar1.Visible = true;
progressBar1.Minimum = 1;
progressBar1.Maximum = m_fg.Cols.Count;
progressBar1.Value = v_i_cur_col;
v_obj_excel_rpt.Export2Grid(m_fg,
v_i_start_excel_row
, v_i_sheet_col
, v_i_cur_col);
v_i_sheet_col = v_i_sheet_col + 1;
}
//m_fg.Rows[m_fg.Rows.Count - 1].Clear(C1.Win.C1FlexGrid.ClearFlags.All);
m_lbl_loading.Visible = false;
progressBar1.Visible = false;
m_fg.Select(0,0);
}