private static ParkDeviceDetection GetParkDeviceDetectionModel(ParkDevice device)
{
ParkDeviceDetection model = new ParkDeviceDetection();
model.RecordID = GuidGenerator.GetGuid().ToString();
model.DeviceID = device.DeviceID;
model.ConnectionState = 0;
IParkGate factory = ParkGateFactory.GetFactory();
model.PKID = factory.QueryParkingIdByGateId(device.GateID);
if (string.IsNullOrWhiteSpace(model.PKID))
{
throw new MyException("获取车场编号失败");
}
return(model);
}
public bool Add(ParkDeviceDetection model, DbOperator dbOperator)
{
model.DataStatus = (int)DataStatus.Normal;
model.LastUpdateTime = DateTime.Now;
model.HaveUpdate = SystemDefaultConfig.DataUpdateFlag;
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into ParkDeviceDetection(RecordID,DeviceID,PKID,ConnectionState,DisconnectTime,DataStatus,LastUpdateTime,HaveUpdate)");
strSql.Append(" values(@RecordID,@DeviceID,@PKID,@ConnectionState,@DisconnectTime,@DataStatus,@LastUpdateTime,@HaveUpdate)");
dbOperator.ClearParameters();
dbOperator.AddParameter("RecordID", model.RecordID);
dbOperator.AddParameter("DeviceID", model.DeviceID);
dbOperator.AddParameter("PKID", model.PKID);
dbOperator.AddParameter("ConnectionState", model.ConnectionState);
dbOperator.AddParameter("DisconnectTime", model.DisconnectTime);
dbOperator.AddParameter("LastUpdateTime", model.LastUpdateTime);
dbOperator.AddParameter("HaveUpdate", model.HaveUpdate);
dbOperator.AddParameter("DataStatus", (int)model.DataStatus);
return(dbOperator.ExecuteNonQuery(strSql.ToString()) > 0);
}
