// GET: ApplyManager/Edit/5 public ActionResult Edit(string id) { if (!User.Identity.IsAuthenticated) { return(RedirectToRoute(new { controller = "Login", action = "LogOut" })); } if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } SetSelect(0); if (!User.Identity.IsAuthenticated) { return(RedirectToRoute(new { controller = "Login", action = "LogOut" })); } int user = PageValidate.FilterParam(User.Identity.Name); Bills dal = new Bills(db); ApplyListModel bill = dal.GetReimbursement(id, user).FirstOrDefault(); bill.contents = dal.getContents(bill.reimbursementCode, 0).ToList(); foreach (var item in bill.contents) { item.details = dal.getContentDetails((int)item.contentId, 0).ToList(); item.attachments = dal.getAttachments(bill.reimbursementCode, 0, (int)item.contentId).ToList(); } bill.attachments = dal.getAttachments(bill.reimbursementCode, 0, 0).ToList(); var responds = dal.getResponds(bill.reimbursementCode, 0).OrderBy(x => x.num).FirstOrDefault(); if (responds != null) { bill.next = (int)responds.thisRespondUser; } return(View(bill)); }
public JsonResult GetRespondResult(string id) { BaseJsonData json = new BaseJsonData(); if (!User.Identity.IsAuthenticated) { json.msg_code = "nologin"; goto next; } int user = Common.PageValidate.FilterParam(User.Identity.Name); Bills dal = new Bills(db); var bill = dal.GetReimbursement(id, 0).FirstOrDefault(); if (bill == null) { json.msg_text = "没有找到该报销单。"; json.msg_code = "noData"; goto next; } if (bill.state != 1) { json.msg_text = "不能打印未批复报销单。"; json.msg_code = "noData"; goto next; } if (user != bill.userId) { json.msg_text = "不能操作他人报销单。"; json.msg_code = "noData"; goto next; } bill.userName = AESEncrypt.Decrypt(bill.userName); bill.contents = dal.getContents(bill.reimbursementCode, 0).ToList(); bill.attachmentsCount = dal.getAttachments(bill.reimbursementCode, 0).Count(); bill.detailsCount = (from content in db.Reimbursement_Content join detail in db.Reimbursement_Detail on content.content_id equals detail.detail_content_id where content.c_reimbursement_code == bill.reimbursementCode select content.content_id).Count(); json.state = 1; json.msg_code = "success"; json.data = bill; next: return(Json(json, JsonRequestBehavior.AllowGet)); }
public ActionResult Detail(StatisticsSearch search) { if (!User.Identity.IsAuthenticated) { return(RedirectToRoute(new { controller = "Login", action = "LogOut" })); } int user = PageValidate.FilterParam(User.Identity.Name); setSearchSelect(user); Bills dal = new Bills(db); var query = dal.GetReimbursement("", (int)search.userId).Where(x => x.state == 1); if (search.beginDate != null) { search.beginDate = DateTime.Parse(((DateTime)search.beginDate).ToString("yyyy-MM-dd 00:00:00.000")); query = query.Where(x => x.time >= search.beginDate); } if (search.endDate != null) { search.endDate = DateTime.Parse(((DateTime)search.endDate).ToString("yyyy-MM-dd 23:59:59.999")); query = query.Where(x => x.time <= search.endDate); } search.Amount = query.Count(); query = query.OrderByDescending(x => x.time).Skip(search.PageSize * (search.PageIndex - 1)).Take(search.PageSize); var list = query.ToList(); foreach (var item in list) { item.userName = AESEncrypt.Decrypt(item.userName); item.attachmentsCount = (from content in db.Reimbursement_Content join detail in db.Reimbursement_Detail on content.content_id equals detail.detail_content_id where content.c_reimbursement_code == item.reimbursementCode select content.content_id).Count(); } ViewData["Details"] = list; return(View(search)); }
// GET: ApplyManager/Details/5 public ActionResult Details(string id) { if (!User.Identity.IsAuthenticated) { return(RedirectToRoute(new { controller = "Login", action = "LogOut" })); } int user = PageValidate.FilterParam(User.Identity.Name); if (id == null) { return(RedirectToRoute(new { controller = "Error", action = "Index", err = "报销单号获取失败。" })); } Bills dal = new Bills(db); List <SelectOption> options = DropDownList.RespondUserSelect(); ViewData["ViewUsers"] = DropDownList.SetDropDownList(options); var bill = dal.GetReimbursement(id, 0).FirstOrDefault(); bill.contents = dal.getContents(bill.reimbursementCode, 0).ToList(); foreach (var item in bill.contents) { item.details = dal.getContentDetails((int)item.contentId, 0).ToList(); item.attachments = dal.getAttachments(bill.reimbursementCode, 0, (int)item.contentId).ToList(); } bill.attachments = dal.getAttachments(bill.reimbursementCode, 0, 0).ToList(); bill.responds = dal.getResponds(bill.reimbursementCode, 0).ToList(); bill.userName = AESEncrypt.Decrypt(bill.userName); if (bill.responds != null && bill.responds.Count() > 0) { foreach (var respond in bill.responds) { respond.respondUser = AESEncrypt.Decrypt(respond.respondUser); } } return(View(bill)); }