/// <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);
}
