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

        public void ProcessRequest(HttpContext context)
        {
            //id,sort,classname,kfqq,kfname
            context.Response.ContentType = "text/plain";
            string ID = context.Request.Params["id"].ToString();
            string kfName = context.Request.Params["kfname"].ToString();
            string kfQQ = context.Request.Params["kfqq"].ToString();
            string ClassName = context.Request.Params["classname"].ToString();
            string Sort = context.Request.Params["sort"].ToString();
            DbConn conn = new DbConn();
            conn.open();
            StringBuilder strSql = new StringBuilder();
            strSql.Append("update  TB_MC_KfOnline set kfName=@kfName, kfQQ=@kfQQ, ClassName=@ClassName, Sort=@Sort,addtime=@addtime");
            strSql.Append(" where ID=@ID");
            SqlParameter[] parm = {
                                  new SqlParameter("@kfName",kfName),
                                  new SqlParameter("@kfQQ",kfQQ),
                                  new SqlParameter("@ClassName",ClassName),
                                  new SqlParameter("@Sort",Sort),
                                  new SqlParameter("@addtime",DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")),
                                  new SqlParameter("@ID",ID)
                                  };
            int k = ExeSql.SqlHelper.ExecuteNonQuery(ExeSql.SqlHelper.ConnectionString, strSql.ToString(), parm);
            string mujson = "";
            if (k > 0)
            {
                mujson = "update successs";
            }
            //string mujson = FormatToJson.ToJson(ds, "result");
            conn.close();
            context.Response.Write(mujson);
        }

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