Exemplo n.º 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.oleDbDataAdapter1   = new System.Data.OleDb.OleDbDataAdapter();
     this.oleDbSelectCommand1 = new System.Data.OleDb.OleDbCommand();
     this.oleDbConnection1    = new System.Data.OleDb.OleDbConnection();
     this.contrato_Docente141 = new contrato_docente.Contrato_Docente14();
     ((System.ComponentModel.ISupportInitialize)(this.contrato_Docente141)).BeginInit();
     //
     // oleDbDataAdapter1
     //
     this.oleDbDataAdapter1.SelectCommand = this.oleDbSelectCommand1;
     this.oleDbDataAdapter1.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
         new System.Data.Common.DataTableMapping("Table", "contrato", new System.Data.Common.DataColumnMapping[] {
             new System.Data.Common.DataColumnMapping("text_antiguo", "text_antiguo"),
             new System.Data.Common.DataColumnMapping("jorn_tdesc", "jorn_tdesc"),
             new System.Data.Common.DataColumnMapping("emailp", "emailp"),
             new System.Data.Common.DataColumnMapping("eciv_tdescp", "eciv_tdescp"),
             new System.Data.Common.DataColumnMapping("pais_tdescp", "pais_tdescp"),
             new System.Data.Common.DataColumnMapping("pers_tprofesionp", "pers_tprofesionp"),
             new System.Data.Common.DataColumnMapping("emailppc", "emailppc"),
             new System.Data.Common.DataColumnMapping("eciv_tdescppc", "eciv_tdescppc"),
             new System.Data.Common.DataColumnMapping("pais_tdescppc", "pais_tdescppc"),
             new System.Data.Common.DataColumnMapping("pers_tprofesionppc", "pers_tprofesionppc"),
             new System.Data.Common.DataColumnMapping("nro_informe", "nro_informe"),
             new System.Data.Common.DataColumnMapping("NRO_INFORME1", "NRO_INFORME1"),
             new System.Data.Common.DataColumnMapping("NOMBRE_INFORME", "NOMBRE_INFORME"),
             new System.Data.Common.DataColumnMapping("NRO_CONTRATO", "NRO_CONTRATO"),
             new System.Data.Common.DataColumnMapping("DD_HOY", "DD_HOY"),
             new System.Data.Common.DataColumnMapping("MM_HOY", "MM_HOY"),
             new System.Data.Common.DataColumnMapping("YY_HOY", "YY_HOY"),
             new System.Data.Common.DataColumnMapping("PERIODO_ACADEMICO", "PERIODO_ACADEMICO"),
             new System.Data.Common.DataColumnMapping("NOMBRE_REPRESENTANTE", "NOMBRE_REPRESENTANTE"),
             new System.Data.Common.DataColumnMapping("NOMBRE_INSTITUCION", "NOMBRE_INSTITUCION"),
             new System.Data.Common.DataColumnMapping("RUT_INSTITUCION", "RUT_INSTITUCION"),
             new System.Data.Common.DataColumnMapping("RUT_POSTULANTE", "RUT_POSTULANTE"),
             new System.Data.Common.DataColumnMapping("EDAD", "EDAD"),
             new System.Data.Common.DataColumnMapping("NOMBRE_ALUMNO", "NOMBRE_ALUMNO"),
             new System.Data.Common.DataColumnMapping("CARRERA", "CARRERA"),
             new System.Data.Common.DataColumnMapping("RUT_CODEUDOR", "RUT_CODEUDOR"),
             new System.Data.Common.DataColumnMapping("NOMBRE_CODEUDOR", "NOMBRE_CODEUDOR"),
             new System.Data.Common.DataColumnMapping("PROFESION", "PROFESION"),
             new System.Data.Common.DataColumnMapping("DIRECCION", "DIRECCION"),
             new System.Data.Common.DataColumnMapping("CIUDAD", "CIUDAD"),
             new System.Data.Common.DataColumnMapping("COMUNA", "COMUNA"),
             new System.Data.Common.DataColumnMapping("TIPO_DOCUMENTO", "TIPO_DOCUMENTO"),
             new System.Data.Common.DataColumnMapping("DOCUMENTO", "DOCUMENTO"),
             new System.Data.Common.DataColumnMapping("NOMBRE_BANCO", "NOMBRE_BANCO"),
             new System.Data.Common.DataColumnMapping("VALOR_DOCTO", "VALOR_DOCTO"),
             new System.Data.Common.DataColumnMapping("NRO_DOCTO", "NRO_DOCTO"),
             new System.Data.Common.DataColumnMapping("FECHA_VENCIMIENTO", "FECHA_VENCIMIENTO"),
             new System.Data.Common.DataColumnMapping("TOTAL_M", "TOTAL_M"),
             new System.Data.Common.DataColumnMapping("TOTAL_A", "TOTAL_A")
         })
     });
     this.oleDbDataAdapter1.RowUpdated += new System.Data.OleDb.OleDbRowUpdatedEventHandler(this.oleDbDataAdapter1_RowUpdated_1);
     //
     // oleDbSelectCommand1
     //
     this.oleDbSelectCommand1.CommandText = @"SELECT 0 AS CDOC_NCORR, 0 AS pers_ncorr, '' AS Nombre_Docente, 0 AS Rut_Docente, '' AS Fecha_Nac, '' AS Estado_Civil, '' AS Direccion, '' AS Comuna, '' AS Ciudad, '' AS PROFESION, 0 AS BLOQ_ANEXO, 0 AS CARR_CCOD, '' AS CARR_TDESC, '' AS ASIG_CCOD, 0 AS ASIG_NHORAS, '' AS ASIG_TDESC, '' AS DUAS_TDESC, 0 AS BPRO_MVALOR, 0 AS Valor, '' AS INST_TRAZON_SOCIAL, '' AS MombreRepLeg, '' AS TipoDocente, '' AS Nacionalidad, '' AS FechaI, '' AS FechaF, 0 AS HOR_COORDINACION1, 0 AS HOR_COORDINACION2, '' AS DV, '' AS FechaF1, '' AS SECC_TDESC, '' AS PORCENTAJE, '' AS MONTOMC, '' AS sede_tdesc, '' AS num_cuotas, '' AS fecha_inicio, '' AS fecha_fin, '' AS tipo_profesor";
     this.oleDbSelectCommand1.Connection  = this.oleDbConnection1;
     //
     // oleDbConnection1
     //
     this.oleDbConnection1.ConnectionString = ((string)(configurationAppSettings.GetValue("cadenaConexion", typeof(string))));
     //
     // contrato_Docente141
     //
     this.contrato_Docente141.DataSetName = "Contrato_Docente14";
     this.contrato_Docente141.Locale      = new System.Globalization.CultureInfo("es-CL");
     this.contrato_Docente141.Namespace   = "http://www.tempuri.org/Contrato_Docente14.xsd";
     this.Load += new System.EventHandler(this.Page_Load);
     ((System.ComponentModel.ISupportInitialize)(this.contrato_Docente141)).EndInit();
 }
Exemplo n.º 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.oleDbDataAdapter1 = new System.Data.OleDb.OleDbDataAdapter();
     this.oleDbSelectCommand1 = new System.Data.OleDb.OleDbCommand();
     this.oleDbConnection1 = new System.Data.OleDb.OleDbConnection();
     this.contrato_Docente141 = new contrato_docente.Contrato_Docente14();
     ((System.ComponentModel.ISupportInitialize)(this.contrato_Docente141)).BeginInit();
     //
     // oleDbDataAdapter1
     //
     this.oleDbDataAdapter1.SelectCommand = this.oleDbSelectCommand1;
     this.oleDbDataAdapter1.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
                                                                                                 new System.Data.Common.DataTableMapping("Table", "contrato", new System.Data.Common.DataColumnMapping[] {
                                                                                                                                                                                                             new System.Data.Common.DataColumnMapping("text_antiguo", "text_antiguo"),
                                                                                                                                                                                                             new System.Data.Common.DataColumnMapping("jorn_tdesc", "jorn_tdesc"),
                                                                                                                                                                                                             new System.Data.Common.DataColumnMapping("emailp", "emailp"),
                                                                                                                                                                                                             new System.Data.Common.DataColumnMapping("eciv_tdescp", "eciv_tdescp"),
                                                                                                                                                                                                             new System.Data.Common.DataColumnMapping("pais_tdescp", "pais_tdescp"),
                                                                                                                                                                                                             new System.Data.Common.DataColumnMapping("pers_tprofesionp", "pers_tprofesionp"),
                                                                                                                                                                                                             new System.Data.Common.DataColumnMapping("emailppc", "emailppc"),
                                                                                                                                                                                                             new System.Data.Common.DataColumnMapping("eciv_tdescppc", "eciv_tdescppc"),
                                                                                                                                                                                                             new System.Data.Common.DataColumnMapping("pais_tdescppc", "pais_tdescppc"),
                                                                                                                                                                                                             new System.Data.Common.DataColumnMapping("pers_tprofesionppc", "pers_tprofesionppc"),
                                                                                                                                                                                                             new System.Data.Common.DataColumnMapping("nro_informe", "nro_informe"),
                                                                                                                                                                                                             new System.Data.Common.DataColumnMapping("NRO_INFORME1", "NRO_INFORME1"),
                                                                                                                                                                                                             new System.Data.Common.DataColumnMapping("NOMBRE_INFORME", "NOMBRE_INFORME"),
                                                                                                                                                                                                             new System.Data.Common.DataColumnMapping("NRO_CONTRATO", "NRO_CONTRATO"),
                                                                                                                                                                                                             new System.Data.Common.DataColumnMapping("DD_HOY", "DD_HOY"),
                                                                                                                                                                                                             new System.Data.Common.DataColumnMapping("MM_HOY", "MM_HOY"),
                                                                                                                                                                                                             new System.Data.Common.DataColumnMapping("YY_HOY", "YY_HOY"),
                                                                                                                                                                                                             new System.Data.Common.DataColumnMapping("PERIODO_ACADEMICO", "PERIODO_ACADEMICO"),
                                                                                                                                                                                                             new System.Data.Common.DataColumnMapping("NOMBRE_REPRESENTANTE", "NOMBRE_REPRESENTANTE"),
                                                                                                                                                                                                             new System.Data.Common.DataColumnMapping("NOMBRE_INSTITUCION", "NOMBRE_INSTITUCION"),
                                                                                                                                                                                                             new System.Data.Common.DataColumnMapping("RUT_INSTITUCION", "RUT_INSTITUCION"),
                                                                                                                                                                                                             new System.Data.Common.DataColumnMapping("RUT_POSTULANTE", "RUT_POSTULANTE"),
                                                                                                                                                                                                             new System.Data.Common.DataColumnMapping("EDAD", "EDAD"),
                                                                                                                                                                                                             new System.Data.Common.DataColumnMapping("NOMBRE_ALUMNO", "NOMBRE_ALUMNO"),
                                                                                                                                                                                                             new System.Data.Common.DataColumnMapping("CARRERA", "CARRERA"),
                                                                                                                                                                                                             new System.Data.Common.DataColumnMapping("RUT_CODEUDOR", "RUT_CODEUDOR"),
                                                                                                                                                                                                             new System.Data.Common.DataColumnMapping("NOMBRE_CODEUDOR", "NOMBRE_CODEUDOR"),
                                                                                                                                                                                                             new System.Data.Common.DataColumnMapping("PROFESION", "PROFESION"),
                                                                                                                                                                                                             new System.Data.Common.DataColumnMapping("DIRECCION", "DIRECCION"),
                                                                                                                                                                                                             new System.Data.Common.DataColumnMapping("CIUDAD", "CIUDAD"),
                                                                                                                                                                                                             new System.Data.Common.DataColumnMapping("COMUNA", "COMUNA"),
                                                                                                                                                                                                             new System.Data.Common.DataColumnMapping("TIPO_DOCUMENTO", "TIPO_DOCUMENTO"),
                                                                                                                                                                                                             new System.Data.Common.DataColumnMapping("DOCUMENTO", "DOCUMENTO"),
                                                                                                                                                                                                             new System.Data.Common.DataColumnMapping("NOMBRE_BANCO", "NOMBRE_BANCO"),
                                                                                                                                                                                                             new System.Data.Common.DataColumnMapping("VALOR_DOCTO", "VALOR_DOCTO"),
                                                                                                                                                                                                             new System.Data.Common.DataColumnMapping("NRO_DOCTO", "NRO_DOCTO"),
                                                                                                                                                                                                             new System.Data.Common.DataColumnMapping("FECHA_VENCIMIENTO", "FECHA_VENCIMIENTO"),
                                                                                                                                                                                                             new System.Data.Common.DataColumnMapping("TOTAL_M", "TOTAL_M"),
                                                                                                                                                                                                             new System.Data.Common.DataColumnMapping("TOTAL_A", "TOTAL_A")})});
     this.oleDbDataAdapter1.RowUpdated += new System.Data.OleDb.OleDbRowUpdatedEventHandler(this.oleDbDataAdapter1_RowUpdated_1);
     //
     // oleDbSelectCommand1
     //
     this.oleDbSelectCommand1.CommandText = @"SELECT 0 AS CDOC_NCORR, 0 AS pers_ncorr, '' AS Nombre_Docente, 0 AS Rut_Docente, '' AS Fecha_Nac, '' AS Estado_Civil, '' AS Direccion, '' AS Comuna, '' AS Ciudad, '' AS PROFESION, 0 AS BLOQ_ANEXO, 0 AS CARR_CCOD, '' AS CARR_TDESC, '' AS ASIG_CCOD, 0 AS ASIG_NHORAS, '' AS ASIG_TDESC, '' AS DUAS_TDESC, 0 AS BPRO_MVALOR, 0 AS Valor, '' AS INST_TRAZON_SOCIAL, '' AS MombreRepLeg, '' AS TipoDocente, '' AS Nacionalidad, '' AS FechaI, '' AS FechaF, 0 AS HOR_COORDINACION1, 0 AS HOR_COORDINACION2, '' AS DV, '' AS FechaF1, '' AS SECC_TDESC, '' AS PORCENTAJE, '' AS MONTOMC, '' AS sede_tdesc, '' AS num_cuotas, '' AS fecha_inicio, '' AS fecha_fin, '' AS tipo_profesor";
     this.oleDbSelectCommand1.Connection = this.oleDbConnection1;
     //
     // oleDbConnection1
     //
     this.oleDbConnection1.ConnectionString = ((string)(configurationAppSettings.GetValue("cadenaConexion", typeof(string))));
     //
     // contrato_Docente141
     //
     this.contrato_Docente141.DataSetName = "Contrato_Docente14";
     this.contrato_Docente141.Locale = new System.Globalization.CultureInfo("es-CL");
     this.contrato_Docente141.Namespace = "http://www.tempuri.org/Contrato_Docente14.xsd";
     this.Load += new System.EventHandler(this.Page_Load);
     ((System.ComponentModel.ISupportInitialize)(this.contrato_Docente141)).EndInit();
 }