From 1c3a5fd0f49506c1ef68a4dbf3a44ef2ef3600d8 Mon Sep 17 00:00:00 2001
From: zrg <z18737863051@163.com>
Date: 星期四, 21 十一月 2024 16:43:09 +0800
Subject: [PATCH] 优化热处理/干燥机从 全程报表跳转获取开始结束时间,增加PDA开工单保存,增加设备工艺参数趋势图 增加根据物料+设备+工序 获取 产品工艺参数清单 工艺参数 增加 根据流转卡+工序 获取设备
---
WebAPI/Controllers/项目管理/工程项目/PM_ProjectBillController.cs | 115 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++-
1 files changed, 113 insertions(+), 2 deletions(-)
diff --git "a/WebAPI/Controllers/\351\241\271\347\233\256\347\256\241\347\220\206/\345\267\245\347\250\213\351\241\271\347\233\256/PM_ProjectBillController.cs" "b/WebAPI/Controllers/\351\241\271\347\233\256\347\256\241\347\220\206/\345\267\245\347\250\213\351\241\271\347\233\256/PM_ProjectBillController.cs"
index eece527..26184fa 100644
--- "a/WebAPI/Controllers/\351\241\271\347\233\256\347\256\241\347\220\206/\345\267\245\347\250\213\351\241\271\347\233\256/PM_ProjectBillController.cs"
+++ "b/WebAPI/Controllers/\351\241\271\347\233\256\347\256\241\347\220\206/\345\267\245\347\250\213\351\241\271\347\233\256/PM_ProjectBillController.cs"
@@ -98,6 +98,33 @@
public string HPicNo;
public string HWorkTask;
public string HProjectNote;
+ public string HContacts;
+ public string HContactNumber;
+
+ public int HSupplierID; //鍒嗗寘鍗曚綅锛坓y_supllier锛�
+ public int HMangerEmpID; //绠＄悊鍛橈紙gy_Employee锛�
+ public string HMaterPlanDate; //鏉愭枡璁″垝
+ public int HWorkerID; //鏂藉伐鍛橈紙gy_Employee锛�
+ public double HPlanWorkTimes; //璁″垝宸ユ湡
+ public double HRelWorkTimes; //瀹為檯宸ユ湡
+ public string HTestDate; //璇曞帇鏃ユ湡
+ public int HTestCheckerID; //璇曞帇楠屾敹浜猴紙gy_Employee锛�
+ public string HTestNote; //璇曞帇璁板綍锛堝瘜鏂囨湰锛�
+ public string HSewageDate; //鎺掓薄鏃ユ湡
+ public string HWaterSupplyDate; //閫氭按鏃ユ湡
+ public string HWorkNote; //绔ｅ伐璧勬枡锛堝瘜鏂囨湰锛�
+ public string HWorkProcNote; //鏂藉伐瀹屾垚鎯呭喌锛堝瘜鏂囨湰锛�
+
+ public double HYuSuanMoney; //棰勭畻閫犱环
+ public double HHeTongMoney; //鍚堝悓閫犱环
+ public double HJieSuanMoney; //缁撶畻閫犱环
+ public double HShenJiMoney; //瀹¤閫犱环
+ public double HCaiLiaoMoney; //鏉愭枡璐�
+ public double HAnZhuangMoney; //瀹夎璐�
+ public double HBanZuMoney; //鐝粍宸ヨ垂
+ public double HYuShouKuanMoney; //棰勬敹娆�
+ public double HGongFeiMoney; //宸ヨ垂缁撹处
+ public double HJieZhangMoney; //缁撶畻缁撹处
}
#endregion
@@ -250,6 +277,36 @@
string HPicNo = mainList[0].HPicNo;
string HWorkTask = mainList[0].HWorkTask;
string HProjectNote = mainList[0].HProjectNote;
+ string HContacts = mainList[0].HContacts;
+ string HContactNumber = mainList[0].HContactNumber;
+
+
+ int HSupplierID = mainList[0].HSupplierID; //鍒嗗寘鍗曚綅锛坓y_supllier锛�
+ int HMangerEmpID = mainList[0].HMangerEmpID; //绠＄悊鍛橈紙gy_Employee锛�
+ string HMaterPlanDate = mainList[0].HMaterPlanDate; //鏉愭枡璁″垝
+ int HWorkerID = mainList[0].HWorkerID; //鏂藉伐鍛橈紙gy_Employee锛�
+ double HPlanWorkTimes = mainList[0].HPlanWorkTimes; //璁″垝宸ユ湡
+ double HRelWorkTimes = mainList[0].HRelWorkTimes; //瀹為檯宸ユ湡
+ string HTestDate = mainList[0].HTestDate; //璇曞帇鏃ユ湡
+ int HTestCheckerID = mainList[0].HTestCheckerID; //璇曞帇楠屾敹浜猴紙gy_Employee锛�
+ string HTestNote = mainList[0].HTestNote; //璇曞帇璁板綍锛堝瘜鏂囨湰锛�
+ string HSewageDate = mainList[0].HSewageDate; //鎺掓薄鏃ユ湡
+ string HWaterSupplyDate = mainList[0].HWaterSupplyDate; //閫氭按鏃ユ湡
+ string HWorkNote = mainList[0].HWorkNote; //绔ｅ伐璧勬枡锛堝瘜鏂囨湰锛�
+ string HWorkProcNote = mainList[0].HWorkProcNote; //鏂藉伐瀹屾垚鎯呭喌锛堝瘜鏂囨湰锛�
+
+ double HYuSuanMoney = mainList[0].HYuSuanMoney; //棰勭畻閫犱环
+ double HHeTongMoney = mainList[0].HHeTongMoney; //鍚堝悓閫犱环
+ double HJieSuanMoney = mainList[0].HJieSuanMoney; //缁撶畻閫犱环
+ double HShenJiMoney = mainList[0].HShenJiMoney; //瀹¤閫犱环
+ double HCaiLiaoMoney = mainList[0].HCaiLiaoMoney; //鏉愭枡璐�
+ double HAnZhuangMoney = mainList[0].HAnZhuangMoney; //瀹夎璐�
+ double HBanZuMoney = mainList[0].HBanZuMoney; //鐝粍宸ヨ垂
+ double HYuShouKuanMoney = mainList[0].HYuShouKuanMoney; //棰勬敹娆�
+ double HGongFeiMoney = mainList[0].HGongFeiMoney; //宸ヨ垂缁撹处
+ double HJieZhangMoney = mainList[0].HJieZhangMoney; //缁撶畻缁撹处
+
+
if (OperationType == 2)
{
ds = oCN.RunProcReturn("select * from PM_ProjectBillMain where HBillNo ='" + HBillNo + "'", "PM_ProjectBillMain");
@@ -269,7 +326,8 @@
{
string sql = "insert into PM_ProjectBillMain" +
"(HYear,HPeriod,HBillType,HBillSubType,HInterID,HDate,HBillNo,HBillStatus,HRemark,HMaker,HMakeDate,HProNumber,HProName,HCusID,HBeginDate,HEndDate,HSumMoney," +
- "HProMoney,HWorkMoney,HOtherMoney,HProType,HPMEmpID,HWorkEmpID,HDepEmpID,HConWorkDays,HDepDays,HLastMoney,HPayCusID,HOrgID,HMaterID,HProjectClassID,HBuildComp,HBuildAddress,HWorkNo,HReDate,HPicNo,HWorkTask,HProjectNote) " +
+ "HProMoney,HWorkMoney,HOtherMoney,HProType,HPMEmpID,HWorkEmpID,HDepEmpID,HConWorkDays,HDepDays,HLastMoney,HPayCusID,HOrgID,HMaterID,HProjectClassID,HBuildComp,HBuildAddress,HWorkNo,HReDate,HPicNo,HWorkTask,HProjectNote,HContacts,HContactNumber" +
+ ",HSupplierID,HMangerEmpID,HMaterPlanDate,HWorkerID,HPlanWorkTimes,HRelWorkTimes,HTestDate,HTestCheckerID,HTestNote,HSewageDate,HWaterSupplyDate,HWorkNote,HWorkProcNote,HYuSuanMoney,HHeTongMoney,HJieSuanMoney,HShenJiMoney,HCaiLiaoMoney,HAnZhuangMoney,HBanZuMoney,HYuShouKuanMoney,HGongFeiMoney,HJieZhangMoney) " +
"values(" +
"" + HYear +
"," + HPeriod +
@@ -309,7 +367,32 @@
"','" + HPicNo +
"','" + HWorkTask +
"','" + HProjectNote +
- "')";
+ "','" + HContacts +
+ "','" + HContactNumber +
+ "','" + HSupplierID + "'" +
+ ",'" + HMangerEmpID + "'" +
+ ",'" + HMaterPlanDate + "'" +
+ ",'" + HWorkerID + "'" +
+ ",'" + HPlanWorkTimes + "'" +
+ ",'" + HRelWorkTimes + "'" +
+ ",'" + HTestDate + "'" +
+ ",'" + HTestCheckerID + "'" +
+ ",'" + HTestNote + "'" +
+ ",'" + HSewageDate + "'" +
+ ",'" + HWaterSupplyDate + "'" +
+ ",'" + HWorkNote + "'" +
+ ",'" + HWorkProcNote + "'" +
+ ",'" + HYuSuanMoney + "'" +
+ ",'" + HHeTongMoney + "'" +
+ ",'" + HJieSuanMoney + "'" +
+ ",'" + HShenJiMoney + "'" +
+ ",'" + HCaiLiaoMoney + "'" +
+ ",'" + HAnZhuangMoney + "'" +
+ ",'" + HBanZuMoney + "'" +
+ ",'" + HYuShouKuanMoney + "'" +
+ ",'" + HGongFeiMoney + "'" +
+ ",'" + HJieZhangMoney + "'" +
+ ")";
//涓昏〃
oCN.RunProc(sql);
@@ -356,6 +439,34 @@
"',HPicNo = '" + HPicNo +
"',HWorkTask = '" + HWorkTask +
"',HProjectNote ='" + HProjectNote +
+ "',HContacts ='" + HContacts +
+ "',HContactNumber ='" + HContactNumber +
+
+ "',HSupplierID = '" + HSupplierID +
+ "',HMangerEmpID = '" + HMangerEmpID +
+ "',HMaterPlanDate = '" + HMaterPlanDate +
+ "',HWorkerID = '" + HWorkerID +
+ "',HPlanWorkTimes = '" + HPlanWorkTimes +
+ "',HRelWorkTimes = '" + HRelWorkTimes +
+ "',HTestDate = '" + HTestDate +
+ "',HTestCheckerID = '" + HTestCheckerID +
+ "',HTestNote = '" + HTestNote +
+ "',HSewageDate = '" + HSewageDate +
+ "',HWaterSupplyDate = '" + HWaterSupplyDate +
+ "',HWorkNote = '" + HWorkNote +
+ "',HWorkProcNote = '" + HWorkProcNote +
+ "',HYuSuanMoney = '" + HYuSuanMoney +
+ "',HHeTongMoney = '" + HHeTongMoney +
+ "',HJieSuanMoney = '" + HJieSuanMoney +
+ "',HShenJiMoney = '" + HShenJiMoney +
+ "',HCaiLiaoMoney = '" + HCaiLiaoMoney +
+ "',HAnZhuangMoney = '" + HAnZhuangMoney +
+ "',HBanZuMoney = '" + HBanZuMoney +
+ "',HYuShouKuanMoney = '" + HYuShouKuanMoney +
+ "',HGongFeiMoney = '" + HGongFeiMoney +
+ "',HJieZhangMoney = '" + HJieZhangMoney +
+
+
"' where HInterID = " + HInterID;
oCN.RunProc(sql);
--
Gitblit v1.9.1