private string SumAllMember()
{
string sql = "";
string text2 = "";
int num = 0;
string connStr = "";
connStr = MyFunc.GetConnStr(2);
connStr = connStr.Substring(connStr.IndexOf("catalog=", 0) + 8, (connStr.IndexOf(";user", 0) - connStr.IndexOf("catalog=", 0)) - 8);
if ((this.Session.Contents["football_bdgg.aspx"] != null) && (this.Session.Contents["football_bdgg.aspx"].ToString().Trim() != ""))
{
sql = "select * from ball_pl4view where matchname in (" + MyFunc.FormatMyStr(this.Session.Contents["football_bdgg.aspx"].ToString().Trim()) + ")";
}
else
{
sql = "select * from ball_pl4view where 1 = 1 ";
}
if ((this.Session.Contents["sessionSelectZD"] != null) && (this.Session.Contents["sessionSelectZD"].ToString().Trim() == "有单"))
{
string text5 = sql;
sql = text5 + " and (select count(*) from " + connStr + "..ball_order where datediff(day,updatetime,getdate()) = 0 and charindex(ball_pl4view.team1,content)>0 and charindex(ball_pl4view.team2,content)>0 and charindex(ball_pl4view.matchname,content)>0 and tztype = 16 and dlsid='" + this.Session["adminuserid"].ToString() + "') > 0";
}
DataBase base2 = new DataBase(MyFunc.GetConnStr(2));
SqlDataReader reader = base2.ExecuteReader(sql);
while (reader.Read())
{
num++;
string text6 = ((text2 + "<tr class='TableBody1'>") + "<td nowrap align=center>" + reader["balltime"].ToString() + "</td>") + "<td align=center>" + reader["matchname"].ToString() + "</td>\n<td><table cellSpacing='0' cellPadding=\"0\" width=\"100%\" border=\"0\"><tr><td>";
string text7 = text6 + reader["team1"].ToString() + "</td></tr><tr><td>" + reader["team2"].ToString() + "</td></tr></table></td>\n";
text2 = text7 + "<td align=center><a href='tzinfo.aspx?gameid=" + reader["ballid"].ToString().Trim() + "&tztype=16&marker=none'>" + MyFunc.SumStatic(reader["ballid"].ToString().Trim(), "16", "none") + "</a></td></tr>";
}
if (num == 0)
{
text2 = text2 + "<tr class='TableBody1'><td colspan=4 align=center height=30><marquee align=middle behavior=alternate width=200><font color=red size=2><b>没有相关注单</b></font></marquee></td></tr>";
}
reader.Close();
base2.CloseConnect();
base2.Dispose();
return(text2 + "\n</table></form></body></html>");
}
private string SumAllMember()
{
string sql = "";
string text2 = "";
int num = 0;
string connStr = "";
connStr = MyFunc.GetConnStr(2);
connStr = connStr.Substring(connStr.IndexOf("catalog=", 0) + 8, (connStr.IndexOf(";user", 0) - connStr.IndexOf("catalog=", 0)) - 8);
if ((this.Session.Contents["basketball_ys.aspx"] != null) && (this.Session.Contents["basketball_ys.aspx"].ToString().Trim() != ""))
{
sql = "select ballid,balltime,matchname,bigsmall1,bigpl,smallpl,bigsmall2,team1,team2,isautoshow,sortdatetime,xenial,giveup,giveup1,giveup2,bsingle,btwin from bk_ball_plYSview where matchname in (" + MyFunc.FormatMyStr(this.Session.Contents["basketball_ys.aspx"].ToString().Trim()) + ")";
}
else
{
sql = "select ballid,balltime,matchname,bigsmall1,bigpl,smallpl,bigsmall2,team1,team2,isautoshow,sortdatetime,xenial,giveup,giveup1,giveup2,bsingle,btwin from bk_ball_plYSview where 1 = 1";
}
if ((this.Session.Contents["sessionSelectZD"] != null) && (this.Session.Contents["sessionSelectZD"].ToString().Trim() == "有单"))
{
sql = sql + " and (select count(*) from " + connStr + "..ball_order where ballid = bk_ball_plYSview.ballid) > 0";
}
DataBase base2 = new DataBase(MyFunc.GetConnStr(2));
SqlDataReader reader = base2.ExecuteReader(sql);
while (reader.Read())
{
num++;
text2 = (((((text2 + "<tr class='TableBody1'>") + "<td nowrap align = center>" + reader["balltime"].ToString()) + "</td>") + "<td align = center>" + reader["matchname"].ToString() + "</td>\n<td><table cellSpacing='0' cellPadding=\"0\" width=\"100%\" border=\"0\"><tr><td>") + reader["team1"].ToString() + "</td><td> </td></tr><tr><td>" + reader["team2"].ToString()) + "</td><td align=right><font color='#009900'></font></td></tr></table>\n" + "<td><table cellSpacing='0' cellPadding=\"0\" width=\"100%\" border=\"0\"><tr><td width=\"33%\">\n";
if (reader["matchname"].ToString().IndexOf("上半") > -1)
{
if (reader["xenial"].ToString().ToUpper() == "H")
{
text2 = text2 + reader["giveup"].ToString().Trim() + " </td>";
}
else
{
text2 = text2 + " </td>";
}
if (reader["giveup1"].ToString().Trim() != "")
{
text2 = text2 + "<td width=\"33%\" align=center>" + ((Convert.ToDouble(reader["giveup1"]) - this.abcadd)).ToString("F3") + "</td>";
}
else
{
text2 = text2 + "<td width=\"33%\" align=center> </td>";
}
string text5 = text2;
text2 = text5 + "<td width='33%' align=right><a href='tzinfo.aspx?gameid=" + reader["ballid"].ToString().Trim() + "&tztype=22&marker=H'>" + this.SumStatic(reader["ballid"].ToString().Trim(), "22", "H") + "</a></td></tr><tr><td>";
if (reader["xenial"].ToString().ToUpper() == "C")
{
text2 = text2 + reader["giveup"].ToString().Trim() + " </td>";
}
else
{
text2 = text2 + " </td>";
}
if (reader["giveup2"].ToString().Trim() != "")
{
text2 = text2 + "<td width=\"33%\" align=center>" + ((Convert.ToDouble(reader["giveup2"]) - this.abcadd)).ToString("F3") + "</td>";
}
else
{
text2 = text2 + "<td width=\"33%\" align=center> </td>";
}
string text6 = text2;
text2 = (text6 + "<td width='33%' align=right><a href='tzinfo.aspx?gameid=" + reader["ballid"].ToString().Trim() + "&tztype=22&marker=C'>" + this.SumStatic(reader["ballid"].ToString().Trim(), "22", "C") + "</a></td></tr><tr></table></td>\n") + "<td><table cellSpacing=0 cellPadding=0 width='100%' border=0><tr><td width='33%'>";
if (reader["bigsmall1"].ToString().Trim().IndexOf("大") > -1)
{
text2 = text2 + reader["bigsmall1"].ToString().Trim().Replace("大", "") + " </td><td width='33%' align=center>";
}
else
{
text2 = text2 + " </td><td width='33%' align=center>";
}
if (reader["bigpl"].ToString() != "")
{
text2 = text2 + ((Convert.ToDouble(reader["bigpl"]) - this.abcadd)).ToString("F3") + "</td><td width=33% align=right>";
}
else
{
text2 = text2 + " </td><td width=33% align=right>";
}
string text7 = text2;
text2 = text7 + "<a href='tzinfo.aspx?gameid=" + reader["ballid"].ToString() + "&tztype=23&marker=H'>" + this.SumStatic(reader["ballid"].ToString().Trim(), "23", "H") + "</a></td></tr><tr><td width=33%>";
if (reader["bigsmall2"].ToString().Trim().IndexOf("大") > -1)
{
text2 = text2 + reader["bigsmall2"].ToString().Trim().Replace("大", "") + " </td><td width=33% align=center>";
}
else
{
text2 = text2 + " </td><td width=33% align=center>";
}
if (reader["smallpl"].ToString() != "")
{
text2 = text2 + ((Convert.ToDouble(reader["smallpl"]) - this.abcadd)).ToString("F3") + "</td><td width=33% align=right>";
}
else
{
text2 = text2 + " </td><td width=33% align=right>";
}
string text8 = text2;
text2 = (text8 + "<a href='tzinfo.aspx?gameid=" + reader["ballid"].ToString() + "&tztype=23&marker=C'>" + this.SumStatic(reader["ballid"].ToString().Trim(), "23", "C") + "</a></td></tr></table></td>") + "<td><table cellSpacing=0 cellPadding=0 width='100%' border=0><tr><td width='33%'>";
if (reader["bsingle"].ToString() != "")
{
text2 = text2 + ((Convert.ToDouble(reader["bsingle"].ToString().Replace("单", "")) - this.abcadd)).ToString("F3") + "</td><td width=33% align=right>";
}
else
{
text2 = text2 + " </td><td width=33% align=right>";
}
string text9 = text2;
text2 = text9 + "<a href='tzinfo.aspx?gameid=" + reader["ballid"].ToString() + "&tztype=24&marker=1'>" + this.SumStatic(reader["ballid"].ToString().Trim(), "24", "1") + "</a></td></tr><tr><td width=33%>";
if (reader["btwin"].ToString() != "")
{
text2 = text2 + ((Convert.ToDouble(reader["btwin"].ToString().Replace("双", "")) - this.abcadd)).ToString("F3") + "</td><td width=33% align=right>";
}
else
{
text2 = text2 + " </td><td width=33% align=right>";
}
string text10 = text2;
text2 = text10 + "<a href='tzinfo.aspx?gameid=" + reader["ballid"].ToString() + "&tztype=24&marker=2'>" + this.SumStatic(reader["ballid"].ToString().Trim(), "24", "2") + "</a></td></tr></table></td>";
}
else
{
if (reader["xenial"].ToString().ToUpper() == "H")
{
text2 = text2 + reader["giveup"].ToString().Trim() + " </td>";
}
else
{
text2 = text2 + " </td>";
}
if (reader["giveup1"].ToString().Trim() != "")
{
text2 = text2 + "<td width=\"33%\" align=center>" + ((Convert.ToDouble(reader["giveup1"]) - this.abcadd)).ToString("F3") + "</td>";
}
else
{
text2 = text2 + "<td width=\"33%\" align=center> </td>";
}
string text11 = text2;
text2 = text11 + "<td width='33%' align=right><a href='tzinfo.aspx?gameid=" + reader["ballid"].ToString().Trim() + "&tztype=18&marker=H'>" + this.SumStatic(reader["ballid"].ToString().Trim(), "18", "H") + "</a></td></tr><tr><td>";
if (reader["xenial"].ToString().ToUpper() == "C")
{
text2 = text2 + reader["giveup"].ToString().Trim() + " </td>";
}
else
{
text2 = text2 + " </td>";
}
if (reader["giveup2"].ToString().Trim() != "")
{
text2 = text2 + "<td width=\"33%\" align=center>" + ((Convert.ToDouble(reader["giveup2"]) - this.abcadd)).ToString("F3") + "</td>";
}
else
{
text2 = text2 + "<td width=\"33%\" align=center> </td>";
}
string text12 = text2;
text2 = (text12 + "<td width='33%' align=right><a href='tzinfo.aspx?gameid=" + reader["ballid"].ToString().Trim() + "&tztype=18&marker=C'>" + this.SumStatic(reader["ballid"].ToString().Trim(), "18", "C") + "</a></td></tr><tr></table></td>\n") + "<td><table cellSpacing=0 cellPadding=0 width='100%' border=0><tr><td width='33%'>";
if (reader["bigsmall1"].ToString().Trim().IndexOf("大") > -1)
{
text2 = text2 + reader["bigsmall1"].ToString().Trim().Replace("大", "") + " </td><td width='33%' align=center>";
}
else
{
text2 = text2 + " </td><td width='33%' align=center>";
}
if (reader["bigpl"].ToString() != "")
{
text2 = text2 + ((Convert.ToDouble(reader["bigpl"]) - this.abcadd)).ToString("F3") + "</td><td width=33% align=right>";
}
else
{
text2 = text2 + " </td><td width=33% align=right>";
}
string text13 = text2;
text2 = text13 + "<a href='tzinfo.aspx?gameid=" + reader["ballid"].ToString() + "&tztype=19&marker=H'>" + this.SumStatic(reader["ballid"].ToString().Trim(), "19", "H") + "</a></td></tr><tr><td width=33%>";
if (reader["bigsmall2"].ToString().Trim().IndexOf("大") > -1)
{
text2 = text2 + reader["bigsmall2"].ToString().Trim().Replace("大", "") + " </td><td width=33% align=center>";
}
else
{
text2 = text2 + " </td><td width=33% align=center>";
}
if (reader["smallpl"].ToString() != "")
{
text2 = text2 + ((Convert.ToDouble(reader["smallpl"]) - this.abcadd)).ToString("F3") + "</td><td width=33% align=right>";
}
else
{
text2 = text2 + " </td><td width=33% align=right>";
}
string text14 = text2;
text2 = (text14 + "<a href='tzinfo.aspx?gameid=" + reader["ballid"].ToString() + "&tztype=19&marker=C'>" + this.SumStatic(reader["ballid"].ToString().Trim(), "19", "C") + "</a></td></tr></table></td>") + "<td><table cellSpacing=0 cellPadding=0 width='100%' border=0><tr><td width='33%'>";
if (reader["bsingle"].ToString() != "")
{
text2 = text2 + ((Convert.ToDouble(reader["bsingle"].ToString().Replace("单", "")) - this.abcadd)).ToString("F3") + "</td><td width=33% align=right>";
}
else
{
text2 = text2 + " </td><td width=33% align=right>";
}
string text15 = text2;
text2 = text15 + "<a href='tzinfo.aspx?gameid=" + reader["ballid"].ToString() + "&tztype=20&marker=1'>" + this.SumStatic(reader["ballid"].ToString().Trim(), "20", "1") + "</a></td></tr><tr><td width=33%>";
if (reader["btwin"].ToString() != "")
{
text2 = text2 + ((Convert.ToDouble(reader["btwin"].ToString().Replace("双", "")) - this.abcadd)).ToString("F3") + "</td><td width=33% align=right>";
}
else
{
text2 = text2 + " </td><td width=33% align=right>";
}
string text16 = text2;
text2 = text16 + "<a href='tzinfo.aspx?gameid=" + reader["ballid"].ToString() + "&tztype=20&marker=2'>" + this.SumStatic(reader["ballid"].ToString().Trim(), "20", "2") + "</a></td></tr></table></td>";
}
text2 = text2 + "</tr>";
}
if (num == 0)
{
text2 = text2 + "<tr class='TableBody1'><td colspan=16 align=center height=30><marquee align=middle behavior=alternate width=200><font color=red size=2><b>没有相关注单</b></font></marquee></td></tr>";
}
reader.Close();
base2.CloseConnect();
base2.Dispose();
return(text2 + "\n</table></form></body></html>");
}
