public DB_ERROR AddNewUser(string name, string path, double principal) { if (name == "" || path == "") { return(DB_ERROR.DB_DATA_CANT_USE); } if (userdict.ContainsKey(name)) { return(DB_ERROR.DB_USER_TABLE_EXISTS); } DBDataController DBC = new DBDataController(name, path); DB_ERROR DBE = DBC.GetLastError(); if (DBE == DB_ERROR.DB_DATA_NOT_EXISTS) { DBC.PrincipalCreate(principal); UsersEntity UE; UE.name = name; UE.path = dbPath; users.Insert(UE); userdict.Add(name, DBC); return(DB_ERROR.DB_OK); } else if (DBE == DB_ERROR.DB_OK) { return(DB_ERROR.DB_USER_EXISTS); } else { return(DBE); } }
public DB_ERROR AddNewUser(string name, string path, double principal) { if (name == "" || path == "") return DB_ERROR.DB_DATA_CANT_USE; if (userdict.ContainsKey(name)) return DB_ERROR.DB_USER_TABLE_EXISTS; DBDataController DBC = new DBDataController(name, path); DB_ERROR DBE = DBC.GetLastError(); if (DBE == DB_ERROR.DB_DATA_NOT_EXISTS) { DBC.PrincipalCreate(principal); UsersEntity UE; UE.name = name; UE.path = dbPath; users.Insert(UE); userdict.Add(name, DBC); return DB_ERROR.DB_OK; } else if (DBE == DB_ERROR.DB_OK) { return DB_ERROR.DB_USER_EXISTS; } else { return DBE; } }
public DBDelegateBridge(DBDataController DBC) { DBDataController.MoneyDelegate money = new DBDataController.MoneyDelegate(MoneyDelegate); DBC.SetMoneyDelegate(money); DBDataController.StockHoldDelegate stockhold = new DBDataController.StockHoldDelegate(StockHoldDelegate); DBC.SetStockHoldDelegate(stockhold); }
public DBDelegateBridge(DBDataController DBC) { DBDataController.MoneyDelegate money = new DBDataController.MoneyDelegate(MoneyDelegate); DBC.SetMoneyDelegate(money); DBDataController.StockHoldDelegate stockhold = new DBDataController.StockHoldDelegate(StockHoldDelegate); DBC.SetStockHoldDelegate(stockhold); }
//默认创建方式 检测数据库是否出现 public void DBDataControllerCreateTest() { File.Delete(Environment.CurrentDirectory + "\\Stock.db");//先移除默认数据库 DBDataController DBC = new DBDataController("user1", Environment.CurrentDirectory + "\\Stock.db"); DB_ERROR DBE = DBC.GetLastError(); Assert.AreEqual(DB_ERROR.DB_DATA_NOT_EXISTS, DBE);//正常返回数据不存在 Assert.IsTrue(File.Exists(Environment.CurrentDirectory + "\\Stock.db"));//检测数据库是否生成 }
public void DelUser(string name, string path) { users.Delete(name); if (userdict.ContainsKey(name)) { userdict[name].DeleteAll(); userdict.Remove(name); } else { DBDataController DBC = new DBDataController(name, dbPath); DBC.DeleteAll(); } }
//数据库Principal读写测试 public void DBDataControllerPrincipalTest() { File.Delete(Environment.CurrentDirectory + "\\Stock2.db"); DBDataController DBC = new DBDataController("user7", Environment.CurrentDirectory + "\\Stock2.db"); DB_ERROR DBE = DBC.GetLastError(); DBC.PrincipalCreate(100000000000000.00); Assert.AreEqual(100000000000000.00, DBC.PrincipalRead()); for (int i = 0; i < 100; i++) { double a = DBC.PrincipalRead(); double m = 12.34 * i; DBC.PrincipalChange(m); Assert.AreEqual((a + m).ToString(), DBC.PrincipalRead().ToString()); } }
//数据库DealList读写测试 public void DBDataControllerDealListTest() { File.Delete(Environment.CurrentDirectory + "\\Stock1.db"); DBDataController DBC = new DBDataController("user6", Environment.CurrentDirectory + "\\Stock1.db"); DB_ERROR DBE = DBC.GetLastError(); DealListEntity DLE = new DealListEntity(); DLE.id = "600001"; DLE.name = "邯郸钢铁"; DBC.DealListAdd(DLE);//存入一条数据 List<DealListEntity> DLEL; DBC.DealListReadAll(out DLEL);//读取 Assert.AreEqual(1, DLEL.Count); Assert.AreEqual(DLE.id, DLEL[0].id);//判断读取与存入的数据是否一致 Assert.AreEqual(DLE.name, DLEL[0].name); }
//增加到dict中 public DB_ERROR AddUser(string name, string path) { if (userdict.ContainsKey(name)) return DB_ERROR.DB_USER_TABLE_EXISTS; DBDataController DBC = new DBDataController(name, path); DB_ERROR DBE = DBC.GetLastError(); if (DBE == DB_ERROR.DB_OK) { userdict.Add(name, DBC); return DB_ERROR.DB_OK; } else { DBC.DeleteAll(); return DBE; } }
//增加到dict中 public DB_ERROR AddUser(string name, string path) { if (userdict.ContainsKey(name)) { return(DB_ERROR.DB_USER_TABLE_EXISTS); } DBDataController DBC = new DBDataController(name, path); DB_ERROR DBE = DBC.GetLastError(); if (DBE == DB_ERROR.DB_OK) { userdict.Add(name, DBC); return(DB_ERROR.DB_OK); } else { DBC.DeleteAll(); return(DBE); } }
public static void setDBDataController(ref DBDataController DBC_) { DBC = DBC_; }
public static DBDataThreadController DBDataThreadControllerHandler(DBDataController DBC) { return new DBDataThreadController(DBC); }
private DBDataThreadController(DBDataController DBC) { this.DBC = DBC; }
public static DBDataThreadController DBDataThreadControllerHandler(DBDataController DBC) { return(new DBDataThreadController(DBC)); }
private DBDataThreadController(DBDataController DBC) { this.DBC = DBC; }
//crack数据库测试 public void DBDataControllerCheckCrackTest() { DBDataController DBC = new DBDataController("user3", Environment.CurrentDirectory + "\\TestDB\\crack.db"); DB_ERROR DBE = DBC.GetLastError(); Assert.AreEqual(DB_ERROR.DB_TABLE_CRACK_FIX, DBE);//返回损坏并修复状态 }
//数据库Log读写测试 public void DBDataControllerLogTest() { File.Delete(Environment.CurrentDirectory + "\\Stock3.db"); DBDataController DBC = new DBDataController("user8", Environment.CurrentDirectory + "\\Stock3.db"); DB_ERROR DBE = DBC.GetLastError(); LogEntity LE = new LogEntity(); LE.state = "状态"; LE.context = "错误内容"; DBC.LogSave(LE);//存入一条数据 List<LogEntity> LEL; DBC.LogRead(out LEL);//读取 Assert.AreEqual(1, LEL.Count); Assert.AreEqual(LE.state, LEL[0].state);//判断读取与存入的数据是否一致 Assert.AreEqual(LE.context, LEL[0].context); }
//没表数据库测试 public void DBDataControllerCheckTableTest() { DBDataController DBC = new DBDataController("user5", Environment.CurrentDirectory + "\\TestDB\\noTable.db"); DB_ERROR DBE = DBC.GetLastError(); Assert.AreEqual(DB_ERROR.DB_DATA_NOT_EXISTS, DBE);//返回数据不存在 }
public void DelUser(string name, string path) { users.Delete(name); if (userdict.ContainsKey(name)) { userdict[name].DeleteAll(); userdict.Remove(name); } else { DBDataController DBC = new DBDataController(name, dbPath); DBC.DeleteAll(); } }
//错误路径的构造方式 public void DBDataControllerCheckConnectTest() { DBDataController DBC = new DBDataController("user2", "/r/n"); DB_ERROR DBE = DBC.GetLastError(); Assert.AreEqual(DB_ERROR.DB_CANT_CONNECT, DBE);//数据库无法连接 }
private void user_SelectionChanged(object sender, SelectionChangedEventArgs e) { string u = ((ComboBoxItem)(((ComboBox)sender).SelectedItem)).Content.ToString(); DBC = UserPanelController.Handler().DBControllerByName(u); }
//数据库StockHold读测试 public void DBDataControllerStockHoldTest() { File.Delete(Environment.CurrentDirectory + "\\Stock4.db"); DBDataController DBC = new DBDataController("user9", Environment.CurrentDirectory + "\\Stock4.db"); DB_ERROR DBE = DBC.GetLastError(); DealListEntity DLE = new DealListEntity(); DLE.id = "600001"; DLE.name = "邯郸钢铁"; DLE.money = 10.11; DLE.number = 400; DLE.type = "买入"; DBC.DealListAdd(DLE);//存入一条数据 DLE.id = "600001"; DLE.name = "邯郸钢铁"; DLE.money = 5.11; DLE.number = 200; DLE.type = "卖出"; DBC.DealListAdd(DLE);//再存入一条数据 List<StockHoldEntity> SHEL; DBC.StockHoldReadAll(out SHEL); Assert.AreEqual(1, SHEL.Count); Assert.AreEqual(DLE.id, SHEL[0].id);//判断读取与存入的数据是否一致 Assert.AreEqual(DLE.name, SHEL[0].name); Assert.AreEqual(200, SHEL[0].hold);//运算结果 Assert.AreEqual(3022, SHEL[0].money);//运算结果 }