本文整理汇总了C#中System.Data.SqlHelper.ExecNoQuery方法的典型用法代码示例。如果您正苦于以下问题:C# SqlHelper.ExecNoQuery方法的具体用法?C# SqlHelper.ExecNoQuery怎么用?C# SqlHelper.ExecNoQuery使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类System.Data.SqlHelper
的用法示例。
在下文中一共展示了SqlHelper.ExecNoQuery方法的4个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: Delete
public void Delete(int id)
{
using (SqlHelper sqlh = new SqlHelper(@"
delete from Access.role
where role = @Id"))
{
sqlh.ExecNoQuery();
}
}
示例2: CreateMemberRole
/// <summary>
/// Добавляет подроль.
/// </summary>
/// <param name="owner_id">Идентификатор роли.</param>
/// <param name="offer_id">Идентификатор подроли.</param>
public void CreateMemberRole(int owner_id, int offer_id)
{
using (var sqlh = new SqlHelper())
{
sqlh.ExecNoQuery(@"
insert into Access.role_member
(
role_owner,
role_offer
)
values
(
@owner_id,
@offer_id
)", new {owner_id, offer_id});
}
}
示例3: Update
public void Update(RoleItem role)
{
using (SqlHelper sqlh = new SqlHelper(@"
update Access.role
set
code = @Code,
mem = @Mem
where role = @Id"))
{
sqlh.AddWithValue("@Id", role.Id);
sqlh.AddWithValue("@Code", role.Code);
sqlh.AddWithValue("@Mem", role.Mem);
sqlh.ExecNoQuery();
}
}
示例4: Update
/// <summary>
/// Обновляет данные по роли.
/// </summary>
/// <param name="role">Роль.</param>
public void Update(RoleItem role)
{
using (var sqlh = new SqlHelper())
{
sqlh.ExecNoQuery(@"
update Access.role
set
code = @Code,
mem = @Mem
where role = @Id", role);
}
}