protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { M_Design_Answer ansMod = ansBll.SelReturnModel(AnsID); M_Design_Ask askMod = askBll.SelReturnModel(ansMod.AskID); Call.SetBreadCrumb(Master, "<li><a href='" + customPath2 + "Main.aspx'>工作台</a></li><li><a href='Default.aspx'>动力模块</a></li><li><a href='AnsList.aspx?AskID=" + ansMod.AskID + "'>回答列表</a></li><li class='active'>" + askMod.Title + "</li>"); MyBind(); } }
//------------- //检测问卷可否被提交 private bool CheckAsk(M_Design_Ask askMod, ref string err) { string ip = IPScaner.GetUserIP(HttpContext); if (askMod == null) { err = "问卷不存在"; return(false); } if (askMod.IsNeedLogin == 1 && mu.IsNull) { err = "[" + askMod.Title + "]必须登录后才可访问"; return(false); } if (askMod.ZStatus != (int)ZLEnum.ConStatus.Audited) { err = "[" + askMod.Title + "]未开放"; return(false); } if (askMod.StartDate >= DateTime.Now) { err = "[" + askMod.Title + "]尚未到开放时间"; return(false); } if (askMod.EndDate <= DateTime.Now) { err = "[" + askMod.Title + "]已经结束"; return(false); } if (askMod.IsIPLimit > 0) { //if (ip.StartsWith("192.168") || ip.Equals("::1")) { } List <SqlParameter> sp = new List <SqlParameter>() { new SqlParameter("ip", ip), new SqlParameter("sdate", DateTime.Now.ToString("yyyy/MM/dd 00:00:00")), new SqlParameter("edate", DateTime.Now.ToString("yyyy/MM/dd 23:59:59")) }; int count = DBCenter.Count(ansBll.TbName, "IP=@ip AND AskID=" + askMod.ID + " AND (CDate>@sdate AND CDate<@edate)", sp); if (count >= askMod.IsIPLimit) { err = "系统限定:一天只能提交" + askMod.IsIPLimit + "份,请明天再来"; return(false); } } if (askMod.IPInterval > 0) { //取最近的一条记录 M_Design_Answer ansMod = ansBll.SelModelByIP(ip); if (ansMod == null || (DateTime.Now - ansMod.CDate).TotalSeconds > askMod.IPInterval) { } else { err = "系统限定:每隔" + DateHelper.ShowSeconds(askMod.IPInterval) + "才可再次提交"; return(false); } } return(true); }
public string ResultAdd_Submit() { if (!AdminCheck()) { return("无权访问"); } int ansnum = DataConvert.CLng(GetParam("ansnum")); if (ansnum < 1) { return("投票人数不正确"); } //[后期改为附加虚拟值的方式] M_Design_Ask askMod = askBll.SelReturnModel(Mid); if (askMod == null) { return("问卷不存在"); } //-------------------------------- M_Design_Answer ansMod = new M_Design_Answer(); ansMod.AskID = askMod.ID; //ansMod.Answer = Req("answer");//{qid:1,answer:'is answer'} ansMod.Answer = GetParam("answer"); ansMod.UserID = -1; ansMod.IP = IPScaner.GetUserIP(HttpContext); ansMod.Source = "管理员添加"; for (int i = 0; i < ansnum; i++) { ansMod.ID = 0; ansMod.ID = ansBll.Insert(ansMod); //-----------单独写入表中,便于后期分析(后期优化为批量插入) List <M_SubOption> ansList = JsonConvert.DeserializeObject <List <M_SubOption> >(GetParam("answer")); foreach (M_SubOption ans in ansList) { M_Design_AnsDetail ansdeMod = new M_Design_AnsDetail(); ansdeMod.AskID = ansMod.AskID; ansdeMod.AnsID = ansMod.ID; ansdeMod.Qid = ans.qid; ansdeMod.Answer = ans.answer; ansdeMod.UserID = ansMod.UserID; ansdeBll.Insert(ansdeMod); } } return(Success.ToString()); }
public string Vote_Submit() { M_Design_Ask askMod = askBll.SelReturnModel(Mid); if (askMod == null) { return("问卷不存在"); } if (askMod.IsEnableVCode == 1) { if (!ZoomlaSecurityCenter.VCodeCheck(GetParam("vkey"), GetParam("vcode"))) { return("验证码不正确"); } } if (!CheckAsk(askMod, ref err)) { return(err); } M_Design_Answer ansMod = new M_Design_Answer(); ansMod.AskID = askMod.ID; //ansMod.Answer = Req("answer");//{qid:1,answer:'is answer'} ansMod.Answer = GetParam("answer"); ansMod.UserID = mu.UserID; ansMod.IP = IPScaner.GetUserIP(HttpContext); //ansMod.Source = DeviceHelper.GetBrower().ToString(); ansMod.ID = ansBll.Insert(ansMod); //-----------单独写入表中,便于后期分析(后期优化为批量插入) List <M_SubOption> ansList = JsonConvert.DeserializeObject <List <M_SubOption> >(GetParam("answer")); foreach (M_SubOption ans in ansList) { M_Design_AnsDetail ansdeMod = new M_Design_AnsDetail(); ansdeMod.AskID = ansMod.AskID; ansdeMod.AnsID = ansMod.ID; ansdeMod.Qid = ans.qid; ansdeMod.Answer = ans.answer; ansdeMod.UserID = ansMod.UserID; ansdeBll.Insert(ansdeMod); } return(Success.ToString()); }
//用户的回答 public IActionResult ShowAnswer() { if (!AdminCheck()) { return(null); } M_Design_Ask askMod = askBll.SelReturnModel(Mid); M_Design_Answer ansMod = ansBll.SelReturnModel(DataConvert.CLng(GetParam("ansid"))); DataTable questDT = questBll.Sel(askMod.ID, "qlist"); ViewBag.questDT = questDT; ViewBag.Mode = "answer"; ViewBag.ansMod = ansMod; if (ansMod == null) { return(WriteErr("传入的参数不正确")); } return(View("Index", askMod)); }
public int Insert(M_Design_Answer model) { return(DBCenter.Insert(model)); }
public bool UpdateByID(M_Design_Answer model) { return(DBCenter.UpdateByID(model, model.ID)); }
public void ProcessRequest(HttpContext context) { M_UserInfo mu = buser.GetLogin(); retMod.retcode = M_APIResult.Failed; try { switch (Action) { case "submit": { M_Design_Answer ansMod = new M_Design_Answer(); ansMod.AskID = Convert.ToInt32(Req("askid")); //ansMod.Answer = Req("answer");//{qid:1,answer:'is answer'} ansMod.Answer = Req("answer"); ansMod.UserID = mu.UserID; ansMod.IP = IPScaner.GetUserIP(); ansMod.Source = DeviceHelper.GetBrower().ToString(); ansMod.ID = ansBll.Insert(ansMod); //-----------单独写入表中,便于后期分析(后期优化为批量插入) List <M_SubOption> ansList = JsonConvert.DeserializeObject <List <M_SubOption> >(Req("answer")); foreach (M_SubOption ans in ansList) { M_Design_AnsDetail ansdeMod = new M_Design_AnsDetail(); ansdeMod.AskID = ansMod.AskID; ansdeMod.AnsID = ansMod.ID; ansdeMod.Qid = ans.qid; ansdeMod.Answer = ans.answer; ansdeMod.UserID = ansMod.UserID; ansdeBll.Insert(ansdeMod); } retMod.retcode = M_APIResult.Success; retMod.result = ansMod.ID.ToString(); } break; case "list": { DataTable dt = ansBll.Sel(mu.UserID, -100); retMod.retcode = M_APIResult.Success; retMod.result = JsonConvert.SerializeObject(dt); } break; case "listbyqid": //仅用于查看详情 { int qid = Convert.ToInt32(Req("qid")); DataTable dt = ansdeBll.Sel(qid.ToString()); retMod.retcode = M_APIResult.Success; retMod.result = JsonConvert.SerializeObject(dt); } break; default: retMod.retmsg = "[" + Action + "]接口不存在"; break; } } catch (Exception ex) { retMod.retmsg = ex.Message; } RepToClient(retMod); }