From 51aebb52e3f964ad5d0e96c6b92ae8e455b24ceb Mon Sep 17 00:00:00 2001
From: username@email.com <yzy2002yzy@163.com>
Date: 星期五, 10 四月 2026 13:08:17 +0800
Subject: [PATCH] 需要修改的， 不选板材，直接按照板材规格扣减库存。 发版套数不填的话就是1. 扣减库存的量就是 数量*发版套数 20260410 试卷 6年级添加 答题卡 选项 完成
---
CY_ECommercePlatform/CY.SQLDAL/EC/EC_SpecialOrdersDAL.cs | 74 +++++++++++++++++++++++++++++++++++-
1 files changed, 71 insertions(+), 3 deletions(-)
diff --git a/CY_ECommercePlatform/CY.SQLDAL/EC/EC_SpecialOrdersDAL.cs b/CY_ECommercePlatform/CY.SQLDAL/EC/EC_SpecialOrdersDAL.cs
index 418ea4f..0b57792 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();
@@ -298,7 +314,7 @@
}
foreach (var m_OA_OutOfStorage in m_OA_OutOfStorageList)
{
- m_OA_OutOfStorage.Remark = string.Format("<span class='a_under' title='鐐瑰嚮鏌ョ湅鏂藉伐鍗曡鎯�' onclick=\"ViewModel_Special('" + m_EC_SpecialOrders.PO_OrderId + "')\">涓撶増锛�" + m_EC_SpecialOrders.PSO_OrderNum + "</span>");
+ m_OA_OutOfStorage.Remark = string.Format("<span class='a_under' title='鐐瑰嚮鏌ョ湅鏂藉伐鍗曡鎯�' onclick=\"ViewModel_Special('" + m_EC_SpecialOrders.Keyid + "')\">涓撶増锛�" + m_EC_SpecialOrders.PSO_OrderNum + "</span>");
dal_OA_OutOfStorageDAL.InserModel(m_OA_OutOfStorage);
}
}
@@ -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();
@@ -431,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