public ActionResult DeleteChaxun(long id) { ArchivesContainer archivesContainer = db.ArchivesContainer.Find(id); long NO = archivesContainer.ID; var charger = from ad in ab.Charger where ad.searchNo == NO select ad; var charger1 = charger.First(); if (charger1.isCharge == true) { return(Content("<script>alert('此费用已经收取,不能进行删除 !');window.history.back();</script>")); } db.ArchivesContainer.Remove(archivesContainer); ab.Charger.Remove(charger1); db.SaveChanges(); ab.SaveChanges(); return(Content("<script>alert('已成功删除!');window.location.href='/OfficeDanganZhuangju/FeiYongChaXun'</script>")); }
public ActionResult HeJuFeiYongEdit(long?id) { ArchivesContainer archivesContainer = db.ArchivesContainer.Find(id); var charge = ab.Charger.Where(a => a.searchNo == id).First(); ViewBag.total = charge.totalExpense; if (charge.isCharge == true) { Response.Write("<script>alert('此费用已经收取,不能进行修改 !');window.history.back();</script>"); } ViewBag.Selected = new SelectList(ab.DepartmentCode, "value", "Text", charge.fromDepartment); List <SelectListItem> list1 = new List <SelectListItem> { new SelectListItem { Text = "转向财务科", Value = "1" }, new SelectListItem { Text = "转向复印室", Value = "0" }, }; ViewBag.Selected1 = new SelectList(list1, "Value", "Text", charge.whereTransfer); if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } ViewBag.seqNo = archivesContainer.seqNo; ViewBag.totle = charge.totalExpense; ViewBag.twoCentiCnt = archivesContainer.twoCentiCnt; ViewBag.thrCentiCnt = archivesContainer.thrCentiCnt; ViewBag.fourCentiCnt = archivesContainer.fourCentiCnt; ViewBag.fiveCentiCnt = archivesContainer.fiveCentiCnt; ViewBag.coverCnt = archivesContainer.coverCnt; ViewBag.catalogueCnt = archivesContainer.catalogueCnt; ViewBag.proformaCnt = archivesContainer.proformaCnt; if (archivesContainer == null) { return(HttpNotFound()); } return(View(archivesContainer)); }
// GET: OfficeDanganZhuangju/Details/5 public ActionResult Details(long?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } ArchivesContainer archivesContainer = db.ArchivesContainer.Find(id); long NO = archivesContainer.ID; var charger = from ad in ab.Charger where ad.searchNo == NO select ad; var charger1 = charger.First(); ViewBag.totle = charger1.totalExpense; ViewBag.trasfer = charger1.whereTransfer; if (archivesContainer == null) { return(HttpNotFound()); } return(View(archivesContainer)); }
public ActionResult HeJuFeiYongEdit(string action, [Bind(Include = "ID,twoCentiCnt,thrCentiCnt,fourCentiCnt,fiveCentiCnt,coverCnt,catalogueCnt,proformaCnt,DepartName,submitDate,submitPerson,archiveBoxFee,archiveCataLogFee,singleBoxFee,singleCatalogFee,seqNo")] ArchivesContainer archivesContainer, Charger charger) { long id = long.Parse(Request.Form["ID"]); var charge = from ad in ab.Charger where ad.searchNo == id select ad; var charge1 = charge.First(); ViewBag.total = charge1.totalExpense; ViewBag.Selected = new SelectList(ab.DepartmentCode, "value", "Text", charge1.fromDepartment); List <SelectListItem> list3 = new List <SelectListItem> { new SelectListItem { Text = "转向财务科", Value = "1" }, new SelectListItem { Text = "转向复印室", Value = "0" }, }; ViewBag.Selected1 = new SelectList(list3, "Value", "Text", charge1.whereTransfer); //Charger charger = new Charger(); long max_chargerID = ab.Charger.Max(d => d.ID); long newchargerID = max_chargerID + 1; string totle = Request.Form["total"]; string zhuanxiang = Request.Form["Selected1"]; string data = Request.Form["submitDate"]; string no = data.Replace("-", ""); if (action == "生成最大收费编号") { if (data.Contains("-")) { if (ModelState.IsValid) { var list1 = from ad in db.ArchivesContainer where ad.seqNo.Contains(no) orderby ad.ID descending select ad; if (list1.Count() != 0) { var list = list1.First(); long max_seqno = long.Parse(list.seqNo); long seqno = max_seqno + 1; archivesContainer.seqNo = seqno.ToString(); ViewBag.seqNo = archivesContainer.seqNo; ViewBag.totle = charge1.totalExpense; ViewBag.twoCentiCnt = archivesContainer.twoCentiCnt; ViewBag.thrCentiCnt = archivesContainer.thrCentiCnt; ViewBag.fourCentiCnt = archivesContainer.fourCentiCnt; ViewBag.fiveCentiCnt = archivesContainer.fiveCentiCnt; ViewBag.coverCnt = archivesContainer.coverCnt; ViewBag.catalogueCnt = archivesContainer.catalogueCnt; ViewBag.proformaCnt = archivesContainer.proformaCnt; } else { archivesContainer.seqNo = no + "001"; ViewBag.seqNo = archivesContainer.seqNo; ViewBag.totle = charge1.totalExpense; ViewBag.twoCentiCnt = archivesContainer.twoCentiCnt; ViewBag.thrCentiCnt = archivesContainer.thrCentiCnt; ViewBag.fourCentiCnt = archivesContainer.fourCentiCnt; ViewBag.fiveCentiCnt = archivesContainer.fiveCentiCnt; ViewBag.coverCnt = archivesContainer.coverCnt; ViewBag.catalogueCnt = archivesContainer.catalogueCnt; ViewBag.proformaCnt = archivesContainer.proformaCnt; } } } else { Response.Write("<script >alert('请选择提交时间');window.history.back();</script >"); } } if (action == "保存") { if (ModelState.IsValid) { string NO = Request.Form["seqNo"]; archivesContainer.seqNo = NO; string person = Request.Form["Selected"]; archivesContainer.submitPerson = person; db.Entry(archivesContainer).State = EntityState.Modified; db.SaveChanges(); charge1.searchNo = archivesContainer.ID; charge1.totalExpense = decimal.Parse(totle); charge1.unitName = archivesContainer.DepartName; charge1.chargeTime = archivesContainer.submitDate; charge1.seqNo = archivesContainer.seqNo; charge1.theoryExpense = decimal.Parse(totle); charge1.whereTransfer = int.Parse(zhuanxiang); ab.Entry(charge1).State = EntityState.Modified; ab.SaveChanges(); return(RedirectToAction("Index")); } } return(View(archivesContainer)); }
public ActionResult Create([Bind(Include = "twoCentiCnt,thrCentiCnt,fourCentiCnt,fiveCentiCnt,coverCnt,catalogueCnt,proformaCnt,DepartName,submitDate,submitPerson,archiveBoxFee,archiveCataLogFee,singleBoxFee,singleCatalogFee")] ArchivesContainer archivesContainer) { var UserID = User.Identity.GetUserId(); var department1 = cb.AspNetUsers.Find(UserID).DepartmentName; var departmentid = ab.Charger.Where(a => a.@operator == department1).First().fromDepartment; ViewBag.Selected = new SelectList(ab.DepartmentCode, "value", "Text", departmentid); List <SelectListItem> list2 = new List <SelectListItem> { new SelectListItem { Text = "转向财务科", Value = "1" }, new SelectListItem { Text = "转向复印室", Value = "0" }, }; ViewBag.Selected1 = new SelectList(list2, "Value", "Text"); Charger charger = new Charger(); long max_ID = db.ArchivesContainer.Max(d => d.ID); long newID = max_ID + 1; long max_chargerID = ab.Charger.Max(d => d.ID); long newchargerID = max_chargerID + 1; string totle = Request.Form["total"]; string zhuanxiang = Request.Form["Selected1"]; string data = Request.Form["submitDate"]; string no = data.Replace("-", "") + "001"; DateTime date = DateTime.Parse(data); if (ModelState.IsValid) { var list1 = ab.Charger.Where(a => a.chargeTime == date).OrderByDescending(a => a.seqNo); //var list1 = ab.Charger.Where(a => a.seqNo.CompareTo(no) >= 0).OrderByDescending(a => a.seqNo); //where ad.seqNo.Substring(0,7)==no //orderby ad.searchNo descending //select ad; if (list1.Count() != 0) { var list = list1.First(); long max_seqno = long.Parse(list.seqNo); long seqno = max_seqno + 1; string person = Request.Form["Selected"]; archivesContainer.submitPerson = ab.DepartmentCode.Where(a => a.value == person).First().text; archivesContainer.ID = newID; archivesContainer.seqNo = seqno.ToString(); db.ArchivesContainer.Add(archivesContainer);//添加到ArchivesContainer charger.ID = newchargerID; charger.itemName = "档案盒及目录装具等费用"; charger.searchNo = archivesContainer.ID; charger.totalExpense = decimal.Parse(totle); charger.fromDepartment = "4"; charger.unitName = archivesContainer.DepartName; charger.chargeClassify = 8; charger.@operator = "办公室"; charger.chargeTime = archivesContainer.submitDate; charger.seqNo = archivesContainer.seqNo; charger.theoryExpense = decimal.Parse(totle); charger.whereTransfer = int.Parse(zhuanxiang); charger.remarks = Request.Form["remarks"]; charger.isCharge = false; charger.isBack = false; charger.chargeExtra = ""; charger.buildingArea = 0; charger.chargeDetail = ""; charger.charger1 = ""; charger.remarks = ""; charger.backNote = ""; charger.centiCnt = 0; ab.Charger.Add(charger);//添加到charger } else { string person = Request.Form["Selected"]; archivesContainer.submitPerson = ab.DepartmentCode.Where(a => a.value == person).First().text;; archivesContainer.ID = newID; archivesContainer.seqNo = no; db.ArchivesContainer.Add(archivesContainer); charger.ID = newchargerID; charger.itemName = "档案盒及目录装具等费用"; charger.searchNo = archivesContainer.ID; charger.totalExpense = decimal.Parse(totle); charger.fromDepartment = "4"; charger.unitName = archivesContainer.DepartName; charger.chargeClassify = 8; charger.@operator = "办公室"; charger.chargeTime = archivesContainer.submitDate; charger.seqNo = archivesContainer.seqNo; charger.theoryExpense = decimal.Parse(totle); charger.whereTransfer = int.Parse(zhuanxiang); charger.isCharge = false; charger.isBack = false; charger.chargeExtra = ""; charger.buildingArea = 0; charger.chargeDetail = ""; charger.charger1 = ""; charger.remarks = ""; charger.backNote = ""; charger.centiCnt = 0; ab.Charger.Add(charger); } db.SaveChanges(); ab.SaveChanges(); return(RedirectToAction("Index")); } return(View(archivesContainer)); }