28,390
社区成员
发帖
与我相关
我的任务
分享
<%
'添加公告页面
'更新记录:
' 2012-1-3 创建
Dim op : op = Request.QueryString("op")
Dim ret : ret = 0
Dim id : id = 0
dim announce
set announce = new xdb_announce
if op = "add" then
announce.AnnTitle = Request.Form("antitle")
announce.AnnContent = Request.Form("andata")
announce.AnnTimeStart = Request.Form("dateStart")
announce.AnnTimeEnd = Request.Form("dateEnd")
announce.Insert()
ret = 1
end if
%>
'添加到数据库,新建一条数据
Public Function Insert()
Dim sql : sql = "insert into xdb_news(CateID,NewsTitle,NewsContent,NewsColor,NewsStyle,NewsAuthor,NewsFrom,NewsPicture,IsTop,IsRecommend,HasPicture) values(@CateID,@NewsTitle,@NewsContent,@NewsColor,@NewsStyle,@NewsAuthor,@NewsFrom,@NewsPicture,@IsTop,@IsRecommend,@HasPicture)"
Dim param
Set param = New DbParam
param.AddIntParam "@CateID",m_CateID
param.AddTextParam "@NewsTitle",m_NewsTitle,50
param.AddMemoParam "@NewsContent",m_NewsContent
param.AddTextParam "@NewsColor",m_NewsColor,7
param.AddTextParam "@NewsStyle",m_NewsStyle,10
param.AddTextParam "@NewsAuthor",m_NewsAuthor,20
param.AddTextParam "@NewsFrom",m_NewsFrom,50
param.AddTextParam "@NewsPicture",m_NewsPicture,255
param.AddIntParam "@IsTop",m_IsTop
param.AddIntParam "@IsRecommend",m_IsRecommend
param.AddIntParam "@HasPicture",m_HasPicture
Dim db
Set db = New DbHelper
db.ExecuteNonQuery sql,param
Set db = Nothing
Set param = Nothing
End Function