示例#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.oleDbConnection1 = new System.Data.OleDb.OleDbConnection();
     this.oleDbDataAdapter1 = new System.Data.OleDb.OleDbDataAdapter();
     this.oleDbSelectCommand1 = new System.Data.OleDb.OleDbCommand();
     this.dataSet11 = new depositos.DataSet1();
     this.oleDbSelectCommand2 = new System.Data.OleDb.OleDbCommand();
     this.oleDbInsertCommand1 = new System.Data.OleDb.OleDbCommand();
     this.oleDbUpdateCommand1 = new System.Data.OleDb.OleDbCommand();
     this.oleDbDeleteCommand1 = new System.Data.OleDb.OleDbCommand();
     this.oleDbDataAdapter2 = new System.Data.OleDb.OleDbDataAdapter();
     ((System.ComponentModel.ISupportInitialize)(this.dataSet11)).BeginInit();
     //
     // oleDbConnection1
     //
     this.oleDbConnection1.ConnectionString = ((string)(configurationAppSettings.GetValue("cadenaConexion", typeof(string))));
     //
     // oleDbDataAdapter1
     //
     this.oleDbDataAdapter1.SelectCommand = this.oleDbSelectCommand1;
     this.oleDbDataAdapter1.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
                                                                                                 new System.Data.Common.DataTableMapping("Table", "Table", new System.Data.Common.DataColumnMapping[] {
                                                                                                                                                                                                          new System.Data.Common.DataColumnMapping("ENVI_NCORR", "ENVI_NCORR"),
                                                                                                                                                                                                          new System.Data.Common.DataColumnMapping("ENVI_FENVIO", "ENVI_FENVIO"),
                                                                                                                                                                                                          new System.Data.Common.DataColumnMapping("CCTE_TDESC", "CCTE_TDESC"),
                                                                                                                                                                                                          new System.Data.Common.DataColumnMapping("INEN_TDESC", "INEN_TDESC"),
                                                                                                                                                                                                          new System.Data.Common.DataColumnMapping("TDEP_TDESC", "TDEP_TDESC"),
                                                                                                                                                                                                          new System.Data.Common.DataColumnMapping("DING_TCUENTA_CORRIENTE", "DING_TCUENTA_CORRIENTE"),
                                                                                                                                                                                                          new System.Data.Common.DataColumnMapping("DING_NDOCTO", "DING_NDOCTO"),
                                                                                                                                                                                                          new System.Data.Common.DataColumnMapping("DING_MDOCTO", "DING_MDOCTO"),
                                                                                                                                                                                                          new System.Data.Common.DataColumnMapping("INGR_FPAGO", "INGR_FPAGO"),
                                                                                                                                                                                                          new System.Data.Common.DataColumnMapping("DING_FDOCTO", "DING_FDOCTO"),
                                                                                                                                                                                                          new System.Data.Common.DataColumnMapping("EDIN_TDESC", "EDIN_TDESC"),
                                                                                                                                                                                                          new System.Data.Common.DataColumnMapping("RUT_APODERADO", "RUT_APODERADO"),
                                                                                                                                                                                                          new System.Data.Common.DataColumnMapping("NOMBRE_APODERADO", "NOMBRE_APODERADO")})});
     //
     // oleDbSelectCommand1
     //
     this.oleDbSelectCommand1.CommandText = @"SELECT '' AS ENVI_NCORR, '' AS ENVI_FENVIO, '' AS CCTE_TDESC, '' AS INEN_TDESC, '' AS TDEP_TDESC, '' AS DING_TCUENTA_CORRIENTE, '' AS DING_NDOCTO, '' AS DING_MDOCTO, '' AS INGR_FPAGO, '' AS DING_FDOCTO, '' AS EDIN_TDESC, '' AS RUT_APODERADO, '' AS NOMBRE_APODERADO ";
     this.oleDbSelectCommand1.Connection = this.oleDbConnection1;
     //
     // dataSet11
     //
     this.dataSet11.DataSetName = "DataSet1";
     this.dataSet11.Locale = new System.Globalization.CultureInfo("es-CL");
     this.dataSet11.Namespace = "http://www.tempuri.org/DataSet1.xsd";
     //
     // oleDbSelectCommand2
     //
     this.oleDbSelectCommand2.CommandText = "SELECT \'\' AS ENVI_NCORR, \'\' AS INEN_CCOD, \'\' AS CCTE_TDESC, \'\' AS TDEP_TDESC, \'\' " +
         "AS ENVI_FENVIO";
     this.oleDbSelectCommand2.Connection = this.oleDbConnection1;
     //
     // oleDbDataAdapter2
     //
     this.oleDbDataAdapter2.DeleteCommand = this.oleDbDeleteCommand1;
     this.oleDbDataAdapter2.InsertCommand = this.oleDbInsertCommand1;
     this.oleDbDataAdapter2.SelectCommand = this.oleDbSelectCommand2;
     this.oleDbDataAdapter2.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
                                                                                                 new System.Data.Common.DataTableMapping("Table", "Table", new System.Data.Common.DataColumnMapping[] {
                                                                                                                                                                                                          new System.Data.Common.DataColumnMapping("ENVI_NCORR", "ENVI_NCORR"),
                                                                                                                                                                                                          new System.Data.Common.DataColumnMapping("INEN_CCOD", "INEN_CCOD"),
                                                                                                                                                                                                          new System.Data.Common.DataColumnMapping("CCTE_TDESC", "CCTE_TDESC"),
                                                                                                                                                                                                          new System.Data.Common.DataColumnMapping("TDEP_TDESC", "TDEP_TDESC"),
                                                                                                                                                                                                          new System.Data.Common.DataColumnMapping("ENVI_FENVIO", "ENVI_FENVIO")})});
     this.oleDbDataAdapter2.UpdateCommand = this.oleDbUpdateCommand1;
     this.Load += new System.EventHandler(this.Page_Load);
     ((System.ComponentModel.ISupportInitialize)(this.dataSet11)).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.oleDbConnection1    = new System.Data.OleDb.OleDbConnection();
     this.oleDbDataAdapter1   = new System.Data.OleDb.OleDbDataAdapter();
     this.oleDbSelectCommand1 = new System.Data.OleDb.OleDbCommand();
     this.dataSet11           = new depositos.DataSet1();
     this.oleDbSelectCommand2 = new System.Data.OleDb.OleDbCommand();
     this.oleDbInsertCommand1 = new System.Data.OleDb.OleDbCommand();
     this.oleDbUpdateCommand1 = new System.Data.OleDb.OleDbCommand();
     this.oleDbDeleteCommand1 = new System.Data.OleDb.OleDbCommand();
     this.oleDbDataAdapter2   = new System.Data.OleDb.OleDbDataAdapter();
     ((System.ComponentModel.ISupportInitialize)(this.dataSet11)).BeginInit();
     //
     // oleDbConnection1
     //
     this.oleDbConnection1.ConnectionString = ((string)(configurationAppSettings.GetValue("cadenaConexion", typeof(string))));
     //
     // oleDbDataAdapter1
     //
     this.oleDbDataAdapter1.SelectCommand = this.oleDbSelectCommand1;
     this.oleDbDataAdapter1.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
         new System.Data.Common.DataTableMapping("Table", "Table", new System.Data.Common.DataColumnMapping[] {
             new System.Data.Common.DataColumnMapping("ENVI_NCORR", "ENVI_NCORR"),
             new System.Data.Common.DataColumnMapping("ENVI_FENVIO", "ENVI_FENVIO"),
             new System.Data.Common.DataColumnMapping("CCTE_TDESC", "CCTE_TDESC"),
             new System.Data.Common.DataColumnMapping("INEN_TDESC", "INEN_TDESC"),
             new System.Data.Common.DataColumnMapping("TDEP_TDESC", "TDEP_TDESC"),
             new System.Data.Common.DataColumnMapping("DING_TCUENTA_CORRIENTE", "DING_TCUENTA_CORRIENTE"),
             new System.Data.Common.DataColumnMapping("DING_NDOCTO", "DING_NDOCTO"),
             new System.Data.Common.DataColumnMapping("DING_MDOCTO", "DING_MDOCTO"),
             new System.Data.Common.DataColumnMapping("INGR_FPAGO", "INGR_FPAGO"),
             new System.Data.Common.DataColumnMapping("DING_FDOCTO", "DING_FDOCTO"),
             new System.Data.Common.DataColumnMapping("EDIN_TDESC", "EDIN_TDESC"),
             new System.Data.Common.DataColumnMapping("RUT_APODERADO", "RUT_APODERADO"),
             new System.Data.Common.DataColumnMapping("NOMBRE_APODERADO", "NOMBRE_APODERADO")
         })
     });
     //
     // oleDbSelectCommand1
     //
     this.oleDbSelectCommand1.CommandText = @"SELECT '' AS ENVI_NCORR, '' AS ENVI_FENVIO, '' AS CCTE_TDESC, '' AS INEN_TDESC, '' AS TDEP_TDESC, '' AS DING_TCUENTA_CORRIENTE, '' AS DING_NDOCTO, '' AS DING_MDOCTO, '' AS INGR_FPAGO, '' AS DING_FDOCTO, '' AS EDIN_TDESC, '' AS RUT_APODERADO, '' AS NOMBRE_APODERADO ";
     this.oleDbSelectCommand1.Connection  = this.oleDbConnection1;
     //
     // dataSet11
     //
     this.dataSet11.DataSetName = "DataSet1";
     this.dataSet11.Locale      = new System.Globalization.CultureInfo("es-CL");
     this.dataSet11.Namespace   = "http://www.tempuri.org/DataSet1.xsd";
     //
     // oleDbSelectCommand2
     //
     this.oleDbSelectCommand2.CommandText = "SELECT \'\' AS ENVI_NCORR, \'\' AS INEN_CCOD, \'\' AS CCTE_TDESC, \'\' AS TDEP_TDESC, \'\' " +
                                            "AS ENVI_FENVIO";
     this.oleDbSelectCommand2.Connection = this.oleDbConnection1;
     //
     // oleDbDataAdapter2
     //
     this.oleDbDataAdapter2.DeleteCommand = this.oleDbDeleteCommand1;
     this.oleDbDataAdapter2.InsertCommand = this.oleDbInsertCommand1;
     this.oleDbDataAdapter2.SelectCommand = this.oleDbSelectCommand2;
     this.oleDbDataAdapter2.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
         new System.Data.Common.DataTableMapping("Table", "Table", new System.Data.Common.DataColumnMapping[] {
             new System.Data.Common.DataColumnMapping("ENVI_NCORR", "ENVI_NCORR"),
             new System.Data.Common.DataColumnMapping("INEN_CCOD", "INEN_CCOD"),
             new System.Data.Common.DataColumnMapping("CCTE_TDESC", "CCTE_TDESC"),
             new System.Data.Common.DataColumnMapping("TDEP_TDESC", "TDEP_TDESC"),
             new System.Data.Common.DataColumnMapping("ENVI_FENVIO", "ENVI_FENVIO")
         })
     });
     this.oleDbDataAdapter2.UpdateCommand = this.oleDbUpdateCommand1;
     this.Load += new System.EventHandler(this.Page_Load);
     ((System.ComponentModel.ISupportInitialize)(this.dataSet11)).EndInit();
 }