private void queryOddsCountBZ() { if (Request["rowData"] != null && Request["blur"] != null) { SeoWebSite.BLL.odds_bz odds_bzbll = new SeoWebSite.BLL.odds_bz(); JArray rowData = JArray.Parse(Request.Form["rowData"]); List <string> oddsList = new List <string>(); foreach (JObject item in rowData) { if (!string.IsNullOrEmpty((string)item["baa"]) && !string.IsNullOrEmpty((string)item["bab"]) && !string.IsNullOrEmpty((string)item["bac"]) && !string.IsNullOrEmpty((string)item["bba"]) && !string.IsNullOrEmpty((string)item["bbb"]) && !string.IsNullOrEmpty((string)item["bbc"])) { string[] sa = { (string)item["baa"], (string)item["bab"], (string)item["bac"], (string)item["bba"], (string)item["bbb"], (string)item["bbc"], item["companyid"].ToString() }; oddsList.Add(string.Join(",", sa)); } } JArray data1 = new JArray(); JArray data2 = new JArray(); JObject obj = JObject.Parse("{blur:" + Request.Form["blur"] + "}"); DataSet ds = odds_bzbll.queryOddsCount(oddsList, float.Parse(Request.Form["blur"]), Convert.ToInt32(Request.Form["scheduleType"])); int totalCount = int.Parse(ds.Tables[0].Rows[0]["totalCount"].ToString()); if (totalCount > 0) { obj.Add("bzscount1", ds.Tables[0].Rows[0][0].ToString()); obj.Add("bzpcount1", ds.Tables[0].Rows[0][1].ToString()); obj.Add("bzfcount1", ds.Tables[0].Rows[0][2].ToString()); obj.Add("totalCount1", totalCount); } JArray data = new JArray(); data.Add(obj); responseText = "{success:true,data:" + data.ToString() + "}"; } }
private void queryOddsBZ() { if (Request["odds"] != null) { JObject result = new JObject(); JArray oddsArray = JArray.Parse(Request.Form["odds"]); int totalCount = 0; DataSet ds = null; DataTable dt = null; SeoWebSite.BLL.odds_bz odds_bzbll = new SeoWebSite.BLL.odds_bz(); foreach (JObject item in oddsArray) { ds = odds_bzbll.GetList(item["companyid"].ToString().Replace("\"", ""), new string[] { (string)item["home1"], (string)item["draw1"], (string)item["away1"], (string)item["home2"], (string)item["draw2"], (string)item["away2"] }); if (ds.Tables[0].Rows.Count > 0) { if (dt == null) { dt = ds.Tables[0]; } else { foreach (DataRow dr in ds.Tables[0].Rows) { dt.ImportRow(dr); } } } } if (dt.Rows.Count > 0) { dt.Columns.Add("victory"); foreach (DataRow dr in dt.Rows) { int score = (int)dr["home"] - (int)dr["away"]; if (score > 0) { dr["victory"] = 3; } else if (score == 0) { dr["victory"] = 1; } else { dr["victory"] = 0; } } } result.Add("success", true); result.Add("totalCount", totalCount); string javascriptJson = JsonConvert.SerializeObject(dt, new JavaScriptDateTimeConverter()); responseText = "{success:true,totalCount:" + totalCount + ",data:" + javascriptJson + "}"; } }
private void queryOddsPerRQ() { if (Request["rowData"] != null) { SeoWebSite.BLL.odds_rq odds_rqbll = new SeoWebSite.BLL.odds_rq(); SeoWebSite.BLL.odds_bz odds_bzbll = new SeoWebSite.BLL.odds_bz(); JArray rowData = JArray.Parse(Request.Form["rowData"]); List<string> oddsList = new List<string>(); List<string> oddsList1 = new List<string>(); foreach (JObject item in rowData) { if (!string.IsNullOrEmpty((string)item["aaa"]) && !string.IsNullOrEmpty((string)item["aab"]) && !string.IsNullOrEmpty((string)item["aac"]) && !string.IsNullOrEmpty((string)item["aba"]) && !string.IsNullOrEmpty((string)item["abb"]) && !string.IsNullOrEmpty((string)item["abc"])) { string[] sa = { (string)item["aaa"], (string)item["aab"], (string)item["aac"], (string)item["aba"], (string)item["abb"], (string)item["abc"], item["companyid"].ToString() }; oddsList.Add(string.Join(",", sa)); } if (!string.IsNullOrEmpty((string)item["baa"]) && !string.IsNullOrEmpty((string)item["bab"]) && !string.IsNullOrEmpty((string)item["bac"]) && !string.IsNullOrEmpty((string)item["bba"]) && !string.IsNullOrEmpty((string)item["bbb"]) && !string.IsNullOrEmpty((string)item["bbc"])) { string[] sa = { (string)item["baa"], (string)item["bab"], (string)item["bac"], (string)item["bba"], (string)item["bbb"], (string)item["bbc"], item["companyid"].ToString() }; oddsList1.Add(string.Join(",", sa)); } } DataTable dt = odds_rqbll.queryCompanyOddsPer(oddsList, 0,0); DataTable dt1 = odds_bzbll.queryCompanyOddsPer(oddsList1, 0, 0); DataTable data = new DataTable(); data.Columns.Add("id", typeof(int)); data.Columns.Add("name", typeof(string)); data.Columns.Add("rqyper", typeof(float)); data.Columns.Add("rqzper", typeof(float)); data.Columns.Add("rqsper", typeof(float)); data.Columns.Add("diffper", typeof(float)); data.Columns.Add("suggest", typeof(int)); DataRow dr = data.NewRow(); dr["id"] = 1; dr["name"] = "亚赔支持平均"; dr["rqyper"] = dt.Compute("avg(rqy)", "1=1"); dr["rqzper"] = dt.Compute("avg(rqz)", "1=1"); dr["rqsper"] = dt.Compute("avg(rqs)", "1=1"); dr["diffper"] = Convert.ToInt32(dt.Compute("avg(rqy)", "1=1")) - Convert.ToInt32(dt.Compute("avg(rqs)", "1=1")); dr["suggest"] = 25; data.Rows.Add(dr); dr = data.NewRow(); dr["id"] = 2; dr["name"] = "亚赔支持最大"; dr["rqyper"] = dt.Compute("max(rqy)", "1=1"); dr["rqzper"] = dt.Compute("max(rqz)", "1=1"); dr["rqsper"] = dt.Compute("max(rqs)", "1=1"); dr["diffper"] = Convert.ToInt32(dt.Compute("max(rqy)", "1=1")) - Convert.ToInt32(dt.Compute("max(rqs)", "1=1")); dr["suggest"] = 40; data.Rows.Add(dr); double ycount = Convert.ToDouble(dt.Compute("count(rqy)", "rqy > rqs")); double scount = Convert.ToDouble(dt.Compute("count(rqy)", "rqy < rqs")); dr = data.NewRow(); dr["id"] = 3; dr["name"] = "亚赔支持数量"; dr["rqyper"] = ycount / (ycount + scount) * 100; dr["rqzper"] = 0; dr["rqsper"] = scount / (ycount + scount) * 100; dr["diffper"] = ycount / (ycount + scount) * 100 - scount / (ycount + scount) * 100; dr["suggest"] = 80; data.Rows.Add(dr); dr = data.NewRow(); dr["id"] = 4; dr["name"] = "欧赔支持平均"; dr["rqyper"] = dt1.Compute("avg(rqy)", "1=1"); dr["rqzper"] = dt1.Compute("avg(rqz)", "1=1"); dr["rqsper"] = dt1.Compute("avg(rqs)", "1=1"); dr["diffper"] = Convert.ToInt32(dt1.Compute("avg(rqy)", "1=1")) - Convert.ToInt32(dt1.Compute("avg(rqs)", "1=1")); dr["suggest"] = 40; data.Rows.Add(dr); dr = data.NewRow(); dr["id"] = 5; dr["name"] = "欧赔支持最大"; dr["rqyper"] = dt1.Compute("max(rqy)", "1=1"); dr["rqzper"] = dt1.Compute("max(rqz)", "1=1"); dr["rqsper"] = dt1.Compute("max(rqs)", "1=1"); dr["diffper"] = Convert.ToInt32(dt1.Compute("max(rqy)", "1=1")) - Convert.ToInt32(dt1.Compute("max(rqs)", "1=1")); dr["suggest"] = 40; data.Rows.Add(dr); double ycount1 = Convert.ToDouble(dt1.Compute("count(rqy)", "rqy > rqs")); double scount1 = Convert.ToDouble(dt1.Compute("count(rqy)", "rqy < rqs")); dr = data.NewRow(); dr["id"] = 6; dr["name"] = "欧赔支持数量"; dr["rqyper"] = ycount1 / (ycount1 + scount1) * 100; dr["rqzper"] = 0; dr["rqsper"] = scount1 / (ycount1 + scount1) * 100; dr["diffper"] = ycount1 / (ycount1 + scount1) * 100 - scount1 / (ycount1 + scount1) * 100; dr["suggest"] = 80; data.Rows.Add(dr); responseText = "{success:true,data:" + JArray.FromObject(data) + "}"; } }
private void queryOddsCountBZ() { if (Request["rowData"] != null && Request["blur"] != null) { SeoWebSite.BLL.odds_bz odds_bzbll = new SeoWebSite.BLL.odds_bz(); JArray rowData = JArray.Parse(Request.Form["rowData"]); List<string> oddsList = new List<string>(); foreach (JObject item in rowData) { if (!string.IsNullOrEmpty((string)item["baa"]) && !string.IsNullOrEmpty((string)item["bab"]) && !string.IsNullOrEmpty((string)item["bac"]) && !string.IsNullOrEmpty((string)item["bba"]) && !string.IsNullOrEmpty((string)item["bbb"]) && !string.IsNullOrEmpty((string)item["bbc"])) { string[] sa = { (string)item["baa"], (string)item["bab"], (string)item["bac"], (string)item["bba"], (string)item["bbb"], (string)item["bbc"], item["companyid"].ToString() }; oddsList.Add(string.Join(",", sa)); } } JArray data1 = new JArray(); JArray data2 = new JArray(); JObject obj = JObject.Parse("{blur:" + Request.Form["blur"] + "}"); DataSet ds = odds_bzbll.queryOddsCount(oddsList, float.Parse(Request.Form["blur"]), Convert.ToInt32(Request.Form["scheduleType"])); int totalCount = int.Parse(ds.Tables[0].Rows[0]["totalCount"].ToString()); if (totalCount > 0) { obj.Add("bzscount1", ds.Tables[0].Rows[0][0].ToString()); obj.Add("bzpcount1", ds.Tables[0].Rows[0][1].ToString()); obj.Add("bzfcount1", ds.Tables[0].Rows[0][2].ToString()); obj.Add("totalCount1", totalCount); } JArray data = new JArray(); data.Add(obj); responseText = "{success:true,data:" + data.ToString() + "}"; } }
private void queryOddsBZ() { if (Request["odds"] != null) { JObject result = new JObject(); JArray oddsArray = JArray.Parse(Request.Form["odds"]); int totalCount = 0; DataSet ds = null; DataTable dt = null; SeoWebSite.BLL.odds_bz odds_bzbll = new SeoWebSite.BLL.odds_bz(); foreach (JObject item in oddsArray) { ds = odds_bzbll.GetList(item["companyid"].ToString().Replace("\"", ""), new string[] { (string)item["home1"], (string)item["draw1"], (string)item["away1"], (string)item["home2"], (string)item["draw2"], (string)item["away2"] }); if (ds.Tables[0].Rows.Count > 0) { if (dt == null) { dt = ds.Tables[0]; } else { foreach (DataRow dr in ds.Tables[0].Rows) dt.ImportRow(dr); } } } if (dt.Rows.Count > 0) { dt.Columns.Add("victory"); foreach (DataRow dr in dt.Rows) { int score = (int)dr["home"] - (int)dr["away"]; if (score > 0) { dr["victory"] = 3; } else if (score == 0) { dr["victory"] = 1; } else { dr["victory"] = 0; } } } result.Add("success", true); result.Add("totalCount", totalCount); string javascriptJson = JsonConvert.SerializeObject(dt, new JavaScriptDateTimeConverter()); responseText = "{success:true,totalCount:" + totalCount + ",data:" + javascriptJson + "}"; } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { ScheduleBLL schedulebll = new ScheduleBLL(); odds_rq rqbll = new odds_rq(); odds_bz bzbll = new odds_bz(); DataSet schedule = DbHelperSQL.Query("select top 200 id,scheduletypeid,Data,Date,home,away FROM Schedule where updated=1 order by id desc"); List<int> companyidList = new List<int>(); foreach (DataRow dr in schedule.Tables[0].Rows) { DataSet odds = DbHelperSQL.Query("select a.companyid, a.home aaa,a.pankou aab,a.away aac,b.home aba,b.pankou abb,b.away abc from tempdb..TempTable_Companys_Chupan_RQ a join tempdb..TempTable_Companys_Zhongpan_RQ b on a.scheduleid=b.scheduleid and a.companyid=b.companyid where a.scheduleid=" + dr["id"]); List<string> oddsList = new List<string>(); foreach (DataRow item in odds.Tables[0].Rows) { string[] sa = { item["aaa"].ToString(), item["aab"].ToString(), item["aac"].ToString(), item["aba"].ToString(), item["abb"].ToString(), item["abc"].ToString(), item["companyid"].ToString() }; oddsList.Add(string.Join(",", sa)); companyidList.Add(Convert.ToInt32(item["companyid"])); } if (oddsList.Count > 0) { //DataTable dt = rqbll.queryOddsPer(oddsList, 0.02f, 0, Convert.ToInt32(dr["id"])); //DataTable dt = rqbll.queryCompanyOddsPer(oddsList, 0, Convert.ToInt32(dr["id"])); DataTable dt = bzbll.queryCompanyOddsPer(oddsList, 0, Convert.ToInt32(dr["id"])); //DataTable dt = rqbll.queryCompanyOddsPer1(Convert.ToInt32(dr["scheduletypeid"]), Convert.ToInt32(dr["id"]), companyidList); try { double pankou = Convert.ToDouble(odds.Tables[0].Rows[0]["aab"]); if (dt.Rows.Count > 0) { if (Math.Abs(Convert.ToInt32(dt.Compute("avg(rqy)", "1=1")) - Convert.ToInt32(dt.Compute("avg(rqs)", "1=1"))) > 10) { if (Convert.ToInt32(dt.Compute("avg(rqy)", "1=1")) - Convert.ToInt32(dt.Compute("avg(rqs)", "1=1")) > 10 && Convert.ToInt32(dr["home"]) - Convert.ToInt32(dr["away"]) > pankou) { winCount++; } else if (Convert.ToInt32(dt.Compute("avg(rqy)", "1=1")) - Convert.ToInt32(dt.Compute("avg(rqs)", "1=1")) < 10 && Convert.ToInt32(dr["home"]) - Convert.ToInt32(dr["away"]) < pankou) { winCount++; } totalCount++; } if (Math.Abs(Convert.ToInt32(dt.Compute("max(rqy)", "1=1")) - Convert.ToInt32(dt.Compute("max(rqs)", "1=1"))) > 0) { if (Convert.ToInt32(dt.Compute("max(rqy)", "1=1")) - Convert.ToInt32(dt.Compute("max(rqs)", "1=1")) > 0 && Convert.ToInt32(dr["home"]) - Convert.ToInt32(dr["away"]) > pankou) { winCount1++; } else if (Convert.ToInt32(dt.Compute("max(rqy)", "1=1")) - Convert.ToInt32(dt.Compute("max(rqs)", "1=1")) < 0 && Convert.ToInt32(dr["home"]) - Convert.ToInt32(dr["away"]) < pankou) { winCount1++; } totalCount1++; } double ycount = Convert.ToDouble(dt.Compute("count(rqy)", "rqy > rqs")); double scount = Convert.ToDouble(dt.Compute("count(rqy)", "rqy < rqs")); if (ycount + scount > 0) { if (ycount / (ycount + scount) > 0.7d || scount / (ycount + scount) > 0.7d) { if (ycount / (ycount + scount) > 0.7d && Convert.ToInt32(dr["home"]) - Convert.ToInt32(dr["away"]) > pankou) { winCount2++; } else if (scount / (ycount + scount) > 0.7d && Convert.ToInt32(dr["home"]) - Convert.ToInt32(dr["away"]) < pankou) { winCount2++; } totalCount2++; } } if (Convert.ToInt32(dt.Compute("max(rqy)", "1=1")) - Convert.ToInt32(dt.Compute("max(rqs)", "1=1")) < 0 && Convert.ToInt32(dt.Compute("count(rqy)", "rqy > rqs")) - Convert.ToInt32(dt.Compute("count(rqy)", "rqy < rqs")) >= 10) { if (Convert.ToInt32(dr["home"]) - Convert.ToInt32(dr["away"]) > pankou) { winCount3++; } totalCount3++; } else if (Convert.ToInt32(dt.Compute("max(rqy)", "1=1")) - Convert.ToInt32(dt.Compute("max(rqs)", "1=1")) >0 && Convert.ToInt32(dt.Compute("count(rqy)", "rqy > rqs")) - Convert.ToInt32(dt.Compute("count(rqy)", "rqy < rqs")) <= 10) { if (Convert.ToInt32(dr["home"]) - Convert.ToInt32(dr["away"]) < pankou) { winCount3++; } totalCount3++; } } //DataSet ds = rqbll.queryOddsCount(oddsList, 0.05f, 0, Convert.ToInt32(dr["id"]));//Convert.ToInt32(dr["scheduleTypeid"]) //if (ds != null && Convert.ToInt32(ds.Tables[0].Rows[0]["totalCount"]) > 0) //{ // int diff = Convert.ToInt32(ds.Tables[0].Rows[0][0]) - Convert.ToInt32(ds.Tables[0].Rows[0][2]); // //if (Math.Abs(diff) >= 5 && Math.Min(Convert.ToInt32(ds.Tables[0].Rows[0][0]), Convert.ToInt32(ds.Tables[0].Rows[0][2])) == 0) // //{ // if (diff > 0 && Convert.ToInt32(dr["home"]) - Convert.ToInt32(dr["away"]) > pankou) // { // winCount3++; // } // else if (diff < 0 && Convert.ToInt32(dr["home"]) - Convert.ToInt32(dr["away"]) < pankou) // { // winCount3++; // } // totalCount3++; // //} //} } catch (Exception) { throw; } } } } }
private void queryOddsPerRQ() { if (Request["rowData"] != null) { SeoWebSite.BLL.odds_rq odds_rqbll = new SeoWebSite.BLL.odds_rq(); SeoWebSite.BLL.odds_bz odds_bzbll = new SeoWebSite.BLL.odds_bz(); JArray rowData = JArray.Parse(Request.Form["rowData"]); List <string> oddsList = new List <string>(); List <string> oddsList1 = new List <string>(); foreach (JObject item in rowData) { if (!string.IsNullOrEmpty((string)item["aaa"]) && !string.IsNullOrEmpty((string)item["aab"]) && !string.IsNullOrEmpty((string)item["aac"]) && !string.IsNullOrEmpty((string)item["aba"]) && !string.IsNullOrEmpty((string)item["abb"]) && !string.IsNullOrEmpty((string)item["abc"])) { string[] sa = { (string)item["aaa"], (string)item["aab"], (string)item["aac"], (string)item["aba"], (string)item["abb"], (string)item["abc"], item["companyid"].ToString() }; oddsList.Add(string.Join(",", sa)); } if (!string.IsNullOrEmpty((string)item["baa"]) && !string.IsNullOrEmpty((string)item["bab"]) && !string.IsNullOrEmpty((string)item["bac"]) && !string.IsNullOrEmpty((string)item["bba"]) && !string.IsNullOrEmpty((string)item["bbb"]) && !string.IsNullOrEmpty((string)item["bbc"])) { string[] sa = { (string)item["baa"], (string)item["bab"], (string)item["bac"], (string)item["bba"], (string)item["bbb"], (string)item["bbc"], item["companyid"].ToString() }; oddsList1.Add(string.Join(",", sa)); } } DataTable dt = odds_rqbll.queryCompanyOddsPer(oddsList, 0, 0); DataTable dt1 = odds_bzbll.queryCompanyOddsPer(oddsList1, 0, 0); DataTable data = new DataTable(); data.Columns.Add("id", typeof(int)); data.Columns.Add("name", typeof(string)); data.Columns.Add("rqyper", typeof(float)); data.Columns.Add("rqzper", typeof(float)); data.Columns.Add("rqsper", typeof(float)); data.Columns.Add("diffper", typeof(float)); data.Columns.Add("suggest", typeof(int)); DataRow dr = data.NewRow(); dr["id"] = 1; dr["name"] = "亚赔支持平均"; dr["rqyper"] = dt.Compute("avg(rqy)", "1=1"); dr["rqzper"] = dt.Compute("avg(rqz)", "1=1"); dr["rqsper"] = dt.Compute("avg(rqs)", "1=1"); dr["diffper"] = Convert.ToInt32(dt.Compute("avg(rqy)", "1=1")) - Convert.ToInt32(dt.Compute("avg(rqs)", "1=1")); dr["suggest"] = 25; data.Rows.Add(dr); dr = data.NewRow(); dr["id"] = 2; dr["name"] = "亚赔支持最大"; dr["rqyper"] = dt.Compute("max(rqy)", "1=1"); dr["rqzper"] = dt.Compute("max(rqz)", "1=1"); dr["rqsper"] = dt.Compute("max(rqs)", "1=1"); dr["diffper"] = Convert.ToInt32(dt.Compute("max(rqy)", "1=1")) - Convert.ToInt32(dt.Compute("max(rqs)", "1=1")); dr["suggest"] = 40; data.Rows.Add(dr); double ycount = Convert.ToDouble(dt.Compute("count(rqy)", "rqy > rqs")); double scount = Convert.ToDouble(dt.Compute("count(rqy)", "rqy < rqs")); dr = data.NewRow(); dr["id"] = 3; dr["name"] = "亚赔支持数量"; dr["rqyper"] = ycount / (ycount + scount) * 100; dr["rqzper"] = 0; dr["rqsper"] = scount / (ycount + scount) * 100; dr["diffper"] = ycount / (ycount + scount) * 100 - scount / (ycount + scount) * 100; dr["suggest"] = 80; data.Rows.Add(dr); dr = data.NewRow(); dr["id"] = 4; dr["name"] = "欧赔支持平均"; dr["rqyper"] = dt1.Compute("avg(rqy)", "1=1"); dr["rqzper"] = dt1.Compute("avg(rqz)", "1=1"); dr["rqsper"] = dt1.Compute("avg(rqs)", "1=1"); dr["diffper"] = Convert.ToInt32(dt1.Compute("avg(rqy)", "1=1")) - Convert.ToInt32(dt1.Compute("avg(rqs)", "1=1")); dr["suggest"] = 40; data.Rows.Add(dr); dr = data.NewRow(); dr["id"] = 5; dr["name"] = "欧赔支持最大"; dr["rqyper"] = dt1.Compute("max(rqy)", "1=1"); dr["rqzper"] = dt1.Compute("max(rqz)", "1=1"); dr["rqsper"] = dt1.Compute("max(rqs)", "1=1"); dr["diffper"] = Convert.ToInt32(dt1.Compute("max(rqy)", "1=1")) - Convert.ToInt32(dt1.Compute("max(rqs)", "1=1")); dr["suggest"] = 40; data.Rows.Add(dr); double ycount1 = Convert.ToDouble(dt1.Compute("count(rqy)", "rqy > rqs")); double scount1 = Convert.ToDouble(dt1.Compute("count(rqy)", "rqy < rqs")); dr = data.NewRow(); dr["id"] = 6; dr["name"] = "欧赔支持数量"; dr["rqyper"] = ycount1 / (ycount1 + scount1) * 100; dr["rqzper"] = 0; dr["rqsper"] = scount1 / (ycount1 + scount1) * 100; dr["diffper"] = ycount1 / (ycount1 + scount1) * 100 - scount1 / (ycount1 + scount1) * 100; dr["suggest"] = 80; data.Rows.Add(dr); responseText = "{success:true,data:" + JArray.FromObject(data) + "}"; } }