public void updateOdds1x2(string scheduleID)
{
try
{
OddsDAO oddsDAO = new OddsDAO();
CompanyDAO companyDAO = new CompanyDAO();
WebClientBLL bll = new WebClientBLL();
string actual = bll.UpdateOdds1x2Content(scheduleID);
//获取赔率原始数据
Regex reg = new Regex("game\\=Array\\(\"" + "\\w[^;" + "]*;");
Match mat = reg.Match(actual);
if (mat != null && !String.IsNullOrEmpty(mat.Value))
{
//所有公司数据
string source = mat.Value.Substring(12, mat.Value.Length - 10 - 4);
//分解出每个公司数据
string[] compstrs = Regex.Split(source, "\",\"", RegexOptions.IgnoreCase);
foreach (string compstr in compstrs)
{
JObject item = new JObject();
string[] oddsArr = compstr.Replace("\"", "").Split('|');
#region 插入公司数据
if (!companyDAO.Exists(int.Parse(oddsArr[0])) && oddsArr.Length > 22)
{
SeoWebSite.Model.Company company = new SeoWebSite.Model.Company();
company.id = int.Parse(oddsArr[0]);
company.fullname = oddsArr[21];
company.name = oddsArr[2];
company.isprimary = Convert.ToBoolean(int.Parse(oddsArr[22]));
company.isexchange = Convert.ToBoolean(int.Parse(oddsArr[23]));
companyDAO.Add(company);
}
#endregion
#region 插入欧赔数据
if (!oddsDAO.Exists(int.Parse(oddsArr[1])))
{
Odds odds = new Odds();
odds.scheduleid = int.Parse(scheduleID);
odds.companyid = int.Parse(oddsArr[0]);
odds.id = int.Parse(oddsArr[1]);
odds.s_win = decimal.Parse(oddsArr[3]);
odds.s_draw = decimal.Parse(oddsArr[4]);
odds.s_lost = decimal.Parse(oddsArr[5]);
odds.s_winper = decimal.Parse(oddsArr[6]);
odds.s_drawper = decimal.Parse(oddsArr[7]);
odds.s_lostper = decimal.Parse(oddsArr[8]);
if (!String.IsNullOrEmpty(oddsArr[9]))
{
odds.s_return = decimal.Parse(oddsArr[9]);
}
if (!String.IsNullOrEmpty(oddsArr[10]))
{
odds.e_win = decimal.Parse(oddsArr[10]);
}
if (!String.IsNullOrEmpty(oddsArr[11]))
{
odds.e_draw = decimal.Parse(oddsArr[11]);
}
if (!String.IsNullOrEmpty(oddsArr[12]))
{
odds.e_lost = decimal.Parse(oddsArr[12]);
}
if (!String.IsNullOrEmpty(oddsArr[13]))
{
odds.e_winper = decimal.Parse(oddsArr[13]);
}
if (!String.IsNullOrEmpty(oddsArr[14]))
{
odds.e_drawper = decimal.Parse(oddsArr[14]);
}
if (!String.IsNullOrEmpty(oddsArr[15]))
{
odds.e_lostper = decimal.Parse(oddsArr[15]);
}
if (!String.IsNullOrEmpty(oddsArr[16]))
{
odds.e_return = decimal.Parse(oddsArr[16]);
}
if (!String.IsNullOrEmpty(oddsArr[17]))
{
odds.winkelly = decimal.Parse(oddsArr[17]);
}
if (!String.IsNullOrEmpty(oddsArr[18]))
{
odds.drawkelly = decimal.Parse(oddsArr[18]);
}
if (!String.IsNullOrEmpty(oddsArr[19]))
{
odds.lostkelly = decimal.Parse(oddsArr[19]);
}
string[] timeArr = oddsArr[20].Split(',');
odds.lastupdatetime = new DateTime(int.Parse(timeArr[0]), int.Parse(timeArr[1].Remove(2)), int.Parse(timeArr[2]), int.Parse(timeArr[3]), int.Parse(timeArr[4]), int.Parse(timeArr[5])).AddHours(8);
oddsDAO.Add(odds);
}
#endregion
}
}
}
catch (WebException e)
{
HttpWebResponse response = (HttpWebResponse)e.Response;
if (response != null) //排除对象为空的错误
{
if (response.StatusCode == HttpStatusCode.NotFound) //判断是否是404错误
sdal.Delete(Convert.ToInt32(scheduleID));
}
}
}
/// <summary>
/// 获得数据列表
/// </summary>
public List<SeoWebSite.Model.Odds> DataTableToList(DataTable dt)
{
List<SeoWebSite.Model.Odds> modelList = new List<SeoWebSite.Model.Odds>();
int rowsCount = dt.Rows.Count;
if (rowsCount > 0)
{
SeoWebSite.Model.Odds model;
for (int n = 0; n < rowsCount; n++)
{
model = new SeoWebSite.Model.Odds();
if(dt.Rows[n]["id"]!=null && dt.Rows[n]["id"].ToString()!="")
{
model.id=int.Parse(dt.Rows[n]["id"].ToString());
}
if(dt.Rows[n]["companyid"]!=null && dt.Rows[n]["companyid"].ToString()!="")
{
model.companyid=int.Parse(dt.Rows[n]["companyid"].ToString());
}
if(dt.Rows[n]["s_win"]!=null && dt.Rows[n]["s_win"].ToString()!="")
{
model.s_win=decimal.Parse(dt.Rows[n]["s_win"].ToString());
}
if(dt.Rows[n]["s_draw"]!=null && dt.Rows[n]["s_draw"].ToString()!="")
{
model.s_draw=decimal.Parse(dt.Rows[n]["s_draw"].ToString());
}
if(dt.Rows[n]["s_lost"]!=null && dt.Rows[n]["s_lost"].ToString()!="")
{
model.s_lost=decimal.Parse(dt.Rows[n]["s_lost"].ToString());
}
if(dt.Rows[n]["s_winper"]!=null && dt.Rows[n]["s_winper"].ToString()!="")
{
model.s_winper=decimal.Parse(dt.Rows[n]["s_winper"].ToString());
}
if(dt.Rows[n]["s_drawper"]!=null && dt.Rows[n]["s_drawper"].ToString()!="")
{
model.s_drawper=decimal.Parse(dt.Rows[n]["s_drawper"].ToString());
}
if(dt.Rows[n]["s_lostper"]!=null && dt.Rows[n]["s_lostper"].ToString()!="")
{
model.s_lostper=decimal.Parse(dt.Rows[n]["s_lostper"].ToString());
}
if(dt.Rows[n]["s_return"]!=null && dt.Rows[n]["s_return"].ToString()!="")
{
model.s_return=decimal.Parse(dt.Rows[n]["s_return"].ToString());
}
if(dt.Rows[n]["e_win"]!=null && dt.Rows[n]["e_win"].ToString()!="")
{
model.e_win=decimal.Parse(dt.Rows[n]["e_win"].ToString());
}
if(dt.Rows[n]["e_draw"]!=null && dt.Rows[n]["e_draw"].ToString()!="")
{
model.e_draw=decimal.Parse(dt.Rows[n]["e_draw"].ToString());
}
if(dt.Rows[n]["e_lost"]!=null && dt.Rows[n]["e_lost"].ToString()!="")
{
model.e_lost=decimal.Parse(dt.Rows[n]["e_lost"].ToString());
}
if(dt.Rows[n]["e_winper"]!=null && dt.Rows[n]["e_winper"].ToString()!="")
{
model.e_winper=decimal.Parse(dt.Rows[n]["e_winper"].ToString());
}
if(dt.Rows[n]["e_drawper"]!=null && dt.Rows[n]["e_drawper"].ToString()!="")
{
model.e_drawper=decimal.Parse(dt.Rows[n]["e_drawper"].ToString());
}
if(dt.Rows[n]["e_lostper"]!=null && dt.Rows[n]["e_lostper"].ToString()!="")
{
model.e_lostper=decimal.Parse(dt.Rows[n]["e_lostper"].ToString());
}
if(dt.Rows[n]["e_return"]!=null && dt.Rows[n]["e_return"].ToString()!="")
{
model.e_return=decimal.Parse(dt.Rows[n]["e_return"].ToString());
}
if(dt.Rows[n]["winkelly"]!=null && dt.Rows[n]["winkelly"].ToString()!="")
{
model.winkelly=decimal.Parse(dt.Rows[n]["winkelly"].ToString());
}
if(dt.Rows[n]["drawkelly"]!=null && dt.Rows[n]["drawkelly"].ToString()!="")
{
model.drawkelly=decimal.Parse(dt.Rows[n]["drawkelly"].ToString());
}
if(dt.Rows[n]["lostkelly"]!=null && dt.Rows[n]["lostkelly"].ToString()!="")
{
model.lostkelly=decimal.Parse(dt.Rows[n]["lostkelly"].ToString());
}
if(dt.Rows[n]["lastupdatetime"]!=null && dt.Rows[n]["lastupdatetime"].ToString()!="")
{
model.lastupdatetime=DateTime.Parse(dt.Rows[n]["lastupdatetime"].ToString());
}
modelList.Add(model);
}
}
return modelList;
}
/// <summary>
/// 增加一条数据
/// </summary>
public void Add(SeoWebSite.Model.Odds model)
{
dal.Add(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(SeoWebSite.Model.Odds model)
{
return(dal.Update(model));
}
/// <summary>
/// 获得数据列表
/// </summary>
public List <SeoWebSite.Model.Odds> DataTableToList(DataTable dt)
{
List <SeoWebSite.Model.Odds> modelList = new List <SeoWebSite.Model.Odds>();
int rowsCount = dt.Rows.Count;
if (rowsCount > 0)
{
SeoWebSite.Model.Odds model;
for (int n = 0; n < rowsCount; n++)
{
model = new SeoWebSite.Model.Odds();
if (dt.Rows[n]["id"] != null && dt.Rows[n]["id"].ToString() != "")
{
model.id = int.Parse(dt.Rows[n]["id"].ToString());
}
if (dt.Rows[n]["companyid"] != null && dt.Rows[n]["companyid"].ToString() != "")
{
model.companyid = int.Parse(dt.Rows[n]["companyid"].ToString());
}
if (dt.Rows[n]["s_win"] != null && dt.Rows[n]["s_win"].ToString() != "")
{
model.s_win = decimal.Parse(dt.Rows[n]["s_win"].ToString());
}
if (dt.Rows[n]["s_draw"] != null && dt.Rows[n]["s_draw"].ToString() != "")
{
model.s_draw = decimal.Parse(dt.Rows[n]["s_draw"].ToString());
}
if (dt.Rows[n]["s_lost"] != null && dt.Rows[n]["s_lost"].ToString() != "")
{
model.s_lost = decimal.Parse(dt.Rows[n]["s_lost"].ToString());
}
if (dt.Rows[n]["s_winper"] != null && dt.Rows[n]["s_winper"].ToString() != "")
{
model.s_winper = decimal.Parse(dt.Rows[n]["s_winper"].ToString());
}
if (dt.Rows[n]["s_drawper"] != null && dt.Rows[n]["s_drawper"].ToString() != "")
{
model.s_drawper = decimal.Parse(dt.Rows[n]["s_drawper"].ToString());
}
if (dt.Rows[n]["s_lostper"] != null && dt.Rows[n]["s_lostper"].ToString() != "")
{
model.s_lostper = decimal.Parse(dt.Rows[n]["s_lostper"].ToString());
}
if (dt.Rows[n]["s_return"] != null && dt.Rows[n]["s_return"].ToString() != "")
{
model.s_return = decimal.Parse(dt.Rows[n]["s_return"].ToString());
}
if (dt.Rows[n]["e_win"] != null && dt.Rows[n]["e_win"].ToString() != "")
{
model.e_win = decimal.Parse(dt.Rows[n]["e_win"].ToString());
}
if (dt.Rows[n]["e_draw"] != null && dt.Rows[n]["e_draw"].ToString() != "")
{
model.e_draw = decimal.Parse(dt.Rows[n]["e_draw"].ToString());
}
if (dt.Rows[n]["e_lost"] != null && dt.Rows[n]["e_lost"].ToString() != "")
{
model.e_lost = decimal.Parse(dt.Rows[n]["e_lost"].ToString());
}
if (dt.Rows[n]["e_winper"] != null && dt.Rows[n]["e_winper"].ToString() != "")
{
model.e_winper = decimal.Parse(dt.Rows[n]["e_winper"].ToString());
}
if (dt.Rows[n]["e_drawper"] != null && dt.Rows[n]["e_drawper"].ToString() != "")
{
model.e_drawper = decimal.Parse(dt.Rows[n]["e_drawper"].ToString());
}
if (dt.Rows[n]["e_lostper"] != null && dt.Rows[n]["e_lostper"].ToString() != "")
{
model.e_lostper = decimal.Parse(dt.Rows[n]["e_lostper"].ToString());
}
if (dt.Rows[n]["e_return"] != null && dt.Rows[n]["e_return"].ToString() != "")
{
model.e_return = decimal.Parse(dt.Rows[n]["e_return"].ToString());
}
if (dt.Rows[n]["winkelly"] != null && dt.Rows[n]["winkelly"].ToString() != "")
{
model.winkelly = decimal.Parse(dt.Rows[n]["winkelly"].ToString());
}
if (dt.Rows[n]["drawkelly"] != null && dt.Rows[n]["drawkelly"].ToString() != "")
{
model.drawkelly = decimal.Parse(dt.Rows[n]["drawkelly"].ToString());
}
if (dt.Rows[n]["lostkelly"] != null && dt.Rows[n]["lostkelly"].ToString() != "")
{
model.lostkelly = decimal.Parse(dt.Rows[n]["lostkelly"].ToString());
}
if (dt.Rows[n]["lastupdatetime"] != null && dt.Rows[n]["lastupdatetime"].ToString() != "")
{
model.lastupdatetime = DateTime.Parse(dt.Rows[n]["lastupdatetime"].ToString());
}
modelList.Add(model);
}
}
return(modelList);
}