asp.net新闻列表生成静态页之批量和单页生成

 using System; using System.Web; using System.Data.SqlClient; using System.Data; using System.Collections.Generic; using System.Web.Script.Serialization; using System.Web.UI.HtmlControls; using System.Web.UI.WebControls; using System.Text; using System.IO; using System.Net; namespace Web.admin { public partial class newslist : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { HttpCookie hcname = Request.Cookies["backname"]; if (hcname != null) { string s = Request.Url.ToString().Substring(Request.Url.ToString().LastIndexOf('/') + 1); if (s.IndexOf("?") > -1) s = s.Substring(0, s.IndexOf("?")); HttpCookie hc1 = new HttpCookie("backUrl", s); hc1.Expires = DateTime.Now.AddMinutes(120); Response.Cookies.Add(hc1); string title = this.Page.Title.ToString(); HttpCookie hc2 = new HttpCookie("backTitle", Server.UrlEncode(title)); hc2.Expires = DateTime.Now.AddMinutes(120); Response.Cookies.Add(hc2); Bind(); } else { this.Page.RegisterStartupScript("aaa", ""); } } } public void Bind() { SqlParameter[] parms = new SqlParameter[] { new SqlParameter("@FEILDS",SqlDbType.NVarChar,1000), new SqlParameter("@PAGE_INDEX",SqlDbType.Int,10), new SqlParameter("@PAGE_SIZE",SqlDbType.Int,10), new SqlParameter("@ORDERTYPE",SqlDbType.Int,2), new SqlParameter("@ANDWHERE",SqlDbType.VarChar,1000), new SqlParameter("@ORDERFEILD",SqlDbType.VarChar,100), new SqlParameter("@TABLENAME",SqlDbType.VarChar,100) }; parms[0].Value = "id,Name,Dir,Static,Url";//获取所有的字段 parms[1].Value = page();//当前页面索引 parms[2].Value = 10;//页面大小 parms[3].Value = paixu();//升序排列 parms[4].Value = "(Name like '%" + keyword() + "%')";//条件语句 parms[5].Value = paixuziduan();//排序字段 parms[6].Value = "HotelInfo";//表名 DataTable dt = new DataTable(); using (SqlDataReader sdr = Yoodor.DAL.SqlHelper.ExecuteReader(CommandType.StoredProcedure, "PAGINATION", parms)) { dt.Load(sdr); R1.DataSource = dt; R1.DataBind(); } if (keyword() != null && keyword() != "none") { text_word.Value = keyword(); } } public int page() { int PageNumber = Request.QueryString["page"] != null ? Convert.ToInt32(Request.QueryString["page"].ToString()) : 1; return PageNumber; } public string keyword() { string key = Request.QueryString["keyword"] != null ? Request.QueryString["keyword"].ToString() : ""; return key; } public string type() { string key = Request.QueryString["type"] != null ? Request.QueryString["type"].ToString() : ""; return key; } public string paixuziduan() { string str = ""; string s = Request.QueryString["field"]; if (s != null) { str = s; } else { str = "Id"; } return str; } public int paixu() { string asc = Request.QueryString["asc"]; if (asc != null) { if (asc == "desc") { return 0; } else { return 1; } } else { return 1; } } //分页事件 protected void AspNetPager1_PageChanged1(object sender, EventArgs e) { Bind(); } protected void AspNetPager1_Load(object sender, EventArgs e) { string count = new BLL.f_article().SelectAllNum(keyword(), type()); AspNetPager1.RecordCount = Convert.ToInt32(count); lab_num.Text = "共" + count + "条记录。"; text_pagecount.Value = AspNetPager1.PageCount.ToString(); } protected void R1_ItemDataBound(object sender, RepeaterItemEventArgs e) { if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem) { CheckBox ch = (CheckBox)e.Item.FindControl("chkItem"); HtmlInputHidden tid = (HtmlInputHidden)e.Item.FindControl("text_id"); ch.Attributes.Add("onclick", "checks(" + tid.Value + ")"); Label state = (Label)e.Item.FindControl("lab_state"); if (state.Text == "0") { state.Text = "未静态"; state.ForeColor = System.Drawing.Color.Red; } else { state.Text = "已静态"; } } } //搜索 protected void Button1_Click(object sender, EventArgs e) { string keyword = text_word.Value.Trim(); Response.Redirect("list.aspx?keyword=" + keyword, false); } } }

 $(function () { //创建弹出提示框 var divdialog = '
'; $(document.body).append(divdialog); //表格行，鼠标放上去变色 $(".tr:odd").css("background", "#FFFCEA"); $(".tr:odd").each(function () { $(this).hover(function () { $(this).css("background-color", "#F5F8F9"); }, function () { $(this).css("background-color", "#FFFCEA"); }); }); $(".tr:even").each(function () { $(this).hover(function () { $(this).css("background-color", "#F5F8F9"); }, function () { $(this).css("background-color", "#fff"); }); }); //生成静态页 $(".Static").click(function () { var url = $(this).attr("data-url"); var path = $(this).attr("data-path"); var href = $(this).attr("data-href"); var tablename = $(this).attr("data-table"); var actid = $(this).attr("data-act"); //0 表示生成当前选中项 var ids = $("#text_delid").val(); var page = $("#text_page").val(); var pagecount = $("#text_pagecount").val(); if (actid == 0) { if (ids == "") { dialog(1, '请先选择！'); return false; } } $.ajax({ url: "ashx/Static.ashx", data: { "geturl": url, "getpath": path, "act": actid, "id": ids, "pages": page, "pagecouts": pagecount, "table": tablename }, type: "post", beforeSend: function (data) { doProgress(href, "生成成功!"); }, success: function (data) { doProgress(href, data); } }) }) }); var progress_id = "loading"; function SetProgress(progress) { if (progress) { $("#" + progress_id + " > div").css({ "width": String(progress) + "%", "background": "#F4A830" }); //控制#loading div宽度 $("#" + progress_id + " > div").html(String(progress) + "%"); //显示百分比 } } var i = 0; function doProgress(href, msg) { $("#loading").show(); if (i > 100) { $("#message").html(msg).fadeIn("fast");//加载完毕提示 // window.location.href = href; $("#loading").hide(); dialog(0, msg, href, 1000); return; } if (i <= 100) { setTimeout("doProgress('"+href+"','"+msg+"')", 1); SetProgress(i); i++; } } function checks(id) { var spid = ""; spid += id + ","; var aa = $("#text_delid").val(); if ($("#labe_" + id + " input").attr("checked")) { // $("#tr_" + id).css("background","#000"); $("#text_delid").val(aa + spid); return false; } else { //$("#tr_" + id).removeClass("hover1"); if (aa.indexOf(id) > -1) { var b = aa.replace(id + ",", ""); $("#text_delid").val(b); } } } //删除确认框 function dels(tablename,url) { var id = $("#text_delid").val(); if (id == "") { dialog(1, '请先选择！'); return false;} else {$("#divdialog").hide(); suredialog(id, "您确定要删除吗？删除之后信息将不再显示！",tablename,url); return false;}} function newdels() { var tablename = $("#text_table").val(); var url = "type.aspx?table=" + tablename; var id = $("#text_delid").val(); if (id == "") { dialog(1, '请先选择！'); return false; } else { $("#divdialog").hide(); suredialog(id, "您确定要删除吗？删除之后信息将不再显示！", tablename, url); return false; } } //全选反选 function QuanXuan() { $(':checkbox').each(function () { $(this).attr("checked", true); var spid = ""; var id = $(this).parent('span').attr("title"); spid += id + ","; var aa = $("#text_delid").val(); $("#text_delid").val(aa + spid); })} function FanXuan() { $(':checkbox').each(function () { $(this).attr("checked", false); $("#text_delid").val(''); })} //删除信息 function deleteinfor(ids, table,url) { $("#divsuredialog").hide(); var page = $('#text_page').val(); $.post("ashx/delete.ashx?id=" + ids + "&table=" + table + "", null, function (data) { if (data == 1) { if (url.indexOf("type.aspx") > -1) { dialog(0, '删除成功', url, 1000); } else { dialog(0, '删除成功', url + '?page=' + page + '', 1000); } } else { dialog(2, '删除失败', url + '?page=' + page + '', 1000);} }); } var dlog; var pp = false; KindEditor.ready(function (K) { K('.a_1').click(function () { $("#divsuredialog").hide(); $("#divdialog").hide(); var id = $(this).attr("data-id"); var value1 = $(this).attr("data-value"); var value = ""; var html = ""; if ($(this).html().indexOf('通过')>-1) { value = value1; html="修改审核状态（点击确定即可）" } else { value = $(this).html(); html = "修改信息"; } var field = $(this).attr("data-field"); var table = $(this).attr("data-table"); var url = $(this).attr("data-url"); dlog = K.dialog({ width: 260, title: html, body: "
", closeBtn: { name: '关闭', click: function (e) { dlog.remove(); } } }); }); K('#newsadd').click(function () { $("#divsuredialog").hide(); $("#divdialog").hide(); dlog = K.dialog({ width: 260, title: '新增分类', body: "
", closeBtn: { name: '关闭', click: function (e) { dlog.remove(); } } }); }); }); //修改信息 function upateinfor(ids, fieldname, tablename, url) { var page = $('#text_page').val(); var value = $("#text_updatevalue").val(); $.post("ashx/update.ashx?id=" + ids + "&table=" + tablename + "&field=" + fieldname + "&value=" + escape(value) + "", null, function (data) { if (data == 1) { closedlog(); if (url.indexOf("type.aspx") > -1) { dialog(0, '修改成功', url, 1000); } else { dialog(0, '修改成功', url + '?page=' + page + '', 1000); } } else { closedlog(); dialog(2, '修改失败', url+'?page=' + page + '', 1000); } }); } //修改信息 带值 function upateinforss(ids, value, fieldname, tablename, url) { var page = $('#text_page').val(); $.post("ashx/update.ashx?id=" + ids + "&table=" + tablename + "&field=" + fieldname + "&value=" + escape(value) + "", null, function (data) { if (data == 1) { $("#div_tip").hide(); if (url.indexOf("type.aspx") > -1) { dialog(0, '修改成功', url , 1000); } else { dialog(0, '修改成功', url + '?page=' + page + '', 1000); } } else { closedlog(); dialog(2, '修改失败', url + '?page=' + page + '', 1000); } }); } //增加分类 function inserttype(){ var value = $("#text_typevalue").val(); var table = $("#text_table").val(); var url = "type.aspx?table="+table; var page = $('#text_page').val(); $.post("ashx/insert.ashx?table="+table+"&value=" + escape(value) + "", null, function (data) { if (data == 1) { closedlog(); dialog(0, '添加成功', url, 1000); } else { closedlog(); dialog(2, '添加失败', url , 1000); } }); } function closedlog() { dlog.remove(); } //弹出删除 确认对话框 function suredialog(id, msg, tablename,url) { var html = "
系统提示
    
"; $("#divsuredialog").show(); $("#divsuredialog").html(html); $(".sure_content").html(msg); }