/// <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.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(Copia));
System.Configuration.AppSettingsReader configurationAppSettings = new System.Configuration.AppSettingsReader();
this.panel1 = new System.Windows.Forms.Panel();
this.btnVistaPrevia = new Soluciones2000.Tools.WinLib.tbBtn();
this.txtIdObra = new System.Windows.Forms.TextBox();
this.label3 = new System.Windows.Forms.Label();
this.label1 = new System.Windows.Forms.Label();
this.label2 = new System.Windows.Forms.Label();
this.cmbIdObraO = new System.Windows.Forms.ComboBox();
this.dsBuscaObra1 = new LancNeo.dsBuscaObra();
this.dsBuscaObra2 = new LancNeo.dsBuscaObra();
this.sqlConn = new System.Data.SqlClient.SqlConnection();
this.sqlDABusObraO = new System.Data.SqlClient.SqlDataAdapter();
this.sqlCommand1 = new System.Data.SqlClient.SqlCommand();
this.sqlDABusObraD = new System.Data.SqlClient.SqlDataAdapter();
this.sqlCommand2 = new System.Data.SqlClient.SqlCommand();
this.sqlComCopia = new System.Data.SqlClient.SqlCommand();
this.panel2 = new System.Windows.Forms.Panel();
this.tbBtn1 = new Soluciones2000.Tools.WinLib.tbBtn();
this.txtBuscar = new System.Windows.Forms.TextBox();
this.label5 = new System.Windows.Forms.Label();
this.cmbRes = new System.Windows.Forms.ComboBox();
this.dsBusResistencia1 = new LancNeo.dsBusResistencia();
this.label6 = new System.Windows.Forms.Label();
this.label4 = new System.Windows.Forms.Label();
this.sqlDARes = new System.Data.SqlClient.SqlDataAdapter();
this.sqlSelectCommand7 = new System.Data.SqlClient.SqlCommand();
this.sqlComRemplaza = new System.Data.SqlClient.SqlCommand();
this.panel1.SuspendLayout();
((System.ComponentModel.ISupportInitialize)(this.dsBuscaObra1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.dsBuscaObra2)).BeginInit();
this.panel2.SuspendLayout();
((System.ComponentModel.ISupportInitialize)(this.dsBusResistencia1)).BeginInit();
this.SuspendLayout();
//
// panel1
//
this.panel1.BackColor = System.Drawing.SystemColors.Highlight;
this.panel1.Controls.Add(this.btnVistaPrevia);
this.panel1.Controls.Add(this.txtIdObra);
this.panel1.Controls.Add(this.label3);
this.panel1.Controls.Add(this.label1);
this.panel1.Controls.Add(this.label2);
this.panel1.Controls.Add(this.cmbIdObraO);
this.panel1.Dock = System.Windows.Forms.DockStyle.Top;
this.panel1.Location = new System.Drawing.Point(0, 0);
this.panel1.Name = "panel1";
this.panel1.Size = new System.Drawing.Size(552, 72);
this.panel1.TabIndex = 0;
//
// btnVistaPrevia
//
this.btnVistaPrevia.BackColor = System.Drawing.Color.Transparent;
this.btnVistaPrevia.Icon = ((System.Drawing.Icon)(resources.GetObject("btnVistaPrevia.Icon")));
this.btnVistaPrevia.Location = new System.Drawing.Point(478, 4);
this.btnVistaPrevia.Name = "btnVistaPrevia";
this.btnVistaPrevia.Size = new System.Drawing.Size(64, 64);
this.btnVistaPrevia.TabIndex = 13;
this.btnVistaPrevia.Click += new System.EventHandler(this.btnVistaPrevia_Click);
//
// txtIdObra
//
this.txtIdObra.Location = new System.Drawing.Point(284, 44);
this.txtIdObra.Name = "txtIdObra";
this.txtIdObra.Size = new System.Drawing.Size(80, 20);
this.txtIdObra.TabIndex = 15;
//
// label3
//
this.label3.AutoSize = true;
this.label3.Font = new System.Drawing.Font("Microsoft Sans Serif", 14F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
this.label3.ForeColor = System.Drawing.Color.White;
this.label3.Location = new System.Drawing.Point(4, 4);
this.label3.Name = "label3";
this.label3.Size = new System.Drawing.Size(142, 24);
this.label3.TabIndex = 14;
this.label3.Text = "Copia de obra";
//
// label1
//
this.label1.AutoSize = true;
this.label1.ForeColor = System.Drawing.Color.White;
this.label1.Location = new System.Drawing.Point(205, 44);
this.label1.Name = "label1";
this.label1.Size = new System.Drawing.Size(70, 13);
this.label1.TabIndex = 12;
this.label1.Text = "Obra destino:";
this.label1.TextAlign = System.Drawing.ContentAlignment.TopRight;
//
// label2
//
this.label2.AutoSize = true;
this.label2.ForeColor = System.Drawing.Color.White;
this.label2.Location = new System.Drawing.Point(210, 16);
this.label2.Name = "label2";
this.label2.Size = new System.Drawing.Size(65, 13);
this.label2.TabIndex = 10;
this.label2.Text = "Obra origen:";
this.label2.TextAlign = System.Drawing.ContentAlignment.TopRight;
//
// cmbIdObraO
//
this.cmbIdObraO.DataSource = this.dsBuscaObra1.Obra;
this.cmbIdObraO.DisplayMember = "Idobra";
this.cmbIdObraO.Location = new System.Drawing.Point(284, 14);
this.cmbIdObraO.Name = "cmbIdObraO";
this.cmbIdObraO.Size = new System.Drawing.Size(80, 21);
this.cmbIdObraO.TabIndex = 9;
this.cmbIdObraO.ValueMember = "IdObra";
//
// dsBuscaObra1
//
this.dsBuscaObra1.DataSetName = "dsBuscaObra";
this.dsBuscaObra1.Locale = new System.Globalization.CultureInfo("es-MX");
this.dsBuscaObra1.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema;
//
// dsBuscaObra2
//
this.dsBuscaObra2.DataSetName = "dsBuscaObra";
this.dsBuscaObra2.Locale = new System.Globalization.CultureInfo("es-MX");
this.dsBuscaObra2.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema;
//
// sqlConn
//
this.sqlConn.ConnectionString = ((string)(configurationAppSettings.GetValue("sqlConn.ConnectionString", typeof(string))));
this.sqlConn.FireInfoMessageEventOnUserErrors = false;
//
// sqlDABusObraO
//
this.sqlDABusObraO.SelectCommand = this.sqlCommand1;
this.sqlDABusObraO.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
new System.Data.Common.DataTableMapping("Table", "Obra", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("Idobra", "Idobra"),
new System.Data.Common.DataColumnMapping("Ubicacion", "Ubicacion"),
new System.Data.Common.DataColumnMapping("RFC", "RFC"),
new System.Data.Common.DataColumnMapping("Facturar", "Facturar")
})
});
//
// sqlCommand1
//
this.sqlCommand1.CommandText = resources.GetString("sqlCommand1.CommandText");
this.sqlCommand1.Connection = this.sqlConn;
//
// sqlDABusObraD
//
this.sqlDABusObraD.SelectCommand = this.sqlCommand2;
this.sqlDABusObraD.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
new System.Data.Common.DataTableMapping("Table", "Obra", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("Idobra", "Idobra"),
new System.Data.Common.DataColumnMapping("Ubicacion", "Ubicacion"),
new System.Data.Common.DataColumnMapping("RFC", "RFC"),
new System.Data.Common.DataColumnMapping("Facturar", "Facturar")
})
});
//
// sqlCommand2
//
this.sqlCommand2.CommandText = resources.GetString("sqlCommand2.CommandText");
this.sqlCommand2.Connection = this.sqlConn;
//
// sqlComCopia
//
this.sqlComCopia.CommandText = "[copia]";
this.sqlComCopia.CommandType = System.Data.CommandType.StoredProcedure;
this.sqlComCopia.Connection = this.sqlConn;
this.sqlComCopia.Parameters.AddRange(new System.Data.SqlClient.SqlParameter[] {
new System.Data.SqlClient.SqlParameter("@RETURN_VALUE", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.ReturnValue, false, ((byte)(0)), ((byte)(0)), "", System.Data.DataRowVersion.Current, null),
new System.Data.SqlClient.SqlParameter("@IdObraOrigen", System.Data.SqlDbType.NVarChar, 6),
new System.Data.SqlClient.SqlParameter("@IdObraDestino", System.Data.SqlDbType.NVarChar, 6)
});
//
// panel2
//
this.panel2.BorderStyle = System.Windows.Forms.BorderStyle.Fixed3D;
this.panel2.Controls.Add(this.tbBtn1);
this.panel2.Controls.Add(this.txtBuscar);
this.panel2.Controls.Add(this.label5);
this.panel2.Controls.Add(this.cmbRes);
this.panel2.Controls.Add(this.label6);
this.panel2.Controls.Add(this.label4);
this.panel2.Dock = System.Windows.Forms.DockStyle.Bottom;
this.panel2.Location = new System.Drawing.Point(0, 89);
this.panel2.Name = "panel2";
this.panel2.Size = new System.Drawing.Size(552, 100);
this.panel2.TabIndex = 1;
this.panel2.Visible = false;
//
// tbBtn1
//
this.tbBtn1.BackColor = System.Drawing.Color.Transparent;
this.tbBtn1.Icon = ((System.Drawing.Icon)(resources.GetObject("tbBtn1.Icon")));
this.tbBtn1.Location = new System.Drawing.Point(478, 4);
this.tbBtn1.Name = "tbBtn1";
this.tbBtn1.Size = new System.Drawing.Size(64, 64);
this.tbBtn1.TabIndex = 43;
this.tbBtn1.Click += new System.EventHandler(this.tbBtn1_Click);
//
// txtBuscar
//
this.txtBuscar.Location = new System.Drawing.Point(282, 40);
this.txtBuscar.Name = "txtBuscar";
this.txtBuscar.Size = new System.Drawing.Size(174, 20);
this.txtBuscar.TabIndex = 42;
//
// label5
//
this.label5.AutoSize = true;
this.label5.ForeColor = System.Drawing.Color.White;
this.label5.Location = new System.Drawing.Point(234, 42);
this.label5.Name = "label5";
this.label5.Size = new System.Drawing.Size(43, 13);
this.label5.TabIndex = 41;
this.label5.Text = "Buscar:";
this.label5.TextAlign = System.Drawing.ContentAlignment.TopRight;
//
// cmbRes
//
this.cmbRes.DataSource = this.dsBusResistencia1.Resistencia;
this.cmbRes.DisplayMember = "Resistencia";
this.cmbRes.Location = new System.Drawing.Point(282, 64);
this.cmbRes.Name = "cmbRes";
this.cmbRes.Size = new System.Drawing.Size(64, 21);
this.cmbRes.TabIndex = 40;
this.cmbRes.ValueMember = "ResistenciaKG";
//
// dsBusResistencia1
//
this.dsBusResistencia1.DataSetName = "dsBusResistencia";
this.dsBusResistencia1.Locale = new System.Globalization.CultureInfo("es-MX");
this.dsBusResistencia1.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema;
//
// label6
//
this.label6.AutoSize = true;
this.label6.ForeColor = System.Drawing.Color.White;
this.label6.Location = new System.Drawing.Point(158, 66);
this.label6.Name = "label6";
this.label6.Size = new System.Drawing.Size(114, 13);
this.label6.TabIndex = 18;
this.label6.Text = "Resistencia resultante:";
this.label6.TextAlign = System.Drawing.ContentAlignment.TopRight;
//
// label4
//
this.label4.AutoSize = true;
this.label4.Font = new System.Drawing.Font("Microsoft Sans Serif", 14F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
this.label4.ForeColor = System.Drawing.Color.White;
this.label4.Location = new System.Drawing.Point(4, 4);
this.label4.Name = "label4";
this.label4.Size = new System.Drawing.Size(258, 24);
this.label4.TabIndex = 15;
this.label4.Text = "Sustitución de resistencias";
//
// sqlDARes
//
this.sqlDARes.SelectCommand = this.sqlSelectCommand7;
this.sqlDARes.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
new System.Data.Common.DataTableMapping("Table", "Resistencia", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("ResistenciaKG", "ResistenciaKG"),
new System.Data.Common.DataColumnMapping("ResistenciaMPa", "ResistenciaMPa")
})
});
//
// sqlSelectCommand7
//
this.sqlSelectCommand7.CommandText = "SELECT ResistenciaKG, STR(ResistenciaKG) AS Resistencia FROM Resistencia";
this.sqlSelectCommand7.Connection = this.sqlConn;
//
// sqlComRemplaza
//
this.sqlComRemplaza.CommandText = "[Remplaza]";
this.sqlComRemplaza.CommandType = System.Data.CommandType.StoredProcedure;
this.sqlComRemplaza.Connection = this.sqlConn;
this.sqlComRemplaza.Parameters.AddRange(new System.Data.SqlClient.SqlParameter[] {
new System.Data.SqlClient.SqlParameter("@RETURN_VALUE", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.ReturnValue, false, ((byte)(0)), ((byte)(0)), "", System.Data.DataRowVersion.Current, null),
new System.Data.SqlClient.SqlParameter("@Busca", System.Data.SqlDbType.NVarChar, 20),
new System.Data.SqlClient.SqlParameter("@IdObraDestino", System.Data.SqlDbType.NVarChar, 6),
new System.Data.SqlClient.SqlParameter("@Resistencia", System.Data.SqlDbType.Real, 4)
});
//
// Copia
//
this.AutoScaleBaseSize = new System.Drawing.Size(5, 13);
this.BackColor = System.Drawing.SystemColors.Highlight;
this.ClientSize = new System.Drawing.Size(552, 189);
this.Controls.Add(this.panel2);
this.Controls.Add(this.panel1);
this.MaximizeBox = false;
this.MinimizeBox = false;
this.Name = "Copia";
this.StartPosition = System.Windows.Forms.FormStartPosition.CenterScreen;
this.Text = "Copia";
this.Load += new System.EventHandler(this.Copia_Load);
this.panel1.ResumeLayout(false);
this.panel1.PerformLayout();
((System.ComponentModel.ISupportInitialize)(this.dsBuscaObra1)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.dsBuscaObra2)).EndInit();
this.panel2.ResumeLayout(false);
this.panel2.PerformLayout();
((System.ComponentModel.ISupportInitialize)(this.dsBusResistencia1)).EndInit();
this.ResumeLayout(false);
}
/// <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.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(Procesa));
System.Configuration.AppSettingsReader configurationAppSettings = new System.Configuration.AppSettingsReader();
this.panel1 = new System.Windows.Forms.Panel();
this.tbBtn1 = new Soluciones2000.Tools.WinLib.tbBtn();
this.btnVistaPrevia = new Soluciones2000.Tools.WinLib.tbBtn();
this.txtFIMin = new System.Windows.Forms.TextBox();
this.txtFIMax = new System.Windows.Forms.TextBox();
this.dtpPFf = new System.Windows.Forms.DateTimePicker();
this.label7 = new System.Windows.Forms.Label();
this.label6 = new System.Windows.Forms.Label();
this.dtpPFi = new System.Windows.Forms.DateTimePicker();
this.label5 = new System.Windows.Forms.Label();
this.dtpFin = new System.Windows.Forms.DateTimePicker();
this.label4 = new System.Windows.Forms.Label();
this.dtpIni = new System.Windows.Forms.DateTimePicker();
this.label1 = new System.Windows.Forms.Label();
this.Fecha = new System.Windows.Forms.Label();
this.cbkPrefijo = new System.Windows.Forms.CheckBox();
this.label3 = new System.Windows.Forms.Label();
this.label2 = new System.Windows.Forms.Label();
this.cmbIdObraO = new System.Windows.Forms.ComboBox();
this.dsBuscaObra1 = new LancNeo.dsBuscaObra();
this.txtIdobra = new System.Windows.Forms.TextBox();
this.sqlComAgrega = new System.Data.SqlClient.SqlCommand();
this.sqlConn = new System.Data.SqlClient.SqlConnection();
this.sqlDABusObraO = new System.Data.SqlClient.SqlDataAdapter();
this.sqlCommand1 = new System.Data.SqlClient.SqlCommand();
this.sqlComAgregaP = new System.Data.SqlClient.SqlCommand();
this.panel1.SuspendLayout();
((System.ComponentModel.ISupportInitialize)(this.dsBuscaObra1)).BeginInit();
this.SuspendLayout();
//
// panel1
//
this.panel1.BackColor = System.Drawing.SystemColors.Highlight;
this.panel1.BorderStyle = System.Windows.Forms.BorderStyle.Fixed3D;
this.panel1.Controls.Add(this.tbBtn1);
this.panel1.Controls.Add(this.btnVistaPrevia);
this.panel1.Controls.Add(this.txtFIMin);
this.panel1.Controls.Add(this.txtFIMax);
this.panel1.Controls.Add(this.dtpPFf);
this.panel1.Controls.Add(this.label7);
this.panel1.Controls.Add(this.label6);
this.panel1.Controls.Add(this.dtpPFi);
this.panel1.Controls.Add(this.label5);
this.panel1.Controls.Add(this.dtpFin);
this.panel1.Controls.Add(this.label4);
this.panel1.Controls.Add(this.dtpIni);
this.panel1.Controls.Add(this.label1);
this.panel1.Controls.Add(this.Fecha);
this.panel1.Controls.Add(this.cbkPrefijo);
this.panel1.Controls.Add(this.label3);
this.panel1.Controls.Add(this.label2);
this.panel1.Controls.Add(this.cmbIdObraO);
this.panel1.Controls.Add(this.txtIdobra);
this.panel1.Dock = System.Windows.Forms.DockStyle.Top;
this.panel1.Location = new System.Drawing.Point(0, 0);
this.panel1.Name = "panel1";
this.panel1.Size = new System.Drawing.Size(942, 192);
this.panel1.TabIndex = 1;
this.panel1.Paint += new System.Windows.Forms.PaintEventHandler(this.panel1_Paint);
//
// tbBtn1
//
this.tbBtn1.BackColor = System.Drawing.Color.Transparent;
this.tbBtn1.Icon = ((System.Drawing.Icon)(resources.GetObject("tbBtn1.Icon")));
this.tbBtn1.Location = new System.Drawing.Point(692, 86);
this.tbBtn1.Name = "tbBtn1";
this.tbBtn1.Size = new System.Drawing.Size(64, 64);
this.tbBtn1.TabIndex = 49;
this.tbBtn1.Click += new System.EventHandler(this.tbBtn1_Click);
//
// btnVistaPrevia
//
this.btnVistaPrevia.BackColor = System.Drawing.Color.Transparent;
this.btnVistaPrevia.Icon = ((System.Drawing.Icon)(resources.GetObject("btnVistaPrevia.Icon")));
this.btnVistaPrevia.Location = new System.Drawing.Point(692, 2);
this.btnVistaPrevia.Name = "btnVistaPrevia";
this.btnVistaPrevia.Size = new System.Drawing.Size(64, 64);
this.btnVistaPrevia.TabIndex = 13;
this.btnVistaPrevia.Click += new System.EventHandler(this.btnVistaPrevia_Click);
//
// txtFIMin
//
this.txtFIMin.Enabled = false;
this.txtFIMin.Location = new System.Drawing.Point(584, 123);
this.txtFIMin.Name = "txtFIMin";
this.txtFIMin.Size = new System.Drawing.Size(84, 20);
this.txtFIMin.TabIndex = 51;
//
// txtFIMax
//
this.txtFIMax.Enabled = false;
this.txtFIMax.Location = new System.Drawing.Point(584, 94);
this.txtFIMax.Name = "txtFIMax";
this.txtFIMax.Size = new System.Drawing.Size(84, 20);
this.txtFIMax.TabIndex = 50;
//
// dtpPFf
//
this.dtpPFf.Enabled = false;
this.dtpPFf.Format = System.Windows.Forms.DateTimePickerFormat.Short;
this.dtpPFf.Location = new System.Drawing.Point(466, 120);
this.dtpPFf.Name = "dtpPFf";
this.dtpPFf.Size = new System.Drawing.Size(84, 20);
this.dtpPFf.TabIndex = 47;
//
// label7
//
this.label7.AutoSize = true;
this.label7.Location = new System.Drawing.Point(438, 122);
this.label7.Name = "label7";
this.label7.Size = new System.Drawing.Size(32, 13);
this.label7.TabIndex = 48;
this.label7.Text = "Final:";
//
// label6
//
this.label6.AutoSize = true;
this.label6.Location = new System.Drawing.Point(323, 120);
this.label6.Name = "label6";
this.label6.Size = new System.Drawing.Size(155, 13);
this.label6.TabIndex = 46;
this.label6.Text = "Fechas de NUEVOS PRECIOS";
//
// dtpPFi
//
this.dtpPFi.Format = System.Windows.Forms.DateTimePickerFormat.Short;
this.dtpPFi.Location = new System.Drawing.Point(465, 95);
this.dtpPFi.Name = "dtpPFi";
this.dtpPFi.Size = new System.Drawing.Size(84, 20);
this.dtpPFi.TabIndex = 44;
this.dtpPFi.ValueChanged += new System.EventHandler(this.dtpPFi_ValueChanged);
//
// label5
//
this.label5.AutoSize = true;
this.label5.Location = new System.Drawing.Point(429, 97);
this.label5.Name = "label5";
this.label5.Size = new System.Drawing.Size(37, 13);
this.label5.TabIndex = 45;
this.label5.Text = "Inicial:";
//
// dtpFin
//
this.dtpFin.Format = System.Windows.Forms.DateTimePickerFormat.Short;
this.dtpFin.Location = new System.Drawing.Point(584, 42);
this.dtpFin.Name = "dtpFin";
this.dtpFin.Size = new System.Drawing.Size(84, 20);
this.dtpFin.TabIndex = 40;
//
// label4
//
this.label4.AutoSize = true;
this.label4.ForeColor = System.Drawing.Color.White;
this.label4.Location = new System.Drawing.Point(556, 44);
this.label4.Name = "label4";
this.label4.Size = new System.Drawing.Size(32, 13);
this.label4.TabIndex = 42;
this.label4.Text = "Final:";
//
// dtpIni
//
this.dtpIni.Format = System.Windows.Forms.DateTimePickerFormat.Short;
this.dtpIni.Location = new System.Drawing.Point(584, 8);
this.dtpIni.Name = "dtpIni";
this.dtpIni.Size = new System.Drawing.Size(84, 20);
this.dtpIni.TabIndex = 38;
//
// label1
//
this.label1.AutoSize = true;
this.label1.ForeColor = System.Drawing.Color.White;
this.label1.Location = new System.Drawing.Point(548, 10);
this.label1.Name = "label1";
this.label1.Size = new System.Drawing.Size(37, 13);
this.label1.TabIndex = 41;
this.label1.Text = "Inicial:";
//
// Fecha
//
this.Fecha.AutoSize = true;
this.Fecha.ForeColor = System.Drawing.Color.White;
this.Fecha.Location = new System.Drawing.Point(452, 26);
this.Fecha.Name = "Fecha";
this.Fecha.Size = new System.Drawing.Size(95, 13);
this.Fecha.TabIndex = 39;
this.Fecha.Text = "Fechas de periodo";
//
// cbkPrefijo
//
this.cbkPrefijo.ForeColor = System.Drawing.Color.White;
this.cbkPrefijo.Location = new System.Drawing.Point(366, 40);
this.cbkPrefijo.Name = "cbkPrefijo";
this.cbkPrefijo.Size = new System.Drawing.Size(74, 24);
this.cbkPrefijo.TabIndex = 37;
this.cbkPrefijo.Text = "No prefijo";
//
// label3
//
this.label3.Font = new System.Drawing.Font("Microsoft Sans Serif", 14F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
this.label3.ForeColor = System.Drawing.Color.White;
this.label3.Location = new System.Drawing.Point(4, 4);
this.label3.Name = "label3";
this.label3.Size = new System.Drawing.Size(290, 82);
this.label3.TabIndex = 14;
this.label3.Text = "Acumula y agrupa los servicios de todos los informes";
//
// label2
//
this.label2.AutoSize = true;
this.label2.Location = new System.Drawing.Point(332, 10);
this.label2.Name = "label2";
this.label2.Size = new System.Drawing.Size(33, 13);
this.label2.TabIndex = 10;
this.label2.Text = "Obra:";
this.label2.TextAlign = System.Drawing.ContentAlignment.TopRight;
//
// cmbIdObraO
//
this.cmbIdObraO.DataSource = this.dsBuscaObra1.Obra;
this.cmbIdObraO.DisplayMember = "Idobra";
this.cmbIdObraO.Location = new System.Drawing.Point(366, 8);
this.cmbIdObraO.Name = "cmbIdObraO";
this.cmbIdObraO.Size = new System.Drawing.Size(80, 21);
this.cmbIdObraO.TabIndex = 9;
this.cmbIdObraO.ValueMember = "IdObra";
this.cmbIdObraO.SelectedIndexChanged += new System.EventHandler(this.cmbIdObraO_SelectedIndexChanged);
//
// dsBuscaObra1
//
this.dsBuscaObra1.DataSetName = "dsBuscaObra";
this.dsBuscaObra1.Locale = new System.Globalization.CultureInfo("es-MX");
this.dsBuscaObra1.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema;
//
// txtIdobra
//
this.txtIdobra.Location = new System.Drawing.Point(378, 10);
this.txtIdobra.Name = "txtIdobra";
this.txtIdobra.ReadOnly = true;
this.txtIdobra.Size = new System.Drawing.Size(48, 20);
this.txtIdobra.TabIndex = 43;
this.txtIdobra.Visible = false;
//
// sqlComAgrega
//
this.sqlComAgrega.CommandText = "[agregaconcentra]";
this.sqlComAgrega.CommandType = System.Data.CommandType.StoredProcedure;
this.sqlComAgrega.Connection = this.sqlConn;
this.sqlComAgrega.Parameters.AddRange(new System.Data.SqlClient.SqlParameter[] {
new System.Data.SqlClient.SqlParameter("@RETURN_VALUE", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.ReturnValue, false, ((byte)(0)), ((byte)(0)), "", System.Data.DataRowVersion.Current, null),
new System.Data.SqlClient.SqlParameter("@IdObra", System.Data.SqlDbType.NVarChar, 6),
new System.Data.SqlClient.SqlParameter("@FIni", System.Data.SqlDbType.DateTime, 8),
new System.Data.SqlClient.SqlParameter("@FFin", System.Data.SqlDbType.DateTime, 8)
});
//
// sqlConn
//
this.sqlConn.ConnectionString = ((string)(configurationAppSettings.GetValue("sqlConn.ConnectionString", typeof(string))));
this.sqlConn.FireInfoMessageEventOnUserErrors = false;
//
// sqlDABusObraO
//
this.sqlDABusObraO.SelectCommand = this.sqlCommand1;
this.sqlDABusObraO.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
new System.Data.Common.DataTableMapping("Table", "Obra", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("Idobra", "Idobra"),
new System.Data.Common.DataColumnMapping("Ubicacion", "Ubicacion"),
new System.Data.Common.DataColumnMapping("RFC", "RFC"),
new System.Data.Common.DataColumnMapping("Facturar", "Facturar")
})
});
//
// sqlCommand1
//
this.sqlCommand1.CommandText = resources.GetString("sqlCommand1.CommandText");
this.sqlCommand1.Connection = this.sqlConn;
//
// sqlComAgregaP
//
this.sqlComAgregaP.CommandText = "[actualizaprecios]";
this.sqlComAgregaP.CommandType = System.Data.CommandType.StoredProcedure;
this.sqlComAgregaP.Connection = this.sqlConn;
this.sqlComAgregaP.Parameters.AddRange(new System.Data.SqlClient.SqlParameter[] {
new System.Data.SqlClient.SqlParameter("@RETURN_VALUE", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.ReturnValue, false, ((byte)(0)), ((byte)(0)), "", System.Data.DataRowVersion.Current, null),
new System.Data.SqlClient.SqlParameter("@FfMax", System.Data.SqlDbType.SmallDateTime, 4),
new System.Data.SqlClient.SqlParameter("@FfMin", System.Data.SqlDbType.SmallDateTime, 4),
new System.Data.SqlClient.SqlParameter("@FiMax", System.Data.SqlDbType.SmallDateTime, 4),
new System.Data.SqlClient.SqlParameter("@FiMin", System.Data.SqlDbType.SmallDateTime, 4)
});
//
// Procesa
//
this.AutoScaleBaseSize = new System.Drawing.Size(5, 13);
this.BackColor = System.Drawing.SystemColors.HighlightText;
this.ClientSize = new System.Drawing.Size(942, 204);
this.Controls.Add(this.panel1);
this.MaximizeBox = false;
this.MinimizeBox = false;
this.Name = "Procesa";
this.Text = "Procesa servicios";
this.Load += new System.EventHandler(this.Procesa_Load);
this.panel1.ResumeLayout(false);
this.panel1.PerformLayout();
((System.ComponentModel.ISupportInitialize)(this.dsBuscaObra1)).EndInit();
this.ResumeLayout(false);
}
/// <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();
System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(RepPromedios));
this.sqlConn = new System.Data.SqlClient.SqlConnection();
this.sqlDAUnidad = new System.Data.SqlClient.SqlDataAdapter();
this.sqlSelectCommand1 = new System.Data.SqlClient.SqlCommand();
this.sqlDAConcretera = new System.Data.SqlClient.SqlDataAdapter();
this.sqlSelectCommand5 = new System.Data.SqlClient.SqlCommand();
this.sqlDAPLanta = new System.Data.SqlClient.SqlDataAdapter();
this.sqlSelectCommand6 = new System.Data.SqlClient.SqlCommand();
this.sqlDABusObra = new System.Data.SqlClient.SqlDataAdapter();
this.sqlCommand1 = new System.Data.SqlClient.SqlCommand();
this.dsUnidad1 = new LancNeo.dsUnidad();
this.dsPlanta1 = new LancNeo.dsPlanta();
this.dsConcretera1 = new LancNeo.dsConcretera();
this.panel1 = new System.Windows.Forms.Panel();
this.buscaBtn1 = new Soluciones2000.Tools.WinLib.BuscaBtn();
this.dsConcreto1 = new LancNeo.dsConcreto();
this.btnVistaPrevia = new Soluciones2000.Tools.WinLib.tbBtn();
this.chbLab = new System.Windows.Forms.CheckBox();
this.cmbIdDiam = new System.Windows.Forms.ComboBox();
this.dsDiametro1 = new LancNeo.dsDiametro();
this.label14 = new System.Windows.Forms.Label();
this.textBox1 = new System.Windows.Forms.TextBox();
this.cbkPrefijo = new System.Windows.Forms.CheckBox();
this.label9 = new System.Windows.Forms.Label();
this.label8 = new System.Windows.Forms.Label();
this.cmbUnidad = new System.Windows.Forms.ComboBox();
this.label5 = new System.Windows.Forms.Label();
this.dtpFin = new System.Windows.Forms.DateTimePicker();
this.label4 = new System.Windows.Forms.Label();
this.dtpIni = new System.Windows.Forms.DateTimePicker();
this.label3 = new System.Windows.Forms.Label();
this.label2 = new System.Windows.Forms.Label();
this.cmbIdObra = new System.Windows.Forms.ComboBox();
this.dsBuscaObra1 = new LancNeo.dsBuscaObra();
this.label1 = new System.Windows.Forms.Label();
this.Fecha = new System.Windows.Forms.Label();
this.cmbConcretera = new System.Windows.Forms.ComboBox();
this.cmbPlanta = new System.Windows.Forms.ComboBox();
this.txtIdobra = new System.Windows.Forms.TextBox();
this.sqlDAConcreto = new System.Data.SqlClient.SqlDataAdapter();
this.sqlCommand2 = new System.Data.SqlClient.SqlCommand();
this.crvRepPromedios = new CrystalDecisions.Windows.Forms.CrystalReportViewer();
this.sqlDAPromedios = new System.Data.SqlClient.SqlDataAdapter();
this.sqlSelectCommand2 = new System.Data.SqlClient.SqlCommand();
this.dsPromedios1 = new LancNeo.dsPromedios();
this.cryRepPromedios1 = new LancNeo.CryRepPromedios();
this.dsMuestra1 = new LancNeo.dsMuestra();
this.sqlDADiametro = new System.Data.SqlClient.SqlDataAdapter();
this.sqlSelectCommand9 = new System.Data.SqlClient.SqlCommand();
this.sqlDATipo = new System.Data.SqlClient.SqlDataAdapter();
this.sqlSelectCommand11 = new System.Data.SqlClient.SqlCommand();
this.dsTipo1 = new LancNeo.dsTipo();
this.cmbTipo = new System.Windows.Forms.ComboBox();
((System.ComponentModel.ISupportInitialize)(this.dsUnidad1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.dsPlanta1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.dsConcretera1)).BeginInit();
this.panel1.SuspendLayout();
((System.ComponentModel.ISupportInitialize)(this.dsConcreto1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.dsDiametro1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.dsBuscaObra1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.dsPromedios1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.dsMuestra1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.dsTipo1)).BeginInit();
this.SuspendLayout();
//
// sqlConn
//
this.sqlConn.ConnectionString = ((string)(configurationAppSettings.GetValue("sqlConn.ConnectionString", typeof(string))));
this.sqlConn.FireInfoMessageEventOnUserErrors = false;
//
// sqlDAUnidad
//
this.sqlDAUnidad.SelectCommand = this.sqlSelectCommand1;
this.sqlDAUnidad.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
new System.Data.Common.DataTableMapping("Table", "Unidad", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("IdUnidad", "IdUnidad"),
new System.Data.Common.DataColumnMapping("Factor", "Factor"),
new System.Data.Common.DataColumnMapping("Undescr", "Undescr"),
new System.Data.Common.DataColumnMapping("MaxagrUn", "MaxagrUn"),
new System.Data.Common.DataColumnMapping("RevenUn", "RevenUn")
})
});
//
// sqlSelectCommand1
//
this.sqlSelectCommand1.CommandText = "SELECT IdUnidad, Factor, Undescr, MaxagrUn, RevenUn FROM Unidad";
this.sqlSelectCommand1.Connection = this.sqlConn;
//
// sqlDAConcretera
//
this.sqlDAConcretera.SelectCommand = this.sqlSelectCommand5;
this.sqlDAConcretera.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
new System.Data.Common.DataTableMapping("Table", "Concretera", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("IdConcretera", "IdConcretera"),
new System.Data.Common.DataColumnMapping("Concretera", "Concretera"),
new System.Data.Common.DataColumnMapping("Direccion", "Direccion")
})
});
//
// sqlSelectCommand5
//
this.sqlSelectCommand5.CommandText = "SELECT IdConcretera, Concretera, Direccion FROM Concretera";
this.sqlSelectCommand5.Connection = this.sqlConn;
//
// sqlDAPLanta
//
this.sqlDAPLanta.SelectCommand = this.sqlSelectCommand6;
this.sqlDAPLanta.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
new System.Data.Common.DataTableMapping("Table", "Planta", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("IdConcretera", "IdConcretera"),
new System.Data.Common.DataColumnMapping("IdPlanta", "IdPlanta"),
new System.Data.Common.DataColumnMapping("Planta", "Planta")
})
});
//
// sqlSelectCommand6
//
this.sqlSelectCommand6.CommandText = "SELECT IdConcretera, IdPlanta, Planta FROM Planta WHERE (IdConcretera LIKE @IdCon" +
"cretera)";
this.sqlSelectCommand6.Connection = this.sqlConn;
this.sqlSelectCommand6.Parameters.AddRange(new System.Data.SqlClient.SqlParameter[] {
new System.Data.SqlClient.SqlParameter("@IdConcretera", System.Data.SqlDbType.NVarChar, 10, "IdConcretera")
});
//
// sqlDABusObra
//
this.sqlDABusObra.SelectCommand = this.sqlCommand1;
this.sqlDABusObra.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
new System.Data.Common.DataTableMapping("Table", "Obra", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("Idobra", "Idobra"),
new System.Data.Common.DataColumnMapping("Ubicacion", "Ubicacion"),
new System.Data.Common.DataColumnMapping("RFC", "RFC"),
new System.Data.Common.DataColumnMapping("Facturar", "Facturar")
})
});
//
// sqlCommand1
//
this.sqlCommand1.CommandText = resources.GetString("sqlCommand1.CommandText");
this.sqlCommand1.Connection = this.sqlConn;
//
// dsUnidad1
//
this.dsUnidad1.DataSetName = "dsUnidad";
this.dsUnidad1.Locale = new System.Globalization.CultureInfo("es-MX");
this.dsUnidad1.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema;
//
// dsPlanta1
//
this.dsPlanta1.DataSetName = "dsPlanta";
this.dsPlanta1.Locale = new System.Globalization.CultureInfo("es-MX");
this.dsPlanta1.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema;
//
// dsConcretera1
//
this.dsConcretera1.DataSetName = "dsConcretera";
this.dsConcretera1.Locale = new System.Globalization.CultureInfo("es-MX");
this.dsConcretera1.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema;
//
// panel1
//
this.panel1.BackColor = System.Drawing.SystemColors.Highlight;
this.panel1.Controls.Add(this.btnVistaPrevia);
this.panel1.Controls.Add(this.buscaBtn1);
this.panel1.Controls.Add(this.cmbTipo);
this.panel1.Controls.Add(this.chbLab);
this.panel1.Controls.Add(this.cmbIdDiam);
this.panel1.Controls.Add(this.label14);
this.panel1.Controls.Add(this.textBox1);
this.panel1.Controls.Add(this.cbkPrefijo);
this.panel1.Controls.Add(this.label9);
this.panel1.Controls.Add(this.label8);
this.panel1.Controls.Add(this.cmbUnidad);
this.panel1.Controls.Add(this.label5);
this.panel1.Controls.Add(this.dtpFin);
this.panel1.Controls.Add(this.label4);
this.panel1.Controls.Add(this.dtpIni);
this.panel1.Controls.Add(this.label3);
this.panel1.Controls.Add(this.label2);
this.panel1.Controls.Add(this.cmbIdObra);
this.panel1.Controls.Add(this.label1);
this.panel1.Controls.Add(this.Fecha);
this.panel1.Controls.Add(this.cmbConcretera);
this.panel1.Controls.Add(this.cmbPlanta);
this.panel1.Controls.Add(this.txtIdobra);
this.panel1.Dock = System.Windows.Forms.DockStyle.Top;
this.panel1.Location = new System.Drawing.Point(0, 0);
this.panel1.Name = "panel1";
this.panel1.Size = new System.Drawing.Size(1046, 78);
this.panel1.TabIndex = 10;
//
// buscaBtn1
//
this.buscaBtn1.AnchoDlgBusq = 450;
this.buscaBtn1.BackColor = System.Drawing.Color.Transparent;
this.buscaBtn1.Datos = this.dsConcreto1.Muestras;
this.buscaBtn1.Icon = ((System.Drawing.Icon)(resources.GetObject("buscaBtn1.Icon")));
this.buscaBtn1.Location = new System.Drawing.Point(360, 0);
this.buscaBtn1.Name = "buscaBtn1";
this.buscaBtn1.Size = new System.Drawing.Size(64, 64);
this.buscaBtn1.TabIndex = 2;
this.buscaBtn1.Visible = false;
this.buscaBtn1.Click += new System.EventHandler(this.buscaBtn1_Click);
//
// dsConcreto1
//
this.dsConcreto1.DataSetName = "dsConcreto";
this.dsConcreto1.Locale = new System.Globalization.CultureInfo("es-MX");
this.dsConcreto1.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema;
//
// btnVistaPrevia
//
this.btnVistaPrevia.BackColor = System.Drawing.Color.Transparent;
this.btnVistaPrevia.Icon = ((System.Drawing.Icon)(resources.GetObject("btnVistaPrevia.Icon")));
this.btnVistaPrevia.Location = new System.Drawing.Point(792, 8);
this.btnVistaPrevia.Name = "btnVistaPrevia";
this.btnVistaPrevia.Size = new System.Drawing.Size(64, 64);
this.btnVistaPrevia.TabIndex = 11;
this.btnVistaPrevia.Visible = false;
this.btnVistaPrevia.Click += new System.EventHandler(this.btnVistaPrevia_Click);
//
// chbLab
//
this.chbLab.Checked = true;
this.chbLab.CheckState = System.Windows.Forms.CheckState.Checked;
this.chbLab.Location = new System.Drawing.Point(440, 52);
this.chbLab.Name = "chbLab";
this.chbLab.Size = new System.Drawing.Size(116, 24);
this.chbLab.TabIndex = 77;
this.chbLab.Text = "Incluye laboratorio";
//
// cmbIdDiam
//
this.cmbIdDiam.DataSource = this.dsDiametro1;
this.cmbIdDiam.DisplayMember = "Diametro.Figura";
this.cmbIdDiam.Location = new System.Drawing.Point(224, 28);
this.cmbIdDiam.Name = "cmbIdDiam";
this.cmbIdDiam.Size = new System.Drawing.Size(128, 21);
this.cmbIdDiam.TabIndex = 76;
this.cmbIdDiam.ValueMember = "IdDiam";
//
// dsDiametro1
//
this.dsDiametro1.DataSetName = "dsDiametro";
this.dsDiametro1.Locale = new System.Globalization.CultureInfo("es-MX");
this.dsDiametro1.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema;
//
// label14
//
this.label14.AutoSize = true;
this.label14.Location = new System.Drawing.Point(144, 28);
this.label14.Name = "label14";
this.label14.Size = new System.Drawing.Size(74, 13);
this.label14.TabIndex = 75;
this.label14.Text = "F. geométrica:";
this.label14.TextAlign = System.Drawing.ContentAlignment.TopRight;
//
// textBox1
//
this.textBox1.Location = new System.Drawing.Point(16, 48);
this.textBox1.Name = "textBox1";
this.textBox1.Size = new System.Drawing.Size(76, 20);
this.textBox1.TabIndex = 74;
this.textBox1.Text = "textBox1";
this.textBox1.Visible = false;
//
// cbkPrefijo
//
this.cbkPrefijo.Checked = true;
this.cbkPrefijo.CheckState = System.Windows.Forms.CheckState.Checked;
this.cbkPrefijo.Location = new System.Drawing.Point(112, 48);
this.cbkPrefijo.Name = "cbkPrefijo";
this.cbkPrefijo.Size = new System.Drawing.Size(74, 24);
this.cbkPrefijo.TabIndex = 73;
this.cbkPrefijo.Text = "No prefijo";
this.cbkPrefijo.CheckedChanged += new System.EventHandler(this.cbkPrefijo_CheckedChanged);
//
// label9
//
this.label9.AutoSize = true;
this.label9.Location = new System.Drawing.Point(672, 30);
this.label9.Name = "label9";
this.label9.Size = new System.Drawing.Size(40, 13);
this.label9.TabIndex = 24;
this.label9.Text = "Planta:";
this.label9.TextAlign = System.Drawing.ContentAlignment.MiddleRight;
//
// label8
//
this.label8.AutoSize = true;
this.label8.Location = new System.Drawing.Point(648, 6);
this.label8.Name = "label8";
this.label8.Size = new System.Drawing.Size(62, 13);
this.label8.TabIndex = 23;
this.label8.Text = "Concretera:";
this.label8.TextAlign = System.Drawing.ContentAlignment.MiddleRight;
//
// cmbUnidad
//
this.cmbUnidad.DataSource = this.dsUnidad1.Unidad;
this.cmbUnidad.DisplayMember = "Undescr";
this.cmbUnidad.Location = new System.Drawing.Point(696, 52);
this.cmbUnidad.Name = "cmbUnidad";
this.cmbUnidad.Size = new System.Drawing.Size(84, 21);
this.cmbUnidad.TabIndex = 10;
this.cmbUnidad.ValueMember = "IdUnidad";
//
// label5
//
this.label5.AutoSize = true;
this.label5.Location = new System.Drawing.Point(656, 54);
this.label5.Name = "label5";
this.label5.Size = new System.Drawing.Size(44, 13);
this.label5.TabIndex = 13;
this.label5.Text = "Unidad:";
//
// dtpFin
//
this.dtpFin.Format = System.Windows.Forms.DateTimePickerFormat.Short;
this.dtpFin.Location = new System.Drawing.Point(560, 28);
this.dtpFin.Name = "dtpFin";
this.dtpFin.Size = new System.Drawing.Size(84, 20);
this.dtpFin.TabIndex = 4;
//
// label4
//
this.label4.AutoSize = true;
this.label4.Location = new System.Drawing.Point(524, 32);
this.label4.Name = "label4";
this.label4.Size = new System.Drawing.Size(32, 13);
this.label4.TabIndex = 11;
this.label4.Text = "Final:";
//
// dtpIni
//
this.dtpIni.Format = System.Windows.Forms.DateTimePickerFormat.Short;
this.dtpIni.Location = new System.Drawing.Point(560, 4);
this.dtpIni.Name = "dtpIni";
this.dtpIni.Size = new System.Drawing.Size(84, 20);
this.dtpIni.TabIndex = 3;
//
// label3
//
this.label3.AutoSize = true;
this.label3.Location = new System.Drawing.Point(520, 6);
this.label3.Name = "label3";
this.label3.Size = new System.Drawing.Size(37, 13);
this.label3.TabIndex = 9;
this.label3.Text = "Inicial:";
//
// label2
//
this.label2.AutoSize = true;
this.label2.Location = new System.Drawing.Point(192, 6);
this.label2.Name = "label2";
this.label2.Size = new System.Drawing.Size(33, 13);
this.label2.TabIndex = 8;
this.label2.Text = "Obra:";
//
// cmbIdObra
//
this.cmbIdObra.DataSource = this.dsBuscaObra1.Obra;
this.cmbIdObra.DisplayMember = "Idobra";
this.cmbIdObra.Location = new System.Drawing.Point(224, 4);
this.cmbIdObra.Name = "cmbIdObra";
this.cmbIdObra.Size = new System.Drawing.Size(80, 21);
this.cmbIdObra.TabIndex = 1;
this.cmbIdObra.ValueMember = "IdObra";
this.cmbIdObra.SelectedIndexChanged += new System.EventHandler(this.cmbIdObra_SelectedIndexChanged);
//
// dsBuscaObra1
//
this.dsBuscaObra1.DataSetName = "dsBuscaObra";
this.dsBuscaObra1.Locale = new System.Globalization.CultureInfo("es-MX");
this.dsBuscaObra1.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema;
//
// label1
//
this.label1.AutoSize = true;
this.label1.Font = new System.Drawing.Font("Microsoft Sans Serif", 14F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
this.label1.Location = new System.Drawing.Point(8, 0);
this.label1.Name = "label1";
this.label1.Size = new System.Drawing.Size(187, 24);
this.label1.TabIndex = 0;
this.label1.Text = "Análisis promedios";
//
// Fecha
//
this.Fecha.AutoSize = true;
this.Fecha.Location = new System.Drawing.Point(424, 6);
this.Fecha.Name = "Fecha";
this.Fecha.Size = new System.Drawing.Size(95, 13);
this.Fecha.TabIndex = 4;
this.Fecha.Text = "Fechas de periodo";
//
// cmbConcretera
//
this.cmbConcretera.DataSource = this.dsConcretera1.Concretera;
this.cmbConcretera.DisplayMember = "Concretera";
this.cmbConcretera.Location = new System.Drawing.Point(712, 4);
this.cmbConcretera.Name = "cmbConcretera";
this.cmbConcretera.Size = new System.Drawing.Size(68, 21);
this.cmbConcretera.TabIndex = 5;
this.cmbConcretera.ValueMember = "IdConcretera";
//
// cmbPlanta
//
this.cmbPlanta.DataSource = this.dsPlanta1.Planta;
this.cmbPlanta.DisplayMember = "Planta";
this.cmbPlanta.Enabled = false;
this.cmbPlanta.Location = new System.Drawing.Point(712, 28);
this.cmbPlanta.Name = "cmbPlanta";
this.cmbPlanta.Size = new System.Drawing.Size(68, 21);
this.cmbPlanta.TabIndex = 6;
this.cmbPlanta.ValueMember = "IdPlanta";
//
// txtIdobra
//
this.txtIdobra.Location = new System.Drawing.Point(368, 24);
this.txtIdobra.Name = "txtIdobra";
this.txtIdobra.ReadOnly = true;
this.txtIdobra.Size = new System.Drawing.Size(48, 20);
this.txtIdobra.TabIndex = 2;
this.txtIdobra.Visible = false;
//
// sqlDAConcreto
//
this.sqlDAConcreto.SelectCommand = this.sqlCommand2;
this.sqlDAConcreto.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
new System.Data.Common.DataTableMapping("Table", "Muestras", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("IdObra", "IdObra"),
new System.Data.Common.DataColumnMapping("Resistencia", "Resistencia"),
new System.Data.Common.DataColumnMapping("Tipo", "Tipo"),
new System.Data.Common.DataColumnMapping("T.M.A.", "T.M.A."),
new System.Data.Common.DataColumnMapping("Rev.", "Rev."),
new System.Data.Common.DataColumnMapping("T. A.", "T. A.")
})
});
//
// sqlCommand2
//
this.sqlCommand2.CommandText = resources.GetString("sqlCommand2.CommandText");
this.sqlCommand2.Connection = this.sqlConn;
this.sqlCommand2.Parameters.AddRange(new System.Data.SqlClient.SqlParameter[] {
new System.Data.SqlClient.SqlParameter("@IdObra", System.Data.SqlDbType.NVarChar, 6, "IdObra")
});
//
// crvRepPromedios
//
this.crvRepPromedios.ActiveViewIndex = -1;
this.crvRepPromedios.BorderStyle = System.Windows.Forms.BorderStyle.FixedSingle;
this.crvRepPromedios.Cursor = System.Windows.Forms.Cursors.Default;
this.crvRepPromedios.Dock = System.Windows.Forms.DockStyle.Fill;
this.crvRepPromedios.EnableRefresh = false;
this.crvRepPromedios.Location = new System.Drawing.Point(0, 78);
this.crvRepPromedios.Name = "crvRepPromedios";
this.crvRepPromedios.ShowCloseButton = false;
this.crvRepPromedios.ShowGroupTreeButton = false;
this.crvRepPromedios.ShowLogo = false;
this.crvRepPromedios.ShowRefreshButton = false;
this.crvRepPromedios.Size = new System.Drawing.Size(1046, 670);
this.crvRepPromedios.TabIndex = 11;
this.crvRepPromedios.ToolPanelView = CrystalDecisions.Windows.Forms.ToolPanelViewType.None;
this.crvRepPromedios.ToolPanelWidth = 167;
//
// sqlDAPromedios
//
this.sqlDAPromedios.SelectCommand = this.sqlSelectCommand2;
//
// sqlSelectCommand2
//
this.sqlSelectCommand2.CommandText = "[Promedios]";
this.sqlSelectCommand2.CommandType = System.Data.CommandType.StoredProcedure;
this.sqlSelectCommand2.Connection = this.sqlConn;
this.sqlSelectCommand2.Parameters.AddRange(new System.Data.SqlClient.SqlParameter[] {
new System.Data.SqlClient.SqlParameter("@RETURN_VALUE", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.ReturnValue, false, ((byte)(0)), ((byte)(0)), "", System.Data.DataRowVersion.Current, null),
new System.Data.SqlClient.SqlParameter("@IdObra", System.Data.SqlDbType.NVarChar, 6),
new System.Data.SqlClient.SqlParameter("@IdConcretera", System.Data.SqlDbType.NVarChar, 10),
new System.Data.SqlClient.SqlParameter("@IdPlanta", System.Data.SqlDbType.SmallInt, 2),
new System.Data.SqlClient.SqlParameter("@FechaIni", System.Data.SqlDbType.DateTime, 8),
new System.Data.SqlClient.SqlParameter("@FechaFin", System.Data.SqlDbType.DateTime, 8),
new System.Data.SqlClient.SqlParameter("@ResistenciaKG", System.Data.SqlDbType.Real, 4),
new System.Data.SqlClient.SqlParameter("@Tipo", System.Data.SqlDbType.Int, 4),
new System.Data.SqlClient.SqlParameter("@Agregado", System.Data.SqlDbType.Real, 4),
new System.Data.SqlClient.SqlParameter("@Renvenimiento", System.Data.SqlDbType.Real, 4),
new System.Data.SqlClient.SqlParameter("@IdAgregado", System.Data.SqlDbType.Int, 4),
new System.Data.SqlClient.SqlParameter("@IdPrueba", System.Data.SqlDbType.SmallInt, 2),
new System.Data.SqlClient.SqlParameter("@IdUnidad", System.Data.SqlDbType.SmallInt, 2),
new System.Data.SqlClient.SqlParameter("@Todos", System.Data.SqlDbType.Bit, 1),
new System.Data.SqlClient.SqlParameter("@IdDiam", System.Data.SqlDbType.SmallInt, 2)
});
//
// dsPromedios1
//
this.dsPromedios1.DataSetName = "dsPromedios";
this.dsPromedios1.Locale = new System.Globalization.CultureInfo("en-US");
this.dsPromedios1.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema;
//
// dsMuestra1
//
this.dsMuestra1.DataSetName = "dsMuestra";
this.dsMuestra1.Locale = new System.Globalization.CultureInfo("es-MX");
this.dsMuestra1.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema;
//
// sqlDADiametro
//
this.sqlDADiametro.SelectCommand = this.sqlSelectCommand9;
this.sqlDADiametro.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
new System.Data.Common.DataTableMapping("Table", "Diametro", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("IdDiam", "IdDiam"),
new System.Data.Common.DataColumnMapping("Diametro", "Diametro")
})
});
//
// sqlSelectCommand9
//
this.sqlSelectCommand9.CommandText = "SELECT IdDiam, Diametro, Diametro + \' \' + Figura AS Figura FROM Diametro";
this.sqlSelectCommand9.Connection = this.sqlConn;
//
// sqlDATipo
//
this.sqlDATipo.SelectCommand = this.sqlSelectCommand11;
this.sqlDATipo.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
new System.Data.Common.DataTableMapping("Table", "Tipo", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("Tipo", "Tipo"),
new System.Data.Common.DataColumnMapping("DesTipo", "DesTipo")
})
});
//
// sqlSelectCommand11
//
this.sqlSelectCommand11.CommandText = "SELECT Tipo, DesTipo FROM Tipo ORDER BY Tipo";
this.sqlSelectCommand11.Connection = this.sqlConn;
//
// dsTipo1
//
this.dsTipo1.DataSetName = "dsTipo";
this.dsTipo1.Locale = new System.Globalization.CultureInfo("es-MX");
this.dsTipo1.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema;
//
// cmbTipo
//
this.cmbTipo.DataSource = this.dsTipo1;
this.cmbTipo.DisplayMember = "Tipo.DesTipo";
this.cmbTipo.Location = new System.Drawing.Point(560, 52);
this.cmbTipo.Name = "cmbTipo";
this.cmbTipo.Size = new System.Drawing.Size(64, 21);
this.cmbTipo.TabIndex = 78;
this.cmbTipo.ValueMember = "Tipo.Tipo";
//
// RepPromedios
//
this.AutoScaleBaseSize = new System.Drawing.Size(5, 13);
this.ClientSize = new System.Drawing.Size(1046, 748);
this.Controls.Add(this.crvRepPromedios);
this.Controls.Add(this.panel1);
this.Name = "RepPromedios";
this.Text = "RepPromedios";
this.WindowState = System.Windows.Forms.FormWindowState.Maximized;
this.Load += new System.EventHandler(this.RepPromedios_Load);
((System.ComponentModel.ISupportInitialize)(this.dsUnidad1)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.dsPlanta1)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.dsConcretera1)).EndInit();
this.panel1.ResumeLayout(false);
this.panel1.PerformLayout();
((System.ComponentModel.ISupportInitialize)(this.dsConcreto1)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.dsDiametro1)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.dsBuscaObra1)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.dsPromedios1)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.dsMuestra1)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.dsTipo1)).EndInit();
this.ResumeLayout(false);
}
