DAL/NoticesDAO.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using MODEL;
using System.Data;
using System.Data.SqlClient;

namespace DAL
{
    public class NoticesDAO
    {
        private SQLHelper sqlhelper;
        public NoticesDAO()
        {
            sqlhelper = new SQLHelper();
        }
        #region 新增公告
        /// <summary>
        /// 新增公告
        /// </summary>
        /// <param name="n">公告信息实体类</param>
        /// <returns></returns>
        public bool Insert(notices  n)
        {
            bool flag = false;
            SqlParameter[] paras = new SqlParameter[]
            {
                new SqlParameter("@content",n.Content),
                new SqlParameter("@issuer",n.Issuer),
                new SqlParameter("@issueTime",n.IssueTime),
                new SqlParameter("@noticeName",n.NoticeName),
                new SqlParameter("@creater",n.Creater),
                new SqlParameter("@modifier",n.Creater),
            };
            int res = sqlhelper.ExecuteNonQuery("INSERT INTO notices ([content],issuer,issueTime,noticeName, creater, modifier) VALUES (@content,@issuer,@issueTime,@noticeName,@creater,@modifier)", paras, CommandType.Text);
            if (res > 0)
            {
                flag = true;
            }
            return flag;
        }
        #endregion
        #region 更新公告信息
        /// <summary>
        /// 更新公告信息
        /// </summary>
        /// <param name="n">公告信息实体类</param>
        public void Update(notices  n)
        {
            SqlParameter[] paras = new SqlParameter[]
            {
                new SqlParameter("@content",n.Content),
                new SqlParameter("@issuer",n.Issuer),
                new SqlParameter("@issueTime",n.IssueTime),
                new SqlParameter("@noticeId",n.NoticeId),
                new SqlParameter("@noticeName",n.NoticeName),
                new SqlParameter("@modifier",n.Modifier),
            };
            sqlhelper.ExecuteQuery("UPDATE notices SET noticeName=@noticeName, modifier=@modifier,[content] = @content,issuer=@issuer, issueTime=@issueTime ,lastmodify = getdate() where noticeId=@noticeId ", paras, CommandType.Text);