public IActionResult ShiTiShunXuNext(int shiJuanId, string shiJuanName, long shiTiId, int daTiType) { IShiTi shiTi = new ShiTi(); ShiTiNumEntity shiTiNumEntity = shiTi.GetShiTiNum(shiJuanId); ShiTiEntity shiTiEntity = shiTi.GetNextShiTiByShiJuanIdAndCurrentIdOld(shiJuanId, shiTiId, daTiType); ViewBag.ShiTi = shiTiEntity; ViewBag.shiJuanId = shiJuanId; ViewBag.shiJuanName = shiJuanName; string myDaAn = string.Empty; if (this.ControllerContext.HttpContext.Request.Cookies.ContainsKey("DaTi")) { string strCookie = this.ControllerContext.HttpContext.Request.Cookies["DaTi"]; List <DaTiCookieEntity> listDaTiCookie = JsonHelper.DeserializeJsonToList <DaTiCookieEntity>(strCookie); List <DaTiCookieEntity> listDaTiCookieExist = listDaTiCookie.Where(i => i.daTiType == daTiType && i.shiJuanId == shiJuanId && i.shiTiId == shiTiEntity.id).ToList(); if (listDaTiCookieExist != null && listDaTiCookieExist.Count > 0) { myDaAn = listDaTiCookieExist[0].myDaAn; } } ViewBag.myDaAn = myDaAn; ViewBag.shiTiNumEntity = shiTiNumEntity; ViewBag.daTiType = daTiType; string viewName = "ShiTiShunXu"; if (shiTiEntity.tiXing == "单选题") { viewName = "ShiTiShunXu_DanXuan"; } else if (shiTiEntity.tiXing == "多选题") { viewName = "ShiTiShunXu_DuoXuan"; } else if (shiTiEntity.tiXing == "判断题") { viewName = "ShiTiShunXu_PanDuan"; } else if (shiTiEntity.tiXing == "简答题") { viewName = "ShiTiShunXu_JianDa"; } else { viewName = "ShiTiShunXu"; } //shiTiEntity.xuanXiang=shiTiEntity.xuanXiang.Replace(" b","<br/>b"); //shiTiEntity.xuanXiang = shiTiEntity.xuanXiang.Replace(" B", "<br/>B"); //shiTiEntity.xuanXiang = shiTiEntity.xuanXiang.Replace(" c", "<br/>c"); //shiTiEntity.xuanXiang = shiTiEntity.xuanXiang.Replace(" C", "<br/>C"); //shiTiEntity.xuanXiang = shiTiEntity.xuanXiang.Replace(" d", "<br/>d"); //shiTiEntity.xuanXiang = shiTiEntity.xuanXiang.Replace(" D", "<br/>D"); return(View(viewName)); }
public ShiTiNumEntity GetShiTiNum(int shiJuanId) { ShiTiNumEntity shiTiNumEntity = new ShiTiNumEntity(); string sql = string.Format(@" select count(1) rowCount,max(id) maxShiTiId,min(id) minShiTiId from shi_ti where is_deleted=0 and shi_juan_id={0}", shiJuanId); DataTable dtShiTiNum = MySqlHelper.ExecuteTable(sql); if (dtShiTiNum != null && dtShiTiNum.Rows.Count > 0) { DataRow dr = dtShiTiNum.Rows[0]; shiTiNumEntity.rowCount = dr["rowCount"] == DBNull.Value?0:Convert.ToInt32(dr["rowCount"].ToString()); shiTiNumEntity.maxShiTiId = dr["maxShiTiId"] == DBNull.Value ? 0 : Convert.ToInt32(dr["maxShiTiId"].ToString()); shiTiNumEntity.minShiTiId = dr["minShiTiId"] == DBNull.Value ? 0 : Convert.ToInt32(dr["minShiTiId"].ToString()); } else { return(null); } return(shiTiNumEntity); }
public IActionResult ShiTiSuiJiGoTo(int shiJuanId, string shiJuanName, long goToShiTiId, int daTiType) { IShiTi shiTi = new ShiTi(); ShiTiNumEntity shiTiNumEntity = shiTi.GetShiTiNum(shiJuanId); ShiTiEntity shiTiEntity = shiTi.GetGoToShiTiByShiJuanIdAndCurrentIdOld(shiJuanId, goToShiTiId); ViewBag.ShiTi = shiTiEntity; ViewBag.shiJuanId = shiJuanId; ViewBag.shiJuanName = shiJuanName; string myDaAn = string.Empty; string doShiTiIdsString = string.Empty;//已答试题编号"1,2" if (this.ControllerContext.HttpContext.Request.Cookies.ContainsKey("DaTi")) { string strCookie = this.ControllerContext.HttpContext.Request.Cookies["DaTi"]; List <DaTiCookieEntity> listDaTiCookie = JsonHelper.DeserializeJsonToList <DaTiCookieEntity>(strCookie); List <DaTiCookieEntity> listDaTiCookieExistThisType = listDaTiCookie.Where(i => i.daTiType == daTiType && i.shiJuanId == shiJuanId).ToList(); if (listDaTiCookieExistThisType != null && listDaTiCookieExistThisType.Count > 0) { foreach (DaTiCookieEntity daTi in listDaTiCookieExistThisType) { doShiTiIdsString += daTi.shiTiId.ToString() + ","; } } List <DaTiCookieEntity> listDaTiCookieExist = listDaTiCookie.Where(i => i.daTiType == daTiType && i.shiJuanId == shiJuanId && i.shiTiId == shiTiEntity.id).ToList(); if (listDaTiCookieExist != null && listDaTiCookieExist.Count > 0) { myDaAn = listDaTiCookieExist[0].myDaAn; } } if (doShiTiIdsString.Length > 0) { doShiTiIdsString = doShiTiIdsString.Substring(0, doShiTiIdsString.Length - 1); } ViewBag.myDaAn = myDaAn; ViewBag.shiTiNumEntity = shiTiNumEntity; ViewBag.daTiType = daTiType; ViewBag.doShiTiIdsString = doShiTiIdsString; string viewName = "ShiTiSuiJi"; if (shiTiEntity.tiXing == "单选题") { viewName = "ShiTiSuiJi_DanXuan"; } else if (shiTiEntity.tiXing == "多选题") { viewName = "ShiTiSuiJi_DuoXuan"; } else if (shiTiEntity.tiXing == "判断题") { viewName = "ShiTiSuiJi_PanDuan"; } else if (shiTiEntity.tiXing == "简答题") { viewName = "ShiTiSuiJi_JianDa"; } else { viewName = "ShiTiSuiJi"; } return(View(viewName)); }