public void TestDeleteHaveUploadedLocalTempData() { var iDbSrv = new DtService36(_dataSource, _dataBaseName, _userId, _pwd); iDbSrv.RigisterBakupDataTable(GetConStr(), "[BMS36].[dbo].[BI_Data_Summary]", "[BMS36].[dbo].[Remote_BI_Data_Summary]"); for (var i = 0; i < 2; i++) { var sn = $"TEST000{i}"; var entry = new List <KeyValuePair <string, string> > { new KeyValuePair <string, string>("Station", Environment.MachineName), new KeyValuePair <string, string>("SN", sn), new KeyValuePair <string, string>("Plan", "A"), new KeyValuePair <string, string>("Board", "A"), new KeyValuePair <string, string>("Floor", "1"), new KeyValuePair <string, string>("Seat", "1"), new KeyValuePair <string, string>("Create_Time", "1"), new KeyValuePair <string, string>("Load_Time", "1"), new KeyValuePair <string, string>("Cost", "1"), new KeyValuePair <string, string>("Result", "1"), new KeyValuePair <string, string>("Comment", "1"), new KeyValuePair <string, string>("Data_Set_ID", "1") }; var id = iDbSrv.ApplyDataSetId(sn); iDbSrv.InsertData(id, "START", entry); iDbSrv.InsertData(id, "END", entry); } iDbSrv.BakupData(); iDbSrv.DeleteLocalHaveUploadedTempData("[BMS36].[dbo].[BI_Data_Summary]"); }
private BoardUnit GetBoardUnit() { ILog log = MockIlog(); DtService36 db = new DtService36(@"Data Source=shg-l80005754\SQLEXPRESS;Initial Catalog=BMS36;Persist Security Info=True;User ID=sa;Password=cml@shg629;Pooling=False"); FetchPlans fetchplans = FetchPlans.Inst(""); fetchplans.FetchPlansList(db); Dictionary <string, string> ports = new Dictionary <string, string>(); ports["OvenPort"] = "COM1"; ports["Floor1"] = "COM1"; ports["Floor2"] = "COM2"; ports["Floor3"] = "COM3"; ports["Floor4"] = "COM4"; ports["Floor5"] = "COM5"; ports["Floor6"] = "COM6"; ports["Floor7"] = "COM7"; ports["Floor8"] = "COM8"; ports["Floor9"] = "COM9"; ports["Floor10"] = "COM10"; BoardFactory factroy = new BoardFactory(log, fetchplans, ports); SystemParams param = new SystemParams(); BoardUnit unit = new BoardUnit(log, db, param); return(unit); }
public void Test_CreateDatabase() { IDataService iDbSrv = new DtService36(this._dataSource, this._dataBaseName, this._userId, this._pwd); string msg; bool res = iDbSrv.CreateDataBase(_dataSource, _userId, _pwd, "BMS361.sql", out msg); Assert.AreEqual(res, true); }
public void Test_UpdateMapScheme() { IDataService iDbSrv = new DtService36(this._dataSource, this._dataBaseName, this._userId, this._pwd); iDbSrv.UpdateMapScheme("1", "{1}"); }
public void Test_DeleteMapScheme() { IDataService iDbSrv = new DtService36(this._dataSource, this._dataBaseName, this._userId, this._pwd); iDbSrv.DeleteMapScheme("2"); }
public void Test_InsertMapScheme() { IDataService iDbSrv = new DtService36(this._dataSource, this._dataBaseName, this._userId, this._pwd); //iDbSrv.InsertMapScheme("2","{}"); //iDbSrv.InsertMapScheme("3", "{}"); }
public void Test_GetMapScheme() { IDataService iDbSrv = new DtService36(this._dataSource, this._dataBaseName, this._userId, this._pwd); iDbSrv.GetMapScheme("VBMS_POS_MAP"); }
public void Test_GetMapSchemeName() { IDataService iDbSrv = new DtService36(this._dataSource, this._dataBaseName, this._userId, this._pwd); string[] res = iDbSrv.GetMapSchemsName(); }
public void Test_CreateDataService() { IDataService iDbSrv = new DtService36(this._dataSource, this._dataBaseName, this._userId, this._pwd); Assert.AreNotEqual(iDbSrv, null); }