From ae60d9f94c079f97310e676e8fa10319c0a2c070 Mon Sep 17 00:00:00 2001
From: yxj <yxj@hz-kingdee.com>
Date: 星期四, 31 八月 2023 13:44:46 +0800
Subject: [PATCH] 新增涤纶半成品生成条码模块，称重入库条码生成模块数量存入修改
---
WebAPI/Controllers/项目管理/项目阶段/Gy_ProjectStageController.cs | 145 ++++++++++++++++++++++++++++++++++++++----------
1 files changed, 115 insertions(+), 30 deletions(-)
diff --git "a/WebAPI/Controllers/\351\241\271\347\233\256\347\256\241\347\220\206/\351\241\271\347\233\256\351\230\266\346\256\265/Gy_ProjectStageController.cs" "b/WebAPI/Controllers/\351\241\271\347\233\256\347\256\241\347\220\206/\351\241\271\347\233\256\351\230\266\346\256\265/Gy_ProjectStageController.cs"
index 992eec1..f7e15ea 100644
--- "a/WebAPI/Controllers/\351\241\271\347\233\256\347\256\241\347\220\206/\351\241\271\347\233\256\351\230\266\346\256\265/Gy_ProjectStageController.cs"
+++ "b/WebAPI/Controllers/\351\241\271\347\233\256\347\256\241\347\220\206/\351\241\271\347\233\256\351\230\266\346\256\265/Gy_ProjectStageController.cs"
@@ -203,12 +203,12 @@
if (sWhere == null || sWhere.Equals(""))
{
- ds = oCN.RunProcReturn("select * from h_v_Gy_ProjectStage order by 闃舵缂栫爜 ", "h_v_Gy_ProjectStage");
+ ds = oCN.RunProcReturn("select * from h_v_Gy_ProjectStage order by 闃舵缂栫爜 desc", "h_v_Gy_ProjectStage");
}
else
{
string sql1 = "select * from h_v_Gy_ProjectStage where 1 = 1 ";
- string sql = sql1 + sWhere + " order by 闃舵缂栫爜 ";
+ string sql = sql1 + sWhere + " order by 闃舵缂栫爜 desc";
ds = oCN.RunProcReturn(sql, "h_v_Gy_ProjectStage");
}
@@ -1321,7 +1321,10 @@
public int HInterID;
public string HBillNo;
public string HDate;
+ public int HProID;
public string HProNumber;
+ public string HMainSourceBillNo;
+ public string HMainSourceBillType;
public int HProjectStageID;
public string HProjectStageName;
public string HStageNote;
@@ -1434,6 +1437,9 @@
objJsonResult.data = null;
return objJsonResult;
}
+ }else if (OperationType == 4)
+ {
+
}
msg2 = "[" + msg2.ToString() + "]";
@@ -1448,7 +1454,10 @@
int HInterID = mainList[0].HInterID;
string HBillNo = mainList[0].HBillNo;
string HDate = mainList[0].HDate;
+ int HProID = mainList[0].HProID;
string HProNumber = mainList[0].HProNumber;
+ string HMainSourceBillNo = mainList[0].HMainSourceBillNo;
+ string HMainSourceBillType = mainList[0].HMainSourceBillType;
int HProjectStageID = mainList[0].HProjectStageID;
string HStageNote = mainList[0].HStageNote;
string HRelationGoods = mainList[0].HRelationGoods;
@@ -1465,7 +1474,7 @@
string HMakerDate = mainList[0].HMakerDate;
string HUpdater = mainList[0].HUpdater;
string HUpdaterDate = mainList[0].HUpdaterDate;
-
+
if (OperationType == 2)
{
@@ -1552,9 +1561,48 @@
//璁板綍鏃ュ織
LogService.Write("鐢ㄦ埛:" + user + ",鏃ユ湡:" + DateTime.Now + ",淇敼椤圭洰闃舵姹囨姤:" + HBillNo);
oCN.RunProc("Insert into System_log (GeginDate, userid, WorkstationName, WorkList, SystemName, NetuserName, State) select GETDATE(),'" + user + "','" + HComputerName + "','" + "淇敼椤圭洰闃舵姹囨姤锛�" + HBillNo + "','LMES-椤圭洰闃舵姹囨姤妯″潡','" + DBUtility.ClsPub.IPAddress + "','淇敼鍗曟嵁'", ref DBUtility.ClsPub.sExeReturnInfo);
+ }else if(OperationType == 4 && ds.Tables[0].Rows.Count == 0 ) //涓嬫帹-鏂板
+ {
+ string sql = "insert into PM_ProjectReportBillMain" +
+ "(HYear,HPeriod,HBillType,HBillSubType,HInterID,HDate,HBillNo,HBillStatus,HRemark,HMaker,HMakeDate" +
+ ",HProNumber,HProjectStageID,HStageNote,HRelationGoods,HIsKey,HReportEmpID,HReportNote,HReportGoods,HReceiveEmp,HCopyEmp,HRate,HOrgID,HMainSourceInterID,HMainSourceEntryID,HMainSourceBillType,HMainSourceBillNo) " +
+ "values(" +
+ "" + HYear +
+ "," + HPeriod +
+ ",'" + HBillType +
+ "','" + HBillSubType +
+ "'," + HInterID +
+ ",'" + HDate +
+ "','" + HBillNo +
+ "'," + HBillStatus +
+ ",'" + HRemark +
+ "','" + HMaker +
+ "','" + HMakerDate +
+ "','" + HProNumber +
+ "'," + HProjectStageID +
+ ",'" + HStageNote +
+ "','" + HRelationGoods +
+ "'," + HIsKey +
+ "," + HReportEmpID +
+ ",'" + HReportNote +
+ "','" + HReportGoods +
+ "','" + HReceiveEmp +
+ "','" + HCopyEmp +
+ "'," + HRate +
+ "," + HOrgID +
+ "," + HProID +
+ "," + HProjectStageID +
+ ",'" + HMainSourceBillType +
+ "','" + HMainSourceBillNo +
+ "')";
+
+ //涓昏〃
+ oCN.RunProc(sql);
+ LogService.Write("鐢ㄦ埛:" + user + ",鏃ユ湡:" + DateTime.Now + ",鏂板椤圭洰闃舵姹囨姤:" + HBillNo);
+ oCN.RunProc("Insert into System_log (GeginDate, userid, WorkstationName, WorkList, SystemName, NetuserName, State) select GETDATE(),'" + user + "','" + HComputerName + "','" + "鏂板椤圭洰闃舵姹囨姤锛�" + HBillNo + "','LMES-椤圭洰闃舵姹囨姤妯″潡','" + DBUtility.ClsPub.IPAddress + "','鏂板鍗曟嵁'", ref DBUtility.ClsPub.sExeReturnInfo);
}
//淇濆瓨瀛愯〃
- objJsonResult = AddBillSub_ProjectReportBill(msg3, HInterID, HBillNo, OperationType);
+ objJsonResult = AddBillSub_ProjectReportBill(msg3, HInterID, HBillNo, OperationType,HProID, HProjectStageID, HMainSourceBillType, HMainSourceBillNo);
if (objJsonResult.code == "0")
{
@@ -1582,36 +1630,73 @@
}
#endregion
#region 娣诲姞椤圭洰闃舵娓呭崟 瀛愯〃
- public json AddBillSub_ProjectReportBill(string msg3, long HInterID, string HBillNo, int OperationType)
+ public json AddBillSub_ProjectReportBill(string msg3, long HInterID, string HBillNo, int OperationType, int HSourceInterID, int HSourceEntryID, string HSourceBillType, string HSourceBillNo)
{
List<PM_ProjectReportBill_Sub> DetailColl = Newtonsoft.Json.JsonConvert.DeserializeObject<List<PM_ProjectReportBill_Sub>>(msg3);
int i = 0; //浣滀负瀛愯〃鍐呯爜
- foreach (PM_ProjectReportBill_Sub oSub in DetailColl)
+ if(OperationType == 4)
{
- i++; //鍚屼竴涓富琛ㄤ笅鐨勫瓙琛ㄧ殑鍐呯爜鑷
+ foreach (PM_ProjectReportBill_Sub oSub in DetailColl)
+ {
+ i++; //鍚屼竴涓富琛ㄤ笅鐨勫瓙琛ㄧ殑鍐呯爜鑷
- int HEntryID = i;
- int HEmpID = oSub.HEmpID;
- int HIsPM = oSub.HIsPM?1:0;
- double HRate = oSub.HRate;
- double HAvgMoney = oSub.HAvgMoney;
- double HCountMoney = oSub.HCountMoney;
- string HRemarkSub = oSub.HRemarkSub;
- string sql = "insert into PM_ProjectReportBillSub" +
- "(HInterID,HBillNo_bak,HEntryID,HRemark,HEmpID,HIsPM,HRate,HAvgMoney,HCountMoney) " +
- "values(" +
- "" + HInterID +
- ",'" + HBillNo +
- "'," + HEntryID +
- ",'" + HRemarkSub +
- "'," + HEmpID +
- "," + HIsPM +
- "," + HRate +
- "," + HAvgMoney +
- "," + HCountMoney +
- ")";
- oCN.RunProc(sql);
+ int HEntryID = i;
+ int HEmpID = oSub.HEmpID;
+ int HIsPM = oSub.HIsPM ? 1 : 0;
+ double HRate = oSub.HRate;
+ double HAvgMoney = oSub.HAvgMoney;
+ double HCountMoney = oSub.HCountMoney;
+ string HRemarkSub = oSub.HRemarkSub;
+ string sql = "insert into PM_ProjectReportBillSub" +
+ "(HInterID,HBillNo_bak,HEntryID,HRemark,HEmpID,HIsPM,HRate,HAvgMoney,HCountMoney,HSourceInterID,HSourceEntryID,HSourceBillType,HSourceBillNo) " +
+ "values(" +
+ "" + HInterID +
+ ",'" + HBillNo +
+ "'," + HEntryID +
+ ",'" + HRemarkSub +
+ "'," + HEmpID +
+ "," + HIsPM +
+ "," + HRate +
+ "," + HAvgMoney +
+ "," + HCountMoney +
+ "," + HSourceInterID +
+ "," + HSourceEntryID +
+ ",'" + HSourceBillType +
+ "','" + HSourceBillNo +
+ "')";
+ oCN.RunProc(sql);
+ }
}
+ else
+ {
+ foreach (PM_ProjectReportBill_Sub oSub in DetailColl)
+ {
+ i++; //鍚屼竴涓富琛ㄤ笅鐨勫瓙琛ㄧ殑鍐呯爜鑷
+
+ int HEntryID = i;
+ int HEmpID = oSub.HEmpID;
+ int HIsPM = oSub.HIsPM ? 1 : 0;
+ double HRate = oSub.HRate;
+ double HAvgMoney = oSub.HAvgMoney;
+ double HCountMoney = oSub.HCountMoney;
+ string HRemarkSub = oSub.HRemarkSub;
+ string sql = "insert into PM_ProjectReportBillSub" +
+ "(HInterID,HBillNo_bak,HEntryID,HRemark,HEmpID,HIsPM,HRate,HAvgMoney,HCountMoney) " +
+ "values(" +
+ "" + HInterID +
+ ",'" + HBillNo +
+ "'," + HEntryID +
+ ",'" + HRemarkSub +
+ "'," + HEmpID +
+ "," + HIsPM +
+ "," + HRate +
+ "," + HAvgMoney +
+ "," + HCountMoney +
+ ")";
+ oCN.RunProc(sql);
+ }
+ }
+
objJsonResult.code = "1";
objJsonResult.count = 1;
@@ -1647,12 +1732,12 @@
if (sWhere == null || sWhere.Equals(""))
{
- ds = oCN.RunProcReturn("select * from h_v_PM_ProjectReportBillList order by 鍗曟嵁鍙� ", "h_v_PM_ProjectReportBillList");
+ ds = oCN.RunProcReturn("select * from h_v_PM_ProjectReportBillList order by 鍗曟嵁鍙� desc ", "h_v_PM_ProjectReportBillList");
}
else
{
string sql1 = "select * from h_v_PM_ProjectReportBillList where 1 = 1 ";
- string sql = sql1 + sWhere + " order by 鍗曟嵁鍙� ";
+ string sql = sql1 + sWhere + " order by 鍗曟嵁鍙� desc ";
ds = oCN.RunProcReturn(sql, "h_v_PM_ProjectReportBillList");
}
--
Gitblit v1.9.1