From 2a363a58ad45f09afdcc0a2c54383b0a76ea1208 Mon Sep 17 00:00:00 2001
From: zrg <z18737863051@163.com>
Date: 星期一, 12 八月 2024 08:51:45 +0800
Subject: [PATCH] 增加工艺参数大类分析报表方法,新增字段 HTechParamClassID int //工艺参数大类（Gy_TechnologyParameterClass） HSNO int //工艺次序 HStdNextTimes money //理论次序间隔 HTechParamIDStd int //对应设定值工艺参数(Gy_TechnologyParameter)
---
WebAPI/Controllers/CJGL/Sc_ProcessExchangeBillController.cs | 7 +++----
1 files changed, 3 insertions(+), 4 deletions(-)
diff --git a/WebAPI/Controllers/CJGL/Sc_ProcessExchangeBillController.cs b/WebAPI/Controllers/CJGL/Sc_ProcessExchangeBillController.cs
index 317ab6b..520f9c4 100644
--- a/WebAPI/Controllers/CJGL/Sc_ProcessExchangeBillController.cs
+++ b/WebAPI/Controllers/CJGL/Sc_ProcessExchangeBillController.cs
@@ -1170,7 +1170,7 @@
string sql = string.Format(@"select * from h_v_Sc_ProcessExchangeBillQuerySub");
- ds = oCN.RunProcReturn(sql + " where hmainid=" + HInterID + " and 鍑虹珯鍏宠仈鏁伴噺=0 and cast(娴佹按鍙� as int)>" + ds1 .Tables[0].Rows[0][0].ToString(), "h_v_Sc_ProcessExchangeBillQuerySub");
+ ds = oCN.RunProcReturn(sql + " where hmainid=" + HInterID + " and 鍑虹珯鍏宠仈鏁伴噺=0 and cast(娴佹按鍙� as int)>" + ds1 .Tables[0].Rows[0][0].ToString()+ " order by cast(娴佹按鍙� as int) ", "h_v_Sc_ProcessExchangeBillQuerySub");
if (float.Parse(ds.Tables[0].Rows[0]["杩涚珯鍏宠仈鏁伴噺"].ToString()) > 0)
{
@@ -1246,9 +1246,9 @@
objJsonResult.data = 1;
return objJsonResult;
}
-
+ int num = oItem.HBillNo.Split('-').Length;
oBill.omodel.HMaker = msg5; //鍒跺崟浜�
- oBill.omodel.HNo = DBUtility.ClsPub.isLong(oItem.HBillNo.Split('-')[1]);
+ oBill.omodel.HNo = DBUtility.ClsPub.isLong(oItem.HBillNo.Split('-')[num - 1]);
oBill.omodel.HYear = DBUtility.ClsPub.isLong(DateTime.Now.Year);
oBill.omodel.HPeriod = DBUtility.ClsPub.isLong(DateTime.Now.Month);
oBill.omodel.HDate = oItem.HDate;// 鏃ユ湡
@@ -1312,7 +1312,6 @@
j++;
}
}
-
//淇濆瓨
//淇濆瓨瀹屾瘯鍚庡鐞�
--
Gitblit v1.9.1