/// <summary> /// 更改后的信息保存 /// </summary> /// <param name="obj">要保存的对象</param> /// <param name="status">是增加还是修改还是删除</param> /// <returns></returns> public bool SaveReserveInfo(Object obj, string status) { ReserveInfo reserveInfo = (ReserveInfo)obj; try { if (status == "added") { reserveInfoDAL.Insert(reserveInfo); } else if (status == "edit") { reserveInfoDAL.Update(reserveInfo); } else { reserveInfoDAL.Delete(reserveInfo.ReserveNo); } } catch (Exception e) { return(false); } return(true); }
/// <summary> /// 更新数据 /// </summary> /// <param name="entity">要更新的数据对象</param> /// <returns></returns> public bool Update(ReserveInfo entity) { string sql = @"update RoomInfo set reserveno=@reserveno,reservename=@reservename,reserveperson=@reserveperson,reservephone=@reservephone,reservenum=@reservenum,starttime=@starttime,endtime=@endtime,reservecost=@reservecost where reserveno=@reserveno"; SqlParameter[] pms = new SqlParameter[] { new SqlParameter("@reserveno", entity.ReserveNo), new SqlParameter("@reservename", entity.ReserveName), new SqlParameter("@reserveperson", entity.ReservePerson), new SqlParameter("@reservephone", entity.ReservePhone), new SqlParameter("@reservenum", entity.ReserveNum), new SqlParameter("@starttime", entity.StartTime), new SqlParameter("@endtime", entity.EndTime), new SqlParameter("@reservecost", entity.ReserveCost) }; int r = SqlHelper.ExecuteNonQuery(sql, CommandType.Text, pms); if (r > 0) { return(true); } else { return(false); } }
/// <summary> /// 插入新数据 /// </summary> /// <param name="entity">要插入的数据对象</param> /// <returns></returns> public bool Insert(ReserveInfo entity) { string sql = "insert into ReserveInfo(reserveno,tableno,peoplenum,starttime,endtime,reservestatus,notes) " + "values(@reserveno,@tableno,@peoplenum,@starttime,@endtime,@reservestatus,@notes)"; SqlParameter[] pms = new SqlParameter[] { new SqlParameter("@reserveno", entity.ReserveNo), new SqlParameter("@tableno", entity.TableNo), new SqlParameter("@peoplenum", entity.PeopleNum), new SqlParameter("@starttime", entity.StartTime), new SqlParameter("@endtime", entity.EndTime), new SqlParameter("@reservestatus", entity.ReserveStatus), new SqlParameter("@notes", entity.Notes), }; int r = SqlHelper.ExecuteNonQuery(sql, CommandType.Text, pms); if (r > 0) { return(true); } else { return(false); } }
/// <summary> /// 查询分页的餐桌信息列表 /// </summary> /// <param name="pageIndex">第几页</param> /// <param name="pageSize">每页多少条</param> /// <returns></returns> public List <ReserveInfo> GetReserveList(int pageIndex, int pageSize) { string sql = selectSql + " order by starttime desc offset(@pageIndex)*@pageSize rows fetch next @pageSize rows only"; List <ReserveInfo> reserveList = new List <ReserveInfo>(); SqlParameter[] pms = new SqlParameter[] { new SqlParameter("@pageIndex", pageIndex), new SqlParameter("@pageSize", pageSize) }; SqlDataReader reader = SqlHelper.ExecuteReader(sql, CommandType.Text, pms); if (reader.HasRows) { while (reader.Read()) { ReserveInfo reserveInfo = new ReserveInfo(); reserveInfo.ReserveNo = reader.GetString(0); reserveInfo.TableNo = reader.GetString(1); reserveInfo.PeopleNum = reader.GetInt32(2); reserveInfo.StartTime = reader.GetDateTime(3); reserveInfo.EndTime = reader.GetDateTime(4); reserveInfo.ReserveStatus = reader.GetInt32(5); reserveInfo.Notes = reader.GetString(6); reserveList.Add(reserveInfo); } } reader.Close(); return(reserveList); }
/// <summary> /// 插入新数据 /// </summary> /// <param name="entity">要插入的数据对象</param> /// <returns></returns> public bool Insert(ReserveInfo entity) { string sql = "insert into ReserveInfo(reserveno,reservename,reserveperson,reservephone,reservenum,starttime,endtime,reservecost) " + "values(@reserveno,@reservename,@reserveperson,@reservephone,@reservenum,@starttime,@endtime,@reservecost)"; SqlParameter[] pms = new SqlParameter[] { new SqlParameter("@reserveno", entity.ReserveNo), new SqlParameter("@reservename", entity.ReserveName), new SqlParameter("@reserveperson", entity.ReservePerson), new SqlParameter("@reservephone", entity.ReservePhone), new SqlParameter("@reservenum", entity.ReserveNum), new SqlParameter("@starttime", entity.StartTime), new SqlParameter("@endtime", entity.EndTime), new SqlParameter("@reservecost", entity.ReserveCost) }; int r = SqlHelper.ExecuteNonQuery(sql, CommandType.Text, pms); string sql2 = @"update RoomInfo set roomsurplus=roomsurplus-1 where roomname=@roomname "; SqlParameter pms2 = new SqlParameter("@roomname", entity.ReserveName); int r2 = SqlHelper.ExecuteNonQuery(sql2, CommandType.Text, pms2); if (r > 0 && r2 > 0) { return(true); } else { return(false); } }
/// <summary> /// 保存预订信息 /// </summary> /// <param name="context"></param> public void SaveReserveInfo(HttpContext context) { var data = JSON.Decode(context.Request["data"]); Hashtable i = (Hashtable)data; ReserveInfo reserveInfo = new ReserveInfo(); string status = null; reserveInfo.ReserveNo = (string)i["ReserveNo"]; reserveInfo.ReserveName = (string)i["ReserveName"]; reserveInfo.ReservePerson = (string)i["ReservePerson"]; reserveInfo.ReservePhone = (string)i["ReservePhone"]; //reserveInfo.ReserveNum = Convert.ToInt32(i["RoomCost"]);. //reserveInfo.ReserveCost = Convert.ToInt32(i["RoomSurplus"]); reserveInfo.StartTime = (DateTime)i["StartTime"]; reserveInfo.EndTime = (DateTime)i["EndTime"]; TimeSpan sp = reserveInfo.EndTime.Subtract(reserveInfo.StartTime); reserveInfo.ReserveNum = sp.Days; reserveInfo.ReserveCost = roomInfoBLL.GetReserveCostByReserveName(reserveInfo.ReserveName) * reserveInfo.ReserveNum; status = (string)i["Status"]; bool r = reserveInfoBLL.SaveReserveInfo(reserveInfo, status); if (r) { String json = JSON.Encode("保存成功!"); context.Response.Write(json); } else { String json = JSON.Encode("保存失败!"); context.Response.Write(json); } }
/// <summary> /// 保存信息 /// </summary> /// <param name="context"></param> public void SaveReserveInfo(HttpContext context) { var data = JSON.Decode(context.Request["data"]); if (data is Hashtable) { Hashtable hs = (Hashtable)JSON.Decode(context.Request["data"]); ReserveInfo reserveInfo = new ReserveInfo(); string status = null; reserveInfo.ReserveNo = (string)hs["ReserveNo"]; reserveInfo.TableNo = (string)hs["TableNo"]; reserveInfo.PeopleNum = Convert.ToInt32(hs["PeopleNum"]); reserveInfo.StartTime = Convert.ToDateTime(hs["StartTime"]); reserveInfo.EndTime = Convert.ToDateTime(hs["EndTime"]); reserveInfo.ReserveStatus = Convert.ToInt32(hs["ReserveStatus"]); reserveInfo.Notes = (string)hs["Notes"]; status = (string)hs["Status"]; bool r = reserveInfoBLL.SaveReserveInfo(reserveInfo, status); if (r) { String json = JSON.Encode("成功!"); context.Response.Write(json); } else { String json = JSON.Encode("失败!"); context.Response.Write(json); } } else if (data is ArrayList) { ArrayList i = (ArrayList)JSON.Decode(context.Request["data"]); ReserveInfo reserveInfo = new ReserveInfo(); string status = null; foreach (var item in i) { Hashtable hs = (Hashtable)item; reserveInfo.ReserveNo = (string)hs["ReserveNo"]; reserveInfo.TableNo = (string)hs["TableNo"]; reserveInfo.PeopleNum = Convert.ToInt32(hs["PeopleNum"]); reserveInfo.StartTime = Convert.ToDateTime(hs["StartTime"]); reserveInfo.EndTime = Convert.ToDateTime(hs["EndTime"]); reserveInfo.ReserveStatus = Convert.ToInt32(hs["ReserveStatus"]); reserveInfo.Notes = (string)hs["Notes"]; status = (string)hs["Status"]; } bool r = reserveInfoBLL.SaveReserveInfo(reserveInfo, status); if (r) { String json = JSON.Encode("成功!"); context.Response.Write(json); } else { String json = JSON.Encode("失败!"); context.Response.Write(json); } } }
public ActionResult Edit([FromQuery] int Id) { ReserveInfo item = Reserve.GetItem(Id); if (item == null) { return(APIReturn.记录不存在_或者没有权限); } ViewBag.item = item; return(View()); }
/// <summary> /// 订单管理页面 /// </summary> /// <returns></returns> public ActionResult OrderListIndex() { var db = new HotelDatabase(); var reserveInfoData = new ReserveInfo(); var lst = db.ReserveInfos.AsQueryable(); ViewBag.ReserveInfoData = lst.OrderByDescending(o => o.OrderId).ToList(); ViewData["sysname"] = GetSysAdminName(); return(View()); }
/// <summary> /// 订单修改保存 /// </summary> /// <param name="changeSaveModel"></param> /// <returns></returns> public ActionResult OrderListEditSave(ReserveInfo changeSaveModel) { var db = new HotelDatabase(); var changeSave = db.ReserveInfos.First(o => o.OrderId == changeSaveModel.OrderId); changeSave.OrderName = changeSaveModel.OrderName; changeSave.OrderIdCard = changeSaveModel.OrderIdCard; changeSave.Tel = changeSaveModel.Tel; db.SaveChanges(); return(RedirectToAction("OrderListIndex")); }
public APIReturn _Add([FromForm] int?Id, [FromForm] int?Mroom_id, [FromForm] DateTime?Datetime1, [FromForm] short?Use_minute, [FromForm] string Username) { ReserveInfo item = new ReserveInfo(); item.Id = Id; item.Mroom_id = Mroom_id; item.Create_time = DateTime.Now; item.Datetime1 = Datetime1; item.Use_minute = Use_minute; item.Username = Username; item = Reserve.Insert(item); return(APIReturn.成功.SetData("item", item.ToBson())); }
/// <summary> /// 保存预定信息 /// </summary> /// <returns></returns> public ActionResult OrderSave(ReserveInfo model) { var flag = false; if (HttpContext.User.Identity.IsAuthenticated == true) //已登录 { var db = new HotelDatabase(); db.Database.CreateIfNotExists(); var saveInfo = new ReserveInfo(); var lst = db.Suites.AsQueryable().Where(o => o.SuiteType.Contains(model.SuiteType)); ///查询价格 var price = 100; foreach (var q in lst) { if (true) { price = q.SuitePrice; break; } } //var d1 = model.ArrivalTime; //var d2 = model.ArrivalTime; //var dtArrival = d1.ToString("yyyy/MM/dd"); //var dtLevel = d2.ToString("yyyy/MM/dd"); saveInfo.UserName = User.Identity.GetUserName(); //当前登录用户 saveInfo.OrderName = model.OrderName; saveInfo.OrderIdCard = model.OrderIdCard; saveInfo.OrderTime = DateTime.Now; saveInfo.SuiteType = model.SuiteType; saveInfo.OrderNunber = model.OrderNunber; saveInfo.ArrivalTime = model.ArrivalTime; saveInfo.LeaveTime = model.LeaveTime; saveInfo.Tel = model.Tel; saveInfo.TotalPrice = price * model.OrderNunber; db.ReserveInfos.Add(saveInfo); db.SaveChanges(); flag = true; } if (flag == true) { //return Content("<script> alert('预订成功'); </script>"); return(View()); } else { return(RedirectToAction("Login", "Account")); } }
public (bool isSuccess, string reservedVhID, string reservedSecID) askReserveSuccess(SectionBLL sectionBLL, string vhID, string sectionID, string addressID) { RepeatedField <ReserveInfo> reserveInfos = new RepeatedField <ReserveInfo>(); ASECTION current_section = sectionBLL.cache.GetSection(sectionID); DriveDirction driveDirction = SCUtility.isMatche(current_section.FROM_ADR_ID, addressID) ? DriveDirction.DriveDirForward : DriveDirction.DriveDirReverse; ReserveInfo info = new ReserveInfo() { //DriveDirction = DriveDirction.DriveDirForward, DriveDirction = driveDirction, ReserveSectionID = sectionID }; reserveInfos.Add(info); return(IsReserveSuccessNew(vhID, reserveInfos, isAsk: true)); }
/// <summary> /// 查询分页的预订信息列表 /// </summary> /// <param name="pageIndex">第几页</param> /// <param name="pageSize">每页多少条</param> /// <returns></returns> public List <ReserveInfo> GetReserveInfoList(int pageIndex, int pageSize, string sortField, string sortOrder) { string sql = null; if (string.IsNullOrEmpty(sortField) && string.IsNullOrEmpty(sortOrder)) { sql = selectSql + " order by reserveno offset(@pageIndex)*@pageSize rows fetch next @pageSize rows only"; } else if (!string.IsNullOrEmpty(sortField) && string.IsNullOrEmpty(sortOrder)) { sql = selectSql + " order by " + sortField + " offset(@pageIndex)*@pageSize rows fetch next @pageSize rows only"; } else if (!string.IsNullOrEmpty(sortField) && !string.IsNullOrEmpty(sortOrder)) { sql = selectSql + " order by " + sortField + " " + sortOrder + " offset(@pageIndex)*@pageSize rows fetch next @pageSize rows only"; } List <ReserveInfo> reserveInfoList = new List <ReserveInfo>(); SqlParameter[] pms = new SqlParameter[] { new SqlParameter("@pageIndex", pageIndex), new SqlParameter("@pageSize", pageSize) }; SqlDataReader reader = SqlHelper.ExecuteReader(sql, CommandType.Text, pms); if (reader.HasRows) { while (reader.Read()) { ReserveInfo reserveInfo = new ReserveInfo(); reserveInfo.ReserveNo = reader.GetString(0); reserveInfo.ReserveName = reader.GetString(1); reserveInfo.ReservePerson = reader.GetString(2); reserveInfo.ReservePhone = reader.GetString(3); reserveInfo.ReserveNum = reader.GetInt32(4); reserveInfo.StartTime = reader.GetDateTime(5); reserveInfo.EndTime = reader.GetDateTime(6); reserveInfo.ReserveCost = reader.GetInt32(7); reserveInfoList.Add(reserveInfo); } } reader.Close(); return(reserveInfoList); }
/// <summary> /// 根据ReserveNo获取单个预约信息 /// </summary> /// <param name="context"></param> public void GetEntityByReserveNo(HttpContext context) { string reserveNo = context.Request["ReserveNo"]; ReserveInfo reserveInfo = reserveInfoBLL.GetEntityByReserveNo(reserveNo); Hashtable hs = new Hashtable(); hs["ReserveNo"] = reserveInfo.ReserveNo; hs["TableNo"] = reserveInfo.TableNo; hs["PeopleNum"] = reserveInfo.PeopleNum; hs["StartTime"] = reserveInfo.StartTime; hs["EndTime"] = reserveInfo.EndTime; hs["ReserveStatus"] = reserveInfo.ReserveStatus; hs["Notes"] = reserveInfo.Notes; String json = JSON.Encode(hs); context.Response.Write(json); }
private void ConfirmDate(DateTimePicker dtp) { ReserveDay = new ReserveInfo(); WorkingDay = new SettingsInfo(); PublicHolidayDay = new PublicHolidayInfo(); AppointmentInfo.Appointment = dtp.Value.Date; Proceed = false; n = 0; while (!Proceed) { AppointmentOK(false); Proceed = true; AppointmentInfo.Appointment = AppointmentInfo.Appointment.AddDays(n); if (ReserveDay.DateIsReserved()) { if (ProceedR = ReserveDay.DateIsReserve()) { Proceed = false; n = 1; } else { return; } } if ((AppointmentInfo.Appointment.DayOfWeek == DayOfWeek.Thursday) && (lblAgeunit.Text == "Y") && (Convert.ToInt32(lblAge.Text) > 20)) { Proceed = false; n = 1; } if (ProceedW = !WorkingDay.DateIsOK()) { Proceed = false; n = 1; } if (ProceedP = PublicHolidayDay.DateIsHoliday()) { Proceed = false; n = 1; } } AppointmentOK(true); }
public APIReturn _Edit([FromQuery] int Id, [FromForm] int?Mroom_id, [FromForm] DateTime?Datetime1, [FromForm] short?Use_minute, [FromForm] string Username) { ReserveInfo item = Reserve.GetItem(Id); if (item == null) { return(APIReturn.记录不存在_或者没有权限); } item.Mroom_id = Mroom_id; item.Create_time = DateTime.Now; item.Datetime1 = Datetime1; item.Use_minute = Use_minute; item.Username = Username; int affrows = Reserve.Update(item); if (affrows > 0) { return(APIReturn.成功.SetMessage($"更新成功,影响行数:{affrows}")); } return(APIReturn.失败); }
/// <summary> /// 查询单个实体对象 /// </summary> /// <param name="reserveNo">要查询的对象的编号</param> /// <returns></returns> public ReserveInfo GetEntityByTableNo(string tableNo) { string sql = selectSql + " where tableno=@tableno"; SqlParameter pms = new SqlParameter("@tableno", tableNo); SqlDataReader reader = SqlHelper.ExecuteReader(sql, CommandType.Text, pms); ReserveInfo reserveInfo = new ReserveInfo(); if (reader.HasRows) { while (reader.Read()) { reserveInfo.ReserveNo = reader.GetString(0); reserveInfo.TableNo = reader.GetString(1); reserveInfo.PeopleNum = reader.GetInt32(2); reserveInfo.StartTime = reader.GetDateTime(3); reserveInfo.EndTime = reader.GetDateTime(4); reserveInfo.ReserveStatus = reader.GetInt32(5); reserveInfo.Notes = reader.GetString(6); } } reader.Close(); return(reserveInfo); }
/// <summary> /// 查询单个实体对象 /// </summary> /// <param name="roomId">要查询的对象的编号</param> /// <returns></returns> public ReserveInfo GetEntity(string reserveNo) { string sql = selectSql + " where reserveno=@reserveno"; SqlParameter pms = new SqlParameter("@reserveno", reserveNo); SqlDataReader reader = SqlHelper.ExecuteReader(sql, CommandType.Text, pms); ReserveInfo reserveInfo = new ReserveInfo(); if (reader.HasRows) { while (reader.Read()) { reserveInfo.ReserveNo = reader.GetString(0); reserveInfo.ReserveName = reader.GetString(1); reserveInfo.ReservePerson = reader.GetString(2); reserveInfo.ReservePhone = reader.GetString(3); reserveInfo.ReserveNum = reader.GetInt32(4); reserveInfo.StartTime = reader.GetDateTime(5); reserveInfo.EndTime = reader.GetDateTime(6); reserveInfo.ReserveCost = reader.GetInt32(7); } } reader.Close(); return(reserveInfo); }
/// <summary> /// 更新数据 /// </summary> /// <param name="entity">要更新的数据对象</param> /// <returns></returns> public bool Update(ReserveInfo entity) { string sql = @"update ReserveInfo set reserveno=@reserveno,tableno=@tableno,peoplenum=@peoplenum,starttime=@starttime,endtime=@endtime,reservestatus=@reservestatus,notes=@notes where reserveno=@reserveno"; SqlParameter[] pms = new SqlParameter[] { new SqlParameter("@reserveno", entity.ReserveNo), new SqlParameter("@tableno", entity.TableNo), new SqlParameter("@peoplenum", entity.PeopleNum), new SqlParameter("@starttime", entity.StartTime), new SqlParameter("@endtime", entity.EndTime), new SqlParameter("@reservestatus", entity.ReserveStatus), new SqlParameter("@notes", entity.Notes), }; if (entity.ReserveStatus == 1) { string sql2 = @"update TableInfo set isuse=1 where tableno=@tableno"; SqlParameter pms2 = new SqlParameter("@tableno", entity.TableNo); int r = SqlHelper.ExecuteNonQuery(sql, CommandType.Text, pms); int r2 = SqlHelper.ExecuteNonQuery(sql2, CommandType.Text, pms2); if (r > 0 && r2 > 0) { return(true); } else { return(false); } } else if (entity.ReserveStatus == 0) { string sql2 = @"update TableInfo set isuse=0 where tableno=@tableno"; SqlParameter pms2 = new SqlParameter("@tableno", entity.TableNo); int r = SqlHelper.ExecuteNonQuery(sql, CommandType.Text, pms); int r2 = SqlHelper.ExecuteNonQuery(sql2, CommandType.Text, pms2); if (r > 0 && r2 > 0) { return(true); } else { return(false); } } else if (entity.ReserveStatus == 2) { string sql2 = @"update TableInfo set isuse=0 where tableno=@tableno"; SqlParameter pms2 = new SqlParameter("@tableno", entity.TableNo); int r = SqlHelper.ExecuteNonQuery(sql, CommandType.Text, pms); int r2 = SqlHelper.ExecuteNonQuery(sql2, CommandType.Text, pms2); if (r > 0 && r2 > 0) { return(true); } else { return(false); } } else { int r = SqlHelper.ExecuteNonQuery(sql, CommandType.Text, pms); if (r > 0) { return(true); } else { return(false); } } }
/// <summary> /// 增 /// </summary> /// <param name="entity">要插入的数据数据对象</param> /// <returns></returns> public bool Insert(ReserveInfo entity) { return(reserveInfoDAL.Insert(entity)); }
private void HandleDistrictReserveSuccess(object sender, ReserveInfo reserveInfo) { State = ClientState.WorldServerDistrictEnterInProgress; WorldClient.AskDistrictEnter(); }
/// <summary> /// 更新 /// </summary> /// <param name="entity">要更新的数据对象</param> /// <returns></returns> public bool Update(ReserveInfo entity) { return(reserveInfoDAL.Update(entity)); }