Joson请求后台数据维护

置顶 于 2012-11-05 22:28:47 发布
阅读量1.4k 收藏
点赞数 1
分类专栏： asp.net学习总结
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/wanglei_samrtfish/article/details/8150804
版权

A.前台页面设计

<html xmlns="http://www.w3.org/1999/xhtml">
<head>
    <title>频道管理</title>

    <script type="text/javascript" src="../JS/jquery-1.4.1.min.js"></script>

    <script type="text/javascript" src="../Common/Page.js"></script>

    <link href="../Admin_Style.css" rel="stylesheet" type="text/css" />

    <script type="text/javascript" src="../JS/jquery-impromptu.3.1.min.js"></script>

    <link href="../Css/alert.css" rel="stylesheet" type="text/css" />
    <link href="../Css/dialog.css" rel="stylesheet" type="text/css" />

    <script type="text/javascript" src="../JS/dialog.js"></script>

    <script src="../JS/Cookies.js" type="text/javascript"></script>

    <script src="../JS/CheckLogin.js" type="text/javascript"></script>

    <script src="../Common/GetRequestUrl.js" type="text/javascript"></script>

</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="添加频道"  οnclick="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">&nbsp;
               
            </td>
        </tr>
    </table>
    <div id="showPageRecord" style="width: 100%;">
    </div>
    </form>
</body>
</html>

<script type="text/javascript">
    CheckLogin("../");
    var navid = GetRequestName("navid");
    if (navid != "")
        SetCookie("navid", navid);
    url = "../Json/ChannelHandler.ashx?type=GetAll&page=";
    nameArr = ['频道名称', '添加时间'];
    lenArr = ['40%', '20%'];
    jsonNameArr = ['ChannelName', 'AddTime'];
    clickrow = [0, 0];
    coldisplay = 10; //按钮样式为，删除，修改，添加版块
    isShowCheck = 1;
    pageinit();

    $("#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() {

        var selID = selIdList();
        if (selID == "") {
            $.prompt('至少选择一项！', '系统提示', 4, { buttons: { '确定': true} });
        } else {
            reDelete(selID.substr(0, selID.length - 1));
        }
    }

    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;
        }
    }

}

 

wanglei_samrtfish
关注
专栏目录
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值