/// <summary>
/// 课程关联试卷 如果存在那么更新 否则 新增
/// </summary>
/// <param name="coursePaper"></param>
/// <returns></returns>
public bool InsertOrUpdateCourseMainPaper(Co_CoursePaper coursePaper)
{
if (_coursePaperDB.IsExistCourseMainPaper(coursePaper.CourseId.Value))
{
return(_coursePaperDB.UpdateCourseMainPaper(coursePaper));
}
else
{
return(_coursePaperDB.AddCoursePaper(coursePaper));
}
}
/// <summary>
/// 修改课程关联的 主试卷
/// </summary>
/// <param name="model"></param>
public bool UpdateCourseMainPaper(Co_CoursePaper model)
{
using (var conn = OpenConnection())
{
const string sqlwhere =
@"update Co_CoursePaper set PaperId=@PaperId,Length=@Length,
Hour=@Hour,LevelScore=@LevelScore,TestTimes=@TestTimes where IsMain=0 AND CourseId=@CourseId";
var param = new
{
model.PaperId,
model.Length,
model.Hour,
model.LevelScore,
model.TestTimes,
model.CourseId
};
return(conn.Execute(sqlwhere, param) > 0);
}
}
/// <summary>
/// 新增课程关联考试
/// </summary>
/// <param name="model"></param>
public bool AddCoursePaper(Co_CoursePaper model)
{
using (var conn = OpenConnection())
{
const string sqlwhere =
@"insert into Co_CoursePaper (PaperId,CourseId,Length,Hour,LevelScore,TestTimes,IsMain)
values (@PaperId,@CourseId,@Length,@Hour,@LevelScore,@TestTimes,@IsMain)";
var param = new
{
model.PaperId,
model.CourseId,
model.Length,
model.Hour,
model.LevelScore,
model.TestTimes,
model.IsMain
};
return(conn.Execute(sqlwhere, param) > 0);
}
}
public bool UpdateCoursePaper(Co_CoursePaper model)
{
return(coursepaperDb.UpdateCourseMainPaper(model));
}
public bool AddCoursePaper(Co_CoursePaper model)
{
return(coursepaperDb.AddCoursePaper(model));
}
