| | |
| | | </div> |
| | | </div> |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label">ç¶æ</label> |
| | | <label class="layui-form-label ">ç¶æ</label> |
| | | <div class="layui-input-block" style="width:150px"> |
| | | <select name="city" lay-verify="required" id="HStatus"> |
| | | <option value="è¿ç«æªæ«">è¿ç«æªæ«</option> |
| | |
| | | <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnSearch" id="btnSearch" style="margin-left:40px;width:60px;padding:0 10px">æ¥è¯¢</button> |
| | | <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnReSearch" id="btnReSearch" style="width: 60px; padding: 0 10px">éç½®</button> |
| | | <div class="layui-colla-content" style="padding: 0px; margin-left: 6%;"> |
| | | <!--æ¾ç¤ºå½åè¿æ»¤æ¹æ¡--> |
| | | <div class="layui-inline" style="margin-left:5px;"> |
| | | <div style="text-align:center;font-size:15px;font-weight:bold;color:#fc9393" id="HFilterScheme_Now"></div> |
| | | </div> |
| | | <div class="layui-row" style="margin-top: 10px; margin-bottom: 10px; margin-left: -105px;"> |
| | | <!--å
¶ä»æ¡ä»¶--> |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label" style="width: 85px;">订åå·</label> |
| | | <div class="layui-input-block" style="margin-left: 120px;"> |
| | | <input type="text" class="layui-input" name="HICMOBillNo" id="HICMOBillNo" onfocus="this.select();"> |
| | | <input type="text" class="layui-input " name="HICMOBillNo" id="HICMOBillNo" onfocus="this.select();"> |
| | | </div> |
| | | </div> |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label" style="width:50px;">客æ·</label> |
| | | <div class="layui-input-inline"> |
| | | <input type="text" class="layui-input" lay-verify="HCusName" name="HCusName" id="HCusName" value="" style="float: left; width: 190px; background-color: #efefef4d; display: inline-block;" readonly> |
| | | <input type="text" class="layui-input ForFilteringSchemes" lay-verify="HCusName" name="HCusName" id="HCusName" value="" style="float: left; width: 190px; background-color: #efefef4d; display: inline-block;" readonly> |
| | | <input type="hidden" name="HCusID" id="HCusID" value="0"> |
| | | <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnHCusID" id="btnHCusID" style="width: 40px;"> |
| | | <i class="layui-icon layui-icon-search layuiadmin-button-btn" style="margin-left:-9px;"></i> |
| | |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label" style="width:50px;">ä¸å¡å</label> |
| | | <div class="layui-input-inline"> |
| | | <input type="text" class="layui-input" lay-verify="HEmpName" name="HEmpName" id="HEmpName" value="" style="float: left; width: 190px; background-color: #efefef4d; display: inline-block;" readonly> |
| | | <input type="text" class="layui-input ForFilteringSchemes" lay-verify="HEmpName" name="HEmpName" id="HEmpName" value="" style="float: left; width: 190px; background-color: #efefef4d; display: inline-block;" readonly> |
| | | <input type="hidden" name="HEmpID" id="HEmpID" value="0"> |
| | | <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnHEmpID" id="btnHEmpID" style="width: 40px;"> |
| | | <i class="layui-icon layui-icon-search layuiadmin-button-btn" style="margin-left:-9px;"></i> |
| | |
| | | <input type="text" name="HQty" id="HQty" lay-verify="HQty" onkeyup="if(!this.value.match(/^[\+\-]?\d*?\.?\d*?$/)){if(!this.t_value>0){this.value=''}else{this.value=this.t_value;}}else this.t_value=this.value;if(this.value.match(/^(?:[\+\-]?\d+(?:\.\d+)?)?$/))this.o_value=this.value" autocomplete="off" class="layui-input" onfocus="this.select();"> |
| | | </div> |
| | | </div> |
| | | |
| | | <div class="layui-row" style="margin:10px 0px"> |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label">è¿æ»¤</label> |
| | | <div class="layui-input-block"> |
| | | <select name="ColName" id="ColName" class="ForFilteringSchemes" lay-filter="ColName" style="width:190px;"> |
| | | </select> |
| | | </div> |
| | | </div> |
| | | <div class="layui-inline"> |
| | | <select name="Comparator" id="Comparator" class="ForFilteringSchemes" lay-filter="Comparator" style="width:190px;"> |
| | | <option value="0" selected="selected"></option> |
| | | <option value="=">=</option> |
| | | <option value=">=">>=</option> |
| | | <option value=">">></option> |
| | | <option value="<="><=</option> |
| | | <option value="<"><</option> |
| | | <option value="<>"><></option> |
| | | <option value="7">å
å«</option> |
| | | <option value="8">å·¦å
å«</option> |
| | | <option value="9">å³å
å«</option> |
| | | <option value="10">ä¸å
å«</option> |
| | | </select> |
| | | </div> |
| | | <div class="layui-inline"> |
| | | <input type="text" class="layui-input ForFilteringSchemes" value="" name="ColContent" id="ColContent"> |
| | | </div> |
| | | </div> |
| | | <div class="layui-row" style="margin:10px 0px"> |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label">è¿æ»¤</label> |
| | | <div class="layui-input-block"> |
| | | <select name="ColName1" id="ColName1" class="ForFilteringSchemes" lay-filter="ColName1" style="width:190px;"> |
| | | </select> |
| | | </div> |
| | | </div> |
| | | <div class="layui-inline"> |
| | | <select name="Comparator1" id="Comparator1" class="ForFilteringSchemes" lay-filter="Comparator1" style="width:190px;"> |
| | | <option value="0" selected="selected"></option> |
| | | <option value="=">=</option> |
| | | <option value=">=">>=</option> |
| | | <option value=">">></option> |
| | | <option value="<="><=</option> |
| | | <option value="<"><</option> |
| | | <option value="<>"><></option> |
| | | <option value="7">å
å«</option> |
| | | <option value="8">å·¦å
å«</option> |
| | | <option value="9">å³å
å«</option> |
| | | <option value="10">ä¸å
å«</option> |
| | | </select> |
| | | </div> |
| | | <div class="layui-inline"> |
| | | <input type="text" class="layui-input ForFilteringSchemes" value="" name="ColContent1" id="ColContent1"> |
| | | </div> |
| | | </div> |
| | | <div class="layui-row" style=" margin-top: 10px; margin-left: 70px;"> |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label">è¿æ»¤</label> |
| | | <div class="layui-input-block"> |
| | | <select name="ColName2" id="ColName2" class="ForFilteringSchemes" lay-filter="ColName2" style="width:190px;"> |
| | | </select> |
| | | </div> |
| | | </div> |
| | | <div class="layui-inline"> |
| | | <select name="Comparator2" id="Comparator2" class="ForFilteringSchemes" lay-filter="Comparator2" style="width:190px;"> |
| | | <option value="0" selected="selected"></option> |
| | | <option value="=">=</option> |
| | | <option value=">=">>=</option> |
| | | <option value=">">></option> |
| | | <option value="<="><=</option> |
| | | <option value="<"><</option> |
| | | <option value="<>"><></option> |
| | | <option value="7">å
å«</option> |
| | | <option value="8">å·¦å
å«</option> |
| | | <option value="9">å³å
å«</option> |
| | | <option value="10">ä¸å
å«</option> |
| | | </select> |
| | | </div> |
| | | <div class="layui-inline"> |
| | | <input type="text" class="layui-input ForFilteringSchemes" value="" name="ColContent2" id="ColContent2"> |
| | | </div> |
| | | </div> |
| | | </div> |
| | | </div> |
| | | |
| | | </div> |
| | | </div> |
| | | <table class="" id="mainTable" lay-filter="mainTable"></table> |
| | |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-RefreshCell" id="RefreshCell"><i class="layui-icon layui-icon-cols"></i>é»è®¤å宽</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="btn_HideColumn" id="HideColumn"><i class="layui-icon layui-icon-form"></i>å设置</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="btn_Exit" id="Exit"><i class="layui-icon layui-icon-logout"></i>éåº</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="set_SaveScheme" id="set_SaveScheme"><i class="layui-icon layui-icon-template"></i>ä¿åæ¹æ¡</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="set_ReadScheme" id="set_ReadScheme"><i class="layui-icon layui-icon-set"></i>è¯»åæ¹æ¡</button> |
| | | </div> |
| | | </script> |
| | | </form> |
| | |
| | | var titleData = ["HCusID"]; //ä¸éè¦æ¾ç¤ºçåæ®µ |
| | | //#endregion |
| | | |
| | | //#region ãè¿æ»¤æ¹æ¡ã |
| | | |
| | | //è¿æ»¤æ¡ä»¶çclassç±» |
| | | var HClassTag = "ForFilteringSchemes"; |
| | | //模ååç§°ï¼ä¸æçï¼ æ¯ä¸ªæ¨¡å页é¢é½éè¦ä¿®æ¹ |
| | | window.HModuleName = "å·¥åºå¼å¸¸è¿ç«æ¥è¡¨"; |
| | | //æ¯å¦å·²ç»éæ©äºè¿æ»¤æ¹æ¡ï¼å
¨å±åéï¼ |
| | | window.HDefaultFilter = ""; |
| | | //éæ©çè¿æ»¤æ¹æ¡å
ç ï¼å
¨å±åéï¼ |
| | | window.HInterID_Choose = 0; |
| | | |
| | | //#region è¿å
¥é¡µé¢å³å è½½ |
| | | |
| | | //åå§åçé¢ |
| | |
| | | set_InitGrid(); |
| | | //æ¥è¯¢ |
| | | get_Display(sWhere); |
| | | |
| | | DisPlay_HideColumn(); |
| | | |
| | | //æ¥è¯¢å½åç»å½ç¨æ·ææ²¡æå¨å½å模å设置é»è®¤è¿æ»¤æ¹æ¡ |
| | | get_DefaultModule(); |
| | | } |
| | | //#endregion |
| | | //#region åææ¾ç¤ºä¸ææ¡ |
| | | function ColFilter() { |
| | | var Organization = '<option value="0" selected="selected" ></option>'; |
| | | for (var i = 1; i < option.cols[0].length; i++) { |
| | | if (option.cols[0][i].hide != true) { |
| | | Organization += '<option style="color:blue;" value="' + option.cols[0][i].field + '">' + option.cols[0][i].field + '</option>'; |
| | | } |
| | | } |
| | | $("#ColName").empty(); |
| | | $("#ColName").append(Organization); |
| | | form.render('select'); |
| | | |
| | | $("#ColName1").empty(); |
| | | $("#ColName1").append(Organization); |
| | | form.render('select'); |
| | | $("#ColName2").empty(); |
| | | $("#ColName2").append(Organization); |
| | | form.render('select'); |
| | | } |
| | | //#endregion |
| | | |
| | | |
| | | //#region åå§åè¡¨æ ¼ |
| | | function set_InitGrid() { |
| | |
| | | |
| | | //#region æ¾ç¤ºåæ°æ® |
| | | function DisPlay_HideColumn() { |
| | | ColFilter(); |
| | | $.ajax({ |
| | | type: "GET", |
| | | url: GetWEBURL() + '/Xt_grdAlignment_WMES/grdAlignmentWMESList', |
| | |
| | | //å设置 |
| | | case 'btn_HideColumn': get_HideColumn(); |
| | | break; |
| | | //ä¿åæ¹æ¡ |
| | | case 'set_SaveScheme': set_SaveScheme(); |
| | | break; |
| | | //è¯»åæ¹æ¡ |
| | | case 'set_ReadScheme': set_ReadScheme(); |
| | | break; |
| | | }; |
| | | }); |
| | | //#endregion |
| | | |
| | | //#region 导åºExecel |
| | | function get_Export() { |
| | | table.exportFile(ins.config.id, option.data, "xls"); |
| | | var ModRightNameCheck = "Sc_ProcessErrStationReport_ExportExcel"; |
| | | |
| | | //é»è¾å®¡æ ¸æ¹æ³ |
| | | $.ajax({ |
| | | type: "GET", |
| | | url: GetWEBURL() + "/LMES/getReportByModRightNameCheck", //æ¹æ³æå¨é¡µé¢åæ¹æ³å |
| | | data: { "ModRightNameCheck": ModRightNameCheck, "user": sessionStorage["HUserName"] }, |
| | | success: function (result) { |
| | | if (result.count == 1) { |
| | | table.exportFile(ins.config.id, option.data, "xls"); |
| | | } else { |
| | | layer.alert("å½åæ¨¡åæ²¡æå¯¼åºæé!", { icon: 5 }); |
| | | } |
| | | }, error: function () { |
| | | layer.alert("æ¥å£è¯·æ±å¤±è´¥!", { icon: 5 }); |
| | | } |
| | | }); |
| | | } |
| | | //#endregion |
| | | |
| | |
| | | |
| | | //#region æ¥è¯¢ |
| | | function get_Display() { |
| | | |
| | | var HBeginDate = $("#HBeginDate").val(); //å¼å§æ¥æ |
| | | var HEndDate = $("#HEndDate").val(); //ç»ææ¥æ |
| | | var HProcID = $("#HProcID").val(); //å·¥åºID |
| | |
| | | |
| | | sWhere = "'" + HBeginDate + "','" + HEndDate + "','" + HProcID + "','" + HStatus + "','" + HICMOBillNo + "','" + HCusID + "','" + HEmpID + "','" + HQty + "'"; |
| | | |
| | | |
| | | //ä»»æå段æ¡ä»¶è¿æ»¤ æ¡ä»¶æå |
| | | 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(); |
| | | |
| | | //æ¼æ¥ä»»ä¸åæ®µè¿æ»¤æ¥è¯¢æ¡ä»¶ |
| | | var com = ""; |
| | | if (ColName != 0 && Comparator != 0 && typeof (ColName) != "undefined") { |
| | | 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; |
| | | } |
| | | com = " and (" + ColName + " " + com + ")"; |
| | | |
| | | } |
| | | |
| | | var com1 = ""; |
| | | if (ColName1 != 0 && Comparator1 != 0 && typeof (ColName1) != "undefined") { |
| | | |
| | | 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; |
| | | } |
| | | com1 = " and (" + ColName1 + " " + com1 + ")"; |
| | | |
| | | } |
| | | //sWhere += com + com1; |
| | | var com2 = ""; |
| | | if (ColName2 != 0 && Comparator2 != 0 && typeof (ColName2) != "undefined") { |
| | | |
| | | 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 = "" + Comparator2 + " ''" + ColContent2 + "''"; |
| | | break; |
| | | } |
| | | com2 = " and (" + ColName2 + " " + com2 + ")"; |
| | | |
| | | } |
| | | |
| | | //æ ¹æ®ç¨æ·è¿æ»¤ç¨æ·å
³è客æ·çè®°å½ |
| | | sWhere = sWhere + ",'" + getSWhereByHUser() + "'"; |
| | | sWhere = sWhere + ",'" + getSWhereByHUser() + com + com1 + com2+"'"; |
| | | |
| | | |
| | | var ajaxLoad = layer.load(); |
| | | $.ajax({ |
| | |
| | | ins = table.render(option); |
| | | |
| | | //å·æ°è¡¨æ ¼æ°æ® |
| | | DisPlay_HideColumn(); |
| | | //DisPlay_HideColumn(); |
| | | layer.close(ajaxLoad); |
| | | } else { |
| | | layer.close(ajaxLoad); |
| | |
| | | layer.alert("æ¥å£è¯·æ±å¤±è´¥!", { icon: 5 }); |
| | | } |
| | | }); |
| | | DisPlay_HideColumn(); |
| | | //DisPlay_HideColumn(); |
| | | } |
| | | //#endregion |
| | | |
| | | //#region å¿«éè¿æ»¤ |
| | | function get_FastQuery() { |
| | | var HBeginDate = $("#HBeginDate").val();//ä¸è¾¾æ¥æ å¼å§æ¥æ |
| | | var HEndDate = $("#HEndDate").val();//ç»ææ¥æ |
| | | |
| | | $("#HProcName").val(""); //å·¥åºåç§° |
| | | $("#HProcID").val("0"); //å·¥åºID |
| | | $("#HStatus").val("è¿ç«æªæ«"); //ç¶æ |
| | | $("#HICMOBillNo").val(""); //订åå· |
| | | $("#HCusName").val(""); //客æ·åç§° |
| | | $("#HCusID").val("0"); //客æ·ID |
| | | $("#HEmpName").val(""); //ä¸å¡ååç§° |
| | | $("#HEmpID").val("0"); //ä¸å¡åID |
| | | $("#HQty").val(""); //ç±³æ° |
| | | |
| | | //sWhere = " and æ¥æ between ''" + HBeginDate + "'' and ''" + HEndDate + "'' "; |
| | | |
| | | |
| | | |
| | | if (HProcName != "") { |
| | | sWhere += " and å·¥åºåç§° like ''%" + HProcName + "%'' "; |
| | | } |
| | | |
| | | if (HProcID != "") { |
| | | sWhere += " and å·¥åºID like ''%" + HProcID + "%'' "; |
| | | } |
| | | |
| | | if (HStatus != "") { |
| | | sWhere += " and ç¶æ like ''%" + HStatus + "%'' "; |
| | | } |
| | | |
| | | if (HICMOBillNo != "") { |
| | | sWhere += " and 订åå· like ''%" + HICMOBillNo + "%'' "; |
| | | } |
| | | |
| | | if (HCusName != "") { |
| | | sWhere += " and 客æ·åç§° like ''%" + HCusName + "%'' "; |
| | | } |
| | | if (HCusID != "") { |
| | | sWhere += " and 客æ·ID like ''%" + HCusID + "%'' "; |
| | | } |
| | | |
| | | if (HEmpName != "") { |
| | | sWhere += " and ä¸å¡ååç§° like ''%" + HEmpName + "%'' "; |
| | | } |
| | | |
| | | if (HEmpID != "") { |
| | | sWhere += " and ä¸å¡åID like ''%" + HEmpID + "%'' "; |
| | | } |
| | | if (HQty != "") { |
| | | sWhere += " and ç±³æ° like ''%" + HQty + "%'' "; |
| | | } |
| | | |
| | | //ä»»æå段æ¡ä»¶è¿æ»¤ æ¡ä»¶æå |
| | | 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(); |
| | | |
| | | //æ¼æ¥ä»»ä¸åæ®µè¿æ»¤æ¥è¯¢æ¡ä»¶ |
| | | var com = ""; |
| | | if (ColName != 0 && Comparator != 0) { |
| | | 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; |
| | | } |
| | | com = " 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; |
| | | } |
| | | com1 = " 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 = "" + Comparator2 + " ''" + ColContent2 + "''"; |
| | | break; |
| | | } |
| | | com2 = " and (" + ColName2 + " " + com2 + ")"; |
| | | |
| | | } |
| | | sWhere += com + com1 + com2; |
| | | |
| | | //æ ¹æ®ç¨æ·è¿æ»¤ç¨æ·å
³è客æ·çè®°å½ |
| | | sWhere += getSWhereByHUser(); |
| | | |
| | | get_Display(sWhere); |
| | | //è°ç¨æ¥å£åæ¸
空sWhereç¼å |
| | | sWhere = ""; |
| | | } |
| | | //#endregion |
| | | //#region éç½®æé® |
| | | form.on('submit(btnReSearch)', function (data) { |
| | | //æ¸
ç©ºè¿æ»¤æ¡ä»¶ |
| | |
| | | function set_ClearQuery() { |
| | | $("#HBeginDate").val(Format(new Date(new Date() - 1000 * 60 * 60 * 24 * (new Date().getDate() - 1)), "yyyy-MM-dd")); //å¼å§æ¥æ |
| | | $("#HEndDate").val(Format(new Date(), "yyyy-MM-dd")); //ç»ææ¥æ |
| | | |
| | | $("#HProcName").val(""); //å·¥åºåç§° |
| | | $("#HProcID").val("0"); //å·¥åºID |
| | | $("#HStatus").val("è¿ç«æªæ«"); //ç¶æ |
| | |
| | | $("#HEmpName").val(""); //ä¸å¡ååç§° |
| | | $("#HEmpID").val("0"); //ä¸å¡åID |
| | | $("#HQty").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"); |
| | | ColFilter(); |
| | | form.render('select'); |
| | | } |
| | | |
| | |
| | | layer.alert("æ¥å£è¯·æ±å¤±è´¥!", { icon: 5 }); |
| | | } |
| | | }); |
| | | res = res.replaceAll("'", "''"); |
| | | return res; |
| | | } |
| | | //#endregion |
| | | |
| | | //#endregion |
| | | //#region ãè¿æ»¤æ¹æ¡ã |
| | | |
| | | //è·åå½åç¨æ·çé»è®¤è¿æ»¤æ¹æ¡ |
| | | function get_DefaultModule() { |
| | | $.ajax({ |
| | | url: GetWEBURL() + '/Xt_FastICScheme/Chooselist', |
| | | type: "GET", |
| | | data: { "user": sessionStorage["Czybm"], "HModuleName": HModuleName, "HInterID": 0, "Type": "Default" }, |
| | | success: function (data1) { |
| | | if (data1.count == 1) { |
| | | //å½åç¨æ·è®¾ç½®æé»è®¤çè¿æ»¤æ¹æ¡ |
| | | var data = data1.data; |
| | | //å½åéæ©çè¿æ»¤æ¹æ¡ |
| | | HInterID_Choose = data[0].hmainid; |
| | | //è¿æ»¤æ¹æ¡å
ç |
| | | HInterID = data[0].hmainid |
| | | //è¿æ»¤æ¹æ¡åç§° |
| | | HDefaultFilter = data[0].æ¹æ¡åç§° |
| | | //è¿æ»¤æ¹æ¡ç夿³¨ï¼æ¹æ¡ä¿¡æ¯æè¿°ï¼ |
| | | var HRemark = data[0].夿³¨ |
| | | //æ¾ç¤ºåºå½åçé»è®¤è¿æ»¤æ¹æ¡ |
| | | document.getElementById("HFilterScheme_Now").style.display = "block"; |
| | | document.getElementById('HFilterScheme_Now').innerHTML = "å½åè¿æ»¤æ¹æ¡ï¼" + HDefaultFilter + '<span style="font-size: 15px; font-weight: bold; color:#7b90fb"> ' + "(" + HRemark + ")" + '</span>'; |
| | | //æè¿æ»¤æ¡ä»¶å¼ååå°é¡µé¢ä¸ |
| | | for (let i = 0; i < data.length; i++) { |
| | | $("#" + data[i].è¿æ»¤å段ID).val(data[i].è¿æ»¤å¼); |
| | | if (data[i].è¿æ»¤æ ç¾ç±»å == 'SELECT') { |
| | | $("#" + data[i].è¿æ»¤å段ID).find("option[value='" + data[i].è¿æ»¤å¼ + "']").attr("selected", true); |
| | | } |
| | | } |
| | | //æ¥è¯¢ |
| | | |
| | | get_FastQuery(); |
| | | |
| | | form.render("select"); |
| | | } else { |
| | | //å½åç¨æ·æ²¡æè®¾ç½®é»è®¤çè¿æ»¤æ¹æ¡ |
| | | //éèæ¾ç¤ºè¿æ»¤æ¹æ¡çæ ç¾ä¿¡æ¯ |
| | | document.getElementById("HFilterScheme_Now").style.display = "none"; |
| | | //æ§è¡æ¥è¯¢æ¹æ³ |
| | | //æ¥è¯¢ |
| | | get_FastQuery(); |
| | | form.render("select"); |
| | | } |
| | | }, error: function () { |
| | | layer.alert("æ¥å£è¯·æ±å¤±è´¥!", { icon: 5 }); |
| | | } |
| | | }); |
| | | } |
| | | |
| | | //ä¿åæ¹æ¡ |
| | | function set_SaveScheme() { |
| | | var index = layer.open() |
| | | //å¤æç¨æ·æ¯å¦ç¹å»äºå³ä¸è§çâåå·âå
³éå¼¹çªé¡µé¢ |
| | | var HIsClose_Manual = false; |
| | | //è·åæ¬é¡µææè¿æ»¤æ¡ä»¶å¯¹è±¡(classä¸å
å«"ForFilteringSchemes"çå
ç´ ) |
| | | var Filter = document.getElementsByClassName(HClassTag); |
| | | |
| | | var HFilterIdList = "";//è¿æ»¤æ¡ä»¶ |
| | | var HFilterIdLists = "";//æ¼æ¥å¤ä¸ªè¿æ»¤æ¡ä»¶ |
| | | var HValue = "";//è¿æ»¤å¼ |
| | | var HElement_type = "";//è¿æ»¤æ ç¾ç±»å |
| | | |
| | | for (var i = 0; i < Filter.length; i++) { |
| | | HFilterIdList = Filter[i].id; //è¿æ»¤æ¡ä»¶ID |
| | | HFilterIdLists += Filter[i].id + ","; //è¿æ»¤æ¡ä»¶ID(æ¼æ¥) |
| | | HValue += $("#" + HFilterIdList).val() + ","; //è¿æ»¤æ¡ä»¶ä¸è¾å
¥çå¼ |
| | | HElement_type += document.getElementById(HFilterIdList).tagName + ",";//éè¿æ ç¾idè·åæ ç¾ç±»å |
| | | } |
| | | |
| | | //å»é¤æ«å°¾éå· |
| | | HFilterIdLists = HFilterIdLists.substring(0, HFilterIdLists.length - 1); |
| | | HValue = HValue.substring(0, HValue.length - 1); |
| | | HElement_type = HElement_type.substring(0, HElement_type.length - 1); |
| | | |
| | | //å½å页é¢ä¸æ²¡æéæ©è¿æ»¤æ¹æ¡ï¼è¿å
¥æ°å¢æ¹æ³ |
| | | if (HDefaultFilter == "") { |
| | | layer.open({ |
| | | type: 2 |
| | | , area: ['40%', '80%'] |
| | | , title: 'è¿æ»¤æ¹æ¡' |
| | | , shift: 0//å¼¹åºå¨ç» |
| | | , content: '../../ç³»ç»ç®¡ç/è¿æ»¤æ¹æ¡è®¾ç½®/Xt_FastICScheme.html?OperationType=1&HModuleName=' + HModuleName + '&HFilterIdLists=' + HFilterIdLists + '&HValue=' + HValue + '&HElement_type=' + HElement_type |
| | | , cancel: function () { |
| | | // å³ä¸è§å
³éäºä»¶çé»è¾ |
| | | HIsClose_Manual = true; |
| | | } |
| | | , end: function () { |
| | | if (HIsClose_Manual != true) { |
| | | get_FastQuery(); |
| | | //æ¾ç¤ºå½åçè¿æ»¤æ¹æ¡ |
| | | document.getElementById("HFilterScheme_Now").style.display = "block"; |
| | | document.getElementById('HFilterScheme_Now').innerHTML = "å½åè¿æ»¤æ¹æ¡ï¼" + sessionStorage["HFilterSchemeName_" + sessionStorage["Czybm"]] + '<span style="font-size: 15px; font-weight: bold; color:#7b90fb"> ' + "(" + sessionStorage["HFilterSchemeRemark_" + sessionStorage["Czybm"]] + ")" + '</span>'; |
| | | } |
| | | } |
| | | }) |
| | | layer.close(index) |
| | | } else { |
| | | //å½å页é¢å·²æè¿æ»¤æ¹æ¡ï¼ç¨æ·éæ© æ°å¢æè
ç¼è¾ |
| | | layer.confirm('å½åå·²éæ©è¿æ»¤æ¹æ¡ï¼æ¯å¦ä¿®æ¹ï¼è¯·éæ©å¯¹åºæä½', { |
| | | title: "æä½æç¤º", |
| | | icon: 0, |
| | | btn: ['æ°å¢æ¹æ¡', 'ä¿åä¿®æ¹å½åæ¹æ¡', 'åæ¶'] |
| | | }, function (index, layero) { |
| | | //æ°å¢ |
| | | layer.open({ |
| | | type: 2 |
| | | , area: ['40%', '80%'] |
| | | , title: 'è¿æ»¤æ¹æ¡' |
| | | , shift: 0//å¼¹åºå¨ç» |
| | | , content: '../../ç³»ç»ç®¡ç/è¿æ»¤æ¹æ¡è®¾ç½®/Xt_FastICScheme.html?OperationType=1&HModuleName=' + HModuleName + '&HFilterIdLists=' + HFilterIdLists + '&HValue=' + HValue + '&HElement_type=' + HElement_type |
| | | , end: function () { |
| | | get_FastQuery() |
| | | //æ¾ç¤ºå½åçè¿æ»¤æ¹æ¡ |
| | | document.getElementById("HFilterScheme_Now").style.display = "block"; |
| | | document.getElementById('HFilterScheme_Now').innerHTML = "å½åè¿æ»¤æ¹æ¡ï¼" + sessionStorage["HFilterSchemeName_" + sessionStorage["Czybm"]] + '<span style="font-size: 15px; font-weight: bold; color:#7b90fb"> ' + "(" + sessionStorage["HFilterSchemeRemark_" + sessionStorage["Czybm"]] + ")" + '</span>'; |
| | | } |
| | | }) |
| | | layer.close(index) |
| | | }, function (index) { |
| | | //ç¼è¾ |
| | | var Filter_Edit = document.getElementsByClassName(HClassTag); //è·åæ¬é¡µææè¿æ»¤æ¡ä»¶å¯¹è±¡(classä¸å
å«"ForFilteringSchemes"çå
ç´ ) |
| | | HFilterIdList = ""; |
| | | HFilterIdLists = ""; |
| | | HValue = ""; |
| | | HElement_type = ""; |
| | | for (var i = 0; i < Filter_Edit.length; i++) { |
| | | HFilterIdList = Filter_Edit[i].id; //è¿æ»¤æ¡ä»¶ID |
| | | HFilterIdLists += Filter_Edit[i].id + ","; //è¿æ»¤æ¡ä»¶ID(æ¼æ¥) |
| | | HValue += $("#" + HFilterIdList).val() + ","; //è¿æ»¤æ¡ä»¶ä¸è¾å
¥çå¼ |
| | | HElement_type += document.getElementById(HFilterIdList).tagName + ",";//éè¿æ ç¾idè·åæ ç¾ç±»å |
| | | } |
| | | //å»é¤æ«å°¾éå· |
| | | HFilterIdLists = HFilterIdLists.substring(0, HFilterIdLists.length - 1); |
| | | HValue = HValue.substring(0, HValue.length - 1); |
| | | HElement_type = HElement_type.substring(0, HElement_type.length - 1); |
| | | |
| | | var sMainSub = HInterID_Choose + ';' + HFilterIdLists + ';' + HValue + ';' + HElement_type + ';' + sessionStorage["Czybm"] + ';' + 3; |
| | | |
| | | //ä¿®æ¹ |
| | | $.ajax({ |
| | | type: "POST", |
| | | url: GetWEBURL() + "/Xt_FastICScheme/save", //æ¹æ³æå¨é¡µé¢åæ¹æ³å |
| | | async: true, |
| | | data: { "oMain": sMainSub }, |
| | | dataType: "json", |
| | | success: function (data) { |
| | | if (data.count == 1) { // 说æéªè¯æåäºï¼ |
| | | layer.msg(data.Message, { time: 1 * 1000, icon: 1 }); |
| | | } |
| | | else { |
| | | |
| | | } |
| | | layer.closeAll("loading"); |
| | | }, |
| | | error: function (err) { |
| | | |
| | | |
| | | } |
| | | }); |
| | | layer.close(index) |
| | | }, function (index) { |
| | | //åæ¶ |
| | | layer.alert('åæ¶') |
| | | layer.close(index) |
| | | }); |
| | | } |
| | | |
| | | } |
| | | |
| | | //è¯»åæ¹æ¡ |
| | | function set_ReadScheme() { |
| | | var HIsClose_Manual = false; |
| | | var Filter = document.getElementsByClassName(HClassTag); //è·åæ¬é¡µææè¿æ»¤æ¡ä»¶å¯¹è±¡(classä¸å
å«"ForFilteringSchemes"çå
ç´ ) |
| | | |
| | | var HFilterIdList = ""; |
| | | var HFilterIdLists = ""; |
| | | var HValue = ""; |
| | | var HElement_type = ""; |
| | | for (var i = 0; i < Filter.length; i++) { |
| | | HFilterIdList = Filter[i].id; //è¿æ»¤æ¡ä»¶ID |
| | | HFilterIdLists += Filter[i].id + ","; //è¿æ»¤æ¡ä»¶ID(æ¼æ¥) |
| | | HValue += $("#" + HFilterIdList).val() + ","; //è¿æ»¤æ¡ä»¶ä¸è¾å
¥çå¼ |
| | | HElement_type += document.getElementById(HFilterIdList).tagName + ",";//éè¿æ ç¾idè·åæ ç¾ç±»å |
| | | } |
| | | //å»é¤æ«å°¾éå· |
| | | HFilterIdLists = HFilterIdLists.substring(0, HFilterIdLists.length - 1); |
| | | HValue = HValue.substring(0, HValue.length - 1); |
| | | HElement_type = HElement_type.substring(0, HElement_type.length - 1); |
| | | |
| | | layer.open({ |
| | | type: 2 |
| | | , area: ['80%', '80%'] |
| | | , title: 'è¿æ»¤æ¹æ¡å表' |
| | | , shift: 0//å¼¹åºå¨ç» |
| | | , content: '../../ç³»ç»ç®¡ç/è¿æ»¤æ¹æ¡è®¾ç½®/Xt_FastICSchemeList.html?HType=Select&HFilterIdLists=' + HFilterIdLists + '&HValue=' + HValue + '&HElement_type=' + HElement_type + '&HModuleName=' + HModuleName |
| | | , cancel: function () { |
| | | // å³ä¸è§å
³éäºä»¶çé»è¾ |
| | | HIsClose_Manual = true; |
| | | } |
| | | , end: function () { |
| | | if (HIsClose_Manual != true) { |
| | | get_FastQuery() |
| | | form.render("select"); |
| | | } |
| | | } |
| | | }) |
| | | } |
| | | |
| | | //#endregion |
| | | //#endregion |
| | | }); |
| | | //#region ãè¿æ»¤æ¹æ¡è¿åæ°æ®ã |
| | | function HFilterScheme(obj) //è¿åè¿æ»¤æ¹æ¡ |
| | | { |
| | | var HInterID = obj[0].hmainid; |
| | | HInterID_Choose = obj[0].hmainid; |
| | | $.ajax({ |
| | | url: GetWEBURL() + '/Xt_FastICScheme/Chooselist', |
| | | type: "GET", |
| | | data: { "user": sessionStorage["Czybm"], "HModuleName": HModuleName, "HInterID": HInterID, "Type": "Select" }, |
| | | success: function (data1) { |
| | | if (data1.count == 1) { |
| | | var data = data1.data; |
| | | //èµå¼è¿æ»¤æ¹æ¡åç§° |
| | | HDefaultFilter = data[0].æ¹æ¡åç§° |
| | | var HRemark = data[0].夿³¨ |
| | | //æ¾ç¤ºå½åçè¿æ»¤æ¹æ¡ |
| | | document.getElementById("HFilterScheme_Now").style.display = "block"; |
| | | document.getElementById('HFilterScheme_Now').innerHTML = "å½åè¿æ»¤æ¹æ¡ï¼" + HDefaultFilter + '<span style="font-size: 15px; font-weight: bold; color:#7b90fb"> ' + "(" + HRemark + ")" + '</span>'; |
| | | HInterID = data[0].hmainid |
| | | //æ ¹æ®éæ©çè¿æ»¤æ¹æ¡åå¡«æ°æ®å°åè¡¨è¿æ»¤æ¡ä»¶ |
| | | for (let i = 0; i < data.length; i++) { |
| | | $("#" + data[i].è¿æ»¤å段ID).val(data[i].è¿æ»¤å¼); |
| | | if (data[i].è¿æ»¤æ ç¾ç±»å == 'SELECT') { |
| | | $("#" + data[i].è¿æ»¤å段ID).find("option[value='" + data[i].è¿æ»¤å¼ + "']").attr("selected", true); |
| | | } |
| | | } |
| | | |
| | | } else { |
| | | layer.close(ajaxLoad); |
| | | layer.alert(data1.code + data1.Message, { icon: 5 }); |
| | | } |
| | | }, error: function () { |
| | | layer.close(ajaxLoad); |
| | | layer.alert("æ¥å£è¯·æ±å¤±è´¥!", { icon: 5 }); |
| | | } |
| | | }); |
| | | } |
| | | //#endregion |
| | | |
| | | //è¿åå·¥åº |
| | | function GetHProcValue(obj) { |
| | | $("#HProcName").val(obj[0].å·¥åº); |
| | | $("#HProcID").val(obj[0].HItemID); |
| | | } |
| | | |
| | | |
| | | </script> |
| | | |
| | | </body> |