From ef64fca176cd33702a999981c7f91e1b77a1adb3 Mon Sep 17 00:00:00 2001
From: YL <YL@LAPTOP-SE03PLUR>
Date: 星期四, 13 五月 2021 14:50:12 +0800
Subject: [PATCH] 仓库看板后台提交
---
MyWebApi/DLL/DAL/LoadDataDAL.cs | 29 +++++++++++++++++++++++++++++
1 files changed, 29 insertions(+), 0 deletions(-)
diff --git a/MyWebApi/DLL/DAL/LoadDataDAL.cs b/MyWebApi/DLL/DAL/LoadDataDAL.cs
index 9f5f713..8d8a8f2 100644
--- a/MyWebApi/DLL/DAL/LoadDataDAL.cs
+++ b/MyWebApi/DLL/DAL/LoadDataDAL.cs
@@ -52,5 +52,34 @@
return new List<LineWork>();
}
#endregion
+
+ #region[浠撳簱鐪嬫澘鐪嬫澘鐮佽〃鏁版嵁]
+ public static DataTable HouseTopData(string houseCode)
+ {
+ //鎵ц瀛樺偍杩囩▼@lineCodeList
+ // 瀛樺偍杩囩▼鍚嶇О
+ string strProcName = "kb_HouseProduct_Radio";
+ //鍒涘缓鍙傛暟
+ SqlParameter[] parameters = { new SqlParameter("@HouseCode", houseCode) };
+ //parameters[0].Direction = ParameterDirection.Output;
+ DataTable dt = DBHelper.ExecuteProductData(strProcName, parameters);
+ return dt;
+ }
+ #endregion
+
+ #region[浠撳簱鐪嬫澘鐪嬫澘璇︽儏鏁版嵁]
+ public static DataTable HouseDataTable(string houseCode)
+ {
+
+ //鎵ц瀛樺偍杩囩▼@lineCodeList
+ // 瀛樺偍杩囩▼鍚嶇О
+ string strProcName = "kb_HouseProduct_Table";
+ //鍒涘缓鍙傛暟
+ SqlParameter[] parameters = { new SqlParameter("@HouseCode", houseCode) };
+ //parameters[0].Direction = ParameterDirection.Output;
+ DataTable dt = DBHelper.ExecuteProductData(strProcName, parameters);
+ return dt;
+ }
+ #endregion
}
}
\ No newline at end of file
--
Gitblit v1.9.1