From 9af997830913bad185ed5ba86f48db8f644aed97 Mon Sep 17 00:00:00 2001
From: CB2-20200827ONU\Administrator <liaoxujun@qq.com>
Date: 星期三, 22 九月 2021 09:41:23 +0800
Subject: [PATCH] no message
---
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