Exemple #1
0
        /// <summary>
        /// 确认提交
        /// </summary>
        private void Ensure()
        {
            try
            {
                ConferenceAuditorBLL Add       = new ConferenceAuditorBLL();
                BoardroomModel       boardroom = new BoardroomModel();

                boardroom.BdrStatus       = '1';
                boardroom.BdrName         = this.txtBdrName.Text;
                boardroom.BdrContactNum   = int.Parse(this.txtBdrContact.Text);
                boardroom.BdrLinkMan      = this.txtConMan.Text;
                boardroom.BdrContactPhone = this.txtConPhone.Text;
                boardroom.BdrIntro        = this.txtConIntro.Text;
                boardroom.BdrRemarks      = this.txtConRemarks.Text;

                Add.AddBoardroom(boardroom);

                this.DialogResult = DialogResult.OK;
                MessageBox.Show("提交成功", "提示信息", MessageBoxButtons.OK, MessageBoxIcon.Warning);
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }
Exemple #2
0
        /// <summary>
        /// 删除会议室信息
        /// </summary>
        private void Del()
        {
            if (MessageBox.Show("确定删除该条会议信息?,该操作不可恢复!", "提示信息", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.No)
            {
                return;
            }
            try
            {
                ConferenceAuditorBLL Del       = new ConferenceAuditorBLL();
                BoardroomModel       boardroom = new BoardroomModel();

                string bdrid = this.dgvBoardroom.CurrentRow.Cells["ColumnBdrId"].Value.ToString();//获取当前行要修改的会议ID
                boardroom.BdrId = int.Parse(bdrid);
                if (Del.DelBoardroom(boardroom))
                {
                    MessageBox.Show("提交成功", "提示信息", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                }
                else
                {
                    MessageBox.Show("该会议室存在会议,不可删除", "提示信息", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                }


                this.btnSearch_Click(null, null);
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }
Exemple #3
0
        }// 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
Exemple #4
0
        }// 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
Exemple #5
0
        }// 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
Exemple #6
0
        private void btnNext_Click(object sender, EventArgs e)
        {
            try
            {
                ConferenceApplyForm conapply = new ConferenceApplyForm();
                conapply.emp = emp;

                try
                {
                    conapply.bdrPlace = int.Parse(this.lblId.Text);
                    //MessageBox.Show(conapply.bdrPlace.ToString());
                }
                catch (Exception ex)
                {
                    throw new Exception("请正确选择会议室");
                }

                if ((DateTime)this.dtpStart.Value < (DateTime)this.dtpEnd.Value)
                {
                    DateTime ds = (DateTime)this.dtpStart.Value;
                    DateTime de = (DateTime)this.dtpEnd.Value;

                    // 判断该时间段内已选会议室是否有会议
                    UserBLL        userbll = new UserBLL();
                    BoardroomModel bdr     = new BoardroomModel();
                    bdr.BdrId = conapply.bdrPlace;
                    if (userbll.IsExistCon(bdr, ds, de))
                    {
                        throw new Exception("该时段会议室有会议,请重新选择");
                    }

                    conapply.constart = (DateTime)this.dtpStart.Value;
                    conapply.conend   = (DateTime)this.dtpEnd.Value;
                    this.Hide();
                    conapply.ShowDialog();
                }
                else
                {
                    throw new Exception("请正确选择时间");
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
                //MessageBox.Show("请正确选择会议室");
            }
        }
Exemple #7
0
        } // function AddRecord


        /// <summary>
        /// 向数据库会议室表中删除一条信息
        /// </summary>
        /// <param name="obj">要删除的会议室信息</param>
        /// <returns>操作成功返回true,失败返回false</returns>
        /// 作者:吴欣哲
        /// 创建时间:2014-09-16
        /// 修改时间:
       public bool DelARecord(object obj)
        {
            try
            {
                BoardroomModel boardroom = (BoardroomModel)obj;
                string strSqlCmd; // sql命令存放语句

                strSqlCmd = string.Format("delete from boardroom where bdrid = '{0}'", boardroom.BdrId);

                SqlHelperDB.ExecuteSql(SqlHelperDB.ConnectionString, strSqlCmd);
                return true;
            }
            catch
            {
                throw new Exception();
                //return false;  
            } // try
        } //function DelARecord
Exemple #8
0
       }//function GetAllRecord()


        /// <summary>
        /// 向数据库会议室表中修改一条信息
        /// </summary>
        /// <param name="obj">要x修改的会议室信息</param>
        /// <returns>操作成功返回true,失败返回false</returns>
        /// 作者:吴欣哲
        /// 创建时间:2014-09-16
        /// 修改时间:
       public bool UpdateARecord(object obj)
        {
            try
            {
                BoardroomModel boardroom = (BoardroomModel)obj;
                string strSqlCmd; // sql命令存放语句

                strSqlCmd = string.Format(@"update boardroom set bdrname='{1}',bdrcontactnum='{2}',bdrlinkman='{3}',
                    bdrcontactphone='{4}',bdrintro='{5}',bdrstatus='{6}',bdrremarks='{7}' where bdrid = '{0}'",
                        boardroom.BdrId, boardroom.BdrName, boardroom.BdrContactNum, boardroom.BdrLinkMan, boardroom.BdrContactPhone,
                        boardroom.BdrIntro, boardroom.BdrStatus, boardroom.BdrRemarks);
                SqlHelperDB.ExecuteSql(SqlHelperDB.ConnectionString, strSqlCmd);
                return true;
            }
            catch (Exception ex)
            {
                throw new Exception(ex.Message);
                
            } // try
        } //function UpdateARecord
Exemple #9
0
      /// <summary>
      /// 向数据库会议室表中插入一条新信息
      /// </summary>
      /// <param name="obj">一条新的会议室信息</param>
      /// <returns>操作成功返回true,失败返回false</returns>
      /// 作者:吴欣哲
      /// 创建时间:2014-09-16
      /// 修改时间:
       public bool AddARecord(object obj) 
        {
            try
            {
                BoardroomModel boardroom = (BoardroomModel)obj;
                string strSqlCmd; // sql命令存放语句

                strSqlCmd = string.Format("insert into Boardroom values('{0}','{1}','{2}','{3}','{4}','{5}','{6}')",
                    boardroom.BdrName, boardroom.BdrContactNum, boardroom.BdrLinkMan, boardroom.BdrContactPhone,
                    boardroom.BdrIntro, boardroom.BdrStatus, boardroom.BdrRemarks);

                SqlHelperDB.ExecuteSql(SqlHelperDB.ConnectionString, strSqlCmd);
                return true;
            }
            catch(Exception ex)
            {
                throw new Exception(ex.Message);
                //return false;  
            } // try
        } // function AddRecord
Exemple #10
0
        }// 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
Exemple #11
0
        /// <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
Exemple #12
0
        }// 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
Exemple #13
0
        /// <summary>
        /// 修改会议室信息
        /// </summary>
        private void Mod()
        {
            try
            {
                UpdateBoardroomForm Upd       = new UpdateBoardroomForm();
                BoardroomModel      boardroom = new BoardroomModel();

                string bdrid = this.dgvBoardroom.CurrentRow.Cells["ColumnBdrId"].Value.ToString(); //获取当前行要修改的学号
                boardroom.BdrId = int.Parse(bdrid);                                                //传值到另一个窗口
                Upd.bdrid       = boardroom;

                if (Upd.ShowDialog() == DialogResult.OK)
                {
                    this.btnSearch_Click(null, null);
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }
Exemple #14
0
        /// <summary>
        /// 确认提交
        /// </summary>
        private void Ensure()
        {
            try
            {
                ConferenceAuditorBLL Upd       = new ConferenceAuditorBLL();
                BoardroomModel       boardroom = new BoardroomModel();

                boardroom.BdrId = bdrid.BdrId;
                if (this.ComtxtBdrs.Text == "正常")
                {
                    boardroom.BdrStatus = '1';
                }
                else
                {
                    boardroom.BdrStatus = '0';
                }
                boardroom.BdrName         = this.txtBdrName.Text;
                boardroom.BdrContactNum   = int.Parse(this.txtBdrContact.Text);
                boardroom.BdrLinkMan      = this.txtConMan.Text;
                boardroom.BdrContactPhone = this.txtConPhone.Text;
                boardroom.BdrIntro        = this.txtConIntro.Text;
                boardroom.BdrRemarks      = this.txtConRemarks.Text;

                if (Upd.UpdateBoardroom(boardroom))
                {
                    MessageBox.Show("提交成功", "提示信息", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                }
                else
                {
                    MessageBox.Show("该会议室存在会议,不可修改", "提示信息", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                }

                this.DialogResult = DialogResult.OK;
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }
Exemple #15
0
       }//function IsConExist

        /// <summary>
        /// 通过会议ID查找会议室
        /// </summary>
        /// <param name="Conplace"></param>
        /// <returns></returns>
       /// 作者:王宇昊
       /// 创建时间:2014-09-19
       /// 修改时间:
       public BoardroomModel GetBdrFromCon(int Conplace)
       {
           try
           {
               List<BoardroomModel> BoardroomList = new List<BoardroomModel>();
               BoardroomList = GetAllRecord(Conplace.ToString());

               BoardroomModel Boardroom = new BoardroomModel();

               foreach (BoardroomModel Bdr in BoardroomList)
               {
                   if (Bdr.BdrId == Conplace)
                   {
                       Boardroom = Bdr;
                   }
               }
               return Boardroom;
           }
           catch (Exception ex)
           {
               throw new Exception(ex.Message);
           }
       }//function GetBdrFromCon
Exemple #16
0
        } //function DelARecord


       /// <summary>
       /// 获取表中所有记录
       /// </summary>
       /// <param name="sqlItems">要获取的记录</param>
       /// <returns>返回BoardroomList</returns>
       /// 作者:朱健
       /// 创建时间:2014-09-18
       /// 修改时间:2014-09-18
       public List<BoardroomModel> GetAllRecord(string sqlItems)
       {
           try
           {
                List<BoardroomModel> BoardroomList = new List<BoardroomModel>();
                string strSqlCmd = string.Format(@"select * from Boardroom where BdrId like '%{0}%' or BdrName like '%{0}%'
                                                                            or BdrContactNum like '%{0}%' or BdrLinkMan like '%{0}%'
                                                                            or BdrContactPhone like '%{0}%' or BdrIntro like '%{0}%'
                                                                            or BdrStatus like '%{0}%' or BdrRemarks like '%{0}%'
                                                                            ", sqlItems);
                DataSet data = SqlHelperDB.GetDataSet(DB.SqlHelperDB.ConnectionString, strSqlCmd , "Boardroom");

                foreach (DataRow row in data.Tables["Boardroom"].Rows)
                {
                    BoardroomModel boardroom =  new BoardroomModel();

                    boardroom.BdrId             = Convert.ToInt32(row["BdrId"].ToString());
                    boardroom.BdrName           = row["BdrName"].ToString();
                    boardroom.BdrContactNum     = int.Parse(row["BdrContactNum"].ToString());
                    boardroom.BdrLinkMan        = row["BdrLinkMan"].ToString();
                    boardroom.BdrContactPhone   = row["BdrContactPhone"].ToString();
                    boardroom.BdrIntro          = row["BdrIntro"].ToString();
                    boardroom.BdrStatus          = char.Parse(row["BdrStatus"].ToString());
                    boardroom.BdrRemarks        = row["BdrRemarks"].ToString();

                    BoardroomList.Add(boardroom); 
                }

                return BoardroomList;
            }
           catch
           {
               throw new Exception();
           }

       }//function GetAllRecord()
Exemple #17
0
        private void FormMain_Load(object sender, EventArgs e)
        {
            #region 界面
            // 在界面显示用户信息
            UserBLL       userInfo = new UserBLL();
            EmployeeModel emInfo   = userInfo.GetEmInfo(this.employee.EmId);
            string        strHello = "欢迎," + emInfo.EmName[0] + (emInfo.EmSex == "男" ? "先生" : "小姐");
            this.lbHello.Text = strHello;

            // 根据登陆用户的权限显示相应的空间
            if (employee.EmPermission == "OU")//普通用户
            {
                this.tsmiCheckTask.Visible     = false;
                this.tsmiApply.Visible         = true;
                this.tsmiManage.Visible        = false;
                this.tsmiVer.Visible           = false;
                this.tsmiUpdateMateria.Visible = true;
                //this.c1scNextCon.Visible = true;

                UserBLL sort = new UserBLL();
                list = sort.GetUserConference(employee);
                //  ConferenceModel con = new ConferenceModel();

                try
                {
                    ConferenceModel con = GetConSort(list);
                    string          bdr = sort.GetBoardroomInfo(con.ConPlace.ToString())[0].BdrName;
                    if (con.ConStatus == '1')
                    {
                        this.lbNextCon.Text =
                            String.Format("会议名称:{0};\n会议地点:{1};\n会议开始时间:{2};\n会议结束时间:{3};\n",
                                          con.ConName, bdr, con.ConStartTime.ToShortTimeString(),
                                          con.ConEndTime.ToShortTimeString());
                    }
                    else
                    {
                        this.lbNextCon.Text = "接下来并没有会议!";
                    }
                }
                catch (Exception ex)
                {
                    //MessageBox.Show(ex.Message);
                    this.lbNextCon.Text = ex.Message;
                }
            }
            else if (employee.EmPermission == "TA")//议题审核人
            {
                this.tsmiCheckTask.Visible     = false;
                this.tsmiApply.Visible         = true;
                this.tsmiManage.Visible        = true;
                this.tsmiConManage.Visible     = false;
                this.tsmiTopicManage.Visible   = true;
                this.tsmiBdrRoomManage.Visible = false;
                this.tsmiResouceManage.Visible = false;
                this.tsmiVer.Visible           = false;
                this.tsmiConVer.Visible        = false;
                this.tsmiUpdateMateria.Visible = true;
                //this.c1scNextCon.Visible = true;
                UserBLL sort = new UserBLL();
                list = sort.GetUserConference(employee);
                try
                {
                    ConferenceModel con = GetConSort(list);
                    string          bdr = sort.GetBoardroomInfo(con.ConPlace.ToString())[0].BdrName;
                    if (con.ConStatus == '1')
                    {
                        this.lbNextCon.Text =
                            String.Format("会议名称:{0};\n会议地点:{1};\n会议开始时间:{2};\n会议结束时间:{3};\n",
                                          con.ConName, bdr, con.ConStartTime.ToShortTimeString(),
                                          con.ConEndTime.ToShortTimeString());
                    }
                    else
                    {
                        this.lbNextCon.Text = "接下来并没有会议!";
                    }
                }
                catch (Exception ex)
                {
                    //MessageBox.Show(ex.Message);
                    this.lbNextCon.Text = ex.Message;
                }
            }
            else if (employee.EmPermission == "CA")//会议管理员
            {
                this.lbHello.Text = "欢迎,管理员";

                this.tsmiTopicManage.Visible   = false;
                this.tsmiCheckTask.Visible     = false;
                this.tsmiManage.Visible        = true;
                this.tsmiConManage.Visible     = true;
                this.tsmiBdrRoomManage.Visible = true;
                this.tsmiResouceManage.Visible = false;
                this.tsmiApply.Visible         = true;
                this.tsmiVer.Visible           = true;
                this.tsmiConVer.Visible        = true;
                this.tsmiUpdateMateria.Visible = true;
                //this.c1scNextCon.Visible = true;
                UserBLL sort = new UserBLL();
                list = sort.GetUserConference(employee);
                try
                {
                    ConferenceModel con = GetConSort(list);
                    string          bdr = sort.GetBoardroomInfo(con.ConPlace.ToString())[0].BdrName;
                    if (con.ConStatus == '1')
                    {
                        this.lbNextCon.Text =
                            String.Format("会议名称:{0};\n会议地点:{1};\n会议开始时间:{2};\n会议结束时间:{3};\n",
                                          con.ConName, bdr, con.ConStartTime.ToShortTimeString(),
                                          con.ConEndTime.ToShortTimeString());
                    }
                    else
                    {
                        this.lbNextCon.Text = "接下来并没有会议!";
                    }
                }
                catch (Exception ex)
                {
                    //MessageBox.Show(ex.Message);
                    this.lbNextCon.Text = ex.Message;
                }
            }
            else if (employee.EmPermission == "CE")//会务执行人
            {
                //this.tsmiManage.Visible = true;
                this.tsmiManage.Visible        = true;
                this.tsmiResouceManage.Visible = true;
                this.tsmiTopicManage.Visible   = false;
                this.tsmiConManage.Visible     = false;
                this.tsmiBdrRoomManage.Visible = false;
                this.tsmiCheckTask.Visible     = true;

                this.tsmiApply.Visible         = true;
                this.tsmiVer.Visible           = false;
                this.tsmiUpdateMateria.Visible = true;
                this.label1.Visible            = false;
                //this.c1scNextCon.Visible = true;
            }
            #endregion

            List <ConferenceModel> ConferenceList = new List <ConferenceModel>();
            UserBLL user = new UserBLL();
            ConferenceList = user.GetConferenceInfo("");
            try
            {
                int n = 0;
                foreach (ConferenceModel con in ConferenceList)
                {
                    if (con.ConStatus == '1')
                    {
                        C1.C1Schedule.Appointment app = new C1.C1Schedule.Appointment();
                        app.Subject = con.ConName;
                        string bdrname = user.GetBoardroomInfo(con.ConPlace.ToString())[0].BdrName;
                        app.Location = bdrname;
                        app.Start    = con.ConStartTime;
                        app.End      = con.ConEndTime;
                        this.c1sView.DataStorage.AppointmentStorage.Appointments.Add(app);
                        BoardroomModel bdr = new BoardroomModel();
                        bdr.BdrId   = con.ConPlace;
                        bdr.BdrName = bdrname;
                        try
                        {
                            this.c1sView.DataStorage.OwnerStorage.Mappings.TextMapping.MappingName  = "BdrName";
                            this.c1sView.DataStorage.OwnerStorage.Mappings.IndexMapping.MappingName = "BdrId";
                            bool iscontains = false;
                            foreach (object m in this.c1sView.DataStorage.OwnerStorage.Contacts)
                            {
                                if (m.ToString() == bdr.BdrName)
                                {
                                    iscontains = true;
                                }
                            }
                            if (iscontains == false)
                            {
                                this.c1sView.DataStorage.OwnerStorage.Add(bdr);
                                app.Owner = this.c1sView.DataStorage.OwnerStorage.Contacts[n];
                                n++;
                            }
                        }
                        catch (Exception ex)
                        {
                            MessageBox.Show(ex.Message);
                        }
                    }
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }