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