private void pContent()
{
string text = "";
string text2 = "";
TimeSpan span = Convert.ToDateTime(this.kaisai).Subtract(DateTime.Now);
int num = (((span.Days * 0x15180) + (span.Hours * 0xe10)) + (span.Minutes * 60)) + span.Seconds;
if (num > 0)
{
if (num < 600)
{
this.kyglcontent = "parent.sTime = '" + num + "';";
}
SqlDataReader reader = new DataBase(MyFunc.GetConnStr(1)).ExecuteReader("SELECT v1.*,isnull((cl.giveup1sum-cl.giveup2sum)/cl.giveupmoney*giveuppl,0) as give FROM Pl as v1 LEFT JOIN changeleave as cl ON (v1.id = cl.ballid AND cl.gsid = '" + this.Session["usergsid"].ToString() + "') WHERE id>214 and id<227 ORDER BY id asc");
while (reader.Read())
{
text = text + "'" + double.Parse(MyFunc.GetPlType(reader["pl"].ToString().Trim(), "0", reader["give"].ToString().Trim(), "H", "0").ToString("F2")).ToString() + "',";
text2 = text2 + "'" + double.Parse(reader["id"].ToString().Trim()).ToString() + "',";
}
reader.Close();
text = text.Substring(0, text.Length - 1);
text2 = text2.Substring(0, text2.Length - 1);
this.kyglcontent = this.kyglcontent + "parent.sOdds = Array(" + text + ");\n";
this.kyglcontent = this.kyglcontent + "parent.sIds = Array(" + text2 + ");\n";
}
this.kyglcontent = this.kyglcontent + "parent.cOddsName = Array('红波','绿波','蓝波');";
this.num = "1";
}
private void sxContent()
{
string text = "";
TimeSpan span = Convert.ToDateTime(this.kaisai).Subtract(DateTime.Now);
int num = (((span.Days * 0x15180) + (span.Hours * 0xe10)) + (span.Minutes * 60)) + span.Seconds;
if (num > 0)
{
if (num < 600)
{
this.kyglcontent = "parent.sTime = '" + num + "';";
}
this.kyglcontent = this.kyglcontent + "parent.pOddsName = Array('单','双','大','小','红波','绿波','蓝波');\n";
DataBase base2 = new DataBase(MyFunc.GetConnStr(1));
SqlDataReader reader = base2.ExecuteReader("SELECT v1.*,isnull((cl.giveup1sum-cl.giveup2sum)/cl.giveupmoney*giveuppl,0) as give FROM Pl as v1 LEFT JOIN changeleave as cl ON (v1.id = cl.ballid AND cl.gsid = '" + this.Session["usergsid"].ToString() + "') WHERE id=230 ORDER BY id asc");
if (reader.Read())
{
text = double.Parse(MyFunc.GetPlType(reader["pl"].ToString().Trim(), "0", reader["give"].ToString().Trim(), "H", "0").ToString("F2")).ToString();
}
reader.Close();
reader.Close();
base2.Dispose();
this.kyglcontent = this.kyglcontent + "parent.pOdds = Array('" + text + "');\n";
reader.Close();
base2.Dispose();
}
this.num = "1";
}
private void MainContent()
{
string text = "";
TimeSpan span = Convert.ToDateTime(this.kaisai).Subtract(DateTime.Now);
int num = (((span.Days * 0x15180) + (span.Hours * 0xe10)) + (span.Minutes * 60)) + span.Seconds;
if (num > 0)
{
DataBase base2 = new DataBase(MyFunc.GetConnStr(1));
SqlDataReader reader = base2.ExecuteReader("SELECT v1.*,isnull((cl.giveup1sum-cl.giveup2sum)/cl.giveupmoney*giveuppl,0) as give FROM Pl as v1 LEFT JOIN changeleave as cl ON (v1.id = cl.ballid AND cl.gsid = '" + this.Session["usergsid"].ToString() + "') WHERE id=230 ORDER BY id asc");
if (reader.Read())
{
text = double.Parse(MyFunc.GetPlType(reader["pl"].ToString().Trim(), "0", reader["give"].ToString().Trim(), "H", "0").ToString("F2")).ToString();
}
this.kygltable = text;
reader.Close();
reader.Close();
base2.Dispose();
this.gTime = this.kaisai;
}
if (this.isclose == "1")
{
this.gTime = "";
}
}
private void rContent()
{
string text = "";
string text2 = "";
TimeSpan span = Convert.ToDateTime(this.kaisai).Subtract(DateTime.Now);
int num = (((span.Days * 0x15180) + (span.Hours * 0xe10)) + (span.Minutes * 60)) + span.Seconds;
if (num > 0)
{
if (num < 600)
{
this.kyglcontent = "parent.sTime = '" + num + "';\n";
}
SqlDataReader reader = null;
DataBase base2 = new DataBase(MyFunc.GetConnStr(1));
this.kyglcontent = this.kyglcontent + "parent.pOddsName = Array('特单','特双','特大','特小','合单','合双');\n";
reader = base2.ExecuteReader("SELECT v1.*,isnull((cl.giveup1sum-cl.giveup2sum)/cl.giveupmoney*giveuppl,0) as give FROM Pl as v1 LEFT JOIN changeleave as cl ON (v1.id = cl.ballid AND cl.gsid = '" + this.Session["usergsid"].ToString() + "') WHERE id>0 and id<7 ORDER BY id asc");
while (reader.Read())
{
text = text + "'" + double.Parse(MyFunc.GetPlType(reader["pl"].ToString().Trim(), this.Session.Contents["ABC"].ToString().Trim(), reader["give"].ToString().Trim(), "H", "0").ToString("F2")).ToString() + "',";
text2 = text2 + "'" + double.Parse(reader["id"].ToString().Trim()).ToString() + "',";
}
text = text.Substring(0, text.Length - 1);
text2 = text2.Substring(0, text2.Length - 1);
this.kyglcontent = this.kyglcontent + "parent.pOdds = Array(" + text + ");\n";
this.kyglcontent = this.kyglcontent + "parent.pOddsId = Array(" + text2 + ");\n";
this.kyglcontent = this.kyglcontent + "parent.cOddsName = Array('单','双','大','小');\n";
text = "";
text2 = "";
reader.Close();
reader = base2.ExecuteReader("SELECT v1.*,isnull((cl.giveup1sum-cl.giveup2sum)/cl.giveupmoney*giveuppl,0) as give FROM Pl as v1 LEFT JOIN changeleave as cl ON (v1.id = cl.ballid AND cl.gsid = '" + this.Session["usergsid"].ToString() + "') WHERE id>10 and id<35 ORDER BY id asc");
while (reader.Read())
{
text = text + "'" + double.Parse(MyFunc.GetPlType(reader["pl"].ToString().Trim(), this.Session.Contents["ABC"].ToString().Trim(), reader["give"].ToString().Trim(), "H", "0").ToString("F2")).ToString() + "',";
text2 = text2 + "'" + double.Parse(reader["id"].ToString().Trim()).ToString() + "',";
}
text = text.Substring(0, text.Length - 1);
text2 = text2.Substring(0, text2.Length - 1);
this.kyglcontent = this.kyglcontent + "parent.cOdds = Array(" + text + ");\n";
this.kyglcontent = this.kyglcontent + "parent.cOddsId = Array(" + text2 + ");\n";
this.kyglcontent = this.kyglcontent + "parent.uOddsName = Array('总单','总双','总大','总小');\n";
text = "";
text2 = "";
reader.Close();
reader = base2.ExecuteReader("SELECT v1.*,isnull((cl.giveup1sum-cl.giveup2sum)/cl.giveupmoney*giveuppl,0) as give FROM Pl as v1 LEFT JOIN changeleave as cl ON (v1.id = cl.ballid AND cl.gsid = '" + this.Session["usergsid"].ToString() + "') WHERE id>6 and id<11 ORDER BY id asc");
while (reader.Read())
{
text = text + "'" + double.Parse(MyFunc.GetPlType(reader["pl"].ToString().Trim(), this.Session.Contents["ABC"].ToString().Trim(), reader["give"].ToString().Trim(), "H", "0").ToString("F2")).ToString() + "',";
text2 = text2 + "'" + double.Parse(reader["id"].ToString().Trim()).ToString() + "',";
}
text = text.Substring(0, text.Length - 1);
text2 = text2.Substring(0, text2.Length - 1);
this.kyglcontent = this.kyglcontent + "parent.uOdds = Array(" + text + ");\n";
this.kyglcontent = this.kyglcontent + "parent.uOddsId = Array(" + text2 + ");\n";
reader.Close();
base2.Dispose();
}
this.num = "1";
}
private string SumAllMember()
{
string text2 = "";
string text3 = "";
string text4 = "";
DataBase base2 = new DataBase(MyFunc.GetConnStr(2));
DataBase base3 = new DataBase(MyFunc.GetConnStr(1));
SqlDataReader reader = null;
SqlDataReader reader2 = null;
DataSet set = null;
string[] textArray = "01,11,21,31,41,特单,02,12,22,32,42,特双,03,13,23,33,43,特大,04,14,24,34,44,特小,05,15,25,35,45,合单,06,16,26,36,46,合双,07,17,27,37,47,08,18,28,38,48,09,19,29,39,49,10,20,30,40".Split(new char[] { ',' });
reader = base2.ExecuteReader("SELECT top 1 convert(nvarchar,updatetime,11) as updatetime,content,qishu,kaisai FROM affiche WHERE le=1 ORDER BY updatetime DESC");
if (reader.Read())
{
DateTime time = Convert.ToDateTime(reader["kaisai"].ToString().Trim());
TimeSpan span = DateTime.Now.Subtract(time);
int num3 = ((span.Days * 0x5a0) + (span.Hours * 60)) + span.Minutes;
if (num3 < 360)
{
object obj2 = text2;
text2 = string.Concat(new object[] { obj2, "<tr bgcolor='#FFFFFF' ><td rowspan=10>", reader["kaisai"].ToString().Split(new char[] { ' ' })[0].ToString().Trim(), "<BR>", reader["kaisai"].ToString().Split(new char[] { ' ' })[1].ToString().Trim(), "</td><td rowspan=10 align=center>", reader["qishu"], "</td>" });
text4 = reader["kaisai"].ToString();
reader.Close();
set = base3.ExecuteDataSet("SELECT v1.*,isnull((cl.giveup1sum-cl.giveup2sum)/cl.giveupmoney*giveuppl,0) as give FROM Pl as v1 LEFT JOIN changeleave as cl ON (v1.id = cl.ballid AND cl.gsid = '" + this.Session["usergsid"].ToString() + "') where id=230 order by id asc");
if (this.Session["sessionSelectStaticCS"].ToString() == "全部")
{
reader2 = base2.ExecuteReader("select max(tztype) as tztype,max(tzteam) as tzteam,count(1) as orderno,isnull(sum(tzmoney),0) as summoney from ball_order where DATEDIFF(dd, GETDATE(), updatetime)=0 and ballid in (230,231) group by tztype order by tztype asc");
}
else
{
reader2 = base2.ExecuteReader("select max(tztype) as tztype,max(tzteam) as tzteam,count(1) as orderno,isnull(sum(tzmoney),0) as summoney from ball_order where DATEDIFF(dd, GETDATE(), updatetime)=0 and ballid in (230,231) group by tztype order by tztype desc");
}
text3 = double.Parse(MyFunc.GetPlType(set.Tables[0].Rows[0]["pl"].ToString().Trim(), this.Session.Contents["ABC"].ToString().Trim(), set.Tables[0].Rows[0]["give"].ToString().Trim(), "H", "0").ToString("F2")).ToString();
if (reader2.Read())
{
string text6 = text2;
text2 = text6 + "<td align=center class=tznumer>" + text3 + " <br> <a href='tzinfo.aspx?gameid=" + set.Tables[0].Rows[0]["id"].ToString().Trim() + "&tztype=20&marker=C'> <font color=#000088>" + double.Parse(reader2["summoney"].ToString()).ToString() + "</font></a></td> ";
}
else
{
text2 = text2 + "<td align=center class=tznumer>" + text3 + " <br> <font color=#000088>0</font></a></td> ";
}
reader2.Close();
set.Dispose();
}
}
reader.Close();
base3.CloseConnect();
base3.Dispose();
base2.CloseConnect();
base2.Dispose();
return(text2 + "\n</table></form></body></html>");
}
private void AHHTContent()
{
string text = "";
string text2 = "";
TimeSpan span = Convert.ToDateTime(this.kaisai).Subtract(DateTime.Now);
int num = (((span.Days * 0x15180) + (span.Hours * 0xe10)) + (span.Minutes * 60)) + span.Seconds;
string[] textArray = "一, 二,三,四,五,六".Split(new char[] { ',' });
if (num > 0)
{
int num2 = 0;
DataBase base2 = new DataBase(MyFunc.GetConnStr(1));
DataSet set = base2.ExecuteDataSet("SELECT v1.*,isnull((cl.giveup1sum-cl.giveup2sum)/cl.giveupmoney*giveuppl,0) as give FROM Pl as v1 LEFT JOIN changeleave as cl ON (v1.id = cl.ballid AND cl.gsid = '" + this.Session["usergsid"].ToString() + "') WHERE id>157 and id<200 ORDER BY id asc");
for (int i = 0; i < 6; i++)
{
this.kygltable = this.kygltable + " <tr> <td rowspan=\"3\" class=\"tr_title_set_cen\">正码" + textArray[i] + "</td>";
text = double.Parse(MyFunc.GetPlType(set.Tables[0].Rows[i * 7]["pl"].ToString().Trim(), "0", set.Tables[0].Rows[i * 7]["give"].ToString().Trim(), "H", "0").ToString("F2")).ToString();
text2 = set.Tables[0].Rows[i * 7]["id"].ToString().Trim();
object kygltable = this.kygltable;
this.kygltable = string.Concat(new object[] { kygltable, " <td><input name=\"game", num2, "\" type=\"radio\" value=\"", text2, "\">单 <font color=\"#FF0000\"><b>", text, "</b></font></td>" });
text = double.Parse(MyFunc.GetPlType(set.Tables[0].Rows[(i * 7) + 1]["pl"].ToString().Trim(), "0", set.Tables[0].Rows[(i * 7) + 1]["give"].ToString().Trim(), "H", "0").ToString("F2")).ToString();
text2 = set.Tables[0].Rows[(i * 7) + 1]["id"].ToString().Trim();
object obj3 = this.kygltable;
this.kygltable = string.Concat(new object[] { obj3, " <td><input name=\"game", num2++, "\" type=\"radio\" value=\"", text2, "\">双 <font color=\"#FF0000\"><b>", text, "</b></font></td></tr>" });
text = double.Parse(MyFunc.GetPlType(set.Tables[0].Rows[(i * 7) + 2]["pl"].ToString().Trim(), "0", set.Tables[0].Rows[(i * 7) + 2]["give"].ToString().Trim(), "H", "0").ToString("F2")).ToString();
text2 = set.Tables[0].Rows[(i * 7) + 2]["id"].ToString().Trim();
object obj4 = this.kygltable;
this.kygltable = string.Concat(new object[] { obj4, " <tr class=ball_td> <td><input name=\"game", num2, "\" type=\"radio\" value=\"", text2, "\">大 <font color=\"#FF0000\"><b>", text, "</b></font></td>" });
text = double.Parse(MyFunc.GetPlType(set.Tables[0].Rows[(i * 7) + 3]["pl"].ToString().Trim(), "0", set.Tables[0].Rows[(i * 7) + 3]["give"].ToString().Trim(), "H", "0").ToString("F2")).ToString();
text2 = set.Tables[0].Rows[(i * 7) + 3]["id"].ToString().Trim();
object obj5 = this.kygltable;
this.kygltable = string.Concat(new object[] { obj5, " <td><input name=\"game", num2++, "\" type=\"radio\" value=\"", text2, "\">小 <font color=\"#FF0000\"><b>", text, "</b></font></td> <td> </td></tr>" });
text = double.Parse(MyFunc.GetPlType(set.Tables[0].Rows[(i * 7) + 4]["pl"].ToString().Trim(), "0", set.Tables[0].Rows[(i * 7) + 4]["give"].ToString().Trim(), "H", "0").ToString("F2")).ToString();
text2 = set.Tables[0].Rows[(i * 7) + 4]["id"].ToString().Trim();
object obj6 = this.kygltable;
this.kygltable = string.Concat(new object[] { obj6, " <tr class=\"ball_td1\"> <td><input name=\"game", num2, "\" type=\"radio\" value=\"", text2, "\">红波 <font color=\"#FF0000\"><b>", text, "</b></font></td>" });
text = double.Parse(MyFunc.GetPlType(set.Tables[0].Rows[(i * 7) + 5]["pl"].ToString().Trim(), "0", set.Tables[0].Rows[(i * 7) + 5]["give"].ToString().Trim(), "H", "0").ToString("F2")).ToString();
text2 = set.Tables[0].Rows[(i * 7) + 5]["id"].ToString().Trim();
object obj7 = this.kygltable;
this.kygltable = string.Concat(new object[] { obj7, " <td><input name=\"game", num2, "\" type=\"radio\" value=\"", text2, "\">绿波 <font color=\"#FF0000\"><b>", text, "</b></font></td>" });
text = double.Parse(MyFunc.GetPlType(set.Tables[0].Rows[(i * 7) + 6]["pl"].ToString().Trim(), "0", set.Tables[0].Rows[(i * 7) + 6]["give"].ToString().Trim(), "H", "0").ToString("F2")).ToString();
text2 = set.Tables[0].Rows[(i * 7) + 6]["id"].ToString().Trim();
object obj8 = this.kygltable;
this.kygltable = string.Concat(new object[] { obj8, " <td><input name=\"game", num2++, "\" type=\"radio\" value=\"", text2, "\">蓝波 <font color=\"#FF0000\"><b>", text, "</b></font></td></tr>" });
}
base2.Dispose();
this.gTime = this.kaisai;
}
if (this.isclose == "1")
{
this.gTime = "";
}
}
private void MainContent1()
{
string text = "";
TimeSpan span = Convert.ToDateTime(this.kaisai).Subtract(DateTime.Now);
int num2 = ((span.Hours * 0xe10) + (span.Minutes * 60)) + span.Seconds;
if (num2 > 0)
{
if (num2 < 600)
{
this.kyglcontent = "parent.sTime = '" + num2 + "';";
}
DataBase base2 = new DataBase(MyFunc.GetConnStr(1));
SqlDataReader reader = base2.ExecuteReader("SELECT v1.*,isnull((cl.giveup1sum-cl.giveup2sum)/cl.giveupmoney*giveuppl,0) as give FROM Pl as v1 LEFT JOIN changeleave as cl ON (v1.id = cl.ballid AND cl.gsid = '" + this.Session["usergsid"].ToString() + "') WHERE id>0 and id<7 ORDER BY id asc");
for (int i = 0; i < 4; i++)
{
if (reader.Read())
{
this.curpl1 = this.curpl1 + double.Parse(MyFunc.GetPlType(reader["pl"].ToString().Trim(), this.Session.Contents["ABC"].ToString().Trim(), reader["give"].ToString().Trim(), "H", "0").ToString("F2")).ToString() + ",";
this.ballid1 = this.ballid1 + double.Parse(reader["id"].ToString().Trim()).ToString() + ",";
text = double.Parse(MyFunc.GetPlType(reader["pl"].ToString().Trim(), this.Session.Contents["ABC"].ToString().Trim(), reader["give"].ToString().Trim(), "H", "0").ToString("F2")).ToString();
this.MainTable.Rows[0].Cells[(3 * i) + 1].InnerHtml = "<FONT style=\"FONT-WEIGHT: bold; FONT-SIZE: 13px; COLOR: #cc0000\">" + text + "</font>";
}
}
for (int j = 0; j < 2; j++)
{
if (reader.Read())
{
this.curpl1 = this.curpl1 + double.Parse(MyFunc.GetPlType(reader["pl"].ToString().Trim(), this.Session.Contents["ABC"].ToString().Trim(), reader["give"].ToString().Trim(), "H", "0").ToString("F2")).ToString() + ",";
this.ballid1 = this.ballid1 + double.Parse(reader["id"].ToString().Trim()).ToString() + ",";
text = double.Parse(MyFunc.GetPlType(reader["pl"].ToString().Trim(), this.Session.Contents["ABC"].ToString().Trim(), reader["give"].ToString().Trim(), "H", "0").ToString("F2")).ToString();
this.MainTable.Rows[1].Cells[(3 * j) + 1].InnerHtml = "<FONT style=\"FONT-WEIGHT: bold; FONT-SIZE: 13px; COLOR: #cc0000\">" + text + "</font>";
}
}
reader.Close();
reader = base2.ExecuteReader("SELECT v1.*,isnull((cl.giveup1sum-cl.giveup2sum)/cl.giveupmoney*giveuppl,0) as give FROM Pl as v1 LEFT JOIN changeleave as cl ON (v1.id = cl.ballid AND cl.gsid = '" + this.Session["usergsid"].ToString() + "') WHERE v1.id>211 and v1.id<215 ORDER BY id asc");
for (int k = 0; k < 3; k++)
{
if (reader.Read())
{
this.curpl1 = this.curpl1 + double.Parse(MyFunc.GetPlType(reader["pl"].ToString().Trim(), this.Session.Contents["ABC"].ToString().Trim(), reader["give"].ToString().Trim(), "H", "0").ToString("F2")).ToString() + ",";
this.ballid1 = this.ballid1 + double.Parse(reader["id"].ToString().Trim()).ToString() + ",";
text = double.Parse(MyFunc.GetPlType(reader["pl"].ToString().Trim(), this.Session.Contents["ABC"].ToString().Trim(), reader["give"].ToString().Trim(), "H", "0").ToString("F2")).ToString();
this.MainTable.Rows[2].Cells[(3 * k) + 1].InnerHtml = "<FONT style=\"FONT-WEIGHT: bold; FONT-SIZE: 13px; COLOR: #cc0000\">" + text + "</font>";
}
}
reader.Close();
this.ballid1 = this.ballid1.Substring(0, this.ballid1.Length - 1);
this.curpl1 = this.curpl1.Substring(0, this.curpl1.Length - 1);
base2.Dispose();
}
}
private void sxContent()
{
string text = "";
DataBase base2 = new DataBase(MyFunc.GetConnStr(1));
SqlDataReader reader = base2.ExecuteReader("SELECT v1.*,isnull((cl.giveup1sum-cl.giveup2sum)/cl.giveupmoney*giveuppl,0) as give FROM Pl as v1 LEFT JOIN changeleave as cl ON (v1.id = cl.ballid AND cl.gsid = '" + this.Session["usergsid"].ToString() + "') WHERE id=230 ORDER BY id asc");
if (reader.Read())
{
text = double.Parse(MyFunc.GetPlType(reader["pl"].ToString().Trim(), "0", reader["give"].ToString().Trim(), "H", "0").ToString("F2")).ToString();
}
reader.Close();
reader.Close();
base2.Dispose();
this.kygltable = " <form name=\"lt_form\" method=\"post\" action=\"betting-entry.aspx\" target=\"bbnet_mem_order\" onSubmit=\"return SubChk(this);\" onReset=\"return reset_num();\"><input type=\"hidden\" name=\"action\" value=\"sx\"><tr> <td height=\"100%\" colspan=\"3\"><TABLE class=\"table_title_line\" cellSpacing=0 cellPadding=0 width=500 border=0 ><TBODY> <TR> <TD height=5 colSpan=2></TD> </TR> <tr> <TD colSpan=2> <table width=\"100%\" border=\"0\" cellspacing=\"2\" cellpadding=\"0\"> <tr align=\"left\"><td class=\"ball_td2\" width=\"60\" align=\"center\">类别</td> <td class=\"ball_td2\" width=\"60\" align=\"center\"><input type=\"radio\" name=\"rtype\" value=\"230\">中</td> <td class=\"ball_td2\" width=\"60\" align=\"center\"><input type=\"radio\" name=\"rtype\" value=\"231\">不中</td> <td class=\"ball_td2\" width=\"60\" align=\"center\">赔率</td> <td class=\"ball_td3\" width=\"60\" align=\"center\" id='odds1' style='background-color: #C1D7E5;'>" + text + "</td><td width=250> </td> </tr></table></TD></TR> <TR> <TD colSpan=2> <TABLE width=\"100%\" border=\"0\" cellspacing=\"1\" cellpadding=\"0\"> <TBODY><tr class=\"tr_title_set_cen\"> <td width=\"50\">六肖</td> <td width=\"130\">号码</td> <td>勾选</td><td width=\"50\">六肖</td> <td width=\"130\">号码</td> <td>勾选</td></tr><tr> <td class=\"tr_title_set_cen\">鼠</td> <td class=\"ball_td2\">" + ConfigurationSettings.AppSettings["twelveNum"].Split(new char[] { '^' })[0].ToString() + "</td> <td class=\"list_cen\"><input type=\"checkbox\" name=\"lt_sx[]\" value=\"0\" onClick=\"SubChkBox(this,this)\"></td> <td class=\"tr_title_set_cen\">牛</td> <td class=\"ball_td2\">" + ConfigurationSettings.AppSettings["twelveNum"].Split(new char[] { '^' })[1].ToString() + "</td> <td class=\"list_cen\"><input type=\"checkbox\" name=\"lt_sx[]\" value=\"1\" onClick=\"SubChkBox(this,this)\"></td></tr><tr><td class=\"tr_title_set_cen\">虎</td><td class=\"ball_td2\">" + ConfigurationSettings.AppSettings["twelveNum"].Split(new char[] { '^' })[2].ToString() + "</td><td class=\"list_cen\"><input type=\"checkbox\" name=\"lt_sx[]\" value=\"2\" onClick=\"SubChkBox(this,this)\"></td><td class=\"tr_title_set_cen\">兔</td><td class=\"ball_td2\">" + ConfigurationSettings.AppSettings["twelveNum"].Split(new char[] { '^' })[3].ToString() + "</td> <td class=\"list_cen\"><input type=\"checkbox\" name=\"lt_sx[]\" value=\"3\" onClick=\"SubChkBox(this,this)\"></td> </tr> <tr><td class=\"tr_title_set_cen\">龙</td> <td class=\"ball_td2\">" + ConfigurationSettings.AppSettings["twelveNum"].Split(new char[] { '^' })[4].ToString() + "</td> <td class=\"list_cen\"><input type=\"checkbox\" name=\"lt_sx[]\" value=\"4\" onClick=\"SubChkBox(this,this)\"></td> <td class=\"tr_title_set_cen\">蛇</td> <td class=\"ball_td2\">" + ConfigurationSettings.AppSettings["twelveNum"].Split(new char[] { '^' })[5].ToString() + "</td><td class=\"list_cen\"><input type=\"checkbox\" name=\"lt_sx[]\" value=\"5\" onClick=\"SubChkBox(this,this)\"></td></tr><tr> <td class=\"tr_title_set_cen\">马</td><td class=\"ball_td2\">" + ConfigurationSettings.AppSettings["twelveNum"].Split(new char[] { '^' })[6].ToString() + "</td><td class=\"list_cen\"><input type=\"checkbox\" name=\"lt_sx[]\" value=\"6\" onClick=\"SubChkBox(this,this)\"></td><td class=\"tr_title_set_cen\">羊</td> <td class=\"ball_td2\">" + ConfigurationSettings.AppSettings["twelveNum"].Split(new char[] { '^' })[7].ToString() + "</td><td class=\"list_cen\"><input type=\"checkbox\" name=\"lt_sx[]\" value=\"7\" onClick=\"SubChkBox(this,this)\"></td></tr><tr><td class=\"tr_title_set_cen\">猴</td><td class=\"ball_td2\">" + ConfigurationSettings.AppSettings["twelveNum"].Split(new char[] { '^' })[8].ToString() + "</td><td class=\"list_cen\"><input type=\"checkbox\" name=\"lt_sx[]\" value=\"8\" onClick=\"SubChkBox(this,this)\"></td><td class=\"tr_title_set_cen\">鸡</td><td class=\"ball_td2\">" + ConfigurationSettings.AppSettings["twelveNum"].Split(new char[] { '^' })[9].ToString() + "</td><td class=\"list_cen\"><input type=\"checkbox\" name=\"lt_sx[]\" value=\"9\" onClick=\"SubChkBox(this,this)\"></td></tr><tr><td class=\"tr_title_set_cen\">狗</td><td class=\"ball_td2\">" + ConfigurationSettings.AppSettings["twelveNum"].Split(new char[] { '^' })[10].ToString() + "</td><td class=\"list_cen\"><input type=\"checkbox\" name=\"lt_sx[]\" value=\"10\" onClick=\"SubChkBox(this,this)\"></td><td class=\"tr_title_set_cen\">猪</td><td class=\"ball_td2\">" + ConfigurationSettings.AppSettings["twelveNum"].Split(new char[] { '^' })[11].ToString() + "</td><td class=\"list_cen\"><input type=\"checkbox\" name=\"lt_sx[]\" value=\"11\" onClick=\"SubChkBox(this,this)\"></td></tr></TBODY> </TABLE> </TD></TR><tr> <td height=\"10\" colspan=\"2\"> </td></tr><TR> <TD colSpan=2><table width=\"100%\" border=\"0\" cellspacing=\"1\" cellpadding=\"0\"> <!--id=\"game_table1\">--> <tr class=\"tr_title_set_cen\"> \t\t\t\t\t \t<td width=\"100%\" align=\"center\"><input type=\"submit\" value=\"送出\"><input type=\"reset\" value=\"取消\" onMouseUp=\"return reset();\"></td> </tr></table></TD></tr> </TBODY> </TABLE></td></tr></form>";
}
private void hfContent()
{
DataBase base2 = new DataBase(MyFunc.GetConnStr(1));
SqlDataReader reader = base2.ExecuteReader("SELECT v1.*,isnull((cl.giveup1sum-cl.giveup2sum)/cl.giveupmoney*giveuppl,0) as give FROM Pl as v1 LEFT JOIN changeleave as cl ON (v1.id = cl.ballid AND cl.gsid = '" + this.Session["usergsid"].ToString() + "') WHERE tztype=21 ORDER BY id asc");
string[] textArray = new string[12];
int num = 0;
while (reader.Read())
{
textArray[num++] = double.Parse(MyFunc.GetPlType(reader["pl"].ToString().Trim(), this.Session.Contents["ABC"].ToString().Trim(), reader["give"].ToString().Trim(), "H", "0").ToString("F2")).ToString();
}
reader.Close();
base2.Dispose();
this.kygltable = "<tr> <td height=\"100%\" colspan=\"3\"> <table border='0' cellpadding='0' cellspacing='1' align='bbnet_mem_order' width='508' class='banner_set' ><tr height='20'><td width='90' align='center' bgcolor='85BAE4' class='table-title4'>半波</td> <td width='90' align='center' bgcolor='85BAE4' class='table-title4'>赔率</td> <td width='*' align='center' bgcolor='85BAE4' class='table-title4'>号码</td></tr><tr bgcolor='#ffffff'><td align='center'>红单</td><td align='center' id='odd0'><a href='betting-entry.aspx?m=232,1,17' target='bbnet_mem_order' class='bet_rate_blue' ><span id='odds0'> " + textArray[0] + "</span></a></td><td align='bbnet_mem_order'><table border='0' cellpadding='0' cellspacing='0'><tr> <td class='redBall' align='center' bgcolor='#ffffff' width='25' height='25'><b>1</b></td><td class='redBall' align='center' bgcolor='#ffffff' width='25' height='25'><b>7</b></td><td class='redBall' align='center' bgcolor='#ffffff' width='25' height='25'><b>13</b></td><td class='redBall' align='center' bgcolor='#ffffff' width='25' height='25'><b>19</b></td><td class='redBall' align='center' bgcolor='#ffffff' width='25' height='25'><b>23</b></td><td class='redBall' align='center' bgcolor='#ffffff' width='25' height='25'><b>29</b></td><td class='redBall' align='center' bgcolor='#ffffff' width='25' height='25'><b>35</b></td><td class='redBall' align='center' bgcolor='#ffffff' width='25' height='25'><b>45</b></td> </tr> </table></td></tr><tr bgcolor='#ffffff'><td align='center'>红双</td><td align='center' id='odd1'><a href='betting-entry.aspx?m=233,1,17' target='bbnet_mem_order' class='bet_rate_blue'><span id='odds1'>" + textArray[1] + "</span></a></td><td align='bbnet_mem_order'><table border='0' cellpadding='0' cellspacing='0'><tr><td class='redBall' align='center' bgcolor='#ffffff' width='25' height='25'><b>2</b></td><td class='redBall' align='center' bgcolor='#ffffff' width='25' height='25'><b>8</b></td><td class='redBall' align='center' bgcolor='#ffffff' width='25' height='25'><b>12</b></td><td class='redBall' align='center' bgcolor='#ffffff' width='25' height='25'><b>18</b></td><td class='redBall' align='center' bgcolor='#ffffff' width='25' height='25'><b>24</b></td><td class='redBall' align='center' bgcolor='#ffffff' width='25' height='25'><b>30</b></td><td class='redBall' align='center' bgcolor='#ffffff' width='25' height='25'><b>34</b></td><td class='redBall' align='center' bgcolor='#ffffff' width='25' height='25'><b>40</b></td><td class='redBall' align='center' bgcolor='#ffffff' width='25' height='25'><b>46</b></td> </tr></table></td></tr><tr bgcolor='#ffffff'><td align='center'>红大</td><td align='center' id='odd2'><a href='betting-entry.aspx?m=234,1,17' target='bbnet_mem_order' class='bet_rate_blue'><span id='odds2'> " + textArray[2] + "</span></a></td><td align='bbnet_mem_order'><table border='0' cellpadding='0' cellspacing='0'><tr><td class='redBall' align='center' bgcolor='#ffffff' width='25' height='25'><b>29</b></td><td class='redBall' align='center' bgcolor='#ffffff' width='25' height='25'><b>30</b></td><td class='redBall' align='center' bgcolor='#ffffff' width='25' height='25'><b>34</b></td><td class='redBall' align='center' bgcolor='#ffffff' width='25' height='25'><b>35</b></td><td class='redBall' align='center' bgcolor='#ffffff' width='25' height='25'><b>40</b></td><td class='redBall' align='center' bgcolor='#ffffff' width='25' height='25'><b>45</b></td><td class='redBall' align='center' bgcolor='#ffffff' width='25' height='25'><b>46</b></td></tr></table></td> </tr><tr bgcolor='#ffffff'><td align='center'>红小</td><td align='center' id='odd3'><a href='betting-entry.aspx?m=235,1,17' target='bbnet_mem_order' class='bet_rate_blue'><span id='odds3'>" + textArray[3] + "</span></a></td><td align='bbnet_mem_order'><table border='0' cellpadding='0' cellspacing='0'> <tr> <td class='redBall' align='center' bgcolor='#ffffff' width='25' height='25'><b>1</b></td> <td class='redBall' align='center' bgcolor='#ffffff' width='25' height='25'><b>2</b></td> <td class='redBall' align='center' bgcolor='#ffffff' width='25' height='25'><b>7</b></td> <td class='redBall' align='center' bgcolor='#ffffff' width='25' height='25'><b>8</b></td> <td class='redBall' align='center' bgcolor='#ffffff' width='25' height='25'><b>12</b></td> <td class='redBall' align='center' bgcolor='#ffffff' width='25' height='25'><b>13</b></td> <td class='redBall' align='center' bgcolor='#ffffff' width='25' height='25'><b>18</b></td> <td class='redBall' align='center' bgcolor='#ffffff' width='25' height='25'><b>19</b></td><td class='redBall' align='center' bgcolor='#ffffff' width='25' height='25'><b>23</b></td><td class='redBall' align='center' bgcolor='#ffffff' width='25' height='25'><b>24</b></td></tr></table></td></tr><tr bgcolor='#ffffff'><td align='center'>绿单</td><td align='center' id='odd4'><a href='betting-entry.aspx?m=236,1,17' target='bbnet_mem_order' class='bet_rate_blue'><span id='odds4'> " + textArray[4] + "</span></a></td><td align='bbnet_mem_order'><table border='0' cellpadding='0' cellspacing='0'><tr><td class='greenBall' align='center' bgcolor='#ffffff' width='25' height='25'><b>5</b></td><td class='greenBall' align='center' bgcolor='#ffffff' width='25' height='25'><b>11</b></td><td class='greenBall' align='center' bgcolor='#ffffff' width='25' height='25'><b>17</b></td><td class='greenBall' align='center' bgcolor='#ffffff' width='25' height='25'><b>21</b></td><td class='greenBall' align='center' bgcolor='#ffffff' width='25' height='25'><b>27</b></td><td class='greenBall' align='center' bgcolor='#ffffff' width='25' height='25'><b>33</b></td><td class='greenBall' align='center' bgcolor='#ffffff' width='25' height='25'><b>39</b></td><td class='greenBall' align='center' bgcolor='#ffffff' width='25' height='25'><b>43</b></td> </tr></table></td> </tr><tr bgcolor='#ffffff'><td align='center'>绿双</td><td align='center' id='odd5'><a href='betting-entry.aspx?m=237,1,17' target='bbnet_mem_order' class='bet_rate_blue'><span id='odds5'>" + textArray[5] + "</span></a></td><td align='bbnet_mem_order'><table border='0' cellpadding='0' cellspacing='0'> <tr><td class='greenBall' align='center' bgcolor='#ffffff' width='25' height='25'><b>6</b></td><td class='greenBall' align='center' bgcolor='#ffffff' width='25' height='25'><b>16</b></td><td class='greenBall' align='center' bgcolor='#ffffff' width='25' height='25'><b>22</b></td><td class='greenBall' align='center' bgcolor='#ffffff' width='25' height='25'><b>28</b></td><td class='greenBall' align='center' bgcolor='#ffffff' width='25' height='25'><b>32</b></td><td class='greenBall' align='center' bgcolor='#ffffff' width='25' height='25'><b>38</b></td><td class='greenBall' align='center' bgcolor='#ffffff' width='25' height='25'><b>44</b></td></tr> </table></td></tr><tr bgcolor='#ffffff'><td align='center'>绿大</td><td align='center' id='odd6'><a href='betting-entry.aspx?m=238,1,17' target='bbnet_mem_order' class='bet_rate_blue'><span id='odds6'>" + textArray[6] + "</span></a></td><td align='bbnet_mem_order'><table border='0' cellpadding='0' cellspacing='0'><tr><td class='greenBall' align='center' bgcolor='#ffffff' width='25' height='25'><b>27</b></td><td class='greenBall' align='center' bgcolor='#ffffff' width='25' height='25'><b>28</b></td><td class='greenBall' align='center' bgcolor='#ffffff' width='25' height='25'><b>32</b></td><td class='greenBall' align='center' bgcolor='#ffffff' width='25' height='25'><b>33</b></td><td class='greenBall' align='center' bgcolor='#ffffff' width='25' height='25'><b>38</b></td><td class='greenBall' align='center' bgcolor='#ffffff' width='25' height='25'><b>39</b></td><td class='greenBall' align='center' bgcolor='#ffffff' width='25' height='25'><b>43</b></td><td class='greenBall' align='center' bgcolor='#ffffff' width='25' height='25'><b>44</b></td></tr></table></td></tr><tr bgcolor='#ffffff'><td align='center'>绿小</td><td align='center' id='odd7'><a href='betting-entry.aspx?m=239,1,17' target='bbnet_mem_order' class='bet_rate_blue'><span id='odds7'>" + textArray[7] + "</span></a></td><td align='bbnet_mem_order'><table border='0' cellpadding='0' cellspacing='0'><tr><td class='greenBall' align='center' bgcolor='#ffffff' width='25' height='25'><b>5</b></td><td class='greenBall' align='center' bgcolor='#ffffff' width='25' height='25'><b>6</b></td><td class='greenBall' align='center' bgcolor='#ffffff' width='25' height='25'><b>11</b></td><td class='greenBall' align='center' bgcolor='#ffffff' width='25' height='25'><b>16</b></td><td class='greenBall' align='center' bgcolor='#ffffff' width='25' height='25'><b>17</b></td><td class='greenBall' align='center' bgcolor='#ffffff' width='25' height='25'><b>21</b></td><td class='greenBall' align='center' bgcolor='#ffffff' width='25' height='25'><b>22</b></td></tr></table></td></tr><tr bgcolor='#ffffff'><td align='center'>蓝单</td> <td align='center' id='odd8'><a href='betting-entry.aspx?m=240,1,17' target='bbnet_mem_order' class='bet_rate_blue'><span id='odds8'>" + textArray[8] + "</span></a></td><td align='bbnet_mem_order'><table border='0' cellpadding='0' cellspacing='0'><tr> <td class='blueBall' align='center' bgcolor='#ffffff' width='25' height='25'><b>3</b></td><td class='blueBall' align='center' bgcolor='#ffffff' width='25' height='25'><b>9</b></td><td class='blueBall' align='center' bgcolor='#ffffff' width='25' height='25'><b>15</b></td><td class='blueBall' align='center' bgcolor='#ffffff' width='25' height='25'><b>25</b></td><td class='blueBall' align='center' bgcolor='#ffffff' width='25' height='25'><b>31</b></td><td class='blueBall' align='center' bgcolor='#ffffff' width='25' height='25'><b>37</b></td> <td class='blueBall' align='center' bgcolor='#ffffff' width='25' height='25'><b>41</b></td><td class='blueBall' align='center' bgcolor='#ffffff' width='25' height='25'><b>47</b></td></tr> </table></td></tr><tr bgcolor='#ffffff'><td align='center'>蓝双</td><td align='center' id='odd9'><a href='betting-entry.aspx?m=241,1,17' target='bbnet_mem_order' class='bet_rate_blue'><span id='odds9'>" + textArray[9] + "</span></a></td><td align='bbnet_mem_order'><table border='0' cellpadding='0' cellspacing='0'><tr><td class='blueBall' align='center' bgcolor='#ffffff' width='25' height='25'><b>4</b></td><td class='blueBall' align='center' bgcolor='#ffffff' width='25' height='25'><b>10</b></td><td class='blueBall' align='center' bgcolor='#ffffff' width='25' height='25'><b>14</b></td><td class='blueBall' align='center' bgcolor='#ffffff' width='25' height='25'><b>20</b></td><td class='blueBall' align='center' bgcolor='#ffffff' width='25' height='25'><b>26</b></td><td class='blueBall' align='center' bgcolor='#ffffff' width='25' height='25'><b>36</b></td><td class='blueBall' align='center' bgcolor='#ffffff' width='25' height='25'><b>42</b></td><td class='blueBall' align='center' bgcolor='#ffffff' width='25' height='25'><b>48</b></td></tr></table></td> </tr><tr bgcolor='#ffffff'><td align='center'>蓝大</td> <td align='center' id='odd10'><a href='betting-entry.aspx?m=242,1,17' target='bbnet_mem_order' class='bet_rate_blue'><span id='odds10'>" + textArray[10] + "</span></a></td><td align='bbnet_mem_order'><table border='0' cellpadding='0' cellspacing='0'><tr><td class='blueBall' align='center' bgcolor='#ffffff' width='25' height='25'><b>25</b></td><td class='blueBall' align='center' bgcolor='#ffffff' width='25' height='25'><b>26</b></td><td class='blueBall' align='center' bgcolor='#ffffff' width='25' height='25'><b>31</b></td><td class='blueBall' align='center' bgcolor='#ffffff' width='25' height='25'><b>36</b></td><td class='blueBall' align='center' bgcolor='#ffffff' width='25' height='25'><b>37</b></td><td class='blueBall' align='center' bgcolor='#ffffff' width='25' height='25'><b>41</b></td><td class='blueBall' align='center' bgcolor='#ffffff' width='25' height='25'><b>42</b></td><td class='blueBall' align='center' bgcolor='#ffffff' width='25' height='25'><b>47</b></td><td class='blueBall' align='center' bgcolor='#ffffff' width='25' height='25'><b>48</b></td></tr></table></td></tr><tr bgcolor='#ffffff'><td align='center'>蓝小</td><td align='center' id='odd11'><a href='betting-entry.aspx?m=243,1,17' target='bbnet_mem_order' class='bet_rate_blue'><span id='odds11'>" + textArray[11] + "</span></a></td><td align='bbnet_mem_order'><table border='0' cellpadding='0' cellspacing='0'> <tr> <td class='blueBall' align='center' bgcolor='#ffffff' width='25' height='25'><b>3</b></td><td class='blueBall' align='center' bgcolor='#ffffff' width='25' height='25'><b>4</b></td><td class='blueBall' align='center' bgcolor='#ffffff' width='25' height='25'><b>9</b></td><td class='blueBall' align='center' bgcolor='#ffffff' width='25' height='25'><b>10</b></td><td class='blueBall' align='center' bgcolor='#ffffff' width='25' height='25'><b>14</b></td><td class='blueBall' align='center' bgcolor='#ffffff' width='25' height='25'><b>15</b></td><td class='blueBall' align='center' bgcolor='#ffffff' width='25' height='25'><b>20</b></td></tr> </table></td></tr></table></td></tr>";
}
private string SumAllMember()
{
string text2 = "";
string text3 = "";
string text4 = "";
int num = 0;
DataBase base2 = new DataBase(MyFunc.GetConnStr(2));
DataBase base3 = new DataBase(MyFunc.GetConnStr(1));
SqlDataReader reader = null;
SqlDataReader reader2 = null;
DataSet set = null;
string[] textArray = "单,双,大,小,红波,绿波,蓝波".Split(new char[] { ',' });
reader = base2.ExecuteReader("SELECT top 1 convert(nvarchar,updatetime,11) as updatetime,content,qishu,kaisai FROM affiche WHERE le=1 ORDER BY updatetime DESC");
if (reader.Read())
{
DateTime time = Convert.ToDateTime(reader["kaisai"].ToString().Trim());
TimeSpan span = DateTime.Now.Subtract(time);
int num3 = ((span.Days * 0x5a0) + (span.Hours * 60)) + span.Minutes;
if (num3 < 360)
{
object obj2 = text2;
text2 = string.Concat(new object[] { obj2, "<tr bgcolor='#FFFFFF' ><td rowspan=10>", reader["kaisai"].ToString().Split(new char[] { ' ' })[0].ToString().Trim(), "<BR>", reader["kaisai"].ToString().Split(new char[] { ' ' })[1].ToString().Trim(), "</td><td rowspan=10 align=center>", reader["qishu"], "</td>" });
text4 = reader["kaisai"].ToString();
reader.Close();
set = base3.ExecuteDataSet("SELECT v1.*,isnull((cl.giveup1sum-cl.giveup2sum)/cl.giveupmoney*giveuppl,0) as give FROM Pl as v1 LEFT JOIN changeleave as cl ON (v1.id = cl.ballid AND cl.gsid = '" + this.Session["usergsid"].ToString() + "') where ((id>10 and id<35 )or (id>132 and id <151)) order by id asc");
reader2 = base2.ExecuteReader("select userid from agence where gdid=" + this.Session["adminuserid"].ToString());
string text6 = "";
while (reader2.Read())
{
text6 = text6 + reader2["userid"].ToString().Trim() + ",";
}
reader2.Close();
text6 = text6 + "0";
for (int i = 0; i < 7; i++)
{
string text5;
if (i < 2)
{
text5 = "6";
}
else if ((i > 1) && (i < 4))
{
text5 = "7";
}
else
{
text5 = "10";
}
if (i > 3)
{
this.Session.Contents["ABC"] = "0";
}
if (i != 0)
{
text2 = text2 + "<tr bgcolor='#FFFFFF' >";
}
text2 = text2 + "<td align=center>" + textArray[i] + "</td>";
if (this.Session["sessionSelectStaticCS"].ToString() == "全部")
{
reader2 = base2.ExecuteReader("select max(tztype) as tztype,max(tzteam) as tzteam,count(1) as orderno,isnull(sum(tzmoney),0) as summoney from ball_order where DATEDIFF(dd, GETDATE(), updatetime)=0 and gdid in (" + text6 + ") and ballid=" + set.Tables[0].Rows[num]["id"].ToString().Trim() + " group by ballid order by ballid asc");
}
else
{
reader2 = base2.ExecuteReader("select max(tztype) as tztype,max(tzteam) as tzteam,count(1) as orderno,isnull(sum(tzmoney*(1-csgd-cszdl-csdls)),0) as summoney from ball_order where DATEDIFF(dd, GETDATE(), updatetime)=0 and gdid in (" + text6 + ") and ballid=" + set.Tables[0].Rows[num]["id"].ToString().Trim() + " group by ballid order by ballid desc");
}
text3 = double.Parse(MyFunc.GetPlType(set.Tables[0].Rows[num]["pl"].ToString().Trim(), this.Session.Contents["ABC"].ToString().Trim(), set.Tables[0].Rows[num]["give"].ToString().Trim(), "H", "0").ToString("F2")).ToString();
if (reader2.Read())
{
string text8 = text2;
text2 = text8 + "<td align=center class=tznumer>" + text3 + " <br> <a href='tzinfo.aspx?gameid=" + set.Tables[0].Rows[num]["id"].ToString().Trim() + "&tztype=" + text5 + "&marker=C'> <font color=#000088>" + double.Parse(reader2["summoney"].ToString()).ToString() + "</font></a></td> ";
}
else
{
text2 = text2 + "<td align=center class=tznumer>" + text3 + " <br> <font color=#000088>0</font></a></td> ";
}
num++;
reader2.Close();
if (this.Session["sessionSelectStaticCS"].ToString() == "全部")
{
reader2 = base2.ExecuteReader("select max(tztype) as tztype,max(tzteam) as tzteam,count(1) as orderno,isnull(sum(tzmoney),0) as summoney from ball_order where DATEDIFF(dd, GETDATE(), updatetime)=0 and gdid in (" + text6 + ") and ballid=" + set.Tables[0].Rows[num]["id"].ToString().Trim() + " group by ballid order by ballid asc");
}
else
{
reader2 = base2.ExecuteReader("select max(tztype) as tztype,max(tzteam) as tzteam,count(1) as orderno,isnull(sum(tzmoney*(1-csgd-cszdl-csdls)),0) as summoney from ball_order where DATEDIFF(dd, GETDATE(), updatetime)=0 and gdid in (" + text6 + ") and ballid=" + set.Tables[0].Rows[num]["id"].ToString().Trim() + " group by ballid order by ballid desc");
}
text3 = double.Parse(MyFunc.GetPlType(set.Tables[0].Rows[num]["pl"].ToString().Trim(), this.Session.Contents["ABC"].ToString().Trim(), set.Tables[0].Rows[num]["give"].ToString().Trim(), "H", "0").ToString("F2")).ToString();
if (reader2.Read())
{
string text9 = text2;
text2 = text9 + "<td align=center class=tznumer>" + text3 + " <br> <a href='tzinfo.aspx?gameid=" + set.Tables[0].Rows[num]["id"].ToString().Trim() + "&tztype=" + text5 + "&marker=C'> <font color=#000088>" + double.Parse(reader2["summoney"].ToString()).ToString() + "</font></a></td> ";
}
else
{
text2 = text2 + "<td align=center class=tznumer>" + text3 + " <br> <font color=#000088>0</font></a></td> ";
}
num++;
reader2.Close();
if (this.Session["sessionSelectStaticCS"].ToString() == "全部")
{
reader2 = base2.ExecuteReader("select max(tztype) as tztype,max(tzteam) as tzteam,count(1) as orderno,isnull(sum(tzmoney),0) as summoney from ball_order where DATEDIFF(dd, GETDATE(), updatetime)=0 and gdid in (" + text6 + ") and ballid=" + set.Tables[0].Rows[num]["id"].ToString().Trim() + " group by ballid order by ballid asc");
}
else
{
reader2 = base2.ExecuteReader("select max(tztype) as tztype,max(tzteam) as tzteam,count(1) as orderno,isnull(sum(tzmoney*(1-csgd-cszdl-csdls)),0) as summoney from ball_order where DATEDIFF(dd, GETDATE(), updatetime)=0 and gdid in (" + text6 + ") and ballid=" + set.Tables[0].Rows[num]["id"].ToString().Trim() + " group by ballid order by ballid desc");
}
text3 = double.Parse(MyFunc.GetPlType(set.Tables[0].Rows[num]["pl"].ToString().Trim(), this.Session.Contents["ABC"].ToString().Trim(), set.Tables[0].Rows[num]["give"].ToString().Trim(), "H", "0").ToString("F2")).ToString();
if (reader2.Read())
{
string text10 = text2;
text2 = text10 + "<td align=center class=tznumer>" + text3 + " <br> <a href='tzinfo.aspx?gameid=" + set.Tables[0].Rows[num]["id"].ToString().Trim() + "&tztype=" + text5 + "&marker=C'> <font color=#000088>" + double.Parse(reader2["summoney"].ToString()).ToString() + "</font></a></td> ";
}
else
{
text2 = text2 + "<td align=center class=tznumer>" + text3 + " <br> <font color=#000088>0</font></a></td> ";
}
num++;
reader2.Close();
if (this.Session["sessionSelectStaticCS"].ToString() == "全部")
{
reader2 = base2.ExecuteReader("select max(tztype) as tztype,max(tzteam) as tzteam,count(1) as orderno,isnull(sum(tzmoney),0) as summoney from ball_order where DATEDIFF(dd, GETDATE(), updatetime)=0 and gdid in (" + text6 + ") and ballid=" + set.Tables[0].Rows[num]["id"].ToString().Trim() + " group by ballid order by ballid asc");
}
else
{
reader2 = base2.ExecuteReader("select max(tztype) as tztype,max(tzteam) as tzteam,count(1) as orderno,isnull(sum(tzmoney*(1-csgd-cszdl-csdls)),0) as summoney from ball_order where DATEDIFF(dd, GETDATE(), updatetime)=0 and gdid in (" + text6 + ") and ballid=" + set.Tables[0].Rows[num]["id"].ToString().Trim() + " group by ballid order by ballid desc");
}
text3 = double.Parse(MyFunc.GetPlType(set.Tables[0].Rows[num]["pl"].ToString().Trim(), this.Session.Contents["ABC"].ToString().Trim(), set.Tables[0].Rows[num]["give"].ToString().Trim(), "H", "0").ToString("F2")).ToString();
if (reader2.Read())
{
string text11 = text2;
text2 = text11 + "<td align=center class=tznumer>" + text3 + " <br> <a href='tzinfo.aspx?gameid=" + set.Tables[0].Rows[num]["id"].ToString().Trim() + "&tztype=" + text5 + "&marker=C'> <font color=#000088>" + double.Parse(reader2["summoney"].ToString()).ToString() + "</font></a></td> ";
}
else
{
text2 = text2 + "<td align=center class=tznumer>" + text3 + " <br> <font color=#000088>0</font></a></td> ";
}
num++;
reader2.Close();
if (this.Session["sessionSelectStaticCS"].ToString() == "全部")
{
reader2 = base2.ExecuteReader("select max(tztype) as tztype,max(tzteam) as tzteam,count(1) as orderno,isnull(sum(tzmoney),0) as summoney from ball_order where DATEDIFF(dd, GETDATE(), updatetime)=0 and gdid in (" + text6 + ") and ballid=" + set.Tables[0].Rows[num]["id"].ToString().Trim() + " group by ballid order by ballid asc");
}
else
{
reader2 = base2.ExecuteReader("select max(tztype) as tztype,max(tzteam) as tzteam,count(1) as orderno,isnull(sum(tzmoney*(1-csgd-cszdl-csdls)),0) as summoney from ball_order where DATEDIFF(dd, GETDATE(), updatetime)=0 and gdid in (" + text6 + ") and ballid=" + set.Tables[0].Rows[num]["id"].ToString().Trim() + " group by ballid order by ballid desc");
}
text3 = double.Parse(MyFunc.GetPlType(set.Tables[0].Rows[num]["pl"].ToString().Trim(), this.Session.Contents["ABC"].ToString().Trim(), set.Tables[0].Rows[num]["give"].ToString().Trim(), "H", "0").ToString("F2")).ToString();
if (reader2.Read())
{
string text12 = text2;
text2 = text12 + "<td align=center class=tznumer>" + text3 + " <br> <a href='tzinfo.aspx?gameid=" + set.Tables[0].Rows[num]["id"].ToString().Trim() + "&tztype=" + text5 + "&marker=C'> <font color=#000088>" + double.Parse(reader2["summoney"].ToString()).ToString() + "</font></a></td> ";
}
else
{
text2 = text2 + "<td align=center class=tznumer>" + text3 + " <br> <font color=#000088>0</font></a></td> ";
}
num++;
reader2.Close();
if (this.Session["sessionSelectStaticCS"].ToString() == "全部")
{
reader2 = base2.ExecuteReader("select max(tztype) as tztype,max(tzteam) as tzteam,count(1) as orderno,isnull(sum(tzmoney),0) as summoney from ball_order where DATEDIFF(dd, GETDATE(), updatetime)=0 and gdid in (" + text6 + ") and ballid=" + set.Tables[0].Rows[num]["id"].ToString().Trim() + " group by ballid order by ballid asc");
}
else
{
reader2 = base2.ExecuteReader("select max(tztype) as tztype,max(tzteam) as tzteam,count(1) as orderno,isnull(sum(tzmoney*(1-csgd-cszdl-csdls)),0) as summoney from ball_order where DATEDIFF(dd, GETDATE(), updatetime)=0 and gdid in (" + text6 + ") and ballid=" + set.Tables[0].Rows[num]["id"].ToString().Trim() + " group by ballid order by ballid desc");
}
text3 = double.Parse(MyFunc.GetPlType(set.Tables[0].Rows[num]["pl"].ToString().Trim(), this.Session.Contents["ABC"].ToString().Trim(), set.Tables[0].Rows[num]["give"].ToString().Trim(), "H", "0").ToString("F2")).ToString();
if (reader2.Read())
{
string text13 = text2;
text2 = text13 + "<td align=center class=tznumer>" + text3 + " <br> <a href='tzinfo.aspx?gameid=" + set.Tables[0].Rows[num]["id"].ToString().Trim() + "&tztype=" + text5 + "&marker=C'> <font color=#000088>" + double.Parse(reader2["summoney"].ToString()).ToString() + "</font></a></td></tr> ";
}
else
{
text2 = text2 + "<td align=center class=tznumer>" + text3 + " <br> <font color=#000088>0</font></a></td></tr> ";
}
num++;
reader2.Close();
}
set.Dispose();
}
}
reader.Close();
base3.CloseConnect();
base3.Dispose();
base2.CloseConnect();
base2.Dispose();
return(text2 + "\n</table></form></body></html>");
}
private string SumAllMember()
{
DataBase base2;
string text2 = "";
string text3 = "";
string text4 = "";
string text5 = "";
int index = 0;
switch (this.Session.Contents["adminclassid"].ToString())
{
case "0":
text5 = " and gdid in (" + this.Session["adminarrgd"].ToString() + "-1) ";
goto Label_0149;
case "1":
text5 = "";
goto Label_0149;
case "2":
text5 = " and gdid = " + this.Session.Contents["adminuserid"] + " ";
goto Label_0149;
case "3":
text5 = " and zdlid = " + this.Session.Contents["adminuserid"] + " ";
break;
case "4":
text5 = " and dlsid = " + this.Session.Contents["adminuserid"] + " ";
break;
}
Label_0149:
base2 = new DataBase(MyFunc.GetConnStr(2));
DataBase base3 = new DataBase(MyFunc.GetConnStr(1));
SqlDataReader reader = null;
SqlDataReader reader2 = null;
DataSet set = null;
double num3 = 0;
string[] textArray = "01,11,21,31,41,特单,02,12,22,32,42,特双,03,13,23,33,43,特大,04,14,24,34,44,特小,05,15,25,35,45,合单,06,16,26,36,46,合双,07,17,27,37,47,08,18,28,38,48,09,19,29,39,49,10,20,30,40".Split(new char[] { ',' });
reader = base2.ExecuteReader("SELECT top 1 convert(nvarchar,updatetime,11) as updatetime,content,qishu,kaisai,tupdatetime FROM affiche WHERE le=1 ORDER BY updatetime DESC");
if (reader.Read())
{
DateTime time = Convert.ToDateTime(reader["kaisai"].ToString().Trim());
TimeSpan span = DateTime.Now.Subtract(time);
int num4 = ((span.Days * 0x5a0) + (span.Hours * 60)) + span.Minutes;
if (num4 < 360)
{
TimeSpan span2 = Convert.ToDateTime(reader["tupdatetime"].ToString().Trim()).Subtract(DateTime.Now);
this.sTime = (((span2.Hours * 0x5a0) + (span2.Minutes * 60)) + span2.Seconds).ToString();
object obj2 = text2;
text2 = string.Concat(new object[] { obj2, "<tr bgcolor='#FFFFFF' ><td rowspan=10>", reader["kaisai"].ToString().Split(new char[] { ' ' })[0].ToString().Trim(), "<BR>", reader["kaisai"].ToString().Split(new char[] { ' ' })[1].ToString().Trim(), "</td><td rowspan=10 align=center>", reader["qishu"], "</td>" });
text4 = reader["kaisai"].ToString();
reader.Close();
set = base3.ExecuteDataSet("SELECT v1.*,isnull((cl.giveup1sum-cl.giveup2sum)/cl.giveupmoney*giveuppl,0) as give FROM Pl as v1 LEFT JOIN changeleave as cl ON (v1.id = cl.ballid AND cl.gsid = '" + this.Session["usergsid"].ToString() + "') where ((id>0 and id<7 )or (id>34 and id <84)) order by id asc");
for (int i = 0; i < 10; i++)
{
if (i != 0)
{
text2 = text2 + "<tr bgcolor='#FFFFFF' >";
}
if (this.Session["sessionSelectStaticCS"].ToString() == "全部")
{
reader2 = base2.ExecuteReader("select max(tztype) as tztype,max(tzteam) as tzteam,count(1) as orderno,isnull(sum(tzmoney),0) as summoney from ball_order where DATEDIFF(dd, GETDATE(), updatetime)=0 " + text5 + " and ballid=" + set.Tables[0].Rows[i + 6]["id"].ToString().Trim() + " group by ballid order by ballid asc");
}
else
{
reader2 = base2.ExecuteReader("select max(tztype) as tztype,max(tzteam) as tzteam,count(1) as orderno,isnull(sum(tzmoney*csdls),0) as summoney from ball_order where DATEDIFF(dd, GETDATE(), updatetime)=0 " + text5 + " and ballid=" + set.Tables[0].Rows[i + 6]["id"].ToString().Trim() + " group by ballid order by ballid desc");
}
text3 = double.Parse(MyFunc.GetPlType(set.Tables[0].Rows[i + 6]["pl"].ToString().Trim(), this.Session.Contents["ABC1"].ToString().Trim(), set.Tables[0].Rows[i + 6]["give"].ToString().Trim(), "H", "0").ToString("F2")).ToString();
string text8 = text2;
text2 = text8 + "<td align=center background=" + MyFunc.GetRGB(textArray[index]) + " class=nums><font color=" + MyFunc.GetRGB(int.Parse(textArray[index])) + "><b>" + textArray[index++] + "</b></font></td>";
if (reader2.Read())
{
string text9 = text2;
text2 = text9 + "<td align=center bgcolor=#FFFFFF ><font color=#CC0000>" + text3 + "</font> <br> <a href='tzinfo.aspx?gameid=" + set.Tables[0].Rows[i + 6]["id"].ToString().Trim() + "&tztype=8&marker=C'><span class=tznumer> <font color=#000088>" + double.Parse(reader2["summoney"].ToString()).ToString() + "</font></span></a></td> ";
num3 += double.Parse(reader2["summoney"].ToString());
}
else
{
text2 = text2 + "<td align=center><font color=#CC0000>" + text3 + "</font> <br> <span class=tznumer><font color=#000088>0</font></span></a></td> ";
}
reader2.Close();
if (this.Session["sessionSelectStaticCS"].ToString() == "全部")
{
reader2 = base2.ExecuteReader("select max(tztype) as tztype,max(tzteam) as tzteam,count(1) as orderno,isnull(sum(tzmoney),0) as summoney from ball_order where DATEDIFF(dd, GETDATE(), updatetime)=0 " + text5 + " and ballid=" + set.Tables[0].Rows[i + 0x10]["id"].ToString().Trim() + " group by ballid order by ballid asc");
}
else
{
reader2 = base2.ExecuteReader("select max(tztype) as tztype,max(tzteam) as tzteam,count(1) as orderno,isnull(sum(tzmoney*csdls),0) as summoney from ball_order where DATEDIFF(dd, GETDATE(), updatetime)=0 " + text5 + " and ballid=" + set.Tables[0].Rows[i + 0x10]["id"].ToString().Trim() + " group by ballid order by ballid desc");
}
text3 = double.Parse(MyFunc.GetPlType(set.Tables[0].Rows[i + 0x10]["pl"].ToString().Trim(), this.Session.Contents["ABC1"].ToString().Trim(), set.Tables[0].Rows[i + 0x10]["give"].ToString().Trim(), "H", "0").ToString("F2")).ToString();
string text10 = text2;
text2 = text10 + "<td align=center background=" + MyFunc.GetRGB(textArray[index]) + " class=nums><font color=" + MyFunc.GetRGB(int.Parse(textArray[index])) + " size=3><b>" + textArray[index++] + "</b></font></td>";
if (reader2.Read())
{
string text11 = text2;
text2 = text11 + "<td align=center bgcolor=#FFFFFF><font color=#CC0000>" + text3 + "</font> <br> <a href='tzinfo.aspx?gameid=" + set.Tables[0].Rows[i + 0x10]["id"].ToString().Trim() + "&tztype=8&marker=C'> <span class=tznumer><font color=#000088>" + double.Parse(reader2["summoney"].ToString()).ToString() + "</span></font></a></td> ";
num3 += double.Parse(reader2["summoney"].ToString());
}
else
{
text2 = text2 + "<td align=center><font color=#CC0000>" + text3 + "</font> <br> <span class=tznumer><font color=#000088>0</font></span></a></td> ";
}
reader2.Close();
if (this.Session["sessionSelectStaticCS"].ToString() == "全部")
{
reader2 = base2.ExecuteReader("select max(tztype) as tztype,max(tzteam) as tzteam,count(1) as orderno,isnull(sum(tzmoney),0) as summoney from ball_order where DATEDIFF(dd, GETDATE(), updatetime)=0 " + text5 + " and ballid=" + set.Tables[0].Rows[i + 0x1a]["id"].ToString().Trim() + " group by ballid order by ballid asc");
}
else
{
reader2 = base2.ExecuteReader("select max(tztype) as tztype,max(tzteam) as tzteam,count(1) as orderno,isnull(sum(tzmoney*csdls),0) as summoney from ball_order where DATEDIFF(dd, GETDATE(), updatetime)=0 " + text5 + " and ballid=" + set.Tables[0].Rows[i + 0x1a]["id"].ToString().Trim() + " group by ballid order by ballid desc");
}
text3 = double.Parse(MyFunc.GetPlType(set.Tables[0].Rows[i + 0x1a]["pl"].ToString().Trim(), this.Session.Contents["ABC1"].ToString().Trim(), set.Tables[0].Rows[i + 0x1a]["give"].ToString().Trim(), "H", "0").ToString("F2")).ToString();
string text12 = text2;
text2 = text12 + "<td align=center background=" + MyFunc.GetRGB(textArray[index]) + " class=nums><font color=" + MyFunc.GetRGB(int.Parse(textArray[index])) + " size=3><b>" + textArray[index++] + "</b></font></td>";
if (reader2.Read())
{
string text13 = text2;
text2 = text13 + "<td align=center bgcolor=#FFFFFF ><font color=#CC0000>" + text3 + "</font> <br> <a href='tzinfo.aspx?gameid=" + set.Tables[0].Rows[i + 0x1a]["id"].ToString().Trim() + "&tztype=8&marker=C'> <span class=tznumer><font color=#000088>" + double.Parse(reader2["summoney"].ToString()).ToString() + "</font></span></a></td> ";
num3 += double.Parse(reader2["summoney"].ToString());
}
else
{
text2 = text2 + "<td align=center ><font color=#CC0000>" + text3 + "</font> <br> <span class=tznumer><font color=#000088>0</font></span></a></td> ";
}
reader2.Close();
if (this.Session["sessionSelectStaticCS"].ToString() == "全部")
{
reader2 = base2.ExecuteReader("select max(tztype) as tztype,max(tzteam) as tzteam,count(1) as orderno,isnull(sum(tzmoney),0) as summoney from ball_order where DATEDIFF(dd, GETDATE(), updatetime)=0 " + text5 + " and ballid=" + set.Tables[0].Rows[i + 0x24]["id"].ToString().Trim() + " group by ballid order by ballid asc");
}
else
{
reader2 = base2.ExecuteReader("select max(tztype) as tztype,max(tzteam) as tzteam,count(1) as orderno,isnull(sum(tzmoney*csdls),0) as summoney from ball_order where DATEDIFF(dd, GETDATE(), updatetime)=0 " + text5 + " and ballid=" + set.Tables[0].Rows[i + 0x24]["id"].ToString().Trim() + " group by ballid order by ballid desc");
}
text3 = double.Parse(MyFunc.GetPlType(set.Tables[0].Rows[i + 0x24]["pl"].ToString().Trim(), this.Session.Contents["ABC1"].ToString().Trim(), set.Tables[0].Rows[i + 0x24]["give"].ToString().Trim(), "H", "0").ToString("F2")).ToString();
string text14 = text2;
text2 = text14 + "<td align=center background=" + MyFunc.GetRGB(textArray[index]) + " class=nums><font color=" + MyFunc.GetRGB(int.Parse(textArray[index])) + " size=3><b>" + textArray[index++] + "</b></font></td>";
if (reader2.Read())
{
string text15 = text2;
text2 = text15 + "<td align=center bgcolor=#FFFFFF ><font color=#CC0000>" + text3 + "</font> <br> <a href='tzinfo.aspx?gameid=" + set.Tables[0].Rows[i + 0x24]["id"].ToString().Trim() + "&tztype=8&marker=C'> <span class=tznumer><font color=#000088>" + double.Parse(reader2["summoney"].ToString()).ToString() + "</font></span></a></td> ";
num3 += double.Parse(reader2["summoney"].ToString());
}
else
{
text2 = text2 + "<td align=center ><font color=#CC0000>" + text3 + "</font> <br> <span class=tznumer><font color=#000088>0</font></span></a></td> ";
}
reader2.Close();
if (i < 9)
{
if (this.Session["sessionSelectStaticCS"].ToString() == "全部")
{
reader2 = base2.ExecuteReader("select max(tztype) as tztype,max(tzteam) as tzteam,count(1) as orderno,isnull(sum(tzmoney),0) as summoney from ball_order where DATEDIFF(dd, GETDATE(), updatetime)=0 " + text5 + " and ballid=" + set.Tables[0].Rows[i + 0x2e]["id"].ToString().Trim() + " group by ballid order by ballid asc");
}
else
{
reader2 = base2.ExecuteReader("select max(tztype) as tztype,max(tzteam) as tzteam,count(1) as orderno,isnull(sum(tzmoney*csdls),0) as summoney from ball_order where DATEDIFF(dd, GETDATE(), updatetime)=0 " + text5 + " and ballid=" + set.Tables[0].Rows[i + 0x2e]["id"].ToString().Trim() + " group by ballid order by ballid desc");
}
text3 = double.Parse(MyFunc.GetPlType(set.Tables[0].Rows[i + 0x2e]["pl"].ToString().Trim(), this.Session.Contents["ABC1"].ToString().Trim(), set.Tables[0].Rows[i + 0x2e]["give"].ToString().Trim(), "H", "0").ToString("F2")).ToString();
string text16 = text2;
text2 = text16 + "<td align=center background=" + MyFunc.GetRGB(textArray[index]) + " class=nums><font color=" + MyFunc.GetRGB(int.Parse(textArray[index])) + " size=3><b>" + textArray[index++] + "</b></font></td>";
if (reader2.Read())
{
string text17 = text2;
text2 = text17 + "<td align=center bgcolor=#FFFFFF ><font color=#CC0000>" + text3 + "</font> <br> <a href='tzinfo.aspx?gameid=" + set.Tables[0].Rows[i + 0x2e]["id"].ToString().Trim() + "&tztype=8&marker=C'> <span class=tznumer><font color=#000088>" + double.Parse(reader2["summoney"].ToString()).ToString() + "</font></span></a></td> ";
num3 += double.Parse(reader2["summoney"].ToString());
}
else
{
text2 = text2 + "<td align=center ><font color=#CC0000>" + text3 + "</font> <br> <span class=tznumer><font color=#000088>0</font></span></a></td> ";
}
reader2.Close();
}
else
{
text2 = text2 + "<td colspan=2> </td>";
}
if (i < 6)
{
if (this.Session["sessionSelectStaticCS"].ToString() == "全部")
{
reader2 = base2.ExecuteReader("select max(tztype) as tztype,max(tzteam) as tzteam,count(1) as orderno,isnull(sum(tzmoney),0) as summoney from ball_order where DATEDIFF(dd, GETDATE(), updatetime)=0 " + text5 + " and ballid=" + set.Tables[0].Rows[i]["id"].ToString().Trim() + " group by ballid order by ballid asc");
}
else
{
reader2 = base2.ExecuteReader("select max(tztype) as tztype,max(tzteam) as tzteam,count(1) as orderno,isnull(sum(tzmoney*csdls),0) as summoney from ball_order where DATEDIFF(dd, GETDATE(), updatetime)=0 " + text5 + " and ballid=" + set.Tables[0].Rows[i]["id"].ToString().Trim() + " group by ballid order by ballid desc");
}
text3 = double.Parse(MyFunc.GetPlType(set.Tables[0].Rows[i]["pl"].ToString().Trim(), this.Session.Contents["ABC"].ToString().Trim(), set.Tables[0].Rows[i]["give"].ToString().Trim(), "H", "0").ToString("F2")).ToString();
text2 = text2 + "<td align=center >" + textArray[index++] + "</td>";
if (reader2.Read())
{
object obj3 = text2;
object[] objArray2 = new object[] { obj3, "<td align=center bgcolor=#FFFFFF><font color=#CC0000>", text3, "</font> <br> <a href='tzinfo.aspx?gameid=", set.Tables[0].Rows[i]["id"].ToString().Trim(), "&tztype=", int.Parse(((i + 2) / 2).ToString()), "&marker=C'> <span class=tznumer><font color=#000088>", double.Parse(reader2["summoney"].ToString()).ToString(), "</font></span></a></td> </tr>" };
text2 = string.Concat(objArray2);
}
else
{
text2 = text2 + "<td align=center bgcolor=#FFFFFF><font color=#CC0000>" + text3 + "</font> <br> <span class=tznumer><font color=#000088>0</font></span></a></td> ";
}
reader2.Close();
}
else
{
text2 = text2 + "<td colspan=2> </td></tr>";
}
}
set.Dispose();
string text18 = text2;
string[] textArray24 = new string[8];
textArray24[0] = text18;
textArray24[1] = "<tr bgcolor='#ffffff' height='25' ><td colspan=14>本页总额<b><font color=blue>";
textArray24[2] = num3.ToString();
textArray24[3] = "</font></b>元(49粒),码均<b><font color=black>";
textArray24[4] = (num3 / 49).ToString("F2");
textArray24[5] = "</font></b>元;按陪率42(12水)估算：如中到<b><font color=red>";
double num27 = (num3 * 0.88) / 42;
textArray24[6] = double.Parse(num27.ToString()).ToString("F2");
textArray24[7] = "</font></b>元投注额,本项目您将输彩</td></tr>";
text2 = string.Concat(textArray24) + "<tr bgColor=#ffffff height=25><TD height=30 colSpan=11>";
try
{
index = int.Parse(base2.ExecuteScalar("select top 1 isnull(ds,0) from ball_order2 where DATEDIFF(dd, GETDATE(), updatetime)=0 and userid=" + this.Session.Contents["adminuserid"]).ToString());
}
catch
{
index = 0;
}
if (index > 0)
{
text2 = text2 + "金额超过" + index.ToString() + "已过给上一级";
this.sTime = "N";
}
else if (int.Parse(this.sTime) < 0)
{
text2 = text2 + "已关闭球赛，不能过单";
this.sTime = "N";
}
else
{
text2 = text2 + "过单金额<input type=hidden name=action value=save><input type=text name=amount onKeyUp=CountGold();><input type=submit name=Submit value=提交>" + "(注：金额超过<span style=color:#FF0000 id=odds0>0</span>将过给上一级)";
}
text2 = text2 + "</TD><td colspan=3><table bgcolor=ffffff><tr><TD id=closeM align=right ><FONT color=red>即将封盘</FONT> 倒数:" + "<SPAN id=close_msg> </SPAN>秒</TD></tr></table>";
}
else
{
text2 = text2 + "<table><tr><TD id=closeM align=right >" + "<SPAN id=close_msg> </SPAN></TD></tr></table>";
}
}
reader.Close();
base3.CloseConnect();
base3.Dispose();
base2.CloseConnect();
base2.Dispose();
return(text2 + "\n</table></form></body></html>");
}
private string[] GetZdRqMsg(string ballid, string team, DataBase db)
{
string sql = "";
string text2 = "";
string text3 = "";
string s = "";
string[] textArray = new string[10];
string[] textArray2 = team.Split(new char[] { ',' });
string[] textArray3 = MyFunc.twelveName.Split(new char[] { ',' });
if (ballid != "0")
{
sql = "SELECT v1.id,v1.tztype,v1.pl,v1.pltype,isnull((cl.giveup1sum-cl.giveup2sum)/cl.giveupmoney*giveuppl,0) as give FROM Pl as v1 left join changeleave as cl On (v1.id = cl.ballid AND cl.gsid = '" + this.Session["usergsid"].ToString() + "') WHERE v1.id =" + ballid;
SqlDataReader reader = db.ExecuteReader(sql);
if (reader.Read())
{
textArray[0] = reader["id"].ToString().Trim();
textArray[2] = "H";
textArray[3] = "H";
text3 = reader["pltype"].ToString().Trim();
if (reader["tztype"].ToString().Trim() == "8")
{
s = double.Parse(MyFunc.GetPlType(reader["pl"].ToString().Trim(), this.Session.Contents["ABC1"].ToString().Trim(), reader["give"].ToString().Trim(), "H", "0").ToString("F2")).ToString();
}
else if (((reader["tztype"].ToString().Trim() == "9") || (reader["tztype"].ToString().Trim() == "10")) || (((reader["tztype"].ToString().Trim() == "18") || (reader["tztype"].ToString().Trim() == "19")) || (reader["tztype"].ToString().Trim() == "20")))
{
s = double.Parse(MyFunc.GetPlType(reader["pl"].ToString().Trim(), "0", reader["give"].ToString().Trim(), "H", "0").ToString("F2")).ToString();
}
else
{
s = double.Parse(MyFunc.GetPlType(reader["pl"].ToString().Trim(), this.Session.Contents["ABC"].ToString().Trim(), reader["give"].ToString().Trim(), "H", "0").ToString("F2")).ToString();
}
textArray[1] = (double.Parse(s) - 1).ToString();
}
reader.Close();
DataBase base2 = new DataBase(MyFunc.GetConnStr(2));
sql = "SELECT top 1 qishu,kaisai FROM affiche WHERE le=1 ORDER BY updatetime DESC";
reader = base2.ExecuteReader(sql);
if (reader.Read())
{
textArray[8] = reader["kaisai"].ToString().Trim();
if (textArray2.Length == 6)
{
string text5 = "";
for (int i = 0; i < 6; i++)
{
text5 = text5 + textArray3[int.Parse(textArray2[i].ToString())].ToString() + ",";
}
text5 = text5.Remove(text5.Length - 1, 1);
text2 = "第" + reader["qishu"].ToString().Trim() + "期 <FONT COLOR=#CC0000>" + text3 + "</font><br>" + text5 + " @ <font color=\"#CC0000\"><B>" + s + "</B></font>";
}
else
{
text2 = "第" + reader["qishu"].ToString().Trim() + "期 <FONT COLOR=#CC0000>" + text3 + "</font> @ <font color=\"#CC0000\"><B>" + s + "</B></font>";
}
}
reader.Close();
textArray[4] = text2.Replace("'", "");
textArray[5] = "1";
textArray[6] = "1";
textArray[7] = "1";
reader.Close();
base2.Dispose();
if ((textArray[0] != "") && (double.Parse(textArray[0]) < 0))
{
return(null);
}
return(textArray);
}
DataBase base3 = new DataBase(MyFunc.GetConnStr(2));
sql = "SELECT top 1 qishu,kaisai FROM affiche WHERE le=1 ORDER BY updatetime DESC";
SqlDataReader reader2 = base3.ExecuteReader(sql);
if (reader2.Read())
{
textArray[8] = reader2["kaisai"].ToString().Trim();
text2 = "第" + reader2["qishu"].ToString().Trim() + "期 ";
}
reader2.Close();
sql = "SELECT v1.id,v1.tztype,v1.pl,v1.pltype,isnull((cl.giveup1sum-cl.giveup2sum)/cl.giveupmoney*giveuppl,0) as give FROM Pl as v1 left join changeleave as cl On (v1.id = cl.ballid AND cl.gsid = '" + this.Session["usergsid"].ToString() + "') WHERE v1.id in (" + team + ")";
reader2 = db.ExecuteReader(sql);
textArray[0] = "9";
double num3 = 1;
while (reader2.Read())
{
textArray[2] = "H";
textArray[3] = "H";
text3 = reader2["pltype"].ToString().Trim();
num3 *= double.Parse(reader2["pl"].ToString().Trim());
string text6 = text2;
text2 = text6 + "<FONT COLOR=#CC0000>" + text3 + "</font> @ <font color=\"#CC0000\"><B>" + double.Parse(MyFunc.GetPlType(reader2["pl"].ToString().Trim(), "0", reader2["give"].ToString().Trim(), "H", "0").ToString("F2")).ToString() + "</B></font><br>";
}
textArray[1] = (num3 - 1).ToString();
textArray[4] = text2.Replace("'", "");
textArray[5] = "1";
textArray[6] = "1";
textArray[7] = "1";
reader2.Close();
base3.Dispose();
if ((textArray[0] != "") && (double.Parse(textArray[0]) < 0))
{
return(null);
}
return(textArray);
}
private string SumAllMember()
{
string text2 = "";
string text3 = "";
string text4 = "";
int index = 0;
DataBase base2 = new DataBase(MyFunc.GetConnStr(2));
DataBase base3 = new DataBase(MyFunc.GetConnStr(1));
SqlDataReader reader = null;
SqlDataReader reader2 = null;
DataSet set = null;
double num3 = 0;
string[] textArray = "01,11,21,31,41,特单,02,12,22,32,42,特双,03,13,23,33,43,特大,04,14,24,34,44,特小,05,15,25,35,45,合单,06,16,26,36,46,合双,07,17,27,37,47,08,18,28,38,48,09,19,29,39,49,10,20,30,40".Split(new char[] { ',' });
reader = base2.ExecuteReader("SELECT top 1 convert(nvarchar,updatetime,11) as updatetime,content,qishu,kaisai FROM affiche WHERE le=1 ORDER BY updatetime DESC");
if (reader.Read())
{
DateTime time = Convert.ToDateTime(reader["kaisai"].ToString().Trim());
TimeSpan span = DateTime.Now.Subtract(time);
int num4 = ((span.Days * 0x5a0) + (span.Hours * 60)) + span.Minutes;
if (num4 < 360)
{
object obj2 = text2;
text2 = string.Concat(new object[] { obj2, "<tr bgcolor='#FFFFFF' ><td rowspan=10>", reader["kaisai"].ToString().Split(new char[] { ' ' })[0].ToString().Trim(), "<BR>", reader["kaisai"].ToString().Split(new char[] { ' ' })[1].ToString().Trim(), "</td><td rowspan=10 align=center>", reader["qishu"], "</td>" });
text4 = reader["kaisai"].ToString();
reader.Close();
set = base3.ExecuteDataSet("SELECT v1.*,isnull((cl.giveup1sum-cl.giveup2sum)/cl.giveupmoney*giveuppl,0) as give FROM Pl as v1 LEFT JOIN changeleave as cl ON (v1.id = cl.ballid AND cl.gsid = '" + this.Session["usergsid"].ToString() + "') where ((id>0 and id<7 )or (id>34 and id <84)) order by id asc");
reader2 = base2.ExecuteReader("select userid from agence where gdid=" + this.Session["adminuserid"].ToString());
string text5 = "";
while (reader2.Read())
{
text5 = text5 + reader2["userid"].ToString().Trim() + ",";
}
reader2.Close();
text5 = text5 + "0";
for (int i = 0; i < 10; i++)
{
if (i != 0)
{
text2 = text2 + "<tr bgcolor='#FFFFFF' >";
}
if (this.Session["sessionSelectStaticCS"].ToString() == "全部")
{
reader2 = base2.ExecuteReader("select max(tztype) as tztype,max(tzteam) as tzteam,count(1) as orderno,isnull(sum(tzmoney),0) as summoney from ball_order where DATEDIFF(dd, GETDATE(), updatetime)=0 and gdid in (" + text5 + ") and ballid=" + set.Tables[0].Rows[i + 6]["id"].ToString().Trim() + " group by ballid order by ballid asc");
}
else
{
reader2 = base2.ExecuteReader("select max(tztype) as tztype,max(tzteam) as tzteam,count(1) as orderno,isnull(sum(tzmoney*(1-csgd-cszdl-csdls)),0) as summoney from ball_order where DATEDIFF(dd, GETDATE(), updatetime)=0 and gdid in (" + text5 + ") and ballid=" + set.Tables[0].Rows[i + 6]["id"].ToString().Trim() + " group by ballid order by ballid desc");
}
text3 = double.Parse(MyFunc.GetPlType(set.Tables[0].Rows[i + 6]["pl"].ToString().Trim(), this.Session.Contents["ABC1"].ToString().Trim(), set.Tables[0].Rows[i + 6]["give"].ToString().Trim(), "H", "0").ToString("F2")).ToString();
string text7 = text2;
text2 = text7 + "<td align=center background=" + MyFunc.GetRGB(textArray[index]) + " class=nums><font color=" + MyFunc.GetRGB(int.Parse(textArray[index])) + " size=3><b>" + textArray[index++] + "</b></font></td>";
if (reader2.Read())
{
string text8 = text2;
text2 = text8 + "<td align=center bgcolor=#FFFFFF ><font color=#CC0000>" + text3 + "</font> <br> <a href='tzinfo.aspx?gameid=" + set.Tables[0].Rows[i + 6]["id"].ToString().Trim() + "&tztype=8&marker=C'><span class=tznumer> <font color=#000088>" + double.Parse(reader2["summoney"].ToString()).ToString() + "</font></span></a></td> ";
num3 += double.Parse(reader2["summoney"].ToString());
}
else
{
text2 = text2 + "<td align=center><font color=#CC0000>" + text3 + "</font> <br> <span class=tznumer><font color=#000088>0</font></span></a></td> ";
}
reader2.Close();
if (this.Session["sessionSelectStaticCS"].ToString() == "全部")
{
reader2 = base2.ExecuteReader("select max(tztype) as tztype,max(tzteam) as tzteam,count(1) as orderno,isnull(sum(tzmoney),0) as summoney from ball_order where DATEDIFF(dd, GETDATE(), updatetime)=0 and gdid in (" + text5 + ") and ballid=" + set.Tables[0].Rows[i + 0x10]["id"].ToString().Trim() + " group by ballid order by ballid asc");
}
else
{
reader2 = base2.ExecuteReader("select max(tztype) as tztype,max(tzteam) as tzteam,count(1) as orderno,isnull(sum(tzmoney*(1-csgd-cszdl-csdls)),0) as summoney from ball_order where DATEDIFF(dd, GETDATE(), updatetime)=0 and gdid in (" + text5 + ") and ballid=" + set.Tables[0].Rows[i + 0x10]["id"].ToString().Trim() + " group by ballid order by ballid desc");
}
text3 = double.Parse(MyFunc.GetPlType(set.Tables[0].Rows[i + 0x10]["pl"].ToString().Trim(), this.Session.Contents["ABC1"].ToString().Trim(), set.Tables[0].Rows[i + 0x10]["give"].ToString().Trim(), "H", "0").ToString("F2")).ToString();
string text9 = text2;
text2 = text9 + "<td align=center background=" + MyFunc.GetRGB(textArray[index]) + " class=nums><font color=" + MyFunc.GetRGB(int.Parse(textArray[index])) + " size=3><b>" + textArray[index++] + "</b></font></td>";
if (reader2.Read())
{
string text10 = text2;
text2 = text10 + "<td align=center bgcolor=#FFFFFF><font color=#CC0000>" + text3 + "</font> <br> <a href='tzinfo.aspx?gameid=" + set.Tables[0].Rows[i + 0x10]["id"].ToString().Trim() + "&tztype=8&marker=C'> <span class=tznumer><font color=#000088>" + double.Parse(reader2["summoney"].ToString()).ToString() + "</span></font></a></td> ";
num3 += double.Parse(reader2["summoney"].ToString());
}
else
{
text2 = text2 + "<td align=center><font color=#CC0000>" + text3 + "</font> <br> <span class=tznumer><font color=#000088>0</font></span></a></td> ";
}
reader2.Close();
if (this.Session["sessionSelectStaticCS"].ToString() == "全部")
{
reader2 = base2.ExecuteReader("select max(tztype) as tztype,max(tzteam) as tzteam,count(1) as orderno,isnull(sum(tzmoney),0) as summoney from ball_order where DATEDIFF(dd, GETDATE(), updatetime)=0 and gdid in (" + text5 + ") and ballid=" + set.Tables[0].Rows[i + 0x1a]["id"].ToString().Trim() + " group by ballid order by ballid asc");
}
else
{
reader2 = base2.ExecuteReader("select max(tztype) as tztype,max(tzteam) as tzteam,count(1) as orderno,isnull(sum(tzmoney*(1-csgd-cszdl-csdls)),0) as summoney from ball_order where DATEDIFF(dd, GETDATE(), updatetime)=0 and gdid in (" + text5 + ") and ballid=" + set.Tables[0].Rows[i + 0x1a]["id"].ToString().Trim() + " group by ballid order by ballid desc");
}
text3 = double.Parse(MyFunc.GetPlType(set.Tables[0].Rows[i + 0x1a]["pl"].ToString().Trim(), this.Session.Contents["ABC1"].ToString().Trim(), set.Tables[0].Rows[i + 0x1a]["give"].ToString().Trim(), "H", "0").ToString("F2")).ToString();
string text11 = text2;
text2 = text11 + "<td align=center background=" + MyFunc.GetRGB(textArray[index]) + " class=nums><font color=" + MyFunc.GetRGB(int.Parse(textArray[index])) + " size=3><b>" + textArray[index++] + "</b></font></td>";
if (reader2.Read())
{
string text12 = text2;
text2 = text12 + "<td align=center bgcolor=#FFFFFF ><font color=#CC0000>" + text3 + "</font> <br> <a href='tzinfo.aspx?gameid=" + set.Tables[0].Rows[i + 0x1a]["id"].ToString().Trim() + "&tztype=8&marker=C'> <span class=tznumer><font color=#000088>" + double.Parse(reader2["summoney"].ToString()).ToString() + "</font></span></a></td> ";
num3 += double.Parse(reader2["summoney"].ToString());
}
else
{
text2 = text2 + "<td align=center ><font color=#CC0000>" + text3 + "</font> <br> <span class=tznumer><font color=#000088>0</font></span></a></td> ";
}
reader2.Close();
if (this.Session["sessionSelectStaticCS"].ToString() == "全部")
{
reader2 = base2.ExecuteReader("select max(tztype) as tztype,max(tzteam) as tzteam,count(1) as orderno,isnull(sum(tzmoney),0) as summoney from ball_order where DATEDIFF(dd, GETDATE(), updatetime)=0 and gdid in (" + text5 + ") and ballid=" + set.Tables[0].Rows[i + 0x24]["id"].ToString().Trim() + " group by ballid order by ballid asc");
}
else
{
reader2 = base2.ExecuteReader("select max(tztype) as tztype,max(tzteam) as tzteam,count(1) as orderno,isnull(sum(tzmoney*(1-csgd-cszdl-csdls)),0) as summoney from ball_order where DATEDIFF(dd, GETDATE(), updatetime)=0 and gdid in (" + text5 + ") and ballid=" + set.Tables[0].Rows[i + 0x24]["id"].ToString().Trim() + " group by ballid order by ballid desc");
}
text3 = double.Parse(MyFunc.GetPlType(set.Tables[0].Rows[i + 0x24]["pl"].ToString().Trim(), this.Session.Contents["ABC1"].ToString().Trim(), set.Tables[0].Rows[i + 0x24]["give"].ToString().Trim(), "H", "0").ToString("F2")).ToString();
string text13 = text2;
text2 = text13 + "<td align=center background=" + MyFunc.GetRGB(textArray[index]) + " class=nums><font color=" + MyFunc.GetRGB(int.Parse(textArray[index])) + " size=3><b>" + textArray[index++] + "</b></font></td>";
if (reader2.Read())
{
string text14 = text2;
text2 = text14 + "<td align=center bgcolor=#FFFFFF ><font color=#CC0000>" + text3 + "</font> <br> <a href='tzinfo.aspx?gameid=" + set.Tables[0].Rows[i + 0x24]["id"].ToString().Trim() + "&tztype=8&marker=C'> <span class=tznumer><font color=#000088>" + double.Parse(reader2["summoney"].ToString()).ToString() + "</font></span></a></td> ";
num3 += double.Parse(reader2["summoney"].ToString());
}
else
{
text2 = text2 + "<td align=center ><font color=#CC0000>" + text3 + "</font> <br> <span class=tznumer><font color=#000088>0</font></span></a></td> ";
}
reader2.Close();
if (i < 9)
{
if (this.Session["sessionSelectStaticCS"].ToString() == "全部")
{
reader2 = base2.ExecuteReader("select max(tztype) as tztype,max(tzteam) as tzteam,count(1) as orderno,isnull(sum(tzmoney),0) as summoney from ball_order where DATEDIFF(dd, GETDATE(), updatetime)=0 and gdid in (" + text5 + ") and ballid=" + set.Tables[0].Rows[i + 0x2e]["id"].ToString().Trim() + " group by ballid order by ballid asc");
}
else
{
reader2 = base2.ExecuteReader("select max(tztype) as tztype,max(tzteam) as tzteam,count(1) as orderno,isnull(sum(tzmoney*(1-csgd-cszdl-csdls)),0) as summoney from ball_order where DATEDIFF(dd, GETDATE(), updatetime)=0 and gdid in (" + text5 + ") and ballid=" + set.Tables[0].Rows[i + 0x2e]["id"].ToString().Trim() + " group by ballid order by ballid desc");
}
text3 = double.Parse(MyFunc.GetPlType(set.Tables[0].Rows[i + 0x2e]["pl"].ToString().Trim(), this.Session.Contents["ABC1"].ToString().Trim(), set.Tables[0].Rows[i + 0x2e]["give"].ToString().Trim(), "H", "0").ToString("F2")).ToString();
string text15 = text2;
text2 = text15 + "<td align=center background=" + MyFunc.GetRGB(textArray[index]) + " class=nums><font color=" + MyFunc.GetRGB(int.Parse(textArray[index])) + " size=3><b>" + textArray[index++] + "</b></font></td>";
if (reader2.Read())
{
string text16 = text2;
text2 = text16 + "<td align=center bgcolor=#FFFFFF ><font color=#CC0000>" + text3 + "</font> <br> <a href='tzinfo.aspx?gameid=" + set.Tables[0].Rows[i + 0x2e]["id"].ToString().Trim() + "&tztype=8&marker=C'> <span class=tznumer><font color=#000088>" + double.Parse(reader2["summoney"].ToString()).ToString() + "</font></span></a></td> ";
num3 += double.Parse(reader2["summoney"].ToString());
}
else
{
text2 = text2 + "<td align=center ><font color=#CC0000>" + text3 + "</font> <br> <span class=tznumer><font color=#000088>0</font></span></a></td> ";
}
reader2.Close();
}
else
{
text2 = text2 + "<td colspan=2> </td>";
}
if (i < 6)
{
if (this.Session["sessionSelectStaticCS"].ToString() == "全部")
{
reader2 = base2.ExecuteReader("select max(tztype) as tztype,max(tzteam) as tzteam,count(1) as orderno,isnull(sum(tzmoney),0) as summoney from ball_order where DATEDIFF(dd, GETDATE(), updatetime)=0 and gdid in (" + text5 + ") and ballid=" + set.Tables[0].Rows[i]["id"].ToString().Trim() + " group by ballid order by ballid asc");
}
else
{
reader2 = base2.ExecuteReader("select max(tztype) as tztype,max(tzteam) as tzteam,count(1) as orderno,isnull(sum(tzmoney*(1-csgd-cszdl-csdls)),0) as summoney from ball_order where DATEDIFF(dd, GETDATE(), updatetime)=0 and gdid in (" + text5 + ") and ballid=" + set.Tables[0].Rows[i]["id"].ToString().Trim() + " group by ballid order by ballid desc");
}
text3 = double.Parse(MyFunc.GetPlType(set.Tables[0].Rows[i]["pl"].ToString().Trim(), this.Session.Contents["ABC"].ToString().Trim(), set.Tables[0].Rows[i]["give"].ToString().Trim(), "H", "0").ToString("F2")).ToString();
text2 = text2 + "<td align=center>" + textArray[index++] + "</td>";
if (reader2.Read())
{
object obj3 = text2;
object[] objArray2 = new object[] { obj3, "<td align=center bgcolor=#FFFFFF><font color=#CC0000>", text3, "</font> <br> <a href='tzinfo.aspx?gameid=", set.Tables[0].Rows[i]["id"].ToString().Trim(), "&tztype=", int.Parse(((i + 2) / 2).ToString()), "&marker=C'> <span class=tznumer><font color=#000088>", double.Parse(reader2["summoney"].ToString()).ToString(), "</font></span></a></td> </tr>" };
text2 = string.Concat(objArray2);
}
else
{
text2 = text2 + "<td align=center bgcolor=#FFFFFF><font color=#CC0000>" + text3 + "</font> <br> <span class=tznumer><font color=#000088>0</font></span></a></td> ";
}
reader2.Close();
}
else
{
text2 = text2 + "<td colspan=2> </td></tr>";
}
}
set.Dispose();
}
}
reader.Close();
base3.CloseConnect();
base3.Dispose();
base2.CloseConnect();
base2.Dispose();
string text17 = text2;
string[] textArray24 = new string[8];
textArray24[0] = text17;
textArray24[1] = "<tr bgcolor='#ffffff' height='25' ><td colspan=14>本页总额<b><font color=blue>";
textArray24[2] = num3.ToString();
textArray24[3] = "</font></b>元(49粒),码均<b><font color=black>";
textArray24[4] = (num3 / 49).ToString("F2");
textArray24[5] = "</font></b>元;按陪率42(12水)估算：如中到<b><font color=red>";
double num26 = (num3 * 0.88) / 42;
textArray24[6] = double.Parse(num26.ToString()).ToString("F2");
textArray24[7] = "</font></b>元投注额,本项目您将输彩</td></tr>";
return(string.Concat(textArray24) + "\n</table></form></body></html>");
}
private string SumAllMember()
{
string text2 = "";
string text3 = "";
string text4 = "";
int index = 0;
DataBase base2 = new DataBase(MyFunc.GetConnStr(2));
DataBase base3 = new DataBase(MyFunc.GetConnStr(1));
SqlDataReader reader = null;
SqlDataReader reader2 = null;
DataSet set = null;
string[] textArray = "0,红波,0,1,绿波,1,2,蓝波,2,3,3,4,4,5,5,6,6,7,7,8,8,9,9,10,10,11,11".Split(new char[] { ',' });
reader = base2.ExecuteReader("SELECT top 1 convert(nvarchar,updatetime,11) as updatetime,content,qishu,kaisai FROM affiche WHERE le=1 ORDER BY updatetime DESC");
if (reader.Read())
{
DateTime time = Convert.ToDateTime(reader["kaisai"].ToString().Trim());
TimeSpan span = DateTime.Now.Subtract(time);
int num3 = ((span.Days * 0x5a0) + (span.Hours * 60)) + span.Minutes;
if (num3 < 360)
{
object obj2 = text2;
text2 = string.Concat(new object[] { obj2, "<tr bgcolor='#FFFFFF' ><td rowspan=12>", reader["kaisai"].ToString().Split(new char[] { ' ' })[0].ToString().Trim(), "<BR>", reader["kaisai"].ToString().Split(new char[] { ' ' })[1].ToString().Trim(), "</td><td rowspan=12 align=center>", reader["qishu"], "</td>" });
text4 = reader["kaisai"].ToString();
reader.Close();
set = base3.ExecuteDataSet("SELECT v1.*,isnull((cl.giveup1sum-cl.giveup2sum)/cl.giveupmoney*giveuppl,0) as give FROM Pl as v1 LEFT JOIN changeleave as cl ON (v1.id = cl.ballid AND cl.gsid = '" + this.Session["usergsid"].ToString() + "') where (id>199 and id<230 ) order by id asc");
for (int i = 0; i < 12; i++)
{
if (i != 0)
{
text2 = text2 + "<tr bgcolor='#FFFFFF' >";
}
if (this.Session["sessionSelectStaticCS"].ToString() == "全部")
{
reader2 = base2.ExecuteReader("select max(tztype) as tztype,max(tzteam) as tzteam,count(1) as orderno,isnull(sum(tzmoney),0) as summoney from ball_order where DATEDIFF(dd, GETDATE(), updatetime)=0 and gdid = '" + this.Session["adminuserid"].ToString() + "' and ballid=" + set.Tables[0].Rows[i]["id"].ToString().Trim() + " group by ballid order by ballid asc");
}
else
{
reader2 = base2.ExecuteReader("select max(tztype) as tztype,max(tzteam) as tzteam,count(1) as orderno,isnull(sum(tzmoney*csgd),0) as summoney from ball_order where DATEDIFF(dd, GETDATE(), updatetime)=0 and gdid = '" + this.Session["adminuserid"].ToString() + "' and ballid=" + set.Tables[0].Rows[i]["id"].ToString().Trim() + " group by ballid order by ballid desc");
}
text3 = double.Parse(MyFunc.GetPlType(set.Tables[0].Rows[i]["pl"].ToString().Trim(), this.Session.Contents["ABC"].ToString().Trim(), set.Tables[0].Rows[i]["give"].ToString().Trim(), "H", "0").ToString("F2")).ToString();
string text6 = text2;
text2 = text6 + "<td align=center>" + MyFunc.GettwelveName(textArray[index]) + "</td><td align=center>" + MyFunc.GettwelveNum(textArray[index++]) + "</td>";
if (reader2.Read())
{
string text7 = text2;
text2 = text7 + "<td align=center class=tznumer>" + text3 + " <br> <a href='tzinfo.aspx?gameid=" + set.Tables[0].Rows[i]["id"].ToString().Trim() + "&tztype=18&marker=C'> <font color=#000088>" + double.Parse(reader2["summoney"].ToString()).ToString() + "</font></a></td> ";
}
else
{
text2 = text2 + "<td align=center class=tznumer>" + text3 + " <br> <font color=#000088>0</font></a></td> ";
}
reader2.Close();
if (i < 3)
{
if (this.Session["sessionSelectStaticCS"].ToString() == "全部")
{
reader2 = base2.ExecuteReader("select max(tztype) as tztype,max(tzteam) as tzteam,count(1) as orderno,isnull(sum(tzmoney),0) as summoney from ball_order where DATEDIFF(dd, GETDATE(), updatetime)=0 and gdid = '" + this.Session["adminuserid"].ToString() + "' and ballid in (" + set.Tables[0].Rows[i + 12]["id"].ToString().Trim() + "," + set.Tables[0].Rows[i + 0x1b]["id"].ToString().Trim() + ") group by tztype order by tztype asc");
}
else
{
reader2 = base2.ExecuteReader("select max(tztype) as tztype,max(tzteam) as tzteam,count(1) as orderno,isnull(sum(tzmoney*csgd),0) as summoney from ball_order where DATEDIFF(dd, GETDATE(), updatetime)=0 and gdid = '" + this.Session["adminuserid"].ToString() + "' and ballid in (" + set.Tables[0].Rows[i + 12]["id"].ToString().Trim() + "," + set.Tables[0].Rows[i + 0x1b]["id"].ToString().Trim() + ") group by tztype order by tztype desc");
}
text3 = double.Parse(MyFunc.GetPlType(set.Tables[0].Rows[i + 12]["pl"].ToString().Trim(), this.Session.Contents["ABC"].ToString().Trim(), set.Tables[0].Rows[i + 0x1a]["give"].ToString().Trim(), "H", "0").ToString("F2")).ToString();
text2 = text2 + "<td align=center>" + textArray[index++] + "</td>";
if (reader2.Read())
{
string text8 = text2;
text2 = text8 + "<td align=center class=tznumer>" + text3 + " <br> <a href='tzinfo.aspx?gameid=" + set.Tables[0].Rows[i + 12]["id"].ToString().Trim() + "," + set.Tables[0].Rows[i + 0x1b]["id"].ToString().Trim() + "&tztype=17&marker=C'> <font color=#000088>" + double.Parse(reader2["summoney"].ToString()).ToString() + "</font></a></td> ";
}
else
{
text2 = text2 + "<td align=center class=tznumer>" + text3 + " <br> <font color=#000088>0</font></a></td> ";
}
reader2.Close();
}
else
{
text2 = text2 + "<td align=center ></td><td align=center ></td>";
}
if (this.Session["sessionSelectStaticCS"].ToString() == "全部")
{
reader2 = base2.ExecuteReader("select max(tztype) as tztype,max(tzteam) as tzteam,count(1) as orderno,isnull(sum(tzmoney),0) as summoney from ball_order where DATEDIFF(dd, GETDATE(), updatetime)=0 and gdid = '" + this.Session["adminuserid"].ToString() + "' and ballid=" + set.Tables[0].Rows[i + 15]["id"].ToString().Trim() + " group by ballid order by ballid asc");
}
else
{
reader2 = base2.ExecuteReader("select max(tztype) as tztype,max(tzteam) as tzteam,count(1) as orderno,isnull(sum(tzmoney*csgd),0) as summoney from ball_order where DATEDIFF(dd, GETDATE(), updatetime)=0 and gdid = '" + this.Session["adminuserid"].ToString() + "' and ballid=" + set.Tables[0].Rows[i + 15]["id"].ToString().Trim() + " group by ballid order by ballid desc");
}
text3 = double.Parse(MyFunc.GetPlType(set.Tables[0].Rows[i + 15]["pl"].ToString().Trim(), this.Session.Contents["ABC"].ToString().Trim(), set.Tables[0].Rows[i]["give"].ToString().Trim(), "H", "0").ToString("F2")).ToString();
string text9 = text2;
text2 = text9 + "<td align=center>" + MyFunc.GettwelveName(textArray[index]) + "</td><td align=center>" + MyFunc.GettwelveNum(textArray[index++]) + "</td>";
if (reader2.Read())
{
string text10 = text2;
text2 = text10 + "<td align=center class=tznumer>" + text3 + " <br> <a href='tzinfo.aspx?gameid=" + set.Tables[0].Rows[i + 15]["id"].ToString().Trim() + "&tztype=19&marker=C'> <font color=#000088>" + double.Parse(reader2["summoney"].ToString()).ToString() + "</font></a></td></tr> ";
}
else
{
text2 = text2 + "<td align=center class=tznumer>" + text3 + " <br> <font color=#000088>0</font></a></td></tr>";
}
reader2.Close();
}
set.Dispose();
}
}
reader.Close();
base3.CloseConnect();
base3.Dispose();
base2.CloseConnect();
base2.Dispose();
return(text2 + "\n</table></form></body></html>");
}
private void MainContent()
{
string text = "";
string text2 = "";
string sql = "";
int num = 0;
TimeSpan span = Convert.ToDateTime(this.kaisai).Subtract(DateTime.Now);
int num2 = ((span.Hours * 0xe10) + (span.Minutes * 60)) + span.Seconds;
if (num2 > 0)
{
if (num2 < 600)
{
this.kyglcontent = "parent.sTime = '" + num2 + "';";
}
DataBase base2 = new DataBase(MyFunc.GetConnStr(1));
sql = "SELECT v1.*,isnull((cl.giveup1sum-cl.giveup2sum)/cl.giveupmoney*giveuppl,0) as give FROM Pl as v1 LEFT JOIN changeleave as cl ON (v1.id = cl.ballid AND cl.gsid = '" + this.Session["usergsid"].ToString() + "') WHERE id>34 and id<84 ORDER BY id asc";
DataSet set = base2.ExecuteDataSet(sql);
for (num = 1; num < 11; num++)
{
if (num != 10)
{
this.kygltable = this.kygltable + "<tr>";
for (int i = 0; i < 5; i++)
{
string text5 = "";
if (i == 0)
{
text5 = "0" + num.ToString();
}
else
{
text5 = ((i * 10) + num).ToString();
}
this.curpl = this.curpl + double.Parse(MyFunc.GetPlType(set.Tables[0].Rows[((i * 10) + num) - 1]["pl"].ToString().Trim(), this.Session.Contents["ABC1"].ToString().Trim(), set.Tables[0].Rows[((i * 10) + num) - 1]["give"].ToString().Trim(), "H", "0").ToString("F2")).ToString() + ",";
this.ballid = this.ballid + double.Parse(set.Tables[0].Rows[((i * 10) + num) - 1]["id"].ToString().Trim()).ToString() + ",";
text = double.Parse(MyFunc.GetPlType(set.Tables[0].Rows[((i * 10) + num) - 1]["pl"].ToString().Trim(), this.Session.Contents["ABC1"].ToString().Trim(), set.Tables[0].Rows[((i * 10) + num) - 1]["give"].ToString().Trim(), "H", "0").ToString("F2")).ToString();
text2 = double.Parse(set.Tables[0].Rows[((i * 10) + num) - 1]["id"].ToString().Trim()).ToString();
string kygltable = this.kygltable;
this.kygltable = kygltable + "<TD class=ball_td align=middle background=" + MyFunc.GetRGB(text5.ToString()) + " height=27><FONT style=\"PADDING-RIGHT: 2px; PADDING-LEFT: 2px; FILTER: glow(color=#000000,strength=1); PADDING-BOTTOM: 2px; COLOR: #000000; PADDING-TOP: 2px; HEIGHT: 10px\">" + text5 + "</FONT></TD>\n";
this.kygltable = this.kygltable + " <TD class=radio_set align=middle><FONT style=\"FONT-WEIGHT: bold; FONT-SIZE: 13px; COLOR: #cc0000\">" + text + "</FONT></TD>\n";
string text8 = this.kygltable;
string[] textArray2 = new string[] { text8, " <TD align=middle><INPUT onkeypress=\"return CheckKey();\" onblur=\"return CountGold(this,'blur','", ((i * 10) + num).ToString(), "');\" onkeyup=\"return CountGold(this,'keyup','", ((i * 10) + num).ToString(), "');\" onfocus=\"CountGold(this,'focus','", ((i * 10) + num).ToString(), "');this.value='';\" tabIndex=", ((i * 10) + num).ToString(), " size=4 name=", text2, "></TD>\n" };
this.kygltable = string.Concat(textArray2);
}
this.kygltable = this.kygltable + "</tr>";
}
else
{
this.kygltable = this.kygltable + "<tr>";
for (int j = 0; j < 4; j++)
{
string text6 = "";
text6 = ((j * 10) + num).ToString();
this.curpl = this.curpl + double.Parse(MyFunc.GetPlType(set.Tables[0].Rows[((j * 10) + num) - 1]["pl"].ToString().Trim(), this.Session.Contents["ABC1"].ToString().Trim(), set.Tables[0].Rows[((j * 10) + num) - 1]["give"].ToString().Trim(), "H", "0").ToString("F2")).ToString() + ",";
this.ballid = this.ballid + double.Parse(set.Tables[0].Rows[((j * 10) + num) - 1]["id"].ToString().Trim()).ToString() + ",";
text = double.Parse(MyFunc.GetPlType(set.Tables[0].Rows[((j * 10) + num) - 1]["pl"].ToString().Trim(), this.Session.Contents["ABC1"].ToString().Trim(), set.Tables[0].Rows[((j * 10) + num) - 1]["give"].ToString().Trim(), "H", "0").ToString("F2")).ToString();
text2 = double.Parse(set.Tables[0].Rows[((j * 10) + num) - 1]["id"].ToString().Trim()).ToString();
string text9 = this.kygltable;
this.kygltable = text9 + "<TD class=ball_td align=middle background=" + MyFunc.GetRGB(text6.ToString()) + " height=27><FONT style=\"PADDING-RIGHT: 2px; PADDING-LEFT: 2px; FILTER: glow(color=#000000,strength=1); PADDING-BOTTOM: 2px; COLOR: #000000; PADDING-TOP: 2px; HEIGHT: 10px\">" + text6 + "</FONT></TD>\n";
this.kygltable = this.kygltable + " <TD class=radio_set align=middle><FONT style=\"FONT-WEIGHT: bold; FONT-SIZE: 13px; COLOR: #cc0000\">" + text + "</FONT></TD>\n";
string text10 = this.kygltable;
string[] textArray4 = new string[] { text10, " <TD align=middle><INPUT onkeypress=\"return CheckKey();\" onblur=\"return CountGold(this,'blur','", ((j * 10) + num).ToString(), "');\" onkeyup=\"return CountGold(this,'keyup','", ((j * 10) + num).ToString(), "');\" onfocus=\"CountGold(this,'focus','", ((j * 10) + num).ToString(), "');this.value='';\" tabIndex=", ((j * 10) + num).ToString(), " size=4 name=", text2, "></TD>\n" };
this.kygltable = string.Concat(textArray4);
}
this.kygltable = this.kygltable + " <TD align=middle colSpan=3><INPUT onclick=\"return ChkSubmit();\" type=button value=确定 name=btnSubmit><INPUT onclick=\"location.href='quickinput2.aspx'\" type=reset value=重设 name=btnReset> </TD></tr>";
}
}
this.ballid = this.ballid.Substring(0, this.ballid.Length - 1);
this.curpl = this.curpl.Substring(0, this.curpl.Length - 1);
base2.Dispose();
this.gTime = this.kaisai;
}
}
private void MainContent()
{
string text = "";
string text2 = "";
string sql = "";
int num = 0;
TimeSpan span = Convert.ToDateTime(this.kaisai).Subtract(DateTime.Now);
int num2 = ((span.Hours * 0xe10) + (span.Minutes * 60)) + span.Seconds;
if (num2 > 0)
{
if (num2 < 600)
{
this.kyglcontent = "parent.sTime = '" + num2 + "';";
}
DataBase base2 = new DataBase(MyFunc.GetConnStr(1));
sql = "SELECT v1.*,isnull((cl.giveup1sum-cl.giveup2sum)/cl.giveupmoney*giveuppl,0) as give FROM Pl as v1 LEFT JOIN changeleave as cl ON (v1.id = cl.ballid AND cl.gsid = '" + this.Session["usergsid"].ToString() + "') WHERE id>0 and id<35 ORDER BY id asc";
DataSet set = base2.ExecuteDataSet(sql);
num = 0;
for (int i = 0; i < 4; i++)
{
this.curpl = this.curpl + double.Parse(MyFunc.GetPlType(set.Tables[0].Rows[(num * 5) + i]["pl"].ToString().Trim(), this.Session.Contents["ABC"].ToString().Trim(), set.Tables[0].Rows[(num * 5) + i]["give"].ToString().Trim(), "H", "0").ToString("F2")).ToString() + ",";
this.ballid = this.ballid + double.Parse(set.Tables[0].Rows[(num * 5) + i]["id"].ToString().Trim()).ToString() + ",";
text = double.Parse(MyFunc.GetPlType(set.Tables[0].Rows[(num * 5) + i]["pl"].ToString().Trim(), this.Session.Contents["ABC"].ToString().Trim(), set.Tables[0].Rows[(num * 5) + i]["give"].ToString().Trim(), "H", "0").ToString("F2")).ToString();
text2 = double.Parse(set.Tables[0].Rows[(num * 5) + i]["id"].ToString().Trim()).ToString();
this.MainTable.Rows[num + 1].Cells[(3 * i) + 1].InnerHtml = "<FONT style=\"FONT-WEIGHT: bold; FONT-SIZE: 15px; COLOR: #cc0000\">" + text + "</font>";
}
num = 1;
for (int j = 0; j < 2; j++)
{
this.curpl = this.curpl + double.Parse(MyFunc.GetPlType(set.Tables[0].Rows[(num * 4) + j]["pl"].ToString().Trim(), this.Session.Contents["ABC"].ToString().Trim(), set.Tables[0].Rows[(num * 4) + j]["give"].ToString().Trim(), "H", "0").ToString("F2")).ToString() + ",";
this.ballid = this.ballid + double.Parse(set.Tables[0].Rows[(num * 4) + j]["id"].ToString().Trim()).ToString() + ",";
text = double.Parse(MyFunc.GetPlType(set.Tables[0].Rows[(num * 4) + j]["pl"].ToString().Trim(), this.Session.Contents["ABC"].ToString().Trim(), set.Tables[0].Rows[(num * 4) + j]["give"].ToString().Trim(), "H", "0").ToString("F2")).ToString();
text2 = double.Parse(set.Tables[0].Rows[(num * 4) + j]["id"].ToString().Trim()).ToString();
this.MainTable.Rows[num + 1].Cells[(3 * j) + 1].InnerHtml = "<FONT style=\"FONT-WEIGHT: bold; FONT-SIZE: 15px; COLOR: #cc0000\">" + text + "</font>";
}
num = 2;
for (int k = 0; k < 4; k++)
{
this.curpl = this.curpl + double.Parse(MyFunc.GetPlType(set.Tables[0].Rows[6 + k]["pl"].ToString().Trim(), this.Session.Contents["ABC"].ToString().Trim(), set.Tables[0].Rows[6 + k]["give"].ToString().Trim(), "H", "0").ToString("F2")).ToString() + ",";
this.ballid = this.ballid + double.Parse(set.Tables[0].Rows[6 + k]["id"].ToString().Trim()).ToString() + ",";
text = double.Parse(MyFunc.GetPlType(set.Tables[0].Rows[6 + k]["pl"].ToString().Trim(), this.Session.Contents["ABC"].ToString().Trim(), set.Tables[0].Rows[6 + k]["give"].ToString().Trim(), "H", "0").ToString("F2")).ToString();
text2 = double.Parse(set.Tables[0].Rows[6 + k]["id"].ToString().Trim()).ToString();
this.MainTable.Rows[num + 1].Cells[(3 * k) + 1].InnerHtml = "<FONT style=\"FONT-WEIGHT: bold; FONT-SIZE: 15px; COLOR: #cc0000\">" + text + "</font>";
}
for (num = 0; num < 4; num++)
{
for (int m = 0; m < 4; m++)
{
this.curpl = this.curpl + double.Parse(MyFunc.GetPlType(set.Tables[0].Rows[(10 + (num * 6)) + m]["pl"].ToString().Trim(), this.Session.Contents["ABC"].ToString().Trim(), set.Tables[0].Rows[(10 + (num * 6)) + m]["give"].ToString().Trim(), "H", "0").ToString("F2")).ToString() + ",";
this.ballid = this.ballid + double.Parse(set.Tables[0].Rows[(10 + (num * 6)) + m]["id"].ToString().Trim()).ToString() + ",";
text = double.Parse(MyFunc.GetPlType(set.Tables[0].Rows[(10 + (num * 6)) + m]["pl"].ToString().Trim(), this.Session.Contents["ABC"].ToString().Trim(), set.Tables[0].Rows[(10 + (num * 6)) + m]["give"].ToString().Trim(), "H", "0").ToString("F2")).ToString();
text2 = double.Parse(set.Tables[0].Rows[(10 + (num * 6)) + m]["id"].ToString().Trim()).ToString();
this.MainTable1.Rows[num + 2].Cells[(3 * m) + 1].InnerHtml = "<FONT style=\"FONT-WEIGHT: bold; FONT-SIZE: 15px; COLOR: #cc0000\">" + text + "</font>";
}
}
for (num = 0; num < 4; num++)
{
for (int n = 4; n < 6; n++)
{
this.curpl = this.curpl + double.Parse(MyFunc.GetPlType(set.Tables[0].Rows[(10 + (num * 6)) + n]["pl"].ToString().Trim(), this.Session.Contents["ABC"].ToString().Trim(), set.Tables[0].Rows[(10 + (num * 6)) + n]["give"].ToString().Trim(), "H", "0").ToString("F2")).ToString() + ",";
this.ballid = this.ballid + double.Parse(set.Tables[0].Rows[(10 + (num * 6)) + n]["id"].ToString().Trim()).ToString() + ",";
text = double.Parse(MyFunc.GetPlType(set.Tables[0].Rows[(10 + (num * 6)) + n]["pl"].ToString().Trim(), this.Session.Contents["ABC"].ToString().Trim(), set.Tables[0].Rows[(10 + (num * 6)) + n]["give"].ToString().Trim(), "H", "0").ToString("F2")).ToString();
text2 = double.Parse(set.Tables[0].Rows[(10 + (num * 6)) + n]["id"].ToString().Trim()).ToString();
this.MainTable1.Rows[num + 8].Cells[((3 * n) + 2) - 13].InnerHtml = "<FONT style=\"FONT-WEIGHT: bold; FONT-SIZE: 15px; COLOR: #cc0000\">" + text + "</font>";
}
}
this.ballid = this.ballid.Substring(0, this.ballid.Length - 1);
this.curpl = this.curpl.Substring(0, this.curpl.Length - 1);
base2.Dispose();
this.gTime = this.kaisai;
}
}
