示例#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.conexion = new System.Data.OleDb.OleDbConnection();
     this.adpEncabezado = new System.Data.OleDb.OleDbDataAdapter();
     this.oleDbSelectCommand3 = new System.Data.OleDb.OleDbCommand();
     this.ds = new repactaciones.DataSet1();
     this.adpDetalles = new System.Data.OleDb.OleDbDataAdapter();
     this.oleDbSelectCommand1 = new System.Data.OleDb.OleDbCommand();
     ((System.ComponentModel.ISupportInitialize)(this.ds)).BeginInit();
     //
     // conexion
     //
     this.conexion.ConnectionString = ((string)(configurationAppSettings.GetValue("cadenaConexion", typeof(string))));
     //
     // adpEncabezado
     //
     this.adpEncabezado.SelectCommand = this.oleDbSelectCommand3;
     this.adpEncabezado.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
                                                                                             new System.Data.Common.DataTableMapping("Table", "ENCABEZADO", new System.Data.Common.DataColumnMapping[] {
                                                                                                                                                                                                           new System.Data.Common.DataColumnMapping("NOMBRE_COMPLETO", "NOMBRE_COMPLETO"),
                                                                                                                                                                                                           new System.Data.Common.DataColumnMapping("CARRERA", "CARRERA"),
                                                                                                                                                                                                           new System.Data.Common.DataColumnMapping("REPA_NCORR", "REPA_NCORR"),
                                                                                                                                                                                                           new System.Data.Common.DataColumnMapping("REPA_FREPACTACION", "REPA_FREPACTACION")})});
     //
     // oleDbSelectCommand3
     //
     this.oleDbSelectCommand3.CommandText = "SELECT \'\' AS NOMBRE_COMPLETO, \'\' AS RUT, \'\' AS REPA_NCORR, \'\' AS REPA_FREPACTACIO" +
         "N, \'\' AS MREP_TDESC, \'\' AS correlativo";
     this.oleDbSelectCommand3.Connection = this.conexion;
     //
     // ds
     //
     this.ds.DataSetName = "dataSet1";
     this.ds.Locale = new System.Globalization.CultureInfo("es-ES");
     this.ds.Namespace = "http://www.tempuri.org/DataSet1.xsd";
     //
     // adpDetalles
     //
     this.adpDetalles.SelectCommand = this.oleDbSelectCommand1;
     this.adpDetalles.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
                                                                                           new System.Data.Common.DataTableMapping("Table", "DETALLES", new System.Data.Common.DataColumnMapping[] {
                                                                                                                                                                                                       new System.Data.Common.DataColumnMapping("ORDEN", "ORDEN"),
                                                                                                                                                                                                       new System.Data.Common.DataColumnMapping("ENCABEZADO", "ENCABEZADO"),
                                                                                                                                                                                                       new System.Data.Common.DataColumnMapping("TING_CCOD", "TING_CCOD"),
                                                                                                                                                                                                       new System.Data.Common.DataColumnMapping("INGR_NCORR", "INGR_NCORR"),
                                                                                                                                                                                                       new System.Data.Common.DataColumnMapping("DING_NDOCTO", "DING_NDOCTO"),
                                                                                                                                                                                                       new System.Data.Common.DataColumnMapping("BANC_TDESC", "BANC_TDESC"),
                                                                                                                                                                                                       new System.Data.Common.DataColumnMapping("DING_FDOCTO", "DING_FDOCTO"),
                                                                                                                                                                                                       new System.Data.Common.DataColumnMapping("BANC_CCOD", "BANC_CCOD"),
                                                                                                                                                                                                       new System.Data.Common.DataColumnMapping("TING_TDESC", "TING_TDESC"),
                                                                                                                                                                                                       new System.Data.Common.DataColumnMapping("MONTO1", "MONTO1"),
                                                                                                                                                                                                       new System.Data.Common.DataColumnMapping("MONTO2", "MONTO2"),
                                                                                                                                                                                                       new System.Data.Common.DataColumnMapping("MONTO3", "MONTO3")})});
     //
     // oleDbSelectCommand1
     //
     this.oleDbSelectCommand1.CommandText = "SELECT 0 AS ORDEN, \'\' AS ENCABEZADO, 0 AS TING_CCOD, 0 AS INGR_NCORR, 0 AS DING_N" +
         "DOCTO, \'\' AS BANC_TDESC, GETDATE() AS DING_FDOCTO, 0 AS BANC_CCOD, \'\' AS TING_TD" +
         "ESC, 0 AS MONTO1, 0 AS MONTO2, 0 AS MONTO3";
     this.oleDbSelectCommand1.Connection = this.conexion;
     this.Load += new System.EventHandler(this.Page_Load);
     ((System.ComponentModel.ISupportInitialize)(this.ds)).EndInit();
 }
示例#2
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.conexion            = new System.Data.OleDb.OleDbConnection();
     this.adpEncabezado       = new System.Data.OleDb.OleDbDataAdapter();
     this.oleDbSelectCommand3 = new System.Data.OleDb.OleDbCommand();
     this.ds                  = new repactaciones.DataSet1();
     this.adpDetalles         = new System.Data.OleDb.OleDbDataAdapter();
     this.oleDbSelectCommand1 = new System.Data.OleDb.OleDbCommand();
     ((System.ComponentModel.ISupportInitialize)(this.ds)).BeginInit();
     //
     // conexion
     //
     this.conexion.ConnectionString = ((string)(configurationAppSettings.GetValue("cadenaConexion", typeof(string))));
     //
     // adpEncabezado
     //
     this.adpEncabezado.SelectCommand = this.oleDbSelectCommand3;
     this.adpEncabezado.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
         new System.Data.Common.DataTableMapping("Table", "ENCABEZADO", new System.Data.Common.DataColumnMapping[] {
             new System.Data.Common.DataColumnMapping("NOMBRE_COMPLETO", "NOMBRE_COMPLETO"),
             new System.Data.Common.DataColumnMapping("CARRERA", "CARRERA"),
             new System.Data.Common.DataColumnMapping("REPA_NCORR", "REPA_NCORR"),
             new System.Data.Common.DataColumnMapping("REPA_FREPACTACION", "REPA_FREPACTACION")
         })
     });
     //
     // oleDbSelectCommand3
     //
     this.oleDbSelectCommand3.CommandText = "SELECT \'\' AS NOMBRE_COMPLETO, \'\' AS RUT, \'\' AS REPA_NCORR, \'\' AS REPA_FREPACTACIO" +
                                            "N, \'\' AS MREP_TDESC, \'\' AS correlativo";
     this.oleDbSelectCommand3.Connection = this.conexion;
     //
     // ds
     //
     this.ds.DataSetName = "dataSet1";
     this.ds.Locale      = new System.Globalization.CultureInfo("es-ES");
     this.ds.Namespace   = "http://www.tempuri.org/DataSet1.xsd";
     //
     // adpDetalles
     //
     this.adpDetalles.SelectCommand = this.oleDbSelectCommand1;
     this.adpDetalles.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
         new System.Data.Common.DataTableMapping("Table", "DETALLES", new System.Data.Common.DataColumnMapping[] {
             new System.Data.Common.DataColumnMapping("ORDEN", "ORDEN"),
             new System.Data.Common.DataColumnMapping("ENCABEZADO", "ENCABEZADO"),
             new System.Data.Common.DataColumnMapping("TING_CCOD", "TING_CCOD"),
             new System.Data.Common.DataColumnMapping("INGR_NCORR", "INGR_NCORR"),
             new System.Data.Common.DataColumnMapping("DING_NDOCTO", "DING_NDOCTO"),
             new System.Data.Common.DataColumnMapping("BANC_TDESC", "BANC_TDESC"),
             new System.Data.Common.DataColumnMapping("DING_FDOCTO", "DING_FDOCTO"),
             new System.Data.Common.DataColumnMapping("BANC_CCOD", "BANC_CCOD"),
             new System.Data.Common.DataColumnMapping("TING_TDESC", "TING_TDESC"),
             new System.Data.Common.DataColumnMapping("MONTO1", "MONTO1"),
             new System.Data.Common.DataColumnMapping("MONTO2", "MONTO2"),
             new System.Data.Common.DataColumnMapping("MONTO3", "MONTO3")
         })
     });
     //
     // oleDbSelectCommand1
     //
     this.oleDbSelectCommand1.CommandText = "SELECT 0 AS ORDEN, \'\' AS ENCABEZADO, 0 AS TING_CCOD, 0 AS INGR_NCORR, 0 AS DING_N" +
                                            "DOCTO, \'\' AS BANC_TDESC, GETDATE() AS DING_FDOCTO, 0 AS BANC_CCOD, \'\' AS TING_TD" +
                                            "ESC, 0 AS MONTO1, 0 AS MONTO2, 0 AS MONTO3";
     this.oleDbSelectCommand1.Connection = this.conexion;
     this.Load += new System.EventHandler(this.Page_Load);
     ((System.ComponentModel.ISupportInitialize)(this.ds)).EndInit();
 }