MTP2.0_CSharp/Muchinfo.MTPClient/Fx4.0/Main/01.Documents/mtp交易端菜单配置.txt

delete from funcmenulist f where f.TERMINALTYPE = 0;

insert into  funcmenulist(funcmenuid,funcmenuname,funcmenucode,parentfuncmenucode,operatefunc,TERMINALTYPE,SEQ)values(1043,'交易',1043,-1,0,0,1000);
insert into  funcmenulist(funcmenuid,funcmenuname,funcmenucode,parentfuncmenucode,operatefunc,TERMINALTYPE,SEQ)values(1021,'买入',1021,1043,0,0,1001);
insert into  funcmenulist(funcmenuid,funcmenuname,funcmenucode,parentfuncmenucode,operatefunc,TERMINALTYPE,SEQ)values(1022,'卖出',1022,1043,0,0,1002);
insert into  funcmenulist(funcmenuid,funcmenuname,funcmenucode,parentfuncmenucode,operatefunc,TERMINALTYPE,SEQ)values(1023,'撤单',1023,1043,0,0,1003);
insert into  funcmenulist(funcmenuid,funcmenuname,funcmenucode,parentfuncmenucode,operatefunc,TERMINALTYPE,SEQ)values(1024,'申购',1024,1043,0,0,1004);

insert into  funcmenulist(funcmenuid,funcmenuname,funcmenucode,parentfuncmenucode,operatefunc,TERMINALTYPE,SEQ)values(1001,'查询',1001,-1,0,0,1005);
insert into  funcmenulist(funcmenuid,funcmenuname,funcmenucode,parentfuncmenucode,operatefunc,TERMINALTYPE,SEQ)values(1002,'资金信息',1002,1001,0,0,1006);
insert into  funcmenulist(funcmenuid,funcmenuname,funcmenucode,parentfuncmenucode,operatefunc,TERMINALTYPE,SEQ)values(1003,'委托单',1003,1001,0,0,1007);
--删除“持仓单”菜单
--insert into  funcmenulist(funcmenuid,funcmenuname,funcmenucode,parentfuncmenucode,operatefunc,TERMINALTYPE,SEQ)values(1004,'持仓单',1004,1001,0,0,1008);
--修改【持仓汇总-》持仓单】
insert into  funcmenulist(funcmenuid,funcmenuname,funcmenucode,parentfuncmenucode,operatefunc,TERMINALTYPE,SEQ)values(1005,'持仓汇总',1005,1001,0,0,1009);

insert into  funcmenulist(funcmenuid,funcmenuname,funcmenucode,parentfuncmenucode,operatefunc,TERMINALTYPE,SEQ)values(1067,'持仓汇总',1067,1001,0,0,1010);

--insert into  funcmenulist(funcmenuid,funcmenuname,funcmenucode,parentfuncmenucode,operatefunc,TERMINALTYPE,SEQ)values(1006,'建仓明细',1006,1001,0,0,1010);
--insert into  funcmenulist(funcmenuid,funcmenuname,funcmenucode,parentfuncmenucode,operatefunc,TERMINALTYPE,SEQ)values(1009,'平仓明细',1009,1001,0,0,1011);
insert into  funcmenulist(funcmenuid,funcmenuname,funcmenucode,parentfuncmenucode,operatefunc,TERMINALTYPE,SEQ)values(1066,'成交明细',1066,1001,0,0,1011);
insert into  funcmenulist(funcmenuid,funcmenuname,funcmenucode,parentfuncmenucode,operatefunc,TERMINALTYPE,SEQ)values(1036,'交收单',1036,1031,0,0,1012);
insert into  funcmenulist(funcmenuid,funcmenuname,funcmenucode,parentfuncmenucode,operatefunc,TERMINALTYPE,SEQ)values(1008,'日志查询',1008,1001,0,0,1013);
insert into  funcmenulist(funcmenuid,funcmenuname,funcmenucode,parentfuncmenucode,operatefunc,TERMINALTYPE,SEQ)values(1041,'预埋单',1041,1001,0,0,1033);
insert into  funcmenulist(funcmenuid,funcmenuname,funcmenucode,parentfuncmenucode,operatefunc,TERMINALTYPE,SEQ)values(1042,'配号中签',1042,1001,0,0,1034);

insert into  funcmenulist(funcmenuid,funcmenuname,funcmenucode,parentfuncmenucode,operatefunc,TERMINALTYPE,SEQ)values(1037,'报表查询',1037,-1,15,0,1074);
insert into  funcmenulist(funcmenuid,funcmenuname,funcmenucode,parentfuncmenucode,operatefunc,TERMINALTYPE,SEQ)values(1038,'日报表',1038,1037,15,0,1015);
 
insert into  funcmenulist(funcmenuid,funcmenuname,funcmenucode,parentfuncmenucode,operatefunc,TERMINALTYPE,SEQ)values(1018,'公告通知',1018,-1,0,0,1078);
insert into  funcmenulist(funcmenuid,funcmenuname,funcmenucode,parentfuncmenucode,operatefunc,TERMINALTYPE,SEQ)values(1019,'公告',1019,1018,0,0,1019);
insert into  funcmenulist(funcmenuid,funcmenuname,funcmenucode,parentfuncmenucode,operatefunc,TERMINALTYPE,SEQ)values(1020,'通知',1020,1018,0,0,1020);

insert into  funcmenulist(funcmenuid,funcmenuname,funcmenucode,parentfuncmenucode,operatefunc,TERMINALTYPE,SEQ)values(1010,'银行业务',1010,-1,0,0,1081);
insert into  funcmenulist(funcmenuid,funcmenuname,funcmenucode,parentfuncmenucode,operatefunc,TERMINALTYPE,SEQ)values(1011,'出金申请',1011,1010,0,0,1022);
insert into  funcmenulist(funcmenuid,funcmenuname,funcmenucode,parentfuncmenucode,operatefunc,TERMINALTYPE,SEQ)values(1012,'入金申请',1012,1010,0,0,1023);
insert into  funcmenulist(funcmenuid,funcmenuname,funcmenucode,parentfuncmenucode,operatefunc,TERMINALTYPE,SEQ)values(1013,'出入金查询',1013,1010,0,0,1024);
insert into  funcmenulist(funcmenuid,funcmenuname,funcmenucode,parentfuncmenucode,operatefunc,TERMINALTYPE,SEQ)values(1015,'银行签约',1015,1010,0,0,1025);
insert into  funcmenulist(funcmenuid,funcmenuname,funcmenucode,parentfuncmenucode,operatefunc,TERMINALTYPE,SEQ)values(1016,'银行解约',1016,1010,0,0,1026);
insert into  funcmenulist(funcmenuid,funcmenuname,funcmenucode,parentfuncmenucode,operatefunc,TERMINALTYPE,SEQ)values(1017,'银行变更',1017,1010,0,0,1027);

insert into  funcmenulist(funcmenuid,funcmenuname,funcmenucode,parentfuncmenucode,operatefunc,TERMINALTYPE,SEQ)values(1049,'仓单管理',1049,-1,0,0,1031);
insert into  funcmenulist(funcmenuid,funcmenuname,funcmenucode,parentfuncmenucode,operatefunc,TERMINALTYPE,SEQ)values(1050,'仓单查询',1050,1049,0,0,1032);
insert into  funcmenulist(funcmenuid,funcmenuname,funcmenucode,parentfuncmenucode,operatefunc,TERMINALTYPE,SEQ)values(1051,'提货申请',1051,1049,0,0,1033);
insert into  funcmenulist(funcmenuid,funcmenuname,funcmenucode,parentfuncmenucode,operatefunc,TERMINALTYPE,SEQ)values(1052,'提货查询',1052,1049,0,0,1034);


insert into  funcmenulist(funcmenuid,funcmenuname,funcmenucode,parentfuncmenucode,operatefunc,TERMINALTYPE,SEQ)values(1025,'交收管理',1025,-1,0,0,1043);
--删除insert into  funcmenulist(funcmenuid,funcmenuname,funcmenucode,parentfuncmenucode,operatefunc,TERMINALTYPE,SEQ)values(1044,'交割申报',1044,1025,0,0,1044);
insert into  funcmenulist(funcmenuid,funcmenuname,funcmenucode,parentfuncmenucode,operatefunc,TERMINALTYPE,SEQ)values(1045,'交割申报查询',1045,1025,0,0,1045);
--修改“交割单查询”-“购销合同”
insert into  funcmenulist(funcmenuid,funcmenuname,funcmenucode,parentfuncmenucode,operatefunc,TERMINALTYPE,SEQ)values(1046,'购销合同',1046,1025,0,0,1046);

 insert into  funcmenulist(funcmenuid,funcmenuname,funcmenucode,parentfuncmenucode,operatefunc,TERMINALTYPE,SEQ)values(1053,'交割成交单',1053,1025,0,0,1053);

insert into  funcmenulist(funcmenuid,funcmenuname,funcmenucode,parentfuncmenucode,operatefunc,TERMINALTYPE,SEQ)values(1060,'商城管理',1060,-1,0,0,1060);
insert into  funcmenulist(funcmenuid,funcmenuname,funcmenucode,parentfuncmenucode,operatefunc,TERMINALTYPE,SEQ)values(1061,'摘牌查询',1061,1060,0,0,1061);

insert into  funcmenulist(funcmenuid,funcmenuname,funcmenucode,parentfuncmenucode,operatefunc,TERMINALTYPE,SEQ)values(1062,'资金流水',1062,1001,0,0,1062);


insert into  funcmenulist(funcmenuid,funcmenuname,funcmenucode,parentfuncmenucode,operatefunc,TERMINALTYPE,SEQ)values(1064,'协议平仓',1064,1043,0,0,1062);

insert into  funcmenulist(funcmenuid,funcmenuname,funcmenucode,parentfuncmenucode,operatefunc,TERMINALTYPE,SEQ)values(1065,'托管查询',1065,1001,0,0,1065);
 
 insert into  funcmenulist(funcmenuid,funcmenuname,funcmenucode,parentfuncmenucode,operatefunc,TERMINALTYPE,SEQ)values(1013,'出入金查询',1013,1010,0,0,1024);
insert into  funcmenulist(funcmenuid,funcmenuname,funcmenucode,parentfuncmenucode,operatefunc,TERMINALTYPE,SEQ)values(1015,'银行签约',1015,1010,0,0,1025);

update funcmenulist set funcmenuname='出入金',SEQ=1025 where funcmenuid=1013;
update funcmenulist set funcmenuname='签约信息',SEQ=1024 where funcmenuid=1015;
 
insert into  funcmenulist(funcmenuid,funcmenuname,funcmenucode,parentfuncmenucode,operatefunc,TERMINALTYPE,SEQ)values(1068,'历史单据',1068,1001,0,0,1011);


insert into  funcmenulist(funcmenuid,funcmenuname,funcmenucode,parentfuncmenucode,operatefunc,TERMINALTYPE,SEQ)values(1069,'我的挂牌',1069,1060,0,0,1069);
insert into  funcmenulist(funcmenuid,funcmenuname,funcmenucode,parentfuncmenucode,operatefunc,TERMINALTYPE,SEQ)values(1070,'我的摘牌',1070,1060,0,0,1070);
insert into  funcmenulist(funcmenuid,funcmenuname,funcmenucode,parentfuncmenucode,operatefunc,TERMINALTYPE,SEQ)values(1071,'我的订单',1071,1060,0,0,1071);