Index.aspx.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

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

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;

public partial class Index : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!Page.IsPostBack)
        {
            if (Session["Type"] == null)
            {
                Session["Type"] = "";
            }

            this.BindSPXX();
            this.BindSPCount();
            this.BindOther();

        }
    }



    public void BindOther()
    {
        DataRQSP.DataSource = DataBase.Get_Table("select top 4 * from V_药品 order by 人气 DESC");
        DataRQSP.DataBind();
        this.DataXSPH.DataSource = DataBase.Get_Table("select top 4 * from V_销售");
        DataXSPH.DataBind();
        this.DataTJSP.DataSource = DataBase.Get_Table("select top 4 * from V_评价");
        DataTJSP.DataBind();
    }

    public void BindSPXX()
    {
        DataTable tmpda = new DataTable();
        if (Request.QueryString["spflbh"] == null)
        {
            //显示全部的药品信息
            tmpda = DataBase.Get_Table("select * from V_药品 where 分类 like '%" + Session["Type"].ToString() + "%'");
        }
        else
        {
            //显示指定类型的药品信息
            tmpda = DataBase.Get_Table("select * from V_药品 where 分类 like '%" + Session["Type"].ToString() + "%' and 类别代码=" + Request.QueryString["spflbh"].ToString());            
        }

        PagedDataSource page = new PagedDataSource();
        page.DataSource = tmpda.DefaultView;
        page.AllowPaging = true;
        page.PageSize = 8;