public IndepPracticeContract GetPracticeById(long Id)
{
var builder = new SelectBuilder("SELECT * FROM indeppractice")
.RegisterEqualClause("id", Id);
//自动根据dataReader转成实体
return(AdoProvide.ExecuteReader(ReadConnectionString, builder, reader => EntityHelper.GetEntity <IndepPracticeContract>(reader)).FirstOrDefault());
}
public SupportContract GetModelByResourceId(long resourceId)
{
var bulider = new SelectBuilder("select * from support") //查询的SQL语句.
.RegisterEqualClause("ResourceId", resourceId);
//自动根据dataReader转成实体
return(AdoProvide.ExecuteReader(ReadConnectionString, bulider, reader => EntityHelper.GetEntity <SupportContract>(reader)).FirstOrDefault());
}
/// <summary>
/// 查询作业答案(无效方法)
/// </summary>
/// <param name="doId"></param>
/// <param name="answerType"></param>
/// <returns></returns>
public List <WorkAnswerContract <FlowReadAnswerEntity> > GetReadAnswers(long doId, int answerType)
{
var builder = new SelectBuilder("SELECT * FROM workanswer where DoId =@DoId and AnswerType=@AnswerType GROUP BY VersionId ORDER BY Score desc");
var _params = new IDataParameter[] {
AdoProvide.BuildParameter("@DoId", doId),
AdoProvide.BuildParameter("@AnswerType", answerType)
};
return(AdoProvide.ExecuteReader(ReadConnectionString, builder, reader => EntityHelper.GetEntity <WorkAnswerContract <FlowReadAnswerEntity> >(reader)).ToList());
}
public IndepPracticeContract GetPracticeByIds(long verionId, string moduleId, int userId)
{
var builder = new SelectBuilder("SELECT * FROM indeppractice")
.RegisterEqualClause("VersionId", verionId)
.RegisterEqualClause("ModuleId", moduleId)
.RegisterEqualClause("SubmitUserId", userId)
.RegisterEqualClause("Status", "0");
//自动根据dataReader转成实体
return(AdoProvide.ExecuteReader(ReadConnectionString, builder, reader => EntityHelper.GetEntity <IndepPracticeContract>(reader)).FirstOrDefault());
}