/// <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.Configuration.AppSettingsReader configurationAppSettings = new System.Configuration.AppSettingsReader(); System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(InfVolimetrica)); this.sqlDAInfVolumetrica = new System.Data.SqlClient.SqlDataAdapter(); this.sqlSelectCommand1 = new System.Data.SqlClient.SqlCommand(); this.sqlConn = new System.Data.SqlClient.SqlConnection(); this.dsInfVolumetrica1 = new LancNeo.dsInfVolumetrica(); this.dsFirmas1 = new LancNeo.dsFirmas(); this.sqlDAFirmas = new System.Data.SqlClient.SqlDataAdapter(); this.sqlSelectCommand7 = new System.Data.SqlClient.SqlCommand(); this.dsBusObra1 = new LancNeo.dsBusObra(); this.sqlDABusObra = new System.Data.SqlClient.SqlDataAdapter(); this.sqlCommand1 = new System.Data.SqlClient.SqlCommand(); this.panel1 = new System.Windows.Forms.Panel(); this.buscaBtn1 = new Soluciones2000.Tools.WinLib.BuscaBtn(); this.dsVolumetricaInf1 = new LancNeo.dsVolumetricaInf(); this.btnVistaPrevia = new Soluciones2000.Tools.WinLib.tbBtn(); this.chbTodos = 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.txtFolioFin = new System.Windows.Forms.TextBox(); this.txtFolioIni = new System.Windows.Forms.TextBox(); 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.chbDuplicado = new System.Windows.Forms.CheckBox(); this.sqlDAVolumentricaInf = new System.Data.SqlClient.SqlDataAdapter(); this.sqlSelectCommand2 = new System.Data.SqlClient.SqlCommand(); this.crvInfVolumetrica = new CrystalDecisions.Windows.Forms.CrystalReportViewer(); this.cryRepVolumetrica1 = new LancNeo.CryRepVolumetrica(); this.sqlDANorma = new System.Data.SqlClient.SqlDataAdapter(); this.sqlSelectCommand3 = new System.Data.SqlClient.SqlCommand(); this.chbRespaldo = new System.Windows.Forms.CheckBox(); ((System.ComponentModel.ISupportInitialize)(this.dsInfVolumetrica1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.dsFirmas1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.dsBusObra1)).BeginInit(); this.panel1.SuspendLayout(); ((System.ComponentModel.ISupportInitialize)(this.dsVolumetricaInf1)).BeginInit(); this.SuspendLayout(); // // sqlDAInfVolumetrica // this.sqlDAInfVolumetrica.SelectCommand = this.sqlSelectCommand1; this.sqlDAInfVolumetrica.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping("Table", "VolumetricoRep", 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("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("Prueba", "Prueba"), new System.Data.Common.DataColumnMapping("Fecha", "Fecha"), new System.Data.Common.DataColumnMapping("IdLaboratorio", "IdLaboratorio"), new System.Data.Common.DataColumnMapping("Material", "Material"), new System.Data.Common.DataColumnMapping("Tipoprueba", "Tipoprueba"), new System.Data.Common.DataColumnMapping("Masa", "Masa"), new System.Data.Common.DataColumnMapping("Optimo", "Optimo"), 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 = "[VolumetricoRep]"; 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("@FolioIni", System.Data.SqlDbType.VarChar, 10), new System.Data.SqlClient.SqlParameter("@FOlioFin", System.Data.SqlDbType.VarChar, 10) }); // // sqlConn // this.sqlConn.ConnectionString = ((string)(configurationAppSettings.GetValue("sqlConn.ConnectionString", typeof(string)))); this.sqlConn.FireInfoMessageEventOnUserErrors = false; // // dsInfVolumetrica1 // this.dsInfVolumetrica1.DataSetName = "dsInfVolumetrica"; this.dsInfVolumetrica1.Locale = new System.Globalization.CultureInfo("es-MX"); this.dsInfVolumetrica1.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; // // 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 (Volumetrica < 6)\r\nORDER BY Volumetrica"; 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; // // 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; // // 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.chbLab); this.panel1.Controls.Add(this.chbLeyenda); this.panel1.Controls.Add(this.chbFormato); this.panel1.Controls.Add(this.txtFolioFin); this.panel1.Controls.Add(this.txtFolioIni); 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.Controls.Add(this.chbDuplicado); 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, 97); this.panel1.TabIndex = 12; 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.dsVolumetricaInf1.Volumetrico; this.buscaBtn1.Icon = ((System.Drawing.Icon)(resources.GetObject("buscaBtn1.Icon"))); this.buscaBtn1.Location = new System.Drawing.Point(418, 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); // // dsVolumetricaInf1 // this.dsVolumetricaInf1.DataSetName = "dsVolumetricaInf"; this.dsVolumetricaInf1.Locale = new System.Globalization.CultureInfo("es-MX"); this.dsVolumetricaInf1.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(657, 5); 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); // // chbTodos // this.chbTodos.ForeColor = System.Drawing.Color.White; this.chbTodos.Location = new System.Drawing.Point(481, 69); this.chbTodos.Name = "chbTodos"; this.chbTodos.Size = new System.Drawing.Size(138, 25); this.chbTodos.TabIndex = 37; this.chbTodos.Text = "Todos los informes"; // // 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(341, 69); this.chbLab.Name = "chbLab"; this.chbLab.Size = new System.Drawing.Size(137, 25); this.chbLab.TabIndex = 36; this.chbLab.Text = "Incluye laboratorio"; // // chbLeyenda // this.chbLeyenda.ForeColor = System.Drawing.Color.White; this.chbLeyenda.Location = new System.Drawing.Point(202, 69); this.chbLeyenda.Name = "chbLeyenda"; this.chbLeyenda.Size = new System.Drawing.Size(116, 25); this.chbLeyenda.TabIndex = 35; this.chbLeyenda.Text = "Formato leyenda"; // // chbFormato // this.chbFormato.ForeColor = System.Drawing.Color.White; this.chbFormato.Location = new System.Drawing.Point(14, 69); this.chbFormato.Name = "chbFormato"; this.chbFormato.Size = new System.Drawing.Size(180, 25); this.chbFormato.TabIndex = 34; this.chbFormato.Text = "Incluye imagen de acreditación"; // // txtFolioFin // this.txtFolioFin.Location = new System.Drawing.Point(556, 40); this.txtFolioFin.Name = "txtFolioFin"; this.txtFolioFin.Size = new System.Drawing.Size(54, 20); this.txtFolioFin.TabIndex = 28; this.txtFolioFin.Visible = false; // // txtFolioIni // this.txtFolioIni.Location = new System.Drawing.Point(556, 12); this.txtFolioIni.Name = "txtFolioIni"; this.txtFolioIni.Size = new System.Drawing.Size(54, 20); this.txtFolioIni.TabIndex = 27; // // label4 // this.label4.AutoSize = true; this.label4.ForeColor = System.Drawing.Color.White; this.label4.Location = new System.Drawing.Point(494, 42); 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(486, 14); 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.Location = new System.Drawing.Point(302, 10); 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(334, 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); // // 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(290, 68); this.label1.TabIndex = 0; this.label1.Text = "Informe de Resultados de Masa Volumétrica Seca Máxima y contenido de agua óptimo"; // // txtIdobra // this.txtIdobra.Location = new System.Drawing.Point(422, 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; // // chbDuplicado // this.chbDuplicado.ForeColor = System.Drawing.Color.White; this.chbDuplicado.Location = new System.Drawing.Point(326, 38); this.chbDuplicado.Name = "chbDuplicado"; this.chbDuplicado.Size = new System.Drawing.Size(88, 24); this.chbDuplicado.TabIndex = 30; this.chbDuplicado.Text = "¿Duplicado?"; // // sqlDAVolumentricaInf // this.sqlDAVolumentricaInf.SelectCommand = this.sqlSelectCommand2; this.sqlDAVolumentricaInf.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping("Table", "Volumetrico", 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("Finforme", "Finforme"), new System.Data.Common.DataColumnMapping("NoEco", "NoEco"), new System.Data.Common.DataColumnMapping("Semana", "Semana") }) }); // // sqlSelectCommand2 // this.sqlSelectCommand2.CommandText = "SELECT FOLIO, IdObra, ConsObra, Finforme, NoEco, Semana FROM Volumetrico WHERE (I" + "dObra = @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") }); // // crvInfVolumetrica // this.crvInfVolumetrica.ActiveViewIndex = -1; this.crvInfVolumetrica.BorderStyle = System.Windows.Forms.BorderStyle.FixedSingle; this.crvInfVolumetrica.Cursor = System.Windows.Forms.Cursors.Default; this.crvInfVolumetrica.Dock = System.Windows.Forms.DockStyle.Fill; this.crvInfVolumetrica.EnableRefresh = false; this.crvInfVolumetrica.Location = new System.Drawing.Point(0, 97); this.crvInfVolumetrica.Name = "crvInfVolumetrica"; this.crvInfVolumetrica.ShowCloseButton = false; this.crvInfVolumetrica.ShowGroupTreeButton = false; this.crvInfVolumetrica.ShowLogo = false; this.crvInfVolumetrica.ShowParameterPanelButton = false; this.crvInfVolumetrica.Size = new System.Drawing.Size(1028, 457); this.crvInfVolumetrica.TabIndex = 13; this.crvInfVolumetrica.ToolPanelView = CrystalDecisions.Windows.Forms.ToolPanelViewType.None; this.crvInfVolumetrica.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") }) }); this.sqlDANorma.RowUpdated += new System.Data.SqlClient.SqlRowUpdatedEventHandler(this.sqlDataAdapter1_RowUpdated); // // sqlSelectCommand3 // this.sqlSelectCommand3.CommandText = "SELECT IdNorma, Informe, Normas, Titulo, IdInforme FROM Normas WHERE (IdNorma = 1" + "3) ORDER BY IdNorma"; this.sqlSelectCommand3.Connection = this.sqlConn; // // chbRespaldo // this.chbRespaldo.ForeColor = System.Drawing.Color.White; this.chbRespaldo.Location = new System.Drawing.Point(605, 71); this.chbRespaldo.Name = "chbRespaldo"; this.chbRespaldo.Size = new System.Drawing.Size(116, 24); this.chbRespaldo.TabIndex = 46; this.chbRespaldo.Text = "Respaldo"; // // InfVolimetrica // this.AutoScaleBaseSize = new System.Drawing.Size(5, 13); this.ClientSize = new System.Drawing.Size(1028, 554); this.Controls.Add(this.crvInfVolumetrica); this.Controls.Add(this.panel1); this.Name = "InfVolimetrica"; this.WindowState = System.Windows.Forms.FormWindowState.Maximized; this.Load += new System.EventHandler(this.InfVolimetrica_Load); ((System.ComponentModel.ISupportInitialize)(this.dsInfVolumetrica1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.dsFirmas1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.dsBusObra1)).EndInit(); this.panel1.ResumeLayout(false); this.panel1.PerformLayout(); ((System.ComponentModel.ISupportInitialize)(this.dsVolumetricaInf1)).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(InfAgregados)); this.sqlDAInfAgregados = 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.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.panel1 = new System.Windows.Forms.Panel(); this.buscaBtn1 = new Soluciones2000.Tools.WinLib.BuscaBtn(); this.dsAgregadosInf1 = new LancNeo.dsAgregadosInf(); this.btnVistaPrevia = new Soluciones2000.Tools.WinLib.tbBtn(); this.chbTodos = new System.Windows.Forms.CheckBox(); this.chbLab = new System.Windows.Forms.CheckBox(); this.chbLeyenda = new System.Windows.Forms.CheckBox(); this.chbDuplicado = new System.Windows.Forms.CheckBox(); this.txtTamaño = new System.Windows.Forms.TextBox(); this.label5 = new System.Windows.Forms.Label(); this.txtFolioFin = new System.Windows.Forms.TextBox(); this.txtFolioIni = new System.Windows.Forms.TextBox(); 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.chbLab1 = new System.Windows.Forms.CheckBox(); this.sqlDAAgregadosInf = new System.Data.SqlClient.SqlDataAdapter(); this.sqlSelectCommand2 = new System.Data.SqlClient.SqlCommand(); this.crvInfAgregados = new CrystalDecisions.Windows.Forms.CrystalReportViewer(); this.sqlDAInfAgregadosMal = new System.Data.SqlClient.SqlDataAdapter(); this.sqlSelectCommand3 = new System.Data.SqlClient.SqlCommand(); this.dsInfAgregadosMal1 = new LancNeo.dsInfAgregadosMal(); this.pictureBox1 = new System.Windows.Forms.PictureBox(); this.sqlDANorma = new System.Data.SqlClient.SqlDataAdapter(); this.sqlSelectCommand4 = new System.Data.SqlClient.SqlCommand(); this.dsInfAgregados1 = new LancNeo.dsInfAgregados(); this.cryRepAgregados1 = new LancNeo.CryRepAgregados(); this.chbRespaldo = new System.Windows.Forms.CheckBox(); ((System.ComponentModel.ISupportInitialize)(this.dsBusObra1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.dsFirmas1)).BeginInit(); this.panel1.SuspendLayout(); ((System.ComponentModel.ISupportInitialize)(this.dsAgregadosInf1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.dsInfAgregadosMal1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.pictureBox1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.dsInfAgregados1)).BeginInit(); this.SuspendLayout(); // // sqlDAInfAgregados // this.sqlDAInfAgregados.SelectCommand = this.sqlSelectCommand1; this.sqlDAInfAgregados.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping("Table", "AgregadosRep", 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("Material", "Material"), 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("Muestreadas", "Muestreadas"), new System.Data.Common.DataColumnMapping("Procedencia", "Procedencia"), new System.Data.Common.DataColumnMapping("Usarse", "Usarse"), new System.Data.Common.DataColumnMapping("MasaSuelta", "MasaSuelta"), new System.Data.Common.DataColumnMapping("MasaCompacta", "MasaCompacta"), new System.Data.Common.DataColumnMapping("MasaEspecifica", "MasaEspecifica"), new System.Data.Common.DataColumnMapping("Agua", "Agua"), new System.Data.Common.DataColumnMapping("Impureza", "Impureza"), new System.Data.Common.DataColumnMapping("Fino", "Fino"), new System.Data.Common.DataColumnMapping("Finura", "Finura"), 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 = "[AgregadosRep]"; 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, "AFB"), new System.Data.SqlClient.SqlParameter("@FolioIni", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "", System.Data.DataRowVersion.Current, "39/13"), new System.Data.SqlClient.SqlParameter("@FOlioFin", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "", System.Data.DataRowVersion.Current, "39/13") }); // // 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; // // 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; // // 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; // // 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.chbLab); this.panel1.Controls.Add(this.chbLeyenda); this.panel1.Controls.Add(this.chbDuplicado); this.panel1.Controls.Add(this.txtTamaño); this.panel1.Controls.Add(this.label5); this.panel1.Controls.Add(this.txtFolioFin); this.panel1.Controls.Add(this.txtFolioIni); 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.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, 95); this.panel1.TabIndex = 12; 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.dsAgregadosInf1.Agregados; this.buscaBtn1.Icon = ((System.Drawing.Icon)(resources.GetObject("buscaBtn1.Icon"))); this.buscaBtn1.Location = new System.Drawing.Point(332, 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); // // dsAgregadosInf1 // this.dsAgregadosInf1.DataSetName = "dsAgregadosInf"; this.dsAgregadosInf1.Locale = new System.Globalization.CultureInfo("es-MX"); this.dsAgregadosInf1.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(630, 0); this.btnVistaPrevia.Name = "btnVistaPrevia"; this.btnVistaPrevia.Size = new System.Drawing.Size(64, 64); this.btnVistaPrevia.TabIndex = 11; this.btnVistaPrevia.Visible = false; this.btnVistaPrevia.Click += new System.EventHandler(this.btnVistaPrevia_Click); // // chbTodos // this.chbTodos.ForeColor = System.Drawing.Color.White; this.chbTodos.Location = new System.Drawing.Point(400, 28); this.chbTodos.Name = "chbTodos"; this.chbTodos.Size = new System.Drawing.Size(126, 25); this.chbTodos.TabIndex = 76; this.chbTodos.Text = "Todos los informes"; // // 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(210, 54); this.chbLab.Name = "chbLab"; this.chbLab.Size = new System.Drawing.Size(116, 24); this.chbLab.TabIndex = 38; 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(532, 53); this.chbLeyenda.Name = "chbLeyenda"; this.chbLeyenda.Size = new System.Drawing.Size(108, 25); this.chbLeyenda.TabIndex = 32; this.chbLeyenda.Text = "Formato leyenda"; // // chbDuplicado // this.chbDuplicado.ForeColor = System.Drawing.Color.White; this.chbDuplicado.Location = new System.Drawing.Point(212, 26); this.chbDuplicado.Name = "chbDuplicado"; this.chbDuplicado.Size = new System.Drawing.Size(89, 24); this.chbDuplicado.TabIndex = 31; this.chbDuplicado.Text = "¿Duplicado?"; // // txtTamaño // this.txtTamaño.Location = new System.Drawing.Point(532, 32); this.txtTamaño.MaxLength = 25; this.txtTamaño.Name = "txtTamaño"; this.txtTamaño.Size = new System.Drawing.Size(74, 20); this.txtTamaño.TabIndex = 30; // // label5 // this.label5.ForeColor = System.Drawing.Color.White; this.label5.Location = new System.Drawing.Point(537, 2); this.label5.Name = "label5"; this.label5.Size = new System.Drawing.Size(70, 26); this.label5.TabIndex = 29; this.label5.Text = "Tamaño nominal:"; this.label5.TextAlign = System.Drawing.ContentAlignment.BottomCenter; // // txtFolioFin // this.txtFolioFin.Location = new System.Drawing.Point(782, 46); this.txtFolioFin.Name = "txtFolioFin"; this.txtFolioFin.Size = new System.Drawing.Size(54, 20); this.txtFolioFin.TabIndex = 28; this.txtFolioFin.Visible = false; // // txtFolioIni // this.txtFolioIni.Location = new System.Drawing.Point(470, 2); this.txtFolioIni.Name = "txtFolioIni"; this.txtFolioIni.Size = new System.Drawing.Size(54, 20); this.txtFolioIni.TabIndex = 27; // // label4 // this.label4.AutoSize = true; this.label4.ForeColor = System.Drawing.Color.White; this.label4.Location = new System.Drawing.Point(720, 48); 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(400, 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.Location = new System.Drawing.Point(212, 5); 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(243, 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); // // 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(202, 69); this.label1.TabIndex = 0; this.label1.Text = "Informe de calidad de agregados petreos"; // // txtIdobra // this.txtIdobra.Location = new System.Drawing.Point(366, 32); this.txtIdobra.Name = "txtIdobra"; this.txtIdobra.ReadOnly = true; this.txtIdobra.Size = new System.Drawing.Size(48, 20); this.txtIdobra.TabIndex = 2; this.txtIdobra.Visible = false; // // chbLab1 // this.chbLab1.Checked = true; this.chbLab1.CheckState = System.Windows.Forms.CheckState.Checked; this.chbLab1.ForeColor = System.Drawing.Color.White; this.chbLab1.Location = new System.Drawing.Point(718, 0); this.chbLab1.Name = "chbLab1"; this.chbLab1.Size = new System.Drawing.Size(130, 24); this.chbLab1.TabIndex = 75; this.chbLab1.Text = "Incluye laboratorista"; // // sqlDAAgregadosInf // this.sqlDAAgregadosInf.SelectCommand = this.sqlSelectCommand2; this.sqlDAAgregadosInf.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping("Table", "Agregados", new System.Data.Common.DataColumnMapping[] { new System.Data.Common.DataColumnMapping("FOLIO", "FOLIO"), new System.Data.Common.DataColumnMapping("IdObra", "IdObra"), new System.Data.Common.DataColumnMapping("Material", "Material"), 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("Muestreadas", "Muestreadas"), new System.Data.Common.DataColumnMapping("Procedencia", "Procedencia"), new System.Data.Common.DataColumnMapping("Usarse", "Usarse") }) }); // // sqlSelectCommand2 // this.sqlSelectCommand2.CommandText = "SELECT FOLIO, IdObra, Material, ConsObra, Fmuestreo, Fensaye, Finforme, NoEco, Se" + "mana, Muestreadas, Procedencia, Usarse FROM Agregados WHERE (IdObra = @IdObra) O" + "RDER 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") }); // // crvInfAgregados // this.crvInfAgregados.ActiveViewIndex = -1; this.crvInfAgregados.BorderStyle = System.Windows.Forms.BorderStyle.FixedSingle; this.crvInfAgregados.Cursor = System.Windows.Forms.Cursors.Default; this.crvInfAgregados.Dock = System.Windows.Forms.DockStyle.Fill; this.crvInfAgregados.EnableRefresh = false; this.crvInfAgregados.Location = new System.Drawing.Point(0, 95); this.crvInfAgregados.Name = "crvInfAgregados"; this.crvInfAgregados.ShowCloseButton = false; this.crvInfAgregados.ShowGroupTreeButton = false; this.crvInfAgregados.ShowLogo = false; this.crvInfAgregados.Size = new System.Drawing.Size(856, 553); this.crvInfAgregados.TabIndex = 13; this.crvInfAgregados.ToolPanelView = CrystalDecisions.Windows.Forms.ToolPanelViewType.None; // // sqlDAInfAgregadosMal // this.sqlDAInfAgregadosMal.SelectCommand = this.sqlSelectCommand3; this.sqlDAInfAgregadosMal.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping("Table", "AgregadosMal", new System.Data.Common.DataColumnMapping[] { new System.Data.Common.DataColumnMapping("Folio", "Folio"), new System.Data.Common.DataColumnMapping("Renglon", "Renglon"), new System.Data.Common.DataColumnMapping("Grava", "Grava"), new System.Data.Common.DataColumnMapping("GravaSI", "GravaSI"), new System.Data.Common.DataColumnMapping("Arena", "Arena"), new System.Data.Common.DataColumnMapping("ArenaSI", "ArenaSI"), new System.Data.Common.DataColumnMapping("Acumulado", "Acumulado"), new System.Data.Common.DataColumnMapping("Quepasa", "Quepasa"), new System.Data.Common.DataColumnMapping("Nomina", "Nomina"), new System.Data.Common.DataColumnMapping("NominalSup", "NominalSup") }) }); // // 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("@IdFolioFin", System.Data.SqlDbType.Char, 10, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Folio", System.Data.DataRowVersion.Current, "15/14"), new System.Data.SqlClient.SqlParameter("@IdFolioini", System.Data.SqlDbType.Char, 10, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Folio", System.Data.DataRowVersion.Current, "15/14") }); // // dsInfAgregadosMal1 // this.dsInfAgregadosMal1.DataSetName = "dsInfAgregadosMal"; this.dsInfAgregadosMal1.Locale = new System.Globalization.CultureInfo("es-MX"); this.dsInfAgregadosMal1.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema; // // pictureBox1 // this.pictureBox1.Location = new System.Drawing.Point(2, 112); this.pictureBox1.Name = "pictureBox1"; this.pictureBox1.Size = new System.Drawing.Size(276, 402); this.pictureBox1.TabIndex = 74; this.pictureBox1.TabStop = false; this.pictureBox1.Visible = false; // // 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 = 10) ORDER BY IdNorma"; this.sqlSelectCommand4.Connection = this.sqlConn; // // dsInfAgregados1 // this.dsInfAgregados1.DataSetName = "dsInfAgregados"; this.dsInfAgregados1.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema; // // chbRespaldo // this.chbRespaldo.ForeColor = System.Drawing.Color.White; this.chbRespaldo.Location = new System.Drawing.Point(400, 54); this.chbRespaldo.Name = "chbRespaldo"; this.chbRespaldo.Size = new System.Drawing.Size(82, 24); this.chbRespaldo.TabIndex = 81; this.chbRespaldo.Text = "Respaldo"; // // InfAgregados // this.AutoScaleBaseSize = new System.Drawing.Size(5, 13); this.ClientSize = new System.Drawing.Size(856, 648); this.Controls.Add(this.pictureBox1); this.Controls.Add(this.crvInfAgregados); this.Controls.Add(this.panel1); this.Name = "InfAgregados"; this.Text = "InfAgregados"; this.WindowState = System.Windows.Forms.FormWindowState.Maximized; this.Load += new System.EventHandler(this.InfAgregados_Load); ((System.ComponentModel.ISupportInitialize)(this.dsBusObra1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.dsFirmas1)).EndInit(); this.panel1.ResumeLayout(false); this.panel1.PerformLayout(); ((System.ComponentModel.ISupportInitialize)(this.dsAgregadosInf1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.dsInfAgregadosMal1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.pictureBox1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.dsInfAgregados1)).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.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(InfAsfaltico)); System.Configuration.AppSettingsReader configurationAppSettings = new System.Configuration.AppSettingsReader(); this.panel1 = new System.Windows.Forms.Panel(); this.buscaBtn1 = new Soluciones2000.Tools.WinLib.BuscaBtn(); this.dsBusAsfaltico1 = new LancNeo.dsBusAsfaltico(); this.btnVistaPrevia = new Soluciones2000.Tools.WinLib.tbBtn(); this.chbRespaldo = new System.Windows.Forms.CheckBox(); this.chbTodos = new System.Windows.Forms.CheckBox(); this.chbLab = new System.Windows.Forms.CheckBox(); this.chbLeyenda = new System.Windows.Forms.CheckBox(); this.chbDuplicado = new System.Windows.Forms.CheckBox(); this.txtFolioIni = new System.Windows.Forms.TextBox(); this.label3 = 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.pictureBox1 = new System.Windows.Forms.PictureBox(); this.sqlDAInfAsfaltico = new System.Data.SqlClient.SqlDataAdapter(); this.sqlSelectCommand1 = new System.Data.SqlClient.SqlCommand(); this.sqlConn = new System.Data.SqlClient.SqlConnection(); this.dsInfAsfaltico1 = new LancNeo.dsInfAsfaltico(); this.sqlDAInfAsfalticoMal = new System.Data.SqlClient.SqlDataAdapter(); this.sqlSelectCommand2 = new System.Data.SqlClient.SqlCommand(); this.crvInfAsfaltico = new CrystalDecisions.Windows.Forms.CrystalReportViewer(); this.CryRepAsfalto1 = new LancNeo.CryRepAsfalto(); this.dsFirmas1 = new LancNeo.dsFirmas(); this.sqlDAFirmas = new System.Data.SqlClient.SqlDataAdapter(); this.sqlSelectCommand7 = new System.Data.SqlClient.SqlCommand(); this.sqlDABusObra = new System.Data.SqlClient.SqlDataAdapter(); this.sqlCommand1 = new System.Data.SqlClient.SqlCommand(); this.sqlDABusAsfaltico = new System.Data.SqlClient.SqlDataAdapter(); this.sqlCommand2 = new System.Data.SqlClient.SqlCommand(); this.sqlDANorma = new System.Data.SqlClient.SqlDataAdapter(); this.sqlSelectCommand4 = new System.Data.SqlClient.SqlCommand(); this.panel1.SuspendLayout(); ((System.ComponentModel.ISupportInitialize)(this.dsBusAsfaltico1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.dsBusObra1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.pictureBox1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.dsInfAsfaltico1)).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.buscaBtn1); this.panel1.Controls.Add(this.btnVistaPrevia); this.panel1.Controls.Add(this.chbRespaldo); this.panel1.Controls.Add(this.chbTodos); this.panel1.Controls.Add(this.chbLab); this.panel1.Controls.Add(this.chbLeyenda); this.panel1.Controls.Add(this.chbDuplicado); this.panel1.Controls.Add(this.txtFolioIni); 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.Controls.Add(this.pictureBox1); 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, 100); this.panel1.TabIndex = 14; // // buscaBtn1 // this.buscaBtn1.AnchoColTit = true; this.buscaBtn1.AnchoDlgBusq = 650; this.buscaBtn1.BackColor = System.Drawing.Color.Transparent; this.buscaBtn1.Datos = this.dsBusAsfaltico1.Asfaltico; this.buscaBtn1.Icon = ((System.Drawing.Icon)(resources.GetObject("buscaBtn1.Icon"))); this.buscaBtn1.Location = new System.Drawing.Point(547, 2); 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); // // dsBusAsfaltico1 // this.dsBusAsfaltico1.DataSetName = "dsBusAsfaltico"; this.dsBusAsfaltico1.Locale = new System.Globalization.CultureInfo("es-MX"); this.dsBusAsfaltico1.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(780, 3); this.btnVistaPrevia.Name = "btnVistaPrevia"; this.btnVistaPrevia.Size = new System.Drawing.Size(64, 65); this.btnVistaPrevia.TabIndex = 11; this.btnVistaPrevia.Visible = false; this.btnVistaPrevia.Click += new System.EventHandler(this.btnVistaPrevia_Click); // // chbRespaldo // this.chbRespaldo.ForeColor = System.Drawing.Color.White; this.chbRespaldo.Location = new System.Drawing.Point(645, 68); this.chbRespaldo.Name = "chbRespaldo"; this.chbRespaldo.Size = new System.Drawing.Size(82, 24); this.chbRespaldo.TabIndex = 80; this.chbRespaldo.Text = "Respaldo"; // // chbTodos // this.chbTodos.ForeColor = System.Drawing.Color.White; this.chbTodos.Location = new System.Drawing.Point(645, 38); this.chbTodos.Name = "chbTodos"; this.chbTodos.Size = new System.Drawing.Size(137, 25); this.chbTodos.TabIndex = 79; this.chbTodos.Text = "Todos los informes"; // // 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(405, 38); this.chbLab.Name = "chbLab"; this.chbLab.Size = new System.Drawing.Size(116, 25); this.chbLab.TabIndex = 37; this.chbLab.Text = "Incluye laboratorio"; // // chbLeyenda // this.chbLeyenda.ForeColor = System.Drawing.Color.White; this.chbLeyenda.Location = new System.Drawing.Point(525, 69); this.chbLeyenda.Name = "chbLeyenda"; this.chbLeyenda.Size = new System.Drawing.Size(114, 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(405, 68); this.chbDuplicado.Name = "chbDuplicado"; this.chbDuplicado.Size = new System.Drawing.Size(114, 23); this.chbDuplicado.TabIndex = 31; this.chbDuplicado.Text = "¿Duplicado?"; // // txtFolioIni // this.txtFolioIni.Location = new System.Drawing.Point(685, 9); this.txtFolioIni.Name = "txtFolioIni"; this.txtFolioIni.Size = new System.Drawing.Size(54, 20); this.txtFolioIni.TabIndex = 27; // // label3 // this.label3.AutoSize = true; this.label3.ForeColor = System.Drawing.Color.White; this.label3.Location = new System.Drawing.Point(615, 10); 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(432, 5); 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(463, 3); 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(6, 0); this.label1.Name = "label1"; this.label1.Size = new System.Drawing.Size(412, 75); this.label1.TabIndex = 0; this.label1.Text = "Informe de ensaye de concreto asfaltico"; // // txtIdobra // this.txtIdobra.Location = new System.Drawing.Point(570, 36); 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; // // pictureBox1 // this.pictureBox1.Location = new System.Drawing.Point(18, 82); this.pictureBox1.Name = "pictureBox1"; this.pictureBox1.Size = new System.Drawing.Size(570, 430); this.pictureBox1.TabIndex = 78; this.pictureBox1.TabStop = false; this.pictureBox1.Visible = false; // // sqlDAInfAsfaltico // this.sqlDAInfAsfaltico.SelectCommand = this.sqlSelectCommand1; this.sqlDAInfAsfaltico.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping("Table", "AsfalticoRep", 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("Frecibo", "Frecibo"), new System.Data.Common.DataColumnMapping("Lab", "Lab"), new System.Data.Common.DataColumnMapping("Semana", "Semana"), new System.Data.Common.DataColumnMapping("Anos", "Anos"), new System.Data.Common.DataColumnMapping("Hoja", "Hoja"), new System.Data.Common.DataColumnMapping("Observac", "Observac"), new System.Data.Common.DataColumnMapping("Material", "Material"), new System.Data.Common.DataColumnMapping("Usarse", "Usarse"), new System.Data.Common.DataColumnMapping("Tratamietno", "Tratamietno"), new System.Data.Common.DataColumnMapping("Deposito", "Deposito"), new System.Data.Common.DataColumnMapping("Ubicacion", "Ubicacion"), new System.Data.Common.DataColumnMapping("Viaje", "Viaje"), new System.Data.Common.DataColumnMapping("TendidoI", "TendidoI"), new System.Data.Common.DataColumnMapping("TendidoF", "TendidoF"), new System.Data.Common.DataColumnMapping("Carril", "Carril"), new System.Data.Common.DataColumnMapping("Franja", "Franja"), new System.Data.Common.DataColumnMapping("TSalida", "TSalida"), new System.Data.Common.DataColumnMapping("TTendido", "TTendido"), new System.Data.Common.DataColumnMapping("TCompacta", "TCompacta"), new System.Data.Common.DataColumnMapping("MSeca", "MSeca"), new System.Data.Common.DataColumnMapping("MLP", "MLP"), new System.Data.Common.DataColumnMapping("Absor", "Absor"), new System.Data.Common.DataColumnMapping("Desgaste", "Desgaste"), new System.Data.Common.DataColumnMapping("Tritura", "Tritura"), new System.Data.Common.DataColumnMapping("Alarga", "Alarga"), new System.Data.Common.DataColumnMapping("Part", "Part"), new System.Data.Common.DataColumnMapping("Arena", "Arena"), new System.Data.Common.DataColumnMapping("Lineal", "Lineal"), new System.Data.Common.DataColumnMapping("Asfalto", "Asfalto"), new System.Data.Common.DataColumnMapping("Marca", "Marca"), new System.Data.Common.DataColumnMapping("Tipo", "Tipo"), new System.Data.Common.DataColumnMapping("Cantidad", "Cantidad"), new System.Data.Common.DataColumnMapping("Afinidad", "Afinidad"), new System.Data.Common.DataColumnMapping("PMSeca", "PMSeca"), new System.Data.Common.DataColumnMapping("PMLP", "PMLP"), new System.Data.Common.DataColumnMapping("PAbsor", "PAbsor"), new System.Data.Common.DataColumnMapping("PDesgaste", "PDesgaste"), new System.Data.Common.DataColumnMapping("PTritura", "PTritura"), new System.Data.Common.DataColumnMapping("PAlarga", "PAlarga"), new System.Data.Common.DataColumnMapping("PPart", "PPart"), new System.Data.Common.DataColumnMapping("PArena", "PArena"), new System.Data.Common.DataColumnMapping("PLineal", "PLineal"), new System.Data.Common.DataColumnMapping("PAsfalto", "PAsfalto"), new System.Data.Common.DataColumnMapping("PMarca", "PMarca"), new System.Data.Common.DataColumnMapping("PTipo", "PTipo"), new System.Data.Common.DataColumnMapping("PCantidad", "PCantidad"), new System.Data.Common.DataColumnMapping("PAfinidad", "PAfinidad"), new System.Data.Common.DataColumnMapping("Mesp", "Mesp"), new System.Data.Common.DataColumnMapping("Estabilidad", "Estabilidad"), new System.Data.Common.DataColumnMapping("Flujo", "Flujo"), new System.Data.Common.DataColumnMapping("Vacios", "Vacios"), new System.Data.Common.DataColumnMapping("VAM", "VAM"), new System.Data.Common.DataColumnMapping("EMesp", "EMesp"), new System.Data.Common.DataColumnMapping("EEstabilidad", "EEstabilidad"), new System.Data.Common.DataColumnMapping("EFlujo", "EFlujo"), new System.Data.Common.DataColumnMapping("EVacios", "EVacios"), new System.Data.Common.DataColumnMapping("EVAM", "EVAM"), new System.Data.Common.DataColumnMapping("TipoC", "TipoC"), new System.Data.Common.DataColumnMapping("Penetra", "Penetra"), new System.Data.Common.DataColumnMapping("Viscosdad", "Viscosdad"), new System.Data.Common.DataColumnMapping("Recomendad", "Recomendad"), new System.Data.Common.DataColumnMapping("Aplicada", "Aplicada"), new System.Data.Common.DataColumnMapping("Razonsocial", "Razonsocial"), new System.Data.Common.DataColumnMapping("Ubicacion1", "Ubicacion1"), new System.Data.Common.DataColumnMapping("Colonia", "Colonia"), new System.Data.Common.DataColumnMapping("Zona", "Zona") }) }); // // sqlSelectCommand1 // this.sqlSelectCommand1.CommandText = "[AsfalticoRep]"; 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("@FolioIni", 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) }); // // sqlConn // this.sqlConn.ConnectionString = ((string)(configurationAppSettings.GetValue("sqlConn.ConnectionString", typeof(string)))); this.sqlConn.FireInfoMessageEventOnUserErrors = false; // // dsInfAsfaltico1 // this.dsInfAsfaltico1.DataSetName = "dsInfAsfaltico"; this.dsInfAsfaltico1.Locale = new System.Globalization.CultureInfo("en-US"); this.dsInfAsfaltico1.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema; // // sqlDAInfAsfalticoMal // this.sqlDAInfAsfalticoMal.SelectCommand = this.sqlSelectCommand2; this.sqlDAInfAsfalticoMal.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping("Table", "AsfalticoMal", new System.Data.Common.DataColumnMapping[] { new System.Data.Common.DataColumnMapping("Folio", "Folio"), new System.Data.Common.DataColumnMapping("Renglon", "Renglon"), new System.Data.Common.DataColumnMapping("Malla", "Malla"), new System.Data.Common.DataColumnMapping("Linea1", "Linea1"), new System.Data.Common.DataColumnMapping("Linea2", "Linea2"), new System.Data.Common.DataColumnMapping("Quepasa", "Quepasa"), new System.Data.Common.DataColumnMapping("Proyecto", "Proyecto") }) }); // // sqlSelectCommand2 // this.sqlSelectCommand2.CommandText = "SELECT Folio, Renglon, Malla, Linea1, Linea2, Quepasa, Proyecto, Designaci" + "on\r\nFROM AsfalticoMal\r\nWHERE (Folio <= @FolioFin) AND (Folio >" + "= @FolioIni)\r\nORDER BY Folio, Renglon"; this.sqlSelectCommand2.Connection = this.sqlConn; this.sqlSelectCommand2.Parameters.AddRange(new System.Data.SqlClient.SqlParameter[] { new System.Data.SqlClient.SqlParameter("@FolioFin", System.Data.SqlDbType.Char, 10, "Folio"), new System.Data.SqlClient.SqlParameter("@FolioIni", System.Data.SqlDbType.Char, 10, "Folio") }); // // crvInfAsfaltico // this.crvInfAsfaltico.ActiveViewIndex = -1; this.crvInfAsfaltico.BorderStyle = System.Windows.Forms.BorderStyle.FixedSingle; this.crvInfAsfaltico.Cursor = System.Windows.Forms.Cursors.Default; this.crvInfAsfaltico.Dock = System.Windows.Forms.DockStyle.Fill; this.crvInfAsfaltico.EnableRefresh = false; this.crvInfAsfaltico.Location = new System.Drawing.Point(0, 100); this.crvInfAsfaltico.Name = "crvInfAsfaltico"; this.crvInfAsfaltico.ShowCloseButton = false; this.crvInfAsfaltico.ShowGroupTreeButton = false; this.crvInfAsfaltico.ShowLogo = false; this.crvInfAsfaltico.ShowParameterPanelButton = false; this.crvInfAsfaltico.ShowRefreshButton = false; this.crvInfAsfaltico.Size = new System.Drawing.Size(856, 548); this.crvInfAsfaltico.TabIndex = 77; this.crvInfAsfaltico.ToolPanelView = CrystalDecisions.Windows.Forms.ToolPanelViewType.None; // // dsFirmas1 // this.dsFirmas1.DataSetName = "dsFirmas"; this.dsFirmas1.Locale = new System.Globalization.CultureInfo("es-MX"); this.dsFirmas1.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema; // // sqlDAFirmas // this.sqlDAFirmas.SelectCommand = this.sqlSelectCommand7; this.sqlDAFirmas.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping("Table", "Firmas", new System.Data.Common.DataColumnMapping[] { new System.Data.Common.DataColumnMapping("IdFirma", "IdFirma"), new System.Data.Common.DataColumnMapping("Nombre", "Nombre"), new System.Data.Common.DataColumnMapping("Cargo", "Cargo"), new System.Data.Common.DataColumnMapping("Imprime", "Imprime") }) }); // // sqlSelectCommand7 // this.sqlSelectCommand7.CommandText = "SELECT IdFirma, Nombre, Cargo, Imprime\r\nFROM Firmas\r\nWHERE (Impri" + "me = 1) AND (Materiales < 6)\r\nORDER BY Materiales"; 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; // // sqlDABusAsfaltico // this.sqlDABusAsfaltico.SelectCommand = this.sqlCommand2; this.sqlDABusAsfaltico.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping("Table", "Asfaltico", 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("Material", "Material") }) }); // // sqlCommand2 // this.sqlCommand2.CommandText = "SELECT FOLIO, IdObra, ConsObra, Fmuestreo, Fensaye, Finforme, NoEco, Material FRO" + "M Asfaltico WHERE (IdObra = @IdObra) ORDER BY ConsObra DESC, FOLIO"; 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") }); // // 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") }); // // InfAsfaltico // this.AutoScaleBaseSize = new System.Drawing.Size(5, 13); this.ClientSize = new System.Drawing.Size(856, 648); this.Controls.Add(this.crvInfAsfaltico); this.Controls.Add(this.panel1); this.Name = "InfAsfaltico"; this.Text = "InfAsfaltico"; this.WindowState = System.Windows.Forms.FormWindowState.Maximized; this.Load += new System.EventHandler(this.InfAsfaltico_Load); this.panel1.ResumeLayout(false); this.panel1.PerformLayout(); ((System.ComponentModel.ISupportInitialize)(this.dsBusAsfaltico1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.dsBusObra1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.pictureBox1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.dsInfAsfaltico1)).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.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(ToronMdor)); System.Configuration.AppSettingsReader configurationAppSettings = new System.Configuration.AppSettingsReader(); this.panel2 = new System.Windows.Forms.Panel(); this.buscaBtn1 = new Soluciones2000.Tools.WinLib.BuscaBtn(); this.dsToronMdor1 = new LancNeo.dsToronMdor(); this.txtObserva = new System.Windows.Forms.TextBox(); this.txtMuestreadasen = new System.Windows.Forms.TextBox(); this.txtSemana = new System.Windows.Forms.TextBox(); this.cmbNoeco = new System.Windows.Forms.ComboBox(); this.dsLaboratorista1 = new LancNeo.dsLaboratorista(); this.dtpFinforme = new System.Windows.Forms.DateTimePicker(); this.dtpFensaye = new System.Windows.Forms.DateTimePicker(); this.dtpFmuestreo = new System.Windows.Forms.DateTimePicker(); this.txtConsecutivo = new System.Windows.Forms.TextBox(); this.cmbIdObra = new System.Windows.Forms.ComboBox(); this.dsBusObra1 = new LancNeo.dsBusObra(); this.txtFolio = new System.Windows.Forms.TextBox(); this.label10 = new System.Windows.Forms.Label(); this.label9 = new System.Windows.Forms.Label(); this.label8 = new System.Windows.Forms.Label(); this.label7 = new System.Windows.Forms.Label(); this.label6 = new System.Windows.Forms.Label(); this.label5 = new System.Windows.Forms.Label(); this.label4 = new System.Windows.Forms.Label(); this.label3 = new System.Windows.Forms.Label(); this.label2 = new System.Windows.Forms.Label(); this.label1 = new System.Windows.Forms.Label(); this.sqlDAToronMdor = new System.Data.SqlClient.SqlDataAdapter(); this.sqlDeleteCommand1 = new System.Data.SqlClient.SqlCommand(); this.sqlConn = new System.Data.SqlClient.SqlConnection(); this.sqlInsertCommand1 = new System.Data.SqlClient.SqlCommand(); this.sqlSelectCommand1 = new System.Data.SqlClient.SqlCommand(); this.sqlUpdateCommand1 = new System.Data.SqlClient.SqlCommand(); this.sqlDABusObra = new System.Data.SqlClient.SqlDataAdapter(); this.sqlCommand1 = new System.Data.SqlClient.SqlCommand(); this.sqlDALaboratorista = new System.Data.SqlClient.SqlDataAdapter(); this.sqlSelectCommand5 = new System.Data.SqlClient.SqlCommand(); this.txtUsrMov = new System.Windows.Forms.TextBox(); this.label28 = new System.Windows.Forms.Label(); this.panelToolBar.SuspendLayout(); this.panel2.SuspendLayout(); ((System.ComponentModel.ISupportInitialize)(this.dsToronMdor1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.dsLaboratorista1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.dsBusObra1)).BeginInit(); this.SuspendLayout(); // // statusBar1 // this.statusBar1.Location = new System.Drawing.Point(0, 431); this.statusBar1.ShowPanels = true; this.statusBar1.Size = new System.Drawing.Size(584, 22); // // panelToolBar // this.panelToolBar.Size = new System.Drawing.Size(584, 64); // // panel2 // this.panel2.BorderStyle = System.Windows.Forms.BorderStyle.Fixed3D; this.panel2.Controls.Add(this.buscaBtn1); this.panel2.Controls.Add(this.txtUsrMov); this.panel2.Controls.Add(this.label28); this.panel2.Controls.Add(this.txtObserva); this.panel2.Controls.Add(this.txtMuestreadasen); this.panel2.Controls.Add(this.txtSemana); this.panel2.Controls.Add(this.cmbNoeco); this.panel2.Controls.Add(this.dtpFinforme); this.panel2.Controls.Add(this.dtpFensaye); this.panel2.Controls.Add(this.dtpFmuestreo); this.panel2.Controls.Add(this.txtConsecutivo); this.panel2.Controls.Add(this.cmbIdObra); this.panel2.Controls.Add(this.txtFolio); this.panel2.Controls.Add(this.label10); this.panel2.Controls.Add(this.label9); this.panel2.Controls.Add(this.label8); this.panel2.Controls.Add(this.label7); this.panel2.Controls.Add(this.label6); this.panel2.Controls.Add(this.label5); this.panel2.Controls.Add(this.label4); this.panel2.Controls.Add(this.label3); this.panel2.Controls.Add(this.label2); this.panel2.Controls.Add(this.label1); this.panel2.Location = new System.Drawing.Point(24, 66); this.panel2.Name = "panel2"; this.panel2.Size = new System.Drawing.Size(536, 320); this.panel2.TabIndex = 7; // // buscaBtn1 // this.buscaBtn1.AnchoColTit = true; this.buscaBtn1.AnchoDlgBusq = 675; this.buscaBtn1.BackColor = System.Drawing.Color.Transparent; this.buscaBtn1.Datos = this.dsToronMdor1.Toron7AlamMdor; this.buscaBtn1.Icon = ((System.Drawing.Icon)(resources.GetObject("buscaBtn1.Icon"))); this.buscaBtn1.Location = new System.Drawing.Point(202, 6); this.buscaBtn1.Name = "buscaBtn1"; this.buscaBtn1.Size = new System.Drawing.Size(64, 64); this.buscaBtn1.TabIndex = 20; // // dsToronMdor1 // this.dsToronMdor1.DataSetName = "dsToronMdor"; this.dsToronMdor1.Locale = new System.Globalization.CultureInfo("es-MX"); this.dsToronMdor1.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema; // // txtObserva // this.txtObserva.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dsToronMdor1, "Toron7AlamMdor.Observaciones", true)); this.txtObserva.Location = new System.Drawing.Point(126, 238); this.txtObserva.MaxLength = 512; this.txtObserva.Multiline = true; this.txtObserva.Name = "txtObserva"; this.txtObserva.ScrollBars = System.Windows.Forms.ScrollBars.Vertical; this.txtObserva.Size = new System.Drawing.Size(394, 68); this.txtObserva.TabIndex = 19; this.txtObserva.Text = "textBox5"; // // txtMuestreadasen // this.txtMuestreadasen.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dsToronMdor1, "Toron7AlamMdor.MuestreadasEn", true)); this.txtMuestreadasen.Location = new System.Drawing.Point(126, 214); this.txtMuestreadasen.Name = "txtMuestreadasen"; this.txtMuestreadasen.Size = new System.Drawing.Size(100, 20); this.txtMuestreadasen.TabIndex = 18; this.txtMuestreadasen.Text = "textBox4"; // // txtSemana // this.txtSemana.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dsToronMdor1, "Toron7AlamMdor.Semana", true)); this.txtSemana.Location = new System.Drawing.Point(126, 190); this.txtSemana.MaxLength = 2; this.txtSemana.Name = "txtSemana"; this.txtSemana.Size = new System.Drawing.Size(66, 20); this.txtSemana.TabIndex = 17; this.txtSemana.Text = "textBox3"; // // cmbNoeco // this.cmbNoeco.DataBindings.Add(new System.Windows.Forms.Binding("SelectedValue", this.dsToronMdor1, "Toron7AlamMdor.NoEco", true)); this.cmbNoeco.DataSource = this.dsLaboratorista1.Laboratorista; this.cmbNoeco.DisplayMember = "Laboratorista"; this.cmbNoeco.Location = new System.Drawing.Point(126, 166); this.cmbNoeco.Name = "cmbNoeco"; this.cmbNoeco.Size = new System.Drawing.Size(392, 21); this.cmbNoeco.TabIndex = 16; this.cmbNoeco.ValueMember = "NoEco"; // // dsLaboratorista1 // this.dsLaboratorista1.DataSetName = "dsLaboratorista"; this.dsLaboratorista1.Locale = new System.Globalization.CultureInfo("es-MX"); this.dsLaboratorista1.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema; // // dtpFinforme // this.dtpFinforme.CustomFormat = "dd/MM/yyyy"; this.dtpFinforme.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dsToronMdor1, "Toron7AlamMdor.FInforme", true)); this.dtpFinforme.Format = System.Windows.Forms.DateTimePickerFormat.Custom; this.dtpFinforme.Location = new System.Drawing.Point(126, 142); this.dtpFinforme.Name = "dtpFinforme"; this.dtpFinforme.Size = new System.Drawing.Size(84, 20); this.dtpFinforme.TabIndex = 15; // // dtpFensaye // this.dtpFensaye.CustomFormat = "dd/MM/yyyy"; this.dtpFensaye.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dsToronMdor1, "Toron7AlamMdor.FEnsaye", true)); this.dtpFensaye.Format = System.Windows.Forms.DateTimePickerFormat.Custom; this.dtpFensaye.Location = new System.Drawing.Point(126, 118); this.dtpFensaye.Name = "dtpFensaye"; this.dtpFensaye.Size = new System.Drawing.Size(84, 20); this.dtpFensaye.TabIndex = 14; // // dtpFmuestreo // this.dtpFmuestreo.CustomFormat = "dd/MM/yyyy"; this.dtpFmuestreo.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dsToronMdor1, "Toron7AlamMdor.FMuestreo", true)); this.dtpFmuestreo.Format = System.Windows.Forms.DateTimePickerFormat.Custom; this.dtpFmuestreo.Location = new System.Drawing.Point(126, 94); this.dtpFmuestreo.Name = "dtpFmuestreo"; this.dtpFmuestreo.Size = new System.Drawing.Size(84, 20); this.dtpFmuestreo.TabIndex = 13; // // txtConsecutivo // this.txtConsecutivo.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dsToronMdor1, "Toron7AlamMdor.ConsObra", true)); this.txtConsecutivo.Location = new System.Drawing.Point(126, 70); this.txtConsecutivo.MaxLength = 4; this.txtConsecutivo.Name = "txtConsecutivo"; this.txtConsecutivo.Size = new System.Drawing.Size(66, 20); this.txtConsecutivo.TabIndex = 12; this.txtConsecutivo.Text = "textBox2"; // // cmbIdObra // this.cmbIdObra.DataBindings.Add(new System.Windows.Forms.Binding("SelectedValue", this.dsToronMdor1, "Toron7AlamMdor.Idobra", true)); this.cmbIdObra.DataSource = this.dsBusObra1.Obra; this.cmbIdObra.DisplayMember = "Idobra"; this.cmbIdObra.Location = new System.Drawing.Point(126, 46); this.cmbIdObra.Name = "cmbIdObra"; this.cmbIdObra.Size = new System.Drawing.Size(66, 21); this.cmbIdObra.TabIndex = 11; this.cmbIdObra.ValueMember = "Idobra"; // // dsBusObra1 // this.dsBusObra1.DataSetName = "dsBusObra"; this.dsBusObra1.Locale = new System.Globalization.CultureInfo("es-MX"); this.dsBusObra1.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema; // // txtFolio // this.txtFolio.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dsToronMdor1, "Toron7AlamMdor.FOLIO", true)); this.txtFolio.Location = new System.Drawing.Point(126, 22); this.txtFolio.MaxLength = 10; this.txtFolio.Name = "txtFolio"; this.txtFolio.Size = new System.Drawing.Size(64, 20); this.txtFolio.TabIndex = 10; this.txtFolio.Text = "textBox1"; // // label10 // this.label10.AutoSize = true; this.label10.Location = new System.Drawing.Point(30, 240); this.label10.Name = "label10"; this.label10.Size = new System.Drawing.Size(81, 13); this.label10.TabIndex = 9; this.label10.Text = "Observaciones:"; this.label10.TextAlign = System.Drawing.ContentAlignment.MiddleRight; // // label9 // this.label9.AutoSize = true; this.label9.Location = new System.Drawing.Point(25, 216); this.label9.Name = "label9"; this.label9.Size = new System.Drawing.Size(86, 13); this.label9.TabIndex = 8; this.label9.Text = "Muestreadas en:"; this.label9.TextAlign = System.Drawing.ContentAlignment.MiddleRight; // // label8 // this.label8.AutoSize = true; this.label8.Location = new System.Drawing.Point(63, 192); this.label8.Name = "label8"; this.label8.Size = new System.Drawing.Size(49, 13); this.label8.TabIndex = 7; this.label8.Text = "Semana:"; this.label8.TextAlign = System.Drawing.ContentAlignment.MiddleRight; // // label7 // this.label7.AutoSize = true; this.label7.Location = new System.Drawing.Point(36, 168); this.label7.Name = "label7"; this.label7.Size = new System.Drawing.Size(75, 13); this.label7.TabIndex = 6; this.label7.Text = "Ensayado por:"; this.label7.TextAlign = System.Drawing.ContentAlignment.MiddleRight; // // label6 // this.label6.AutoSize = true; this.label6.Location = new System.Drawing.Point(33, 144); this.label6.Name = "label6"; this.label6.Size = new System.Drawing.Size(77, 13); this.label6.TabIndex = 5; this.label6.Text = "Fecha informe:"; this.label6.TextAlign = System.Drawing.ContentAlignment.MiddleRight; // // label5 // this.label5.AutoSize = true; this.label5.Location = new System.Drawing.Point(19, 120); this.label5.Name = "label5"; this.label5.Size = new System.Drawing.Size(92, 13); this.label5.TabIndex = 4; this.label5.Text = "Fecha de ensaye:"; this.label5.TextAlign = System.Drawing.ContentAlignment.MiddleRight; // // label4 // this.label4.AutoSize = true; this.label4.Location = new System.Drawing.Point(8, 96); this.label4.Name = "label4"; this.label4.Size = new System.Drawing.Size(101, 13); this.label4.TabIndex = 3; this.label4.Text = "Fecha de muestreo:"; this.label4.TextAlign = System.Drawing.ContentAlignment.MiddleRight; // // label3 // this.label3.AutoSize = true; this.label3.Location = new System.Drawing.Point(43, 72); this.label3.Name = "label3"; this.label3.Size = new System.Drawing.Size(69, 13); this.label3.TabIndex = 2; this.label3.Text = "Consecutivo:"; this.label3.TextAlign = System.Drawing.ContentAlignment.MiddleRight; // // label2 // this.label2.AutoSize = true; this.label2.Location = new System.Drawing.Point(81, 48); this.label2.Name = "label2"; this.label2.Size = new System.Drawing.Size(33, 13); this.label2.TabIndex = 1; this.label2.Text = "Obra:"; this.label2.TextAlign = System.Drawing.ContentAlignment.MiddleRight; // // label1 // this.label1.AutoSize = true; this.label1.Location = new System.Drawing.Point(72, 24); this.label1.Name = "label1"; this.label1.Size = new System.Drawing.Size(41, 13); this.label1.TabIndex = 0; this.label1.Text = "FOLIO:"; this.label1.TextAlign = System.Drawing.ContentAlignment.MiddleRight; // // sqlDAToronMdor // this.sqlDAToronMdor.DeleteCommand = this.sqlDeleteCommand1; this.sqlDAToronMdor.InsertCommand = this.sqlInsertCommand1; this.sqlDAToronMdor.SelectCommand = this.sqlSelectCommand1; this.sqlDAToronMdor.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping("Table", "Toron7AlamMdor", new System.Data.Common.DataColumnMapping[] { new System.Data.Common.DataColumnMapping("FOLIO", "FOLIO"), new System.Data.Common.DataColumnMapping("Idobra", "Idobra"), new System.Data.Common.DataColumnMapping("ConsObra", "ConsObra"), new System.Data.Common.DataColumnMapping("FMuestreo", "FMuestreo"), new System.Data.Common.DataColumnMapping("FEnsaye", "FEnsaye"), new System.Data.Common.DataColumnMapping("FInforme", "FInforme"), new System.Data.Common.DataColumnMapping("NoEco", "NoEco"), new System.Data.Common.DataColumnMapping("Semana", "Semana"), new System.Data.Common.DataColumnMapping("MuestreadasEn", "MuestreadasEn"), new System.Data.Common.DataColumnMapping("Observaciones", "Observaciones"), new System.Data.Common.DataColumnMapping("IdUsuario", "IdUsuario") }) }); this.sqlDAToronMdor.UpdateCommand = this.sqlUpdateCommand1; // // sqlDeleteCommand1 // this.sqlDeleteCommand1.CommandText = resources.GetString("sqlDeleteCommand1.CommandText"); this.sqlDeleteCommand1.Connection = this.sqlConn; this.sqlDeleteCommand1.Parameters.AddRange(new System.Data.SqlClient.SqlParameter[] { new System.Data.SqlClient.SqlParameter("@Original_FOLIO", System.Data.SqlDbType.Char, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "FOLIO", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_Idobra", System.Data.SqlDbType.NVarChar, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Idobra", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@IsNull_ConsObra", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "ConsObra", System.Data.DataRowVersion.Original, true, null, "", "", ""), new System.Data.SqlClient.SqlParameter("@Original_ConsObra", System.Data.SqlDbType.SmallInt, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "ConsObra", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@IsNull_FMuestreo", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "FMuestreo", System.Data.DataRowVersion.Original, true, null, "", "", ""), new System.Data.SqlClient.SqlParameter("@Original_FMuestreo", System.Data.SqlDbType.SmallDateTime, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "FMuestreo", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@IsNull_FEnsaye", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "FEnsaye", System.Data.DataRowVersion.Original, true, null, "", "", ""), new System.Data.SqlClient.SqlParameter("@Original_FEnsaye", System.Data.SqlDbType.SmallDateTime, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "FEnsaye", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@IsNull_FInforme", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "FInforme", System.Data.DataRowVersion.Original, true, null, "", "", ""), new System.Data.SqlClient.SqlParameter("@Original_FInforme", System.Data.SqlDbType.SmallDateTime, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "FInforme", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@IsNull_NoEco", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "NoEco", System.Data.DataRowVersion.Original, true, null, "", "", ""), new System.Data.SqlClient.SqlParameter("@Original_NoEco", System.Data.SqlDbType.SmallInt, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "NoEco", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@IsNull_Semana", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "Semana", System.Data.DataRowVersion.Original, true, null, "", "", ""), new System.Data.SqlClient.SqlParameter("@Original_Semana", System.Data.SqlDbType.SmallInt, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Semana", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@IsNull_MuestreadasEn", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "MuestreadasEn", System.Data.DataRowVersion.Original, true, null, "", "", ""), new System.Data.SqlClient.SqlParameter("@Original_MuestreadasEn", System.Data.SqlDbType.NVarChar, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "MuestreadasEn", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@IsNull_Observaciones", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "Observaciones", System.Data.DataRowVersion.Original, true, null, "", "", ""), new System.Data.SqlClient.SqlParameter("@Original_Observaciones", System.Data.SqlDbType.NVarChar, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Observaciones", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@IsNull_IdUsuario", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "IdUsuario", System.Data.DataRowVersion.Original, true, null, "", "", ""), new System.Data.SqlClient.SqlParameter("@Original_IdUsuario", System.Data.SqlDbType.VarChar, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "IdUsuario", System.Data.DataRowVersion.Original, null) }); // // sqlConn // this.sqlConn.ConnectionString = ((string)(configurationAppSettings.GetValue("sqlConn.ConnectionString", typeof(string)))); this.sqlConn.FireInfoMessageEventOnUserErrors = false; // // sqlInsertCommand1 // this.sqlInsertCommand1.CommandText = resources.GetString("sqlInsertCommand1.CommandText"); this.sqlInsertCommand1.Connection = this.sqlConn; this.sqlInsertCommand1.Parameters.AddRange(new System.Data.SqlClient.SqlParameter[] { new System.Data.SqlClient.SqlParameter("@FOLIO", System.Data.SqlDbType.Char, 0, "FOLIO"), new System.Data.SqlClient.SqlParameter("@Idobra", System.Data.SqlDbType.NVarChar, 0, "Idobra"), new System.Data.SqlClient.SqlParameter("@ConsObra", System.Data.SqlDbType.SmallInt, 0, "ConsObra"), new System.Data.SqlClient.SqlParameter("@FMuestreo", System.Data.SqlDbType.SmallDateTime, 0, "FMuestreo"), new System.Data.SqlClient.SqlParameter("@FEnsaye", System.Data.SqlDbType.SmallDateTime, 0, "FEnsaye"), new System.Data.SqlClient.SqlParameter("@FInforme", System.Data.SqlDbType.SmallDateTime, 0, "FInforme"), new System.Data.SqlClient.SqlParameter("@NoEco", System.Data.SqlDbType.SmallInt, 0, "NoEco"), new System.Data.SqlClient.SqlParameter("@Semana", System.Data.SqlDbType.SmallInt, 0, "Semana"), new System.Data.SqlClient.SqlParameter("@MuestreadasEn", System.Data.SqlDbType.NVarChar, 0, "MuestreadasEn"), new System.Data.SqlClient.SqlParameter("@Observaciones", System.Data.SqlDbType.NVarChar, 0, "Observaciones"), new System.Data.SqlClient.SqlParameter("@IdUsuario", System.Data.SqlDbType.VarChar, 0, "IdUsuario") }); // // sqlSelectCommand1 // this.sqlSelectCommand1.CommandText = "SELECT FOLIO, Idobra, ConsObra, FMuestreo, FEnsaye, FInforme, NoEco, Seman" + "a, MuestreadasEn, Observaciones, IdUsuario\r\nFROM Toron7AlamMdor"; this.sqlSelectCommand1.Connection = this.sqlConn; // // sqlUpdateCommand1 // this.sqlUpdateCommand1.CommandText = resources.GetString("sqlUpdateCommand1.CommandText"); this.sqlUpdateCommand1.Connection = this.sqlConn; this.sqlUpdateCommand1.Parameters.AddRange(new System.Data.SqlClient.SqlParameter[] { new System.Data.SqlClient.SqlParameter("@FOLIO", System.Data.SqlDbType.Char, 0, "FOLIO"), new System.Data.SqlClient.SqlParameter("@Idobra", System.Data.SqlDbType.NVarChar, 0, "Idobra"), new System.Data.SqlClient.SqlParameter("@ConsObra", System.Data.SqlDbType.SmallInt, 0, "ConsObra"), new System.Data.SqlClient.SqlParameter("@FMuestreo", System.Data.SqlDbType.SmallDateTime, 0, "FMuestreo"), new System.Data.SqlClient.SqlParameter("@FEnsaye", System.Data.SqlDbType.SmallDateTime, 0, "FEnsaye"), new System.Data.SqlClient.SqlParameter("@FInforme", System.Data.SqlDbType.SmallDateTime, 0, "FInforme"), new System.Data.SqlClient.SqlParameter("@NoEco", System.Data.SqlDbType.SmallInt, 0, "NoEco"), new System.Data.SqlClient.SqlParameter("@Semana", System.Data.SqlDbType.SmallInt, 0, "Semana"), new System.Data.SqlClient.SqlParameter("@MuestreadasEn", System.Data.SqlDbType.NVarChar, 0, "MuestreadasEn"), new System.Data.SqlClient.SqlParameter("@Observaciones", System.Data.SqlDbType.NVarChar, 0, "Observaciones"), new System.Data.SqlClient.SqlParameter("@IdUsuario", System.Data.SqlDbType.VarChar, 0, "IdUsuario"), new System.Data.SqlClient.SqlParameter("@Original_FOLIO", System.Data.SqlDbType.Char, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "FOLIO", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_Idobra", System.Data.SqlDbType.NVarChar, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Idobra", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@IsNull_ConsObra", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "ConsObra", System.Data.DataRowVersion.Original, true, null, "", "", ""), new System.Data.SqlClient.SqlParameter("@Original_ConsObra", System.Data.SqlDbType.SmallInt, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "ConsObra", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@IsNull_FMuestreo", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "FMuestreo", System.Data.DataRowVersion.Original, true, null, "", "", ""), new System.Data.SqlClient.SqlParameter("@Original_FMuestreo", System.Data.SqlDbType.SmallDateTime, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "FMuestreo", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@IsNull_FEnsaye", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "FEnsaye", System.Data.DataRowVersion.Original, true, null, "", "", ""), new System.Data.SqlClient.SqlParameter("@Original_FEnsaye", System.Data.SqlDbType.SmallDateTime, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "FEnsaye", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@IsNull_FInforme", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "FInforme", System.Data.DataRowVersion.Original, true, null, "", "", ""), new System.Data.SqlClient.SqlParameter("@Original_FInforme", System.Data.SqlDbType.SmallDateTime, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "FInforme", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@IsNull_NoEco", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "NoEco", System.Data.DataRowVersion.Original, true, null, "", "", ""), new System.Data.SqlClient.SqlParameter("@Original_NoEco", System.Data.SqlDbType.SmallInt, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "NoEco", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@IsNull_Semana", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "Semana", System.Data.DataRowVersion.Original, true, null, "", "", ""), new System.Data.SqlClient.SqlParameter("@Original_Semana", System.Data.SqlDbType.SmallInt, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Semana", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@IsNull_MuestreadasEn", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "MuestreadasEn", System.Data.DataRowVersion.Original, true, null, "", "", ""), new System.Data.SqlClient.SqlParameter("@Original_MuestreadasEn", System.Data.SqlDbType.NVarChar, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "MuestreadasEn", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@IsNull_Observaciones", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "Observaciones", System.Data.DataRowVersion.Original, true, null, "", "", ""), new System.Data.SqlClient.SqlParameter("@Original_Observaciones", System.Data.SqlDbType.NVarChar, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Observaciones", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@IsNull_IdUsuario", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "IdUsuario", System.Data.DataRowVersion.Original, true, null, "", "", ""), new System.Data.SqlClient.SqlParameter("@Original_IdUsuario", System.Data.SqlDbType.VarChar, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "IdUsuario", System.Data.DataRowVersion.Original, null) }); // // sqlDABusObra // this.sqlDABusObra.SelectCommand = this.sqlCommand1; this.sqlDABusObra.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping("Table", "Obra", new System.Data.Common.DataColumnMapping[] { new System.Data.Common.DataColumnMapping("Idobra", "Idobra"), new System.Data.Common.DataColumnMapping("Ubicacion", "Ubicacion"), new System.Data.Common.DataColumnMapping("RFC", "RFC"), new System.Data.Common.DataColumnMapping("Facturar", "Facturar") }) }); // // sqlCommand1 // this.sqlCommand1.CommandText = "SELECT Obra.Idobra, Obra.Ubicacion, Obra.RFC, Razonsocial.Facturar FROM Obra LEFT" + " OUTER JOIN Razonsocial ON Obra.IdCliente = Razonsocial.IdCliente AND Obra.RFC =" + " Razonsocial.RFC ORDER BY Obra.Idobra"; this.sqlCommand1.Connection = this.sqlConn; // // sqlDALaboratorista // this.sqlDALaboratorista.SelectCommand = this.sqlSelectCommand5; this.sqlDALaboratorista.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping("Table", "Laboratorista", new System.Data.Common.DataColumnMapping[] { new System.Data.Common.DataColumnMapping("NoEco", "NoEco"), new System.Data.Common.DataColumnMapping("Laboratorista", "Laboratorista"), new System.Data.Common.DataColumnMapping("IdZona", "IdZona"), new System.Data.Common.DataColumnMapping("IdNivel", "IdNivel"), new System.Data.Common.DataColumnMapping("Fechai", "Fechai") }) }); // // sqlSelectCommand5 // this.sqlSelectCommand5.CommandText = "SELECT NoEco, LTRIM(STR(NoEco)) + \' \' + Laboratorista AS Laboratorista, IdZona, I" + "dNivel, Fechai FROM Laboratorista ORDER BY NoEco"; this.sqlSelectCommand5.Connection = this.sqlConn; // // txtUsrMov // this.txtUsrMov.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dsToronMdor1, "Toron7AlamMdor.IdUsuario", true)); this.txtUsrMov.Location = new System.Drawing.Point(400, 26); this.txtUsrMov.Name = "txtUsrMov"; this.txtUsrMov.ReadOnly = true; this.txtUsrMov.Size = new System.Drawing.Size(68, 20); this.txtUsrMov.TabIndex = 52; // // label28 // this.label28.AutoSize = true; this.label28.Font = new System.Drawing.Font("Microsoft Sans Serif", 8.25F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0))); this.label28.ForeColor = System.Drawing.Color.Red; this.label28.Location = new System.Drawing.Point(339, 30); this.label28.Name = "label28"; this.label28.Size = new System.Drawing.Size(54, 13); this.label28.TabIndex = 51; this.label28.Text = "Usuario:"; this.label28.TextAlign = System.Drawing.ContentAlignment.MiddleRight; // // ToronMdor // this.AutoScaleBaseSize = new System.Drawing.Size(5, 13); this.ClientSize = new System.Drawing.Size(584, 453); this.Controls.Add(this.panel2); this.DAGeneral = this.sqlDAToronMdor; this.dsGeneral = this.dsToronMdor1; this.Name = "ToronMdor"; this.NombreTabla = "Toron7AlamMdor"; this.Text = "ToronMdor"; this.Load += new System.EventHandler(this.ToronMdor_Load); this.Controls.SetChildIndex(this.statusBar1, 0); this.Controls.SetChildIndex(this.panelToolBar, 0); this.Controls.SetChildIndex(this.panel2, 0); this.panelToolBar.ResumeLayout(false); this.panel2.ResumeLayout(false); this.panel2.PerformLayout(); ((System.ComponentModel.ISupportInitialize)(this.dsToronMdor1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.dsLaboratorista1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.dsBusObra1)).EndInit(); this.ResumeLayout(false); }
/// <summary> /// Método necesario para admitir el Diseñador. No se puede modificar /// el contenido del método con el editor de código. /// </summary> private void InitializeComponent() { System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(Servicios)); System.Configuration.AppSettingsReader configurationAppSettings = new System.Configuration.AppSettingsReader(); System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle7 = new System.Windows.Forms.DataGridViewCellStyle(); System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle8 = new System.Windows.Forms.DataGridViewCellStyle(); System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle10 = new System.Windows.Forms.DataGridViewCellStyle(); System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle11 = new System.Windows.Forms.DataGridViewCellStyle(); System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle12 = new System.Windows.Forms.DataGridViewCellStyle(); System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle9 = new System.Windows.Forms.DataGridViewCellStyle(); this.sqlDAServicios = 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.dsServicios1 = new LancNeo.dsServicios(); this.dsBusObra1 = new LancNeo.dsBusObra(); this.sqlDABusObra = new System.Data.SqlClient.SqlDataAdapter(); this.sqlCommand1 = new System.Data.SqlClient.SqlCommand(); this.sqlDAConcepto = new System.Data.SqlClient.SqlDataAdapter(); this.sqlSelectCommand3 = new System.Data.SqlClient.SqlCommand(); this.dsConcepto1 = new LancNeo.dsConcepto(); this.cmbIdObra = new System.Windows.Forms.ComboBox(); this.label1 = new System.Windows.Forms.Label(); this.panel2 = new System.Windows.Forms.Panel(); this.txtIdobra = new System.Windows.Forms.TextBox(); this.dsLaboratorista1 = new LancNeo.dsLaboratorista(); this.sqlDALaboratorista = new System.Data.SqlClient.SqlDataAdapter(); this.sqlSelectCommand5 = new System.Data.SqlClient.SqlCommand(); this.sqlDAInformes = new System.Data.SqlClient.SqlDataAdapter(); this.sqlDeleteCommand2 = new System.Data.SqlClient.SqlCommand(); this.sqlInsertCommand2 = new System.Data.SqlClient.SqlCommand(); this.sqlSelectCommand2 = new System.Data.SqlClient.SqlCommand(); this.sqlUpdateCommand2 = new System.Data.SqlClient.SqlCommand(); this.dsInformes1 = new LancNeo.dsInformes(); this.dataGridView1 = new System.Windows.Forms.DataGridView(); this.idObraDataGridViewTextBoxColumn = new System.Windows.Forms.DataGridViewTextBoxColumn(); this.fechaDataGridViewTextBoxColumn = new System.Windows.Forms.DataGridViewTextBoxColumn(); this.consecutivoDataGridViewTextBoxColumn = new System.Windows.Forms.DataGridViewTextBoxColumn(); this.identificadorDataGridViewTextBoxColumn = new System.Windows.Forms.DataGridViewTextBoxColumn(); this.idConceptoDataGridViewTextBoxColumn = new System.Windows.Forms.DataGridViewComboBoxColumn(); this.idInformeDataGridViewTextBoxColumn = new System.Windows.Forms.DataGridViewComboBoxColumn(); this.cantidadDataGridViewTextBoxColumn = new System.Windows.Forms.DataGridViewTextBoxColumn(); this.operadorDataGridViewTextBoxColumn = new System.Windows.Forms.DataGridViewComboBoxColumn(); this.panelToolBar.SuspendLayout(); ((System.ComponentModel.ISupportInitialize)(this.dsServicios1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.dsBusObra1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.dsConcepto1)).BeginInit(); this.panel2.SuspendLayout(); ((System.ComponentModel.ISupportInitialize)(this.dsLaboratorista1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.dsInformes1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.dataGridView1)).BeginInit(); this.SuspendLayout(); // // statusBar1 // this.statusBar1.Location = new System.Drawing.Point(0, 641); this.statusBar1.ShowPanels = true; this.statusBar1.Size = new System.Drawing.Size(1022, 22); // // panelToolBar // this.panelToolBar.Size = new System.Drawing.Size(1022, 64); // // sqlDAServicios // this.sqlDAServicios.DeleteCommand = this.sqlDeleteCommand1; this.sqlDAServicios.InsertCommand = this.sqlInsertCommand1; this.sqlDAServicios.SelectCommand = this.sqlSelectCommand1; this.sqlDAServicios.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping("Table", "Servicios", new System.Data.Common.DataColumnMapping[] { new System.Data.Common.DataColumnMapping("IdObra", "IdObra"), new System.Data.Common.DataColumnMapping("Fecha", "Fecha"), new System.Data.Common.DataColumnMapping("Consecutivo", "Consecutivo"), new System.Data.Common.DataColumnMapping("Identificador", "Identificador"), new System.Data.Common.DataColumnMapping("IdConcepto", "IdConcepto"), new System.Data.Common.DataColumnMapping("Cantidad", "Cantidad"), new System.Data.Common.DataColumnMapping("Operador", "Operador"), new System.Data.Common.DataColumnMapping("IdInforme", "IdInforme") }) }); this.sqlDAServicios.UpdateCommand = this.sqlUpdateCommand1; // // sqlDeleteCommand1 // this.sqlDeleteCommand1.CommandText = resources.GetString("sqlDeleteCommand1.CommandText"); this.sqlDeleteCommand1.Connection = this.sqlConn; this.sqlDeleteCommand1.Parameters.AddRange(new System.Data.SqlClient.SqlParameter[] { new System.Data.SqlClient.SqlParameter("@Original_Consecutivo", System.Data.SqlDbType.SmallInt, 2, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Consecutivo", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_Fecha", System.Data.SqlDbType.DateTime, 4, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Fecha", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_IdObra", System.Data.SqlDbType.NVarChar, 6, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "IdObra", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_Cantidad", System.Data.SqlDbType.Decimal, 9, System.Data.ParameterDirection.Input, false, ((byte)(18)), ((byte)(4)), "Cantidad", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_IdConcepto", System.Data.SqlDbType.SmallInt, 2, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "IdConcepto", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_IdInforme", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "IdInforme", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_Identificador", System.Data.SqlDbType.NVarChar, 50, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Identificador", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_Operador", System.Data.SqlDbType.SmallInt, 2, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Operador", 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("@IdObra", System.Data.SqlDbType.NVarChar, 6, "IdObra"), new System.Data.SqlClient.SqlParameter("@Fecha", System.Data.SqlDbType.DateTime, 4, "Fecha"), new System.Data.SqlClient.SqlParameter("@Consecutivo", System.Data.SqlDbType.SmallInt, 2, "Consecutivo"), new System.Data.SqlClient.SqlParameter("@Identificador", System.Data.SqlDbType.NVarChar, 50, "Identificador"), new System.Data.SqlClient.SqlParameter("@IdConcepto", System.Data.SqlDbType.SmallInt, 2, "IdConcepto"), new System.Data.SqlClient.SqlParameter("@Cantidad", System.Data.SqlDbType.Decimal, 9, System.Data.ParameterDirection.Input, false, ((byte)(18)), ((byte)(4)), "Cantidad", System.Data.DataRowVersion.Current, null), new System.Data.SqlClient.SqlParameter("@Operador", System.Data.SqlDbType.SmallInt, 2, "Operador"), new System.Data.SqlClient.SqlParameter("@IdInforme", System.Data.SqlDbType.VarChar, 10, "IdInforme") }); // // sqlSelectCommand1 // this.sqlSelectCommand1.CommandText = "SELECT IdObra, Fecha, Consecutivo, Identificador, IdConcepto, Cantidad, Operador," + " IdInforme FROM Servicios WHERE (IdObra = @IdObra) ORDER BY IdObra, Fecha DESC, " + "Consecutivo"; 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") }); // // sqlUpdateCommand1 // this.sqlUpdateCommand1.CommandText = resources.GetString("sqlUpdateCommand1.CommandText"); this.sqlUpdateCommand1.Connection = this.sqlConn; this.sqlUpdateCommand1.Parameters.AddRange(new System.Data.SqlClient.SqlParameter[] { new System.Data.SqlClient.SqlParameter("@IdObra", System.Data.SqlDbType.NVarChar, 6, "IdObra"), new System.Data.SqlClient.SqlParameter("@Fecha", System.Data.SqlDbType.DateTime, 4, "Fecha"), new System.Data.SqlClient.SqlParameter("@Consecutivo", System.Data.SqlDbType.SmallInt, 2, "Consecutivo"), new System.Data.SqlClient.SqlParameter("@Identificador", System.Data.SqlDbType.NVarChar, 50, "Identificador"), new System.Data.SqlClient.SqlParameter("@IdConcepto", System.Data.SqlDbType.SmallInt, 2, "IdConcepto"), new System.Data.SqlClient.SqlParameter("@Cantidad", System.Data.SqlDbType.Decimal, 9, System.Data.ParameterDirection.Input, false, ((byte)(18)), ((byte)(4)), "Cantidad", System.Data.DataRowVersion.Current, null), new System.Data.SqlClient.SqlParameter("@Operador", System.Data.SqlDbType.SmallInt, 2, "Operador"), new System.Data.SqlClient.SqlParameter("@IdInforme", System.Data.SqlDbType.VarChar, 10, "IdInforme"), new System.Data.SqlClient.SqlParameter("@Original_Consecutivo", System.Data.SqlDbType.SmallInt, 2, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Consecutivo", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_Fecha", System.Data.SqlDbType.DateTime, 4, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Fecha", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_IdObra", System.Data.SqlDbType.NVarChar, 6, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "IdObra", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_Cantidad", System.Data.SqlDbType.Decimal, 9, System.Data.ParameterDirection.Input, false, ((byte)(18)), ((byte)(4)), "Cantidad", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_IdConcepto", System.Data.SqlDbType.SmallInt, 2, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "IdConcepto", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_IdInforme", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "IdInforme", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_Identificador", System.Data.SqlDbType.NVarChar, 50, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Identificador", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_Operador", System.Data.SqlDbType.SmallInt, 2, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Operador", System.Data.DataRowVersion.Original, null) }); // // dsServicios1 // this.dsServicios1.DataSetName = "dsServicios"; this.dsServicios1.Locale = new System.Globalization.CultureInfo("es-MX"); this.dsServicios1.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema; // // dsBusObra1 // this.dsBusObra1.DataSetName = "dsBusObra"; this.dsBusObra1.Locale = new System.Globalization.CultureInfo("es-MX"); this.dsBusObra1.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 = "SELECT Obra.Idobra, Obra.Ubicacion, Obra.RFC, Razonsocial.Facturar FROM Obra LEFT" + " OUTER JOIN Razonsocial ON Obra.IdCliente = Razonsocial.IdCliente AND Obra.RFC =" + " Razonsocial.RFC ORDER BY Obra.Idobra"; this.sqlCommand1.Connection = this.sqlConn; // // sqlDAConcepto // this.sqlDAConcepto.SelectCommand = this.sqlSelectCommand3; this.sqlDAConcepto.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping("Table", "Concepto", new System.Data.Common.DataColumnMapping[] { new System.Data.Common.DataColumnMapping("IdConcepto", "IdConcepto"), new System.Data.Common.DataColumnMapping("Concepto", "Concepto") }) }); // // sqlSelectCommand3 // this.sqlSelectCommand3.CommandText = "SELECT IdConcepto, Concepto FROM Concepto ORDER BY Concepto"; this.sqlSelectCommand3.Connection = this.sqlConn; // // dsConcepto1 // this.dsConcepto1.DataSetName = "dsConcepto"; this.dsConcepto1.Locale = new System.Globalization.CultureInfo("es-MX"); this.dsConcepto1.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema; // // cmbIdObra // this.cmbIdObra.DataSource = this.dsBusObra1.Obra; this.cmbIdObra.DisplayMember = "Idobra"; this.cmbIdObra.Location = new System.Drawing.Point(122, 8); this.cmbIdObra.Name = "cmbIdObra"; this.cmbIdObra.Size = new System.Drawing.Size(64, 21); this.cmbIdObra.TabIndex = 7; this.cmbIdObra.ValueMember = "Idobra"; this.cmbIdObra.SelectedIndexChanged += new System.EventHandler(this.cmbIdObra_SelectedIndexChanged); // // label1 // this.label1.AutoSize = true; this.label1.Location = new System.Drawing.Point(73, 10); this.label1.Name = "label1"; this.label1.Size = new System.Drawing.Size(40, 13); this.label1.TabIndex = 5; this.label1.Text = "Idobra:"; // // panel2 // this.panel2.BorderStyle = System.Windows.Forms.BorderStyle.Fixed3D; this.panel2.Controls.Add(this.cmbIdObra); this.panel2.Controls.Add(this.label1); this.panel2.Controls.Add(this.txtIdobra); this.panel2.Location = new System.Drawing.Point(6, 68); this.panel2.Name = "panel2"; this.panel2.Size = new System.Drawing.Size(570, 36); this.panel2.TabIndex = 9; // // txtIdobra // this.txtIdobra.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dsServicios1, "Servicios.IdObra", true)); this.txtIdobra.Enabled = false; this.txtIdobra.Location = new System.Drawing.Point(130, 9); this.txtIdobra.MaxLength = 6; this.txtIdobra.Name = "txtIdobra"; this.txtIdobra.ReadOnly = true; this.txtIdobra.Size = new System.Drawing.Size(48, 20); this.txtIdobra.TabIndex = 53; this.txtIdobra.Text = "textBox1"; // // dsLaboratorista1 // this.dsLaboratorista1.DataSetName = "dsLaboratorista"; this.dsLaboratorista1.Locale = new System.Globalization.CultureInfo("es-MX"); this.dsLaboratorista1.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema; // // sqlDALaboratorista // this.sqlDALaboratorista.SelectCommand = this.sqlSelectCommand5; this.sqlDALaboratorista.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping("Table", "Laboratorista", new System.Data.Common.DataColumnMapping[] { new System.Data.Common.DataColumnMapping("NoEco", "NoEco"), new System.Data.Common.DataColumnMapping("Laboratorista", "Laboratorista"), new System.Data.Common.DataColumnMapping("IdZona", "IdZona"), new System.Data.Common.DataColumnMapping("IdNivel", "IdNivel"), new System.Data.Common.DataColumnMapping("Fechai", "Fechai") }) }); // // sqlSelectCommand5 // this.sqlSelectCommand5.CommandText = "SELECT NoEco, LTRIM(STR(NoEco)) + \' \' + Laboratorista AS Laboratorista, IdZona, I" + "dNivel, Fechai FROM Laboratorista ORDER BY NoEco"; this.sqlSelectCommand5.Connection = this.sqlConn; // // sqlDAInformes // this.sqlDAInformes.DeleteCommand = this.sqlDeleteCommand2; this.sqlDAInformes.InsertCommand = this.sqlInsertCommand2; this.sqlDAInformes.SelectCommand = this.sqlSelectCommand2; this.sqlDAInformes.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping("Table", "Informes", new System.Data.Common.DataColumnMapping[] { new System.Data.Common.DataColumnMapping("IdInforme", "IdInforme"), new System.Data.Common.DataColumnMapping("Informe", "Informe") }) }); this.sqlDAInformes.UpdateCommand = this.sqlUpdateCommand2; // // sqlDeleteCommand2 // this.sqlDeleteCommand2.CommandText = "DELETE FROM Informes WHERE (IdInforme = @Original_IdInforme) AND (Informe = @Orig" + "inal_Informe OR @Original_Informe IS NULL AND Informe IS NULL)"; this.sqlDeleteCommand2.Connection = this.sqlConn; this.sqlDeleteCommand2.Parameters.AddRange(new System.Data.SqlClient.SqlParameter[] { new System.Data.SqlClient.SqlParameter("@Original_IdInforme", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "IdInforme", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_Informe", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Informe", System.Data.DataRowVersion.Original, null) }); // // sqlInsertCommand2 // this.sqlInsertCommand2.CommandText = "INSERT INTO Informes(IdInforme, Informe) VALUES (@IdInforme, @Informe); SELECT Id" + "Informe, Informe FROM Informes WHERE (IdInforme = @IdInforme) ORDER BY Informe"; this.sqlInsertCommand2.Connection = this.sqlConn; this.sqlInsertCommand2.Parameters.AddRange(new System.Data.SqlClient.SqlParameter[] { new System.Data.SqlClient.SqlParameter("@IdInforme", System.Data.SqlDbType.VarChar, 10, "IdInforme"), new System.Data.SqlClient.SqlParameter("@Informe", System.Data.SqlDbType.VarChar, 50, "Informe") }); // // sqlSelectCommand2 // this.sqlSelectCommand2.CommandText = "SELECT IdInforme, Informe FROM Informes ORDER BY Informe"; this.sqlSelectCommand2.Connection = this.sqlConn; // // sqlUpdateCommand2 // this.sqlUpdateCommand2.CommandText = resources.GetString("sqlUpdateCommand2.CommandText"); this.sqlUpdateCommand2.Connection = this.sqlConn; this.sqlUpdateCommand2.Parameters.AddRange(new System.Data.SqlClient.SqlParameter[] { new System.Data.SqlClient.SqlParameter("@IdInforme", System.Data.SqlDbType.VarChar, 10, "IdInforme"), new System.Data.SqlClient.SqlParameter("@Informe", System.Data.SqlDbType.VarChar, 50, "Informe"), new System.Data.SqlClient.SqlParameter("@Original_IdInforme", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "IdInforme", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_Informe", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Informe", System.Data.DataRowVersion.Original, null) }); // // dsInformes1 // this.dsInformes1.DataSetName = "dsInformes"; this.dsInformes1.Locale = new System.Globalization.CultureInfo("es-MX"); this.dsInformes1.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema; // // dataGridView1 // dataGridViewCellStyle7.BackColor = System.Drawing.Color.White; dataGridViewCellStyle7.ForeColor = System.Drawing.Color.Black; dataGridViewCellStyle7.SelectionBackColor = System.Drawing.Color.White; dataGridViewCellStyle7.SelectionForeColor = System.Drawing.Color.DimGray; this.dataGridView1.AlternatingRowsDefaultCellStyle = dataGridViewCellStyle7; this.dataGridView1.AutoGenerateColumns = false; this.dataGridView1.BackgroundColor = System.Drawing.SystemColors.HighlightText; dataGridViewCellStyle8.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleLeft; dataGridViewCellStyle8.BackColor = System.Drawing.Color.White; dataGridViewCellStyle8.Font = new System.Drawing.Font("Microsoft Sans Serif", 8.25F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0))); dataGridViewCellStyle8.ForeColor = System.Drawing.Color.Black; dataGridViewCellStyle8.SelectionBackColor = System.Drawing.Color.White; dataGridViewCellStyle8.SelectionForeColor = System.Drawing.Color.DimGray; dataGridViewCellStyle8.WrapMode = System.Windows.Forms.DataGridViewTriState.True; this.dataGridView1.ColumnHeadersDefaultCellStyle = dataGridViewCellStyle8; this.dataGridView1.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.AutoSize; this.dataGridView1.Columns.AddRange(new System.Windows.Forms.DataGridViewColumn[] { this.idObraDataGridViewTextBoxColumn, this.fechaDataGridViewTextBoxColumn, this.consecutivoDataGridViewTextBoxColumn, this.identificadorDataGridViewTextBoxColumn, this.idConceptoDataGridViewTextBoxColumn, this.idInformeDataGridViewTextBoxColumn, this.cantidadDataGridViewTextBoxColumn, this.operadorDataGridViewTextBoxColumn }); this.dataGridView1.DataMember = "Servicios"; this.dataGridView1.DataSource = this.dsServicios1; dataGridViewCellStyle10.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleLeft; dataGridViewCellStyle10.BackColor = System.Drawing.Color.White; dataGridViewCellStyle10.Font = new System.Drawing.Font("Microsoft Sans Serif", 8.25F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0))); dataGridViewCellStyle10.ForeColor = System.Drawing.Color.White; dataGridViewCellStyle10.SelectionBackColor = System.Drawing.Color.White; dataGridViewCellStyle10.SelectionForeColor = System.Drawing.Color.DimGray; dataGridViewCellStyle10.WrapMode = System.Windows.Forms.DataGridViewTriState.False; this.dataGridView1.DefaultCellStyle = dataGridViewCellStyle10; this.dataGridView1.Location = new System.Drawing.Point(6, 108); this.dataGridView1.Name = "dataGridView1"; dataGridViewCellStyle11.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleLeft; dataGridViewCellStyle11.BackColor = System.Drawing.SystemColors.Control; dataGridViewCellStyle11.Font = new System.Drawing.Font("Microsoft Sans Serif", 6.75F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0))); dataGridViewCellStyle11.ForeColor = System.Drawing.SystemColors.WindowText; dataGridViewCellStyle11.SelectionBackColor = System.Drawing.SystemColors.HighlightText; dataGridViewCellStyle11.SelectionForeColor = System.Drawing.SystemColors.GrayText; dataGridViewCellStyle11.WrapMode = System.Windows.Forms.DataGridViewTriState.True; this.dataGridView1.RowHeadersDefaultCellStyle = dataGridViewCellStyle11; dataGridViewCellStyle12.BackColor = System.Drawing.Color.White; dataGridViewCellStyle12.ForeColor = System.Drawing.Color.Black; dataGridViewCellStyle12.SelectionBackColor = System.Drawing.Color.White; dataGridViewCellStyle12.SelectionForeColor = System.Drawing.Color.DimGray; this.dataGridView1.RowsDefaultCellStyle = dataGridViewCellStyle12; this.dataGridView1.RowTemplate.DefaultCellStyle.BackColor = System.Drawing.Color.White; this.dataGridView1.RowTemplate.DefaultCellStyle.Font = new System.Drawing.Font("Microsoft Sans Serif", 6.75F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0))); this.dataGridView1.RowTemplate.DefaultCellStyle.ForeColor = System.Drawing.Color.Black; this.dataGridView1.RowTemplate.DefaultCellStyle.SelectionBackColor = System.Drawing.Color.White; this.dataGridView1.RowTemplate.DefaultCellStyle.SelectionForeColor = System.Drawing.Color.DimGray; this.dataGridView1.Size = new System.Drawing.Size(1014, 530); this.dataGridView1.TabIndex = 11; // // idObraDataGridViewTextBoxColumn // this.idObraDataGridViewTextBoxColumn.DataPropertyName = "IdObra"; this.idObraDataGridViewTextBoxColumn.HeaderText = "IdObra"; this.idObraDataGridViewTextBoxColumn.Name = "idObraDataGridViewTextBoxColumn"; this.idObraDataGridViewTextBoxColumn.ReadOnly = true; this.idObraDataGridViewTextBoxColumn.Visible = false; this.idObraDataGridViewTextBoxColumn.Width = 5; // // fechaDataGridViewTextBoxColumn // this.fechaDataGridViewTextBoxColumn.DataPropertyName = "Fecha"; dataGridViewCellStyle9.Format = "d"; dataGridViewCellStyle9.NullValue = null; this.fechaDataGridViewTextBoxColumn.DefaultCellStyle = dataGridViewCellStyle9; this.fechaDataGridViewTextBoxColumn.HeaderText = "Fecha"; this.fechaDataGridViewTextBoxColumn.MaxInputLength = 10; this.fechaDataGridViewTextBoxColumn.Name = "fechaDataGridViewTextBoxColumn"; this.fechaDataGridViewTextBoxColumn.Width = 75; // // consecutivoDataGridViewTextBoxColumn // this.consecutivoDataGridViewTextBoxColumn.DataPropertyName = "Consecutivo"; this.consecutivoDataGridViewTextBoxColumn.HeaderText = "Consecutivo"; this.consecutivoDataGridViewTextBoxColumn.MaxInputLength = 3; this.consecutivoDataGridViewTextBoxColumn.Name = "consecutivoDataGridViewTextBoxColumn"; this.consecutivoDataGridViewTextBoxColumn.Width = 70; // // identificadorDataGridViewTextBoxColumn // this.identificadorDataGridViewTextBoxColumn.DataPropertyName = "Identificador"; this.identificadorDataGridViewTextBoxColumn.HeaderText = "Identificador"; this.identificadorDataGridViewTextBoxColumn.MaxInputLength = 3; this.identificadorDataGridViewTextBoxColumn.Name = "identificadorDataGridViewTextBoxColumn"; this.identificadorDataGridViewTextBoxColumn.Width = 70; // // idConceptoDataGridViewTextBoxColumn // this.idConceptoDataGridViewTextBoxColumn.DataPropertyName = "IdConcepto"; this.idConceptoDataGridViewTextBoxColumn.DataSource = this.dsConcepto1; this.idConceptoDataGridViewTextBoxColumn.DisplayMember = "Concepto.Concepto"; this.idConceptoDataGridViewTextBoxColumn.HeaderText = "Concepto"; this.idConceptoDataGridViewTextBoxColumn.Name = "idConceptoDataGridViewTextBoxColumn"; this.idConceptoDataGridViewTextBoxColumn.Resizable = System.Windows.Forms.DataGridViewTriState.True; this.idConceptoDataGridViewTextBoxColumn.SortMode = System.Windows.Forms.DataGridViewColumnSortMode.Automatic; this.idConceptoDataGridViewTextBoxColumn.ValueMember = "Concepto.IdConcepto"; this.idConceptoDataGridViewTextBoxColumn.Width = 225; // // idInformeDataGridViewTextBoxColumn // this.idInformeDataGridViewTextBoxColumn.DataPropertyName = "IdInforme"; this.idInformeDataGridViewTextBoxColumn.DataSource = this.dsInformes1; this.idInformeDataGridViewTextBoxColumn.DisplayMember = "Informes.Informe"; this.idInformeDataGridViewTextBoxColumn.HeaderText = "IdInforme"; this.idInformeDataGridViewTextBoxColumn.Name = "idInformeDataGridViewTextBoxColumn"; this.idInformeDataGridViewTextBoxColumn.Resizable = System.Windows.Forms.DataGridViewTriState.True; this.idInformeDataGridViewTextBoxColumn.SortMode = System.Windows.Forms.DataGridViewColumnSortMode.Automatic; this.idInformeDataGridViewTextBoxColumn.ValueMember = "Informes.IdInforme"; this.idInformeDataGridViewTextBoxColumn.Width = 225; // // cantidadDataGridViewTextBoxColumn // this.cantidadDataGridViewTextBoxColumn.DataPropertyName = "Cantidad"; this.cantidadDataGridViewTextBoxColumn.HeaderText = "Cantidad"; this.cantidadDataGridViewTextBoxColumn.Name = "cantidadDataGridViewTextBoxColumn"; this.cantidadDataGridViewTextBoxColumn.Width = 60; // // operadorDataGridViewTextBoxColumn // this.operadorDataGridViewTextBoxColumn.DataPropertyName = "Operador"; this.operadorDataGridViewTextBoxColumn.DataSource = this.dsLaboratorista1; this.operadorDataGridViewTextBoxColumn.DisplayMember = "Laboratorista.Laboratorista"; this.operadorDataGridViewTextBoxColumn.HeaderText = "Operador"; this.operadorDataGridViewTextBoxColumn.Name = "operadorDataGridViewTextBoxColumn"; this.operadorDataGridViewTextBoxColumn.Resizable = System.Windows.Forms.DataGridViewTriState.True; this.operadorDataGridViewTextBoxColumn.SortMode = System.Windows.Forms.DataGridViewColumnSortMode.Automatic; this.operadorDataGridViewTextBoxColumn.ValueMember = "Laboratorista.NoEco"; this.operadorDataGridViewTextBoxColumn.Width = 220; // // Servicios // this.AutoScaleBaseSize = new System.Drawing.Size(5, 13); this.ClientSize = new System.Drawing.Size(1022, 663); this.Controls.Add(this.dataGridView1); this.Controls.Add(this.panel2); this.DAGeneral = this.sqlDAServicios; this.dsGeneral = this.dsServicios1; this.MaximizeBox = false; this.MinimizeBox = false; this.Name = "Servicios"; this.NombreTabla = "Servicios"; this.Text = "Servicios"; this.WindowState = System.Windows.Forms.FormWindowState.Maximized; this.Load += new System.EventHandler(this.Servicios_Load); this.Controls.SetChildIndex(this.statusBar1, 0); this.Controls.SetChildIndex(this.panelToolBar, 0); this.Controls.SetChildIndex(this.panel2, 0); this.Controls.SetChildIndex(this.dataGridView1, 0); this.panelToolBar.ResumeLayout(false); ((System.ComponentModel.ISupportInitialize)(this.dsServicios1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.dsBusObra1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.dsConcepto1)).EndInit(); this.panel2.ResumeLayout(false); this.panel2.PerformLayout(); ((System.ComponentModel.ISupportInitialize)(this.dsLaboratorista1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.dsInformes1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.dataGridView1)).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(RepMuestreador)); System.Configuration.AppSettingsReader configurationAppSettings = new System.Configuration.AppSettingsReader(); this.label1 = new System.Windows.Forms.Label(); this.buscaBtn1 = new Soluciones2000.Tools.WinLib.BuscaBtn(); this.dsBusMuestreador1 = new LancNeo.dsBusMuestreador(); this.txtIdobra = new System.Windows.Forms.TextBox(); this.Fecha = new System.Windows.Forms.Label(); this.txtFecha = new System.Windows.Forms.TextBox(); this.btnVistaPrevia = new Soluciones2000.Tools.WinLib.tbBtn(); this.sqlDABusMuestreador = new System.Data.SqlClient.SqlDataAdapter(); this.sqlSelectCommand1 = new System.Data.SqlClient.SqlCommand(); this.sqlConn = new System.Data.SqlClient.SqlConnection(); this.sqlDARepMuestreador = new System.Data.SqlClient.SqlDataAdapter(); this.sqlSelectCommand2 = new System.Data.SqlClient.SqlCommand(); this.dsRepMuestreador1 = new LancNeo.dsRepMuestreador(); this.cryRepMuestreador1 = new LancNeo.CryRepMuestreador(); this.panel1 = new System.Windows.Forms.Panel(); this.chbLab1 = new System.Windows.Forms.CheckBox(); this.label2 = new System.Windows.Forms.Label(); this.comboBox1 = new System.Windows.Forms.ComboBox(); this.dsBusObra1 = new LancNeo.dsBusObra(); this.crvRepMuestreador = new CrystalDecisions.Windows.Forms.CrystalReportViewer(); this.sqlDABusObra = new System.Data.SqlClient.SqlDataAdapter(); this.sqlCommand1 = new System.Data.SqlClient.SqlCommand(); ((System.ComponentModel.ISupportInitialize)(this.dsBusMuestreador1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.dsRepMuestreador1)).BeginInit(); this.panel1.SuspendLayout(); ((System.ComponentModel.ISupportInitialize)(this.dsBusObra1)).BeginInit(); this.SuspendLayout(); // // label1 // this.label1.Font = new System.Drawing.Font("Microsoft Sans Serif", 14F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0))); this.label1.Location = new System.Drawing.Point(8, 8); this.label1.Name = "label1"; this.label1.Size = new System.Drawing.Size(279, 23); this.label1.TabIndex = 0; this.label1.Text = "Reporte de Muestreador"; // // buscaBtn1 // this.buscaBtn1.AnchoDlgBusq = 450; this.buscaBtn1.BackColor = System.Drawing.Color.Transparent; this.buscaBtn1.Datos = this.dsBusMuestreador1.Muestreador; this.buscaBtn1.Icon = ((System.Drawing.Icon)(resources.GetObject("buscaBtn1.Icon"))); this.buscaBtn1.Location = new System.Drawing.Point(448, 0); this.buscaBtn1.Name = "buscaBtn1"; this.buscaBtn1.Size = new System.Drawing.Size(64, 64); this.buscaBtn1.TabIndex = 1; this.buscaBtn1.Visible = false; this.buscaBtn1.Click += new System.EventHandler(this.buscaBtn1_Click); // // dsBusMuestreador1 // this.dsBusMuestreador1.DataSetName = "dsBusMuestreador"; this.dsBusMuestreador1.Locale = new System.Globalization.CultureInfo("es-MX"); this.dsBusMuestreador1.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema; // // txtIdobra // this.txtIdobra.Location = new System.Drawing.Point(464, 16); this.txtIdobra.Name = "txtIdobra"; this.txtIdobra.ReadOnly = true; this.txtIdobra.Size = new System.Drawing.Size(48, 20); this.txtIdobra.TabIndex = 2; this.txtIdobra.Visible = false; // // Fecha // this.Fecha.AutoSize = true; this.Fecha.Location = new System.Drawing.Point(520, 16); this.Fecha.Name = "Fecha"; this.Fecha.Size = new System.Drawing.Size(40, 13); this.Fecha.TabIndex = 4; this.Fecha.Text = "Fecha:"; // // txtFecha // this.txtFecha.Location = new System.Drawing.Point(560, 16); this.txtFecha.Name = "txtFecha"; this.txtFecha.ReadOnly = true; this.txtFecha.Size = new System.Drawing.Size(80, 20); this.txtFecha.TabIndex = 5; this.txtFecha.TextChanged += new System.EventHandler(this.txtFecha_TextChanged); // // btnVistaPrevia // this.btnVistaPrevia.BackColor = System.Drawing.Color.Transparent; this.btnVistaPrevia.Icon = ((System.Drawing.Icon)(resources.GetObject("btnVistaPrevia.Icon"))); this.btnVistaPrevia.Location = new System.Drawing.Point(646, 0); this.btnVistaPrevia.Name = "btnVistaPrevia"; this.btnVistaPrevia.Size = new System.Drawing.Size(64, 64); this.btnVistaPrevia.TabIndex = 6; this.btnVistaPrevia.Visible = false; this.btnVistaPrevia.Click += new System.EventHandler(this.btnVistaPrevia_Click); // // sqlDABusMuestreador // this.sqlDABusMuestreador.SelectCommand = this.sqlSelectCommand1; this.sqlDABusMuestreador.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping("Table", "Muestreador", new System.Data.Common.DataColumnMapping[] { new System.Data.Common.DataColumnMapping("IdObra", "IdObra"), new System.Data.Common.DataColumnMapping("Fecha", "Fecha") }) }); // // sqlSelectCommand1 // this.sqlSelectCommand1.CommandText = "SELECT IdObra, Fecha FROM Muestreador WHERE (IdObra = @IdObra) ORDER BY IdObra"; this.sqlSelectCommand1.Connection = this.sqlConn; this.sqlSelectCommand1.Parameters.AddRange(new System.Data.SqlClient.SqlParameter[] { new System.Data.SqlClient.SqlParameter("@IdObra", System.Data.SqlDbType.NVarChar, 6, "IdObra") }); // // sqlConn // this.sqlConn.ConnectionString = ((string)(configurationAppSettings.GetValue("sqlConn.ConnectionString", typeof(string)))); this.sqlConn.FireInfoMessageEventOnUserErrors = false; // // sqlDARepMuestreador // this.sqlDARepMuestreador.SelectCommand = this.sqlSelectCommand2; this.sqlDARepMuestreador.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping("Table", "RepMuestreado", new System.Data.Common.DataColumnMapping[] { new System.Data.Common.DataColumnMapping("IdObra", "IdObra"), new System.Data.Common.DataColumnMapping("Descripcion", "Descripcion"), new System.Data.Common.DataColumnMapping("Ubicacion", "Ubicacion"), new System.Data.Common.DataColumnMapping("Facturar", "Facturar"), new System.Data.Common.DataColumnMapping("Fecha", "Fecha"), new System.Data.Common.DataColumnMapping("NoEco", "NoEco"), new System.Data.Common.DataColumnMapping("Zona", "Zona"), new System.Data.Common.DataColumnMapping("Laboratorista", "Laboratorista"), new System.Data.Common.DataColumnMapping("Semana", "Semana"), new System.Data.Common.DataColumnMapping("Hinicio", "Hinicio"), new System.Data.Common.DataColumnMapping("Hfinal", "Hfinal"), new System.Data.Common.DataColumnMapping("Vsolicitado", "Vsolicitado"), new System.Data.Common.DataColumnMapping("Textra", "Textra"), new System.Data.Common.DataColumnMapping("Volumen", "Volumen"), new System.Data.Common.DataColumnMapping("Nmuestras", "Nmuestras"), new System.Data.Common.DataColumnMapping("Ncilindros", "Ncilindros"), new System.Data.Common.DataColumnMapping("M1dv", "M1dv"), new System.Data.Common.DataColumnMapping("M3dv", "M3dv"), new System.Data.Common.DataColumnMapping("M3d", "M3d"), new System.Data.Common.DataColumnMapping("M7d", "M7d"), new System.Data.Common.DataColumnMapping("M14d", "M14d"), new System.Data.Common.DataColumnMapping("M28d", "M28d"), new System.Data.Common.DataColumnMapping("Observaciones", "Observaciones"), new System.Data.Common.DataColumnMapping("Consecutivo", "Consecutivo"), new System.Data.Common.DataColumnMapping("Fecham", "Fecham"), new System.Data.Common.DataColumnMapping("Muestra", "Muestra"), new System.Data.Common.DataColumnMapping("IdConcretera", "IdConcretera"), new System.Data.Common.DataColumnMapping("IdPlanta", "IdPlanta"), new System.Data.Common.DataColumnMapping("ResistenciaKG", "ResistenciaKG"), new System.Data.Common.DataColumnMapping("tipo", "tipo"), new System.Data.Common.DataColumnMapping("Agregado", "Agregado"), new System.Data.Common.DataColumnMapping("Revenimento", "Revenimento"), new System.Data.Common.DataColumnMapping("Grado", "Grado"), new System.Data.Common.DataColumnMapping("IdAgregado", "IdAgregado"), new System.Data.Common.DataColumnMapping("Agregado1", "Agregado1"), new System.Data.Common.DataColumnMapping("IdRemision", "IdRemision"), new System.Data.Common.DataColumnMapping("IdOlla", "IdOlla"), new System.Data.Common.DataColumnMapping("Volumen1", "Volumen1"), new System.Data.Common.DataColumnMapping("Hora", "Hora"), new System.Data.Common.DataColumnMapping("RevObt", "RevObt"), new System.Data.Common.DataColumnMapping("Elemento", "Elemento"), new System.Data.Common.DataColumnMapping("Ejes", "Ejes"), new System.Data.Common.DataColumnMapping("Nivel", "Nivel"), new System.Data.Common.DataColumnMapping("Edif", "Edif"), new System.Data.Common.DataColumnMapping("Observa", "Observa") }) }); this.sqlDARepMuestreador.RowUpdated += new System.Data.SqlClient.SqlRowUpdatedEventHandler(this.sqlDARepMuestreador_RowUpdated); // // sqlSelectCommand2 // this.sqlSelectCommand2.CommandText = "[RepMuestreado]"; this.sqlSelectCommand2.CommandType = System.Data.CommandType.StoredProcedure; this.sqlSelectCommand2.Connection = this.sqlConn; this.sqlSelectCommand2.Parameters.AddRange(new System.Data.SqlClient.SqlParameter[] { new System.Data.SqlClient.SqlParameter("@RETURN_VALUE", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.ReturnValue, false, ((byte)(0)), ((byte)(0)), "", System.Data.DataRowVersion.Current, null), new System.Data.SqlClient.SqlParameter("@IdObra", System.Data.SqlDbType.NVarChar, 6), new System.Data.SqlClient.SqlParameter("@Fecha", System.Data.SqlDbType.DateTime, 8) }); // // dsRepMuestreador1 // this.dsRepMuestreador1.DataSetName = "dsRepMuestreador"; this.dsRepMuestreador1.Locale = new System.Globalization.CultureInfo("en-US"); this.dsRepMuestreador1.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema; // // panel1 // this.panel1.BackColor = System.Drawing.SystemColors.Highlight; this.panel1.Controls.Add(this.btnVistaPrevia); this.panel1.Controls.Add(this.buscaBtn1); this.panel1.Controls.Add(this.chbLab1); this.panel1.Controls.Add(this.label2); this.panel1.Controls.Add(this.comboBox1); this.panel1.Controls.Add(this.label1); this.panel1.Controls.Add(this.txtIdobra); this.panel1.Controls.Add(this.txtFecha); this.panel1.Controls.Add(this.Fecha); this.panel1.Dock = System.Windows.Forms.DockStyle.Top; this.panel1.Location = new System.Drawing.Point(0, 0); this.panel1.Name = "panel1"; this.panel1.Size = new System.Drawing.Size(880, 56); this.panel1.TabIndex = 8; // // chbLab1 // this.chbLab1.Checked = true; this.chbLab1.CheckState = System.Windows.Forms.CheckState.Checked; this.chbLab1.Location = new System.Drawing.Point(106, 34); this.chbLab1.Name = "chbLab1"; this.chbLab1.Size = new System.Drawing.Size(133, 21); this.chbLab1.TabIndex = 41; this.chbLab1.Text = "Incluye laboratorista"; // // label2 // this.label2.AutoSize = true; this.label2.Location = new System.Drawing.Point(336, 18); this.label2.Name = "label2"; this.label2.Size = new System.Drawing.Size(33, 13); this.label2.TabIndex = 8; this.label2.Text = "Obra:"; // // comboBox1 // this.comboBox1.DataBindings.Add(new System.Windows.Forms.Binding("SelectedValue", this.dsBusObra1, "Obra.Idobra", true)); this.comboBox1.DataSource = this.dsBusObra1.Obra; this.comboBox1.DisplayMember = "IdObra"; this.comboBox1.Location = new System.Drawing.Point(376, 16); this.comboBox1.Name = "comboBox1"; this.comboBox1.Size = new System.Drawing.Size(64, 21); this.comboBox1.TabIndex = 7; this.comboBox1.ValueMember = "IdObra"; this.comboBox1.SelectedIndexChanged += new System.EventHandler(this.comboBox1_SelectedIndexChanged); // // dsBusObra1 // this.dsBusObra1.DataSetName = "dsBusObra"; this.dsBusObra1.Locale = new System.Globalization.CultureInfo("es-MX"); this.dsBusObra1.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema; // // crvRepMuestreador // this.crvRepMuestreador.ActiveViewIndex = -1; this.crvRepMuestreador.BorderStyle = System.Windows.Forms.BorderStyle.FixedSingle; this.crvRepMuestreador.Cursor = System.Windows.Forms.Cursors.Default; this.crvRepMuestreador.Dock = System.Windows.Forms.DockStyle.Fill; this.crvRepMuestreador.EnableRefresh = false; this.crvRepMuestreador.Location = new System.Drawing.Point(0, 56); this.crvRepMuestreador.Name = "crvRepMuestreador"; this.crvRepMuestreador.ShowCloseButton = false; this.crvRepMuestreador.ShowGroupTreeButton = false; this.crvRepMuestreador.ShowLogo = false; this.crvRepMuestreador.Size = new System.Drawing.Size(880, 645); this.crvRepMuestreador.TabIndex = 9; this.crvRepMuestreador.ToolPanelView = CrystalDecisions.Windows.Forms.ToolPanelViewType.None; // // sqlDABusObra // this.sqlDABusObra.SelectCommand = this.sqlCommand1; this.sqlDABusObra.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping("Table", "Obra", new System.Data.Common.DataColumnMapping[] { new System.Data.Common.DataColumnMapping("Idobra", "Idobra"), new System.Data.Common.DataColumnMapping("Ubicacion", "Ubicacion"), new System.Data.Common.DataColumnMapping("RFC", "RFC"), new System.Data.Common.DataColumnMapping("Facturar", "Facturar") }) }); // // sqlCommand1 // this.sqlCommand1.CommandText = "SELECT Obra.Idobra, Obra.Ubicacion, Obra.RFC, Razonsocial.Facturar FROM Obra LEFT" + " OUTER JOIN Razonsocial ON Obra.IdCliente = Razonsocial.IdCliente AND Obra.RFC =" + " Razonsocial.RFC ORDER BY Obra.Idobra"; this.sqlCommand1.Connection = this.sqlConn; // // RepMuestreador // this.AutoScaleBaseSize = new System.Drawing.Size(5, 13); this.ClientSize = new System.Drawing.Size(880, 701); this.Controls.Add(this.crvRepMuestreador); this.Controls.Add(this.panel1); this.MinimizeBox = false; this.Name = "RepMuestreador"; this.Text = "RepMuestreador"; this.WindowState = System.Windows.Forms.FormWindowState.Maximized; this.Load += new System.EventHandler(this.RepMuestreador_Load); ((System.ComponentModel.ISupportInitialize)(this.dsBusMuestreador1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.dsRepMuestreador1)).EndInit(); this.panel1.ResumeLayout(false); this.panel1.PerformLayout(); ((System.ComponentModel.ISupportInitialize)(this.dsBusObra1)).EndInit(); this.ResumeLayout(false); }
/// <summary> /// Método necesario para admitir el Diseñador. No se puede modificar /// el contenido del método con el editor de código. /// </summary> private void InitializeComponent() { System.Configuration.AppSettingsReader configurationAppSettings = new System.Configuration.AppSettingsReader(); System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(InfCompacta)); this.sqlDAInfCompacta = new System.Data.SqlClient.SqlDataAdapter(); this.sqlSelectCommand1 = new System.Data.SqlClient.SqlCommand(); this.sqlConn = new System.Data.SqlClient.SqlConnection(); this.dsCompactaRep1 = new LancNeo.dsCompactaRep(); this.sqlDAFirmas = new System.Data.SqlClient.SqlDataAdapter(); this.sqlSelectCommand7 = new System.Data.SqlClient.SqlCommand(); this.dsBusObra1 = new LancNeo.dsBusObra(); this.sqlDABusObra = new System.Data.SqlClient.SqlDataAdapter(); this.sqlCommand1 = new System.Data.SqlClient.SqlCommand(); this.dsFirmas1 = new LancNeo.dsFirmas(); this.panel1 = new System.Windows.Forms.Panel(); this.btnVistaPrevia = new Soluciones2000.Tools.WinLib.tbBtn(); this.buscaBtn1 = new Soluciones2000.Tools.WinLib.BuscaBtn(); this.dsCompactaMdor1 = new LancNeo.dsCompactaMdor(); this.chbTodos = new System.Windows.Forms.CheckBox(); this.chbOrienta = new System.Windows.Forms.CheckBox(); this.chbLab1 = new System.Windows.Forms.CheckBox(); this.chbLab = new System.Windows.Forms.CheckBox(); this.chbFormato = new System.Windows.Forms.CheckBox(); this.chbLeyenda = new System.Windows.Forms.CheckBox(); this.chbDuplicado = new System.Windows.Forms.CheckBox(); this.txtFolio = new System.Windows.Forms.TextBox(); this.Fecha = new System.Windows.Forms.Label(); this.label5 = new System.Windows.Forms.Label(); this.nudRenglon = new System.Windows.Forms.NumericUpDown(); 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.sqlDACompactaMdor = new System.Data.SqlClient.SqlDataAdapter(); this.sqlSelectCommand2 = new System.Data.SqlClient.SqlCommand(); this.crvInfCompacta = new CrystalDecisions.Windows.Forms.CrystalReportViewer(); this.cryRepCompacta1 = new LancNeo.CryRepCompacta(); this.sqlDANorma = new System.Data.SqlClient.SqlDataAdapter(); this.sqlSelectCommand3 = new System.Data.SqlClient.SqlCommand(); this.sqlDAcMdorH = new System.Data.SqlClient.SqlDataAdapter(); this.sqlCommand2 = new System.Data.SqlClient.SqlCommand(); this.cryRepCompactah1 = new LancNeo.CryRepCompactah(); this.chbRespaldo = new System.Windows.Forms.CheckBox(); ((System.ComponentModel.ISupportInitialize)(this.dsCompactaRep1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.dsBusObra1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.dsFirmas1)).BeginInit(); this.panel1.SuspendLayout(); ((System.ComponentModel.ISupportInitialize)(this.dsCompactaMdor1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.nudRenglon)).BeginInit(); this.SuspendLayout(); // // sqlDAInfCompacta // this.sqlDAInfCompacta.SelectCommand = this.sqlSelectCommand1; this.sqlDAInfCompacta.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping("Table", "CompactaRep", 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("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("Cala", "Cala"), new System.Data.Common.DataColumnMapping("Fecha", "Fecha"), new System.Data.Common.DataColumnMapping("Localizacion", "Localizacion"), new System.Data.Common.DataColumnMapping("Capa", "Capa"), new System.Data.Common.DataColumnMapping("ProfunCapa", "ProfunCapa"), new System.Data.Common.DataColumnMapping("AguaOptima", "AguaOptima"), new System.Data.Common.DataColumnMapping("AhuaLugar", "AhuaLugar"), new System.Data.Common.DataColumnMapping("MasaSecaMax", "MasaSecaMax"), new System.Data.Common.DataColumnMapping("MasaSecaLugar", "MasaSecaLugar"), 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("Observa", "Observa"), new System.Data.Common.DataColumnMapping("Observa1", "Observa1"), new System.Data.Common.DataColumnMapping("Nota", "Nota"), new System.Data.Common.DataColumnMapping("Nota1", "Nota1"), new System.Data.Common.DataColumnMapping("Razonsocial", "Razonsocial"), new System.Data.Common.DataColumnMapping("Ubicacion", "Ubicacion"), new System.Data.Common.DataColumnMapping("Colonia", "Colonia"), new System.Data.Common.DataColumnMapping("Zona", "Zona") }) }); // // sqlSelectCommand1 // this.sqlSelectCommand1.CommandText = "[CompactaRep]"; 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) }); // // sqlConn // this.sqlConn.ConnectionString = ((string)(configurationAppSettings.GetValue("sqlConn.ConnectionString", typeof(string)))); this.sqlConn.FireInfoMessageEventOnUserErrors = false; // // dsCompactaRep1 // this.dsCompactaRep1.DataSetName = "dsCompactaRep"; this.dsCompactaRep1.Locale = new System.Globalization.CultureInfo("es-MX"); this.dsCompactaRep1.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, Compactacion\r\nFROM Firmas\r\nWH" + "ERE (Imprime = 1) AND (Compactacion < 6)\r\nORDER BY Compactacion"; 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; // // 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; // // 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.chbOrienta); this.panel1.Controls.Add(this.chbLab1); this.panel1.Controls.Add(this.chbLab); this.panel1.Controls.Add(this.chbFormato); this.panel1.Controls.Add(this.chbLeyenda); this.panel1.Controls.Add(this.chbDuplicado); this.panel1.Controls.Add(this.txtFolio); this.panel1.Controls.Add(this.Fecha); this.panel1.Controls.Add(this.label5); this.panel1.Controls.Add(this.nudRenglon); 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, 76); 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(931, 4); this.btnVistaPrevia.Name = "btnVistaPrevia"; this.btnVistaPrevia.Size = new System.Drawing.Size(64, 65); this.btnVistaPrevia.TabIndex = 11; this.btnVistaPrevia.Visible = false; this.btnVistaPrevia.Click += new System.EventHandler(this.btnVistaPrevia_Click); // // buscaBtn1 // this.buscaBtn1.AnchoColTit = true; this.buscaBtn1.AnchoDlgBusq = 450; this.buscaBtn1.BackColor = System.Drawing.Color.Transparent; this.buscaBtn1.Datos = this.dsCompactaMdor1.CompactaMdor; this.buscaBtn1.Icon = ((System.Drawing.Icon)(resources.GetObject("buscaBtn1.Icon"))); this.buscaBtn1.Location = new System.Drawing.Point(366, 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); // // dsCompactaMdor1 // this.dsCompactaMdor1.DataSetName = "dsCompactaMdor"; this.dsCompactaMdor1.Locale = new System.Globalization.CultureInfo("es-MX"); this.dsCompactaMdor1.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema; // // chbTodos // this.chbTodos.ForeColor = System.Drawing.Color.White; this.chbTodos.Location = new System.Drawing.Point(805, 47); this.chbTodos.Name = "chbTodos"; this.chbTodos.Size = new System.Drawing.Size(116, 24); this.chbTodos.TabIndex = 43; this.chbTodos.Text = "Todos los folios"; // // chbOrienta // this.chbOrienta.ForeColor = System.Drawing.Color.White; this.chbOrienta.Location = new System.Drawing.Point(805, 0); this.chbOrienta.Name = "chbOrienta"; this.chbOrienta.Size = new System.Drawing.Size(116, 24); this.chbOrienta.TabIndex = 42; this.chbOrienta.Text = "Formato vertical"; this.chbOrienta.Visible = false; // // chbLab1 // this.chbLab1.Checked = true; this.chbLab1.CheckState = System.Windows.Forms.CheckState.Checked; this.chbLab1.ForeColor = System.Drawing.Color.White; this.chbLab1.Location = new System.Drawing.Point(441, 47); 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(616, 45); this.chbLab.Name = "chbLab"; this.chbLab.Size = new System.Drawing.Size(115, 24); this.chbLab.TabIndex = 37; this.chbLab.Text = "Incluye laboratorio"; // // chbFormato // this.chbFormato.ForeColor = System.Drawing.Color.White; this.chbFormato.Location = new System.Drawing.Point(616, 23); this.chbFormato.Name = "chbFormato"; this.chbFormato.Size = new System.Drawing.Size(183, 23); this.chbFormato.TabIndex = 35; this.chbFormato.Text = "Incluye imagen de acreditación"; // // chbLeyenda // this.chbLeyenda.Checked = true; this.chbLeyenda.CheckState = System.Windows.Forms.CheckState.Checked; this.chbLeyenda.ForeColor = System.Drawing.Color.White; this.chbLeyenda.Location = new System.Drawing.Point(441, 23); this.chbLeyenda.Name = "chbLeyenda"; this.chbLeyenda.Size = new System.Drawing.Size(116, 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(248, 30); this.chbDuplicado.Name = "chbDuplicado"; this.chbDuplicado.Size = new System.Drawing.Size(89, 24); this.chbDuplicado.TabIndex = 32; this.chbDuplicado.Text = "¿Duplicado?"; // // txtFolio // this.txtFolio.Location = new System.Drawing.Point(478, 4); this.txtFolio.Name = "txtFolio"; this.txtFolio.Size = new System.Drawing.Size(56, 20); this.txtFolio.TabIndex = 31; // // Fecha // this.Fecha.AutoSize = true; this.Fecha.ForeColor = System.Drawing.Color.White; this.Fecha.Location = new System.Drawing.Point(438, 8); this.Fecha.Name = "Fecha"; this.Fecha.Size = new System.Drawing.Size(32, 13); this.Fecha.TabIndex = 30; this.Fecha.Text = "Folio:"; // // label5 // this.label5.AutoSize = true; this.label5.ForeColor = System.Drawing.Color.White; this.label5.Location = new System.Drawing.Point(560, 3); this.label5.Name = "label5"; this.label5.Size = new System.Drawing.Size(124, 13); this.label5.TabIndex = 13; this.label5.Text = "Especio entre renglones:"; // // nudRenglon // this.nudRenglon.Location = new System.Drawing.Point(694, 0); 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 = 12; this.nudRenglon.Value = new decimal(new int[] { 1, 0, 0, 0 }); // // label2 // this.label2.AutoSize = true; this.label2.ForeColor = System.Drawing.Color.White; this.label2.Location = new System.Drawing.Point(246, 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(278, 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); // // 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(232, 56); this.label1.TabIndex = 0; this.label1.Text = "Informe de verificación de la compactación"; // // txtIdobra // this.txtIdobra.Location = new System.Drawing.Point(366, 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; // // sqlDACompactaMdor // this.sqlDACompactaMdor.SelectCommand = this.sqlSelectCommand2; this.sqlDACompactaMdor.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping("Table", "CompactaMdor", 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("FInforme", "FInforme"), new System.Data.Common.DataColumnMapping("NoEco", "NoEco"), new System.Data.Common.DataColumnMapping("Semana", "Semana"), new System.Data.Common.DataColumnMapping("Observaciones", "Observaciones") }) }); // // sqlSelectCommand2 // this.sqlSelectCommand2.CommandText = "SELECT FOLIO, IdObra, ConsObra, FInforme, NoEco, Semana, Observaciones FROM Compa" + "ctaMdor WHERE (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") }); // // crvInfCompacta // this.crvInfCompacta.ActiveViewIndex = -1; this.crvInfCompacta.BorderStyle = System.Windows.Forms.BorderStyle.FixedSingle; this.crvInfCompacta.Cursor = System.Windows.Forms.Cursors.Default; this.crvInfCompacta.Dock = System.Windows.Forms.DockStyle.Fill; this.crvInfCompacta.Location = new System.Drawing.Point(0, 76); this.crvInfCompacta.Name = "crvInfCompacta"; this.crvInfCompacta.ReuseParameterValuesOnRefresh = true; this.crvInfCompacta.ShowCloseButton = false; this.crvInfCompacta.ShowGroupTreeButton = false; this.crvInfCompacta.ShowLogo = false; this.crvInfCompacta.Size = new System.Drawing.Size(1028, 529); this.crvInfCompacta.TabIndex = 12; this.crvInfCompacta.ToolPanelView = CrystalDecisions.Windows.Forms.ToolPanelViewType.None; this.crvInfCompacta.Visible = false; // // 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 = 1" + "4) ORDER BY IdNorma"; this.sqlSelectCommand3.Connection = this.sqlConn; // // sqlDAcMdorH // this.sqlDAcMdorH.SelectCommand = this.sqlCommand2; this.sqlDAcMdorH.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping("Table", "CompactaRep", 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("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("Cala", "Cala"), new System.Data.Common.DataColumnMapping("Fecha", "Fecha"), new System.Data.Common.DataColumnMapping("Localizacion", "Localizacion"), new System.Data.Common.DataColumnMapping("Capa", "Capa"), new System.Data.Common.DataColumnMapping("ProfunCapa", "ProfunCapa"), new System.Data.Common.DataColumnMapping("AguaOptima", "AguaOptima"), new System.Data.Common.DataColumnMapping("AhuaLugar", "AhuaLugar"), new System.Data.Common.DataColumnMapping("MasaSecaMax", "MasaSecaMax"), new System.Data.Common.DataColumnMapping("MasaSecaLugar", "MasaSecaLugar"), 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("Observa", "Observa"), new System.Data.Common.DataColumnMapping("Observa1", "Observa1"), new System.Data.Common.DataColumnMapping("Nota", "Nota"), new System.Data.Common.DataColumnMapping("Nota1", "Nota1"), new System.Data.Common.DataColumnMapping("Razonsocial", "Razonsocial"), new System.Data.Common.DataColumnMapping("Ubicacion", "Ubicacion"), new System.Data.Common.DataColumnMapping("Colonia", "Colonia"), new System.Data.Common.DataColumnMapping("Zona", "Zona") }) }); // // sqlCommand2 // this.sqlCommand2.CommandText = "[CompactaRep1]"; 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.Char, 10) }); // // chbRespaldo // this.chbRespaldo.ForeColor = System.Drawing.Color.White; this.chbRespaldo.Location = new System.Drawing.Point(805, 23); this.chbRespaldo.Name = "chbRespaldo"; this.chbRespaldo.Size = new System.Drawing.Size(116, 24); this.chbRespaldo.TabIndex = 44; this.chbRespaldo.Text = "Respaldo"; // // InfCompacta // this.AutoScaleBaseSize = new System.Drawing.Size(5, 13); this.ClientSize = new System.Drawing.Size(1028, 605); this.Controls.Add(this.crvInfCompacta); this.Controls.Add(this.panel1); this.Name = "InfCompacta"; this.Text = "InfCompacta"; this.WindowState = System.Windows.Forms.FormWindowState.Maximized; this.Load += new System.EventHandler(this.InfCompacta_Load); ((System.ComponentModel.ISupportInitialize)(this.dsCompactaRep1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.dsBusObra1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.dsFirmas1)).EndInit(); this.panel1.ResumeLayout(false); this.panel1.PerformLayout(); ((System.ComponentModel.ISupportInitialize)(this.dsCompactaMdor1)).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.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(Presupuesto)); System.Configuration.AppSettingsReader configurationAppSettings = new System.Configuration.AppSettingsReader(); System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle1 = new System.Windows.Forms.DataGridViewCellStyle(); System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle2 = new System.Windows.Forms.DataGridViewCellStyle(); System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle3 = new System.Windows.Forms.DataGridViewCellStyle(); this.sqlDAPresupuesto = 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.dsPresupuesto1 = new LancNeo.dsPresupuesto(); this.panel2 = new System.Windows.Forms.Panel(); 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.dsConcepto1 = new LancNeo.dsConcepto(); this.sqlDAConcepto = new System.Data.SqlClient.SqlDataAdapter(); this.sqlSelectCommand3 = new System.Data.SqlClient.SqlCommand(); this.sqlDABusObra = new System.Data.SqlClient.SqlDataAdapter(); this.sqlCommand1 = new System.Data.SqlClient.SqlCommand(); this.dgPresupuestos = new System.Windows.Forms.DataGridView(); this.idObraDataGridViewTextBoxColumn = new System.Windows.Forms.DataGridViewTextBoxColumn(); this.renglonDataGridViewTextBoxColumn = new System.Windows.Forms.DataGridViewTextBoxColumn(); this.idConceptoDataGridViewTextBoxColumn = new System.Windows.Forms.DataGridViewComboBoxColumn(); this.cantidadDataGridViewTextBoxColumn = new System.Windows.Forms.DataGridViewTextBoxColumn(); this.importeDataGridViewTextBoxColumn = new System.Windows.Forms.DataGridViewTextBoxColumn(); this.panelToolBar.SuspendLayout(); ((System.ComponentModel.ISupportInitialize)(this.dsPresupuesto1)).BeginInit(); this.panel2.SuspendLayout(); ((System.ComponentModel.ISupportInitialize)(this.dsBusObra1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.dsConcepto1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.dgPresupuestos)).BeginInit(); this.SuspendLayout(); // // statusBar1 // this.statusBar1.Location = new System.Drawing.Point(0, 441); this.statusBar1.ShowPanels = true; this.statusBar1.Size = new System.Drawing.Size(578, 22); // // panelToolBar // this.panelToolBar.Size = new System.Drawing.Size(578, 64); // // sqlDAPresupuesto // this.sqlDAPresupuesto.DeleteCommand = this.sqlDeleteCommand1; this.sqlDAPresupuesto.InsertCommand = this.sqlInsertCommand1; this.sqlDAPresupuesto.SelectCommand = this.sqlSelectCommand1; this.sqlDAPresupuesto.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping("Table", "Presupuesto", new System.Data.Common.DataColumnMapping[] { new System.Data.Common.DataColumnMapping("IdObra", "IdObra"), new System.Data.Common.DataColumnMapping("Renglon", "Renglon"), new System.Data.Common.DataColumnMapping("IdConcepto", "IdConcepto"), new System.Data.Common.DataColumnMapping("Cantidad", "Cantidad"), new System.Data.Common.DataColumnMapping("importe", "importe") }) }); this.sqlDAPresupuesto.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_IdObra", System.Data.SqlDbType.NVarChar, 6, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "IdObra", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_Renglon", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Renglon", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_Cantidad", System.Data.SqlDbType.Decimal, 9, System.Data.ParameterDirection.Input, false, ((byte)(18)), ((byte)(4)), "Cantidad", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_IdConcepto", System.Data.SqlDbType.SmallInt, 2, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "IdConcepto", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_importe", System.Data.SqlDbType.Decimal, 9, System.Data.ParameterDirection.Input, false, ((byte)(18)), ((byte)(2)), "importe", 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("@IdObra", System.Data.SqlDbType.NVarChar, 6, "IdObra"), new System.Data.SqlClient.SqlParameter("@Renglon", System.Data.SqlDbType.Int, 4, "Renglon"), new System.Data.SqlClient.SqlParameter("@IdConcepto", System.Data.SqlDbType.SmallInt, 2, "IdConcepto"), new System.Data.SqlClient.SqlParameter("@Cantidad", System.Data.SqlDbType.Decimal, 9, System.Data.ParameterDirection.Input, false, ((byte)(18)), ((byte)(4)), "Cantidad", System.Data.DataRowVersion.Current, null), new System.Data.SqlClient.SqlParameter("@importe", System.Data.SqlDbType.Decimal, 9, System.Data.ParameterDirection.Input, false, ((byte)(18)), ((byte)(2)), "importe", System.Data.DataRowVersion.Current, null) }); // // sqlSelectCommand1 // this.sqlSelectCommand1.CommandText = "SELECT IdObra, Renglon, IdConcepto, Cantidad, importe FROM Presupuesto WHERE (IdO" + "bra = @IdObra) ORDER BY IdObra, IdConcepto"; 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") }); // // sqlUpdateCommand1 // this.sqlUpdateCommand1.CommandText = resources.GetString("sqlUpdateCommand1.CommandText"); this.sqlUpdateCommand1.Connection = this.sqlConn; this.sqlUpdateCommand1.Parameters.AddRange(new System.Data.SqlClient.SqlParameter[] { new System.Data.SqlClient.SqlParameter("@IdObra", System.Data.SqlDbType.NVarChar, 6, "IdObra"), new System.Data.SqlClient.SqlParameter("@Renglon", System.Data.SqlDbType.Int, 4, "Renglon"), new System.Data.SqlClient.SqlParameter("@IdConcepto", System.Data.SqlDbType.SmallInt, 2, "IdConcepto"), new System.Data.SqlClient.SqlParameter("@Cantidad", System.Data.SqlDbType.Decimal, 9, System.Data.ParameterDirection.Input, false, ((byte)(18)), ((byte)(4)), "Cantidad", System.Data.DataRowVersion.Current, null), new System.Data.SqlClient.SqlParameter("@importe", System.Data.SqlDbType.Decimal, 9, System.Data.ParameterDirection.Input, false, ((byte)(18)), ((byte)(2)), "importe", System.Data.DataRowVersion.Current, null), new System.Data.SqlClient.SqlParameter("@Original_IdObra", System.Data.SqlDbType.NVarChar, 6, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "IdObra", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_Renglon", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Renglon", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_Cantidad", System.Data.SqlDbType.Decimal, 9, System.Data.ParameterDirection.Input, false, ((byte)(18)), ((byte)(4)), "Cantidad", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_IdConcepto", System.Data.SqlDbType.SmallInt, 2, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "IdConcepto", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_importe", System.Data.SqlDbType.Decimal, 9, System.Data.ParameterDirection.Input, false, ((byte)(18)), ((byte)(2)), "importe", System.Data.DataRowVersion.Original, null) }); // // dsPresupuesto1 // this.dsPresupuesto1.DataSetName = "dsPresupuesto"; this.dsPresupuesto1.Locale = new System.Globalization.CultureInfo("es-MX"); this.dsPresupuesto1.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema; // // panel2 // this.panel2.BorderStyle = System.Windows.Forms.BorderStyle.Fixed3D; this.panel2.Controls.Add(this.cmbIdObra); this.panel2.Controls.Add(this.label1); this.panel2.Controls.Add(this.txtIdObra); this.panel2.Location = new System.Drawing.Point(0, 72); this.panel2.Name = "panel2"; this.panel2.Size = new System.Drawing.Size(572, 32); this.panel2.TabIndex = 4; this.panel2.Paint += new System.Windows.Forms.PaintEventHandler(this.panel2_Paint); // // cmbIdObra // this.cmbIdObra.DataSource = this.dsBusObra1.Obra; this.cmbIdObra.DisplayMember = "Idobra"; this.cmbIdObra.Location = new System.Drawing.Point(128, 2); this.cmbIdObra.Name = "cmbIdObra"; this.cmbIdObra.Size = new System.Drawing.Size(64, 21); this.cmbIdObra.TabIndex = 3; 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.AutoSize = true; this.label1.Location = new System.Drawing.Point(82, 4); this.label1.Name = "label1"; this.label1.Size = new System.Drawing.Size(40, 13); this.label1.TabIndex = 0; this.label1.Text = "Idobra:"; // // txtIdObra // this.txtIdObra.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dsPresupuesto1, "Presupuesto.IdObra", true)); this.txtIdObra.Location = new System.Drawing.Point(130, 2); this.txtIdObra.Name = "txtIdObra"; this.txtIdObra.Size = new System.Drawing.Size(48, 20); this.txtIdObra.TabIndex = 7; this.txtIdObra.Text = "textBox1"; // // dsConcepto1 // this.dsConcepto1.DataSetName = "dsConcepto"; this.dsConcepto1.Locale = new System.Globalization.CultureInfo("es-MX"); this.dsConcepto1.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema; // // sqlDAConcepto // this.sqlDAConcepto.SelectCommand = this.sqlSelectCommand3; this.sqlDAConcepto.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping("Table", "Concepto", new System.Data.Common.DataColumnMapping[] { new System.Data.Common.DataColumnMapping("IdConcepto", "IdConcepto"), new System.Data.Common.DataColumnMapping("Concepto", "Concepto") }) }); // // sqlSelectCommand3 // this.sqlSelectCommand3.CommandText = "SELECT IdConcepto, Concepto FROM Concepto ORDER BY Concepto"; this.sqlSelectCommand3.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 = "SELECT Obra.Idobra, Obra.Ubicacion, Obra.RFC, Razonsocial.Facturar FROM Obra LEFT" + " OUTER JOIN Razonsocial ON Obra.IdCliente = Razonsocial.IdCliente AND Obra.RFC =" + " Razonsocial.RFC ORDER BY Obra.Idobra"; this.sqlCommand1.Connection = this.sqlConn; // // dgPresupuestos // dataGridViewCellStyle1.BackColor = System.Drawing.Color.White; dataGridViewCellStyle1.ForeColor = System.Drawing.Color.Black; dataGridViewCellStyle1.SelectionBackColor = System.Drawing.Color.White; dataGridViewCellStyle1.SelectionForeColor = System.Drawing.Color.DimGray; this.dgPresupuestos.AlternatingRowsDefaultCellStyle = dataGridViewCellStyle1; this.dgPresupuestos.AutoGenerateColumns = false; this.dgPresupuestos.BackgroundColor = System.Drawing.SystemColors.HighlightText; this.dgPresupuestos.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.AutoSize; this.dgPresupuestos.Columns.AddRange(new System.Windows.Forms.DataGridViewColumn[] { this.idObraDataGridViewTextBoxColumn, this.renglonDataGridViewTextBoxColumn, this.idConceptoDataGridViewTextBoxColumn, this.cantidadDataGridViewTextBoxColumn, this.importeDataGridViewTextBoxColumn }); this.dgPresupuestos.DataMember = "Presupuesto"; this.dgPresupuestos.DataSource = this.dsPresupuesto1; dataGridViewCellStyle2.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleLeft; dataGridViewCellStyle2.BackColor = System.Drawing.Color.White; dataGridViewCellStyle2.Font = new System.Drawing.Font("Microsoft Sans Serif", 8.25F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0))); dataGridViewCellStyle2.ForeColor = System.Drawing.Color.Black; dataGridViewCellStyle2.SelectionBackColor = System.Drawing.Color.White; dataGridViewCellStyle2.SelectionForeColor = System.Drawing.Color.DimGray; dataGridViewCellStyle2.WrapMode = System.Windows.Forms.DataGridViewTriState.False; this.dgPresupuestos.DefaultCellStyle = dataGridViewCellStyle2; this.dgPresupuestos.Location = new System.Drawing.Point(2, 108); this.dgPresupuestos.Name = "dgPresupuestos"; dataGridViewCellStyle3.BackColor = System.Drawing.Color.White; dataGridViewCellStyle3.ForeColor = System.Drawing.Color.Black; dataGridViewCellStyle3.SelectionBackColor = System.Drawing.Color.White; dataGridViewCellStyle3.SelectionForeColor = System.Drawing.Color.DimGray; this.dgPresupuestos.RowsDefaultCellStyle = dataGridViewCellStyle3; this.dgPresupuestos.RowTemplate.DefaultCellStyle.BackColor = System.Drawing.Color.White; this.dgPresupuestos.RowTemplate.DefaultCellStyle.Font = new System.Drawing.Font("Microsoft Sans Serif", 8.25F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0))); this.dgPresupuestos.RowTemplate.DefaultCellStyle.ForeColor = System.Drawing.Color.Black; this.dgPresupuestos.RowTemplate.DefaultCellStyle.SelectionBackColor = System.Drawing.Color.White; this.dgPresupuestos.RowTemplate.DefaultCellStyle.SelectionForeColor = System.Drawing.Color.DimGray; this.dgPresupuestos.Size = new System.Drawing.Size(570, 328); this.dgPresupuestos.TabIndex = 6; // // idObraDataGridViewTextBoxColumn // this.idObraDataGridViewTextBoxColumn.DataPropertyName = "IdObra"; this.idObraDataGridViewTextBoxColumn.HeaderText = "IdObra"; this.idObraDataGridViewTextBoxColumn.Name = "idObraDataGridViewTextBoxColumn"; this.idObraDataGridViewTextBoxColumn.Visible = false; this.idObraDataGridViewTextBoxColumn.Width = 5; // // renglonDataGridViewTextBoxColumn // this.renglonDataGridViewTextBoxColumn.DataPropertyName = "Renglon"; this.renglonDataGridViewTextBoxColumn.HeaderText = "Renglon"; this.renglonDataGridViewTextBoxColumn.Name = "renglonDataGridViewTextBoxColumn"; this.renglonDataGridViewTextBoxColumn.Width = 60; // // idConceptoDataGridViewTextBoxColumn // this.idConceptoDataGridViewTextBoxColumn.DataPropertyName = "IdConcepto"; this.idConceptoDataGridViewTextBoxColumn.DataSource = this.dsConcepto1; this.idConceptoDataGridViewTextBoxColumn.DisplayMember = "Concepto.Concepto"; this.idConceptoDataGridViewTextBoxColumn.HeaderText = "IdConcepto"; this.idConceptoDataGridViewTextBoxColumn.Name = "idConceptoDataGridViewTextBoxColumn"; this.idConceptoDataGridViewTextBoxColumn.Resizable = System.Windows.Forms.DataGridViewTriState.True; this.idConceptoDataGridViewTextBoxColumn.SortMode = System.Windows.Forms.DataGridViewColumnSortMode.Automatic; this.idConceptoDataGridViewTextBoxColumn.ValueMember = "Concepto.IdConcepto"; this.idConceptoDataGridViewTextBoxColumn.Width = 300; // // cantidadDataGridViewTextBoxColumn // this.cantidadDataGridViewTextBoxColumn.DataPropertyName = "Cantidad"; this.cantidadDataGridViewTextBoxColumn.HeaderText = "Cantidad"; this.cantidadDataGridViewTextBoxColumn.Name = "cantidadDataGridViewTextBoxColumn"; this.cantidadDataGridViewTextBoxColumn.Width = 75; // // importeDataGridViewTextBoxColumn // this.importeDataGridViewTextBoxColumn.DataPropertyName = "importe"; this.importeDataGridViewTextBoxColumn.HeaderText = "importe"; this.importeDataGridViewTextBoxColumn.Name = "importeDataGridViewTextBoxColumn"; this.importeDataGridViewTextBoxColumn.Width = 75; // // Presupuesto // this.AutoScaleBaseSize = new System.Drawing.Size(5, 13); this.ClientSize = new System.Drawing.Size(578, 463); this.Controls.Add(this.dgPresupuestos); this.Controls.Add(this.panel2); this.DAGeneral = this.sqlDAPresupuesto; this.dsGeneral = this.dsPresupuesto1; this.Name = "Presupuesto"; this.NombreTabla = "Presupuesto"; this.Text = "Presupuesto"; this.Load += new System.EventHandler(this.Presupuesto_Load); this.Controls.SetChildIndex(this.panel2, 0); this.Controls.SetChildIndex(this.statusBar1, 0); this.Controls.SetChildIndex(this.panelToolBar, 0); this.Controls.SetChildIndex(this.dgPresupuestos, 0); this.panelToolBar.ResumeLayout(false); ((System.ComponentModel.ISupportInitialize)(this.dsPresupuesto1)).EndInit(); this.panel2.ResumeLayout(false); this.panel2.PerformLayout(); ((System.ComponentModel.ISupportInitialize)(this.dsBusObra1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.dsConcepto1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.dgPresupuestos)).EndInit(); this.ResumeLayout(false); }