public async Task <ActionResult> Login(InputLogin model) { if (!ModelState.IsValid) { return(View(model)); } //var result = loginOnManager.LoginOn(model); using (SubBugEntities db = new SubBugEntities()) { var Pwd = md5.MD5Encrypt(model.LoginPwd); var result = await db.TB_LoginOn.FirstOrDefaultAsync(l => l.LoginNo == model.LoginNo && l.LoginPwd == Pwd); if (result != null) { Session["LoginName"] = result; if (((TB_LoginOn)Session["LoginName"]).AId != 1) { return(RedirectToAction("Index", "Follow")); } return(RedirectToAction("List", "Home")); } ViewData["info"] = "失败!"; return(View(model)); } }
public async Task <ActionResult> Register(TB_LoginOn model) { if (ModelState.IsValid) { using (SubBugEntities db = new SubBugEntities()) { if (await db.TB_LoginOn.FirstOrDefaultAsync(l => l.LoginNo == model.LoginNo) != null) { ModelState.AddModelError("", "用户名已经存在!"); return(View()); } else { model = new TB_LoginOn() { LoginNo = Request.Params["LoginNo"].ToUpper(), LoginPwd = md5.MD5Encrypt(Request.Params["LoginPwd"]), LoginName = Request.Params["LoginName"].ToUpper(), LPhone = Request.Params["LPhone"], ComputerNo = Request.Params["ComputerNo"].ToUpper(), AId = 1 }; db.TB_LoginOn.Add(model); await db.SaveChangesAsync(); return(RedirectToAction("Login", "Account")); } } } return(View(model)); }
public ActionResult SetPwd(TB_LoginOn login) { using (SubBugEntities db = new SubBugEntities()) { var lid = ((TB_LoginOn)Session["LoginName"]).LId; TB_LoginOn lg = db.TB_LoginOn.Where(t => t.LId == lid).FirstOrDefault(); lg.LoginPwd = md5.MD5Encrypt(login.LoginPwd); db.SaveChanges(); Session.Clear(); return(Content("<script>alert('密码修改成功!');window.location.href='Login';</script>")); } }
public ActionResult Edit([Bind(Include = "LId,LoginNo,LoginName,LoginPwd,LPhone,ComputerNo")] TB_LoginOn loginOn) { if (ModelState.IsValid) { using (SubBugEntities db = new SubBugEntities()) { db.Entry(loginOn).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } } return(View(loginOn)); }
public ActionResult LoginNameList(string Lg) { if (Lg == null) { return(RedirectToAction("Index", "Home")); } using (SubBugEntities db = new SubBugEntities()) { var list = new List <TB_BugSubmit>(); var tB_Follow = db.TB_Follow.Include(t => t.BugSubmit).Include(t => t.LoginOn).Where(t => t.BugSubmit.YN == "N" && t.LoginOn.LoginName == Lg).OrderByDescending(t => t.BId); return(View(tB_Follow.ToList())); } }
//public X.PagedList.IPagedList<TB_BugSubmit> BugSubmit { get; set; } public async Task <ActionResult> Index(int?page) { SubBugEntities db = new SubBugEntities(); var list = await db.TB_BugSubmit.Where(t => t.YN == "N").OrderByDescending(d => d.BId).ToListAsync(); //int pageSize = int.Parse(ConfigurationManager.AppSettings["pageSize"]); int pageSize = GetPageSize.IsMobileRequest(); var pageNumber = page ?? 1; IPagedList <TB_BugSubmit> pagedList = list.ToPagedList(pageNumber, pageSize); return(View(pagedList)); }
public ActionResult Details(int?id) { if (id == null) { return(View()); } SubBugEntities db = new SubBugEntities(); TB_BugSubmit follow = db.TB_BugSubmit.Find(id);//db.TB_BugSubmit.Include(t => t.Follow).Where(t => t.BId == id); //var follow =db.TB_Follow.Where(t => t.BId == id); if (follow == null) { return(HttpNotFound()); } return(View(follow)); }
public async Task <ActionResult> Create(TB_BugSubmit model) { if (Session["LoginName"] != null) { model.LId = ((TB_LoginOn)Session["LoginName"]).LId; model.Claimant = ((TB_LoginOn)Session["LoginName"]).LoginName; model.LPhone = ((TB_LoginOn)Session["LoginName"]).LPhone; model.ComputerNo = ((TB_LoginOn)Session["LoginName"]).ComputerNo; } else { if (ModelState.IsValid) { model.LId = 1; model.AppName = Request.Params["AppName"].ToUpper(); model.Describe = Request.Params["Describe"]; model.Claimant = Request.Params["Claimant"].ToUpper(); model.LPhone = Request.Params["LPhone"].ToUpper(); model.ComputerNo = Request.Params["ComputerNo"].ToUpper(); } } model.LIP = System.Web.HttpContext.Current.Request.UserHostAddress; model.SubDate = DateTime.Now; model.YN = "N"; using (SubBugEntities db = new SubBugEntities()) { try { db.TB_BugSubmit.Add(model); await db.SaveChangesAsync(); return(RedirectToAction("Index", "Home")); } catch { return(View()); } } }
public async Task <ActionResult> List() { using (SubBugEntities db = new SubBugEntities()) { var list = new List <TB_BugSubmit>(); //var listB = new List<TB_Follow>(); if (Session["LoginName"] != null) { var lid = ((TB_LoginOn)Session["LoginName"]).LId; list = await db.TB_BugSubmit.Include(t => t.LoginOn).Where(t => t.LId.Equals(lid) && t.YN == "N").OrderByDescending(d => d.BId).ToListAsync(); //listB = db.TB_Follow.Include(t => t.BugSubmit).Where(t=>t.LId==lid&&t.BugSubmit.YN=="N").OrderByDescending(d => d.BId).ToList(); //return View(listB); } else { list = await db.TB_BugSubmit.Where(t => t.YN == "N").OrderByDescending(d => d.BId).ToListAsync(); } return(View(list)); } }
public ActionResult SelectList(int?page, string searchString, string strST, string strET, string currentFilter, string currentST, string currentET) { SubBugEntities db = new SubBugEntities(); List <TB_LoginOn> listSelect = db.TB_LoginOn.Where(t => t.AId != 1 && t.LoginName != "Guest").ToList(); //ViewData["STime"] = strST; //ViewData["ETime"] = strET; //ViewData["LoginName"] = searchString; searchString = Request.Params["LoginName"]; strST = Request.Params["STime"]; strET = Request.Params["ETime"]; var list = new List <TB_Schedule>(); int pageSize = GetPageSize.IsMobileRequest(); var pageNumber = page ?? 1; if (!string.IsNullOrWhiteSpace(searchString) || (strST != null && strET != null)) { pageNumber = 1; } else { searchString = currentFilter; strST = currentST; strET = currentET; } SelectList selList = new SelectList(listSelect, "LoginName", "LoginName", searchString); ViewData["Select"] = selList; ViewData["CurrentFilter"] = searchString; ViewData["CurrentST"] = strST; ViewData["CurrentET"] = strET; list = db.TB_Schedule.Include(t => t.Follow).Include(t => t.BugSubmit).Where(t => t.BugSubmit.YN == "Y").OrderByDescending(t => t.FinishDate).ToList(); //int TotalCount = list.Count(); if (!string.IsNullOrWhiteSpace(searchString) && !string.IsNullOrEmpty(strST) && !string.IsNullOrEmpty(strET)) { //list = list.Where(t => t.Follow.LoginOn.LoginName.Contains(searchString)).ToList(); list = list.Where(t => t.FinishDate >= Convert.ToDateTime(strST) && t.FinishDate <= Convert.ToDateTime(strET) && t.Follow.LoginOn.LoginName.Contains(searchString)).ToList(); IPagedList <TB_Schedule> pagedListD = list.ToPagedList(pageNumber, pageSize); //TotalCount = list.Count(); return(View(pagedListD)); } else { if (!string.IsNullOrWhiteSpace(searchString)) { list = list.Where(t => t.Follow.LoginOn.LoginName.Contains(searchString)).ToList(); IPagedList <TB_Schedule> pagedListA = list.ToPagedList(pageNumber, pageSize); //TotalCount = list.Count(); return(View(pagedListA)); } if (!string.IsNullOrEmpty(strST) && !string.IsNullOrEmpty(strET)) { list = list.Where(t => t.FinishDate >= Convert.ToDateTime(strST) && t.FinishDate <= Convert.ToDateTime(strET)).ToList(); IPagedList <TB_Schedule> pagedListB = list.ToPagedList(pageNumber, pageSize); //TotalCount = list.Count(); return(View(pagedListB)); } } IPagedList <TB_Schedule> pagedListC = list.ToPagedList(pageNumber, pageSize); return(View(pagedListC)); }