private void cbProcedimiento_RowSelected(object sender, Infragistics.Win.UltraWinGrid.RowSelectedEventArgs e)
{
#region Conexion SAM
ConexionSigesoft conectasam = new ConexionSigesoft();
conectasam.opensigesoft();
#endregion
string proced = cbProcedimiento.Text;
var cadena1 = "select i_ParameterId from systemparameter where v_Value1='" + proced + "'";
SqlCommand comando = new SqlCommand(cadena1, connection: conectasam.conectarsigesoft);
SqlDataReader lector = comando.ExecuteReader();
while (lector.Read())
{
txtProcedId.Text = lector.GetValue(0).ToString();
}
lector.Close();
conectasam.closesigesoft();
}
private void txtcInvCode_RowSelected(object sender, Infragistics.Win.UltraWinGrid.RowSelectedEventArgs e)
{
var uRow = e.Row;
if (uRow == null || uRow.Index <= -1)
{
return;
}
if (!long.TryParse(uRow.Cells["AutoID"].Value.ToString(), out bomID))
{
return;
}
_FitemId = uRow.Cells["cFitemID"].Value.ToString(); dataInventory.BomDetail.Rows.Clear();
bomDetailTableAdapter.Fill(dataInventory.BomDetail, bomID);
txtcInvStd.Text = uRow.Cells["cInvStd"].Value.ToString();
utecInvName.Text = uRow.Cells["cInvName"].Value.ToString();
txtcFullName.Text = uRow.Cells["cFullName"].Value.ToString();
}
private void cbLine_RowSelected(object sender, Infragistics.Win.UltraWinGrid.RowSelectedEventArgs e)
{
#region Conexion SAM obtener id de linea
ConexionSambhs conectasam = new ConexionSambhs();
conectasam.openSambhs();
var cadena = "select v_IdLinea from [dbo].[linea] where v_Nombre='" + cbLine.Text + "' and i_Eliminado=0";
SqlCommand comandou = new SqlCommand(cadena, connection: conectasam.conectarSambhs);
SqlDataReader lectoru = comandou.ExecuteReader();
lineId = "";
while (lectoru.Read())
{
lineId = lectoru.GetValue(0).ToString();
}
lectoru.Close();
conectasam.closeSambhs();
#endregion
txtUnidProdId.Text = lineId;
}
private void cbDx_RowSelected(object sender, Infragistics.Win.UltraWinGrid.RowSelectedEventArgs e)
{
//MessageBox.Show("hola MUNDO", "Validacion", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
#region Conexion SAM
ConexionSigesoft conectasam = new ConexionSigesoft();
conectasam.opensigesoft();
#endregion
string dx = cbDx.Text;
var cadena1 = "select v_CIE10Description2 from cie10 where v_CIE10Description1='" + dx + "'";
SqlCommand comando = new SqlCommand(cadena1, connection: conectasam.conectarsigesoft);
SqlDataReader lector = comando.ExecuteReader();
while (lector.Read())
{
txtCie10.Text = lector.GetValue(0).ToString();
}
lector.Close();
conectasam.closesigesoft();
}
private void cbLine_RowSelected(object sender, Infragistics.Win.UltraWinGrid.RowSelectedEventArgs e)
{
#region Conexion SAMBHS
ConexionSambhs conectaConexionSambhs = new ConexionSambhs(); conectaConexionSambhs.openSambhs();
var cadenasam = "select v_IdLinea from linea where i_Eliminado=0 and v_Nombre ='" + cbLine.Text + "'";
var comando = new SqlCommand(cadenasam, connection: conectaConexionSambhs.conectarSambhs);
var lector = comando.ExecuteReader();
string LineId = "";
List <ListaLineas> objListaLineas = new List <ListaLineas>();
while (lector.Read())
{
LineId = lector.GetValue(0).ToString();
}
lector.Close();
conectaConexionSambhs.closeSambhs();
#endregion
txtUnidadProdId.Text = LineId;
}