C# JpCommon.queryString2StrID方法代码示例

    protected void Page_Load(object sender, EventArgs e)
    {
        TPortalClass.JpCommon JpCommon = new TPortalClass.JpCommon();
        if (this.Request.QueryString["cid"] != null)
            this.cid = JpCommon.queryString2StrID(this.Request.QueryString["cid"].ToString(), 9);
        if (this.Request.QueryString["aid"] != null)
            this.aid = JpCommon.queryString2StrID(this.Request.QueryString["aid"].ToString(), 9);

        if (!this.IsPostBack)
        {
            this.txtDocid.Value = System.Guid.NewGuid().ToString();
        }
        DataPlay();
    }

    protected void Page_Load(object sender, EventArgs e)
    {
        //获取参数
        string ls_aid = "", ls_cid = "", ls_page = "1", ls_pagesize = "10";
        JpCommon JpCommon = new JpCommon();
        if (this.Request.QueryString["cid"] != null)
            ls_cid = JpCommon.queryString2StrID(this.Request.QueryString["cid"].ToString(), 9);
        if (this.Request.QueryString["aid"] != null)
            ls_aid = JpCommon.queryString2StrID(this.Request.QueryString["aid"].ToString(), 9);

        if (this.Request.QueryString["page"] != null)
            ls_page = JpCommon.queryString2StrID(this.Request.QueryString["page"].ToString(), 9);
        if (this.Request.QueryString["pagesize"] != null)
            ls_pagesize = JpCommon.queryString2StrID(this.Request.QueryString["pagesize"].ToString(), 9);

        TPortalClass.JpComment JpComment = new TPortalClass.JpComment();
        TPortalClass.JpUserVip JpUserVip = new TPortalClass.JpUserVip();
        DataTable dt = JpComment.Getdocsbyaid_ysh_fy(ls_aid, ls_cid, Convert.ToInt32(ls_page), Convert.ToInt32(ls_pagesize));
        DataTable tempTable = dt.Clone();
        DataColumn col1 = new DataColumn("rytx", typeof(String));
        DataColumn col2 = new DataColumn("showTime", typeof(String));
        tempTable.Columns.Add(col1);
        tempTable.Columns.Add(col2);
        for (int i = 0; i < dt.Rows.Count; i++)
        {
            DataRow dr = tempTable.NewRow();
            string ls_user = dt.Rows[i]["usid"].ToString();
            DataTable dtrytx = JpUserVip.GetJpUserPic(ls_user);
            if (dtrytx.Rows.Count > 0)
            {
                dr["rytx"] = dtrytx.Rows[0]["hy_pic"].ToString();
            }
            else
            {
                dr["rytx"] = "images/1211p1.png";
            }
            dr["showTime"] = JpCommon.DateDiff(DateTime.Now, Convert.ToDateTime(dt.Rows[i]["commenttime"].ToString()));
            for (int j = 0; j < dt.Columns.Count; j++)
            {
                dr[dt.Columns[j].ColumnName] = dt.Rows[i][j];
            }
            tempTable.Rows.Add(dr);
        }
        //转换成json格式
        string strJson = JsonConvert.SerializeObject(tempTable);
        //数据抛出
        Response.Write(strJson);
    }

    private void RptBind()
    {
        TPortalClass.JpCommon JpCommon2 = new TPortalClass.JpCommon();
        if (this.Request.QueryString["cid"] != null)
            this.pis_cid = JpCommon2.queryString2StrID(this.Request.QueryString["cid"].ToString(), 9);

        TPortalClass.JpArticle JpArticle = new TPortalClass.JpArticle();
        string ls_where = " and cid like '" + pis_cid + "%' ";
        string ls_order = " order by pubtime desc";
        DataTable dt = JpArticle.SearchdocsByKey(ls_where, ls_order, 1, 3);
        DataTable tempTable = dt.Clone();
        //在现有的DatatTable增加一列
        DataColumn col = new DataColumn("showTime", typeof(String));
        //将列添加到DataTable中去
        tempTable.Columns.Add(col);
        //循环  对DataTable重新赋值
        for (int i = 0; i < dt.Rows.Count; i++)
        {
            DataRow dr = tempTable.NewRow();
            for (int j = 0; j < dt.Columns.Count; j++)
            {
                dr[tempTable.Columns[j].ColumnName] = dt.Rows[i][j];
            }
            //获得间隔的时间
            dr["showTime"] = JpCommon.DateDiff(DateTime.Now, Convert.ToDateTime(dt.Rows[i]["crtime"].ToString()));
            tempTable.Rows.Add(dr);
        }
        rptList.DataSource = tempTable;
        rptList.DataBind();
        this.pis_totalCount = JpArticle.SearchdocsByKeyNum(ls_where);
    }

 protected void Page_Load(object sender, EventArgs e)
 {
     TPortalClass.JpCommon JpCommon = new TPortalClass.JpCommon();
     if (this.Request.QueryString["cid"] != null)
         this.pis_cid = JpCommon.queryString2StrID(this.Request.QueryString["cid"].ToString(), 9);
     string ls_where = " and cid like '" + pis_cid + "%' and sfzwd='否' ";
     TPortalClass.JpArticle JpArticle = new TPortalClass.JpArticle();
     this.pis_totalCount = JpArticle.SearchdocsByKeyNum(ls_where);
 }

    protected void Page_Load(object sender, EventArgs e)
    {
        string ls_cid = "", ls_page = "1", la_pagesize = "10";
        TPortalClass.JpCommon JpCommon = new TPortalClass.JpCommon();
        if (this.Request.QueryString["cid"] != null)
        {
            ls_cid = JpCommon.queryString2StrID(this.Request.QueryString["cid"].ToString(), 9);
        }
        if (this.Request.QueryString["page"] != null)
        {
            ls_page = JpCommon.Filter(this.Request.QueryString["page"].ToString());
        }
        if (this.Request.QueryString["pagesize"] != null)
        {
            la_pagesize = JpCommon.Filter(this.Request.QueryString["pagesize"].ToString());
        }
        //根据传入的文章栏目ID、页码、页数返回列表信息
        TPortalClass.JpArticle JpArticle = new TPortalClass.JpArticle();
        string ls_where = "", ls_order = "";
        ls_where = " and cid like '" + ls_cid + "%' and sfzwd='否' ";
        ls_order = " order by pubtime desc";
        DataTable dt = JpArticle.SearchdocsByKey(ls_where, ls_order, int.Parse(ls_page), int.Parse(la_pagesize));
        //复制一个DataTalbe
        DataTable tempTable = dt.Clone();
        //在现有的DatatTable增加一列
        DataColumn col = new DataColumn("showTime", typeof(String));
        //将列添加到DataTable中去
        tempTable.Columns.Add(col);

        //在现有的DatatTable增加一列
        DataColumn col2 = new DataColumn("commentCount", typeof(String));
        //将列添加到DataTable中去
        tempTable.Columns.Add(col2);

        int commentCount = 0;
        JpComment jpComment = new JpComment();
        //循环  对DataTable重新赋值
        for (int i = 0; i < dt.Rows.Count; i++)
        {
            DataRow dr = tempTable.NewRow();
            for (int j = 0; j < dt.Columns.Count; j++)
            {
                dr[tempTable.Columns[j].ColumnName] = dt.Rows[i][j];
            }
            DataTable dtComment = jpComment.Getdocsbyaid_ysh(ls_cid, dt.Rows[i]["aid"].ToString());
            commentCount = dtComment.Rows.Count;
            //获得间隔的时间
            dr["showTime"] = JpCommon.DateDiff(DateTime.Now, Convert.ToDateTime(dt.Rows[i]["crtime"].ToString()));
            dr["commentCount"] = commentCount;
            tempTable.Rows.Add(dr);
        }
        //转换成json格式
        string strJson = JsonConvert.SerializeObject(tempTable);
        //数据抛出
        Response.Write(strJson);
    }

 protected void Page_Load(object sender, EventArgs e)
 {
     JpCommon JpCommon = new JpCommon();
     if (this.Request.QueryString["cid"] != null)
     {
         this.txtcid.Value = this.Request.QueryString["cid"].ToString();
         this.pis_cid = JpCommon.queryString2StrID(this.Request.QueryString["cid"].ToString(), 9);
     }
     string ls_where = " and cid = '" + this.txtcid.Value + "'  and sfzwd='是'";
     JpArticle JpArticle = new JpArticle();
     this.pis_totalCount = JpArticle.SearchdocsByKeyNum(ls_where);
 }

    private void RptBind()
    {
        TPortalClass.JpCommon JpCommon = new TPortalClass.JpCommon();
        if (this.Request.QueryString["cid"] != null)
            this.pis_cid = JpCommon.queryString2StrID(this.Request.QueryString["cid"].ToString(),9);

        TPortalClass.JpArticle JpArticle = new TPortalClass.JpArticle();
        string ls_where = " and cid like '" + pis_cid + "%' ";
        string ls_order = " order by pubtime desc";
        DataTable dt = JpArticle.SearchdocsByKey(ls_where, ls_order, 1, 4);
        rptList.DataSource = dt;
        rptList.DataBind();
        this.pis_totalCount = JpArticle.SearchdocsByKeyNum(ls_where);
    }

    public String RptBind()
    {
        StringBuilder stringBuilder = new StringBuilder();
        JpCommon JpCommon = new JpCommon();
        if (this.Request.QueryString["aid"] != null)
        {
            this.pis_aid = JpCommon.queryString2StrID(this.Request.QueryString["aid"].ToString(), 9);
        }

        JpArticle JpArticle = new JpArticle();
        DataTable dt = JpArticle.GetArticleByaid(int.Parse(pis_aid));
        if (dt.Rows.Count > 0)
        {
            pis_cid = dt.Rows[0]["cid"].ToString();
            this.lbljptx.Text = "<h1>\"" + dt.Rows[0]["title"].ToString() + "\"</h1><span><img src=\"" + dt.Rows[0]["indexdisplaypicpath"].ToString() + "\"></span>";
        }

        string ls_where = " and cid = '" + pis_cid + "' and zwdid=" + pis_aid + " and sfzwd='否' ";
        string ls_order = " order by pubtime desc";
        DataTable dt2 = JpArticle.SearchdocsByKey(ls_where, ls_order, 1, 5);
        string strTitle = "";
        if (dt2.Rows.Count > 0)
        {
            for (int i = 0; i < dt2.Rows.Count; i++)
            {
                strTitle = dt2.Rows[i]["title"].ToString();
                if (strTitle.Length > 18)
                {
                    strTitle = strTitle.Substring(0, 18) + "...";
                }
                stringBuilder.Append("<a onclick=\"locationDetail('art_detail.aspx?aid=" + dt2.Rows[i]["aid"].ToString() + "','" + locationType + "','0')\"><li>");
                if (dt2.Rows[i]["indexdisplaypicpath"].ToString() != "")
                {
                    stringBuilder.Append("<img src=\"" + dt2.Rows[i]["indexdisplaypicpath"].ToString() + "\">");
                }
                else
                {
                    stringBuilder.Append("<img src=\"/images/noImg.jpg\">");
                }
                stringBuilder.Append("<h1>");
                stringBuilder.Append("" + strTitle + "</h1><p class=\"fleft\">" + JpCommon.DateDiff(DateTime.Now, Convert.ToDateTime(dt2.Rows[i]["crtime"].ToString())) + "</p></li></a>");
            }
        }

        return stringBuilder.ToString();
    }

    protected void Page_Load(object sender, EventArgs e)
    {
        //获取参数
        string ls_aid = "", ls_cid = "", ls_page = "1", ls_pagesize = "10";
        JpCommon JpCommon = new JpCommon();
        if (this.Request.QueryString["cid"] != null)
            ls_cid = JpCommon.queryString2StrID(this.Request.QueryString["cid"].ToString(), 9);
        if (this.Request.QueryString["aid"] != null)
            ls_aid = JpCommon.queryString2StrID(this.Request.QueryString["aid"].ToString(), 9);

        if (this.Request.QueryString["page"] != null)
            ls_page = JpCommon.queryString2StrID(this.Request.QueryString["page"].ToString(), 9);
        if (this.Request.QueryString["pagesize"] != null)
            ls_pagesize = JpCommon.queryString2StrID(this.Request.QueryString["pagesize"].ToString(), 9);

        StringBuilder stringBuilder = new StringBuilder();
        JpArticle JpArticle = new JpArticle();
        string ls_where = " and cid = '" + ls_cid + "' ";
        string ls_order = " order by pubtime desc";
        DataTable dt = JpArticle.SearchdocsByKey(ls_where, ls_order, Convert.ToInt32(ls_page), Convert.ToInt32(ls_pagesize));
        JpColumns jpColumns = new JpColumns();
        string strColumnName = "";
        stringBuilder.Append("[");
        if (dt.Rows.Count > 0)
        {
            for (int i = 0; i < dt.Rows.Count; i++)
            {
                DataTable dt_columns = jpColumns.GetColumnBycid(dt.Rows[i]["cid"].ToString());
                if (dt_columns.Rows.Count > 0)
                {
                    strColumnName = dt_columns.Rows[0]["cname"].ToString();
                }
                string ls_zwdid = dt.Rows[i]["aid"].ToString();
                stringBuilder.Append("{\"aid\":\"" + dt.Rows[i]["aid"].ToString() + "\",\"cid\":\"" + dt.Rows[i]["cid"].ToString() + "\",\"cname\":\"" + strColumnName + "\",\"indexdisplaypicpath\":\"" + dt.Rows[i]["indexdisplaypicpath"].ToString() + "\",\"title\":\"" + dt.Rows[i]["title"].ToString() + "\",\"showTime\":\"" + JpCommon.DateDiff(DateTime.Now, Convert.ToDateTime(dt.Rows[i]["crtime"].ToString())) + "\",\"child\":[");
                string ls_where2 = " and cid = '" + ls_cid + "' and zwdid='" + ls_zwdid + "' and sfzwd='否' ";
                string ls_order2 = " order by pubtime desc";
                DataTable dt_zwd = JpArticle.SearchdocsByKey(ls_where2, ls_order2, Convert.ToInt32(ls_page), Convert.ToInt32(ls_pagesize));
                if (dt_zwd.Rows.Count > 0)
                {
                    for (int j = 0; j < dt_zwd.Rows.Count; j++)
                    {
                        stringBuilder.Append("{\"aid\":\"" + dt_zwd.Rows[j]["aid"].ToString() + "\",\"cid\":\"" + dt.Rows[i]["cid"].ToString() + "\",\"cname\":\"" + strColumnName + "\",\"indexdisplaypicpath\":\"" + dt_zwd.Rows[j]["indexdisplaypicpath"].ToString() + "\",\"map_cid\":\"" + dt_zwd.Rows[j]["map_cid"].ToString() + "\",\"title\":\"" + dt_zwd.Rows[j]["title"].ToString() + "\",\"showTime\":\"" + JpCommon.DateDiff(DateTime.Now, Convert.ToDateTime(dt_zwd.Rows[j]["crtime"].ToString())) + "\"");
                        if (j == dt_zwd.Rows.Count - 1)
                        {
                            stringBuilder.Append("}");
                        }
                        else
                        {
                            stringBuilder.Append("},");
                        }
                    }
                }
                stringBuilder.Append("]");
                if (dt.Rows.Count - 1 == i)
                {
                    stringBuilder.Append("}");
                }
                else
                {
                    stringBuilder.Append("},");
                }

            }
        }
        stringBuilder.Append("]");
        //数据抛出
        Response.Write(stringBuilder.ToString());
    }