예제 #1
0
        private void statOddsHistory1()
        {
            if (Request["stypeid"] != null && Request["oddsarr"] != null)
            {
                string[]      sclassArr   = Request.Form["stypeid"].Split('^');
                string[]      oddsArr     = Request.Form["oddsarr"].Split('^');
                string[]      scheduleArr = Request.Form["schedulearr"].Split('^');
                string[]      oddsInfo    = Request.Form["odds"].Split(',');
                List <string> swhereList  = new List <string>();
                List <string> ewhereList  = new List <string>();
                foreach (string oddsStr in oddsArr)
                {
                    string[] odds = oddsStr.Split('|');
                    swhereList.Add("(companyid=" + odds[0] + " and s_win=" + odds[3] +
                                   " and s_draw=" + odds[4] + " and s_lost=" + odds[5] + ")");
                    if (!String.IsNullOrEmpty(odds[10]) && !String.IsNullOrEmpty(odds[11]) && !String.IsNullOrEmpty(odds[12]))
                    {
                        ewhereList.Add("(companyid=" + odds[0] + " and (e_win=" + odds[10] +
                                       ") and (e_draw=" + odds[11] + ") and (e_lost=" + odds[12] + "))");
                    }
                }
                string swhereStr = "(" + String.Join(" or ", swhereList.ToArray()) + ")";
                string ewhereStr = "(" + String.Join(" or ", ewhereList.ToArray()) + ")";

                switch (Request.Form["query"])
                {
                case "2":
                    swhereStr += " and c.cclassid=" + sclassArr[9];
                    ewhereStr += " and c.cclassid=" + sclassArr[9];
                    break;

                case "3":
                    swhereStr += " and a.sclassid=" + sclassArr[0];
                    ewhereStr += " and a.sclassid=" + sclassArr[0];
                    break;

                default:
                    break;
                }
                //DataTable dt = scheduleBLL.queryCompanyHistory(1, swhereStr, 300).Tables[0];
                //if (ewhereList.Count > 0)
                //{
                //    DataTable dt1 = scheduleBLL.queryCompanyHistory(2, ewhereStr, 200).Tables[0];
                //    dt.Merge(dt1);
                //}
                DataTable dt = scheduleBLL.queryCompanyHistory(2, ewhereStr, 100).Tables[0];
                dt.Columns.Add("time", typeof(DateTime));
                dt.Columns.Add("w", typeof(decimal));
                dt.Columns.Add("d", typeof(decimal));
                dt.Columns.Add("l", typeof(decimal));
                foreach (DataRow dr in dt.Rows)
                {
                    foreach (string oddsStr in oddsArr)
                    {
                        string[] odds = oddsStr.Split('|');
                        if (dr["companyid"].ToString() == odds[0])
                        {
                            string[] timeArr = odds[20].Split(',');
                            dr.SetField("time", 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));
                            if (dr["type"].ToString() == "1")
                            {
                                dr.SetField("swin", Convert.ToDecimal(dr["swin"]) - Convert.ToDecimal(odds[6]));
                                dr.SetField("sdraw", Convert.ToDecimal(dr["sdraw"]) - Convert.ToDecimal(odds[7]));
                                dr.SetField("slost", Convert.ToDecimal(dr["slost"]) - Convert.ToDecimal(odds[8]));
                            }
                            else
                            {
                                decimal[] decimalArr = new decimal[] {
                                    Convert.ToDecimal(dr["swin"]) - Convert.ToDecimal(odds[13]),
                                    Convert.ToDecimal(dr["sdraw"]) - Convert.ToDecimal(odds[14]),
                                    Convert.ToDecimal(dr["slost"]) - Convert.ToDecimal(odds[15])
                                };
                                dr.SetField("swin", decimalArr[0]);
                                dr.SetField("sdraw", decimalArr[1]);
                                dr.SetField("slost", decimalArr[2]);
                            }
                        }
                    }
                }
                JsonSerializer serializer = new JsonSerializer();
                serializer.Converters.Add(new JavaScriptDateTimeConverter());
                serializer.NullValueHandling = NullValueHandling.Ignore;
                Response.Write(JArray.FromObject(dt, serializer));
            }
        }
예제 #2
0
    private void SendMessageByMail()
    {
        if (Request["stypeid"] != null && Request["oddsarr"] != null)
        {
            string[]      sclassArr   = Request.Form["stypeid"].Split('^');
            string[]      oddsArr     = Request.Form["oddsarr"].Split('^');
            string[]      scheduleArr = Request.Form["schedulearr"].Split('^');
            string[]      oddsInfo    = Request.Form["odds"].Split(',');
            List <string> swhereList  = new List <string>();
            List <string> ewhereList  = new List <string>();
            foreach (string oddsStr in oddsArr)
            {
                string[] odds = oddsStr.Split('|');
                swhereList.Add("(companyid=" + odds[0] + " and s_win=" + odds[3] +
                               " and s_draw=" + odds[4] + " and s_lost=" + odds[5] + ")");
                if (!String.IsNullOrEmpty(odds[10]) && !String.IsNullOrEmpty(odds[11]) && !String.IsNullOrEmpty(odds[12]))
                {
                    ewhereList.Add("(companyid=" + odds[0] + " and (e_win=" + odds[10] +
                                   ") and (e_draw=" + odds[11] + ") and (e_lost=" + odds[12] + "))");
                }
            }
            string swhereStr = "(" + String.Join(" or ", swhereList.ToArray()) + ")";
            string ewhereStr = "(" + String.Join(" or ", ewhereList.ToArray()) + ")";

            DataTable dt = scheduleBLL.queryCompanyHistory(2, ewhereStr, 100).Tables[0];
            dt.Columns.Add("time", typeof(DateTime));
            foreach (DataRow dr in dt.Rows)
            {
                foreach (string oddsStr in oddsArr)
                {
                    string[] odds = oddsStr.Split('|');
                    if (dr["companyid"].ToString() == odds[0])
                    {
                        string[] timeArr = odds[20].Split(',');
                        dr.SetField("time", 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));
                        if (dr["type"].ToString() == "2")
                        {
                            dr.SetField("swin", Convert.ToDecimal(dr["swin"]) - Convert.ToDecimal(odds[13]));
                            dr.SetField("sdraw", Convert.ToDecimal(dr["sdraw"]) - Convert.ToDecimal(odds[14]));
                            dr.SetField("slost", Convert.ToDecimal(dr["slost"]) - Convert.ToDecimal(odds[15]));
                        }
                    }
                }
            }

            bool          ismail = false;
            string        limit  = "type=2";
            List <double> avg    = new List <double>();
            List <double> max    = new List <double>();
            avg.Add(Convert.ToDouble(dt.Compute("avg(swin)", limit)));
            avg.Add(Convert.ToDouble(dt.Compute("avg(sdraw)", limit)));
            avg.Add(Convert.ToDouble(dt.Compute("avg(slost)", limit)));
            max.Add(Convert.ToDouble(dt.Compute("max(swin)", limit)));
            max.Add(Convert.ToDouble(dt.Compute("max(sdraw)", limit)));
            max.Add(Convert.ToDouble(dt.Compute("max(slost)", limit)));
            double x = 3;
            if (dt.Rows.Count > 2)
            {
                if (toInt(scheduleArr[13]) + toInt(scheduleArr[14]) == 0)
                {
                    if (!string.IsNullOrEmpty(oddsInfo[2]))
                    {
                        double rq = Convert.ToDouble(oddsInfo[2]);
                        if (Math.Abs(rq) < 1)
                        {
                            if (rq > 0)
                            {
                                ismail = avg[0] > x && max[1] < 0 && max[2] < 0 || avg[0] < -x || avg[0] == avg.Min() && (avg[1] > x || avg[2] > x);
                            }
                            else if (rq < 0)
                            {
                                ismail = avg[0] < 0 && max[1] < 0 && max[2] > x || avg[2] < -x || avg[2] == avg.Min() && (avg[0] > x || avg[1] > x);
                            }
                            else
                            {
                                ismail = avg[0] < -x || avg[2] < -x || avg[0] == avg.Min() && avg[2] > x || avg[0] > x && avg[2] == avg.Min();
                            }
                        }
                        else if (rq >= 1)
                        {
                            ismail = avg[0] < -x || avg[0] == avg.Min() && (avg[1] > x || avg[2] > x);
                        }
                        else if (rq <= -1)
                        {
                            ismail = avg[2] < -x || avg[2] == avg.Min() && (avg[0] > x || avg[1] > x);
                        }
                    }
                }
                else
                {
                    if (toInt(scheduleArr[13]) - toInt(scheduleArr[14]) > 0)
                    {
                        ismail = avg[0] < -x || avg[0] == avg.Min() && (avg[1] > x || avg[2] > x);
                    }
                    else if (toInt(scheduleArr[13]) - toInt(scheduleArr[14]) < 0)
                    {
                        ismail = avg[2] < -x || avg[2] == avg.Min() && (avg[0] > x || avg[1] > x);
                    }
                }
            }



            if (ismail)
            {
                NameValueCollection myCol = new NameValueCollection();
                for (int i = 0; i < scheduleArr.Length; i++)
                {
                    myCol.Add("scheduleArr" + i, scheduleArr[i]);
                }
                for (int i = 0; i < sclassArr.Length; i++)
                {
                    myCol.Add("sclassArr" + i, sclassArr[i]);
                }
                for (int i = 0; i < oddsInfo.Length; i++)
                {
                    myCol.Add("oddsArr" + i, oddsInfo[i]);
                }

                StringBuilder sb = new StringBuilder();
                foreach (DataRow dr in dt.Select("1=1", "time desc"))
                {
                    sb.Append("<tr>");
                    string color = "black";
                    if (Convert.ToBoolean(dr["isprimary"]))
                    {
                        color = "blue";
                    }
                    else if (Convert.ToBoolean(dr["isexchange"]))
                    {
                        color = "green";
                    }
                    sb.Append("<td align=\"center\" bgcolor=\"White\" style=\"overflow:hidden;text-overflow:ellipsis;white-space:nowrap;line-height: 21px;font-size: 10px;color:" + color + ";\">" + dr["fullname"] + "</td>");
                    sb.Append("<td align=\"center\" bgcolor=\"White\" style=\"line-height: 21px; font-size: 10px;\">" + (dr["type"].ToString() == "1"?"初  盘":"临场盘") + "</td>");
                    sb.Append("<td align=\"center\" bgcolor=\"White\" style=\"line-height: 21px; font-size: 10px;\">" + dr["scount"] + "</td>");
                    sb.Append("<td align=\"center\" bgcolor=\"" + getBGColor(0, dr["swin"]) + "\" style=\"line-height: 21px; font-size: 10px;\">" + dRound(dr["swin"]) + "</td>");
                    sb.Append("<td align=\"center\" bgcolor=\"" + getBGColor(0, dr["sdraw"]) + "\" style=\"line-height: 21px; font-size: 10px;\">" + dRound(dr["sdraw"]) + "</td>");
                    sb.Append("<td align=\"center\" bgcolor=\"" + getBGColor(0, dr["slost"]) + "\" style=\"line-height: 21px; font-size: 10px;\">" + dRound(dr["slost"]) + "</td>");
                    sb.Append("<td align=\"center\" bgcolor=\"White\" style=\"line-height: 21px; font-size: 10px;\">" + Convert.ToDateTime(dr["time"]).ToString("MM-dd HH:mm") + "</td>");
                    sb.Append("</tr>");
                }
                sb.Append("<tr>");
                sb.Append("<td align=\"center\" bgcolor=\"White\" style=\"overflow:hidden;text-overflow:ellipsis;white-space:nowrap;line-height: 21px;font-size: 10px;\">合计</td>");
                sb.Append("<td align=\"center\" bgcolor=\"White\" style=\"line-height: 21px; font-size: 10px;\">临场盘</td>");
                sb.Append("<td align=\"center\" bgcolor=\"White\" style=\"line-height: 21px; font-size: 10px;\"></td>");
                sb.Append("<td align=\"center\" bgcolor=\"" + getBGColor(0, avg[0]) + "\" style=\"line-height: 21px; font-size: 10px;\">" + dRound(avg[0]) + "</td>");
                sb.Append("<td align=\"center\" bgcolor=\"" + getBGColor(0, avg[1]) + "\" style=\"line-height: 21px; font-size: 10px;\">" + dRound(avg[1]) + "</td>");
                sb.Append("<td align=\"center\" bgcolor=\"" + getBGColor(0, avg[2]) + "\" style=\"line-height: 21px; font-size: 10px;\">" + dRound(avg[2]) + "</td>");
                sb.Append("<td align=\"center\" bgcolor=\"White\" style=\"line-height: 21px; font-size: 10px;\"></td>");
                sb.Append("</tr>");
                myCol.Add("companyHistory", sb.ToString());

                string title       = String.Format(sclassArr[1] + " {4}-{7}", scheduleArr);
                string templetpath = Server.MapPath("~/Template/mail.htm");
                string mailBody    = TemplateHelper.BulidByFile(templetpath, myCol);
                MailSender.Send("*****@*****.**", title, mailBody);
            }
        }
    }