// Application.Current.MainWindow = this; public CreateSurvey(string id, string name, string Descript) { InitializeComponent(); Application.Current.MainWindow = this; myViewModel = new BindingList <SurveyViewModel>(); DG1.ItemsSource = myViewModel; s_id = id; s_name = name; s_descrip = Descript; ManageSql Sql = new ManageSql(); Data = Sql.selectSurvey(s_id); Console.WriteLine("---------테스트"); Console.WriteLine(Data); if (!string.IsNullOrEmpty(Data)) { State = 1; LoadSurvey(Data); } //ConnectWeb(); //CreateTableColumn(); }
//*********************************************** //저장 버튼 클릭 화면에 입력된 데이터 JSON 변경 //*********************************************** private void SaveButton_Click(object sender, RoutedEventArgs e) { var FormData = new JObject(); var Title = new JObject(); Title.Add("Title", s_name); Title.Add("Descrip", s_descrip); var Item = new JArray(); for (int i = 0; i < myViewModel.Count; i++) { var SurveySubject = new JObject(); SurveySubject.Add("Title", myViewModel[i].SurveyTitle); SurveySubject.Add("Descrip", myViewModel[i].SurveyDescrip); SurveySubject.Add("Option", myViewModel[i].OptionNumber); SurveySubject.Add("OptionName", myViewModel[i].SurveyOption); if (myViewModel[i].SurveyOption != "단답형" && myViewModel[i].SurveyOption != "장문형") { var SurveyRow = new JArray(); var SurveyColumn = new JArray(); var SurveyItem = new JArray(); var SurveyItemRowAndColumn = new JObject(); for (int j = 0; j < myViewModel[i].SurveyItem.Count; j++) { if (myViewModel[i].SurveyOption == "객관식1" || myViewModel[i].SurveyOption == "객관식2") { SurveyItem.Add(myViewModel[i].SurveyItem[j].SurveyItem); } else if (myViewModel[i].SurveyOption == "그리드") { if (!string.IsNullOrEmpty(myViewModel[i].SurveyItem[j].SurveyRow)) { SurveyRow.Add(myViewModel[i].SurveyItem[j].SurveyRow); } if (!string.IsNullOrEmpty(myViewModel[i].SurveyItem[j].SurveyColumn)) { SurveyColumn.Add(myViewModel[i].SurveyItem[j].SurveyColumn); } } } SurveyItemRowAndColumn.Add("Row", SurveyRow); SurveyItemRowAndColumn.Add("Column", SurveyColumn); if (myViewModel[i].SurveyOption == "그리드") { SurveySubject.Add("item", SurveyItemRowAndColumn); } else { SurveySubject.Add("item", SurveyItem); } } Item.Add(SurveySubject); } FormData.Add("Title", Title); FormData.Add("item", Item); string str_json = JsonConvert.SerializeObject(FormData); string Url = "&Collection=" + str_json; Console.WriteLine(str_json); ConnectWeb(Url); ManageSql Sql = new ManageSql(); //Console.WriteLine(s_id); //저장 if (State == 0) { Sql.insertSurvey(str_json, s_id); State = 1; return; } //업데이트 if (State == 1) { Sql.updateSurvey(str_json, s_id); } }