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 Page_Load(object sender, EventArgs e) { MyFunc.isRefUrl(); if (!MyFunc.CheckUserLogin(0) || !MyTeam.OnlineList.OnlineList.isUserLogin(0)) { MyFunc.goToLoginPage(); base.Response.End(); } else if (!base.IsPostBack) { DataBase db = new DataBase(MyFunc.GetConnStr(2)); SqlDataReader reader = db.ExecuteReader("SELECT convert(nvarchar,updatetime,11) as updatetime,content FROM affiche WHERE le=1 ORDER BY updatetime DESC"); SqlDataReader reader2 = null; int num = 0; double num2 = 0; string text = ""; this.msg = "<div class=hover>"; while (reader.Read()) { this.msg = this.msg + reader["content"].ToString().Trim(); } this.msg = this.msg + "</div>"; reader.Close(); string text2 = db.ExecuteScalar("SELECT ISNULL(jsdatetime,'') FROM member WHERE userid=" + this.Session.Contents["userid"].ToString().Trim()).ToString().Trim(); double num3 = 0; double num4 = 0; reader2 = db.ExecuteReader("SELECT top 1 * FROM ball_bf1 ORDER BY balltime DESC"); if (reader2.Read()) { DateTime time = Convert.ToDateTime(reader2["balltime"].ToString().Trim()); TimeSpan span = DateTime.Now.Subtract(time); num = ((span.Days * 0x5a0) + (span.Hours * 60)) + span.Minutes; text = reader2["qishu"].ToString().Trim(); } reader2.Close(); string s = ""; string text4 = ""; string text5 = ""; string text6 = ""; string text7 = ""; DataSet set = db.ExecuteDataSet("select * from ball_bf1 where ballid in (select top 3 ballid from ball_bf1 order by ballid desc) order by ballid"); for (int i = 0; i < 3; i++) { s = set.Tables[0].Rows[i]["balltime"].ToString().Trim().Split(new char[] { ' ' })[0].ToString(); text4 = s.Split(new char[] { '-' })[0].ToString(); text6 = s.Split(new char[] { '-' })[1].ToString(); text5 = s.Split(new char[] { '-' })[2].ToString(); text7 = MyFunc.DayToWeek(DateTime.Parse(s)); string sql = "SELECT COUNT(1) AS tzcount, ISNULL(SUM(tzmoney),0) AS tzmoney,ISNULL(SUM(ROUND(win-lose,2)),0) AS result FROM ball_order WHERE DateDiff(day,balltime,'" + s + "')=0 AND isjs=1 AND userid=" + this.Session.Contents["userid"].ToString().Trim(); if (text2 != "") { sql = sql + " AND updatetime>'" + text2 + "'"; } reader2 = db.ExecuteReader(sql); reader2.Read(); double num6 = Math.Round(double.Parse(reader2["tzmoney"].ToString()), 2); double num7 = Math.Round(double.Parse(reader2["result"].ToString()), 2); this.kyglList = this.kyglList + "<TR class=\"b_rig\"><TD class=\"b_fwn\">"; if (int.Parse(text5) < 10) { text5 = "0" + text5; } if (int.Parse(text6) < 10) { text6 = "0" + text6; } if (int.Parse(reader2["tzcount"].ToString().Trim()) != 0) { string kyglList = this.kyglList; this.kyglList = kyglList + "<a href=bets-enquiry.aspx?date=" + s + "><font color=#CC0000>" + text6 + "-" + text5 + " " + text7 + "</font></a>"; } else { string text10 = this.kyglList; this.kyglList = text10 + "<font color=#CC0000>" + text6 + "-" + text5 + " " + text7 + "</font>"; } reader2.Close(); num2 = 0; num2 = double.Parse(MyFunc.usermsg(this.Session.Contents["userid"].ToString().Trim(), db, "0")[2].ToString()) - num6; num3 += num6; num4 += num7; object obj2 = this.kyglList; this.kyglList = string.Concat(new object[] { obj2, "</TD><TD class='tdR'>", set.Tables[0].Rows[i]["qishu"].ToString().Trim(), "</td><TD class='tdR'>", num6, "</TD><TD class='tdR'>", num7, "</TD><TD class='tdR'>", num2, "</TD></TR>" }); } db.Dispose(); string text11 = this.kyglList; this.kyglList = text11 + "<TR style='BACKGROUND-COLOR: #e9e9e9' class=\"b_rig\"><TD class=\"b_fwn\" >小计</TD><td class='list_rig'></td><TD class='list_rig' bgColor='lightyellow'><B style='FONT-SIZE: 14px; COLOR: brown'>" + num3.ToString("F2") + "</B></TD><TD class='list_rig' bgColor='lightyellow'><B style='FONT-SIZE: 14px; COLOR: brown'>" + num4.ToString("F2") + "</B></TD><td bgColor=#990000><FONT color=#ffffff></FONT></td></TR>"; this.DataBind(); } }
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.Request.Params["MySelDate"] == null) { if (this.Session.Contents["basketthisDay"] == null) { this.Session.Contents["basketthisDay"] = DateTime.Today.ToShortDateString(); } } else { this.Session.Contents["basketthisDay"] = base.Request.Params["MySelDate"]; } this.selday = this.Session.Contents["basketthisDay"].ToString(); if (!base.IsPostBack) { for (int i = 0; i < 7; i++) { this.SelectDay.Items.Add(new ListItem(DateTime.Today.AddDays((double)-i).ToShortDateString() + " " + MyFunc.DayToWeek(DateTime.Today.AddDays((double)-i)), DateTime.Today.AddDays((double)-i).ToShortDateString())); } } this.FillDataGrid(this.selday); this.DataGrid1.DataBind(); } }
private void Page_Load(object sender, EventArgs e) { if (((this.Session.Contents["classid"] != null) && (this.Session.Contents["classid"].ToString().Trim() != "1")) && (this.Session.Contents["classid"].ToString().Trim() != "2")) { MyFunc.goToLoginPage(); base.Response.End(); } else if ((this.Session.Contents["adminclassid"] != null) && (this.Session.Contents["adminclassid"].ToString().Trim() != "5")) { MyFunc.goToLoginPage(); base.Response.End(); } else if ((this.Session.Contents["classid"] == null) && (this.Session.Contents["adminclassid"] == null)) { MyFunc.goToLoginPage(); base.Response.End(); } else if (!base.IsPostBack) { if (((base.Request.QueryString["action"] != null) && (base.Request.QueryString["action"].ToString().Trim() == "open")) && ((base.Request.QueryString["ballid"] != null) && (base.Request.QueryString["ballid"].ToString().Trim() != ""))) { this.BallCancel(base.Request.QueryString["ballid"].ToString().Trim(), 0); } else if (((base.Request.QueryString["action"] != null) && (base.Request.QueryString["action"].ToString().Trim() == "close")) && ((base.Request.QueryString["ballid"] != null) && (base.Request.QueryString["ballid"].ToString().Trim() != ""))) { this.BallCancel(base.Request.QueryString["ballid"].ToString().Trim(), 1); } else if (((base.Request.QueryString["action"] != null) && (base.Request.QueryString["action"].ToString().Trim() == "open1")) && ((base.Request.QueryString["ballid"] != null) && (base.Request.QueryString["ballid"].ToString().Trim() != ""))) { this.BallCancel1(base.Request.QueryString["ballid"].ToString().Trim(), 0); } else if (((base.Request.QueryString["action"] != null) && (base.Request.QueryString["action"].ToString().Trim() == "close1")) && ((base.Request.QueryString["ballid"] != null) && (base.Request.QueryString["ballid"].ToString().Trim() != ""))) { this.BallCancel1(base.Request.QueryString["ballid"].ToString().Trim(), 1); } else if (((((base.Request.Form["action"] != null) && (base.Request.Form["action"].ToString().Trim() == "ffpost")) && ((base.Request.Form["ballid"] != null) && (base.Request.Form["ballid"].ToString().Trim() != ""))) && (((base.Request.Form["btype"] != null) && (base.Request.Form["btype"].ToString().Trim() != "")) && ((base.Request.Form["bf1"] != null) && (base.Request.Form["bf1"].ToString().Trim() != "")))) && ((base.Request.Form["bf2"] != null) && (base.Request.Form["bf2"].ToString().Trim() != ""))) { this.UpdateBf(base.Request.Form["ballid"].ToString().Trim(), base.Request.Form["btype"].ToString().Trim(), base.Request.Form["bf1"].ToString().Trim(), base.Request.Form["bf2"].ToString().Trim()); } for (int i = 0; i < 7; i++) { this.SelectDay.Items.Add(new ListItem(DateTime.Today.AddDays((double)-i).ToShortDateString() + " " + MyFunc.DayToWeek(DateTime.Today.AddDays((double)-i)), DateTime.Today.AddDays((double)-i).ToShortDateString())); } this.kyglSelDay = this.SelectDay.Items[0].Value; if ((base.Request.QueryString["selday"] != null) && (base.Request.QueryString["selday"].ToString().Trim() != "")) { this.SelectDay.SelectedValue = base.Request.QueryString["selday"].ToString().Trim(); this.kyglSelDay = base.Request.QueryString["selday"].ToString().Trim(); } if ((base.Request.Form["selday"] != null) && (base.Request.Form["selday"].ToString().Trim() != "")) { this.SelectDay.SelectedValue = base.Request.Form["selday"].ToString().Trim(); this.kyglSelDay = base.Request.Form["selday"].ToString().Trim(); } this.kyglContent = this.GameList(this.kyglSelDay); this.DataBind(); } }
private void Page_Load(object sender, EventArgs e) { MyFunc.isRefUrl(); if (!MyFunc.CheckUserLogin(0) || ((this.Session.Contents["classid"].ToString().Trim() != "1") && (this.Session.Contents["classid"].ToString().Trim() != "2"))) { MyFunc.goToLoginPage(); base.Response.End(); } else if (!base.IsPostBack) { for (int i = 0; i < 7; i++) { this.SelectDay.Items.Add(new ListItem(DateTime.Today.AddDays((double)-i).ToShortDateString() + " " + MyFunc.DayToWeek(DateTime.Today.AddDays((double)-i)), DateTime.Today.AddDays((double)-i).ToShortDateString())); } this.kyglSelDay = this.SelectDay.Items[0].Value; if ((base.Request.Form["selday"] != null) && (base.Request.Form["selday"].ToString().Trim() != "")) { this.SelectDay.SelectedValue = base.Request.Form["selday"].ToString().Trim(); this.kyglSelDay = base.Request.Form["selday"].ToString().Trim(); } this.kyglContent = this.GameList(this.kyglSelDay); this.DataBind(); } }