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);
}
}
/// <summary>
/// 竞彩足球
/// </summary>
public void Add_JCZQ(List <jczq> model, string GameCode = "jczq")
{
try
{
List <jczq_result> jczq_Results = new List <jczq_result>();
List <jclq_result> List = new List <jclq_result>();
foreach (var item in model)
{
jczq_result jczq = new jczq_result
{
MatchId = item.id.Replace("-", "") + item.TournamentNumber,
MatchDate = item.MatchTime,
MatchNumber = item.TournamentNumber,
HomeTeam = item.HomeTeam,
GuestTeam = item.VisitingTeam,
LetBall = item.LetBall,
HalfScore = item.Score == "-" ? "-" : item.Score.Split(")")[0].Replace("(", "").Replace(")", ""),
FullScore = item.Score == "-" ? "-" : item.Score.Split(")")[1].Replace(")", "").Replace(" ", ""),
LeagueName = item.TournamentType,
League_Color = item.League_Color,
CreateTime = DateTime.Now,
JCDate = item.id,
AvgEu_SP = item.AvgOuCompensation,
Url_Type = (int)CollectionUrlEnum.url_500zx
};
foreach (var Sub_item in item.gameTypes)
{
if (Sub_item.game == Game.让球胜平负)
{
jczq.RQSPF_Result = Sub_item.FruitColor;
jczq.RQSPF_SP = Sub_item.Bonus;
}
else if (Sub_item.game == Game.总进球数)
{
jczq.ZJQ_Result = Sub_item.FruitColor;
jczq.ZJQ_SP = Sub_item.Bonus;
}
else if (Sub_item.game == Game.比分)
{
//比分彩果FullScore
jczq.BF_SP = Sub_item.Bonus;
}
else if (Sub_item.game == Game.胜平负)
{
jczq.SPF_Result = Sub_item.FruitColor;
jczq.SPF_SP = Sub_item.Bonus;
}
else if (Sub_item.game == Game.半全场)
{
jczq.BQC_Result = Sub_item.FruitColor;
jczq.BQC_SP = Sub_item.Bonus;
}
}
jczq_Results.Add(jczq);
}
int i = 0;
jczq_Results.ForEach((a) => {
bool b = db.Queryable <jczq_result>().Where(x => x.MatchId == a.MatchId).Count() > 0 ? true : false;
if (!b)
{
db.Insertable(a).ExecuteCommand();
i++;
}
});
ConSoleHelp("A", GameCode, jczq_Results.Select(x => x.JCDate).FirstOrDefault(), i);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
