From 26442f48020b19571df22341ca259775c38ff79e Mon Sep 17 00:00:00 2001
From: yangle <admin@YINMOU>
Date: 星期二, 23 一月 2024 08:30:57 +0800
Subject: [PATCH] 销售订单子表 增加 3个字段： 客户物料编码 、客户物料名称、客户规格型号 生产订单子表 增加 3个字段： 客户物料编码 、客户物料名称、客户规格型号（如果已经有了就不增加） 销售订单下推时，将这3个字段默认带入到生产订单界面上， 可修改 保存。
---
WebAPI/Controllers/LMESController.cs | 9 ++++++++-
1 files changed, 8 insertions(+), 1 deletions(-)
diff --git a/WebAPI/Controllers/LMESController.cs b/WebAPI/Controllers/LMESController.cs
index a1fe776..fbacc0b 100644
--- a/WebAPI/Controllers/LMESController.cs
+++ b/WebAPI/Controllers/LMESController.cs
@@ -572,6 +572,7 @@
//鑾峰彇绯荤粺鍙傛暟
string Ret = "";
+ string Count = "";
if (oSystemParameter.ShowBill(ref Ret))
{
//鍒ゆ柇瀹㈡埛涓洪緳灞辨苯閰�
@@ -582,10 +583,16 @@
sWhere += sql_splice;
}
+ //鍒ゆ柇瀹㈡埛涓虹憺涓庣ズ
+ if (oSystemParameter.omodel.WMS_CampanyName == "鐟炰笌绁�")
+ {
+ Count = "top 1000";
+ }
}
+
SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
- ds = oCN.RunProcReturn("select * from h_v_Sc_ProcessExchangeIssueBillQuery where 1 = 1 " + sWhere + " order by hmainid desc ", "h_v_Sc_ProcessExchangeIssueBillQuery");
+ ds = oCN.RunProcReturn("select " + Count + " * from h_v_Sc_ProcessExchangeIssueBillQuery where 1 = 1 " + sWhere + " order by hmainid desc,CONVERT(int,娴佹按鍙�) asc", "h_v_Sc_ProcessExchangeIssueBillQuery");
objJsonResult.code = "1";
objJsonResult.count = 1;
objJsonResult.Message = "Sucess锛�";
--
Gitblit v1.9.1