Smokewinetea.DAL/SendDAL.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 SendDAL
    {
       /// <summary>
       /// 添加消息
       /// </summary>
       /// <param name="sen"></param>
       /// <returns></returns>
       public static int insertSend(SendModels sen)
       {
           StringBuilder sql = new StringBuilder();
     
           sql.Append("insert into Send values(@SendName,@receiveName,@SendTime,@SendContent)");
           SqlParameter[] param = {
                                      new SqlParameter("SendName",SqlDbType.VarChar,20),
                                      new SqlParameter("receiveName",SqlDbType.VarChar,20),
                                      new SqlParameter("SendTime",SqlDbType.DateTime),
                                      new SqlParameter("SendContent",SqlDbType.VarChar,500)
                                  };
           param[0].Value =sen.SendName;
           param[1].Value = sen.ReceiveName;
           param[2].Value = sen.SendTime;
           param[3].Value = sen.SendContent;

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

       /// <summary>
       /// 加载消息
       /// </summary>
       /// <returns></returns>
       public static List<SendModels> Sendji()
       {
           StringBuilder sql = new StringBuilder();
           sql.Append("select SendName,SendTime,SendContent from Send");
           SqlDataReader dr = DbHelper.ExecuteReader(sql.ToString());
           List<SendModels> send = new List<SendModels>();
           SendModels sen;
           while(dr.Read())
           {
               sen = new SendModels();
               sen.SendName = dr[0].ToString();
               sen.SendTime = Convert.ToDateTime(dr[1]);
               sen.SendContent = dr[2].ToString();
               send.Add(sen);
           }
           dr.Close();
           DbHelper.ConClose();
           return send;
       }