2.stock_init.sql

学习PB入门的好帮手,附件中包含以下文件夹

/*
delete from f_desktopmain
delete from f_desktopchild
delete from f_plist
delete from f_loginuser
*/

insert into f_desktopmain values(1,'基础设置')
insert into f_desktopmain values(2,'库存管理')
insert into f_desktopmain values(3,'领导查询')
insert into f_desktopmain values(4,'系统管理')

insert into f_desktopchild values(1,1,'公司基本资料','images\a1.jpg')
insert into f_desktopchild values(1,2,'供应商基本资料','images\a2.jpg')
insert into f_desktopchild values(1,3,'客户基本资料','images\a3.jpg')
insert into f_desktopchild values(1,4,'仓库管理','images\a4.jpg')
insert into f_desktopchild values(1,5,'产品类别管理','images\a5.jpg')
insert into f_desktopchild values(1,6,'产品管理','images\a6.jpg')
insert into f_desktopchild values(1,8,'库存期初','images\a8.jpg')

insert into f_desktopchild values(2,1,'入库单管理','images\1.jpg')
insert into f_desktopchild values(2,2,'出货单管理','images\2.jpg')
insert into f_desktopchild values(2,3,'生产单管理','images\3.jpg')
insert into f_desktopchild values(2,4,'盘点单管理','images\7.jpg')
insert into f_desktopchild values(2,5,'入库单审核','images\8.jpg')
insert into f_desktopchild values(2,6,'出货单审核','images\9.jpg')
insert into f_desktopchild values(2,7,'生产单审核','images\15.jpg')
insert into f_desktopchild values(2,8,'盘点单审核','images\17.jpg')

insert into f_desktopchild values(3,1,'供应商产品综合查询','images\a9.jpg')
insert into f_desktopchild values(3,2,'综合查询','images\e2.jpg')

insert into f_desktopchild values(4,1,'用户管理','images\13.jpg')
insert into f_desktopchild values(4,2,'权限设置','images\user.jpg')
insert into f_desktopchild values(4,3,'修改密码','images\12.jpg')


----------------------------------------------------------------------
insert into f_plist values('101','公司基本资料')
insert into f_plist values('102','供应商基本资料')
insert into f_plist values('103','客户基本资料')
insert into f_plist values('104','仓库管理')
insert into f_plist values('105','产品类别管理')
insert into f_plist values('106','产品管理')
insert into f_plist values('108','库存期初')


insert into f_plist values('201','入库单管理')
insert into f_plist values('202','出货单管理')
insert into f_plist values('203','生产单管理')
insert into f_plist values('204','盘点单管理')
insert into f_plist values('205','入库单审核')
insert into f_plist values('206','出货单审核')
insert into f_plist values('207','生产单审核')
insert into f_plist values('208','盘点单审核')

insert into f_plist values('301','供应商产品综合查询')
insert into f_plist values('302','综合查询')

insert into f_plist values('401','用户管理')
insert into f_plist values('402','权限设置')
insert into f_plist values('403','修改密码')

insert into f_loginuser(c_loginuserid,c_loginusername,c_pwd,i_admin,i_go ) values('admin','admin','888',1,0)