转Linq：SET startTimeYear = TIMESTAMP 2023-01-01 000000;SET endTimeYear = TIMESTAMP 2023-12-31 235959999999;SET startTimeMonth = TIMESTAMP 2023-07-01 000000;SET endTimeMonth = TIMESTAMP 2023-07-31 23595

var startTimeYear = new DateTime(2023, 1, 1, 0, 0, 0); var endTimeYear = new DateTime(2023, 12, 31, 23, 59, 59, 999); var startTimeMonth = new DateTime(2023, 7, 1, 0, 0, 0); var endTimeMonth = new DateTime(2023, 7, 31, 23, 59, 59, 999); var startTimeDay = new DateTime(2023, 7, 4, 0, 0, 0); var endTimeDay = new DateTime(2023, 7, 4, 23, 59, 59, 999);

var chargeCapacityYear = ( from c0 in Charging_Order join e1 in Equipment_ChargingGunsInfo on c0.ChargingGunId equals e1.Id join e2 in Equipment_ChargingPileInfo on e1.ChargingPileId equals e2.Id where !c0.Deleted && !e1.Deleted && e1.IsEnable && !e2.Deleted && e2.IsEnable && e2.EnterpriseId == "1638003434462388224" && c0.ChargingBeginTime >= startTimeYear && c0.ChargingBeginTime <= endTimeYear select (double?)c0.ChargeCapacity ?? 0.0 ).Sum();

var chargeCapacityMonth = ( from c1 in Charging_Order join e3 in Equipment_ChargingGunsInfo on c1.ChargingGunId equals e3.Id join e4 in Equipment_ChargingPileInfo on e3.ChargingPileId equals e4.Id where !c1.Deleted && !e3.Deleted && e3.IsEnable && !e4.Deleted && e4.IsEnable && e4.EnterpriseId == "1638003434462388224" && c1.ChargingBeginTime >= startTimeMonth && c1.ChargingBeginTime <= endTimeMonth select (double?)c1.ChargeCapacity ?? 0.0 ).Sum();

var chargeCapacityDay = ( from c2 in Charging_Order join e5 in Equipment_ChargingGunsInfo on c2.ChargingGunId equals e5.Id join e6 in Equipment_ChargingPileInfo on e5.ChargingPileId equals e6.Id where !c2.Deleted && !e5.Deleted && e5.IsEnable && !e6.Deleted && e6.IsEnable && e6.EnterpriseId == "1638003434462388224" && c2.ChargingBeginTime >= startTimeDay && c2.ChargingBeginTime <= endTimeDay select (double?)c2.ChargeCapacity ?? 0.0 ).Sum();

var result = new { ChargeCapacityYear = chargeCapacityYear, ChargeCapacityMonth = chargeCapacityMonth, ChargeCapacityDay = chargeCapacityDay }