/// <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()
{
this.oleDbDataAdapter1 = new System.Data.OleDb.OleDbDataAdapter();
this.oleDbSelectCommand1 = new System.Data.OleDb.OleDbCommand();
this.oleDbConnection1 = new System.Data.OleDb.OleDbConnection();
this.datosContrato1 = new imprimir_contrato_1.datosContrato();
((System.ComponentModel.ISupportInitialize)(this.datosContrato1)).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"),
new System.Data.Common.DataColumnMapping("DIRECCION_ALUMNO", "DIRECCION_ALUMNO"),
new System.Data.Common.DataColumnMapping("COMUNA_ALUMNO", "COMUNA_ALUMNO"),
new System.Data.Common.DataColumnMapping("texto", "texto"),
new System.Data.Common.DataColumnMapping("CIUDAD_ALUMNO", "CIUDAD_ALUMNO")
})
});
this.oleDbDataAdapter1.RowUpdated += new System.Data.OleDb.OleDbRowUpdatedEventHandler(this.oleDbDataAdapter1_RowUpdated_1);
//
// oleDbSelectCommand1
//
this.oleDbSelectCommand1.CommandText = @"SELECT '' AS text_antiguo, '' AS jorn_tdesc, '' AS emailp, '' AS eciv_tdescp, '' AS pais_tdescp, ' ' AS pers_tprofesionp, '' AS emailppc, '' AS eciv_tdescppc, '' AS pais_tdescppc, '' AS pers_tprofesionppc, 0 AS nro_informe, '' AS NOMBRE_INFORME, '' AS NRO_CONTRATO, '' AS DD_HOY, '' AS MM_HOY, '' AS YY_HOY, '' AS NOMBRE_INSTITUCION, '' AS PERIODO_ACADEMICO, '' AS RUT_INSTITUCION, '' AS NOMBRE_REPRESENTANTE, '' AS RUT_POSTULANTE, '' AS EDAD, '' AS NOMBRE_ALUMNO, '' AS CARRERA, '' AS RUT_CODEUDOR, '' AS NOMBRE_CODEUDOR, '' AS PROFESION, '' AS DIRECCION, '' AS DIRECCION_ALUMNO, '' AS CIUDAD, '' AS COMUNA, '' AS CIUDAD_ALUMNO, '' AS COMUNA_ALUMNO, '' AS TIPO_DOCUMENTO, '' AS DOCUMENTO, '' AS NOMBRE_BANCO, '' AS VALOR_DOCTO, '' AS NRO_DOCTO, '' AS FECHA_VENCIMIENTO, '' AS TOTAL_M, '' AS TOTAL_A, '' AS matricula, '' AS arancel, '' AS sede, '' AS comuna_sede,'' AS texto";
this.oleDbSelectCommand1.Connection = this.oleDbConnection1;
//
// oleDbConnection1
//
this.oleDbConnection1.ConnectionString = "Provider=SQLOLEDB;server=edoras;OLE DB Services = -2;uid=protic;pwd=mrclave;initi" +
"al catalog=sigaupaprueba2";
this.oleDbConnection1.InfoMessage += new System.Data.OleDb.OleDbInfoMessageEventHandler(this.oleDbConnection1_InfoMessage);
//
// datosContrato1
//
this.datosContrato1.DataSetName = "datosContrato";
this.datosContrato1.Locale = new System.Globalization.CultureInfo("es-ES");
this.datosContrato1.Namespace = "http://www.tempuri.org/datosContrato.xsd";
this.Load += new System.EventHandler(this.Page_Load);
((System.ComponentModel.ISupportInitialize)(this.datosContrato1)).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()
{
this.oleDbDataAdapter1 = new System.Data.OleDb.OleDbDataAdapter();
this.oleDbSelectCommand1 = new System.Data.OleDb.OleDbCommand();
this.oleDbConnection1 = new System.Data.OleDb.OleDbConnection();
this.datosContrato1 = new imprimir_contrato_1.datosContrato();
((System.ComponentModel.ISupportInitialize)(this.datosContrato1)).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"),
new System.Data.Common.DataColumnMapping("DIRECCION_ALUMNO", "DIRECCION_ALUMNO"),
new System.Data.Common.DataColumnMapping("COMUNA_ALUMNO", "COMUNA_ALUMNO"),
new System.Data.Common.DataColumnMapping("texto", "texto"),
new System.Data.Common.DataColumnMapping("CIUDAD_ALUMNO", "CIUDAD_ALUMNO")
})
});
this.oleDbDataAdapter1.RowUpdated += new System.Data.OleDb.OleDbRowUpdatedEventHandler(this.oleDbDataAdapter1_RowUpdated_1);
//
// oleDbSelectCommand1
//
this.oleDbSelectCommand1.CommandText = @"SELECT '' AS text_antiguo, '' AS jorn_tdesc, '' AS emailp, '' AS eciv_tdescp, '' AS pais_tdescp, ' ' AS pers_tprofesionp, '' AS emailppc, '' AS eciv_tdescppc, '' AS pais_tdescppc, '' AS pers_tprofesionppc, 0 AS nro_informe, '' AS NOMBRE_INFORME, '' AS NRO_CONTRATO, '' AS DD_HOY, '' AS MM_HOY, '' AS YY_HOY, '' AS NOMBRE_INSTITUCION, '' AS PERIODO_ACADEMICO, '' AS RUT_INSTITUCION, '' AS NOMBRE_REPRESENTANTE, '' AS RUT_POSTULANTE, '' AS EDAD, '' AS NOMBRE_ALUMNO, '' AS CARRERA, '' AS RUT_CODEUDOR, '' AS NOMBRE_CODEUDOR, '' AS PROFESION, '' AS DIRECCION, '' AS DIRECCION_ALUMNO, '' AS CIUDAD, '' AS COMUNA, '' AS CIUDAD_ALUMNO, '' AS COMUNA_ALUMNO, '' AS TIPO_DOCUMENTO, '' AS DOCUMENTO, '' AS NOMBRE_BANCO, '' AS VALOR_DOCTO, '' AS NRO_DOCTO, '' AS FECHA_VENCIMIENTO, '' AS TOTAL_M, '' AS TOTAL_A, '' AS matricula, '' AS arancel, '' AS sede, '' AS comuna_sede,'' AS texto";
this.oleDbSelectCommand1.Connection = this.oleDbConnection1;
//
// oleDbConnection1
//
// CONECTIOS STRING DE DESARROLLO
//this.oleDbConnection1.ConnectionString = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=protic_desa;pwd=fglio9085;Initial Catalog=sigaupa_desa;Data Source=172.16.11.111;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=MRIFFOI;Use Encryption for Data=False;Tag with column collation when possible=False";
// CONECTIOS STRING DE Prueba ADMISION2016
//this.oleDbConnection1.ConnectionString = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=protic;pwd=proticprueba;Initial Catalog=sigaupa_prueba;Data Source=10.10.10.77;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=MRIFFOI;Use Encryption for Data=False;Tag with column collation when possible=False";
// CONECTIOS STRING DE PRODUCCION
this.oleDbConnection1.ConnectionString = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=protic;pwd=pu7685bt,yet;Initial Catalog=sigaupa;Data Source=172.16.254.2;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=MRIFFOI;Use Encryption for Data=False;Tag with column collation when possible=False";
this.oleDbConnection1.InfoMessage += new System.Data.OleDb.OleDbInfoMessageEventHandler(this.oleDbConnection1_InfoMessage);
//
// datosContrato1
//
this.datosContrato1.DataSetName = "datosContrato";
this.datosContrato1.Locale = new System.Globalization.CultureInfo("es-ES");
this.datosContrato1.Namespace = "http://www.tempuri.org/datosContrato.xsd";
this.Load += new System.EventHandler(this.Page_Load);
((System.ComponentModel.ISupportInitialize)(this.datosContrato1)).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()
{
this.oleDbDataAdapter1 = new System.Data.OleDb.OleDbDataAdapter();
this.oleDbSelectCommand1 = new System.Data.OleDb.OleDbCommand();
this.oleDbConnection1 = new System.Data.OleDb.OleDbConnection();
this.datosContrato1 = new imprimir_contrato_1.datosContrato();
((System.ComponentModel.ISupportInitialize)(this.datosContrato1)).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"),
new System.Data.Common.DataColumnMapping("DIRECCION_ALUMNO", "DIRECCION_ALUMNO"),
new System.Data.Common.DataColumnMapping("COMUNA_ALUMNO", "COMUNA_ALUMNO"),
new System.Data.Common.DataColumnMapping("texto", "texto"),
new System.Data.Common.DataColumnMapping("CIUDAD_ALUMNO", "CIUDAD_ALUMNO")})});
this.oleDbDataAdapter1.RowUpdated += new System.Data.OleDb.OleDbRowUpdatedEventHandler(this.oleDbDataAdapter1_RowUpdated_1);
//
// oleDbSelectCommand1
//
this.oleDbSelectCommand1.CommandText = @"SELECT '' AS text_antiguo, '' AS jorn_tdesc, '' AS emailp, '' AS eciv_tdescp, '' AS pais_tdescp, ' ' AS pers_tprofesionp, '' AS emailppc, '' AS eciv_tdescppc, '' AS pais_tdescppc, '' AS pers_tprofesionppc, 0 AS nro_informe, '' AS NOMBRE_INFORME, '' AS NRO_CONTRATO, '' AS DD_HOY, '' AS MM_HOY, '' AS YY_HOY, '' AS NOMBRE_INSTITUCION, '' AS PERIODO_ACADEMICO, '' AS RUT_INSTITUCION, '' AS NOMBRE_REPRESENTANTE, '' AS RUT_POSTULANTE, '' AS EDAD, '' AS NOMBRE_ALUMNO, '' AS CARRERA, '' AS RUT_CODEUDOR, '' AS NOMBRE_CODEUDOR, '' AS PROFESION, '' AS DIRECCION, '' AS DIRECCION_ALUMNO, '' AS CIUDAD, '' AS COMUNA, '' AS CIUDAD_ALUMNO, '' AS COMUNA_ALUMNO, '' AS TIPO_DOCUMENTO, '' AS DOCUMENTO, '' AS NOMBRE_BANCO, '' AS VALOR_DOCTO, '' AS NRO_DOCTO, '' AS FECHA_VENCIMIENTO, '' AS TOTAL_M, '' AS TOTAL_A, '' AS matricula, '' AS arancel, '' AS sede, '' AS comuna_sede,'' AS texto";
this.oleDbSelectCommand1.Connection = this.oleDbConnection1;
//
// oleDbConnection1
//
this.oleDbConnection1.ConnectionString = "Provider=SQLOLEDB;server=edoras;OLE DB Services = -2;uid=protic;pwd=mrclave;initi" +
"al catalog=sigaupaprueba2";
this.oleDbConnection1.InfoMessage += new System.Data.OleDb.OleDbInfoMessageEventHandler(this.oleDbConnection1_InfoMessage);
//
// datosContrato1
//
this.datosContrato1.DataSetName = "datosContrato";
this.datosContrato1.Locale = new System.Globalization.CultureInfo("es-ES");
this.datosContrato1.Namespace = "http://www.tempuri.org/datosContrato.xsd";
this.Load += new System.EventHandler(this.Page_Load);
((System.ComponentModel.ISupportInitialize)(this.datosContrato1)).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.oleDbDataAdapter1 = new System.Data.OleDb.OleDbDataAdapter();
this.oleDbSelectCommand1 = new System.Data.OleDb.OleDbCommand();
this.oleDbConnection1 = new System.Data.OleDb.OleDbConnection();
this.datosContrato1 = new imprimir_contrato_1.datosContrato();
((System.ComponentModel.ISupportInitialize)(this.datosContrato1)).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("NRO_INFORME", "NRO_INFORME"),
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 '' text_antiguo, '' as jorn_tdesc, '' as emailp, '' as eciv_tdescp, '' as pais_tdescp, ' ' as pers_tprofesionp, '' as emailppc, '' as eciv_tdescppc, '' as pais_tdescppc, '' as pers_tprofesionppc,0 as nro_informe,'' AS NRO_INFORME, '' AS NOMBRE_INFORME, '' AS NRO_CONTRATO, '' AS DD_HOY, '' AS MM_HOY, '' AS YY_HOY, '' AS PERIODO_ACADEMICO, '' AS NOMBRE_REPRESENTANTE, '' AS NOMBRE_INSTITUCION, '' AS RUT_INSTITUCION, '' AS RUT_POSTULANTE, '' AS EDAD, '' AS NOMBRE_ALUMNO, '' AS CARRERA, '' AS RUT_CODEUDOR, '' AS NOMBRE_CODEUDOR, '' AS PROFESION, '' AS DIRECCION, '' AS CIUDAD, '' AS COMUNA, '' AS TIPO_DOCUMENTO, '' AS DOCUMENTO, '' AS NOMBRE_BANCO, '' AS VALOR_DOCTO, '' AS NRO_DOCTO, '' AS FECHA_VENCIMIENTO, '' AS TOTAL_M, '' AS TOTAL_A";
this.oleDbSelectCommand1.Connection = this.oleDbConnection1;
//
// oleDbConnection1
//
this.oleDbConnection1.ConnectionString = ((string)(configurationAppSettings.GetValue("cadenaConexion", typeof(string))));
//
// datosContrato1
//
this.datosContrato1.DataSetName = "datosContrato";
this.datosContrato1.Locale = new System.Globalization.CultureInfo("es-ES");
this.datosContrato1.Namespace = "http://www.tempuri.org/datosContrato.xsd";
this.Load += new System.EventHandler(this.Page_Load);
((System.ComponentModel.ISupportInitialize)(this.datosContrato1)).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()
{
this.oleDbDataAdapter1 = new System.Data.OleDb.OleDbDataAdapter();
this.oleDbSelectCommand1 = new System.Data.OleDb.OleDbCommand();
this.oleDbConnection1 = new System.Data.OleDb.OleDbConnection();
this.datosContrato1 = new imprimir_contrato_1.datosContrato();
((System.ComponentModel.ISupportInitialize)(this.datosContrato1)).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"),
new System.Data.Common.DataColumnMapping("DIRECCION_ALUMNO", "DIRECCION_ALUMNO"),
new System.Data.Common.DataColumnMapping("COMUNA_ALUMNO", "COMUNA_ALUMNO"),
new System.Data.Common.DataColumnMapping("texto", "texto"),
new System.Data.Common.DataColumnMapping("CIUDAD_ALUMNO", "CIUDAD_ALUMNO")})});
this.oleDbDataAdapter1.RowUpdated += new System.Data.OleDb.OleDbRowUpdatedEventHandler(this.oleDbDataAdapter1_RowUpdated_1);
//
// oleDbSelectCommand1
//
this.oleDbSelectCommand1.CommandText = @"SELECT '' AS text_antiguo, '' AS jorn_tdesc, '' AS emailp, '' AS eciv_tdescp, '' AS pais_tdescp, ' ' AS pers_tprofesionp, '' AS emailppc, '' AS eciv_tdescppc, '' AS pais_tdescppc, '' AS pers_tprofesionppc, 0 AS nro_informe, '' AS NOMBRE_INFORME, '' AS NRO_CONTRATO, '' AS DD_HOY, '' AS MM_HOY, '' AS YY_HOY, '' AS NOMBRE_INSTITUCION, '' AS PERIODO_ACADEMICO, '' AS RUT_INSTITUCION, '' AS NOMBRE_REPRESENTANTE, '' AS RUT_POSTULANTE, '' AS EDAD, '' AS NOMBRE_ALUMNO, '' AS CARRERA, '' AS RUT_CODEUDOR, '' AS NOMBRE_CODEUDOR, '' AS PROFESION, '' AS DIRECCION, '' AS DIRECCION_ALUMNO, '' AS CIUDAD, '' AS COMUNA, '' AS CIUDAD_ALUMNO, '' AS COMUNA_ALUMNO, '' AS TIPO_DOCUMENTO, '' AS DOCUMENTO, '' AS NOMBRE_BANCO, '' AS VALOR_DOCTO, '' AS NRO_DOCTO, '' AS FECHA_VENCIMIENTO, '' AS TOTAL_M, '' AS TOTAL_A, '' AS matricula, '' AS arancel, '' AS sede, '' AS comuna_sede,'' AS texto";
this.oleDbSelectCommand1.Connection = this.oleDbConnection1;
//
// oleDbConnection1
//
// CONECTIOS STRING DE DESARROLLO
//this.oleDbConnection1.ConnectionString = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=protic_desa;pwd=fglio9085;Initial Catalog=sigaupa_desa;Data Source=172.16.11.111;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=MRIFFOI;Use Encryption for Data=False;Tag with column collation when possible=False";
// CONECTIOS STRING DE Prueba ADMISION2016
//this.oleDbConnection1.ConnectionString = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=protic;pwd=proticprueba;Initial Catalog=sigaupa_prueba;Data Source=10.10.10.77;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=MRIFFOI;Use Encryption for Data=False;Tag with column collation when possible=False";
// CONECTIOS STRING DE PRODUCCION
this.oleDbConnection1.ConnectionString = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=protic;pwd=pu7685bt,yet;Initial Catalog=sigaupa;Data Source=172.16.254.2;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=MRIFFOI;Use Encryption for Data=False;Tag with column collation when possible=False";
this.oleDbConnection1.InfoMessage += new System.Data.OleDb.OleDbInfoMessageEventHandler(this.oleDbConnection1_InfoMessage);
//
// datosContrato1
//
this.datosContrato1.DataSetName = "datosContrato";
this.datosContrato1.Locale = new System.Globalization.CultureInfo("es-ES");
this.datosContrato1.Namespace = "http://www.tempuri.org/datosContrato.xsd";
this.Load += new System.EventHandler(this.Page_Load);
((System.ComponentModel.ISupportInitialize)(this.datosContrato1)).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.oleDbDataAdapter1 = new System.Data.OleDb.OleDbDataAdapter();
this.oleDbSelectCommand1 = new System.Data.OleDb.OleDbCommand();
this.oleDbConnection1 = new System.Data.OleDb.OleDbConnection();
this.datosContrato1 = new imprimir_contrato_1.datosContrato();
((System.ComponentModel.ISupportInitialize)(this.datosContrato1)).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("NRO_INFORME", "NRO_INFORME"),
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 '' text_antiguo, '' as jorn_tdesc, '' as emailp, '' as eciv_tdescp, '' as pais_tdescp, ' ' as pers_tprofesionp, '' as emailppc, '' as eciv_tdescppc, '' as pais_tdescppc, '' as pers_tprofesionppc,0 as nro_informe,'' AS NRO_INFORME, '' AS NOMBRE_INFORME, '' AS NRO_CONTRATO, '' AS DD_HOY, '' AS MM_HOY, '' AS YY_HOY, '' AS PERIODO_ACADEMICO, '' AS NOMBRE_REPRESENTANTE, '' AS NOMBRE_INSTITUCION, '' AS RUT_INSTITUCION, '' AS RUT_POSTULANTE, '' AS EDAD, '' AS NOMBRE_ALUMNO, '' AS CARRERA, '' AS RUT_CODEUDOR, '' AS NOMBRE_CODEUDOR, '' AS PROFESION, '' AS DIRECCION, '' AS CIUDAD, '' AS COMUNA, '' AS TIPO_DOCUMENTO, '' AS DOCUMENTO, '' AS NOMBRE_BANCO, '' AS VALOR_DOCTO, '' AS NRO_DOCTO, '' AS FECHA_VENCIMIENTO, '' AS TOTAL_M, '' AS TOTAL_A";
this.oleDbSelectCommand1.Connection = this.oleDbConnection1;
//
// oleDbConnection1
//
this.oleDbConnection1.ConnectionString = ((string)(configurationAppSettings.GetValue("cadenaConexion", typeof(string))));
//
// datosContrato1
//
this.datosContrato1.DataSetName = "datosContrato";
this.datosContrato1.Locale = new System.Globalization.CultureInfo("es-ES");
this.datosContrato1.Namespace = "http://www.tempuri.org/datosContrato.xsd";
this.Load += new System.EventHandler(this.Page_Load);
((System.ComponentModel.ISupportInitialize)(this.datosContrato1)).EndInit();
}
