/// <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(InfGrad50)); System.Configuration.AppSettingsReader configurationAppSettings = new System.Configuration.AppSettingsReader(); this.panel1 = new System.Windows.Forms.Panel(); this.btnVistaPrevia = new Soluciones2000.Tools.WinLib.tbBtn(); this.buscaBtn1 = new Soluciones2000.Tools.WinLib.BuscaBtn(); this.dsGrad50Mdor1 = new LancNeo.dsGrad50Mdor(); this.chbTodos = new System.Windows.Forms.CheckBox(); this.groupBox1 = new System.Windows.Forms.GroupBox(); this.rbColada = new System.Windows.Forms.RadioButton(); this.radioButton1 = new System.Windows.Forms.RadioButton(); this.chbLab = new System.Windows.Forms.CheckBox(); this.chbLeyenda = new System.Windows.Forms.CheckBox(); this.chbDuplicado = new System.Windows.Forms.CheckBox(); this.txtFolio = new System.Windows.Forms.TextBox(); this.label6 = new System.Windows.Forms.Label(); this.txtRenglon = new System.Windows.Forms.TextBox(); this.cmbUnidad = new System.Windows.Forms.ComboBox(); this.dsUnidad1 = new LancNeo.dsUnidad(); this.label5 = new System.Windows.Forms.Label(); this.label2 = new System.Windows.Forms.Label(); this.cmbIdObra = new System.Windows.Forms.ComboBox(); this.dsBusObra1 = new LancNeo.dsBusObra(); this.label1 = new System.Windows.Forms.Label(); this.Fecha = new System.Windows.Forms.Label(); this.txtIdobra = new System.Windows.Forms.TextBox(); this.chbFormato = new System.Windows.Forms.CheckBox(); this.chbLab1 = new System.Windows.Forms.CheckBox(); this.sqlDAInfGrad50 = new System.Data.SqlClient.SqlDataAdapter(); this.sqlSelectCommand1 = new System.Data.SqlClient.SqlCommand(); this.sqlConn = new System.Data.SqlClient.SqlConnection(); this.sqlDAUnidad = new System.Data.SqlClient.SqlDataAdapter(); this.sqlCommand2 = new System.Data.SqlClient.SqlCommand(); this.sqlDAFirmas = new System.Data.SqlClient.SqlDataAdapter(); this.sqlSelectCommand7 = new System.Data.SqlClient.SqlCommand(); this.sqlDABusObra = new System.Data.SqlClient.SqlDataAdapter(); this.sqlCommand1 = new System.Data.SqlClient.SqlCommand(); this.dsFirmas1 = new LancNeo.dsFirmas(); this.dsInfGra501 = new LancNeo.dsInfGra50(); this.sqlDAGrad50 = new System.Data.SqlClient.SqlDataAdapter(); this.sqlSelectCommand2 = new System.Data.SqlClient.SqlCommand(); this.crvInfAcero = new CrystalDecisions.Windows.Forms.CrystalReportViewer(); this.cryRepGra501 = new LancNeo.CryRepGra50(); this.sqlDANorma = new System.Data.SqlClient.SqlDataAdapter(); this.sqlSelectCommand3 = new System.Data.SqlClient.SqlCommand(); this.cryRepGra50O1 = new LancNeo.CryRepGra50O(); this.chbRespaldo = new System.Windows.Forms.CheckBox(); this.panel1.SuspendLayout(); ((System.ComponentModel.ISupportInitialize)(this.dsGrad50Mdor1)).BeginInit(); this.groupBox1.SuspendLayout(); ((System.ComponentModel.ISupportInitialize)(this.dsUnidad1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.dsBusObra1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.dsFirmas1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.dsInfGra501)).BeginInit(); this.SuspendLayout(); // // panel1 // this.panel1.BackColor = System.Drawing.SystemColors.Highlight; this.panel1.BorderStyle = System.Windows.Forms.BorderStyle.Fixed3D; this.panel1.Controls.Add(this.btnVistaPrevia); this.panel1.Controls.Add(this.buscaBtn1); this.panel1.Controls.Add(this.chbRespaldo); this.panel1.Controls.Add(this.chbTodos); this.panel1.Controls.Add(this.groupBox1); this.panel1.Controls.Add(this.chbLab); this.panel1.Controls.Add(this.chbLeyenda); this.panel1.Controls.Add(this.chbDuplicado); this.panel1.Controls.Add(this.txtFolio); this.panel1.Controls.Add(this.label6); this.panel1.Controls.Add(this.txtRenglon); this.panel1.Controls.Add(this.cmbUnidad); this.panel1.Controls.Add(this.label5); this.panel1.Controls.Add(this.label2); this.panel1.Controls.Add(this.cmbIdObra); this.panel1.Controls.Add(this.label1); this.panel1.Controls.Add(this.Fecha); this.panel1.Controls.Add(this.txtIdobra); this.panel1.Controls.Add(this.chbFormato); this.panel1.Controls.Add(this.chbLab1); this.panel1.Dock = System.Windows.Forms.DockStyle.Top; this.panel1.Location = new System.Drawing.Point(0, 0); this.panel1.Name = "panel1"; this.panel1.Size = new System.Drawing.Size(878, 114); this.panel1.TabIndex = 13; // // 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(778, 6); this.btnVistaPrevia.Name = "btnVistaPrevia"; this.btnVistaPrevia.Size = new System.Drawing.Size(64, 63); this.btnVistaPrevia.TabIndex = 45; this.btnVistaPrevia.Visible = false; this.btnVistaPrevia.Click += new System.EventHandler(this.btnVistaPrevia_Click); // // buscaBtn1 // this.buscaBtn1.AnchoColTit = true; this.buscaBtn1.AnchoDlgBusq = 650; this.buscaBtn1.BackColor = System.Drawing.Color.Transparent; this.buscaBtn1.Datos = this.dsGrad50Mdor1.Grad50Mdor; this.buscaBtn1.Icon = ((System.Drawing.Icon)(resources.GetObject("buscaBtn1.Icon"))); this.buscaBtn1.Location = new System.Drawing.Point(432, 4); this.buscaBtn1.Name = "buscaBtn1"; this.buscaBtn1.Size = new System.Drawing.Size(64, 64); this.buscaBtn1.TabIndex = 2; this.buscaBtn1.Visible = false; this.buscaBtn1.Click += new System.EventHandler(this.buscaBtn1_Click); // // dsGrad50Mdor1 // this.dsGrad50Mdor1.DataSetName = "dsGrad50Mdor"; this.dsGrad50Mdor1.Locale = new System.Globalization.CultureInfo("es-MX"); this.dsGrad50Mdor1.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema; // // chbTodos // this.chbTodos.ForeColor = System.Drawing.Color.White; this.chbTodos.Location = new System.Drawing.Point(646, 76); this.chbTodos.Name = "chbTodos"; this.chbTodos.Size = new System.Drawing.Size(114, 24); this.chbTodos.TabIndex = 46; this.chbTodos.Text = "Todos los informes"; // // groupBox1 // this.groupBox1.Controls.Add(this.rbColada); this.groupBox1.Controls.Add(this.radioButton1); this.groupBox1.ForeColor = System.Drawing.Color.White; this.groupBox1.Location = new System.Drawing.Point(602, 5); this.groupBox1.Name = "groupBox1"; this.groupBox1.Size = new System.Drawing.Size(158, 67); this.groupBox1.TabIndex = 44; this.groupBox1.TabStop = false; this.groupBox1.Text = "Formato"; // // rbColada // this.rbColada.AutoSize = true; this.rbColada.Checked = true; this.rbColada.ForeColor = System.Drawing.Color.White; this.rbColada.Location = new System.Drawing.Point(7, 43); this.rbColada.Name = "rbColada"; this.rbColada.Size = new System.Drawing.Size(98, 17); this.rbColada.TabIndex = 1; this.rbColada.TabStop = true; this.rbColada.Text = "Colada, remesa"; this.rbColada.UseVisualStyleBackColor = true; // // radioButton1 // this.radioButton1.AutoSize = true; this.radioButton1.ForeColor = System.Drawing.Color.White; this.radioButton1.Location = new System.Drawing.Point(7, 19); this.radioButton1.Name = "radioButton1"; this.radioButton1.Size = new System.Drawing.Size(96, 17); this.radioButton1.TabIndex = 0; this.radioButton1.Text = "Características"; this.radioButton1.UseVisualStyleBackColor = true; // // chbLab // this.chbLab.Checked = true; this.chbLab.CheckState = System.Windows.Forms.CheckState.Checked; this.chbLab.Location = new System.Drawing.Point(345, 76); this.chbLab.Name = "chbLab"; this.chbLab.Size = new System.Drawing.Size(116, 24); this.chbLab.TabIndex = 43; this.chbLab.Text = "Incluye laboratorio"; // // chbLeyenda // this.chbLeyenda.Checked = true; this.chbLeyenda.CheckState = System.Windows.Forms.CheckState.Checked; this.chbLeyenda.ForeColor = System.Drawing.Color.White; this.chbLeyenda.Location = new System.Drawing.Point(229, 76); this.chbLeyenda.Name = "chbLeyenda"; this.chbLeyenda.Size = new System.Drawing.Size(115, 24); this.chbLeyenda.TabIndex = 32; this.chbLeyenda.Text = "Formato leyenda"; // // chbDuplicado // this.chbDuplicado.ForeColor = System.Drawing.Color.White; this.chbDuplicado.Location = new System.Drawing.Point(137, 76); this.chbDuplicado.Name = "chbDuplicado"; this.chbDuplicado.Size = new System.Drawing.Size(87, 24); this.chbDuplicado.TabIndex = 30; this.chbDuplicado.Text = "¿Duplicado?"; // // txtFolio // this.txtFolio.Location = new System.Drawing.Point(540, 6); this.txtFolio.Name = "txtFolio"; this.txtFolio.Size = new System.Drawing.Size(56, 20); this.txtFolio.TabIndex = 27; // // label6 // this.label6.AutoSize = true; this.label6.ForeColor = System.Drawing.Color.White; this.label6.Location = new System.Drawing.Point(500, 33); this.label6.Name = "label6"; this.label6.Size = new System.Drawing.Size(61, 13); this.label6.TabIndex = 26; this.label6.Text = "Renglones:"; // // txtRenglon // this.txtRenglon.Location = new System.Drawing.Point(570, 29); this.txtRenglon.MaxLength = 2; this.txtRenglon.Name = "txtRenglon"; this.txtRenglon.Size = new System.Drawing.Size(23, 20); this.txtRenglon.TabIndex = 25; this.txtRenglon.Text = "20"; this.txtRenglon.TextAlign = System.Windows.Forms.HorizontalAlignment.Right; // // cmbUnidad // this.cmbUnidad.DataSource = this.dsUnidad1.Unidad; this.cmbUnidad.DisplayMember = "Undescr"; this.cmbUnidad.Location = new System.Drawing.Point(344, 32); this.cmbUnidad.Name = "cmbUnidad"; this.cmbUnidad.Size = new System.Drawing.Size(80, 21); this.cmbUnidad.TabIndex = 23; this.cmbUnidad.ValueMember = "IdUnidad"; // // dsUnidad1 // this.dsUnidad1.DataSetName = "dsUnidad"; this.dsUnidad1.Locale = new System.Globalization.CultureInfo("es-MX"); this.dsUnidad1.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema; // // label5 // this.label5.AutoSize = true; this.label5.ForeColor = System.Drawing.Color.White; this.label5.Location = new System.Drawing.Point(301, 38); this.label5.Name = "label5"; this.label5.Size = new System.Drawing.Size(44, 13); this.label5.TabIndex = 24; this.label5.Text = "Unidad:"; // // label2 // this.label2.AutoSize = true; this.label2.ForeColor = System.Drawing.Color.White; this.label2.Location = new System.Drawing.Point(312, 8); this.label2.Name = "label2"; this.label2.Size = new System.Drawing.Size(33, 13); this.label2.TabIndex = 8; this.label2.Text = "Obra:"; // // cmbIdObra // this.cmbIdObra.DataSource = this.dsBusObra1.Obra; this.cmbIdObra.DisplayMember = "Idobra"; this.cmbIdObra.Location = new System.Drawing.Point(344, 8); this.cmbIdObra.Name = "cmbIdObra"; this.cmbIdObra.Size = new System.Drawing.Size(80, 21); this.cmbIdObra.TabIndex = 1; this.cmbIdObra.ValueMember = "IdObra"; this.cmbIdObra.SelectedIndexChanged += new System.EventHandler(this.cmbIdObra_SelectedIndexChanged); // // dsBusObra1 // this.dsBusObra1.DataSetName = "dsBusObra"; this.dsBusObra1.Locale = new System.Globalization.CultureInfo("es-MX"); this.dsBusObra1.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema; // // label1 // this.label1.Font = new System.Drawing.Font("Microsoft Sans Serif", 14F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0))); this.label1.ForeColor = System.Drawing.Color.White; this.label1.Location = new System.Drawing.Point(10, 0); this.label1.Name = "label1"; this.label1.Size = new System.Drawing.Size(272, 73); this.label1.TabIndex = 0; this.label1.Text = "Informe de verificación de calidad de malla y alambre corrugado y liso grado 50"; // // Fecha // this.Fecha.AutoSize = true; this.Fecha.ForeColor = System.Drawing.Color.White; this.Fecha.Location = new System.Drawing.Point(500, 6); this.Fecha.Name = "Fecha"; this.Fecha.Size = new System.Drawing.Size(32, 13); this.Fecha.TabIndex = 4; this.Fecha.Text = "Folio:"; // // txtIdobra // this.txtIdobra.Location = new System.Drawing.Point(432, 32); this.txtIdobra.Name = "txtIdobra"; this.txtIdobra.ReadOnly = true; this.txtIdobra.Size = new System.Drawing.Size(48, 20); this.txtIdobra.TabIndex = 2; this.txtIdobra.Visible = false; // // chbFormato // this.chbFormato.Location = new System.Drawing.Point(465, 76); this.chbFormato.Name = "chbFormato"; this.chbFormato.Size = new System.Drawing.Size(184, 24); this.chbFormato.TabIndex = 26; this.chbFormato.Text = "Incluye imagen de acreditación"; // // chbLab1 // this.chbLab1.Checked = true; this.chbLab1.CheckState = System.Windows.Forms.CheckState.Checked; this.chbLab1.ForeColor = System.Drawing.Color.White; this.chbLab1.Location = new System.Drawing.Point(14, 76); this.chbLab1.Name = "chbLab1"; this.chbLab1.Size = new System.Drawing.Size(125, 24); this.chbLab1.TabIndex = 41; this.chbLab1.Text = "Incluye laboratorista"; // // sqlDAInfGrad50 // this.sqlDAInfGrad50.SelectCommand = this.sqlSelectCommand1; this.sqlDAInfGrad50.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping("Table", "Gra50Rep", new System.Data.Common.DataColumnMapping[] { new System.Data.Common.DataColumnMapping("Folio", "Folio"), new System.Data.Common.DataColumnMapping("IdObra", "IdObra"), new System.Data.Common.DataColumnMapping("ConsObra", "ConsObra"), new System.Data.Common.DataColumnMapping("FMuestreo", "FMuestreo"), new System.Data.Common.DataColumnMapping("FEnsaye", "FEnsaye"), new System.Data.Common.DataColumnMapping("Finforme", "Finforme"), new System.Data.Common.DataColumnMapping("Lab", "Lab"), new System.Data.Common.DataColumnMapping("Anos", "Anos"), new System.Data.Common.DataColumnMapping("Semana", "Semana"), new System.Data.Common.DataColumnMapping("Hoja", "Hoja"), new System.Data.Common.DataColumnMapping("MuesEn", "MuesEn"), new System.Data.Common.DataColumnMapping("Observac", "Observac"), new System.Data.Common.DataColumnMapping("Especifica", "Especifica"), new System.Data.Common.DataColumnMapping("Numero", "Numero"), new System.Data.Common.DataColumnMapping("Grado", "Grado"), new System.Data.Common.DataColumnMapping("Masa", "Masa"), new System.Data.Common.DataColumnMapping("Area", "Area"), new System.Data.Common.DataColumnMapping("EsfLE", "EsfLE"), new System.Data.Common.DataColumnMapping("EsfMAX", "EsfMAX"), new System.Data.Common.DataColumnMapping("Alarga", "Alarga"), new System.Data.Common.DataColumnMapping("Separa", "Separa"), new System.Data.Common.DataColumnMapping("Altura", "Altura"), new System.Data.Common.DataColumnMapping("Inclina", "Inclina"), new System.Data.Common.DataColumnMapping("Doblado", "Doblado"), new System.Data.Common.DataColumnMapping("NominalE", "NominalE"), new System.Data.Common.DataColumnMapping("Cortante1", "Cortante1"), new System.Data.Common.DataColumnMapping("Cortante2", "Cortante2"), new System.Data.Common.DataColumnMapping("Muestra", "Muestra"), new System.Data.Common.DataColumnMapping("Marca", "Marca"), new System.Data.Common.DataColumnMapping("Diametro", "Diametro"), new System.Data.Common.DataColumnMapping("MasaR", "MasaR"), new System.Data.Common.DataColumnMapping("AreaR", "AreaR"), new System.Data.Common.DataColumnMapping("CargaLE", "CargaLE"), new System.Data.Common.DataColumnMapping("CargaMax", "CargaMax"), new System.Data.Common.DataColumnMapping("EsfLER", "EsfLER"), new System.Data.Common.DataColumnMapping("EsfMAXR", "EsfMAXR"), new System.Data.Common.DataColumnMapping("AlargaR", "AlargaR"), new System.Data.Common.DataColumnMapping("SeparaR", "SeparaR"), new System.Data.Common.DataColumnMapping("AlturaR", "AlturaR"), new System.Data.Common.DataColumnMapping("InclinaR", "InclinaR"), new System.Data.Common.DataColumnMapping("DobladoR", "DobladoR"), new System.Data.Common.DataColumnMapping("Cortante1R", "Cortante1R"), new System.Data.Common.DataColumnMapping("Cortante2R", "Cortante2R"), new System.Data.Common.DataColumnMapping("Observa", "Observa"), new System.Data.Common.DataColumnMapping("Observa1", "Observa1"), new System.Data.Common.DataColumnMapping("Nota", "Nota"), new System.Data.Common.DataColumnMapping("Nota1", "Nota1"), new System.Data.Common.DataColumnMapping("Razonsocial", "Razonsocial"), new System.Data.Common.DataColumnMapping("Ubicacion", "Ubicacion"), new System.Data.Common.DataColumnMapping("Colonia", "Colonia"), new System.Data.Common.DataColumnMapping("Nominal", "Nominal"), new System.Data.Common.DataColumnMapping("Milimetros", "Milimetros"), new System.Data.Common.DataColumnMapping("Zona", "Zona"), new System.Data.Common.DataColumnMapping("Colada", "Colada"), new System.Data.Common.DataColumnMapping("Remesa", "Remesa") }) }); // // sqlSelectCommand1 // this.sqlSelectCommand1.CommandText = "[Gra50Rep]"; this.sqlSelectCommand1.CommandType = System.Data.CommandType.StoredProcedure; this.sqlSelectCommand1.Connection = this.sqlConn; this.sqlSelectCommand1.Parameters.AddRange(new System.Data.SqlClient.SqlParameter[] { new System.Data.SqlClient.SqlParameter("@RETURN_VALUE", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.ReturnValue, false, ((byte)(0)), ((byte)(0)), "", System.Data.DataRowVersion.Current, null), new System.Data.SqlClient.SqlParameter("@IdObra", System.Data.SqlDbType.NVarChar, 6), new System.Data.SqlClient.SqlParameter("@Folio1", System.Data.SqlDbType.Char, 10), new System.Data.SqlClient.SqlParameter("@FolioFin", System.Data.SqlDbType.Char, 10), new System.Data.SqlClient.SqlParameter("@IdUnidad", System.Data.SqlDbType.SmallInt, 2), new System.Data.SqlClient.SqlParameter("@Numren", System.Data.SqlDbType.SmallInt, 2) }); // // sqlConn // this.sqlConn.ConnectionString = ((string)(configurationAppSettings.GetValue("sqlConn.ConnectionString", typeof(string)))); this.sqlConn.FireInfoMessageEventOnUserErrors = false; // // sqlDAUnidad // this.sqlDAUnidad.SelectCommand = this.sqlCommand2; this.sqlDAUnidad.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping("Table", "Unidad", new System.Data.Common.DataColumnMapping[] { new System.Data.Common.DataColumnMapping("IdUnidad", "IdUnidad"), new System.Data.Common.DataColumnMapping("Factor", "Factor"), new System.Data.Common.DataColumnMapping("Undescr", "Undescr"), new System.Data.Common.DataColumnMapping("MaxagrUn", "MaxagrUn"), new System.Data.Common.DataColumnMapping("RevenUn", "RevenUn") }) }); // // sqlCommand2 // this.sqlCommand2.CommandText = "SELECT IdUnidad, Factor, Undescr, MaxagrUn, RevenUn FROM Unidad"; this.sqlCommand2.Connection = this.sqlConn; // // sqlDAFirmas // this.sqlDAFirmas.SelectCommand = this.sqlSelectCommand7; this.sqlDAFirmas.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping("Table", "Firmas", new System.Data.Common.DataColumnMapping[] { new System.Data.Common.DataColumnMapping("IdFirma", "IdFirma"), new System.Data.Common.DataColumnMapping("Nombre", "Nombre"), new System.Data.Common.DataColumnMapping("Cargo", "Cargo"), new System.Data.Common.DataColumnMapping("Imprime", "Imprime") }) }); // // sqlSelectCommand7 // this.sqlSelectCommand7.CommandText = "SELECT IdFirma, Nombre, Cargo, Imprime FROM Firmas WHERE (Imprime = 1) ORDER BY I" + "dFirma"; this.sqlSelectCommand7.Connection = this.sqlConn; // // sqlDABusObra // this.sqlDABusObra.SelectCommand = this.sqlCommand1; this.sqlDABusObra.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping("Table", "Obra", new System.Data.Common.DataColumnMapping[] { new System.Data.Common.DataColumnMapping("Idobra", "Idobra"), new System.Data.Common.DataColumnMapping("Ubicacion", "Ubicacion"), new System.Data.Common.DataColumnMapping("RFC", "RFC"), new System.Data.Common.DataColumnMapping("Facturar", "Facturar") }) }); // // sqlCommand1 // this.sqlCommand1.CommandText = resources.GetString("sqlCommand1.CommandText"); this.sqlCommand1.Connection = this.sqlConn; // // dsFirmas1 // this.dsFirmas1.DataSetName = "dsFirmas"; this.dsFirmas1.Locale = new System.Globalization.CultureInfo("es-MX"); this.dsFirmas1.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema; // // dsInfGra501 // this.dsInfGra501.DataSetName = "dsInfGra50"; this.dsInfGra501.Locale = new System.Globalization.CultureInfo("es-MX"); this.dsInfGra501.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema; // // sqlDAGrad50 // this.sqlDAGrad50.SelectCommand = this.sqlSelectCommand2; this.sqlDAGrad50.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping("Table", "Grad50Mdor", new System.Data.Common.DataColumnMapping[] { new System.Data.Common.DataColumnMapping("FOLIO", "FOLIO"), new System.Data.Common.DataColumnMapping("IdObra", "IdObra"), new System.Data.Common.DataColumnMapping("ConsObra", "ConsObra"), new System.Data.Common.DataColumnMapping("FMuestreo", "FMuestreo"), new System.Data.Common.DataColumnMapping("FEnsaye", "FEnsaye"), new System.Data.Common.DataColumnMapping("FInforme", "FInforme"), new System.Data.Common.DataColumnMapping("NoEco", "NoEco"), new System.Data.Common.DataColumnMapping("Semana", "Semana"), new System.Data.Common.DataColumnMapping("MuestreadasEn", "MuestreadasEn"), new System.Data.Common.DataColumnMapping("Observaciones", "Observaciones") }) }); // // sqlSelectCommand2 // this.sqlSelectCommand2.CommandText = "SELECT FOLIO, IdObra, ConsObra, FMuestreo, FEnsaye, FInforme, NoEco, Semana, Mues" + "treadasEn, Observaciones FROM Grad50Mdor WHERE (IdObra = @IdObra)"; this.sqlSelectCommand2.Connection = this.sqlConn; this.sqlSelectCommand2.Parameters.AddRange(new System.Data.SqlClient.SqlParameter[] { new System.Data.SqlClient.SqlParameter("@IdObra", System.Data.SqlDbType.NVarChar, 50, "IdObra") }); // // crvInfAcero // this.crvInfAcero.ActiveViewIndex = -1; this.crvInfAcero.BorderStyle = System.Windows.Forms.BorderStyle.FixedSingle; this.crvInfAcero.Cursor = System.Windows.Forms.Cursors.Default; this.crvInfAcero.Dock = System.Windows.Forms.DockStyle.Fill; this.crvInfAcero.EnableRefresh = false; this.crvInfAcero.Location = new System.Drawing.Point(0, 114); this.crvInfAcero.Name = "crvInfAcero"; this.crvInfAcero.ShowCloseButton = false; this.crvInfAcero.ShowGroupTreeButton = false; this.crvInfAcero.ShowLogo = false; this.crvInfAcero.Size = new System.Drawing.Size(878, 410); this.crvInfAcero.TabIndex = 14; this.crvInfAcero.ToolPanelView = CrystalDecisions.Windows.Forms.ToolPanelViewType.None; // // sqlDANorma // this.sqlDANorma.SelectCommand = this.sqlSelectCommand3; this.sqlDANorma.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping("Table", "Normas", new System.Data.Common.DataColumnMapping[] { new System.Data.Common.DataColumnMapping("IdNorma", "IdNorma"), new System.Data.Common.DataColumnMapping("Informe", "Informe"), new System.Data.Common.DataColumnMapping("Normas", "Normas"), new System.Data.Common.DataColumnMapping("Titulo", "Titulo"), new System.Data.Common.DataColumnMapping("IdInforme", "IdInforme"), new System.Data.Common.DataColumnMapping("Norma1", "Norma1"), new System.Data.Common.DataColumnMapping("Norma2", "Norma2"), new System.Data.Common.DataColumnMapping("Norma3", "Norma3"), new System.Data.Common.DataColumnMapping("Norma4", "Norma4"), new System.Data.Common.DataColumnMapping("Norma5", "Norma5") }) }); // // sqlSelectCommand3 // this.sqlSelectCommand3.CommandText = "SELECT IdNorma, Informe, Normas, Titulo, IdInforme, Norma1, Norma2, Norma3, Norma" + "4, Norma5 FROM Normas WHERE (IdNorma = @IdNorma) ORDER BY IdNorma"; this.sqlSelectCommand3.Connection = this.sqlConn; this.sqlSelectCommand3.Parameters.AddRange(new System.Data.SqlClient.SqlParameter[] { new System.Data.SqlClient.SqlParameter("@IdNorma", System.Data.SqlDbType.SmallInt, 2, "IdNorma") }); // // chbRespaldo // this.chbRespaldo.ForeColor = System.Drawing.Color.White; this.chbRespaldo.Location = new System.Drawing.Point(766, 76); this.chbRespaldo.Name = "chbRespaldo"; this.chbRespaldo.Size = new System.Drawing.Size(90, 24); this.chbRespaldo.TabIndex = 85; this.chbRespaldo.Text = "Respaldo"; // // InfGrad50 // this.AutoScaleBaseSize = new System.Drawing.Size(5, 13); this.ClientSize = new System.Drawing.Size(878, 524); this.Controls.Add(this.crvInfAcero); this.Controls.Add(this.panel1); this.ForeColor = System.Drawing.Color.White; this.Name = "InfGrad50"; this.Text = "InfGrad50"; this.WindowState = System.Windows.Forms.FormWindowState.Maximized; this.Load += new System.EventHandler(this.InfGrad50_Load); this.panel1.ResumeLayout(false); this.panel1.PerformLayout(); ((System.ComponentModel.ISupportInitialize)(this.dsGrad50Mdor1)).EndInit(); this.groupBox1.ResumeLayout(false); this.groupBox1.PerformLayout(); ((System.ComponentModel.ISupportInitialize)(this.dsUnidad1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.dsBusObra1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.dsFirmas1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.dsInfGra501)).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(InfSolda)); System.Configuration.AppSettingsReader configurationAppSettings = new System.Configuration.AppSettingsReader(); this.panel1 = new System.Windows.Forms.Panel(); this.buscaBtn1 = new Soluciones2000.Tools.WinLib.BuscaBtn(); this.dsSoldaMdor1 = new LancNeo.dsSoldaMdor(); this.btnVistaPrevia = new Soluciones2000.Tools.WinLib.tbBtn(); this.chbTodos = new System.Windows.Forms.CheckBox(); this.chbFormato = new System.Windows.Forms.CheckBox(); this.chbLeyenda = new System.Windows.Forms.CheckBox(); this.chbDuplicado = new System.Windows.Forms.CheckBox(); this.txtFolio = new System.Windows.Forms.TextBox(); this.Fecha = new System.Windows.Forms.Label(); this.cmbUnidad = new System.Windows.Forms.ComboBox(); this.dsUnidad1 = new LancNeo.dsUnidad(); this.label5 = new System.Windows.Forms.Label(); this.label2 = new System.Windows.Forms.Label(); this.cmbIdObra = new System.Windows.Forms.ComboBox(); this.dsBusObra1 = new LancNeo.dsBusObra(); this.label1 = new System.Windows.Forms.Label(); this.txtIdobra = new System.Windows.Forms.TextBox(); this.chbLab = new System.Windows.Forms.CheckBox(); this.chbLab1 = new System.Windows.Forms.CheckBox(); this.sqlDABusObra = new System.Data.SqlClient.SqlDataAdapter(); this.sqlCommand1 = new System.Data.SqlClient.SqlCommand(); this.sqlConn = new System.Data.SqlClient.SqlConnection(); this.sqlDASoldaMdor = new System.Data.SqlClient.SqlDataAdapter(); this.sqlSelectCommand1 = new System.Data.SqlClient.SqlCommand(); this.crvInfSolda = new CrystalDecisions.Windows.Forms.CrystalReportViewer(); this.cryRepSolda1 = new LancNeo.CryRepSolda(); this.sqlDAInfSolda = new System.Data.SqlClient.SqlDataAdapter(); this.sqlSelectCommand2 = new System.Data.SqlClient.SqlCommand(); this.dsSoldaRep1 = new LancNeo.dsSoldaRep(); this.sqlDAFirmas = new System.Data.SqlClient.SqlDataAdapter(); this.sqlSelectCommand7 = new System.Data.SqlClient.SqlCommand(); this.dsFirmas1 = new LancNeo.dsFirmas(); this.sqlDAUnidad = new System.Data.SqlClient.SqlDataAdapter(); this.sqlCommand2 = new System.Data.SqlClient.SqlCommand(); this.sqlDANorma = new System.Data.SqlClient.SqlDataAdapter(); this.sqlSelectCommand3 = new System.Data.SqlClient.SqlCommand(); this.chbRespaldo = new System.Windows.Forms.CheckBox(); this.panel1.SuspendLayout(); ((System.ComponentModel.ISupportInitialize)(this.dsSoldaMdor1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.dsUnidad1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.dsBusObra1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.dsSoldaRep1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.dsFirmas1)).BeginInit(); this.SuspendLayout(); // // panel1 // this.panel1.BackColor = System.Drawing.SystemColors.Highlight; this.panel1.BorderStyle = System.Windows.Forms.BorderStyle.Fixed3D; this.panel1.Controls.Add(this.btnVistaPrevia); this.panel1.Controls.Add(this.buscaBtn1); this.panel1.Controls.Add(this.chbRespaldo); this.panel1.Controls.Add(this.chbTodos); this.panel1.Controls.Add(this.chbFormato); this.panel1.Controls.Add(this.chbLeyenda); this.panel1.Controls.Add(this.chbDuplicado); this.panel1.Controls.Add(this.txtFolio); this.panel1.Controls.Add(this.Fecha); this.panel1.Controls.Add(this.cmbUnidad); this.panel1.Controls.Add(this.label5); this.panel1.Controls.Add(this.label2); this.panel1.Controls.Add(this.cmbIdObra); this.panel1.Controls.Add(this.label1); this.panel1.Controls.Add(this.txtIdobra); this.panel1.Controls.Add(this.chbLab); this.panel1.Controls.Add(this.chbLab1); this.panel1.Dock = System.Windows.Forms.DockStyle.Top; this.panel1.Location = new System.Drawing.Point(0, 0); this.panel1.Name = "panel1"; this.panel1.Size = new System.Drawing.Size(856, 97); this.panel1.TabIndex = 10; this.panel1.Paint += new System.Windows.Forms.PaintEventHandler(this.panel1_Paint); // // buscaBtn1 // this.buscaBtn1.AnchoColTit = true; this.buscaBtn1.AnchoDlgBusq = 650; this.buscaBtn1.BackColor = System.Drawing.Color.Transparent; this.buscaBtn1.Datos = this.dsSoldaMdor1.SoldaMdor; this.buscaBtn1.Icon = ((System.Drawing.Icon)(resources.GetObject("buscaBtn1.Icon"))); this.buscaBtn1.Location = new System.Drawing.Point(400, 0); this.buscaBtn1.Name = "buscaBtn1"; this.buscaBtn1.Size = new System.Drawing.Size(63, 63); this.buscaBtn1.TabIndex = 2; this.buscaBtn1.Visible = false; this.buscaBtn1.Click += new System.EventHandler(this.buscaBtn1_Click); // // dsSoldaMdor1 // this.dsSoldaMdor1.DataSetName = "dsSoldaMdor"; this.dsSoldaMdor1.Locale = new System.Globalization.CultureInfo("es-MX"); this.dsSoldaMdor1.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema; // // btnVistaPrevia // this.btnVistaPrevia.BackColor = System.Drawing.Color.Transparent; this.btnVistaPrevia.Icon = ((System.Drawing.Icon)(resources.GetObject("btnVistaPrevia.Icon"))); this.btnVistaPrevia.Location = new System.Drawing.Point(778, 3); this.btnVistaPrevia.Name = "btnVistaPrevia"; this.btnVistaPrevia.Size = new System.Drawing.Size(64, 63); this.btnVistaPrevia.TabIndex = 11; this.btnVistaPrevia.Visible = false; this.btnVistaPrevia.Click += new System.EventHandler(this.btnVistaPrevia_Click); // // chbTodos // this.chbTodos.Location = new System.Drawing.Point(578, 0); this.chbTodos.Name = "chbTodos"; this.chbTodos.Size = new System.Drawing.Size(141, 24); this.chbTodos.TabIndex = 77; this.chbTodos.Text = "Todos los informes"; // // chbFormato // this.chbFormato.ForeColor = System.Drawing.Color.White; this.chbFormato.Location = new System.Drawing.Point(8, 62); this.chbFormato.Name = "chbFormato"; this.chbFormato.Size = new System.Drawing.Size(184, 25); this.chbFormato.TabIndex = 35; this.chbFormato.Text = "Incluye imagen de acreditación"; // // chbLeyenda // this.chbLeyenda.ForeColor = System.Drawing.Color.White; this.chbLeyenda.Location = new System.Drawing.Point(197, 62); this.chbLeyenda.Name = "chbLeyenda"; this.chbLeyenda.Size = new System.Drawing.Size(115, 24); this.chbLeyenda.TabIndex = 34; this.chbLeyenda.Text = "Formato leyenda"; // // chbDuplicado // this.chbDuplicado.ForeColor = System.Drawing.Color.White; this.chbDuplicado.Location = new System.Drawing.Point(467, 31); this.chbDuplicado.Name = "chbDuplicado"; this.chbDuplicado.Size = new System.Drawing.Size(88, 24); this.chbDuplicado.TabIndex = 30; this.chbDuplicado.Text = "¿Duplicado?"; // // txtFolio // this.txtFolio.Location = new System.Drawing.Point(507, 0); this.txtFolio.Name = "txtFolio"; this.txtFolio.Size = new System.Drawing.Size(55, 20); this.txtFolio.TabIndex = 29; // // Fecha // this.Fecha.AutoSize = true; this.Fecha.Location = new System.Drawing.Point(467, 2); this.Fecha.Name = "Fecha"; this.Fecha.Size = new System.Drawing.Size(32, 13); this.Fecha.TabIndex = 28; this.Fecha.Text = "Folio:"; // // cmbUnidad // this.cmbUnidad.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dsUnidad1, "Unidad.Undescr", true)); this.cmbUnidad.DataBindings.Add(new System.Windows.Forms.Binding("SelectedValue", this.dsUnidad1, "Unidad.IdUnidad", true)); this.cmbUnidad.DataSource = this.dsUnidad1.Unidad; this.cmbUnidad.DisplayMember = "Undescr"; this.cmbUnidad.Location = new System.Drawing.Point(320, 33); this.cmbUnidad.Name = "cmbUnidad"; this.cmbUnidad.Size = new System.Drawing.Size(80, 21); this.cmbUnidad.TabIndex = 25; this.cmbUnidad.ValueMember = "IdUnidad"; // // dsUnidad1 // this.dsUnidad1.DataSetName = "dsUnidad"; this.dsUnidad1.Locale = new System.Globalization.CultureInfo("es-MX"); this.dsUnidad1.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema; // // label5 // this.label5.AutoSize = true; this.label5.ForeColor = System.Drawing.Color.White; this.label5.Location = new System.Drawing.Point(280, 35); this.label5.Name = "label5"; this.label5.Size = new System.Drawing.Size(44, 13); this.label5.TabIndex = 26; this.label5.Text = "Unidad:"; // // label2 // this.label2.AutoSize = true; this.label2.ForeColor = System.Drawing.Color.White; this.label2.Location = new System.Drawing.Point(288, 3); this.label2.Name = "label2"; this.label2.Size = new System.Drawing.Size(33, 13); this.label2.TabIndex = 8; this.label2.Text = "Obra:"; // // cmbIdObra // this.cmbIdObra.DataSource = this.dsBusObra1.Obra; this.cmbIdObra.DisplayMember = "Idobra"; this.cmbIdObra.Location = new System.Drawing.Point(320, 2); this.cmbIdObra.Name = "cmbIdObra"; this.cmbIdObra.Size = new System.Drawing.Size(80, 21); this.cmbIdObra.TabIndex = 1; this.cmbIdObra.ValueMember = "IdObra"; this.cmbIdObra.SelectedIndexChanged += new System.EventHandler(this.cmbIdObra_SelectedIndexChanged); // // dsBusObra1 // this.dsBusObra1.DataSetName = "dsBusObra"; this.dsBusObra1.Locale = new System.Globalization.CultureInfo("es-MX"); this.dsBusObra1.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema; // // label1 // this.label1.Font = new System.Drawing.Font("Microsoft Sans Serif", 14F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0))); this.label1.ForeColor = System.Drawing.Color.White; this.label1.Location = new System.Drawing.Point(8, 0); this.label1.Name = "label1"; this.label1.Size = new System.Drawing.Size(272, 56); this.label1.TabIndex = 0; this.label1.Text = "Informe de verificación de calidad de soldadura"; // // txtIdobra // this.txtIdobra.Location = new System.Drawing.Point(408, 32); this.txtIdobra.Name = "txtIdobra"; this.txtIdobra.ReadOnly = true; this.txtIdobra.Size = new System.Drawing.Size(48, 20); this.txtIdobra.TabIndex = 2; this.txtIdobra.Visible = false; // // chbLab // this.chbLab.Checked = true; this.chbLab.CheckState = System.Windows.Forms.CheckState.Checked; this.chbLab.ForeColor = System.Drawing.Color.White; this.chbLab.Location = new System.Drawing.Point(323, 62); this.chbLab.Name = "chbLab"; this.chbLab.Size = new System.Drawing.Size(116, 25); this.chbLab.TabIndex = 40; this.chbLab.Text = "Incluye laboratorio"; // // chbLab1 // this.chbLab1.Checked = true; this.chbLab1.CheckState = System.Windows.Forms.CheckState.Checked; this.chbLab1.ForeColor = System.Drawing.Color.White; this.chbLab1.Location = new System.Drawing.Point(467, 62); this.chbLab1.Name = "chbLab1"; this.chbLab1.Size = new System.Drawing.Size(123, 24); this.chbLab1.TabIndex = 76; this.chbLab1.Text = "Incluye laboratorista"; // // sqlDABusObra // this.sqlDABusObra.SelectCommand = this.sqlCommand1; this.sqlDABusObra.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping("Table", "Obra", new System.Data.Common.DataColumnMapping[] { new System.Data.Common.DataColumnMapping("Idobra", "Idobra"), new System.Data.Common.DataColumnMapping("Ubicacion", "Ubicacion"), new System.Data.Common.DataColumnMapping("RFC", "RFC"), new System.Data.Common.DataColumnMapping("Facturar", "Facturar")})}); // // sqlCommand1 // this.sqlCommand1.CommandText = resources.GetString("sqlCommand1.CommandText"); this.sqlCommand1.Connection = this.sqlConn; // // sqlConn // this.sqlConn.ConnectionString = ((string)(configurationAppSettings.GetValue("sqlConn.ConnectionString", typeof(string)))); this.sqlConn.FireInfoMessageEventOnUserErrors = false; // // sqlDASoldaMdor // this.sqlDASoldaMdor.SelectCommand = this.sqlSelectCommand1; this.sqlDASoldaMdor.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping("Table", "SoldaMdor", 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")})}); // // sqlSelectCommand1 // this.sqlSelectCommand1.CommandText = "SELECT FOLIO, IdObra, ConsObra, FMuestreo, FEnsaye, FInforme, NoEco, Semana, Mues" + "treadasEn FROM SoldaMdor WHERE (IdObra = @IdObra) ORDER BY FOLIO"; 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")}); // // crvInfSolda // this.crvInfSolda.ActiveViewIndex = -1; this.crvInfSolda.BorderStyle = System.Windows.Forms.BorderStyle.FixedSingle; this.crvInfSolda.Cursor = System.Windows.Forms.Cursors.Default; this.crvInfSolda.Dock = System.Windows.Forms.DockStyle.Fill; this.crvInfSolda.EnableRefresh = false; this.crvInfSolda.Location = new System.Drawing.Point(0, 97); this.crvInfSolda.Name = "crvInfSolda"; this.crvInfSolda.ShowCloseButton = false; this.crvInfSolda.ShowGroupTreeButton = false; this.crvInfSolda.ShowLogo = false; this.crvInfSolda.Size = new System.Drawing.Size(856, 427); this.crvInfSolda.TabIndex = 11; this.crvInfSolda.ToolPanelView = CrystalDecisions.Windows.Forms.ToolPanelViewType.None; // // sqlDAInfSolda // this.sqlDAInfSolda.SelectCommand = this.sqlSelectCommand2; this.sqlDAInfSolda.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping("Table", "SoldaRep", new System.Data.Common.DataColumnMapping[] { new System.Data.Common.DataColumnMapping("Folio", "Folio"), new System.Data.Common.DataColumnMapping("IdObra", "IdObra"), new System.Data.Common.DataColumnMapping("ConsObra", "ConsObra"), new System.Data.Common.DataColumnMapping("FMuestreo", "FMuestreo"), new System.Data.Common.DataColumnMapping("FEnsaye", "FEnsaye"), new System.Data.Common.DataColumnMapping("Finforme", "Finforme"), new System.Data.Common.DataColumnMapping("Lab", "Lab"), new System.Data.Common.DataColumnMapping("Anos", "Anos"), new System.Data.Common.DataColumnMapping("Semana", "Semana"), new System.Data.Common.DataColumnMapping("Hoja", "Hoja"), new System.Data.Common.DataColumnMapping("MuesEn", "MuesEn"), new System.Data.Common.DataColumnMapping("Observac", "Observac"), new System.Data.Common.DataColumnMapping("Especifica", "Especifica"), new System.Data.Common.DataColumnMapping("Numero", "Numero"), new System.Data.Common.DataColumnMapping("Grado", "Grado"), new System.Data.Common.DataColumnMapping("Masa", "Masa"), new System.Data.Common.DataColumnMapping("EsfLE", "EsfLE"), new System.Data.Common.DataColumnMapping("EsfMAX", "EsfMAX"), new System.Data.Common.DataColumnMapping("Alarga", "Alarga"), new System.Data.Common.DataColumnMapping("Separa", "Separa"), new System.Data.Common.DataColumnMapping("Altura", "Altura"), new System.Data.Common.DataColumnMapping("Ancho", "Ancho"), new System.Data.Common.DataColumnMapping("Inclina", "Inclina"), new System.Data.Common.DataColumnMapping("Doblado", "Doblado"), new System.Data.Common.DataColumnMapping("Muestra", "Muestra"), new System.Data.Common.DataColumnMapping("MasaR", "MasaR"), new System.Data.Common.DataColumnMapping("Area", "Area"), new System.Data.Common.DataColumnMapping("CargaLE", "CargaLE"), new System.Data.Common.DataColumnMapping("CargaMax", "CargaMax"), new System.Data.Common.DataColumnMapping("EsfLER", "EsfLER"), new System.Data.Common.DataColumnMapping("EsfMAXR", "EsfMAXR"), new System.Data.Common.DataColumnMapping("AlargaR", "AlargaR"), new System.Data.Common.DataColumnMapping("DobladoR", "DobladoR"), new System.Data.Common.DataColumnMapping("SeparaR", "SeparaR"), new System.Data.Common.DataColumnMapping("AlturaR", "AlturaR"), new System.Data.Common.DataColumnMapping("AnchoR", "AnchoR"), new System.Data.Common.DataColumnMapping("InclinaR", "InclinaR"), new System.Data.Common.DataColumnMapping("Observa", "Observa"), new System.Data.Common.DataColumnMapping("Observa1", "Observa1"), new System.Data.Common.DataColumnMapping("Nota", "Nota"), new System.Data.Common.DataColumnMapping("Nota1", "Nota1"), new System.Data.Common.DataColumnMapping("Razonsocial", "Razonsocial"), new System.Data.Common.DataColumnMapping("Ubicacion", "Ubicacion"), new System.Data.Common.DataColumnMapping("Colonia", "Colonia"), new System.Data.Common.DataColumnMapping("Nominal", "Nominal"), new System.Data.Common.DataColumnMapping("Milimetros", "Milimetros")})}); // // sqlSelectCommand2 // this.sqlSelectCommand2.CommandText = "[SoldaRep]"; 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("@Folio1", System.Data.SqlDbType.Char, 10), new System.Data.SqlClient.SqlParameter("@Foliofin", System.Data.SqlDbType.Char, 10), new System.Data.SqlClient.SqlParameter("@IdUnidad", System.Data.SqlDbType.SmallInt, 2)}); // // dsSoldaRep1 // this.dsSoldaRep1.DataSetName = "dsSoldaRep"; this.dsSoldaRep1.Locale = new System.Globalization.CultureInfo("es-MX"); this.dsSoldaRep1.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema; // // sqlDAFirmas // this.sqlDAFirmas.SelectCommand = this.sqlSelectCommand7; this.sqlDAFirmas.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping("Table", "Firmas", new System.Data.Common.DataColumnMapping[] { new System.Data.Common.DataColumnMapping("IdFirma", "IdFirma"), new System.Data.Common.DataColumnMapping("Nombre", "Nombre"), new System.Data.Common.DataColumnMapping("Cargo", "Cargo"), new System.Data.Common.DataColumnMapping("Imprime", "Imprime")})}); // // sqlSelectCommand7 // this.sqlSelectCommand7.CommandText = "SELECT IdFirma, Nombre, Cargo, Imprime\r\nFROM Firmas\r\nWHERE (Impri" + "me = 1) AND (Soldadura < 6)\r\nORDER BY Soldadura"; this.sqlSelectCommand7.Connection = this.sqlConn; // // dsFirmas1 // this.dsFirmas1.DataSetName = "dsFirmas"; this.dsFirmas1.Locale = new System.Globalization.CultureInfo("es-MX"); this.dsFirmas1.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema; // // sqlDAUnidad // this.sqlDAUnidad.SelectCommand = this.sqlCommand2; this.sqlDAUnidad.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping("Table", "Unidad", new System.Data.Common.DataColumnMapping[] { new System.Data.Common.DataColumnMapping("IdUnidad", "IdUnidad"), new System.Data.Common.DataColumnMapping("Factor", "Factor"), new System.Data.Common.DataColumnMapping("Undescr", "Undescr"), new System.Data.Common.DataColumnMapping("MaxagrUn", "MaxagrUn"), new System.Data.Common.DataColumnMapping("RevenUn", "RevenUn")})}); // // sqlCommand2 // this.sqlCommand2.CommandText = "SELECT IdUnidad, Factor, Undescr, MaxagrUn, RevenUn FROM Unidad"; this.sqlCommand2.Connection = this.sqlConn; // // sqlDANorma // this.sqlDANorma.SelectCommand = this.sqlSelectCommand3; this.sqlDANorma.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping("Table", "Normas", new System.Data.Common.DataColumnMapping[] { new System.Data.Common.DataColumnMapping("IdNorma", "IdNorma"), new System.Data.Common.DataColumnMapping("Informe", "Informe"), new System.Data.Common.DataColumnMapping("Normas", "Normas"), new System.Data.Common.DataColumnMapping("Titulo", "Titulo"), new System.Data.Common.DataColumnMapping("IdInforme", "IdInforme"), new System.Data.Common.DataColumnMapping("Norma1", "Norma1"), new System.Data.Common.DataColumnMapping("Norma2", "Norma2"), new System.Data.Common.DataColumnMapping("Norma3", "Norma3"), new System.Data.Common.DataColumnMapping("Norma4", "Norma4"), new System.Data.Common.DataColumnMapping("Norma5", "Norma5")})}); // // sqlSelectCommand3 // this.sqlSelectCommand3.CommandText = "SELECT IdNorma, Informe, Normas, Titulo, IdInforme, Norma1, Norma2, Norma3, Norma" + "4, Norma5 FROM Normas WHERE (IdNorma = @IdNorma) ORDER BY IdNorma"; this.sqlSelectCommand3.Connection = this.sqlConn; this.sqlSelectCommand3.Parameters.AddRange(new System.Data.SqlClient.SqlParameter[] { new System.Data.SqlClient.SqlParameter("@IdNorma", System.Data.SqlDbType.SmallInt, 2, "IdNorma")}); // // chbRespaldo // this.chbRespaldo.ForeColor = System.Drawing.Color.White; this.chbRespaldo.Location = new System.Drawing.Point(578, 30); this.chbRespaldo.Name = "chbRespaldo"; this.chbRespaldo.Size = new System.Drawing.Size(82, 24); this.chbRespaldo.TabIndex = 83; this.chbRespaldo.Text = "Respaldo"; // // InfSolda // this.AutoScaleBaseSize = new System.Drawing.Size(5, 13); this.ClientSize = new System.Drawing.Size(856, 524); this.Controls.Add(this.crvInfSolda); this.Controls.Add(this.panel1); this.ForeColor = System.Drawing.Color.White; this.Name = "InfSolda"; this.Text = "InfSolda"; this.WindowState = System.Windows.Forms.FormWindowState.Maximized; this.Load += new System.EventHandler(this.InfSolda_Load); this.panel1.ResumeLayout(false); this.panel1.PerformLayout(); ((System.ComponentModel.ISupportInitialize)(this.dsSoldaMdor1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.dsUnidad1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.dsBusObra1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.dsSoldaRep1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.dsFirmas1)).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(InfSecante)); this.sqlDAInfSecante = new System.Data.SqlClient.SqlDataAdapter(); this.sqlSelectCommand1 = new System.Data.SqlClient.SqlCommand(); this.sqlConn = new System.Data.SqlClient.SqlConnection(); this.dsBusObra1 = new LancNeo.dsBusObra(); this.dsUnidad1 = new LancNeo.dsUnidad(); this.sqlDAUnidad = new System.Data.SqlClient.SqlDataAdapter(); this.sqlCommand2 = new System.Data.SqlClient.SqlCommand(); this.sqlDAFirmas = new System.Data.SqlClient.SqlDataAdapter(); this.sqlSelectCommand7 = new System.Data.SqlClient.SqlCommand(); this.dsFirmas1 = new LancNeo.dsFirmas(); this.sqlDABusObra = new System.Data.SqlClient.SqlDataAdapter(); this.sqlCommand1 = new System.Data.SqlClient.SqlCommand(); this.dsInfSecante1 = new LancNeo.dsInfSecante(); this.panel1 = new System.Windows.Forms.Panel(); this.btnVistaPrevia = new Soluciones2000.Tools.WinLib.tbBtn(); this.buscaBtn1 = new Soluciones2000.Tools.WinLib.BuscaBtn(); this.dsSecanteInf1 = new LancNeo.dsSecanteInf(); this.chbRespaldo = new System.Windows.Forms.CheckBox(); this.chbTodos = new System.Windows.Forms.CheckBox(); this.txtDesc = new System.Windows.Forms.TextBox(); this.chbLab1 = new System.Windows.Forms.CheckBox(); this.chbLab = new System.Windows.Forms.CheckBox(); this.chbLeyenda = new System.Windows.Forms.CheckBox(); this.chbFormato = new System.Windows.Forms.CheckBox(); this.chbDuplicado = new System.Windows.Forms.CheckBox(); this.label6 = new System.Windows.Forms.Label(); this.nudRenglon = new System.Windows.Forms.NumericUpDown(); this.txtFolioFin = new System.Windows.Forms.TextBox(); this.txtFolioIni = new System.Windows.Forms.TextBox(); this.cmbUnidad = new System.Windows.Forms.ComboBox(); 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.cmbIdObra = new System.Windows.Forms.ComboBox(); this.label1 = new System.Windows.Forms.Label(); this.txtIdobra = new System.Windows.Forms.TextBox(); this.sqlDASecante = new System.Data.SqlClient.SqlDataAdapter(); this.sqlSelectCommand2 = new System.Data.SqlClient.SqlCommand(); this.crvInfSecante = new CrystalDecisions.Windows.Forms.CrystalReportViewer(); this.cryRepSecante1 = new LancNeo.CryRepSecante(); this.sqlDANorma = new System.Data.SqlClient.SqlDataAdapter(); this.sqlSelectCommand3 = new System.Data.SqlClient.SqlCommand(); ((System.ComponentModel.ISupportInitialize)(this.dsBusObra1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.dsUnidad1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.dsFirmas1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.dsInfSecante1)).BeginInit(); this.panel1.SuspendLayout(); ((System.ComponentModel.ISupportInitialize)(this.dsSecanteInf1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.nudRenglon)).BeginInit(); this.SuspendLayout(); // // sqlDAInfSecante // this.sqlDAInfSecante.SelectCommand = this.sqlSelectCommand1; this.sqlDAInfSecante.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping("Table", "SecanteRep", 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("FEnsaye", "FEnsaye"), new System.Data.Common.DataColumnMapping("Finforme", "Finforme"), new System.Data.Common.DataColumnMapping("Lab", "Lab"), new System.Data.Common.DataColumnMapping("Anos", "Anos"), new System.Data.Common.DataColumnMapping("Semana", "Semana"), new System.Data.Common.DataColumnMapping("Hoja", "Hoja"), new System.Data.Common.DataColumnMapping("Observac", "Observac"), new System.Data.Common.DataColumnMapping("PromedioP", "PromedioP"), new System.Data.Common.DataColumnMapping("PromedioR", "PromedioR"), new System.Data.Common.DataColumnMapping("Muestra", "Muestra"), new System.Data.Common.DataColumnMapping("Fecha", "Fecha"), new System.Data.Common.DataColumnMapping("IdCroncretera", "IdCroncretera"), 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("Revenimiento", "Revenimiento"), new System.Data.Common.DataColumnMapping("Grado", "Grado"), new System.Data.Common.DataColumnMapping("IdAgregado", "IdAgregado"), new System.Data.Common.DataColumnMapping("IdRemision", "IdRemision"), new System.Data.Common.DataColumnMapping("RevObt", "RevObt"), new System.Data.Common.DataColumnMapping("Cilindro", "Cilindro"), new System.Data.Common.DataColumnMapping("Edad", "Edad"), new System.Data.Common.DataColumnMapping("Masa", "Masa"), new System.Data.Common.DataColumnMapping("Resistencia", "Resistencia"), new System.Data.Common.DataColumnMapping("Obtenido", "Obtenido"), new System.Data.Common.DataColumnMapping("Promedio", "Promedio"), new System.Data.Common.DataColumnMapping("Requerido", "Requerido"), 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("Razonsocial", "Razonsocial"), new System.Data.Common.DataColumnMapping("Ubicacion", "Ubicacion"), new System.Data.Common.DataColumnMapping("Colonia", "Colonia"), new System.Data.Common.DataColumnMapping("Zona", "Zona") }) }); // // sqlSelectCommand1 // this.sqlSelectCommand1.CommandText = "dbo.SecanteRep"; this.sqlSelectCommand1.CommandType = System.Data.CommandType.StoredProcedure; this.sqlSelectCommand1.Connection = this.sqlConn; this.sqlSelectCommand1.Parameters.AddRange(new System.Data.SqlClient.SqlParameter[] { new System.Data.SqlClient.SqlParameter("@RETURN_VALUE", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.ReturnValue, false, ((byte)(0)), ((byte)(0)), "", System.Data.DataRowVersion.Current, null), new System.Data.SqlClient.SqlParameter("@IdObra", System.Data.SqlDbType.NVarChar, 6, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "", System.Data.DataRowVersion.Current, "LE1218"), new System.Data.SqlClient.SqlParameter("@FolioIni", System.Data.SqlDbType.Char, 10, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "", System.Data.DataRowVersion.Current, "71/18"), new System.Data.SqlClient.SqlParameter("@FOlioFin", System.Data.SqlDbType.Char, 10, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "", System.Data.DataRowVersion.Current, "71/18"), new System.Data.SqlClient.SqlParameter("@IdUnidad", System.Data.SqlDbType.SmallInt, 2, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "", System.Data.DataRowVersion.Current, "1") }); // // sqlConn // this.sqlConn.ConnectionString = ((string)(configurationAppSettings.GetValue("sqlConn.ConnectionString", typeof(string)))); this.sqlConn.FireInfoMessageEventOnUserErrors = false; // // dsBusObra1 // this.dsBusObra1.DataSetName = "dsBusObra"; this.dsBusObra1.Locale = new System.Globalization.CultureInfo("es-MX"); this.dsBusObra1.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema; // // dsUnidad1 // this.dsUnidad1.DataSetName = "dsUnidad"; this.dsUnidad1.Locale = new System.Globalization.CultureInfo("es-MX"); this.dsUnidad1.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema; // // sqlDAUnidad // this.sqlDAUnidad.SelectCommand = this.sqlCommand2; this.sqlDAUnidad.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping("Table", "Unidad", new System.Data.Common.DataColumnMapping[] { new System.Data.Common.DataColumnMapping("IdUnidad", "IdUnidad"), new System.Data.Common.DataColumnMapping("Factor", "Factor"), new System.Data.Common.DataColumnMapping("Undescr", "Undescr"), new System.Data.Common.DataColumnMapping("MaxagrUn", "MaxagrUn"), new System.Data.Common.DataColumnMapping("RevenUn", "RevenUn") }) }); // // sqlCommand2 // this.sqlCommand2.CommandText = "SELECT IdUnidad, Factor, Undescr, MaxagrUn, RevenUn FROM Unidad"; this.sqlCommand2.Connection = this.sqlConn; // // sqlDAFirmas // this.sqlDAFirmas.SelectCommand = this.sqlSelectCommand7; this.sqlDAFirmas.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping("Table", "Firmas", new System.Data.Common.DataColumnMapping[] { new System.Data.Common.DataColumnMapping("IdFirma", "IdFirma"), new System.Data.Common.DataColumnMapping("Nombre", "Nombre"), new System.Data.Common.DataColumnMapping("Cargo", "Cargo"), new System.Data.Common.DataColumnMapping("Imprime", "Imprime") }) }); // // sqlSelectCommand7 // this.sqlSelectCommand7.CommandText = "SELECT IdFirma, Nombre, Cargo, Imprime\r\nFROM Firmas\r\nWHERE (Impri" + "me = 1) AND (Moduloelastico < 6)\r\nORDER BY Moduloelastico"; this.sqlSelectCommand7.Connection = this.sqlConn; // // dsFirmas1 // this.dsFirmas1.DataSetName = "dsFirmas"; this.dsFirmas1.Locale = new System.Globalization.CultureInfo("es-MX"); this.dsFirmas1.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema; // // sqlDABusObra // this.sqlDABusObra.SelectCommand = this.sqlCommand1; this.sqlDABusObra.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping("Table", "Obra", new System.Data.Common.DataColumnMapping[] { new System.Data.Common.DataColumnMapping("Idobra", "Idobra"), new System.Data.Common.DataColumnMapping("Ubicacion", "Ubicacion"), new System.Data.Common.DataColumnMapping("RFC", "RFC"), new System.Data.Common.DataColumnMapping("Facturar", "Facturar") }) }); // // sqlCommand1 // this.sqlCommand1.CommandText = resources.GetString("sqlCommand1.CommandText"); this.sqlCommand1.Connection = this.sqlConn; // // dsInfSecante1 // this.dsInfSecante1.DataSetName = "dsInfSecante"; this.dsInfSecante1.Locale = new System.Globalization.CultureInfo("es-MX"); this.dsInfSecante1.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema; // // panel1 // this.panel1.BackColor = System.Drawing.SystemColors.Highlight; this.panel1.BorderStyle = System.Windows.Forms.BorderStyle.Fixed3D; this.panel1.Controls.Add(this.buscaBtn1); this.panel1.Controls.Add(this.btnVistaPrevia); this.panel1.Controls.Add(this.chbRespaldo); this.panel1.Controls.Add(this.chbTodos); this.panel1.Controls.Add(this.txtDesc); this.panel1.Controls.Add(this.chbLab1); this.panel1.Controls.Add(this.chbLab); this.panel1.Controls.Add(this.chbLeyenda); this.panel1.Controls.Add(this.chbFormato); this.panel1.Controls.Add(this.chbDuplicado); this.panel1.Controls.Add(this.label6); this.panel1.Controls.Add(this.nudRenglon); this.panel1.Controls.Add(this.txtFolioFin); this.panel1.Controls.Add(this.txtFolioIni); this.panel1.Controls.Add(this.cmbUnidad); this.panel1.Controls.Add(this.label5); this.panel1.Controls.Add(this.label4); this.panel1.Controls.Add(this.label3); this.panel1.Controls.Add(this.label2); this.panel1.Controls.Add(this.cmbIdObra); this.panel1.Controls.Add(this.label1); this.panel1.Controls.Add(this.txtIdobra); this.panel1.Dock = System.Windows.Forms.DockStyle.Top; this.panel1.Location = new System.Drawing.Point(0, 0); this.panel1.Name = "panel1"; this.panel1.Size = new System.Drawing.Size(1028, 118); this.panel1.TabIndex = 11; // // 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(714, 24); this.btnVistaPrevia.Name = "btnVistaPrevia"; this.btnVistaPrevia.Size = new System.Drawing.Size(64, 63); this.btnVistaPrevia.TabIndex = 11; this.btnVistaPrevia.Visible = false; this.btnVistaPrevia.Load += new System.EventHandler(this.btnVistaPrevia_Load); this.btnVistaPrevia.Click += new System.EventHandler(this.btnVistaPrevia_Click); // // buscaBtn1 // this.buscaBtn1.AnchoColTit = true; this.buscaBtn1.AnchoDlgBusq = 650; this.buscaBtn1.BackColor = System.Drawing.Color.Transparent; this.buscaBtn1.Datos = this.dsSecanteInf1.Secante; this.buscaBtn1.Icon = ((System.Drawing.Icon)(resources.GetObject("buscaBtn1.Icon"))); this.buscaBtn1.Location = new System.Drawing.Point(396, -3); this.buscaBtn1.Name = "buscaBtn1"; this.buscaBtn1.Size = new System.Drawing.Size(64, 63); this.buscaBtn1.TabIndex = 2; this.buscaBtn1.Visible = false; this.buscaBtn1.Click += new System.EventHandler(this.buscaBtn1_Click); // // dsSecanteInf1 // this.dsSecanteInf1.DataSetName = "dsSecanteInf"; this.dsSecanteInf1.Locale = new System.Globalization.CultureInfo("es-MX"); this.dsSecanteInf1.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema; // // chbRespaldo // this.chbRespaldo.ForeColor = System.Drawing.Color.White; this.chbRespaldo.Location = new System.Drawing.Point(507, 58); this.chbRespaldo.Name = "chbRespaldo"; this.chbRespaldo.Size = new System.Drawing.Size(116, 24); this.chbRespaldo.TabIndex = 45; this.chbRespaldo.Text = "Respaldo"; // // chbTodos // this.chbTodos.ForeColor = System.Drawing.Color.White; this.chbTodos.Location = new System.Drawing.Point(507, 35); this.chbTodos.Name = "chbTodos"; this.chbTodos.Size = new System.Drawing.Size(124, 24); this.chbTodos.TabIndex = 43; this.chbTodos.Text = "Todos los informes"; // // txtDesc // this.txtDesc.Location = new System.Drawing.Point(870, 28); this.txtDesc.Name = "txtDesc"; this.txtDesc.Size = new System.Drawing.Size(100, 20); this.txtDesc.TabIndex = 42; // // chbLab1 // this.chbLab1.Checked = true; this.chbLab1.CheckState = System.Windows.Forms.CheckState.Checked; this.chbLab1.ForeColor = System.Drawing.Color.White; this.chbLab1.Location = new System.Drawing.Point(212, 58); this.chbLab1.Name = "chbLab1"; this.chbLab1.Size = new System.Drawing.Size(133, 24); this.chbLab1.TabIndex = 41; this.chbLab1.Text = "Incluye laboratorista"; // // chbLab // this.chbLab.Checked = true; this.chbLab.CheckState = System.Windows.Forms.CheckState.Checked; this.chbLab.ForeColor = System.Drawing.Color.White; this.chbLab.Location = new System.Drawing.Point(212, 81); this.chbLab.Name = "chbLab"; this.chbLab.Size = new System.Drawing.Size(183, 24); this.chbLab.TabIndex = 36; this.chbLab.Text = "Incluye Laboratorios"; // // chbLeyenda // this.chbLeyenda.Checked = true; this.chbLeyenda.CheckState = System.Windows.Forms.CheckState.Checked; this.chbLeyenda.ForeColor = System.Drawing.Color.White; this.chbLeyenda.Location = new System.Drawing.Point(507, 81); this.chbLeyenda.Name = "chbLeyenda"; this.chbLeyenda.Size = new System.Drawing.Size(110, 24); this.chbLeyenda.TabIndex = 35; this.chbLeyenda.Text = "Formato leyenda"; // // chbFormato // this.chbFormato.ForeColor = System.Drawing.Color.White; this.chbFormato.Location = new System.Drawing.Point(25, 81); this.chbFormato.Name = "chbFormato"; this.chbFormato.Size = new System.Drawing.Size(182, 24); this.chbFormato.TabIndex = 34; this.chbFormato.Text = "Incluye imagen de acreditación"; this.chbFormato.CheckedChanged += new System.EventHandler(this.chbFormato_CheckedChanged); // // chbDuplicado // this.chbDuplicado.ForeColor = System.Drawing.Color.White; this.chbDuplicado.Location = new System.Drawing.Point(408, 81); this.chbDuplicado.Name = "chbDuplicado"; this.chbDuplicado.Size = new System.Drawing.Size(89, 25); this.chbDuplicado.TabIndex = 31; this.chbDuplicado.Text = "¿Duplicado?"; // // label6 // this.label6.AutoSize = true; this.label6.ForeColor = System.Drawing.Color.White; this.label6.Location = new System.Drawing.Point(596, 2); this.label6.Name = "label6"; this.label6.Size = new System.Drawing.Size(124, 13); this.label6.TabIndex = 30; this.label6.Text = "Especio entre renglones:"; // // nudRenglon // this.nudRenglon.Location = new System.Drawing.Point(730, -2); this.nudRenglon.Maximum = new decimal(new int[] { 4, 0, 0, 0 }); this.nudRenglon.Name = "nudRenglon"; this.nudRenglon.Size = new System.Drawing.Size(48, 20); this.nudRenglon.TabIndex = 29; this.nudRenglon.Value = new decimal(new int[] { 2, 0, 0, 0 }); // // txtFolioFin // this.txtFolioFin.Location = new System.Drawing.Point(926, 81); this.txtFolioFin.Name = "txtFolioFin"; this.txtFolioFin.Size = new System.Drawing.Size(54, 20); this.txtFolioFin.TabIndex = 28; this.txtFolioFin.Visible = false; this.txtFolioFin.TextChanged += new System.EventHandler(this.textBox2_TextChanged); // // txtFolioIni // this.txtFolioIni.Location = new System.Drawing.Point(532, 0); this.txtFolioIni.Name = "txtFolioIni"; this.txtFolioIni.Size = new System.Drawing.Size(54, 20); this.txtFolioIni.TabIndex = 27; // // cmbUnidad // this.cmbUnidad.DataSource = this.dsUnidad1.Unidad; this.cmbUnidad.DisplayMember = "Undescr"; this.cmbUnidad.Location = new System.Drawing.Point(308, 33); this.cmbUnidad.Name = "cmbUnidad"; this.cmbUnidad.Size = new System.Drawing.Size(80, 21); this.cmbUnidad.TabIndex = 25; this.cmbUnidad.ValueMember = "IdUnidad"; this.cmbUnidad.SelectedIndexChanged += new System.EventHandler(this.cmbUnidad_SelectedIndexChanged); // // label5 // this.label5.AutoSize = true; this.label5.ForeColor = System.Drawing.Color.White; this.label5.Location = new System.Drawing.Point(262, 35); this.label5.Name = "label5"; this.label5.Size = new System.Drawing.Size(44, 13); this.label5.TabIndex = 26; this.label5.Text = "Unidad:"; // // label4 // this.label4.AutoSize = true; this.label4.ForeColor = System.Drawing.Color.White; this.label4.Location = new System.Drawing.Point(864, 83); this.label4.Name = "label4"; this.label4.Size = new System.Drawing.Size(54, 13); this.label4.TabIndex = 11; this.label4.Text = "Folio final:"; this.label4.Visible = false; // // label3 // this.label3.AutoSize = true; this.label3.ForeColor = System.Drawing.Color.White; this.label3.Location = new System.Drawing.Point(462, 3); this.label3.Name = "label3"; this.label3.Size = new System.Drawing.Size(61, 13); this.label3.TabIndex = 9; this.label3.Text = "Folio inicial:"; // // label2 // this.label2.AutoSize = true; this.label2.ForeColor = System.Drawing.Color.White; this.label2.Location = new System.Drawing.Point(263, 3); this.label2.Name = "label2"; this.label2.Size = new System.Drawing.Size(33, 13); this.label2.TabIndex = 8; this.label2.Text = "Obra:"; // // cmbIdObra // this.cmbIdObra.DataSource = this.dsBusObra1.Obra; this.cmbIdObra.DisplayMember = "Idobra"; this.cmbIdObra.Location = new System.Drawing.Point(308, 0); this.cmbIdObra.Name = "cmbIdObra"; this.cmbIdObra.Size = new System.Drawing.Size(80, 21); this.cmbIdObra.TabIndex = 1; this.cmbIdObra.ValueMember = "IdObra"; this.cmbIdObra.SelectedIndexChanged += new System.EventHandler(this.cmbIdObra_SelectedIndexChanged); // // label1 // this.label1.Font = new System.Drawing.Font("Microsoft Sans Serif", 14F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0))); this.label1.ForeColor = System.Drawing.Color.White; this.label1.Location = new System.Drawing.Point(6, 0); this.label1.Name = "label1"; this.label1.Size = new System.Drawing.Size(254, 75); this.label1.TabIndex = 0; this.label1.Text = "Informe de Módulo Elástico Secante NMX-C-128"; // // txtIdobra // this.txtIdobra.Location = new System.Drawing.Point(396, 32); this.txtIdobra.Name = "txtIdobra"; this.txtIdobra.ReadOnly = true; this.txtIdobra.Size = new System.Drawing.Size(48, 20); this.txtIdobra.TabIndex = 2; this.txtIdobra.Visible = false; // // sqlDASecante // this.sqlDASecante.SelectCommand = this.sqlSelectCommand2; this.sqlDASecante.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping("Table", "Secante", 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("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("PromedioP", "PromedioP"), new System.Data.Common.DataColumnMapping("PromedioR", "PromedioR") }) }); // // sqlSelectCommand2 // this.sqlSelectCommand2.CommandText = "SELECT FOLIO, IdObra, ConsObra, Fensaye, Finforme, NoEco, Semana FROM Secante WHE" + "RE (IdObra = @IdObra) ORDER BY FOLIO"; this.sqlSelectCommand2.Connection = this.sqlConn; this.sqlSelectCommand2.Parameters.AddRange(new System.Data.SqlClient.SqlParameter[] { new System.Data.SqlClient.SqlParameter("@IdObra", System.Data.SqlDbType.NVarChar, 6, "IdObra") }); // // crvInfSecante // this.crvInfSecante.ActiveViewIndex = -1; this.crvInfSecante.BorderStyle = System.Windows.Forms.BorderStyle.FixedSingle; this.crvInfSecante.Cursor = System.Windows.Forms.Cursors.Default; this.crvInfSecante.Dock = System.Windows.Forms.DockStyle.Fill; this.crvInfSecante.EnableRefresh = false; this.crvInfSecante.Location = new System.Drawing.Point(0, 118); this.crvInfSecante.Name = "crvInfSecante"; this.crvInfSecante.ShowCloseButton = false; this.crvInfSecante.ShowGroupTreeButton = false; this.crvInfSecante.ShowLogo = false; this.crvInfSecante.Size = new System.Drawing.Size(1028, 487); this.crvInfSecante.TabIndex = 12; this.crvInfSecante.ToolPanelView = CrystalDecisions.Windows.Forms.ToolPanelViewType.None; this.crvInfSecante.ToolPanelWidth = 167; // // sqlDANorma // this.sqlDANorma.SelectCommand = this.sqlSelectCommand3; this.sqlDANorma.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping("Table", "Normas", new System.Data.Common.DataColumnMapping[] { new System.Data.Common.DataColumnMapping("IdNorma", "IdNorma"), new System.Data.Common.DataColumnMapping("Informe", "Informe"), new System.Data.Common.DataColumnMapping("Normas", "Normas"), new System.Data.Common.DataColumnMapping("Titulo", "Titulo"), new System.Data.Common.DataColumnMapping("IdInforme", "IdInforme") }) }); // // sqlSelectCommand3 // this.sqlSelectCommand3.CommandText = "SELECT IdNorma, Informe, Normas, Titulo, IdInforme FROM Normas WHERE (IdNorma = 9" + ") ORDER BY IdNorma"; this.sqlSelectCommand3.Connection = this.sqlConn; // // InfSecante // this.AutoScaleBaseSize = new System.Drawing.Size(5, 13); this.ClientSize = new System.Drawing.Size(1028, 605); this.Controls.Add(this.crvInfSecante); this.Controls.Add(this.panel1); this.Name = "InfSecante"; this.Text = "InfSecante"; this.WindowState = System.Windows.Forms.FormWindowState.Maximized; this.Load += new System.EventHandler(this.InfSecante_Load); ((System.ComponentModel.ISupportInitialize)(this.dsBusObra1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.dsUnidad1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.dsFirmas1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.dsInfSecante1)).EndInit(); this.panel1.ResumeLayout(false); this.panel1.PerformLayout(); ((System.ComponentModel.ISupportInitialize)(this.dsSecanteInf1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.nudRenglon)).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(InfTabique)); this.sqlDAInfTabiqueMdor = new System.Data.SqlClient.SqlDataAdapter(); this.sqlSelectCommand1 = new System.Data.SqlClient.SqlCommand(); this.sqlConn = new System.Data.SqlClient.SqlConnection(); this.dsInfTabiqueMdor1 = new LancNeo.dsInfTabiqueMdor(); this.sqlDABusObra = new System.Data.SqlClient.SqlDataAdapter(); this.sqlCommand1 = new System.Data.SqlClient.SqlCommand(); this.sqlDAFirmas = new System.Data.SqlClient.SqlDataAdapter(); this.sqlSelectCommand7 = new System.Data.SqlClient.SqlCommand(); this.dsBusObra1 = new LancNeo.dsBusObra(); this.dsFirmas1 = new LancNeo.dsFirmas(); this.panel1 = new System.Windows.Forms.Panel(); this.buscaBtn1 = new Soluciones2000.Tools.WinLib.BuscaBtn(); this.dsTabiqueMdor1 = new LancNeo.dsTabiqueMdor(); this.btnVistaPrevia = new Soluciones2000.Tools.WinLib.tbBtn(); this.chbLab = new System.Windows.Forms.CheckBox(); this.chbDuplicado = new System.Windows.Forms.CheckBox(); this.txtFolio = new System.Windows.Forms.TextBox(); this.Fecha = new System.Windows.Forms.Label(); this.cmbUnidad = new System.Windows.Forms.ComboBox(); this.dsUnidad1 = new LancNeo.dsUnidad(); this.label5 = new System.Windows.Forms.Label(); this.label2 = new System.Windows.Forms.Label(); this.cmbIdObra = new System.Windows.Forms.ComboBox(); this.label1 = new System.Windows.Forms.Label(); this.txtIdobra = new System.Windows.Forms.TextBox(); this.chbLeyenda = new System.Windows.Forms.CheckBox(); this.chbLab1 = new System.Windows.Forms.CheckBox(); this.crvInfTabique = new CrystalDecisions.Windows.Forms.CrystalReportViewer(); this.sqlDAInfTabiqueResC = new System.Data.SqlClient.SqlDataAdapter(); this.sqlSelectCommand2 = new System.Data.SqlClient.SqlCommand(); this.sqlDAInfTabiqueResA = new System.Data.SqlClient.SqlDataAdapter(); this.sqlCommand2 = new System.Data.SqlClient.SqlCommand(); this.sqlDATabiqueMdor = new System.Data.SqlClient.SqlDataAdapter(); this.sqlSelectCommand3 = new System.Data.SqlClient.SqlCommand(); this.cryRepTabique1 = new LancNeo.CryRepTabique(); this.sqlDAUnidad = new System.Data.SqlClient.SqlDataAdapter(); this.sqlCommand3 = new System.Data.SqlClient.SqlCommand(); this.sqlDANorma = new System.Data.SqlClient.SqlDataAdapter(); this.sqlSelectCommand4 = new System.Data.SqlClient.SqlCommand(); ((System.ComponentModel.ISupportInitialize)(this.dsInfTabiqueMdor1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.dsBusObra1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.dsFirmas1)).BeginInit(); this.panel1.SuspendLayout(); ((System.ComponentModel.ISupportInitialize)(this.dsTabiqueMdor1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.dsUnidad1)).BeginInit(); this.SuspendLayout(); // // sqlDAInfTabiqueMdor // this.sqlDAInfTabiqueMdor.SelectCommand = this.sqlSelectCommand1; this.sqlDAInfTabiqueMdor.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping("Table", "TabiqueRep", new System.Data.Common.DataColumnMapping[] { new System.Data.Common.DataColumnMapping("Folio", "Folio"), new System.Data.Common.DataColumnMapping("IdObra", "IdObra"), new System.Data.Common.DataColumnMapping("ConsObra", "ConsObra"), new System.Data.Common.DataColumnMapping("FMuestreo", "FMuestreo"), new System.Data.Common.DataColumnMapping("FEnsaye", "FEnsaye"), new System.Data.Common.DataColumnMapping("Finforme", "Finforme"), new System.Data.Common.DataColumnMapping("Lab", "Lab"), new System.Data.Common.DataColumnMapping("Anos", "Anos"), new System.Data.Common.DataColumnMapping("Semana", "Semana"), new System.Data.Common.DataColumnMapping("Hoja", "Hoja"), new System.Data.Common.DataColumnMapping("MReducida", "MReducida"), new System.Data.Common.DataColumnMapping("Unidad", "Unidad"), new System.Data.Common.DataColumnMapping("Cumple", "Cumple"), new System.Data.Common.DataColumnMapping("Norma", "Norma"), new System.Data.Common.DataColumnMapping("Como", "Como"), new System.Data.Common.DataColumnMapping("ObsComo", "ObsComo"), new System.Data.Common.DataColumnMapping("Tipo", "Tipo"), new System.Data.Common.DataColumnMapping("Subtipo", "Subtipo"), new System.Data.Common.DataColumnMapping("Grado", "Grado"), new System.Data.Common.DataColumnMapping("Empleado", "Empleado"), new System.Data.Common.DataColumnMapping("Observac", "Observac"), new System.Data.Common.DataColumnMapping("Razonsocial", "Razonsocial"), new System.Data.Common.DataColumnMapping("Ubicacion", "Ubicacion"), new System.Data.Common.DataColumnMapping("Colonia", "Colonia"), new System.Data.Common.DataColumnMapping("Zona", "Zona") }) }); // // sqlSelectCommand1 // this.sqlSelectCommand1.CommandText = "[TabiqueRep]"; this.sqlSelectCommand1.CommandType = System.Data.CommandType.StoredProcedure; this.sqlSelectCommand1.Connection = this.sqlConn; this.sqlSelectCommand1.Parameters.AddRange(new System.Data.SqlClient.SqlParameter[] { new System.Data.SqlClient.SqlParameter("@RETURN_VALUE", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.ReturnValue, false, ((byte)(0)), ((byte)(0)), "", System.Data.DataRowVersion.Current, null), new System.Data.SqlClient.SqlParameter("@IdObra", System.Data.SqlDbType.NVarChar, 6), new System.Data.SqlClient.SqlParameter("@Folio1", System.Data.SqlDbType.VarChar, 10) }); // // sqlConn // this.sqlConn.ConnectionString = ((string)(configurationAppSettings.GetValue("sqlConn.ConnectionString", typeof(string)))); this.sqlConn.FireInfoMessageEventOnUserErrors = false; // // dsInfTabiqueMdor1 // this.dsInfTabiqueMdor1.DataSetName = "dsInfTabiqueMdor"; this.dsInfTabiqueMdor1.Locale = new System.Globalization.CultureInfo("es-MX"); this.dsInfTabiqueMdor1.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema; // // sqlDABusObra // this.sqlDABusObra.SelectCommand = this.sqlCommand1; this.sqlDABusObra.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping("Table", "Obra", new System.Data.Common.DataColumnMapping[] { new System.Data.Common.DataColumnMapping("Idobra", "Idobra"), new System.Data.Common.DataColumnMapping("Ubicacion", "Ubicacion"), new System.Data.Common.DataColumnMapping("RFC", "RFC"), new System.Data.Common.DataColumnMapping("Facturar", "Facturar") }) }); // // sqlCommand1 // this.sqlCommand1.CommandText = resources.GetString("sqlCommand1.CommandText"); this.sqlCommand1.Connection = this.sqlConn; // // sqlDAFirmas // this.sqlDAFirmas.SelectCommand = this.sqlSelectCommand7; this.sqlDAFirmas.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping("Table", "Firmas", new System.Data.Common.DataColumnMapping[] { new System.Data.Common.DataColumnMapping("IdFirma", "IdFirma"), new System.Data.Common.DataColumnMapping("Nombre", "Nombre"), new System.Data.Common.DataColumnMapping("Cargo", "Cargo"), new System.Data.Common.DataColumnMapping("Imprime", "Imprime") }) }); // // sqlSelectCommand7 // this.sqlSelectCommand7.CommandText = "SELECT IdFirma, Nombre, Cargo, Imprime FROM Firmas WHERE (Imprime = 1) ORDER BY I" + "dFirma"; this.sqlSelectCommand7.Connection = this.sqlConn; // // dsBusObra1 // this.dsBusObra1.DataSetName = "dsBusObra"; this.dsBusObra1.Locale = new System.Globalization.CultureInfo("es-MX"); this.dsBusObra1.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema; // // dsFirmas1 // this.dsFirmas1.DataSetName = "dsFirmas"; this.dsFirmas1.Locale = new System.Globalization.CultureInfo("es-MX"); this.dsFirmas1.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema; // // panel1 // this.panel1.BackColor = System.Drawing.SystemColors.Highlight; this.panel1.BorderStyle = System.Windows.Forms.BorderStyle.Fixed3D; this.panel1.Controls.Add(this.buscaBtn1); this.panel1.Controls.Add(this.btnVistaPrevia); this.panel1.Controls.Add(this.chbLab); this.panel1.Controls.Add(this.chbDuplicado); this.panel1.Controls.Add(this.txtFolio); this.panel1.Controls.Add(this.Fecha); this.panel1.Controls.Add(this.cmbUnidad); this.panel1.Controls.Add(this.label5); this.panel1.Controls.Add(this.label2); this.panel1.Controls.Add(this.cmbIdObra); this.panel1.Controls.Add(this.label1); this.panel1.Controls.Add(this.txtIdobra); this.panel1.Controls.Add(this.chbLeyenda); this.panel1.Controls.Add(this.chbLab1); this.panel1.Dock = System.Windows.Forms.DockStyle.Top; this.panel1.Location = new System.Drawing.Point(0, 0); this.panel1.Name = "panel1"; this.panel1.Size = new System.Drawing.Size(856, 109); this.panel1.TabIndex = 12; // // buscaBtn1 // this.buscaBtn1.AnchoColTit = true; this.buscaBtn1.AnchoDlgBusq = 450; this.buscaBtn1.BackColor = System.Drawing.Color.Transparent; this.buscaBtn1.Datos = this.dsTabiqueMdor1.TabiqueMdor; this.buscaBtn1.Icon = ((System.Drawing.Icon)(resources.GetObject("buscaBtn1.Icon"))); this.buscaBtn1.Location = new System.Drawing.Point(560, 0); this.buscaBtn1.Name = "buscaBtn1"; this.buscaBtn1.Size = new System.Drawing.Size(64, 64); this.buscaBtn1.TabIndex = 2; this.buscaBtn1.Visible = false; this.buscaBtn1.Click += new System.EventHandler(this.buscaBtn1_Click); // // dsTabiqueMdor1 // this.dsTabiqueMdor1.DataSetName = "dsTabiqueMdor"; this.dsTabiqueMdor1.Locale = new System.Globalization.CultureInfo("es-MX"); this.dsTabiqueMdor1.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema; // // btnVistaPrevia // this.btnVistaPrevia.BackColor = System.Drawing.Color.Transparent; this.btnVistaPrevia.Icon = ((System.Drawing.Icon)(resources.GetObject("btnVistaPrevia.Icon"))); this.btnVistaPrevia.Location = new System.Drawing.Point(748, 7); this.btnVistaPrevia.Name = "btnVistaPrevia"; this.btnVistaPrevia.Size = new System.Drawing.Size(64, 64); this.btnVistaPrevia.TabIndex = 11; this.btnVistaPrevia.Visible = false; this.btnVistaPrevia.Load += new System.EventHandler(this.btnVistaPrevia_Load); this.btnVistaPrevia.Click += new System.EventHandler(this.btnVistaPrevia_Click); // // chbLab // this.chbLab.Checked = true; this.chbLab.CheckState = System.Windows.Forms.CheckState.Checked; this.chbLab.Location = new System.Drawing.Point(562, 76); this.chbLab.Name = "chbLab"; this.chbLab.Size = new System.Drawing.Size(115, 24); this.chbLab.TabIndex = 78; this.chbLab.Text = "Incluye laboratorio"; // // chbDuplicado // this.chbDuplicado.Location = new System.Drawing.Point(628, 32); this.chbDuplicado.Name = "chbDuplicado"; this.chbDuplicado.Size = new System.Drawing.Size(89, 24); this.chbDuplicado.TabIndex = 34; this.chbDuplicado.Text = "¿Duplicado?"; // // txtFolio // this.txtFolio.Location = new System.Drawing.Point(665, 6); this.txtFolio.Name = "txtFolio"; this.txtFolio.Size = new System.Drawing.Size(56, 20); this.txtFolio.TabIndex = 33; // // Fecha // this.Fecha.AutoSize = true; this.Fecha.Location = new System.Drawing.Point(628, 8); this.Fecha.Name = "Fecha"; this.Fecha.Size = new System.Drawing.Size(32, 13); this.Fecha.TabIndex = 32; this.Fecha.Text = "Folio:"; // // cmbUnidad // this.cmbUnidad.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dsUnidad1, "Unidad.Undescr", true)); this.cmbUnidad.DataBindings.Add(new System.Windows.Forms.Binding("SelectedValue", this.dsUnidad1, "Unidad.IdUnidad", true)); this.cmbUnidad.DataSource = this.dsUnidad1.Unidad; this.cmbUnidad.DisplayMember = "Undescr"; this.cmbUnidad.Location = new System.Drawing.Point(472, 32); this.cmbUnidad.Name = "cmbUnidad"; this.cmbUnidad.Size = new System.Drawing.Size(80, 21); this.cmbUnidad.TabIndex = 25; this.cmbUnidad.ValueMember = "IdUnidad"; // // dsUnidad1 // this.dsUnidad1.DataSetName = "dsUnidad"; this.dsUnidad1.Locale = new System.Globalization.CultureInfo("es-MX"); this.dsUnidad1.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema; // // label5 // this.label5.AutoSize = true; this.label5.Location = new System.Drawing.Point(429, 34); this.label5.Name = "label5"; this.label5.Size = new System.Drawing.Size(44, 13); this.label5.TabIndex = 26; this.label5.Text = "Unidad:"; // // label2 // this.label2.AutoSize = true; this.label2.Location = new System.Drawing.Point(440, 8); this.label2.Name = "label2"; this.label2.Size = new System.Drawing.Size(33, 13); this.label2.TabIndex = 8; this.label2.Text = "Obra:"; // // cmbIdObra // this.cmbIdObra.DataSource = this.dsBusObra1.Obra; this.cmbIdObra.DisplayMember = "Idobra"; this.cmbIdObra.Location = new System.Drawing.Point(472, 6); this.cmbIdObra.Name = "cmbIdObra"; this.cmbIdObra.Size = new System.Drawing.Size(80, 21); this.cmbIdObra.TabIndex = 1; this.cmbIdObra.ValueMember = "IdObra"; this.cmbIdObra.SelectedIndexChanged += new System.EventHandler(this.cmbIdObra_SelectedIndexChanged); // // 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, 0); this.label1.Name = "label1"; this.label1.Size = new System.Drawing.Size(392, 75); this.label1.TabIndex = 0; this.label1.Text = "Informe de verificación de las propiedades físicas del ladrillo, tabique, block y" + " adoquin"; // // txtIdobra // this.txtIdobra.Location = new System.Drawing.Point(560, 32); this.txtIdobra.Name = "txtIdobra"; this.txtIdobra.ReadOnly = true; this.txtIdobra.Size = new System.Drawing.Size(48, 20); this.txtIdobra.TabIndex = 2; this.txtIdobra.Visible = false; // // chbLeyenda // this.chbLeyenda.Checked = true; this.chbLeyenda.CheckState = System.Windows.Forms.CheckState.Checked; this.chbLeyenda.Location = new System.Drawing.Point(432, 76); this.chbLeyenda.Name = "chbLeyenda"; this.chbLeyenda.Size = new System.Drawing.Size(116, 24); this.chbLeyenda.TabIndex = 33; this.chbLeyenda.Text = "Formato leyenda"; // // chbLab1 // this.chbLab1.Checked = true; this.chbLab1.CheckState = System.Windows.Forms.CheckState.Checked; this.chbLab1.Location = new System.Drawing.Point(686, 76); this.chbLab1.Name = "chbLab1"; this.chbLab1.Size = new System.Drawing.Size(140, 28); this.chbLab1.TabIndex = 41; this.chbLab1.Text = "Incluye laboratorista"; // // crvInfTabique // this.crvInfTabique.ActiveViewIndex = -1; this.crvInfTabique.BorderStyle = System.Windows.Forms.BorderStyle.FixedSingle; this.crvInfTabique.Cursor = System.Windows.Forms.Cursors.Default; this.crvInfTabique.Dock = System.Windows.Forms.DockStyle.Fill; this.crvInfTabique.EnableRefresh = false; this.crvInfTabique.Location = new System.Drawing.Point(0, 109); this.crvInfTabique.Name = "crvInfTabique"; this.crvInfTabique.ShowCloseButton = false; this.crvInfTabique.ShowGroupTreeButton = false; this.crvInfTabique.ShowLogo = false; this.crvInfTabique.Size = new System.Drawing.Size(856, 415); this.crvInfTabique.TabIndex = 13; this.crvInfTabique.ToolPanelView = CrystalDecisions.Windows.Forms.ToolPanelViewType.None; // // sqlDAInfTabiqueResC // this.sqlDAInfTabiqueResC.SelectCommand = this.sqlSelectCommand2; this.sqlDAInfTabiqueResC.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping("Table", "TabiqueRep1", new System.Data.Common.DataColumnMapping[] { new System.Data.Common.DataColumnMapping("Folio", "Folio"), new System.Data.Common.DataColumnMapping("Muestra", "Muestra"), new System.Data.Common.DataColumnMapping("TMuestra", "TMuestra"), new System.Data.Common.DataColumnMapping("Largo", "Largo"), new System.Data.Common.DataColumnMapping("Ancho", "Ancho"), new System.Data.Common.DataColumnMapping("Peralte", "Peralte"), new System.Data.Common.DataColumnMapping("Area", "Area"), new System.Data.Common.DataColumnMapping("RcAInd", "RcAInd"), new System.Data.Common.DataColumnMapping("RcAPro", "RcAPro"), new System.Data.Common.DataColumnMapping("EspInd", "EspInd"), new System.Data.Common.DataColumnMapping("EspPro", "EspPro") }) }); // // sqlSelectCommand2 // this.sqlSelectCommand2.CommandText = "[TabiqueRep1]"; 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("@Folio1", System.Data.SqlDbType.VarChar, 10), new System.Data.SqlClient.SqlParameter("@Prueba", System.Data.SqlDbType.Bit, 1), new System.Data.SqlClient.SqlParameter("@IdUnidad", System.Data.SqlDbType.SmallInt, 2) }); // // sqlDAInfTabiqueResA // this.sqlDAInfTabiqueResA.SelectCommand = this.sqlCommand2; this.sqlDAInfTabiqueResA.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping("Table", "TabiqueRep1", new System.Data.Common.DataColumnMapping[] { new System.Data.Common.DataColumnMapping("Folio", "Folio"), new System.Data.Common.DataColumnMapping("Muestra", "Muestra"), new System.Data.Common.DataColumnMapping("TMuestra", "TMuestra"), new System.Data.Common.DataColumnMapping("Largo", "Largo"), new System.Data.Common.DataColumnMapping("Ancho", "Ancho"), new System.Data.Common.DataColumnMapping("Peralte", "Peralte"), new System.Data.Common.DataColumnMapping("Area", "Area"), new System.Data.Common.DataColumnMapping("RcAInd", "RcAInd"), new System.Data.Common.DataColumnMapping("RcAPro", "RcAPro"), new System.Data.Common.DataColumnMapping("EspInd", "EspInd"), new System.Data.Common.DataColumnMapping("EspPro", "EspPro") }) }); // // sqlCommand2 // this.sqlCommand2.CommandText = "[TabiqueRep1]"; this.sqlCommand2.CommandType = System.Data.CommandType.StoredProcedure; this.sqlCommand2.Connection = this.sqlConn; this.sqlCommand2.Parameters.AddRange(new System.Data.SqlClient.SqlParameter[] { new System.Data.SqlClient.SqlParameter("@RETURN_VALUE", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.ReturnValue, false, ((byte)(0)), ((byte)(0)), "", System.Data.DataRowVersion.Current, null), new System.Data.SqlClient.SqlParameter("@IdObra", System.Data.SqlDbType.NVarChar, 6), new System.Data.SqlClient.SqlParameter("@Folio1", System.Data.SqlDbType.VarChar, 10), new System.Data.SqlClient.SqlParameter("@Prueba", System.Data.SqlDbType.Bit, 1), new System.Data.SqlClient.SqlParameter("@IdUnidad", System.Data.SqlDbType.SmallInt, 2) }); // // sqlDATabiqueMdor // this.sqlDATabiqueMdor.SelectCommand = this.sqlSelectCommand3; this.sqlDATabiqueMdor.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping("Table", "TabiqueMdor", 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("MReducida", "MReducida"), new System.Data.Common.DataColumnMapping("Unidad", "Unidad"), new System.Data.Common.DataColumnMapping("Cumple", "Cumple"), new System.Data.Common.DataColumnMapping("Norma", "Norma"), new System.Data.Common.DataColumnMapping("Como", "Como"), new System.Data.Common.DataColumnMapping("ObsComo", "ObsComo"), new System.Data.Common.DataColumnMapping("Tipo", "Tipo"), new System.Data.Common.DataColumnMapping("Subtipo", "Subtipo"), new System.Data.Common.DataColumnMapping("Grado", "Grado"), new System.Data.Common.DataColumnMapping("Empleado", "Empleado"), new System.Data.Common.DataColumnMapping("Observaciones", "Observaciones") }) }); // // sqlSelectCommand3 // this.sqlSelectCommand3.CommandText = resources.GetString("sqlSelectCommand3.CommandText"); this.sqlSelectCommand3.Connection = this.sqlConn; this.sqlSelectCommand3.Parameters.AddRange(new System.Data.SqlClient.SqlParameter[] { new System.Data.SqlClient.SqlParameter("@IdObra", System.Data.SqlDbType.NVarChar, 6, "IdObra") }); // // sqlDAUnidad // this.sqlDAUnidad.SelectCommand = this.sqlCommand3; this.sqlDAUnidad.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping("Table", "Unidad", new System.Data.Common.DataColumnMapping[] { new System.Data.Common.DataColumnMapping("IdUnidad", "IdUnidad"), new System.Data.Common.DataColumnMapping("Factor", "Factor"), new System.Data.Common.DataColumnMapping("Undescr", "Undescr"), new System.Data.Common.DataColumnMapping("MaxagrUn", "MaxagrUn"), new System.Data.Common.DataColumnMapping("RevenUn", "RevenUn") }) }); // // sqlCommand3 // this.sqlCommand3.CommandText = "SELECT IdUnidad, Factor, Undescr, MaxagrUn, RevenUn FROM Unidad"; this.sqlCommand3.Connection = this.sqlConn; // // sqlDANorma // this.sqlDANorma.SelectCommand = this.sqlSelectCommand4; this.sqlDANorma.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping("Table", "Normas", new System.Data.Common.DataColumnMapping[] { new System.Data.Common.DataColumnMapping("IdNorma", "IdNorma"), new System.Data.Common.DataColumnMapping("Informe", "Informe"), new System.Data.Common.DataColumnMapping("Normas", "Normas"), new System.Data.Common.DataColumnMapping("Titulo", "Titulo"), new System.Data.Common.DataColumnMapping("IdInforme", "IdInforme"), new System.Data.Common.DataColumnMapping("Norma1", "Norma1"), new System.Data.Common.DataColumnMapping("Norma2", "Norma2"), new System.Data.Common.DataColumnMapping("Norma3", "Norma3"), new System.Data.Common.DataColumnMapping("Norma4", "Norma4"), new System.Data.Common.DataColumnMapping("Norma5", "Norma5") }) }); // // sqlSelectCommand4 // this.sqlSelectCommand4.CommandText = "SELECT IdNorma, Informe, Normas, Titulo, IdInforme, Norma1, Norma2, Norma3, Norma" + "4, Norma5 FROM Normas WHERE (IdNorma = @IdNorma)"; this.sqlSelectCommand4.Connection = this.sqlConn; this.sqlSelectCommand4.Parameters.AddRange(new System.Data.SqlClient.SqlParameter[] { new System.Data.SqlClient.SqlParameter("@IdNorma", System.Data.SqlDbType.SmallInt, 2, "IdNorma") }); // // InfTabique // this.AutoScaleBaseSize = new System.Drawing.Size(5, 13); this.ClientSize = new System.Drawing.Size(856, 524); this.Controls.Add(this.crvInfTabique); this.Controls.Add(this.panel1); this.Name = "InfTabique"; this.Text = "infTabique"; this.WindowState = System.Windows.Forms.FormWindowState.Maximized; this.Load += new System.EventHandler(this.InfTabique_Load); ((System.ComponentModel.ISupportInitialize)(this.dsInfTabiqueMdor1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.dsBusObra1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.dsFirmas1)).EndInit(); this.panel1.ResumeLayout(false); this.panel1.PerformLayout(); ((System.ComponentModel.ISupportInitialize)(this.dsTabiqueMdor1)).EndInit(); ((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.Configuration.AppSettingsReader configurationAppSettings = new System.Configuration.AppSettingsReader(); System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(RepPromedios)); this.sqlConn = new System.Data.SqlClient.SqlConnection(); this.sqlDAUnidad = new System.Data.SqlClient.SqlDataAdapter(); this.sqlSelectCommand1 = new System.Data.SqlClient.SqlCommand(); this.sqlDAConcretera = new System.Data.SqlClient.SqlDataAdapter(); this.sqlSelectCommand5 = new System.Data.SqlClient.SqlCommand(); this.sqlDAPLanta = new System.Data.SqlClient.SqlDataAdapter(); this.sqlSelectCommand6 = new System.Data.SqlClient.SqlCommand(); this.sqlDABusObra = new System.Data.SqlClient.SqlDataAdapter(); this.sqlCommand1 = new System.Data.SqlClient.SqlCommand(); this.dsUnidad1 = new LancNeo.dsUnidad(); this.dsPlanta1 = new LancNeo.dsPlanta(); this.dsConcretera1 = new LancNeo.dsConcretera(); this.panel1 = new System.Windows.Forms.Panel(); this.buscaBtn1 = new Soluciones2000.Tools.WinLib.BuscaBtn(); this.dsConcreto1 = new LancNeo.dsConcreto(); this.btnVistaPrevia = new Soluciones2000.Tools.WinLib.tbBtn(); this.chbLab = new System.Windows.Forms.CheckBox(); this.cmbIdDiam = new System.Windows.Forms.ComboBox(); this.dsDiametro1 = new LancNeo.dsDiametro(); this.label14 = new System.Windows.Forms.Label(); this.textBox1 = new System.Windows.Forms.TextBox(); this.cbkPrefijo = new System.Windows.Forms.CheckBox(); this.label9 = new System.Windows.Forms.Label(); this.label8 = new System.Windows.Forms.Label(); this.cmbUnidad = new System.Windows.Forms.ComboBox(); this.label5 = new System.Windows.Forms.Label(); this.dtpFin = new System.Windows.Forms.DateTimePicker(); this.label4 = new System.Windows.Forms.Label(); this.dtpIni = new System.Windows.Forms.DateTimePicker(); this.label3 = new System.Windows.Forms.Label(); this.label2 = new System.Windows.Forms.Label(); this.cmbIdObra = new System.Windows.Forms.ComboBox(); this.dsBuscaObra1 = new LancNeo.dsBuscaObra(); this.label1 = new System.Windows.Forms.Label(); this.Fecha = new System.Windows.Forms.Label(); this.cmbConcretera = new System.Windows.Forms.ComboBox(); this.cmbPlanta = new System.Windows.Forms.ComboBox(); this.txtIdobra = new System.Windows.Forms.TextBox(); this.sqlDAConcreto = new System.Data.SqlClient.SqlDataAdapter(); this.sqlCommand2 = new System.Data.SqlClient.SqlCommand(); this.crvRepPromedios = new CrystalDecisions.Windows.Forms.CrystalReportViewer(); this.sqlDAPromedios = new System.Data.SqlClient.SqlDataAdapter(); this.sqlSelectCommand2 = new System.Data.SqlClient.SqlCommand(); this.dsPromedios1 = new LancNeo.dsPromedios(); this.cryRepPromedios1 = new LancNeo.CryRepPromedios(); this.dsMuestra1 = new LancNeo.dsMuestra(); this.sqlDADiametro = new System.Data.SqlClient.SqlDataAdapter(); this.sqlSelectCommand9 = new System.Data.SqlClient.SqlCommand(); this.sqlDATipo = new System.Data.SqlClient.SqlDataAdapter(); this.sqlSelectCommand11 = new System.Data.SqlClient.SqlCommand(); this.dsTipo1 = new LancNeo.dsTipo(); this.cmbTipo = new System.Windows.Forms.ComboBox(); ((System.ComponentModel.ISupportInitialize)(this.dsUnidad1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.dsPlanta1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.dsConcretera1)).BeginInit(); this.panel1.SuspendLayout(); ((System.ComponentModel.ISupportInitialize)(this.dsConcreto1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.dsDiametro1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.dsBuscaObra1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.dsPromedios1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.dsMuestra1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.dsTipo1)).BeginInit(); this.SuspendLayout(); // // sqlConn // this.sqlConn.ConnectionString = ((string)(configurationAppSettings.GetValue("sqlConn.ConnectionString", typeof(string)))); this.sqlConn.FireInfoMessageEventOnUserErrors = false; // // sqlDAUnidad // this.sqlDAUnidad.SelectCommand = this.sqlSelectCommand1; this.sqlDAUnidad.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping("Table", "Unidad", new System.Data.Common.DataColumnMapping[] { new System.Data.Common.DataColumnMapping("IdUnidad", "IdUnidad"), new System.Data.Common.DataColumnMapping("Factor", "Factor"), new System.Data.Common.DataColumnMapping("Undescr", "Undescr"), new System.Data.Common.DataColumnMapping("MaxagrUn", "MaxagrUn"), new System.Data.Common.DataColumnMapping("RevenUn", "RevenUn") }) }); // // sqlSelectCommand1 // this.sqlSelectCommand1.CommandText = "SELECT IdUnidad, Factor, Undescr, MaxagrUn, RevenUn FROM Unidad"; this.sqlSelectCommand1.Connection = this.sqlConn; // // sqlDAConcretera // this.sqlDAConcretera.SelectCommand = this.sqlSelectCommand5; this.sqlDAConcretera.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping("Table", "Concretera", new System.Data.Common.DataColumnMapping[] { new System.Data.Common.DataColumnMapping("IdConcretera", "IdConcretera"), new System.Data.Common.DataColumnMapping("Concretera", "Concretera"), new System.Data.Common.DataColumnMapping("Direccion", "Direccion") }) }); // // sqlSelectCommand5 // this.sqlSelectCommand5.CommandText = "SELECT IdConcretera, Concretera, Direccion FROM Concretera"; this.sqlSelectCommand5.Connection = this.sqlConn; // // sqlDAPLanta // this.sqlDAPLanta.SelectCommand = this.sqlSelectCommand6; this.sqlDAPLanta.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping("Table", "Planta", new System.Data.Common.DataColumnMapping[] { new System.Data.Common.DataColumnMapping("IdConcretera", "IdConcretera"), new System.Data.Common.DataColumnMapping("IdPlanta", "IdPlanta"), new System.Data.Common.DataColumnMapping("Planta", "Planta") }) }); // // sqlSelectCommand6 // this.sqlSelectCommand6.CommandText = "SELECT IdConcretera, IdPlanta, Planta FROM Planta WHERE (IdConcretera LIKE @IdCon" + "cretera)"; this.sqlSelectCommand6.Connection = this.sqlConn; this.sqlSelectCommand6.Parameters.AddRange(new System.Data.SqlClient.SqlParameter[] { new System.Data.SqlClient.SqlParameter("@IdConcretera", System.Data.SqlDbType.NVarChar, 10, "IdConcretera") }); // // sqlDABusObra // this.sqlDABusObra.SelectCommand = this.sqlCommand1; this.sqlDABusObra.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping("Table", "Obra", new System.Data.Common.DataColumnMapping[] { new System.Data.Common.DataColumnMapping("Idobra", "Idobra"), new System.Data.Common.DataColumnMapping("Ubicacion", "Ubicacion"), new System.Data.Common.DataColumnMapping("RFC", "RFC"), new System.Data.Common.DataColumnMapping("Facturar", "Facturar") }) }); // // sqlCommand1 // this.sqlCommand1.CommandText = resources.GetString("sqlCommand1.CommandText"); this.sqlCommand1.Connection = this.sqlConn; // // dsUnidad1 // this.dsUnidad1.DataSetName = "dsUnidad"; this.dsUnidad1.Locale = new System.Globalization.CultureInfo("es-MX"); this.dsUnidad1.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema; // // dsPlanta1 // this.dsPlanta1.DataSetName = "dsPlanta"; this.dsPlanta1.Locale = new System.Globalization.CultureInfo("es-MX"); this.dsPlanta1.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema; // // dsConcretera1 // this.dsConcretera1.DataSetName = "dsConcretera"; this.dsConcretera1.Locale = new System.Globalization.CultureInfo("es-MX"); this.dsConcretera1.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema; // // panel1 // this.panel1.BackColor = System.Drawing.SystemColors.Highlight; this.panel1.Controls.Add(this.btnVistaPrevia); this.panel1.Controls.Add(this.buscaBtn1); this.panel1.Controls.Add(this.cmbTipo); this.panel1.Controls.Add(this.chbLab); this.panel1.Controls.Add(this.cmbIdDiam); this.panel1.Controls.Add(this.label14); this.panel1.Controls.Add(this.textBox1); this.panel1.Controls.Add(this.cbkPrefijo); this.panel1.Controls.Add(this.label9); this.panel1.Controls.Add(this.label8); this.panel1.Controls.Add(this.cmbUnidad); this.panel1.Controls.Add(this.label5); this.panel1.Controls.Add(this.dtpFin); this.panel1.Controls.Add(this.label4); this.panel1.Controls.Add(this.dtpIni); this.panel1.Controls.Add(this.label3); this.panel1.Controls.Add(this.label2); this.panel1.Controls.Add(this.cmbIdObra); this.panel1.Controls.Add(this.label1); this.panel1.Controls.Add(this.Fecha); this.panel1.Controls.Add(this.cmbConcretera); this.panel1.Controls.Add(this.cmbPlanta); this.panel1.Controls.Add(this.txtIdobra); this.panel1.Dock = System.Windows.Forms.DockStyle.Top; this.panel1.Location = new System.Drawing.Point(0, 0); this.panel1.Name = "panel1"; this.panel1.Size = new System.Drawing.Size(1046, 78); this.panel1.TabIndex = 10; // // buscaBtn1 // this.buscaBtn1.AnchoDlgBusq = 450; this.buscaBtn1.BackColor = System.Drawing.Color.Transparent; this.buscaBtn1.Datos = this.dsConcreto1.Muestras; this.buscaBtn1.Icon = ((System.Drawing.Icon)(resources.GetObject("buscaBtn1.Icon"))); this.buscaBtn1.Location = new System.Drawing.Point(360, 0); this.buscaBtn1.Name = "buscaBtn1"; this.buscaBtn1.Size = new System.Drawing.Size(64, 64); this.buscaBtn1.TabIndex = 2; this.buscaBtn1.Visible = false; this.buscaBtn1.Click += new System.EventHandler(this.buscaBtn1_Click); // // dsConcreto1 // this.dsConcreto1.DataSetName = "dsConcreto"; this.dsConcreto1.Locale = new System.Globalization.CultureInfo("es-MX"); this.dsConcreto1.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema; // // btnVistaPrevia // this.btnVistaPrevia.BackColor = System.Drawing.Color.Transparent; this.btnVistaPrevia.Icon = ((System.Drawing.Icon)(resources.GetObject("btnVistaPrevia.Icon"))); this.btnVistaPrevia.Location = new System.Drawing.Point(792, 8); this.btnVistaPrevia.Name = "btnVistaPrevia"; this.btnVistaPrevia.Size = new System.Drawing.Size(64, 64); this.btnVistaPrevia.TabIndex = 11; this.btnVistaPrevia.Visible = false; this.btnVistaPrevia.Click += new System.EventHandler(this.btnVistaPrevia_Click); // // chbLab // this.chbLab.Checked = true; this.chbLab.CheckState = System.Windows.Forms.CheckState.Checked; this.chbLab.Location = new System.Drawing.Point(440, 52); this.chbLab.Name = "chbLab"; this.chbLab.Size = new System.Drawing.Size(116, 24); this.chbLab.TabIndex = 77; this.chbLab.Text = "Incluye laboratorio"; // // cmbIdDiam // this.cmbIdDiam.DataSource = this.dsDiametro1; this.cmbIdDiam.DisplayMember = "Diametro.Figura"; this.cmbIdDiam.Location = new System.Drawing.Point(224, 28); this.cmbIdDiam.Name = "cmbIdDiam"; this.cmbIdDiam.Size = new System.Drawing.Size(128, 21); this.cmbIdDiam.TabIndex = 76; this.cmbIdDiam.ValueMember = "IdDiam"; // // dsDiametro1 // this.dsDiametro1.DataSetName = "dsDiametro"; this.dsDiametro1.Locale = new System.Globalization.CultureInfo("es-MX"); this.dsDiametro1.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema; // // label14 // this.label14.AutoSize = true; this.label14.Location = new System.Drawing.Point(144, 28); this.label14.Name = "label14"; this.label14.Size = new System.Drawing.Size(74, 13); this.label14.TabIndex = 75; this.label14.Text = "F. geométrica:"; this.label14.TextAlign = System.Drawing.ContentAlignment.TopRight; // // textBox1 // this.textBox1.Location = new System.Drawing.Point(16, 48); this.textBox1.Name = "textBox1"; this.textBox1.Size = new System.Drawing.Size(76, 20); this.textBox1.TabIndex = 74; this.textBox1.Text = "textBox1"; this.textBox1.Visible = false; // // cbkPrefijo // this.cbkPrefijo.Checked = true; this.cbkPrefijo.CheckState = System.Windows.Forms.CheckState.Checked; this.cbkPrefijo.Location = new System.Drawing.Point(112, 48); this.cbkPrefijo.Name = "cbkPrefijo"; this.cbkPrefijo.Size = new System.Drawing.Size(74, 24); this.cbkPrefijo.TabIndex = 73; this.cbkPrefijo.Text = "No prefijo"; this.cbkPrefijo.CheckedChanged += new System.EventHandler(this.cbkPrefijo_CheckedChanged); // // label9 // this.label9.AutoSize = true; this.label9.Location = new System.Drawing.Point(672, 30); this.label9.Name = "label9"; this.label9.Size = new System.Drawing.Size(40, 13); this.label9.TabIndex = 24; this.label9.Text = "Planta:"; this.label9.TextAlign = System.Drawing.ContentAlignment.MiddleRight; // // label8 // this.label8.AutoSize = true; this.label8.Location = new System.Drawing.Point(648, 6); this.label8.Name = "label8"; this.label8.Size = new System.Drawing.Size(62, 13); this.label8.TabIndex = 23; this.label8.Text = "Concretera:"; this.label8.TextAlign = System.Drawing.ContentAlignment.MiddleRight; // // cmbUnidad // this.cmbUnidad.DataSource = this.dsUnidad1.Unidad; this.cmbUnidad.DisplayMember = "Undescr"; this.cmbUnidad.Location = new System.Drawing.Point(696, 52); this.cmbUnidad.Name = "cmbUnidad"; this.cmbUnidad.Size = new System.Drawing.Size(84, 21); this.cmbUnidad.TabIndex = 10; this.cmbUnidad.ValueMember = "IdUnidad"; // // label5 // this.label5.AutoSize = true; this.label5.Location = new System.Drawing.Point(656, 54); this.label5.Name = "label5"; this.label5.Size = new System.Drawing.Size(44, 13); this.label5.TabIndex = 13; this.label5.Text = "Unidad:"; // // dtpFin // this.dtpFin.Format = System.Windows.Forms.DateTimePickerFormat.Short; this.dtpFin.Location = new System.Drawing.Point(560, 28); this.dtpFin.Name = "dtpFin"; this.dtpFin.Size = new System.Drawing.Size(84, 20); this.dtpFin.TabIndex = 4; // // label4 // this.label4.AutoSize = true; this.label4.Location = new System.Drawing.Point(524, 32); this.label4.Name = "label4"; this.label4.Size = new System.Drawing.Size(32, 13); this.label4.TabIndex = 11; this.label4.Text = "Final:"; // // dtpIni // this.dtpIni.Format = System.Windows.Forms.DateTimePickerFormat.Short; this.dtpIni.Location = new System.Drawing.Point(560, 4); this.dtpIni.Name = "dtpIni"; this.dtpIni.Size = new System.Drawing.Size(84, 20); this.dtpIni.TabIndex = 3; // // label3 // this.label3.AutoSize = true; this.label3.Location = new System.Drawing.Point(520, 6); this.label3.Name = "label3"; this.label3.Size = new System.Drawing.Size(37, 13); this.label3.TabIndex = 9; this.label3.Text = "Inicial:"; // // label2 // this.label2.AutoSize = true; this.label2.Location = new System.Drawing.Point(192, 6); this.label2.Name = "label2"; this.label2.Size = new System.Drawing.Size(33, 13); this.label2.TabIndex = 8; this.label2.Text = "Obra:"; // // cmbIdObra // this.cmbIdObra.DataSource = this.dsBuscaObra1.Obra; this.cmbIdObra.DisplayMember = "Idobra"; this.cmbIdObra.Location = new System.Drawing.Point(224, 4); this.cmbIdObra.Name = "cmbIdObra"; this.cmbIdObra.Size = new System.Drawing.Size(80, 21); this.cmbIdObra.TabIndex = 1; this.cmbIdObra.ValueMember = "IdObra"; this.cmbIdObra.SelectedIndexChanged += new System.EventHandler(this.cmbIdObra_SelectedIndexChanged); // // dsBuscaObra1 // this.dsBuscaObra1.DataSetName = "dsBuscaObra"; this.dsBuscaObra1.Locale = new System.Globalization.CultureInfo("es-MX"); this.dsBuscaObra1.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema; // // label1 // this.label1.AutoSize = true; this.label1.Font = new System.Drawing.Font("Microsoft Sans Serif", 14F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0))); this.label1.Location = new System.Drawing.Point(8, 0); this.label1.Name = "label1"; this.label1.Size = new System.Drawing.Size(187, 24); this.label1.TabIndex = 0; this.label1.Text = "Análisis promedios"; // // Fecha // this.Fecha.AutoSize = true; this.Fecha.Location = new System.Drawing.Point(424, 6); this.Fecha.Name = "Fecha"; this.Fecha.Size = new System.Drawing.Size(95, 13); this.Fecha.TabIndex = 4; this.Fecha.Text = "Fechas de periodo"; // // cmbConcretera // this.cmbConcretera.DataSource = this.dsConcretera1.Concretera; this.cmbConcretera.DisplayMember = "Concretera"; this.cmbConcretera.Location = new System.Drawing.Point(712, 4); this.cmbConcretera.Name = "cmbConcretera"; this.cmbConcretera.Size = new System.Drawing.Size(68, 21); this.cmbConcretera.TabIndex = 5; this.cmbConcretera.ValueMember = "IdConcretera"; // // cmbPlanta // this.cmbPlanta.DataSource = this.dsPlanta1.Planta; this.cmbPlanta.DisplayMember = "Planta"; this.cmbPlanta.Enabled = false; this.cmbPlanta.Location = new System.Drawing.Point(712, 28); this.cmbPlanta.Name = "cmbPlanta"; this.cmbPlanta.Size = new System.Drawing.Size(68, 21); this.cmbPlanta.TabIndex = 6; this.cmbPlanta.ValueMember = "IdPlanta"; // // txtIdobra // this.txtIdobra.Location = new System.Drawing.Point(368, 24); this.txtIdobra.Name = "txtIdobra"; this.txtIdobra.ReadOnly = true; this.txtIdobra.Size = new System.Drawing.Size(48, 20); this.txtIdobra.TabIndex = 2; this.txtIdobra.Visible = false; // // sqlDAConcreto // this.sqlDAConcreto.SelectCommand = this.sqlCommand2; this.sqlDAConcreto.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping("Table", "Muestras", new System.Data.Common.DataColumnMapping[] { new System.Data.Common.DataColumnMapping("IdObra", "IdObra"), new System.Data.Common.DataColumnMapping("Resistencia", "Resistencia"), new System.Data.Common.DataColumnMapping("Tipo", "Tipo"), new System.Data.Common.DataColumnMapping("T.M.A.", "T.M.A."), new System.Data.Common.DataColumnMapping("Rev.", "Rev."), new System.Data.Common.DataColumnMapping("T. A.", "T. A.") }) }); // // sqlCommand2 // this.sqlCommand2.CommandText = resources.GetString("sqlCommand2.CommandText"); this.sqlCommand2.Connection = this.sqlConn; this.sqlCommand2.Parameters.AddRange(new System.Data.SqlClient.SqlParameter[] { new System.Data.SqlClient.SqlParameter("@IdObra", System.Data.SqlDbType.NVarChar, 6, "IdObra") }); // // crvRepPromedios // this.crvRepPromedios.ActiveViewIndex = -1; this.crvRepPromedios.BorderStyle = System.Windows.Forms.BorderStyle.FixedSingle; this.crvRepPromedios.Cursor = System.Windows.Forms.Cursors.Default; this.crvRepPromedios.Dock = System.Windows.Forms.DockStyle.Fill; this.crvRepPromedios.EnableRefresh = false; this.crvRepPromedios.Location = new System.Drawing.Point(0, 78); this.crvRepPromedios.Name = "crvRepPromedios"; this.crvRepPromedios.ShowCloseButton = false; this.crvRepPromedios.ShowGroupTreeButton = false; this.crvRepPromedios.ShowLogo = false; this.crvRepPromedios.ShowRefreshButton = false; this.crvRepPromedios.Size = new System.Drawing.Size(1046, 670); this.crvRepPromedios.TabIndex = 11; this.crvRepPromedios.ToolPanelView = CrystalDecisions.Windows.Forms.ToolPanelViewType.None; this.crvRepPromedios.ToolPanelWidth = 167; // // sqlDAPromedios // this.sqlDAPromedios.SelectCommand = this.sqlSelectCommand2; // // sqlSelectCommand2 // this.sqlSelectCommand2.CommandText = "[Promedios]"; this.sqlSelectCommand2.CommandType = System.Data.CommandType.StoredProcedure; this.sqlSelectCommand2.Connection = this.sqlConn; this.sqlSelectCommand2.Parameters.AddRange(new System.Data.SqlClient.SqlParameter[] { new System.Data.SqlClient.SqlParameter("@RETURN_VALUE", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.ReturnValue, false, ((byte)(0)), ((byte)(0)), "", System.Data.DataRowVersion.Current, null), new System.Data.SqlClient.SqlParameter("@IdObra", System.Data.SqlDbType.NVarChar, 6), new System.Data.SqlClient.SqlParameter("@IdConcretera", System.Data.SqlDbType.NVarChar, 10), new System.Data.SqlClient.SqlParameter("@IdPlanta", System.Data.SqlDbType.SmallInt, 2), new System.Data.SqlClient.SqlParameter("@FechaIni", System.Data.SqlDbType.DateTime, 8), new System.Data.SqlClient.SqlParameter("@FechaFin", System.Data.SqlDbType.DateTime, 8), new System.Data.SqlClient.SqlParameter("@ResistenciaKG", System.Data.SqlDbType.Real, 4), new System.Data.SqlClient.SqlParameter("@Tipo", System.Data.SqlDbType.Int, 4), new System.Data.SqlClient.SqlParameter("@Agregado", System.Data.SqlDbType.Real, 4), new System.Data.SqlClient.SqlParameter("@Renvenimiento", System.Data.SqlDbType.Real, 4), new System.Data.SqlClient.SqlParameter("@IdAgregado", System.Data.SqlDbType.Int, 4), new System.Data.SqlClient.SqlParameter("@IdPrueba", System.Data.SqlDbType.SmallInt, 2), new System.Data.SqlClient.SqlParameter("@IdUnidad", System.Data.SqlDbType.SmallInt, 2), new System.Data.SqlClient.SqlParameter("@Todos", System.Data.SqlDbType.Bit, 1), new System.Data.SqlClient.SqlParameter("@IdDiam", System.Data.SqlDbType.SmallInt, 2) }); // // dsPromedios1 // this.dsPromedios1.DataSetName = "dsPromedios"; this.dsPromedios1.Locale = new System.Globalization.CultureInfo("en-US"); this.dsPromedios1.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema; // // dsMuestra1 // this.dsMuestra1.DataSetName = "dsMuestra"; this.dsMuestra1.Locale = new System.Globalization.CultureInfo("es-MX"); this.dsMuestra1.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema; // // sqlDADiametro // this.sqlDADiametro.SelectCommand = this.sqlSelectCommand9; this.sqlDADiametro.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping("Table", "Diametro", new System.Data.Common.DataColumnMapping[] { new System.Data.Common.DataColumnMapping("IdDiam", "IdDiam"), new System.Data.Common.DataColumnMapping("Diametro", "Diametro") }) }); // // sqlSelectCommand9 // this.sqlSelectCommand9.CommandText = "SELECT IdDiam, Diametro, Diametro + \' \' + Figura AS Figura FROM Diametro"; this.sqlSelectCommand9.Connection = this.sqlConn; // // sqlDATipo // this.sqlDATipo.SelectCommand = this.sqlSelectCommand11; this.sqlDATipo.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping("Table", "Tipo", new System.Data.Common.DataColumnMapping[] { new System.Data.Common.DataColumnMapping("Tipo", "Tipo"), new System.Data.Common.DataColumnMapping("DesTipo", "DesTipo") }) }); // // sqlSelectCommand11 // this.sqlSelectCommand11.CommandText = "SELECT Tipo, DesTipo FROM Tipo ORDER BY Tipo"; this.sqlSelectCommand11.Connection = this.sqlConn; // // dsTipo1 // this.dsTipo1.DataSetName = "dsTipo"; this.dsTipo1.Locale = new System.Globalization.CultureInfo("es-MX"); this.dsTipo1.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema; // // cmbTipo // this.cmbTipo.DataSource = this.dsTipo1; this.cmbTipo.DisplayMember = "Tipo.DesTipo"; this.cmbTipo.Location = new System.Drawing.Point(560, 52); this.cmbTipo.Name = "cmbTipo"; this.cmbTipo.Size = new System.Drawing.Size(64, 21); this.cmbTipo.TabIndex = 78; this.cmbTipo.ValueMember = "Tipo.Tipo"; // // RepPromedios // this.AutoScaleBaseSize = new System.Drawing.Size(5, 13); this.ClientSize = new System.Drawing.Size(1046, 748); this.Controls.Add(this.crvRepPromedios); this.Controls.Add(this.panel1); this.Name = "RepPromedios"; this.Text = "RepPromedios"; this.WindowState = System.Windows.Forms.FormWindowState.Maximized; this.Load += new System.EventHandler(this.RepPromedios_Load); ((System.ComponentModel.ISupportInitialize)(this.dsUnidad1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.dsPlanta1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.dsConcretera1)).EndInit(); this.panel1.ResumeLayout(false); this.panel1.PerformLayout(); ((System.ComponentModel.ISupportInitialize)(this.dsConcreto1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.dsDiametro1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.dsBuscaObra1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.dsPromedios1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.dsMuestra1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.dsTipo1)).EndInit(); this.ResumeLayout(false); }
/// <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); }