protected void PopulateValueCrystalReport(string var_idliquidacion)
{
if (Session[_nameSessionDataC] == null)
{
_liqValsReport = new ArrayList();
DataSet dsLiqInfo = Liquidations_Hdr.getLiquidationHdrInfo(var_idliquidacion);
if (dsLiqInfo == null)
{
return;
}
//DataSet dsLiqDtl = Liquidation_Dtl.getLiquidationDtl(_user._usv_co, _noLiq);
DataSet dsLiqDtl = new DataSet();
dsLiqDtl.Tables.Add(dsLiqInfo.Tables[1].Copy());
if (dsLiqDtl == null)
{
return;
}
DataRow dRow = dsLiqInfo.Tables[0].Rows[0];
foreach (DataRow dRowDtl in dsLiqDtl.Tables[0].Rows)
{
string vncredito = ""; decimal VtotalcreditoTotal = 0;
string vfecha = DateTime.Today.ToString("dd/MM/yyyy");
//Bata.Aquarella.BLL.Reports.Liquidation objLiqReport = new BLL.Reports.Liquidation(dRow["ohv_warehouseid"].ToString(), dRow["wav_description"].ToString(),
// dRow["wav_address"].ToString(), dRow["wav_telephones"].ToString(), dRow["ubicationwav"].ToString(), dRow["con_coordinator_id"].ToString(), dRow["bdv_document_no"].ToString(),
// dRow["name"].ToString(), dRow["bdv_address"].ToString(), dRow["bdv_phone"].ToString(), dRow["bdv_movil_phone"].ToString(), dRow["bdv_email"].ToString(),
// dRow["ubicationcustomer"].ToString(), dRow["lhv_liquidation_no"].ToString(), Convert.ToDateTime(dRow["lhd_date"]), Convert.ToDateTime(dRow["lhd_expiration_date"].ToString()),
// dRow["stv_description"].ToString(), Convert.ToDecimal(dRow["lon_disscount"]), Convert.ToDecimal(dRow["tax_rate"]), Convert.ToDecimal(dRow["lhn_tax_rate"]), Convert.ToDecimal(dRow["lhn_handling"]),
// dRowDtl["ldv_article"].ToString(), dRowDtl["brv_description"].ToString(), dRowDtl["cov_description"].ToString(), dRowDtl["arv_name"].ToString(), dRowDtl["ldv_size"].ToString(), Convert.ToDecimal(dRowDtl["ldn_qty"]),
// Convert.ToDecimal(dRowDtl["ldn_sell_price"]), Convert.ToDecimal(dRowDtl["ldn_commission"]), Convert.ToDecimal(dRowDtl["ldn_disscount"]), Convert.ToDecimal(dRow["percepcion"]), Convert.ToDecimal(dRow["porc_percepcion"]),
// Convert.ToDecimal(dRow["ncredito"]), vncredito, Convert.ToDateTime(vfecha), VtotalcreditoTotal, _noLiq, Convert.ToDecimal(dRow["totalop"]));
www.aquarella.com.pe.bll.Reports.Liquidation objLiqReport = new www.aquarella.com.pe.bll.Reports.Liquidation("1", dRow["almacen"].ToString(),
dRow["alm_direccion"].ToString(), dRow["Alm_Telefono"].ToString(), "", dRow["Bas_Id"].ToString(), dRow["Bas_Documento"].ToString(),
dRow["nombres"].ToString(), dRow["Bas_Direccion"].ToString(), dRow["Bas_Telefono"].ToString(), dRow["Bas_Celular"].ToString(), dRow["Bas_Correo"].ToString(),
dRow["ubicacion"].ToString(), dRow["Liq_Id"].ToString(), Convert.ToDateTime(dRow["Liq_FechaIng"]), Convert.ToDateTime(dRow["Liq_Fecha_Expiracion"].ToString()),
dRow["estado"].ToString(), 0, Convert.ToDecimal(dRow["igvporc"]), Convert.ToDecimal(dRow["igvmonto"]), 0,
dRowDtl["Art_Id"].ToString(), dRowDtl["Mar_Descripcion"].ToString(), dRowDtl["Col_Descripcion"].ToString(), dRowDtl["art_descripcion"].ToString(), dRowDtl["Liq_Det_TalId"].ToString(), Convert.ToDecimal(dRowDtl["Liq_Det_Cantidad"]),
Convert.ToDecimal(dRowDtl["Liq_Det_Precio"]), Convert.ToDecimal(dRowDtl["Liq_Det_Comision"]), 0, Convert.ToDecimal(dRow["Percepcionm"]), Convert.ToDecimal(dRow["Percepcionp"]),
Convert.ToDecimal(dRow["ncredito"]), vncredito, Convert.ToDateTime(vfecha), VtotalcreditoTotal, var_idliquidacion, Convert.ToDecimal(dRow["totalop"]), Convert.ToDecimal(dRowDtl["Liq_Det_OfertaM"]));
_liqValsReport.Add(objLiqReport);
}
_liqValsSubReport = new ArrayList();
//DataSet dsLiqpagoInfo = Liquidations_Hdr.getpagoncreditoliqui(_noLiq);
DataSet dsLiqpagoInfo = new DataSet();
dsLiqpagoInfo.Tables.Add(dsLiqInfo.Tables[2].Copy());
if (dsLiqpagoInfo == null)
{
return;
}
foreach (DataRow dRowDtl in dsLiqpagoInfo.Tables[0].Rows)
{
string vncredito = dRowDtl["ncredito"].ToString();
decimal VtotalcreditoTotal = Convert.ToDecimal(dRowDtl["Total"].ToString());
DateTime vfecha = Convert.ToDateTime(dRowDtl["fecha"].ToString());
www.aquarella.com.pe.bll.Reports.LiqNcSubinforme objLiqpagoReport = new www.aquarella.com.pe.bll.Reports.LiqNcSubinforme("", vncredito, vfecha, VtotalcreditoTotal);
_liqValsSubReport.Add(objLiqpagoReport);
}
_liqValsPagoSubReport = new ArrayList();
//DataSet dsLiqpagoformainfo = Liquidations_Hdr.getpagonformaliqui(_noLiq);
DataSet dsLiqpagoformainfo = new DataSet();
dsLiqpagoformainfo.Tables.Add(dsLiqInfo.Tables[3].Copy());
if (dsLiqpagoformainfo == null)
{
return;
}
foreach (DataRow drowdtl in dsLiqpagoformainfo.Tables[0].Rows)
{
string vpago = drowdtl["pago"].ToString();
string vdocumento = drowdtl["Documento"].ToString();
DateTime vfecha = Convert.ToDateTime(drowdtl["fecha"].ToString());
Decimal vtotal = Convert.ToDecimal(drowdtl["Total"].ToString());
www.aquarella.com.pe.bll.Reports.VentaPagoSubInforme objLiqpagoformaReport = new bll.Reports.VentaPagoSubInforme(vpago, vdocumento, vfecha, vtotal);
_liqValsPagoSubReport.Add(objLiqpagoformaReport);
}
}
else
{
_liqValsReport = (ArrayList)Session[_nameSessionDataC];
_liqValsSubReport = (ArrayList)Session[_nameSessionDataC];
_liqValsPagoSubReport = (ArrayList)Session[_nameSessionDataC];
}
}
public void PopulateValueCrystalReportI()
{
if (this.Session[this._nombreSession] == null)
{
DataSet ds_venta = Facturacion.getInvoiceHdr(this._noInvoice);
DataTable invoiceHdr = ds_venta.Tables[0].Copy();
//DataTable invoiceHdr = Facturacion.getInvoiceHdr(this._user._usv_co, this._noInvoice, this._noOrderUrl);
if (invoiceHdr.Rows.Count > 0)
{
//DataTable warehouseByPk = new warehouses(this._user._usv_co, invoiceHdr.Rows[0]["stv_warehouse"].ToString()).getWarehouseByPk();
string wavDescription = "";
string wavAddress = "";
string wavPhone = "";
string wavUbication = "";
//if (warehouseByPk != null && warehouseByPk.Rows.Count > 0)
//{
wavDescription = invoiceHdr.Rows[0]["almacen"].ToString().ToUpper();
wavAddress = invoiceHdr.Rows[0]["alm_direccion"].ToString();
wavPhone = invoiceHdr.Rows[0]["Alm_Telefono"].ToString();
wavUbication = "";
//}
string typeresolution = "";
//DataTable invoiceDtl = Facturacion.getInvoiceDtl(this._user._usv_co, this._noInvoice);
DataTable invoiceDtl = ds_venta.Tables[1].Copy();
string str = "";
Decimal descuentoGnral = 0;
string numeroRemision = "";
string destinatario = invoiceHdr.Rows[0]["nombres"].ToString();
string cedula = invoiceHdr.Rows[0]["Bas_Documento"].ToString();
string ubicacionDestinatario = invoiceHdr.Rows[0]["ubicacion"].ToString();
string telefono = invoiceHdr.Rows[0]["Bas_Telefono"].ToString();
string trasportadora = invoiceHdr.Rows[0]["Tra_Descripcion"].ToString();
string numeroGuia = invoiceHdr.Rows[0]["Tra_Gui_No"].ToString();
Decimal porc_percepcion = Convert.ToDecimal(invoiceHdr.Rows[0]["Percepcionp"].ToString());
Decimal iva = Convert.ToDecimal(invoiceHdr.Rows[0]["igvmonto"].ToString());
Decimal flete = 0;
DateTime fechaRemision = Convert.ToDateTime(invoiceHdr.Rows[0]["Ven_Fecha"].ToString());
Decimal ncredito = Convert.ToDecimal(invoiceHdr.Rows[0]["ncredito"].ToString());
Decimal totalop = Convert.ToDecimal(invoiceHdr.Rows[0]["totalop"].ToString());
this.facturacionValues = new ArrayList();
foreach (DataRow dataRow in (InternalDataCollectionBase)invoiceDtl.Rows)
{
string numFactura = dataRow["Ven_Det_Id"].ToString();
string esCopia = str;
string msgs = "";// invoiceHdr.Rows[0]["imv_text"].ToString();
string codigoArticulo = dataRow["Art_Id"].ToString();
string nomArticulo = dataRow["art_descripcion"].ToString();
Decimal cantidad = Convert.ToDecimal(dataRow["Ven_Det_Cantidad"].ToString());
string talla = dataRow["Ven_Det_TalId"].ToString();
Decimal precio = Convert.ToDecimal(dataRow["Ven_Det_Precio"].ToString());
Decimal valorLinea = Convert.ToDecimal(dataRow["articulo_value"].ToString());
Decimal descuentoArticulo = 0;
Decimal comisionLineal = Convert.ToDecimal(dataRow["Ven_Det_ComisionM"].ToString());
string descripcionArtic = dataRow["Col_Descripcion"].ToString();
this.facturacionValues.Add((object)new ReporteFacturacion(destinatario, ubicacionDestinatario, telefono, "", "", cedula, "", this._noOrderUrl, numFactura, fechaRemision, numeroRemision, "", esCopia, typeresolution, codigoArticulo, nomArticulo, descripcionArtic, cantidad, talla, precio, descuentoArticulo, comisionLineal, valorLinea, iva, flete, numeroGuia, trasportadora, msgs, descuentoGnral, wavDescription, wavAddress, wavPhone, wavUbication, porc_percepcion, ncredito, totalop));
}
this.pagoncredito = new ArrayList();
//DataSet dsLiqpagoInfo = Liquidations_Hdr.getpagoncreditoliqui(this._noOrderUrl);
DataSet dsLiqpagoInfo = new DataSet();
dsLiqpagoInfo.Tables.Add(ds_venta.Tables[2].Copy());
if (dsLiqpagoInfo == null)
{
return;
}
foreach (DataRow dRowDtl in dsLiqpagoInfo.Tables[0].Rows)
{
string vncredito = dRowDtl["ncredito"].ToString();
decimal VtotalcreditoTotal = Convert.ToDecimal(dRowDtl["Total"].ToString());
DateTime vfecha = Convert.ToDateTime(dRowDtl["fecha"].ToString());
www.aquarella.com.pe.bll.Reports.LiqNcSubinforme objLiqpagoReport = new www.aquarella.com.pe.bll.Reports.LiqNcSubinforme("", vncredito, vfecha, VtotalcreditoTotal);
pagoncredito.Add(objLiqpagoReport);
}
this.pagoforma = new ArrayList();
//DataSet dsLiqpagoformaInfo = Liquidations_Hdr.getpagonformaliqui(this._noOrderUrl);
DataSet dsLiqpagoformaInfo = new DataSet();
dsLiqpagoformaInfo.Tables.Add(ds_venta.Tables[3].Copy());
if (dsLiqpagoInfo == null)
{
return;
}
foreach (DataRow dRowDtl in dsLiqpagoformaInfo.Tables[0].Rows)
{
string vpago = dRowDtl["pago"].ToString();
string vdocumento = dRowDtl["Documento"].ToString();
DateTime vfecha = Convert.ToDateTime(dRowDtl["fecha"].ToString());
Decimal vtotal = Convert.ToDecimal(dRowDtl["Total"].ToString());
www.aquarella.com.pe.bll.Reports.VentaPagoSubInforme objLiqpagoformaReport = new www.aquarella.com.pe.bll.Reports.VentaPagoSubInforme(vpago, vdocumento, vfecha, vtotal);
pagoforma.Add(objLiqpagoformaReport);
}
}
}
}
