/// <summary>
/// 获得数据列表
/// </summary>
public List <SeoWebSite.Model.Company> DataTableToList(DataTable dt)
{
List <SeoWebSite.Model.Company> modelList = new List <SeoWebSite.Model.Company>();
int rowsCount = dt.Rows.Count;
if (rowsCount > 0)
{
SeoWebSite.Model.Company model;
for (int n = 0; n < rowsCount; n++)
{
model = new SeoWebSite.Model.Company();
if (dt.Rows[n]["id"] != null && dt.Rows[n]["id"].ToString() != "")
{
model.id = int.Parse(dt.Rows[n]["id"].ToString());
}
if (dt.Rows[n]["fullname"] != null && dt.Rows[n]["fullname"].ToString() != "")
{
model.fullname = dt.Rows[n]["fullname"].ToString();
}
if (dt.Rows[n]["name"] != null && dt.Rows[n]["name"].ToString() != "")
{
model.name = dt.Rows[n]["name"].ToString();
}
if (dt.Rows[n]["isprimary"] != null && dt.Rows[n]["isprimary"].ToString() != "")
{
if ((dt.Rows[n]["isprimary"].ToString() == "1") || (dt.Rows[n]["isprimary"].ToString().ToLower() == "true"))
{
model.isprimary = true;
}
else
{
model.isprimary = false;
}
}
if (dt.Rows[n]["isexchange"] != null && dt.Rows[n]["isexchange"].ToString() != "")
{
if ((dt.Rows[n]["isexchange"].ToString() == "1") || (dt.Rows[n]["isexchange"].ToString().ToLower() == "true"))
{
model.isexchange = true;
}
else
{
model.isexchange = false;
}
}
modelList.Add(model);
}
}
return(modelList);
}
/// <summary>
/// 获得数据列表
/// </summary>
public List<SeoWebSite.Model.Company> DataTableToList(DataTable dt)
{
List<SeoWebSite.Model.Company> modelList = new List<SeoWebSite.Model.Company>();
int rowsCount = dt.Rows.Count;
if (rowsCount > 0)
{
SeoWebSite.Model.Company model;
for (int n = 0; n < rowsCount; n++)
{
model = new SeoWebSite.Model.Company();
if(dt.Rows[n]["id"]!=null && dt.Rows[n]["id"].ToString()!="")
{
model.id=int.Parse(dt.Rows[n]["id"].ToString());
}
if(dt.Rows[n]["fullname"]!=null && dt.Rows[n]["fullname"].ToString()!="")
{
model.fullname=dt.Rows[n]["fullname"].ToString();
}
if(dt.Rows[n]["name"]!=null && dt.Rows[n]["name"].ToString()!="")
{
model.name=dt.Rows[n]["name"].ToString();
}
if(dt.Rows[n]["isprimary"]!=null && dt.Rows[n]["isprimary"].ToString()!="")
{
if((dt.Rows[n]["isprimary"].ToString()=="1")||(dt.Rows[n]["isprimary"].ToString().ToLower()=="true"))
{
model.isprimary=true;
}
else
{
model.isprimary=false;
}
}
if(dt.Rows[n]["isexchange"]!=null && dt.Rows[n]["isexchange"].ToString()!="")
{
if((dt.Rows[n]["isexchange"].ToString()=="1")||(dt.Rows[n]["isexchange"].ToString().ToLower()=="true"))
{
model.isexchange=true;
}
else
{
model.isexchange=false;
}
}
modelList.Add(model);
}
}
return modelList;
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(SeoWebSite.Model.Company model)
{
return(dal.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public void Add(SeoWebSite.Model.Company model)
{
dal.Add(model);
}
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));
}
}
}
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));
}
}
}
}