Example #1
0
        /// <summary>
        /// 用于判断一个IP是否参加过这次活动
        /// </summary>
        /// <param name="IP"></param>
        /// <returns></returns>
        public int GetRoteInfoCountByIP(int AID, String IP)
        {
            String sql = "SELECT COUNT(RU.RUID) FROM RoteUser AS RU INNER JOIN RoteInfo AS RI ON RI.RUID=RU.RUID AND RI.RIP=@RIP AND AID=@AID";

            return(Convert.ToInt32(DataBaseOpen.QueryOne(sql, new SqlParameter[] {
                new SqlParameter("@RIP", IP),
                new SqlParameter("@AID", AID)
            })));
        }
Example #2
0
        public int GetCount(int AID = 0)
        {
            String sql = "SELECT COUNT(RUID) FROM RoteUser" + (AID == 0 ? "" : " WHERE AID=" + AID);

            return(Convert.ToInt32(DataBaseOpen.QueryOne(sql)));
        }