SQL to LINQ Conversion: Calculate Charging Capacity by Year, Month, and Day

var ChargeCapacityYear = (from c0 in Charging_Order\n join e1 in Equipment_ChargingGunsInfo on c0.ChargingGunId equals e1.Id\n join e2 in Equipment_ChargingPileInfo on e1.ChargingPileId equals e2.Id\n where !c0.Deleted && !e1.Deleted && e1.IsEnable && !e2.Deleted && e2.IsEnable && e2.EnterpriseId == "1638003434462388224" && c0.ChargingBeginTime >= __startTimeYear_1 && c0.ChargingBeginTime <= __endTimeYear_2\n select (double?)c0.ChargeCapacity ?? 0.0).Sum();\n\nvar ChargeCapacityMonth = (from c1 in Charging_Order\n join e3 in Equipment_ChargingGunsInfo on c1.ChargingGunId equals e3.Id\n join e4 in Equipment_ChargingPileInfo on e3.ChargingPileId equals e4.Id\n where !c1.Deleted && !e3.Deleted && e3.IsEnable && !e4.Deleted && e4.IsEnable && e4.EnterpriseId == "1638003434462388224" && c1.ChargingBeginTime >= __startTimeMonth_3 && c1.ChargingBeginTime <= __endTimeMonth_4\n select (double?)c1.ChargeCapacity ?? 0.0).Sum();\n\nvar ChargeCapacityDay = (from c2 in Charging_Order\n join e5 in Equipment_ChargingGunsInfo on c2.ChargingGunId equals e5.Id\n join e6 in Equipment_ChargingPileInfo on e5.ChargingPileId equals e6.Id\n where !c2.Deleted && !e5.Deleted && e5.IsEnable && !e6.Deleted && e6.IsEnable && e6.EnterpriseId == "1638003434462388224" && c2.ChargingBeginTime >= __startTimeDay_5 && c2.ChargingBeginTime <= __endTimeDay_6\n select (double?)c2.ChargeCapacity ?? 0.0).Sum();\n\nvar result = new { ChargeCapacityYear, ChargeCapacityMonth, ChargeCapacityDay };