Beispiel #1
0
        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));
        }
Beispiel #2
0
        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));
        }
Beispiel #3
0
        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);
        }
Beispiel #4
0
        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));
 }