Exemplo n.º 1
0
    public void SearchData()
    {
        //查询条件
        int BlockType = PageRequest.GetInt("BlockType", 0);//限制方式 0白名单 1黑名单

        //分页

        var pageIndex = PageRequest.GetInt("pageIndex", 1) + 1;
        var pageSize  = PageRequest.GetInt("pageSize", 1);
        //字段排序
        var sortField = PageRequest.GetString("sortField");
        var sortOrder = PageRequest.GetString("sortOrder");
        var order     = "";

        if (String.IsNullOrEmpty(sortField) == false)
        {
            if (sortOrder != "desc")
            {
                sortOrder = "asc";
            }
            order = " " + sortField + " " + sortOrder;
        }
        else
        {
            order += " createtime desc";
        }
        //业务层：数据库操作

        var strWhere = "1=1";

        strWhere += " and BlockType=" + BlockType;


        var dt      = BllIpBlock.GetTable(pageSize, pageIndex, strWhere, order);
        var dataAll = MyDBUtils.DataTable2ArrayList(dt);
        var result  = new Hashtable();

        result["data"] = dataAll;
        var total = new Common().GetCount("SysIpBlock", strWhere);

        result["total"] = total;

        //JSON
        var json = PluSoft.Utils.JSON.Encode(result);

        Response.Write(json);
    }