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