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));
}
}
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);
}
}
}