protected void generar(Object Sender, EventArgs e) { string [] pr = new string[2]; pr[0] = pr[1] = ""; Press frontEnd = new Press(new DataSet(), reportTitle); frontEnd.PreHeader(tabPreHeader, Grid.Width, pr); frontEnd.Firmas(tabFirmas, Grid.Width); lb.Text = ""; this.PrepararTabla(); lineas = new DataSet(); DBFunctions.Request(lineas, IncludeSchema.NO, "select distinct pcv.pcat_descripcion as modelo,mpv.mped_valounit as valor_total, mpv.mped_valounit/(1+(pcv.piva_porciva*0.01)) as valorunitario, mpv.mped_valounit - (mpv.mped_valounit/(1+(pcv.piva_porciva*0.01))) as valor_iva from dbxschema.mpedidovehiculo mpv, dbxschema.pcatalogovehiculo pcv,dbxschema.mcatalogovehiculo mcv, dbxschema.mnit mn, dbxschema.mvehiculo mv, dbxschema.mfacturacliente mfc, dbxschema.pvendedor pv, dbxschema.masignacionvehiculo mav,dbxschema.pclasevehiculo pclv, dbxschema.mfacturapedidovehiculo mfpv where mfc.pven_codigo = pv.pven_codigo and mfpv.pdoc_codigo = mfc.pdoc_codigo and mfpv.mped_codigo = mpv.pdoc_codigo and mfpv.mped_numepedi = mpv.mped_numepedi and mpv.pdoc_codigo = mav.pdoc_codigo and mpv.mped_numepedi = mav.mped_numepedi and mav.mveh_inventario = mv.mveh_inventario and mv.mcat_vin = mcv.mcat_vin and mcv.pcat_codigo = pcv.pcat_codigo and pcv.pcla_codigo = pclv.pcla_codigo"); for (int i = 0; i < lineas.Tables[0].Rows.Count; i++) { //Vamos a crear una fila para nuestro DataTable resultado, que almacene los resultados de las operaciones anteriores DataRow fila; Valto = Convert.ToInt32(lineas.Tables[0].Rows[i].ItemArray[1]); Valun = Convert.ToInt32(lineas.Tables[0].Rows[i].ItemArray[2]); total = Convert.ToDouble(lineas.Tables[0].Rows[i].ItemArray[1]); unitario = Convert.ToDouble(lineas.Tables[0].Rows[i].ItemArray[2]); poiva = Convert.ToDouble(lineas.Tables[0].Rows[i].ItemArray[3]); /////////////////////////////////// total1 = String.Format("{0:C}", total); unitario1 = String.Format("{0:C}", unitario); poiva1 = String.Format("{0:C}", poiva); //////////////////////////// int cantidad = 0; cantidad = (Valto / Valun); fila = resultado.NewRow(); fila["MODELO"] = lineas.Tables[0].Rows[i].ItemArray[0].ToString(); fila["VALORUNITARIO"] = unitario1; fila["VALORTOTAL"] = total1; fila["PORCENTAJE"] = poiva1; fila["CANTIDAD"] = cantidad; resultado.Rows.Add(fila); } //fin sentencia FOR Grid.DataSource = resultado; Grid.DataBind(); StringBuilder SB = new StringBuilder(); StringWriter SW = new StringWriter(SB); HtmlTextWriter htmlTW = new HtmlTextWriter(SW); tabPreHeader.RenderControl(htmlTW); Grid.RenderControl(htmlTW); tabFirmas.RenderControl(htmlTW); string strRep; strRep = SB.ToString(); Session.Clear(); Session["Rep"] = strRep; //toolsHolder.Visible = true; }
protected void generar(Object Sender, EventArgs e) { string [] pr = new string[2]; pr[0] = pr[1] = ""; Press frontEnd = new Press(new DataSet(), reportTitle); frontEnd.PreHeader(tabPreHeader, Grid.Width, pr); frontEnd.Firmas(tabFirmas, Grid.Width); lb.Text = ""; Año = Convert.ToInt32(año.SelectedValue.ToString()); Mes = Convert.ToInt32(DBFunctions.SingleData("SELECT pmes_mes FROM DBXSCHEMA.pmes WHERE pmes_nombre='" + mes.SelectedValue.ToString() + "' ")); /////////////////////////////////////////////////////// this.PrepararTabla(); lineas = new DataSet(); DBFunctions.Request(lineas, IncludeSchema.NO, "select MBR.MBUSR_FECHA,MBR.MCAT_PLACA,MBR.ORIGEN,MBR.DESTINO,MBR.NOMBRE_RESERVA,MBR.VALOR_RESERVA FROM DBXSCHEMA.MBUS_RENTADO MBR,DBXSCHEMA.MBUSAFILIADO MBUS WHERE MBR.MCAT_PLACA=MBUS.MCAT_PLACA AND MBUS.TESTA_CODIGO=6 AND year(MBR.MBUSR_FECHA)=" + Año + " and month(MBR.MBUSR_FECHA)=" + Mes + " "); for (int i = 0; i < lineas.Tables[0].Rows.Count; i++) { //Vamos a crear una fila para nuestro DataTable resultado, que almacene los resultados de las operaciones anteriores DataRow fila; //SaldoFinal1=String.Format("{0:C}",saldoLinea); fila = resultado.NewRow(); double valor = 0; string ValorFormato = null; valor = Convert.ToDouble(lineas.Tables[0].Rows[i].ItemArray[5].ToString()); ValorFormato = String.Format("{0:C}", valor); fila["FECHA"] = lineas.Tables[0].Rows[i].ItemArray[0].ToString(); fila["PLACA"] = lineas.Tables[0].Rows[i].ItemArray[1].ToString(); fila["ORIGEN"] = lineas.Tables[0].Rows[i].ItemArray[2].ToString(); fila["DESTINO"] = lineas.Tables[0].Rows[i].ItemArray[3].ToString(); fila["CONTRATANTE"] = lineas.Tables[0].Rows[i].ItemArray[4].ToString(); fila["VALCONTRATO"] = ValorFormato.ToString(); resultado.Rows.Add(fila); } //fin sentencia FOR Grid.DataSource = resultado; Grid.DataBind(); StringBuilder SB = new StringBuilder(); StringWriter SW = new StringWriter(SB); HtmlTextWriter htmlTW = new HtmlTextWriter(SW); tabPreHeader.RenderControl(htmlTW); Grid.RenderControl(htmlTW); tabFirmas.RenderControl(htmlTW); string strRep; strRep = SB.ToString(); Session.Clear(); Session["Rep"] = strRep; toolsHolder.Visible = true; }
public void Cargar(object sender, System.EventArgs e) { plDownload.Controls.Clear(); string preP = "", numP = ""; string sa = ddlPeds.SelectedValue.ToString(); preP = sa.Substring(0, sa.LastIndexOf("-")).Trim(); numP = sa.ToString().Substring(sa.LastIndexOf("-") + 1).Trim(); ds = new DataSet(); DBFunctions.Request(ds, IncludeSchema.NO, "select t1.MPED_CLASREGI as ped_tipo, t1.PPED_CODIGO as ped_ref, t1.MPED_NUMEPEDI as ped_num, DBXSCHEMA.EDITARREFERENCIAS(t1.mite_codigo,t4.plin_tipo) as mite_codigo, t2.mite_nombre as mite_nombre, t1.dped_cantpedi as mite_cant, t3.msal_costprom as mite_precio, t1.piva_porciva as mite_piva, (t1.dped_cantpedi*t3.msal_costprom) + (t1.piva_porciva*(t1.dped_cantpedi*t3.msal_costprom))/100 as mite_total from dpedidoitem as t1, mitems as t2, msaldoitem as t3, plineaitem as t4 where t1.mite_codigo=t2.mite_codigo and t3.mite_codigo=t2.mite_codigo and t1.pped_codigo='" + preP + "' and t1.mped_numepedi=" + numP + " and t3.pano_ano=" + DBFunctions.SingleData("SELECT pano_ano from cinventario") + " and t2.plin_codigo=t4.plin_codigo"); // 0 1 2 3 4 5 6 7 8 int n; if (ds.Tables[0].Rows.Count <= 0) { Utils.MostrarAlerta(Response, "No hay items en el pedido!"); return; } double st = 0, t = 0, iva = 0, at, ia; for (n = 0; n < ds.Tables[0].Rows.Count; n++) { at = Convert.ToDouble(ds.Tables[0].Rows[n][5]) * Convert.ToDouble(ds.Tables[0].Rows[n][6]); st += at; ia = (Convert.ToDouble(ds.Tables[0].Rows[n][7]) / 100) * at; iva += ia; t += at + ia; ds.Tables[0].Rows[n][0] = (n + 1).ToString(); } DataRow nr = ds.Tables[0].NewRow(); nr[0] = "Subtotal:"; nr[8] = st; ds.Tables[0].Rows.Add(nr); nr = ds.Tables[0].NewRow(); nr[0] = "IVA:"; nr[8] = iva; ds.Tables[0].Rows.Add(nr); nr = ds.Tables[0].NewRow(); nr[0] = "Total:"; nr[8] = t; ds.Tables[0].Rows.Add(nr); dgItems.Visible = true; dgItems.DataSource = ds.Tables[0]; dgItems.DataBind(); DatasToControls.JustificacionGrilla(dgItems, ds.Tables[0]); btnGuarda.Visible = toolsHolder.Visible = btnReiniciar.Visible = true; ddlNIT.Enabled = ddlPeds.Enabled = btnCarga.Enabled = false; string [] pr = new string[2]; tabPreHeader = new Table(); tabFirmas = new Table(); pr[0] = "Nit: " + ddlNIT.SelectedItem.Text; pr[1] = DBFunctions.SingleData("SELECT t1.MNIT_DIRECCION concat ' - ' concat t2.pciu_nombre concat ' - ' concat t1.mnit_telefono FROM MNIT as t1, pciudad as t2 where t2.PCIU_CODIGO=t1.PCIU_CODIGO and MNIT_NIT='" + ddlNIT.SelectedValue + "'"); Press frontEnd = new Press(new DataSet(), reportTitle); frontEnd.PreHeader(tabPreHeader, dgItems.Width, pr); frontEnd.Firmas(tabFirmas, dgItems.Width); StringBuilder SB = new StringBuilder(); StringWriter SW = new StringWriter(SB); HtmlTextWriter htmlTW = new HtmlTextWriter(SW); tabPreHeader.RenderControl(htmlTW); dgItems.RenderControl(htmlTW); tabFirmas.RenderControl(htmlTW); string strRep; strRep = SB.ToString(); Session.Clear(); Session["Rep"] = strRep; }
protected void Consulta_Click(object Sender, EventArgs e) { string[] pr = new string[2]; pr[0] = pr[1] = ""; Press frontEnd = new Press(new DataSet(), reportTitle); frontEnd.PreHeader(tabPreHeader, dg.Width, pr); frontEnd.Firmas(tabFirmas, dg.Width); string sql = " select PDOC_CODIGO, MCOM_NUMEDOCU, MCOM_FECHA, MCOM_RAZON, MCOM_FECHAPROC, MCOM_USUARIO, MCOM_VALOR from MCOMPROBANTE where PMES_MES = " + month.SelectedValue + " AND PANO_ANO =" + year.SelectedValue; //0 1 2 3 4 5 6 //string sql1 = "select MC.MCUE_NOMBRE CONCAT ' - ' CONCAT DC.MCUE_CODIPUC ,DCUE_CODIREFE,DCUE_NUMEREFE,DCUE_DETALLE,PALM_ALMACEN,PCEN_CODIGO || ' - ' || Nit || ' - ' || NOMBRE,DCUE_VALODEBI,DCUE_VALOCRED,DCUE_VALOBASE, PDOC_CODIGO, MCOM_NUMEDOCU, dcue_niifdebi, dcue_niifcred from dcuenta DC, MCUENTA MC, VMNIT where vmnit.mnit_nit=DC.mnit_nit AND DC.MCUE_CODIPUC = MC.MCUE_CODIPUC"; string sql1 = "select MCUE_CODIPUC ,DCUE_CODIREFE,DCUE_NUMEREFE,DCUE_DETALLE,PALM_ALMACEN,PCEN_CODIGO || ' - ' || Nit || ' - ' || NOMBRE,DCUE_VALODEBI,DCUE_VALOCRED,DCUE_VALOBASE, PDOC_CODIGO, MCOM_NUMEDOCU, dcue_niifdebi, dcue_niifcred from dcuenta, VMNIT where vmnit.mnit_nit=DCUENTA.mnit_nit "; //0 1 2 3 4 5 6 7 8 9 10 CultureInfo bz = new CultureInfo("en-us"); //Uno if (RadioOpcion.SelectedValue == "UCE") { if (ddlNumComp.Items.Count == 0) { return; } sql += " AND MCOM_NUMEDOCU = " + ddlNumComp.SelectedValue + " AND PDOC_CODIGO='" + typeDoc.SelectedValue + "'"; sql1 += " AND MCOM_NUMEDOCU = " + ddlNumComp.SelectedValue + " AND PDOC_CODIGO='" + typeDoc.SelectedValue + "'"; ViewState["CONSULTAExcel"] = sql1; } //Un tipo if (RadioOpcion.SelectedValue == "UTC") { if (ddlNumComp.Items.Count == 0) { return; } sql += " AND PDOC_CODIGO='" + typeDoc.SelectedValue + "'"; sql1 += " AND PDOC_CODIGO='" + typeDoc.SelectedValue + "'"; ViewState["CONSULTAExcel"] = sql1; } sql += " ORDER BY PDOC_CODIGO, MCOM_NUMEDOCU"; sql1 += " ORDER BY PDOC_CODIGO, MCOM_NUMEDOCU, MCUE_CODIPUC"; ViewState["CONSULTAExcel"] = sql1; DBFunctions.Request(ds, IncludeSchema.NO, sql); DBFunctions.Request(ds, IncludeSchema.NO, sql1); DBFunctions.Request(ds, IncludeSchema.NO, "SELECT MCUE_CODIPUC, MCUE_NOMBRE FROM MCUENTA"); string[] titleFields = { "Cod Doc.", "Nº Comprobante", "Fecha", "Razon", "Fecha Proc. Débito", "Usuario Crédito", "Valor", "Débito NIIF", "Crédito NIIF" }; string[] dataFields = { "Cod Doc.", "Nº Comprobante", "Fecha", "Razon", "Fecha Proc. Débito", "Usuario Crédito", "Valor", "Débito NIIF", "Crédito NIIF" }; int i, j, k; for (i = 0; i < titleFields.Length; i++) { BoundColumn bc = new BoundColumn(); bc.HeaderText = titleFields[i]; bc.DataField = dataFields[i]; bc.DataFormatString = "{0:N}"; dg.Columns.Add(bc); } DataTable dtRep = new DataTable(); for (i = 0; i < titleFields.Length; i++) { dtRep.Columns.Add(new DataColumn(dataFields[i], typeof(string))); } DataRow dr; DataRow[] rows; DataRow[] rowsC; double deb, cred, d, c, debNIIF, credNIIF, dNIIF, cNIIF; bool res = false; ArrayList Cods = new ArrayList(); ArrayList Debs = new ArrayList(); ArrayList Creds = new ArrayList(); ArrayList CodsNIIF = new ArrayList(); ArrayList DebsNIIF = new ArrayList(); ArrayList CredsNIIF = new ArrayList(); for (i = 0; i < ds.Tables[0].Rows.Count; i++) { dr = dtRep.NewRow(); dr[0] = ds.Tables[0].Rows[i].ItemArray[0].ToString(); dr[1] = ds.Tables[0].Rows[i].ItemArray[1].ToString(); dr[2] = ds.Tables[0].Rows[i].ItemArray[2].ToString(); dr[3] = ds.Tables[0].Rows[i].ItemArray[3].ToString(); dr[4] = ds.Tables[0].Rows[i].ItemArray[4].ToString(); dr[5] = ds.Tables[0].Rows[i].ItemArray[5].ToString(); dr[6] = ((double)Convert.ToDouble(ds.Tables[0].Rows[i].ItemArray[6])).ToString("N"); dtRep.Rows.Add(dr); rows = ds.Tables[1].Select("PDOC_CODIGO = '" + ds.Tables[0].Rows[i].ItemArray[0].ToString() + "' and MCOM_NUMEDOCU='" + ds.Tables[0].Rows[i].ItemArray[1].ToString() + "'"); deb = cred = debNIIF = credNIIF = 0; for (j = 0; j < rows.Length; j++) { string nombre = DBFunctions.SingleData("SELECT MCUE_NOMBRE FROM MCUENTA WHERE MCUE_CODIPUC = '" + rows[j][0] + "'"); dr = dtRep.NewRow(); dr[0] = "»" + rows[j][0] + " - " + nombre; dr[1] = rows[j][1] + " - " + rows[j][2]; dr[2] = rows[j][3]; dr[3] = rows[j][4] + " - " + rows[j][5]; dr[4] = ((double)Convert.ToDouble(rows[j][6])).ToString("N"); dr[5] = ((double)Convert.ToDouble(rows[j][7])).ToString("N"); dr[6] = ((double)Convert.ToDouble(rows[j][8])).ToString("N"); dr[7] = ((double)Convert.ToDouble(rows[j][11])).ToString("N"); dr[8] = ((double)Convert.ToDouble(rows[j][12])).ToString("N"); d = Convert.ToDouble(rows[j][6]); c = Convert.ToDouble(rows[j][7]); dNIIF = Convert.ToDouble(rows[j][11]); cNIIF = Convert.ToDouble(rows[j][12]); Inserta(Cods, Debs, Creds, rows[j][0].ToString(), d, c); Inserta(CodsNIIF, DebsNIIF, CredsNIIF, rows[j][0].ToString(), dNIIF, cNIIF); deb += d; cred += c; debNIIF += dNIIF; credNIIF += cNIIF; dtRep.Rows.Add(dr); } dr = dtRep.NewRow(); if (Math.Abs(deb - cred) > 0.009 || Math.Abs(debNIIF - credNIIF) > 0.009) { dr[2] = " Sumas desiguales"; dr[3] = " Diferencia:"; dr[6] = (deb - cred).ToString("N"); } else { dr[2] = " Sumas iguales"; } dr[4] = (deb).ToString("N"); dr[5] = (cred).ToString("N"); dr[7] = (debNIIF).ToString("N"); dr[8] = (credNIIF).ToString("N"); dtRep.Rows.Add(dr); res = false; if (i == ds.Tables[0].Rows.Count - 1) { res = true; } else if (ds.Tables[0].Rows[i].ItemArray[0].ToString() != ds.Tables[0].Rows[i + 1].ItemArray[0].ToString()) { res = true; } if (res && Cods.Count > 0) { //Resumen dr = dtRep.NewRow(); dr[3] = " RESUMEN:"; dtRep.Rows.Add(dr); for (k = 0; k < Cods.Count; k++) { rowsC = ds.Tables[2].Select("MCUE_CODIPUC = '" + Cods[k].ToString().Trim() + "'"); dr = dtRep.NewRow(); dr[1] = Cods[k]; if (rowsC.Length > 0) { dr[2] = rowsC[0][1]; } else { dr[2] = "Cuenta no definida en PUC."; } dr[4] = ((double)Convert.ToDouble(Debs[k])).ToString("N"); dr[5] = ((double)Convert.ToDouble(Creds[k])).ToString("N"); dr[7] = ((double)Convert.ToDouble(DebsNIIF[k])).ToString("N"); dr[8] = ((double)Convert.ToDouble(CredsNIIF[k])).ToString("N"); dtRep.Rows.Add(dr); } Cods.Clear(); Debs.Clear(); Creds.Clear(); CodsNIIF.Clear(); DebsNIIF.Clear(); CredsNIIF.Clear(); } } dg.DataSource = dtRep; dg.DataBind(); StringBuilder SB = new StringBuilder(); StringWriter SW = new StringWriter(SB); HtmlTextWriter htmlTW = new HtmlTextWriter(SW); tabPreHeader.RenderControl(htmlTW); dg.RenderControl(htmlTW); tabFirmas.RenderControl(htmlTW); string strRep; strRep = SB.ToString(); Session.Clear(); Session["Rep"] = strRep; toolsHolder.Visible = true; }
public void MakeReport(Object Sender, EventArgs E) { DatasForReport balComp = new DatasForReport(reportTitle); ds = balComp.GetDatas(false, GetParams()); //3 tablas: // 1. mcue_codipuc, mcue_nombre, tnat_codigo, timp_codigo FROM mcuenta // 2. mcuenta.mcue_codipuc as CODIGO, mcuenta.mcue_nombre as NOMBRE, parcial=msal_valodebi-msal_valocred o msal_valocred-msal_valodebi WHERE mcuenta.mcue_codipuc=msaldocuenta.mcue_codipuc AND msaldocuenta.pano_ano=@ AND msaldocuenta.pmes_mes<=@ AND mcuenta.timp_codigo in ('N','P','@') AND mcuenta.tcla_codigo='R' // 3. mauxiliarcuenta.mcue_codipuc as COD, mauxiliarcuenta.mnit_nit as NIT, mnit.mnit_nombres+mnit.mnit_apellidos as NOMBRE, DETALLE = mauxiliarcuenta.maux_valodebi-mauxiliarcuenta.maux_valocred o mauxiliarcuenta.maux_valocred-mauxiliarcuenta.maux_valodebi FROM mcuenta, mauxiliarcuenta, mnit WHERE mauxiliarcuenta.mnit_nit=mnit.mnit_nit AND mcuenta.mcue_codipuc=mauxiliarcuenta.mcue_codipuc AND mauxiliarcuenta.pano_ano=@ AND mauxiliarcuenta.pmes_mes<=@ AND mauxiliarcuenta.mnit_nit != '@' //reportInfo.Text=ds.Tables.Count.ToString(); Press frontEnd = new Press(ds, reportTitle); frontEnd.PreHeader(tabPreHeader, report.Width, pr); frontEnd.Firmas(tabFirmas, report.Width); frontEnd.SourceFieldTitles(balComp.PressFields); tbReport = frontEnd.TbReport; ArrayList arC0 = new ArrayList(); ArrayList arC1 = new ArrayList(); ArrayList arC2 = new ArrayList(); ArrayList arV0 = new ArrayList(); ArrayList arV1 = new ArrayList(); ArrayList arV2 = new ArrayList(); ArrayList arC = null; ArrayList arV = null; ArrayList arCT = new ArrayList(); DataRow[] rows; int ano, ai; ano = Convert.ToInt16(values[0]); for (i = 0; i < ds.Tables[1].Rows.Count; i++) { ai = ano - Convert.ToInt16(ds.Tables[1].Rows[i][4]); if (ai == 0) { arC = arC0; arV = arV0; } if (ai == 1) { arC = arC1; arV = arV1; } if (ai == 2) { arC = arC2; arV = arV2; } Inserta(arC, ds.Tables[1].Rows[i][0].ToString(), Convert.ToDouble(ds.Tables[1].Rows[i][2]), arV, arCT); if (ds.Tables[1].Rows[i][3].ToString().ToUpper() == "D") { TDeb += Convert.ToDouble(ds.Tables[1].Rows[i][2]); } if (ds.Tables[1].Rows[i][3].ToString().ToUpper() == "C") { TCred += Convert.ToDouble(ds.Tables[1].Rows[i][2]); } } double v0, v1, v2; if (arCT.Count > 0) { for (i = 0; i < arCT.Count; i++) { dr = tbReport.NewRow(); dr[0] = arCT[i].ToString(); rows = ds.Tables[0].Select("MCUE_CODIPUC = '" + arCT[i].ToString() + "'"); dr[1] = rows[0][1]; if (arC0.Contains(arCT[i])) { v0 = (double)arV0[i]; } else { v0 = 0; } dr[2] = (v0).ToString(); if (arC1.Contains(arCT[i])) { v1 = (double)arV1[i]; } else { v1 = 0; } dr[3] = (v1).ToString(); if (arC2.Contains(arCT[i])) { v2 = (double)arV2[i]; } else { v2 = 0; } dr[4] = (v2).ToString(); if (v0 != 0) { dr[5] = (((v1 - v0) * 100) / v0).ToString(); // % Año 0-1 dr[6] = (((v2 - v0) * 100) / v0).ToString(); // % Año 0-2 } else { dr[5] = "0.00"; dr[6] = "0.00"; } if (!(v0 == 0 && v1 == 0 && v2 == 0)) { tbReport.Rows.Add(dr); } } } frontEnd.PressFieldTitles(report); DataView dv = frontEnd.SortWithNextField(3, 0); DataTable dtTmp = dv.Table; if (values[2] == "A") { report.DataSource = SetAux(dv, 0); } else if (values[2] == "D") { report.DataSource = SetAux(dv, 14); } else if (values[2] == "G") { report.DataSource = SetAux(dv, 10); } else if (values[2] == "M") { report.DataSource = SetAux(dv, 6); } report.Columns[2].HeaderText = values[0]; report.Columns[3].HeaderText = (Convert.ToInt16(values[0]) - 1).ToString(); report.Columns[4].HeaderText = (Convert.ToInt16(values[0]) - 2).ToString(); report.Columns[5].HeaderText = "% " + values[0] + "-" + (Convert.ToInt16(values[0]) - 1).ToString(); report.Columns[6].HeaderText = "% " + values[0] + "-" + (Convert.ToInt16(values[0]) - 2).ToString(); report.DataBind(); StringBuilder SB = new StringBuilder(); StringWriter SW = new StringWriter(SB); HtmlTextWriter htmlTW = new HtmlTextWriter(SW); tabPreHeader.RenderControl(htmlTW); report.RenderControl(htmlTW); tabFirmas.RenderControl(htmlTW); string strRep; strRep = SB.ToString(); Session.Clear(); Session["Rep"] = strRep; toolsHolder.Visible = true; }
protected void Consulta_Click(object Sender, EventArgs e) { int ord = 0; if (RadioOpcion.SelectedValue == "CUE") { ord = 1; } if (RadioOpcion.SelectedValue == "NIT") { ord = 2; } if (RadioOpcion.SelectedValue == "NOM") { ord = 3; } string sql, sql1, sql2, sql3; sql = @"select m1.mcue_codipuc as mcue_codipuc,m1.mnit_nit,m2.mcue_nombre,case when m2.tnat_codigo='D' then m1.maux_valodebi-m1.maux_valocred when m2.tnat_codigo='C' then m1.maux_valocred-m1.maux_valodebi end as saldo, m3.mnit_nombres || ' ' || coalesce(MNIT_NOMBRE2,'') as mnit_nombres,m3.mnit_apellidos || ' ' || coalesce(MNIT_APELLIDO2,'') as mnit_apellidos from mauxiliarcuenta m1,mcuenta m2, mnit m3 where m1.mcue_codipuc=m2.mcue_codipuc AND m3.mnit_nit=m1.mnit_nit AND m1.pmes_mes = " + month.SelectedValue + " AND m1.pano_ano=" + year.SelectedValue; sql1 = @"select m1.mcue_codipuc as mcue_codipuc,m1.mnit_nit as mnit_nit,case when m2.tnat_codigo='D' then m1.maux_valodebi-m1.maux_valocred when m2.tnat_codigo='C' then m1.maux_valocred-m1.maux_valodebi end as saldo from mauxiliarcuenta m1,mcuenta m2 where m1.mcue_codipuc=m2.mcue_codipuc AND m1.pmes_mes = 0 AND m1.pano_ano=" + year.SelectedValue; sql2 = @"select m1.mcue_codipuc as mcue_codipuc,m1.mnit_nit as mnit_nit,case when m2.tnat_codigo='D' then sum(m1.maux_valodebi-m1.maux_valocred) when m2.tnat_codigo='C' then sum(m1.maux_valocred-m1.maux_valodebi) end as saldo from mauxiliarcuenta m1,mcuenta m2 where m1.mcue_codipuc=m2.mcue_codipuc AND m1.pmes_mes > 0 AND m1.pmes_mes < " + month.SelectedValue + " AND m1.pano_ano = " + year.SelectedValue + " group by (m1.mcue_codipuc,m1.mnit_nit,m2.tnat_codigo)"; sql3 = "Select MNIT_NIT, MNIT_NOMBRES || ' ' || coalesce(MNIT_NOMBRE2,''), MNIT_APELLIDOS || ' ' || coalesce(MNIT_APELLIDO2,'') from MNIT"; if (ord == 1) { sql += " ORDER BY mcue_codipuc,mnit_nit"; } if (ord == 2) { sql += " ORDER BY mnit_nit,mcue_codipuc"; } if (ord == 3) { sql += " ORDER BY mnit_apellidos,mnit_nombres,mnit_nit,mcue_codipuc"; } CultureInfo bz = new CultureInfo("en-us"); DataSet ds = new DataSet(); DBFunctions.Request(ds, IncludeSchema.NO, sql); DBFunctions.Request(ds, IncludeSchema.NO, sql1); DBFunctions.Request(ds, IncludeSchema.NO, sql2); DBFunctions.Request(ds, IncludeSchema.NO, sql3); string[] titleFields = { "Cod", "Nombre", "Saldo Año Ant", "Mvto Año", "Mvto Mes", "Saldo" }; string[] dataFields = { "Cod", "Nombre", "Saldo Año Ant", "Mvto Año", "Mvto Mes", "Saldo" }; int i; double d1, d2, d3, d4; for (i = 0; i < titleFields.Length; i++) { BoundColumn bc = new BoundColumn(); bc.HeaderText = titleFields[i]; bc.DataField = dataFields[i]; bc.DataFormatString = "{0:N}"; dg.Columns.Add(bc); } DataTable dtRep = new DataTable(); DataRow dr; DataRow[] rowsT; double sm; for (i = 0; i < titleFields.Length; i++) { dtRep.Columns.Add(new DataColumn(dataFields[i], typeof(string))); } string uCod = ""; if (ds.Tables[0].Rows.Count > 0) { for (i = 0; i < ds.Tables[0].Rows.Count; i++) { if (ord == 1)//Cuenta { d1 = d2 = d3 = d4 = 0; dr = dtRep.NewRow(); dr[0] = "<br>"; dtRep.Rows.Add(dr); dr = dtRep.NewRow(); dr[0] = ds.Tables[0].Rows[i][0].ToString(); dr[1] = ds.Tables[0].Rows[i][2].ToString(); dtRep.Rows.Add(dr); uCod = ds.Tables[0].Rows[i][0].ToString(); while (i < ds.Tables[0].Rows.Count && ds.Tables[0].Rows[i][0].ToString() == uCod) { dr = dtRep.NewRow(); dr[0] = ds.Tables[0].Rows[i][1].ToString(); rowsT = ds.Tables[3].Select("mnit_nit='" + ds.Tables[0].Rows[i][1].ToString() + "'"); if (rowsT.Length > 0) { dr[1] = rowsT[0][1] + " " + rowsT[0][2]; } else { dr[1] = "No Existe"; } rowsT = ds.Tables[1].Select("mcue_codipuc='" + uCod + "' AND mnit_nit='" + ds.Tables[0].Rows[i][1].ToString() + "'"); if (rowsT.Length > 0) { dr[2] = ((double)Convert.ToDouble(rowsT[0][2])).ToString("N"); } else { dr[2] = "0.00"; } rowsT = ds.Tables[2].Select("mcue_codipuc='" + uCod + "' AND mnit_nit='" + ds.Tables[0].Rows[i][1].ToString() + "'"); if (rowsT.Length > 0) { dr[3] = ((double)Convert.ToDouble(rowsT[0][2])).ToString("N"); } else { dr[3] = "0.00"; } dr[4] = ((double)Convert.ToDouble(ds.Tables[0].Rows[i][3])).ToString("N"); sm = Convert.ToDouble(dr[4]) + Convert.ToDouble(dr[3]) + Convert.ToDouble(dr[2]); dr[5] = sm.ToString("N"); d1 += Convert.ToDouble(dr[2]); d2 += Convert.ToDouble(dr[3]); d3 += Convert.ToDouble(dr[4]); d4 += Convert.ToDouble(dr[5]); i++; dtRep.Rows.Add(dr); } i--; dr = dtRep.NewRow(); dr[1] = "Total:"; dr[2] = d1.ToString("N"); dr[3] = d2.ToString("N"); dr[4] = d3.ToString("N"); dr[5] = d4.ToString("N"); dtRep.Rows.Add(dr); } else//NIT-Nombre { d1 = d2 = d3 = d4 = 0; dr = dtRep.NewRow(); dr[0] = "<br>"; dtRep.Rows.Add(dr); dr = dtRep.NewRow(); rowsT = ds.Tables[3].Select("mnit_nit='" + ds.Tables[0].Rows[i][1].ToString() + "'"); if (rowsT.Length > 0) { dr[1] = rowsT[0][1] + " " + rowsT[0][2]; } else { dr[1] = "No Existe"; } dr[0] = ds.Tables[0].Rows[i][1].ToString(); dtRep.Rows.Add(dr); uCod = ds.Tables[0].Rows[i][1].ToString(); while (i < ds.Tables[0].Rows.Count && ds.Tables[0].Rows[i][1].ToString() == uCod) { dr = dtRep.NewRow(); dr[0] = ds.Tables[0].Rows[i][0].ToString(); dr[1] = ds.Tables[0].Rows[i][2].ToString(); rowsT = ds.Tables[1].Select("mnit_nit='" + uCod + "' AND mcue_codipuc='" + ds.Tables[0].Rows[i][0].ToString() + "'"); if (rowsT.Length > 0) { dr[2] = ((double)Convert.ToDouble(rowsT[0][2])).ToString("N"); } else { dr[2] = "0.00"; } rowsT = ds.Tables[2].Select("mnit_nit='" + uCod + "' AND mcue_codipuc='" + ds.Tables[0].Rows[i][0].ToString() + "'"); if (rowsT.Length > 0) { dr[3] = ((double)Convert.ToDouble(rowsT[0][2])).ToString("N"); } else { dr[3] = "0.00"; } dr[4] = ((double)Convert.ToDouble(ds.Tables[0].Rows[i][3])).ToString("N"); sm = Convert.ToDouble(dr[4]) + Convert.ToDouble(dr[3]) + Convert.ToDouble(dr[2]); dr[5] = sm.ToString("N"); d1 += Convert.ToDouble(dr[2]); d2 += Convert.ToDouble(dr[3]); d3 += Convert.ToDouble(dr[4]); d4 += Convert.ToDouble(dr[5]); i++; dtRep.Rows.Add(dr); } i--; dr = dtRep.NewRow(); dr[1] = "Total:"; dr[2] = d1.ToString("N"); dr[3] = d2.ToString("N"); dr[4] = d3.ToString("N"); dr[5] = d4.ToString("N"); dtRep.Rows.Add(dr); } } lblAux.Text = ""; dg.DataSource = dtRep; dg.DataBind(); string [] pr = new string[2]; pr[1] = month.SelectedItem.ToString(); pr[0] = year.SelectedValue.ToString(); Press frontEnd = new Press(ds, "Terceros por Cuenta"); frontEnd.PreHeader(tabPreHeader, dg.Width, pr); frontEnd.Firmas(tabFirmas, dg.Width); StringBuilder SB = new StringBuilder(); StringWriter SW = new StringWriter(SB); HtmlTextWriter htmlTW = new HtmlTextWriter(SW); tabPreHeader.RenderControl(htmlTW); dg.RenderControl(htmlTW); tabFirmas.RenderControl(htmlTW); string strRep; strRep = SB.ToString(); Session.Clear(); Session["Rep"] = strRep; toolsHolder.Visible = true; } else { lblAux.Text = "No se encontraron datos."; } }
protected void generar(Object Sender, EventArgs e) { string [] pr = new string[2]; pr[0] = pr[1] = ""; Press frontEnd = new Press(new DataSet(), reportTitle); frontEnd.PreHeader(tabPreHeader, Grid.Width, pr); frontEnd.Firmas(tabFirmas, Grid.Width); lb.Text = ""; /////////////////////////////////////////////////////// this.PrepararTabla(); lineas = new DataSet(); string fecha = Convert.ToDateTime(FechaInicio.Text).ToString("yyyy-MM-dd"); string fecha1 = Convert.ToDateTime(FechaFinal.Text).ToString("yyyy-MM-dd"); try { DBFunctions.Request(lineas, IncludeSchema.NO, "select distinct mbus.mbus_numero as NUMEROBUS,drut.mcat_placa as PLACA,tciu.tciu_nombre as CIUDADORIGEN,tciu1.tciu_nombre as CIUDADDESTINO,mrut.mrut_valor as VALOR,drut.drut_horasal as HORASALIDA,drut.drut_fecha as FECHA,drut.drut_codigo as CODIGORUTA,drut.drut_planilla as NUMEROPLANILLA,drut.drut_codrelevante as RELEVANTE from dbxschema.druta drut,dbxschema.druta drut1,dbxschema.dtiquete dtiq,dbxschema.mruta mrut, dbxschema.tciudad tciu,dbxschema.tciudad tciu1,dbxschema.tciudad tciu2,dbxschema.mbusafiliado mbus where drut.drut_fecha between '" + fecha + "' and '" + fecha1 + "' and drut.drut_codigo=drut.drut_codigo and drut.mrut_codigo=mrut.mrut_codigo and mrut.tciu_cod=tciu.tciu_codigo and mrut.tciu_coddes=tciu1.tciu_codigo and mbus.mcat_placa=drut.mcat_placa and tciu.tciu_nombre=(select tciu.TCIU_nombre from dbxschema.MOFICINA mofi,dbxschema.tciudad tciu where mofi_codigo='" + ddlagencia.SelectedValue + "'and tciu.tciu_codigo=mofi.tciu_codigo)order by drut.drut_fecha,tciu1.tciu_nombre"); } catch (Exception t) { Response.Write("<script language:javascript>alert('No se Encuentra Ningun Reporte De esta Bus'); </script>" + t.Message); } for (int i = 0; i < lineas.Tables[0].Rows.Count; i++) { //Vamos a crear una fila para nuestro DataTable resultado, que almacene los resultados de las operaciones anteriores string lineas1 = DBFunctions.SingleData("Select count (*) from DBXSCHEMA.DTIQUETE where drut_codigo=" + lineas.Tables[0].Rows[i][7].ToString() + ""); string lineas2 = DBFunctions.SingleData("Select count(*)from dbxschema.dtiquete where drut_codigo=" + lineas.Tables[0].Rows[i].ItemArray[7].ToString() + " and test_codigo='RS'"); int puestosre = 0; int puestos = 0; if (lineas2.Length == 0) { puestosre = 0; puestos = Convert.ToInt32(lineas1); } else { puestos = Convert.ToInt32(lineas1); puestosre = Convert.ToInt32(lineas2); } string capacidad = DBFunctions.SingleData("SELECT pcat.pcat_capacidad FROM dbxschema.pcatalogovehiculo pcat,dbxschema.druta druta,dbxschema.mruta mruta,dbxschema.mbusafiliado mbus,dbxschema.mcatalogovehiculo mcat WHERE druta.drut_codigo=" + lineas.Tables[0].Rows[i][7].ToString() + " and druta.mrut_codigo=mruta.mrut_codigo and druta.mcat_placa=mbus.mcat_placa and mbus.mcat_placa=mcat.mcat_placa and pcat.pcat_codigo=mcat.pcat_codigo"); string disponibilidad = ((System.Convert.ToInt32(capacidad)) - (System.Convert.ToInt32(DBFunctions.SingleData("SELECT COUNT(*) FROM dpuestoruta WHERE drut_codigo=" + lineas.Tables[0].Rows[i][7].ToString() + " AND (test_codigo<>'LI')").Trim()))).ToString(); DataRow fila; fila = resultado.NewRow(); fila["NUMERO BUS"] = lineas.Tables[0].Rows[i].ItemArray[0].ToString(); fila["PLACA"] = lineas.Tables[0].Rows[i].ItemArray[1].ToString(); fila["ORIGEN"] = lineas.Tables[0].Rows[i].ItemArray[2].ToString(); fila["DESTINO"] = lineas.Tables[0].Rows[i].ItemArray[3].ToString(); fila["VALOR"] = lineas.Tables[0].Rows[i].ItemArray[4].ToString(); fila["HORA SALIDA"] = lineas.Tables[0].Rows[i].ItemArray[5].ToString(); fila["FECHA"] = lineas.Tables[0].Rows[i].ItemArray[6].ToString(); fila["CODIGO RUTA"] = lineas.Tables[0].Rows[i].ItemArray[7].ToString(); fila["NUMERO PLANILLA"] = lineas.Tables[0].Rows[i].ItemArray[8].ToString(); fila["RELEVANTE"] = lineas.Tables[0].Rows[i].ItemArray[9].ToString(); fila["NUMERO DE PASAJEROS"] = puestos - puestosre; fila["DISPONIBLES"] = disponibilidad; fila["TOTAL"] = puestos * Convert.ToDouble(lineas.Tables[0].Rows[i].ItemArray[4]); resultado.Rows.Add(fila); } //fin sentencia FOR Grid.DataSource = resultado; Grid.DataBind(); StringBuilder SB = new StringBuilder(); StringWriter SW = new StringWriter(SB); HtmlTextWriter htmlTW = new HtmlTextWriter(SW); tabPreHeader.RenderControl(htmlTW); Grid.RenderControl(htmlTW); tabFirmas.RenderControl(htmlTW); string strRep; strRep = SB.ToString(); Session.Clear(); Session["Rep"] = strRep; toolsHolder.Visible = true; }
protected void Consulta_Click(object Sender, EventArgs e) { DataSet ds = new DataSet(); string [] pr = new string[2]; pr[0] = pr[1] = ""; Press frontEnd = new Press(new DataSet(), reportTitle); frontEnd.PreHeader(tabPreHeader, dg.Width, pr); frontEnd.Firmas(tabFirmas, dg.Width); string sql = "select distinct d1.pdoc_codigo,d1.mcom_numedocu, d1.mcue_codipuc, d1.dcue_codirefe, d1.dcue_numerefe, d1.mnit_nit, d1.palm_almacen, d1.pcen_codigo, d1.dcue_detalle, d1.dcue_valodebi, d1.dcue_valocred, d1.dcue_valobase, m3.mcue_nombre,m3.tnat_codigo from mcomprobante m1, dcuenta d1, mauxiliarcuenta m2, mcuenta m3 where m3.mcue_codipuc=d1.mcue_codipuc AND m1.PDOC_CODIGO = d1.PDOC_CODIGO and m1.mcom_numedocu=d1.mcom_numedocu and m1.pmes_mes=" + month.SelectedValue + " AND m1.pano_ano=" + year.SelectedValue + " ORDER BY d1.mcue_codipuc"; // 0 1 2 3 4 5 6 7 8 9 10 11 12 13 string sql1 = "Select MNIT_NIT, MNIT_NOMBRES || ' ' || coalesce(MNIT_NOMBRE2,''), MNIT_APELLIDOS || ' ' || coalesce(MNIT_APELLIDO2,'') from MNIT"; CultureInfo bz = new CultureInfo("en-us"); bool totTer = false; if (RadioOpcion.SelectedValue == "DOC") { sql += ", d1.pdoc_codigo"; } if (RadioOpcion.SelectedValue == "NIT") { sql += ", d1.mnit_nit"; totTer = true; } if (RadioOpcion.SelectedValue == "NOM") { sql += ", d1.mnit_nit"; totTer = true; } if (RadioOpcion.SelectedValue == "SCC") { sql += ", d1.palm_almacen, d1.pcen_codigo"; } if (RadioOpcion.SelectedValue == "CRE") { sql += ", d1.dcue_valocred, d1.dcue_valodebi"; } if (RadioOpcion.SelectedValue == "DEB") { sql += ", d1.dcue_valodebi, d1.dcue_valocred"; } string sql2 = "select m1.mcue_codipuc as mcue_codipuc, CASE WHEN m2.tnat_codigo='D' THEN sum(m1.maux_valodebi-m1.maux_valocred) WHEN m2.tnat_codigo='C' THEN sum(m1.maux_valocred-m1.maux_valodebi) END as DETALLE from mauxiliarcuenta as m1, mcuenta as m2 where m1.pano_ano=" + year.SelectedValue + " and m1.pmes_mes<" + month.SelectedValue + " and m1.mcue_codipuc=m2.mcue_codipuc group by (m1.mcue_codipuc,m2.tnat_codigo)"; //Saldo anterior meses pasados //lblAux.Text=sql1; DBFunctions.Request(ds, IncludeSchema.NO, sql); DBFunctions.Request(ds, IncludeSchema.NO, sql1); DBFunctions.Request(ds, IncludeSchema.NO, sql2); string[] titleFields = { "Doc-Comp", "Cuenta", "Nit", "Cod-Num Ref.", "Sede-CC", "Detalle", "Debito", "Credito", "Base" }; string[] dataFields = { "Doc-Comp", "Cuenta", "Nit", "Cod-Num Ref.", "Sede-CC", "Detalle", "Debito", "Credito", "Base" }; int i; for (i = 0; i < titleFields.Length; i++) { BoundColumn bc = new BoundColumn(); bc.HeaderText = titleFields[i]; bc.DataField = dataFields[i]; bc.DataFormatString = "{0:N}"; dg.Columns.Add(bc); } DataTable dtRep = new DataTable(); DataRow dr; DataRow[] rows; string uC = "", uT = ""; string nomter = ""; double trCCT, trCDT, trCC, trCD, trC, trD; DataView dv = ds.Tables[1].DefaultView; trCCT = trCDT = trCC = trCD = trC = trD = 0; for (i = 0; i < titleFields.Length; i++) { dtRep.Columns.Add(new DataColumn(dataFields[i], typeof(string))); } if (ds.Tables[0].Rows.Count > 0) { for (i = 0; i < ds.Tables[0].Rows.Count; i++) { if (uC != ds.Tables[0].Rows[i].ItemArray[2].ToString()) //Cuenta diferente { dr = dtRep.NewRow(); dr[0] = "<br>"; dtRep.Rows.Add(dr); //Titulo dr = dtRep.NewRow(); dr[0] = ds.Tables[0].Rows[i].ItemArray[2].ToString(); dr[1] = ds.Tables[0].Rows[i].ItemArray[12].ToString(); rows = ds.Tables[2].Select("MCUE_CODIPUC='" + ds.Tables[0].Rows[i].ItemArray[2].ToString() + "'"); dr[5] = "Saldo Ant:"; if (ds.Tables[0].Rows[i].ItemArray[13].ToString().ToUpper() == "D") //Saldo anterior { if (rows.Length > 0) { dr[6] = ((double)Convert.ToDouble(rows[0][1])).ToString("N"); } else { dr[6] = "0.00"; } } else if (rows.Length > 0) { dr[7] = ((double)Convert.ToDouble(rows[0][1])).ToString("N"); } else { dr[7] = "0.00"; } uC = ds.Tables[0].Rows[i].ItemArray[2].ToString(); trCC = trCD = 0; dtRep.Rows.Add(dr); uT = ""; } rows = ds.Tables[1].Select("MNIT_NIT='" + ds.Tables[0].Rows[i].ItemArray[5].ToString() + "'"); //Nombre del tercero if (rows.Length > 0) { nomter = rows[0][1] + " " + rows[0][2]; } else { nomter = "No existe."; uT = "no"; trC = trD = 0; } if (rows.Length > 0 && totTer) //Titulo terceros { if (uT == "" || uT != nomter) { dr = dtRep.NewRow(); rows = ds.Tables[2].Select("MCUE_CODIPUC='" + ds.Tables[0].Rows[i].ItemArray[2].ToString() + "'"); if (ds.Tables[0].Rows[i].ItemArray[13].ToString().ToUpper() == "D") { if (rows.Length > 0) { dr[6] = ((double)Convert.ToDouble(rows[0][1])).ToString("N"); } else { dr[6] = "0.00"; } } else { if (rows.Length > 0) { dr[7] = ((double)Convert.ToDouble(rows[0][1])).ToString("N"); } else { dr[7] = "0.00"; } } dr[0] = ds.Tables[0].Rows[i].ItemArray[5].ToString(); dr[1] = nomter; uT = nomter; dr[5] = "Saldo A Ter:"; dtRep.Rows.Add(dr); } } dr = dtRep.NewRow(); dr[1] = nomter; dr[0] = ds.Tables[0].Rows[i].ItemArray[0].ToString() + "-" + ds.Tables[0].Rows[i].ItemArray[1].ToString(); dr[3] = ds.Tables[0].Rows[i].ItemArray[3].ToString() + "-" + ds.Tables[0].Rows[i].ItemArray[4].ToString(); dr[2] = ds.Tables[0].Rows[i].ItemArray[5].ToString(); dr[4] = ds.Tables[0].Rows[i].ItemArray[6].ToString() + "-" + ds.Tables[0].Rows[i].ItemArray[7].ToString(); dr[5] = ds.Tables[0].Rows[i].ItemArray[8].ToString(); dr[6] = ((double)Convert.ToDouble(ds.Tables[0].Rows[i].ItemArray[9])).ToString("N"); dr[7] = ((double)Convert.ToDouble(ds.Tables[0].Rows[i].ItemArray[10])).ToString("N"); dr[8] = ((double)Convert.ToDouble(ds.Tables[0].Rows[i].ItemArray[11])).ToString("N"); trCD += Convert.ToDouble(ds.Tables[0].Rows[i].ItemArray[9]); trCC += Convert.ToDouble(ds.Tables[0].Rows[i].ItemArray[10]); dtRep.Rows.Add(dr); if (totTer && uT != "no")//Total terceros { if (i == ds.Tables[0].Rows.Count - 1 || ds.Tables[0].Rows[i].ItemArray[5].ToString() != ds.Tables[0].Rows[i + 1].ItemArray[5].ToString() || ds.Tables[0].Rows[i].ItemArray[2].ToString() != ds.Tables[0].Rows[i + 1].ItemArray[2].ToString()) { dr = dtRep.NewRow(); dr[5] = "Total Ter:"; dtRep.Rows.Add(dr); uT = nomter; trC += Convert.ToDouble(ds.Tables[0].Rows[i].ItemArray[10]); trD += Convert.ToDouble(ds.Tables[0].Rows[i].ItemArray[9]); dr[6] = (trD).ToString("N"); dr[7] = (trC).ToString("N"); trC = trD = 0; } else { trC += Convert.ToDouble(ds.Tables[0].Rows[i].ItemArray[10]); trD += Convert.ToDouble(ds.Tables[0].Rows[i].ItemArray[9]); } } if (i == ds.Tables[0].Rows.Count - 1 || ds.Tables[0].Rows[i].ItemArray[2].ToString() != ds.Tables[0].Rows[i + 1].ItemArray[2].ToString()) { dr = dtRep.NewRow(); dr[0] = "Total:"; dr[1] = ds.Tables[0].Rows[i].ItemArray[12].ToString(); dr[5] = "Movimiento:"; dr[6] = (trCD).ToString("N"); dr[7] = (trCC).ToString("N"); dtRep.Rows.Add(dr); dr = dtRep.NewRow(); dr[5] = "Saldo:"; if (ds.Tables[0].Rows[i].ItemArray[13].ToString().ToUpper() == "D") { dr[6] = (trCD - trCC).ToString("N"); } else { dr[7] = (trCC - trCD).ToString("N"); } trCCT += trCC; trCDT += trCD; trCC = trCD = 0; dtRep.Rows.Add(dr); } } dr = dtRep.NewRow(); dr[0] = "<br>"; dtRep.Rows.Add(dr); dr = dtRep.NewRow(); dr[0] = "TOTAL:"; dr[6] = (trCDT).ToString("N"); dr[7] = (trCCT).ToString("N"); if (Math.Abs(trCDT - trCCT) < 0.01) { dr[1] = "Sumas Iguales"; } else { dr[1] = "Sumas Desiguales"; dr[2] = "Diferencia:"; dr[3] = Math.Abs(trCC - trCD).ToString("N"); } dtRep.Rows.Add(dr); lblAux.Text = ""; dg.DataSource = dtRep; dg.DataBind(); StringBuilder SB = new StringBuilder(); StringWriter SW = new StringWriter(SB); HtmlTextWriter htmlTW = new HtmlTextWriter(SW); tabPreHeader.RenderControl(htmlTW); dg.RenderControl(htmlTW); tabFirmas.RenderControl(htmlTW); string strRep; strRep = SB.ToString(); Session.Clear(); Session["Rep"] = strRep; toolsHolder.Visible = true; } else { lblAux.Text = "No se encontraron datos."; } }
protected void generar(Object Sender, EventArgs e) { string [] pr = new string[2]; pr[0] = pr[1] = ""; Press frontEnd = new Press(new DataSet(), reportTitle); frontEnd.PreHeader(tabPreHeader, Grid.Width, pr); frontEnd.Firmas(tabFirmas, Grid.Width); lb.Text = ""; Año = Convert.ToInt32(año.SelectedValue.ToString()); Mes = Convert.ToInt32(DBFunctions.SingleData("SELECT pmes_mes FROM DBXSCHEMA.pmes WHERE pmes_nombre='" + mes.SelectedValue.ToString() + "' ")); /////////////////////////////////////////////////////// this.PrepararTabla(); lineas = new DataSet(); DBFunctions.Request(lineas, IncludeSchema.NO, "select COD_AUTORIZACION,MAU_FECHA,MAU_CANTIDAD,MAU_VALOTOT,MAU_CODIGO FROM DBXSCHEMA.MAUTORIZACION WHERE MCAT_PLACA='" + Placa.SelectedValue.ToString() + "' AND year(MAU_FECHA)=" + Año + " and month(MAU_FECHA)=" + Mes + " "); for (int i = 0; i < lineas.Tables[0].Rows.Count; i++) { string descripcion = null; int codigoservicio = 0; codigoservicio = Convert.ToInt32(lineas.Tables[0].Rows[i].ItemArray[0].ToString()); descripcion = DBFunctions.SingleData("select TAUT_DESCRIPCION FROM DBXSCHEMA.TAUTORIZACION WHERE COD_AUTORIZACION=" + codigoservicio + " "); int valorservicio = 0; valorservicio = Convert.ToInt32(DBFunctions.SingleData("select TAUT_VALO FROM DBXSCHEMA.TAUTORIZACION WHERE COD_AUTORIZACION=" + codigoservicio + " ")); //Vamos a crear una fila para nuestro DataTable resultado, que almacene los resultados de las operaciones anteriores DataRow fila; fila = resultado.NewRow(); double valorserv = 0; double valor = 0; string ValorFormato = null; string ValorAutoFormato = null; valor = Convert.ToDouble(lineas.Tables[0].Rows[i].ItemArray[3].ToString()); valorserv = Convert.ToDouble(valorservicio.ToString()); ValorFormato = String.Format("{0:C}", valor); ValorAutoFormato = String.Format("{0:C}", valorserv); fila["FECHA"] = lineas.Tables[0].Rows[i].ItemArray[1].ToString(); fila["CODIGO"] = lineas.Tables[0].Rows[i].ItemArray[0].ToString(); fila["DESCRIPCION"] = descripcion.ToString(); fila["VALORSERV"] = ValorAutoFormato.ToString(); fila["CANTIDAD"] = lineas.Tables[0].Rows[i].ItemArray[2].ToString(); fila["VALORTOTAL"] = ValorFormato.ToString(); fila["NUMAUTO"] = lineas.Tables[0].Rows[i].ItemArray[4].ToString(); resultado.Rows.Add(fila); } //fin sentencia FOR Grid.DataSource = resultado; Grid.DataBind(); StringBuilder SB = new StringBuilder(); StringWriter SW = new StringWriter(SB); HtmlTextWriter htmlTW = new HtmlTextWriter(SW); tabPreHeader.RenderControl(htmlTW); Grid.RenderControl(htmlTW); tabFirmas.RenderControl(htmlTW); string strRep; strRep = SB.ToString(); Session.Clear(); Session["Rep"] = strRep; toolsHolder.Visible = true; }
protected void Consulta_Click(object Sender, EventArgs e) { DataSet ds = new DataSet(); string [] pr = new string[2]; pr[0] = pr[1] = ""; Press frontEnd = new Press(new DataSet(), reportTitle); frontEnd.PreHeader(tabPreHeader, dg.Width, pr); frontEnd.Firmas(tabFirmas, dg.Width); string sql = @"select m.PDOC_CODIGO, m.MCOM_NUMEDOCU, cast(MCOM_FECHA as char(10)), MCOM_RAZON, cast(MCOM_FECHAPROC as char(10)), MCOM_USUARIO, coalesce(sum(dcue_VALOdebi),123456789) as total_debito, coalesce(sum(dcue_VALOcred),987654321) as total_credito, coalesce(sum(dcue_VALOdebi),123456789) - coalesce(sum(dcue_VALOcred),987654321) as DIFERENCIA, coalesce(sum(dcue_NIIFdebi),123456789) as total_debito_NIIF, coalesce(sum(dcue_NIIFcred),987654321) as total_credito_NIIF, coalesce(sum(dcue_NIIFdebi),123456789) - coalesce(sum(dcue_NIIFcred),987654321) as DIFERENCIA_NIIF from MCOMPROBANTE m left join dcuenta d on m.pdoc_CODIGO = D.pdoc_CODIGO AND M.MCOM_NUMEDOCU = D.MCOM_NUMEDOCU where PMES_MES = " + month.SelectedValue + " AND PANO_ANO =" + year.SelectedValue + " "; // 0 1 2 3 4 5 6 CultureInfo bz = new CultureInfo("en-us"); if (RadioOpcion.SelectedValue == "UTC") { sql += " AND M.PDOC_CODIGO = '" + typeDoc.SelectedValue + "' "; } sql += " GROUP BY m.PDOC_CODIGO, m.MCOM_NUMEDOCU, MCOM_FECHA, MCOM_RAZON, MCOM_FECHAPROC, MCOM_USUARIO " + " ORDER BY M.PDOC_CODIGO, M.MCOM_NUMEDOCU"; ViewState["CONSULTAExcel"] = sql; // hola.Text+=sql+"<br>"; DBFunctions.Request(ds, IncludeSchema.NO, sql); string[] titleFields = { "Cod Doc.", "Nº Comprobante", "Fecha", "Razón", "Fecha Proc.", "Usuario", "Valor Débito", "Valor Crédito", "Vr Diferencia", "Valor Débito NIIF", "Valor Crédito NIIF", "Vr Diferencia NIIF" }; string[] dataFields = { "Cod Doc.", "Nº Comprobante", "Fecha", "Razón", "Fecha Proc.", "Usuario", "Valor Débito", "Valor Crédito", "Vr Diferencia", "Valor Débito NIIF", "Valor Crédito NIIF", "Vr Diferencia NIIF" }; int i; for (i = 0; i < titleFields.Length; i++) { BoundColumn bc = new BoundColumn(); bc.HeaderText = titleFields[i]; bc.DataField = dataFields[i]; bc.DataFormatString = "{0:N}"; dg.Columns.Add(bc); } DataTable dtRep = new DataTable(); DataRow dr; for (i = 0; i < titleFields.Length; i++) { dtRep.Columns.Add(new DataColumn(dataFields[i], typeof(string))); } string ca = "0"; int nd = 0, fal = 0; //JFSC 11022008 Poner en comentario por no ser usado: //ct=0, double pra = 0, prt = 0; if (ds.Tables[0].Rows.Count > 0) { ca = ds.Tables[0].Rows[0].ItemArray[0].ToString(); pra = Convert.ToDouble(ds.Tables[0].Rows[0].ItemArray[1]); for (i = 0; i < ds.Tables[0].Rows.Count; i++) { prt = Convert.ToDouble(ds.Tables[0].Rows[i].ItemArray[1]); if (ca != ds.Tables[0].Rows[i].ItemArray[0].ToString()) { ca = ds.Tables[0].Rows[i].ItemArray[0].ToString(); pra = Convert.ToDouble(ds.Tables[0].Rows[i].ItemArray[1]); } if (prt - pra > 1) { fal++; dr = dtRep.NewRow(); if (prt - pra > 2) { dr[0] = (pra + 1).ToString() + " - " + (prt - 1).ToString(); dr[1] = "FALTAN!"; } else { dr[0] = (pra + 1).ToString(); dr[1] = "FALTA!"; } dtRep.Rows.Add(dr); } nd++; pra = prt; dr = dtRep.NewRow(); dr[0] = ds.Tables[0].Rows[i].ItemArray[0].ToString(); dr[1] = ds.Tables[0].Rows[i].ItemArray[1].ToString(); dr[2] = ds.Tables[0].Rows[i].ItemArray[2].ToString(); dr[3] = ds.Tables[0].Rows[i].ItemArray[3].ToString(); dr[4] = ds.Tables[0].Rows[i].ItemArray[4].ToString(); dr[5] = ds.Tables[0].Rows[i].ItemArray[5].ToString(); dr[6] = ((double)Convert.ToDouble(ds.Tables[0].Rows[i].ItemArray[6])).ToString("N"); dr[7] = ((double)Convert.ToDouble(ds.Tables[0].Rows[i].ItemArray[7])).ToString("N"); dr[8] = ((double)Convert.ToDouble(ds.Tables[0].Rows[i].ItemArray[8])).ToString("N"); dr[9] = ((double)Convert.ToDouble(ds.Tables[0].Rows[i].ItemArray[9])).ToString("N"); dr[10] = ((double)Convert.ToDouble(ds.Tables[0].Rows[i].ItemArray[10])).ToString("N"); dr[11] = ((double)Convert.ToDouble(ds.Tables[0].Rows[i].ItemArray[11])).ToString("N"); dtRep.Rows.Add(dr); } dr = dtRep.NewRow(); dr[0] = "TOTALES:"; dr[1] = nd.ToString(); dr[2] = "Reg.Faltantes"; dr[3] = fal.ToString(); dtRep.Rows.Add(dr); } dg.DataSource = dtRep; dg.DataBind(); StringBuilder SB = new StringBuilder(); StringWriter SW = new StringWriter(SB); HtmlTextWriter htmlTW = new HtmlTextWriter(SW); tabPreHeader.RenderControl(htmlTW); dg.RenderControl(htmlTW); tabFirmas.RenderControl(htmlTW); string strRep; strRep = SB.ToString(); Session.Clear(); Session["Rep"] = strRep; toolsHolder.Visible = true; }
protected void generar(Object Sender, EventArgs e) { string [] pr = new string[2]; double SaldoParcial = 0; double SaldoFinal = 0; string SaldoFinal1 = null; pr[0] = pr[1] = ""; Press frontEnd = new Press(new DataSet(), reportTitle); frontEnd.PreHeader(tabPreHeader, Grid.Width, pr); frontEnd.Firmas(tabFirmas, Grid.Width); lb.Text = ""; bool Acumulado = false; bool biMestre = false; //Se revisa si el usuario desea el anexo acumulado o al mes escogido if (opciones.SelectedItem.Text == "Acumulado Año") { Acumulado = true; } else { if (opciones.SelectedItem.Text == "Bimestre") { biMestre = true; } } /////////////////////////////////////////////////////// this.PrepararTabla(); lineas = new DataSet(); DBFunctions.Request(lineas, IncludeSchema.NO, "SELECT PL.pane_codianex, PL.plin_linea, PL.plin_nombline, PL.plin_tipolinea, PL.plin_formula, PL.activa FROM plineanexo PL, panexobalance PX WHERE PL.pane_codianex=PX.pane_codianex AND PX.pane_nombanex='" + anexo.SelectedItem.ToString() + "' order by 1,2,3"); for (int i = 0; i < lineas.Tables[0].Rows.Count; i++) { double saldoLinea = 0; //Variable para ir almacenado el saldo de la linea string numero = lineas.Tables[0].Rows[i].ItemArray[1].ToString(); //Tipo=cuenta if ((lineas.Tables[0].Rows[i].ItemArray[3].ToString().Trim()) == "C") { DataSet caractLineas = new DataSet(); DBFunctions.Request(caractLineas, IncludeSchema.NO, "SELECT plin_iinicial, plin_ifinal, plin_operacion, plin_tipmov FROM pcuentaanexo WHERE pane_codianex='" + lineas.Tables[0].Rows[i].ItemArray[0].ToString() + "'AND plin_linea='" + lineas.Tables[0].Rows[i].ItemArray[1].ToString() + "'"); for (int j = 0; j < caractLineas.Tables[0].Rows.Count; j++) { DataSet cuentAfectadas = new DataSet(); string mes = DBFunctions.SingleData("SELECT pmes_mes FROM pmes WHERE pmes_nombre='" + month.SelectedItem.ToString() + "'"); Int16 mesInicial = 0; Int16 mesFinal = 0; Int16 claseCta = Convert.ToInt16(clase.SelectedValue.ToString()); // 1=Legal, 2=Niif if (!Acumulado && !biMestre) // un mes { DBFunctions.Request(cuentAfectadas, IncludeSchema.NO, "SELECT m.mcue_codipuc, case when '" + claseCta + "' = 1 then msal_valodebi else msal_niifdebi end, case when '" + claseCta + "' = 1 then msal_valocred else msal_niifcred end, tnat_codigo FROM msaldocuenta ms, mcuenta m WHERE m.mcue_codipuc = ms.mcue_codipuc and pano_ano=" + year.SelectedItem.ToString() + " AND pmes_mes=" + mes + " AND M.mcue_codipuc>='" + caractLineas.Tables[0].Rows[j].ItemArray[0].ToString() + "' AND M.mcue_codipuc<='" + caractLineas.Tables[0].Rows[j].ItemArray[1].ToString() + "'"); } else if (Acumulado) // Acumulado del año hasta el mes { DBFunctions.Request(cuentAfectadas, IncludeSchema.NO, @"SELECT m.mcue_codipuc, case when '" + claseCta + "' = 1 then msal_valodebi else msal_niifdebi end, case when '" + claseCta + "' = 1 then msal_valocred else msal_niifcred end, tnat_codigo FROM msaldocuenta ms, mcuenta m WHERE m.mcue_codipuc = ms.mcue_codipuc and pano_ano=" + year.SelectedItem.ToString() + " AND pmes_mes<=" + mes + " AND m.mcue_codipuc>='" + caractLineas.Tables[0].Rows[j].ItemArray[0].ToString() + "' AND m.mcue_codipuc<='" + caractLineas.Tables[0].Rows[j].ItemArray[1].ToString() + "' "); } else { if (mes == "1" || mes == "3" || mes == "5" || mes == "7" || mes == "9" || mes == "11") { mesInicial = Convert.ToInt16(mes); mesFinal = Convert.ToInt16(mesInicial + 1); } else { mesFinal = Convert.ToInt16(mes); mesInicial = Convert.ToInt16(mesFinal - 1); } DBFunctions.Request(cuentAfectadas, IncludeSchema.NO, @"SELECT m.mcue_codipuc, case when '" + claseCta + "' = 1 then msal_valodebi else msal_niifdebi end, case when '" + claseCta + "'= 1 then msal_valocred else msal_niifcred end, tnat_codigo FROM mcuenta m, msaldocuenta ms WHERE m.mcue_codipuc = ms.mcue_codipuc and pano_ano=" + year.SelectedItem.ToString() + " AND pmes_mes>=" + mesInicial + " AND pmes_mes<=" + mesFinal + " AND m.mcue_codipuc>='" + caractLineas.Tables[0].Rows[j].ItemArray[0].ToString() + "' AND m.mcue_codipuc<='" + caractLineas.Tables[0].Rows[j].ItemArray[1].ToString() + "'"); } /////////////////Consulta de saldos////////////////// if (cuentAfectadas.Tables.Count > 0) { for (int k = 0; k < cuentAfectadas.Tables[0].Rows.Count; k++) { if ((caractLineas.Tables[0].Rows[j].ItemArray[2].ToString().Trim()) == "S") //Si es SUMA { if ((caractLineas.Tables[0].Rows[j].ItemArray[3].ToString().Trim()) == "S") //Si es el saldo { string naturaleza = cuentAfectadas.Tables[0].Rows[k].ItemArray[3].ToString(); //DBFunctions.SingleData("SELECT tnat_codigo FROM mcuenta WHERE mcue_codipuc='"+cuentAfectadas.Tables[0].Rows[k].ItemArray[0].ToString()+"'"); if (naturaleza == "D") { saldoLinea += System.Convert.ToDouble(cuentAfectadas.Tables[0].Rows[k].ItemArray[1]) - System.Convert.ToDouble(cuentAfectadas.Tables[0].Rows[k].ItemArray[2]); } else if (naturaleza == "C") { saldoLinea += System.Convert.ToDouble(cuentAfectadas.Tables[0].Rows[k].ItemArray[2]) - System.Convert.ToDouble(cuentAfectadas.Tables[0].Rows[k].ItemArray[1]); } } else if ((caractLineas.Tables[0].Rows[j].ItemArray[3].ToString().Trim()) == "C")//Si es el credito { saldoLinea += System.Convert.ToDouble(cuentAfectadas.Tables[0].Rows[k].ItemArray[2]); } else if ((caractLineas.Tables[0].Rows[j].ItemArray[3].ToString().Trim()) == "D")//Si es el debito { saldoLinea += System.Convert.ToDouble(cuentAfectadas.Tables[0].Rows[k].ItemArray[1]); } } ////EN CASO QUE LA OPERACION SEA UNA RESTA else if ((caractLineas.Tables[0].Rows[j].ItemArray[2].ToString().Trim()) == "R") { if ((caractLineas.Tables[0].Rows[j].ItemArray[3].ToString().Trim()) == "S") //Si es el saldo { string naturaleza = cuentAfectadas.Tables[0].Rows[k].ItemArray[3].ToString(); // DBFunctions.SingleData("SELECT tnat_codigo FROM mcuenta WHERE mcue_codipuc='"+cuentAfectadas.Tables[0].Rows[k].ItemArray[0].ToString()+"'"); if (naturaleza == "D") { saldoLinea -= System.Convert.ToDouble(cuentAfectadas.Tables[0].Rows[k].ItemArray[1]) - System.Convert.ToDouble(cuentAfectadas.Tables[0].Rows[k].ItemArray[2]); } else if (naturaleza == "C") { saldoLinea -= System.Convert.ToDouble(cuentAfectadas.Tables[0].Rows[k].ItemArray[2]) - System.Convert.ToDouble(cuentAfectadas.Tables[0].Rows[k].ItemArray[1]); } } else if ((caractLineas.Tables[0].Rows[j].ItemArray[3].ToString().Trim()) == "C")//Si es el credito { saldoLinea -= System.Convert.ToDouble(cuentAfectadas.Tables[0].Rows[k].ItemArray[2]); } else if ((caractLineas.Tables[0].Rows[j].ItemArray[3].ToString().Trim()) == "D")//Si es el debito { saldoLinea -= System.Convert.ToDouble(cuentAfectadas.Tables[0].Rows[k].ItemArray[1]); } } } } } SaldoParcial = saldoLinea + SaldoParcial; SaldoFinal1 = String.Format("{0:C}", saldoLinea); } //Fin sentencia If para discriminar el tipo de linea del renglon //Tipo=Renglon if ((lineas.Tables[0].Rows[i].ItemArray[3].ToString().Trim()) == "R") //la pocision del itemarray[] es el numero de la columna en la base de datos siendo 0 la primera { SaldoFinal = SaldoParcial; SaldoParcial = 0; saldoLinea = SaldoFinal; SaldoFinal = 0; SaldoFinal1 = String.Format("{0:C}", saldoLinea); } //Tipo=Formula? if ((lineas.Tables[0].Rows[i].ItemArray[3].ToString().Trim()) == "L") { lb.Text += "<BR>formula=" + lineas.Tables[0].Rows[i].ItemArray[3].ToString(); } //Tipo=Sentencia if ((lineas.Tables[0].Rows[i].ItemArray[3].ToString().Trim()) == "S") { SaldoFinal1 = DBFunctions.SingleData(lineas.Tables[0].Rows[i]["plin_formula"].ToString()); } //Tipo=Titulo if ((lineas.Tables[0].Rows[i].ItemArray[3].ToString().Trim()) == "T") { SaldoFinal1 = ""; numero = ""; } //Vamos a crear una fila para nuestro DataTable resultado, que almacene los resultados de las operaciones anteriores DataRow fila; fila = resultado.NewRow(); fila["NOMBRE"] = lineas.Tables[0].Rows[i].ItemArray[2].ToString(); fila["NUMERO"] = numero; fila["TOTAL"] = SaldoFinal1; //Linea Activa? if ((lineas.Tables[0].Rows[i].ItemArray[5].ToString().Trim()) == "S") { resultado.Rows.Add(fila); } } //fin sentencia FOR Grid.DataSource = resultado; Grid.DataBind(); StringBuilder SB = new StringBuilder(); StringWriter SW = new StringWriter(SB); HtmlTextWriter htmlTW = new HtmlTextWriter(SW); tabPreHeader.RenderControl(htmlTW); Grid.RenderControl(htmlTW); tabFirmas.RenderControl(htmlTW); string strRep; strRep = SB.ToString(); Session.Clear(); Session["Rep"] = strRep; toolsHolder.Visible = true; }
protected void generar(Object Sender, EventArgs e) { string [] pr = new string[2]; pr[0] = pr[1] = ""; Press frontEnd = new Press(new DataSet(), reportTitle); frontEnd.PreHeader(tabPreHeader, Grid.Width, pr); frontEnd.Firmas(tabFirmas, Grid.Width); lb.Text = ""; //////////////FECHA//////////// int Año1 = Convert.ToInt32(añoI.SelectedValue.ToString()); int Año2 = Convert.ToInt32(añoF.SelectedValue.ToString()); int Mes1 = Convert.ToInt32(DBFunctions.SingleData("select PMES_MES from DBXSCHEMA.PMES WHERE PMES_NOMBRE='" + mesI.SelectedValue.ToString() + "'")); int Mes2 = Convert.ToInt32(DBFunctions.SingleData("select PMES_MES from DBXSCHEMA.PMES WHERE PMES_NOMBRE='" + mesF.SelectedValue.ToString() + "'")); int dia1 = 1; int dia2 = 1; string dia1S = diaI.Text; string dia2S = diaF.Text; if (dia1S.ToString().Equals(null) || dia1S.ToString().Equals("0")) { dia1 = 1; } else { dia1 = Convert.ToInt32(diaI.Text.ToString()); } if (dia2S.ToString().Equals(null) || dia2S.ToString().Equals("0")) { dia2 = Convert.ToInt32(DateTime.Now.Day); } else { dia2 = Convert.ToInt32(diaF.Text.ToString()); } string fecha = Año1 + "-" + Mes1 + "-" + dia1; string fecha2 = Año2 + "-" + Mes2 + "-" + dia2; /////////////////////////////// /////opciones de estado comparendo if (pago.Checked.Equals(true)) { queryEstado = "AND MCOM_ESTADO =1"; } if (nopago.Checked.Equals(true)) { queryEstado = "AND MCOM_ESTADO =3"; } if (proceso.Checked.Equals(true)) { queryEstado = "AND MCOM_ESTADO =2"; } if (todos.Checked.Equals(true)) { queryEstado = " "; } ////////////////////////////////////////////////// ////seleccion conductor conductoresS = conductor.SelectedValue.ToString(); if (conductoresS.Equals("0")) { queryF = "select MCOM_FECHACOM,MCOM_INFRACCION,MCOM_CONDUCTOR,MCOM_ESTADO,MCOM_NUMCOM FROM DBXSCHEMA.MCOMPARENDOS WHERE MCOM_FECHACOM BETWEEN '" + fecha + "' AND '" + fecha2 + "' " + queryEstado + " "; } else { string nit = DBFunctions.SingleData("select MNIT.MNIT_NIT FROM DBXSCHEMA.MNIT MNIT WHERE MNIT.MNIT_NOMBRES CONCAT ' ' CONCAT coalesce(MNIT.MNIT_NOMBRE2,'') CONCAT ' ' CONCAT MNIT.MNIT_APELLIDOS CONCAT ' 'CONCAT coalesce(MNIT.MNIT_APELLIDO2,'') ='" + conductoresS + "' "); queryF = "select MCOM_FECHACOM,MCOM_INFRACCION,MCOM_CONDUCTOR,MCOM_ESTADO,MCOM_NUMCOM FROM DBXSCHEMA.MCOMPARENDOS WHERE MCOM_FECHACOM BETWEEN '" + fecha + "' AND '" + fecha2 + "' " + queryEstado + " AND MCOM_CONDUCTOR='" + nit + "' "; } /////////////////////////////////////////////////////// this.PrepararTabla(); lineas = new DataSet(); DBFunctions.Request(lineas, IncludeSchema.NO, " " + queryF + " "); for (int i = 0; i < lineas.Tables[0].Rows.Count; i++) { string infraccion = null; int codigoinfraccion = 0; double valorcomparendo = 0; codigoinfraccion = Convert.ToInt32(lineas.Tables[0].Rows[i].ItemArray[1].ToString()); infraccion = DBFunctions.SingleData("Select DESC_COMPARENDO from DBXSCHEMA.TCOMPARENDO WHERE COD_COMPARENDO=" + codigoinfraccion + " "); valorcomparendo = Convert.ToDouble(DBFunctions.SingleData("Select VALO_COMPARENDO from DBXSCHEMA.TCOMPARENDO WHERE COD_COMPARENDO=" + codigoinfraccion + " ")); string estadoIn = null; int estadoInfraccion = Convert.ToInt32(lineas.Tables[0].Rows[i].ItemArray[3].ToString()); estadoIn = DBFunctions.SingleData("Select DESC_ESTACOMPA from DBXSCHEMA.TESTADO_COMPARENDO WHERE COD_ESTACOMPA=" + estadoInfraccion + " "); string nombreco = DBFunctions.SingleData("select MNIT.MNIT_NOMBRES CONCAT ' ' CONCAT coalesce(MNIT.MNIT_NOMBRE2,'') CONCAT ' ' CONCAT MNIT.MNIT_APELLIDOS CONCAT ' 'CONCAT coalesce(MNIT.MNIT_APELLIDO2,'') AS NOMBRE FROM DBXSCHEMA.MNIT MNIT WHERE MNIT.MNIT_NIT='" + lineas.Tables[0].Rows[i].ItemArray[2].ToString() + "' "); //Vamos a crear una fila para nuestro DataTable resultado, que almacene los resultados de las operaciones anteriores DataRow fila; fila = resultado.NewRow(); string ValorFormato = null; ValorFormato = String.Format("{0:C}", valorcomparendo); fila["FECHA"] = lineas.Tables[0].Rows[i].ItemArray[0].ToString(); fila["NUMCOMPARENDO"] = lineas.Tables[0].Rows[i].ItemArray[4].ToString(); fila["INFRACCION"] = infraccion.ToString(); fila["VALOR"] = ValorFormato.ToString(); fila["CONDUCTOR"] = nombreco.ToString(); fila["ESTADO"] = estadoIn.ToString(); resultado.Rows.Add(fila); } //fin sentencia FOR Grid.DataSource = resultado; Grid.DataBind(); StringBuilder SB = new StringBuilder(); StringWriter SW = new StringWriter(SB); HtmlTextWriter htmlTW = new HtmlTextWriter(SW); tabPreHeader.RenderControl(htmlTW); Grid.RenderControl(htmlTW); tabFirmas.RenderControl(htmlTW); string strRep; strRep = SB.ToString(); Session.Clear(); Session["Rep"] = strRep; toolsHolder.Visible = true; }
public void MakeReport(Object Sender, EventArgs E) { DatasForReport balGen = new DatasForReport(reportTitle); ds = balGen.GetDatas(false, GetParams()); //reportInfo.Text += balGen.SQL[1] + "<br>"; //dgTest.DataSource = ds.Tables[1]; Press frontEnd = new Press(ds, reportTitle); frontEnd.PreHeader(tabPreHeader, report.Width, pr); frontEnd.Firmas(tabFirmas, report.Width); frontEnd.SourceFieldTitles(balGen.PressFields); tbReport = frontEnd.TbReport; double deb1 = 0, cre1 = 0, totalDeb = 0, totalCre = 0; string cVal, aVal; for (i = 0; i < ds.Tables[0].Rows.Count; i++) { cVal = ds.Tables[0].Rows[i][2].ToString(); deb1 += Convert.ToDouble(ds.Tables[0].Rows[i][4]); cre1 += Convert.ToDouble(ds.Tables[0].Rows[i][5]); if (i != ds.Tables[0].Rows.Count - 1) { aVal = ds.Tables[0].Rows[i + 1][2].ToString(); } else { aVal = "00000"; } if (cVal != aVal) { dr = tbReport.NewRow(); tbReport.Rows.Add(dr); dr[0] = ds.Tables[0].Rows[i][0].ToString(); dr[1] = ds.Tables[0].Rows[i][1].ToString(); dr[2] = cVal; dr[3] = ds.Tables[0].Rows[i][3].ToString(); dr[4] = deb1; dr[5] = cre1; deb1 = 0; cre1 = 0; } } dr = tbReport.NewRow(); tbReport.Rows.Add(dr); dr = tbReport.NewRow(); tbReport.Rows.Add(dr); dr[3] = "R E S U M E N"; deb1 = 0; cre1 = 0; for (i = 0; i < ds.Tables[1].Rows.Count; i++) { cVal = ds.Tables[1].Rows[i][0].ToString(); deb1 += Convert.ToDouble(ds.Tables[1].Rows[i][2]); cre1 += Convert.ToDouble(ds.Tables[1].Rows[i][3]); if (i != ds.Tables[1].Rows.Count - 1) { aVal = ds.Tables[1].Rows[i + 1][0].ToString(); } else { aVal = "00000"; } if (cVal != aVal) { dr = tbReport.NewRow(); tbReport.Rows.Add(dr); dr[2] = ds.Tables[1].Rows[i][0].ToString(); dr[3] = ds.Tables[1].Rows[i][1].ToString(); dr[4] = deb1; dr[5] = cre1; totalDeb = deb1; totalCre = cre1; } } dr = tbReport.NewRow(); tbReport.Rows.Add(dr); dr = tbReport.NewRow(); tbReport.Rows.Add(dr); dr[3] = "TOTAL MOVIMIENTO"; dr[4] = totalDeb; dr[5] = totalCre; //reportInfo.Text += ds.Tables.Count.ToString() + "<br>"; frontEnd.PressFieldTitles(report); //DataView dv = frontEnd.SortWithNextField(2,0); report.DataSource = ds.Tables[2]; report.DataBind(); StringBuilder SB = new StringBuilder(); StringWriter SW = new StringWriter(SB); HtmlTextWriter htmlTW = new HtmlTextWriter(SW); tabPreHeader.RenderControl(htmlTW); report.RenderControl(htmlTW); tabFirmas.RenderControl(htmlTW); string strRep; strRep = SB.ToString(); Session.Clear(); Session["Rep"] = strRep; toolsHolder.Visible = true; }
public void MakeReport(Object Sender, EventArgs E) { DatasForReport balGen = new DatasForReport(reportTitle); ds = balGen.GetDatas(false, GetParams()); //3 tablas: // 1. mcue_codipuc, mcue_nombre, tnat_codigo, timp_codigo FROM mcuenta // 2. mcuenta.mcue_codipuc as CODIGO, mcuenta.mcue_nombre as NOMBRE, parcial=msal_valodebi-msal_valocred o msal_valocred-msal_valodebi WHERE mcuenta.mcue_codipuc=msaldocuenta.mcue_codipuc AND msaldocuenta.pano_ano=@ AND msaldocuenta.pmes_mes<=@ AND mcuenta.timp_codigo in ('N','P','@') AND mcuenta.tcla_codigo='R' // 3. mauxiliarcuenta.mcue_codipuc as COD, mauxiliarcuenta.mnit_nit as NIT, mnit.mnit_nombres+mnit.mnit_apellidos as NOMBRE, DETALLE = mauxiliarcuenta.maux_valodebi-mauxiliarcuenta.maux_valocred o mauxiliarcuenta.maux_valocred-mauxiliarcuenta.maux_valodebi FROM mcuenta, mauxiliarcuenta, mnit WHERE mauxiliarcuenta.mnit_nit=mnit.mnit_nit AND mcuenta.mcue_codipuc=mauxiliarcuenta.mcue_codipuc AND mauxiliarcuenta.pano_ano=@ AND mauxiliarcuenta.pmes_mes<=@ AND mauxiliarcuenta.mnit_nit != '@' //reportInfo.Text=ds.Tables.Count.ToString(); Press frontEnd = new Press(ds, reportTitle); frontEnd.PreHeader(tabPreHeader, report.Width, pr); frontEnd.Firmas(tabFirmas, report.Width); frontEnd.SourceFieldTitles(balGen.PressFields); tbReport = frontEnd.TbReport; ArrayList arC = new ArrayList(); ArrayList arV = new ArrayList(); DataRow[] rows; int l; TCred = new double[10]; TDeb = new double[10]; for (i = 0; i < 10; i++) { TCred[i] = 0; TDeb[i] = 0; } ; for (i = 0; i < ds.Tables[1].Rows.Count; i++) { Inserta(arC, ds.Tables[1].Rows[i][0].ToString(), Convert.ToDouble(ds.Tables[1].Rows[i][2]), arV); //Calcular Utilidades aca: //UBruta,UEjer,UOper /*if(Convert.ToInt16(ds.Tables[1].Rows[i][3])==1)UBruta+=Convert.ToDouble(ds.Tables[1].Rows[i][2]); * if(Convert.ToInt16(ds.Tables[1].Rows[i][3])==2)UEjer+=Convert.ToDouble(ds.Tables[1].Rows[i][2]); * if(Convert.ToInt16(ds.Tables[1].Rows[i][3])==3)UOper+=Convert.ToDouble(ds.Tables[1].Rows[i][2]);*/ if (ds.Tables[1].Rows[i][4].ToString().ToUpper() == "D") { TDeb[Convert.ToInt16(ds.Tables[1].Rows[i][0].ToString().Substring(0, 1))] += Convert.ToDouble(ds.Tables[1].Rows[i][2]); } if (ds.Tables[1].Rows[i][4].ToString().ToUpper() == "C") { TCred[Convert.ToInt16(ds.Tables[1].Rows[i][0].ToString().Substring(0, 1))] += Convert.ToDouble(ds.Tables[1].Rows[i][2]); } } //arC.Sort(); int tot = arC.Count; for (i = 0; i < tot; i++) { //reportInfo.Text+=arC[i].ToString()+"<br>"; l = arC[i].ToString().Length; dr = tbReport.NewRow(); dr[0] = arC[i].ToString(); rows = ds.Tables[0].Select("MCUE_CODIPUC = '" + arC[i].ToString() + "'"); if (rows.Length > 0) { dr[1] = rows[0][1]; } if (l < 3) { dr[5] = ((double)arV[i]).ToString(); } else { if (l == 4) { dr[4] = ((double)arV[i]).ToString(); } else { if (l == 6) { dr[3] = ((double)arV[i]).ToString(); } else { dr[2] = ((double)arV[i]).ToString(); } } } if (((double)arV[i]) != 0) { tbReport.Rows.Add(dr); } } frontEnd.PressFieldTitles(report); DataView dv = frontEnd.SortWithNextField(3, 0); DataTable dtTmp = dv.Table; if (values[3] == "A") { report.DataSource = SetAux(dv, 0); report.DataBind(); } else if (values[3] == "D") { report.DataSource = SetAux(dv, 14); report.DataBind(); } else if (values[3] == "G") { report.DataSource = SetAux(dv, 6); report.DataBind(); } else if (values[3] == "M") { report.DataSource = SetAux(dv, 4); report.DataBind(); } StringBuilder SB = new StringBuilder(); StringWriter SW = new StringWriter(SB); HtmlTextWriter htmlTW = new HtmlTextWriter(SW); tabPreHeader.RenderControl(htmlTW); report.RenderControl(htmlTW); tabFirmas.RenderControl(htmlTW); string strRep; strRep = SB.ToString(); Session.Clear(); Session["Rep"] = strRep; toolsHolder.Visible = true; }
protected void generar(Object Sender, EventArgs e) { string [] pr = new string[2]; pr[0] = pr[1] = ""; Press frontEnd = new Press(new DataSet(), reportTitle); frontEnd.PreHeader(tabPreHeader, Grid.Width, pr); frontEnd.Firmas(tabFirmas, Grid.Width); lb.Text = ""; Año = Convert.ToInt32(año.SelectedValue.ToString()); Mes = Convert.ToInt32(DBFunctions.SingleData("SELECT pmes_mes FROM DBXSCHEMA.pmes WHERE pmes_nombre='" + mes.SelectedValue.ToString() + "' ")); /////////////////////////////////////////////////////// this.PrepararTabla(); lineas = new DataSet(); DBFunctions.Request(lineas, IncludeSchema.NO, "select MAN_CODIGO,MAN_FECHA,COD_ANTICIPO,MCAT_PLACA,MAN_VALOTOTAL from DBXSCHEMA.MANTICIPO MAN where MAN.MCAT_PLACA='" + Placa.SelectedValue.ToString() + "' AND year(MAN_FECHA)=" + Año + " and month(MAN_FECHA)=" + Mes + " "); // 0 1 2 3 4 for (int i = 0; i < lineas.Tables[0].Rows.Count; i++) { string codigoE = DBFunctions.SingleData("select TTANTI_CODIGO FROM DBXSCHEMA.TANTICIPO WHERE COD_ANTICIPO=" + lineas.Tables[0].Rows[i].ItemArray[2] + ""); string descripcion = DBFunctions.SingleData("select TTIPA_DESCRIPCION from DBXSCHEMA.TTIOPOANTICIPO WHERE TTIPA_CODIGO=" + codigoE + " "); //codigoanticipo=Convert.ToInt32(lineas.Tables[0].Rows[i].ItemArray[2].ToString()); //descripcion=DBFunctions.SingleData("select TTIPA_DESCRIPCION from DBXSCHEMA.TTIOPOANTICIPO WHERE TTIPA_CODIGO="+codigoanticipo+" "); //Vamos a crear una fila para nuestro DataTable resultado, que almacene los resultados de las operaciones anteriores DataRow fila; //SaldoFinal1=String.Format("{0:C}",saldoLinea); fila = resultado.NewRow(); double valor = 0; string ValorFormato = null; valor = Convert.ToDouble(lineas.Tables[0].Rows[i].ItemArray[4].ToString()); ValorFormato = String.Format("{0:C}", valor); fila["FECHA"] = lineas.Tables[0].Rows[i].ItemArray[1].ToString(); fila["CODIGO"] = lineas.Tables[0].Rows[i].ItemArray[0].ToString(); fila["DESCRIPCION"] = descripcion.ToString(); fila["VALOR"] = ValorFormato; resultado.Rows.Add(fila); } //fin sentencia FOR Grid.DataSource = resultado; Grid.DataBind(); StringBuilder SB = new StringBuilder(); StringWriter SW = new StringWriter(SB); HtmlTextWriter htmlTW = new HtmlTextWriter(SW); tabPreHeader.RenderControl(htmlTW); Grid.RenderControl(htmlTW); tabFirmas.RenderControl(htmlTW); string strRep; strRep = SB.ToString(); Session.Clear(); Session["Rep"] = strRep; toolsHolder.Visible = true; }
protected void generar_OnClick(Object Sender, EventArgs e) { string [] pr = new string[2]; pr[0] = pr[1] = ""; Press frontEnd = new Press(new DataSet(), reportTitle); frontEnd.PreHeader(tabPreHeader, Grid.Width, pr); frontEnd.Firmas(tabFirmas, Grid.Width); lb.Text = ""; string fecha = null; if (RadioButtonList1.SelectedItem.Value.Equals("1")) { fecha = "AND YEAR(MAN_FECHA)=" + AñoBox.Text.ToString() + " "; } if (RadioButtonList1.SelectedItem.Value.Equals("2")) { fecha = "AND YEAR(MAN_FECHA)=" + AñoBox.Text.ToString() + " AND MONTH(MAN_FECHA)=" + MesBox.Text.ToString() + " "; } if (RadioButtonList1.SelectedItem.Value.Equals("3")) { fecha = "AND YEAR(MAN_FECHA)=" + AñoBox.Text.ToString() + " AND MONTH(MAN_FECHA)=" + MesBox.Text.ToString() + " AND DAY(MAN_FECHA)=" + DiaBox.Text.ToString() + " "; } /////////////////////////////////////////////////////// this.PrepararTabla(); lineas = new DataSet(); string query = null; query = "select PREF_DOCU CONCAT' 'CONCAT CAST(MAN_CODIGO AS CHARACTER(10)),MAN_FECHA,COD_ANTICIPO,MCAT_PLACA,MNIT_EMPLEADO_CONDUCTOR,MAN_DESC,MAN_VALOTOTAL from DBXSCHEMA.MANTICIPO_EXTRA WHERE MCAT_PLACA='" + placa.SelectedValue.ToString() + "' " + fecha.ToString() + " "; // 0 1 2 3 4 5 6 DBFunctions.Request(lineas, IncludeSchema.NO, "" + query.ToString() + ""); for (int i = 0; i < lineas.Tables[0].Rows.Count; i++) { string descripcion = null; descripcion = DBFunctions.SingleData("SELECT TTIPA_DESCRIPCION from DBXSCHEMA.TTIOPOANTICIPO WHERE TTIPA_CODIGO=" + lineas.Tables[0].Rows[i].ItemArray[2].ToString() + ""); string nombre = null; nombre = DBFunctions.SingleData("SELECT MNIT.MNIT_NOMBRES CONCAT ' 'CONCAT coalesce(MNIT.MNIT_NOMBRE2,'') CONCAT ' ' CONCAT MNIT.MNIT_APELLIDOS CONCAT ' ' CONCAT coalesce(MNIT.MNIT_APELLIDO2,'') from DBXSCHEMA.MNIT MNIT,DBXSCHEMA.MEMPLEADO MEMP WHERE MNIT.MNIT_NIT='" + lineas.Tables[0].Rows[i].ItemArray[4].ToString() + "'"); //Vamos a crear una fila para nuestro DataTable resultado, que almacene los resultados de las operaciones anteriores DataRow fila; fila = resultado.NewRow(); double valor = 0; string ValorFormato = null; valor = Convert.ToDouble(lineas.Tables[0].Rows[i].ItemArray[6].ToString()); ValorFormato = String.Format("{0:C}", valor); string Fecha = Convert.ToDateTime(lineas.Tables[0].Rows[i].ItemArray[1]).ToString("yyyy-MM-dd"); fila["DOCUMENTO"] = lineas.Tables[0].Rows[i].ItemArray[0].ToString(); fila["FECHA"] = Fecha.ToString(); fila["TANTICIPO"] = descripcion.ToString(); fila["PLACA"] = lineas.Tables[0].Rows[i].ItemArray[3].ToString(); fila["NOMBRE"] = nombre.ToString(); fila["DESC"] = descripcion.ToString(); fila["VALOR"] = ValorFormato.ToString(); resultado.Rows.Add(fila); } //fin sentencia FOR Grid.DataSource = resultado; Grid.DataBind(); StringBuilder SB = new StringBuilder(); StringWriter SW = new StringWriter(SB); HtmlTextWriter htmlTW = new HtmlTextWriter(SW); tabPreHeader.RenderControl(htmlTW); Grid.RenderControl(htmlTW); tabFirmas.RenderControl(htmlTW); string strRep; strRep = SB.ToString(); Session.Clear(); Session["Rep"] = strRep; toolsHolder.Visible = true; }
public void generar(Object Sender, EventArgs e) { string [] pr = new string[2]; pr[0] = pr[1] = ""; Press frontEnd = new Press(new DataSet(), reportTitle); frontEnd.PreHeader(tabPreHeader, Grid.Width, pr); frontEnd.Firmas(tabFirmas, Grid.Width); lb.Text = ""; Año = Convert.ToInt32(año.SelectedValue.ToString()); Mes = Convert.ToInt32(DBFunctions.SingleData("SELECT pmes_mes FROM DBXSCHEMA.pmes WHERE pmes_nombre='" + mes.SelectedValue.ToString() + "' ")); dia = Convert.ToInt32(Dia.Text.ToString()); /////////////////////////////////////////////////////// this.PrepararTabla(); this.PrepararTabla1(); this.PrepararTabla2(); this.PrepararTabla4(); lineas = new DataSet(); lineas2 = new DataSet(); lineas3 = new DataSet(); lineas4 = new DataSet(); DBFunctions.Request(lineas, IncludeSchema.NO, "Select MREM.MCAT_PLACA AS PLACA,MREM.NUM_REM AS NUMERO,MREM.VALO_FLET AS REMESA from DBXSCHEMA.MREMESA MREM where year(MREM_FECHA)=" + Año + " AND MONTH(MREM_FECHA)=" + Mes + " AND DAY(MREM_FECHA)=" + dia + " "); //remesa DBFunctions.Request(lineas2, IncludeSchema.NO, "SELECT MAN.MCAT_PLACA AS PLACA,MAN.MAN_CODIGO AS NUMERO,MAN.MAN_VALOTOTAL AS VALOR from DBXSCHEMA.MANTICIPO MAN WHERE year(MAN_FECHA)=" + Año + " AND MONTH(MAN_FECHA)=" + Mes + " AND DAY(MAN_FECHA)=" + dia + " "); //anticipo DBFunctions.Request(lineas3, IncludeSchema.NO, "select MAU.MCAT_PLACA AS PLACA,MAU.MAU_CODIGO AS NUMERO,MAU.MAU_VALOTOT AS VALOR from DBXSCHEMA.MAUTORIZACION MAU WHERE year(MAU_FECHA)=" + Año + " AND MONTH(MAU_FECHA)=" + Mes + " AND DAY(MAU_FECHA)=" + dia + " "); //autorizacion de servicio DBFunctions.Request(lineas4, IncludeSchema.NO, "select DRUT.MCAT_PLACA,DRUT.DRUT_PLANILLA,DRUT.DRUT_CODIGO from DBXSCHEMA.DRUTA DRUT WHERE year(DRUT.DRUT_FECHA)=" + Año + " AND MONTH(DRUT.DRUT_FECHA)=" + Mes + " AND DAY(DRUT.DRUT_FECHA)=" + dia + " "); // tiquetes /////////////////////////TABLAS////////////////////////// /////////////////// TABLA 1 ///////////////////////////// for (int i = 0; i < lineas.Tables[0].Rows.Count; i++) { //Vamos a crear una fila para nuestro DataTable resultado, que almacene los resultados de las operaciones anteriores DataRow fila; fila = resultado.NewRow(); double valor = 0; string ValorFormato = null; valor = Convert.ToDouble(lineas.Tables[0].Rows[i].ItemArray[2].ToString()); ValorFormato = String.Format("{0:C}", valor); fila["BUS"] = lineas.Tables[0].Rows[i].ItemArray[0].ToString(); fila["NUMERO"] = lineas.Tables[0].Rows[i].ItemArray[1].ToString(); fila["VALOR"] = ValorFormato.ToString(); resultado.Rows.Add(fila); } ///////////////////////TABLA 2/////////////////////////// for (int a = 0; a < lineas2.Tables[0].Rows.Count; a++) { //Vamos a crear una fila para nuestro DataTable resultado, que almacene los resultados de las operaciones anteriores DataRow fila2; fila2 = resultado2.NewRow(); double valor2 = 0; string ValorFormato2 = null; valor2 = Convert.ToDouble(lineas2.Tables[0].Rows[a].ItemArray[2].ToString()); ValorFormato2 = String.Format("{0:C}", valor2); fila2["BUS1"] = lineas2.Tables[0].Rows[a].ItemArray[0].ToString(); fila2["NUMERO1"] = lineas2.Tables[0].Rows[a].ItemArray[1].ToString(); fila2["VALOR1"] = ValorFormato2.ToString(); resultado2.Rows.Add(fila2); } /////////////////// TABLA 3 ///////////////////// for (int b = 0; b < lineas3.Tables[0].Rows.Count; b++) { //Vamos a crear una fila para nuestro DataTable resultado, que almacene los resultados de las operaciones anteriores DataRow fila3; fila3 = resultado3.NewRow(); double valor3 = 0; string ValorFormato3 = null; valor3 = Convert.ToDouble(lineas3.Tables[0].Rows[b].ItemArray[2].ToString()); ValorFormato3 = String.Format("{0:C}", valor3); fila3["BUS2"] = lineas3.Tables[0].Rows[b].ItemArray[0].ToString(); fila3["NUMERO2"] = lineas3.Tables[0].Rows[b].ItemArray[1].ToString(); fila3["VALOR2"] = ValorFormato3.ToString(); resultado3.Rows.Add(fila3); } /////////////////// TABLA 4 ///////////////////// for (int c = 0; c < lineas4.Tables[0].Rows.Count; c++) { int codigoruta = Convert.ToInt32(lineas4.Tables[0].Rows[c].ItemArray[2].ToString()); int Puestos = Convert.ToInt32(DBFunctions.SingleData("SELECT count(*) AS NUMERO from DBXSCHEMA.DTIQUETE where DRUT_CODIGO=" + codigoruta + " and TTIQ_CODIGO=1")); int codigoMruta = Convert.ToInt32(DBFunctions.SingleData("select MRUT_CODIGO FROM DBXSCHEMA.DRUTA WHERE DRUT_CODIGO=" + codigoruta + " ")); double precio = Convert.ToDouble(DBFunctions.SingleData("select MRUT_VALOR from DBXSCHEMA.MRUTA WHERE MRUT_CODIGO=" + codigoMruta + "")); double total = precio * Puestos; //Vamos a crear una fila para nuestro DataTable resultado, que almacene los resultados de las operaciones anteriores DataRow fila4; fila4 = resultado4.NewRow(); string ValorFormato4 = null; ValorFormato4 = String.Format("{0:C}", total); fila4["BUS4"] = lineas4.Tables[0].Rows[c].ItemArray[0].ToString(); fila4["TOTAL"] = Puestos; fila4["VALOR4"] = ValorFormato4.ToString(); resultado4.Rows.Add(fila4); } ///////////// FIN TABLAS //////////////////// Grid.DataSource = resultado; Grid.DataBind(); StringBuilder SB = new StringBuilder(); StringWriter SW = new StringWriter(SB); HtmlTextWriter htmlTW = new HtmlTextWriter(SW); tabPreHeader.RenderControl(htmlTW); Grid.RenderControl(htmlTW); tabFirmas.RenderControl(htmlTW); string strRep; strRep = SB.ToString(); Session.Clear(); Session["Rep"] = strRep; toolsHolder.Visible = true; ////////////////////////////// Grid1.DataSource = resultado2; Grid1.DataBind(); Grid1.RenderControl(htmlTW); ////////////////////////////// Grid2.DataSource = resultado3; Grid2.DataBind(); Grid2.RenderControl(htmlTW); ////////////////////////////// Grid3.DataSource = resultado4; Grid3.DataBind(); Grid3.RenderControl(htmlTW); //////////////////////////////// }
public void MakeReport(Object Sender, EventArgs E) { DatasForReport balPru = new DatasForReport(reportTitle); ds = balPru.GetDatas(false, GetParams()); Press frontEnd = new Press(ds, reportTitle); frontEnd.PreHeader(tabPreHeader, report.Width, pr); frontEnd.Firmas(tabFirmas, report.Width); frontEnd.SourceFieldTitles(balPru.PressFields); tbReport = frontEnd.TbReport; decimal subtotal = 0, total = 0; string cVal, aVal; DataRow[] rows; //Operations op = new Operations(ds, balPru.Operations); //op.Executer(); //reportInfo.Text += op.InfoProcess; for (i = 0; i < ds.Tables[1].Rows.Count; i++) { dr = tbReport.NewRow(); tbReport.Rows.Add(dr); cVal = ds.Tables[1].Rows[i][0].ToString(); dr[0] = cVal; dr[1] = ds.Tables[1].Rows[i][1]; rows = ds.Tables[0].Select("MCUE_CODIPUC = '" + cVal.Substring(0, 4) + "'"); if (rows[0][2].ToString() == "D") { dr[2] = (Decimal)ds.Tables[1].Rows[i][2]; } else { dr[5] = (Decimal)ds.Tables[1].Rows[i][2]; } subtotal += (Decimal)Convert.ToDecimal(ds.Tables[1].Rows[i][2]); if (i != ds.Tables[1].Rows.Count - 1) { aVal = ds.Tables[1].Rows[i + 1][0].ToString(); if (cVal.Substring(0, 4) != aVal.Substring(0, 4)) { dr = tbReport.NewRow(); tbReport.Rows.Add(dr); dr[0] = "TOTAL"; rows = ds.Tables[0].Select("MCUE_CODIPUC = '" + cVal.Substring(0, 4) + "'"); dr[1] = rows[0][1]; if (rows[0][2].ToString() == "D") { dr[3] = subtotal; } else { dr[6] = subtotal; } total += subtotal; subtotal = 0; } if (cVal.Substring(0, 2) != aVal.Substring(0, 2)) { dr = tbReport.NewRow(); tbReport.Rows.Add(dr); dr[0] = "TOTAL"; rows = ds.Tables[0].Select("MCUE_CODIPUC = '" + cVal.Substring(0, 2) + "'"); dr[1] = rows[0][1]; if (rows[0][2].ToString() == "D") { dr[4] = total; } else { dr[7] = total; } total = 0; } } toolsHolder.Visible = true; } report.DataSource = ds.Tables[2]; frontEnd.PressFieldTitles(report); report.DataBind(); StringBuilder SB = new StringBuilder(); StringWriter SW = new StringWriter(SB); HtmlTextWriter htmlTW = new HtmlTextWriter(SW); tabPreHeader.RenderControl(htmlTW); report.RenderControl(htmlTW); tabFirmas.RenderControl(htmlTW); string strRep; strRep = SB.ToString(); Session.Clear(); Session["Rep"] = strRep; toolsHolder.Visible = true; }
public void MakeReport(Object Sender, EventArgs E) { DatasForReport balGen = new DatasForReport(reportTitle); ds = balGen.GetDatas(false, GetParams()); //reportInfo.Text += balGen.SQL[0] + "<br>"; //dgTest.DataSource = ds.Tables[2]; //dgTest.DataBind(); Press frontEnd = new Press(ds, reportTitle); frontEnd.PreHeader(tabPreHeader, report.Width, pr); frontEnd.Firmas(tabFirmas, report.Width); frontEnd.SourceFieldTitles(balGen.PressFields); tbReport = frontEnd.TbReport; double parcialD1 = 0, parcialD2 = 0, parcialD3 = 0, parcialC1 = 0, parcialC2 = 0, parcialC3 = 0; double subtotalD1 = 0, subtotalD2 = 0, subtotalD3 = 0, subtotalC1 = 0, subtotalC2 = 0, subtotalC3 = 0; double totalD1 = 0, totalD2 = 0, totalD3 = 0, totalC1 = 0, totalC2 = 0, totalC3 = 0; string cVal, aVal; string mcue = ""; double saldoAntCuenta = 0, saldoAntSubCuenta = 0, saldoAntSubSubCuenta = 0; double saldoCuenta = 0, saldoSubCuenta = 0, saldoSubSubCuenta = 0; double saldo = 0; double totalSaldoAntDeb = 0, totalSaldoAntCre = 0, totalSaldoActDeb = 0, totalSaldoActCre = 0, totalSaldoDeb = 0, totalSaldoCre = 0; try{ mcue = DBFunctions.SingleData("SELECT mcue_codipuc FROM ccontabilidad"); }catch {}; mcue = mcue.Trim(); DataRow[] rows; for (i = 0; i < ds.Tables[3].Rows.Count; i++) { dr = tbReport.NewRow(); cVal = ds.Tables[3].Rows[i][0].ToString(); dr[0] = cVal; if (dr[0].ToString() != mcue) { tbReport.Rows.Add(dr); dr[1] = ds.Tables[3].Rows[i][1]; saldo = CalcularSaldoCuenta(cVal, Convert.ToDouble(ds.Tables[3].Rows[i][2]), Convert.ToDouble(ds.Tables[3].Rows[i][3])); if (NaturalezaCuenta(cVal) == "D") { if (saldo > 0) { dr[6] = saldo; totalSaldoDeb = totalSaldoDeb + saldo; } else if (saldo < 0) { dr[7] = saldo * -1; totalSaldoCre = totalSaldoCre + (saldo * -1); } } else if (NaturalezaCuenta(cVal) == "C") { if (saldo > 0) { dr[7] = saldo; totalSaldoCre = totalSaldoCre + saldo; } else if (saldo < 0) { dr[6] = saldo * -1; totalSaldoDeb = totalSaldoDeb + (saldo * -1); } } /*if(Convert.ToDouble(ds.Tables[3].Rows[i][2]) != 0) * dr[6] = Convert.ToDouble(ds.Tables[3].Rows[i][2]); * if(Convert.ToDouble(ds.Tables[3].Rows[i][3]) != 0) * dr[7] = Convert.ToDouble(ds.Tables[3].Rows[i][3]);*/ rows = ds.Tables[2].Select("CODIGO = '" + cVal + "'"); if (rows.Length > 0) { dr[4] = Convert.ToDouble(rows[0][2]); dr[5] = Convert.ToDouble(rows[0][3]); parcialD2 += Convert.ToDouble(rows[0][2]); parcialC2 += Convert.ToDouble(rows[0][3]); totalSaldoActDeb = totalSaldoActDeb + Convert.ToDouble(rows[0][2]); totalSaldoActCre = totalSaldoActCre + Convert.ToDouble(rows[0][3]); } rows = ds.Tables[1].Select("CODIGO = '" + cVal + "'"); if (rows.Length > 0) { dr[2] = Convert.ToDouble(rows[0][2]); dr[3] = Convert.ToDouble(rows[0][3]); parcialD1 += Convert.ToDouble(rows[0][2]); parcialC1 += Convert.ToDouble(rows[0][3]); totalSaldoAntDeb = totalSaldoAntDeb + Convert.ToDouble(rows[0][2]); totalSaldoAntCre = totalSaldoAntCre + Convert.ToDouble(rows[0][3]); } parcialD3 += Convert.ToDouble(ds.Tables[3].Rows[i][2]); parcialC3 += Convert.ToDouble(ds.Tables[3].Rows[i][3]); if (i != ds.Tables[3].Rows.Count - 1) { aVal = ds.Tables[3].Rows[i + 1][0].ToString(); } else { aVal = "00000"; } if (cVal.Substring(0, 4) != aVal.Substring(0, 4)) { dr = tbReport.NewRow(); tbReport.Rows.Add(dr); dr[0] = cVal.Substring(0, 4); rows = ds.Tables[0].Select("MCUE_CODIPUC = '" + cVal.Substring(0, 4) + "'"); dr[1] = rows[0][1]; saldoAntSubSubCuenta = CalcularSaldoCuenta(cVal.Substring(0, 4), parcialD1, parcialC1); if (NaturalezaCuenta(cVal.Substring(0, 4)) == "D") { if (saldoAntSubSubCuenta > 0) { dr[2] = saldoAntSubSubCuenta; } else if (saldoAntSubCuenta < 0) { dr[3] = saldoAntSubSubCuenta * -1; } } else if (NaturalezaCuenta(cVal.Substring(0, 4)) == "C") { if (saldoAntSubSubCuenta > 0) { dr[3] = saldoAntSubSubCuenta; } else if (saldoAntSubSubCuenta < 0) { dr[2] = saldoAntSubSubCuenta * -1; } } dr[4] = parcialD2; dr[5] = parcialC2; saldoSubSubCuenta = CalcularSaldoCuenta(cVal.Substring(0, 4), parcialD3, parcialC3); if (NaturalezaCuenta(cVal.Substring(0, 4)) == "D") { if (saldoSubSubCuenta > 0) { dr[6] = saldoSubSubCuenta; } else if (saldoSubSubCuenta < 0) { dr[7] = saldoSubSubCuenta * -1; } } else if (NaturalezaCuenta(cVal.Substring(0, 4)) == "C") { if (saldoSubSubCuenta > 0) { dr[7] = saldoSubSubCuenta; } else if (saldoSubSubCuenta < 0) { dr[6] = saldoSubSubCuenta * -1; } } subtotalD1 += parcialD1; subtotalD2 += parcialD2; subtotalD3 += parcialD3; subtotalC1 += parcialC1; subtotalC2 += parcialC2; subtotalC3 += parcialC3; parcialD1 = 0; parcialD2 = 0; parcialD3 = 0; parcialC1 = 0; parcialC2 = 0; parcialC3 = 0; } if (cVal.Substring(0, 2) != aVal.Substring(0, 2)) { dr = tbReport.NewRow(); tbReport.Rows.Add(dr); dr[0] = cVal.Substring(0, 2); //*rows = ds.Tables[0].Select("MCUE_CODIPUC = '" + cVal.Substring(0,2) + "'"); try{ dr[1] = DBFunctions.SingleData("SELECT mcue_nombre FROM mcuenta WHERE mcue_codipuc='" + cVal.Substring(0, 2) + "'"); } catch {} saldoAntSubCuenta = CalcularSaldoCuenta(cVal.Substring(0, 2), subtotalD1, subtotalC1); if (NaturalezaCuenta(cVal.Substring(0, 2)) == "D") { if (saldoAntSubCuenta > 0) { dr[2] = saldoAntSubCuenta; } else if (saldoAntSubCuenta < 0) { dr[3] = saldoAntSubCuenta * -1; } } else if (NaturalezaCuenta(cVal.Substring(0, 2)) == "C") { if (saldoAntSubCuenta > 0) { dr[3] = saldoAntSubCuenta; } else if (saldoAntSubCuenta < 0) { dr[2] = saldoAntSubCuenta * -1; } } dr[4] = subtotalD2; dr[5] = subtotalC2; saldoSubCuenta = CalcularSaldoCuenta(cVal.Substring(0, 2), subtotalD3, subtotalC3); if (NaturalezaCuenta(cVal.Substring(0, 2)) == "D") { if (saldoSubCuenta > 0) { dr[6] = saldoSubCuenta; } else if (saldoSubCuenta < 0) { dr[7] = saldoSubCuenta * -1; } } else if (NaturalezaCuenta(cVal.Substring(0, 2)) == "C") { if (saldoSubCuenta > 0) { dr[7] = saldoSubCuenta; } else if (saldoSubCuenta < 0) { dr[6] = saldoSubCuenta * -1; } } totalD1 += subtotalD1; totalD2 += subtotalD2; totalD3 += subtotalD3; totalC1 += subtotalC1; totalC2 += subtotalC2; totalC3 += subtotalC3; subtotalD1 = 0; subtotalD2 = 0; subtotalD3 = 0; subtotalC1 = 0; subtotalC2 = 0; subtotalC3 = 0; } if (cVal.Substring(0, 1) != aVal.Substring(0, 1)) { dr = tbReport.NewRow(); tbReport.Rows.Add(dr); dr[0] = cVal.Substring(0, 1); try { rows = ds.Tables[0].Select("MCUE_CODIPUC = '" + cVal.Substring(0, 1) + "'"); dr[1] = rows[0][1]; } catch { dr[1] = ""; } saldoAntCuenta = CalcularSaldoCuenta(cVal.Substring(0, 1), totalD1, totalC1); if (NaturalezaCuenta(cVal.Substring(0, 1)) == "D") { if (saldoAntCuenta > 0) { dr[2] = saldoAntCuenta; } else if (saldoAntCuenta < 0) { dr[3] = saldoAntCuenta * -1; } } else if (NaturalezaCuenta(cVal.Substring(0, 1)) == "C") { if (saldoAntCuenta > 0) { dr[3] = saldoAntCuenta; } else if (saldoAntCuenta < 0) { dr[2] = saldoAntCuenta * -1; } } dr[4] = totalD2; dr[5] = totalC2; saldoCuenta = CalcularSaldoCuenta(cVal.Substring(0, 1), totalD3, totalC3); if (NaturalezaCuenta(cVal.Substring(0, 1)) == "D") { if (saldoCuenta > 0) { dr[6] = saldoCuenta; } else if (saldoCuenta < 0) { dr[7] = saldoCuenta * -1; } } else if (NaturalezaCuenta(cVal.Substring(0, 1)) == "C") { if (saldoCuenta > 0) { dr[7] = saldoCuenta; } else if (saldoCuenta < 0) { dr[6] = saldoCuenta * -1; } } totalD1 = 0; totalD2 = 0; totalD3 = 0; totalC1 = 0; totalC2 = 0; totalC3 = 0; } } } drTotales = tbReport.NewRow(); dr[0] = "T O T "; dr[1] = " A L E S "; dr[2] = totalSaldoAntDeb.ToString("N"); dr[3] = totalSaldoAntCre.ToString("N"); dr[4] = totalSaldoActDeb.ToString("N"); dr[5] = totalSaldoActCre.ToString("N"); dr[6] = totalSaldoDeb.ToString("N"); dr[7] = totalSaldoCre.ToString("N"); tbReport.Rows.Add(drTotales); frontEnd.PressFieldTitles(report); DataView dv = frontEnd.SortWithNextField(4, 0); //DataTable dtTmp = dv.Table; if (values[2] == "D") { report.DataSource = dv; report.DataBind(); } else if (values[2] == "G") { report.DataSource = ApplyFilter(dv, 6); report.DataBind(); } else if (values[2] == "M") { report.DataSource = ApplyFilter(dv, 4); report.DataBind(); } StringBuilder SB = new StringBuilder(); StringWriter SW = new StringWriter(SB); HtmlTextWriter htmlTW = new HtmlTextWriter(SW); tabPreHeader.RenderControl(htmlTW); report.RenderControl(htmlTW); tabFirmas.RenderControl(htmlTW); string strRep; strRep = SB.ToString(); Session.Clear(); Session["Rep"] = strRep; toolsHolder.Visible = true; }
protected void generar(Object Sender, EventArgs e) { string [] pr = new string[2]; pr[0] = pr[1] = ""; Press frontEnd = new Press(new DataSet(), reportTitle); frontEnd.PreHeader(tabPreHeader, Grid.Width, pr); frontEnd.Firmas(tabFirmas, Grid.Width); lb.Text = ""; codigoagencia = DBFunctions.SingleData("select MOFI_CODIGO from DBXSCHEMA.MOFICINA WHERE MOFI_DESCRIPCION ='" + Agencia.SelectedValue.ToString() + "' "); Año = Convert.ToInt32(año.SelectedValue.ToString()); Mes = Convert.ToInt32(DBFunctions.SingleData("SELECT pmes_mes FROM DBXSCHEMA.pmes WHERE pmes_nombre='" + mes.SelectedValue.ToString() + "' ")); /////////////////////////////////////////////////////// this.PrepararTabla(); lineas = new DataSet(); DBFunctions.Request(lineas, IncludeSchema.NO, "select MGIRO_CODGIRO,FECHA_GIRO,AGENCIA_ORIGEN,NOMBRE_EMISOR,CEDULA_EMISOR,NOMBRE_DESTINATARIO,CEDULA_DESTINATARIO,MGIRO_VALOR,MGIRO_COSTO,DGIRO_CODIGO from DBXSCHEMA.MGIRO WHERE AGENCIA_DESTINO='" + codigoagencia + "' AND year(FECHA_GIRO)=" + Año + " and month(FECHA_GIRO)=" + Mes + " "); for (int i = 0; i < lineas.Tables[0].Rows.Count; i++) { string estado = DBFunctions.SingleData("Select DGIRO_DESCRIPCION from DBXSCHEMA.DGIRO WHERE DGIRO_CODIGO=" + lineas.Tables[0].Rows[i].ItemArray[9].ToString() + " "); string agencia = DBFunctions.SingleData("select MOFI_DESCRIPCION from DBXSCHEMA.MOFICINA WHERE MOFI_CODIGO ='" + lineas.Tables[0].Rows[i].ItemArray[2].ToString() + "' "); //Vamos a crear una fila para nuestro DataTable resultado, que almacene los resultados de las operaciones anteriores DataRow fila; fila = resultado.NewRow(); double valor = 0; double costo = 0; string Valor = null; string Costo = null; valor = Convert.ToDouble(lineas.Tables[0].Rows[i].ItemArray[7].ToString()); costo = Convert.ToDouble(lineas.Tables[0].Rows[i].ItemArray[8].ToString()); Valor = String.Format("{0:C}", valor); Costo = String.Format("{0:C}", costo); fila["NUMEROGIRO"] = lineas.Tables[0].Rows[i].ItemArray[0].ToString(); fila["FECHA"] = lineas.Tables[0].Rows[i].ItemArray[1].ToString(); fila["ORIGEN"] = agencia.ToString(); fila["NOMBREEMISOR"] = lineas.Tables[0].Rows[i].ItemArray[3].ToString(); fila["CEDULAEMISOR"] = lineas.Tables[0].Rows[i].ItemArray[4].ToString(); fila["NOMBRERECEPTOR"] = lineas.Tables[0].Rows[i].ItemArray[5].ToString(); fila["CEDULARECEPTOR"] = lineas.Tables[0].Rows[i].ItemArray[6].ToString(); fila["VALORGIRO"] = Valor.ToString(); fila["COSTOGIRO"] = Costo.ToString(); fila["ESTADOGIRO"] = estado.ToString(); resultado.Rows.Add(fila); } //fin sentencia FOR Grid.DataSource = resultado; Grid.DataBind(); StringBuilder SB = new StringBuilder(); StringWriter SW = new StringWriter(SB); HtmlTextWriter htmlTW = new HtmlTextWriter(SW); tabPreHeader.RenderControl(htmlTW); Grid.RenderControl(htmlTW); tabFirmas.RenderControl(htmlTW); string strRep; strRep = SB.ToString(); Session.Clear(); Session["Rep"] = strRep; toolsHolder.Visible = true; }
protected void generar(Object Sender, EventArgs e) { string [] pr = new string[2]; pr[0] = pr[1] = ""; Press frontEnd = new Press(new DataSet(), reportTitle); frontEnd.PreHeader(tabPreHeader, Grid.Width, pr); frontEnd.Firmas(tabFirmas, Grid.Width); lb.Text = ""; Año = Convert.ToInt32(año.SelectedValue.ToString()); Mes = Convert.ToInt32(DBFunctions.SingleData("SELECT pmes_mes FROM DBXSCHEMA.pmes WHERE pmes_nombre='" + mes.SelectedValue.ToString() + "' ")); /////////////////////////////////////////////////////// this.PrepararTabla(); lineas = new DataSet(); DBFunctions.Request(lineas, IncludeSchema.NO, "SELECT TREM_CODIGO,NUM_REM,MREM_FECHA,NOM_EMISOR,NOM_DESTINO,ORIGEN,DESTINO,VALOR_DEC,UNIDADES,PESO,VALO_FLET,MREM_ESTADO,MREM_CONTENIDO FROM DBXSCHEMA.MREMESA where MCAT_PLACA='" + Placa.SelectedValue.ToString() + "' AND year(MREM_FECHA)=" + Año + " and month(MREM_FECHA)=" + Mes + " "); for (int i = 0; i < lineas.Tables[0].Rows.Count; i++) { string descripcion = null; int codigoremesa = 0; codigoremesa = Convert.ToInt32(lineas.Tables[0].Rows[i].ItemArray[0].ToString()); descripcion = DBFunctions.SingleData("Select TREM_DESCRIPCION from DBXSCHEMA.TREMESA WHERE TREM_CODIGO=" + codigoremesa + " "); int codigoEstado = 0; string descrpcionestado = null; codigoEstado = Convert.ToInt32(lineas.Tables[0].Rows[i].ItemArray[11].ToString()); descrpcionestado = DBFunctions.SingleData("Select TREMEST_DESCRIPCION from DBXSCHEMA.TREMESAESTADO WHERE TREMEST_CODIGO=" + codigoEstado + " "); //Vamos a crear una fila para nuestro DataTable resultado, que almacene los resultados de las operaciones anteriores DataRow fila; fila = resultado.NewRow(); double valor = 0; double valordec = 0; string ValorDecFormato = null; string ValorFormato = null; valordec = Convert.ToDouble(lineas.Tables[0].Rows[i].ItemArray[7].ToString()); valor = Convert.ToDouble(lineas.Tables[0].Rows[i].ItemArray[10].ToString()); ValorFormato = String.Format("{0:C}", valor); ValorDecFormato = String.Format("{0:C}", valordec); fila["NUMEROREMESA"] = lineas.Tables[0].Rows[i].ItemArray[1].ToString(); fila["FECHA"] = lineas.Tables[0].Rows[i].ItemArray[2].ToString(); fila["DESCRIPCION"] = descripcion.ToString(); fila["NOMBREEMISOR"] = lineas.Tables[0].Rows[i].ItemArray[3].ToString(); fila["NOMBREDESTINO"] = lineas.Tables[0].Rows[i].ItemArray[4].ToString(); fila["ORIGEN"] = lineas.Tables[0].Rows[i].ItemArray[5].ToString(); fila["DESTINO"] = lineas.Tables[0].Rows[i].ItemArray[6].ToString(); fila["VALORDECLARADO"] = ValorDecFormato.ToString(); fila["UNIDADES"] = lineas.Tables[0].Rows[i].ItemArray[8].ToString(); fila["PESO"] = lineas.Tables[0].Rows[i].ItemArray[9].ToString(); fila["VALORFLETE"] = ValorFormato.ToString(); fila["ESTADOREMESA"] = descrpcionestado.ToString(); fila["CONTENIDO"] = lineas.Tables[0].Rows[i].ItemArray[12].ToString(); resultado.Rows.Add(fila); } //fin sentencia FOR Grid.DataSource = resultado; Grid.DataBind(); StringBuilder SB = new StringBuilder(); StringWriter SW = new StringWriter(SB); HtmlTextWriter htmlTW = new HtmlTextWriter(SW); tabPreHeader.RenderControl(htmlTW); Grid.RenderControl(htmlTW); tabFirmas.RenderControl(htmlTW); string strRep; strRep = SB.ToString(); Session.Clear(); Session["Rep"] = strRep; toolsHolder.Visible = true; }