DAL/SendEmailDAL.cs

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

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using Model;
namespace DAL
{
   public class SendEmailDAL
    {
       public static int insertSendStateInfo(SendEmailMOD semod)
       {
           SQLHelper sqh = new SQLHelper();
           SqlParameter[] para = new SqlParameter[] { new SqlParameter("@usename", SqlDbType.NVarChar ,50), new SqlParameter("@sendstate", SqlDbType.NVarChar, 50), new SqlParameter("@sendtime", SqlDbType.NVarChar, 20), new SqlParameter("@zsid", SqlDbType.Int)};
           para[0].Value = semod.UseName.ToString();
           para[1].Value = semod.Sendstate.ToString();
           para[2].Value = semod.Currenttime.ToString();
           para[3].Value = semod.Zsid;
           try
           {
               int i = sqh.ExecuteNonQuery(para, "Pro_insertSendStateInfo");
               return i;
           }
           catch (Exception ex)
           {
               throw ex;
           }

       }
    }
}