show.aspx.cs

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

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

using System;
using System.Collections.Generic;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Text;
using System.Data;
using System.Data.SqlClient;


public partial class reg  : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        
        if(!IsPostBack)
        {
            
            show();
        }
    }

    /// <summary>
    /// 根据编号显示对应的信息
    /// </summary>
    protected void show()
    {
        SqlDataReader sdrques = SqlHelper.ExecuteReader("select a.*,isnull(tt,0) as tt from products a left join(select pid,sum(quantity) as tt from ordersMore group by pid) b on a.pid=b.pid where a.pid=" + Request.QueryString["id"]);
        if(sdrques.Read())
        {
            lbltitle.Text=sdrques["pname"].ToString();
            lblnid.Text=sdrques["pid"].ToString();
            lblmemo.Text=sdrques["memo"].ToString();

            if (sdrques["pic"].ToString() != "" && sdrques["pic"].ToString().Length > 3)
            {
                imgpic.ImageUrl = "uploads/" + sdrques["pic"].ToString();

                zoom1.HRef = "uploads/" + sdrques["pic"].ToString();
                zoom1.Title = lbltitle.Text;
            }
            lblprice.Text = sdrques["price"].ToString();
            lbladdtime.Text = sdrques["addtime"].ToString();
            Literal4.Text = sdrques["tt"].ToString();
            Literal2.Text= sdrques["quan"].ToString();

            if(int.Parse(Literal2.Text)==0)
            {
                Button1.Enabled = false;
                Button1.Text = "暂无库存";
            }
        }

    }


    protected void Button1_Click(object sender, EventArgs e)
    {
        if (Session["lname"] == null)
        {