From 7b776d93b25a2e9d6e2210d581c1e2998e4fc8ae Mon Sep 17 00:00:00 2001
From: yusijie <ysj@hz-kingdee.com>
Date: 星期一, 05 八月 2024 17:32:18 +0800
Subject: [PATCH] 1
---
WebAPI/Controllers/XSGL/Xs_ReceivableBillController.cs | 41 +++++++++++++++++++++++++++++++++++------
1 files changed, 35 insertions(+), 6 deletions(-)
diff --git a/WebAPI/Controllers/XSGL/Xs_ReceivableBillController.cs b/WebAPI/Controllers/XSGL/Xs_ReceivableBillController.cs
index 9ac25a4..0741fc4 100644
--- a/WebAPI/Controllers/XSGL/Xs_ReceivableBillController.cs
+++ b/WebAPI/Controllers/XSGL/Xs_ReceivableBillController.cs
@@ -94,10 +94,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 = "";
@@ -105,7 +106,7 @@
try
{
//缂栬緫鏉冮檺
- if (!DBUtility.ClsPub.Security_Log_second("Xs_ReceivableBill_Edit", 1, false, msg4))
+ if (!DBUtility.ClsPub.Security_Log_second("Xs_ReceivableBill_Edit", 1, false, msg5))
{
objJsonResult.code = "0";
objJsonResult.count = 0;
@@ -207,6 +208,28 @@
}
+ //瀛愯〃Entry
+ //鎸� },{鏉ユ媶鍒嗘暟缁� //鍘绘帀銆愬拰銆�
+ msg4 = msg4.Substring(1, msg4.Length - 2);
+ msg4 = msg4.Replace("\\", "");
+ msg4 = msg4.Replace("\n", ""); //\n
+ //msg2 = msg2.Replace("'", "鈥�");
+ List<Model.ClsXs_ReceivableBillSub> ls2 = new List<Model.ClsXs_ReceivableBillSub>();
+ ls2 = oListModels.getObjectByJson_Xs_ReceivableBillSub(msg4);
+ int j = 0;
+ foreach (Model.ClsXs_ReceivableBillSub 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;
@@ -270,6 +293,7 @@
try
{
ds = oCN.RunProcReturn("select * from h_v_Xs_ReceivableBillList_EditInit where hmainid=" + HInterID, "h_v_Xs_ReceivableBillList_EditInit");
+ objJsonResult.data = ds.Tables[0];
if (ds == null || ds.Tables[0].Rows.Count == 0)
{
objJsonResult.code = "0";
@@ -280,10 +304,15 @@
}
else
{
+ ds = oCN.RunProcReturn(@"select a.*,mater.HNumber AS 鐗╂枡浠ｇ爜, mater.HName AS 鐗╂枡鍚嶇О, mater.HModel AS 瑙勬牸鍨嬪彿, mater.HUnitID, unit.HName AS 璁￠噺鍗曚綅 from Xs_ReceivableBillSub_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, "Xs_ReceivableBillSub_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;
}
}
@@ -399,7 +428,7 @@
oCN.RunProc("delete from Xs_ReceivableBillMain where HInterID = " + HInterID);
oCN.RunProc("delete from Xs_ReceivableBillSub where HInterID= " + HInterID);
-
+ oCN.RunProc("delete from Xs_ReceivableBillSub_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