/// <summary>
/// 数据访问通过条件查询并分页排序
/// </summary>
/// <param name="WhereString">查询条件</param>
/// <param name="PageIndex">当前页码</param>
/// <param name="PageSize">页大小（每页显示多少条数据）</param>
/// <param name="OrderString">排序条件（排序条件为必须参数）</param>
/// <returns>ExamCourse实体类对象</returns>
public List <ExamCourse> SelectByWhereAndPage(string WhereString, int PageIndex, int PageSize, string OrderString, out int TotalCount)
{
SqlParameter[] param = new SqlParameter[]
{
new SqlParameter("@where", WhereString),
new SqlParameter("@pageIndex", PageIndex),
new SqlParameter("@pageSize", PageSize),
new SqlParameter("@orderString", OrderString),
new SqlParameter("@TotalCount", ParameterDirection.Output)
};
List <ExamCourse> list = new List <ExamCourse>();
ExamCourse model = null;
using (SqlDataReader dr = DBHelper.RunProcedure("ExamCourse_SelectByWhereAndPage", param))
{
while (dr.Read())
{
model = new ExamCourse();
model.ExamCourseId = Convert.ToInt32(dr["ExamCourseId"]);
model.ExamId = Convert.ToInt32(dr["ExamId"]);
model.CourseId = Convert.ToInt32(dr["CourseId"]);
model.IsDelete = Convert.ToBoolean(dr["IsDelete"]);
list.Add(model);
}
if (dr.NextResult() && dr.Read())
{
TotalCount = Convert.ToInt32(dr["TotalCount"]);
}
else
{
TotalCount = 0;
}
}
return(list);
}
/// <summary>
/// 增加
/// </summary>
/// <param name="ExamCourse">ExamCourse实体对象</param>
/// <returns>int值,返回自增ID</returns>
public int AddReturnId(ExamCourse model)
{
SqlParameter[] param = new SqlParameter[]
{
new SqlParameter("@ExamId", model.ExamId),
new SqlParameter("@CourseId", model.CourseId),
new SqlParameter("@IsDelete", model.IsDelete)
};
return(Convert.ToInt32(DBHelper.ExecuteScalar("ExamCourse_AddReturnId", param)));
}
/// <summary>
/// 增加
/// </summary>
/// <param name="ExamCourse">ExamCourse实体对象</param>
/// <returns>bool值,判断是否操作成功</returns>
public bool Add(ExamCourse model)
{
SqlParameter[] param = new SqlParameter[]
{
new SqlParameter("@ExamId", model.ExamId),
new SqlParameter("@CourseId", model.CourseId),
new SqlParameter("@IsDelete", model.IsDelete)
};
return(DBHelper.ExecuteNonQuery("ExamCourse_Add", param));
}
public IActionResult Index(ExamCourse examCourse)
{
var userId = User.FindFirstValue(ClaimTypes.NameIdentifier);
var query = _context.Exam.Where(m => m.ApplicationUserId == userId)
.Select(x => new ExamCourse
{
examDate = x.examDate,
examDifficulty = x.examDifficulty,
Group = x.Group,
courseName = x.Course.courseName,
eId = x.eId
});
return(View(query.ToList()));
}
/// <summary>
/// 查看全部
/// </summary>
/// <returns>list集合</returns>
public List <ExamCourse> SelectAll()
{
List <ExamCourse> list = new List <ExamCourse>();
ExamCourse model = null;
using (SqlDataReader dr = DBHelper.RunProcedure("ExamCourse_SelectAll", null))
{
while (dr.Read())
{
model = new ExamCourse();
model.ExamCourseId = Convert.ToInt32(dr["ExamCourseId"]);
model.ExamId = Convert.ToInt32(dr["ExamId"]);
model.CourseId = Convert.ToInt32(dr["CourseId"]);
model.IsDelete = Convert.ToBoolean(dr["IsDelete"]);
list.Add(model);
}
}
return(list);
}
/// <summary>
/// 通过Id查询
/// </summary>
/// <param name="Id">主键Id</param>
/// <returns>ExamCourse实体类对象</returns>
public ExamCourse SelectById(int Id)
{
SqlParameter[] param = new SqlParameter[]
{
new SqlParameter("@ExamCourseId", Id)
};
ExamCourse model = new ExamCourse();
using (SqlDataReader dr = DBHelper.RunProcedure("ExamCourse_SelectById", param))
{
if (dr.Read())
{
model.ExamCourseId = Convert.ToInt32(dr["ExamCourseId"]);
model.ExamId = Convert.ToInt32(dr["ExamId"]);
model.CourseId = Convert.ToInt32(dr["CourseId"]);
model.IsDelete = Convert.ToBoolean(dr["IsDelete"]);
}
}
return(model);
}
private static ExamTuitionData ResolveExamTuition(ExamCourse course, List <Tuition> tuitions, Period period)
{
foreach (var tuition in tuitions)
{
foreach (var tuitionPeriod in tuition.Periods)
{
if (tuitionPeriod.TuitionNumber == course.TuitionNumber && tuitionPeriod.Subject == course.CourseName && tuitionPeriod.PeriodNumber == period.Number)
{
return(new ExamTuitionData
{
Grades = tuitionPeriod.Grades.Distinct().ToList(),
SubjectOrCourse = tuitionPeriod.Subject,
Teachers = new List <string> {
tuitionPeriod.Teacher
}
});
}
}
}
return(null);
}
/// <summary>
/// 通过条件查询
/// </summary>
/// <param name="WhereString">查询条件</param>
/// <returns>ExamCourse实体类对象</returns>
public List <ExamCourse> SelectByWhere(string WhereString)
{
SqlParameter[] param = new SqlParameter[]
{
new SqlParameter("@where", WhereString)
};
List <ExamCourse> list = new List <ExamCourse>();
ExamCourse model = null;
using (SqlDataReader dr = DBHelper.RunProcedure("ExamCourse_SelectByWhere", param))
{
while (dr.Read())
{
model = new ExamCourse();
model.ExamCourseId = Convert.ToInt32(dr["ExamCourseId"]);
model.ExamId = Convert.ToInt32(dr["ExamId"]);
model.CourseId = Convert.ToInt32(dr["CourseId"]);
model.IsDelete = Convert.ToBoolean(dr["IsDelete"]);
list.Add(model);
}
}
return(list);
}
/// <summary>
/// 修改
/// </summary>
/// <param name="ExamCourse">ExamCourse实体对象</param>
/// <returns>bool值,判断是否操作成功</returns>
public bool Change(ExamCourse model)
{
return(dal.Change(model));
}
/// <summary>
/// 增加
/// </summary>
/// <param name="ExamCourse">ExamCourse实体对象</param>
/// <returns>int值,返回自增ID</returns>
public int AddReturnId(ExamCourse model)
{
return(dal.AddReturnId(model));
}
/// <summary>
/// 增加
/// </summary>
/// <param name="ExamCourse">ExamCourse实体对象</param>
/// <returns>bool值,判断是否操作成功</returns>
public bool Add(ExamCourse model)
{
return(dal.Add(model));
}
