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