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