JS Ajax Jquery implements page refresh-free paging and grouping, super powerful implementation-JS Tutorial-php.cn

Home

Web Front-end

JS Tutorial

JS Ajax Jquery implements page refresh-free paging and grouping, super powerful implementation

PHP中文网

May 16, 2016 pm 06:47 PM

PaginationNo refreshpage

<%@ Page language="c#" Codebehind="GroupText.aspx.cs" AutoEventWireup="false" 
Inherits="test1.GroupText" %> 
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 
4.0 Transitional//EN" > 
<HTML> 
    <HEAD> 
        <title>GroupText</title> 
        <meta 
name="GENERATOR" Content="Microsoft Visual Studio .NET 7.1"> 
        <meta name="CODE_LANGUAGE" Content="C#"> 
        <meta 
name="vs_defaultClientScript" content="JavaScript"> 
        <meta 
name="vs_targetSchema" 
content="http://schemas.microsoft.com/intellisense/ie5"> 
        <LINK 
href="css/wmh.css" href="css/wmh.css" type="text/css" rel="stylesheet"> 
        <script src="js/jquery.js" 
type="text/javascript"></script> 
        <script 
src="js/Common.js" type="text/javascript"></script> 
        <script src="js/getCommonTable.js" 
type="text/javascript"></script> 
        <script 
src="js/GroupText.js" type="text/javascript"></script> 
        <script language="javascript"><!-- 
        var ecid = 
&#39;100001&#39;; 
        var jpstr = ""; 
        var pageSize = 8; 

         
// --></script> 

    </HEAD> 
    <body MS_POSITIONING="GridLayout"> 
        <form id="Form1" 
method="post" runat="server"> 
            <div class="listDiv" 
style="height:100%; PADDING-TOP: 2px"> 
                <table 
cellSpacing="0" cellPadding="0" width="100%" border="0"> 
                    <tr class="dg_header"> 
                        <td style="BORDER-RIGHT: 1px solid; BORDER-TOP: 
1px solid; BORDER-LEFT: 1px solid; WIDTH: 10%; BORDER-BOTTOM: 1px solid; 
TEXT-ALIGN: center" >活动名称</td> 
                        <td 
style="BORDER-RIGHT: 1px solid; BORDER-TOP: 1px solid; WIDTH: 10%; 
BORDER-BOTTOM: 1px solid; TEXT-ALIGN: center">发送方</td> 
                        <td style="BORDER-RIGHT: 1px solid; BORDER-TOP: 
1px solid; WIDTH: 10%; BORDER-BOTTOM: 1px solid; TEXT-ALIGN: 
center">接收方</td> 
                        <td 
style="BORDER-RIGHT: 1px solid; BORDER-TOP: 1px solid; WIDTH: 12%; 
BORDER-BOTTOM: 1px solid; TEXT-ALIGN: center">发送时间</td> 
                        <td style="BORDER-RIGHT: 1px solid; BORDER-TOP: 
1px solid; WIDTH: 38%; BORDER-BOTTOM: 1px solid; TEXT-ALIGN: 
center">发送内容</td> 
                        <td 
style="BORDER-RIGHT: 1px solid; BORDER-TOP: 1px solid; WIDTH: 10%; 
BORDER-BOTTOM: 1px solid; TEXT-ALIGN: center">积分</td> 
                        <td style="BORDER-RIGHT: 1px solid; BORDER-TOP: 
1px solid; WIDTH: 10%; BORDER-BOTTOM: 1px solid; TEXT-ALIGN: 
center">状态</td> 
                    </tr> 
                    <tr> 
                        <td 
class="dg_line" style="BORDER-BOTTOM: 0px solid" style="BORDER-BOTTOM: 0px 
solid" vAlign="top" width="100%" colSpan="7" 
                            height="100%"> 
                            <div id="divcontent" style="WIDTH: 100%; 
HEIGHT: 100%" align="left"></div> 
                        </td> 
                    </tr> 
                    <tr> 
                        <td 
class="dg_line" style="BORDER-RIGHT: 1px solid; BORDER-TOP: 1px solid; 
BORDER-LEFT: 1px solid; BORDER-BOTTOM: 1px solid" style="BORDER-RIGHT: 1px 
solid; BORDER-TOP: 1px solid; BORDER-LEFT: 1px solid; BORDER-BOTTOM: 1px solid" 
                            width="100%" colSpan="10"> 
                            <table width="100%"> 
                                <tr> 
                                    <td class="pgtext">共<span 
id="recordcount" style="COLOR: red" style="COLOR: red">0</span>条记录    
                                        目前第<span id="curpageindex" 
style="COLOR: red" style="COLOR: red">0</span> <font 
color="red">/</font><span id="pgcount" style="COLOR: red" 
style="COLOR: red">0</span>页    
                                        <input class="pageText" 
id="gototxt" type="text" maxLength="10" name="gototxt" runat="server"> 
                                        <input id="gotopg" type="button" 
class="goBtn"></td> 
                                    <td 
align="right"><img src="/static/imghwm/default1.png"  data-src="Images/first.gif"  class="lazy"  id="btnfirst"   style="max-width:90%" style="CURSOR: hand" 
alt="首页" > 
                                        <img src="/static/imghwm/default1.png"  data-src="Images/btn_pre.gif"  class="lazy"  id="btnpre" style="CURSOR: 
hand" style="CURSOR: hand" alt="上一页"  > <img src="/static/imghwm/default1.png"  data-src="Images/btn_next.gif"  class="lazy"  
id="btnnext" style="CURSOR: hand" style="CURSOR: hand" alt="下一页"  > 
                                        <img src="/static/imghwm/default1.png"  data-src="Images/btn_last.gif"  class="lazy"  id="btnlast" style="CURSOR: 
hand" style="CURSOR: hand" alt="尾页"  > 
                                    </td> 
                                </tr> 
                            </table> 
                        </td> 
                    </tr> 
                </table> 
            </div> 
        </form> 
    </body> 
</HTML>

Common.js

Common.js: 
//时间格式化 

function getDateByFormat(oldDate){ 
                var Dy = oldDate.getFullYear(); 
                var Dm = 
oldDate.getMonth()+1; 
                var Dd = oldDate.getDate(); 
                if(Dm<10){ 
                    Dm = "0" + Dm; 
                } 
                if(Dd<10){ 
                    Dd = "0" + Dd; 
                } 
                var newDate = Dy+&#39;-&#39;+Dm+&#39;-&#39;+Dd; 

                    return newDate; 
                } 
//日期-时间格式化 
function getDateTimeByFormat(oldDate){ 
                var Dy = 
oldDate.getFullYear(); 
                var Dm = oldDate.getMonth()+1; 
                var Dd = oldDate.getDate(); 
                var Dh = 
oldDate.getHours(); 
                var Dmi = oldDate.getMinutes();   
                var Ds    = oldDate.getSeconds();    
                if(Dm<10) 
                    Dm = "0" + Dm; 
                if(Dd<10) 
                    Dd = "0" + Dd; 

                if(Dh<10) 
                 Dh = "0" + Dh; 
                if(Dmi<10) 
                    Dmi = "0" + Dmi; 
                if(Ds<10) 
                    Ds = "0" + Ds; 

                var newDate = Dy+&#39;-&#39;+Dm+&#39;-&#39;+Dd+&#39; &#39;+Dh+&#39;:&#39;+Dmi+&#39;:&#39;+Ds; 
                    return newDate; 
                } 

//只能输入数字 
function txtnumber() 
            { 
                if 
((event.keyCode >57) || (event.keyCode <48)) 
                    return false;else return true; 
            } 

        //只能输入数字和字母 

    function txtnumchar() 
            { 
//65- 90 97-122 
                var kcode = event.keyCode; 
                if (kcode >= 48 && kcode <= 57) 
                    return true; 
                else if(kcode >= 65 
&& kcode <= 90) 
                    return true; 
                else if (kcode >= 97 && kcode <= 122) 
                    return true; 
                else 
                    return false; 
            }

getCommonTable.js

getCommonTable.js 
//获取table头 
         function 
getTableHeadByWidth(widthSize,ids){ 
         var Tableone = "<table 
id=&#39;tab"+ids+"&#39; border=&#39;0&#39; cellspacing=&#39;0&#39; cellpadding=&#39;0&#39; "; 
         var 
Tabletwo = ">"; 
         if (widthSize == "") 
         return 
Tableone + Tabletwo; 
         else 
         return 
Tableone+"width="+widthSize+Tabletwo; 

        } 

         
//获取第一个tr td 传一个宽度值 
        function 
getTrAndTdFirstByCWidth(classname,widthSize){ 
         var tdone = " <tr 
"; 
         var tdtwo = "><td style="BORDER-BOTTOM: 1px solid;" 
style="BORDER-BOTTOM: 1px solid;" align=&#39;center&#39; "; 
         var tdthr = " 
> "; 
         if (classname =="") 
         tdone += tdtwo; 
         else 
         tdone+=" class =&#39;"+classname+"&#39; "+tdtwo; 

         if (widthSize == "") 
         tdone += tdthr; 
         else 
         tdone += " width="+widthSize+tdthr; 

         return 
tdone; 
        } 

        //获取下一个TD，传一个宽度值 
        function 
getTdNextByWidth(widthSize){ 
         var tdone = " </td><td 
style=" BORDER-BOTTOM: 1px solid" style=" BORDER-BOTTOM: 1px solid" 
align=&#39;center&#39; "; 
         var tdtwo =">"; 
         if (widthSize 
=="") 
         return tdone+tdtwo; 
         else 
         return 
tdone+"width="+widthSize+tdtwo; 
        } 

        //获取最后一个td 
        function getTdLastByWidth(widthSize){ 
         var tdone = 
" </td><td style=" BORDER-BOTTOM: 1px solid" style=" BORDER-BOTTOM: 1px 
solid" align=&#39;center&#39; "; 
         var tdtwo =">"; 
         if 
(widthSize =="") 
         return tdone+tdtwo; 
         else 
         return tdone+"width="+widthSize+tdtwo; 
        } 
        //获取最后一个tr/td 
        function getTrAndTdLast(){ 
         return 
" </td></tr>"; 
        } 

         
        //获取table尾 
        function getTableLast(){ 
         return "</table>"; 
        } 

        //获取img 
        function 
getImgByParams(imgUrl,altstr,eventName,eventParams,imgid){ 
         var one 
= "<img src="/static/imghwm/default1.png"  data-src="Images/uuu.gif"  class="lazy"  border=&#39;0&#39;   style="max-width:90%" style="CURSOR: hand""; 
         if (imgUrl != "") 
         one += "src=&#39;"+imgUrl+"&#39;"; 
         if 
(altstr != "") 
         one += "alt=&#39;"+altstr+"&#39;"; 
         if(imgid != 
"") 
         one += "id=&#39;"+imgid+"&#39;"; 

         one += 
"onclick=&#39;"+eventName+"("+eventParams+");&#39;> "; 

         return one 
        } 

//--------排序--------------------------- 
            //通过字段的内容排序 
        SortByBtnidAndCellName=function(btnId,cellName,celltype){ 
            var way =    getOpType(btnId);//0为正。1为倒 
            var ds = 
userdata.value; 
            var sortarr= new Array(); 
            if 
((ds!= null) && (typeof(ds) == "object")){ 
             var len = 
ds.Rows.length; 
             if(celltype==&#39;S&#39; || celltype==&#39;N&#39;){ 
                        for(var j=0;j<len;j++){ 
                            sortarr[j] = 
ds.Rows[j][cellName];//.substr(0,1);//通过字符 
                            } 
                    }else if(celltype==&#39;D&#39;){ 
                        for(var i=0;i<len;i++){ 
                                    sortarr[i] = 
getDateByFormat(ds.Rows[i][cellName]);//通过日期 
                            } 
                    } 
                if(sortarr!=&#39;&#39;){ 
                    var indexarr = new Array(); 
                    indexarr = getSortArray(sortarr,celltype);//得到新的排序规则 
                    if(indexarr != &#39;&#39;){ 
                        setSortAginbyWay(indexarr,way); 
                    } 
                } 
            } 
        } 

        //获得排序 
        getOpType=function(btnid){//返回0正序，1为倒序 
            var imgName= $("#"+btnid).attr("src"); 
            var wz = 
imgName.indexOf(&#39;.gif&#39;); 
            var oldImg =imgName.substr(wz-9,9); 
            if(oldImg==&#39;sort_desc&#39;){//当前是倒序或未排序,需要正序sort_ascc 
                $("#"+btnid).attr("src","../Images/sort_ascc.gif"); 
                return 0; 
            }else{ 
                $("#"+btnid).attr("src","../Images/sort_desc.gif"); 
                return 1; 
            } 

        } 
        //按JS Sort排序 获得新的排序规则 
        getSortArray=function 
(sortdatearr,celltype){// 参数为array 
                var sortstr = &#39;&#39;; 
                for(var k=0;k<sortdatearr.length;k++){ 
                if(sortstr==&#39;&#39;) 
                        sortstr=sortdatearr[k]; 
                    else 
                        sortstr+=&#39;^%^&#39;+sortdatearr[k]; 
                } 
                var newsortdate =sortdatearr; 
                var len = 
sortdatearr.length; 

                    if(celltype ==&#39;S&#39; || celltype 
==&#39;D&#39;) 
                        newsortdate.sort();//字符排序 
                    else{ //数字排序 
                        for(var 
i=0;i<len;i++){ 
                            var tmp =0; 
                            for(var j=i+1;j<len;j++){ 
                                if(newsortdate[i]>newsortdate[j]){ 
                                    tmp = newsortdate[i]; 
                                    newsortdate[i] = newsortdate[j]; 
                                    newsortdate[j] =tmp; 
                                } 
                            } 
                        } 
                    } 

             var 
tmpsortdate =sortstr.split(&#39;^%^&#39;) 

             var resultarr = new 
Array(); 
             for(var i = 0;i<len;i++){ 
                    for(var j = 0;j<len;j++){ 
                     if(newsortdate[i]==tmpsortdate[j]){ 
                            resultarr[i] 
= j; 
                            tmpsortdate[j] =&#39;||||||||&#39;; 
                            break; 
                     } 
                    } 
             } 

             return 
resultarr; 
        }; 

//--------------------end------------------------------- 
//删除重复的手机号码 
SplitRepeatMobile=function(mobile){ 
    var mob=mobile; 
    for(var 
i=0;i<mob.length;i++){ 
        for(var j=i+1;j<mob.length;j++){ 
            if(mob[i]==mob[j]){ 
                mob.splice(j,1); 
            } 
        } 
    } 
    return mob; 
}

GroupText.js 

        var totalCount;//总页 
var userdata;//数据对象 
    $(document).ready(function(){             

             
            if(ecid !=""){ 
             firstSearch(ecid); 
            } 

            $("#ddlCsList").change(function(){ 
             ecid = $.trim($("#ddlCsList").val()); 
             firstSearch(ecid); 
            }); 

            $("#btnfirst").click(function(){ 
         firstSearch(ecid); 
            }); 

            $("#btnnext").click(function(){ 
             nextSearch(ecid); 
            }); 

            $("#btnpre").click(function(){ 
             preSearch(ecid); 
            }); 

            $("#btnlast").click(function(){ 
             lastSearch(ecid); 
            }); 

            $("#gotopg").click(function(){ 
             gotoSearch(ecid); 
            }); 

         

}); 
//绑定数据 
        function binddata(udata) 
        { 
         jpstr 
="";//这样的目的是清空,很有用的一步 

         var ds = udata.value; 

                    if ((ds!= null) && (typeof(ds) == "object")) 
                    { 
                     //alert( ds.Rows[0].ItemName 
) 
                     var c = ds.Rows.length; 
                     var 
newarr = getdataarr(udata); 
                     for(var k = 0; 
k<newarr.length;k++){ 

                             
                            var tmp = newarr[k]; 
                            jpstr +="<tr><td style=" BORDER-BOTTOM: 
1px solid" style=" BORDER-BOTTOM: 1px solid"><img src="/static/imghwm/default1.png"  data-src="Images/uuu.gif"  class="lazy"  id 
=&#39;"+ds.Rows[tmp].srId+"&#39; onclick=showOrHide("+ds.Rows[tmp].srId+") 
style="CURSOR: hand" style="CURSOR: hand"  ><B>"+ds.Rows[tmp].ItemName+"</b></td></tr><tr><td>" 
                            var jpstrA=""; 
                            for(var i=tmp; i<c; i++) 
                            { 

                             if(ds.Rows[tmp].ItemName == ds.Rows[i].ItemName ){ 
                                            jpstrA += 
getTrAndTdFirstByCWidth("dg_item","10%") + 
                                                            ""+ds.Rows[i].ItemName 
+ getTdNextByWidth("10%") + 
                                                            ""+ds.Rows[i].SendMod 
+ getTdNextByWidth("10%") + 
                                                            ""+ds.Rows[i].RecvMod 
+ getTdNextByWidth("12%") + 
                                                            ""+getDateByFormat(ds.Rows[i].SendDate) 
+ getTdNextByWidth("38%") + 
                                                            ""+ds.Rows[i].SendMsg 
+ getTdNextByWidth("10%") + 
                                                            ""+ds.Rows[i].JfValue 
+ getTdLastByWidth("10%") + 
                                                            ""+getTextByStatus(ds.Rows[i].SendStatus) 
+ 
                                                            "" + 
getTrAndTdLast(); 
                                        } 
                                }     

                                jpstr 
+=getTableHeadByWidth("100%",ds.Rows[tmp].srId) + jpstrA + getTableLast(); 

                                jpstr += "</td></tr>"; 

                        } 
                        jpstr ="<table 
width=100%>"+jpstr+"</table>"; 

                             

                                document.getElementById("divcontent").innerHTML 
= jpstr; 
                                //alert(jpstr); 

                } 
                else 
                { 
                    document.getElementById("divcontent").innerHTML = 
"";     
                } 

} 
showOrHide=function(ids){ 
            $("#tab"+ids).toggle(); 
            var imgName= 
$("#"+ids).attr("src"); 

                var wz = 
imgName.indexOf(&#39;.gif&#39;); 
                var oldImg =imgName.substr(wz-3,3); 

                if(oldImg==&#39;uuu&#39;)//选择 
                        $("#"+ids).attr("src","Images/eee.gif"); 
                else{ 
                    $("#"+ids).attr("src","Images/uuu.gif"); 

                    } 

} 
function getdataarr(udata){ 
var 
ds = udata.value; 
            var resultArr= new Array(); 
            var dsstr=&#39;&#39;; 
            for(var i=0; i<ds.Rows.length; 
i++){ 
                resultArr[i] = $.trim(ds.Rows[i].ItemName); 
                if(dsstr==&#39;&#39;) 
                 dsstr 
=$.trim(ds.Rows[i].ItemName); 
                 else 
                 dsstr+=&#39;^%^&#39;+$.trim(ds.Rows[i].ItemName) 
            } 

            splitStr(resultArr) 

            var newArr = new 
Array(); 
            var temparr=dsstr.split(&#39;^%^&#39;) 
            for(var 
k=0;k<resultArr.length;k++){ 
                for(var 
m=0;m<temparr.length;m++){ 
                    if(resultArr[k]==temparr[m]){ 
                        newArr[k]=m; 
                        break; 
                    } 
                } 
            } 

            return newArr; 
} 
splitStr= function(oldarr){ 
                var nArr=oldarr; 
                var isok=false; 
                for(var l=0;l<nArr.length;l++){ 
                    for(var j=l+1;j<nArr.length;j++){ 
                    if(nArr[l]==nArr[j]){ 
                        nArr.splice(j,1); 
                        isok=true; 
                        }     
                } 
            } 

            if(isok) 
                splitStr(nArr); 

} 
function 
getTextByStatus(status){ 
            if(status==0){ 
             return 
"<font color=&#39;blue&#39;>启用</font>"; 
}else{ 
             return 
"<font color=&#39;red&#39;><B>禁用</B></font>"; 
} 
} 
function getImgByStatus(status){ 
if(status==0){ 
return 
"../Images/gz2.gif"; 
}else{ 
return "../Images/gz1.gif"; 
} 
} 
function getTxtByStatus(status){ 
if(status==0){ 
return "我要禁用"; 
}else{ 
return "我要启用"; 
} 
} 
//第一页 
        function 
firstSearch(ecid) 
        { 
         if (ecid != ""){ 
                 totalCount = Interactive.GetCmdSMSlogCount("1=1").value; 
                    userdata = 
Interactive.PageingOpenCmdSMSLog(1,pageSize);//Interactive.getInteractiveSMSByEcid(ecid,pageSize,1,totalCount); 

                    binddata(userdata); 

                    $("#recordcount").html(totalCount.toString());//curpageindex 
                    $("#curpageindex").html(totalCount==0?&#39;0&#39;:1); 
                    if (totalCount % pageSize ==0) 
                    { 
                     $("#pgcount").html((totalCount / pageSize).toString()); 
                    }else{ 
                     $("#pgcount").html(parseInt(totalCount / pageSize)+1); 
                    } 

                } 
        } 
    //下一页 
        function 
nextSearch(ecid){ 
         if (ecid != ""){ 
         var curpg 
=$("#curpageindex").html();//得到当前页 
         var pgCount = 
$("#pgcount").html();//得到总的页数 
         if (curpg < pgCount){ 
                        totalCount = 
Interactive.GetCmdSMSlogCount(&#39;1=1&#39;).value; 
                     userdata = 
Interactive.PageingOpenCmdSMSLog(parseInt(curpg)+1,pageSize); 

                        binddata(userdata); 
                        $("#recordcount").html(totalCount);//curpageindex 
                        $("#curpageindex").html(parseInt(curpg)+1); 
                        if (totalCount % pageSize ==0) 
                        { 
                        $("#pgcount").html(totalCount / pageSize); 
                        }else{ 
                            $("#pgcount").html(parseInt(totalCount / 
pageSize)+1); 
                        } 
                    }else{ 
                     alert("当前已经是尾页了!"); 
                    } 
                } 
        } 
    //上一页 
        function 
preSearch(ecid){ 
         if (ecid != ""){ 
         var curpg 
=$("#curpageindex").html();//得到当前页 
         var pgCount = 
$("#pgcount").html();//得到总的页数 
         if (curpg > 1 ){ 
                        totalCount = 
Interactive.GetCmdSMSlogCount(&#39;1=1&#39;).value; 
                     userdata = 
Interactive.PageingOpenCmdSMSLog(parseInt(curpg)-1,pageSize); 
                        binddata(userdata); 
                        $("#recordcount").html(totalCount);//curpageindex 
                        $("#curpageindex").html(parseInt(curpg)-1); 
                        if (totalCount % pageSize ==0) 
                        { 
                        $("#pgcount").html(totalCount / pageSize); 
                        }else{ 
                            $("#pgcount").html(parseInt(totalCount / 
pageSize)+1); 
                        } 
                    }else{ 
                         alert("当前已经是首页了!"); 
                    } 
                } 
        } 
        //尾页 
        function 
lastSearch(ecid){ 
         if (ecid != ""){ 
         var curpg 
=$("#curpageindex").html();//得到当前页 
         var pgCount = 
$("#pgcount").html();//得到总的页数 
         if (curpg < pgCount ){ 
                        totalCount = 
Interactive.GetCmdSMSlogCount(&#39;1=1&#39;).value; 
                     userdata = 
Interactive.PageingOpenCmdSMSLog(pgCount,pageSize); 
                        binddata(userdata); 
                        $("#recordcount").html(totalCount);//curpageindex 
                        $("#curpageindex").html(pgCount); 
                        if (totalCount % pageSize ==0) 
                        { 
                        $("#pgcount").html(totalCount / pageSize); 
                        }else{ 
                            $("#pgcount").html(parseInt(totalCount / 
pageSize)+1); 
                        } 
                    } 
                } 

        } 

        //跳转指定页 
        function gotoSearch(ecid){ 
         if (ecid != ""){ 
         var curpg =$("#curpageindex").html();//得到当前页 
         var 
pgCount = $("#pgcount").html();//得到总的页数 
         var pggoto 
=$("#gototxt").val(); 
         var reg = /[^\d]/g; 
                    if (($.trim(pggoto) != "") && 
!(reg.test(pggoto))){ 
                        if ((parseInt(curpg) != 
parseInt(pggoto)) && (pggoto <= pgCount)){ 
                            totalCount = 
Interactive.GetCmdSMSlogCount(&#39;1=1&#39;).value; 
                            userdata = 
Interactive.PageingOpenCmdSMSLog(pggoto,pageSize); 
                            binddata(userdata); 
                            $("#recordcount").html(totalCount);//curpageindex 
                            $("#curpageindex").html(pggoto); 
                            if (totalCount % pageSize ==0) 
                            { 
                            $("#pgcount").html(totalCount / pageSize); 
                            }else{ 
                                $("#pgcount").html(parseInt(totalCount / 
pageSize)+1); 
                            } 
                        } 
                    }else{ 
                        alert("请输入正确的数字!"); 
                    } 

                } 

        } 

        //刷新 
        function Refresh(ecid){ 
         if (ecid 
!= ""){ 
         var curpg =$("#curpageindex").html();//得到当前页 

                    totalCount = 
Interactive.GetCmdSMSlogCount(&#39;1=1&#39;).value; 
                    userdata = 
Interactive.PageingOpenCmdSMSLog(curpg); 
                    binddata(userdata); 
                    $("#recordcount").html(totalCount);//curpageindex 
                    $("#curpageindex").html(curpg); 
                    if (totalCount % pageSize ==0) 
                    { 
                    $("#pgcount").html(totalCount / pageSize); 
                    }else{ 
                        $("#pgcount").html(parseInt(totalCount / 
pageSize)+1); 
                    } 

                     
                } 

        }

GroupText.aspx.cs: 
private void Page_Load(object sender, System.EventArgs e) 
{ 
// 在此处放置用户代码以初始化页面 
Ajax.Utility.RegisterTypeForAjax(typeof(DataAccess.Interactive)); 
}

Interactive.cs: 
[Ajax.AjaxMethod(Ajax.HttpSessionStateRequirement.Read)] 
        public DataTable PageingOpenCmdSMSLog(int pgindex,int pageSize) 
        { 
            int pageIndex=pgindex; 
            DataTable 
dt = new DataTable (); 
            JSONHelper json = new JSONHelper(); 
            int count = GetCmdSMSlogCount("1=1"); 
            dt = 
GetDataByPager2000("SendAndRecvData S left join InteractiveSMS I on 
(S.ItemId=I.Id AND S.ECID=I.ECID)","srId","1=1",pageSize,pageIndex,"srId",1, 
                "S.srId,I.ItemName,S.SendMod,S.RecvMod,S.SendDate,S.SendMsg,S.JfValue,S.SendStatus",count); 
            return dt; 
        } 

        [Ajax.AjaxMethod(Ajax.HttpSessionStateRequirement.Read)] 
        public int GetCmdSMSlogCount(string where) 
        { 
            try 
            { 
                int count = 
ReturnSQL("select count(*) from SendAndRecvData S left join InteractCommand I 
on(S.ItemId=I.Id AND S.ECID=I.ECID) where "+where); 
                return 
count; 
            } 
            catch (Exception) 
            { 

                throw; 
            } 
        } 
        /// 
<summary> 
        /// 分页获取数据列表 适用于SQL2000 
        /// 
</summary> 
        /// <param name="tablename">表名</param> 
        /// <param name="key">主键</param> 
        /// 
<param name="where">查询条件</param> 
        /// <param 
name="pagesize">每页记录数</param> 
        /// <param 
name="pageindex">页索引</param> 
        /// <param 
name="orderfield">排序字段</param> 
        /// <param 
name="ordertype">排序方式 1=ASC 0=DESC</param> 
        /// <param 
name="fieldlist">查找的字段</param> 
        /// <param 
name="recordcount">总记录数</param> 
        /// 
<returns></returns> 
        public static DataTable 
GetDataByPager2000(string tablename, string key, string where, int pagesize, int 
pageindex, string orderfield, int ordertype, string fieldlist, int recordcount) 
        { 
            string cmd = "ProcCustomPage"; 
            SqlParameter[] para = new SqlParameter[9]; 
            para[0] = new SqlParameter("@Table_Name", tablename); 
            para[1] = new SqlParameter("@Sign_Record", key); 
            para[2] = new SqlParameter("@Filter_Condition", where); 
            para[3] = new SqlParameter("@Page_Size", pagesize); 
            para[4] = new SqlParameter("@Page_Index", pageindex); 
            para[5] = new SqlParameter("@TaxisField", orderfield); 
            para[6] = new SqlParameter("@Taxis_Sign", ordertype); 
            para[7] = new SqlParameter("@Find_RecordList", fieldlist); 
            para[8] = new SqlParameter("@Record_Count", recordcount); 

            return ExecuteDataSet(CommandType.StoredProcedure, cmd, 
para).Tables[0]; 

        } 
        public static DataSet 
ExecuteDataSet(CommandType cmdType, string cmdText, params SqlParameter[] para) 
        { 
            try 
            { 
                using 
(SqlConnection con = new SqlConnection(CONN_STRING)) 
                { 
                    SqlDataAdapter adapter = new SqlDataAdapter(); 

                    using (SqlCommand cmd = new SqlCommand()) 
                    { 
                        DataSet ds = new 
DataSet(); 
                        PrepareCommand(con, cmd, cmdType, 
cmdText, para); 
                        adapter.SelectCommand = cmd; 
                        adapter.Fill(ds); 

                        return ds; 
                    } 
                } 
            } 
            catch(Exception ex) 
            { 
                string d=ex.ToString(); 
                return null; 
            } 
        } 
        /// 
<summary> 
        /// 建立SqlCommand 
        /// </summary> 
        /// <param name="con">SqlConnection　对象</param> 
        /// <param name="cmd">要建立的Command</param> 
        /// <param name="cmdType">CommandType</param> 
        /// <param name="cmdText">执行的SQL语句</param> 
        /// <param name="cmdParms">参数</param> 
        private static void PrepareCommand(SqlConnection con, SqlCommand 
cmd, CommandType cmdType, string cmdText, SqlParameter[] cmdParms) 
        { 
            if (con.State != ConnectionState.Open) 
                con.Open(); 

            cmd.Connection = con; 
            cmd.CommandType = cmdType; 
            cmd.CommandText = 
cmdText; 

            if (cmdParms != null) 
                foreach 
(SqlParameter para in cmdParms) 
                    cmd.Parameters.Add(para); 
        }

Statement

The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

如何在Word中复制页面Feb 20, 2024 am 10:09 AM

是否要复制MicrosoftWord中的页面，并保持格式不变？这是一个聪明的想法，因为当您想要创建特定文档布局或格式的多个副本时，在Word中复制页面可能是一种有用的节省时间的技术。本指南将逐步引导您在Word中复制页面的过程，无论是创建模板还是复制文档中的特定页面。这些简单的说明旨在帮助您轻松地重新制作页面，省去从头开始的麻烦。为什么要在MicrosoftWord中复制页面？在Word中复制页面非常有益的原因有以下几点：当您有一个具有特定布局或格式的文档要复制时。与从头开始重新创建整个页面不同

如何在CakePHP中创建自定义分页？Jun 04, 2023 am 08:32 AM

CakePHP是一个强大的PHP框架，为开发人员提供了很多有用的工具和功能。其中之一是分页，它可以帮助我们将大量数据分成几页，从而简化浏览和操作。默认情况下，CakePHP提供了一些基本的分页方法，但有时你可能需要创建一些自定义的分页方法。这篇文章将向您展示如何在CakePHP中创建自定义分页。步骤1：创建自定义分页类首先，我们需要创建一个自定义分页类。这个

处理Laravel页面无法正确显示CSS的方法Mar 10, 2024 am 11:33 AM

《处理Laravel页面无法正确显示CSS的方法，需要具体代码示例》在使用Laravel框架开发Web应用时，有时候会遇到页面无法正确显示CSS样式的问题，这可能会导致页面呈现不正常的样式，影响用户体验。本文将介绍一些处理Laravel页面无法正确显示CSS的方法，并提供具体的代码示例，帮助开发者解决这一常见问题。一、检查文件路径首先要检查CSS文件的路径是

3秒跳转页面实现方法：PHP编程指南Mar 25, 2024 am 10:42 AM

标题：3秒跳转页面实现方法：PHP编程指南在网页开发中，页面跳转是常见的操作，一般情况下我们使用HTML中的meta标签或者JavaScript的方法进行页面跳转。不过，在某些特定的情况下，我们需要在服务器端进行页面跳转。本文将介绍如何使用PHP编程实现一个在3秒内自动跳转到指定页面的功能，同时会给出具体的代码示例。PHP实现页面跳转的基本原理PHP是一种在

如何在iPhone上自定义和编辑待机模式：iOS 17的新功能Sep 21, 2023 pm 04:01 PM

待机是iOS17更新中的一项新功能，它提供了一种新的增强方式，可以在手机快速闲置时访问信息。通过StandBy，您可以方便地查看时间、查看即将发生的事件、浏览日历、获取您所在位置的天气更新等等。激活后，iPhone在充电时设置为横向时会直观地进入待机模式。此功能非常适合床头柜等无线充电点，或者在日常任务中离开iPhone充电时。它允许您轻扫待机中显示的各种小部件，以访问来自各种应用程序的不同信息集。但是，您可能希望根据您的偏好和您经常需要的信息修改这些小部件，甚至删除一些小部件。因此，让我们深入

重新排列、禁用和删除 iPhone 主屏幕页面的方法Nov 29, 2023 am 08:22 AM

在iOS中，Apple允许您禁用iPhone上的单个主屏幕页面。还可以重新排列主屏幕页面的顺序，并直接删除页面，而不仅仅是禁用它们。这是它的工作原理。如何重新排列主屏幕页面触摸并按住主屏幕上的空格可进入抖动模式。轻点代表主屏幕页面的圆点行。在显示的主屏幕网格中，轻触并拖动页面以将其相对于其他页面重新排列。其他人会移动以响应您的拖拽动作。当您对新排列感到满意时，点击屏幕右上角的“完成”，然后再次点击“完成”以退出抖动模式。如何禁用或删除主屏幕页面触摸并按住主屏幕上的空格可进入抖动模式。轻点代表主屏

如何快速刷新网页？Feb 18, 2024 pm 01:14 PM

页面刷新在我们日常的网络使用中非常常见，当我们访问一个网页后，有时候会遇到一些问题，比如网页加载不出来或者显示不正常等。这时候我们通常会选择刷新页面来解决问题，那么如何快速地刷新页面呢？下面我们就来探讨一下页面刷新的快捷键。页面刷新快捷键是一种通过键盘操作来快速刷新当前网页的方法。在不同的操作系统和浏览器中，页面刷新的快捷键可能有所不同。下面我们以常见的W

使用JavaScript实现表格数据的分页显示Jun 16, 2023 am 10:00 AM

随着数据的不断增长，表格显示变得更加困难。大多数情况下，表格中的数据量过大，导致表格在加载时变得缓慢，而且用户需要不断地浏览页面才能找到自己想要的数据。本文将介绍如何使用JavaScript实现表格数据的分页显示，让用户更容易找到自己想要的数据。一、动态创建表格为了使分页功能更加可控，需要动态创建表格。在HTML页面中，添加一个类似于下面的table元素。

See all articles

Hot AI Tools

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress images for free

Clothoff.io

AI clothes remover

AI Hentai Generator

Generate AI Hentai for free.

Hot Article

R.E.P.O. Energy Crystals Explained and What They Do (Yellow Crystal)

2 weeks agoBy尊渡假赌尊渡假赌尊渡假赌

Repo: How To Revive Teammates

4 weeks agoBy尊渡假赌尊渡假赌尊渡假赌

Hello Kitty Island Adventure: How To Get Giant Seeds

3 weeks agoBy尊渡假赌尊渡假赌尊渡假赌

How Long Does It Take To Beat Split Fiction?

3 weeks agoByDDD

R.E.P.O. Save File Location: Where Is It & How to Protect It?

3 weeks agoByDDD

Hot Tools

ZendStudio 13.5.1 Mac

Powerful PHP integrated development environment

SAP NetWeaver Server Adapter for Eclipse

Integrate Eclipse with SAP NetWeaver application server.

EditPlus Chinese cracked version

Small size, syntax highlighting, does not support code prompt function

DVWA

Damn Vulnerable Web App (DVWA) is a PHP/MySQL web application that is very vulnerable. Its main goals are to be an aid for security professionals to test their skills and tools in a legal environment, to help web developers better understand the process of securing web applications, and to help teachers/students teach/learn in a classroom environment Web application security. The goal of DVWA is to practice some of the most common web vulnerabilities through a simple and straightforward interface, with varying degrees of difficulty. Please note that this software

Atom editor mac version download

The most popular open source editor

Hot Topics

Where is the login entrance for gmail email?

7319

1625

1349

1261

1209