Boolean Validar() { try { var ITEMS = ListExcel.ToList().FindAll(v => v.chk == true); foreach (var item in ITEMS) { if (string.IsNullOrEmpty(item.IdCtaCble)) { MessageBox.Show("Existen elmentos que no tienen Cta. Contable"); return(false); } if (item.dc_Valor <= 0) { MessageBox.Show("Existen montos en cero "); return(false); } } return(true); } catch (Exception ex) { string NameMetodo = System.Reflection.MethodBase.GetCurrentMethod().Name; MessageBox.Show(param.Get_Mensaje_sys(enum_Mensajes_sys.Error_comunicarse_con_sistemas) + ex.Message + " ", param.Nombre_sistema, MessageBoxButtons.OK, MessageBoxIcon.Error); Log_Error_bus.Log_Error(NameMetodo + " - " + ex.ToString()); return(false); } }
public static void SortLocFiles(DirectoryInfo langFolder) { if (!langFolder.Exists) { return; } var files = langFolder.GetFiles(); foreach (var fil in files) { switch (fil.Extension) { case ".dotx": case ".docx": case ".dotm": ListWord.Add(fil.FullName); break; case ".xltx": case ".xlsx": case ".xltm": ListExcel.Add(fil.FullName); break; case ".potx": case ".pptx": case ".potm": ListPpt.Add(fil.FullName); // Console.WriteLine(fil.Directory.Name); // To get the file language folder name break; } } }
private void ExportExcel(DataTable dt, int[] headerWidth) { if (dt != null && dt.Rows.Count > 0) { string title = this.GetExportTitle(); string path = FileDialogHelper.SaveExcel(title + ".xls"); if (path != null && path != string.Empty) { if (File.Exists(path)) { File.Delete(path); } ListExcel ls = new ListExcel(path, dt); ls.Title = title; ls.HeaderWidth = headerWidth; ls.GetExcelReport(); this.Cursor = Cursors.WaitCursor; MessageBoxHelper.Show("导出成功!"); this.Cursor = Cursors.Default; } } else { MessageBoxHelper.Show("没有找到可导出的数据!"); } }
public void CreateExcel(SpreadsheetDocument document, CardFaceUl template, object obj = null) { ListExcel excel = new ListExcel(document); var list1 = excel.CreateExcelList("Контрагенты"); AllDocumentExcel docNds = new AllDocumentExcel(excel.Document, excel.WorkBookPart); list1.Worksheet = docNds.ReportNds(template, (int)obj); excel.WorkBookPart.Workbook.Save(); }
public void CreateExcel(SpreadsheetDocument document, ReportCardModel template, object obj = null) { ListExcel excel = new ListExcel(document); var list1 = excel.CreateExcelList("Табель"); AllDocumentExcel docCard = new AllDocumentExcel(excel.Document, excel.WorkBookPart); list1.Worksheet = docCard.ReportCard(template); excel.WorkBookPart.Workbook.Save(); }
public void CreateExcel(SpreadsheetDocument document, List <AllIpServerSelect> template, object obj = null) { ListExcel excel = new ListExcel(document); var list1 = excel.CreateExcelList("Сервера"); AllDocumentExcel docCard = new AllDocumentExcel(excel.Document, excel.WorkBookPart); list1.Worksheet = docCard.ReportStatusIpServer(template); excel.WorkBookPart.Workbook.Save(); }
/// <summary> /// ListExcel导出名叫reportname的excel报表 /// </summary> /// <param name="reportname">报表名字带xls后缀</param> /// <param name="listExcel">ListExcel</param> public static void ExportExcelReport(string reportname, ListExcel listExcel) { System.Web.HttpContext.Current.Response.Clear(); System.Web.HttpContext.Current.Response.ContentEncoding = System.Text.Encoding.UTF8; System.Web.HttpContext.Current.Response.AddHeader("Content-Disposition", "attachment; filename=" + System.Web.HttpUtility.UrlEncode(reportname)); System.Web.HttpContext.Current.Response.ContentType = "application/ms-excel"; string filename = listExcel.GetExcelReport(); FileInfo file = new FileInfo(filename); System.Web.HttpContext.Current.Response.AddHeader("Content-Length", file.Length.ToString()); //添加头文件,指定文件的大小,让浏览器显示文件下载的速度 System.Web.HttpContext.Current.Response.WriteFile(file.FullName); // 把文件流发送到客户端 System.Web.HttpContext.Current.Response.End(); }
private void Export() { DataTable dt = this.GetTableFromGrid(); string path = FileDialogHelper.SaveExcel(this.GetTitle() + ".xls"); if (path != null && path != string.Empty) { if (File.Exists(path)) { File.Delete(path); } ListExcel ls = new ListExcel(path, dt); ls.Title = this.GetTitle(); ls.GetExcelReport(); this.Cursor = Cursors.WaitCursor; MessageBoxHelper.Show("导出成功!"); this.Cursor = Cursors.Default; } }
private void btnAceptar_Click(object sender, EventArgs e) { try { var ITEMS = ListExcel.ToList().FindAll(v => v.chk == true); if (!Validar()) { return; } ct_Periodo_Bus BusPeriodo = new ct_Periodo_Bus(); ba_Cbte_Ban_Bus BUSBANCOSCOMPROBANTE = new ba_Cbte_Ban_Bus(); List <ba_Cbte_Ban_tipo_x_ct_CbteCble_tipo_Info> _Parametros_ = _BusCbtBanXCtbtCble.Get_List_Cbte_Ban_tipo_x_ct_CbteCble_tipo(param.IdEmpresa); foreach (var item in ITEMS) { var prm = _Parametros_.First(v => v.CodTipoCbteBan == item.CodTipoCbteBan.Trim()); ct_Cbtecble_Info CabeceraCbte = new ct_Cbtecble_Info(); CabeceraCbte.IdEmpresa = param.IdEmpresa; CabeceraCbte.IdTipoCbte = prm.IdTipoCbteCble; CabeceraCbte.IdPeriodo = BusPeriodo.Get_Info_Periodo(param.IdEmpresa, item.cb_Fecha, ref MensajeError).IdPeriodo; CabeceraCbte.IdUsuario = param.IdUsuario; CabeceraCbte.IdUsuarioUltModi = param.IdUsuario; CabeceraCbte.Mayorizado = "N"; CabeceraCbte.cb_Fecha = item.cb_Fecha; CabeceraCbte.cb_Observacion = item.cb_Observacion; CabeceraCbte.cb_Valor = item.dc_Valor; CabeceraCbte.Estado = "A"; CabeceraCbte.cb_FechaTransac = param.Fecha_Transac; CabeceraCbte.cb_FechaUltModi = CabeceraCbte.cb_FechaTransac; ct_Cbtecble_det_Info DetalleInfo = new ct_Cbtecble_det_Info(); DetalleInfo.IdEmpresa = param.IdEmpresa; DetalleInfo.IdTipoCbte = CabeceraCbte.IdEmpresa; DetalleInfo.secuencia = 1; DetalleInfo.IdCtaCble = IdCtaCbleBanco; DetalleInfo.IdCentroCosto = item.IdCentroCosto; if (item.CodTipoCbteBan == "NCBA") { DetalleInfo.dc_Valor = item.dc_Valor * -1; } if (item.CodTipoCbteBan == "NDBA") { DetalleInfo.dc_Valor = item.dc_Valor; } DetalleInfo.dc_Observacion = item.cb_Observacion; CabeceraCbte._cbteCble_det_lista_info.Add(DetalleInfo); DetalleInfo = new ct_Cbtecble_det_Info(); DetalleInfo.IdEmpresa = param.IdEmpresa; DetalleInfo.IdTipoCbte = CabeceraCbte.IdEmpresa; DetalleInfo.secuencia = 2; DetalleInfo.IdCtaCble = item.IdCtaCble; DetalleInfo.IdCentroCosto = item.IdCentroCosto; if (item.CodTipoCbteBan == "NCBA") { DetalleInfo.dc_Valor = item.dc_Valor; } if (item.CodTipoCbteBan == "NDBA") { DetalleInfo.dc_Valor = item.dc_Valor * -1; } DetalleInfo.dc_Observacion = item.cb_Observacion; CabeceraCbte._cbteCble_det_lista_info.Add(DetalleInfo); decimal IdCbte = 0; string Mensaje = ""; string Codigo = ""; BUS_CONTABILIDAD.GrabarDB(CabeceraCbte, ref IdCbte, ref Mensaje); item.IdHASH = string.Format("{0}-MOVI_BAN$-s{1}-{2}-{3}-d{4}-{5}-{6}", fileName, item.SecuenciaRelacionado, item.cb_Fecha, item.CodTipoCbteBan, item.cb_Cheque, item.cb_Observacion, item.dc_Valor); ba_Cbte_Ban_Info COMPROBANTEBANCARIO = new ba_Cbte_Ban_Info(); COMPROBANTEBANCARIO.IdEmpresa = param.IdEmpresa; COMPROBANTEBANCARIO.IdCbteCble = IdCbte; COMPROBANTEBANCARIO.IdTipocbte = CabeceraCbte.IdTipoCbte; COMPROBANTEBANCARIO.Cod_Cbtecble = Codigo; COMPROBANTEBANCARIO.IdPeriodo = CabeceraCbte.IdPeriodo; COMPROBANTEBANCARIO.IdBanco = IdBanco; COMPROBANTEBANCARIO.cb_Fecha = item.cb_Fecha; COMPROBANTEBANCARIO.cb_Observacion = item.cb_Observacion; COMPROBANTEBANCARIO.cb_Valor = item.dc_Valor; COMPROBANTEBANCARIO.cb_ChequeImpreso = "N"; COMPROBANTEBANCARIO.IdUsuario = param.IdUsuario; COMPROBANTEBANCARIO.IdUsuarioUltMod = param.IdUsuario; COMPROBANTEBANCARIO.ip = param.ip; COMPROBANTEBANCARIO.nom_pc = param.nom_pc; COMPROBANTEBANCARIO.Fecha_Transac = param.Fecha_Transac; COMPROBANTEBANCARIO.Fecha_UltMod = COMPROBANTEBANCARIO.Fecha_Transac; //COMPROBANTEBANCARIO.IdTipoNota = null; COMPROBANTEBANCARIO.IdTransaccion = item.IdHASH; BUSBANCOSCOMPROBANTE.GrabarDB(COMPROBANTEBANCARIO, ref MensajeError); item.IdCbteCble = IdCbte; item.IdTipocbte = CabeceraCbte.IdTipoCbte; } GetList_NotadasDeb_Cred(ITEMS); Close(); } catch (Exception ex) { string NameMetodo = System.Reflection.MethodBase.GetCurrentMethod().Name; MessageBox.Show(param.Get_Mensaje_sys(enum_Mensajes_sys.Error_comunicarse_con_sistemas) + ex.Message + " ", param.Nombre_sistema, MessageBoxButtons.OK, MessageBoxIcon.Error); Log_Error_bus.Log_Error(NameMetodo + " - " + ex.ToString()); } }
private static void Main(string[] args) { Console.WriteLine(DateTime.Now + " " + "Developed by Moravia Publishing & Media automation team. All rights reserved." + "\n"); Console.WriteLine("Please input the root directory of loc templates folders >> "); Console.WriteLine("========================================"); Input: var dirInput = Console.ReadLine(); Console.WriteLine("========================================"); Console.WriteLine("In progress of processing, please hold on and wait for a while :) "); Console.WriteLine("========================================"); // Check if input path is empty if (string.IsNullOrEmpty(dirInput) && string.IsNullOrWhiteSpace(dirInput)) { Console.WriteLine("Empty or invalid directory, please double check and re-enter it!"); goto Input; } // Transfer input directory string to DirectoryInfo if (!File.Exists(dirInput) && Directory.Exists(dirInput)) { if (!dirInput.EndsWith("\\")) { dirInput = dirInput + "\\"; } var dirInfo = new DirectoryInfo(dirInput); // Get all subfolder names and add into LocalLanguage List try { ListLangFolders(dirInfo); } catch (Exception ex) { Console.WriteLine("Error when create folders list: " + ex.Message); return; } foreach (var lang in ListLang) { try { var langDirInfo = new DirectoryInfo(dirInput + lang + "\\"); SortLocFiles(langDirInfo); } catch (IOException e) { Console.WriteLine("Fail to sort files: " + e.Message); return; } } } else if (File.Exists(dirInput)) { var fileInfo = new FileInfo(dirInput); switch (fileInfo.Extension) { case ".dotx": case ".docx": case ".dotm": ListWord.Add(fileInfo.FullName); break; case ".xltx": case ".xlsx": case ".xltm": ListExcel.Add(fileInfo.FullName); break; case ".potx": case ".pptx": case ".potm": ListPpt.Add(fileInfo.FullName); break; } } KillProcess(); // PowerPointHandler if (ListPpt.Count > 0) { foreach (var f in ListPpt) { if (f.Contains("~$")) { continue; } Console.Write("\r\n" + "Processing: "); Common.WriteLine("\r\n" + f + "\r\n"); var objPpt = new PowerPointHandler(f); objPpt.PptMain(f); Common.WriteSglText(f); } } // WordHandler if (ListWord.Count > 0) { foreach (var f in ListWord) { if (f.Contains("~$")) { continue; } Console.Write("\r\n" + "Processing: "); Common.WriteLine("\r\n" + f + "\r\n"); var objWordHandler = new WordHandler(f); objWordHandler.WordMain(f); Common.WriteSglText(f); } } // Process ExcelHandler files if (ListExcel.Count > 0) { foreach (var f in ListExcel) { if (f.Contains("~$")) { continue; } Console.Write("\r\n" + "Processing: "); Common.WriteLine("\r\n" + f + "\r\n"); var objExcelHandler = new ExcelHandler(f); objExcelHandler.ExcelMain(f); Common.WriteSglText(f); } } // Write all Console content to text Common.WriteAllText(dirInput); // End Console.WriteLine("========================================"); Console.WriteLine("All files process complete! You are good to go!"); Console.ReadLine(); }