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