protected void Page_Load(object sender, EventArgs e) { SurveyCommitHistory ent = null; switch (this.RequestActionString) { case "getScoreInfo": // DoGetScoreInfo(); break; default: DoSelect(); break; } }
private void CommitSurvey() /*存储提交的调查问卷数据*/ { string CommitHistory = this.RequestData.Get <string>("CommitHistory"); IList <string> list = this.RequestData.GetList <string>("commitArr"); if (list.Count > 0 && !string.IsNullOrEmpty(CommitHistory)) { IList <SurveyResult> ents = list.Select(ten => JsonHelper.GetObject <SurveyResult>(ten) as SurveyResult).ToArray(); SurveyCommitHistory shEnt = JsonHelper.GetObject <SurveyCommitHistory>(CommitHistory); foreach (var v in ents) { v.DoCreate(); } shEnt.DoCreate(); } }
private void GetCommitSurvey() { string SurveyId = this.RequestData.Get <string>("SurveyId"); if (!string.IsNullOrEmpty(SurveyId)) { if (!string.IsNullOrEmpty(this.RequestData.Get <string>("UserId"))) { SurveyCommitHistory Ent = SurveyCommitHistory.FindFirstByProperties(SurveyCommitHistory.Prop_SurveyId, SurveyId, SurveyCommitHistory.Prop_SurveyedUserId, this.RequestData.Get <string>("UserId")); if (Ent != null) { string str = string.IsNullOrEmpty(Ent.CommitSurvey) ? "" : Ent.CommitSurvey; try { int start = str.IndexOf("<SCRIPT type=text/javascript src=\"js/renderSurvey.js\"></SCRIPT>"); int end = str.IndexOf("</HEAD>"); str = str.Remove(start, end - start); str = str.Replace("commit()", ""); str = str.Replace("cancel()", ""); Response.Write(str); } catch (Exception e) { Response.Write(str); } } } else { SurveyCommitHistory Ent = SurveyCommitHistory.FindFirstByProperties(SurveyCommitHistory.Prop_SurveyId, SurveyId, SurveyCommitHistory.Prop_SurveyedUserId, UserInfo.UserID); if (Ent != null) { string str = string.IsNullOrEmpty(Ent.CommitSurvey) ? "" : Ent.CommitSurvey; int start = str.IndexOf("<SCRIPT type=text/javascript src=\"js/renderSurvey.js\"></SCRIPT>"); int end = str.IndexOf("</HEAD>"); str = str.Remove(start, end - start); Response.Write(str); // Response.Write(string.IsNullOrEmpty(Ent.CommitSurvey) ? "" : Ent.CommitSurvey); } } } //Response.End(); }
private void GetCommitSurvey() { string SurveyId = this.RequestData.Get <string>("SurveyId"); if (!string.IsNullOrEmpty(SurveyId)) { if (!string.IsNullOrEmpty(this.RequestData.Get <string>("UserId"))) { SurveyCommitHistory Ent = SurveyCommitHistory.FindFirstByProperties(SurveyCommitHistory.Prop_SurveyId, SurveyId, SurveyCommitHistory.Prop_SurveyedUserId, this.RequestData.Get <string>("UserId")); if (Ent != null) { Response.Write(string.IsNullOrEmpty(Ent.CommitSurvey) ? "" : Ent.CommitSurvey); } } else { SurveyCommitHistory Ent = SurveyCommitHistory.FindFirstByProperties(SurveyCommitHistory.Prop_SurveyId, SurveyId, SurveyCommitHistory.Prop_SurveyedUserId, UserInfo.UserID); if (Ent != null) { Response.Write(string.IsNullOrEmpty(Ent.CommitSurvey) ? "" : Ent.CommitSurvey); } } } }
private void CommitSurvey() /*存储提交的调查问卷数据*/ { string CommitHistory = this.RequestData.Get <string>("CommitHistory"); IList <string> list = this.RequestData.GetList <string>("commitArr"); if (list.Count > 0 && !string.IsNullOrEmpty(CommitHistory)) { IList <SurveyedResult> ents = list.Select(ten => JsonHelper.GetObject <SurveyedResult>(ten) as SurveyedResult).ToArray(); SurveyCommitHistory shEnt = JsonHelper.GetObject <SurveyCommitHistory>(CommitHistory); if (!string.IsNullOrEmpty(shEnt.SurveyedUserId)) { var UserEnt = SysUser.Find(shEnt.SurveyedUserId); shEnt.WorkNo = UserEnt.WorkNo; shEnt.SurveyedUserName = UserEnt.Name; } try { foreach (var v in ents) { v.DoCreate(); } } catch (Exception ex) { string SQL = "delete from FL_Culture..SurveyedResult where SurveyId='{0}' and UserId='{1}' "; SQL = string.Format(SQL, Id, uid); DataHelper.ExecSql(SQL); } int totalScore = -1; //计算总分 -1 表示无分值项 string SocreInfo = string.Empty; // 分值总分 var Ents = QuestionAnswerItem.FindAllByProperties(QuestionAnswerItem.Prop_SurveyId, shEnt.SurveyId); QuestionAnswerItem[] QArr = Ents.Where(ten => ten.Score.HasValue).ToArray(); if (QArr.Length > 0) { string sql = "select FL_Culture.dbo.f_SumSurveyScore('{0}','{1}') As TotalScore"; sql = string.Format(sql, shEnt.SurveyId, shEnt.SurveyedUserId); object obj = DataHelper.QueryValue(sql); int tryVal = 0; if (int.TryParse(obj.ToString(), out tryVal)) { tryVal = int.Parse(obj.ToString()); } totalScore = tryVal; SocreInfo = GetScoreInfo(shEnt.SurveyId, shEnt.SurveyedUserId); } //添加积分项 SurveyQuestion SQ = SurveyQuestion.Find(shEnt.SurveyId); if (SQ.Score.HasValue) { SurveyScore Score = new SurveyScore(); Score.Score = SQ.Score; Score.Sign = "s"; Score.UserID = shEnt.SurveyedUserId; Score.UserName = shEnt.SurveyedUserName; Score.Detail = SQ.SurveyTitile; Score.Ext1 = SQ.Id;//SurveyId Score.DoCreate(); } shEnt.TotalScore = totalScore; shEnt.ScoreInfo = SocreInfo; shEnt.DoCreate(); } }