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 CuentaCorriente.DataSet1();
this.oleDbDataAdapter2 = new System.Data.OleDb.OleDbDataAdapter();
this.oleDbSelectCommand2 = new System.Data.OleDb.OleDbCommand();
this.oleDbDataAdapter3 = new System.Data.OleDb.OleDbDataAdapter();
this.oleDbSelectCommand3 = new System.Data.OleDb.OleDbCommand();
this.oleDbSelectCommand4 = 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.oleDbDataAdapter4 = 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", "T_detalles", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("PERS_NCORR", "PERS_NCORR"),
new System.Data.Common.DataColumnMapping("INST_CCOD", "INST_CCOD"),
new System.Data.Common.DataColumnMapping("COMP_NDOCTO", "COMP_NDOCTO"),
new System.Data.Common.DataColumnMapping("TCOM_CCOD", "TCOM_CCOD"),
new System.Data.Common.DataColumnMapping("DCOM_NCOMPROMISO", "DCOM_NCOMPROMISO"),
new System.Data.Common.DataColumnMapping("NCUOTA", "NCUOTA"),
new System.Data.Common.DataColumnMapping("COMP_FDOCTO", "COMP_FDOCTO"),
new System.Data.Common.DataColumnMapping("DCOM_FCOMPROMISO", "DCOM_FCOMPROMISO"),
new System.Data.Common.DataColumnMapping("DCOM_MCOMPROMISO", "DCOM_MCOMPROMISO"),
new System.Data.Common.DataColumnMapping("TING_CCOD", "TING_CCOD"),
new System.Data.Common.DataColumnMapping("DING_NDOCTO", "DING_NDOCTO"),
new System.Data.Common.DataColumnMapping("ABONOS", "ABONOS"),
new System.Data.Common.DataColumnMapping("SALDO", "SALDO"),
new System.Data.Common.DataColumnMapping("EDIN_CCOD", "EDIN_CCOD"),
new System.Data.Common.DataColumnMapping("EDIN_TDESC", "EDIN_TDESC"),
new System.Data.Common.DataColumnMapping("TCOM_TDESC", "TCOM_TDESC"),
new System.Data.Common.DataColumnMapping("TING_TDESC", "TING_TDESC"),
new System.Data.Common.DataColumnMapping("DOCUMENTADO", "DOCUMENTADO")
})
});
//
// oleDbSelectCommand1
//
this.oleDbSelectCommand1.CommandText = @"SELECT '' AS PERS_NCORR, '' AS INST_CCOD, '' AS COMP_NDOCTO, '' AS TCOM_CCOD, '' AS DCOM_NCOMPROMISO, '' AS NCUOTA, '' AS COMP_FDOCTO, '' AS DCOM_FCOMPROMISO, '' AS DCOM_MCOMPROMISO, '' AS TING_CCOD, '' AS DING_NDOCTO, '' AS ABONOS, '' AS SALDO, '' AS EDIN_CCOD, '' AS EDIN_TDESC, '' AS TCOM_TDESC, '' AS TING_TDESC, '' AS DOCUMENTADO ";
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";
//
// 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("PERS_NCORR", "PERS_NCORR"),
new System.Data.Common.DataColumnMapping("RUT", "RUT"),
new System.Data.Common.DataColumnMapping("NOMBRE", "NOMBRE"),
new System.Data.Common.DataColumnMapping("CARR_TDESC", "CARR_TDESC"),
new System.Data.Common.DataColumnMapping("SEDE_TDESC", "SEDE_TDESC"),
new System.Data.Common.DataColumnMapping("ANO_INGRESO", "ANO_INGRESO"),
new System.Data.Common.DataColumnMapping("ESTADO_MATRICULA", "ESTADO_MATRICULA"),
new System.Data.Common.DataColumnMapping("ESTADO_ALUMNO", "ESTADO_ALUMNO")
})
});
this.oleDbDataAdapter2.RowUpdated += new System.Data.OleDb.OleDbRowUpdatedEventHandler(this.oleDbDataAdapter2_RowUpdated);
//
// oleDbSelectCommand2
//
this.oleDbSelectCommand2.CommandText = "SELECT \'\' AS PERS_NCORR, \'\' AS RUT, \'\' AS NOMBRE, \'\' AS CARR_TDESC, \'\' AS SEDE_TD" +
"ESC, \'\' AS ANO_INGRESO, \'\' AS ESTADO_MATRICULA, \'\' AS ESTADO_ALUMNO, \'\' AS ingre" +
"so_u, \'\' AS PERI_TDESC";
this.oleDbSelectCommand2.Connection = this.oleDbConnection1;
//
// oleDbDataAdapter3
//
this.oleDbDataAdapter3.SelectCommand = this.oleDbSelectCommand3;
this.oleDbDataAdapter3.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
new System.Data.Common.DataTableMapping("Table", "T_Creditos", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("CONT_NCORR", "CONT_NCORR"),
new System.Data.Common.DataColumnMapping("STDE_CCOD", "STDE_CCOD"),
new System.Data.Common.DataColumnMapping("STDE_TDESC", "STDE_TDESC"),
new System.Data.Common.DataColumnMapping("BENE_MMONTO", "BENE_MMONTO"),
new System.Data.Common.DataColumnMapping("MONE_CCOD", "MONE_CCOD"),
new System.Data.Common.DataColumnMapping("BENE_NPORCENTAJE_MATRICULA", "BENE_NPORCENTAJE_MATRICULA"),
new System.Data.Common.DataColumnMapping("BENE_NPORCENTAJE_COLEGIATURA", "BENE_NPORCENTAJE_COLEGIATURA"),
new System.Data.Common.DataColumnMapping("TBEN_CCOD", "TBEN_CCOD"),
new System.Data.Common.DataColumnMapping("BENE_FBENEFICIO", "BENE_FBENEFICIO")
})
});
//
// oleDbSelectCommand3
//
this.oleDbSelectCommand3.CommandText = "SELECT \'\' AS contrato, \'\' AS CONT_NCORR, \'\' AS STDE_CCOD, \'\' AS STDE_TDESC, \'\' AS" +
" BENE_MMONTO, \'\' AS MONE_CCOD, \'\' AS BENE_NPORCENTAJE_MATRICULA, \'\' AS BENE_NPOR" +
"CENTAJE_COLEGIATURA, \'\' AS TBEN_CCOD, \'\' AS BENE_FBENEFICIO";
this.oleDbSelectCommand3.Connection = this.oleDbConnection1;
//
// oleDbSelectCommand4
//
this.oleDbSelectCommand4.CommandText = "SELECT \'\' AS COME_NCORR, \'\' AS COME_TCOMENTARIO, \'\' AS COME_FCOMENTARIO, \'\' AS TI" +
"CO_TDESC, \'\' AS PERS_NCORR_AUTOR";
this.oleDbSelectCommand4.Connection = this.oleDbConnection1;
//
// oleDbDataAdapter4
//
this.oleDbDataAdapter4.DeleteCommand = this.oleDbDeleteCommand1;
this.oleDbDataAdapter4.InsertCommand = this.oleDbInsertCommand1;
this.oleDbDataAdapter4.SelectCommand = this.oleDbSelectCommand4;
this.oleDbDataAdapter4.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
new System.Data.Common.DataTableMapping("Table", "Comentarios", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("COME_NCORR", "COME_NCORR"),
new System.Data.Common.DataColumnMapping("COME_TCOMENTARIO", "COME_TCOMENTARIO"),
new System.Data.Common.DataColumnMapping("COME_FCOMENTARIO", "COME_FCOMENTARIO"),
new System.Data.Common.DataColumnMapping("TICO_TDESC", "TICO_TDESC"),
new System.Data.Common.DataColumnMapping("PERS_NCORR_AUTOR", "PERS_NCORR_AUTOR")
})
});
this.oleDbDataAdapter4.UpdateCommand = this.oleDbUpdateCommand1;
this.Load += new System.EventHandler(this.Page_Load);
((System.ComponentModel.ISupportInitialize)(this.dataSet11)).EndInit();
}
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 CuentaCorriente.DataSet1();
this.oleDbDataAdapter2 = new System.Data.OleDb.OleDbDataAdapter();
this.oleDbSelectCommand2 = new System.Data.OleDb.OleDbCommand();
this.oleDbDataAdapter3 = new System.Data.OleDb.OleDbDataAdapter();
this.oleDbSelectCommand3 = new System.Data.OleDb.OleDbCommand();
this.oleDbSelectCommand4 = 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.oleDbDataAdapter4 = 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", "T_detalles", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("PERS_NCORR", "PERS_NCORR"),
new System.Data.Common.DataColumnMapping("INST_CCOD", "INST_CCOD"),
new System.Data.Common.DataColumnMapping("COMP_NDOCTO", "COMP_NDOCTO"),
new System.Data.Common.DataColumnMapping("TCOM_CCOD", "TCOM_CCOD"),
new System.Data.Common.DataColumnMapping("DCOM_NCOMPROMISO", "DCOM_NCOMPROMISO"),
new System.Data.Common.DataColumnMapping("NCUOTA", "NCUOTA"),
new System.Data.Common.DataColumnMapping("COMP_FDOCTO", "COMP_FDOCTO"),
new System.Data.Common.DataColumnMapping("DCOM_FCOMPROMISO", "DCOM_FCOMPROMISO"),
new System.Data.Common.DataColumnMapping("DCOM_MCOMPROMISO", "DCOM_MCOMPROMISO"),
new System.Data.Common.DataColumnMapping("TING_CCOD", "TING_CCOD"),
new System.Data.Common.DataColumnMapping("DING_NDOCTO", "DING_NDOCTO"),
new System.Data.Common.DataColumnMapping("ABONOS", "ABONOS"),
new System.Data.Common.DataColumnMapping("SALDO", "SALDO"),
new System.Data.Common.DataColumnMapping("EDIN_CCOD", "EDIN_CCOD"),
new System.Data.Common.DataColumnMapping("EDIN_TDESC", "EDIN_TDESC"),
new System.Data.Common.DataColumnMapping("TCOM_TDESC", "TCOM_TDESC"),
new System.Data.Common.DataColumnMapping("TING_TDESC", "TING_TDESC"),
new System.Data.Common.DataColumnMapping("DOCUMENTADO", "DOCUMENTADO")})});
//
// oleDbSelectCommand1
//
this.oleDbSelectCommand1.CommandText = @"SELECT '' AS PERS_NCORR, '' AS INST_CCOD, '' AS COMP_NDOCTO, '' AS TCOM_CCOD, '' AS DCOM_NCOMPROMISO, '' AS NCUOTA, '' AS COMP_FDOCTO, '' AS DCOM_FCOMPROMISO, '' AS DCOM_MCOMPROMISO, '' AS TING_CCOD, '' AS DING_NDOCTO, '' AS ABONOS, '' AS SALDO, '' AS EDIN_CCOD, '' AS EDIN_TDESC, '' AS TCOM_TDESC, '' AS TING_TDESC, '' AS DOCUMENTADO ";
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";
//
// 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("PERS_NCORR", "PERS_NCORR"),
new System.Data.Common.DataColumnMapping("RUT", "RUT"),
new System.Data.Common.DataColumnMapping("NOMBRE", "NOMBRE"),
new System.Data.Common.DataColumnMapping("CARR_TDESC", "CARR_TDESC"),
new System.Data.Common.DataColumnMapping("SEDE_TDESC", "SEDE_TDESC"),
new System.Data.Common.DataColumnMapping("ANO_INGRESO", "ANO_INGRESO"),
new System.Data.Common.DataColumnMapping("ESTADO_MATRICULA", "ESTADO_MATRICULA"),
new System.Data.Common.DataColumnMapping("ESTADO_ALUMNO", "ESTADO_ALUMNO")})});
this.oleDbDataAdapter2.RowUpdated += new System.Data.OleDb.OleDbRowUpdatedEventHandler(this.oleDbDataAdapter2_RowUpdated);
//
// oleDbSelectCommand2
//
this.oleDbSelectCommand2.CommandText = "SELECT \'\' AS PERS_NCORR, \'\' AS RUT, \'\' AS NOMBRE, \'\' AS CARR_TDESC, \'\' AS SEDE_TD" +
"ESC, \'\' AS ANO_INGRESO, \'\' AS ESTADO_MATRICULA, \'\' AS ESTADO_ALUMNO, \'\' AS ingre" +
"so_u, \'\' AS PERI_TDESC";
this.oleDbSelectCommand2.Connection = this.oleDbConnection1;
//
// oleDbDataAdapter3
//
this.oleDbDataAdapter3.SelectCommand = this.oleDbSelectCommand3;
this.oleDbDataAdapter3.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
new System.Data.Common.DataTableMapping("Table", "T_Creditos", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("CONT_NCORR", "CONT_NCORR"),
new System.Data.Common.DataColumnMapping("STDE_CCOD", "STDE_CCOD"),
new System.Data.Common.DataColumnMapping("STDE_TDESC", "STDE_TDESC"),
new System.Data.Common.DataColumnMapping("BENE_MMONTO", "BENE_MMONTO"),
new System.Data.Common.DataColumnMapping("MONE_CCOD", "MONE_CCOD"),
new System.Data.Common.DataColumnMapping("BENE_NPORCENTAJE_MATRICULA", "BENE_NPORCENTAJE_MATRICULA"),
new System.Data.Common.DataColumnMapping("BENE_NPORCENTAJE_COLEGIATURA", "BENE_NPORCENTAJE_COLEGIATURA"),
new System.Data.Common.DataColumnMapping("TBEN_CCOD", "TBEN_CCOD"),
new System.Data.Common.DataColumnMapping("BENE_FBENEFICIO", "BENE_FBENEFICIO")})});
//
// oleDbSelectCommand3
//
this.oleDbSelectCommand3.CommandText = "SELECT \'\' AS contrato, \'\' AS CONT_NCORR, \'\' AS STDE_CCOD, \'\' AS STDE_TDESC, \'\' AS" +
" BENE_MMONTO, \'\' AS MONE_CCOD, \'\' AS BENE_NPORCENTAJE_MATRICULA, \'\' AS BENE_NPOR" +
"CENTAJE_COLEGIATURA, \'\' AS TBEN_CCOD, \'\' AS BENE_FBENEFICIO";
this.oleDbSelectCommand3.Connection = this.oleDbConnection1;
//
// oleDbSelectCommand4
//
this.oleDbSelectCommand4.CommandText = "SELECT \'\' AS COME_NCORR, \'\' AS COME_TCOMENTARIO, \'\' AS COME_FCOMENTARIO, \'\' AS TI" +
"CO_TDESC, \'\' AS PERS_NCORR_AUTOR";
this.oleDbSelectCommand4.Connection = this.oleDbConnection1;
//
// oleDbDataAdapter4
//
this.oleDbDataAdapter4.DeleteCommand = this.oleDbDeleteCommand1;
this.oleDbDataAdapter4.InsertCommand = this.oleDbInsertCommand1;
this.oleDbDataAdapter4.SelectCommand = this.oleDbSelectCommand4;
this.oleDbDataAdapter4.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
new System.Data.Common.DataTableMapping("Table", "Comentarios", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("COME_NCORR", "COME_NCORR"),
new System.Data.Common.DataColumnMapping("COME_TCOMENTARIO", "COME_TCOMENTARIO"),
new System.Data.Common.DataColumnMapping("COME_FCOMENTARIO", "COME_FCOMENTARIO"),
new System.Data.Common.DataColumnMapping("TICO_TDESC", "TICO_TDESC"),
new System.Data.Common.DataColumnMapping("PERS_NCORR_AUTOR", "PERS_NCORR_AUTOR")})});
this.oleDbDataAdapter4.UpdateCommand = this.oleDbUpdateCommand1;
this.Load += new System.EventHandler(this.Page_Load);
((System.ComponentModel.ISupportInitialize)(this.dataSet11)).EndInit();
}
