| | |
| | | <script src="../../../layuiadmin/Scripts/jquery-1.4.1.js"></script> |
| | | <script src="../../../layuiadmin/Scripts/webConfig.js"></script> |
| | | <script src="../../../layuiadmin/PubCustom.js"></script> |
| | | <script src="../../../layuiadmin/xm-select.js"></script> |
| | | <!--<script src="../../../layuiadmin/soulTable.slim.js"></script>--> <!--æ é¢çéä¸è½å¼ç¨æ¤jsæä»¶--> |
| | | </head> |
| | | <body> |
| | |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label" style="width: 85px;">ç»ç»</label> |
| | | <div class="layui-input-block" style="margin-left: 120px; width: 185px;"> |
| | | <select name="HORGID" id="HORGID" lay-verify="HORGID"> |
| | | <!--<select name="HORGID" id="HORGID" lay-verify="HORGID">--> |
| | | <!--å¨ææ¸²æç»ç»--> |
| | | </select> |
| | | <!--</select>--> |
| | | <div id="demo1"> |
| | | |
| | | </div> |
| | | </div> |
| | | </div> |
| | | <div class="layui-inline"> |
| | |
| | | , cellMinWidth: 90 |
| | | , totalRow: true |
| | | , limit: 50 |
| | | , limits: [50, 500,1000, 5000] |
| | | , limits: [50, 500, 1000, 5000] |
| | | , title:"é½å¥æ¥è¡¨" |
| | | //, loading: false |
| | | , cols: [[ |
| | | { type: 'checkbox', fixed: 'left' } |
| | |
| | | , { field: 'åä½ç¨é', title: 'åä½ç¨é', sort: true, filter: true } |
| | | , { field: 'ä¾è´§è½¦é´ä»£ç ', title: 'ä¾è´§è½¦é´ä»£ç ', sort: true, filter: true } |
| | | , { field: 'ä¾è´§è½¦é´', title: 'ä¾è´§è½¦é´', sort: true, filter: true } |
| | | , { field: 'ç©æå±æ§', title: 'ç©æå±æ§', sort: true, filter: true } |
| | | , { field: 'ç©æå±æ§', title: 'ç©æå±æ§', sort: true, filter: true } |
| | | , { field: 'ä»åºåç§°', title: 'ä»åºåç§°', sort: true, filter: true } |
| | | , { field: '计ååææ°é', title: '计ååææ°é', sort: true, totalRow: true, filter: true } |
| | | , { field: 'é½å¥æ°é', title: 'é½å¥æ°é', sort: true, totalRow: true, filter: true } |
| | | , { field: 'ç¼ºææ°é', title: 'ç¼ºææ°é', sort: true, totalRow: true, filter: true } |
| | |
| | | function Organ() { |
| | | //è·åç»å½é¡µç»ç»å |
| | | var Organization = ''; |
| | | var selectDataList = []; |
| | | $.ajax({ |
| | | type: "get", |
| | | url: GetWEBURL() + "/Web/GetOrganizations", |
| | | async: false, |
| | | success: function (result) { |
| | | if (result.count == 1) { // 说æéªè¯æåäºï¼ |
| | | var data = result.data; |
| | | for (var i = 0; i < data.length; i++) { |
| | | Organization += '<option style="color:blue;" value="' + data[i].ID + '">' + data[i].Name + '</option>'; |
| | | /*Organization += '<option style="color:blue;" value="' + data[i].ID + '">' + data[i].Name + '</option>';*/ |
| | | //䏿å¤éæ¡æ°æ®åå§å |
| | | var selectData = { name: data[i].Name, value: data[i].ID }; |
| | | selectDataList.push(selectData); |
| | | } |
| | | $("#HORGID").append(Organization); |
| | | $("#HORGID").val(sessionStorage["OrganizationID"]) |
| | | //$("#HORGID").append(Organization); |
| | | //$("#HORGID").val(sessionStorage["OrganizationID"]); |
| | | var demo1 = xmSelect.render({ |
| | | el: '#demo1', |
| | | language: 'zn', |
| | | /*initValue: [sessionStorage["OrganizationID"]],*///é»è®¤é项 |
| | | data: selectDataList |
| | | }) |
| | | form.render('select'); |
| | | } |
| | | layer.closeAll("loading"); |
| | | } |
| | | }) |
| | | |
| | | } |
| | | |
| | | //#region æ¥è¯¢ |
| | |
| | | function getExportData() { |
| | | var data;//导åºçæ°æ® |
| | | var ajaxLoad = layer.load(); |
| | | var HORGID = $("#HORGID").val();//ç»ç» |
| | | var HORGID = "";//ç»ç» |
| | | var xmList = xmSelect.get('#demo1', true);//è·åéæ©æ¡å®ä¾ |
| | | var xmValueStr = xmList.getValue("valueStr")//è·åå¼å符串 |
| | | if (xmValueStr == "") { |
| | | HORGID = "'0'"//æ²¡éæ©ç»ç»åå
¨é¨ç»ç» |
| | | } else { |
| | | HORGID = "'" + xmValueStr + "'" |
| | | } |
| | | var HMATERIALID = $("#HMATERIALID").val();//ç©æ/产å |
| | | var HDeptID = $("#HDeptID").val();//çäº§è½¦é´ |
| | | var HSCZYID = $("#HSCZYID").val();//çäº§èµæº |
| | |
| | | var HEndDate = $("#HEndDate").val();//è³ |
| | | var HMaterAtt = $("#HMaterAtt").val();//ç©æå±æ§ |
| | | |
| | | var ColName = $("#ColName").val();//å¤éæ¡ |
| | | var Comparator = $("#Comparator").val() |
| | | var ColContent = $("#ColContent").val(); |
| | | var ColName1 = $("#ColName1").val();//å¤éæ¡ |
| | | var Comparator1 = $("#Comparator1").val() |
| | | var ColContent1 = $("#ColContent1").val(); |
| | | var ColName2 = $("#ColName2").val();//å¤éæ¡ |
| | | var Comparator2 = $("#Comparator2").val() |
| | | var ColContent2 = $("#ColContent2").val(); |
| | | |
| | | if (ColName != 0 && Comparator != 0) { |
| | | var com = ""; |
| | | switch (Comparator) { |
| | | case "7": |
| | | com = "like'%" + ColContent + "%'"; |
| | | break; |
| | | case "8": |
| | | com = "like'%" + ColContent + "'"; |
| | | break; |
| | | case "9": |
| | | com = "like'" + ColContent + "%'"; |
| | | break; |
| | | case "10": |
| | | com = "not like'%" + ColContent + "%'"; |
| | | break; |
| | | default: |
| | | com = "" + Comparator + "'" + ColContent + "'"; |
| | | break; |
| | | } |
| | | sWhere += " and " + ColName + " " + com; |
| | | } |
| | | |
| | | if (ColName1 != 0 && Comparator1 != 0) { |
| | | var com1 = ""; |
| | | switch (Comparator1) { |
| | | case "7": |
| | | com1 = "like'%" + ColContent1 + "%'"; |
| | | break; |
| | | case "8": |
| | | com1 = "like'%" + ColContent1 + "'"; |
| | | break; |
| | | case "9": |
| | | com1 = "like'" + ColContent1 + "%'"; |
| | | break; |
| | | case "10": |
| | | com1 = "not like'%" + ColContent1 + "%'"; |
| | | break; |
| | | default: |
| | | com1 = "" + Comparator1 + "'" + ColContent1 + "'"; |
| | | break; |
| | | } |
| | | sWhere += " and " + ColName1 + " " + com1; |
| | | } |
| | | if (ColName2 != 0 && Comparator2 != 0) { |
| | | var com2 = ""; |
| | | switch (Comparator2) { |
| | | case "7": |
| | | com2 = "like'%" + ColContent2 + "%'"; |
| | | break; |
| | | case "8": |
| | | com2 = "like'%" + ColContent2 + "'"; |
| | | break; |
| | | case "9": |
| | | com2 = "like'" + ColContent2 + "%'"; |
| | | break; |
| | | case "10": |
| | | com2 = "not like'%" + ColContent2 + "%'"; |
| | | break; |
| | | default: |
| | | com2 = "" + Comparator + "'" + ColContent + "'"; |
| | | break; |
| | | } |
| | | sWhere += " and " + ColName2 + " " + com2; |
| | | } |
| | | |
| | | if (HBeginDate > HEndDate) { |
| | | layer.close(ajaxLoad); |
| | |
| | | item[itemobj] = item[itemobj].toString().replace(/[\r\n]+/g, ''); // å°æ¢è¡ç¬¦æ¿æ¢ä¸ºç©ºå符串 |
| | | item[itemobj] = item[itemobj].toString().replace(/,/g, ''); // å°æ¢è¡ç¬¦æ¿æ¢ä¸ºç©ºå符串 |
| | | } |
| | | if (itemobj == "订å交æ") { |
| | | item[itemobj] = item[itemobj].toString().split('T')[0]; |
| | | } |
| | | if (itemobj == "æ¥è®¡åæ¥æ") { |
| | | item[itemobj] = item[itemobj].toString().split('T')[0]; |
| | | } |
| | | } |
| | | }); |
| | | |
| | |
| | | //#region å¿«éè¿æ»¤ |
| | | function get_FastQuery(number) { |
| | | var HORGID = ""; |
| | | if (number == 1) { |
| | | HORGID = sessionStorage["OrganizationID"]; |
| | | } |
| | | else { |
| | | HORGID = $("#HORGID").val();//ç»ç» |
| | | //if (number == 1) { |
| | | // HORGID = sessionStorage["OrganizationID"]; |
| | | //} |
| | | //else { |
| | | // HORGID = $("#HORGID").val();//ç»ç» |
| | | //} |
| | | var xmList = xmSelect.get('#demo1', true);//è·åéæ©æ¡å®ä¾ |
| | | var xmValueStr = xmList.getValue("valueStr")//è·åå¼å符串 |
| | | if (xmValueStr == "") { |
| | | HORGID = "'0'" |
| | | } else { |
| | | HORGID = "'" + xmValueStr + "'" |
| | | } |
| | | var HMATERIALID = $("#HMATERIALID").val();//ç©æ/产å |
| | | var HDeptID = $("#HDeptID").val();//çäº§è½¦é´ |
| | |
| | | var HBeginDate = $("#HBeginDate").val();//æææ¥æ |
| | | var HEndDate = $("#HEndDate").val();//è³ |
| | | var HMaterAtt = $("#HMaterAtt").val();//ç©æå±æ§ |
| | | |
| | | var ColName = $("#ColName").val();//å¤éæ¡ |
| | | var Comparator = $("#Comparator").val() |
| | | var ColContent = $("#ColContent").val(); |
| | | var ColName1 = $("#ColName1").val();//å¤éæ¡ |
| | | var Comparator1 = $("#Comparator1").val() |
| | | var ColContent1 = $("#ColContent1").val(); |
| | | var ColName2 = $("#ColName2").val();//å¤éæ¡ |
| | | var Comparator2 = $("#Comparator2").val() |
| | | var ColContent2 = $("#ColContent2").val(); |
| | | |
| | | if (ColName != 0 && Comparator != 0) { |
| | | var com = ""; |
| | | switch (Comparator) { |
| | | case "7": |
| | | com = "like'%" + ColContent + "%'"; |
| | | break; |
| | | case "8": |
| | | com = "like'%" + ColContent + "'"; |
| | | break; |
| | | case "9": |
| | | com = "like'" + ColContent + "%'"; |
| | | break; |
| | | case "10": |
| | | com = "not like'%" + ColContent + "%'"; |
| | | break; |
| | | default: |
| | | com = "" + Comparator + "'" + ColContent + "'"; |
| | | break; |
| | | } |
| | | sWhere += " and " + ColName + " " + com; |
| | | } |
| | | |
| | | if (ColName1 != 0 && Comparator1 != 0) { |
| | | var com1 = ""; |
| | | switch (Comparator1) { |
| | | case "7": |
| | | com1 = "like'%" + ColContent1 + "%'"; |
| | | break; |
| | | case "8": |
| | | com1 = "like'%" + ColContent1 + "'"; |
| | | break; |
| | | case "9": |
| | | com1 = "like'" + ColContent1 + "%'"; |
| | | break; |
| | | case "10": |
| | | com1 = "not like'%" + ColContent1 + "%'"; |
| | | break; |
| | | default: |
| | | com1 = "" + Comparator1 + "'" + ColContent1 + "'"; |
| | | break; |
| | | } |
| | | sWhere += " and " + ColName1 + " " + com1; |
| | | } |
| | | if (ColName2 != 0 && Comparator2 != 0) { |
| | | var com2 = ""; |
| | | switch (Comparator2) { |
| | | case "7": |
| | | com2 = "like'%" + ColContent2 + "%'"; |
| | | break; |
| | | case "8": |
| | | com2 = "like'%" + ColContent2 + "'"; |
| | | break; |
| | | case "9": |
| | | com2 = "like'" + ColContent2 + "%'"; |
| | | break; |
| | | case "10": |
| | | com2 = "not like'%" + ColContent2 + "%'"; |
| | | break; |
| | | default: |
| | | com2 = "" + Comparator + "'" + ColContent + "'"; |
| | | break; |
| | | } |
| | | sWhere += " and " + ColName2 + " " + com2; |
| | | } |
| | | |
| | | if (HBeginDate > HEndDate) { |
| | | return layer.msg("å¼å§æ¥æä¸è½å°äºç»ææ¥æ!"); |
| | |
| | | |
| | | //#region éç½®è¿æ»¤æ¡ä»¶æ¹æ³ |
| | | function set_ClearQuery() { |
| | | $("#HORGID").val(sessionStorage["OrganizationID"]);//ç»ç» |
| | | |
| | | $("#HMATERIALID").val(0);//ç©æ/产å |
| | | $("#HMATERIALNAME").val(""); |
| | | $("#HDeptID").val(0);//çäº§è½¦é´ |
| | |
| | | $("#HSCZYName").val(""); |
| | | $("#HXQD").val("");//éæ±åå· |
| | | $("#HMOBILLNO").val("");//ç产订åå· |
| | | $("#ColContent").val(""); |
| | | $("#ColName").val("0"); |
| | | $("#Comparator").val("0"); |
| | | $("#ColContent1").val(""); |
| | | $("#ColName1").val("0"); |
| | | $("#Comparator1").val("0"); |
| | | $("#ColContent2").val(""); |
| | | $("#ColName2").val("0"); |
| | | $("#Comparator2").val("0"); |
| | | $("#HBeginDate").val(Format(new Date(new Date()), "yyyy-MM-dd"));//æææ¥æ |
| | | $("#HEndDate").val(Format(new Date($("#HBeginDate").val()).setDate(new Date($("#HBeginDate").val()).getDate() + 30), "yyyy-MM-dd"));//è³ |
| | | $("#HMaterAtt").val(""); |