/// <summary> /// 保存内部与会人员签到信息 /// </summary> private void InSave() { try { ExecutorBLL Execu = new ExecutorBLL(); InConMemberModel InCon = new InConMemberModel(); for (int n = 0; n < dgvInRegister.Rows.Count; n++) { string selectValue = dgvInRegister.Rows[n].Cells["ColumnInConRegister"].EditedFormattedValue.ToString(); if (selectValue == "True") { InCon.ConId = Convert.ToInt32(conid); InCon.ConRegister = '1'; InCon.ConEmId = int.Parse(dgvInRegister.Rows[n].Cells["ColumnEmId"].Value.ToString()); Execu.InConMemberRegister(InCon); } else { InCon.ConId = Convert.ToInt32(conid); InCon.ConRegister = '0'; InCon.ConEmId = int.Parse(dgvInRegister.Rows[n].Cells["ColumnEmId"].Value.ToString()); Execu.InConMemberRegister(InCon); } } MessageBox.Show("提交成功", "提示信息", MessageBoxButtons.OK, MessageBoxIcon.Warning); InQuery(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
/// <summary> /// 保存外部与会人员签到信息 /// </summary> private void OutSave() { try { ExecutorBLL Execu = new ExecutorBLL(); OutConMemberModel OutCon = new OutConMemberModel(); for (int n = 0; n < dgvOutRegister.Rows.Count; n++) { string selectValue = dgvOutRegister.Rows[n].Cells["ColumnConRegister"].EditedFormattedValue.ToString(); if (selectValue == "True") { OutCon.ConId = Convert.ToInt32(conid); OutCon.ConRegister = '1'; OutCon.ConPhone = dgvOutRegister.Rows[n].Cells["ColumnConPhone"].Value.ToString(); Execu.OutConMemberRegister(OutCon); } else { OutCon.ConId = Convert.ToInt32(conid); OutCon.ConRegister = '0'; OutCon.ConPhone = dgvOutRegister.Rows[n].Cells["ColumnConPhone"].Value.ToString(); Execu.OutConMemberRegister(OutCon); } } MessageBox.Show("提交成功", "提示信息", MessageBoxButtons.OK, MessageBoxIcon.Warning); OutQuery(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void ConferenceModForm_Load(object sender, EventArgs e) { bindtopic(); bindhost(); bindPlace(); UserBLL userbll = new UserBLL(); ExecutorBLL exebll = new ExecutorBLL(); List <ConferenceModel> conlist = new List <ConferenceModel>(); conlist = userbll.GetConferenceInfo(selecetedConId.ToString()); foreach (ConferenceModel con in conlist) { if (con.ConId == selecetedConId) { cmbTopic.Text = con.ConName; cmbHost.Text = con.ConHost; List <BoardroomModel> bdrlist = new List <BoardroomModel>(); bdrlist = userbll.GetBoardroomInfo(con.ConPlace.ToString()); foreach (BoardroomModel bdr in bdrlist) { cmbPlace.Text = bdr.BdrName; } dtpEnd.Value = con.ConEndTime; dtpStart.Value = con.ConStartTime; List <ResourceModel> reslist = new List <ResourceModel>(); reslist = userbll.GetConUseResourceInfo(con.ConId); foreach (ResourceModel res in reslist) { cklStaff.Items.Add(res.ResourceId + " " + res.ResourceClass); } con.ConOthers = rtxRemarks.Text; cklStaff.Enabled = false; } } }
/// <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 Ensure() { try { ExecutorBLL Add = new ExecutorBLL(); OutConMemberModel OutConMember = new OutConMemberModel(); OutConMember.ConId = conid.Conid; OutConMember.ConName = this.txtConName.Text; OutConMember.ConSex = this.cmbConSex.Text; OutConMember.ConDuties = this.txtConDuties.Text; OutConMember.ConPhone = this.txtConPhone.Text; OutConMember.ConEmail = this.txtConEmail.Text; OutConMember.ConCompany = this.txtConCompany.Text; OutConMember.ConRegister = '0'; Add.AddConMenRecord(OutConMember); this.DialogResult = DialogResult.OK; MessageBox.Show("提交成功", "提示信息", MessageBoxButtons.OK, MessageBoxIcon.Warning); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
/// <summary> /// 查询内部与会人员信息 /// </summary> private void InQuery() { try { dgvInConMember.Rows.Clear(); ExecutorBLL InConMember = new ExecutorBLL(); List <EmployeeModel> EmployeeList = new List <EmployeeModel>(); ConferenceModel Conid = new ConferenceModel(); Conid.ConId = Convert.ToInt32(conid); EmployeeList = InConMember.GetInConMemberInfo(Conid); int n = 0; foreach (EmployeeModel employee in EmployeeList) { dgvInConMember.Rows.Add(); dgvInConMember.Rows[n].Cells["ColumnEmId"].Value = employee.EmId; dgvInConMember.Rows[n].Cells["ColumnEmName"].Value = employee.EmName; dgvInConMember.Rows[n].Cells["ColumnEmPermission"].Value = employee.EmPermission; dgvInConMember.Rows[n].Cells["ColumnEmSex"].Value = employee.EmSex; dgvInConMember.Rows[n].Cells["ColumnEmDepart"].Value = employee.EmDepart; dgvInConMember.Rows[n].Cells["ColumnEmPhone"].Value = employee.EmPhone; dgvInConMember.Rows[n].Cells["ColumnEmEmail"].Value = employee.EmEmail; dgvInConMember.Rows[n].Cells["ColumnEmCompany"].Value = employee.EmCompany; dgvInConMember.Rows[n].Cells["ColumnEmDuties"].Value = employee.EmDuties; n++; } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
/// <summary> /// 查询内部与会人员签到信息 /// </summary> private void InQuery() { try { dgvInRegister.Rows.Clear(); ExecutorBLL InConMember = new ExecutorBLL(); List <EmployeeModel> EmployeeList = new List <EmployeeModel>(); List <InConMemberModel> inconList = new List <InConMemberModel>(); ConferenceModel Conid = new ConferenceModel(); ConferenceModel Con = new ConferenceModel(); Conid.ConId = Convert.ToInt32(conid); EmployeeList = InConMember.GetInConMemberInfo(Conid); int n = 0; foreach (EmployeeModel employee in EmployeeList) { dgvInRegister.Rows.Add(); dgvInRegister.Rows[n].Cells["ColumnEmId"].Value = employee.EmId; dgvInRegister.Rows[n].Cells["ColumnEmName"].Value = employee.EmName; dgvInRegister.Rows[n].Cells["ColumnEmPhone"].Value = employee.EmPhone; dgvInRegister.Rows[n].Cells["ColumnEmDuties"].Value = employee.EmDuties; Con.ConId = Conid.ConId; inconList = InConMember.GetInConMemberRegisterInfo(Con); foreach (InConMemberModel incon in inconList) { if (incon.ConEmId == employee.EmId) { if (incon.ConRegister == '1') { ((DataGridViewCheckBoxCell)dgvInRegister.Rows[n].Cells["ColumnInConRegister"]).Value = true; } if (incon.ConRegister == '0') { ((DataGridViewCheckBoxCell)dgvInRegister.Rows[n].Cells["ColumnInConRegister"]).Value = false; } } dgvInRegister.Rows[n].Cells["ColumnConId2"].Value = incon.ConId; } 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> /// 查询外部与会人员信息 /// </summary> private void OutQuery() { try { dgvOutConMember.Rows.Clear(); ExecutorBLL OutConMember = new ExecutorBLL(); List <OutConMemberModel> OutConMemberList = new List <OutConMemberModel>(); ConferenceModel Conid = new ConferenceModel(); Conid.ConId = Convert.ToInt32(conid); OutConMemberList = OutConMember.GetOutConMemberRegisterInfo(Conid); int n = 0; foreach (OutConMemberModel outConMember in OutConMemberList) { dgvOutConMember.Rows.Add(); dgvOutConMember.Rows[n].Cells["ColumnConId"].Value = outConMember.ConId; dgvOutConMember.Rows[n].Cells["ColumnConName"].Value = outConMember.ConName; dgvOutConMember.Rows[n].Cells["ColumnConSex"].Value = outConMember.ConSex; dgvOutConMember.Rows[n].Cells["ColumnConDuties"].Value = outConMember.ConDuties; dgvOutConMember.Rows[n].Cells["ColumnConPhone"].Value = outConMember.ConPhone; dgvOutConMember.Rows[n].Cells["ColumnConEmail"].Value = outConMember.ConEmail; dgvOutConMember.Rows[n].Cells["ColumnConCompany"].Value = outConMember.ConCompany; if (outConMember.ConRegister == '1') { dgvOutConMember.Rows[n].Cells["ColumnConRegister"].Value = "已签到"; } else { dgvOutConMember.Rows[n].Cells["ColumnConRegister"].Value = "未签到"; } n++; } } catch (Exception ex) { MessageBox.Show(ex.Message); } }