/// <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); }