From 1bfc8f9c7baad9be7fdb92742cf796f9fdb50df3 Mon Sep 17 00:00:00 2001 From: username@email.com <yzy2002yzy@163.com> Date: 星期三, 22 九月 2021 09:38:37 +0800 Subject: [PATCH] Merge branch 'master' of http://47.108.235.38:8080/r/chuanyin-group-project --- CY_ECommercePlatform/CY.SQLDAL/EC/EC_OrderBasicDAL.cs | 16 ++++++++++++++++ 1 files changed, 16 insertions(+), 0 deletions(-) diff --git a/CY_ECommercePlatform/CY.SQLDAL/EC/EC_OrderBasicDAL.cs b/CY_ECommercePlatform/CY.SQLDAL/EC/EC_OrderBasicDAL.cs index 38a6be8..be83822 100644 --- a/CY_ECommercePlatform/CY.SQLDAL/EC/EC_OrderBasicDAL.cs +++ b/CY_ECommercePlatform/CY.SQLDAL/EC/EC_OrderBasicDAL.cs @@ -469,6 +469,7 @@ //鎵ц鍒嗛〉瀛樺偍 using (IDataReader reader = _dataBase.QueryDataReader("sp_EC_OrderBasic_Financial_Search", CommandType.StoredProcedure, sqlParms.ToArray())) { + result = _dataBase.ReadDataToModel<EC_OrderBasic>(reader); } if (result != null && result.Count > 0) @@ -535,6 +536,8 @@ new SqlParameter("@Kehuqianshou",DBNull.Value){SqlDbType=SqlDbType.Int}, new SqlParameter("@KaipiaoshenqingId",DBNull.Value){SqlDbType=SqlDbType.UniqueIdentifier}, new SqlParameter("@buyerId",DBNull.Value){SqlDbType=SqlDbType.UniqueIdentifier}, + new SqlParameter("@DocumentName",DBNull.Value){SqlDbType=SqlDbType.VarChar,Size=50}, + }; /* @@ -1152,6 +1155,19 @@ return null == result || result.Count < 1 ? null : result[0]; } + + /// <summary> + /// 鏍规嵁瀹㈡埛ID鍜岃鍗曟敮浠樼姸鎬佽幏鍙栬鍗曞垪琛� + /// </summary> + /// <param name="BuyerId">鍗栧ID</param> + /// <returns></returns> + public IList<EC_OrderBasic> GetOrderById(Guid BuyerId, int PayState) + { + IList<EC_OrderBasic> result = new List<EC_OrderBasic>(); + + result = _dataBase.SelectModel<EC_OrderBasic>(" * ", "EC_OrderBasic ", string.Format(" BuyerId = '{0}' and PayState!={1}", BuyerId,PayState)); + return result; + } /// <summary> /// 鍙楃悊璁㈠崟 /// </summary> -- Gitblit v1.9.1