/// <summary> /// Método necesario para admitir el Diseñador. No se puede modificar /// el contenido del método con el editor de código. /// </summary> private void InitializeComponent() { System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(Concepto)); System.Configuration.AppSettingsReader configurationAppSettings = new System.Configuration.AppSettingsReader(); this.panel2 = new System.Windows.Forms.Panel(); this.buscaBtn1 = new Soluciones2000.Tools.WinLib.BuscaBtn(); this.dsConcepto1 = new LancNeo.dsConcepto(); this.txtConcepto = new System.Windows.Forms.TextBox(); this.label2 = new System.Windows.Forms.Label(); this.txtIdConcepto = new System.Windows.Forms.TextBox(); this.label1 = new System.Windows.Forms.Label(); this.sqlDAConcepto = new System.Data.SqlClient.SqlDataAdapter(); this.sqlDeleteCommand1 = new System.Data.SqlClient.SqlCommand(); this.sqlConn = new System.Data.SqlClient.SqlConnection(); this.sqlInsertCommand1 = new System.Data.SqlClient.SqlCommand(); this.sqlSelectCommand1 = new System.Data.SqlClient.SqlCommand(); this.sqlUpdateCommand1 = new System.Data.SqlClient.SqlCommand(); this.panelToolBar.SuspendLayout(); this.panel2.SuspendLayout(); ((System.ComponentModel.ISupportInitialize)(this.dsConcepto1)).BeginInit(); this.SuspendLayout(); // // statusBar1 // this.statusBar1.Location = new System.Drawing.Point(0, 351); this.statusBar1.ShowPanels = true; this.statusBar1.Size = new System.Drawing.Size(600, 22); // // panelToolBar // this.panelToolBar.Size = new System.Drawing.Size(600, 64); // // panel2 // this.panel2.BorderStyle = System.Windows.Forms.BorderStyle.Fixed3D; this.panel2.Controls.Add(this.buscaBtn1); this.panel2.Controls.Add(this.txtConcepto); this.panel2.Controls.Add(this.label2); this.panel2.Controls.Add(this.txtIdConcepto); this.panel2.Controls.Add(this.label1); this.panel2.Location = new System.Drawing.Point(96, 128); this.panel2.Name = "panel2"; this.panel2.Size = new System.Drawing.Size(448, 144); this.panel2.TabIndex = 4; // // buscaBtn1 // this.buscaBtn1.AnchoDlgBusq = 0; this.buscaBtn1.BackColor = System.Drawing.Color.Transparent; this.buscaBtn1.Datos = this.dsConcepto1.Concepto; this.buscaBtn1.Icon = ((System.Drawing.Icon)(resources.GetObject("buscaBtn1.Icon"))); this.buscaBtn1.Location = new System.Drawing.Point(224, 0); this.buscaBtn1.Name = "buscaBtn1"; this.buscaBtn1.Size = new System.Drawing.Size(64, 64); this.buscaBtn1.TabIndex = 4; this.toolTip1.SetToolTip(this.buscaBtn1, "Buscar"); // // dsConcepto1 // this.dsConcepto1.DataSetName = "dsConcepto"; this.dsConcepto1.Locale = new System.Globalization.CultureInfo("es-MX"); this.dsConcepto1.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema; // // txtConcepto // this.txtConcepto.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dsConcepto1, "Concepto.Concepto", true)); this.txtConcepto.Location = new System.Drawing.Point(104, 88); this.txtConcepto.Name = "txtConcepto"; this.txtConcepto.Size = new System.Drawing.Size(312, 20); this.txtConcepto.TabIndex = 3; this.txtConcepto.Text = "textBox1"; // // label2 // this.label2.AutoSize = true; this.label2.Location = new System.Drawing.Point(33, 88); this.label2.Name = "label2"; this.label2.Size = new System.Drawing.Size(56, 13); this.label2.TabIndex = 2; this.label2.Text = "Concepto:"; // // txtIdConcepto // this.txtIdConcepto.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dsConcepto1, "Concepto.IdConcepto", true)); this.txtIdConcepto.Location = new System.Drawing.Point(104, 24); this.txtIdConcepto.Name = "txtIdConcepto"; this.txtIdConcepto.Size = new System.Drawing.Size(100, 20); this.txtIdConcepto.TabIndex = 1; this.txtIdConcepto.Text = "textBox1"; this.txtIdConcepto.TextChanged += new System.EventHandler(this.txtIdConcepto_TextChanged); // // label1 // this.label1.AutoSize = true; this.label1.Location = new System.Drawing.Point(24, 24); this.label1.Name = "label1"; this.label1.Size = new System.Drawing.Size(65, 13); this.label1.TabIndex = 0; this.label1.Text = "IdConcepto:"; this.label1.Click += new System.EventHandler(this.label1_Click); // // sqlDAConcepto // this.sqlDAConcepto.DeleteCommand = this.sqlDeleteCommand1; this.sqlDAConcepto.InsertCommand = this.sqlInsertCommand1; this.sqlDAConcepto.SelectCommand = this.sqlSelectCommand1; this.sqlDAConcepto.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping("Table", "Concepto", new System.Data.Common.DataColumnMapping[] { new System.Data.Common.DataColumnMapping("IdConcepto", "IdConcepto"), new System.Data.Common.DataColumnMapping("Concepto", "Concepto") }) }); this.sqlDAConcepto.UpdateCommand = this.sqlUpdateCommand1; // // sqlDeleteCommand1 // this.sqlDeleteCommand1.CommandText = "DELETE FROM Concepto WHERE (IdConcepto = @Original_IdConcepto) AND (Concepto = @O" + "riginal_Concepto OR @Original_Concepto IS NULL AND Concepto IS NULL)"; this.sqlDeleteCommand1.Connection = this.sqlConn; this.sqlDeleteCommand1.Parameters.AddRange(new System.Data.SqlClient.SqlParameter[] { new System.Data.SqlClient.SqlParameter("@Original_IdConcepto", System.Data.SqlDbType.SmallInt, 2, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "IdConcepto", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_Concepto", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Concepto", System.Data.DataRowVersion.Original, null) }); // // sqlConn // this.sqlConn.ConnectionString = ((string)(configurationAppSettings.GetValue("sqlConn.ConnectionString", typeof(string)))); this.sqlConn.FireInfoMessageEventOnUserErrors = false; // // sqlInsertCommand1 // this.sqlInsertCommand1.CommandText = "INSERT INTO Concepto(IdConcepto, Concepto) VALUES (@IdConcepto, @Concepto); SELEC" + "T IdConcepto, Concepto FROM Concepto WHERE (IdConcepto = @IdConcepto)"; this.sqlInsertCommand1.Connection = this.sqlConn; this.sqlInsertCommand1.Parameters.AddRange(new System.Data.SqlClient.SqlParameter[] { new System.Data.SqlClient.SqlParameter("@IdConcepto", System.Data.SqlDbType.SmallInt, 2, "IdConcepto"), new System.Data.SqlClient.SqlParameter("@Concepto", System.Data.SqlDbType.VarChar, 50, "Concepto") }); // // sqlSelectCommand1 // this.sqlSelectCommand1.CommandText = "SELECT IdConcepto, Concepto FROM Concepto"; this.sqlSelectCommand1.Connection = this.sqlConn; // // sqlUpdateCommand1 // this.sqlUpdateCommand1.CommandText = resources.GetString("sqlUpdateCommand1.CommandText"); this.sqlUpdateCommand1.Connection = this.sqlConn; this.sqlUpdateCommand1.Parameters.AddRange(new System.Data.SqlClient.SqlParameter[] { new System.Data.SqlClient.SqlParameter("@IdConcepto", System.Data.SqlDbType.SmallInt, 2, "IdConcepto"), new System.Data.SqlClient.SqlParameter("@Concepto", System.Data.SqlDbType.VarChar, 50, "Concepto"), new System.Data.SqlClient.SqlParameter("@Original_IdConcepto", System.Data.SqlDbType.SmallInt, 2, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "IdConcepto", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_Concepto", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Concepto", System.Data.DataRowVersion.Original, null) }); // // Concepto // this.AutoScaleBaseSize = new System.Drawing.Size(5, 13); this.ClientSize = new System.Drawing.Size(600, 373); this.Controls.Add(this.panel2); this.DAGeneral = this.sqlDAConcepto; this.dsGeneral = this.dsConcepto1; this.Name = "Concepto"; this.NombreTabla = "Concepto"; this.Text = "Concepto"; this.Load += new System.EventHandler(this.Concepto_Load); this.Controls.SetChildIndex(this.panel2, 0); this.Controls.SetChildIndex(this.statusBar1, 0); this.Controls.SetChildIndex(this.panelToolBar, 0); this.panelToolBar.ResumeLayout(false); this.panel2.ResumeLayout(false); this.panel2.PerformLayout(); ((System.ComponentModel.ISupportInitialize)(this.dsConcepto1)).EndInit(); this.ResumeLayout(false); }
/// <summary> /// Método necesario para admitir el Diseñador. No se puede modificar /// el contenido del método con el editor de código. /// </summary> private void InitializeComponent() { System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(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(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); }