protected void btnSubmit_Click(object sender, EventArgs e)
{
short grade = Convert.ToInt16(ddlGrade.SelectedItem.Value); // 获取用户评分
string content = TextBox1.Text; // 评论内容
if (string.IsNullOrEmpty(content)) {
ClientScript.RegisterStartupScript(Page.GetType(), "Message", "<script>alert('请输入评论内容')</script>");
return;
}
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["DataSource"].ConnectionString);
string insert = string.Format("insert into CommentTable(OrderID, UserName, LineID, Grade, Content) Values('{0}', '{1}', {2}, {3}, '{4}')", orderID, Session["UserName"].ToString(), lineID, grade, content);
SqlCommand cmd = new SqlCommand(insert, conn);
// 添加评论
try {
conn.Open();
cmd.ExecuteNonQuery();
var table = new CommentTableAdapters.OrderInfoTableAdapter();
table.UpdateQueryIsComment(true, orderID); // 更新数据库
ClientScript.RegisterStartupScript(Page.GetType(), "ss", "<script>alert('评论成功');{location.href='UserPage.aspx'}</script>");
} catch {
} finally {
conn.Close();
}
//ClientScript.RegisterStartupScript(Page.GetType(), "ss", "<script>alert('评论成功')</script>");
}
protected void Page_Load(object sender, EventArgs e)
{
this.Title = "线路评价";
orderID = Request["orderID"]; // 获取订单编号
var table = new CommentTableAdapters.OrderInfoTableAdapter();
var result = table.GetDataByOrderID(orderID).Single();
lineID = result.LineID;
string travelDate = result.TravelDate.ToString("yyyy-MM-dd");
var lineTable = new ViewLineTableAdapters.TourLineTableAdapter();
var lineName = lineTable.GetDataByID(lineID).Single().LineName;
lblLineName.Text = "线路名称" + lineName;
lblTravelDate.Text = "旅行日期: " + travelDate;
}