public static dto_Reply GetReplyById(int id)
{
dto_Reply result = null;
string sql = "select Id, UserId, TopicId, ReplyContent, CreateDate, Good from T_Reply where Id = @Id ";
using (var reader = MySqlHelper.ExecuteReader(Util.GetConnectString(BBSConnString), sql.ToString(), "@Id".ToInt32InPara(id)))
{
if (reader != null && reader.HasRows)
{
result = MySqlDBHelper.ConvertDataReaderToEntitySingle <dto_Reply>(reader);
}
}
return(result);
}
/// <summary>
/// 查询作业
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public static T_Zy GetZy(int id)
{
T_Zy model = null;
using (MySqlDataReader dr = MySqlHelper.ExecuteReader(Util.GetConnectString(ZyConnString),
"select Id, UserId, ZyName, CourseId, SubjectId, CreateDate, Ip, IMEI, MobileBrand, SystemType, Browser, OpenDate, DueDate, Type, Status from T_Zy where Id = @Id",
"@Id".ToInt32InPara(id)))
{
if (dr != null && dr.HasRows)
{
model = MySqlDBHelper.ConvertDataReaderToEntitySingle <T_Zy>(dr);
}
}
return(model);
}
public static T_School GetSchool(int schoolId)
{
T_School model = null;
using (MySqlDataReader dr = MySqlHelper.ExecuteReader(Util.GetConnectString(BaseConnString),
"select SchoolId, SchoolName from T_School where SchoolId = @SchoolId",
"@SchoolId".ToInt32InPara(schoolId)))
{
if (dr != null && dr.HasRows)
{
model = MySqlDBHelper.ConvertDataReaderToEntitySingle <T_School>(dr);
}
}
return(model);
}
public static T_User GetUser(int Id)
{
T_User model = null;
using (MySqlDataReader dr = MySqlHelper.ExecuteReader(Util.GetConnectString(UserConnString),
"select Id, UserName, TrueName, Psd, Mobile, FirstLoginDate, CreateDate, ZyPsd, ZyPrice, ProvinceId, CityId, DistrictId, SchoolId, GradeId, ClassId from T_User where Id = @Id",
"@Id".ToInt32InPara(Id)))
{
if (dr != null && dr.HasRows)
{
model = MySqlDBHelper.ConvertDataReaderToEntitySingle <T_User>(dr);
}
}
return(model);
}
/// <summary>
/// 根据试题Id获取其试题信息（不包含任何小题、选项）
/// </summary>
/// <param name="qId"></param>
/// <returns></returns>
public static dto_Question GetQuestion(int courseId, int qId)
{
dto_Question model = null;
using (MySqlDataReader dr = MySqlHelper.ExecuteReader(Util.GetConnectString(QuesConnString),
"select id, courseid, ptypeid, typeid, typename, difftype, diff, haschildren, quesbody, quesanswer, quesparse, pid, usagetimes from T_Questions where courseid = @courseid and id = @id",
"@courseid".ToInt32InPara(courseId), "@id".ToInt32InPara(qId)))
{
if (dr != null && dr.HasRows)
{
model = MySqlDBHelper.ConvertDataReaderToEntitySingle <dto_Question>(dr);
}
}
return(model);
}
/// <summary>
/// 根据试题Id获取其选项信息
/// </summary>
/// <param name="qId"></param>
/// <returns></returns>
public static T_QuesOptions GetQuesOption(int qId)
{
T_QuesOptions model = null;
using (MySqlDataReader dr = MySqlHelper.ExecuteReader(Util.GetConnectString(QuesConnString),
"select id, optiona, optionb, optionc, optiond, optione, optionf, optiong from T_QuesOptions where id = @id",
"@id".ToInt32InPara(qId)))
{
if (dr != null && dr.HasRows)
{
model = MySqlDBHelper.ConvertDataReaderToEntitySingle <T_QuesOptions>(dr);
}
}
return(model);
}
public static T_UserExtend GetUserExtend(int userId)
{
T_UserExtend model = null;
using (MySqlDataReader dr = MySqlHelper.ExecuteReader(Util.GetConnectString(UserConnString),
"select UserId, Locked from T_UserExtend where UserId = @UserId",
"@UserId".ToInt32InPara(userId)))
{
if (dr != null && dr.HasRows)
{
model = MySqlDBHelper.ConvertDataReaderToEntitySingle <T_UserExtend>(dr);
}
}
return(model);
}
public static dto_ModifyRequest GetModifyRequest(int userId)
{
dto_ModifyRequest model = null;
using (MySqlDataReader dr = MySqlHelper.ExecuteReader(Util.GetConnectString(UserConnString),
"select Id, UserId, FromSchoolId, ToSchoolId, Reason, Status, CreateDate from T_ModifyRequest where UserId = @UserId and Status = 0 limit 1",
"@UserId".ToInt32InPara(userId)))
{
if (dr != null && dr.HasRows)
{
model = MySqlDBHelper.ConvertDataReaderToEntitySingle <dto_ModifyRequest>(dr);
}
}
return(model);
}
public static dto_Topic GetTopic(int Id)
{
dto_Topic model = null;
using (MySqlDataReader dr = MySqlHelper.ExecuteReader(Util.GetConnectString(BBSConnString),
"select Id, UserId, Invites, Title, TopicContent, TopicText, CreateDate, Good, Hit, ReplyCount, GradeId, SubjectId, Deleted, Blocked, Ip from T_Topic where Id = @Id",
"@Id".ToInt32InPara(Id)))
{
if (dr != null && dr.HasRows)
{
model = MySqlDBHelper.ConvertDataReaderToEntitySingle <dto_Topic>(dr);
}
}
return(model);
}
public static dto_Paper GetPaper(int paperId)
{
dto_Paper p = null;
using (MySqlDataReader dr = MySqlHelper.ExecuteReader(Util.GetConnectString(QuesConnString),
"select PaperId, CourseId, TypeId, GradeId, AreaId, PaperYear, Title, QIds from T_Paper where PaperId = @PaperId",
"@PaperId".ToInt32InPara(paperId)))
{
if (dr != null && dr.HasRows)
{
p = MySqlDBHelper.ConvertDataReaderToEntitySingle <dto_Paper>(dr);
}
}
return(p);
}
/// <summary>
/// 获取答案
/// </summary>
/// <param name="zyId"></param>
/// <param name="userId"></param>
/// <returns></returns>
public static T_Answer GetAnswer(int zyId, int userId)
{
T_Answer model = null;
using (MySqlDataReader dr = MySqlHelper.ExecuteReader(Util.GetConnectString(ZyConnString),
"select Id, ZyId, ZyType, StudentId, AnswerJson, AnswerImg, Submited, CreateDate from T_Answer where ZyId = @ZyId and StudentId = @StudentId",
"@ZyId".ToInt32InPara(zyId),
"@StudentId".ToInt32InPara(userId)))
{
if (dr != null && dr.HasRows)
{
model = MySqlDBHelper.ConvertDataReaderToEntitySingle <T_Answer>(dr);
}
}
return(model);
}
public static T_Answer GetZyAnswer(int zyId, string trueName)
{
T_Answer model = null;
using (MySqlDataReader dr = MySqlHelper.ExecuteReader(Util.GetConnectString(ZyConnString),
"select Id, ZyId, StudentId, TrueName, AnswerJson, AnswerImg, CreateDate, Ip, IMEI, MobileBrand, SystemType, Browser from T_Answer where ZyId = @ZyId and TrueName = @TrueName",
"@ZyId".ToInt32InPara(zyId),
"@TrueName".ToVarCharInPara(trueName)))
{
if (dr != null && dr.HasRows)
{
model = MySqlDBHelper.ConvertDataReaderToEntitySingle <T_Answer>(dr);
}
}
return(model);
}
