public override int Insert(Entity.BlogUser entity)
{
return((int)
base.ExecuteScalar <decimal>(
"insert into BlogUser (UserPassword,Name,Nick) values (@UserPassword,@Name,@Nick) SELECT SCOPE_IDENTITY()",
new SqlParameters
{
{ "UserPassword", entity.UserPassword },
{ "Name", entity.Name },
{ "Nick", entity.Nick },
}
));
}
public override bool Update(Entity.BlogUser entity)
{
var res = base.ExecuteNonQuery(
"UPDATE BlogUser set UserPassword = @UserPassword, Name = @Name, Nick = @Nick where Id = @Id ",
new SqlParameters
{
{ "UserPassword", entity.UserPassword },
{ "Name", entity.Name },
{ "Nick", entity.Nick },
{ "Id", entity.Id },
}
);
return(res > 0);
}