From db942dd220a9463732a29334afb497187f5084a4 Mon Sep 17 00:00:00 2001
From: wyb <1qaz@123>
Date: 星期四, 13 五月 2021 18:40:16 +0800
Subject: [PATCH] 地图数据获取方法编写
---
MyWebApi/DLL/DAL/LoadDataDAL.cs | 19 +++++++++++++++++++
MyWebApi/Web.config | 5 ++++-
MyWebApi/Controllers/LoadDataController.cs | 18 ++++++++++++++++++
MyWebApi/DLL/BLL/LoadDataBLL.cs | 6 ++++++
4 files changed, 47 insertions(+), 1 deletions(-)
diff --git a/MyWebApi/Controllers/LoadDataController.cs b/MyWebApi/Controllers/LoadDataController.cs
index 05af2fa..23ee7e9 100644
--- a/MyWebApi/Controllers/LoadDataController.cs
+++ b/MyWebApi/Controllers/LoadDataController.cs
@@ -105,5 +105,23 @@
return response;
}
#endregion
+
+ /// <summary>
+ /// 鍦板浘鐪嬫澘鏁版嵁
+ /// </summary>
+ /// <returns></returns>
+ [Route(template: "MapTableData")]
+ [HttpGet]
+ public HttpResponseMessage MapTableData()
+ {
+
+ List<DataTable> list = new List<DataTable>();
+ list = LoadDataBLL.MyMap();
+ var timeConverter = new IsoDateTimeConverter { DateTimeFormat = "yyyy-MM-dd" };
+ HttpResponseMessage response = Request.CreateResponse();
+ response.StatusCode = HttpStatusCode.OK;
+ response.Content = new StringContent(JsonConvert.SerializeObject(new { code = 200, data = list }), System.Text.Encoding.UTF8);
+ return response;
+ }
}
}
diff --git a/MyWebApi/DLL/BLL/LoadDataBLL.cs b/MyWebApi/DLL/BLL/LoadDataBLL.cs
index a2138ea..df31944 100644
--- a/MyWebApi/DLL/BLL/LoadDataBLL.cs
+++ b/MyWebApi/DLL/BLL/LoadDataBLL.cs
@@ -38,5 +38,11 @@
return LoadDataDAL.HouseDataTable(houseCode);
}
#endregion
+
+ /// <summary>
+ /// 鍦板浘鏁版嵁鐪嬫澘
+ /// </summary>
+ /// <returns></returns>
+ public static List<DataTable> MyMap() { return LoadDataDAL.MyMap(); }
}
}
\ No newline at end of file
diff --git a/MyWebApi/DLL/DAL/LoadDataDAL.cs b/MyWebApi/DLL/DAL/LoadDataDAL.cs
index 8d8a8f2..6d7199a 100644
--- a/MyWebApi/DLL/DAL/LoadDataDAL.cs
+++ b/MyWebApi/DLL/DAL/LoadDataDAL.cs
@@ -81,5 +81,24 @@
return dt;
}
#endregion
+
+ #region 鍦板浘鏁版嵁鐪嬫澘
+ /// <summary>
+ /// 鍦板浘鏁版嵁鐪嬫澘
+ /// </summary>
+ /// <returns></returns>
+ public static List<DataTable> MyMap ()
+ {
+ List<DataTable> list = new List<DataTable>();
+ //鎵ц瀛樺偍杩囩▼h_p_Xs_SeOrderQtySort
+ // 瀛樺偍杩囩▼鍚嶇О
+ string strProcName = "h_p_Xs_SeOrderQtySort";
+ //鍒涘缓鍙傛暟
+ SqlParameter[] parameters = {};
+ list = DBHelper.ExecuteProductDataList(strProcName, parameters);
+
+ return list;
+ }
+ #endregion
}
}
\ No newline at end of file
diff --git a/MyWebApi/Web.config b/MyWebApi/Web.config
index a014aa3..f7d0cff 100644
--- a/MyWebApi/Web.config
+++ b/MyWebApi/Web.config
@@ -5,7 +5,10 @@
-->
<configuration>
<appSettings>
- <add key="DBServer" value="Data Source=LAPTOP-SE03PLUR;Initial Catalog=dsmAIS20201023121341;Integrated Security=True" />
+ <!--鐜嬫案娉㈡湰鍦版暟鎹簱杩炴帴-->
+ <add key="DBServer" value="Data Source=.;Initial Catalog=HX_LMESsys;Persist Security Info=True;User ID=HX_USER; Password=lc@841022;" />
+ <!--鏉ㄩ湶鏈湴鏁版嵁搴撹繛鎺�-->
+ <!--<add key="DBServer" value="Data Source=LAPTOP-SE03PLUR;Initial Catalog=dsmAIS20201023121341;Integrated Security=True" />-->
<!--娴佹按绾跨紪鐮�-->
<add key="LineCode" value="509" />
<!--娴佹按绾跨湅鏉夸粖鏃ュ叏閮ㄦ祦姘寸嚎缂栫爜:浜х嚎1銆佷骇绾�2銆佷骇绾�3銆佷骇绾�4銆佷骇绾�5銆佷骇绾�6-->
--
Gitblit v1.9.1