jQuery、Ajax分页

小鱼儿 2022-08-10 14:52 188阅读 0赞

## 1、效果图预览 ##

![Image 1][]

![SouthEast][]

## 2、HTML代码 ##

## 3、JS代码 ##

//加载短信模板内容-分页
    function TemplateAjax() {
        $('#TemplateTable tbody tr').remove();//清空Table tbody
        AjaxPage(1, PageSize);
    }
    
    //当前页，显示条数
    function AjaxPage(curpage, PageSize) {
        //省
        var ProvinceId = $('#MainContent_ddlsheng').val();
        //市
        var CityId = $('#MainContent_ddlshi').val();
        $.ajax({
            cache: false,
            url: "/ajaxpage/getajax.aspx?t=smsplateformtemplateajaxpage&ProvinceId=" + ProvinceId + "&CityId=" + CityId + "&CurPage=" + curpage + "&PageSize=" + PageSize + "&a=" + Math.random(),
            dataType: 'json',
            success: function (data) {
                if (data != null) {
                    var str = '';
                    for (var i in data["Data"]) {
                        var Content = data["Data"][i]["SmsTemplateContent"];
                        if (Content.length >= 60) {
                            Content = Content.substring(0, 60);
                        }
                        str += "<tr><td>" + data["Data"][i]["SmsTemplateName"] + "</td><td>" + Content + "</td><td><input type='button' value=' 删 除 ' class='btn btn-primary' οnclick='TemplateDelete(" + data["Data"][i]["Id"] + ")'/></td></tr>";
                    }
                    $('#TemplateTable tbody').html(str);
                    RecordCount = data["RecordCount"];
                    $('#pageCount').html(RecordCount);
    
                }
            }
        })
    }
    //首页、上一页、下一页、尾页点击
    function PageIndexClick(obj) {
        //当前第几页
        var CurrenPageSize = $('#CurrenPageSize').html();
        //id
        var type = $(obj).attr('id');
        //首页
        if (type == 'FirstPage') {
            CurrenPageSize = 1;
            AjaxPage(CurrenPageSize, PageSize);
            $('#CurrenPageSize').html('1');
        }
            //上一页
        else if (type == 'TopPage') {
            if (CurrenPageSize > 1) {
                CurrenPageSize = parseInt(CurrenPageSize) - 1;
            } else {
                CurrenPageSize = 1;
            }
            AjaxPage(CurrenPageSize, PageSize);
            $('#CurrenPageSize').html(CurrenPageSize);
        }
            //下一页
        else if (type == 'NextPage') {
            var size = parseInt(CurrenPageSize) + 1;
            var maxpage = RecordCount % PageSize == 0 ? parseInt(RecordCount / PageSize) : (parseInt(RecordCount / PageSize) + 1);
            if (size <= maxpage) {
                CurrenPageSize = parseInt(CurrenPageSize) + 1
            }
            AjaxPage(CurrenPageSize, PageSize);
            $('#CurrenPageSize').html(CurrenPageSize);
        }
            //尾页
        else if (type == 'LastPage') {
            CurrenPageSize = (RecordCount % PageSize == 0 ? parseInt(RecordCount / PageSize) : parseInt(RecordCount / PageSize) + 1);
            AjaxPage(CurrenPageSize, PageSize);
            $('#CurrenPageSize').html(CurrenPageSize);
        }
    }
    
    //删除模板
    function TemplateDelete(id) {
        $.ajax({
            cache: false,
            url: "/ajaxpage/getajax.aspx?t=smsplateformtemplateajaxdelete&Id=" + id + "&a=" + Math.random(),
            dataType: 'json',
            success: function (data) {
                if (data != null) {
                    alert(data['result']);
                    AjaxPage(1, PageSize);
                }
            }
        });
    }

## 4、C\#后台代码 ##

if(Request.QueryString["t"] == "smsplateformtemplateajaxpage")
                {
                    try
                    {
                        string ProvinceId = Request.QueryString["ProvinceId"];
                        string CityId = Request.QueryString["CityId"];
                        int CurPage = 1;//当前第几页
                        int.TryParse(Request.QueryString["CurPage"], out CurPage);
                        int PageSize = 5;//每页显示多少条数据
                        int.TryParse(Request.QueryString["PageSize"], out PageSize);
    
                        StringBuilder sb = new StringBuilder();
                        sb.Append(" 1=1 and (delete_flag IS NULL  OR  delete_flag=0)");
                        //省
                        if (ProvinceId != null && !string.IsNullOrEmpty(ProvinceId) && ProvinceId != "0")
                        {
                            sb.Append(string.Format(" and ProvinceId={0} ", ProvinceId.Trim()));
                        }
                        //市
                        if (!string.IsNullOrEmpty(CityId) && CityId != "0" && CityId != "null")
                        {
                            sb.Append(string.Format(" and CityId={0} ", CityId.Trim()));
                        }
                        PageArgs pageArgs = new PageArgs();
                        pageArgs.PageSize = PageSize;
                        pageArgs.PageIndex = CurPage;
                        pageArgs.TableName = "D_SMSTemplate";
                        pageArgs.PrimaryKey = "Id";
                        pageArgs.Fields = "";
                        pageArgs.Filter = sb.ToString();
                        pageArgs.Order = " create_time desc";
                        IList<SMSTemplateEntity> list = new SMSTemplateBLL().GetSMSTemplateAll(ref pageArgs);
    
                        List<Dictionary<string, object>> li = new List<Dictionary<string, object>>();
                        Dictionary<string, object> dic = new Dictionary<string, object>();
                        dic.Add("RecordCount", pageArgs.RecordCount);//总条数
                        dic.Add("Data", list);
    
                        JavaScriptSerializer serializer = new JavaScriptSerializer();
                        var result = serializer.Serialize(dic);
                        Response.Write(result);
                    }
                    catch
                    {
                        Response.Write(null);
                    }
                }

## \*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*别墅图纸推荐\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\* ##

[![Center][]][Center 1]

##     ##

我想有一栋别墅，面朝大海，春暖花开

龙兴科技别墅图纸设计，这里有最新最全的别墅图纸，

这里有最给力的别墅图纸折扣活动，图纸包括建筑图、结构图、给排水图、电气图

我们致力于为广大客户提供别墅设计图纸,图纸均由专业、经验丰富的设计团队设计，可免费提供施工技术指导

地址：[http://bstzsj.taobao.com/][Center 1]

[Image 1]: 
[SouthEast]: /images/20220810/ce36798121c44f878e9c241e8e3c8205.png
[Center]: /images/20220810/70ee96b68357469ba38d5720497d38b5.png
[Center 1]: http://bstzsj.taobao.com/