| | |
| | | </div> |
| | | </div> |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label">æ¥æ</label> |
| | | <label class="layui-form-label">å¼å§æ¥æ</label> |
| | | <div class="layui-input-block"> |
| | | <input type="date" class="layui-input" id="HDate" style="width:190px;"> |
| | | </div> |
| | | </div> |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label">ç»ææ¥æ</label> |
| | | <div class="layui-input-block"> |
| | | <input type="date" class="layui-input" id="HDate1" style="width:190px;"> |
| | | </div> |
| | | </div> |
| | | <div class="layui-inline"> |
| | |
| | | <script src="../../../layuiadmin/Scripts/json2.js"></script> |
| | | <script src="../../../layuiadmin/Scripts/jquery-1.4.1.js"></script> |
| | | <script src="../../../layuiadmin/Scripts/webConfig.js"></script> |
| | | <script src="../../../layuiadmin/zgqCustom/zgqCustom.js"></script> |
| | | <script> |
| | | var cols_arr = []; //åå¨è¡¨æ ¼å¤´çæ°ç» |
| | | var table = null; |
| | |
| | | |
| | | //#region è¿å
¥é¡µé¢æ¢å è½½ |
| | | //åå§åçé¢ |
| | | set_ClearBill(); |
| | | set_ClearBill(sWhere); |
| | | //#endregion |
| | | |
| | | //#region åå§å表å |
| | | function set_InitFrom() { |
| | | laydate.render({ |
| | | elem: '#HDate' |
| | | }); |
| | | laydate.render({ |
| | | elem: '#HDate1' |
| | | }); |
| | | } |
| | | //#endregion |
| | | |
| | | //头工å
·æ äºä»¶ |
| | | table.on('toolbar(mainTable)', function (obj) { |
| | |
| | | }); |
| | | |
| | | //åå§åçé¢ |
| | | function set_ClearBill() { |
| | | function set_ClearBill(sWhere) { |
| | | resultTableHead = []; //æ¸
空表头åï¼é²æ¢é夿¸²æ |
| | | //åå§æ¥è¯¢ |
| | | get_Display(sWhere); |
| | | //get_Display(sWhere); |
| | | $("#HDate").val(Format(new Date(new Date() - 1000 * 60 * 60 * 24 * 30), "yyyy-MM-dd")); |
| | | $("#HDate1").val(Format(new Date(), "yyyy-MM-dd")); |
| | | get_FastQuery(); |
| | | |
| | | } |
| | | //å è½½ç½æ ¼ |
| | |
| | | $.ajax({ |
| | | url: GetWEBURL() + '/Sc_PackUnionBill/Get_PackUnionBillList', |
| | | type: "GET", |
| | | data: { "sWhere": sWhere, "page": 1, "limit": 10 }, |
| | | data: { "page": 1, "limit": 10 ,"sWhere": sWhere}, |
| | | datatype: "json", |
| | | success: function (data1) { |
| | | console.log(data1); |
| | |
| | | }); |
| | | } |
| | | //åå§åè¡¨æ ¼ |
| | | function set_InitGrid() { |
| | | 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 }; |
| | | cols_arr[0][i + 1] = { field: data[i].id, title: data[i].name, align: 'center', totalRow: true, sort: true,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 }; |
| | | cols_arr[0][i + 1] = { field: data[i].id, title: data[i].name, align: 'center', totalRow: true, sort: true, width: 200 }; |
| | | break; |
| | | default: |
| | | cols_arr[0][i + 1] = { field: data[i].id, title: data[i].name, align: 'center', sort: true }; |
| | | cols_arr[0][i + 1] = { field: data[i].id, title: data[i].name, align: 'center', sort: true, width: 200}; |
| | | } |
| | | } |
| | | } |
| | | //å¡«å
è¡¨æ ¼æ°æ® |
| | | table.render({ |
| | | elem: '#mainTable', |
| | | toolbar: '#toolbarDemo', |
| | | url: GetWEBURL() + '/Sc_PackUnionBill/Get_PackUnionBillList', |
| | | title: 'ç»æåå表', |
| | | cols: cols_arr, //å¡«å
è¡¨æ ¼å¤´æ°æ®, |
| | |
| | | //å¿«éè¿æ»¤ |
| | | function get_FastQuery() { |
| | | var HDate = $("#HDate").val();//å¼å§æ¥æ |
| | | var HDate1 = $("#HDate1").val();//ç»ææ¥æ |
| | | var HBillNo = $("#HBillNo").val(); //åæ®å· |
| | | var HDepartName = $("#HDepartName").val(); |
| | | var HMaterNumber = $("#HMaterNumber").val(); |
| | |
| | | var HMakerMan = $("#HMakerMan").val(); |
| | | if (HDate) { |
| | | sWhere += " and CONVERT(varchar(100),æ¥æ, 23) >= '" + HDate + "'"; |
| | | } |
| | | if (HDate1) { |
| | | sWhere += " and CONVERT(varchar(100),æ¥æ, 23) <= '" + HDate1 + "'"; |
| | | } |
| | | if (HBillNo) { |
| | | sWhere += " and åæ®å· like '%" + HBillNo + "%'"; |
| | |
| | | if (HMakerMan) { |
| | | sWhere += " and å¶å人 like '%" + HMakerMan + "%'"; |
| | | } |
| | | set_ClearBill(sWhere); |
| | | get_Display(sWhere); |
| | | sWhere = ""; |
| | | } |
| | | //éç½®è¿æ»¤æ¡ä»¶ |
| | | function set_ClearQuery() { |
| | | $("#HDate").val(Format(new Date(new Date() - 1000 * 60 * 60 * 24 * 30), "yyyy-MM-dd")); |
| | | $("#HDate1").val(Format(new Date(), "yyyy-MM-dd")); |
| | | $("#HBillNo").val(""); |
| | | $("#HDepartName").val(""); |
| | | $("#HMaterNumber").val(""); |