public ActionResult Checklist(CheckLog checkLog) { var pnumber = Convert.ToInt32(Request["PNumber"]); var user = HttpContext.User.Identity.Name; checkLog.CheckDate = DateTime.Now.ToString(); checkLog.UserId = user; checkLog.PointId = pnumber; db.CheckLogs.Add(checkLog); if (db.CheckLists.Any(x => x.PointID == pnumber) == true) { var point = db.CheckLists .Where(x => x.PointID == pnumber) .FirstOrDefault(); point.CheckDate = DateTime.Now.ToString(); point.UserID = user; point.PrinterSN = checkLog.CardPrinter; point.RouterSN = checkLog.RouterSN; point.Description = checkLog.CheckDescription; } else { var point = db.CheckLists; point.Add(new PointCheckList { PointID = pnumber, UserID = user, CheckDate = DateTime.Now.ToString(), RouterSN = checkLog.RouterSN, PrinterSN = checkLog.CardPrinter, Description = checkLog.CheckDescription }); } db.SaveChanges(); return(RedirectToAction("Index")); }
private void btExport_Click_1(object sender, EventArgs e) { if (tbFromDate != null && tbFromDate.Text != null && tbToDate.Text != "" && tbToDate.Text != null) { DateTime temp; if (DateTime.TryParse(tbFromDate.Text, out temp) && DateTime.TryParse(tbFromDate.Text, out temp)) { List <CheckLog> result = CheckLog.GetData(tbFromDate.Text, tbToDate.Text); ExportData expData = new ExportData(result); expData.WriteResultToExcel(); } } }
private void btExport_Click(object sender, EventArgs e) { DateTime fromDate, toDate; if (DateTime.TryParse(tbFromDate.Text, out fromDate) && DateTime.TryParse(tbToDate.Text, out toDate)) { List <CheckLog> result = CheckLog.GetData(tbFromDate.Text, tbToDate.Text); ExportData exportData = new ExportData(result); } else { MessageBox.Show("Please Check your Date format(dd/MM/YYYY)"); } }
public List <CheckLog> SelectAllData(string from, string to) { List <CheckLog> result = new List <CheckLog>(); try { this.ExcuteQurey("Select * from CheckLog where Check_Date Between '" + from + " 12:00:00' AND '" + to + " 12:00:00';"); while (this.dReader.Read()) { CheckLog check = new CheckLog(); check.Id = this.dReader[0].ToString(); check.Barcode = this.dReader[1].ToString(); check.ItemDescription = this.dReader[2].ToString(); check.UserInit = this.dReader[3].ToString(); //check.ItemDescription = bool status; if (Boolean.TryParse(this.dReader[5].ToString(), out status)) { if (status) { check.StudentNo = ""; check.Status = true; } else { check.StudentNo = this.dReader[4].ToString(); check.Status = false; } } check.CheckOutDate = this.dReader[6].ToString(); check.ExpireDate = this.dReader[7].ToString(); result.Add(check); } this.CloseConnection(); } catch (Exception ex) { System.Windows.Forms.MessageBox.Show(ex.Message); this.CloseConnection(); } return(result); }
public ActionResult SaveApply(Apply apply, string role, string applyType) { #region 保存申请 if (apply.ID == new Guid()) { apply.ID = Guid.NewGuid(); } apply.ApplyType = ApplyTypeManager.Get(new Guid(applyType)); apply.SendUser = UserInfoManager.GetUserSession(); apply.CreateTime = DateTime.Now; apply.CheckState = 0; apply.CheckStateName = "待审核"; ApplyManager.SaveOrUpdate(apply); #endregion #region 保存待审核用户的信息 // 读取需要进行审核角色的用户 IList <RoleUser> roleUser = RoleUserManager.LoadAll().Where(f => f.Role.ID == new Guid(role)).ToList(); Guid roleId = new Guid(role); Role checkRole = RoleManager.Get(roleId); if (roleUser.Count == 0) { return(Content("-1")); } for (int i = 0; i < roleUser.Count; i++) { CheckLog checkLog = new CheckLog(); checkLog.ID = Guid.NewGuid(); checkLog.Apply = apply; checkLog.CheckState = 0; checkLog.CheckTime = DateTime.Now; checkLog.CreateTime = DateTime.Now; checkLog.Remark = ""; checkLog.Role = checkRole; checkLog.UserInfo = roleUser[i].User; CheckLogManager.Save(checkLog); } #endregion return(Content("1")); }