增加 项目 字段过滤功能(下拉框的方式,加载 现有 项目工程表里 前20位 ); 物料、工艺路线维护、工艺路线查询、产品工艺参数列表、生产订单维护、工序流转卡维护、首件检验单维护、 巡检单维护、工序转移检验单、库存检验单维护、车间自检单维护 并且
| | |
| | | <?xml version="1.0" encoding="utf-8"?> |
| | | <Project ToolsVersion="12.0" xmlns="http://schemas.microsoft.com/developer/msbuild/2003"> |
| | | <PropertyGroup> |
| | | <NameOfLastUsedPublishProfile>D:\vs\项ç®ä»£ç \MES-WEB-TM\MESWMS-LayUI\WebTM\Properties\PublishProfiles\FolderProfile1.pubxml</NameOfLastUsedPublishProfile> |
| | | <NameOfLastUsedPublishProfile>D:\æºäºè¿æ\MES\MES-WEB-LayUI\WebTM\Properties\PublishProfiles\FolderProfile.pubxml</NameOfLastUsedPublishProfile> |
| | | <ProjectView>ProjectFiles</ProjectView> |
| | | <LastActiveSolutionConfig>Debug|Any CPU</LastActiveSolutionConfig> |
| | | <UseIISExpress>true</UseIISExpress> |
| | |
| | | <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="HProject" id="HProject" class=" ForFilteringSchemes" lay-verify="HProject"> |
| | | <!--å¨ææ¸²æç»ç»--> |
| | | </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> |
| | |
| | | var html2 = '<h1 style="text-align:center;line-height:290px;color:red;font-weight:bolder;"></h1>'; |
| | | $("#file").append(html2); |
| | | Carousel.reload({ autoplay: false }) |
| | | |
| | | get_FastQuery(); |
| | | //è·å项ç®å· |
| | | Get_HProject(); |
| | | get_FastQuery(); |
| | | //if (openType == 2) { |
| | | // addSWhereByOpenType(); |
| | | // //get_Display(sWhere); |
| | |
| | | function set_ClearQuery() { |
| | | $("#HNumber").val(""); |
| | | $("#HName").val(""); |
| | | $("#HProject").val(""); |
| | | $("#HModel").val(""); |
| | | $("#HOrgName").val(""); |
| | | $("#ColContent").val(""); |
| | |
| | | sWhere = ""; |
| | | var HNumber = $("#HNumber").val(); |
| | | var HName = $("#HName").val(); |
| | | var HProject = $("#HProject").val(); |
| | | var HModel = $("#HModel").val(); |
| | | var HOrgName = $("#HOrgName").val(); |
| | | var ColName = $("#ColName").val();//å¤éæ¡ |
| | |
| | | } |
| | | if (HOrgName) { |
| | | sWhere += " and ç»ç»åç§° like '%" + HOrgName + "%'"; |
| | | } |
| | | if (HProject) { |
| | | sWhere += " and 项ç®å· like '%" + HProject + "%'"; |
| | | } |
| | | if (GetDataCols != "") { |
| | | sWhere += GetDataCols; |
| | |
| | | } |
| | | //#endregion |
| | | |
| | | //#region è·å项ç®å· |
| | | function Get_HProject() { |
| | | //è·å项ç®å· |
| | | var HProjectList = '<option value="0" style="color:red;" selected></option>'; |
| | | $.ajax({ |
| | | type: "get", |
| | | url: GetWEBURL() + "/Gy_Material/Get_HProject", |
| | | async: false, |
| | | data: { "HOrgID": sessionStorage["OrganizationID"] }, |
| | | success: function (result) { |
| | | if (result.count == 1) { // 说æéªè¯æåäºï¼ |
| | | var data = result.data; |
| | | for (var i = 0; i < data.length; i++) { |
| | | HProjectList += '<option style="color:blue;" value="' + data[i].HName + '" >' + data[i].HName + '</option>'; |
| | | } |
| | | $("#HProject").append(HProjectList); |
| | | form.render('select'); |
| | | |
| | | } |
| | | layer.closeAll("loading"); |
| | | } |
| | | }) |
| | | } |
| | | //#endregion |
| | | |
| | | |
| | | // æ ç¶å¾æ¥è¯¢ |
| | | function get_Display_Tree() { |
| | |
| | | </select> |
| | | </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="HProject" id="HProject" class=" ForFilteringSchemes" lay-verify="HProject"> |
| | | <!--å¨ææ¸²æç»ç»--> |
| | | </select> |
| | | </div> |
| | | </div> |
| | | </div> |
| | | <div class="layui-row"> |
| | | <div class="layui-inline"> |
| | |
| | | |
| | | //æ¥è¯¢æé® |
| | | form.on('submit(btnSearch)', function (data) {//éæ©ä»ä½ |
| | | |
| | | get_FastQuery(); |
| | | if ($("#HProject").val() == 0) { |
| | | get_FastQuery(2); |
| | | } else { |
| | | get_FastQuery(3); |
| | | } |
| | | |
| | | }); |
| | | |
| | | //#region æ¥æé´é䏿å表çå¬ |
| | |
| | | |
| | | //åå§åè¡¨æ ¼ |
| | | set_InitGrid(); |
| | | //è·å项ç®å· |
| | | Get_HProject(); |
| | | //æ¥è¯¢ |
| | | get_FastQuery(); |
| | | //æ¥è¯¢å½åç»å½ç¨æ·ææ²¡æå¨å½å模å设置é»è®¤è¿æ»¤æ¹æ¡ |
| | |
| | | //#endregion |
| | | |
| | | //#region å¿«éè¿æ»¤ |
| | | function get_FastQuery() { |
| | | function get_FastQuery(number) { |
| | | var HDate = $("#HDate").val();;//å¼å§æ¥æ |
| | | var HDate1 = $("#HDate1").val();//ç»ææ¥æ |
| | | var HProject = $("#HProject").val();//项ç®å· |
| | | var HOrderProcNO = $("#HOrderProcNO").val();//订åè·è¸ªå· |
| | | var WorkCenter = $("#WorkCenter").val();//åæ®å· |
| | | var HMaterName = $("#HMaterName").val();//åæ®å· |
| | |
| | | if (HModel) { |
| | | sWhere += " and è§æ ¼åå· like '%" + HModel + "%'"; |
| | | } |
| | | if (number == 3) { |
| | | if (HProject) { |
| | | sWhere += " and 项ç®å· like '%" + HProject + "%'"; |
| | | } |
| | | } |
| | | //if (HSF) { |
| | | // sWhere += " and æ¯å¦ä¸æ¨çææµè½¬å¡ like '%" + HSF + "%'"; |
| | | //} |
| | |
| | | var HInitTimeCycle = $("#HInitTimeCycle").val() * 1; |
| | | $("#HDate").val(Format(new Date(new Date() - 1000 * 60 * 60 * 24 * HInitTimeCycle), "yyyy-MM-dd")); //å¼å§æ¥æ |
| | | $("#HDate1").val(Format(new Date(), "yyyy-MM-dd")); //ç»ææ¥æ |
| | | |
| | | $("#HProject").val("");//项ç®å· |
| | | $("#HOrderProcNO").val("");//订åè·è¸ªå· |
| | | $("#WorkCenter").val("");//åæ®å· |
| | | $("#HDeptName").val("0");//åæ®å· |
| | |
| | | } |
| | | //#endregion |
| | | |
| | | //#region è·å项ç®å· |
| | | function Get_HProject() { |
| | | //è·å项ç®å· |
| | | var HProjectList = '<option value="0" style="color:red;" selected></option>'; |
| | | $.ajax({ |
| | | type: "get", |
| | | url: GetWEBURL() + "/Gy_Material/Get_HProject", |
| | | async: false, |
| | | data: { "HOrgID": sessionStorage["OrganizationID"] }, |
| | | success: function (result) { |
| | | if (result.count == 1) { // 说æéªè¯æåäºï¼ |
| | | var data = result.data; |
| | | for (var i = 0; i < data.length; i++) { |
| | | HProjectList += '<option style="color:blue;" value="' + data[i].HName + '" >' + data[i].HName + '</option>'; |
| | | } |
| | | $("#HProject").append(HProjectList); |
| | | form.render('select'); |
| | | |
| | | } |
| | | layer.closeAll("loading"); |
| | | } |
| | | }) |
| | | } |
| | | //#endregion |
| | | |
| | | //æ°å¢ |
| | | function set_AddNew() { |
| | | layer.open({ |
| | |
| | | <input type="date" class="layui-input ForFilteringSchemes" id="HEndDate" 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="HProject" id="HProject" class=" ForFilteringSchemes" lay-verify="HProject"> |
| | | <!--å¨ææ¸²æç»ç»--> |
| | | </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> |
| | |
| | | |
| | | //åå§åè¡¨æ ¼ |
| | | set_InitGrid(); |
| | | |
| | | //è·å项ç®å· |
| | | Get_HProject(); |
| | | //æ¥è¯¢ |
| | | if (addSWhereByOpenType()) { //addSWhereByOpenType()æ¹æ³å¤ææ¯å¦å
¶å®é¡µé¢æå¼æ¬é¡µé¢ï¼è¥æ¯åå¤çè¿æ»¤æ¡ä»¶ï¼å¹¶è¿åtrue |
| | | get_FastQuery(2); |
| | |
| | | var HBillNo = $("#HBillNo").val(); //åæ®å· |
| | | var HBeginDate = $("#HBeginDate").val();//æ»ç»äºº |
| | | var HEndDate = $("#HEndDate").val();//åæ®ç¶æ |
| | | var HProject = $("#HProject").val(); |
| | | |
| | | //ä»»æåæ®µè¿æ»¤ |
| | | var ColName = $("#ColName").val();//å¤éæ¡ |
| | |
| | | if (HEndDate) { |
| | | sWhere += " and CONVERT(varchar(100),æ¥æ, 23) <= '" + HEndDate + "'"; |
| | | } |
| | | |
| | | |
| | | if (number==2) { |
| | | if (HProject) { |
| | | sWhere += " and 项ç®å· like '%" + HProject + "%'"; |
| | | } |
| | | } |
| | | get_Display(sWhere); |
| | | sWhere = "";//è°ç¨æ¥å£åæ¸
空sWhereç¼å |
| | | } |
| | |
| | | //#region éç½®è¿æ»¤æ¡ä»¶æ¹æ³ |
| | | function set_ClearQuery() { |
| | | $("#HBillNo").val(""); |
| | | $("#HProject").val(""); |
| | | var HInitTimeCycle = $("#HInitTimeCycle").val() * 1; |
| | | $("#HBeginDate").val(Format(new Date(new Date() - 1000 * 60 * 60 * 24 * HInitTimeCycle), "yyyy-MM-dd")); //å¼å§æ¥æ |
| | | $("#HEndDate").val(Format(new Date(), "yyyy-MM-dd")); //ç»ææ¥æ |
| | |
| | | $("#HInitTimeCycle").val("29"); |
| | | } |
| | | //#endregion |
| | | //#region è·å项ç®å· |
| | | function Get_HProject() { |
| | | //è·å项ç®å· |
| | | var HProjectList = '<option value="0" style="color:red;" selected></option>'; |
| | | $.ajax({ |
| | | type: "get", |
| | | url: GetWEBURL() + "/Gy_Material/Get_HProject", |
| | | async: false, |
| | | data: { "HOrgID": sessionStorage["OrganizationID"] }, |
| | | success: function (result) { |
| | | if (result.count == 1) { // 说æéªè¯æåäºï¼ |
| | | var data = result.data; |
| | | for (var i = 0; i < data.length; i++) { |
| | | HProjectList += '<option style="color:blue;" value="' + data[i].HName + '" >' + data[i].HName + '</option>'; |
| | | } |
| | | $("#HProject").append(HProjectList); |
| | | form.render('select'); |
| | | |
| | | } |
| | | layer.closeAll("loading"); |
| | | } |
| | | }) |
| | | } |
| | | //#endregion |
| | | |
| | | //#region æ°å¢ |
| | | function set_AddNew() { |
| | |
| | | // æé®1 çåè° |
| | | end: function (index, layero, that) { |
| | | //å·æ°é¡µé¢ |
| | | get_FastQuery(); |
| | | get_FastQuery(1); |
| | | } |
| | | }) |
| | | } |
| | |
| | | // æé®1 çåè° |
| | | end: function (index, layero, that) { |
| | | //å·æ°é¡µé¢ |
| | | get_FastQuery(); |
| | | get_FastQuery(1); |
| | | } |
| | | }) |
| | | } else { |
| | |
| | | //ä¿®æ¹ä¸ºååå·æ°çé¢ |
| | | |
| | | }); |
| | | get_FastQuery(); |
| | | get_FastQuery(1); |
| | | } else { |
| | | layer.alert(result.code + result.Message, { icon: 5 }); |
| | | layer.close(wait); |
| | |
| | | |
| | | //#region å·æ° |
| | | function get_Refresh() { |
| | | get_FastQuery(); |
| | | get_FastQuery(1); |
| | | } |
| | | //#endregion |
| | | |
| | |
| | | if (result.count == 1) { |
| | | layer.msg(result.Message, { icon: 1 }); |
| | | layer.close(wait); |
| | | get_FastQuery(); |
| | | get_FastQuery(1); |
| | | } else { |
| | | layer.alert(result.code + result.Message, { icon: 5 }); |
| | | layer.close(wait); |
| | |
| | | if (result.count == 1) { |
| | | layer.msg(result.Message, { icon: 1 }); |
| | | layer.close(wait); |
| | | get_FastQuery(); |
| | | get_FastQuery(1); |
| | | } else { |
| | | layer.alert(result.code + result.Message, { icon: 5 }); |
| | | layer.close(wait); |
| | |
| | | |
| | | layer.msg(result.Message, { icon: 1 }); |
| | | layer.close(wait); |
| | | get_FastQuery(); |
| | | get_FastQuery(1); |
| | | } else { |
| | | layer.alert(result.code + result.Message, { icon: 5 }); |
| | | layer.close(wait); |
| | |
| | | |
| | | layer.msg(result.Message, { icon: 1 }); |
| | | layer.close(wait); |
| | | get_FastQuery(); |
| | | get_FastQuery(1); |
| | | } else { |
| | | layer.alert(result.code + result.Message, { icon: 5 }); |
| | | layer.close(wait); |
| | |
| | | |
| | | |
| | | //æ§è¡æ¥è¯¢æ¹æ³ |
| | | get_FastQuery(); |
| | | get_FastQuery(1); |
| | | } else { |
| | | $('#HBeginDate').prop('disabled', false); |
| | | $('#HEndDate').prop('disabled', false); |
| | | } |
| | | //æ§è¡æ¥è¯¢æ¹æ³ |
| | | get_FastQuery() |
| | | get_FastQuery(1) |
| | | form.render("select"); |
| | | } else { |
| | | //å½åç¨æ·æ²¡æè®¾ç½®é»è®¤çè¿æ»¤æ¹æ¡ |
| | |
| | | } |
| | | , end: function () { |
| | | if (HIsClose_Manual != true) { |
| | | get_FastQuery(); |
| | | get_FastQuery(1); |
| | | //æ¾ç¤ºå½åçè¿æ»¤æ¹æ¡ |
| | | 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>'; |
| | |
| | | , shift: 0//å¼¹åºå¨ç» |
| | | , content: '../../ç³»ç»ç®¡ç/è¿æ»¤æ¹æ¡è®¾ç½®/Xt_FastICScheme.html?OperationType=1&HModuleName=' + HModuleName + '&HFilterIdLists=' + HFilterIdLists + '&HValue=' + HValue + '&HElement_type=' + HElement_type |
| | | , end: function () { |
| | | get_FastQuery() |
| | | get_FastQuery(1) |
| | | //æ¾ç¤ºå½åçè¿æ»¤æ¹æ¡ |
| | | 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>'; |
| | |
| | | </button> |
| | | </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" lay-verify="HOrgID"> |
| | | <!--å¨ææ¸²æç»ç»--> |
| | | </select> |
| | | <div class="layui-row" style="margin-top:5px;margin-left:82px;margin-bottom:5px;"> |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label" style="width: 85px;">ç产订åç»ç»</label> |
| | | <div class="layui-input-block" style="margin-left: 120px; width: 185px;"> |
| | | <select name="HOrgID" id="HOrgID" lay-verify="HOrgID"> |
| | | <!--å¨ææ¸²æç»ç»--> |
| | | </select> |
| | | </div> |
| | | </div> |
| | | </div> |
| | | <button class="layui-btn layuiadmin-btn-order" style="display:none;" 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; display: none;">éç½®</button> |
| | | <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="HProject" id="HProject" class=" ForFilteringSchemes" lay-verify="HProject"> |
| | | <!--å¨ææ¸²æç»ç»--> |
| | | </select> |
| | | </div> |
| | | </div> |
| | | <button class="layui-btn layuiadmin-btn-order" style="display:none;" 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; display: none;">éç½®</button> |
| | | </div> |
| | | <div class="layui-row" style="margin-top:10px;margin-left:5%;"> |
| | | <!--å
¶ä»æ¡ä»¶--> |
| | | <div class="layui-inline"> |
| | |
| | | Organ(); |
| | | //æ¥è¯¢ |
| | | get_FastQuery(1); |
| | | //è·å项ç®å· |
| | | Get_HProject(); |
| | | } |
| | | //#endregion |
| | | |
| | |
| | | var HMaterNumber = $("#HMaterNumber").val(); |
| | | var HModel = $("#HModel").val(); |
| | | var WorkCenter = $("#WorkCenter").val();//åæ®å· |
| | | var HProject = $("#HProject").val(); |
| | | var ColName = $("#ColName").val();//å¤éæ¡ |
| | | var Comparator = $("#Comparator").val() |
| | | var ColContent = $("#ColContent").val(); |
| | |
| | | if (HOrgID) { |
| | | sWhere += " and HOrgID = '" + HOrgID + "'"; |
| | | } |
| | | if (number==2) { |
| | | if (HProject) { |
| | | sWhere += " and 项ç®å· like '%" + HProject + "%'"; |
| | | } |
| | | } |
| | | |
| | | sWhere += " and å·¥åºä»£ç != '9999' and HBillSubType<>'SUB'" |
| | | get_Display(sWhere); |
| | | sWhere = "";//è°ç¨æ¥å£åæ¸
空sWhereç¼å |
| | |
| | | } |
| | | //#endregion |
| | | |
| | | //#region è·å项ç®å· |
| | | function Get_HProject() { |
| | | //è·å项ç®å· |
| | | var HProjectList = '<option value="0" style="color:red;" selected></option>'; |
| | | $.ajax({ |
| | | type: "get", |
| | | url: GetWEBURL() + "/Gy_Material/Get_HProject", |
| | | async: false, |
| | | data: { "HOrgID": sessionStorage["OrganizationID"] }, |
| | | success: function (result) { |
| | | if (result.count == 1) { // 说æéªè¯æåäºï¼ |
| | | var data = result.data; |
| | | for (var i = 0; i < data.length; i++) { |
| | | HProjectList += '<option style="color:blue;" value="' + data[i].HName + '" >' + data[i].HName + '</option>'; |
| | | } |
| | | $("#HProject").append(HProjectList); |
| | | form.render('select'); |
| | | |
| | | } |
| | | layer.closeAll("loading"); |
| | | } |
| | | }) |
| | | } |
| | | //#endregion |
| | | |
| | | //#region å¤è¡ä¸æ¨ï¼éè´å
¥åºåï¼ |
| | | function set_ProcPriceRequestBills() { |
| | | var checkStatus = table.checkStatus('mainTable') |
| | |
| | | </button> |
| | | </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" lay-verify="HOrgID"> |
| | | <!--å¨ææ¸²æç»ç»--> |
| | | </select> |
| | | <div class="layui-row" style="margin-top:5px;margin-left:82px;margin-bottom:5px;"> |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label" style="width: 85px;">ç产订åç»ç»</label> |
| | | <div class="layui-input-block" style="margin-left: 120px; width: 185px;"> |
| | | <select name="HOrgID" id="HOrgID" lay-verify="HOrgID"> |
| | | <!--å¨ææ¸²æç»ç»--> |
| | | </select> |
| | | </div> |
| | | </div> |
| | | </div> |
| | | <button class="layui-btn layuiadmin-btn-order" type="button" style="display:none;" 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; display: none;">éç½®</button> |
| | | <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="HProject" id="HProject" class=" ForFilteringSchemes" lay-verify="HProject"> |
| | | <!--å¨ææ¸²æç»ç»--> |
| | | </select> |
| | | </div> |
| | | </div> |
| | | <button class="layui-btn layuiadmin-btn-order" type="button" style="display:none;" 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; display: none;">éç½®</button> |
| | | </div> |
| | | <div class="layui-row" style="margin-top:10px;margin-left:5%;"> |
| | | <!--å
¶ä»æ¡ä»¶--> |
| | | <div class="layui-inline"> |
| | |
| | | //åå§åè¡¨æ ¼ |
| | | set_InitGrid(); |
| | | Organ(); |
| | | //æ¥è¯¢é¡¹ç®å· |
| | | Get_HProject(); |
| | | //æ¥è¯¢ |
| | | get_FastQuery(1); |
| | | |
| | | } |
| | | //#endregion |
| | | |
| | |
| | | $("#HMaterNumber").val("");//ç©æ |
| | | $("#HModel").val("");//ç©æ |
| | | $("#HOrderProcNO").val("");//åæ®ç±»å |
| | | $("#HProject").val(""); |
| | | $("#ColContent").val(""); |
| | | $("#ColName").val("0"); |
| | | $("#Comparator").val("0"); |
| | |
| | | form.render('select'); |
| | | |
| | | $("#HInitTimeCycle").val("29"); |
| | | } |
| | | //#endregion |
| | | |
| | | //#region è·å项ç®å· |
| | | function Get_HProject() { |
| | | //è·å项ç®å· |
| | | var HProjectList = '<option value="0" style="color:red;" selected></option>'; |
| | | $.ajax({ |
| | | type: "get", |
| | | url: GetWEBURL() + "/Gy_Material/Get_HProject", |
| | | async: false, |
| | | data: { "HOrgID": sessionStorage["OrganizationID"] }, |
| | | success: function (result) { |
| | | if (result.count == 1) { // 说æéªè¯æåäºï¼ |
| | | var data = result.data; |
| | | for (var i = 0; i < data.length; i++) { |
| | | HProjectList += '<option style="color:blue;" value="' + data[i].HName + '" >' + data[i].HName + '</option>'; |
| | | } |
| | | $("#HProject").append(HProjectList); |
| | | form.render('select'); |
| | | |
| | | } |
| | | layer.closeAll("loading"); |
| | | } |
| | | }) |
| | | } |
| | | //#endregion |
| | | |
| | |
| | | var HDate = $("#HBeginDate").val();//å¼å§æ¥æ |
| | | var HDate1 = $("#HEndDate").val();//ç»ææ¥æ |
| | | var HOrgID = ""; |
| | | var HProject = $("#HProject").val(); |
| | | var HOrderProcNO = $("#HOrderProcNO").val();//åæ®ç±»å |
| | | //var HMaterID = $("#HMaterID").val(); |
| | | var HMaterName = $("#HMaterName").val(); |
| | |
| | | if (HOrgID) { |
| | | sWhere += " and HOrgID = '" + HOrgID + "'"; |
| | | } |
| | | if (number==2) { |
| | | if (HProject) { |
| | | sWhere += " and 项ç®å· like '%" + HProject + "%'"; |
| | | } |
| | | } |
| | | |
| | | sWhere += " and HBillSubType<>'SUB' "; |
| | | get_Display(sWhere); |
| | | sWhere = "";//è°ç¨æ¥å£åæ¸
空sWhereç¼å |
| | |
| | | <html xmlns="http://www.w3.org/1999/xhtml"> |
| | | <head> |
| | | <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> |
| | | <title>é¦ä»¶æ£éªåå表</title> |
| | | <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"> |
| | |
| | | <label class="layui-form-label" style="width: 85px;">ç»ææ¥æ</label> |
| | | <div class="layui-input-block" style="margin-left: 120px;"> |
| | | <input type="text" class="layui-input ForFilteringSchemes" name="HDate2" id="HDate2"> |
| | | </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="HProject" id="HProject" class=" ForFilteringSchemes" lay-verify="HProject"> |
| | | <!--å¨ææ¸²æç»ç»--> |
| | | </select> |
| | | </div> |
| | | </div> |
| | | <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnSearch" id="btnSearch"> |
| | |
| | | |
| | | //#region æ¥è¯¢æé® |
| | | form.on('submit(btnSearch)', function (data) { |
| | | get_FastQuery(); |
| | | if ($("#HProject").val() == 0) { |
| | | get_FastQuery(); |
| | | } else { |
| | | get_FastQuery(2); |
| | | } |
| | | }); |
| | | //#endregion |
| | | |
| | |
| | | $("#HDate2").val(Format(new Date(), "yyyy-MM-dd")); |
| | | //åå§åè¡¨æ ¼ |
| | | set_InitGrid(); |
| | | //æ¥è¯¢ |
| | | //RoadHBillNo(sql); |
| | | //è·å项ç®å· |
| | | Get_HProject(); |
| | | //æ¥è¯¢å½åç»å½ç¨æ·ææ²¡æå¨å½å模å设置é»è®¤è¿æ»¤æ¹æ¡ |
| | | get_DefaultModule(); |
| | | |
| | |
| | | |
| | | |
| | | //#region å¿«éè¿æ»¤ |
| | | function get_FastQuery() { |
| | | function get_FastQuery(number) { |
| | | var sqlWhere = " and 1=1 "; |
| | | var HBillNo = $("#HBillNo").val();//åæ®å· |
| | | var HProject = $("#HProject").val(); |
| | | var HNumber = $("#HNumber").val();//ç©æç¼ç |
| | | var HName = $("#HName").val();//ç©æåç§° |
| | | var HModel = $("#HModel").val();//è§æ ¼åå· |
| | |
| | | if (HDate2) { |
| | | sqlWhere += " and æ¥æ <= '" + HDate2 + "'"; |
| | | } |
| | | if (number==2) { |
| | | if (HProject) { |
| | | sqlWhere += " and 项ç®å· like '%" + HProject + "%'"; |
| | | } |
| | | } |
| | | RoadHBillNo(sqlWhere); |
| | | } |
| | | //#endregion |
| | |
| | | $("#HName").val(""); |
| | | $("#HReceiveEmp").val(""); |
| | | $("#HBillStatus").val(""); |
| | | |
| | | $("#HProject").val(""); |
| | | $("#HNumber").val(""); |
| | | $("#HModel").val(""); |
| | | $("#HName1").val(""); |
| | |
| | | |
| | | //#endregion |
| | | |
| | | //#region è·å项ç®å· |
| | | function Get_HProject() { |
| | | //è·å项ç®å· |
| | | var HProjectList = '<option value="0" style="color:red;" selected></option>'; |
| | | $.ajax({ |
| | | type: "get", |
| | | url: GetWEBURL() + "/Gy_Material/Get_HProject", |
| | | async: false, |
| | | data: { "HOrgID": sessionStorage["OrganizationID"] }, |
| | | success: function (result) { |
| | | if (result.count == 1) { // 说æéªè¯æåäºï¼ |
| | | var data = result.data; |
| | | for (var i = 0; i < data.length; i++) { |
| | | HProjectList += '<option style="color:blue;" value="' + data[i].HName + '" >' + data[i].HName + '</option>'; |
| | | } |
| | | $("#HProject").append(HProjectList); |
| | | form.render('select'); |
| | | |
| | | } |
| | | layer.closeAll("loading"); |
| | | } |
| | | }) |
| | | } |
| | | //#endregion |
| | | |
| | | //#region å·æ° |
| | | function get_Refresh() { |
| | | $("#btnSearch").trigger('click'); |
| | |
| | | <input type="text" class="layui-input ForFilteringSchemes" name="HName1" id="HName1"> |
| | | </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="HProject" id="HProject" class=" ForFilteringSchemes" lay-verify="HProject"> |
| | | <!--å¨ææ¸²æç»ç»--> |
| | | </select> |
| | | </div> |
| | | </div> |
| | | </div> |
| | | <div class="layui-row" style="margin-top:5px"> |
| | | <div class="layui-inline"> |
| | |
| | | |
| | | //#region æ¥è¯¢æé® |
| | | form.on('submit(btnSearch)', function (data) { |
| | | get_FastQuery(); |
| | | if ($("#HProject").val() == 0) { |
| | | get_FastQuery(); |
| | | } else { |
| | | get_FastQuery(2); |
| | | } |
| | | }); |
| | | //#endregion |
| | | |
| | |
| | | $("#HDate2").val(Format(new Date(), "yyyy-MM-dd")); |
| | | //åå§åè¡¨æ ¼ |
| | | set_InitGrid(); |
| | | //æ¥è¯¢ |
| | | get_Display(sWhere); |
| | | //è·å项ç®å· |
| | | Get_HProject(); |
| | | //æ¥è¯¢å½åç»å½ç¨æ·ææ²¡æå¨å½å模å设置é»è®¤è¿æ»¤æ¹æ¡ |
| | | get_DefaultModule(); |
| | | |
| | |
| | | |
| | | |
| | | //#region å¿«éè¿æ»¤ |
| | | function get_FastQuery() { |
| | | function get_FastQuery(number) { |
| | | var sqlWhere = " and 1=1 "; |
| | | var HBillNo = $("#HBillNo").val();//åæ®å· |
| | | var HProject = $("#HProject").val();//项ç®å· |
| | | var HNumber = $("#HNumber").val();//ç©æç¼ç |
| | | var HName = $("#HName").val();//ç©æåç§° |
| | | var HModel = $("#HModel").val();//è§æ ¼åå· |
| | |
| | | if (HDate2) { |
| | | sWhere += " and CONVERT(varchar(100),æ¥æ, 23) <= '" + HDate2 + "'"; |
| | | } |
| | | if (number == 2) { |
| | | if (HProject) { |
| | | sqlWhere += " and 项ç®å· like '%" + HProject + "%'"; |
| | | } |
| | | } |
| | | get_Display(sqlWhere); |
| | | } |
| | | //#endregion |
| | |
| | | $("#HBillNo").val(""); |
| | | $("#HProNumber").val(""); |
| | | $("#HName").val(""); |
| | | |
| | | $("#HProject").val(""); |
| | | $("#HNumber").val(""); |
| | | $("#HModel").val(""); |
| | | $("#HName1").val(""); |
| | |
| | | } |
| | | //#endregion |
| | | |
| | | //#region è·å项ç®å· |
| | | function Get_HProject() { |
| | | //è·å项ç®å· |
| | | var HProjectList = '<option value="0" style="color:red;" selected></option>'; |
| | | $.ajax({ |
| | | type: "get", |
| | | url: GetWEBURL() + "/Gy_Material/Get_HProject", |
| | | async: false, |
| | | data: { "HOrgID": sessionStorage["OrganizationID"] }, |
| | | success: function (result) { |
| | | if (result.count == 1) { // 说æéªè¯æåäºï¼ |
| | | var data = result.data; |
| | | for (var i = 0; i < data.length; i++) { |
| | | HProjectList += '<option style="color:blue;" value="' + data[i].HName + '" >' + data[i].HName + '</option>'; |
| | | } |
| | | $("#HProject").append(HProjectList); |
| | | form.render('select'); |
| | | |
| | | } |
| | | layer.closeAll("loading"); |
| | | } |
| | | }) |
| | | } |
| | | //#endregion |
| | | |
| | | //#region ãè¿æ»¤æ¹æ¡ã |
| | | |
| | | //è·åå½åç¨æ·çé»è®¤è¿æ»¤æ¹æ¡ |
| | |
| | | document.getElementById("HFilterScheme_Now").style.display = "none"; |
| | | //æ§è¡æ¥è¯¢æ¹æ³ |
| | | //æ¥è¯¢ |
| | | //get_FastQuery(); |
| | | get_FastQuery(); |
| | | |
| | | form.render("select"); |
| | | } |
| | |
| | | <input type="text" class="layui-input ForFilteringSchemes" name="HName1" id="HName1"> |
| | | </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="HProject" id="HProject" class=" ForFilteringSchemes" lay-verify="HProject"> |
| | | <!--å¨ææ¸²æç»ç»--> |
| | | </select> |
| | | </div> |
| | | </div> |
| | | </div> |
| | | <div class="layui-row" style="margin-top:5px"> |
| | | <div class="layui-inline"> |
| | |
| | | |
| | | //#region æ¥è¯¢æé® |
| | | form.on('submit(btnSearch)', function (data) { |
| | | get_FastQuery(); |
| | | if ($("#HProject").val() == 0) { |
| | | get_FastQuery(); |
| | | } else { |
| | | get_FastQuery(2); |
| | | } |
| | | |
| | | }); |
| | | //#endregion |
| | | //æ¥æé´é䏿å表çå¬ |
| | |
| | | $("#HDate2").val(Format(new Date(), "yyyy-MM-dd")); |
| | | //åå§åè¡¨æ ¼ |
| | | set_InitGrid(); |
| | | //æ¥è¯¢ |
| | | //RoadHBillNo(sql); |
| | | //è·å项ç®å· |
| | | Get_HProject(); |
| | | //æ¥è¯¢å½åç»å½ç¨æ·ææ²¡æå¨å½å模å设置é»è®¤è¿æ»¤æ¹æ¡ |
| | | get_DefaultModule(); |
| | | |
| | |
| | | |
| | | |
| | | //#region å¿«éè¿æ»¤ |
| | | function get_FastQuery() { |
| | | function get_FastQuery(number) { |
| | | var sqlWhere = " and 1=1 "; |
| | | var HBillNo = $("#HBillNo").val();//åæ®å· |
| | | var HProject = $("#HProject").val();//项ç®å· |
| | | var HNumber = $("#HNumber").val();//ç©æç¼ç |
| | | var HName = $("#HName").val();//ç©æåç§° |
| | | var HModel = $("#HModel").val();//è§æ ¼åå· |
| | |
| | | sqlWhere += " and å·¥åºæµè½¬å¡å· like '%" + HProcExchBillNo + "%'"; |
| | | |
| | | if (HDate1) { |
| | | sWhere += " and CONVERT(varchar(100),æ¥æ, 23) >= '" + HDate1 + "'"; |
| | | sqlWhere += " and CONVERT(varchar(100),æ¥æ, 23) >= '" + HDate1 + "'"; |
| | | } |
| | | if (HDate2) { |
| | | sWhere += " and CONVERT(varchar(100),æ¥æ, 23) <= '" + HDate2 + "'"; |
| | | sqlWhere += " and CONVERT(varchar(100),æ¥æ, 23) <= '" + HDate2 + "'"; |
| | | } |
| | | if (number==2) { |
| | | |
| | | if (HProject) { |
| | | sqlWhere += " and 项ç®å· like '%" + HProject + "%'"; |
| | | } |
| | | } |
| | | RoadHBillNo(sqlWhere); |
| | | } |
| | |
| | | $("#HName").val(""); |
| | | $("#HReceiveEmp").val(""); |
| | | $("#HBillStatus").val(""); |
| | | |
| | | $("#HProject").val(""); |
| | | $("#HNumber").val(""); |
| | | $("#HModel").val(""); |
| | | $("#HName1").val(""); |
| | |
| | | } |
| | | //#endregion |
| | | |
| | | //#region è·å项ç®å· |
| | | function Get_HProject() { |
| | | //è·å项ç®å· |
| | | var HProjectList = '<option value="0" style="color:red;" selected></option>'; |
| | | $.ajax({ |
| | | type: "get", |
| | | url: GetWEBURL() + "/Gy_Material/Get_HProject", |
| | | async: false, |
| | | data: { "HOrgID": sessionStorage["OrganizationID"] }, |
| | | success: function (result) { |
| | | if (result.count == 1) { // 说æéªè¯æåäºï¼ |
| | | var data = result.data; |
| | | for (var i = 0; i < data.length; i++) { |
| | | HProjectList += '<option style="color:blue;" value="' + data[i].HName + '" >' + data[i].HName + '</option>'; |
| | | } |
| | | $("#HProject").append(HProjectList); |
| | | form.render('select'); |
| | | |
| | | } |
| | | layer.closeAll("loading"); |
| | | } |
| | | }) |
| | | } |
| | | //#endregion |
| | | |
| | | //æ°å¢ |
| | | function set_AddNew() { |
| | | layer.open({ |
| | |
| | | <html xmlns="http://www.w3.org/1999/xhtml"> |
| | | <head> |
| | | <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> |
| | | <title>é¦ä»¶æ£éªåå表</title> |
| | | <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"> |
| | |
| | | <label class="layui-form-label" style="width: 85px;">ç»ææ¥æ</label> |
| | | <div class="layui-input-block" style="margin-left: 120px;"> |
| | | <input type="text" class="layui-input ForFilteringSchemes" name="HDate2" id="HDate2"> |
| | | </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="HProject" id="HProject" class=" ForFilteringSchemes" lay-verify="HProject"> |
| | | <!--å¨ææ¸²æç»ç»--> |
| | | </select> |
| | | </div> |
| | | </div> |
| | | <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnSearch" id="btnSearch"> |
| | |
| | | |
| | | //#region æ¥è¯¢æé® |
| | | form.on('submit(btnSearch)', function (data) { |
| | | get_FastQuery(); |
| | | if ($("#HProject").val() == 0) { |
| | | get_FastQuery(); |
| | | } else { |
| | | get_FastQuery(2); |
| | | } |
| | | }); |
| | | //#endregion |
| | | |
| | |
| | | $("#HDate2").val(Format(new Date(), "yyyy-MM-dd")); |
| | | //åå§åè¡¨æ ¼ |
| | | set_InitGrid(); |
| | | //æ¥è¯¢ |
| | | //RoadHBillNo(sql); |
| | | //è·å项ç®å· |
| | | Get_HProject(); |
| | | //æ¥è¯¢å½åç»å½ç¨æ·ææ²¡æå¨å½å模å设置é»è®¤è¿æ»¤æ¹æ¡ |
| | | get_DefaultModule(); |
| | | |
| | |
| | | |
| | | |
| | | //#region å¿«éè¿æ»¤ |
| | | function get_FastQuery() { |
| | | function get_FastQuery(number) { |
| | | var sqlWhere = " and 1=1 "; |
| | | var HBillNo = $("#HBillNo").val();//åæ®å· |
| | | var HProject = $("#HProject").val();//项ç®å· |
| | | var HNumber = $("#HNumber").val();//ç©æç¼ç |
| | | var HName = $("#HName").val();//ç©æåç§° |
| | | var HModel = $("#HModel").val();//è§æ ¼åå· |
| | |
| | | if (HDate2) { |
| | | sqlWhere += " and æ¥æ <= '" + HDate2 + "'"; |
| | | } |
| | | if (number==2) { |
| | | if (HProject) { |
| | | sqlWhere += " and 项ç®å· like '%" + HProject + "%'"; |
| | | } |
| | | } |
| | | RoadHBillNo(sqlWhere); |
| | | } |
| | | //#endregion |
| | |
| | | //#region éç½®è¿æ»¤æ¡ä»¶æ¹æ³ |
| | | function set_ClearQuery() { |
| | | $("#HBillNo").val(""); |
| | | $("#HProject").val(""); |
| | | $("#HProNumber").val(""); |
| | | $("#HName").val(""); |
| | | $("#HReceiveEmp").val(""); |
| | | $("#HBillStatus").val(""); |
| | | |
| | | $("#HProject").val(""); |
| | | $("#HNumber").val(""); |
| | | $("#HModel").val(""); |
| | | $("#HName1").val(""); |
| | |
| | | } |
| | | //#endregion |
| | | |
| | | //#region è·å项ç®å· |
| | | function Get_HProject() { |
| | | //è·å项ç®å· |
| | | var HProjectList = '<option value="0" style="color:red;" selected></option>'; |
| | | $.ajax({ |
| | | type: "get", |
| | | url: GetWEBURL() + "/Gy_Material/Get_HProject", |
| | | async: false, |
| | | data: { "HOrgID": sessionStorage["OrganizationID"] }, |
| | | success: function (result) { |
| | | if (result.count == 1) { // 说æéªè¯æåäºï¼ |
| | | var data = result.data; |
| | | for (var i = 0; i < data.length; i++) { |
| | | HProjectList += '<option style="color:blue;" value="' + data[i].HName + '" >' + data[i].HName + '</option>'; |
| | | } |
| | | $("#HProject").append(HProjectList); |
| | | form.render('select'); |
| | | |
| | | } |
| | | layer.closeAll("loading"); |
| | | } |
| | | }) |
| | | } |
| | | //#endregion |
| | | |
| | | //æ°å¢ |
| | | function set_AddNew() { |
| | | layer.open({ |
| | |
| | | <input type="text" class="layui-input ForFilteringSchemes" name="HDate2" id="HDate2"> |
| | | </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="HProject" id="HProject" class=" ForFilteringSchemes" lay-verify="HProject"> |
| | | <!--å¨ææ¸²æç»ç»--> |
| | | </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> |
| | |
| | | |
| | | //#region æ¥è¯¢æé® |
| | | form.on('submit(btnSearch)', function (data) { |
| | | get_FastQuery(); |
| | | if ($("#HProject").val() == 0) { |
| | | get_FastQuery(); |
| | | } else { |
| | | get_FastQuery(2); |
| | | } |
| | | }); |
| | | //#endregion |
| | | |
| | |
| | | $("#HDate2").val(Format(new Date(), "yyyy-MM-dd")); |
| | | //åå§åè¡¨æ ¼ |
| | | set_InitGrid(); |
| | | //æ¥è¯¢ |
| | | //RoadHBillNo(sql); |
| | | //è·å项ç®å· |
| | | Get_HProject(); |
| | | //æ¥è¯¢å½åç»å½ç¨æ·ææ²¡æå¨å½å模å设置é»è®¤è¿æ»¤æ¹æ¡ |
| | | get_DefaultModule(); |
| | | |
| | |
| | | |
| | | |
| | | //#region å¿«éè¿æ»¤ |
| | | function get_FastQuery() { |
| | | function get_FastQuery(number) { |
| | | var sqlWhere = " and 1=1 "; |
| | | var HBillNo = $("#HBillNo").val();//åæ®å· |
| | | var HProject = $("#HProject").val();//项ç®å· |
| | | var HNumber = $("#HNumber").val();//ç©æç¼ç |
| | | var HName = $("#HName").val();//ç©æåç§° |
| | | var HModel = $("#HModel").val();//è§æ ¼åå· |
| | |
| | | if (HDate2) { |
| | | sqlWhere += " and æ¥æ <= '" + HDate2 + "'"; |
| | | } |
| | | if (number==2) { |
| | | if (HProject) { |
| | | sqlWhere += " and 项ç®å· like '%" + HProject + "%'"; |
| | | } |
| | | } |
| | | RoadHBillNo(sqlWhere); |
| | | } |
| | | //#endregion |
| | |
| | | $("#HName").val(""); |
| | | $("#HReceiveEmp").val(""); |
| | | $("#HBillStatus").val(""); |
| | | |
| | | $("#HProject").val(""); |
| | | $("#HNumber").val(""); |
| | | $("#HModel").val(""); |
| | | $("#HName1").val(""); |
| | |
| | | } |
| | | //#endregion |
| | | |
| | | //#region è·å项ç®å· |
| | | function Get_HProject() { |
| | | //è·å项ç®å· |
| | | var HProjectList = '<option value="0" style="color:red;" selected></option>'; |
| | | $.ajax({ |
| | | type: "get", |
| | | url: GetWEBURL() + "/Gy_Material/Get_HProject", |
| | | async: false, |
| | | data: { "HOrgID": sessionStorage["OrganizationID"] }, |
| | | success: function (result) { |
| | | if (result.count == 1) { // 说æéªè¯æåäºï¼ |
| | | var data = result.data; |
| | | for (var i = 0; i < data.length; i++) { |
| | | HProjectList += '<option style="color:blue;" value="' + data[i].HName + '" >' + data[i].HName + '</option>'; |
| | | } |
| | | $("#HProject").append(HProjectList); |
| | | form.render('select'); |
| | | |
| | | } |
| | | layer.closeAll("loading"); |
| | | } |
| | | }) |
| | | } |
| | | //#endregion |
| | | |
| | | //æ°å¢ |
| | | function set_AddNew() { |
| | | layer.open({ |
| | |
| | | <input type="text" class="layui-input ForFilteringSchemes" name="HProcExchBillNo" id="SHname"> |
| | | </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="HProject" id="HProject" class=" ForFilteringSchemes" lay-verify="HProject"> |
| | | <!--å¨ææ¸²æç»ç»--> |
| | | </select> |
| | | </div> |
| | | </div> |
| | | </div> |
| | | <div class="layui-row" style="margin-top: 10px; margin-bottom: 10px;"> |
| | | <div class="layui-inline"> |
| | |
| | | |
| | | //#region æ¥è¯¢æé® |
| | | form.on('submit(btnSearch)', function (data) { |
| | | get_FastQuery(); |
| | | if ($("#HProject").val() == 0) { |
| | | get_FastQuery(); |
| | | } else { |
| | | get_FastQuery(2); |
| | | } |
| | | |
| | | }); |
| | | //#endregion |
| | | |
| | |
| | | //åå§åä»è¡¨å表 |
| | | set_InitGrid4(); |
| | | table.render(option2); |
| | | //è·å项ç®å· |
| | | Get_HProject(); |
| | | //æ¥è¯¢ |
| | | get_FastQuery(); |
| | | //æ¥è¯¢å½åç»å½ç¨æ·ææ²¡æå¨å½å模å设置é»è®¤è¿æ»¤æ¹æ¡ |
| | |
| | | var HInitTimeCycle = $("#HInitTimeCycle").val() * 1; |
| | | $("#HDate").val(Format(new Date(new Date() - 1000 * 60 * 60 * 24 * HInitTimeCycle), "yyyy-MM-dd")); //å¼å§æ¥æ |
| | | $("#HDate1").val(Format(new Date(), "yyyy-MM-dd")); //ç»ææ¥æ |
| | | |
| | | $("#HProject").val("");//项ç®å· |
| | | $("#HOrderProcNO").val("");//订åè·è¸ªå· |
| | | $("#SHname").val("");//ç©æ|åä»¶åç§°|åä»¶è§æ ¼ |
| | | $("#HBillNo").val("");//åæ®å· |
| | |
| | | //#endregion |
| | | |
| | | //#region å¿«éè¿æ»¤ |
| | | function get_FastQuery() { |
| | | function get_FastQuery(number) { |
| | | var SHPrintQty = $("#SHPrintQty").val();//æå°ç¶æ |
| | | var HDate = $("#HDate").val();//å¼å§æ¥æ |
| | | var HDate1 = $("#HDate1").val();//ç»ææ¥æ |
| | | var HProject = $("#HProject").val();//项ç®å· |
| | | var HOrderProcNO = $("#HOrderProcNO").val();//订åè·è¸ªå· |
| | | var HWorkBillNo = $("#HWorkBillNo").val(); |
| | | var SHname = $("#SHname").val();//ç©æ|åä»¶åç§°|åä»¶è§æ ¼ |
| | |
| | | if (HErpID) { |
| | | sWhere += " and å¯ä¸ID like '%" + HErpID + "%'"; |
| | | } |
| | | |
| | | if (number==2) { |
| | | if (HProject) { |
| | | sWhere += " and 项ç®å· like '%" + HProject + "%'"; |
| | | } |
| | | } |
| | | //æ ¹æ®ç¨æ·è¿æ»¤ç¨æ·å
³è客æ·çè®°å½ |
| | | sWhere += getSWhereByHUser(); |
| | | |
| | |
| | | } |
| | | //#endregion |
| | | |
| | | //#region è·å项ç®å· |
| | | function Get_HProject() { |
| | | //è·å项ç®å· |
| | | var HProjectList = '<option value="0" style="color:red;" selected></option>'; |
| | | $.ajax({ |
| | | type: "get", |
| | | url: GetWEBURL() + "/Gy_Material/Get_HProject", |
| | | async: false, |
| | | data: { "HOrgID": sessionStorage["OrganizationID"] }, |
| | | success: function (result) { |
| | | if (result.count == 1) { // 说æéªè¯æåäºï¼ |
| | | var data = result.data; |
| | | for (var i = 0; i < data.length; i++) { |
| | | HProjectList += '<option style="color:blue;" value="' + data[i].HName + '" >' + data[i].HName + '</option>'; |
| | | } |
| | | $("#HProject").append(HProjectList); |
| | | form.render('select'); |
| | | |
| | | } |
| | | layer.closeAll("loading"); |
| | | } |
| | | }) |
| | | } |
| | | //#endregion |
| | | |
| | | //è·åå½åç¨æ·çé»è®¤è¿æ»¤æ¹æ¡ |
| | | function get_DefaultModule() { |
| | | $.ajax({ |