//根据id 查询会议室信息:Rooms_Content public ConferenceManagement RoomsContent_getCha(int id) { string sql = string.Format("select ConferenceID,User_Name,User_Name,User_Name,Form_Meeting ,DepartName ,Inviter ,Conference_BeginTime,Conference_EndTime,Name_Meeting,Conference_Room_Name, case when Meeting_Status=0 then '空' else '满' end Meeting_Status from MS_Conference_management a,MS_Conference_Room_Management b,MS_User c,MS_Department d where a.User_Id=c.User_Id and a.Conference_RoomID=b.Conference_RoomID and a.DepartID=d.DepartID and ConferenceID={0}", id); var table = DBHelper.Select(sql); ConferenceManagement user = new ConferenceManagement(); user.ConferenceID = Convert.ToInt32(table.Rows[0]["ConferenceID"]); //ID user.ConferenceBeginTime = table.Rows[0]["Conference_BeginTime"].ToString(); //开始时间 user.ConferenceEndTime = table.Rows[0]["Conference_EndTime"].ToString(); //结束时间 user.FormMeeting = table.Rows[0]["Form_Meeting"].ToString(); //会议形式 user.Inviter = table.Rows[0]["Inviter"].ToString(); //邀请人员 user.NameMeeting = table.Rows[0]["Name_Meeting"].ToString(); //会议名称 user.MeetingStatus = table.Rows[0]["Meeting_Status"].ToString(); //状态 // user.MeetingDescribes = table.Rows[0]["Meeting_Describes"].ToString();//描述 user.UserId = new User { // UserID = Convert.ToInt32(table.Rows[0]["UserID"]),//ID Name = table.Rows[0]["User_Name"].ToString(),//姓名 }; user.DepartID = new Department { // DepartID = Convert.ToInt32(table.Rows[0]["DepartID"]),//ID DepartName = table.Rows[0]["DepartName"].ToString(),//部门 }; user.ConferenceRoomID = new ConferenceRoomManagement { // ConferenceRoomID = Convert.ToInt32(table.Rows[0]["ConferenceRoomID"]),//ID ConferenceRoomName = table.Rows[0]["Conference_Room_Name"].ToString(),//会议室名称 }; return(user); }
/// <summary> /// 会议室管理资源图按条件查询 /// </summary> /// <returns></returns> public List <ConferenceManagement> Select_infroationName(string name) { string sql = string.Format("SELECT dbo.MS_Conference_Room_Management.Conference_Room_Name, " + " dbo.MS_Conference_Room_Management.Conference_Room_Place, dbo.MS_User.User_Name FROM " + " dbo.MS_Conference_Room_Management INNER JOIN dbo.MS_Conference_management ON " + "dbo.MS_Conference_Room_Management.Conference_RoomID = dbo.MS_Conference_management.Conference_RoomID INNER JOIN dbo.MS_User ON " + "dbo.MS_Conference_management.User_Id = dbo.MS_User.User_Id WHERE(dbo.MS_User.User_Name LIKE '%{0}%')", name); var table = DBHelper.Select(sql); List <ConferenceManagement> list = new List <ConferenceManagement>(); foreach (DataRow item in table.Rows) { ConferenceManagement room = new ConferenceManagement { //ConferenceRoomID = Convert.ToInt32(item["Conference_RoomID"]), UserId = new User { Name = item["User_Name"].ToString() }, ConferenceRoomID = new ConferenceRoomManagement { ConferenceRoomName = item["Conference_Room_Name"].ToString(), ConferenceRoomPlace = item["Conference_Room_Place"].ToString() }, }; list.Add(room); } return(list); }
public void ManageConferenceNoTalksTest() { var talks = new Queue <Talk>(); var conference = ConferenceManagement.ManageConference(talks); foreach (var track in conference.Tracks) { Assert.IsTrue(track.MorningSession.Talks.Count == 0); Assert.IsTrue(track.AfterNoonSession.Talks.Count == 0); } }
public ConferenceReply RoomAdd(ConferenceRoom roomAdded) { ConferenceReply conferenceReply = new ConferenceReply(); ConferenceManagement.getInstance().Add(roomAdded); conferenceReply.Name = roomAdded.Name; conferenceReply.IsPrivate = roomAdded.IsPrivate; conferenceReply.Creator = roomAdded.Creator; conferenceReply.AddStatus = "Successful"; return(conferenceReply); }
/// <summary> /// 会议室创建修改按钮 /// </summary> /// <returns></returns> public bool ROOMS_Update(ConferenceManagement room) { RoomManageDAL b = new RoomManageDAL(); var a = b.ROOM_Update(room); if (a > 0) { return(true); } else { return(false); } }
public void ManageConferenceOneBigTalkTest() { var talks = new Queue <Talk>(); talks.Enqueue(new Talk() { Duration = 300, Name = "User Interface CSS in Rails Apps 300min" }); var conference = ConferenceManagement.ManageConference(talks); foreach (var track in conference.Tracks) { Assert.IsTrue(track.MorningSession.Talks.Count == 0); Assert.IsTrue(track.AfterNoonSession.Talks.Count == 0); } }
/// <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 List <ConferenceManagement> Room_getChaName(string Name_Meeting, string Conference_Room_Name) { string sql = string.Format("select ConferenceID ,User_Name ,Form_Meeting ,DepartName ,Inviter ,Conference_BeginTime, Conference_EndTime, Name_Meeting, Conference_Room_Name,case when Meeting_Status = 0 then '空' else '满' end Meeting_Status FROM dbo.MS_Conference_management a JOIN dbo.MS_Conference_Room_Management b ON a.Conference_RoomID = b.Conference_RoomID INNER JOIN dbo.MS_User c ON a.User_Id = c.User_Id INNER JOIN dbo.MS_Department ON a.DepartID = dbo.MS_Department.DepartID AND c.Departmentid = dbo.MS_Department.DepartID where Name_Meeting like '%{0}%' and Conference_Room_Name like '%{1}%'", Name_Meeting, Conference_Room_Name); var table = DBHelper.Select(sql); List <ConferenceManagement> list = new List <ConferenceManagement>(); foreach (DataRow item in table.Rows) { ConferenceManagement management = new ConferenceManagement(); management.ConferenceID = Convert.ToInt32(item["ConferenceID"]); management.UserId = new User { // UserID = Convert.ToInt32(item["User_Id"]), Name = item["User_Name"].ToString(), }; management.Inviter = item["Inviter"].ToString(); management.FormMeeting = item["Form_Meeting"].ToString(); management.NameMeeting = item["Name_Meeting"].ToString(); management.DepartID = new Department { // DepartID = Convert.ToInt32(item["DepartID"]), DepartName = item["DepartName"].ToString(), }; management.ConferenceBeginTime = item["Conference_BeginTime"].ToString(); management.ConferenceEndTime = item["Conference_EndTime"].ToString(); management.ConferenceRoomID = new ConferenceRoomManagement { // ConferenceRoomID = Convert.ToInt32(item["Conference_RoomID"]), ConferenceRoomName = item["Conference_Room_Name"].ToString(), }; management.MeetingStatus = item["Meeting_Status"].ToString(); //management.MeetingDescribes = item["Conference_Room_Describes"].ToString(); list.Add(management); } ; return(list); }
/// <summary> /// 动态加载会议室数据 /// </summary> /// <returns></returns> public List <ConferenceManagement> Room_getCha() { string sql = string.Format("select ConferenceID ,User_Name ,Form_Meeting ,DepartName ,Inviter ,Conference_BeginTime,Conference_EndTime, Name_Meeting,Conference_Room_Name, case when Meeting_Status=0 then '空' else '满' end Meeting_Status from MS_Conference_management a,MS_Conference_Room_Management b,MS_User c,MS_Department d where a.User_Id=c.User_Id and a.Conference_RoomID=b.Conference_RoomID and a.DepartID=d.DepartID"); var table = DBHelper.Select(sql); List <ConferenceManagement> list = new List <ConferenceManagement>(); foreach (DataRow item in table.Rows) { ConferenceManagement management = new ConferenceManagement(); management.ConferenceID = Convert.ToInt32(item["ConferenceID"]); management.UserId = new User { // UserID = Convert.ToInt32(item["User_Id"]), Name = item["User_Name"].ToString(), }; management.Inviter = item["Inviter"].ToString(); management.FormMeeting = item["Form_Meeting"].ToString(); management.NameMeeting = item["Name_Meeting"].ToString(); management.DepartID = new Department { // DepartID = Convert.ToInt32(item["DepartID"]), DepartName = item["DepartName"].ToString(), }; management.ConferenceBeginTime = item["Conference_BeginTime"].ToString(); management.ConferenceEndTime = item["Conference_EndTime"].ToString(); management.ConferenceRoomID = new ConferenceRoomManagement { // ConferenceRoomID = Convert.ToInt32(item["Conference_RoomID"]), ConferenceRoomName = item["Conference_Room_Name"].ToString(), }; management.MeetingStatus = item["Meeting_Status"].ToString(); //management.MeetingDescribes = item["Conference_Room_Describes"].ToString(); list.Add(management); } ; return(list); }
/// <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(); }
public List <ConferenceRoom> GetAllStudents() { return(ConferenceManagement.getInstance().getAllRooms()); }
/// <summary> /// 会议室申请保存按钮 /// </summary> /// <returns></returns> public bool RoomApplay_baoc(ConferenceManagement management) { string sql = string.Format("INSERT INTO [dbo].[MS_Conference_management] ([User_Id],[Inviter],[Form_Meeting],[Name_Meeting] ,[DepartID] ,[Conference_BeginTime] ,[Conference_EndTime] ,[Conference_RoomID],[Meeting_Status],Meeting_Describes) VALUES ({0},'{1}','{2}','{3}' ,'{4}' ,'{5}','{6}','{7}','{8}','{9}')", management.UserId.UserID, management.Inviter, management.FormMeeting, management.NameMeeting, management.DepartID.DepartID, management.ConferenceBeginTime, management.ConferenceEndTime, management.ConferenceRoomID.ConferenceRoomID, management.MeetingStatus, management.MeetingDescribes); return(DBHelper.NonQuery(sql) > 0); }
public void ManageConferenceTest() { var talks = new Queue <Talk>(); talks.Enqueue(new Talk() { Duration = 60, Name = "Writing Fast Tests Against Enterprise Rails 60min" }); talks.Enqueue(new Talk() { Duration = 45, Name = "Overdoing it in Python 45min" }); talks.Enqueue(new Talk() { Duration = 30, Name = "Lua for the Masses 30min" }); talks.Enqueue(new Talk() { Duration = 45, Name = "Ruby Errors from Mismatched Gem Versions 45min" }); talks.Enqueue(new Talk() { Duration = 45, Name = "Common Ruby Errors 45min" }); talks.Enqueue(new Talk() { Duration = 5, Name = "Rails for Python Developers lightning" }); talks.Enqueue(new Talk() { Duration = 60, Name = "Communicating Over Distance 60min" }); talks.Enqueue(new Talk() { Duration = 45, Name = "Accounting-Driven Development 45min" }); talks.Enqueue(new Talk() { Duration = 30, Name = "Woah 30min" }); talks.Enqueue(new Talk() { Duration = 30, Name = "Sit Down and Write 30min" }); talks.Enqueue(new Talk() { Duration = 45, Name = "Pair Programming vs Noise 45min" }); talks.Enqueue(new Talk() { Duration = 60, Name = "Rails Magic 60min" }); talks.Enqueue(new Talk() { Duration = 60, Name = "Ruby on Rails: Why We Should Move On 60min" }); talks.Enqueue(new Talk() { Duration = 45, Name = "Clojure Ate Scala (on my project) 45min" }); talks.Enqueue(new Talk() { Duration = 30, Name = "Programming in the Boondocks of Seattle 30min" }); talks.Enqueue(new Talk() { Duration = 30, Name = "Ruby vs. Clojure for Back-End Development 30min" }); talks.Enqueue(new Talk() { Duration = 60, Name = "Ruby on Rails Legacy App Maintenance 60min" }); talks.Enqueue(new Talk() { Duration = 30, Name = "A World Without HackerNews 30min" }); talks.Enqueue(new Talk() { Duration = 30, Name = "User Interface CSS in Rails Apps 30min" }); ConferenceManagement.ManageConference(talks); }
/// <summary> /// 会议室修改页面 /// </summary> /// <param name="id"></param> /// <returns></returns> public int ROOM_Update(ConferenceManagement room) { string sql = string.Format("UPDATE [dbo].[MS_Conference_management] SET [User_Id] = '{0}' ,[Inviter] = '{1}' ,[Form_Meeting] ='{2}' ,[Name_Meeting] ='{3}' ,[DepartID] = '{4}',[Conference_BeginTime] = '{5}',[Conference_EndTime] ='{6}',[Conference_RoomID] ='{7}' ,[Meeting_Status] = '{8}' WHERE ConferenceID='{9}'", room.UserId, room.Inviter, room.FormMeeting, room.NameMeeting, room.DepartID, room.ConferenceBeginTime, room.ConferenceEndTime, room.ConferenceRoomID, room.MeetingStatus, room.ConferenceID); return(DBHelper.NonQuery(sql)); }
public IActionResult DeleteStudentRecord(String roomName) { return(Ok(ConferenceManagement.getInstance().RemoveRoom(roomName))); }
public JsonResult UpdateStudentRecord(ConferenceRoom stdn) { return(Json(ConferenceManagement.getInstance().EditRoom(stdn))); }
/// <summary> /// 会议室申请保存按钮 /// </summary> /// <returns></returns> public bool RoomApplay_baoc(ConferenceManagement management) { return(room.RoomApplay_baoc(management)); }
/// <summary> /// 会议室审核保存按钮 /// </summary> /// <returns></returns> public bool RoomExmin_Baoc(ConferenceManagement management) { return(room.RoomExmin_baoc(management)); }