public static string ActualizarUsuarioTtccol307(string PICK, string ORNO, string PONO, string ADVS)
{
string strError = string.Empty;
Ent_tticol182 MyObj182 = new Ent_tticol182();
MyObj182.STAT = "1";
MyObj182.ORNO = ORNO;
MyObj182.PONO = PONO;
MyObj182.ADVS = ADVS;
MyObj182.PICK = PICK;
bool ActualizacionExitosa = _idaltticol182.ActualizarStatTticol182(ref MyObj182, ref strError);
if (ActualizacionExitosa)
{
ObjReturn.Error = false;
ObjReturn.SuccessMsg = Updtatesuccessfull;
ObjReturn.TypeMsgJs = "lbl";
}
else if (!ActualizacionExitosa)
{
ObjReturn.Error = true;
ObjReturn.ErrorMsg = Updtatenotsuccessfull;
ObjReturn.TypeMsgJs = "lbl";
}
return(JsonConvert.SerializeObject(ObjReturn));
}
public static string ConsultarTtccol307(string PAID)
{
Ent_tticol182 MyObj182 = new Ent_tticol182();
MyObj182.STAT = "5";
string strError = string.Empty;
DataTable DTtticol182 = _idaltticol182.SelectTticol182(ref MyObj182, ref strError);
if (DTtticol182.Rows.Count > 0)
{
DataRow ItemRow = DTtticol182.Rows[0];
ObjReturn.PAID = ItemRow["PICK"].ToString();
ObjReturn.STAT = ItemRow["STAA"].ToString();
ObjReturn.STAT = ItemRow["STATUS"].ToString();
ObjReturn.Error = false;
}
else
{
ObjReturn.Error = true;
ObjReturn.ErrorMsg = ThepalletIDdoestexist;
ObjReturn.TypeMsgJs = "lbl";
}
return(JsonConvert.SerializeObject(DTtticol182));
}
public DataTable SelectRecord(ref Ent_tticol182 data, ref string strError)
{
method = MethodBase.GetCurrentMethod();
DataTable retorno = new DataTable();
try
{
paramList = new Dictionary <string, object>();
paramList.Add(":T$CWAR", data.CWAR.Trim());
strSentencia = recursos.readStatement(method.ReflectedType.Name, method.Name, ref owner, ref env, tabla, paramList);
retorno = DAL.BaseDAL.BaseDal.EjecutarCons("Text", strSentencia, ref parametersOut, null, true);
return(retorno);
}
catch (Exception ex)
{
strError = ex.InnerException != null ?
ex.Message + " (" + ex.InnerException + ")" :
ex.Message;
}
return(retorno);
}
public bool ActualizarStatTticol182(ref Ent_tticol182 data, ref string strError)
{
method = MethodBase.GetCurrentMethod();
bool retorno = false;
try
{
paramList = new Dictionary <string, object>();
paramList.Add(":T$ORNO", data.ORNO);
paramList.Add(":T$PONO", data.PONO);
paramList.Add(":T$ADVS", data.ADVS);
paramList.Add(":T$PICK", data.PICK);
paramList.Add(":T$STAT", data.STAT);
strSentencia = recursos.readStatement(method.ReflectedType.Name, method.Name, ref owner, ref env, tabla, paramList);
return(DAL.BaseDAL.BaseDal.EjecutarCrud("Text", strSentencia, ref parametersOut, null, false));
}
catch (Exception ex)
{
strError = ex.InnerException != null ?
ex.Message + " (" + ex.InnerException + ")" :
ex.Message;
}
return(retorno);
}
public bool ActualizarStatTticol182(ref Ent_tticol182 data, ref string strError)
{
bool retorno = false;
try
{
retorno = dal.ActualizarStatTticol182(ref data, ref strError);
return(retorno);
}
catch (Exception ex)
{
throw new Exception(strError += "\nPila: " + ex.Message);
}
}
public DataTable SelectTticol182(ref Ent_tticol182 data, ref string strError)
{
DataTable retorno = new DataTable();
try
{
retorno = dal.SelectTticol182(ref data, ref strError);
return(retorno);
}
catch (Exception ex)
{
throw new Exception(strError += "\nPila: " + ex.Message);
}
}
public bool ActualizarRegistroItticol182(Ent_tticol182 myObj)
{
return(dal.ActualizarRegistroItticol182(myObj));
}
public bool InsertarregistroItticol182(Ent_tticol182 myObj)
{
return(dal.InsertarregistroItticol182(myObj));
}