/// <summary>
/// 更新workRecord
/// </summary>
/// <param name="WorkName"></param>
/// <param name="WorkProcess"></param>
/// <param name="WorkLevel"></param>
/// <param name="WorkMark"></param>
/// <param name="StartTime"></param>
/// <param name="EndTime"></param>
/// <returns></returns>
public JsonResult SaveUpdate(int Id, string WorkName, int WorkProcess, int WorkLevel, string WorkMark, DateTime StartTime, DateTime EndTime)
{
string result = "";
if (Id > 0)
{
try
{
using (var DB = new WorkRecordsContext())
{
var entry = (from t in DB.WorkRecords where t.Id == Id select t).FirstOrDefault();
entry.WorkName = WorkName;
entry.WorkProcss = WorkProcess;
entry.WorkLevel = WorkLevel;
entry.WorkMark = WorkMark;
entry.StartTime = StartTime;
entry.EndTime = EndTime;
DB.WorkRecords.Update(entry);
DB.SaveChanges();
result = entry.Id.ToString(); //成功
}
}
catch (Exception ex)
{
result = "0";//失败
}
}
return(Json(result));
}
public IActionResult Index(int page = 1)
{
try
{
using (var DB = new WorkRecordsContext())
{
ViewBag.Record = DB.WorkRecords.ToList().Skip((page - 1) * PageSize).Take(PageSize).ToList();;
ViewBag.PageHtml = PageingHtml.GetPagingHTML(DB.WorkRecords.ToList().Count, PageSize, page, "turnPage(1Index1)", 5, 2);
}
}
catch (Exception ex)
{
//写日志记录错误
}
return(View());
}
public async Task <IActionResult> Unauthorized(string username, string password, string returnUrl = null)
{
try
{
using (var DB = new WorkRecordsContext())
{
var usermodel = (from t in DB.WorkUser where t.username == username && t.password == password select t).FirstOrDefault();
if (usermodel != null)
{
List <Claim> claims = new List <Claim>();
claims.Add(new Claim(ClaimTypes.Name, username, ClaimValueTypes.String, ""));
var userIdentity = new ClaimsIdentity("管理员");
userIdentity.AddClaims(claims);
var userPrincipal = new ClaimsPrincipal(userIdentity);
await HttpContext.Authentication.SignInAsync("MyCookieMiddlewareInstance", userPrincipal,
new AuthenticationProperties
{
ExpiresUtc = DateTime.UtcNow.AddMinutes(20),
IsPersistent = false,
AllowRefresh = false
});
if (Url.IsLocalUrl(returnUrl))
{
return(Redirect(returnUrl));
}
else
{
return(RedirectToAction("Index", "Home"));
}
}
else
{
return(RedirectToAction("Index", "Account"));//登录失败
}
}
}
catch (Exception ex)
{
return(RedirectToAction("Index", "Account"));//失败
}
}
public JsonResult SaveAdd(string WorkName, int WorkProcess, int WorkLevel, string WorkMark, DateTime StartTime, DateTime EndTime, string UserName)
{
string result = "";
try
{
using (var DB = new WorkRecordsContext())
{
var entry = new WorkRecords()
{
WorkName = WorkName, WorkProcss = WorkProcess, WorkLevel = WorkLevel, WorkMark = WorkMark, StartTime = StartTime, EndTime = EndTime, UserName = UserName
};
DB.WorkRecords.Add(entry);
DB.SaveChanges();
result = "0"; //成功
}
}
catch (Exception ex)
{
result = "1";//失败
}
return(Json(result));
}
public IActionResult Index(int StartTime = 0, int EndTime = 0, int WorkProcss = 0, int WorkLevel = 0, int page = 1)
{
try
{
using (var DB = new WorkRecordsContext())
{
//mysql的EF入口没发现sql的执行方法，暂时先这么写
if (StartTime > 0)
{
if (StartTime == 1)
{
ViewBag.Record = DB.WorkRecords.ToList().OrderBy(i => i.StartTime).Skip((page - 1) * PageSize).Take(PageSize).ToList();
}
else
{
ViewBag.Record = DB.WorkRecords.ToList().OrderByDescending(i => i.StartTime).Skip((page - 1) * PageSize).Take(PageSize).ToList();
}
}
else if (EndTime > 0)
{
if (EndTime == 1)
{
ViewBag.Record = DB.WorkRecords.ToList().OrderBy(i => i.EndTime).Skip((page - 1) * PageSize).Take(PageSize).ToList();
}
else
{
ViewBag.Record = DB.WorkRecords.ToList().OrderByDescending(i => i.EndTime).Skip((page - 1) * PageSize).Take(PageSize).ToList();
}
}
else if (WorkProcss > 0)
{
if (WorkProcss == 1)
{
ViewBag.Record = DB.WorkRecords.ToList().OrderBy(i => i.WorkProcss).Skip((page - 1) * PageSize).Take(PageSize).ToList();
}
else
{
ViewBag.Record = DB.WorkRecords.ToList().OrderByDescending(i => i.WorkProcss).Skip((page - 1) * PageSize).Take(PageSize).ToList();
}
}
else if (WorkLevel > 0)
{
if (WorkLevel == 1)
{
ViewBag.Record = DB.WorkRecords.ToList().OrderBy(i => i.WorkLevel).Skip((page - 1) * PageSize).Take(PageSize).ToList();
}
else
{
ViewBag.Record = DB.WorkRecords.ToList().OrderByDescending(i => i.WorkLevel).Skip((page - 1) * PageSize).Take(PageSize).ToList();
}
}
else
{
ViewBag.Record = DB.WorkRecords.ToList().Skip((page - 1) * PageSize).Take(PageSize).ToList();
}
ViewBag.PageHtml = PageingHtml.GetPagingHTML(DB.WorkRecords.ToList().Count, PageSize, page, "turnPage(1Index1)", 5, 2);
}
}
catch (Exception ex)
{
//写日志记录错误
}
return(View());
}
