Пример #1
0
    private string Module_List()
    {
        string tmpstr = "";
        string tmpastr, tmprstr, tmptstr;
        int tpage = cls.getNum(request.querystring("page"));
        string tfield = cls.getSafeString(request.querystring("field"));
        string tkeyword = cls.getSafeString(request.querystring("keyword"));
        string tnav = cls.getSafeString(request.querystring("hspan"));

        tmpstr = jt.itake("manage.list", "tpl");
        tmprstr = "";
        tmpastr = cls.ctemplate(ref tmpstr, "{@}");

        string tdatabase = cls.getString(jt.itake("global.config.sys->upload-ndatabase", "cfg"));
        string tfpre = cls.getString(jt.itake("global.config.sys->upload-nfpre", "cfg"));
        string tsqlstr = "select * from " + tdatabase + " where " + cls.cfnames(tfpre, "id") + ">0";
        if (tfield == "filename") tsqlstr += " and " + cls.cfnames(tfpre, "filename") + " like '%" + tkeyword + "%'";
        if (tfield == "genre") tsqlstr += " and " + cls.cfnames(tfpre, "genre") + " like '%" + tkeyword + "%'";
        if (tfield == "valid") tsqlstr += " and " + cls.cfnames(tfpre, "valid") + "=" + cls.getNum(tkeyword);
        if (tfield == "id") tsqlstr += " and " + cls.cfnames(tfpre, "id") + "=" + cls.getNum(tkeyword);
        tsqlstr += " order by " + cls.cfnames(tfpre, "time") + " desc";

        pagi pagi;
        pagi = new pagi();
        pagi.db = db;
        pagi.sqlstr = tsqlstr;
        pagi.pagenum = tpage;
        pagi.rslimit = cls.getNum(jt.itake("config.nlisttopx", "cfg"));
        pagi.pagesize = cls.getNum(jt.itake("config.npagesize", "cfg"));
        pagi.Init();
        object[] tArys = pagi.getDataAry();
        if (tArys != null)
        {
            for (int tis = 0; tis < tArys.Length; tis++)
            {
                tmptstr = tmpastr;
                object[,] tAry = (object[,])tArys[tis];
                for (int ti = 0; ti < tAry.GetLength(0); ti++)
                {
                    tAry[ti, 0] = (object)cls.getLRStr((string)tAry[ti, 0], tfpre, "rightr");
                    tmptstr = tmptstr.Replace("{$" + cls.toString(tAry[ti, 0]) + "}", encode.htmlencode(cls.toString(tAry[ti, 1])));
                }
                string tFileType = (string)db.getValue(tAry, "filename");
                tFileType = cls.getLRStr(tFileType, ".", "right");
                tFileType = tFileType.ToLower();
                tmptstr = tmptstr.Replace("{$-filetype}", tFileType);
                tmptstr = tmptstr.Replace("{$-vlreason}", PP_GetVLReason((int)db.getValue(tAry, "valid"), (int)db.getValue(tAry, "vlreason")));
                tmprstr += tmptstr;
            }
        }
        tmpstr = tmpstr.Replace(config.jtbccinfo, tmprstr);
        tmpstr = jt.creplace(tmpstr);

        #region �������˷�ҳ
        pagi_plus pagi_plus = new pagi_plus(pagi);

        string pagerUrl = config.nuri + "?";

        if (!cls.isEmpty(tfield))
            pagerUrl += string.Format("{0}field={1}", pagerUrl.EndsWith("?") ? "" : "&", tfield);

        if (!cls.isEmpty(tkeyword))
            pagerUrl += string.Format("{0}keyword={1}", pagerUrl.EndsWith("?") ? "" : "&", tkeyword);

        if (!cls.isEmpty(tnav))
            pagerUrl += string.Format("{0}hspan={1}", pagerUrl.EndsWith("?") ? "" : "&", tnav);

        pagerUrl += pagerUrl.EndsWith("?") ? "page=[$page]" : "&page=[$page]";

        string pager = pagi_plus.pager(pagerUrl, 9);
        tmpstr = tmpstr.Replace("{$pager}", pager);
        tmpstr = tmpstr.Replace("{$page}", cls.toString(pagi.pagenum));
        #endregion

        string tmpstrp = jt.itake("manage.public", "tpl");
        tmpstr = tmpstrp.Replace("{$content}", tmpstr);
        tmpstr = jt_plus.creplace(tmpstr);

        return tmpstr;
    }
Пример #2
0
    private string Module_List()
    {
        //���ղ���
        string tgenre = cls.getSafeString(request.querystring("genre"));
        if (cls.isEmpty(tgenre)) tgenre = Sub_GetDefaultGenre();
        int tfid = cls.getNum(request.querystring("fid"), 0);
        int tpage = cls.getNum(request.querystring("page"));
        string tnav = cls.getSafeString(request.querystring("hspan"));

        //��ȡģ�������������HTML
        string tmpstr = "";
        string tmpastr, tmprstr, tmptstr;
        tmpstr = jt.itake("manage.list", "tpl");
        tmprstr = "";
        tmpastr = cls.ctemplate(ref tmpstr, "{@}");
        string tdatabase = cls.getString(jt.itake("global.config.sys->category-ndatabase", "cfg"));
        string tfpre = cls.getString(jt.itake("global.config.sys->category-nfpre", "cfg"));
        string tsqlstr = "select * from " + tdatabase + " where " + cls.cfnames(tfpre, "lng") + "=" + admin.slng + " and " + cls.cfnames(tfpre, "genre") + "='" + tgenre + "' and " + cls.cfnames(tfpre, "fid") + "=" + tfid + " order by " + cls.cfnames(tfpre, "order") + " asc";
        pagi pagi;
        pagi = new pagi();
        pagi.db = db;
        pagi.sqlstr = tsqlstr;
        pagi.pagenum = tpage;
        pagi.rslimit = cls.getNum(jt.itake("config.nlisttopx", "cfg"));
        pagi.pagesize = cls.getNum(jt.itake("config.npagesize", "cfg"));
        pagi.Init();
        object[] tArys = pagi.getDataAry();
        if (tArys != null)
        {
            for (int tis = 0; tis < tArys.Length; tis++)
            {
                tmptstr = tmpastr;
                object[,] tAry = (object[,])tArys[tis];
                for (int ti = 0; ti < tAry.GetLength(0); ti++)
                {
                    tAry[ti, 0] = (object)cls.getLRStr((string)tAry[ti, 0], tfpre, "rightr");
                    tmptstr = tmptstr.Replace("{$" + cls.toString(tAry[ti, 0]) + "}", encode.htmlencode(cls.toString(tAry[ti, 1])));
                }
                tmprstr += tmptstr;
            }
        }
        tmpstr = tmpstr.Replace(config.jtbccinfo, tmprstr);

        #region ��ҳ
        pagi_plus pagi_plus = new pagi_plus(pagi);

        string pagerUrl = config.nuri + "?";

        if (!cls.isEmpty(tgenre))
            pagerUrl += string.Format("{0}genre={1}", pagerUrl.EndsWith("?") ? "" : "&", tgenre);

        if (tfid != 0)
            pagerUrl += string.Format("{0}fid={1}", pagerUrl.EndsWith("?") ? "" : "&", tfid);

        if (!cls.isEmpty(tnav))
            pagerUrl += string.Format("{0}hspan={1}", pagerUrl.EndsWith("?") ? "" : "&", tnav);

        pagerUrl += pagerUrl.EndsWith("?") ? "page=[$page]" : "&page=[$page]";

        string pager = pagi_plus.pager(pagerUrl, 9);
        tmpstr = tmpstr.Replace("{$pager}", pager);
        tmpstr = tmpstr.Replace("{$page}", cls.toString(pagi.pagenum));
        #endregion

        tmpstr = tmpstr.Replace("{$category.FaCatHtml}", category.getFaCatHtml(jt.itake("manage.data_fa_category", "tpl"), tgenre, admin.slng, tfid));
        tmpstr = jt.creplace(tmpstr);

        string tmpstrp = jt.itake("manage.public", "tpl");
        tmpstrp = tmpstrp.Replace("{$content}", tmpstr);
        tmpstr = jt_plus.creplace(tmpstrp);
        tmpstr = tmpstr.Replace("{$selcolumn}", Sub_Selcolumn(tgenre));
        tmpstr = tmpstr.Replace("{$genre}", tgenre);
        tmpstr = tmpstr.Replace("{$fid}", tfid.ToString());

        return tmpstr;
    }