/// <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.oleDbConnection1 = new System.Data.OleDb.OleDbConnection(); this.oleDbDataAdapter1 = new System.Data.OleDb.OleDbDataAdapter(); this.oleDbSelectCommand1 = new System.Data.OleDb.OleDbCommand(); this.dataSet11 = new comp_ingreso.DataSet1(); this.oleDbDataAdapter2 = new System.Data.OleDb.OleDbDataAdapter(); this.oleDbSelectCommand2 = new System.Data.OleDb.OleDbCommand(); this.oleDbDataAdapter3 = new System.Data.OleDb.OleDbDataAdapter(); this.oleDbSelectCommand3 = new System.Data.OleDb.OleDbCommand(); this.oleDbDataAdapter4 = new System.Data.OleDb.OleDbDataAdapter(); this.oleDbSelectCommand4 = new System.Data.OleDb.OleDbCommand(); this.oleDbConnection2 = new System.Data.OleDb.OleDbConnection(); this.oleDbSelectCommand5 = new System.Data.OleDb.OleDbCommand(); this.oleDbInsertCommand1 = new System.Data.OleDb.OleDbCommand(); this.oleDbUpdateCommand1 = new System.Data.OleDb.OleDbCommand(); this.oleDbDeleteCommand1 = new System.Data.OleDb.OleDbCommand(); this.oleDbDataAdapter5 = new System.Data.OleDb.OleDbDataAdapter(); ((System.ComponentModel.ISupportInitialize)(this.dataSet11)).BeginInit(); // // oleDbConnection1 // this.oleDbConnection1.ConnectionString = ((string)(configurationAppSettings.GetValue("cadenaConexion", typeof(string)))); // // oleDbDataAdapter1 // this.oleDbDataAdapter1.SelectCommand = this.oleDbSelectCommand1; this.oleDbDataAdapter1.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping("Table", "T_Contrato", new System.Data.Common.DataColumnMapping[] { new System.Data.Common.DataColumnMapping("NUMERO_HOJA", "NUMERO_HOJA"), new System.Data.Common.DataColumnMapping("NOMBRE_HOJA", "NOMBRE_HOJA"), new System.Data.Common.DataColumnMapping("CONT_NCORR", "CONT_NCORR"), new System.Data.Common.DataColumnMapping("F_CONTRATO", "F_CONTRATO"), new System.Data.Common.DataColumnMapping("AUDI_TUSUARIO", "AUDI_TUSUARIO"), new System.Data.Common.DataColumnMapping("ANO_INGRESO", "ANO_INGRESO"), new System.Data.Common.DataColumnMapping("CARRERA", "CARRERA"), new System.Data.Common.DataColumnMapping("RUT_ALUMNO", "RUT_ALUMNO"), new System.Data.Common.DataColumnMapping("PATERNO_ALUMNO", "PATERNO_ALUMNO"), new System.Data.Common.DataColumnMapping("MATERNO_ALUMNO", "MATERNO_ALUMNO"), new System.Data.Common.DataColumnMapping("NOMBRES_ALUMNO", "NOMBRES_ALUMNO"), new System.Data.Common.DataColumnMapping("DIRECCION_ALUMNO", "DIRECCION_ALUMNO"), new System.Data.Common.DataColumnMapping("CIUDAD_ALUMNO", "CIUDAD_ALUMNO"), new System.Data.Common.DataColumnMapping("COMUNA_ALUMNO", "COMUNA_ALUMNO"), new System.Data.Common.DataColumnMapping("FONO_ALUMNO", "FONO_ALUMNO"), new System.Data.Common.DataColumnMapping("RUT_APODERADO", "RUT_APODERADO"), new System.Data.Common.DataColumnMapping("PATERNO_APODERADO", "PATERNO_APODERADO"), new System.Data.Common.DataColumnMapping("MATERNO_APODERADO", "MATERNO_APODERADO"), new System.Data.Common.DataColumnMapping("NOMBRES_APODERADO", "NOMBRES_APODERADO"), new System.Data.Common.DataColumnMapping("DIRECCION_APODERADO", "DIRECCION_APODERADO"), new System.Data.Common.DataColumnMapping("CIUDAD_APODERADO", "CIUDAD_APODERADO"), new System.Data.Common.DataColumnMapping("COMUNA_APODERADO", "COMUNA_APODERADO"), new System.Data.Common.DataColumnMapping("FONO_APODERADO", "FONO_APODERADO"), new System.Data.Common.DataColumnMapping("IGAS_TCODIGO", "IGAS_TCODIGO"), new System.Data.Common.DataColumnMapping("CCOS_TCODIGO", "CCOS_TCODIGO"), new System.Data.Common.DataColumnMapping("TIPO_IMPRESION", "TIPO_IMPRESION")})}); // // oleDbSelectCommand1 // this.oleDbSelectCommand1.CommandText = @"SELECT '' AS NUMERO_HOJA, '' AS NOMBRE_HOJA, '' AS CONT_NCORR, '' AS F_CONTRATO, '' AS AUDI_TUSUARIO, '' AS ANO_INGRESO, '' AS CARRERA, '' AS RUT_ALUMNO, '' AS PATERNO_ALUMNO, '' AS MATERNO_ALUMNO, '' AS NOMBRES_ALUMNO, '' AS DIRECCION_ALUMNO, '' AS CIUDAD_ALUMNO, '' AS COMUNA_ALUMNO, '' AS FONO_ALUMNO, '' AS RUT_APODERADO, '' AS PATERNO_APODERADO, '' AS MATERNO_APODERADO, '' AS NOMBRES_APODERADO, '' AS DIRECCION_APODERADO, '' AS CIUDAD_APODERADO, '' AS COMUNA_APODERADO, '' AS FONO_APODERADO, '' AS igas_tcodigo, '' AS CCOS_TCODIGO, '' AS tipo_impresion"; this.oleDbSelectCommand1.Connection = this.oleDbConnection1; // // dataSet11 // this.dataSet11.DataSetName = "DataSet1"; this.dataSet11.Locale = new System.Globalization.CultureInfo("es-CL"); this.dataSet11.Namespace = "http://www.tempuri.org/DataSet1.xsd"; // // oleDbDataAdapter2 // this.oleDbDataAdapter2.SelectCommand = this.oleDbSelectCommand2; this.oleDbDataAdapter2.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping("Table", "T_Beneficios", new System.Data.Common.DataColumnMapping[] { new System.Data.Common.DataColumnMapping("COMP_NDOCTO", "COMP_NDOCTO"), new System.Data.Common.DataColumnMapping("TCOM_CCOD", "TCOM_CCOD"), new System.Data.Common.DataColumnMapping("ITEM", "ITEM"), new System.Data.Common.DataColumnMapping("FECHA_BENEFICIO", "FECHA_BENEFICIO"), new System.Data.Common.DataColumnMapping("MONTO", "MONTO"), new System.Data.Common.DataColumnMapping("PORCENTAJE", "PORCENTAJE")})}); // // oleDbSelectCommand2 // this.oleDbSelectCommand2.CommandText = "SELECT \'\' AS COMP_NDOCTO, \'\' AS TCOM_CCOD, \'\' AS ITEM, \'\' AS FECHA_BENEFICIO, \'\' " + "AS MONTO, \'\' AS PORCENTAJE"; this.oleDbSelectCommand2.Connection = this.oleDbConnection1; // // oleDbDataAdapter3 // this.oleDbDataAdapter3.SelectCommand = this.oleDbSelectCommand3; this.oleDbDataAdapter3.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping("Table", "T_Cuotas", new System.Data.Common.DataColumnMapping[] { new System.Data.Common.DataColumnMapping("CONT_NCORR", "CONT_NCORR"), new System.Data.Common.DataColumnMapping("INGR_NCORR", "INGR_NCORR"), new System.Data.Common.DataColumnMapping("F_EMISION", "F_EMISION"), new System.Data.Common.DataColumnMapping("MONTO", "MONTO"), new System.Data.Common.DataColumnMapping("DING_NDOCTO", "DING_NDOCTO"), new System.Data.Common.DataColumnMapping("TIPO_DOC", "TIPO_DOC"), new System.Data.Common.DataColumnMapping("BANCO", "BANCO"), new System.Data.Common.DataColumnMapping("PLAZA", "PLAZA"), new System.Data.Common.DataColumnMapping("F_VENCIMIENTO", "F_VENCIMIENTO")})}); // // oleDbSelectCommand3 // this.oleDbSelectCommand3.CommandText = "SELECT \'\' AS CONT_NCORR, \'\' AS INGR_NCORR, \'\' AS F_EMISION, \'\' AS MONTO, \'\' AS DI" + "NG_NDOCTO, \'\' AS TIPO_DOC, \'\' AS BANCO, \'\' AS PLAZA, \'\' AS F_VENCIMIENTO"; this.oleDbSelectCommand3.Connection = this.oleDbConnection1; // // oleDbDataAdapter4 // this.oleDbDataAdapter4.SelectCommand = this.oleDbSelectCommand4; this.oleDbDataAdapter4.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping("Table", "T_Folio_Ref", new System.Data.Common.DataColumnMapping[] { new System.Data.Common.DataColumnMapping("CONT_NCORR", "CONT_NCORR"), new System.Data.Common.DataColumnMapping("INGR_NFOLIO_REFERENCIA", "INGR_NFOLIO_REFERENCIA")})}); // // oleDbSelectCommand4 // this.oleDbSelectCommand4.CommandText = "SELECT \'\' AS CONT_NCORR, \'\' AS INGR_NFOLIO_REFERENCIA, \'\' AS ingr_ncorrelativo_ca" + "ja"; this.oleDbSelectCommand4.Connection = this.oleDbConnection1; // // oleDbConnection2 // this.oleDbConnection2.ConnectionString = "Provider=SQLOLEDB;server=edoras;OLE DB Services = -2;uid=protic;pwd=,.protic;init" + "ial catalog=protic"; // // oleDbSelectCommand5 // this.oleDbSelectCommand5.CommandText = "SELECT \'\' AS RUT, \'\' AS NOMBRE"; this.oleDbSelectCommand5.Connection = this.oleDbConnection1; // // oleDbDataAdapter5 // this.oleDbDataAdapter5.DeleteCommand = this.oleDbDeleteCommand1; this.oleDbDataAdapter5.InsertCommand = this.oleDbInsertCommand1; this.oleDbDataAdapter5.SelectCommand = this.oleDbSelectCommand5; this.oleDbDataAdapter5.UpdateCommand = this.oleDbUpdateCommand1; this.Load += new System.EventHandler(this.Page_Load); ((System.ComponentModel.ISupportInitialize)(this.dataSet11)).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.oleDbConnection1 = new System.Data.OleDb.OleDbConnection(); this.oleDbDataAdapter1 = new System.Data.OleDb.OleDbDataAdapter(); this.oleDbSelectCommand1 = new System.Data.OleDb.OleDbCommand(); this.dataSet11 = new comp_ingreso.DataSet1(); this.oleDbDataAdapter2 = new System.Data.OleDb.OleDbDataAdapter(); this.oleDbSelectCommand2 = new System.Data.OleDb.OleDbCommand(); this.oleDbDataAdapter3 = new System.Data.OleDb.OleDbDataAdapter(); this.oleDbSelectCommand3 = new System.Data.OleDb.OleDbCommand(); this.oleDbDataAdapter4 = new System.Data.OleDb.OleDbDataAdapter(); this.oleDbSelectCommand4 = new System.Data.OleDb.OleDbCommand(); this.oleDbConnection2 = new System.Data.OleDb.OleDbConnection(); this.oleDbSelectCommand5 = new System.Data.OleDb.OleDbCommand(); this.oleDbInsertCommand1 = new System.Data.OleDb.OleDbCommand(); this.oleDbUpdateCommand1 = new System.Data.OleDb.OleDbCommand(); this.oleDbDeleteCommand1 = new System.Data.OleDb.OleDbCommand(); this.oleDbDataAdapter5 = new System.Data.OleDb.OleDbDataAdapter(); ((System.ComponentModel.ISupportInitialize)(this.dataSet11)).BeginInit(); // // oleDbConnection1 // this.oleDbConnection1.ConnectionString = ((string)(configurationAppSettings.GetValue("cadenaConexion", typeof(string)))); // // oleDbDataAdapter1 // this.oleDbDataAdapter1.SelectCommand = this.oleDbSelectCommand1; this.oleDbDataAdapter1.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping("Table", "T_Contrato", new System.Data.Common.DataColumnMapping[] { new System.Data.Common.DataColumnMapping("NUMERO_HOJA", "NUMERO_HOJA"), new System.Data.Common.DataColumnMapping("NOMBRE_HOJA", "NOMBRE_HOJA"), new System.Data.Common.DataColumnMapping("CONT_NCORR", "CONT_NCORR"), new System.Data.Common.DataColumnMapping("F_CONTRATO", "F_CONTRATO"), new System.Data.Common.DataColumnMapping("AUDI_TUSUARIO", "AUDI_TUSUARIO"), new System.Data.Common.DataColumnMapping("ANO_INGRESO", "ANO_INGRESO"), new System.Data.Common.DataColumnMapping("CARRERA", "CARRERA"), new System.Data.Common.DataColumnMapping("RUT_ALUMNO", "RUT_ALUMNO"), new System.Data.Common.DataColumnMapping("PATERNO_ALUMNO", "PATERNO_ALUMNO"), new System.Data.Common.DataColumnMapping("MATERNO_ALUMNO", "MATERNO_ALUMNO"), new System.Data.Common.DataColumnMapping("NOMBRES_ALUMNO", "NOMBRES_ALUMNO"), new System.Data.Common.DataColumnMapping("DIRECCION_ALUMNO", "DIRECCION_ALUMNO"), new System.Data.Common.DataColumnMapping("CIUDAD_ALUMNO", "CIUDAD_ALUMNO"), new System.Data.Common.DataColumnMapping("COMUNA_ALUMNO", "COMUNA_ALUMNO"), new System.Data.Common.DataColumnMapping("FONO_ALUMNO", "FONO_ALUMNO"), new System.Data.Common.DataColumnMapping("RUT_APODERADO", "RUT_APODERADO"), new System.Data.Common.DataColumnMapping("PATERNO_APODERADO", "PATERNO_APODERADO"), new System.Data.Common.DataColumnMapping("MATERNO_APODERADO", "MATERNO_APODERADO"), new System.Data.Common.DataColumnMapping("NOMBRES_APODERADO", "NOMBRES_APODERADO"), new System.Data.Common.DataColumnMapping("DIRECCION_APODERADO", "DIRECCION_APODERADO"), new System.Data.Common.DataColumnMapping("CIUDAD_APODERADO", "CIUDAD_APODERADO"), new System.Data.Common.DataColumnMapping("COMUNA_APODERADO", "COMUNA_APODERADO"), new System.Data.Common.DataColumnMapping("FONO_APODERADO", "FONO_APODERADO"), new System.Data.Common.DataColumnMapping("IGAS_TCODIGO", "IGAS_TCODIGO"), new System.Data.Common.DataColumnMapping("CCOS_TCODIGO", "CCOS_TCODIGO"), new System.Data.Common.DataColumnMapping("TIPO_IMPRESION", "TIPO_IMPRESION") }) }); // // oleDbSelectCommand1 // this.oleDbSelectCommand1.CommandText = @"SELECT '' AS NUMERO_HOJA, '' AS NOMBRE_HOJA, '' AS CONT_NCORR, '' AS F_CONTRATO, '' AS AUDI_TUSUARIO, '' AS ANO_INGRESO, '' AS CARRERA, '' AS RUT_ALUMNO, '' AS PATERNO_ALUMNO, '' AS MATERNO_ALUMNO, '' AS NOMBRES_ALUMNO, '' AS DIRECCION_ALUMNO, '' AS CIUDAD_ALUMNO, '' AS COMUNA_ALUMNO, '' AS FONO_ALUMNO, '' AS RUT_APODERADO, '' AS PATERNO_APODERADO, '' AS MATERNO_APODERADO, '' AS NOMBRES_APODERADO, '' AS DIRECCION_APODERADO, '' AS CIUDAD_APODERADO, '' AS COMUNA_APODERADO, '' AS FONO_APODERADO, '' AS igas_tcodigo, '' AS CCOS_TCODIGO, '' AS tipo_impresion"; this.oleDbSelectCommand1.Connection = this.oleDbConnection1; // // dataSet11 // this.dataSet11.DataSetName = "DataSet1"; this.dataSet11.Locale = new System.Globalization.CultureInfo("es-CL"); this.dataSet11.Namespace = "http://www.tempuri.org/DataSet1.xsd"; // // oleDbDataAdapter2 // this.oleDbDataAdapter2.SelectCommand = this.oleDbSelectCommand2; this.oleDbDataAdapter2.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping("Table", "T_Beneficios", new System.Data.Common.DataColumnMapping[] { new System.Data.Common.DataColumnMapping("COMP_NDOCTO", "COMP_NDOCTO"), new System.Data.Common.DataColumnMapping("TCOM_CCOD", "TCOM_CCOD"), new System.Data.Common.DataColumnMapping("ITEM", "ITEM"), new System.Data.Common.DataColumnMapping("FECHA_BENEFICIO", "FECHA_BENEFICIO"), new System.Data.Common.DataColumnMapping("MONTO", "MONTO"), new System.Data.Common.DataColumnMapping("PORCENTAJE", "PORCENTAJE") }) }); // // oleDbSelectCommand2 // this.oleDbSelectCommand2.CommandText = "SELECT \'\' AS COMP_NDOCTO, \'\' AS TCOM_CCOD, \'\' AS ITEM, \'\' AS FECHA_BENEFICIO, \'\' " + "AS MONTO, \'\' AS PORCENTAJE"; this.oleDbSelectCommand2.Connection = this.oleDbConnection1; // // oleDbDataAdapter3 // this.oleDbDataAdapter3.SelectCommand = this.oleDbSelectCommand3; this.oleDbDataAdapter3.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping("Table", "T_Cuotas", new System.Data.Common.DataColumnMapping[] { new System.Data.Common.DataColumnMapping("CONT_NCORR", "CONT_NCORR"), new System.Data.Common.DataColumnMapping("INGR_NCORR", "INGR_NCORR"), new System.Data.Common.DataColumnMapping("F_EMISION", "F_EMISION"), new System.Data.Common.DataColumnMapping("MONTO", "MONTO"), new System.Data.Common.DataColumnMapping("DING_NDOCTO", "DING_NDOCTO"), new System.Data.Common.DataColumnMapping("TIPO_DOC", "TIPO_DOC"), new System.Data.Common.DataColumnMapping("BANCO", "BANCO"), new System.Data.Common.DataColumnMapping("PLAZA", "PLAZA"), new System.Data.Common.DataColumnMapping("F_VENCIMIENTO", "F_VENCIMIENTO") }) }); // // oleDbSelectCommand3 // this.oleDbSelectCommand3.CommandText = "SELECT \'\' AS CONT_NCORR, \'\' AS INGR_NCORR, \'\' AS F_EMISION, \'\' AS MONTO, \'\' AS DI" + "NG_NDOCTO, \'\' AS TIPO_DOC, \'\' AS BANCO, \'\' AS PLAZA, \'\' AS F_VENCIMIENTO"; this.oleDbSelectCommand3.Connection = this.oleDbConnection1; // // oleDbDataAdapter4 // this.oleDbDataAdapter4.SelectCommand = this.oleDbSelectCommand4; this.oleDbDataAdapter4.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping("Table", "T_Folio_Ref", new System.Data.Common.DataColumnMapping[] { new System.Data.Common.DataColumnMapping("CONT_NCORR", "CONT_NCORR"), new System.Data.Common.DataColumnMapping("INGR_NFOLIO_REFERENCIA", "INGR_NFOLIO_REFERENCIA") }) }); // // oleDbSelectCommand4 // this.oleDbSelectCommand4.CommandText = "SELECT \'\' AS CONT_NCORR, \'\' AS INGR_NFOLIO_REFERENCIA, \'\' AS ingr_ncorrelativo_ca" + "ja"; this.oleDbSelectCommand4.Connection = this.oleDbConnection1; // // oleDbConnection2 // this.oleDbConnection2.ConnectionString = "Provider=SQLOLEDB;server=edoras;OLE DB Services = -2;uid=protic;pwd=,.protic;init" + "ial catalog=protic"; // // oleDbSelectCommand5 // this.oleDbSelectCommand5.CommandText = "SELECT \'\' AS RUT, \'\' AS NOMBRE"; this.oleDbSelectCommand5.Connection = this.oleDbConnection1; // // oleDbDataAdapter5 // this.oleDbDataAdapter5.DeleteCommand = this.oleDbDeleteCommand1; this.oleDbDataAdapter5.InsertCommand = this.oleDbInsertCommand1; this.oleDbDataAdapter5.SelectCommand = this.oleDbSelectCommand5; this.oleDbDataAdapter5.UpdateCommand = this.oleDbUpdateCommand1; this.Load += new System.EventHandler(this.Page_Load); ((System.ComponentModel.ISupportInitialize)(this.dataSet11)).EndInit(); }