jhls.sql

来自「这是用PB6开发的一个POS管理系统」· SQL 代码 · 共 79 行

use sypos012000
go

Create View xslstj as select * from sypos011999..xslstj0000_1999
go

Create View jhls as 
 select * from sypos011998..jhls
 union 
 select * from sypos011999..jhls

go

Create View jhlsmx as
 Select * from sypos011998..jhlsmx
 union 
 select * from sypos011999..jhlsmx

go

Create View msbfxx as 
   select * from sypos011998..msbfxx0000_1998
   Union
   Select * from sypos011999..msbfxx0000_1999
go


Create view pdsy as
  Select * from sypos011998..mspdsy0000_1998
  Union 
  Select * from sypos011999..mspdsy0000_1999
go


create View Syls as
  Select * from sypos011998..syls0000_1998
  Union 
  Select * from sypos011999..syls0000_1999
go

Create View jxcrbb as
  Select * from sypos011998..msjxcrbb0000_1998
  Union
  Select * from sypos011999..msjxcrbb0000_1999
go

/*
INSERT INTO funcs (name,pname,disp,window,event,params,leaf,funclevel,openway) 
VALUES ('olddata','root','老系统数据查询','',NULL,NULL,'0',1,'0')
go
INSERT INTO funcs (name,pname,disp,window,event,params,leaf,funclevel,openway) 
VALUES ('jhls','olddata','进货业务','','ue_public_query','jhls.ini','1',2,'0')
go
*/

INSERT INTO funcs (name,pname,disp,window,event,params,leaf,funclevel,openway) 
VALUES ('msbfxx','olddata','门市信息','','ue_public_query','msbfxx.ini','1',2,'0')
go

INSERT INTO funcs (name,pname,disp,window,event,params,leaf,funclevel,openway) 
VALUES ('pdsy','olddata','盘点备份','','ue_public_query','pdsy.ini','1',2,'0')
go

INSERT INTO funcs (name,pname,disp,window,event,params,leaf,funclevel,openway) 
VALUES ('syls','olddata','损益单','','ue_public_query','syls.ini','1',2,'0')
go

INSERT INTO funcs (name,pname,disp,window,event,params,leaf,funclevel,openway) 
VALUES ('jxcrbb','olddata','进销存报表','','ue_public_query','jcxrbb.ini','1',2,'0')
go

INSERT INTO funcs (name,pname,disp,window,event,params,leaf,funclevel,openway) 
VALUES ('xslstj','olddata','销售流水统计','','ue_public_query','xslstj.ini','1',2,'0')
go