public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() { CryRepAceroO rpt = new CryRepAceroO(); rpt.Site = this.Site; return(rpt); }
/// <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(InfAcero)); 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.dsAceroMdor1 = new LancNeo.dsAceroMdor(); this.chbTodos = new System.Windows.Forms.CheckBox(); this.chbLab1 = new System.Windows.Forms.CheckBox(); this.label6 = new System.Windows.Forms.Label(); this.Fecha = new System.Windows.Forms.Label(); this.groupBox1 = new System.Windows.Forms.GroupBox(); this.rbColada = new System.Windows.Forms.RadioButton(); this.radioButton1 = new System.Windows.Forms.RadioButton(); this.chbLab = new System.Windows.Forms.CheckBox(); this.chbFormato = new System.Windows.Forms.CheckBox(); this.chbLeyenda = new System.Windows.Forms.CheckBox(); this.chbDuplicado = new System.Windows.Forms.CheckBox(); this.txtFolio = new System.Windows.Forms.TextBox(); this.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.txtIdobra = new System.Windows.Forms.TextBox(); this.sqlDABusObra = new System.Data.SqlClient.SqlDataAdapter(); this.sqlCommand1 = new System.Data.SqlClient.SqlCommand(); this.sqlConn = new System.Data.SqlClient.SqlConnection(); this.sqlDAAceroMdor = new System.Data.SqlClient.SqlDataAdapter(); this.sqlSelectCommand1 = new System.Data.SqlClient.SqlCommand(); this.crvInfAcero = new CrystalDecisions.Windows.Forms.CrystalReportViewer(); this.cryRepAcero1 = new LancNeo.CryRepAcero(); this.sqlDAInfAcero = new System.Data.SqlClient.SqlDataAdapter(); this.sqlSelectCommand2 = new System.Data.SqlClient.SqlCommand(); this.dsAceroRep1 = new LancNeo.dsAceroRep(); 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.cryRepAceroO1 = new LancNeo.CryRepAceroO(); this.chbRespaldo = new System.Windows.Forms.CheckBox(); this.panel1.SuspendLayout(); ((System.ComponentModel.ISupportInitialize)(this.dsAceroMdor1)).BeginInit(); this.groupBox1.SuspendLayout(); ((System.ComponentModel.ISupportInitialize)(this.dsUnidad1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.dsBusObra1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.dsAceroRep1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.dsFirmas1)).BeginInit(); this.SuspendLayout(); // // panel1 // this.panel1.BackColor = System.Drawing.SystemColors.Highlight; 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.chbLab1); this.panel1.Controls.Add(this.label6); this.panel1.Controls.Add(this.Fecha); this.panel1.Controls.Add(this.groupBox1); this.panel1.Controls.Add(this.chbLab); this.panel1.Controls.Add(this.chbFormato); this.panel1.Controls.Add(this.chbLeyenda); this.panel1.Controls.Add(this.chbDuplicado); this.panel1.Controls.Add(this.txtFolio); this.panel1.Controls.Add(this.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.txtIdobra); this.panel1.Dock = System.Windows.Forms.DockStyle.Top; this.panel1.ForeColor = System.Drawing.Color.White; this.panel1.Location = new System.Drawing.Point(0, 0); this.panel1.Name = "panel1"; this.panel1.Size = new System.Drawing.Size(993, 90); this.panel1.TabIndex = 10; // // 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(910, 15); 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); // // buscaBtn1 // this.buscaBtn1.AnchoColTit = true; this.buscaBtn1.AnchoDlgBusq = 650; this.buscaBtn1.BackColor = System.Drawing.Color.Transparent; this.buscaBtn1.Datos = this.dsAceroMdor1.AceroMdor; this.buscaBtn1.Icon = ((System.Drawing.Icon)(resources.GetObject("buscaBtn1.Icon"))); this.buscaBtn1.Location = new System.Drawing.Point(382, 2); this.buscaBtn1.Name = "buscaBtn1"; this.buscaBtn1.Size = new System.Drawing.Size(49, 54); this.buscaBtn1.TabIndex = 2; this.buscaBtn1.Visible = false; this.buscaBtn1.Click += new System.EventHandler(this.buscaBtn1_Click); // // dsAceroMdor1 // this.dsAceroMdor1.DataSetName = "dsAceroMdor"; this.dsAceroMdor1.Locale = new System.Globalization.CultureInfo("es-MX"); this.dsAceroMdor1.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema; // // chbTodos // this.chbTodos.Location = new System.Drawing.Point(763, 3); this.chbTodos.Name = "chbTodos"; this.chbTodos.Size = new System.Drawing.Size(141, 24); this.chbTodos.TabIndex = 45; this.chbTodos.Text = "Todos los informes"; // // 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(356, 55); this.chbLab1.Name = "chbLab1"; this.chbLab1.Size = new System.Drawing.Size(133, 24); this.chbLab1.TabIndex = 40; this.chbLab1.Text = "Incluye laboratorista"; // // label6 // this.label6.AutoSize = true; this.label6.ForeColor = System.Drawing.Color.White; this.label6.Location = new System.Drawing.Point(431, 24); this.label6.Name = "label6"; this.label6.Size = new System.Drawing.Size(61, 13); this.label6.TabIndex = 26; this.label6.Text = "Renglones:"; // // Fecha // this.Fecha.AutoSize = true; this.Fecha.Location = new System.Drawing.Point(431, 3); this.Fecha.Name = "Fecha"; this.Fecha.Size = new System.Drawing.Size(32, 13); this.Fecha.TabIndex = 4; this.Fecha.Text = "Folio:"; // // groupBox1 // this.groupBox1.Controls.Add(this.rbColada); this.groupBox1.Controls.Add(this.radioButton1); this.groupBox1.Location = new System.Drawing.Point(637, 22); this.groupBox1.Name = "groupBox1"; this.groupBox1.Size = new System.Drawing.Size(120, 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(491, 55); this.chbLab.Name = "chbLab"; this.chbLab.Size = new System.Drawing.Size(115, 24); this.chbLab.TabIndex = 39; this.chbLab.Text = "Incluye laboratorio"; // // chbFormato // this.chbFormato.ForeColor = System.Drawing.Color.White; this.chbFormato.Location = new System.Drawing.Point(531, 3); this.chbFormato.Name = "chbFormato"; this.chbFormato.Size = new System.Drawing.Size(184, 24); this.chbFormato.TabIndex = 33; this.chbFormato.Text = "Incluye imagen de acreditación"; // // chbLeyenda // this.chbLeyenda.Checked = true; this.chbLeyenda.CheckState = System.Windows.Forms.CheckState.Checked; this.chbLeyenda.ForeColor = System.Drawing.Color.White; this.chbLeyenda.Location = new System.Drawing.Point(531, 32); 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(252, 54); this.chbDuplicado.Name = "chbDuplicado"; this.chbDuplicado.Size = new System.Drawing.Size(89, 24); this.chbDuplicado.TabIndex = 30; this.chbDuplicado.Text = "¿Duplicado?"; // // txtFolio // this.txtFolio.Location = new System.Drawing.Point(471, 3); this.txtFolio.Name = "txtFolio"; this.txtFolio.Size = new System.Drawing.Size(55, 20); this.txtFolio.TabIndex = 27; // // txtRenglon // this.txtRenglon.Location = new System.Drawing.Point(502, 24); this.txtRenglon.MaxLength = 2; this.txtRenglon.Name = "txtRenglon"; this.txtRenglon.Size = new System.Drawing.Size(24, 20); this.txtRenglon.TabIndex = 25; this.txtRenglon.Text = "20"; this.txtRenglon.TextAlign = System.Windows.Forms.HorizontalAlignment.Right; // // cmbUnidad // this.cmbUnidad.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(299, 28); 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.Location = new System.Drawing.Point(254, 28); 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.Location = new System.Drawing.Point(266, 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(299, 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(8, 0); this.label1.Name = "label1"; this.label1.Size = new System.Drawing.Size(272, 83); this.label1.TabIndex = 0; this.label1.Text = "Informe de verificación de calidad del acero de refuerzo"; // // txtIdobra // this.txtIdobra.Location = new System.Drawing.Point(223, 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; // // 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; // // sqlDAAceroMdor // this.sqlDAAceroMdor.SelectCommand = this.sqlSelectCommand1; this.sqlDAAceroMdor.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping("Table", "AceroMdor", 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 AceroMdor 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") }); // // 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.Location = new System.Drawing.Point(0, 90); this.crvInfAcero.Name = "crvInfAcero"; this.crvInfAcero.ReuseParameterValuesOnRefresh = true; this.crvInfAcero.ShowCloseButton = false; this.crvInfAcero.ShowGroupTreeButton = false; this.crvInfAcero.ShowLogo = false; this.crvInfAcero.Size = new System.Drawing.Size(993, 434); this.crvInfAcero.TabIndex = 11; this.crvInfAcero.ToolPanelView = CrystalDecisions.Windows.Forms.ToolPanelViewType.None; this.crvInfAcero.Load += new System.EventHandler(this.crvInfAcero_Load); // // sqlDAInfAcero // this.sqlDAInfAcero.SelectCommand = this.sqlSelectCommand2; this.sqlDAInfAcero.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping("Table", "AceroRep", 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 = "[AceroRep]"; 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), new System.Data.SqlClient.SqlParameter("@Numren", System.Data.SqlDbType.SmallInt, 2) }); // // dsAceroRep1 // this.dsAceroRep1.DataSetName = "dsAceroRep"; this.dsAceroRep1.Locale = new System.Globalization.CultureInfo("es-MX"); this.dsAceroRep1.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 (Acero < 6)\r\nORDER BY Acero"; 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)"; 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(763, 28); this.chbRespaldo.Name = "chbRespaldo"; this.chbRespaldo.Size = new System.Drawing.Size(82, 24); this.chbRespaldo.TabIndex = 82; this.chbRespaldo.Text = "Respaldo"; // // InfAcero // this.AutoScaleBaseSize = new System.Drawing.Size(5, 13); this.ClientSize = new System.Drawing.Size(993, 524); this.Controls.Add(this.crvInfAcero); this.Controls.Add(this.panel1); this.Name = "InfAcero"; this.Text = "InfAcero"; this.WindowState = System.Windows.Forms.FormWindowState.Maximized; this.Load += new System.EventHandler(this.InfAcero_Load); this.panel1.ResumeLayout(false); this.panel1.PerformLayout(); ((System.ComponentModel.ISupportInitialize)(this.dsAceroMdor1)).EndInit(); this.groupBox1.ResumeLayout(false); this.groupBox1.PerformLayout(); ((System.ComponentModel.ISupportInitialize)(this.dsUnidad1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.dsBusObra1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.dsAceroRep1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.dsFirmas1)).EndInit(); this.ResumeLayout(false); }