Etusivu Tutki Apua
Rekisteröidy Kirjaudu sisään
MTP2.0_New
/
MTP2.0_CSharp
2
0
Fork 0
Tiedostot Ongelmat 0 Pull-pyynnöt 0 Wiki
Puu: 479f7a996a
Branchit Tagit
MTP2.0_CSharp
/
Muchinfo.MTPClient
/
Fx4.0
/
Main
/
01.Documents
/
mtp交易端菜单配置.txt

mtp交易端菜单配置.txt 7.8 KB
Historia Raaka

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778 
  1. 

  2. delete from funcmenulist f where f.TERMINALTYPE = 0;
    3. 

  3. 

  4. insert into  funcmenulist(funcmenuid,funcmenuname,funcmenucode,parentfuncmenucode,operatefunc,TERMINALTYPE,SEQ)values(1043,'交易',1043,-1,0,0,1000);
    5. 

  5. insert into  funcmenulist(funcmenuid,funcmenuname,funcmenucode,parentfuncmenucode,operatefunc,TERMINALTYPE,SEQ)values(1021,'买入',1021,1043,0,0,1001);
    6. 

  6. insert into  funcmenulist(funcmenuid,funcmenuname,funcmenucode,parentfuncmenucode,operatefunc,TERMINALTYPE,SEQ)values(1022,'卖出',1022,1043,0,0,1002);
    7. 

  7. insert into  funcmenulist(funcmenuid,funcmenuname,funcmenucode,parentfuncmenucode,operatefunc,TERMINALTYPE,SEQ)values(1023,'撤单',1023,1043,0,0,1003);
    8. 

  8. insert into  funcmenulist(funcmenuid,funcmenuname,funcmenucode,parentfuncmenucode,operatefunc,TERMINALTYPE,SEQ)values(1024,'申购',1024,1043,0,0,1004);
    9. 

  9. 

  10. insert into  funcmenulist(funcmenuid,funcmenuname,funcmenucode,parentfuncmenucode,operatefunc,TERMINALTYPE,SEQ)values(1001,'查询',1001,-1,0,0,1005);
    11. 

  11. insert into  funcmenulist(funcmenuid,funcmenuname,funcmenucode,parentfuncmenucode,operatefunc,TERMINALTYPE,SEQ)values(1002,'资金信息',1002,1001,0,0,1006);
    12. 

  12. insert into  funcmenulist(funcmenuid,funcmenuname,funcmenucode,parentfuncmenucode,operatefunc,TERMINALTYPE,SEQ)values(1003,'委托单',1003,1001,0,0,1007);
    13. 

  13. --删除“持仓单”菜单
    14. 

  14. --insert into  funcmenulist(funcmenuid,funcmenuname,funcmenucode,parentfuncmenucode,operatefunc,TERMINALTYPE,SEQ)values(1004,'持仓单',1004,1001,0,0,1008);
    15. 

  15. --修改【持仓汇总-》持仓单】
    16. 

  16. insert into  funcmenulist(funcmenuid,funcmenuname,funcmenucode,parentfuncmenucode,operatefunc,TERMINALTYPE,SEQ)values(1005,'持仓汇总',1005,1001,0,0,1009);
    17. 

  17. 

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

  19. 

  20. --insert into  funcmenulist(funcmenuid,funcmenuname,funcmenucode,parentfuncmenucode,operatefunc,TERMINALTYPE,SEQ)values(1006,'建仓明细',1006,1001,0,0,1010);
    21. 

  21. --insert into  funcmenulist(funcmenuid,funcmenuname,funcmenucode,parentfuncmenucode,operatefunc,TERMINALTYPE,SEQ)values(1009,'平仓明细',1009,1001,0,0,1011);
    22. 

  22. insert into  funcmenulist(funcmenuid,funcmenuname,funcmenucode,parentfuncmenucode,operatefunc,TERMINALTYPE,SEQ)values(1066,'成交明细',1066,1001,0,0,1011);
    23. 

  23. insert into  funcmenulist(funcmenuid,funcmenuname,funcmenucode,parentfuncmenucode,operatefunc,TERMINALTYPE,SEQ)values(1036,'交收单',1036,1031,0,0,1012);
    24. 

  24. insert into  funcmenulist(funcmenuid,funcmenuname,funcmenucode,parentfuncmenucode,operatefunc,TERMINALTYPE,SEQ)values(1008,'日志查询',1008,1001,0,0,1013);
    25. 

  25. insert into  funcmenulist(funcmenuid,funcmenuname,funcmenucode,parentfuncmenucode,operatefunc,TERMINALTYPE,SEQ)values(1041,'预埋单',1041,1001,0,0,1033);
    26. 

  26. insert into  funcmenulist(funcmenuid,funcmenuname,funcmenucode,parentfuncmenucode,operatefunc,TERMINALTYPE,SEQ)values(1042,'配号中签',1042,1001,0,0,1034);
    27. 

  27. 

  28. insert into  funcmenulist(funcmenuid,funcmenuname,funcmenucode,parentfuncmenucode,operatefunc,TERMINALTYPE,SEQ)values(1037,'报表查询',1037,-1,15,0,1074);
    29. 

  29. insert into  funcmenulist(funcmenuid,funcmenuname,funcmenucode,parentfuncmenucode,operatefunc,TERMINALTYPE,SEQ)values(1038,'日报表',1038,1037,15,0,1015);
    30. 

  30.  
    31. 

  31. insert into  funcmenulist(funcmenuid,funcmenuname,funcmenucode,parentfuncmenucode,operatefunc,TERMINALTYPE,SEQ)values(1018,'公告通知',1018,-1,0,0,1078);
    32. 

  32. insert into  funcmenulist(funcmenuid,funcmenuname,funcmenucode,parentfuncmenucode,operatefunc,TERMINALTYPE,SEQ)values(1019,'公告',1019,1018,0,0,1019);
    33. 

  33. insert into  funcmenulist(funcmenuid,funcmenuname,funcmenucode,parentfuncmenucode,operatefunc,TERMINALTYPE,SEQ)values(1020,'通知',1020,1018,0,0,1020);
    34. 

  34. 

  35. insert into  funcmenulist(funcmenuid,funcmenuname,funcmenucode,parentfuncmenucode,operatefunc,TERMINALTYPE,SEQ)values(1010,'银行业务',1010,-1,0,0,1081);
    36. 

  36. insert into  funcmenulist(funcmenuid,funcmenuname,funcmenucode,parentfuncmenucode,operatefunc,TERMINALTYPE,SEQ)values(1011,'出金申请',1011,1010,0,0,1022);
    37. 

  37. insert into  funcmenulist(funcmenuid,funcmenuname,funcmenucode,parentfuncmenucode,operatefunc,TERMINALTYPE,SEQ)values(1012,'入金申请',1012,1010,0,0,1023);
    38. 

  38. insert into  funcmenulist(funcmenuid,funcmenuname,funcmenucode,parentfuncmenucode,operatefunc,TERMINALTYPE,SEQ)values(1013,'出入金查询',1013,1010,0,0,1024);
    39. 

  39. insert into  funcmenulist(funcmenuid,funcmenuname,funcmenucode,parentfuncmenucode,operatefunc,TERMINALTYPE,SEQ)values(1015,'银行签约',1015,1010,0,0,1025);
    40. 

  40. insert into  funcmenulist(funcmenuid,funcmenuname,funcmenucode,parentfuncmenucode,operatefunc,TERMINALTYPE,SEQ)values(1016,'银行解约',1016,1010,0,0,1026);
    41. 

  41. insert into  funcmenulist(funcmenuid,funcmenuname,funcmenucode,parentfuncmenucode,operatefunc,TERMINALTYPE,SEQ)values(1017,'银行变更',1017,1010,0,0,1027);
    42. 

  42. 

  43. insert into  funcmenulist(funcmenuid,funcmenuname,funcmenucode,parentfuncmenucode,operatefunc,TERMINALTYPE,SEQ)values(1049,'仓单管理',1049,-1,0,0,1031);
    44. 

  44. insert into  funcmenulist(funcmenuid,funcmenuname,funcmenucode,parentfuncmenucode,operatefunc,TERMINALTYPE,SEQ)values(1050,'仓单查询',1050,1049,0,0,1032);
    45. 

  45. insert into  funcmenulist(funcmenuid,funcmenuname,funcmenucode,parentfuncmenucode,operatefunc,TERMINALTYPE,SEQ)values(1051,'提货申请',1051,1049,0,0,1033);
    46. 

  46. insert into  funcmenulist(funcmenuid,funcmenuname,funcmenucode,parentfuncmenucode,operatefunc,TERMINALTYPE,SEQ)values(1052,'提货查询',1052,1049,0,0,1034);
    47. 

  47. 

  48. 

  49. insert into  funcmenulist(funcmenuid,funcmenuname,funcmenucode,parentfuncmenucode,operatefunc,TERMINALTYPE,SEQ)values(1025,'交收管理',1025,-1,0,0,1043);
    50. 

  50. --删除insert into  funcmenulist(funcmenuid,funcmenuname,funcmenucode,parentfuncmenucode,operatefunc,TERMINALTYPE,SEQ)values(1044,'交割申报',1044,1025,0,0,1044);
    51. 

  51. insert into  funcmenulist(funcmenuid,funcmenuname,funcmenucode,parentfuncmenucode,operatefunc,TERMINALTYPE,SEQ)values(1045,'交割申报查询',1045,1025,0,0,1045);
    52. 

  52. --修改“交割单查询”-“购销合同”
    53. 

  53. insert into  funcmenulist(funcmenuid,funcmenuname,funcmenucode,parentfuncmenucode,operatefunc,TERMINALTYPE,SEQ)values(1046,'购销合同',1046,1025,0,0,1046);
    54. 

  54. 

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

  56. 

  57. insert into  funcmenulist(funcmenuid,funcmenuname,funcmenucode,parentfuncmenucode,operatefunc,TERMINALTYPE,SEQ)values(1060,'商城管理',1060,-1,0,0,1060);
    58. 

  58. insert into  funcmenulist(funcmenuid,funcmenuname,funcmenucode,parentfuncmenucode,operatefunc,TERMINALTYPE,SEQ)values(1061,'摘牌查询',1061,1060,0,0,1061);
    59. 

  59. 

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

  61. 

  62. 

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

  64. 

  65. insert into  funcmenulist(funcmenuid,funcmenuname,funcmenucode,parentfuncmenucode,operatefunc,TERMINALTYPE,SEQ)values(1065,'托管查询',1065,1001,0,0,1065);
    66. 

  66.  
    67. 

  67.  insert into  funcmenulist(funcmenuid,funcmenuname,funcmenucode,parentfuncmenucode,operatefunc,TERMINALTYPE,SEQ)values(1013,'出入金查询',1013,1010,0,0,1024);
    68. 

  68. insert into  funcmenulist(funcmenuid,funcmenuname,funcmenucode,parentfuncmenucode,operatefunc,TERMINALTYPE,SEQ)values(1015,'银行签约',1015,1010,0,0,1025);
    69. 

  69. 

  70. update funcmenulist set funcmenuname='出入金',SEQ=1025 where funcmenuid=1013;
    71. 

  71. update funcmenulist set funcmenuname='签约信息',SEQ=1024 where funcmenuid=1015;
    72. 

  72.  
    73. 

  73. insert into  funcmenulist(funcmenuid,funcmenuname,funcmenucode,parentfuncmenucode,operatefunc,TERMINALTYPE,SEQ)values(1068,'历史单据',1068,1001,0,0,1011);
    74. 

  74. 

  75. 

  76. insert into  funcmenulist(funcmenuid,funcmenuname,funcmenucode,parentfuncmenucode,operatefunc,TERMINALTYPE,SEQ)values(1069,'我的挂牌',1069,1060,0,0,1069);
    77. 

  77. insert into  funcmenulist(funcmenuid,funcmenuname,funcmenucode,parentfuncmenucode,operatefunc,TERMINALTYPE,SEQ)values(1070,'我的摘牌',1070,1060,0,0,1070);
    78. 

  78. insert into  funcmenulist(funcmenuid,funcmenuname,funcmenucode,parentfuncmenucode,operatefunc,TERMINALTYPE,SEQ)values(1071,'我的订单',1071,1060,0,0,1071);
    79.