//绑定朝代分类数据
protected void BindClass()
{
DataTable dt = DynBll.allDyn();
if (dt != null && dt.Rows.Count != 0)
{
dynlist.DataSource = dt;
dynlist.DataBind();
}
DataTable dt1 = ClassificationBll.allclass();
if (dt1 != null && dt1.Rows.Count != 0)
{
classlist.DataSource = dt1;
classlist.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
BindClass();
classpanel.Visible = false;
dynpanel.Visible = false;
#region 朝代进来
if (Request.QueryString["dynid"] != null)
{
dynpanel.Visible = true;
if (Request.QueryString["dynid"] == "dyn")
{
//全部数据
dyn.Text = "朝代";
iddyn = "朝代";
DataTable dt = CullService.SelectAll();
if (dt != null && dt.Rows.Count != 0)
{
cullview.DataSource = dt;
cullview.DataBind();
}
}
else
{
iddyn = Request.QueryString["dynid"].ToString();
//根据分类ID查询分类名或者朝代名
SqlDataReader dynname = DynBll.dynname(int.Parse(Request.QueryString["dynid"].ToString()));
dynname.Read();
dyn.Text = dynname["Dyn_Name"].ToString();
//根据朝代绑定前台数据
DataTable dt = CullService.SelectCullDyn(int.Parse(Request.QueryString["dynid"].ToString()));
if (dt != null && dt.Rows.Count != 0)
{
cullview.DataSource = dt;
cullview.DataBind();
}
}
}
#endregion
#region 页面内分类查询
if (Request.QueryString["class2"] != null)
{
classpanel.Visible = true;
//根据分类ID查询分类名或者朝代名
SqlDataReader classname = ClassificationBll.clssname(int.Parse(Request.QueryString["class2"].ToString()));
classname.Read();
cullclass.Text = classname["Class_Name"].ToString();
if (iddyn == "朝代")
{
dyn.Text = iddyn;
//根据朝代和分类绑定前台数据
DataTable dt2 = CullService.SelectCullClass(int.Parse(Request.QueryString["class2"]));
if (dt2 != null && dt2.Rows.Count != 0)
{
cullview.DataSource = dt2;
cullview.DataBind();
}
}
else
{
//根据分类ID查询分类名或者朝代名
SqlDataReader dynname = DynBll.dynname(int.Parse(iddyn));
dynname.Read();
dyn.Text = dynname["Dyn_Name"].ToString();
DataTable dt2 = CullService.SelectCullClassDyn(int.Parse(iddyn), int.Parse(Request.QueryString["class2"].ToString()));
if (dt2 != null && dt2.Rows.Count != 0)
{
cullview.DataSource = dt2;
cullview.DataBind();
}
}
}
#endregion
#region 分类进来
if (Request.QueryString["classid"] != null)
{
classpanel.Visible = true;
if (Request.QueryString["classid"] == "leibie")
{
cullclass.Text = "类别";
idclass = "类别";
DataTable dt = CullService.SelectAll();
if (dt != null && dt.Rows.Count != 0)
{
cullview.DataSource = dt;
cullview.DataBind();
}
}
else
{
idclass = Request.QueryString["classid"].ToString();
//根据分类ID查询分类名或者朝代名
SqlDataReader cullclassname = ClassificationBll.clssname(int.Parse(Request.QueryString["classid"].ToString()));
cullclassname.Read();
cullclass.Text = cullclassname["Class_Name"].ToString();
//根据分类绑定前台数据
DataTable dt = CullService.SelectCullClass(int.Parse(Request.QueryString["classid"].ToString()));
if (dt != null && dt.Rows.Count != 0)
{
cullview.DataSource = dt;
cullview.DataBind();
}
}
}
#endregion
#region 页面内朝代查询
if (Request.QueryString["dyn2"] != null)
{
dynpanel.Visible = true;
//根据分类ID查询分类名或者朝代名
SqlDataReader dynname = DynBll.dynname(int.Parse(Request.QueryString["dyn2"].ToString()));
dynname.Read();
dyn.Text = dynname["Dyn_Name"].ToString();
if (idclass == "类别")
{
cullclass.Text = idclass;
//根据朝代和分类绑定前台数据
DataTable dt2 = CullService.SelectCullDyn(int.Parse(Request.QueryString["dyn2"]));
if (dt2 != null && dt2.Rows.Count != 0)
{
cullview.DataSource = dt2;
cullview.DataBind();
}
}
else
{
//根据分类ID查询分类名或者朝代名
SqlDataReader cullclassname = ClassificationBll.clssname(int.Parse(idclass));
cullclassname.Read();
cullclass.Text = cullclassname["Class_Name"].ToString();
//根据朝代和分类绑定前台数据
DataTable dt2 = CullService.SelectCullClassDyn(int.Parse(Request.QueryString["dyn2"].ToString()), int.Parse(idclass));
if (dt2 != null && dt2.Rows.Count != 0)
{
cullview.DataSource = dt2;
cullview.DataBind();
}
}
}
#endregion
}
}
