/// <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(ToronMdor)); System.Configuration.AppSettingsReader configurationAppSettings = new System.Configuration.AppSettingsReader(); this.panel2 = new System.Windows.Forms.Panel(); this.buscaBtn1 = new Soluciones2000.Tools.WinLib.BuscaBtn(); this.dsToronMdor1 = new LancNeo.dsToronMdor(); this.txtObserva = new System.Windows.Forms.TextBox(); this.txtMuestreadasen = new System.Windows.Forms.TextBox(); this.txtSemana = new System.Windows.Forms.TextBox(); this.cmbNoeco = new System.Windows.Forms.ComboBox(); this.dsLaboratorista1 = new LancNeo.dsLaboratorista(); this.dtpFinforme = new System.Windows.Forms.DateTimePicker(); this.dtpFensaye = new System.Windows.Forms.DateTimePicker(); this.dtpFmuestreo = new System.Windows.Forms.DateTimePicker(); this.txtConsecutivo = new System.Windows.Forms.TextBox(); this.cmbIdObra = new System.Windows.Forms.ComboBox(); this.dsBusObra1 = new LancNeo.dsBusObra(); this.txtFolio = new System.Windows.Forms.TextBox(); this.label10 = new System.Windows.Forms.Label(); this.label9 = new System.Windows.Forms.Label(); this.label8 = new System.Windows.Forms.Label(); this.label7 = new System.Windows.Forms.Label(); this.label6 = new System.Windows.Forms.Label(); this.label5 = new System.Windows.Forms.Label(); this.label4 = new System.Windows.Forms.Label(); this.label3 = new System.Windows.Forms.Label(); this.label2 = new System.Windows.Forms.Label(); this.label1 = new System.Windows.Forms.Label(); this.sqlDAToronMdor = new System.Data.SqlClient.SqlDataAdapter(); this.sqlDeleteCommand1 = new System.Data.SqlClient.SqlCommand(); this.sqlConn = new System.Data.SqlClient.SqlConnection(); this.sqlInsertCommand1 = new System.Data.SqlClient.SqlCommand(); this.sqlSelectCommand1 = new System.Data.SqlClient.SqlCommand(); this.sqlUpdateCommand1 = new System.Data.SqlClient.SqlCommand(); this.sqlDABusObra = new System.Data.SqlClient.SqlDataAdapter(); this.sqlCommand1 = new System.Data.SqlClient.SqlCommand(); this.sqlDALaboratorista = new System.Data.SqlClient.SqlDataAdapter(); this.sqlSelectCommand5 = new System.Data.SqlClient.SqlCommand(); this.txtUsrMov = new System.Windows.Forms.TextBox(); this.label28 = new System.Windows.Forms.Label(); this.panelToolBar.SuspendLayout(); this.panel2.SuspendLayout(); ((System.ComponentModel.ISupportInitialize)(this.dsToronMdor1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.dsLaboratorista1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.dsBusObra1)).BeginInit(); this.SuspendLayout(); // // statusBar1 // this.statusBar1.Location = new System.Drawing.Point(0, 431); this.statusBar1.ShowPanels = true; this.statusBar1.Size = new System.Drawing.Size(584, 22); // // panelToolBar // this.panelToolBar.Size = new System.Drawing.Size(584, 64); // // panel2 // this.panel2.BorderStyle = System.Windows.Forms.BorderStyle.Fixed3D; this.panel2.Controls.Add(this.buscaBtn1); this.panel2.Controls.Add(this.txtUsrMov); this.panel2.Controls.Add(this.label28); this.panel2.Controls.Add(this.txtObserva); this.panel2.Controls.Add(this.txtMuestreadasen); this.panel2.Controls.Add(this.txtSemana); this.panel2.Controls.Add(this.cmbNoeco); this.panel2.Controls.Add(this.dtpFinforme); this.panel2.Controls.Add(this.dtpFensaye); this.panel2.Controls.Add(this.dtpFmuestreo); this.panel2.Controls.Add(this.txtConsecutivo); this.panel2.Controls.Add(this.cmbIdObra); this.panel2.Controls.Add(this.txtFolio); this.panel2.Controls.Add(this.label10); this.panel2.Controls.Add(this.label9); this.panel2.Controls.Add(this.label8); this.panel2.Controls.Add(this.label7); this.panel2.Controls.Add(this.label6); this.panel2.Controls.Add(this.label5); this.panel2.Controls.Add(this.label4); this.panel2.Controls.Add(this.label3); this.panel2.Controls.Add(this.label2); this.panel2.Controls.Add(this.label1); this.panel2.Location = new System.Drawing.Point(24, 66); this.panel2.Name = "panel2"; this.panel2.Size = new System.Drawing.Size(536, 320); this.panel2.TabIndex = 7; // // buscaBtn1 // this.buscaBtn1.AnchoColTit = true; this.buscaBtn1.AnchoDlgBusq = 675; this.buscaBtn1.BackColor = System.Drawing.Color.Transparent; this.buscaBtn1.Datos = this.dsToronMdor1.Toron7AlamMdor; this.buscaBtn1.Icon = ((System.Drawing.Icon)(resources.GetObject("buscaBtn1.Icon"))); this.buscaBtn1.Location = new System.Drawing.Point(202, 6); this.buscaBtn1.Name = "buscaBtn1"; this.buscaBtn1.Size = new System.Drawing.Size(64, 64); this.buscaBtn1.TabIndex = 20; // // dsToronMdor1 // this.dsToronMdor1.DataSetName = "dsToronMdor"; this.dsToronMdor1.Locale = new System.Globalization.CultureInfo("es-MX"); this.dsToronMdor1.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema; // // txtObserva // this.txtObserva.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dsToronMdor1, "Toron7AlamMdor.Observaciones", true)); this.txtObserva.Location = new System.Drawing.Point(126, 238); this.txtObserva.MaxLength = 512; this.txtObserva.Multiline = true; this.txtObserva.Name = "txtObserva"; this.txtObserva.ScrollBars = System.Windows.Forms.ScrollBars.Vertical; this.txtObserva.Size = new System.Drawing.Size(394, 68); this.txtObserva.TabIndex = 19; this.txtObserva.Text = "textBox5"; // // txtMuestreadasen // this.txtMuestreadasen.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dsToronMdor1, "Toron7AlamMdor.MuestreadasEn", true)); this.txtMuestreadasen.Location = new System.Drawing.Point(126, 214); this.txtMuestreadasen.Name = "txtMuestreadasen"; this.txtMuestreadasen.Size = new System.Drawing.Size(100, 20); this.txtMuestreadasen.TabIndex = 18; this.txtMuestreadasen.Text = "textBox4"; // // txtSemana // this.txtSemana.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dsToronMdor1, "Toron7AlamMdor.Semana", true)); this.txtSemana.Location = new System.Drawing.Point(126, 190); this.txtSemana.MaxLength = 2; this.txtSemana.Name = "txtSemana"; this.txtSemana.Size = new System.Drawing.Size(66, 20); this.txtSemana.TabIndex = 17; this.txtSemana.Text = "textBox3"; // // cmbNoeco // this.cmbNoeco.DataBindings.Add(new System.Windows.Forms.Binding("SelectedValue", this.dsToronMdor1, "Toron7AlamMdor.NoEco", true)); this.cmbNoeco.DataSource = this.dsLaboratorista1.Laboratorista; this.cmbNoeco.DisplayMember = "Laboratorista"; this.cmbNoeco.Location = new System.Drawing.Point(126, 166); this.cmbNoeco.Name = "cmbNoeco"; this.cmbNoeco.Size = new System.Drawing.Size(392, 21); this.cmbNoeco.TabIndex = 16; this.cmbNoeco.ValueMember = "NoEco"; // // dsLaboratorista1 // this.dsLaboratorista1.DataSetName = "dsLaboratorista"; this.dsLaboratorista1.Locale = new System.Globalization.CultureInfo("es-MX"); this.dsLaboratorista1.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema; // // dtpFinforme // this.dtpFinforme.CustomFormat = "dd/MM/yyyy"; this.dtpFinforme.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dsToronMdor1, "Toron7AlamMdor.FInforme", true)); this.dtpFinforme.Format = System.Windows.Forms.DateTimePickerFormat.Custom; this.dtpFinforme.Location = new System.Drawing.Point(126, 142); this.dtpFinforme.Name = "dtpFinforme"; this.dtpFinforme.Size = new System.Drawing.Size(84, 20); this.dtpFinforme.TabIndex = 15; // // dtpFensaye // this.dtpFensaye.CustomFormat = "dd/MM/yyyy"; this.dtpFensaye.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dsToronMdor1, "Toron7AlamMdor.FEnsaye", true)); this.dtpFensaye.Format = System.Windows.Forms.DateTimePickerFormat.Custom; this.dtpFensaye.Location = new System.Drawing.Point(126, 118); this.dtpFensaye.Name = "dtpFensaye"; this.dtpFensaye.Size = new System.Drawing.Size(84, 20); this.dtpFensaye.TabIndex = 14; // // dtpFmuestreo // this.dtpFmuestreo.CustomFormat = "dd/MM/yyyy"; this.dtpFmuestreo.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dsToronMdor1, "Toron7AlamMdor.FMuestreo", true)); this.dtpFmuestreo.Format = System.Windows.Forms.DateTimePickerFormat.Custom; this.dtpFmuestreo.Location = new System.Drawing.Point(126, 94); this.dtpFmuestreo.Name = "dtpFmuestreo"; this.dtpFmuestreo.Size = new System.Drawing.Size(84, 20); this.dtpFmuestreo.TabIndex = 13; // // txtConsecutivo // this.txtConsecutivo.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dsToronMdor1, "Toron7AlamMdor.ConsObra", true)); this.txtConsecutivo.Location = new System.Drawing.Point(126, 70); this.txtConsecutivo.MaxLength = 4; this.txtConsecutivo.Name = "txtConsecutivo"; this.txtConsecutivo.Size = new System.Drawing.Size(66, 20); this.txtConsecutivo.TabIndex = 12; this.txtConsecutivo.Text = "textBox2"; // // cmbIdObra // this.cmbIdObra.DataBindings.Add(new System.Windows.Forms.Binding("SelectedValue", this.dsToronMdor1, "Toron7AlamMdor.Idobra", true)); this.cmbIdObra.DataSource = this.dsBusObra1.Obra; this.cmbIdObra.DisplayMember = "Idobra"; this.cmbIdObra.Location = new System.Drawing.Point(126, 46); this.cmbIdObra.Name = "cmbIdObra"; this.cmbIdObra.Size = new System.Drawing.Size(66, 21); this.cmbIdObra.TabIndex = 11; this.cmbIdObra.ValueMember = "Idobra"; // // dsBusObra1 // this.dsBusObra1.DataSetName = "dsBusObra"; this.dsBusObra1.Locale = new System.Globalization.CultureInfo("es-MX"); this.dsBusObra1.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema; // // txtFolio // this.txtFolio.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dsToronMdor1, "Toron7AlamMdor.FOLIO", true)); this.txtFolio.Location = new System.Drawing.Point(126, 22); this.txtFolio.MaxLength = 10; this.txtFolio.Name = "txtFolio"; this.txtFolio.Size = new System.Drawing.Size(64, 20); this.txtFolio.TabIndex = 10; this.txtFolio.Text = "textBox1"; // // label10 // this.label10.AutoSize = true; this.label10.Location = new System.Drawing.Point(30, 240); this.label10.Name = "label10"; this.label10.Size = new System.Drawing.Size(81, 13); this.label10.TabIndex = 9; this.label10.Text = "Observaciones:"; this.label10.TextAlign = System.Drawing.ContentAlignment.MiddleRight; // // label9 // this.label9.AutoSize = true; this.label9.Location = new System.Drawing.Point(25, 216); this.label9.Name = "label9"; this.label9.Size = new System.Drawing.Size(86, 13); this.label9.TabIndex = 8; this.label9.Text = "Muestreadas en:"; this.label9.TextAlign = System.Drawing.ContentAlignment.MiddleRight; // // label8 // this.label8.AutoSize = true; this.label8.Location = new System.Drawing.Point(63, 192); this.label8.Name = "label8"; this.label8.Size = new System.Drawing.Size(49, 13); this.label8.TabIndex = 7; this.label8.Text = "Semana:"; this.label8.TextAlign = System.Drawing.ContentAlignment.MiddleRight; // // label7 // this.label7.AutoSize = true; this.label7.Location = new System.Drawing.Point(36, 168); this.label7.Name = "label7"; this.label7.Size = new System.Drawing.Size(75, 13); this.label7.TabIndex = 6; this.label7.Text = "Ensayado por:"; this.label7.TextAlign = System.Drawing.ContentAlignment.MiddleRight; // // label6 // this.label6.AutoSize = true; this.label6.Location = new System.Drawing.Point(33, 144); this.label6.Name = "label6"; this.label6.Size = new System.Drawing.Size(77, 13); this.label6.TabIndex = 5; this.label6.Text = "Fecha informe:"; this.label6.TextAlign = System.Drawing.ContentAlignment.MiddleRight; // // label5 // this.label5.AutoSize = true; this.label5.Location = new System.Drawing.Point(19, 120); this.label5.Name = "label5"; this.label5.Size = new System.Drawing.Size(92, 13); this.label5.TabIndex = 4; this.label5.Text = "Fecha de ensaye:"; this.label5.TextAlign = System.Drawing.ContentAlignment.MiddleRight; // // label4 // this.label4.AutoSize = true; this.label4.Location = new System.Drawing.Point(8, 96); this.label4.Name = "label4"; this.label4.Size = new System.Drawing.Size(101, 13); this.label4.TabIndex = 3; this.label4.Text = "Fecha de muestreo:"; this.label4.TextAlign = System.Drawing.ContentAlignment.MiddleRight; // // label3 // this.label3.AutoSize = true; this.label3.Location = new System.Drawing.Point(43, 72); this.label3.Name = "label3"; this.label3.Size = new System.Drawing.Size(69, 13); this.label3.TabIndex = 2; this.label3.Text = "Consecutivo:"; this.label3.TextAlign = System.Drawing.ContentAlignment.MiddleRight; // // label2 // this.label2.AutoSize = true; this.label2.Location = new System.Drawing.Point(81, 48); this.label2.Name = "label2"; this.label2.Size = new System.Drawing.Size(33, 13); this.label2.TabIndex = 1; this.label2.Text = "Obra:"; this.label2.TextAlign = System.Drawing.ContentAlignment.MiddleRight; // // label1 // this.label1.AutoSize = true; this.label1.Location = new System.Drawing.Point(72, 24); this.label1.Name = "label1"; this.label1.Size = new System.Drawing.Size(41, 13); this.label1.TabIndex = 0; this.label1.Text = "FOLIO:"; this.label1.TextAlign = System.Drawing.ContentAlignment.MiddleRight; // // sqlDAToronMdor // this.sqlDAToronMdor.DeleteCommand = this.sqlDeleteCommand1; this.sqlDAToronMdor.InsertCommand = this.sqlInsertCommand1; this.sqlDAToronMdor.SelectCommand = this.sqlSelectCommand1; this.sqlDAToronMdor.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping("Table", "Toron7AlamMdor", new System.Data.Common.DataColumnMapping[] { new System.Data.Common.DataColumnMapping("FOLIO", "FOLIO"), new System.Data.Common.DataColumnMapping("Idobra", "Idobra"), new System.Data.Common.DataColumnMapping("ConsObra", "ConsObra"), new System.Data.Common.DataColumnMapping("FMuestreo", "FMuestreo"), new System.Data.Common.DataColumnMapping("FEnsaye", "FEnsaye"), new System.Data.Common.DataColumnMapping("FInforme", "FInforme"), new System.Data.Common.DataColumnMapping("NoEco", "NoEco"), new System.Data.Common.DataColumnMapping("Semana", "Semana"), new System.Data.Common.DataColumnMapping("MuestreadasEn", "MuestreadasEn"), new System.Data.Common.DataColumnMapping("Observaciones", "Observaciones"), new System.Data.Common.DataColumnMapping("IdUsuario", "IdUsuario") }) }); this.sqlDAToronMdor.UpdateCommand = this.sqlUpdateCommand1; // // sqlDeleteCommand1 // this.sqlDeleteCommand1.CommandText = resources.GetString("sqlDeleteCommand1.CommandText"); this.sqlDeleteCommand1.Connection = this.sqlConn; this.sqlDeleteCommand1.Parameters.AddRange(new System.Data.SqlClient.SqlParameter[] { new System.Data.SqlClient.SqlParameter("@Original_FOLIO", System.Data.SqlDbType.Char, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "FOLIO", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_Idobra", System.Data.SqlDbType.NVarChar, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Idobra", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@IsNull_ConsObra", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "ConsObra", System.Data.DataRowVersion.Original, true, null, "", "", ""), new System.Data.SqlClient.SqlParameter("@Original_ConsObra", System.Data.SqlDbType.SmallInt, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "ConsObra", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@IsNull_FMuestreo", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "FMuestreo", System.Data.DataRowVersion.Original, true, null, "", "", ""), new System.Data.SqlClient.SqlParameter("@Original_FMuestreo", System.Data.SqlDbType.SmallDateTime, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "FMuestreo", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@IsNull_FEnsaye", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "FEnsaye", System.Data.DataRowVersion.Original, true, null, "", "", ""), new System.Data.SqlClient.SqlParameter("@Original_FEnsaye", System.Data.SqlDbType.SmallDateTime, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "FEnsaye", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@IsNull_FInforme", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "FInforme", System.Data.DataRowVersion.Original, true, null, "", "", ""), new System.Data.SqlClient.SqlParameter("@Original_FInforme", System.Data.SqlDbType.SmallDateTime, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "FInforme", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@IsNull_NoEco", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "NoEco", System.Data.DataRowVersion.Original, true, null, "", "", ""), new System.Data.SqlClient.SqlParameter("@Original_NoEco", System.Data.SqlDbType.SmallInt, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "NoEco", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@IsNull_Semana", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "Semana", System.Data.DataRowVersion.Original, true, null, "", "", ""), new System.Data.SqlClient.SqlParameter("@Original_Semana", System.Data.SqlDbType.SmallInt, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Semana", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@IsNull_MuestreadasEn", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "MuestreadasEn", System.Data.DataRowVersion.Original, true, null, "", "", ""), new System.Data.SqlClient.SqlParameter("@Original_MuestreadasEn", System.Data.SqlDbType.NVarChar, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "MuestreadasEn", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@IsNull_Observaciones", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "Observaciones", System.Data.DataRowVersion.Original, true, null, "", "", ""), new System.Data.SqlClient.SqlParameter("@Original_Observaciones", System.Data.SqlDbType.NVarChar, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Observaciones", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@IsNull_IdUsuario", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "IdUsuario", System.Data.DataRowVersion.Original, true, null, "", "", ""), new System.Data.SqlClient.SqlParameter("@Original_IdUsuario", System.Data.SqlDbType.VarChar, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "IdUsuario", System.Data.DataRowVersion.Original, null) }); // // sqlConn // this.sqlConn.ConnectionString = ((string)(configurationAppSettings.GetValue("sqlConn.ConnectionString", typeof(string)))); this.sqlConn.FireInfoMessageEventOnUserErrors = false; // // sqlInsertCommand1 // this.sqlInsertCommand1.CommandText = resources.GetString("sqlInsertCommand1.CommandText"); this.sqlInsertCommand1.Connection = this.sqlConn; this.sqlInsertCommand1.Parameters.AddRange(new System.Data.SqlClient.SqlParameter[] { new System.Data.SqlClient.SqlParameter("@FOLIO", System.Data.SqlDbType.Char, 0, "FOLIO"), new System.Data.SqlClient.SqlParameter("@Idobra", System.Data.SqlDbType.NVarChar, 0, "Idobra"), new System.Data.SqlClient.SqlParameter("@ConsObra", System.Data.SqlDbType.SmallInt, 0, "ConsObra"), new System.Data.SqlClient.SqlParameter("@FMuestreo", System.Data.SqlDbType.SmallDateTime, 0, "FMuestreo"), new System.Data.SqlClient.SqlParameter("@FEnsaye", System.Data.SqlDbType.SmallDateTime, 0, "FEnsaye"), new System.Data.SqlClient.SqlParameter("@FInforme", System.Data.SqlDbType.SmallDateTime, 0, "FInforme"), new System.Data.SqlClient.SqlParameter("@NoEco", System.Data.SqlDbType.SmallInt, 0, "NoEco"), new System.Data.SqlClient.SqlParameter("@Semana", System.Data.SqlDbType.SmallInt, 0, "Semana"), new System.Data.SqlClient.SqlParameter("@MuestreadasEn", System.Data.SqlDbType.NVarChar, 0, "MuestreadasEn"), new System.Data.SqlClient.SqlParameter("@Observaciones", System.Data.SqlDbType.NVarChar, 0, "Observaciones"), new System.Data.SqlClient.SqlParameter("@IdUsuario", System.Data.SqlDbType.VarChar, 0, "IdUsuario") }); // // sqlSelectCommand1 // this.sqlSelectCommand1.CommandText = "SELECT FOLIO, Idobra, ConsObra, FMuestreo, FEnsaye, FInforme, NoEco, Seman" + "a, MuestreadasEn, Observaciones, IdUsuario\r\nFROM Toron7AlamMdor"; this.sqlSelectCommand1.Connection = this.sqlConn; // // sqlUpdateCommand1 // this.sqlUpdateCommand1.CommandText = resources.GetString("sqlUpdateCommand1.CommandText"); this.sqlUpdateCommand1.Connection = this.sqlConn; this.sqlUpdateCommand1.Parameters.AddRange(new System.Data.SqlClient.SqlParameter[] { new System.Data.SqlClient.SqlParameter("@FOLIO", System.Data.SqlDbType.Char, 0, "FOLIO"), new System.Data.SqlClient.SqlParameter("@Idobra", System.Data.SqlDbType.NVarChar, 0, "Idobra"), new System.Data.SqlClient.SqlParameter("@ConsObra", System.Data.SqlDbType.SmallInt, 0, "ConsObra"), new System.Data.SqlClient.SqlParameter("@FMuestreo", System.Data.SqlDbType.SmallDateTime, 0, "FMuestreo"), new System.Data.SqlClient.SqlParameter("@FEnsaye", System.Data.SqlDbType.SmallDateTime, 0, "FEnsaye"), new System.Data.SqlClient.SqlParameter("@FInforme", System.Data.SqlDbType.SmallDateTime, 0, "FInforme"), new System.Data.SqlClient.SqlParameter("@NoEco", System.Data.SqlDbType.SmallInt, 0, "NoEco"), new System.Data.SqlClient.SqlParameter("@Semana", System.Data.SqlDbType.SmallInt, 0, "Semana"), new System.Data.SqlClient.SqlParameter("@MuestreadasEn", System.Data.SqlDbType.NVarChar, 0, "MuestreadasEn"), new System.Data.SqlClient.SqlParameter("@Observaciones", System.Data.SqlDbType.NVarChar, 0, "Observaciones"), new System.Data.SqlClient.SqlParameter("@IdUsuario", System.Data.SqlDbType.VarChar, 0, "IdUsuario"), new System.Data.SqlClient.SqlParameter("@Original_FOLIO", System.Data.SqlDbType.Char, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "FOLIO", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_Idobra", System.Data.SqlDbType.NVarChar, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Idobra", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@IsNull_ConsObra", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "ConsObra", System.Data.DataRowVersion.Original, true, null, "", "", ""), new System.Data.SqlClient.SqlParameter("@Original_ConsObra", System.Data.SqlDbType.SmallInt, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "ConsObra", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@IsNull_FMuestreo", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "FMuestreo", System.Data.DataRowVersion.Original, true, null, "", "", ""), new System.Data.SqlClient.SqlParameter("@Original_FMuestreo", System.Data.SqlDbType.SmallDateTime, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "FMuestreo", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@IsNull_FEnsaye", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "FEnsaye", System.Data.DataRowVersion.Original, true, null, "", "", ""), new System.Data.SqlClient.SqlParameter("@Original_FEnsaye", System.Data.SqlDbType.SmallDateTime, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "FEnsaye", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@IsNull_FInforme", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "FInforme", System.Data.DataRowVersion.Original, true, null, "", "", ""), new System.Data.SqlClient.SqlParameter("@Original_FInforme", System.Data.SqlDbType.SmallDateTime, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "FInforme", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@IsNull_NoEco", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "NoEco", System.Data.DataRowVersion.Original, true, null, "", "", ""), new System.Data.SqlClient.SqlParameter("@Original_NoEco", System.Data.SqlDbType.SmallInt, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "NoEco", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@IsNull_Semana", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "Semana", System.Data.DataRowVersion.Original, true, null, "", "", ""), new System.Data.SqlClient.SqlParameter("@Original_Semana", System.Data.SqlDbType.SmallInt, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Semana", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@IsNull_MuestreadasEn", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "MuestreadasEn", System.Data.DataRowVersion.Original, true, null, "", "", ""), new System.Data.SqlClient.SqlParameter("@Original_MuestreadasEn", System.Data.SqlDbType.NVarChar, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "MuestreadasEn", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@IsNull_Observaciones", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "Observaciones", System.Data.DataRowVersion.Original, true, null, "", "", ""), new System.Data.SqlClient.SqlParameter("@Original_Observaciones", System.Data.SqlDbType.NVarChar, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Observaciones", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@IsNull_IdUsuario", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "IdUsuario", System.Data.DataRowVersion.Original, true, null, "", "", ""), new System.Data.SqlClient.SqlParameter("@Original_IdUsuario", System.Data.SqlDbType.VarChar, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "IdUsuario", System.Data.DataRowVersion.Original, null) }); // // 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 = "SELECT Obra.Idobra, Obra.Ubicacion, Obra.RFC, Razonsocial.Facturar FROM Obra LEFT" + " OUTER JOIN Razonsocial ON Obra.IdCliente = Razonsocial.IdCliente AND Obra.RFC =" + " Razonsocial.RFC ORDER BY Obra.Idobra"; this.sqlCommand1.Connection = this.sqlConn; // // sqlDALaboratorista // this.sqlDALaboratorista.SelectCommand = this.sqlSelectCommand5; this.sqlDALaboratorista.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping("Table", "Laboratorista", new System.Data.Common.DataColumnMapping[] { new System.Data.Common.DataColumnMapping("NoEco", "NoEco"), new System.Data.Common.DataColumnMapping("Laboratorista", "Laboratorista"), new System.Data.Common.DataColumnMapping("IdZona", "IdZona"), new System.Data.Common.DataColumnMapping("IdNivel", "IdNivel"), new System.Data.Common.DataColumnMapping("Fechai", "Fechai") }) }); // // sqlSelectCommand5 // this.sqlSelectCommand5.CommandText = "SELECT NoEco, LTRIM(STR(NoEco)) + \' \' + Laboratorista AS Laboratorista, IdZona, I" + "dNivel, Fechai FROM Laboratorista ORDER BY NoEco"; this.sqlSelectCommand5.Connection = this.sqlConn; // // txtUsrMov // this.txtUsrMov.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dsToronMdor1, "Toron7AlamMdor.IdUsuario", true)); this.txtUsrMov.Location = new System.Drawing.Point(400, 26); this.txtUsrMov.Name = "txtUsrMov"; this.txtUsrMov.ReadOnly = true; this.txtUsrMov.Size = new System.Drawing.Size(68, 20); this.txtUsrMov.TabIndex = 52; // // label28 // this.label28.AutoSize = true; this.label28.Font = new System.Drawing.Font("Microsoft Sans Serif", 8.25F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0))); this.label28.ForeColor = System.Drawing.Color.Red; this.label28.Location = new System.Drawing.Point(339, 30); this.label28.Name = "label28"; this.label28.Size = new System.Drawing.Size(54, 13); this.label28.TabIndex = 51; this.label28.Text = "Usuario:"; this.label28.TextAlign = System.Drawing.ContentAlignment.MiddleRight; // // ToronMdor // this.AutoScaleBaseSize = new System.Drawing.Size(5, 13); this.ClientSize = new System.Drawing.Size(584, 453); this.Controls.Add(this.panel2); this.DAGeneral = this.sqlDAToronMdor; this.dsGeneral = this.dsToronMdor1; this.Name = "ToronMdor"; this.NombreTabla = "Toron7AlamMdor"; this.Text = "ToronMdor"; this.Load += new System.EventHandler(this.ToronMdor_Load); this.Controls.SetChildIndex(this.statusBar1, 0); this.Controls.SetChildIndex(this.panelToolBar, 0); this.Controls.SetChildIndex(this.panel2, 0); this.panelToolBar.ResumeLayout(false); this.panel2.ResumeLayout(false); this.panel2.PerformLayout(); ((System.ComponentModel.ISupportInitialize)(this.dsToronMdor1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.dsLaboratorista1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.dsBusObra1)).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(InfToron)); System.Configuration.AppSettingsReader configurationAppSettings = new System.Configuration.AppSettingsReader(); this.panel1 = new System.Windows.Forms.Panel(); this.buscaBtn1 = new Soluciones2000.Tools.WinLib.BuscaBtn(); this.dsToronMdor1 = new LancNeo.dsToronMdor(); this.btnVistaPrevia = new Soluciones2000.Tools.WinLib.tbBtn(); this.chbTodos = new System.Windows.Forms.CheckBox(); this.groupBox1 = new System.Windows.Forms.GroupBox(); this.rbColada = new System.Windows.Forms.RadioButton(); this.radioButton1 = new System.Windows.Forms.RadioButton(); this.chbLab = new System.Windows.Forms.CheckBox(); this.chbFormato = new System.Windows.Forms.CheckBox(); this.chbLeyenda = new System.Windows.Forms.CheckBox(); this.chbDuplicado = new System.Windows.Forms.CheckBox(); this.txtFolio = new System.Windows.Forms.TextBox(); this.label6 = new System.Windows.Forms.Label(); this.txtRenglon = new System.Windows.Forms.TextBox(); this.cmbUnidad = new System.Windows.Forms.ComboBox(); this.dsUnidad1 = new LancNeo.dsUnidad(); this.label5 = new System.Windows.Forms.Label(); this.label2 = new System.Windows.Forms.Label(); this.cmbIdObra = new System.Windows.Forms.ComboBox(); this.dsBusObra1 = new LancNeo.dsBusObra(); this.label1 = new System.Windows.Forms.Label(); this.Fecha = new System.Windows.Forms.Label(); this.txtIdobra = new System.Windows.Forms.TextBox(); this.chbLab1 = new System.Windows.Forms.CheckBox(); this.crvInfAcero = new CrystalDecisions.Windows.Forms.CrystalReportViewer(); this.sqlDAToronInf = new System.Data.SqlClient.SqlDataAdapter(); this.sqlSelectCommand1 = new System.Data.SqlClient.SqlCommand(); this.sqlConn = new System.Data.SqlClient.SqlConnection(); this.dsFirmas1 = new LancNeo.dsFirmas(); this.sqlDAFirmas = new System.Data.SqlClient.SqlDataAdapter(); this.sqlSelectCommand7 = new System.Data.SqlClient.SqlCommand(); this.sqlDABusObra = new System.Data.SqlClient.SqlDataAdapter(); this.sqlCommand1 = new System.Data.SqlClient.SqlCommand(); this.sqlDAUnidad = new System.Data.SqlClient.SqlDataAdapter(); this.sqlCommand2 = new System.Data.SqlClient.SqlCommand(); this.sqlDAToronMdor = new System.Data.SqlClient.SqlDataAdapter(); this.sqlSelectCommand2 = new System.Data.SqlClient.SqlCommand(); this.dsToronRep1 = new LancNeo.dsToronRep(); this.cryRepToron1 = new LancNeo.CryRepToron(); this.sqlDANorma = new System.Data.SqlClient.SqlDataAdapter(); this.sqlSelectCommand3 = new System.Data.SqlClient.SqlCommand(); this.cryRepToronO1 = new LancNeo.CryRepToronO(); this.chbRespaldo = new System.Windows.Forms.CheckBox(); this.panel1.SuspendLayout(); ((System.ComponentModel.ISupportInitialize)(this.dsToronMdor1)).BeginInit(); this.groupBox1.SuspendLayout(); ((System.ComponentModel.ISupportInitialize)(this.dsUnidad1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.dsBusObra1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.dsFirmas1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.dsToronRep1)).BeginInit(); this.SuspendLayout(); // // panel1 // this.panel1.BackColor = System.Drawing.SystemColors.Highlight; this.panel1.BorderStyle = System.Windows.Forms.BorderStyle.Fixed3D; this.panel1.Controls.Add(this.buscaBtn1); this.panel1.Controls.Add(this.btnVistaPrevia); this.panel1.Controls.Add(this.chbRespaldo); this.panel1.Controls.Add(this.chbTodos); this.panel1.Controls.Add(this.groupBox1); this.panel1.Controls.Add(this.chbLab); this.panel1.Controls.Add(this.chbFormato); this.panel1.Controls.Add(this.chbLeyenda); this.panel1.Controls.Add(this.chbDuplicado); this.panel1.Controls.Add(this.txtFolio); this.panel1.Controls.Add(this.label6); this.panel1.Controls.Add(this.txtRenglon); this.panel1.Controls.Add(this.cmbUnidad); this.panel1.Controls.Add(this.label5); 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.txtIdobra); this.panel1.Controls.Add(this.chbLab1); 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(929, 102); this.panel1.TabIndex = 12; // // buscaBtn1 // this.buscaBtn1.AnchoColTit = true; this.buscaBtn1.AnchoDlgBusq = 650; this.buscaBtn1.BackColor = System.Drawing.Color.Transparent; this.buscaBtn1.Datos = this.dsToronMdor1.Toron7AlamMdor; this.buscaBtn1.Icon = ((System.Drawing.Icon)(resources.GetObject("buscaBtn1.Icon"))); this.buscaBtn1.Location = new System.Drawing.Point(432, 4); this.buscaBtn1.Name = "buscaBtn1"; this.buscaBtn1.Size = new System.Drawing.Size(64, 64); this.buscaBtn1.TabIndex = 2; this.buscaBtn1.Visible = false; this.buscaBtn1.Load += new System.EventHandler(this.buscaBtn1_Load); this.buscaBtn1.Click += new System.EventHandler(this.buscaBtn1_Click); // // dsToronMdor1 // this.dsToronMdor1.DataSetName = "dsToronMdor"; this.dsToronMdor1.Locale = new System.Globalization.CultureInfo("es-MX"); this.dsToronMdor1.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(766, 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); // // chbTodos // this.chbTodos.ForeColor = System.Drawing.Color.White; this.chbTodos.Location = new System.Drawing.Point(671, 70); this.chbTodos.Name = "chbTodos"; this.chbTodos.Size = new System.Drawing.Size(130, 24); this.chbTodos.TabIndex = 46; this.chbTodos.Text = "Todos los informes"; // // groupBox1 // this.groupBox1.Controls.Add(this.rbColada); this.groupBox1.Controls.Add(this.radioButton1); this.groupBox1.ForeColor = System.Drawing.Color.White; this.groupBox1.Location = new System.Drawing.Point(612, 2); this.groupBox1.Name = "groupBox1"; this.groupBox1.Size = new System.Drawing.Size(123, 67); this.groupBox1.TabIndex = 45; this.groupBox1.TabStop = false; this.groupBox1.Text = "Formato"; // // rbColada // this.rbColada.AutoSize = true; this.rbColada.Checked = true; this.rbColada.ForeColor = System.Drawing.Color.White; this.rbColada.Location = new System.Drawing.Point(7, 43); this.rbColada.Name = "rbColada"; this.rbColada.Size = new System.Drawing.Size(98, 17); this.rbColada.TabIndex = 1; this.rbColada.TabStop = true; this.rbColada.Text = "Colada, remesa"; this.rbColada.UseVisualStyleBackColor = true; // // radioButton1 // this.radioButton1.AutoSize = true; this.radioButton1.ForeColor = System.Drawing.Color.White; this.radioButton1.Location = new System.Drawing.Point(7, 19); this.radioButton1.Name = "radioButton1"; this.radioButton1.Size = new System.Drawing.Size(96, 17); this.radioButton1.TabIndex = 0; this.radioButton1.Text = "Características"; this.radioButton1.UseVisualStyleBackColor = true; // // chbLab // this.chbLab.Checked = true; this.chbLab.CheckState = System.Windows.Forms.CheckState.Checked; this.chbLab.ForeColor = System.Drawing.Color.White; this.chbLab.Location = new System.Drawing.Point(370, 71); this.chbLab.Name = "chbLab"; this.chbLab.Size = new System.Drawing.Size(115, 24); this.chbLab.TabIndex = 41; this.chbLab.Text = "Incluye laboratorio"; // // chbFormato // this.chbFormato.ForeColor = System.Drawing.Color.White; this.chbFormato.Location = new System.Drawing.Point(495, 71); this.chbFormato.Name = "chbFormato"; this.chbFormato.Size = new System.Drawing.Size(183, 24); this.chbFormato.TabIndex = 33; this.chbFormato.Text = "Incluye imagen de acreditación"; // // chbLeyenda // this.chbLeyenda.Checked = true; this.chbLeyenda.CheckState = System.Windows.Forms.CheckState.Checked; this.chbLeyenda.ForeColor = System.Drawing.Color.White; this.chbLeyenda.Location = new System.Drawing.Point(243, 71); this.chbLeyenda.Name = "chbLeyenda"; this.chbLeyenda.Size = new System.Drawing.Size(116, 24); this.chbLeyenda.TabIndex = 32; this.chbLeyenda.Text = "Formato leyenda"; // // chbDuplicado // this.chbDuplicado.ForeColor = System.Drawing.Color.White; this.chbDuplicado.Location = new System.Drawing.Point(148, 71); this.chbDuplicado.Name = "chbDuplicado"; this.chbDuplicado.Size = new System.Drawing.Size(88, 24); this.chbDuplicado.TabIndex = 30; this.chbDuplicado.Text = "¿Duplicado?"; // // txtFolio // this.txtFolio.Location = new System.Drawing.Point(542, 8); this.txtFolio.Name = "txtFolio"; this.txtFolio.Size = new System.Drawing.Size(56, 20); this.txtFolio.TabIndex = 27; // // label6 // this.label6.AutoSize = true; this.label6.ForeColor = System.Drawing.Color.White; this.label6.Location = new System.Drawing.Point(502, 31); this.label6.Name = "label6"; this.label6.Size = new System.Drawing.Size(61, 13); this.label6.TabIndex = 26; this.label6.Text = "Renglones:"; // // txtRenglon // this.txtRenglon.Location = new System.Drawing.Point(573, 31); this.txtRenglon.MaxLength = 2; this.txtRenglon.Name = "txtRenglon"; this.txtRenglon.Size = new System.Drawing.Size(24, 20); this.txtRenglon.TabIndex = 25; this.txtRenglon.Text = "20"; this.txtRenglon.TextAlign = System.Windows.Forms.HorizontalAlignment.Right; // // cmbUnidad // this.cmbUnidad.DataSource = this.dsUnidad1.Unidad; this.cmbUnidad.DisplayMember = "Undescr"; this.cmbUnidad.Location = new System.Drawing.Point(344, 32); this.cmbUnidad.Name = "cmbUnidad"; this.cmbUnidad.Size = new System.Drawing.Size(80, 21); this.cmbUnidad.TabIndex = 23; this.cmbUnidad.ValueMember = "IdUnidad"; // // dsUnidad1 // this.dsUnidad1.DataSetName = "dsUnidad"; this.dsUnidad1.Locale = new System.Globalization.CultureInfo("es-MX"); this.dsUnidad1.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema; // // label5 // this.label5.AutoSize = true; this.label5.ForeColor = System.Drawing.Color.White; this.label5.Location = new System.Drawing.Point(301, 32); this.label5.Name = "label5"; this.label5.Size = new System.Drawing.Size(44, 13); this.label5.TabIndex = 24; this.label5.Text = "Unidad:"; // // label2 // this.label2.AutoSize = true; this.label2.ForeColor = System.Drawing.Color.White; this.label2.Location = new System.Drawing.Point(312, 8); 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.dsBusObra1.Obra; this.cmbIdObra.DisplayMember = "Idobra"; this.cmbIdObra.Location = new System.Drawing.Point(344, 8); 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); // // dsBusObra1 // this.dsBusObra1.DataSetName = "dsBusObra"; this.dsBusObra1.Locale = new System.Globalization.CultureInfo("es-MX"); this.dsBusObra1.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema; // // label1 // this.label1.Font = new System.Drawing.Font("Microsoft Sans Serif", 14F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0))); this.label1.ForeColor = System.Drawing.Color.White; this.label1.Location = new System.Drawing.Point(8, 0); this.label1.Name = "label1"; this.label1.Size = new System.Drawing.Size(272, 56); this.label1.TabIndex = 0; this.label1.Text = "Informe de resistencia de toron de siete alamabres"; // // Fecha // this.Fecha.AutoSize = true; this.Fecha.ForeColor = System.Drawing.Color.White; this.Fecha.Location = new System.Drawing.Point(502, 8); this.Fecha.Name = "Fecha"; this.Fecha.Size = new System.Drawing.Size(32, 13); this.Fecha.TabIndex = 4; this.Fecha.Text = "Folio:"; // // txtIdobra // this.txtIdobra.Location = new System.Drawing.Point(432, 32); 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; // // chbLab1 // this.chbLab1.Checked = true; this.chbLab1.CheckState = System.Windows.Forms.CheckState.Checked; this.chbLab1.ForeColor = System.Drawing.Color.White; this.chbLab1.Location = new System.Drawing.Point(16, 71); this.chbLab1.Name = "chbLab1"; this.chbLab1.Size = new System.Drawing.Size(125, 24); this.chbLab1.TabIndex = 41; this.chbLab1.Text = "Incluye laboratorista"; // // crvInfAcero // this.crvInfAcero.ActiveViewIndex = -1; this.crvInfAcero.BorderStyle = System.Windows.Forms.BorderStyle.FixedSingle; this.crvInfAcero.Cursor = System.Windows.Forms.Cursors.Default; this.crvInfAcero.Dock = System.Windows.Forms.DockStyle.Fill; this.crvInfAcero.EnableRefresh = false; this.crvInfAcero.Location = new System.Drawing.Point(0, 102); this.crvInfAcero.Name = "crvInfAcero"; this.crvInfAcero.ShowCloseButton = false; this.crvInfAcero.ShowGroupTreeButton = false; this.crvInfAcero.ShowLogo = false; this.crvInfAcero.Size = new System.Drawing.Size(929, 422); this.crvInfAcero.TabIndex = 13; this.crvInfAcero.ToolPanelView = CrystalDecisions.Windows.Forms.ToolPanelViewType.None; this.crvInfAcero.Load += new System.EventHandler(this.crvInfAcero_Load); // // sqlDAToronInf // this.sqlDAToronInf.SelectCommand = this.sqlSelectCommand1; this.sqlDAToronInf.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping("Table", "ToronRep", new System.Data.Common.DataColumnMapping[] { new System.Data.Common.DataColumnMapping("Folio", "Folio"), new System.Data.Common.DataColumnMapping("IdObra", "IdObra"), new System.Data.Common.DataColumnMapping("ConsObra", "ConsObra"), new System.Data.Common.DataColumnMapping("FMuestreo", "FMuestreo"), new System.Data.Common.DataColumnMapping("FEnsaye", "FEnsaye"), new System.Data.Common.DataColumnMapping("Finforme", "Finforme"), new System.Data.Common.DataColumnMapping("Lab", "Lab"), new System.Data.Common.DataColumnMapping("Anos", "Anos"), new System.Data.Common.DataColumnMapping("Semana", "Semana"), new System.Data.Common.DataColumnMapping("Hoja", "Hoja"), new System.Data.Common.DataColumnMapping("MuesEn", "MuesEn"), new System.Data.Common.DataColumnMapping("Observac", "Observac"), new System.Data.Common.DataColumnMapping("Especifica", "Especifica"), new System.Data.Common.DataColumnMapping("Metodo", "Metodo"), new System.Data.Common.DataColumnMapping("Diametro1", "Diametro1"), new System.Data.Common.DataColumnMapping("Diametro2", "Diametro2"), new System.Data.Common.DataColumnMapping("Paso1", "Paso1"), new System.Data.Common.DataColumnMapping("Paso2", "Paso2"), new System.Data.Common.DataColumnMapping("Diferencia", "Diferencia"), new System.Data.Common.DataColumnMapping("Carga1", "Carga1"), new System.Data.Common.DataColumnMapping("Cargamax", "Cargamax"), new System.Data.Common.DataColumnMapping("Alarga", "Alarga"), new System.Data.Common.DataColumnMapping("Marca", "Marca"), new System.Data.Common.DataColumnMapping("Procede", "Procede"), new System.Data.Common.DataColumnMapping("Tipo", "Tipo"), new System.Data.Common.DataColumnMapping("Muestra", "Muestra"), new System.Data.Common.DataColumnMapping("MetodoR", "MetodoR"), new System.Data.Common.DataColumnMapping("Diametro", "Diametro"), new System.Data.Common.DataColumnMapping("Area", "Area"), new System.Data.Common.DataColumnMapping("Paso", "Paso"), new System.Data.Common.DataColumnMapping("DiamPro", "DiamPro"), new System.Data.Common.DataColumnMapping("DiamAla", "DiamAla"), new System.Data.Common.DataColumnMapping("DiferenciaR", "DiferenciaR"), new System.Data.Common.DataColumnMapping("CargaDef", "CargaDef"), new System.Data.Common.DataColumnMapping("CargaMaxR", "CargaMaxR"), new System.Data.Common.DataColumnMapping("CargaFlu", "CargaFlu"), new System.Data.Common.DataColumnMapping("EsfMAX", "EsfMAX"), new System.Data.Common.DataColumnMapping("AlargaR", "AlargaR"), new System.Data.Common.DataColumnMapping("Rompieron", "Rompieron"), new System.Data.Common.DataColumnMapping("Observa", "Observa"), new System.Data.Common.DataColumnMapping("Observa1", "Observa1"), new System.Data.Common.DataColumnMapping("Nota", "Nota"), new System.Data.Common.DataColumnMapping("Nota1", "Nota1"), new System.Data.Common.DataColumnMapping("Razonsocial", "Razonsocial"), new System.Data.Common.DataColumnMapping("Ubicacion", "Ubicacion"), new System.Data.Common.DataColumnMapping("Colonia", "Colonia"), new System.Data.Common.DataColumnMapping("Zona", "Zona"), new System.Data.Common.DataColumnMapping("Colada", "Colada"), new System.Data.Common.DataColumnMapping("Remesa", "Remesa") }) }); // // sqlSelectCommand1 // this.sqlSelectCommand1.CommandText = "[ToronRep]"; this.sqlSelectCommand1.CommandType = System.Data.CommandType.StoredProcedure; this.sqlSelectCommand1.Connection = this.sqlConn; this.sqlSelectCommand1.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("@Folio1", System.Data.SqlDbType.VarChar, 10), new System.Data.SqlClient.SqlParameter("@IdUnidad", System.Data.SqlDbType.SmallInt, 2), new System.Data.SqlClient.SqlParameter("@Numren", System.Data.SqlDbType.SmallInt, 2) }); // // sqlConn // this.sqlConn.ConnectionString = ((string)(configurationAppSettings.GetValue("sqlConn.ConnectionString", typeof(string)))); this.sqlConn.FireInfoMessageEventOnUserErrors = false; // // dsFirmas1 // this.dsFirmas1.DataSetName = "dsFirmas"; this.dsFirmas1.Locale = new System.Globalization.CultureInfo("es-MX"); this.dsFirmas1.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema; // // sqlDAFirmas // this.sqlDAFirmas.SelectCommand = this.sqlSelectCommand7; this.sqlDAFirmas.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping("Table", "Firmas", new System.Data.Common.DataColumnMapping[] { new System.Data.Common.DataColumnMapping("IdFirma", "IdFirma"), new System.Data.Common.DataColumnMapping("Nombre", "Nombre"), new System.Data.Common.DataColumnMapping("Cargo", "Cargo"), new System.Data.Common.DataColumnMapping("Imprime", "Imprime") }) }); // // sqlSelectCommand7 // this.sqlSelectCommand7.CommandText = "SELECT IdFirma, Nombre, Cargo, Imprime FROM Firmas WHERE (Imprime = 1) ORDER BY I" + "dFirma"; this.sqlSelectCommand7.Connection = this.sqlConn; // // 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; // // sqlDAUnidad // this.sqlDAUnidad.SelectCommand = this.sqlCommand2; 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") }) }); // // sqlCommand2 // this.sqlCommand2.CommandText = "SELECT IdUnidad, Factor, Undescr, MaxagrUn, RevenUn FROM Unidad"; this.sqlCommand2.Connection = this.sqlConn; // // sqlDAToronMdor // this.sqlDAToronMdor.SelectCommand = this.sqlSelectCommand2; this.sqlDAToronMdor.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping("Table", "Toron7AlamMdor", new System.Data.Common.DataColumnMapping[] { new System.Data.Common.DataColumnMapping("FOLIO", "FOLIO"), new System.Data.Common.DataColumnMapping("Idobra", "Idobra"), new System.Data.Common.DataColumnMapping("ConsObra", "ConsObra"), new System.Data.Common.DataColumnMapping("FMuestreo", "FMuestreo"), new System.Data.Common.DataColumnMapping("FEnsaye", "FEnsaye"), new System.Data.Common.DataColumnMapping("FInforme", "FInforme"), new System.Data.Common.DataColumnMapping("NoEco", "NoEco"), new System.Data.Common.DataColumnMapping("Semana", "Semana"), new System.Data.Common.DataColumnMapping("MuestreadasEn", "MuestreadasEn"), new System.Data.Common.DataColumnMapping("Observaciones", "Observaciones") }) }); // // sqlSelectCommand2 // this.sqlSelectCommand2.CommandText = "SELECT FOLIO, Idobra, ConsObra, FMuestreo, FEnsaye, FInforme, NoEco, Semana, Mues" + "treadasEn, Observaciones FROM Toron7AlamMdor WHERE (Idobra = @IdObra)"; this.sqlSelectCommand2.Connection = this.sqlConn; this.sqlSelectCommand2.Parameters.AddRange(new System.Data.SqlClient.SqlParameter[] { new System.Data.SqlClient.SqlParameter("@IdObra", System.Data.SqlDbType.NVarChar, 50, "Idobra") }); // // dsToronRep1 // this.dsToronRep1.DataSetName = "dsToronRep"; this.dsToronRep1.Locale = new System.Globalization.CultureInfo("es-MX"); this.dsToronRep1.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema; // // sqlDANorma // this.sqlDANorma.SelectCommand = this.sqlSelectCommand3; this.sqlDANorma.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping("Table", "Normas", new System.Data.Common.DataColumnMapping[] { new System.Data.Common.DataColumnMapping("IdNorma", "IdNorma"), new System.Data.Common.DataColumnMapping("Informe", "Informe"), new System.Data.Common.DataColumnMapping("Normas", "Normas"), new System.Data.Common.DataColumnMapping("Titulo", "Titulo"), new System.Data.Common.DataColumnMapping("IdInforme", "IdInforme"), new System.Data.Common.DataColumnMapping("Norma1", "Norma1"), new System.Data.Common.DataColumnMapping("Norma2", "Norma2"), new System.Data.Common.DataColumnMapping("Norma3", "Norma3"), new System.Data.Common.DataColumnMapping("Norma4", "Norma4"), new System.Data.Common.DataColumnMapping("Norma5", "Norma5") }) }); // // sqlSelectCommand3 // this.sqlSelectCommand3.CommandText = "SELECT IdNorma, Informe, Normas, Titulo, IdInforme, Norma1, Norma2, Norma3, Norma" + "4, Norma5 FROM Normas WHERE (IdNorma = @IdNorma) ORDER BY IdNorma"; this.sqlSelectCommand3.Connection = this.sqlConn; this.sqlSelectCommand3.Parameters.AddRange(new System.Data.SqlClient.SqlParameter[] { new System.Data.SqlClient.SqlParameter("@IdNorma", System.Data.SqlDbType.SmallInt, 2, "IdNorma") }); // // chbRespaldo // this.chbRespaldo.ForeColor = System.Drawing.Color.White; this.chbRespaldo.Location = new System.Drawing.Point(795, 71); this.chbRespaldo.Name = "chbRespaldo"; this.chbRespaldo.Size = new System.Drawing.Size(90, 24); this.chbRespaldo.TabIndex = 87; this.chbRespaldo.Text = "Respaldo"; // // InfToron // this.AutoScaleBaseSize = new System.Drawing.Size(5, 13); this.ClientSize = new System.Drawing.Size(929, 524); this.Controls.Add(this.crvInfAcero); this.Controls.Add(this.panel1); this.Name = "InfToron"; this.Text = "InfToron"; this.WindowState = System.Windows.Forms.FormWindowState.Maximized; this.Load += new System.EventHandler(this.InfToron_Load); this.panel1.ResumeLayout(false); this.panel1.PerformLayout(); ((System.ComponentModel.ISupportInitialize)(this.dsToronMdor1)).EndInit(); this.groupBox1.ResumeLayout(false); this.groupBox1.PerformLayout(); ((System.ComponentModel.ISupportInitialize)(this.dsUnidad1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.dsBusObra1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.dsFirmas1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.dsToronRep1)).EndInit(); this.ResumeLayout(false); }