wtt
2025-10-30 d9d78499cf3aaa6165bb1bc9fe3d8a9537e4d26a
WebTM/views/ÏúÊÛ¹ÜÀí/ÏúÊÛ¶©µ¥/Xs_SeOrderBillList.html
@@ -1,5 +1,6 @@
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
    <title>销售订单列表</title>
@@ -18,13 +19,14 @@
    <script src="../../../layuiadmin/soulTable.slim.js"></script>
    <script src="../../../layuiadmin/HideButton.js"></script>
    <script src="../../../layuiadmin/PageTitle.js"></script>
    <script src="../../../layuiadmin/SetColumn.js"></script>
    <style type="text/css">
        input.layui-input.layui-unselect {
            padding-right: 0;
        }
    </style>
</head>
<body>
    <div class="layui-fluid">
        <div class="layui-col-md12">
@@ -41,45 +43,62 @@
                                <div class="layui-inline">
                                    <label class="layui-form-label">日期间隔</label>
                                    <div class="layui-input-block">
                                        <select name="HInitTimeCycle" id="HInitTimeCycle" class="ForFilteringSchemes" lay-filter="HInitTimeCycle" style="width:190px;">
                                        <select name="HInitTimeCycle" id="HInitTimeCycle" class="ForFilteringSchemes"
                                            lay-filter="HInitTimeCycle" style="width:190px;">
                                        </select>
                                    </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="HBeginDate" style="width:190px;">
                                        <input type="date" class="layui-input ForFilteringSchemes" id="HBeginDate"
                                            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="HEndDate" style="width:190px;">
                                        <input type="date" class="layui-input ForFilteringSchemes" id="HEndDate"
                                            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="HBillNo" id="HBillNo" style="width:190px;">
                                        <input type="text" class="layui-input ForFilteringSchemes" name="HBillNo"
                                            id="HBillNo" style="width:190px;">
                                    </div>
                                </div>
                                <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnSearch" id="btnSearch">
                                <div class="layui-inline">
                                    <label class="layui-form-label">项目编号</label>
                                    <div class="layui-input-block">
                                        <input type="text" class="layui-input ForFilteringSchemes" name="HProjectNumber"
                                            id="HProjectNumber" style="width:190px;">
                                    </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>
                                <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit=""
                                    lay-filter="btnReSearch" id="btnReSearch" style="padding:0 5px">重置</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 style="text-align:center;font-size:15px;font-weight:bold;color:#fc9393"
                                        id="HFilterScheme_Now"></div>
                                </div>
                                <div style="display:none;">
                                    <div class="layui-inline">
                                        <label class="layui-form-label">单据号</label>
                                        <div class="layui-input-block">
                                            <input type="text" class="layui-input ForFilteringSchemes" name="HBillno2" id="HBillno2" style="width:190px;">
                                            <input type="text" class="layui-input ForFilteringSchemes" name="HBillno2"
                                                id="HBillno2" style="width:190px;">
                                        </div>
                                    </div>
                                    <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnResCnz" id="btnReSearch" style="padding: 0 5px;">重新同步</button>
                                    <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit=""
                                        lay-filter="btnResCnz" id="btnReSearch" style="padding: 0 5px;">重新同步</button>
                                </div>
                                <div class="layui-colla-content">
@@ -87,19 +106,22 @@
                                        <div class="layui-inline">
                                            <label class="layui-form-label">客户</label>
                                            <div class="layui-input-block">
                                                <input type="text" class="layui-input ForFilteringSchemes" name="HCusID" id="HCusID" style="width:190px;">
                                                <input type="text" class="layui-input ForFilteringSchemes" name="HCusID"
                                                    id="HCusID" 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="HMaterNumber" id="HMaterNumber" style="width:190px;">
                                                <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;">
                                                <input type="text" class="layui-input ForFilteringSchemes"
                                                    name="HMaterName" id="HMaterName" style="width:190px;">
                                            </div>
                                        </div>
                                    </div>
@@ -107,19 +129,25 @@
                                        <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 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;">
                                            <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="<=">
                                                    <=< /option>
                                                <option value="<">
                                                    << /option>
                                                <option value="<>">
                                                    <>
                                                </option>
                                                <option value="7">包含</option>
                                                <option value="8">左包含</option>
                                                <option value="9">右包含</option>
@@ -127,7 +155,8 @@
                                            </select>
                                        </div>
                                        <div class="layui-inline">
                                            <input type="text" class="layui-input ForFilteringSchemes" value="" name="ColContent" id="ColContent">
                                            <input type="text" class="layui-input ForFilteringSchemes" value=""
                                                name="ColContent" id="ColContent">
                                        </div>
                                    </div>
@@ -135,19 +164,25 @@
                                        <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 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;">
                                            <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="<=">
                                                    <=< /option>
                                                <option value="<">
                                                    << /option>
                                                <option value="<>">
                                                    <>
                                                </option>
                                                <option value="7">包含</option>
                                                <option value="8">左包含</option>
                                                <option value="9">右包含</option>
@@ -155,7 +190,8 @@
                                            </select>
                                        </div>
                                        <div class="layui-inline">
                                            <input type="text" class="layui-input ForFilteringSchemes" value="" name="ColContent1" id="ColContent1">
                                            <input type="text" class="layui-input ForFilteringSchemes" value=""
                                                name="ColContent1" id="ColContent1">
                                        </div>
                                    </div>
@@ -163,19 +199,25 @@
                                        <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 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;">
                                            <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="<=">
                                                    <=< /option>
                                                <option value="<">
                                                    << /option>
                                                <option value="<>">
                                                    <>
                                                </option>
                                                <option value="7">包含</option>
                                                <option value="8">左包含</option>
                                                <option value="9">右包含</option>
@@ -183,51 +225,54 @@
                                            </select>
                                        </div>
                                        <div class="layui-inline">
                                            <input type="text" class="layui-input ForFilteringSchemes" value="" name="ColContent2" id="ColContent2">
                                            <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>
                        <div id="page"></div>
                        <script type="text/html" id="toolbarDemo">
                            <div class="layui-btn-container">
                                <button type="button" class="layui-btn layui-btn-sm" style="" lay-event="btn-Add" id="btn-Add"><i class="layui-icon layui-icon-file-b"></i>新增</button>
                                <button type="button" class="layui-btn layui-btn-sm" style="" lay-event="btn-Copy" id="btn-Copy"><i class="layui-icon layui-icon-file-b"></i>复制</button>
                                <button type="button" class="layui-btn layui-btn-sm" style="" lay-event="btn-Edit" id="btn-Edit"><i class="layui-icon layui-icon-form"></i>编辑</button>
                                <button type="button" class="layui-btn layui-btn-sm" style="" lay-event="btn-Delete" id="btn-Delete"><i class="layui-icon layui-icon-delete"></i>删除</button>
                                <button type="button" class="layui-btn layui-btn-sm" style="" lay-event="btn-PushSeOrderChangeBill" id="btn-PushSeOrderChangeBill"><i class="layui-icon layui-icon-delete"></i>下推(销售订单变更单)</button>
                                <button type="button" class="layui-btn layui-btn-sm" style="" lay-event="btn-PushExceptiveCheckRequestBill" id="btn-PushExceptiveCheckRequestBill"><i class="layui-icon layui-icon-delete"></i>下推(特批申请单)</button>
                                <button type="button" class="layui-btn layui-btn-sm" style="" lay-event="btn-PushICMOBill" id="btn-PushICMOBill"><i class="layui-icon layui-icon-delete"></i>下推(生产订单)</button>
                                <button type="button" class="layui-btn layui-btn-sm" style="" lay-event="btn-PushICStockBills" id="btn-PushICStockBills"><i class="layui-icon layui-icon-delete"></i>多行下推(销售出库单)</button>
                                <button type="button" class="layui-btn layui-btn-sm" style="" lay-event="btn-PushICStockBackBills" id="btn-PushICStockBackBills"><i class="layui-icon layui-icon-delete"></i>多行下推(销售退货单)</button>
                                <button type="button" class="layui-btn layui-btn-sm" style="" lay-event="btn-PushReceivableBills" id="btn-PushReceivableBills"><i class="layui-icon layui-icon-delete"></i>多行下推(应收单)</button>
                                <button type="button" class="layui-btn layui-btn-sm" style="" 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" style="" lay-event="get_LookDown" id="get_LookDown"><i class="layui-icon layui-icon-refresh-3"></i>下查</button>
                                <button type="button" class="layui-btn layui-btn-sm" style="" lay-event="get_needClose" id="get_needClose"><i class="layui-icon layui-icon-refresh-3"></i>待关闭项</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-Add" id="btn-Add"><i class="layui-icon layui-icon-file-b"></i>新增</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-Copy" id="btn-Copy"><i class="layui-icon layui-icon-file-b"></i>复制</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-Edit" id="btn-Edit"><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-delete"></i>删除</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-PushSeOrderChangeBill" id="btn-PushSeOrderChangeBill"><i class="layui-icon layui-icon-delete"></i>下推(销售订单变更单)</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-PushExceptiveCheckRequestBill" id="btn-PushExceptiveCheckRequestBill"><i class="layui-icon layui-icon-delete"></i>下推(特批申请单)</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-PushICMOBill" id="btn-PushICMOBill"><i class="layui-icon layui-icon-delete"></i>下推(生产订单)</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-PushOutCompCheckBill" id="btn-PushOutCompCheckBill"><i class="layui-icon layui-icon-delete"></i>下推(出厂检验单)</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-PushICStockBills" id="btn-PushICStockBills"><i class="layui-icon layui-icon-delete"></i>多行下推(销售出库单)</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-PushICStockBackBills" id="btn-PushICStockBackBills"><i class="layui-icon layui-icon-delete"></i>多行下推(销售退货单)</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-PushReceivableBills" id="btn-PushReceivableBills"><i class="layui-icon layui-icon-delete"></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_LookDown" id="get_LookDown"><i class="layui-icon layui-icon-refresh-3"></i>下查</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="get_needClose" id="get_needClose"><i class="layui-icon layui-icon-refresh-3"></i>待关闭项</button>
                                <!--<button type="button" class="layui-btn layui-btn-sm" style="display:none;" lay-event="btn-print" id="btn-print"><i class="layui-icon layui-icon-print"></i>打印</button>-->
                                <button type="button" class="layui-btn layui-btn-sm" style="" lay-event="set_startCheckBill" id="set_startCheckBill"><i class="layui-icon layui-icon-form"></i>发起审批</button>
                                <button type="button" class="layui-btn layui-btn-sm" style="" lay-event="get_CheckFlowInfo" id="get_CheckFlowInfo"><i class="layui-icon layui-icon-form"></i>查看审批进度</button>
                                <button type="button" class="layui-btn layui-btn-sm" style="" lay-event="set_CheckBill_Flow" id="CheckBill_Flow"><i class="layui-icon layui-icon-form"></i>多级审核</button>
                                <button type="button" class="layui-btn layui-btn-sm" style="" lay-event="set_AbandonCheck_Flow" id="AbandonCheck_Flow"><i class="layui-icon layui-icon-form"></i>多级反审核</button>
                                <button type="button" class="layui-btn layui-btn-sm" style="" lay-event="set_RejectCheck_Flow" id="RejectCheck_Flow"><i class="layui-icon layui-icon-form"></i>驳回</button>
                                <button type="button" class="layui-btn layui-btn-sm" style="" lay-event="set_CheckBill" id="CheckBill"><i class="layui-icon layui-icon-form"></i>审核</button>
                                <button type="button" class="layui-btn layui-btn-sm" style="" lay-event="set_AbandonCheck" id="AbandonCheck"><i class="layui-icon layui-icon-form"></i>反审核</button>
                                <button type="button" class="layui-btn layui-btn-sm" style="" 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" style="" 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" style="" lay-event="set_CloseRow" id="set_CloseRow"><i class="layui-icon layui-icon-form"></i>行关闭</button>
                                <button type="button" class="layui-btn layui-btn-sm" style="" lay-event="set_CancelCloseRow" id="set_CancelCloseRow"><i class="layui-icon layui-icon-form"></i>行反关闭</button>
                                <button type="button" class="layui-btn layui-btn-sm" style="" lay-event="set_Drop" id="set_Drop"><i class="layui-icon layui-icon-radio"></i>作废</button>
                                <button type="button" class="layui-btn layui-btn-sm" style="" lay-event="set_DeDrop" id="set_DeDrop"><i class="layui-icon layui-icon-radio"></i>反作废</button>
                                <button type="button" class="layui-btn layui-btn-sm" style="" id="btn-print" lay-event="btn-print"><i class="layui-icon layui-icon-form"></i>打印</button>
                                <button type="button" class="layui-btn layui-btn-sm" style="" id="btn-print_StockIn" lay-event="btn-print_StockIn"><i class="layui-icon layui-icon-form"></i>打印(入库码单)</button>
                                <button type="button" class="layui-btn layui-btn-sm" style="" 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" style="" lay-event="HideColumn" id="HideColumn"><i class="layui-icon layui-icon-form"></i>隐藏列设置</button>
                                <button type="button" class="layui-btn layui-btn-sm" style="" lay-event="set_HideButton" id="HideButton"><i class="layui-icon layui-icon-form"></i>按钮设置</button>
                                <button type="button" class="layui-btn layui-btn-sm" style="" 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" style="" 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="set_startCheckBill" id="set_startCheckBill"><i class="layui-icon layui-icon-form"></i>发起审批</button>
                                <button type="button" class="layui-btn layui-btn-sm"  lay-event="get_CheckFlowInfo" id="get_CheckFlowInfo"><i class="layui-icon layui-icon-form"></i>查看审批进度</button>
                                <button type="button" class="layui-btn layui-btn-sm"  lay-event="set_CheckBill_Flow" id="CheckBill_Flow"><i class="layui-icon layui-icon-form"></i>多级审核</button>
                                <button type="button" class="layui-btn layui-btn-sm"  lay-event="set_AbandonCheck_Flow" id="AbandonCheck_Flow"><i class="layui-icon layui-icon-form"></i>多级反审核</button>
                                <button type="button" class="layui-btn layui-btn-sm"  lay-event="set_RejectCheck_Flow" id="RejectCheck_Flow"><i class="layui-icon layui-icon-form"></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>
                                <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="set_CloseRow" id="set_CloseRow"><i class="layui-icon layui-icon-form"></i>行关闭</button>
                                <button type="button" class="layui-btn layui-btn-sm"  lay-event="set_CancelCloseRow" id="set_CancelCloseRow"><i class="layui-icon layui-icon-form"></i>行反关闭</button>
                                <button type="button" class="layui-btn layui-btn-sm"  lay-event="set_Drop" id="set_Drop"><i class="layui-icon layui-icon-radio"></i>作废</button>
                                <button type="button" class="layui-btn layui-btn-sm"  lay-event="set_DeDrop" id="set_DeDrop"><i class="layui-icon layui-icon-radio"></i>反作废</button>
                                <button type="button" class="layui-btn layui-btn-sm"  id="btn-print" lay-event="btn-print"><i class="layui-icon layui-icon-form"></i>打印</button>
                                <button type="button" class="layui-btn layui-btn-sm"  id="btn-print_StockIn" lay-event="btn-print_StockIn"><i class="layui-icon layui-icon-form"></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="HideColumn" id="HideColumn"><i class="layui-icon layui-icon-form"></i>隐藏列设置</button>
                                <button type="button" class="layui-btn layui-btn-sm"  lay-event="set_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" style="display:none;" lay-event="set_QueryCondition" id="set_QueryCondition"><i class="layui-icon layui-icon-set"></i>高级过滤</button>-->
                                <button type="button" class="layui-btn layui-btn-sm" style="" 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="get_Exit" id="get_Exit"><i class="layui-icon layui-icon-logout"></i>退出</button>
                            </div>
                        </script>
                    </form>
@@ -258,13 +303,17 @@
                , util = layui.util
                , soulTable = layui.soulTable
            //查询条件
            var Organization = sessionStorage["Organization"];
            var sWhere = "";
            var option = [];
            var HModName = "Xs_SeOrderBillList";
            var HBillType = "1401";
            var ins;                        //用于导出excel
            //记录过滤条件用于排序时获取数据
            var sWhere_Bak = "";
            var get_needClose_Bar = 0;
@@ -272,7 +321,7 @@
            //#region ã€åŠ¨æ€èŽ·å–æ¨¡å—åç§°ã€‘
            var HModuleType = "1401";
            //通过单据类型,从数据库动态获取单据模块命名,引用js文件 PageTitle.js
            var HPageTitle = get_PageTitle(HModuleType) == "" ? document.title : get_PageTitle(HModuleType);
            var HPageTitle = get_PageTitle(HModuleType) || document.title;
            //#endregion
            var titleData = ["hmainid", "HBillType", "HCusID", "HSSID", "HCurID", "HDeptID", "HManagerID", "HEmpID", "hsubid", "HMaterID", "HUnitID"];//不需要显示的字段 å¯æ‰©å±•
            //#region ã€è¿‡æ»¤æ–¹æ¡ˆã€‘
@@ -290,6 +339,9 @@
            //#endregion
            //#region åŠ è½½é¡µé¢
            //检测是否具备查看金额权限,设置隐藏列
            checkRight_Money();
            //#region åˆå§‹åŒ–界面
            set_ClearBill();
            //#endregion
@@ -300,7 +352,17 @@
            form.on('submit(btnSearch)', function (data) {
                //标记当前数据为 æŸ¥è¯¢æ•°æ®
                get_needClose_Bar = 0;
                optionPage.curr = 1;
                get_FastQuery(table, option);
            });
            //#endregion
            //#endregion è¾“入框回车监听
            $('input[type="text"]').on('keydown', function (event) {
                if (event.keyCode == 13) {
                    $("#btnSearch").click();
                }
            });
            //#endregion
@@ -308,6 +370,10 @@
            form.on('submit(btnReSearch)', function (data) {
                //清空过滤条件
                set_ClearQuery();
                optionPage.curr = 1;
                get_FastQuery(table, option);
            });
            //#endregion
@@ -348,6 +414,10 @@
                    //下推(生产订单)
                    case 'btn-PushICMOBill':
                        set_PushICMOBill();
                        break;
                    // ä¸‹æŽ¨(出厂检验单)
                    case 'btn-PushOutCompCheckBill':
                        set_PushOutCompCheckBill()
                        break;
                    //多行下推(销售出库单)
                    case 'btn-PushICStockBills':
@@ -447,45 +517,20 @@
            });
            //#endregion
            //#region ç›‘听排序事件
            table.on('sort(mainTable)', function (obj) {
                // èŽ·å–æŽ’åºå­—æ®µå’Œç±»åž‹
                var field = obj.field;
                var type = obj.type;
                //记录过滤条件
                var temp = sWhere_Bak;
                //为过滤条件增加排序
                sWhere_Bak += " order by " + field + " " + (type == "null" ? "" : type) + " ";
                //获取排序后的数据并重新渲染
                var ajaxLoad = layer.load();
                $.ajax({
                    url: GetWEBURL() + '/Xs_SeOrderBill/sortList',
                    async: false,
                    type: "GET",
                    data: { "sWhere": sWhere_Bak, "user": sessionStorage["HUserName"] },
                    success: function (data1) {
                        if (data1.count == 1) {
                            option.data = data1.data;
                            table.render(option);
                            layer.close(ajaxLoad);
                            if ($("#Comparator").val() == 0 && $("#ColContent").val() == "" && $("#Comparator1").val() == 0 && $("#ColContent1").val() == "" && $("#Comparator2").val() == 0 && $("#ColContent2").val() == "") {
                                ColFilter();
                            }
                        } else {
                            layer.close(ajaxLoad);
                            layer.alert(data1.code + data1.Message, { icon: 5 });
                        }
                    }, error: function () {
                        layer.close(ajaxLoad);
                        layer.alert("接口请求失败!", { icon: 5 });
            //#region æŽ’序后选择
            table.on('sort(mainTable)', function (obj) { //注:sort æ˜¯å·¥å…·æ¡äº‹ä»¶åï¼Œtest æ˜¯ table åŽŸå§‹å®¹å™¨çš„å±žæ€§ lay-filter="对应的值"
                table.reload('mainTable', {
                    initSort: obj //记录初始排序,如果不设的话,将无法标记表头的排序状态。 layui 2.1.1 æ–°å¢žå‚æ•°
                    , where: { //请求参数(注意:这里面的参数可任意定义,并非下面固定的格式)
                        field: obj.field //排序字段   åœ¨æŽ¥å£ä½œä¸ºå‚数字段  field order
                        , order: obj.type //排序方式   åœ¨æŽ¥å£ä½œä¸ºå‚数字段  field order
                    }
                });
                sWhere_Bak = temp;
                option.data = layui.table.cache["mainTable"];
                table.render(option);
                //刷新按钮显示
                // var btns = document.getElementsByTagName("button");     //获取本页所有按钮对象
                // Display_HideButton(btns, HBillType, HModName, sessionStorage["HUserName"]);
            });
            //#endregion
@@ -593,12 +638,13 @@
                //初始化表格
                set_InitGrid();
                //查询
                //get_FastQuery();
                //get_Display(sWhere);
                get_FastQuery();
                //初始化页大小
                //DisPlay_HideColumn_GetPageSize(HModName, sessionStorage["HUserName"], optionPage);
                //查询当前登录用户有没有在当前模块设置默认过滤方案
                get_DefaultModule();
                DisPlay_HideColumn();
                //DisPlay_HideColumn();
            }
            //#endregion
@@ -607,15 +653,15 @@
                option = {
                    elem: '#mainTable'
                    , toolbar: '#toolbarDemo'
                    , height: 'full-50'
                    , page: true
                    , height: 'full-80'
                    , page: false
                    , totalRow: true
                    , cellMinWidth: 90
                    , limit: 50
                    , limits: [50, 500, 5000, 20000]
                    //, limits: [50, 500, 5000, 20000]
                    , cols: [[
                        { type: 'checkbox', fixed: 'left' }
                       ,{ field: 'hmainid', title: 'hmainid', sort: true, hide: true }
                        , { field: 'hmainid', title: 'hmainid', sort: true, hide: true }
                        , { field: '日期', title: '日期', width: 125, sort: true }
                        , { field: '单据号', title: '单据号', width: 125, sort: true }
                        , { field: 'hsubid', title: 'hsubid', hide: true, sort: true }
@@ -700,8 +746,8 @@
                        soulTable.render(this);
                        //刷新按钮显示
                        var btns = document.getElementsByTagName("button");     //获取本页所有按钮对象
                        Display_HideButton(btns, HBillType, HModName, sessionStorage["HUserName"]);
                        // var btns = document.getElementsByTagName("button");     //获取本页所有按钮对象
                        // Display_HideButton(btns, HBillType, HModName, sessionStorage["HUserName"]);
                        //循环表数据根据flag状态给行上色
                        //$.each(res['data'], function (i, j) {
@@ -717,9 +763,38 @@
                        //});
                    }
                };
                optionPage = {
                    elem: 'page', //注意,这里的 page æ˜¯ ID,不用加 # å·
                    count: 10000, //数据总数,从服务端得到
                    limit: 50,
                    limits: [50, 500, 5000, 50000],
                    layout: ['count', 'prev', 'page', 'next', 'limit', 'skip'],
                    jump: function (obj, first) {
                        //console.log(obj)
                        //obj包含了当前分页的所有参数,比如:
                        //console.log(obj.curr); //得到当前页,以便向服务端请求对应页的数据。
                        //console.log(obj.limit); //得到每页显示的条数
                        //首次不执行
                        if (!first) {
                            //do something
                            console.log(obj)
                            if (get_needClose_Bar == 0) {
                                get_FastQuery();
                            } else if (get_needClose_Bar == 1) {
                                get_needClose();
                            }
                        }
                    }
                }
                laypage.render(optionPage);
            }
            //#endregion
            //#endregion  ç›‘听网格表体事件
            //#region  ç›‘听网格表体事件
            table.on('tool(mainTable)', function (obj) {
                var data = obj.data;
@@ -735,7 +810,7 @@
                        , shade: 0.6 //遮罩透明度
                        , maxmin: true //允许全屏最小化
                        , anim: 0 //0-6的动画形式,-1不开启
                        , content: '../../销售管理/销售订单/Add_Edit_Xs_SeOrderBillList.html?OperationType=3&linterid='+linterid+'& HSouceBillType=0&closeType=1'  //设置 iframe çš„ URL,URL ä¸­åŒ…含了查询参数,来调用所需要的值
                        , content: '../../销售管理/销售订单/Add_Edit_Xs_SeOrderBillList.html?OperationType=3&linterid=' + linterid + '& HSouceBillType=0&closeType=1'  //设置 iframe çš„ URL,URL ä¸­åŒ…含了查询参数,来调用所需要的值
                        , resize: false,  //是否允许用户调整弹出大小
                        end: function () {  //当关闭时调用
@@ -747,7 +822,8 @@
                    })
                }
            });
             //#endregion
            //#endregion
            //#region è¿›å…¥é¡µé¢æ˜¾ç¤ºçš„缓存列表
            function get_Display(sWhere) {
                var ajaxLoad = layer.load();
@@ -757,81 +833,129 @@
                    type: "GET",
                    data: { "sWhere": sWhere, "user": sessionStorage["HUserName"] },
                    success: function (data1) {
                        if (data1.count == 1) {
                            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', totalRowText: '合计' });
                            //设置列表同一个单据只有第一条数据显示主表信息,其它记录只显示子表信息
                            //获取子表列数据
                            var colList = [];
                            for (var i = 0; i < option.cols[0].length; i++) {
                                colList.push(option.cols[0][i].field);
                            }
                            for (var i = 0; i < data.length; i++) {//遍历data数组重的数据
                                // if (data[i].name == 'HInterID' || data[i].name == 'HBillType' || data[i].name == 'hmainid') {
                                if ($.inArray(data[i].name, titleData) > -1) {//检查data【i】.name是否在数组中  //计算列
                                    col.push({ field: data[i].id, title: data[i].name, align: 'center', hide: true }); //隐藏id列
                        if (data1.count != 0) {
                            if (data1.data.length == 0) {
                                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 });//从每个对象中提取数据
                                }
                                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 if (data[i].name == '单据号') {
                                    col.push({
                                        field: data[i].id, title: data[i].name, align: 'center', sort: true, width: 200, event: '单据号'
                                        , event: '单据号', templet: function (d) {
                                            return '<span style="color: blue;">' + d.单据号 + '</span>'
                                        }, style: 'cursor: pointer;' });
                                } 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 == "行关闭日期" ? "行关闭人" : data[i].name) + " ==''?'':layui.util.toDateString(d." + data[i].name + ", 'yyyy-MM-dd HH:mm:ss')}}</div>", width: 200 });
                                            break;
                                        default:
                                            col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, width: 200 });
                                col.push({ type: 'checkbox', fixed: 'left', totalRowText: '合计' });
                                //设置列表同一个单据只有第一条数据显示主表信息,其它记录只显示子表信息
                                //获取子表列数据
                                var colList = [];
                                for (var i = 0; i < option.cols[0].length; i++) {
                                    colList.push(option.cols[0][i].field);
                                }
                                for (var i = 0; i < data.length; i++) {//遍历data数组重的数据
                                    // if (data[i].name == 'HInterID' || data[i].name == 'HBillType' || data[i].name == 'hmainid') {
                                    if ($.inArray(data[i].name, titleData) > -1) {//检查data【i】.name是否在数组中  //计算列
                                        col.push({ field: data[i].id, title: data[i].name, align: 'center', hide: true }); //隐藏id列
                                    }
                                    else if ($.inArray(data[i].name, totalArray) > -1 || (data[i].Type == "Decimal" || data[i].Type == "Int32")) { //计算列
                                        col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, totalRow: true, width: 120 });
                                    } else if (data[i].name == '单据号') {
                                        col.push({
                                            field: data[i].id, title: data[i].name, align: 'center', sort: true, width: 200, event: '单据号'
                                            , event: '单据号', templet: function (d) {
                                                return '<span style="color: blue;">' + d.单据号 + '</span>'
                                            }, style: 'cursor: pointer;'
                                        });
                                    } 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 == "行关闭日期" ? "行关闭人" : data[i].name) + " ==''?'':layui.util.toDateString(d." + data[i].name + ", 'yyyy-MM-dd HH:mm:ss')}}</div>", width: 200 });
                                                break;
                                            default:
                                                col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, width: 200 });
                                        }
                                    }
                                }
                            }
                            //动态显示列名
                            option = {
                                elem: '#mainTable'
                                , toolbar: '#toolbarDemo'
                                , cols: [col]
                                , data: data1.data
                                , height: 800
                                , page: true
                                , totalRow: true
                                , cellMinWidth: 90
                                , limit: 50
                                , limits: [50, 500, 5000, 20000]
                                , done: function (res, curr, count) {
                                    soulTable.render(this);
                                option.cols = [col];
                                option.data = [];
                                ins = table.render(option);
                            } else {
                                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 });//从每个对象中提取数据
                                }
                            }
                            //设置数据
                            var result = data1.data;
                            var temp = "";
                            for (var i = 0; i < result.length; i++) {
                                if (temp != result[i]["hmainid"]) {
                                    temp = result[i]["hmainid"];
                                } else {
                                    var initIndex = $.inArray("hmainid", colList);
                                    var lastIndex = $.inArray("hsubid", colList);
                                    for (var j = initIndex + 1; j < lastIndex; j++) {
                                        var fieldName = colList[j];
                                        result[i][fieldName] = "";
                                col.push({ type: 'checkbox', fixed: 'left', totalRowText: '合计' });
                                //设置列表同一个单据只有第一条数据显示主表信息,其它记录只显示子表信息
                                //获取子表列数据
                                var colList = [];
                                for (var i = 0; i < option.cols[0].length; i++) {
                                    colList.push(option.cols[0][i].field);
                                }
                                for (var i = 0; i < data.length; i++) {//遍历data数组重的数据
                                    // if (data[i].name == 'HInterID' || data[i].name == 'HBillType' || data[i].name == 'hmainid') {
                                    if ($.inArray(data[i].name, titleData) > -1) {//检查data【i】.name是否在数组中  //计算列
                                        col.push({ field: data[i].id, title: data[i].name, align: 'center', hide: true }); //隐藏id列
                                    }
                                    else if ($.inArray(data[i].name, totalArray) > -1 || (data[i].Type == "Decimal" || data[i].Type == "int")) { //计算列
                                        col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, totalRow: true, width: 120 });
                                    } else if (data[i].name == '单据号') {
                                        col.push({
                                            field: data[i].id, title: data[i].name, align: 'center', sort: true, width: 200, event: '单据号'
                                            , event: '单据号', templet: function (d) {
                                                return '<span style="color: blue;">' + d.单据号 + '</span>'
                                            }, style: 'cursor: pointer;'
                                        });
                                    } 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 == "行关闭日期" ? "行关闭人" : data[i].name) + " ==''?'':layui.util.toDateString(d." + data[i].name + ", 'yyyy-MM-dd HH:mm:ss')}}</div>", width: 200 });
                                                break;
                                            default:
                                                col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, width: 200 });
                                        }
                                    }
                                }
                                //动态显示列名
                                option = {
                                    elem: '#mainTable'
                                    , toolbar: '#toolbarDemo'
                                    , cols: [col]
                                    , data: data1.data
                                    , height: 800
                                    , page: true
                                    , totalRow: true
                                    , cellMinWidth: 90
                                    , limit: 50
                                    , limits: [50, 500, 5000, 20000]
                                    , done: function (res, curr, count) {
                                        soulTable.render(this);
                                    }
                                }
                                //设置数据
                                var result = data1.data;
                                var temp = "";
                                for (var i = 0; i < result.length; i++) {
                                    if (temp != result[i]["hmainid"]) {
                                        temp = result[i]["hmainid"];
                                    } else {
                                        var initIndex = $.inArray("hmainid", colList);
                                        var lastIndex = $.inArray("hsubid", colList);
                                        for (var j = initIndex + 1; j < lastIndex; j++) {
                                            var fieldName = colList[j];
                                            result[i][fieldName] = "";
                                        }
                                    }
                                }
                                option.data = result;
                                ins = table.render(option);
                            }
                            option.data = result;
                            ins = table.render(option);
                            layer.close(ajaxLoad);
                            DisPlay_HideColumn();
@@ -851,11 +975,105 @@
            }
            //#endregion
            //#region æŸ¥è¯¢-分页
            function get_DisplayPage(sWhere) {
                var wait = layer.load();//遮罩
                var ajaxLoad = layer.load();
                $.ajax({
                    url: GetWEBURL() + '/Xs_SeOrderBill/list_ByPage',
                    type: "GET",
                    data: { "sWhere": sWhere, "user": sessionStorage["HUserName"], "Organization": Organization, "page": optionPage.curr, "size": optionPage.limit },
                    success: function (data1) {
                        option.limit = optionPage.limit;//改变表格页大小
                        if (data1.code == 1) {
                            optionPage.count = data1.count;//改变列表数据总数
                            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', totalRowText: '合计' });
                            //设置列表同一个单据只有第一条数据显示主表信息,其它记录只显示子表信息
                            //获取子表列数据
                            var colList = [];
                            for (var i = 0; i < option.cols[0].length; i++) {
                                colList.push(option.cols[0][i].field);
                            }
                            for (var i = 0; i < data.length; i++) {//遍历data数组重的数据
                                // if (data[i].name == 'HInterID' || data[i].name == 'HBillType' || data[i].name == 'hmainid') {
                                if ($.inArray(data[i].name, titleData) > -1) {//检查data【i】.name是否在数组中  //计算列
                                    col.push({ field: data[i].id, title: data[i].name, align: 'center', hide: true }); //隐藏id列
                                }
                                else if ($.inArray(data[i].name, totalArray) > -1 || (data[i].Type == "Decimal" || data[i].Type == "int")) { //计算列
                                    col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, totalRow: true, width: 120 });
                                } else if (data[i].name == '单据号') {
                                    col.push({
                                        field: data[i].id, title: data[i].name, align: 'center', sort: true, width: 200, event: '单据号'
                                        , event: '单据号', templet: function (d) {
                                            return '<span style="color: blue;">' + d.单据号 + '</span>'
                                        }, style: 'cursor: pointer;'
                                    });
                                } 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 == "行关闭日期" ? "行关闭人" : data[i].name) + " ==''?'':layui.util.toDateString(d." + data[i].name + ", 'yyyy-MM-dd HH:mm:ss')}}</div>", width: 200 });
                                            break;
                                        default:
                                            col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, width: 200 });
                                    }
                                }
                            }
                            option.cols = [col];
                            option.data = data1.data;
                            //设置数据
                            var result = data1.data;
                            var temp = "";
                            for (var i = 0; i < result.length; i++) {
                                if (temp != result[i]["hmainid"]) {
                                    temp = result[i]["hmainid"];
                                } else {
                                    var initIndex = $.inArray("hmainid", colList);
                                    var lastIndex = $.inArray("hsubid", colList);
                                    for (var j = initIndex + 1; j < lastIndex; j++) {
                                        var fieldName = colList[j];
                                        result[i][fieldName] = "";
                                    }
                                }
                            }
                            option.data = result;
                            ins = table.render(option);
                            laypage.render(optionPage);
                            //刷新表格数据
                            DisPlay_HideColumn();
                            layer.close(ajaxLoad);
                            if ($("#ColName option").length < 1) {
                                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(table, option) {
                var HDate = $("#HBeginDate").val();//开始日期
                var HDate1 = $("#HEndDate").val();//结束日期
                var HBillNo = $("#HBillNo").val();//单据号
                var HProjectNumber = $("#HProjectNumber").val(); //项目编号
                var HCusID = $("#HCusID").val();
                var HMaterNumber = $("#HMaterNumber").val();
                var HMaterName = $("#HMaterName").val();
@@ -876,19 +1094,19 @@
                    var com = "";
                    switch (Comparator) {
                        case "7":
                            com = "like'%" + ColContent + "%'";
                            com = "like ''%" + ColContent + "%''";
                            break;
                        case "8":
                            com = "like'%" + ColContent + "'";
                            com = "like ''%" + ColContent + "''";
                            break;
                        case "9":
                            com = "like'" + ColContent + "%'";
                            com = "like ''" + ColContent + "%''";
                            break;
                        case "10":
                            com = "not like'%" + ColContent + "%'";
                            com = "not like ''%" + ColContent + "%''";
                            break;
                        default:
                            com = "" + Comparator + "'" + ColContent + "'";
                            com = "" + Comparator + "''" + ColContent + "''";
                            break;
                    }
                    sWhere += " and " + ColName + " " + com;
@@ -898,19 +1116,19 @@
                    var com1 = "";
                    switch (Comparator1) {
                        case "7":
                            com1 = "like'%" + ColContent1 + "%'";
                            com1 = "like ''%" + ColContent1 + "%''";
                            break;
                        case "8":
                            com1 = "like'%" + ColContent1 + "'";
                            com1 = "like ''%" + ColContent1 + "''";
                            break;
                        case "9":
                            com1 = "like'" + ColContent1 + "%'";
                            com1 = "like ''" + ColContent1 + "%''";
                            break;
                        case "10":
                            com1 = "not like'%" + ColContent1 + "%'";
                            com1 = "not like ''%" + ColContent1 + "%''";
                            break;
                        default:
                            com1 = "" + Comparator1 + "'" + ColContent1 + "'";
                            com1 = "" + Comparator1 + "''" + ColContent1 + "''";
                            break;
                    }
                    sWhere += " and " + ColName1 + " " + com1;
@@ -920,41 +1138,44 @@
                    var com2 = "";
                    switch (Comparator2) {
                        case "7":
                            com2 = "like'%" + ColContent2 + "%'";
                            com2 = "like ''%" + ColContent2 + "%''";
                            break;
                        case "8":
                            com2 = "like'%" + ColContent2 + "'";
                            com2 = "like ''%" + ColContent2 + "''";
                            break;
                        case "9":
                            com2 = "like'" + ColContent2 + "%'";
                            com2 = "like ''" + ColContent2 + "%''";
                            break;
                        case "10":
                            com2 = "not like'%" + ColContent2 + "%'";
                            com2 = "not like ''%" + ColContent2 + "%''";
                            break;
                        default:
                            com2 = "" + Comparator2 + "'" + ColContent2 + "'";
                            com2 = "" + Comparator2 + "''" + ColContent2 + "''";
                            break;
                    }
                    sWhere += " and " + ColName2 + " " + com2;
                }
                if (HDate) {
                    sWhere += " and CONVERT(varchar(100),日期, 23) >= '" + HDate + "'";
                    sWhere += " and CONVERT(varchar(100),日期, 23) >= ''" + HDate + "''";
                }
                if (HDate1) {
                    sWhere += " and CONVERT(varchar(100),日期, 23) <= '" + HDate1 + "'";
                    sWhere += " and CONVERT(varchar(100),日期, 23) <= ''" + HDate1 + "''";
                }
                if (HBillNo) {
                    sWhere += " and å•据号 like '%" + HBillNo + "%'";
                    sWhere += " and å•据号 like ''%" + HBillNo + "%''";
                }
                if (HProjectNumber) {
                    sWhere += " and é¡¹ç›®ç¼–码 like ''%" + HProjectNumber + "%''";
                }
                if (HCusID) {
                    sWhere += " and å®¢æˆ· like '%" + HCusID + "%'";
                    sWhere += " and å®¢æˆ· like ''%" + HCusID + "%''";
                }
                if (HMaterNumber) {
                    sWhere += " and ç‰©æ–™ä»£ç  like '%" + HMaterNumber + "%'";
                    sWhere += " and ç‰©æ–™ä»£ç  like ''%" + HMaterNumber + "%''";
                }
                if (HMaterName) {
                    sWhere += " and ç‰©æ–™åç§° like '%" + HMaterName + "%'";
                    sWhere += " and ç‰©æ–™åç§° like ''%" + HMaterName + "%''";
                }
                if (GetDataCols != "") {
                    sWhere += GetDataCols;
@@ -967,7 +1188,12 @@
                sWhere_Bak = sWhere;
                get_Display(sWhere);
                //普通查询
                //get_Display(sWhere);
                //分页查询
                get_DisplayPage(sWhere);
                sWhere = "";//调用接口后清空sWhere缓存
                GetDataCols = "";
            }
@@ -979,6 +1205,7 @@
                $("#HBeginDate").val(Format(new Date(new Date() - 1000 * 60 * 60 * 24 * HInitTimeCycle), "yyyy-MM-dd")); //开始日期
                $("#HEndDate").val(Format(new Date(), "yyyy-MM-dd"));  //结束日期
                $("#HBillNo").val("");//
                $("#HProjectNumber").val("");
                $("#HCusID").val("");
                $("#HMaterNumber").val("");
                $("#HMaterName").val("");
@@ -1299,6 +1526,39 @@
            }
            //#endregion
            //#region ä¸‹æŽ¨ å‡ºåŽ‚æ£€éªŒå•
            function set_PushOutCompCheckBill() {
                var checkStatus = table.checkStatus('mainTable')
                    , data = checkStatus.data;
                if (data.length != 1) {
                    return layer.msg("请选择一行单据下推")
                }
                debugger
                var linterid = data[0]['hmainid']
                var hsubid = data[0]['hsubid']
                layer.open({
                    type: 2
                    , area: ['100%', '100%']
                    , title: '销售订单-下推出厂检验单'
                    , shift: 0//弹出动画
                    , content: '../../质量管理/出厂检验单/QC_OutCompCheckBill.html?operationType=2&linterid=' + linterid
                    + "&HSouceBillType="+ HBillType + "&HICMOEntryID=&HEntryID="+ hsubid
                    , btn: [],
                    // æŒ‰é’®1 çš„回调
                    end: function (index, layero, that) {
                        ////修改为功后刷新界面
                        //if (get_needClose_Bar == 0) {
                        //    $("#btnSearch").trigger('click');
                        //} else if (get_needClose_Bar == 1) {
                        //    $("#get_needClose").trigger('click');
                        //}
                    }
                })
            }
            //#endregion
            //#region å¤šè¡Œä¸‹æŽ¨ï¼ˆé”€å”®å‡ºåº“单)
            function set_PushICStockBills() {
                var checkStatus = table.checkStatus('mainTable')
@@ -1535,27 +1795,83 @@
            function get_needClose() {
                //记录过滤条件
                var temp = sWhere_Bak;
                if (get_needClose_Bar == 0) {
                    //设置页数为1
                    optionPage.curr = 1;
                }
                //标记当前数据为 å¾…关闭项
                get_needClose_Bar = 1;
                //为过滤条件增加排序
                sWhere_Bak += " and å‰©ä½™è®¢é‡‘>0 and å‰©ä½™è®¢é‡‘<=1000 and å…³é—­äºº='' and è¡Œå…³é—­äºº='' and çŠ¶æ€ = '已审核' and HCusID <> 166351 order by å•据号 desc";
                //sWhere_Bak += " and å‰©ä½™è®¢é‡‘>0 and å‰©ä½™è®¢é‡‘<=1000 and å…³é—­äºº='' and è¡Œå…³é—­äºº='' and çŠ¶æ€ = '已审核' and HCusID <> 166351 order by å•据号 desc";
                //获取排序后的数据并重新渲染
                var ajaxLoad = layer.load();
                $.ajax({
                    url: GetWEBURL() + '/Xs_SeOrderBill/sortList',
                    url: GetWEBURL() + '/Xs_SeOrderBill/sortList__ByPage',
                    async: false,
                    type: "GET",
                    data: { "sWhere": sWhere_Bak, "user": sessionStorage["HUserName"] },
                    data: { "sWhere": sWhere, "user": sessionStorage["HUserName"], "Organization": Organization, "page": optionPage.curr, "size": optionPage.limit },
                    success: function (data1) {
                        if (data1.count == 1) {
                        option.limit = optionPage.limit;//改变表格页大小
                        if (data1.count != 0) {
                            optionPage.count = data1.count;//改变列表数据总数
                            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', totalRowText: '合计' });
                            //设置列表同一个单据只有第一条数据显示主表信息,其它记录只显示子表信息
                            //获取子表列数据
                            var colList = [];
                            for (var i = 0; i < option.cols[0].length; i++) {
                                colList.push(option.cols[0][i].field);
                            }
                            for (var i = 0; i < data.length; i++) {//遍历data数组重的数据
                                // if (data[i].name == 'HInterID' || data[i].name == 'HBillType' || data[i].name == 'hmainid') {
                                if ($.inArray(data[i].name, titleData) > -1) {//检查data【i】.name是否在数组中  //计算列
                                    col.push({ field: data[i].id, title: data[i].name, align: 'center', hide: true }); //隐藏id列
                                }
                                else if ($.inArray(data[i].name, totalArray) > -1 || (data[i].Type == "Decimal" || data[i].Type == "int")) { //计算列
                                    col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, totalRow: true, width: 120 });
                                } else if (data[i].name == '单据号') {
                                    col.push({
                                        field: data[i].id, title: data[i].name, align: 'center', sort: true, width: 200, event: '单据号'
                                        , event: '单据号', templet: function (d) {
                                            return '<span style="color: blue;">' + d.单据号 + '</span>'
                                        }, style: 'cursor: pointer;'
                                    });
                                } 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 == "行关闭日期" ? "行关闭人" : data[i].name) + " ==''?'':layui.util.toDateString(d." + data[i].name + ", 'yyyy-MM-dd HH:mm:ss')}}</div>", width: 200 });
                                            break;
                                        default:
                                            col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, width: 200 });
                                    }
                                }
                            }
                            //动态显示列名
                            option = {
                                elem: '#mainTable'
                                , toolbar: '#toolbarDemo'
                                , cols: [col]
                                , data: data1.data
                                , height: 800
                                //, page: true
                                , totalRow: true
                                , cellMinWidth: 90
                                , limit: 50
                                , limits: [50, 500, 5000, 20000]
                                , done: function (res, curr, count) {
                                    soulTable.render(this);
                                }
                            }
                            //设置数据
                            var result = data1.data;
@@ -1575,15 +1891,21 @@
                            option.data = result;
                            table.render(option);
                            layer.close(ajaxLoad);
                            ins = table.render(option);
                            laypage.render(optionPage);
                            //刷新表格数据
                            DisPlay_HideColumn();
                            if ($("#Comparator").val() == 0 && $("#ColContent").val() == "" && $("#Comparator1").val() == 0 && $("#ColContent1").val() == "" && $("#Comparator2").val() == 0 && $("#ColContent2").val() == "") {
                            layer.close(ajaxLoad);
                            if ($("#ColName option").length < 1) {
                                ColFilter();
                            }
                            //layer.alert("查询成功", { icon: 1 });
                        } else {
                            option.data = [];
                            table.render(option);
                            layer.close(ajaxLoad);
                            layer.alert(data1.code + data1.Message, { icon: 5 });
                            /*layer.alert(data1.code + data1.Message, { icon: 5 });*/
                        }
                    }, error: function () {
                        layer.close(ajaxLoad);
@@ -1611,7 +1933,7 @@
                    $.ajax({
                        type: "GET",
                        url: GetWEBURL() + "/Xs_SeOrderBill/StartCheckFlow_SeOrderBIll", //方法所在页面和方法名
                        data: { "HInterID": InterID,"CurUserName": sessionStorage["HUserName"] },
                        data: { "HInterID": InterID, "CurUserName": sessionStorage["HUserName"] },
                        success: function (result) {
                            if (result.count == 1) {
                                layer.msg(result.Message, { time: 1 * 1000, icon: 1 }, function () {
@@ -2009,8 +2331,10 @@
                    , content: ['../../基础资料/隐藏列设置/Gy_GridView_Hide.html?HModName=' + HModName + '&colName=' + colName, "yes"]
                    , btn: ["确定", "取消"]
                    , btn1: function (index, laero) {
                        //刷新表格数据
                        DisPlay_HideColumn();
                        //初始化页大小
                        DisPlay_HideColumn_GetPageSize(HModName, sessionStorage["HUserName"], optionPage);
                        //直接执行列表筛选 åŠ è½½æ•°æ®åˆ°ç½‘æ ¼
                        get_FastQuery()
                        //更新表格缓存的数据
                        layer.close(index);//关闭弹窗
                    }
@@ -2021,18 +2345,21 @@
            function DisPlay_HideColumn() {
                $.ajax({
                    url: GetWEBURL() + '/Xt_grdAlignment_WMES/grdAlignmentWMESList',
                    async:false,
                    async: false,
                    type: "GET",
                    data: { "HModName": HModName, "user": sessionStorage["HUserName"] },
                    success: function (data1) {
                        if (data1.data.length != 0) {
                            var dataCol = [];//数据库查询出的列数据
                            var titleData = ["hmainid", "HBillType", "HCusID", "HSSID", "HCurID", "HDeptID", "HManagerID", "HEmpID", "hsubid", "HMaterID","HUnitID"];//不需要显示的字段 å¯æ‰©å±•
                            //var titleData = ["hmainid", "HBillType", "HCusID", "HSSID", "HCurID", "HDeptID", "HManagerID", "HEmpID", "hsubid", "HMaterID","HUnitID"];//不需要显示的字段 å¯æ‰©å±•
                            dataCol = data1.data[0].HGridString.split(',');
                            for (var i = 0; i < option.cols[0].length - 1; i++) {
                                if (i >= dataCol.length) {
                                    continue;
                                }
                                var dataCols = dataCol[i].split('|');
                                //隐藏列
                                if (dataCols[1] == 1) {
@@ -2089,6 +2416,15 @@
                                    option.cols[0][i + 1]["fixed"] = "left";
                                }
                            }
                            //设置列排序
                            for (var i = 1; i < option.cols[0].length; i++) {
                                if (data1.data[0].HSortFlag == "是") {
                                    option.cols[0][i]["sort"] = true;
                                }
                                else {
                                    option.cols[0][i]["sort"] = false;
                                }
                            }
                            table.render(option);
                            //刷新按钮显示
@@ -2133,6 +2469,7 @@
                $.ajax({
                    url: GetWEBURL() + '/Xt_FastICScheme/Chooselist',
                    type: "GET",
                    async: false,
                    data: { "user": sessionStorage["Czybm"], "HModuleName": HModuleName, "HInterID": 0, "Type": "Default" },
                    success: function (data1) {
                        if (data1.count == 1) {
@@ -2177,7 +2514,7 @@
                                //$("#HBeginDate").val(HBeginDate);
                                //执行查询方法
                                get_FastQuery();
                                // get_FastQuery();
                            } else {
                                //$('#HBeginDate').prop('disabled', false);
                                //$('#HEndDate').prop('disabled', false);
@@ -2191,7 +2528,7 @@
                            //隐藏显示过滤方案的标签信息
                            document.getElementById("HFilterScheme_Now").style.display = "none";
                            //执行查询方法
                            get_FastQuery()
                            //get_FastQuery()
                            form.render("select");
                        }
                    }, error: function () {
@@ -2377,7 +2714,7 @@
                }
                colName = encodeURI(colName.substring(0, colName.length - 1));//对 URI è¿›è¡Œç¼–码
               var HModBillName = "h_v_IF_SeOrderBillList";//等于该列表的视图
                var HModBillName = "h_v_IF_SeOrderBillList";//等于该列表的视图
                contentUrl += '基础资料/隐藏列设置/Gy_QueryCondition.html?HModName=' + HModBillName + '&colName=' + colName;
@@ -2400,9 +2737,9 @@
                        var myIframe = window[laero.find('iframe')[0]['name']];
                        GetDataCols += "and (";
                        for (var i = 0; i < checkStatus.length; i++) {
                            GetDataCols += myIframe.get_FastQuery(checkStatus[i]) ; //get_FastQuery()为子页面的方法
                            GetDataCols += myIframe.get_FastQuery(checkStatus[i]); //get_FastQuery()为子页面的方法
                            if ((i + 1) < checkStatus.length) {
                                GetDataCols += " " + checkStatus[i]["HRelationCol"]+" ";
                                GetDataCols += " " + checkStatus[i]["HRelationCol"] + " ";
                            }
                        }
                        GetDataCols += ")";
@@ -2441,8 +2778,8 @@
            //#region åˆå§‹æ—¥æœŸé—´éš” ä¸‹æ‹‰åˆ—表
            function setSelect_HInitTimeCycle() {
                var valueList = [0, 1, 2, 3, 4, 5, 6, 29];
                var titleList = ["今天", "近两天", "近三天", "近四天", "近五天", "近六天", "近七天", "近30天"];
                var valueList = [0, 1, 2, 3, 4, 5, 6, 29, 180, 365];
                var titleList = ["今天", "近两天", "近三天", "近四天", "近五天", "近六天", "近七天", "近30天", "近半年", "近一年"];
                var HInitTimeCycle_ArrayList = '<option  value="-1" selected="selected" >任意间隔</option>';
                for (var i = 0; i < valueList.length; i++) {
@@ -2477,7 +2814,31 @@
                        layer.alert("接口请求失败!", { icon: 5 });
                    }
                });
                res = res.replace(/'/g, "''");
                return res;
            }
            //#endregion
            //#region æŸ¥çœ‹æ˜¯å¦å…·å¤‡æŸ¥çœ‹é‡‘额权限,设置金额等字段是否需要隐藏
            function checkRight_Money() {
                $.ajax({
                    type: "GET",
                    async: false,
                    url: GetWEBURL() + "/Xs_SeOrderBill/CheckRight_Money", //方法所在页面和方法名
                    data: { "user": sessionStorage["HUserName"] },
                    success: function (result) {
                        if (result.count == 1) {
                        } else {
                            var HideColumnList = ["剩余订金", "单价", "税率", "含税单价", "金额", "价税合计"];
                            for (var i = 0; i < HideColumnList.length; i++) {
                                titleData.push(HideColumnList[i]);
                            }
                        }
                    }, error: function (err) {
                        layer.alert("接口请求失败!", { icon: 5 });
                    }
                });
            }
            //#endregion
@@ -2503,7 +2864,7 @@
                var addSWhere = "";
                if (openType == 2) {
                    addSWhere = " and çŠ¶æ€ = '已审核' and è¡ŒçŠ¶æ€ = '' and HOrgID = " + HOrgID;
                    addSWhere = " and çŠ¶æ€ = ''已审核'' and è¡ŒçŠ¶æ€ = '''' and HOrgID = " + HOrgID;
                }
                return addSWhere;
            }
@@ -2558,4 +2919,5 @@
    </script>
</body>
</html>
</html>