saleconfirm.aspx.cs

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

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

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;
using DbPrvd;
using Common;

public partial class saleconfirm : System.Web.UI.Page
{
    string saleid = "0";
    string pid = "0";
    string quantity = "0";
    protected void Page_Load(object sender, EventArgs e)
    {
        if (Session["User"] == null || Session["Role"] == null)
            Response.Write("<script type='text/javascript'>parent.document.location='timeout.htm';</script>");
        if (Session["Role"].ToString() != "管理员")
        {
            Response.Write("<script type='text/javascript'>alert('您无权操作');history.go(-1);</script>");
        }


        if (!string.IsNullOrEmpty(Request.QueryString["id"]) && RegexHelper.isNumberR(Request.QueryString["id"]))
        {
            saleid = Request.QueryString["id"];
            BindInfo();
        }
    }
    private void BindInfo()
    {
        string Query = "select A.*,B.name from [" + SqlHelper.Tbpre + "sale] as A inner join [" + SqlHelper.Tbpre + "product] as B " +
            " on A.pid=B.sid where A.id=" + saleid;
        SqlDataReader tempReader = SqlHelper.ExecuteReader(SqlHelper.ConStr, CommandType.Text, Query);
        while (tempReader.Read())
        {
            if (tempReader["isconfirm"].ToString() == "yes")
            {
                Response.Write("<script type='text/javascript'>alert('这条数据已经审核通过');document.location='salelist.aspx';</script>");
            }
            lblID.Text = pid = tempReader["pid"].ToString();
            lblName.Text = tempReader["name"].ToString();
            lblQuantity.Text = quantity = tempReader["quantity"].ToString();
            lblPrice.Text = tempReader["price"].ToString();
            lblTotalPrice.Text = tempReader["totalprice"].ToString();
            lblRemark.Text = tempReader["remark"].ToString();
        }
    }
    protected void Button1_Click1(object sender, EventArgs e)
    {
        //库存中减去销售数量
        string updtQuery = "update [" + SqlHelper.Tbpre + "kucun] set quantity=isnull(quantity,0)-" + quantity + " where pid='" + pid + "'";
        //将销售记录设置为已审
        string confirmQuery = "update [" + SqlHelper.Tbpre + "sale] set [isconfirm]='yes' where id=" + saleid;
        if (DB.ExecuteNonQuery(updtQuery) > 0 && DB.ExecuteNonQuery(confirmQuery) > 0)
        {