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