WebUI/Allot/allotview.aspx.cs

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

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

namespace hyst.Allot
{
    using DBUtility;
    using Model;
    using System;
    using System.Data;
    using System.Web.UI;
    using System.Web.UI.HtmlControls;
    using System.Web.UI.WebControls;

    public class allotview : Page
    {
        protected Button btnCal;
        protected Button btnSave;
        protected Button btnShou;
        protected HtmlForm form1;
        protected HtmlHead Head1;
        protected HtmlInputHidden txtaid;
        protected HtmlInputHidden txttype;

        protected void btnCal_Click(object sender, EventArgs e)
        {
            string msg = "";
            string aid = this.txtaid.Value;
            BaseClass bc = new BaseClass();
            msg = "1";
            string sql = "SELECT a2.*,c.cCount kCount,c.cCount-a2.lCount tCount,a.aOutShopnum,a.aIntoShopnum,c.cName  FROM Allot a  LEFT JOIN Allotlist a2 ON a.aNum=a2.lyNum  LEFT JOIN consumes c ON c.cNum=a2.lNum AND a.aOutShopnum=c.csNum  WHERE a.aNum='" + aid + "'";
            string sqlf = "";
            DataTable dt = bc.ReadTable(sql);
            string str = "";
            if (dt.Rows.Count > 0)
            {
                for (int i = 0; i < dt.Rows.Count; i++)
                {
                    object name1 = sqlf;
                    sqlf = string.Concat(new object[] { name1, " UPDATE consumes SET cCount = cCount+", Convert.ToDouble(dt.Rows[i]["lCount"].ToString()), " WHERE cNum='", dt.Rows[i]["lNum"].ToString(), "' AND csNum='", dt.Rows[i]["aOutShopnum"].ToString(), "'" });
                    string name3 = str;
                    str = name3 + "商品编号：" + dt.Rows[i]["lNum"].ToString() + ",商品名称：" + dt.Rows[i]["cName"].ToString() + ",数量：" + dt.Rows[i]["lCount"].ToString() + ",";
                }
            }
            else
            {
                msg = "2";
            }
            if (msg == "1")
            {
                try
                {
                    sqlf = sqlf + " update Allot set aStates='已撤单' where aNum='" + aid + "'";
                    bc.execsql(sqlf);
                }
                catch
                {
                    msg = "2";
                }
            }
            if (msg == "1")
            {
                this.Page.ClientScript.RegisterStartupScript(base.GetType(), "", "<script> f_alert2('warn', '撤单成功！')</script>");
            }