/// <summary> /// 发送邮件 /// </summary> /// <param name="email"></param> /// <returns></returns> public static object sendEmai(ycEmail email) { sqltext = "insert into [dbo].[ycEmail]([Title],[detail],[sendtime],[writer],[receiver],[isRead],[isdelete],[isOwner])values('" + email.Title + "','" + email.Detail + "',getdate(),'" + email.Writer + "','" + email.Receiver + "','0','0','0')"; SQLHELPER.ExecuteNonQuery(sqltext); sqltext = "insert into [dbo].[ycEmail]([Title],[detail],[sendtime],[writer],[receiver],[isRead],[isdelete],[isOwner])values('" + email.Title + "','" + email.Detail + "',getdate(),'" + email.Writer + "','" + email.Receiver + "','0','0','1')"; return(SQLHELPER.ExecuteNonQuery(sqltext)); }
private void btnEmailSubmit_Click(object sender, EventArgs e) { //提交邮件 string title = this.txtemailtitle.Text.Trim(); string content = this.txtemailcontent.Text.Trim(); int senderid = Local.getCurrentUid(); int receiveerid = this._uids[this.comboxrecvperson.SelectedIndex]; if (title == "" || title == null || content == "" || content == null) { MessageBox.Show("没有输入完整!"); this.bindAllDataView(); return; } ycEmail email = new ycEmail(); email.Detail = content; email.Title = title; email.Receiver = receiveerid; email.Writer = senderid; if (BLL.ycEmailBLL.sendEmai(email) == 1) { MessageBox.Show("邮件发送成功!"); this.bindAllDataView(); } }
//发邮件 public static int sendEmai(ycEmail email) { return(Convert.ToInt32(DAL.ycEmailServer.sendEmai(email))); }