public IHttpActionResult PutOreder(long id, Oreder oreder) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != oreder.OrderId) { return(BadRequest()); } db.Entry(oreder).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!OrederExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
public static bool AddOrder(Oreder order) { SqlConnection con = DBConnect.DBOpen(); SqlCommand cmd = new SqlCommand("insert into " + DBConfig.Order + "([TKType],[TKPrice],[TKReserveTime],[TKUseTime],[TKSupplier],[TKImagSrc],[TKUserId],[TKNum],[TKSYId])" + "values(@TKType,@TKPrice,@TKReserveTime,@TKUseTime,@TKSupplier,@TKImagSrc,@TKUserId,@TKNum,@TKSYId)", con); cmd.Parameters.AddWithValue("@TKType", order.TKType); cmd.Parameters.AddWithValue("@TKPrice", order.TKPrice); cmd.Parameters.AddWithValue("@TKReserveTime", order.TKReserveTime); cmd.Parameters.AddWithValue("@TKUseTime", order.TKUseTime); cmd.Parameters.AddWithValue("@TKSupplier", order.TKSupplier); cmd.Parameters.AddWithValue("@TKImagSrc", order.TKImagSrc); cmd.Parameters.AddWithValue("@TKUserId", order.TKUserId); cmd.Parameters.AddWithValue("@TKNum", order.TKNum); cmd.Parameters.AddWithValue("@TKSYId", order.TKSYId); int count = cmd.ExecuteNonQuery(); if (count == 1) { DBConnect.DBClose(); SceneryAccess.SceneryUpdateForOrder(order); return(true); } DBConnect.DBClose(); return(false); }
public IHttpActionResult GetOreder(long id) { Oreder oreder = db.Oreder.Find(id); if (oreder == null) { return(NotFound()); } return(Ok(oreder)); }
public IHttpActionResult PostOreder(Oreder oreder) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } db.Oreder.Add(oreder); db.SaveChanges(); return(CreatedAtRoute("DefaultApi", new { id = oreder.OrderId }, oreder)); }
public IHttpActionResult DeleteOreder(long id) { Oreder oreder = db.Oreder.Find(id); if (oreder == null) { return(NotFound()); } db.Oreder.Remove(oreder); db.SaveChanges(); return(Ok(oreder)); }
/// <summary> /// 门票预订成功后更新相应景点的状态 /// </summary> /// <param name="order"></param> /// <returns></returns> public static bool SceneryUpdateForOrder(Oreder order) { SqlConnection con = DBConnect.DBOpen(); SqlCommand cmd = new SqlCommand("update " + DBConfig.Scenery + " set SYUseNum=SYUseNum+" + order.TKNum + " where SYId=" + order.TKSYId + "and [SYUseTime]='" + order.TKUseTime + "'", con); int count = cmd.ExecuteNonQuery(); if (count == 1) { DBConnect.DBClose(); return(true); } DBConnect.DBClose(); return(false); }
/// <summary> /// 门票预订 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btBook_Click(object sender, EventArgs e) { if (scenery.SYUseNum >= scenery.SYTotal) { MessageBox.Show("当前时间的门票已售罄!"); } else { Oreder order = new Oreder(); order.TKType = this.cbTicketType.SelectedIndex; order.TKReserveTime = DateTime.Now; order.TKUseTime = Convert.ToDateTime(this.dtpUseTime.Text); order.TKNum = Convert.ToInt32(this.nudTicketNum.Value); order.TKUserId = UserId; order.TKSupplier = scenery.SYSupplier; order.TKImagSrc = scenery.SYImagSrc; order.TKPrice = Convert.ToInt32(this.lbPrice2.Text); order.TKSYId = scenery.SYId; #region 订票验证 if (order.TKNum != 0) { if (UserId != -1) { if (SceneryAccess.ShowSceneryByUseTime(order.TKUseTime)) { if (this.cbTicketType.SelectedIndex != -1) { if (OrderAccess.AddOrder(order)) { #region MyRegion if (DistributorAccess.SelectById(UserId)) { this.Visible = false; DistributorUser distributorUser = new DistributorUser(UserId); distributorUser.Show(); } else { MessageBox.Show("预订成功!"); this.Visible = false; Homepage homePage = new Homepage(UserId); homePage.Show(); } } else { MessageBox.Show("订票失败!"); } #endregion } else { MessageBox.Show("请选择票型"); } } else { MessageBox.Show("当前门票暂时没有上线,请晚些时候再来!"); } } else { MessageBox.Show("请登录后再订票!"); } #endregion } else { MessageBox.Show("请选择预订数量!"); } } }