/// <summary> /// /// </summary> /// <param name="parCallWriteLogSQL"></param> public WDB_SQLite(CallWriteLogSQL parCallWriteLogSQL = null) : base(parCallWriteLogSQL) { this.varVersion = "SQLite.0.0.1"; this.ReadSQL(GlobalVar.varPathIni + @"SQLite.sql"); this.InitSQL(); DateTime varD = DateTime.Today; string varReceiptFile = GlobalVar.varPathDB + varD.ToString("yyyyMM") + @"\Rc_" + GlobalVar.varIdWorkPlace.ToString() + "_" + varD.ToString("yyyyMMdd") + ".db"; if (!File.Exists(varReceiptFile)) { //Створюємо щоденну табличку з чеками. this.db = new SQLite(varReceiptFile); this.db.ExecuteNonQuery(varSqlCreateReceiptTable); this.db.Close(); } this.db = new SQLite(GlobalVar.varPathDB + @"MID.db");//,"",this.varCallWriteLogSQL); //this.db.ExecuteNonQuery("ATTACH ':memory:' AS m"); this.db.ExecuteNonQuery(this.varSqlCreateT); this.db.ExecuteNonQuery("ATTACH '" + varReceiptFile + "' AS rc"); }
public WDB(CallWriteLogSQL parCallWriteLogSQL = null) { this.varCallWriteLogSQL = parCallWriteLogSQL; }