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 PrintBarTitle()
{
if ((this.Session.Contents["adminsubid"] != null) && (this.Session.Contents["adminsubid"].ToString() != ""))
{
this.tableBarMenu.Rows[0].Cells[0].InnerHtml = " 管理员子帐户:" + this.Session.Contents["adminsubname"].ToString() + " 日期区间:" + this.startTime + "~~" + this.endTime + " -- 报表:" + this.GetReportType(this.reportType) + " -- 信用/现金:" + this.GettzCaseName(this.tzCase) + " -- 方式:" + MyFunc.GettzTypeName(this.tzType) + " -- <a href='javascript:window.history.back();'>返回</a>";
}
else
{
this.tableBarMenu.Rows[0].Cells[0].InnerHtml = " 管理员:" + this.Session.Contents["adminusername"].ToString() + " 日期区间:" + this.startTime + "~~" + this.endTime + " -- 报表:" + this.GetReportType(this.reportType) + " -- 信用/现金:" + this.GettzCaseName(this.tzCase) + " -- 方式:" + MyFunc.GettzTypeName(this.tzType) + " -- <a href='javascript:window.history.back();'>返回</a>";
}
}
private void Page_Load(object sender, EventArgs e)
{
MyFunc.isRefUrl();
if (!MyFunc.CheckUserLogin(1) || !MyTeam.OnlineList.OnlineList.isUserLogin(1))
{
MyFunc.goToLoginPage();
base.Response.End();
}
else if (!base.IsPostBack)
{
DateTime now = DateTime.Now;
this.datetime = now.Year.ToString() + "-" + now.Month.ToString() + "-" + now.Day.ToString();
string sql = "";
string text2 = "";
text2 = MyFunc.GetConnStr(2).ToLower();
text2 = text2.Substring(text2.IndexOf("catalog=", 0) + 8, (text2.IndexOf(";user", 0) - text2.IndexOf("catalog=", 0)) - 8);
this.kyglName = this.Session.Contents["adminusername"].ToString().Trim();
if ((base.Request.QueryString["date"] != null) && (base.Request.QueryString["date"].ToString().Trim() != ""))
{
this.kyglTT = "结果";
try
{
DateTime.Parse(base.Request.QueryString["date"].ToString().Trim());
}
catch
{
return;
}
sql = "SELECT updatetime,tztype,orderid,content,tzmoney,(win-lose) AS result,iscancel,isdanger,zdmoney,GetDate() as thisdatetime FROM ball_order2 WHERE userid=" + this.Session.Contents["adminuserid"].ToString().Trim() + " AND datediff(day,balltime,'" + base.Request.QueryString["date"].ToString().Trim() + "')=0 AND isjs=1 ORDER BY updatetime DESC";
}
else
{
this.kyglTT = "可嬴金额";
sql = "SELECT updatetime,tztype,orderid,content,tzmoney,(tzmoney*curpl) AS result,iscancel,isdanger,zdmoney,GetDate() as thisdatetime FROM ball_order2 WHERE userid=" + this.Session.Contents["adminuserid"].ToString().Trim() + " AND isjs=0 ORDER BY updatetime DESC";
}
DataBase base2 = new DataBase(MyFunc.GetConnStr(2));
SqlDataReader reader = base2.ExecuteReader("SELECT convert(nvarchar,updatetime,11) as updatetime,content FROM affiche WHERE le=1 ORDER BY updatetime DESC");
this.msg = "<div class=hover>";
while (reader.Read())
{
this.msg = this.msg + reader["content"].ToString().Trim();
}
this.msg = this.msg + "</div>";
reader.Close();
SqlDataReader reader2 = base2.ExecuteReader(sql);
double num = 0;
double num2 = 0;
for (int i = 1; reader2.Read(); i++)
{
double num4 = Math.Round(double.Parse(reader2["tzmoney"].ToString().Trim()), 2);
double num5 = Math.Round(double.Parse(reader2["result"].ToString().Trim()), 2);
string kyglList = this.kyglList;
this.kyglList = kyglList + "<TR><td style='text-align:center'>" + reader2["updatetime"].ToString().Trim() + "</td><TD>" + reader2["orderid"].ToString().Trim() + "</TD><TD style=\"TEXT-ALIGN: center\">" + MyFunc.GettzTypeName(reader2["tztype"].ToString().Trim());
this.kyglList = this.kyglList + "</TD>";
this.kyglList = this.kyglList + "<TD class='details' noWrap style=\"TEXT-ALIGN: right\">" + reader2["content"].ToString().Trim() + "</TD>";
if ((reader2["isdanger"].ToString().Trim() == "2") || (num4 == 0))
{
this.kyglList = this.kyglList + "<TD class='tdR'><font color=red>-</font></TD><TD class='tdR'>";
}
else
{
this.kyglList = this.kyglList + "<TD class='tdR'>" + num4.ToString("F0") + "</TD><TD class='tdR'>";
}
if ((ConfigurationSettings.AppSettings["UserDanger"] == "1") && (reader2["isdanger"].ToString().Trim() == "2"))
{
this.kyglList = this.kyglList + "<br><font color=red>危险球<br>取消</font>";
}
else if (reader2["iscancel"].ToString().Trim().ToUpper() == "TRUE")
{
this.kyglList = this.kyglList + "<font color=red>取消</font>";
}
else
{
this.kyglList = this.kyglList + num5;
num += num4;
num2 += num5;
}
this.kyglList = this.kyglList + "</TD></TR>";
}
reader2.Close();
base2.Dispose();
this.kyglList = this.kyglList + "<TR style='BACKGROUND-COLOR: #e9e9e9'><TD class='tdR' colSpan='4'><IMG src='../user/images/print.gif' border='0'> <A href='javascript:window.print()'> 打印</A> </TD>";
object obj2 = this.kyglList;
this.kyglList = string.Concat(new object[] { obj2, "<TD class='tdR' style='VERTICAL-ALIGN: middle' bgColor='lightyellow'><B style='FONT-SIZE: 14px; COLOR: brown'>", num, "</B> </TD>" });
this.kyglList = this.kyglList + "<TD class='tdR' style='VERTICAL-ALIGN: middle' bgColor='lightyellow'><B style='FONT-SIZE: 14px; COLOR: brown'>" + num2.ToString("F2") + "</B> </TD></TR>";
this.DataBind();
}
}
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 string MatchList()
{
string text = "";
DataBase db = new DataBase(MyFunc.GetConnStr(2));
if ((base.Request.QueryString["action"] != null) && (base.Request.QueryString["action"].ToString().Trim() == "del"))
{
this.delall();
}
for (int i = 1; i < 0x16; i++)
{
string s = this.nojs(i.ToString(), db, "false");
string text3 = this.allorder(i.ToString(), db, "false");
if (((base.Request.QueryString["action"] == null) || (base.Request.QueryString["action"].ToString().Trim() != "no")) || (s != "0"))
{
string text5 = text;
string[] textArray = new string[] { text5, "<tr><td bgcolor=#ffffff>", MyFunc.GettzTypeName(i.ToString()), "</td><td align=center bgcolor=#ffffff>", text3, "</td><td align=center bgcolor=#ffffff>", (int.Parse(text3) - int.Parse(s)).ToString(), "</td>" };
text = string.Concat(textArray);
if (s != "0")
{
text = text + "<td align=center bgcolor=red>" + s + "</td>";
}
else
{
text = text + "<td align=center bgcolor=#ffffff>" + s + "</td>";
}
object obj2 = text;
text = string.Concat(new object[] { obj2, "<td bgcolor=#ffffff align=center><a href=BallJs.aspx?action=kygl&jstype=", i, "&ballid=0>结算</a></td></tr>" });
}
}
db.Dispose();
return(text);
}
private void Page_Load(object sender, EventArgs e)
{
MyFunc.isRefUrl();
if (!MyFunc.CheckUserLogin(1) || !MyTeam.OnlineList.OnlineList.isUserLogin(1))
{
MyFunc.goToLoginPage("../");
base.Response.End();
}
else if (!base.IsPostBack)
{
if (((base.Request.QueryString["userid"] != null) && (base.Request.QueryString["userid"].ToString().Trim() != "")) && ((base.Request.QueryString["flag"] != null) && (base.Request.QueryString["flag"].ToString().Trim() != "")))
{
string text = base.Request.QueryString["userid"].ToString().Trim().Replace(" ", "").Replace("'", "");
string text2 = base.Request.QueryString["flag"].ToString().Trim().Replace(" ", "").Replace("'", "");
DataBase base2 = new DataBase(MyFunc.GetConnStr(2));
double num = double.Parse(base2.ExecuteScalar("SELECT SUM(tzmoney) FROM ball_order WHERE userid=" + text + " AND Datediff(day,balltime,GetDate())=0").ToString());
SqlDataReader reader = base2.ExecuteReader("SELECT userid,username,usemoney,curmoney,(usemoney-curmoney) AS smoney FROM member WHERE userid=" + text);
reader.Read();
this.kyglContent1 = "会员 <a href=../userlist_reportlist.aspx?userid=" + reader["userid"].ToString().Trim() + "&username="******"username"].ToString().Trim() + ">" + reader["username"].ToString().Trim() + "</a> 总信用度 " + reader["usemoney"].ToString().Trim() + " 下注 " + reader["smoney"].ToString().Trim() + " 余额 " + reader["curmoney"].ToString().Trim() + " ";
this.kyglContent1 = this.kyglContent1 + ((text2 == "1") ? "正常" : string.Concat(new string[5]));
reader.Close();
reader = base2.ExecuteReader("SELECT orderid,updatetime,balltime,content,tztype,tzmoney,ISNULL((win-lose),0) as tzresult,iscancel FROM ball_order WHERE userid=" + text + " AND datediff(day,balltime,GetDate())=0 AND isjs=1 ORDER BY updatetime");
double num2 = 0;
double num3 = 0;
while (reader.Read())
{
double num4 = double.Parse(reader["tzresult"].ToString().Trim());
num3 += num4;
double num5 = double.Parse(reader["tzmoney"].ToString().Trim());
num2 += num5;
string text3 = this.kyglContent2;
this.kyglContent2 = text3 + "<tr bgcolor=#ffffff><td align=center>" + DateTime.Parse(reader["updatetime"].ToString()).ToString("yy-MM-dd<br>HH:mm:ss") + "</td><td align=center>" + MyFunc.GettzTypeName(reader["tztype"].ToString().Trim()) + "<br>" + reader["orderid"].ToString().Trim() + "</td><td align=right>" + reader["content"].ToString().Trim() + "</td><td align=right>" + num5.ToString("F0") + "</td>";
if ((reader["iscancel"].ToString().Trim().ToUpper() == "TRUE") && (num5 == 0))
{
this.kyglContent2 = this.kyglContent2 + "<td align=center><font color=red>危险球<br>取消</font></td></tr>";
}
else
{
if (reader["iscancel"].ToString().Trim().ToUpper() == "TRUE")
{
this.kyglContent2 = this.kyglContent2 + "<td align=center><font color=red>取消</font></td></tr>";
continue;
}
this.kyglContent2 = this.kyglContent2 + "<td align=right>" + num4.ToString("F2") + "</td></tr>";
}
}
reader.Close();
string text4 = this.kyglContent2;
this.kyglContent2 = text4 + "<tr class=sum bgcolor=#ffffff><td> </td><td> </td><td> </td><td>" + num2.ToString("F0") + "</td><td>" + num3.ToString("F2") + "</td></tr>";
reader = base2.ExecuteReader("SELECT orderid,updatetime,balltime,content,tztype,tzmoney,ISNULL(tzmoney*curpl,0) as tzresult,iscancel FROM ball_order WHERE userid=" + text + " AND datediff(day,balltime,GetDate())=0 AND isjs=0 ORDER BY updatetime");
double num6 = 0;
double num7 = 0;
while (reader.Read())
{
double num8 = double.Parse(reader["tzresult"].ToString().Trim());
num7 += num8;
double num9 = double.Parse(reader["tzmoney"].ToString().Trim());
num6 += num9;
string text5 = this.kyglContent3;
this.kyglContent3 = text5 + "<tr bgcolor=#ffffff><td align=center>" + DateTime.Parse(reader["updatetime"].ToString()).ToString("yy-MM-dd<br>HH:mm:ss") + "</td><td align=center>" + MyFunc.GettzTypeName(reader["tztype"].ToString().Trim()) + "<br>" + reader["orderid"].ToString().Trim() + "</td><td align=right>" + reader["content"].ToString().Trim() + "</td><td align=right>" + num9.ToString("F0") + "</td>";
if ((reader["iscancel"].ToString().Trim().ToUpper() == "TRUE") && (num9 == 0))
{
this.kyglContent3 = this.kyglContent3 + "<td align=center><font color=red>危险球<br>取消</font></td></tr>";
}
else
{
if (reader["iscancel"].ToString().Trim().ToUpper() == "TRUE")
{
this.kyglContent3 = this.kyglContent3 + "<td align=center><font color=red>取消</font></td></tr>";
continue;
}
this.kyglContent3 = this.kyglContent3 + "<td align=right>" + num8.ToString("F2") + "</td></tr>";
}
}
reader.Close();
string text6 = this.kyglContent3;
this.kyglContent3 = text6 + "<tr class=sum bgcolor=#ffffff><td> </td><td> </td><td> </td><td>" + num6.ToString("F0") + "</td><td>" + num7.ToString("F2") + "</td></tr>";
base2.Dispose();
}
this.DataBind();
}
}
