sendmail.cs

网络营销软件的源代码

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


namespace WebApplication8.firstPage
{
	/// <summary>
	/// SendMail 的摘要说明。
	/// </summary>
	public class SendMail
	{
		SqlConnection mailConnection;
		SqlCommand mailCommand;
		SqlDataAdapter reader;
		DataSet dataset = new DataSet();

		public SendMail(string c)
		{
			//
			// TODO: 在此处添加构造函数逻辑
			//
			mailConnection = new SqlConnection();
			mailCommand = new SqlCommand();

			mailConnection.ConnectionString = c;
			mailConnection.Open();
			mailCommand.Connection = mailConnection;
			reader = new SqlDataAdapter();
			reader.SelectCommand = mailCommand;
		}

		public bool sendMail(string sender,string receiver,string subject,string body,string size)
		{
			mailCommand.CommandText = "insert into Mail values('"+subject+"','"+body+"','"+size+"','未读','"+System.DateTime.Now.ToString()+"','"+receiver+"','"+sender+"')";
			int temp = mailCommand.ExecuteNonQuery();
			return true;
		}

		public DataSet getMail(string userName)
		{
			dataset.Clear();
			mailCommand.CommandText = "SELECT * FROM Mail WHERE (receiver = '"+userName+"') AND (state = '未读' OR state = '已读')";
			reader.Fill(dataset);
			return dataset;
		}

		public DataSet getRubbish(string userName)
		{
			dataset.Clear();
			mailCommand.CommandText = "SELECT * FROM Mail WHERE (receiver = '"+userName+"') AND (state = '垃圾')";
			reader.Fill(dataset);
			return dataset;
		}

		public void deleteToRubbish(string id)
		{
			mailCommand.CommandText = "update Mail set state='垃圾'where id='"+id+"'";
			mailCommand.ExecuteNonQuery();
		}

		public void deleteFromRubbish(string id)
		{
			mailCommand.CommandText = "delete from Mail where id='"+id+"'";
			mailCommand.ExecuteNonQuery();
		}

	}
}