private void btnSecession_Click(object sender, RoutedEventArgs e) { SQLiteManager sqliteManager = MainWindow.GetSqliteManager(); string sql = "where Phone=\"" + tbPhone2.Text + "\""; sqliteManager.DBOpen(); if (MyMessageBox.createMessageBox(2, "이름 : " + cbName.Text + " 핸드폰번호 : " + tbPhone2.Text + " 사용자를 삭제하시겠습니까?", "회원삭제확인") == 0) { sqliteManager.Delete(SQLiteData.TableMember, sql); sqliteManager.Drop(tbPhone2.Text); Thread thread = new Thread(() => MainWindow.runThread(3, MySQLData.TableMember, sql)); thread.Start(); } sqliteManager.DBClose(); if (MemberData.GetMemberData.Phone == tbPhone2.Text) { TransitionPage.TransitionPages(0); } initCBSecession(); }
/// <summary> /// 스케줄 데이터 Delete /// </summary> /// <param name="phone">핸드폰번호</param> /// <param name="WageData">지울 데이터 구조체</param> /// <returns>영양받은 행수</returns> public int Delete(string phone, WageData WageData) { int result = -1; string sql = "where Date=\"" + WageData.Date + "\""; string year = SplitString(WageData.Date, '-')[0]; sqlliteManager.DBOpen(); result = sqlliteManager.Delete(phone + year, sql); sqlliteManager.DBClose(); sql = "where Date=\"" + WageData.Date + "\" and Phone=\"" + phone + "\""; Thread thread = new Thread(() => MainWindow.runThread(3, MySQLData.TableWage, sql)); thread.Start(); return(result); }