ajax与js无刷新分页,JS+Ajax+Jquery实现页面无刷新分页以及分组 超强的实现

GroupText

var ecid = '100001';

var jpstr = "";

var pageSize = 8;

// -->

活动名称发送方接收方发送时间发送内容积分状态

height="100%">

width="100%" colSpan="10">

0条记录   

目前第0 /0页   

首页

上一页下一页

尾页

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+'-'+Dm+'-'+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+'-'+Dm+'-'+Dd+' '+Dh+':'+Dmi+':'+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 = "

var Tabletwo = ">";

if (widthSize == "")

return Tableone + Tabletwo;

else

return Tableone+"width="+widthSize+Tabletwo;

}

//获取第一个tr td 传一个宽度值

function getTrAndTdFirstByCWidth(classname,widthSize){

var tdone = "

var tdtwo = ">

var tdthr = " > ";

if (classname =="")

tdone += tdtwo;

else

tdone+=" class ='"+classname+"' "+tdtwo;

if (widthSize == "")

tdone += tdthr;

else

tdone += " width="+widthSize+tdthr;

return tdone;

}

//获取下一个TD,传一个宽度值

function getTdNextByWidth(widthSize){

var tdone = " 

var tdtwo =">";

if (widthSize =="")

return tdone+tdtwo;

else

return tdone+"width="+widthSize+tdtwo;

}

//获取最后一个td

function getTdLastByWidth(widthSize){

var tdone = " 

var tdtwo =">";

if (widthSize =="")

return tdone+tdtwo;

else

return tdone+"width="+widthSize+tdtwo;

}

//获取最后一个tr/td

function getTrAndTdLast(){

return " 

";

}

//获取table尾

function getTableLast(){

return "

";

}

//获取img

function getImgByParams(imgUrl,altstr,eventName,eventParams,imgid){

         var one = "

if (imgUrl != "")

one += "src='"+imgUrl+"'";

if (altstr != "")

one += "alt='"+altstr+"'";

if(imgid != "")

one += "id='"+imgid+"'";

one += "οnclick='"+eventName+"("+eventParams+");'> ";

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=='S' || celltype=='N'){

for(var j=0;j

sortarr[j] = ds.Rows[j][cellName];//.substr(0,1);//通过字符

}

}else if(celltype=='D'){

for(var i=0;i

sortarr[i] = getDateByFormat(ds.Rows[i][cellName]);//通过日期

}

}

if(sortarr!=''){

var indexarr = new Array();

indexarr = getSortArray(sortarr,celltype);//得到新的排序规则

if(indexarr != ''){

setSortAginbyWay(indexarr,way);

}

}

}

}

//获得排序

getOpType=function(btnid){//返回0正序,1为倒序

var imgName= $("#"+btnid).attr("src");

var wz = imgName.indexOf('.gif');

var oldImg =imgName.substr(wz-9,9);

if(oldImg=='sort_desc'){//当前是倒序或未排序,需要正序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 = '';

for(var k=0;k

if(sortstr=='')

sortstr=sortdatearr[k];

else

sortstr+='^%^'+sortdatearr[k];

}

var newsortdate =sortdatearr;

var len = sortdatearr.length;

if(celltype =='S' || celltype =='D')

newsortdate.sort();//字符排序

else{ //数字排序

for(var i=0;i

var tmp =0;

for(var j=i+1;j

if(newsortdate[i]>newsortdate[j]){

tmp = newsortdate[i];

newsortdate[i] = newsortdate[j];

newsortdate[j] =tmp;

}

}

}

}

var tmpsortdate =sortstr.split('^%^')

var resultarr = new Array();

for(var i = 0;i

for(var j = 0;j

if(newsortdate[i]==tmpsortdate[j]){

resultarr[i] = j;

tmpsortdate[j] ='||||||||';

break;

}

}

}

return resultarr;

};

//--------------------end-------------------------------

//删除重复的手机号码

SplitRepeatMobile=function(mobile){

var mob=mobile;

for(var i=0;i

for(var j=i+1;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

var tmp = newarr[k];

jpstr +="

uuu.gif "+ds.Rows[tmp].ItemName+""

var jpstrA="";

for(var i=tmp; 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 += "

";

}

jpstr ="

";

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('.gif');

var oldImg =imgName.substr(wz-3,3);

if(oldImg=='uuu')//选择

$("#"+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='';

for(var i=0; i

resultArr[i] = $.trim(ds.Rows[i].ItemName);

if(dsstr=='')

dsstr =$.trim(ds.Rows[i].ItemName);

else

dsstr+='^%^'+$.trim(ds.Rows[i].ItemName)

}

splitStr(resultArr)

var newArr = new Array();

var temparr=dsstr.split('^%^')

for(var k=0;k

for(var m=0;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

for(var j=l+1;j

if(nArr[l]==nArr[j]){

nArr.splice(j,1);

isok=true;

}

}

}

if(isok)

splitStr(nArr);

}

function getTextByStatus(status){

if(status==0){

return "启用";

}else{

return "禁用";

}

}

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?'0':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('1=1').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('1=1').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('1=1').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('1=1').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('1=1').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;

}

}

///

/// 分页获取数据列表 适用于SQL2000

///

/// 表名

/// 主键

/// 查询条件

/// 每页记录数

/// 页索引

/// 排序字段

/// 排序方式 1=ASC 0=DESC

/// 查找的字段

/// 总记录数

///

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;

}

}

///

/// 建立SqlCommand

///

/// SqlConnection 对象

/// 要建立的Command

/// CommandType

/// 执行的SQL语句

/// 参数

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

}

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值