From c7a507c5d77652d5ceb722ff032f68514d369deb Mon Sep 17 00:00:00 2001 From: yusijie <ysj@hz-kingdee.com> Date: 星期二, 24 九月 2024 10:02:17 +0800 Subject: [PATCH] 收料通知单同步双计量单位;打印模板设置;json版本 --- WebAPI/Controllers/WebAPIController.cs | 81 ++++++++++++++++++++++++++++++++++++++++ 1 files changed, 81 insertions(+), 0 deletions(-) diff --git a/WebAPI/Controllers/WebAPIController.cs b/WebAPI/Controllers/WebAPIController.cs index 48f1ae6..a578e16 100644 --- a/WebAPI/Controllers/WebAPIController.cs +++ b/WebAPI/Controllers/WebAPIController.cs @@ -468,6 +468,87 @@ } } + /// <summary> + /// 璁剧疆榛樿鎵撳嵃妯℃澘 + /// </summary> + /// <returns></returns> + [Route("Open_PrintTem/DefaultOpenTmp")] + [HttpGet] + public object DefaultOpenTmp(string HNumber, string HName) + { + ClsCN oCn = new ClsCN(); + try + { + oCn.BeginTran(); + //鍏堟妸姝ゆā鍧椾笅鐨勬ā鏉块粯璁ゆā鏉挎爣璁伴兘鍏抽棴 + oCn.RunProc("update SRM_OpenTmp set HStdFlag = 0 where HNumber='" + HNumber + "'", ref DBUtility.ClsPub.sExeReturnInfo); + //鏇存柊褰撳墠妯℃澘涓洪粯璁ゆā鏉� + oCn.RunProc("update SRM_OpenTmp set HStdFlag = 1 where HNumber='" + HNumber + "' and HName='" + HName + "'", ref DBUtility.ClsPub.sExeReturnInfo); + oCn.Commit(); + objjson.code = "0"; + objjson.count = 1; + objjson.Message = "璁剧疆鎴愬姛!"; + objjson.data = null; + return objjson; + } + catch (Exception e) + { + oCn.RollBack(); + objjson.code = "0"; + objjson.count = 0; + objjson.Message = "璁剧疆澶辫触" + e.ToString(); + objjson.data = null; + return objjson; + } + } + + #region [鑾峰彇榛樿鎵撳嵃妯℃澘] + /// <summary> + /// 鑾峰彇鎵撳嵃妯℃澘鍒楄〃 + /// </summary> + /// <returns></returns> + [Route("Open_PrintTem/GetDefaultOpenTmp_Json")] + [HttpGet] + public object GetDefaultOpenTmp_Json(string HNumber) + { + sWhere = " Where 榛樿鏍囪=1 "; + //sWhere = " Where HStopFlag=0 and HEndFlag=1 and HUSEORGID = " + DBUtility.ClsPub.HORGANIZATIONSID.ToString(); + if (HNumber != "") + { + sWhere = sWhere + " and ( HNumber = '" + HNumber + "') "; + } + ClsCN oCn = new ClsCN(); + try + { + ds = oCn.RunProcReturn("select * from h_v_IF_OpenTmpList " + sWhere, "h_v_IF_OpenTmpList"); + if (ds == null || ds.Tables[0].Rows.Count <= 0) + { + objjson.code = "0"; + objjson.count = 0; + objjson.Message = "鑾峰彇澶辫触,娌℃湁璁剧疆榛樿妯℃澘" + DBUtility.ClsPub.sErrInfo; + objjson.data = null; + return objjson; + } + else + { + objjson.code = "0"; + objjson.count = 1; + objjson.Message = "鑾峰彇鎴愬姛!"; + objjson.data = ds.Tables[0]; + return objjson; + } + } + catch (Exception ex) + { + objjson.code = "0"; + objjson.count = 0; + objjson.Message = "寮傚父" + ex.ToString(); + objjson.data = null; + return objjson; + } + } + #endregion + #region 鍩虹璧勬枡 /// <summary> /// 鑾峰彇浠撳簱鍒楄〃 -- Gitblit v1.9.1