From 6592e8f84bf7958dd256a33b66e1fa3203296312 Mon Sep 17 00:00:00 2001 From: yusijie <ysj@hz-kingdee.com> Date: 星期四, 25 五月 2023 16:40:52 +0800 Subject: [PATCH] 1 --- WebAPI/Controllers/WebAPIController.cs | 119 +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ 1 files changed, 118 insertions(+), 1 deletions(-) diff --git a/WebAPI/Controllers/WebAPIController.cs b/WebAPI/Controllers/WebAPIController.cs index 3db330f..b6fe672 100644 --- a/WebAPI/Controllers/WebAPIController.cs +++ b/WebAPI/Controllers/WebAPIController.cs @@ -26,6 +26,7 @@ private json objjson = new json(); private json objJsonResult = new json(); SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); + Pub_Class.ClsXt_SystemParameter oSystemParameter = new Pub_Class.ClsXt_SystemParameter(); //public static string sUrl = "http://183.129.128.86:9090/WEBS-WMSTest/WebService1.asmx"; // private POInStockBillServices oclscg_poinstockbillmain = new POInStockBillServices(); /// <summary> @@ -201,7 +202,7 @@ public object GetUser(string UserName, string PassWord, string HOrgName) { try - { + { DataSet ds = null; ClsCN oCnLoc = new ClsCN(); DAL.ClsUser oUser = new DAL.ClsUser(); @@ -239,6 +240,49 @@ objjson.code = "0"; objjson.count = 0; objjson.Message = "鐧诲綍寮傚父锛�" + e.Message; + objjson.data = null; + return objjson; ; + } + } + /// <summary> + /// 鑿滃崟鏍� + /// </summary> + /// <returns></returns> + [Route("Web/MenuBar")] + [HttpGet] + public object MenuBar(string UserName) + { + try + { + //鑾峰彇绯荤粺鍙傛暟 + string Ret = ""; + if (oSystemParameter.ShowBill(ref Ret)) + { + //鍒ゆ柇瀹㈡埛涓洪緳灞辨苯閰� + if (oSystemParameter.omodel.WMS_CampanyName == "榫欏北姹介厤") + { + //鍒ゆ柇鏄惁鏈夋煡璇㈡潈闄� + if (!DBUtility.ClsPub.Security_Log("Xt_MenuBar_Unfold", 1, false, UserName)) + { + objjson.code = "0"; + objjson.count = 0; + objjson.Message = "鏃犲睍寮�鑿滃崟鏍忔潈闄�!"; + objjson.data = null; + return objjson; + } + } + } + objjson.code = "0"; + objjson.count = 1; + objjson.Message = "灞曞紑鎴愬姛锛�"; + objjson.data = 1; + return objjson; + } + catch (Exception e) + { + objjson.code = "0"; + objjson.count = 0; + objjson.Message = "寮傚父锛�" + e.Message; objjson.data = null; return objjson; ; } @@ -384,6 +428,16 @@ try { ds = webserver.GetKf_PonderationBillMain_TempList(HBillType, sWhere); + + List<object> columnNameList = new List<object>(); + //娣诲姞鍒楀悕 + foreach (DataColumn col in ds.Tables[0].Columns) + { + Type dataType = col.DataType; + string ColmString = "{\"ColmCols\":\"" + col.ColumnName + "\",\"ColmType\":\"" + dataType.Name + "\"}"; + columnNameList.Add(JsonConvert.DeserializeObject(ColmString));//鑾峰彇鍒癉ataColumn鍒楀璞$殑鍒楀悕 + } + if (ds == null || ds.Tables[0].Rows.Count <= 0) { @@ -400,6 +454,7 @@ objJsonResult.count = 1; objJsonResult.Message = "鑾峰彇淇℃伅鎴愬姛锛�"; objJsonResult.data = ds.Tables[0]; + objJsonResult.list = columnNameList; return objJsonResult; } } @@ -3984,6 +4039,68 @@ } } + /// <summary> + /// 浜у搧鍏ュ簱缂撳瓨鍒楄〃鍒锋柊淇℃伅 + /// </summary> + /// <returns></returns> + [Route("Web/chanpinruk1")] + [HttpGet] + public object chanpinruk1(string HBillType, string sHMaker, Int64 HOrgID) + { + WebS.WebService1 oWebs = new WebS.WebService1(); + try + { + ds = oWebs.GetKf_PonderationBillMain_TempList_New(HBillType, sHMaker, HOrgID); + + if (ds == null) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.count = 0; + objJsonResult.Message = "娌℃湁杩斿洖浠讳綍璁板綍锛�"; + objJsonResult.data = null; + return objJsonResult; + + } + + List<object> columnNameList = new List<object>(); + //娣诲姞鍒楀悕 + foreach (DataColumn col in ds.Tables[0].Columns) + { + Type dataType = col.DataType; + string ColmString = "{\"ColmCols\":\"" + col.ColumnName + "\",\"ColmType\":\"" + dataType.Name + "\"}"; + columnNameList.Add(JsonConvert.DeserializeObject(ColmString));//鑾峰彇鍒癉ataColumn鍒楀璞$殑鍒楀悕 + } + + if (ds == null || ds.Tables[0].Rows.Count <= 0) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "娌℃湁杩斿洖浠讳綍璁板綍锛�"; + objJsonResult.data = null; + return objJsonResult; + //DBUtility.ClsPub.MessageBeep((int)DBUtility.ClsPub.BeepType.Warning); + } + else + { + objJsonResult.code = "0"; + objJsonResult.count = 1; + objJsonResult.Message = "鑾峰彇淇℃伅鎴愬姛锛�"; + objJsonResult.data = ds.Tables[0]; + objJsonResult.list = columnNameList; + return objJsonResult; + } + } + catch (Exception e) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "娌℃湁杩斿洖浠讳綍璁板綍锛�" + e.ToString(); + objJsonResult.data = null; + return objJsonResult; + } + } + #region PDA鍏朵粬鍏ュ簱鍒楄〃妯″潡 /// <summary> -- Gitblit v1.9.1