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