public DataTable findRecordByOrderNumber(ref Ent_twhinh225 data, ref string strError)
{
method = MethodBase.GetCurrentMethod();
paramList = new Dictionary <string, object>();
paramList.Add(":T$ORNO", data.orno.Trim());
paramList.Add(":T$OSET", data.oset.Trim());
paramList.Add(":T$PONO", data.pono.Trim());
paramList.Add(":T$SERN", data.sern.Trim());
paramList.Add(":T$SEQN", data.seqn.Trim());
strSentencia = recursos.readStatement(method.ReflectedType.Name, method.Name, ref owner, ref env, tabla, paramList);
try
{
consulta = DAL.BaseDAL.BaseDal.EjecutarCons("Text", strSentencia, ref parametersOut, null, true);
if (consulta.Rows.Count < 1)
{
strError = "Incorrect location, please verify.";
}
}
catch (Exception ex)
{
strError = "Error to the search sequence [twhinh225]. Try again or contact your administrator \n ";
log.escribirError(strError + Console.Out.NewLine + ex.Message, stackTrace.GetFrame(1).GetMethod().Name, method.Name, method.ReflectedType.Name);
}
return(consulta);
}
public DataTable findRecordByOrderNumber(ref Ent_twhinh225 data, ref string strError)
{
DataTable retorno = new DataTable();
try
{
retorno = dal.findRecordByOrderNumber(ref data, ref strError);
return(retorno);
}
catch (Exception ex)
{
throw new Exception(strError += "\nPila: " + ex.Message);
}
}
protected void btnConsultar_Click(object sender, EventArgs e)
{
lblConfirm.Text = String.Empty;
lblError.Text = String.Empty;
if (txtNumero.Text != "")
{
var numeroSugerencia = txtNumero.Text.ToUpper();
var cwar = numeroSugerencia.Substring(0, 5);
var orno = numeroSugerencia.Substring(0, 9);
var oset = numeroSugerencia.Substring(9, 2);
var pono = numeroSugerencia.Substring(11, 3);
var seqn = numeroSugerencia.Substring(14, 2);
var sern = numeroSugerencia.Substring(16, 2);
Ent_twhinh225 data = new Ent_twhinh225()
{
orno = orno,
oset = oset,
pono = pono,
sern = sern,
seqn = seqn
};
_validateRecord = _idaltwhinh225.findRecordByOrderNumber(ref data, ref strError);
if (_validateRecord.Rows.Count > 0)
{
if (_validateRecord.Rows[0]["SLOC"].ToString() == "2")
{
lblError.Text = mensajes("almnolocation");
return;
}
divTable.Visible = true;
lblValueOrden.Text = String.Concat(_validateRecord.Rows[0]["ORNO"].ToString()
, _validateRecord.Rows[0]["OSET"].ToString()
, _validateRecord.Rows[0]["PONO"].ToString()
, _validateRecord.Rows[0]["SEQN"].ToString());
lblValueArticulo.Text = String.Concat(_validateRecord.Rows[0]["DSCA"].ToString(), " ", _validateRecord.Rows[0]["ITEM"].ToString());
lblValueCantSugerida.Text = _validateRecord.Rows[0]["ASTR"].ToString();
lblValueUnidad.Text = _validateRecord.Rows[0]["ATUN"].ToString();
lblValueAlmacen.Text = _validateRecord.Rows[0]["CWAR"].ToString();
lblValueUbicacion.Text = _validateRecord.Rows[0]["LOCA"].ToString();
lblValueLote.Text = _validateRecord.Rows[0]["CLOT"].ToString();
lblValueUnidadTwo.Text = _validateRecord.Rows[0]["ATUN"].ToString();
lblValueAlmacenTwo.Text = _validateRecord.Rows[0]["CWAR"].ToString();
hdfCantidadPedida.Value = _validateRecord.Rows[0]["ASTK"].ToString();;
hdfCantidadSugerida.Value = _validateRecord.Rows[0]["ASTR"].ToString();;
hdfUbicacion.Value = _validateRecord.Rows[0]["LOCA"].ToString();;
hdfLote.Value = _validateRecord.Rows[0]["CLOT"].ToString();;
}
else
{
lblError.Text = mensajes("notorder");
return;
}
}
else
{
lblError.Text = mensajes("blanknumber");
return;
}
}
