private void queryOddsHistory()
{
if (Request["rowindex"] != null)
{
string strWhere = "";
string cclassid = "";
string sclassid = "";
int rowindex = Convert.ToInt32(Request.Form["rowindex"]);
if (rowindex % 2 == 0)
{
strWhere = Common.DataCache.GetCache("swhere").ToString();
}
else
{
strWhere = Common.DataCache.GetCache("ewhere").ToString();
}
if (rowindex == 2 || rowindex == 3)
{
cclassid = Common.DataCache.GetCache("cclassid").ToString();
}
else if (rowindex == 4 || rowindex == 5)
{
sclassid = Common.DataCache.GetCache("sclassid").ToString();
}
DataSet ds = scheduleBLL.queryOddsHistory(cclassid, sclassid, strWhere);
JArray data = new JArray();
if (ds.Tables[0].Rows.Count > 0)
{
string[] Cookie = Request.Cookies["Cookie"].Value.Split('^');
foreach (DataRow dr in ds.Tables[0].Rows)
{
string[] scheduleArr = dr["sdata"].ToString().Split(',');
string[] scheduleClassArr = dr["sclass"].ToString().Split(',');
JObject row = new JObject();
row.Add("s_time", scheduleArr[10].Replace("<br>", " "));
row.Add("league", scheduleClassArr[1]);
row.Add("bgcolor", scheduleClassArr[4]);
row.Add("h_teamname", scheduleArr[4]);
row.Add("g_teamname", scheduleArr[7]);
row.Add("score", scheduleArr[13] + "-" + scheduleArr[14]);
row.Add("half", scheduleArr[15] + "-" + scheduleArr[16]);
row.Add("rangqiu", scheduleArr[25]);
if (!string.IsNullOrEmpty(scheduleArr[25]))
{
double numResult = Convert.ToDouble(scheduleArr[13]) - Convert.ToDouble(scheduleArr[14]) - Convert.ToDouble(scheduleArr[25]);
row.Add("numResult", numResult);
}
row.Add("scount", dr["scount"].ToString());
data.Add(row);
}
}
JObject result = JObject.Parse("{success:true}");
result.Add("data", data);
StringJSON = result.ToString();
}
}