Exemplo n.º 1
0
    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() + "}";
        }
    }
Exemplo n.º 2
0
 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 + "}";
     }
 }
Exemplo n.º 3
0
    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) + "}";
        }
    }
Exemplo n.º 4
0
    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() + "}";
        }
    }
Exemplo n.º 5
0
 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 + "}";
     }
 }
Exemplo n.º 6
0
    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;
                    }
                }

            }
        }
    }
Exemplo n.º 7
0
    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) + "}";
        }
    }