From b03ae699c49cfca53d22772f0c2aec5210bc9758 Mon Sep 17 00:00:00 2001
From: username@email.com <yzy2002yzy@163.com>
Date: 星期四, 02 四月 2026 08:50:35 +0800
Subject: [PATCH] 张薇按我这个界面比例画图 生产要求只填1行就够了，其他跟之前的一样 这个地方是增加或者删除不需要的后道
---
CY_ECommercePlatform/CY.SQLDAL/EC/EC_SpecialOrdersDAL.cs | 79 +++++++++++++++++++++++++++++++++++++--
1 files changed, 75 insertions(+), 4 deletions(-)
diff --git a/CY_ECommercePlatform/CY.SQLDAL/EC/EC_SpecialOrdersDAL.cs b/CY_ECommercePlatform/CY.SQLDAL/EC/EC_SpecialOrdersDAL.cs
index f601522..19902ee 100644
--- a/CY_ECommercePlatform/CY.SQLDAL/EC/EC_SpecialOrdersDAL.cs
+++ b/CY_ECommercePlatform/CY.SQLDAL/EC/EC_SpecialOrdersDAL.cs
@@ -239,7 +239,7 @@
/// <param name="m_OA_OrderWorkListRelation"></param>
/// <param name="m_EC_SpecialForumsList"></param>
/// <returns></returns>
- public bool AddSpecialForums(EC_OrderOperate m_EC_OrderOperate, EC_SpecialOrders m_EC_SpecialOrders, OA_OrderWorkListRelation m_OA_OrderWorkListRelation, List<EC_SpecialForums> m_EC_SpecialForumsList, List<OA_Inventory> m_OA_InventoryList, List<OA_OutOfStorage> m_OA_OutOfStorageList)
+ public bool AddSpecialForums(EC_OrderOperate m_EC_OrderOperate, EC_SpecialOrders m_EC_SpecialOrders, OA_OrderWorkListRelation m_OA_OrderWorkListRelation, List<EC_SpecialForums> m_EC_SpecialForumsList, List<OA_Inventory> m_OA_InventoryList, List<OA_OutOfStorage> m_OA_OutOfStorageList, List<EC_SpecialHoudaos> m_EC_SpecialHoudaosList)
{
try
{
@@ -248,6 +248,7 @@
EC_OrderExtendDAL dal_EC_OrderExtendDAL = new EC_OrderExtendDAL(_dataBase);
OA_OrderWorkListRelationDAL dal_OA_OrderWorkListRelationDAL = new OA_OrderWorkListRelationDAL(_dataBase);
EC_SpecialForumsDAL dal_EC_SpecialForumsDAL = new EC_SpecialForumsDAL(_dataBase);
+ EC_SpecialHoudaosDAL dal_EC_SpecialHoudaosDAL = new EC_SpecialHoudaosDAL(_dataBase);
using (TransactionScope t_TransactionScope = new TransactionScope())
{
@@ -277,6 +278,21 @@
return false;
}
}
+
+ foreach (var m_EC_SpecialHoudaos in m_EC_SpecialHoudaosList)
+ {
+ if (result)
+ {
+ m_EC_SpecialHoudaos.SpecialOrderId = m_EC_SpecialOrders.Keyid;
+ result = dal_EC_SpecialHoudaosDAL.InserModel(m_EC_SpecialHoudaos);
+
+ }
+ else
+ {
+ return false;
+ }
+ }
+
if (result)
{
t_TransactionScope.Complete();
@@ -318,15 +334,18 @@
/// <param name="m_EC_SpecialOrders"></param>
/// <param name="m_EC_SpecialForumsList"></param>
/// <returns></returns>
- public bool UpdateSpecialForums(EC_SpecialOrders m_EC_SpecialOrders, List<EC_SpecialForums> m_EC_SpecialForumsList, List<OA_Inventory> m_OA_InventoryList, List<OA_OutOfStorage> m_OA_OutOfStorageList)
+ public bool UpdateSpecialForums(EC_SpecialOrders m_EC_SpecialOrders, List<EC_SpecialForums> m_EC_SpecialForumsList, List<OA_Inventory> m_OA_InventoryList, List<OA_OutOfStorage> m_OA_OutOfStorageList, List<EC_SpecialHoudaos> m_EC_SpecialHoudaosList)
{
try
{
bool result = false;
EC_SpecialForumsDAL dal_EC_SpecialForumsDAL = new EC_SpecialForumsDAL(_dataBase);
+ EC_SpecialHoudaosDAL dal_EC_SpecialHoudaosDAL = new EC_SpecialHoudaosDAL(_dataBase);
+
List<EC_SpecialForums> m_EC_SpecialForumsList_Old = GetEC_SpecialForumsListByKeyid(m_EC_SpecialOrders.Keyid) as List<EC_SpecialForums>;
+ List<EC_SpecialHoudaos> m_EC_SpecialHoudaosList_Old = GetEC_SpecialHoudaosListByKeyid(m_EC_SpecialOrders.Keyid) as List<EC_SpecialHoudaos>;
using (TransactionScope t_TransactionScope = new TransactionScope())
{
result = UpdateModel(m_EC_SpecialOrders);
@@ -342,6 +361,18 @@
return false;
}
+ foreach (var m_EC_SpecialHoudaos in m_EC_SpecialHoudaosList_Old)
+ {
+ if (result)
+ {
+ result = dal_EC_SpecialHoudaosDAL.DeleteModel(m_EC_SpecialHoudaos);
+ }
+ else
+ return false;
+ }
+
+
+
foreach (var m_EC_SpecialForums in m_EC_SpecialForumsList)
{
if (result)
@@ -352,6 +383,18 @@
else
return false;
}
+
+ foreach (var m_EC_SpecialHoudaos in m_EC_SpecialHoudaosList)
+ {
+ if (result)
+ {
+ m_EC_SpecialHoudaos.SpecialOrderId = m_EC_SpecialOrders.Keyid;
+ result = dal_EC_SpecialHoudaosDAL.InserModel(m_EC_SpecialHoudaos);
+ }
+ else
+ return false;
+ }
+
if (result)
{
t_TransactionScope.Complete();
@@ -388,7 +431,7 @@
/// <param name="MemberId"></param>
/// <returns></returns>
public IEnumerable<Model.EC_SpecialOrders> SelectModelPage(Infrastructure.Query.Pagination pagination, Guid MemberId, string PrintName, string
-CustomName, string PSO_OrderNum, DateTime? beginTime, DateTime? endTime)
+CustomName, string PSO_OrderNum, DateTime? beginTime, DateTime? endTime, string PSF_PressesDesk)
{
try
{
@@ -419,7 +462,10 @@
{
Condition += string.Format(" and PSO_OrderNum like '%{0}%'", PSO_OrderNum);
}
-
+ if (!string.IsNullOrEmpty(PSF_PressesDesk))
+ {
+ Condition += string.Format(" and a.[Keyid] not in ( select [SpecialOrderId] from [EC_SpecialForums] where [PSF_PressesDesk] = '{0}')", PSF_PressesDesk);
+ }
return _dataBase.SelectModelPage<Model.EC_SpecialOrders>(pagination, " a.*,b.BuyerName as CustomName,b.DocumentName as PrintName ", " EC_SpecialOrders as a left join EC_OrderBasic as b on a.PO_OrderId = b.Keyid ", " PSO_OrderNum DESC ", " PSO_OrderNum DESC ", Condition);
}
@@ -428,5 +474,30 @@
throw ex;
}
}
+
+
+
+
+ /// <summary>
+ /// 鏍规嵁缂栧彿鑾峰緱鐗堥潰淇℃伅
+ /// </summary>
+ /// <param name="Keyid"></param>
+ /// <returns></returns>
+ public IEnumerable<Model.EC_SpecialHoudaos> GetEC_SpecialHoudaosListByKeyid(int? Keyid)
+ {
+ try
+ {
+ if (Keyid == null)
+ return null;//閿欒鏁版嵁杩斾細绌�
+
+ IList<EC_SpecialHoudaos> result = _dataBase.SelectModel<EC_SpecialHoudaos>("*", "EC_SpecialHoudaos", string.Format(" SpecialOrderId='{0}'", Keyid)) as IList<EC_SpecialHoudaos>;//鎵ц鏌ヨ
+
+ return result;//杩斿洖缁撴灉
+ }
+ catch (Exception ex)
+ {
+ throw ex;
+ }
+ }
}
}
--
Gitblit v1.9.1