本文整理汇总了C#中SQLHandler.ExecuteAsDataSet方法的典型用法代码示例。如果您正苦于以下问题：C# SQLHandler.ExecuteAsDataSet方法的具体用法？C# SQLHandler.ExecuteAsDataSet怎么用？C# SQLHandler.ExecuteAsDataSet使用的例子？那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类SQLHandler的用法示例。
在下文中一共展示了SQLHandler.ExecuteAsDataSet方法的15个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: GetAdvanceSearchDataSet
public DataSet GetAdvanceSearchDataSet(string prefix, bool isActive, AspxCommonInfo aspxCommonObj, int CategoryID, bool IsGiftCard)
{
try
{
DataSet objHDSetting = new DataSet();
if (!CacheHelper.Get("AdvanceSearchDataSet" + aspxCommonObj.StoreID.ToString() + aspxCommonObj.PortalID.ToString() + "_" + aspxCommonObj.CultureName, out objHDSetting))
{
int itemID = 0;
List<KeyValuePair<string, object>> parameterCollection = CommonParmBuilder.GetParamSPC(aspxCommonObj);
parameterCollection.Add(new KeyValuePair<string, object>("@CategoryID", CategoryID));
parameterCollection.Add(new KeyValuePair<string, object>("@IsGiftCard", IsGiftCard));
parameterCollection.Add(new KeyValuePair<string, object>("@Prefix", prefix));
parameterCollection.Add(new KeyValuePair<string, object>("@IsActive", isActive));
parameterCollection.Add(new KeyValuePair<string, object>("@ItemID", itemID));
parameterCollection.Add(new KeyValuePair<string, object>("@UserName", aspxCommonObj.UserName));
SQLHandler sqlH = new SQLHandler();
objHDSetting = sqlH.ExecuteAsDataSet("[dbo].[usp_Aspx_AdvanceSearch]", parameterCollection);
}
return objHDSetting;
}
catch (Exception e)
{
throw e;
}
}示例2: GetCatalogPricingRule
public static DataSet GetCatalogPricingRule(Int32 catalogPriceRuleID, AspxCommonInfo aspxCommonObj)
{
SQLHandler sqlHandler = new SQLHandler();
List<KeyValuePair<string, object>> paramList = CommonParmBuilder.GetParamSPUC(aspxCommonObj);
paramList.Add(new KeyValuePair<string, object>("@CatalogPriceRuleID", catalogPriceRuleID));
DataSet ds = sqlHandler.ExecuteAsDataSet("usp_Aspx_GetPricingRuleInfoByID", paramList);
return ds;
}示例3: GetCatalogPricingRule
public DataSet GetCatalogPricingRule(Int32 catalogPriceRuleID, AspxCommonInfo aspxCommonObj)
{
SQLHandler sqlHandler = new SQLHandler();
List<KeyValuePair<string, object>> paramList = new List<KeyValuePair<string, object>>();
paramList.Add(new KeyValuePair<string, object>("@CatalogPriceRuleID", catalogPriceRuleID));
paramList.Add(new KeyValuePair<string, object>("@StoreID", aspxCommonObj.StoreID));
paramList.Add(new KeyValuePair<string, object>("@PortalID", aspxCommonObj.PortalID));
paramList.Add(new KeyValuePair<string, object>("@UserName", aspxCommonObj.UserName));
paramList.Add(new KeyValuePair<string, object>("@CultureName", aspxCommonObj.CultureName));
DataSet ds = sqlHandler.ExecuteAsDataSet("usp_Aspx_GetPricingRuleInfoByID", paramList);
return ds;
}示例4: GetCatalogPricingRule
public DataSet GetCatalogPricingRule(Int32 catalogPriceRuleID, Int32 storeID, Int32 portalID, string userName, string culture)
{
SQLHandler sqlHandler = new SQLHandler();
List<KeyValuePair<string, object>> paramList = new List<KeyValuePair<string, object>>();
paramList.Add(new KeyValuePair<string, object>("@CatalogPriceRuleID", catalogPriceRuleID));
paramList.Add(new KeyValuePair<string, object>("@StoreID", storeID));
paramList.Add(new KeyValuePair<string, object>("@PortalID", portalID));
paramList.Add(new KeyValuePair<string, object>("@Username", userName));
paramList.Add(new KeyValuePair<string, object>("@CultureName", culture));
DataSet ds = sqlHandler.ExecuteAsDataSet("usp_Aspx_GetPricingRuleInfoByID", paramList);
return ds;
}示例5: GetLatestItemsByCount
public DataSet GetLatestItemsByCount(AspxCommonInfo aspxCommonObj)
{
try
{
List<KeyValuePair<string, object>> parameterCollection = CommonParmBuilder.GetParamSPUC(aspxCommonObj);
SQLHandler sqlH = new SQLHandler();
return sqlH.ExecuteAsDataSet("[dbo].[usp_Aspx_GetLatestItemInfo]", parameterCollection);
}
catch (Exception e)
{
throw e;
}
}示例6: GetBrandSettingAndSlider
public DataSet GetBrandSettingAndSlider(AspxCommonInfo aspxCommonObj)
{
try
{
List<KeyValuePair<string, object>> ParaMeter = CommonParmBuilder.GetParamSPC(aspxCommonObj);
SQLHandler sqLH = new SQLHandler();
return sqLH.ExecuteAsDataSet("usp_Aspx_BrandSettingAndSlider", ParaMeter);
}
catch (Exception e)
{
throw e;
}
}示例7: GetAllPortals
public DataTable GetAllPortals()
{
try
{
DataSet ds = new DataSet();
SQLHandler sagesql = new SQLHandler();
ds = sagesql.ExecuteAsDataSet("dbo.sp_GetAllPortals");
DataTable dt = ds.Tables[0];
return dt;
}
catch (Exception e)
{
throw e;
}
}示例8: MakeHtmlDataSet
public DataSet MakeHtmlDataSet(string HtmlUserModuleID)
{
SQLHandler sagesql = new SQLHandler();
List<KeyValuePair<string, object>> ParamCollInput = new List<KeyValuePair<string, object>>();
ParamCollInput.Add(new KeyValuePair<string, object>("@UserModuleID", HtmlUserModuleID));
DataSet objDataSet = new DataSet();
try
{
objDataSet = sagesql.ExecuteAsDataSet("usp_Template_ExtractModules", ParamCollInput);
}
catch (Exception)
{
throw;
}
return objDataSet;
}示例9: GetExtensionSettings
public DataSet GetExtensionSettings(string ModuleID)
{
try
{
List<KeyValuePair<string, string>> ParaMeterCollection = new List<KeyValuePair<string, string>>();
ParaMeterCollection.Add(new KeyValuePair<string, string>("@ModuleID", ModuleID));
ParaMeterCollection.Add(new KeyValuePair<string, string>("@PortalID", GetPortalID.ToString()));
DataSet ds = new DataSet();
SQLHandler sagesql = new SQLHandler();
ds = sagesql.ExecuteAsDataSet("dbo.sp_GetExtensionSetting", ParaMeterCollection);
return ds;
}
catch (Exception e)
{
throw e;
}
} 示例10: GetSettingsByPortalAndSettingType
private DataSet GetSettingsByPortalAndSettingType(string PortalID, string SettingType)
{
try
{
List<KeyValuePair<string, string>> ParaMeterCollection = new List<KeyValuePair<string, string>>();
ParaMeterCollection.Add(new KeyValuePair<string, string>("@PortalID", PortalID));
ParaMeterCollection.Add(new KeyValuePair<string, string>("@SettingType", SettingType));
DataSet ds = new DataSet();
SQLHandler sagesql = new SQLHandler();
ds = sagesql.ExecuteAsDataSet("dbo.sp_GetAllSettings", ParaMeterCollection);
return ds;
}
catch (Exception e)
{
throw e;
}
}示例11: GetStoreSettingsByPortal
public DataSet GetStoreSettingsByPortal(int storeID,int portalID, string cultureName)
{
try
{
List<KeyValuePair<string, object>> parameterCollection = new List<KeyValuePair<string, object>>();
parameterCollection.Add(new KeyValuePair<string, object>("@StoreID", storeID));
parameterCollection.Add(new KeyValuePair<string, object>("@PortalID", portalID));
parameterCollection.Add(new KeyValuePair<string, object>("@CultureName", cultureName));
DataSet ds = new DataSet();
SQLHandler sagesql = new SQLHandler();
ds = sagesql.ExecuteAsDataSet("usp_Aspx_GetStoreSettingForCache", parameterCollection);
return ds;
}
catch (Exception e)
{
throw e;
}
}示例12: GetSettingsByPortalAndSettingType
public DataSet GetSettingsByPortalAndSettingType(string usermoduleID, string QuestionID, string PortalID, string Username)
{
try
{
List<KeyValuePair<string, string>> ParaMeterCollection = new List<KeyValuePair<string, string>>();
ParaMeterCollection.Add(new KeyValuePair<string, string>("@usermoduleID", usermoduleID));
ParaMeterCollection.Add(new KeyValuePair<string, string>("@QuestionID", QuestionID));
ParaMeterCollection.Add(new KeyValuePair<string, string>("@PortalID", PortalID));
ParaMeterCollection.Add(new KeyValuePair<string, string>("@Username", Username));
DataSet ds = new DataSet();
SQLHandler sagesql = new SQLHandler();
ds = sagesql.ExecuteAsDataSet("dbo.sp_PollAnswerList", ParaMeterCollection);
return ds;
}
catch (Exception e)
{
throw e;
}
}示例13: GetCountryList
public static List<Countries> GetCountryList()
{
List<Countries> lstCountries = new List<Countries>();
DataSet ds = new DataSet();
try
{
SQLHandler sagesql = new SQLHandler();
ds = sagesql.ExecuteAsDataSet("sp_GetCountryList");
}
catch (Exception)
{
throw;
}
foreach (DataRow row in ds.Tables[0].Rows)
{
lstCountries.Add(new Countries("Modules/Language/flags/" + row["Value"].ToString().ToLower() + ".png", row["Text"].ToString(), row["Culture"].ToString()));
}
return lstCountries;
}示例14: GetPageSettings
public DataSet GetPageSettings(string controlType, string pageID)
{
try
{
List<KeyValuePair<string, string>> ParaMeterCollection = new List<KeyValuePair<string, string>>();
ParaMeterCollection.Add(new KeyValuePair<string, string>("@ControlType", controlType));
ParaMeterCollection.Add(new KeyValuePair<string, string>("@PageID", pageID));
ParaMeterCollection.Add(new KeyValuePair<string, string>("@PortalID", GetPortalID.ToString()));
ParaMeterCollection.Add(new KeyValuePair<string, string>("@UserName", GetUsername));
DataSet ds = new DataSet();
SQLHandler sagesql = new SQLHandler();
ds = sagesql.ExecuteAsDataSet("dbo.sp_GetPageSetting", ParaMeterCollection);
return ds;
}
catch (Exception e)
{
throw e;
}
}示例15: NotificationUsersGetAll
public static List<SubscriptionInfo> NotificationUsersGetAll(AspxCommonInfo aspxCommonObj)
{
try
{
List<KeyValuePair<string, object>> parameterCollection = CommonParmBuilder.GetParamSP(aspxCommonObj);
SQLHandler sqLH = new SQLHandler();
DataSet ds = sqLH.ExecuteAsDataSet("[dbo].[usp_Aspx_NotificationUsersGetAll]",parameterCollection);
List<SubscriptionInfo> SubscriptionDetails = new List<SubscriptionInfo>();
if (ds.Tables.Count > 0)
{
SubscriptionDetails = DataSourceHelper.FillCollection<SubscriptionInfo>(ds.Tables[0]);
}
return SubscriptionDetails;
}
catch (Exception e)
{
throw e;
}
}