/// <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; }