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