asublist.aspx.cs

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;

public partial class m_asublist : System.Web.UI.Page
{
    public string ArticalType = "";

    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            bindSubType();
        }

    }

    private void bindSubType()
    {
        string atype = Request.QueryString["atype"];

        string strSql = "";
        DataTable dt = null;

        string ArticalTypeID = DES.MD5Decrypt(atype);
        strSql = "select Type,SubType from tbl_atype where ID =" + ArticalTypeID;
        dt = DB.GetTable(strSql);
        ArticalType = dt.Rows[0]["Type"].ToString();


        strSql = "select ID,Type from tbl_atype where " + toWhere(dt.Rows[0]["SubType"].ToString()) + " order by ID";
        dt = DB.GetTable(strSql);
        repeatAsublist.DataSource = dt;
        repeatAsublist.DataBind();


    }

    private string toWhere(string con)
    {
        string[] arr = con.Split(new char[] { ',' });
        string ret = "";
        foreach (string str in arr)
        {
            ret += "ID=" + str + " or ";
        }

        return ret.Remove(ret.Length - 4);
    }

}