/// <summary>
/// 得到一个对象实体
/// </summary>
public OnLineTest.Model.Question GetModel(int QuestionId)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 QuestionId,QuestionTitle,AnswerA,AnswerB,AnswerC,AnswerD,CorrectAnswer,ImageAddress,DifficultyId,UserId,UpLoadTime,VerifyTimes,IsVerified,IsDelte,IsSupported,IsDeSupported,PaperCodeId,TextBookId,ChapterId,PastExamPaperId,PastExamQuestionId,Explain,Remark from Question ");
strSql.Append(" where QuestionId=@QuestionId");
SqlParameter[] parameters =
{
new SqlParameter("@QuestionId", SqlDbType.Int, 4)
};
parameters[0].Value = QuestionId;
OnLineTest.Model.Question model = new OnLineTest.Model.Question();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(OnLineTest.Model.Question model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Question(");
strSql.Append("QuestionTitle,AnswerA,AnswerB,AnswerC,AnswerD,CorrectAnswer,ImageAddress,DifficultyId,UserId,UpLoadTime,VerifyTimes,IsVerified,IsDelte,IsSupported,IsDeSupported,PaperCodeId,TextBookId,ChapterId,PastExamPaperId,PastExamQuestionId,Explain,Remark)");
strSql.Append(" values (");
strSql.Append("@QuestionTitle,@AnswerA,@AnswerB,@AnswerC,@AnswerD,@CorrectAnswer,@ImageAddress,@DifficultyId,@UserId,@UpLoadTime,@VerifyTimes,@IsVerified,@IsDelte,@IsSupported,@IsDeSupported,@PaperCodeId,@TextBookId,@ChapterId,@PastExamPaperId,@PastExamQuestionId,@Explain,@Remark)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@QuestionTitle", SqlDbType.Text),
new SqlParameter("@AnswerA", SqlDbType.Text),
new SqlParameter("@AnswerB", SqlDbType.Text),
new SqlParameter("@AnswerC", SqlDbType.Text),
new SqlParameter("@AnswerD", SqlDbType.Text),
new SqlParameter("@CorrectAnswer", SqlDbType.Int, 4),
new SqlParameter("@ImageAddress", SqlDbType.NVarChar, 100),
new SqlParameter("@DifficultyId", SqlDbType.Int, 4),
new SqlParameter("@UserId", SqlDbType.Int, 4),
new SqlParameter("@UpLoadTime", SqlDbType.DateTime),
new SqlParameter("@VerifyTimes", SqlDbType.Int, 4),
new SqlParameter("@IsVerified", SqlDbType.Bit, 1),
new SqlParameter("@IsDelte", SqlDbType.Bit, 1),
new SqlParameter("@IsSupported", SqlDbType.Int, 4),
new SqlParameter("@IsDeSupported", SqlDbType.Int, 4),
new SqlParameter("@PaperCodeId", SqlDbType.Int, 4),
new SqlParameter("@TextBookId", SqlDbType.Int, 4),
new SqlParameter("@ChapterId", SqlDbType.Int, 4),
new SqlParameter("@PastExamPaperId", SqlDbType.Int, 4),
new SqlParameter("@PastExamQuestionId", SqlDbType.Int, 4),
new SqlParameter("@Explain", SqlDbType.Text),
new SqlParameter("@Remark", SqlDbType.Text)
};
parameters[0].Value = model.QuestionTitle;
parameters[1].Value = model.AnswerA;
parameters[2].Value = model.AnswerB;
parameters[3].Value = model.AnswerC;
parameters[4].Value = model.AnswerD;
parameters[5].Value = model.CorrectAnswer;
parameters[6].Value = model.ImageAddress;
parameters[7].Value = model.DifficultyId;
parameters[8].Value = model.UserId;
parameters[9].Value = model.UpLoadTime;
parameters[10].Value = model.VerifyTimes;
parameters[11].Value = model.IsVerified;
parameters[12].Value = model.IsDelte;
parameters[13].Value = model.IsSupported;
parameters[14].Value = model.IsDeSupported;
parameters[15].Value = model.PaperCodeId;
parameters[16].Value = model.TextBookId;
parameters[17].Value = model.ChapterId;
parameters[18].Value = model.PastExamPaperId;
parameters[19].Value = model.PastExamQuestionId;
parameters[20].Value = model.Explain;
parameters[21].Value = model.Remark;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public OnLineTest.Model.Question DataRowToModel(DataRow row)
{
OnLineTest.Model.Question model = new OnLineTest.Model.Question();
if (row != null)
{
if (row["QuestionId"] != null && row["QuestionId"].ToString() != "")
{
model.QuestionId = int.Parse(row["QuestionId"].ToString());
}
if (row["QuestionTitle"] != null)
{
model.QuestionTitle = row["QuestionTitle"].ToString();
}
if (row["AnswerA"] != null)
{
model.AnswerA = row["AnswerA"].ToString();
}
if (row["AnswerB"] != null)
{
model.AnswerB = row["AnswerB"].ToString();
}
if (row["AnswerC"] != null)
{
model.AnswerC = row["AnswerC"].ToString();
}
if (row["AnswerD"] != null)
{
model.AnswerD = row["AnswerD"].ToString();
}
if (row["CorrectAnswer"] != null && row["CorrectAnswer"].ToString() != "")
{
model.CorrectAnswer = int.Parse(row["CorrectAnswer"].ToString());
}
if (row["ImageAddress"] != null)
{
model.ImageAddress = row["ImageAddress"].ToString();
}
if (row["DifficultyId"] != null && row["DifficultyId"].ToString() != "")
{
model.DifficultyId = int.Parse(row["DifficultyId"].ToString());
}
if (row["UserId"] != null && row["UserId"].ToString() != "")
{
model.UserId = int.Parse(row["UserId"].ToString());
}
if (row["UpLoadTime"] != null && row["UpLoadTime"].ToString() != "")
{
model.UpLoadTime = DateTime.Parse(row["UpLoadTime"].ToString());
}
if (row["VerifyTimes"] != null && row["VerifyTimes"].ToString() != "")
{
model.VerifyTimes = int.Parse(row["VerifyTimes"].ToString());
}
if (row["IsVerified"] != null && row["IsVerified"].ToString() != "")
{
if ((row["IsVerified"].ToString() == "1") || (row["IsVerified"].ToString().ToLower() == "true"))
{
model.IsVerified = true;
}
else
{
model.IsVerified = false;
}
}
if (row["IsDelte"] != null && row["IsDelte"].ToString() != "")
{
if ((row["IsDelte"].ToString() == "1") || (row["IsDelte"].ToString().ToLower() == "true"))
{
model.IsDelte = true;
}
else
{
model.IsDelte = false;
}
}
if (row["IsSupported"] != null && row["IsSupported"].ToString() != "")
{
model.IsSupported = int.Parse(row["IsSupported"].ToString());
}
if (row["IsDeSupported"] != null && row["IsDeSupported"].ToString() != "")
{
model.IsDeSupported = int.Parse(row["IsDeSupported"].ToString());
}
if (row["PaperCodeId"] != null && row["PaperCodeId"].ToString() != "")
{
model.PaperCodeId = int.Parse(row["PaperCodeId"].ToString());
}
if (row["TextBookId"] != null && row["TextBookId"].ToString() != "")
{
model.TextBookId = int.Parse(row["TextBookId"].ToString());
}
if (row["ChapterId"] != null && row["ChapterId"].ToString() != "")
{
model.ChapterId = int.Parse(row["ChapterId"].ToString());
}
if (row["PastExamPaperId"] != null && row["PastExamPaperId"].ToString() != "")
{
model.PastExamPaperId = int.Parse(row["PastExamPaperId"].ToString());
}
if (row["PastExamQuestionId"] != null && row["PastExamQuestionId"].ToString() != "")
{
model.PastExamQuestionId = int.Parse(row["PastExamQuestionId"].ToString());
}
if (row["Explain"] != null)
{
model.Explain = row["Explain"].ToString();
}
if (row["Remark"] != null)
{
model.Remark = row["Remark"].ToString();
}
}
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(OnLineTest.Model.Question model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update Question set ");
strSql.Append("QuestionTitle=@QuestionTitle,");
strSql.Append("AnswerA=@AnswerA,");
strSql.Append("AnswerB=@AnswerB,");
strSql.Append("AnswerC=@AnswerC,");
strSql.Append("AnswerD=@AnswerD,");
strSql.Append("CorrectAnswer=@CorrectAnswer,");
strSql.Append("ImageAddress=@ImageAddress,");
strSql.Append("DifficultyId=@DifficultyId,");
strSql.Append("UserId=@UserId,");
strSql.Append("UpLoadTime=@UpLoadTime,");
strSql.Append("VerifyTimes=@VerifyTimes,");
strSql.Append("IsVerified=@IsVerified,");
strSql.Append("IsDelte=@IsDelte,");
strSql.Append("IsSupported=@IsSupported,");
strSql.Append("IsDeSupported=@IsDeSupported,");
strSql.Append("PaperCodeId=@PaperCodeId,");
strSql.Append("TextBookId=@TextBookId,");
strSql.Append("ChapterId=@ChapterId,");
strSql.Append("PastExamPaperId=@PastExamPaperId,");
strSql.Append("PastExamQuestionId=@PastExamQuestionId");
strSql.Append("Explain=@Explain");
strSql.Append("Remark=@Remark");
strSql.Append(" where QuestionId=@QuestionId");
SqlParameter[] parameters =
{
new SqlParameter("@QuestionTitle", SqlDbType.Text),
new SqlParameter("@AnswerA", SqlDbType.Text),
new SqlParameter("@AnswerB", SqlDbType.Text),
new SqlParameter("@AnswerC", SqlDbType.Text),
new SqlParameter("@AnswerD", SqlDbType.Text),
new SqlParameter("@CorrectAnswer", SqlDbType.Int, 4),
new SqlParameter("@ImageAddress", SqlDbType.NVarChar, 100),
new SqlParameter("@DifficultyId", SqlDbType.Int, 4),
new SqlParameter("@UserId", SqlDbType.Int, 4),
new SqlParameter("@UpLoadTime", SqlDbType.DateTime),
new SqlParameter("@VerifyTimes", SqlDbType.Int, 4),
new SqlParameter("@IsVerified", SqlDbType.Bit, 1),
new SqlParameter("@IsDelte", SqlDbType.Bit, 1),
new SqlParameter("@IsSupported", SqlDbType.Int, 4),
new SqlParameter("@IsDeSupported", SqlDbType.Int, 4),
new SqlParameter("@PaperCodeId", SqlDbType.Int, 4),
new SqlParameter("@TextBookId", SqlDbType.Int, 4),
new SqlParameter("@ChapterId", SqlDbType.Int, 4),
new SqlParameter("@PastExamPaperId", SqlDbType.Int, 4),
new SqlParameter("@PastExamQuestionId", SqlDbType.Int, 4),
new SqlParameter("@QuestionId", SqlDbType.Int, 4),
new SqlParameter("@Explain", SqlDbType.Text),
new SqlParameter("@Remark", SqlDbType.Text)
};
parameters[0].Value = model.QuestionTitle;
parameters[1].Value = model.AnswerA;
parameters[2].Value = model.AnswerB;
parameters[3].Value = model.AnswerC;
parameters[4].Value = model.AnswerD;
parameters[5].Value = model.CorrectAnswer;
parameters[6].Value = model.ImageAddress;
parameters[7].Value = model.DifficultyId;
parameters[8].Value = model.UserId;
parameters[9].Value = model.UpLoadTime;
parameters[10].Value = model.VerifyTimes;
parameters[11].Value = model.IsVerified;
parameters[12].Value = model.IsDelte;
parameters[13].Value = model.IsSupported;
parameters[14].Value = model.IsDeSupported;
parameters[15].Value = model.PaperCodeId;
parameters[16].Value = model.TextBookId;
parameters[17].Value = model.ChapterId;
parameters[18].Value = model.PastExamPaperId;
parameters[19].Value = model.PastExamQuestionId;
parameters[20].Value = model.QuestionId;
parameters[21].Value = model.Explain;
parameters[22].Value = model.Remark;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
