| | |
| | | }); |
| | | //éç½®æé® |
| | | form.on('submit(btnReSearch)', function (data) { |
| | | cols_arr = []; |
| | | set_ClearQuery(); |
| | | }); |
| | | //æ¥è¯¢æé® |
| | | form.on('submit(btnSearch)', function (data) { |
| | | cols_arr = []; |
| | | get_FastQuery(); |
| | | }); |
| | | |
| | |
| | | } |
| | | //åå§åè¡¨æ ¼ |
| | | function set_InitGrid(sWhere) { |
| | | |
| | | //å¡«å
è¡¨æ ¼å¤´æ°ç» |
| | | var data = resultTableHead; |
| | | cols_arr[0] = []; |
| | |
| | | switch (data[i].Type) { |
| | | //int |
| | | case 'Int32': |
| | | cols_arr[0][i + 1] = { field: data[i].id, title: data[i].name, align: 'center', totalRow: true, sort: true, width: 100 }; |
| | | cols_arr[0][i + 1] = { field: data[i].id, title: data[i].name, align: 'center', width: 100 }; |
| | | break; |
| | | //Decimal |
| | | case 'Decimal': |
| | | cols_arr[0][i + 1] = { field: data[i].id, title: data[i].name, align: 'center', totalRow: true, sort: true, width: 200 }; |
| | | cols_arr[0][i + 1] = { field: data[i].id, title: data[i].name, align: 'center', width: 200 }; |
| | | break; |
| | | default: |
| | | cols_arr[0][i + 1] = { field: data[i].id, title: data[i].name, align: 'center', sort: true, width: 200 }; |
| | | cols_arr[0][i + 1] = { field: data[i].id, title: data[i].name, align: 'center', width: 200 }; |
| | | } |
| | | } |
| | | } |
| | |
| | | var HMaterNumber = $("#HMaterNumber").val(); |
| | | var HMaterName = $("#HMaterName").val(); |
| | | var HMakerMan = $("#HMakerMan").val(); |
| | | |
| | | if (HDate) { |
| | | sWhere += " and CONVERT(varchar(100),æ¥æ, 23) >= '" + HDate + "'"; |
| | | } |