From 120215455f4fb2e5a1447f3ecda87f36aca1f38f Mon Sep 17 00:00:00 2001
From: username@email.com <yzy2002yzy@163.com>
Date: 星期五, 27 二月 2026 08:54:22 +0800
Subject: [PATCH] 1）有到期时间的，到期前3个月变成红色（像人事管理那样）；没有到期时间的，从建档时间起算，9个月后变成红色。完成 （2）建档后1个月没有下单，变成血红色。 完成 （3）列表中删除“完结状态”；操作中删除“订单关联” 完成 （4）在“应收款订单”后面增加“未收款金额” 、“逾期收款”完成
---
CY_ECommercePlatform/CY.WebForm/Pages/business/CorporateClientsList.aspx.cs | 189 +++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 188 insertions(+), 1 deletions(-)
diff --git a/CY_ECommercePlatform/CY.WebForm/Pages/business/CorporateClientsList.aspx.cs b/CY_ECommercePlatform/CY.WebForm/Pages/business/CorporateClientsList.aspx.cs
index a5672fb..8cb7b57 100644
--- a/CY_ECommercePlatform/CY.WebForm/Pages/business/CorporateClientsList.aspx.cs
+++ b/CY_ECommercePlatform/CY.WebForm/Pages/business/CorporateClientsList.aspx.cs
@@ -154,8 +154,156 @@
foreach (var item in this.RepClientList.DataSource as IEnumerable<OA_CorporateClients>)
{
item.LessOrderMoneyProperty = item.Contractmoney-item.OrderMoney;
+ var ssss = bll_eC_OrderBasicDAL.GetOrderById(item.Keyid, -1, CurrentUser.MemberId);
+ item.NoOverOderCount = ssss.Count;
+ if (ssss.Count > 0)
+ {
+ string ids = "";
- item.NoOverOderCount = bll_eC_OrderBasicDAL.GetOrderById(item.Keyid, -1, CurrentUser.MemberId).Count;
+ foreach(var c_OrderBasic in ssss)
+ {
+ ids += c_OrderBasic.Keyid + ",";
+ }
+ ids = ids.Trim(',');
+ var eC_OrderBasics = bll_eC_OrderBasicDAL.GetOrderByIds(ids);
+
+
+ item.Weishoukuanjine = eC_OrderBasics.Sum(x => x.UnPayedMoney);
+
+
+ var sssssss = item.Paytime;
+ var Paydays = item.Paydays.HasValue? item.Paydays.Value:0;
+ var Shifouwanjie = item.Shifouwanjie.HasValue ? item.Shifouwanjie.Value : 2;
+ item.Yuqijine = 0;
+ foreach (var eC_OrderBasic in eC_OrderBasics)
+ {
+ //鍒ゆ柇璁㈠崟鏄惁閫炬湡
+ var yuqi = false;
+ var ssdfsdf = eC_OrderBasic.CreateTime.Value.Date;
+
+ if(sssssss == 1)
+ {
+ // 姝ラ1锛氳幏鍙栧綋鍓嶆椂闂寸殑鈥滄湰鏈堢涓�澶┾��
+ DateTime currentMonthFirstDay = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1);
+
+ if(ssdfsdf < currentMonthFirstDay)
+ {
+ yuqi = true;
+ }
+ }
+ else if (sssssss == 2)
+ {
+ // 姝ラ1锛氭彁鍙栨棩鏈熺殑骞翠唤鍜屾湀浠斤紙蹇界暐鏃跺垎绉掞級
+ int year = DateTime.Now.Year;
+ int month = DateTime.Now.Month;
+
+ // 姝ラ2锛氳绠楀綋鍓嶆湀浠芥墍灞炲搴︾殑璧峰鏈堜唤锛堟牳蹇冨叕寮忥級
+ // 閫昏緫锛�(鏈堜唤-1)/3 寰楀埌瀛ｅ害绱㈠紩锛�0=Q1,1=Q2,2=Q3,3=Q4锛夛紝鍐嵜�3+1寰楀埌璧峰鏈�
+ int quarterStartMonth = ((month - 1) / 3) * 3 + 1;
+
+ // 姝ラ3锛氱粍鍚堟垚鏈搴︾涓�澶╋紙浠呮棩鏈燂紝鏃跺垎绉掍负00:00:00锛�
+ DateTime quarterFirstDay = new DateTime(year, quarterStartMonth, 1);
+ if (ssdfsdf < quarterFirstDay)
+ {
+ yuqi = true;
+ }
+ }
+ else if (sssssss == 3)
+ {
+ // 姝ラ1锛氭彁鍙栨棩鏈熺殑骞翠唤鍜屾湀浠斤紙蹇界暐鏃跺垎绉掞級
+ int year = DateTime.Now.Year;
+ int month = DateTime.Now.Month;
+
+ // 鍒ゆ柇鎵�灞炲崐骞达紝纭畾璧峰鏈堜唤
+ int halfYearStartMonth = month <= 6 ? 1 : 7;
+
+ // 缁勫悎鎴愭湰鍗婂勾绗竴澶╋紙鏃跺垎绉掗粯璁�00:00:00锛�
+ DateTime halfYearFirstDay = new DateTime(year, halfYearStartMonth, 1);
+ if (ssdfsdf < halfYearFirstDay)
+ {
+ yuqi = true;
+ }
+ }
+ else if (sssssss == 4)
+ {
+ // 姝ラ1锛氭彁鍙栨棩鏈熺殑骞翠唤鍜屾湀浠斤紙蹇界暐鏃跺垎绉掞級
+ int year = DateTime.Now.Year;
+ int month = DateTime.Now.Month;
+
+ // 鏍稿績閫昏緫锛氭彁鍙栧勾浠斤紝鐩存帴鏋勯��1鏈�1鏃�
+ DateTime yearFirstDay = new DateTime(year, 1, 1);
+
+ if (ssdfsdf < yearFirstDay)
+ {
+ yuqi = true;
+ }
+ }
+ else if (sssssss == 5)
+ {
+ // 姝ラ1锛氭彁鍙栨棩鏈熺殑骞翠唤鍜屾湀浠斤紙蹇界暐鏃跺垎绉掞級
+ int year = DateTime.Now.Year;
+ int month = DateTime.Now.Month;
+
+ DateTime semesterFirstDay;
+ if (month >= 3 && month <= 8)
+ {
+ // 3-8鏈堬細褰撳勾绗竴瀛︽湡锛岄鏃�=褰撳勾3鏈�1鏃�
+ semesterFirstDay = new DateTime(year, 3, 1);
+ }
+ else if (month >= 9 && month <= 12)
+ {
+ // 9-12鏈堬細褰撳勾绗簩瀛︽湡锛岄鏃�=褰撳勾9鏈�1鏃�
+ semesterFirstDay = new DateTime(year, 9, 1);
+ }
+ else // 1-2鏈�
+ {
+ // 1-2鏈堬細涓婁竴骞寸浜屽鏈燂紝棣栨棩=涓婁竴骞�9鏈�1鏃�
+ semesterFirstDay = new DateTime(year - 1, 9, 1);
+ }
+
+ if (ssdfsdf < semesterFirstDay)
+ {
+ yuqi = true;
+ }
+ }
+ else if (sssssss == 6)
+ {
+ if (Shifouwanjie == 1)
+ {
+ yuqi = true;
+ }
+ }
+ else if (sssssss == 7)
+ {
+ // 绗簩姝ワ細璁＄畻鏃堕棿宸紝鍙朌ays灞炴�э紙宸插彇鏁达級锛岀粷瀵瑰�间繚璇佺粨鏋滀负姝�
+ TimeSpan timeSpan = DateTime.Now.Date.Subtract(ssdfsdf);
+
+ var sss = Math.Abs(timeSpan.Days);
+
+ if (sss > Paydays)
+ {
+ yuqi = true;
+ }
+ }
+
+
+
+
+ if (yuqi)
+ {
+ if (eC_OrderBasic.UnPayedMoney >= 0)
+ {
+ item.Yuqijine += eC_OrderBasic.UnPayedMoney;
+ }
+ }
+ }
+ }
+
+
+
+
+
+
Database DC = new Database();
try
{
@@ -174,8 +322,47 @@
if (DC.Connection.State != System.Data.ConnectionState.Closed)
DC.Connection.Close();
}
+ item.Yanse = "";
+ //if (item.Keyid == item.MemberId)
+ //{
+ // item.Yanse = "green";
+ //}
+ //鏈夊埌鏈熸椂闂寸殑锛屽埌鏈熷墠3涓湀鍙樻垚绾㈣壊锛堝儚浜轰簨绠＄悊閭ｆ牱锛夛紱
+ if (item.Expiretype.HasValue && item.Expiretype == 1)
+ {
+ if (item.ExpireTime.HasValue)
+ {
+ if (item.ExpireTime.Value < DateTime.Now.AddMonths(3))
+ {
+ item.Yanse = "red";
+ }
+ }
+
+ }
+
+ if (item.CreateTime.HasValue)
+ {
+ //娌℃湁鍒版湡鏃堕棿鐨勶紝浠庡缓妗ｆ椂闂磋捣绠楋紝9涓湀鍚庡彉鎴愮孩鑹层��
+ if (item.CreateTime.Value < DateTime.Now.AddMonths(-9))
+ {
+ item.Yanse = "red";
+ }
+ //寤烘。鍚�1涓湀娌℃湁涓嬪崟锛屽彉鎴愯绾㈣壊銆�
+ if (item.CreateTime.Value < DateTime.Now.AddMonths(-1))
+ {
+ if (!item.OrderCount.HasValue || item.OrderCount.Value <= 0)
+ {
+ item.Yanse = "maroon";
+ }
+ }
+
+
+
+
+ }
+
}
this.RepClientList.DataBind();
UCPager1.AspNetPager.RecordCount = pa.RecordCount;
--
Gitblit v1.9.1