//查看评论
public bool lookComment(Mail m, Comment c)
{
//改变标志位
string sql2 = string.Format("Update FFTX_Photo_Comment set comment_look_flag = 1 where comment_id = {0}", c.Comment_Id);
int r2 = SqlDB.ExecuteNonQuery(sql2);
//success
if (r2 == 1)
{
//更新站内信条数
string sql = string.Format("Update FFTX_Mail set comment_num = {0} where user_id = {1}", m.Comment_Num, m.User_Id);
int r = SqlDB.ExecuteNonQuery(sql);
if (r == 1)
{
return(true);
}
else
{
return(false);
}
}
else
{
return(false);
}
}
/// <summary>
/// 添加好友 好友所在组 人员数+1
/// </summary>
/// <param name="f">包含User Id, Follow_Id, Group_Id, Follow_id_Remark</param>
/// <returns>成功返回1 已成为好友返回2 失败返回0</returns>
public int addFriend(Friend f)
{
//添加之前先查询是否已经成为好友
if (hasBeenFriend(f))
{
return(2);
}
else
{ // 没有成为好友 再添加好友
string sql = string.Format("INSERT INTO FFTX_Friend (user_id,follow_id,group_id,follow_id_remark) VALUES ('{0}','{1}','{2}','{3}')",
f.User_Id, f.Follow_Id, f.Group_Id, f.Follow_Id_Remark);
int result = SqlDB.ExecuteNonQuery(sql);
//用户关注和 粉丝数的变更
//加完好友 好友所在组数+1
if (result == 1 && new GroupSql().plusOneInGroupNum(f) && new UserSql().changeUserFans(f.Follow_Id, "plus") && new UserSql().changeUserFollow(f.User_Id, "plus"))
{
return(1);
}
else
{
return(0);
}
}
}
public bool changeUserFollow(string user_id, string operate)
{
string sql = null;
if (operate.Equals("plus"))
{
sql = string.Format("Update FFTX_User set user_follow = (user_follow+1) where user_id = {0}", user_id);
}
else if (operate.Equals("dec"))
{
sql = string.Format("Update FFTX_User set user_fans = (user_fans+1) where user_id = {0}", user_id);
}
else
{
return(false);
}
int result = SqlDB.ExecuteNonQuery(sql);
if (result == 1)
{
return(true);
}
else
{
return(false);
}
}
public int changeHeadImg(User u)
{
string sql = string.Format("Update FFTX_User set user_headimg = '{0}' where user_id = {1}", u.User_HeadImg, u.User_Id);
int result = SqlDB.ExecuteNonQuery(sql);
return(result);
}
/// <summary>
/// 添加用户分组信息 ( 用户创建了一个分组)
/// </summary>
/// <param name="group">需要有 User_id和Group_name </param>
/// <returns>添加成功返回true</returns>
public bool addGroupFriendInfo(Group group)
{
//添加之前先查询是否有同名分组
if (searchGroupFriendInfo(group))
{
//查找到分组 直接返回
return(true);
}
else
{
//没有查找到 添加分组
string sql = string.Format("Insert Into FFTX_Group_to_Friend(user_id,group_id,group_name) VALUES('{0}',{1},'{2}')", group.User_Id, group.Group_Id, group.Group_Name);
int result = SqlDB.ExecuteNonQuery(sql);
//是否成功
if (result == 1)
{
//获取用户分组信息
if (searchGroupFriendInfo(group))
{
return(true);
}
else
{
return(false);
}
}
else
{
return(false);
}
}
}
//主动封号
public bool blockUser(AdminOperate ao)
{
bool result = false;
User u = new User();
u.User_Id = ao.User_Id;
//判断用户是否存在
if (new UserSql().isExistUser(u))
{
//改用户状态
string sql = string.Format("Update FFTX_User set user_state = 0 where user_id = {0}", ao.User_Id);
int r = SqlDB.ExecuteNonQuery(sql);
//执行失败
if (r != 1)
{
return(false);
}
//添加一条 处理数据
string sql2 = string.Format("INSERT INTO FFTX_Admin_Operate (admin_id,user_id,operate_time,operate_reason) VALUES ('{0}','{1}','{2}','{3}')",
ao.Admin_Id, ao.User_Id, ao.Operate_Time, ao.Operate_Reason);
r = SqlDB.ExecuteNonQuery(sql2);
//添加数据失败
if (r != 1)
{
return(false);
}
return(true);
}
return(result);
}
//创建相册
public int addAlbum(Album album)
{
string sql = string.Format("INSERT INTO FFTX_Album (user_id,album_name,album_describe,album_power) VALUES ('{0}','{1}','{2}','{3}')",
album.User_Id, album.Album_Name, album.Album_Describe, album.Album_Power);
int result = SqlDB.ExecuteNonQuery(sql);
return(result);
}
//重命名相册
public bool renameAlbum(Album album)
{
string sql = string.Format("Update FFTX_Album set album_name = '{0}' where album_id = {1}", album.Album_Name, album.Album_Id);
int r = SqlDB.ExecuteNonQuery(sql);
//执行失败
if (r != 1)
{
return(false);
}
return(true);
}
//清空信息
public bool emptyMail(Mail m)
{
string sql = string.Format("Update FFTX_Mail set comment_num = 0,share_num=0,like_num=0,message_num =0 where user_id = {2}", m.Comment_Num, m.Message_Num, m.User_Id);
int r = SqlDB.ExecuteNonQuery(sql);
//执行失败
if (r != 1)
{
return(false);
}
return(true);
}
public bool changeUserState(string uid, int state)
{
string sql = string.Format("Update FFTX_User set user_state = {0} where user_id = '{1}'", state, uid);
int result = SqlDB.ExecuteNonQuery(sql);
if (result == 1)
{
return(true);
}
else
{
return(false);
}
}
//解封
public bool deblockUser(UserRequest ur)
{
string sql = string.Format("delete from FFTX_Admin_Request where user_id = {0}", ur.User_Id);
int result = SqlDB.ExecuteNonQuery(sql);
if (result == 1)
{
return(true);
}
else
{
return(false);
}
}
//删除留言
public bool deleteMessage(int mid)
{
string sql = string.Format("delete from FFTX_BoardMessage where message_id={0}", mid);
int r = SqlDB.ExecuteNonQuery(sql);
if (r == 1)
{
return(true);
}
else
{
return(false);
}
}
//重命名
public bool renamePhoto(Photo p)
{
string sql = string.Format("Update FFTX_Photo set photo_src = '{0}' where photo_id = {1}", p.Photo_Src, p.Photo_Id);
int result = SqlDB.ExecuteNonQuery(sql);
if (result == 1)
{
return(true);
}
else
{
return(false);
}
}
public bool blockUser(UserRequest ur)
{
string sql = string.Format("update FFTX_Admin_Request set request_state = 1 where user_id = {0}", ur.User_Id);
int result = SqlDB.ExecuteNonQuery(sql);
if (result == 1)
{
return(true);
}
else
{
return(false);
}
}
public bool decOneInGroupNum(Friend f)
{
//用户所在组 数量+1
string sql = string.Format("update FFTX_Group_to_Friend set group_friend_num = (group_friend_num-1) where user_id ='{0}',group_id={1}", f.User_Id, f.Group_Id);
int result = SqlDB.ExecuteNonQuery(sql);
if (result == 1)
{
return(true);
}
else
{
return(false);
}
}
//设置相册封面
public bool changeAlbumCover(Album album)
{
string sql = string.Format("Update FFTX_Album set album_cover = '{0}' where album_id = {1}", album.Album_Cover, album.Album_Id);
int r = SqlDB.ExecuteNonQuery(sql);
//执行失败
if (r != 1)
{
return(false);
}
else
{
return(true);
}
}
/// <summary>
/// 用户注册 注册信息包括: ID 用户名 密码 密保问题 密保答案
/// </summary>
/// <param name="user">用户类</param>
/// <returns>添加成功返回1 失败返回-1</returns>
public int addUser(User user)
{
int result = -1;
string sql = string.Format("INSERT INTO FFTX_User (user_id,user_name,user_password,password_question,password_answer) VALUES ('{0}','{1}','{2}','{3}','{4}')",
user.User_Id, user.User_Name, user.User_Password, user.Password_Question, user.Password_Answer);
//判断用户ID是否存在.不存在便添加
if (!isExistUser(user))
{
result = SqlDB.ExecuteNonQuery(sql);
}
return(result);
}
public bool addCommentMail(string uid)
{
string sql = string.Format("update FFTX_Mail set comment_num = comment_num+1 where user_id = {0}",
uid);
int r = SqlDB.ExecuteNonQuery(sql);
if (r == 1)
{
return(true);
}
else
{
return(false);
}
}
public bool changePwd(User user)
{
string sql = string.Format("Update FFTX_User set user_password = '******' where user_id = '{1}'",
user.User_Password, user.User_Id);
int result = SqlDB.ExecuteNonQuery(sql);
if (result == 1)
{
return(true);
}
else
{
return(false);
}
}
//更新用户信息
public bool updateUserInfo(User user)
{
string sql = string.Format("Update FFTX_User set user_name='{0}',user_email='{1}',user_phone='{2}',user_sex='{3}' where user_id = '{4}'",
user.User_Name, user.User_Email, user.User_Phone, user.User_Sex, user.User_Id);
int result = SqlDB.ExecuteNonQuery(sql);
if (result == 1)
{
return(true);
}
else
{
return(false);
}
}
//申请解封
// 数据库添加一条信息
public bool requestDeblock(UserRequest ur)
{
string sql = string.Format("INSERT INTO FFTX_Admin_Request (user_id,request_time) VALUES ('{0}','{1}')",
ur.User_Id, ur.Request_Time);
int result = SqlDB.ExecuteNonQuery(sql);
if (result == 1)
{
return(true);
}
else
{
return(false);
}
}
//评论
public bool addComment(Comment c)
{
string sql = string.Format("INSERT INTO FFTX_Photo_Comment (comment_user_id,comment_user_name,photo_id,comment_content,reply_id,comment_time,reply_user_id,reply_user_name) VALUES ('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}')",
c.Comment_User_Id, c.Comment_Name, c.Photo_Id, c.Comment_Content, c.Reply_Id, c.Comment_Time, c.Reply_User_Id, c.Reply_User_Name);
int result = SqlDB.ExecuteNonQuery(sql);
if (result == 1)
{
return(true);
}
else
{
return(false);
}
}
//新建用户拥有站内信
public bool creatMail(Mail m)
{
string sql = string.Format("INSERT INTO FFTX_Mail (user_id) VALUES ('{0}')",
m.User_Id);
int r = SqlDB.ExecuteNonQuery(sql);
if (r == 1)
{
return(true);
}
else
{
return(false);
}
}
//添加留言
public bool addMessage(Message m)
{
string sql = string.Format("Insert into FFTX_BoardMessage (message_content,message_time,message_friend_id,message_reply_id,message_user_id,message_user_name) values('{0}','{1}','{2}',{3},'{4}','{5}')",
m.Message_Content, m.Message_Time, m.Message_Friend_Id, m.Message_Reply_Id, m.Message_User_Id, m.Message_User_Name);
int r = SqlDB.ExecuteNonQuery(sql);
if (r == 1)
{
return(true);
}
else
{
return(false);
}
}
//上传照片
public bool uploadPhoto(Photo p)
{
string sql = string.Format("INSERT INTO FFTX_Photo (photo_src,photo_time,album_id,photo_label) VALUES ('{0}','{1}','{2}','{3}')",
p.Photo_Src, p.Photo_Time, p.album_id, p.Photo_Label);
//在Photo表中添加一条信息
int result = SqlDB.ExecuteNonQuery(sql);
if (result == 1)
{
return(true);
}
else
{
return(false);
}
}
public bool deleteGroup(Group g)
{
//删除分组
string sql = string.Format("DELETE FROM FFTX_Friend WHERE group_id='{0}'", g.Group_Id);
int result = SqlDB.ExecuteNonQuery(sql);
string a = string.Format("delete from FFTX_Group_to_Friend where user_id='{0}' and group_id='{1}'", g.User_Id, g.Group_Id);
int b = SqlDB.ExecuteNonQuery(a);
if (result == 1 && b == 1)
{
return(true);
}
else
{
return(false);
}
}
//删除好友
public int deleteFriend(Friend f)
{
//删除好友
string sql = string.Format("DELETE FROM FFTX_Friend WHERE user_id={0} AND follow_id={1}", f.User_Id, f.Follow_Id);
int result = SqlDB.ExecuteNonQuery(sql);
//用户 粉丝 与 关注数变化
//好友所在分组总数 -1
if (result == 1 && new GroupSql().decOneInGroupNum(f) && new UserSql().changeUserFans(f.Follow_Id, "dec") && new UserSql().changeUserFollow(f.User_Id, "dec"))
{
return(1);
}
else
{
return(0);
}
}
/// <summary>
/// 添加 group_name 和group_id对应信息
/// </summary>
/// <param name="group">需要group_name字段</param>
/// <returns>添加成功返回true 并获取group_id</returns>
public bool addGroupInfo(Group group)
{
//在 Group表中 添加 ID 和 组名对应信息
if (!searchGroupInfo(group))
{
string sql = string.Format("Insert Into FFTX_Group(group_name) VALUES('{0}')", group.Group_Name);
int result = SqlDB.ExecuteNonQuery(sql);
if (result == 1) //添加对应信息成功
{
return(searchGroupInfo(group)); //获取group id是否成功
}
else
{
return(false);
}
}
//在Group to User表中 为用户添加相应分组
return(true);
}
//删除相册 path: Request.MapPath("~s");
public bool deleteAlbum(Album album, string path)
{
//查询相册中所包含的 photo id
string sql = string.Format("select photo_id from FFTX_Photo where album_id = '{0}'", album.Album_Id);
SqlDataReader sqldr = SqlDB.ExecuteReader(sql);
if (sqldr != null && sqldr.HasRows)
{
while (sqldr.Read())
{
//删除photo
deletePhoto(sqldr.GetInt32(0), path);
}
}
string sql2 = string.Format("delete from FFTX_Album where album_id = {0}", album.Album_Id);
int result = SqlDB.ExecuteNonQuery(sql2);
if (result == 1)
{
return(true);
}
return(false);
}
//删除
public bool deletePhoto(Photo p)
{
string sql = string.Format("delete from FFTX_Photo where photo_id = {0}", p.Photo_Id);
int result = SqlDB.ExecuteNonQuery(sql);
if (result == 1)
{
string sql1 = string.Format("delete from FFTX_Photo_Comment where photo_id = {0}", p.Photo_Id);
string sql2 = string.Format("delete from FFTX_Photo_Like where photo_id = {0}", p.Photo_Id);
string sql3 = string.Format("delete from FFTX_Photo_Share where photo_id = {0}", p.Photo_Id);
SqlDB.ExecuteNonQuery(sql1);
SqlDB.ExecuteNonQuery(sql2);
SqlDB.ExecuteNonQuery(sql3);
return(true);
}
else
{
return(false);
}
}