//删除
public int Delete(int id)
{
string sql = "delete from Users where Id = @id";
SqlParameter[] param =
{
new SqlParameter("@id", id)
};
return(SqlHelper.ExcueteNonQuery(sql, param));
}
public int Edit(Users u)
{
string sql = "update Users set Name = @Name,Birthday = @Birthday,Sex = @Sex where Id = @Id";
SqlParameter[] param =
{
new SqlParameter("@Name", u.Name),
new SqlParameter("@Birthday", u.Birthday),
new SqlParameter("@Sex", u.Sex),
new SqlParameter("@Id", u.Id)
};
return(SqlHelper.ExcueteNonQuery(sql, param));
}
//修改
public int Alter(Users user)
{
string sql = "UPDATE Users SET Name = @name,Birthday = @brithday,Sex=@sex,Addresss = @addresss WHERE Id = Id";
SqlParameter[] param =
{
new SqlParameter("@name", user.Name),
new SqlParameter("@brithday", user.Birthday),
new SqlParameter("@sex", user.Sex),
new SqlParameter("@pid", user.Pid),
new SqlParameter("@id", user.Cid),
new SqlParameter("@aid", user.Aid),
new SqlParameter("@addresss", user.Addresss)
};
return(SqlHelper.ExcueteNonQuery(sql, param));
}
/// <summary>
/// 新增用户
/// </summary>
/// <param name="user"></param>
/// <returns></returns>
public int Add(Users user)
{
string sql = "insert into Users(Name,Birthday,Sex,Pid,Cid,Aid,Addresss) values (@Name,@Birthday,@Sex,@Pid,@Cid,@Aid,@Addresss)";
SqlParameter[] param =
{
new SqlParameter("@Name", SqlDbType.VarChar)
{
Value = user.Name
},
new SqlParameter("@Birthday", SqlDbType.DateTime)
{
Value = user.Birthday
},
new SqlParameter("@Sex", SqlDbType.Char)
{
Value = user.Sex
},
new SqlParameter("@Pid", SqlDbType.Int)
{
Value = user.Pid
},
new SqlParameter("@Cid", SqlDbType.Int)
{
Value = user.Cid
},
new SqlParameter("@Aid", SqlDbType.Int)
{
Value = user.Aid
},
new SqlParameter("@Addresss", SqlDbType.VarChar)
{
Value = user.Addresss
},
};
return(SqlHelper.ExcueteNonQuery(sql, param));
}
