From 1bf3dc43e38f780864b7030f2a8aca8bf01abc05 Mon Sep 17 00:00:00 2001
From: yusijie <ysj@hz-kingdee.com>
Date: 星期四, 01 八月 2024 17:10:02 +0800
Subject: [PATCH] 1
---
WebAPI/Controllers/CGGL/Cg_PayableBillController.cs | 39 ++++++++++++++++++++++++++++++++++-----
1 files changed, 34 insertions(+), 5 deletions(-)
diff --git a/WebAPI/Controllers/CGGL/Cg_PayableBillController.cs b/WebAPI/Controllers/CGGL/Cg_PayableBillController.cs
index d0dae79..acfea6f 100644
--- a/WebAPI/Controllers/CGGL/Cg_PayableBillController.cs
+++ b/WebAPI/Controllers/CGGL/Cg_PayableBillController.cs
@@ -85,10 +85,11 @@
string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries);
string msg2 = sArray[0].ToString(); //琛ㄥご鏁版嵁
string msg3 = sArray[1].ToString(); //瀛愯〃1鏁版嵁
- string refSav = sArray[2].ToString(); //鎿嶄綔鏂瑰紡
- string msg4 = sArray[3].ToString(); //鐢ㄦ埛
+ string msg4 = sArray[2].ToString(); //瀛愯〃2鏁版嵁
+ string refSav = sArray[3].ToString(); //鎿嶄綔鏂瑰紡
+ string msg5 = sArray[4].ToString(); //鐢ㄦ埛
- DBUtility.ClsPub.CurUserName = msg4;
+ DBUtility.ClsPub.CurUserName = msg5;
string UserName = "";
string s = "";
@@ -189,6 +190,27 @@
oBill.DetailColl.Add(oItemSub);
}
+ //瀛愯〃Entry
+ //鎸� },{鏉ユ媶鍒嗘暟缁� //鍘绘帀銆愬拰銆�
+ msg4 = msg4.Substring(1, msg4.Length - 2);
+ msg4 = msg4.Replace("\\", "");
+ msg4 = msg4.Replace("\n", ""); //\n
+ //msg2 = msg2.Replace("'", "鈥�");
+ List<Model.ClsCg_PayableSub> ls2 = new List<Model.ClsCg_PayableSub>();
+ ls2 = oListModels.getObjectByJson_Cg_PayableSub(msg4);
+ int j = 0;
+ foreach (Model.ClsCg_PayableSub oItemSub in ls2)
+ {
+ j++;
+ oItemSub.HEntryID = j;
+
+ oItemSub.HCloseMan = ""; //琛屽叧闂�
+ oItemSub.HEntryCloseDate = DBUtility.ClsPub.isDate(DateTime.Now);
+ oItemSub.HCloseType = false; //鍏抽棴绫诲瀷
+
+ oBill.DetailCol2.Add(oItemSub);
+
+ }
//杩涜 浼氳鏈熼棿 缁撹处 鐨勫垽鏂拰鎺у埗
int sYear = 0;
@@ -253,6 +275,7 @@
try
{
ds = oCN.RunProcReturn("select * from h_v_Cg_PayableBillList_EditInit where hmainid=" + HInterID, "h_v_Cg_PayableBillList_EditInit");
+ objJsonResult.data = ds.Tables[0];
if (ds == null || ds.Tables[0].Rows.Count == 0)
{
objJsonResult.code = "0";
@@ -263,10 +286,16 @@
}
else
{
+ ds = oCN.RunProcReturn(@"select a.*,mater.HNumber AS 鐗╂枡浠ｇ爜, mater.HName AS 鐗╂枡鍚嶇О, mater.HModel AS 瑙勬牸鍨嬪彿, mater.HUnitID, unit.HName AS 璁￠噺鍗曚綅 from Cg_PayableSub_Entry AS a LEFT OUTER JOIN
+ dbo.Gy_Material AS mater ON a.HMaterID = mater.HItemID LEFT OUTER JOIN
+ dbo.Gy_Unit AS unit ON mater.HUnitID = unit.HItemID where HInterID=" + HInterID, "Cg_PayableSub_Entry");
+ List<Object> dataTables = new List<Object>();
+ dataTables.Add(ds.Tables[0]);
objJsonResult.code = "1";
objJsonResult.count = 1;
objJsonResult.Message = "Sucess锛�";
- objJsonResult.data = ds.Tables[0];
+ objJsonResult.list = dataTables;
+
return objJsonResult;
}
}
@@ -364,7 +393,7 @@
oCN.RunProc("delete from Cg_PayableBillMain where HInterID = " + HInterID);
oCN.RunProc("delete from Cg_PayableSub where HInterID= " + HInterID);
-
+ oCN.RunProc("delete from Cg_PayableSub_Entry where HInterID= " + HInterID);
////鍒犻櫎鍚庢帶鍒�==================================================================================
//string sql2 = "exec h_p_Xs_ReceivableBill_AfterDelCtrl " + BillOld.omodel.HInterID + ",'" + BillOld.omodel.HBillNo + "','" + user + "'";
//ds = oCN.RunProcReturn(sql2, "h_p_Xs_ReceivableBill_AfterDelCtrl");
--
Gitblit v1.9.1