Home Explore Help
Sign In
wudonglin
/
XinYu_LZMES
1
0
Fork 0
Files Issues 0 Pull Requests 0 Wiki
Tree: a540bd687a
Branches Tags
XinYu_LZMES
/
.svn
/
pristine
/
15
/
151217c7372f19c1da9c58dadb961171a9f952a7.svn-base

151217c7372f19c1da9c58dadb961171a9f952a7.svn-base 1.7 KB
History Raw

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859 
  1. <?xml version="1.0" encoding='UTF-8'?>
    2. 

  2. 

  3. <queryMap desc="编码对照表">
    4. 

  4. 

  5. 

  6. <query id="UIB100102_01.SELECT"   desc="查询编码">
    7. 

  7.     SELECT      T.*   ,T.QLTY_CD QLTY_CD_XP FROM        TBB10_QLTY_CD  T WHERE T.QLTY_CD LIKE ?||'%'
    8. 

  8. </query>
    9. 

  9. 

  10. 

  11. <query id="UIB100102_01.UPDATE" desc="更新">
    12. 

  12. 	UPDATE       TBB10_QLTY_CD   T
    13. 

  13. 	SET          QLTY_CD_1       =              ?
    14. 

  14. 	            ,QLTY_CD_2       =              ?
    15. 

  15. 	            ,QLTY_CD_2_NM    =              ?
    16. 

  16. 	            ,QLTY_CD_3       =              ?
    17. 

  17. 	            ,QLTY_CD_3_NM    =              ?
    18. 

  18. 	            ,QLTY_CD         =              ?
    19. 

  19. 	            ,QLTY_CD_CFNM    =              ?
    20. 

  20. 	            ,QLTY_UNIT       =              ?
    21. 

  21. 	            ,QLTY_TYPE       =              ?
    22. 

  22. 	            ,DISPLAY_SEQ     =              ?
    23. 

  23. 	            ,QLTY_OPE_CD     =              ?
    24. 

  24. 	            ,QLTY_DIR        =              ?
    25. 

  25. 	            ,QLTY_SIZ        =              ?
    26. 

  26. 	            ,QLTY_TEM        =              ? 
    27. 

  27. 	            ,QLTY_RP         =              ?
    28. 

  28. 	WHERE        QLTY_CD         =              ?       
    29. 

  29. </query>
    30. 

  30. 

  31. <query id="UIB100102_01.INSERT" desc="插入">
    32. 

  32. 	INSERT       
    33. 

  33. 	INTO         TBB10_QLTY_CD
    34. 

  34. 	            (
    35. 

  35. 	             QLTY_CD_1
    36. 

  36. 	            ,QLTY_CD_2
    37. 

  37. 	            ,QLTY_CD_2_NM
    38. 

  38. 	            ,QLTY_CD_3
    39. 

  39. 	            ,QLTY_CD_3_NM
    40. 

  40. 	            ,QLTY_CD
    41. 

  41. 	            ,QLTY_CD_CFNM
    42. 

  42. 	            ,QLTY_UNIT
    43. 

  43. 	            ,QLTY_TYPE
    44. 

  44. 	            ,DISPLAY_SEQ
    45. 

  45. 	            ,QLTY_OPE_CD
    46. 

  46. 	            ,QLTY_DIR
    47. 

  47. 	            ,QLTY_SIZ
    48. 

  48. 	            ,QLTY_TEM
    49. 

  49. 	            ,QLTY_RP
    50. 

  50. 	            )             
    51. 

  51. 	VALUES      (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) 
    52. 

  52. </query>
    53. 

  53. 

  54. 

  55. <query id="UIB100102_01.DELETE" desc="删除">
    56. 

  56. 	DELETE FROM TBB10_QLTY_CD WHERE QLTY_CD = ?
    57. 

  57. </query>
    58. 

  58. 

  59. </queryMap>
    60.