//add Rio public string AddEmailAttachmentInfor(EmailAttachEntity _EmailAttachEntity) { DbParameter[] pramsInsert = { MakeInParam("@AttachmentName",(DbType)SqlDbType.VarChar,50,_EmailAttachEntity.AttachmentName), MakeInParam("@AttachmentUrl",(DbType)SqlDbType.VarChar,2000,_EmailAttachEntity.AttachmentUrl), MakeInParam("@EmailSerialID",(DbType)SqlDbType.Int,4,_EmailAttachEntity.EmailSerialID), MakeInParam("@AttachClientName",(DbType)SqlDbType.VarChar,2000,_EmailAttachEntity.AttachClientName), MakeInParam("@AttachSize",(DbType)SqlDbType.Float,32,_EmailAttachEntity.AttachSize), MakeInParam("@AttachType",(DbType)SqlDbType.VarChar,50,_EmailAttachEntity.AttachType), }; StringBuilder sb = new StringBuilder(); sb.Append("INSERT INTO [dbo].[UserEmailAttachment]"); sb.Append("("); sb.Append(" [AttachmentName]"); sb.Append(",[AttachmentUrl]"); sb.Append(",[EmailSerialID]"); sb.Append(",[AttachClientName]"); sb.Append(",[AttachSize]"); sb.Append(",[AttachType]"); sb.Append(")"); sb.Append("VALUES"); sb.Append("("); sb.Append(" @AttachmentName"); sb.Append(",@AttachmentUrl"); sb.Append(",@EmailSerialID"); sb.Append(",@AttachClientName"); sb.Append(",@AttachSize"); sb.Append(",@AttachType"); sb.Append(")"); sb.Append(" select @@identity;"); return ExecuteScalar(CommandType.Text, sb.ToString(), pramsInsert).ToString(); }
protected void btnSendMail_Click(object sender, EventArgs e) { string szResult =""; string szUserSerialID = ""; // string szFileName = lblHideMessage.Text; string szAllName = ""; string szAllSecret = ""; string savePath = ".."; DataTable dtValue = (DataTable)FileUploadEmail.dtAttach; szAllName = txtSendTo.Text; szAllSecret = txtlblScret.Text; EmailEntity _EmailEntity = new EmailEntity(); _EmailEntity.UserID = userEntity.UserID; _EmailEntity.SenderID = szAllName; _EmailEntity.ReceiverID = ""; _EmailEntity.SendTime = DateTime.Now; _EmailEntity.ReceiveTime = DateTime.Now; _EmailEntity.MailTitle = txtTitle.Text; _EmailEntity.MailContent = FreeTextBox1.Text; _EmailEntity.ISRead = 0; if (szAllSecret == "") _EmailEntity.SecretSenderID = ""; else _EmailEntity.SecretSenderID = szAllSecret; if (dtValue.Rows.Count > 0) _EmailEntity.AttachID ="" ; else _EmailEntity.AttachID = ""; _EmailEntity.UserMasterID = 0; szUserSerialID = DbHelper.GetInstance().AddEmailInfor(_EmailEntity); if (dtValue.Rows.Count > 0) { for (int jj = 0; jj < dtValue.Rows.Count; jj++) { EmailAttachEntity _EmailAttachEntity = new EmailAttachEntity(); _EmailAttachEntity.AttachSize = Convert.ToSingle(dtValue.Rows[jj]["AttachSize"].ToString()); _EmailAttachEntity.AttachType = dtValue.Rows[jj]["AttachType"].ToString(); ; _EmailAttachEntity.AttachClientName = dtValue.Rows[jj]["AttachClientName"].ToString(); _EmailAttachEntity.AttachmentName = dtValue.Rows[jj]["AttachmentName"].ToString() ; _EmailAttachEntity.AttachmentUrl = Server.MapPath(savePath) + "\\" + dtValue.Rows[jj]["AttachmentName"].ToString(); _EmailAttachEntity.EmailSerialID = Int32.Parse(szUserSerialID); szResult = DbHelper.GetInstance().AddEmailAttachmentInfor(_EmailAttachEntity); } } int iCount = 0; string[] szOneAllName = szAllName.Split(';'); foreach (string szOneName in szOneAllName) { if (szOneName != "") { string[] szName = szOneName.Split('('); foreach (string szUserName in szName) { iCount++; if (iCount == 1) { _EmailEntity = new EmailEntity(); _EmailEntity.UserID = szUserName; _EmailEntity.SenderID = ""; _EmailEntity.ReceiverID = userEntity.UserID; _EmailEntity.SendTime = DateTime.Now; _EmailEntity.ReceiveTime = DateTime.Now; _EmailEntity.MailTitle = txtTitle.Text; _EmailEntity.MailContent = FreeTextBox1.Text; _EmailEntity.ISRead = 0; //0: 未读 1: 已读 2:删除(非彻底删除) _EmailEntity.SecretSenderID = ""; _EmailEntity.IsScret = 0; if (dtValue.Rows.Count > 0) _EmailEntity.AttachID = ""; else _EmailEntity.AttachID = ""; _EmailEntity.UserMasterID = Int32.Parse(szUserSerialID); szResult = DbHelper.GetInstance().AddEmailInfor(_EmailEntity); } else iCount = 0; } } } iCount = 0; string[] szOneSecretName = szAllSecret.Split(';'); foreach (string szOneName in szOneSecretName) { if (szOneName != "") { string[] szName = szOneName.Split('('); foreach (string szUserName in szName) { iCount++; if (iCount == 1) { _EmailEntity = new EmailEntity(); _EmailEntity.UserID = szUserName; _EmailEntity.SenderID = ""; _EmailEntity.ReceiverID = userEntity.UserID; _EmailEntity.SendTime = DateTime.Now; _EmailEntity.ReceiveTime = DateTime.Now; _EmailEntity.MailTitle = txtTitle.Text; _EmailEntity.MailContent = FreeTextBox1.Text; _EmailEntity.ISRead = 0; //0: 未读 1: 已读 2:删除(非彻底删除) _EmailEntity.SecretSenderID = ""; _EmailEntity.IsScret = 1; //1:密件 if (dtValue.Rows.Count > 0) _EmailEntity.AttachID = "" ; else _EmailEntity.AttachID = ""; _EmailEntity.UserMasterID = Int32.Parse(szUserSerialID); szResult = DbHelper.GetInstance().AddEmailInfor(_EmailEntity); } else iCount = 0; } } } Response.Redirect("Success.aspx"); }