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 /// /// 按车号查询状态为未使用或使用中的计量实绩数据 /// /// /// public RESTfulResult> doQueryByFlag(MeterWorkCarActualFirst info) { DbHelper db = new DbHelper(); info.pageNum = 1; info.pageSize = 3; RESTfulResult> result = db.doOption>("meterworkcaractualfirsts", "/queryByFlag", new object[] { info }, 1); return result; } #endregion internal RESTfulResult> doQueryWf(MeterWorkCarActualFirst info) { DbHelper db = new DbHelper(); RESTfulResult>> rm = db.doOption>>("meterworkcaractualfirsts", "/", new object[] { info }, 0); List lt = new List(); //如果一次数据在当前过期时间外,则将数据设置为失效状态 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> result = new RESTfulResult>(); 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; } /// /// 修改 /// /// /// public RESTfulResult doUpdateWf(MeterWorkCarActualFirst info) { DbHelper db = new DbHelper(); RESTfulResult rm = db.doOption("meterworkcaractualfirsts", "doUpdateWf", new object[] { info }, 1); return rm; } } }