protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { bGerado = false; Dados.StringDeConexao = ConfigurationManager.ConnectionStrings["GTIconnection"].ToString(); DebitoBLL obj = new DebitoBLL(); nValorTaxa = obj.TaxaExpediente(DateTime.Now.Year); ShowResult(false); txtVencto.Text = DateTime.Now.ToString("dd/MM/yyyy"); lblMsg2.Text = ""; } }
private void GeraGuia() { decimal tmpNumber = 0; StringBuilder sFullTrib; bGerado = true; List <Debito> lstExtrato = new List <Debito>(); DebitoBLL objDebitoBLL = new DebitoBLL(); Decimal nTaxaExp = objDebitoBLL.TaxaExpediente(DateTime.Now.Year); Debito reg; foreach (GridViewRow row in grdMain.Rows) { if (row.RowType == DataControlRowType.DataRow) { if ((row.FindControl("chkRow") as CheckBox).Checked) { reg = new Debito(); reg.Codigo = Convert.ToInt32(txtCod.Text); reg.Exercicio = Convert.ToInt32(row.Cells[1].Text); reg.Lancamento = Convert.ToInt16(row.Cells[2].Text.Substring(0, 3)); reg.Sequencia = Convert.ToInt16(row.Cells[3].Text); reg.Parcela = Convert.ToInt16(row.Cells[4].Text); reg.Complemento = Convert.ToInt16(row.Cells[5].Text); reg.DescLancamento = row.Cells[2].Text.Substring(4, row.Cells[2].Text.ToString().Length - 4); reg.DtVencimento = Convert.ToDateTime(row.Cells[6].Text); decimal.TryParse(row.Cells[7].Text, out tmpNumber); reg.VlTributo = tmpNumber; decimal.TryParse(row.Cells[8].Text, out tmpNumber); reg.VlJuros = tmpNumber; decimal.TryParse(row.Cells[9].Text, out tmpNumber); reg.VlMulta = tmpNumber; decimal.TryParse(row.Cells[10].Text, out tmpNumber); reg.VlCorrecao = tmpNumber; decimal.TryParse(row.Cells[11].Text, out tmpNumber); reg.VlTotal = tmpNumber; sFullTrib = new StringBuilder(); List <Debito> ListaTrib = objDebitoBLL.ListaTributos(reg); foreach (Debito Trib in ListaTrib) { if (sFullTrib.ToString().IndexOf(Trib.CodigoTributo.ToString("000")) == -1) { String CodTributo = Trib.CodigoTributo.ToString("000"); String DescTributo = Trib.DescTributo; sFullTrib.Append(CodTributo + "-" + DescTributo + "/"); } } sFullTrib.Remove(sFullTrib.Length - 1, 1); reg.DescTributo = sFullTrib.ToString(); lstExtrato.Add(reg); } } } //taxa de expediente reg = new Debito(); reg.Codigo = Convert.ToInt32(txtCod.Text); reg.Exercicio = DateTime.Now.Year; reg.Lancamento = 4; reg.Sequencia = 0; reg.Parcela = 1; reg.Complemento = 0; reg.DtVencimento = Convert.ToDateTime(txtVencto.Text); reg.DescTributo = "003-TAXA EXP.DOC."; reg.DescLancamento = ""; reg.VlTributo = nTaxaExp; reg.VlJuros = 0; reg.VlMulta = 0; reg.VlCorrecao = 0; reg.VlTotal = nTaxaExp; lstExtrato.Add(reg); float nValorGuia = 0; float.TryParse(TableTotal.Rows[2].Cells[6].Text, out nValorGuia); Int32 NumDoc = objDebitoBLL.GravaNovoDocumento(nValorGuia); objDebitoBLL.GravaDAMWeb(NumDoc); // NumDoc = Convert.ToInt32(txtimgcode.Text); foreach (Debito Lanc in lstExtrato) { objDebitoBLL.GravaParcelaDocumento(Lanc, NumDoc); } String sDataDAM = txtVencto.Text; Int32 nSID = objDebitoBLL.GravaBoletoDAM(lstExtrato, NumDoc, DateTime.ParseExact(sDataDAM, "dd/MM/yyyy", null)); Dados.StringDeConexao = ConfigurationManager.ConnectionStrings["GTIconnection"].ToString(); DebitoBLL obj = new DebitoBLL(); DataTable lista = obj.FillDataTableBoleto(nSID); ReportDocument crystalReport = new ReportDocument(); crystalReport.Load(Server.MapPath("~/Report/boletodam.rpt")); crystalReport.SetDataSource(lista); HttpContext.Current.Response.Buffer = false; HttpContext.Current.Response.ClearContent(); HttpContext.Current.Response.ClearHeaders(); objDebitoBLL.DeleteSID(nSID); try { crystalReport.ExportToHttpResponse(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat, HttpContext.Current.Response, true, "DAM" + nSID.ToString()); } catch { } finally { crystalReport.Close(); crystalReport.Dispose(); } }