| | |
| | | case 'DateTime': |
| | | col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, templet: "<div>{{d." + data[i].name + " ==null ?'':layui.util.toDateString(d." + data[i].name + ", 'yyyy-MM-dd')}}</div>", width: 200 }); |
| | | break; |
| | | case 'long': |
| | | case 'Int32': |
| | | case 'Int64': |
| | | case 'double': |
| | | case 'Decimal': |
| | | col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, width: 120, totalRow: true }); |
| | | break; |
| | | default: |
| | | col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, width: 200 }); |
| | | } |
| | |
| | | , toolbar: '#toolbarDemo' |
| | | , height: 'full-50' |
| | | , page: true //å¼å¯å页 |
| | | , totalRow: true |
| | | , limit: 50 |
| | | , limits: [50, 500, 5000, 20000] |
| | | , cols: [col] |
| | |
| | | } |
| | | |
| | | if (HDate) { |
| | | sWhere += " and å¶åæ¥æ >= '" + HDate + "'"; |
| | | sWhere += " and CONVERT(varchar(100), å¶åæ¥æ, 23) >= '" + HDate + "'"; |
| | | } |
| | | if (HDate1) { |
| | | sWhere += " and å¶åæ¥æ <= '" + HDate1 + "'"; |
| | | sWhere += " and CONVERT(varchar(100), å¶åæ¥æ, 23) <= '" + HDate1 + "'"; |
| | | } |
| | | |
| | | if (HICMOBillNo) { |