//[HttpPost]
//[ActionName("real")]
public ActionResult Real()
{
string UserName = string.Empty;
if (Request.Cookies["userName"] != null)
{
UserName = Server.HtmlEncode(Request.Cookies["userName"].Value);
}
if (string.IsNullOrEmpty(UserName))
{
return(RedirectToAction("Index", "login", new { ReturnCtrl = "answer", ReturnAction = "Real" }));
}
pid = Process.GetCurrentProcess().Id; //线程id
//当前用户今天答了几次题
string sql_par = " user_id = '" + UserName + "' and q_dt = '" + strdt + "'";
qdseq = DbHelperSQL.GetMaxID("q_seq", "u_question_hst_log", sql_par); //需要修改成历史表 测试时是log表
//读取配置文件 1.总题目数量
string sql_totcnt = "select config from b_minor where major_cd = 'A3' and minor_cd = 'S'";
QAcnt = int.Parse(DbHelperSQL.GetSingle(sql_totcnt).ToString()); //题目总数
ViewData["username"] = UserName;
ViewData["qdseq"] = qdseq; //今天第几次答题
//封装随机抽取的N道题
DataSet ask_temp_Data_hd = new DataSet();
StringBuilder sb = new StringBuilder();
sb.Append("EXEC usp_real_question_by_user ");
sb.Append("@user = "******"pid"].ToString());
QATBHdr.Sqid = int.Parse(ask_temp_Data_hd.Tables[0].Rows[i]["q_id"].ToString());
QATBHdr.Sqseq = int.Parse(ask_temp_Data_hd.Tables[0].Rows[i]["q_seq"].ToString());
QATBHdr.q_nm = ask_temp_Data_hd.Tables[0].Rows[i]["q_nm"].ToString();
QATBHdr.q_key = ask_temp_Data_hd.Tables[0].Rows[i]["q_key"].ToString();
QATBHdr.q_type = ask_temp_Data_hd.Tables[0].Rows[i]["q_type"].ToString();
QATBHdr.q_rmk = ask_temp_Data_hd.Tables[0].Rows[i]["q_rmk"].ToString();
LQATBHdr.Add(QATBHdr);
}
Session["pidlist"] = LQATBHdr;//封装到session中
return(View()); //view中 开始答题时 默认从第一题 seq = 0开始
}
private void Ahdrexec(List <QAskTempByPidHdr> lQATBHdr, int AskSeq, string chk, string UserName, string end_flag)
{
QAskTempByPidHdr qAskTempByPidHdr = new QAskTempByPidHdr();
foreach (QAskTempByPidHdr s in lQATBHdr)
{
if (s.Sqseq == AskSeq)
{
StringBuilder Ahdrexec = new StringBuilder();
Ahdrexec.Append("insert into u_question_hst_log " +
"( pid, user_id, q_dt, q_seq, q_sub_seq, q_id, k_val, q_rmk, isrt_dt) VALUES ( ");
Ahdrexec.Append("'").Append(s.Spid).Append("',");
Ahdrexec.Append("'").Append(UserName).Append("',");
Ahdrexec.Append("'").Append(strdt).Append("',");
Ahdrexec.Append("'").Append(qdseq).Append("',");
Ahdrexec.Append("'").Append(AskSeq).Append("',");
Ahdrexec.Append("'").Append(s.Sqid).Append("',");
Ahdrexec.Append("'").Append(chk).Append("',");
Ahdrexec.Append("'").Append(s.q_rmk).Append("',");
Ahdrexec.Append("'").Append(strdt).Append("')");
int trn = DbHelperSQL.ExecuteSql(Ahdrexec.ToString());
if (trn == 0)
{
Content("Error Ahdrexec");
}
}
if (end_flag == "Y")
{
StringBuilder Ahdrexec1 = new StringBuilder();
Ahdrexec1.Append("insert into u_question_hst " +
"( user_id, q_dt, q_seq, q_sub_seq, q_id, k_val, isrt_dt) VALUES ( ");
Ahdrexec1.Append("'").Append(UserName).Append("',");
Ahdrexec1.Append("'").Append(strdt).Append("',");
Ahdrexec1.Append("'").Append(qdseq).Append("',");
Ahdrexec1.Append("'").Append(AskSeq).Append("',");
Ahdrexec1.Append("'").Append(s.Sqid).Append("',");
Ahdrexec1.Append("'").Append(chk).Append("',");
Ahdrexec1.Append("'").Append(strdt).Append("')");
int trn = DbHelperSQL.ExecuteSql(Ahdrexec1.ToString());
if (trn == 0)
{
Content("Error Ahdrexec");
}
}
}
}
