C# SqlHelper.Execute方法代码示例

        /// <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);
        }

        /// <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);
        }

        /// <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);
        }

        /// <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);
            }
        }

        /// <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);
            }
        }

        /// <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);
        }

        /// <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);
            }
        }

        /// <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);
        }

        /// <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);
        }

        /// <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);
        }

        /// <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);
            }
        }

        /// <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);
        }

        /// <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);
            }
        }

        /// <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);
            }
        }

        /// <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);
            }
        }