Example #1
0
    private string getCondPlayerScore(ParamMemberInfo p, GMUser user)
    {
        string cond;

        if (p.isSearchAll()) // 搜索所有的
        {
            string createCode = "";
            if (string.IsNullOrEmpty(p.m_creator))
            {
                createCode = ItemHelp.getCreateCodeSpecial(user);
            }
            else
            {
                createCode = ItemHelp.getCreateCode(p.m_creator, user);
            }

            cond = string.Format(" opSrcCreateCode like '{0}%'  ", createCode);
        }
        else // 直接下级
        {
            if (string.IsNullOrEmpty(p.m_creator))
            {
                cond = string.Format(" opSrc='{0}' ", getAccountSpecial(user));
            }
            else
            {
                cond = string.Format(" opSrc='{0}' and opSrcCreateCode like '{1}%' ", p.m_creator,
                                     ItemHelp.getCreateCodeSpecial(user));
            }
        }
        return(cond);
    }
Example #2
0
    // 返回条件
    protected override string getCondition(ParamMemberInfo p, GMUser user)
    {
        string cond = "";

        if (p.isSearchAll()) // 搜索所有的下级代理下下级代理...所创建的玩家的输赢情况
        {
            string createCode = "";
            string parent     = null;
            if (string.IsNullOrEmpty(p.m_creator))
            {
                createCode = ItemHelp.getCreateCodeSpecial(user);
                parent     = user.m_user;
            }
            else
            {
                createCode = ItemHelp.getCreateCode(p.m_creator, user);
                parent     = p.m_creator;
            }

            if (p.isIncludeDirectlyPlayer())
            {
                cond = string.Format(" playerCreateCode like '{0}%'  ", createCode);
            }
            else
            {
                cond = string.Format(" playerCreateCode like '{0}%' and playerCreator<>'{1}' ", createCode, parent);
            }
        }
        else // 直属会员
        {
            if (string.IsNullOrEmpty(p.m_creator))
            {
                cond = string.Format(" playerCreator='{0}' ", getAccountSpecial(user));
            }
            else
            {
                cond = string.Format(" playerCreator='{0}' and playerCreateCode like '{1}%' ", p.m_creator,
                                     ItemHelp.getCreateCodeSpecial(user));
            }
        }
        return(cond);
    }
Example #3
0
    private string getCondGm(ParamMemberInfo p, GMUser user)
    {
        string cond      = "";
        string parentAcc = "";
        int    depth     = 0;

        if (p.isSearchAll()) // 搜索所有的
        {
            string createCode = "";
            if (string.IsNullOrEmpty(p.m_creator))
            {
                createCode = ItemHelp.getCreateCodeSpecial(user);
                parentAcc  = getAccountSpecial(user);
            }
            else
            {
                createCode = ItemHelp.getCreateCode(p.m_creator, user);
                parentAcc  = p.m_creator;
            }

            if (p.m_subAcc == 2) // 只搜索子账号
            {
                cond = string.Format(" createCode like '{0}%' and  depth={1} ",
                                     createCode, user.m_depth);
            }
            else
            {
                cond = string.Format(" createCode like '{0}%' and  depth>{1} ", createCode, user.m_depth);
            }

            /* if (p.m_subAcc == 1) // 不包括子账号
             * {
             *   cond = string.Format(" createCode like '{0}%' and  acc<>'{1}' and accType<>{2} ",
             *       createCode, parentAcc, AccType.ACC_AGENCY_SUB);
             * }
             * else if (p.m_subAcc == 2) // 只搜索子账号
             * {
             *   cond = string.Format(" createCode like '{0}%' and  acc<>'{1}' and accType={2} ",
             *       createCode, parentAcc, AccType.ACC_AGENCY_SUB);
             * }
             * else
             * {
             *   cond = string.Format(" createCode like '{0}%' and  acc<>'{1}' ", createCode, parentAcc);
             * }*/
        }
        else // 直接下级
        {
            if (string.IsNullOrEmpty(p.m_creator))
            {
                cond  = string.Format(" owner='{0}' ", getAccountSpecial(user));
                depth = user.m_depth;
            }
            else
            {
                cond = string.Format(" owner='{0}' and createCode like '{1}%' ", p.m_creator,
                                     ItemHelp.getCreateCodeSpecial(user));

                depth = p.m_creatorDepth;
            }

            if (p.m_subAcc == 2) // 只搜索子账号
            {
                // cond += string.Format("  and accType={0} ", AccType.ACC_AGENCY_SUB);
                cond += string.Format("  and depth={0} ", depth);
            }
            else
            {
                // cond += string.Format("  and depth>{0} ", depth);
                cond += string.Format("  and accType<>{0} and accType<>{1} and accType<>{2} ",
                                      AccType.ACC_AGENCY_SUB,
                                      AccType.ACC_API_ADMIN,
                                      AccType.ACC_SUPER_ADMIN_SUB);
            }

            /*if (p.m_subAcc == 1) // 不包括子账号
             * {
             *  cond += string.Format("  and accType<>{0} ", AccType.ACC_AGENCY_SUB);
             * }
             * else if (p.m_subAcc == 2) // 只搜索子账号
             * {
             *  cond += string.Format("  and accType={0} ", AccType.ACC_AGENCY_SUB);
             * }*/
        }

        return(cond);
    }