From 7bcbbbd0459f00ebc3aa7d4f249cb9231a6b5d40 Mon Sep 17 00:00:00 2001
From: username@email.com <yzy2002yzy@163.com>
Date: 星期五, 31 十月 2025 12:25:17 +0800
Subject: [PATCH] 这个销售绩效查询这个列表中的，你把这个到期类型和到期时间合并，现在到期类型就不要了， 到期时间里面，日期的就显示。时间，他是和金额执行完毕的，就在到期时间里头， 就填上金额执行完毕那个合同金额也是就有金额的显示。金额没得金额的，就先据实结算。好，合同类型这个就不要了。
---
CY_ECommercePlatform/CY.SQLDAL/OA/OA_DeliverPlanPaicheDAL.cs | 5 +++--
1 files changed, 3 insertions(+), 2 deletions(-)
diff --git a/CY_ECommercePlatform/CY.SQLDAL/OA/OA_DeliverPlanPaicheDAL.cs b/CY_ECommercePlatform/CY.SQLDAL/OA/OA_DeliverPlanPaicheDAL.cs
index fab239d..492fcd3 100644
--- a/CY_ECommercePlatform/CY.SQLDAL/OA/OA_DeliverPlanPaicheDAL.cs
+++ b/CY_ECommercePlatform/CY.SQLDAL/OA/OA_DeliverPlanPaicheDAL.cs
@@ -133,9 +133,10 @@
new SqlParameter("@Deliveredstatus",trueModel.Deliveredstatus.HasValue?trueModel.Deliveredstatus.Value:0),
new SqlParameter("@TransferType",trueModel.TransferType.HasValue?trueModel.TransferType.Value:0),
new SqlParameter("@TransferName",string.IsNullOrEmpty(trueModel.TransferName)?"":trueModel.TransferName),
+ new SqlParameter("@Zerenren",trueModel.Zerenren.HasValue?trueModel.Zerenren.Value:0),
};
- string sql = "Insert Into [OA_DeliverPlanPaiche] ([Keyid],[FirmId],[BuyerId],[DeliveredTime],[Zhuyishixiang],[Gongzuokaoping], [CarId], [DriverId],[Transferstatus], [TransfersTime], [Creater],[CreateTime],[Updater],[LastUpdateTime],[Sort],DeliverTime,wentifankui,Yichangchuli,Xingzhengzhuize,SellerOrderId,Dianhua,Dizhi,Remark,BusinessManagerId,Biddingcompany,shifouDelivery,Lianxiren,CompanyName,Deliveredstatus,TransferType,TransferName)"
- + " Values ( @Keyid,@FirmId,@BuyerId,@DeliveredTime, @Zhuyishixiang,@Gongzuokaoping, @CarId, @DriverId, @Transferstatus, @TransfersTime, @Creater,@CreateTime,@Updater,@LastUpdateTime,@Sort,@DeliverTime,@wentifankui,@Yichangchuli,@Xingzhengzhuize,@SellerOrderId,@Dianhua,@Dizhi,@Remark,@BusinessManagerId,@Biddingcompany,@shifouDelivery,@Lianxiren,@CompanyName,@Deliveredstatus,@TransferType,@TransferName )";
+ string sql = "Insert Into [OA_DeliverPlanPaiche] ([Keyid],[FirmId],[BuyerId],[DeliveredTime],[Zhuyishixiang],[Gongzuokaoping], [CarId], [DriverId],[Transferstatus], [TransfersTime], [Creater],[CreateTime],[Updater],[LastUpdateTime],[Sort],DeliverTime,wentifankui,Yichangchuli,Xingzhengzhuize,SellerOrderId,Dianhua,Dizhi,Remark,BusinessManagerId,Biddingcompany,shifouDelivery,Lianxiren,CompanyName,Deliveredstatus,TransferType,TransferName,Zerenren)"
+ + " Values ( @Keyid,@FirmId,@BuyerId,@DeliveredTime, @Zhuyishixiang,@Gongzuokaoping, @CarId, @DriverId, @Transferstatus, @TransfersTime, @Creater,@CreateTime,@Updater,@LastUpdateTime,@Sort,@DeliverTime,@wentifankui,@Yichangchuli,@Xingzhengzhuize,@SellerOrderId,@Dianhua,@Dizhi,@Remark,@BusinessManagerId,@Biddingcompany,@shifouDelivery,@Lianxiren,@CompanyName,@Deliveredstatus,@TransferType,@TransferName,@Zerenren )";
try
{
_dataBase.ExecuteSql(sql, sqlParms.ToArray<SqlParameter>());
--
Gitblit v1.9.1