using com.hnshituo.core.webapp.vo; using System; using System.Collections.Generic; using System.Data; namespace Common { public class MeterWorkCarActualService { private Log lg = Log.GetInstance(); //写日志 /// /// 查询一次该车最近的3条计量历史数据 /// /// public RESTfulResult doQueryWf(CommonPage cpc) { try { DbHelper db = new DbHelper(); cpc.pageNum = 1; if (cpc.pageSize == 0) cpc.pageSize = 10; RESTfulResult>> rm = db.doOption>>("meterworkcaractuals", "doQueryWf", new object[] { cpc }, 1); 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 (rm.Succeed && rm.Data != null && rm.Data.list != null && rm.Data.list.Count > 0) { result.Data = rm.Data.list.ListToDataTable(); } else { result.Data = new DataTable(); } return result; } catch (Exception ex) { lg.WriteLog(13, "查询计量实绩信息异常MeterWorkCarActualService/doQueryWf,车号【" + cpc.param.carNo + "】!异常信息:" + ex); return null; } } /// /// 查询当前预报最近的1条数据 /// /// /// public RESTfulResult> doQueryOneWf(CommonPage cpc) { try { DbHelper db = new DbHelper(); cpc.pageNum = 1; if (cpc.pageSize == 0) cpc.pageSize = 1; RESTfulResult>> rm = db.doOption>>("meterworkcaractuals", "doQueryWf", new object[] { cpc }, 1); RESTfulResult> result = new RESTfulResult>(); result.Succeed = rm.Succeed; result.Status = rm.Status; result.Message = rm.Message; result.ResultMessage = rm.ResultMessage; result.Code = rm.Code; result.Data = rm.Data?.list; return result; } catch (Exception ex) { lg.WriteLog(13, "查询计量实绩信息异常MeterWorkCarActualService/doQueryOneWf,车号【" + cpc.param.carNo + "】!异常信息:" + ex); return null; } } //多条件模糊查询 自带自定义状态 public RESTfulResult> doQueryAndMultiple(CommonPage info) { DbHelper db = new DbHelper(); RESTfulResult> rm = db.doOption>("meterworkcaractuals", "doQueryAndMultiple", new object[] { info }, 1); return rm; } #region JISCO接口 /// /// 结净 /// /// MeterWorkCarActualFirst /// MeterWorkCarActual /// 0 不保存历史皮,1保存历史皮 /// public RESTfulResult doAddNet(MeterWorkCarActualFirst onceDb, MeterWorkCarActualFirst secondDb, MeterWorkCarActual netDb, MeterMonitorNote monitorNote, string saveTare) { DbHelper db = new DbHelper(); PbSomeModel pbSomeModel = new PbSomeModel(); pbSomeModel.one = secondDb; pbSomeModel.two = netDb; pbSomeModel.sOne = saveTare; pbSomeModel.four = monitorNote; if (secondDb != null && string.IsNullOrEmpty(secondDb.createManNo)) { secondDb.createManNo = secondDb.baseSpotNo; secondDb.createManName = secondDb.baseSpotName; } //RESTfulResult rm = db.doOption("meterworkcaractualfirsts", "doAddNetInnerWf", new object[] { secondDb, netDb, saveTare }, 1); RESTfulResult rm = db.doOption("meterworkcaractualfirsts", "doAddNetInnerWf", new object[] { pbSomeModel }, 1); return rm; } /// /// 混装混卸逻辑 /// /// MeterWorkCarActualFirst /// 混装混卸中,自动新增的一次计量数据 /// MeterWorkCarActual /// 0 不保存历史皮,1保存历史皮 /// public RESTfulResult doAddNetHZHX(MeterWorkCarActualFirst secondDb, MeterWorkCarActualFirst secondDb2, MeterWorkCarActual netDb, MeterMonitorNote monitorNote, string saveTare) { DbHelper db = new DbHelper(); PbSomeModel pbSomeModel = new PbSomeModel(); pbSomeModel.one = secondDb; pbSomeModel.two = netDb; pbSomeModel.three = secondDb2; pbSomeModel.sOne = saveTare; pbSomeModel.four = monitorNote; if (secondDb != null && string.IsNullOrEmpty(secondDb.createManNo)) { secondDb.createManNo = secondDb.baseSpotNo; secondDb.createManName = secondDb.baseSpotName; } //RESTfulResult rm = db.doOption("meterworkcaractualfirsts", "doAddNetInnerWf", new object[] { secondDb, netDb, saveTare }, 1); RESTfulResult rm = db.doOption("meterworkcaractualfirsts", "doAddNetHZHX", new object[] { pbSomeModel }, 1); return rm; } /// /// 双委托逻辑 /// /// List /// 双委托中,自动新增的一次计量数据 /// MeterWorkCarActual /// public RESTfulResult doNetAddTwo(List scale, MeterWorkCarActualFirst actualFirst, MeterWorkCarActual netDb) { DbHelper db = new DbHelper(); PbSomeModel pbSomeModel = new PbSomeModel(); pbSomeModel.one = actualFirst; pbSomeModel.two = netDb; pbSomeModel.three = scale[0]; pbSomeModel.four = scale[1]; if (actualFirst != null && string.IsNullOrEmpty(actualFirst.createManNo)) { actualFirst.createManNo = actualFirst.baseSpotNo; actualFirst.createManName = actualFirst.baseSpotName; } //RESTfulResult rm = db.doOption("meterworkcaractualfirsts", "doAddNetInnerWf", new object[] { secondDb, netDb, saveTare }, 1); RESTfulResult rm = db.doOption("meterworkcaractualfirsts", "doNetAddTwo", new object[] { pbSomeModel }, 1); return rm; } #endregion } }