private Caike_Body GetBJDCList(string matchDateCode = "") { try { var BJDC_url = "Trade/DrawInfo/jingjiDraw.aspx?lotteryType=20011"; if (!string.IsNullOrEmpty(matchDateCode)) { BJDC_url += "&matchDateCode=" + matchDateCode; } var url = Url_Caike + BJDC_url; int page = 1; var result = new Caike_Body() { matchDates = new List <Caike_matchDates>() }; while (true) { var str = CommonHelper.Post(url, "action=loaddata&" + "pageIndex=" + page, Encoding.UTF8, CollectionUrlEnum.url_caike); if (!string.IsNullOrEmpty(str)) { var model = JsonHelper.Deserialize <CaikeCommonCollection>(str); if (model != null) { result.matchDates = model.body.matchDates; result.records.AddRange(model.body.records); if (!model.body.hasNext) { return(result); } else { page++; } } } } } catch (Exception ex) { Console.WriteLine(ex.Message + ":" + ex.StackTrace); return(null); } }
public int AddCaiKeBJDC(Caike_Body caike_Body, string matchDateCode) { try { int m = 0; caike_Body.records.ForEach((record) => { bjdc_result _Result = new bjdc_result { MatchId = matchDateCode + record.matchNo, MatchDate = "", MatchNumber = record.matchNo, HomeTeam = record.homeTeam, GuestTeam = record.guestTeam, HalfScore = record.hScoreText.Replace("-", ":"), FullScore = record.scoreText.Substring(record.scoreText.IndexOf(">") + 1, record.scoreText.Substring(record.scoreText.IndexOf(">") + 1).IndexOf("<")).Replace("-", ":"), LeagueName = record.leagueName, AvgEu_SP = "123456", Url_Type = (int)CollectionUrlEnum.url_caike }; int i = 0; record.details.ForEach((detail) => { if (detail.name != "" && detail.name != "-" && detail.value != "" && detail.value != "-") { if (i == 0) { _Result.LetBall = detail.name.Substring(detail.name.IndexOf("(") + 1, detail.name.IndexOf(")") - detail.name.IndexOf("(") - 1); _Result.RQSPF_Result = detail.name.Substring(detail.name.IndexOf("(") + 1, detail.name.IndexOf(")") - detail.name.IndexOf("(") - 1); _Result.RQSPF_SP = detail.value; i++; } else if (i == 1) { _Result.ZJQ_Result = Convert2Number(detail.name.Replace("球", "")).ToString(); _Result.ZJQ_SP = detail.value; i++; } else if (i == 2) { _Result.SXDS_Result = detail.name; _Result.SXDS_SP = detail.value; i++; } else if (i == 3) { _Result.BF_SP = detail.name; i++; } else if (i == 4) { _Result.BQC_Result = detail.name; _Result.BQC_SP = detail.value; i++; } } }); if (!string.IsNullOrEmpty(_Result.RQSPF_Result) && _Result.RQSPF_Result != "-" && !string.IsNullOrEmpty(_Result.ZJQ_Result) && _Result.ZJQ_Result != "-" && !string.IsNullOrEmpty(_Result.FullScore) && _Result.FullScore != "-" && !string.IsNullOrEmpty(_Result.SXDS_Result) && _Result.SXDS_Result != "-" && !string.IsNullOrEmpty(_Result.BQC_Result) && _Result.BQC_Result != "-") { _Result.IsFinish = true; } else { _Result.IsFinish = false; } var model = db.Queryable <bjdc_result>().Where(x => x.MatchId == _Result.MatchId).First(); if (model == null) { db.Insertable(_Result).ExecuteCommand(); m++; } else { if (!model.IsFinish) { db.Updateable(_Result).ExecuteCommand(); } } }); var lottery = db.Queryable <sys_lottery>().Where(x => x.LotteryCode == "zqdc").First(); caike_Body.matchDates.ForEach((matchDate) => { if (matchDate.code == matchDateCode) { sys_issue _sys_Issue = new sys_issue(); _sys_Issue.LotteryId = lottery.Lottery_Id; _sys_Issue.IssueNo = matchDate.code; _sys_Issue.LotteryCode = lottery.LotteryCode; _sys_Issue.CreateTime = DateTime.Now; var Model = db.Queryable <sys_issue>().Where(x => x.LotteryId == _sys_Issue.LotteryId && x.LotteryCode == _sys_Issue.LotteryCode && x.IssueNo == _sys_Issue.IssueNo).First(); if (Model == null) { db.Insertable(_sys_Issue).ExecuteCommand(); } } }); return(m); } catch (Exception ex) { throw new Exception(ex.Message); } }
public int AddCaikeJCZQ(Caike_Body caike_Body, string matchDateCode, DateTime dateTime) { try { int m = 0; caike_Body.records.ForEach((record) => { jczq_result _Result = new jczq_result { MatchId = matchDateCode + record.matchNo, MatchDate = "", MatchNumber = record.matchNo, HomeTeam = record.homeTeam, GuestTeam = record.guestTeam, HalfScore = record.hScoreText, FullScore = record.scoreText.Substring(record.scoreText.IndexOf(">") + 1, record.scoreText.Substring(record.scoreText.IndexOf(">") + 1).IndexOf("<")).Replace("-", ":"), LeagueName = record.leagueName, Url_Type = (int)CollectionUrlEnum.url_caike }; int i = 0; record.details.ForEach((detail) => { if (detail.name != "" && detail.name != "-" && detail.value != "" && detail.value != "-") { if (i == 0) { _Result.RQSPF_Result = detail.name.Substring(0, 1); _Result.LetBall = detail.name.Substring(detail.name.IndexOf("(") + 1, detail.name.IndexOf(")") - detail.name.IndexOf("(") - 1); _Result.RQSPF_SP = detail.value; i++; } else if (i == 1) { _Result.SPF_Result = detail.name; _Result.SPF_SP = detail.value; i++; } else if (i == 2) { _Result.BF_SP = detail.value; i++; } else if (i == 3) { _Result.ZJQ_Result = detail.name.Replace("球", ""); _Result.ZJQ_SP = detail.value; i++; } else if (i == 4) { _Result.BQC_Result = detail.name; _Result.BQC_SP = detail.value; i++; } } }); _Result.AvgEu_SP = "123456"; _Result.JCDate = dateTime.ToString("yyyy-MM-dd"); _Result.CreateTime = DateTime.Now; var Model = db.Queryable <jczq_result>().Where(x => x.MatchId == _Result.MatchId).First(); if (Model == null) { db.Insertable(_Result).ExecuteCommand(); m++; } }); return(m); } catch (Exception ex) { throw new Exception(ex.Message); } }
public int AddCaiKeJCLQ(Caike_Body caike_Body, string matchDateCode, DateTime dateTime) { try { int m = 0; caike_Body.records.ForEach((record) => { jclq_result _Result = new jclq_result { MatchId = matchDateCode + record.matchNo, MatchDate = "", MatchNumber = record.matchNo, HomeTeam = record.homeTeam, GuestTeam = record.guestTeam, LeagueName = record.leagueName, FullScore = record.scoreText.Substring(record.scoreText.IndexOf(">") + 1, record.scoreText.Substring(record.scoreText.IndexOf(">") + 1).IndexOf("<")).Replace("-", ":"), AvgEu_SP = "123456", JCDate = dateTime.ToString("yyyy-MM-dd"), CreateTime = DateTime.Now, Url_Type = (int)CollectionUrlEnum.url_caike }; int i = 0; record.details.ForEach((detail) => { if (detail.name != "" && detail.name != "-" && detail.value != "" && detail.value != "-") { if (i == 0) { _Result.SF_Result = detail.name; i++; } else if (i == 1) { _Result.RFSF_Result = detail.name.Substring(0, detail.name.IndexOf("(") - 1); _Result.LetBall = detail.name.Substring(detail.name.IndexOf("(") + 1, detail.name.IndexOf(")") - detail.name.IndexOf("(") - 1); i++; } else if (i == 2) { var SFC = detail.name.Replace("胜", "").Replace("负", ""); _Result.SFC_Result = _Result.RFSF_Result + SFC; _Result.GG_SFC_Result = _Result.RFSF_Result + SFC; _Result.GG_RFSF_Result = "让分" + _Result.RFSF_Result; i++; } else if (i == 3) { _Result.YSZF = detail.name.Substring(detail.name.IndexOf("(") + 1, detail.name.IndexOf(")") - detail.name.IndexOf("(") - 1); _Result.DXF_Result = detail.name.Split("(")[0]; _Result.GG_DXF_Result = detail.name.Split("(")[0] + "分"; i++; } } }); var Model = db.Queryable <jclq_result>().Where(x => x.MatchId == _Result.MatchId).First(); if (Model == null) { db.Insertable(_Result).ExecuteCommand(); m++; } }); return(m); } catch (Exception ex) { throw new Exception(ex.Message); } }