var ecid = '100001';
var jpstr = "";
var pageSize = 8;
// -->
活动名称 | 发送方 | 接收方 | 发送时间 | 发送内容 | 积分 | 状态 |
height="100%"> | ||||||
width="100%" colSpan="10">
|
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 +="
"+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);
}