コード例 #1
0
ファイル: Libro_Venta.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.DbConnection        = new System.Data.OleDb.OleDbConnection();
     this.DataAdapter         = new System.Data.OleDb.OleDbDataAdapter();
     this.dataSet_Contratos1  = new Libro_Venta.DataSet_Contratos();
     this.oleDbSelectCommand1 = new System.Data.OleDb.OleDbCommand();
     ((System.ComponentModel.ISupportInitialize)(this.dataSet_Contratos1)).BeginInit();
     //
     // DbConnection
     //
     this.DbConnection.ConnectionString = ((string)(configurationAppSettings.GetValue("cadenaConexion", typeof(string))));
     //
     // DataAdapter
     //
     this.DataAdapter.SelectCommand = this.oleDbSelectCommand1;
     this.DataAdapter.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
         new System.Data.Common.DataTableMapping("Table", "T_Contratos", new System.Data.Common.DataColumnMapping[] {
             new System.Data.Common.DataColumnMapping("SEDE_CCOD", "SEDE_CCOD"),
             new System.Data.Common.DataColumnMapping("CARR_TDESC", "CARR_TDESC"),
             new System.Data.Common.DataColumnMapping("ESPE_TDESC", "ESPE_TDESC"),
             new System.Data.Common.DataColumnMapping("CONT_NCORR", "CONT_NCORR"),
             new System.Data.Common.DataColumnMapping("CONT_FCONTRATO", "CONT_FCONTRATO"),
             new System.Data.Common.DataColumnMapping("RUT_ALUMNO", "RUT_ALUMNO"),
             new System.Data.Common.DataColumnMapping("NOMBRE_ALUMNO", "NOMBRE_ALUMNO"),
             new System.Data.Common.DataColumnMapping("INGR_NFOLIO_REFERENCIA", "INGR_NFOLIO_REFERENCIA"),
             new System.Data.Common.DataColumnMapping("INGR_FPAGO", "INGR_FPAGO"),
             new System.Data.Common.DataColumnMapping("MONTO_MATRICULA", "MONTO_MATRICULA"),
             new System.Data.Common.DataColumnMapping("MONTO_COLEGIATURA", "MONTO_COLEGIATURA"),
             new System.Data.Common.DataColumnMapping("TOTAL", "TOTAL"),
             new System.Data.Common.DataColumnMapping("JORN_CCOD", "JORN_CCOD"),
             new System.Data.Common.DataColumnMapping("JORN_TDESC", "JORN_TDESC"),
             new System.Data.Common.DataColumnMapping("CREDITO", "CREDITO"),
             new System.Data.Common.DataColumnMapping("BECA", "BECA"),
             new System.Data.Common.DataColumnMapping("DESCUENTO", "DESCUENTO"),
             new System.Data.Common.DataColumnMapping("INTERESES", "INTERESES"),
             new System.Data.Common.DataColumnMapping("SEDE_TDESC", "SEDE_TDESC")
         })
     });
     //
     // dataSet_Contratos1
     //
     this.dataSet_Contratos1.DataSetName = "DataSet_Contratos";
     this.dataSet_Contratos1.Locale      = new System.Globalization.CultureInfo("es-CL");
     this.dataSet_Contratos1.Namespace   = "http://www.tempuri.org/DataSet_Contratos.xsd";
     //
     // oleDbSelectCommand1
     //
     this.oleDbSelectCommand1.CommandText = @"SELECT '' AS SEDE_CCOD, '' AS CARR_TDESC, '' AS ESPE_TDESC, '' AS CONT_NCORR, '' AS CONT_FCONTRATO, '' AS RUT_ALUMNO, '' AS NOMBRE_ALUMNO, '' AS INGR_NFOLIO_REFERENCIA, '' AS INGR_FPAGO, '' AS MONTO_MATRICULA, '' AS MONTO_COLEGIATURA, '' AS TOTAL, '' AS JORN_CCOD, '' AS JORN_TDESC, '' AS CREDITO, '' AS BECA, '' AS DESCUENTO, '' AS INTERESES, '' AS SEDE_TDESC FROM DUAL";
     this.oleDbSelectCommand1.Connection  = this.DbConnection;
     this.Load += new System.EventHandler(this.Page_Load);
     ((System.ComponentModel.ISupportInitialize)(this.dataSet_Contratos1)).EndInit();
 }
コード例 #2
0
ファイル: Libro_Venta.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.DbConnection = new System.Data.OleDb.OleDbConnection();
     this.DataAdapter = new System.Data.OleDb.OleDbDataAdapter();
     this.dataSet_Contratos1 = new Libro_Venta.DataSet_Contratos();
     this.oleDbSelectCommand1 = new System.Data.OleDb.OleDbCommand();
     ((System.ComponentModel.ISupportInitialize)(this.dataSet_Contratos1)).BeginInit();
     //
     // DbConnection
     //
     this.DbConnection.ConnectionString = ((string)(configurationAppSettings.GetValue("cadenaConexion", typeof(string))));
     //
     // DataAdapter
     //
     this.DataAdapter.SelectCommand = this.oleDbSelectCommand1;
     this.DataAdapter.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
                                                                                           new System.Data.Common.DataTableMapping("Table", "T_Contratos", new System.Data.Common.DataColumnMapping[] {
                                                                                                                                                                                                          new System.Data.Common.DataColumnMapping("SEDE_CCOD", "SEDE_CCOD"),
                                                                                                                                                                                                          new System.Data.Common.DataColumnMapping("CARR_TDESC", "CARR_TDESC"),
                                                                                                                                                                                                          new System.Data.Common.DataColumnMapping("ESPE_TDESC", "ESPE_TDESC"),
                                                                                                                                                                                                          new System.Data.Common.DataColumnMapping("CONT_NCORR", "CONT_NCORR"),
                                                                                                                                                                                                          new System.Data.Common.DataColumnMapping("CONT_FCONTRATO", "CONT_FCONTRATO"),
                                                                                                                                                                                                          new System.Data.Common.DataColumnMapping("RUT_ALUMNO", "RUT_ALUMNO"),
                                                                                                                                                                                                          new System.Data.Common.DataColumnMapping("NOMBRE_ALUMNO", "NOMBRE_ALUMNO"),
                                                                                                                                                                                                          new System.Data.Common.DataColumnMapping("INGR_NFOLIO_REFERENCIA", "INGR_NFOLIO_REFERENCIA"),
                                                                                                                                                                                                          new System.Data.Common.DataColumnMapping("INGR_FPAGO", "INGR_FPAGO"),
                                                                                                                                                                                                          new System.Data.Common.DataColumnMapping("MONTO_MATRICULA", "MONTO_MATRICULA"),
                                                                                                                                                                                                          new System.Data.Common.DataColumnMapping("MONTO_COLEGIATURA", "MONTO_COLEGIATURA"),
                                                                                                                                                                                                          new System.Data.Common.DataColumnMapping("TOTAL", "TOTAL"),
                                                                                                                                                                                                          new System.Data.Common.DataColumnMapping("JORN_CCOD", "JORN_CCOD"),
                                                                                                                                                                                                          new System.Data.Common.DataColumnMapping("JORN_TDESC", "JORN_TDESC"),
                                                                                                                                                                                                          new System.Data.Common.DataColumnMapping("CREDITO", "CREDITO"),
                                                                                                                                                                                                          new System.Data.Common.DataColumnMapping("BECA", "BECA"),
                                                                                                                                                                                                          new System.Data.Common.DataColumnMapping("DESCUENTO", "DESCUENTO"),
                                                                                                                                                                                                          new System.Data.Common.DataColumnMapping("INTERESES", "INTERESES"),
                                                                                                                                                                                                          new System.Data.Common.DataColumnMapping("SEDE_TDESC", "SEDE_TDESC")})});
     //
     // dataSet_Contratos1
     //
     this.dataSet_Contratos1.DataSetName = "DataSet_Contratos";
     this.dataSet_Contratos1.Locale = new System.Globalization.CultureInfo("es-CL");
     this.dataSet_Contratos1.Namespace = "http://www.tempuri.org/DataSet_Contratos.xsd";
     //
     // oleDbSelectCommand1
     //
     this.oleDbSelectCommand1.CommandText = @"SELECT '' AS SEDE_CCOD, '' AS CARR_TDESC, '' AS ESPE_TDESC, '' AS CONT_NCORR, '' AS CONT_FCONTRATO, '' AS RUT_ALUMNO, '' AS NOMBRE_ALUMNO, '' AS INGR_NFOLIO_REFERENCIA, '' AS INGR_FPAGO, '' AS MONTO_MATRICULA, '' AS MONTO_COLEGIATURA, '' AS TOTAL, '' AS JORN_CCOD, '' AS JORN_TDESC, '' AS CREDITO, '' AS BECA, '' AS DESCUENTO, '' AS INTERESES, '' AS SEDE_TDESC FROM DUAL";
     this.oleDbSelectCommand1.Connection = this.DbConnection;
     this.Load += new System.EventHandler(this.Page_Load);
     ((System.ComponentModel.ISupportInitialize)(this.dataSet_Contratos1)).EndInit();
 }