/// <summary> /// 确认或拒绝好友申请 /// </summary> public void SureApply(int id, ConStatus status) { B_User_Friend friBll = new B_User_Friend(); switch (status) { case ConStatus.Reject: break; case ConStatus.Audited: //通过申请,将其加为好友 M_User_FriendApply model = SelReturnModel(id); if (!friBll.IsFriend(model.UserID, model.TUserID)) { friBll.Insert(new M_User_Friend() { UserID = model.UserID, TUserID = model.TUserID, ZStatus = (int)ConStatus.Audited, FType = 0 }); } break; } DBCenter.UpdateSQL(TbName, "ZStatus=" + (int)status, "ID=" + id); }
/// <summary> /// 根据状态获取文件 /// </summary> public DataTable SelDocByStatus(ZoomLa.Model.ZLEnum.ConStatus status) { string sql = "SELECT * FROM " + strTableName + " WHERE [Status]=" + (int)status; return(SqlHelper.ExecuteTable(CommandType.Text, sql)); }