| | |
| | | <script src="../../../layuiadmin/Scripts/jquery-1.4.1.js"></script> |
| | | <script src="../../../layuiadmin/Scripts/webConfig.js"></script> |
| | | <script src="../../../layuiadmin/layui/lay/modules/table.js"></script> |
| | | <script src="../../../layuiadmin/HideButton_New.js"></script> |
| | | <script src="../../../layuiadmin/SetColumn.js"></script> |
| | | <style> |
| | | /*æ ç¶å¾ç¹å»é«äº®åè²*/ |
| | | .layui-tree-set-active > .layui-tree-entry .layui-tree-main { |
| | |
| | | <input type="text" class="layui-input ForFilteringSchemes" name="HName" id="HName"> |
| | | </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="HUSEORGID" id="HUSEORGID" class="ForFilteringSchemes" lay-verify="HUSEORGID"> |
| | | <!--å¨ææ¸²æç»ç»--> |
| | | </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> |
| | |
| | | <!--æ¾ç¤ºå½åè¿æ»¤æ¹æ¡--> |
| | | <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-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" lay-filter="ColName" style="width:190px;" class="ForFilteringSchemes"> |
| | | </select> |
| | | </div> |
| | | </div> |
| | | <div class="layui-inline"> |
| | | <select name="Comparator" id="Comparator" lay-filter="Comparator" style="width:190px;" class="ForFilteringSchemes"> |
| | | <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:5px"> |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label">è¿æ»¤</label> |
| | | <div class="layui-input-block"> |
| | | <select name="ColName1" id="ColName1" lay-filter="ColName1" style="width:190px;" class="ForFilteringSchemes"> |
| | | </select> |
| | | </div> |
| | | </div> |
| | | <div class="layui-inline"> |
| | | <select name="Comparator1" id="Comparator1" lay-filter="Comparator1" style="width:190px;" class="ForFilteringSchemes"> |
| | | <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:5px"> |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label">è¿æ»¤</label> |
| | | <div class="layui-input-block"> |
| | | <select name="ColName2" id="ColName2" lay-filter="ColName2" style="width:190px;" class="ForFilteringSchemes"> |
| | | </select> |
| | | </div> |
| | | </div> |
| | | <div class="layui-inline"> |
| | | <select name="Comparator2" id="Comparator2" lay-filter="Comparator2" style="width:190px;" class="ForFilteringSchemes"> |
| | | <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> |
| | | </div> |
| | | <script type="text/html" id="toolbarDemo"> |
| | | <div class="layui-btn-container"> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="btnAdd"><i class="layui-icon layui-icon-add-1"></i>æ°å¢</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="btnModify"><i class="layui-icon layui-icon-edit"></i>ç¼è¾</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="btndelete"><i class="layui-icon layui-icon-delete"></i>å é¤</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-view"><i class="layui-icon layui-icon-tips"></i>é¢è§</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-print"><i class="layui-icon layui-icon-print"></i>æå°</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="set_CheckBill" id="CheckBill"><i class="layui-icon layui-icon-form"></i>å®¡æ ¸</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="set_AbandonCheck" id="AbandonCheck"><i class="layui-icon layui-icon-form"></i>åå®¡æ ¸</button> |
| | | <div class="layui-btn-container" id="toolbarDemo_ButtonSet"> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="set_SouceExcel" id="set_SouceExcel"><i class="layui-icon layui-icon-delete"></i>导å
¥</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="btn_Export" id="btn_Export"><i class="layui-icon layui-icon-export"></i>导åº</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="btnAdd" id="btnAdd"><i class="layui-icon layui-icon-add-1"></i>æ°å¢</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="btn_Copy" id="btn_Copy"><i class="layui-icon layui-icon-add-1"></i>å¤å¶</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="btnModify" id="btnModify"><i class="layui-icon layui-icon-edit"></i>ç¼è¾</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="btndelete" id="btndelete"><i class="layui-icon layui-icon-delete"></i>å é¤</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="set_CheckBill" id="set_CheckBill"><i class="layui-icon layui-icon-form"></i>å®¡æ ¸</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="set_AbandonCheck" id="set_AbandonCheck"><i class="layui-icon layui-icon-form"></i>åå®¡æ ¸</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="btn_Delete" id="btn_Delete"><i class="layui-icon layui-icon-radio"></i>ä½åº</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="btn_UnDelete" id="btn_UnDelete"><i class="layui-icon layui-icon-radio"></i>åä½åº</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="set_CloseBill" id="set_CloseBill"><i class="layui-icon layui-icon-form"></i>å
³é</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="set_CancelCloseBill" id="set_CancelCloseBill"><i class="layui-icon layui-icon-form"></i>åå
³é</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="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="set_HideButton" id="set_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_Exit"><i class="layui-icon layui-icon-logout"></i>éåº</button> |
| | | <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="get_Exit" id="get_Exit"><i class="layui-icon layui-icon-logout"></i>éåº</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-view" id="btn-view"><i class="layui-icon layui-icon-tips"></i>é¢è§</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-print" id="btn-print"><i class="layui-icon layui-icon-print"></i>æå°</button> |
| | | </div> |
| | | </script> |
| | | </form> |
| | |
| | | , tree = layui.tree |
| | | var sWhere = ""; |
| | | var option = []; |
| | | var titleData = ["hmainid", "HMaterID", "HUnitID", "HDeptID", "HEquipDotCheckRuleInterID", "HEquipMaintainRuleInterID", "HEquipFileTypeID","HBillType", "HUseEmpID", "HRepairEmpID", "HSellSupID", "HMakeSupID", "HMainSourceID", "HSourceID", "HSourceName"]; |
| | | //#endregion |
| | | //#region ãè¿æ»¤æ¹æ¡ã |
| | | |
| | | var HModName = "Gy_EquipFileMainList"; |
| | | var HBillType = "3308"; |
| | | var ins; //ç¨äºå¯¼åºexcel |
| | | var set_HideButton_ID = "toolbarDemo_ButtonSet"; //éè¦è®¾ç½®çæé®çç¶çº§èç¹çid |
| | | //è¿æ»¤æ¡ä»¶çclassç±» |
| | | var HClassTag = "ForFilteringSchemes"; |
| | | //模ååç§°ï¼ä¸æçï¼ æ¯ä¸ªæ¨¡å页é¢é½éè¦ä¿®æ¹ |
| | |
| | | //ç¼è¾æé® |
| | | case 'btnModify': set_ShowBill(); |
| | | break; |
| | | //å设置 |
| | | case 'set_HideColumn': get_HideColumnNoPage(HModName, sessionStorage["HUserName"], option, get_FastQuery); |
| | | break; |
| | | //æé®è®¾ç½® |
| | | case 'set_HideButton': |
| | | get_HideButton(set_HideButton_ID, HBillType, HModName, sessionStorage["HUserName"]); |
| | | break; |
| | | //é¢è§ |
| | | case 'btn-view': get_ViewReport(); |
| | | break; |
| | | //导å
¥ |
| | | case 'set_SouceExcel': set_SouceExcel(); |
| | | break; |
| | | //å¯¼åºæé® |
| | | case 'btn_Export': btn_Export(); |
| | | break; |
| | | //å¤å¶ |
| | | case 'btn_Copy': |
| | | set_copy(); |
| | | break; |
| | | //æå° |
| | | case 'btn-print': get_PrintReport(); |
| | |
| | | break; |
| | | //åå
³é |
| | | case 'set_CancelCloseBill': set_CloseBill(2); |
| | | break; |
| | | //ä½åº |
| | | case 'btn_Delete': btn_Delete(1); |
| | | break; |
| | | //åä½åº |
| | | case 'btn_UnDelete': btn_Delete(2); |
| | | break; |
| | | //å·æ° |
| | | case 'get_Refresh': get_Refresh(); |
| | |
| | | |
| | | //åå§åè¡¨æ ¼ |
| | | function set_ClearBill() { |
| | | set_StockOrg(); |
| | | //åå§åè¡¨æ ¼ |
| | | set_InitGrid(); |
| | | |
| | |
| | | |
| | | get_DefaultModule(); |
| | | } |
| | | |
| | | //#region 导åºExecel |
| | | function btn_Export() { |
| | | table.exportFile(ins.config.id, option.data, "xls"); |
| | | } |
| | | //#endregion |
| | | |
| | | //åå§åè¡¨æ ¼ |
| | | function set_InitGrid() |
| | |
| | | , done: function (res, curr, count) { |
| | | soulTable.render(this); |
| | | } |
| | | , cols: [[ |
| | | { type: 'checkbox', fixed: 'left', totalRowText: 'å计è¡' } |
| | | , { field: 'hmainid', title: 'hmainid', sort: true, hide: true } |
| | | , { field: 'æ¥æ', title: 'æ¥æ', templet: "<div>{{d.æ¥æ ==null ?'':layui.util.toDateString(d.æ¥æ, 'yyyy-MM-dd')}}</div>", sort: true } |
| | | , { field: 'æ¡å½¢ç ', title: 'æ¡ç ç¼å·', sort: true } |
| | | , { field: 'HMaterID', title: 'HMaterID', hide: true, sort: true } |
| | | , { field: 'ç©æåç§°', title: 'ç©æåç§°', sort: true } |
| | | , { field: '设å¤ä»£ç ', title: '设å¤ä»£ç ', sort: true } |
| | | , { field: '设å¤ç¼ç ', title: '设å¤ç¼ç ', sort: true } |
| | | , { field: '设å¤åç§°', title: '设å¤åç§°', sort: true } |
| | | , { field: '设å¤è§æ ¼', title: '设å¤è§æ ¼', sort: true } |
| | | , { field: '设å¤åå·', title: '设å¤åå·', sort: true } |
| | | , { field: 'HUnitID', title: 'HUnitID', hide: true, sort: true } |
| | | , { field: 'åä½', title: 'åä½', sort: true } |
| | | , { field: '设å¤åºåæ¥æ', title: '设å¤åºåæ¥æ', templet: "<div>{{d.设å¤åºåæ¥æ ==null ?'':layui.util.toDateString(d.设å¤åºåæ¥æ, 'yyyy-MM-dd')}}</div>", sort: true } |
| | | , { field: '设å¤åºåç¼å·', title: '设å¤åºåç¼å·', sort: true } |
| | | , { field: 'HDeptID', title: 'HDeptID', hide: true, sort: true } |
| | | , { field: '使ç¨é¨é¨', title: '使ç¨é¨é¨', sort: true } |
| | | , { field: 'HUseEmpID', title: 'HUseEmpID', hide: true, sort: true } |
| | | , { field: '使ç¨è´è´£äºº', title: '使ç¨è´è´£äºº', sort: true } |
| | | , { field: 'HRepairEmpID', title: 'HRepairEmpID', hide: true, sort: true } |
| | | , { field: 'ç»´æ¤è´è´£äºº', title: 'ç»´æ¤è´è´£äºº', sort: true } |
| | | , { field: 'å®è£
å°ç¹', title: 'å®è£
å°ç¹', sort: true } |
| | | , { field: 'å®è£
æ¥æ', title: 'å®è£
æ¥æ', templet: "<div>{{d.å®è£
æ¥æ ==null ?'':layui.util.toDateString(d.å®è£
æ¥æ, 'yyyy-MM-dd')}}</div>", sort: true } |
| | | , { field: 'è¿è¡å¼å§æ¥æ', title: 'è¿è¡å¼å§æ¥æ', templet: "<div>{{d.è¿è¡å¼å§æ¥æ ==null ?'':layui.util.toDateString(d.è¿è¡å¼å§æ¥æ, 'yyyy-MM-dd')}}</div>", sort: true } |
| | | , { field: 'å½åç¶æ', title: 'å½åç¶æ', sort: true } |
| | | , { field: 'HEquipFileTypeID', title: 'HEquipFileTypeID', hide: true, sort: true } |
| | | , { field: '设å¤ç±»å', title: '设å¤ç±»å', sort: true } |
| | | , { field: 'å·¥ç¨ç¼ç ', title: 'å·¥ç¨ç¼ç ', sort: true } |
| | | , { field: '产å', title: '产å', sort: true } |
| | | , { field: 'åç', title: 'åç', sort: true } |
| | | , { field: 'HSellSupID', title: 'HSellSupID', hide: true, sort: true } |
| | | , { field: 'ä¾åºå', title: 'ä¾åºå', sort: true } |
| | | , { field: 'HMakeSupID', title: 'HMakeSupID', hide: true, sort: true } |
| | | , { field: 'å¶é å', title: 'å¶é å', sort: true } |
| | | , { field: 'å¶å人', title: 'å¶å人', sort: true } |
| | | , { field: 'å¶åæ¥æ', title: 'å¶åæ¥æ', templet: "<div>{{d.å¶åæ¥æ ==null ?'':layui.util.toDateString(d.å¶åæ¥æ, 'yyyy-MM-dd')}}</div>", sort: true } |
| | | , { field: 'å®¡æ ¸äºº', title: 'å®¡æ ¸äºº', sort: true } |
| | | , { field: 'å®¡æ ¸æ¥æ', title: 'å®¡æ ¸æ¥æ', templet: "<div>{{d.å®¡æ ¸æ¥æ ==null ?'':layui.util.toDateString(d.å®¡æ ¸æ¥æ, 'yyyy-MM-dd')}}</div>", sort: true } |
| | | , { field: 'ä¿®æ¹äºº', title: 'ä¿®æ¹äºº', sort: true } |
| | | , { field: 'ä¿®æ¹æ¥æ', title: 'ä¿®æ¹æ¥æ', templet: "<div>{{d.ä¿®æ¹æ¥æ ==null ?'':layui.util.toDateString(d.ä¿®æ¹æ¥æ, 'yyyy-MM-dd')}}</div>", sort: true } |
| | | , { field: 'å
³é人', title: 'å
³é人', sort: true } |
| | | , { field: 'å
³éæ¥æ', title: 'å
³éæ¥æ', templet: "<div>{{d.å
³éæ¥æ ==null ?'':layui.util.toDateString(d.å
³éæ¥æ, 'yyyy-MM-dd')}}</div>", sort: true } |
| | | , { field: 'hbilltype', title: 'hbilltype', hide: true, sort: true } |
| | | , { field: 'åæ®å·', title: 'åæ®å·', sort: true } |
| | | , { field: 'åæ®ç±»å', title: 'åæ®ç±»å', sort: true } |
| | | , { field: 'HMoudType', title: 'HMoudType', hide: true, sort: true } |
| | | , { field: 'hsubid', title: 'hsubid', hide: true, sort: true } |
| | | ]] |
| | | //, cols: [[ |
| | | // { type: 'checkbox', fixed: 'left', totalRowText: 'å计è¡' } |
| | | // , { field: 'hmainid', title: 'hmainid', sort: true, hide: true } |
| | | // , { field: 'æ¥æ', title: 'æ¥æ', templet: "<div>{{d.æ¥æ ==null ?'':layui.util.toDateString(d.æ¥æ, 'yyyy-MM-dd')}}</div>", sort: true } |
| | | // , { field: 'æ¡å½¢ç ', title: 'æ¡ç ç¼å·', sort: true } |
| | | // , { field: 'HMaterID', title: 'HMaterID', hide: true, sort: true } |
| | | // , { field: 'ç©æåç§°', title: 'ç©æåç§°', sort: true } |
| | | // , { field: '设å¤ä»£ç ', title: '设å¤ä»£ç ', sort: true } |
| | | // , { field: '设å¤ç¼ç ', title: '设å¤ç¼ç ', sort: true } |
| | | // , { field: '设å¤åç§°', title: '设å¤åç§°', sort: true } |
| | | // , { field: '设å¤è§æ ¼', title: '设å¤è§æ ¼', sort: true } |
| | | // , { field: '设å¤åå·', title: '设å¤åå·', sort: true } |
| | | // , { field: 'HUnitID', title: 'HUnitID', hide: true, sort: true } |
| | | // , { field: 'åä½', title: 'åä½', sort: true } |
| | | // , { field: '设å¤åºåæ¥æ', title: '设å¤åºåæ¥æ', templet: "<div>{{d.设å¤åºåæ¥æ ==null ?'':layui.util.toDateString(d.设å¤åºåæ¥æ, 'yyyy-MM-dd')}}</div>", sort: true } |
| | | // , { field: '设å¤åºåç¼å·', title: '设å¤åºåç¼å·', sort: true } |
| | | // , { field: 'HDeptID', title: 'HDeptID', hide: true, sort: true } |
| | | // , { field: '使ç¨é¨é¨', title: '使ç¨é¨é¨', sort: true } |
| | | // , { field: 'HUseEmpID', title: 'HUseEmpID', hide: true, sort: true } |
| | | // , { field: '使ç¨è´è´£äºº', title: '使ç¨è´è´£äºº', sort: true } |
| | | // , { field: 'HRepairEmpID', title: 'HRepairEmpID', hide: true, sort: true } |
| | | // , { field: 'ç»´æ¤è´è´£äºº', title: 'ç»´æ¤è´è´£äºº', sort: true } |
| | | // , { field: 'å®è£
å°ç¹', title: 'å®è£
å°ç¹', sort: true } |
| | | // , { field: 'å®è£
æ¥æ', title: 'å®è£
æ¥æ', templet: "<div>{{d.å®è£
æ¥æ ==null ?'':layui.util.toDateString(d.å®è£
æ¥æ, 'yyyy-MM-dd')}}</div>", sort: true } |
| | | // , { field: 'è¿è¡å¼å§æ¥æ', title: 'è¿è¡å¼å§æ¥æ', templet: "<div>{{d.è¿è¡å¼å§æ¥æ ==null ?'':layui.util.toDateString(d.è¿è¡å¼å§æ¥æ, 'yyyy-MM-dd')}}</div>", sort: true } |
| | | // , { field: 'å½åç¶æ', title: 'å½åç¶æ', sort: true } |
| | | // , { field: 'HEquipFileTypeID', title: 'HEquipFileTypeID', hide: true, sort: true } |
| | | // , { field: '设å¤ç±»å', title: '设å¤ç±»å', sort: true } |
| | | // , { field: 'å·¥ç¨ç¼ç ', title: 'å·¥ç¨ç¼ç ', sort: true } |
| | | // , { field: '产å', title: '产å', sort: true } |
| | | // , { field: 'åç', title: 'åç', sort: true } |
| | | // , { field: 'HSellSupID', title: 'HSellSupID', hide: true, sort: true } |
| | | // , { field: 'ä¾åºå', title: 'ä¾åºå', sort: true } |
| | | // , { field: 'HMakeSupID', title: 'HMakeSupID', hide: true, sort: true } |
| | | // , { field: 'å¶é å', title: 'å¶é å', sort: true } |
| | | // , { field: 'å¶å人', title: 'å¶å人', sort: true } |
| | | // , { field: 'å¶åæ¥æ', title: 'å¶åæ¥æ', templet: "<div>{{d.å¶åæ¥æ ==null ?'':layui.util.toDateString(d.å¶åæ¥æ, 'yyyy-MM-dd')}}</div>", sort: true } |
| | | // , { field: 'å®¡æ ¸äºº', title: 'å®¡æ ¸äºº', sort: true } |
| | | // , { field: 'å®¡æ ¸æ¥æ', title: 'å®¡æ ¸æ¥æ', templet: "<div>{{d.å®¡æ ¸æ¥æ ==null ?'':layui.util.toDateString(d.å®¡æ ¸æ¥æ, 'yyyy-MM-dd')}}</div>", sort: true } |
| | | // , { field: 'ä¿®æ¹äºº', title: 'ä¿®æ¹äºº', sort: true } |
| | | // , { field: 'ä¿®æ¹æ¥æ', title: 'ä¿®æ¹æ¥æ', templet: "<div>{{d.ä¿®æ¹æ¥æ ==null ?'':layui.util.toDateString(d.ä¿®æ¹æ¥æ, 'yyyy-MM-dd')}}</div>", sort: true } |
| | | // , { field: 'å
³é人', title: 'å
³é人', sort: true } |
| | | // , { field: 'å
³éæ¥æ', title: 'å
³éæ¥æ', templet: "<div>{{d.å
³éæ¥æ ==null ?'':layui.util.toDateString(d.å
³éæ¥æ, 'yyyy-MM-dd')}}</div>", sort: true } |
| | | // , { field: 'hbilltype', title: 'hbilltype', hide: true, sort: true } |
| | | // , { field: 'åæ®å·', title: 'åæ®å·', sort: true } |
| | | // , { field: 'åæ®ç±»å', title: 'åæ®ç±»å', sort: true } |
| | | // , { field: 'HMoudType', title: 'HMoudType', hide: true, sort: true } |
| | | // , { field: 'hsubid', title: 'hsubid', hide: true, sort: true } |
| | | //]] |
| | | }; |
| | | } |
| | | |
| | |
| | | //æ¥è¯¢ |
| | | function get_Display(sWhere) { |
| | | var index = layer.load(0, { shade: false }); |
| | | var ModRightNameSelect = 'Gy_MouldFileList'; |
| | | sWhere += addSWhereByOpenType();//æ·»å åæ®æ¨¡åéæ©åºç¡èµææ¶çè¿æ»¤æ¡ä»¶ï¼å·²å®¡æ ¸æªå
³é |
| | | //è¿å
¥é¡µé¢æ¾ç¤ºçç¼åå表 |
| | | $.ajax({ |
| | | url: GetWEBURL() + '/Gy_EquipFileMain/GetList', |
| | |
| | | data: { "sWhere": sWhere, "user": sessionStorage["HUserName"]}, |
| | | success: function (data1) { |
| | | if (data1.count == 1) { |
| | | option.data = data1.data; |
| | | var data = []; |
| | | var col = []; |
| | | var totalArray = []; |
| | | //ç»ç©ºçæ°ç»èµå¼ |
| | | 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 ($.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: false, totalRow: true, width: 120 }); |
| | | } else { |
| | | switch (data[i].Type) { |
| | | case 'DateTime': |
| | | col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: false, templet: "<div>{{d." + data[i].name + " ==null ?'':layui.util.toDateString(d." + data[i].name + ", 'yyyy-MM-dd')}}</div>", width: 120 }); |
| | | break; |
| | | case 'long': |
| | | case 'Int32': |
| | | case 'Int64': |
| | | case 'double': |
| | | case 'Decimal': |
| | | col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: false, width: 120, totalRow: true }); |
| | | break; |
| | | default: |
| | | col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: false, width: 120 }); |
| | | } |
| | | } |
| | | } |
| | | |
| | | //卿æ¾ç¤ºåå |
| | | option = { |
| | | elem: '#mainTable' |
| | | , toolbar: '#toolbarDemo' |
| | | , cols: [col] |
| | | , data: data1.data |
| | | , height: 'full-80' |
| | | , page: true |
| | | , limits: [50, 500, 5000, 20000] |
| | | , limit: 50 |
| | | , totalRow: true |
| | | , done: function (res, curr, count) { |
| | | soulTable.render(this); |
| | | } |
| | | } |
| | | ins = table.render(option); |
| | | |
| | | //å·æ°è¡¨æ ¼æ°æ® |
| | | DisPlay_HideColumn(HModName, sessionStorage["HUserName"], option, titleData); |
| | | |
| | | table.render(option); |
| | | layer.close(index); |
| | | |
| | | if ($("#ColName option").length < 1) { |
| | | ColFilter(); |
| | | } |
| | | |
| | | Display_HideButton(set_HideButton_ID, HBillType, HModName, sessionStorage["HUserName"]); |
| | | |
| | | } else { |
| | | layer.close(index); |
| | | layer.alert(data1.code + data1.Message, { icon: 5 }); |
| | |
| | | }); |
| | | } |
| | | |
| | | //#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); |
| | | $("#ColName1").empty(); |
| | | $("#ColName1").append(Organization); |
| | | $("#ColName2").empty(); |
| | | $("#ColName2").append(Organization); |
| | | form.render('select'); |
| | | } |
| | | //#endregion |
| | | |
| | | //å¿«éè¿æ»¤ |
| | | function get_FastQuery() { |
| | | var HNumber = $("#HNumber").val(); |
| | | var HName = $("#HName").val(); |
| | | var HUSEORGID = $("#HUSEORGID").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; |
| | | } |
| | | |
| | | if (HNumber) { |
| | | sWhere += " and 设å¤ä»£ç like '%" + HNumber + "%'"; |
| | | } |
| | | if (HName) { |
| | | sWhere += " and 设å¤åç§° like '%" + HName + "%'"; |
| | | } |
| | | if (HUSEORGID) { |
| | | sWhere += " and 使ç¨ç»ç»åç§° = '" + HUSEORGID + "'"; |
| | | } |
| | | get_Display(sWhere); |
| | | sWhere = "";//è°ç¨æ¥å£åæ¸
空sWhereç¼å |
| | |
| | | layer.open({ |
| | | type: 2, |
| | | skin: 'layui-layer-rim', //å ä¸è¾¹æ¡ |
| | | title: 'æ°å¢å¨å
·æ¡£æ¡å表', |
| | | title: 'æ°å¢è®¾å¤æ¡£æ¡å表', |
| | | closeBtn: false, |
| | | shift: 2, |
| | | area: ['100%', '100%'], |
| | |
| | | }); |
| | | } |
| | | |
| | | //å¤å¶ |
| | | function set_copy() { |
| | | var checkStatus = table.checkStatus('mainTable') |
| | | , data = checkStatus.data; |
| | | if (checkStatus.data.length === 1) { |
| | | var HInterID = data[0].hmainid.toString(); |
| | | layer.open({ |
| | | type: 2 |
| | | , area: ['100%', '100%'] |
| | | , title: 'ç¼è¾è®¾å¤æ¡£æ¡å表' |
| | | , shade: 0.6 //é®ç½©éæåº¦ |
| | | , maxmin: true //å
许å
¨å±æå°å |
| | | , anim: 0 //0-6çå¨ç»å½¢å¼ï¼-1ä¸å¼å¯ |
| | | , content: '../è®¾å¤æ¡£æ¡/Gy_EquipFileMainEdit.html?OperationType=2&linterid=' + HInterID |
| | | , resize: false |
| | | , cancel: function () { |
| | | |
| | | } |
| | | }) |
| | | |
| | | } else { |
| | | layer.msg('è¯·éæ©ä¸è¡æ°æ®ç¼è¾ï¼'); |
| | | } |
| | | } |
| | | |
| | | //ä¿®æ¹ |
| | | function set_ShowBill() |
| | | { |
| | |
| | | layer.open({ |
| | | type: 2 |
| | | , area: ['100%', '100%'] |
| | | , title: 'ç¼è¾å¨å
·æ¡£æ¡å表' |
| | | , title: 'ç¼è¾è®¾å¤æ¡£æ¡å表' |
| | | , shade: 0.6 //é®ç½©éæåº¦ |
| | | , maxmin: true //å
许å
¨å±æå°å |
| | | , anim: 0 //0-6çå¨ç»å½¢å¼ï¼-1ä¸å¼å¯ |
| | |
| | | layer.msg('è¯·éæ©ä¸è¡æ°æ®å é¤ï¼'); |
| | | } |
| | | } |
| | | |
| | | //导å
¥ |
| | | function set_SouceExcel() { |
| | | layer.open({ |
| | | type: 2 |
| | | , area: ['100%', '100%'] |
| | | , title: 'è®¾å¤æ¡£æ¡å¯¼å
¥' |
| | | , shift: 0//å¼¹åºå¨ç» |
| | | , content: './Gy_EquipFile_Excel.html?OperationType=dao&HSouceBillType=' |
| | | }) |
| | | } |
| | | //å®¡æ ¸/åå®¡æ ¸ |
| | | function set_CheckBill(num) { |
| | | var checkStatus = table.checkStatus('mainTable') |
| | |
| | | if (result.count == 1) { |
| | | layer.msg(result.Message, { icon: 1 }); |
| | | layer.close(wait); |
| | | get_FastQuery(); |
| | | } else { |
| | | layer.alert(result.code + result.Message, { icon: 5 }); |
| | | layer.close(wait); |
| | |
| | | else { |
| | | layer.msg("è¯·éæ©ä¸æ¡æ°æ®!"); |
| | | } |
| | | } |
| | | } |
| | | |
| | | //#region è·åç»ç» |
| | | function set_StockOrg() { |
| | | //è·åç»å½é¡µç»ç»å |
| | | $.ajax({ |
| | | type: "GET", |
| | | url: GetWEBURL() + "/Web/GetOrganizations", |
| | | async: false, //asyncç¨äºæ§å¶ï¼falseï¼åæ¥åï¼trueï¼å¼æ¥ï¼é»è®¤çæ¯trueï¼å³è¯·æ±é»è®¤çæ¯å¼æ¥è¯·æ± |
| | | success: function (result) { |
| | | var Organization = ""; |
| | | Organization += '<option style="color:blue;" value="">å
¨é¨</option>'; |
| | | if (result.count == 1) { // 说æéªè¯æåäºï¼ |
| | | var data = result.data; |
| | | for (var i = 0; i < data.length; i++) { |
| | | Organization += '<option style="color:blue;" value="' + data[i].Name + '">' + data[i].Name + '</option>'; |
| | | } |
| | | $("#HUSEORGID").append(Organization); |
| | | $("#HUSEORGID").val(sessionStorage["Organization"]) |
| | | form.render('select'); |
| | | } |
| | | layer.closeAll("loading"); |
| | | }, |
| | | complete: function (XHR, TS) { XHR = null }//åæ¶èµæº |
| | | }) |
| | | } |
| | | //#endregion |
| | | |
| | | |
| | | //ä½åº/åä½åº |
| | | function btn_Delete(num) { |
| | | var checkStatus = table.checkStatus('mainTable') |
| | | , data = checkStatus.data; |
| | | |
| | | if (data.length == 1) { |
| | | layer.confirm("确认è¦ä½åºå?", function (index) { |
| | | var wait = layer.load(); |
| | | var HInterID = data[0].hmainid; |
| | | $.ajax({ |
| | | url: GetWEBURL() + '/Gy_EquipFileBill/DeleteGy_EquipFileBill', |
| | | type: "GET", |
| | | data: { "HInterID": HInterID, "Type": num, "user": sessionStorage["HUserName"] }, |
| | | success: function (result) { |
| | | if (result.count == 1) { |
| | | layer.msg(result.Message, { icon: 1 }); |
| | | layer.close(wait); |
| | | get_FastQuery(); |
| | | } else { |
| | | layer.alert(result.code + result.Message, { icon: 5 }); |
| | | layer.close(wait); |
| | | } |
| | | }, error: function () { |
| | | layer.alert("æ¥å£è¯·æ±å¤±è´¥!", { icon: 5 }); |
| | | layer.close(wait); |
| | | } |
| | | }); |
| | | }) |
| | | } |
| | | else { |
| | | layer.msg("è¯·éæ©ä¸æ¡æ°æ®!"); |
| | | } |
| | | } |
| | | |
| | | //é¢è§ |
| | | function get_ViewReport() { |
| | |
| | | tree.render({ |
| | | elem: '#TreeTable' //é»è®¤æ¯ç¹å»èç¹å¯è¿è¡æ¶ç¼© |
| | | , data: treeTable |
| | | , onlyIconControl: true |
| | | , click: function (obj) { |
| | | //é«äº®åè² |
| | | $(".layui-tree-set").removeClass('layui-tree-set-active'); |
| | |
| | | function get_Refresh() { |
| | | $("#HNumber").val(""); |
| | | $("#HName").val(""); |
| | | $("#ColContent").val(""); |
| | | $("#ColName").val("0"); |
| | | $("#Comparator").val("0"); |
| | | $("#ColContent2").val(""); |
| | | $("#ColName2").val("0"); |
| | | $("#Comparator2").val("0"); |
| | | $("#ColContent1").val(""); |
| | | $("#ColName1").val("0"); |
| | | $("#Comparator1").val("0"); |
| | | $("#HUSEORGID").val(sessionStorage["Organization"]); |
| | | form.render('select'); |
| | | $("#btnSearch").click(); |
| | | } |
| | | |
| | | //#region è·ååæ° |
| | | function getUrlVars() { |
| | | var vars = [], hash; |
| | | var hashes = window.location.href.slice(window.location.href.indexOf('?') + 1).split('&'); |
| | | for (var i = 0; i < hashes.length; i++) { |
| | | hash = hashes[i].split('='); |
| | | vars.push(hash[0]); |
| | | vars[hash[0]] = hash[1]; |
| | | } |
| | | return vars; |
| | | } |
| | | //#endregion |
| | | |
| | | //#region 夿æ¯ç´æ¥æå¼é¡µé¢è¿æ¯å
¶å®é¡µé¢éè¿éæ©æé®æå¼ï¼å¹¶æ¾ç¤ºç¸åºæ°æ® |
| | | function addSWhereByOpenType() { |
| | | //è·ååæ° |
| | | var params = getUrlVars(); |
| | | var openType = params[params[0]]; //ä»åæ°ä¸è·å æå¼æ¹å¼ 1ç´æ¥æå¼ 2å
¶å®é¡µé¢éè¿éæ©æé®æå¼ |
| | | var addSWhere = ""; |
| | | if (typeof (openType) != "undefined") { |
| | | addSWhere = " and isnull(å
³é人,'') = '' and isnull(å®¡æ ¸äºº,'') != ''"; |
| | | } |
| | | return addSWhere; |
| | | } |
| | | //#endregion |
| | | |
| | | //#region ãè¿æ»¤æ¹æ¡ã |
| | | |
| | | //è·åå½åç¨æ·çé»è®¤è¿æ»¤æ¹æ¡ |