Exemple #1
0
        //根据状态查询游戏信息(分页列表)  _gameState:-1所有,0未开仓,1已开仓
        public DataSet GameQueryByGameState(String _gameState, int _lengthLimit, int _pageIndex, int _pageSize, out int _pageAmount)
        {
            DataSet _ds;
            int     _index = 0;

            int _intNum;

            if (!int.TryParse(_gameState, out _intNum))
            {
                _gameState = "-1";
            }

            _ds = _gameDB.GameQueryByGameState(_gameState, _pageIndex.ToString(), _pageSize.ToString(), out _pageAmount);

            if (_ds.Tables.Count != 0)
            {
                _ds.Tables[0].Columns.Add("GameStateStr", Type.GetType("System.String"));

                foreach (DataRow _dr in _ds.Tables[0].Rows)
                {
                    String _gameStateStr = _dr[5].ToString();
                    String _noHtmlStr    = remove_html_tag(_ds.Tables[0].Rows[_index][6].ToString());
                    int    _length       = _noHtmlStr.Length;

                    switch (_gameStateStr)
                    {
                    case "0": _ds.Tables[0].Rows[_index]["GameStateStr"] = "未开仓"; break;

                    case "1": _ds.Tables[0].Rows[_index]["GameStateStr"] = "已开仓"; break;
                    }

                    if (_length > _lengthLimit)
                    {
                        _noHtmlStr  = _noHtmlStr.Substring(0, _lengthLimit);
                        _noHtmlStr += "...";
                    }

                    _ds.Tables[0].Rows[_index][6] = _noHtmlStr;

                    _index++;
                }
            }

            return(_ds);
        }