EasyShop/ashx/EditProSjState.ashx.cs

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

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using conn;
using System.Text;
using System.Data;
using FormatJosn;
using System.Data.SqlClient;

namespace EasyShop.ashx
{
    /// <summary>
    /// EditProSjState 的摘要说明
    /// </summary>
    public class EditProSjState : IHttpHandler
    {

        public void ProcessRequest(HttpContext context)
        {
            context.Response.ContentType = "text/plain";
            string ID = context.Request.QueryString["id"];
            string ProductName = context.Request.QueryString["productname"];
            string BuySellState = context.Request.QueryString["state"];
            DbConn conn = new DbConn();
            conn.open();
            StringBuilder strSql = new StringBuilder();
            strSql.Append("update  TB_MC_Product set BuySellState=@BuySellState");
            strSql.Append(" where ID=@ID");
            string mujson = "NO";
            SqlParameter[] parm = { 
                                    new SqlParameter("@ProductName",ProductName),
                                    new SqlParameter("@BuySellState",BuySellState),
                                    new SqlParameter("@ID",ID)
                                  };
            int k = ExeSql.SqlHelper.ExecuteNonQuery(ExeSql.SqlHelper.ConnectionString, strSql.ToString(), parm);
            if (k > 0)
            {
                mujson = "OK";
            }
            //string mujson = FormatToJson.ToJson(ds, "result");
            conn.close();
            context.Response.Write(mujson);
        }

        public bool IsReusable
        {
            get
            {
                return false;
            }
        }
    }
}