/// <summary>
/// 载入学生详情
/// </summary>
/// <param name="sname"></param>
/// <param name="hno"></param>
public void LoadDetail(Hmwk hmwk)
{
mHmwk = hmwk;
Sno.Text = mHmwk.Sno;
Sname.Text = mHmwk.Sname;
Hno.Text = mHmwk.Hno;
Score.Text = mHmwk.Score >= 0 ? mHmwk.Score.ToString() : "暂未打分";
TextScore.Text = "";
}
/// <summary>
/// 置分数
/// </summary>
public static void SetScore(Hmwk h, int score)
{
if (dbPath == null)
{
throw new FileNotFoundException("不存在DB文件sqlite.db！");
}
Log.D("DBOptionHelper.SetScore: start.");
int oldScore = h.Score; //旧分数
if (oldScore < 0)
{
Log.D("DBOptionHelper.SetScore: score info not exist, creating...");
SqLiteHelper.ExecuteQuery(dbPath, string.Format("INSERT INTO {0} VALUES ('{1}', '{2}', '{3}', '{4}')",
"score", h.Sno, h.Hno, 0, score));
}
else
{
Log.D("DBOptionHelper.SetScore: score info exist, updating...");
SqLiteHelper.ExecuteQuery(dbPath, string.Format("UPDATE score SET score={0} WHERE sno='{1}' AND hno='{2}'",
score.ToString(), h.Sno, h.Hno));
}
}
//----------------------------功能操作----------------------------
public void LoadHmwk(Hmwk hmwk)
{
mHmwk = hmwk;
}
