public ActionResult BettingFind(int id)
{
try
{
ViewBag.Title = "投注记录";
ViewBag.Title2 = "投注记录";
ViewBag.Page = "投注";
var betting = new DBC.Betting(id);
var user = new DBC.User(betting.UserID);
var current = GetCurrentUser();
if (user.ID == current.ID || user.Parent == current.ID)
{
var bettingList = new List <DBC.Betting>()
{
betting
};
ViewBag.list = GetBettingOverviewList(bettingList);
}
else
{
throw new Exception("无权查看");
}
}
catch
{
ViewBag.errorText = "未查询到任何记录";
}
return(View("betting"));
}
public ActionResult Betting(int?userid, int p = 0)
{
try
{
ViewBag.Title = "投注记录";
ViewBag.Title2 = "投注记录";
ViewBag.Page = "投注";
var currentUser = Session["user"] as DBC.User;
var pages = 1;
var sqlCount = "";
var sqlList = "";
var sqlCountArgs = new List <object>();
var sqlListArgs = new List <object>();
var current = GetCurrentUser();
sqlCount = string.Format("select count(*) from {0} where {0}.userid=?", DBTables.Betting, DBTables.User);
sqlCountArgs.Add(current.ID);
sqlList = string.Format("select id from {0} where {0}.userid=? order by time desc limit ?,?", DBTables.Betting, DBTables.User);
sqlListArgs.Add(current.ID);
//添加分页参数
sqlListArgs.Add(p * _itemsPerPage);
sqlListArgs.Add(_itemsPerPage);
var totalCount = Convert.ToInt32(DB.SExecuteScalar(sqlCount, sqlCountArgs.ToArray()));
pages = (int)Math.Ceiling(totalCount * 1.0 / _itemsPerPage);
var res = DB.SExecuteReader(sqlList, sqlListArgs.ToArray());
var bettingList = new List <DBC.Betting>();
foreach (var item in res)
{
//数据记录不完整时跳过
try
{
var id = Convert.ToInt32(item[0]);
var betting = new DBC.Betting(id);
bettingList.Add(betting);
}
catch { }
}
var pagination = new Pagination();
pagination.Pages = pages;
pagination.Current = p;
pagination.BaseUrl = "/home/betting";
ViewBag.pagination = pagination;
ViewBag.list = GetBettingOverviewList(bettingList);
}
catch
{
ViewBag.errorText = "未查询到任何记录";
}
return(View());
}
public ActionResult Betting(int? userid, int p = 0)
{
try
{
ViewBag.Title = "投注记录";
ViewBag.Title2 = "投注记录";
ViewBag.Page = "投注";
var currentUser = Session["user"] as DBC.User;
var pages = 1;
var sqlCount = "";
var sqlList = "";
var sqlCountArgs = new List<object>();
var sqlListArgs = new List<object>();
var current = GetCurrentUser();
sqlCount = string.Format("select count(*) from {0} where {0}.userid=?", DBTables.Betting, DBTables.User);
sqlCountArgs.Add(current.ID);
sqlList = string.Format("select id from {0} where {0}.userid=? order by time desc limit ?,?", DBTables.Betting, DBTables.User);
sqlListArgs.Add(current.ID);
//添加分页参数
sqlListArgs.Add(p * _itemsPerPage);
sqlListArgs.Add(_itemsPerPage);
var totalCount = Convert.ToInt32(DB.SExecuteScalar(sqlCount, sqlCountArgs.ToArray()));
pages = (int)Math.Ceiling(totalCount * 1.0 / _itemsPerPage);
var res = DB.SExecuteReader(sqlList, sqlListArgs.ToArray());
var bettingList = new List<DBC.Betting>();
foreach (var item in res)
{
//数据记录不完整时跳过
try
{
var id = Convert.ToInt32(item[0]);
var betting = new DBC.Betting(id);
bettingList.Add(betting);
}
catch { }
}
var pagination = new Pagination();
pagination.Pages = pages;
pagination.Current = p;
pagination.BaseUrl = "/home/betting";
ViewBag.pagination = pagination;
ViewBag.list = GetBettingOverviewList(bettingList);
}
catch
{
ViewBag.errorText = "未查询到任何记录";
}
return View();
}
void GetBettingsList()
{
var user = GetCurrentUser();
if (user == null || user.Role != Enums.Roles.Normal)
{
return;
}
var list = new List <DBC.Betting>();
var sql = string.Format("select id from {0} where userid=? order by id desc limit 20", DBTables.Betting);
var res = DB.SExecuteReader(sql, user.ID);
foreach (var item in res)
{
var id = Convert.ToInt32(item[0]);
var betting = new DBC.Betting(id);
list.Add(betting);
}
ViewBag.user = user;
ViewBag.bettingsList = list;
}
public ActionResult Betting(int? userid, DateTime? beginDate, DateTime? endDate, int p = 0)
{
try
{
ViewBag.Title = "投注记录";
ViewBag.Title2 = "投注记录";
ViewBag.Page = "投注";
if (beginDate == null)
beginDate = DateTime.Today.AddDays(-7);
if (endDate == null)
endDate = DateTime.Today;
var currentUser = Session["user"] as DBC.User;
var pages = 1;
var sqlCount = "";
var sqlList = "";
var sqlSum = "";
var sqlCountArgs = new List<object>();
var sqlListArgs = new List<object>();
var sqlSumArgs = new List<object>();
//查看指定用户的投注记录
if (userid != null)
{
var user = new DBC.User(userid.Value);
if (user.Parent != GetCurrentUser().ID)
throw new Exception("无权查看");
sqlCount = string.Format("select count(*) from {0} where {0}.userid=? and time>? and time<?", DBTables.Betting);
sqlCountArgs.Add(user.ID);
sqlCountArgs.Add(beginDate.Value);
sqlCountArgs.Add(endDate.Value.AddDays(1));
sqlList = string.Format("select id from {0} where {0}.userid=? and time>? and time<? order by time desc limit ?,?", DBTables.Betting, DBTables.User);
sqlListArgs.Add(user.ID);
sqlListArgs.Add(beginDate.Value);
sqlListArgs.Add(endDate.Value.AddDays(1));
sqlSum = string.Format("select sum(total),sum(winning) from {0} where userid=? and time>? and time<?", DBTables.Betting);
sqlSumArgs.Add(user.ID);
sqlSumArgs.Add(beginDate.Value);
sqlSumArgs.Add(endDate.Value.AddDays(1));
}
//查看全部投注记录
else
{
var current = GetCurrentUser();
sqlCount = string.Format("select count(*) from {0},{1} where {0}.userid={1}.id and ({1}.id=? or {1}.parent=?) and time>? and time<?", DBTables.Betting, DBTables.User);
sqlCountArgs.Add(current.ID);
sqlCountArgs.Add(current.ID);
sqlCountArgs.Add(beginDate.Value);
sqlCountArgs.Add(endDate.Value.AddDays(1));
sqlList = string.Format("select {0}.id from {0},{1} where {0}.userid={1}.id and ({1}.id=? or {1}.parent=?) and time>? and time<? order by time desc limit ?,?", DBTables.Betting, DBTables.User);
sqlListArgs.Add(current.ID);
sqlListArgs.Add(current.ID);
sqlListArgs.Add(beginDate.Value);
sqlListArgs.Add(endDate.Value.AddDays(1));
sqlSum = string.Format("select sum(total),sum(winning) from {0},{1} where {0}.userid={1}.id and ({1}.id=? or {1}.parent=?) and time>? and time<?", DBTables.Betting, DBTables.User);
sqlSumArgs.Add(current.ID);
sqlSumArgs.Add(current.ID);
sqlSumArgs.Add(beginDate.Value);
sqlSumArgs.Add(endDate.Value.AddDays(1));
}
//添加分页参数
sqlListArgs.Add(p * _itemsPerPage);
sqlListArgs.Add(_itemsPerPage);
//获取总记录数
var totalCount = Convert.ToInt32(DB.SExecuteScalar(sqlCount, sqlCountArgs.ToArray()));
//计算分页数
pages = (int)Math.Ceiling(totalCount * 1.0 / _itemsPerPage);
//获取下注记录
var res = DB.SExecuteReader(sqlList, sqlListArgs.ToArray());
var bettingList = new List<DBC.Betting>();
foreach (var item in res)
{
//数据记录不完整时跳过
try
{
var id = Convert.ToInt32(item[0]);
var betting = new DBC.Betting(id);
bettingList.Add(betting);
}
catch { }
}
//获取总投注和总中奖
var res2 = DB.SExecuteReader(sqlSum, sqlSumArgs.ToArray());
var totalBetting = Utility.ToInt32(res2[0][0]);
var totalWinning = Utility.ToInt32(res2[0][1]);
var pagination = new Pagination();
pagination.Pages = pages;
pagination.Current = p;
pagination.BaseUrl = string.Format("/home/betting?userid={0}&beginDate={1}&endDate={2}", userid, beginDate.Value.ToString("yyyy-MM-dd"), endDate.Value.ToString("yyyy-MM-dd"));
ViewBag.list = GetBettingOverviewList(bettingList);
ViewBag.pagination = pagination;
ViewBag.totalBetting = totalBetting;
ViewBag.totalWinning = totalWinning;
ViewBag.beginDate = beginDate.Value;
ViewBag.endDate = endDate.Value;
ViewBag.userid = userid;
}
catch
{
ViewBag.errorText = "未查询到任何记录";
}
return View();
}
public ActionResult BettingFind(int id)
{
try
{
ViewBag.Title = "投注记录";
ViewBag.Title2 = "投注记录";
ViewBag.Page = "投注";
var betting = new DBC.Betting(id);
var user = new DBC.User(betting.UserID);
var current = GetCurrentUser();
if (user.ID == current.ID || user.Parent == current.ID)
{
var bettingList = new List<DBC.Betting>() { betting };
ViewBag.list = GetBettingOverviewList(bettingList);
}
else
{
throw new Exception("无权查看");
}
}
catch
{
ViewBag.errorText = "未查询到任何记录";
}
return View("betting");
}
public ActionResult Betting(int?userid, DateTime?beginDate, DateTime?endDate, int p = 0)
{
try
{
ViewBag.Title = "投注记录";
ViewBag.Title2 = "投注记录";
ViewBag.Page = "投注";
if (beginDate == null)
{
beginDate = DateTime.Today.AddDays(-7);
}
if (endDate == null)
{
endDate = DateTime.Today;
}
var currentUser = Session["user"] as DBC.User;
var pages = 1;
var sqlCount = "";
var sqlList = "";
var sqlSum = "";
var sqlCountArgs = new List <object>();
var sqlListArgs = new List <object>();
var sqlSumArgs = new List <object>();
//查看指定用户的投注记录
if (userid != null)
{
var user = new DBC.User(userid.Value);
if (user.Parent != GetCurrentUser().ID)
{
throw new Exception("无权查看");
}
sqlCount = string.Format("select count(*) from {0} where {0}.userid=? and time>? and time<?", DBTables.Betting);
sqlCountArgs.Add(user.ID);
sqlCountArgs.Add(beginDate.Value);
sqlCountArgs.Add(endDate.Value.AddDays(1));
sqlList = string.Format("select id from {0} where {0}.userid=? and time>? and time<? order by time desc limit ?,?", DBTables.Betting, DBTables.User);
sqlListArgs.Add(user.ID);
sqlListArgs.Add(beginDate.Value);
sqlListArgs.Add(endDate.Value.AddDays(1));
sqlSum = string.Format("select sum(total),sum(winning) from {0} where userid=? and time>? and time<?", DBTables.Betting);
sqlSumArgs.Add(user.ID);
sqlSumArgs.Add(beginDate.Value);
sqlSumArgs.Add(endDate.Value.AddDays(1));
}
//查看全部投注记录
else
{
var current = GetCurrentUser();
sqlCount = string.Format("select count(*) from {0},{1} where {0}.userid={1}.id and ({1}.id=? or {1}.parent=?) and time>? and time<?", DBTables.Betting, DBTables.User);
sqlCountArgs.Add(current.ID);
sqlCountArgs.Add(current.ID);
sqlCountArgs.Add(beginDate.Value);
sqlCountArgs.Add(endDate.Value.AddDays(1));
sqlList = string.Format("select {0}.id from {0},{1} where {0}.userid={1}.id and ({1}.id=? or {1}.parent=?) and time>? and time<? order by time desc limit ?,?", DBTables.Betting, DBTables.User);
sqlListArgs.Add(current.ID);
sqlListArgs.Add(current.ID);
sqlListArgs.Add(beginDate.Value);
sqlListArgs.Add(endDate.Value.AddDays(1));
sqlSum = string.Format("select sum(total),sum(winning) from {0},{1} where {0}.userid={1}.id and ({1}.id=? or {1}.parent=?) and time>? and time<?", DBTables.Betting, DBTables.User);
sqlSumArgs.Add(current.ID);
sqlSumArgs.Add(current.ID);
sqlSumArgs.Add(beginDate.Value);
sqlSumArgs.Add(endDate.Value.AddDays(1));
}
//添加分页参数
sqlListArgs.Add(p * _itemsPerPage);
sqlListArgs.Add(_itemsPerPage);
//获取总记录数
var totalCount = Convert.ToInt32(DB.SExecuteScalar(sqlCount, sqlCountArgs.ToArray()));
//计算分页数
pages = (int)Math.Ceiling(totalCount * 1.0 / _itemsPerPage);
//获取下注记录
var res = DB.SExecuteReader(sqlList, sqlListArgs.ToArray());
var bettingList = new List <DBC.Betting>();
foreach (var item in res)
{
//数据记录不完整时跳过
try
{
var id = Convert.ToInt32(item[0]);
var betting = new DBC.Betting(id);
bettingList.Add(betting);
}
catch { }
}
//获取总投注和总中奖
var res2 = DB.SExecuteReader(sqlSum, sqlSumArgs.ToArray());
var totalBetting = Utility.ToInt32(res2[0][0]);
var totalWinning = Utility.ToInt32(res2[0][1]);
var pagination = new Pagination();
pagination.Pages = pages;
pagination.Current = p;
pagination.BaseUrl = string.Format("/home/betting?userid={0}&beginDate={1}&endDate={2}", userid, beginDate.Value.ToString("yyyy-MM-dd"), endDate.Value.ToString("yyyy-MM-dd"));
ViewBag.list = GetBettingOverviewList(bettingList);
ViewBag.pagination = pagination;
ViewBag.totalBetting = totalBetting;
ViewBag.totalWinning = totalWinning;
ViewBag.beginDate = beginDate.Value;
ViewBag.endDate = endDate.Value;
ViewBag.userid = userid;
}
catch
{
ViewBag.errorText = "未查询到任何记录";
}
return(View());
}
void GetBettingsList()
{
var user = GetCurrentUser();
if (user == null || user.Role != Enums.Roles.Normal)
return;
var list = new List<DBC.Betting>();
var sql = string.Format("select id from {0} where userid=? order by id desc limit 20", DBTables.Betting);
var res = DB.SExecuteReader(sql, user.ID);
foreach (var item in res)
{
var id = Convert.ToInt32(item[0]);
var betting = new DBC.Betting(id);
list.Add(betting);
}
ViewBag.user = user;
ViewBag.bettingsList = list;
}