/// <summary>
/// 动态加载会议室数据
/// </summary>
/// <returns></returns>
private void RoomGetCha()
{
RoomManageBLL room = new RoomManageBLL();
var table = room.Room_getCha();
Serialize1(table);
}
/// <summary>
/// 会议室管理资源图
/// </summary>
/// <returns></returns>
public void Select_infroations()
{
RoomManageBLL room = new RoomManageBLL();
var table = room.Select_infroations();
Serialize1(table);
}
/// <summary>
/// 会议室邀请人
/// </summary>
/// <param name="Wirte"></param>
private void RoomsPeople()
{
RoomManageBLL room = new RoomManageBLL();
var s = HttpContext.Current.Request.Form["id"];
var table = room.RoomPeople(s);
Serialize1(table);
}
/// <summary>
/// 会议室管理资源图按条件查询
/// </summary>
/// <returns></returns>
public void Select_infroationsNmae()
{
string name = HttpContext.Current.Request.Form["Name"];
RoomManageBLL room = new RoomManageBLL();
var table = room.Select_infroationName(name);
Serialize1(table);
}
/// <summary>
///根据id 查询会议室信息:Rooms_Content
/// </summary>
/// <returns></returns>
private void RoomsContents_GetCha()
{
int id = 4;
RoomManageBLL room = new RoomManageBLL();
var table = room.RoomsContents_getCha(id);
Serialize1(table);
}
/// <summary>
/// 会议室预约人：Rooms_Information
/// </summary>
public void Rooms_Informations_OrderSelects()
{
RoomManageBLL room = new RoomManageBLL();
JavaScriptSerializer js = new JavaScriptSerializer();
var table = room.Rooms_Informations_OrderSelects();
string str = js.Serialize(table);
HttpContext.Current.Response.Write(str);
HttpContext.Current.Response.End();
}
/// <summary>
/// 根据会议名称查询会议室数据
/// 根据会议室名称查询会议室数据
/// </summary>
/// <returns></returns>
private void Room_getChaName()
{
string Conference_Room_Name = HttpContext.Current.Request.Form["Conference_Room_Name"];
string Name_Meeting = HttpContext.Current.Request.Form["Name_Meeting"];
BLL.RoomManageBLL a = new RoomManageBLL();
var b = a.Room_getChaName(Name_Meeting, Conference_Room_Name);
Serialize1(b);
}
/// <summary>
/// 会议室
/// </summary>
/// <returns></returns>
private void Rooms()
{
BLL.RoomManageBLL room = new RoomManageBLL();
JavaScriptSerializer js = new JavaScriptSerializer();
var table = room.GetRooms();
string str = js.Serialize(table);
HttpContext.Current.Response.Write(str);
HttpContext.Current.Response.End();
}
/// <summary>
/// 会议室预约人：Rooms_Information
/// </summary>
/// <returns></returns>
public void Rooms_InformationsOrders()
{
var id = HttpContext.Current.Request.Form["DepartID"];
RoomManageBLL room = new RoomManageBLL();
JavaScriptSerializer js = new JavaScriptSerializer();
var table = room.Rooms_Informations_Orders(id);
string str = js.Serialize(table);
HttpContext.Current.Response.Write(str);
HttpContext.Current.Response.End();
}
/// <summary>
/// 会议室申请保存按钮
/// </summary>
/// <returns></returns>
private void RoomApplay()
{
ConferenceManagement management = new ConferenceManagement();
management.ConferenceID = Convert.ToInt32(HttpContext.Current.Request.Form["ConferenceID"]);//id
management.UserId = new User {
UserID = 7
}; //发起人
management.Inviter = HttpContext.Current.Request.Form["Inviter"]; //邀请人
management.FormMeeting = HttpContext.Current.Request.Form["FormMeeting"]; //会议名称
management.NameMeeting = HttpContext.Current.Request.Form["NameMeeting"]; //会议形式
//management.DepartID = new Department
//{
// DepartID = 7,//部门id
// //DepartName=HttpContext.Current.Request.Form["DepartName"]
//};
management.DepartID = new Department {
DepartID = Convert.ToInt32(HttpContext.Current.Request.Form["DepartID"])
};
management.ConferenceBeginTime = HttpContext.Current.Request.Form["ConferenceBeginTime"]; //开始时间
management.ConferenceEndTime = HttpContext.Current.Request.Form["ConferenceEndTime"]; //结束时间
management.ConferenceRoomID = new ConferenceRoomManagement {
ConferenceRoomID = Convert.ToInt32(HttpContext.Current.Request.Form["ConferenceRoomID"])
}; //会议室id
management.MeetingStatus = HttpContext.Current.Request.Form["MeetingStatus"]; //会议室状态
management.MeetingDescribes = HttpContext.Current.Request.Form["MeetingDescribes"]; //描述
RoomManageBLL room = new RoomManageBLL();
var r = room.RoomApplay_baoc(management);
JavaScriptSerializer js = new JavaScriptSerializer();
var obj = new { msg = "添加失败", code = 201 };
if (r)
{
obj = new { msg = "添加成功", code = 200 };
}
string str = js.Serialize(obj);
HttpContext.Current.Response.Write(str);
HttpContext.Current.Response.End();
}
/// <summary>
/// 会议室修改页面
/// </summary>
/// <returns></returns>
public void ROOMS_Update()
{
ConferenceManagement management = new ConferenceManagement();
management.ConferenceID = Convert.ToInt32(HttpContext.Current.Request.Form["ConferenceID"]);//id
management.UserId = new User {
UserID = 7
}; //发起人
management.Inviter = HttpContext.Current.Request.Form["Inviter"]; //邀请人
management.FormMeeting = HttpContext.Current.Request.Form["FormMeeting"]; //会议名称
management.NameMeeting = HttpContext.Current.Request.Form["NameMeeting"]; //会议形式
management.DepartID = new Department
{
DepartID = 7,//部门id
//DepartName=HttpContext.Current.Request.Form["DepartName"]
};
management.ConferenceBeginTime = HttpContext.Current.Request.Form["ConferenceBeginTime"]; //开始时间
management.ConferenceEndTime = HttpContext.Current.Request.Form["ConferenceEndTime"]; //结束时间
management.ConferenceRoomID = new ConferenceRoomManagement {
ConferenceRoomID = 1,
}; //会议室id
management.MeetingStatus = HttpContext.Current.Request.Form["MeetingStatus"]; //会议室状态
management.MeetingDescribes = HttpContext.Current.Request.Form["MeetingDescribes"]; //描述
RoomManageBLL room = new RoomManageBLL();
var a = room.ROOMS_Update(management);
var obj = new { msg = "修改成功！", code = 200 };
if (!room.ROOMS_Update(management))
{
obj = new { msg = "修改失败！", code = 201 };
}
JavaScriptSerializer js = new JavaScriptSerializer();
string rs = js.Serialize(obj);
HttpContext.Current.Response.Write(rs);
HttpContext.Current.Response.End();
}
/// <summary>
/// 会议室审核保存按钮
/// </summary>
/// <returns></returns>
private void RoomExmin_baoC()
{
ConferenceManagement management = new ConferenceManagement();
//management.ConferenceID = Convert.ToInt32(HttpContext.Current.Request.Form["ConferenceID"]);
management.UserId = new User {
UserID = 5,
};
management.Inviter = HttpContext.Current.Request.Form["Inviter"];
management.FormMeeting = HttpContext.Current.Request.Form["FormMeeting"];
management.NameMeeting = HttpContext.Current.Request.Form["NameMeeting"];
management.DepartID = new Department
{
DepartID = 5,
// DepartName=HttpContext.Current.Request.Form["DepartName"]
};
management.ConferenceBeginTime = HttpContext.Current.Request.Form["ConferenceBeginTime"];
management.ConferenceEndTime = HttpContext.Current.Request.Form["ConferenceEndTime"];
management.ConferenceRoomID = new ConferenceRoomManagement {
ConferenceRoomID = 1,
};
management.MeetingStatus = HttpContext.Current.Request.Form["MeetingStatus"];
management.MeetingDescribes = HttpContext.Current.Request.Form["MeetingDescribes"];
RoomManageBLL room = new RoomManageBLL();
var r = room.RoomExmin_Baoc(management);
JavaScriptSerializer js = new JavaScriptSerializer();
var obj = new { msg = "添加失败", code = 201 };
if (r)
{
obj = new { msg = "添加成功", code = 200 };
}
string str = js.Serialize(obj);
HttpContext.Current.Response.Write(str);
HttpContext.Current.Response.End();
}
/// <summary>
/// 获取所有的房间
/// </summary>
/// <param name="floorNum">楼层</param>
/// <param name="completeNum">完整编号</param>
/// <param name="typeTxt">类型</param>
/// <param name="stateTxt">状态</param>
/// <param name="page">第几页</param>
/// <param name="rows">一页多少条</param>
/// <returns></returns>
public JsonResult GetAllRoom(string floorNum, string completeNum, string typeTxt, string stateTxt, string page, string rows)
{
RoomManageBLL roomManageBLL = new RoomManageBLL();
return(Json(roomManageBLL.GetAllRoom(floorNum, completeNum, typeTxt, stateTxt, page, rows), JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 增加消耗
/// </summary>
/// <param name="Id">房间编号</param>
/// <param name="name">商品名称</param>
/// <param name="commodityNum">消耗数量</param>
/// <returns></returns>
public ActionResult IncreaseCommodityC(string Id, string namecombobox, string commodityNum)
{
RoomManageBLL roomManageBLL = new RoomManageBLL();
return(Json(roomManageBLL.IncreaseCommodityC(Id, namecombobox, commodityNum), JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 修改金额
/// </summary>
/// <param name="Id">房间编号</param>
/// <param name="UnitPrice">修改金额</param>
/// <returns></returns>
public JsonResult EditAmount(string Id, string UnitPrice)
{
RoomManageBLL roomManageBLL = new RoomManageBLL();
return(Json(roomManageBLL.EditAmount(Id, UnitPrice), JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 修改折扣
/// </summary>
/// <param name="Id">房间编号</param>
/// <param name="DiscountNum">折扣数</param>
/// <returns></returns>
public JsonResult EditDiscount(string Id, string DiscountNum)
{
RoomManageBLL roomManageBLL = new RoomManageBLL();
return(Json(roomManageBLL.EditDiscount(Id, DiscountNum), JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 修改房间状态
/// </summary>
/// <param name="id">房间编号</param>
/// <returns></returns>
public JsonResult ModifyState(string id)
{
RoomManageBLL roomManageBLL = new RoomManageBLL();
return(Json(roomManageBLL.ModifyState(Convert.ToInt32(id ?? "0"), Session["DdentityId"].ToString()), JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 获取所有历史折扣
/// </summary>
/// <param name="completeNum">房间编号</param>
/// <param name="page">第几页</param>
/// <param name="rows">一页多少行</param>
/// <returns></returns>
public JsonResult GetAllHistoryDiscount(string completeNum, string page, string rows)
{
RoomManageBLL roomManageBLL = new RoomManageBLL();
return(Json(roomManageBLL.GetAllHistoryDiscount(completeNum, page, rows), JsonRequestBehavior.AllowGet));
}