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