Jquery+Ajax+asp.net+sqlserver-编写的通用邮件管理(源码)

ewrewre · 发表于 2014-4-8 10:35:33

Jquery+Ajax+asp.net+sqlserver-编写的通用邮件管理(源码)
开始
      邮件管理通常用在各个内部系统中，为了方便快捷的使用现有的代码开发一个邮件管理系统而诞生的、

准备条件
这是我的设计表结构，大家一看就懂了

--邮件接收表
CREATE TABLE [dbo].[TAB_MAILSENDRESERVED](
[FID] [nvarchar](36) NULL,
[MAILGUID] [nvarchar](36) NULL,
[SENDUSERID] [nvarchar](36) NULL,--发送人
[RESERVEDUSERID] [nvarchar](36) NULL,--接收人
[SENDTIME] [datetime] NULL,
[sorttime] [int] identity(1,1) ,
[ISBACKMSG] [int] DEFAULT ((0)) ,
[STATUE] [int] DEFAULT ((0)),
[ISDELETE] [int] DEFAULT ((0)),
[SENDUSERNAME] [nvarchar](200) NULL,
[RESERVEDNAME] [nvarchar](200) NULL
)

--邮件主题表
CREATE TABLE [dbo].[TAB_MAIL](
[ID] [nvarchar](36) NULL,
[TITLE] [nvarchar](300) NULL,
[CONTENT] [text] NULL,
[ISATTACHFILE] [int] default(0) ,
[USINGCOUNT] [int] NULL
)

--邮件附件表
CREATE TABLE [dbo].[TAB_MAILFILES](
[FILEID] [nvarchar](36) NULL,
[FILEPATH] [nvarchar](100) NULL,
[FILETYPE] [nvarchar](10) NULL,
[FILESIZE] [nvarchar](10) NULL,
[USINGCOUNT] [int] default(0) ,--这个很重要（判断当前多少用户使用该附件，最后一个删除邮件主体数据的才能物理删除该附件）
[FILENAMES] [nvarchar](200) NULL
)

   现在只需要一个用户表中一个ID字段或者UserID字段。

截图：
  地址在这里：http://10086bank.com/  里面的”邮件“

界面截图：（写新邮件，收件箱，发件箱，回收站之间可以拖动顺序）界面打开默认获取收件箱数据。如图：

支持自己给自己发邮件，定时发送邮件。

前端JS
var userid = 1002; //test demo using value
 var filepath = []; //路径
 var filename = []; //名称
 var filesize = []; //大小
 var ckidlist = []; //判断是否存在
 var pagesizeindex = "", persize = 5;
 var gettype = 0; //0收件箱/1发件箱/2回收站

 $(function () {
 $("#WNewEmail").hide(); //新邮件框隐藏
 $("#divsysmsg").hide(); //提示框
 $("myModalA").hide(); //选择人list
 $("#DivViewDT").hide(); //邮件详情

 jQuery("#divall").validationEngine(); //验证
 jQuery("#divpeoplelistitle").validationEngine(); //验证

 //写新邮件
 $("#newemialdiv").click(function () {
 $("#WNewEmail").show();
 $("#divshow").hide(); //关闭列表
 $("#DivViewDT").hide();

 $("#inputSendobj").val(""); //选人id
 $("#inputSendobjName").val(""); //选人name
 $("#date01").val(""); //标题
 $("#textarea2").val("")//内容
 $("#lablefile").html(""); //显示附件名称

 filename = [];
 filepath = [];
 filesize = [];

 $("#FilelistTbody").html(""); //clear files
 $("#MailFileList2").hide();

 $("body[style='margin:4px; font:10pt Arial,Verdana; cursor:text']").html(" ");

 });
 //取消写新邮件
 $("#btnclosedffsdfla").click(function () {
 $("#WNewEmail").hide();
 $("#divmaillist").show();
 });
 //关闭写新邮件
 $("#btncanceldiv").click(function () {
 $("#WNewEmail").hide();
 $("#divmaillist").show();
 });
 //关闭列表
 $("#close").click(function () {
 $("#divshow").hide();
 });
 //modal show 选择发送人员
 $("#inputSendobjName").click(function () {
 $("#myModalA").modal("show");
 scname = "scname";
 GetOrgName($("#searchpeopletxt").val());
 });
 //文本框查找机构
 $("#searchpeopletxt").keyup(function () {
 GetOrgName($("#searchpeopletxt").val());
 });
 //关闭详细显示列表
 $("#A4close").click(function () {
 $("#DivViewDT").hide();
 $("#divmaillist").show();
 });
 //check 选择人员提交
 $("#lasure").click(function () {

 var inputSendobjName = "";
 ckidlist = [];

 $("#inputSendobj").val("");
 var ob = $("input[name='checkboxA']");
 $(ob).each(function () {
 if ($(this).attr("checked") == "checked") {
 $("#inputSendobj").val($("#inputSendobj").val() + $(this).attr("id") + ",");

 ckidlist.push($(this).attr("id"));

 inputSendobjName = inputSendobjName + $(this).attr("myname") + ",";
 }
 });
 if ($("#inputSendobj").val() != "") {
 $("#inputSendobj").val($("#inputSendobj").val().substr(0, $("#inputSendobj").val().length - 1));
 inputSendobjName = inputSendobjName.substr(0, inputSendobjName.length - 1);
 }
 $("#inputSendobjName").val(inputSendobjName);
 $("#Checkboxall").attr("checked", false);
 });
 //全选
 $("#Checkboxall").click(function () {
 if ($("#Checkboxall").attr("checked") == "checked") {
 var objall = $("input[name = 'checkboxA']");
 $(objall).each(function () {
 $(this).attr("checked", true);
 })
 return;
 }
 else {
 var objall = $("input[name = 'checkboxA']");
 $(objall).each(function () {
 $(this).attr("checked", false);
 })
 return;
 }
 });
 //反选
 $("#Checkboxback").click(function () {
 if ($("#Checkboxback").attr("checked") == "checked") {
 var objall = $("input[name = 'checkboxA']");
 $(objall).each(function () {
 if ($(this).attr("checked") == "checked")
 $(this).attr("checked", false);
 })
 return;
 }
 else {
 var objall = $("input[name = 'checkboxA']");
 $(objall).each(function () {
 if ($(this).attr("checked") == false)
 $(this).attr("checked", true);
 })
 return;
 }
 });
 //提交新邮件
 $("#btnsavedata").click(function () {

 if (!jQuery('#divall').validationEngine('validate')) {
 return;
 }

 if ($("#inputSendobj").val() == "") { alert("请选择收件人"); return false; }

 var para = {
 "topeople": $("#inputSendobj").val(),
 "title": $("#date01").val(),
 "content": encodeURIComponent($("#textarea2").val()),
 "filepath": filepath.toString(),
 "filename": filename.toString(),
 "filesize": filesize.toString(),
 "type": "addmsg",
 "ttime": $("#txtsendtime").val() + " " + $("#txthour").val() + ":" + $("#txtmini").val() + ":00",
 "userid": userid
 };

 $.post("userajax/Mail.aspx", para, function (data) {
 $("#inputSendobj").val(""); //选人
 $("#date01").val(""); //标题
 $("#textarea2").val("")//内容
 $("#lablefile").html(""); //显示附件名称

 filename = [];
 filepath = [];
 filesize = [];

 pagesizeindex = "";
 GetSendBox();
 })

 });
 $("#btnmore").click(function () {
 if (gettype == 0)
 GetResBox();
 else if (gettype == 1)
 GetSendBox();
 else if (gettype == 2)
 GetRebBox();
 })

 //发
 $("#A1").click(function () {
 pagesizeindex = "";
 GetSendBox();
 });
 //收
 $("#A2").click(function () {
 pagesizeindex = "";
 GetResBox();
 });
 //回
 $("#A3").click(function () {
 pagesizeindex = "";
 GetRebBox();
 });

 //发
 function GetSendBox() {
 $("#thlable009").html("收件人");
 gettype = 1;
 $("#DivViewDT").hide();
 $("#divmaillist").show();

 if (pagesizeindex == "")
 $("#datalist").html("");

 $("#WNewEmail").hide();
 $("#divshow").show();
 $("#hlistname").html("发件箱");

 $.post("userajax/Mail.aspx", { "type": "getmysenddata", "userid": userid, "searchtype": "1", "pagesizeindex": pagesizeindex }, function (data) {
 if (data == "-999") { alert("登录失效.请重新登录!"); return false; }
 if (data == null || data == "no" || data == "") { $("#datainfoa").html("无数据!"); $("#btnmore").hide(); return; }
 $("#datainfoa").html("");

 var objresult = $.parseJSON(data);

 if (objresult == null) {
 $("#btnmore").hide();
 return;
 }

 pagesizeindex = objresult[objresult.length - 1].sorttime;

 if (objresult.length < persize)
 $("#btnmore").hide();
 else
 $("#btnmore").show();

 for (var i = 0; i < objresult.length; i++) {
 $("#datalist").append("<tr id='TRList" + objresult.sorttime + "'><td>" + objresult.RESERVEDNAME + "</td><td class='center'>" + objresult.SENDTIME + "</td><td class='center'>" + objresult.TITLE + "</td><td class='center'>" + "已发送" + "</td><td>" + (objresult.ISATTACHFILE == '1' ? "" : " ") + "</td><td class='center'><table border='0'><tr border='0'><td><a class='btn btn-success' onclick=maildo('view','" + objresult.ID + "," + objresult.FID + "','" + objresult.sorttime + "')> 查看</a></td><td><a class='btn btn-info' onclick=maildo('forw','" + objresult.ID + "," + objresult.FID + "','" + objresult.sorttime + "')> 转发</a></td><td><a class='btn btn-danger' onclick=maildo('deleteoutbox','" + objresult.ID + "," + objresult.FID + "','" + objresult.sorttime + "')> 删除</a></td></tr></table></td></tr>");
 }
 })
 }

 //收
 function GetResBox() {
 $("#thlable009").html("发件人");
 gettype = 0;
 $("#DivViewDT").hide();
 $("#divmaillist").show();

 if (pagesizeindex == "")
 $("#datalist").html("");

 $("#WNewEmail").hide();
 $("#divshow").show();
 $("#hlistname").html("收件箱");

 $.post("userajax/Mail.aspx", { "type": "getmysenddata", "userid": userid, "searchtype": "0", "pagesizeindex": pagesizeindex }, function (data) {
 if (data == "-999") { alert("登录失效.请重新登录!"); return false; }
 if (data == null || data == "no" || data == "") { $("#datainfoa").html("无数据!"); $("#btnmore").hide(); return; }
 $("#datainfoa").html("");
 var objresult = $.parseJSON(data);

 if (objresult == null) {
 $("#btnmore").hide();
 return;
 }

 pagesizeindex = objresult[objresult.length - 1].sorttime;

 if (objresult.length < persize)
 $("#btnmore").hide();
 else
 $("#btnmore").show();

 for (var i = 0; i < objresult.length; i++) {
 $("#datalist").append("<tr id='TRList" + objresult.sorttime + "'><td>" + objresult.SENDUSERNAME + "</td><td class='center'>" + objresult.SENDTIME + "</td><td class='center'>" + objresult.TITLE + "</td><td class='center'>" + (objresult.STATUE == "0" || objresult.STATUE == 0 ? "" : "") + "" + (objresult.STATUE == "0" || objresult.STATUE == 0 ? "新邮件" : "已读") + "</td><td>" + (objresult.ISATTACHFILE == '1' ? "" : " ") + "</td><td class='center'><table border='0'><tr border='0'><td><a class='btn btn-success' onclick=maildo('view','" + objresult.ID + "," + objresult.FID + "','" + objresult.sorttime + "')> 查看</a></td><td><a class='btn btn-info' onclick=maildo('forw','" + objresult.ID + "," + objresult.FID + "','" + objresult.sorttime + "')> 转发</a></td><td><a class='btn btn-danger' onclick=maildo('deleteinbox','" + objresult.ID + "," + objresult.FID + "','" + objresult.sorttime + "')> 删除</a></td></tr></table></td></tr>");
 }
 })
 }

 //回
 function GetRebBox() {
 $("#thlable009").html("收件人");
 gettype = 2;
 $("#DivViewDT").hide();
 $("#divmaillist").show();

 if (pagesizeindex == "")
 $("#datalist").html("");

 $("#WNewEmail").hide();
 $("#divshow").show();
 $("#hlistname").html("回收站");

 $.post("userajax/Mail.aspx", { "type": "getmysenddata", "userid": userid, "searchtype": "2", "pagesizeindex": pagesizeindex }, function (data) {

 if (data == "-999") { alert("登录失效.请重新登录!"); return false; }

 if (data == null || data == "no" || data == "") { $("#datainfoa").html("无数据!"); $("#btnmore").hide(); return; }

 $("#datainfoa").html("");
 var objresult = $.parseJSON(data);

 if (objresult == null) {
 $("#btnmore").hide();
 return;
 }

 pagesizeindex = objresult[objresult.length - 1].sorttime;

 if (objresult.length < persize)
 $("#btnmore").hide();
 else
 $("#btnmore").show();

 for (var i = 0; i < objresult.length; i++) {
 $("#datalist").append("<tr id='TRList" + objresult.sorttime + "'><td>" + objresult.RESERVEDNAME + "</td><td class='center'>" + objresult.SENDTIME + "</td><td class='center'>" + objresult.TITLE + "</td><td class='center'>已进回收站</td><td>" + (objresult.ISATTACHFILE == '1' ? "" : " ") + "</td><td class='center'><table border='0'><tr border='0'><td><a class='btn btn-success' onclick=maildo('backview','" + objresult.ID + "," + objresult.FID + "','" + objresult.sorttime + "')> 还原</a></td><td><a class='btn btn-danger' onclick=maildo('deleteon','" + objresult.ID + "," + objresult.FID + "','" + objresult.sorttime + "')> 彻底删除</a></td></tr></table></td></tr>");
 }
 })
 }

 load();

 //页面加载默认显示收件箱
 function load() {
 GetResBox();
 }

 //删除附件(多个)
 $("#spdelete").click(function () {
 if (confirm("确定删除吗?") == false) return;

 if (ismyupload == 0) { filename = []; filepath = []; filesize = []; $("#spdelete").hide(); $("#lablefile").html(""); return; }
 $.post("userajax/Mail.aspx", { "type": "deletefile", "pathlist": filepath.toString() }, function (data) {
 if (data == "-999") { alert("登录失效.请重新登录!"); return false; }
 if (data == "1")
 $("#spdelete").hide();
 $("#lablefile").html("");
 })
 })

 /*
 // 文件上传 ------------------------- begin(华丽的分隔符) ---------------------------
 var button = $('#adlaimgFile'), interval;
 new AjaxUpload(button, {
 action: 'userajax/FileMail.ashx',
 name: 'imgFile',
 onSubmit: function (file, ext) {
 this.disable();
 interval = window.setInterval(function () {
 var text = button.text();
 }, 200);
 },
 onComplete: function (file, response) {
 window.clearInterval(interval);
 this.enable();
 response = response.replace(/<pre>/ig, "").replace(/<\/pre>/ig, ""); //过滤
 var obj = $.parseJSON(response);
 if (obj[0].filetruename == "ferror") { alert("该文件类型不允许上传!"); return false; }
 if (obj[0].filetruename == "big") { alert("文件过大!"); return false; }
 filename.push(obj[0].filetruename);
 filepath.push(obj[0].filepath);
 filesize.push(obj[0].filesize);

 LoadJSFile();
 }
 });
 */

 // window.onload = load(); //默认加载收件箱数据
 })
 //dom end

 //标识是否为自己上传变量
 var ismyupload = 1;

 //加载列表
 function LoadJSFile() {
 $("#FilelistTbody").html("");

 if (filename.length > 0) {
 $("#MailFileList2").show();
 }
 else {
 $("#MailFileList2").hide();
 return;
 }
 for (var i = 0; i < filename.length; i++)
 $("#FilelistTbody").append("<tr id='trf" + i + "'><td>" + filename + "</td><td class='center'>" + filesize + "k </td><td class='center'>" + filename.substr(filename.lastIndexOf(".") + 1) + "</td><td class='center'> </td></tr>");
 }

 //删除单个附件
 function deleteBypath(id, i) {
 if(confirm("确定删除吗?")==false)return;

 //不能删除邮件转发的附件
 if (ismyupload == 0) {
 filename.pop(i);
 filepath.pop(i);
 filesize.pop(i);
 $("#trf" + i).remove();
 if (filename.length < 1)
 $("#MailFileList2").hide();
 else
 $("#MailFileList2").show();
 return;
 }
 //物理删除
 $.post("userajax/Mail.aspx", { "type": "deletefileone", "pathlist": id }, function (data) {
 if(data=="-999"){alert("登录失效.请重新登录!");return false;}
 if (data == "1")
 $("#trf" + i).remove();
 filename.pop(i);
 filepath.pop(i);
 filesize.pop(i);
 if (filename.length < 1)
 $("#MailFileList2").hide();
 else
 $("#MailFileList2").show();
 })
 }

 //function for button
 function maildo(type, id,num) {
 //收件箱删除伪删除
 if (type == "deleteinbox") {
 if (confirm("确定删除吗?") == false) return;
 $.post("userajax/Mail.aspx", { "type": "deleteinbox", "userid": userid, "idlist": id }, function (data) {
 if (data == "-999") { alert("登录失效.请重新登录!"); return false; }
 $("#TRList" + num).remove();
 MSG();
 //pagesizeindex = "";
 //GetResBox();
 });
 }
 //发件箱删除伪删除
 else if (type == "deleteoutbox") {
 if (confirm("确定删除吗?") == false) return;
 $.post("userajax/Mail.aspx", { "type": "deleteoutbox", "userid": userid, "idlist": id }, function (data) {
 if (data == "-999") { alert("登录失效.请重新登录!"); return false; }
 $("#TRList" + num).remove();
 MSG();
 //pagesizeindex = "";
 //GetSendBox();
 });
 }
 //回收站返回
 else if (type == "backview") {
 $.post("userajax/Mail.aspx", { "type": "backview", "userid": userid, "idlist": id }, function (data) {
 if (data == "-999") { alert("登录失效.请重新登录!"); return false; }
 $("#TRList" + num).remove();
 MSG();
 //pagesizeindex = "";
 //GetRebBox();
 });
 }
 //回收站彻底删除
 else if (type == "deleteon") {
 if (confirm("确定删除吗?") == false) return;
 $.post("userajax/Mail.aspx", { "type": "deleteon", "userid": userid, "idlist": id }, function (data) {
 if (data == "-999") { alert("登录失效.请重新登录!"); return false; }
 $("#TRList" + num).remove();
 MSG();
 //pagesizeindex = "";
 //GetRebBox();
 });
 }
 //查看邮件
 else if (type == "view") {
 $("#DivViewDT").show();
 $.post("userajax/Mail.aspx", { "type": "view", "userid": userid, "idlist": id }, function (data) {
 if (data == "-999") { alert("登录失效.请重新登录!"); return false; }

 // if ($("#TRList" + id).html().toString().indexOf('新邮件') > -1)
 // $("#TRList" + id).html($("#TRList" + id).html().replace("label label-important", "label").replace("新邮件", "已读"));

 $("#divmaillist").hide();
 $("#DivViewDT").show();

 var obj = $.parseJSON(data);

 $("#ViewTitle").html("邮件主题:" + obj[0].TITLE);
 $("#sendlable").html("发送人:" + obj[0].SENDUSERNAME);
 $("#reserveduname").html("接收人:" + obj[0].RESERVEDNAME);
 $("#sendtime").html("发送时间:" + obj[0].SENDTIME);

 $("#contentlable").html(decodeURIComponent(obj[0].CONTENT));
 MSG();

 });
 //附件
 $("#Tbodyfilelistview").html("");
 $.post("userajax/Mail.aspx", { "type": "file", "id": id }, function (data) {
 if (data == "-999") { alert("登录失效.请重新登录!"); return false; }
 if (data == null || data == "no" || data == "") { $("#Afileresult").html("无附件!"); $("#tablefilelist").hide(); return; }
 $("#Afileresult").html("");
 $("#tablefilelist").show();
 var obj = $.parseJSON(data);
 for (var i = 0; i < obj.length; i++) {
 $("#Tbodyfilelistview").append("<tr><td><a target='_blank' href='Ajax/" + obj.FILEPATH + "'>" + obj.FILENAME + "</a></td><td class='center'>" + obj.FILESIZE + "k </td><td class='center'>" + obj.FILETYPE + "</td><td class='center'> </td></tr>");
 }
 })
 }
 //转发
 else if (type == "forw") {
 $("#divmaillist").hide();
 $("#WNewEmail").show();

 $("#inputSendobj").val("");
 ismyupload = 0; //控制不能删除别人附件
 filename = []; filepath = []; filesize = [];

 //转发带附件的邮件
 $.post("userajax/Mail.aspx", { "type": "file", "id": id }, function (data) {
 if (data == "-999") { alert("登录失效.请重新登录!"); return false; }
 if (data == null || data == "no" || data == "") { $("#lablefile").html(""); return; }
 $("#lablefile").html("");
 var obj = $.parseJSON(data);
 for (var i = 0; i < obj.length; i++) {
 filename.push(obj.FILENAME);
 filepath.push(obj.FILEPATH);
 filesize.push(obj.FILESIZE);
 }
 LoadJSFile();
 })

 $.post("userajax/Mail.aspx", { "type": "view", "userid": userid, "idlist": id }, function (data) {
 if (data == "-999") { alert("登录失效.请重新登录!"); return false; }

 // if ($("#TRList" + id).html().toString().indexOf('新邮件') > -1)
 // $("#TRList" + id).html($("#TRList" + id).html().replace("label label-important", "label").replace("新邮件", "已读"));

 var obj = $.parseJSON(data);

 $("#date01").val(obj[0].TITLE);

 $("#textarea2").val(decodeURIComponent(obj[0].CONTENT));

 MSG();
 })
 }
 //附件
 else if (type == "filedelete" || type == "file") {
 if (type == "filedelete") { alert("回收站中无法查看附件！"); return; }
 $("#DivFiles").modal("show");
 $("#FileListdata").html("");
 $.post("userajax/Mail.aspx", { "type": "file", "id": id }, function (data) {
 if (data == "-999") { alert("登录失效.请重新登录!"); return false; }
 if (data == null || data == "no" || data == "") { $("#fileinfoa").html("无数据!"); return; }
 $("#fileinfoa").html("");
 var obj = $.parseJSON(data);
 for (var i = 0; i < obj.length; i++) {
 $("#FileListdata").append("<tr><td><a target='_blank' href='Ajax/" + obj.FILEPATH + "'>" + obj.FILENAME + "</a></td><td class='center'>" + obj.FILESIZE + "k </td><td class='center'>" + obj.FILETYPE + "</td><td class='center'> </td></tr>");
 }
 })
 }
 }

 //下载
 function downloadfile(fpath) {
 $.post("Ajax/Floor.aspx", { "type": "existsfile", "filep": fpath }, function (data) {
 if (data == "noyes") {
 alert("文件不存在!");
 return;
 }
 else
 window.open("Ajax/" + fpath);
 //location.href = "Ajax/" + fpath;
 });
 }

 //消息提示框
 function MSG() {
 $("#divsysmsg").show();
 setInterval("$('#divsysmsg').hide();", 2000);
 }
 //获取名称
 var scname="scname";
 function GetOrgName(name) {

 if(scname==name){return;}
 scname=name;

 if (name == "'" || name == "," || name == "!" || name == '"') { $("#acount").html("非法字符!"); return; } //过滤字符
 $("#divchecklist").html("");
 $("#imgprogress").show();
 $("#acount").html("");

 $.ajax({
 url: "userajax/Mail.aspx",
 data: { "type": "getorgname", "searchval": name },
 type: "POST",
 beforsend: function () {

 },
 success: function (a) {
 setInterval("$('#imgprogress').hide();", 1500);
 if (a == "-999") { alert("登录失效.请重新登录!"); return false; }
 if (a == "no") { $("#acount").html("0条结果"); return false; } //无数据
 var obj = $.parseJSON(a);
 $("#acount").html(obj.length + "条结果"); //get counts number
 for (var i = 0; i < obj.length; i++) {

 if (exists(obj.USERID) == true)
 $("#divchecklist").append("<input checked='checked' type='checkbox' myname='" + obj.MYUSERNAME + "' name='checkboxA' id='" + obj.USERID + "' />" + obj.MYUSERNAME + "");
 else
 $("#divchecklist").append("<input type='checkbox' myname='" + obj.MYUSERNAME + "' name='checkboxA' id='" + obj.USERID + "' />" + obj.MYUSERNAME + "");
 }
 }
 })
 }

 //判断是否选中该数据
 function exists(id) {
 for (var i = 0; i < ckidlist.length; i++) {
 if (ckidlist == id)
 return true;
 }
 return false;
 }

 //发
 function GetSendBox() {
 $("#thlable009").html("收件人");
 gettype = 1;
 $("#DivViewDT").hide();
 $("#divmaillist").show();

 if (pagesizeindex == "")
 $("#datalist").html("");

 $("#WNewEmail").hide();
 $("#divshow").show();
 $("#hlistname").html("发件箱");

 $.post("userajax/Mail.aspx", { "type": "getmysenddata", "userid": userid, "searchtype": "1", "pagesizeindex": pagesizeindex }, function (data) {
 if (data == "-999") { alert("登录失效.请重新登录!"); return false; }
 if (data == null || data == "no" || data == "") { $("#datainfoa").html("无数据!"); $("#btnmore").hide(); return; }
 $("#datainfoa").html("");

 var objresult = $.parseJSON(data);

 if (objresult == null) {
 $("#btnmore").hide();
 return;
 }

 pagesizeindex = objresult[objresult.length - 1].sorttime;

 if (objresult.length < persize)
 $("#btnmore").hide();
 else
 $("#btnmore").show();

 for (var i = 0; i < objresult.length; i++) {
 $("#datalist").append("<tr id='TRList" + objresult.sorttime + "'><td>" + objresult.RESERVEDNAME + "</td><td class='center'>" + objresult.SENDTIME + "</td><td class='center'>" + objresult.TITLE + "</td><td class='center'>" + "已发送" + "</td><td>" + (objresult.ISATTACHFILE == '1' ? "" : " ") + "</td><td class='center'><table border='0'><tr border='0'><td><a class='btn btn-success' onclick=maildo('view','" + objresult.ID + "," + objresult.FID + "','" + objresult.sorttime + "')> 查看</a></td><td><a class='btn btn-info' onclick=maildo('forw','" + objresult.ID + "," + objresult.FID + "','" + objresult.sorttime + "')> 转发</a></td><td><a class='btn btn-danger' onclick=maildo('deleteoutbox','" + objresult.ID + "," + objresult.FID + "','" + objresult.sorttime + "')> 删除</a></td></tr></table></td></tr>");
 }
 })
 }

 //收
 function GetResBox() {
 $("#thlable009").html("发件人");
 gettype = 0;
 $("#DivViewDT").hide();
 $("#divmaillist").show();

 if (pagesizeindex == "")
 $("#datalist").html("");

 $("#WNewEmail").hide();
 $("#divshow").show();
 $("#hlistname").html("收件箱");

 $.post("userajax/Mail.aspx", { "type": "getmysenddata", "userid": userid, "searchtype": "0", "pagesizeindex": pagesizeindex }, function (data) {
 if (data == "-999") { alert("登录失效.请重新登录!"); return false; }
 if (data == null || data == "no" || data == "") { $("#datainfoa").html("无数据!"); $("#btnmore").hide(); return; }
 $("#datainfoa").html("");
 var objresult = $.parseJSON(data);

 if (objresult == null) {
 $("#btnmore").hide();
 return;
 }

 pagesizeindex = objresult[objresult.length - 1].sorttime;

 if (objresult.length < persize)
 $("#btnmore").hide();
 else
 $("#btnmore").show();

 for (var i = 0; i < objresult.length; i++) {
 $("#datalist").append("<tr id='TRList" + objresult.sorttime + "'><td>" + objresult.SENDUSERNAME + "</td><td class='center'>" + objresult.SENDTIME + "</td><td class='center'>" + objresult.TITLE + "</td><td class='center'>" + (objresult.STATUE == "0" || objresult.STATUE == 0 ? "" : "") + "" + (objresult.STATUE == "0" || objresult.STATUE == 0 ? "新邮件" : "已读") + "</td><td>" + (objresult.ISATTACHFILE == '1' ? "" : " ") + "</td><td class='center'><table border='0'><tr border='0'><td><a class='btn btn-success' onclick=maildo('view','" + objresult.ID + "," + objresult.FID + "','" + objresult.sorttime + "')> 查看</a></td><td><a class='btn btn-info' onclick=maildo('forw','" + objresult.ID + "," + objresult.FID + "','" + objresult.sorttime + "')> 转发</a></td><td><a class='btn btn-danger' onclick=maildo('deleteinbox','" + objresult.ID + "," + objresult.FID + "','" + objresult.sorttime + "')> 删除</a></td></tr></table></td></tr>");
 }
 })
 }

 //回
 function GetRebBox() {
 $("#thlable009").html("收件人");
 gettype = 2;
 $("#DivViewDT").hide();
 $("#divmaillist").show();

 if (pagesizeindex == "")
 $("#datalist").html("");

 $("#WNewEmail").hide();
 $("#divshow").show();
 $("#hlistname").html("回收站");

 $.post("userajax/Mail.aspx", { "type": "getmysenddata", "userid": userid, "searchtype": "2", "pagesizeindex": pagesizeindex }, function (data) {

 if (data == "-999") { alert("登录失效.请重新登录!"); return false; }

 if (data == null || data == "no" || data == "") { $("#datainfoa").html("无数据!"); $("#btnmore").hide(); return; }

 $("#datainfoa").html("");
 var objresult = $.parseJSON(data);

 if (objresult == null) {
 $("#btnmore").hide();
 return;
 }

 pagesizeindex = objresult[objresult.length - 1].sorttime;

 if (objresult.length < persize)
 $("#btnmore").hide();
 else
 $("#btnmore").show();

 for (var i = 0; i < objresult.length; i++) {
 $("#datalist").append("<tr id='TRList" + objresult.sorttime + "'><td>" + objresult.RESERVEDNAME + "</td><td class='center'>" + objresult.SENDTIME + "</td><td class='center'>" + objresult.TITLE + "</td><td class='center'>已进回收站</td><td>" + (objresult.ISATTACHFILE == '1' ? "" : " ") + "</td><td class='center'><table border='0'><tr border='0'><td><a class='btn btn-success' onclick=maildo('backview','" + objresult.ID + "," + objresult.FID + "','" + objresult.sorttime + "')> 还原</a></td><td><a class='btn btn-danger' onclick=maildo('deleteon','" + objresult.ID + "," + objresult.FID + "','" + objresult.sorttime + "')> 彻底删除</a></td></tr></table></td></tr>");
 }
 })
 }
复制代码

底层实现
 （分条数获取数据）

object obj = Request.Form.Get("type");

 if (obj == null || obj.ToString() == "") { Response.Write("error"); Response.End(); }

 //收件箱发件箱回收站
 if (obj.ToString() == "getmysenddata")
 Response.Write(getmysenddata(Common.GetUserCode(), int.Parse(Request.Form.Get("searchtype")), Request.Form.Get("pagesizeindex")));
 //收件箱删除
 else if (obj.ToString() == "deleteinbox")
 Response.Write(deletevirtual(Common.GetUserCode(), Request.Form.Get("idlist")).ToString());
 //发件箱删除
 else if (obj.ToString() == "deleteoutbox")
 Response.Write(deletevirtual(Common.GetUserCode(), Request.Form.Get("idlist"), 2).ToString());
 //还原
 else if (obj.ToString() == "backview")
 Response.Write(UpdateToBackBox(Request.Form.Get("idlist")).ToString());
 //彻底删除
 else if (obj.ToString() == "deleteon")
 Response.Write(deleteon(Request.Form.Get("idlist")).ToString());
 //查看
 else if (obj.ToString() == "view")
 Response.Write(UpdateNumStatue(Request.Form.Get("idlist")));
 //发送新邮件
 else if (obj.ToString() == "addmsg")
 Response.Write(AddMsg() + "");
 //查看附件
 else if (obj.ToString() == "file")
 Response.Write(GetOneMailFiles(Request.Form.Get("id")));
 //删除自己上传的附件
 else if (obj.ToString() == "deletefile")
 Response.Write(DeleteFileByMyself(Request.Form.Get("pathlist")).ToString());
 //删除自己上传的附件
 else if (obj.ToString() == "deletefileone")
 Response.Write(DeleteFileByMyself(Request.Form.Get("pathlist"), 1).ToString());
 //获取机构名称
 else if (obj.ToString() == "getorgname")
 Response.Write(GetOrganizationName());
 //查询用户消息
 else if (obj.ToString() == "getusernews")
 Response.Write(GetNewsByNotRead(Common.GetUserCode()));

最后
 需要源码的进入：http://10086bank.com/ 点击邮件进入底部下载即可。

 人一辈子不会因为你做了什么而后悔，只会因为你没做什么而后悔。

 2014年，不平凡的一年。

END

账号		自动登录	找回密码
密码			立即注册

wirelessnetview好用的无线分析工具

Red Hat RHCE 8 (EX294) Cert Guide

Shell从入门到精通（阿良）

亿图图示专家(EDraw Max) V7.9 中文破解版

zabbix3.4.1安装部署+微信推送信息+大屏显

Red Hat OpenShift I: Containers & Kubern

2025 年，C++ 还能“硬核”多久？

[经验分享] Jquery+Ajax+asp.net+sqlserver-编写的通用邮件管理(源码)

浏览过的版块

扫码加入运维网微信交流群