public long TradeInsert(Table.TblTrade TblTrade)
{
long ret = 0;
using (IDbConnection conn = Database.GetDbConnection())
ret = Dapper.Contrib.Extensions.SqlMapperExtensions.Insert(conn, TblTrade);
return(ret);
}
public bool TradeDelete(Table.TblTrade TblTrade)
{
bool ret = false;
using (IDbConnection conn = Database.GetDbConnection())
{
ret = Dapper.Contrib.Extensions.SqlMapperExtensions.Delete(conn, TblTrade);
}
return(ret);
}
public Table.TblTrade GetTblTradeSeq(Int64 seq, TcpMsg.TradeStatus status = TcpMsg.TradeStatus.None)
{
Table.TblTrade ret = null;
using (IDbConnection conn = Database.GetDbConnection())
{
string where = string.Empty;
if (status != TcpMsg.TradeStatus.None)
{
where = $"seq = {seq} and status = {(Int32)status}";
}
else
{
where = $"seq = {seq}";
}
string qry = $"select * from {Table.TblTrade.Name} where {where};";
ret = Dapper.SqlMapper.Query <Table.TblTrade>(conn, qry).FirstOrDefault();
}
return(ret);
}
