protected void UpdateTrainingResult(enum_TraningResult result) { string strCodeStr = GetEnumTrainingResultCodeStr(result); string strTrainingResult = lblTrainingResult.Text; int MaxLen_TrainingResult = Convert.ToInt32(ConfigurationManager.AppSettings["MaxLenTrainingResult"]);; if (strTrainingResult.Length < MaxLen_TrainingResult) { strTrainingResult = strTrainingResult + strCodeStr; } else { strTrainingResult = strTrainingResult.Substring(1); //去掉左起第一个字 strTrainingResult = strTrainingResult + strCodeStr; } string connectionStr; connectionStr = ConfigurationManager.ConnectionStrings["worddbConnectionString"].ConnectionString; MySqlConnection conn = new MySqlConnection(connectionStr); try { conn.Open(); string sql = "UPDATE wordstudyhistory SET trainingresult = '" + strTrainingResult + "' WHERE UnitScheduleId = " + Session["SelectedScheduleID"].ToString() + " AND WordId =" + lblWordId.Text; MySqlCommand cmd = new MySqlCommand(sql, conn); cmd.ExecuteNonQuery(); int TimeUsedBefore = 0; string sqlTimeUsedBefore = "SELECT timeused FROM unitstudyschedule WHERE id =" + Session["SelectedScheduleID"].ToString(); MySqlCommand cmdTimeUsedBefore = new MySqlCommand(sqlTimeUsedBefore, conn); MySqlDataReader rdr = cmdTimeUsedBefore.ExecuteReader(); while (rdr.Read()) { TimeUsedBefore = Int32.Parse(rdr.IsDBNull(0) ? "0" : rdr[0].ToString()); } rdr.Close(); TimeUsedBefore = TimeUsedBefore + GetTimeUsedOfCurrentWord(); string sqlUpdateTimeSpend = "UPDATE unitstudyschedule SET TimeUsed ='" + TimeUsedBefore.ToString() + "' WHERE id = " + Session["SelectedScheduleID"].ToString(); MySqlCommand cmdUpdateTimeSpend = new MySqlCommand(sqlUpdateTimeSpend, conn); cmdUpdateTimeSpend.ExecuteNonQuery(); //conn.Close(); } catch (Exception ex) { //Console.WriteLine(ex.ToString()); } finally { conn.Close(); } lblTrainingResult.Text = strTrainingResult; }
protected string GetEnumTrainingResultCodeStr(enum_TraningResult result) { string strTempCodeStr = ""; if (result == enum_TraningResult.Wrong) { strTempCodeStr = "0"; } else if (result == enum_TraningResult.Correct) { strTempCodeStr = "1"; } else if (result == enum_TraningResult.WithHint) { strTempCodeStr = "2"; } else if (result == enum_TraningResult.QuickCorrect) { strTempCodeStr = "3"; } return(strTempCodeStr); }