1037 lines
68 KiB
SQL
1037 lines
68 KiB
SQL
DELETE zc_module;
|
||
/*
|
||
SELECT 'INSERT INTO zc_module(mkbm, shunx, mklx, mkzt, mkmc, sjmkbm)VALUES('''
|
||
+ mkbm + ''', ' + CAST(shunx AS VARCHAR(12)) + ', '+ CAST(mklx AS VARCHAR(12)) + ', '+ CAST(mkzt AS VARCHAR(12)) + ', '''
|
||
+ mkmc + ''', ' + ISNULL('''' + sjmkbm + '''', 'NULL') + ');'
|
||
FROM zc_module
|
||
ORDER BY shunx;
|
||
*/
|
||
INSERT INTO zc_module(mkbm, shunx, mklx, mkzt, mkmc, sjmkbm, blsx1)VALUES('1010000 ', 1, 0, 0, '接口管理', NULL, '.');
|
||
INSERT INTO zc_module(mkbm, shunx, mklx, mkzt, mkmc, sjmkbm, blsx1)VALUES('1010001 ', 2, 0, 1, '出入库单据', '1010000 ', '.jkgl.client.JkglPane');
|
||
INSERT INTO zc_module(mkbm, shunx, mklx, mkzt, mkmc, sjmkbm, blsx1)VALUES('1010002 ', 3, 0, 1, '基础数据', '1010000 ', '.jkgl.client.JcsjPane');
|
||
|
||
INSERT INTO zc_module(mkbm, shunx, mklx, mkzt, mkmc, sjmkbm, blsx1)VALUES('10300001', 10, 0, 1, '入库登记', NULL, '.');
|
||
|
||
INSERT INTO zc_module(mkbm, shunx, mklx, mkzt, mkmc, sjmkbm, blsx1)VALUES('10300002', 11, 0, 1, '借用返还入库', '10300001', '.cpgl.client.JyRkPane');
|
||
INSERT INTO zc_module(mkbm, shunx, mklx, mkzt, mkmc, sjmkbm, blsx1)VALUES('10300003', 12, 0, 1, '返修回库', '10300001', '.cpgl.client.FxRkPane');
|
||
INSERT INTO zc_module(mkbm, shunx, mklx, mkzt, mkmc, sjmkbm, blsx1)VALUES('10300004', 13, 0, 1, '定检回库', '10300001', '.cpgl.client.DjRkPane');
|
||
INSERT INTO zc_module(mkbm, shunx, mklx, mkzt, mkmc, sjmkbm, blsx1)VALUES('10300005', 14, 0, 1, '新购入库', '10300001', '.cpgl.client.XgRkPane');
|
||
INSERT INTO zc_module(mkbm, shunx, mklx, mkzt, mkmc, sjmkbm, blsx1)VALUES('10300010', 16, 0, 1, '成品入库', '10300001', '.cpgl.client.RkdMxXzPane');
|
||
INSERT INTO zc_module(mkbm, shunx, mklx, mkzt, mkmc, sjmkbm, blsx1)VALUES('10300012', 17, 0, 1, '入库指令管理', '10300001', '.cpgl.client.RkZlPane');
|
||
|
||
INSERT INTO zc_module(mkbm, shunx, mklx, mkzt, mkmc, sjmkbm, blsx1)VALUES('10300007', 15, 0, 1, '入库指令', NULL, NULL);
|
||
|
||
INSERT INTO zc_module(mkbm, shunx, mklx, mkzt, mkmc, sjmkbm, blsx1)VALUES('10400001', 60, 0, 1, '出库登记', NULL, '.');
|
||
|
||
INSERT INTO zc_module(mkbm, shunx, mklx, mkzt, mkmc, sjmkbm, blsx1)VALUES('10400002', 61, 0, 1, '借用出库', '10400001', '.cpgl.client.JyCkPane');
|
||
INSERT INTO zc_module(mkbm, shunx, mklx, mkzt, mkmc, sjmkbm, blsx1)VALUES('10400003', 62, 0, 1, '返修出库', '10400001', '.cpgl.client.FxCkPane');
|
||
INSERT INTO zc_module(mkbm, shunx, mklx, mkzt, mkmc, sjmkbm, blsx1)VALUES('10400004', 63, 0, 1, '定检出库', '10400001', '.cpgl.client.DjCkPane');
|
||
INSERT INTO zc_module(mkbm, shunx, mklx, mkzt, mkmc, sjmkbm, blsx1)VALUES('10400006', 64, 0, 1, '报废出库', '10400001', '.cpgl.client.BfCkPane');
|
||
|
||
INSERT INTO zc_module(mkbm, shunx, mklx, mkzt, mkmc, sjmkbm, blsx1)VALUES('10400005', 66, 0, 1, '出库指令', NULL, NULL);
|
||
|
||
INSERT INTO zc_module(mkbm, shunx, mklx, mkzt, mkmc, sjmkbm, blsx1)VALUES('10410003', 101, 0, 1, '空托盘出入库', NULL, '..stock.client.KtpCrkPane');
|
||
INSERT INTO zc_module(mkbm, shunx, mklx, mkzt, mkmc, sjmkbm, blsx1)VALUES('10500001', 200, 0, 1, '存货管理', NULL, '.');
|
||
INSERT INTO zc_module(mkbm, shunx, mklx, mkzt, mkmc, sjmkbm, blsx1)VALUES('10500004', 230, 0, 1, '仓库盘点', '10500001', '.stock.client.CpPddPane');
|
||
INSERT INTO zc_module(mkbm, shunx, mklx, mkzt, mkmc, sjmkbm, blsx1)VALUES('10510005', 240, 0, 1, '转 库', '10500001', '.stock.client.CpZkzlPane');
|
||
|
||
INSERT INTO zc_module(mkbm, shunx, mklx, mkzt, mkmc, sjmkbm, blsx1)VALUES('10600001', 300, 0, 1, '统计报表', NULL, '.');
|
||
INSERT INTO zc_module(mkbm, shunx, mklx, mkzt, mkmc, sjmkbm, blsx1)VALUES('10500003', 301, 0, 1, '当前库存', '10600001', '.bbgl.client.CPStockQueryPane');
|
||
INSERT INTO zc_module(mkbm, shunx, mklx, mkzt, mkmc, sjmkbm, blsx1)VALUES('10500002', 302, 0, 1, '仓库库位状态', '10600001', '.bbgl.client.StockShowPane');
|
||
INSERT INTO zc_module(mkbm, shunx, mklx, mkzt, mkmc, sjmkbm, blsx1)VALUES('10600006', 309, 0, 1, '出入库总账', '10600001', '.bbgl.client.CpCrkZzPane');
|
||
INSERT INTO zc_module(mkbm, shunx, mklx, mkzt, mkmc, sjmkbm, blsx1)VALUES('10600002', 310, 0, 1, '出入库明细账', '10600001', '.bbgl.client.CpcrmxzPane');
|
||
INSERT INTO zc_module(mkbm, shunx, mklx, mkzt, mkmc, sjmkbm, blsx1)VALUES('10600004', 311, 0, 1, '出入库作业指令清单', '10600001', '.bbgl.client.CrkZyzlQdPane');
|
||
INSERT INTO zc_module(mkbm, shunx, mklx, mkzt, mkmc, sjmkbm, blsx1)VALUES('1061KKXX', 312, 0, 0, '库卡信息', '10600001', '.bbgl.client.KkxxPane');
|
||
INSERT INTO zc_module(mkbm, shunx, mklx, mkzt, mkmc, sjmkbm, blsx1)VALUES('10600003', 320, 0, 0, '收发存', '10600001', '.bbgl.client.CpSfcbbPane');
|
||
INSERT INTO zc_module(mkbm, shunx, mklx, mkzt, mkmc, sjmkbm, blsx1)VALUES('106CRKPL', 321, 0, 1, '出入库频率分析', '10600001', '.bbgl.client.CrkplPane');
|
||
INSERT INTO zc_module(mkbm, shunx, mklx, mkzt, mkmc, sjmkbm, blsx1)VALUES('10600005', 325, 0, 1, '库存量预警报告', '10600001', '.bbgl.client.KclYjPane');
|
||
INSERT INTO zc_module(mkbm, shunx, mklx, mkzt, mkmc, sjmkbm, blsx1)VALUES('1061CQCC', 326, 0, 1, '超期存储报告', '10600001', '.bbgl.client.CqccPane');
|
||
--INSERT INTO zc_module(mkbm, shunx, mklx, mkzt, mkmc, sjmkbm, blsx1)VALUES('1061DJJQ', 327, 0, 1, '定检近期报告', '10600001', '.bbgl.client.DjjqPane');
|
||
--INSERT INTO zc_module(mkbm, shunx, mklx, mkzt, mkmc, sjmkbm, blsx1)VALUES('1061GZZT', 328, 0, 1, '工装状态报告', '10600001', '.bbgl.client.GzztPane');
|
||
|
||
INSERT INTO zc_module(mkbm, shunx, mklx, mkzt, mkmc, sjmkbm, blsx1)VALUES('10700001', 400, 0, 1, '基础数据维护', NULL, '.');
|
||
INSERT INTO zc_module(mkbm, shunx, mklx, mkzt, mkmc, sjmkbm, blsx1)VALUES('10700002', 410, 0, 1, '存货分类', '10700001', '.base.client.WzlbPane');
|
||
INSERT INTO zc_module(mkbm, shunx, mklx, mkzt, mkmc, sjmkbm, blsx1)VALUES('10700003', 411, 0, 1, '专有属性栏目', '10700001', NULL);
|
||
INSERT INTO zc_module(mkbm, shunx, mklx, mkzt, mkmc, sjmkbm, blsx1)VALUES('10700004', 420, 0, 1, '存货档案', '10700001', '.base.client.CpxxPane');
|
||
INSERT INTO zc_module(mkbm, shunx, mklx, mkzt, mkmc, sjmkbm, blsx1)VALUES('10700041', 421, 0, 1, '附件信息', '10700001', NULL);
|
||
INSERT INTO zc_module(mkbm, shunx, mklx, mkzt, mkmc, sjmkbm, blsx1)VALUES('10700005', 430, 0, 1, '仓库档案', '10700001', '.base.client.CkxxPane');
|
||
INSERT INTO zc_module(mkbm, shunx, mklx, mkzt, mkmc, sjmkbm, blsx1)VALUES('10700006', 431, 0, 1, '库位信息', '10700001', NULL);
|
||
INSERT INTO zc_module(mkbm, shunx, mklx, mkzt, mkmc, sjmkbm, blsx1)VALUES('10700007', 435, 0, 1, '人员信息', '10700001', '.base.client.RyxxPane');
|
||
INSERT INTO zc_module(mkbm, shunx, mklx, mkzt, mkmc, sjmkbm, blsx1)VALUES('ABCDEFGH', 440, 0, 1, '选择输入项', '10700001', 'com.usun.frame.client.XzsrxPane');
|
||
INSERT INTO zc_module(mkbm, shunx, mklx, mkzt, mkmc, sjmkbm, blsx1)VALUES('AAAAA001', 1000, 0, 1, '系统管理', NULL, '.');
|
||
INSERT INTO zc_module(mkbm, shunx, mklx, mkzt, mkmc, sjmkbm, blsx1)VALUES('00000118', 1001, 0, 1, '用户组', 'AAAAA001', 'com.zcsoft.purview.client.UserGroupPane');
|
||
INSERT INTO zc_module(mkbm, shunx, mklx, mkzt, mkmc, sjmkbm, blsx1)VALUES('00000119', 1002, 0, 1, '系统用户', 'AAAAA001', '.base.client.User');
|
||
INSERT INTO zc_module(mkbm, shunx, mklx, mkzt, mkmc, sjmkbm, blsx1)VALUES('00000368', 1003, 0, 1, '在线用户', 'AAAAA001', '.sys.client.OnlineUserPane');
|
||
INSERT INTO zc_module(mkbm, shunx, mklx, mkzt, mkmc, sjmkbm, blsx1)VALUES('00000369', 1004, 0, 1, '系统配置', 'AAAAA001', '.sys.client.ConfigPane');
|
||
INSERT INTO zc_module(mkbm, shunx, mklx, mkzt, mkmc, sjmkbm, blsx1)VALUES('BB10001 ', 5000, 0, 0, '收发存结算', NULL, NULL);
|
||
INSERT INTO zc_module(mkbm, shunx, mklx, mkzt, mkmc, sjmkbm, blsx1)VALUES('scriptgo', 6000, 0, 1, '执行数据库更新脚本', NULL, NULL);
|
||
INSERT INTO zc_module(mkbm, shunx, mklx, mkzt, mkmc, sjmkbm, blsx1)VALUES('DBbackup', 6005, 0, 0, '数据库自动备份', NULL, NULL);
|
||
INSERT INTO zc_module(mkbm, shunx, mklx, mkzt, mkmc, sjmkbm, blsx1)VALUES('T_Design', 8010, 0, 0, '票据打印模板设计', NULL, NULL);
|
||
INSERT INTO zc_module(mkbm, shunx, mklx, mkzt, mkmc, sjmkbm, blsx1)VALUES('R_Design', 8011, 0, 0, '报表打印模板设计', NULL, NULL);
|
||
;
|
||
/
|
||
DELETE zc_moduleQx;
|
||
/*
|
||
SELECT 'INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES(''' + mkbm + ''', ' + CAST(qxid AS VARCHAR(12)) + ', ''' + qxmc + ''');'
|
||
FROM zc_moduleQx
|
||
ORDER BY mkbm, qxid;
|
||
*/
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('00000118', 1, '使用');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('00000119', 1, '使用');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('00000368', 1, '使用');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('00000368', 2, '刷新');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('00000368', 8, '删除');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('00000369', 1, '使用');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('00000369', 4, '修改');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('1010000 ', 1, '使用');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('1010001 ', 1, '使用');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('1010001 ', 8, '不接收/作废');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('1010001 ', 16, '查询');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('1010001 ', 128, '下载数据');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('1010001 ', 256, '清除历史数据');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('1010001 ', 512, '调整自动作废时间');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('1010001 ', 1024, '取消作废');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('1010002 ', 1, '使用');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('1010002 ', 8, '不接收');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('1010002 ', 16, '查询');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('1010002 ', 128, '下载数据');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('1010002 ', 256, '清除历史数据');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('1010002 ', 512, '自动下载');
|
||
|
||
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('10300001', 1, '使用');
|
||
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('10300002', 1, '使用');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('10300002', 2, '增加');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('10300002', 4, '修改');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('10300002', 8, '删除');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('10300002', 16, '查询');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('10300002', 32, '打印');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('10300002', 64, '审核');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('10300002', 128, '安排库位');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('10300002', 256, '取消审核');
|
||
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('10300003', 1, '使用');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('10300003', 2, '增加');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('10300003', 4, '修改');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('10300003', 8, '删除');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('10300003', 16, '查询');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('10300003', 32, '打印');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('10300003', 64, '审核');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('10300003', 128, '安排库位');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('10300003', 256, '取消审核');
|
||
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('10300004', 1, '使用');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('10300004', 2, '增加');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('10300004', 4, '修改');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('10300004', 8, '删除');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('10300004', 16, '查询');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('10300004', 32, '打印');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('10300004', 64, '审核');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('10300004', 128, '安排库位');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('10300004', 256, '取消审核');
|
||
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('10300005', 1, '使用');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('10300005', 2, '增加');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('10300005', 4, '修改');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('10300005', 8, '删除');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('10300005', 16, '查询');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('10300005', 32, '打印');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('10300005', 64, '审核');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('10300005', 128, '安排库位');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('10300005', 256, '取消审核');
|
||
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('10300007', 1, '刷新');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('10300007', 4, '修改');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('10300007', 8, '删除');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('10300007', 64, '标示完成');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('10300007', 128, '执行作业');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('10300007', 512, '取消完成');
|
||
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('10300010', 1, '使用');
|
||
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('10300012', 1, '使用');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('10300012', 2, '增加');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('10300012', 4, '修改');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('10300012', 8, '删除');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('10300012', 16, '查询');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('10300012', 32, '打印');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('10300012', 64, '审核');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('10300012', 128, '安排库位');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('10300012', 256, '取消审核');
|
||
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('10400001', 1, '使用');
|
||
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('10400002', 1, '使用');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('10400002', 2, '增加');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('10400002', 4, '修改');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('10400002', 8, '删除');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('10400002', 16, '查询');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('10400002', 32, '打印');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('10400002', 64, '审核');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('10400002', 128, '安排库位');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('10400002', 256, '取消审核');
|
||
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('10400003', 1, '使用');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('10400003', 2, '增加');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('10400003', 4, '修改');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('10400003', 8, '删除');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('10400003', 16, '查询');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('10400003', 32, '打印');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('10400003', 64, '审核');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('10400003', 128, '安排库位');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('10400003', 256, '取消审核');
|
||
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('10400004', 1, '使用');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('10400004', 2, '增加');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('10400004', 4, '修改');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('10400004', 8, '删除');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('10400004', 16, '查询');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('10400004', 32, '打印');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('10400004', 64, '审核');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('10400004', 128, '安排库位');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('10400004', 256, '取消审核');
|
||
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('10400006', 1, '使用');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('10400006', 2, '增加');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('10400006', 4, '修改');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('10400006', 8, '删除');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('10400006', 16, '查询');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('10400006', 32, '打印');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('10400006', 64, '审核');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('10400006', 128, '安排库位');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('10400006', 256, '取消审核');
|
||
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('10400005', 1, '刷新');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('10400005', 4, '修改');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('10400005', 8, '删除');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('10400005', 64, '标示完成');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('10400005', 128, '执行作业');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('10400005', 512, '取消完成');
|
||
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('10410003', 1, '使用');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('10500001', 1, '使用');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('10500002', 1, '使用');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('10500002', 2, '操作库位锁');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('10500004', 1, '使用');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('10500004', 2, '增加');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('10500004', 8, '删除');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('10500004', 16, '查询');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('10500004', 32, '打印');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('10500004', 64, '调整库存');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('10500004', 128, '取出托盘');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('10500004', 256, '记录盘点结果');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('10510005', 1, '使用');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('10510005', 2, '增加');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('10510005', 4, '修改');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('10510005', 8, '删除');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('10510005', 16, '查询');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('10510005', 64, '审核');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('10510005', 1024, '转入');
|
||
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('10600001', 1, '使用');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('10500003', 1, '使用');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('10500003', 16, '查询');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('10500003', 32, '打印');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('10600002', 1, '使用');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('10600002', 16, '统计');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('10600002', 32, '打印');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('10600003', 1, '使用');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('10600003', 16, '统计');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('10600003', 32, '打印');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('10600004', 1, '使用');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('10600004', 16, '统计');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('10600004', 32, '打印');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('10600005', 1, '使用');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('10600005', 16, '统计');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('10600005', 32, '打印');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('10600006', 1, '使用');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('10600006', 16, '统计');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('10600006', 32, '打印');
|
||
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('106CRKPL', 1, '使用');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('106CRKPL', 16, '统计');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('106CRKPL', 32, '打印');
|
||
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('1061KKXX', 1, '使用');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('1061KKXX', 16, '统计');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('1061KKXX', 32, '打印');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('1061KKXX', 128, '年末结转');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('1061CQCC', 1, '使用');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('1061CQCC', 16, '统计');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('1061CQCC', 32, '打印');
|
||
|
||
--INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('1061DJJQ', 1, '使用');
|
||
--INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('1061DJJQ', 16, '统计');
|
||
--INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('1061DJJQ', 32, '打印');
|
||
|
||
--INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('1061GZZT', 1, '使用');
|
||
--INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('1061GZZT', 16, '统计');
|
||
--INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('1061GZZT', 32, '打印');
|
||
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('10700001', 1, '使用');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('10700002', 1, '使用');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('10700002', 2, '增加');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('10700002', 4, '修改');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('10700002', 8, '删除');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('10700002', 128, '维护存货档案');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('10700003', 1, '使用');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('10700003', 2, '新增栏目');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('10700003', 4, '修改栏目');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('10700003', 8, '删除栏目');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('10700004', 1, '使用');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('10700004', 2, '增加');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('10700004', 4, '修改');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('10700004', 8, '删除');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('10700004', 16, '查询');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('10700004', 128, '改分类');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('10700004', 256, '改编码');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('10700004', 512, '同步更新');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('10700004', 1024, '导入');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('10700004', 2048, '附件信息');
|
||
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('10700041', 2, '增加');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('10700041', 4, '修改');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('10700041', 8, '删除');
|
||
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('10700005', 1, '使用');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('10700006', 2, '新增库位');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('10700006', 4, '修改库位');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('10700006', 8, '删除库位');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('10700006', 16, '查询');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('10700006', 128, '设定分区');
|
||
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('10700007', 1, '使用');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('10700007', 2, '增加');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('10700007', 4, '修改');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('10700007', 8, '删除');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('10700007', 16, '查询');
|
||
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('AAAAA001', 1, '使用');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('ABCDEFGH', 1, '使用');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('ABCDEFGH', 2, '增加');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('ABCDEFGH', 4, '修改');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('ABCDEFGH', 8, '删除');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('BB10001 ', 1, '使用');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('DBbackup', 1, '使用');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('R_Design', 1, '使用');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('scriptgo', 1, '使用');
|
||
INSERT INTO zc_moduleQx(mkbm, qxid, qxmc)VALUES('T_Design', 1, '使用');
|
||
;
|
||
/
|
||
|
||
-- 定义所有权限用户组
|
||
DELETE FROM zc_yhz WHERE yhzbm='1';
|
||
INSERT INTO zc_yhz(yhzbm,yhzmc)VALUES('1', '所有权限');
|
||
DELETE FROM zc_yhzmkqx WHERE yhzbm='1';
|
||
INSERT INTO zc_yhzmkqx(yhzbm,mkbm,qx)
|
||
SELECT '1', A.mkbm, qx
|
||
FROM zc_module A,
|
||
(SELECT mkbm, SUM(qxid) qx FROM zc_moduleQx GROUP BY mkbm)B
|
||
WHERE A.mkbm = B.mkbm AND A.mkzt = 1;
|
||
;
|
||
/
|
||
DELETE FROM zc_yhxx WHERE yhm='admin';
|
||
INSERT INTO zc_yhxx(yhm, mm, xm)VALUES('admin', 'admin', '系统管理员');
|
||
DELETE FROM zc_yhmkqx WHERE yhm='admin';
|
||
INSERT INTO zc_yhmkqx(yhm,mkbm,qx)
|
||
SELECT 'admin', A.mkbm, qx
|
||
FROM zc_module A,
|
||
(SELECT mkbm, SUM(qxid) qx FROM zc_moduleQx GROUP BY mkbm)B
|
||
WHERE A.mkbm = B.mkbm AND A.mkzt = 1;
|
||
;
|
||
/
|
||
-- 代码名称对照表
|
||
/*
|
||
SELECT 'INSERT INTO USUN_DM_MC_DZB(sbm,dm,mc,sx)'
|
||
+ char(13) + char(10) + space(len('INSERT INTO USUN_DM_MC_DZB(') - 7) + 'VALUES'
|
||
+ '(''' + sbm + ''''
|
||
+ ',' + ISNULL('''' + dm + '''', 'NULL')
|
||
+ ',' + ISNULL('''' + mc + '''', 'NULL')
|
||
+ ',' + ISNULL('''' + sx + '''', 'NULL')
|
||
+ ');'
|
||
FROM USUN_DM_MC_DZB
|
||
ORDER BY SBM,SX
|
||
*/
|
||
DELETE FROM USUN_DM_MC_DZB;
|
||
|
||
INSERT INTO USUN_DM_MC_DZB(sbm,dm,mc,sx)VALUES(N'CRKDZT', '0', N'未审核', 1);
|
||
INSERT INTO USUN_DM_MC_DZB(sbm,dm,mc,sx)VALUES(N'CRKDZT', '1', N'已审核', 2);
|
||
INSERT INTO USUN_DM_MC_DZB(sbm,dm,mc,sx)VALUES(N'CZLX', 'D', N'删除', 3);
|
||
INSERT INTO USUN_DM_MC_DZB(sbm,dm,mc,sx)VALUES(N'CZLX', 'I', N'新增', 1);
|
||
INSERT INTO USUN_DM_MC_DZB(sbm,dm,mc,sx)VALUES(N'CZLX', 'U', N'修改', 2);
|
||
INSERT INTO USUN_DM_MC_DZB(sbm,dm,mc,sx)VALUES(N'JCSJLB', 'CKBM', N'仓库档案', 2);
|
||
INSERT INTO USUN_DM_MC_DZB(sbm,dm,mc,sx)VALUES(N'JCSJLB', 'WLBM', N'存货档案', 1);
|
||
INSERT INTO USUN_DM_MC_DZB(sbm,dm,mc,sx)VALUES(N'JCSJLB', 'WZLB', N'存货分类', 3);
|
||
INSERT INTO USUN_DM_MC_DZB(sbm,dm,mc,sx)VALUES(N'JCSJZT', '0', N'就绪', 1);
|
||
INSERT INTO USUN_DM_MC_DZB(sbm,dm,mc,sx)VALUES(N'JCSJZT', '1', N'已同步', 2);
|
||
INSERT INTO USUN_DM_MC_DZB(sbm,dm,mc,sx)VALUES(N'JCSJZT', '2', N'出错', 3);
|
||
INSERT INTO USUN_DM_MC_DZB(sbm,dm,mc,sx)VALUES(N'JCSJZT', '3', N'已作废', 3);
|
||
INSERT INTO USUN_DM_MC_DZB(sbm,dm,mc,sx)VALUES(N'JKZT', '0', N'就绪', 2);
|
||
INSERT INTO USUN_DM_MC_DZB(sbm,dm,mc,sx)VALUES(N'JKZT', '1', N'已下载', 3);
|
||
INSERT INTO USUN_DM_MC_DZB(sbm,dm,mc,sx)VALUES(N'JKZT', '2', N'已完成', 4);
|
||
INSERT INTO USUN_DM_MC_DZB(sbm,dm,mc,sx)VALUES(N'JKZT', '3', N'不接收/作废', 5);
|
||
INSERT INTO USUN_DM_MC_DZB(sbm,dm,mc,sx)VALUES(N'JKZT', '4', N'ERP已处理', 6);
|
||
INSERT INTO USUN_DM_MC_DZB(sbm,dm,mc,sx)VALUES(N'SFLZ', '0', N'否', 1);
|
||
INSERT INTO USUN_DM_MC_DZB(sbm,dm,mc,sx)VALUES(N'SFLZ', '1', N'是', 2);
|
||
INSERT INTO USUN_DM_MC_DZB(sbm,dm,mc,sx)VALUES(N'YHJS', '1', N'部门主管(可查看他人输入的单据)', NULL);
|
||
INSERT INTO USUN_DM_MC_DZB(sbm,dm,mc,sx)VALUES(N'YHJS', '2', N'普通职员(只能看自己输入的单据)', NULL);
|
||
INSERT INTO USUN_DM_MC_DZB(sbm,dm,mc,sx)VALUES(N'ZL', '0', N'不合格品', 3);
|
||
INSERT INTO USUN_DM_MC_DZB(sbm,dm,mc,sx)VALUES(N'ZL', '1', N'待验', 2);
|
||
INSERT INTO USUN_DM_MC_DZB(sbm,dm,mc,sx)VALUES(N'ZL', '2', N'合格品', 1);
|
||
INSERT INTO USUN_DM_MC_DZB(sbm,dm,mc,sx)VALUES(N'ZLZTZHD.SHZT', '0', N'待审核', 1);
|
||
INSERT INTO USUN_DM_MC_DZB(sbm,dm,mc,sx)VALUES(N'ZLZTZHD.SHZT', '1', N'已审核', 2);
|
||
INSERT INTO USUN_DM_MC_DZB(sbm,dm,mc,sx)VALUES(N'KKXX.DJLX', 'R', N'入库单', 1);
|
||
INSERT INTO USUN_DM_MC_DZB(sbm,dm,mc,sx)VALUES(N'KKXX.DJLX', 'C', N'出库单', 2);
|
||
INSERT INTO USUN_DM_MC_DZB(sbm,dm,mc,sx)VALUES(N'KKXX.DJLX', 'Z', N'转 库', 3);
|
||
INSERT INTO USUN_DM_MC_DZB(sbm,dm,mc,sx)VALUES(N'KKXX.DJLX', 'H', N'质量转换', 4);
|
||
INSERT INTO USUN_DM_MC_DZB(sbm,dm,mc,sx)VALUES(N'KKXX.DJLX', 'I', N'结 转', 5);
|
||
INSERT INTO USUN_DM_MC_DZB(sbm,dm,mc,sx)VALUES(N'KWJBXX.WZLB', '变速箱', N'变速箱', 1);
|
||
INSERT INTO USUN_DM_MC_DZB(sbm,dm,mc,sx)VALUES(N'KWJBXX.WZLB', '量具', N'量具', 2);
|
||
INSERT INTO USUN_DM_MC_DZB(sbm,dm,mc,sx)VALUES(N'KWJBXX.WZLB', '样板', N'样板', 3);
|
||
|
||
INSERT INTO USUN_DM_MC_DZB(sbm,dm,mc,sx)
|
||
VALUES('RKLX','02','借用返还入库','1');
|
||
INSERT INTO USUN_DM_MC_DZB(sbm,dm,mc,sx)
|
||
VALUES('RKLX','03','返修回库','2');
|
||
INSERT INTO USUN_DM_MC_DZB(sbm,dm,mc,sx)
|
||
VALUES('RKLX','04','定检回库','3');
|
||
INSERT INTO USUN_DM_MC_DZB(sbm,dm,mc,sx)
|
||
VALUES('RKLX','01','新购入库','5');
|
||
--INSERT INTO USUN_DM_MC_DZB(sbm,dm,mc,sx)
|
||
-- VALUES('RKLX','05','其它入库','6');
|
||
|
||
INSERT INTO USUN_DM_MC_DZB(sbm,dm,mc,sx)
|
||
VALUES('CRKDLX','02','借用返还入库','1');
|
||
INSERT INTO USUN_DM_MC_DZB(sbm,dm,mc,sx)
|
||
VALUES('CRKDLX','03','返修回库','2');
|
||
INSERT INTO USUN_DM_MC_DZB(sbm,dm,mc,sx)
|
||
VALUES('CRKDLX','04','定检回库','3');
|
||
INSERT INTO USUN_DM_MC_DZB(sbm,dm,mc,sx)
|
||
VALUES('CRKDLX','01','新购入库','5');
|
||
--INSERT INTO USUN_DM_MC_DZB(sbm,dm,mc,sx)
|
||
-- VALUES('CRKDLX','05','其它入库','6');
|
||
|
||
INSERT INTO USUN_DM_MC_DZB(sbm,dm,mc,sx)
|
||
VALUES('CKLX','12','借用出库','11');
|
||
INSERT INTO USUN_DM_MC_DZB(sbm,dm,mc,sx)
|
||
VALUES('CKLX','13','返修出库','12');
|
||
INSERT INTO USUN_DM_MC_DZB(sbm,dm,mc,sx)
|
||
VALUES('CKLX','14','定检出库','13');
|
||
INSERT INTO USUN_DM_MC_DZB(sbm,dm,mc,sx)
|
||
VALUES('CKLX','10','报废出库','15');
|
||
--INSERT INTO USUN_DM_MC_DZB(sbm,dm,mc,sx)
|
||
-- VALUES('CKLX','15','其它出库','16');
|
||
|
||
INSERT INTO USUN_DM_MC_DZB(sbm,dm,mc,sx)
|
||
VALUES('CRKDLX','12','借用出库','11');
|
||
INSERT INTO USUN_DM_MC_DZB(sbm,dm,mc,sx)
|
||
VALUES('CRKDLX','13','返修出库','12');
|
||
INSERT INTO USUN_DM_MC_DZB(sbm,dm,mc,sx)
|
||
VALUES('CRKDLX','14','定检出库','13');
|
||
INSERT INTO USUN_DM_MC_DZB(sbm,dm,mc,sx)
|
||
VALUES('CRKDLX','10','报废出库','15');
|
||
--INSERT INTO USUN_DM_MC_DZB(sbm,dm,mc,sx)
|
||
-- VALUES('CRKDLX','15','其它出库','16');
|
||
|
||
INSERT INTO USUN_DM_MC_DZB(sbm,dm,mc,sx)
|
||
VALUES('cpxx.flagLpxx','0','否', 1);
|
||
INSERT INTO USUN_DM_MC_DZB(sbm,dm,mc,sx)
|
||
VALUES('cpxx.flagLpxx','1','是', 2);
|
||
INSERT INTO USUN_DM_MC_DZB(sbm,dm,mc,sx)
|
||
VALUES('cpxx.flagSfmj','1','是', 1);
|
||
INSERT INTO USUN_DM_MC_DZB(sbm,dm,mc,sx)
|
||
VALUES('cpxx.flagSfmj','0','否', 2);
|
||
;
|
||
/
|
||
/*
|
||
SELECT 'INSERT INTO SYS_CONFIG(ID_pzx, pzsm, dqz, mrz, sjlx, qzfw, bz, lx, groupID, xgsj)'
|
||
+ char(13) + char(10) + space(len('INSERT INTO SYS_CONFIG(') - 7) + 'VALUES'
|
||
+ '(''' + ID_PZX + ''''
|
||
+ ',' + ISNULL('''' + PZSM + '''', 'NULL')
|
||
+ ',' + ISNULL('''' + DQZ + '''', 'NULL')
|
||
+ ',' + ISNULL('''' + MRZ + '''', 'NULL')
|
||
+ ',' + ISNULL('''' + SJLX + '''', 'NULL')
|
||
+ ',' + ISNULL('''' + QZFW + '''', 'NULL')
|
||
+ ',' + ISNULL('''' + BZ + '''', 'NULL')
|
||
+ ',' + ISNULL('''' + LX + '''', 'NULL')
|
||
+ ',' + ISNULL('''' + GROUPID + '''', 'NULL')
|
||
+ ',' + ISNULL('TO_DATE(''' + CONVERT(VARCHAR(20), XGSJ, 120) + ''',''YYYY-MM-DD HH24:MI:SS''', 'NULL')
|
||
+ ');'
|
||
FROM SYS_CONFIG
|
||
*/
|
||
/
|
||
DELETE FROM SYS_CONFIG;
|
||
INSERT INTO SYS_CONFIG(ID_pzx, pzsm, dqz, mrz, sjlx, qzfw, bz, lx, groupID, xgsj)
|
||
VALUES('CellInventoryFields','库位状态显示图上，库位库存需显示字段列表','cpbh,cpmc,cpgg1,cpgg3,lpxx,sl,rksj',NULL,'string',NULL,NULL,'S','XSKZ',sysdate);
|
||
INSERT INTO SYS_CONFIG(ID_pzx, pzsm, dqz, mrz, sjlx, qzfw, bz, lx, groupID, xgsj)
|
||
VALUES('ckdj.dh.userInput','是否允许用户自行输入单据编号','0','1','list','0=不允许;1=允许','对于管理上做不到按纸质凭据进行出入库时，让操作者随意输入单号没有实际意义','U','SRKZ',sysdate);
|
||
INSERT INTO SYS_CONFIG(ID_pzx, pzsm, dqz, mrz, sjlx, qzfw, bz, lx, groupID, xgsj)
|
||
VALUES('ckdj.rq.userInput','是否允许用户修改出入库单据的日期','0','0','list','0=不允许;1=允许','随意输入日期会造成系统记录的收发存和实际的不相符','U','SRKZ',sysdate);
|
||
INSERT INTO SYS_CONFIG(ID_pzx, pzsm, dqz, mrz, sjlx, qzfw, bz, lx, groupID, xgsj)
|
||
VALUES('ckdmx.lpxx.input','出库单明细上是否需要指定批号','1','0','list','0=不需要;1=必须输入;2=显示但可以不输入','如果不是选择1，则需要修改视图cp_kyKcmx_v的代码','S','SRKZ',sysdate);
|
||
INSERT INTO SYS_CONFIG(ID_pzx, pzsm, dqz, mrz, sjlx, qzfw, bz, lx, groupID, xgsj)
|
||
VALUES('ckdmx_input_jls','一张出库单的物资明细记录数（绝大多数情况下）','0','0','number','0~','用于判定何时自动关闭明细输入界面。0 表示不固定','U','MRZKZ',sysdate);
|
||
INSERT INTO SYS_CONFIG(ID_pzx, pzsm, dqz, mrz, sjlx, qzfw, bz, lx, groupID, xgsj)
|
||
VALUES('ckdmx_input_srchFlds','出库单明细选择添加界面上可选的检索字段','cpbh, , cpmc, , lpxx','cpbh,pmh,cpgg3,cpgg1','multi','cpbh=存货编码;pmh=品号;txm=条码;cpmc=存货名称;cpgg1=规格型号;cpgg2=材质;cpgg3=图号; =<换行>',NULL,'S','SRKZ',sysdate);
|
||
INSERT INTO SYS_CONFIG(ID_pzx, pzsm, dqz, mrz, sjlx, qzfw, bz, lx, groupID, xgsj)
|
||
VALUES('ckkw.apfs','出库库位安排操作方式','3','3','list','1=自动选择库位;2=手工选取库位;3=弹出选择界面，让用户决定采用自动还是手工',NULL,'U','LCKZ',sysdate);
|
||
INSERT INTO SYS_CONFIG(ID_pzx, pzsm, dqz, mrz, sjlx, qzfw, bz, lx, groupID, xgsj)
|
||
VALUES('ckkw.zdap.kwgs','自动安排出库库位时，每种物品是否仅安排一个库位','0','0','list','0=否(全部安排完);1=是','对于每次出库仅出一个托盘的情况下，应该选择 1。','U','LCKZ',sysdate);
|
||
INSERT INTO SYS_CONFIG(ID_pzx, pzsm, dqz, mrz, sjlx, qzfw, bz, lx, groupID, xgsj)
|
||
VALUES('cpxx_input_match','存货编码输入框上，按用户输入内容模糊查找的筛选语句','(cpmc LIKE ''{0}%'' OR cpgg3 LIKE ''{0}%'' OR cpbh LIKE ''{0}%'')','cpbh LIKE ''''{0}%''''','string',NULL,'双击或按下右向光标键查找时用到该配置','S','SRKZ',sysdate);
|
||
INSERT INTO SYS_CONFIG(ID_pzx, pzsm, dqz, mrz, sjlx, qzfw, bz, lx, groupID, xgsj)
|
||
VALUES('cpxx_input_srchFlds','存货编码输入下拉框上面显示的附加检索字段',NULL,'wzlb,cpgg3,cpgg1,cpgg2','multi','wzlb=存货分类;cpbh=存货编码;pmh=品号;txm=条码;cpmc=存货名称;cpgg1=规格型号;cpgg2=材质;cpgg3=图号',NULL,'S','SRKZ',sysdate);
|
||
INSERT INTO SYS_CONFIG(ID_pzx, pzsm, dqz, mrz, sjlx, qzfw, bz, lx, groupID, xgsj)
|
||
VALUES('cpxx_input_tysx','存货档案输入界面是否有“特有属性”输入标签','0','0','list','0=没有;1=有',NULL,'U','SRKZ',sysdate);
|
||
INSERT INTO SYS_CONFIG(ID_pzx, pzsm, dqz, mrz, sjlx, qzfw, bz, lx, groupID, xgsj)
|
||
VALUES('crkd_zdzf','出入库单接口自动作废处理间隔时间(分钟)','0','1','number(1)','0~60',NULL,'S','ZDKZ',to_date('2008-04-09 10:28:00','YYYY-MM-DD HH24:MI:SS'));
|
||
INSERT INTO SYS_CONFIG(ID_pzx, pzsm, dqz, mrz, sjlx, qzfw, bz, lx, groupID, xgsj)
|
||
VALUES('DB.backup.command','数据库备份命令字符串','NULL',NULL,'string',null,'使用java.text.MessageFormat进行格式化。共两个参数，第0个是数据库名字/用户名，第1个是备份文件完整路径','S','ZDKZ',sysdate);
|
||
INSERT INTO SYS_CONFIG(ID_pzx, pzsm, dqz, mrz, sjlx, qzfw, bz, lx, groupID, xgsj)
|
||
VALUES('devicesInstalledScanner','安装有固定式托盘条码扫描枪的设备ID列表',NULL,NULL,'string',NULL,'重新登录系统才能生效','S',NULL,sysdate);
|
||
INSERT INTO SYS_CONFIG(ID_pzx, pzsm, dqz, mrz, sjlx, qzfw, bz, lx, groupID, xgsj)
|
||
VALUES('ERP_inteface_mode','同ERP接口模式','0','0','list','0=无接口;1=中间表;2=调用ERP过程记帐',NULL,'S','interface',sysdate);
|
||
INSERT INTO SYS_CONFIG(ID_pzx, pzsm, dqz, mrz, sjlx, qzfw, bz, lx, groupID, xgsj)
|
||
VALUES('fieldOnScreen','显示屏上显示出入库物资描述对应字段名称','cpmc','cpbh','string',NULL,NULL,'S','XSKZ',NULL);
|
||
INSERT INTO SYS_CONFIG(ID_pzx, pzsm, dqz, mrz, sjlx, qzfw, bz, lx, groupID, xgsj)
|
||
VALUES('HasScannerInput','客户端界面是否有条码扫描枪配置功能','0','0','list','0=没有;1=有',NULL,'S','SRKZ',sysdate);
|
||
INSERT INTO SYS_CONFIG(ID_pzx, pzsm, dqz, mrz, sjlx, qzfw, bz, lx, groupID, xgsj)
|
||
VALUES('HiddenColumns','需要全局隐藏的字段','*次数,简码,??存放库位,*长度*,*高度*,图号,材质,*价,*额,条形码,收货单位,收货人,交货单位,件装量',NULL,'string',NULL,'需要重新登录才生效','S','XSKZ',sysdate);
|
||
INSERT INTO SYS_CONFIG(ID_pzx, pzsm, dqz, mrz, sjlx, qzfw, bz, lx, groupID, xgsj)
|
||
VALUES('jcsj_zdxz','基础数据接口自动下载处理间隔时间(分钟)','0','1','number(1)','0~60',NULL,'S','ZDKZ',sysdate);
|
||
INSERT INTO SYS_CONFIG(ID_pzx, pzsm, dqz, mrz, sjlx, qzfw, bz, lx, groupID, xgsj)
|
||
VALUES('materialContentFrmt','物料编码输入框列表显示物料描述信息串的组成格式','1','1','list','0=编码＝名称;1=名称|规格|材质|图号＝编码;2=名称|规格|材质|图号',NULL,'S','XSKZ',sysdate);
|
||
INSERT INTO SYS_CONFIG(ID_pzx, pzsm, dqz, mrz, sjlx, qzfw, bz, lx, groupID, xgsj)
|
||
VALUES('MJCK.FILTER','模具出库模块的强制筛选条件', NULL,NULL,'string',NULL,NULL,'S','FILTER',sysdate);
|
||
INSERT INTO SYS_CONFIG(ID_pzx, pzsm, dqz, mrz, sjlx, qzfw, bz, lx, groupID, xgsj)
|
||
VALUES('MJRK.FILTER','模具入库模块的强制筛选条件', NULL,NULL,'string',NULL,NULL,'S','FILTER',sysdate);
|
||
INSERT INTO SYS_CONFIG(ID_pzx, pzsm, dqz, mrz, sjlx, qzfw, bz, lx, groupID, xgsj)
|
||
VALUES('OPR_ON_OPEN_CPXX','打开存货档案模块时，自动执行的操作','1','0','list','0=打开查询窗口;1=读取有效编码记录','修改后需要重新登录才起作用','U','XSKZ',sysdate);
|
||
INSERT INTO SYS_CONFIG(ID_pzx, pzsm, dqz, mrz, sjlx, qzfw, bz, lx, groupID, xgsj)
|
||
VALUES('OPR_ON_OPEN_KCCX','打开库存查询界面，自动执行的操作','0','0','list', '0=打开查询界面;1=直接显示库存', '在没有查询结果的情况下才启作用','U','XSKZ', sysdate);
|
||
INSERT INTO SYS_CONFIG(ID_pzx, pzsm, dqz, mrz, sjlx, qzfw, bz, lx, groupID, xgsj)
|
||
VALUES('quantity.scale','数量的小数位数','0','3','list','0~3',NULL,'U','SRKZ',sysdate);
|
||
INSERT INTO SYS_CONFIG(ID_pzx, pzsm, dqz, mrz, sjlx, qzfw, bz, lx, groupID, xgsj)
|
||
VALUES('rkdmx_input_cpsl','入库单物资明细输入界面上，‘应收数量’输入框中的默认值',NULL,NULL,'number','0~','对于入库前不知道具体数量的情形，应设定为0，此时实际可装盘的数量不受应收数量的限制','U','MRZKZ',sysdate);
|
||
INSERT INTO SYS_CONFIG(ID_pzx, pzsm, dqz, mrz, sjlx, qzfw, bz, lx, groupID, xgsj)
|
||
VALUES('rkdmx_input_jls','一张入库单的物资明细记录数（绝大多数情况下）','0','0','number','0~','用于判定何时自动关闭明细输入界面。0 表示不固定','U','MRZKZ',sysdate);
|
||
INSERT INTO SYS_CONFIG(ID_pzx, pzsm, dqz, mrz, sjlx, qzfw, bz, lx, groupID, xgsj)
|
||
VALUES('rkzl.tpbh.input','入库组盘确认前，是否要求必须输入托盘号','1','0','list','0=否;1=是','对于通过固定式条码扫描枪下发入库任务的，则应选择必须输入','U','SRKZ',sysdate);
|
||
INSERT INTO SYS_CONFIG(ID_pzx, pzsm, dqz, mrz, sjlx, qzfw, bz, lx, groupID, xgsj)
|
||
VALUES('rkzl_input_tpbh','是否允许手工输入托盘号条码','2','1','list','0=不允许;1=允许;2=不显示托盘号输入框','入库库位安排界面和空托盘入库界面用该配置控制“托盘条码”输入是否可编辑','U','SRKZ',sysdate);
|
||
INSERT INTO SYS_CONFIG(ID_pzx, pzsm, dqz, mrz, sjlx, qzfw, bz, lx, groupID, xgsj)
|
||
VALUES('rkzlsc_show_zdzr','入库库位安排界面上，是否显示“自动装入最近存放库位”按钮','1','0','list','0=不显示;1=显示','最近存放库位在库位上物资最近一次全部出库时记录','U','SRKZ',sysdate);
|
||
INSERT INTO SYS_CONFIG(ID_pzx, pzsm, dqz, mrz, sjlx, qzfw, bz, lx, groupID, xgsj)
|
||
VALUES('rkzlsc_show_zjcfkw','入库库位安排界面上，待入库表格中是否显示‘最近存放库位’栏目','1','0','list','0=不显示;1=显示',NULL,'S','XSKZ',sysdate);
|
||
INSERT INTO SYS_CONFIG(ID_pzx, pzsm, dqz, mrz, sjlx, qzfw, bz, lx, groupID, xgsj)
|
||
VALUES('rkzlsc_show_zjrks','入库库位安排界面上，是否显示“可追加入库数”输入框','0','1','list','0=不显示;1=显示','用于记录下次还可以向目标库位上追加的数量，用于备忘','U','SRKZ',sysdate);
|
||
INSERT INTO SYS_CONFIG(ID_pzx, pzsm, dqz, mrz, sjlx, qzfw, bz, lx, groupID, xgsj)
|
||
VALUES('rkzlsc_show_sameMaterialCheck','入库库位安排界面的库位筛选区域里是否显示‘存放同一物资的库位’筛选条件','0','1','list','0=不显示;1=显示',NULL,'U','XSKZ',sysdate);
|
||
INSERT INTO SYS_CONFIG(ID_pzx, pzsm, dqz, mrz, sjlx, qzfw, bz, lx, groupID, xgsj)
|
||
VALUES('rkzlsc_zdzx_checkbox','入库指令生成界面上，“立刻下发新的立体仓库作业指令”勾选框状态','0','3','list','0=不显示;1=显示但不勾选;3=显示且默认勾选',NULL,'U','MRZKZ',sysdate);
|
||
INSERT INTO SYS_CONFIG(ID_pzx, pzsm, dqz, mrz, sjlx, qzfw, bz, lx, groupID, xgsj)
|
||
VALUES('rkzlsc_clrCellOnMaterialChange','入库库位安排界面上，如果调整了装入托盘的物资，是否清除之前带出的可入库位','2','0','list','0=不清除;1=提示清除;2=强制清除',NULL,'U','LCKZ',sysdate);
|
||
INSERT INTO SYS_CONFIG(ID_pzx, pzsm, dqz, mrz, sjlx, qzfw, bz, lx, groupID, xgsj)
|
||
VALUES('srkz.tpbh.regex','托盘编号输入规则','T[0-9][0-9][0-9][0-9]','T[0-9][0-9][0-9][0-9]','string',NULL,'如果用户输入的托盘号字符串不满足规则，程序应该报错','S','SRKZ',sysdate);
|
||
INSERT INTO SYS_CONFIG(ID_pzx, pzsm, dqz, mrz, sjlx, qzfw, bz, lx, groupID, xgsj)
|
||
VALUES('wmcsEntrances','可选出入库口',NULL,NULL,'string',NULL,NULL,'S',NULL,NULL);
|
||
INSERT INTO SYS_CONFIG(ID_pzx, pzsm, dqz, mrz, sjlx, qzfw, bz, lx, groupID, xgsj)
|
||
VALUES('wmcs-server','监控系统服务器网络访问地址','localhost',NULL,'string',NULL,'一般填写监控服务器IP地址','U','WBDZ',sysdate);
|
||
INSERT INTO SYS_CONFIG(ID_pzx, pzsm, dqz, mrz, sjlx, qzfw, bz, lx, groupID, xgsj)
|
||
VALUES('wmcs-server-port','监控系统服务器网络访问端口','8080','8080','number','60~9999',NULL,'U','WBDZ',sysdate);
|
||
INSERT INTO SYS_CONFIG(ID_pzx, pzsm, dqz, mrz, sjlx, qzfw, bz, lx, groupID, xgsj)
|
||
VALUES('DB.alter.column.syntax','本数据库管理系统中ALTER TABLE语法中，修改列属性语法','MODIFY','ALTER COLUMN','string', NULL,NULL,'S','XTTX', sysdate);
|
||
INSERT INTO SYS_CONFIG(ID_pzx, pzsm, dqz, mrz, sjlx, qzfw, bz, lx, groupID, xgsj)
|
||
VALUES('DB.function.datepart','本数据库管理系统中，提取日期某个属性值的函数','datepart(''''{0}'''',{1})','datepart({0},{1})','string', NULL,'SQL Server数据库用的是默认值','S','XTTX', sysdate);
|
||
INSERT INTO SYS_CONFIG(ID_pzx, pzsm, dqz, mrz, sjlx, qzfw, bz, lx, groupID, xgsj)
|
||
VALUES('DB.function.datediff','本数据库管理系统中，提取两个日期差的函数','DATEDIFF(''''{0}'''',{1}, {2})','DATEDIFF({0},{1},{2})','string', NULL,'SQL Server数据库用的是默认值','S','XTTX', sysdate);
|
||
INSERT INTO SYS_CONFIG(ID_pzx, pzsm, dqz, mrz, sjlx, qzfw, bz, lx, groupID, xgsj)
|
||
VALUES('srkz.jsr.srff','出入库单据输入界面上，经手人的输入方法','1','0','list', '0=记忆选择输入;1=从人员信息表中取','如果人员信息模块不开放，则应该使用默认值','S','SRKZ', sysdate);
|
||
INSERT INTO SYS_CONFIG(ID_pzx, pzsm, dqz, mrz, sjlx, qzfw, bz, lx, groupID, xgsj)
|
||
VALUES('delete_0_inventory','是否自动删除零库存记录','1','1','list', '0=否;1=是','对于存货是按件管理的模具，且模具总是定库位存放的，应该设定为0','U','XTKZ', sysdate);
|
||
INSERT INTO SYS_CONFIG(ID_pzx, pzsm, dqz, mrz, sjlx, qzfw, bz, lx, groupID, xgsj)
|
||
VALUES('update_cpxx_cfkw','是否自动更新存货档案信息记录上的最近存放库位和当前存放库存字段的值','1','0','list', '0=否;1=是','对于存货是按件管理的模具，应该设定为1','U','XTKZ', sysdate);
|
||
INSERT INTO SYS_CONFIG(ID_pzx, pzsm, dqz, mrz, sjlx, qzfw, bz, lx, groupID, xgsj)
|
||
VALUES('lckz_mjrk_rkkwap','入库单生成后，是否自动安排入库库位为最近存放库位','1','0','list', '0=否;1=是','对于定库位存放的模具类仓库','U','LCKZ', sysdate);
|
||
INSERT INTO SYS_CONFIG(ID_pzx, pzsm, dqz, mrz, sjlx, qzfw, bz, lx, groupID, xgsj)
|
||
VALUES('srkz.cellNoDigitMax','库位编号字符串中排、列、层编号的最大值','99,99,12','99,99,99','string', 'NULL','需要同stock.xml文件同步修改。在库位定义界面上用到该配置。','U','LCKZ', sysdate);
|
||
/
|
||
|
||
INSERT INTO lisence(lisence, ID, info, name, sysname)
|
||
VALUES('重庆青山', 'WXZD-CQQS', '重庆', '重庆青山', '立体仓库存货管理系统');
|
||
/
|
||
/*
|
||
SELECT 'INSERT INTO ZC_SEQUENCE(SEQUENCENAME,CURRENTVALUE,MINVALUE,MAXVALUE,DIGIT,APPENDIX1,BZ)'
|
||
+ char(13) + char(10) + space(len('INSERT INTO ZC_SEQUENCE(') - 7) + 'VALUES'
|
||
+ '(''' + SEQUENCENAME + ''''
|
||
+ ',' + ISNULL('''' + CAST(1 AS VARCHAR(20)) + '''', 'NULL')
|
||
+ ',' + ISNULL('''' + CAST(MINVALUE AS VARCHAR(20)) + '''', 'NULL')
|
||
+ ',' + ISNULL('''' + CAST(MAXVALUE AS VARCHAR(20)) + '''', 'NULL')
|
||
+ ',' + ISNULL('''' + CAST(DIGIT AS VARCHAR(20)) + '''', 'NULL')
|
||
+ ',' + ISNULL('''' + APPENDIX1 + '''', 'NULL')
|
||
+ ',' + ISNULL('''' + BZ + '''', 'NULL')
|
||
+ ');'
|
||
FROM ZC_SEQUENCE
|
||
*/
|
||
/
|
||
DELETE FROM ZC_SEQUENCE;
|
||
INSERT INTO ZC_SEQUENCE(SEQUENCENAME,CURRENTVALUE,MINVALUE,MAXVALUE,DIGIT,APPENDIX1,BZ)
|
||
VALUES('ckd','1','1','9999999999','10','C','出库单编号');
|
||
INSERT INTO ZC_SEQUENCE(SEQUENCENAME,CURRENTVALUE,MINVALUE,MAXVALUE,DIGIT,APPENDIX1,BZ)
|
||
VALUES('cpckmxbh','1','1','9999999999','10',NULL,'产品出库明细编号');
|
||
INSERT INTO ZC_SEQUENCE(SEQUENCENAME,CURRENTVALUE,MINVALUE,MAXVALUE,DIGIT,APPENDIX1,BZ)
|
||
VALUES('cprkd','1','1','9999999999','10','R','入库单编号');
|
||
INSERT INTO ZC_SEQUENCE(SEQUENCENAME,CURRENTVALUE,MINVALUE,MAXVALUE,DIGIT,APPENDIX1,BZ)
|
||
VALUES('cprkmxbh','1','1','9999999999','10',NULL,'产品入库明细编号');
|
||
INSERT INTO ZC_SEQUENCE(SEQUENCENAME,CURRENTVALUE,MINVALUE,MAXVALUE,DIGIT,APPENDIX1,BZ)
|
||
VALUES('khbh','1','1','999999','6',NULL,'客户编号');
|
||
INSERT INTO ZC_SEQUENCE(SEQUENCENAME,CURRENTVALUE,MINVALUE,MAXVALUE,DIGIT,APPENDIX1,BZ)
|
||
VALUES('pdd','1','1','9999999999','10','P','盘库单编号');
|
||
INSERT INTO ZC_SEQUENCE(SEQUENCENAME,CURRENTVALUE,MINVALUE,MAXVALUE,DIGIT,APPENDIX1,BZ)
|
||
VALUES('zlztzhd','1','1','9999999999','10','ZH','质量状态转换单编号');
|
||
;
|
||
/
|
||
/*
|
||
SELECT 'INSERT INTO sys_string_resource(locale, id, caption)'
|
||
+ char(13) + char(10) + space(len('INSERT INTO sys_string_resource(') - 7) + 'VALUES'
|
||
+ '(''' + locale + ''''
|
||
+ ',' + ISNULL('''' + id + '''', 'NULL')
|
||
+ ',' + ISNULL('''' + caption + '''', 'NULL')
|
||
+ ');'
|
||
FROM sys_string_resource
|
||
*/
|
||
DELETE FROM sys_string_resource;
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','aqkc','安全库存量');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','bgck','授权保管仓库');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','bgwz','保管位置');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','bgy','保管员');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','bz','备注');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','bzbh','部门');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','bzr','编制人');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','cd', '长度(mm)');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','ceng','层');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','cfkwFqsx','存放库位分区');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','cgy','采购员');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','ckbh','仓库');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','ckck','出库仓库');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','ckdh','出库单号');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','cklx','出库类型');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','ckmc','仓库');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','ckrq','出库日期');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','cksl','出库数量');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','clfs','处理方式');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','cpbh','存货编码');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','cpgg1','规格型号');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','cpgg2','材质');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','cpgg3','图号');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','cpmc','存货名称');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','creation_date','建档时间');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','czr','操作人');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','dataType','数据类型');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','ddbh','订单号');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','ddhh','订单行号');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','dgdw','订购单位');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','dh','单号');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','dj','单价');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','djbh','ERP事务号');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','djlsh','ERP单据流水号');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','djlx','ERP事务类型');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','djzt','单据状态');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','dm','代码');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','dqcfkw','当前存放库位');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','drsl','待入数量');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','dwhsxs','单位换算系数');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','dz','单重(kg)');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','erp_id','ERP代号');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','fcsl','发出数');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','fieldCaption','栏目名称');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','fieldName','栏目代码');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','flagLpxx','按批管理');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','flagSfmj','按件管理');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','frjs','放入件数');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','frsl','放入数量');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','gd','高度(mm)');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','ghrq','归还日期');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','ghs','来源');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','gmrq','购买日期');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','gsdl','归属大类');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','gydw','来源');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','gzdw','工作单位');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','gzsj','工作时间');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','hjsl','合计数量');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','hkzt','入库状态');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','instStatus','指令状态');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','jbjs','角色');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','je','金额');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','jhcks','计划出库数');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','jhj','计划价');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','jhzyl','计划占用量');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','jldw','计量单位');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','jlh','记录号');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','jussl','拒收数量');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','jzl','件装量');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','kcbz','库存备注');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','kcfps','库存数');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','kcsl','库存数量');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','kcsx','最高库存量');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','kcxx','最低库存量');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','kd', '宽度(mm)');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','kfwpcd','可放物品长度(mm)');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','kfwpkd','可放物品宽度(mm)');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','kfwpgd','可放物品高度(mm)');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','kfwpzl','可放物品重量(kg)');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','khbh','客户');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','kwbh','库位号');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','kyl','可用量');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','kzjrks','可追加入库数');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','last_update_date','最近更新时间');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','lb','类别');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','lie','列');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','ljgzsj','累计工作时间');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','ljsycs','累计已使用次数');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','llr','经手人');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','llswh','领料事务号');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','lpxx','批号');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','lx','类型');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','lyqx','来源去向');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','mc','名称');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','mcsycs','每次生产使用次数');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','mjsycs','使用次数');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','mm','密码');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','mxbh','明细编号');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','nullable','允许空值');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','orderIndex','显示顺序');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','pai','排');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','ph','订单号');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','phkz','批号控制');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','pjjg','均价');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','pmh','简码');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','pzbh','凭证号');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','pzrq','日期');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','qczt','取出状态');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','qxdh','保管存货分类');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','qysx','分区类别');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','rERPck','至ERP仓库');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','rERPkq','至ERP库区');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','rkck','入库仓库');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','rkdh','入库单号');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','rkrq','入库日期');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','rksj','入库时间');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','rksl','应收数量');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','rygh','人员工号');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','ryxm','人员姓名');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','lxdh','联系电话');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','txdz','通讯地址');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','dzyj','电子邮件');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','rq','日期');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','sbbh','设备编号');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','scdw','制造单位');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','scrq','生产日期');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','scsj','生成时间');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','sfky','是否启用');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','sflz','是否蓝字');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','sftz','已调整库存?');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','sfyx','是否启用');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','shdw','去向');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','shr','审核人');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','shrq','出库日期');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','shsj','审核时间');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','shsl','请领数量');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','sjsl','实际数');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','sl','数量');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','slr','经手人');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','srsl','收入数');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','ssgs','所属公司');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','sycs','使用次数');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','sycsAfterZjwx','最近维修后使用次数');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','sypc','使用频次');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','tpbh','托盘号');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','tpxl','限装件数/托盘');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','txm','条形码');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','tzr','调整人');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','tzsj','调整时间');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','validValue','取值范围');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','wapsl','未安排数量');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','wcsj','完成时间');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','wlgg','规格型号');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','wlmc','存货名称');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','wzbh','存货编码');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','wzlb','存货分类');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','xishu','系数');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','xm','姓名');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','xnkw','虚拟库位?');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','yapsl','已安排数');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','ycwxsycs','每次维修后可使用次数');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','yhm','制单人');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','yk','盈亏数');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','ykcs','原库存数');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','ykcsl','原库存数量');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','ysdh','入库单号');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','ysrq','入库日期');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','yszf','运输杂费');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','yxsycs','最多允许使用次数');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','yzjs','已装件数');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','yzsl','已装数量');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','zcck','转出仓库');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','zckw','转出库位');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','zctp','转出托盘');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','zdsl','在单量');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','zj','总价');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','zjcfkw','最近存放库位');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','zje','总金额');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','zjsl','在检数量');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','zl','质量状态');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','zlbh','指令号');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','zlx','单据子类');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','zlzt','质量状态');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','zrck','转入仓库');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','zrkw','转入库位');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','zrtp','转入托盘');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','zcs','总次数');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','zsl','总数量');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','zt','状态');
|
||
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','cERPck','自ERP仓库');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','cERPkq','自ERP库区');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','xilieh','系列号');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','banci','版次号');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','djzq','定检周期(天)');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','syyzrq','试用验证日期');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','sqdh','申请单号');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','jxh','机型号');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','cpth','产品图号');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','pinzhbh','品种表号');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','zjm','助记码');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','cfwzxx','存放位置信息');
|
||
INSERT INTO sys_string_resource(locale, id, caption)
|
||
VALUES('zh_CN','lssl','零散数量');
|
||
;
|
||
/
|
||
insert into ckxx(dm, mc, fblx, sfpk, flagTpzx)values('LTCK', '自动化立体仓库', 0, 0, 1);
|
||
|
||
-- UPDATE lisence SET zckey='-5335391492118742774';
|
||
/
|
||
|
||
INSERT INTO sys_external_tools(orderIndex, title, command, keyStroke)
|
||
VALUES(10,'测试账套(C)','javaws.exe "$$base/wmsceshi/index.jnlp?user=$$user"',NULL);
|
||
INSERT INTO sys_external_tools(orderIndex, title, command, keyStroke)
|
||
VALUES(99,'仓库监控系统','javaws.exe "$$base/wcs/index.jnlp"',NULL);
|
||
INSERT INTO sys_external_tools(orderIndex, title, command, keyStroke)
|
||
VALUES(1,'计算器','calc.exe','F9');
|
||
INSERT INTO sys_external_tools(orderIndex, title, command, keyStroke)
|
||
VALUES(2,'','---------',NULL);
|
||
/
|
||
|
||
INSERT INTO sys_SQL_statements(ID, SQL_string, remark)
|
||
VALUES('ckpxx','SELECT pai,CAST(MAX(lie) AS VARCHAR(3)),CAST(MAX(ceng) AS VARCHAR(2)) FROM kwjbxx WHERE ckmc=? AND sfyx=1 GROUP BY pai ORDER BY pai','提取指定仓库排信息的查询语句。');
|
||
INSERT INTO sys_SQL_statements(ID, SQL_string, remark)
|
||
VALUES('ktpKrkw','SELECT TOP 1 kwbh FROM kwjbxx WHERE ckmc=? AND sfsd=0 AND zsl=0 AND xnkw=0 AND sfyx=1 AND flagKzkw=0 AND kwbh LIKE ''{0}%'' ORDER BY CASE WHEN qysx=''KTP'' THEN 0 ELSE (CASE WHEN lie<=15 THEN lie*(3+ceng) ELSE lie*20 END) END,ceng,pai DESC','提取空托盘可入库位的查询语句。');
|
||
INSERT INTO sys_SQL_statements(ID, SQL_string, remark)
|
||
VALUES('orderClauseForDistance','CASE WHEN lie<=15 THEN lie*(3+ceng) ELSE lie*20 END,ceng,pai','提取可入库库位时，库位表的ORDER BY子句部分。');
|
||
|
||
|
||
|
||
COMMIT;
|