/// <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); } }
/// <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); } }
}// 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 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
}// 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
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("请正确选择会议室"); } }
} // 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
}//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
/// <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
}// 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
/// <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 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
/// <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); } }
/// <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); } }
}//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
} //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()
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); } }