黑冰第2部电视剧,近日新闻,救赎方舟
本文实例讲述了asp.net(c#)读取数据库并生成js文件制作首页图片切换效果的方法。分享给大家供大家参考，具体如下：
我要评论
using system;
using system.collections.generic;
using system.linq;
using system.web;
using system.web.ui;
using system.web.ui.webcontrols;
using system.text;
using system.io;
public partial class _default : system.web.ui.page
{
protected void page_load(object sender, eventargs e)
{
}
/// <summary>
/// 利用模板生成静态页面
/// </summary>
/// <param name="strtitle">标题</param>
/// <param name="strtext">作者</param>
/// <param name="strcontent">发布时间</param>
/// <param name="strauthor">内容</param>
/// <returns>生成页面名称</returns>
public static string writefile(string strtitle, string strauthor, string strdate, string strcontent)
{
string path = httpcontext.current.server.mappath("~/");
encoding code = encoding.getencoding("gb2312");
// 读取模板文件
string temp = httpcontext.current.server.mappath("~/template.html");
streamreader sr = null;
streamwriter sw = null;
string str = "";
try
{
sr = new streamreader(temp, code);
str = sr.readtoend(); // 读取文件
}
catch (exception exp)
{
httpcontext.current.response.write(exp.message);
httpcontext.current.response.end();
sr.close();
}
random rd = new random();
string strrd = rd.next(0, 9999).tostring();
string htmlfilename = datetime.now.tostring("yyyymmddhhmmss") + strrd + ".html";
datetime dtnow = datetime.now;
// 替换内容
str = str.replace("$biaoti", strtitle);
str = str.replace("$author", strauthor);
str = str.replace("$datetime", strdate);
str = str.replace("$content", strcontent);
// 写文件
try
{
string pathurl = path + dtnow.year + "\\" + dtnow.month + "\\" + dtnow.day;
if (!directory.exists(pathurl))
{
directory.createdirectory(pathurl);
}
sw = new streamwriter(pathurl + "\\" + htmlfilename, false, code);
sw.write(str);
sw.flush();
}
catch (exception ex)
{
httpcontext.current.response.write(ex.message);
httpcontext.current.response.end();
}
finally
{
sw.close();
}
return dtnow.year.tostring() + "/" + dtnow.month.tostring() + "/" + dtnow.day.tostring() + "/" + htmlfilename;
}
protected void button1_click(object sender, eventargs e)
{
writefile("title" , "ttttttt" , "2011-09-27", "测试 <br>");
}
}
template.html
<table>
<tr>
<td align="center">$biaoti</td>
</tr>
<tr>
<td align="center">作者：$author 发布时间：$datetime</td>
</tr>
<tr>
<td>$content</td>
</tr>
</table>
思路：首先读取数据库中图片，链接，说明文字等数据，然后将读取到的数据写入首页图片切换效果的js文件。
下面代码实现向数据库中增加 图片、链接、说明文字等数据 和 生成js文件
using system;
using system.data;
using system.configuration;
using system.collections;
using system.web;
using system.web.security;
using system.web.ui;
using system.web.ui.webcontrols;
using system.web.ui.webcontrols.webparts;
using system.web.ui.htmlcontrols;
using system.data.oledb;
using system.io;
using system.text;
public partial class admin_slide : system.web.ui.page protected void page_load(object sender, eventargs e)
{
}
protected void add_btn_click(object sender, eventargs e) //增加幻灯片,将信息写入数据库 string imgpath;
imgpath = "../uploadfiles/slideimg/" + imgup.filename;
imgup.saveas(server.mappath(imgpath));
myoledb mc = new myoledb();
mc.connopen();
oledbcommand cmd = new oledbcommand("insert into slideimg(lnk,pic,txt) values ('" + linkarea.text.tostring() + "','" + imgpath + "','" + imgtitle.text.tostring() + "');", mc.conn);
oledbdatareader rdr = null;
rdr = cmd.executereader();
mc.connclose();
}
protected void mjs_btn_click(object sender, eventargs e) //生成js幻灯文件 string jsfile,jstemplete;
string strlnk, strpic, strtxt;
strlnk = null;
strpic = null;
strtxt = null;
jsfile = server.mappath("~/js/") + "slideimg.js"; //js文件路径
jstemplete = server.mappath("~/js/") + "jstemplete.js"; //js文件模板路径
deljs(jsfile); //删除js文件
myoledb mc = new myoledb();
mc.connopen();
oledbcommand cmd = new oledbcommand("select top " + img_num.text.tostring() + " * from slideimg order by id desc", mc.conn);
oledbdatareader rdr = null;
rdr = cmd.executereader();
while (rdr.read()) strlnk += rdr["lnk"].tostring() + "|";
strpic += rdr["pic"].tostring() + "|";
strtxt += rdr["txt"].tostring() + "|"; mc.connclose();
encoding code = encoding.getencoding("utf-8");
streamreader sr = null;
streamwriter sw = null;
string str = "";
try sr = new streamreader(jstemplete, code);
str = sr.readtoend(); // 读取文件 catch (exception exp) httpcontext.current.response.write("<script type='text/javascript'>alert('读取模板文件错误！')</script>" + exp.message);
httpcontext.current.response.end();
sr.close();
}
// 替换内容 str = str.replace("$txt$", strtxt);
str = str.replace("$pic$", strpic);
str = str.replace("$lnk$", strlnk);
try sw = new streamwriter(jsfile, false, code);
sw.write(str);
sw.flush(); catch (exception ex) httpcontext.current.response.write("<script type='text/javascript'>alert('生成js文件出错！')</script>" + ex.message);
httpcontext.current.response.end(); finally sw.flush();
sw.close();
}
}
//以下是自定义删除原有js文件函数
protected void deljs(string jsfile) if (file.exists(jsfile)) file.delete(jsfile); else response.write("<script type='text/javascript'>alert('系统中不存在能产生首页切换图片的文件！')</script>"); }
}
js文件模板 jstemplete.js
var focus_width=300;
var focus_height=225;
var text_height=18;
var swf_height = focus_height+text_height;
var pics,links,texts;
texts='$txt$' //将被替换的内容（切换图片的说明文字）
pics='$pic$' //将被替换的内容（切换图片的地址）
links='$lnk$' //将被替换的内容（链接地址）
pics=pics.substr(0,pics.length-1);
links=links.substr(0,links.length-1);
texts=texts.substr(0,texts.length-1);
var fv="pics="+pics+"&links="+links+"&texts="+texts+"&borderwidth="+focus_width+"&borderheight="+focus_height+"&textheight="+text_height;
document.write('<object classid="clsid:d27cdb6e-ae6d-11cf-96b8-444553540000" codebase="http://fpdownload.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=6,0,0,0" width="'+ focus_width +'" height="'+ swf_height +'">');
document.write('<param name="allowscriptaccess" value="samedomain"><param name="movie" value="../plugin/slide.swf"><param name="quality" value="high"><param name="bgcolor" value="#e5ecf4">');
document.write('<param name="menu" value="false"><param name=wmode value="opaque">');
document.write('<param name="flashvars" value="pics='+pics+'&links='+links+'&texts='+texts+'&borderwidth='+focus_width+'&borderheight='+focus_height+'&textheight='+text_height+'">');
document.write('<embed src="pixviewer.swf" wmode="opaque" flashvars="pics='+pics+'&links='+links+'&texts='+texts+'&borderwidth='+focus_width+'&borderheight='+focus_height+'&textheight='+text_height+'" menu="false" bgcolor="#009900" quality="high" width="'+ focus_width +'" height="'+ focus_height +'" allowscriptaccess="samedomain" type="application/x-shockwave-flash" pluginspage="http://www.macromedia.com/go/getflashplayer" />');
document.write('</object>');
办法三
<script language="javascript" src="js.aspx?classid=2"> </script>
js.aspx输出的是js内容就可以了
然后在这个abc.aspx里读取数据库，并生成document.write输出新闻的语句
<%@ page language="c#" autoeventwireup="true" %> var focus_width="asdasdasdwer"; document.write(focus_width);
完整实例代码点击此处。
更多关于asp.net相关内容感兴趣的读者可查看本站专题：《asp.net文件操作技巧汇总》、《asp.net ajax技巧总结专题》及《asp.net缓存操作技巧总结》。
希望本文所述对大家asp.net程序设计有所帮助。
如对本文有疑问，请在下面进行留言讨论，广大热心网友会与你互动！！ 点击进行留言回复
Net Core Web Api项目与在NginX下发布的方法
asp.net core3.1 引用的元包dll版本兼容性问题解决方案
IdentityServer4实现.Net Core API接口权限认证(快速入门)
ASP.NET Core MVC通过IViewLocationExpander扩展视图搜索路径的实现
网友评论