/// <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); } }
} // function AddConMenRecord /// <summary> /// 添加内部与会人员 /// </summary> /// <returns> 添加内部与会人员</returns> /// 作者:王宇昊 /// 创建时间:2014-09-20 /// 修改时间: public void AddConMenRecord(InConMemberModel inConMen) { try { InConMemberDAL ICMDAL = new InConMemberDAL(); ICMDAL.AddARecord(inConMen); } catch (Exception ex) { throw new Exception(ex.Message); } } // function AddConMenRecord
} // function DelARecord /// <summary> /// 向数据库内部与会人员表中修改信息 /// </summary> /// <param name="obj">要修改的内部与会人员信息</param> /// <returns>操作成功返回true,失败返回false</returns> /// 作者:朱健 /// 创建时间:2014-09-16 /// 修改时间:2014-09-17 public bool UpdateARecord(object obj) { try { InConMemberModel InConMember = (InConMemberModel)obj; string strSqlCmd;// 存储数据库命令语句 strSqlCmd = string.Format("update InConMember set ConRegister='{2}' where ConId ='{0}'and ConEmId='{1}'", InConMember.ConId, InConMember.ConEmId, InConMember.ConRegister); SqlHelperDB.ExecuteSql(SqlHelperDB.ConnectionString, strSqlCmd); return(true); } catch (Exception) { return(false); } } // function UpdateARecord
} // function AddARecord /// <summary> /// 从数据库内部与会人员表中删除一条信息 /// </summary> /// <param name="obj">要删除的内部与会人员信息</param> /// <returns>操作成功返回true,失败返回false</returns> /// 作者:朱健 /// 创建时间:2014-09-16 /// 修改时间:2014-09-17 public bool DelARecord(object obj) { try { InConMemberModel InConMember = (InConMemberModel)obj; string strSqlCmd;// 存储数据库命令语句 strSqlCmd = string.Format("Delete from InconMember where ConId ='{0}'and ConEmId='{1}'", InConMember.ConId, InConMember.ConEmId); SqlHelperDB.ExecuteSql(SqlHelperDB.ConnectionString, strSqlCmd); return(true); } catch (Exception) { return(false); } } // function DelARecord
/// <summary> /// 向数据库内部与会人员表中插入一条新信息 /// </summary> /// <param name="obj">一条新的内部与会人员信息</param> /// <returns>操作成功返回true,失败返回false</returns> /// 作者:朱健 /// 创建时间:2014-09-16 /// 修改时间:2014-09-17 public bool AddARecord(object obj) { try { InConMemberModel InConMember = (InConMemberModel)obj; string strSqlCmd;// 存储数据库命令语句 strSqlCmd = string.Format("insert into InconMember values('{0}','{1}','{2}')", InConMember.ConId, InConMember.ConEmId, InConMember.ConRegister); SqlHelperDB.ExecuteSql(SqlHelperDB.ConnectionString, strSqlCmd); return(true); } catch (Exception) { return(false); } } // function AddARecord
} // function UpdateARecord /// <summary> /// 获取内部参会者的状态 /// </summary> /// <param name="conId">会议ID</param> /// <returns>返回内部参会者</returns> /// 作者:王宇昊 /// 创建时间:2014-09-22 /// 修改时间: public List <InConMemberModel> GetInConRecord(int conId) { try { List <InConMemberModel> InConMemberList = new List <InConMemberModel>(); InConMemberModel InConMember = new InConMemberModel(); DataSet data = SqlHelperDB.GetDataSet(DB.SqlHelperDB.ConnectionString, "select * from InConMember where Conid='" + conId + "'", "InConMember"); foreach (DataRow row in data.Tables["InConMember"].Rows) { InConMember.ConId = Convert.ToInt32(row["ConId"]); InConMember.ConEmId = Convert.ToInt32(row["EmId"]); InConMember.ConRegister = char.Parse(row["ConRegister"].ToString()); InConMemberList.Add(InConMember); } return(InConMemberList); } catch (Exception ex) { throw new Exception(ex.Message); } }// function GetInConRecord
/// <summary> /// 申请,将数据添加到数据库中 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnEnsure_Click(object sender, EventArgs e) { DialogResult result; result = MessageBox.Show("确定申请?", "系统消息", MessageBoxButtons.OKCancel); if (cmbHost.Text != "" && cmbTopic.Text != "") { if (result == DialogResult.OK) { con.ConHost = cmbHost.Text; con.ConSubMen = emp.EmId; con.ConOthers = rtxRemarks.Text; con.ConPlace = bdrPlace; con.ConStartTime = constart; con.ConEndTime = conend; con.ConStatus = '0'; con.ConIsDone = '0'; con.ConName = cmbTopic.Text; con.ConRecordMen = Convert.ToInt32(cmbRecMan.SelectedValue); // 随机选择会务执行人 List<EmployeeModel> emlist = new List<EmployeeModel>(); List<EmployeeModel> onelist = new List<EmployeeModel>(); emlist = userbll.GetAllEmployee(); foreach (EmployeeModel em2 in emlist) { if (em2.EmPermission == "CE") { onelist.Add(em2); } } Random r = new Random(); int ecId = r.Next(0, onelist.Count - 1); con.ConStaffMen = onelist[ecId].EmId; // 会议使用资源表中添加条目 List<string> rscList = new List<string>(); IEnumerator myEnumerator = cklStaff.CheckedIndices.GetEnumerator(); int index; string[] rsc; while (myEnumerator.MoveNext()) { index = (int)myEnumerator.Current; cklStaff.SelectedItem = cklStaff.Items[index]; rsc = cklStaff.Text.Split(' '); rscList.Add(rsc[0]); //MessageBox.Show(rsc[0]); } int ConId = userbll.ConApply(con, rscList); for (int i = 0; i < addconmem.dataset.Tables["table"].Rows.Count; i++) { InConMemberModel ICMM = new InConMemberModel(); ICMM.ConId = ConId; DataRow dr; dr = addconmem.dataset.Tables["table"].Rows[i]; ICMM.ConEmId = Convert.ToInt32(dr["员工ID"]); ICMM.ConRegister = '0'; userbll.AddConMenRecord(ICMM); } // 申请会议 MessageBox.Show("申请成功,请耐心等待管理员审核通知"); this.Close(); } } // end if else { MessageBox.Show("请填写完整信息"); } }
}// function GetTask /// <summary> /// 内部与会人员签到 /// </summary> /// <param name="RegisterMan"></param> /// 作者:王宇昊 /// 创建时间:2014-09-19 /// 修改时间: public void InConMemberRegister(InConMemberModel RegisterMan) { InConMemberDAL ICMDAL = new InConMemberDAL(); ICMDAL.UpdateARecord(RegisterMan); }// function InConMemberRegister