/// <summary> /// 查询问卷列表 /// </summary> public string GetQuestionnairesData() { var form = Request("form").DeserializeJSONTo <QuestionnairesQueryEntity>(); var questionnaireBLL = new QuestionnaireBLL(this.CurrentUserInfo); string content = string.Empty; string QuestionnaireName = FormatParamValue(form.QuestionnaireName); //string Title = FormatParamValue(form.Title); //string DateBegin = FormatParamValue(form.DateBegin); //string DateEnd = FormatParamValue(form.DateEnd); int pageIndex = Utils.GetIntVal(FormatParamValue(Request("page"))) - 1; QuestionnaireEntity queryEntity = new QuestionnaireEntity(); queryEntity.QuestionnaireName = QuestionnaireName; //if (this.CurrentUserInfo.CurrentUser.User_Name.ToLower() == "admin") //{ // queryEntity.CreateBy = this.CurrentUserInfo.CurrentUser.User_Name.ToLower(); //} //else //{ // queryEntity.CreateBy = this.CurrentUserInfo.UserID; //} var data = questionnaireBLL.GetWebQuestionnaires(queryEntity, pageIndex, PageSize); var dataTotalCount = questionnaireBLL.GetWebQuestionnairesCount(queryEntity); content = string.Format("{{\"totalCount\":{1},\"topics\":{0}}}", data.ToJSON(), dataTotalCount); return(content); }
protected string GetEventCommentList(string pRequest) { EventCommentListRD rd = new EventCommentListRD(); try { var rp = pRequest.DeserializeJSONTo <APIRequest <EventCommentListRP> >(); var loggingSessionInfo = Default.GetBSLoggingSession(rp.CustomerID, rp.UserID); QuestionnaireBLL bll = new QuestionnaireBLL(loggingSessionInfo); var ds = bll.GetCommentList(rp.Parameters.QuestionnaireID, rp.UserID); if (ds != null && ds.Tables[0].Rows.Count > 0) { string VIPName = ds.Tables[0].Rows[0]["VipName"].ToString(); var list1 = ds.Tables[0].AsEnumerable().Where(t => t["QuestionType"].ToString() == "3"); //查内容 var list2 = ds.Tables[0].AsEnumerable().Where(t => t["QuestionType"].ToString() == "6"); //查询评分 var Grade = list2.Aggregate(0, (a, b) => a + Convert.ToInt32(b["OptionsText"])) / list2.Count(); var Commentcontent = list1.Aggregate("", (a, b) => a + b["Content"].ToString() + "\r\n "); rd.VipName = VIPName; rd.Grade = Grade; rd.Commentcontent = Commentcontent; } var rsp = new SuccessResponse <IAPIResponseData>(rd); return(rsp.ToJSON()); } catch (Exception ex) { throw new APIException(ex.Message); } }
/// <summary> /// 保存用户考题 /// 返回 /// </summary> /// <param name="pSurveyTestId"></param> /// <param name="pAnswerList"></param> /// <returns></returns> public int SaveAnswerSheet(string pSurveyTestId, string pUserId, List <AnswerItem> pAnswerList, out decimal lastScore) { int isPassed = 0; decimal score = 0; decimal outSocre = 0; int singleIsCorrect = -1; MLAnswerSheetBLL sheetBll = new MLAnswerSheetBLL(_loggingSessionInfo); string answerSheetId = Guid.NewGuid().ToString().Replace("-", ""); foreach (var item in pAnswerList) { //保存答题 singleIsCorrect = SaveAnswerSheetItem(answerSheetId, item.QuestionId, item.Answer, out outSocre); if (singleIsCorrect == 1) { score += outSocre; } } //判断是否通过 //条件:score>=PassScore QuestionnaireBLL quesBll = new QuestionnaireBLL(_loggingSessionInfo); QuestionnaireEntity quesEntity = quesBll.GetByID(pSurveyTestId); if (quesEntity != null) { if (score >= quesEntity.PassScore) { isPassed = 1; } else { isPassed = 0; } } lastScore = score; //保存考卷 MLAnswerSheetEntity sheetEntity = new MLAnswerSheetEntity() { AnswerSheetId = answerSheetId, AnswerTime = DateTime.Now, CustomerID = _loggingSessionInfo.CurrentUser.customer_id, IsDelete = 0, IsPassed = isPassed, QuestionnaireID = pSurveyTestId, Score = score, UserId = pUserId }; sheetBll.Create(sheetEntity); return(isPassed); }
/// <summary> /// 考卷列表 /// </summary> /// <param name="pType"></param> /// <param name="pPageIndex"></param> /// <param name="pPageSize"></param> /// <returns></returns> public List <SurveyTestItem> GetQuestionnaires(string pType, int pPageIndex, int pPageSize) { List <SurveyTestItem> list = new List <SurveyTestItem>(); QuestionnaireBLL quesBll = new QuestionnaireBLL(_loggingSessionInfo); DataTable dTbl = quesBll.GetQuestionnaire(pType, pPageIndex, pPageSize); if (dTbl != null) { list = DataTableToObject.ConvertToList <SurveyTestItem>(dTbl); } return(list); }
/// <summary> /// 获取考卷详情 /// </summary> /// <param name="pSurveyTestId"></param> /// <returns></returns> public SurveyTestItem GetQuestionnaireDetail(string pSurveyTestId) { List <SurveyTestItem> list = new List <SurveyTestItem>(); QuestionnaireBLL quesBll = new QuestionnaireBLL(_loggingSessionInfo); DataTable dTbl = quesBll.GetQuestionnaireDetail(pSurveyTestId); if (dTbl != null) { list = DataTableToObject.ConvertToList <SurveyTestItem>(dTbl); return(list[0]); } return(null); }
/// <summary> /// 胆汁质,包括2,6,9,14,17,21,27,31,36,38,42,48,50,54,58各题; /// 多血质,包括4,8,11,16,19,23,25,29,34,40,44,46,52,56,60各题; /// 粘液质,包括1,7,10,13,18,22,26,30,33,39,43,45,49,55,57各题; /// 抑郁质,包括3,5,12,15,20,24,28,32,35,37,41,47,51,53,59各题。 /// 1、testScore1 胆汁质总分 /// 2、testScore2 多血质总分 /// 3、testScore3 粘液质总分 /// 4、testScore4 抑郁质总分 /// </summary> /// <param name="context"></param> public void ProcessRequest(HttpContext context) { context.Response.ContentType = "text/plain"; string stunum = "1610030169"; int testScore1 = int.Parse(context.Request.Form["s1"]); int testScore2 = int.Parse(context.Request.Form["s2"]); int testScore3 = int.Parse(context.Request.Form["s3"]); int testScore4 = int.Parse(context.Request.Form["s4"]); string learPattern = context.Request.Form["pattern"]; int msg; QuestionnaireBLL bll = new QuestionnaireBLL(); bll.ScoreInsert(stunum, testScore1, testScore2, testScore3, testScore4, learPattern, out msg); context.Response.Write(msg); }
/// <summary> /// 视频类型 /// </summary> public string GetQuestionnaireTypeData() { QuestionnaireBLL service = new QuestionnaireBLL(CurrentUserInfo); var list = service.GetAll(); string content = string.Empty; var jsonData = new JsonData(); jsonData.totalCount = list != null?list.Length.ToString() : "0"; jsonData.data = list; content = jsonData.ToJSON(); return(content); }
/// <summary> /// 根据ID获取问题信息 /// </summary> public string GetQuestionnairesById() { var questionnairesService = new QuestionnaireBLL(this.CurrentUserInfo); string content = string.Empty; string key = string.Empty; if (FormatParamValue(Request("QuestionnaireID")) != null && FormatParamValue(Request("QuestionnaireID")) != string.Empty) { key = FormatParamValue(Request("QuestionnaireID")).ToString().Trim(); } var condition = new List <IWhereCondition>(); if (!key.Equals(string.Empty)) { condition.Add(new EqualsCondition() { FieldName = "QuestionnaireID", Value = key }); } var data = questionnairesService.Query(condition.ToArray(), null).ToList().FirstOrDefault(); //if (data != null) //{ // data.StrPublishTime = data.PublishTime.Value.ToString("yyyy-MM-dd"); //} //data.StartDateText = data.StartTime == null ? string.Empty : // Convert.ToDateTime(data.StartTime).ToString("yyyy-MM-dd"); //data.EndDateText = data.StartTime == null ? string.Empty : // Convert.ToDateTime(data.StartTime).ToString("yyyy-MM-dd"); //data.Description = HttpUtility.HtmlDecode(data.Description); var jsonData = new JsonData(); jsonData.totalCount = (data == null) ? "0" : "1"; jsonData.data = data; content = string.Format("{{\"totalCount\":{1},\"topics\":{0}}}", data.ToJSON(), (data == null) ? "0" : "1"); return(content); }
public string GetSurveyTestList(string pRequest) { var rd = new APIResponse <GetSurveyTestListRD>(); var rdData = new GetSurveyTestListRD(); var rp = pRequest.DeserializeJSONTo <APIRequest <GetSurveyTestListRP> >(); if (rp.Parameters == null) { throw new ArgumentException(); } if (rp.Parameters != null) { rp.Parameters.Validate(); } var loggingSessionInfo = Default.GetBSLoggingSession(rp.CustomerID, rp.UserID); try { QuestionnaireBLL quesBll = new QuestionnaireBLL(loggingSessionInfo); DataTable dTbl = quesBll.GetQuestionnaire(rp.Parameters.Type.ToString(), rp.Parameters.PageIndex, rp.Parameters.PageSize); if (dTbl != null) { rdData.SurveyTestList = DataTableToObject.ConvertToList <SurveyTestItem>(dTbl); } rd.ResultCode = 0; } catch (Exception ex) { rd.ResultCode = 103; rd.Message = ex.Message; } rd.Data = rdData; return(rd.ToJSON()); }
protected void save_Click(object sender, EventArgs e) { questionnaireModel = new QuestionnaireModel(); questionnaireBLL = new QuestionnaireBLL(); studentsRotaryBLL = new StudentsRotaryBLL(); questionnaireModel.id = Guid.NewGuid().ToString(); questionnaireModel.training_base_name = CommonFunc.FilterSpecialString(CommonFunc.SafeGetStringFromObj(training_base_name.Text.Trim())); questionnaireModel.training_base_code = CommonFunc.FilterSpecialString(CommonFunc.SafeGetStringFromObj(training_base_code.Value.Trim())); questionnaireModel.professional_base_name = CommonFunc.FilterSpecialString(CommonFunc.SafeGetStringFromObj(professional_base_name.Text.Trim())); questionnaireModel.professional_base_code = CommonFunc.FilterSpecialString(CommonFunc.SafeGetStringFromObj(professional_base_code.Value.Trim())); questionnaireModel.rotary_dept_name = CommonFunc.FilterSpecialString(CommonFunc.SafeGetStringFromObj(rotary_dept_name.Text.Trim())); questionnaireModel.rotary_dept_code = CommonFunc.FilterSpecialString(CommonFunc.SafeGetStringFromObj(rotary_dept_code.Value.Trim())); questionnaireModel.instructor = CommonFunc.FilterSpecialString(CommonFunc.SafeGetStringFromObj(instructor.Text.Trim())); questionnaireModel.one = CommonFunc.FilterSpecialString(CommonFunc.SafeGetStringFromObj(RadioButtonList1.SelectedValue)); questionnaireModel.two = CommonFunc.FilterSpecialString(CommonFunc.SafeGetStringFromObj(RadioButtonList2.SelectedValue)); questionnaireModel.three = CommonFunc.FilterSpecialString(CommonFunc.SafeGetStringFromObj(RadioButtonList3.SelectedValue)); questionnaireModel.four = CommonFunc.FilterSpecialString(CommonFunc.SafeGetStringFromObj(RadioButtonList4.SelectedValue)); questionnaireModel.five = CommonFunc.FilterSpecialString(CommonFunc.SafeGetStringFromObj(RadioButtonList5.SelectedValue)); questionnaireModel.six = CommonFunc.FilterSpecialString(CommonFunc.SafeGetStringFromObj(RadioButtonList6.SelectedValue)); questionnaireModel.seven = CommonFunc.FilterSpecialString(CommonFunc.SafeGetStringFromObj(RadioButtonList7.SelectedValue)); questionnaireModel.eight = CommonFunc.FilterSpecialString(CommonFunc.SafeGetStringFromObj(RadioButtonList8.SelectedValue)); questionnaireModel.nine = CommonFunc.FilterSpecialString(CommonFunc.SafeGetStringFromObj(RadioButtonList9.SelectedValue)); questionnaireModel.ten = CommonFunc.FilterSpecialString(CommonFunc.SafeGetStringFromObj(RadioButtonList10.SelectedValue)); questionnaireModel.eleven = CommonFunc.FilterSpecialString(CommonFunc.SafeGetStringFromObj(RadioButtonList11.SelectedValue)); questionnaireModel.twelve = CommonFunc.FilterSpecialString(CommonFunc.SafeGetStringFromObj(RadioButtonList12.SelectedValue)); questionnaireModel.thirteen = CommonFunc.FilterSpecialString(CommonFunc.SafeGetStringFromObj(RadioButtonList13.SelectedValue)); questionnaireModel.advice = CommonFunc.FilterSpecialString(CommonFunc.SafeGetStringFromObj(advice.Text.Trim())); questionnaireModel.register_date = CommonFunc.FilterSpecialString(CommonFunc.SafeGetStringFromObj(register_date.Text.Trim())); questionnaireModel.writor = CommonFunc.FilterSpecialString(CommonFunc.SafeGetStringFromObj(writor.Value.Trim())); if (RadioButtonList1.SelectedItem == null) { ShowMessageBox.Showmessagebox(this, "第一项未选择", null); return; } if (RadioButtonList2.SelectedItem == null) { ShowMessageBox.Showmessagebox(this, "第二项未选择", null); return; } if (RadioButtonList3.SelectedItem == null) { ShowMessageBox.Showmessagebox(this, "第三项未选择", null); return; } if (RadioButtonList4.SelectedItem == null) { ShowMessageBox.Showmessagebox(this, "第四项未选择", null); return; } if (RadioButtonList5.SelectedItem == null) { ShowMessageBox.Showmessagebox(this, "第五项未选择", null); return; } if (RadioButtonList6.SelectedItem == null) { ShowMessageBox.Showmessagebox(this, "第六项未选择", null); return; } if (RadioButtonList7.SelectedItem == null) { ShowMessageBox.Showmessagebox(this, "第七项未选择", null); return; } if (RadioButtonList8.SelectedItem == null) { ShowMessageBox.Showmessagebox(this, "第八项未选择", null); return; } if (RadioButtonList9.SelectedItem == null) { ShowMessageBox.Showmessagebox(this, "第九项未选择", null); return; } if (RadioButtonList10.SelectedItem == null) { ShowMessageBox.Showmessagebox(this, "第十项未选择", null); return; } if (RadioButtonList11.SelectedItem == null) { ShowMessageBox.Showmessagebox(this, "第十一项未选择", null); return; } if (RadioButtonList12.SelectedItem == null) { ShowMessageBox.Showmessagebox(this, "第十二项未选择", null); return; } if (RadioButtonList13.SelectedItem == null) { ShowMessageBox.Showmessagebox(this, "第十三项未选择", null); return; } if (string.IsNullOrEmpty(questionnaireModel.advice)) { ShowMessageBox.Showmessagebox(this, "第十四项不能为空", null); return; } if (questionnaireBLL.InsertQuestionnaire(questionnaireModel) && studentsRotaryBLL.UpdateQuestStatus(questionnaireyi, id)) { try { Response.Write("<script language='javascript'> alert('问卷调查提交成功');window.opener.window.loadPageList('" + pi + "');window.close();</script>"); return; } catch (Exception ex) { Response.Write(ex.Message); } } }
/// <summary> /// 活动报名表数据获取 /// </summary> public string getEventApplyQues() { string ReqContent = string.Empty; string content = string.Empty; var respObj = new getEventApplyQuesRespData(); string respStr = string.Empty; try { ReqContent = Request["ReqContent"]; ReqContent = HttpUtility.HtmlDecode(ReqContent); var reqContentObj = ReqContent.DeserializeJSONTo <getEventApplyQuesReqData>(); Loggers.Debug(new DebugLogInfo() { Message = string.Format( "getEventApplyQues ReqContent:{0}", ReqContent) }); var service = new QuestionnaireBLL(Default.GetLoggingSession()); GetResponseParams <QuestionnaireEntity> returnDataObj = service.getEventApplyQues(reqContentObj.special.eventId); // GetResponseParams<QuestionnaireEntity> returnDataObj = service.getEventApplyQues("1"); var contentObj = new getEventApplyQuesRespContentData(); respObj.Code = returnDataObj.Code; respObj.Description = returnDataObj.Description; if (returnDataObj.Flag == "1" && returnDataObj.Params != null) { contentObj.questionCount = Default.ToStr(returnDataObj.Params.QuestionCount); // questions if (returnDataObj.Params.QuesQuestionEntityList != null) { contentObj.questions = new List <getEventApplyQuesRespQuestionData>(); foreach (var tmpQuestion in returnDataObj.Params.QuesQuestionEntityList) { if (tmpQuestion == null) { continue; } var tmpQues = new getEventApplyQuesRespQuestionData(); tmpQues.questionId = Default.ToStr(tmpQuestion.QuestionID); tmpQues.isSaveOutEvent = Default.ToStr(tmpQuestion.IsSaveOutEvent); tmpQues.cookieName = Default.ToStr(tmpQuestion.CookieName); tmpQues.questionText = Default.ToStr(tmpQuestion.QuestionDesc); tmpQues.questionType = Default.ToStr(tmpQuestion.QuestionType); tmpQues.minSelected = Default.ToStr(tmpQuestion.MinSelected); tmpQues.maxSelected = Default.ToStr(tmpQuestion.MaxSelected); tmpQues.isRequired = Default.ToStr(tmpQuestion.IsRequired); tmpQues.isFinished = Default.ToStr(tmpQuestion.IsFinished); // options if (tmpQuestion.QuesOptionEntityList != null) { tmpQues.options = new List <getEventApplyQuesRespOptionData>(); foreach (var tmpOption in tmpQuestion.QuesOptionEntityList) { if (tmpOption == null) { continue; } var tmpOp = new getEventApplyQuesRespOptionData(); tmpOp.optionId = Default.ToStr(tmpOption.OptionsID); tmpOp.optionText = Default.ToStr(tmpOption.OptionsText); tmpOp.isSelected = Default.ToStr(tmpOption.IsSelect); tmpQues.options.Add(tmpOp); } } contentObj.questions.Add(tmpQues); } } } respObj.content = contentObj; Loggers.Debug(new DebugLogInfo() { Message = string.Format( "getEventApplyQues RespContent:{0}", respObj.ToJSON()) }); } catch (Exception ex) { respObj.Code = "103"; respObj.Description = "数据库操作错误"; respObj.Exception = ex.ToString(); } content = respObj.ToJSON(); return(content); }
/// <summary> /// 活动报名表数据提交 /// </summary> public string submitEventApply() { string ReqContent = string.Empty; string content = string.Empty; var respObj = new submitEventApplyRespData(); string respStr = string.Empty; try { ReqContent = Request["Form"]; //ReqContent = HttpUtility.HtmlDecode(ReqContent); var reqContentObj = ReqContent.DeserializeJSONTo <submitEventApplyReqData>(); Loggers.Debug(new DebugLogInfo() { Message = string.Format( "submitEventApply ReqContent:{0}", ReqContent) }); var service = new QuestionnaireBLL(Default.GetLoggingSession()); // WEventUserMappingEntity //WEventUserMappingEntity userMappingEntity = new WEventUserMappingEntity(); //userMappingEntity.UserName = reqContentObj.special.userName; //userMappingEntity.Mobile = reqContentObj.special.mobile; //userMappingEntity.Email = reqContentObj.special.email; // quesAnswerList IList <QuesAnswerEntity> quesAnswerList = new List <QuesAnswerEntity>(); if (reqContentObj.special.questions != null) { foreach (var question in reqContentObj.special.questions) { QuesAnswerEntity quesAnswerEntity = new QuesAnswerEntity(); quesAnswerEntity.QuestionID = question.questionId; quesAnswerEntity.QuestionValue = question.questionValue; quesAnswerList.Add(quesAnswerEntity); } } string userId = reqContentObj.common.userId; if (userId == null || userId.Trim().Length == 0) { userId = "1"; } //Jermyn20130621 判断特殊的openId=123456,作为公众平台编辑模式进来的判断逻辑 if (reqContentObj.common.openId.Equals("123456") || reqContentObj.common.openId.Equals("111")) { reqContentObj.common.openId = System.Guid.NewGuid().ToString().Replace("-", ""); } if (reqContentObj.special.userName == null || reqContentObj.special.userName.Trim().Length == 0) { reqContentObj.special.userName = System.Guid.NewGuid().ToString().Replace("-", ""); } GetResponseParams <bool> returnDataObj = service.WEventSubmitEventApply( reqContentObj.common.openId, reqContentObj.special.eventId, userId, //userMappingEntity, quesAnswerList, reqContentObj.special.userName); respObj.Code = returnDataObj.Code; respObj.Description = returnDataObj.Description; Loggers.Debug(new DebugLogInfo() { Message = string.Format( "submitEventApply RespContent:{0}", respObj.ToJSON()) }); #region 推送消息 string msgUrl = ConfigurationManager.AppSettings["push_weixin_msg_url"].Trim(); string msgText = "感谢您积极参与我们的活动。"; string msgData = "<xml><OpenID><![CDATA[" + reqContentObj.common.openId + "]]></OpenID><Content><![CDATA[" + msgText + "]]></Content></xml>"; var msgResult = Common.Utils.GetRemoteData(msgUrl, "POST", msgData); #endregion } catch (Exception ex) { respObj.Code = "103"; respObj.Description = "数据库操作错误"; respObj.Exception = ex.ToString(); } content = respObj.ToJSON(); return(content); }
/// <summary> /// 保存问题信息 /// </summary> public string SaveQuestionnaires() { var questionnairesService = new QuestionnaireBLL(this.CurrentUserInfo); string content = string.Empty; string error = ""; var responseData = new ResponseData(); string key = string.Empty; string QuestionnaireID = string.Empty; var questionnaires = Request("questionnaires"); if (FormatParamValue(questionnaires) != null && FormatParamValue(questionnaires) != string.Empty) { key = FormatParamValue(questionnaires).ToString().Trim(); } if (FormatParamValue(Request("QuestionnaireID")) != null && FormatParamValue(Request("QuestionnaireID")) != string.Empty) { QuestionnaireID = FormatParamValue(Request("QuestionnaireID")).ToString().Trim(); } var questionnairesEntity = key.DeserializeJSONTo <QuestionnaireEntity>(); //if (questionnairesEntity.QuestionnaireType == null || questionnairesEntity.QuestionnaireType.ToString().Trim().Length == 0) //{ // responseData.success = false; // responseData.msg = "问题类型不能为空"; // return responseData.ToJSON(); //} //if (questionnairesEntity.Title == null || questionnairesEntity.Title.Trim().Length == 0) //{ // responseData.success = false; // responseData.msg = "问题标题不能为空"; // return responseData.ToJSON(); //} //if (questionnairesEntity.StartTimeText == null || questionnairesEntity.StartTimeText.Trim().Length == 0) //{ // responseData.success = false; // responseData.msg = "起始时间不能为空"; // return responseData.ToJSON(); //} //if (questionnairesEntity.EndTimeText == null || questionnairesEntity.EndTimeText.Trim().Length == 0) //{ // responseData.success = false; // responseData.msg = "结束时间不能为空"; // return responseData.ToJSON(); //} //try //{ // questionnairesEntity.StartTime = Convert.ToDateTime(questionnairesEntity.StartTimeText); //} //catch //{ // responseData.success = false; // responseData.msg = "起始时间格式错误"; // return responseData.ToJSON(); //} //try //{ // questionnairesEntity.EndTime = Convert.ToDateTime(questionnairesEntity.EndTimeText); //} //catch //{ // responseData.success = false; // responseData.msg = "结束时间格式错误"; // return responseData.ToJSON(); //} //questionnairesEntity.Description = HttpUtility.HtmlEncode(questionnairesEntity.Description); if (QuestionnaireID.Trim().Length == 0) { questionnairesEntity.QuestionnaireID = Utils.NewGuid(); questionnairesEntity.CustomerId = CurrentUserInfo.CurrentUser.customer_id; //questionnairesEntity.Status = 0; //questionnairesEntity.ApplyCount = 0; //questionnairesEntity.CheckInCount = 0; //questionnairesEntity.PostCount = 0; questionnairesService.Create(questionnairesEntity); } else { questionnairesEntity.QuestionnaireID = QuestionnaireID; questionnairesService.Update(questionnairesEntity, false); } responseData.success = true; responseData.msg = error; content = responseData.ToJSON(); return(content); }