C# SQLHandler.ExecuteNonQueryAsBool方法代码示例

        private bool IsPageExists(string pagename)
        {
            SQLHandler sqlH = new SQLHandler();
            var paramCol = new List<KeyValuePair<string, object>>();
            paramCol.Add(new KeyValuePair<string, object>("@PortalID", -1));
            paramCol.Add(new KeyValuePair<string, object>("@PageName", pagename));
            // paramCol.Add(new KeyValuePair<string, object>("@PageName", pagename));
            return sqlH.ExecuteNonQueryAsBool("[dbo].[usp_Aspx_CheckPaymentPage]", paramCol, "@IsExist");

        }

 public static bool CheckTaxClassUniqueness(AspxCommonInfo aspxCommonObj, string taxItemClassName)
 {
     try
     {
         List<KeyValuePair<string, object>> parameter = CommonParmBuilder.GetParamSPC(aspxCommonObj);
         parameter.Add(new KeyValuePair<string, object>("@TaxClassName", taxItemClassName));
         SQLHandler sqlh = new SQLHandler();
         bool isUnique = sqlh.ExecuteNonQueryAsBool("[usp_Aspx_CheckTaxClassUniqueness]", parameter, "@IsUnique");
         return isUnique;
     }
     catch (Exception e)
     {
         throw e;
     }
 }

 public static bool CheckCouponStatusUniqueness(AspxCommonInfo aspxCommonObj, int couponStatusId, string couponStatusName)
 {
     try
     {
         SQLHandler sqlH = new SQLHandler();
         List<KeyValuePair<string, object>> Parameter = CommonParmBuilder.GetParamSPC(aspxCommonObj);
         Parameter.Add(new KeyValuePair<string, object>("@CouponStatusId", couponStatusId));
         Parameter.Add(new KeyValuePair<string, object>("@CouponStatusName", couponStatusName));
         bool isUnique = sqlH.ExecuteNonQueryAsBool("[dbo].[usp_Aspx_CheckCouponStatusUniquness]", Parameter, "@IsUnique");
         return isUnique;
     }
     catch (Exception e)
     {
         throw e;
     }
 }

 public static bool CheckUniqueName(string catName, int catId, AspxCommonInfo aspxCommonObj)
 {
     try
     {
         SQLHandler sqlH = new SQLHandler();
         List<KeyValuePair<string, object>> parameterCollection = CommonParmBuilder.GetParamSPC(aspxCommonObj);
         parameterCollection.Add(new KeyValuePair<string, object>("@CategoryName", catName));
         parameterCollection.Add(new KeyValuePair<string, object>("@CategoryID", catId));
         bool isUnique = sqlH.ExecuteNonQueryAsBool("dbo.usp_Aspx_CategoryNameUniquenessCheck", parameterCollection, "@IsUnique");
         return isUnique;
     }
     catch (Exception e)
     {
         throw e;
     }
 }

 public bool CheckUniqueName(string catName, int catId, int storeId, int portalId, string cultureName)
 {
     try
     {
         SQLHandler sqlH = new SQLHandler();
         List<KeyValuePair<string, object>> parameterCollection = new List<KeyValuePair<string, object>>();
         parameterCollection.Add(new KeyValuePair<string, object>("@CategoryName", catName));
         parameterCollection.Add(new KeyValuePair<string, object>("@CategoryID", catId));
         parameterCollection.Add(new KeyValuePair<string, object>("@StoreID", storeId));
         parameterCollection.Add(new KeyValuePair<string, object>("@PortalID", portalId));
         parameterCollection.Add(new KeyValuePair<string, object>("@CultureName", cultureName));
         return sqlH.ExecuteNonQueryAsBool("dbo.usp_Aspx_CategoryNameUniquenessCheck", parameterCollection, "@IsUnique");
     }
     catch (Exception ex)
     {
         throw ex;
     }
 }

 public static bool IsShippingLabelCreated(int orderId, AspxCommonInfo commonInfo)
 {
     List<KeyValuePair<string, object>> paraMeter = new List<KeyValuePair<string, object>>();
     paraMeter.Add(new KeyValuePair<string, object>("@OrderID", orderId));
     paraMeter.Add(new KeyValuePair<string, object>("@PortalId", commonInfo.StoreID));
     paraMeter.Add(new KeyValuePair<string, object>("@StoreId", commonInfo.StoreID));
     SQLHandler sqLh = new SQLHandler();
     bool isCreated = sqLh.ExecuteNonQueryAsBool("[dbo].[usp_Aspx_CheckLabelExist]", paraMeter, "@IsCreated");
     return isCreated;
 }

 public static bool CheckRemainingDownload(int itemId, int orderItemId, AspxCommonInfo aspxCommonObj)
 {
     try
     {
         SQLHandler sqlH = new SQLHandler();
         List<KeyValuePair<string, object>> parameterCollection = CommonParmBuilder.GetParamSPU(aspxCommonObj);
         parameterCollection.Add(new KeyValuePair<string, object>("@ItemID", itemId));
         parameterCollection.Add(new KeyValuePair<string, object>("@OrderItemID", orderItemId));
         bool isRemain = sqlH.ExecuteNonQueryAsBool("dbo.usp_Aspx_CheckRemainingDownloadForCustomer", parameterCollection, "@IsRemainDowload");
         return isRemain;
     }
     catch (Exception e)
     {
         throw e;
     }
 }

 public static bool CheckBrandUniqueness(string brandName, AspxCommonInfo aspxCommonObj)
 {
     try
     {
         List<KeyValuePair<string, object>> parameter = CommonParmBuilder.GetParamSPC(aspxCommonObj);
         parameter.Add(new KeyValuePair<string, object>("@BrandName", brandName));
         SQLHandler sqlH = new SQLHandler();
         bool isUnique= sqlH.ExecuteNonQueryAsBool("usp_Aspx_CheckBrandUniqueness", parameter, "@isUnique");
         return isUnique;
     }
     catch (Exception e)
     {
         throw e;
     }
 }

 public bool CheckCatalogRuleExist(int iPortalID, int iStoreID)
 {
     try
     {
         bool isExist = false;
         SQLHandler sqlHandler = new SQLHandler();
         List<KeyValuePair<string, object>> paramList = new List<KeyValuePair<string, object>>();
         paramList.Add(new KeyValuePair<string, object>("@PortalID", iPortalID));
         paramList.Add(new KeyValuePair<string, object>("@StoreID", iPortalID));
         isExist = sqlHandler.ExecuteNonQueryAsBool("[dbo].[usp_Aspx_CheckCatalogRuleExist]", paramList, "@IsExist");
         return isExist;
     }
     catch (Exception e)
     {
         throw e;
     }
 }

 public bool CheckUniqueSKUCode(string sku, int itemId, AspxCommonInfo aspxCommonObj)
 {
     try
     {
         SQLHandler sqlH = new SQLHandler();
         List<KeyValuePair<string, object>> parameterCollection = new List<KeyValuePair<string, object>>();
         parameterCollection.Add(new KeyValuePair<string, object>("@SKU", sku));
         parameterCollection.Add(new KeyValuePair<string, object>("@ItemID", itemId));
         parameterCollection.Add(new KeyValuePair<string, object>("@StoreID",aspxCommonObj.StoreID));
         parameterCollection.Add(new KeyValuePair<string, object>("@PortalID",aspxCommonObj.PortalID));
         parameterCollection.Add(new KeyValuePair<string, object>("@CultureName",aspxCommonObj.CultureName));
         return sqlH.ExecuteNonQueryAsBool("dbo.usp_Aspx_ItemSKUCodeUniquenessCheck", parameterCollection, "@IsUnique");
     }
     catch (Exception ex)
     {
         throw ex;
     }
 }

 public static bool CheckExisting(AspxCommonInfo aspxCommonObj, int storeAccesskeyId, string accessData)
 {
     try
     {
         SQLHandler sqlH = new SQLHandler();
         List<KeyValuePair<string, object>> parameter = CommonParmBuilder.GetParamSP(aspxCommonObj);
         parameter.Add(new KeyValuePair<string, object>("@StoreAccessKeyID", storeAccesskeyId));
         parameter.Add(new KeyValuePair<string, object>("@StoreAccessData", accessData));
         bool isUnique= sqlH.ExecuteNonQueryAsBool("[dbo].[usp_Aspx_CheckExistingStoreAccess]", parameter, "@IsUnique");
         return isUnique;
     }
     catch (Exception e)
     {
         throw e;
     }
 }

        public bool CheckEmailAddress(string email,int storeID, int portalID)
        {
            try
            {
                SQLHandler sqlH = new SQLHandler();
                List<KeyValuePair<string, object>> parameter = new List<KeyValuePair<string, object>>();
                parameter.Add(new KeyValuePair<string, object>("@PortalID", portalID));
                parameter.Add(new KeyValuePair<string, object>("@StoreID", storeID));
                parameter.Add(new KeyValuePair<string, object>("@Email", email));
                //parameter.Add(new KeyValuePair<string, object>("@IsExist", 0));
                return sqlH.ExecuteNonQueryAsBool("usp_Aspx_CheckEmailIsAdmin", parameter, "@IsExist");
            }
            catch (Exception ex)
            {

                throw ex;
            }
        }

 public bool CheckDownloadableItemOnly(int storeID, int portalID, int customerID, string sessionCode)
 {
     try
     {
         List<KeyValuePair<string, object>> parameter = new List<KeyValuePair<string, object>>();
         parameter.Add(new KeyValuePair<string, object>("@CustomerID", customerID));
         parameter.Add(new KeyValuePair<string, object>("@StoreID", storeID));
         parameter.Add(new KeyValuePair<string, object>("@PortalID", portalID));
         parameter.Add(new KeyValuePair<string, object>("@SessionCode", sessionCode));
         SQLHandler sqlH = new SQLHandler();
         return sqlH.ExecuteNonQueryAsBool("[dbo].[usp_Aspx_CheckForDownloadableItemsInCart]", parameter, "@IsAllDownloadable");
     }
     catch (Exception ex)
     {
         throw ex;
     }
 }

 public bool CheckCatalogPriorityUniqueness(int CatalogPriceRuleID, int Priority, int StoreID, int PortalID)
 {
     try
     {
         SQLHandler Sq = new SQLHandler();
         List<KeyValuePair<string, object>> ParaMeterCollection = new List<KeyValuePair<string, object>>();
         ParaMeterCollection.Add(new KeyValuePair<string, object>("@CatalogPriceRuleID", CatalogPriceRuleID));
         ParaMeterCollection.Add(new KeyValuePair<string, object>("@Priority", Priority));
         ParaMeterCollection.Add(new KeyValuePair<string, object>("@StoreID", StoreID));
         ParaMeterCollection.Add(new KeyValuePair<string, object>("@PortalID", PortalID));
         return Sq.ExecuteNonQueryAsBool("[usp_ASPX_CatalogPriorityUniquenessCheck]", ParaMeterCollection, "@IsUnique");
     }
     catch (Exception ex)
     {
         throw ex;
     }
 }

 public bool CheckUniqueSKUCode(string SKU, int itemId, int storeId, int portalId, string cultureName)
 {
     try
     {
         SQLHandler Sq = new SQLHandler();
         List<KeyValuePair<string, object>> ParaMeterCollection = new List<KeyValuePair<string, object>>();
         ParaMeterCollection.Add(new KeyValuePair<string, object>("@SKU", SKU));
         ParaMeterCollection.Add(new KeyValuePair<string, object>("@ItemID", itemId));
         ParaMeterCollection.Add(new KeyValuePair<string, object>("@StoreID", storeId));
         ParaMeterCollection.Add(new KeyValuePair<string, object>("@PortalID", portalId));
         ParaMeterCollection.Add(new KeyValuePair<string, object>("@CultureName", cultureName));
         return Sq.ExecuteNonQueryAsBool("dbo.usp_ASPX_ItemSKUCodeUniquenessCheck", ParaMeterCollection, "@IsUnique");
     }
     catch (Exception ex)
     {
         throw ex;
     }
 }