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