本文整理汇总了C#中StoredProcedure.ExecuteDataTable方法的典型用法代码示例。如果您正苦于以下问题：C# StoredProcedure.ExecuteDataTable方法的具体用法？C# StoredProcedure.ExecuteDataTable怎么用？C# StoredProcedure.ExecuteDataTable使用的例子？那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类StoredProcedure的用法示例。
在下文中一共展示了StoredProcedure.ExecuteDataTable方法的12个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: AllCategoriesDrugsByParent
public static DataTable AllCategoriesDrugsByParent(int? p_ParentCategoryID, bool p_isShowAll)
{
StoredProcedure sp = new StoredProcedure("p_CategoriesDrugs_sl_ByParent");
sp["@CategoryID"].Value = p_ParentCategoryID == null ? DBNull.Value : (object)p_ParentCategoryID;
sp["@ShowAll"].Value = p_isShowAll;
return sp.ExecuteDataTable();
}示例2: GetCategory
public static DataTable GetCategory(int p_CategoryID)
{
StoredProcedure sp = new StoredProcedure("p_Categories_s");
sp["@CategoryID"].Value = p_CategoryID;
return sp.ExecuteDataTable();
}示例3: AllByParent
public static DataTable AllByParent(int? p_ParentCategoryID, bool p_ShowDisable)
{
StoredProcedure sp = new StoredProcedure("p_Categories_sl_ByParent");
sp["@ParentCategoryID"].Value = p_ParentCategoryID==null?DBNull.Value:(object)p_ParentCategoryID;
sp["@ShowDisable"].Value = p_ShowDisable;
return sp.ExecuteDataTable();
}示例4: GetBanner
public static DataRow GetBanner(int p_BannerID)
{
StoredProcedure sp = new StoredProcedure("p_Banners_s");
sp["@BannerID"].Value = p_BannerID;
DataTable l_dtRes = sp.ExecuteDataTable();
if (l_dtRes.Rows.Count<=0) return null;
return l_dtRes.Rows[0];
}示例5: GetCategoryByCode
public static DataRow GetCategoryByCode(string p_CategoryCode)
{
StoredProcedure sp = new StoredProcedure("p_Categories_s_byCategoryCode");
sp["@CategoryCode"].Value = p_CategoryCode;
DataTable l_dtRes = sp.ExecuteDataTable();
if (l_dtRes.Rows.Count>0)
{
return l_dtRes.Rows[0];
}else {return null;}
}示例6: All
public static DataTable All()
{
StoredProcedure sp = new StoredProcedure("p_Banners_sl");
return sp.ExecuteDataTable();
}示例7: GetPossibleDeliveries
public static DataTable GetPossibleDeliveries(string p_DrugIDs)
{
StoredProcedure sp = new StoredProcedure("p_DeliveryMethods_s_ByDrugs");
sp["@DrugIDs"].Value = p_DrugIDs;
return sp.ExecuteDataTable();
}示例8: GetCategoryByDrugId
public static DataTable GetCategoryByDrugId(int p_DrugID)
{
StoredProcedure sp = new StoredProcedure("p_Category_sl_byDrugID");
sp["@DrugID"].Value = p_DrugID;
return sp.ExecuteDataTable();
}示例9: All
public static DataTable All(bool p_ShowDisable)
{
StoredProcedure sp = new StoredProcedure("p_Categories_sl");
sp["@ShowDisable"].Value = p_ShowDisable;
return sp.ExecuteDataTable();
}示例10: GetCategoryParentByID
public static DataRow GetCategoryParentByID(int p_CategoryID)
{
StoredProcedure sp = new StoredProcedure("p_Categories_s_ParentbyCategoryID");
sp["@CategoryID"].Value = p_CategoryID;
DataTable l_dtRes = sp.ExecuteDataTable();
if (l_dtRes.Rows.Count > 0)
{
return l_dtRes.Rows[0];
}
else { return null; }
}示例11: GetCustomerAddresses
public static DataTable GetCustomerAddresses(int p_CustomerID)
{
StoredProcedure sp = new StoredProcedure("p_CustomerAddresses_sl");
sp["@CustomerID"].Value = p_CustomerID;
return sp.ExecuteDataTable();
}示例12: GetCustomerByCredentials
private static DataTable GetCustomerByCredentials(string p_Login, string p_Password, bool p_isCheckPass)
{
StoredProcedure sp = new StoredProcedure("p_Customers_s_byLogin");
sp["@Login"].Value = p_Login.Trim();
sp["@Password"].Value = p_Password.Trim();
sp["@isCheckPass"].Value = p_isCheckPass;
return sp.ExecuteDataTable();
}