EasyShop/ashx/AddProductJiFen.ashx.cs

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

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

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using conn;
using System.Text;
using System.Data;
using FormatJosn;
using OpSql;
using System.Data.SqlClient;
namespace EasyShop.ashx
{
    /// <summary>
    /// AddProductJiFen 的摘要说明
    /// </summary>
    public class AddProductJiFen : IHttpHandler
    {

        public void ProcessRequest(HttpContext context)
        {
            context.Response.ContentType = "text/plain";
            //pid, setnum, starttime, endtime
            string pid, setnum, starttime, endtime, goodscode, stocknumber, setprice;

            //pid, setnum, goodscode, stocknumber, setprice,starttime, endtime
            pid = context.Request.Params["pid"].ToString();
            setnum = context.Request.Params["setnum"].ToString();
            goodscode = context.Request.Params["goodscode"].ToString();
            stocknumber = context.Request.Params["stocknumber"].ToString();
            setprice = context.Request.Params["setprice"].ToString();
            starttime = context.Request.Params["starttime"].ToString();
            endtime = context.Request.Params["endtime"].ToString();
            int ynumber = int.Parse(stocknumber) - int.Parse(setnum);
            StringBuilder strSql = new StringBuilder();
            strSql.Append("insert into TB_MC_ProductTeam( ProID,NowPrice, GoodsCode,Type, kcNum,CreateBy,CreateDate,StartDate,EndDate,tp) values (@ProID,@NowPrice, @GoodsCode,@Type, @kcNum,@CreateBy,@CreateDate,@StartDate,@EndDate,@tp)");
            SqlParameter[] parm = { 
                                  new SqlParameter("@ProID",pid),
                                  new SqlParameter("@NowPrice",setprice),
                                  new SqlParameter("@GoodsCode",goodscode),
                                  new SqlParameter("@Type",3),
                                  new SqlParameter("@tp",3),
                                  new SqlParameter("@StartDate",starttime),
                                  new SqlParameter("@EndDate",endtime),
                                  new SqlParameter("@kcNum",setnum),
                                  new SqlParameter("@CreateBy",conn.MyCookie.getCookie("LoginUser")),
                                  new SqlParameter("@CreateDate",DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"))
                                  };
            int k = ExeSql.SqlHelper.ExecuteNonQuery(ExeSql.SqlHelper.ConnectionString, strSql.ToString(), parm);
            string mujson = "";
            if (k > 0)
            {
                StringBuilder sql = new StringBuilder();
                sql.Append("update TB_MC_Product set ProStockNumber=" + ynumber + " where GoodsCode='" + goodscode + "'");
                int k1 = ExeSql.SqlHelper.ExecuteNonQuery(ExeSql.SqlHelper.ConnectionString, sql.ToString());
                mujson = "OK";
            }
            else
            {
                mujson = "No";
            }