~yxj/MES-WEB-API.git

			@@ -1,4 +1,5 @@
			using Newtonsoft.Json.Linq;
			using Newtonsoft.Json;
			using Newtonsoft.Json.Linq;
			using Pub_Class;
			using System;
			using System.Collections;
			@@ -11,6 +12,8 @@
			{
			public class Gy_SupplierController : ApiController
			{
			//获取系统参数
			Pub_Class.ClsXt_SystemParameter oSystemParameter = new Pub_Class.ClsXt_SystemParameter();
			public DBUtility.ClsPub.Enum_BillStatus BillStatus;

			private json objJsonResult = new json();
			@@ -25,36 +28,45 @@
			/// </summary>
			[Route("Gy_Supplier/list")]
			[HttpGet]
			public object list(string sWhere)
			public object list(string sWhere,string user,string Organization)
			{
			try
			{
			if (sWhere == null \|\| sWhere.Equals(""))
			{
			ds = oCN.RunProcReturn("select * from h_v_Gy_SupplierList " + sWhere, "h_v_Gy_SupplierList");
			}
			else
			{
			string sql1 = "select * from h_v_Gy_SupplierList where 1 = 1 ";
			string sql = sql1 + sWhere;
			ds = oCN.RunProcReturn(sql, "h_v_Gy_SupplierList");
			}
			if (ds == null \|\| ds.Tables[0].Rows.Count == 0)
			List<object> columnNameList = new List<object>();
			//编辑权限
			if (!DBUtility.ClsPub.Security_Log_second("Gy_Supplier", 1, false, user))
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "false！";
			objJsonResult.Message = "无查看权限！";
			objJsonResult.data = null;
			return objJsonResult;
			}
			string sql1 = string.Format(@"select * from h_v_Gy_SupplierList where 组织名称='" + Organization + "'");
			if (sWhere == null \|\| sWhere.Equals(""))
			{
			ds = oCN.RunProcReturn(sql1 + sWhere + " order by 供应商代码", "h_v_Gy_SupplierList");
			}
			else
			{
			objJsonResult.code = "1";
			objJsonResult.count = 1;
			objJsonResult.Message = "Sucess！";
			objJsonResult.data = ds.Tables[0];
			return objJsonResult;
			string sql = sql1 + sWhere + " order by 供应商代码 ";
			ds = oCN.RunProcReturn(sql, "h_v_Gy_SupplierList");
			}

			//添加列名
			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));//获取到DataColumn列对象的列名
			}

			objJsonResult.code = "1";
			objJsonResult.count = 1;
			objJsonResult.Message = "Sucess！";
			objJsonResult.data = ds.Tables[0];
			objJsonResult.list = columnNameList;
			return objJsonResult;
			}
			catch (Exception e)
			{
			@@ -109,7 +121,16 @@
			{
			try
			{
			ds = oCN.RunProcReturn("select * from Gy_Supplier where HItemID=" + HInterID, "Gy_Supplier");
			string sql = string.Format(@"select s.HItemID,s.HNumber 编码,s.HName 名称,s.HHelpCode 助记码,s.HShortName 简称,s.HAddress 地址,s.HLinkMan 联系人,s.HLinkPhone 联系电话
			,s.HMobilePhone 手机,s.HFax 传真,s.HPostalCode 邮编,s.HEmail 电子邮件,s.HCorMan 法人代表,s.HBank 开户银行,s.HBankAccount 银行账号,
			s.HTaxNum 税务登记号,s.HEnglishName 英文名称,s.HEngLishAddress 英文地址,s.HCountry 国家,s.HStopflag 禁用标志
			,s.HRemark 备注,s.HAreaID 地区ID,a.HName 地区名称,s.HTaxRate 增值税率,s.HCurID 默认货币ID,r.HName 默认货币,
			s.HSSID 结算方式ID,e.HName 结算方式 from Gy_Supplier s
			left join Gy_AreaSet a on s.HAreaID=a.HItemID
			left join Gy_Currency r on s.HCurID=r.HItemID
			left join Gy_SettleStyle e on s.HSSID=e.HItemID
			where s.HItemID='" + HInterID + "'");
			ds = oCN.RunProcReturn(sql, "Gy_Supplier");

			objJsonResult.code = "1";
			objJsonResult.count = 1;
			@@ -151,13 +172,14 @@

			List<Supplier> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Supplier>>(msg1);

			long HItemID = list[0].HItemID;
			long HItemID = list[0].HInterID;
			string HNumber = list[0].HNumber;
			string HShortNumber = list[0].HShortNumber;
			string HName = list[0].HName;
			long HParentID = list[0].HParentID;
			long HLevel = list[0].HLevel;
			string HEndFlag = list[0].HEnfFlag;
			string HStopflag = list[0].HStopflag;
			string HHelpCode = list[0].HHelpCode;
			string HShortName = list[0].HShortName;
			string HAddress = list[0].HAddress;
			@@ -208,7 +230,7 @@
			",HTaxNum,HTaxRate,HCountry,HCorMan,HEnglishName" +
			",HEnglishAddress,HCurID,HSSID,HAreaID) " +
			" values('" + HNumber + "','" + HName + "','" + HHelpCode + "','" + HShortNumber + "','" + HParentID + "'" +
			"," + HLevel + ",'0','0','" + HRemark + "'" +
			"," + HLevel + ",0,'" + HStopflag + "','" + HRemark + "'" +
			",'" + HShortName + "','" + HAddress + "','" + HLinkMan + "','" + HLinkPhone + "','" + HMobilePhone + "'" +
			",'" + HFax + "','" + HPostalCode + "','" + HEmail + "','" + HBank + "','" + HBankAccount + "'" +
			",'" + HTaxNum + "','" + HTaxRate + "','" + HCountry + "','" + HCorMan + "','" + HEnglishName + "'" +
			@@ -234,6 +256,58 @@
			}
			}

			[Route("Gy_Supplier/SaveGy_SupplierListApi")]
			[HttpPost]
			public object SaveGy_SupplierListApi([FromBody] JObject msg)
			{
			try
			{
			var _value = msg["model"].ToString();
			SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
			//反序列化
			_value = "[" + _value.ToString() + "]";
			List<Supplier> lsmain = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Supplier>>(_value);
			string sql = string.Empty;
			//保存
			oCN.BeginTran();
			sql = $"delete Gy_Supplier where HItemID = {lsmain[0].HItemID}";
			oCN.RunProc(sql);
			sql = "set identity_insert Gy_Supplier on";
			oCN.RunProc(sql);
			oCN.RunProc("Insert Into Gy_Supplier " +
			"(HItemID,HNumber,HName,HHelpCode,HShortNumber,HParentID" +
			",HLevel,HEndFlag,HStopflag,HRemark" +
			",HShortName,HAddress,HLinkMan,HLinkPhone,HMobilePhone" +
			",HFax,HPostalCode,HEmail,HBank,HBankAccount" +
			",HTaxNum,HTaxRate,HCountry,HCorMan,HEnglishName" +
			",HEnglishAddress,HCurID,HSSID,HAreaID) " +
			" values('" + lsmain[0].HItemID + "','" + lsmain[0].HNumber + "','" + lsmain[0].HName + "','" + lsmain[0].HHelpCode + "','" + lsmain[0].HShortNumber + "','" + lsmain[0].HParentID + "'" +
			"," + lsmain[0].HLevel + ",0,'" + lsmain[0].HStopflag + "','" + lsmain[0].HRemark + "'" +
			",'" + lsmain[0].HShortName + "','" + lsmain[0].HAddress + "','" + lsmain[0].HLinkMan + "','" + lsmain[0].HLinkPhone + "','" + lsmain[0].HMobilePhone + "'" +
			",'" + lsmain[0].HFax + "','" + lsmain[0].HPostalCode + "','" + lsmain[0].HEmail + "','" + lsmain[0].HBank + "','" + lsmain[0].HBankAccount + "'" +
			",'" + lsmain[0].HTaxNum + "','" + lsmain[0].HTaxRate + "','" + lsmain[0].HCountry + "','" + lsmain[0].HCorMan + "','" + lsmain[0].HEnglishName + "'" +
			",'" + lsmain[0].HEnglishAddress + "'," + lsmain[0].HCurID + "," + lsmain[0].HSSID + "," + lsmain[0].HAreaID +
			") ");
			//修改上级为非末级代码
			sql = "set identity_insert Gy_Supplier off";
			oCN.RunProc(sql);
			oCN.Commit();

			objJsonResult.code = "1";
			objJsonResult.count = 1;
			objJsonResult.Message = "保存成功！";
			objJsonResult.data = 1;
			return objJsonResult;
			}
			catch (Exception e)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "保存失败！" + e.ToString();
			objJsonResult.data = 1;
			return objJsonResult;
			}
			}

			/// <summary>
			/// 修改单据-保存按钮
			@@ -253,21 +327,22 @@
			var _value = oMain["oMain"].ToString();
			string msg1 = _value.ToString();
			string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries);
			string msg2 = sArray[0].ToString();
			string msg3 = sArray[1].ToString();
			string msg4 = sArray[2].ToString();
			string msg5 = sArray[3].ToString();
			string msg2 = sArray[0].ToString(); //表头数据
			string msg3 = sArray[1].ToString(); //列表主ID
			string msg4 = sArray[2].ToString(); //登录人员
			string msg5 = sArray[3].ToString(); //权限模块代码
			//反序列化
			msg2 = "[" + msg2.ToString() + "]";
			List<Supplier> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Supplier>>(msg2);

			long HItemID = list[0].HItemID;
			long HItemID = list[0].HInterID;
			string HNumber = list[0].HNumber;
			string HShortNumber = list[0].HShortNumber;
			string HName = list[0].HName;
			long HParentID = list[0].HParentID;
			long HLevel = list[0].HLevel;
			string HEndFlag = list[0].HEnfFlag;
			string HStopflag = list[0].HStopflag;
			string HHelpCode = list[0].HHelpCode;
			string HShortName = list[0].HShortName;
			string HAddress = list[0].HAddress;
			@@ -297,11 +372,11 @@


			//判断权限
			if (!ClsPub.Security_Log(msg5, 1, true, msg4))
			if (!ClsPub.Security_Log(msg5, 1, false, msg4))
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "没有找到该功能模块！";
			objJsonResult.Message = "无保存权限！";
			objJsonResult.data = null;
			return objJsonResult;
			}
			@@ -316,25 +391,39 @@
			return objJsonResult;
			}

			if (oDept.HavSameNumber(HItemID, HNumber))
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "代码重复！";
			objJsonResult.data = null;
			return objJsonResult;
			}


			//若MAINDI重复则重新获取
			oCN.BeginTran();
			//主表
			oCN.RunProc("Update Gy_Supplier set " +
			" HNumber='" + HNumber + "'" +
			",HName='" + HName + "'" +
			",HShortNumber='" + HShortNumber + "'" +
			",HParentID=" + HParentID +
			",HRemark= '" + HRemark + "' Where HItemID=" + HItemID, ref DBUtility.ClsPub.sExeReturnInfo);
			" HNumber='" + HNumber + "'" +
			",HName='" + HName + "'" +
			",HShortNumber='" + HShortNumber + "'" +
			",HParentID=" + HParentID.ToString() +
			",HLevel=" + HLevel.ToString() +
			",HStopflag ='" + HStopflag + "'" +
			",HRemark= '" + HRemark + "'" +
			",HHelpCode='" + HHelpCode + "'" +
			",HShortName='" + HShortName + "'" +
			",HAddress='" + HAddress + "'" +
			",HLinkMan='" + HLinkMan + "'" +
			",HLinkPhone='" + HLinkPhone + "'" +
			",HMobilePhone='" + HMobilePhone + "'" +
			",HFax='" + HFax + "'" +
			",HPostalCode='" + HPostalCode + "'" +
			",HEmail='" + HEmail + "'" +
			",HBank='" + HBank + "'" +
			",HBankAccount='" + HBankAccount + "'" +
			",HTaxNum='" + HTaxNum + "'" +
			",HTaxRate=" + HTaxRate.ToString() +
			",HCountry='" + HCountry + "'" +
			",HCorMan='" +HCorMan + "'" +
			",HEnglishName='" + HEnglishName + "'" +
			",HEnglishAddress='" + HEnglishAddress + "'" +
			",HCurID=" + HCurID.ToString() +
			",HSSID=" + HSSID.ToString() +
			",HAreaID=" + HAreaID.ToString() + "Where HItemID=" + HItemID, ref DBUtility.ClsPub.sExeReturnInfo);


			//修改子项目代码
			//oCN.RunProc("exec h_p_Gy_UpdateNumber Gy_Department,'" + HNumber + ".','" + this.HOldNumber + ".'", ref DBUtility.ClsPub.sExeReturnInfo);
			//将上级为非末级
			@@ -358,6 +447,250 @@
			}
			}

			//
			/// <summary>
			/// 供应商列表删除
			/// </summary>
			/// <param name="HItemID">删除列的ID</param>
			/// <param name="User">当前登录用户</param>
			/// <param name="ModRightNameDelete"></param>
			/// <returns></returns>
			[Route("Gy_Supplier/Delete_Json")]
			[HttpGet]
			public object Delete_Json(long HItemID, string User, string ModRightNameDelete)
			{
			DAL.ClsGy_Supplier_Ctl oGroup = new DAL.ClsGy_Supplier_Ctl();
			DAL.ClsGy_Supplier_View oGroupHlp = new DAL.ClsGy_Supplier_View();
			try
			{
			if (!DBUtility.ClsPub.Security_Log(ModRightNameDelete, 1, false, User))
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "没有删除权限";
			objJsonResult.data = null;
			return objJsonResult;
			}
			if (oGroupHlp.GetInfoByID(HItemID))
			{
			if (oGroup.HavChildCodes(HItemID))
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "此项目存在子项目,不能删除！";
			objJsonResult.data = null;
			return objJsonResult;
			}
			//删除前判断是否已使用 20141020
			if (oGroupHlp.omodel.HUseFlag != "未使用")
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "此项目已使用或者未检测，不能删除！请重新检测再删除！";
			objJsonResult.data = null;
			return objJsonResult;
			}
			//
			if (oGroup.DeleteByID(HItemID))
			{
			//写入日志
			ClsPub.Add_Log("", "删除项目，代码：" + oGroupHlp.omodel.HNumber + ",名称：" + oGroupHlp.omodel.HName, ClsPub.CurUserName);
			//更新上级为末级
			objJsonResult.code = "1";
			objJsonResult.count = 1;
			objJsonResult.Message = "删除成功";
			objJsonResult.data = null;
			return objJsonResult;
			}
			else
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "删除失败";
			objJsonResult.data = null;
			return objJsonResult;
			}
			}
			//ds = oCN.RunProcReturn("delete from Gy_Department where HItemID = " + HItemID, "Gy_Department");

			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;
			}
			}

			#region [同步基础资料]
			[Route("Gy_Supplier/Gy_SupplierViewApi")]
			[HttpGet]
			public json Gy_SupplierViewApi(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_Supplier", 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_Supplier where HNumber = '" + Number + "'", "Gy_Supplier");
			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"],
			HERPItemID = _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 = "已使用",
			HMakeTime = _saveObj["Result"]["Result"]["CreateDate"],
			HCREATEORGID = _saveObj["Result"]["Result"]["CreateOrgId_Id"],
			HUSEORGID = _saveObj["Result"]["Result"]["UseOrgId_Id"],
			HPAYCONDITION = _saveObj["Result"]["Result"]["SupplierFinance"][0]["PayCondition_Id"]
			};
			#endregion
			// 删除主表对应数据
			sql = $"delete from Gy_Supplier where HItemID = " + jsonData.HItemID + " and HNumber = '" + Number + "'";
			oCN.RunProc(sql);

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

			//插入表
			sql = $@"
			insert into Gy_Supplier
			(HItemID,HERPItemID,HNumber,HName,HShortNumber,HParentID
			,HLevel,HEndFlag,HStopflag,HRemark,HUseFlag,HMakeTime,HCREATEORGID,HUSEORGID
			,HPAYCONDITION
			)
			values
			({jsonData.HItemID},{jsonData.HERPItemID},'{jsonData.HNumber}','{jsonData.HName}',
			'{jsonData.HShortNumber}',{jsonData.HParentID},{jsonData.HLevel},{jsonData.HEndFlag},{jsonData.HStopflag},'{jsonData.HRemark}','{jsonData.HUseFlag}','{jsonData.HMakeTime}',{jsonData.HCREATEORGID},{jsonData.HUSEORGID},{jsonData.HPAYCONDITION})";

			oCN.RunProc(sql);

			sql = "set identity_insert Gy_Supplier 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

			}
			}