From 2fee7b9b90c1acf7a17aef84ee22c2a31b801fe2 Mon Sep 17 00:00:00 2001
From: username@email.com <yzy2002yzy@163.com>
Date: 星期五, 07 三月 2025 08:34:42 +0800
Subject: [PATCH] 送货管理 增加查询 业务经理 客户名称 完成 查询送货安排的历史 完成
---
CY_ECommercePlatform/CY.BLL/EC/EC_OrderBasicBLL.cs | 145 +++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 143 insertions(+), 2 deletions(-)
diff --git a/CY_ECommercePlatform/CY.BLL/EC/EC_OrderBasicBLL.cs b/CY_ECommercePlatform/CY.BLL/EC/EC_OrderBasicBLL.cs
index 8d97fd8..84ff7ae 100644
--- a/CY_ECommercePlatform/CY.BLL/EC/EC_OrderBasicBLL.cs
+++ b/CY_ECommercePlatform/CY.BLL/EC/EC_OrderBasicBLL.cs
@@ -29,6 +29,9 @@
using CY.Model;
using CY.IDAL;
using CY.Infrastructure.Query;
+using CY.Model.Inquiry;
+using CY.Infrastructure.Common;
+using CY.IDAL.EC;
namespace CY.BLL.EC
{
@@ -38,10 +41,15 @@
public class EC_OrderBasicBLL
{
IEC_OrderBasicDAL _eC_OrderBasicDAL = null;
-
+ IEC_OrderPrintParameterDAL _eC_OrderPrintParameterDAL = null;
+ IEC_OrderExtendDAL _eC_OrderExtendDAL = null;
+ IPay_TradingSingleDAL _pay_TradingSingleDAL = null;
public EC_OrderBasicBLL()
{
_eC_OrderBasicDAL = AbstractFactory.Factory.GetDALByInterfaceName(AbstractFactory.DALInterface.IEC_OrderBasicDAL) as IEC_OrderBasicDAL;
+ _eC_OrderPrintParameterDAL = AbstractFactory.Factory.GetDALByInterfaceName(AbstractFactory.DALInterface.IEC_OrderPrintParameterDAL) as IEC_OrderPrintParameterDAL;
+ _eC_OrderExtendDAL = AbstractFactory.Factory.GetDALByInterfaceName(AbstractFactory.DALInterface.IEC_OrderExtendDAL) as IEC_OrderExtendDAL;
+ _pay_TradingSingleDAL = AbstractFactory.Factory.GetDALByInterfaceName(AbstractFactory.DALInterface.IPay_TradingSingleDAL) as IPay_TradingSingleDAL;
}
/// <summary>
@@ -64,6 +72,17 @@
public IEnumerable<EC_OrderBasic> SelectModelPage_Seller(Infrastructure.Query.Pagination pagination, Dictionary<int, object> searchParam)
{
return _eC_OrderBasicDAL.SelectModelPage_Seller(pagination, searchParam);
+ }
+
+
+ /// <summary>
+ /// 浣滀笟鏈�佽揣鍒嗛〉鏌ヨ
+ /// </summary>
+ /// <param name="pagination"></param>
+ /// <returns></returns>
+ public IEnumerable<EC_OrderBasic> SelectModelPageWorkBook(Infrastructure.Query.Pagination pagination, Guid _MemberID, string txtBeginDate, string txtEndDate, string txtOrderId, string txtSearchyjname, string selCustormerManager, string selBusinessManager, string selOrderStates)
+ {
+ return _eC_OrderBasicDAL.SelectModelPageWorkBook(pagination, _MemberID, txtBeginDate, txtEndDate, txtOrderId, txtSearchyjname, selCustormerManager, selBusinessManager, selOrderStates);
}
/// <summary>
@@ -122,6 +141,17 @@
}
/// <summary>
+ /// 閿佸畾璁㈠崟
+ /// </summary>
+ /// <param name="orderId">璁㈠崟缂栧彿</param>
+ /// <param name="operator">鎿嶄綔浜�</param>
+ /// <returns></returns>
+ public bool SuodingOrder(int orderId, string operater)
+ {
+ return _eC_OrderBasicDAL.SuodingOrder(orderId, operater);
+ }
+
+ /// <summary>
/// 鎵归噺鍙楃悊璁㈠崟
/// </summary>
/// <param name="orderIds"></param>
@@ -140,6 +170,16 @@
public bool UpdateOrderState(params EC_OrderOperate[] orderOperates)
{
return _eC_OrderBasicDAL.UpdateOrderState(orderOperates);
+ }
+
+ /// <summary>
+ /// 淇敼璁㈠崟鐘舵��(闈炴敮浠樼姸鎬佷笖涓嶅彲淇敼涓烘湭鍙楃悊鍜屽凡鍙楃悊)
+ /// </summary>
+ /// <param name="orderOperate">璁㈠崟鎿嶄綔</param>
+ /// <returns></returns>
+ public bool UpSurplusPrintNum(int? Keyid, int? SurplusPrintNum, string Operator)
+ {
+ return _eC_OrderExtendDAL.UpSurplusPrintNumsql(Keyid, SurplusPrintNum, Operator);
}
/// <summary>
@@ -255,6 +295,18 @@
public bool ReceiveMoneyToAccount(int orderId, OA_FirmAccountRecord firmAccountRecord)
{
return _eC_OrderBasicDAL.ReceiveMoneyToAccount(orderId, firmAccountRecord);
+ }
+
+
+ /// <summary>
+ /// 鏀舵(绾夸笅杞处銆佺幇閲�)
+ /// </summary>
+ /// <param name="orderId">璁㈠崟缂栧彿</param>
+ /// <param name="firmAccountRecord">鎿嶄綔璁板綍</param>
+ /// <returns></returns>
+ public bool ReceiveMoneyToQueren(int orderId, OA_FirmAccountRecord firmAccountRecord)
+ {
+ return _eC_OrderBasicDAL.ReceiveMoneyToQueren(orderId, firmAccountRecord);
}
/// <summary>
@@ -494,6 +546,18 @@
return _eC_OrderBasicDAL.DeleteOutOrder(OrderId);
}
+
+ /// <summary>
+ /// 鍒犻櫎澶栧崗璁㈠崟
+ /// </summary>
+ /// <param name="OrderId"></param>
+ /// <returns></returns>
+ public bool UpdateOldOrderSurplusPrintNum(int outOrderId)
+ {
+ return _eC_OrderBasicDAL.UpdateOldOrderSurplusPrintNum(outOrderId);
+ }
+
+
/// <summary>
/// 鏍规嵁鏂板璁㈠崟鎿嶄綔锛屽苟淇敼璁㈠崟鐘舵��
/// </summary>
@@ -523,7 +587,7 @@
/// <returns></returns>
public IEnumerable<EC_OrderBasic> GetModelPageListForPrepayments(Pagination pa, string DeliveryTime, string Province, string City, string County, string BuyerName, string BusinessManagerId, string SellerOrderId, string DocumentName, Guid SellerId)
{
- string Condition = " and ( ob.[OrderState] ='2' or ob.[OrderState] ='3' and SellerId='"+ SellerId + "' )";
+ string Condition = " and ( ob.[OrderState] ='1' or ob.[OrderState] ='2' or ob.[OrderState] ='3' ) and SellerId='" + SellerId + "' ";
if (!string.IsNullOrEmpty(DeliveryTime))
{
@@ -634,5 +698,82 @@
{
return _eC_OrderBasicDAL.GetEC_OrderBasicListBydeliverorderId(deliverorderId, FirmId);
}
+
+
+ /// <summary>
+ /// 閲嶆柊璁＄畻璁㈠崟鐨勯噾棰�
+ /// </summary>
+ /// <param name="orderOperate"></param>
+ /// <returns></returns>
+ public bool UpdateorderJine(int orderId)
+ {
+ CoreCmsPlanOrderBLL _PlanOrderBLL = new CoreCmsPlanOrderBLL();
+ CoreCmsPlanOrderItemBLL _coreCmsPlanOrderItemBLL = new CoreCmsPlanOrderItemBLL();
+
+ var eC_OrderBasic = this.SelectModelById(orderId);
+ EC_OrderPrintParameterBLL _OrderPrintParameterBLL = new EC_OrderPrintParameterBLL();
+ var eC_OrderPrintParameter = _OrderPrintParameterBLL.GetModel(orderId);
+ InquiryCommonModel model = SerializationHelper.DeSerialize(typeof(InquiryCommonModel), eC_OrderPrintParameter.PrintParameter) as InquiryCommonModel;
+
+ //eC_OrderBasic.SumPrice =12 ;
+ //eC_OrderBasic.UnitPrice = 12;
+ var sss = model.InquiryWorkBookList;
+
+ var coreCmsPlanOrders = _PlanOrderBLL.GetModelByorderid(orderId).ToList();
+
+
+ decimal SumPrice = 0;
+ int num = 0;
+
+ var coreCmsPlanOrders2 = new List<CoreCmsPlanOrderItem>();
+
+ foreach (var coreCmsPlanOrder in coreCmsPlanOrders)
+ {
+ var coreCmsPlanOrders1 = _coreCmsPlanOrderItemBLL.GetModelsByOrderid(coreCmsPlanOrder.id).ToList();
+ coreCmsPlanOrders2.AddRange(coreCmsPlanOrders1);
+
+ num += coreCmsPlanOrders1.Sum(x=>x.nums);
+ SumPrice += coreCmsPlanOrders1.Sum(x => x.amount);
+
+ }
+
+ eC_OrderBasic.SumPrice = SumPrice;
+ if (num > 0)
+ {
+ eC_OrderBasic.UnitPrice = Math.Round(SumPrice / new decimal(num), 4);
+ }
+ else
+ {
+ eC_OrderBasic.UnitPrice = 0;
+ }
+
+
+
+ model.PrintCount = num;
+ foreach ( var inquiryWorkBookModel in model.InquiryWorkBookList)
+ {
+ var sssssss = coreCmsPlanOrders2.Where(x => x.name == inquiryWorkBookModel.WorkBookNameTxt && x.specification == inquiryWorkBookModel.WorkBookSizeTxt).ToList();
+ inquiryWorkBookModel.WorkBookCount = sssssss.Sum(x=>x.nums).ToString2();
+ inquiryWorkBookModel.WorkBookMoney = sssssss.Sum(x=>x.amount).ToString2();
+ }
+
+
+ var isWin = _eC_OrderBasicDAL.Updatejinedanjia(eC_OrderBasic.Keyid.Value, eC_OrderBasic.SumPrice.Value, eC_OrderBasic.UnitPrice.Value, num);
+
+ eC_OrderPrintParameter.PrintParameter = SerializationHelper.Serialize(model);
+ isWin = _eC_OrderPrintParameterDAL.UpdateModel(eC_OrderPrintParameter);
+
+
+ var pay_TradingSingles = _pay_TradingSingleDAL.GetOrderByIds(eC_OrderBasic.Keyid.Value).FirstOrDefault() ;
+ if (pay_TradingSingles != null)
+ {
+ pay_TradingSingles.TradingMoney = eC_OrderBasic.SumPrice.Value;
+ pay_TradingSingles.PayableMoney = eC_OrderBasic.SumPrice.Value;
+ isWin = _pay_TradingSingleDAL.UpdateModel(pay_TradingSingles);
+ }
+
+ return isWin;
+ }
+
}
}
--
Gitblit v1.9.1