Changeset 146 for trunk/Modules/Finance/ModuleFinance.pas
- Timestamp:
- Dec 29, 2023, 11:44:26 PM (11 months ago)
- File:
-
- 1 moved
Legend:
- Unmodified
- Added
- Removed
-
trunk/Modules/Finance/ModuleFinance.pas
r145 r146 1 unit UModuleFinance;1 unit ModuleFinance; 2 2 3 3 interface 4 4 5 5 uses 6 Classes, SysUtils, UModularSystem, UModuleBase, UWebPage;6 Classes, SysUtils, UModularSystem, ModuleBase, UWebPage; 7 7 8 8 type … … 26 26 27 27 uses 28 UCore, UPageFinance, USqlDatabase;28 Core, PageFinance, USqlDatabase; 29 29 30 30 { TModuleFinance } … … 67 67 DbRows := TDbRows.Create; 68 68 69 Core.Co mmonDatabase.Query(DbRows,69 Core.Core.CommonDatabase.Query(DbRows, 70 70 'CREATE TABLE IF NOT EXISTS `FinanceTariff` (' + 71 71 ' `Id` int(11) NOT NULL AUTO_INCREMENT,' + … … 84 84 ') ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=1 ;'); 85 85 86 Core.Co mmonDatabase.Query(DbRows,86 Core.Core.CommonDatabase.Query(DbRows, 87 87 'CREATE TABLE IF NOT EXISTS `FinanceYear` (' + 88 88 ' `Id` int(11) NOT NULL AUTO_INCREMENT,' + … … 93 93 ') ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=1 ;'); 94 94 95 Core.Co mmonDatabase.Query(DbRows,95 Core.Core.CommonDatabase.Query(DbRows, 96 96 'CREATE TABLE IF NOT EXISTS `DocumentLine` (' + 97 97 ' `Id` int(11) NOT NULL AUTO_INCREMENT,' + … … 102 102 ') ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=1; '); 103 103 104 Core.Co mmonDatabase.Query(DbRows,104 Core.Core.CommonDatabase.Query(DbRows, 105 105 'CREATE TABLE IF NOT EXISTS `DocumentLineSequence` (' + 106 106 ' `Id` int(11) NOT NULL AUTO_INCREMENT,' + … … 114 114 ') ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=1 ;'); 115 115 116 Core.Co mmonDatabase.Query(DbRows,116 Core.Core.CommonDatabase.Query(DbRows, 117 117 'CREATE TABLE IF NOT EXISTS `FinanceBankAccount` (' + 118 118 ' `Id` int(11) NOT NULL AUTO_INCREMENT,' + … … 123 123 ') ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=1; '); 124 124 125 Core.Co mmonDatabase.Query(DbRows,125 Core.Core.CommonDatabase.Query(DbRows, 126 126 'CREATE TABLE IF NOT EXISTS `FinanceBillingPeriod` (' + 127 127 ' `Id` int(11) NOT NULL AUTO_INCREMENT,' + … … 144 144 try 145 145 DbRows := TDbRows.Create; 146 Core.Co mmonDatabase.Query(DbRows, 'DROP TABLE IF EXISTS `FinanceBillingPeriod`');147 Core.Co mmonDatabase.Query(DbRows, 'DROP TABLE IF EXISTS `FinanceBankAccount`');148 Core.Co mmonDatabase.Query(DbRows, 'DROP TABLE IF EXISTS `DocumentLine`');149 Core.Co mmonDatabase.Query(DbRows, 'DROP TABLE IF EXISTS `DocumentLineSequence`');150 Core.Co mmonDatabase.Query(DbRows, 'DROP TABLE IF EXISTS `FinanceTariff`');151 Core.Co mmonDatabase.Query(DbRows, 'DROP TABLE IF EXISTS `FinanceYear`');146 Core.Core.CommonDatabase.Query(DbRows, 'DROP TABLE IF EXISTS `FinanceBillingPeriod`'); 147 Core.Core.CommonDatabase.Query(DbRows, 'DROP TABLE IF EXISTS `FinanceBankAccount`'); 148 Core.Core.CommonDatabase.Query(DbRows, 'DROP TABLE IF EXISTS `DocumentLine`'); 149 Core.Core.CommonDatabase.Query(DbRows, 'DROP TABLE IF EXISTS `DocumentLineSequence`'); 150 Core.Core.CommonDatabase.Query(DbRows, 'DROP TABLE IF EXISTS `FinanceTariff`'); 151 Core.Core.CommonDatabase.Query(DbRows, 'DROP TABLE IF EXISTS `FinanceYear`'); 152 152 finally 153 153 DbRows.Free;
Note:
See TracChangeset
for help on using the changeset viewer.