/// <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); }