fix : MySQL=》DMSQL

cy

2022-06-23 b83c40548208609d0d6826be13d742c28a784806

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
[#macro combobox id="" name=id hasDownArrow="true" textField="DATAVALUE" valueField="DATAKEY"  model="remote" source=""
    textValues="" idValues="" editable="true" style="width:100px;" url=""  multiple="false" 
    attr={}
]
 
 
[#if multiple=="false"]
<script type="text/javascript">
    $(document).ready(function() {
          $('#_${id}').combobox({
                textField : '${textField}',
                valueField : '${valueField}',
                multiple:false,
                [#if model == "remote"]
                    mode : 'remote',
                    url : '${url}',
                [#else]
                    data:${source},
                [/#if]
                hasDownArrow:${hasDownArrow},
                [#list attr?keys as key]
                    ${key} : ${attr[key]},
                [/#list]
                editable:${editable},
                onSelect:function(item){
                    var id = $("#_${id}").combobox("getValue");
                    var text = $("#_${id}").combobox("getText");
                    document.getElementById("${id}_TEXT").value = text; 
                    document.getElementById("${id}").value = id;
                    try{on${id}Changed(id,text);}catch(e){}
                },
                onChange:function(newValue, oldValue){
                    document.getElementById("${id}_TEXT").value = "";
                    document.getElementById("${id}").value = "";  
                    var text = $("#_${id}").combobox("getText");
                    try{on${id}Changed("",text);}catch(e){}
                }
                  
        });
        [#if idValues !="" && textValues == ""]
            $('#_${id}').combobox("select",'${idValues}');
        [/#if]
        });
    </script>
    <input type="text" style="${style}" value="${textValues}" name="_${name}" id="_${id}"/>
    <input type="hidden" value="${textValues}" name="${name}_TEXT" id="${id}_TEXT" />
    <input type="hidden" value="${idValues}" name="${name}" id="${id}" />  
[/#if]
[#if multiple=="true"]
 
<script type="text/javascript">
    $(document).ready(function() {
          $('#_${id}').combobox({
                textField : '${textField}',
                valueField : '${valueField}',
                multiple:true,
                [#if model == "remote"]
                    mode : 'remote',
                    url : '${url}',
                [#else]
                    data:${source},
                [/#if]
                editable:false,
                onUnselect:function(item){
                    var ids = $("#_${id}").combobox("getValues");
                    var text = $("#_${id}").combobox("getText");
                    document.getElementById("${id}_TEXT").value = text;
                    $("#${id}").val(ids);
                    try{on${id}Changed(ids,text);}catch(e){}
                },
                onSelect:function(item){
                    var ids = $("#_${id}").combobox("getValues");
                    var text = $("#_${id}").combobox("getText");
                    $("#${id}").val(ids);
                    document.getElementById("${id}_TEXT").value = text;
                    try{on${id}Changed(ids,text);}catch(e){}
                }
        });
        
        [#if idValues!=""]
            var ids = '${idValues}';
            var arrIDS = ids.split(",");
            $('#_${id}').combobox("setValues",arrIDS);
        [/#if]
        [#if textValues !="" ]
            $('#_${id}').combobox("setText",'${textValues}');
        [/#if]
        });
    </script>
    <input type="text" style="${style}" value="" name="_${name}" id="_${id}"/>
    <input type="hidden" value="${textValues}" name="${name}_TEXT" id="${id}_TEXT" />
    <input type="hidden" value="${idValues}" name="${name}" id="${id}"/>
[/#if]
[/#macro]