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