客户物料对应表增加小卫自定义字段 F_XLBH_TEXT 商品id

zrg

2025-10-23 f83f3f14c5e84e8805d131adf55667b0a965f394

客户物料对应表增加小卫自定义字段   F_XLBH_TEXT  商品id

 zymes/OperationService/zymes_RealessCusMaterial.cs

@@ -61,7 +61,8 @@
                    a.FCREATORID AS HCREATEORGID,
                    a.FUSEORGID AS HUSEORGID,
                    o.FNUMBER as HOrganNumber,
                    u.FNAME HMaker
                    u.FNAME HMaker,
                    c.F_XLBH_TEXT HShopID   
                FROM T_SAL_CUSTMATMAPPING a
                INNER JOIN T_SAL_CUSTMATMAPPINGENTRY c ON a.FID = c.FID  -- 客户物料表明细
                INNER JOIN T_SAL_CUSTMATMAPPINGENTRY_L d ON c.FENTRYID = d.FENTRYID -- 客户物料表明细_多语言
@@ -69,7 +70,8 @@
                INNER JOIN T_SEC_USER u ON a.FCREATORID = u.FUSERID  -- 用户表
                INNER JOIN T_ORG_Organizations o on a.FUSEORGID=o.FORGID
                where a.FID={id}
                ";               
                ";
                //F_XLBH_TEXT小卫自定义字段 商品id
                LogService.Write("查询器sql：" + sql);

                DataTable dt = DBServiceHelper.ExecuteDataSet(Context, sql).Tables[0];