protected void btnSubmit_Click(object sender, EventArgs e)
{
string action = Request["action"];
if (action == null) {
if (string.IsNullOrEmpty(txtName.Text.Trim()) || string.IsNullOrEmpty(txtPrice.Text.Trim()) ||
string.IsNullOrEmpty(txtDays.Text.Trim()) || string.IsNullOrEmpty(txtMaxPeople.Text.Trim()) ||
string.IsNullOrEmpty(txtIntroduce.Text) || string.IsNullOrEmpty(txtAttention.Text)) {
ClientScript.RegisterStartupScript(Page.GetType(), "ss", "<script>alert('请按要求输入完整信息')</script>");
return;
}
string name = txtName.Text;
string type = lstType.SelectedValue;
int price = Convert.ToInt32(txtPrice.Text.Trim());
int days = Convert.ToInt32(txtDays.Text.Trim());
int maxPeople = Convert.ToInt32(txtMaxPeople.Text.Trim());
string introduce = txtIntroduce.Text;
string attention = txtAttention.Text;
//插入数据库
SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["DataSource"].ConnectionString);
string insert = string.Format("insert into TourLine(LineName, LineType, LinePrice, LineDays, LineMaxPeople, LineIntroduce, LineAttention) values('{0}', '{1}', {2}, {3}, {4}, '{5}', '{6}')", name, type, price, days, maxPeople, introduce, attention);
SqlCommand cmd = new SqlCommand(insert, connection);
try {
connection.Open();
cmd.ExecuteNonQuery();
connection.Close();
ClientScript.RegisterStartupScript(Page.GetType(), "Message", "<script>alert('添加成功');location.href('/Admin/Manage.aspx')</script>");
} catch {
}
} else { // 编辑信息
int id = Convert.ToInt32(Request["id"]);
var dataSet = new TourLineTableAdapter().GetDataByID(id).Single();
if (string.IsNullOrEmpty(txtName.Text.Trim()) || string.IsNullOrEmpty(txtPrice.Text.Trim()) ||
string.IsNullOrEmpty(txtDays.Text.Trim()) || string.IsNullOrEmpty(txtMaxPeople.Text.Trim()) ||
string.IsNullOrEmpty(txtIntroduce.Text) || string.IsNullOrEmpty(txtAttention.Text)) {
ClientScript.RegisterStartupScript(Page.GetType(), "ss", "<script>alert('请按要求输入完整信息')</script>");
return;
}
dataSet.LineName = txtName.Text;
dataSet.LineType = lstType.SelectedValue;
dataSet.LinePrice = Convert.ToInt32(txtPrice.Text.Trim());
dataSet.LineDays = Convert.ToInt32(txtDays.Text.Trim());
dataSet.LineMaxPeople = Convert.ToInt32(txtMaxPeople.Text.Trim());
dataSet.LineIntroduce = txtIntroduce.Text;
dataSet.LineAttention = txtAttention.Text;
new TourLineTableAdapter().Update(dataSet);
//if (action == "edit") {
ClientScript.RegisterStartupScript(Page.GetType(), "Message", "<script>alert('修改成功');location.href('/Admin/Manage.aspx')</script>");
//} else {
//ClientScript.RegisterStartupScript(Page.GetType(), "Message", "<script>alert('添加成功');location.href('/Admin/Manage.aspx')</script>");
//}
}
}
protected void btnReserve_Click(object sender, EventArgs e)
{
if (Session["UserName"] == null) {
Response.Redirect("~/UserLogin.aspx");
} else {
int lineId = Convert.ToInt32(Request["id"]);
var lineTable = new TourLineTableAdapter().GetDataByID(lineId);
var lineRow = lineTable.Single();
// 判断当天余量是否充足
long lineID = lineRow.LineID; // 订单编号
int maxPeople = lineRow.LineMaxPeople; // 最大人数
DateTime travelTime = CaleOrderTime.SelectedDate.Date; // 旅行日期
if (travelTime == DateTime.Parse("0001-01-01")) { // 判断是否选择合法日期
ClientScript.RegisterStartupScript(Page.GetType(), "ss", "<script>alert('请选择日期')</script>");
return;
}
// 获取已选人数
string count = string.Format("select count(*) as ordered from OrderInfo where LineID={0} and TravelDate='{1}';", lineID, travelTime);
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["DataSource"].ConnectionString);
SqlCommand cmd = new SqlCommand(count, conn);
try {
conn.Open(); // 打开数据库连接
int ordered = (int)(cmd.ExecuteScalar()); // 获取已选人数
if (ordered >= maxPeople) {
ClientScript.RegisterStartupScript(Page.GetType(), "ss", "<script>alert('Sorry，当前已选人数已满，请更换日期')</script>");
}
} catch {
} finally {
conn.Close(); // 关闭数据库连接
}
string orderID =
DateTime.Now.ToString("yyyyMMddHHmmss") + Session["UserName"].ToString(); // 订单编号
// 将此订单加入数据库
string insert = string.Format(@"insert into OrderInfo(OrderID, UserName, LineID, TravelDate, IsComplete, IsComment)
Values('{0}', '{1}', {2}, '{3}', {4}, {5})", orderID, Session["UserName"].ToString(), lineID, travelTime, 0, 0);
SqlCommand insertCmd = new SqlCommand(insert, conn);
try {
conn.Open();
insertCmd.ExecuteNonQuery();
ClientScript.RegisterStartupScript(Page.GetType(), "ss", "<script>alert('订购成功');{location.href='UserViewOrders.aspx'}</script>");
} catch {
} finally {
conn.Close();
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack) {
string action = Request["action"];
if (action == "edit") {
this.Title = "修改线路";
int id = Convert.ToInt32(Request["id"]);
var dataSet = new TourLineTableAdapter().GetDataByID(id).Single();
txtName.Text = dataSet.LineName;
lstType.Text = dataSet.LineType;
txtPrice.Text = dataSet.LinePrice.ToString();
txtDays.Text = dataSet.LineDays.ToString();
txtMaxPeople.Text = dataSet.LineMaxPeople.ToString();
txtIntroduce.Text = dataSet.LineIntroduce;
txtAttention.Text = dataSet.LineAttention;
} else {
this.Title = "添加线路";
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack) {
int lineId = Convert.ToInt32(Request["id"]);
var lineTable = new TourLineTableAdapter().GetDataByID(lineId);
if (lineTable.Count <= 0) {
litLineName.Text = "线路不存在";
}
var lineRow = lineTable.Single();
litLineName.Text = lineRow.LineName;
litLineType.Text = lineRow.LineType;
litLinePrice.Text = lineRow.LinePrice.ToString() + "￥";
litLineDays.Text = lineRow.LineDays.ToString() + "天";
litLineMaxPeople.Text = lineRow.LineMaxPeople.ToString() + "人";
litLineIntroduce.Text = lineRow.LineIntroduce;
litLineAttention.Text = lineRow.LineAttention;
this.Title = litLineName.Text;
// 显示评论
SqlConnection conn = new System.Data.SqlClient.SqlConnection(ConfigurationManager.ConnectionStrings["DataSource"].ConnectionString);
string select = string.Format("select UserName, Grade, Content from CommentTable where LineID={0}", Convert.ToInt32(Request["id"]));
DataSet dataset = new DataSet();
try {
conn.Open();
SqlDataAdapter adapter = new System.Data.SqlClient.SqlDataAdapter(select, conn);
adapter.Fill(dataset);
GridView1.DataSource = dataset;
GridView1.DataBind();
} finally {
conn.Close();
}
// 综合评分
var table = new GradeTableAdapters.CommentTableTableAdapter();
int? count = table.ScalarQueryCount(Convert.ToInt32(Request["id"]));
double? sum = table.ScalarQuerySum(Convert.ToInt32(Request["id"]));
if ((count == null) || (sum == null)) {
litGrade.Text = "尚无评分";
} else {
litGrade.Text = (sum / count).ToString() + "/5";
}
}
}