messagesmake.cs

来自「企业内部的短信交流管理平台。 设计详细」· CS 代码 · 共 67 行

using System;
using System.Data;
using System.Data.SqlClient;

namespace Com.SMS.Dal
{
	/// <summary>
	/// MessagesMake 的摘要说明。
	/// </summary>
	public class MessagesMake
	{
		/// <summary>
		/// 添加聊天消息内容
		/// </summary>
		/// <param name="msg"></param>
		/// <returns></returns>
		public bool Insert(Entity.Message msg)
		{
			SqlParameter[] parms=
			{
				new SqlParameter("@Content",msg.Content),
				new SqlParameter("@sender",msg.Sender),
				new SqlParameter("@recive",msg.Recive),
				new SqlParameter("@sendTime",msg.SendTime),
			};

			int i=SqlBasic.ExecuteNonQuery(SqlBasic.CONN_STRING,CommandType.Text,SqlCollections.SQL_MESSAGES_INSERT,parms);

			if(i==1)
			{
				return true;
			}
			else
				return false;
		}

		/// <summary>
		/// 删除聊天消息内容
		/// </summary>
		/// <param name="msgId"></param>
		/// <returns></returns>
		public bool Delete(int msgId)
		{
			int i=SqlBasic.ExecuteNonQuery(SqlBasic.CONN_STRING,CommandType.Text,SqlCollections.SQL_MESSAGES_DELETE,new SqlParameter("@msgId",msgId));

			if(i==1)
			{
				return true;
			}
			else
				return false;
		}

		/// <summary>
		/// 查询所有聊天消息
		/// </summary>
		/// <returns></returns>
		public DataTable FindAll()
		{
			DataTable dt=new DataTable();
			SqlBasic.FillDatatable(SqlBasic.CONN_STRING,CommandType.Text,SqlCollections.SQL_MESSAGES_SELECTALL,dt);

			return dt;
		}
	}
}