} // function GetCanUseResource /// <summary> /// 向数据库会议资源表中查询与某一会议相关资源的信息 /// </summary> /// <param name="conId">会议id</param> /// <returns>一组资源信息</returns> /// 作者:王宇昊 /// 创建时间:2014-09-22 /// 修改时间: public List <ResourceModel> GetConUseResourceInfo(int conId) { try { ConUseResourceDAL CUR = new ConUseResourceDAL(); ResourceDAL R = new ResourceDAL(); List <ConUseResourceModel> UseResourceList = new List <ConUseResourceModel>(); List <ResourceModel> ResourceList = new List <ResourceModel>(); List <ResourceModel> ResourceReList = new List <ResourceModel>();//要返回的列表 UseResourceList = CUR.GetUseResource(conId); foreach (ConUseResourceModel conuse in UseResourceList) { ResourceList = R.GetAllRecord(); foreach (ResourceModel RM in ResourceList) { if (conuse.DeviceId == RM.ResourceId) { ResourceReList.Add(RM); } } } return(ResourceReList); } catch (Exception ex) { throw new Exception(ex.Message); } // try } // function GetConUseResource
}// 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