private void GetData() { DBHelper helper = null; helper = new DBHelper(_conStrPortalDbRoot); DataTable dt; long accID = 0; var query = ""; if (_id > 0) { var account = AgencyDAO.GetById(_id); if (UserContext.UserInfo.GroupID == 0) { if (account != null) { if (account.IsAgency == true) { accID = account.ID; } } } else { if (account != null) { if (account.IsAgency == true) { var agencyInfo = TransactionDAO.GetAgencyInfo(account.GameAccountId); if (agencyInfo != null && agencyInfo.Creator == UserContext.UserInfo.AccountID) { accID = account.GameAccountId; } } } } } else { var agency = AgencyDAO.GetById(UserContext.UserInfo.AccountID); accID = agency.GameAccountId; } if (_type == 0) { query = $"select top 1000 * from ag.[Transaction] where {accID} in (SenderID, RecvID) and CreatedTimeInt >= {_start} and CreatedTimeInt <= {_end} order by id desc"; } else if (_type == 1) { query = $"select top 1000 * from ag.[Transaction] where RecvID = {accID} and CreatedTimeInt >= {_start} and CreatedTimeInt <= {_end} order by id desc"; } else { query = $"select top 1000 * from ag.[Transaction] where SenderID = {accID} and CreatedTimeInt >= {_start} and CreatedTimeInt <= {_end} order by id desc"; } dt = helper.GetDataTable(query); CreateSheet("Lịch sử giao dịch", dt); }
public dynamic AgencyTransaction(int id, string start, string end, int type, int page = 0) { try { DateTime from = new DateTime(Convert.ToInt32(start.Substring(0, 4)), Convert.ToInt32(start.Substring(4, 2)), Convert.ToInt32(start.Substring(6, 2))); DateTime to = new DateTime(Convert.ToInt32(end.Substring(0, 4)), Convert.ToInt32(end.Substring(4, 2)), Convert.ToInt32(end.Substring(6, 2))); var skip = page * 50; long totalMoney = 0, totalFee = 0; if (id > 0) { var account = AgencyDAO.GetById(id); if (UserContext.UserInfo.GroupID == 0) { if (account != null) { if (account.IsAgency == true) { var _data = TransactionDAO.TransactionHistory(account.GameAccountId, from, to, type, skip, 50, out totalMoney, out totalFee); return(new { TotalMoney = totalMoney, TotalFee = totalFee, Data = _data }); } } } else { if (account != null) { if (account.IsAgency == true) { var agencyInfo = TransactionDAO.GetAgencyInfo(account.GameAccountId); if (agencyInfo != null && agencyInfo.Creator == UserContext.UserInfo.AccountID) { var _data = TransactionDAO.TransactionHistory(account.GameAccountId, from, to, type, skip, 50, out totalMoney, out totalFee); return(new { TotalMoney = totalMoney, TotalFee = totalFee, Data = _data }); } } } } } else { var agency = AgencyDAO.GetById(UserContext.UserInfo.AccountID); if (agency != null) { var _data = TransactionDAO.TransactionHistory(agency.GameAccountId, from, to, type, skip, 50, out totalMoney, out totalFee); return(new { TotalMoney = totalMoney, TotalFee = totalFee, Data = _data }); } } return(null); } catch (Exception ex) { NLogManager.PublishException(ex); } return(null); }