From 711fc30d62069784f461426d8c00a30dfd54e1a9 Mon Sep 17 00:00:00 2001
From: username@email.com <yzy2002yzy@163.com>
Date: 星期三, 17 十二月 2025 12:14:11 +0800
Subject: [PATCH] 20251217 逾期款项列表的“未收款金额”下面加个合计
---
CY_ECommercePlatform/CY.WebForm/Pages/business/DeliverPlanDakaList.aspx.cs | 102 ++++++++++++++++++++++++++++++++++++++++++++++++++-
1 files changed, 100 insertions(+), 2 deletions(-)
diff --git a/CY_ECommercePlatform/CY.WebForm/Pages/business/DeliverPlanDakaList.aspx.cs b/CY_ECommercePlatform/CY.WebForm/Pages/business/DeliverPlanDakaList.aspx.cs
index b9c634d..575a35e 100644
--- a/CY_ECommercePlatform/CY.WebForm/Pages/business/DeliverPlanDakaList.aspx.cs
+++ b/CY_ECommercePlatform/CY.WebForm/Pages/business/DeliverPlanDakaList.aspx.cs
@@ -118,7 +118,7 @@
this.txtCreatTimeend.Value,
this.selCarId.Value,
this.txtCreater.Value,
- this.selClockType.Value
+ ""
);
Database DC = new Database();
@@ -128,6 +128,104 @@
List<OA_CorporateClientsContract> fileDataList = null;
foreach (var oA_DriverRecord in oA_DriverRecords)
{
+
+
+ var oA_DriverRecord1 = _oA_DriverRecordBLL.GetModelByTimeCarIDClockType(oA_DriverRecord.CreatTime, oA_DriverRecord.CarID, 2);
+ if (oA_DriverRecord1 != null)
+ {
+ oA_DriverRecord1.CreatTimeName = oA_DriverRecord1.CreatTime.ToString("yyyy-MM-dd HH:mm:ss");
+ if (string.IsNullOrEmpty(oA_DriverRecord1.MileageImg))
+ {
+ oA_DriverRecord1.MileageImgName = "";
+ }
+ else
+ {
+ oA_DriverRecord1.MileageImgName = "<img src=\"" + oA_DriverRecord1.MileageImg + "\" width=\"20\" height=\"20\" >";
+ }
+
+
+
+
+
+ string sqlStr1 = string.Format(@" select * from [dbo].[OA_attachment] where [OA_Id]='{0}' and [AttachmentType]=4 order by [CreateTime] ", oA_DriverRecord1.Id);
+
+ SqlCommand myCmd1 = new SqlCommand(sqlStr1, DC.Connection);
+ //SqlDataAdapter myDa = new SqlDataAdapter(myCmd);
+ var a1 = myCmd1.ExecuteReader();
+ //myDa.Dispose();
+ fileDataList = new List<OA_CorporateClientsContract>();
+ OA_CorporateClientsContract Contract1;
+ var j = 1;
+ while (a1.Read())
+ { //娉ㄦ剰濡備綍灏嗘瘡娆¤鍙栧埌鐨勮褰曟坊鍔犲埌listbox1涓紙鍥犱负绗竴娆″仛鏃跺嚭閿欎簡锛屽樋鍢匡級
+ Contract1 = new OA_CorporateClientsContract();
+ // Contract.Keyid = a.GetInt32(0);
+ //Contract.CorporateClientsid = a.GetGuid(1);
+ //Contract.CorporateClientsName = a.GetString(4);
+ Contract1.FileName = a1[4].ToString();
+ Contract1.PageCode = j;
+ Contract1.FilePath = a1.GetString(2);
+ // Contract.Remark = a.GetString(6);
+ j += 1;
+
+ fileDataList.Add(Contract1);
+ }
+ a1.Close(); //鍏抽棴sqldatareader
+
+ if (fileDataList.Count > 0)
+ {
+ oA_DriverRecord1.ZhuangcheImg = "<img src=\"" + fileDataList[0].FilePath + "\" width=\"20\" height=\"20\" >";
+ }
+ else
+ {
+ oA_DriverRecord1.ZhuangcheImg = "";
+ }
+
+
+
+
+ sqlStr1 = string.Format(@" select * from [dbo].[OA_attachment] where [OA_Id]='{0}' and [AttachmentType]=5 order by [CreateTime] ", oA_DriverRecord1.Id);
+
+ myCmd1 = new SqlCommand(sqlStr1, DC.Connection);
+ //SqlDataAdapter myDa = new SqlDataAdapter(myCmd);
+ a1 = myCmd1.ExecuteReader();
+ //myDa.Dispose();
+ fileDataList = new List<OA_CorporateClientsContract>();
+ j = 1;
+ while (a1.Read())
+ { //娉ㄦ剰濡備綍灏嗘瘡娆¤鍙栧埌鐨勮褰曟坊鍔犲埌listbox1涓紙鍥犱负绗竴娆″仛鏃跺嚭閿欎簡锛屽樋鍢匡級
+ Contract1 = new OA_CorporateClientsContract();
+ // Contract.Keyid = a.GetInt32(0);
+ //Contract.CorporateClientsid = a.GetGuid(1);
+ //Contract.CorporateClientsName = a.GetString(4);
+ Contract1.FileName = a1[4].ToString();
+ Contract1.PageCode = j;
+ Contract1.FilePath = a1.GetString(2);
+ // Contract.Remark = a.GetString(6);
+ j += 1;
+
+ fileDataList.Add(Contract1);
+ }
+ a1.Close(); //鍏抽棴sqldatareader
+
+ if (fileDataList.Count > 0)
+ {
+ oA_DriverRecord1.CarConditionImg = "<img src=\"" + fileDataList[0].FilePath + "\" width=\"20\" height=\"20\" >";
+ }
+ else
+ {
+ oA_DriverRecord1.CarConditionImg = "";
+ }
+
+ oA_DriverRecord.oA_DriverRecord = oA_DriverRecord1;
+ }
+ else
+ {
+ oA_DriverRecord.oA_DriverRecord = new OA_DriverRecord();
+ }
+
+
+
if (string.IsNullOrEmpty(oA_DriverRecord.MileageImg))
{
oA_DriverRecord.MileageImgName = "";
@@ -272,7 +370,7 @@
this.txtCreatTimeend.Value,
this.selCarId.Value,
this.txtCreater.Value,
- this.selClockType.Value
+ ""
);
// 鍒涘缓宸ヤ綔绨�
--
Gitblit v1.9.1