public DataTable SelectNoticeByID(MNotice objNotice)
{
StringBuilder sb = new StringBuilder();
sb.Append("select * from tb_notice where noticeID=@ID");
SqlParameter[] param = {
SQLDbHelper.GetParameter("@ID",SqlDbType.Int,4,"noticeID",objNotice.ID)
};
DataTable dt = SQLDbHelper.ExecuteDt(sb.ToString(),param);
return dt;
}
/// <summary>
/// 获取公告内容自动生成或更新XML文件
/// </summary>
//public void SelectNoticeUpdXmlByID(MNotice objNotice)
//{
// //注意：ADO.NET通过DataSet与XML进行交互。
// //定义一个数据集对象
// DataTable dt = new DataTable();
// dt.TableName = "Notice";
// //获取数据
// dt = notce.SelectNoticeByID(objNotice);
// //实例化一个FileStream对象
// FileStream objFs = new FileStream(HttpContext.Current.Server.MapPath("~/Xml/NoticeXml/Notice.xml"),
// FileMode.OpenOrCreate, FileAccess.Write);
// DataSet ds = new DataSet();
// ds.Tables.Add(dt);
// //将获取后的数据自动生成或更新xml文件
// ds.WriteXml(objFs);
// //关闭新建对象
// objFs.Close();
//}
/// <summary>
/// 定义生成信息静态页面
/// </summary>
public void CreateNoticeHtml(MNotice objNotice)
{
//生成静态页面后保存的路径
string strSavePath = HttpContext.Current.Server.MapPath("~/") + "Html/Notice/";
//静态页面样板所保存的路径
string strHtmlPath = HttpContext.Current.Server.MapPath("~/") + "Html/Notice/Model.html";
//定义样板读取变量并读样板
StreamReader objSr = new StreamReader(strHtmlPath, System.Text.Encoding.GetEncoding("gb2312"));//"utf-8"
//文件数据流
string ObjContent = "";
//开始读取
try
{
ObjContent = objSr.ReadToEnd();
}
catch (Exception ex)
{
HttpContext.Current.Response.Write(ex.Message);
HttpContext.Current.Response.End();
objSr.Close();
}
//定义新生成的html文件名
string strNewHtmlFileName = objNotice.NoticeHtmlName + ".html";
StreamWriter objSw = new StreamWriter(strSavePath + strNewHtmlFileName, false, System.Text.Encoding.GetEncoding("gb2312"));
//写入生成的文件
ObjContent = ObjContent.Replace("T_Title", objNotice.NoticeTitle);
ObjContent = ObjContent.Replace("N_Title", objNotice.NoticeTitle);
ObjContent = ObjContent.Replace("N_Time", objNotice.NoticeTime.ToString());
ObjContent = ObjContent.Replace("N_Author", objNotice.NoticePerson);
ObjContent = ObjContent.Replace("N_Content", objNotice.NoticeContent);
try
{
objSw.Write(ObjContent);
objSw.Flush();
}
catch (Exception ex)
{
HttpContext.Current.Response.Write(ex.Message);
HttpContext.Current.Response.End();
}
finally
{
objSw.Close();
}
}
public bool DeleteNoticeByID(MNotice objNotice)
{
StringBuilder sb = new StringBuilder();
sb.Append("delete from tb_notice where noticeID=@ID");
SqlParameter[] param = {
SQLDbHelper.GetParameter("@ID",SqlDbType.Int,4,"noticeID",objNotice.ID)
};
bool is_succeed = SQLDbHelper.ExecuteSql(sb.ToString(), param);
if (is_succeed)
{
return true;
}
else
{
return false;
}
}
public bool UpdateNoticeByID(MNotice objNotice)
{
StringBuilder sb = new StringBuilder();
sb.Append("update tb_notice set noticeTitle=@Title,noticePerson=@NoticePerson,noticeContent=@NoticeContent where noticeID=@ID");
SqlParameter[] param = {
SQLDbHelper.GetParameter("@Title",SqlDbType.VarChar,40,"noticeTitle",objNotice.NoticeTitle),
SQLDbHelper.GetParameter("@NoticePerson",SqlDbType.VarChar,20,"noticePerson",objNotice.NoticePerson),
SQLDbHelper.GetParameter("@NoticeContent",SqlDbType.Text,"noticeContent",objNotice.NoticeContent),
SQLDbHelper.GetParameter("@ID",SqlDbType.Int,4,"noticeID",objNotice.ID)
};
bool is_succeed = SQLDbHelper.ExecuteSql(sb.ToString(), param);
if (is_succeed)
{
return true;
}
else
{
return false;
}
}
public bool InsertIntoNotice(MNotice objNotice)
{
StringBuilder sb = new StringBuilder();
sb.Append("insert into tb_notice (noticeTitle,noticeTime,noticePerson,noticeContent,noticeHtmlName) values(@Title,@Datetime,@NoticePerson,@NoticeContent,@NoticeHtmlName)");
SqlParameter[] param = {
SQLDbHelper.GetParameter("@Title",SqlDbType.VarChar,40,"noticeTitle",objNotice.NoticeTitle),
SQLDbHelper.GetParameter("@Datetime",SqlDbType.DateTime,"noticeTime",objNotice.NoticeTime),
SQLDbHelper.GetParameter("@NoticePerson",SqlDbType.VarChar,20,"noticePerson",objNotice.NoticePerson),
SQLDbHelper.GetParameter("@NoticeContent",SqlDbType.Text,"noticeContent",objNotice.NoticeContent),
SQLDbHelper.GetParameter("@NoticeHtmlName",SqlDbType.VarChar,50,"noticeHtmlName",objNotice.NoticeHtmlName)
};
bool is_succeed = SQLDbHelper.ExecuteSql(sb.ToString(), param);
if (is_succeed)
{
return true;
}
else
{
return false;
}
}
public bool DeleteNoticeByID(MNotice objNotice)
{
return notce.DeleteNoticeByID(objNotice);
}
public bool UpdateNoticeByID(MNotice objNotice)
{
return notce.UpdateNoticeByID(objNotice);
}
public DataTable SelectNoticeByID(MNotice objNotice)
{
return notce.SelectNoticeByID(objNotice);
}
public bool InsertIntoNotice(MNotice objNotice)
{
return notce.InsertIntoNotice(objNotice);
}
public void DeleteNoticeHtml(MNotice objNotice)
{
//生成静态页面后保存的路径
string strSavePath = HttpContext.Current.Server.MapPath("~/") + "Html/Notice/";
//定义新生成的html文件名
string strNewHtmlFileName = objNotice.NoticeHtmlName + ".html";
string Path = strSavePath + strNewHtmlFileName;
if (File.Exists(@Path))
{
File.Delete(@Path);
}
}
