/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Mail_Test.Model.sendlist model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update sendlist set ");
strSql.Append("issend=@issend,");
strSql.Append("sendtime=@sendtime");
strSql.Append(" where userid=@userid");
strSql.Append(" and mailid=@mailid");
SqlParameter[] parameters =
{
new SqlParameter("@userid", SqlDbType.Int, 4),
new SqlParameter("@mailid", SqlDbType.Int, 4),
new SqlParameter("@issend", SqlDbType.Bit, 1),
new SqlParameter("@sendtime", SqlDbType.DateTime)
};
parameters[0].Value = model.userid;
parameters[1].Value = model.mailid;
parameters[2].Value = model.issend;
parameters[3].Value = model.sendtime;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Mail_Test.Model.sendlist DataRowToModel(DataRow row)
{
Mail_Test.Model.sendlist model = new Mail_Test.Model.sendlist();
if (row != null)
{
if (row["userid"] != null && row["userid"].ToString() != "")
{
model.userid = int.Parse(row["userid"].ToString());
}
if (row["mailid"] != null && row["mailid"].ToString() != "")
{
model.mailid = int.Parse(row["mailid"].ToString());
}
if (row["issend"] != null && row["issend"].ToString() != "")
{
if ((row["issend"].ToString() == "1") || (row["issend"].ToString().ToLower() == "true"))
{
model.issend = true;
}
else
{
model.issend = false;
}
}
if (row["sendtime"] != null && row["sendtime"].ToString() != "")
{
model.sendtime = DateTime.Parse(row["sendtime"].ToString());
}
if (row["id"] != null && row["id"].ToString() != "")
{
model.id = int.Parse(row["id"].ToString());
}
}
return(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Mail_Test.Model.sendlist model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into sendlist(");
strSql.Append("userid,mailid,issend,sendtime)");
strSql.Append(" values (");
strSql.Append("@userid,@mailid,@issend,@sendtime)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@userid", SqlDbType.Int, 4),
new SqlParameter("@mailid", SqlDbType.Int, 4),
new SqlParameter("@issend", SqlDbType.Bit, 1),
new SqlParameter("@sendtime", SqlDbType.DateTime)
};
parameters[0].Value = model.userid;
parameters[1].Value = model.mailid;
parameters[2].Value = model.issend;
parameters[3].Value = model.sendtime;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Mail_Test.Model.sendlist GetModel(int id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 userid,mailid,issend,sendtime,id from sendlist ");
strSql.Append(" where id=@id");
SqlParameter[] parameters =
{
new SqlParameter("@id", SqlDbType.Int, 4)
};
parameters[0].Value = id;
Mail_Test.Model.sendlist model = new Mail_Test.Model.sendlist();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
public JsonResult Sendmail()
{
bool isAsync = false;
string idlist = "";
if (Request.Form["selmember"] != null)
{
idlist = Request.Form["selmember"].ToString();
}
idlist = idlist.Replace("false", "0");
MailHelper mail = new MailHelper(isAsync);
//保存邮件信息
Mail_Test.Model.maillist mailinfo = new Mail_Test.Model.maillist();
mailinfo.mcc = Request.Form["txtCc"].ToString();
mailinfo.ccname = Request.Form["txtCcname"].ToString();
mailinfo.fromname = Request.Form["txtfromname"].ToString();
mailinfo.mailcontent = Request.Form["txtContent"].ToString();
mailinfo.mfrom = Request.Form["txtfrom"].ToString();
mailinfo.mto = Request.Form["txtTo"].ToString();
mailinfo.title = Request.Form["txtTitle"].ToString();
mailinfo.toname = Request.Form["txtToname"].ToString();
mailinfo.sendtime = DateTime.Now;
mailinfo.guid = new Guid(Request.Form["guid"].ToString());
int mailid = new Mail_Test.BLL.maillist().Add(mailinfo);
string path = AppDomain.CurrentDomain.BaseDirectory + "uploads\\" + mailid.ToString() + "\\";
ArrayList list = Config.uploadfile(System.Web.HttpContext.Current.Request.Files, path);
savefj(list, mailid);
if (Config.IsEmailString(mailinfo.mto))
{
this.SendMessage(mail, false, list, mailinfo, true, true);
}
//保存收件人信息
DataSet ds = getmemberlist(idlist);
foreach (DataRow dr in ds.Tables[0].Rows)
{
Mail_Test.Model.sendlist model = new Mail_Test.Model.sendlist();
model.mailid = mailid;
model.userid = int.Parse(dr["id"].ToString());
model.issend = false;
model.sendtime = DateTime.Now;
new sendlist().Add(model);
}
foreach (DataRow dr in ds.Tables[0].Rows)
{
mailinfo.mto = dr["useremail"].ToString();
mailinfo.toname = dr["username"].ToString();
this.SendMessage(mail, false, list, mailinfo, true, true);
Mail_Test.Model.sendlist model = new Mail_Test.Model.sendlist();
model.mailid = mailid;
model.userid = int.Parse(dr["id"].ToString());
model.issend = true;
model.sendtime = DateTime.Now;
new sendlist().Update(model);
}
JsonResult jsr = new JsonResult();
jsr.Data = "邮件发送完成";
return(jsr);
}
