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

        public void ProcessRequest(HttpContext context)
        {
            context.Response.ContentType = "text/plain";
            //string ID = context.Request.Params["id"].ToString();
            string Name = context.Request.Params["title"].ToString();
            string LinkUrl = context.Request.Params["linkurl"].ToString();
            string OpenTarget = context.Request.Params["target"].ToString();
            string InWebSite = context.Request.Params["zn"].ToString();
            string Sort = context.Request.Params["sort"].ToString();
            string ShowHide = context.Request.Params["show"].ToString();
            DbConn conn = new DbConn();
            conn.open();
            StringBuilder strSql = new StringBuilder();
            strSql.Append("insert into TB_MC_WebNavMenu(Name, LinkUrl, OpenTarget, InWebSite, Sort, ShowHide, addtime) values (@Name, @LinkUrl, @OpenTarget, @InWebSite, @Sort, @ShowHide, @addtime)");
            //strSql.Append("update  TB_MC_WebNavMenu set Name='" + Name + "', LinkUrl='" + LinkUrl + "', OpenTarget='" + OpenTarget + "', InWebSite='" + InWebSite + "', Sort=" + Sort + ", ShowHide='" + ShowHide + "', addtime='" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "'");
            //strSql.Append(" where ID=" + ID + "");
            SqlParameter[] parm = { 
                                  new SqlParameter("@Name",Name),
                                  new SqlParameter("@LinkUrl",LinkUrl),
                                  new SqlParameter("@OpenTarget",OpenTarget),
                                  new SqlParameter("@InWebSite",InWebSite),
                                  new SqlParameter("@Sort",Sort),
                                  new SqlParameter("@ShowHide",ShowHide),
                                  new SqlParameter("@addtime",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)
            {
                mujson = "add successs";
            }
            
            //string mujson = FormatToJson.ToJson(ds, "result");
            conn.close();
            context.Response.Write(mujson);
        }

        public bool IsReusable
        {
            get
            {
                return false;