Backup/DAL/Common.cs

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

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

using System;
using System.Collections.Generic;
using System.Text;
using System.Web;
using System.Drawing;
using System.Web.Services;
using System.Web.UI;
using System.Data.SqlClient;
using System.Data;
using Maticsoft.DBUtility;//请先添加引用

namespace MrZeng.DAL
{
    public class Common
    {
        /// <summary>
        /// 创建虚拟表以便存储购物清单信息
        /// </summary>
        /// <returns>DataTable</returns>
        public static DataTable CreateCartTable()
        {
            DataTable dt = new DataTable();
            dt.Columns.Add(new DataColumn("NO", typeof(string)));
            dt.Columns.Add(new DataColumn("ID", typeof(string)));
            dt.Columns.Add(new DataColumn("GoodsName", typeof(string)));
            dt.Columns.Add(new DataColumn("SellPrice", typeof(decimal)));
            dt.Columns.Add(new DataColumn("GoodsSum", typeof(int)));
            dt.Columns.Add(new DataColumn("TotalPrice", typeof(decimal)));
            dt.Columns.Add(new DataColumn("UserNum", typeof(string)));
            return dt;
        }
        /// <summary>
        /// 邮件发送
        /// </summary>
        /// <param name="mailBody"></param>
        /// <param name="mailTo"></param>
        /// <returns></returns>
        public  bool SendEmail(string mailBody, string mailTo)
        {
            //建立发邮件类
            jmail.MessageClass mc = new jmail.MessageClass();

            //内容格式
            mc.ContentType = "text/html";
            //字符集
            mc.Charset = "GB2312";
            //是否将信头编码成iso-8859-1字符集
            mc.ISOEncodeHeaders = false;
            //优先级
            mc.Priority = Convert.ToByte(1);

            //发送人邮件地址
            mc.From = "zengprince@163.com";
            //发送人姓名
            mc.FromName = "[王子购物]邮件";
            //邮件主题
            mc.Subject = "新会员注册(激活)邮件";
            //身份验证的用户名
            mc.MailServerUserName = "zengprince";
            //用户密码