| | |
| | | </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; |
| | |
| | | var pageIndex = 1;//å½å页ç å¼ |
| | | |
| | | //#region è¿å
¥é¡µé¢æ¢å è½½ |
| | | //åå§å表åæä»¶ |
| | | set_InitFrom(); |
| | | //åå§åçé¢ |
| | | set_ClearBill(sWhere); |
| | | //#endregion |
| | | |
| | | //#region åå§å表å |
| | | function set_InitFrom() { |
| | | laydate.render({ |
| | | elem: '#HDate' |
| | | }); |
| | | laydate.render({ |
| | | elem: '#HDate1' |
| | | }); |
| | | } |
| | | //#endregion |
| | | |
| | | //头工å
·æ äºä»¶ |
| | | table.on('toolbar(mainTable)', function (obj) { |
| | |
| | | get_FastQuery(); |
| | | }); |
| | | |
| | | //åå§å表å |
| | | function set_InitFrom() { |
| | | laydate.render({ |
| | | elem: '#HDate' |
| | | }); |
| | | } |
| | | //åå§åçé¢ |
| | | function set_ClearBill(sWhere) { |
| | | resultTableHead = []; //æ¸
空表头åï¼é²æ¢é夿¸²æ |
| | | //åå§æ¥è¯¢ |
| | | //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(); |
| | | |
| | | get_Display(sWhere); |
| | | } |
| | | //å è½½ç½æ ¼ |
| | | function get_Display(sWhere) { |
| | |
| | | $.ajax({ |
| | | url: GetWEBURL() + '/Sc_PackUnionBill/Get_PackUnionBillList', |
| | | type: "GET", |
| | | data: { "page": 1, "limit": 10 ,"sWhere": sWhere}, |
| | | data: { "sWhere": sWhere, "page": 1, "limit": 10 }, |
| | | datatype: "json", |
| | | success: function (data1) { |
| | | console.log(data1); |
| | |
| | | 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', totalRow: true, sort: true }; |
| | | 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', totalRow: true, sort: true }; |
| | | 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', sort: true }; |
| | | } |
| | | } |
| | | } |
| | | //å¡«å
è¡¨æ ¼æ°æ® |
| | | table.render({ |
| | | elem: '#mainTable', |
| | | toolbar: '#toolbarDemo', |
| | | url: GetWEBURL() + '/Sc_PackUnionBill/Get_PackUnionBillList', |
| | | toolbar: '#toolbarDemo', |
| | | title: 'ç»æåå表', |
| | | cols: cols_arr, //å¡«å
è¡¨æ ¼å¤´æ°æ®, |
| | | id: 'mainTable', //è¡¨æ ¼id |
| | |
| | | } |
| | | }); |
| | | } |
| | | //å é¤ |
| | | function set_DeleteBill() { |
| | | var checkStatus = table.checkStatus('mainTable') |
| | | , data = checkStatus.data; |
| | | if (checkStatus.data.length === 1) { |
| | | var InterID = data[0].hmainid.toString(); |
| | | //é»è¾å 餿¹æ³ |
| | | layer.confirm("确认è¦å é¤åï¼å é¤åä¸è½æ¢å¤", { title: "å é¤ç¡®è®¤" }, function (index) { |
| | | var wait = layer.load(); |
| | | $.ajax({ |
| | | type: "GET", |
| | | url: GetWEBURL() + "/Sc_PackUnionBill/set_DeleteBill", //æ¹æ³æå¨é¡µé¢åæ¹æ³å |
| | | data: { "HInterID": InterID, "user": sessionStorage["HUserName"] }, |
| | | success: function (result) { |
| | | if (result.count == 1) { |
| | | layer.msg(result.Message, { time: 1 * 1000, icon: 1 }, function () { |
| | | // å¾å°frameç´¢å¼ |
| | | var index = layer.getFrameIndex(window.name); |
| | | //å
³éå½åframe |
| | | layer.close(index); |
| | | //ä¿®æ¹ä¸ºååå·æ°çé¢ |
| | | window.location.reload(); |
| | | }); |
| | | |
| | | } else { |
| | | layer.alert(result.code + result.Message, { icon: 5 }); |
| | | } |
| | | layer.close(wait); |
| | | }, error: function () { |
| | | layer.close(wait); |
| | | layer.alert("æ¥å£è¯·æ±å¤±è´¥!", { icon: 5 }); |
| | | } |
| | | }); |
| | | }) |
| | | } |
| | | else { |
| | | layer.msg('è¯·éæ©ä¸è¡æ°æ®å é¤ï¼'); |
| | | } |
| | | } |
| | | //å¿«éè¿æ»¤ |
| | | 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 + "%'"; |
| | | } |
| | | get_Display(sWhere); |
| | | set_ClearBill(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(""); |
| | | $("#HMaterName").val(""); |
| | | $("#HMakerMan").val(""); |
| | | sWhere = " "; |
| | | get_FastQuery(); |
| | | sWhere = ""; |
| | | get_Display(sWhere); |
| | | } |
| | | //å·æ° |
| | | function set_Refresh() { |