public ActionResult Index() { string uname = Session["username"].ToString(); game_user_account n = (from d in db.game_user_account where d.Accounts == uname select d).FirstOrDefault(); //List<game_user_account> list = (from d in db.game_user_account where d.Accounts == uname select d).ToList(); ////return View(); //ViewData["datalist"] = list; return(View(n)); }
public ActionResult SelectUser() { if (Session["userid"] != null) { ViewBag.uname = Session["username"].ToString(); int uid = (int)Session["userid"]; game_user_account nn = (from dd in db.game_user_account where dd.UserID == uid select dd).FirstOrDefault(); return(View(nn)); } else { return(RedirectToAction("Index", "Login")); } }
public ActionResult IngotAdd(int?UserID) { if (Session["username"] != null) { ViewBag.uname = Session["username"].ToString(); ViewBag.level = Session["level"].ToString(); game_user_account gua = (from a in db.game_user_account where a.UserID == UserID select a).FirstOrDefault(); ViewData["User"] = gua; return(View()); } else { return(RedirectToAction("Login", "SuperLogin")); } }
public ActionResult personal() { if (Session["username"] != null) { ViewBag.uname = Session["username"].ToString(); ViewBag.level = Session["level"].ToString(); int id = Convert.ToInt32(Session["aid"]); web_admin n = (from d in ldb.web_admin where d.id == id select d).FirstOrDefault(); ViewData["admin"] = n; Session["userid"] = n.userid; game_user_account gua = (from f in db.game_user_account where f.UserID == n.userid select f).FirstOrDefault(); ViewData["user"] = gua; log_gamelogin lg = (from c in db.log_gamelogin where c.userid == n.userid orderby c.logid descending select c).FirstOrDefault(); ViewData["gamelogin"] = lg; web_admin f_n = (from d in ldb.web_admin where d.id == n.up_agentid select d).FirstOrDefault(); ViewData["f_admin"] = f_n; var erzi = (from e in db.game_user_account where e.bind_number == n.invitecode select e).ToList(); ViewBag.erzi = erzi.Count(); if (n.level < 3) { var erzi_sanji = (from e in ldb.web_admin where e.up_agentid == n.userid && e.level == 3 select e).ToList(); ViewBag.erzi_sanji = 0; ViewBag.erzi_erji = 0; if (erzi_sanji.Count > 0) { ViewBag.erzi_sanji = erzi_sanji.Count(); } if (n.level == 1) { var erzi_erji = (from e in ldb.web_admin where e.up_agentid == n.userid && e.level == 2 select e).ToList(); if (erzi_erji.Count > 0) { ViewBag.erzi_erji = erzi_erji.Count(); } } } return(View(n)); } else { return(RedirectToAction("Login", "SuperLogin")); } }
// GET: Admin public ActionResult Index() { if (Session["username"] != null) { ViewBag.uname = Session["username"].ToString(); string uname = Session["username"].ToString(); //int id = Session["aid"]; game_user_account n = (from d in db.game_user_account where d.Accounts == uname select d).FirstOrDefault(); Session["userid"] = n.UserID; //List<game_user_account> list = (from d in db.game_user_account where d.Accounts == uname select d).ToList(); ////return View(); //ViewData["datalist"] = list; return(View(n)); } else { return(RedirectToAction("Index", "Login")); } }
public ActionResult IngotAdd(FormCollection f) { int uid = Convert.ToInt32(f["UserID"]); int gold = 0; int ingot = 0; if (f["gold"] != "") { gold = Convert.ToInt32(f["gold"]); } if (f["ingot"] != "") { ingot = Convert.ToInt32(f["ingot"]); } string remake = "管理员:" + Session["username"].ToString() + "进行的操作,备注为:" + f["remake"]; game_user_account gua = (from a in db.game_user_account where a.UserID == uid select a).FirstOrDefault(); int ingot_num = ingot + Convert.ToInt32(gua.Ingot); int gold_num = gold + Convert.ToInt32(gua.Gold);; string query1 = @"UPDATE game_user_account SET Ingot = @Ingot ,Gold = @Gold WHERE UserID =@uid;"; MySqlParameter[] paras1 = new MySqlParameter[] { new MySqlParameter("@uid", uid), new MySqlParameter("@Ingot", ingot_num), new MySqlParameter("@Gold", gold_num) }; try { db.Database.ExecuteSqlCommand(query1, paras1); } catch { } if (ingot != 0) { int reason = 7; if (ingot < 0) { reason = 8; } string qquery = @"INSERT INTO log_ingot_detail(ingot_num,kind_id,reason,user_id,create_time,after_ingot,before_ingot,remark) values (@num, 101,@reason,@uid,@create_time,@after_ingot,@before_ingot,@remake);"; MySqlParameter[] pparas = new MySqlParameter[] { new MySqlParameter("@uid", uid), new MySqlParameter("@num", ingot), new MySqlParameter("@reason", reason), new MySqlParameter("@create_time", DateTime.Now), new MySqlParameter("@after_ingot", ingot_num), new MySqlParameter("@before_ingot", Convert.ToInt32(gua.Ingot)), new MySqlParameter("@remake", remake) }; db.Database.ExecuteSqlCommand(qquery, pparas); } return(RedirectToAction("IngotDetail", "SuperAdmin")); }