public BookTicketInfoExModel getByIdAndTypes1(int id) { string sql = @"SELECT bti.Id ,TrainNumber ,StartStation ,EndStation ,BookDate ,StudentId ,Phone ,Remark ,TicketSate FROM dbo.BookTicketInfo bti INNER JOIN dbo.BookTicketState bts ON bti.Id = bts.BookTicketInfoId INNER JOIN dbo.Student s ON bti.StudentId = s.Id INNER JOIN dbo.SysRole sr ON s.RoleId = sr.RoleId WHERE Types = 1 AND bti.Id = @Id"; SqlParameter par = new SqlParameter("@Id", SqlDbType.Int); par.Value = id; BookTicketInfoExModel model = null; DataTable dt = MSSQL.query(sql, par); if (dt.Rows.Count > 0) { model = Utils.dataTable2List <BookTicketInfoExModel>(dt)[0]; } return(model); }
protected void btnSave_Click(object sender, EventArgs e) { this.model = new BookTicketInfoExModel(); this.model.TrainNumber = this.txtTrainNumber.Text.Trim(); this.model.StartStation = this.txtStartStation.Text.Trim(); this.model.EndStation = this.txtEndStation.Text.Trim(); if (DateTime.TryParse(this.txtBookDate.Text.Trim(), out DateTime bookDate)) { this.model.BookDate = bookDate; } else { this.Message = "预定日期格式不正确"; return; } this.model.Phone = this.txtPhone.Text.Trim(); this.model.Remark = this.txtRemark.Text.Trim(); if (Request["type"] == "add") { // 新增 // 获取当前登录账户 VwUserModel vwUserModel = (VwUserModel)Session["User"]; // 当前登录学生的票,所以该页面只允许普通学生或学生管理员登录 model.StudentId = vwUserModel.Id; // 最后的操作人这里也算作 该申请学生 if (bookTicketInfoBll.bookTicket(model, vwUserModel.Id)) { this.Message = "订票成功"; initControl(); } else { this.Message = "订票失败"; } } else if (Request["type"] == "edit") { // 编辑 this.model.Id = Convert.ToInt32(Request["id"]); if (bookTicketInfoBll.editModel(model) > 0) { Response.Redirect("BookTicketList.aspx"); } else { this.Message = "修改失败,请稍后再试"; } } }
private void loadBookTicketInfo(int id) { this.model = this.bookTicketInfoBll.getByIdAndTypes1(id); if (model != null) { this.txtTrainNumber.Text = this.model.TrainNumber; this.txtStartStation.Text = this.model.StartStation; this.txtEndStation.Text = this.model.EndStation; this.txtBookDate.Text = this.model.BookDate.ToString("yyyy-MM-dd"); this.txtPhone.Text = this.model.Phone; this.txtRemark.Text = this.model.Remark; this.txtState.Text = this.model.TicketSate.ToString(); } else { this.Message = "不存在此普通学生及学生管理员"; } }