染厂产量报表：增加客户字段、增加根据用户关联客户过滤

duhe

2024-05-28 262cee2e43059f55330b5efda849fcd1d445efd2

染厂产量报表：增加客户字段、增加根据用户关联客户过滤

 WebTM/views/³µ¼ä¹ÜÀí/±¨±í·ÖÎö/Kf_ProdProcessSumReport_DyeColor_third.html

@@ -310,6 +310,9 @@
                    com = " and (" + ColName + " " + com + ")";
                }

                //根据用户过滤用户关联客户的记录
                var OtherSearch = getSWhereByHUser();

                sWhere = {
                    HBeginDate: HBeginDate
                    , HEndDate: HEndDate
@@ -318,6 +321,7 @@
                    , HProductName: HProductName
                    , HProductModel: HProductModel
                    , RandomSearch: com
                    , OtherSearch: (OtherSearch == null || OtherSearch == "undefine") ? " and 1=1 " : OtherSearch
                }
                sWhere = JSON.stringify(sWhere);

@@ -527,6 +531,9 @@
                    com = " and (" + ColName + " " + com + ")";
                }

                //根据用户过滤用户关联客户的记录
                var OtherSearch = getSWhereByHUser();

                sWhere = {
                    HBeginDate: HBeginDate
                    , HEndDate: HEndDate
@@ -535,6 +542,7 @@
                    , HProductName: HProductName
                    , HProductModel: HProductModel
                    , RandomSearch: com
                    , OtherSearch: (OtherSearch == null || OtherSearch == "undefine") ? " and 1=1 " : OtherSearch
                }
                //set_InitGrid(JSON.stringify(sWhere));
                get_Display(JSON.stringify(sWhere));
@@ -705,7 +713,31 @@
                })
            }

            
            //#region æ ¹æ®ç”¨æˆ·èŽ·å–用户关联客户的过滤条件
            function getSWhereByHUser() {
                var res = "";
                $.ajax({
                    type: "GET",
                    async: false,
                    url: GetWEBURL() + "/Xs_SeOrderBill/getCusIDListByUser", //方法所在页面和方法名
                    data: { "CurUserID": sessionStorage["Czybm"], "CurUserName": sessionStorage["HUserName"] },
                    success: function (result) {
                        if (result.count == 1) {
                            res = result.data;
                        } else {
                            res = result.data;
                            layer.alert(result.code + result.Message, { icon: 5 });
                        }
                    }, error: function (err) {
                        res = " and 1 = 0";
                        layer.alert("接口请求失败!", { icon: 5 });
                    }
                });
                res = res.replaceAll("'", "''");
                return res;
            }
            //#endregion

            //#endregion
        });
    </script>