private void load_file_excel() { if(m_ofd_exel_file.ShowDialog() == System.Windows.Forms.DialogResult.OK) { try { // Reset lại ds mới nếu chọn lại file excel khác m_ds = new DS_EXCEL_IMPORT_HOC_VIEN(); m_lbl_loading_mes.Visible = true; CExcelReport v_excel_rpt = new CExcelReport(m_ofd_exel_file.FileName); m_ds.EnforceConstraints = false; v_excel_rpt.Export2DatasetDS_by_DucVT(m_ds, m_ds.EXCEL_IMPORT_HOC_VIEN.TableName, 2); m_fg.Redraw = false; //Gán DataSource //m_fg.DataSource = m_ds.DM_NHAN_SU; CGridUtils.Dataset2C1Grid(m_ds, m_fg, m_obj_trans); m_fg.Redraw = true; m_lbl_loading_mes.Visible = false; } catch(Exception v_e) { CSystemLog_301.ExceptionHandle(v_e); } } }
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 export_2_excel() { CExcelReport v_obj_excel_report = new CExcelReport("f405_Tra_cuc_so_Bill_new.xls", 6, 1); v_obj_excel_report.AddFindAndReplaceItem("<tu_ngay>", m_dt_tu_ngay.Text); v_obj_excel_report.AddFindAndReplaceItem("<den_ngay>", m_dt_den_ngay.Text); v_obj_excel_report.AddFindAndReplaceItem("<phap_nhan>", m_cbo_ten_pb.Text); //v_obj_excel_report.AddFindAndReplaceItem("<trang_thai>", m_cbo_trang_thai.Text); v_obj_excel_report.FindAndReplace(false); DataSet v_ds = new DataSet(); v_ds=grid_to_dataset_export_excel(m_fg); m_fg_excel.DataSource = v_ds.Tables[0].DefaultView; v_obj_excel_report.Export2ExcelWithoutFixedRows(m_fg_excel, 0, m_fg_excel.Cols.Count -1, true); }
private void export_excel() { CExcelReport v_obj_exe_report = new CExcelReport(); switch (m_e_form_mode) { case eFormMode.KE_KHAI: v_obj_exe_report = new CExcelReport(TEN_BAO_CAO.BCDM_TSLM_KE_KHAI, 21, 1); break; case eFormMode.DE_NGHI_XU_LY: v_obj_exe_report = new CExcelReport(TEN_BAO_CAO.BCDM_TSLM_DE_NGHI_XU_LY, 21, 1); break; } v_obj_exe_report.AddFindAndReplaceItem("<DON_VI_SU_DUNG_TAI_SAN>", m_cbo_don_vi_su_dung.Text); if (m_fg_excel_nha[1, (int)e_col_Excel_number.MA_DON_VI_SU_DUNG] != null) v_obj_exe_report.AddFindAndReplaceItem("<MA_DON_VI>", m_fg_excel_nha[1, (int)e_col_Excel_number.MA_DON_VI_SU_DUNG]); else v_obj_exe_report.AddFindAndReplaceItem("<MA_DON_VI>", ""); v_obj_exe_report.AddFindAndReplaceItem("<LOAI_HINH_DON_VI>", m_cbo_loai_hinh_don_vi.Text); v_obj_exe_report.AddFindAndReplaceItem("<TRU_SO_LAM_VIEC>", m_lbl_lam_tru_so_lam_viec.Text); v_obj_exe_report.AddFindAndReplaceItem("<DIA_CHI>", m_lbl_dia_chi.Text); v_obj_exe_report.AddFindAndReplaceItem("<DT_KHUON_VIEN>", m_lbl_dien_tich_khuon_vien_dat.Text); v_obj_exe_report.AddFindAndReplaceItem("<CO_SO_HDSN>", m_lbl_lam_co_so_hd_su_nghiep.Text); v_obj_exe_report.AddFindAndReplaceItem("<LAM_NHA_O>", m_lbl_lam_nha_o.Text); v_obj_exe_report.AddFindAndReplaceItem("<CHO_THUE>", m_lbl_cho_thue.Text); v_obj_exe_report.AddFindAndReplaceItem("<BO_TRONG>", m_lbl_bo_trong.Text); v_obj_exe_report.AddFindAndReplaceItem("<BI_LAN_CHIEM>", m_lbl_bi_lan_chiem.Text); v_obj_exe_report.AddFindAndReplaceItem("<KHAC>", m_lbl_su_dung_vao_muc_dich_khac.Text); v_obj_exe_report.AddFindAndReplaceItem("<GT_THEO_SO_KE_TOAN>", m_lbl_gia_tri_theo_so_ke_toan.Text); v_obj_exe_report.AddFindAndReplaceItem("<NGAY>", DateTime.Now.Day); v_obj_exe_report.AddFindAndReplaceItem("<THANG>", DateTime.Now.Month); v_obj_exe_report.AddFindAndReplaceItem("<NAM>", DateTime.Now.Year); v_obj_exe_report.FindAndReplace(false); v_obj_exe_report.Export2ExcelWithoutFixedRows(m_fg_nha, 2, m_fg_nha.Cols.Count - 1, true); }
} private void m_cmd_update_Click(object sender, EventArgs e) { try{ update_v_gd_don_dat_hang_detail(); } catch (Exception v_e){ CSystemLog_301.ExceptionHandle(v_e); } } private void m_cmd_xuat_excel_Click(object sender, EventArgs e) {
//private void Export2Dataset_BangChiPhiCuoiThangNCC(string ip_path_and_file_name, System.Data.DataSet i_DataSet, int i_iSheetStartRow) //{ // // khởi tạo đường dẫn InitPath() // string m_strOutputPath = AppDomain.CurrentDomain.SetupInformation.ApplicationBase + "Reports\\Templates\\"; // string m_strTemplatesPath = AppDomain.CurrentDomain.SetupInformation.ApplicationBase + "Reports\\Output\\"; // //Khởi tạo đối tượng Excel // Excel.Application v_objExcelApp; // Excel.Worksheet v_objExcelWorksheet; // v_objExcelApp = new Excel.Application(); // try // { // System.Threading.Thread.CurrentThread.CurrentCulture = System.Globalization.CultureInfo.CreateSpecificCulture("en-US"); // v_objExcelApp.Workbooks.Open(ip_path_and_file_name); // v_objExcelApp.Workbooks[1].Worksheets.Select(1); // v_objExcelWorksheet = (Excel.Worksheet)v_objExcelApp.Workbooks[1].Worksheets[1]; // int i_iExcelRow = 0; // int i_iExcelCol = 0; // bool v_bol_stop = false; // while (!v_bol_stop) // { // System.Data.DataRow v_iDataRow; // v_iDataRow = i_DataSet.Tables[0].NewRow(); // v_iDataRow[i_iExcelCol] = i_iExcelCol + 1; // for (i_iExcelCol = 0; i_iExcelCol <= i_DataSet.Tables[0].Columns.Count - 2; i_iExcelCol++) // { // if (!object.ReferenceEquals(v_objExcelWorksheet.Cells[i_iExcelRow + i_iSheetStartRow, 3], null)) // { // if (!(v_objExcelWorksheet.Cells[i_iExcelRow + i_iSheetStartRow, i_iExcelCol + 1] == null)) // { // v_iDataRow[i_iExcelCol + 1] = v_objExcelWorksheet.Cells[i_iExcelRow + i_iSheetStartRow, i_iExcelCol + 1]; // } // } // else // { // v_bol_stop = true; // } // } // if (!v_bol_stop) // { // i_DataSet.Tables[0].Rows.InsertAt(v_iDataRow, i_iExcelRow); // i_iExcelRow += 1; // } // } // v_objExcelApp.Workbooks.Close(); // v_objExcelApp.Quit(); // //Unmount // v_objExcelWorksheet = null; // v_objExcelApp = null; // } // catch (Exception v_e) // { // v_objExcelApp.Workbooks.Close(); // //Unmount // v_objExcelWorksheet = null; // v_objExcelApp = null; // throw v_e; // } //} private void load_danh_sach_excel() { if (m_OpenFile_dlg.ShowDialog() == DialogResult.OK) { string v_str_path_and_file_name = m_OpenFile_dlg.FileName; string v_str_file_name = v_str_path_and_file_name.Substring(v_str_path_and_file_name.LastIndexOf("\\") + 1, v_str_path_and_file_name.Length - v_str_path_and_file_name.LastIndexOf("\\") - 1); CExcelReport v_xls_file = new CExcelReport(v_str_path_and_file_name); try { m_lbl_thong_bao_cap_nhat.Visible = false; m_lbl_loading.Visible = true; m_ds.EnforceConstraints = false; //Export2Dataset_BangChiPhiCuoiThangNCC(v_str_path_and_file_name, v_ds, 14); v_xls_file.Export2DatasetDSPhongThi(m_ds, m_ds.RPT_BANG_CHI_PHI_CUOI_THANG_NCC.TableName, 14); //set MA_HD_NCC cho từng bản ghi //int v_i_row_fg = 0; //string v_str_ma_don_hang_ncc = ""; //for (v_i_row_fg = 0; v_i_row_fg < m_ds.RPT_BANG_CHI_PHI_CUOI_THANG_NCC.Count; v_i_row_fg++) //{ // if (m_ds.RPT_BANG_CHI_PHI_CUOI_THANG_NCC.Rows[v_i_row_fg][2].ToString() != "") // { // v_str_ma_don_hang_ncc = m_ds.RPT_BANG_CHI_PHI_CUOI_THANG_NCC.Rows[v_i_row_fg][2].ToString(); // } // else // { // m_ds.RPT_BANG_CHI_PHI_CUOI_THANG_NCC.Rows[v_i_row_fg][2] = v_str_ma_don_hang_ncc; // } //} //set NGAY cho từng hóa đơn //v_i_row_fg = 0; //DateTime v_dat_ngay = DateTime.Parse(m_ds.RPT_BANG_CHI_PHI_CUOI_THANG_NCC.Rows[v_i_row_fg][1].ToString()); //for (v_i_row_fg = 0; v_i_row_fg < m_ds.RPT_BANG_CHI_PHI_CUOI_THANG_NCC.Count; v_i_row_fg++) //{ // if (m_ds.RPT_BANG_CHI_PHI_CUOI_THANG_NCC.Rows[v_i_row_fg][1].ToString() != "") // { // v_dat_ngay = DateTime.Parse(m_ds.RPT_BANG_CHI_PHI_CUOI_THANG_NCC.Rows[v_i_row_fg][1].ToString()); // } // else // { // m_ds.RPT_BANG_CHI_PHI_CUOI_THANG_NCC.Rows[v_i_row_fg][1] = v_dat_ngay; // } //} // Đưa dữ liệu lên lưới: CGridUtils.Dataset2C1Grid(m_ds, m_fg, m_obj_trans_xls); //CGridUtils.MakeSoTT(0, m_fg); //m_fg.Subtotal(C1.Win.C1FlexGrid.AggregateEnum.Count // chỗ này dùng hàm count tức là để đếm, có thể dùng các hàm khác thay thế // , 0 // , (int)e_col_Number.NGAY // chỗ này là tên trường mà mình nhóm // , (int)e_col_Number.TEN_VPP // chỗ này là tên trường mà mình Count // , "{0}" // ); //m_fg.Subtotal(C1.Win.C1FlexGrid.AggregateEnum.Sum // , 0 // , (int)e_col_Number.NGAY // , (int)e_col_Number.DOANH_THU // , "{0}" // ); //m_fg.Redraw = true; //m_fg.Tree.Show(1); //m_lbl_tong_so_luong.Text = CIPConvert.ToStr(m_fg_load_file.Rows.Count - 1); //set mã hóa đơn MA_HD cho từng bản ghi //int v_i_row_fg = 0; //string v_str_ma_don_hang_ncc = ""; //for (v_i_row_fg = 0; v_i_row_fg < m_ds.RPT_BANG_CHI_PHI_CUOI_THANG_NCC.Count; v_i_row_fg++) //{ // if (m_ds.RPT_BANG_CHI_PHI_CUOI_THANG_NCC.Rows[v_i_row_fg][(int)e_col_Number.MA_HD].ToString() != "") // { // v_str_ma_don_hang_ncc = m_ds.RPT_BANG_CHI_PHI_CUOI_THANG_NCC.Rows[v_i_row_fg][(int)e_col_Number.MA_HD].ToString(); // } // else // { // m_ds.RPT_BANG_CHI_PHI_CUOI_THANG_NCC.Rows[v_i_row_fg][(int)e_col_Number.MA_HD] = v_str_ma_don_hang_ncc; // } //} m_lbl_loading.Visible = false; } catch (Exception v_e) { if (v_e.Message.ToString() == "Cannot set Column 'STT' to be null. Please use DBNull instead.") BaseMessages.MsgBox_Error(THONG_BAO.ER_COT_STT_DE_TRONG); else CSystemLog_301.ExceptionHandle(v_e); } } }
private void export_excel() { CExcelReport v_obj_exe_report = new CExcelReport(); switch (m_e_form_mode) { case eFormMode.TONG_HOP_CHUNG: v_obj_exe_report = new CExcelReport(TEN_BAO_CAO.BCTH_THSD_TSK_THC, 17, 1); break; case eFormMode.CHI_TIET_THEO_LOAI_HINH: v_obj_exe_report = new CExcelReport(TEN_BAO_CAO.BCTH_THSD_TSK_LH, 17, 1); break; case eFormMode.CHI_TIET_THEO_TUNG_DON_VI: v_obj_exe_report = new CExcelReport(TEN_BAO_CAO.BCTH_THSD_TSK_DV, 17, 1); break; } v_obj_exe_report.AddFindAndReplaceItem("<BO_TINH>", m_lbl_don_vi_bo_tinh.Text); v_obj_exe_report.AddFindAndReplaceItem("<DON_VI_BO_TINH>", m_lbl_don_vi_bo_tinh.Text); v_obj_exe_report.AddFindAndReplaceItem("<DON_VI_CHU_QUAN>", m_lbl_don_vi_chu_quan.Text); v_obj_exe_report.AddFindAndReplaceItem("<MA_DON_VI>", m_lbl_ma_don_vi.Text); v_obj_exe_report.AddFindAndReplaceItem("<NGAY>", DateTime.Now.Day); v_obj_exe_report.AddFindAndReplaceItem("<THANG>", DateTime.Now.Month); v_obj_exe_report.AddFindAndReplaceItem("<NAM>", DateTime.Now.Year); v_obj_exe_report.FindAndReplace(false); v_obj_exe_report.Export2ExcelWithoutFixedRows(m_fg_tai_san_khac, 2, m_fg_tai_san_khac.Cols.Count - 1, true); }
void m_xuat_excel_Click(object sender, EventArgs e) { try { CExcelReport v_excel = new CExcelReport("f130_chuc_nang.xls", 6, 1); v_excel.FindAndReplace(false); v_excel.Export2ExcelWithoutFixedRows(m_fg_load_file, (int)e_col_Number.SOCT, (int)e_col_Number.GHICHU, true); //v_excel.OpenExcelFile(); } catch(Exception v_e) { CSystemLog_301.ExceptionHandle(v_e); } }
private void export_excel() { CExcelReport v_obj_exe_report = new CExcelReport(); switch (m_e_form_mode) { case eFormMode.KE_KHAI: v_obj_exe_report = new CExcelReport(TEN_BAO_CAO.BCDM_OTO_KE_KHAI, 13, 1); break; case eFormMode.DE_NGHI_XU_LY: v_obj_exe_report = new CExcelReport(TEN_BAO_CAO.BCDM_OTO_DE_NGHI_XU_LY, 13, 1); break; } v_obj_exe_report.AddFindAndReplaceItem("<DON_VI_SU_DUNG_TAI_SAN>", m_cbo_don_vi_su_dung.Text); if (m_fg_oto_excel[1, (int)e_col_Excel_number.MA_DON_VI_SU_DUNG] != null) v_obj_exe_report.AddFindAndReplaceItem("<MA_DON_VI>", m_fg_oto_excel[1, (int)e_col_Excel_number.MA_DON_VI_SU_DUNG]); else v_obj_exe_report.AddFindAndReplaceItem("<MA_DON_VI>", ""); v_obj_exe_report.AddFindAndReplaceItem("<LOAI_HINH_DON_VI>", m_cbo_loai_hinh_don_vi.Text); v_obj_exe_report.AddFindAndReplaceItem("<NGAY>", DateTime.Now.Day); v_obj_exe_report.AddFindAndReplaceItem("<THANG>", DateTime.Now.Month); v_obj_exe_report.AddFindAndReplaceItem("<NAM>", DateTime.Now.Year); v_obj_exe_report.FindAndReplace(false); v_obj_exe_report.Export2ExcelWithoutFixedRows(m_fg_oto, 2, m_fg_oto.Cols.Count - 1, true); }
private void export_excel() { CExcelReport v_obj_exe_report; switch (m_e_form_mode) { case eFormMode.KE_KHAI: v_obj_exe_report = new CExcelReport(TEN_BAO_CAO.BCDM_TST_TREN500TRIEU_KK, 12, 1); v_obj_exe_report.AddFindAndReplaceItem("<TEN_DON_VI_CHU_QUAN>", m_lbl_don_vi_chu_quan.Text); v_obj_exe_report.AddFindAndReplaceItem("<DON_VI_SU_DUNG>", m_lbl_don_vi_su_dung.Text); break; case eFormMode.DE_NGHI_XU_LY: v_obj_exe_report = new CExcelReport(TEN_BAO_CAO.BCDM_TSK_DE_NGHI_XU_LY, 12, 1); break; default: v_obj_exe_report = new CExcelReport(); break; } v_obj_exe_report.AddFindAndReplaceItem("<DON_VI_SU_DUNG_TAI_SAN>", m_lbl_ma_don_vi.Text); v_obj_exe_report.AddFindAndReplaceItem("<MA_DON_VI>", m_lbl_ma_don_vi.Text); v_obj_exe_report.AddFindAndReplaceItem("<LOAI_HINH_DON_VI>", m_lbl_loai_hinh_don_vi.Text); v_obj_exe_report.AddFindAndReplaceItem("<NGAY>", DateTime.Now.Day); v_obj_exe_report.AddFindAndReplaceItem("<THANG>", DateTime.Now.Month); v_obj_exe_report.AddFindAndReplaceItem("<NAM>", DateTime.Now.Year); v_obj_exe_report.FindAndReplace(false); v_obj_exe_report.Export2ExcelWithoutFixedRows(m_fg_tai_san_khac, 2, m_fg_tai_san_khac.Cols.Count - 1, true); }
private void excel_file_to_dataset(string ip_str_file_path) { CExcelReport v_cer = new CExcelReport(ip_str_file_path); //tao 1 dataset de luu du lieu tu file excel m_ds_temp = new DataSet(); m_dt_temp = new DataTable(); m_dt_temp.TableName = "DM_VPP"; m_dt_temp.Columns.Add("Temp");//cot thua m_dt_temp.Columns.Add("STT"); m_dt_temp.Columns.Add("MA_SAN_PHAM"); m_dt_temp.Columns.Add("TEN_VPP"); m_dt_temp.Columns.Add("DON_VI_TINH"); m_dt_temp.Columns.Add("DON_GIA_CHUA_VAT"); m_dt_temp.Columns.Add("DON_GIA_GOM_VAT"); m_dt_temp.Columns.Add("GIOI_HAN_VPP"); m_ds_temp.Tables.Add(m_dt_temp); //data from excel file to dataset and fill to grid v_cer.Export2DatasetDSPhongThi(m_ds_temp, m_ds_temp.Tables[0].TableName, 10); m_ds_temp.Tables[0].Columns.RemoveAt(0);//loai bo cot thua m_ds_temp.AcceptChanges(); //format lai 2 cot don gia for (int i = 0; i < m_ds_temp.Tables[0].Rows.Count; i++) { m_ds.Tables[0].Rows[i][2] = CIPConvert.ToDecimal(m_ds.Tables[0].Rows[i][4]).ToString(); m_ds.Tables[0].Rows[i][3] = CIPConvert.ToDecimal(m_ds.Tables[0].Rows[i][5]).ToString(); } m_fg.DataSource = m_ds_temp.Tables[0]; }
private void xuat_excel() { var v_start_row = 8; var v_start_col = 2; var v_obj_excel_rpt = new CExcelReport("f460_tinh_hinh_thoi_hoc.xlsx", v_start_row, v_start_col); v_obj_excel_rpt.AddFindAndReplaceItem("<tu_ngay>", string.Format("{0}/{1}/{2}", m_dat_tu_ngay.Value.Date.Day, m_dat_tu_ngay.Value.Month, m_dat_tu_ngay.Value.Year)); v_obj_excel_rpt.AddFindAndReplaceItem("<den_ngay>", string.Format("{0}/{1}/{2}", m_dat_den_ngay.Value.Day, m_dat_den_ngay.Value.Month, m_dat_den_ngay.Value.Year)); v_obj_excel_rpt.AddFindAndReplaceItem("<tong_so>", m_txt_sl_dang_hoc.Text); v_obj_excel_rpt.FindAndReplace(false); v_obj_excel_rpt.Export2ExcelWithoutFixedRows(m_fg, 0, m_fg.Cols.Count - 1, false); }
private void export_2_excel() { m_fg.Cols[(int)e_col_Number.UU_TIEN].Visible = false; m_dat_chon_thang = CIPConvert.ToDatetime("01/" + m_dt_chon_thang.Text); DateTime v_dt_tu_ngay = m_dat_chon_thang; DateTime v_dt_den_ngay = m_dat_chon_thang.AddMonths(1).AddDays(-m_dat_chon_thang.Day); CExcelReport v_obj_excel_report = new CExcelReport("f406_bc_Tong_hop_bill_theo_phong_ban.xlsx", 5, 1); US_HT_NGUOI_SU_DUNG v_ht_nguoi_su_dung = new US_HT_NGUOI_SU_DUNG(CAppContext_201.getCurrentUserID()); //v_obj_excel_report.AddFindAndReplaceItem("<tu_ngay>", v_dt_tu_ngay.ToShortDateString()); //v_obj_excel_report.AddFindAndReplaceItem("<den_ngay>", v_dt_den_ngay.ToShortDateString()); v_obj_excel_report.AddFindAndReplaceItem("<THANG_TONG_HOP>", v_dt_tu_ngay.Month); v_obj_excel_report.AddFindAndReplaceItem("<NGUOI_LAP>", v_ht_nguoi_su_dung.strTEN); v_obj_excel_report.AddFindAndReplaceItem("<ngay>", DateTime.Now.Day); v_obj_excel_report.AddFindAndReplaceItem("<thang>", DateTime.Now.Month); v_obj_excel_report.AddFindAndReplaceItem("<nam>", DateTime.Now.Year); //v_obj_excel_report.AddFindAndReplaceItem("<trang_thai>", m_cbo_trang_thai.Text); v_obj_excel_report.FindAndReplace(false); v_obj_excel_report.Export2ExcelWithoutFixedRows(m_fg, 0, m_fg.Cols.Count - 1, true); m_fg.Cols[(int)e_col_Number.UU_TIEN].Visible = true; }
private void export_2_excel() { CExcelReport v_obj_excel_report = new CExcelReport("f407_bc_chi_tiet_bill_cua_phong_ban.xlsx", 6, 1); v_obj_excel_report.AddFindAndReplaceItem("<tu_ngay>", m_lbl_tu_ngay.Text); v_obj_excel_report.AddFindAndReplaceItem("<den_ngay>", m_lbl_den_ngay.Text); v_obj_excel_report.AddFindAndReplaceItem("<phong_ban>", m_lbl_ten_phong_ban.Text); v_obj_excel_report.AddFindAndReplaceItem("<tong_bill>", m_lbl_tong_bill.Text); v_obj_excel_report.AddFindAndReplaceItem("<tong_tien>", m_lbl_tong_tien.Text); v_obj_excel_report.FindAndReplace(false); v_obj_excel_report.Export2ExcelWithoutFixedRows(m_fg, 0, m_fg.Cols.Count - 1, true); }
} catch (Exception v_e) { v_us.Rollback(); CDBExceptionHandler v_objErrHandler = new CDBExceptionHandler(v_e, new CDBClientDBExceptionInterpret()); v_objErrHandler.showErrorMessage(); } } //private void set_search_tu_khoa_format_before() //{ // if (m_txt_tu_khoa.Text == "") // { // m_txt_tu_khoa.Text = m_str_goi_y; // m_txt_tu_khoa.ForeColor = Color.Gray; // } //} //private void set_search_tu_khoa_format_after() //{ // if (m_txt_tu_khoa.Text == m_str_goi_y) // { // m_txt_tu_khoa.Text = ""; // }
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 export_2_excel() { CExcelReport v_obj_excel_report = new CExcelReport("f535_gui_don_hang_cho_NCC.xls", 6,1); v_obj_excel_report.AddFindAndReplaceItem("<thang>",m_dtp_thang.Text); v_obj_excel_report.FindAndReplace(false); v_obj_excel_report.Export2ExcelWithoutFixedRows(m_grv_don_hang, 0, m_grv_don_hang.Cols.Count - 1, true); } private void export_dataset_2_excel()
private void load_danh_sach_excel() { if (m_dgl_open_file.ShowDialog() == DialogResult.OK) { string v_str_path_and_file_name = m_dgl_open_file.FileName; string v_str_file_name = v_str_path_and_file_name.Substring(v_str_path_and_file_name.LastIndexOf("\\") + 1, v_str_path_and_file_name.Length - v_str_path_and_file_name.LastIndexOf("\\") - 1); CExcelReport v_xls_file = new CExcelReport(v_str_path_and_file_name); DS_CM_DM_DANG_KY_GUI_DANH_SACH_TUNG_PHONG v_ds_cm_dm_dang_ky_gui_danh_sach_tung_phong = new DS_CM_DM_DANG_KY_GUI_DANH_SACH_TUNG_PHONG(); try { m_lbl_load.Visible = true; v_ds_cm_dm_dang_ky_gui_danh_sach_tung_phong.EnforceConstraints = false; v_xls_file.Export2DatasetDSPhongThi(v_ds_cm_dm_dang_ky_gui_danh_sach_tung_phong, v_ds_cm_dm_dang_ky_gui_danh_sach_tung_phong.CM_DM_DANG_KY_GUI_DANH_SACH_TUNG_PHONG.TableName, 2); //DataSet v_ds_cm_dm_bang_modify = ModifyDateToUSFormat(v_ds_cm_dm_bang_chi_tiet_cuoi_thang); CGridUtils.Dataset2C1Grid(v_ds_cm_dm_dang_ky_gui_danh_sach_tung_phong, m_fg_load_file, m_obj_trans); m_i_flag = 0; m_lbl_tong_bill.Text = CIPConvert.ToStr(m_fg_load_file.Rows.Count - 1); m_lbl_load.Visible = false; } catch (Exception v_e) { if (v_e.Message.ToString() == "Cannot set Column 'STT' to be null. Please use DBNull instead.") BaseMessages.MsgBox_Error(THONG_BAO.ER_COT_STT_DE_TRONG); else CSystemLog_301.ExceptionHandle(v_e); } } }
private void export_2_excel() { CExcelReport v_obj_excel_report = new CExcelReport("F461_Bao_cao_so_sanh_chi_phi_cuoi_thang.xls", 8, 1); v_obj_excel_report.AddFindAndReplaceItem("<ngay>", DateTime.Now.ToShortDateString()); v_obj_excel_report.FindAndReplace(false); v_obj_excel_report.Export2ExcelWithoutFixedRows(m_fg, 0, m_fg.Cols.Count - 1, true); }
private void export_2_excel() { m_grv_bill.Cols[(int)e_col_Number.CHON_GUI_MAIL].Visible = false; CExcelReport v_obj_excel_report = new CExcelReport("f512_bill_bi_tra_lai.xls", 6, 1); v_obj_excel_report.AddFindAndReplaceItem("<tu_ngay>", m_dtp_tu_ngay.Text); v_obj_excel_report.AddFindAndReplaceItem("<den_ngay>", m_dtp_den_ngay.Text); v_obj_excel_report.FindAndReplace(false); v_obj_excel_report.Export2ExcelWithoutFixedRows(m_grv_bill, 0, m_grv_bill.Cols.Count - 1, true); m_grv_bill.Cols[(int)e_col_Number.CHON_GUI_MAIL].Visible = true; }
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 xuat_excel() { var v_start_row = 8; var v_start_col = 2; var v_obj_excel_rpt = new CExcelReport("f420_bao_cao_tai_chinh_hs_theo_lop.xlsx", v_start_row, v_start_col); v_obj_excel_rpt.AddFindAndReplaceItem("<tu_ngay>", string.Format("{0}/{1}/{2}", m_dat_tu_ngay.Value.Date.Day, m_dat_tu_ngay.Value.Month, m_dat_tu_ngay.Value.Year)); v_obj_excel_rpt.AddFindAndReplaceItem("<den_ngay>", string.Format("{0}/{1}/{2}", m_dat_den_ngay.Value.Day, m_dat_den_ngay.Value.Month, m_dat_den_ngay.Value.Year)); v_obj_excel_rpt.AddFindAndReplaceItem("<ten_lop>", m_cbo_lop.Text.Trim()); v_obj_excel_rpt.FindAndReplace(false); v_obj_excel_rpt.Export2ExcelWithoutFixedRows(m_fg, 0, m_fg.Cols.Count - 1, false); }
private void export_2_excel() { CExcelReport v_obj_excel_report = new CExcelReport("f710_bc_tinh_hinh_VPP_theo_phong_ban.xlsx", 7, 1); v_obj_excel_report.AddFindAndReplaceItem("<tu_ngay>", v_dt_tu_ngay.ToShortDateString()); v_obj_excel_report.AddFindAndReplaceItem("<den_ngay>", v_dt_den_ngay.ToShortDateString()); v_obj_excel_report.FindAndReplace(false); //v_obj_excel_report.Export2ExcelWithoutFixedRows(m_fg, 0, m_fg.Cols.Count - 1, true); v_obj_excel_report.Export2ExcelWithoutFixedRows_saveDialog("abc",m_fg, 0, m_fg.Cols.Count - 1, true); }
v_us.CommitTransaction(); m_grv_trang_thai.Rows.Remove(m_grv_trang_thai.Row); } catch (Exception v_e) { v_us.Rollback(); CDBExceptionHandler v_objErrHandler = new CDBExceptionHandler(v_e, new CDBClientDBExceptionInterpret()); v_objErrHandler.showErrorMessage();
private void export_excel() { CExcelReport v_obj_exe_report = new CExcelReport("BC-002 Bao cao ke khai xe o to.xls", 13, 1); ; switch (m_e_form_mode) { case eFormMode.KE_KHAI_O_TO: v_obj_exe_report = new CExcelReport("BC-002 Bao cao ke khai xe o to.xls", 13, 1); break; case eFormMode.O_TO_DE_NGHI_XU_LY: v_obj_exe_report = new CExcelReport("BC-005 Danh muc xe oto de nghi xu ly.xls", 13, 1); break; case eFormMode.O_TO_GIAO_DON_VI_SU_NGHIEP: v_obj_exe_report = new CExcelReport("BC-023 Bao cao danh muc xe o to giao cho don vi su nghiep cong lap tu chu tai chinh.xls", 13, 1); break; default: break; } v_obj_exe_report.AddFindAndReplaceItem("<BO_TINH>", m_cbo_bo_tinh.Text); v_obj_exe_report.AddFindAndReplaceItem("<DON_VI_CHU_QUAN>", m_cbo_don_vi_chu_quan.Text); v_obj_exe_report.AddFindAndReplaceItem("<DON_VI_SU_DUNG_TAI_SAN>", m_cbo_don_vi_su_dung.Text); v_obj_exe_report.AddFindAndReplaceItem("<MA_DON_VI>", m_txt_ma_don_vi.Text); v_obj_exe_report.AddFindAndReplaceItem("<LOAI_HINH_DON_VI>", m_txt_loai_hinh_don_vi.Text); v_obj_exe_report.FindAndReplace(false); v_obj_exe_report.Export2ExcelWithoutFixedRows(m_fg, 1, m_fg.Cols.Count - 1, true); }
v_objErrHandler.showErrorMessage(); } } private void export_2_excel() { CExcelReport v_obj_excel_report = new CExcelReport("f555_tong_hop_chi_phi_vpp.xls", 6, 1);
private void xuat_excel() { var v_start_row = 8; var v_start_col = 2; var v_obj_excel_rpt = new CExcelReport("f230_ds_hoc_vien_theo_lop.xlsx", v_start_row, v_start_col); v_obj_excel_rpt.AddFindAndReplaceItem("<ten_lop>", m_cbo_lop_mon.Text); v_obj_excel_rpt.FindAndReplace(false); v_obj_excel_rpt.Export2ExcelWithoutFixedRows(m_fg, 0, m_fg.Cols.Count - 1, false); }
private void export_2_excel() { CExcelReport v_obj_excel_report = new CExcelReport("f410_bc_chi_phi_theo_phap_nhan.xlsx", 5, 1); v_obj_excel_report.AddFindAndReplaceItem("<tu_ngay>", m_dt_tu_ngay.Text); v_obj_excel_report.AddFindAndReplaceItem("<den_ngay>", m_dt_den_ngay.Text); //v_obj_excel_report.AddFindAndReplaceItem("<trang_thai>", m_cbo_trang_thai.Text); v_obj_excel_report.FindAndReplace(false); v_obj_excel_report.Export2ExcelWithoutFixedRows(m_fg, 0, m_fg.Cols.Count - 1, true); }
private void export_2_excel_pn_pb() { CExcelReport v_obj_excel_report = new CExcelReport("f405_Tra_cuu_so_Bill_PN_PB.xls", 6, 1); v_obj_excel_report.AddFindAndReplaceItem("<tu_ngay>", m_dt_tu_ngay.Text); v_obj_excel_report.AddFindAndReplaceItem("<den_ngay>", m_dt_den_ngay.Text); v_obj_excel_report.AddFindAndReplaceItem("<phap_nhan>", m_cbo_ten_pb.Text); //v_obj_excel_report.AddFindAndReplaceItem("<trang_thai>", m_cbo_trang_thai.Text); v_obj_excel_report.FindAndReplace(false); v_obj_excel_report.Export2ExcelWithoutFixedRows(m_fg, 0, m_fg.Cols.Count - 5, true); }
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); }