C# SQLHandler.ExecuteAsList方法代码示例

        private void BindGridOnPageLoad()
        {
            try
            {

                bool Issystem = true;

                List<KeyValuePair<string, object>> ParaMeterCollection = new List<KeyValuePair<string, object>>();
                ParaMeterCollection.Add(new KeyValuePair<string, object>("@PortalID", -1));
                ParaMeterCollection.Add(new KeyValuePair<string, object>("@Culture", GetCurrentCultureName));

                SQLHandler sqlH = new SQLHandler();
                List<sp_GetDefaultListResult> defaultList = sqlH.ExecuteAsList<sp_GetDefaultListResult>("dbo.sp_GetDefaultList", ParaMeterCollection);
                
                //var defaultList = dbList.sp_GetDefaultList(-1,GetCurrentCultureName);
                //{
                foreach (sp_GetDefaultListResult topList in defaultList)
                {
                    BindGrid(topList.ListName, topList.ParentKey);//culture
                    //var listSystemCheck = dbList.sp_GetListsByPortalID(-1, GetCurrentCultureName);

                    List<sp_GetListsByPortalIDResult> listSystemCheck = sqlH.ExecuteAsList<sp_GetListsByPortalIDResult>("dbo.sp_GetListsByPortalID", ParaMeterCollection);

                    foreach (sp_GetListsByPortalIDResult system in listSystemCheck)
                    {
                        if (system.ListName == topList.ListName)
                            Issystem = system.SystemList;
                    }
                    lblListName.Text = topList.ListName;
                    lblDeleteList.Text = "Delete "+topList.ListName+" List";
                    ViewState["PARENTKEY"] = topList.ParentKey;
                    ViewState["LISTNAME"] = topList.ListName;
                }


                if (Issystem == true)
                {
                    gdvSubList.Columns[4].Visible = false;

                }
                else
                {
                    gdvSubList.Columns[4].Visible = true;
                }
                lblParent.Visible = false;
                if (ViewState["LIST"] != null)
                {
                    lblEntry.Text = ViewState["LIST"].ToString() + " " + GetSageMessage("ListSettings", "Entries");
                }
                ViewMode();
                pnlListAll.Visible = true;
                //}
            }
            catch (Exception ex)
            {
                ProcessException(ex);
            }
        }

 /// <summary>
 /// To Bind Attribute Type dropdown
 /// </summary>
 /// <returns></returns>
 public List<AttributesInputTypeInfo> GetAttributesInputType()
 {
     List<AttributesInputTypeInfo> ml = new List<AttributesInputTypeInfo>();
     SQLHandler Sq = new SQLHandler();
     ml = Sq.ExecuteAsList<AttributesInputTypeInfo>("dbo.usp_ASPX_AttributesInputTypeGetAll");
     return ml;
 }

 public static List<PricingRuleAttributeInfo> GetPricingRuleAttributes(AspxCommonInfo aspxCommonObj)
 {
     SQLHandler sqlHandler = new SQLHandler();
     List<KeyValuePair<string, object>> paramList = CommonParmBuilder.GetParamSPUC(aspxCommonObj);
     List<PricingRuleAttributeInfo> lstPriceRuleAttr = sqlHandler.ExecuteAsList<PricingRuleAttributeInfo>("usp_Aspx_GetPricingRuleAttr", paramList);
     return lstPriceRuleAttr;
 }

 public List<ContactUsInfo> ContactUsGetAll(int portalID)
 {
     List<KeyValuePair<string, object>> ParaMeterCollection = new List<KeyValuePair<string, object>>();
     ParaMeterCollection.Add(new KeyValuePair<string, object>("@PortalID", portalID));
     SQLHandler sqlH = new SQLHandler();
     return sqlH.ExecuteAsList<ContactUsInfo>("sp_ContactUsGetAll", ParaMeterCollection);
 }

 /// <summary>
 /// To Bind Attribute Type dropdown
 /// </summary>
 /// <returns></returns>
 public List<AttributesInputTypeInfo> GetAttributesInputType()
 {
     List<AttributesInputTypeInfo> ml;
     SQLHandler sqlH = new SQLHandler();
     ml = sqlH.ExecuteAsList<AttributesInputTypeInfo>("dbo.usp_Aspx_AttributesInputTypeGetAll");
     return ml;
 }

 public List<States> GetStatesByCountry(string countryCode)
 {
     var sqlHandler = new SQLHandler();
     var paramList = new List<KeyValuePair<string, object>> { new KeyValuePair<string, object>("@CountryCode", countryCode) };
     List<States> cl = sqlHandler.ExecuteAsList<States>("usp_Aspx_GetStateList", paramList);
    return cl;
 }

 public static List<LayoutMgrInfo> GetAdminModules(int PortalID)
 {
     SQLHandler SQLH = new SQLHandler();
     List<KeyValuePair<string, object>> ParaMeterCollection = new List<KeyValuePair<string, object>>();
     ParaMeterCollection.Add(new KeyValuePair<string, object>("@PortalID", PortalID));
     return SQLH.ExecuteAsList<LayoutMgrInfo>("[dbo].[usp_ModuleManagerGetAdminModules]",ParaMeterCollection);
 }

        /// <summary>
        /// Connects to database and gets breadcrumb.
        /// </summary>
        /// <param name="SEOName">SEOName</param>
        /// <param name="PortalID">PortalID</param>
        /// <param name="MenuId">MenuId</param>
        /// <param name="CultureCode">CultureCode</param>
        /// <returns>Returns BreadCrumInfo list </returns>
        public List<BreadCrumInfo> GetBreadCrumb(string SEOName, int PortalID, int MenuId, string CultureCode)
        {
            try
            {

                List<KeyValuePair<string, object>> ParaMeterCollection = new List<KeyValuePair<string, object>>();
                ParaMeterCollection.Add(new KeyValuePair<string, object>("@SEOName", SEOName));
                ParaMeterCollection.Add(new KeyValuePair<string, object>("@PortalID", PortalID));
                ParaMeterCollection.Add(new KeyValuePair<string, object>("@CultureCode", CultureCode));
                //if (MenuId != 0)
                //{
                //    ParaMeterCollection.Add(new KeyValuePair<string, object>("@MenuID", MenuId));
                //    SQLHandler SQLH = new SQLHandler();
                //    SQLH.ExecuteNonQuery("[dbo].[usp_BreadCrumbGetFromMenuItem]", ParaMeterCollection);
                //    return SQLH.ExecuteAsList<BreadCrumInfo>("usp_BreadCrumbMenuItemPath");
                //}
                //else
                //{
                SQLHandler SQLH = new SQLHandler();
                return SQLH.ExecuteAsList<BreadCrumInfo>("usp_BreadCrumbGetFromPageName", ParaMeterCollection);
                //}
            }
            catch (Exception)
            {

                throw;
            }

        }

 public static List<CategoryInfo> GetCategoryAll(bool isActive, AspxCommonInfo aspxCommonObj)
 {
     SQLHandler sqlHandler = new SQLHandler();
     List<KeyValuePair<string, object>> parameterCollection = CommonParmBuilder.GetParamSPUC(aspxCommonObj);
     parameterCollection.Add(new KeyValuePair<string, object>("@IsActive", isActive));
     List<CategoryInfo> catList = sqlHandler.ExecuteAsList<CategoryInfo>("dbo.usp_Aspx_GetCategoryAll", parameterCollection);
     return catList;
 }

 public static List<TickerInfo> LoadOngdvTickerData(int StoreID,int PortalID)
 {
     List<KeyValuePair<string, object>> Parameter = new List<KeyValuePair<string, object>>();
     Parameter.Add(new KeyValuePair<string, object>("@StoreID", StoreID));
     Parameter.Add(new KeyValuePair<string, object>("@PortalID", PortalID));
     SQLHandler sqlHand = new SQLHandler();
     return sqlHand.ExecuteAsList<TickerInfo>("usp_TickerLoadData",Parameter);
 }

 public List<TickerInfo> GetAllTickerItem(int StoreID, int PortalID)
 {
     List<KeyValuePair<string, object>> Parameter = new List<KeyValuePair<string, object>>();
     Parameter.Add(new KeyValuePair<string, object>("@StoreID", StoreID));
     Parameter.Add(new KeyValuePair<string, object>("@PortalID", PortalID));
     SQLHandler sqlH = new SQLHandler();
     return sqlH.ExecuteAsList<TickerInfo>("usp_TickerGetAllTickerItems", Parameter);
 }

 public static List<WareHouseAddress> GetAllWareHouseById(int wareHouseID, AspxCommonInfo aspxCommonObj)
 {
     List<KeyValuePair<string, object>> paramCol = CommonParmBuilder.GetParamSP(aspxCommonObj);
     paramCol.Add(new KeyValuePair<string, object>("@WareHouseID", wareHouseID));
     SQLHandler sageSQL = new SQLHandler();
     List<WareHouseAddress> wList = sageSQL.ExecuteAsList<WareHouseAddress>("[usp_Aspx_SelectWareHouseByID]", paramCol);
     return wList;
 }

 public List<SpecialItemsInfo> GetSpecialItems(AspxCommonInfo aspxCommonObj, int count)
 {
     List<KeyValuePair<string, object>> paramCol = CommonParmBuilder.GetParamSPUC(aspxCommonObj);
     paramCol.Add(new KeyValuePair<string, object>("@count", count));
     SQLHandler sageSQL = new SQLHandler();
     List<SpecialItemsInfo> slInfo = sageSQL.ExecuteAsList<SpecialItemsInfo>("[dbo].[usp_Aspx_GetSpecialItems]", paramCol);
     return slInfo;
 }

 public static List<States> GetStatesByCountry(string countryCode)
 {
     SQLHandler sqlHandler = new SQLHandler();
     List<KeyValuePair<string, object>> paramList = new List<KeyValuePair<string, object>>();
     paramList.Add(new KeyValuePair<string, object>("@CountryCode", countryCode));
     List<States> lstState = sqlHandler.ExecuteAsList<States>("usp_Aspx_GetStateList", paramList);
     return lstState;
 }

 public List<PortalInfo> GetPortalSeoName(int portalID, string userName)
 {
     SQLHandler sqlHandler = new SQLHandler();
     List<KeyValuePair<string, object>> paramList = new List<KeyValuePair<string, object>>();
     paramList.Add(new KeyValuePair<string, object>("@PortalID", portalID));
     paramList.Add(new KeyValuePair<string, object>("@Username", userName));
     return sqlHandler.ExecuteAsList<PortalInfo>("sp_PortalGetByPortalID", paramList);
 }