/// <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.Configuration.AppSettingsReader configurationAppSettings = new System.Configuration.AppSettingsReader(); System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(Bascula)); this.sqlDABascula = 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.lblIdBascula = new System.Windows.Forms.Label(); this.lblBascula = new System.Windows.Forms.Label(); this.textBox1 = new System.Windows.Forms.TextBox(); this.dsBascula1 = new LancNeo.dsBascula(); this.textBox2 = new System.Windows.Forms.TextBox(); this.panel1 = new System.Windows.Forms.Panel(); this.buscaBtn1 = new Soluciones2000.Tools.WinLib.BuscaBtn(); this.panelToolBar.SuspendLayout(); ((System.ComponentModel.ISupportInitialize)(this.dsBascula1)).BeginInit(); this.panel1.SuspendLayout(); this.SuspendLayout(); // // statusBar1 // this.statusBar1.ShowPanels = true; this.statusBar1.Size = new System.Drawing.Size(576, 22); // // panelToolBar // this.panelToolBar.Size = new System.Drawing.Size(576, 64); // // sqlDABascula // this.sqlDABascula.DeleteCommand = this.sqlDeleteCommand1; this.sqlDABascula.InsertCommand = this.sqlInsertCommand1; this.sqlDABascula.SelectCommand = this.sqlSelectCommand1; this.sqlDABascula.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping("Table", "Bascula", new System.Data.Common.DataColumnMapping[] { new System.Data.Common.DataColumnMapping("IdBascula", "IdBascula"), new System.Data.Common.DataColumnMapping("Bascula", "Bascula") }) }); this.sqlDABascula.UpdateCommand = this.sqlUpdateCommand1; // // sqlDeleteCommand1 // this.sqlDeleteCommand1.CommandText = "DELETE FROM Bascula WHERE (IdBascula = @Original_IdBascula) AND (Bascula = @Origi" + "nal_Bascula OR @Original_Bascula IS NULL AND Bascula IS NULL)"; this.sqlDeleteCommand1.Connection = this.sqlConn; this.sqlDeleteCommand1.Parameters.AddRange(new System.Data.SqlClient.SqlParameter[] { new System.Data.SqlClient.SqlParameter("@Original_IdBascula", System.Data.SqlDbType.NVarChar, 2, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "IdBascula", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_Bascula", System.Data.SqlDbType.NVarChar, 50, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Bascula", System.Data.DataRowVersion.Original, null) }); // // sqlConn // this.sqlConn.ConnectionString = ((string)(configurationAppSettings.GetValue("sqlConn.ConnectionString", typeof(string)))); this.sqlConn.FireInfoMessageEventOnUserErrors = false; // // sqlInsertCommand1 // this.sqlInsertCommand1.CommandText = "INSERT INTO Bascula(IdBascula, Bascula) VALUES (@IdBascula, @Bascula); SELECT IdB" + "ascula, Bascula FROM Bascula WHERE (IdBascula = @IdBascula)"; this.sqlInsertCommand1.Connection = this.sqlConn; this.sqlInsertCommand1.Parameters.AddRange(new System.Data.SqlClient.SqlParameter[] { new System.Data.SqlClient.SqlParameter("@IdBascula", System.Data.SqlDbType.NVarChar, 2, "IdBascula"), new System.Data.SqlClient.SqlParameter("@Bascula", System.Data.SqlDbType.NVarChar, 50, "Bascula") }); // // sqlSelectCommand1 // this.sqlSelectCommand1.CommandText = "SELECT IdBascula, Bascula FROM Bascula"; 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("@IdBascula", System.Data.SqlDbType.NVarChar, 2, "IdBascula"), new System.Data.SqlClient.SqlParameter("@Bascula", System.Data.SqlDbType.NVarChar, 50, "Bascula"), new System.Data.SqlClient.SqlParameter("@Original_IdBascula", System.Data.SqlDbType.NVarChar, 2, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "IdBascula", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_Bascula", System.Data.SqlDbType.NVarChar, 50, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Bascula", System.Data.DataRowVersion.Original, null) }); // // lblIdBascula // this.lblIdBascula.Location = new System.Drawing.Point(32, 48); this.lblIdBascula.Name = "lblIdBascula"; this.lblIdBascula.Size = new System.Drawing.Size(72, 23); this.lblIdBascula.TabIndex = 3; this.lblIdBascula.Text = "Id Báscula:"; this.lblIdBascula.TextAlign = System.Drawing.ContentAlignment.MiddleRight; this.lblIdBascula.Click += new System.EventHandler(this.label1_Click); // // lblBascula // this.lblBascula.Location = new System.Drawing.Point(32, 88); this.lblBascula.Name = "lblBascula"; this.lblBascula.Size = new System.Drawing.Size(72, 23); this.lblBascula.TabIndex = 3; this.lblBascula.Text = "Báscula:"; this.lblBascula.TextAlign = System.Drawing.ContentAlignment.MiddleRight; this.lblBascula.Click += new System.EventHandler(this.label2_Click); // // textBox1 // this.textBox1.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dsBascula1, "Bascula.IdBascula", true)); this.textBox1.Location = new System.Drawing.Point(112, 48); this.textBox1.Name = "textBox1"; this.textBox1.Size = new System.Drawing.Size(56, 20); this.textBox1.TabIndex = 4; this.textBox1.Text = "textBox1"; // // dsBascula1 // this.dsBascula1.DataSetName = "dsBascula"; this.dsBascula1.Locale = new System.Globalization.CultureInfo("es-MX"); this.dsBascula1.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema; // // textBox2 // this.textBox2.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dsBascula1, "Bascula.Bascula", true)); this.textBox2.Location = new System.Drawing.Point(112, 88); this.textBox2.Name = "textBox2"; this.textBox2.Size = new System.Drawing.Size(240, 20); this.textBox2.TabIndex = 4; this.textBox2.Text = "textBox1"; // // panel1 // this.panel1.BorderStyle = System.Windows.Forms.BorderStyle.Fixed3D; this.panel1.Controls.Add(this.buscaBtn1); this.panel1.Controls.Add(this.textBox2); this.panel1.Controls.Add(this.lblIdBascula); this.panel1.Controls.Add(this.lblBascula); this.panel1.Controls.Add(this.textBox1); this.panel1.Location = new System.Drawing.Point(80, 120); this.panel1.Name = "panel1"; this.panel1.Size = new System.Drawing.Size(384, 176); this.panel1.TabIndex = 8; // // buscaBtn1 // this.buscaBtn1.AnchoDlgBusq = 0; this.buscaBtn1.BackColor = System.Drawing.Color.Transparent; this.buscaBtn1.Datos = this.dsBascula1.Bascula; this.buscaBtn1.ForeColor = System.Drawing.Color.Transparent; this.buscaBtn1.Icon = ((System.Drawing.Icon)(resources.GetObject("buscaBtn1.Icon"))); this.buscaBtn1.Location = new System.Drawing.Point(176, 16); this.buscaBtn1.Name = "buscaBtn1"; this.buscaBtn1.Size = new System.Drawing.Size(64, 64); this.buscaBtn1.TabIndex = 5; this.toolTip1.SetToolTip(this.buscaBtn1, "Buscar"); // // Bascula // this.AutoScaleBaseSize = new System.Drawing.Size(5, 13); this.AutoSizeMode = System.Windows.Forms.AutoSizeMode.GrowAndShrink; this.ClientSize = new System.Drawing.Size(576, 423); this.Controls.Add(this.panel1); this.DAGeneral = this.sqlDABascula; this.dsGeneral = this.dsBascula1; this.FormBorderStyle = System.Windows.Forms.FormBorderStyle.SizableToolWindow; this.Name = "Bascula"; this.NombreTabla = "Bascula"; this.StartPosition = System.Windows.Forms.FormStartPosition.CenterParent; this.Text = "Catálogo de Básculas"; this.Load += new System.EventHandler(this.Bascula_Load); this.Controls.SetChildIndex(this.statusBar1, 0); this.Controls.SetChildIndex(this.panelToolBar, 0); this.Controls.SetChildIndex(this.panel1, 0); this.panelToolBar.ResumeLayout(false); ((System.ComponentModel.ISupportInitialize)(this.dsBascula1)).EndInit(); this.panel1.ResumeLayout(false); this.panel1.PerformLayout(); 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(Tempranos)); this.sqlDATempranos = 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.dsTempranos1 = new LancNeo.dsTempranos(); this.txtIdTempranos = new System.Windows.Forms.TextBox(); this.label1 = new System.Windows.Forms.Label(); this.txtTempranos = new System.Windows.Forms.TextBox(); this.label2 = new System.Windows.Forms.Label(); this.buscaBtn1 = new Soluciones2000.Tools.WinLib.BuscaBtn(); this.panelToolBar.SuspendLayout(); ((System.ComponentModel.ISupportInitialize)(this.dsTempranos1)).BeginInit(); this.SuspendLayout(); // // statusBar1 // this.statusBar1.Location = new System.Drawing.Point(0, 279); this.statusBar1.ShowPanels = true; this.statusBar1.Size = new System.Drawing.Size(576, 22); // // panelToolBar // this.panelToolBar.Size = new System.Drawing.Size(576, 64); // // sqlDATempranos // this.sqlDATempranos.DeleteCommand = this.sqlDeleteCommand1; this.sqlDATempranos.InsertCommand = this.sqlInsertCommand1; this.sqlDATempranos.SelectCommand = this.sqlSelectCommand1; this.sqlDATempranos.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping("Table", "Tempranos", new System.Data.Common.DataColumnMapping[] { new System.Data.Common.DataColumnMapping("IdTempranos", "IdTempranos"), new System.Data.Common.DataColumnMapping("Tempranos", "Tempranos") }) }); this.sqlDATempranos.UpdateCommand = this.sqlUpdateCommand1; // // sqlDeleteCommand1 // this.sqlDeleteCommand1.CommandText = "DELETE FROM Tempranos WHERE (IdTempranos = @Original_IdTempranos) AND (Tempranos " + "= @Original_Tempranos OR @Original_Tempranos IS NULL AND Tempranos IS NULL)"; this.sqlDeleteCommand1.Connection = this.sqlConn; this.sqlDeleteCommand1.Parameters.AddRange(new System.Data.SqlClient.SqlParameter[] { new System.Data.SqlClient.SqlParameter("@Original_IdTempranos", System.Data.SqlDbType.SmallInt, 2, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "IdTempranos", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_Tempranos", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Tempranos", System.Data.DataRowVersion.Original, null) }); // // sqlConn // this.sqlConn.ConnectionString = ((string)(configurationAppSettings.GetValue("sqlConn.ConnectionString", typeof(string)))); this.sqlConn.FireInfoMessageEventOnUserErrors = false; // // sqlInsertCommand1 // this.sqlInsertCommand1.CommandText = "INSERT INTO Tempranos(IdTempranos, Tempranos) VALUES (@IdTempranos, @Tempranos); " + "SELECT IdTempranos, Tempranos FROM Tempranos WHERE (IdTempranos = @IdTempranos)"; this.sqlInsertCommand1.Connection = this.sqlConn; this.sqlInsertCommand1.Parameters.AddRange(new System.Data.SqlClient.SqlParameter[] { new System.Data.SqlClient.SqlParameter("@IdTempranos", System.Data.SqlDbType.SmallInt, 2, "IdTempranos"), new System.Data.SqlClient.SqlParameter("@Tempranos", System.Data.SqlDbType.VarChar, 10, "Tempranos") }); // // sqlSelectCommand1 // this.sqlSelectCommand1.CommandText = "SELECT IdTempranos, Tempranos FROM Tempranos"; 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("@IdTempranos", System.Data.SqlDbType.SmallInt, 2, "IdTempranos"), new System.Data.SqlClient.SqlParameter("@Tempranos", System.Data.SqlDbType.VarChar, 10, "Tempranos"), new System.Data.SqlClient.SqlParameter("@Original_IdTempranos", System.Data.SqlDbType.SmallInt, 2, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "IdTempranos", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_Tempranos", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Tempranos", System.Data.DataRowVersion.Original, null) }); // // dsTempranos1 // this.dsTempranos1.DataSetName = "dsTempranos"; this.dsTempranos1.Locale = new System.Globalization.CultureInfo("es-MX"); this.dsTempranos1.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema; // // txtIdTempranos // this.txtIdTempranos.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dsTempranos1, "Tempranos.IdTempranos", true)); this.txtIdTempranos.Location = new System.Drawing.Point(160, 95); this.txtIdTempranos.Name = "txtIdTempranos"; this.txtIdTempranos.Size = new System.Drawing.Size(46, 20); this.txtIdTempranos.TabIndex = 4; this.txtIdTempranos.Text = "0"; // // label1 // this.label1.Location = new System.Drawing.Point(74, 94); this.label1.Name = "label1"; this.label1.Size = new System.Drawing.Size(84, 23); this.label1.TabIndex = 5; this.label1.Text = "IdTempranos:"; this.label1.TextAlign = System.Drawing.ContentAlignment.MiddleRight; // // txtTempranos // this.txtTempranos.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dsTempranos1, "Tempranos.Tempranos", true)); this.txtTempranos.Location = new System.Drawing.Point(160, 126); this.txtTempranos.Name = "txtTempranos"; this.txtTempranos.Size = new System.Drawing.Size(100, 20); this.txtTempranos.TabIndex = 6; this.txtTempranos.Text = "textBox1"; // // label2 // this.label2.Location = new System.Drawing.Point(74, 125); this.label2.Name = "label2"; this.label2.Size = new System.Drawing.Size(84, 23); this.label2.TabIndex = 7; this.label2.Text = "Tempranos:"; this.label2.TextAlign = System.Drawing.ContentAlignment.MiddleRight; // // buscaBtn1 // this.buscaBtn1.AnchoColTit = true; this.buscaBtn1.AnchoDlgBusq = 400; this.buscaBtn1.BackColor = System.Drawing.Color.Transparent; this.buscaBtn1.Datos = this.dsTempranos1.Tempranos; this.buscaBtn1.Icon = ((System.Drawing.Icon)(resources.GetObject("buscaBtn1.Icon"))); this.buscaBtn1.Location = new System.Drawing.Point(276, 90); this.buscaBtn1.Name = "buscaBtn1"; this.buscaBtn1.Size = new System.Drawing.Size(64, 64); this.buscaBtn1.TabIndex = 8; this.buscaBtn1.Click += new System.EventHandler(this.buscaBtn1_Click); // // Tempranos // this.AutoScaleBaseSize = new System.Drawing.Size(5, 13); this.ClientSize = new System.Drawing.Size(576, 301); this.Controls.Add(this.buscaBtn1); this.Controls.Add(this.label2); this.Controls.Add(this.txtTempranos); this.Controls.Add(this.label1); this.Controls.Add(this.txtIdTempranos); this.DAGeneral = this.sqlDATempranos; this.dsGeneral = this.dsTempranos1; this.Name = "Tempranos"; this.NombreTabla = "Tempranos"; this.Text = "Tempranos"; this.Load += new System.EventHandler(this.Tempranos_Load); this.Controls.SetChildIndex(this.txtIdTempranos, 0); this.Controls.SetChildIndex(this.label1, 0); this.Controls.SetChildIndex(this.txtTempranos, 0); this.Controls.SetChildIndex(this.statusBar1, 0); this.Controls.SetChildIndex(this.panelToolBar, 0); this.Controls.SetChildIndex(this.label2, 0); this.Controls.SetChildIndex(this.buscaBtn1, 0); this.panelToolBar.ResumeLayout(false); ((System.ComponentModel.ISupportInitialize)(this.dsTempranos1)).EndInit(); this.ResumeLayout(false); this.PerformLayout(); }
/// <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(RepMuestreador)); System.Configuration.AppSettingsReader configurationAppSettings = new System.Configuration.AppSettingsReader(); this.label1 = new System.Windows.Forms.Label(); this.buscaBtn1 = new Soluciones2000.Tools.WinLib.BuscaBtn(); this.dsBusMuestreador1 = new LancNeo.dsBusMuestreador(); this.txtIdobra = new System.Windows.Forms.TextBox(); this.Fecha = new System.Windows.Forms.Label(); this.txtFecha = new System.Windows.Forms.TextBox(); this.btnVistaPrevia = new Soluciones2000.Tools.WinLib.tbBtn(); this.sqlDABusMuestreador = new System.Data.SqlClient.SqlDataAdapter(); this.sqlSelectCommand1 = new System.Data.SqlClient.SqlCommand(); this.sqlConn = new System.Data.SqlClient.SqlConnection(); this.sqlDARepMuestreador = new System.Data.SqlClient.SqlDataAdapter(); this.sqlSelectCommand2 = new System.Data.SqlClient.SqlCommand(); this.dsRepMuestreador1 = new LancNeo.dsRepMuestreador(); this.cryRepMuestreador1 = new LancNeo.CryRepMuestreador(); this.panel1 = new System.Windows.Forms.Panel(); this.chbLab1 = new System.Windows.Forms.CheckBox(); this.label2 = new System.Windows.Forms.Label(); this.comboBox1 = new System.Windows.Forms.ComboBox(); this.dsBusObra1 = new LancNeo.dsBusObra(); this.crvRepMuestreador = new CrystalDecisions.Windows.Forms.CrystalReportViewer(); this.sqlDABusObra = new System.Data.SqlClient.SqlDataAdapter(); this.sqlCommand1 = new System.Data.SqlClient.SqlCommand(); ((System.ComponentModel.ISupportInitialize)(this.dsBusMuestreador1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.dsRepMuestreador1)).BeginInit(); this.panel1.SuspendLayout(); ((System.ComponentModel.ISupportInitialize)(this.dsBusObra1)).BeginInit(); this.SuspendLayout(); // // label1 // 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, 8); this.label1.Name = "label1"; this.label1.Size = new System.Drawing.Size(279, 23); this.label1.TabIndex = 0; this.label1.Text = "Reporte de Muestreador"; // // buscaBtn1 // this.buscaBtn1.AnchoDlgBusq = 450; this.buscaBtn1.BackColor = System.Drawing.Color.Transparent; this.buscaBtn1.Datos = this.dsBusMuestreador1.Muestreador; this.buscaBtn1.Icon = ((System.Drawing.Icon)(resources.GetObject("buscaBtn1.Icon"))); this.buscaBtn1.Location = new System.Drawing.Point(448, 0); this.buscaBtn1.Name = "buscaBtn1"; this.buscaBtn1.Size = new System.Drawing.Size(64, 64); this.buscaBtn1.TabIndex = 1; this.buscaBtn1.Visible = false; this.buscaBtn1.Click += new System.EventHandler(this.buscaBtn1_Click); // // dsBusMuestreador1 // this.dsBusMuestreador1.DataSetName = "dsBusMuestreador"; this.dsBusMuestreador1.Locale = new System.Globalization.CultureInfo("es-MX"); this.dsBusMuestreador1.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema; // // txtIdobra // this.txtIdobra.Location = new System.Drawing.Point(464, 16); 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; // // Fecha // this.Fecha.AutoSize = true; this.Fecha.Location = new System.Drawing.Point(520, 16); this.Fecha.Name = "Fecha"; this.Fecha.Size = new System.Drawing.Size(40, 13); this.Fecha.TabIndex = 4; this.Fecha.Text = "Fecha:"; // // txtFecha // this.txtFecha.Location = new System.Drawing.Point(560, 16); this.txtFecha.Name = "txtFecha"; this.txtFecha.ReadOnly = true; this.txtFecha.Size = new System.Drawing.Size(80, 20); this.txtFecha.TabIndex = 5; this.txtFecha.TextChanged += new System.EventHandler(this.txtFecha_TextChanged); // // 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(646, 0); this.btnVistaPrevia.Name = "btnVistaPrevia"; this.btnVistaPrevia.Size = new System.Drawing.Size(64, 64); this.btnVistaPrevia.TabIndex = 6; this.btnVistaPrevia.Visible = false; this.btnVistaPrevia.Click += new System.EventHandler(this.btnVistaPrevia_Click); // // sqlDABusMuestreador // this.sqlDABusMuestreador.SelectCommand = this.sqlSelectCommand1; this.sqlDABusMuestreador.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping("Table", "Muestreador", new System.Data.Common.DataColumnMapping[] { new System.Data.Common.DataColumnMapping("IdObra", "IdObra"), new System.Data.Common.DataColumnMapping("Fecha", "Fecha") }) }); // // sqlSelectCommand1 // this.sqlSelectCommand1.CommandText = "SELECT IdObra, Fecha FROM Muestreador WHERE (IdObra = @IdObra) ORDER BY IdObra"; this.sqlSelectCommand1.Connection = this.sqlConn; this.sqlSelectCommand1.Parameters.AddRange(new System.Data.SqlClient.SqlParameter[] { new System.Data.SqlClient.SqlParameter("@IdObra", System.Data.SqlDbType.NVarChar, 6, "IdObra") }); // // sqlConn // this.sqlConn.ConnectionString = ((string)(configurationAppSettings.GetValue("sqlConn.ConnectionString", typeof(string)))); this.sqlConn.FireInfoMessageEventOnUserErrors = false; // // sqlDARepMuestreador // this.sqlDARepMuestreador.SelectCommand = this.sqlSelectCommand2; this.sqlDARepMuestreador.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping("Table", "RepMuestreado", new System.Data.Common.DataColumnMapping[] { new System.Data.Common.DataColumnMapping("IdObra", "IdObra"), new System.Data.Common.DataColumnMapping("Descripcion", "Descripcion"), new System.Data.Common.DataColumnMapping("Ubicacion", "Ubicacion"), new System.Data.Common.DataColumnMapping("Facturar", "Facturar"), new System.Data.Common.DataColumnMapping("Fecha", "Fecha"), new System.Data.Common.DataColumnMapping("NoEco", "NoEco"), new System.Data.Common.DataColumnMapping("Zona", "Zona"), new System.Data.Common.DataColumnMapping("Laboratorista", "Laboratorista"), new System.Data.Common.DataColumnMapping("Semana", "Semana"), new System.Data.Common.DataColumnMapping("Hinicio", "Hinicio"), new System.Data.Common.DataColumnMapping("Hfinal", "Hfinal"), new System.Data.Common.DataColumnMapping("Vsolicitado", "Vsolicitado"), new System.Data.Common.DataColumnMapping("Textra", "Textra"), new System.Data.Common.DataColumnMapping("Volumen", "Volumen"), new System.Data.Common.DataColumnMapping("Nmuestras", "Nmuestras"), new System.Data.Common.DataColumnMapping("Ncilindros", "Ncilindros"), new System.Data.Common.DataColumnMapping("M1dv", "M1dv"), new System.Data.Common.DataColumnMapping("M3dv", "M3dv"), new System.Data.Common.DataColumnMapping("M3d", "M3d"), new System.Data.Common.DataColumnMapping("M7d", "M7d"), new System.Data.Common.DataColumnMapping("M14d", "M14d"), new System.Data.Common.DataColumnMapping("M28d", "M28d"), new System.Data.Common.DataColumnMapping("Observaciones", "Observaciones"), new System.Data.Common.DataColumnMapping("Consecutivo", "Consecutivo"), new System.Data.Common.DataColumnMapping("Fecham", "Fecham"), new System.Data.Common.DataColumnMapping("Muestra", "Muestra"), new System.Data.Common.DataColumnMapping("IdConcretera", "IdConcretera"), new System.Data.Common.DataColumnMapping("IdPlanta", "IdPlanta"), new System.Data.Common.DataColumnMapping("ResistenciaKG", "ResistenciaKG"), new System.Data.Common.DataColumnMapping("tipo", "tipo"), new System.Data.Common.DataColumnMapping("Agregado", "Agregado"), new System.Data.Common.DataColumnMapping("Revenimento", "Revenimento"), new System.Data.Common.DataColumnMapping("Grado", "Grado"), new System.Data.Common.DataColumnMapping("IdAgregado", "IdAgregado"), new System.Data.Common.DataColumnMapping("Agregado1", "Agregado1"), new System.Data.Common.DataColumnMapping("IdRemision", "IdRemision"), new System.Data.Common.DataColumnMapping("IdOlla", "IdOlla"), new System.Data.Common.DataColumnMapping("Volumen1", "Volumen1"), new System.Data.Common.DataColumnMapping("Hora", "Hora"), new System.Data.Common.DataColumnMapping("RevObt", "RevObt"), new System.Data.Common.DataColumnMapping("Elemento", "Elemento"), new System.Data.Common.DataColumnMapping("Ejes", "Ejes"), new System.Data.Common.DataColumnMapping("Nivel", "Nivel"), new System.Data.Common.DataColumnMapping("Edif", "Edif"), new System.Data.Common.DataColumnMapping("Observa", "Observa") }) }); this.sqlDARepMuestreador.RowUpdated += new System.Data.SqlClient.SqlRowUpdatedEventHandler(this.sqlDARepMuestreador_RowUpdated); // // sqlSelectCommand2 // this.sqlSelectCommand2.CommandText = "[RepMuestreado]"; 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("@Fecha", System.Data.SqlDbType.DateTime, 8) }); // // dsRepMuestreador1 // this.dsRepMuestreador1.DataSetName = "dsRepMuestreador"; this.dsRepMuestreador1.Locale = new System.Globalization.CultureInfo("en-US"); this.dsRepMuestreador1.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.chbLab1); this.panel1.Controls.Add(this.label2); this.panel1.Controls.Add(this.comboBox1); this.panel1.Controls.Add(this.label1); this.panel1.Controls.Add(this.txtIdobra); this.panel1.Controls.Add(this.txtFecha); this.panel1.Controls.Add(this.Fecha); 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(880, 56); this.panel1.TabIndex = 8; // // chbLab1 // this.chbLab1.Checked = true; this.chbLab1.CheckState = System.Windows.Forms.CheckState.Checked; this.chbLab1.Location = new System.Drawing.Point(106, 34); this.chbLab1.Name = "chbLab1"; this.chbLab1.Size = new System.Drawing.Size(133, 21); this.chbLab1.TabIndex = 41; this.chbLab1.Text = "Incluye laboratorista"; // // label2 // this.label2.AutoSize = true; this.label2.Location = new System.Drawing.Point(336, 18); this.label2.Name = "label2"; this.label2.Size = new System.Drawing.Size(33, 13); this.label2.TabIndex = 8; this.label2.Text = "Obra:"; // // comboBox1 // this.comboBox1.DataBindings.Add(new System.Windows.Forms.Binding("SelectedValue", this.dsBusObra1, "Obra.Idobra", true)); this.comboBox1.DataSource = this.dsBusObra1.Obra; this.comboBox1.DisplayMember = "IdObra"; this.comboBox1.Location = new System.Drawing.Point(376, 16); this.comboBox1.Name = "comboBox1"; this.comboBox1.Size = new System.Drawing.Size(64, 21); this.comboBox1.TabIndex = 7; this.comboBox1.ValueMember = "IdObra"; this.comboBox1.SelectedIndexChanged += new System.EventHandler(this.comboBox1_SelectedIndexChanged); // // dsBusObra1 // this.dsBusObra1.DataSetName = "dsBusObra"; this.dsBusObra1.Locale = new System.Globalization.CultureInfo("es-MX"); this.dsBusObra1.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema; // // crvRepMuestreador // this.crvRepMuestreador.ActiveViewIndex = -1; this.crvRepMuestreador.BorderStyle = System.Windows.Forms.BorderStyle.FixedSingle; this.crvRepMuestreador.Cursor = System.Windows.Forms.Cursors.Default; this.crvRepMuestreador.Dock = System.Windows.Forms.DockStyle.Fill; this.crvRepMuestreador.EnableRefresh = false; this.crvRepMuestreador.Location = new System.Drawing.Point(0, 56); this.crvRepMuestreador.Name = "crvRepMuestreador"; this.crvRepMuestreador.ShowCloseButton = false; this.crvRepMuestreador.ShowGroupTreeButton = false; this.crvRepMuestreador.ShowLogo = false; this.crvRepMuestreador.Size = new System.Drawing.Size(880, 645); this.crvRepMuestreador.TabIndex = 9; this.crvRepMuestreador.ToolPanelView = CrystalDecisions.Windows.Forms.ToolPanelViewType.None; // // 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; // // RepMuestreador // this.AutoScaleBaseSize = new System.Drawing.Size(5, 13); this.ClientSize = new System.Drawing.Size(880, 701); this.Controls.Add(this.crvRepMuestreador); this.Controls.Add(this.panel1); this.MinimizeBox = false; this.Name = "RepMuestreador"; this.Text = "RepMuestreador"; this.WindowState = System.Windows.Forms.FormWindowState.Maximized; this.Load += new System.EventHandler(this.RepMuestreador_Load); ((System.ComponentModel.ISupportInitialize)(this.dsBusMuestreador1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.dsRepMuestreador1)).EndInit(); this.panel1.ResumeLayout(false); this.panel1.PerformLayout(); ((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(Diametro)); System.Configuration.AppSettingsReader configurationAppSettings = new System.Configuration.AppSettingsReader(); this.sqlDAdiametro = 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.dsDiametro1 = new LancNeo.dsDiametro(); this.panel1 = new System.Windows.Forms.Panel(); this.buscaBtn1 = new Soluciones2000.Tools.WinLib.BuscaBtn(); this.txtFigura = new System.Windows.Forms.TextBox(); this.label2 = new System.Windows.Forms.Label(); this.textBox2 = new System.Windows.Forms.TextBox(); this.Diámetro = new System.Windows.Forms.Label(); this.label1 = new System.Windows.Forms.Label(); this.txtIdDiametro = new System.Windows.Forms.TextBox(); this.panelToolBar.SuspendLayout(); ((System.ComponentModel.ISupportInitialize)(this.dsDiametro1)).BeginInit(); this.panel1.SuspendLayout(); this.SuspendLayout(); // // statusBar1 // this.statusBar1.Location = new System.Drawing.Point(0, 351); this.statusBar1.ShowPanels = true; this.statusBar1.Size = new System.Drawing.Size(624, 22); // // panelToolBar // this.panelToolBar.Size = new System.Drawing.Size(624, 64); // // sqlDAdiametro // this.sqlDAdiametro.DeleteCommand = this.sqlDeleteCommand1; this.sqlDAdiametro.InsertCommand = this.sqlInsertCommand1; this.sqlDAdiametro.SelectCommand = this.sqlSelectCommand1; 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"), new System.Data.Common.DataColumnMapping("Figura", "Figura") }) }); this.sqlDAdiametro.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_IdDiam", System.Data.SqlDbType.SmallInt, 2, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "IdDiam", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_Diametro", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Diametro", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_Figura", System.Data.SqlDbType.VarChar, 30, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Figura", System.Data.DataRowVersion.Original, null) }); // // sqlConn // this.sqlConn.ConnectionString = ((string)(configurationAppSettings.GetValue("sqlConn.ConnectionString", typeof(string)))); this.sqlConn.FireInfoMessageEventOnUserErrors = false; // // sqlInsertCommand1 // this.sqlInsertCommand1.CommandText = "INSERT INTO Diametro(IdDiam, Diametro, Figura) VALUES (@IdDiam, @Diametro, @Figur" + "a); SELECT IdDiam, Diametro, Figura FROM Diametro WHERE (IdDiam = @IdDiam)"; this.sqlInsertCommand1.Connection = this.sqlConn; this.sqlInsertCommand1.Parameters.AddRange(new System.Data.SqlClient.SqlParameter[] { new System.Data.SqlClient.SqlParameter("@IdDiam", System.Data.SqlDbType.SmallInt, 2, "IdDiam"), new System.Data.SqlClient.SqlParameter("@Diametro", System.Data.SqlDbType.VarChar, 10, "Diametro"), new System.Data.SqlClient.SqlParameter("@Figura", System.Data.SqlDbType.VarChar, 30, "Figura") }); // // sqlSelectCommand1 // this.sqlSelectCommand1.CommandText = "SELECT IdDiam, Diametro, Figura FROM Diametro"; 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("@IdDiam", System.Data.SqlDbType.SmallInt, 2, "IdDiam"), new System.Data.SqlClient.SqlParameter("@Diametro", System.Data.SqlDbType.VarChar, 10, "Diametro"), new System.Data.SqlClient.SqlParameter("@Figura", System.Data.SqlDbType.VarChar, 30, "Figura"), new System.Data.SqlClient.SqlParameter("@Original_IdDiam", System.Data.SqlDbType.SmallInt, 2, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "IdDiam", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_Diametro", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Diametro", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_Figura", System.Data.SqlDbType.VarChar, 30, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Figura", System.Data.DataRowVersion.Original, null) }); // // dsDiametro1 // this.dsDiametro1.DataSetName = "dsDiametro"; this.dsDiametro1.Locale = new System.Globalization.CultureInfo("es-MX"); this.dsDiametro1.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema; // // panel1 // this.panel1.BorderStyle = System.Windows.Forms.BorderStyle.Fixed3D; this.panel1.Controls.Add(this.buscaBtn1); this.panel1.Controls.Add(this.txtFigura); this.panel1.Controls.Add(this.label2); this.panel1.Controls.Add(this.textBox2); this.panel1.Controls.Add(this.Diámetro); this.panel1.Controls.Add(this.label1); this.panel1.Controls.Add(this.txtIdDiametro); this.panel1.Location = new System.Drawing.Point(112, 96); this.panel1.Name = "panel1"; this.panel1.Size = new System.Drawing.Size(392, 168); this.panel1.TabIndex = 3; // // buscaBtn1 // this.buscaBtn1.AnchoDlgBusq = 0; this.buscaBtn1.BackColor = System.Drawing.Color.Transparent; this.buscaBtn1.Datos = this.dsDiametro1.Diametro; this.buscaBtn1.Icon = ((System.Drawing.Icon)(resources.GetObject("buscaBtn1.Icon"))); this.buscaBtn1.Location = new System.Drawing.Point(270, 16); this.buscaBtn1.Name = "buscaBtn1"; this.buscaBtn1.Size = new System.Drawing.Size(64, 64); this.buscaBtn1.TabIndex = 4; this.toolTip1.SetToolTip(this.buscaBtn1, "Buscar"); // // txtFigura // this.txtFigura.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dsDiametro1, "Diametro.Figura", true)); this.txtFigura.Location = new System.Drawing.Point(166, 121); this.txtFigura.Name = "txtFigura"; this.txtFigura.Size = new System.Drawing.Size(100, 20); this.txtFigura.TabIndex = 6; this.txtFigura.Text = "textBox1"; // // label2 // this.label2.Location = new System.Drawing.Point(54, 120); this.label2.Name = "label2"; this.label2.Size = new System.Drawing.Size(100, 23); this.label2.TabIndex = 5; this.label2.Text = "Figura geométrica:"; this.label2.TextAlign = System.Drawing.ContentAlignment.MiddleRight; // // textBox2 // this.textBox2.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dsDiametro1, "Diametro.Diametro", true)); this.textBox2.Location = new System.Drawing.Point(166, 88); this.textBox2.MaxLength = 10; this.textBox2.Name = "textBox2"; this.textBox2.Size = new System.Drawing.Size(100, 20); this.textBox2.TabIndex = 3; // // Diámetro // this.Diámetro.Location = new System.Drawing.Point(54, 88); this.Diámetro.Name = "Diámetro"; this.Diámetro.Size = new System.Drawing.Size(100, 23); this.Diámetro.TabIndex = 2; this.Diámetro.Text = "Diámetro:"; this.Diámetro.TextAlign = System.Drawing.ContentAlignment.MiddleRight; // // label1 // this.label1.Location = new System.Drawing.Point(54, 48); this.label1.Name = "label1"; this.label1.Size = new System.Drawing.Size(100, 23); this.label1.TabIndex = 1; this.label1.Text = "IdDiametro:"; this.label1.TextAlign = System.Drawing.ContentAlignment.MiddleRight; // // txtIdDiametro // this.txtIdDiametro.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dsDiametro1, "Diametro.IdDiam", true)); this.txtIdDiametro.Location = new System.Drawing.Point(166, 48); this.txtIdDiametro.MaxLength = 4; this.txtIdDiametro.Name = "txtIdDiametro"; this.txtIdDiametro.Size = new System.Drawing.Size(100, 20); this.txtIdDiametro.TabIndex = 0; this.txtIdDiametro.TextChanged += new System.EventHandler(this.textBox1_TextChanged); // // Diametro // this.AutoScaleBaseSize = new System.Drawing.Size(5, 13); this.ClientSize = new System.Drawing.Size(624, 373); this.Controls.Add(this.panel1); this.DAGeneral = this.sqlDAdiametro; this.dsGeneral = this.dsDiametro1; this.Name = "Diametro"; this.NombreTabla = "Diametro"; this.Text = "Diametro"; this.Load += new System.EventHandler(this.Diametro_Load); this.Controls.SetChildIndex(this.panel1, 0); this.Controls.SetChildIndex(this.statusBar1, 0); this.Controls.SetChildIndex(this.panelToolBar, 0); this.panelToolBar.ResumeLayout(false); ((System.ComponentModel.ISupportInitialize)(this.dsDiametro1)).EndInit(); this.panel1.ResumeLayout(false); this.panel1.PerformLayout(); 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(Agregado)); this.sqlDAAgregado = 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.dsAgregado1 = new LancNeo.dsAgregado(); this.txtIdAgregado = new System.Windows.Forms.TextBox(); this.txtAgregado = new System.Windows.Forms.TextBox(); this.txtTipo = new System.Windows.Forms.TextBox(); this.lblIdAgregado = new System.Windows.Forms.Label(); this.lblAgregado = new System.Windows.Forms.Label(); this.lblTipo = new System.Windows.Forms.Label(); this.panel1 = new System.Windows.Forms.Panel(); this.buscaBtn1 = new Soluciones2000.Tools.WinLib.BuscaBtn(); this.panelToolBar.SuspendLayout(); ((System.ComponentModel.ISupportInitialize)(this.dsAgregado1)).BeginInit(); this.panel1.SuspendLayout(); this.SuspendLayout(); // // statusBar1 // this.statusBar1.ShowPanels = true; this.statusBar1.Size = new System.Drawing.Size(576, 22); // // panelToolBar // this.panelToolBar.Size = new System.Drawing.Size(576, 64); // // sqlDAAgregado // this.sqlDAAgregado.DeleteCommand = this.sqlDeleteCommand1; this.sqlDAAgregado.InsertCommand = this.sqlInsertCommand1; this.sqlDAAgregado.SelectCommand = this.sqlSelectCommand1; this.sqlDAAgregado.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping("Table", "Agregado", new System.Data.Common.DataColumnMapping[] { new System.Data.Common.DataColumnMapping("IdAgregado", "IdAgregado"), new System.Data.Common.DataColumnMapping("Agregado", "Agregado"), new System.Data.Common.DataColumnMapping("Tipo", "Tipo") }) }); this.sqlDAAgregado.UpdateCommand = this.sqlUpdateCommand1; // // sqlDeleteCommand1 // this.sqlDeleteCommand1.CommandText = "DELETE FROM Agregado WHERE (IdAgregado = @Original_IdAgregado) AND (Agregado = @O" + "riginal_Agregado OR @Original_Agregado IS NULL AND Agregado IS NULL) AND (Tipo =" + " @Original_Tipo)"; this.sqlDeleteCommand1.Connection = this.sqlConn; this.sqlDeleteCommand1.Parameters.AddRange(new System.Data.SqlClient.SqlParameter[] { new System.Data.SqlClient.SqlParameter("@Original_IdAgregado", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "IdAgregado", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_Agregado", System.Data.SqlDbType.NVarChar, 15, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Agregado", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_Tipo", System.Data.SqlDbType.NVarChar, 11, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Tipo", System.Data.DataRowVersion.Original, null) }); // // sqlConn // this.sqlConn.ConnectionString = ((string)(configurationAppSettings.GetValue("sqlConn.ConnectionString", typeof(string)))); this.sqlConn.FireInfoMessageEventOnUserErrors = false; // // sqlInsertCommand1 // this.sqlInsertCommand1.CommandText = "INSERT INTO Agregado(IdAgregado, Agregado, Tipo) VALUES (@IdAgregado, @Agregado, " + "@Tipo); SELECT IdAgregado, Agregado, Tipo FROM Agregado WHERE (IdAgregado = @IdA" + "gregado)"; this.sqlInsertCommand1.Connection = this.sqlConn; this.sqlInsertCommand1.Parameters.AddRange(new System.Data.SqlClient.SqlParameter[] { new System.Data.SqlClient.SqlParameter("@IdAgregado", System.Data.SqlDbType.Int, 4, "IdAgregado"), new System.Data.SqlClient.SqlParameter("@Agregado", System.Data.SqlDbType.NVarChar, 15, "Agregado"), new System.Data.SqlClient.SqlParameter("@Tipo", System.Data.SqlDbType.NVarChar, 11, "Tipo") }); // // sqlSelectCommand1 // this.sqlSelectCommand1.CommandText = "SELECT IdAgregado, Agregado, Tipo FROM Agregado"; 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("@IdAgregado", System.Data.SqlDbType.Int, 4, "IdAgregado"), new System.Data.SqlClient.SqlParameter("@Agregado", System.Data.SqlDbType.NVarChar, 15, "Agregado"), new System.Data.SqlClient.SqlParameter("@Tipo", System.Data.SqlDbType.NVarChar, 11, "Tipo"), new System.Data.SqlClient.SqlParameter("@Original_IdAgregado", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "IdAgregado", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_Agregado", System.Data.SqlDbType.NVarChar, 15, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Agregado", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_Tipo", System.Data.SqlDbType.NVarChar, 11, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Tipo", System.Data.DataRowVersion.Original, null) }); // // dsAgregado1 // this.dsAgregado1.DataSetName = "dsAgregado"; this.dsAgregado1.Locale = new System.Globalization.CultureInfo("es-MX"); this.dsAgregado1.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema; // // txtIdAgregado // this.txtIdAgregado.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dsAgregado1, "Agregado.IdAgregado", true)); this.txtIdAgregado.Location = new System.Drawing.Point(160, 40); this.txtIdAgregado.Name = "txtIdAgregado"; this.txtIdAgregado.Size = new System.Drawing.Size(64, 20); this.txtIdAgregado.TabIndex = 3; // // txtAgregado // this.txtAgregado.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dsAgregado1, "Agregado.Agregado", true)); this.txtAgregado.Location = new System.Drawing.Point(160, 72); this.txtAgregado.Name = "txtAgregado"; this.txtAgregado.Size = new System.Drawing.Size(160, 20); this.txtAgregado.TabIndex = 4; // // txtTipo // this.txtTipo.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dsAgregado1, "Agregado.Tipo", true)); this.txtTipo.Location = new System.Drawing.Point(160, 104); this.txtTipo.Name = "txtTipo"; this.txtTipo.Size = new System.Drawing.Size(160, 20); this.txtTipo.TabIndex = 5; // // lblIdAgregado // this.lblIdAgregado.Location = new System.Drawing.Point(48, 40); this.lblIdAgregado.Name = "lblIdAgregado"; this.lblIdAgregado.Size = new System.Drawing.Size(100, 23); this.lblIdAgregado.TabIndex = 6; this.lblIdAgregado.Text = "IdAgregado:"; this.lblIdAgregado.TextAlign = System.Drawing.ContentAlignment.MiddleRight; // // lblAgregado // this.lblAgregado.Location = new System.Drawing.Point(48, 72); this.lblAgregado.Name = "lblAgregado"; this.lblAgregado.Size = new System.Drawing.Size(100, 23); this.lblAgregado.TabIndex = 6; this.lblAgregado.Text = "Agregado:"; this.lblAgregado.TextAlign = System.Drawing.ContentAlignment.MiddleRight; // // lblTipo // this.lblTipo.Location = new System.Drawing.Point(48, 104); this.lblTipo.Name = "lblTipo"; this.lblTipo.Size = new System.Drawing.Size(100, 23); this.lblTipo.TabIndex = 6; this.lblTipo.Text = "Tipo:"; this.lblTipo.TextAlign = System.Drawing.ContentAlignment.MiddleRight; // // panel1 // this.panel1.BorderStyle = System.Windows.Forms.BorderStyle.FixedSingle; this.panel1.Controls.Add(this.buscaBtn1); this.panel1.Controls.Add(this.lblTipo); this.panel1.Controls.Add(this.txtAgregado); this.panel1.Controls.Add(this.txtTipo); this.panel1.Controls.Add(this.lblAgregado); this.panel1.Controls.Add(this.txtIdAgregado); this.panel1.Controls.Add(this.lblIdAgregado); this.panel1.ForeColor = System.Drawing.Color.White; this.panel1.Location = new System.Drawing.Point(80, 128); this.panel1.Name = "panel1"; this.panel1.Size = new System.Drawing.Size(384, 176); this.panel1.TabIndex = 7; // // buscaBtn1 // this.buscaBtn1.AnchoDlgBusq = 0; this.buscaBtn1.BackColor = System.Drawing.Color.Transparent; this.buscaBtn1.Datos = this.dsAgregado1.Agregado; this.buscaBtn1.Icon = ((System.Drawing.Icon)(resources.GetObject("buscaBtn1.Icon"))); this.buscaBtn1.Location = new System.Drawing.Point(232, 0); this.buscaBtn1.Name = "buscaBtn1"; this.buscaBtn1.Size = new System.Drawing.Size(64, 64); this.buscaBtn1.TabIndex = 7; this.toolTip1.SetToolTip(this.buscaBtn1, "Buscar"); this.buscaBtn1.Load += new System.EventHandler(this.buscaBtn1_Load); // // Agregado // this.AutoScaleBaseSize = new System.Drawing.Size(5, 13); this.ClientSize = new System.Drawing.Size(576, 423); this.Controls.Add(this.panel1); this.DAGeneral = this.sqlDAAgregado; this.dsGeneral = this.dsAgregado1; this.Name = "Agregado"; this.NombreTabla = "agregado"; this.Text = "Catálogo de Agregados"; this.Load += new System.EventHandler(this.Agregado_Load); this.Controls.SetChildIndex(this.panel1, 0); this.Controls.SetChildIndex(this.statusBar1, 0); this.Controls.SetChildIndex(this.panelToolBar, 0); this.panelToolBar.ResumeLayout(false); ((System.ComponentModel.ISupportInitialize)(this.dsAgregado1)).EndInit(); this.panel1.ResumeLayout(false); this.panel1.PerformLayout(); 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(Norma)); System.Configuration.AppSettingsReader configurationAppSettings = new System.Configuration.AppSettingsReader(); this.sqlDANormas = 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.dsNormas1 = new LancNeo.dsNormas(); this.panel2 = new System.Windows.Forms.Panel(); this.buscaBtn1 = new Soluciones2000.Tools.WinLib.BuscaBtn(); this.textBox7 = new System.Windows.Forms.TextBox(); this.label10 = new System.Windows.Forms.Label(); this.textBox5 = new System.Windows.Forms.TextBox(); this.textBox6 = new System.Windows.Forms.TextBox(); this.label8 = new System.Windows.Forms.Label(); this.label9 = new System.Windows.Forms.Label(); this.textBox3 = new System.Windows.Forms.TextBox(); this.textBox4 = new System.Windows.Forms.TextBox(); this.label6 = new System.Windows.Forms.Label(); this.label7 = new System.Windows.Forms.Label(); this.textBox1 = new System.Windows.Forms.TextBox(); this.textBox2 = new System.Windows.Forms.TextBox(); this.label4 = new System.Windows.Forms.Label(); this.label5 = new System.Windows.Forms.Label(); this.txtNormas = new System.Windows.Forms.TextBox(); this.txtInforme = new System.Windows.Forms.TextBox(); this.txtIdNorma = new System.Windows.Forms.TextBox(); this.label3 = new System.Windows.Forms.Label(); this.label2 = new System.Windows.Forms.Label(); this.label1 = new System.Windows.Forms.Label(); this.panelToolBar.SuspendLayout(); ((System.ComponentModel.ISupportInitialize)(this.dsNormas1)).BeginInit(); this.panel2.SuspendLayout(); this.SuspendLayout(); // // statusBar1 // this.statusBar1.Location = new System.Drawing.Point(0, 501); this.statusBar1.ShowPanels = true; this.statusBar1.Size = new System.Drawing.Size(592, 22); // // panelToolBar // this.panelToolBar.Size = new System.Drawing.Size(592, 64); // // sqlDANormas // this.sqlDANormas.DeleteCommand = this.sqlDeleteCommand1; this.sqlDANormas.InsertCommand = this.sqlInsertCommand1; this.sqlDANormas.SelectCommand = this.sqlSelectCommand1; this.sqlDANormas.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") }) }); this.sqlDANormas.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_IdNorma", System.Data.SqlDbType.SmallInt, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "IdNorma", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@IsNull_Informe", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "Informe", System.Data.DataRowVersion.Original, true, null, "", "", ""), new System.Data.SqlClient.SqlParameter("@Original_Informe", System.Data.SqlDbType.VarChar, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Informe", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@IsNull_Normas", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "Normas", System.Data.DataRowVersion.Original, true, null, "", "", ""), new System.Data.SqlClient.SqlParameter("@Original_Normas", System.Data.SqlDbType.VarChar, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Normas", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@IsNull_Titulo", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "Titulo", System.Data.DataRowVersion.Original, true, null, "", "", ""), new System.Data.SqlClient.SqlParameter("@Original_Titulo", System.Data.SqlDbType.VarChar, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Titulo", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@IsNull_IdInforme", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "IdInforme", System.Data.DataRowVersion.Original, true, null, "", "", ""), new System.Data.SqlClient.SqlParameter("@Original_IdInforme", System.Data.SqlDbType.VarChar, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "IdInforme", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@IsNull_Norma1", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "Norma1", System.Data.DataRowVersion.Original, true, null, "", "", ""), new System.Data.SqlClient.SqlParameter("@Original_Norma1", System.Data.SqlDbType.VarChar, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Norma1", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@IsNull_Norma2", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "Norma2", System.Data.DataRowVersion.Original, true, null, "", "", ""), new System.Data.SqlClient.SqlParameter("@Original_Norma2", System.Data.SqlDbType.VarChar, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Norma2", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@IsNull_Norma3", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "Norma3", System.Data.DataRowVersion.Original, true, null, "", "", ""), new System.Data.SqlClient.SqlParameter("@Original_Norma3", System.Data.SqlDbType.VarChar, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Norma3", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@IsNull_Norma4", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "Norma4", System.Data.DataRowVersion.Original, true, null, "", "", ""), new System.Data.SqlClient.SqlParameter("@Original_Norma4", System.Data.SqlDbType.VarChar, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Norma4", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@IsNull_Norma5", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "Norma5", System.Data.DataRowVersion.Original, true, null, "", "", ""), new System.Data.SqlClient.SqlParameter("@Original_Norma5", System.Data.SqlDbType.VarChar, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Norma5", 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("@IdNorma", System.Data.SqlDbType.SmallInt, 0, "IdNorma"), new System.Data.SqlClient.SqlParameter("@Informe", System.Data.SqlDbType.VarChar, 0, "Informe"), new System.Data.SqlClient.SqlParameter("@Normas", System.Data.SqlDbType.VarChar, 0, "Normas"), new System.Data.SqlClient.SqlParameter("@Titulo", System.Data.SqlDbType.VarChar, 0, "Titulo"), new System.Data.SqlClient.SqlParameter("@IdInforme", System.Data.SqlDbType.VarChar, 0, "IdInforme"), new System.Data.SqlClient.SqlParameter("@Norma1", System.Data.SqlDbType.VarChar, 0, "Norma1"), new System.Data.SqlClient.SqlParameter("@Norma2", System.Data.SqlDbType.VarChar, 0, "Norma2"), new System.Data.SqlClient.SqlParameter("@Norma3", System.Data.SqlDbType.VarChar, 0, "Norma3"), new System.Data.SqlClient.SqlParameter("@Norma4", System.Data.SqlDbType.VarChar, 0, "Norma4"), new System.Data.SqlClient.SqlParameter("@Norma5", System.Data.SqlDbType.VarChar, 0, "Norma5") }); // // sqlSelectCommand1 // this.sqlSelectCommand1.CommandText = "SELECT IdNorma, Informe, Normas, Titulo, IdInforme, Norma1, Norma2, Norma3, N" + "orma4, Norma5\r\nFROM Normas\r\nORDER BY IdNorma"; 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("@IdNorma", System.Data.SqlDbType.SmallInt, 0, "IdNorma"), new System.Data.SqlClient.SqlParameter("@Informe", System.Data.SqlDbType.VarChar, 0, "Informe"), new System.Data.SqlClient.SqlParameter("@Normas", System.Data.SqlDbType.VarChar, 0, "Normas"), new System.Data.SqlClient.SqlParameter("@Titulo", System.Data.SqlDbType.VarChar, 0, "Titulo"), new System.Data.SqlClient.SqlParameter("@IdInforme", System.Data.SqlDbType.VarChar, 0, "IdInforme"), new System.Data.SqlClient.SqlParameter("@Norma1", System.Data.SqlDbType.VarChar, 0, "Norma1"), new System.Data.SqlClient.SqlParameter("@Norma2", System.Data.SqlDbType.VarChar, 0, "Norma2"), new System.Data.SqlClient.SqlParameter("@Norma3", System.Data.SqlDbType.VarChar, 0, "Norma3"), new System.Data.SqlClient.SqlParameter("@Norma4", System.Data.SqlDbType.VarChar, 0, "Norma4"), new System.Data.SqlClient.SqlParameter("@Norma5", System.Data.SqlDbType.VarChar, 0, "Norma5"), new System.Data.SqlClient.SqlParameter("@Original_IdNorma", System.Data.SqlDbType.SmallInt, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "IdNorma", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@IsNull_Informe", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "Informe", System.Data.DataRowVersion.Original, true, null, "", "", ""), new System.Data.SqlClient.SqlParameter("@Original_Informe", System.Data.SqlDbType.VarChar, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Informe", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@IsNull_Normas", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "Normas", System.Data.DataRowVersion.Original, true, null, "", "", ""), new System.Data.SqlClient.SqlParameter("@Original_Normas", System.Data.SqlDbType.VarChar, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Normas", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@IsNull_Titulo", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "Titulo", System.Data.DataRowVersion.Original, true, null, "", "", ""), new System.Data.SqlClient.SqlParameter("@Original_Titulo", System.Data.SqlDbType.VarChar, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Titulo", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@IsNull_IdInforme", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "IdInforme", System.Data.DataRowVersion.Original, true, null, "", "", ""), new System.Data.SqlClient.SqlParameter("@Original_IdInforme", System.Data.SqlDbType.VarChar, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "IdInforme", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@IsNull_Norma1", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "Norma1", System.Data.DataRowVersion.Original, true, null, "", "", ""), new System.Data.SqlClient.SqlParameter("@Original_Norma1", System.Data.SqlDbType.VarChar, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Norma1", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@IsNull_Norma2", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "Norma2", System.Data.DataRowVersion.Original, true, null, "", "", ""), new System.Data.SqlClient.SqlParameter("@Original_Norma2", System.Data.SqlDbType.VarChar, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Norma2", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@IsNull_Norma3", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "Norma3", System.Data.DataRowVersion.Original, true, null, "", "", ""), new System.Data.SqlClient.SqlParameter("@Original_Norma3", System.Data.SqlDbType.VarChar, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Norma3", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@IsNull_Norma4", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "Norma4", System.Data.DataRowVersion.Original, true, null, "", "", ""), new System.Data.SqlClient.SqlParameter("@Original_Norma4", System.Data.SqlDbType.VarChar, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Norma4", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@IsNull_Norma5", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "Norma5", System.Data.DataRowVersion.Original, true, null, "", "", ""), new System.Data.SqlClient.SqlParameter("@Original_Norma5", System.Data.SqlDbType.VarChar, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Norma5", System.Data.DataRowVersion.Original, null) }); // // dsNormas1 // this.dsNormas1.DataSetName = "dsNormas"; this.dsNormas1.Locale = new System.Globalization.CultureInfo("es-MX"); this.dsNormas1.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema; // // panel2 // this.panel2.BorderStyle = System.Windows.Forms.BorderStyle.Fixed3D; this.panel2.Controls.Add(this.buscaBtn1); this.panel2.Controls.Add(this.textBox7); this.panel2.Controls.Add(this.label10); this.panel2.Controls.Add(this.textBox5); this.panel2.Controls.Add(this.textBox6); this.panel2.Controls.Add(this.label8); this.panel2.Controls.Add(this.label9); this.panel2.Controls.Add(this.textBox3); this.panel2.Controls.Add(this.textBox4); this.panel2.Controls.Add(this.label6); this.panel2.Controls.Add(this.label7); this.panel2.Controls.Add(this.textBox1); this.panel2.Controls.Add(this.textBox2); this.panel2.Controls.Add(this.label4); this.panel2.Controls.Add(this.label5); this.panel2.Controls.Add(this.txtNormas); this.panel2.Controls.Add(this.txtInforme); this.panel2.Controls.Add(this.txtIdNorma); 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(22, 80); this.panel2.Name = "panel2"; this.panel2.Size = new System.Drawing.Size(568, 418); this.panel2.TabIndex = 5; this.panel2.Paint += new System.Windows.Forms.PaintEventHandler(this.panel2_Paint); // // buscaBtn1 // this.buscaBtn1.AnchoDlgBusq = 0; this.buscaBtn1.BackColor = System.Drawing.Color.Transparent; this.buscaBtn1.Datos = this.dsNormas1.Normas; this.buscaBtn1.Icon = ((System.Drawing.Icon)(resources.GetObject("buscaBtn1.Icon"))); this.buscaBtn1.Location = new System.Drawing.Point(156, 4); this.buscaBtn1.Name = "buscaBtn1"; this.buscaBtn1.Size = new System.Drawing.Size(64, 64); this.buscaBtn1.TabIndex = 8; this.toolTip1.SetToolTip(this.buscaBtn1, "Buscar"); // // textBox7 // this.textBox7.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dsNormas1, "Normas.Norma5", true)); this.textBox7.Location = new System.Drawing.Point(68, 394); this.textBox7.MaxLength = 25; this.textBox7.Name = "textBox7"; this.textBox7.Size = new System.Drawing.Size(190, 20); this.textBox7.TabIndex = 22; this.textBox7.Text = "textBox1"; this.textBox7.TextChanged += new System.EventHandler(this.textBox7_TextChanged); // // label10 // this.label10.AutoSize = true; this.label10.Location = new System.Drawing.Point(12, 394); this.label10.Name = "label10"; this.label10.Size = new System.Drawing.Size(50, 13); this.label10.TabIndex = 21; this.label10.Text = "Norma 5:"; // // textBox5 // this.textBox5.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dsNormas1, "Normas.Norma4", true)); this.textBox5.Location = new System.Drawing.Point(68, 370); this.textBox5.MaxLength = 25; this.textBox5.Name = "textBox5"; this.textBox5.Size = new System.Drawing.Size(190, 20); this.textBox5.TabIndex = 20; this.textBox5.Text = "textBox1"; this.textBox5.TextChanged += new System.EventHandler(this.textBox5_TextChanged); // // textBox6 // this.textBox6.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dsNormas1, "Normas.Norma3", true)); this.textBox6.Location = new System.Drawing.Point(68, 346); this.textBox6.MaxLength = 25; this.textBox6.Name = "textBox6"; this.textBox6.Size = new System.Drawing.Size(190, 20); this.textBox6.TabIndex = 19; this.textBox6.Text = "textBox1"; // // label8 // this.label8.AutoSize = true; this.label8.Location = new System.Drawing.Point(12, 370); this.label8.Name = "label8"; this.label8.Size = new System.Drawing.Size(50, 13); this.label8.TabIndex = 18; this.label8.Text = "Norma 4:"; // // label9 // this.label9.AutoSize = true; this.label9.Location = new System.Drawing.Point(12, 346); this.label9.Name = "label9"; this.label9.Size = new System.Drawing.Size(50, 13); this.label9.TabIndex = 17; this.label9.Text = "Norma 3:"; // // textBox3 // this.textBox3.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dsNormas1, "Normas.Norma2", true)); this.textBox3.Location = new System.Drawing.Point(68, 322); this.textBox3.MaxLength = 25; this.textBox3.Name = "textBox3"; this.textBox3.Size = new System.Drawing.Size(190, 20); this.textBox3.TabIndex = 16; this.textBox3.Text = "textBox1"; // // textBox4 // this.textBox4.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dsNormas1, "Normas.Norma1", true)); this.textBox4.Location = new System.Drawing.Point(68, 298); this.textBox4.MaxLength = 25; this.textBox4.Name = "textBox4"; this.textBox4.Size = new System.Drawing.Size(190, 20); this.textBox4.TabIndex = 15; this.textBox4.Text = "textBox1"; // // label6 // this.label6.AutoSize = true; this.label6.Location = new System.Drawing.Point(12, 322); this.label6.Name = "label6"; this.label6.Size = new System.Drawing.Size(50, 13); this.label6.TabIndex = 14; this.label6.Text = "Norma 2:"; // // label7 // this.label7.AutoSize = true; this.label7.Location = new System.Drawing.Point(12, 300); this.label7.Name = "label7"; this.label7.Size = new System.Drawing.Size(50, 13); this.label7.TabIndex = 13; this.label7.Text = "Norma 1:"; // // textBox1 // this.textBox1.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dsNormas1, "Normas.IdInforme", true)); this.textBox1.Location = new System.Drawing.Point(68, 274); this.textBox1.MaxLength = 20; this.textBox1.Name = "textBox1"; this.textBox1.Size = new System.Drawing.Size(190, 20); this.textBox1.TabIndex = 12; this.textBox1.Text = "textBox1"; // // textBox2 // this.textBox2.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dsNormas1, "Normas.Titulo", true)); this.textBox2.Location = new System.Drawing.Point(68, 230); this.textBox2.MaxLength = 200; this.textBox2.Multiline = true; this.textBox2.Name = "textBox2"; this.textBox2.Size = new System.Drawing.Size(454, 40); this.textBox2.TabIndex = 11; this.textBox2.Text = "textBox1"; // // label4 // this.label4.AutoSize = true; this.label4.Location = new System.Drawing.Point(12, 276); this.label4.Name = "label4"; this.label4.Size = new System.Drawing.Size(57, 13); this.label4.TabIndex = 10; this.label4.Text = "Id Informe:"; // // label5 // this.label5.AutoSize = true; this.label5.Location = new System.Drawing.Point(12, 230); this.label5.Name = "label5"; this.label5.Size = new System.Drawing.Size(36, 13); this.label5.TabIndex = 9; this.label5.Text = "Titulo:"; // // txtNormas // this.txtNormas.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dsNormas1, "Normas.Normas", true)); this.txtNormas.Location = new System.Drawing.Point(68, 70); this.txtNormas.MaxLength = 2500; this.txtNormas.Multiline = true; this.txtNormas.Name = "txtNormas"; this.txtNormas.Size = new System.Drawing.Size(454, 156); this.txtNormas.TabIndex = 5; this.txtNormas.Text = "textBox2"; // // txtInforme // this.txtInforme.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dsNormas1, "Normas.Informe", true)); this.txtInforme.Location = new System.Drawing.Point(68, 46); this.txtInforme.MaxLength = 20; this.txtInforme.Name = "txtInforme"; this.txtInforme.Size = new System.Drawing.Size(80, 20); this.txtInforme.TabIndex = 4; this.txtInforme.Text = "textBox1"; // // txtIdNorma // this.txtIdNorma.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dsNormas1, "Normas.IdNorma", true)); this.txtIdNorma.Location = new System.Drawing.Point(68, 22); this.txtIdNorma.MaxLength = 4; this.txtIdNorma.Name = "txtIdNorma"; this.txtIdNorma.Size = new System.Drawing.Size(80, 20); this.txtIdNorma.TabIndex = 3; this.txtIdNorma.Text = "textBox1"; // // label3 // this.label3.AutoSize = true; this.label3.Location = new System.Drawing.Point(12, 70); this.label3.Name = "label3"; this.label3.Size = new System.Drawing.Size(46, 13); this.label3.TabIndex = 2; this.label3.Text = "Normas:"; // // label2 // this.label2.AutoSize = true; this.label2.Location = new System.Drawing.Point(12, 46); this.label2.Name = "label2"; this.label2.Size = new System.Drawing.Size(45, 13); this.label2.TabIndex = 1; this.label2.Text = "Informe:"; // // label1 // this.label1.AutoSize = true; this.label1.Location = new System.Drawing.Point(12, 22); this.label1.Name = "label1"; this.label1.Size = new System.Drawing.Size(53, 13); this.label1.TabIndex = 0; this.label1.Text = "Id Norma:"; // // Norma // this.AutoScaleBaseSize = new System.Drawing.Size(5, 13); this.ClientSize = new System.Drawing.Size(592, 523); this.Controls.Add(this.panel2); this.DAGeneral = this.sqlDANormas; this.dsGeneral = this.dsNormas1; this.Name = "Norma"; this.NombreTabla = "Normas"; this.Text = "Norma"; this.Load += new System.EventHandler(this.Norma_Load); this.Controls.SetChildIndex(this.statusBar1, 0); this.Controls.SetChildIndex(this.panelToolBar, 0); this.Controls.SetChildIndex(this.panel2, 0); this.panelToolBar.ResumeLayout(false); ((System.ComponentModel.ISupportInitialize)(this.dsNormas1)).EndInit(); this.panel2.ResumeLayout(false); this.panel2.PerformLayout(); 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(Zona)); System.Configuration.AppSettingsReader configurationAppSettings = new System.Configuration.AppSettingsReader(); this.sqlDAZona = 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.dsZona1 = new LancNeo.dsZona(); this.panel1 = new System.Windows.Forms.Panel(); this.buscaBtn1 = new Soluciones2000.Tools.WinLib.BuscaBtn(); this.txtUbicacion = new System.Windows.Forms.TextBox(); this.groupBox1 = new System.Windows.Forms.GroupBox(); this.rdLocal = new System.Windows.Forms.RadioButton(); this.rdForanea = new System.Windows.Forms.RadioButton(); this.txtIdZona = new System.Windows.Forms.TextBox(); this.lblIdZona = new System.Windows.Forms.Label(); this.lblZona = new System.Windows.Forms.Label(); this.txtZona = new System.Windows.Forms.TextBox(); this.panelToolBar.SuspendLayout(); ((System.ComponentModel.ISupportInitialize)(this.dsZona1)).BeginInit(); this.panel1.SuspendLayout(); this.groupBox1.SuspendLayout(); this.SuspendLayout(); // // statusBar1 // this.statusBar1.ShowPanels = true; this.statusBar1.Size = new System.Drawing.Size(576, 22); // // panelToolBar // this.panelToolBar.Size = new System.Drawing.Size(576, 64); // // sqlDAZona // this.sqlDAZona.DeleteCommand = this.sqlDeleteCommand1; this.sqlDAZona.InsertCommand = this.sqlInsertCommand1; this.sqlDAZona.SelectCommand = this.sqlSelectCommand1; this.sqlDAZona.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping("Table", "Zona", new System.Data.Common.DataColumnMapping[] { new System.Data.Common.DataColumnMapping("IdZona", "IdZona"), new System.Data.Common.DataColumnMapping("Zona", "Zona"), new System.Data.Common.DataColumnMapping("Ubicación", "Ubicación") }) }); this.sqlDAZona.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_IdZona", System.Data.SqlDbType.NVarChar, 1, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "IdZona", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_Ubicación", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Ubicación", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_Zona", System.Data.SqlDbType.NVarChar, 50, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Zona", System.Data.DataRowVersion.Original, null) }); // // sqlConn // this.sqlConn.ConnectionString = ((string)(configurationAppSettings.GetValue("sqlConn.ConnectionString", typeof(string)))); this.sqlConn.FireInfoMessageEventOnUserErrors = false; // // sqlInsertCommand1 // this.sqlInsertCommand1.CommandText = "INSERT INTO Zona(IdZona, Zona, Ubicación) VALUES (@IdZona, @Zona, @Ubicación); SE" + "LECT IdZona, Zona, Ubicación FROM Zona WHERE (IdZona = @IdZona)"; this.sqlInsertCommand1.Connection = this.sqlConn; this.sqlInsertCommand1.Parameters.AddRange(new System.Data.SqlClient.SqlParameter[] { new System.Data.SqlClient.SqlParameter("@IdZona", System.Data.SqlDbType.NVarChar, 1, "IdZona"), new System.Data.SqlClient.SqlParameter("@Zona", System.Data.SqlDbType.NVarChar, 50, "Zona"), new System.Data.SqlClient.SqlParameter("@Ubicación", System.Data.SqlDbType.Int, 4, "Ubicación") }); // // sqlSelectCommand1 // this.sqlSelectCommand1.CommandText = "SELECT IdZona, Zona, Ubicación FROM Zona"; 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("@IdZona", System.Data.SqlDbType.NVarChar, 1, "IdZona"), new System.Data.SqlClient.SqlParameter("@Zona", System.Data.SqlDbType.NVarChar, 50, "Zona"), new System.Data.SqlClient.SqlParameter("@Ubicación", System.Data.SqlDbType.Int, 4, "Ubicación"), new System.Data.SqlClient.SqlParameter("@Original_IdZona", System.Data.SqlDbType.NVarChar, 1, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "IdZona", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_Ubicación", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Ubicación", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_Zona", System.Data.SqlDbType.NVarChar, 50, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Zona", System.Data.DataRowVersion.Original, null) }); // // dsZona1 // this.dsZona1.DataSetName = "dsZona"; this.dsZona1.Locale = new System.Globalization.CultureInfo("en-US"); this.dsZona1.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema; // // panel1 // this.panel1.BorderStyle = System.Windows.Forms.BorderStyle.Fixed3D; this.panel1.Controls.Add(this.buscaBtn1); this.panel1.Controls.Add(this.txtUbicacion); this.panel1.Controls.Add(this.groupBox1); this.panel1.Controls.Add(this.txtIdZona); this.panel1.Controls.Add(this.lblIdZona); this.panel1.Controls.Add(this.lblZona); this.panel1.Controls.Add(this.txtZona); this.panel1.Location = new System.Drawing.Point(68, 104); this.panel1.Name = "panel1"; this.panel1.Size = new System.Drawing.Size(440, 248); this.panel1.TabIndex = 0; // // buscaBtn1 // this.buscaBtn1.AnchoDlgBusq = 0; this.buscaBtn1.BackColor = System.Drawing.Color.Transparent; this.buscaBtn1.Datos = null; this.buscaBtn1.Icon = ((System.Drawing.Icon)(resources.GetObject("buscaBtn1.Icon"))); this.buscaBtn1.Location = new System.Drawing.Point(240, 16); this.buscaBtn1.Name = "buscaBtn1"; this.buscaBtn1.Size = new System.Drawing.Size(64, 64); this.buscaBtn1.TabIndex = 5; this.toolTip1.SetToolTip(this.buscaBtn1, "Buscar"); // // txtUbicacion // this.txtUbicacion.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dsZona1, "Zona.Ubicación", true)); this.txtUbicacion.Location = new System.Drawing.Point(168, 216); this.txtUbicacion.Name = "txtUbicacion"; this.txtUbicacion.Size = new System.Drawing.Size(0, 20); this.txtUbicacion.TabIndex = 4; this.txtUbicacion.TextChanged += new System.EventHandler(this.txtUbicacion_TextChanged); // // groupBox1 // this.groupBox1.Controls.Add(this.rdLocal); this.groupBox1.Controls.Add(this.rdForanea); this.groupBox1.Location = new System.Drawing.Point(104, 136); this.groupBox1.Name = "groupBox1"; this.groupBox1.Size = new System.Drawing.Size(256, 64); this.groupBox1.TabIndex = 3; this.groupBox1.TabStop = false; this.groupBox1.Text = "Ubicación"; // // rdLocal // this.rdLocal.Checked = true; this.rdLocal.Location = new System.Drawing.Point(58, 24); this.rdLocal.Name = "rdLocal"; this.rdLocal.Size = new System.Drawing.Size(56, 24); this.rdLocal.TabIndex = 2; this.rdLocal.TabStop = true; this.rdLocal.Text = "Local"; this.rdLocal.CheckedChanged += new System.EventHandler(this.rdLocal_CheckedChanged); // // rdForanea // this.rdForanea.Location = new System.Drawing.Point(134, 24); this.rdForanea.Name = "rdForanea"; this.rdForanea.Size = new System.Drawing.Size(64, 24); this.rdForanea.TabIndex = 2; this.rdForanea.Text = "Foránea"; this.rdForanea.CheckedChanged += new System.EventHandler(this.rdForanea_CheckedChanged); // // txtIdZona // this.txtIdZona.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dsZona1, "Zona.IdZona", true)); this.txtIdZona.Location = new System.Drawing.Point(168, 48); this.txtIdZona.MaxLength = 1; this.txtIdZona.Name = "txtIdZona"; this.txtIdZona.Size = new System.Drawing.Size(64, 20); this.txtIdZona.TabIndex = 1; // // lblIdZona // this.lblIdZona.Location = new System.Drawing.Point(56, 48); this.lblIdZona.Name = "lblIdZona"; this.lblIdZona.Size = new System.Drawing.Size(100, 23); this.lblIdZona.TabIndex = 0; this.lblIdZona.Text = "Id Zona:"; this.lblIdZona.TextAlign = System.Drawing.ContentAlignment.MiddleRight; // // lblZona // this.lblZona.Location = new System.Drawing.Point(56, 88); this.lblZona.Name = "lblZona"; this.lblZona.Size = new System.Drawing.Size(100, 23); this.lblZona.TabIndex = 0; this.lblZona.Text = "Zona:"; this.lblZona.TextAlign = System.Drawing.ContentAlignment.MiddleRight; // // txtZona // this.txtZona.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dsZona1, "Zona.Zona", true)); this.txtZona.Location = new System.Drawing.Point(168, 96); this.txtZona.MaxLength = 50; this.txtZona.Name = "txtZona"; this.txtZona.Size = new System.Drawing.Size(192, 20); this.txtZona.TabIndex = 1; // // Zona // this.AutoScaleBaseSize = new System.Drawing.Size(5, 13); this.ClientSize = new System.Drawing.Size(576, 423); this.Controls.Add(this.panel1); this.DAGeneral = this.sqlDAZona; this.dsGeneral = this.dsZona1; this.Name = "Zona"; this.NombreTabla = "Zona"; this.Text = "Zona"; this.Load += new System.EventHandler(this.Zona_Load); this.Controls.SetChildIndex(this.panel1, 0); this.Controls.SetChildIndex(this.statusBar1, 0); this.Controls.SetChildIndex(this.panelToolBar, 0); this.panelToolBar.ResumeLayout(false); ((System.ComponentModel.ISupportInitialize)(this.dsZona1)).EndInit(); this.panel1.ResumeLayout(false); this.panel1.PerformLayout(); this.groupBox1.ResumeLayout(false); 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(Concepto)); System.Configuration.AppSettingsReader configurationAppSettings = new System.Configuration.AppSettingsReader(); this.panel2 = new System.Windows.Forms.Panel(); this.buscaBtn1 = new Soluciones2000.Tools.WinLib.BuscaBtn(); this.dsConcepto1 = new LancNeo.dsConcepto(); this.txtConcepto = new System.Windows.Forms.TextBox(); this.label2 = new System.Windows.Forms.Label(); this.txtIdConcepto = new System.Windows.Forms.TextBox(); this.label1 = new System.Windows.Forms.Label(); this.sqlDAConcepto = 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.panelToolBar.SuspendLayout(); this.panel2.SuspendLayout(); ((System.ComponentModel.ISupportInitialize)(this.dsConcepto1)).BeginInit(); this.SuspendLayout(); // // statusBar1 // this.statusBar1.Location = new System.Drawing.Point(0, 351); this.statusBar1.ShowPanels = true; this.statusBar1.Size = new System.Drawing.Size(600, 22); // // panelToolBar // this.panelToolBar.Size = new System.Drawing.Size(600, 64); // // panel2 // this.panel2.BorderStyle = System.Windows.Forms.BorderStyle.Fixed3D; this.panel2.Controls.Add(this.buscaBtn1); this.panel2.Controls.Add(this.txtConcepto); this.panel2.Controls.Add(this.label2); this.panel2.Controls.Add(this.txtIdConcepto); this.panel2.Controls.Add(this.label1); this.panel2.Location = new System.Drawing.Point(96, 128); this.panel2.Name = "panel2"; this.panel2.Size = new System.Drawing.Size(448, 144); this.panel2.TabIndex = 4; // // buscaBtn1 // this.buscaBtn1.AnchoDlgBusq = 0; this.buscaBtn1.BackColor = System.Drawing.Color.Transparent; this.buscaBtn1.Datos = this.dsConcepto1.Concepto; this.buscaBtn1.Icon = ((System.Drawing.Icon)(resources.GetObject("buscaBtn1.Icon"))); this.buscaBtn1.Location = new System.Drawing.Point(224, 0); this.buscaBtn1.Name = "buscaBtn1"; this.buscaBtn1.Size = new System.Drawing.Size(64, 64); this.buscaBtn1.TabIndex = 4; this.toolTip1.SetToolTip(this.buscaBtn1, "Buscar"); // // dsConcepto1 // this.dsConcepto1.DataSetName = "dsConcepto"; this.dsConcepto1.Locale = new System.Globalization.CultureInfo("es-MX"); this.dsConcepto1.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema; // // txtConcepto // this.txtConcepto.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dsConcepto1, "Concepto.Concepto", true)); this.txtConcepto.Location = new System.Drawing.Point(104, 88); this.txtConcepto.Name = "txtConcepto"; this.txtConcepto.Size = new System.Drawing.Size(312, 20); this.txtConcepto.TabIndex = 3; this.txtConcepto.Text = "textBox1"; // // label2 // this.label2.AutoSize = true; this.label2.Location = new System.Drawing.Point(33, 88); this.label2.Name = "label2"; this.label2.Size = new System.Drawing.Size(56, 13); this.label2.TabIndex = 2; this.label2.Text = "Concepto:"; // // txtIdConcepto // this.txtIdConcepto.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dsConcepto1, "Concepto.IdConcepto", true)); this.txtIdConcepto.Location = new System.Drawing.Point(104, 24); this.txtIdConcepto.Name = "txtIdConcepto"; this.txtIdConcepto.Size = new System.Drawing.Size(100, 20); this.txtIdConcepto.TabIndex = 1; this.txtIdConcepto.Text = "textBox1"; this.txtIdConcepto.TextChanged += new System.EventHandler(this.txtIdConcepto_TextChanged); // // label1 // this.label1.AutoSize = true; this.label1.Location = new System.Drawing.Point(24, 24); this.label1.Name = "label1"; this.label1.Size = new System.Drawing.Size(65, 13); this.label1.TabIndex = 0; this.label1.Text = "IdConcepto:"; this.label1.Click += new System.EventHandler(this.label1_Click); // // sqlDAConcepto // this.sqlDAConcepto.DeleteCommand = this.sqlDeleteCommand1; this.sqlDAConcepto.InsertCommand = this.sqlInsertCommand1; this.sqlDAConcepto.SelectCommand = this.sqlSelectCommand1; this.sqlDAConcepto.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping("Table", "Concepto", new System.Data.Common.DataColumnMapping[] { new System.Data.Common.DataColumnMapping("IdConcepto", "IdConcepto"), new System.Data.Common.DataColumnMapping("Concepto", "Concepto") }) }); this.sqlDAConcepto.UpdateCommand = this.sqlUpdateCommand1; // // sqlDeleteCommand1 // this.sqlDeleteCommand1.CommandText = "DELETE FROM Concepto WHERE (IdConcepto = @Original_IdConcepto) AND (Concepto = @O" + "riginal_Concepto OR @Original_Concepto IS NULL AND Concepto IS NULL)"; this.sqlDeleteCommand1.Connection = this.sqlConn; this.sqlDeleteCommand1.Parameters.AddRange(new System.Data.SqlClient.SqlParameter[] { new System.Data.SqlClient.SqlParameter("@Original_IdConcepto", System.Data.SqlDbType.SmallInt, 2, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "IdConcepto", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_Concepto", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Concepto", System.Data.DataRowVersion.Original, null) }); // // sqlConn // this.sqlConn.ConnectionString = ((string)(configurationAppSettings.GetValue("sqlConn.ConnectionString", typeof(string)))); this.sqlConn.FireInfoMessageEventOnUserErrors = false; // // sqlInsertCommand1 // this.sqlInsertCommand1.CommandText = "INSERT INTO Concepto(IdConcepto, Concepto) VALUES (@IdConcepto, @Concepto); SELEC" + "T IdConcepto, Concepto FROM Concepto WHERE (IdConcepto = @IdConcepto)"; this.sqlInsertCommand1.Connection = this.sqlConn; this.sqlInsertCommand1.Parameters.AddRange(new System.Data.SqlClient.SqlParameter[] { new System.Data.SqlClient.SqlParameter("@IdConcepto", System.Data.SqlDbType.SmallInt, 2, "IdConcepto"), new System.Data.SqlClient.SqlParameter("@Concepto", System.Data.SqlDbType.VarChar, 50, "Concepto") }); // // sqlSelectCommand1 // this.sqlSelectCommand1.CommandText = "SELECT IdConcepto, Concepto FROM Concepto"; 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("@IdConcepto", System.Data.SqlDbType.SmallInt, 2, "IdConcepto"), new System.Data.SqlClient.SqlParameter("@Concepto", System.Data.SqlDbType.VarChar, 50, "Concepto"), new System.Data.SqlClient.SqlParameter("@Original_IdConcepto", System.Data.SqlDbType.SmallInt, 2, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "IdConcepto", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_Concepto", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Concepto", System.Data.DataRowVersion.Original, null) }); // // Concepto // this.AutoScaleBaseSize = new System.Drawing.Size(5, 13); this.ClientSize = new System.Drawing.Size(600, 373); this.Controls.Add(this.panel2); this.DAGeneral = this.sqlDAConcepto; this.dsGeneral = this.dsConcepto1; this.Name = "Concepto"; this.NombreTabla = "Concepto"; this.Text = "Concepto"; this.Load += new System.EventHandler(this.Concepto_Load); this.Controls.SetChildIndex(this.panel2, 0); this.Controls.SetChildIndex(this.statusBar1, 0); this.Controls.SetChildIndex(this.panelToolBar, 0); this.panelToolBar.ResumeLayout(false); this.panel2.ResumeLayout(false); this.panel2.PerformLayout(); ((System.ComponentModel.ISupportInitialize)(this.dsConcepto1)).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(Resistencia)); System.Configuration.AppSettingsReader configurationAppSettings = new System.Configuration.AppSettingsReader(); this.panel1 = new System.Windows.Forms.Panel(); this.buscaBtn1 = new Soluciones2000.Tools.WinLib.BuscaBtn(); this.dsResistencia1 = new LancNeo.dsResistencia(); this.cmbMezcla = new System.Windows.Forms.ComboBox(); this.txtResKg = new System.Windows.Forms.TextBox(); this.lblResistenciaKg = new System.Windows.Forms.Label(); this.lblResistenciaMPa = new System.Windows.Forms.Label(); this.sqlDAResistencia = 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.panelToolBar.SuspendLayout(); this.panel1.SuspendLayout(); ((System.ComponentModel.ISupportInitialize)(this.dsResistencia1)).BeginInit(); this.SuspendLayout(); // // statusBar1 // this.statusBar1.ShowPanels = true; this.statusBar1.Size = new System.Drawing.Size(576, 22); // // panelToolBar // this.panelToolBar.Size = new System.Drawing.Size(576, 64); // // panel1 // this.panel1.BorderStyle = System.Windows.Forms.BorderStyle.Fixed3D; this.panel1.Controls.Add(this.buscaBtn1); this.panel1.Controls.Add(this.cmbMezcla); this.panel1.Controls.Add(this.txtResKg); this.panel1.Controls.Add(this.lblResistenciaKg); this.panel1.Controls.Add(this.lblResistenciaMPa); this.panel1.Location = new System.Drawing.Point(110, 112); this.panel1.Name = "panel1"; this.panel1.Size = new System.Drawing.Size(356, 200); this.panel1.TabIndex = 0; // // buscaBtn1 // this.buscaBtn1.AnchoDlgBusq = 0; this.buscaBtn1.BackColor = System.Drawing.Color.Transparent; this.buscaBtn1.Datos = this.dsResistencia1.Resistencia; this.buscaBtn1.Icon = ((System.Drawing.Icon)(resources.GetObject("buscaBtn1.Icon"))); this.buscaBtn1.Location = new System.Drawing.Point(268, 32); this.buscaBtn1.Name = "buscaBtn1"; this.buscaBtn1.Size = new System.Drawing.Size(64, 64); this.buscaBtn1.TabIndex = 2; this.toolTip1.SetToolTip(this.buscaBtn1, "Buscar"); // // dsResistencia1 // this.dsResistencia1.DataSetName = "dsResistencia"; this.dsResistencia1.Locale = new System.Globalization.CultureInfo("es-MX"); this.dsResistencia1.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema; // // cmbMezcla // this.cmbMezcla.DataBindings.Add(new System.Windows.Forms.Binding("SelectedValue", this.dsResistencia1, "Resistencia.ResistenciaMPa", true)); this.cmbMezcla.Location = new System.Drawing.Point(168, 104); this.cmbMezcla.Name = "cmbMezcla"; this.cmbMezcla.Size = new System.Drawing.Size(96, 21); this.cmbMezcla.TabIndex = 3; this.cmbMezcla.Text = "cmbMezcla"; // // txtResKg // this.txtResKg.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dsResistencia1, "Resistencia.ResistenciaKG", true)); this.txtResKg.Location = new System.Drawing.Point(164, 64); this.txtResKg.Name = "txtResKg"; this.txtResKg.Size = new System.Drawing.Size(100, 20); this.txtResKg.TabIndex = 1; this.txtResKg.Text = "textBox1"; // // lblResistenciaKg // this.lblResistenciaKg.Location = new System.Drawing.Point(20, 64); this.lblResistenciaKg.Name = "lblResistenciaKg"; this.lblResistenciaKg.Size = new System.Drawing.Size(136, 23); this.lblResistenciaKg.TabIndex = 0; this.lblResistenciaKg.Text = "Resistencia en Kg/cm ²:"; this.lblResistenciaKg.TextAlign = System.Drawing.ContentAlignment.MiddleRight; // // lblResistenciaMPa // this.lblResistenciaMPa.Location = new System.Drawing.Point(20, 103); this.lblResistenciaMPa.Name = "lblResistenciaMPa"; this.lblResistenciaMPa.Size = new System.Drawing.Size(136, 23); this.lblResistenciaMPa.TabIndex = 0; this.lblResistenciaMPa.Text = "Mezcla:"; this.lblResistenciaMPa.TextAlign = System.Drawing.ContentAlignment.MiddleRight; // // sqlDAResistencia // this.sqlDAResistencia.DeleteCommand = this.sqlDeleteCommand1; this.sqlDAResistencia.InsertCommand = this.sqlInsertCommand1; this.sqlDAResistencia.SelectCommand = this.sqlSelectCommand1; this.sqlDAResistencia.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") }) }); this.sqlDAResistencia.UpdateCommand = this.sqlUpdateCommand1; // // sqlDeleteCommand1 // this.sqlDeleteCommand1.CommandText = "DELETE FROM Resistencia WHERE (ResistenciaKG = @Original_ResistenciaKG) AND (Resi" + "stenciaMPa = @Original_ResistenciaMPa OR @Original_ResistenciaMPa IS NULL AND Re" + "sistenciaMPa IS NULL)"; this.sqlDeleteCommand1.Connection = this.sqlConn; this.sqlDeleteCommand1.Parameters.AddRange(new System.Data.SqlClient.SqlParameter[] { new System.Data.SqlClient.SqlParameter("@Original_ResistenciaKG", System.Data.SqlDbType.Real, 4, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "ResistenciaKG", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_ResistenciaMPa", System.Data.SqlDbType.Real, 4, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "ResistenciaMPa", System.Data.DataRowVersion.Original, null) }); // // sqlConn // this.sqlConn.ConnectionString = ((string)(configurationAppSettings.GetValue("sqlConn.ConnectionString", typeof(string)))); this.sqlConn.FireInfoMessageEventOnUserErrors = false; // // sqlInsertCommand1 // this.sqlInsertCommand1.CommandText = "INSERT INTO Resistencia(ResistenciaKG, ResistenciaMPa) VALUES (@ResistenciaKG, @R" + "esistenciaMPa); SELECT ResistenciaKG, ResistenciaMPa FROM Resistencia WHERE (Res" + "istenciaKG = @ResistenciaKG)"; this.sqlInsertCommand1.Connection = this.sqlConn; this.sqlInsertCommand1.Parameters.AddRange(new System.Data.SqlClient.SqlParameter[] { new System.Data.SqlClient.SqlParameter("@ResistenciaKG", System.Data.SqlDbType.Real, 4, "ResistenciaKG"), new System.Data.SqlClient.SqlParameter("@ResistenciaMPa", System.Data.SqlDbType.Real, 4, "ResistenciaMPa") }); // // sqlSelectCommand1 // this.sqlSelectCommand1.CommandText = "SELECT ResistenciaKG, ResistenciaMPa FROM Resistencia"; 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("@ResistenciaKG", System.Data.SqlDbType.Real, 4, "ResistenciaKG"), new System.Data.SqlClient.SqlParameter("@ResistenciaMPa", System.Data.SqlDbType.Real, 4, "ResistenciaMPa"), new System.Data.SqlClient.SqlParameter("@Original_ResistenciaKG", System.Data.SqlDbType.Real, 4, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "ResistenciaKG", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_ResistenciaMPa", System.Data.SqlDbType.Real, 4, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "ResistenciaMPa", System.Data.DataRowVersion.Original, null) }); // // Resistencia // this.AutoScaleBaseSize = new System.Drawing.Size(5, 13); this.ClientSize = new System.Drawing.Size(576, 423); this.Controls.Add(this.panel1); this.DAGeneral = this.sqlDAResistencia; this.dsGeneral = this.dsResistencia1; this.Name = "Resistencia"; this.NombreTabla = "Resistencia"; this.Text = "Catálogo de Resistencias"; this.Load += new System.EventHandler(this.Resistencia_Load); this.Controls.SetChildIndex(this.panel1, 0); this.Controls.SetChildIndex(this.statusBar1, 0); this.Controls.SetChildIndex(this.panelToolBar, 0); this.panelToolBar.ResumeLayout(false); this.panel1.ResumeLayout(false); this.panel1.PerformLayout(); ((System.ComponentModel.ISupportInitialize)(this.dsResistencia1)).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(Manometro)); System.Configuration.AppSettingsReader configurationAppSettings = new System.Configuration.AppSettingsReader(); this.panel2 = new System.Windows.Forms.Panel(); this.buscaBtn1 = new Soluciones2000.Tools.WinLib.BuscaBtn(); this.dsManometro1 = new LancNeo.dsManometro(); this.txtIdManometro = new System.Windows.Forms.TextBox(); this.lblIdManometro = new System.Windows.Forms.Label(); this.lblManometro = new System.Windows.Forms.Label(); this.txtManometro = new System.Windows.Forms.TextBox(); this.sqlDAManometro = 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.panelToolBar.SuspendLayout(); this.panel2.SuspendLayout(); ((System.ComponentModel.ISupportInitialize)(this.dsManometro1)).BeginInit(); this.SuspendLayout(); // // statusBar1 // this.statusBar1.ShowPanels = true; this.statusBar1.Size = new System.Drawing.Size(576, 22); // // panelToolBar // this.panelToolBar.Size = new System.Drawing.Size(576, 64); // // panel2 // this.panel2.BorderStyle = System.Windows.Forms.BorderStyle.Fixed3D; this.panel2.Controls.Add(this.buscaBtn1); this.panel2.Controls.Add(this.txtIdManometro); this.panel2.Controls.Add(this.lblIdManometro); this.panel2.Controls.Add(this.lblManometro); this.panel2.Controls.Add(this.txtManometro); this.panel2.Location = new System.Drawing.Point(116, 115); this.panel2.Name = "panel2"; this.panel2.Size = new System.Drawing.Size(344, 192); this.panel2.TabIndex = 4; // // buscaBtn1 // this.buscaBtn1.AnchoDlgBusq = 0; this.buscaBtn1.BackColor = System.Drawing.Color.Transparent; this.buscaBtn1.Datos = this.dsManometro1.Manometro; this.buscaBtn1.Icon = ((System.Drawing.Icon)(resources.GetObject("buscaBtn1.Icon"))); this.buscaBtn1.Location = new System.Drawing.Point(232, 32); this.buscaBtn1.Name = "buscaBtn1"; this.buscaBtn1.Size = new System.Drawing.Size(64, 64); this.buscaBtn1.TabIndex = 2; this.toolTip1.SetToolTip(this.buscaBtn1, "Buscar"); // // dsManometro1 // this.dsManometro1.DataSetName = "dsManometro"; this.dsManometro1.Locale = new System.Globalization.CultureInfo("es-MX"); this.dsManometro1.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema; // // txtIdManometro // this.txtIdManometro.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dsManometro1, "Manometro.IdManometro", true)); this.txtIdManometro.Location = new System.Drawing.Point(130, 64); this.txtIdManometro.Name = "txtIdManometro"; this.txtIdManometro.Size = new System.Drawing.Size(100, 20); this.txtIdManometro.TabIndex = 1; this.txtIdManometro.Text = "textBox1"; // // lblIdManometro // this.lblIdManometro.Location = new System.Drawing.Point(26, 60); this.lblIdManometro.Name = "lblIdManometro"; this.lblIdManometro.Size = new System.Drawing.Size(100, 23); this.lblIdManometro.TabIndex = 0; this.lblIdManometro.Text = "Id Manómetro:"; this.lblIdManometro.TextAlign = System.Drawing.ContentAlignment.BottomRight; // // lblManometro // this.lblManometro.Location = new System.Drawing.Point(26, 100); this.lblManometro.Name = "lblManometro"; this.lblManometro.Size = new System.Drawing.Size(100, 23); this.lblManometro.TabIndex = 0; this.lblManometro.Text = "Manómetro:"; this.lblManometro.TextAlign = System.Drawing.ContentAlignment.BottomRight; // // txtManometro // this.txtManometro.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dsManometro1, "Manometro.Manometro", true)); this.txtManometro.Location = new System.Drawing.Point(130, 104); this.txtManometro.MaxLength = 50; this.txtManometro.Name = "txtManometro"; this.txtManometro.Size = new System.Drawing.Size(150, 20); this.txtManometro.TabIndex = 1; this.txtManometro.Text = "textBox1"; // // sqlDAManometro // this.sqlDAManometro.DeleteCommand = this.sqlDeleteCommand1; this.sqlDAManometro.InsertCommand = this.sqlInsertCommand1; this.sqlDAManometro.SelectCommand = this.sqlSelectCommand1; this.sqlDAManometro.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping("Table", "Manometro", new System.Data.Common.DataColumnMapping[] { new System.Data.Common.DataColumnMapping("IdManometro", "IdManometro"), new System.Data.Common.DataColumnMapping("Manometro", "Manometro") }) }); this.sqlDAManometro.UpdateCommand = this.sqlUpdateCommand1; // // sqlDeleteCommand1 // this.sqlDeleteCommand1.CommandText = "DELETE FROM Manometro WHERE (IdManometro = @Original_IdManometro) AND (Manometro " + "= @Original_Manometro OR @Original_Manometro IS NULL AND Manometro IS NULL)"; this.sqlDeleteCommand1.Connection = this.sqlConn; this.sqlDeleteCommand1.Parameters.AddRange(new System.Data.SqlClient.SqlParameter[] { new System.Data.SqlClient.SqlParameter("@Original_IdManometro", System.Data.SqlDbType.SmallInt, 2, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "IdManometro", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_Manometro", System.Data.SqlDbType.NVarChar, 50, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Manometro", System.Data.DataRowVersion.Original, null) }); // // sqlConn // this.sqlConn.ConnectionString = ((string)(configurationAppSettings.GetValue("sqlConn.ConnectionString", typeof(string)))); this.sqlConn.FireInfoMessageEventOnUserErrors = false; // // sqlInsertCommand1 // this.sqlInsertCommand1.CommandText = "INSERT INTO Manometro(IdManometro, Manometro) VALUES (@IdManometro, @Manometro); " + "SELECT IdManometro, Manometro FROM Manometro WHERE (IdManometro = @IdManometro) " + "ORDER BY IdManometro"; this.sqlInsertCommand1.Connection = this.sqlConn; this.sqlInsertCommand1.Parameters.AddRange(new System.Data.SqlClient.SqlParameter[] { new System.Data.SqlClient.SqlParameter("@IdManometro", System.Data.SqlDbType.SmallInt, 2, "IdManometro"), new System.Data.SqlClient.SqlParameter("@Manometro", System.Data.SqlDbType.NVarChar, 50, "Manometro") }); // // sqlSelectCommand1 // this.sqlSelectCommand1.CommandText = "SELECT IdManometro, Manometro FROM Manometro ORDER BY IdManometro"; 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("@IdManometro", System.Data.SqlDbType.SmallInt, 2, "IdManometro"), new System.Data.SqlClient.SqlParameter("@Manometro", System.Data.SqlDbType.NVarChar, 50, "Manometro"), new System.Data.SqlClient.SqlParameter("@Original_IdManometro", System.Data.SqlDbType.SmallInt, 2, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "IdManometro", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_Manometro", System.Data.SqlDbType.NVarChar, 50, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Manometro", System.Data.DataRowVersion.Original, null) }); // // Manometro // this.AutoScaleBaseSize = new System.Drawing.Size(5, 13); this.ClientSize = new System.Drawing.Size(576, 423); this.Controls.Add(this.panel2); this.DAGeneral = this.sqlDAManometro; this.dsGeneral = this.dsManometro1; this.Name = "Manometro"; this.NombreTabla = "Manometro"; this.Text = "Manometro"; this.Load += new System.EventHandler(this.Manometro_Load); this.Controls.SetChildIndex(this.panel2, 0); this.Controls.SetChildIndex(this.statusBar1, 0); this.Controls.SetChildIndex(this.panelToolBar, 0); this.panelToolBar.ResumeLayout(false); this.panel2.ResumeLayout(false); this.panel2.PerformLayout(); ((System.ComponentModel.ISupportInitialize)(this.dsManometro1)).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(Planta)); System.Configuration.AppSettingsReader configurationAppSettings = new System.Configuration.AppSettingsReader(); this.panel2 = new System.Windows.Forms.Panel(); this.buscaBtn1 = new Soluciones2000.Tools.WinLib.BuscaBtn(); this.dsPlanta1 = new LancNeo.dsPlanta(); this.cmbConcretera = new System.Windows.Forms.ComboBox(); this.dsConcretera1 = new LancNeo.dsConcretera(); this.txtIdNivel = new System.Windows.Forms.TextBox(); this.lblIdPlanta = new System.Windows.Forms.Label(); this.lblPlanta = new System.Windows.Forms.Label(); this.txtNivel = new System.Windows.Forms.TextBox(); this.lblIdConcretera = new System.Windows.Forms.Label(); this.sqlDAPlanta = 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.sqlDAConcretera = new System.Data.SqlClient.SqlDataAdapter(); this.sqlSelectCommand2 = new System.Data.SqlClient.SqlCommand(); this.panelToolBar.SuspendLayout(); this.panel2.SuspendLayout(); ((System.ComponentModel.ISupportInitialize)(this.dsPlanta1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.dsConcretera1)).BeginInit(); this.SuspendLayout(); // // statusBar1 // this.statusBar1.ShowPanels = true; this.statusBar1.Size = new System.Drawing.Size(576, 22); // // panelToolBar // this.panelToolBar.Size = new System.Drawing.Size(576, 64); // // panel2 // this.panel2.BorderStyle = System.Windows.Forms.BorderStyle.Fixed3D; this.panel2.Controls.Add(this.buscaBtn1); this.panel2.Controls.Add(this.cmbConcretera); this.panel2.Controls.Add(this.txtIdNivel); this.panel2.Controls.Add(this.lblIdPlanta); this.panel2.Controls.Add(this.lblPlanta); this.panel2.Controls.Add(this.txtNivel); this.panel2.Controls.Add(this.lblIdConcretera); this.panel2.Location = new System.Drawing.Point(48, 115); this.panel2.Name = "panel2"; this.panel2.Size = new System.Drawing.Size(456, 192); this.panel2.TabIndex = 6; // // buscaBtn1 // this.buscaBtn1.AnchoDlgBusq = 0; this.buscaBtn1.BackColor = System.Drawing.Color.Transparent; this.buscaBtn1.Datos = this.dsPlanta1.Planta; this.buscaBtn1.Icon = ((System.Drawing.Icon)(resources.GetObject("buscaBtn1.Icon"))); this.buscaBtn1.Location = new System.Drawing.Point(224, 16); this.buscaBtn1.Name = "buscaBtn1"; this.buscaBtn1.Size = new System.Drawing.Size(64, 64); this.buscaBtn1.TabIndex = 3; // // dsPlanta1 // this.dsPlanta1.DataSetName = "dsPlanta"; this.dsPlanta1.Locale = new System.Globalization.CultureInfo("es-MX"); this.dsPlanta1.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema; // // cmbConcretera // this.cmbConcretera.DataBindings.Add(new System.Windows.Forms.Binding("SelectedValue", this.dsPlanta1, "Planta.IdConcretera", true)); this.cmbConcretera.DataSource = this.dsConcretera1.Concretera; this.cmbConcretera.DisplayMember = "Concretera"; this.cmbConcretera.Location = new System.Drawing.Point(120, 128); this.cmbConcretera.Name = "cmbConcretera"; this.cmbConcretera.Size = new System.Drawing.Size(304, 21); this.cmbConcretera.TabIndex = 2; this.cmbConcretera.ValueMember = "IdConcretera"; // // dsConcretera1 // this.dsConcretera1.DataSetName = "dsConcretera"; this.dsConcretera1.Locale = new System.Globalization.CultureInfo("es-MX"); this.dsConcretera1.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema; // // txtIdNivel // this.txtIdNivel.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dsPlanta1, "Planta.IdPlanta", true)); this.txtIdNivel.Location = new System.Drawing.Point(119, 46); this.txtIdNivel.Name = "txtIdNivel"; this.txtIdNivel.Size = new System.Drawing.Size(100, 20); this.txtIdNivel.TabIndex = 1; this.txtIdNivel.Text = "textBox1"; // // lblIdPlanta // this.lblIdPlanta.Location = new System.Drawing.Point(31, 42); this.lblIdPlanta.Name = "lblIdPlanta"; this.lblIdPlanta.Size = new System.Drawing.Size(80, 23); this.lblIdPlanta.TabIndex = 0; this.lblIdPlanta.Text = "Id Planta:"; this.lblIdPlanta.TextAlign = System.Drawing.ContentAlignment.BottomRight; // // lblPlanta // this.lblPlanta.Location = new System.Drawing.Point(31, 82); this.lblPlanta.Name = "lblPlanta"; this.lblPlanta.Size = new System.Drawing.Size(80, 23); this.lblPlanta.TabIndex = 0; this.lblPlanta.Text = "Planta:"; this.lblPlanta.TextAlign = System.Drawing.ContentAlignment.BottomRight; // // txtNivel // this.txtNivel.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dsPlanta1, "Planta.Planta", true)); this.txtNivel.Location = new System.Drawing.Point(119, 86); this.txtNivel.MaxLength = 50; this.txtNivel.Name = "txtNivel"; this.txtNivel.Size = new System.Drawing.Size(97, 20); this.txtNivel.TabIndex = 1; this.txtNivel.Text = "textBox1"; // // lblIdConcretera // this.lblIdConcretera.Location = new System.Drawing.Point(31, 120); this.lblIdConcretera.Name = "lblIdConcretera"; this.lblIdConcretera.Size = new System.Drawing.Size(80, 23); this.lblIdConcretera.TabIndex = 0; this.lblIdConcretera.Text = "Id Concretera:"; this.lblIdConcretera.TextAlign = System.Drawing.ContentAlignment.BottomRight; // // sqlDAPlanta // this.sqlDAPlanta.DeleteCommand = this.sqlDeleteCommand1; this.sqlDAPlanta.InsertCommand = this.sqlInsertCommand1; this.sqlDAPlanta.SelectCommand = this.sqlSelectCommand1; 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("IdPlanta", "IdPlanta"), new System.Data.Common.DataColumnMapping("Planta", "Planta"), new System.Data.Common.DataColumnMapping("IdConcretera", "IdConcretera") }) }); this.sqlDAPlanta.UpdateCommand = this.sqlUpdateCommand1; // // sqlDeleteCommand1 // this.sqlDeleteCommand1.CommandText = "DELETE FROM Planta WHERE (IdConcretera = @Original_IdConcretera) AND (IdPlanta = " + "@Original_IdPlanta) AND (Planta = @Original_Planta OR @Original_Planta IS NULL A" + "ND Planta IS NULL)"; this.sqlDeleteCommand1.Connection = this.sqlConn; this.sqlDeleteCommand1.Parameters.AddRange(new System.Data.SqlClient.SqlParameter[] { new System.Data.SqlClient.SqlParameter("@Original_IdConcretera", System.Data.SqlDbType.NVarChar, 10, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "IdConcretera", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_IdPlanta", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "IdPlanta", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_Planta", System.Data.SqlDbType.NVarChar, 50, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Planta", 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("@IdPlanta", System.Data.SqlDbType.Int, 4, "IdPlanta"), new System.Data.SqlClient.SqlParameter("@Planta", System.Data.SqlDbType.NVarChar, 50, "Planta"), new System.Data.SqlClient.SqlParameter("@IdConcretera", System.Data.SqlDbType.NVarChar, 10, "IdConcretera") }); // // sqlSelectCommand1 // this.sqlSelectCommand1.CommandText = "SELECT IdPlanta, Planta, IdConcretera FROM Planta ORDER BY IdPlanta"; 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("@IdPlanta", System.Data.SqlDbType.Int, 4, "IdPlanta"), new System.Data.SqlClient.SqlParameter("@Planta", System.Data.SqlDbType.NVarChar, 50, "Planta"), new System.Data.SqlClient.SqlParameter("@IdConcretera", System.Data.SqlDbType.NVarChar, 10, "IdConcretera"), new System.Data.SqlClient.SqlParameter("@Original_IdConcretera", System.Data.SqlDbType.NVarChar, 10, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "IdConcretera", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_IdPlanta", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "IdPlanta", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_Planta", System.Data.SqlDbType.NVarChar, 50, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Planta", System.Data.DataRowVersion.Original, null) }); // // sqlDAConcretera // this.sqlDAConcretera.SelectCommand = this.sqlSelectCommand2; 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") }) }); // // sqlSelectCommand2 // this.sqlSelectCommand2.CommandText = "SELECT IdConcretera, Concretera, Direccion FROM Concretera ORDER BY Concretera"; this.sqlSelectCommand2.Connection = this.sqlConn; // // Planta // this.AutoScaleBaseSize = new System.Drawing.Size(5, 13); this.ClientSize = new System.Drawing.Size(576, 423); this.Controls.Add(this.panel2); this.DAGeneral = this.sqlDAPlanta; this.dsGeneral = this.dsPlanta1; this.Name = "Planta"; this.NombreTabla = "Planta"; this.Text = "Planta"; this.Load += new System.EventHandler(this.Planta_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.dsPlanta1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.dsConcretera1)).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(Laboratorista)); System.Configuration.AppSettingsReader configurationAppSettings = new System.Configuration.AppSettingsReader(); this.sqlDALaboratorista = 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.dsLaboratorista1 = new LancNeo.dsLaboratorista(); this.panel1 = new System.Windows.Forms.Panel(); this.buscaBtn1 = new Soluciones2000.Tools.WinLib.BuscaBtn(); this.dtpFecha = new System.Windows.Forms.DateTimePicker(); this.cmbZona = new System.Windows.Forms.ComboBox(); this.dsZona1 = new LancNeo.dsZona(); this.txtNoEco = new System.Windows.Forms.TextBox(); this.lblNoEco = new System.Windows.Forms.Label(); this.lblLaboratorista = new System.Windows.Forms.Label(); this.lblZona = new System.Windows.Forms.Label(); this.lblNivel = new System.Windows.Forms.Label(); this.lblFecha = new System.Windows.Forms.Label(); this.txtLaboratorista = new System.Windows.Forms.TextBox(); this.cmbNivel = new System.Windows.Forms.ComboBox(); this.dsNivel1 = new LancNeo.dsNivel(); this.sqlDAZona = new System.Data.SqlClient.SqlDataAdapter(); this.sqlCommand1 = new System.Data.SqlClient.SqlCommand(); this.sqlCommand2 = new System.Data.SqlClient.SqlCommand(); this.sqlCommand3 = new System.Data.SqlClient.SqlCommand(); this.sqlCommand4 = new System.Data.SqlClient.SqlCommand(); this.sqlDANivel = new System.Data.SqlClient.SqlDataAdapter(); this.sqlCommand5 = new System.Data.SqlClient.SqlCommand(); this.sqlCommand6 = new System.Data.SqlClient.SqlCommand(); this.sqlCommand7 = new System.Data.SqlClient.SqlCommand(); this.sqlCommand8 = new System.Data.SqlClient.SqlCommand(); this.sqlDABusq = new System.Data.SqlClient.SqlDataAdapter(); this.sqlCommand11 = new System.Data.SqlClient.SqlCommand(); this.panelToolBar.SuspendLayout(); ((System.ComponentModel.ISupportInitialize)(this.dsLaboratorista1)).BeginInit(); this.panel1.SuspendLayout(); ((System.ComponentModel.ISupportInitialize)(this.dsZona1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.dsNivel1)).BeginInit(); this.SuspendLayout(); // // statusBar1 // this.statusBar1.ShowPanels = true; this.statusBar1.Size = new System.Drawing.Size(576, 22); // // panelToolBar // this.panelToolBar.Size = new System.Drawing.Size(576, 64); // // sqlDALaboratorista // this.sqlDALaboratorista.DeleteCommand = this.sqlDeleteCommand1; this.sqlDALaboratorista.InsertCommand = this.sqlInsertCommand1; this.sqlDALaboratorista.SelectCommand = this.sqlSelectCommand1; 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") }) }); this.sqlDALaboratorista.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_NoEco", System.Data.SqlDbType.SmallInt, 2, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "NoEco", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_Fechai", System.Data.SqlDbType.DateTime, 8, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Fechai", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_IdNivel", System.Data.SqlDbType.SmallInt, 2, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "IdNivel", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_IdZona", System.Data.SqlDbType.NVarChar, 1, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "IdZona", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_Laboratorista", System.Data.SqlDbType.NVarChar, 50, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Laboratorista", 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("@NoEco", System.Data.SqlDbType.SmallInt, 2, "NoEco"), new System.Data.SqlClient.SqlParameter("@Laboratorista", System.Data.SqlDbType.NVarChar, 50, "Laboratorista"), new System.Data.SqlClient.SqlParameter("@IdZona", System.Data.SqlDbType.NVarChar, 1, "IdZona"), new System.Data.SqlClient.SqlParameter("@IdNivel", System.Data.SqlDbType.SmallInt, 2, "IdNivel"), new System.Data.SqlClient.SqlParameter("@Fechai", System.Data.SqlDbType.DateTime, 8, "Fechai") }); // // sqlSelectCommand1 // this.sqlSelectCommand1.CommandText = "SELECT NoEco, Laboratorista, IdZona, IdNivel, Fechai FROM Laboratorista ORDER BY " + "NoEco"; 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("@NoEco", System.Data.SqlDbType.SmallInt, 2, "NoEco"), new System.Data.SqlClient.SqlParameter("@Laboratorista", System.Data.SqlDbType.NVarChar, 50, "Laboratorista"), new System.Data.SqlClient.SqlParameter("@IdZona", System.Data.SqlDbType.NVarChar, 1, "IdZona"), new System.Data.SqlClient.SqlParameter("@IdNivel", System.Data.SqlDbType.SmallInt, 2, "IdNivel"), new System.Data.SqlClient.SqlParameter("@Fechai", System.Data.SqlDbType.DateTime, 8, "Fechai"), new System.Data.SqlClient.SqlParameter("@Original_NoEco", System.Data.SqlDbType.SmallInt, 2, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "NoEco", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_Fechai", System.Data.SqlDbType.DateTime, 8, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Fechai", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_IdNivel", System.Data.SqlDbType.SmallInt, 2, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "IdNivel", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_IdZona", System.Data.SqlDbType.NVarChar, 1, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "IdZona", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_Laboratorista", System.Data.SqlDbType.NVarChar, 50, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Laboratorista", System.Data.DataRowVersion.Original, null) }); // // dsLaboratorista1 // this.dsLaboratorista1.DataSetName = "dsLaboratorista"; this.dsLaboratorista1.Locale = new System.Globalization.CultureInfo("es-MX"); this.dsLaboratorista1.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema; // // panel1 // this.panel1.BorderStyle = System.Windows.Forms.BorderStyle.Fixed3D; this.panel1.Controls.Add(this.buscaBtn1); this.panel1.Controls.Add(this.dtpFecha); this.panel1.Controls.Add(this.cmbZona); this.panel1.Controls.Add(this.txtNoEco); this.panel1.Controls.Add(this.lblNoEco); this.panel1.Controls.Add(this.lblLaboratorista); this.panel1.Controls.Add(this.lblZona); this.panel1.Controls.Add(this.lblNivel); this.panel1.Controls.Add(this.lblFecha); this.panel1.Controls.Add(this.txtLaboratorista); this.panel1.Controls.Add(this.cmbNivel); this.panel1.Location = new System.Drawing.Point(80, 96); this.panel1.Name = "panel1"; this.panel1.Size = new System.Drawing.Size(416, 256); this.panel1.TabIndex = 0; // // buscaBtn1 // this.buscaBtn1.AnchoDlgBusq = 450; this.buscaBtn1.BackColor = System.Drawing.Color.Transparent; this.buscaBtn1.Datos = this.dsLaboratorista1.Laboratorista; this.buscaBtn1.Icon = ((System.Drawing.Icon)(resources.GetObject("buscaBtn1.Icon"))); this.buscaBtn1.Location = new System.Drawing.Point(248, 8); this.buscaBtn1.Name = "buscaBtn1"; this.buscaBtn1.Size = new System.Drawing.Size(64, 64); this.buscaBtn1.TabIndex = 4; this.toolTip1.SetToolTip(this.buscaBtn1, "Buscar"); // // dtpFecha // this.dtpFecha.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dsLaboratorista1, "Laboratorista.Fechai", true)); this.dtpFecha.Location = new System.Drawing.Point(144, 192); this.dtpFecha.Name = "dtpFecha"; this.dtpFecha.Size = new System.Drawing.Size(200, 20); this.dtpFecha.TabIndex = 3; this.dtpFecha.Value = new System.DateTime(2004, 7, 7, 0, 0, 0, 0); // // cmbZona // this.cmbZona.DataBindings.Add(new System.Windows.Forms.Binding("SelectedValue", this.dsLaboratorista1, "Laboratorista.IdZona", true)); this.cmbZona.DataSource = this.dsZona1.Zona; this.cmbZona.DisplayMember = "Zona"; this.cmbZona.Location = new System.Drawing.Point(144, 112); this.cmbZona.Name = "cmbZona"; this.cmbZona.Size = new System.Drawing.Size(256, 21); this.cmbZona.TabIndex = 2; this.cmbZona.ValueMember = "IdZona"; // // dsZona1 // this.dsZona1.DataSetName = "dsZona"; this.dsZona1.Locale = new System.Globalization.CultureInfo("en-US"); this.dsZona1.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema; // // txtNoEco // this.txtNoEco.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dsLaboratorista1, "Laboratorista.NoEco", true)); this.txtNoEco.Location = new System.Drawing.Point(144, 32); this.txtNoEco.Name = "txtNoEco"; this.txtNoEco.Size = new System.Drawing.Size(100, 20); this.txtNoEco.TabIndex = 1; this.txtNoEco.Text = "textBox1"; // // lblNoEco // this.lblNoEco.Location = new System.Drawing.Point(8, 32); this.lblNoEco.Name = "lblNoEco"; this.lblNoEco.Size = new System.Drawing.Size(112, 23); this.lblNoEco.TabIndex = 0; this.lblNoEco.Text = "Número económico:"; this.lblNoEco.TextAlign = System.Drawing.ContentAlignment.MiddleRight; // // lblLaboratorista // this.lblLaboratorista.Location = new System.Drawing.Point(8, 72); this.lblLaboratorista.Name = "lblLaboratorista"; this.lblLaboratorista.Size = new System.Drawing.Size(112, 23); this.lblLaboratorista.TabIndex = 0; this.lblLaboratorista.Text = "Laboratorista:"; this.lblLaboratorista.TextAlign = System.Drawing.ContentAlignment.MiddleRight; // // lblZona // this.lblZona.Location = new System.Drawing.Point(8, 112); this.lblZona.Name = "lblZona"; this.lblZona.Size = new System.Drawing.Size(112, 23); this.lblZona.TabIndex = 0; this.lblZona.Text = "Zona"; this.lblZona.TextAlign = System.Drawing.ContentAlignment.MiddleRight; // // lblNivel // this.lblNivel.Location = new System.Drawing.Point(8, 152); this.lblNivel.Name = "lblNivel"; this.lblNivel.Size = new System.Drawing.Size(112, 23); this.lblNivel.TabIndex = 0; this.lblNivel.Text = "Nivel"; this.lblNivel.TextAlign = System.Drawing.ContentAlignment.MiddleRight; // // lblFecha // this.lblFecha.Location = new System.Drawing.Point(8, 192); this.lblFecha.Name = "lblFecha"; this.lblFecha.Size = new System.Drawing.Size(112, 23); this.lblFecha.TabIndex = 0; this.lblFecha.Text = "Fecha de Ingreso:"; this.lblFecha.TextAlign = System.Drawing.ContentAlignment.MiddleRight; // // txtLaboratorista // this.txtLaboratorista.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dsLaboratorista1, "Laboratorista.Laboratorista", true)); this.txtLaboratorista.Location = new System.Drawing.Point(144, 72); this.txtLaboratorista.Name = "txtLaboratorista"; this.txtLaboratorista.Size = new System.Drawing.Size(256, 20); this.txtLaboratorista.TabIndex = 1; this.txtLaboratorista.Text = "textBox1"; // // cmbNivel // this.cmbNivel.DataBindings.Add(new System.Windows.Forms.Binding("SelectedValue", this.dsLaboratorista1, "Laboratorista.IdNivel", true)); this.cmbNivel.DataSource = this.dsNivel1.Nivel; this.cmbNivel.DisplayMember = "Nivel"; this.cmbNivel.Location = new System.Drawing.Point(144, 152); this.cmbNivel.Name = "cmbNivel"; this.cmbNivel.Size = new System.Drawing.Size(121, 21); this.cmbNivel.TabIndex = 2; this.cmbNivel.ValueMember = "IdNivel"; // // dsNivel1 // this.dsNivel1.DataSetName = "dsNivel"; this.dsNivel1.Locale = new System.Globalization.CultureInfo("es-MX"); this.dsNivel1.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema; // // sqlDAZona // this.sqlDAZona.DeleteCommand = this.sqlCommand1; this.sqlDAZona.InsertCommand = this.sqlCommand2; this.sqlDAZona.SelectCommand = this.sqlCommand3; this.sqlDAZona.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping("Table", "Zona", new System.Data.Common.DataColumnMapping[] { new System.Data.Common.DataColumnMapping("IdZona", "IdZona"), new System.Data.Common.DataColumnMapping("Zona", "Zona"), new System.Data.Common.DataColumnMapping("Ubicación", "Ubicación") }) }); this.sqlDAZona.UpdateCommand = this.sqlCommand4; // // sqlCommand1 // this.sqlCommand1.CommandText = resources.GetString("sqlCommand1.CommandText"); this.sqlCommand1.Connection = this.sqlConn; this.sqlCommand1.Parameters.AddRange(new System.Data.SqlClient.SqlParameter[] { new System.Data.SqlClient.SqlParameter("@Original_IdZona", System.Data.SqlDbType.NVarChar, 1, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "IdZona", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_Ubicación", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Ubicación", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_Zona", System.Data.SqlDbType.NVarChar, 50, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Zona", System.Data.DataRowVersion.Original, null) }); // // sqlCommand2 // this.sqlCommand2.CommandText = "INSERT INTO Zona(IdZona, Zona, Ubicación) VALUES (@IdZona, @Zona, @Ubicación); SE" + "LECT IdZona, Zona, Ubicación FROM Zona WHERE (IdZona = @IdZona)"; this.sqlCommand2.Connection = this.sqlConn; this.sqlCommand2.Parameters.AddRange(new System.Data.SqlClient.SqlParameter[] { new System.Data.SqlClient.SqlParameter("@IdZona", System.Data.SqlDbType.NVarChar, 1, "IdZona"), new System.Data.SqlClient.SqlParameter("@Zona", System.Data.SqlDbType.NVarChar, 50, "Zona"), new System.Data.SqlClient.SqlParameter("@Ubicación", System.Data.SqlDbType.Int, 4, "Ubicación") }); // // sqlCommand3 // this.sqlCommand3.CommandText = "SELECT IdZona, Zona, Ubicación FROM Zona"; this.sqlCommand3.Connection = this.sqlConn; // // sqlCommand4 // this.sqlCommand4.CommandText = resources.GetString("sqlCommand4.CommandText"); this.sqlCommand4.Connection = this.sqlConn; this.sqlCommand4.Parameters.AddRange(new System.Data.SqlClient.SqlParameter[] { new System.Data.SqlClient.SqlParameter("@IdZona", System.Data.SqlDbType.NVarChar, 1, "IdZona"), new System.Data.SqlClient.SqlParameter("@Zona", System.Data.SqlDbType.NVarChar, 50, "Zona"), new System.Data.SqlClient.SqlParameter("@Ubicación", System.Data.SqlDbType.Int, 4, "Ubicación"), new System.Data.SqlClient.SqlParameter("@Original_IdZona", System.Data.SqlDbType.NVarChar, 1, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "IdZona", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_Ubicación", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Ubicación", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_Zona", System.Data.SqlDbType.NVarChar, 50, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Zona", System.Data.DataRowVersion.Original, null) }); // // sqlDANivel // this.sqlDANivel.DeleteCommand = this.sqlCommand5; this.sqlDANivel.InsertCommand = this.sqlCommand6; this.sqlDANivel.SelectCommand = this.sqlCommand7; this.sqlDANivel.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping("Table", "Nivel", new System.Data.Common.DataColumnMapping[] { new System.Data.Common.DataColumnMapping("IdNivel", "IdNivel"), new System.Data.Common.DataColumnMapping("Nivel", "Nivel") }) }); this.sqlDANivel.UpdateCommand = this.sqlCommand8; // // sqlCommand5 // this.sqlCommand5.CommandText = "DELETE FROM Nivel WHERE (IdNivel = @Original_IdNivel) AND (Nivel = @Original_Nive" + "l OR @Original_Nivel IS NULL AND Nivel IS NULL)"; this.sqlCommand5.Connection = this.sqlConn; this.sqlCommand5.Parameters.AddRange(new System.Data.SqlClient.SqlParameter[] { new System.Data.SqlClient.SqlParameter("@Original_IdNivel", System.Data.SqlDbType.SmallInt, 2, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "IdNivel", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_Nivel", System.Data.SqlDbType.NVarChar, 50, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Nivel", System.Data.DataRowVersion.Original, null) }); // // sqlCommand6 // this.sqlCommand6.CommandText = "INSERT INTO Nivel(IdNivel, Nivel) VALUES (@IdNivel, @Nivel); SELECT IdNivel, Nive" + "l FROM Nivel WHERE (IdNivel = @IdNivel) ORDER BY IdNivel"; this.sqlCommand6.Connection = this.sqlConn; this.sqlCommand6.Parameters.AddRange(new System.Data.SqlClient.SqlParameter[] { new System.Data.SqlClient.SqlParameter("@IdNivel", System.Data.SqlDbType.SmallInt, 2, "IdNivel"), new System.Data.SqlClient.SqlParameter("@Nivel", System.Data.SqlDbType.NVarChar, 50, "Nivel") }); // // sqlCommand7 // this.sqlCommand7.CommandText = "SELECT IdNivel, Nivel FROM Nivel ORDER BY IdNivel"; this.sqlCommand7.Connection = this.sqlConn; // // sqlCommand8 // this.sqlCommand8.CommandText = resources.GetString("sqlCommand8.CommandText"); this.sqlCommand8.Connection = this.sqlConn; this.sqlCommand8.Parameters.AddRange(new System.Data.SqlClient.SqlParameter[] { new System.Data.SqlClient.SqlParameter("@IdNivel", System.Data.SqlDbType.SmallInt, 2, "IdNivel"), new System.Data.SqlClient.SqlParameter("@Nivel", System.Data.SqlDbType.NVarChar, 50, "Nivel"), new System.Data.SqlClient.SqlParameter("@Original_IdNivel", System.Data.SqlDbType.SmallInt, 2, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "IdNivel", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_Nivel", System.Data.SqlDbType.NVarChar, 50, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Nivel", System.Data.DataRowVersion.Original, null) }); // // sqlDABusq // this.sqlDABusq.SelectCommand = this.sqlCommand11; this.sqlDABusq.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") }) }); // // sqlCommand11 // this.sqlCommand11.CommandText = resources.GetString("sqlCommand11.CommandText"); this.sqlCommand11.Connection = this.sqlConn; // // Laboratorista // this.AutoScaleBaseSize = new System.Drawing.Size(5, 13); this.ClientSize = new System.Drawing.Size(576, 423); this.Controls.Add(this.panel1); this.DAGeneral = this.sqlDALaboratorista; this.dsGeneral = this.dsLaboratorista1; this.Name = "Laboratorista"; this.NombreTabla = "Laboratorista"; this.Text = "Laboratorista"; this.Load += new System.EventHandler(this.Laboratorista_Load); this.Controls.SetChildIndex(this.panel1, 0); this.Controls.SetChildIndex(this.statusBar1, 0); this.Controls.SetChildIndex(this.panelToolBar, 0); this.panelToolBar.ResumeLayout(false); ((System.ComponentModel.ISupportInitialize)(this.dsLaboratorista1)).EndInit(); this.panel1.ResumeLayout(false); this.panel1.PerformLayout(); ((System.ComponentModel.ISupportInitialize)(this.dsZona1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.dsNivel1)).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(Unidad)); System.Configuration.AppSettingsReader configurationAppSettings = new System.Configuration.AppSettingsReader(); this.panel2 = new System.Windows.Forms.Panel(); this.buscaBtn1 = new Soluciones2000.Tools.WinLib.BuscaBtn(); this.dsUnidad1 = new LancNeo.dsUnidad(); this.label2 = new System.Windows.Forms.Label(); this.txtUfrevenimiento = new System.Windows.Forms.TextBox(); this.label1 = new System.Windows.Forms.Label(); this.txtfUagregado = new System.Windows.Forms.TextBox(); this.txtIdUnidad = new System.Windows.Forms.TextBox(); this.lblIdUnidad = new System.Windows.Forms.Label(); this.lblUnidad = new System.Windows.Forms.Label(); this.lblFactor = new System.Windows.Forms.Label(); this.lblUnAgreg = new System.Windows.Forms.Label(); this.lblUnReven = new System.Windows.Forms.Label(); this.txtUnidad = new System.Windows.Forms.TextBox(); this.txtFactor = new System.Windows.Forms.TextBox(); this.txtUniAgreg = new System.Windows.Forms.TextBox(); this.txtUniReven = new System.Windows.Forms.TextBox(); this.sqlDAUnidad = 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.panelToolBar.SuspendLayout(); this.panel2.SuspendLayout(); ((System.ComponentModel.ISupportInitialize)(this.dsUnidad1)).BeginInit(); this.SuspendLayout(); // // statusBar1 // this.statusBar1.ShowPanels = true; this.statusBar1.Size = new System.Drawing.Size(576, 22); // // panelToolBar // this.panelToolBar.Size = new System.Drawing.Size(576, 64); // // panel2 // this.panel2.BorderStyle = System.Windows.Forms.BorderStyle.Fixed3D; this.panel2.Controls.Add(this.buscaBtn1); this.panel2.Controls.Add(this.label2); this.panel2.Controls.Add(this.txtUfrevenimiento); this.panel2.Controls.Add(this.label1); this.panel2.Controls.Add(this.txtfUagregado); this.panel2.Controls.Add(this.txtIdUnidad); this.panel2.Controls.Add(this.lblIdUnidad); this.panel2.Controls.Add(this.lblUnidad); this.panel2.Controls.Add(this.lblFactor); this.panel2.Controls.Add(this.lblUnAgreg); this.panel2.Controls.Add(this.lblUnReven); this.panel2.Controls.Add(this.txtUnidad); this.panel2.Controls.Add(this.txtFactor); this.panel2.Controls.Add(this.txtUniAgreg); this.panel2.Controls.Add(this.txtUniReven); this.panel2.Location = new System.Drawing.Point(72, 83); this.panel2.Name = "panel2"; this.panel2.Size = new System.Drawing.Size(432, 277); this.panel2.TabIndex = 4; // // buscaBtn1 // this.buscaBtn1.AnchoDlgBusq = 0; this.buscaBtn1.BackColor = System.Drawing.Color.Transparent; this.buscaBtn1.Datos = this.dsUnidad1.Unidad; this.buscaBtn1.Icon = ((System.Drawing.Icon)(resources.GetObject("buscaBtn1.Icon"))); this.buscaBtn1.Location = new System.Drawing.Point(304, 8); this.buscaBtn1.Name = "buscaBtn1"; this.buscaBtn1.Size = new System.Drawing.Size(64, 64); this.buscaBtn1.TabIndex = 2; this.toolTip1.SetToolTip(this.buscaBtn1, "Buscar"); // // dsUnidad1 // this.dsUnidad1.DataSetName = "dsUnidad"; this.dsUnidad1.Locale = new System.Globalization.CultureInfo("es-MX"); this.dsUnidad1.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema; // // label2 // this.label2.Location = new System.Drawing.Point(8, 232); this.label2.Name = "label2"; this.label2.Size = new System.Drawing.Size(176, 23); this.label2.TabIndex = 5; this.label2.Text = "Conversión unidad revenimiento:"; this.label2.TextAlign = System.Drawing.ContentAlignment.MiddleRight; // // txtUfrevenimiento // this.txtUfrevenimiento.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dsUnidad1, "Unidad.FacRev", true)); this.txtUfrevenimiento.Location = new System.Drawing.Point(200, 232); this.txtUfrevenimiento.Name = "txtUfrevenimiento"; this.txtUfrevenimiento.Size = new System.Drawing.Size(100, 20); this.txtUfrevenimiento.TabIndex = 6; this.txtUfrevenimiento.Text = "txtUrevenimiento"; // // label1 // this.label1.Location = new System.Drawing.Point(24, 200); this.label1.Name = "label1"; this.label1.Size = new System.Drawing.Size(160, 23); this.label1.TabIndex = 3; this.label1.Text = "Conversión unidad agregado:"; this.label1.TextAlign = System.Drawing.ContentAlignment.MiddleRight; // // txtfUagregado // this.txtfUagregado.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dsUnidad1, "Unidad.FacMax", true)); this.txtfUagregado.Location = new System.Drawing.Point(200, 200); this.txtfUagregado.Name = "txtfUagregado"; this.txtfUagregado.Size = new System.Drawing.Size(100, 20); this.txtfUagregado.TabIndex = 4; this.txtfUagregado.Text = "txtUrevenimiento"; // // txtIdUnidad // this.txtIdUnidad.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dsUnidad1, "Unidad.IdUnidad", true)); this.txtIdUnidad.Location = new System.Drawing.Point(200, 40); this.txtIdUnidad.Name = "txtIdUnidad"; this.txtIdUnidad.Size = new System.Drawing.Size(100, 20); this.txtIdUnidad.TabIndex = 1; this.txtIdUnidad.Text = "textBox1"; // // lblIdUnidad // this.lblIdUnidad.Location = new System.Drawing.Point(48, 35); this.lblIdUnidad.Name = "lblIdUnidad"; this.lblIdUnidad.Size = new System.Drawing.Size(136, 23); this.lblIdUnidad.TabIndex = 0; this.lblIdUnidad.Text = "Id Unidad:"; this.lblIdUnidad.TextAlign = System.Drawing.ContentAlignment.MiddleRight; // // lblUnidad // this.lblUnidad.Location = new System.Drawing.Point(48, 64); this.lblUnidad.Name = "lblUnidad"; this.lblUnidad.Size = new System.Drawing.Size(136, 23); this.lblUnidad.TabIndex = 0; this.lblUnidad.Text = "Descripción:"; this.lblUnidad.TextAlign = System.Drawing.ContentAlignment.MiddleRight; // // lblFactor // this.lblFactor.Location = new System.Drawing.Point(48, 96); this.lblFactor.Name = "lblFactor"; this.lblFactor.Size = new System.Drawing.Size(136, 23); this.lblFactor.TabIndex = 0; this.lblFactor.Text = "Factor a Kg f/ cm ²:"; this.lblFactor.TextAlign = System.Drawing.ContentAlignment.MiddleRight; // // lblUnAgreg // this.lblUnAgreg.Location = new System.Drawing.Point(48, 128); this.lblUnAgreg.Name = "lblUnAgreg"; this.lblUnAgreg.Size = new System.Drawing.Size(136, 23); this.lblUnAgreg.TabIndex = 0; this.lblUnAgreg.Text = "Unidad del agregado:"; this.lblUnAgreg.TextAlign = System.Drawing.ContentAlignment.MiddleRight; // // lblUnReven // this.lblUnReven.Location = new System.Drawing.Point(48, 160); this.lblUnReven.Name = "lblUnReven"; this.lblUnReven.Size = new System.Drawing.Size(136, 23); this.lblUnReven.TabIndex = 0; this.lblUnReven.Text = "Unidad del revenimiento:"; this.lblUnReven.TextAlign = System.Drawing.ContentAlignment.MiddleRight; // // txtUnidad // this.txtUnidad.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dsUnidad1, "Unidad.Undescr", true)); this.txtUnidad.Location = new System.Drawing.Point(200, 72); this.txtUnidad.Name = "txtUnidad"; this.txtUnidad.Size = new System.Drawing.Size(100, 20); this.txtUnidad.TabIndex = 1; this.txtUnidad.Text = "textBox1"; // // txtFactor // this.txtFactor.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dsUnidad1, "Unidad.Factor", true)); this.txtFactor.Location = new System.Drawing.Point(200, 104); this.txtFactor.Name = "txtFactor"; this.txtFactor.Size = new System.Drawing.Size(100, 20); this.txtFactor.TabIndex = 1; this.txtFactor.Text = "textBox1"; // // txtUniAgreg // this.txtUniAgreg.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dsUnidad1, "Unidad.MaxagrUn", true)); this.txtUniAgreg.Location = new System.Drawing.Point(200, 136); this.txtUniAgreg.Name = "txtUniAgreg"; this.txtUniAgreg.Size = new System.Drawing.Size(100, 20); this.txtUniAgreg.TabIndex = 1; this.txtUniAgreg.Text = "textBox1"; // // txtUniReven // this.txtUniReven.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dsUnidad1, "Unidad.RevenUn", true)); this.txtUniReven.Location = new System.Drawing.Point(200, 168); this.txtUniReven.Name = "txtUniReven"; this.txtUniReven.Size = new System.Drawing.Size(100, 20); this.txtUniReven.TabIndex = 1; this.txtUniReven.Text = "txtUagregado"; // // sqlDAUnidad // this.sqlDAUnidad.DeleteCommand = this.sqlDeleteCommand1; this.sqlDAUnidad.InsertCommand = this.sqlInsertCommand1; 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("Undescr", "Undescr"), new System.Data.Common.DataColumnMapping("Factor", "Factor"), new System.Data.Common.DataColumnMapping("MaxagrUn", "MaxagrUn"), new System.Data.Common.DataColumnMapping("RevenUn", "RevenUn"), new System.Data.Common.DataColumnMapping("FacMax", "FacMax"), new System.Data.Common.DataColumnMapping("FacRev", "FacRev") }) }); this.sqlDAUnidad.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_IdUnidad", System.Data.SqlDbType.SmallInt, 2, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "IdUnidad", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_FacMax", System.Data.SqlDbType.Real, 4, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "FacMax", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_FacRev", System.Data.SqlDbType.Real, 4, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "FacRev", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_Factor", System.Data.SqlDbType.Real, 4, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Factor", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_MaxagrUn", System.Data.SqlDbType.NVarChar, 2, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "MaxagrUn", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_RevenUn", System.Data.SqlDbType.NVarChar, 2, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "RevenUn", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_Undescr", System.Data.SqlDbType.NVarChar, 7, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Undescr", 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("@IdUnidad", System.Data.SqlDbType.SmallInt, 2, "IdUnidad"), new System.Data.SqlClient.SqlParameter("@Undescr", System.Data.SqlDbType.NVarChar, 7, "Undescr"), new System.Data.SqlClient.SqlParameter("@Factor", System.Data.SqlDbType.Real, 4, "Factor"), new System.Data.SqlClient.SqlParameter("@MaxagrUn", System.Data.SqlDbType.NVarChar, 2, "MaxagrUn"), new System.Data.SqlClient.SqlParameter("@RevenUn", System.Data.SqlDbType.NVarChar, 2, "RevenUn"), new System.Data.SqlClient.SqlParameter("@FacMax", System.Data.SqlDbType.Real, 4, "FacMax"), new System.Data.SqlClient.SqlParameter("@FacRev", System.Data.SqlDbType.Real, 4, "FacRev") }); // // sqlSelectCommand1 // this.sqlSelectCommand1.CommandText = "SELECT IdUnidad, Undescr, Factor, MaxagrUn, RevenUn, FacMax, FacRev FROM Unidad"; 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("@IdUnidad", System.Data.SqlDbType.SmallInt, 2, "IdUnidad"), new System.Data.SqlClient.SqlParameter("@Undescr", System.Data.SqlDbType.NVarChar, 7, "Undescr"), new System.Data.SqlClient.SqlParameter("@Factor", System.Data.SqlDbType.Real, 4, "Factor"), new System.Data.SqlClient.SqlParameter("@MaxagrUn", System.Data.SqlDbType.NVarChar, 2, "MaxagrUn"), new System.Data.SqlClient.SqlParameter("@RevenUn", System.Data.SqlDbType.NVarChar, 2, "RevenUn"), new System.Data.SqlClient.SqlParameter("@FacMax", System.Data.SqlDbType.Real, 4, "FacMax"), new System.Data.SqlClient.SqlParameter("@FacRev", System.Data.SqlDbType.Real, 4, "FacRev"), new System.Data.SqlClient.SqlParameter("@Original_IdUnidad", System.Data.SqlDbType.SmallInt, 2, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "IdUnidad", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_FacMax", System.Data.SqlDbType.Real, 4, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "FacMax", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_FacRev", System.Data.SqlDbType.Real, 4, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "FacRev", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_Factor", System.Data.SqlDbType.Real, 4, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Factor", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_MaxagrUn", System.Data.SqlDbType.NVarChar, 2, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "MaxagrUn", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_RevenUn", System.Data.SqlDbType.NVarChar, 2, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "RevenUn", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_Undescr", System.Data.SqlDbType.NVarChar, 7, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Undescr", System.Data.DataRowVersion.Original, null) }); // // Unidad // this.AutoScaleBaseSize = new System.Drawing.Size(5, 13); this.ClientSize = new System.Drawing.Size(576, 423); this.Controls.Add(this.panel2); this.DAGeneral = this.sqlDAUnidad; this.dsGeneral = this.dsUnidad1; this.Name = "Unidad"; this.NombreTabla = "Unidad"; this.Text = "Catálogo de Unidad de Medida"; this.Load += new System.EventHandler(this.Unidad_Load); this.Controls.SetChildIndex(this.panel2, 0); this.Controls.SetChildIndex(this.statusBar1, 0); this.Controls.SetChildIndex(this.panelToolBar, 0); this.panelToolBar.ResumeLayout(false); this.panel2.ResumeLayout(false); this.panel2.PerformLayout(); ((System.ComponentModel.ISupportInitialize)(this.dsUnidad1)).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(Cliente)); System.Configuration.AppSettingsReader configurationAppSettings = new System.Configuration.AppSettingsReader(); this.panel2 = new System.Windows.Forms.Panel(); this.buscaBtn1 = new Soluciones2000.Tools.WinLib.BuscaBtn(); this.dsBusCliente1 = new LancNeo.dsBusCliente(); this.textBox8 = new System.Windows.Forms.TextBox(); this.dsCliente1 = new LancNeo.dsCliente(); this.groupBox2 = new System.Windows.Forms.GroupBox(); this.radioButton5 = new System.Windows.Forms.RadioButton(); this.radioButton4 = new System.Windows.Forms.RadioButton(); this.label13 = new System.Windows.Forms.Label(); this.txtDiasr = new System.Windows.Forms.TextBox(); this.label5 = new System.Windows.Forms.Label(); this.txtColonia = new System.Windows.Forms.TextBox(); this.label4 = new System.Windows.Forms.Label(); this.txtDirección = new System.Windows.Forms.TextBox(); this.label2 = new System.Windows.Forms.Label(); this.txtCliente = new System.Windows.Forms.TextBox(); this.label1 = new System.Windows.Forms.Label(); this.txtIdCliente = new System.Windows.Forms.TextBox(); this.sqlDACliente = 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.sqlDABusCliente = new System.Data.SqlClient.SqlDataAdapter(); this.sqlSelectCommand2 = new System.Data.SqlClient.SqlCommand(); this.panelToolBar.SuspendLayout(); this.panel2.SuspendLayout(); ((System.ComponentModel.ISupportInitialize)(this.dsBusCliente1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.dsCliente1)).BeginInit(); this.groupBox2.SuspendLayout(); this.SuspendLayout(); // // statusBar1 // this.statusBar1.Location = new System.Drawing.Point(0, 309); this.statusBar1.ShowPanels = true; this.statusBar1.Size = new System.Drawing.Size(576, 22); // // panelToolBar // this.panelToolBar.Size = new System.Drawing.Size(576, 64); // // panel2 // this.panel2.BorderStyle = System.Windows.Forms.BorderStyle.Fixed3D; this.panel2.Controls.Add(this.buscaBtn1); this.panel2.Controls.Add(this.textBox8); this.panel2.Controls.Add(this.groupBox2); this.panel2.Controls.Add(this.label13); this.panel2.Controls.Add(this.txtDiasr); this.panel2.Controls.Add(this.label5); this.panel2.Controls.Add(this.txtColonia); this.panel2.Controls.Add(this.label4); this.panel2.Controls.Add(this.txtDirección); this.panel2.Controls.Add(this.label2); this.panel2.Controls.Add(this.txtCliente); this.panel2.Controls.Add(this.label1); this.panel2.Controls.Add(this.txtIdCliente); this.panel2.Location = new System.Drawing.Point(8, 72); this.panel2.Name = "panel2"; this.panel2.Size = new System.Drawing.Size(564, 230); this.panel2.TabIndex = 4; // // buscaBtn1 // this.buscaBtn1.AnchoDlgBusq = 600; this.buscaBtn1.BackColor = System.Drawing.Color.Transparent; this.buscaBtn1.Datos = this.dsBusCliente1.cliente; this.buscaBtn1.Icon = ((System.Drawing.Icon)(resources.GetObject("buscaBtn1.Icon"))); this.buscaBtn1.Location = new System.Drawing.Point(228, 0); this.buscaBtn1.Name = "buscaBtn1"; this.buscaBtn1.Size = new System.Drawing.Size(64, 64); this.buscaBtn1.TabIndex = 4; // // dsBusCliente1 // this.dsBusCliente1.DataSetName = "dsBusCliente"; this.dsBusCliente1.Locale = new System.Globalization.CultureInfo("es-MX"); this.dsBusCliente1.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema; // // textBox8 // this.textBox8.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dsCliente1, "cliente.Pago", true)); this.textBox8.Location = new System.Drawing.Point(450, 159); this.textBox8.Name = "textBox8"; this.textBox8.ReadOnly = true; this.textBox8.Size = new System.Drawing.Size(0, 20); this.textBox8.TabIndex = 78; this.textBox8.TextChanged += new System.EventHandler(this.textBox8_TextChanged); // // dsCliente1 // this.dsCliente1.DataSetName = "dsCliente"; this.dsCliente1.Locale = new System.Globalization.CultureInfo("es-MX"); this.dsCliente1.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema; // // groupBox2 // this.groupBox2.Controls.Add(this.radioButton5); this.groupBox2.Controls.Add(this.radioButton4); this.groupBox2.ForeColor = System.Drawing.Color.White; this.groupBox2.Location = new System.Drawing.Point(140, 181); this.groupBox2.Name = "groupBox2"; this.groupBox2.Size = new System.Drawing.Size(166, 31); this.groupBox2.TabIndex = 32; this.groupBox2.TabStop = false; // // radioButton5 // this.radioButton5.AutoSize = true; this.radioButton5.CheckAlign = System.Drawing.ContentAlignment.MiddleRight; this.radioButton5.ForeColor = System.Drawing.Color.White; this.radioButton5.Location = new System.Drawing.Point(73, 8); this.radioButton5.Name = "radioButton5"; this.radioButton5.Size = new System.Drawing.Size(76, 17); this.radioButton5.TabIndex = 1; this.radioButton5.TabStop = true; this.radioButton5.Text = "PAQUETE"; this.radioButton5.UseVisualStyleBackColor = true; this.radioButton5.CheckedChanged += new System.EventHandler(this.radioButton5_CheckedChanged); // // radioButton4 // this.radioButton4.AutoSize = true; this.radioButton4.CheckAlign = System.Drawing.ContentAlignment.MiddleRight; this.radioButton4.ForeColor = System.Drawing.Color.White; this.radioButton4.Location = new System.Drawing.Point(11, 8); this.radioButton4.Name = "radioButton4"; this.radioButton4.Size = new System.Drawing.Size(49, 17); this.radioButton4.TabIndex = 0; this.radioButton4.TabStop = true; this.radioButton4.Text = "P. U."; this.radioButton4.UseVisualStyleBackColor = true; this.radioButton4.CheckedChanged += new System.EventHandler(this.radioButton4_CheckedChanged); // // label13 // this.label13.AutoSize = true; this.label13.Location = new System.Drawing.Point(115, 155); this.label13.Name = "label13"; this.label13.Size = new System.Drawing.Size(22, 13); this.label13.TabIndex = 7; this.label13.Text = "N°:"; // // txtDiasr // this.txtDiasr.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dsCliente1, "cliente.diasr", true)); this.txtDiasr.Location = new System.Drawing.Point(140, 155); this.txtDiasr.MaxLength = 50; this.txtDiasr.Name = "txtDiasr"; this.txtDiasr.Size = new System.Drawing.Size(320, 20); this.txtDiasr.TabIndex = 6; this.txtDiasr.Text = "textBox1"; // // label5 // this.label5.AutoSize = true; this.label5.Location = new System.Drawing.Point(92, 122); this.label5.Name = "label5"; this.label5.Size = new System.Drawing.Size(45, 13); this.label5.TabIndex = 10; this.label5.Text = "Colonia:"; this.label5.TextAlign = System.Drawing.ContentAlignment.MiddleRight; // // txtColonia // this.txtColonia.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dsCliente1, "cliente.Colonia", true)); this.txtColonia.Location = new System.Drawing.Point(140, 122); this.txtColonia.MaxLength = 50; this.txtColonia.Name = "txtColonia"; this.txtColonia.Size = new System.Drawing.Size(320, 20); this.txtColonia.TabIndex = 9; this.txtColonia.Text = "textBox1"; // // label4 // this.label4.AutoSize = true; this.label4.Location = new System.Drawing.Point(84, 98); this.label4.Name = "label4"; this.label4.Size = new System.Drawing.Size(55, 13); this.label4.TabIndex = 8; this.label4.Text = "Dirección:"; this.label4.TextAlign = System.Drawing.ContentAlignment.MiddleRight; // // txtDirección // this.txtDirección.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dsCliente1, "cliente.Direccion", true)); this.txtDirección.Location = new System.Drawing.Point(140, 98); this.txtDirección.MaxLength = 50; this.txtDirección.Name = "txtDirección"; this.txtDirección.Size = new System.Drawing.Size(320, 20); this.txtDirección.TabIndex = 7; this.txtDirección.Text = "textBox1"; // // label2 // this.label2.AutoSize = true; this.label2.Location = new System.Drawing.Point(96, 64); this.label2.Name = "label2"; this.label2.Size = new System.Drawing.Size(42, 13); this.label2.TabIndex = 3; this.label2.Text = "Cliente:"; this.label2.TextAlign = System.Drawing.ContentAlignment.MiddleRight; // // txtCliente // this.txtCliente.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dsCliente1, "cliente.Cliente", true)); this.txtCliente.Location = new System.Drawing.Point(140, 64); this.txtCliente.MaxLength = 80; this.txtCliente.Multiline = true; this.txtCliente.Name = "txtCliente"; this.txtCliente.Size = new System.Drawing.Size(320, 32); this.txtCliente.TabIndex = 2; this.txtCliente.Text = "0123456789012345678901234567890123456789"; // // label1 // this.label1.AutoSize = true; this.label1.Location = new System.Drawing.Point(87, 24); this.label1.Name = "label1"; this.label1.Size = new System.Drawing.Size(51, 13); this.label1.TabIndex = 1; this.label1.Text = "IdCliente:"; this.label1.TextAlign = System.Drawing.ContentAlignment.MiddleRight; // // txtIdCliente // this.txtIdCliente.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dsCliente1, "cliente.IdCliente", true)); this.txtIdCliente.Location = new System.Drawing.Point(140, 24); this.txtIdCliente.MaxLength = 4; this.txtIdCliente.Name = "txtIdCliente"; this.txtIdCliente.Size = new System.Drawing.Size(32, 20); this.txtIdCliente.TabIndex = 0; this.txtIdCliente.Text = "textBox1"; // // sqlDACliente // this.sqlDACliente.DeleteCommand = this.sqlDeleteCommand1; this.sqlDACliente.InsertCommand = this.sqlInsertCommand1; this.sqlDACliente.SelectCommand = this.sqlSelectCommand1; this.sqlDACliente.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping("Table", "cliente", new System.Data.Common.DataColumnMapping[] { new System.Data.Common.DataColumnMapping("IdCliente", "IdCliente"), new System.Data.Common.DataColumnMapping("Cliente", "Cliente"), new System.Data.Common.DataColumnMapping("Direccion", "Direccion"), new System.Data.Common.DataColumnMapping("Colonia", "Colonia"), new System.Data.Common.DataColumnMapping("diasr", "diasr"), new System.Data.Common.DataColumnMapping("Pago", "Pago") }) }); this.sqlDACliente.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_IdCliente", System.Data.SqlDbType.NVarChar, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "IdCliente", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_Cliente", System.Data.SqlDbType.NVarChar, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Cliente", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_Direccion", System.Data.SqlDbType.NVarChar, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Direccion", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@IsNull_Colonia", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "Colonia", System.Data.DataRowVersion.Original, true, null, "", "", ""), new System.Data.SqlClient.SqlParameter("@Original_Colonia", System.Data.SqlDbType.NVarChar, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Colonia", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@IsNull_diasr", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "diasr", System.Data.DataRowVersion.Original, true, null, "", "", ""), new System.Data.SqlClient.SqlParameter("@Original_diasr", System.Data.SqlDbType.NVarChar, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "diasr", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@IsNull_Pago", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "Pago", System.Data.DataRowVersion.Original, true, null, "", "", ""), new System.Data.SqlClient.SqlParameter("@Original_Pago", System.Data.SqlDbType.SmallInt, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Pago", 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("@IdCliente", System.Data.SqlDbType.NVarChar, 0, "IdCliente"), new System.Data.SqlClient.SqlParameter("@Cliente", System.Data.SqlDbType.NVarChar, 0, "Cliente"), new System.Data.SqlClient.SqlParameter("@Direccion", System.Data.SqlDbType.NVarChar, 0, "Direccion"), new System.Data.SqlClient.SqlParameter("@Colonia", System.Data.SqlDbType.NVarChar, 0, "Colonia"), new System.Data.SqlClient.SqlParameter("@diasr", System.Data.SqlDbType.NVarChar, 0, "diasr"), new System.Data.SqlClient.SqlParameter("@Pago", System.Data.SqlDbType.SmallInt, 0, "Pago") }); // // sqlSelectCommand1 // this.sqlSelectCommand1.CommandText = "SELECT IdCliente, Cliente, Direccion, Colonia, diasr, Pago\r\nFROM " + " cliente"; 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("@IdCliente", System.Data.SqlDbType.NVarChar, 0, "IdCliente"), new System.Data.SqlClient.SqlParameter("@Cliente", System.Data.SqlDbType.NVarChar, 0, "Cliente"), new System.Data.SqlClient.SqlParameter("@Direccion", System.Data.SqlDbType.NVarChar, 0, "Direccion"), new System.Data.SqlClient.SqlParameter("@Colonia", System.Data.SqlDbType.NVarChar, 0, "Colonia"), new System.Data.SqlClient.SqlParameter("@diasr", System.Data.SqlDbType.NVarChar, 0, "diasr"), new System.Data.SqlClient.SqlParameter("@Pago", System.Data.SqlDbType.SmallInt, 0, "Pago"), new System.Data.SqlClient.SqlParameter("@Original_IdCliente", System.Data.SqlDbType.NVarChar, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "IdCliente", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_Cliente", System.Data.SqlDbType.NVarChar, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Cliente", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_Direccion", System.Data.SqlDbType.NVarChar, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Direccion", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@IsNull_Colonia", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "Colonia", System.Data.DataRowVersion.Original, true, null, "", "", ""), new System.Data.SqlClient.SqlParameter("@Original_Colonia", System.Data.SqlDbType.NVarChar, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Colonia", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@IsNull_diasr", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "diasr", System.Data.DataRowVersion.Original, true, null, "", "", ""), new System.Data.SqlClient.SqlParameter("@Original_diasr", System.Data.SqlDbType.NVarChar, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "diasr", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@IsNull_Pago", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "Pago", System.Data.DataRowVersion.Original, true, null, "", "", ""), new System.Data.SqlClient.SqlParameter("@Original_Pago", System.Data.SqlDbType.SmallInt, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Pago", System.Data.DataRowVersion.Original, null) }); // // sqlDABusCliente // this.sqlDABusCliente.SelectCommand = this.sqlSelectCommand2; this.sqlDABusCliente.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping("Table", "cliente", new System.Data.Common.DataColumnMapping[] { new System.Data.Common.DataColumnMapping("IdCliente", "IdCliente"), new System.Data.Common.DataColumnMapping("Cliente", "Cliente"), new System.Data.Common.DataColumnMapping("Direccion", "Direccion") }) }); // // sqlSelectCommand2 // this.sqlSelectCommand2.CommandText = "SELECT IdCliente, Cliente, Direccion FROM cliente"; this.sqlSelectCommand2.Connection = this.sqlConn; // // Cliente // this.AutoScaleBaseSize = new System.Drawing.Size(5, 13); this.ClientSize = new System.Drawing.Size(576, 331); this.Controls.Add(this.panel2); this.DAGeneral = this.sqlDACliente; this.dsGeneral = this.dsCliente1; this.Name = "Cliente"; this.NombreTabla = "cliente"; this.Text = "Cliente"; this.Load += new System.EventHandler(this.Cliente_Load); this.Controls.SetChildIndex(this.panel2, 0); this.Controls.SetChildIndex(this.statusBar1, 0); this.Controls.SetChildIndex(this.panelToolBar, 0); this.panelToolBar.ResumeLayout(false); this.panel2.ResumeLayout(false); this.panel2.PerformLayout(); ((System.ComponentModel.ISupportInitialize)(this.dsBusCliente1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.dsCliente1)).EndInit(); this.groupBox2.ResumeLayout(false); this.groupBox2.PerformLayout(); 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(Informes)); System.Configuration.AppSettingsReader configurationAppSettings = new System.Configuration.AppSettingsReader(); this.sqlDAInformes = 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.dsInformes1 = new LancNeo.dsInformes(); this.panel2 = new System.Windows.Forms.Panel(); this.buscaBtn1 = new Soluciones2000.Tools.WinLib.BuscaBtn(); this.txtcorto = new System.Windows.Forms.TextBox(); this.label3 = new System.Windows.Forms.Label(); this.txtInformes = new System.Windows.Forms.TextBox(); this.label2 = new System.Windows.Forms.Label(); this.txtIdInformes = new System.Windows.Forms.TextBox(); this.label1 = new System.Windows.Forms.Label(); this.panelToolBar.SuspendLayout(); ((System.ComponentModel.ISupportInitialize)(this.dsInformes1)).BeginInit(); this.panel2.SuspendLayout(); this.SuspendLayout(); // // statusBar1 // this.statusBar1.Location = new System.Drawing.Point(0, 263); this.statusBar1.ShowPanels = true; this.statusBar1.Size = new System.Drawing.Size(576, 22); // // panelToolBar // this.panelToolBar.Size = new System.Drawing.Size(576, 64); // // sqlDAInformes // this.sqlDAInformes.DeleteCommand = this.sqlDeleteCommand1; this.sqlDAInformes.InsertCommand = this.sqlInsertCommand1; this.sqlDAInformes.SelectCommand = this.sqlSelectCommand1; this.sqlDAInformes.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping("Table", "Informes", new System.Data.Common.DataColumnMapping[] { new System.Data.Common.DataColumnMapping("IdInforme", "IdInforme"), new System.Data.Common.DataColumnMapping("Informe", "Informe"), new System.Data.Common.DataColumnMapping("InformeCorto", "InformeCorto") }) }); this.sqlDAInformes.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_IdInforme", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "IdInforme", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_Informe", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Informe", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_InformeCorto", System.Data.SqlDbType.VarChar, 15, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "InformeCorto", 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("@IdInforme", System.Data.SqlDbType.VarChar, 10, "IdInforme"), new System.Data.SqlClient.SqlParameter("@Informe", System.Data.SqlDbType.VarChar, 50, "Informe"), new System.Data.SqlClient.SqlParameter("@InformeCorto", System.Data.SqlDbType.VarChar, 15, "InformeCorto") }); // // sqlSelectCommand1 // this.sqlSelectCommand1.CommandText = "SELECT IdInforme, Informe, InformeCorto FROM Informes ORDER BY IdInforme"; 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("@IdInforme", System.Data.SqlDbType.VarChar, 10, "IdInforme"), new System.Data.SqlClient.SqlParameter("@Informe", System.Data.SqlDbType.VarChar, 50, "Informe"), new System.Data.SqlClient.SqlParameter("@InformeCorto", System.Data.SqlDbType.VarChar, 15, "InformeCorto"), new System.Data.SqlClient.SqlParameter("@Original_IdInforme", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "IdInforme", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_Informe", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Informe", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_InformeCorto", System.Data.SqlDbType.VarChar, 15, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "InformeCorto", System.Data.DataRowVersion.Original, null) }); // // dsInformes1 // this.dsInformes1.DataSetName = "dsInformes"; this.dsInformes1.Locale = new System.Globalization.CultureInfo("es-MX"); this.dsInformes1.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema; // // panel2 // this.panel2.BorderStyle = System.Windows.Forms.BorderStyle.Fixed3D; this.panel2.Controls.Add(this.buscaBtn1); this.panel2.Controls.Add(this.txtcorto); this.panel2.Controls.Add(this.label3); this.panel2.Controls.Add(this.txtInformes); this.panel2.Controls.Add(this.label2); this.panel2.Controls.Add(this.txtIdInformes); this.panel2.Controls.Add(this.label1); this.panel2.Location = new System.Drawing.Point(8, 96); this.panel2.Name = "panel2"; this.panel2.Size = new System.Drawing.Size(528, 136); this.panel2.TabIndex = 4; // // buscaBtn1 // this.buscaBtn1.AnchoDlgBusq = 0; this.buscaBtn1.BackColor = System.Drawing.Color.Transparent; this.buscaBtn1.Datos = this.dsInformes1.Informes; this.buscaBtn1.Icon = ((System.Drawing.Icon)(resources.GetObject("buscaBtn1.Icon"))); this.buscaBtn1.Location = new System.Drawing.Point(176, 0); this.buscaBtn1.Name = "buscaBtn1"; this.buscaBtn1.Size = new System.Drawing.Size(64, 64); this.buscaBtn1.TabIndex = 54; this.toolTip1.SetToolTip(this.buscaBtn1, "Buscar"); // // txtcorto // this.txtcorto.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dsInformes1, "Informes.InformeCorto", true)); this.txtcorto.Location = new System.Drawing.Point(72, 104); this.txtcorto.Name = "txtcorto"; this.txtcorto.Size = new System.Drawing.Size(100, 20); this.txtcorto.TabIndex = 59; this.txtcorto.Text = "textBox1"; // // label3 // this.label3.AutoSize = true; this.label3.Location = new System.Drawing.Point(2, 104); this.label3.Name = "label3"; this.label3.Size = new System.Drawing.Size(68, 13); this.label3.TabIndex = 58; this.label3.Text = "Identificador:"; this.label3.TextAlign = System.Drawing.ContentAlignment.MiddleRight; // // txtInformes // this.txtInformes.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dsInformes1, "Informes.Informe", true)); this.txtInformes.Location = new System.Drawing.Point(72, 64); this.txtInformes.Name = "txtInformes"; this.txtInformes.Size = new System.Drawing.Size(336, 20); this.txtInformes.TabIndex = 57; this.txtInformes.Text = "textBox2"; // // label2 // this.label2.AutoSize = true; this.label2.Location = new System.Drawing.Point(25, 66); this.label2.Name = "label2"; this.label2.Size = new System.Drawing.Size(45, 13); this.label2.TabIndex = 56; this.label2.Text = "Informe:"; this.label2.TextAlign = System.Drawing.ContentAlignment.MiddleRight; // // txtIdInformes // this.txtIdInformes.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dsInformes1, "Informes.IdInforme", true)); this.txtIdInformes.Location = new System.Drawing.Point(72, 22); this.txtIdInformes.Name = "txtIdInformes"; this.txtIdInformes.Size = new System.Drawing.Size(100, 20); this.txtIdInformes.TabIndex = 55; this.txtIdInformes.Text = "textBox1"; // // label1 // this.label1.AutoSize = true; this.label1.Location = new System.Drawing.Point(16, 24); this.label1.Name = "label1"; this.label1.Size = new System.Drawing.Size(54, 13); this.label1.TabIndex = 53; this.label1.Text = "IdInforme:"; this.label1.TextAlign = System.Drawing.ContentAlignment.MiddleRight; // // Informes // this.AutoScaleBaseSize = new System.Drawing.Size(5, 13); this.ClientSize = new System.Drawing.Size(576, 285); this.Controls.Add(this.panel2); this.DAGeneral = this.sqlDAInformes; this.dsGeneral = this.dsInformes1; this.Name = "Informes"; this.NombreTabla = "Informes"; this.Text = "Informes"; this.Load += new System.EventHandler(this.Informes_Load); this.Controls.SetChildIndex(this.panel2, 0); this.Controls.SetChildIndex(this.statusBar1, 0); this.Controls.SetChildIndex(this.panelToolBar, 0); this.panelToolBar.ResumeLayout(false); ((System.ComponentModel.ISupportInitialize)(this.dsInformes1)).EndInit(); this.panel2.ResumeLayout(false); this.panel2.PerformLayout(); 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(Descarga)); System.Configuration.AppSettingsReader configurationAppSettings = new System.Configuration.AppSettingsReader(); this.panel1 = new System.Windows.Forms.Panel(); this.buscaBtn1 = new Soluciones2000.Tools.WinLib.BuscaBtn(); this.dsDescarga1 = new LancNeo.dsDescarga(); this.txtIdDescarga = new System.Windows.Forms.TextBox(); this.lblDescarga = new System.Windows.Forms.Label(); this.lblIdDescarga = new System.Windows.Forms.Label(); this.txtDescarga = new System.Windows.Forms.TextBox(); this.sqlDADescarga = 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.panelToolBar.SuspendLayout(); this.panel1.SuspendLayout(); ((System.ComponentModel.ISupportInitialize)(this.dsDescarga1)).BeginInit(); this.SuspendLayout(); // // statusBar1 // this.statusBar1.ShowPanels = true; this.statusBar1.Size = new System.Drawing.Size(576, 22); // // panelToolBar // this.panelToolBar.Size = new System.Drawing.Size(576, 64); // // panel1 // this.panel1.BorderStyle = System.Windows.Forms.BorderStyle.Fixed3D; this.panel1.Controls.Add(this.buscaBtn1); this.panel1.Controls.Add(this.txtIdDescarga); this.panel1.Controls.Add(this.lblDescarga); this.panel1.Controls.Add(this.lblIdDescarga); this.panel1.Controls.Add(this.txtDescarga); this.panel1.Location = new System.Drawing.Point(96, 123); this.panel1.Name = "panel1"; this.panel1.Size = new System.Drawing.Size(384, 176); this.panel1.TabIndex = 10; // // buscaBtn1 // this.buscaBtn1.AnchoDlgBusq = 0; this.buscaBtn1.BackColor = System.Drawing.Color.Transparent; this.buscaBtn1.Datos = this.dsDescarga1.Descarga; this.buscaBtn1.Icon = ((System.Drawing.Icon)(resources.GetObject("buscaBtn1.Icon"))); this.buscaBtn1.Location = new System.Drawing.Point(256, 16); this.buscaBtn1.Name = "buscaBtn1"; this.buscaBtn1.Size = new System.Drawing.Size(64, 64); this.buscaBtn1.TabIndex = 2; this.toolTip1.SetToolTip(this.buscaBtn1, "Buscar"); // // dsDescarga1 // this.dsDescarga1.DataSetName = "dsDescarga"; this.dsDescarga1.Locale = new System.Globalization.CultureInfo("es-MX"); this.dsDescarga1.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema; // // txtIdDescarga // this.txtIdDescarga.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dsDescarga1, "Descarga.IdDescarga", true)); this.txtIdDescarga.Location = new System.Drawing.Point(152, 48); this.txtIdDescarga.Name = "txtIdDescarga"; this.txtIdDescarga.Size = new System.Drawing.Size(100, 20); this.txtIdDescarga.TabIndex = 1; this.txtIdDescarga.Text = "textBox1"; // // lblDescarga // this.lblDescarga.Location = new System.Drawing.Point(40, 88); this.lblDescarga.Name = "lblDescarga"; this.lblDescarga.Size = new System.Drawing.Size(100, 23); this.lblDescarga.TabIndex = 0; this.lblDescarga.Text = "Descarga:"; this.lblDescarga.TextAlign = System.Drawing.ContentAlignment.MiddleRight; // // lblIdDescarga // this.lblIdDescarga.Location = new System.Drawing.Point(40, 48); this.lblIdDescarga.Name = "lblIdDescarga"; this.lblIdDescarga.Size = new System.Drawing.Size(100, 23); this.lblIdDescarga.TabIndex = 0; this.lblIdDescarga.Text = "Id Descarga:"; this.lblIdDescarga.TextAlign = System.Drawing.ContentAlignment.MiddleRight; // // txtDescarga // this.txtDescarga.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dsDescarga1, "Descarga.Descarga", true)); this.txtDescarga.Location = new System.Drawing.Point(152, 88); this.txtDescarga.Name = "txtDescarga"; this.txtDescarga.Size = new System.Drawing.Size(216, 20); this.txtDescarga.TabIndex = 1; this.txtDescarga.Text = "textBox1"; // // sqlDADescarga // this.sqlDADescarga.DeleteCommand = this.sqlDeleteCommand1; this.sqlDADescarga.InsertCommand = this.sqlInsertCommand1; this.sqlDADescarga.SelectCommand = this.sqlSelectCommand1; this.sqlDADescarga.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping("Table", "Descarga", new System.Data.Common.DataColumnMapping[] { new System.Data.Common.DataColumnMapping("IdDescarga", "IdDescarga"), new System.Data.Common.DataColumnMapping("Descarga", "Descarga") }) }); this.sqlDADescarga.UpdateCommand = this.sqlUpdateCommand1; // // sqlDeleteCommand1 // this.sqlDeleteCommand1.CommandText = "DELETE FROM Descarga WHERE (IdDescarga = @Original_IdDescarga) AND (Descarga = @O" + "riginal_Descarga)"; this.sqlDeleteCommand1.Connection = this.sqlConn; this.sqlDeleteCommand1.Parameters.AddRange(new System.Data.SqlClient.SqlParameter[] { new System.Data.SqlClient.SqlParameter("@Original_IdDescarga", System.Data.SqlDbType.SmallInt, 2, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "IdDescarga", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_Descarga", System.Data.SqlDbType.NVarChar, 20, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Descarga", System.Data.DataRowVersion.Original, null) }); // // sqlConn // this.sqlConn.ConnectionString = ((string)(configurationAppSettings.GetValue("sqlConn.ConnectionString", typeof(string)))); this.sqlConn.FireInfoMessageEventOnUserErrors = false; // // sqlInsertCommand1 // this.sqlInsertCommand1.CommandText = "INSERT INTO Descarga(IdDescarga, Descarga) VALUES (@IdDescarga, @Descarga); SELEC" + "T IdDescarga, Descarga FROM Descarga WHERE (IdDescarga = @IdDescarga)"; this.sqlInsertCommand1.Connection = this.sqlConn; this.sqlInsertCommand1.Parameters.AddRange(new System.Data.SqlClient.SqlParameter[] { new System.Data.SqlClient.SqlParameter("@IdDescarga", System.Data.SqlDbType.SmallInt, 2, "IdDescarga"), new System.Data.SqlClient.SqlParameter("@Descarga", System.Data.SqlDbType.NVarChar, 20, "Descarga") }); // // sqlSelectCommand1 // this.sqlSelectCommand1.CommandText = "SELECT IdDescarga, Descarga FROM Descarga"; 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("@IdDescarga", System.Data.SqlDbType.SmallInt, 2, "IdDescarga"), new System.Data.SqlClient.SqlParameter("@Descarga", System.Data.SqlDbType.NVarChar, 20, "Descarga"), new System.Data.SqlClient.SqlParameter("@Original_IdDescarga", System.Data.SqlDbType.SmallInt, 2, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "IdDescarga", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_Descarga", System.Data.SqlDbType.NVarChar, 20, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Descarga", System.Data.DataRowVersion.Original, null) }); // // Descarga // this.AutoScaleBaseSize = new System.Drawing.Size(5, 13); this.ClientSize = new System.Drawing.Size(576, 423); this.Controls.Add(this.panel1); this.DAGeneral = this.sqlDADescarga; this.dsGeneral = this.dsDescarga1; this.Name = "Descarga"; this.NombreTabla = "Descarga"; this.Text = "Descarga"; this.Load += new System.EventHandler(this.Descarga_Load); this.Controls.SetChildIndex(this.panel1, 0); this.Controls.SetChildIndex(this.statusBar1, 0); this.Controls.SetChildIndex(this.panelToolBar, 0); this.panelToolBar.ResumeLayout(false); this.panel1.ResumeLayout(false); this.panel1.PerformLayout(); ((System.ComponentModel.ISupportInitialize)(this.dsDescarga1)).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(Grado)); System.Configuration.AppSettingsReader configurationAppSettings = new System.Configuration.AppSettingsReader(); this.sqlDAGrado = 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.lblGrado = new System.Windows.Forms.Label(); this.lblPorcentaje = new System.Windows.Forms.Label(); this.lblPruebas = new System.Windows.Forms.Label(); this.lblPorPromedio = new System.Windows.Forms.Label(); this.lblConsecutivo = new System.Windows.Forms.Label(); this.lblConstante = new System.Windows.Forms.Label(); this.panel1 = new System.Windows.Forms.Panel(); this.buscaBtn1 = new Soluciones2000.Tools.WinLib.BuscaBtn(); this.dsGrado1 = new LancNeo.dsGrado(); this.txtConstante = new System.Windows.Forms.TextBox(); this.txtConsecutivo = new System.Windows.Forms.TextBox(); this.txtPorPromedio = new System.Windows.Forms.TextBox(); this.txtPruebas = new System.Windows.Forms.TextBox(); this.txtPorcentaje = new System.Windows.Forms.TextBox(); this.txtGrado = new System.Windows.Forms.TextBox(); this.panelToolBar.SuspendLayout(); this.panel1.SuspendLayout(); ((System.ComponentModel.ISupportInitialize)(this.dsGrado1)).BeginInit(); this.SuspendLayout(); // // statusBar1 // this.statusBar1.ShowPanels = true; this.statusBar1.Size = new System.Drawing.Size(576, 22); // // panelToolBar // this.panelToolBar.Size = new System.Drawing.Size(576, 64); // // sqlDAGrado // this.sqlDAGrado.DeleteCommand = this.sqlDeleteCommand1; this.sqlDAGrado.InsertCommand = this.sqlInsertCommand1; this.sqlDAGrado.SelectCommand = this.sqlSelectCommand1; this.sqlDAGrado.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping("Table", "Grado", new System.Data.Common.DataColumnMapping[] { new System.Data.Common.DataColumnMapping("Grado", "Grado"), new System.Data.Common.DataColumnMapping("Porcentaje", "Porcentaje"), new System.Data.Common.DataColumnMapping("Pruebas", "Pruebas"), new System.Data.Common.DataColumnMapping("Porpromedio", "Porpromedio"), new System.Data.Common.DataColumnMapping("Consecutivo", "Consecutivo"), new System.Data.Common.DataColumnMapping("Constante", "Constante") }) }); this.sqlDAGrado.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_Grado", System.Data.SqlDbType.NVarChar, 1, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Grado", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_Consecutivo", System.Data.SqlDbType.SmallInt, 2, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Consecutivo", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_Constante", System.Data.SqlDbType.Real, 4, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Constante", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_Porcentaje", System.Data.SqlDbType.Real, 4, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Porcentaje", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_Porpromedio", System.Data.SqlDbType.Real, 4, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Porpromedio", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_Pruebas", System.Data.SqlDbType.SmallInt, 2, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Pruebas", 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("@Grado", System.Data.SqlDbType.NVarChar, 1, "Grado"), new System.Data.SqlClient.SqlParameter("@Porcentaje", System.Data.SqlDbType.Real, 4, "Porcentaje"), new System.Data.SqlClient.SqlParameter("@Pruebas", System.Data.SqlDbType.SmallInt, 2, "Pruebas"), new System.Data.SqlClient.SqlParameter("@Porpromedio", System.Data.SqlDbType.Real, 4, "Porpromedio"), new System.Data.SqlClient.SqlParameter("@Consecutivo", System.Data.SqlDbType.SmallInt, 2, "Consecutivo"), new System.Data.SqlClient.SqlParameter("@Constante", System.Data.SqlDbType.Real, 4, "Constante") }); // // sqlSelectCommand1 // this.sqlSelectCommand1.CommandText = "SELECT Grado, Porcentaje, Pruebas, Porpromedio, Consecutivo, Constante FROM Grado" + ""; 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("@Grado", System.Data.SqlDbType.NVarChar, 1, "Grado"), new System.Data.SqlClient.SqlParameter("@Porcentaje", System.Data.SqlDbType.Real, 4, "Porcentaje"), new System.Data.SqlClient.SqlParameter("@Pruebas", System.Data.SqlDbType.SmallInt, 2, "Pruebas"), new System.Data.SqlClient.SqlParameter("@Porpromedio", System.Data.SqlDbType.Real, 4, "Porpromedio"), new System.Data.SqlClient.SqlParameter("@Consecutivo", System.Data.SqlDbType.SmallInt, 2, "Consecutivo"), new System.Data.SqlClient.SqlParameter("@Constante", System.Data.SqlDbType.Real, 4, "Constante"), new System.Data.SqlClient.SqlParameter("@Original_Grado", System.Data.SqlDbType.NVarChar, 1, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Grado", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_Consecutivo", System.Data.SqlDbType.SmallInt, 2, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Consecutivo", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_Constante", System.Data.SqlDbType.Real, 4, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Constante", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_Porcentaje", System.Data.SqlDbType.Real, 4, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Porcentaje", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_Porpromedio", System.Data.SqlDbType.Real, 4, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Porpromedio", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_Pruebas", System.Data.SqlDbType.SmallInt, 2, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Pruebas", System.Data.DataRowVersion.Original, null) }); // // lblGrado // this.lblGrado.Location = new System.Drawing.Point(88, 24); this.lblGrado.Name = "lblGrado"; this.lblGrado.Size = new System.Drawing.Size(152, 23); this.lblGrado.TabIndex = 3; this.lblGrado.Text = "Grado:"; this.lblGrado.TextAlign = System.Drawing.ContentAlignment.MiddleRight; // // lblPorcentaje // this.lblPorcentaje.Location = new System.Drawing.Point(88, 64); this.lblPorcentaje.Name = "lblPorcentaje"; this.lblPorcentaje.Size = new System.Drawing.Size(152, 23); this.lblPorcentaje.TabIndex = 4; this.lblPorcentaje.Text = "Porcentaje máximo de error:"; this.lblPorcentaje.TextAlign = System.Drawing.ContentAlignment.MiddleRight; // // lblPruebas // this.lblPruebas.Location = new System.Drawing.Point(88, 104); this.lblPruebas.Name = "lblPruebas"; this.lblPruebas.Size = new System.Drawing.Size(152, 23); this.lblPruebas.TabIndex = 5; this.lblPruebas.Text = "Mínimo de pruebas:"; this.lblPruebas.TextAlign = System.Drawing.ContentAlignment.MiddleRight; // // lblPorPromedio // this.lblPorPromedio.Location = new System.Drawing.Point(88, 144); this.lblPorPromedio.Name = "lblPorPromedio"; this.lblPorPromedio.Size = new System.Drawing.Size(152, 23); this.lblPorPromedio.TabIndex = 6; this.lblPorPromedio.Text = "Porcentaje máximo de error promedio:"; this.lblPorPromedio.TextAlign = System.Drawing.ContentAlignment.MiddleRight; // // lblConsecutivo // this.lblConsecutivo.Location = new System.Drawing.Point(88, 176); this.lblConsecutivo.Name = "lblConsecutivo"; this.lblConsecutivo.Size = new System.Drawing.Size(152, 23); this.lblConsecutivo.TabIndex = 7; this.lblConsecutivo.Text = "Número consecutivo:"; this.lblConsecutivo.TextAlign = System.Drawing.ContentAlignment.MiddleRight; // // lblConstante // this.lblConstante.Location = new System.Drawing.Point(88, 216); this.lblConstante.Name = "lblConstante"; this.lblConstante.Size = new System.Drawing.Size(152, 23); this.lblConstante.TabIndex = 8; this.lblConstante.Text = "Constante:"; this.lblConstante.TextAlign = System.Drawing.ContentAlignment.MiddleRight; // // panel1 // this.panel1.BorderStyle = System.Windows.Forms.BorderStyle.Fixed3D; this.panel1.Controls.Add(this.buscaBtn1); this.panel1.Controls.Add(this.txtConstante); this.panel1.Controls.Add(this.txtConsecutivo); this.panel1.Controls.Add(this.txtPorPromedio); this.panel1.Controls.Add(this.txtPruebas); this.panel1.Controls.Add(this.txtPorcentaje); this.panel1.Controls.Add(this.txtGrado); this.panel1.Controls.Add(this.lblPorcentaje); this.panel1.Controls.Add(this.lblConsecutivo); this.panel1.Controls.Add(this.lblPorPromedio); this.panel1.Controls.Add(this.lblConstante); this.panel1.Controls.Add(this.lblPruebas); this.panel1.Controls.Add(this.lblGrado); this.panel1.Location = new System.Drawing.Point(72, 96); this.panel1.Name = "panel1"; this.panel1.Size = new System.Drawing.Size(440, 256); this.panel1.TabIndex = 9; // // buscaBtn1 // this.buscaBtn1.AnchoDlgBusq = 0; this.buscaBtn1.BackColor = System.Drawing.Color.Transparent; this.buscaBtn1.Datos = this.dsGrado1.Grado; this.buscaBtn1.Icon = ((System.Drawing.Icon)(resources.GetObject("buscaBtn1.Icon"))); this.buscaBtn1.Location = new System.Drawing.Point(320, 0); this.buscaBtn1.Name = "buscaBtn1"; this.buscaBtn1.Size = new System.Drawing.Size(64, 64); this.buscaBtn1.TabIndex = 15; this.toolTip1.SetToolTip(this.buscaBtn1, "Buscar"); // // dsGrado1 // this.dsGrado1.DataSetName = "dsGrado"; this.dsGrado1.Locale = new System.Globalization.CultureInfo("es-MX"); this.dsGrado1.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema; // // txtConstante // this.txtConstante.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dsGrado1, "Grado.Constante", true)); this.txtConstante.Location = new System.Drawing.Point(248, 216); this.txtConstante.Name = "txtConstante"; this.txtConstante.Size = new System.Drawing.Size(64, 20); this.txtConstante.TabIndex = 14; this.txtConstante.Text = "textBox6"; // // txtConsecutivo // this.txtConsecutivo.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dsGrado1, "Grado.Consecutivo", true)); this.txtConsecutivo.Location = new System.Drawing.Point(248, 176); this.txtConsecutivo.Name = "txtConsecutivo"; this.txtConsecutivo.Size = new System.Drawing.Size(64, 20); this.txtConsecutivo.TabIndex = 13; this.txtConsecutivo.Text = "textBox5"; // // txtPorPromedio // this.txtPorPromedio.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dsGrado1, "Grado.Porpromedio", true)); this.txtPorPromedio.Location = new System.Drawing.Point(248, 136); this.txtPorPromedio.Name = "txtPorPromedio"; this.txtPorPromedio.Size = new System.Drawing.Size(64, 20); this.txtPorPromedio.TabIndex = 12; this.txtPorPromedio.Text = "textBox4"; // // txtPruebas // this.txtPruebas.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dsGrado1, "Grado.Pruebas", true)); this.txtPruebas.Location = new System.Drawing.Point(248, 104); this.txtPruebas.Name = "txtPruebas"; this.txtPruebas.Size = new System.Drawing.Size(64, 20); this.txtPruebas.TabIndex = 11; this.txtPruebas.Text = "textBox3"; // // txtPorcentaje // this.txtPorcentaje.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dsGrado1, "Grado.Porcentaje", true)); this.txtPorcentaje.Location = new System.Drawing.Point(248, 64); this.txtPorcentaje.Name = "txtPorcentaje"; this.txtPorcentaje.Size = new System.Drawing.Size(64, 20); this.txtPorcentaje.TabIndex = 10; this.txtPorcentaje.Text = "textBox2"; // // txtGrado // this.txtGrado.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dsGrado1, "Grado.Grado", true)); this.txtGrado.Location = new System.Drawing.Point(248, 24); this.txtGrado.Name = "txtGrado"; this.txtGrado.Size = new System.Drawing.Size(64, 20); this.txtGrado.TabIndex = 9; this.txtGrado.Text = "textBox1"; // // Grado // this.AutoScaleBaseSize = new System.Drawing.Size(5, 13); this.ClientSize = new System.Drawing.Size(576, 423); this.Controls.Add(this.panel1); this.DAGeneral = this.sqlDAGrado; this.dsGeneral = this.dsGrado1; this.Name = "Grado"; this.NombreTabla = "Grado"; this.Text = "Grado"; this.Load += new System.EventHandler(this.Grado_Load); this.Controls.SetChildIndex(this.statusBar1, 0); this.Controls.SetChildIndex(this.panelToolBar, 0); this.Controls.SetChildIndex(this.panel1, 0); this.panelToolBar.ResumeLayout(false); this.panel1.ResumeLayout(false); this.panel1.PerformLayout(); ((System.ComponentModel.ISupportInitialize)(this.dsGrado1)).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(Valoresfp)); System.Configuration.AppSettingsReader configurationAppSettings = new System.Configuration.AppSettingsReader(); this.panel2 = new System.Windows.Forms.Panel(); this.buscaBtn1 = new Soluciones2000.Tools.WinLib.BuscaBtn(); this.dsValoresfp1 = new LancNeo.dsValoresfp(); this.cmbGrado = new System.Windows.Forms.ComboBox(); this.txtConsecutivo = new System.Windows.Forms.TextBox(); this.lblConsecutivo = new System.Windows.Forms.Label(); this.lblGrado = new System.Windows.Forms.Label(); this.lblResistenciaMPa = new System.Windows.Forms.Label(); this.lblResistenciaKg = new System.Windows.Forms.Label(); this.txtResistenciaMPa = new System.Windows.Forms.TextBox(); this.txtResistenciaKg = new System.Windows.Forms.TextBox(); this.label1 = new System.Windows.Forms.Label(); this.label2 = new System.Windows.Forms.Label(); this.sqlDAValoresfp = 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.panelToolBar.SuspendLayout(); this.panel2.SuspendLayout(); ((System.ComponentModel.ISupportInitialize)(this.dsValoresfp1)).BeginInit(); this.SuspendLayout(); // // statusBar1 // this.statusBar1.ShowPanels = true; this.statusBar1.Size = new System.Drawing.Size(576, 22); // // panelToolBar // this.panelToolBar.Size = new System.Drawing.Size(576, 64); // // panel2 // this.panel2.BorderStyle = System.Windows.Forms.BorderStyle.Fixed3D; this.panel2.Controls.Add(this.buscaBtn1); this.panel2.Controls.Add(this.cmbGrado); this.panel2.Controls.Add(this.txtConsecutivo); this.panel2.Controls.Add(this.lblConsecutivo); this.panel2.Controls.Add(this.lblGrado); this.panel2.Controls.Add(this.lblResistenciaMPa); this.panel2.Controls.Add(this.lblResistenciaKg); this.panel2.Controls.Add(this.txtResistenciaMPa); this.panel2.Controls.Add(this.txtResistenciaKg); this.panel2.Controls.Add(this.label1); this.panel2.Controls.Add(this.label2); this.panel2.Location = new System.Drawing.Point(72, 87); this.panel2.Name = "panel2"; this.panel2.Size = new System.Drawing.Size(432, 248); this.panel2.TabIndex = 4; // // buscaBtn1 // this.buscaBtn1.AnchoDlgBusq = 0; this.buscaBtn1.BackColor = System.Drawing.Color.Transparent; this.buscaBtn1.Datos = this.dsValoresfp1.ValoresFp; this.buscaBtn1.Icon = ((System.Drawing.Icon)(resources.GetObject("buscaBtn1.Icon"))); this.buscaBtn1.Location = new System.Drawing.Point(288, 24); this.buscaBtn1.Name = "buscaBtn1"; this.buscaBtn1.Size = new System.Drawing.Size(64, 64); this.buscaBtn1.TabIndex = 3; this.toolTip1.SetToolTip(this.buscaBtn1, "Buscar"); // // dsValoresfp1 // this.dsValoresfp1.DataSetName = "dsValoresfp"; this.dsValoresfp1.Locale = new System.Globalization.CultureInfo("es-MX"); this.dsValoresfp1.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema; // // cmbGrado // this.cmbGrado.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dsValoresfp1, "ValoresFp.Grado", true)); this.cmbGrado.Location = new System.Drawing.Point(184, 95); this.cmbGrado.Name = "cmbGrado"; this.cmbGrado.Size = new System.Drawing.Size(121, 21); this.cmbGrado.TabIndex = 2; this.cmbGrado.Text = "comboBox1"; // // txtConsecutivo // this.txtConsecutivo.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dsValoresfp1, "ValoresFp.Consecutivo", true)); this.txtConsecutivo.Location = new System.Drawing.Point(184, 63); this.txtConsecutivo.Name = "txtConsecutivo"; this.txtConsecutivo.Size = new System.Drawing.Size(100, 20); this.txtConsecutivo.TabIndex = 1; this.txtConsecutivo.Text = "textBox1"; // // lblConsecutivo // this.lblConsecutivo.Location = new System.Drawing.Point(107, 63); this.lblConsecutivo.Name = "lblConsecutivo"; this.lblConsecutivo.Size = new System.Drawing.Size(72, 23); this.lblConsecutivo.TabIndex = 0; this.lblConsecutivo.Text = "Consecutivo:"; this.lblConsecutivo.TextAlign = System.Drawing.ContentAlignment.MiddleRight; // // lblGrado // this.lblGrado.Location = new System.Drawing.Point(107, 95); this.lblGrado.Name = "lblGrado"; this.lblGrado.Size = new System.Drawing.Size(72, 23); this.lblGrado.TabIndex = 0; this.lblGrado.Text = "Grado:"; this.lblGrado.TextAlign = System.Drawing.ContentAlignment.MiddleRight; // // lblResistenciaMPa // this.lblResistenciaMPa.Location = new System.Drawing.Point(107, 127); this.lblResistenciaMPa.Name = "lblResistenciaMPa"; this.lblResistenciaMPa.Size = new System.Drawing.Size(72, 23); this.lblResistenciaMPa.TabIndex = 0; this.lblResistenciaMPa.Text = "Resistencia:"; this.lblResistenciaMPa.TextAlign = System.Drawing.ContentAlignment.MiddleRight; // // lblResistenciaKg // this.lblResistenciaKg.Location = new System.Drawing.Point(107, 159); this.lblResistenciaKg.Name = "lblResistenciaKg"; this.lblResistenciaKg.Size = new System.Drawing.Size(72, 23); this.lblResistenciaKg.TabIndex = 0; this.lblResistenciaKg.Text = "Resistencia:"; this.lblResistenciaKg.TextAlign = System.Drawing.ContentAlignment.MiddleRight; // // txtResistenciaMPa // this.txtResistenciaMPa.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dsValoresfp1, "ValoresFp.ResistenciaMPa", true)); this.txtResistenciaMPa.Location = new System.Drawing.Point(184, 127); this.txtResistenciaMPa.Name = "txtResistenciaMPa"; this.txtResistenciaMPa.Size = new System.Drawing.Size(100, 20); this.txtResistenciaMPa.TabIndex = 1; this.txtResistenciaMPa.Text = "textBox1"; // // txtResistenciaKg // this.txtResistenciaKg.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dsValoresfp1, "ValoresFp.ResistenciaKg", true)); this.txtResistenciaKg.Location = new System.Drawing.Point(184, 159); this.txtResistenciaKg.Name = "txtResistenciaKg"; this.txtResistenciaKg.Size = new System.Drawing.Size(100, 20); this.txtResistenciaKg.TabIndex = 1; this.txtResistenciaKg.Text = "textBox1"; // // label1 // this.label1.Location = new System.Drawing.Point(288, 128); this.label1.Name = "label1"; this.label1.Size = new System.Drawing.Size(40, 23); this.label1.TabIndex = 0; this.label1.Text = "MPa"; this.label1.TextAlign = System.Drawing.ContentAlignment.MiddleLeft; // // label2 // this.label2.Location = new System.Drawing.Point(288, 160); this.label2.Name = "label2"; this.label2.Size = new System.Drawing.Size(72, 23); this.label2.TabIndex = 0; this.label2.Text = "Kg/cm ²"; this.label2.TextAlign = System.Drawing.ContentAlignment.MiddleLeft; // // sqlDAValoresfp // this.sqlDAValoresfp.DeleteCommand = this.sqlDeleteCommand1; this.sqlDAValoresfp.InsertCommand = this.sqlInsertCommand1; this.sqlDAValoresfp.SelectCommand = this.sqlSelectCommand1; this.sqlDAValoresfp.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping("Table", "ValoresFp", new System.Data.Common.DataColumnMapping[] { new System.Data.Common.DataColumnMapping("Consecutivo", "Consecutivo"), new System.Data.Common.DataColumnMapping("Grado", "Grado"), new System.Data.Common.DataColumnMapping("ResistenciaMPa", "ResistenciaMPa"), new System.Data.Common.DataColumnMapping("ResistenciaKg", "ResistenciaKg") }) }); this.sqlDAValoresfp.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_Consecutivo", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Consecutivo", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_Grado", System.Data.SqlDbType.NVarChar, 1, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Grado", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_ResistenciaKg", System.Data.SqlDbType.Real, 4, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "ResistenciaKg", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_ResistenciaMPa", System.Data.SqlDbType.Real, 4, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "ResistenciaMPa", 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("@Consecutivo", System.Data.SqlDbType.Int, 4, "Consecutivo"), new System.Data.SqlClient.SqlParameter("@Grado", System.Data.SqlDbType.NVarChar, 1, "Grado"), new System.Data.SqlClient.SqlParameter("@ResistenciaMPa", System.Data.SqlDbType.Real, 4, "ResistenciaMPa"), new System.Data.SqlClient.SqlParameter("@ResistenciaKg", System.Data.SqlDbType.Real, 4, "ResistenciaKg") }); // // sqlSelectCommand1 // this.sqlSelectCommand1.CommandText = "SELECT Consecutivo, Grado, ResistenciaMPa, ResistenciaKg FROM ValoresFp ORDER BY " + "Consecutivo"; 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("@Consecutivo", System.Data.SqlDbType.Int, 4, "Consecutivo"), new System.Data.SqlClient.SqlParameter("@Grado", System.Data.SqlDbType.NVarChar, 1, "Grado"), new System.Data.SqlClient.SqlParameter("@ResistenciaMPa", System.Data.SqlDbType.Real, 4, "ResistenciaMPa"), new System.Data.SqlClient.SqlParameter("@ResistenciaKg", System.Data.SqlDbType.Real, 4, "ResistenciaKg"), new System.Data.SqlClient.SqlParameter("@Original_Consecutivo", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Consecutivo", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_Grado", System.Data.SqlDbType.NVarChar, 1, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Grado", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_ResistenciaKg", System.Data.SqlDbType.Real, 4, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "ResistenciaKg", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_ResistenciaMPa", System.Data.SqlDbType.Real, 4, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "ResistenciaMPa", System.Data.DataRowVersion.Original, null) }); // // Valoresfp // this.AutoScaleBaseSize = new System.Drawing.Size(5, 13); this.ClientSize = new System.Drawing.Size(576, 423); this.Controls.Add(this.panel2); this.DAGeneral = this.sqlDAValoresfp; this.dsGeneral = this.dsValoresfp1; this.Name = "Valoresfp"; this.NombreTabla = "Valoresfp"; this.Text = "Tabla de Valores fp mínimos"; this.Load += new System.EventHandler(this.Valoresfp_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.dsValoresfp1)).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(Cemento)); System.Configuration.AppSettingsReader configurationAppSettings = new System.Configuration.AppSettingsReader(); this.panel2 = new System.Windows.Forms.Panel(); this.buscaBtn1 = new Soluciones2000.Tools.WinLib.BuscaBtn(); this.dtpHri = new System.Windows.Forms.DateTimePicker(); this.dsCemento = new LancNeo.dsCemento(); this.Cementolbl = new System.Windows.Forms.Label(); this.Fecha = new System.Windows.Forms.Label(); this.txtNombre = new System.Windows.Forms.TextBox(); this.IdObra = new System.Windows.Forms.Label(); this.txtIdObra = new System.Windows.Forms.TextBox(); this.sqlConn = new System.Data.SqlClient.SqlConnection(); this.sqlSelectCommand1 = new System.Data.SqlClient.SqlCommand(); this.sqlInsertCommand1 = new System.Data.SqlClient.SqlCommand(); this.sqlUpdateCommand1 = new System.Data.SqlClient.SqlCommand(); this.sqlDeleteCommand1 = new System.Data.SqlClient.SqlCommand(); this.sqlDACemento = new System.Data.SqlClient.SqlDataAdapter(); this.sqlDABusObra = new System.Data.SqlClient.SqlDataAdapter(); this.sqlCommand1 = new System.Data.SqlClient.SqlCommand(); this.dsBusObra1 = new LancNeo.dsBusObra(); this.panelToolBar.SuspendLayout(); this.panel2.SuspendLayout(); ((System.ComponentModel.ISupportInitialize)(this.dsCemento)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.dsBusObra1)).BeginInit(); this.SuspendLayout(); // // statusBar1 // this.statusBar1.Location = new System.Drawing.Point(0, 267); this.statusBar1.ShowPanels = true; this.statusBar1.Size = new System.Drawing.Size(648, 22); // // panelToolBar // this.panelToolBar.Size = new System.Drawing.Size(648, 64); // // panel2 // this.panel2.BorderStyle = System.Windows.Forms.BorderStyle.Fixed3D; this.panel2.Controls.Add(this.buscaBtn1); this.panel2.Controls.Add(this.dtpHri); this.panel2.Controls.Add(this.Cementolbl); this.panel2.Controls.Add(this.Fecha); this.panel2.Controls.Add(this.txtNombre); this.panel2.Controls.Add(this.IdObra); this.panel2.Controls.Add(this.txtIdObra); this.panel2.Location = new System.Drawing.Point(40, 80); this.panel2.Name = "panel2"; this.panel2.Size = new System.Drawing.Size(552, 176); this.panel2.TabIndex = 5; // // buscaBtn1 // this.buscaBtn1.AnchoDlgBusq = 0; this.buscaBtn1.BackColor = System.Drawing.Color.Transparent; this.buscaBtn1.Datos = this.dsCemento.Cemento; this.buscaBtn1.Icon = ((System.Drawing.Icon)(resources.GetObject("buscaBtn1.Icon"))); this.buscaBtn1.Location = new System.Drawing.Point(357, 12); this.buscaBtn1.Name = "buscaBtn1"; this.buscaBtn1.Size = new System.Drawing.Size(64, 64); this.buscaBtn1.TabIndex = 8; this.buscaBtn1.Load += new System.EventHandler(this.buscaBtn1_Load); // // dtpHri // this.dtpHri.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dsCemento, "Cemento.Fecha", true)); this.dtpHri.Format = System.Windows.Forms.DateTimePickerFormat.Short; this.dtpHri.Location = new System.Drawing.Point(176, 56); this.dtpHri.Name = "dtpHri"; this.dtpHri.Size = new System.Drawing.Size(88, 20); this.dtpHri.TabIndex = 9; this.dtpHri.ValueChanged += new System.EventHandler(this.dtpHri_ValueChanged); // // dsCemento // this.dsCemento.DataSetName = "dsCemento"; this.dsCemento.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema; // // Cementolbl // this.Cementolbl.AutoSize = true; this.Cementolbl.Location = new System.Drawing.Point(112, 88); this.Cementolbl.Name = "Cementolbl"; this.Cementolbl.Size = new System.Drawing.Size(52, 13); this.Cementolbl.TabIndex = 5; this.Cementolbl.Text = "Cemento:"; // // Fecha // this.Fecha.AutoSize = true; this.Fecha.Location = new System.Drawing.Point(112, 56); this.Fecha.Name = "Fecha"; this.Fecha.Size = new System.Drawing.Size(40, 13); this.Fecha.TabIndex = 3; this.Fecha.Text = "Fecha:"; // // txtNombre // this.txtNombre.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dsCemento, "Cemento.Cemento", true)); this.txtNombre.Location = new System.Drawing.Point(176, 88); this.txtNombre.MaxLength = 20; this.txtNombre.Name = "txtNombre"; this.txtNombre.Size = new System.Drawing.Size(168, 20); this.txtNombre.TabIndex = 2; // // IdObra // this.IdObra.AutoSize = true; this.IdObra.Location = new System.Drawing.Point(112, 24); this.IdObra.Name = "IdObra"; this.IdObra.Size = new System.Drawing.Size(42, 13); this.IdObra.TabIndex = 1; this.IdObra.Text = "IdObra:"; // // txtIdObra // this.txtIdObra.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dsCemento, "Cemento.IdObra", true)); this.txtIdObra.Location = new System.Drawing.Point(176, 24); this.txtIdObra.Name = "txtIdObra"; this.txtIdObra.Size = new System.Drawing.Size(100, 20); this.txtIdObra.TabIndex = 0; // // sqlConn // this.sqlConn.ConnectionString = ((string)(configurationAppSettings.GetValue("sqlConn.ConnectionString", typeof(string)))); this.sqlConn.FireInfoMessageEventOnUserErrors = false; // // sqlSelectCommand1 // this.sqlSelectCommand1.CommandText = "SELECT IdObra, Fecha, Cemento\r\nFROM Cemento\r\nORDER BY IdObra"; this.sqlSelectCommand1.Connection = this.sqlConn; // // sqlInsertCommand1 // this.sqlInsertCommand1.CommandText = "INSERT INTO [Cemento] ([IdObra], [Fecha], [Cemento]) VALUES (@IdObra, @Fecha, @Ce" + "mento);\r\nSELECT IdObra, Fecha, Cemento FROM Cemento WHERE (Fecha = @Fecha) AND (" + "IdObra = @IdObra) ORDER BY IdObra"; this.sqlInsertCommand1.Connection = this.sqlConn; this.sqlInsertCommand1.Parameters.AddRange(new System.Data.SqlClient.SqlParameter[] { new System.Data.SqlClient.SqlParameter("@IdObra", System.Data.SqlDbType.NVarChar, 0, "IdObra"), new System.Data.SqlClient.SqlParameter("@Fecha", System.Data.SqlDbType.SmallDateTime, 0, "Fecha"), new System.Data.SqlClient.SqlParameter("@Cemento", System.Data.SqlDbType.Decimal, 0, System.Data.ParameterDirection.Input, false, ((byte)(18)), ((byte)(2)), "Cemento", System.Data.DataRowVersion.Current, null) }); // // 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("@IdObra", System.Data.SqlDbType.NVarChar, 0, "IdObra"), new System.Data.SqlClient.SqlParameter("@Fecha", System.Data.SqlDbType.SmallDateTime, 0, "Fecha"), new System.Data.SqlClient.SqlParameter("@Cemento", System.Data.SqlDbType.Decimal, 0, System.Data.ParameterDirection.Input, false, ((byte)(18)), ((byte)(2)), "Cemento", System.Data.DataRowVersion.Current, 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("@Original_Fecha", System.Data.SqlDbType.SmallDateTime, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Fecha", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@IsNull_Cemento", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "Cemento", System.Data.DataRowVersion.Original, true, null, "", "", ""), new System.Data.SqlClient.SqlParameter("@Original_Cemento", System.Data.SqlDbType.Decimal, 0, System.Data.ParameterDirection.Input, false, ((byte)(18)), ((byte)(2)), "Cemento", System.Data.DataRowVersion.Original, null) }); // // sqlDeleteCommand1 // this.sqlDeleteCommand1.CommandText = "DELETE FROM [Cemento] WHERE (([IdObra] = @Original_IdObra) AND ([Fecha] = @Origin" + "al_Fecha) AND ((@IsNull_Cemento = 1 AND [Cemento] IS NULL) OR ([Cemento] = @Orig" + "inal_Cemento)))"; this.sqlDeleteCommand1.Connection = this.sqlConn; this.sqlDeleteCommand1.Parameters.AddRange(new System.Data.SqlClient.SqlParameter[] { 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("@Original_Fecha", System.Data.SqlDbType.SmallDateTime, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Fecha", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@IsNull_Cemento", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "Cemento", System.Data.DataRowVersion.Original, true, null, "", "", ""), new System.Data.SqlClient.SqlParameter("@Original_Cemento", System.Data.SqlDbType.Decimal, 0, System.Data.ParameterDirection.Input, false, ((byte)(18)), ((byte)(2)), "Cemento", System.Data.DataRowVersion.Original, null) }); // // sqlDACemento // this.sqlDACemento.DeleteCommand = this.sqlDeleteCommand1; this.sqlDACemento.InsertCommand = this.sqlInsertCommand1; this.sqlDACemento.SelectCommand = this.sqlSelectCommand1; this.sqlDACemento.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping("Table", "Cemento", new System.Data.Common.DataColumnMapping[] { new System.Data.Common.DataColumnMapping("IdObra", "IdObra"), new System.Data.Common.DataColumnMapping("Fecha", "Fecha"), new System.Data.Common.DataColumnMapping("Cemento", "Cemento") }) }); this.sqlDACemento.UpdateCommand = this.sqlUpdateCommand1; // // 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; // // dsBusObra1 // this.dsBusObra1.DataSetName = "dsBusObra"; this.dsBusObra1.Locale = new System.Globalization.CultureInfo("es-MX"); this.dsBusObra1.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema; // // Cemento // this.AutoScaleBaseSize = new System.Drawing.Size(5, 13); this.ClientSize = new System.Drawing.Size(648, 289); this.Controls.Add(this.panel2); this.DAGeneral = this.sqlDACemento; this.dsGeneral = this.dsCemento; this.Name = "Cemento"; this.NombreTabla = "Cemento"; this.Text = "br"; this.Load += new System.EventHandler(this.Cemento_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.dsCemento)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.dsBusObra1)).EndInit(); this.ResumeLayout(false); }