private void DlsUseMoney(DataBase db) { int num = int.Parse(db.ExecuteScalar("SELECT ISNULL(usemoney,0) FROM agence WHERE userid=" + this.TextBoxDlsid.Text.Trim()).ToString()); int num2 = int.Parse(db.ExecuteScalar("SELECT ISNULL(sum(usemoney),0) FROM member WHERE dlsid=" + this.TextBoxDlsid.Text.Trim()).ToString()); int num3 = num - num2; this.LabelUseMoney.Text = MyFunc.NumBerFormat(num3.ToString(), true) + " / " + MyFunc.NumBerFormat(num.ToString(), true); }
private void DlsUseMoney(DataBase db) { if ((this.DropDownListDls.SelectedValue != null) && (this.DropDownListDls.SelectedValue != "")) { int num = int.Parse(db.ExecuteScalar("SELECT ISNULL(usemoney,0) FROM agence WHERE userid=" + this.DropDownListDls.SelectedValue).ToString()); int num2 = int.Parse(db.ExecuteScalar("SELECT ISNULL(sum(usemoney),0) FROM member WHERE dlsid=" + this.DropDownListDls.SelectedValue).ToString()); int num3 = num - num2; this.LabelUseMoney.Text = MyFunc.NumBerFormat(num3.ToString(), true) + " / " + MyFunc.NumBerFormat(num.ToString(), true); } }
private void ShowMonthContent() { string text = ""; string sql = ""; int num = 0; double num2 = 0; double num3 = 0; double num4 = 0; double num5 = 0; text = "<table border=0 cellspacing=1 cellpadding=0 class=tableNoBorder1 width=100%>\n"; text = text + "<tr class=dlsheader><td width=15%>日期</td><td width=5% nowrap>投注数</td><td width=20%>投注额</td><td width=20%>结果</td><td width=20%>代理商</td><td width=20%>总代理</td></tr>\n"; DataBase base2 = new DataBase(MyFunc.GetConnStr(2)); SqlDataReader reader = null; for (int i = 0; i < 30; i++) { sql = "SELECT isnull(sum(mdls),0) as dlsmoney,isnull(sum(mzdl),0) as zdlmoney,count(*) as tzcount,isnull(sum(tzmoney),0) as tzmoney,isnull(sum(win-lose),0) as result FROM ball_order WHERE dlsid = '" + this.userId + "' AND datediff(day,updatetime,'" + DateTime.Today.AddDays((double)-i).ToShortDateString() + "') = 0"; reader = base2.ExecuteReader(sql); while (reader.Read()) { text = text + "<tr bgcolor=white align=right height=22>"; if (reader["tzcount"].ToString() != "0") { string text3 = text; text = (((((text3 + "<td align=center nowrap><a href='dlslist_reportcontent.aspx?userid=" + this.userId + "&username="******"&updatetime=" + DateTime.Today.AddDays((double)-i).ToString("yyyy-MM-dd") + "'><font color=blue>" + DateTime.Today.AddDays((double)-i).ToString("yyyy-MM-dd") + "-" + MyFunc.DayToWeek(DateTime.Today.AddDays((double)-i)) + "<font></a></td>") + "<td align=center>" + reader["tzcount"].ToString() + "</td>") + "<td>" + Convert.ToDouble(reader["tzmoney"]).ToString() + "</td>") + "<td>" + MyFunc.NumBerFormat(reader["result"].ToString()) + "</td>") + "<td>" + MyFunc.NumBerFormat(reader["dlsmoney"].ToString()) + "</td>") + "<td>" + MyFunc.NumBerFormat(reader["zdlmoney"].ToString()) + "</td>"; num += int.Parse(reader["tzcount"].ToString()); num2 += double.Parse(reader["tzmoney"].ToString()); num3 += double.Parse(reader["dlsmoney"].ToString()); num4 += double.Parse(reader["zdlmoney"].ToString()); num5 += double.Parse(reader["result"].ToString()); } else { string text4 = text; text = (((((text4 + "<td align=center nowrap>" + DateTime.Today.AddDays((double)-i).ToString("yyyy-MM-dd") + "-" + MyFunc.DayToWeek(DateTime.Today.AddDays((double)-i)) + "</a></td>") + "<td align=center>" + reader["tzcount"].ToString() + "</td>") + "<td>" + Convert.ToDouble(reader["tzmoney"]).ToString() + "</td>") + "<td>" + MyFunc.NumBerFormat(reader["result"].ToString()) + "</td>") + "<td>" + MyFunc.NumBerFormat(reader["dlsmoney"].ToString()) + "</td>") + "<td>" + MyFunc.NumBerFormat(reader["zdlmoney"].ToString()) + "</td>"; } text = text + "</tr>\n"; } reader.Close(); } text = ((((((text + "<tr class=reportTotalnum align=right height=22><td class=reportTotalchar>总 数</td>") + "<td align=center>" + num.ToString() + "</td>") + "<td>" + num2.ToString() + "</td>") + "<td>" + MyFunc.NumBerFormat(num5.ToString()) + "</td>") + "<td>" + MyFunc.NumBerFormat(num3.ToString()) + "</td>") + "<td>" + MyFunc.NumBerFormat(num4.ToString()) + "</td>") + "</tr></table>\n"; this.tableHeader.Rows[3].Cells[0].InnerHtml = text; }
private void setShowContent() { int curpage; int start; string sql = this.GetSqlStr(); string sumSqlStr = this.GetSumSqlStr(); string tzTypeName = MyFunc.GettzTypeName(this.tzType.Value); int num = 0; double num2 = 0; double num3 = 0; double num4 = 0; StringBuilder builder = new StringBuilder(); DataBase base2 = new DataBase(MyFunc.GetConnStr(2)); int pagesize = 100; try { curpage = int.Parse(this.thePages.SelectedValue); } catch { curpage = 1; } if (curpage < 1) { curpage = 1; } builder.Append("<table border=0 cellspacing=1 cellpadding=0 width=100% class=tableBorder1>\n"); builder.Append("<tr class='dlsheader'><td width=10%>时间</td><td width=15%>会员(win/lose)</td><td width=10%>方式</td><td width=25%>详情</td><td width=10%>注额</td><td width=10%>成数</td><td width=10%>注额(成数)</td><td width=10%>结果</td></tr>\n"); int totalrecord = int.Parse(base2.ExecuteScalar(sumSqlStr).ToString()); if (totalrecord == 0) { start = 0; } else { start = (curpage - 1) * pagesize; } DataSet set = base2.ExecuteDataSet(sql, start, pagesize, "ball_order2"); int num9 = 0; for (int i = 1; num9 < set.Tables[0].Rows.Count; i++) { builder.Append("<tr bgcolor=#ffffff align=right>"); builder.Append("<td align=center>"); builder.Append(DateTime.Parse(set.Tables[0].Rows[num9]["updatetime"].ToString().Trim()).ToString("yyyy-MM-dd HH:mm:ss").ToUpper().Replace(" ", "<br>")); builder.Append("</td><td align=center nowrap><table border=0 cellpadding=1 cellspacing=0 width=100%><tr><td><font color=red>"); builder.Append(set.Tables[0].Rows[num9]["abc"].ToString()); builder.Append("</font> "); builder.Append(set.Tables[0].Rows[num9]["username"].ToString()); builder.Append(" </td><td nowrap><font color=red>"); builder.Append(Convert.ToDouble(set.Tables[0].Rows[num9]["hsuser_w"]).ToString("F2")); builder.Append("</font>/<font color=red>"); builder.Append(Convert.ToDouble(set.Tables[0].Rows[num9]["hsuser_l"]).ToString("F2")); builder.Append("</font></td></tr></table></td>"); builder.Append("<td align=center><font color=blue>"); builder.Append(tzTypeName); builder.Append("</td><td>"); builder.Append(set.Tables[0].Rows[num9]["content"].ToString()); builder.Append("</td><td>"); builder.Append(MyFunc.NumBerFormat(set.Tables[0].Rows[num9]["tzmoney"].ToString())); builder.Append("</td><td>"); builder.Append(Convert.ToDouble(set.Tables[0].Rows[num9]["cszdl"]).ToString("F1")); builder.Append("</td><td>"); builder.Append(MyFunc.NumBerFormat(set.Tables[0].Rows[num9]["csres"].ToString())); builder.Append("</td><td>"); builder.Append(MyFunc.NumBerFormat(set.Tables[0].Rows[num9]["result"].ToString())); builder.Append("</td></tr>\n"); num++; num2 += double.Parse(set.Tables[0].Rows[num9]["tzmoney"].ToString()); num3 += double.Parse(set.Tables[0].Rows[num9]["csres"].ToString()); num4 += double.Parse(set.Tables[0].Rows[num9]["result"].ToString()); num9++; } if (set.Tables[0].Rows.Count == 0) { builder.Append("<tr bgcolor=#ffffff><td align=center colspan=9 height=30><marquee align=middle behavior=alternate width=200><font color=red size=2><b>没有资料</b></font></marquee></td></tr>\n"); } else { builder.Append("<tr bgcolor=#dfefff height=22 class=reportTotalnum><td colspan=4 align=right>"); builder.Append(num.ToString()); builder.Append("</td><td align=right>"); builder.Append(num2.ToString()); builder.Append("</td><td align=right> "); builder.Append("</td><td align=right>"); builder.Append(num3.ToString()); builder.Append("</td><td align=right >"); builder.Append(num4.ToString()); builder.Append("</td></tr>"); } builder.Append("</table>\n"); set.Clear(); base2.CloseConnect(); base2.Dispose(); this.showContent.Rows[0].Cells[0].InnerHtml = builder.ToString(); this.setselectpageproc(pagesize, totalrecord, curpage); }
private void Deal(string sql) { string text = ""; int num = 0; int num2 = 0; double num3 = 0; double num4 = 0; double num5 = 0; double num6 = 0; double num7 = 0; double num8 = 0; double num9 = 0; double num10 = 0; DataBase base2 = new DataBase(MyFunc.GetConnStr(2)); SqlDataReader reader = base2.ExecuteReader(sql); text = "<table border=0 cellspacing=1 cellpadding=0 class=tableNoBorder1 width=100%>\n"; text = text + "<tr class=dlsreport><td width=8%>总代理</td><td width=4%>笔数</td><td width=10%>会员投注金额</td><td width=10%>会员</td><td width=10%>代理商金额</td><td width=10%>代理商</td><td width=4%>成数</td><td width=10%>总代理金额</td><td width=10%>总代理</td><td width=4%>成数</td><td width=10%>股东金额</td><td width=10%>股东</td></tr>\n"; while (reader.Read()) { num++; string text2 = text + "<tr bgcolor=white align=right height=22>"; string text3 = (text2 + "<td align=center><a href='zdllist_reportlist.aspx?userid=" + reader["zdlid"].ToString() + "&username="******"zdlname"].ToString() + "'>" + reader["zdlname"].ToString() + "</a></td>") + "<td>" + reader["tzNumber"].ToString() + "</td>"; text = ((((((((((text3 + "<td><a href='reportshowdls.aspx?" + this.pathStr + "&zdlid=" + reader["zdlid"].ToString() + "'><font color=blue>" + MyFunc.NumBerFormat(reader["tzmoney"].ToString()) + "</font></a></td>") + "<td>" + MyFunc.NumBerFormat(reader["result"].ToString()) + "</td>") + "<td>" + MyFunc.NumBerFormat(reader["mdls"].ToString()) + "</td>") + "<td>" + MyFunc.NumBerFormat(reader["csmdls"].ToString()) + "</td>") + "<td>" + Convert.ToDouble(reader["csdls"]).ToString("F1") + "</td>") + "<td>" + MyFunc.NumBerFormat(reader["mzdl"].ToString()) + "</td>") + "<td>" + MyFunc.NumBerFormat(reader["csmzdl"].ToString()) + "</td>") + "<td>" + Convert.ToDouble(reader["cszdl"]).ToString("F1") + "</td>") + "<td>" + MyFunc.NumBerFormat(reader["mgd"].ToString()) + "</td>") + "<td>" + MyFunc.NumBerFormat(reader["csmgd"].ToString()) + "</td>") + "</tr>\n"; num2 += int.Parse(reader["tzNumber"].ToString()); num3 += double.Parse(reader["tzmoney"].ToString()); num4 += double.Parse(reader["result"].ToString()); num7 += double.Parse(reader["csmdls"].ToString()); num8 += double.Parse(reader["mdls"].ToString()); num5 += double.Parse(reader["csmzdl"].ToString()); num6 += double.Parse(reader["mzdl"].ToString()); num9 += double.Parse(reader["mgd"].ToString()); num10 += double.Parse(reader["csmgd"].ToString()); } reader.Close(); base2.Dispose(); text = ((((((((((((text + "<tr height=22 class=reportTotalnum><td class=reportTotalchar>总 数</td>") + "<td>" + num2.ToString() + "</td>") + "<td>" + MyFunc.NumBerFormat(num3.ToString()) + "</td>") + "<td>" + MyFunc.NumBerFormat(num4.ToString()) + "</td>") + "<td>" + MyFunc.NumBerFormat(num8.ToString()) + "</td>") + "<td>" + MyFunc.NumBerFormat(num7.ToString()) + "</td>") + "<td> </td>") + "<td>" + MyFunc.NumBerFormat(num6.ToString()) + "</td>") + "<td>" + MyFunc.NumBerFormat(num5.ToString()) + "</td>") + "<td> </td>") + "<td>" + MyFunc.NumBerFormat(num9.ToString()) + "</td>") + "<td>" + MyFunc.NumBerFormat(num10.ToString()) + "</td>") + "</tr></table>\n"; if (this.search.ToLower() == "credit") { this.tableHeader.Rows[1].Cells[0].InnerHtml = text; } else { this.tableMiddle.Rows[1].Cells[0].InnerHtml = text; } }
private void Deal(string sql, string sumSql) { int curpage; int start; string text = ""; int num = 0; double num2 = 0; double num3 = 0; double num4 = 0; DataBase base2 = new DataBase(MyFunc.GetConnStr(2)); text = "<table border=0 cellspacing=1 cellpadding=0 width=100% class=tableNoBorder1>\n"; text = text + "<tr class=dlsheader><td width=10%>时间</td><td width=15%>会员 (win/lose)</td><td width=10%>投注方式</td><td width=25%>详情</td><td width=10%>注额</td><td width=10%>成数</td><td width=10%>注额(成数)</td><td width=10%>结果</td></tr>\n"; int pagesize = 100; try { curpage = int.Parse(this.selectpage.Value); } catch { curpage = 1; } if (curpage < 1) { curpage = 1; } int totalrecord = int.Parse(base2.ExecuteScalar(sumSql).ToString()); if (totalrecord == 0) { start = 0; } else { if (((curpage - 1) * pagesize) >= totalrecord) { curpage = 1; } start = (curpage - 1) * pagesize; } DataSet set = base2.ExecuteDataSet(sql, start, pagesize, "ball_order"); for (int i = 0; i < set.Tables[0].Rows.Count; i++) { num++; string text2 = (((text + "<tr bgcolor=white align=right height=22>") + "<td align=center>" + DateTime.Parse(set.Tables[0].Rows[i]["updatetime"].ToString().Trim()).ToString("yyyy-MM-dd HH:mm:ss").ToUpper().Replace(" ", "<br>") + "</td>") + "<td align=center nowrap><table border=0 cellspacing=0 cellpadding=0><tr><td><font color=red>" + set.Tables[0].Rows[i]["abc"].ToString() + "</font> </td>") + "<td align=center nowrap> " + set.Tables[0].Rows[i]["username"].ToString() + " </td>"; text = (((((text2 + "<td nowrap> <font color=red>" + set.Tables[0].Rows[i]["hsuser_w"].ToString() + "</font>/<font color=red>" + set.Tables[0].Rows[i]["hsuser_l"].ToString() + "</font></td></tr></table></td>") + "<td align=center>" + set.Tables[0].Rows[i]["tzTypeName"].ToString() + "</td>") + "<td>" + set.Tables[0].Rows[i]["content"].ToString() + "</td>") + "<td>" + Convert.ToDouble(set.Tables[0].Rows[i]["tzmoney"]).ToString() + "</td>") + "<td>" + Convert.ToDouble(set.Tables[0].Rows[i]["cszdl"]).ToString("F1") + "</td>") + "<td>" + MyFunc.NumBerFormat(set.Tables[0].Rows[i]["csres"].ToString()) + "</td>"; if (set.Tables[0].Rows[i]["iscancel"].ToString().ToLower() == "true") { if (set.Tables[0].Rows[i]["isdanger"].ToString().ToLower() == "2") { text = text + "<td><font color='red'>危险球取消</font></td>"; } else { text = text + "<td><font color='red'>取消</font></td>"; } } else { text = text + "<td>" + MyFunc.NumBerFormat(set.Tables[0].Rows[i]["result"].ToString()) + "</td>"; } text = text + "</tr>\n"; num2 += double.Parse(set.Tables[0].Rows[i]["tzmoney"].ToString()); num3 += double.Parse(set.Tables[0].Rows[i]["csres"].ToString()); num4 += double.Parse(set.Tables[0].Rows[i]["result"].ToString()); } set.Clear(); base2.Dispose(); this.setselectpageproc(pagesize, totalrecord, curpage); text = ((((((text + "<tr align=right height=22 class=reportTotalnum><td colspan=3> </td>") + "<td>" + num.ToString() + "</td>") + "<td>" + num2.ToString() + "</td>") + "<td colspan=3>" + MyFunc.NumBerFormat(num4.ToString()) + "</td></tr>") + "</table>\n" + "<table border=0 cellspacing=0 cellpadding=0 width=100% bgcolor=#eeeeee>\n") + "<tr><td width=100% height=12></td></tr>\n</table>\n" + "<table border=0 cellspacing=1 cellpadding=0 class=tableNoBorder1 width=100%>\n") + "<tr class=dlsreport1><td width=30%>总代理</td><td width=10%>笔数</td><td width=18%>投注额</td><td width=18%>注额(成数)</td><td width=18%>结果</td></tr>\n" + "<tr class=reportTotalnum align=right height=22>"; if ((this.Session.Contents["adminsubid"] != null) && (this.Session.Contents["adminsubid"].ToString() != "")) { text = text + "<td>" + this.Session.Contents["adminsubname"].ToString() + "</td>"; } else { text = text + "<td>" + this.Session.Contents["adminusername"].ToString() + "</td>"; } text = (((text + "<td>" + num.ToString() + "</td>") + "<td>" + num2.ToString() + "</td>") + "<td>" + num3.ToString() + "</td>") + "<td>" + MyFunc.NumBerFormat(num4.ToString()) + "</td></tr></table>"; this.tableCredit.Rows[0].Cells[0].InnerHtml = text; }
private void ShowBallOrderContent() { int curpage; int start; string text = ""; string sql = ""; string text3 = ""; int num = 0; double num2 = 0; double num3 = 0; double num4 = 0; sql = "SELECT cszdl,tzmoney*cszdl as csres,convert(numeric(5,2),hsuser_w) as hsuser_w,convert(numeric(5,2),hsuser_l) as hsuser_l,dbo.GettzType_Func(tzType) as tzTypeName,tzType,updatetime,username,content,tzmoney,isnull((win-lose),0) as result,abc,iscancel FROM ball_order where datediff(day,'" + this.upDateTime + "',updatetime) = 0 and userid='" + this.userId + "'"; text3 = "select count(*) from ball_order where datediff(day,'" + this.upDateTime + "',updatetime) = 0 and userid='" + this.userId + "'"; DataBase base2 = new DataBase(MyFunc.GetConnStr(2)); text = "<table border=0 cellspacing=1 cellpadding=0 class=tableNoBorder1 width=100%>\n"; text = text + "<tr class=dlsheader><td width=10%>时间</td><td width=15%>退水 (win/lose)</td><td width=10%>投注方式</td><td width=25%>详情</td><td width=10%>注额</td><td width=10%>成数</td><td width=10%>注额(成数)</td><td width=10%>结果</td></tr>\n"; int pagesize = 100; try { curpage = int.Parse(this.selectpage.Value); } catch { curpage = 1; } if (curpage < 1) { curpage = 1; } int totalrecord = int.Parse(base2.ExecuteScalar(text3).ToString()); if (totalrecord == 0) { start = 0; } else { if (((curpage - 1) * pagesize) >= totalrecord) { curpage = 1; } start = (curpage - 1) * pagesize; } DataSet set = base2.ExecuteDataSet(sql, start, pagesize, "ball_order"); for (int i = 0; i < set.Tables[0].Rows.Count; i++) { num++; string text4 = (((text + "<tr bgcolor=white align=right height=22>") + "<td align=center>" + DateTime.Parse(set.Tables[0].Rows[i]["updatetime"].ToString().Trim()).ToString("yyyy-MM-dd HH:mm:ss").ToUpper().Replace(" ", "<br>") + "</td>") + "<td align=center nowrap><table border=0 cellspacing=0 cellpadding=0><tr><td><font color=red>" + set.Tables[0].Rows[i]["abc"].ToString() + "</font> </td>") + "<td align=center nowrap> " + set.Tables[0].Rows[i]["username"].ToString() + " </td>"; text = (((((text4 + "<td nowrap> <font color=red>" + set.Tables[0].Rows[i]["hsuser_w"].ToString() + "</font>/<font color=red>" + set.Tables[0].Rows[i]["hsuser_l"].ToString() + "</font></td></tr></table></td>") + "<td align=center>" + set.Tables[0].Rows[i]["tzTypeName"].ToString() + "</td>") + "<td>" + set.Tables[0].Rows[i]["content"].ToString() + "</td>") + "<td>" + Convert.ToDouble(set.Tables[0].Rows[i]["tzmoney"]).ToString() + "</td>") + "<td>" + Convert.ToDouble(set.Tables[0].Rows[i]["cszdl"]).ToString("F1") + "</td>") + "<td>" + MyFunc.NumBerFormat(set.Tables[0].Rows[i]["csres"].ToString()) + "</td>"; if (set.Tables[0].Rows[i]["iscancel"].ToString().ToLower() == "true") { text = text + "<td><font color='red'>取消</font></td>"; } else { text = text + "<td>" + MyFunc.NumBerFormat(set.Tables[0].Rows[i]["result"].ToString()) + "</td>"; } text = text + "</tr>\n"; num2 += double.Parse(set.Tables[0].Rows[i]["tzmoney"].ToString()); num3 += double.Parse(set.Tables[0].Rows[i]["csres"].ToString()); num4 += double.Parse(set.Tables[0].Rows[i]["result"].ToString()); } set.Clear(); base2.Dispose(); this.setselectpageproc(pagesize, totalrecord, curpage); text = ((((((text + "<tr class=reportTotalnum align=right height=22><td colspan=3> </td>") + "<td>" + num.ToString() + "</td>") + "<td>" + num2.ToString() + "</td>") + "<td colspan=3>" + MyFunc.NumBerFormat(num4.ToString()) + "</td></tr>") + "</table>\n" + "<table border=0 cellspacing=0 cellpadding=0 width=100% bgcolor=white>\n") + "<tr><td width=100% height=12></td></tr>\n</table>\n" + "<table border=0 cellspacing=1 cellpadding=0 class=tableNoBorder1 width=100%>\n") + "<tr class=dlsreport1><td width=30%>总代理</td><td width=10%>笔数</td><td width=18%>投注额</td><td width=18%>注额(成数)</td><td width=18%>结果</td></tr>\n" + "<tr class=reportTotalnum align=right height=22>"; if ((this.Session.Contents["adminsubid"] != null) && (this.Session.Contents["adminsubid"].ToString() != "")) { text = text + "<td>" + this.Session.Contents["adminsubname"].ToString() + "</td>"; } else { text = text + "<td>" + this.Session.Contents["adminusername"].ToString() + "</td>"; } text = (((text + "<td>" + num.ToString() + "</td>") + "<td>" + num2.ToString() + "</td>") + "<td>" + num3.ToString() + "</td>") + "<td>" + MyFunc.NumBerFormat(num4.ToString()) + "</td></tr></table>"; this.tableContent.Rows[0].Cells[0].InnerHtml = text; }
private string GetOrderList(string start_date, string end_date, string t1, string t2, string isjs, string tztype, string ballid, string gdid, string zdlid, string dlsid, string userid, string username, string orderid, string matchname, string tzmoney, string rr, string iscancel, string iswin) { int curPage; int start; int pagesize = 100; try { curPage = int.Parse(base.Request.QueryString["page"].ToString()); } catch { curPage = 1; } if (curPage < 1) { curPage = 1; } string text = "SELECT orderid,userid,username,tzmoney,tztype,curpl,win,lose,truewin,hsuser_w,hsuser_l,content,updatetime,iscancel,balltime,isdanger,tzip,ds FROM Ball_order "; string text2 = "WHERE updatetime BETWEEN '" + start_date + " " + t1 + "' AND '" + end_date + " " + t2 + "' "; string text3 = ""; if (orderid != "") { text2 = text2 + " AND orderid=" + orderid; } if (tztype != "") { text2 = text2 + " AND tztype=" + tztype; } if (ballid != "") { text2 = text2 + " AND ballid in (" + ballid + ")"; } if (gdid != "") { text2 = text2 + " AND gdid=" + gdid; } if (zdlid != "") { text2 = text2 + " AND zdlid=" + zdlid; } if (dlsid != "") { text2 = text2 + " AND dlsid=" + dlsid; } if ((userid != "") && (username == "")) { text2 = text2 + " AND userid='" + userid + "'"; } if ((userid == "") && (username != "")) { text2 = text2 + " AND username='******'"; } if ((isjs != "") && (iscancel == "")) { text2 = text2 + " AND isjs=" + isjs; } if ((rr != "") && (rr == "0")) { text2 = text2 + " AND win-lose=0"; } if (tzmoney != "") { text2 = text2 + " AND tzmoney>=" + tzmoney; } if ((iscancel != "") && (iscancel != "0")) { text2 = text2 + " AND iscancel=" + iscancel; } if (iswin != "") { if (iswin == "w") { text2 = text2 + " AND win>0"; } if (iswin == "s") { text2 = text2 + " AND lose > 0"; } } DataBase base2 = new DataBase(MyFunc.GetConnStr(2)); int totalRecord = int.Parse(base2.ExecuteScalar("SELECT COUNT(1) FROM Ball_order " + text2).ToString()); if (totalRecord == 0) { start = 0; } else { start = (curPage - 1) * pagesize; } DataSet set = base2.ExecuteDataSet(text + text2 + " ORDER BY orderid DESC", start, pagesize, "ball_order"); double num5 = 0; double num6 = 0; int num7 = 0; string text4 = ""; for (int i = 0; i < set.Tables[0].Rows.Count; i++) { string text9 = text3; string text10 = text9 + "<tr bgcolor=#FFFFFF><td align=\"center\">" + set.Tables[0].Rows[i]["orderid"].ToString().Trim() + "</td><td align=\"center\">" + DateTime.Parse(set.Tables[0].Rows[i]["updatetime"].ToString().Trim()).ToString("yyyy-MM-dd HH:mm:ss").ToUpper().Replace(" ", "<br>"); text3 = text10 + "</td><td align=\"center\">" + set.Tables[0].Rows[i]["username"].ToString().Trim() + "</td><td align=\"center\">" + MyFunc.GettzTypeName(set.Tables[0].Rows[i]["tztype"].ToString().Trim()) + "</td><td align=\"right\">" + set.Tables[0].Rows[i]["content"].ToString().Trim() + "</td><td align=\"right\" valign=\"top\"> </td><td align=\"right\" valign=\"top\">" + MyFunc.NumBerFormat(set.Tables[0].Rows[i]["tzmoney"].ToString().Trim()) + "</td>"; string text5 = "#ffffff"; string text6 = " "; double num9 = double.Parse(set.Tables[0].Rows[i]["truewin"].ToString().Trim()); double num10 = double.Parse(set.Tables[0].Rows[i]["win"].ToString().Trim()); double num11 = double.Parse(set.Tables[0].Rows[i]["lose"].ToString().Trim()); string text7 = set.Tables[0].Rows[i]["ds"].ToString().Trim(); if ((num10 > 0) && (num9 == 1)) { text5 = "#FF9B9B"; text6 = "全赢"; } else if (num9 == 0.5) { text5 = "#A6D5EE"; text6 = "和局"; } else if ((num11 > 0) && (num9 == 1)) { text5 = "#FFFF99"; text6 = "全输"; } else if ((num10 > 0) && (num9 == 2)) { text5 = "#FF9B9B"; text6 = text7; } string text11 = text3; text3 = (text11 + "<td align=\"center\" valign=\"top\" style='background-color: " + text5 + ";'>" + text6) + "</td>" + "<td align=\"right\" valign=\"top\">"; if (set.Tables[0].Rows[i]["isdanger"].ToString().Trim().ToUpper() == "2") { text3 = text3 + "<font color=red>危险球取消</font>"; } else if (set.Tables[0].Rows[i]["iscancel"].ToString().Trim().ToUpper() == "TRUE") { text3 = text3 + "<font color=red>已取消</font>"; } else { double num12 = double.Parse(set.Tables[0].Rows[i]["win"].ToString().Trim()) - double.Parse(set.Tables[0].Rows[i]["lose"].ToString().Trim()); text3 = text3 + MyFunc.NumBerFormat(num12.ToString()); } text3 = text3 + "</td><td align=center>"; if ((this.Session.Contents["classid"] != null) && (this.Session.Contents["classid"].ToString().Trim() == "3")) { text3 = text3 + "<font color=red>不能操作</font>"; } else if (set.Tables[0].Rows[i]["iscancel"].ToString().Trim().ToUpper() == "TRUE") { string text12 = text3; text3 = text12 + "<a href=orderlist.aspx?action=resume&orderid=" + set.Tables[0].Rows[i]["orderid"].ToString().Trim() + "&start=" + start_date + "&end=" + end_date + "&flag=" + isjs + "&bid=" + ballid + "&type=" + tztype + "&gid=" + gdid + "&zid=" + zdlid + "&did=" + dlsid + "&uid=" + userid + "&uname=" + username + "&oid=" + orderid + "&t1=" + t1 + "&t2=" + t2 + "&matchname=" + matchname + "&tzmoney=" + tzmoney + "&rr=" + rr + "&isc=" + iscancel + "&isw=" + iswin + "&page=" + curPage.ToString() + " onclick=\"return confirm('确定要恢复该注单吗?')\"><font color=red>恢复</font></a>"; } else { string text13 = text3; text3 = text13 + "<a href=orderlist.aspx?action=cancel&orderid=" + set.Tables[0].Rows[i]["orderid"].ToString().Trim() + "&start=" + start_date + "&end=" + end_date + "&flag=" + isjs + "&bid=" + ballid + "&type=" + tztype + "&gid=" + gdid + "&zid=" + zdlid + "&did=" + dlsid + "&uid=" + userid + "&uname=" + username + "&oid=" + orderid + "&t1=" + t1 + "&t2=" + t2 + "&matchname=" + matchname + "&tzmoney=" + tzmoney + "&rr=" + rr + "&isc=" + iscancel + "&isw=" + iswin + "&page=" + curPage.ToString() + " onclick=\"return confirm('确定要取消该注单吗?')\">取消</a>"; num5 += double.Parse(set.Tables[0].Rows[i]["tzmoney"].ToString().Trim()); num6 += double.Parse(set.Tables[0].Rows[i]["win"].ToString().Trim()) - double.Parse(set.Tables[0].Rows[i]["lose"].ToString().Trim()); } num7++; text4 = text4 + set.Tables[0].Rows[i]["orderid"].ToString().Trim() + ","; } string text14 = text3; text3 = (text14 + "<tr class=\"sum\"><form name='form1' method='post' action='OrderList.aspx'><input name='action' type='hidden' value='kygl'><input name='order_list' type='hidden' value='" + text4 + "'><td colspan=\"4\"><input type=submit value='取消本页注单' onclick=\"return confirm('确定要取消本页所有注单吗?')\" class=text></td></form><td>当前笔数:" + num7.ToString() + "</td><td> </td><td>" + MyFunc.NumBerFormat(num5.ToString()) + "</td><td> </td><td>" + MyFunc.NumBerFormat(num6.ToString()) + "</td><td> </td></tr>") + "<tr><td colspan=10 align=right bgcolor=#ffffff>" + MyFunc.MulitPager(totalRecord, pagesize, curPage, "OrderList.aspx?start=" + start_date + "&end=" + end_date + "&flag=" + isjs + "&bid=" + ballid + "&type=" + tztype + "&gid=" + gdid + "&zid=" + zdlid + "&did=" + dlsid + "&uid=" + userid + "&oid=" + orderid + "&t1=" + t1 + "&t2=" + t2 + "&matchname=" + matchname + "&tzmoney=" + tzmoney + "&rr=" + rr + "&isc=" + iscancel + "&isw=" + iswin) + "</td></tr>"; SqlDataReader reader = base2.ExecuteReader("SELECT ISNULL(COUNT(1),0) AS ordercount,ISNULL(sum(tzmoney),0) AS tzcount,ISNULL(sum(win-lose),0) AS wincount FROM ball_order " + text2); if (reader.Read()) { string text15 = text3; text3 = text15 + "<tr class=\"sum\"><td colspan=\"4\"> </td><td>总笔数:" + reader["ordercount"].ToString().Trim() + "</td><td> </td><td>" + MyFunc.NumBerFormat(reader["tzcount"].ToString()) + "</td><td> </td><td>" + MyFunc.NumBerFormat(reader["wincount"].ToString()) + "</td><td> </td></tr>"; } reader.Close(); base2.Dispose(); return(text3); }
private void setTableLists() { string sql = ""; double num = 0; DataBase base2 = new DataBase(MyFunc.GetConnStr(2)); this.username.Text = this.Session["adminusername"].ToString(); SqlDataReader reader = base2.ExecuteReader("select isnull(sum(usemoney),0) as usemoney from member where dlsid = '" + this.Session["adminuserid"].ToString() + "'"); if (reader.Read()) { num = Convert.ToDouble(reader["usemoney"]); } reader.Close(); sql = "SELECT Ag.Usemoney,Ag.MaxC1,Ag.MaxC2,Ag.MaxC3,Ag.MaxC4,Ag.MaxC5,Ag.MaxC6,Ag.MaxC7,Ag.MaxC8,Ag.MaxC9,Ag.MaxC10,Ag.MaxC11,Ag.MaxC12,Ag.MaxC13,Ag.MaxC18,Ag.MaxC19,Ag.MaxC20,Ag.MaxC21,Ag.MaxC22,Ag.MaxC23,Ag.MaxC24,Ag.MaxC28,Ag.MaxZ1,Ag.MaxZ2,Ag.MaxZ3,Ag.MaxZ4,Ag.MaxZ5,Ag.MaxZ6,Ag.MaxZ7,Ag.MaxZ8,Ag.MaxZ9,Ag.MaxZ10,Ag.MaxZ11,Ag.MaxZ12,Ag.MaxZ13,Ag.MaxZ28,Ag.MaxZ18,Ag.MaxZ19,Ag.MaxZ20,Ag.MaxZ21,Ag.MaxZ22,Ag.MaxZ23,Ag.MaxZ24,"; string text2 = sql; sql = text2 + "hs.W1,hs.W2,hs.W3,hs.W4,hs.W5,hs.W6,hs.W7,hs.W8,hs.W9,hs.W10,hs.W11,hs.W12,hs.W13,hs.W18,hs.W19,hs.W20,hs.W21,hs.W22,hs.W23,hs.W24,hs.W28,hs.L1,hs.L2,hs.L3,hs.L4,hs.L5,hs.L6,hs.L7,hs.L8,hs.L9,hs.L10,hs.L11,hs.L12,hs.L13,hs.L18,hs.L19,hs.L20,hs.L21,hs.L22,hs.L23,hs.L24,hs.L28,hs.type FROM Agence as Ag JOIN hs ON hs.userid = Ag.userid WHERE Ag.userid ='" + this.Session["adminuserid"].ToString() + "' AND Ag.classid = '" + this.Session["adminclassid"].ToString() + "'"; reader = base2.ExecuteReader(sql); while (reader.Read()) { string str = reader["type"].ToString().ToUpper(); if (str == null) { break; } str = string.IsInterned(str); if (str == "A") { HtmlTableCell cell1 = this.myFootballTable.Rows[0].Cells[0]; cell1.InnerHtml = cell1.InnerHtml + reader["Usemoney"].ToString(); HtmlTableCell cell2 = this.myFootballTable.Rows[0].Cells[0]; cell2.InnerHtml = cell2.InnerHtml + " 已用额度:"; HtmlTableCell cell3 = this.myFootballTable.Rows[0].Cells[0]; cell3.InnerHtml = cell3.InnerHtml + num.ToString("F0"); HtmlTableCell cell4 = this.myFootballTable.Rows[0].Cells[0]; cell4.InnerHtml = cell4.InnerHtml + " 剩余额度:"; HtmlTableCell cell5 = this.myFootballTable.Rows[0].Cells[0]; cell5.InnerHtml = cell5.InnerHtml + ((Convert.ToDouble(reader["Usemoney"]) - num)).ToString("F0"); this.myFootballTable.Rows[2].Cells[1].InnerHtml = reader["MaxZ1"].ToString(); this.myFootballTable.Rows[2].Cells[2].InnerHtml = reader["MaxZ2"].ToString(); this.myFootballTable.Rows[2].Cells[3].InnerHtml = reader["MaxZ3"].ToString(); this.myFootballTable.Rows[2].Cells[4].InnerHtml = reader["MaxZ4"].ToString(); this.myFootballTable.Rows[2].Cells[5].InnerHtml = reader["MaxZ28"].ToString(); this.myFootballTable.Rows[2].Cells[6].InnerHtml = reader["MaxZ5"].ToString(); this.myFootballTable.Rows[2].Cells[7].InnerHtml = reader["MaxZ6"].ToString(); this.myFootballTable.Rows[2].Cells[8].InnerHtml = reader["MaxZ7"].ToString(); this.myFootballTable.Rows[2].Cells[9].InnerHtml = reader["MaxZ8"].ToString(); this.myFootballTable.Rows[2].Cells[10].InnerHtml = reader["MaxZ9"].ToString(); this.myFootballTable.Rows[2].Cells[11].InnerHtml = reader["MaxZ10"].ToString(); this.myFootballTable.Rows[2].Cells[12].InnerHtml = reader["MaxZ11"].ToString(); this.myFootballTable.Rows[2].Cells[13].InnerHtml = reader["MaxZ12"].ToString(); this.myFootballTable.Rows[2].Cells[14].InnerHtml = reader["MaxZ13"].ToString(); this.BKTable.Rows[1].Cells[1].InnerHtml = reader["MaxC18"].ToString().Trim(); this.BKTable.Rows[1].Cells[2].InnerHtml = reader["MaxC19"].ToString().Trim(); this.BKTable.Rows[1].Cells[3].InnerHtml = reader["MaxC20"].ToString().Trim(); this.BKTable.Rows[1].Cells[4].InnerHtml = reader["MaxC21"].ToString().Trim(); this.BKTable.Rows[1].Cells[5].InnerHtml = reader["MaxC22"].ToString().Trim(); this.BKTable.Rows[1].Cells[6].InnerHtml = reader["MaxC23"].ToString().Trim(); this.BKTable.Rows[2].Cells[1].InnerHtml = reader["MaxZ18"].ToString().Trim(); this.BKTable.Rows[2].Cells[2].InnerHtml = reader["MaxZ19"].ToString().Trim(); this.BKTable.Rows[2].Cells[3].InnerHtml = reader["MaxZ20"].ToString().Trim(); this.BKTable.Rows[2].Cells[4].InnerHtml = reader["MaxZ21"].ToString().Trim(); this.BKTable.Rows[2].Cells[5].InnerHtml = reader["MaxZ22"].ToString().Trim(); this.BKTable.Rows[2].Cells[6].InnerHtml = reader["MaxZ23"].ToString().Trim(); this.myFootballTable.Rows[4].Cells[1].InnerHtml = "<font color=#aa0000>" + MyFunc.NumBerFormat(reader["W1"].ToString()) + "</font>/<font color=darkblue>" + MyFunc.NumBerFormat(reader["L1"].ToString()) + "</font>"; this.myFootballTable.Rows[4].Cells[2].InnerHtml = "<font color=#aa0000>" + MyFunc.NumBerFormat(reader["W2"].ToString()) + "</font>/<font color=darkblue>" + MyFunc.NumBerFormat(reader["L2"].ToString()) + "</font>"; this.myFootballTable.Rows[4].Cells[3].InnerHtml = "<font color=#aa0000>" + MyFunc.NumBerFormat(reader["W3"].ToString()) + "</font>/<font color=darkblue>" + MyFunc.NumBerFormat(reader["L3"].ToString()) + "</font>"; this.myFootballTable.Rows[4].Cells[4].InnerHtml = "<font color=#aa0000>" + MyFunc.NumBerFormat(reader["W4"].ToString()) + "</font>/<font color=darkblue>" + MyFunc.NumBerFormat(reader["L4"].ToString()) + "</font>"; this.myFootballTable.Rows[4].Cells[5].InnerHtml = "<font color=#aa0000>" + MyFunc.NumBerFormat(reader["W28"].ToString()) + "</font>/<font color=darkblue>" + MyFunc.NumBerFormat(reader["L28"].ToString()) + "</font>"; this.myFootballTable.Rows[4].Cells[6].InnerHtml = "<font color=#aa0000>" + MyFunc.NumBerFormat(reader["W5"].ToString()) + "</font>/<font color=darkblue>" + MyFunc.NumBerFormat(reader["L5"].ToString()) + "</font>"; this.myFootballTable.Rows[4].Cells[7].InnerHtml = "<font color=#aa0000>" + reader["W6"].ToString() + "</font>/<font color=darkblue>" + reader["L6"].ToString() + "</font>"; this.myFootballTable.Rows[4].Cells[8].InnerHtml = "<font color=#aa0000>" + reader["W7"].ToString() + "</font>/<font color=darkblue>" + reader["L7"].ToString() + "</font>"; this.myFootballTable.Rows[4].Cells[9].InnerHtml = "<font color=#aa0000>" + reader["W8"].ToString() + "</font>/<font color=darkblue>" + reader["L8"].ToString() + "</font>"; this.myFootballTable.Rows[4].Cells[10].InnerHtml = "<font color=#aa0000>" + reader["W9"].ToString() + "</font>/<font color=darkblue>" + reader["L9"].ToString() + "</font>"; this.myFootballTable.Rows[4].Cells[11].InnerHtml = "<font color=#aa0000>" + reader["W10"].ToString() + "</font>/<font color=darkblue>" + reader["L10"].ToString() + "</font>"; this.myFootballTable.Rows[4].Cells[12].InnerHtml = "<font color=#aa0000>" + reader["W11"].ToString() + "</font>/<font color=darkblue>" + reader["L11"].ToString() + "</font>"; this.myFootballTable.Rows[4].Cells[13].InnerHtml = "<font color=#aa0000>" + MyFunc.NumBerFormat(reader["W12"].ToString()) + "</font>/<font color=darkblue>" + MyFunc.NumBerFormat(reader["L12"].ToString()) + "</font>"; this.myFootballTable.Rows[4].Cells[14].InnerHtml = "<font color=#aa0000>" + MyFunc.NumBerFormat(reader["W13"].ToString()) + "</font>/<font color=darkblue>" + MyFunc.NumBerFormat(reader["L13"].ToString()) + "</font>"; this.BKTable.Rows[3].Cells[1].InnerHtml = "<font color=#aa0000>" + MyFunc.NumBerFormat(reader["W18"].ToString()) + "</font>/<font color=darkblue>" + MyFunc.NumBerFormat(reader["L18"].ToString()) + "</font>"; this.BKTable.Rows[3].Cells[2].InnerHtml = "<font color=#aa0000>" + MyFunc.NumBerFormat(reader["W19"].ToString()) + "</font>/<font color=darkblue>" + MyFunc.NumBerFormat(reader["L19"].ToString()) + "</font>"; this.BKTable.Rows[3].Cells[3].InnerHtml = "<font color=#aa0000>" + MyFunc.NumBerFormat(reader["W20"].ToString()) + "</font>/<font color=darkblue>" + MyFunc.NumBerFormat(reader["L20"].ToString()) + "</font>"; this.BKTable.Rows[3].Cells[4].InnerHtml = "<font color=#aa0000>" + MyFunc.NumBerFormat(reader["W21"].ToString()) + "</font>/<font color=darkblue>" + MyFunc.NumBerFormat(reader["L21"].ToString()) + "</font>"; this.BKTable.Rows[3].Cells[5].InnerHtml = "<font color=#aa0000>" + MyFunc.NumBerFormat(reader["W22"].ToString()) + "</font>/<font color=darkblue>" + MyFunc.NumBerFormat(reader["L22"].ToString()) + "</font>"; this.BKTable.Rows[3].Cells[6].InnerHtml = "<font color=#aa0000>" + MyFunc.NumBerFormat(reader["W23"].ToString()) + "</font>/<font color=darkblue>" + MyFunc.NumBerFormat(reader["L23"].ToString()) + "</font>"; } else { if (str == "B") { this.myFootballTable.Rows[3].Cells[1].InnerHtml = reader["MaxC1"].ToString(); this.myFootballTable.Rows[3].Cells[2].InnerHtml = reader["MaxC2"].ToString(); this.myFootballTable.Rows[3].Cells[3].InnerHtml = reader["MaxC3"].ToString(); this.myFootballTable.Rows[3].Cells[4].InnerHtml = reader["MaxC4"].ToString(); this.myFootballTable.Rows[3].Cells[5].InnerHtml = reader["MaxC28"].ToString(); this.myFootballTable.Rows[3].Cells[6].InnerHtml = reader["MaxC5"].ToString(); this.myFootballTable.Rows[3].Cells[7].InnerHtml = reader["MaxC6"].ToString(); this.myFootballTable.Rows[3].Cells[8].InnerHtml = reader["MaxC7"].ToString(); this.myFootballTable.Rows[3].Cells[9].InnerHtml = reader["MaxC8"].ToString(); this.myFootballTable.Rows[3].Cells[10].InnerHtml = reader["MaxC9"].ToString(); this.myFootballTable.Rows[3].Cells[11].InnerHtml = reader["MaxC10"].ToString(); this.myFootballTable.Rows[3].Cells[12].InnerHtml = reader["MaxC11"].ToString(); this.myFootballTable.Rows[3].Cells[13].InnerHtml = reader["MaxC12"].ToString(); this.myFootballTable.Rows[3].Cells[14].InnerHtml = reader["MaxC13"].ToString(); this.myFootballTable.Rows[5].Cells[1].InnerHtml = "<font color=#aa0000>" + MyFunc.NumBerFormat(reader["W1"].ToString()) + "</font>/<font color=darkblue>" + MyFunc.NumBerFormat(reader["L1"].ToString()) + "</font>"; this.myFootballTable.Rows[5].Cells[2].InnerHtml = "<font color=#aa0000>" + MyFunc.NumBerFormat(reader["W2"].ToString()) + "</font>/<font color=darkblue>" + MyFunc.NumBerFormat(reader["L2"].ToString()) + "</font>"; this.myFootballTable.Rows[5].Cells[3].InnerHtml = "<font color=#aa0000>" + MyFunc.NumBerFormat(reader["W3"].ToString()) + "</font>/<font color=darkblue>" + MyFunc.NumBerFormat(reader["L3"].ToString()) + "</font>"; this.myFootballTable.Rows[5].Cells[4].InnerHtml = "<font color=#aa0000>" + MyFunc.NumBerFormat(reader["W4"].ToString()) + "</font>/<font color=darkblue>" + MyFunc.NumBerFormat(reader["L4"].ToString()) + "</font>"; this.myFootballTable.Rows[5].Cells[5].InnerHtml = "<font color=#aa0000>" + MyFunc.NumBerFormat(reader["W28"].ToString()) + "</font>/<font color=darkblue>" + MyFunc.NumBerFormat(reader["L28"].ToString()) + "</font>"; this.myFootballTable.Rows[5].Cells[6].InnerHtml = "<font color=#aa0000>" + MyFunc.NumBerFormat(reader["W5"].ToString()) + "</font>/<font color=darkblue>" + MyFunc.NumBerFormat(reader["L5"].ToString()) + "</font>"; this.myFootballTable.Rows[5].Cells[7].InnerHtml = "<font color=#aa0000>" + reader["W6"].ToString() + "</font>/<font color=darkblue>" + reader["L6"].ToString() + "</font>"; this.myFootballTable.Rows[5].Cells[8].InnerHtml = "<font color=#aa0000>" + reader["W7"].ToString() + "</font>/<font color=darkblue>" + reader["L7"].ToString() + "</font>"; this.myFootballTable.Rows[5].Cells[9].InnerHtml = "<font color=#aa0000>" + reader["W8"].ToString() + "</font>/<font color=darkblue>" + reader["L8"].ToString() + "</font>"; this.myFootballTable.Rows[5].Cells[10].InnerHtml = "<font color=#aa0000>" + reader["W9"].ToString() + "</font>/<font color=darkblue>" + reader["L9"].ToString() + "</font>"; this.myFootballTable.Rows[5].Cells[11].InnerHtml = "<font color=#aa0000>" + reader["W10"].ToString() + "</font>/<font color=darkblue>" + reader["L10"].ToString() + "</font>"; this.myFootballTable.Rows[5].Cells[12].InnerHtml = "<font color=#aa0000>" + reader["W11"].ToString() + "</font>/<font color=darkblue>" + reader["L11"].ToString() + "</font>"; this.myFootballTable.Rows[5].Cells[13].InnerHtml = "<font color=#aa0000>" + MyFunc.NumBerFormat(reader["W12"].ToString()) + "</font>/<font color=darkblue>" + MyFunc.NumBerFormat(reader["L12"].ToString()) + "</font>"; this.myFootballTable.Rows[5].Cells[14].InnerHtml = "<font color=#aa0000>" + MyFunc.NumBerFormat(reader["W13"].ToString()) + "</font>/<font color=darkblue>" + MyFunc.NumBerFormat(reader["L13"].ToString()) + "</font>"; this.BKTable.Rows[4].Cells[1].InnerHtml = "<font color=#aa0000>" + MyFunc.NumBerFormat(reader["W18"].ToString()) + "</font>/<font color=darkblue>" + MyFunc.NumBerFormat(reader["L18"].ToString()) + "</font>"; this.BKTable.Rows[4].Cells[2].InnerHtml = "<font color=#aa0000>" + MyFunc.NumBerFormat(reader["W19"].ToString()) + "</font>/<font color=darkblue>" + MyFunc.NumBerFormat(reader["L19"].ToString()) + "</font>"; this.BKTable.Rows[4].Cells[3].InnerHtml = "<font color=#aa0000>" + MyFunc.NumBerFormat(reader["W20"].ToString()) + "</font>/<font color=darkblue>" + MyFunc.NumBerFormat(reader["L20"].ToString()) + "</font>"; this.BKTable.Rows[4].Cells[4].InnerHtml = "<font color=#aa0000>" + MyFunc.NumBerFormat(reader["W21"].ToString()) + "</font>/<font color=darkblue>" + MyFunc.NumBerFormat(reader["L21"].ToString()) + "</font>"; this.BKTable.Rows[4].Cells[5].InnerHtml = "<font color=#aa0000>" + MyFunc.NumBerFormat(reader["W22"].ToString()) + "</font>/<font color=darkblue>" + MyFunc.NumBerFormat(reader["L22"].ToString()) + "</font>"; this.BKTable.Rows[4].Cells[6].InnerHtml = "<font color=#aa0000>" + MyFunc.NumBerFormat(reader["W23"].ToString()) + "</font>/<font color=darkblue>" + MyFunc.NumBerFormat(reader["L23"].ToString()) + "</font>"; } else if (str == "C") { this.myFootballTable.Rows[6].Cells[1].InnerHtml = "<font color=#aa0000>" + MyFunc.NumBerFormat(reader["W1"].ToString()) + "</font>/<font color=darkblue>" + MyFunc.NumBerFormat(reader["L1"].ToString()) + "</font>"; this.myFootballTable.Rows[6].Cells[2].InnerHtml = "<font color=#aa0000>" + MyFunc.NumBerFormat(reader["W2"].ToString()) + "</font>/<font color=darkblue>" + MyFunc.NumBerFormat(reader["L2"].ToString()) + "</font>"; this.myFootballTable.Rows[6].Cells[3].InnerHtml = "<font color=#aa0000>" + MyFunc.NumBerFormat(reader["W3"].ToString()) + "</font>/<font color=darkblue>" + MyFunc.NumBerFormat(reader["L3"].ToString()) + "</font>"; this.myFootballTable.Rows[6].Cells[4].InnerHtml = "<font color=#aa0000>" + MyFunc.NumBerFormat(reader["W4"].ToString()) + "</font>/<font color=darkblue>" + MyFunc.NumBerFormat(reader["L4"].ToString()) + "</font>"; this.myFootballTable.Rows[6].Cells[5].InnerHtml = "<font color=#aa0000>" + MyFunc.NumBerFormat(reader["W28"].ToString()) + "</font>/<font color=darkblue>" + MyFunc.NumBerFormat(reader["L28"].ToString()) + "</font>"; this.myFootballTable.Rows[6].Cells[6].InnerHtml = "<font color=#aa0000>" + MyFunc.NumBerFormat(reader["W5"].ToString()) + "</font>/<font color=darkblue>" + MyFunc.NumBerFormat(reader["L5"].ToString()) + "</font>"; this.myFootballTable.Rows[6].Cells[7].InnerHtml = "<font color=#aa0000>" + reader["W6"].ToString() + "</font>/<font color=darkblue>" + reader["L6"].ToString() + "</font>"; this.myFootballTable.Rows[6].Cells[8].InnerHtml = "<font color=#aa0000>" + reader["W7"].ToString() + "</font>/<font color=darkblue>" + reader["L7"].ToString() + "</font>"; this.myFootballTable.Rows[6].Cells[9].InnerHtml = "<font color=#aa0000>" + reader["W8"].ToString() + "</font>/<font color=darkblue>" + reader["L8"].ToString() + "</font>"; this.myFootballTable.Rows[6].Cells[10].InnerHtml = "<font color=#aa0000>" + reader["W9"].ToString() + "</font>/<font color=darkblue>" + reader["L9"].ToString() + "</font>"; this.myFootballTable.Rows[6].Cells[11].InnerHtml = "<font color=#aa0000>" + reader["W10"].ToString() + "</font>/<font color=darkblue>" + reader["L10"].ToString() + "</font>"; this.myFootballTable.Rows[6].Cells[12].InnerHtml = "<font color=#aa0000>" + reader["W11"].ToString() + "</font>/<font color=darkblue>" + reader["L11"].ToString() + "</font>"; this.myFootballTable.Rows[6].Cells[13].InnerHtml = "<font color=#aa0000>" + MyFunc.NumBerFormat(reader["W12"].ToString()) + "</font>/<font color=darkblue>" + MyFunc.NumBerFormat(reader["L12"].ToString()) + "</font>"; this.myFootballTable.Rows[6].Cells[14].InnerHtml = "<font color=#aa0000>" + MyFunc.NumBerFormat(reader["W13"].ToString()) + "</font>/<font color=darkblue>" + MyFunc.NumBerFormat(reader["L13"].ToString()) + "</font>"; this.BKTable.Rows[5].Cells[1].InnerHtml = "<font color=#aa0000>" + MyFunc.NumBerFormat(reader["W18"].ToString()) + "</font>/<font color=darkblue>" + MyFunc.NumBerFormat(reader["L18"].ToString()) + "</font>"; this.BKTable.Rows[5].Cells[2].InnerHtml = "<font color=#aa0000>" + MyFunc.NumBerFormat(reader["W19"].ToString()) + "</font>/<font color=darkblue>" + MyFunc.NumBerFormat(reader["L19"].ToString()) + "</font>"; this.BKTable.Rows[5].Cells[3].InnerHtml = "<font color=#aa0000>" + MyFunc.NumBerFormat(reader["W20"].ToString()) + "</font>/<font color=darkblue>" + MyFunc.NumBerFormat(reader["L20"].ToString()) + "</font>"; this.BKTable.Rows[5].Cells[4].InnerHtml = "<font color=#aa0000>" + MyFunc.NumBerFormat(reader["W21"].ToString()) + "</font>/<font color=darkblue>" + MyFunc.NumBerFormat(reader["L21"].ToString()) + "</font>"; this.BKTable.Rows[5].Cells[5].InnerHtml = "<font color=#aa0000>" + MyFunc.NumBerFormat(reader["W22"].ToString()) + "</font>/<font color=darkblue>" + MyFunc.NumBerFormat(reader["L22"].ToString()) + "</font>"; this.BKTable.Rows[5].Cells[6].InnerHtml = "<font color=#aa0000>" + MyFunc.NumBerFormat(reader["W23"].ToString()) + "</font>/<font color=darkblue>" + MyFunc.NumBerFormat(reader["L23"].ToString()) + "</font>"; } else { if (str != "D") { break; } this.myFootballTable.Rows[7].Cells[1].InnerHtml = "<font color=#aa0000>" + MyFunc.NumBerFormat(reader["W1"].ToString()) + "</font>/<font color=darkblue>" + MyFunc.NumBerFormat(reader["L1"].ToString()) + "</font>"; this.myFootballTable.Rows[7].Cells[2].InnerHtml = "<font color=#aa0000>" + MyFunc.NumBerFormat(reader["W2"].ToString()) + "</font>/<font color=darkblue>" + MyFunc.NumBerFormat(reader["L2"].ToString()) + "</font>"; this.myFootballTable.Rows[7].Cells[3].InnerHtml = "<font color=#aa0000>" + MyFunc.NumBerFormat(reader["W3"].ToString()) + "</font>/<font color=darkblue>" + MyFunc.NumBerFormat(reader["L3"].ToString()) + "</font>"; this.myFootballTable.Rows[7].Cells[4].InnerHtml = "<font color=#aa0000>" + MyFunc.NumBerFormat(reader["W4"].ToString()) + "</font>/<font color=darkblue>" + MyFunc.NumBerFormat(reader["L4"].ToString()) + "</font>"; this.myFootballTable.Rows[7].Cells[5].InnerHtml = "<font color=#aa0000>" + MyFunc.NumBerFormat(reader["W28"].ToString()) + "</font>/<font color=darkblue>" + MyFunc.NumBerFormat(reader["L28"].ToString()) + "</font>"; this.myFootballTable.Rows[7].Cells[6].InnerHtml = "<font color=#aa0000>" + MyFunc.NumBerFormat(reader["W5"].ToString()) + "</font>/<font color=darkblue>" + MyFunc.NumBerFormat(reader["L5"].ToString()) + "</font>"; this.myFootballTable.Rows[7].Cells[7].InnerHtml = "<font color=#aa0000>" + reader["W6"].ToString() + "</font>/<font color=darkblue>" + reader["L6"].ToString() + "</font>"; this.myFootballTable.Rows[7].Cells[8].InnerHtml = "<font color=#aa0000>" + reader["W7"].ToString() + "</font>/<font color=darkblue>" + reader["L7"].ToString() + "</font>"; this.myFootballTable.Rows[7].Cells[9].InnerHtml = "<font color=#aa0000>" + reader["W8"].ToString() + "</font>/<font color=darkblue>" + reader["L8"].ToString() + "</font>"; this.myFootballTable.Rows[7].Cells[10].InnerHtml = "<font color=#aa0000>" + reader["W9"].ToString() + "</font>/<font color=darkblue>" + reader["L9"].ToString() + "</font>"; this.myFootballTable.Rows[7].Cells[11].InnerHtml = "<font color=#aa0000>" + reader["W10"].ToString() + "</font>/<font color=darkblue>" + reader["L10"].ToString() + "</font>"; this.myFootballTable.Rows[7].Cells[12].InnerHtml = "<font color=#aa0000>" + reader["W11"].ToString() + "</font>/<font color=darkblue>" + reader["L11"].ToString() + "</font>"; this.myFootballTable.Rows[7].Cells[13].InnerHtml = "<font color=#aa0000>" + MyFunc.NumBerFormat(reader["W12"].ToString()) + "</font>/<font color=darkblue>" + MyFunc.NumBerFormat(reader["L12"].ToString()) + "</font>"; this.myFootballTable.Rows[7].Cells[14].InnerHtml = "<font color=#aa0000>" + MyFunc.NumBerFormat(reader["W13"].ToString()) + "</font>/<font color=darkblue>" + MyFunc.NumBerFormat(reader["L13"].ToString()) + "</font>"; this.BKTable.Rows[6].Cells[1].InnerHtml = "<font color=#aa0000>" + MyFunc.NumBerFormat(reader["W18"].ToString()) + "</font>/<font color=darkblue>" + MyFunc.NumBerFormat(reader["L18"].ToString()) + "</font>"; this.BKTable.Rows[6].Cells[2].InnerHtml = "<font color=#aa0000>" + MyFunc.NumBerFormat(reader["W19"].ToString()) + "</font>/<font color=darkblue>" + MyFunc.NumBerFormat(reader["L19"].ToString()) + "</font>"; this.BKTable.Rows[6].Cells[3].InnerHtml = "<font color=#aa0000>" + MyFunc.NumBerFormat(reader["W20"].ToString()) + "</font>/<font color=darkblue>" + MyFunc.NumBerFormat(reader["L20"].ToString()) + "</font>"; this.BKTable.Rows[6].Cells[4].InnerHtml = "<font color=#aa0000>" + MyFunc.NumBerFormat(reader["W21"].ToString()) + "</font>/<font color=darkblue>" + MyFunc.NumBerFormat(reader["L21"].ToString()) + "</font>"; this.BKTable.Rows[6].Cells[5].InnerHtml = "<font color=#aa0000>" + MyFunc.NumBerFormat(reader["W22"].ToString()) + "</font>/<font color=darkblue>" + MyFunc.NumBerFormat(reader["L22"].ToString()) + "</font>"; this.BKTable.Rows[6].Cells[6].InnerHtml = "<font color=#aa0000>" + MyFunc.NumBerFormat(reader["W23"].ToString()) + "</font>/<font color=darkblue>" + MyFunc.NumBerFormat(reader["L23"].ToString()) + "</font>"; } continue; } } }
private void ShowZongShuPartContent(DataBase db) { string text = ""; SqlDataReader reader = db.ExecuteReader(this.allPartSql); text = "<table border=0 cellspacing=1 cellpadding=0 class=tableborder1 width=100%>\n"; if (reader.Read()) { text = ((((((text + "<tr class=reportTotalchar align=right height=22>" + "<td width=10% class=reportTotalchar>总 数</td>") + "<td width=10% align=right>" + reader["tzNumber"].ToString() + "</td>") + "<td width=10% align=right>" + MyFunc.NumBerFormat(reader["tzmoney"].ToString()) + "</td>") + "<td width=10% align=right>" + MyFunc.NumBerFormat(reader["result"].ToString()) + "</td>") + "<td width=10% align=right>" + MyFunc.NumBerFormat(reader["mdls"].ToString()) + "</td>") + "<td width=10% align=right>" + MyFunc.NumBerFormat(reader["mzdl"].ToString()) + "</td>") + "<td width=10% align=right> </td></tr>"; } else { text = (((text + "<tr class=reportTotalchar align=right height=22>" + "<td width=10% class=reportTotalchar>总 数</td>") + "<td width=10% align=right>0</td>" + "<td width=10% align=right>0.00</td>") + "<td width=10% align=right>0.00</td>" + "<td width=10% align=right>0.00</td>") + "<td width=10% align=right>0.00</td>" + "<td width=10% align=right> </td></tr>\n"; } reader.Close(); text = text + "</table>\n"; this.tableBottom.Rows[1].Cells[0].InnerHtml = text; }
private void ShowCreditPartContent(DataBase db) { string text = ""; int num = 0; double num2 = 0; double num3 = 0; double num4 = 0; double num5 = 0; double num6 = 0; double num7 = 0; SqlDataReader reader = db.ExecuteReader(this.creditPartSql); text = "<table border=0 cellspacing=1 cellpadding=0 class=tableNoBorder1 width=100%>\n"; text = text + "<tr class=dlsreport><td width=8%>投注方式</td><td width=5%>笔数</td><td width=13%>会员投注金额</td><td width=13%>会员</td><td width=13%>代理商金额</td><td width=13%>代理商</td><td width=5%>成数</td><td width=13%>总代理金额</td><td width=13%>总代理</td><td width=5%>成数</td></tr>\n"; while (reader.Read()) { string text2 = ((text + "<tr bgcolor=white align=right height=22>") + "<td align=center>" + reader["tzTypeName"].ToString() + "</td>") + "<td>" + reader["tzNumber"].ToString() + "</td>"; text = ((((((((text2 + "<td><a href='reportpartshownext.aspx?search=credit" + this.pathPartStr + "&tzType=" + reader["tzType"].ToString() + "'><font color=blue>" + MyFunc.NumBerFormat(reader["tzmoney"].ToString()) + "</font></a></td>") + "<td>" + MyFunc.NumBerFormat(reader["result"].ToString()) + "</td>") + "<td>" + MyFunc.NumBerFormat(reader["mdls"].ToString()) + "</td>") + "<td>" + MyFunc.NumBerFormat(reader["csmdls"].ToString()) + "</td>") + "<td>" + Convert.ToDouble(reader["csdls"]).ToString("F1") + "</td>") + "<td>" + MyFunc.NumBerFormat(reader["mzdl"].ToString()) + "</td>") + "<td>" + MyFunc.NumBerFormat(reader["csmzdl"].ToString()) + "</td>") + "<td>" + Convert.ToDouble(reader["cszdl"]).ToString("F1") + "</td>") + "</tr>\n"; num += int.Parse(reader["tzNumber"].ToString()); num2 += double.Parse(reader["tzmoney"].ToString()); num3 += double.Parse(reader["mdls"].ToString()); num4 += double.Parse(reader["mzdl"].ToString()); num5 += double.Parse(reader["csmdls"].ToString()); num6 += double.Parse(reader["csmzdl"].ToString()); num7 += double.Parse(reader["result"].ToString()); } reader.Close(); text = (((((((((text + "<tr class=reportTotalnum align=right height=22><td class=reportTotalchar>总 数</td>") + "<td>" + num.ToString() + "</td>") + "<td>" + MyFunc.NumBerFormat(num2.ToString()) + "</td>") + "<td>" + MyFunc.NumBerFormat(num7.ToString()) + "</td>") + "<td>" + MyFunc.NumBerFormat(num3.ToString()) + "</td>") + "<td>" + MyFunc.NumBerFormat(num5.ToString()) + "</td>") + "<td> </td>") + "<td>" + MyFunc.NumBerFormat(num4.ToString()) + "</td>") + "<td>" + MyFunc.NumBerFormat(num6.ToString()) + "</td>") + "<td> </td></tr>" + "</table>\n"; this.tableHeader.Rows[1].Cells[0].InnerHtml = text; }
private void ShowCashContent(DataBase db) { string text = ""; int num = 0; double num2 = 0; double num3 = 0; double num4 = 0; double num5 = 0; SqlDataReader reader = db.ExecuteReader(this.cashSql); text = "<table border=0 cellspacing=1 cellpadding=0 class=tableNoBorder1 width=100%>\n"; text = text + "<tr class=pinkheader><td width=10%>代理商</td><td width=10%>投注数</td><td width=10%>投注额</td><td width=10%>会员</td><td width=10%>代理商金额</td><td width=10%>代理商</td><td width=10%>总代理金额</td><td width=10%>总代理</td></tr>\n"; while (reader.Read()) { string text2 = ((text + "<tr bgcolor=white align=right height=22>") + "<td align=center>" + reader["dlsname"].ToString() + "</td>") + "<td>" + reader["tzNumber"].ToString() + "</td>"; text = ((((((((text2 + "<td><a href='reportshowuser.aspx?search=cash" + this.pathStr + "&dlsid=" + reader["dlsid"].ToString() + "'><font color=blue>" + MyFunc.NumBerFormat(reader["tzmoney"].ToString()) + "</font></a></td>") + "<td>" + MyFunc.NumBerFormat(reader["result"].ToString()) + "</td>") + "<td> </td>") + "<td>" + MyFunc.NumBerFormat(reader["mdls"].ToString()) + "</td>") + "<td>" + Convert.ToDouble(reader["csdls"]).ToString("F1") + "</td>") + "<td> </td>") + "<td>" + MyFunc.NumBerFormat(reader["mzdl"].ToString()) + "</td>") + "<td>" + Convert.ToDouble(reader["cszdl"]).ToString("F1") + "</td>") + "</tr>\n"; num += int.Parse(reader["tzNumber"].ToString()); num2 += double.Parse(reader["tzmoney"].ToString()); num3 += double.Parse(reader["mdls"].ToString()); num4 += double.Parse(reader["mzdl"].ToString()); num5 += double.Parse(reader["result"].ToString()); } reader.Close(); text = ((((((((text + "<tr class=reportTotalnum align=right height=22><td class=reportTotalchar>总 数</td>") + "<td>" + num.ToString() + "</td>") + "<td>" + MyFunc.NumBerFormat(num2.ToString()) + "</td>") + "<td>" + MyFunc.NumBerFormat(num5.ToString()) + "</td>") + "<td> </td>") + "<td>" + MyFunc.NumBerFormat(num3.ToString()) + "</td>") + "<td> </td>") + "<td>" + MyFunc.NumBerFormat(num4.ToString()) + "</td></tr>") + "</table>\n"; this.tableMiddle.Rows[1].Cells[0].InnerHtml = text; }
private void ShowCreditContent(DataBase db) { string text = ""; int num = 0; double num2 = 0; double num3 = 0; double num4 = 0; double num5 = 0; double num6 = 0; double num7 = 0; double num8 = 0; SqlDataReader reader = db.ExecuteReader(this.creditSql); text = "<table border=0 cellspacing=1 cellpadding=0 class=tableNoborder1 width=100%>\n"; text = text + "<tr class=dlsreport><td width=8%>股东</td><td width=5%>笔数</td><td width=15%>会员投注金额</td><td width=12%>会员</td><td width=10%>代理商</td><td width=10%>总代理</td><td width=10%>股东金额</td><td width=10%>股东</td><td width=5% nowrap>成数</td><td width=10%>公司</td><td width=5% nowrap>成数</td></tr>\n"; while (reader.Read()) { string text2 = text + "<tr bgcolor=white align=right height=22>"; string text3 = (text2 + "<td align=center><a href='gdlist_reportlist.aspx?userid=" + reader["gdid"].ToString() + "&username="******"gdname"].ToString() + "'>" + reader["gdname"].ToString() + "</a></td>") + "<td>" + reader["tzNumber"].ToString() + "</td>"; text = (((((((((text3 + "<td><a href='reportshowzdl.aspx?search=credit" + this.pathStr + "&gdid=" + reader["gdid"].ToString() + "'><font color=blue>" + MyFunc.NumBerFormat(reader["tzmoney"].ToString()) + "</font></a></td>") + "<td>" + MyFunc.NumBerFormat(reader["result"].ToString()) + "</td>") + "<td>" + MyFunc.NumBerFormat(reader["mdls"].ToString()) + "</td>") + "<td>" + MyFunc.NumBerFormat(reader["mzdl"].ToString()) + "</td>") + "<td>" + MyFunc.NumBerFormat(reader["mgd"].ToString()) + "</td>") + "<td>" + MyFunc.NumBerFormat(reader["csmgd"].ToString()) + "</td>") + "<td>" + Convert.ToDouble(reader["csgd"]).ToString("F1") + "</td>") + "<td>" + MyFunc.NumBerFormat(reader["mgs"].ToString()) + "</td>") + "<td>" + Convert.ToDouble(reader["csgs"]).ToString("F1") + "</td>") + "</tr>\n"; num += int.Parse(reader["tzNumber"].ToString()); num2 += double.Parse(reader["tzmoney"].ToString()); num3 += double.Parse(reader["mdls"].ToString()); num4 += double.Parse(reader["mzdl"].ToString()); num5 += double.Parse(reader["mgd"].ToString()); num6 += double.Parse(reader["csmgd"].ToString()); num7 += double.Parse(reader["mgs"].ToString()); num8 += double.Parse(reader["result"].ToString()); } reader.Close(); text = ((((((((((text + "<tr height=22 class=reportTotalnum><td class=reportTotalchar>总 数</td>") + "<td>" + num.ToString() + "</td>") + "<td>" + MyFunc.NumBerFormat(num2.ToString()) + "</td>") + "<td>" + MyFunc.NumBerFormat(num8.ToString()) + "</td>") + "<td>" + MyFunc.NumBerFormat(num3.ToString()) + "</td>") + "<td>" + MyFunc.NumBerFormat(num4.ToString()) + "</td>") + "<td>" + MyFunc.NumBerFormat(num5.ToString()) + "</td>") + "<td>" + MyFunc.NumBerFormat(num6.ToString()) + "</td>") + "<td> </td>") + "<td>" + MyFunc.NumBerFormat(num7.ToString()) + "</td>") + "<td> </td>" + "</tr></table>\n"; this.tableHeader.Rows[1].Cells[0].InnerHtml = text; }
private void setfootballtableproc(SqlDataReader dr) { string text = "0"; string text2 = "0"; string text3 = "0"; string text4 = "0"; string text5 = "0"; string text6 = "0"; string text7 = "0"; string text8 = "0"; string text9 = "0"; string text10 = "0"; string text11 = "0"; string text12 = "0"; string text13 = "0"; string text14 = "0"; string text15 = "0"; string text16 = "0"; string text17 = "0"; string text18 = "0"; string text19 = "0"; string text20 = "0"; string text21 = "0"; string text22 = "0"; string text23 = "0"; string text24 = "0"; string text25 = "0"; string text26 = "0"; string text27 = "0"; string text28 = "0"; string text29 = "0"; string text30 = "0"; string text31 = "0"; string text32 = "0"; string text33 = "0"; string text34 = "0"; string text35 = "0"; string text36 = "0"; string text37 = "0"; string text38 = "0"; string text39 = "0"; string text40 = "0"; string text41 = "0"; string text42 = "0"; string text43 = "0"; string text44 = "0"; string text45 = "0"; string text46 = "0"; this.username.InnerHtml = dr["username"].ToString(); this.truename.InnerHtml = dr["truename"].ToString(); this.ABC.InnerHtml = dr["abc"].ToString(); this.moneysort.InnerHtml = dr["moneysort"].ToString(); DataBase base2 = new DataBase(MyFunc.GetConnStr(2)); SqlDataReader reader = base2.ExecuteReader("select W1,W2,W3,W4,W5,W6,W7,W8,W9,W10,W11,W12,W13,W14,W15,W18,W19,W20,W21,W22,W23,W24,W28,L1,L2,L3,L4,L5,L6,L7,L8,L9,L10,L11,L12,L13,L14,L15,L18,L19,L20,L21,L22,L23,L24,L28 FROM hs WHERE userid='" + dr["dlsid"].ToString().Trim() + "' and type = '" + dr["abc"].ToString().Trim() + "'"); if (reader.Read()) { text = reader["W1"].ToString(); text2 = reader["W2"].ToString(); text3 = reader["W3"].ToString(); text4 = reader["W4"].ToString(); text5 = reader["W5"].ToString(); text6 = reader["W6"].ToString(); text7 = reader["W7"].ToString(); text8 = reader["W8"].ToString(); text9 = reader["W9"].ToString(); text10 = reader["W10"].ToString(); text11 = reader["W11"].ToString(); text12 = reader["W12"].ToString(); text13 = reader["W13"].ToString(); text14 = reader["W14"].ToString(); text15 = reader["W15"].ToString(); text16 = reader["W18"].ToString(); text17 = reader["W19"].ToString(); text18 = reader["W20"].ToString(); text19 = reader["W21"].ToString(); text20 = reader["W22"].ToString(); text21 = reader["W23"].ToString(); text22 = reader["W24"].ToString(); text23 = reader["W28"].ToString(); text24 = reader["L1"].ToString(); text25 = reader["L2"].ToString(); text26 = reader["L3"].ToString(); text27 = reader["L4"].ToString(); text28 = reader["L5"].ToString(); text29 = reader["L6"].ToString(); text30 = reader["L7"].ToString(); text31 = reader["L8"].ToString(); text32 = reader["L9"].ToString(); text33 = reader["L10"].ToString(); text34 = reader["L11"].ToString(); text35 = reader["L12"].ToString(); text36 = reader["L13"].ToString(); text37 = reader["L14"].ToString(); text38 = reader["L15"].ToString(); text39 = reader["L18"].ToString(); text40 = reader["L19"].ToString(); text41 = reader["L20"].ToString(); text42 = reader["L21"].ToString(); text43 = reader["L22"].ToString(); text44 = reader["L23"].ToString(); text45 = reader["L24"].ToString(); text46 = reader["L28"].ToString(); } reader.Close(); SqlDataReader reader2 = base2.ExecuteReader("SELECT W1,W2,W3,W4,W5,W6,W7,W8,W9,W10,W11,W12,W13,W14,W15,W18,W19,W20,W21,W22,W23,W24,W28,L1,L2,L3,L4,L5,L6,L7,L8,L9,L10,L11,L12,L13,L14,L15,L18,L19,L20,L21,L22,L23,L24,L28,MAXC1,MAXC2,MAXC3,MAXC4,MAXC5,MAXC6,MAXC7,MAXC8,MAXC9,MAXC10,MAXC11,MAXC12,MAXC13,MAXC14,MAXC15,MAXC18,MAXC19,MAXC20,MAXC21,MAXC22,MAXC23,MAXC24,MAXC28,MAXZ1,MAXZ2,MAXZ3,MAXZ4,MAXZ5,MAXZ6,MAXZ7,MAXZ8,MAXZ9,MAXZ10,MAXZ11,MAXZ12,MAXZ13,MAXZ14,MAXZ15,MAXZ18,MAXZ19,MAXZ20,MAXZ21,MAXZ22,MAXZ23,MAXZ24,MAXZ28 FROM userhs where userid = '" + this.useridhid.Value + "'"); if (reader2.Read()) { this.footballsettable.Rows[2].Cells[1].InnerHtml = reader2["MAXC1"].ToString().Trim() + " "; this.footballsettable.Rows[2].Cells[2].InnerHtml = reader2["MAXC2"].ToString().Trim() + " "; this.footballsettable.Rows[2].Cells[3].InnerHtml = reader2["MAXC3"].ToString().Trim() + " "; this.footballsettable.Rows[2].Cells[4].InnerHtml = reader2["MAXC4"].ToString().Trim() + " "; this.footballsettable.Rows[2].Cells[5].InnerHtml = reader2["MAXC28"].ToString().Trim() + " "; this.footballsettable.Rows[2].Cells[6].InnerHtml = reader2["MAXC5"].ToString().Trim() + " "; this.footballsettable.Rows[2].Cells[7].InnerHtml = reader2["MAXC6"].ToString().Trim() + " "; this.footballsettable.Rows[2].Cells[8].InnerHtml = reader2["MAXC7"].ToString().Trim() + " "; this.footballsettable.Rows[2].Cells[9].InnerHtml = reader2["MAXC8"].ToString().Trim() + " "; this.footballsettable.Rows[2].Cells[10].InnerHtml = reader2["MAXC9"].ToString().Trim() + " "; this.footballsettable.Rows[2].Cells[11].InnerHtml = reader2["MAXC10"].ToString().Trim() + " "; this.footballsettable.Rows[2].Cells[12].InnerHtml = reader2["MAXC11"].ToString().Trim() + " "; this.footballsettable.Rows[2].Cells[13].InnerHtml = reader2["MAXC12"].ToString().Trim() + " "; this.footballsettable.Rows[2].Cells[14].InnerHtml = reader2["MAXC13"].ToString().Trim() + " "; this.BKTable.Rows[2].Cells[1].InnerText = reader2["MAXC18"].ToString().Trim(); this.BKTable.Rows[2].Cells[2].InnerText = reader2["MAXC19"].ToString().Trim(); this.BKTable.Rows[2].Cells[3].InnerText = reader2["MAXC20"].ToString().Trim(); this.BKTable.Rows[2].Cells[4].InnerText = reader2["MAXC21"].ToString().Trim(); this.BKTable.Rows[2].Cells[5].InnerText = reader2["MAXC22"].ToString().Trim(); this.BKTable.Rows[2].Cells[6].InnerText = reader2["MAXC23"].ToString().Trim(); this.footballsettable.Rows[3].Cells[1].InnerHtml = reader2["MAXZ1"].ToString().Trim() + " "; this.footballsettable.Rows[3].Cells[2].InnerHtml = reader2["MAXZ2"].ToString().Trim() + " "; this.footballsettable.Rows[3].Cells[3].InnerHtml = reader2["MAXZ3"].ToString().Trim() + " "; this.footballsettable.Rows[3].Cells[4].InnerHtml = reader2["MAXZ4"].ToString().Trim() + " "; this.footballsettable.Rows[3].Cells[5].InnerHtml = reader2["MAXZ28"].ToString().Trim() + " "; this.footballsettable.Rows[3].Cells[6].InnerHtml = reader2["MAXZ5"].ToString().Trim() + " "; this.footballsettable.Rows[3].Cells[7].InnerHtml = reader2["MAXZ6"].ToString().Trim() + " "; this.footballsettable.Rows[3].Cells[8].InnerHtml = reader2["MAXZ7"].ToString().Trim() + " "; this.footballsettable.Rows[3].Cells[9].InnerHtml = reader2["MAXZ8"].ToString().Trim() + " "; this.footballsettable.Rows[3].Cells[10].InnerHtml = reader2["MAXZ9"].ToString().Trim() + " "; this.footballsettable.Rows[3].Cells[11].InnerHtml = reader2["MAXZ10"].ToString().Trim() + " "; this.footballsettable.Rows[3].Cells[12].InnerHtml = reader2["MAXZ11"].ToString().Trim() + " "; this.footballsettable.Rows[3].Cells[13].InnerHtml = reader2["MAXZ12"].ToString().Trim() + " "; this.footballsettable.Rows[3].Cells[14].InnerHtml = reader2["MAXZ13"].ToString().Trim() + " "; this.BKTable.Rows[3].Cells[1].InnerText = reader2["MAXZ18"].ToString().Trim(); this.BKTable.Rows[3].Cells[2].InnerText = reader2["MAXZ19"].ToString().Trim(); this.BKTable.Rows[3].Cells[3].InnerText = reader2["MAXZ20"].ToString().Trim(); this.BKTable.Rows[3].Cells[4].InnerText = reader2["MAXZ21"].ToString().Trim(); this.BKTable.Rows[3].Cells[5].InnerText = reader2["MAXZ22"].ToString().Trim(); this.BKTable.Rows[3].Cells[6].InnerText = reader2["MAXZ23"].ToString().Trim(); this.footballsettable.Rows[1].Cells[1].InnerHtml = MyFunc.NumBerFormat(reader2["W1"].ToString().Trim()) + " / " + MyFunc.NumBerFormat(reader2["L1"].ToString().Trim()); this.footballsettable.Rows[1].Cells[2].InnerHtml = MyFunc.NumBerFormat(reader2["W2"].ToString().Trim()) + " / " + MyFunc.NumBerFormat(reader2["L2"].ToString().Trim()); this.footballsettable.Rows[1].Cells[3].InnerHtml = MyFunc.NumBerFormat(reader2["W3"].ToString().Trim()) + " / " + MyFunc.NumBerFormat(reader2["L3"].ToString().Trim()); this.footballsettable.Rows[1].Cells[4].InnerHtml = MyFunc.NumBerFormat(reader2["W4"].ToString().Trim()) + " / " + MyFunc.NumBerFormat(reader2["L4"].ToString().Trim()); this.footballsettable.Rows[1].Cells[5].InnerHtml = MyFunc.NumBerFormat(reader2["W28"].ToString().Trim()) + " / " + MyFunc.NumBerFormat(reader2["L28"].ToString().Trim()); this.footballsettable.Rows[1].Cells[6].InnerHtml = MyFunc.NumBerFormat(reader2["W5"].ToString().Trim()) + " / " + MyFunc.NumBerFormat(reader2["L5"].ToString().Trim()); this.footballsettable.Rows[1].Cells[7].InnerHtml = reader2["W6"].ToString().Trim() + " / " + reader2["L6"].ToString().Trim(); this.footballsettable.Rows[1].Cells[8].InnerHtml = reader2["W7"].ToString().Trim() + " / " + reader2["L7"].ToString().Trim(); this.footballsettable.Rows[1].Cells[9].InnerHtml = reader2["W8"].ToString().Trim() + " / " + reader2["L8"].ToString().Trim(); this.footballsettable.Rows[1].Cells[10].InnerHtml = reader2["W9"].ToString().Trim() + " / " + reader2["L9"].ToString().Trim(); this.footballsettable.Rows[1].Cells[11].InnerHtml = reader2["W10"].ToString().Trim() + " / " + reader2["L10"].ToString().Trim(); this.footballsettable.Rows[1].Cells[12].InnerHtml = reader2["W11"].ToString().Trim() + " / " + reader2["L11"].ToString().Trim(); this.footballsettable.Rows[1].Cells[13].InnerHtml = MyFunc.NumBerFormat(reader2["W12"].ToString().Trim()) + " / " + MyFunc.NumBerFormat(reader2["L12"].ToString().Trim()); this.footballsettable.Rows[1].Cells[14].InnerHtml = MyFunc.NumBerFormat(reader2["W13"].ToString().Trim()) + " / " + MyFunc.NumBerFormat(reader2["L13"].ToString().Trim()); this.BKTable.Rows[1].Cells[1].InnerText = double.Parse(reader2["W18"].ToString().Trim()).ToString("F2") + "/" + double.Parse(reader2["L18"].ToString().Trim()).ToString("F2"); this.BKTable.Rows[1].Cells[2].InnerText = double.Parse(reader2["W19"].ToString().Trim()).ToString("F2") + "/" + double.Parse(reader2["L19"].ToString().Trim()).ToString("F2"); this.BKTable.Rows[1].Cells[3].InnerText = double.Parse(reader2["W20"].ToString().Trim()).ToString("F2") + "/" + double.Parse(reader2["L20"].ToString().Trim()).ToString("F2"); this.BKTable.Rows[1].Cells[4].InnerText = reader2["W21"].ToString().Trim() + "/" + reader2["L21"].ToString().Trim(); this.BKTable.Rows[1].Cells[5].InnerText = double.Parse(reader2["W22"].ToString().Trim()).ToString("F2") + "/" + double.Parse(reader2["L22"].ToString().Trim()).ToString("F2"); this.BKTable.Rows[1].Cells[6].InnerText = double.Parse(reader2["W23"].ToString().Trim()).ToString("F2") + "/" + double.Parse(reader2["L23"].ToString().Trim()).ToString("F2"); this.footballsettable.Rows[4].Cells[1].InnerHtml = "<a href=\"#\" onClick=\"show_win('特别号','dsrq','" + reader2["MAXC1"].ToString() + "','" + reader2["MAXZ1"].ToString().Trim() + "'," + reader2["W1"].ToString().Trim() + "," + reader2["L1"].ToString().Trim() + ",0.25," + text + "," + text24 + ",'FT');\">修改</a>"; this.footballsettable.Rows[4].Cells[2].InnerHtml = "<a href=\"#\" onClick=\"show_win('特别号单双','dsdx','" + reader2["MAXC2"].ToString() + "','" + reader2["MAXZ2"].ToString().Trim() + "'," + reader2["W2"].ToString().Trim() + "," + reader2["L2"].ToString().Trim() + ",0.25," + text2 + "," + text25 + ",'FT');\">修改</a>"; this.footballsettable.Rows[4].Cells[3].InnerHtml = "<a href=\"#\" onClick=\"show_win('特别号大小','zdrq','" + reader2["MAXC3"].ToString() + "','" + reader2["MAXZ3"].ToString().Trim() + "'," + reader2["W3"].ToString().Trim() + "," + reader2["L3"].ToString().Trim() + ",0.25," + text3 + "," + text26 + ",'FT');\">修改</a>"; this.footballsettable.Rows[4].Cells[4].InnerHtml = "<a href=\"#\" onClick=\"show_win('特别号合数单双','zddx','" + reader2["MAXC4"].ToString() + "','" + reader2["MAXZ4"].ToString().Trim() + "'," + reader2["W4"].ToString().Trim() + "," + reader2["L4"].ToString().Trim() + ",0.25," + text4 + "," + text27 + ",'FT');\">修改</a>"; this.footballsettable.Rows[4].Cells[5].InnerHtml = "<a href=\"#\" onClick=\"show_win('正码','28','" + reader2["MAXC28"].ToString() + "','" + reader2["MAXZ28"].ToString().Trim() + "'," + reader2["W28"].ToString().Trim() + "," + reader2["L28"].ToString().Trim() + ",0.25," + text23 + "," + text46 + ",'FT');\">修改</a>"; this.footballsettable.Rows[4].Cells[6].InnerHtml = "<a href=\"#\" onClick=\"show_win('总和单双','ds','" + reader2["MAXC5"].ToString() + "','" + reader2["MAXZ5"].ToString().Trim() + "'," + reader2["W5"].ToString().Trim() + "," + reader2["L5"].ToString().Trim() + ",0.25," + text5 + "," + text28 + ",'FT');\">修改</a>"; this.footballsettable.Rows[4].Cells[7].InnerHtml = "<a href=\"#\" onClick=\"show_win('总和大小','bz','" + reader2["MAXC6"].ToString() + "','" + reader2["MAXZ6"].ToString().Trim() + "'," + reader2["W6"].ToString().Trim() + "," + reader2["L6"].ToString().Trim() + ",0.25," + text6 + "," + text29 + ",'FT');\">修改</a>"; this.footballsettable.Rows[4].Cells[8].InnerHtml = "<a href=\"#\" onClick=\"show_win('二全中','bzgg','" + reader2["MAXC7"].ToString() + "','" + reader2["MAXZ7"].ToString().Trim() + "'," + reader2["W7"].ToString().Trim() + "," + reader2["L7"].ToString().Trim() + ",0.25," + text7 + "," + text30 + ",'FT');\">修改</a>"; this.footballsettable.Rows[4].Cells[9].InnerHtml = "<a href=\"#\" onClick=\"show_win('三全中','rqgg','" + reader2["MAXC8"].ToString() + "','" + reader2["MAXZ8"].ToString().Trim() + "'," + reader2["W8"].ToString().Trim() + "," + reader2["L8"].ToString().Trim() + ",0.25," + text8 + "," + text31 + ",'FT');\">修改</a>"; this.footballsettable.Rows[4].Cells[10].InnerHtml = "<a href=\"#\" onClick=\"show_win('三中二','bdtz','" + reader2["MAXC9"].ToString() + "','" + reader2["MAXZ9"].ToString().Trim() + "'," + reader2["W9"].ToString().Trim() + "," + reader2["L9"].ToString().Trim() + ",0.25," + text9 + "," + text32 + ",'FT');\">修改</a>"; this.footballsettable.Rows[4].Cells[11].InnerHtml = "<a href=\"#\" onClick=\"show_win('二中特','zrq','" + reader2["MAXC10"].ToString() + "','" + reader2["MAXZ10"].ToString().Trim() + "'," + reader2["W10"].ToString().Trim() + "," + reader2["L10"].ToString().Trim() + ",0.25," + text10 + "," + text33 + ",'FT');\">修改</a>"; this.footballsettable.Rows[4].Cells[12].InnerHtml = "<a href=\"#\" onClick=\"show_win('特串','bqc','" + reader2["MAXC11"].ToString() + "','" + reader2["MAXZ11"].ToString().Trim() + "'," + reader2["W11"].ToString().Trim() + "," + reader2["L11"].ToString().Trim() + ",0.25," + text11 + "," + text34 + ",'FT');\">修改</a>"; this.footballsettable.Rows[4].Cells[13].InnerHtml = "<a href=\"#\" onClick=\"show_win('正码过关','rqsbc','" + reader2["MAXC12"].ToString() + "','" + reader2["MAXZ12"].ToString().Trim() + "'," + reader2["W12"].ToString().Trim() + "," + reader2["L12"].ToString().Trim() + ",0.25," + text12 + "," + text35 + ",'FT');\">修改</a>"; this.footballsettable.Rows[4].Cells[14].InnerHtml = "<a href=\"#\" onClick=\"show_win('色波','dxsbc','" + reader2["MAXC13"].ToString() + "','" + reader2["MAXZ13"].ToString().Trim() + "'," + reader2["W13"].ToString().Trim() + "," + reader2["L13"].ToString().Trim() + ",0.25," + text13 + "," + text36 + ",'FT');\">修改</a>"; this.BKTable.Rows[4].Cells[1].InnerHtml = "<span style=\"CURSOR:hand\" onclick=\"show_win('生肖','18','" + reader2["MAXC18"].ToString().Trim() + "','" + reader2["MAXZ18"].ToString().Trim() + "','" + reader2["W18"].ToString().Trim() + "','" + reader2["L18"].ToString().Trim() + "',0.25," + text16 + "," + text39 + ");\">修改</span>"; this.BKTable.Rows[4].Cells[2].InnerHtml = "<span style=\"CURSOR:hand\" onclick=\"show_win('正码1-6单双','19','" + reader2["MAXC19"].ToString().Trim() + "','" + reader2["MAXZ19"].ToString().Trim() + "','" + reader2["W19"].ToString().Trim() + "','" + reader2["L19"].ToString().Trim() + "',0.25," + text17 + "," + text40 + ");\">修改</span>"; this.BKTable.Rows[4].Cells[3].InnerHtml = "<span style=\"CURSOR:hand\" onclick=\"show_win('正码1-6大小','20','" + reader2["MAXC20"].ToString().Trim() + "','" + reader2["MAXZ20"].ToString().Trim() + "','" + reader2["W20"].ToString().Trim() + "','" + reader2["L20"].ToString().Trim() + "',0.25," + text18 + "," + text41 + ");\">修改</span>"; this.BKTable.Rows[4].Cells[4].InnerHtml = "<span style=\"CURSOR:hand\" onclick=\"show_win('正码1-6色波','21','" + reader2["MAXC21"].ToString().Trim() + "','" + reader2["MAXZ21"].ToString().Trim() + "','" + reader2["W21"].ToString().Trim() + "','" + reader2["L21"].ToString().Trim() + "',1," + text19 + "," + text42 + ");\">修改</span>"; this.BKTable.Rows[4].Cells[5].InnerHtml = "<span style=\"CURSOR:hand\" onclick=\"show_win('一肖','22','" + reader2["MAXC22"].ToString().Trim() + "','" + reader2["MAXZ22"].ToString().Trim() + "','" + reader2["W22"].ToString().Trim() + "','" + reader2["L22"].ToString().Trim() + "',0.25," + text20 + "," + text43 + ");\">修改</span>"; this.BKTable.Rows[4].Cells[6].InnerHtml = "<span style=\"CURSOR:hand\" onclick=\"show_win('六肖','23','" + reader2["MAXC23"].ToString().Trim() + "','" + reader2["MAXZ23"].ToString().Trim() + "','" + reader2["W23"].ToString().Trim() + "','" + reader2["L23"].ToString().Trim() + "',0.25," + text21 + "," + text44 + ");\">修改</span>"; } reader2.Close(); base2.CloseConnect(); base2.Dispose(); }
private void Deal(string flag) { int curpage; int start; string text = ""; string sql = ""; string text3 = ""; int num = 0; double num2 = 0; double num3 = 0; if (flag == "all") { sql = "SELECT convert(numeric(5,2),od.hsuser_w) as hsuser_w,convert(numeric(5,2),od.hsuser_l) as hsuser_l,dbo.GettzType_Func(od.tzType) as tzTypeName,od.tzType as tzType,od.updatetime as updatetime,od.username as username,od.content as content,od.tzmoney as tzmoney,isnull((od.win-od.lose),0) as result,od.abc as abc,od.iscancel as iscancel FROM ball_order as od inner join member as mb on od.userid = mb.userid where od.gdid in (" + this.Session.Contents["adminarrgd"].ToString().Trim() + "-1) and od.isjs = 0 and od.iscancel = 0 and datediff(day,'" + DateTime.Today.ToShortDateString() + "',od.updatetime) = 0"; text3 = "select count(*) from ball_order where gdid in (" + this.Session.Contents["adminarrgd"].ToString().Trim() + "-1) and isjs = 0 and iscancel = 0 and datediff(day,'" + DateTime.Today.ToShortDateString() + "',updatetime) = 0"; } else { sql = "SELECT convert(numeric(5,2),od.hsuser_w) as hsuser_w,convert(numeric(5,2),od.hsuser_l) as hsuser_l,dbo.GettzType_Func(od.tzType) as tzTypeName,od.tzType as tzType,od.updatetime as updatetime,od.username as username,od.content as content,od.tzmoney as tzmoney,isnull((od.win-od.lose),0) as result,od.abc as abc,od.iscancel as iscancel FROM ball_order as od inner join member as mb on od.userid = mb.userid where od.gdid in (" + this.Session.Contents["adminarrgd"].ToString().Trim() + "-1) and od.tztype='1' AND od.isjs = 0 and od.iscancel = 0 and datediff(day,'" + DateTime.Today.ToShortDateString() + "',od.updatetime) = 0"; text3 = "select count(*) from ball_order where gdid in (" + this.Session.Contents["adminarrgd"].ToString().Trim() + "-1) and tztype='1' AND isjs = 0 and iscancel = 0 and datediff(day,'" + DateTime.Today.ToShortDateString() + "',updatetime) = 0"; } DataBase base2 = new DataBase(MyFunc.GetConnStr(2)); text = "<table border=0 cellspacing=1 cellpadding=0 class=tableNoBorder1 width=100%>\n"; text = text + "<tr class=dlsreport1><td width=10%>时间</td><td width=15%>会员(win/lose)</td><td width=10%>投注方式</td><td width=35%>详情</td><td width=15%>投注额</td><td width=15%>结果</td></tr>\n"; int pagesize = 100; try { curpage = int.Parse(this.selectpage.Value); } catch { curpage = 1; } if (curpage < 1) { curpage = 1; } int totalrecord = int.Parse(base2.ExecuteScalar(text3).ToString()); if (totalrecord == 0) { start = 0; } else { if (((curpage - 1) * pagesize) >= totalrecord) { curpage = 1; } start = (curpage - 1) * pagesize; } DataSet set = base2.ExecuteDataSet(sql, start, pagesize, "ball_order"); for (int i = 0; i < set.Tables[0].Rows.Count; i++) { num++; string text4 = (((text + "<tr bgcolor=white align=right height=22>") + "<td align=center>" + DateTime.Parse(set.Tables[0].Rows[i]["updatetime"].ToString().Trim()).ToString("yyyy-MM-dd HH:mm:ss").ToUpper().Replace(" ", "<br>") + "</td>") + "<td align=center nowrap><table border=0 cellspacing=0 cellpadding=0><tr><td><font color=red>" + set.Tables[0].Rows[i]["abc"].ToString() + "</font> </td>") + "<td align=center nowrap> " + set.Tables[0].Rows[i]["username"].ToString() + " </td>"; text = (((text4 + "<td nowrap> <font color=red>" + set.Tables[0].Rows[i]["hsuser_w"].ToString() + "</font>/<font color=red>" + set.Tables[0].Rows[i]["hsuser_l"].ToString() + "</font></td></tr></table></td>") + "<td align=center>" + set.Tables[0].Rows[i]["tzTypeName"].ToString() + "</td>") + "<td>" + set.Tables[0].Rows[i]["content"].ToString() + "</td>") + "<td>" + Convert.ToDouble(set.Tables[0].Rows[i]["tzmoney"]).ToString() + "</td>"; if (set.Tables[0].Rows[i]["iscancel"].ToString().ToLower() == "true") { text = text + "<td><font color='red'>取消</font></td>"; } else { text = text + "<td>" + MyFunc.NumBerFormat(set.Tables[0].Rows[i]["result"].ToString()) + "</td>"; } text = text + "</tr>\n"; num2 += double.Parse(set.Tables[0].Rows[i]["tzmoney"].ToString()); num3 += double.Parse(set.Tables[0].Rows[i]["result"].ToString()); } set.Clear(); base2.Dispose(); this.setselectpageproc(pagesize, totalrecord, curpage); text = (((((((((((text + "<tr align=right height=22 class=reportTotalnum><td colspan=3> </td>") + "<td>" + num.ToString() + "</td>") + "<td>" + num2.ToString() + "</td>") + "<td>" + MyFunc.NumBerFormat(num3.ToString()) + "</td></tr>") + "</table>\n" + "<table border=0 cellspacing=0 cellpadding=0 width=100% bgcolor=#eeeeee>\n") + "<tr><td width=100% height=12></td></tr>\n</table>\n" + "<table border=0 cellspacing=1 cellpadding=0 class=tableNoBorder1 width=100%>\n") + "<tr class=dlsreport1><td width=10%>会员</td><td width=15%>笔数</td><td width=15%>金额</td><td width=15%>会员</td><td width=15%>代理商金额</td><td width=15%>代理商</td><td width=15%>成数</td></tr>\n" + "<tr class=reportTotalnum align=right height=22><td> </td>") + "<td>" + num.ToString() + "</td>") + "<td>" + num2.ToString() + "</td>") + "<td>" + MyFunc.NumBerFormat(num3.ToString()) + "</td>") + "<td> </td>") + "<td>0.00</td>" + "<td>0.0</td></tr></table>"; this.tableContent.Rows[0].Cells[0].InnerHtml = text; }