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("请选择预订数量！");
}
}
}
