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