예제 #1
0
        /// <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");
        }
예제 #2
0
파일: WDB.cs 프로젝트: OlehR/UniCS.TM
 public WDB(CallWriteLogSQL parCallWriteLogSQL = null)
 {
     this.varCallWriteLogSQL = parCallWriteLogSQL;
 }