From 5b8adef561ef255319cd961b8b13642041ed2a39 Mon Sep 17 00:00:00 2001
From: 王 垚 <1402714037@qq.com>
Date: 星期五, 09 十二月 2022 17:58:58 +0800
Subject: [PATCH] 代码提交
---
zymes/OperationService/zymes_RealessCustomer.cs | 33 +++++++++++++++++++++++----------
1 files changed, 23 insertions(+), 10 deletions(-)
diff --git a/zymes/OperationService/zymes_RealessCustomer.cs b/zymes/OperationService/zymes_RealessCustomer.cs
index b1ffb52..72870d9 100644
--- a/zymes/OperationService/zymes_RealessCustomer.cs
+++ b/zymes/OperationService/zymes_RealessCustomer.cs
@@ -46,34 +46,47 @@
foreach (var billObj in e.DataEntitys)
{
var sql = $"exec zymes_RealessCustomer {billObj["Id"]} ";
- DataTable dt = DBServiceHelper.ExecuteDataSet(Context, sql).Tables[0];
- if (dt.Rows.Count == 0)
+ DataSet ds = DBServiceHelper.ExecuteDataSet(Context,sql);
+ DataTable maindt = ds.Tables[0];//瀹㈡埛淇℃伅
+ DataTable subdt = ds.Tables[1];//瀹㈡埛_浜よ揣鍦扮偣
+ if (maindt.Rows.Count == 0)
{
LogService.Write("瀹㈡埛鍚屾寮傚父锛�" + sql);
continue;
}
- DataRow dr = dt.Rows[0];
- JObject model = new JObject();
- foreach (DataColumn column in dt.Columns)
+ JArray array = new JArray();//鏄庣粏琛�
+ foreach (DataRow dr in subdt.Rows)
{
- model.Add(column.ColumnName, dr[column.ColumnName].ToString());
+ JObject fentrymodel = new JObject();
+ foreach (DataColumn column in subdt.Columns)
+ {
+ fentrymodel.Add(column.ColumnName, dr[column.ColumnName].ToString());
+ }
+ array.Add(fentrymodel);
}
- JObject _jsonRoot = new JObject()
+ JObject model = new JObject();//涓昏〃
+ DataRow maindr = maindt.Rows[0];
+ foreach (DataColumn column in maindt.Columns)
+ {
+ model.Add(column.ColumnName, maindr[column.ColumnName].ToString());
+ }
+ model.Add("HCustLocationEntry", array);
+ JObject jsonRoot = new JObject()
{
["model"] = model
};
- //LogService.Write("瀹㈡埛鍚屾绀轰緥锛�"+JsonConvert.SerializeObject(_jsonRoot));
+ LogService.Write("瀹㈡埛鍚屾绀轰緥" + JsonConvert.SerializeObject(jsonRoot));
string clientUrl = Util.GetConfigKey(AppDomain.CurrentDomain.BaseDirectory + "/Config/kdapi.config", "ClientUrl");//K/3 Cloud 涓氬姟绔欑偣鍦板潃
var client = new RestSharp.RestClient(clientUrl);
var requestPost = new RestRequest("Gy_Customer/SaveGy_CustomerListApi", Method.POST);
- requestPost.AddParameter("application/json", JsonConvert.SerializeObject(_jsonRoot), ParameterType.RequestBody);
+ requestPost.AddParameter("application/json", JsonConvert.SerializeObject(jsonRoot), ParameterType.RequestBody);
IRestResponse responsePost = client.Execute(requestPost);
var contentPost = responsePost.Content;
if (!contentPost.Contains("鎴愬姛"))
{
LogService.Write("瀹㈡埛鍚屾寮傚父,POST鏂瑰紡鑾峰彇缁撴灉," + billObj["Id"] + "," + contentPost);
LogService.Write("瀹㈡埛鍚屾寮傚父,POST," + clientUrl + "Gy_Customer/SaveGy_CustomerListApi");
- LogService.Write("瀹㈡埛鍚屾寮傚父,JsonConvert.SerializeObject(_jsonRoot)," + JsonConvert.SerializeObject(_jsonRoot));
+ LogService.Write("瀹㈡埛鍚屾寮傚父,JsonConvert.SerializeObject(_jsonRoot)," + JsonConvert.SerializeObject(jsonRoot));
}
};
--
Gitblit v1.9.1