IA.Data/FuelConsumptionData.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Text;
using IA.Core.Domain;
using IA.Data.EF;
using IA.Data.Ioc;
using IA.Models;
using IA.Models.Common;

namespace IA.Data
{
    public class FuelConsumptionData : EfBaseData
    {
        /// <summary>燃油消耗列表
        /// </summary>
        /// <param name="productNo">出厂编号</param>
        /// <param name="endTime"></param>
        /// <param name="pageIndex"></param>
        /// <param name="pageSize"></param>
        /// <param name="equipmentNum"></param>
        /// <param name="startTime"></param>
        /// <returns></returns>
        public PageResult<FuelConsumptionModel> GetList(string productNo, string equipmentNum, string startTime, string endTime, int pageIndex, int pageSize)
        {
            using (var vPersistance = IOCContainer.Get<IEfPersistance>())
            {
                var sqlText = @"SELECT [id], 
                                       [productno],
                                       a.[AgriculModel],
                                       a.[EquipmentNum], 
                                       a.statisticsdatetime, 
                                       [workingaarea], 
                                       [workingoil], 
                                       [proportion],
                                       b.[hisworkingaarea], 
                                       b.[hisworkingoil], 
                                       b.[hisproportion], 
                                       [createutc] 
                                FROM   [dbo].[fuelconsumption] a 
                                       JOIN(SELECT [EquipmentNum], 
                                                   Max([statisticsdatetime])StatisticsDateTime, 
                                                   Sum([workingaarea])      [hisworkingaarea], 
                                                   Sum([workingoil])        [HisWorkingOil], 
                                                   ( CASE 
                                                       WHEN Sum([workingaarea]) = 0 THEN 0 
                                                       ELSE Sum([workingoil]) / Sum([workingaarea]) 
                                                     END )                  [HisProportion] 
                                            FROM   [dbo].[fuelconsumption] 
                                            WHERE  1=1 {0}
                                            GROUP  BY [EquipmentNum]) b 
                                         ON a.EquipmentNum = b.EquipmentNum 
                                            AND a.statisticsdatetime = b.statisticsdatetime ";

                var conditionText = new StringBuilder();
                if (!string.IsNullOrWhiteSpace(productNo))
                {
                    conditionText.AppendFormat(" AND ProductNo LIKE '%{0}%'", productNo);
                }
                if (!string.IsNullOrWhiteSpace(equipmentNum))
                {
                    conditionText.AppendFormat(" AND EquipmentNum like '%{0}%'", equipmentNum);