예제 #1
0
파일: PostDao.cs 프로젝트: huchao007/bbsmax
        public override void CreateThreadManageLog(int userID, string username, string realname, string ipAddress, ModeratorCenterAction actionType
            , IEnumerable<int> postUserIDs
            , int forumID, IEnumerable<int> threadIDs, IEnumerable<string> subjects, string reason, bool isPublic, out string threadLog)
        {
            using (SqlQuery query = new SqlQuery())
            {
                query.CommandText = "bx_v5_CreateThreadManageLog";
                query.CommandType = CommandType.StoredProcedure;

                query.CreateParameter<int>("@UserID", userID, SqlDbType.Int);
                query.CreateParameter<string>("@NickName", realname, SqlDbType.NVarChar, 64);
                query.CreateParameter<string>("@UserName", username, SqlDbType.NVarChar, 64);
                query.CreateParameter<string>("@IPAddress", ipAddress, SqlDbType.VarChar, 15);
                query.CreateParameter<string>("@PostUserIDs", StringUtil.Join(postUserIDs), SqlDbType.VarChar, 8000);
                query.CreateParameter<int>("@ActionType", (int)actionType, SqlDbType.TinyInt);
                query.CreateParameter<int>("@ForumID", forumID, SqlDbType.Int);
                query.CreateParameter<string>("@ThreadIDs", StringUtil.Join(threadIDs), SqlDbType.VarChar, 8000);
                query.CreateParameter<string>("@ThreadSubjects", StringUtil.Join(subjects), SqlDbType.NText);
                query.CreateParameter<string>("@Reason", reason, SqlDbType.NVarChar, 256);
                query.CreateParameter<bool>("@IsPublic", isPublic, SqlDbType.Bit);

                threadLog = null;
                using (XSqlDataReader reader = query.ExecuteReader())
                {
                    while (reader.Read())
                    {
                        threadLog = reader.Get<string>(0);
                    }
                }
            }
        }
예제 #2
0
파일: PostDao.cs 프로젝트: zhangbo27/bbsmax
 public abstract void CreateThreadManageLog(int userID, string username, string realname, string ipAddress, ModeratorCenterAction actionType
                                            , IEnumerable <int> postUserIDs
                                            , int forumID, IEnumerable <int> threadIDs, IEnumerable <string> subjects, string reason, bool isPublic, out string threadLog);