protected void Page_Load(object sender, EventArgs e) { this.surveyId = BasePage.RequestInt32("SurveyID"); if (!base.IsPostBack) { if (this.surveyId == 0) { AdminPage.WriteErrMsg("<li>请指定问卷ID</li>", "SurveyManage.aspx"); } else if (!SurveyManager.SurveyIdOfPassedExists(this.surveyId)) { AdminPage.WriteErrMsg("<li>该问卷未启用,不能查看报表!</li>"); } else { SurveyInfo surveyById = SurveyManager.GetSurveyById(this.surveyId); if (!surveyById.IsNull) { this.LblSurveyName.Text = surveyById.SurveyName; this.LblDescription.Text = surveyById.Description; this.LblTitle.Text = "[" + surveyById.SurveyName + "]问卷报表"; this.LblSurveyNumber.Text = SurveyRecord.GetTotalOfSurveyRecord(this.surveyId).ToString(); this.LblDate.Text = surveyById.CreateDate.ToString() + "/" + surveyById.EndTime.ToString(); } else { AdminPage.WriteErrMsg("<li>未找到对应的问卷信息</li>"); } } this.BtnReport.Attributes.Add("onclick", "javascript:window.print();return false;"); } }
protected void BtnDelete_Click(object sender, EventArgs e) { if (SurveyRecord.Delete(this.m_RecordId.ToString(), this.m_SurveyId)) { AdminPage.WriteSuccessMsg("删除记录成功", "ShowCountData3.aspx?SurveyID=" + this.m_SurveyId); } else { AdminPage.WriteErrMsg("<li>删除记录失败</li>"); } }
public ActionResult Create(SurveyTemplate surveytemplate, FormCollection formcollection) { if (ModelState.IsValid) { db.SurveyTemplates.Add(surveytemplate); surveytemplate.PreDefined = true; db.SaveChanges(); surveytemplate.SurveyRecords = new List <SurveyRecord>(); int xindex = 0; foreach (SurveyNode snode_ in db.SurveyNodes.ToList()) { try { if (bool.Parse(formcollection[snode_.SurveyNodeID.ToString() + "_Check"].Split(',')[0])) { SurveyRecord newsurvrec = new SurveyRecord { SurveyNodeID = snode_.SurveyNodeID, OrderNum = xindex, SurveyRecordTypeID = int.Parse(formcollection[snode_.SurveyNodeID.ToString() + "_survrectype"]) }; surveytemplate.SurveyRecords.Add(newsurvrec); db.SaveChanges(); xindex++; } } catch (Exception exx) { ViewBag.CustomErr = exx.Message; } } return(RedirectToAction("Index")); } ViewBag.AllSurveyNodes = db.SurveyNodes.ToList(); var query = db.RequestTypes.Where(u => db.SurveyTemplates.Where(i => i.PreDefined == true).Select(s => s.RequestTypeID).Contains(u.RequestTypeID)); var emptyReqTypes = db.RequestTypes.Except(query); ViewBag.RequestTypeID = new SelectList(emptyReqTypes, "RequestTypeID", "Description", surveytemplate.RequestTypeID); return(View(surveytemplate)); }
private void BindData() { this.RptAnswerList.DataSource = SurveyRecord.GetQuestionAnswer(this.surveyId, "Q" + this.questionId.ToString()); this.RptAnswerList.DataBind(); }
public async Task <ActionResult <SurveyRecord> > AddAsync([FromBody] SurveyRecord surveyRecord) { var item = await _surveyRecordService.AddAsync(surveyRecord); return(CreatedAtAction(nameof(GetByIdAsync), new { id = item.Id }, item)); }
private void BindData() { this.RptAnswerList.DataSource = SurveyRecord.GetList((this.Pager.CurrentPageIndex - 1) * this.Pager.PageSize, this.Pager.PageSize, this.surveyId, 0); this.RptAnswerList.DataBind(); this.Pager.RecordCount = SurveyRecord.GetTotalOfSurveyRecord(); }
private void SaveSurveyRecord(int surveyId) { if (surveyId == 0) { DynamicPage.WriteErrMsg("问卷调查ID错误!"); } else { SurveyInfo surveyById = SurveyManager.GetSurveyById(surveyId); if (surveyById.IsOpen != 1) { DynamicPage.WriteErrMsg("问卷调查尚未启用!!!"); } if (surveyById.EndTime != null)//.HasValue) { DateTime?endTime = surveyById.EndTime; DateTime now = DateTime.Now; if (endTime.HasValue ? (endTime.GetValueOrDefault() < now) : false) { DynamicPage.WriteErrMsg("问卷调查已经结束!!!"); } } if (!SurveyManager.CheckLockUrl(base.Request.ServerVariables["HTTP_REFERER"], surveyById)) { DynamicPage.WriteErrMsg("不允许从外部链接地址提交!!!"); } if (SurveyManager.CheckRepeatIP(PEContext.Current.UserHostAddress, surveyId, surveyById)) { DynamicPage.WriteErrMsg("同一用户不允许填写问卷调查超过" + surveyById.IPRepeat.ToString() + "次!!!"); } if (!string.IsNullOrEmpty(surveyById.SetPassword) && (surveyById.SetPassword != base.Request.Form["SurveyPassword"].ToString())) { DynamicPage.WriteErrMsg("问卷密码错误!!!"); } if (SurveyManager.CheckIPLock(PEContext.Current.UserHostAddress, surveyById)) { DynamicPage.WriteErrMsg("对不起!您的IP(" + PEContext.Current.UserHostAddress + ")被系统限定,您可以和站长联系。"); } if (surveyById.NeedLogin == 1) { if (PEContext.Current.User.Identity.IsAuthenticated) { if (surveyById.PresentPoint != 0) { int userId = PEContext.Current.User.UserInfo.UserId; Users.Update(userId, "UserPoint", (PEContext.Current.User.UserInfo.UserPoint + surveyById.PresentPoint).ToString()); UserPointLogInfo userPointLogInfo = new UserPointLogInfo(); userPointLogInfo.IncomePayOut = 1; userPointLogInfo.InfoId = 0; userPointLogInfo.Inputer = "System"; userPointLogInfo.IP = PEContext.Current.UserHostAddress; userPointLogInfo.LogId = UserPointLog.GetTotalInComeAndPayOutAll().Count; userPointLogInfo.LogTime = DateTime.Now; userPointLogInfo.Memo = ""; userPointLogInfo.ModuleType = 9; userPointLogInfo.Point = surveyById.PresentPoint; userPointLogInfo.Remark = "参与“" + surveyById.SurveyName + "”--问卷调查获得奖励点数"; userPointLogInfo.Times = 1; userPointLogInfo.UserName = PEContext.Current.User.UserInfo.UserName; UserPointLog.Add(userPointLogInfo); } } else { string absoluteUri = HttpContext.Current.Request.Url.AbsoluteUri; BasePage.ResponseRedirect("../User/Login.aspx?ReturnUrl=" + HttpUtility.UrlEncode(absoluteUri)); } } IList <SurveyFieldInfo> fieldList = SurveyField.GetFieldList(surveyId); SurveyRecordInfo surveyrecordinfo = new SurveyRecordInfo(); DataTable table = new DataTable(); table.Columns.Add("Option", typeof(string)); table.Columns.Add("Input", typeof(string)); table.Columns.Add("QuestionType", typeof(int)); table.Columns.Add("InputType", typeof(int)); table.Columns.Add("QuestionId", typeof(int)); foreach (SurveyFieldInfo info4 in fieldList) { string answer = DataSecurity.FilterBadChar(base.Request.Form["Q" + info4.QuestionId]); this.CheckForm(info4, answer); DataRow row = table.NewRow(); row["Option"] = answer; row["QuestionType"] = info4.QuestionType; row["InputType"] = info4.InputType; row["QuestionId"] = info4.QuestionId; if (info4.InputType > 0) { string str3 = DataSecurity.FilterBadChar(base.Request.Form["Q" + info4.QuestionId + "Input"]); row["Input"] = str3; } if (((info4.QuestionType == 2) || (info4.QuestionType == 4)) || (info4.QuestionType == 7)) { SurveyVote.Vote(surveyId, info4.QuestionId, DataConverter.CLng(answer)); } if ((info4.QuestionType == 3) || (info4.QuestionType == 5)) { foreach (string str4 in answer.Split(new char[] { ',' })) { SurveyVote.Vote(surveyId, info4.QuestionId, DataConverter.CLng(str4)); } } table.Rows.Add(row); } surveyrecordinfo.Answer = table; surveyrecordinfo.UserName = PEContext.Current.User.UserInfo.UserName; surveyrecordinfo.IP = PEContext.Current.UserHostAddress; surveyrecordinfo.SubmitTime = DateTime.Now; surveyrecordinfo.SurveyId = surveyId; if (!SurveyRecord.SaveSurveyRecord(surveyrecordinfo)) { DynamicPage.WriteErrMsg("提交问卷失败!"); } else { DynamicPage.WriteSuccessMsg("提交问卷成功!", ""); } } }
private void BindData() { this.RptShowCountList.DataSource = SurveyRecord.GetList((this.Pager.CurrentPageIndex - 1) * this.Pager.PageSize, this.Pager.PageSize, this.m_SurveyId, this.m_RecordId); this.RptShowCountList.DataBind(); this.Pager.RecordCount = SurveyRecord.GetTotalOfSurveyRecord(); }
public ActionResult Edit(SurveyTemplate surveytemplate, FormCollection formcollection) { if (ModelState.IsValid) { if (db.SurveyTemplates.AsNoTracking().Where(i => i.RequestTypeID == surveytemplate.RequestTypeID && i.PreDefined == true && i.SurveyTemplateID != surveytemplate.SurveyTemplateID).ToList().Count > 0) { ViewBag.CustomErr = "İlgili İş tipine ait bir taslak zaten var. Lütfen Başka Bir Tip seçiniz"; return(RedirectToAction("Edit", new { id = surveytemplate.SurveyTemplateID })); } db.Entry(surveytemplate).State = EntityState.Modified; db.SaveChanges(); SurveyTemplate mysurvtemplate_ = db.SurveyTemplates.Include(p => p.SurveyRecords).Where(i => i.SurveyTemplateID == surveytemplate.SurveyTemplateID).SingleOrDefault(); int xindex = 0; foreach (SurveyNode snode_ in db.SurveyNodes.ToList()) { try { if (bool.Parse(formcollection[snode_.SurveyNodeID.ToString() + "_Remove"].Split(',')[0])) { } else { SurveyRecord mysurvrec = db.SurveyTemplates.AsNoTracking().Where(i => i.SurveyTemplateID == surveytemplate.SurveyTemplateID).SingleOrDefault().SurveyRecords.Where(u => u.SurveyNodeID == snode_.SurveyNodeID).SingleOrDefault(); var mysrec = db.SurveyRecords.Find(mysurvrec.SurveyRecordID); surveytemplate.SurveyRecords.Remove(mysrec); db.Entry(surveytemplate).State = EntityState.Modified; //db.SurveyRecords.Remove(mysurvrec); db.SaveChanges(); KlmsnContext db_ = new KlmsnContext(); var mysrec_forremove = db_.SurveyRecords.Find(mysurvrec.SurveyRecordID); db_.SurveyRecords.Remove(mysrec_forremove); db_.SaveChanges(); db_.Dispose(); try { if (bool.Parse(formcollection[snode_.SurveyNodeID.ToString() + "_Check"].Split(',')[0])) { SurveyRecord newsurvrec = new SurveyRecord { SurveyNodeID = snode_.SurveyNodeID, OrderNum = xindex, SurveyRecordTypeID = int.Parse(formcollection[snode_.SurveyNodeID.ToString() + "_survrectype"]) }; mysurvtemplate_.SurveyRecords.Add(newsurvrec); db.SaveChanges(); xindex++; } } catch (Exception ex) { ViewBag.CustomErr = ex.Message; } } } catch { try { if (bool.Parse(formcollection[snode_.SurveyNodeID.ToString() + "_Check"].Split(',')[0])) { SurveyRecord newsurvrec = new SurveyRecord { SurveyNodeID = snode_.SurveyNodeID, OrderNum = xindex, SurveyRecordTypeID = int.Parse(formcollection[snode_.SurveyNodeID.ToString() + "_survrectype"]) }; mysurvtemplate_.SurveyRecords.Add(newsurvrec); db.SaveChanges(); xindex++; } } catch (Exception ex) { ViewBag.CustomErr = ex.Message; } } xindex++; } return(RedirectToAction("Index")); } ViewBag.AllSurveyNodes = db.SurveyNodes.ToList(); ViewBag.TheseSurveyRecords = db.SurveyTemplates.Find(surveytemplate.SurveyTemplateID).SurveyRecords.ToList(); ViewBag.RequestTypeID = new SelectList(db.RequestTypes, "RequestTypeID", "Description", surveytemplate.RequestTypeID); return(View(surveytemplate)); }