jisco_winform_wzjl/CarLocalMeter/DbOption/MeterWorkCarActualFirstService.cs

using com.hnshituo.core.webapp.vo;
using CoreFS.CA06;
using iCore.Rtdb;
using System;
using System.Collections;
using System.Collections.Generic;
using System.Linq;

namespace CarLocalMeter
{
    public class MeterWorkCarActualFirstService
    {
        #region JISCO特殊接口 By BourneCao 20220122
        /// <summary>
        /// 按车号查询状态为未使用或使用中的计量实绩数据
        /// </summary>
        /// <param name="info"></param>
        /// <returns></returns>
        public RESTfulResult<List<MeterWorkCarActualFirst>> doQueryByFlag(MeterWorkCarActualFirst info)
        {
            DbHelper db = new DbHelper();
            info.pageNum = 1;
            info.pageSize = 3;
            RESTfulResult<List<MeterWorkCarActualFirst>> result = db.doOption<List<MeterWorkCarActualFirst>>("meterworkcaractualfirsts", "/queryByFlag", new object[] { info }, 1);
            return result;
        }
        #endregion

        internal RESTfulResult<List<MeterWorkCarActualFirst>> doQueryWf(MeterWorkCarActualFirst info)
        {
            DbHelper db = new DbHelper();
            RESTfulResult<PageList<List<MeterWorkCarActualFirst>>> rm = db.doOption<PageList<List<MeterWorkCarActualFirst>>>("meterworkcaractualfirsts", "/", new object[] { info }, 0);

            List<MeterWorkCarActualFirst> lt = new List<MeterWorkCarActualFirst>();
            //如果一次数据在当前过期时间外，则将数据设置为失效状态
            if (rm.Succeed)
            {
                DateTime dtNow = DateTime.Now;
                if (rm.Data.list.Count > 0)
                {
                    foreach (MeterWorkCarActualFirst meter in rm.Data.list)
                    {
                        if (meter.createTime.Value.AddHours(AppConfigCache.isEndHour).CompareTo(dtNow) < 0)
                        {
                            doUpdateWf(new MeterWorkCarActualFirst { actualFirstNo = meter.actualFirstNo, valueFlag = "0", updateTime = dtNow, updateManName = "超期未使用" });
                        }
                        else
                        {
                            lt.Add(meter);
                        }
                    }
                }
            }

            RESTfulResult<List<MeterWorkCarActualFirst>> result = new RESTfulResult<List<MeterWorkCarActualFirst>>();
            result.Succeed = rm.Succeed;
            result.Status = rm.Status;
            result.Message = rm.Message;
            result.ResultMessage = rm.ResultMessage;
            result.Code = rm.Code;
            if (lt != null && lt.Count > 0)
            {
                result.Data = rm.Data.list;
            }

            return result;
        }

        /// <summary>
        /// 修改
        /// </summary>
        /// <param name="info"></param>
        /// <returns></returns>
        public RESTfulResult<string> doUpdateWf(MeterWorkCarActualFirst info)
        {
            DbHelper db = new DbHelper();
            RESTfulResult<string> rm = db.doOption<string>("meterworkcaractualfirsts", "doUpdateWf", new object[] { info }, 1);
            return rm;
        }
    }    
}