From d22bbad221b392dcf606e5cca06f83b3a7b10eb7 Mon Sep 17 00:00:00 2001
From: duhe <226547893@qq.com>
Date: 星期四, 09 十一月 2023 21:08:30 +0800
Subject: [PATCH] 生产订单变更单：审核后反写生产订单的数量
---
WebAPI/Controllers/XSGL/Xs_CusRatingChangeBillController.cs | 27 +++++++++++++++++++++++++++
1 files changed, 27 insertions(+), 0 deletions(-)
diff --git a/WebAPI/Controllers/XSGL/Xs_CusRatingChangeBillController.cs b/WebAPI/Controllers/XSGL/Xs_CusRatingChangeBillController.cs
index fbc3a11..d8ed3a9 100644
--- a/WebAPI/Controllers/XSGL/Xs_CusRatingChangeBillController.cs
+++ b/WebAPI/Controllers/XSGL/Xs_CusRatingChangeBillController.cs
@@ -468,9 +468,36 @@
//杩涜闇�瑕佽繘琛岀殑瀹℃牳/鍙嶅鏍告搷浣�
if (IsAudit == 0) //瀹℃牳鎻愪氦
{
+ //鍙嶅啓瀹㈡埛淇＄敤棰濆害
+ oCN.BeginTran();
+ string sql = "select * from Gy_Customer_Credit where HCusID = " + oBill.omodel.HCusID;
+ ds = oCN.RunProcReturn(sql, "Gy_Customer_Credit");
+ if (ds.Tables[0].Rows.Count == 0)
+ {
+ sql = "insert into Gy_Customer_Credit" +
+ "(HCusID,HCreditRating_Now,HUpdateTime,HUpdateMan)" +
+ " values(" +
+ "" + oBill.omodel.HCusID +
+ "," + oBill.omodel.HNewRating +
+ ",'" + DateTime.Now.ToString("yyyy-MM-dd") + "'" +
+ ",'" + CurUserName + "'" +
+ ")";
+ oCN.RunProc(sql);
+ }
+ else
+ {
+ sql = "update Gy_Customer_Credit set " +
+ "HCreditRating_Now = " + oBill.omodel.HNewRating +
+ ",HUpdateTime = '" + DateTime.Now.ToString("yyyy-MM-dd") + "'" +
+ ",HUpdateMan = '" + CurUserName + "'" +
+ " where HCusID = " + oBill.omodel.HCusID;
+ oCN.RunProc(sql);
+ }
//瀹℃牳鎻愪氦
if (oBill.CheckBill(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo) == true)
{
+ oCN.Commit();
+
objJsonResult.code = "1";
objJsonResult.count = 1;
objJsonResult.Message = "瀹℃牳鎴愬姛";
--
Gitblit v1.9.1