/// <summary>
/// 详细信息
/// </summary>
/// <param name="TitleListID">题目ID</param>
/// <returns></returns>
public List <Model.OptionsList> Details(int TitleListID)
{
string strSql = "";
strSql = "Select * FROM [OptionsList] Where [TitleListID]='" + TitleListID + "'";
List <Model.OptionsList> List = new List <Model.OptionsList>();
SqlParameter[] parameters =
{
};
SqlDataReader DR;
DR = ExamSys.ExecuteReader(strSql.ToString(), parameters);
using (DR)
{
while (DR.Read())
{
Model.OptionsList model = new Model.OptionsList();
model.Name = DR["Name"].ToString();
model.T_F = DR["T_F"].ToString();
model.ID = int.Parse(DR["ID"].ToString());
List.Add(model);
}
DR.Close();
DR.Dispose();
}
return(List);
}
/// <summary>
/// 详细信息
/// </summary>
/// <param name="ID">ID</param>
/// <returns></returns>
public List <Model.Papers> Details(int ID)
{
string strSql = "";
strSql = "Select * FROM [Papers] Where [ID]='" + ID + "'";
List <Model.Papers> List = new List <Model.Papers>();
SqlParameter[] parameters =
{
};
SqlDataReader DR;
DR = ExamSys.ExecuteReader(strSql.ToString(), parameters);
using (DR)
{
while (DR.Read())
{
Model.Papers model = new Model.Papers();
model.ID = int.Parse(DR["ID"].ToString());
model.Name = DR["Name"].ToString();
model.CourseID = int.Parse(DR["CourseID"].ToString());
model.Type = DR["Type"].ToString();
model.Lock = int.Parse(DR["Lock"].ToString());
List.Add(model);
}
DR.Close();
DR.Dispose();
}
return(List);
}
/// <summary>
/// 显示所有
/// </summary>
/// <param name="Type">类型(单选/多选/不定项选/判断)</param>
/// <param name="CourseID">课程ID</param>
/// <param name="Extent">程度</param>
/// <returns></returns>
public List <Model.TitleList> GetList(string Type, int CourseID, string Extent)
{
string strSql = "";
strSql = "Select * FROM [TitleList] Where [Type]='" + Type + "' AND [CourseID]='" + CourseID + "' AND [Extent]='" + Extent + "'";
List <Model.TitleList> List = new List <Model.TitleList>();
SqlParameter[] parameters =
{
};
SqlDataReader DR;
DR = ExamSys.ExecuteReader(strSql.ToString(), parameters);
using (DR)
{
while (DR.Read())
{
Model.TitleList model = new Model.TitleList();
model.Title = DR["Title"].ToString();
model.T_F = DR["T_F"].ToString();
model.Analysis = DR["Analysis"].ToString();
model.ID = int.Parse(DR["ID"].ToString());
model.Extent = DR["Extent"].ToString();
List.Add(model);
}
DR.Close();
DR.Dispose();
}
return(List);
}
/// <summary>
/// 显示所有
/// </summary>
/// <param name="TitleListID">题目ID</param>
/// <returns></returns>
public List <Model.PapersOptionsList> GetList(int TitleListID, int PapersID)
{
string strSql = "";
//strSql = "Select * FROM [PapersOptionsList] Where [TitleListID]='" + TitleListID + "' and [PapersID]='" + PapersID + "' order by newid()";
strSql = "Select * FROM [PapersOptionsList] Where [TitleListID]='" + TitleListID + "' and [PapersID]='" + PapersID + "' order by ID";
List <Model.PapersOptionsList> List = new List <Model.PapersOptionsList>();
SqlParameter[] parameters =
{
};
SqlDataReader DR;
DR = ExamSys.ExecuteReader(strSql.ToString(), parameters);
using (DR)
{
while (DR.Read())
{
Model.PapersOptionsList model = new Model.PapersOptionsList();
model.Name = DR["Name"].ToString();
model.T_F = DR["T_F"].ToString();
model.PapersID = int.Parse(DR["PapersID"].ToString());
model.TitleListID = int.Parse(DR["TitleListID"].ToString());
model.ID = int.Parse(DR["ID"].ToString());
model.Score = int.Parse(DR["Score"].ToString());
List.Add(model);
}
DR.Close();
DR.Dispose();
}
return(List);
}
/// <summary>
/// 详细信息
/// </summary>
/// <param name="ID">ID</param>
/// <returns></returns>
public List <Model.TitleList> Details(int ID)
{
string strSql = "";
strSql = "Select * FROM [TitleList] Where [ID]='" + ID + "'";
List <Model.TitleList> List = new List <Model.TitleList>();
SqlParameter[] parameters =
{
};
SqlDataReader DR;
DR = ExamSys.ExecuteReader(strSql.ToString(), parameters);
using (DR)
{
while (DR.Read())
{
Model.TitleList model = new Model.TitleList();
model.Title = DR["Title"].ToString();
model.T_F = DR["T_F"].ToString();
model.Analysis = DR["Analysis"].ToString();
model.ID = int.Parse(DR["ID"].ToString());
model.CourseID = int.Parse(DR["CourseID"].ToString());
model.Status_id = int.Parse(DR["Status_id"].ToString());
List.Add(model);
}
DR.Close();
DR.Dispose();
}
return(List);
}
/// <summary>
/// 显示所有
/// </summary>
/// <param name="Type">类型(单选/多选/不定项选/判断)</param>
/// <param name="PapersID">试卷ID</param>
/// <returns></returns>
public List <Model.PapersTitleList> GetList(string Type, int PapersID, int StatusID)
{
string strSql = "";
//strSql = "Select * FROM [PapersTitleList] Where [Type]='" + Type + "' AND [PapersID]='" + PapersID + "' AND Status_id='"+ StatusID + "' order by newid()";
//add by wangke 2016-12-13 题目排序调整
strSql = "Select * FROM [PapersTitleList] Where [Type]='" + Type + "' AND [PapersID]='" + PapersID + "' AND Status_id='" + StatusID + "' order by ID";
List <Model.PapersTitleList> List = new List <Model.PapersTitleList>();
SqlParameter[] parameters =
{
};
SqlDataReader DR;
DR = ExamSys.ExecuteReader(strSql.ToString(), parameters);
using (DR)
{
while (DR.Read())
{
Model.PapersTitleList model = new Model.PapersTitleList();
model.Title = DR["Title"].ToString();
model.T_F = DR["T_F"].ToString();
model.ID = int.Parse(DR["ID"].ToString());
model.Score = int.Parse(DR["Score"].ToString());
List.Add(model);
}
DR.Close();
DR.Dispose();
}
return(List);
}
public void DisposeResultaat()
{
foreach (var DR in ResultaatList)
{
DR.Dispose();
}
ResultaatList.Clear();
GC.Collect();
}
/// <summary>
/// 查询所有
/// </summary>
/// <returns></returns>
public List <Model.UserSystem> GetList(int PageCount, int PageSize)
{
string strSql = "";
string RedCountsql = "";
int RowTotal = (PageCount - 1) * PageSize;//
RedCountsql = "(select count(TR_ID) from [AP_TRAINEE_USER]) as RowTotal";
strSql = "Select Top " + PageSize + " [TR_ID],[TR_POSITION],[TR_NICKNAME],[TR_NAME],[TR_SEX],[TR_CITY],[TR_PHONE],[TR_EMAIL],[TR_COMPANY_TEL],[TR_QR_CODE]," + RedCountsql + " FROM AP_TRAINEE_USER where [TR_ID] not in (Select Top " + RowTotal + " [TR_ID] from AP_TRAINEE_USER ORDER BY TR_ID DESC) ORDER BY TR_ID DESC";
List <Model.UserSystem> List = new List <Model.UserSystem>();
SqlParameter[] parameters =
{
};
SqlDataReader DR;
if (GetUserSysSetupInfo())
{
DR = UserSys.ExecuteReader(strSql.ToString(), parameters);
}
else
{
DR = ExamSys.ExecuteReader(strSql.ToString(), parameters);
}
using (DR)
{
while (DR.Read())
{
Model.UserSystem model = new Model.UserSystem();
model.ID = int.Parse(DR["TR_ID"].ToString());
model.cnName = DR["TR_NAME"].ToString();
model.enName = DR["TR_NICKNAME"].ToString();
model.Sex = DR["TR_SEX"].ToString();
model.ZipCode = DR["TR_QR_CODE"].ToString();
model.Address = DR["TR_CITY"].ToString();
model.Mobile = DR["TR_COMPANY_TEL"].ToString();
model.Phone = DR["TR_PHONE"].ToString();
model.Email = DR["TR_EMAIL"].ToString();
model.RowTotal = int.Parse(DR["RowTotal"].ToString());
List.Add(model);
}
DR.Close();
DR.Dispose();
}
return(List);
}
/// <summary>
/// 显示所有
/// add by wangke 2016-11-23 添加返回datatable类型
/// </summary>
/// <param name="Type">类型(单选/多选/不定项选/判断)</param>
/// <param name="CourseID">课程ID</param>
/// <returns></returns>
public DataTable GetList(string Type, int CourseID, int Status_id)
{
string strSql = "";
if (Status_id != 0)
{
strSql = "Select * FROM [TitleList] Where [Type]='" + Type + "' AND [CourseID]='" + CourseID + "' AND [Status_id]=" + Status_id;
}
else
{
strSql = "Select * FROM [TitleList] Where [Type]='" + Type + "' AND [CourseID]='" + CourseID + "'";
}
DataTable dt = new DataTable();
dt.Columns.Add("Title");
dt.Columns.Add("T_F");
dt.Columns.Add("Analysis");
dt.Columns.Add("ID");
dt.Columns.Add("Extent");
SqlParameter[] parameters =
{
};
SqlDataReader DR;
DR = ExamSys.ExecuteReader(strSql.ToString(), parameters);
using (DR)
{
while (DR.Read())
{
DataRow dr = dt.NewRow();
dr["Title"] = DR["Title"].ToString();
dr["T_F"] = DR["T_F"].ToString();
dr["Analysis"] = DR["Analysis"].ToString();
dr["ID"] = DR["ID"].ToString();
dr["Extent"] = DR["Extent"].ToString();
dt.Rows.Add(dr);
}
DR.Close();
DR.Dispose();
}
return(dt);
}
/// <summary>
/// 查询所有
/// </summary>
/// <param name="CourseLbID">类别ID</param>
/// <returns></returns>
public List <Model.CourseSystem> GetList(int PageCount, int PageSize, int CourseLbID)
{
string strSql = "";
string RedCountsql = "";
int RowTotal = (PageCount - 1) * PageSize;//
RedCountsql = "(select count(CR_ID) from [AP_COURSE] where [CR_CATEGORY_ID]='" + CourseLbID + "' ) as RowTotal";
strSql = "Select Top " + PageSize + " *," + RedCountsql + " FROM [AP_COURSE] where [CR_ID] not in (Select Top " + RowTotal + " [CR_ID] from [AP_COURSE] Where [CR_CATEGORY_ID]='" + CourseLbID + "' ORDER BY CR_ID DESC ) And [CR_CATEGORY_ID]='" + CourseLbID + "' ORDER BY CR_ID DESC";
List <Model.CourseSystem> List = new List <Model.CourseSystem>();
SqlParameter[] parameters =
{
};
SqlDataReader DR;
if (GetCourseSysSetupInfo())
{
DR = CourseSys.ExecuteReader(strSql.ToString(), parameters);
}
else
{
DR = ExamSys.ExecuteReader(strSql.ToString(), parameters);
}
using (DR)
{
while (DR.Read())
{
Model.CourseSystem model = new Model.CourseSystem();
model.ID = int.Parse(DR["CR_ID"].ToString());
model.Title = DR["CR_COURSE_NAME"].ToString();
model.RowTotal = int.Parse(DR["RowTotal"].ToString());
model.Credit = int.Parse(DR["CR_CREDIT"].ToString());
model.Money = int.Parse(DR["CR_MONEY"].ToString());
List.Add(model);
}
DR.Close();
DR.Dispose();
}
return(List);
}
/// <summary>
/// 查询所有
/// </summary>
/// <param name="UserName">用户名(可中可英)</param>
/// <returns></returns>
public List <Model.UserSystem> GetList(string UserName)
{
string strSql = "";
strSql = "Select * FROM [AP_TRAINEE_USER] Where [TR_NAME] like '%" + UserName + "%' or [TR_NICKNAME] like '%" + UserName + "%'";
List <Model.UserSystem> List = new List <Model.UserSystem>();
SqlParameter[] parameters =
{
};
SqlDataReader DR;
if (GetUserSysSetupInfo())
{
DR = UserSys.ExecuteReader(strSql.ToString(), parameters);
}
else
{
DR = ExamSys.ExecuteReader(strSql.ToString(), parameters);
}
using (DR)
{
while (DR.Read())
{
Model.UserSystem model = new Model.UserSystem();
model.ID = int.Parse(DR["TR_ID"].ToString());
model.cnName = DR["TR_NAME"].ToString();
model.enName = DR["TR_NICKNAME"].ToString();
model.Sex = DR["TR_SEX"].ToString();
model.ZipCode = DR["TR_QR_CODE"].ToString();
model.Address = DR["TR_CITY"].ToString();
model.Mobile = DR["TR_COMPANY_TEL"].ToString();
model.Phone = DR["TR_PHONE"].ToString();
model.Email = DR["TR_EMAIL"].ToString();
List.Add(model);
}
DR.Close();
DR.Dispose();
}
return(List);
}
/// <summary>
/// 统计分值
/// </summary>
/// <param name="Type">类型(单选/多选/不定项选/判断)</param>
/// <param name="PapersID">试卷ID</param>
/// <returns></returns>
private List <Model.PapersTitleList> nSumScore(string Type, int PapersID)
{
string strSql = "";
if (Type != "")
{
strSql = "SELECT SUM([Score]) as sumscore FROM [ExaminationSystem].[Exam].[PapersTitleList] where PapersID='" + PapersID + "' and Type='" + Type + "'";
}
else
{
strSql = "SELECT SUM([Score]) as sumscore FROM [ExaminationSystem].[Exam].[PapersTitleList] where PapersID='" + PapersID + "'";
}
List <Model.PapersTitleList> List = new List <Model.PapersTitleList>();
SqlParameter[] parameters =
{
};
SqlDataReader DR;
DR = ExamSys.ExecuteReader(strSql.ToString(), parameters);
using (DR)
{
while (DR.Read())
{
Model.PapersTitleList model = new Model.PapersTitleList();
if (DR["sumscore"].ToString() == "")
{
model.Score = 0;
}
else
{
model.Score = int.Parse(DR["sumscore"].ToString());
}
List.Add(model);
}
DR.Close();
DR.Dispose();
}
return(List);
}
/// <summary>
/// 查询所有
/// </summary>
/// <returns></returns>
public List <Model.CourseSystem> GetList()
{
string strSql = "";
strSql = "Select * FROM [AP_COURSE_CATEGORY]";
List <Model.CourseSystem> List = new List <Model.CourseSystem>();
SqlParameter[] parameters =
{
};
SqlDataReader DR;
if (GetCourseSysSetupInfo())
{
DR = CourseSys.ExecuteReader(strSql.ToString(), parameters);
}
else
{
DR = ExamSys.ExecuteReader(strSql.ToString(), parameters);
}
using (DR)
{
while (DR.Read())
{
Model.CourseSystem model = new Model.CourseSystem();
model.CourseLbID = int.Parse(DR["CRC_ID"].ToString());
model.Name = DR["CRC_CATEGORY_NAME"].ToString();
model.Up = int.Parse(DR["CRC_PARENT_ID"].ToString());
model.CourseCount = GetCourseCount(int.Parse(DR["CRC_ID"].ToString()));
//model.CourseCount = 1;
List.Add(model);
}
DR.Close();
DR.Dispose();
}
return(List);
}
/// <summary>
/// 显示详细
/// </summary>
/// <param name="ID">ID</param>
/// <returns></returns>
public List <Model.CourseSystem> Details(int ID)
{
string strSql = "";
strSql = "Select * FROM [AP_COURSE] Where [CR_ID]='" + ID + "'";
List <Model.CourseSystem> List = new List <Model.CourseSystem>();
SqlParameter[] parameters =
{
};
SqlDataReader DR;
if (GetCourseSysSetupInfo())
{
DR = CourseSys.ExecuteReader(strSql.ToString(), parameters);
}
else
{
DR = ExamSys.ExecuteReader(strSql.ToString(), parameters);
}
using (DR)
{
while (DR.Read())
{
Model.CourseSystem model = new Model.CourseSystem();
model.ID = int.Parse(DR["CR_ID"].ToString());
model.Title = DR["CR_COURSE_NAME"].ToString();
model.Abstract = DR["CR_DESC"].ToString();
model.Outline = DR["CR_OUTLINE"].ToString();
List.Add(model);
}
DR.Close();
DR.Dispose();
}
return(List);
}
