public void Execute(IdentificationInfo iInfo, EnteranceRecord eRecord, OwnerInfo oInfo)
{
if (eRecord == null && oInfo == null)
{
PlateInfoCallBack();
return;
}
else
{
string userType = "临时车辆";
int day = 255;
bool openTheDoor = true;
bool charges = true;
IChargesRecordService chargesRecordService = BLL.Container.Container.Resolve <IChargesRecordService>();
IEnumerable <ChargesRecord> chargesRecords = chargesRecordService.Query(iInfo.LicensePlateNumber, DateTime.Today);
double money = chargesRecords.Sum(e => e.ChargeAmount);
if (oInfo != null)
{
charges = false;
if (oInfo.PlateType == 0) //月租车辆
{
userType = "月租车辆";
day = SurplusDays(oInfo.StopTime);
if (day == 0)
{
//过期
userType += "（过期）";
charges = true;
}
//开门
}
else if (oInfo.PlateType == 1)//固定车辆
{
userType = "固定车辆";
}
else if (oInfo.PlateType == 2) //定距卡车辆
{
userType = "定距卡车辆";
}
if (oInfo.UserType == 1) //黑名单
{
//不开门
userType += "（黑名单）";
openTheDoor = false;
}
}
if (openTheDoor)
{
}
else
{
}
}
PlateInfoCallBack();
}
public void Update(EnteranceRecord t)
{
string sql = "UPDATE CBEnteranceRecrd SET PlateNumber=@PlateNumber,EntranceTime=@EntranceTime,VehicleType=@VehicleType WHERE ID = @ID";
using (IDbConnection connection = DbConnectionFactory.Create())
{
connection.Execute(sql);
}
}
public void Delete(EnteranceRecord t)
{
string sql = "DELETE FROM CBEnteranceRecrd WHERE ID =@ID;";
using (IDbConnection connection = DbConnectionFactory.Create())
{
connection.Execute(sql);
}
}
public int Add(EnteranceRecord t)
{
string sql = "INSERT INTO CBEnteranceRecrd(PlateNumber,EntranceTime,VehicleType) VALUES(@PlateNumber,@EntranceTime,@VehicleType); SELECT LAST_INSERT_ROWID(); ";
using (IDbConnection connection = DbConnectionFactory.Create())
{
return(connection.Query <int>(sql).FirstOrDefault());
}
}
public void Execute(IdentificationInfo iInfo, EnteranceRecord eRecord, OwnerInfo oInfo)
{
string userType = "临时车辆";
int day = 255;
bool openTheDoor = true;
if (oInfo != null)
{
if (oInfo.PlateType == 0) //月租车辆
{
userType = "月租车辆";
day = SurplusDays(oInfo.StopTime);
if (day == 0)
{
//过期
userType += "（过期）";
openTheDoor = false;
}
//开门
}
else if (oInfo.PlateType == 1)//固定车辆
{
userType = "固定车辆";
}
else if (oInfo.PlateType == 2) //定距卡车辆
{
userType = "定距卡车辆";
}
if (oInfo.UserType == 1) //黑名单
{
//不开门
userType += "（黑名单）";
openTheDoor = false;
}
}
else
{
openTheDoor = false;
}
OpenTheDoor(iInfo.LicensePlateNumber, iInfo.IdentificationTime, openTheDoor);
PlateInfoCallBack();
}
public void Execute(IdentificationInfo iInfo)
{
bool ret = Compared(iInfo.LicensePlateNumber, iInfo.IdentificationTime);
if (ret)
{
return;
}
//获取入场的信息
IEnteranceRecordService enteranceRecordService = BLL.Container.Container.Resolve <IEnteranceRecordService>();
EnteranceRecord enteranceRecord = enteranceRecordService.Query(iInfo.LicensePlateNumber);
//获取车主信息
IOwnerInfoService ownerInfoService = BLL.Container.Container.Resolve <IOwnerInfoService>();
OwnerInfo ownerInfo = ownerInfoService.Query(iInfo.LicensePlateNumber);
ExitDoor.Execute(iInfo, enteranceRecord, ownerInfo);
}
public void Execute(IdentificationInfo iInfo)
{
bool ret = Compared(iInfo.LicensePlateNumber, iInfo.IdentificationTime);
if (ret)
{
return;
}
IEnteranceRecordService enteranceRecordService = BLL.Container.Container.Resolve <IEnteranceRecordService>();
EnteranceRecord enteranceRecord = null;
OwnerInfo ownerInfo = null;
ChargesRecord chargeRecord = null;
try
{
if (iInfo.LicensePlateNumber != "ABCDEF")
{
enteranceRecord = enteranceRecordService.Query(iInfo.LicensePlateNumber);
//获取车主信息
IOwnerInfoService ownerInfoService = BLL.Container.Container.Resolve <IOwnerInfoService>();
ownerInfo = ownerInfoService.Query(iInfo.LicensePlateNumber);
//获取车辆记录中修改的车辆类型 大车 中车 小车
IChargesRecordService chargeRecordService = BLL.Container.Container.Resolve <IChargesRecordService>();
chargeRecord = chargeRecordService.Query(iInfo.LicensePlateNumber);
}
EnterDoor.Execute(iInfo, ownerInfo);
}
finally
{
try
{
if (enteranceRecord == null)
{
int vehicleType = 0;
if (iInfo.LicensePlateType == LicensePlateTypes.LT_YELLOW || iInfo.LicensePlateType == LicensePlateTypes.LT_YELLOW2)
{
vehicleType = 2;
}
if (chargeRecord != null)
{
if (vehicleType != chargeRecord.VehicleType)
{
vehicleType = chargeRecord.VehicleType;
}
}
enteranceRecord = new EnteranceRecord(iInfo.LicensePlateNumber, iInfo.IdentificationTime, vehicleType);
enteranceRecordService.Add(enteranceRecord);
}
else
{
enteranceRecord.EntranceTime = iInfo.IdentificationTime;
enteranceRecordService.Update(enteranceRecord);
}
}
catch (Exception ex)
{
Log.Error(ex.Message, ex);
}
}
}
