/// <summary>
/// 修改假期配置
/// </summary>
/// <param name="args">配置信息实体</param>
/// <returns>影响行数</returns>
public CustomResult Update(OT_HDayConfig model)
{
using (DataSubmittedEntities db = new DataSubmittedEntities())
{
using (TransactionScope transaction = new TransactionScope())
{
CustomResult pReturnValue = new CustomResult();
var list = db.OT_HDayConfig.Where(a => a.Id == model.Id).ToList();
if (list != null && list.Count > 0)
{
if (model.CheckFloat != null && model.CheckFloat > 0)
list[0].CheckFloat = model.CheckFloat;
if (model.CompEnd != null)
list[0].CompEnd = model.CompEnd;
if (model.CompStart != null)
list[0].CompStart = model.CompStart;
if (!string.IsNullOrEmpty(model.ConfigName))
list[0].ConfigName = model.ConfigName;
if (model.ForeDate != null)
list[0].ForeDate = model.ForeDate;
if (model.ForeFloat != null && model.ForeFloat > 0)
list[0].ForeFloat = model.ForeFloat;
if (model.HDayEnd != null)
list[0].HDayEnd = model.HDayEnd;
if (model.HDayId != null && model.HDayId > 0)
list[0].HDayId = model.HDayId;
if (model.HDayStart != null)
list[0].HDayStart = model.HDayStart;
if (!string.IsNullOrEmpty(model.RptRemark))
list[0].RptRemark = model.RptRemark;
pReturnValue = Result.SaveUpdateResult(db, transaction);
}
else
{
pReturnValue.ResultKey = (byte)EResult.IsNull1;
pReturnValue.ResultValue = Wttech.DataSubmitted.Common.Resources.TipInfo.Inexist;
}
return pReturnValue;
}
}
}
/// <summary>
/// 8.9.10数据源更新方法
/// </summary>
/// <param name="dt"></param>
/// <param name="HourPer"></param>
public void Update(DateTime dt, int HourPer)
{
try
{
string startTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
SystemLog.GetInstance().Log.Info(string.Format("{0}：开始获取8,9,10报表数据", startTime));
using (DataSubmittedEntities db = new DataSubmittedEntities())
{
DateTime plasttime = new DateTime();
List<OT_HDayConfig> pdayconfigs = db.OT_HDayConfig.Where(s => s.Id == 9).ToList();
OT_HDayConfig pdayconfig = new OT_HDayConfig();
if (pdayconfigs.Count > 0)
{
pdayconfig = pdayconfigs.First();
if (pdayconfig.HDayStart.HasValue && pdayconfig.HDayEnd.HasValue)
{
int ptemp = 0;
//判断当天是否在假期配置时间范围内
DateTime ptempdt = DateTime.Parse(dt.ToShortDateString());
if (ptempdt >= pdayconfig.HDayStart.Value && ptempdt <= pdayconfig.HDayEnd)
{
//间隔的天数
ptemp = (ptempdt - pdayconfig.HDayStart.Value).Days;
}
if (pdayconfig.CompStart.HasValue)
{
plasttime = pdayconfig.CompStart.Value.AddDays(ptemp);
}
}
}
List<RP_AADTSta> pOlds = db.RP_AADTSta.Where(s => s.CalculTime == plasttime).ToList();
//判断去年同期是否存在
RP_AADTSta oldinfo = new RP_AADTSta();
if (pOlds.Count > 0)
{
oldinfo = pOlds.First();
}
DateTime pdt = DateTime.Parse(dt.ToShortDateString());
//北京段包含出入口收费站
List<int> BJStation = StationConfiguration.GetBJStaion();
//北京段只包含出口收费站
List<int> outBJStation = StationConfiguration.GetOutBJStaion();
//获取北京段数据//p.VehType == 0 表示合计数据，
IEnumerable<DS_DataSource> pBJCollection = db.DS_DataSource.Where(p =>
DbFunctions.TruncateTime(p.CalcuTime) == DbFunctions.TruncateTime(dt)
&& p.VehType == 0
&& BJStation.Contains(p.StaID.Value));
//判断数据是否已存在
RP_AADTSta pAADTStaInfo = null;
List<RP_AADTSta> pList = db.RP_AADTSta.Where(p => p.CalculTime == pdt).ToList();
if (pList.Count > 0)//已存在，则更新
{
pAADTStaInfo = pList.FirstOrDefault();
pAADTStaInfo.UpdDate = DateTime.Now;
pAADTStaInfo.State = "1";
}
else//不存在，添加
{
pAADTStaInfo = new RP_AADTSta();
pAADTStaInfo.Id = Guid.NewGuid();
pAADTStaInfo.CrtDate = DateTime.Now;
pAADTStaInfo.State = "0";
}
//涉及到金额的单位全部转为万元，保留两位小数
//出京路线总交通量,不包括绿通
pAADTStaInfo.LineExSum = pBJCollection.Where(s => outBJStation.Contains(s.StaID.Value) && s.CalcuType != 3).Sum(s => s.InNum);
//入京路线总交通量，不包括绿通
pAADTStaInfo.LineEnSum = pBJCollection.Where(s => BJStation.Contains(s.StaID.Value) && s.CalcuType != 3).Sum(s => s.OutNum);
pAADTStaInfo.LineSum = pAADTStaInfo.LineEnSum + pAADTStaInfo.LineExSum;
//总交通量同比增幅
if (oldinfo.LineSum.HasValue)
{
pAADTStaInfo.SumGrow = double.Parse(string.Format("{0:0.00}", (pAADTStaInfo.LineSum - oldinfo.LineSum) / oldinfo.LineSum));
}
//出进京比
pAADTStaInfo.ExEnPer = double.Parse(string.Format("{0:0.00}", (pAADTStaInfo.LineExSum / pAADTStaInfo.LineEnSum)));
//收费/免征总金额
pAADTStaInfo.FeeSum = Math.Round(pBJCollection.Sum(s => s.RecMoney.Value) / 10000, 2);
//出京小型客车免费通行交通量
pAADTStaInfo.ExSmaCarFee = pBJCollection.Where(s => s.CalcuType == 0 && outBJStation.Contains(s.StaID.Value)).Sum(s => s.InNum);
//进京小型客车免费通行交通量
pAADTStaInfo.EnSmaCarFee = pBJCollection.Where(s => s.CalcuType == 0).Sum(s => s.OutNum);
//小型客车免费通行交通量（合计）
pAADTStaInfo.SmaCarFeeNum = pAADTStaInfo.ExSmaCarFee + pAADTStaInfo.EnSmaCarFee;
//小型客车交通量同比增幅
if (oldinfo.SmaCarFeeNum.HasValue)
{
pAADTStaInfo.SmaCarCompGrow = double.Parse(string.Format("{0:0.00}", (pAADTStaInfo.SmaCarFeeNum - oldinfo.SmaCarFeeNum) / oldinfo.SmaCarFeeNum));
}//小型客车免费金额
pAADTStaInfo.SmaCarFee = Math.Round(pBJCollection.Where(s => s.CalcuType.Value == 0).Sum(s => s.RecMoney.Value) / 10000, 2);
//出京收费车辆
pAADTStaInfo.ExChagNum = pBJCollection.Where(s => outBJStation.Contains(s.StaID.Value) && (s.CalcuType == 1 || s.CalcuType == 2)).Sum(s => s.InNum);
//进京收费车辆
pAADTStaInfo.EnChagNum = pBJCollection.Where(s => s.CalcuType == 1 || s.CalcuType == 2).Sum(s => s.OutNum);
//收费车辆合计
pAADTStaInfo.ChagSumNum = pAADTStaInfo.ExChagNum + pAADTStaInfo.EnChagNum;
//收费额度
pAADTStaInfo.ChagAmount = Math.Round(pBJCollection.Where(s => s.CalcuType == 1 || s.CalcuType == 2).Sum(s => s.RecMoney.Value) / 10000, 2);
//绿色通道车辆数
pAADTStaInfo.GreNum = pBJCollection.Where(s => s.CalcuType == 3).Sum(s => s.OutNum);
//绿色通道免收费金额
pAADTStaInfo.GreFee = Math.Round(pBJCollection.Where(s => s.CalcuType == 3).Sum(s => s.RecMoney.Value) / 10000, 2);
//出京总交通量（站）
pAADTStaInfo.StaExSum = pBJCollection.Where(s => s.StaID == (int)StationConfiguration.StationID.DYF).Sum(s => s.InNum);
//进京总交通量（站）
pAADTStaInfo.StaEnSum = pBJCollection.Where(s => s.StaID == (int)StationConfiguration.StationID.DYF).Sum(s => s.OutNum);
pAADTStaInfo.CalculTime = pdt;
using (TransactionScope trans = new TransactionScope())
{
if (pList.Count <= 0)
db.RP_AADTSta.Add(pAADTStaInfo);
db.SaveChanges();
trans.Complete();
}
}
string endTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
SystemLog.GetInstance().Log.Info(string.Format("{0}：结束获取8,9,10报表数据", endTime));
SystemLog.GetInstance().Log.Info(string.Format("统计8,9,10报表数据耗时{0}秒", (DateTime.Parse(endTime) - DateTime.Parse(startTime)).TotalSeconds));
//显示执行该方法的线程ID
//SystemLog.GetInstance().Log.Info(string.Format("调用8,9,10Update的线程ID为：{0}", Thread.CurrentThread.ManagedThreadId));
Thread.Sleep(1000);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 获取或更新报表11,12源数据
/// </summary>
/// <param name="dt"></param>
/// <param name="HourPer"></param>
public void Update(DateTime dt, int HourPer)
{
try
{
string startTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
SystemLog.GetInstance().Log.Info(string.Format("{0}：开始获取11,12报表数据", startTime));
using (DataSubmittedEntities db = new DataSubmittedEntities())
{
//获取报表12配置的假期信息
List<OT_HDayConfig> pdayconfigs = db.OT_HDayConfig.Where(s => s.Id == 12).ToList();
OT_HDayConfig pdayconfig = new OT_HDayConfig();
if (pdayconfigs.Count > 0)
{
pdayconfig = pdayconfigs.First();
}
DateTime pDt = DateTime.Parse(dt.ToShortDateString());
//报表11,12收费站
List<int> TJStation = StationConfiguration.GetStaionList();
//获取今年当日数据//p.VehType == 0 表示合计数据，
IEnumerable<DS_DataSource> pCollection = db.DS_DataSource.Where(p =>
DbFunctions.TruncateTime(p.CalcuTime) == DbFunctions.TruncateTime(dt)
&& p.VehType == 0 && TJStation.Contains(p.StaID.Value));
//今年数据
IEnumerable<DS_DataSource> pHdayCollection = db.DS_DataSource.Where(p =>
(DbFunctions.TruncateTime(p.CalcuTime) <= pdayconfig.HDayEnd.Value
&& DbFunctions.TruncateTime(p.CalcuTime) >= pdayconfig.HDayStart.Value)
&& p.VehType == 0 && TJStation.Contains(p.StaID.Value));
//每日数据
List<RP_HDayAADT> pList = db.RP_HDayAADT.Where(p => p.CalcuTime == pDt).ToList();
RP_HDayAADT pAADTInfo = null;
bool pIsHas = false;
if (pList.Count > 0)
{
pAADTInfo = pList.FirstOrDefault();
pIsHas = true;
}
else
{
pAADTInfo = new RP_HDayAADT();
}
//更新实体
UpdateInfo(pCollection, pAADTInfo, pDt, pIsHas, pHdayCollection);
using (TransactionScope transaction = new TransactionScope())
{
//如果不存在，则添加，否则则更新
if (!pIsHas)
db.RP_HDayAADT.Add(pAADTInfo);
db.SaveChanges();
transaction.Complete();
}
}
string endTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
SystemLog.GetInstance().Log.Info(string.Format("{0}：结束获取11,12报表数据", endTime));
SystemLog.GetInstance().Log.Info(string.Format("统计11,12报表数据耗时{0}秒", (DateTime.Parse(endTime) - DateTime.Parse(startTime)).TotalSeconds));
//显示执行该方法的线程ID
//SystemLog.GetInstance().Log.Info(string.Format("调用11,12Update的线程ID为：{0}", Thread.CurrentThread.ManagedThreadId));
Thread.Sleep(1000);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 修改配置信息
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public CustomResult UpdateConfig(HolidayConfigViewModel model)
{
OT_HDayConfig modelHC = new OT_HDayConfig();
modelHC.CheckFloat = model.CheckFloat;
modelHC.CompEnd = model.ComparedEndTime;
modelHC.CompStart = model.ComparedStartTime;
modelHC.ConfigName = model.ConfigName;
modelHC.ForeDate = model.ForecastDate;
modelHC.ForeFloat = model.ForecastFloat;
modelHC.Id = model.HolidayConfigId;
modelHC.HDayEnd = model.HolidayEndTime;
modelHC.HDayId = model.HolidayId;
modelHC.HDayStart = model.HolidayStartTime;
modelHC.RptRemark = model.ReportRemark;
return holidayConfig.Update(modelHC);
}
/// <summary>
/// 获取同期流量
/// </summary>
/// <param name="dt">数据日期</param>
/// <returns></returns>
public double? GetSameSum(DateTime dt)
{
double? pSameSum = null;
using (DataSubmittedEntities db = new DataSubmittedEntities())
{
DateTime plasttime = new DateTime();
//获取报表12配置的假期同期
List<OT_HDayConfig> pdayconfigs = db.OT_HDayConfig.Where(s => s.Id == 12).ToList();
OT_HDayConfig pdayconfig = new OT_HDayConfig();
if (pdayconfigs.Count > 0)
{
pdayconfig = pdayconfigs.First();
if (pdayconfig.HDayStart.HasValue && pdayconfig.HDayEnd.HasValue)
{
int ptemp = 0;
//判断当天是否在假期配置时间范围内
DateTime ptempdt = DateTime.Parse(dt.ToShortDateString());
if (ptempdt >= pdayconfig.HDayStart.Value && ptempdt <= pdayconfig.HDayEnd)
{
//间隔的天数
ptemp = (ptempdt - pdayconfig.HDayStart.Value).Days;
}
if (pdayconfig.CompStart.HasValue)
{
plasttime = pdayconfig.CompStart.Value.AddDays(ptemp);
}
}
}
List<RP_HDayAADT> pOlds = db.RP_HDayAADT.Where(s => s.CalcuTime <= plasttime && s.CalcuTime >= pdayconfig.CompStart.Value).ToList();
pSameSum = pOlds.Sum(s => s.Sum.Value);
}
return pSameSum;
}
