private void btnGeneraFileIncassi_Click(object sender, EventArgs e) { int n = CfgFn.GetNoNullInt32(txtNproceedsTransm.Text); if (n == 0) { MessageBox.Show(this, "E' necessario selezionare un numero per la distinta"); return; } int y = CfgFn.GetNoNullInt32(Conn.GetSys("esercizio")); string filterProceedsTransmission = QHS.AppAnd(QHS.CmpEq("yproceedstransmission", y), QHS.CmpEq("nproceedstransmission", n)); object idtreasurer = Conn.DO_READ_VALUE("proceedstransmission", filterProceedsTransmission, "idtreasurer"); object flagtransmissionenabled = Conn.DO_READ_VALUE("proceedstransmission", filterProceedsTransmission, "flagtransmissionenabled"); object cfgflagenabletransmission = Conn.DO_READ_VALUE("config", QHS.CmpEq("ayear", y), "flagenabletransmission"); if (cfgflagenabletransmission != DBNull.Value) { string cfg_flag = cfgflagenabletransmission.ToString().ToUpper(); if ((cfg_flag == "S") && (flagtransmissionenabled.ToString().ToUpper() != "S")) { MessageBox.Show(this, "La trasmissione della distinta non è stata autorizzata"); return; } } EsportazioneDistinteIncasso E = new EsportazioneDistinteIncasso(Conn, y, n); XmlDocument D = E.GeneraFileXML(); string filterTreasurer = QHS.CmpEq("idtreasurer", idtreasurer); string fname = ""; object savepath = Conn.DO_READ_VALUE("treasurer", filterTreasurer, "savepath"); if (savepath != DBNull.Value) { fname = Path.Combine(savepath.ToString(), Meta.GetSys("esercizio") + "_reversali_" + n.ToString()); } else { saveFileDialog1.FileName = Meta.GetSys("esercizio") + "_reversali_" + n.ToString(); DialogResult dialogResult = saveFileDialog1.ShowDialog(this); if (dialogResult == DialogResult.Cancel) { return; } fname = saveFileDialog1.FileName; } try { XmlWriterSettings xs = new XmlWriterSettings(); xs.Indent = true; xs.CloseOutput = true; xs.Encoding = Encoding.GetEncoding("ISO-8859-15"); XmlWriter xw = XmlWriter.Create(fname, xs); D.WriteTo(xw); xw.Flush(); xw.Close(); MessageBox.Show("Salvataggio del file " + fname + " effettuato"); TreasurerPutFile ftp = new TreasurerPutFile(Conn, idtreasurer); ftp.putFile(fname, Meta.GetSys("esercizio") + "_reversali_" + n.ToString()); } catch (Exception e1) { QueryCreator.ShowException("Errore nel salvataggio del file " + fname, e1); return; } try { XslCompiledTransform xsltransform = new XslCompiledTransform(); xsltransform.Load(AppDomain.CurrentDomain.BaseDirectory + "ORDINATIVI_3.02.xslt"); // Terzo metodo creazione da stringta XML Stream transformedData = new MemoryStream(); String xmlString = D.InnerXml; //String xmlString1 = ("<flusso_ordinativi genre='novel' ISBN='1-861001-57-5'>" + // "<informazioni_versante>Pride And Prejudice</informazioni_versante>" + // "</flusso_ordinativi>"); XmlDocument doc = new XmlDocument(); doc.LoadXml(xmlString); xsltransform.Transform(doc, null, transformedData); transformedData.Seek(0, SeekOrigin.Begin); webBrowser1.DocumentStream = transformedData; } catch (Exception e2) { QueryCreator.ShowException("Errore cercando di visualizzare il file " + fname, e2); return; } try { bool res = XML_XSD_Validator.Validate(fname, AppDomain.CurrentDomain.BaseDirectory + "ORDINATIVI_3.02.XSD"); if (!res) { QueryCreator.ShowError(this, "Errore nella validazione dell'xml", XML_XSD_Validator.GetError()); return; } } catch (Exception e3) { QueryCreator.ShowException("Errore validando il file " + fname, e3); return; } AggiornaStreamDate("PROCEEDSTRANSMISSION", y, n); //try //{ // Process.Start(fname); //} //catch (Exception E1) //{ // QueryCreator.ShowException(E1); //} }
private void btnGeneraFilePagamenti_Click(object sender, EventArgs e) { int n = CfgFn.GetNoNullInt32(txtNPaymentTransmission.Text); if (n == 0) { MessageBox.Show(this, "E' necessario selezionare un numero per la distinta"); return; } int y = CfgFn.GetNoNullInt32(Conn.GetSys("esercizio")); string filterPaymentTransmission = QHS.AppAnd(QHS.CmpEq("ypaymenttransmission", y), QHS.CmpEq("npaymenttransmission", n)); object idtreasurer = Conn.DO_READ_VALUE("paymenttransmission", filterPaymentTransmission, "idtreasurer"); object flagtransmissionenabled = Conn.DO_READ_VALUE("paymenttransmission", filterPaymentTransmission, "flagtransmissionenabled"); object cfgflagenabletransmission = Conn.DO_READ_VALUE("config", QHS.CmpEq("ayear", y), "flagenabletransmission"); if (cfgflagenabletransmission != DBNull.Value) { string cfg_flag = cfgflagenabletransmission.ToString().ToUpper(); if ((cfg_flag == "S") && (flagtransmissionenabled.ToString().ToUpper() != "S")) { MessageBox.Show(this, "La trasmissione della distinta non è stata autorizzata"); return; } } EsportazioneDistintePagamento E = new EsportazioneDistintePagamento(Conn, y, n); XmlDocument D = E.GeneraFileXML(); if (D == null) { return; } string filterTreasurer = QHS.CmpEq("idtreasurer", idtreasurer); string fname = ""; object savepath = Conn.DO_READ_VALUE("treasurer", filterTreasurer, "savepath"); if (savepath != DBNull.Value) { fname = Path.Combine(savepath.ToString(), Meta.GetSys("esercizio") + "_mandati_" + n.ToString()); } else { saveFileDialog1.FileName = Meta.GetSys("esercizio") + "_mandati_" + n.ToString(); DialogResult dialogResult = saveFileDialog1.ShowDialog(this); if (dialogResult == DialogResult.Cancel) { return; } fname = saveFileDialog1.FileName; } try { XmlWriterSettings xs = new XmlWriterSettings(); xs.Indent = true; xs.CloseOutput = true; xs.Encoding = Encoding.GetEncoding("ISO-8859-15"); XmlWriter xw = XmlWriter.Create(fname, xs); D.WriteTo(xw); xw.Flush(); xw.Close(); MessageBox.Show("Salvataggio del file " + fname + " effettuato"); TreasurerPutFile ftp = new TreasurerPutFile(Conn, idtreasurer); ftp.putFile(fname, Meta.GetSys("esercizio") + "_mandati_" + n.ToString()); } catch (Exception e1) { QueryCreator.ShowException("Errore nel salvataggio del file " + fname, e1); return; } try { XslCompiledTransform xsltransform = new XslCompiledTransform(); xsltransform.Load(AppDomain.CurrentDomain.BaseDirectory + "ORDINATIVI_3.02.xslt"); Stream transformedData = new MemoryStream(); xsltransform.Transform(D, null, transformedData); transformedData.Seek(0, SeekOrigin.Begin); webBrowser1.DocumentStream = transformedData; } catch (Exception e2) { QueryCreator.ShowException("Errore cercando di visualizzare il file " + fname, e2); return; } try { bool res = XML_XSD_Validator.Validate(fname, AppDomain.CurrentDomain.BaseDirectory + "ORDINATIVI_3.02.XSD"); if (!res) { QueryCreator.ShowError(this, "Errore nella validazione dell'xml", XML_XSD_Validator.GetError()); return; } } catch (Exception e3) { QueryCreator.ShowException("Errore validando il file " + fname, e3); return; } AggiornaStreamDate("PAYMENTTRANSMISSION", y, n); }