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