/// <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.conexion = new System.Data.OleDb.OleDbConnection();
this.ds = new EgresoTitulacion.DataSet2();
this.adpTitulados = new System.Data.OleDb.OleDbDataAdapter();
this.oleDbSelectCommand2 = new System.Data.OleDb.OleDbCommand();
this.adpGrupos = new System.Data.OleDb.OleDbDataAdapter();
this.oleDbSelectCommand3 = new System.Data.OleDb.OleDbCommand();
this.adpEncRequisitosCalificados = new System.Data.OleDb.OleDbDataAdapter();
this.oleDbSelectCommand4 = new System.Data.OleDb.OleDbCommand();
this.oleDbSelectCommand1 = 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("ACTI_FEMISION", "ACTI_FEMISION"),
new System.Data.Common.DataColumnMapping("ESPE_TDESC", "ESPE_TDESC"),
new System.Data.Common.DataColumnMapping("CODIGO", "CODIGO"),
new System.Data.Common.DataColumnMapping("ACTI_NCORR", "ACTI_NCORR"),
new System.Data.Common.DataColumnMapping("ESPE_CCOD", "ESPE_CCOD"),
new System.Data.Common.DataColumnMapping("CARR_CCOD", "CARR_CCOD"),
new System.Data.Common.DataColumnMapping("ESPE_TTITULO", "ESPE_TTITULO")
})
});
//
// conexion
//
this.conexion.ConnectionString = ((string)(configurationAppSettings.GetValue("cadena_conexion", typeof(string))));
//
// ds
//
this.ds.DataSetName = "DataSet2";
this.ds.Locale = new System.Globalization.CultureInfo("es-MX");
this.ds.Namespace = "http://www.tempuri.org/DataSet2.xsd";
//
// adpTitulados
//
this.adpTitulados.SelectCommand = this.oleDbSelectCommand2;
this.adpTitulados.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
new System.Data.Common.DataTableMapping("Table", "TITULADOS", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("GRUPO", "GRUPO"),
new System.Data.Common.DataColumnMapping("N", "N"),
new System.Data.Common.DataColumnMapping("EGRE_NCORR", "EGRE_NCORR"),
new System.Data.Common.DataColumnMapping("NOMBRE", "NOMBRE"),
new System.Data.Common.DataColumnMapping("RUT", "RUT"),
new System.Data.Common.DataColumnMapping("ACTI_NCORR", "ACTI_NCORR"),
new System.Data.Common.DataColumnMapping("ACEG_NCORR", "ACEG_NCORR"),
new System.Data.Common.DataColumnMapping("PERIODO_INGRESO", "PERIODO_INGRESO"),
new System.Data.Common.DataColumnMapping("PERIODO_EGRESO", "PERIODO_EGRESO"),
new System.Data.Common.DataColumnMapping("REG_FOLIO", "REG_FOLIO"),
new System.Data.Common.DataColumnMapping("FECHA_ENTREGA", "FECHA_ENTREGA"),
new System.Data.Common.DataColumnMapping("N1", "N1"),
new System.Data.Common.DataColumnMapping("P1", "P1"),
new System.Data.Common.DataColumnMapping("N2", "N2"),
new System.Data.Common.DataColumnMapping("P2", "P2"),
new System.Data.Common.DataColumnMapping("N3", "N3"),
new System.Data.Common.DataColumnMapping("P3", "P3"),
new System.Data.Common.DataColumnMapping("N4", "N4"),
new System.Data.Common.DataColumnMapping("P4", "P4"),
new System.Data.Common.DataColumnMapping("N5", "N5"),
new System.Data.Common.DataColumnMapping("P5", "P5"),
new System.Data.Common.DataColumnMapping("N6", "N6"),
new System.Data.Common.DataColumnMapping("P6", "P6"),
new System.Data.Common.DataColumnMapping("N7", "N7"),
new System.Data.Common.DataColumnMapping("P7", "P7"),
new System.Data.Common.DataColumnMapping("N8", "N8"),
new System.Data.Common.DataColumnMapping("P8", "P8"),
new System.Data.Common.DataColumnMapping("NOTA_TITULACION", "NOTA_TITULACION")
})
});
//
// oleDbSelectCommand2
//
this.oleDbSelectCommand2.CommandText = @"SELECT 1 AS GRUPO, 1 AS N, 1 AS EGRE_NCORR, '' AS NOMBRE, '' AS RUT, 1 AS ACTI_NCORR, 1 AS ACEG_NCORR, '' AS PERIODO_INGRESO, '' AS PERIODO_EGRESO, '' AS REG_FOLIO, SYSDATE AS FECHA_ENTREGA, '0.0' AS N1, '0.00' AS P1, '0.0' AS N2, '0.00' AS P2, '0.0' AS N3, '0.00' AS P3, '0.0' AS N4, '0.00' AS P4, '0.0' AS N5, '0.00' AS P5, '0.0' AS N6, '0.00' AS P6, '0.0' AS N7, '0.00' AS P7, '0.0' AS N8, '0.00' AS P8, '0.00' AS NOTA_TITULACION FROM DUAL";
this.oleDbSelectCommand2.Connection = this.conexion;
//
// adpGrupos
//
this.adpGrupos.SelectCommand = this.oleDbSelectCommand3;
this.adpGrupos.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
new System.Data.Common.DataTableMapping("Table", "GRUPOS", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("GRUPO", "GRUPO")
})
});
//
// oleDbSelectCommand3
//
this.oleDbSelectCommand3.CommandText = "SELECT 1 AS GRUPO FROM DUAL";
this.oleDbSelectCommand3.Connection = this.conexion;
//
// adpEncRequisitosCalificados
//
this.adpEncRequisitosCalificados.SelectCommand = this.oleDbSelectCommand4;
this.adpEncRequisitosCalificados.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
new System.Data.Common.DataTableMapping("Table", "ENC_REQ_CALIFICADOS", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("T1", "T1"),
new System.Data.Common.DataColumnMapping("P1", "P1"),
new System.Data.Common.DataColumnMapping("T2", "T2"),
new System.Data.Common.DataColumnMapping("P2", "P2"),
new System.Data.Common.DataColumnMapping("T3", "T3"),
new System.Data.Common.DataColumnMapping("P3", "P3"),
new System.Data.Common.DataColumnMapping("T4", "T4"),
new System.Data.Common.DataColumnMapping("P4", "P4"),
new System.Data.Common.DataColumnMapping("T5", "T5"),
new System.Data.Common.DataColumnMapping("P5", "P5"),
new System.Data.Common.DataColumnMapping("T6", "T6"),
new System.Data.Common.DataColumnMapping("P6", "P6"),
new System.Data.Common.DataColumnMapping("T7", "T7"),
new System.Data.Common.DataColumnMapping("P7", "P7"),
new System.Data.Common.DataColumnMapping("T8", "T8"),
new System.Data.Common.DataColumnMapping("P8", "P8"),
new System.Data.Common.DataColumnMapping("T9", "T9"),
new System.Data.Common.DataColumnMapping("P9", "P9"),
new System.Data.Common.DataColumnMapping("T10", "T10"),
new System.Data.Common.DataColumnMapping("P10", "P10")
})
});
//
// oleDbSelectCommand4
//
this.oleDbSelectCommand4.CommandText = "SELECT \'T\' AS T1, 1 AS P1, \'T\' AS T2, 2 AS P2, \'T\' AS T3, 3 AS P3, \'T\' AS T4, 4 A" +
"S P4, \'T\' AS T5, 5 AS P5, \'T\' AS T6, 6 AS P6, \'T\' AS T7, 7 AS P7, \'T\' AS T8, 8 A" +
"S P8, \'T\' AS T9, 9 AS P9, \'T\' AS T10, 10 AS P10 FROM DUAL";
this.oleDbSelectCommand4.Connection = this.conexion;
//
// oleDbSelectCommand1
//
this.oleDbSelectCommand1.CommandText = @"SELECT E.INST_TRAZON_SOCIAL AS LINEA1, '' AS LINEA2, 'SEDE ' || ': ' || F.SEDE_TDESC || ' ; ' || F.SEDE_TCALLE || ' ' || F.SEDE_TNRO || ' - ' || G.CIUD_TDESC AS LINEA3, '' AS LINEA4, D.CARR_TDESC, A.ACTI_FEMISION, C.ESPE_TDESC, B.ESPE_CCOD || '-' || TO_CHAR(B.PLAN_NCORRELATIVO) AS CODIGO, A.ACTI_NCORR, C.ESPE_CCOD, D.CARR_CCOD, H.TTIT_TDESC AS ESPE_TTITULO FROM ACTAS_TITULACION A, PLANES_ESTUDIO B, ESPECIALIDADES C, CARRERAS D, INSTITUCIONES E, SEDES F, CIUDADES G, TIPOS_TITULOS H WHERE A.PLAN_CCOD = B.PLAN_CCOD AND B.ESPE_CCOD = C.ESPE_CCOD AND C.CARR_CCOD = D.CARR_CCOD AND D.INST_CCOD = E.INST_CCOD AND A.SEDE_CCOD = F.SEDE_CCOD AND F.CIUD_CCOD = G.CIUD_CCOD AND C.TTIT_CCOD = H.TTIT_CCOD (+) AND (A.ACTI_NCORR = ?)";
this.oleDbSelectCommand1.Connection = this.conexion;
this.oleDbSelectCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("ACTI_NCORR", System.Data.OleDb.OleDbType.Decimal, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(10)), ((System.Byte)(0)), "ACTI_NCORR", 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.conexion = new System.Data.OleDb.OleDbConnection();
this.ds = new EgresoTitulacion.DataSet2();
this.adpTitulados = new System.Data.OleDb.OleDbDataAdapter();
this.oleDbSelectCommand2 = new System.Data.OleDb.OleDbCommand();
this.adpGrupos = new System.Data.OleDb.OleDbDataAdapter();
this.oleDbSelectCommand3 = new System.Data.OleDb.OleDbCommand();
this.adpEncRequisitosCalificados = new System.Data.OleDb.OleDbDataAdapter();
this.oleDbSelectCommand4 = new System.Data.OleDb.OleDbCommand();
this.oleDbSelectCommand1 = 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("ACTI_FEMISION", "ACTI_FEMISION"),
new System.Data.Common.DataColumnMapping("ESPE_TDESC", "ESPE_TDESC"),
new System.Data.Common.DataColumnMapping("CODIGO", "CODIGO"),
new System.Data.Common.DataColumnMapping("ACTI_NCORR", "ACTI_NCORR"),
new System.Data.Common.DataColumnMapping("ESPE_CCOD", "ESPE_CCOD"),
new System.Data.Common.DataColumnMapping("CARR_CCOD", "CARR_CCOD"),
new System.Data.Common.DataColumnMapping("ESPE_TTITULO", "ESPE_TTITULO")})});
//
// conexion
//
this.conexion.ConnectionString = ((string)(configurationAppSettings.GetValue("cadena_conexion", typeof(string))));
//
// ds
//
this.ds.DataSetName = "DataSet2";
this.ds.Locale = new System.Globalization.CultureInfo("es-MX");
this.ds.Namespace = "http://www.tempuri.org/DataSet2.xsd";
//
// adpTitulados
//
this.adpTitulados.SelectCommand = this.oleDbSelectCommand2;
this.adpTitulados.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
new System.Data.Common.DataTableMapping("Table", "TITULADOS", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("GRUPO", "GRUPO"),
new System.Data.Common.DataColumnMapping("N", "N"),
new System.Data.Common.DataColumnMapping("EGRE_NCORR", "EGRE_NCORR"),
new System.Data.Common.DataColumnMapping("NOMBRE", "NOMBRE"),
new System.Data.Common.DataColumnMapping("RUT", "RUT"),
new System.Data.Common.DataColumnMapping("ACTI_NCORR", "ACTI_NCORR"),
new System.Data.Common.DataColumnMapping("ACEG_NCORR", "ACEG_NCORR"),
new System.Data.Common.DataColumnMapping("PERIODO_INGRESO", "PERIODO_INGRESO"),
new System.Data.Common.DataColumnMapping("PERIODO_EGRESO", "PERIODO_EGRESO"),
new System.Data.Common.DataColumnMapping("REG_FOLIO", "REG_FOLIO"),
new System.Data.Common.DataColumnMapping("FECHA_ENTREGA", "FECHA_ENTREGA"),
new System.Data.Common.DataColumnMapping("N1", "N1"),
new System.Data.Common.DataColumnMapping("P1", "P1"),
new System.Data.Common.DataColumnMapping("N2", "N2"),
new System.Data.Common.DataColumnMapping("P2", "P2"),
new System.Data.Common.DataColumnMapping("N3", "N3"),
new System.Data.Common.DataColumnMapping("P3", "P3"),
new System.Data.Common.DataColumnMapping("N4", "N4"),
new System.Data.Common.DataColumnMapping("P4", "P4"),
new System.Data.Common.DataColumnMapping("N5", "N5"),
new System.Data.Common.DataColumnMapping("P5", "P5"),
new System.Data.Common.DataColumnMapping("N6", "N6"),
new System.Data.Common.DataColumnMapping("P6", "P6"),
new System.Data.Common.DataColumnMapping("N7", "N7"),
new System.Data.Common.DataColumnMapping("P7", "P7"),
new System.Data.Common.DataColumnMapping("N8", "N8"),
new System.Data.Common.DataColumnMapping("P8", "P8"),
new System.Data.Common.DataColumnMapping("NOTA_TITULACION", "NOTA_TITULACION")})});
//
// oleDbSelectCommand2
//
this.oleDbSelectCommand2.CommandText = @"SELECT 1 AS GRUPO, 1 AS N, 1 AS EGRE_NCORR, '' AS NOMBRE, '' AS RUT, 1 AS ACTI_NCORR, 1 AS ACEG_NCORR, '' AS PERIODO_INGRESO, '' AS PERIODO_EGRESO, '' AS REG_FOLIO, SYSDATE AS FECHA_ENTREGA, '0.0' AS N1, '0.00' AS P1, '0.0' AS N2, '0.00' AS P2, '0.0' AS N3, '0.00' AS P3, '0.0' AS N4, '0.00' AS P4, '0.0' AS N5, '0.00' AS P5, '0.0' AS N6, '0.00' AS P6, '0.0' AS N7, '0.00' AS P7, '0.0' AS N8, '0.00' AS P8, '0.00' AS NOTA_TITULACION FROM DUAL";
this.oleDbSelectCommand2.Connection = this.conexion;
//
// adpGrupos
//
this.adpGrupos.SelectCommand = this.oleDbSelectCommand3;
this.adpGrupos.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
new System.Data.Common.DataTableMapping("Table", "GRUPOS", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("GRUPO", "GRUPO")})});
//
// oleDbSelectCommand3
//
this.oleDbSelectCommand3.CommandText = "SELECT 1 AS GRUPO FROM DUAL";
this.oleDbSelectCommand3.Connection = this.conexion;
//
// adpEncRequisitosCalificados
//
this.adpEncRequisitosCalificados.SelectCommand = this.oleDbSelectCommand4;
this.adpEncRequisitosCalificados.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
new System.Data.Common.DataTableMapping("Table", "ENC_REQ_CALIFICADOS", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("T1", "T1"),
new System.Data.Common.DataColumnMapping("P1", "P1"),
new System.Data.Common.DataColumnMapping("T2", "T2"),
new System.Data.Common.DataColumnMapping("P2", "P2"),
new System.Data.Common.DataColumnMapping("T3", "T3"),
new System.Data.Common.DataColumnMapping("P3", "P3"),
new System.Data.Common.DataColumnMapping("T4", "T4"),
new System.Data.Common.DataColumnMapping("P4", "P4"),
new System.Data.Common.DataColumnMapping("T5", "T5"),
new System.Data.Common.DataColumnMapping("P5", "P5"),
new System.Data.Common.DataColumnMapping("T6", "T6"),
new System.Data.Common.DataColumnMapping("P6", "P6"),
new System.Data.Common.DataColumnMapping("T7", "T7"),
new System.Data.Common.DataColumnMapping("P7", "P7"),
new System.Data.Common.DataColumnMapping("T8", "T8"),
new System.Data.Common.DataColumnMapping("P8", "P8"),
new System.Data.Common.DataColumnMapping("T9", "T9"),
new System.Data.Common.DataColumnMapping("P9", "P9"),
new System.Data.Common.DataColumnMapping("T10", "T10"),
new System.Data.Common.DataColumnMapping("P10", "P10")})});
//
// oleDbSelectCommand4
//
this.oleDbSelectCommand4.CommandText = "SELECT \'T\' AS T1, 1 AS P1, \'T\' AS T2, 2 AS P2, \'T\' AS T3, 3 AS P3, \'T\' AS T4, 4 A" +
"S P4, \'T\' AS T5, 5 AS P5, \'T\' AS T6, 6 AS P6, \'T\' AS T7, 7 AS P7, \'T\' AS T8, 8 A" +
"S P8, \'T\' AS T9, 9 AS P9, \'T\' AS T10, 10 AS P10 FROM DUAL";
this.oleDbSelectCommand4.Connection = this.conexion;
//
// oleDbSelectCommand1
//
this.oleDbSelectCommand1.CommandText = @"SELECT E.INST_TRAZON_SOCIAL AS LINEA1, '' AS LINEA2, 'SEDE ' || ': ' || F.SEDE_TDESC || ' ; ' || F.SEDE_TCALLE || ' ' || F.SEDE_TNRO || ' - ' || G.CIUD_TDESC AS LINEA3, '' AS LINEA4, D.CARR_TDESC, A.ACTI_FEMISION, C.ESPE_TDESC, B.ESPE_CCOD || '-' || TO_CHAR(B.PLAN_NCORRELATIVO) AS CODIGO, A.ACTI_NCORR, C.ESPE_CCOD, D.CARR_CCOD, H.TTIT_TDESC AS ESPE_TTITULO FROM ACTAS_TITULACION A, PLANES_ESTUDIO B, ESPECIALIDADES C, CARRERAS D, INSTITUCIONES E, SEDES F, CIUDADES G, TIPOS_TITULOS H WHERE A.PLAN_CCOD = B.PLAN_CCOD AND B.ESPE_CCOD = C.ESPE_CCOD AND C.CARR_CCOD = D.CARR_CCOD AND D.INST_CCOD = E.INST_CCOD AND A.SEDE_CCOD = F.SEDE_CCOD AND F.CIUD_CCOD = G.CIUD_CCOD AND C.TTIT_CCOD = H.TTIT_CCOD (+) AND (A.ACTI_NCORR = ?)";
this.oleDbSelectCommand1.Connection = this.conexion;
this.oleDbSelectCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("ACTI_NCORR", System.Data.OleDb.OleDbType.Decimal, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(10)), ((System.Byte)(0)), "ACTI_NCORR", System.Data.DataRowVersion.Current, null));
this.Load += new System.EventHandler(this.Page_Load);
((System.ComponentModel.ISupportInitialize)(this.ds)).EndInit();
}
