本文整理汇总了C#中System.Data.SqlHelper.Execute方法的典型用法代码示例。如果您正苦于以下问题:C# SqlHelper.Execute方法的具体用法?C# SqlHelper.Execute怎么用?C# SqlHelper.Execute使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类System.Data.SqlHelper
的用法示例。
在下文中一共展示了SqlHelper.Execute方法的15个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: UpdatePermission
/// <summary>
/// Updates a Permission into the data store based on the primitive properties. This can be used as the
/// update method for an ObjectDataSource.
/// </summary>
/// <param name="permission_id">permission_id</param>
/// <param name="role_nameId">role_nameId</param>
/// <param name="admin_id">admin_id</param>
/// <param name="company_id">company_id</param>
/// <param name="authoriser_id">authoriser_id</param>
/// <param name="company_position">company_position</param>
/// <param name="creation_datetime">creation_datetime</param>
/// <param name="helper">helper</param>
internal static void UpdatePermission(int @permission_id, string @role_nameId, int @admin_id, int @company_id, int @authoriser_id, string @company_position, DateTime @creation_datetime, SqlHelper @helper)
{
string commandText = "PermissionUpdate";
System.Collections.Generic.List<SqlParameter> parameters = new System.Collections.Generic.List<SqlParameter>();
parameters.Add(new SqlParameter("@permission_id", EntityBase.GetDatabaseValue(@permission_id)));
parameters.Add(new SqlParameter("@role_name", EntityBase.GetDatabaseValue(@role_nameId)));
parameters.Add(new SqlParameter("@admin_id", EntityBase.GetDatabaseValue(@admin_id)));
parameters.Add(new SqlParameter("@company_id", EntityBase.GetDatabaseValue(@company_id)));
parameters.Add(new SqlParameter("@authoriser_id", EntityBase.GetDatabaseValue(@authoriser_id)));
parameters.Add(new SqlParameter("@company_position", EntityBase.GetDatabaseValue(@company_position)));
parameters.Add(new SqlParameter("@creation_datetime", EntityBase.GetDatabaseValue(@creation_datetime)));
@helper.Execute(commandText, CommandType.StoredProcedure, parameters);
}
示例2: UpdateRewardSetting
/// <summary>
/// Updates a RewardSetting into the data store based on the primitive properties. This can be used as the
/// update method for an ObjectDataSource.
/// </summary>
/// <param name="setting_id">setting_id</param>
/// <param name="company_id">company_id</param>
/// <param name="expiry_days">expiry_days</param>
/// <param name="points_per_dollar">points_per_dollar</param>
/// <param name="points_threshold">points_threshold</param>
/// <param name="voucher_amount">voucher_amount</param>
/// <param name="enable_vouchers">enable_vouchers</param>
/// <param name="helper">helper</param>
internal static void UpdateRewardSetting(int @setting_id, int @company_id, int @expiry_days, int @points_per_dollar, int @points_threshold, decimal @voucher_amount, bool @enable_vouchers, SqlHelper @helper)
{
string commandText = "RewardSettingUpdate";
System.Collections.Generic.List<SqlParameter> parameters = new System.Collections.Generic.List<SqlParameter>();
parameters.Add(new SqlParameter("@setting_id", EntityBase.GetDatabaseValue(@setting_id)));
parameters.Add(new SqlParameter("@company_id", EntityBase.GetDatabaseValue(@company_id)));
parameters.Add(new SqlParameter("@expiry_days", EntityBase.GetDatabaseValue(@expiry_days)));
parameters.Add(new SqlParameter("@points_per_dollar", EntityBase.GetDatabaseValue(@points_per_dollar)));
parameters.Add(new SqlParameter("@points_threshold", EntityBase.GetDatabaseValue(@points_threshold)));
parameters.Add(new SqlParameter("@voucher_amount", EntityBase.GetDatabaseValue(@voucher_amount)));
parameters.Add(new SqlParameter("@enable_vouchers", @enable_vouchers));
@helper.Execute(commandText, CommandType.StoredProcedure, parameters);
}
示例3: DeletePurchaseOrderItem
/// <summary>
/// Deletes a PurchaseOrderItem from the data store based on the primitive primary keys. This can be used as the
/// delete method for an ObjectDataSource.
/// </summary>
/// <param name="purchaseorder_id">purchaseorder_id</param>
/// <param name="product_code">product_code</param>
/// <param name="helper">helper</param>
internal static void DeletePurchaseOrderItem(int @purchaseorder_id, string @product_code, SqlHelper @helper)
{
string commandText = "PurchaseOrderItemDelete";
System.Collections.Generic.List<SqlParameter> parameters = new System.Collections.Generic.List<SqlParameter>();
parameters.Add(new SqlParameter("@purchaseorder_id", @purchaseorder_id));
parameters.Add(new SqlParameter("@product_code", @product_code));
@helper.Execute(commandText, CommandType.StoredProcedure, parameters);
}
示例4: DeleteTriggersByuploadedad_
/// <summary>
/// Deletes Trigger objects by a UploadedAd unique identifier.
/// </summary>
/// <param name="uploadedad_id">uploadedad_id</param>
public static void DeleteTriggersByuploadedad_(int uploadedad_id)
{
string commandText = "TriggerDeleteByUploadedAd";
System.Collections.Generic.List<SqlParameter> parameters = new System.Collections.Generic.List<SqlParameter>();
parameters.Add(new SqlParameter("@uploadedad_id", uploadedad_id));
using (SqlHelper helper = new SqlHelper())
{
helper.Execute(commandText, CommandType.StoredProcedure, parameters);
}
}
示例5: DeleteRewardSettingsBycompany_
/// <summary>
/// Deletes RewardSetting objects by a Company unique identifier.
/// </summary>
/// <param name="company_id">company_id</param>
public static void DeleteRewardSettingsBycompany_(int company_id)
{
string commandText = "RewardSettingDeleteByCompany";
System.Collections.Generic.List<SqlParameter> parameters = new System.Collections.Generic.List<SqlParameter>();
parameters.Add(new SqlParameter("@company_id", company_id));
using (SqlHelper helper = new SqlHelper())
{
helper.Execute(commandText, CommandType.StoredProcedure, parameters);
}
}
示例6: UpdateDocketItem
/// <summary>
/// Updates a DocketItem into the data store based on the primitive properties. This can be used as the
/// update method for an ObjectDataSource.
/// </summary>
/// <param name="docketitem_id">docketitem_id</param>
/// <param name="docket_id">docket_id</param>
/// <param name="product_code">product_code</param>
/// <param name="description">description</param>
/// <param name="quantity">quantity</param>
/// <param name="product_barcode">product_barcode</param>
/// <param name="department">department</param>
/// <param name="cost_ex">cost_ex</param>
/// <param name="sale_ex">sale_ex</param>
/// <param name="category">category</param>
/// <param name="sale_inc">sale_inc</param>
/// <param name="helper">helper</param>
internal static void UpdateDocketItem(int @docketitem_id, int @docket_id, string @product_code, string @description, double @quantity, string @product_barcode, string @department, decimal @cost_ex, decimal @sale_ex, string @category, decimal @sale_inc, SqlHelper @helper)
{
string commandText = "DocketItemUpdate";
System.Collections.Generic.List<SqlParameter> parameters = new System.Collections.Generic.List<SqlParameter>();
parameters.Add(new SqlParameter("@docketitem_id", EntityBase.GetDatabaseValue(@docketitem_id)));
parameters.Add(new SqlParameter("@docket_id", EntityBase.GetDatabaseValue(@docket_id)));
parameters.Add(new SqlParameter("@product_code", EntityBase.GetDatabaseValue(@product_code)));
parameters.Add(new SqlParameter("@description", EntityBase.GetDatabaseValue(@description)));
parameters.Add(new SqlParameter("@quantity", @quantity));
parameters.Add(new SqlParameter("@product_barcode", EntityBase.GetDatabaseValue(@product_barcode)));
parameters.Add(new SqlParameter("@department", EntityBase.GetDatabaseValue(@department)));
parameters.Add(new SqlParameter("@cost_ex", EntityBase.GetDatabaseValue(@cost_ex)));
parameters.Add(new SqlParameter("@sale_ex", EntityBase.GetDatabaseValue(@sale_ex)));
parameters.Add(new SqlParameter("@category", EntityBase.GetDatabaseValue(@category)));
parameters.Add(new SqlParameter("@sale_inc", EntityBase.GetDatabaseValue(@sale_inc)));
@helper.Execute(commandText, CommandType.StoredProcedure, parameters);
}
示例7: DeleteTriggersBycreator_
/// <summary>
/// Deletes Trigger objects by a Admin unique identifier.
/// </summary>
/// <param name="admin_id">admin_id</param>
public static void DeleteTriggersBycreator_(int admin_id)
{
string commandText = "TriggerDeleteByAdmin";
System.Collections.Generic.List<SqlParameter> parameters = new System.Collections.Generic.List<SqlParameter>();
parameters.Add(new SqlParameter("@creator_id", admin_id));
using (SqlHelper helper = new SqlHelper())
{
helper.Execute(commandText, CommandType.StoredProcedure, parameters);
}
}
示例8: DeleteRequestedAd
/// <summary>
/// Deletes a RequestedAd from the data store based on the primitive primary keys. This can be used as the
/// delete method for an ObjectDataSource.
/// </summary>
/// <param name="admatch_id">admatch_id</param>
/// <param name="uploadedad_id">uploadedad_id</param>
/// <param name="helper">helper</param>
internal static void DeleteRequestedAd(int @admatch_id, int @uploadedad_id, SqlHelper @helper)
{
string commandText = "RequestedAdDelete";
System.Collections.Generic.List<SqlParameter> parameters = new System.Collections.Generic.List<SqlParameter>();
parameters.Add(new SqlParameter("@admatch_id", @admatch_id));
parameters.Add(new SqlParameter("@uploadedad_id", @uploadedad_id));
@helper.Execute(commandText, CommandType.StoredProcedure, parameters);
}
示例9: UpdateRequestedAd
/// <summary>
/// Updates a RequestedAd into the data store based on the primitive properties. This can be used as the
/// update method for an ObjectDataSource.
/// </summary>
/// <param name="admatch_id">admatch_id</param>
/// <param name="uploadedad_id">uploadedad_id</param>
/// <param name="num_wanted">num_wanted</param>
/// <param name="daily_quota">daily_quota</param>
/// <param name="num_printed">num_printed</param>
/// <param name="is_active">is_active</param>
/// <param name="helper">helper</param>
internal static void UpdateRequestedAd(int @admatch_id, int @uploadedad_id, int @num_wanted, int @daily_quota, int @num_printed, bool @is_active, SqlHelper @helper)
{
string commandText = "RequestedAdUpdate";
System.Collections.Generic.List<SqlParameter> parameters = new System.Collections.Generic.List<SqlParameter>();
parameters.Add(new SqlParameter("@admatch_id", EntityBase.GetDatabaseValue(@admatch_id)));
parameters.Add(new SqlParameter("@uploadedad_id", EntityBase.GetDatabaseValue(@uploadedad_id)));
parameters.Add(new SqlParameter("@num_wanted", EntityBase.GetDatabaseValue(@num_wanted)));
parameters.Add(new SqlParameter("@daily_quota", EntityBase.GetDatabaseValue(@daily_quota)));
parameters.Add(new SqlParameter("@num_printed", EntityBase.GetDatabaseValue(@num_printed)));
parameters.Add(new SqlParameter("@is_active", @is_active));
@helper.Execute(commandText, CommandType.StoredProcedure, parameters);
}
示例10: UpdateRole
/// <summary>
/// Updates a Role into the data store based on the primitive properties. This can be used as the
/// update method for an ObjectDataSource.
/// </summary>
/// <param name="role_name">role_name</param>
/// <param name="notes">notes</param>
/// <param name="helper">helper</param>
internal static void UpdateRole(string @role_name, string @notes, SqlHelper @helper)
{
string commandText = "RoleUpdate";
System.Collections.Generic.List<SqlParameter> parameters = new System.Collections.Generic.List<SqlParameter>();
parameters.Add(new SqlParameter("@role_name", EntityBase.GetDatabaseValue(@role_name)));
parameters.Add(new SqlParameter("@notes", EntityBase.GetDatabaseValue(@notes)));
@helper.Execute(commandText, CommandType.StoredProcedure, parameters);
}
示例11: DeleteRequestedAdsByadmatch_
/// <summary>
/// Deletes RequestedAd objects by a AdMatch unique identifier.
/// </summary>
/// <param name="admatch_id">admatch_id</param>
public static void DeleteRequestedAdsByadmatch_(int admatch_id)
{
string commandText = "RequestedAdDeleteByAdMatch";
System.Collections.Generic.List<SqlParameter> parameters = new System.Collections.Generic.List<SqlParameter>();
parameters.Add(new SqlParameter("@admatch_id", admatch_id));
using (SqlHelper helper = new SqlHelper())
{
helper.Execute(commandText, CommandType.StoredProcedure, parameters);
}
}
示例12: DeleteRole
/// <summary>
/// Deletes a Role from the data store based on the primitive primary keys. This can be used as the
/// delete method for an ObjectDataSource.
/// </summary>
/// <param name="role_name">role_name</param>
/// <param name="helper">helper</param>
internal static void DeleteRole(string @role_name, SqlHelper @helper)
{
string commandText = "RoleDelete";
System.Collections.Generic.List<SqlParameter> parameters = new System.Collections.Generic.List<SqlParameter>();
parameters.Add(new SqlParameter("@role_name", @role_name));
@helper.Execute(commandText, CommandType.StoredProcedure, parameters);
}
示例13: DeletePermissionsByrole_name
/// <summary>
/// Deletes Permission objects by a Role unique identifier.
/// </summary>
/// <param name="role_name">role_name</param>
public static void DeletePermissionsByrole_name(string role_name)
{
string commandText = "PermissionDeleteByRole";
System.Collections.Generic.List<SqlParameter> parameters = new System.Collections.Generic.List<SqlParameter>();
parameters.Add(new SqlParameter("@role_name", role_name));
using (SqlHelper helper = new SqlHelper())
{
helper.Execute(commandText, CommandType.StoredProcedure, parameters);
}
}
示例14: DeletePermissionsByauthoriser_
/// <summary>
/// Deletes Permission objects by a Admin object.
/// </summary>
/// <param name="admin">admin</param>
public static void DeletePermissionsByauthoriser_(Admin admin)
{
string commandText = "PermissionDeleteByAdmin";
System.Collections.Generic.List<SqlParameter> parameters = new System.Collections.Generic.List<SqlParameter>();
parameters.Add(new SqlParameter("@authoriser_id", admin.admin_id));
using (SqlHelper helper = new SqlHelper())
{
helper.Execute(commandText, CommandType.StoredProcedure, parameters);
}
}
示例15: DeleteDocketItemsBydocket_
/// <summary>
/// Deletes DocketItem objects by a Docket unique identifier.
/// </summary>
/// <param name="docket_id">docket_id</param>
public static void DeleteDocketItemsBydocket_(int docket_id)
{
string commandText = "DocketItemDeleteByDocket";
System.Collections.Generic.List<SqlParameter> parameters = new System.Collections.Generic.List<SqlParameter>();
parameters.Add(new SqlParameter("@docket_id", docket_id));
using (SqlHelper helper = new SqlHelper())
{
helper.Execute(commandText, CommandType.StoredProcedure, parameters);
}
}