/// <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.adpDetalles = new System.Data.OleDb.OleDbDataAdapter();
this.oleDbSelectCommand1 = new System.Data.OleDb.OleDbCommand();
this.conexion = new System.Data.OleDb.OleDbConnection();
this.ds = new otros_ingresos.DataSet1();
this.adpEncabezado = new System.Data.OleDb.OleDbDataAdapter();
this.oleDbSelectCommand2 = new System.Data.OleDb.OleDbCommand();
((System.ComponentModel.ISupportInitialize)(this.ds)).BeginInit();
//
// adpDetalles
//
this.adpDetalles.SelectCommand = this.oleDbSelectCommand1;
this.adpDetalles.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
new System.Data.Common.DataTableMapping("Table", "OTROS_INGRESOS", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("TDET_CCOD", "TDET_CCOD"),
new System.Data.Common.DataColumnMapping("TDET_TDESC", "TDET_TDESC"),
new System.Data.Common.DataColumnMapping("RECIBIDO_01", "RECIBIDO_01"),
new System.Data.Common.DataColumnMapping("RECIBIDO_02", "RECIBIDO_02"),
new System.Data.Common.DataColumnMapping("RECIBIDO_03", "RECIBIDO_03"),
new System.Data.Common.DataColumnMapping("RECIBIDO_04", "RECIBIDO_04"),
new System.Data.Common.DataColumnMapping("RECIBIDO_05", "RECIBIDO_05"),
new System.Data.Common.DataColumnMapping("RECIBIDO_06", "RECIBIDO_06"),
new System.Data.Common.DataColumnMapping("RECIBIDO_07", "RECIBIDO_07"),
new System.Data.Common.DataColumnMapping("RECIBIDO_08", "RECIBIDO_08"),
new System.Data.Common.DataColumnMapping("RECIBIDO_09", "RECIBIDO_09"),
new System.Data.Common.DataColumnMapping("RECIBIDO_10", "RECIBIDO_10"),
new System.Data.Common.DataColumnMapping("RECIBIDO_11", "RECIBIDO_11"),
new System.Data.Common.DataColumnMapping("RECIBIDO_12", "RECIBIDO_12"),
new System.Data.Common.DataColumnMapping("RECIBIDO_ANO", "RECIBIDO_ANO")
})
});
//
// oleDbSelectCommand1
//
this.oleDbSelectCommand1.CommandText = @"SELECT 0 AS TDET_CCOD, '' AS TDET_TDESC, 0 AS RECIBIDO_01, 0 AS RECIBIDO_02, 0 AS RECIBIDO_03, 0 AS RECIBIDO_04, 0 AS RECIBIDO_05, 0 AS RECIBIDO_06, 0 AS RECIBIDO_07, 0 AS RECIBIDO_08, 0 AS RECIBIDO_09, 0 AS RECIBIDO_10, 0 AS RECIBIDO_11, 0 AS RECIBIDO_12, 0 AS RECIBIDO_ANO FROM DUAL";
this.oleDbSelectCommand1.Connection = this.conexion;
//
// conexion
//
this.conexion.ConnectionString = ((string)(configurationAppSettings.GetValue("cadenaConexion", typeof(string))));
//
// ds
//
this.ds.DataSetName = "DataSet1";
this.ds.Locale = new System.Globalization.CultureInfo("es-CL");
this.ds.Namespace = "http://www.tempuri.org/DataSet1.xsd";
//
// adpEncabezado
//
this.adpEncabezado.SelectCommand = this.oleDbSelectCommand2;
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("SEDE_TDESC", "SEDE_TDESC"),
new System.Data.Common.DataColumnMapping("ANOS_CCOD", "ANOS_CCOD"),
new System.Data.Common.DataColumnMapping("SEDE_CCOD", "SEDE_CCOD")
})
});
//
// oleDbSelectCommand2
//
this.oleDbSelectCommand2.CommandText = "SELECT A.SEDE_TDESC, B.ANOS_CCOD, A.SEDE_CCOD FROM SEDES A, ANOS B WHERE (A.SEDE_" +
"CCOD = ?) AND (B.ANOS_CCOD = ?)";
this.oleDbSelectCommand2.Connection = this.conexion;
this.oleDbSelectCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("SEDE_CCOD", System.Data.OleDb.OleDbType.Decimal, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(3)), ((System.Byte)(0)), "SEDE_CCOD", System.Data.DataRowVersion.Current, null));
this.oleDbSelectCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("ANOS_CCOD", System.Data.OleDb.OleDbType.Decimal, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(4)), ((System.Byte)(0)), "ANOS_CCOD", 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.adpDetalles = new System.Data.OleDb.OleDbDataAdapter();
this.oleDbSelectCommand1 = new System.Data.OleDb.OleDbCommand();
this.conexion = new System.Data.OleDb.OleDbConnection();
this.ds = new otros_ingresos.DataSet1();
this.adpEncabezado = new System.Data.OleDb.OleDbDataAdapter();
this.oleDbSelectCommand2 = new System.Data.OleDb.OleDbCommand();
((System.ComponentModel.ISupportInitialize)(this.ds)).BeginInit();
//
// adpDetalles
//
this.adpDetalles.SelectCommand = this.oleDbSelectCommand1;
this.adpDetalles.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
new System.Data.Common.DataTableMapping("Table", "OTROS_INGRESOS", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("TDET_CCOD", "TDET_CCOD"),
new System.Data.Common.DataColumnMapping("TDET_TDESC", "TDET_TDESC"),
new System.Data.Common.DataColumnMapping("RECIBIDO_01", "RECIBIDO_01"),
new System.Data.Common.DataColumnMapping("RECIBIDO_02", "RECIBIDO_02"),
new System.Data.Common.DataColumnMapping("RECIBIDO_03", "RECIBIDO_03"),
new System.Data.Common.DataColumnMapping("RECIBIDO_04", "RECIBIDO_04"),
new System.Data.Common.DataColumnMapping("RECIBIDO_05", "RECIBIDO_05"),
new System.Data.Common.DataColumnMapping("RECIBIDO_06", "RECIBIDO_06"),
new System.Data.Common.DataColumnMapping("RECIBIDO_07", "RECIBIDO_07"),
new System.Data.Common.DataColumnMapping("RECIBIDO_08", "RECIBIDO_08"),
new System.Data.Common.DataColumnMapping("RECIBIDO_09", "RECIBIDO_09"),
new System.Data.Common.DataColumnMapping("RECIBIDO_10", "RECIBIDO_10"),
new System.Data.Common.DataColumnMapping("RECIBIDO_11", "RECIBIDO_11"),
new System.Data.Common.DataColumnMapping("RECIBIDO_12", "RECIBIDO_12"),
new System.Data.Common.DataColumnMapping("RECIBIDO_ANO", "RECIBIDO_ANO")})});
//
// oleDbSelectCommand1
//
this.oleDbSelectCommand1.CommandText = @"SELECT 0 AS TDET_CCOD, '' AS TDET_TDESC, 0 AS RECIBIDO_01, 0 AS RECIBIDO_02, 0 AS RECIBIDO_03, 0 AS RECIBIDO_04, 0 AS RECIBIDO_05, 0 AS RECIBIDO_06, 0 AS RECIBIDO_07, 0 AS RECIBIDO_08, 0 AS RECIBIDO_09, 0 AS RECIBIDO_10, 0 AS RECIBIDO_11, 0 AS RECIBIDO_12, 0 AS RECIBIDO_ANO FROM DUAL";
this.oleDbSelectCommand1.Connection = this.conexion;
//
// conexion
//
this.conexion.ConnectionString = ((string)(configurationAppSettings.GetValue("cadenaConexion", typeof(string))));
//
// ds
//
this.ds.DataSetName = "DataSet1";
this.ds.Locale = new System.Globalization.CultureInfo("es-CL");
this.ds.Namespace = "http://www.tempuri.org/DataSet1.xsd";
//
// adpEncabezado
//
this.adpEncabezado.SelectCommand = this.oleDbSelectCommand2;
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("SEDE_TDESC", "SEDE_TDESC"),
new System.Data.Common.DataColumnMapping("ANOS_CCOD", "ANOS_CCOD"),
new System.Data.Common.DataColumnMapping("SEDE_CCOD", "SEDE_CCOD")})});
//
// oleDbSelectCommand2
//
this.oleDbSelectCommand2.CommandText = "SELECT A.SEDE_TDESC, B.ANOS_CCOD, A.SEDE_CCOD FROM SEDES A, ANOS B WHERE (A.SEDE_" +
"CCOD = ?) AND (B.ANOS_CCOD = ?)";
this.oleDbSelectCommand2.Connection = this.conexion;
this.oleDbSelectCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("SEDE_CCOD", System.Data.OleDb.OleDbType.Decimal, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(3)), ((System.Byte)(0)), "SEDE_CCOD", System.Data.DataRowVersion.Current, null));
this.oleDbSelectCommand2.Parameters.Add(new System.Data.OleDb.OleDbParameter("ANOS_CCOD", System.Data.OleDb.OleDbType.Decimal, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(4)), ((System.Byte)(0)), "ANOS_CCOD", System.Data.DataRowVersion.Current, null));
this.Load += new System.EventHandler(this.Page_Load);
((System.ComponentModel.ISupportInitialize)(this.ds)).EndInit();
}
