protected void Page_Load(object sender, EventArgs e) { SurveyId = RequestData.Get <string>("id") + ""; switch (this.RequestAction) { case RequestActionEnum.Update: DoSave(); break; case RequestActionEnum.Delete: ent = this.GetTargetData <SurveyQuestion>(); ent.DoDelete(); return; default: if (RequestActionString == "GetId") { QuestionItem qItem = new QuestionItem(); qItem.SubItemId = Guid.NewGuid().ToString(); qItem.DoCreate(); this.PageState.Add("SubItemId", qItem.Id + "|" + qItem.SubItemId); } else if (RequestActionString == "Close") { DoClose(); } else { DoSelect(); } break; } }
private void DoSelect() { if (!string.IsNullOrEmpty(SurveyId)) { var Ent = SurveyQuestion.Find(SurveyId); if (string.IsNullOrEmpty(Ent.TemplateId)) { string sql = @"select * from FL_Culture..QuestionItem where SurveyId='{0}' order by SortIndex "; sql = string.Format(sql, SurveyId); this.PageState.Add("DataList", DataHelper.QueryDictList(sql)); } else { //判断是否合并过 string SQL = "select * from FL_Culture..QuestionItem where SurveyId='{0}' "; SQL = string.Format(SQL, SurveyId); var Ents = DataHelper.QueryDictList(SQL); if (Ents.Count > 0) { string sql = @"select * from FL_Culture..QuestionItem where SurveyId='{0}' order by SortIndex "; sql = string.Format(sql, SurveyId); this.PageState.Add("DataList", DataHelper.QueryDictList(sql)); //SearchCriterion.SetOrder("SortIndex"); //IList<QuestionItem> Items = QuestionItem.FindAll(SearchCriterion, Expression.Sql(" SurveyId='" + SurveyId + "'")); //this.PageState.Add("DataList", Items); return; } //合并模板 var TemplateId = Ent.TemplateId; var ItemEnts = QuestionItem.FindAllByProperties(QuestionItem.Prop_SurveyId, TemplateId); var SubItemEnts = QuestionAnswerItem.FindAllByProperties(QuestionAnswerItem.Prop_SurveyId, TemplateId); foreach (var ent in ItemEnts) { QuestionItem Item = new QuestionItem(); Item = ent; Item.SurveyId = SurveyId; Item.DoCreate(); } foreach (var subEnt in SubItemEnts) { QuestionAnswerItem subItem = new QuestionAnswerItem(); subItem = subEnt; subItem.SurveyId = SurveyId; subItem.DoCreate(); } SearchCriterion.SetOrder("SortIndex"); IList <QuestionItem> items = QuestionItem.FindAll(SearchCriterion, Expression.Sql(" SurveyId='" + SurveyId + "'")); this.PageState.Add("DataList", items); } } }
//导入模板 private void ImpTpl() { if (!string.IsNullOrEmpty(id)) { string TemplateId = RequestData.Get("TemplateId") + ""; SurveyQuestion TemplateEnt = SurveyQuestion.TryFind(TemplateId); //问卷模板 SurveyQuestion Ent = SurveyQuestion.Find(id); if (string.IsNullOrEmpty(Ent.Description) && TemplateEnt != null) //描述 { Ent.Description = TemplateEnt.Description; } Ent.TemplateId = TemplateId; Ent.DoUpdate(); string SurveyId = id; int SortIndex = 1; string sql = "select count(1) T from FL_Culture..QuestionItem where SurveyId='{0}' "; sql = string.Format(sql, SurveyId); object obj = DataHelper.QueryValue(sql); if (obj != null) { SortIndex += int.Parse(obj.ToString()); } //合并模板 var ItemEnts = QuestionItem.FindAllByProperties(0, QuestionItem.Prop_SortIndex, QuestionItem.Prop_SurveyId, TemplateId); var SubItemEnts = QuestionAnswerItem.FindAllByProperties(QuestionAnswerItem.Prop_SurveyId, TemplateId); foreach (var ents in ItemEnts) { QuestionItem Item = new QuestionItem(); Item = ents; Item.SurveyId = SurveyId; Item.SortIndex = SortIndex; Item.Ext2 = "imp"; //导入标志 imp Item.DoCreate(); SortIndex++; } foreach (var subEnt in SubItemEnts) { QuestionAnswerItem subItem = new QuestionAnswerItem(); subItem = subEnt; subItem.SurveyId = SurveyId; subItem.Ext1 = "imp"; subItem.DoCreate(); } IList <QuestionItem> items = QuestionItem.FindAll(Expression.Sql(" SurveyId='" + SurveyId + "' order by SortIndex ")); this.PageState.Add("QItem", items); } }
/// <summary> /// 转存为模板 /// </summary> private void TurnTempLate() { string Id = RequestData.Get <string>("SurveyId"); if (!string.IsNullOrEmpty(Id)) { //先删除 var tplEnt = SurveyQuestion.FindFirstByProperties(SurveyQuestion.Prop_TurnSurveyId, Id, SurveyQuestion.Prop_IsFixed, "1"); if (tplEnt != null) { string SQL = "delete from FL_Culture..QuestionItem where SurveyId='{0}' "; SQL += " delete from FL_Culture..QuestionAnswerItem where SurveyId='{0}' "; SQL = string.Format(SQL, tplEnt.Id); DataHelper.ExecSql(SQL); tplEnt.DoDelete(); } SurveyQuestion Ent = SurveyQuestion.Find(Id); if (Ent != null) { SurveyQuestion TplEnt = new SurveyQuestion(); TplEnt.IsFixed = "1"; //1 模板标志位 TplEnt.State = "1"; //表示启用 TplEnt.SurveyTitile = Ent.SurveyTitile; TplEnt.Description = Ent.Description; TplEnt.TurnSurveyId = Id; TplEnt.CompanyId = Ent.CompanyId; //公司ID TplEnt.CompanyName = Ent.CompanyName; TplEnt.DoCreate(); var tplItems = QuestionItem.FindAllByProperties(QuestionItem.Prop_SurveyId, Id); var tplSubItems = QuestionAnswerItem.FindAllByProperties(QuestionAnswerItem.Prop_SurveyId, Id); foreach (var Item in tplItems) { QuestionItem tmpItem = new QuestionItem(); tmpItem = Item; tmpItem.SurveyId = TplEnt.Id; tmpItem.DoCreate(); } foreach (var SubItem in tplSubItems) { QuestionAnswerItem tempSubEnt = new QuestionAnswerItem(); tempSubEnt = SubItem; tempSubEnt.SurveyId = TplEnt.Id; tempSubEnt.DoCreate(); } } } }
/// <summary> /// 复制题目选择项 /// </summary> private void CopyItems() { string LastItem = RequestData.Get("LastItem") + ""; if (!string.IsNullOrEmpty(LastItem)) { string gid = Guid.NewGuid().ToString(); var LastEnt = QuestionItem.FindFirstByProperties(QuestionItem.Prop_SubItemId, LastItem); var Ents = QuestionAnswerItem.FindAllByProperty("QuestionItemId", LastItem); foreach (var v in Ents) { QuestionAnswerItem item = new QuestionAnswerItem(); item.Answer = v.Answer; item.IsExplanation = v.IsExplanation; item.IsShowScore = v.IsShowScore; item.QuestionItemId = gid; //* item.SurveyId = v.SurveyId; item.SortIndex = v.SortIndex; item.Score = v.Score; item.DoCreate(); } QuestionItem QiEnt = new QuestionItem(); QiEnt = LastEnt; QiEnt.SubItemId = gid; //* QiEnt.Content = string.Empty; QiEnt.SortIndex = LastEnt.SortIndex + 1; //QiEnt.IsComment = LastEnt.IsComment; //QiEnt.IsMustAnswer = LastEnt.IsMustAnswer; //QiEnt.IsShowScore = LastEnt.IsShowScore; //QiEnt.QuestionType = LastEnt.QuestionType; //QiEnt.SurveyId = LastEnt.SurveyId; //QiEnt.SubItems = LastEnt.SubItems; //QiEnt.Ext1 = LastEnt.Ext1; QiEnt.DoCreate(); this.PageState.Add("SubItemId", gid + "|" + QiEnt.Id); } else { this.PageState.Add("SubItemId", ""); } }
string SurveyId = String.Empty; // SurveyId protected void Page_Load(object sender, EventArgs e) { SurveyId = RequestData.Get <string>("SurveyId") + ""; switch (this.RequestActionString) { case "GetId": QuestionItem qItem = new QuestionItem(); qItem.SubItemId = Guid.NewGuid().ToString(); qItem.DoCreate(); this.PageState.Add("SubItemId", qItem.Id + "|" + qItem.SubItemId); break; case "Save": DoSave(); break; default: DoSelect(); break; } }
//子项的添加 private void AddQuestionItem() { QuestionItem qItem = new QuestionItem(); qItem.SubItemId = Guid.NewGuid().ToString(); qItem.IsMustAnswer = "是"; qItem.QuestionType = "单选项"; qItem.IsShowScore = "否"; qItem.IsComment = "否"; var SortIndex = this.RequestData.Get("SortIndex") + ""; var SurveyId = RequestData.Get("SurveyId") + ""; if (String.IsNullOrEmpty(SortIndex)) { SortIndex = "0"; } qItem.SortIndex = int.Parse(SortIndex); qItem.SurveyId = SurveyId; qItem.DoCreate(); this.PageState.Add("SubItemId", qItem.Id + "|" + qItem.SubItemId); }