/// <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); } }
/// <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> /// <param name="sender"></param> /// <param name="e"></param> /// 作者:王宇昊 /// 创建时间:2014-09-24 /// 修改时间:2014-09-24 private void btnEnsure_Click(object sender, EventArgs e) { try { if (dgvTask.RowCount != 0) { ConferenceAuditorBLL Save = new ConferenceAuditorBLL(); ExecutorBLL Get = new ExecutorBLL(); List <ConferenceModel> Conference = new List <ConferenceModel>(); Conference = Get.GetConferenceInfo(""); foreach (ConferenceModel con in Conference) { if (con.ConId.ToString() == this.dgvTask.CurrentRow.Cells["ColumnConferenceId"].Value.ToString()) { con.ConIsDone = '1'; Save.UpdateConference(con); MessageBox.Show("确认成功", "提示信息", MessageBoxButtons.OK, MessageBoxIcon.Warning); } } GetTask(); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
/// <summary> /// 增加资源 /// </summary> private void Add() { try { if (cmbAddResClass.Text == "") { if (MessageBox.Show("值不能为空", "提示信息", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.No) { return; } } else { if (MessageBox.Show("确定添加?", "提示信息", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.No) { return; } ConferenceAuditorBLL Add = new ConferenceAuditorBLL(); ResourceModel resource = new ResourceModel(); resource.ResourceClass = cmbAddResClass.Text; resource.ResourceStatus = '0'; Add.AddResouce(resource); MessageBox.Show("提交成功", "提示信息", MessageBoxButtons.OK, MessageBoxIcon.Warning); this.ResourceManageForm_Load(null, null); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
/// <summary> /// 查询所有会议室信息 /// </summary> private void search() { try { dgvBoardroom.Rows.Clear(); ConferenceAuditorBLL Boardroom = new ConferenceAuditorBLL(); List <BoardroomModel> BoardroomList = new List <BoardroomModel>(); BoardroomList = Boardroom.GetBoardroomInfo(txtQuery.Text); int n = 0; foreach (BoardroomModel boardroom in BoardroomList) { dgvBoardroom.Rows.Add(); dgvBoardroom.Rows[n].Cells["ColumnBdrId"].Value = boardroom.BdrId; if (boardroom.BdrStatus == '1') { dgvBoardroom.Rows[n].Cells["ColumnBdrStatus"].Value = "正常"; } else { dgvBoardroom.Rows[n].Cells["ColumnBdrStatus"].Value = "损坏"; } dgvBoardroom.Rows[n].Cells["ColumnBdrName"].Value = boardroom.BdrName; dgvBoardroom.Rows[n].Cells["ColumnBdrContactNum"].Value = boardroom.BdrContactNum; dgvBoardroom.Rows[n].Cells["ColumnBdrLinkMan"].Value = boardroom.BdrLinkMan; dgvBoardroom.Rows[n].Cells["ColumnBdrContactPhone"].Value = boardroom.BdrContactPhone; dgvBoardroom.Rows[n].Cells["ColumnBdrIntro"].Value = boardroom.BdrIntro; dgvBoardroom.Rows[n].Cells["ColumnBdrRemarks"].Value = boardroom.BdrRemarks; n++; } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
/// <summary> /// 获取选中的信息显示在控件中 /// </summary> private void load() { ConferenceAuditorBLL Boardroom = new ConferenceAuditorBLL(); List <BoardroomModel> BoardroomList = new List <BoardroomModel>(); BoardroomList = Boardroom.GetBoardroomInfo(""); foreach (BoardroomModel boardroom in BoardroomList) { if (boardroom.BdrId == bdrid.BdrId) { if (boardroom.BdrStatus == '1') { ComtxtBdrs.Text = "正常"; } else { ComtxtBdrs.Text = "损坏"; } txtBdrName.Text = boardroom.BdrName; txtBdrContact.Text = boardroom.BdrContactNum.ToString(); txtConMan.Text = boardroom.BdrLinkMan; txtConPhone.Text = boardroom.BdrContactPhone; txtConIntro.Text = boardroom.BdrIntro; txtConRemarks.Text = boardroom.BdrRemarks; } } }
private void btnEnsure_Click(object sender, EventArgs e) { if (DialogResult.OK == MessageBox.Show("确定修改吗", "系统消息", MessageBoxButtons.OKCancel)) { ConferenceAuditorBLL auditbll = new ConferenceAuditorBLL(); List <ConferenceModel> conlist = new List <ConferenceModel>(); conlist = auditbll.GetConferenceInfo(selecetedConId.ToString()); foreach (ConferenceModel con in conlist) { if (con.ConId == this.selecetedConId) { con.ConHost = cmbHost.Text; List <BoardroomModel> bdrlist = new List <BoardroomModel>(); bdrlist = auditbll.GetBoardroomInfo(cmbPlace.Text); foreach (BoardroomModel bdr in bdrlist) { con.ConPlace = bdr.BdrId; } con.ConStartTime = dtpStart.Value; con.ConEndTime = dtpEnd.Value; auditbll.UpdateCon(con); MessageBox.Show("修改成功!"); } } } }
private void ChooseBoardroomForm_Load(object sender, EventArgs e) { ConferenceAuditorBLL conabll = new ConferenceAuditorBLL(); List <BoardroomModel> bdrlist = new List <BoardroomModel> (); bdrlist = conabll.GetBoardroomInfo(""); foreach (BoardroomModel bdr in bdrlist) { cmbSelect.Items.Add(bdr.BdrName); } }
/// <summary> /// 绑定会议室 /// </summary> private void bindPlace() { ConferenceAuditorBLL conabll = new ConferenceAuditorBLL(); List <BoardroomModel> bdrlist = new List <BoardroomModel>(); bdrlist = conabll.GetBoardroomInfo(""); foreach (BoardroomModel bdr in bdrlist) { cmbPlace.Items.Add(bdr.BdrName); } }
/// <summary> /// 读取界面 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void ConferenceApplyForm_Load(object sender, EventArgs e) { GetStaff(); dgvConMember.DataSource = dataset; List<TopicModel > toplist = new List<TopicModel> (); toplist = userbll.GetUserTopic(emp); foreach (TopicModel top in toplist) { cmbTopic.Items.Add(top.TopicHead); } ConferenceAuditorBLL conabll = new ConferenceAuditorBLL(); cmbHost.Text = conabll.GetAEmployee(emp.EmId).EmDepart; rdoInCon.Checked = true; rdoInCon_Click(null,null); rdoReg.Checked = true; rdoReg_Click(null,null); }
/// <summary> /// 读取议题信息 /// </summary> private void load() { try { dgvTopic.Rows.Clear(); TopicAuditorBLL Topic = new TopicAuditorBLL(); List <TopicModel> TopicList = new List <TopicModel>(); ConferenceAuditorBLL GetAEmployee = new ConferenceAuditorBLL(); TopicList = Topic.GetTopicInfo(""); int n = 0; foreach (TopicModel topic in TopicList) { if (topic.TopicApplicantId == TopicApplicantId) { dgvTopic.Rows.Add(); dgvTopic.Rows[n].Cells["dgvTopicSubTime"].Value = topic.TopicSubTime; if (topic.TopicStatus == '0') { dgvTopic.Rows[n].Cells["dgvTopicVerifyTime"].Value = ""; dgvTopic.Rows[n].Cells["dgvTopicStatus"].Value = "未审核"; } else { dgvTopic.Rows[n].Cells["dgvTopicVerifyTime"].Value = topic.TopicVerifyTime; if (topic.TopicStatus == '1') { dgvTopic.Rows[n].Cells["dgvTopicStatus"].Value = "已审核"; } else { dgvTopic.Rows[n].Cells["dgvTopicStatus"].Value = "未通过"; } } dgvTopic.Rows[n].Cells["dgvTopicHead"].Value = topic.TopicHead; dgvTopic.Rows[n].Cells["dgvTopicContent"].Value = topic.TopicContent; n++; } } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
/// <summary> /// 获取任务单 /// </summary> /// 作者:王宇昊 /// 创建时间:2014-09-24 /// 修改时间:2014-09-24 private void GetTask() { try { dgvTask.Rows.Clear(); ExecutorBLL Task = new ExecutorBLL(); List <TaskModel> TaskList = new List <TaskModel>(); ConferenceAuditorBLL ResourceName = new ConferenceAuditorBLL(); List <ResourceModel> Resource = new List <ResourceModel>(); TaskList = Task.GetTask(employee); int n = 0; foreach (TaskModel task in TaskList) { if (task.TaskConference.ConIsDone == '0') { dgvTask.Rows.Add(); dgvTask.Rows[n].Cells["ColumnConferenceId"].Value = task.TaskConference.ConId; dgvTask.Rows[n].Cells["ColumnConference"].Value = task.TaskBdrName; dgvTask.Rows[n].Cells["ColumnBoardroom"].Value = task.TaskConference.ConName; dgvTask.Rows[n].Cells["ColumnStartTime"].Value = task.TaskConference.ConStartTime; dgvTask.Rows[n].Cells["ColumnResource"].Value = ""; for (int i = 0; i < task.TaskResource.Count; i++) { Resource = ResourceName.GetAllResource(); foreach (ResourceModel Res in Resource) { if (Res.ResourceId == Convert.ToInt32(task.TaskResource[i])) { dgvTask.Rows[n].Cells["ColumnResource"].Value += task.TaskResource[i].ToString() + Res.ResourceClass + "\r\n"; } } } n++; } } //txtResId.Text = this.dgvTask.CurrentRow.Cells["ColumnResourceId"].Value.ToString(); dgvTask_CellContentClick(null, null); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
/// <summary> /// 绑定LIST到datagridview /// </summary> /// 作者:吴欣哲 /// 创建时间:20140919 public void BindDataToDgv() { dgvReturn.Rows.Clear(); ConferenceAuditorBLL con = new ConferenceAuditorBLL(); List <ConferenceModel> conList = new List <ConferenceModel>(); conList = con.GetConferenceInfo(txtQuery.Text); int n = 0; foreach (ConferenceModel conference in conList) { dgvReturn.Rows.Add(); dgvReturn.Rows[n].Cells["Column1"].Value = conference.ConId; if (conference.ConStatus == '0') { dgvReturn.Rows[n].Cells["Column2"].Value = "未审核"; } else if (conference.ConStatus == '1') { dgvReturn.Rows[n].Cells["Column2"].Value = "审核通过"; } else if (conference.ConStatus == '2') { dgvReturn.Rows[n].Cells["Column2"].Value = "不通过"; } dgvReturn.Rows[n].Cells["Column3"].Value = conference.ConName; dgvReturn.Rows[n].Cells["Column4"].Value = conference.ConStartTime; dgvReturn.Rows[n].Cells["Column5"].Value = conference.ConEndTime; UserBLL userbll = new UserBLL(); List <BoardroomModel> bdrlist = new List <BoardroomModel>(); bdrlist = userbll.GetBoardroomInfo(conference.ConPlace.ToString()); foreach (BoardroomModel bdr in bdrlist) { if (bdr.BdrId == conference.ConId) { dgvReturn.Rows[n].Cells["Column6"].Value = bdr.BdrName; } } n++; } }
/// <summary> /// 保存资源信息 /// </summary> private void Save() { try { ConferenceAuditorBLL Save = new ConferenceAuditorBLL(); ResourceModel resource = new ResourceModel(); resource.ResourceId = int.Parse(txtResId.Text); resource.ResourceClass = cmbResClass.Text; if (cmbStatus.Text == "空闲") { resource.ResourceStatus = '0'; } else if (cmbStatus.Text == "被预订") { resource.ResourceStatus = '1'; } else if (cmbStatus.Text == "使用中") { resource.ResourceStatus = '2'; } else if (cmbStatus.Text == "损坏") { resource.ResourceStatus = '3'; } else { MessageBox.Show("输入错误"); return; } Save.UpdateResouce(resource); MessageBox.Show("保存成功", "提示信息", MessageBoxButtons.OK, MessageBoxIcon.Warning); this.ResourceManageForm_Load(null, null); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
/// <summary> /// 读取资源信息 /// </summary> private void load() { try { dgvResource.Rows.Clear(); ConferenceAuditorBLL Resource = new ConferenceAuditorBLL(); List <ResourceModel> ResourceList = new List <ResourceModel>(); ResourceList = Resource.GetAllResource(); int n = 0; foreach (ResourceModel resource in ResourceList) { dgvResource.Rows.Add(); dgvResource.Rows[n].Cells["ColumnResourceId"].Value = resource.ResourceId; dgvResource.Rows[n].Cells["ColumnResourceClass"].Value = resource.ResourceClass; if (resource.ResourceStatus == '0') { dgvResource.Rows[n].Cells["ColumnResourceStatus"].Value = "空闲"; } if (resource.ResourceStatus == '1') { dgvResource.Rows[n].Cells["ColumnResourceStatus"].Value = "被预订"; } if (resource.ResourceStatus == '2') { dgvResource.Rows[n].Cells["ColumnResourceStatus"].Value = "使用中"; } if (resource.ResourceStatus == '3') { dgvResource.Rows[n].Cells["ColumnResourceStatus"].Value = "损坏"; } n++; } txtResId.Text = this.dgvResource.CurrentRow.Cells["ColumnResourceId"].Value.ToString(); cmbResClass.Text = this.dgvResource.CurrentRow.Cells["ColumnResourceClass"].Value.ToString(); cmbStatus.Text = this.dgvResource.CurrentRow.Cells["ColumnResourceStatus"].Value.ToString(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void cmbSelect_SelectionChangeCommitted(object sender, EventArgs e) { List <BoardroomModel> bdrlist = new List <BoardroomModel>(); ConferenceAuditorBLL conabll = new ConferenceAuditorBLL(); bdrlist = conabll.GetBoardroomInfo(""); foreach (BoardroomModel bdr in bdrlist) { if (bdr.BdrName.ToString() == cmbSelect.SelectedItem.ToString()) { lblId.Text = bdr.BdrId.ToString(); lblName.Text = bdr.BdrName; lblContactNum.Text = bdr.BdrContactNum.ToString(); lblIntro.Text = bdr.BdrIntro; lblRemarks.Text = bdr.BdrRemarks; lblStatus.Text = bdr.BdrStatus.ToString(); lblConMan.Text = bdr.BdrLinkMan; lblConPhone.Text = bdr.BdrContactPhone; } } }
/// <summary> /// 读取议题信息 /// </summary> /// <param name="statut">状态</param> /// <param name="statusDisplay">状态名称</param> /// <param name="dgvTopic">填充的表格</param> /// <param name="Name">列名前缀</param> /// <param name="query">查询的内容</param> private void load(char statut, string statusDisplay, DataGridView dgvTopic, string Name, string query) { try { dgvTopic.Rows.Clear(); TopicAuditorBLL Topic = new TopicAuditorBLL(); List <TopicModel> TopicList = new List <TopicModel>(); ConferenceAuditorBLL GetAEmployee = new ConferenceAuditorBLL(); TopicList = Topic.GetTopicInfo(query); int n = 0; foreach (TopicModel topic in TopicList) { if (topic.TopicStatus == statut) { dgvTopic.Rows.Add(); dgvTopic.Rows[n].Cells[Name + "Id"].Value = topic.TopicId; dgvTopic.Rows[n].Cells[Name + "ApplicantId"].Value = topic.TopicApplicantId; dgvTopic.Rows[n].Cells[Name + "Applicant"].Value = GetAEmployee.GetAEmployee(topic.TopicApplicantId).EmName; dgvTopic.Rows[n].Cells[Name + "SubTime"].Value = topic.TopicSubTime; if (topic.TopicStatus == '0') { dgvTopic.Rows[n].Cells[Name + "VerifyTime"].Value = ""; } else { dgvTopic.Rows[n].Cells[Name + "VerifyTime"].Value = topic.TopicVerifyTime; } dgvTopic.Rows[n].Cells[Name + "Head"].Value = topic.TopicHead; dgvTopic.Rows[n].Cells[Name + "Content"].Value = topic.TopicContent; dgvTopic.Rows[n].Cells[Name + "Status"].Value = statusDisplay; n++; } } } 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); } }
/// <summary> /// 删除资源信息 /// </summary> private void Del() { if (MessageBox.Show("确定删除该条资源信息?该操作不可恢复!", "提示信息", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.No) { return; } try { ConferenceAuditorBLL Del = new ConferenceAuditorBLL(); ResourceModel resource = new ResourceModel(); string resourceid = this.dgvResource.CurrentRow.Cells["ColumnResourceId"].Value.ToString();; //获取当前行要修改的资源ID resource.ResourceId = int.Parse(resourceid); Del.DelAResource(resource); MessageBox.Show("提交成功", "提示信息", MessageBoxButtons.OK, MessageBoxIcon.Warning); this.ResourceManageForm_Load(null, null); } catch (Exception ex) { MessageBox.Show(ex.Message); } }