コード例 #1
0
 /// <summary>
 /// Método necesario para admitir el Diseñador, no se puede modificar
 /// el contenido del método con el editor de código.
 /// </summary>
 private void InitializeComponent()
 {
     System.Configuration.AppSettingsReader configurationAppSettings = new System.Configuration.AppSettingsReader();
     this.oleDbDataAdapter1   = new System.Data.OleDb.OleDbDataAdapter();
     this.oleDbSelectCommand1 = new System.Data.OleDb.OleDbCommand();
     this.oleDbConnection1    = new System.Data.OleDb.OleDbConnection();
     this.oleDbDataAdapter2   = new System.Data.OleDb.OleDbDataAdapter();
     this.oleDbSelectCommand2 = new System.Data.OleDb.OleDbCommand();
     this.oleDbConnection2    = new System.Data.OleDb.OleDbConnection();
     this.datos_comprobante1  = new comp_cajas.datos_comprobante();
     this.oleDbDataAdapter3   = new System.Data.OleDb.OleDbDataAdapter();
     this.oleDbSelectCommand3 = new System.Data.OleDb.OleDbCommand();
     ((System.ComponentModel.ISupportInitialize)(this.datos_comprobante1)).BeginInit();
     //
     // oleDbDataAdapter1
     //
     this.oleDbDataAdapter1.SelectCommand = this.oleDbSelectCommand1;
     this.oleDbDataAdapter1.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
         new System.Data.Common.DataTableMapping("Table", "t_documento", new System.Data.Common.DataColumnMapping[] {
             new System.Data.Common.DataColumnMapping("NRO_DOCUMENTO", "NRO_DOCUMENTO"),
             new System.Data.Common.DataColumnMapping("FECHA_DOCUMENTO", "FECHA_DOCUMENTO"),
             new System.Data.Common.DataColumnMapping("NOMBRE_BANCO", "NOMBRE_BANCO"),
             new System.Data.Common.DataColumnMapping("NFOLIO", "NFOLIO"),
             new System.Data.Common.DataColumnMapping("TIPO_PAGO", "TIPO_PAGO"),
             new System.Data.Common.DataColumnMapping("MONTO_DOC", "MONTO_DOC"),
             new System.Data.Common.DataColumnMapping("DETALLES_COMPROMISO", "DETALLES_COMPROMISO"),
             new System.Data.Common.DataColumnMapping("TOTAL", "TOTAL")
         })
     });
     //
     // oleDbSelectCommand1
     //
     this.oleDbSelectCommand1.CommandText = "SELECT \'\' AS NRO_DOCUMENTO, \'\' AS FECHA_DOCUMENTO, \'\' AS NOMBRE_BANCO, \'\' AS NFOL" +
                                            "IO, \'\' AS TIPO_PAGO, \'\' AS MONTO_DOC, \'\' AS DETALLES_COMPROMISO, \'\' AS TOTAL, \'\'" +
                                            " AS TDOCUMENTO, \'\' AS pers_ncorr, \'\' AS INGR_FPAGO, \'\' AS OTRO, \'\' AS ingr_ncorr" +
                                            "elativo_caja";
     this.oleDbSelectCommand1.Connection = this.oleDbConnection1;
     //
     // oleDbConnection1
     //
     this.oleDbConnection1.ConnectionString = ((string)(configurationAppSettings.GetValue("cadenaConexion", typeof(string))));
     //
     // oleDbDataAdapter2
     //
     this.oleDbDataAdapter2.SelectCommand = this.oleDbSelectCommand2;
     this.oleDbDataAdapter2.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
         new System.Data.Common.DataTableMapping("Table", "t_alumno", new System.Data.Common.DataColumnMapping[] {
             new System.Data.Common.DataColumnMapping("CODIGO_ALUMNO", "CODIGO_ALUMNO"),
             new System.Data.Common.DataColumnMapping("NOMBRE_CARRERA", "NOMBRE_CARRERA"),
             new System.Data.Common.DataColumnMapping("OFERTA", "OFERTA"),
             new System.Data.Common.DataColumnMapping("NOMBRE_ALUMNO", "NOMBRE_ALUMNO"),
             new System.Data.Common.DataColumnMapping("NOMBRE_CODEUDOR", "NOMBRE_CODEUDOR"),
             new System.Data.Common.DataColumnMapping("RUT_CODEUDOR", "RUT_CODEUDOR")
         })
     });
     //
     // oleDbSelectCommand2
     //
     this.oleDbSelectCommand2.CommandText = "SELECT \'\' AS PERS_NCORR, \'\' AS CODIGO_ALUMNO, \'\' AS NOMBRE_CARRERA, \'\' AS OFERTA," +
                                            " \'\' AS NOMBRE_ALUMNO, \'\' AS RUT_ALUMNO, \'\' AS FECHA_DIA, \'\' AS NOMBRE_CODEUDOR, " +
                                            "\'\' AS RUT_CODEUDOR ";
     this.oleDbSelectCommand2.Connection = this.oleDbConnection2;
     //
     // oleDbConnection2
     //
     this.oleDbConnection2.ConnectionString = ((string)(configurationAppSettings.GetValue("cadenaConexion", typeof(string))));
     //
     // datos_comprobante1
     //
     this.datos_comprobante1.DataSetName = "datos_comprobante";
     this.datos_comprobante1.Locale      = new System.Globalization.CultureInfo("es-ES");
     this.datos_comprobante1.Namespace   = "http://www.tempuri.org/datos_comprobante.xsd";
     //
     // oleDbDataAdapter3
     //
     this.oleDbDataAdapter3.SelectCommand = this.oleDbSelectCommand3;
     this.oleDbDataAdapter3.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
         new System.Data.Common.DataTableMapping("Table", "t_compromisos", new System.Data.Common.DataColumnMapping[] {
             new System.Data.Common.DataColumnMapping("NRO_DOCUMENTO", "NRO_DOCUMENTO"),
             new System.Data.Common.DataColumnMapping("FECHA_VENCIMIENTO", "FECHA_VENCIMIENTO"),
             new System.Data.Common.DataColumnMapping("TIPO_COMPROMISO", "TIPO_COMPROMISO"),
             new System.Data.Common.DataColumnMapping("MONTO_ABONO", "MONTO_ABONO")
         })
     });
     //
     // oleDbSelectCommand3
     //
     this.oleDbSelectCommand3.CommandText = "SELECT \'\' AS NRO_DOCUMENTO, \'\' AS FECHA_VENCIMIENTO, \'\' AS TIPO_COMPROMISO, \'\' AS" +
                                            " MONTO_ABONO, \'\' AS TIPO_DETALLE ";
     this.oleDbSelectCommand3.Connection = this.oleDbConnection1;
     this.Load += new System.EventHandler(this.Page_Load);
     ((System.ComponentModel.ISupportInitialize)(this.datos_comprobante1)).EndInit();
 }
コード例 #2
0
ファイル: comp_cajas.aspx.cs プロジェクト: yesashii/upa
 /// <summary>
 /// M�todo necesario para admitir el Dise�ador, no se puede modificar
 /// el contenido del m�todo con el editor de c�digo.
 /// </summary>
 private void InitializeComponent()
 {
     System.Configuration.AppSettingsReader configurationAppSettings = new System.Configuration.AppSettingsReader();
     this.oleDbDataAdapter1 = new System.Data.OleDb.OleDbDataAdapter();
     this.oleDbSelectCommand1 = new System.Data.OleDb.OleDbCommand();
     this.oleDbConnection1 = new System.Data.OleDb.OleDbConnection();
     this.oleDbDataAdapter2 = new System.Data.OleDb.OleDbDataAdapter();
     this.oleDbSelectCommand2 = new System.Data.OleDb.OleDbCommand();
     this.oleDbConnection2 = new System.Data.OleDb.OleDbConnection();
     this.datos_comprobante1 = new comp_cajas.datos_comprobante();
     this.oleDbDataAdapter3 = new System.Data.OleDb.OleDbDataAdapter();
     this.oleDbSelectCommand3 = new System.Data.OleDb.OleDbCommand();
     ((System.ComponentModel.ISupportInitialize)(this.datos_comprobante1)).BeginInit();
     //
     // oleDbDataAdapter1
     //
     this.oleDbDataAdapter1.SelectCommand = this.oleDbSelectCommand1;
     this.oleDbDataAdapter1.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
                                                                                                 new System.Data.Common.DataTableMapping("Table", "t_documento", new System.Data.Common.DataColumnMapping[] {
                                                                                                                                                                                                                new System.Data.Common.DataColumnMapping("NRO_DOCUMENTO", "NRO_DOCUMENTO"),
                                                                                                                                                                                                                new System.Data.Common.DataColumnMapping("FECHA_DOCUMENTO", "FECHA_DOCUMENTO"),
                                                                                                                                                                                                                new System.Data.Common.DataColumnMapping("NOMBRE_BANCO", "NOMBRE_BANCO"),
                                                                                                                                                                                                                new System.Data.Common.DataColumnMapping("NFOLIO", "NFOLIO"),
                                                                                                                                                                                                                new System.Data.Common.DataColumnMapping("TIPO_PAGO", "TIPO_PAGO"),
                                                                                                                                                                                                                new System.Data.Common.DataColumnMapping("MONTO_DOC", "MONTO_DOC"),
                                                                                                                                                                                                                new System.Data.Common.DataColumnMapping("DETALLES_COMPROMISO", "DETALLES_COMPROMISO"),
                                                                                                                                                                                                                new System.Data.Common.DataColumnMapping("TOTAL", "TOTAL")})});
     //
     // oleDbSelectCommand1
     //
     this.oleDbSelectCommand1.CommandText = "SELECT \'\' AS NRO_DOCUMENTO, \'\' AS FECHA_DOCUMENTO, \'\' AS NOMBRE_BANCO, \'\' AS NFOL" +
         "IO, \'\' AS TIPO_PAGO, \'\' AS MONTO_DOC, \'\' AS DETALLES_COMPROMISO, \'\' AS TOTAL, \'\'" +
         " AS TDOCUMENTO, \'\' AS pers_ncorr, \'\' AS INGR_FPAGO, \'\' AS OTRO, \'\' AS ingr_ncorr" +
         "elativo_caja";
     this.oleDbSelectCommand1.Connection = this.oleDbConnection1;
     //
     // oleDbConnection1
     //
     this.oleDbConnection1.ConnectionString = ((string)(configurationAppSettings.GetValue("cadenaConexion", typeof(string))));
     //
     // oleDbDataAdapter2
     //
     this.oleDbDataAdapter2.SelectCommand = this.oleDbSelectCommand2;
     this.oleDbDataAdapter2.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
                                                                                                 new System.Data.Common.DataTableMapping("Table", "t_alumno", new System.Data.Common.DataColumnMapping[] {
                                                                                                                                                                                                             new System.Data.Common.DataColumnMapping("CODIGO_ALUMNO", "CODIGO_ALUMNO"),
                                                                                                                                                                                                             new System.Data.Common.DataColumnMapping("NOMBRE_CARRERA", "NOMBRE_CARRERA"),
                                                                                                                                                                                                             new System.Data.Common.DataColumnMapping("OFERTA", "OFERTA"),
                                                                                                                                                                                                             new System.Data.Common.DataColumnMapping("NOMBRE_ALUMNO", "NOMBRE_ALUMNO"),
                                                                                                                                                                                                             new System.Data.Common.DataColumnMapping("NOMBRE_CODEUDOR", "NOMBRE_CODEUDOR"),
                                                                                                                                                                                                             new System.Data.Common.DataColumnMapping("RUT_CODEUDOR", "RUT_CODEUDOR")})});
     //
     // oleDbSelectCommand2
     //
     this.oleDbSelectCommand2.CommandText = "SELECT \'\' AS PERS_NCORR, \'\' AS CODIGO_ALUMNO, \'\' AS NOMBRE_CARRERA, \'\' AS OFERTA," +
         " \'\' AS NOMBRE_ALUMNO, \'\' AS RUT_ALUMNO, \'\' AS FECHA_DIA, \'\' AS NOMBRE_CODEUDOR, " +
         "\'\' AS RUT_CODEUDOR ";
     this.oleDbSelectCommand2.Connection = this.oleDbConnection2;
     //
     // oleDbConnection2
     //
     this.oleDbConnection2.ConnectionString = ((string)(configurationAppSettings.GetValue("cadenaConexion", typeof(string))));
     //
     // datos_comprobante1
     //
     this.datos_comprobante1.DataSetName = "datos_comprobante";
     this.datos_comprobante1.Locale = new System.Globalization.CultureInfo("es-ES");
     this.datos_comprobante1.Namespace = "http://www.tempuri.org/datos_comprobante.xsd";
     //
     // oleDbDataAdapter3
     //
     this.oleDbDataAdapter3.SelectCommand = this.oleDbSelectCommand3;
     this.oleDbDataAdapter3.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
                                                                                                 new System.Data.Common.DataTableMapping("Table", "t_compromisos", new System.Data.Common.DataColumnMapping[] {
                                                                                                                                                                                                                  new System.Data.Common.DataColumnMapping("NRO_DOCUMENTO", "NRO_DOCUMENTO"),
                                                                                                                                                                                                                  new System.Data.Common.DataColumnMapping("FECHA_VENCIMIENTO", "FECHA_VENCIMIENTO"),
                                                                                                                                                                                                                  new System.Data.Common.DataColumnMapping("TIPO_COMPROMISO", "TIPO_COMPROMISO"),
                                                                                                                                                                                                                  new System.Data.Common.DataColumnMapping("MONTO_ABONO", "MONTO_ABONO")})});
     //
     // oleDbSelectCommand3
     //
     this.oleDbSelectCommand3.CommandText = "SELECT \'\' AS NRO_DOCUMENTO, \'\' AS FECHA_VENCIMIENTO, \'\' AS TIPO_COMPROMISO, \'\' AS" +
         " MONTO_ABONO, \'\' AS TIPO_DETALLE ";
     this.oleDbSelectCommand3.Connection = this.oleDbConnection1;
     this.Load += new System.EventHandler(this.Page_Load);
     ((System.ComponentModel.ISupportInitialize)(this.datos_comprobante1)).EndInit();
 }