public void GetExamPersions(long EIID, int MEIID, out string IDs, out string Names) { IDs = ""; Names = ""; int total = 0; Entities.QueryExamPerson query = new QueryExamPerson(); DataTable dt = new DataTable(); if (MEIID == 0) {//获取普通考试考生数据 query.ExamType = 0; query.EIID = EIID; } else {//获取补考考生数据 query.ExamType = 1; query.EIID = EIID; query.MEIID = MEIID; } dt = BLL.ExamPerson.Instance.GetExamPerson(query, "", 1, 1000, out total); foreach (DataRow row in dt.Rows) { IDs += row["ExamPerSonID"].ToString() + ","; Names += BitAuto.YanFa.SysRightManager.Common.UserInfo.GerTrueName(Convert.ToInt32(row["ExamPerSonID"].ToString())) + ","; } if (IDs.Length > 0) { IDs = IDs.Substring(0, IDs.Length - 1); Names = Names.Substring(0, Names.Length - 1); } }
public string getEmployeeNames(long EIID, int MEIID, int EPID) { string Names = ""; int total = 0; string type = ""; Entities.QueryExamPerson query = new QueryExamPerson(); DataTable dt = new DataTable(); Entities.QueryExamOnline examOnlineQuery = new QueryExamOnline(); examOnlineQuery.EIID = Convert.ToInt32(EIID); if (MEIID == 0) {//获取普通考试考生数据 query.ExamType = 0; query.EIID = EIID; examOnlineQuery.IsMakeUp = 0; type = "0"; } else {//获取补考考生数据 query.ExamType = 1; query.EIID = EIID; query.MEIID = MEIID; examOnlineQuery.IsMakeUp = 1; examOnlineQuery.MEIID = MEIID; type = "1"; } dt = BLL.ExamPerson.Instance.GetExamPerson(query, "", 1, 1000, out total); foreach (DataRow row in dt.Rows) { string persionID = row["ExamPerSonID"].ToString(); string name = BitAuto.YanFa.SysRightManager.Common.UserInfo.GerTrueName(Convert.ToInt32(persionID)); examOnlineQuery.ExamPersonID = Convert.ToInt32(persionID); DataTable st_examOnline = BLL.ExamOnline.Instance.GetExamOnline(examOnlineQuery, "", 1, 1, out total); if (st_examOnline.Rows.Count > 0 && st_examOnline.Rows[0]["IsMarking"].ToString() == "1") { Names += "<a href='../ExamScoreManagement/MarkExamPaper.aspx?eiid=" + BLL.Util.EncryptString(EIID.ToString()) + "&type=" + BLL.Util.EncryptString(type) + "&come=" + BLL.Util.EncryptString("2") + "&ExamPersonID=" + BLL.Util.EncryptString(persionID) + "&epid=" + BLL.Util.EncryptString(EPID.ToString()) + "'>" + name + "</a>,"; } else { Names += name + ","; } } if (Names.Length > 0) { Names = Names.Substring(0, Names.Length - 1); } return(Names); }
/// <summary> /// 按照查询条件查询 /// </summary> /// <param name="query">查询条件</param> /// <param name="order">排序</param> /// <param name="currentPage">页号,-1不分页</param> /// <param name="pageSize">每页记录数</param> /// <param name="totalCount">总行数</param> /// <returns>集合</returns> public DataTable GetExamPerson(QueryExamPerson query, string order, int currentPage, int pageSize, out int totalCount) { string where = string.Empty; if (query.EIID != Constant.INT_INVALID_VALUE) { where += " AND EIID=" + query.EIID; } if (query.MEIID != Constant.INT_INVALID_VALUE) { where += " AND MEIID=" + query.MEIID; } if (query.EPID != Constant.INT_INVALID_VALUE) { where += " AND EPID=" + query.EPID; } if (query.ExamType != Constant.INT_INVALID_VALUE) { where += " AND ExamType=" + query.ExamType; } if (query.ExamPerSonID != Constant.INT_INVALID_VALUE) { where += " AND ExamPerSonID=" + query.ExamPerSonID; } DataSet ds; SqlParameter[] parameters = { new SqlParameter("@where", SqlDbType.NVarChar, 40000), new SqlParameter("@order", SqlDbType.NVarChar, 200), new SqlParameter("@pagesize", SqlDbType.Int, 4), new SqlParameter("@indexpage", SqlDbType.Int, 4), new SqlParameter("@totalRecorder", SqlDbType.Int, 4) }; parameters[0].Value = where; parameters[1].Value = order; parameters[2].Value = pageSize; parameters[3].Value = currentPage; parameters[4].Direction = ParameterDirection.Output; ds = SqlHelper.ExecuteDataset(CONNECTIONSTRINGS, CommandType.StoredProcedure, P_EXAMPERSON_SELECT, parameters); totalCount = (int)(parameters[4].Value); return(ds.Tables[0]); }
/// <summary> /// 得到一个对象实体 /// </summary> public Entities.ExamPerson GetExamPerson(long EPID) { QueryExamPerson query = new QueryExamPerson(); query.EPID = EPID; DataTable dt = new DataTable(); int count = 0; dt = GetExamPerson(query, string.Empty, 1, 1, out count); if (count > 0) { return(LoadSingleExamPerson(dt.Rows[0])); } else { return(null); } }
/// <summary> /// 是否存在该记录 /// </summary> public bool IsExistsByEPID(long EPID) { QueryExamPerson query = new QueryExamPerson(); query.EPID = EPID; DataTable dt = new DataTable(); int count = 0; dt = GetExamPerson(query, string.Empty, 1, 1, out count); if (count > 0) { return(true); } else { return(false); } }
/// <summary> /// 按照查询条件查询 /// </summary> /// <param name="query">查询条件</param> /// <param name="order">排序</param> /// <param name="currentPage">页号,-1不分页</param> /// <param name="pageSize">每页记录数</param> /// <param name="totalCount">总行数</param> /// <returns>集合</returns> public DataTable GetExamPerson(QueryExamPerson query, string order, int currentPage, int pageSize, out int totalCount) { return(Dal.ExamPerson.Instance.GetExamPerson(query, order, currentPage, pageSize, out totalCount)); }