EasyShop/ashx/EditProState.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>
    /// EditProState 的摘要说明
    /// </summary>
    public class EditProState : IHttpHandler
    {

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

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