?? frmlogin.~cpp
字號:
sql=sql+"GDS_BZ char(40) NULL) ON [PRIMARY]";
database2->Execute(sql, NULL, false, NULL); //創建數據庫索引
sql="";
sql=sql+"CREATE TABLE dbo.H_YEAR ";
sql=sql+"(Y_ID int NOT NULL IDENTITY (1, 1),";
sql=sql+"Y_YEAR char(4) NOT NULL CONSTRAINT DF_H_YEAR_HY_YEAR DEFAULT ('2002')) ON [PRIMARY]";
database2->Execute(sql, NULL, false, NULL); //創建數據庫索引
sql="";
sql=sql+"CREATE TABLE dbo.HSDW ";
sql=sql+"(XT_DWDM char(10) NULL,";
sql=sql+"XT_DWMC char(32) NULL,";
sql=sql+"XT_FZR char(10) NULL,";
sql=sql+"XT_LXDH char(10) NULL,";
sql=sql+"XT_KHYH char(32) NULL,";
sql=sql+"XT_YHZH char(16) NULL,";
sql=sql+"XT_QYRQ datetime NULL,";
sql=sql+"XT_PQBM char(7) NULL) ON [PRIMARY]";
database2->Execute(sql, NULL, false, NULL); //創建數據庫索引
sql="";
sql=sql+"CREATE NONCLUSTERED INDEX IX_dwxx ON dbo.HSDW ";
sql=sql+"(XT_DWDM) ON [PRIMARY]";
database2->Execute(sql, NULL, false, NULL); //創建數據庫索引
sql="";
sql=sql+"CREATE TABLE dbo.HYDM ";
sql=sql+"(HY_ID int NOT NULL IDENTITY (1, 1),";
sql=sql+"HY_HYDM char(2) NULL,";
sql=sql+"HY_HYMC char(40) NULL,";
sql=sql+"HY_BZ char(16) NULL) ON [PRIMARY]";
database2->Execute(sql, NULL, false, NULL); //創建數據庫索引
sql="";
sql=sql+"CREATE TABLE dbo.jjxm ";
sql=sql+"(fj_id int NOT NULL IDENTITY (1, 1),";
sql=sql+"fj_jjdm char(2) NULL,";
sql=sql+"fj_jjmc char(8) NULL,";
sql=sql+"fj_jjdj decimal(18, 0) NULL,";
sql=sql+"fj_jjbz char(20) NULL) ON [PRIMARY]";
database2->Execute(sql, NULL, false, NULL); //創建數據庫索引
sql="";
sql=sql+"CREATE TABLE dbo.JXGX0000 ";
sql=sql+"(id int NOT NULL IDENTITY (1, 1),";
sql=sql+"hhhh char(10) NOT NULL,";
sql=sql+"dbbh char(4) NULL,";
sql=sql+"hhhhf char(10) NULL,";
sql=sql+"dbbhf char(4) NULL,";
sql=sql+"lb char(5) NULL,";
sql=sql+"dea char(1) NULL) ON [PRIMARY]";
database2->Execute(sql, NULL, false, NULL); //創建數據庫索引
sql="";
sql=sql+"CREATE NONCLUSTERED INDEX IX_JXGX0000 ON dbo.JXGX0000 ";
sql=sql+"(hhhh) ON [PRIMARY]";
database2->Execute(sql, NULL, false, NULL); //創建數據庫索引
sql="";
sql=sql+"CREATE TABLE dbo.PQDM ";
sql=sql+"(ID int NOT NULL IDENTITY (1, 1),";
sql=sql+"PQDM char(12) NOT NULL,";
sql=sql+"PQMC char(24) NOT NULL,";
sql=sql+"BZ char(50) NULL) ON [PRIMARY]";
database2->Execute(sql, NULL, false, NULL); //創建數據庫索引
sql="";
sql=sql+"CREATE UNIQUE CLUSTERED INDEX IX_PQDM ON dbo.PQDM ";
sql=sql+"(PQDM) ON [PRIMARY]";
database2->Execute(sql, NULL, false, NULL); //創建數據庫索引
sql="";
sql=sql+"CREATE TABLE dbo.XLCS ";
sql=sql+"(ID int NOT NULL IDENTITY (1, 1),";
sql=sql+"XLBH char(10) NULL,";
sql=sql+"XLMC char(24) NULL,";
sql=sql+"XLDY char(16) NULL,";
sql=sql+"XLCD numeric(8, 2) NULL,";
sql=sql+"XLLB char(16) NULL,";
sql=sql+"RXRL numeric(8, 0) NULL,";
sql=sql+"YXFH numeric(8, 0) NULL,";
sql=sql+"XLTGS int NULL,";
sql=sql+"XLGDS char(16) NULL,";
sql=sql+"XLBZ char(16) NULL) ON [PRIMARY]";
database2->Execute(sql, NULL, false, NULL); //創建數據庫索引
sql="";
sql=sql+"CREATE TABLE dbo.XTCS ";
sql=sql+"(XT_ID int NOT NULL IDENTITY (1, 1),";
sql=sql+"XT_QZSF char(1) NULL CONSTRAINT DF_XTCS_XT_QZSF DEFAULT ('0'),";
sql=sql+"XT_HHQSH decimal(18, 0) NULL CONSTRAINT DF_XTCS_XT_HHQSH DEFAULT (0),";
sql=sql+"XT_FPQSH decimal(18, 0) NULL CONSTRAINT DF_XTCS_XT_FPQSH DEFAULT (0),";
sql=sql+"XT_HSQX char(7) NULL,";
sql=sql+"XT_WGFDJ decimal(18, 5) NULL CONSTRAINT DF_XTCS_XT_WGFDJ DEFAULT (0),";
sql=sql+"XT_TJDF char(30) NULL,";
sql=sql+"XT_TYDF char(30) NULL,";
sql=sql+"XT_DLYH char(30) NULL,";
sql=sql+"XT_CS11 char(30) NULL) ON [PRIMARY]";
database2->Execute(sql, NULL, false, NULL); //創建數據庫索引
sql="";
sql=sql+"CREATE TABLE dbo.YDFL ";
sql=sql+"(fl_id int NOT NULL IDENTITY (1, 1),";
sql=sql+"fl_dm char(2) NULL,";
sql=sql+"fl_mc char(8) NULL,";
sql=sql+"fl_bkdj char(64) NULL) ON [PRIMARY]";
database2->Execute(sql, NULL, false, NULL); //創建數據庫索引
sql="";
sql=sql+"CREATE TABLE dbo.YDMENU ";
sql=sql+"(ID int NOT NULL IDENTITY (1, 1),";
sql=sql+"NAME char(10) NULL,";
sql=sql+"JC char(3) NULL,";
sql=sql+"SJ int NULL,";
sql=sql+"CDXM char(20) NULL) ON [PRIMARY]";
database2->Execute(sql, NULL, false, NULL); //創建數據庫索引
sql="";
sql=sql+"CREATE TABLE dbo.YHDA0000 ";
sql=sql+"(yhda_id int NOT NULL IDENTITY (1, 1),";
sql=sql+"hsqx char(7) NULL,";
sql=sql+"hhhh char(10) NOT NULL,";
sql=sql+"yhmc char(20) NOT NULL,";
sql=sql+"yhdz char(40) NULL,";
sql=sql+"gds char(30) NULL,";
sql=sql+"klbs char(30) NULL,";
sql=sql+"dz char(30) NULL,";
sql=sql+"xzq char(12) NULL,";
sql=sql+"ydfl char(6) NULL,";
sql=sql+"gddy char(16) NULL,";
sql=sql+"byqxh char(12) NULL,";
sql=sql+"jffs char(8) NULL,";
sql=sql+"kplb char(4) NULL,";
sql=sql+"bzrl decimal(10, 0) NULL CONSTRAINT DF_YHDA0000_bzrl DEFAULT (0),";
sql=sql+"syrl decimal(10, 0) NULL CONSTRAINT DF_YHDA0000_syrl DEFAULT (0),";
sql=sql+"jbdj decimal(5, 2) NULL CONSTRAINT DF_YHDA0000_jbdj DEFAULT (0),";
sql=sql+"jbdf decimal(12, 2) NULL CONSTRAINT DF_YHDA0000_jbdf DEFAULT (0),";
sql=sql+"yxzt char(4) NULL,";
sql=sql+"zj char(12) NULL,";
sql=sql+"yxts decimal(2, 0) NULL CONSTRAINT DF_YHDA0000_yxts DEFAULT (30),";
sql=sql+"bz char(2) NULL,";
sql=sql+"zjwgdl decimal(10, 0) NULL CONSTRAINT DF_YHDA0000_zjwgdl DEFAULT (0),";
sql=sql+"zjygdl decimal(10, 0) NULL CONSTRAINT DF_YHDA0000_zjygdl DEFAULT (0),";
sql=sql+"bzll decimal(4, 2) NULL CONSTRAINT DF_YHDA0000_bzll DEFAULT (0),";
sql=sql+"byll decimal(5, 2) NULL CONSTRAINT DF_YHDA0000_byll DEFAULT (0),";
sql=sql+"jfbl decimal(8, 5) NULL CONSTRAINT DF_YHDA0000_jfbl DEFAULT (0),";
sql=sql+"lldf decimal(12, 2) NULL CONSTRAINT DF_YHDA0000_lldf DEFAULT (0),";
sql=sql+"sdl decimal(10, 2) NULL CONSTRAINT DF_YHDA0000_sdl DEFAULT (0),";
sql=sql+"dddf decimal(12, 2) NULL CONSTRAINT DF_YHDA0000_dddf DEFAULT (0),";
sql=sql+"fjf decimal(12, 2) NULL CONSTRAINT DF_YHDA0000_fjf DEFAULT (0),";
sql=sql+"zjdf decimal(12, 2) NULL CONSTRAINT DF_YHDA0000_zjdf DEFAULT (0),";
sql=sql+"wgf decimal(12, 2) NULL CONSTRAINT DF_YHDA0000_wgf DEFAULT (0),";
sql=sql+"www decimal(12, 2) NULL CONSTRAINT DF_YHDA0000_www DEFAULT (0),";
sql=sql+"hjdf decimal(12, 2) NULL CONSTRAINT DF_YHDA0000_hjdf DEFAULT (0),";
sql=sql+"tjbsdl decimal(10, 2) NULL CONSTRAINT DF_YHDA0000_tjbsdl DEFAULT (0),";
sql=sql+"tjxsdl decimal(10, 2) NULL CONSTRAINT DF_YHDA0000_tjxsdl DEFAULT (0),";
sql=sql+"yjdfye decimal(12, 2) NULL CONSTRAINT DF_YHDA0000_yjdfye DEFAULT (0),";
sql=sql+"syye decimal(18, 2) NULL CONSTRAINT DF_YHDA0000_syye DEFAULT (0),";
sql=sql+"fh decimal(10, 3) NULL CONSTRAINT DF_YHDA0000_fh DEFAULT (0),";
sql=sql+"tbjs char(12) NULL,";
sql=sql+"bzsj datetime NULL,";
sql=sql+"jfrq int NULL,";
sql=sql+"sfrq datetime NULL,";
sql=sql+"sfy char(10) NULL,";
sql=sql+"skfs char(10) NULL,";
sql=sql+"fpbh char(10) NULL,";
sql=sql+"cby char(10) NULL,";
sql=sql+"cl decimal(8, 2) NULL CONSTRAINT DF_YHDA0000_cl DEFAULT (0),";
sql=sql+"cszt char(1) NULL,";
sql=sql+"BS_ZYG decimal(18, 2) NULL CONSTRAINT DF_YHDA0000_BS_ZYG DEFAULT (0),";
sql=sql+"BS_ZWG decimal(18, 2) NULL CONSTRAINT DF_YHDA0000_BS_ZWG DEFAULT (0),";
sql=sql+"BS_YGSS decimal(18, 2) NULL CONSTRAINT DF_YHDA0000_BS_YGSS DEFAULT (0),";
sql=sql+"BS_WGSS decimal(18, 2) NULL CONSTRAINT DF_YHDA0000_BS_WGSS DEFAULT (0),";
sql=sql+"BS_YGBSL int NULL CONSTRAINT DF_YHDA0000_BS_YGBSL DEFAULT (0),";
sql=sql+"BS_WGBSL int NULL CONSTRAINT DF_YHDA0000_BS_WGBSL DEFAULT (0)) ON [PRIMARY]";
database2->Execute(sql, NULL, false, NULL); //創建數據庫索引
sql="";
sql=sql+"CREATE UNIQUE CLUSTERED INDEX IX_YHDA0000 ON dbo.YHDA0000 ";
sql=sql+"(hhhh) ON [PRIMARY]";
database2->Execute(sql, NULL, false, NULL); //創建數據庫索引
sql="";
sql=sql+"CREATE TABLE dbo.yhrz ";
sql=sql+"(id int NOT NULL IDENTITY (1, 1),";
sql=sql+"yhmc char(16) NULL,";
sql=sql+"dlsj datetime NULL,";
sql=sql+"tcsj datetime NULL,";
sql=sql+"bz char(16) NULL) ON [PRIMARY]";
database2->Execute(sql, NULL, false, NULL); //創建數據庫索引
sql="";
sql=sql+"CREATE UNIQUE CLUSTERED INDEX IX_BYQCS_1 ON dbo.BYQCS ";
sql=sql+"(byq_id) ON [PRIMARY]";
database2->Execute(sql, NULL, false, NULL); //創建數據庫索引
sql="";
sql=sql+"CREATE UNIQUE CLUSTERED INDEX IX_CBYK ON dbo.CBYK ";
sql=sql+"(CBY_ID) ON [PRIMARY]";
database2->Execute(sql, NULL, false, NULL); //創建數據庫索引
sql="";
sql=sql+"CREATE CLUSTERED INDEX IX_CZRZ ON dbo.CZRZ ";
sql=sql+"(date) ON [PRIMARY]";
database2->Execute(sql, NULL, false, NULL); //創建數據庫索引
sql="";
sql=sql+"CREATE UNIQUE CLUSTERED INDEX IX_CZYGL ON dbo.CZYGL ";
sql=sql+"(ID) ON [PRIMARY]";
database2->Execute(sql, NULL, false, NULL); //創建數據庫索引
sql="";
sql=sql+"CREATE UNIQUE CLUSTERED INDEX IX_DBDA0000_2 ON dbo.DBDA0000 ";
sql=sql+"(db_id) ON [PRIMARY]";
database2->Execute(sql, NULL, false, NULL); //創建數據庫索引
sql="";
sql=sql+"CREATE UNIQUE CLUSTERED INDEX IX_DJKP0000_2 ON dbo.DJKP0000 ";
sql=sql+"(kp_id) ON [PRIMARY]";
database2->Execute(sql, NULL, false, NULL); //創建數據庫索引
sql="";
sql=sql+"CREATE UNIQUE CLUSTERED INDEX IX_djsjk ON dbo.djsjk ";
sql=sql+"(dj_id) ON [PRIMARY]";
database2->Execute(sql, NULL, false, NULL); //創建數據庫索引
sql="";
sql=sql+"CREATE UNIQUE CLUSTERED INDEX IX_dydj ON dbo.dydj ";
sql=sql+"(dy_id) ON [PRIMARY]";
database2->Execute(sql, NULL, false, NULL); //創建數據庫索引
sql="";
sql=sql+"CREATE UNIQUE CLUSTERED INDEX IX_FJJJ0000_1 ON dbo.FJJJ0000 ";
sql=sql+"(FJ_ID) ON [PRIMARY]";
database2->Execute(sql, NULL, false, NULL); //創建數據庫索引
sql="";
sql=sql+"CREATE UNIQUE CLUSTERED INDEX IX_GDS ON dbo.GDS ";
sql=sql+"(GDS_ID) ON [PRIMARY]";
database2->Execute(sql, NULL, false, NULL); //創建數據庫索引
sql="";
sql=sql+"CREATE UNIQUE CLUSTERED INDEX IX_H_YEAR ON dbo.H_YEAR ";
sql=sql+"(Y_ID) ON [PRIMARY]";
database2->Execute(sql, NULL, false, NULL); //創建數據庫索引
sql="";
sql=sql+"CREATE UNIQUE CLUSTERED INDEX IX_HYDM ON dbo.HYDM ";
sql=sql+"(HY_ID) ON [PRIMARY]";
database2->Execute(sql, NULL, false, NULL); //創建數據庫索引
sql="";
sql=sql+"CREATE UNIQUE CLUSTERED INDEX IX_jjxm ON dbo.jjxm ";
sql=sql+"(fj_id) ON [PRIMARY]";
database2->Execute(sql, NULL, false, NULL); //創建數據庫索引
sql="";
sql=sql+"CREATE UNIQUE CLUSTERED INDEX IX_JXGX0000_1 ON dbo.JXGX0000 ";
sql=sql+"(id) ON [PRIMARY]";
database2->Execute(sql, NULL, false, NULL); //創建數據庫索引
sql="";
sql=sql+"CREATE UNIQUE CLUSTERED INDEX IX_XLCS ON dbo.XLCS ";
sql=sql+"(ID) ON [PRIMARY]";
database2->Execute(sql, NULL, false, NULL); //創建數據庫索引
sql="";
sql=sql+"CREATE UNIQUE CLUSTERED INDEX IX_XTCS ON dbo.XTCS ";
sql=sql+"(XT_ID) ON [PRIMARY]";
database2->Execute(sql, NULL, false, NULL); //創建數據庫索引
sql="";
sql=sql+"CREATE UNIQUE CLUSTERED INDEX IX_YDFL ON dbo.YDFL ";
sql=sql+"(fl_id) ON [PRIMARY]";
database2->Execute(sql, NULL, false, NULL); //創建數據庫索引
sql="";
sql=sql+"CREATE UNIQUE CLUSTERED INDEX IX_YDMENU ON dbo.YDMENU ";
sql=sql+"(ID) ON [PRIMARY]";
database2->Execute(sql, NULL, false, NULL); //創建數據庫索引
sql="";
sql=sql+"CREATE UNIQUE CLUSTERED INDEX IX_yhrz ON dbo.yhrz ";
sql=sql+"(id) ON [PRIMARY]";
database2->Execute(sql, NULL, false, NULL); //創建數據庫索引
}
catch(...)
{
;
}
delete database2;
}
//---------------------------
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -