/// <summary>
/// 修改
/// </summary>
/// <param name="p"></param>
/// <returns></returns>
public int Up_User(UsersModels U)
{
string sql = "update Users set Email=@Email,NickName=@NickName,Photo=@Photo where Id=@Id";
SqlParameter[] param =
{
new SqlParameter("@Email", SqlDbType.VarChar)
{
Value = U.Email
},
new SqlParameter("@NickName", SqlDbType.VarChar)
{
Value = U.NickName
},
new SqlParameter("@Photo", SqlDbType.VarChar)
{
Value = U.Photo
},
new SqlParameter("@Id", SqlDbType.Int)
{
Value = U.ID
},
};
return(Class1.ExcuteNoQuery(sql, CommandType.Text, param));
}
/// <summary>
/// 删除
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public int Del_Users(int id)
{
string sql = "delete from Users where Id = @Id";
SqlParameter[] sp =
{
new SqlParameter("@Id", id)
};
return(Class1.ExcuteNoQuery(sql, CommandType.Text, sp));
}
/// <summary>
/// 添加
/// </summary>
/// <param name="users"></param>
/// <returns></returns>
public int Add_User(UsersModels u)
{
string sql = "insert into Users(Email,Password,Nickname,Photo) values(@Email,@Password,@Nickname,@Photo)";
SqlParameter[] sp =
{
new SqlParameter("@Email", u.Email),
new SqlParameter("@Password", u.Password),
new SqlParameter("@Nickname", u.NickName),
new SqlParameter("@Photo", u.Photo)
};
return(Class1.ExcuteNoQuery(sql, CommandType.Text, sp));
}
