}// function GetConferenceInfo
/// <summary>
/// 查看会议室
/// </summary>
/// <param name="sqlItems">查询会议信息</param>
/// <returns>一组会议室信息</returns>
/// 作者:王宇昊
/// 创建时间:2014-09-18
/// 修改时间:
public List <BoardroomModel> GetBoardroomInfo(string sqlItems)
{
List <BoardroomModel> LBM = new List <BoardroomModel>();
BoardroomDAL LBMDAL = new BoardroomDAL();
LBM = LBMDAL.GetAllRecord(sqlItems);
return(LBM);
}// function GetBoardroomInfo
}// function GetInConMemberRegisterInfo
/// <summary>
/// 获取任务单
/// </summary>
/// <param name="employee"></param>
/// <returns></returns>
/// 作者:王宇昊
/// 创建时间:2014-09-19
/// 修改时间:
public List <TaskModel> GetTask(EmployeeModel employee)
{
ConferenceDAL conDal = new ConferenceDAL();
List <ConferenceModel> conModel = new List <ConferenceModel>();
List <TaskModel> taskList = new List <TaskModel>();
conModel = conDal.GetAllRecord(employee.EmId.ToString());
foreach (ConferenceModel con in conModel)
{
if (con.ConStaffMen == employee.EmId)
{
TaskModel task = new TaskModel();
task.TaskConference = con; // 获取会议信息
//task.TaskConName = con.ConName; //获取会议名称
//task.TaskConTime = con.ConStartTime;//获取会议时间
BoardroomDAL BdrDAL = new BoardroomDAL();
List <BoardroomModel> BoardroomList = new List <BoardroomModel>();
BoardroomList = BdrDAL.GetAllRecord(con.ConPlace.ToString());
BoardroomModel Boardroom = new BoardroomModel();
foreach (BoardroomModel Bdr in BoardroomList)
{
if (Bdr.BdrId == con.ConPlace)
{
Boardroom = Bdr;
}
}
task.TaskBdrName = Boardroom.BdrName;//获取会议室名称
BoardroomDAL boardroomDal = new BoardroomDAL();
BoardroomModel boardroomModel = new BoardroomModel();
ConUseResourceDAL conUseRscDal = new ConUseResourceDAL();
List <ConUseResourceModel> conUseRscList = new List <ConUseResourceModel> ();
task.TaskResource = new ArrayList();
conUseRscList = conUseRscDal.GetUseResource(con.ConId);
if (conUseRscList.Count != 0)
{
foreach (ConUseResourceModel conUseRsc in conUseRscList)
{
task.TaskResource.Add(conUseRsc.DeviceId);//获取资源ID列表
} // end foreach
}
taskList.Add(task);
} // end if
} // end foreach
return(taskList);
}// function GetTask
}// function VerifyConference
/// <summary>
/// 会议管理员添加会议室
/// </summary>
/// <param name="boardroom">会议室实体类的实例化对象</param>
/// <returns>true：添加成功；false：添加失败</returns>
/// 作者:王宇昊
/// 创建时间:2014-09-18
/// 修改时间:
public bool AddBoardroom(BoardroomModel boardroom)
{
try
{
BoardroomDAL BdrDAL = new BoardroomDAL();
BdrDAL.AddARecord(boardroom);
return(true);
}
catch
{
return(false);
}
}// function AddBoardroom
}// function UpdateConference
/// <summary>
/// 会议管理员对会议申请进行审核
/// </summary>
/// <param name="conference">会议实体类的实例化对象</param>
/// <returns>true：审核成功；false：审核失败</returns>
/// 作者:王宇昊
/// 创建时间:2014-09-18
/// 修改时间:
public bool VerifyConference(ConferenceModel conference)
{
try
{
ConferenceDAL ConDAL = new ConferenceDAL();
if (conference.ConStatus == '1')
{
ConDAL.UpdateARecord(conference);
SendTask(conference.ConSubMen, conference.ConName + "会议审核成功", "已通知各参会人员");//发送回执单信息给申请人员
BoardroomDAL BdrDAL = new BoardroomDAL();
List <BoardroomModel> BoardroomList = new List <BoardroomModel>();
BoardroomList = BdrDAL.GetAllRecord(conference.ConPlace.ToString());
BoardroomModel Boardroom = new BoardroomModel();
foreach (BoardroomModel Bdr in BoardroomList)
{
if (Bdr.BdrId == conference.ConPlace)
{
Boardroom = Bdr;
}
}
string Topic = string.Format("{0}会议通知", conference.ConName);
string Body = string.Format("会议名称：{0}<br />会议地点：{1}<br />主办单位：{2}<br />会议时间：{3}", conference.ConName, Boardroom.BdrName, conference.ConHost, conference.ConStartTime);
SendNotice(conference, Topic, Body);//查找与会人员通过邮件发布会议修改的信息
List <ConUseResourceModel> ConUse = new List <ConUseResourceModel>();
ConUseResourceDAL CURDAL = new ConUseResourceDAL();
Body = Body + "<br />会议资源：";
ConUse = CURDAL.GetUseResource(conference.ConId);
foreach (ConUseResourceModel CU in ConUse)
{
Body = Body + CU.DeviceId.ToString() + ",";
}
SendTask(conference.ConStaffMen, Topic, Body);//发送新任务单信息给会务人员
}
else
{
ConDAL.UpdateARecord(conference);
}
return(true);
}
catch
{
return(false);
}
}// function VerifyConference
}// function TopicApply
/// <summary>
/// 判断选择时间内是否有会议
/// </summary>
/// <param name="boardroom">会议室实体类</param>
/// <param name="start">开始时间</param>
/// <param name="end">结束时间</param>
/// <returns>有会议返回true，无会议返回false</returns>
public bool IsExistCon(BoardroomModel boardroom, DateTime start, DateTime end)
{
try
{
//判断会议结束时间>当前时间并且会议室ID=boardroom.BrdId 是否存在
BoardroomDAL BdrDAL = new BoardroomDAL();
if (BdrDAL.IsConExist(boardroom.BdrId, start, end))
{
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}//function IsExistCon
/// <summary>
/// 会议管理员删除会议
/// </summary>
/// <param name="conference">会议表实体类</param>
/// <returns>true：申请提交成功；false：申请提交失败</returns>
/// 作者:王宇昊
/// 创建时间:2014-09-18
/// 修改时间:
public bool DelConference(ConferenceModel conference)
{
try
{
ConferenceDAL ConDAL = new ConferenceDAL();
if (conference.ConStatus == '0')
{
ConDAL.DelARecord(conference);
}
else
{
ConDAL.DelARecord(conference);
BoardroomDAL BdrDAL = new BoardroomDAL();
List <BoardroomModel> BoardroomList = new List <BoardroomModel>();
BoardroomList = BdrDAL.GetAllRecord(conference.ConPlace.ToString());
BoardroomModel Boardroom = new BoardroomModel();
foreach (BoardroomModel Bdr in BoardroomList)
{
if (Bdr.BdrId == conference.ConPlace)
{
Boardroom = Bdr;
}
}
ConDAL.UpdateARecord(conference);
string Topic = string.Format("{0}会议取消通知", conference.ConName);
string Body = string.Format("会议名称：{0}<br />会议地点：{1}<br />主办单位：{2}<br />会议时间：{3}<br />会议由于特殊原因取消，请诸位告知", conference.ConName, Boardroom.BdrName, conference.ConHost, conference.ConStartTime);
SendTask(conference.ConSubMen, Topic, Body); //向会议申请人发送会议取消的消息
SendNotice(conference, Topic, Body); //查找与会人员通过邮件发布会议取消的信息
SendTask(conference.ConStaffMen, Topic, Body); //发送新任务单信息给会务人员
}
return(true);
}
catch
{
return(false);
}
}// function DelConference
}// function DelBoardroom
/// <summary>
/// 会议管理员修改会议室
/// </summary>
/// <param name="boardroom">会议实体类的实例化对象</param>
/// <returns>true：修改成功；false：修改失败</returns>
/// 作者:王宇昊
/// 创建时间:2014-09-18
/// 修改时间:
public bool UpdateBoardroom(BoardroomModel boardroom)
{
try
{
//判断会议结束时间>当前时间并且会议室ID=boardroom.BrdId 是否存在
BoardroomDAL BdrDAL = new BoardroomDAL();
if (BdrDAL.IsConExist(boardroom.BdrId))
{
BdrDAL.UpdateARecord(boardroom);
return(true);
}
else
{
return(false);
}
}
catch
{
return(false);
}
}// function UpdateBoardroom
