Ejemplo n.º 1
0
        /// <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);
        }
Ejemplo n.º 2
0
        /// <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));
        }