Joson请求后台数据维护

最新推荐文章于 2024-08-19 05:30:00 发布

原创最新推荐文章于 2024-08-19 05:30:00 发布 · 置顶 · 1.4k 阅读

0 ·

CC 4.0 BY-SA版权

asp.net学习总结专栏收录该内容

103 篇文章

订阅专栏

本文介绍了一个频道管理系统的前端页面设计与后端JSON数据处理逻辑。前端使用HTML、JavaScript等技术实现用户界面及交互功能；后端通过C#处理频道的增删改查请求，并以JSON格式返回数据。

A.前台页面设计

</head>
<body>
    <form id="form1" runat="server">
    <table width="100%" border="0" cellpadding="0" cellspacing="1" class="border" style="margin-bottom: 10px;">
        <tr>
            <td height="25" align="center" class="topbg">
                频道管理
            </td>
        </tr>
        <tr>
            <td height="25" class="bgcolor">
                <label for="txtKeyWord">
                </label>
                按频道名：
                <input name="txtKeyWord" type="text" class="border" id="txtKeyWord" />
                <input name="button" type="button" class="anniucss002" id="webSearch" value="快速查询" />
                <input name="button" type="button" class="anniucss002" style="display:none" id="btnAdd" value="添加频道" onclick="javascript:location.href='ChannelAdd.htm'" />
                【<a href="javascript:showHideSearch()">显示高级搜索</a>】
            </td>
        </tr>
    </table>
    <table width="100%" border="0" cellpadding="0" cellspacing="0" class="border" style="margin-bottom: 10px;
        display: none;" id="SearchAreaHtml">
        <tr>
            <td height="30" class="bgcolor"> 

            </td>
        </tr>
    </table>
    <div id="showPageRecord" style="width: 100%;">
    </div>
    </form>
</body>
</html>

    $("#webSearch").click(function() {
        url = "../Json/ChannelHandler.ashx?type=GetAll&ChannelName=" + escape($("#txtKeyWord").val()) + "&page=";
        pageinit();
    })
    //修改操作
    reEdit = function(id) {
        window.location.href = "ChannelUpd.htm?nid=" + id;
    }
    //删除操作
    var nid;
    reDelete = function(id) {
        nid = id;

        $.prompt('确定要删除您所选的记录吗？本操作将无法恢复！', '系统提示', 1, { buttons: { '确定': true, '取消': false }, callback: mycallbackfunc });
    }
    deleteSel = function() {

function mycallbackfunc(v, m, f) {
if (v == true) {

            $.post("../Json/ChannelHandler.ashx", { 'type': "ChannelDel", 'id': Math.random(), 'ChannelId': nid }, function(data) {
                var data1 = eval("(" + data + ")");
                if (data1.data[0]["Result"] == "1") {

                    $.prompt('频道信息删除成功！', '系统提示', 3);
                    location.href = "ChannelList.htm";
                } else {
                    $.prompt('频道信息删除失败！', '系统提示', 4);
                }
            }, "Json");

        }
    }
    //添加版块操作
    reChannelPlateAdd = function(cid) {

        location.href = "../ChannelPlate/ChannelPlateAdd.htm?ChannelId="+cid+"&id=" + Math.random() + "";
    }
reSeeNav=function(cid)
{
  location.href = "../ChannelPlate/ChannelPlateList.htm?ChannelId="+cid+"&id=" + Math.random() + "";
}
    //显示高级搜索区域
    showHideSearch = function() {
        $("#SearchAreaHtml").slideToggle("hide");
    }
</script>

B。Joson数据处理（ChannelHandler.ashx）

<%@ WebHandler Language="C#" Class="ChannelHandler" %>

using System;
using System.Web;
using Dal;
using Model;

public class ChannelHandler : IHttpHandler {
    ChannelDal advbll = new ChannelDal();
    public void ProcessRequest (HttpContext context) {
        string type = context.Request["type"].ToString();
        switch (type)
        {
            case "ChannelAdd":
                context.Response.Write(ChannelAdd()); break;
            case "GetAll":
                context.Response.Write(GetChannel()); break;
            case "ChannelDel":
                context.Response.Write(ChannelDel()); break;
            case "ChannelBind":
                context.Response.Write(ChannelBind()); break;
            case "ChannelUpd":
                context.Response.Write(ChannelUpd()); break;
            case "ChannelIsUseful":
                context.Response.Write(ChannelIsUseFul()); break;
            case"GetAllChannel":
                context.Response.Write(advbll.GetAllChannel());
                break;
            default: break;
        }
    }
    public string ChannelIsUseFul()
    {

        SQLHelper.JsonHelper json = new SQLHelper.JsonHelper();
        ChannelModel model = new ChannelModel();
        try
        {
            int channeid = int.Parse(HttpContext.Current.Request["ChannelId"].ToString().Trim());

            string strName=advbll.Exists(channeid);
            if (!string.IsNullOrEmpty(strName))
            {
                json.AddItem("Result", "1");
                json.AddItem("name",strName);
                json.ItemOk();
            }
            else
            {
                json.AddItem("Result", "-1");
                json.ItemOk();
            }
        }
        catch (Exception ex)
        {
            json.AddItem("Result", ex.Message.ToString());
            json.ItemOk();
        }
        return json.ToString();
    }
    public string ChannelUpd()
    {
        SQLHelper.JsonHelper json = new SQLHelper.JsonHelper();
        ChannelModel model = new ChannelModel();
        try
        {
            model.Id = int.Parse(HttpContext.Current.Request["nid"].ToString().Trim());
            model.ChannelName = HttpContext.Current.Server.UrlDecode(HttpContext.Current.Request["ChannelName"].ToString());
            model.ChannelTitle = HttpContext.Current.Server.UrlDecode(HttpContext.Current.Request["ChannelTitle"].ToString());
            model.ChannelKeyWords = HttpContext.Current.Server.UrlDecode(HttpContext.Current.Request["ChannelKeyWords"].ToString());
            model.ChannelDesContent = HttpContext.Current.Server.UrlDecode(HttpContext.Current.Request["ChannelDesContent"].ToString());
            model.AddTime = DateTime.Now;

            if (advbll.UpdateChannel(model))
            {
                PublicClass.AddLog("修改了名为【"+model.ChannelName+"】的频道信息！");
                json.AddItem("Result", "1");
                json.ItemOk();
            }
            else
            {
                json.AddItem("Result", "-1");
                json.ItemOk();
            }
        }
        catch (Exception ex)
        {
            json.AddItem("Result", ex.Message.ToString());
            json.ItemOk();
        }
        return json.ToString();
    }
    public string ChannelBind()
    {
        string StrWhere = "1=1";
        if (!string.IsNullOrEmpty(HttpContext.Current.Request["nid"]))
        {
            StrWhere += " and id=" + HttpContext.Current.Request["nid"].ToString().Trim() + "";
        }
        else
        {
            StrWhere += " and 1=2";
        }
        PagerModel model = new PagerModel();
        model.Page_Index = 1;
        model.Page_Size = 20;
        model.Find_RecordList = "";
        model.Filter_Condition = StrWhere;
        model.Record_Count = 0;
        model.Sign_Record = "Id";
        model.TableName = "C_Channel";
        model.Taxis_Sign = 1;
        model.TaxisField = "AddTime";
        return advbll.GetChannelJson(model);
    }
    public string ChannelDel()
    {
        SQLHelper.JsonHelper json = new SQLHelper.JsonHelper();

try
{

            if (advbll.DeleteChannel(HttpContext.Current.Request["ChannelId"].ToString()))
            {
                json.AddItem("Result", "1");
                json.ItemOk();
            }
            else
            {
                json.AddItem("Result", "-1");
                json.ItemOk();
            }
        }
        catch (Exception ex)
        {
            json.AddItem("Result", ex.Message.ToString());
            json.ItemOk();
        }
        return json.ToString();
    }
    public string GetChannel()
    {
        string StrWhere = "1=1";
        if (!string.IsNullOrEmpty(HttpContext.Current.Request["ChannelName"]))
        {
            StrWhere += " and ChannelName like '%" + HttpContext.Current.Server.UrlDecode(HttpContext.Current.Request["ChannelName"].ToString().Trim()) + "%'";
        }
        PagerModel model = new PagerModel();
        model.Page_Index = int.Parse(HttpContext.Current.Request["page"]) == 0 ? 1 : int.Parse(HttpContext.Current.Request["page"]);
        model.Page_Size = 20;
        model.Find_RecordList = "";
        model.Filter_Condition = StrWhere;
        model.Record_Count = 0;
        model.Sign_Record = "Id";
        model.TableName = "C_Channel";
        model.Taxis_Sign = 0;
        model.TaxisField = "AddTime";
        return advbll.GetChannelJson(model);
    }
    public string ChannelAdd()
    {
        SQLHelper.JsonHelper json = new SQLHelper.JsonHelper();
        ChannelModel model = new ChannelModel();
        try
        {
            model.ChannelName = HttpContext.Current.Server.UrlDecode(HttpContext.Current.Request["ChannelName"].ToString());
            model.ChannelTitle = HttpContext.Current.Server.UrlDecode(HttpContext.Current.Request["ChannelTitle"].ToString());
            model.ChannelKeyWords = HttpContext.Current.Server.UrlDecode(HttpContext.Current.Request["ChannelKeyWords"].ToString());
            model.ChannelDesContent = HttpContext.Current.Server.UrlDecode(HttpContext.Current.Request["ChannelDesContent"].ToString());
            model.AddTime = DateTime.Now;

            if (advbll.AddChannel(model))
            {
                PublicClass.AddLog("添加了一条名为【" + model.ChannelName + "】的频道信息！");
                json.AddItem("Result", "1");
                json.ItemOk();
            }
            else
            {
                json.AddItem("Result", "-1");
                json.ItemOk();
            }
        }
        catch (Exception ex)
        {
            json.AddItem("Result", ex.Message.ToString());
            json.ItemOk();
        }
        return json.ToString();
    }
    public bool IsReusable {
        get {
            return false;
        }
    }

}