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));
}
