public int LoadData(WDB pDB, bool parIsFull, StringBuilder Log)
{
string SQL;
Log.Append($"\n{ DateTime.Now:yyyy-MM-dd h:mm:ss.fffffff} Start LoadData {parIsFull}");
Debug.WriteLine("Start LoadData " + parIsFull.ToString());
SQL = GetSQL("SqlGetMessageNo");
int varMessageNoMax = db.ExecuteScalar <int>(SQL);
int varMessageNoMin = pDB.GetConfig <int>("MessageNo");
var oWarehouse = new pWarehouse()
{
CodeWarehouse = Global.CodeWarehouse
};
var oMessage = new pMessage()
{
IsFull = parIsFull ? 1 : 0, MessageNoMin = varMessageNoMin, MessageNoMax = varMessageNoMax, CodeWarehouse = Global.CodeWarehouse
};
Debug.WriteLine("SqlGetDimPrice");
SQL = GetSQL("SqlGetDimPrice");
var PD = db.Execute <pMessage, Price>(SQL, oMessage);
pDB.ReplacePrice(PD);
Log.Append($"\n{ DateTime.Now:yyyy-MM-dd h:mm:ss.fffffff} SqlGetDimPrice => {PD.Count()}");
PD = null;
Debug.WriteLine("SqlGetUser");
SQL = GetSQL("SqlGetUser");
var PU = db.Execute <pMessage, User>(SQL, oMessage);
pDB.ReplaceUser(PU);
Log.Append($"\n{ DateTime.Now:yyyy-MM-dd h:mm:ss.fffffff} SqlGetDimPrice => {PU.Count()}");
PU = null;
Debug.WriteLine("SqlSalesBan");
SQL = GetSQL("SqlSalesBan");
var SB = db.Execute <pWarehouse, SalesBan>(SQL, oWarehouse);
pDB.ReplaceSalesBan(SB);
Log.Append($"\n{ DateTime.Now:yyyy-MM-dd h:mm:ss.fffffff} SqlSalesBan => {SB.Count()}");
SB = null;
Debug.WriteLine("SqlGetPromotionSaleGift");
SQL = GetSQL("SqlGetPromotionSaleGift");
var PSGf = db.Execute <pWarehouse, PromotionSaleGift>(SQL, oWarehouse);
pDB.ReplacePromotionSaleGift(PSGf);
Log.Append($"\n{ DateTime.Now:yyyy-MM-dd h:mm:ss.fffffff} SqlGetPromotionSaleGift => {PSGf.Count()}");
PSGf = null;
Debug.WriteLine("SqlGetPromotionSaleGroupWares");
SQL = GetSQL("SqlGetPromotionSaleGroupWares");
var PSGW = db.Execute <pWarehouse, PromotionSaleGroupWares>(SQL, oWarehouse);
if (PSGW != null)
{
pDB.ReplacePromotionSaleGroupWares(PSGW);
Log.Append($"\n{ DateTime.Now:yyyy-MM-dd h:mm:ss.fffffff} SqlGetPromotionSaleGroupWares => {PSGW.Count()}");
PSGW = null;
}
Debug.WriteLine("SqlGetPromotionSale");
SQL = GetSQL("SqlGetPromotionSale");
var PS = db.Execute <pWarehouse, PromotionSale>(SQL, oWarehouse);
pDB.ReplacePromotionSale(PS);
Log.Append($"\n{ DateTime.Now:yyyy-MM-dd h:mm:ss.fffffff} SqlGetPromotionSale => {PS.Count()}");
PS = null;
Debug.WriteLine("SqlGetPromotionSaleFilter");
SQL = GetSQL("SqlGetPromotionSaleFilter");
var PSF = db.Execute <pWarehouse, PromotionSaleFilter>(SQL, oWarehouse);
pDB.ReplacePromotionSaleFilter(PSF);
Log.Append($"\n{ DateTime.Now:yyyy-MM-dd h:mm:ss.fffffff} SqlGetPromotionSaleFilter => {PSF.Count()}");
PSF = null;
Debug.WriteLine("SqlGetPromotionSaleData");
SQL = GetSQL("SqlGetPromotionSaleData");
var PSD = db.Execute <pWarehouse, PromotionSaleData>(SQL, oWarehouse);
pDB.ReplacePromotionSaleData(PSD);
Log.Append($"\n{ DateTime.Now:yyyy-MM-dd h:mm:ss.fffffff} SqlGetPromotionSaleData => {PSD.Count()}");
PSD = null;
Debug.WriteLine("SqlGetPromotionSaleDealer");
SQL = GetSQL("SqlGetPromotionSaleDealer");
var PSP = db.Execute <pWarehouse, PromotionSaleDealer>(SQL, oWarehouse);
pDB.ReplacePromotionSaleDealer(PSP);
Log.Append($"\n{ DateTime.Now:yyyy-MM-dd h:mm:ss.fffffff} SqlGetPromotionSaleDealer =>{PSP.Count()}");
PSP = null;
Debug.WriteLine("SqlGetPromotionSale2Category");
SQL = GetSQL("SqlGetPromotionSale2Category");
var PS2c = db.Execute <pWarehouse, PromotionSale2Category>(SQL, oWarehouse);
pDB.ReplacePromotionSale2Category(PS2c);
Log.Append($"\n{ DateTime.Now:yyyy-MM-dd h:mm:ss.fffffff} SqlGetPromotionSale2Category => {PS2c.Count()}");
PS2c = null;
Debug.WriteLine("SqlGetMRC");
SQL = GetSQL("SqlGetMRC");
var MRC = db.Execute <pWarehouse, MRC>(SQL, oWarehouse);
pDB.ReplaceMRC(MRC);
Log.Append($"\n{ DateTime.Now:yyyy-MM-dd h:mm:ss.fffffff} SqlGetMRC => {MRC.Count()}");
MRC = null;
Debug.WriteLine("SqlGetDimClient");
SQL = GetSQL("SqlGetDimClient");
var Cl = db.Execute <pMessage, Client>(SQL, oMessage);
pDB.ReplaceClient(Cl);
Log.Append($"\n{ DateTime.Now:yyyy-MM-dd h:mm:ss.fffffff} SqlGetDimClient => {Cl.Count()}");
Cl = null;
Debug.WriteLine("SqlGetDimWares");
SQL = GetSQL("SqlGetDimWares");
var W = db.Execute <pMessage, Wares>(SQL, oMessage);
pDB.ReplaceWares(W);
Log.Append($"\n{ DateTime.Now:yyyy-MM-dd h:mm:ss.fffffff} SqlGetDimWares => {W.Count()}");
W = null;
Debug.WriteLine("SqlGetDimAdditionUnit");
SQL = GetSQL("SqlGetDimAdditionUnit");
var AU = db.Execute <pMessage, AdditionUnit>(SQL, oMessage);
pDB.ReplaceAdditionUnit(AU);
Log.Append($"\n{ DateTime.Now:yyyy-MM-dd h:mm:ss.fffffff} SqlGetDimAdditionUnit => {AU.Count()}");
AU = null;
Debug.WriteLine("SqlGetDimBarCode");
SQL = GetSQL("SqlGetDimBarCode");
var BC = db.Execute <pMessage, Barcode>(SQL, oMessage);
pDB.ReplaceBarCode(BC);
Log.Append($"\n{ DateTime.Now:yyyy-MM-dd h:mm:ss.fffffff} SqlGetDimBarCode => { BC.Count()}");
BC = null;
Debug.WriteLine("SqlGetDimUnitDimension");
SQL = GetSQL("SqlGetDimUnitDimension");
var UD = db.Execute <UnitDimension>(SQL);
pDB.ReplaceUnitDimension(UD);
Log.Append($"\n{ DateTime.Now:yyyy-MM-dd h:mm:ss.fffffff} SqlGetDimUnitDimension => { UD.Count()}");
UD = null;
Debug.WriteLine("SqlGetDimGroupWares");
SQL = GetSQL("SqlGetDimGroupWares");
var GW = db.Execute <GroupWares>(SQL);
pDB.ReplaceGroupWares(GW);
Log.Append($"\n{ DateTime.Now:yyyy-MM-dd h:mm:ss.fffffff} SqlGetDimGroupWares => { GW.Count()}");
GW = null;
Debug.WriteLine("SqlGetDimTypeDiscount");
SQL = GetSQL("SqlGetDimTypeDiscount");
var TD = db.Execute <TypeDiscount>(SQL);
pDB.ReplaceTypeDiscount(TD);
Log.Append($"\n{ DateTime.Now:yyyy-MM-dd h:mm:ss.fffffff} SqlGetDimTypeDiscount => { TD.Count()}");
TD = null;
Debug.WriteLine("SqlGetDimFastGroup");
SQL = GetSQL("SqlGetDimFastGroup");
var FG = db.Execute <pWarehouse, FastGroup>(SQL, oWarehouse);
pDB.ReplaceFastGroup(FG);
Log.Append($"\n{ DateTime.Now:yyyy-MM-dd h:mm:ss.fffffff} SqlGetDimFastGroup => { FG.Count()}");
FG = null;
Debug.WriteLine("SqlGetDimFastWares");
SQL = GetSQL("SqlGetDimFastWares");
var FW = db.Execute <pWarehouse, FastWares>(SQL, oWarehouse);
pDB.ReplaceFastWares(FW);
Log.Append($"\n{ DateTime.Now:yyyy-MM-dd h:mm:ss.fffffff} SqlGetDimFastWares => { FW.Count()}");
FW = null;
//Пакети
var GWL = new List <FastWares>();
foreach (var el in Global.Bags)
{
GWL.Add(new FastWares {
CodeFastGroup = Global.CodeFastGroupBag, CodeWares = el
});
}
pDB.ReplaceFastWares(GWL);
Log.Append($"\n{ DateTime.Now:yyyy-MM-dd h:mm:ss.fffffff} FastWares => { GWL.Count()}");
GWL = null;
Log.Append($"\n{ DateTime.Now:yyyy-MM-dd h:mm:ss.fffffff} MessageNo {varMessageNoMax}\n");
return(varMessageNoMax);
}
/// <summary>
/// Оновлення структури бази даних
/// </summary>
protected override void UpdateDB(ref bool pIsUseOld)
{
try
{
IsFirstStart = false;
int CurVerConfig = 0, CurVerMid = 0, CurVerRC = 0;
var Lines = SqlUpdateConfig.Split(new string[] { "\r\n", "\r", "\n" }, StringSplitOptions.None);
SQLite dbC = new SQLite(ConfigFile);
var wDB = new WDB(Path.Combine(Global.PathIni, "SQLite.sql"), dbC);
CurVerConfig = wDB.GetConfig <int>("VerConfig");
CurVerMid = wDB.GetConfig <int>("VerMid");
CurVerRC = wDB.GetConfig <int>("VerRC");
//Config
var(Ver, IsReload) = Parse(Lines, CurVerConfig, dbC);
if (Ver != CurVerConfig)
{
wDB.SetConfig <int>("VerConfig", Ver);
}
//Mid
if (File.Exists(MidFile))
{
var dbMID = new SQLite(MidFile);
CurVerMid = wDB.GetConfig <int>("VerMID");
Lines = SqlUpdateMID.Split(new string[] { "\r\n", "\r", "\n" }, StringSplitOptions.None);
(Ver, IsReload) = Parse(Lines, CurVerMid, dbMID);
dbMID.Close(true);
if (IsReload)
{
if (File.Exists(MidFile))
{
File.Delete(MidFile);
}
pIsUseOld = false;
}
if (Ver != CurVerMid)
{
wDB.SetConfig <int>("VerMID", Ver);
}
}
//RC
CurVerRC = wDB.GetConfig <int>("VerRC");
var cDT = DateTime.Now.Date.AddDays(-10);
while (cDT <= DateTime.Now.Date)
{
if (File.Exists(GetReceiptFile(cDT)))
{
var dbRC = new SQLite(GetReceiptFile(cDT));
Lines = SqlUpdateRC.Split(new string[] { "\r\n", "\r", "\n" }, StringSplitOptions.None);
(Ver, IsReload) = Parse(Lines, CurVerRC, dbRC);
}
cDT = cDT.AddDays(1);
}
if (Ver != CurVerRC)
{
wDB.SetConfig <int>("VerRC", Ver);
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}