static void Main(string[] args) { DatabaseManager.Initialize(); TcpAccountInfo accInfo = new TcpAccountInfo("root", "123qweasd", "김정현", "Super"); if (DatabaseManager.TryToRegister(accInfo, false)) { Console.WriteLine("root 계정을 추가하였습니다."); } else { Console.WriteLine("root 계정이 이미 있으므로 추가하지 않았습니다."); } TcpLoginInfo loginInfo1 = new TcpLoginInfo("wrong", "123qweasd"); TcpLoginInfo loginInfo2 = new TcpLoginInfo("root", "wrong"); TcpLoginInfo loginInfo3 = new TcpLoginInfo("root", "123qweasd"); Console.WriteLine(DatabaseManager.MatchLoginInfo(loginInfo1).ToString()); Console.WriteLine(DatabaseManager.MatchLoginInfo(loginInfo2).ToString()); Console.WriteLine(DatabaseManager.MatchLoginInfo(loginInfo3).ToString()); TcpDataInsert insert = new TcpDataInsert(); List <DatabaseValues> values = new List <DatabaseValues>(); values.Add(new DatabaseValues("#2000-8-14#", "99".ToSQLString(), "99".ToSQLString(), "99".ToSQLString(), "김정현".ToSQLString(), "1", "1", "1", "1", "1", "1", "1", "1", "1")); values.Add(new DatabaseValues("#2000-8-14#", "99".ToSQLString(), "99".ToSQLString(), "100".ToSQLString(), "김정현".ToSQLString(), "1", "1", "1", "1", "1", "1", "1", "1", "1")); values.Add(new DatabaseValues("#2000-8-14#", "99".ToSQLString(), "99".ToSQLString(), "101".ToSQLString(), "김정현".ToSQLString(), "1", "1", "1", "1", "1", "1", "1", "1", "1")); insert.ColumnsText = ""; insert.TableName = "출석부"; insert.Values = values; Console.WriteLine($"출석부에 {DatabaseManager.DBInsert(insert)}개 줄이 추가됨."); TcpDataUpdate update = new TcpDataUpdate(); update.TableName = "출석부"; update.Setter.Add("[0교시]", "2"); update.Setter.Add("[1교시]", "2"); update.Setter.Add("[2교시]", "2"); update.Setter.Add("[3교시]", "2"); update.Where = "[일자]=#2000-8-14# AND 학년=\"99\" AND 반=\"99\" AND 번호=\"99\""; Console.WriteLine($"출석부에서 {DatabaseManager.DBUpdate(update)}개 줄이 업데이트됨."); TcpDataDelete delete = new TcpDataDelete(); delete.TableName = "[출석부]"; delete.Where = "[일자]=#2000-8-14# AND 학년=\"99\" AND 반=\"99\" AND 번호=\"99\""; Console.WriteLine($"출석부에서 {DatabaseManager.DBDelete(delete)}개 줄이 삭제됨."); DatabaseManager.Close(); }
public static int DBInsert(TcpDataInsert dataInsert) { if (dataInsert == null) { throw new ArgumentNullException(nameof(dataInsert)); } string sql; OleDbCommand cmd = new OleDbCommand(); cmd.Connection = mConnection; int sum = 0; if (string.IsNullOrWhiteSpace(dataInsert.ColumnsText)) { foreach (DatabaseValues values in dataInsert.Values) { sql = $"INSERT INTO {dataInsert.TableName} VALUES {values.ToString()}"; cmd.CommandText = sql; lock (LOCKER) { sum += cmd.ExecuteNonQuery(); } } } else { foreach (DatabaseValues values in dataInsert.Values) { sql = $"INSERT INTO {dataInsert.TableName} {dataInsert.ColumnsText} VALUES {values.ToString()}"; cmd.CommandText = sql; lock (LOCKER) { sum += cmd.ExecuteNonQuery(); } } } return(sum); }
private void InsertDefaultAttToServer(DataTable stuList) { TcpDataInsert insert = new TcpDataInsert(); insert.TableName = "출석부"; insert.ColumnsText = null; List <DatabaseValues> values = new List <DatabaseValues>(); foreach (DataRow row in stuList.Rows) { values.Add(new DatabaseValues(DateControl.SelectedDate.Value.ToSQLString(), row["학년"].ToString().ToSQLString(), row["반"].ToString().ToSQLString(), row["번호"].ToString().ToSQLString(), row["성명"].ToString().ToSQLString(), "1", "1", "1", "1", "1", "1", "1", "1", "1")); } insert.Values = values; ParentWindow.Client.InsertData(insert); }
public bool Import(DataTable table) { if (table == null) { throw new ArgumentNullException(nameof(table)); } if (mTable == null) { return(false); } bool success = false; this.Dispatcher.BeginInvoke((Action)(() => { if (IsTableEmpty) { mTable.Rows.Clear(); } try { TcpDataInsert insert = new TcpDataInsert(); insert.TableName = "[학생 명단]"; insert.ColumnsText = null; List <DatabaseValues> values = new List <DatabaseValues>(); foreach (DataRow row in table.Rows) { DataRow newRow = mTable.NewRow(); newRow["학년"] = mCurrentGrade; newRow["반"] = mCurrentClass; newRow["번호"] = row["번호"]; newRow["성명"] = row["성명"]; newRow["등록날짜"] = (DateTime.Now).ToShortDateString(); values.Add(new DatabaseValues(newRow["학년"].ToString().ToSQLString(), newRow["반"].ToString().ToSQLString(), newRow["번호"].ToString().ToSQLString(), newRow["성명"].ToString().ToSQLString(), DateTime.Now.ToSQLString())); mTable.Rows.Add(newRow); } insert.Values = values; ParentWindow.Client.InsertData(insert); success = true; } catch (Exception e) { MessageBox.Show($"학생 명단에 데이터를 추가하는데 실패하였습니다...\n\n디버그용 메세지 : {e.Message}\n{e.StackTrace}", "추가 실패", MessageBoxButton.OK, MessageBoxImage.Error); success = false; } })).Wait(); return(success); }