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 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 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 FootBallList()
{
int num2;
int start;
int pagesize = 10;
try
{
num2 = int.Parse(base.Request.Form["page"].ToString());
}
catch
{
num2 = 1;
}
if (num2 < 1)
{
num2 = 1;
}
DataBase base2 = new DataBase(MyFunc.GetConnStr(2));
int num4 = int.Parse(base2.ExecuteScalar("SELECT COUNT(1) FROM Ball_bf1 ").ToString());
if (num4 > 120)
{
pagesize = (num4 / 2) + 1;
}
if (num4 == 0)
{
start = 0;
}
else
{
start = (num2 - 1) * pagesize;
}
int num3 = num4 / pagesize;
if ((num4 % pagesize) > 0)
{
num3++;
}
for (int i = 1; i <= num3; i++)
{
if (num2 == i)
{
object pageorder = this.pageorder;
this.pageorder = string.Concat(new object[] { pageorder, "<option value=", i, " selected >", i, "</option>" });
}
else
{
object obj3 = this.pageorder;
this.pageorder = string.Concat(new object[] { obj3, "<option value=", i, " >", i, "</option>" });
}
}
object obj4 = this.pageorder;
this.pageorder = string.Concat(new object[] { obj4, "/ ", num3, " 页" });
string sql = "SELECT qishu,ballid,balltime ,isnull(num1,0) as num1,isnull(num2,0) as num2,isnull(num3,0) as num3,isnull(num4,0) as num4,isnull(num5,0) as num5,isnull(num6,0) as num6,isnull(tema,0) as tema FROM Ball_bf1 order by balltime desc";
DataSet set = base2.ExecuteDataSet(sql, start, pagesize, "ball_pl1");
int num7 = 0;
num7 = start;
for (int j = 0; j < set.Tables[0].Rows.Count; j++)
{
this.kyglcontent = this.kyglcontent + " <TR class=list_cen><TD align=\"center\">" + set.Tables[0].Rows[j]["qishu"].ToString().Trim() + "</TD>";
this.kyglcontent = this.kyglcontent + "<TD nowrap bgcolor=\"#C8D1D6\" align=center>" + set.Tables[0].Rows[j]["balltime"].ToString() + "</TD>";
string kyglcontent = this.kyglcontent;
this.kyglcontent = kyglcontent + "<TD width=50 align=middle bgcolor=\"C1D7E5\" class=\"ball_td\" align=\"center\" background=" + MyFunc.GetRGB(set.Tables[0].Rows[j]["num1"].ToString()) + " height=\"27\"><font style=\"filter: glow(color=#000000,strength=1); height:10px; color:#000000; padding:2px\">" + set.Tables[0].Rows[j]["num1"].ToString() + "</font></TD>";
string text9 = this.kyglcontent;
this.kyglcontent = text9 + "<TD width=50 align=middle bgcolor=\"C1D7E5\" class=\"ball_td\" align=\"center\" background=" + MyFunc.GetRGB(set.Tables[0].Rows[j]["num2"].ToString()) + " height=\"27\"><font style=\"filter: glow(color=#000000,strength=1); height:10px; color:#000000; padding:2px\">" + set.Tables[0].Rows[j]["num2"].ToString() + "</font></TD>";
string text10 = this.kyglcontent;
this.kyglcontent = text10 + "<TD width=50 align=middle bgcolor=\"C1D7E5\" class=\"ball_td\" align=\"center\" background=" + MyFunc.GetRGB(set.Tables[0].Rows[j]["num3"].ToString()) + " height=\"27\"><font style=\"filter: glow(color=#000000,strength=1); height:10px; color:#000000; padding:2px\">" + set.Tables[0].Rows[j]["num3"].ToString() + "</font></TD>";
string text11 = this.kyglcontent;
this.kyglcontent = text11 + "<TD width=50 align=middle bgcolor=\"C1D7E5\" class=\"ball_td\" align=\"center\" background=" + MyFunc.GetRGB(set.Tables[0].Rows[j]["num4"].ToString()) + " height=\"27\"><font style=\"filter: glow(color=#000000,strength=1); height:10px; color:#000000; padding:2px\">" + set.Tables[0].Rows[j]["num4"].ToString() + "</font></TD>";
string text12 = this.kyglcontent;
this.kyglcontent = text12 + "<TD width=50 align=middle bgcolor=\"C1D7E5\" class=\"ball_td\" align=\"center\" background=" + MyFunc.GetRGB(set.Tables[0].Rows[j]["num5"].ToString()) + " height=\"27\"><font style=\"filter: glow(color=#000000,strength=1); height:10px; color:#000000; padding:2px\">" + set.Tables[0].Rows[j]["num5"].ToString() + "</font></TD>";
string text13 = this.kyglcontent;
this.kyglcontent = text13 + "<TD width=50 align=middle bgcolor=\"C1D7E5\" class=\"ball_td\" align=\"center\" background=" + MyFunc.GetRGB(set.Tables[0].Rows[j]["num6"].ToString()) + " height=\"27\"><font style=\"filter: glow(color=#000000,strength=1); height:10px; color:#000000; padding:2px\">" + set.Tables[0].Rows[j]["num6"].ToString() + "</font></TD>";
string text14 = this.kyglcontent;
this.kyglcontent = text14 + "<TD width=50 align=middle bgcolor=\"C1D7E5\" class=\"ball_td\" align=\"center\" background=" + MyFunc.GetRGB(set.Tables[0].Rows[j]["tema"].ToString()) + " height=\"27\"><font style=\"filter: glow(color=#000000,strength=1); height:10px; color:#000000; padding:2px\">" + set.Tables[0].Rows[j]["tema"].ToString() + "</font></TD>";
num7 = (((((this.myInt(set.Tables[0].Rows[j]["num1"].ToString()) + this.myInt(set.Tables[0].Rows[j]["num2"].ToString())) + this.myInt(set.Tables[0].Rows[j]["num3"].ToString())) + this.myInt(set.Tables[0].Rows[j]["num4"].ToString())) + this.myInt(set.Tables[0].Rows[j]["num5"].ToString())) + this.myInt(set.Tables[0].Rows[j]["num6"].ToString())) + this.myInt(set.Tables[0].Rows[j]["tema"].ToString());
object obj5 = this.kyglcontent;
this.kyglcontent = string.Concat(new object[] { obj5, "<TD width=50 align=middle bgcolor=\"C1D7E5\" height=\"27\"><strong>", num7, "</strong></td><td><a href=\"ballmsg.aspx?ballid=", set.Tables[0].Rows[j]["ballid"].ToString().Trim(), "&action=mod\">修改</a> / " });
this.kyglcontent = this.kyglcontent + "<a href=\"javascript:if(confirm('确定删除！'))window.location='balllist.aspx?ballid=" + set.Tables[0].Rows[j]["ballid"].ToString().Trim() + "&action=del';\">删除</a></td></TR>";
}
set.Dispose();
base2.Dispose();
}
private void recalculate(string n1, string n2, string n3, string n4, string n5, string n6, string te)
{
string sql = "";
string text2 = n1 + "," + n2 + "," + n3 + "," + n4 + "," + n5 + "," + n6 + "," + te;
string[] tztype = text2.Split(new char[] { ',' });
int num = (((((int.Parse(n1) + int.Parse(n2)) + int.Parse(n3)) + int.Parse(n4)) + int.Parse(n5)) + int.Parse(n6)) + int.Parse(te);
DataBase base2 = new DataBase(MyFunc.GetConnStr(1));
if (int.Parse(tztype[6]) != 0x31)
{
if ((int.Parse(tztype[6]) % 2) == 0)
{
sql = sql + "UPDATE pl SET result=0 WHERE id=1;" + "UPDATE pl SET result=1 WHERE id=2;";
}
else
{
sql = sql + "UPDATE pl SET result=0 WHERE id=2;" + "UPDATE pl SET result=1 WHERE id=1;";
}
}
else
{
sql = sql + "UPDATE pl SET result=20 WHERE id=2;" + "UPDATE pl SET result=20 WHERE id=1;";
}
if (int.Parse(tztype[6]) != 0x31)
{
if (int.Parse(tztype[6]) >= 0x19)
{
sql = sql + "UPDATE pl SET result=0 WHERE id=4;" + "UPDATE pl SET result=1 WHERE id=3;";
}
else
{
sql = sql + "UPDATE pl SET result=0 WHERE id=3;" + "UPDATE pl SET result=1 WHERE id=4;";
}
}
else
{
sql = sql + "UPDATE pl SET result=20 WHERE id=3;" + "UPDATE pl SET result=20 WHERE id=4;";
}
if (int.Parse(tztype[6]) != 0x31)
{
if (((int.Parse(tztype[6].ToString().Substring(0, 1)) + int.Parse(tztype[6].ToString().Substring(1, 1))) % 2) == 0)
{
sql = sql + "UPDATE pl SET result=0 WHERE id=5;" + "UPDATE pl SET result=1 WHERE id=6;";
}
else
{
sql = sql + "UPDATE pl SET result=0 WHERE id=6;" + "UPDATE pl SET result=1 WHERE id=5;";
}
}
else
{
sql = sql + "UPDATE pl SET result=20 WHERE id=5;" + "UPDATE pl SET result=20 WHERE id=6;";
}
if ((num % 2) == 0)
{
sql = sql + "UPDATE pl SET result=0 WHERE id=7;" + "UPDATE pl SET result=1 WHERE id=8;";
}
else
{
sql = sql + "UPDATE pl SET result=0 WHERE id=8;" + "UPDATE pl SET result=1 WHERE id=7;";
}
if (num >= 0xaf)
{
sql = sql + "UPDATE pl SET result=0 WHERE id=10;" + "UPDATE pl SET result=1 WHERE id=9;";
}
else
{
sql = sql + "UPDATE pl SET result=1 WHERE id=10;" + "UPDATE pl SET result=0 WHERE id=9;";
}
for (int i = 0; i < 6; i++)
{
if (int.Parse(tztype[i]) != 0x31)
{
if ((int.Parse(tztype[i]) % 2) == 0)
{
object obj2 = sql;
object obj3 = string.Concat(new object[] { obj2, "UPDATE pl SET result=0 WHERE id=", i + 11, ";" });
sql = string.Concat(new object[] { obj3, "UPDATE pl SET result=1 WHERE id=", i + 0x11, ";" });
}
else
{
object obj4 = sql;
object obj5 = string.Concat(new object[] { obj4, "UPDATE pl SET result=0 WHERE id=", i + 0x11, ";" });
sql = string.Concat(new object[] { obj5, "UPDATE pl SET result=1 WHERE id=", i + 11, ";" });
}
}
else
{
object obj6 = sql;
object obj7 = string.Concat(new object[] { obj6, "UPDATE pl SET result=20 WHERE id=", i + 11, ";" });
sql = string.Concat(new object[] { obj7, "UPDATE pl SET result=20 WHERE id=", i + 0x11, ";" });
}
}
for (int j = 0; j < 6; j++)
{
if (int.Parse(tztype[j]) != 0x31)
{
if (int.Parse(tztype[j]) >= 0x19)
{
object obj8 = sql;
object obj9 = string.Concat(new object[] { obj8, "UPDATE pl SET result=0 WHERE id=", j + 0x1d, ";" });
sql = string.Concat(new object[] { obj9, "UPDATE pl SET result=1 WHERE id=", j + 0x17, ";" });
}
else
{
object obj10 = sql;
object obj11 = string.Concat(new object[] { obj10, "UPDATE pl SET result=0 WHERE id=", j + 0x17, ";" });
sql = string.Concat(new object[] { obj11, "UPDATE pl SET result=1 WHERE id=", j + 0x1d, ";" });
}
}
else
{
object obj12 = sql;
object obj13 = string.Concat(new object[] { obj12, "UPDATE pl SET result=20 WHERE id=", j + 0x1d, ";" });
sql = string.Concat(new object[] { obj13, "UPDATE pl SET result=20 WHERE id=", j + 0x17, ";" });
}
}
for (int k = 1; k < 50; k++)
{
if (int.Parse(tztype[6]) == k)
{
object obj14 = sql;
sql = string.Concat(new object[] { obj14, "UPDATE pl SET result=1 WHERE id=", k + 0x22, ";" });
}
else
{
object obj15 = sql;
sql = string.Concat(new object[] { obj15, "UPDATE pl SET result=0 WHERE id=", k + 0x22, ";" });
}
}
for (int m = 1; m < 50; m++)
{
if ((((int.Parse(tztype[0]) == m) || (int.Parse(tztype[1]) == m)) || ((int.Parse(tztype[2]) == m) || (int.Parse(tztype[3]) == m))) || ((int.Parse(tztype[4]) == m) || (int.Parse(tztype[5]) == m)))
{
object obj16 = sql;
sql = string.Concat(new object[] { obj16, "UPDATE pl SET result=1 WHERE id=", m + 0x53, ";" });
}
else
{
object obj17 = sql;
sql = string.Concat(new object[] { obj17, "UPDATE pl SET result=0 WHERE id=", m + 0x53, ";" });
}
}
for (int n = 0; n < 6; n++)
{
if (MyFunc.GetRGB(int.Parse(tztype[n])) == "red")
{
object obj18 = sql;
object obj19 = string.Concat(new object[] { obj18, "UPDATE pl SET result=1 WHERE id=", n + 0x85, ";" });
object obj20 = string.Concat(new object[] { obj19, "UPDATE pl SET result=0 WHERE id=", n + 0x8b, ";" });
sql = string.Concat(new object[] { obj20, "UPDATE pl SET result=0 WHERE id=", n + 0x91, ";" });
}
else if (MyFunc.GetRGB(int.Parse(tztype[n])) == "green")
{
object obj21 = sql;
object obj22 = string.Concat(new object[] { obj21, "UPDATE pl SET result=0 WHERE id=", n + 0x85, ";" });
object obj23 = string.Concat(new object[] { obj22, "UPDATE pl SET result=1 WHERE id=", n + 0x8b, ";" });
sql = string.Concat(new object[] { obj23, "UPDATE pl SET result=0 WHERE id=", n + 0x91, ";" });
}
else
{
object obj24 = sql;
object obj25 = string.Concat(new object[] { obj24, "UPDATE pl SET result=0 WHERE id=", n + 0x85, ";" });
object obj26 = string.Concat(new object[] { obj25, "UPDATE pl SET result=0 WHERE id=", n + 0x8b, ";" });
sql = string.Concat(new object[] { obj26, "UPDATE pl SET result=1 WHERE id=", n + 0x91, ";" });
}
}
for (int index = 0; index < 6; index++)
{
if ((int.Parse(tztype[index]) % 2) == 0)
{
object obj27 = sql;
object obj28 = string.Concat(new object[] { obj27, "UPDATE pl SET result=0 WHERE id=", (index * 7) + 0x9e, ";" });
sql = string.Concat(new object[] { obj28, "UPDATE pl SET result=1 WHERE id=", (index * 7) + 0x9f, ";" });
}
else
{
object obj29 = sql;
object obj30 = string.Concat(new object[] { obj29, "UPDATE pl SET result=0 WHERE id=", (index * 7) + 0x9f, ";" });
sql = string.Concat(new object[] { obj30, "UPDATE pl SET result=1 WHERE id=", (index * 7) + 0x9e, ";" });
}
}
for (int num8 = 0; num8 < 6; num8++)
{
if (int.Parse(tztype[num8]) >= 0x19)
{
object obj31 = sql;
object obj32 = string.Concat(new object[] { obj31, "UPDATE pl SET result=0 WHERE id=", (num8 * 7) + 0xa1, ";" });
sql = string.Concat(new object[] { obj32, "UPDATE pl SET result=1 WHERE id=", (num8 * 7) + 160, ";" });
}
else
{
object obj33 = sql;
object obj34 = string.Concat(new object[] { obj33, "UPDATE pl SET result=0 WHERE id=", (num8 * 7) + 160, ";" });
sql = string.Concat(new object[] { obj34, "UPDATE pl SET result=1 WHERE id=", (num8 * 7) + 0xa1, ";" });
}
}
for (int num9 = 0; num9 < 6; num9++)
{
if (MyFunc.GetRGB(int.Parse(tztype[num9])) == "red")
{
object obj35 = sql;
object obj36 = string.Concat(new object[] { obj35, "UPDATE pl SET result=1 WHERE id=", (num9 * 7) + 0xa2, ";" });
object obj37 = string.Concat(new object[] { obj36, "UPDATE pl SET result=0 WHERE id=", (num9 * 7) + 0xa3, ";" });
sql = string.Concat(new object[] { obj37, "UPDATE pl SET result=0 WHERE id=", (num9 * 7) + 0xa4, ";" });
}
else if (MyFunc.GetRGB(int.Parse(tztype[num9])) == "green")
{
object obj38 = sql;
object obj39 = string.Concat(new object[] { obj38, "UPDATE pl SET result=0 WHERE id=", (num9 * 7) + 0xa2, ";" });
object obj40 = string.Concat(new object[] { obj39, "UPDATE pl SET result=1 WHERE id=", (num9 * 7) + 0xa3, ";" });
sql = string.Concat(new object[] { obj40, "UPDATE pl SET result=0 WHERE id=", (num9 * 7) + 0xa4, ";" });
}
else
{
object obj41 = sql;
object obj42 = string.Concat(new object[] { obj41, "UPDATE pl SET result=0 WHERE id=", (num9 * 7) + 0xa2, ";" });
object obj43 = string.Concat(new object[] { obj42, "UPDATE pl SET result=0 WHERE id=", (num9 * 7) + 0xa3, ";" });
sql = string.Concat(new object[] { obj43, "UPDATE pl SET result=1 WHERE id=", (num9 * 7) + 0xa4, ";" });
}
}
for (int num10 = 0; num10 < 12; num10++)
{
if (MyFunc.GettwelveId(tztype[6]) == num10.ToString())
{
object obj44 = sql;
sql = string.Concat(new object[] { obj44, "UPDATE pl SET result=1 WHERE id=", num10 + 200, ";" });
}
else
{
object obj45 = sql;
sql = string.Concat(new object[] { obj45, "UPDATE pl SET result=0 WHERE id=", num10 + 200, ";" });
}
}
if (MyFunc.GetRGB(int.Parse(tztype[6])) == "red")
{
sql = (sql + "UPDATE pl SET result=1 WHERE id=212;") + "UPDATE pl SET result=0 WHERE id=213;" + "UPDATE pl SET result=0 WHERE id=214;";
}
else if (MyFunc.GetRGB(int.Parse(tztype[6])) == "green")
{
sql = (sql + "UPDATE pl SET result=0 WHERE id=212;") + "UPDATE pl SET result=1 WHERE id=213;" + "UPDATE pl SET result=0 WHERE id=214;";
}
else
{
sql = (sql + "UPDATE pl SET result=0 WHERE id=212;") + "UPDATE pl SET result=0 WHERE id=213;" + "UPDATE pl SET result=1 WHERE id=214;";
}
for (int num11 = 0; num11 < 12; num11++)
{
if (text2.IndexOf("49") == -1)
{
if (MyFunc.GettwelveId(tztype, num11) > 0)
{
object obj46 = sql;
sql = string.Concat(new object[] { obj46, "UPDATE pl SET result=1 WHERE id=", num11 + 0xd7, ";" });
}
else
{
object obj47 = sql;
sql = string.Concat(new object[] { obj47, "UPDATE pl SET result=0 WHERE id=", num11 + 0xd7, ";" });
}
}
else if (int.Parse(MyFunc.GettwelveId("49")) != num11)
{
if (MyFunc.GettwelveId(tztype, num11) > 0)
{
object obj48 = sql;
sql = string.Concat(new object[] { obj48, "UPDATE pl SET result=1 WHERE id=", num11 + 0xd7, ";" });
}
else
{
object obj49 = sql;
sql = string.Concat(new object[] { obj49, "UPDATE pl SET result=0 WHERE id=", num11 + 0xd7, ";" });
}
}
else if (MyFunc.GettwelveId(tztype, num11) > 1)
{
object obj50 = sql;
sql = string.Concat(new object[] { obj50, "UPDATE pl SET result=1 WHERE id=", num11 + 0xd7, ";" });
}
else if (MyFunc.GettwelveId(tztype, num11) == 1)
{
object obj51 = sql;
sql = string.Concat(new object[] { obj51, "UPDATE pl SET result=20 WHERE id=", num11 + 0xd7, ";" });
}
else
{
object obj52 = sql;
sql = string.Concat(new object[] { obj52, "UPDATE pl SET result=0 WHERE id=", num11 + 0xd7, ";" });
}
}
if (MyFunc.GetRGB(int.Parse(tztype[6])) == "red")
{
if (int.Parse(tztype[6]) != 0x31)
{
if ((int.Parse(tztype[6]) % 2) == 0)
{
sql = sql + "UPDATE pl SET result=0 WHERE id=232;" + "UPDATE pl SET result=1 WHERE id=233;";
}
else
{
sql = sql + "UPDATE pl SET result=0 WHERE id=233;" + "UPDATE pl SET result=1 WHERE id=232;";
}
}
if (int.Parse(tztype[6]) != 0x31)
{
if (int.Parse(tztype[6]) >= 0x19)
{
sql = sql + "UPDATE pl SET result=0 WHERE id=235;" + "UPDATE pl SET result=1 WHERE id=234;";
}
else
{
sql = sql + "UPDATE pl SET result=0 WHERE id=234;" + "UPDATE pl SET result=1 WHERE id=235;";
}
}
sql = sql + "UPDATE pl SET result=0 WHERE id>235 and id<244;";
}
else if (MyFunc.GetRGB(int.Parse(tztype[6])) == "green")
{
if (int.Parse(tztype[6]) != 0x31)
{
if ((int.Parse(tztype[6]) % 2) == 0)
{
sql = sql + "UPDATE pl SET result=0 WHERE id=236;" + "UPDATE pl SET result=1 WHERE id=237;";
}
else
{
sql = sql + "UPDATE pl SET result=0 WHERE id=237;" + "UPDATE pl SET result=1 WHERE id=236;";
}
}
if (int.Parse(tztype[6]) != 0x31)
{
if (int.Parse(tztype[6]) >= 0x19)
{
sql = sql + "UPDATE pl SET result=0 WHERE id=239;" + "UPDATE pl SET result=1 WHERE id=238;";
}
else
{
sql = sql + "UPDATE pl SET result=0 WHERE id=238;" + "UPDATE pl SET result=1 WHERE id=239;";
}
}
sql = sql + "UPDATE pl SET result=0 WHERE (id>231 and id<236) or (id>239 and id<244);";
}
else
{
if (int.Parse(tztype[6]) != 0x31)
{
if ((int.Parse(tztype[6]) % 2) == 0)
{
sql = sql + "UPDATE pl SET result=0 WHERE id=240;" + "UPDATE pl SET result=1 WHERE id=241;";
}
else
{
sql = sql + "UPDATE pl SET result=0 WHERE id=241;" + "UPDATE pl SET result=1 WHERE id=240;";
}
}
if (int.Parse(tztype[6]) != 0x31)
{
if (int.Parse(tztype[6]) >= 0x19)
{
sql = sql + "UPDATE pl SET result=0 WHERE id=243;" + "UPDATE pl SET result=1 WHERE id=242;";
}
else
{
sql = sql + "UPDATE pl SET result=0 WHERE id=242;" + "UPDATE pl SET result=1 WHERE id=243;";
}
}
sql = sql + "UPDATE pl SET result=0 WHERE (id>231 and id<240);";
}
if (int.Parse(tztype[6]) == 0x31)
{
sql = sql + "UPDATE pl SET result=20 WHERE (id>231 and id<244);";
}
sql = sql + "UPDATE pl SET result='" + MyFunc.GettwelveId(tztype[6]) + "' WHERE id=230;";
base2.ExecuteNonQuery(sql);
base2.Dispose();
}
private void FootBallList()
{
int num2;
int start;
int pagesize = 10;
try
{
num2 = int.Parse(base.Request.Form["page"].ToString());
}
catch
{
num2 = 1;
}
if (num2 < 1)
{
num2 = 1;
}
DataBase base2 = new DataBase(MyFunc.GetConnStr(2));
int num4 = int.Parse(base2.ExecuteScalar("SELECT COUNT(1) FROM Ball_bf1 ").ToString());
if (num4 > 120)
{
pagesize = (num4 / 2) + 1;
}
if (num4 == 0)
{
start = 0;
}
else
{
start = (num2 - 1) * pagesize;
}
int num3 = num4 / pagesize;
if ((num4 % pagesize) > 0)
{
num3++;
}
for (int i = 1; i <= num3; i++)
{
if (num2 == i)
{
object pageorder = this.pageorder;
this.pageorder = string.Concat(new object[] { pageorder, "<option value=", i, " selected >", i, "</option>" });
}
else
{
object obj3 = this.pageorder;
this.pageorder = string.Concat(new object[] { obj3, "<option value=", i, " >", i, "</option>" });
}
}
object obj4 = this.pageorder;
this.pageorder = string.Concat(new object[] { obj4, "/ ", num3, " 页" });
string sql = "SELECT * FROM Ball_bf1 where tema<>'' order by balltime desc";
DataSet set = base2.ExecuteDataSet(sql, start, pagesize, "ball_pl1");
int num7 = 0;
num7 = start;
for (int j = 0; j < set.Tables[0].Rows.Count; j++)
{
this.kyglcontent = this.kyglcontent + " <TR class=list_cen><TD align=\"center\">" + set.Tables[0].Rows[j]["qishu"].ToString().Trim() + "</TD>";
this.kyglcontent = this.kyglcontent + "<TD nowrap bgcolor=\"#C8D1D6\" align=center>" + set.Tables[0].Rows[j]["balltime"].ToString().Split(new char[] { ' ' })[0] + "</TD>";
string kyglcontent = this.kyglcontent;
this.kyglcontent = kyglcontent + "<TD width=50 align=middle bgcolor=\"C1D7E5\" class=\"ball_td\" align=\"center\" background=" + MyFunc.GetRGB(set.Tables[0].Rows[j]["num1"].ToString()) + " height=\"27\"><font style=\"filter: glow(color=#000000,strength=1); height:10px; color:#000000; padding:2px\">" + set.Tables[0].Rows[j]["num1"].ToString() + "</font></TD>";
string text9 = this.kyglcontent;
this.kyglcontent = text9 + "<TD width=50 align=middle bgcolor=\"C1D7E5\" class=\"ball_td\" align=\"center\" background=" + MyFunc.GetRGB(set.Tables[0].Rows[j]["num2"].ToString()) + " height=\"27\"><font style=\"filter: glow(color=#000000,strength=1); height:10px; color:#000000; padding:2px\">" + set.Tables[0].Rows[j]["num2"].ToString() + "</font></TD>";
string text10 = this.kyglcontent;
this.kyglcontent = text10 + "<TD width=50 align=middle bgcolor=\"C1D7E5\" class=\"ball_td\" align=\"center\" background=" + MyFunc.GetRGB(set.Tables[0].Rows[j]["num3"].ToString()) + " height=\"27\"><font style=\"filter: glow(color=#000000,strength=1); height:10px; color:#000000; padding:2px\">" + set.Tables[0].Rows[j]["num3"].ToString() + "</font></TD>";
string text11 = this.kyglcontent;
this.kyglcontent = text11 + "<TD width=50 align=middle bgcolor=\"C1D7E5\" class=\"ball_td\" align=\"center\" background=" + MyFunc.GetRGB(set.Tables[0].Rows[j]["num4"].ToString()) + " height=\"27\"><font style=\"filter: glow(color=#000000,strength=1); height:10px; color:#000000; padding:2px\">" + set.Tables[0].Rows[j]["num4"].ToString() + "</font></TD>";
string text12 = this.kyglcontent;
this.kyglcontent = text12 + "<TD width=50 align=middle bgcolor=\"C1D7E5\" class=\"ball_td\" align=\"center\" background=" + MyFunc.GetRGB(set.Tables[0].Rows[j]["num5"].ToString()) + " height=\"27\"><font style=\"filter: glow(color=#000000,strength=1); height:10px; color:#000000; padding:2px\">" + set.Tables[0].Rows[j]["num5"].ToString() + "</font></TD>";
string text13 = this.kyglcontent;
this.kyglcontent = text13 + "<TD width=50 align=middle bgcolor=\"C1D7E5\" class=\"ball_td\" align=\"center\" background=" + MyFunc.GetRGB(set.Tables[0].Rows[j]["num6"].ToString()) + " height=\"27\"><font style=\"filter: glow(color=#000000,strength=1); height:10px; color:#000000; padding:2px\">" + set.Tables[0].Rows[j]["num6"].ToString() + "</font></TD>";
string text14 = this.kyglcontent;
this.kyglcontent = text14 + "<TD width=50 align=middle bgcolor=\"C1D7E5\" class=\"ball_td\" align=\"center\" background=" + MyFunc.GetRGB(set.Tables[0].Rows[j]["tema"].ToString()) + " height=\"27\"><font style=\"filter: glow(color=#000000,strength=1); height:10px; color:#000000; padding:2px\">" + set.Tables[0].Rows[j]["tema"].ToString() + "</font></TD>";
num7 = (((((int.Parse(set.Tables[0].Rows[j]["num1"].ToString()) + int.Parse(set.Tables[0].Rows[j]["num2"].ToString())) + int.Parse(set.Tables[0].Rows[j]["num3"].ToString())) + int.Parse(set.Tables[0].Rows[j]["num4"].ToString())) + int.Parse(set.Tables[0].Rows[j]["num5"].ToString())) + int.Parse(set.Tables[0].Rows[j]["num6"].ToString())) + int.Parse(set.Tables[0].Rows[j]["tema"].ToString());
object obj5 = this.kyglcontent;
this.kyglcontent = string.Concat(new object[] { obj5, "<TD width=50 align=middle bgcolor=\"C1D7E5\" height=\"27\"><strong>", num7, "</strong></TR>" });
}
set.Dispose();
base2.Dispose();
}