public void Delete(OwnerDelayRecord t)
{
string sql = "DELETE FROM CBLprDelayRecord WHERE ID=@ID";
using (IDbConnection connection = DbConnectionFactory.Create())
{
connection.Execute(sql);
}
}
public void Update(OwnerDelayRecord t)
{
string sql = @"UPDATE CBLprDelayRecord SET LprUserName=@LprUserName
,LprUserPlate=@LprUserPlate
,StartTime=@StartTime
,StopTime=@StopTime
,ChargeAmount=@ChargeAmount
,Operator=@Operator
,RecordTime=@RecordTime WHERE ID=@ID;";
using (IDbConnection connection = DbConnectionFactory.Create())
{
connection.Execute(sql);
}
}
public int Add(OwnerDelayRecord t)
{
string sql = @"INSERT INTO CBLprDelayRecord(LprUserName
,LprUserPlate
,StartTime
,StopTime
,ChargeAmount
,Operator
,RecordTime) VALUES(@LprUserName
,@LprUserPlate
,@StartTime
,@StopTime
,@ChargeAmount
,@Operator
,@RecordTime);SELECT LAST_INSERT_ROWID();";
using (IDbConnection connection = DbConnectionFactory.Create())
{
return(connection.Query <int>(sql).FirstOrDefault());
}
}
