From d9666ecd3599c458ddd714dafe96f28bfba93cac Mon Sep 17 00:00:00 2001
From: username@email.com <yzy2002yzy@163.com>
Date: 星期二, 04 十一月 2025 08:45:40 +0800
Subject: [PATCH] 绩效查询 未完结的客户数量有问题，查找问题
---
CY_ECommercePlatform/CY.Model/OA/OA_DeliverPlan.cs | 266 +++++++++++++++++++++++++++++++++++++++++++++++-----
1 files changed, 239 insertions(+), 27 deletions(-)
diff --git a/CY_ECommercePlatform/CY.Model/OA/OA_DeliverPlan.cs b/CY_ECommercePlatform/CY.Model/OA/OA_DeliverPlan.cs
index 40a4952..3c24c8b 100644
--- a/CY_ECommercePlatform/CY.Model/OA/OA_DeliverPlan.cs
+++ b/CY_ECommercePlatform/CY.Model/OA/OA_DeliverPlan.cs
@@ -38,7 +38,13 @@
public Guid Keyid { get; set; }
public Guid? YujihuikuanKeyid { get; set; }
-
+
+
+ /// <summary>
+ /// 鍚堝苟閫佽揣鍗昳d
+ /// </summary>
+ public Guid? DeliverPlanPaicheid { get; set; }
+
/// <summary>
/// OrderId
/// </summary>
@@ -56,6 +62,8 @@
/// </summary>
public string BuyerName { get; set; }
+ public string CompanyName { get; set; }
+
public string BusinessManager { get; set; }
public string DizhiLianxirenDianhua { get; set; }
@@ -63,7 +71,11 @@
public int? shuliang { get; set; }
-
+ public int? fapiaoshuliang { get; set; }
+
+ public string fapiaoshuliangName { get; set; }
+
+
/// <summary>
/// 瑕佹眰鍒拌揪鏃堕棿
@@ -135,6 +147,37 @@
get;
set;
}
+
+ /// <summary>
+ /// 鐗╂祦鐘舵��
+ /// </summary>
+ public int? Deliveredstatus
+ {
+ get;
+ set;
+ }
+
+ /// <summary>
+ /// 绉讳氦绫诲瀷 1 瀹㈡埛缁忕悊 2 宸ュ巶鐗╂祦閮�
+ /// </summary>
+ public int? TransferType
+ {
+ get;
+ set;
+ }
+
+
+ /// <summary>
+ /// 绉讳氦绫诲瀷鍚嶇О
+ /// </summary>
+ public string TransferName
+ {
+ get;
+ set;
+ }
+
+
+
/// <summary>
/// 绉讳氦鏃堕棿
/// </summary>
@@ -306,6 +349,16 @@
set;
}
+
+ /// <summary>
+ /// 鍌璁板綍
+ /// </summary>
+ public string Cuikuanjilu
+ {
+ get;
+ set;
+ }
+
/// <summary>
/// 鏈粯娆�
/// </summary>
@@ -317,19 +370,47 @@
}
}
+
/// <summary>
/// 鏈粯娆�
/// </summary>
- public decimal UnorderMoney
+ public decimal? OrAllUnPayedMoney
+ {
+ get;
+ set;
+ }
+
+ /// <summary>
+ /// 鏈粯娆�
+ /// </summary>
+ public decimal? UnorderMoney
{
get
{
- return SumPrice.HasValue && Contractmoney.HasValue ? (Contractmoney - SumPrice).Value : 0;
+ var aaaa = SumPrice.HasValue ? SumPrice.Value : 0;
+ if ( Contractmoney.HasValue)
+ {
+ var sss = Contractmoney.Value - aaaa;
+ if (sss < 0)
+ {
+ return null;
+ }
+ return sss;
+ }
+
+ return null;
}
}
public string shoukuanshijian
+ {
+ get;
+ set;
+ }
+
+ //閫佽揣鍗曞浘鐗囩殑灞曠ず
+ public string SonghuodanTupian
{
get;
set;
@@ -392,6 +473,63 @@
}
public decimal? huifangshuliang
+ {
+ get;
+ set;
+ }
+
+ public int? Wanjiestatus
+ {
+ get;
+ set;
+ }
+ public string WanjiestatusName
+ {
+ get
+ {
+ return Wanjiestatus.HasValue&& Wanjiestatus.Value==1 ? "鈭�" : "脳";
+ }
+
+ }
+
+ public DateTime? WanjieTime
+ {
+ get;
+ set;
+ }
+
+ public string Wanjieren
+ {
+ get;
+ set;
+ }
+
+ public int? Zerenren
+ {
+ get;
+ set;
+ }
+
+ public string ZerenrenName
+ {
+ get;
+ set;
+ }
+
+ public decimal? Fakuan
+ {
+ get;
+ set;
+ }
+
+
+ public DateTime? ZerenTime
+ {
+ get;
+ set;
+ }
+
+ public string Zerenoperater
{
get;
set;
@@ -593,124 +731,198 @@
this.Lianxiren = isChange ? MyConvert.ConvertToString(value) : Lianxiren;
theValue = this.Lianxiren;
}
- else if ("SumPrice".Equals(name, StringComparison.CurrentCultureIgnoreCase) || index == 34)
+ else if ("SumPrice".Equals(name, StringComparison.CurrentCultureIgnoreCase) || index == 35)
{
this.SumPrice = isChange ? MyConvert.ConvertToDecimal(value) : SumPrice;
theValue = this.SumPrice;
}
- else if ("PayedMoney".Equals(name, StringComparison.CurrentCultureIgnoreCase) || index == 34)
+ else if ("PayedMoney".Equals(name, StringComparison.CurrentCultureIgnoreCase) || index == 36)
{
this.PayedMoney = isChange ? MyConvert.ConvertToDecimal(value) : PayedMoney;
theValue = this.PayedMoney;
}
- else if ("shoukuanshijian".Equals(name, StringComparison.CurrentCultureIgnoreCase) || index == 34)
+ else if ("shoukuanshijian".Equals(name, StringComparison.CurrentCultureIgnoreCase) || index == 37)
{
this.shoukuanshijian = isChange ? MyConvert.ConvertToString(value) : shoukuanshijian;
theValue = this.shoukuanshijian;
}
- else if ("Paytime".Equals(name, StringComparison.CurrentCultureIgnoreCase) || index == 34)
+ else if ("Paytime".Equals(name, StringComparison.CurrentCultureIgnoreCase) || index == 38)
{
this.Paytime = isChange ? MyConvert.ConvertToInt32(value) : Paytime;
theValue = this.Paytime;
}
- else if ("OrderId".Equals(name, StringComparison.CurrentCultureIgnoreCase) || index == 35)
+ else if ("OrderId".Equals(name, StringComparison.CurrentCultureIgnoreCase) || index == 39)
{
this.OrderId = isChange ? MyConvert.ConvertToInt32(value) : OrderId;
theValue = this.OrderId;
}
- else if ("YujihuikuanTime".Equals(name, StringComparison.CurrentCultureIgnoreCase) || index == 36)
+ else if ("YujihuikuanTime".Equals(name, StringComparison.CurrentCultureIgnoreCase) || index == 40)
{
this.YujihuikuanTime = isChange ? MyConvert.ConvertToDateTime(value) : YujihuikuanTime;
theValue = this.YujihuikuanTime;
}
- else if ("YujihuikuanKeyid".Equals(name, StringComparison.CurrentCultureIgnoreCase) || index == 36)
+ else if ("YujihuikuanKeyid".Equals(name, StringComparison.CurrentCultureIgnoreCase) || index == 41)
{
this.YujihuikuanKeyid = isChange ? MyConvert.ConvertToGuid(value) : YujihuikuanKeyid;
theValue = this.YujihuikuanKeyid;
}
- else if ("quyu".Equals(name, StringComparison.CurrentCultureIgnoreCase) || index == 37)
+ else if ("quyu".Equals(name, StringComparison.CurrentCultureIgnoreCase) || index == 42)
{
this.quyu = isChange ? MyConvert.ConvertToString(value) : quyu;
theValue = this.quyu;
}
- else if ("ContracttypeName".Equals(name, StringComparison.CurrentCultureIgnoreCase) || index == 38)
+ else if ("ContracttypeName".Equals(name, StringComparison.CurrentCultureIgnoreCase) || index == 43)
{
this.ContracttypeName = isChange ? MyConvert.ConvertToString(value) : ContracttypeName;
theValue = this.ContracttypeName;
}
- else if ("Contractmoney".Equals(name, StringComparison.CurrentCultureIgnoreCase) || index == 39)
+ else if ("Contractmoney".Equals(name, StringComparison.CurrentCultureIgnoreCase) || index == 44)
{
this.Contractmoney = isChange ? MyConvert.ConvertToDecimal(value) : Contractmoney;
theValue = this.Contractmoney;
}
- else if ("ExpiretypeName".Equals(name, StringComparison.CurrentCultureIgnoreCase) || index == 40)
+ else if ("ExpiretypeName".Equals(name, StringComparison.CurrentCultureIgnoreCase) || index == 45)
{
this.ExpiretypeName = isChange ? MyConvert.ConvertToString(value) : ExpiretypeName;
theValue = this.ExpiretypeName;
}
- else if ("ExpireTime".Equals(name, StringComparison.CurrentCultureIgnoreCase) || index == 41)
+ else if ("ExpireTime".Equals(name, StringComparison.CurrentCultureIgnoreCase) || index == 46)
{
this.ExpireTime = isChange ? MyConvert.ConvertToDateTime(value) : ExpireTime;
theValue = this.ExpireTime;
}
- else if ("gendanshuliang".Equals(name, StringComparison.CurrentCultureIgnoreCase) || index == 42)
+ else if ("gendanshuliang".Equals(name, StringComparison.CurrentCultureIgnoreCase) || index == 47)
{
this.gendanshuliang = isChange ? MyConvert.ConvertToDecimal(value) : gendanshuliang;
theValue = this.gendanshuliang;
}
- else if ("xinzengshuliang".Equals(name, StringComparison.CurrentCultureIgnoreCase) || index == 43)
+ else if ("xinzengshuliang".Equals(name, StringComparison.CurrentCultureIgnoreCase) || index == 48)
{
this.xinzengshuliang = isChange ? MyConvert.ConvertToDecimal(value) : xinzengshuliang;
theValue = this.xinzengshuliang;
}
- else if ("wanjieshuliang".Equals(name, StringComparison.CurrentCultureIgnoreCase) || index == 44)
+ else if ("wanjieshuliang".Equals(name, StringComparison.CurrentCultureIgnoreCase) || index == 49)
{
this.wanjieshuliang = isChange ? MyConvert.ConvertToDecimal(value) : wanjieshuliang;
theValue = this.wanjieshuliang;
}
- else if ("xiadanshuliang".Equals(name, StringComparison.CurrentCultureIgnoreCase) || index == 45)
+ else if ("xiadanshuliang".Equals(name, StringComparison.CurrentCultureIgnoreCase) || index == 50)
{
this.xiadanshuliang = isChange ? MyConvert.ConvertToDecimal(value) : xiadanshuliang;
theValue = this.xiadanshuliang;
}
- else if ("kaipiaojine".Equals(name, StringComparison.CurrentCultureIgnoreCase) || index == 46)
+ else if ("kaipiaojine".Equals(name, StringComparison.CurrentCultureIgnoreCase) || index == 51)
{
this.kaipiaojine = isChange ? MyConvert.ConvertToDecimal(value) : kaipiaojine;
theValue = this.kaipiaojine;
}
- else if ("huifangshuliang".Equals(name, StringComparison.CurrentCultureIgnoreCase) || index == 47)
+ else if ("huifangshuliang".Equals(name, StringComparison.CurrentCultureIgnoreCase) || index == 52)
{
this.huifangshuliang = isChange ? MyConvert.ConvertToDecimal(value) : huifangshuliang;
theValue = this.huifangshuliang;
}
- else if ("chaxuntime".Equals(name, StringComparison.CurrentCultureIgnoreCase) || index == 48)
+ else if ("chaxuntime".Equals(name, StringComparison.CurrentCultureIgnoreCase) || index == 53)
{
this.chaxuntime = isChange ? MyConvert.ConvertToDateTime(value) : chaxuntime;
theValue = this.chaxuntime;
}
- else if ("chaxuntimestart".Equals(name, StringComparison.CurrentCultureIgnoreCase) || index == 49)
+ else if ("chaxuntimestart".Equals(name, StringComparison.CurrentCultureIgnoreCase) || index == 54)
{
this.chaxuntimestart = isChange ? MyConvert.ConvertToDateTime(value) : chaxuntimestart;
theValue = this.chaxuntimestart;
}
- else if ("chaxuntimeend".Equals(name, StringComparison.CurrentCultureIgnoreCase) || index == 50)
+ else if ("chaxuntimeend".Equals(name, StringComparison.CurrentCultureIgnoreCase) || index == 55)
{
this.chaxuntimeend = isChange ? MyConvert.ConvertToDateTime(value) : chaxuntimeend;
theValue = this.chaxuntimeend;
}
- else if ("huikuankehu".Equals(name, StringComparison.CurrentCultureIgnoreCase) || index == 51)
+ else if ("huikuankehu".Equals(name, StringComparison.CurrentCultureIgnoreCase) || index == 56)
{
this.huikuankehu = isChange ? MyConvert.ConvertToDecimal(value) : huikuankehu;
theValue = this.huikuankehu;
}
- else if ("weihuikuankehu".Equals(name, StringComparison.CurrentCultureIgnoreCase) || index == 52)
+ else if ("weihuikuankehu".Equals(name, StringComparison.CurrentCultureIgnoreCase) || index == 57)
{
this.weihuikuankehu = isChange ? MyConvert.ConvertToDecimal(value) : weihuikuankehu;
theValue = this.weihuikuankehu;
}
+ else if ("CompanyName".Equals(name, StringComparison.CurrentCultureIgnoreCase) || index == 58)
+ {
+ this.CompanyName = isChange ? MyConvert.ConvertToString(value) : CompanyName;
+ theValue = this.CompanyName;
+ }
+ else if ("Deliveredstatus".Equals(name, StringComparison.CurrentCultureIgnoreCase) || index == 59)
+ {
+ this.Deliveredstatus = isChange ? MyConvert.ConvertToInt32(value) : Deliveredstatus;
+ theValue = this.Deliveredstatus;
+ }
+
+ else if ("TransferType".Equals(name, StringComparison.CurrentCultureIgnoreCase) || index == 60)
+ {
+ this.TransferType = isChange ? MyConvert.ConvertToInt32(value) : TransferType;
+ theValue = this.TransferType;
+ }
+
+ else if ("TransferName".Equals(name, StringComparison.CurrentCultureIgnoreCase) || index == 61)
+ {
+ this.TransferName = isChange ? MyConvert.ConvertToString(value) : TransferName;
+ theValue = this.TransferName;
+ }
+ else if ("DeliverPlanPaicheid".Equals(name, StringComparison.CurrentCultureIgnoreCase) || index == 62)
+ {
+ this.DeliverPlanPaicheid = isChange ? MyConvert.ConvertToGuid(value) : DeliverPlanPaicheid;
+ theValue = this.DeliverPlanPaicheid;
+ }
+
+ else if ("Wanjiestatus".Equals(name, StringComparison.CurrentCultureIgnoreCase) || index == 63)
+ {
+ this.Wanjiestatus = isChange ? MyConvert.ConvertToInt32(value) : Wanjiestatus;
+ theValue = this.Wanjiestatus;
+ }
+ else if ("WanjieTime".Equals(name, StringComparison.CurrentCultureIgnoreCase) || index == 64)
+ {
+ this.WanjieTime = isChange ? MyConvert.ConvertToDateTime(value) : WanjieTime;
+ theValue = this.WanjieTime;
+ }
+ else if ("Wanjieren".Equals(name, StringComparison.CurrentCultureIgnoreCase) || index == 65)
+ {
+ this.Wanjieren = isChange ? MyConvert.ConvertToString(value) : Wanjieren;
+ theValue = this.Wanjieren;
+ }
+ else if ("Zerenren".Equals(name, StringComparison.CurrentCultureIgnoreCase) || index == 66)
+ {
+ this.Zerenren = isChange ? MyConvert.ConvertToInt32(value) : Zerenren;
+ theValue = this.Zerenren;
+ }
+ else if ("ZerenrenName".Equals(name, StringComparison.CurrentCultureIgnoreCase) || index == 67)
+ {
+ this.ZerenrenName = isChange ? MyConvert.ConvertToString(value) : ZerenrenName;
+ theValue = this.ZerenrenName;
+ }
+ else if ("Fakuan".Equals(name, StringComparison.CurrentCultureIgnoreCase) || index == 68)
+ {
+ this.Fakuan = isChange ? MyConvert.ConvertToDecimal(value) : Fakuan;
+ theValue = this.Fakuan;
+ }
+ else if ("ZerenTime".Equals(name, StringComparison.CurrentCultureIgnoreCase) || index == 69)
+ {
+ this.ZerenTime = isChange ? MyConvert.ConvertToDateTime(value) : ZerenTime;
+ theValue = this.ZerenTime;
+ }
+ else if ("Zerenoperater".Equals(name, StringComparison.CurrentCultureIgnoreCase) || index == 70)
+ {
+ this.Zerenoperater = isChange ? MyConvert.ConvertToString(value) : Zerenoperater;
+ theValue = this.Zerenoperater;
+ }
+ else if ("OrAllUnPayedMoney".Equals(name, StringComparison.CurrentCultureIgnoreCase) || index == 71)
+ {
+ this.OrAllUnPayedMoney = isChange ? MyConvert.ConvertToDecimal(value) : OrAllUnPayedMoney;
+ theValue = this.OrAllUnPayedMoney;
+ }
+
--
Gitblit v1.9.1