发货通知单及时库存显示,考勤汇报单导出,添加应付单待审核清单

wtt

2024-12-09 6851086303e05a1e468960f8527a9365c20c8179

发货通知单及时库存显示,考勤汇报单导出,添加应付单待审核清单

 WebTM/WebTM.csproj

@@ -653,6 +653,7 @@
    <Content Include="views\车间管理\报表分析\Kf_PressurizedWaterNoOutReport.html" />
    <Content Include="views\采购管理\付款单\YF_PayMentBillQuery.html" />
    <Content Include="views\采购管理\应付单\Cg_PayableBillQuery.html" />
    <Content Include="views\采购管理\应付单\Cg_PayableBillCheckQuery.html" />
    <Content Include="views\采购管理\收料通知单\Cg_POInStockBillQuery.html" />
    <Content Include="views\采购管理\采购报表\Gy_SupplierPayPlanReport.html" />
    <Content Include="views\采购管理\采购合同\Add_Edit_Cg_ContractBillList.html" />

 WebTM/views/¹¤×ʹÜÀí/¿¼Çڻ㱨µ¥/Pay_WorkTimesBillList.html

@@ -422,10 +422,10 @@
                                    }
                                }
                            }
                            table.render(option);
                            ins = table.render(option);
                            
                        } else {
                            table.render(option);
                            ins = table.render(option);
                            
                        }
                        //刷新按钮显示
@@ -591,7 +591,127 @@

            //#region å¯¼å‡ºExecel
            function btn_Export() {
                table.exportFile(ins.config.id, option.data, "xls");
                var data;
                var ajaxLoad = layer.load();
                //设置sWhere
                var HBeginDate = $("#HBeginDate").val();//开始日期
                var HEndDate = $("#HEndDate").val();//结束日期
                var HBillNo = $("#HBillNo").val();//单据号
                var ColName = $("#ColName").val();//复选框
                var Comparator = $("#Comparator").val()
                var ColContent = $("#ColContent").val();

                var ColName1 = $("#ColName1").val();//复选框
                var Comparator1 = $("#Comparator1").val()
                var ColContent1 = $("#ColContent1").val();
                var ColName2 = $("#ColName2").val();//复选框
                var Comparator2 = $("#Comparator2").val()
                var ColContent2 = $("#ColContent2").val();

                if (ColName != 0 && Comparator != 0) {
                    var com = "";
                    switch (Comparator) {
                        case "7":
                            com = "like'%" + ColContent + "%'";
                            break;
                        case "8":
                            com = "like'%" + ColContent + "'";
                            break;
                        case "9":
                            com = "like'" + ColContent + "%'";
                            break;
                        case "10":
                            com = "not like'%" + ColContent + "%'";
                            break;
                        default:
                            com = "" + Comparator + "'" + ColContent + "'";
                            break;
                    }
                    sWhere += " and " + ColName + " " + com;
                }
                if (ColName1 != 0 && Comparator1 != 0) {
                    var com1 = "";
                    switch (Comparator1) {
                        case "7":
                            com1 = "like'%" + ColContent1 + "%'";
                            break;
                        case "8":
                            com1 = "like'%" + ColContent1 + "'";
                            break;
                        case "9":
                            com1 = "like'" + ColContent1 + "%'";
                            break;
                        case "10":
                            com1 = "not like'%" + ColContent1 + "%'";
                            break;
                        default:
                            com1 = "" + Comparator1 + "'" + ColContent1 + "'";
                            break;
                    }
                    sWhere += " and " + ColName1 + " " + com1;
                }
                if (ColName2 != 0 && Comparator2 != 0) {
                    var com2 = "";
                    switch (Comparator2) {
                        case "7":
                            com2 = "like'%" + ColContent2 + "%'";
                            break;
                        case "8":
                            com2 = "like'%" + ColContent2 + "'";
                            break;
                        case "9":
                            com2 = "like'" + ColContent2 + "%'";
                            break;
                        case "10":
                            com2 = "not like'%" + ColContent2 + "%'";
                            break;
                        default:
                            com2 = "" + Comparator + "'" + ColContent + "'";
                            break;
                    }
                    sWhere += " and " + ColName2 + " " + com2;
                }
                if (HBeginDate) {
                    sWhere += " and æ—¥æœŸ >= '" + HBeginDate + "'";
                }
                if (HEndDate) {
                    sWhere += " and æ—¥æœŸ <= '" + HEndDate + "'";
                }
                if (HBillNo) {
                    sWhere += " and å•æ®å· like '%" + HBillNo + "%'";
                }
                $.ajax({
                    type: "GET",
                    url: GetWEBURL() + '/Pay_WorkTimesBillController/GetPay_WorkTimesBillList_Json',
                    async: false,    //async用于控制（false）同步和（true）异步，默认的是true，即请求默认的是异步请求
                    data: { "sWhere": sWhere, "HMaker": HMaker },
                    success: function (data1) {
                        if (data1.count == 1) {
                            data = data1.data
                            layer.close(ajaxLoad);
                        } else {
                            layer.close(ajaxLoad);
                            layer.alert(data1.Message, { icon: 5 });
                        }
                    },
                    error: function () {
                        layer.close(ajaxLoad);
                        layer.alert("接口请求失败!", { icon: 5 });
                    }
                });
                sWhere = "";
                data.forEach((item) => {
                    for (let itemobj in item) {
                        if (item[itemobj] == null) {
                            item[itemobj] = "";
                        }
                        if (item[itemobj].length > 0) {  // å‡è®¾å­—段名为field
                            item[itemobj] = item[itemobj].toString().replaceAll(/[\r\n]+/g, '');  // å°†æ¢è¡Œç¬¦æ›¿æ¢ä¸ºç©ºå­—符串
                        }
                    }
                });

                table.exportFile(ins.config.id, data, "xls");
            }
            //#endregion


 WebTM/views/²É¹º¹ÜÀí/Ó¦¸¶µ¥/Cg_PayableBillCheckQuery.html

New file
@@ -0,0 +1,1005 @@
<!DOCTYPE html>
<html>
<head>
    <meta charset="utf-8" />
    <title>应付单待审核清单</title>
    <meta name="renderer" content="webkit">
    <meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1">
    <meta name="viewport" content="width=device-width, initial-scale=1.0, minimum-scale=1.0, maximum-scale=1.0, user-scalable=0">
    <!--引用layui样式文件-->
    <link rel="stylesheet" href="../../../layuiadmin/layui/css/layui.css" media="all">
    <link rel="stylesheet" href="../../../layuiadmin/style/admin.css" media="all">
    <!--引用layui js文件-->
    <script src="../../../layuiadmin/layui/layui.js"></script>
    <script src="../../../layuiadmin/Scripts/json2.js"></script>
    <script src="../../../layuiadmin/Scripts/jquery-1.4.1.js"></script>
    <script src="../../../layuiadmin/Scripts/webConfig.js"></script>
    <script src="../../../layuiadmin/PubCustom.js"></script>
    <script src="../../../layuiadmin/zgqCustom/zgqCustom.js"></script>
    <script src="../../../layuiadmin/PageTitle.js"></script>
    <script src="../../../layuiadmin/HideButton.js"></script>
    <style type="text/css">
        .layui-form-label {
            width: 85px;
        }

        .maintitle {
            background-color: #1492ff;
            color: #fff;
            padding: 5px 10px;
            border: none;
            border-radius: 4px;
        }

        .title {
            border-left: 4px solid #1492ff;
            padding-left: 6px;
            margin: 20px 10px 4px;
            font-size: 16px;
            color: #333;
        }

        .buttom_box_little {
            width: 60px;
            height: 36px;
            color: #fff;
            background-color: #1492ff;
            border-radius: 4px;
            border: none;
            margin: 10px;
        }

        .layui-input {
            width: 93%;
        }

        .layui-inline, img {
            display: block;
            vertical-align: middle
        }

        .layui-input, .layui-textarea {
            display: inline-block;
            width: 100%;
            padding-left: 10px;
        }

        .laydate-time-list ol {
            overflow-x: hidden !important;
            overflow-y: auto !important;
        }

        .layui-form-label {
            padding: 9px 5px;
        }

        .layui-input-block {
            margin-left: 85px;
            min-height: 36px;
        }
    </style>
</head>
<body>

    <div id="layout1" class="layui-fluid">
            <div class="layui-col-md12">
                <div class="layui-card" style="">
                    <div class="layui-card-body"style="padding:1px">
                        <h1 style="text-align:center;margin-bottom:7px;margin-top:7px;"><b>应付单查询</b></h1>
                        <div class="layui-tab layui-tab-card" lay-filter="table">
                            <ul class="layui-tab-title">
                                <li>我创建的</li>
                                <li class="layui-this">需要我审核的</li>
                                <li>我已审核的</li>
                            </ul>
                            <div class="layui-tab-content" style="">
                                <div class="layui-tab-item ">
                                    <script type="text/html" id="toolbarDemoSend">
                                        <div class="layui-btn-container">
                                            <button type="button" class="layui-btn layui-btn-sm" lay-event="get_Refresh"><i class="layui-icon layui-icon-refresh-3"></i>刷新</button>
                                            <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-Edit"><i class="layui-icon layui-icon-form"></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_HideColumn"><i class="layui-icon layui-icon-form"></i>列设置</button>
                                        </div>
                                    </script>
                                    <table class="" id="mainTableSend" lay-filter="mainTableSend"></table>
                                </div>
                                <div class="layui-tab-item  layui-show">
                                    <script type="text/html" id="toolbarDemoNeedCheck">
                                        <div class="layui-btn-container">
                                            <button type="button" class="layui-btn layui-btn-sm" lay-event="get_Refresh"><i class="layui-icon layui-icon-refresh-3"></i>刷新</button>
                                            <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-Edit"><i class="layui-icon layui-icon-form"></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_HideColumn"><i class="layui-icon layui-icon-form"></i>列设置</button>
                                        </div>
                                    </script>
                                    <table class="" id="mainTableNeedCheck" lay-filter="mainTableNeedCheck"></table>
                                </div>
                                <div class="layui-tab-item ">
                                    <script type="text/html" id="toolbarDemoChecked">
                                        <div class="layui-btn-container">
                                            <button type="button" class="layui-btn layui-btn-sm" lay-event="get_Refresh"><i class="layui-icon layui-icon-refresh-3"></i>刷新</button>
                                            <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-Edit"><i class="layui-icon layui-icon-form"></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_HideColumn"><i class="layui-icon layui-icon-form"></i>列设置</button>
                                        </div>
                                    </script>
                                    <table class="" id="mainTableChecked" lay-filter="mainTableChecked"></table>
                                </div>
                            </div>
                        </div>
                        </div>
                </div>
            </div>
    </div>
    <script>
        layui.config({
            base: '../../../layuiadmin/' //静态资源所在路径
        }).extend({
            index: 'lib/index' //主入口模块
        }).use(['index', 'form', 'laydate', 'table', 'element'], function () {
             //#region å…¬ç”¨å˜é‡
            var $ = layui.$
                , admin = layui.admin
                , layer = layui.layer
                , table = layui.table
                , form = layui.form
                , laydate = layui.laydate
                , element = layui.element;

            window.HDeptType = 0;
            var tabIndex = 1;//页签索引
            var option = [];
            var optionNeedCheck = [];
            var optionSend = [];
            var optionChecked = [];
            var HBillType = 1114;
            //不需要显示的字段 å¯æ‰©å±•
            var titleData = [];
            //#endregion
            //#endregion
            var HModName = "Cg_PayableBillCheckQuery";

            //#region è¿›å…¥é¡µé¢æ—¢åŠ è½½
            //初始化表格
            set_InitGrid();
            //查询
            get_Display(2);
            //get_Display(2);
            //get_Display(3);
            //#endregion

            //#region ç‚¹å‡»äº‹ä»¶åŒ…括on form事件等
            //#region头工具栏事件
            table.on('toolbar(mainTableSend)', function (obj) {
                switch (obj.event) {
                    //编辑
                    case 'btn-Edit': get_ShowBill('mainTableSend');
                        break;
                    //刷新
                    case 'get_Refresh': get_Display(1);
                        break;
                    //发起审批
                    case 'set_startCheckBill': set_startCheckBill('mainTableSend');
                        break;
                    //查看审批进度
                    case 'get_CheckFlowInfo': get_CheckFlowInfo('mainTableSend');
                        break;
                    //多级审核
                    case 'set_CheckBill_Flow': set_CheckBill_Flow(0, 'mainTableSend');
                        break;
                    //多级反审核
                    case 'set_AbandonCheck_Flow': set_CheckBill_Flow(1, 'mainTableSend');
                        break;
                    //驳回
                    case 'set_RejectCheck_Flow': set_RejectCheck_Flow('mainTableSend');
                        break;
                    //列设置
                    case 'set_HideColumn': get_HideColumn();
                        break;
                };
            });
            table.on('toolbar(mainTableNeedCheck)', function (obj) {
                switch (obj.event) {
                    //编辑
                    case 'btn-Edit': get_ShowBill('mainTableNeedCheck');
                        break;
                    //刷新
                    case 'get_Refresh': get_Display(2);
                        break;
                    //发起审批
                    case 'set_startCheckBill': set_startCheckBill('mainTableNeedCheck');
                        break;
                    //查看审批进度
                    case 'get_CheckFlowInfo': get_CheckFlowInfo('mainTableNeedCheck');
                        break;
                    //多级审核
                    case 'set_CheckBill_Flow': set_CheckBill_Flow(0, 'mainTableNeedCheck');
                        break;
                    //多级反审核
                    case 'set_AbandonCheck_Flow': set_CheckBill_Flow(1, 'mainTableNeedCheck');
                        break;
                    //驳回
                    case 'set_RejectCheck_Flow': set_RejectCheck_Flow('mainTableNeedCheck');
                        break;
                    //列设置
                    case 'set_HideColumn': get_HideColumn();
                        break;
                };
            });
            table.on('toolbar(mainTableChecked)', function (obj) {
                switch (obj.event) {
                    //编辑
                    case 'btn-Edit': get_ShowBill('mainTableChecked');
                        break;
                    //发起审批
                    case 'set_startCheckBill': set_startCheckBill('mainTableChecked');
                        break;
                    //查看审批进度
                    case 'get_CheckFlowInfo': get_CheckFlowInfo('mainTableChecked');
                        break;
                    //多级审核
                    case 'set_CheckBill_Flow': set_CheckBill_Flow(0, 'mainTableChecked');
                        break;
                    //多级反审核
                    case 'set_AbandonCheck_Flow': set_CheckBill_Flow(1, 'mainTableChecked');
                        break;
                    //驳回
                    case 'set_RejectCheck_Flow': set_RejectCheck_Flow('mainTableChecked');
                        break;
                    //刷新
                    case 'get_Refresh': get_Display(3);
                        break;
                    //列设置
                    case 'set_HideColumn': get_HideColumn();
                        break;
                };
            });

            table.on('tool(mainTableChecked)', function (obj) {
                var data = obj.data;
                if (obj.event == '单据号') {
                    var linterid = data.hmainid.toString();
                    //if (AllowLoadData(sSubStr) != false) {//非空验证
                    layer.open({
                        type: 2
                        , area: ['100%', '100%']
                        , title: '编辑应付单' 
                        , closeBtn: 1
                        , shade: 0.6 //遮罩透明度
                        , maxmin: true //允许全屏最小化
                        , anim: 0 //0-6的动画形式，-1不开启
                        , content: '../../采购管理/应付单/Cg_PayableBill.html?OperationType=3&linterid=' + linterid + '&HSouceBillType='
                        , resize: false,
                        end: function () {
                           
                        }
                        , cancel: function () {
                            //$(".layui-btn").removeClass("layui-btn-disabled");
                        }
                    })
                }
            });
            table.on('tool(mainTableNeedCheck)', function (obj) {
                var data = obj.data;
                if (obj.event == '单据号') {
                    var linterid = data.hmainid.toString();
                    //if (AllowLoadData(sSubStr) != false) {//非空验证
                    layer.open({
                        type: 2
                        , area: ['100%', '100%']
                        , title: '编辑应付单'
                        , closeBtn: 1
                        , shade: 0.6 //遮罩透明度
                        , maxmin: true //允许全屏最小化
                        , anim: 0 //0-6的动画形式，-1不开启
                        , content: '../../采购管理/应付单/Cg_PayableBill.html?OperationType=3&linterid=' + linterid + '&HSouceBillType='
                        , resize: false,
                        end: function () {

                        }
                        , cancel: function () {
                            //$(".layui-btn").removeClass("layui-btn-disabled");
                        }
                    })
                }
            });
            table.on('tool(mainTableSend)', function (obj) {
                var data = obj.data;
                if (obj.event == '单据号') {
                    var linterid = data.hmainid.toString();
                    //if (AllowLoadData(sSubStr) != false) {//非空验证
                    layer.open({
                        type: 2
                        , area: ['100%', '100%']
                        , title: '编辑应付单'
                        , closeBtn: 1
                        , shade: 0.6 //遮罩透明度
                        , maxmin: true //允许全屏最小化
                        , anim: 0 //0-6的动画形式，-1不开启
                        , content: '../../采购管理/应付单/Cg_PayableBill.html?OperationType=3&linterid=' + linterid + '&HSouceBillType='
                        , resize: false,
                        end: function () {

                        }
                        , cancel: function () {
                            //$(".layui-btn").removeClass("layui-btn-disabled");
                        }
                    })
                }
            });
            //#endregion

            //#region ç›‘听Tab切换，切换时触发
            element.on('tab(table)', function (data) {
                // èŽ·å–被切换到的面板的索引
                var index = data.index;
                // æ‰§è¡Œä¸€äº›æ“ä½œï¼Œä¾‹å¦‚改变页面内容
                tabIndex = index + 1;
                get_Display(index+1);
            });
            //#endregion

            //#region ç‚¹å‡»è¡Œé€‰ä¸­é«˜äº®
            table.on('row(mainTableChecked)', function (obj) {
                //选中行改变颜色
                var flag = !obj.tr.find(':checkbox:first').prop('checked');
                obj.tr.find(':checkbox').prop('checked', flag);
                if (flag) {
                    obj.tr.find('.layui-form-checkbox').addClass('layui-form-checked');  //设置复选框选中样式
                    $(obj.tr.selector).attr({ "style": "background:#ceedfa;color:black" });//改变当前tr背景颜色和字体颜色
                } else {
                    obj.tr.find('.layui-form-checkbox').removeClass('layui-form-checked');//取消复选框选中样式
                    $(obj.tr.selector).attr({ "style": "background:" });//取消当前tr颜色
                }
                //mainTable ä¸ºè¡¨æ ¼ID   æ³¨æ„æ­¤å¤„如果ID不正确将导致你在监听复选框时获取不到你选择的数据，前面的只是添加或删除选中未选中样式以及设置背景色，字体颜色
                layui.each(table.cache.mainTableChecked, function (i, l) {
                    if (obj.tr.index() == l.LAY_TABLE_INDEX) {
                        l.LAY_CHECKED = flag;
                    }
                });
            })
            table.on('row(mainTableSend)', function (obj) {
                //选中行改变颜色
                var flag = !obj.tr.find(':checkbox:first').prop('checked');
                obj.tr.find(':checkbox').prop('checked', flag);
                if (flag) {
                    obj.tr.find('.layui-form-checkbox').addClass('layui-form-checked');  //设置复选框选中样式
                    $(obj.tr.selector).attr({ "style": "background:#ceedfa;color:black" });//改变当前tr背景颜色和字体颜色
                } else {
                    obj.tr.find('.layui-form-checkbox').removeClass('layui-form-checked');//取消复选框选中样式
                    $(obj.tr.selector).attr({ "style": "background:" });//取消当前tr颜色
                }
                //mainTable ä¸ºè¡¨æ ¼ID   æ³¨æ„æ­¤å¤„如果ID不正确将导致你在监听复选框时获取不到你选择的数据，前面的只是添加或删除选中未选中样式以及设置背景色，字体颜色
                layui.each(table.cache.mainTableSend, function (i, l) {
                    if (obj.tr.index() == l.LAY_TABLE_INDEX) {
                        l.LAY_CHECKED = flag;
                    }
                });
            })
            table.on('row(mainTableNeedCheck)', function (obj) {
                //选中行改变颜色
                var flag = !obj.tr.find(':checkbox:first').prop('checked');
                obj.tr.find(':checkbox').prop('checked', flag);
                if (flag) {
                    obj.tr.find('.layui-form-checkbox').addClass('layui-form-checked');  //设置复选框选中样式
                    $(obj.tr.selector).attr({ "style": "background:#ceedfa;color:black" });//改变当前tr背景颜色和字体颜色
                } else {
                    obj.tr.find('.layui-form-checkbox').removeClass('layui-form-checked');//取消复选框选中样式
                    $(obj.tr.selector).attr({ "style": "background:" });//取消当前tr颜色
                }
                //mainTable ä¸ºè¡¨æ ¼ID   æ³¨æ„æ­¤å¤„如果ID不正确将导致你在监听复选框时获取不到你选择的数据，前面的只是添加或删除选中未选中样式以及设置背景色，字体颜色
                layui.each(table.cache.mainTableNeedCheck, function (i, l) {
                    if (obj.tr.index() == l.LAY_TABLE_INDEX) {
                        l.LAY_CHECKED = flag;
                    }
                });
            })
            //#endregion

            //#region æŽ’序
            table.on('sort(mainTableChecked)', function (obj) { //注：sort æ˜¯å·¥å…·æ¡äº‹ä»¶åï¼Œtest æ˜¯ table åŽŸå§‹å®¹å™¨çš„属性 lay-filter="对应的值"
                table.reload('mainTableReceive', {
                    initSort: obj //记录初始排序，如果不设的话，将无法标记表头的排序状态。 layui 2.1.1 æ–°å¢žå‚æ•°
                    , where: { //请求参数（注意：这里面的参数可任意定义，并非下面固定的格式）
                        field: obj.field //排序字段   åœ¨æŽ¥å£ä½œä¸ºå‚数字段  field order
                        , order: obj.type //排序方式   åœ¨æŽ¥å£ä½œä¸ºå‚数字段  field order
                    }
                });
                optionNeedCheck.data = layui.table.cache["mainTableReceive"];
                table.render(optionNeedCheck);
            });
            table.on('sort(mainTableSend)', function (obj) { //注：sort æ˜¯å·¥å…·æ¡äº‹ä»¶åï¼Œtest æ˜¯ table åŽŸå§‹å®¹å™¨çš„属性 lay-filter="对应的值"
                table.reload('mainTableSend', {
                    initSort: obj //记录初始排序，如果不设的话，将无法标记表头的排序状态。 layui 2.1.1 æ–°å¢žå‚æ•°
                    , where: { //请求参数（注意：这里面的参数可任意定义，并非下面固定的格式）
                        field: obj.field //排序字段   åœ¨æŽ¥å£ä½œä¸ºå‚数字段  field order
                        , order: obj.type //排序方式   åœ¨æŽ¥å£ä½œä¸ºå‚数字段  field order
                    }
                });
                optionSend.data = layui.table.cache["mainTableSend"];
                table.render(optionSend);
            });
            table.on('sort(mainTableNeedCheck)', function (obj) { //注：sort æ˜¯å·¥å…·æ¡äº‹ä»¶åï¼Œtest æ˜¯ table åŽŸå§‹å®¹å™¨çš„属性 lay-filter="对应的值"
                table.reload('mainTableSendCopy', {
                    initSort: obj //记录初始排序，如果不设的话，将无法标记表头的排序状态。 layui 2.1.1 æ–°å¢žå‚æ•°
                    , where: { //请求参数（注意：这里面的参数可任意定义，并非下面固定的格式）
                        field: obj.field //排序字段   åœ¨æŽ¥å£ä½œä¸ºå‚数字段  field order
                        , order: obj.type //排序方式   åœ¨æŽ¥å£ä½œä¸ºå‚数字段  field order
                    }
                });
                optionChecked.data = layui.table.cache["mainTableSendCopy"];
                table.render(optionChecked);
            });
            //#endregion

            //#endregion

            //#region è¯¥é¡µé¢æ‰€æœ‰æ–¹æ³•
            //#region åˆå§‹åŒ–表格
            function set_InitGrid() {
                optionNeedCheck = {
                    elem: '#mainTableNeedCheck'
                    , toolbar: '#toolbarDemoNeedCheck'
                    , totalRow: true
                    , page: true
                    , cellMinWidth: 120
                    , height: 'full-50'
                    , limit: 50
                    , limits: [50, 500, 5000, 20000]
                    , data : []
                };
                optionSend = {
                    elem: '#mainTableSend'
                    , toolbar: '#toolbarDemoSend'
                    , totalRow: true
                    , page: true
                    , cellMinWidth: 120
                    , height: 'full-50'
                    , limit: 50
                    , limits: [50, 500, 5000, 20000]
                    
                };
                optionChecked = {
                    elem: '#mainTableChecked'
                    , toolbar: '#toolbarDemoChecked'
                    , totalRow: true
                    , page: true
                    , cellMinWidth: 120
                    , height: 'full-50'
                    , limit: 50
                    , limits: [50, 500, 5000, 20000]
                    
                };
                option = optionSend;//初始化列设置option
            }
            //#endregion

            //#region åŠ è½½è¡¨æ ¼1为我发起的2我需要审核的3我已审核的
            function get_Display(type) {
                var ajaxLoad = layer.load();//遮罩
                var url = "";
                var user = sessionStorage["HUserName"];
                if (type == 1) {
                    var sWhere = "and åˆ¶å•äºº = '" + user + "'"  + "and å®¡æ ¸äºº = ''"
                    url = '/Cg_PayableBill/list';
                    userData = { "sWhere": sWhere, "user": sessionStorage["HUserName"]};
                    
                } else if (type == 2) {
                    url = '/Cg_PayableBill/NeedChecklist';
                    userData = { "user": user, "userid": sessionStorage["Czybm"]}
                }
                else if (type == 3) {
                    url = '/Cg_PayableBill/Checkedlist';
                    userData = { "user": user }
                } else {
                    var url = "";
                    userData = { "user": user}
                }
                $.ajax({
                    url: GetWEBURL() + url,
                    type: "GET",
                    async: false,
                    data: userData,
                    success: function (data1) {
                        if (data1.count == 1) {
                            var data = [];
                            var col = [];
                            //给空的数组赋值
                            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: '合计行' });
                            for (var i = 0; i < data.length; i++) {
                                // if (data[i].name == 'HInterID' || data[i].name == 'HBillType' || data[i].name == 'hmainid') {
                                if ($.inArray(data[i].name, titleData) > -1) {
                                    col.push({ field: data[i].id, title: data[i].name, align: 'center', hide: true }); //隐藏id列
                                } else if (data[i].name == '单据号') {//添加超链接
                                    col.push({
                                        field: data[i].id, title: data[i].name, align: 'center', sort: true, width: 200, 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 + " =='' ?'':layui.util.toDateString(d." + data[i].name + ", 'yyyy-MM-dd')}}</div>", width: 120 });
                                            break;
                                        case 'long':
                                        case 'Int32':
                                        case 'Int64':
                                        case 'double':
                                        case 'Decimal':
                                            col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, width: 120, totalRow: true });
                                            break;
                                        default:
                                            col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, width: 120 });
                                    }
                                }
                            }
                            optionSend.cols = [col];
                            optionNeedCheck.cols = [col];
                            optionChecked.cols = [col];

                            if (type == 1) {
                                HModName = "Cg_PayableBillCheckQueryIMake";
                                optionSend.data = data1.data;
                                //设置列表同一个单据只有第一条数据显示主表信息，其它记录只显示子表信息
                                //获取子表列数据
                                var colList = [];
                                for (var i = 0; i < optionSend.cols[0].length; i++) {
                                    colList.push(optionSend.cols[0][i].field);
                                }
                                //设置数据
                                var result = data1.data;
                                var temp = "";
                                for (var i = 0; i < result.length; i++) {
                                    if (temp != result[i]["单据号"]) {
                                        temp = result[i]["单据号"];
                                    } else {
                                        var initIndex = $.inArray("单据号", colList);
                                        var lastIndex = $.inArray("hsubid", colList);
                                        for (var j = initIndex; j < lastIndex; j++) {
                                            var fieldName = colList[j];
                                            result[i][fieldName] = "";
                                        }
                                    }
                                }
                                optionSend.data = result;
                                table.render(optionSend);
                                option = optionSend;
                            } else if (type == 2) {
                                HModName = "Cg_PayableBillCheckQuery";
                                optionNeedCheck.data = data1.data;
                                //设置列表同一个单据只有第一条数据显示主表信息，其它记录只显示子表信息
                                //获取子表列数据
                                var colList = [];
                                for (var i = 0; i < optionNeedCheck.cols[0].length; i++) {
                                    colList.push(optionNeedCheck.cols[0][i].field);
                                }
                                //设置数据
                                var result = data1.data;
                                var temp = "";
                                for (var i = 0; i < result.length; i++) {
                                    if (temp != result[i]["单据号"]) {
                                        temp = result[i]["单据号"];
                                    } else {
                                        var initIndex = $.inArray("单据号", colList);
                                        var lastIndex = $.inArray("hsubid", colList);
                                        for (var j = initIndex; j < lastIndex; j++) {
                                            var fieldName = colList[j];
                                            result[i][fieldName] = "";
                                        }
                                    }
                                }
                                optionNeedCheck.data = result;
                                table.render(optionNeedCheck);
                                option = optionNeedCheck;
                            }
                            else if (type == 3) {
                                HModName = "Cg_PayableBillCheckQuery";
                                optionChecked.data = data1.data;//获取前1000
                                //设置列表同一个单据只有第一条数据显示主表信息，其它记录只显示子表信息
                                //获取子表列数据
                                var colList = [];
                                for (var i = 0; i < optionChecked.cols[0].length; i++) {
                                    colList.push(optionChecked.cols[0][i].field);
                                }
                                //设置数据
                                var result = data1.data;
                                var temp = "";
                                for (var i = 0; i < result.length; i++) {
                                    if (temp != result[i]["单据号"]) {
                                        temp = result[i]["单据号"];
                                    } else {
                                        var initIndex = $.inArray("单据号", colList);
                                        var lastIndex = $.inArray("hsubid", colList);
                                        for (var j = initIndex; j < lastIndex; j++) {
                                            var fieldName = colList[j];
                                            result[i][fieldName] = "";
                                        }
                                    }
                                }
                                optionChecked.data = result;
                                table.render(optionChecked);
                                option = optionChecked;
                            } else {
                                /*table.render(optionSend);*/
                            }
                            DisPlay_HideColumn();
                            layer.close(ajaxLoad);
                            
                            //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_HideColumn() {
                var colName = "";
                for (var i = 1; i < option.cols[0].length; i++) {
                    colName += option.cols[0][i]["field"] + ",";
                }

                colName = encodeURI(colName.substring(0, colName.length - 1));//对 URI è¿›è¡Œç¼–码
                layer.open({
                    type: 2
                    , skin: "layui-layer-rim" //加上边框
                    , title: "隐藏列设置"  //标题
                    , closeBtn: 1  //窗体右上角关闭 çš„ æ ·å¼
                    , shift: 2 //弹出动画
                    , area: ["50%", "90%"] //窗体大小
                    , maxmin: true //设置最大最小按钮是否显示
                    , content: ['../../基础资料/隐藏列设置/Gy_GridView_Hide_New.html?HModName=' + HModName + '&colName=' + colName, "yes"]
                    , btn: ["确定", "取消"]
                    , btn1: function (index, laero) {
                        //刷新表格数据
                        DisPlay_HideColumn();
                        //更新表格缓存的数据
                        layer.close(index);//关闭弹窗
                    }
                })
            }
            //#endregion

            //#region æ˜¾ç¤ºåˆ—数据
            function DisPlay_HideColumn() {
                $.ajax({
                    url: GetWEBURL() + '/Xt_grdAlignment_WMES/grdAlignmentWMESList',
                    type: "GET",
                    async: false,
                    data: { "HModName": HModName, "user": sessionStorage["HUserName"] },
                    success: function (data1) {
                        if (data1.data.length != 0) {

                            var dataCol = [];//数据库查询出的列数据
                            var titleData = [];//不需要显示的字段 å¯æ‰©å±•
                            var newCols = [[]];//对应数据库列顺序col
                            newCols[0].push(option.cols[0][0]);//放入第一个checkbox
                            dataCol = data1.data[0].HGridString.split(',');
                            //列设置列数与页面列数是否一致
                            if (dataCol.length == option.cols[0].length - 1) {
                                //遍历寻找列设置对应列按顺序插入
                                for (var j = 0; j < option.cols[0].length - 1; j++) {
                                    for (var i = 0; i < option.cols[0].length - 1; i++) {
                                        var dataCols = dataCol[j].split('|');
                                        //选择与datacols相应列进行修改
                                        if (option.cols[0][i + 1]["field"] == dataCols[5]) {
                                            //隐藏列
                                            if (dataCols[1] == 1) {
                                                option.cols[0][i + 1]["hide"] = true;
                                            }
                                            //设置列宽
                                            if (dataCols[3] > 0) {
                                                option.cols[0][i + 1]["width"] = dataCols[3];
                                            }
                                            //设置内容字体大小
                                            if (data1.data[0].HFontSize != 0) {
                                                option.cols[0][i + 1]["style"] = "font-size:" + data1.data[0].HFontSize + "px;";
                                            } else {
                                                option.cols[0][i + 1]["style"] = "font-size:100%";
                                            }
                                            //显示列
                                            if (dataCols[1] == 0 && $.inArray(option.cols[0][i + 1]["title"], titleData) == -1) {
                                                option.cols[0][i + 1]["hide"] = false;
                                            }
                                            //统计列
                                            if (dataCols[6] == 1) {
                                                option.cols[0][i + 1]["totalRow"] = true;
                                            }
                                            //字体所在位置(å·¦ å±…中 å³)
                                            switch (dataCols[2]) {
                                                case "L":
                                                    option.cols[0][i + 1]["align"] = "left";
                                                    break;
                                                case "M":
                                                    option.cols[0][i + 1]["align"] = "center";
                                                    break;
                                                case "R":
                                                    option.cols[0][i + 1]["align"] = "right";
                                                    break;
                                            }
                                            //设置表格title属性显示别名
                                            if (dataCols[4] != null && dataCols[4] != "") {
                                                option.cols[0][i + 1]["title"] = dataCols[4];
                                            }
                                            newCols[0].push(option.cols[0][i + 1]);
                                        }
                                    }
                                }
                                //遍历循环后判断对应列数是否一致
                                if (dataCol.length == newCols[0].length - 1) {
                                    option.cols = newCols;
                                    //取消冻结列
                                    for (var i = 1; i < option.cols[0].length - 1; i++) {
                                        if (option.cols[0][i]["fixed"] != null) {
                                            option.cols[0][i]["fixed"] = null;
                                        }
                                        else {
                                            break;
                                        }
                                    }
                                    //冻结列
                                    if (data1.data[0].HFixCols != 0) {
                                        for (var i = 0; i < data1.data[0].HFixCols; i++) {
                                            if ($.inArray(option.cols[0][i + 1]["title"], titleData) != -1) {
                                                data1.data[0].HFixCols += 1;
                                            }
                                            option.cols[0][i + 1]["fixed"] = "left";
                                        }
                                    }
                                }
                            }
                            ins=table.render(option);
                        } else {
                            ins=table.render(option);
                        }
                    }, error: function () {
                        layer.alert("接口请求失败!", { icon: 5 });
                    }
                })
            }
            //#endregion


            //#region ç¼–辑
            function get_ShowBill(tableName) {
                var checkStatus = table.checkStatus(tableName)
                    , data = checkStatus.data;
                if (checkStatus.data.length === 1) {
                    var linterid = data[0].HItemID;
                    layer.open({
                        type: 2
                        , area: ['100%', '100%']
                        , title: '编辑应付单'
                        , closeBtn: 1
                        , shade: 0.6 //遮罩透明度
                        , maxmin: true //允许全屏最小化
                        , anim: 0 //0-6的动画形式，-1不开启
                        , content: '../../采购管理/应付单/Cg_PayableBill.html?OperationType=3&linterid=' + linterid + '&HSouceBillType='
                        , resize: false,
                        end: function () {
                            /*get_FastQuery(table, option);*/
                        }
                        , cancel: function () {
                            //$(".layui-btn").removeClass("layui-btn-disabled");
                        }
                    })
                } else {
                    layer.msg('请选择一行数据编辑！');
                }
            }
            //#endregion

            //#region å‘起审批
            function set_startCheckBill(tableName) {
                var checkStatus = table.checkStatus(tableName)
                    , data = checkStatus.data;
                if (checkStatus.data.length === 1) {
                    var InterID = data[0].hmainid.toString();
                    //逻辑审核方法
                    $.ajax({
                        type: "GET",
                        url: GetWEBURL() + "/Cg_PayableBill/StartCheckFlow_POOrderBill", //方法所在页面和方法名
                        data: { "HInterID": InterID, "CurUserName": sessionStorage["HUserName"] },
                        success: function (result) {
                            if (result.count == 1) {
                                layer.msg(result.Message, { time: 1 * 1000, icon: 1 }, function () {

                                    // å¾—到frame索引
                                    var index = layer.getFrameIndex(window.name);
                                    //关闭当前frame
                                    layer.close(index);
                                    if (tableName == 'mainTableSend') {
                                        get_Display(1);
                                    } else if (tableName == 'mainTableNeedCheck') {
                                        get_Display(2);
                                    } else if (tableName == 'mainTableChecked') {
                                        get_Display(3)
                                    }
                                });

                            } else {
                                layer.alert(result.code + result.Message, { icon: 5 });
                            }
                        }, error: function () {
                            layer.alert("接口请求失败!", { icon: 5 });
                        }
                    });
                    //修改为功后刷新界面
                    if (tableName == 'mainTableSend') {
                        get_Display(1);
                    } else if (tableName == 'mainTableNeedCheck') {
                        get_Display(2);
                    } else if (tableName == 'mainTableChecked') {
                        get_Display(3)
                    }
                }
                else {
                    layer.msg('请选择一行数据审核！');
                }
            }
            //#endregion

            //#region æŸ¥çœ‹å®¡æ‰¹è¿›åº¦
            function get_CheckFlowInfo(tableName) {
                var checkStatus = table.checkStatus(tableName)
                    , data = checkStatus.data;
                if (checkStatus.data.length === 1) {
                    var hID = data[0].hmainid.toString();
                    layer.open({
                        type: 2
                        , area: ['70%', '70%']
                        , title: '单据审批进度'
                        , closeBtn: 1
                        , shade: 0.6 //遮罩透明度
                        , maxmin: true //允许全屏最小化
                        , anim: 0 //0-6的动画形式，-1不开启
                        , content: '../../系统管理/多级审批/审批进度/Xt_CheckFlowProgressList.html?linterid=' + hID + '&HSouceBillType=' + HBillType
                        , resize: false,
                        end: function () {
                            ////修改为功后刷新界面
                            //if (get_needClose_Bar == 0) {
                            //    $("#btnSearch").trigger('click');
                            //} else if (get_needClose_Bar == 1) {
                            //    $("#get_needClose").trigger('click');
                            //}
                        }
                        , cancel: function () {

                        }
                    })
                } else {
                    layer.msg('请选择一行数据查看！');
                }
            }
            //#endregion

            //#region å¤šçº§ åå®¡æ ¸/审核数据
            function set_CheckBill_Flow(num, tableName) {
                var checkStatus = table.checkStatus(tableName)
                    , data = checkStatus.data;
                if (checkStatus.data.length != 0) {
                    var uniqueIds = [...new Set(data.map(obj => obj.hmainid))];//将对象数组id提取去重
                    var queryString = uniqueIds.join(",");//将ids变成数组
                    //逻辑审核方法
                    $.ajax({
                        type: "GET",
                        url: GetWEBURL() + "/Cg_PayableBill/CheckAllFlow", //方法所在页面和方法名
                        data: { "HInterIDS": queryString, "IsAudit": num, "CurUserName": sessionStorage["HUserName"], "CurUserID": sessionStorage["Czybm"] },
                        success: function (result) {
                            if (result.count == 1) {
                                layer.msg(result.Message, { time: 1 * 1000, icon: 1 }, function () {
                                    // å¾—到frame索引
                                    var index = layer.getFrameIndex(window.name);
                                    //关闭当前frame
                                    layer.close(index);
                                    //修改为功后刷新界面
                                    if (tableName == 'mainTableSend') {
                                        get_Display(1);
                                    } else if (tableName == 'mainTableNeedCheck') {
                                        get_Display(2);
                                    } else if (tableName == 'mainTableChecked') {
                                        get_Display(3)
                                    }
                                });

                            } else {
                                layer.alert(result.code + result.Message, { icon: 5 });
                            }
                        }, error: function () {
                            layer.alert("接口请求失败!", { icon: 5 });
                        }
                    });
                }
                else {
                    layer.msg('请选择至少一行数据审核！');
                }
            }
            //#endregion

            //#region é©³å›ž
            function set_RejectCheck_Flow(tableName) {
                var checkStatus = table.checkStatus(tableName)
                    , data = checkStatus.data;
                if (checkStatus.data.length !=0 ) {
                    var uniqueIds = [...new Set(data.map(obj => obj.hmainid))];//将对象数组id提取去重
                    var queryString = uniqueIds.join(",");//将ids变成数组
                    //逻辑审核方法
                    $.ajax({
                        type: "GET",
                        url: GetWEBURL() + "/Cg_PayableBill/RejectAllCheckFlow", //方法所在页面和方法名
                        data: { "HInterIDS": queryString, "CurUserID": sessionStorage["Czybm"] },
                        success: function (result) {
                            if (result.count == 1) {
                                layer.msg(result.Message, { time: 1 * 1000, icon: 1 }, function () {
                                    // å¾—到frame索引
                                    var index = layer.getFrameIndex(window.name);
                                    //关闭当前frame
                                    layer.close(index);
                                });
                                //修改为功后刷新界面
                                if (tableName == 'mainTableSend') {
                                    get_Display(1);
                                } else if (tableName == 'mainTableNeedCheck') {
                                    get_Display(2);
                                } else if (tableName == 'mainTableChecked') {
                                    get_Display(3)
                                }
                            } else {
                                layer.alert(result.code + result.Message, { icon: 5 });
                            }
                        }, error: function () {
                            layer.alert("接口请求失败!", { icon: 5 });
                        }
                    });
                }
                else {
                    layer.msg('请选择一行数据审核！');
                }
            }
            //#endregion


            //#endregion


            //以上为layui模块
        });

        function formatDate(date) {
            var d = new Date(date),
                month = '' + (d.getMonth() + 1),
                day = '' + d.getDate(),
                year = d.getFullYear();

            if (month.length < 2) month = '0' + month;
            if (day.length < 2) day = '0' + day;

            return [year, month, day].join('-');
        }
    </script>
</body>
</html>

 WebTM/views/ÏúÊÛ¹ÜÀí/·¢»õ֪ͨµ¥/Add_Edit_Xs_SeOutStockBillList.html

@@ -445,14 +445,6 @@
            }
            //#endregion

            

            var rowdata = [{
                "HMaterID": 0, "物料代码": "", "物料名称": "", "规格型号": "", "HUnitID": 0, "计量单位": "", "HWHID": "0", "发货仓库": "",
                "HQty": "0", "HPrice": "0", "HMoney": "0", "HRemark": "",
                "HSourceBillNo": 0, "HSourceBillType": 0, "HSourceInterID": 0, "HSourceEntryID": 0,
            }];

            // åˆå§‹åŒ–ç•Œ
            set_InitGrid();
            //获取源单类型
@@ -464,7 +456,7 @@
                //新增行表格数据
                var NewRow = {
                    "HMaterID": 0, "物料代码": "", "物料名称": "", "规格型号": "", "HUnitID": 0, "计量单位": "", "HWHID": "0", "发货仓库": "",
                    "HQty": "0", "HPrice": "0", "HMoney": "0", "HRemark": "",
                    "HQty": "0", "HPrice": "0", "HMoney": "0", "HRemark": "","HInventoryQty":0,
                    "HSourceBillNo": 0, "HSourceBillType": 0, "HSourceInterID": 0, "HSourceEntryID": 0,
                };
                switch (obj.event) {
@@ -662,6 +654,8 @@
                                        j++;
                                    }
                                    table.render(option);
                                    //设置当前库存
                                    SetAllInventoryByMaterID();
                                    layer.close(ajaxLoad);
                                    layer.msg("查询成功", { time: 1 * 1000, icon: 1 });
                                }
@@ -880,6 +874,8 @@
                        $("#HWHName").val(checkStatus.data[0].主仓库);

                        table.render(option);
                        //设置当前库存
                        SetAllInventoryByMaterID();
                        layer.close(index);//关闭弹窗
                    }

@@ -940,6 +936,8 @@
                            }
                        }
                        getSeletMainInfo(sMainWhere);
                        //设置当前库存
                        SetAllInventoryByMaterID();
                        layer.close(index);//关闭弹窗
                    }
                });
@@ -1069,6 +1067,7 @@
                        , { field: 'HWHID', title: 'HWHID', width: 100, hide: true }
                        , { field: '发货仓库', title: '发货仓库', width: 100, edit: 'text', event: "HWHID" }//f7
                        , { field: 'HQty', title: '数量', width: 100, edit: 'text' }
                        , { field: 'HInventoryQty', title: '当前库存', width: 100}
                        , { field: 'HPrice', title: '单价', width: 100, edit: 'text' }
                        , { field: 'HMoney', title: '金额', width: 100 }
                        , { field: 'HRemark', title: '备注', width: 100, edit: 'text' }
@@ -1151,7 +1150,7 @@
                                rowdata.push(
                                    {
                                        "HMaterID": subdata[i].HMaterID, "物料代码": subdata[i].物料代码, "物料名称": subdata[i].物料名称, "规格型号": subdata[i].规格型号, "HUnitID": subdata[i].HUnitID, "计量单位": subdata[i].计量单位,
                                        "HWHID": subdata[i].HWHID, "发货仓库": subdata[i].发货仓库, "HQty": subdata[i].数量, "HPrice": subdata[i].单价, "HMoney": subdata[i].金额, "HRemark": subdata[i].表体备注
                                        "HWHID": subdata[i].HWHID, "发货仓库": subdata[i].发货仓库, "HQty": subdata[i].数量,"HPrice": subdata[i].单价, "HMoney": subdata[i].金额, "HRemark": subdata[i].表体备注
                                        , "HSourceBillNo": subdata[i].源单单号,    //源单号
                                        "HSourceBillType": subdata[i].源单类型,   //源单类型
                                        "HSourceInterID": subdata[i].源单主内码,   //源单主内码
@@ -1161,6 +1160,8 @@
                            }
                            option.data = rowdata;
                            table.render(option);
                            //设置当前库存
                            SetAllInventoryByMaterID();
                            form.render('select');

                            layer.close(ajaxLoad);
@@ -1369,6 +1370,8 @@
                                            if (childData != null) {
                                                //更新表格缓存的数据
                                                OptionData = childData;
                                                //获取当前库存
                                                var HInventoryQty = GetInventoryByMaterID(OptionData.HItemID, obj.data["HWHID"]);
                                                obj.update({
                                                    "HMaterID": OptionData.HItemID
                                                    , "物料代码": OptionData.物料代码
@@ -1377,7 +1380,9 @@
                                                    , "HUnitID": OptionData.HUnitID
                                                    , "计量单位": OptionData.计量单位名称
                                                    , "HQty": 1
                                                    , "HInventoryQty": HInventoryQty
                                                })


                                                OptionData = {};
                                                childData = null;
@@ -1410,6 +1415,7 @@
                                    if (childData != null) {
                                        //更新表格缓存的数据
                                        OptionData = childData;
                                        var HInventoryQty = GetInventoryByMaterID(OptionData.HItemID, obj.data["HWHID"]);
                                        obj.update({
                                            "HMaterID": OptionData.HItemID
                                            , "物料代码": OptionData.物料代码
@@ -1418,6 +1424,7 @@
                                            , "HUnitID": OptionData.HUnitID
                                            , "计量单位": OptionData.计量单位名称
                                            , "HQty": 1
                                            , "HInventoryQty": HInventoryQty
                                        })

                                        OptionData = {};
@@ -1456,7 +1463,9 @@

                                    if (checkStatus.data.length == 0) {
                                        return layer.msg("请选择数据");
                                    }else if (checkStatus.data.length == 1) {
                                    } else if (checkStatus.data.length == 1) {
                                        //获取当前库存
                                        var HInventoryQty = GetInventoryByMaterID(checkStatus.data[0].HItemID, obj.data["HWHID"]);
                                        //更新表格缓存的数据
                                        obj.update({
                                            "HMaterID": checkStatus.data[0].HItemID
@@ -1465,6 +1474,7 @@
                                            , "规格型号": checkStatus.data[0].规格型号
                                            , "HUnitID": checkStatus.data[0].HUnitID
                                            , "计量单位": checkStatus.data[0].计量单位名称
                                            , "HInventoryQty": HInventoryQty
                                            ,"HQty": 1
                                        })
                                        layer.close(index);//关闭弹窗
@@ -1484,6 +1494,8 @@

                                                table.render(option);//渲染界面
                                            }
                                            //获取当前库存
                                            var HInventoryQty = GetInventoryByMaterID(checkStatus.data[i].HItemID, option.data[rowIndex + i].HWHID);
                                            option.data[rowIndex + i].HMaterID = checkStatus.data[i].HItemID;  //将option.data数组中对应行的HMaterID属性更新为从resultData对象中获取的物料ID
                                            option.data[rowIndex + i].物料代码 = checkStatus.data[i].物料代码; //将option.data数组中对应行的 ç‰©æ–™ä»£ç  å±žæ€§æ›´æ–°ä¸ºä»ŽresultData对象中获取的物料ID
                                            option.data[rowIndex + i].物料名称 = checkStatus.data[i].物料名称; //将option.data数组中对应行的  ç‰©æ–™åç§°  å±žæ€§æ›´æ–°ä¸ºä»ŽresultData对象中获取的物料ID
@@ -1491,6 +1503,7 @@
                                            option.data[rowIndex + i].HUnitID = checkStatus.data[i].HUnitID; //将option.data数组中对应行的 HUnitID å±žæ€§æ›´æ–°ä¸ºä»ŽresultData对象中获取的物料ID
                                            option.data[rowIndex + i].计量单位 = checkStatus.data[i].计量单位名称; //将option.data数组中对应行的 è®¡é‡å•ä½ å±žæ€§æ›´æ–°ä¸ºä»ŽresultData对象中获取的物料ID   æ›´æ–°è®¡é‡å•ä½å±žæ€§
                                            option.data[rowIndex + i].HQty = 1;  //将对应行的HQty属性（可能代表数量）设置为1。这表示对于每个选中的物料，其默认数量被设置为1
                                            option.data[rowIndex + i].HInventoryQty = HInventoryQty;  //当前库存
                                        }
                                        table.render(option);
                                        layer.close(index);//关闭弹窗
@@ -1499,6 +1512,7 @@
                                }
                                , end: function () {
                                    if (typeof (OptionData.HItemID) != "undefined") {
                                        var HInventoryQty = GetInventoryByMaterID(OptionData.HItemID, obj.data["HWHID"]);
                                        //更新表格缓存的数据
                                        obj.update({
                                            "HMaterID": OptionData.HItemID
@@ -1508,6 +1522,7 @@
                                            , "HUnitID": OptionData.HUnitID
                                            , "计量单位": OptionData.计量单位名称
                                            , "HQty": 1
                                            , "HInventoryQty": HInventoryQty
                                        })
                                        OptionData = [];
                                    }
@@ -1573,19 +1588,23 @@
                                    if (checkStatus.data.length != 1) {
                                        return layer.msg("请选择一条数据");
                                    }
                                    var HInventoryQty = GetInventoryByMaterID(obj.data["HMaterID"], checkStatus.data[0].HItemID);
                                    //更新表格缓存的数据
                                    obj.update({

                                        "HWHID": checkStatus.data[0].HItemID,
                                        "发货仓库": checkStatus.data[0].仓库名称
                                        "发货仓库": checkStatus.data[0].仓库名称,
                                        "HInventoryQty": HInventoryQty
                                    })
                                    layer.close(index);//关闭弹窗
                                }
                                , end: function () {
                                    if (typeof (OptionData.HItemID) != "undefined") {
                                        var HInventoryQty = GetInventoryByMaterID(obj.data["HMaterID"],OptionData.HItemID);
                                        obj.update({
                                            "HWHID": OptionData.HItemID
                                            , "发货仓库": OptionData.仓库名称
                                            , "HInventoryQty": HInventoryQty
                                        })
                                        OptionData = [];
                                    }
@@ -1620,6 +1639,8 @@
                            if (checkStatus.data.length == 0) {
                                return layer.msg("请选择数据");
                            } else if (checkStatus.data.length == 1) {
                                //获取当前库存
                                var HInventoryQty = GetInventoryByMaterID(checkStatus.data[0].HItemID, obj.data["HWHID"]);
                                //更新表格缓存的数据
                                obj.update({
                                    "HMaterID": checkStatus.data[0].HItemID
@@ -1628,6 +1649,7 @@
                                    , "规格型号": checkStatus.data[0].规格型号
                                    , "HUnitID": checkStatus.data[0].HUnitID
                                    , "计量单位": checkStatus.data[0].计量单位名称
                                    , "HInventoryQty": HInventoryQty
                                    , "HQty": 1
                                })
                                layer.close(index);//关闭弹窗
@@ -1647,6 +1669,8 @@

                                        table.render(option);//渲染界面
                                    }
                                    //获取当前库存
                                    var HInventoryQty = GetInventoryByMaterID(checkStatus.data[i].HItemID, option.data[rowIndex + i].HWHID);
                                    option.data[rowIndex + i].HMaterID = checkStatus.data[i].HItemID;  //将option.data数组中对应行的HMaterID属性更新为从resultData对象中获取的物料ID
                                    option.data[rowIndex + i].物料代码 = checkStatus.data[i].物料代码; //将option.data数组中对应行的 ç‰©æ–™ä»£ç  å±žæ€§æ›´æ–°ä¸ºä»ŽresultData对象中获取的物料ID
                                    option.data[rowIndex + i].物料名称 = checkStatus.data[i].物料名称; //将option.data数组中对应行的  ç‰©æ–™åç§°  å±žæ€§æ›´æ–°ä¸ºä»ŽresultData对象中获取的物料ID
@@ -1654,6 +1678,7 @@
                                    option.data[rowIndex + i].HUnitID = checkStatus.data[i].HUnitID; //将option.data数组中对应行的 HUnitID å±žæ€§æ›´æ–°ä¸ºä»ŽresultData对象中获取的物料ID
                                    option.data[rowIndex + i].计量单位 = checkStatus.data[i].计量单位名称; //将option.data数组中对应行的 è®¡é‡å•ä½ å±žæ€§æ›´æ–°ä¸ºä»ŽresultData对象中获取的物料ID   æ›´æ–°è®¡é‡å•ä½å±žæ€§
                                    option.data[rowIndex + i].HQty = 1;  //将对应行的HQty属性（可能代表数量）设置为1。这表示对于每个选中的物料，其默认数量被设置为1
                                    option.data[rowIndex + i].HInventoryQty = HInventoryQty;  //当前库存
                                }
                                table.render(option);
                                layer.close(index);//关闭弹窗
@@ -1662,6 +1687,7 @@
                        }
                        , end: function () {
                            if (typeof (OptionData.HItemID) != "undefined") {
                                var HInventoryQty = GetInventoryByMaterID(OptionData.HItemID, obj.data["HWHID"]);
                                //更新表格缓存的数据
                                obj.update({
                                    "HMaterID": OptionData.HItemID
@@ -1671,6 +1697,7 @@
                                    , "HUnitID": OptionData.HUnitID
                                    , "计量单位": OptionData.计量单位名称
                                    , "HQty": 1
                                    , "HInventoryQty": HInventoryQty
                                })
                                OptionData = [];
                            }
@@ -1731,6 +1758,37 @@
            }
            //#endregion

            //#region åŠæ—¶åº“存查询
            function GetInventoryByMaterID(HMaterID, HWHID) {
                var HInventoryQty = 0;
                $.ajax({
                    url: GetWEBURL() + '/Xs_SeOutStockBill/GetICInventory',
                    async: false,
                    type: "GET",
                    data: { "HMaterID": HMaterID, "HWHID": HWHID, "HORGID": sessionStorage["OrganizationID"] },
                    async: false,
                    success: function (data1) {
                        if (data1.count == 1) {
                            HInventoryQty = data1.data;
                        }
                    }, error: function () {
                        layer.alert("接口请求失败!", { icon: 5 });
                    }
                })
                return HInventoryQty;
            }
            //设置获取所有option的当前库存
            function SetAllInventoryByMaterID() {
                option.date = table.cache["mainTable"];
                for (var i = 0; i < table.cache["mainTable"].length; i++) {
                    var HInventoryQty = GetInventoryByMaterID(table.cache["mainTable"][i].HMaterID, table.cache["mainTable"][i].HWHID);
                    table.cache["mainTable"][i].HInventoryQty = HInventoryQty;
                }
                table.render(option);
            }
            //#endregion


            //#region å­è¡¨1：隐藏列设置
            function get_HideColumn() {
                var colName = "";
@@ -1783,6 +1841,9 @@
                            dataCol = data1.data[0].HGridString.split(',');

                            for (var i = 0; i < option.cols[0].length - 2; i++) {
                                if (dataCol.length <= i) {
                                    break;
                                }
                                var dataCols = dataCol[i].split('|');
                                //隐藏列
                                if (dataCols[1] == 1) {