public void InsertTradeHistory(Table.TblTrade tblTrade, TcpMsg.TradeStatus status, Int64 buyeruuid, string buyernickName) { var repoTrade = TCGGameSrv.IocContainer.Resolve <Repository.ITrading>(); if (!repoTrade.TradeDelete(tblTrade.seq)) { logger.Warn($"Trade Delete fail seq={tblTrade.seq} status={status.ToString()}"); } else { var tblTradeHistory = new Table.TblTradeHistory() { seller_uuid = tblTrade.uuid, seller_nickname = tblTrade.nickname, buyer_uuid = buyeruuid, buyer_nickname = buyernickName, tokenid = $"{tblTrade.tokentype}{tblTrade.tokenidx}", cardid = tblTrade.cardid, tokenidxnum = tblTrade.tokenidxnum, sale_price = tblTrade.sale_price, status = (Int32)status, comment = tblTrade.comment, regdate = DateTime.Now }; tblTradeHistory.seq = repoTrade.HistoryInsert(tblTradeHistory); } }
public bool TradeUpdate(Int64 seq, TcpMsg.TradeStatus setstatus, TcpMsg.TradeStatus wherestatus) { Int32 ret = 0; using (IDbConnection conn = Database.GetDbConnection()) { string qry = $"update {Table.TblTrade.Name} set status=@SETSTATUS where seq=@SEQ and status=@WHERESTATUS;"; ret = conn.Execute(qry, new { SETSTATUS = (Int32)setstatus, SEQ = seq, WHERESTATUS = (Int32)wherestatus }); } return(ret > 0); }
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); }
public Table.TblTrade GetTradeGoods(Int64 seq, TcpMsg.TradeStatus status = TcpMsg.TradeStatus.None) { var repoTrading = TCGGameSrv.IocContainer.Resolve <Repository.ITrading>(); return(repoTrading.GetTblTradeSeq(seq, status)); }