//[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"); } } } }