EasyShop/siteAdmin/Goods/Pup_JoinProKill.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 ExeSql;
using MyModels;
using Easy.COMMON;
using System.Text;
namespace EasyShop.siteAdmin.Goods
{
    public partial class Pup_JoinProKill : System.Web.UI.Page
    {
        public string jsString = string.Empty;
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                string ID = Common.GetMes.GetRequestQuery(Request, "id");
                TB_MC_Product tmp = new TB_MC_Product();
                tmp.ID = int.Parse(ID);
                DataSet ds = tmp.GetDataSetListByID();
                int num = ds.Tables[0].Rows.Count;
                for (int i=0; i < num; i++)
                {
                    lb_ProCode.Text = ds.Tables[0].Rows[i]["GoodsCode"].ToString();
                    lb_YlNum.Text = ds.Tables[0].Rows[i]["Stock"].ToString();
                    lb_YlPrice.Text = ds.Tables[0].Rows[i]["Price"].ToString();
                    
                }
            }
        }
        public void Save_Click(object sender, EventArgs e)
        {
            TB_MC_ProductTeam tmt = new TB_MC_ProductTeam();
            string PID = Common.GetMes.GetRequestQuery(Request, "id");
            tmt.ProID = int.Parse(PID);
            tmt.NowPrice = decimal.Parse(txt_SetPrice.Text);
            tmt.GoodsCode = lb_ProCode.Text;
            tmt.StartDate = DateTime.Parse(txt_STime.Text);
            tmt.EndDate = DateTime.Parse(txt_ETime.Text);
            tmt.kcNum = int.Parse(txt_SetNum.Text);
            int k = tmt.AddKillInfo();
            if (k > 0)
            {
                StringBuilder sql = new StringBuilder();
                int ynumber = int.Parse(lb_YlNum.Text) - int.Parse(txt_SetNum.Text);
                sql.Append("update TB_MC_Product set ProStockNumber=" + ynumber + ", Stock="+ynumber+" where GoodsCode='" + lb_ProCode.Text + "'");
                int k1 = ExeSql.SqlHelper.ExecuteNonQuery(ExeSql.SqlHelper.ConnectionString, sql.ToString());
                jsString += "alert(\"添加成功\");window.close();";
            }
            else
            {
 
            }
        }