T007_BatFile_DatFile

 
007_BatFile_DatFile ================================
【ArmPos Hospitality Tutorial】 課程編號: 92f3f51d-78fb-4f87-b770-3839a40e98d2 ----------- 此講義目錄 : https://aclasarmpos.blogspot.com/p/armpos-internal-tutorial.html 此講義YouTube PlayList : ArmPos Hospitality Tutorial(All) https://youtube.com/playlist?list=PLGa5Tzn6r8qHGqXwzy0_i4JAi21sl37u_ ArmPos Hospitality Tutorial(Internal) https://youtube.com/playlist?list=PLGa5Tzn6r8qHhvRh9-tuS3xpQgwMcz9Kp ArmPos Hospitality Tutorial(Customer) https://youtube.com/playlist?list=PLGa5Tzn6r8qFIcfl2r0Jd2lpnYw_5_ve5 SampleFile : https://drive.google.com/drive/folders/1FQKoWkFSMrNrEMN4Gdv6ECMygtHsgg54?usp=sharing ----------- 講義部落格 : https://aclasarmpos.blogspot.com/ Youtube PlayList : https://www.youtube.com/channel/UCyvy6XeA1tS73JpJtjlaRTQ/playlists ================================ ---------------------------- Internal Training : All Customer Training : None ---------------------------- T007_BatFile_DatFile https://aclasarmpos.blogspot.com/2022/03/t007batfiledatfile.html
================================ 1. Summary ================================

================================

1. Summary

-------------------------------------------------------------------------------------------------------------------------------------------------

Summary

-------------------------------------------------------------------------------------------------------------------------------------------------

1.

"DatFile" is one kind of "SQLServer" back up file for whole database which including your sales data, menu data, and more.

I would suggest you to create a "DatFile" to backup your data daily or weekly.

I also suggest you to back up your "DatFile" to "Dropbox, GoogleDrive" or to your portable external hard drive.

------------------------------------------------------------------------------------------------------------------------------------

2.

By default, All the "DatFile" was in the following "Directory"

C:\Program Files (x86)\CYEcrPC\DBBackup\

The "FileName" of "DatFile" should be "yyyymmdd_StoreName_Reason".

------------------------------------------------------------------------------------------------------------------------------------

3.

Dat File

-------------------------------------------------------------------------------------------------------------------------

3.1.

DBBackup\20211207_BlankMenu.dat

"DatFile" is one kind of "SQLServer" back up file for whole database which including your sales data, menu data, and more.

"DBBackup\20211207_BlankMenu.dat" is the "BlankDatabase" for "Armpos Hospitality"

which means there is no "Category", no "Item", and no "SalesRecord".

----------------------------------------------

"DatFile"是一種"SQLServer"備份檔案，可以備份整個資料庫，包括你的銷售紀錄，菜單，和其他。

"DBBackup\20211207_BlankMenu.dat"是"Armpos Hospitality"的"BlankDatabase"(空白資料庫)

這意思是其沒有"Category"(菜單種類)、沒有"Item"(菜單物件)、沒有"SalesRecord"(銷售紀錄)。

------------------------------------------------------------------------------------------------------------------------------------

4.

BAT File

-------------------------------------------------------------------------------------------------------------------------

4.0.

"BatFile" is a set of command lines.  

When you execute the "BatFile", it would execute a set of command lines.

-------------------------------------------------------------------------------------------------------------------------

4.1.

ArmposHospitality_DeleteCategoryAndItemAndSales.bat

Delete all "Category" and "Item" and "SalesRecords" in "ArmposHospitality".

刪除"ArmposHospitality"裡面所有的"Category"和"Item"和"SalesRecords"。

-------------------------------------------------------------------------------------------------------------------------

4.2.

ArmposHospitality_DeleteSales.bat

Delete all "SalesRecords" in "ArmposHospitality".

刪除"ArmposHospitality"裡面所有的"SalesRecords"(銷售紀錄)

-------------------------------------------------------------------------------------------------------------------------

4.3.

ArmposRetail_DeleteCategoryAndItemAndSales.bat

Delete all "Category" and "Item" and "SalesRecords" in "ArmposRetail".

刪除"ArmposRetail"裡面所有的"Category"和"Item"和"SalesRecords"。

-------------------------------------------------------------------------------------------------------------------------

4.4.

ArmposRetail_DeletePromotion.bat

Delete all "Promotion(Discount)" in "ArmposRetail".

刪除"ArmposRetail"裡面所有的"Promotion(Discount)"(打折優惠)

-------------------------------------------------------------------------------------------------------------------------

4.5.

ArmposRetail_DeleteSales.bat

Delete all "sales records" in "ArmposRetail".

刪除"ArmposRetail"裡面所有的"sales records"(銷售紀錄)

-------------------------------------------------------------------------------------------------------------------------

4.6.

ArmposRetail_SetStockQuantityToZero.bat

Set the "Stock Quantity" to "0" for all "Items" in "ArmposRetail".

把"ArmposRetail"裡面所有的"Items"的"Stock Quantity"都設為"0"。

-------------------------------------------------------------------------------------------------------------------------------------------------