| | |
| | | #region [同步基础资料] |
| | | [Route("Gy_Supplier/Gy_SupplierViewApi")] |
| | | [HttpGet] |
| | | public json Gy_SupplierViewApi(string Number, string Type) |
| | | public json Gy_SupplierViewApi(string Number, string Type, string HUseOrgID) |
| | | { |
| | | string sql = string.Empty; |
| | | string sReturn = ""; |
| | |
| | | { |
| | | #region [公有云模式,调用WEBAPI的方式进行更新] |
| | | var json = new |
| | | // { |
| | | // CreateOrgId = HUseOrgID, |
| | | // Number = Number, |
| | | // Id = "" |
| | | // }; |
| | | { |
| | | CreateOrgId = 0, |
| | | Number = Number, |
| | | Id = "" |
| | | FormId= "BD_Supplier", |
| | | FieldKeys= "FMASTERID,FNUMBER,FNAME,FFORBIDERID,FCREATEDATE,FCREATEORGID,FUSEORGID,FPAYCONDITION", |
| | | FilterString= $@"FNumber='{Number}' AND FUseOrgID={HUseOrgID}", |
| | | OrderString= "", |
| | | TopRowCount= 0, |
| | | StartRow= 0, |
| | | Limit= 0 |
| | | }; |
| | | #region [金蝶部分] |
| | | //登录金蝶 |
| | |
| | | return objJsonResult; |
| | | } |
| | | //查看 获取数据 |
| | | var _result = InvokeHelper.View("BD_Supplier", JsonConvert.SerializeObject(json)); |
| | | var _saveObj = JObject.Parse(_result); |
| | | var _result = InvokeHelper.Query("BD_Supplier", JsonConvert.SerializeObject(json)); |
| | | var _saveObj = JArray.Parse(_result); |
| | | //判断数据是否获取成功 |
| | | if (_saveObj["Result"]["ResponseStatus"]["IsSuccess"].ToString().ToUpper() != "TRUE") |
| | | // if (_saveObj["Result"]["ResponseStatus"]["IsSuccess"].ToString().ToUpper() != "TRUE") |
| | | // { |
| | | // objJsonResult.code = "0"; |
| | | // objJsonResult.count = 0; |
| | | // objJsonResult.Message = "金蝶供应商同步失败jsonRoot:" + _result; |
| | | // objJsonResult.data = null; |
| | | // return objJsonResult; |
| | | // } |
| | | if (_saveObj.Count == 0) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "金蝶供应商同步失败jsonRoot:" + _result; |
| | | objJsonResult.Message = "金蝶客户同步失败,使用组织对应的供应商代码不存在"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | |
| | | |
| | | #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"] |
| | | // }; |
| | | |
| | | { |
| | | 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"], |
| | | HItemID = _saveObj[0][0], |
| | | HERPItemID = _saveObj[0][0], |
| | | HNumber = _saveObj[0][1], |
| | | HName = _saveObj[0][2], |
| | | HShortNumber = _saveObj[0][1], |
| | | HParentID = 0, |
| | | HLevel = 1, |
| | | HEndFlag = 1, |
| | | HStopflag = _saveObj["Result"]["Result"]["ForbidStatus"].ToString() == "A" ? 0 : 1, |
| | | HStopflag = _saveObj[0][3].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"] |
| | | HMakeTime = _saveObj[0][4], |
| | | HCREATEORGID = _saveObj[0][5], |
| | | HUSEORGID = _saveObj[0][6], |
| | | HPAYCONDITION = _saveObj[0][7] |
| | | }; |
| | | #endregion |
| | | // 删除主表对应数据 |