From 680b605296b299a426438579b8a271882521dc8a Mon Sep 17 00:00:00 2001 From: yangle <admin@YINMOU> Date: 星期一, 22 五月 2023 11:26:35 +0800 Subject: [PATCH] 1 --- WebAPI/Controllers/CJGL/Sc_ProcessExchangeBillController.cs | 87 +++++++++++++++++++++++++++++++++++++++++++ 1 files changed, 87 insertions(+), 0 deletions(-) diff --git a/WebAPI/Controllers/CJGL/Sc_ProcessExchangeBillController.cs b/WebAPI/Controllers/CJGL/Sc_ProcessExchangeBillController.cs index 7be7f46..69945cd 100644 --- a/WebAPI/Controllers/CJGL/Sc_ProcessExchangeBillController.cs +++ b/WebAPI/Controllers/CJGL/Sc_ProcessExchangeBillController.cs @@ -1230,5 +1230,92 @@ } #endregion + + + #region 鍗曟嵁鍙樻洿 椤甸潰鍒濆鍖� + [Route("Sc_ProcessExchangeBill/GetProcessExchangeBillMain_Change_init")] + [HttpGet] + public object GetProcessExchangeBillMain_Change_init(string HInterID) + { + try + { + if (string.IsNullOrEmpty(HInterID)) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "Exception锛丠InterID涓嶈兘涓虹┖"; + objJsonResult.data = null; + return objJsonResult; + } + SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); + + ds = oCN.RunProcReturn("select * from h_v_Sc_ProcessExchangeBillQuery where hmainid = " + HInterID + " ", "h_v_Sc_ProcessExchangeBillQuery"); + + if (ds==null||ds.Tables[0].Rows.Count == 0) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "Exception锛佷笉瀛樺湪宸ュ簭娴佽浆鍗�"; + objJsonResult.data = null; + return objJsonResult; + } + else + { + objJsonResult.code = "1"; + objJsonResult.count = 1; + objJsonResult.Message = "Sucess锛�"; + objJsonResult.data = ds.Tables[0]; + return objJsonResult; + } + } + catch (Exception e) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "Exception锛�" + e.ToString(); + objJsonResult.data = null; + return objJsonResult; + } + } + #endregion + + #region 鍗曟嵁鍙樻洿 淇濆瓨 + [Route("Sc_ProcessExchangeBill/GetProcessExchangeBillMain_Change_save")] + [HttpGet] + public object GetProcessExchangeBillMain_Change_save(string HInterID,string HMaterModel2) + { + try + { + if (string.IsNullOrEmpty(HInterID)) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "Exception锛丠InterID涓嶈兘涓虹┖"; + objJsonResult.data = null; + return objJsonResult; + } + SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); + + oCN.BeginTran(); + oCN.RunProc("update Sc_ProcessExchangeBillMain set HMaterModel2 = '" + HMaterModel2 + "' where HInterID = " + HInterID + ""); + oCN.Commit(); + + objJsonResult.code = "1"; + objJsonResult.count = 1; + objJsonResult.Message = "Sucess锛�"; + objJsonResult.data = null; + return objJsonResult; + } + catch (Exception e) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "Exception锛�" + e.ToString(); + objJsonResult.data = null; + return objJsonResult; + } + } + #endregion + } } \ No newline at end of file -- Gitblit v1.9.1