仓库库位更改联表字段， 组织过滤

yusijie

2023-03-15 d96f23ba5f38ba07bf4b20d50e329ef71f30b2fe

仓库库位更改联表字段， 组织过滤

 zymes/OperationService/zymes_RealessCurrency.cs

@@ -45,9 +45,9 @@
            Entity entity = this.BusinessInfo.GetEntity("FEntity");//获取明细信息
            foreach (var billObj in e.DataEntitys)
            {
                var forgName = Context.CurrentOrganizationInfo.Name;
                if (!forgName.Contains("杭州斯莫尔磁性材料有限公司"))
                    continue;
                //var forgName = Context.CurrentOrganizationInfo.Name;
                //if (!forgName.Contains("杭州斯莫尔磁性材料有限公司"))
                //    continue;
                //var sql = $"exec zymes_RealessCurrency {billObj["Id"]} ";
                var id = billObj["Id"].ToString();
                string sql = string.Empty;

 zymes/OperationService/zymes_RealessPaymentCondition.cs

@@ -45,7 +45,7 @@
            Entity entity = this.BusinessInfo.GetEntity("FEntity");//获取明细信息
            foreach (var billObj in e.DataEntitys)
            {
                var forgName = Context.CurrentOrganizationInfo.Name;
                //var forgName = Context.CurrentOrganizationInfo.Name;
                //if (!forgName.Contains("杭州斯莫尔磁性材料有限公司"))
                //    continue;
                var id = billObj["Id"].ToString();

 zymes/OperationService/zymes_RealessRecCondition.cs

@@ -45,9 +45,9 @@
            Entity entity = this.BusinessInfo.GetEntity("FEntity");//获取明细信息
            foreach (var billObj in e.DataEntitys)
            {
                var forgName = Context.CurrentOrganizationInfo.Name;
                if (!forgName.Contains("杭州斯莫尔磁性材料有限公司"))
                    continue;
                //var forgName = Context.CurrentOrganizationInfo.Name;
                //if (!forgName.Contains("杭州斯莫尔磁性材料有限公司"))
                //    continue;
                var id = billObj["Id"].ToString();
                string sql = string.Empty;
                sql = $@"

 zymes/OperationService/zymes_RealessStock.cs

@@ -46,8 +46,8 @@
            foreach (var billObj in e.DataEntitys)
            {
                var forgName = Context.CurrentOrganizationInfo.Name;
                //if (!forgName.Contains("杭州斯莫尔磁性材料有限公司"))
                //    continue;
                if (!forgName.Contains("杭州斯莫尔磁性材料有限公司"))
                    continue;
                //var sql = $"exec zymes_RealessStock {billObj["Id"]} ";
                var id = billObj["Id"].ToString();
                string sql = string.Empty;
@@ -69,7 +69,7 @@
join T_BAS_FLEXVALUESDETAIL t2 on t1.FSTOCKLOCID = t2.FID
--SELECT * FROM T_BAS_FLEXVALUESENTRY t1--仓位值集列表明细
--join T_BAS_FLEXVALUESENTRY_L  t2 on t1.FENTRYID=t2.FENTRYID--仓位值集列表
join T_BAS_FLEXVALUESENTRY t3 on t2.FF100003 = t3.FENTRYID--仓位值集列表明细
join T_BAS_FLEXVALUESENTRY t3 on t2.FF100006 = t3.FENTRYID--仓位值集列表明细
join T_BAS_FLEXVALUESENTRY_L t4 on t3.FENTRYID=t4.FENTRYID
where t1.fstockid= {0} --采购入库单选择仓库后 选择仓位
", id);

 zymes/OperationService/zymes_RealessStockStatus.cs

@@ -45,7 +45,7 @@
            Entity entity = this.BusinessInfo.GetEntity("FEntity");//获取明细信息
            foreach (var billObj in e.DataEntitys)
            {
                var forgName = Context.CurrentOrganizationInfo.Name;
                //var forgName = Context.CurrentOrganizationInfo.Name;
                //if (!forgName.Contains("杭州斯莫尔磁性材料有限公司"))
                //    continue;
                var id = billObj["Id"].ToString();

 zymes/OperationService/zymes_RealessUnit.cs

@@ -45,9 +45,9 @@
            Entity entity = this.BusinessInfo.GetEntity("FEntity");//获取明细信息
            foreach (var billObj in e.DataEntitys)
            {
                var forgName = Context.CurrentOrganizationInfo.Name;
                if (!forgName.Contains("杭州斯莫尔磁性材料有限公司"))
                    continue;
                //var forgName = Context.CurrentOrganizationInfo.Name;
                //if (!forgName.Contains("杭州斯莫尔磁性材料有限公司"))
                //    continue;
                //var sql = $"exec zymes_RealessUnit {billObj["Id"]} ";
                var id = billObj["Id"].ToString();
                string sql =string.Empty;