/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(LearnSite.Model.QuizGrade model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update QuizGrade set ");
strSql.Append("Qobj=@Qobj,");
strSql.Append("Qclass=@Qclass,");
strSql.Append("Qhid=@Qhid,");
strSql.Append("Qonly=@Qonly,");
strSql.Append("Qmore=@Qmore,");
strSql.Append("Qjudge=@Qjudge,");
strSql.Append("Qopen=@Qopen,");
strSql.Append("Qanswer=@Qanswer");
strSql.Append(" where Qid=@Qid");
SqlParameter[] parameters =
{
new SqlParameter("@Qid", SqlDbType.Int, 4),
new SqlParameter("@Qobj", SqlDbType.Int, 4),
new SqlParameter("@Qclass", SqlDbType.NText),
new SqlParameter("@Qhid", SqlDbType.Int, 4),
new SqlParameter("@Qonly", SqlDbType.Int, 4),
new SqlParameter("@Qmore", SqlDbType.Int, 4),
new SqlParameter("@Qjudge", SqlDbType.Int, 4),
new SqlParameter("@Qopen", SqlDbType.Bit, 1),
new SqlParameter("@Qanswer", SqlDbType.Bit, 1)
};
parameters[0].Value = model.Qid;
parameters[1].Value = model.Qobj;
parameters[2].Value = model.Qclass;
parameters[3].Value = model.Qhid;
parameters[4].Value = model.Qonly;
parameters[5].Value = model.Qmore;
parameters[6].Value = model.Qjudge;
parameters[7].Value = model.Qopen;
parameters[8].Value = model.Qanswer;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(LearnSite.Model.QuizGrade model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into QuizGrade(");
strSql.Append("Qobj,Qclass,Qhid,Qonly,Qmore,Qjudge,Qopen,Qanswer)");
strSql.Append(" values (");
strSql.Append("@Qobj,@Qclass,@Qhid,@Qonly,@Qmore,@Qjudge,@Qopen,@Qanswer)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@Qobj", SqlDbType.Int, 4),
new SqlParameter("@Qclass", SqlDbType.NText),
new SqlParameter("@Qhid", SqlDbType.Int, 4),
new SqlParameter("@Qonly", SqlDbType.Int, 4),
new SqlParameter("@Qmore", SqlDbType.Int, 4),
new SqlParameter("@Qjudge", SqlDbType.Int, 4),
new SqlParameter("@Qopen", SqlDbType.Bit, 1),
new SqlParameter("@Qanswer", SqlDbType.Bit, 1)
};
parameters[0].Value = model.Qobj;
parameters[1].Value = model.Qclass;
parameters[2].Value = model.Qhid;
parameters[3].Value = model.Qonly;
parameters[4].Value = model.Qmore;
parameters[5].Value = model.Qjudge;
parameters[6].Value = model.Qopen;
parameters[7].Value = model.Qanswer;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 根据年级，班级得到一个对象实体
/// </summary>
public LearnSite.Model.QuizGrade GetModelByQobjRclass(int Qobj, int Rclass)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 Qid,Qobj,Qclass,Qhid,Qonly,Qmore,Qjudge,Qopen,Qanswer from QuizGrade,Room ");
strSql.Append(" where Qobj=@Qobj and Qhid=Rhid and Rgrade=Qobj and Rclass=@Rclass ");
SqlParameter[] parameters =
{
new SqlParameter("@Qobj", SqlDbType.Int, 4),
new SqlParameter("@Rclass", SqlDbType.Int, 4)
};
parameters[0].Value = Qobj;
parameters[1].Value = Rclass;
LearnSite.Model.QuizGrade model = new LearnSite.Model.QuizGrade();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["Qid"].ToString() != "")
{
model.Qid = int.Parse(ds.Tables[0].Rows[0]["Qid"].ToString());
}
if (ds.Tables[0].Rows[0]["Qobj"].ToString() != "")
{
model.Qobj = int.Parse(ds.Tables[0].Rows[0]["Qobj"].ToString());
}
model.Qclass = ds.Tables[0].Rows[0]["Qclass"].ToString();
if (ds.Tables[0].Rows[0]["Qhid"].ToString() != "")
{
model.Qhid = int.Parse(ds.Tables[0].Rows[0]["Qhid"].ToString());
}
if (ds.Tables[0].Rows[0]["Qonly"].ToString() != "")
{
model.Qonly = int.Parse(ds.Tables[0].Rows[0]["Qonly"].ToString());
}
if (ds.Tables[0].Rows[0]["Qmore"].ToString() != "")
{
model.Qmore = int.Parse(ds.Tables[0].Rows[0]["Qmore"].ToString());
}
if (ds.Tables[0].Rows[0]["Qjudge"].ToString() != "")
{
model.Qjudge = int.Parse(ds.Tables[0].Rows[0]["Qjudge"].ToString());
}
if (ds.Tables[0].Rows[0]["Qopen"].ToString() != "")
{
if ((ds.Tables[0].Rows[0]["Qopen"].ToString() == "1") || (ds.Tables[0].Rows[0]["Qopen"].ToString().ToLower() == "true"))
{
model.Qopen = true;
}
else
{
model.Qopen = false;
}
}
if (ds.Tables[0].Rows[0]["Qanswer"].ToString() != "")
{
if ((ds.Tables[0].Rows[0]["Qanswer"].ToString() == "1") || (ds.Tables[0].Rows[0]["Qanswer"].ToString().ToLower() == "true"))
{
model.Qanswer = true;
}
else
{
model.Qanswer = false;
}
}
return(model);
}
else
{
return(null);
}
}
