public TotalSingleTreasure_Collection QueryBDFXAutherHomePage(string userId, string strIsBonus, string currentTime, int pageIndex, int pageSize) { Session.Clear(); TotalSingleTreasure_Collection collection = new TotalSingleTreasure_Collection(); collection.TotalCount = 0; Dictionary <string, object> outputs; var query = CreateOutputQuery(Session.GetNamedQuery("P_QueryBDFXAutherHomePage")) .AddInParameter("UserId", userId) .AddInParameter("StrIsBonus", strIsBonus) .AddInParameter("CurrentTime", currentTime) .AddInParameter("PageIndex", pageIndex) .AddInParameter("PageSize", pageSize) .AddOutParameter("TotalCount", "Int32") .AddOutParameter("AllTotalBuyCount", "Int32") .AddOutParameter("AllTotalBonusMoney", "Int32"); var dt = query.GetDataTable(out outputs); collection.TotalCount = UsefullHelper.GetDbValue <int>(outputs["TotalCount"]); collection.AllTotalBuyCount = UsefullHelper.GetDbValue <int>(outputs["AllTotalBuyCount"]); collection.AllTotalBonusMoney = UsefullHelper.GetDbValue <int>(outputs["AllTotalBonusMoney"]); if (collection.TotalCount > 0) { foreach (DataRow row in dt.Rows) { TotalSingleTreasureInfo info = new TotalSingleTreasureInfo(); info.UserId = Convert.ToString(row["UserId"]); info.UserName = Convert.ToString(row["UserName"]); info.SingleTreasureDeclaration = Convert.ToString(row["SingleTreasureDeclaration"]); info.GameCode = Convert.ToString(row["GameCode"]); info.GameType = Convert.ToString(row["GameType"]); info.IssuseNumber = Convert.ToString(row["IssuseNumber"]); info.ExpectedReturnRate = Convert.ToDecimal(row["ExpectedReturnRate"]); info.Commission = Convert.ToDecimal(row["Commission"]); info.Security = (TogetherSchemeSecurity)Convert.ToInt32(row["Security"]); info.TotalBuyCount = Convert.ToInt32(row["TotalBuyCount"]); info.TotalBuyMoney = Convert.ToDecimal(row["TotalBuyMoney"]); info.AfterTaxBonusMoney = Convert.ToDecimal(row["AfterTaxBonusMoney"]); info.FirstMatchStopTime = Convert.ToDateTime(row["FirstMatchStopTime"]); info.LastMatchStopTime = Convert.ToDateTime(row["LastMatchStopTime"]); info.ProfitRate = Convert.ToDecimal(row["ProfitRate"]); info.SchemeId = Convert.ToString(row["SchemeId"]); info.TotalBonusMoney = Convert.ToDecimal(row["TotalBonusMoney"]); info.ExpectedBonusMoney = Convert.ToDecimal(row["ExpectedBonusMoney"]); info.BetCount = Convert.ToInt32(row["BetCount"]); info.TotalMatchCount = Convert.ToInt32(row["TotalMatchCount"]); info.IsComplate = Convert.ToBoolean(row["IsComplate"]); info.CurrentBetMoney = Convert.ToDecimal(row["CurrentBetMoney"]); info.CurrProfitRate = row["CurrProfitRate"] == DBNull.Value ? 0M : Convert.ToDecimal(row["CurrProfitRate"]); collection.TotalSingleTreasureList.Add(info); } var arrSchemeId = from o in collection.TotalSingleTreasureList select o.SchemeId; var anteCodeList = this.QueryAnteCodeList(arrSchemeId.ToArray()); collection.AnteCodeList.AddRange(anteCodeList); } return(collection); }
public TotalSingleTreasure_Collection QueryTodayBDFXList(string userId, string userName, string gameCode, string orderBy, string desc, DateTime startTime, DateTime endTime, string isMyBD, int pageIndex, int pageSize) { Session.Clear(); TotalSingleTreasure_Collection collection = new TotalSingleTreasure_Collection(); collection.TotalCount = 0; //计算上周时间 var currTime = DateTime.Now; int day = Convert.ToInt32(currTime.DayOfWeek) - 1; if (currTime.DayOfWeek != 0) { currTime = currTime.AddDays(-day); } else { currTime = currTime.AddDays(-6); } var sTime = currTime.AddDays(-7).Date; var eTime = currTime.Date; Dictionary <string, object> outputs; var query = CreateOutputQuery(Session.GetNamedQuery("P_Order_QueryTodayBDFX")) .AddInParameter("UserId", userId) .AddInParameter("UserName", userName) .AddInParameter("GameCode", gameCode) .AddInParameter("OrderBy", orderBy) .AddInParameter("Desc", desc) .AddInParameter("PageIndex", pageIndex) .AddInParameter("PageSize", pageSize) .AddInParameter("StartTime", startTime) .AddInParameter("EndTime", endTime) .AddInParameter("LastweekStartTime", sTime) .AddInParameter("LastweekEndTime", eTime) .AddInParameter("IsMyBD", isMyBD) .AddOutParameter("TotalCount", "Int32"); var dt = query.GetDataTable(out outputs); collection.TotalCount = UsefullHelper.GetDbValue <int>(outputs["TotalCount"]); if (collection.TotalCount > 0) { foreach (DataRow row in dt.Rows) { TotalSingleTreasureInfo info = new TotalSingleTreasureInfo(); info.UserId = Convert.ToString(row["UserId"]); info.UserName = Convert.ToString(row["UserName"]); info.SingleTreasureDeclaration = Convert.ToString(row["SingleTreasureDeclaration"]); info.GameCode = Convert.ToString(row["GameCode"]); info.GameType = Convert.ToString(row["GameType"]); info.IssuseNumber = Convert.ToString(row["IssuseNumber"]); info.ExpectedReturnRate = Convert.ToDecimal(row["ExpectedReturnRate"]); info.Commission = Convert.ToDecimal(row["Commission"]); info.Security = (TogetherSchemeSecurity)Convert.ToInt32(row["Security"]); info.TotalBuyCount = Convert.ToInt32(row["TotalBuyCount"]); info.TotalBuyMoney = Convert.ToDecimal(row["TotalBuyMoney"]); info.AfterTaxBonusMoney = Convert.ToDecimal(row["AfterTaxBonusMoney"]); info.FirstMatchStopTime = Convert.ToDateTime(row["FirstMatchStopTime"]); info.LastMatchStopTime = Convert.ToDateTime(row["LastMatchStopTime"]); info.ProfitRate = Convert.ToDecimal(row["ProfitRate"]); info.SchemeId = Convert.ToString(row["SchemeId"]); info.TotalBonusMoney = Convert.ToDecimal(row["TotalBonusMoney"]); info.ExpectedBonusMoney = Convert.ToDecimal(row["ExpectedBonusMoney"]); info.BetCount = Convert.ToInt32(row["BetCount"]); info.TotalMatchCount = Convert.ToInt32(row["TotalMatchCount"]); info.IsComplate = Convert.ToBoolean(row["IsComplate"]); info.CurrentBetMoney = Convert.ToDecimal(row["CurrentBetMoney"]); info.ProfitRate = Convert.ToDecimal(row["CDProfitRate"]); info.LastweekProfitRate = row["LastweekProfitRate"] == DBNull.Value ? 0 : Convert.ToDecimal(row["LastweekProfitRate"]); info.BDFXCreateTime = Convert.ToDateTime(row["BDFXCreateTime"]); info.CurrProfitRate = row["CurrProfitRate"] == DBNull.Value ? 0 : Convert.ToDecimal(row["CurrProfitRate"]); collection.TotalSingleTreasureList.Add(info); } var arrSchemeId = from o in collection.TotalSingleTreasureList select o.SchemeId; var anteCodeList = this.QueryAnteCodeList(arrSchemeId.ToArray()); collection.AnteCodeList.AddRange(anteCodeList); } return(collection); }