/// <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.datosPagare1 = new imprimir_pagare.datosPagare();
((System.ComponentModel.ISupportInitialize)(this.datosPagare1)).BeginInit();
//
// oleDbDataAdapter1
//
this.oleDbDataAdapter1.SelectCommand = this.oleDbSelectCommand1;
this.oleDbDataAdapter1.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
new System.Data.Common.DataTableMapping("Table", "pagare", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("NRO_PAGARE", "NRO_PAGARE"),
new System.Data.Common.DataColumnMapping("VALOR_PAGAR", "VALOR_PAGAR"),
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("INICIO_VENCIMIENTO", "INICIO_VENCIMIENTO"),
new System.Data.Common.DataColumnMapping("FINAL_VENCIMIENTO", "FINAL_VENCIMIENTO"),
new System.Data.Common.DataColumnMapping("RUT_POST", "RUT_POST"),
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("DIRECCION_CODEUDOR", "DIRECCION_CODEUDOR"),
new System.Data.Common.DataColumnMapping("CIUDAD_CODEUDOR", "CIUDAD_CODEUDOR"),
new System.Data.Common.DataColumnMapping("DIRECCION_POSTULANTE", "DIRECCION_POSTULANTE"),
new System.Data.Common.DataColumnMapping("CONTRATO", "CONTRATO"),
new System.Data.Common.DataColumnMapping("CIUDAD_CODEUDOR1", "CIUDAD_CODEUDOR1")
})
});
//
// oleDbSelectCommand1
//
this.oleDbSelectCommand1.CommandText = @"SELECT '' AS CIUDAD_SEDE, '' AS NRO_PAGARE, '' AS VALOR_PAGAR, '' AS DD_HOY, '' AS MM_HOY, '' AS YY_HOY, '' AS PERIODO_ACADEMICO, '' AS INICIO_VENCIMIENTO, '' AS FINAL_VENCIMIENTO, '' AS RUT_POST, '' AS NOMBRE_ALUMNO, '' AS CARRERA, '' AS RUT_CODEUDOR, '' AS NOMBRE_CODEUDOR, '' AS DIRECCION_CODEUDOR, '' AS CIUDAD_CODEUDOR, '' AS DIRECCION_POSTULANTE, '' AS CIUDAD_CODEUDOR FROM DUAL";
this.oleDbSelectCommand1.Connection = this.oleDbConnection1;
//
// oleDbConnection1
//
this.oleDbConnection1.ConnectionString = ((string)(configurationAppSettings.GetValue("cadenaConexion", typeof(string))));
//
// datosPagare1
//
this.datosPagare1.DataSetName = "datosPagare";
this.datosPagare1.Locale = new System.Globalization.CultureInfo("es-ES");
this.datosPagare1.Namespace = "http://www.tempuri.org/datosPagare.xsd";
this.Load += new System.EventHandler(this.Page_Load);
((System.ComponentModel.ISupportInitialize)(this.datosPagare1)).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.datosPagare1 = new imprimir_pagare.datosPagare();
((System.ComponentModel.ISupportInitialize)(this.datosPagare1)).BeginInit();
//
// oleDbDataAdapter1
//
this.oleDbDataAdapter1.SelectCommand = this.oleDbSelectCommand1;
this.oleDbDataAdapter1.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
new System.Data.Common.DataTableMapping("Table", "pagare", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("NRO_PAGARE", "NRO_PAGARE"),
new System.Data.Common.DataColumnMapping("VALOR_PAGAR", "VALOR_PAGAR"),
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("INICIO_VENCIMIENTO", "INICIO_VENCIMIENTO"),
new System.Data.Common.DataColumnMapping("FINAL_VENCIMIENTO", "FINAL_VENCIMIENTO"),
new System.Data.Common.DataColumnMapping("RUT_POST", "RUT_POST"),
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("DIRECCION_CODEUDOR", "DIRECCION_CODEUDOR"),
new System.Data.Common.DataColumnMapping("CIUDAD_CODEUDOR", "CIUDAD_CODEUDOR"),
new System.Data.Common.DataColumnMapping("DIRECCION_POSTULANTE", "DIRECCION_POSTULANTE"),
new System.Data.Common.DataColumnMapping("CONTRATO", "CONTRATO"),
new System.Data.Common.DataColumnMapping("CIUDAD_CODEUDOR1", "CIUDAD_CODEUDOR1")})});
//
// oleDbSelectCommand1
//
this.oleDbSelectCommand1.CommandText = @"SELECT '' AS CIUDAD_SEDE, '' AS NRO_PAGARE, '' AS VALOR_PAGAR, '' AS DD_HOY, '' AS MM_HOY, '' AS YY_HOY, '' AS PERIODO_ACADEMICO, '' AS INICIO_VENCIMIENTO, '' AS FINAL_VENCIMIENTO, '' AS RUT_POST, '' AS NOMBRE_ALUMNO, '' AS CARRERA, '' AS RUT_CODEUDOR, '' AS NOMBRE_CODEUDOR, '' AS DIRECCION_CODEUDOR, '' AS CIUDAD_CODEUDOR, '' AS DIRECCION_POSTULANTE, '' AS CIUDAD_CODEUDOR FROM DUAL";
this.oleDbSelectCommand1.Connection = this.oleDbConnection1;
//
// oleDbConnection1
//
this.oleDbConnection1.ConnectionString = ((string)(configurationAppSettings.GetValue("cadenaConexion", typeof(string))));
//
// datosPagare1
//
this.datosPagare1.DataSetName = "datosPagare";
this.datosPagare1.Locale = new System.Globalization.CultureInfo("es-ES");
this.datosPagare1.Namespace = "http://www.tempuri.org/datosPagare.xsd";
this.Load += new System.EventHandler(this.Page_Load);
((System.ComponentModel.ISupportInitialize)(this.datosPagare1)).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.datosPagare1 = new imprimir_pagare.datosPagare();
((System.ComponentModel.ISupportInitialize)(this.datosPagare1)).BeginInit();
//
// oleDbDataAdapter1
//
this.oleDbDataAdapter1.SelectCommand = this.oleDbSelectCommand1;
this.oleDbDataAdapter1.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
new System.Data.Common.DataTableMapping("Table", "PAGARE", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("CIUDAD_SEDE", "CIUDAD_SEDE"),
new System.Data.Common.DataColumnMapping("NRO_PAGARE", "NRO_PAGARE"),
new System.Data.Common.DataColumnMapping("VALOR_PAGAR", "VALOR_PAGAR"),
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("INICIO_VENCIMIENTO", "INICIO_VENCIMIENTO"),
new System.Data.Common.DataColumnMapping("FINAL_VENCIMIENTO", "FINAL_VENCIMIENTO"),
new System.Data.Common.DataColumnMapping("RUT_POST", "RUT_POST"),
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("DIRECCION_CODEUDOR", "DIRECCION_CODEUDOR"),
new System.Data.Common.DataColumnMapping("CIUDAD_CODEUDOR", "CIUDAD_CODEUDOR"),
new System.Data.Common.DataColumnMapping("DIRECCION_POSTULANTE", "DIRECCION_POSTULANTE"),
new System.Data.Common.DataColumnMapping("CIUDAD_CODEUDOR1", "CIUDAD_CODEUDOR1"),
new System.Data.Common.DataColumnMapping("VALOR_CUOTA", "VALOR_CUOTA"),
new System.Data.Common.DataColumnMapping("NUMERO_CUOTAS", "NUMERO_CUOTAS"),
new System.Data.Common.DataColumnMapping("FECHA_PAGO", "FECHA_PAGO"),
new System.Data.Common.DataColumnMapping("BANCO", "BANCO"),
new System.Data.Common.DataColumnMapping("CUENTA_CTE", "CUENTA_CTE")})});
this.oleDbDataAdapter1.RowUpdated += new System.Data.OleDb.OleDbRowUpdatedEventHandler(this.oleDbDataAdapter1_RowUpdated);
//
// oleDbSelectCommand1
//
this.oleDbSelectCommand1.CommandText = @"SELECT '' AS CIUDAD_SEDE, '' AS NRO_PAGARE, '' AS VALOR_PAGAR, '' AS DD_HOY, '' AS MM_HOY, '' AS YY_HOY, '' AS PERIODO_ACADEMICO, '' AS INICIO_VENCIMIENTO, '' AS FINAL_VENCIMIENTO, '' AS RUT_POST, '' AS NOMBRE_ALUMNO, '' AS CARRERA, '' AS RUT_CODEUDOR, '' AS NOMBRE_CODEUDOR, '' AS DIRECCION_CODEUDOR, '' AS CIUDAD_CODEUDOR, '' AS DIRECCION_POSTULANTE, '' AS CIUDAD_CODEUDOR, '' AS VALOR_CUOTA, '' AS NUMERO_CUOTAS, '' AS FECHA_PAGO, '' AS BANCO, '' AS CUENTA_CTE, '' AS COMUNA_CODEUDOR";
this.oleDbSelectCommand1.Connection = this.oleDbConnection1;
//
// oleDbConnection1
//
//this.oleDbConnection1.ConnectionString = "Provider=SQLOLEDB;server=sbd03;OLE DB Services = -2;uid=protic;pwd=,.protic;initi" +"al catalog=sigaupa";
// CONECTOR ADMISION
//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);
//
// datosPagare1
//
this.datosPagare1.DataSetName = "datosPagare";
this.datosPagare1.Locale = new System.Globalization.CultureInfo("es-ES");
this.datosPagare1.Namespace = "http://www.tempuri.org/datosContrato.xsd";
this.Load += new System.EventHandler(this.Page_Load);
((System.ComponentModel.ISupportInitialize)(this.datosPagare1)).EndInit();
}
