//*************************************************** //설문지 조회 1:성공 0:실패 //*************************************************** public void SelectSelectSurvey(BindingList <SelectSurveyViewModel> myViewModel) { string sql = "Select * from sasu_suv"; connectionOpen(); try { cmd = new MySqlCommand(sql, conn); MySqlDataReader reader = cmd.ExecuteReader(); myViewModel.Clear(); while (reader.Read()) { SelectSurveyViewModel Temp = new SelectSurveyViewModel { SurveyCode = "S", SurveyName = reader["suv_name"].ToString(), SurveyDescrip = reader["suv_descrip"].ToString(), SurveyId = reader["suv_suvid"].ToString(), StartTime = Convert.ToDateTime(reader["suv_stime"]), FinishTime = Convert.ToDateTime(reader["suv_ftime"]), }; SelectLeftDG(Temp.LDG, Temp.SurveyId); SelectRightDG(Temp.RDG, Temp.SurveyId); myViewModel.Insert(myViewModel.Count, Temp); } }catch (Exception e) { Console.WriteLine(e.ToString()); } finally { cmd = null; conn.Close(); } }
//*************************************************** //설문지 입력 1:성공 0:실패 //*************************************************** public int InsertSelectSurvey(SelectSurveyViewModel data, string admin) { connectionOpen(); string sql = "insert into sasu_suv(adm_id, suv_name, suv_descrip, suv_stime, suv_ftime, datasys1, datasys2, datasys3) " + "value(@adminName, @SurveyName,@SurveyDescrip,@Stime,@Ftime,now(),'A',@admin);"; int result = 0; try { cmd = new MySqlCommand(sql, conn); cmd.Parameters.AddWithValue("@adminName", "dkxltks25"); cmd.Parameters.AddWithValue("@SurveyName", data.SurveyName); cmd.Parameters.AddWithValue("@SurveyDescrip", data.SurveyDescrip); cmd.Parameters.AddWithValue("@Stime", data.StartTime.ToString("yyyy-MM-dd HH:mm:ss")); cmd.Parameters.AddWithValue("@Ftime", data.FinishTime.ToString("yyyy-MM-dd HH:mm:ss")); cmd.Parameters.AddWithValue("@admin", admin); cmd.ExecuteNonQuery(); result = 1; }catch (Exception e) { result = 0; Console.WriteLine(e.ToString()); } finally { cmd = null; conn.Close(); } return(result); }
//***************************************************************** // 확인 버튼 클릭 //***************************************************************** private void CheckButton_Click(object sender, RoutedEventArgs e) { SelectSurveyViewModel data = (SelectSurveyViewModel)SurveyInfo.DataContext; if (btn_state == 0) { Console.WriteLine(data.SurveyName); SelectSurveyViewModel temp = new SelectSurveyViewModel { SurveyCode = "A", SurveyName = data.SurveyName, SurveyDescrip = data.SurveyDescrip, StartTime = data.StartTime, FinishTime = data.FinishTime }; myViewModel.Insert(myViewModel.Count, temp); } //업데이트 else if (btn_state == 1) { if (myViewModel[DG1.SelectedIndex].SurveyCode == "S") { myViewModel[DG1.SelectedIndex].SurveyCode = "U"; } else if (myViewModel[DG1.SelectedIndex].SurveyCode == "D") { myViewModel[DG1.SelectedIndex].SurveyCode = "U"; } } //삭제 else if (btn_state == 2) { if (myViewModel[DG1.SelectedIndex].SurveyCode == "S" || myViewModel[DG1.SelectedIndex].SurveyCode == "U") { myViewModel[DG1.SelectedIndex].SurveyDivision = myViewModel[DG1.SelectedIndex].SurveyCode; myViewModel[DG1.SelectedIndex].SurveyCode = "D"; } else if (myViewModel[DG1.SelectedIndex].SurveyCode == "D") { myViewModel[DG1.SelectedIndex].SurveyCode = myViewModel[DG1.SelectedIndex].SurveyDivision; } else { myViewModel.RemoveAt(DG1.SelectedIndex); } } resetText(); }
//*************************************************** //설문지 업데이트 1:성공 0:실패 //*************************************************** public int UpdateSelectSurvey(SelectSurveyViewModel data, string admin) { string sql = "update sasu_suv set \n" + "suv_name = @name,\n" + "suv_descrip = @descrip,\n" + "suv_stime = @st,\n" + "suv_ftime = @ft,\n" + "datasys1 = now(),\n" + "datasys2 = 'U',\n" + "datasys3 = @admin where suv_suvId = @id;"; int result = 0; connectionOpen(); try { cmd = new MySqlCommand(sql, conn); cmd.Parameters.AddWithValue("@name", data.SurveyName); cmd.Parameters.AddWithValue("@descrip", data.SurveyDescrip); cmd.Parameters.AddWithValue("@st", data.StartTime.ToString("yyyy-MM-dd HH:mm:ss")); cmd.Parameters.AddWithValue("@ft", data.FinishTime.ToString("yyyy-MM-dd HH:mm:ss")); cmd.Parameters.AddWithValue("@admin", admin); cmd.Parameters.AddWithValue("@id", data.SurveyId); cmd.ExecuteNonQuery(); result = 1; } catch (Exception e) { result = 0; Console.WriteLine(e.ToString()); } finally { cmd = null; conn.Close(); } return(result); }