From 25f2644f775fa0045fc5ff4885135fbde0f8be51 Mon Sep 17 00:00:00 2001 From: yusijie <ysj@hz-kingdee.com> Date: 星期五, 04 十月 2024 12:52:28 +0800 Subject: [PATCH] 添康科技-出站汇报单去除生产资源必录 --- WebAPI/Controllers/WebAPIController.cs | 62 +++++++++++++++++++++++++++++++ 1 files changed, 62 insertions(+), 0 deletions(-) diff --git a/WebAPI/Controllers/WebAPIController.cs b/WebAPI/Controllers/WebAPIController.cs index 6af28ed..828fb1d 100644 --- a/WebAPI/Controllers/WebAPIController.cs +++ b/WebAPI/Controllers/WebAPIController.cs @@ -171,6 +171,68 @@ } } + [Route("Web/GetMAXNum_ProcExchange")] + [HttpGet] + public object GetMAXNum_ProcExchange(string HBillType) + { + try + { + string HBillNo = ""; + string sErrMsg = ""; + Int64 HInterID = 0;//鏄剧ず鐨勫瓧娈� + HInterID = DBUtility.ClsPub.CreateBillID_Prod(HBillType, ref sErrMsg); + HBillNo = DBUtility.ClsPub.CreateBillCode_Prod(HBillType, ref sErrMsg, true); + + DataSet ds; + SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); + ds = oCN.RunProcReturn("exec h_p_IF_CheckBillIDExists_WMS " + HInterID + ",'" + HBillNo + "'", "h_p_IF_CheckBillIDExists_WMS"); + if (ds == null || ds.Tables[0].Rows.Count == 0) + { + sErrMsg = "瀛樺湪閲嶅鍗曟嵁鍐呯爜鎴栧崟鎹彿鐨勫崟鎹紝涓嶅厑璁告柊澧烇紝璇烽��鍑哄悗閲嶆柊鐧诲綍锛�"; + objjson.code = "0"; + objjson.count = 0; + objjson.Message = sErrMsg; + objjson.data = null; + return objjson; + } + else if (DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0][0]) == "1") + { + sErrMsg = "瀛樺湪閲嶅鍗曟嵁鍐呯爜鎴栧崟鎹彿鐨勫崟鎹紝涓嶅厑璁告柊澧烇紝璇烽��鍑哄悗閲嶆柊鐧诲綍锛�"; + objjson.code = "0"; + objjson.count = 0; + objjson.Message = sErrMsg; + objjson.data = null; + return objjson; + } + else + { + //----------鍒涘缓铏氳〃------------------------ + DataTable dt_Main = new DataTable("Json"); + dt_Main.Columns.Add("HBillNo", typeof(string)); + dt_Main.Columns.Add("HInterID", typeof(Int64)); + //---------鍒涘缓鏂拌------------------------ + DataRow dr_main = dt_Main.NewRow();//鍒涘缓鏂拌 + dt_Main.Rows.Add(dr_main);//灏嗘柊琛屽姞鍏ュ埌琛ㄤ腑 + dr_main["HBillNo"] = DBUtility.ClsPub.isStrNull(HBillNo); + dr_main["HInterID"] = DBUtility.ClsPub.isLong(HInterID); + //杩斿洖鏁版嵁 + objjson.code = "0"; + objjson.count = 1; + objjson.Message = "鑾峰彇鎴愬姛"; + objjson.data = dt_Main; + return objjson; + } + } + catch (Exception e) + { + objjson.code = "0"; + objjson.count = 0; + objjson.Message = "鑾峰彇澶辫触" + e.ToString(); + objjson.data = null; + return objjson; + } + } + /// <summary> /// 鑷姩鑾峰彇鍩虹璧勬枡 娴佹按鍙� 灏辨槸浠g爜 /// </summary> -- Gitblit v1.9.1