/// <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(ToronMdor));
System.Configuration.AppSettingsReader configurationAppSettings = new System.Configuration.AppSettingsReader();
this.panel2 = new System.Windows.Forms.Panel();
this.buscaBtn1 = new Soluciones2000.Tools.WinLib.BuscaBtn();
this.dsToronMdor1 = new LancNeo.dsToronMdor();
this.txtObserva = new System.Windows.Forms.TextBox();
this.txtMuestreadasen = new System.Windows.Forms.TextBox();
this.txtSemana = new System.Windows.Forms.TextBox();
this.cmbNoeco = new System.Windows.Forms.ComboBox();
this.dsLaboratorista1 = new LancNeo.dsLaboratorista();
this.dtpFinforme = new System.Windows.Forms.DateTimePicker();
this.dtpFensaye = new System.Windows.Forms.DateTimePicker();
this.dtpFmuestreo = new System.Windows.Forms.DateTimePicker();
this.txtConsecutivo = new System.Windows.Forms.TextBox();
this.cmbIdObra = new System.Windows.Forms.ComboBox();
this.dsBusObra1 = new LancNeo.dsBusObra();
this.txtFolio = new System.Windows.Forms.TextBox();
this.label10 = new System.Windows.Forms.Label();
this.label9 = new System.Windows.Forms.Label();
this.label8 = new System.Windows.Forms.Label();
this.label7 = new System.Windows.Forms.Label();
this.label6 = new System.Windows.Forms.Label();
this.label5 = new System.Windows.Forms.Label();
this.label4 = new System.Windows.Forms.Label();
this.label3 = new System.Windows.Forms.Label();
this.label2 = new System.Windows.Forms.Label();
this.label1 = new System.Windows.Forms.Label();
this.sqlDAToronMdor = new System.Data.SqlClient.SqlDataAdapter();
this.sqlDeleteCommand1 = new System.Data.SqlClient.SqlCommand();
this.sqlConn = new System.Data.SqlClient.SqlConnection();
this.sqlInsertCommand1 = new System.Data.SqlClient.SqlCommand();
this.sqlSelectCommand1 = new System.Data.SqlClient.SqlCommand();
this.sqlUpdateCommand1 = new System.Data.SqlClient.SqlCommand();
this.sqlDABusObra = new System.Data.SqlClient.SqlDataAdapter();
this.sqlCommand1 = new System.Data.SqlClient.SqlCommand();
this.sqlDALaboratorista = new System.Data.SqlClient.SqlDataAdapter();
this.sqlSelectCommand5 = new System.Data.SqlClient.SqlCommand();
this.txtUsrMov = new System.Windows.Forms.TextBox();
this.label28 = new System.Windows.Forms.Label();
this.panelToolBar.SuspendLayout();
this.panel2.SuspendLayout();
((System.ComponentModel.ISupportInitialize)(this.dsToronMdor1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.dsLaboratorista1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.dsBusObra1)).BeginInit();
this.SuspendLayout();
//
// statusBar1
//
this.statusBar1.Location = new System.Drawing.Point(0, 431);
this.statusBar1.ShowPanels = true;
this.statusBar1.Size = new System.Drawing.Size(584, 22);
//
// panelToolBar
//
this.panelToolBar.Size = new System.Drawing.Size(584, 64);
//
// panel2
//
this.panel2.BorderStyle = System.Windows.Forms.BorderStyle.Fixed3D;
this.panel2.Controls.Add(this.buscaBtn1);
this.panel2.Controls.Add(this.txtUsrMov);
this.panel2.Controls.Add(this.label28);
this.panel2.Controls.Add(this.txtObserva);
this.panel2.Controls.Add(this.txtMuestreadasen);
this.panel2.Controls.Add(this.txtSemana);
this.panel2.Controls.Add(this.cmbNoeco);
this.panel2.Controls.Add(this.dtpFinforme);
this.panel2.Controls.Add(this.dtpFensaye);
this.panel2.Controls.Add(this.dtpFmuestreo);
this.panel2.Controls.Add(this.txtConsecutivo);
this.panel2.Controls.Add(this.cmbIdObra);
this.panel2.Controls.Add(this.txtFolio);
this.panel2.Controls.Add(this.label10);
this.panel2.Controls.Add(this.label9);
this.panel2.Controls.Add(this.label8);
this.panel2.Controls.Add(this.label7);
this.panel2.Controls.Add(this.label6);
this.panel2.Controls.Add(this.label5);
this.panel2.Controls.Add(this.label4);
this.panel2.Controls.Add(this.label3);
this.panel2.Controls.Add(this.label2);
this.panel2.Controls.Add(this.label1);
this.panel2.Location = new System.Drawing.Point(24, 66);
this.panel2.Name = "panel2";
this.panel2.Size = new System.Drawing.Size(536, 320);
this.panel2.TabIndex = 7;
//
// buscaBtn1
//
this.buscaBtn1.AnchoColTit = true;
this.buscaBtn1.AnchoDlgBusq = 675;
this.buscaBtn1.BackColor = System.Drawing.Color.Transparent;
this.buscaBtn1.Datos = this.dsToronMdor1.Toron7AlamMdor;
this.buscaBtn1.Icon = ((System.Drawing.Icon)(resources.GetObject("buscaBtn1.Icon")));
this.buscaBtn1.Location = new System.Drawing.Point(202, 6);
this.buscaBtn1.Name = "buscaBtn1";
this.buscaBtn1.Size = new System.Drawing.Size(64, 64);
this.buscaBtn1.TabIndex = 20;
//
// dsToronMdor1
//
this.dsToronMdor1.DataSetName = "dsToronMdor";
this.dsToronMdor1.Locale = new System.Globalization.CultureInfo("es-MX");
this.dsToronMdor1.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema;
//
// txtObserva
//
this.txtObserva.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dsToronMdor1, "Toron7AlamMdor.Observaciones", true));
this.txtObserva.Location = new System.Drawing.Point(126, 238);
this.txtObserva.MaxLength = 512;
this.txtObserva.Multiline = true;
this.txtObserva.Name = "txtObserva";
this.txtObserva.ScrollBars = System.Windows.Forms.ScrollBars.Vertical;
this.txtObserva.Size = new System.Drawing.Size(394, 68);
this.txtObserva.TabIndex = 19;
this.txtObserva.Text = "textBox5";
//
// txtMuestreadasen
//
this.txtMuestreadasen.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dsToronMdor1, "Toron7AlamMdor.MuestreadasEn", true));
this.txtMuestreadasen.Location = new System.Drawing.Point(126, 214);
this.txtMuestreadasen.Name = "txtMuestreadasen";
this.txtMuestreadasen.Size = new System.Drawing.Size(100, 20);
this.txtMuestreadasen.TabIndex = 18;
this.txtMuestreadasen.Text = "textBox4";
//
// txtSemana
//
this.txtSemana.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dsToronMdor1, "Toron7AlamMdor.Semana", true));
this.txtSemana.Location = new System.Drawing.Point(126, 190);
this.txtSemana.MaxLength = 2;
this.txtSemana.Name = "txtSemana";
this.txtSemana.Size = new System.Drawing.Size(66, 20);
this.txtSemana.TabIndex = 17;
this.txtSemana.Text = "textBox3";
//
// cmbNoeco
//
this.cmbNoeco.DataBindings.Add(new System.Windows.Forms.Binding("SelectedValue", this.dsToronMdor1, "Toron7AlamMdor.NoEco", true));
this.cmbNoeco.DataSource = this.dsLaboratorista1.Laboratorista;
this.cmbNoeco.DisplayMember = "Laboratorista";
this.cmbNoeco.Location = new System.Drawing.Point(126, 166);
this.cmbNoeco.Name = "cmbNoeco";
this.cmbNoeco.Size = new System.Drawing.Size(392, 21);
this.cmbNoeco.TabIndex = 16;
this.cmbNoeco.ValueMember = "NoEco";
//
// dsLaboratorista1
//
this.dsLaboratorista1.DataSetName = "dsLaboratorista";
this.dsLaboratorista1.Locale = new System.Globalization.CultureInfo("es-MX");
this.dsLaboratorista1.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema;
//
// dtpFinforme
//
this.dtpFinforme.CustomFormat = "dd/MM/yyyy";
this.dtpFinforme.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dsToronMdor1, "Toron7AlamMdor.FInforme", true));
this.dtpFinforme.Format = System.Windows.Forms.DateTimePickerFormat.Custom;
this.dtpFinforme.Location = new System.Drawing.Point(126, 142);
this.dtpFinforme.Name = "dtpFinforme";
this.dtpFinforme.Size = new System.Drawing.Size(84, 20);
this.dtpFinforme.TabIndex = 15;
//
// dtpFensaye
//
this.dtpFensaye.CustomFormat = "dd/MM/yyyy";
this.dtpFensaye.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dsToronMdor1, "Toron7AlamMdor.FEnsaye", true));
this.dtpFensaye.Format = System.Windows.Forms.DateTimePickerFormat.Custom;
this.dtpFensaye.Location = new System.Drawing.Point(126, 118);
this.dtpFensaye.Name = "dtpFensaye";
this.dtpFensaye.Size = new System.Drawing.Size(84, 20);
this.dtpFensaye.TabIndex = 14;
//
// dtpFmuestreo
//
this.dtpFmuestreo.CustomFormat = "dd/MM/yyyy";
this.dtpFmuestreo.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dsToronMdor1, "Toron7AlamMdor.FMuestreo", true));
this.dtpFmuestreo.Format = System.Windows.Forms.DateTimePickerFormat.Custom;
this.dtpFmuestreo.Location = new System.Drawing.Point(126, 94);
this.dtpFmuestreo.Name = "dtpFmuestreo";
this.dtpFmuestreo.Size = new System.Drawing.Size(84, 20);
this.dtpFmuestreo.TabIndex = 13;
//
// txtConsecutivo
//
this.txtConsecutivo.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dsToronMdor1, "Toron7AlamMdor.ConsObra", true));
this.txtConsecutivo.Location = new System.Drawing.Point(126, 70);
this.txtConsecutivo.MaxLength = 4;
this.txtConsecutivo.Name = "txtConsecutivo";
this.txtConsecutivo.Size = new System.Drawing.Size(66, 20);
this.txtConsecutivo.TabIndex = 12;
this.txtConsecutivo.Text = "textBox2";
//
// cmbIdObra
//
this.cmbIdObra.DataBindings.Add(new System.Windows.Forms.Binding("SelectedValue", this.dsToronMdor1, "Toron7AlamMdor.Idobra", true));
this.cmbIdObra.DataSource = this.dsBusObra1.Obra;
this.cmbIdObra.DisplayMember = "Idobra";
this.cmbIdObra.Location = new System.Drawing.Point(126, 46);
this.cmbIdObra.Name = "cmbIdObra";
this.cmbIdObra.Size = new System.Drawing.Size(66, 21);
this.cmbIdObra.TabIndex = 11;
this.cmbIdObra.ValueMember = "Idobra";
//
// dsBusObra1
//
this.dsBusObra1.DataSetName = "dsBusObra";
this.dsBusObra1.Locale = new System.Globalization.CultureInfo("es-MX");
this.dsBusObra1.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema;
//
// txtFolio
//
this.txtFolio.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dsToronMdor1, "Toron7AlamMdor.FOLIO", true));
this.txtFolio.Location = new System.Drawing.Point(126, 22);
this.txtFolio.MaxLength = 10;
this.txtFolio.Name = "txtFolio";
this.txtFolio.Size = new System.Drawing.Size(64, 20);
this.txtFolio.TabIndex = 10;
this.txtFolio.Text = "textBox1";
//
// label10
//
this.label10.AutoSize = true;
this.label10.Location = new System.Drawing.Point(30, 240);
this.label10.Name = "label10";
this.label10.Size = new System.Drawing.Size(81, 13);
this.label10.TabIndex = 9;
this.label10.Text = "Observaciones:";
this.label10.TextAlign = System.Drawing.ContentAlignment.MiddleRight;
//
// label9
//
this.label9.AutoSize = true;
this.label9.Location = new System.Drawing.Point(25, 216);
this.label9.Name = "label9";
this.label9.Size = new System.Drawing.Size(86, 13);
this.label9.TabIndex = 8;
this.label9.Text = "Muestreadas en:";
this.label9.TextAlign = System.Drawing.ContentAlignment.MiddleRight;
//
// label8
//
this.label8.AutoSize = true;
this.label8.Location = new System.Drawing.Point(63, 192);
this.label8.Name = "label8";
this.label8.Size = new System.Drawing.Size(49, 13);
this.label8.TabIndex = 7;
this.label8.Text = "Semana:";
this.label8.TextAlign = System.Drawing.ContentAlignment.MiddleRight;
//
// label7
//
this.label7.AutoSize = true;
this.label7.Location = new System.Drawing.Point(36, 168);
this.label7.Name = "label7";
this.label7.Size = new System.Drawing.Size(75, 13);
this.label7.TabIndex = 6;
this.label7.Text = "Ensayado por:";
this.label7.TextAlign = System.Drawing.ContentAlignment.MiddleRight;
//
// label6
//
this.label6.AutoSize = true;
this.label6.Location = new System.Drawing.Point(33, 144);
this.label6.Name = "label6";
this.label6.Size = new System.Drawing.Size(77, 13);
this.label6.TabIndex = 5;
this.label6.Text = "Fecha informe:";
this.label6.TextAlign = System.Drawing.ContentAlignment.MiddleRight;
//
// label5
//
this.label5.AutoSize = true;
this.label5.Location = new System.Drawing.Point(19, 120);
this.label5.Name = "label5";
this.label5.Size = new System.Drawing.Size(92, 13);
this.label5.TabIndex = 4;
this.label5.Text = "Fecha de ensaye:";
this.label5.TextAlign = System.Drawing.ContentAlignment.MiddleRight;
//
// label4
//
this.label4.AutoSize = true;
this.label4.Location = new System.Drawing.Point(8, 96);
this.label4.Name = "label4";
this.label4.Size = new System.Drawing.Size(101, 13);
this.label4.TabIndex = 3;
this.label4.Text = "Fecha de muestreo:";
this.label4.TextAlign = System.Drawing.ContentAlignment.MiddleRight;
//
// label3
//
this.label3.AutoSize = true;
this.label3.Location = new System.Drawing.Point(43, 72);
this.label3.Name = "label3";
this.label3.Size = new System.Drawing.Size(69, 13);
this.label3.TabIndex = 2;
this.label3.Text = "Consecutivo:";
this.label3.TextAlign = System.Drawing.ContentAlignment.MiddleRight;
//
// label2
//
this.label2.AutoSize = true;
this.label2.Location = new System.Drawing.Point(81, 48);
this.label2.Name = "label2";
this.label2.Size = new System.Drawing.Size(33, 13);
this.label2.TabIndex = 1;
this.label2.Text = "Obra:";
this.label2.TextAlign = System.Drawing.ContentAlignment.MiddleRight;
//
// label1
//
this.label1.AutoSize = true;
this.label1.Location = new System.Drawing.Point(72, 24);
this.label1.Name = "label1";
this.label1.Size = new System.Drawing.Size(41, 13);
this.label1.TabIndex = 0;
this.label1.Text = "FOLIO:";
this.label1.TextAlign = System.Drawing.ContentAlignment.MiddleRight;
//
// sqlDAToronMdor
//
this.sqlDAToronMdor.DeleteCommand = this.sqlDeleteCommand1;
this.sqlDAToronMdor.InsertCommand = this.sqlInsertCommand1;
this.sqlDAToronMdor.SelectCommand = this.sqlSelectCommand1;
this.sqlDAToronMdor.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
new System.Data.Common.DataTableMapping("Table", "Toron7AlamMdor", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("FOLIO", "FOLIO"),
new System.Data.Common.DataColumnMapping("Idobra", "Idobra"),
new System.Data.Common.DataColumnMapping("ConsObra", "ConsObra"),
new System.Data.Common.DataColumnMapping("FMuestreo", "FMuestreo"),
new System.Data.Common.DataColumnMapping("FEnsaye", "FEnsaye"),
new System.Data.Common.DataColumnMapping("FInforme", "FInforme"),
new System.Data.Common.DataColumnMapping("NoEco", "NoEco"),
new System.Data.Common.DataColumnMapping("Semana", "Semana"),
new System.Data.Common.DataColumnMapping("MuestreadasEn", "MuestreadasEn"),
new System.Data.Common.DataColumnMapping("Observaciones", "Observaciones"),
new System.Data.Common.DataColumnMapping("IdUsuario", "IdUsuario")
})
});
this.sqlDAToronMdor.UpdateCommand = this.sqlUpdateCommand1;
//
// sqlDeleteCommand1
//
this.sqlDeleteCommand1.CommandText = resources.GetString("sqlDeleteCommand1.CommandText");
this.sqlDeleteCommand1.Connection = this.sqlConn;
this.sqlDeleteCommand1.Parameters.AddRange(new System.Data.SqlClient.SqlParameter[] {
new System.Data.SqlClient.SqlParameter("@Original_FOLIO", System.Data.SqlDbType.Char, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "FOLIO", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@Original_Idobra", System.Data.SqlDbType.NVarChar, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Idobra", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@IsNull_ConsObra", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "ConsObra", System.Data.DataRowVersion.Original, true, null, "", "", ""),
new System.Data.SqlClient.SqlParameter("@Original_ConsObra", System.Data.SqlDbType.SmallInt, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "ConsObra", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@IsNull_FMuestreo", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "FMuestreo", System.Data.DataRowVersion.Original, true, null, "", "", ""),
new System.Data.SqlClient.SqlParameter("@Original_FMuestreo", System.Data.SqlDbType.SmallDateTime, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "FMuestreo", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@IsNull_FEnsaye", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "FEnsaye", System.Data.DataRowVersion.Original, true, null, "", "", ""),
new System.Data.SqlClient.SqlParameter("@Original_FEnsaye", System.Data.SqlDbType.SmallDateTime, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "FEnsaye", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@IsNull_FInforme", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "FInforme", System.Data.DataRowVersion.Original, true, null, "", "", ""),
new System.Data.SqlClient.SqlParameter("@Original_FInforme", System.Data.SqlDbType.SmallDateTime, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "FInforme", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@IsNull_NoEco", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "NoEco", System.Data.DataRowVersion.Original, true, null, "", "", ""),
new System.Data.SqlClient.SqlParameter("@Original_NoEco", System.Data.SqlDbType.SmallInt, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "NoEco", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@IsNull_Semana", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "Semana", System.Data.DataRowVersion.Original, true, null, "", "", ""),
new System.Data.SqlClient.SqlParameter("@Original_Semana", System.Data.SqlDbType.SmallInt, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Semana", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@IsNull_MuestreadasEn", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "MuestreadasEn", System.Data.DataRowVersion.Original, true, null, "", "", ""),
new System.Data.SqlClient.SqlParameter("@Original_MuestreadasEn", System.Data.SqlDbType.NVarChar, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "MuestreadasEn", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@IsNull_Observaciones", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "Observaciones", System.Data.DataRowVersion.Original, true, null, "", "", ""),
new System.Data.SqlClient.SqlParameter("@Original_Observaciones", System.Data.SqlDbType.NVarChar, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Observaciones", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@IsNull_IdUsuario", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "IdUsuario", System.Data.DataRowVersion.Original, true, null, "", "", ""),
new System.Data.SqlClient.SqlParameter("@Original_IdUsuario", System.Data.SqlDbType.VarChar, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "IdUsuario", System.Data.DataRowVersion.Original, null)
});
//
// sqlConn
//
this.sqlConn.ConnectionString = ((string)(configurationAppSettings.GetValue("sqlConn.ConnectionString", typeof(string))));
this.sqlConn.FireInfoMessageEventOnUserErrors = false;
//
// sqlInsertCommand1
//
this.sqlInsertCommand1.CommandText = resources.GetString("sqlInsertCommand1.CommandText");
this.sqlInsertCommand1.Connection = this.sqlConn;
this.sqlInsertCommand1.Parameters.AddRange(new System.Data.SqlClient.SqlParameter[] {
new System.Data.SqlClient.SqlParameter("@FOLIO", System.Data.SqlDbType.Char, 0, "FOLIO"),
new System.Data.SqlClient.SqlParameter("@Idobra", System.Data.SqlDbType.NVarChar, 0, "Idobra"),
new System.Data.SqlClient.SqlParameter("@ConsObra", System.Data.SqlDbType.SmallInt, 0, "ConsObra"),
new System.Data.SqlClient.SqlParameter("@FMuestreo", System.Data.SqlDbType.SmallDateTime, 0, "FMuestreo"),
new System.Data.SqlClient.SqlParameter("@FEnsaye", System.Data.SqlDbType.SmallDateTime, 0, "FEnsaye"),
new System.Data.SqlClient.SqlParameter("@FInforme", System.Data.SqlDbType.SmallDateTime, 0, "FInforme"),
new System.Data.SqlClient.SqlParameter("@NoEco", System.Data.SqlDbType.SmallInt, 0, "NoEco"),
new System.Data.SqlClient.SqlParameter("@Semana", System.Data.SqlDbType.SmallInt, 0, "Semana"),
new System.Data.SqlClient.SqlParameter("@MuestreadasEn", System.Data.SqlDbType.NVarChar, 0, "MuestreadasEn"),
new System.Data.SqlClient.SqlParameter("@Observaciones", System.Data.SqlDbType.NVarChar, 0, "Observaciones"),
new System.Data.SqlClient.SqlParameter("@IdUsuario", System.Data.SqlDbType.VarChar, 0, "IdUsuario")
});
//
// sqlSelectCommand1
//
this.sqlSelectCommand1.CommandText = "SELECT FOLIO, Idobra, ConsObra, FMuestreo, FEnsaye, FInforme, NoEco, Seman" +
"a, MuestreadasEn, Observaciones, IdUsuario\r\nFROM Toron7AlamMdor";
this.sqlSelectCommand1.Connection = this.sqlConn;
//
// sqlUpdateCommand1
//
this.sqlUpdateCommand1.CommandText = resources.GetString("sqlUpdateCommand1.CommandText");
this.sqlUpdateCommand1.Connection = this.sqlConn;
this.sqlUpdateCommand1.Parameters.AddRange(new System.Data.SqlClient.SqlParameter[] {
new System.Data.SqlClient.SqlParameter("@FOLIO", System.Data.SqlDbType.Char, 0, "FOLIO"),
new System.Data.SqlClient.SqlParameter("@Idobra", System.Data.SqlDbType.NVarChar, 0, "Idobra"),
new System.Data.SqlClient.SqlParameter("@ConsObra", System.Data.SqlDbType.SmallInt, 0, "ConsObra"),
new System.Data.SqlClient.SqlParameter("@FMuestreo", System.Data.SqlDbType.SmallDateTime, 0, "FMuestreo"),
new System.Data.SqlClient.SqlParameter("@FEnsaye", System.Data.SqlDbType.SmallDateTime, 0, "FEnsaye"),
new System.Data.SqlClient.SqlParameter("@FInforme", System.Data.SqlDbType.SmallDateTime, 0, "FInforme"),
new System.Data.SqlClient.SqlParameter("@NoEco", System.Data.SqlDbType.SmallInt, 0, "NoEco"),
new System.Data.SqlClient.SqlParameter("@Semana", System.Data.SqlDbType.SmallInt, 0, "Semana"),
new System.Data.SqlClient.SqlParameter("@MuestreadasEn", System.Data.SqlDbType.NVarChar, 0, "MuestreadasEn"),
new System.Data.SqlClient.SqlParameter("@Observaciones", System.Data.SqlDbType.NVarChar, 0, "Observaciones"),
new System.Data.SqlClient.SqlParameter("@IdUsuario", System.Data.SqlDbType.VarChar, 0, "IdUsuario"),
new System.Data.SqlClient.SqlParameter("@Original_FOLIO", System.Data.SqlDbType.Char, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "FOLIO", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@Original_Idobra", System.Data.SqlDbType.NVarChar, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Idobra", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@IsNull_ConsObra", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "ConsObra", System.Data.DataRowVersion.Original, true, null, "", "", ""),
new System.Data.SqlClient.SqlParameter("@Original_ConsObra", System.Data.SqlDbType.SmallInt, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "ConsObra", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@IsNull_FMuestreo", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "FMuestreo", System.Data.DataRowVersion.Original, true, null, "", "", ""),
new System.Data.SqlClient.SqlParameter("@Original_FMuestreo", System.Data.SqlDbType.SmallDateTime, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "FMuestreo", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@IsNull_FEnsaye", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "FEnsaye", System.Data.DataRowVersion.Original, true, null, "", "", ""),
new System.Data.SqlClient.SqlParameter("@Original_FEnsaye", System.Data.SqlDbType.SmallDateTime, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "FEnsaye", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@IsNull_FInforme", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "FInforme", System.Data.DataRowVersion.Original, true, null, "", "", ""),
new System.Data.SqlClient.SqlParameter("@Original_FInforme", System.Data.SqlDbType.SmallDateTime, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "FInforme", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@IsNull_NoEco", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "NoEco", System.Data.DataRowVersion.Original, true, null, "", "", ""),
new System.Data.SqlClient.SqlParameter("@Original_NoEco", System.Data.SqlDbType.SmallInt, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "NoEco", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@IsNull_Semana", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "Semana", System.Data.DataRowVersion.Original, true, null, "", "", ""),
new System.Data.SqlClient.SqlParameter("@Original_Semana", System.Data.SqlDbType.SmallInt, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Semana", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@IsNull_MuestreadasEn", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "MuestreadasEn", System.Data.DataRowVersion.Original, true, null, "", "", ""),
new System.Data.SqlClient.SqlParameter("@Original_MuestreadasEn", System.Data.SqlDbType.NVarChar, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "MuestreadasEn", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@IsNull_Observaciones", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "Observaciones", System.Data.DataRowVersion.Original, true, null, "", "", ""),
new System.Data.SqlClient.SqlParameter("@Original_Observaciones", System.Data.SqlDbType.NVarChar, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Observaciones", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@IsNull_IdUsuario", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "IdUsuario", System.Data.DataRowVersion.Original, true, null, "", "", ""),
new System.Data.SqlClient.SqlParameter("@Original_IdUsuario", System.Data.SqlDbType.VarChar, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "IdUsuario", System.Data.DataRowVersion.Original, null)
});
//
// sqlDABusObra
//
this.sqlDABusObra.SelectCommand = this.sqlCommand1;
this.sqlDABusObra.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
new System.Data.Common.DataTableMapping("Table", "Obra", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("Idobra", "Idobra"),
new System.Data.Common.DataColumnMapping("Ubicacion", "Ubicacion"),
new System.Data.Common.DataColumnMapping("RFC", "RFC"),
new System.Data.Common.DataColumnMapping("Facturar", "Facturar")
})
});
//
// sqlCommand1
//
this.sqlCommand1.CommandText = "SELECT Obra.Idobra, Obra.Ubicacion, Obra.RFC, Razonsocial.Facturar FROM Obra LEFT" +
" OUTER JOIN Razonsocial ON Obra.IdCliente = Razonsocial.IdCliente AND Obra.RFC =" +
" Razonsocial.RFC ORDER BY Obra.Idobra";
this.sqlCommand1.Connection = this.sqlConn;
//
// sqlDALaboratorista
//
this.sqlDALaboratorista.SelectCommand = this.sqlSelectCommand5;
this.sqlDALaboratorista.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
new System.Data.Common.DataTableMapping("Table", "Laboratorista", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("NoEco", "NoEco"),
new System.Data.Common.DataColumnMapping("Laboratorista", "Laboratorista"),
new System.Data.Common.DataColumnMapping("IdZona", "IdZona"),
new System.Data.Common.DataColumnMapping("IdNivel", "IdNivel"),
new System.Data.Common.DataColumnMapping("Fechai", "Fechai")
})
});
//
// sqlSelectCommand5
//
this.sqlSelectCommand5.CommandText = "SELECT NoEco, LTRIM(STR(NoEco)) + \' \' + Laboratorista AS Laboratorista, IdZona, I" +
"dNivel, Fechai FROM Laboratorista ORDER BY NoEco";
this.sqlSelectCommand5.Connection = this.sqlConn;
//
// txtUsrMov
//
this.txtUsrMov.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dsToronMdor1, "Toron7AlamMdor.IdUsuario", true));
this.txtUsrMov.Location = new System.Drawing.Point(400, 26);
this.txtUsrMov.Name = "txtUsrMov";
this.txtUsrMov.ReadOnly = true;
this.txtUsrMov.Size = new System.Drawing.Size(68, 20);
this.txtUsrMov.TabIndex = 52;
//
// label28
//
this.label28.AutoSize = true;
this.label28.Font = new System.Drawing.Font("Microsoft Sans Serif", 8.25F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
this.label28.ForeColor = System.Drawing.Color.Red;
this.label28.Location = new System.Drawing.Point(339, 30);
this.label28.Name = "label28";
this.label28.Size = new System.Drawing.Size(54, 13);
this.label28.TabIndex = 51;
this.label28.Text = "Usuario:";
this.label28.TextAlign = System.Drawing.ContentAlignment.MiddleRight;
//
// ToronMdor
//
this.AutoScaleBaseSize = new System.Drawing.Size(5, 13);
this.ClientSize = new System.Drawing.Size(584, 453);
this.Controls.Add(this.panel2);
this.DAGeneral = this.sqlDAToronMdor;
this.dsGeneral = this.dsToronMdor1;
this.Name = "ToronMdor";
this.NombreTabla = "Toron7AlamMdor";
this.Text = "ToronMdor";
this.Load += new System.EventHandler(this.ToronMdor_Load);
this.Controls.SetChildIndex(this.statusBar1, 0);
this.Controls.SetChildIndex(this.panelToolBar, 0);
this.Controls.SetChildIndex(this.panel2, 0);
this.panelToolBar.ResumeLayout(false);
this.panel2.ResumeLayout(false);
this.panel2.PerformLayout();
((System.ComponentModel.ISupportInitialize)(this.dsToronMdor1)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.dsLaboratorista1)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.dsBusObra1)).EndInit();
this.ResumeLayout(false);
}
/// <summary>
/// Método necesario para admitir el Diseñador. No se puede modificar
/// el contenido del método con el editor de código.
/// </summary>
private void InitializeComponent()
{
System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(Laboratorista));
System.Configuration.AppSettingsReader configurationAppSettings = new System.Configuration.AppSettingsReader();
this.sqlDALaboratorista = 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.dsLaboratorista1 = new LancNeo.dsLaboratorista();
this.panel1 = new System.Windows.Forms.Panel();
this.buscaBtn1 = new Soluciones2000.Tools.WinLib.BuscaBtn();
this.dtpFecha = new System.Windows.Forms.DateTimePicker();
this.cmbZona = new System.Windows.Forms.ComboBox();
this.dsZona1 = new LancNeo.dsZona();
this.txtNoEco = new System.Windows.Forms.TextBox();
this.lblNoEco = new System.Windows.Forms.Label();
this.lblLaboratorista = new System.Windows.Forms.Label();
this.lblZona = new System.Windows.Forms.Label();
this.lblNivel = new System.Windows.Forms.Label();
this.lblFecha = new System.Windows.Forms.Label();
this.txtLaboratorista = new System.Windows.Forms.TextBox();
this.cmbNivel = new System.Windows.Forms.ComboBox();
this.dsNivel1 = new LancNeo.dsNivel();
this.sqlDAZona = new System.Data.SqlClient.SqlDataAdapter();
this.sqlCommand1 = new System.Data.SqlClient.SqlCommand();
this.sqlCommand2 = new System.Data.SqlClient.SqlCommand();
this.sqlCommand3 = new System.Data.SqlClient.SqlCommand();
this.sqlCommand4 = new System.Data.SqlClient.SqlCommand();
this.sqlDANivel = new System.Data.SqlClient.SqlDataAdapter();
this.sqlCommand5 = new System.Data.SqlClient.SqlCommand();
this.sqlCommand6 = new System.Data.SqlClient.SqlCommand();
this.sqlCommand7 = new System.Data.SqlClient.SqlCommand();
this.sqlCommand8 = new System.Data.SqlClient.SqlCommand();
this.sqlDABusq = new System.Data.SqlClient.SqlDataAdapter();
this.sqlCommand11 = new System.Data.SqlClient.SqlCommand();
this.panelToolBar.SuspendLayout();
((System.ComponentModel.ISupportInitialize)(this.dsLaboratorista1)).BeginInit();
this.panel1.SuspendLayout();
((System.ComponentModel.ISupportInitialize)(this.dsZona1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.dsNivel1)).BeginInit();
this.SuspendLayout();
//
// statusBar1
//
this.statusBar1.ShowPanels = true;
this.statusBar1.Size = new System.Drawing.Size(576, 22);
//
// panelToolBar
//
this.panelToolBar.Size = new System.Drawing.Size(576, 64);
//
// sqlDALaboratorista
//
this.sqlDALaboratorista.DeleteCommand = this.sqlDeleteCommand1;
this.sqlDALaboratorista.InsertCommand = this.sqlInsertCommand1;
this.sqlDALaboratorista.SelectCommand = this.sqlSelectCommand1;
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")
})
});
this.sqlDALaboratorista.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_NoEco", System.Data.SqlDbType.SmallInt, 2, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "NoEco", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@Original_Fechai", System.Data.SqlDbType.DateTime, 8, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Fechai", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@Original_IdNivel", System.Data.SqlDbType.SmallInt, 2, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "IdNivel", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@Original_IdZona", System.Data.SqlDbType.NVarChar, 1, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "IdZona", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@Original_Laboratorista", System.Data.SqlDbType.NVarChar, 50, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Laboratorista", 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("@NoEco", System.Data.SqlDbType.SmallInt, 2, "NoEco"),
new System.Data.SqlClient.SqlParameter("@Laboratorista", System.Data.SqlDbType.NVarChar, 50, "Laboratorista"),
new System.Data.SqlClient.SqlParameter("@IdZona", System.Data.SqlDbType.NVarChar, 1, "IdZona"),
new System.Data.SqlClient.SqlParameter("@IdNivel", System.Data.SqlDbType.SmallInt, 2, "IdNivel"),
new System.Data.SqlClient.SqlParameter("@Fechai", System.Data.SqlDbType.DateTime, 8, "Fechai")
});
//
// sqlSelectCommand1
//
this.sqlSelectCommand1.CommandText = "SELECT NoEco, Laboratorista, IdZona, IdNivel, Fechai FROM Laboratorista ORDER BY " +
"NoEco";
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("@NoEco", System.Data.SqlDbType.SmallInt, 2, "NoEco"),
new System.Data.SqlClient.SqlParameter("@Laboratorista", System.Data.SqlDbType.NVarChar, 50, "Laboratorista"),
new System.Data.SqlClient.SqlParameter("@IdZona", System.Data.SqlDbType.NVarChar, 1, "IdZona"),
new System.Data.SqlClient.SqlParameter("@IdNivel", System.Data.SqlDbType.SmallInt, 2, "IdNivel"),
new System.Data.SqlClient.SqlParameter("@Fechai", System.Data.SqlDbType.DateTime, 8, "Fechai"),
new System.Data.SqlClient.SqlParameter("@Original_NoEco", System.Data.SqlDbType.SmallInt, 2, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "NoEco", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@Original_Fechai", System.Data.SqlDbType.DateTime, 8, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Fechai", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@Original_IdNivel", System.Data.SqlDbType.SmallInt, 2, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "IdNivel", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@Original_IdZona", System.Data.SqlDbType.NVarChar, 1, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "IdZona", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@Original_Laboratorista", System.Data.SqlDbType.NVarChar, 50, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Laboratorista", System.Data.DataRowVersion.Original, null)
});
//
// dsLaboratorista1
//
this.dsLaboratorista1.DataSetName = "dsLaboratorista";
this.dsLaboratorista1.Locale = new System.Globalization.CultureInfo("es-MX");
this.dsLaboratorista1.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema;
//
// panel1
//
this.panel1.BorderStyle = System.Windows.Forms.BorderStyle.Fixed3D;
this.panel1.Controls.Add(this.buscaBtn1);
this.panel1.Controls.Add(this.dtpFecha);
this.panel1.Controls.Add(this.cmbZona);
this.panel1.Controls.Add(this.txtNoEco);
this.panel1.Controls.Add(this.lblNoEco);
this.panel1.Controls.Add(this.lblLaboratorista);
this.panel1.Controls.Add(this.lblZona);
this.panel1.Controls.Add(this.lblNivel);
this.panel1.Controls.Add(this.lblFecha);
this.panel1.Controls.Add(this.txtLaboratorista);
this.panel1.Controls.Add(this.cmbNivel);
this.panel1.Location = new System.Drawing.Point(80, 96);
this.panel1.Name = "panel1";
this.panel1.Size = new System.Drawing.Size(416, 256);
this.panel1.TabIndex = 0;
//
// buscaBtn1
//
this.buscaBtn1.AnchoDlgBusq = 450;
this.buscaBtn1.BackColor = System.Drawing.Color.Transparent;
this.buscaBtn1.Datos = this.dsLaboratorista1.Laboratorista;
this.buscaBtn1.Icon = ((System.Drawing.Icon)(resources.GetObject("buscaBtn1.Icon")));
this.buscaBtn1.Location = new System.Drawing.Point(248, 8);
this.buscaBtn1.Name = "buscaBtn1";
this.buscaBtn1.Size = new System.Drawing.Size(64, 64);
this.buscaBtn1.TabIndex = 4;
this.toolTip1.SetToolTip(this.buscaBtn1, "Buscar");
//
// dtpFecha
//
this.dtpFecha.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dsLaboratorista1, "Laboratorista.Fechai", true));
this.dtpFecha.Location = new System.Drawing.Point(144, 192);
this.dtpFecha.Name = "dtpFecha";
this.dtpFecha.Size = new System.Drawing.Size(200, 20);
this.dtpFecha.TabIndex = 3;
this.dtpFecha.Value = new System.DateTime(2004, 7, 7, 0, 0, 0, 0);
//
// cmbZona
//
this.cmbZona.DataBindings.Add(new System.Windows.Forms.Binding("SelectedValue", this.dsLaboratorista1, "Laboratorista.IdZona", true));
this.cmbZona.DataSource = this.dsZona1.Zona;
this.cmbZona.DisplayMember = "Zona";
this.cmbZona.Location = new System.Drawing.Point(144, 112);
this.cmbZona.Name = "cmbZona";
this.cmbZona.Size = new System.Drawing.Size(256, 21);
this.cmbZona.TabIndex = 2;
this.cmbZona.ValueMember = "IdZona";
//
// dsZona1
//
this.dsZona1.DataSetName = "dsZona";
this.dsZona1.Locale = new System.Globalization.CultureInfo("en-US");
this.dsZona1.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema;
//
// txtNoEco
//
this.txtNoEco.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dsLaboratorista1, "Laboratorista.NoEco", true));
this.txtNoEco.Location = new System.Drawing.Point(144, 32);
this.txtNoEco.Name = "txtNoEco";
this.txtNoEco.Size = new System.Drawing.Size(100, 20);
this.txtNoEco.TabIndex = 1;
this.txtNoEco.Text = "textBox1";
//
// lblNoEco
//
this.lblNoEco.Location = new System.Drawing.Point(8, 32);
this.lblNoEco.Name = "lblNoEco";
this.lblNoEco.Size = new System.Drawing.Size(112, 23);
this.lblNoEco.TabIndex = 0;
this.lblNoEco.Text = "Número económico:";
this.lblNoEco.TextAlign = System.Drawing.ContentAlignment.MiddleRight;
//
// lblLaboratorista
//
this.lblLaboratorista.Location = new System.Drawing.Point(8, 72);
this.lblLaboratorista.Name = "lblLaboratorista";
this.lblLaboratorista.Size = new System.Drawing.Size(112, 23);
this.lblLaboratorista.TabIndex = 0;
this.lblLaboratorista.Text = "Laboratorista:";
this.lblLaboratorista.TextAlign = System.Drawing.ContentAlignment.MiddleRight;
//
// lblZona
//
this.lblZona.Location = new System.Drawing.Point(8, 112);
this.lblZona.Name = "lblZona";
this.lblZona.Size = new System.Drawing.Size(112, 23);
this.lblZona.TabIndex = 0;
this.lblZona.Text = "Zona";
this.lblZona.TextAlign = System.Drawing.ContentAlignment.MiddleRight;
//
// lblNivel
//
this.lblNivel.Location = new System.Drawing.Point(8, 152);
this.lblNivel.Name = "lblNivel";
this.lblNivel.Size = new System.Drawing.Size(112, 23);
this.lblNivel.TabIndex = 0;
this.lblNivel.Text = "Nivel";
this.lblNivel.TextAlign = System.Drawing.ContentAlignment.MiddleRight;
//
// lblFecha
//
this.lblFecha.Location = new System.Drawing.Point(8, 192);
this.lblFecha.Name = "lblFecha";
this.lblFecha.Size = new System.Drawing.Size(112, 23);
this.lblFecha.TabIndex = 0;
this.lblFecha.Text = "Fecha de Ingreso:";
this.lblFecha.TextAlign = System.Drawing.ContentAlignment.MiddleRight;
//
// txtLaboratorista
//
this.txtLaboratorista.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dsLaboratorista1, "Laboratorista.Laboratorista", true));
this.txtLaboratorista.Location = new System.Drawing.Point(144, 72);
this.txtLaboratorista.Name = "txtLaboratorista";
this.txtLaboratorista.Size = new System.Drawing.Size(256, 20);
this.txtLaboratorista.TabIndex = 1;
this.txtLaboratorista.Text = "textBox1";
//
// cmbNivel
//
this.cmbNivel.DataBindings.Add(new System.Windows.Forms.Binding("SelectedValue", this.dsLaboratorista1, "Laboratorista.IdNivel", true));
this.cmbNivel.DataSource = this.dsNivel1.Nivel;
this.cmbNivel.DisplayMember = "Nivel";
this.cmbNivel.Location = new System.Drawing.Point(144, 152);
this.cmbNivel.Name = "cmbNivel";
this.cmbNivel.Size = new System.Drawing.Size(121, 21);
this.cmbNivel.TabIndex = 2;
this.cmbNivel.ValueMember = "IdNivel";
//
// dsNivel1
//
this.dsNivel1.DataSetName = "dsNivel";
this.dsNivel1.Locale = new System.Globalization.CultureInfo("es-MX");
this.dsNivel1.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema;
//
// sqlDAZona
//
this.sqlDAZona.DeleteCommand = this.sqlCommand1;
this.sqlDAZona.InsertCommand = this.sqlCommand2;
this.sqlDAZona.SelectCommand = this.sqlCommand3;
this.sqlDAZona.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
new System.Data.Common.DataTableMapping("Table", "Zona", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("IdZona", "IdZona"),
new System.Data.Common.DataColumnMapping("Zona", "Zona"),
new System.Data.Common.DataColumnMapping("Ubicación", "Ubicación")
})
});
this.sqlDAZona.UpdateCommand = this.sqlCommand4;
//
// sqlCommand1
//
this.sqlCommand1.CommandText = resources.GetString("sqlCommand1.CommandText");
this.sqlCommand1.Connection = this.sqlConn;
this.sqlCommand1.Parameters.AddRange(new System.Data.SqlClient.SqlParameter[] {
new System.Data.SqlClient.SqlParameter("@Original_IdZona", System.Data.SqlDbType.NVarChar, 1, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "IdZona", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@Original_Ubicación", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Ubicación", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@Original_Zona", System.Data.SqlDbType.NVarChar, 50, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Zona", System.Data.DataRowVersion.Original, null)
});
//
// sqlCommand2
//
this.sqlCommand2.CommandText = "INSERT INTO Zona(IdZona, Zona, Ubicación) VALUES (@IdZona, @Zona, @Ubicación); SE" +
"LECT IdZona, Zona, Ubicación FROM Zona WHERE (IdZona = @IdZona)";
this.sqlCommand2.Connection = this.sqlConn;
this.sqlCommand2.Parameters.AddRange(new System.Data.SqlClient.SqlParameter[] {
new System.Data.SqlClient.SqlParameter("@IdZona", System.Data.SqlDbType.NVarChar, 1, "IdZona"),
new System.Data.SqlClient.SqlParameter("@Zona", System.Data.SqlDbType.NVarChar, 50, "Zona"),
new System.Data.SqlClient.SqlParameter("@Ubicación", System.Data.SqlDbType.Int, 4, "Ubicación")
});
//
// sqlCommand3
//
this.sqlCommand3.CommandText = "SELECT IdZona, Zona, Ubicación FROM Zona";
this.sqlCommand3.Connection = this.sqlConn;
//
// sqlCommand4
//
this.sqlCommand4.CommandText = resources.GetString("sqlCommand4.CommandText");
this.sqlCommand4.Connection = this.sqlConn;
this.sqlCommand4.Parameters.AddRange(new System.Data.SqlClient.SqlParameter[] {
new System.Data.SqlClient.SqlParameter("@IdZona", System.Data.SqlDbType.NVarChar, 1, "IdZona"),
new System.Data.SqlClient.SqlParameter("@Zona", System.Data.SqlDbType.NVarChar, 50, "Zona"),
new System.Data.SqlClient.SqlParameter("@Ubicación", System.Data.SqlDbType.Int, 4, "Ubicación"),
new System.Data.SqlClient.SqlParameter("@Original_IdZona", System.Data.SqlDbType.NVarChar, 1, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "IdZona", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@Original_Ubicación", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Ubicación", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@Original_Zona", System.Data.SqlDbType.NVarChar, 50, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Zona", System.Data.DataRowVersion.Original, null)
});
//
// sqlDANivel
//
this.sqlDANivel.DeleteCommand = this.sqlCommand5;
this.sqlDANivel.InsertCommand = this.sqlCommand6;
this.sqlDANivel.SelectCommand = this.sqlCommand7;
this.sqlDANivel.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
new System.Data.Common.DataTableMapping("Table", "Nivel", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("IdNivel", "IdNivel"),
new System.Data.Common.DataColumnMapping("Nivel", "Nivel")
})
});
this.sqlDANivel.UpdateCommand = this.sqlCommand8;
//
// sqlCommand5
//
this.sqlCommand5.CommandText = "DELETE FROM Nivel WHERE (IdNivel = @Original_IdNivel) AND (Nivel = @Original_Nive" +
"l OR @Original_Nivel IS NULL AND Nivel IS NULL)";
this.sqlCommand5.Connection = this.sqlConn;
this.sqlCommand5.Parameters.AddRange(new System.Data.SqlClient.SqlParameter[] {
new System.Data.SqlClient.SqlParameter("@Original_IdNivel", System.Data.SqlDbType.SmallInt, 2, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "IdNivel", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@Original_Nivel", System.Data.SqlDbType.NVarChar, 50, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Nivel", System.Data.DataRowVersion.Original, null)
});
//
// sqlCommand6
//
this.sqlCommand6.CommandText = "INSERT INTO Nivel(IdNivel, Nivel) VALUES (@IdNivel, @Nivel); SELECT IdNivel, Nive" +
"l FROM Nivel WHERE (IdNivel = @IdNivel) ORDER BY IdNivel";
this.sqlCommand6.Connection = this.sqlConn;
this.sqlCommand6.Parameters.AddRange(new System.Data.SqlClient.SqlParameter[] {
new System.Data.SqlClient.SqlParameter("@IdNivel", System.Data.SqlDbType.SmallInt, 2, "IdNivel"),
new System.Data.SqlClient.SqlParameter("@Nivel", System.Data.SqlDbType.NVarChar, 50, "Nivel")
});
//
// sqlCommand7
//
this.sqlCommand7.CommandText = "SELECT IdNivel, Nivel FROM Nivel ORDER BY IdNivel";
this.sqlCommand7.Connection = this.sqlConn;
//
// sqlCommand8
//
this.sqlCommand8.CommandText = resources.GetString("sqlCommand8.CommandText");
this.sqlCommand8.Connection = this.sqlConn;
this.sqlCommand8.Parameters.AddRange(new System.Data.SqlClient.SqlParameter[] {
new System.Data.SqlClient.SqlParameter("@IdNivel", System.Data.SqlDbType.SmallInt, 2, "IdNivel"),
new System.Data.SqlClient.SqlParameter("@Nivel", System.Data.SqlDbType.NVarChar, 50, "Nivel"),
new System.Data.SqlClient.SqlParameter("@Original_IdNivel", System.Data.SqlDbType.SmallInt, 2, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "IdNivel", System.Data.DataRowVersion.Original, null),
new System.Data.SqlClient.SqlParameter("@Original_Nivel", System.Data.SqlDbType.NVarChar, 50, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Nivel", System.Data.DataRowVersion.Original, null)
});
//
// sqlDABusq
//
this.sqlDABusq.SelectCommand = this.sqlCommand11;
this.sqlDABusq.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")
})
});
//
// sqlCommand11
//
this.sqlCommand11.CommandText = resources.GetString("sqlCommand11.CommandText");
this.sqlCommand11.Connection = this.sqlConn;
//
// Laboratorista
//
this.AutoScaleBaseSize = new System.Drawing.Size(5, 13);
this.ClientSize = new System.Drawing.Size(576, 423);
this.Controls.Add(this.panel1);
this.DAGeneral = this.sqlDALaboratorista;
this.dsGeneral = this.dsLaboratorista1;
this.Name = "Laboratorista";
this.NombreTabla = "Laboratorista";
this.Text = "Laboratorista";
this.Load += new System.EventHandler(this.Laboratorista_Load);
this.Controls.SetChildIndex(this.panel1, 0);
this.Controls.SetChildIndex(this.statusBar1, 0);
this.Controls.SetChildIndex(this.panelToolBar, 0);
this.panelToolBar.ResumeLayout(false);
((System.ComponentModel.ISupportInitialize)(this.dsLaboratorista1)).EndInit();
this.panel1.ResumeLayout(false);
this.panel1.PerformLayout();
((System.ComponentModel.ISupportInitialize)(this.dsZona1)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.dsNivel1)).EndInit();
this.ResumeLayout(false);
}
