private List <Ent_ParametrosDAL> AdicionaParametrosComunes(Ent_tticol132 parametros, bool blnUsarPRetorno = false)
{
method = MethodBase.GetCurrentMethod();
string strError = string.Empty;
List <Ent_ParametrosDAL> parameterCollection = new List <Ent_ParametrosDAL>();
try
{
Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, "T$BCDE", DbType.String, parametros.barcode);
//Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, "T$DATE", DbType.DateTime, parametros.date.ToString("dd/MM/yyyy HH:mm:ss"));
Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, "T$TYPE", DbType.Int64, parametros.type);
Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, "T$ITEM", DbType.String, parametros.item);
Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, "T$USER", DbType.String, parametros.user);
Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, "T$STAT", DbType.Int64, parametros.status);
Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, "T$MCNO", DbType.String, parametros.machine);
Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, "T$REFCNTD", DbType.Int64, parametros.refcntd);
Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, "T$REFCNTU", DbType.Int64, parametros.refcntu);
if (blnUsarPRetorno)
{
Ent_ParametrosDAL pDal = new Ent_ParametrosDAL();
pDal.Name = "@p_Int_Resultado";
pDal.Type = DbType.Int32;
pDal.ParDirection = ParameterDirection.Output;
parameterCollection.Add(pDal);
}
}
catch (Exception ex)
{
strError = "Error when creating parameters [135]. 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(parameterCollection);
}
public static string ValidarIdentifier(string sIdentifier)
{
string retorno = "0";
DataTable DTRetorno = null;
string strError = string.Empty;
InterfazDAL_tticol132 tticol132 = new InterfazDAL_tticol132();
Ent_tticol132 ent_tticol132 = new Ent_tticol132();
if (string.IsNullOrEmpty(sIdentifier))
{
retorno = "0";
}
else
{
Ent_tticol132 param = new Ent_tticol132()
{
barcode = sIdentifier
};
try
{
DTRetorno = tticol132.ObtenerBox(ref param, ref strError);
if (DTRetorno.Rows.Count > 0)
{
retorno = string.Empty;
}
}
catch (Exception ex)
{
retorno = ex.InnerException != null ?
ex.Message + " (" + ex.InnerException + ")" :
ex.Message;
}
}
return(retorno);
}
protected void btnContinue_Click(object sender, EventArgs e)
{
InterfazDAL_tticol132 tticol132 = new InterfazDAL_tticol132();
Ent_tticol132 ent_tticol132 = new Ent_tticol132();
string strError = string.Empty;
int retorno;
List <Ent_tticol132> param = new List <Ent_tticol132>();
DataTable DTBox;
try
{
if (String.IsNullOrEmpty(txtIdentifier.Text))
{
strError = "Box Identifier doesn't exist";
return;
}
ent_tticol132.barcode = txtIdentifier.Text;
DTBox = tticol132.ObtenerBox(ref ent_tticol132, ref strError);
if (DTBox.Rows.Count > 0)
{
ent_tticol132.item = string.Format(" {0}", DTBox.Rows[0]["t$item"].ToString().Trim());
ent_tticol132.type = int.Parse(DTBox.Rows[0]["t$type"].ToString());
ent_tticol132.user = Session["user"].ToString();
//Modificado por petición de DMontoya
//Al digitar un registro de uso el registro que se está guardando en la tabla el registro con:
//status “Nuevo” y este campo debe quedar con valor “En Uso” (2) Pendiente
//ent_tticol132.status = int.Parse(DTBox.Rows[0]["t$stat"].ToString());
ent_tticol132.status = 2;
ent_tticol132.machine = txtMachine.Text.Trim().ToUpperInvariant();
ent_tticol132.refcntd = 0;
ent_tticol132.refcntu = 0;
param.Add(ent_tticol132);
}
retorno = tticol132.insertarRegistro(ref param, ref strError);
if (retorno == 0 && !string.IsNullOrEmpty(strError))
{
strError = "Save unsuccessfully (" + strError + ")";
}
else
{
strError = "Save successfully";
txtIdentifier.Text = "";
//txtMachine.Text = "";
}
}
catch (Exception ex)
{
strError = ex.InnerException != null ?
ex.Message + " (" + ex.InnerException + ")" :
ex.Message;
}
lblMensaje.Text = strError;
}
public DataTable ObtenerBox(ref Ent_tticol132 parametros, ref string strError)
{
//int retorno = -1;
DataTable retorno;
try
{
retorno = dal.ObtenerBox(ref parametros, ref strError);
return(retorno);
}
catch (Exception ex)
{
throw new Exception(ex.InnerException.ToString());
}
}
public DataTable ObtenerBox(ref Ent_tticol132 ParametrosIn, ref string strError)
{
method = MethodBase.GetCurrentMethod();
paramList = new Dictionary <string, object>();
paramList.Add("p1", ParametrosIn.barcode.Trim().ToUpperInvariant());
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 = "Not found records for confirm";
}
}
catch (Exception ex)
{
strError = "Error when querying data [tticol132]. Try again or contact your administrator";
log.escribirError(strError + Console.Out.NewLine + ex.Message, stackTrace.GetFrame(1).GetMethod().Name, method.Name, method.ReflectedType.Name);
}
return(consulta);
}
