protected void Page_Load(object sender, EventArgs e)
{
strId = Request.QueryString["id"];
if (string.IsNullOrEmpty(strId))
{
Response.Write("<script language='javascript' type='text/javascript'>alert('非法访问！');location.href='RepliedEmailList.aspx'</script>");
return;
}
re = EmailRepliedType.findById(int.Parse(strId));
EmailType ce = EmailType.find("MessageID=" + re.MessageID).first();
tbxContent.Text= ce.Body;
lblOurStore.Text = ce.SaleAccount;
lblFrom.Text = ce.BuyerAccount + "———" + ce.CreateOn.ToString();
lblItemCurrency.Text = ce.ItemPriceCurrency;
lblItemTitle.Text = ce.ItemTitle;
lblItemValue.Text = ce.ItemPrice.ToString();
lblMsgType.Text = ce.MessageType;
lblSenderEmail.Text = ce.BuyerEmail;
lblTitle.Text = ce.Subject;
hlinkViewItem.NavigateUrl = ce.ItemURL;
hlinkViewItem.Target = "_blank";
txtEmailTitle.Text = re.Subject;
tbxReply.Text = re.Body;
}
protected void Page_Load(object sender, EventArgs e)
{
strId = Request.QueryString["id"];
currentEbayAccount = Request.QueryString["ea"];
if (string.IsNullOrEmpty(strId))
{
Response.Write("<script language='javascript' type='text/javascript'>alert('非法访问！');location.href='Default.aspx';</script>");
return;
}
ce = EmailType.findById(int.Parse(strId));
if (ce.MessageStatus == "Replied")
{
Page.ClientScript.RegisterStartupScript(typeof(Page), "", "<script language='javascript' type='text/javascript'>alert('该Email已回复！');EmailListReload();</script>");
return;
}
List<OrderType> listOrder = OrderType.find("BuyerId='" + ce.BuyerAccount + "' and UserNameForm='" + ce.SaleAccount + "' and CreateOn>'" + DateTime.Now.AddMonths(-1).ToString("yyyy-MM-dd") + "'").list();
for (int i = 0; i < listOrder.Count; i++)
{
listOrder[i].OrderGoods = OrderGoodsType.find("OrderNo='" + listOrder[i].Id + "'").list();
}
rpOrderInfo.DataSource = listOrder;
rpOrderInfo.DataBind();
DateTime limitTime = DateTime.Now.AddDays(-90);
DataTable dtHistory = db.RunTable<EmailType>("SELECT E.BuyerAccount,E.[Subject],E.[Body],E.[CreateOn],RE.[Replier],RE.[Subject],RE.[Body],RE.CreateOn FROM [Email] AS E LEFT JOIN [EmailReplied] AS RE ON E.MessageID = RE.MessageID WHERE E.BuyerAccount='" + ce.BuyerAccount + "' AND E.SaleAccount='" + ce.SaleAccount + "' AND E.CreateOn>'" + limitTime + "' ORDER BY E.CreateOn ASC");
List<EmailRepliedType> result = new List<EmailRepliedType>();
foreach (DataRow dr in dtHistory.Rows)
{
EmailRepliedType re = new EmailRepliedType();
re.Replier = dr[0].ToString();
re.Subject=dr[1].ToString();
re.Body = dr[2].ToString();
re.CreateOn = DateTime.Parse(dr[3].ToString());
re.IsToEbay = false;
result.Add(re);
re = new EmailRepliedType();
if (!dr.IsNull(4))
{
re.Replier = dr[4].ToString();
re.Subject = dr[5].ToString();
re.Body = dr[6].ToString();
re.CreateOn = DateTime.Parse(dr[7].ToString());
re.IsToEbay = true;
result.Add(re);
}
}
rpHistoryEmail.DataSource = result;
rpHistoryEmail.DataBind();
lblOurStore.Text = ce.SaleAccount;
lblItemCurrency.Text = ce.ItemPriceCurrency;
lblItemTitle.Text = ce.ItemTitle;
lblItemValue.Text = ce.ItemPrice.ToString();
lblMsgType.Text = ce.MessageType;
lblSenderEmail.Text = ce.BuyerEmail.Replace("@", " @");
hlinkViewItem.NavigateUrl = ce.ItemURL;
hlinkViewItem.Target = "_blank";
txtEmailTitle.Text = ce.Subject;
hdStartTime.Value = DateTime.Now.ToString();
}
private void SaveCurrentReply()
{
string strEmailTitle = Request.Form[txtEmailTitle.ID].Trim();
string strContent = Request.Form[tbxReply.ID].Trim();
EmailRepliedType re = new EmailRepliedType();
if (strContent.Length > 0)
{
re.Body = strContent + "\r\n\r\n---" + "";//当前用户名
}
else
{
re.Body = "";
}
re.CreateOn = DateTime.Now;
re.ReceiveOn = ce.CreateOn;
re.SaleAccount = ce.SaleAccount;
re.ItemID = ce.ItemID;
re.Subject = strEmailTitle;
re.IsToEbay = false;
re.MessageID = ce.MessageID;
re.Replier = "";//当前用户名
re.BuyerEmail = ce.BuyerEmail;
re.BuyerAccount = ce.BuyerAccount;
re.ToEbayOn = new DateTime(1999, 1, 1, 0, 0, 0, 0);
string strStartTime = Request.Form[hdStartTime.ID].Trim();
DateTime startTime = DateTime.Parse(strStartTime);
re.ReplyCostSecond = (re.CreateOn - startTime).TotalSeconds;
re.insert();
ce.MessageStatus = "Replied";
ce.update();
}
