| WebTM/Properties/PublishProfiles/LAYUI.pubxml.user | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
| WebTM/WebTM.csproj | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
| WebTM/views/仓存管理/条码报表/Kf_ICInventory_Cus.html | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
| WebTM/views/应收管理/报表分析/Xs_CusShouGongChaoBaoReport.html | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 |
WebTM/Properties/PublishProfiles/LAYUI.pubxml.user
@@ -29,11 +29,11 @@ </File> <File Include="bin/WebTM.dll"> <publishTime>04/27/2021 20:31:08</publishTime> <publishTime>09/01/2025 08:40:46</publishTime> <publishTime>09/01/2025 15:45:55</publishTime> </File> <File Include="bin/WebTM.pdb"> <publishTime>04/27/2021 20:31:08</publishTime> <publishTime>09/01/2025 08:40:46</publishTime> <publishTime>09/01/2025 15:45:55</publishTime> </File> <File Include="Download/WMS软件å®è£ å .apk"> <publishTime>07/29/2025 13:10:58</publishTime> @@ -3268,6 +3268,9 @@ <File Include="views/ä»å管ç/æ¡ç æ¥è¡¨/Kf_ICInventory_BarCode.html"> <publishTime>09/01/2025 10:11:20</publishTime> </File> <File Include="views/ä»å管ç/æ¡ç æ¥è¡¨/Kf_ICInventory_Cus.html"> <publishTime>09/01/2025 15:45:41</publishTime> </File> <File Include="views/ä»å管ç/æ¡ç æ¥è¡¨/Kf_ICInventory_Mater.html"> <publishTime>07/15/2024 09:58:59</publishTime> </File> @@ -4974,6 +4977,9 @@ <File Include="views/åºæ¶ç®¡ç/æ¥è¡¨åæ/Xs_CusBalanceReport_HIsUsingBalanceEntry.html"> <publishTime>03/26/2024 16:28:56</publishTime> </File> <File Include="views/åºæ¶ç®¡ç/æ¥è¡¨åæ/Xs_CusShouGongChaoBaoReport.html"> <publishTime>09/01/2025 13:16:46</publishTime> </File> <File Include="views/åºæ¶ç®¡ç/æ¥è¡¨åæ/Xs_OutDoorBillReport.html"> <publishTime>04/14/2025 10:04:52</publishTime> </File> WebTM/WebTM.csproj
@@ -420,6 +420,7 @@ <Content Include="views\ä»å管ç\ä»åºè°æ¨\Add_Edit_Kf_MoveStockBill.html" /> <Content Include="views\ä»å管ç\忥å¼è°å ¥å\Fb_StepFoldinBillEdit.html" /> <Content Include="views\ä»å管ç\æ¡ç åºå\KF_PonderationBillMain_Temp.html" /> <Content Include="views\ä»å管ç\æ¡ç æ¥è¡¨\Kf_ICInventory_Cus.html" /> <Content Include="views\ä»å管ç\æ¡ç æ¥è¡¨\Kf_StockInOutEntryByPageReport.html" /> <Content Include="views\ä»å管ç\æ¡ç æ¥è¡¨\KF_StockInOutEntryReport.html" /> <Content Include="views\ä»å管ç\æ¡ç æ¥è¡¨\KF_StockInOutRecordReport.html" /> @@ -595,6 +596,7 @@ <Content Include="views\å·¥èµç®¡ç\å·¥èµè¿ç®\Pay_SalaryCalculate_New.html" /> <Content Include="views\å·¥èµç®¡ç\æè½èæ ¸\HR_EmployeeSkillExamBill.html" /> <Content Include="views\å·¥èµç®¡ç\æè½èæ ¸\HR_EmployeeSkillExamBillList.html" /> <Content Include="views\åºæ¶ç®¡ç\æ¥è¡¨åæ\Xs_CusShouGongChaoBaoReport.html" /> <Content Include="views\åºæ¶ç®¡ç\æ¥è¡¨åæ\Kf_SellOutEntryReport_YP.html" /> <Content Include="views\åºæ¶ç®¡ç\æ¥è¡¨åæ\Xs_OutDoorBillReport.html" /> <Content Include="views\åºæ¶ç®¡ç\æ¥è¡¨åæ\Xs_SellOutCompareToProductReport.html" /> WebTM/views/²Ö´æ¹ÜÀí/ÌõÂ뱨±í/Kf_ICInventory_Cus.html
New file @@ -0,0 +1,1034 @@ <!DOCTYPE html> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>客æ·ç©æå³æ¶åºåæ¥è¡¨</title> <meta name="renderer" content="webkit"> <meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1"> <meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1"> <link rel="stylesheet" href="../../../layuiadmin/layui/css/layui.css" media="all"> <link rel="stylesheet" href="../../../layuiadmin/style/admin.css" media="all"> <script src="../../../layuiadmin/layui/layui.js"></script> <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/PubCustom.js"></script> <script src="../../../layuiadmin/zgqCustom/zgqCustom.js"></script> <script src="../../../layuiadmin/HideButton.js"></script> </head> <body> <div class="layui-fluid"> <div class="layui-col-md12"> <div class="layui-card" style="padding: 1px"> <div class="layui-card-body" style="padding: 1px;"> <form class="layui-form" action="" lay-filter="component-form-group"> <div class="layui-collapse"> <div class="layui-colla-item"> <div class="layui-colla-title layui-inline"> <div class="layui-inline"> <span>æ´å¤</span> </div> </div> <div class="layui-inline"> <label class="layui-form-label">客æ·</label> <div class="layui-input-block"> <input type="text" class="layui-input ForFilteringSchemes" name="HCusName" id="HCusName" style="width:190px;"> </div> </div> <div class="layui-inline"> <label class="layui-form-label">ä»åº</label> <div class="layui-input-block"> <input type="text" class="layui-input ForFilteringSchemes" name="HWHName" id="HWHName" style="width:190px;"> </div> </div> <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" class="ForFilteringSchemes" lay-verify="HOrgID"> <!--å¨ææ¸²æç»ç»--> </select> </div> </div> <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnSearch" id="btnSearch"> <i class="layui-icon layui-icon-search layuiadmin-button-btn"></i> </button> <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnReSearch" id="btnReSearch" style="padding:0 5px">éç½®</button> <div class="layui-row"> <!--æ¾ç¤ºå½åè¿æ»¤æ¹æ¡--> <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> <div class="layui-colla-content"> <div class="layui-inline"> <div class="layui-inline"> <span>å ¶ä»æ¡ä»¶></span> </div> </div> <div class="layui-inline"> <label class="layui-form-label">ç©æä»£ç </label> <div class="layui-input-block"> <input type="text" class="layui-input ForFilteringSchemes" name="HMaterNumber" id="HMaterNumber" style="width:190px;"> </div> </div> <div class="layui-inline"> <label class="layui-form-label">ç©æåç§°</label> <div class="layui-input-block"> <input type="text" class="layui-input ForFilteringSchemes" name="HMaterName" id="HMaterName" style="width:190px;"> </div> </div> </div> <div class="layui-colla-content" style="padding: 0px; margin-left: 6%;"> <div class="layui-row" style="margin-top:5px"> <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-top: 10px; margin-left: 70px;"> <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> <table class="" id="mainTable" lay-filter="mainTable"></table> <script type="text/html" id="toolbarDemo"> <div class="layui-btn-container"> <button type="button" class="layui-btn layui-btn-sm" lay-event="get_Refresh" id="get_Refresh"><i class="layui-icon layui-icon-refresh-3"></i>å·æ°</button> <button type="button" class="layui-btn layui-btn-sm" lay-event="set_HideColumn" id="set_HideColumn"><i class="layui-icon layui-icon-form"></i>å设置</button> <button type="button" class="layui-btn layui-btn-sm" lay-event="HideButton" id="HideButton"><i class="layui-icon layui-icon-form"></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> <button type="button" class="layui-btn layui-btn-sm" lay-event="get_export" id="get_export"><i class="layui-icon layui-icon-export"></i>导åº</button> <button type="button" class="layui-btn layui-btn-sm" lay-event="get_Exit" id="get_Exit"><i class="layui-icon layui-icon-logout"></i>éåº</button> </div> </script> </form> </div> </div> </div> </div> <script> layui.config({ base: '../../../layuiadmin/' //éæèµæºæå¨è·¯å¾ }).extend({ index: 'lib/index', //ä¸»å ¥å£æ¨¡å }).use(['index', 'form', 'table', 'element', 'laypage', 'laydate'], function () { //#region å ¬ç¨åé var $ = layui.$ , admin = layui.admin , layer = layui.layer , table = layui.table , form = layui.form , element = layui.element , laypage = layui.laypage , laydate = layui.laydate var option = []; var sWhere = ""; var HModName = "Kf_ICInventory_Cus"; //ä¸éè¦æ¾ç¤ºçåæ®µ 坿©å± var titleData = []; var ins; //ç¨äºå¯¼åºexcel //#endregion //#region ãè¿æ»¤æ¹æ¡ã //è¿æ»¤æ¡ä»¶çclassç±» var HClassTag = "ForFilteringSchemes"; //模ååç§°ï¼ä¸æçï¼ æ¯ä¸ªæ¨¡å页é¢é½éè¦ä¿®æ¹ window.HModuleName = "客æ·ç©æå³æ¶åºåæ¥è¡¨"; //æ¯å¦å·²ç»éæ©äºè¿æ»¤æ¹æ¡ï¼å ¨å±åéï¼ window.HDefaultFilter = ""; //éæ©çè¿æ»¤æ¹æ¡å ç ï¼å ¨å±åéï¼ window.HInterID_Choose = 0; //#endregion //#region è¿å ¥é¡µé¢å³å è½½ //è·åç»ç» Organ(); //åå§åçé¢ set_ClearBill(); //#endregion //#region 触åäºä»¶ï¼å æ¬form.on(){}æ ¼å¼çææç¹å»äºä»¶ãéæ©äºä»¶ç //#region å¤´å·¥å ·æ äºä»¶ table.on('toolbar(mainTable)', function (obj) { switch (obj.event) { //导åºexcel case 'get_export': get_Export(); break; //å·æ° case 'get_Refresh': get_Refresh(); break; //éåºæé® case 'get_Exit': Pub_Close(2); break; //å设置 case 'set_HideColumn': get_HideColumn(); break; //æé®è®¾ç½® case 'HideButton': var btns = document.getElementsByTagName("button"); //è·åæ¬é¡µæææé®å¯¹è±¡ var HBillType = "Kf_ICInventory_Cus"; get_HideButton(btns, HBillType, HModName, sessionStorage["HUserName"]); break; //ä¿åæ¹æ¡ case 'set_SaveScheme': set_SaveScheme(); break; //è¯»åæ¹æ¡ case 'set_ReadScheme': set_ReadScheme(); break; }; }); //#endregion //#region ç¹å»è¡éä¸é«äº® table.on('row(mainTable)', function (obj) { //éä¸è¡æ¹åé¢è² var flag = !obj.tr.find(':checkbox:first').prop('checked'); obj.tr.find(':checkbox').prop('checked', flag); if (flag) { obj.tr.find('.layui-form-checkbox').addClass('layui-form-checked'); //设置å¤éæ¡é䏿 ·å¼ $(obj.tr.selector).attr({ "style": "background:#ceedfa;color:black" });//æ¹åå½åtrèæ¯é¢è²ååä½é¢è² } else { obj.tr.find('.layui-form-checkbox').removeClass('layui-form-checked');//åæ¶å¤éæ¡é䏿 ·å¼ $(obj.tr.selector).attr({ "style": "background:" });//åæ¶å½åtré¢è² } //mainTable ä¸ºè¡¨æ ¼ID æ³¨ææ¤å¤å¦æID䏿£ç¡®å°å¯¼è´ä½ å¨çå¬å¤éæ¡æ¶è·åä¸å°ä½ éæ©çæ°æ®ï¼åé¢çåªæ¯æ·»å æå é¤é䏿ªé䏿 ·å¼ä»¥åè®¾ç½®èæ¯è²ï¼åä½é¢è² layui.each(table.cache.mainTable, function (i, l) { if (obj.tr.index() == l.LAY_TABLE_INDEX) { l.LAY_CHECKED = flag; } }); }) //#endregion //#region éç½®æé® form.on('submit(btnReSearch)', function (data) { set_ClearQuery(); }); //#endregion //#region æ¥è¯¢æé® form.on('submit(btnSearch)', function (data) { get_FastQuery(2); }); //#endregion //#region æ¬é¡µé¢ææè¢«è°ç¨çæ¹æ³ //#region åå§åçé¢ function set_ClearBill() { //åå§åè¡¨æ ¼ set_InitGrid(); //æ¥è¯¢ get_FastQuery(1); //æ¥è¯¢å½åç»å½ç¨æ·ææ²¡æå¨å½å模å设置é»è®¤è¿æ»¤æ¹æ¡ get_DefaultModule(); } //#endregion //#region åå§åè¡¨æ ¼æ¹æ³ function set_InitGrid() { option = { elem: '#mainTable' , toolbar: '#toolbarDemo' , height: 'full-50' , page: true , totalRow: true //, cellMinWidth: 90 , limit: 50 , limits: [50, 500, 5000, 20000] }; } //#endregion //#endregion //#region æ¥è¯¢ function get_Display(sql) { var ajaxLoad = layer.load(); var ModRightNameCheck = "Kf_ICInventory_Cus"; $.ajax({ url: GetWEBURL() + '/CommonModel/searchMethod', type: "GET", async:false, data: { "sql": sql, "user": sessionStorage["HUserName"], "ModRightNameCheck": ModRightNameCheck}, success: function (data1) { if (data1.count == 1) { var totalArray = []; var data = []; var col = []; //ç»ç©ºçæ°ç»èµå¼ col.push({ type: 'checkbox', fixed: 'left', totalRowText: 'å计' }); for (var key in data1.list) { data.push({ "id": data1.list[key].ColmCols, "name": data1.list[key].ColmCols, "Type": data1.list[key].ColmType }); } //å¨å表左边添å å¾éæ¡ //col.push({ type: 'checkbox', fixed: 'left' }); for (var i = 0; i < data.length; i++) { // if (data[i].name == 'HInterID' || data[i].name == 'HBillType' || data[i].name == 'hmainid') { if ($.inArray(data[i].name, titleData) > -1) { col.push({ field: data[i].id, title: data[i].name, align: 'center', hide: true }); //éèidå } else if ($.inArray(data[i].name, totalArray) > -1) { col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, totalRow: true, width: 120 }); } else { switch (data[i].Type) { //int 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:120 }); break; default: col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, width: 120 }); } } } option.cols = [col]; option.data = data1.data; ins = table.render(option); //å·æ°æé®æ¾ç¤º var btns = document.getElementsByTagName("button"); //è·åæ¬é¡µæææé®å¯¹è±¡ var HBillType = "Kf_ICInventory_Cus"; Display_HideButton(btns, HBillType, HModName, sessionStorage["HUserName"]); //å·æ°è¡¨æ ¼æ°æ® DisPlay_HideColumn(); layer.close(ajaxLoad); if ($("#Comparator").val() == 0 && $("#ColContent").val() == "" && $("#Comparator1").val() == 0 && $("#ColContent1").val() == "" && $("#Comparator2").val() == 0 && $("#ColContent2").val() == "") { ColFilter(); } //layer.alert("æ¥è¯¢æå", { icon: 1 }); } else { layer.close(ajaxLoad); layer.alert(data1.code + data1.Message, { icon: 5 }); } }, error: function () { layer.close(ajaxLoad); layer.alert("æ¥å£è¯·æ±å¤±è´¥!", { icon: 5 }); } }); } //#endregion //#region å¿«éè¿æ»¤ function get_FastQuery(number) { var HCusName = $("#HCusName").val(); var HWHName = $("#HWHName").val(); var HMaterNumber = $("#HMaterNumber").val(); var HMaterName = $("#HMaterName").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 = "" + Comparator2 + "'" + ColContent2 + "'"; break; } sWhere += " and " + ColName2 + " " + com2; } HOrgID = $("#HOrgID").val();//ç»ç» if (HCusName) { sWhere += " and å®¢æ· like '%" + HCusName + "%'"; } if (HWHName) { sWhere += " and ä»åº like '%" + HWHName + "%'"; } if (HMaterNumber) { sWhere += " and ç©æä»£ç like '%" + HMaterNumber + "%'"; } if (HMaterName) { sWhere += " and ç©æåç§° like '%" + HMaterName + "%'"; } //æ ¹æ®ç¨æ·è¿æ»¤ç¨æ·å ³è客æ·çè®°å½ sWhere += getSWhereByHUser(); sWhere = sWhere.replaceAll("'", "''"); var sql = "exec h_p_Kf_ICInventory_Cus '" + sWhere + "'"; get_Display(sql); sWhere = "";//è°ç¨æ¥å£åæ¸ ç©ºsWhereç¼å } //#endregion //#region éç½®è¿æ»¤æ¡ä»¶æ¹æ³ function set_ClearQuery() { $("#HCusName").val("");// $("#HWHName").val(""); $("#HMatrNumber").val(""); $("#HMaterName").val(""); $("#HOrgID").val(sessionStorage["OrganizationID"]); $("#ColContent").val(""); $("#ColName").val("0"); $("#Comparator").val("0"); $("#ColContent1").val(""); $("#ColName1").val("0"); $("#Comparator1").val("0"); $("#ColContent2").val(""); $("#ColName2").val("0"); $("#Comparator2").val("0"); form.render('select'); sWhere = ""; } //#endregion //#region 导åºExecel function get_Export() { var ModRightNameCheck = "Kf_ICInventory_Cus"; //é»è¾å®¡æ ¸æ¹æ³ $.ajax({ type: "GET", url: GetWEBURL() + "/LMES/getReportByModRightNameCheck", //æ¹æ³æå¨é¡µé¢åæ¹æ³å data: { "ModRightNameCheck": ModRightNameCheck, "user": sessionStorage["HUserName"] }, success: function (result) { if (result.count == 1) { var data = option.data; data.forEach((item) => { for (let itemobj in item) { if (item[itemobj] == null) { item[itemobj] = ""; } if (item[itemobj].length > 0) { // åè®¾åæ®µå为field item[itemobj] = item[itemobj].toString().replaceAll(/[\r\n]+/g, ''); // å°æ¢è¡ç¬¦æ¿æ¢ä¸ºç©ºå符串 item[itemobj] = item[itemobj].toString().replaceAll(/[,]+/g, 'ï¼'); // å°æ¢åå·æ¿æ¢ä¸ºç©ºå符串 } } }); table.exportFile(ins.config.id,data, "xls"); } else { layer.alert("å½åæ¨¡åæ²¡æå¯¼åºæé!", { icon: 5 }); } }, error: function () { layer.alert("æ¥å£è¯·æ±å¤±è´¥!", { icon: 5 }); } }); } //#endregion //#region å·æ° function get_Refresh() { $("#btnSearch").trigger('click'); } //#endregion //#region è·åç»ç» function Organ() { //è·åç»å½é¡µç»ç»å $.ajax({ type: "get", url: GetWEBURL() + "/Web/GetOrganizations", success: function (result) { var Organization = ""; 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>'; } $("#HOrgID").append(Organization); $("#HOrgID").val(sessionStorage["OrganizationID"]) form.render('select'); } layer.closeAll("loading"); } }) } //#endregion //#region éèå设置 function get_HideColumn() { var colName = ""; var contentUrl = ""; for (var i = 1; i < option.cols[0].length; i++) { colName += option.cols[0][i]["title"] + ","; } var urlStr = window.document.location.pathname;//è·åæä»¶è·¯å¾ var urlLen = urlStr.split('/'); for (var i = 0; i < urlLen.length - 4; i++) { contentUrl += "../"; } colName = encodeURI(colName.substring(0, colName.length - 1));//对 URI è¿è¡ç¼ç contentUrl += 'åºç¡èµæ/éèå设置/Gy_GridView_Hide.html?HModName=' + HModName + '&colName=' + colName; layer.open({ type: 2 , skin: "layui-layer-rim" //å ä¸è¾¹æ¡ , title: "éèå设置" //æ é¢ , closeBtn: 1 //çªä½å³ä¸è§å ³é ç æ ·å¼ , shift: 2 //å¼¹åºå¨ç» , area: ["50%", "90%"] //çªä½å¤§å° , maxmin: true //设置æå¤§æå°æé®æ¯å¦æ¾ç¤º , content: [contentUrl, "yes"] , btn: ["ç¡®å®", "åæ¶"] , btn1: function (index, laero) { //å·æ°è¡¨æ ¼æ°æ® DisPlay_HideColumn(); //æ´æ°è¡¨æ ¼ç¼åçæ°æ® layer.close(index);//å ³éå¼¹çª } }) } //#endregion //#region æ¾ç¤ºåæ°æ® function DisPlay_HideColumn() { $.ajax({ url: GetWEBURL() + '/Xt_grdAlignment_WMES/grdAlignmentWMESList', type: "GET", data: { "HModName": HModName, "user": sessionStorage["HUserName"] }, success: function (data1) { if (data1.data.length != 0) { var dataCol = [];//æ°æ®åºæ¥è¯¢åºçåæ°æ® //var titleData = ["åæ®ID", "HMouldID", "hsubid", "HManagerID", "æºå主å ç ", "æºååå ç "];//ä¸éè¦æ¾ç¤ºçåæ®µ 坿©å± dataCol = data1.data[0].HGridString.split(','); for (var i = 0; i < option.cols[0].length - 1; i++) { var dataCols = dataCol[i].split('|'); //éèå if (dataCols[1] == 1) { option.cols[0][i + 1]["hide"] = true; } //设置å宽 if (dataCols[3] > 0) { option.cols[0][i + 1]["width"] = dataCols[3]; } //设置å 容åä½å¤§å° if (data1.data[0].HFontSize != 0) { option.cols[0][i + 1]["style"] = "font-size:" + data1.data[0].HFontSize + "px;"; } else { option.cols[0][i + 1]["style"] = "font-size:100%"; } //设置å宽 //if (data1.data[0].HColumnWidth != 0) { // option.cols[0][i + 1]["width"] = data1.data[0].HColumnWidth + "px;"; //} else { // option.cols[0][i + 1]["width"] = ""; //} //æ¾ç¤ºå if (dataCols[1] == 0 && $.inArray(option.cols[0][i + 1]["title"], titleData) == -1) { option.cols[0][i + 1]["hide"] = false; } //å使å¨ä½ç½®(å·¦ å± ä¸ å³) switch (dataCols[2]) { case "L": option.cols[0][i + 1]["align"] = "left"; break; case "M": option.cols[0][i + 1]["align"] = "center"; break; case "R": option.cols[0][i + 1]["align"] = "right"; break; } } //åæ¶å»ç»å for (var i = 1; i < option.cols[0].length - 1; i++) { if (option.cols[0][i]["fixed"] != null) { option.cols[0][i]["fixed"] = null; } else { break; } } //å»ç»å if (data1.data[0].HFixCols != 0) { for (var i = 0; i < data1.data[0].HFixCols; i++) { if ($.inArray(option.cols[0][i + 1]["title"], titleData) != -1) { data1.data[0].HFixCols += 1; } option.cols[0][i + 1]["fixed"] = "left"; } } table.render(option); } else { table.render(option); } }, error: function () { layer.alert("æ¥å£è¯·æ±å¤±è´¥!", { icon: 5 }); } }) } //#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(); $("#ColName1").empty(); $("#ColName2").empty(); $("#ColName").append(Organization); $("#ColName1").append(Organization); $("#ColName2").append(Organization); form.render('select'); } //#endregion //#region æéå¤å® function set_ModCheck(ModRightNameCheck) { var Permission = false; $.ajax({ type: "GET", url: GetWEBURL() + "/LMES/getReportByModRightNameCheck", //æ¹æ³æå¨é¡µé¢åæ¹æ³å async: false, data: { "ModRightNameCheck": ModRightNameCheck, "user": sessionStorage["HUserName"] }, success: function (result) { if (result.count == 1) { Permission = true; } else { //layer.alert("å½åæ¨¡åæ²¡ææ¥è¯¢æé!", { icon: 5 }); } }, error: function (e) { layer.alert("æ¥å£è¯·æ±å¤±è´¥!", { icon: 5 }); } }); return Permission; } //#endregion //#region æ ¹æ®ç¨æ·è·åç¨æ·å ³è客æ·çè¿æ»¤æ¡ä»¶ function getSWhereByHUser() { var res = ""; $.ajax({ type: "GET", async: false, url: GetWEBURL() + "/Xs_SeOrderBill/getCusIDListByUser", //æ¹æ³æå¨é¡µé¢åæ¹æ³å data: { "CurUserID": sessionStorage["Czybm"], "CurUserName": sessionStorage["HUserName"] }, success: function (result) { if (result.count == 1) { res = result.data; } else { res = result.data; layer.alert(result.code + result.Message, { icon: 5 }); } }, error: function (err) { res = " and 1 = 0"; layer.alert("æ¥å£è¯·æ±å¤±è´¥!", { icon: 5 }); } }); //res = res.replace("HCusID", "客æ·å ç "); //res = res.replaceAll("'", "''"); return res; } //#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 //以䏿¯layui模å </script> </body> </html> WebTM/views/Ó¦ÊÕ¹ÜÀí/±¨±í·ÖÎö/Xs_CusShouGongChaoBaoReport.html
New file @@ -0,0 +1,1049 @@ <!DOCTYPE html> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>å®¢æ·æå·¥æå æ¥è¡¨</title> <meta name="renderer" content="webkit"> <meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1"> <meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1"> <link rel="stylesheet" href="../../../layuiadmin/layui/css/layui.css" media="all"> <link rel="stylesheet" href="../../../layuiadmin/style/admin.css" media="all"> <script src="../../../layuiadmin/layui/layui.js"></script> <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/PubCustom.js"></script> <script src="../../../layuiadmin/zgqCustom/zgqCustom.js"></script> <script src="../../../layuiadmin/HideButton.js"></script> </head> <body> <div class="layui-fluid"> <div class="layui-col-md12"> <div class="layui-card" style="padding: 1px"> <div class="layui-card-body" style="padding: 1px;"> <form class="layui-form" action="" lay-filter="component-form-group"> <div class="layui-collapse"> <div class="layui-colla-item"> <div class="layui-colla-title layui-inline"> <div class="layui-inline"> <span>æ´å¤</span> </div> </div> <div class="layui-inline"> <label class="layui-form-label">å¼å§æ¥æ</label> <div class="layui-input-block"> <input type="date" class="layui-input ForFilteringSchemes" 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 ForFilteringSchemes" id="HDate1" style="width:190px;"> </div> </div> <div class="layui-inline"> <label class="layui-form-label">客æ·</label> <div class="layui-input-block"> <input type="text" class="layui-input ForFilteringSchemes" name="HCusName" id="HCusName" style="width:190px;"> </div> </div> <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" class="ForFilteringSchemes" lay-verify="HOrgID"> <!--å¨ææ¸²æç»ç»--> </select> </div> </div> <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnSearch" id="btnSearch"> <i class="layui-icon layui-icon-search layuiadmin-button-btn"></i> </button> <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnReSearch" id="btnReSearch" style="padding:0 5px">éç½®</button> <div class="layui-row"> <!--æ¾ç¤ºå½åè¿æ»¤æ¹æ¡--> <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> <div class="layui-colla-content"> <div class="layui-inline"> <div class="layui-inline"> <span>å ¶ä»æ¡ä»¶></span> </div> </div> <div class="layui-inline"> <label class="layui-form-label">ç©æä»£ç </label> <div class="layui-input-block"> <input type="text" class="layui-input ForFilteringSchemes" name="HMaterNumber" id="HMaterNumber" style="width:190px;"> </div> </div> <div class="layui-inline"> <label class="layui-form-label">ç©æåç§°</label> <div class="layui-input-block"> <input type="text" class="layui-input ForFilteringSchemes" name="HMaterName" id="HMaterName" style="width:190px;"> </div> </div> </div> <div class="layui-colla-content" style="padding: 0px; margin-left: 6%;"> <div class="layui-row" style="margin-top:5px"> <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-top: 10px; margin-left: 70px;"> <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> <table class="" id="mainTable" lay-filter="mainTable"></table> <script type="text/html" id="toolbarDemo"> <div class="layui-btn-container"> <button type="button" class="layui-btn layui-btn-sm" lay-event="get_Refresh" id="get_Refresh"><i class="layui-icon layui-icon-refresh-3"></i>å·æ°</button> <button type="button" class="layui-btn layui-btn-sm" lay-event="set_HideColumn" id="set_HideColumn"><i class="layui-icon layui-icon-form"></i>å设置</button> <button type="button" class="layui-btn layui-btn-sm" lay-event="HideButton" id="HideButton"><i class="layui-icon layui-icon-form"></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> <button type="button" class="layui-btn layui-btn-sm" lay-event="get_export" id="get_export"><i class="layui-icon layui-icon-export"></i>导åº</button> <button type="button" class="layui-btn layui-btn-sm" lay-event="get_Exit" id="get_Exit"><i class="layui-icon layui-icon-logout"></i>éåº</button> </div> </script> </form> </div> </div> </div> </div> <script> layui.config({ base: '../../../layuiadmin/' //éæèµæºæå¨è·¯å¾ }).extend({ index: 'lib/index', //ä¸»å ¥å£æ¨¡å }).use(['index', 'form', 'table', 'element', 'laypage', 'laydate'], function () { //#region å ¬ç¨åé var $ = layui.$ , admin = layui.admin , layer = layui.layer , table = layui.table , form = layui.form , element = layui.element , laypage = layui.laypage , laydate = layui.laydate var option = []; var sWhere = ""; var HModName = "Xs_CusShouGongChaoBaoReport"; //ä¸éè¦æ¾ç¤ºçåæ®µ 坿©å± var titleData = []; var ins; //ç¨äºå¯¼åºexcel //#endregion //#region ãè¿æ»¤æ¹æ¡ã //è¿æ»¤æ¡ä»¶çclassç±» var HClassTag = "ForFilteringSchemes"; //模ååç§°ï¼ä¸æçï¼ æ¯ä¸ªæ¨¡å页é¢é½éè¦ä¿®æ¹ window.HModuleName = "å®¢æ·æå·¥æå æ¥è¡¨"; //æ¯å¦å·²ç»éæ©äºè¿æ»¤æ¹æ¡ï¼å ¨å±åéï¼ window.HDefaultFilter = ""; //éæ©çè¿æ»¤æ¹æ¡å ç ï¼å ¨å±åéï¼ window.HInterID_Choose = 0; //#endregion //#region è¿å ¥é¡µé¢å³å è½½ //è·åç»ç» Organ(); //åå§åçé¢ set_ClearBill(); //#endregion //#region 触åäºä»¶ï¼å æ¬form.on(){}æ ¼å¼çææç¹å»äºä»¶ãéæ©äºä»¶ç //#region å¤´å·¥å ·æ äºä»¶ table.on('toolbar(mainTable)', function (obj) { switch (obj.event) { //导åºexcel case 'get_export': get_Export(); break; //å·æ° case 'get_Refresh': get_Refresh(); break; //éåºæé® case 'get_Exit': Pub_Close(2); break; //å设置 case 'set_HideColumn': get_HideColumn(); break; //æé®è®¾ç½® case 'HideButton': var btns = document.getElementsByTagName("button"); //è·åæ¬é¡µæææé®å¯¹è±¡ var HBillType = "Xs_CusShouGongChaoBaoReport"; get_HideButton(btns, HBillType, HModName, sessionStorage["HUserName"]); break; //ä¿åæ¹æ¡ case 'set_SaveScheme': set_SaveScheme(); break; //è¯»åæ¹æ¡ case 'set_ReadScheme': set_ReadScheme(); break; }; }); //#endregion //#region ç¹å»è¡éä¸é«äº® table.on('row(mainTable)', function (obj) { //éä¸è¡æ¹åé¢è² var flag = !obj.tr.find(':checkbox:first').prop('checked'); obj.tr.find(':checkbox').prop('checked', flag); if (flag) { obj.tr.find('.layui-form-checkbox').addClass('layui-form-checked'); //设置å¤éæ¡é䏿 ·å¼ $(obj.tr.selector).attr({ "style": "background:#ceedfa;color:black" });//æ¹åå½åtrèæ¯é¢è²ååä½é¢è² } else { obj.tr.find('.layui-form-checkbox').removeClass('layui-form-checked');//åæ¶å¤éæ¡é䏿 ·å¼ $(obj.tr.selector).attr({ "style": "background:" });//åæ¶å½åtré¢è² } //mainTable ä¸ºè¡¨æ ¼ID æ³¨ææ¤å¤å¦æID䏿£ç¡®å°å¯¼è´ä½ å¨çå¬å¤éæ¡æ¶è·åä¸å°ä½ éæ©çæ°æ®ï¼åé¢çåªæ¯æ·»å æå é¤é䏿ªé䏿 ·å¼ä»¥åè®¾ç½®èæ¯è²ï¼åä½é¢è² layui.each(table.cache.mainTable, function (i, l) { if (obj.tr.index() == l.LAY_TABLE_INDEX) { l.LAY_CHECKED = flag; } }); }) //#endregion //#region éç½®æé® form.on('submit(btnReSearch)', function (data) { set_ClearQuery(); }); //#endregion //#region æ¥è¯¢æé® form.on('submit(btnSearch)', function (data) { get_FastQuery(2); }); //#endregion //#region æ¬é¡µé¢ææè¢«è°ç¨çæ¹æ³ //#region åå§åçé¢ function set_ClearBill() { //æ ¹æ®æ¥æé´é设置å¼å§æ¶é´ä¸ç»ææ¶é´ $("#HDate").val(Format(new Date(new Date() - 1000 * 60 * 60 * 24 * 7), "yyyy-MM-dd")); $("#HDate1").val(Format(new Date(), "yyyy-MM-dd")); //åå§åè¡¨æ ¼ set_InitGrid(); //æ¥è¯¢ get_FastQuery(1); //æ¥è¯¢å½åç»å½ç¨æ·ææ²¡æå¨å½å模å设置é»è®¤è¿æ»¤æ¹æ¡ get_DefaultModule(); } //#endregion //#region åå§åè¡¨æ ¼æ¹æ³ function set_InitGrid() { option = { elem: '#mainTable' , toolbar: '#toolbarDemo' , height: 'full-50' , page: true , totalRow: true //, cellMinWidth: 90 , limit: 50 , limits: [50, 500, 5000, 20000] }; } //#endregion //#endregion //#region æ¥è¯¢ function get_Display(sql) { var ajaxLoad = layer.load(); var ModRightNameCheck = "Xs_CusShouGongChaoBaoReport"; $.ajax({ url: GetWEBURL() + '/CommonModel/searchMethod', type: "GET", async:false, data: { "sql": sql, "user": sessionStorage["HUserName"], "ModRightNameCheck": ModRightNameCheck}, success: function (data1) { if (data1.count == 1) { var totalArray = []; var data = []; var col = []; //ç»ç©ºçæ°ç»èµå¼ col.push({ type: 'checkbox', fixed: 'left', totalRowText: 'å计' }); for (var key in data1.list) { data.push({ "id": data1.list[key].ColmCols, "name": data1.list[key].ColmCols, "Type": data1.list[key].ColmType }); } //å¨å表左边添å å¾éæ¡ //col.push({ type: 'checkbox', fixed: 'left' }); for (var i = 0; i < data.length; i++) { // if (data[i].name == 'HInterID' || data[i].name == 'HBillType' || data[i].name == 'hmainid') { if ($.inArray(data[i].name, titleData) > -1) { col.push({ field: data[i].id, title: data[i].name, align: 'center', hide: true }); //éèidå } else if ($.inArray(data[i].name, totalArray) > -1) { col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, totalRow: true, width: 120 }); } else { switch (data[i].Type) { //int 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:120 }); break; default: col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, width: 120 }); } } } option.cols = [col]; option.data = data1.data; ins = table.render(option); //å·æ°æé®æ¾ç¤º var btns = document.getElementsByTagName("button"); //è·åæ¬é¡µæææé®å¯¹è±¡ var HBillType = "Xs_CusShouGongChaoBaoReport"; Display_HideButton(btns, HBillType, HModName, sessionStorage["HUserName"]); //å·æ°è¡¨æ ¼æ°æ® DisPlay_HideColumn(); layer.close(ajaxLoad); if ($("#Comparator").val() == 0 && $("#ColContent").val() == "" && $("#Comparator1").val() == 0 && $("#ColContent1").val() == "" && $("#Comparator2").val() == 0 && $("#ColContent2").val() == "") { ColFilter(); } //layer.alert("æ¥è¯¢æå", { icon: 1 }); } else { layer.close(ajaxLoad); layer.alert(data1.code + data1.Message, { icon: 5 }); } }, error: function () { layer.close(ajaxLoad); layer.alert("æ¥å£è¯·æ±å¤±è´¥!", { icon: 5 }); } }); } //#endregion //#region å¿«éè¿æ»¤ function get_FastQuery(number) { var HDate = $("#HDate").val();//å¼å§æ¥æ var HDate1 = $("#HDate1").val();//ç»ææ¥æ var HCusName = $("#HCusName").val(); var HMaterNumber = $("#HMaterNumber").val(); var HMaterName = $("#HMaterName").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 = "" + Comparator2 + "'" + ColContent2 + "'"; break; } sWhere += " and " + ColName2 + " " + com2; } HOrgID = $("#HOrgID").val();//ç»ç» if (HDate) { sWhere += " and CONVERT(varchar(100),æ¥æ, 20) >= '" + HDate + "'"; } if (HDate1) { sWhere += " and CONVERT(varchar(100),æ¥æ, 20) <= '" + HDate1 + "'"; } if (HCusName) { sWhere += " and å®¢æ· like '%" + HCusName + "%'"; } if (HMaterNumber) { sWhere += " and ç©æä»£ç like '%" + HMaterNumber + "%'"; } if (HMaterName) { sWhere += " and ç©æåç§° like '%" + HMaterName + "%'"; } //æ ¹æ®ç¨æ·è¿æ»¤ç¨æ·å ³è客æ·çè®°å½ sWhere += getSWhereByHUser(); var sql = "select * from h_v_Xs_CusShouGongChaoBaoReport where 1=1 " + sWhere + " order by æ¥æ desc,HCusID,HMaterID"; get_Display(sql); sWhere = "";//è°ç¨æ¥å£åæ¸ ç©ºsWhereç¼å } //#endregion //#region éç½®è¿æ»¤æ¡ä»¶æ¹æ³ function set_ClearQuery() { //æ ¹æ®æ¥æé´é设置å¼å§æ¶é´ä¸ç»ææ¶é´ $("#HDate").val(Format(new Date(new Date() - 1000 * 60 * 60 * 24 * 7), "yyyy-MM-dd")); $("#HDate1").val(Format(new Date(), "yyyy-MM-dd")); $("#HCusName").val("");// $("#HMatrNumber").val(""); $("#HMaterName").val(""); $("#HOrgID").val(sessionStorage["OrganizationID"]); $("#ColContent").val(""); $("#ColName").val("0"); $("#Comparator").val("0"); $("#ColContent1").val(""); $("#ColName1").val("0"); $("#Comparator1").val("0"); $("#ColContent2").val(""); $("#ColName2").val("0"); $("#Comparator2").val("0"); form.render('select'); sWhere = ""; } //#endregion //#region 导åºExecel function get_Export() { var ModRightNameCheck = "Xs_CusShouGongChaoBaoReport_ExportExcel"; //é»è¾å®¡æ ¸æ¹æ³ $.ajax({ type: "GET", url: GetWEBURL() + "/LMES/getReportByModRightNameCheck", //æ¹æ³æå¨é¡µé¢åæ¹æ³å data: { "ModRightNameCheck": ModRightNameCheck, "user": sessionStorage["HUserName"] }, success: function (result) { if (result.count == 1) { var data = option.data; data.forEach((item) => { for (let itemobj in item) { if (item[itemobj] == null) { item[itemobj] = ""; } if (item[itemobj].length > 0) { // åè®¾åæ®µå为field item[itemobj] = item[itemobj].toString().replaceAll(/[\r\n]+/g, ''); // å°æ¢è¡ç¬¦æ¿æ¢ä¸ºç©ºå符串 item[itemobj] = item[itemobj].toString().replaceAll(/[,]+/g, 'ï¼'); // å°æ¢åå·æ¿æ¢ä¸ºç©ºå符串 } } }); table.exportFile(ins.config.id,data, "xls"); } else { layer.alert("å½åæ¨¡åæ²¡æå¯¼åºæé!", { icon: 5 }); } }, error: function () { layer.alert("æ¥å£è¯·æ±å¤±è´¥!", { icon: 5 }); } }); } //#endregion //#region å·æ° function get_Refresh() { $("#btnSearch").trigger('click'); } //#endregion //#region è·åç»ç» function Organ() { //è·åç»å½é¡µç»ç»å $.ajax({ type: "get", url: GetWEBURL() + "/Web/GetOrganizations", success: function (result) { var Organization = ""; 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>'; } $("#HOrgID").append(Organization); $("#HOrgID").val(sessionStorage["OrganizationID"]) form.render('select'); } layer.closeAll("loading"); } }) } //#endregion //#region éèå设置 function get_HideColumn() { var colName = ""; var contentUrl = ""; for (var i = 1; i < option.cols[0].length; i++) { colName += option.cols[0][i]["title"] + ","; } var urlStr = window.document.location.pathname;//è·åæä»¶è·¯å¾ var urlLen = urlStr.split('/'); for (var i = 0; i < urlLen.length - 4; i++) { contentUrl += "../"; } colName = encodeURI(colName.substring(0, colName.length - 1));//对 URI è¿è¡ç¼ç contentUrl += 'åºç¡èµæ/éèå设置/Gy_GridView_Hide.html?HModName=' + HModName + '&colName=' + colName; layer.open({ type: 2 , skin: "layui-layer-rim" //å ä¸è¾¹æ¡ , title: "éèå设置" //æ é¢ , closeBtn: 1 //çªä½å³ä¸è§å ³é ç æ ·å¼ , shift: 2 //å¼¹åºå¨ç» , area: ["50%", "90%"] //çªä½å¤§å° , maxmin: true //设置æå¤§æå°æé®æ¯å¦æ¾ç¤º , content: [contentUrl, "yes"] , btn: ["ç¡®å®", "åæ¶"] , btn1: function (index, laero) { //å·æ°è¡¨æ ¼æ°æ® DisPlay_HideColumn(); //æ´æ°è¡¨æ ¼ç¼åçæ°æ® layer.close(index);//å ³éå¼¹çª } }) } //#endregion //#region æ¾ç¤ºåæ°æ® function DisPlay_HideColumn() { $.ajax({ url: GetWEBURL() + '/Xt_grdAlignment_WMES/grdAlignmentWMESList', type: "GET", data: { "HModName": HModName, "user": sessionStorage["HUserName"] }, success: function (data1) { if (data1.data.length != 0) { var dataCol = [];//æ°æ®åºæ¥è¯¢åºçåæ°æ® //var titleData = ["åæ®ID", "HMouldID", "hsubid", "HManagerID", "æºå主å ç ", "æºååå ç "];//ä¸éè¦æ¾ç¤ºçåæ®µ 坿©å± dataCol = data1.data[0].HGridString.split(','); for (var i = 0; i < option.cols[0].length - 1; i++) { var dataCols = dataCol[i].split('|'); //éèå if (dataCols[1] == 1) { option.cols[0][i + 1]["hide"] = true; } //设置å宽 if (dataCols[3] > 0) { option.cols[0][i + 1]["width"] = dataCols[3]; } //设置å 容åä½å¤§å° if (data1.data[0].HFontSize != 0) { option.cols[0][i + 1]["style"] = "font-size:" + data1.data[0].HFontSize + "px;"; } else { option.cols[0][i + 1]["style"] = "font-size:100%"; } //设置å宽 //if (data1.data[0].HColumnWidth != 0) { // option.cols[0][i + 1]["width"] = data1.data[0].HColumnWidth + "px;"; //} else { // option.cols[0][i + 1]["width"] = ""; //} //æ¾ç¤ºå if (dataCols[1] == 0 && $.inArray(option.cols[0][i + 1]["title"], titleData) == -1) { option.cols[0][i + 1]["hide"] = false; } //å使å¨ä½ç½®(å·¦ å± ä¸ å³) switch (dataCols[2]) { case "L": option.cols[0][i + 1]["align"] = "left"; break; case "M": option.cols[0][i + 1]["align"] = "center"; break; case "R": option.cols[0][i + 1]["align"] = "right"; break; } } //åæ¶å»ç»å for (var i = 1; i < option.cols[0].length - 1; i++) { if (option.cols[0][i]["fixed"] != null) { option.cols[0][i]["fixed"] = null; } else { break; } } //å»ç»å if (data1.data[0].HFixCols != 0) { for (var i = 0; i < data1.data[0].HFixCols; i++) { if ($.inArray(option.cols[0][i + 1]["title"], titleData) != -1) { data1.data[0].HFixCols += 1; } option.cols[0][i + 1]["fixed"] = "left"; } } table.render(option); } else { table.render(option); } }, error: function () { layer.alert("æ¥å£è¯·æ±å¤±è´¥!", { icon: 5 }); } }) } //#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(); $("#ColName1").empty(); $("#ColName2").empty(); $("#ColName").append(Organization); $("#ColName1").append(Organization); $("#ColName2").append(Organization); form.render('select'); } //#endregion //#region æéå¤å® function set_ModCheck(ModRightNameCheck) { var Permission = false; $.ajax({ type: "GET", url: GetWEBURL() + "/LMES/getReportByModRightNameCheck", //æ¹æ³æå¨é¡µé¢åæ¹æ³å async: false, data: { "ModRightNameCheck": ModRightNameCheck, "user": sessionStorage["HUserName"] }, success: function (result) { if (result.count == 1) { Permission = true; } else { //layer.alert("å½åæ¨¡åæ²¡ææ¥è¯¢æé!", { icon: 5 }); } }, error: function (e) { layer.alert("æ¥å£è¯·æ±å¤±è´¥!", { icon: 5 }); } }); return Permission; } //#endregion //#region æ ¹æ®ç¨æ·è·åç¨æ·å ³è客æ·çè¿æ»¤æ¡ä»¶ function getSWhereByHUser() { var res = ""; $.ajax({ type: "GET", async: false, url: GetWEBURL() + "/Xs_SeOrderBill/getCusIDListByUser", //æ¹æ³æå¨é¡µé¢åæ¹æ³å data: { "CurUserID": sessionStorage["Czybm"], "CurUserName": sessionStorage["HUserName"] }, success: function (result) { if (result.count == 1) { res = result.data; } else { res = result.data; layer.alert(result.code + result.Message, { icon: 5 }); } }, error: function (err) { res = " and 1 = 0"; layer.alert("æ¥å£è¯·æ±å¤±è´¥!", { icon: 5 }); } }); //res = res.replace("HCusID", "客æ·å ç "); //res = res.replaceAll("'", "''"); return res; } //#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 //以䏿¯layui模å </script> </body> </html>