DAL/MailsInfoDAL.cs

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

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

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

namespace DAL
{
    public class MailsInfoDAL
    {
        /// <summary>
        /// 用户登录
        /// </summary>
        /// <param name="Title">用户名</param>
        /// <param name="Contain">密码</param>
        /// <returns>返回第一行第一列的值</returns>

        public static bool MailLogin(string Title, string Contain)
        {
            string sql = "select * from Mails where Title = @Title and Contain = @Contain";
            SqlParameter sp1 = new SqlParameter("@Title", Title);
            SqlParameter sp2 = new SqlParameter("@Contain", Contain);

            object obj = SqlHelper.GetObj(sql, sp1, sp2);
            if (obj != null)
                return true;
            else
                return false;
        }

        /// <summary>
        /// 判断用户是否存在
        /// </summary>
        /// <param name="cardID">用户名</param>
        /// <returns></returns>
        public static int IsTrueTitle(string Title)
        {
            string sql = "select count(Title) from Mails where Title=@Title";
            SqlParameter sp1 = new SqlParameter("@Title", Title);
            object obj = SqlHelper.GetObj(sql, sp1);
            return Convert.ToInt32(obj);
        }


        /// <summary>
        /// 根据用户名，获取相应的邮箱地址
        /// </summary>
        /// <param name="FromAddress"></param>
        /// <param name="Contain"></param>
        /// <returns></returns>
        public static List<Model.MailsInfo> GetListEmail(string Title)
        {
            string sql = "select ToAddress from Mails where Title = @Title";
            SqlParameter sp1 = new SqlParameter("@Title", Title);

            SqlDataReader dr = SqlHelper.GetRead(sql, sp1);
            List<Model.MailsInfo> list = new List<Model.MailsInfo>();

            while (dr.Read())