public ActionResult Index()
{
ViewBag.Title = "注册";
if (Session["user"] != null)
return Content("已经登录不能操作");
if (Request.HttpMethod == "POST")
{
var tel = Request.Form["tel"];
var password = Request.Form["password"];
try
{
var userid = DB.SInsert("insert into " + DBTables.User + " (tel,password) values (?,?)", tel, password.SHA256());
var user = new DBC.User(userid);
Session["user"] = user;
return Content("注册成功");
}
catch
{
return Content("改用户名已经被注册");
}
}
return View();
}
public ActionResult UserRecharge(int id, int count)
{
try
{
var current = GetCurrentUser();
var user = new DBC.User(id);
if (user.Parent != current.ID)
{
return(Content("未找到该用户"));
}
if (count >= 0)
{
if (current.Points < count)
{
return(Content("余额不足，无法完成充值"));
}
current.Points -= (uint)count;
user.Points += (uint)count;
}
else
{
count = -1 * count;
if (user.Points < count)
{
return(Content("提现额大于积分，提现失败"));
}
user.Points -= (uint)count;
}
}
catch { }
return(Redirect("~/home/users"));
}
public ActionResult Users(int p = 0)
{
ViewBag.Title = "用户";
ViewBag.Title2 = "用户";
ViewBag.Page = "用户";
var currentUser = Session["user"] as DBC.User;
var pages = 1;
var sql1 = string.Format("select count(*) from {0} where parent=?", DBTables.User);
var totalCount = Convert.ToInt32(DB.SExecuteScalar(sql1, currentUser.ID));
pages = (int)Math.Ceiling(totalCount * 1.0 / _itemsPerPage);
var sql2 = string.Format("select id from {0} where parent=? limit ?,?", DBTables.User);
var res = DB.SExecuteReader(sql2, currentUser.ID, p * _itemsPerPage, _itemsPerPage);
var userList = new List<DBC.User>();
foreach (var item in res)
{
var id = Convert.ToInt32(item[0]);
var u = new DBC.User(id);
userList.Add(u);
}
ViewBag.list = GetUserOverviewList(userList);
var pagination = new Pagination();
pagination.Pages = pages;
pagination.Current = p;
pagination.BaseUrl = "/home/users";
ViewBag.pagination = pagination;
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 UserFind(int id)
{
var currentUser = Session["user"] as DBC.User;
ViewBag.Title = "查找用户";
ViewBag.Title2 = "查找用户";
ViewBag.Page = "用户";
try
{
var user = new DBC.User(id);
if (user.Parent != currentUser.ID)
{
throw new Exception("无权查看该用户资料");
}
ViewBag.list = GetUserOverviewList(new List <DBC.User>()
{
user
});
}
catch
{
ViewBag.errorText = "该用户id不存在";
}
return(View("users"));
}
//删除用户,功能暂时不实现，问题多多
//public ActionResult UserDelete(int id)
//{
// try
// {
// var user = new DBC.User(id);
// if (user.Parent == _currentUser.ID)
// user.Delete();
// }
// catch { }
// return Redirect("~/home/users");
//}
//重置用户密码
public ActionResult UserResetPw(int id)
{
var user = new DBC.User(id);
if (user.Parent == GetCurrentUser().ID)
user.Password = "******".ToSHA256String();
return Redirect("~/home/users");
}
protected void Session_Start()
{
var cookie = Request.Cookies["login"];
if (cookie != null)
{
var val = cookie.Value;
var sql = "select userid from " + DBTables.UserLoginCookie + " where value=? and expire>?";
var res = DB.SExecuteScalar(sql, val, DateTime.Now);
if (res != null)
{
var userid = Convert.ToInt32(res);
Session["user"] = new DBC.User(userid);
}
}
}
protected void Session_Start()
{
var cookie = Request.Cookies["login"];
if (cookie != null)
{
var val = cookie.Value;
var sql = "select userid from " + DBTables.UserLoginCookie + " where value=? and expire>?";
var res = DB.SExecuteScalar(sql, val, DateTime.Now);
if (res != null)
{
var userid = Convert.ToInt32(res);
Session["user"] = new DBC.User(userid);
}
}
}
//充值
public ActionResult UserRecharge(int id)
{
try
{
var currentUser = Session["user"] as DBC.User;
ViewBag.Title = "用户充值";
ViewBag.Title2 = "用户充值";
ViewBag.Page = "用户";
var user = new DBC.User(id);
if (user.Parent != GetCurrentUser().ID)
throw new Exception("无权充值");
ViewBag.user = user;
}
catch
{
ViewBag.errorText = "找不到该用户";
}
return View();
}
public ActionResult Index(int id, string password, string remember)
{
try
{
var user = new DBC.User(id);
if (user.Role != Enums.Roles.Administrator)
{
throw new Exception("权限不足");
}
if (user.Password != password.ToSHA256String())
{
throw new Exception("密码错误");
}
Session["user"] = user;
if (string.IsNullOrEmpty(remember) == false)
{
HttpCookie cookie = new HttpCookie("login");
var val = Guid.NewGuid().ToString("d");
var expire = DateTime.Now.AddDays(15);
DB.SExecuteNonQuery("insert into " + DBTables.UserLoginCookie + "(userid,value,expire) values (?,?,?)", user.ID, val, expire);
cookie.Value = val;
cookie.Expires = expire;
cookie.HttpOnly = true;
Response.SetCookie(cookie);
}
return(Redirect("~/"));
}
catch
{
ViewBag.loginFail = true;
return(View());
}
}
public ActionResult Index()
{
if (Session["user"] != null)
return Content("已经登录过了,请不要重复登录");
if (Request.HttpMethod == "POST")
{
var tel = Request.Form["tel"];
var password = Request.Form["password"];
var sql = "select id from " + DBTables.User + " where tel=? and password=?";
var pw = password.SHA256();
var res = DB.SExecuteScalar(sql, tel, password.SHA256());
if (res == null)
return Content("帐号或密码错误");
var userid = Convert.ToInt32(res);
Session["user"] = new DBC.User(userid);
if (string.IsNullOrEmpty(Request.Form["remember"]) == false)
{
HttpCookie cookie = new HttpCookie("login");
var val = Guid.NewGuid().ToString("d");
var expire = DateTime.Now.AddDays(15);
DB.SExecuteNonQuery("insert into "+DBTables.UserLoginCookie +"(userid,value,expire) values (?,?,?)" ,userid,val,expire);
cookie.Value = val;
cookie.Expires = expire;
cookie.HttpOnly = true;
Response.SetCookie(cookie);
}
return Redirect("~/account");
}
return View();
}
public ActionResult Index(int id, string password, string remember)
{
try
{
var user = new DBC.User(id);
if (user.Role != Enums.Roles.Administrator)
throw new Exception("权限不足");
if (user.Password != password.ToSHA256String())
throw new Exception("密码错误");
Session["user"] = user;
if (string.IsNullOrEmpty(remember) == false)
{
HttpCookie cookie = new HttpCookie("login");
var val = Guid.NewGuid().ToString("d");
var expire = DateTime.Now.AddDays(15);
DB.SExecuteNonQuery("insert into " + DBTables.UserLoginCookie + "(userid,value,expire) values (?,?,?)", user.ID, val, expire);
cookie.Value = val;
cookie.Expires = expire;
cookie.HttpOnly = true;
Response.SetCookie(cookie);
}
return Redirect("~/");
}
catch
{
ViewBag.loginFail = true;
return View();
}
}
public ActionResult Users(int p = 0)
{
ViewBag.Title = "用户";
ViewBag.Title2 = "用户";
ViewBag.Page = "用户";
var user = Session["user"] as DBC.User;
var itemsPerPage = 20;
var pages = 1;
var sql1 = string.Format("select count(*) from {0}", DBTables.User);
var totalCount = Convert.ToInt32(DB.SExecuteScalar(sql1));
pages = (int)Math.Ceiling(totalCount * 1.0 / itemsPerPage);
var sql2 = string.Format("select id from {0} where parent=? limit ?,?", DBTables.User);
var res = DB.SExecuteReader(sql2, user.ID, p * itemsPerPage, itemsPerPage);
var userList = new List<DBC.User>();
foreach (var item in res)
{
var id = Convert.ToInt32(item[0]);
var u = new DBC.User(id);
userList.Add(u);
}
ViewBag.list = GetUserOverviewList(userList);
var pagination = new Pagination();
pagination.Pages = pages;
pagination.Current = p;
pagination.BaseUrl = "/home/users";
ViewBag.pagination = pagination;
return View();
}
//重置密码
public ActionResult UserResetPw(int id)
{
var user = new DBC.User(id);
if (user.Parent == GetCurrentUser().ID)
user.Password = "******".ToSHA256String();
return Redirect("~/home/users");
}
public ActionResult UserRecharge(int id, int count)
{
try
{
var current = GetCurrentUser();
var user = new DBC.User(id);
if (user.Parent != current.ID)
return Content("未找到该用户");
if (count >= 0)
{
if (current.Points < count)
return Content("余额不足，无法完成充值");
current.Points -=(uint) count;
user.Points +=(uint) count;
}
else
{
count = -1 * count;
if(user.Points<count)
{
return Content("提现额大于积分，提现失败");
}
user.Points -=(uint) count;
}
}
catch { }
return Redirect("~/home/users");
}
//充值
public ActionResult UserRecharge(int id)
{
try
{
var current = GetCurrentUser();
ViewBag.Title = "用户充值";
ViewBag.Title2 = "用户充值";
ViewBag.Page = "用户";
var user = new DBC.User(id);
if (user.Parent != current.ID)
throw new Exception("无权充值");
ViewBag.user = user;
}
catch
{
ViewBag.errorText = "找不到该用户";
}
return View();
}
public ActionResult UserFind(int id)
{
var currentUser = Session["user"] as DBC.User;
ViewBag.Title = "查找用户";
ViewBag.Title2 = "查找用户";
ViewBag.Page = "用户";
try
{
var user = new DBC.User(id);
if (user.Parent != currentUser.ID)
throw new Exception("无权查看该用户资料");
ViewBag.list = GetUserOverviewList(new List<DBC.User>() { user });
}
catch
{
ViewBag.errorText = "该用户id不存在";
}
return View("users");
}
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());
}