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); }