} // 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 DelARecord
/// <summary>
/// 会议管理员向会议使用资源表添加一条记录
/// </summary>
/// <param name="useRsc">使用资源实体类的实例化对象</param>
/// <returns>true：添加成功；false：添加失败</returns>
public bool AddConUseResource(ConUseResourceModel useRsc)
{
try
{
ConUseResourceDAL CURD = new ConUseResourceDAL();
CURD.AddARecord(useRsc);
return(true);
}
catch
{
return(false);
}
} // function AddConUseResource
}// 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 GetBoardroomInfo
/// <summary>
/// 申请会议
/// </summary>
/// <param name="conferenceInfo">会议信息</param>
/// <param name="resource">资源设备编号信息</param>
/// <returns>是否成功申请</returns>
/// 作者:王宇昊
/// 创建时间:2014-09-18
/// 修改时间:
///
///
public int ConApply(ConferenceModel conferenceInfo, List <string> resource)
{
try
{
ConferenceDAL ConDAL = new ConferenceDAL();
ConUseResourceDAL CURDAL = new ConUseResourceDAL();
ConUseResourceModel CURM = new ConUseResourceModel();
//
ResourceDAL RDAL = new ResourceDAL();
ResourceModel RMODEL = new ResourceModel();
int CId = ConDAL.AddARecordReturnId(conferenceInfo);//返回会议的ID
if (CId != -1)
{
foreach (string DeviceId in resource)
{
CURM.ConId = CId;
CURM.DeviceId = Convert.ToInt32(DeviceId);
CURDAL.AddARecord(CURM);
// 将资源表中的状态标志改为1，被预订
RMODEL.ResourceId = Convert.ToInt32(DeviceId);
RMODEL.ResourceStatus = '1';
RDAL.UpdateAStatus(RMODEL);
}
return(CId);
}
else
{
return(-1);
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}// function ConApply
