Smokewinetea.DAL/NoticeDAL.cs

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

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

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

namespace Smokewinetea.DAL
{
   public class NoticeDAL
    {
       /// <summary>
       /// 发送公告
       /// </summary>
       /// <param name="notice"></param>
       /// <returns></returns>
       public static int NoticeInsert(NoticeModels notice)
       {
           StringBuilder sql = new StringBuilder();
           sql.Append("insert into Notice values(@NteName,@NotiTime,@NteContent)");
           SqlParameter[] param ={
               new SqlParameter("NteName",SqlDbType.VarChar,20),
               new SqlParameter("NotiTime",SqlDbType.DateTime),
               new SqlParameter("NteContent",SqlDbType.VarChar,500)

                                };
           param[0].Value = notice.NteName;
           param[1].Value = notice.NotiTime;
           param[2].Value = notice.NteContent;

           int n = DbHelper.ExecuteNonQuery(sql.ToString(), param);
           return n;


       }

       /// <summary>
       /// 加载公告
       /// </summary>
       /// <returns></returns>
       public static List<NoticeModels> Notice()
       {   
           StringBuilder sql = new StringBuilder();
           sql.Append("select NotiTime,NteContent from Notice");
           SqlDataReader dr = DbHelper.ExecuteReader(sql.ToString());
           List<NoticeModels> Nms = new List<NoticeModels>();
           NoticeModels Nm;
           while(dr.Read())
           {
               Nm = new NoticeModels();
               Nm.NotiTime = Convert.ToDateTime(dr[0]);
               Nm.NteContent =Convert.ToString(dr[1]);
               Nms.Add(Nm);
           }
           dr.Close();
           DbHelper.ConClose();
           return Nms;
       }
/// <summary>