public override bool AddReceipt(Receipt parReceipt) { using (var DB = new SQLite(ReceiptFile)) { return(DB.ExecuteNonQuery <Receipt>(SqlAddReceipt, parReceipt) > 0); } }
public override bool InsertAddWeight(AddWeight parAddWeight) { using (var DB = new SQLite(ConfigFile)) { return(DB.ExecuteNonQuery <AddWeight>(SqlInsertAddWeight, parAddWeight) > 0); } }
public override bool DeleteReceiptWares(ReceiptWares parIdReceiptWares) { using (var DB = new SQLite(ReceiptFile)) { return(DB.ExecuteNonQuery <IdReceiptWares>(SqlDeleteReceiptWares, parIdReceiptWares) > 0 /*&& RecalcHeadReceipt(parParameters)*/); } }
public override bool FixWeight(ReceiptWares parIdReceipt) { using (var DB = new SQLite(ReceiptFile)) { return(DB.ExecuteNonQuery <ReceiptWares>(SqlSetFixWeight, parIdReceipt) > 0); } }
public override bool SetRefundedQuantity(ReceiptWares parReceiptWares) { using (var DB = new SQLite(ReceiptFile)) { return(DB.ExecuteNonQuery <ReceiptWares>(SqlSetRefundedQuantity, parReceiptWares) > 0); } }
public override bool DeleteReceiptEvent(IdReceipt parIdReceipt) { using (var DB = new SQLite(ReceiptFile)) { return(DB.ExecuteNonQuery <IdReceipt>(SqlDeleteReceiptEvent, parIdReceipt) > 0); } }
public override bool RecalcHeadReceipt(IdReceipt parReceipt) { using (var DB = new SQLite(ReceiptFile)) { return(DB.ExecuteNonQuery <IdReceipt>(this.SqlRecalcHeadReceipt, parReceipt) > 0); } }
public override bool InsertWeight(Object parWeight) { using (var DB = new SQLite(ConfigFile)) { return(DB.ExecuteNonQuery <Object>(SqlInsertWeight, parWeight) > 0); } }
public override bool InsertLogRRO(LogRRO pLog) { using (var DB = new SQLite(ReceiptFile)) { return(DB.ExecuteNonQuery <LogRRO>(SqlInsertLogRRO, pLog) > 0); } }
public override bool ReplaceWaresReceipt(ReceiptWares parReceiptWares) { using (var DB = new SQLite(ReceiptFile)) { return(DB.ExecuteNonQuery <ReceiptWares>(SqlReplaceWaresReceipt, parReceiptWares) > 0); } }
/// <summary> /// Повертає фактичну кількість після вставки(добавляє до текучої кількості - -1 якщо помилка; /// </summary> /// <param name="parParameters"></param> /// <returns></returns> public override bool AddWares(ReceiptWares parReceiptWares) { using (var DB = new SQLite(ReceiptFile)) { return(DB.ExecuteNonQuery <ReceiptWares>(SqlInsertWaresReceipt, parReceiptWares) > 0 /*&& RecalcHeadReceipt((IdReceipt)parReceiptWares)*/); } }
public override bool DeleteWaresReceiptPromotion(IdReceipt parIdReceipt) { using (var DB = new SQLite(ReceiptFile)) { DB.ExecuteNonQuery <IdReceipt>(SqlDeleteWaresReceiptPromotion, parIdReceipt); } return(true); }
public override bool InsertBarCode2Cat(WaresReceiptPromotion parWRP) { using (var DB = new SQLite(ReceiptFile)) { DB.ExecuteNonQuery <WaresReceiptPromotion>(SqlInsertBarCode2Cat, parWRP); } return(true); }
public override bool SetStateReceipt(Receipt parReceipt) { using (var DB = new SQLite(ReceiptFile)) { DB.ExecuteNonQuery <Receipt>(SqlSetStateReceipt, parReceipt); } return(true); }
public override bool UpdateQR(ReceiptWares pRW) { using (var DB = new SQLite(ReceiptFile)) { return(DB.ExecuteNonQuery <ReceiptWares>(SqlUpdateQR, pRW) > 0); } //return true; }
public override bool MoveReceipt(ParamMoveReceipt parMoveReceipt) { using (var DB = new SQLite(ReceiptFile)) { DB.ExecuteNonQuery <ParamMoveReceipt>(SqlMoveReceipt, parMoveReceipt); } return(true); }
public bool CreateMIDIndex() { using (var DB = new SQLite(MidFile)) { DB.ExecuteNonQuery(SqlCreateMIDIndex); } return(true); }
public override bool UpdateQuantityWares(ReceiptWares parReceiptWares) { using (var DB = new SQLite(ReceiptFile)) { lock (GetObjectForLockByIdWorkplace(parReceiptWares.IdWorkplace)) { return(DB.ExecuteNonQuery(SqlUpdateQuantityWares, parReceiptWares) > 0 /*&& RecalcHeadReceipt(parParameters)*/); } } }
public override bool CloseReceipt(Receipt parReceipt) { using (var DB = new SQLite(ReceiptFile)) { lock (GetObjectForLockByIdWorkplace(parReceipt.IdWorkplace)) { return(DB.ExecuteNonQuery <Receipt>(SqlCloseReceipt, parReceipt) > 0); } } }
public override bool UpdateClient(IdReceipt parIdReceipt, int parCodeClient) { using (var DB = new SQLite(ReceiptFile)) { lock (GetObjectForLockByIdWorkplace(parIdReceipt.IdWorkplace)) { return(DB.ExecuteNonQuery <IdReceipt>(SqlUpdateClient, parIdReceipt) > 0); } } }
/////////////////////////////////////////////////////////////////// /// Переробляю через відкриття закриття конекта. /////////////////////////////////////////////////////////////////// /// ///////////////// Config public override bool SetConfig <T>(string parName, T parValue, SQL pDB = null) { using (var DB = new SQLite(ConfigFile)) { if (pDB == null) { DB.ExecuteNonQuery <object>(this.SqlReplaceConfig, new { NameVar = parName, DataVar = parValue, @TypeVar = parValue.GetType().ToString() }); } else { pDB.ExecuteNonQuery <object>(this.SqlReplaceConfig, new { NameVar = parName, DataVar = parValue, @TypeVar = parValue.GetType().ToString() }); } } return(true); }
public override bool ReplacePayment(IEnumerable <Payment> parData) { using (var DB = new SQLite(ReceiptFile)) { if (parData != null && parData.Count() > 0) { if (parData.Count() == 1)//Костиль через проблеми з мультипоточністю BD { DB.ExecuteNonQuery <Payment>(SqlReplacePayment, parData.First()); } else { DB.BulkExecuteNonQuery <Payment>(SqlReplacePayment, parData); } } } return(true); }
protected (int, bool) Parse(string[] pLines, int pCurVersion, SQLite pDB) { int NewVer = pCurVersion, Ver; bool isReload = false; foreach (var el in pLines) { var i = el.IndexOf("VER=>"); if (i >= 0) { string str = el.Substring(i + 5); string[] All = str.Split(';'); if (int.TryParse(All[0], out Ver)) { if (Ver > pCurVersion) { try { pDB.ExecuteNonQuery(el); if (All.Length > 1 && All[1].Equals("Reload".ToUpper())) { isReload = true; } } catch (Exception e) { if (e.Message.IndexOf("duplicate column name:") == -1) { throw new Exception(e.Message, e); } } } if (NewVer <= Ver) { NewVer = Ver; } } } } return(NewVer, isReload); }
public WDB_SQLite(DateTime parD = default(DateTime), string parConnect = "", bool pIsUseOldDB = false) : base(Path.Combine(Global.PathIni, "SQLite.sql")) { Connect = parConnect; varVersion = "SQLite.0.0.1"; DT = parD != default(DateTime) ? parD.Date : DateTime.Today.Date; InitSQL(); if (IsFirstStart) { UpdateDB(ref pIsUseOldDB); } if (!File.Exists(ConfigFile)) { db = new SQLite(ConfigFile); db.ExecuteNonQuery(SqlCreateConfigTable); db.Close(); } //db = new SQLite(ConfigFile);//,"",this.varCallWriteLogSQL); if (!File.Exists(ReceiptFile)) { var receiptFilePath = Path.GetDirectoryName(ReceiptFile); if (!Directory.Exists(receiptFilePath)) { Directory.CreateDirectory(receiptFilePath); } //Створюємо щоденну табличку з чеками. var db = new SQLite(ReceiptFile); db.ExecuteNonQuery(SqlCreateReceiptTable); db.Close(); db = null; } if (!File.Exists(MidFile)) { if (pIsUseOldDB) { db = new SQLite(ConfigFile); var varLastMidFile = GetConfig <string>("Last_MID"); db = null; if (!string.IsNullOrEmpty(varLastMidFile) && File.Exists(varLastMidFile)) { LastMidFile = varLastMidFile; } } if (!pIsUseOldDB || string.IsNullOrEmpty(LastMidFile)) { var db = new SQLite(MidFile); db.ExecuteNonQuery(SqlCreateMIDTable); db.Close(); db = null; } } /* * if (pTypeDb == eTypeDb.AllMid || pTypeDb == eTypeDb.AllRC) * { * if (pTypeDb == eTypeDb.AllMid) * { * db = new SQLite(MidFile); * db.ExecuteNonQuery("ATTACH '" + ReceiptFile + "' AS rc"); * } * else * { * db = new SQLite(ReceiptFile); * db.ExecuteNonQuery("ATTACH '" + MidFile + "' AS mid"); * //db.ExecuteNonQuery("ATTACH '" + ConfigFile + "' AS con"); * } * db.ExecuteNonQuery("ATTACH '" + ConfigFile + "' AS con"); * } * * if(pTypeDb == eTypeDb.Mid) * db = new SQLite(MidFile); * * if(pTypeDb == eTypeDb.RC) * db = new SQLite(ReceiptFile); * * if (pTypeDb == eTypeDb.Config) * db = new SQLite(ConfigFile); */ db = new SQLite(ReceiptFile); db.ExecuteNonQuery("ATTACH '" + MidFile + "' AS mid"); db.ExecuteNonQuery("ATTACH '" + ConfigFile + "' AS con"); db.ExecuteNonQuery("PRAGMA synchronous = EXTRA;"); db.ExecuteNonQuery("PRAGMA journal_mode = DELETE;"); db.ExecuteNonQuery("PRAGMA wal_autocheckpoint = 5;"); }