~yxj/MES-WEB-API.git

			@@ -1,4 +1,5 @@
			ï»¿using Newtonsoft.Json;
			ï»¿using DBUtility;
			using Newtonsoft.Json;
			using Newtonsoft.Json.Linq;
			using System;
			using System.Collections.Generic;
			@@ -14,6 +15,9 @@
			{
			public class Gy_StaffController : ApiController
			{
			//è·åç³»ç»åæ°
			Pub_Class.ClsXt_SystemParameter oSystemParameter = new Pub_Class.ClsXt_SystemParameter();

			private json objJsonResult = new json();
			SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
			DataSet ds;
			@@ -391,5 +395,173 @@
			}
			}
			#endregion

			#region [åæ¥åºç¡èµæ]
			[Route("Gy_Staff/Gy_StaffViewApi")]
			[HttpGet]
			public json Gy_StaffViewApi(string Number, string Type)
			{
			string sql = string.Empty;
			string sReturn = "";
			if (oSystemParameter.ShowBill(ref sReturn) == true)
			{
			//ç³»ç»åæ°æ¯å¦ä¸ºç§æäºæ¨¡å¼,Nä¸ºå¬æäºæ¨¡å¼ï¼Yä¸ºç§æäºæ¨¡å¼
			if (oSystemParameter.omodel.WMS_CloudMode == "Y")
			{
			#region [ç§æäºæ¨¡å¼ï¼ç´æ¥è°ç¨æ°æ®åºåå¨è¿ç¨æ´æ°]
			try
			{
			oCN.BeginTran();
			SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
			DataSet DS = oCn.RunProcReturn("exec h_p_WMS_ERPBasicInfoToLocal '" + Number + "','" + Type + "'", "h_p_WMS_ERPBasicInfoToLocal");
			if (DS == null)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "åºç¡èµæåæ¥å¤±è´¥";
			objJsonResult.data = null;
			return objJsonResult;
			}
			else
			{
			if (DBUtility.ClsPub.isStrNull(DS.Tables[0].Rows[0]["HBack"]) == "2")
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "ERPä¸ä¸åå¨è¯¥ä»£ç ";
			objJsonResult.data = null;
			return objJsonResult;
			}
			else
			{
			objJsonResult.code = "1";
			objJsonResult.count = 1;
			objJsonResult.Message = "åºç¡èµæåæ¥æå";
			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
			}
			else
			{
			#region [å¬æäºæ¨¡å¼ï¼è°ç¨WEBAPIçæ¹å¼è¿è¡æ´æ°]
			var json = new
			{
			CreateOrgId = 0,
			Number = Number,
			Id = ""
			};
			#region [éè¶é¨å]
			//ç»å½éè¶
			var loginRet = InvokeHelper.Login();
			var isSuccess = JObject.Parse(loginRet)["LoginResultType"].Value<int>();
			//å¤ææ¯å¦ç»å½æå
			if (isSuccess < 0)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = loginRet;
			objJsonResult.data = null;
			return objJsonResult;
			}
			//æ¥ç è·åæ°æ®
			var _result = InvokeHelper.View("BD_Empinfo", JsonConvert.SerializeObject(json));
			var _saveObj = JObject.Parse(_result);
			//å¤ææ°æ®æ¯å¦è·åæå
			if (_saveObj["Result"]["ResponseStatus"]["IsSuccess"].ToString().ToUpper() != "TRUE")
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "éè¶åå·¥åæ¥å¤±è´¥jsonRootï¼" + _result;
			objJsonResult.data = null;
			return objJsonResult;
			}

			#endregion
			//è·åæ°æ®
			DataSet Ds;
			Ds = oCN.RunProcReturn("select * from Gy_Staff where HNumber = '" + Number + "'", "Gy_Staff");
			if (Ds.Tables[0].Rows.Count != 0 && ClsPub.isLong(Ds.Tables[0].Rows[0]["HItemID"].ToString()) != 0)
			{

			}

			#region [è¡¨æ°æ®èµå¼]
			var jsonData = new
			{
			HItemID = _saveObj["Result"]["Result"]["Id"],
			HNumber = _saveObj["Result"]["Result"]["Number"],
			HName = _saveObj["Result"]["Result"]["Name"][0]["Value"],
			HShortNumber = _saveObj["Result"]["Result"]["Number"],
			HParentID = 0,
			HLevel = 1,
			HEndFlag = 1,
			HStopflag = _saveObj["Result"]["Result"]["ForbidStatus"].ToString() == "A" ? 0 : 1,
			HRemark = "CLD-ERPå¯¼å¥",
			HUseFlag = "å·²ä½¿ç¨",
			HCREATEORGID = _saveObj["Result"]["Result"]["CreateOrgId_Id"],
			HUSEORGID = _saveObj["Result"]["Result"]["UseOrgId_Id"],
			HPERSONID = _saveObj["Result"]["Result"]["PersonId_Id"],
			HPOSTID = _saveObj["Result"]["Result"]["FPostId_Id"],
			HFIRSTCARDID = _saveObj["Result"]["Result"]["FirstCardID_Id"],
			HDeptID = _saveObj["Result"]["Result"]["PostEntity"][0]["Post"]["FDept_Id"],
			HSTAFFNUMBER = _saveObj["Result"]["Result"]["FStaffNumber"]
			};
			#endregion
			// å é¤ä¸»è¡¨å¯¹åºæ°æ®
			sql = $"delete from Gy_Staff where HItemID = " + jsonData.HItemID + " and HNumber = '" + Number + "'";
			oCN.RunProc(sql);

			sql = "set identity_insert Gy_Staff on";
			oCN.RunProc(sql);

			//æå¥è¡¨
			sql = $@"
			insert into Gy_Staff
			(HItemID,HNumber,HName,HShortNumber,HParentID,HLevel
			,HEndFlag,HStopflag,HRemark,HUseFlag,HCREATEORGID,HUSEORGID
			,HPERSONID,HPOSTID,HFIRSTCARDID,HDeptID,HSTAFFNUMBER
			)
			values
			({jsonData.HItemID},'{jsonData.HNumber}','{jsonData.HName}',
			'{jsonData.HShortNumber}',{jsonData.HParentID},{jsonData.HLevel},{jsonData.HEndFlag},{jsonData.HStopflag},'{jsonData.HRemark}','{jsonData.HUseFlag}',{jsonData.HCREATEORGID},{jsonData.HUSEORGID},
			{jsonData.HPERSONID},{jsonData.HPOSTID},{jsonData.HFIRSTCARDID},{jsonData.HDeptID},'{jsonData.HSTAFFNUMBER}')";

			oCN.RunProc(sql);

			sql = "set identity_insert Gy_Staff off";
			oCN.RunProc(sql);

			objJsonResult.code = "1";
			objJsonResult.count = 1;
			objJsonResult.Message = "åå·¥åæ¥æåï¼";
			objJsonResult.data = null;
			return objJsonResult;

			#endregion
			}
			}
			else
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "åºç¡èµæè¯»åå¤±è´¥ï¼";
			objJsonResult.data = null;
			return objJsonResult;
			}
			}
			#endregion

			}
			}