Exemplo n.º 1
0
 public static string[] AC_GetVendorPN(string term)
 {
     try
     {
         clsUtil  u = new clsUtil();
         string[] x = u.GetJSONFromDB(DBK.SP.spAC_OTSVENDORPN, "%" + term + "%", DBK.strVENDORPARTNUMBER);
         return(x);
     }
     catch (Exception ex)
     {
         string strErr = ex.Message + ex.StackTrace;
         return(new string[0]);
     }
 }
Exemplo n.º 2
0
 public static string[] AC_GetProduct(string term)
 {
     try
     {
         clsUtil  u = new clsUtil();
         string[] x = u.GetJSONFromDB(DBK.SP.spAC_OTSPRODUCT, "%" + term + "%", DBK.strPRODUCT);
         return(x);
     }
     catch (Exception ex)
     {
         string strErr = ex.Message + ex.StackTrace;
         return(new string[0]);
     }
 }
Exemplo n.º 3
0
        public static string[] GetAssyNames(string term)
        {
            try
            {
                clsUtil             u  = new clsUtil();
                List <SqlParameter> ps = new List <SqlParameter>();

                string[] x = u.GetJSONFromDB(DBK.SP.spAC_ASYNAMES, "%" + term + "%", DBK.strNAME);
                return(x);
            } catch (Exception ex)
            {
                string strErr = ex.Message + ex.StackTrace;
                return(new string[0]);
            }
        }
Exemplo n.º 4
0
        public static string[] GetStateProvince(string term)
        {
            try
            {
                clsUtil             u  = new clsUtil();
                List <SqlParameter> ps = new List <SqlParameter>();

                string[] x = u.GetJSONFromDB(DBK.SP.spAC_LOCSTATEPROVINCE, "%" + term + "%", DBK.strSTATEPROVINCE);
                return(x);
            }
            catch (Exception ex)
            {
                string strErr = ex.Message + ex.StackTrace;
                return(new string[0]);
            }
        }
Exemplo n.º 5
0
        public static string[] GetStreetAddress(string term)
        {
            try
            {
                clsUtil             u  = new clsUtil();
                List <SqlParameter> ps = new List <SqlParameter>();

                string[] x = u.GetJSONFromDB(DBK.SP.spAC_LOCADDRESS, "%" + term + "%", DBK.strADDRESS);
                return(x);
            }
            catch (Exception ex)
            {
                string strErr = ex.Message + ex.StackTrace;
                return(new string[0]);
            }
        }
Exemplo n.º 6
0
        public static string[] GetCountry(string term)
        {
            try
            {
                clsUtil             u  = new clsUtil();
                List <SqlParameter> ps = new List <SqlParameter>();

                string[] x = u.GetJSONFromDB(DBK.SP.spAC_LOCCOUNTRY, "%" + term + "%", DBK.strCOUNTRY);
                return(x);
            }
            catch (Exception ex)
            {
                string strErr = ex.Message + ex.StackTrace;
                return(new string[0]);
            }
        }
Exemplo n.º 7
0
        public static string[] GetPostalCode(string term)
        {
            try
            {
                clsUtil             u  = new clsUtil();
                List <SqlParameter> ps = new List <SqlParameter>();

                string[] x = u.GetJSONFromDB(DBK.SP.spAC_LOCPOSTALCODE, "%" + term + "%", DBK.strPOSTALCODE);
                return(x);
            }
            catch (Exception ex)
            {
                string strErr = ex.Message + ex.StackTrace;
                return(new string[0]);
            }
        }
Exemplo n.º 8
0
        public static string[] GetSubInventory(string term)
        {
            try
            {
                clsUtil             u  = new clsUtil();
                List <SqlParameter> ps = new List <SqlParameter>();

                string[] x = u.GetJSONFromDB(DBK.SP.spAC_INVSUBINVENTORY, "%" + term + "%", DBK.strSUBINV);
                return(x);
            }
            catch (Exception ex)
            {
                string strErr = ex.Message + ex.StackTrace;
                return(new string[0]);
            }
        }
Exemplo n.º 9
0
 public static string[] GetAssyBOMRevs(string term)
 {
     try
     {
         string[]            strSpl   = { AAAK.DELIM };
         string[]            arrTerms = term.Split(strSpl, StringSplitOptions.None);
         List <SqlParameter> sqlPs    = new List <SqlParameter>();
         sqlPs.Add(new SqlParameter("@strName", arrTerms[0]));
         sqlPs.Add(new SqlParameter("@strRevision", arrTerms[1]));
         clsUtil  u = new clsUtil();
         string[] x = u.GetJSONFromDB(DBK.SP.spAC_ASYBOMREVSFORGIVENASYNAMEANDREV, "", DBK.intBOMREV, ps: sqlPs);
         return(x);
     }
     catch (Exception ex)
     {
         string strErr = ex.Message + ex.StackTrace;
         return(new string[0]);
     }
 }