Admin/DDSee.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 Admin_DDSee : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!Page.IsPostBack)
        {
            //根据传递的订单编号 查询 显示订单主表内容
            DataTable tmpda = new DataTable();
            tmpda = DataBase.Get_Table("select * from 订单 where 订单编号='" + Request.QueryString["ID"].ToString() + "'");
            if (tmpda.Rows.Count > 0)
            {
                this.TextBox1.Text = tmpda.Rows[0]["订单编号"].ToString();
                this.TextBox2.Text = tmpda.Rows[0]["会员帐号"].ToString();
                this.TextBox3.Text = tmpda.Rows[0]["总数量"].ToString();
                this.TextBox4.Text = tmpda.Rows[0]["总金额"].ToString();
                this.TextBox15.Text = tmpda.Rows[0]["订单日期"].ToString();
                this.TextBox6.Text = tmpda.Rows[0]["付款方式"].ToString();
            }
            //控制订单使用权限
            if (tmpda.Rows[0]["确认订单"].ToString() != "")
            {
                this.Button1.Visible = false;
            }
               //显示订单明细表内容
            tmpda = DataBase.Get_Table("select * from 订单信息,药品信息 where 订单信息.药品代码=药品信息.代码 and 订单信息.订单编号='" + Request.QueryString["Id"].ToString() + "'");
            this.GridView1.DataSource = tmpda;
            this.GridView1.DataBind();


        }
    }

    protected void Button1_Click(object sender, EventArgs e)
    {

        //确认当前的订单信息
        DataTable dt = DataBase.Get_Table("select * from 订单信息 where 订单编号='" + Request.QueryString["ID"].ToString() + "'");
        if (dt.Rows.Count > 0)
        {
            for (int i = 0; i < dt.Rows.Count; i++)
            {
                if (DataBase.Get_Table("select * from 药品信息 where 库存数量-"+dt.Rows[i]["数量"].ToString()+"<0 and 代码=" + dt.Rows[i]["药品代码"].ToString()).Rows.Count > 0)
                {
                    Page.ClientScript.RegisterStartupScript(this.GetType(), "info", "<script>alert('库存不足,不能出货！');</script>");
                    return;
                }
            }

            for (int i = 0; i < dt.Rows.Count; i++)