//发送留言
public void PostLWord(LWord lword)
{
string LwordContent = lword.Leave_word;
float LwordScore = lword.Score;
string LwordISBN = lword.Getbook.ISBN;
string LwordUserID = lword.Getcustomer.UserID;
string LwordEmai = lword.Getcustomer.Email;
DateTime LwordPostTime = new DateTime();
LwordPostTime = DateTime.Now;
(new UserData()).PostLeaveWord(lword);
(new BookData()).Average_Score((new BookData()).GetBook(LwordISBN)); //更新书本评分
}
protected void Submit_Click(object sender, EventArgs e)
{
//Response.Write("<script>alert('" + hiddenMessage.Value + "')</script>");
Customer user = new Customer();
user = Session["User"] as Customer;
//user = (new UserOperation().GetCustomer("00001"));
//Response.Write("<script>alert('" + Session["User"] as string + "')</script>");
BookMessage book = new BookMessage();
book = (new BookOperation().GetBook((Request.QueryString["ISBN"] as string)));
LWord lword = new LWord();
lword.Getbook.ISBN = book.ISBN;
lword.Getcustomer.UserID = user.UserID;
lword.Leave_word = lytext.InnerText;
lword.Score = (float)Convert.ToDouble(hiddenMessage.Value);
(new UserOperation()).PostLWord(lword);
ClientScript.RegisterStartupScript(GetType(), "PostSuccess", "<script>alert('发送成功');window.location.href ='Comment.aspx?ISBN=" + book.ISBN + "'</script>");
}
//获取书本留言内容
public IList <LWord> GetLeaveWord(string text)
{
List <LWord> leavewords = new List <LWord>(); //定义留言数组
//根据书本的ISBN查找
var result = from r in BookDB.LeaveWord
where r.ISBN == text.Trim()
select r;
foreach (var r in result)
{
LWord leaveword = new LWord();
leaveword.Getbook.ISBN = r.ISBN;
leaveword.Getcustomer.UserID = r.UserID;
leaveword.Post_time = r.PostTime;
leaveword.Score = (float)r.Score;
leaveword.Leave_word = r.TextContent;
leavewords.Add(leaveword); //增加这个书本的留言到数组
}
return(leavewords); //返回书本留言的数组
}
//发送留言
public void PostLeaveWord(LWord lword)
{
LeaveWord LWordTable = new LeaveWord(); //建立LeaveWord类实例
var judge = from r in LWordDB.LeaveWord
where r.UserID == lword.Getcustomer.UserID && r.ISBN == lword.Getbook.ISBN
select r;
if (judge.Count() >= 1)
{
throw new Exception("这个用户已经评分过");
}
else
{
LWordTable.UserID = lword.Getcustomer.UserID;
LWordTable.ISBN = lword.Getbook.ISBN;
LWordTable.TextContent = lword.Leave_word;
LWordTable.PostTime = lword.Post_time;
LWordTable.Score = lword.Score;
LWordDB.LeaveWord.InsertOnSubmit(LWordTable);
LWordDB.SubmitChanges(); //提交更改，增加留言
}
}
