/// <summary> /// 获取混合单关数据 /// </summary> /// <param name="gameType"></param> /// <param name="matchDate"></param> /// <param name="isLeftJoin"></param> /// <returns></returns> public static List <JCLQ_MatchInfo_WEB> GetJCLQHHDGList() { BettingHelper bizHelper = new BettingHelper(); var match = bizHelper.GetMatchInfoList <JCLQHHDGBase>(GetFilePath("New/Match_HHDG_List")); var list = new List <JCLQ_MatchInfo_WEB>(); match = match.Where(t => long.Parse(Convert.ToDateTime(t.FSStopBettingTime).ToString("yyyyMMddHHmmss")) > long.Parse(DateTime.Now.ToString("yyyyMMddHHmmss"))).ToList(); if (match != null && match.Count > 0) { foreach (var item in match) { var matchDataTime = ConvertHelper.ConvertStrToDateTime("20" + item.MatchData); var info = new JCLQ_MatchInfo_WEB() { //CreateTime = item.CreateTime.ToString("yyyyMMddHHmmss"), //DSStopBettingTime = item.DSStopBettingTime.ToString("yyyyMMddHHmmss"), MatcheDateTime = matchDataTime, //FSStopBettingTime = bizHelper.ConvertDateTimeInt(Convert.ToDateTime(item.FSStopBettingTime)).ToString(), FSStopBettingTime = item.FSStopBettingTime, //FSStopBettingTime = item.FSStopBettingTime.ToString("yyyyMMddHHmmss"), //GuestTeamId = item.GuestTeamId, GuestTeamName = BettingHelper.GetTeamName(item.GuestTeamName), HomeTeamName = BettingHelper.GetTeamName(item.HomeTeamName), //HomeTeamId = item.HomeTeamId, LeagueColor = item.LeagueColor.Contains("#") ? item.LeagueColor : "#" + "DB7917", //LeagueId = item.LeagueId, LeagueName = item.LeagueName, MatchIdName = item.MatchIdName, //StartDateTime = bizHelper.ConvertDateTimeInt(Convert.ToDateTime(item.StartDateTime)).ToString(), StartDateTime = Convert.ToDateTime(item.StartDateTime), //StartDateTime = item.StartDateTime.ToString("yyyyMMddHHmmss"), MatchData = item.MatchData, MatchId = item.MatchId, MatchNumber = item.MatchNumber, //AverageLose = item.AverageLose, //AverageWin = item.AverageWin, //Mid = item.Mid, FXId = item.FXId, State_HHDG = item.State, PrivilegesType = item.PrivilegesType == null ? string.Empty : item.PrivilegesType, }; #region 附加胜负sp数据 if (item.SF != null) { var sfcjson = JsonHelper.Deserialize <JCLQ_SF_SPInfo>(item.SF); if (sfcjson != null) { info.SF_WinSP = sfcjson.WinSP; info.SF_LoseSP = sfcjson.LoseSP; } } #endregion #region 附加让分胜负sp数据 if (item.RFSF != null) { var json = JsonHelper.Deserialize <JCLQ_RFSF_SPInfo>(item.RFSF); if (json != null) { info.RF = json.RF; info.RF_LoseSP = json.LoseSP; info.RF_WinSP = json.WinSP; } } #endregion #region 附加胜分差sp数据 if (item.SFC != null) { var json = JsonHelper.Deserialize <JCLQ_SFC_SPInfo>(item.SFC); if (json != null) { info.GuestWin1_5 = json.GuestWin1_5; info.GuestWin11_15 = json.GuestWin11_15; info.GuestWin16_20 = json.GuestWin16_20; info.GuestWin21_25 = json.GuestWin21_25; info.GuestWin26 = json.GuestWin26; info.GuestWin6_10 = json.GuestWin6_10; info.HomeWin1_5 = json.HomeWin1_5; info.HomeWin11_15 = json.HomeWin11_15; info.HomeWin16_20 = json.HomeWin16_20; info.HomeWin21_25 = json.HomeWin21_25; info.HomeWin26 = json.HomeWin26; info.HomeWin6_10 = json.HomeWin6_10; } } #endregion #region 附加大小分sp数据 if (item.DXF != null) { var json = JsonHelper.Deserialize <JCLQ_DXF_SPInfo>(item.DXF); if (json != null) { info.DF = json.DF; info.XF = json.XF; info.YSZF = json.YSZF; } } #endregion list.Add(info); } } return(list); }
/// <summary> /// 查询队伍信息与队伍比赛结果信息 - WEB页面使用 /// - 合并队伍基础信息与队伍结果信息 /// - 合并各玩法SP数据 /// </summary> /// <param name="service">HttpServerUtilityBase对象</param> /// <param name="type">玩法类型</param> /// <param name="matchDate">查询日期</param> /// <param name="isLeftJoin">是否查询没有结果的队伍比赛信息</param> /// <returns>队伍信息及比赛结果信息</returns> public static List <JCLQ_MatchInfo_WEB> MatchList_WEB(string gameType, string matchDate = null, bool isLeftJoin = true) { BettingHelper bizHelper = new BettingHelper(); var match = bizHelper.GetMatchInfoList <JCLQ_MatchInfo>(MatchFile(gameType, matchDate)); var matchresult = bizHelper.GetMatchInfoList <JCLQ_MatchResultInfo>(MatchResultFile(matchDate)); //var sp_sf =bizHelper.GetMatchInfoList<JCLQ_SF_SPInfo>(SPFile("SF", matchDate)); //胜负sp数据 //var sp_rfsf = bizHelper.GetMatchInfoList<JCLQ_RFSF_SPInfo>(SPFile("RFSF", matchDate)); //让分胜负sp数据 //var sp_sfc = bizHelper.GetMatchInfoList<JCLQ_SFC_SPInfo>(SPFile("SFC", matchDate)); //胜分差sp数据 //var sp_dxf = bizHelper.GetMatchInfoList<JCLQ_DXF_SPInfo>(SPFile("DXF", matchDate)); //大小分sp数据 var sp_sf = bizHelper.GetMatchInfoList <JCLQ_SF_SPInfo>(SPFile(gameType, matchDate)); //胜负sp数据 var sp_rfsf = bizHelper.GetMatchInfoList <JCLQ_RFSF_SPInfo>(SPFile(gameType, matchDate)); //让分胜负sp数据 var sp_sfc = bizHelper.GetMatchInfoList <JCLQ_SFC_SPInfo>(SPFile(gameType, matchDate)); //胜分差sp数据 var sp_dxf = bizHelper.GetMatchInfoList <JCLQ_DXF_SPInfo>(SPFile(gameType, matchDate)); //大小分sp数据 var list = new List <JCLQ_MatchInfo_WEB>(); match = match.Where(t => long.Parse(Convert.ToDateTime(t.FSStopBettingTime).ToString("yyyyMMddHHmmss")) > long.Parse(DateTime.Now.ToString("yyyyMMddHHmmss"))).ToList(); foreach (var item in match) { #region 队伍基础信息 var matchDataTime = ConvertHelper.ConvertStrToDateTime("20" + item.MatchData); var info = new JCLQ_MatchInfo_WEB() { //CreateTime = item.CreateTime.ToString("yyyyMMddHHmmss"), //DSStopBettingTime = item.DSStopBettingTime.ToString("yyyyMMddHHmmss"), MatcheDateTime = matchDataTime, //FSStopBettingTime = bizHelper.ConvertDateTimeInt(Convert.ToDateTime(item.FSStopBettingTime)).ToString(), FSStopBettingTime = item.FSStopBettingTime, //FSStopBettingTime = item.FSStopBettingTime.ToString("yyyyMMddHHmmss"), //GuestTeamId = item.GuestTeamId, GuestTeamName = BettingHelper.GetTeamName(item.GuestTeamName), HomeTeamName = BettingHelper.GetTeamName(item.HomeTeamName), //HomeTeamId = item.HomeTeamId, LeagueColor = item.LeagueColor.Contains("#") ? item.LeagueColor : "#" + "DB7917", //LeagueId = item.LeagueId, LeagueName = item.LeagueName, MatchIdName = item.MatchIdName, StartDateTime = Convert.ToDateTime(item.StartDateTime), //StartDateTime = item.StartDateTime.ToString("yyyyMMddHHmmss"), MatchData = item.MatchData, MatchId = item.MatchId, MatchNumber = item.MatchNumber, //AverageLose = item.AverageLose, //AverageWin = item.AverageWin, //Mid = item.Mid, FXId = item.FXId, PrivilegesType = item.PrivilegesType == null ? string.Empty : item.PrivilegesType, State_HHDG = item.State }; #endregion #region 附加队伍结果信息 var res = matchresult.FirstOrDefault(p => p.MatchId == item.MatchId); if (res != null) { //info.DXF_Result = res.DXF_Result; //info.DXF_SP = res.DXF_SP; //info.DXF_Trend = res.DXF_Trend; //info.GuestScore = res.GuestScore; //info.HomeScore = res.HomeScore; //info.RFSF_Result = res.RFSF_Result; //info.RFSF_SP = res.RFSF_SP; //info.RFSF_Trend = res.RFSF_Trend; //info.SF_Result = res.SF_Result; //info.SF_SP = res.SF_SP; //info.SFC_Result = res.SFC_Result; //info.SFC_SP = res.SFC_SP; //info.MatchState = res.MatchState; } else if (!isLeftJoin) { continue; } #endregion #region 附加胜负sp数据 var sp_sf_item = sp_sf.FirstOrDefault(p => p.MatchId == item.MatchId); if (gameType.ToLower() == "hh") { if (sp_sf_item != null && sp_sf_item.SF != null) { var json = JsonHelper.Deserialize <JCLQ_SF_SPInfo>(sp_sf_item.SF); info.SF_WinSP = json.WinSP; info.SF_LoseSP = json.LoseSP; //info.PrivilegesType = json.PrivilegesType == null ? string.Empty : json.PrivilegesType; } } else { if (sp_sf_item != null) { info.SF_WinSP = sp_sf_item.WinSP; info.SF_LoseSP = sp_sf_item.LoseSP; //info.PrivilegesType = sp_sf_item.PrivilegesType == null ? string.Empty : sp_sf_item.PrivilegesType; } } #endregion #region 附加让分胜负sp数据 var sp_rfsf_item = sp_rfsf.FirstOrDefault(p => p.MatchId == item.MatchId); if (gameType.ToLower() == "hh") { if (sp_rfsf_item != null && sp_rfsf_item.RFSF != null) { var json = JsonHelper.Deserialize <JCLQ_RFSF_SPInfo>(sp_rfsf_item.RFSF); info.RF = json.RF; info.RF_LoseSP = json.LoseSP; info.RF_WinSP = json.WinSP; //info.PrivilegesType = json.PrivilegesType == null ? string.Empty : json.PrivilegesType; } } else { if (sp_rfsf_item != null) { info.RF = sp_rfsf_item.RF; info.RF_LoseSP = sp_rfsf_item.LoseSP; info.RF_WinSP = sp_rfsf_item.WinSP; //info.PrivilegesType = sp_rfsf_item.PrivilegesType == null ? string.Empty : sp_rfsf_item.PrivilegesType; } } #endregion #region 附加胜分差sp数据 var sp_sfc_item = sp_sfc.FirstOrDefault(p => p.MatchId == item.MatchId); if (gameType.ToLower() == "hh") { if (sp_sfc_item != null && sp_sfc_item.SFC != null) { var json = JsonHelper.Deserialize <JCLQ_SFC_SPInfo>(sp_sfc_item.SFC); info.GuestWin1_5 = json.GuestWin1_5; info.GuestWin11_15 = json.GuestWin11_15; info.GuestWin16_20 = json.GuestWin16_20; info.GuestWin21_25 = json.GuestWin21_25; info.GuestWin26 = json.GuestWin26; info.GuestWin6_10 = json.GuestWin6_10; info.HomeWin1_5 = json.HomeWin1_5; info.HomeWin11_15 = json.HomeWin11_15; info.HomeWin16_20 = json.HomeWin16_20; info.HomeWin21_25 = json.HomeWin21_25; info.HomeWin26 = json.HomeWin26; info.HomeWin6_10 = json.HomeWin6_10; //info.PrivilegesType = json.PrivilegesType == null ? string.Empty : json.PrivilegesType; } } else { if (sp_sfc_item != null) { info.GuestWin1_5 = sp_sfc_item.GuestWin1_5; info.GuestWin11_15 = sp_sfc_item.GuestWin11_15; info.GuestWin16_20 = sp_sfc_item.GuestWin16_20; info.GuestWin21_25 = sp_sfc_item.GuestWin21_25; info.GuestWin26 = sp_sfc_item.GuestWin26; info.GuestWin6_10 = sp_sfc_item.GuestWin6_10; info.HomeWin1_5 = sp_sfc_item.HomeWin1_5; info.HomeWin11_15 = sp_sfc_item.HomeWin11_15; info.HomeWin16_20 = sp_sfc_item.HomeWin16_20; info.HomeWin21_25 = sp_sfc_item.HomeWin21_25; info.HomeWin26 = sp_sfc_item.HomeWin26; info.HomeWin6_10 = sp_sfc_item.HomeWin6_10; //info.PrivilegesType = sp_sfc_item.PrivilegesType == null ? string.Empty : sp_sfc_item.PrivilegesType; } } #endregion #region 附加大小分sp数据 var sp_dxf_item = sp_dxf.FirstOrDefault(p => p.MatchId == item.MatchId); if (gameType.ToLower() == "hh") { if (sp_dxf_item != null && sp_dxf_item.DXF != null) { var json = JsonHelper.Deserialize <JCLQ_DXF_SPInfo>(sp_dxf_item.DXF); info.DF = json.DF; info.XF = json.XF; info.YSZF = json.YSZF; //info.PrivilegesType = json.PrivilegesType == null ? string.Empty : json.PrivilegesType; } } else { if (sp_dxf_item != null) { info.DF = sp_dxf_item.DF; info.XF = sp_dxf_item.XF; info.YSZF = sp_dxf_item.YSZF; //info.PrivilegesType = sp_dxf_item.PrivilegesType == null ? string.Empty : sp_dxf_item.PrivilegesType; } } #endregion list.Add(info); } return(list); }