/// <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.adpEncabezado = new System.Data.OleDb.OleDbDataAdapter();
this.oleDbSelectCommand1 = new System.Data.OleDb.OleDbCommand();
this.conexion = new System.Data.OleDb.OleDbConnection();
this.ds = new EgresoTitulacion.DataSet1();
this.adpAlumnos = new System.Data.OleDb.OleDbDataAdapter();
this.oleDbSelectCommand2 = new System.Data.OleDb.OleDbCommand();
this.comDatos = new System.Data.OleDb.OleDbCommand();
this.adpAsignaturas = new System.Data.OleDb.OleDbDataAdapter();
this.oleDbSelectCommand3 = new System.Data.OleDb.OleDbCommand();
((System.ComponentModel.ISupportInitialize)(this.ds)).BeginInit();
//
// adpEncabezado
//
this.adpEncabezado.SelectCommand = this.oleDbSelectCommand1;
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("LINEA1", "LINEA1"),
new System.Data.Common.DataColumnMapping("LINEA2", "LINEA2"),
new System.Data.Common.DataColumnMapping("LINEA3", "LINEA3"),
new System.Data.Common.DataColumnMapping("LINEA4", "LINEA4"),
new System.Data.Common.DataColumnMapping("CARR_TDESC", "CARR_TDESC"),
new System.Data.Common.DataColumnMapping("CARR_CCOD", "CARR_CCOD"),
new System.Data.Common.DataColumnMapping("ACEG_NCORR", "ACEG_NCORR"),
new System.Data.Common.DataColumnMapping("ACEG_FEMISION", "ACEG_FEMISION"),
new System.Data.Common.DataColumnMapping("ESPE_TDESC", "ESPE_TDESC"),
new System.Data.Common.DataColumnMapping("NOM_JCURRICULAR", "NOM_JCURRICULAR"),
new System.Data.Common.DataColumnMapping("NOM_JCARRERA", "NOM_JCARRERA"),
new System.Data.Common.DataColumnMapping("NOM_JDOCENTE", "NOM_JDOCENTE"),
new System.Data.Common.DataColumnMapping("NOM_DIRECTOR", "NOM_DIRECTOR"),
new System.Data.Common.DataColumnMapping("NOM_CTITULOS", "NOM_CTITULOS"),
new System.Data.Common.DataColumnMapping("ESPE_CCOD", "ESPE_CCOD"),
new System.Data.Common.DataColumnMapping("CODIGO", "CODIGO")})});
//
// oleDbSelectCommand1
//
this.oleDbSelectCommand1.CommandText = @"SELECT F.INST_TRAZON_SOCIAL AS LINEA1, '' AS LINEA2, 'SEDE ' || ': ' || B.SEDE_TDESC || ' ; ' || B.SEDE_TCALLE || ' ' || B.SEDE_TNRO || ' - ' || C.CIUD_TDESC AS LINEA3, '' AS LINEA4, E.CARR_TDESC, E.CARR_CCOD, A.ACEG_NCORR, TO_CHAR(A.ACEG_FEMISION, 'dd/mm/yyyy') AS ACEG_FEMISION, D.ESPE_TDESC, B.SEDE_TREGISTR AS NOM_JCURRICULAR, '' AS NOM_JCARRERA, '' AS NOM_JDOCENTE, B.SEDE_SECRET AS NOM_DIRECTOR, '' AS NOM_CTITULOS, D.ESPE_CCOD, A.ESPE_CCOD || '-' || TO_CHAR(G.PLAN_NCORRELATIVO) AS CODIGO FROM ACTAS_EGRESOS A, SEDES B, CIUDADES C, ESPECIALIDADES D, CARRERAS E, INSTITUCIONES F, PLANES_ESTUDIO G WHERE A.SEDE_CCOD = B.SEDE_CCOD AND B.CIUD_CCOD = C.CIUD_CCOD AND A.ESPE_CCOD = D.ESPE_CCOD AND D.CARR_CCOD = E.CARR_CCOD AND E.INST_CCOD = F.INST_CCOD AND A.PLAN_CCOD = G.PLAN_CCOD AND (A.ACEG_NCORR = ?)";
this.oleDbSelectCommand1.Connection = this.conexion;
this.oleDbSelectCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("ACEG_NCORR", System.Data.OleDb.OleDbType.Decimal, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(10)), ((System.Byte)(0)), "ACEG_NCORR", System.Data.DataRowVersion.Current, null));
//
// conexion
//
this.conexion.ConnectionString = ((string)(configurationAppSettings.GetValue("cadena_conexion", typeof(string))));
//
// ds
//
this.ds.DataSetName = "DataSet1";
this.ds.Locale = new System.Globalization.CultureInfo("es-MX");
this.ds.Namespace = "http://www.tempuri.org/DataSet1.xsd";
//
// adpAlumnos
//
this.adpAlumnos.SelectCommand = this.oleDbSelectCommand2;
this.adpAlumnos.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
new System.Data.Common.DataTableMapping("Table", "EGRESADOS", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("N", "N"),
new System.Data.Common.DataColumnMapping("GRUPO", "GRUPO"),
new System.Data.Common.DataColumnMapping("PERS_NCORR", "PERS_NCORR"),
new System.Data.Common.DataColumnMapping("NOMBRE", "NOMBRE"),
new System.Data.Common.DataColumnMapping("RUT", "RUT"),
new System.Data.Common.DataColumnMapping("PERIODO_INGRESO", "PERIODO_INGRESO"),
new System.Data.Common.DataColumnMapping("PERIODO_EGRESO", "PERIODO_EGRESO"),
new System.Data.Common.DataColumnMapping("N1", "N1"),
new System.Data.Common.DataColumnMapping("N2", "N2"),
new System.Data.Common.DataColumnMapping("N3", "N3"),
new System.Data.Common.DataColumnMapping("N4", "N4"),
new System.Data.Common.DataColumnMapping("N5", "N5"),
new System.Data.Common.DataColumnMapping("N6", "N6"),
new System.Data.Common.DataColumnMapping("N7", "N7"),
new System.Data.Common.DataColumnMapping("N8", "N8"),
new System.Data.Common.DataColumnMapping("N9", "N9"),
new System.Data.Common.DataColumnMapping("N10", "N10"),
new System.Data.Common.DataColumnMapping("N11", "N11"),
new System.Data.Common.DataColumnMapping("N12", "N12"),
new System.Data.Common.DataColumnMapping("N13", "N13"),
new System.Data.Common.DataColumnMapping("N14", "N14"),
new System.Data.Common.DataColumnMapping("N15", "N15"),
new System.Data.Common.DataColumnMapping("N16", "N16"),
new System.Data.Common.DataColumnMapping("N17", "N17"),
new System.Data.Common.DataColumnMapping("N18", "N18"),
new System.Data.Common.DataColumnMapping("N19", "N19"),
new System.Data.Common.DataColumnMapping("N20", "N20"),
new System.Data.Common.DataColumnMapping("N21", "N21"),
new System.Data.Common.DataColumnMapping("N22", "N22"),
new System.Data.Common.DataColumnMapping("N23", "N23"),
new System.Data.Common.DataColumnMapping("N24", "N24"),
new System.Data.Common.DataColumnMapping("N25", "N25"),
new System.Data.Common.DataColumnMapping("NEGRESO", "NEGRESO")})});
//
// oleDbSelectCommand2
//
this.oleDbSelectCommand2.CommandText = @"SELECT 1 AS N, 1 AS GRUPO, 143815 AS PERS_NCORR, 'CUBILLOS GUZMAN JUAN CARLOS' AS NOMBRE, '9603176-9' AS RUT, '1997/O' AS PERIODO_INGRESO, '2002/P' AS PERIODO_EGRESO, '6.0' AS N1, '6.0' AS N2, '6.0' AS N3, '6.0' AS N4, '6.0' AS N5, '6.0' AS N6, '6.0' AS N7, '6.0' AS N8, '6.0' AS N9, '6.0' AS N10, '6.0' AS N11, '6.0' AS N12, '6.0' AS N13, '6.0' AS N14, '6.0' AS N15, '6.0' AS N16, '6.0' AS N17, '6.0' AS N18, '6.0' AS N19, '6.0' AS N20, '6.0' AS N21, '6.0' AS N22, '6.0' AS N23, '6.0' AS N24, '6.0' AS N25, '6.0' AS NEGRESO FROM DUAL";
this.oleDbSelectCommand2.Connection = this.conexion;
//
// comDatos
//
this.comDatos.CommandText = "SELECT B.PLAN_CCOD, C.ESPE_CCOD, C.CARR_CCOD FROM ACTAS_EGRESOS A, PLANES_ESTUDIO" +
" B, ESPECIALIDADES C WHERE A.PLAN_CCOD = B.PLAN_CCOD AND B.ESPE_CCOD = C.ESPE_CC" +
"OD AND (A.ACEG_NCORR = ?)";
this.comDatos.Connection = this.conexion;
this.comDatos.Parameters.Add(new System.Data.OleDb.OleDbParameter("ACEG_NCORR", System.Data.OleDb.OleDbType.Decimal, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(10)), ((System.Byte)(0)), "ACEG_NCORR", System.Data.DataRowVersion.Current, null));
//
// adpAsignaturas
//
this.adpAsignaturas.SelectCommand = this.oleDbSelectCommand3;
this.adpAsignaturas.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
new System.Data.Common.DataTableMapping("Table", "ASIGNATURAS", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("GRUPO", "GRUPO"),
new System.Data.Common.DataColumnMapping("NASIGNATURA", "NASIGNATURA"),
new System.Data.Common.DataColumnMapping("COD_ASIGNATURA", "COD_ASIGNATURA"),
new System.Data.Common.DataColumnMapping("ASIG_CCOD", "ASIG_CCOD"),
new System.Data.Common.DataColumnMapping("ASIG_TDESC", "ASIG_TDESC"),
new System.Data.Common.DataColumnMapping("ASIG_NHORAS", "ASIG_NHORAS")})});
//
// oleDbSelectCommand3
//
this.oleDbSelectCommand3.CommandText = "SELECT 1 AS GRUPO, 1 AS NASIGNATURA, \'011\' AS COD_ASIGNATURA, B.ASIG_CCOD, B.ASIG" +
"_TDESC, B.ASIG_NHORAS FROM MALLA_CURRICULAR A, ASIGNATURAS B WHERE A.ASIG_CCOD =" +
" B.ASIG_CCOD AND (A.PLAN_CCOD = ?) ORDER BY A.NIVE_CCOD, B.ASIG_CCOD";
this.oleDbSelectCommand3.Connection = this.conexion;
this.oleDbSelectCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("PLAN_CCOD", System.Data.OleDb.OleDbType.Decimal, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(3)), ((System.Byte)(0)), "PLAN_CCOD", System.Data.DataRowVersion.Current, null));
this.Load += new System.EventHandler(this.Page_Load);
((System.ComponentModel.ISupportInitialize)(this.ds)).EndInit();
}
/// <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.adpEncabezado = new System.Data.OleDb.OleDbDataAdapter();
this.oleDbSelectCommand1 = new System.Data.OleDb.OleDbCommand();
this.conexion = new System.Data.OleDb.OleDbConnection();
this.ds = new EgresoTitulacion.DataSet1();
this.adpAlumnos = new System.Data.OleDb.OleDbDataAdapter();
this.oleDbSelectCommand2 = new System.Data.OleDb.OleDbCommand();
this.comDatos = new System.Data.OleDb.OleDbCommand();
this.adpAsignaturas = new System.Data.OleDb.OleDbDataAdapter();
this.oleDbSelectCommand3 = new System.Data.OleDb.OleDbCommand();
((System.ComponentModel.ISupportInitialize)(this.ds)).BeginInit();
//
// adpEncabezado
//
this.adpEncabezado.SelectCommand = this.oleDbSelectCommand1;
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("LINEA1", "LINEA1"),
new System.Data.Common.DataColumnMapping("LINEA2", "LINEA2"),
new System.Data.Common.DataColumnMapping("LINEA3", "LINEA3"),
new System.Data.Common.DataColumnMapping("LINEA4", "LINEA4"),
new System.Data.Common.DataColumnMapping("CARR_TDESC", "CARR_TDESC"),
new System.Data.Common.DataColumnMapping("CARR_CCOD", "CARR_CCOD"),
new System.Data.Common.DataColumnMapping("ACEG_NCORR", "ACEG_NCORR"),
new System.Data.Common.DataColumnMapping("ACEG_FEMISION", "ACEG_FEMISION"),
new System.Data.Common.DataColumnMapping("ESPE_TDESC", "ESPE_TDESC"),
new System.Data.Common.DataColumnMapping("NOM_JCURRICULAR", "NOM_JCURRICULAR"),
new System.Data.Common.DataColumnMapping("NOM_JCARRERA", "NOM_JCARRERA"),
new System.Data.Common.DataColumnMapping("NOM_JDOCENTE", "NOM_JDOCENTE"),
new System.Data.Common.DataColumnMapping("NOM_DIRECTOR", "NOM_DIRECTOR"),
new System.Data.Common.DataColumnMapping("NOM_CTITULOS", "NOM_CTITULOS"),
new System.Data.Common.DataColumnMapping("ESPE_CCOD", "ESPE_CCOD"),
new System.Data.Common.DataColumnMapping("CODIGO", "CODIGO")
})
});
//
// oleDbSelectCommand1
//
this.oleDbSelectCommand1.CommandText = @"SELECT F.INST_TRAZON_SOCIAL AS LINEA1, '' AS LINEA2, 'SEDE ' || ': ' || B.SEDE_TDESC || ' ; ' || B.SEDE_TCALLE || ' ' || B.SEDE_TNRO || ' - ' || C.CIUD_TDESC AS LINEA3, '' AS LINEA4, E.CARR_TDESC, E.CARR_CCOD, A.ACEG_NCORR, TO_CHAR(A.ACEG_FEMISION, 'dd/mm/yyyy') AS ACEG_FEMISION, D.ESPE_TDESC, B.SEDE_TREGISTR AS NOM_JCURRICULAR, '' AS NOM_JCARRERA, '' AS NOM_JDOCENTE, B.SEDE_SECRET AS NOM_DIRECTOR, '' AS NOM_CTITULOS, D.ESPE_CCOD, A.ESPE_CCOD || '-' || TO_CHAR(G.PLAN_NCORRELATIVO) AS CODIGO FROM ACTAS_EGRESOS A, SEDES B, CIUDADES C, ESPECIALIDADES D, CARRERAS E, INSTITUCIONES F, PLANES_ESTUDIO G WHERE A.SEDE_CCOD = B.SEDE_CCOD AND B.CIUD_CCOD = C.CIUD_CCOD AND A.ESPE_CCOD = D.ESPE_CCOD AND D.CARR_CCOD = E.CARR_CCOD AND E.INST_CCOD = F.INST_CCOD AND A.PLAN_CCOD = G.PLAN_CCOD AND (A.ACEG_NCORR = ?)";
this.oleDbSelectCommand1.Connection = this.conexion;
this.oleDbSelectCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("ACEG_NCORR", System.Data.OleDb.OleDbType.Decimal, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(10)), ((System.Byte)(0)), "ACEG_NCORR", System.Data.DataRowVersion.Current, null));
//
// conexion
//
this.conexion.ConnectionString = ((string)(configurationAppSettings.GetValue("cadena_conexion", typeof(string))));
//
// ds
//
this.ds.DataSetName = "DataSet1";
this.ds.Locale = new System.Globalization.CultureInfo("es-MX");
this.ds.Namespace = "http://www.tempuri.org/DataSet1.xsd";
//
// adpAlumnos
//
this.adpAlumnos.SelectCommand = this.oleDbSelectCommand2;
this.adpAlumnos.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
new System.Data.Common.DataTableMapping("Table", "EGRESADOS", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("N", "N"),
new System.Data.Common.DataColumnMapping("GRUPO", "GRUPO"),
new System.Data.Common.DataColumnMapping("PERS_NCORR", "PERS_NCORR"),
new System.Data.Common.DataColumnMapping("NOMBRE", "NOMBRE"),
new System.Data.Common.DataColumnMapping("RUT", "RUT"),
new System.Data.Common.DataColumnMapping("PERIODO_INGRESO", "PERIODO_INGRESO"),
new System.Data.Common.DataColumnMapping("PERIODO_EGRESO", "PERIODO_EGRESO"),
new System.Data.Common.DataColumnMapping("N1", "N1"),
new System.Data.Common.DataColumnMapping("N2", "N2"),
new System.Data.Common.DataColumnMapping("N3", "N3"),
new System.Data.Common.DataColumnMapping("N4", "N4"),
new System.Data.Common.DataColumnMapping("N5", "N5"),
new System.Data.Common.DataColumnMapping("N6", "N6"),
new System.Data.Common.DataColumnMapping("N7", "N7"),
new System.Data.Common.DataColumnMapping("N8", "N8"),
new System.Data.Common.DataColumnMapping("N9", "N9"),
new System.Data.Common.DataColumnMapping("N10", "N10"),
new System.Data.Common.DataColumnMapping("N11", "N11"),
new System.Data.Common.DataColumnMapping("N12", "N12"),
new System.Data.Common.DataColumnMapping("N13", "N13"),
new System.Data.Common.DataColumnMapping("N14", "N14"),
new System.Data.Common.DataColumnMapping("N15", "N15"),
new System.Data.Common.DataColumnMapping("N16", "N16"),
new System.Data.Common.DataColumnMapping("N17", "N17"),
new System.Data.Common.DataColumnMapping("N18", "N18"),
new System.Data.Common.DataColumnMapping("N19", "N19"),
new System.Data.Common.DataColumnMapping("N20", "N20"),
new System.Data.Common.DataColumnMapping("N21", "N21"),
new System.Data.Common.DataColumnMapping("N22", "N22"),
new System.Data.Common.DataColumnMapping("N23", "N23"),
new System.Data.Common.DataColumnMapping("N24", "N24"),
new System.Data.Common.DataColumnMapping("N25", "N25"),
new System.Data.Common.DataColumnMapping("NEGRESO", "NEGRESO")
})
});
//
// oleDbSelectCommand2
//
this.oleDbSelectCommand2.CommandText = @"SELECT 1 AS N, 1 AS GRUPO, 143815 AS PERS_NCORR, 'CUBILLOS GUZMAN JUAN CARLOS' AS NOMBRE, '9603176-9' AS RUT, '1997/O' AS PERIODO_INGRESO, '2002/P' AS PERIODO_EGRESO, '6.0' AS N1, '6.0' AS N2, '6.0' AS N3, '6.0' AS N4, '6.0' AS N5, '6.0' AS N6, '6.0' AS N7, '6.0' AS N8, '6.0' AS N9, '6.0' AS N10, '6.0' AS N11, '6.0' AS N12, '6.0' AS N13, '6.0' AS N14, '6.0' AS N15, '6.0' AS N16, '6.0' AS N17, '6.0' AS N18, '6.0' AS N19, '6.0' AS N20, '6.0' AS N21, '6.0' AS N22, '6.0' AS N23, '6.0' AS N24, '6.0' AS N25, '6.0' AS NEGRESO FROM DUAL";
this.oleDbSelectCommand2.Connection = this.conexion;
//
// comDatos
//
this.comDatos.CommandText = "SELECT B.PLAN_CCOD, C.ESPE_CCOD, C.CARR_CCOD FROM ACTAS_EGRESOS A, PLANES_ESTUDIO" +
" B, ESPECIALIDADES C WHERE A.PLAN_CCOD = B.PLAN_CCOD AND B.ESPE_CCOD = C.ESPE_CC" +
"OD AND (A.ACEG_NCORR = ?)";
this.comDatos.Connection = this.conexion;
this.comDatos.Parameters.Add(new System.Data.OleDb.OleDbParameter("ACEG_NCORR", System.Data.OleDb.OleDbType.Decimal, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(10)), ((System.Byte)(0)), "ACEG_NCORR", System.Data.DataRowVersion.Current, null));
//
// adpAsignaturas
//
this.adpAsignaturas.SelectCommand = this.oleDbSelectCommand3;
this.adpAsignaturas.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
new System.Data.Common.DataTableMapping("Table", "ASIGNATURAS", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("GRUPO", "GRUPO"),
new System.Data.Common.DataColumnMapping("NASIGNATURA", "NASIGNATURA"),
new System.Data.Common.DataColumnMapping("COD_ASIGNATURA", "COD_ASIGNATURA"),
new System.Data.Common.DataColumnMapping("ASIG_CCOD", "ASIG_CCOD"),
new System.Data.Common.DataColumnMapping("ASIG_TDESC", "ASIG_TDESC"),
new System.Data.Common.DataColumnMapping("ASIG_NHORAS", "ASIG_NHORAS")
})
});
//
// oleDbSelectCommand3
//
this.oleDbSelectCommand3.CommandText = "SELECT 1 AS GRUPO, 1 AS NASIGNATURA, \'011\' AS COD_ASIGNATURA, B.ASIG_CCOD, B.ASIG" +
"_TDESC, B.ASIG_NHORAS FROM MALLA_CURRICULAR A, ASIGNATURAS B WHERE A.ASIG_CCOD =" +
" B.ASIG_CCOD AND (A.PLAN_CCOD = ?) ORDER BY A.NIVE_CCOD, B.ASIG_CCOD";
this.oleDbSelectCommand3.Connection = this.conexion;
this.oleDbSelectCommand3.Parameters.Add(new System.Data.OleDb.OleDbParameter("PLAN_CCOD", System.Data.OleDb.OleDbType.Decimal, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(3)), ((System.Byte)(0)), "PLAN_CCOD", System.Data.DataRowVersion.Current, null));
this.Load += new System.EventHandler(this.Page_Load);
((System.ComponentModel.ISupportInitialize)(this.ds)).EndInit();
}
