vici框架写的留言板

来源：互联网发布：手机淘宝教育编辑：程序博客网时间：2024/06/06 12:40

下面是我用vici框架写的留言板，很简单，主要是学习vici，入门还是有必要的。

guestbook.htm:

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml"><head> <title></title> <mce:style type="text/css"></mce:style><style type="text/css" mce_bogus="1"> body { color:#000000; font:12px/18px Tahoma,Arial,Simsun,"宋体"; } #contain { margin:auto; width:950px; height:auto; } .wtag { width:20px; height:100%; } .htag { height:20px; width:100%; } * { margin:0; padding:0; } #header { width:950px; height:auto; } .topInfo_wide { background:url("../img/navBg2.png") no-repeat scroll 0 15px transparent; height:34px; line-height:34px; padding-top:15px; position:relative; text-align:right; z-index:3; } .navList_wide { float:left; padding-left:2px; } .topInfo_wide .qsLink { color:#83A90D; font-weight:bold; } .navList_wide a { background:url("../img/navLineBg.png") no-repeat scroll right center transparent; color:#FFFFFF; display:inline; float:left; font-size:14px; padding:0 15px 0 13px; } a { color:#010101; text-decoration:none; } #content { width:950px; height:auto; } ul li { list-style:none outside none; } .leftcon { width:650px; height :auto; border :0px solid #cccccc; margin:0px; padding :5px 10px 5px 10px; float:left; } .rightcon { width:255px; height :auto; border :0px solid #cccccc; margin:0px; padding :5px 10px 5px 10px; float:right; } .guestbook_box { width:630px; height:100px; padding:5px 10px 5px 10px; margin:auto; background:none repeat scroll 0 0 #F0F5F8; } .box_top, .box_content { width:100%; height:auto; margin-bottom:20px; } .top_title { float:left; padding-left:10px; } .top_writer { float:right; padding-right:10px; font-size:14px; } .box_content_left { width:530px; height:auto; float:left; } .box_content_right { width:95px; height:auto; float:right; padding-top:30px; } .ulmesg li { border-bottom:1px solid #E3EEF8; } .boxcontent,.bookperson { font-size:12px; width:630px; height:auto; margin-bottom:20px; padding:5px 10px 5px 10px; } .guestcontent { width:530px; height:80px; padding-left:10px; float:right; } .help { width:100%; height:auto; border:1px solid #CCCCCC; margin-bottom:20px; overflow:auto; } .spot_title { background:none repeat scroll 0 0 #F9F9F9; border-bottom:1px solid #ECECEC; color:#333333; font-size:12px; padding:3px 5px 4px 15px; } .shige { padding:5px 10px 5px 10px; line-height:20px; font-size:12px; } </style></head><body><mce:script type="text/javascript" src="../js/jquery.pagination.js" mce_src="js/jquery.pagination.js"></mce:script><mce:script type="text/javascript"></mce:script><div id="contain"><div id="header"> <div class="htag"></div> <div class="topInfo_wide"> <p collection="Y" class="navList_wide"> <a class="qsLink" href="~/index" mce_href="~/index">首页</a> <a class="yule" href="~/goalguide" mce_href="~/goalguide">目的地指南</a> <a class="dyLink" href="~/recommend" mce_href="~/recommend">景点指南</a> <a class="dsjLink" href="~/guestbook" mce_href="~/guestbook">留言板</a> </p> </div></div><div id="content"><div class="htag"></div><div class="leftcon"><div class="guestbook_box"><div class="box_top"><h2 class="top_title">留言板</h2><span class="top_writer">青柠</span></div><div class="box_content"><form method="post" action=""><div class="box_content_left"><textarea name ="guestbox_content" id="des" rows="2" cols="20" style="width:100%; height:auto;">

来客留言：

{{mesg._contents}}
留言人：{{mesg._writer}}时间：{{mesg._date}}

公告栏

欢迎来到青柠旅游网，本网站由目的地搜索，景点搜索，全国范围内省会城市旅游信息搜索等组成，我们本着顾客是上帝的原则将竭诚为您服务，您的肯定和认可是对我们工作的最大支持，谢谢！

诗歌

北方的冬天是冬天，
满眼黄沙漠漠的地与天：
赤膊的树枝，硬搅着北风先——
一队队敢死的健儿，傲立在战阵前！
不留半片残青，没有一丝粘恋，
只拼着精光的筋骨；凝敛着生命的精液，
耐，耐三冬的霜鞭与雪拳与风剑，
直耐到春阳征服了消杀与枯寂与凶惨，
直耐到春阳打开了生命的牢监，放出一瓣的树头鲜！
直耐到忍耐的奋斗功效见，健儿克敌回家酣笑颜！
北方的冬天是冬天！
满眼黄沙茫茫的地与天；
田里一只困顿的黄牛，
西天边画出几线的悲鸣雁。
摘抄自《徐志摩诗全集》

guestbook.cs:

using System;using System.Collections.Generic;using System.Linq;using System.Web;using Vici.Mvc;namespace Demo.ViciMvc{ public class guestbook:BaseController { [BeforeAction] public void RegisterCss() { View.RegisterCSSInclude("css","~/Content/css/guestbook.css"); } public void Run() { // ViewData["message"] = DataService.GetAllMesgFromGuestBook(); int page_num = DataService.PageCount("GuestBook",8); ViewData["page_num"] = page_num; } [Ajax("postMesgToGuestBook")] public static object PostGetBookMesg(string writer,string contents) { DateTime data = DateTime.Now; int id = DataService.InsertGusetBookReturnId(writer ,contents ,data ); return new { result = id, MesgList = DataService.GetMesgFromGuestBook("GuestBook",id) }; } [Ajax("pagination")] public static object Pagination(int pageIndex) { return new { MessageList=DataService.SelectGuestBook (pageIndex,8) }; } }} dataserver.cs:

/// <summary> /// 从表GuestBook提取单条信息 /// </summary> /// <param name="table_name"></param> /// <returns></returns> public static List<GuestBook> GetMesgFromGuestBook(string table,int id) { DataSet ds = DBHelper.GetMesgOnId(table,id ); List<GuestBook> guestbook = new List<GuestBook>(); if (ds.Tables[0].Rows.Count > 0) { foreach (DataRow row in ds.Tables[0].Rows) { guestbook.Add(InitGuestBook(row)); } } return guestbook; } /// <summary> /// 存入数据库，并得到受影响的行ID /// </summary> /// <param name="writer"></param> /// <param name="contents"></param> /// <param name="date"></param> /// <returns></returns> public static int InsertGusetBookReturnId(string writer,string contents,DateTime date) { string str = "insert into GuestBook(writer,contents,date) values('"+writer+"','"+contents+"','"+date+"')"; return DBHelper.InsertTableReturnId(str,"GuestBook"); } /// <summary> /// 从GuestBook提取全部信息 /// </summary> /// <returns></returns> public static List<GuestBook> GetAllMesgFromGuestBook() { DataSet ds = DBHelper.GetMesgOnlyTable("GuestBook"); List<GuestBook> guestbook = new List<GuestBook>(); if (ds.Tables[0].Rows.Count > 0) { foreach (DataRow row in ds.Tables[0].Rows) { guestbook.Add(InitGuestBook(row)); } } return guestbook; } /// <summary> /// 留言板分页数据调用 /// </summary> /// <param name="page_index"></param> /// <returns></returns> public static List<GuestBook> SelectGuestBook(int page_index,int count) { int num = page_index * count; string str = "select top "+count+" * from GuestBook where id not in(select top " + num + " id from GuestBook order by id desc ) order by id desc"; DataSet ds = DBHelper.GetMesg(str); List<GuestBook> lMesg = new List<GuestBook>(); if (ds.Tables[0].Rows.Count > 0) { foreach (DataRow row in ds.Tables[0].Rows) { lMesg.Add(InitGuestBook(row)); } } return lMesg; } /// <summary> /// 求分页数方法，可重复使用 /// </summary> /// <returns></returns> public static int PageCount(string table,int count) { string str = "select * from "+table+""; page.DataSource = DBHelper.GetMesg(str).Tables[0].DefaultView; page.AllowPaging = true; page.PageSize = count; return page.PageCount; } DbHelper.cs:

/// <summary> /// 写入数据库同时返回受影响的行号 /// </summary> /// <param name="str"></param> /// <param name="table"></param> /// <returns></returns> public static int InsertTableReturnId(string str,string table) { using (SqlConnection conn = new SqlConnection(strConn)) { int result = 0; SqlCommand comm = new SqlCommand(str, conn); conn.Open(); int row = comm.ExecuteNonQuery(); if (row != 0) { comm.CommandText = "select max(id) from "+table +""; SqlDataReader dr = comm.ExecuteReader(); while (dr.Read()) { result = dr.GetInt32(0); } return result; } else { return result; } } } /// <summary> /// 从数据库提取信息 /// </summary> /// <param name="str">sql语句 </param> /// <returns></returns> public static DataSet GetMesg(string str) { using (SqlConnection conn = new SqlConnection(strConn)) { SqlCommand comm = new SqlCommand(str, conn); conn.Open(); SqlDataAdapter sqlDa = new SqlDataAdapter(comm ); DataSet ds = new DataSet(); sqlDa.Fill(ds); return ds; } } /// <summary> /// 在只提供表名的情况下从数据库提取所以信息 /// </summary> /// <param name="table_name"></param> /// <returns></returns> public static DataSet GetMesgOnlyTable(string table_name) { string str = "select * from "+table_name+" order by id desc"; using (SqlConnection conn = new SqlConnection(strConn)) { SqlCommand comm = new SqlCommand(str, conn); conn.Open(); SqlDataAdapter sqlDa = new SqlDataAdapter(comm); DataSet ds = new DataSet(); sqlDa.Fill(ds); return ds; } } /// <summary> /// 获取某个表的特定ID值信息 /// </summary> /// <param name="table"></param> /// <param name="id"></param> /// <returns></returns> public static DataSet GetMesgOnId(string table,int id) { string str = "select * from " + table + " where id="+id+""; using (SqlConnection conn = new SqlConnection(strConn)) { SqlCommand comm = new SqlCommand(str, conn); conn.Open(); SqlDataAdapter sqlDa = new SqlDataAdapter(comm); DataSet ds = new DataSet(); sqlDa.Fill(ds); return ds; } }

vici框架写的留言板

留言人：{{mesg._writer}}时间：{{mesg._date}}

公告栏

诗歌