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;
}
