/// <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));
}
