using System;
using System.Collections;
using System.ComponentModel;
using System.Drawing;
using System.Windows.Forms;

namespace LLNet.DAL.Oracle.Reports
{
	public class Reports : LLNet.DAL.OracleDAL
	{
		#region CodeGen

		#region Declaraciones

		public System.Data.OracleClient.OracleDataAdapter adpUserInfo;
		private System.Data.OracleClient.OracleCommand oracleSelectCommand1;
		public System.Data.OracleClient.OracleDataAdapter adpExternalReps;
		private System.Data.OracleClient.OracleCommand oracleSelectCommand2;
		private System.Data.OracleClient.OracleCommand oracleInsertCommand1;
		private System.Data.OracleClient.OracleCommand oracleUpdateCommand1;
		private System.Data.OracleClient.OracleCommand oracleDeleteCommand1;
		public System.Data.OracleClient.OracleDataAdapter adpWmsDoctos;
		private System.Data.OracleClient.OracleCommand oracleSelectCommand3;
		private System.Data.OracleClient.OracleCommand oracleCommand1;
		private System.Data.OracleClient.OracleCommand oracleInsertCommand2;
		public System.Data.OracleClient.OracleDataAdapter adpRetDoctos;
		private System.Data.OracleClient.OracleCommand oracleCommand2;
		private System.Data.OracleClient.OracleCommand oracleCommand3;
		private System.Data.OracleClient.OracleCommand oracleCommand4;
    public System.Data.OracleClient.OracleDataAdapter odaRetFormatosReporte;
    private System.Data.OracleClient.OracleCommand oracleSelectCommand4;
    private System.Data.OracleClient.OracleCommand oracleCommand5;
    private System.Data.OracleClient.OracleCommand oracleCommand6;
    private System.Data.OracleClient.OracleCommand oracleCommand7;
        private System.Data.OracleClient.OracleCommand oracleSelectCommand5;
        private System.Data.OracleClient.OracleCommand oracleInsertCommand3;
        private System.Data.OracleClient.OracleCommand oracleUpdateCommand2;
        private System.Data.OracleClient.OracleCommand oracleDeleteCommand2;
        public System.Data.OracleClient.OracleDataAdapter adpVale;
        public System.Data.OracleClient.OracleDataAdapter adpPosDoctos;
        private System.Data.OracleClient.OracleCommand oracleCommand8;
        private System.Data.OracleClient.OracleCommand oracleCommand9;
        private System.Data.OracleClient.OracleCommand oracleCommand10;
        private System.Data.OracleClient.OracleCommand oracleSelectCommand6;
        private System.Data.OracleClient.OracleConnection oracleConnection1;
        public System.Data.OracleClient.OracleDataAdapter adpRepDocumentos;
        private System.Data.OracleClient.OracleCommand oracleSelectCommand7;
        public System.Data.OracleClient.OracleDataAdapter adpRepDetDocumentos;
        private System.Data.OracleClient.OracleCommand oracleSelectCommand8;
        public System.Data.OracleClient.OracleDataAdapter adpnotacredito;
        private System.Data.OracleClient.OracleConnection oracleConnection2;
        public System.Data.OracleClient.OracleDataAdapter adpDespachos;
        private System.Data.OracleClient.OracleCommand oracleCommand11;
		private System.ComponentModel.IContainer components = null;

		#endregion

		#region Constructor

		public Reports()
		{
			// This call is required by the Windows Form Designer.
			InitializeComponent();

			// TODO: Add any initialization after the InitializeComponent call
			LoadQueries();
			
		}

		#endregion

		#region Destructor

		/// <summary>
		/// Clean up any resources being used.
		/// </summary>
		protected override void Dispose( bool disposing )
		{
			if( disposing )
			{
				if (components != null) 
				{
					components.Dispose();
				}
			}
			base.Dispose( disposing );
		}

		#endregion

		#region Designer generated code
		/// <summary>
		/// Required method for Designer support - do not modify
		/// the contents of this method with the code editor.
		/// </summary>
		private void InitializeComponent()
		{
            System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(Reports));
            this.adpUserInfo = new System.Data.OracleClient.OracleDataAdapter();
            this.oracleSelectCommand1 = new System.Data.OracleClient.OracleCommand();
            this.adpExternalReps = new System.Data.OracleClient.OracleDataAdapter();
            this.oracleDeleteCommand1 = new System.Data.OracleClient.OracleCommand();
            this.oracleInsertCommand1 = new System.Data.OracleClient.OracleCommand();
            this.oracleSelectCommand2 = new System.Data.OracleClient.OracleCommand();
            this.oracleUpdateCommand1 = new System.Data.OracleClient.OracleCommand();
            this.adpWmsDoctos = new System.Data.OracleClient.OracleDataAdapter();
            this.oracleInsertCommand2 = new System.Data.OracleClient.OracleCommand();
            this.oracleSelectCommand3 = new System.Data.OracleClient.OracleCommand();
            this.oracleCommand1 = new System.Data.OracleClient.OracleCommand();
            this.adpRetDoctos = new System.Data.OracleClient.OracleDataAdapter();
            this.oracleCommand2 = new System.Data.OracleClient.OracleCommand();
            this.oracleCommand3 = new System.Data.OracleClient.OracleCommand();
            this.oracleCommand4 = new System.Data.OracleClient.OracleCommand();
            this.odaRetFormatosReporte = new System.Data.OracleClient.OracleDataAdapter();
            this.oracleCommand5 = new System.Data.OracleClient.OracleCommand();
            this.oracleCommand6 = new System.Data.OracleClient.OracleCommand();
            this.oracleSelectCommand4 = new System.Data.OracleClient.OracleCommand();
            this.oracleCommand7 = new System.Data.OracleClient.OracleCommand();
            this.oracleSelectCommand5 = new System.Data.OracleClient.OracleCommand();
            this.oracleInsertCommand3 = new System.Data.OracleClient.OracleCommand();
            this.oracleUpdateCommand2 = new System.Data.OracleClient.OracleCommand();
            this.oracleDeleteCommand2 = new System.Data.OracleClient.OracleCommand();
            this.adpVale = new System.Data.OracleClient.OracleDataAdapter();
            this.adpPosDoctos = new System.Data.OracleClient.OracleDataAdapter();
            this.oracleCommand8 = new System.Data.OracleClient.OracleCommand();
            this.oracleCommand9 = new System.Data.OracleClient.OracleCommand();
            this.oracleCommand10 = new System.Data.OracleClient.OracleCommand();
            this.oracleSelectCommand6 = new System.Data.OracleClient.OracleCommand();
            this.oracleConnection1 = new System.Data.OracleClient.OracleConnection();
            this.adpRepDocumentos = new System.Data.OracleClient.OracleDataAdapter();
            this.oracleSelectCommand7 = new System.Data.OracleClient.OracleCommand();
            this.adpRepDetDocumentos = new System.Data.OracleClient.OracleDataAdapter();
            this.oracleSelectCommand8 = new System.Data.OracleClient.OracleCommand();
            this.oracleConnection2 = new System.Data.OracleClient.OracleConnection();
            this.adpnotacredito = new System.Data.OracleClient.OracleDataAdapter();
            this.adpDespachos = new System.Data.OracleClient.OracleDataAdapter();
            this.oracleCommand11 = new System.Data.OracleClient.OracleCommand();
            this.SuspendLayout();
            // 
            // cnn
            // 
            this.cnn.ConnectionString = "user id=metro;data source=oradb;password=metro";
            // 
            // adpUserInfo
            // 
            this.adpUserInfo.SelectCommand = this.oracleSelectCommand1;
            this.adpUserInfo.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
            new System.Data.Common.DataTableMapping("Table", "WMS_USUARIOS", new System.Data.Common.DataColumnMapping[] {
                        new System.Data.Common.DataColumnMapping("USUARIO", "USUARIO"),
                        new System.Data.Common.DataColumnMapping("NOMBRES", "NOMBRES"),
                        new System.Data.Common.DataColumnMapping("APELLIDOS", "APELLIDOS"),
                        new System.Data.Common.DataColumnMapping("TODAY", "TODAY")})});
            // 
            // oracleSelectCommand1
            // 
            this.oracleSelectCommand1.CommandText = "SELECT USUARIO, NOMBRES, APELLIDOS, TO_CHAR(SYSDATE, \'DD/MM/YYYY HH:MI\') AS TODAY" +
                " FROM WMS_USUARIOS U";
            this.oracleSelectCommand1.Connection = this.cnn;
            // 
            // adpExternalReps
            // 
            this.adpExternalReps.DeleteCommand = this.oracleDeleteCommand1;
            this.adpExternalReps.InsertCommand = this.oracleInsertCommand1;
            this.adpExternalReps.SelectCommand = this.oracleSelectCommand2;
            this.adpExternalReps.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
            new System.Data.Common.DataTableMapping("Table", "REP_BASEDOCTOS", new System.Data.Common.DataColumnMapping[] {
                        new System.Data.Common.DataColumnMapping("IDREPORTE", "IDREPORTE"),
                        new System.Data.Common.DataColumnMapping("CODIGO", "CODIGO"),
                        new System.Data.Common.DataColumnMapping("TIPO_REPORTE", "TIPO_REPORTE"),
                        new System.Data.Common.DataColumnMapping("DESCRIPCION", "DESCRIPCION"),
                        new System.Data.Common.DataColumnMapping("PREIMPRIMIR", "PREIMPRIMIR"),
                        new System.Data.Common.DataColumnMapping("SISTEMA", "SISTEMA"),
                        new System.Data.Common.DataColumnMapping("MODULO", "MODULO")})});
            this.adpExternalReps.UpdateCommand = this.oracleUpdateCommand1;
            // 
            // oracleDeleteCommand1
            // 
            this.oracleDeleteCommand1.CommandText = "DELETE FROM REP_BASEDOCTOS WHERE (IDREPORTE = :Original_IDREPORTE)";
            this.oracleDeleteCommand1.Connection = this.cnn;
            this.oracleDeleteCommand1.Parameters.AddRange(new System.Data.OracleClient.OracleParameter[] {
            new System.Data.OracleClient.OracleParameter(":Original_IDREPORTE", System.Data.OracleClient.OracleType.Number, 0, System.Data.ParameterDirection.Input, false, ((byte)(38)), ((byte)(0)), "IDREPORTE", System.Data.DataRowVersion.Original, null)});
            // 
            // oracleInsertCommand1
            // 
            this.oracleInsertCommand1.CommandText = resources.GetString("oracleInsertCommand1.CommandText");
            this.oracleInsertCommand1.Connection = this.cnn;
            this.oracleInsertCommand1.Parameters.AddRange(new System.Data.OracleClient.OracleParameter[] {
            new System.Data.OracleClient.OracleParameter(":IDREPORTE", System.Data.OracleClient.OracleType.Number, 0, System.Data.ParameterDirection.Input, false, ((byte)(38)), ((byte)(0)), "IDREPORTE", System.Data.DataRowVersion.Current, null),
            new System.Data.OracleClient.OracleParameter(":CODIGO", System.Data.OracleClient.OracleType.VarChar, 32, "CODIGO"),
            new System.Data.OracleClient.OracleParameter(":NOMBRE", System.Data.OracleClient.OracleType.VarChar, 80, "NOMBRE"),
            new System.Data.OracleClient.OracleParameter(":TIPO_REPORTE", System.Data.OracleClient.OracleType.VarChar, 20, "TIPO_REPORTE"),
            new System.Data.OracleClient.OracleParameter(":DESCRIPCION", System.Data.OracleClient.OracleType.VarChar, 255, "DESCRIPCION"),
            new System.Data.OracleClient.OracleParameter(":IDREFERENCIA", System.Data.OracleClient.OracleType.Number, 0, System.Data.ParameterDirection.Input, false, ((byte)(38)), ((byte)(0)), "IDREFERENCIA", System.Data.DataRowVersion.Current, null),
            new System.Data.OracleClient.OracleParameter(":PREIMPRIMIR", System.Data.OracleClient.OracleType.VarChar, 1, "PREIMPRIMIR"),
            new System.Data.OracleClient.OracleParameter(":SISTEMA", System.Data.OracleClient.OracleType.VarChar, 1, "SISTEMA"),
            new System.Data.OracleClient.OracleParameter(":MODULO", System.Data.OracleClient.OracleType.VarChar, 3, "MODULO")});
            // 
            // oracleSelectCommand2
            // 
            this.oracleSelectCommand2.CommandText = "SELECT IDREPORTE, CODIGO, NOMBRE, TIPO_REPORTE, DESCRIPCION, IDREFERENCIA, PREIMP" +
                "RIMIR, SISTEMA, MODULO FROM REP_BASEDOCTOS WHERE (1 = 1)";
            this.oracleSelectCommand2.Connection = this.cnn;
            // 
            // oracleUpdateCommand1
            // 
            this.oracleUpdateCommand1.CommandText = resources.GetString("oracleUpdateCommand1.CommandText");
            this.oracleUpdateCommand1.Connection = this.cnn;
            this.oracleUpdateCommand1.Parameters.AddRange(new System.Data.OracleClient.OracleParameter[] {
            new System.Data.OracleClient.OracleParameter(":CODIGO", System.Data.OracleClient.OracleType.VarChar, 32, "CODIGO"),
            new System.Data.OracleClient.OracleParameter(":NOMBRE", System.Data.OracleClient.OracleType.VarChar, 80, "NOMBRE"),
            new System.Data.OracleClient.OracleParameter(":TIPO_REPORTE", System.Data.OracleClient.OracleType.VarChar, 20, "TIPO_REPORTE"),
            new System.Data.OracleClient.OracleParameter(":DESCRIPCION", System.Data.OracleClient.OracleType.VarChar, 255, "DESCRIPCION"),
            new System.Data.OracleClient.OracleParameter(":IDREFERENCIA", System.Data.OracleClient.OracleType.Number, 0, System.Data.ParameterDirection.Input, false, ((byte)(38)), ((byte)(0)), "IDREFERENCIA", System.Data.DataRowVersion.Current, null),
            new System.Data.OracleClient.OracleParameter(":PREIMPRIMIR", System.Data.OracleClient.OracleType.VarChar, 1, "PREIMPRIMIR"),
            new System.Data.OracleClient.OracleParameter(":SISTEMA", System.Data.OracleClient.OracleType.VarChar, 1, "SISTEMA"),
            new System.Data.OracleClient.OracleParameter(":MODULO", System.Data.OracleClient.OracleType.VarChar, 3, "MODULO"),
            new System.Data.OracleClient.OracleParameter(":Original_IDREPORTE", System.Data.OracleClient.OracleType.Number, 0, System.Data.ParameterDirection.Input, false, ((byte)(38)), ((byte)(0)), "IDREPORTE", System.Data.DataRowVersion.Original, null)});
            // 
            // adpWmsDoctos
            // 
            this.adpWmsDoctos.InsertCommand = this.oracleInsertCommand2;
            this.adpWmsDoctos.SelectCommand = this.oracleSelectCommand3;
            this.adpWmsDoctos.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
            new System.Data.Common.DataTableMapping("Table", "WMS_V_WMSDOCTOS", new System.Data.Common.DataColumnMapping[] {
                        new System.Data.Common.DataColumnMapping("CODIGO", "CODIGO"),
                        new System.Data.Common.DataColumnMapping("ICONO", "ICONO"),
                        new System.Data.Common.DataColumnMapping("NOMBRE", "NOMBRE"),
                        new System.Data.Common.DataColumnMapping("DESCRIPCION", "DESCRIPCION"),
                        new System.Data.Common.DataColumnMapping("MENU", "MENU"),
                        new System.Data.Common.DataColumnMapping("NO_COPIAS", "NO_COPIAS"),
                        new System.Data.Common.DataColumnMapping("FORMATO", "FORMATO"),
                        new System.Data.Common.DataColumnMapping("TIPO", "TIPO"),
                        new System.Data.Common.DataColumnMapping("IMPRESORA", "IMPRESORA"),
                        new System.Data.Common.DataColumnMapping("PREIMPRESION", "PREIMPRESION"),
                        new System.Data.Common.DataColumnMapping("RV_DOMAIN", "RV_DOMAIN")})});
            this.adpWmsDoctos.UpdateCommand = this.oracleCommand1;
            // 
            // oracleInsertCommand2
            // 
            this.oracleInsertCommand2.CommandText = resources.GetString("oracleInsertCommand2.CommandText");
            this.oracleInsertCommand2.Connection = this.cnn;
            this.oracleInsertCommand2.Parameters.AddRange(new System.Data.OracleClient.OracleParameter[] {
            new System.Data.OracleClient.OracleParameter(":CODIGO", System.Data.OracleClient.OracleType.VarChar, 30, "CODIGO"),
            new System.Data.OracleClient.OracleParameter(":ICONO", System.Data.OracleClient.OracleType.VarChar, 20, "ICONO"),
            new System.Data.OracleClient.OracleParameter(":NOMBRE", System.Data.OracleClient.OracleType.VarChar, 100, "NOMBRE"),
            new System.Data.OracleClient.OracleParameter(":NO_COPIAS", System.Data.OracleClient.OracleType.Number, 0, System.Data.ParameterDirection.Input, false, ((byte)(38)), ((byte)(0)), "NO_COPIAS", System.Data.DataRowVersion.Current, null),
            new System.Data.OracleClient.OracleParameter(":MENU", System.Data.OracleClient.OracleType.Number, 0, System.Data.ParameterDirection.Input, false, ((byte)(38)), ((byte)(0)), "MENU", System.Data.DataRowVersion.Current, null),
            new System.Data.OracleClient.OracleParameter(":FORMATO", System.Data.OracleClient.OracleType.Number, 0, System.Data.ParameterDirection.Input, false, ((byte)(38)), ((byte)(0)), "FORMATO", System.Data.DataRowVersion.Current, null),
            new System.Data.OracleClient.OracleParameter(":DESCRIPCION", System.Data.OracleClient.OracleType.VarChar, 500, "DESCRIPCION"),
            new System.Data.OracleClient.OracleParameter(":TIPO", System.Data.OracleClient.OracleType.VarChar, 100, "TIPO"),
            new System.Data.OracleClient.OracleParameter(":PREIMPRESION", System.Data.OracleClient.OracleType.VarChar, 100, "PREIMPRESION"),
            new System.Data.OracleClient.OracleParameter("RV_DOMAIN", System.Data.OracleClient.OracleType.VarChar, 100, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "RV_DOMAIN", System.Data.DataRowVersion.Original, null)});
            // 
            // oracleSelectCommand3
            // 
            this.oracleSelectCommand3.CommandText = "SELECT CODIGO, ICONO, NOMBRE, DESCRIPCION, MENU, NO_COPIAS, FORMATO, TIPO, IMPRES" +
                "ORA, PREIMPRESION FROM WMS_V_WMSDOCTOS WHERE 1 = 1";
            this.oracleSelectCommand3.Connection = this.cnn;
            // 
            // oracleCommand1
            // 
            this.oracleCommand1.CommandText = resources.GetString("oracleCommand1.CommandText");
            this.oracleCommand1.Connection = this.cnn;
            this.oracleCommand1.Parameters.AddRange(new System.Data.OracleClient.OracleParameter[] {
            new System.Data.OracleClient.OracleParameter(":CODIGO", System.Data.OracleClient.OracleType.VarChar, 20, "CODIGO"),
            new System.Data.OracleClient.OracleParameter(":ICONO", System.Data.OracleClient.OracleType.VarChar, 20, "ICONO"),
            new System.Data.OracleClient.OracleParameter(":NOMBRE", System.Data.OracleClient.OracleType.VarChar, 100, "NOMBRE"),
            new System.Data.OracleClient.OracleParameter(":NO_COPIAS", System.Data.OracleClient.OracleType.Number, 0, System.Data.ParameterDirection.Input, false, ((byte)(38)), ((byte)(0)), "NO_COPIAS", System.Data.DataRowVersion.Current, null),
            new System.Data.OracleClient.OracleParameter(":MENU", System.Data.OracleClient.OracleType.Number, 0, System.Data.ParameterDirection.Input, false, ((byte)(38)), ((byte)(0)), "MENU", System.Data.DataRowVersion.Current, null),
            new System.Data.OracleClient.OracleParameter(":FORMATO", System.Data.OracleClient.OracleType.Number, 0, System.Data.ParameterDirection.Input, false, ((byte)(38)), ((byte)(0)), "FORMATO", System.Data.DataRowVersion.Current, null),
            new System.Data.OracleClient.OracleParameter(":DESCRIPCION", System.Data.OracleClient.OracleType.VarChar, 500, "DESCRIPCION"),
            new System.Data.OracleClient.OracleParameter(":TIPO", System.Data.OracleClient.OracleType.VarChar, 100, "TIPO"),
            new System.Data.OracleClient.OracleParameter(":PREIMPRESION", System.Data.OracleClient.OracleType.VarChar, 100, "PREIMPRESION"),
            new System.Data.OracleClient.OracleParameter(":ORIGINAL_CODIGO", System.Data.OracleClient.OracleType.VarChar, 20, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "CODIGO", System.Data.DataRowVersion.Original, null),
            new System.Data.OracleClient.OracleParameter(":IMPRESORA", System.Data.OracleClient.OracleType.VarChar, 100, "IMPRESORA")});
            // 
            // adpRetDoctos
            // 
            this.adpRetDoctos.InsertCommand = this.oracleCommand2;
            this.adpRetDoctos.SelectCommand = this.oracleCommand3;
            this.adpRetDoctos.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
            new System.Data.Common.DataTableMapping("Table", "WMS_V_RETDOCTOS", new System.Data.Common.DataColumnMapping[] {
                        new System.Data.Common.DataColumnMapping("CODIGO", "CODIGO"),
                        new System.Data.Common.DataColumnMapping("ICONO", "ICONO"),
                        new System.Data.Common.DataColumnMapping("NOMBRE", "NOMBRE"),
                        new System.Data.Common.DataColumnMapping("DESCRIPCION", "DESCRIPCION"),
                        new System.Data.Common.DataColumnMapping("MENU", "MENU"),
                        new System.Data.Common.DataColumnMapping("NO_COPIAS", "NO_COPIAS"),
                        new System.Data.Common.DataColumnMapping("FORMATO", "FORMATO"),
                        new System.Data.Common.DataColumnMapping("TIPO", "TIPO"),
                        new System.Data.Common.DataColumnMapping("IMPRESORA", "IMPRESORA"),
                        new System.Data.Common.DataColumnMapping("PREIMPRESION", "PREIMPRESION"),
                        new System.Data.Common.DataColumnMapping("RV_DOMAIN", "RV_DOMAIN")})});
            this.adpRetDoctos.UpdateCommand = this.oracleCommand4;
            // 
            // oracleCommand2
            // 
            this.oracleCommand2.CommandText = resources.GetString("oracleCommand2.CommandText");
            this.oracleCommand2.Connection = this.cnn;
            this.oracleCommand2.Parameters.AddRange(new System.Data.OracleClient.OracleParameter[] {
            new System.Data.OracleClient.OracleParameter(":CODIGO", System.Data.OracleClient.OracleType.VarChar, 30, "CODIGO"),
            new System.Data.OracleClient.OracleParameter(":ICONO", System.Data.OracleClient.OracleType.VarChar, 20, "ICONO"),
            new System.Data.OracleClient.OracleParameter(":NOMBRE", System.Data.OracleClient.OracleType.VarChar, 100, "NOMBRE"),
            new System.Data.OracleClient.OracleParameter(":NO_COPIAS", System.Data.OracleClient.OracleType.Number, 0, System.Data.ParameterDirection.Input, false, ((byte)(38)), ((byte)(0)), "NO_COPIAS", System.Data.DataRowVersion.Current, null),
            new System.Data.OracleClient.OracleParameter(":MENU", System.Data.OracleClient.OracleType.Number, 0, System.Data.ParameterDirection.Input, false, ((byte)(38)), ((byte)(0)), "MENU", System.Data.DataRowVersion.Current, null),
            new System.Data.OracleClient.OracleParameter(":FORMATO", System.Data.OracleClient.OracleType.Number, 0, System.Data.ParameterDirection.Input, false, ((byte)(38)), ((byte)(0)), "FORMATO", System.Data.DataRowVersion.Current, null),
            new System.Data.OracleClient.OracleParameter(":DESCRIPCION", System.Data.OracleClient.OracleType.VarChar, 500, "DESCRIPCION"),
            new System.Data.OracleClient.OracleParameter(":TIPO", System.Data.OracleClient.OracleType.VarChar, 100, "TIPO"),
            new System.Data.OracleClient.OracleParameter(":PREIMPRESION", System.Data.OracleClient.OracleType.VarChar, 100, "PREIMPRESION"),
            new System.Data.OracleClient.OracleParameter("RV_DOMAIN", System.Data.OracleClient.OracleType.VarChar, 100, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "RV_DOMAIN", System.Data.DataRowVersion.Original, null)});
            // 
            // oracleCommand3
            // 
            this.oracleCommand3.CommandText = "SELECT CODIGO, ICONO, NOMBRE, DESCRIPCION, MENU, NO_COPIAS, FORMATO, TIPO, IMPRES" +
                "ORA, PREIMPRESION FROM WMS_V_RETDOCTOS WHERE 1 = 1";
            this.oracleCommand3.Connection = this.cnn;
            // 
            // oracleCommand4
            // 
            this.oracleCommand4.CommandText = resources.GetString("oracleCommand4.CommandText");
            this.oracleCommand4.Connection = this.cnn;
            this.oracleCommand4.Parameters.AddRange(new System.Data.OracleClient.OracleParameter[] {
            new System.Data.OracleClient.OracleParameter(":CODIGO", System.Data.OracleClient.OracleType.VarChar, 20, "CODIGO"),
            new System.Data.OracleClient.OracleParameter(":ICONO", System.Data.OracleClient.OracleType.VarChar, 20, "ICONO"),
            new System.Data.OracleClient.OracleParameter(":NOMBRE", System.Data.OracleClient.OracleType.VarChar, 100, "NOMBRE"),
            new System.Data.OracleClient.OracleParameter(":NO_COPIAS", System.Data.OracleClient.OracleType.Number, 0, System.Data.ParameterDirection.Input, false, ((byte)(38)), ((byte)(0)), "NO_COPIAS", System.Data.DataRowVersion.Current, null),
            new System.Data.OracleClient.OracleParameter(":MENU", System.Data.OracleClient.OracleType.Number, 0, System.Data.ParameterDirection.Input, false, ((byte)(38)), ((byte)(0)), "MENU", System.Data.DataRowVersion.Current, null),
            new System.Data.OracleClient.OracleParameter(":FORMATO", System.Data.OracleClient.OracleType.Number, 0, System.Data.ParameterDirection.Input, false, ((byte)(38)), ((byte)(0)), "FORMATO", System.Data.DataRowVersion.Current, null),
            new System.Data.OracleClient.OracleParameter(":DESCRIPCION", System.Data.OracleClient.OracleType.VarChar, 500, "DESCRIPCION"),
            new System.Data.OracleClient.OracleParameter(":TIPO", System.Data.OracleClient.OracleType.VarChar, 100, "TIPO"),
            new System.Data.OracleClient.OracleParameter(":PREIMPRESION", System.Data.OracleClient.OracleType.VarChar, 100, "PREIMPRESION"),
            new System.Data.OracleClient.OracleParameter(":ORIGINAL_CODIGO", System.Data.OracleClient.OracleType.VarChar, 20, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "CODIGO", System.Data.DataRowVersion.Original, null)});
            // 
            // odaRetFormatosReporte
            // 
            this.odaRetFormatosReporte.DeleteCommand = this.oracleCommand5;
            this.odaRetFormatosReporte.InsertCommand = this.oracleCommand6;
            this.odaRetFormatosReporte.SelectCommand = this.oracleSelectCommand4;
            this.odaRetFormatosReporte.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
            new System.Data.Common.DataTableMapping("Table", "REP_V_RET_FORMATOS_REPORTE", new System.Data.Common.DataColumnMapping[] {
                        new System.Data.Common.DataColumnMapping("REPORTE", "REPORTE"),
                        new System.Data.Common.DataColumnMapping("IDREPORTE", "IDREPORTE"),
                        new System.Data.Common.DataColumnMapping("CODIGO", "CODIGO"),
                        new System.Data.Common.DataColumnMapping("NOMBRE", "NOMBRE"),
                        new System.Data.Common.DataColumnMapping("DESCRIPCION", "DESCRIPCION")})});
            this.odaRetFormatosReporte.UpdateCommand = this.oracleCommand7;
            // 
            // oracleCommand5
            // 
            this.oracleCommand5.CommandText = "DELETE FROM REP_FORMATOS_REPORTE WHERE (REPORTE = :REPORTE) AND (IDREPORTE = :IDR" +
                "EPORTE)";
            this.oracleCommand5.Connection = this.cnn;
            this.oracleCommand5.Parameters.AddRange(new System.Data.OracleClient.OracleParameter[] {
            new System.Data.OracleClient.OracleParameter(":REPORTE", System.Data.OracleClient.OracleType.VarChar, 32, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "REPORTE", System.Data.DataRowVersion.Original, null),
            new System.Data.OracleClient.OracleParameter(":IDREPORTE", System.Data.OracleClient.OracleType.Number, 0, System.Data.ParameterDirection.Input, false, ((byte)(10)), ((byte)(0)), "IDREPORTE", System.Data.DataRowVersion.Original, null)});
            // 
            // oracleCommand6
            // 
            this.oracleCommand6.CommandText = "INSERT INTO REP_FORMATOS_REPORTE (REPORTE, IDREPORTE) VALUES (:REPORTE, :IDREPORT" +
                "E)";
            this.oracleCommand6.Connection = this.cnn;
            this.oracleCommand6.Parameters.AddRange(new System.Data.OracleClient.OracleParameter[] {
            new System.Data.OracleClient.OracleParameter(":REPORTE", System.Data.OracleClient.OracleType.VarChar, 32, "REPORTE"),
            new System.Data.OracleClient.OracleParameter(":IDREPORTE", System.Data.OracleClient.OracleType.Number, 0, System.Data.ParameterDirection.Input, false, ((byte)(10)), ((byte)(0)), "IDREPORTE", System.Data.DataRowVersion.Current, null)});
            // 
            // oracleSelectCommand4
            // 
            this.oracleSelectCommand4.CommandText = "SELECT REPORTE, IDREPORTE, CODIGO, NOMBRE, DESCRIPCION FROM REP_V_RET_FORMATOS_RE" +
                "PORTE WHERE (1 = 1)";
            this.oracleSelectCommand4.Connection = this.cnn;
            // 
            // oracleCommand7
            // 
            this.oracleCommand7.CommandText = "UPDATE REP_FORMATOS_REPORTE SET IDREPORTE = :IDREPORTE WHERE (REPORTE = :Original" +
                "_REPORTE) AND (IDREPORTE = :Original_IDREPORTE)";
            this.oracleCommand7.Connection = this.cnn;
            this.oracleCommand7.Parameters.AddRange(new System.Data.OracleClient.OracleParameter[] {
            new System.Data.OracleClient.OracleParameter(":IDREPORTE", System.Data.OracleClient.OracleType.Number, 0, System.Data.ParameterDirection.Input, false, ((byte)(10)), ((byte)(0)), "IDREPORTE", System.Data.DataRowVersion.Current, null),
            new System.Data.OracleClient.OracleParameter(":Original_REPORTE", System.Data.OracleClient.OracleType.VarChar, 32, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "REPORTE", System.Data.DataRowVersion.Original, null),
            new System.Data.OracleClient.OracleParameter(":Original_IDREPORTE", System.Data.OracleClient.OracleType.Number, 0, System.Data.ParameterDirection.Input, false, ((byte)(10)), ((byte)(0)), "IDREPORTE", System.Data.DataRowVersion.Original, null)});
            // 
            // oracleSelectCommand5
            // 
            this.oracleSelectCommand5.CommandText = "select *\r\nfrom doc_vales\r\nwhere 1 = 1";
            this.oracleSelectCommand5.Connection = this.cnn;
            // 
            // oracleInsertCommand3
            // 
            this.oracleInsertCommand3.CommandText = resources.GetString("oracleInsertCommand3.CommandText");
            this.oracleInsertCommand3.Connection = this.cnn;
            this.oracleInsertCommand3.Parameters.AddRange(new System.Data.OracleClient.OracleParameter[] {
            new System.Data.OracleClient.OracleParameter("VALE", System.Data.OracleClient.OracleType.Number, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "VALE", System.Data.DataRowVersion.Current, null),
            new System.Data.OracleClient.OracleParameter("ESTADO", System.Data.OracleClient.OracleType.VarChar, 0, "ESTADO"),
            new System.Data.OracleClient.OracleParameter("TIPO", System.Data.OracleClient.OracleType.VarChar, 0, "TIPO"),
            new System.Data.OracleClient.OracleParameter("SOCIO", System.Data.OracleClient.OracleType.Number, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "SOCIO", System.Data.DataRowVersion.Current, null),
            new System.Data.OracleClient.OracleParameter("MONTO", System.Data.OracleClient.OracleType.Number, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "MONTO", System.Data.DataRowVersion.Current, null),
            new System.Data.OracleClient.OracleParameter("VENCE_EL", System.Data.OracleClient.OracleType.DateTime, 0, "VENCE_EL"),
            new System.Data.OracleClient.OracleParameter("CREADO_POR", System.Data.OracleClient.OracleType.VarChar, 0, "CREADO_POR"),
            new System.Data.OracleClient.OracleParameter("CREADO_EL", System.Data.OracleClient.OracleType.DateTime, 0, "CREADO_EL"),
            new System.Data.OracleClient.OracleParameter("MODIFICADO_POR", System.Data.OracleClient.OracleType.VarChar, 0, "MODIFICADO_POR"),
            new System.Data.OracleClient.OracleParameter("MODIFICADO_EL", System.Data.OracleClient.OracleType.DateTime, 0, "MODIFICADO_EL"),
            new System.Data.OracleClient.OracleParameter("MODIFICACIONES", System.Data.OracleClient.OracleType.Number, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "MODIFICACIONES", System.Data.DataRowVersion.Current, null),
            new System.Data.OracleClient.OracleParameter("JORNADA", System.Data.OracleClient.OracleType.Number, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "JORNADA", System.Data.DataRowVersion.Current, null),
            new System.Data.OracleClient.OracleParameter("VALE_PADRE", System.Data.OracleClient.OracleType.Number, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "VALE_PADRE", System.Data.DataRowVersion.Current, null),
            new System.Data.OracleClient.OracleParameter("OBSERVACIONES", System.Data.OracleClient.OracleType.VarChar, 0, "OBSERVACIONES"),
            new System.Data.OracleClient.OracleParameter("AUTORIZADO_POR", System.Data.OracleClient.OracleType.VarChar, 0, "AUTORIZADO_POR"),
            new System.Data.OracleClient.OracleParameter("FACTURA_COBRO", System.Data.OracleClient.OracleType.Number, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "FACTURA_COBRO", System.Data.DataRowVersion.Current, null),
            new System.Data.OracleClient.OracleParameter("FACTURA_PAGO", System.Data.OracleClient.OracleType.Number, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "FACTURA_PAGO", System.Data.DataRowVersion.Current, null),
            new System.Data.OracleClient.OracleParameter("DEVOLUCION", System.Data.OracleClient.OracleType.Number, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "DEVOLUCION", System.Data.DataRowVersion.Current, null),
            new System.Data.OracleClient.OracleParameter("SOCIO2", System.Data.OracleClient.OracleType.Number, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "SOCIO2", System.Data.DataRowVersion.Current, null),
            new System.Data.OracleClient.OracleParameter("MOTIVO", System.Data.OracleClient.OracleType.Number, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "MOTIVO", System.Data.DataRowVersion.Current, null),
            new System.Data.OracleClient.OracleParameter("CANJEADO_X_EFECTIVO", System.Data.OracleClient.OracleType.VarChar, 0, "CANJEADO_X_EFECTIVO"),
            new System.Data.OracleClient.OracleParameter("A_NOMBRE_DE", System.Data.OracleClient.OracleType.VarChar, 0, "A_NOMBRE_DE"),
            new System.Data.OracleClient.OracleParameter("DE_PARTE_DE", System.Data.OracleClient.OracleType.VarChar, 0, "DE_PARTE_DE"),
            new System.Data.OracleClient.OracleParameter("BODEGA", System.Data.OracleClient.OracleType.Number, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "BODEGA", System.Data.DataRowVersion.Current, null)});
            // 
            // oracleUpdateCommand2
            // 
            this.oracleUpdateCommand2.CommandText = resources.GetString("oracleUpdateCommand2.CommandText");
            this.oracleUpdateCommand2.Connection = this.cnn;
            this.oracleUpdateCommand2.Parameters.AddRange(new System.Data.OracleClient.OracleParameter[] {
            new System.Data.OracleClient.OracleParameter("VALE", System.Data.OracleClient.OracleType.Number, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "VALE", System.Data.DataRowVersion.Current, null),
            new System.Data.OracleClient.OracleParameter("ESTADO", System.Data.OracleClient.OracleType.VarChar, 0, "ESTADO"),
            new System.Data.OracleClient.OracleParameter("TIPO", System.Data.OracleClient.OracleType.VarChar, 0, "TIPO"),
            new System.Data.OracleClient.OracleParameter("SOCIO", System.Data.OracleClient.OracleType.Number, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "SOCIO", System.Data.DataRowVersion.Current, null),
            new System.Data.OracleClient.OracleParameter("MONTO", System.Data.OracleClient.OracleType.Number, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "MONTO", System.Data.DataRowVersion.Current, null),
            new System.Data.OracleClient.OracleParameter("VENCE_EL", System.Data.OracleClient.OracleType.DateTime, 0, "VENCE_EL"),
            new System.Data.OracleClient.OracleParameter("CREADO_POR", System.Data.OracleClient.OracleType.VarChar, 0, "CREADO_POR"),
            new System.Data.OracleClient.OracleParameter("CREADO_EL", System.Data.OracleClient.OracleType.DateTime, 0, "CREADO_EL"),
            new System.Data.OracleClient.OracleParameter("MODIFICADO_POR", System.Data.OracleClient.OracleType.VarChar, 0, "MODIFICADO_POR"),
            new System.Data.OracleClient.OracleParameter("MODIFICADO_EL", System.Data.OracleClient.OracleType.DateTime, 0, "MODIFICADO_EL"),
            new System.Data.OracleClient.OracleParameter("MODIFICACIONES", System.Data.OracleClient.OracleType.Number, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "MODIFICACIONES", System.Data.DataRowVersion.Current, null),
            new System.Data.OracleClient.OracleParameter("JORNADA", System.Data.OracleClient.OracleType.Number, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "JORNADA", System.Data.DataRowVersion.Current, null),
            new System.Data.OracleClient.OracleParameter("VALE_PADRE", System.Data.OracleClient.OracleType.Number, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "VALE_PADRE", System.Data.DataRowVersion.Current, null),
            new System.Data.OracleClient.OracleParameter("OBSERVACIONES", System.Data.OracleClient.OracleType.VarChar, 0, "OBSERVACIONES"),
            new System.Data.OracleClient.OracleParameter("AUTORIZADO_POR", System.Data.OracleClient.OracleType.VarChar, 0, "AUTORIZADO_POR"),
            new System.Data.OracleClient.OracleParameter("FACTURA_COBRO", System.Data.OracleClient.OracleType.Number, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "FACTURA_COBRO", System.Data.DataRowVersion.Current, null),
            new System.Data.OracleClient.OracleParameter("FACTURA_PAGO", System.Data.OracleClient.OracleType.Number, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "FACTURA_PAGO", System.Data.DataRowVersion.Current, null),
            new System.Data.OracleClient.OracleParameter("DEVOLUCION", System.Data.OracleClient.OracleType.Number, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "DEVOLUCION", System.Data.DataRowVersion.Current, null),
            new System.Data.OracleClient.OracleParameter("SOCIO2", System.Data.OracleClient.OracleType.Number, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "SOCIO2", System.Data.DataRowVersion.Current, null),
            new System.Data.OracleClient.OracleParameter("MOTIVO", System.Data.OracleClient.OracleType.Number, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "MOTIVO", System.Data.DataRowVersion.Current, null),
            new System.Data.OracleClient.OracleParameter("CANJEADO_X_EFECTIVO", System.Data.OracleClient.OracleType.VarChar, 0, "CANJEADO_X_EFECTIVO"),
            new System.Data.OracleClient.OracleParameter("A_NOMBRE_DE", System.Data.OracleClient.OracleType.VarChar, 0, "A_NOMBRE_DE"),
            new System.Data.OracleClient.OracleParameter("DE_PARTE_DE", System.Data.OracleClient.OracleType.VarChar, 0, "DE_PARTE_DE"),
            new System.Data.OracleClient.OracleParameter("BODEGA", System.Data.OracleClient.OracleType.Number, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "BODEGA", System.Data.DataRowVersion.Current, null),
            new System.Data.OracleClient.OracleParameter("Original_VALE", System.Data.OracleClient.OracleType.Number, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "VALE", System.Data.DataRowVersion.Original, null)});
            // 
            // oracleDeleteCommand2
            // 
            this.oracleDeleteCommand2.CommandText = "DELETE FROM \"DOC_VALES\" WHERE ((\"VALE\" = :Original_VALE))";
            this.oracleDeleteCommand2.Connection = this.cnn;
            this.oracleDeleteCommand2.Parameters.AddRange(new System.Data.OracleClient.OracleParameter[] {
            new System.Data.OracleClient.OracleParameter("Original_VALE", System.Data.OracleClient.OracleType.Number, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "VALE", System.Data.DataRowVersion.Original, null)});
            // 
            // adpVale
            // 
            this.adpVale.DeleteCommand = this.oracleDeleteCommand2;
            this.adpVale.InsertCommand = this.oracleInsertCommand3;
            this.adpVale.SelectCommand = this.oracleSelectCommand5;
            this.adpVale.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
            new System.Data.Common.DataTableMapping("Table", "DOC_VALES", new System.Data.Common.DataColumnMapping[] {
                        new System.Data.Common.DataColumnMapping("VALE", "VALE"),
                        new System.Data.Common.DataColumnMapping("ESTADO", "ESTADO"),
                        new System.Data.Common.DataColumnMapping("TIPO", "TIPO"),
                        new System.Data.Common.DataColumnMapping("SOCIO", "SOCIO"),
                        new System.Data.Common.DataColumnMapping("MONTO", "MONTO"),
                        new System.Data.Common.DataColumnMapping("VENCE_EL", "VENCE_EL"),
                        new System.Data.Common.DataColumnMapping("CREADO_POR", "CREADO_POR"),
                        new System.Data.Common.DataColumnMapping("CREADO_EL", "CREADO_EL"),
                        new System.Data.Common.DataColumnMapping("MODIFICADO_POR", "MODIFICADO_POR"),
                        new System.Data.Common.DataColumnMapping("MODIFICADO_EL", "MODIFICADO_EL"),
                        new System.Data.Common.DataColumnMapping("MODIFICACIONES", "MODIFICACIONES"),
                        new System.Data.Common.DataColumnMapping("JORNADA", "JORNADA"),
                        new System.Data.Common.DataColumnMapping("VALE_PADRE", "VALE_PADRE"),
                        new System.Data.Common.DataColumnMapping("OBSERVACIONES", "OBSERVACIONES"),
                        new System.Data.Common.DataColumnMapping("AUTORIZADO_POR", "AUTORIZADO_POR"),
                        new System.Data.Common.DataColumnMapping("FACTURA_COBRO", "FACTURA_COBRO"),
                        new System.Data.Common.DataColumnMapping("FACTURA_PAGO", "FACTURA_PAGO"),
                        new System.Data.Common.DataColumnMapping("DEVOLUCION", "DEVOLUCION"),
                        new System.Data.Common.DataColumnMapping("SOCIO2", "SOCIO2"),
                        new System.Data.Common.DataColumnMapping("MOTIVO", "MOTIVO"),
                        new System.Data.Common.DataColumnMapping("CANJEADO_X_EFECTIVO", "CANJEADO_X_EFECTIVO"),
                        new System.Data.Common.DataColumnMapping("A_NOMBRE_DE", "A_NOMBRE_DE"),
                        new System.Data.Common.DataColumnMapping("DE_PARTE_DE", "DE_PARTE_DE"),
                        new System.Data.Common.DataColumnMapping("BODEGA", "BODEGA")})});
            this.adpVale.UpdateCommand = this.oracleUpdateCommand2;
            // 
            // adpPosDoctos
            // 
            this.adpPosDoctos.InsertCommand = this.oracleCommand8;
            this.adpPosDoctos.SelectCommand = this.oracleCommand9;
            this.adpPosDoctos.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
            new System.Data.Common.DataTableMapping("Table", "WMS_V_POSDOCTOS", new System.Data.Common.DataColumnMapping[] {
                        new System.Data.Common.DataColumnMapping("CODIGO", "CODIGO"),
                        new System.Data.Common.DataColumnMapping("ICONO", "ICONO"),
                        new System.Data.Common.DataColumnMapping("NOMBRE", "NOMBRE"),
                        new System.Data.Common.DataColumnMapping("DESCRIPCION", "DESCRIPCION"),
                        new System.Data.Common.DataColumnMapping("MENU", "MENU"),
                        new System.Data.Common.DataColumnMapping("NO_COPIAS", "NO_COPIAS"),
                        new System.Data.Common.DataColumnMapping("FORMATO", "FORMATO"),
                        new System.Data.Common.DataColumnMapping("TIPO", "TIPO"),
                        new System.Data.Common.DataColumnMapping("IMPRESORA", "IMPRESORA"),
                        new System.Data.Common.DataColumnMapping("PREIMPRESION", "PREIMPRESION"),
                        new System.Data.Common.DataColumnMapping("RV_DOMAIN", "RV_DOMAIN")})});
            this.adpPosDoctos.UpdateCommand = this.oracleCommand10;
            // 
            // oracleCommand8
            // 
            this.oracleCommand8.CommandText = resources.GetString("oracleCommand8.CommandText");
            this.oracleCommand8.Connection = this.cnn;
            this.oracleCommand8.Parameters.AddRange(new System.Data.OracleClient.OracleParameter[] {
            new System.Data.OracleClient.OracleParameter(":CODIGO", System.Data.OracleClient.OracleType.VarChar, 30, "CODIGO"),
            new System.Data.OracleClient.OracleParameter(":ICONO", System.Data.OracleClient.OracleType.VarChar, 20, "ICONO"),
            new System.Data.OracleClient.OracleParameter(":NOMBRE", System.Data.OracleClient.OracleType.VarChar, 100, "NOMBRE"),
            new System.Data.OracleClient.OracleParameter(":NO_COPIAS", System.Data.OracleClient.OracleType.Number, 0, System.Data.ParameterDirection.Input, false, ((byte)(38)), ((byte)(0)), "NO_COPIAS", System.Data.DataRowVersion.Current, null),
            new System.Data.OracleClient.OracleParameter(":MENU", System.Data.OracleClient.OracleType.Number, 0, System.Data.ParameterDirection.Input, false, ((byte)(38)), ((byte)(0)), "MENU", System.Data.DataRowVersion.Current, null),
            new System.Data.OracleClient.OracleParameter(":FORMATO", System.Data.OracleClient.OracleType.Number, 0, System.Data.ParameterDirection.Input, false, ((byte)(38)), ((byte)(0)), "FORMATO", System.Data.DataRowVersion.Current, null),
            new System.Data.OracleClient.OracleParameter(":DESCRIPCION", System.Data.OracleClient.OracleType.VarChar, 500, "DESCRIPCION"),
            new System.Data.OracleClient.OracleParameter(":TIPO", System.Data.OracleClient.OracleType.VarChar, 100, "TIPO"),
            new System.Data.OracleClient.OracleParameter(":PREIMPRESION", System.Data.OracleClient.OracleType.VarChar, 100, "PREIMPRESION"),
            new System.Data.OracleClient.OracleParameter("RV_DOMAIN", System.Data.OracleClient.OracleType.VarChar, 100, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "RV_DOMAIN", System.Data.DataRowVersion.Original, null)});
            // 
            // oracleCommand9
            // 
            this.oracleCommand9.CommandText = "SELECT CODIGO, ICONO, NOMBRE, DESCRIPCION, MENU, NO_COPIAS, FORMATO, TIPO, IMPRES" +
                "ORA, PREIMPRESION FROM WMS_V_WMSDOCTOS WHERE 1 = 1";
            this.oracleCommand9.Connection = this.cnn;
            // 
            // oracleCommand10
            // 
            this.oracleCommand10.CommandText = resources.GetString("oracleCommand10.CommandText");
            this.oracleCommand10.Connection = this.cnn;
            this.oracleCommand10.Parameters.AddRange(new System.Data.OracleClient.OracleParameter[] {
            new System.Data.OracleClient.OracleParameter(":CODIGO", System.Data.OracleClient.OracleType.VarChar, 20, "CODIGO"),
            new System.Data.OracleClient.OracleParameter(":ICONO", System.Data.OracleClient.OracleType.VarChar, 20, "ICONO"),
            new System.Data.OracleClient.OracleParameter(":NOMBRE", System.Data.OracleClient.OracleType.VarChar, 100, "NOMBRE"),
            new System.Data.OracleClient.OracleParameter(":NO_COPIAS", System.Data.OracleClient.OracleType.Number, 22, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "NO_COPIAS", System.Data.DataRowVersion.Current, null),
            new System.Data.OracleClient.OracleParameter(":MENU", System.Data.OracleClient.OracleType.Number, 22, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "MENU", System.Data.DataRowVersion.Current, null),
            new System.Data.OracleClient.OracleParameter(":FORMATO", System.Data.OracleClient.OracleType.Number, 22, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "FORMATO", System.Data.DataRowVersion.Current, null),
            new System.Data.OracleClient.OracleParameter(":IMPRESORA", System.Data.OracleClient.OracleType.VarChar, 100, "IMPRESORA"),
            new System.Data.OracleClient.OracleParameter(":DESCRIPCION", System.Data.OracleClient.OracleType.VarChar, 500, "DESCRIPCION"),
            new System.Data.OracleClient.OracleParameter(":TIPO", System.Data.OracleClient.OracleType.VarChar, 100, "TIPO"),
            new System.Data.OracleClient.OracleParameter(":PREIMPRESION", System.Data.OracleClient.OracleType.VarChar, 100, "PREIMPRESION"),
            new System.Data.OracleClient.OracleParameter(":ORIGINAL_CODIGO", System.Data.OracleClient.OracleType.VarChar, 20, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "CODIGO", System.Data.DataRowVersion.Original, null)});
            // 
            // oracleSelectCommand6
            // 
            this.oracleSelectCommand6.CommandText = "SELECT   *\r\nFROM         TDA_V_REP_DOCUMENTOS";
            this.oracleSelectCommand6.Connection = this.oracleConnection1;
            // 
            // oracleConnection1
            // 
            this.oracleConnection1.ConnectionString = "Data Source=SERVER310G;Persist Security Info=True;User ID=LOGISTIKA710;Password=L" +
                "OGISTIKA710";
            // 
            // adpRepDocumentos
            // 
            this.adpRepDocumentos.SelectCommand = this.oracleSelectCommand6;
            this.adpRepDocumentos.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
            new System.Data.Common.DataTableMapping("Table", "TDA_V_REP_DOCUMENTOS", new System.Data.Common.DataColumnMapping[] {
                        new System.Data.Common.DataColumnMapping("DOCUMENTO", "DOCUMENTO"),
                        new System.Data.Common.DataColumnMapping("SOCIO", "SOCIO"),
                        new System.Data.Common.DataColumnMapping("SOCIO_ALTERNO", "SOCIO_ALTERNO"),
                        new System.Data.Common.DataColumnMapping("NOMBRE", "NOMBRE"),
                        new System.Data.Common.DataColumnMapping("NIT", "NIT"),
                        new System.Data.Common.DataColumnMapping("TOTAL_PRODUCTOS", "TOTAL_PRODUCTOS"),
                        new System.Data.Common.DataColumnMapping("TOTAL_DESCUENTO", "TOTAL_DESCUENTO"),
                        new System.Data.Common.DataColumnMapping("TOTAL_SIN_DESC", "TOTAL_SIN_DESC"),
                        new System.Data.Common.DataColumnMapping("DEVOLUCIONES", "DEVOLUCIONES"),
                        new System.Data.Common.DataColumnMapping("CANJES", "CANJES"),
                        new System.Data.Common.DataColumnMapping("TOTAL", "TOTAL"),
                        new System.Data.Common.DataColumnMapping("DESCRIPCION", "DESCRIPCION"),
                        new System.Data.Common.DataColumnMapping("TIENDA", "TIENDA"),
                        new System.Data.Common.DataColumnMapping("DIRECCION", "DIRECCION"),
                        new System.Data.Common.DataColumnMapping("TELEFONOS", "TELEFONOS"),
                        new System.Data.Common.DataColumnMapping("EMAIL", "EMAIL"),
                        new System.Data.Common.DataColumnMapping("HORARIO", "HORARIO"),
                        new System.Data.Common.DataColumnMapping("DIRECCION_SOCIO", "DIRECCION_SOCIO"),
                        new System.Data.Common.DataColumnMapping("TELEFONO_SOCIO", "TELEFONO_SOCIO"),
                        new System.Data.Common.DataColumnMapping("EMAIL_SOCIO", "EMAIL_SOCIO"),
                        new System.Data.Common.DataColumnMapping("CONTACTO", "CONTACTO"),
                        new System.Data.Common.DataColumnMapping("SOCIO_PEDIDO", "SOCIO_PEDIDO"),
                        new System.Data.Common.DataColumnMapping("VALIDEZ_COTIZACION", "VALIDEZ_COTIZACION"),
                        new System.Data.Common.DataColumnMapping("TOTAL_LETRAS", "TOTAL_LETRAS"),
                        new System.Data.Common.DataColumnMapping("NOMBRES", "NOMBRES"),
                        new System.Data.Common.DataColumnMapping("APELLIDOS", "APELLIDOS"),
                        new System.Data.Common.DataColumnMapping("AVALISTA", "AVALISTA"),
                        new System.Data.Common.DataColumnMapping("DIRECCIONA", "DIRECCIONA"),
                        new System.Data.Common.DataColumnMapping("SERIE", "SERIE"),
                        new System.Data.Common.DataColumnMapping("NO_DOCUMENTO", "NO_DOCUMENTO"),
                        new System.Data.Common.DataColumnMapping("CAJA", "CAJA"),
                        new System.Data.Common.DataColumnMapping("JORNADA", "JORNADA"),
                        new System.Data.Common.DataColumnMapping("DIA", "DIA"),
                        new System.Data.Common.DataColumnMapping("MES", "MES"),
                        new System.Data.Common.DataColumnMapping("ANIO", "ANIO"),
                        new System.Data.Common.DataColumnMapping("IMPUESTO", "IMPUESTO"),
                        new System.Data.Common.DataColumnMapping("TOTAL_SIMP", "TOTAL_SIMP"),
                        new System.Data.Common.DataColumnMapping("FECHA_EMISION", "FECHA_EMISION"),
                        new System.Data.Common.DataColumnMapping("FECHA_VENCIMIENTO", "FECHA_VENCIMIENTO"),
                        new System.Data.Common.DataColumnMapping("CUSTOM0", "CUSTOM0"),
                        new System.Data.Common.DataColumnMapping("CUSTOM1", "CUSTOM1"),
                        new System.Data.Common.DataColumnMapping("CUSTOM2", "CUSTOM2"),
                        new System.Data.Common.DataColumnMapping("CUSTOM3", "CUSTOM3"),
                        new System.Data.Common.DataColumnMapping("CUSTOM4", "CUSTOM4"),
                        new System.Data.Common.DataColumnMapping("CUSTOM5", "CUSTOM5"),
                        new System.Data.Common.DataColumnMapping("CUSTOM6", "CUSTOM6"),
                        new System.Data.Common.DataColumnMapping("CUSTOM7", "CUSTOM7"),
                        new System.Data.Common.DataColumnMapping("CUSTOM8", "CUSTOM8"),
                        new System.Data.Common.DataColumnMapping("CUSTOM9", "CUSTOM9"),
                        new System.Data.Common.DataColumnMapping("OBSERVACIONES", "OBSERVACIONES")})});
            // 
            // oracleSelectCommand7
            // 
            this.oracleSelectCommand7.CommandText = "select *\r\nfrom tda_v_rep_det_documentos";
            this.oracleSelectCommand7.Connection = this.cnn;
            // 
            // adpRepDetDocumentos
            // 
            this.adpRepDetDocumentos.SelectCommand = this.oracleSelectCommand7;
            this.adpRepDetDocumentos.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
            new System.Data.Common.DataTableMapping("Table", "TDA_V_REP_DET_DOCUMENTOS", new System.Data.Common.DataColumnMapping[] {
                        new System.Data.Common.DataColumnMapping("DOCUMENTO", "DOCUMENTO"),
                        new System.Data.Common.DataColumnMapping("NO_DOCUMENTO", "NO_DOCUMENTO"),
                        new System.Data.Common.DataColumnMapping("SERIE", "SERIE"),
                        new System.Data.Common.DataColumnMapping("LINEA", "LINEA"),
                        new System.Data.Common.DataColumnMapping("SKU", "SKU"),
                        new System.Data.Common.DataColumnMapping("SKU_ALTERNO", "SKU_ALTERNO"),
                        new System.Data.Common.DataColumnMapping("DESCRIPCION", "DESCRIPCION"),
                        new System.Data.Common.DataColumnMapping("DESC_UINV", "DESC_UINV"),
                        new System.Data.Common.DataColumnMapping("SITUACION_SKU", "SITUACION_SKU"),
                        new System.Data.Common.DataColumnMapping("TIPO_DESPACHO", "TIPO_DESPACHO"),
                        new System.Data.Common.DataColumnMapping("CANTIDAD", "CANTIDAD"),
                        new System.Data.Common.DataColumnMapping("PRECIO_ACTUAL", "PRECIO_ACTUAL"),
                        new System.Data.Common.DataColumnMapping("PRECIO_CIMP", "PRECIO_CIMP"),
                        new System.Data.Common.DataColumnMapping("IMPUESTO_SDESC", "IMPUESTO_SDESC"),
                        new System.Data.Common.DataColumnMapping("PRECIO_UNITARIO", "PRECIO_UNITARIO"),
                        new System.Data.Common.DataColumnMapping("COSTO_PROMEDIO", "COSTO_PROMEDIO"),
                        new System.Data.Common.DataColumnMapping("PCT_DESCUENTO", "PCT_DESCUENTO"),
                        new System.Data.Common.DataColumnMapping("DESCUENTO_CIMP", "DESCUENTO_CIMP"),
                        new System.Data.Common.DataColumnMapping("DESCUENTO", "DESCUENTO"),
                        new System.Data.Common.DataColumnMapping("PCT_IMPUESTO", "PCT_IMPUESTO"),
                        new System.Data.Common.DataColumnMapping("IMPUESTO", "IMPUESTO"),
                        new System.Data.Common.DataColumnMapping("PRECIO_SIMP", "PRECIO_SIMP"),
                        new System.Data.Common.DataColumnMapping("PRECIO_CLIENTE", "PRECIO_CLIENTE"),
                        new System.Data.Common.DataColumnMapping("TOTAL_SIMP", "TOTAL_SIMP"),
                        new System.Data.Common.DataColumnMapping("TOTAL_LINEA", "TOTAL_LINEA"),
                        new System.Data.Common.DataColumnMapping("MOTIVO_ANULACION", "MOTIVO_ANULACION"),
                        new System.Data.Common.DataColumnMapping("USUARIO_ANULO", "USUARIO_ANULO"),
                        new System.Data.Common.DataColumnMapping("FECHA_ANULACION", "FECHA_ANULACION"),
                        new System.Data.Common.DataColumnMapping("CREADO_EL", "CREADO_EL"),
                        new System.Data.Common.DataColumnMapping("DOCUMENTO_PADRE", "DOCUMENTO_PADRE"),
                        new System.Data.Common.DataColumnMapping("SITUACION", "SITUACION"),
                        new System.Data.Common.DataColumnMapping("PU", "PU"),
                        new System.Data.Common.DataColumnMapping("MANEJA_SERIES", "MANEJA_SERIES"),
                        new System.Data.Common.DataColumnMapping("MESES_GARANTIA", "MESES_GARANTIA"),
                        new System.Data.Common.DataColumnMapping("DESCRIPCION_LARGA", "DESCRIPCION_LARGA"),
                        new System.Data.Common.DataColumnMapping("MARCA", "MARCA"),
                        new System.Data.Common.DataColumnMapping("TASA", "TASA"),
                        new System.Data.Common.DataColumnMapping("FINANCIERA", "FINANCIERA"),
                        new System.Data.Common.DataColumnMapping("CUOTAS", "CUOTAS"),
                        new System.Data.Common.DataColumnMapping("ULTIMA_CUOTA", "ULTIMA_CUOTA"),
                        new System.Data.Common.DataColumnMapping("ENGANCHE", "ENGANCHE"),
                        new System.Data.Common.DataColumnMapping("CANTIDAD_PAGOS", "CANTIDAD_PAGOS"),
                        new System.Data.Common.DataColumnMapping("TOTAL_FINANCIADO", "TOTAL_FINANCIADO"),
                        new System.Data.Common.DataColumnMapping("TOTAL_PAGOS", "TOTAL_PAGOS"),
                        new System.Data.Common.DataColumnMapping("IMAGEN", "IMAGEN"),
                        new System.Data.Common.DataColumnMapping("REPROCESAR", "REPROCESAR"),
                        new System.Data.Common.DataColumnMapping("VALE", "VALE"),
                        new System.Data.Common.DataColumnMapping("DOCUMENTO_PADRE3", "DOCUMENTO_PADRE3"),
                        new System.Data.Common.DataColumnMapping("LINEA_PADRE3", "LINEA_PADRE3"),
                        new System.Data.Common.DataColumnMapping("PORCENTAJE1", "PORCENTAJE1"),
                        new System.Data.Common.DataColumnMapping("PORCENTAJE2", "PORCENTAJE2"),
                        new System.Data.Common.DataColumnMapping("PORCENTAJE3", "PORCENTAJE3"),
                        new System.Data.Common.DataColumnMapping("USUARIO", "USUARIO"),
                        new System.Data.Common.DataColumnMapping("USUARIO2", "USUARIO2"),
                        new System.Data.Common.DataColumnMapping("USUARIO3", "USUARIO3"),
                        new System.Data.Common.DataColumnMapping("NOMBRE_VENDEDOR1", "NOMBRE_VENDEDOR1"),
                        new System.Data.Common.DataColumnMapping("NOMBRE_VENDEDOR2", "NOMBRE_VENDEDOR2"),
                        new System.Data.Common.DataColumnMapping("NOMBRE_VENDEDOR3", "NOMBRE_VENDEDOR3"),
                        new System.Data.Common.DataColumnMapping("OBSERVACIONES", "OBSERVACIONES")})});
            // 
            // oracleSelectCommand8
            // 
            this.oracleSelectCommand8.CommandText = resources.GetString("oracleSelectCommand8.CommandText");
            this.oracleSelectCommand8.Connection = this.cnn;
            // 
            // oracleConnection2
            // 
            this.oracleConnection2.ConnectionString = "Data Source=xe;Persist Security Info=True;User ID=logistika700;Password=logistika" +
                "700";
            // 
            // adpnotacredito
            // 
            this.adpnotacredito.SelectCommand = this.oracleSelectCommand8;
            this.adpnotacredito.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
            new System.Data.Common.DataTableMapping("Table", "TDA_V_PREIMPRESO_NC", new System.Data.Common.DataColumnMapping[] {
                        new System.Data.Common.DataColumnMapping("DOCUMENTO", "DOCUMENTO"),
                        new System.Data.Common.DataColumnMapping("CLIENTE", "CLIENTE"),
                        new System.Data.Common.DataColumnMapping("NIT", "NIT"),
                        new System.Data.Common.DataColumnMapping("DIRECCION1", "DIRECCION1"),
                        new System.Data.Common.DataColumnMapping("TELEFONOS", "TELEFONOS"),
                        new System.Data.Common.DataColumnMapping("CAJERO", "CAJERO"),
                        new System.Data.Common.DataColumnMapping("NOTA_CREDITO", "NOTA_CREDITO"),
                        new System.Data.Common.DataColumnMapping("FECHA_EMISION", "FECHA_EMISION"),
                        new System.Data.Common.DataColumnMapping("SERIE", "SERIE"),
                        new System.Data.Common.DataColumnMapping("NO_DOCUMENTO", "NO_DOCUMENTO"),
                        new System.Data.Common.DataColumnMapping("TOTAL", "TOTAL"),
                        new System.Data.Common.DataColumnMapping("SALDO", "SALDO"),
                        new System.Data.Common.DataColumnMapping("FACTURA", "FACTURA"),
                        new System.Data.Common.DataColumnMapping("ABONO", "ABONO"),
                        new System.Data.Common.DataColumnMapping("MOTIVO", "MOTIVO")})});
            // 
            // adpDespachos
            // 
            this.adpDespachos.SelectCommand = this.oracleCommand11;
            this.adpDespachos.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
            new System.Data.Common.DataTableMapping("Table", "TDA_V_PREIMPRESO_NC", new System.Data.Common.DataColumnMapping[] {
                        new System.Data.Common.DataColumnMapping("DOCUMENTO", "DOCUMENTO"),
                        new System.Data.Common.DataColumnMapping("CLIENTE", "CLIENTE"),
                        new System.Data.Common.DataColumnMapping("NIT", "NIT"),
                        new System.Data.Common.DataColumnMapping("DIRECCION1", "DIRECCION1"),
                        new System.Data.Common.DataColumnMapping("TELEFONOS", "TELEFONOS"),
                        new System.Data.Common.DataColumnMapping("CAJERO", "CAJERO"),
                        new System.Data.Common.DataColumnMapping("NOTA_CREDITO", "NOTA_CREDITO"),
                        new System.Data.Common.DataColumnMapping("FECHA_EMISION", "FECHA_EMISION"),
                        new System.Data.Common.DataColumnMapping("SERIE", "SERIE"),
                        new System.Data.Common.DataColumnMapping("NO_DOCUMENTO", "NO_DOCUMENTO"),
                        new System.Data.Common.DataColumnMapping("TOTAL", "TOTAL"),
                        new System.Data.Common.DataColumnMapping("SALDO", "SALDO"),
                        new System.Data.Common.DataColumnMapping("FACTURA", "FACTURA"),
                        new System.Data.Common.DataColumnMapping("ABONO", "ABONO"),
                        new System.Data.Common.DataColumnMapping("MOTIVO", "MOTIVO")})});
            // 
            // oracleCommand11
            // 
            this.oracleCommand11.CommandText = resources.GetString("oracleCommand11.CommandText");
            this.oracleCommand11.Connection = this.cnn;
            // 
            // Reports
            // 
            this.Name = "Reports";
            this.ResumeLayout(false);

    }
		#endregion

		#endregion

		#region LoadQueries

		private void LoadQueries()
		{

            QueryMap.Add("dsArqueos.JORNADASE", @"select NVL(efectivomb,0) efectivomb, NVL(efectivoma,0) efectivoma,retirosmb,retirosma,total_retiros,tarjeta1,tarjeta2, tarjeta3,credicuotas,pagoscredito,
                NVL(RetirosMB,0)+NVL(tarjeta1,0)+NVL(tarjeta2,0)+NVL(tarjeta3,0)+total_giftcard + CREDIX + credicuotas Total_Usuario,
                NVL(efectivo,0)-NVL(devefectivo,0)-total_cajach+NVL(tarjetas,0)+total_giftcard+ TOTAL_BNSERVICIOS + TOTAL_RECARGAS + 
                NVL(CREDIXS,0) +  credicuotas  + pagoscredito + COLRECNIC - VUELTOFACTDOL total_sistema,
                ( NVL(RetirosMB,0) + NVL(tarjeta1,0) + NVL(tarjeta2,0) + NVL(tarjeta3,0) + NVL(CREDIX,0) + NVL(total_giftcard,0) - (NVL(efectivo,0) - NVL(devefectivo,0)
                - NVL(total_cajach,0) + NVL(tarjetas,0) + NVL(total_giftcard,0) + NVL(TOTAL_BNSERVICIOS,0) + NVL(TOTAL_RECARGAS,0) + NVL(CREDIXS,0) + NVL(COLRECNIC,0) + NVL(PAGOSCREDITO, 0) ) 
                + NVL(EFECTIVO_ENTREGADO,0) + VUELTOFACTDOL)Sobrante,                  
                NVL(RetirosMA,0) Total_UsuarioD,
                NVL(efectivoD,0) + DOLRECNIC total_sistemaD,
                NVL(RetirosMA,0) - (NVL(efectivoD,0) + DOLRECNIC) SOBRANTED,
                efectivo_entregado, total_cajach, total_giftcard,TOTAL_BNSERVICIOS, TOTAL_RECARGAS, CREDIX, CREDIXS, TOTAL_REC_NIC, TOTAL_WESTERN_UNION from (
                SELECT * FROM                 
                (
                select NVL(sum(total),0)EFECTIVOMB from wms_v_detalle_arqueos
                where arqueo = &&ARQUEO&& 
                AND MONEDA = WMS_F_MONEDA_BASE) A,                
                (select NVL(sum(total),0)EFECTIVOMA from wms_v_detalle_arqueos
                where arqueo = &&ARQUEO&& 
                AND MONEDA = WMS_F_MONEDA_ALTERNA )B,                
                (select NVL(sum(deposito*nvl(tasa_cambio,1)),0)RetirosMB from wms_retiros
                where jornada = &&JORNADA&& and moneda = wms_f_moneda_base and anulado_el is null
                )C,               
                (select NVL(sum(deposito),0)RetirosMA from wms_retiros
                where jornada = &&JORNADA&& AND MONEDA = WMS_F_MONEDA_ALTERNA and anulado_el is null)D,               
                (select NVL(sum(deposito*nvl(tasa_cambio,1)),0)Total_Retiros from wms_retiros
                where jornada = &&JORNADA&& and anulado_el is null)g,               
                (select monto tarjeta1 from RET_V_DETALLE_PAGOS_X_JORNADA where jornada = &&JORNADA&& and tipo_pago =
                (SELECT RV_LOW_VALUE FROM CG_REF_CODES WHERE RV_DOMAIN = 'TIPO PAGO CIERRE' AND RV_MPNC01
            ='1' AND RV_HIGH_VALUE = 1))h,                        
            (select monto tarjeta2 from RET_V_DETALLE_PAGOS_X_JORNADA where jornada = &&JORNADA&& and tipo_pago =
                (SELECT RV_LOW_VALUE FROM CG_REF_CODES WHERE RV_DOMAIN = 'TIPO PAGO CIERRE' AND RV_MPNC01
            ='2' AND RV_HIGH_VALUE = 1))i,           
            (select monto tarjeta3 from RET_V_DETALLE_PAGOS_X_JORNADA where jornada = &&JORNADA&& and tipo_pago =
                (SELECT RV_LOW_VALUE FROM CG_REF_CODES WHERE RV_DOMAIN = 'TIPO PAGO CIERRE' AND RV_MPNC01
            ='3' AND RV_HIGH_VALUE = 1))j,           
            (SELECT  nvl((DECODE (Cg_F_Parameter_Value ('MOJO'), 'MB', SUM(a.total), SUM((a.total / NVL (a.tasa_cambio_ma, 1))))  ),0)devefectivo
              FROM   WMS_DOCUMENTOS a, WMS_SOCIOS b
              WHERE  a.tipo_documento = 'D'
              AND    a.socio = b.socio(+)
              AND    a.jornada =&&JORNADA&&
              AND SUBTIPO_DOCUMENTO = 'D'
              AND    NVL (a.situacion, 1) <> 11)k,
            (SELECT SUM (a.valor) tarjetas FROM wms_pago_documentos a, wms_documentos b 
                        WHERE a.documento = b.documento AND b.jornada = &&JORNADA&& AND CAJA = &&CAJA&& AND a.tipo_pago = 1
                    AND NVL(SITUACION, 1) <> 11 AND WMS_F_FACTANUL(NVL(B.DOCUMENTO_PADRE, B.DOCUMENTO)) <> 0)l,
            (SELECT NVL(SUM(EFECTIVO),0) EFECTIVO FROM WMS_V_EFECTIVO_CAJA WHERE MONEDA = 1 and CAJA = &&CAJA&& AND JORNADA = &&JORNADA&& )m,
            (SELECT NVL(SUM(EFECTIVO),0) EFECTIVOD FROM WMS_V_EFECTIVO_CAJA WHERE MONEDA = 2 and CAJA = &&CAJA&& AND JORNADA = &&JORNADA&& )m1,
            (SELECT DECODE(SUM(EFECTIVO_ENTREGADO), NULL, 0, SUM(EFECTIVO_ENTREGADO)) EFECTIVO_ENTREGADO FROM WMS_CASHBACK WHERE JORNADA = &&JORNADA&& AND ANULADO_EL IS NULL)n,
            (SELECT NVL(SUM(MONTO), 0) TOTAL_CAJACH FROM WMS_V_CAJACHICA WHERE JORNADA = &&JORNADA&& ) o,
            (SELECT NVL(SUM(MONTO), 0) TOTAL_GIFTCARD FROM WMS_V_GIFTCARD WHERE JORNADA = &&JORNADA&& ) p,
            (SELECT NVL(SUM(MONTO), 0) TOTAL_BNSERVICIOS FROM WMS_V_BNSERVICIOS WHERE JORNADA = &&JORNADA&& ) q,
            (SELECT NVL(SUM(MONTO), 0) TOTAL_RECARGAS FROM WMS_V_RECARGAS2 WHERE JORNADA = &&JORNADA&& ) r,
            (select NVL(SUM(MONTO), 0) CREDIX from RET_V_DETALLE_PAGOS_X_JORNADA where jornada = &&JORNADA&& and tipo_pago =
                (SELECT RV_LOW_VALUE FROM CG_REF_CODES WHERE RV_DOMAIN = 'TIPO PAGO CIERRE' AND RV_MPNC01
            ='4' AND RV_HIGH_VALUE = 32))s,
            (SELECT NVL(SUM(NVL(MONTO, 0)),0) CREDIXS FROM WMS_V_CREDIX WHERE JORNADA = &&JORNADA&& ) u,
            (select WMS_F_DIFCOL_HABLAMAS( &&JORNADA&& ) COLRECNIC from dual ) v,
            (select wms_f_dol_hablamas( &&JORNADA&& ) DOLRECNIC from dual ) v1
            )t,
            (select NVL(SUM(MONTO), 0) credicuotas from RET_V_DETALLE_PAGOS_X_JORNADA where jornada = &&JORNADA&& and tipo_pago =
                (SELECT RV_LOW_VALUE FROM CG_REF_CODES WHERE RV_DOMAIN = 'TIPO PAGO CIERRE' AND RV_MPNC01
            ='4' AND RV_HIGH_VALUE = 34))u,
            (SELECT NVL(SUM(MONTO_CANCELADO),0)pagoscredito  FROM (select NVL(SUM(MONTO_CANCELADO),0)MONTO_CANCELADO from WMS_CREDITOEK_PAGOS WHERE JORNADA = &&JORNADA&&
            union all
            select NVL(SUM(MONTO_CANCELADO),0)MONTO_CANCELADO from WMS_INSTACREDIT_PAGOS WHERE JORNADA = &&JORNADA&&
            union all
            select nvl(sum(monto_cancelado),0) MONTO_CANCELADO froM wms_multicred_pagos where jornada = &&JORNADA&& ) )v,
            (SELECT NVL(SUM(MONTO), 0) TOTAL_REC_NIC FROM wms_v_RecargsNic WHERE JORNADA = &&JORNADA&& ) a1,
            (SELECT 0 TOTAL_WESTERN_UNION FROM DUAL ) b1,            
             (SELECT NVL(sum(nvl(vuelto ,0)),0) VUELTOFACTDOL FROM (SELECT a.documento, e.serie||' '||e.no_documento no_documento, b.socio_alterno, b.nombre, a.jornada,
                        ROUND(c.valor/ NVL (a.tasa_cambio_ma, 1),2) total, c.tasa_cambio tipo_cambio, c.VALOR_MONEDA totalDolar ,(c.PAGADO - c.VALOR) vuelto 
                        FROM   WMS_DOCUMENTOS a, WMS_SOCIOS b, wms_pago_documentos c, doc_abono_documentos d, wms_documentos e
                        WHERE  a.tipo_documento = 'R'
                        AND   A.DOCUMENTO = C.DOCUMENTO
                        AND   C.MONEDA = WMS_F_MONEDA_ALTERNA 
                        AND  C.TIPO_PAGO = '3'
                        AND    a.socio = b.socio(+)
                        AND    a.jornada IN ( &&JORNADA&& )
                        AND    NVL (a.situacion, 1) <> 11
                        and   d.recibo = a.documento
                        and   d.documento = e.documento
                        and   nvl(e.fecha_vencimiento,e.fecha_emision) =  nvl(e.fecha_emision, sysdate)) ) C1
            ");


            QueryMap.Add("dsArqueos.WMS_V_DATOS_TIENDA", @"SELECT * FROM WMS_V_DATOS_TIENDA");

            QueryMap.Add("MaxArqueo", @"
                SELECT MAX(ARQUEO) FROM WMS_ARQUEOS WHERE JORNADA =&&JORNADA&& AND ESTADO = 'C' ORDER BY ARQUEO DESC");

            QueryMap.Add("dsArqueos.WMS_DETALLE_ARQUEOS", @"
                SELECT * FROM WMS_V_DETALLE_ARQUEOS WHERE ARQUEO = &&ARQUEO&& ORDER BY MONEDA,SUBTIPO_PAGO");

            QueryMap.Add("dsArqueos.WMS_ARQUEOS", @"
                SELECT * FROM WMS_V_ARQUEOS WHERE ARQUEO = &&ARQUEO&&");

            QueryMap.Add("DsDocReports.DESCRIPCION_COMPLEMENTARIOS", @"
                SELECT tda_f_skus_complementarios(&&DOCUMENTO&&, &&SOCIO&&, '&&USUARIO&&') TEXTO
                  FROM dual
            ");

            QueryMap.Add("DsDocReports.TDA_DATOS_DOCCONS", @"
                SELECT *
                  FROM tda_datos_doccons
                 WHERE (serie = '&&SERIE&&') 
                   AND (no_documento = '&&NO_DOCUMENTO&&')
            ");

            QueryMap.Add("DsDocReports.TDA_DETALLE_PEDCONS", @"
                SELECT * 
                  FROM tda_detalle_pedcons
                 WHERE (serie = '&&SERIE&&') 
                   AND (no_documento = '&&NO_DOCUMENTO&&')
            ");

            string strCmd = "";
            strCmd = " SELECT  DOCUMENTO, CLIENTE, NIT, DIRECCION1, TELEFONOS, CAJERO, NOTA_CREDITO, FECHA_EMISION, SERIE, NO_DOCUMENTO, TOTAL, SALDO, FACTURA, ABONO, MOTIVO  FROM TDA_V_PREIMPRESO_NC WHERE (1=1) ";
            strCmd += Utils.QueryParams.PredefinedTags.RepToolbarTag;
            QueryMap.Add("dstdanotacred.TDA_V_PREIMPRESO_NC", strCmd);


            QueryMap.Add("DsDocReports.TDA_V_REP_DOCUMENTOS", @"
                SELECT *
                  FROM tda_v_rep_documentos
                 WHERE documento = &&DOCUMENTO&&
            ");

            QueryMap.Add("DsDocReports.TDA_V_REP_DET_DOCUMENTOS", @"
                SELECT *
                  FROM tda_v_rep_det_documentos
                 WHERE documento = &&DOCUMENTO&&
            ");

            QueryMap.Add("DsVale.DOC_VALES", @"
                select *
                from doc_vales
                where vale = &&VALE&&
            ");

            QueryMap.Add("DsVale.TDA_V_VALES", @"
                SELECT *
                FROM tda_v_vales
                WHERE vale = &&VALE&&
            ");

			QueryMap.Add("DsReports.WMS_USUARIOS","SELECT u.USUARIO, u.NOMBRES, u.APELLIDOS, to_char( SYSDATE, 'DD/MM/YYYY HH:MI') AS Today, sysdate General  FROM wms_usuarios u WHERE u.USUARIO = '&&USUARIO&&'");

			//-- Establece la lista reportes
			QueryMap.Add("DsRepBaseDoctos.REP_BASEDOCTOS",@"
				SELECT R.IDREPORTE, R.CODIGO, R.NOMBRE, R.TIPO_REPORTE, R.DESCRIPCION, R.IDREFERENCIA
					 , (SELECT CODIGO FROM REP_BASEDOCTOS WHERE IDREPORTE = R.IDREFERENCIA) REFERENCIA
                     , R.PREIMPRIMIR, R.SISTEMA, R.MODULO
                  FROM REP_BASEDOCTOS R
                 WHERE (1 = 1) "
				+ Utils.QueryParams.PredefinedTags.AllToolbarsTag);


			//-- Estab.lece la lista de valores de los reportes base
			QueryMap.Add("DsRepBaseDoctos.LOV_BASEDOCTOS",@"
				SELECT R.IDREPORTE, R.CODIGO, R.NOMBRE, R.TIPO_REPORTE, R.DESCRIPCION
					 , (SELECT CODIGO FROM REP_BASEDOCTOS WHERE IDREPORTE = R.IDREFERENCIA) REFERENCIA
				  FROM REP_BASEDOCTOS R 
				 WHERE (1 = 1) "
				+ Utils.QueryParams.PredefinedTags.AllToolbarsTag);
			//-- Establece los tipos de reportes base
			QueryMap.Add("DsRepBaseDoctos.TipoReportes",@"SELECT rv_low_value codigo, rv_meaning descripcion FROM cg_ref_codes WHERE RV_DOMAIN = 'TIPO REPORTES' AND RV_HIGH_VALUE = &&APP&& ");
			//-- Obtiene el siguiente número de reporte
			QueryMap.Add("NextReporte","SELECT rep_s_idreporte.nextval FROM dual");
			//-- Obtiene cuántas veces está repetido un código en la tabla de reportes
			QueryMap.Add("ReporteAlterno",@"SELECT COUNT(1) reportes FROM rep_basedoctos WHERE codigo = '&&CODIGO&&' AND idreporte <> &&IDREPORTE&&");
			//-- Obtiene el codigo del reporte enviado
			QueryMap.Add("CodigoReporte",@"SELECT codigo FROM rep_basedoctos WHERE idreporte = &&IDREPORTE&&");
			//-- Obtiene el tipo de reporte del codigo enviado
			QueryMap.Add("ReporteBase",@"SELECT tipo_reporte FROM rep_basedoctos WHERE idreporte = &&IDREPORTE&&");
			//-- Actualización de la impresora del documento enviado
			QueryMap.Add("UpdPrinterName", @"update cg_ref_codes set rv_mpcc01 = &&IMPRESORA&&, rv_mpcc03 = null where rv_domain = 'DOCUMENTOS WMS' and rv_low_value = &&CODIGO&& ");

			//-- Listado de documentos del Wms
			QueryMap.Add("DsWmsDoctos.WMS_V_WMSDOCTOS", @"
				SELECT CODIGO, ICONO, NOMBRE, DESCRIPCION, MENU, NO_COPIAS
                     , FORMATO, BASE_FORMATO, CODIGO_FORMATO, TIPO, IMPRESORA, PREIMPRESION,RV_DOMAIN
				  FROM WMS_V_WMSDOCTOS
                 WHERE ( 1 = 1 ) "
				+ Utils.QueryParams.PredefinedTags.AllToolbarsTag);

			//-- Listado de documentos del Ret
			QueryMap.Add("DsWmsDoctos.WMS_V_RETDOCTOS", @"
				SELECT CODIGO, ICONO, NOMBRE, DESCRIPCION, MENU, NO_COPIAS
                     , FORMATO, BASE_FORMATO, CODIGO_FORMATO, TIPO, IMPRESORA, PREIMPRESION,RV_DOMAIN
				  FROM WMS_V_RETDOCTOS
                 WHERE ( 1 = 1 ) "
				+ Utils.QueryParams.PredefinedTags.AllToolbarsTag);

            QueryMap.Add("DsWmsDoctos.WMS_V_POSDOCTOS", @"
				SELECT CODIGO, ICONO, NOMBRE, DESCRIPCION, MENU, NO_COPIAS
                     , FORMATO, BASE_FORMATO, CODIGO_FORMATO, TIPO, IMPRESORA, PREIMPRESION,RV_DOMAIN
				  FROM WMS_V_POSDOCTOS
                 WHERE ( 1 = 1 ) "
                + Utils.QueryParams.PredefinedTags.AllToolbarsTag);

			QueryMap.Add("DsRepBaseDoctos.WMS_V_POSDOCTOS", @"
				SELECT CODIGO, ICONO, NOMBRE, DESCRIPCION, MENU, NO_COPIAS
			    , FORMATO, BASE_FORMATO, CODIGO_FORMATO, TIPO, IMPRESORA, PREIMPRESION 
			   FROM WMS_V_POSDOCTOS
			  WHERE ( 1 = 1 ) "
			+ Utils.QueryParams.PredefinedTags.AllToolbarsTag);
			
			
			QueryMap.Add("CodigoRep","SELECT CODIGO FROM WMS_V_POSDOCTOS WHERE ( 1 = 1 ) AND idreporte = &&IDREP&&");


			QueryMap.Add("CodigoRandomRep","SELECT CG_P_RANDOM.STRING('U',5)Codigo from dual");

			QueryMap.Add("dsReportes.INDICADORES",@"
				SELECT ROUND(SUM(NVL(a.venta_bruta,0)),6) venta_bruta
				,      ROUND(MAX(NVL((
						SELECT SUM(CASE WHEN NVL(total,0) > 0 THEN 1 ELSE 0 END)
						FROM   cof_facturas 
						WHERE  tipo_documento = 'F' 
						AND    fecha BETWEEN TO_DATE('&&DESDE&&','DD/MM/YYYY')  
						AND    TO_DATE('&&HASTA&&','DD/MM/YYYY') 
						AND    bodega = &&BODEGA&& ),0) ),6) cnt_venta_bruta
				,      ROUND(SUM(NVL(a.impuesto,0)),6) impuesto
				,      SUM(CASE WHEN NVL(a.impuesto,0) > 0 THEN 1 ELSE 0 END) cnt_impuesto 
				,      ROUND(SUM(NVL(a.venta_neta,0)),6) venta_neta
				,      SUM(CASE WHEN NVL(a.venta_neta,0) > 0 THEN 1 ELSE 0 END) cnt_venta_neta 
				,      ROUND(SUM(NVL(a.descuento,0)),6) descuento  
				,      SUM(CASE WHEN NVL(a.descuento,0) > 0 THEN 1 ELSE 0 END) cnt_descuento 
				,      ROUND(MAX(NVL((
						SELECT SUM(NVL(total,0)) 
						FROM   cof_facturas_anuladas 
						WHERE  fecha BETWEEN TO_DATE('&&DESDE&&','DD/MM/YYYY') 
						AND    TO_DATE('&&HASTA&&','DD/MM/YYYY') 
						AND    bodega = &&BODEGA&& ),0) ),6) anulaciones  
				,      MAX(NVL(( 
						SELECT SUM(CASE WHEN NVL(total,0) > 0 THEN 1 ELSE 0 END) 
						FROM   cof_facturas_anuladas 
						WHERE  fecha BETWEEN TO_DATE('&&DESDE&&','DD/MM/YYYY')  
						AND    TO_DATE('&&HASTA&&','DD/MM/YYYY') 
						AND    bodega = &&BODEGA&& ),0) )  cnt_anulaciones 
				,      ROUND(SUM(NVL(( 
						SELECT SUM(NVL(ajustado,0)) 
						FROM   cof_conteos_wms 
						WHERE  fecha BETWEEN TO_DATE('&&DESDE&&','DD/MM/YYYY')  
						AND    TO_DATE('&&HASTA&&','DD/MM/YYYY') 
						AND    bodega = &&BODEGA&& ),0)),6) ajustes  
				,      MAX(NVL(( 
						SELECT SUM(CASE WHEN NVL(ajustado,0) > 0 THEN 1 ELSE 0 END) 
						FROM   cof_conteos_wms 
						WHERE  fecha BETWEEN TO_DATE('&&DESDE&&','DD/MM/YYYY') 
						AND    TO_DATE('&&HASTA&&','DD/MM/YYYY') 
						AND    bodega = &&BODEGA&& ),0) ) cnt_ajustes 
				FROM   cof_ventas a
				WHERE  fecha BETWEEN TO_DATE('&&DESDE&&','DD/MM/YYYY') 
				AND    TO_DATE('&&HASTA&&','DD/MM/YYYY') 
				AND    bodega = &&BODEGA&&	");

			QueryMap.Add("dsReportes.VENTA_X_CATEGORIA",@"
				select clasificacion_sku&&CLASIFICACION&& clasificacion
				,      SUM(decode(trim(nombre_dia),'LUNES',venta_neta,0)) lunes
				,      SUM(decode(trim(nombre_dia),'MARTES',venta_neta,0)) martes
				,      SUM(decode(trim(nombre_dia),'MIERCOLES',venta_neta,0)) miercoles
				,      SUM(decode(trim(nombre_dia),'JUEVES',venta_neta,0)) jueves
				,      SUM(decode(trim(nombre_dia),'VIERNES',venta_neta,0)) viernes
				,      SUM(decode(trim(nombre_dia),'SABADO',venta_neta,0)) sabado
				,      SUM(decode(trim(nombre_dia),'DOMINGO',venta_neta,0)) domingo
				,      SUM(venta_neta) venta_total
				from cubo_ventas
				where  fecha between to_date('&&DESDE&&','DD/MM/YYYY') and to_date('&&HASTA&&','DD/MM/YYYY')
				group by clasificacion_sku&&CLASIFICACION&&
			");

      // Formatos Reporte
      QueryMap.Add("DsRepBaseDoctos.REP_V_RET_FORMATOS_REPORTE",@"
        select reporte, idreporte, codigo, nombre, descripcion from rep_v_ret_formatos_reporte where reporte = '&&REPORTE&&'");
      QueryMap.Add("DsRepBaseDoctos.REP_V_RET_FORMATOS_REPORTE1",@"
        select reporte, idreporte from rep_v_ret_formatos_reporte where idreporte = '&&IDREPORTE&&'");

      QueryMap.Add ("ExecImpresionGarantias","BEGIN WMS_P_IMPRESION_GARANTIAS(&&DOCUMENTO&&); END;");

      QueryMap.Add("dsGarantias.TDA_V_IMPRESION_GARANTIAS", "SELECT * FROM TDA_V_IMPRESION_GARANTIAS WHERE (1=1) AND DOCUMENTO = &&DOCUMENTO&& AND SKU = &&SKU&&");

      QueryMap.Add("DsRepGarantia.TDA_V_IMPRESION_GARANTIAS", "SELECT * FROM TDA_V_IMPRESION_GARANTIAS WHERE (1=1) AND DOCUMENTO = &&DOCUMENTO&& AND SKU = &&SKU&&");

      QueryMap.Add("DsRepPreimpresos.TDA_V_REP_PREIMPRESOS", "SELECT * FROM TDA_V_REP_PREIMPRESOS WHERE (1=1) AND DOCUMENTO = &&DOCUMENTO&& ");

      QueryMap.Add("OrdenamientoDespacho", @"
        SELECT rv_meaning
        FROM   CG_REF_CODES
        WHERE  rv_domain = 'ORDENAMIENTO DESPACHO'
        AND    rv_low_value = NVL(cg_f_parameter_value('ORDD'),'1') ");

      QueryMap.Add("DsDespachos.RET_V_DESPACHOS", @"
        SELECT documento, no_documento, fecha_emision, tipo_documento, desc_tipo_documento,
               transaccion, tipo, iniciada_el, finalizada_el, sku, sku_alterno,
               descripcion, cantidad, bodega, desc_bodega, zona, desc_zona, ubicacion,
               ubicacion_logica, bodega_alterna, zona_alterna,NOMBRE,DIRECCION1,observaciones
        FROM   ret_v_despachos
        WHERE  documento = &&DOCUMENTO&& " + Utils.QueryParams.PredefinedTags.OrderByToolbarTag);


    }

		#endregion


}
}