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