} // function LoginIn
/// <summary>
/// 查询所有会议
/// </summary>
/// <param name="sqlItems">查询的内容</param>
/// <returns>一组会议信息</returns>
/// 作者:王宇昊
/// 创建时间:2014-09-18
/// 修改时间:
public List <ConferenceModel> GetConferenceInfo(string sqlItems)
{
List <ConferenceModel> ConM = new List <ConferenceModel>();
ConferenceDAL ConDAL = new ConferenceDAL();
ConM = ConDAL.GetAllRecord(sqlItems);
return(ConM);
}// function GetConferenceInfo
}// 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
}// function DelCon
/// <summary>
/// 对已提交申请但未审核的会议进行更改
/// </summary>
/// <param name="conference">会议表实体类</param>
/// <returns>true：申请提交成功；false：申请提交失败</returns>
/// 作者:王宇昊
/// 创建时间:2014-09-18
/// 修改时间:
public bool UpdateCon(ConferenceModel conference)
{
try
{
ConferenceDAL ConDAL = new ConferenceDAL();
if (conference.ConStatus == '0')
{
ConDAL.UpdateARecord(conference);
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}// function UpdateCon
/// <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 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