⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 data.sql

📁 一个pb框架,试过
💻 SQL
📖 第 1 页 / 共 5 页
字号:
🔍
12345 
insert into OPERRFMETHOD (ORFMRID, ORFMFID, ORFMETHOD)
	values ('00', '010501', 'M')
insert into OPERRFMETHOD (ORFMRID, ORFMFID, ORFMETHOD)
	values ('00', '020110', 'S')
insert into OPERRFMETHOD (ORFMRID, ORFMFID, ORFMETHOD)
	values ('00', '010501', 'S')
insert into OPERRFMETHOD (ORFMRID, ORFMFID, ORFMETHOD)
	values ('00', '010601', 'R')
insert into OPERRFMETHOD (ORFMRID, ORFMFID, ORFMETHOD)
	values ('00', '010402', 'N')
insert into OPERRFMETHOD (ORFMRID, ORFMFID, ORFMETHOD)
	values ('00', '010402', 'D')
insert into OPERRFMETHOD (ORFMRID, ORFMFID, ORFMETHOD)
	values ('00', '010402', 'M')
insert into OPERRFMETHOD (ORFMRID, ORFMFID, ORFMETHOD)
	values ('00', '010402', 'S')
insert into OPERRFMETHOD (ORFMRID, ORFMFID, ORFMETHOD)
	values ('00', '010402', 'R')
insert into OPERRFMETHOD (ORFMRID, ORFMFID, ORFMETHOD)
	values ('00', '010401', 'M')
insert into OPERRFMETHOD (ORFMRID, ORFMFID, ORFMETHOD)
	values ('00', '010401', 'S')
insert into OPERRFMETHOD (ORFMRID, ORFMFID, ORFMETHOD)
	values ('00', '020110', 'M')

insert into OPERROLE (ORID, ORNAME, ORGID, ORTRANGE, ORDRANGE)
	values ('00', '系统管理员', '00', 99, 'N')

insert into OPERROLEFUNC (ORFRID, ORFFID)
	values ('00', '010101')
insert into OPERROLEFUNC (ORFRID, ORFFID)
	values ('00', '010102')
insert into OPERROLEFUNC (ORFRID, ORFFID)
	values ('00', '010201')
insert into OPERROLEFUNC (ORFRID, ORFFID)
	values ('00', '010202')
insert into OPERROLEFUNC (ORFRID, ORFFID)
	values ('00', '010203')
insert into OPERROLEFUNC (ORFRID, ORFFID)
	values ('00', '010301')
insert into OPERROLEFUNC (ORFRID, ORFFID)
	values ('00', '010302')
insert into OPERROLEFUNC (ORFRID, ORFFID)
	values ('00', '010401')
insert into OPERROLEFUNC (ORFRID, ORFFID)
	values ('00', '010501')
insert into OPERROLEFUNC (ORFRID, ORFFID)
	values ('00', '010601')
insert into OPERROLEFUNC (ORFRID, ORFFID)
	values ('00', '020101')
insert into OPERROLEFUNC (ORFRID, ORFFID)
	values ('00', '010402')
insert into OPERROLEFUNC (ORFRID, ORFFID)
	values ('00', '010602')
insert into OPERROLEFUNC (ORFRID, ORFFID)
	values ('00', '020110')
insert into OPERROLEFUNC (ORFRID, ORFFID)
	values ('00', '020111')

insert into OPERTYPEDWOBJECT (OTDOBID, OTDOTID, OTDOOBJECT, OTDOMEMO)
	values ('101', 'BOTH', 'dw_userapplyinfo_list', null)
insert into OPERTYPEDWOBJECT (OTDOBID, OTDOTID, OTDOOBJECT, OTDOMEMO)
	values ('101', 'PERD', 'dw_userapplyinfo_list_period', null)
insert into OPERTYPEDWOBJECT (OTDOBID, OTDOTID, OTDOOBJECT, OTDOMEMO)
	values ('101', 'AGNT', 'dw_userapplyinfo_list_agent', null)
insert into OPERTYPEDWOBJECT (OTDOBID, OTDOTID, OTDOOBJECT, OTDOMEMO)
	values ('101', 'NONE', 'dw_userapplyinfo_list_all', null)

insert into SYSCHARLIST (SCLTYPE, SCLID, SCLVALUE, SCLWIDTH, SCLGROUP)
	values ('系统运行窗口类型', 'M', '带参数窗口', 1, 'SYS')
insert into SYSCHARLIST (SCLTYPE, SCLID, SCLVALUE, SCLWIDTH, SCLGROUP)
	values ('系统运行窗口类型', 'O', '普通窗口', 1, 'SYS')
insert into SYSCHARLIST (SCLTYPE, SCLID, SCLVALUE, SCLWIDTH, SCLGROUP)
	values ('系统运行窗口类型', 'P', '带参数sheet窗口', 1, 'SYS')
insert into SYSCHARLIST (SCLTYPE, SCLID, SCLVALUE, SCLWIDTH, SCLGROUP)
	values ('系统运行窗口类型', 'S', 'sheet窗口', 1, 'SYS')
insert into SYSCHARLIST (SCLTYPE, SCLID, SCLVALUE, SCLWIDTH, SCLGROUP)
	values ('报装用户类型', 'CT', '居民用户', 2, 'APLY')
insert into SYSCHARLIST (SCLTYPE, SCLID, SCLVALUE, SCLWIDTH, SCLGROUP)
	values ('报装用户类型', 'BR', '商业餐饮用户', 2, 'APLY')
insert into SYSCHARLIST (SCLTYPE, SCLID, SCLVALUE, SCLWIDTH, SCLGROUP)
	values ('报装用户类型', 'ID', '工业用户', 2, 'APLY')
insert into SYSCHARLIST (SCLTYPE, SCLID, SCLVALUE, SCLWIDTH, SCLGROUP)
	values ('报装用户类型', 'SC', '学校用户', 2, 'APLY')
insert into SYSCHARLIST (SCLTYPE, SCLID, SCLVALUE, SCLWIDTH, SCLGROUP)
	values ('用气建筑状态', '1', '地基阶段', 1, 'APLY')
insert into SYSCHARLIST (SCLTYPE, SCLID, SCLVALUE, SCLWIDTH, SCLGROUP)
	values ('用气建筑状态', '2', '基建阶段', 1, 'APLY')
insert into SYSCHARLIST (SCLTYPE, SCLID, SCLVALUE, SCLWIDTH, SCLGROUP)
	values ('用气建筑状态', '3', '装修阶段', 1, 'APLY')
insert into SYSCHARLIST (SCLTYPE, SCLID, SCLVALUE, SCLWIDTH, SCLGROUP)
	values ('用气建筑状态', '4', '已使用阶段', 1, 'APLY')
insert into SYSCHARLIST (SCLTYPE, SCLID, SCLVALUE, SCLWIDTH, SCLGROUP)
	values ('员工类型', 'SF', '收费员', 2, 'SYS')
insert into SYSCHARLIST (SCLTYPE, SCLID, SCLVALUE, SCLWIDTH, SCLGROUP)
	values ('员工类型', 'CB', '抄表员', 2, 'SYS')
insert into SYSCHARLIST (SCLTYPE, SCLID, SCLVALUE, SCLWIDTH, SCLGROUP)
	values ('员工类型', 'CZ', '操作员', 2, 'SYS')
insert into SYSCHARLIST (SCLTYPE, SCLID, SCLVALUE, SCLWIDTH, SCLGROUP)
	values ('报装准备资料', 'STF01', '用气建筑1:500总平面图', 5, 'APLY')
insert into SYSCHARLIST (SCLTYPE, SCLID, SCLVALUE, SCLWIDTH, SCLGROUP)
	values ('报装准备资料', 'STF02', '1:1000红线图', 5, 'APLY')
insert into SYSCHARLIST (SCLTYPE, SCLID, SCLVALUE, SCLWIDTH, SCLGROUP)
	values ('报装准备资料', 'STF03', '航测图', 5, 'APLY')
insert into SYSCHARLIST (SCLTYPE, SCLID, SCLVALUE, SCLWIDTH, SCLGROUP)
	values ('报装准备资料', 'STF04', '用气建筑平面图', 5, 'APLY')
insert into SYSCHARLIST (SCLTYPE, SCLID, SCLVALUE, SCLWIDTH, SCLGROUP)
	values ('报装准备资料', 'STF05', '用气建筑立面图', 5, 'APLY')
insert into SYSCHARLIST (SCLTYPE, SCLID, SCLVALUE, SCLWIDTH, SCLGROUP)
	values ('报装准备资料', 'STF06', '用气建筑剖面图', 5, 'APLY')
insert into SYSCHARLIST (SCLTYPE, SCLID, SCLVALUE, SCLWIDTH, SCLGROUP)
	values ('报装准备资料', 'STF08', '位置摆放图', 5, 'APLY')
insert into SYSCHARLIST (SCLTYPE, SCLID, SCLVALUE, SCLWIDTH, SCLGROUP)
	values ('报装准备资料', 'STF09', '锅炉技术参数', 5, 'APLY')
insert into SYSCHARLIST (SCLTYPE, SCLID, SCLVALUE, SCLWIDTH, SCLGROUP)
	values ('报装准备资料', 'STF07', '用气设备间的平面图', 5, 'APLY')
insert into SYSCHARLIST (SCLTYPE, SCLID, SCLVALUE, SCLWIDTH, SCLGROUP)
	values ('报装准备资料', 'STF10', '灶具技术参数', 5, 'APLY')
insert into SYSCHARLIST (SCLTYPE, SCLID, SCLVALUE, SCLWIDTH, SCLGROUP)
	values ('报装准备资料', 'STF11', '用户报装申请报告', 5, 'APLY')
insert into SYSCHARLIST (SCLTYPE, SCLID, SCLVALUE, SCLWIDTH, SCLGROUP)
	values ('报装用户类型', 'WF', '公福用户', 2, 'APLY')
insert into SYSCHARLIST (SCLTYPE, SCLID, SCLVALUE, SCLWIDTH, SCLGROUP)
	values ('报装用户类型', 'BB', '商业锅炉用户', 2, 'APLY')
insert into SYSCHARLIST (SCLTYPE, SCLID, SCLVALUE, SCLWIDTH, SCLGROUP)
	values ('设备类型维护', '06', '调 压 箱', 2, 'APLY')
insert into SYSCHARLIST (SCLTYPE, SCLID, SCLVALUE, SCLWIDTH, SCLGROUP)
	values ('设备类型维护', '05', '燃 烧 机', 2, 'APLY')
insert into SYSCHARLIST (SCLTYPE, SCLID, SCLVALUE, SCLWIDTH, SCLGROUP)
	values ('设备类型维护', '04', '锅    炉', 2, 'APLY')
insert into SYSCHARLIST (SCLTYPE, SCLID, SCLVALUE, SCLWIDTH, SCLGROUP)
	values ('设备类型维护', '03', '报 警 器', 2, 'APLY')
insert into SYSCHARLIST (SCLTYPE, SCLID, SCLVALUE, SCLWIDTH, SCLGROUP)
	values ('设备类型维护', '02', '热 水 器', 2, 'APLY')
insert into SYSCHARLIST (SCLTYPE, SCLID, SCLVALUE, SCLWIDTH, SCLGROUP)
	values ('设备类型维护', '01', '灶    具', 2, 'APLY')
insert into SYSCHARLIST (SCLTYPE, SCLID, SCLVALUE, SCLWIDTH, SCLGROUP)
	values ('燃气具缴费方式', '2', '随工程款交纳货款', 1, 'APLY')
insert into SYSCHARLIST (SCLTYPE, SCLID, SCLVALUE, SCLWIDTH, SCLGROUP)
	values ('燃气具缴费方式', '1', '选型并交纳货款', 1, 'APLY')
insert into SYSCHARLIST (SCLTYPE, SCLID, SCLVALUE, SCLWIDTH, SCLGROUP)
	values ('设备类型维护', '07', '工业用气', 2, 'APLY')

insert into SYSFILETYPE (SFID, SFNAME, SFDESC, SFCOUNT, SFICO)
	values ('21', 'pbt', 'pb目标对象文件', 0, 'ico\pbt.ico')
insert into SYSFILETYPE (SFID, SFNAME, SFDESC, SFCOUNT, SFICO)
	values ('22', 'cur', '光标文件', 6, 'ico\cur.ico')
insert into SYSFILETYPE (SFID, SFNAME, SFDESC, SFCOUNT, SFICO)
	values ('24', 'psd', 'PhotoShop文件', 0, 'ico\psd.ico')
insert into SYSFILETYPE (SFID, SFNAME, SFDESC, SFCOUNT, SFICO)
	values ('23', 'jpg', '交互式图形文件', 3, 'ico\jpg.ico')
insert into SYSFILETYPE (SFID, SFNAME, SFDESC, SFCOUNT, SFICO)
12345

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -