SPLook.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 SPLook : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!Page.IsPostBack)
        {
            DataBase.ExecSql("update 药品信息 set 人气=人气+1 where 代码 = " + Request.QueryString["spbh"].ToString());
            this.BindSPXX();

        }
    }
    protected void Imagebutton4_Click(object sender, ImageClickEventArgs e)
    {
        Session.Remove("UserID");
        Session.Remove("UserName");
        Session.Remove("PersonType");
        Response.Redirect("index.aspx");
    }


    public void BindSPXX()
    {
        DataTable tmpda = new DataTable();
        tmpda = DataBase.Get_Table("select * from 药品信息 where 代码 = " + Request.QueryString["spbh"].ToString());
        if (tmpda.Rows.Count > 0)
        {
            DataRow dr = tmpda.Rows[0];
            Image1.ImageUrl = "image/" + dr["图片"].ToString();
            Label1.Text = dr["名称"].ToString();
            Label3.Text = dr["名称"].ToString();
            Label8.Text = dr["批号"].ToString();
            Label9.Text = dr["生产日期"].ToString();
            Label6.Text = dr["价格"].ToString();
            Label10.Text = dr["库存数量"].ToString();
            this.MS.InnerHtml = dr["保质期"].ToString().Replace("\r\n", "<br>");
            DateTime d1 = Convert.ToDateTime(dr["保质期"].ToString());
            DateTime d2 = DateTime.Now; 
            TimeSpan s = d2 - d1;
            if (s.Days > 0)
            {
                this.Label11.Text = "已过保质期";
            }
            else
            {
                this.Label11.Text = "在保质期内";
            }
        }
    }