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 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(); } }