用户关联客户：根据所选客户对应的关联客户，过滤指定客户

duhe

2023-12-27 8247fe4292bd89e2cf71059d2f5f037434410b81

 WebTM/views/ϵͳ¹ÜÀí/Óû§¹ÜÀí/Gy_UserCustomer.html

@@ -61,6 +61,26 @@
                                                    </button>
                                                </div>
                                            </div>
                                            <div class="layui-inline">
                                                <label class="layui-form-label">客户代码</label>
                                                <div class="layui-input-inline">
                                                    <input type="text" name="HCusNumber" id="HCusNumber" class="layui-input" value="" style="float:left;width:150px;">
                                                </div>
                                            </div>
                                            <div class="layui-inline">
                                                <label class="layui-form-label">客户名称</label>
                                                <div class="layui-input-inline">
                                                    <input type="text" name="HCusName" id="HCusName" class="layui-input" value="" style="float:left;width:150px;">
                                                </div>
                                            </div>
                                            <div class="layui-inline">
                                                <div class="layui-input-inline">
                                                    <button type="button" lay-submit="" class="layui-btn" lay-filter="Search" style="width:40px;">
                                                        <i class="layui-icon layui-icon-search layuiadmin-button-btn" style="margin-left:-9px;"></i>
                                                    </button>
                                                    <button type="button" lay-submit="" class="layui-btn" lay-filter="ReSet" style="width:60px;">重置</button>
                                                </div>
                                            </div>
                                        </div>
                                    </div>
                                </div>
@@ -185,7 +205,7 @@
                        $.ajax({
                            url: GetWEBURL() + "/Xt_User/CustomerPlaylist",
                            type: "GET",
                            data: { "HUserID": checkStatus.data[0].HNumber },
                            data: { "HUserID": checkStatus.data[0].HNumber, "CurUserName": sessionStorage["HUserName"] },
                            success: function (data) {
                                if (data.data != null && data.data != "") {
                                    option.data = data.data;
@@ -194,6 +214,7 @@
                                else {
                                    table.reload("mainTable", {});
                                    table.reload('mainTable', { data: [] });
                                    layer.alert(data.Message);
                                }

                            }
@@ -241,11 +262,29 @@
                                    }
                                    //console.log(obj.data);
                                    //同步更新表格和缓存对应的值
                                    obj.update({
                                        HCusID: checkStatus.data[0].HItemID,
                                        HCustomerNumber: checkStatus.data[0].HNumber,
                                        HCustomerName: checkStatus.data[0].HName
                                    });
                                    //obj.update({
                                    //    HCusID: checkStatus.data[0].HItemID,
                                    //    HCustomerNumber: checkStatus.data[0].HNumber,
                                    //    HCustomerName: checkStatus.data[0].HName
                                    //});


                                    var rowIndex = $(obj.tr).attr("data-index") * 1;
                                    for (var i = 0; i < checkStatus.data.length; i++) {
                                        if (rowIndex + i >= option.data.length) {
                                            var NewRow = { "HCusID": 0, "HCustomerNumber": "", "HCustomerName": "" };
                                            table.cache["mainTable"].push(NewRow);
                                            option.data = table.cache["mainTable"];
                                            table.render(option);
                                        }

                                        option.data[rowIndex + i].HCusID = checkStatus.data[i].HItemID;
                                        option.data[rowIndex + i].HCustomerNumber = checkStatus.data[i].HNumber;
                                        option.data[rowIndex + i].HCustomerName = checkStatus.data[i].HName;
                                    }
                                    table.render(option);



                                    layer.close(layer.index); //它获取的始终是最新弹出的某个层，值是由layer内部动态递增计算的
                                }
@@ -287,7 +326,7 @@
                    return false;
                }

                var sMainSub = sSubStr + ';' + UserID
                var sMainSub = sSubStr + ';' + UserID + ';' + sessionStorage["HUserName"];
                $.ajax(
                    {
                        type: "POST",
@@ -331,9 +370,57 @@
                }
            });

            //快速过滤
            form.on('submit(Search)', function () {
                get_FastQuery();
            });

            //重置过滤条件
            form.on('submit(ReSet)', function () {
                set_ClearQuery();
            });

            //#endregion

            //#region æ­¤é¡µé¢æ‰€æœ‰æ–¹æ³•
            //#region å¿«é€Ÿè¿‡æ»¤
            function get_FastQuery() {
                var UserID = $("#UserID").val();        //用户
                var HCusNumber = $("#HCusNumber").val();//客户代码
                var HCusName = $("#HCusName").val();    //客户名称

                if (UserID == null || UserID == "") {
                    layer.alert("用户未选择，请选择用户！");
                    return;
                }

                $.ajax({
                    url: GetWEBURL() + "/Xt_User/CustomerPlaylistFromUserCustomerList",
                    type: "GET",
                    data: { "HUserID": UserID, "HCusNumber": HCusNumber, "HCusName": HCusName, "CurUserName": sessionStorage["HUserName"] },
                    success: function (data) {
                        if (data.data != null && data.data != "") {
                            option.data = data.data;
                            table.render(option);
                        }
                        else {
                            table.reload("mainTable", {});
                            table.reload('mainTable', { data: [] });
                            layer.alert(data.Message);
                        }

                    }
                });
            }
            //#endregion

            //#region é‡ç½®è¿‡æ»¤æ¡ä»¶
            function set_ClearQuery() {
                $("#HCusNumber").val("");//客户代码
                $("#HCusName").val(""); //客户名称
            }
            //#endregion

            //初始化表格
            function set_InitGrid() {
                columns = [