public ActionResult Create([Bind(Include = "isNeibu,seqNo,boxNo,archiveNo,regisNo,paijiaNo,archiveTitle,archiveCode,bianzhiUnit,bianzhiDate,securityID,retentionPeriodID,archiveBoxCnt,archiveBoxNo,pageCnt,inchCnt,classifyID,isArchive,textMatirial,drawing,photo,status,yearNo,classify,boxID,projectCnt,projectNo,ID,ArchiveThick,storeLocation,receiveTime,luruTime,classSeqNo,isYD,lururen")] PlanArchiveBox planArchiveBox, int ID, int classifyID, string box, string isYD, String action)
{
if (action == "录入该卷工程")
{
return(RedirectToAction("Create", "PlanProjects1", new { classifyID = planArchiveBox.classifyID, id = 0, id1 = 0 }));
}
if (action == "删除该案卷")
{
PlanArchiveBox planArchiveBox_temp = db_plan.PlanArchiveBox.Find(ID);
if (planArchiveBox_temp != null)
{
db_plan.PlanArchiveBox.Remove(planArchiveBox_temp);
var planProject_temp = db_plan.PlanProject.Where(d => d.archiveID == ID).ToList();
foreach (var item in planProject_temp)//删除案卷的同时删除相关卷内目录
{
db_plan.PlanProject.Remove(item);
}
db_plan.SaveChanges();
return(Content("<script >alert('删除成功！');window.history.back();</script >"));
}
}
else if (action == "添加下一卷")
{
//planArchiveBox.ID = ID;
if (planArchiveBox.archiveBoxNo >= planArchiveBox.archiveBoxCnt)
{
return(RedirectToAction("Create", new { ID = 0, classifyID = planArchiveBox.classifyID }));
}
else
{
return(RedirectToAction("Create", new { ID = planArchiveBox.ID, classifyID = classifyID, id3 = 0 }));
}
}
if (action == "打印备考表")
{
return(RedirectToAction("beikaobiao", new { id = ID }));
}
if (action == "打印案卷封皮")
{
return(RedirectToAction("GuiHuaAnJuanFengPi", new { id = ID }));
}
if (action == "打印案卷（工程）封皮")
{
return(RedirectToAction("GuiHuaAnJuanGongChengFengPi", new { id = ID }));
}
if (action == "打印工程封皮")
{
return(RedirectToAction("GuiHuaGongChengFengPi", new { id = ID }));
}
if (action == "打印卷内目录")
{
return(RedirectToAction("JuanNeiMuLu", new { id = ID }));
}
return(View(planArchiveBox));
}
// GET: PlanArchiveBoxes/Delete/5
//public ActionResult Delete(int? id)
//{
// if (id == null)
// {
// return new HttpStatusCodeResult(HttpStatusCode.BadRequest);
// }
// PlanArchiveBox planArchiveBox = db_plan.PlanArchiveBox.Find(id);
// if (planArchiveBox == null)
// {
// return HttpNotFound();
// }
// return View(planArchiveBox);
//}
//// POST: PlanArchiveBoxes/Delete/5
//[HttpPost, ActionName("Delete")]
//[ValidateAntiForgeryToken]
public ActionResult Delete(int id, int?classifyID)
{
PlanArchiveBox planArchiveBox = db_plan.PlanArchiveBox.Find(id);
db_plan.PlanArchiveBox.Remove(planArchiveBox);
db_plan.SaveChanges();
return(Content("<script>alert('已成功删除！');window.location.href='/PlanArchiveBoxes/Index/?classifyID=" + classifyID + "';</script>"));
//return RedirectToAction("Index");
}
public string baocun(string ID, string box, string boxID, string classifyID, string boxNo, string archiveBoxCnt, string archiveBoxNo, string yearNo, string name)
{
string flag = "0";//初始状态为0
if (name == "baocun")
{
PlanArchiveBox planArchive = new PlanArchiveBox();
planArchive.seqNo = 0;
planArchive.storeLocation = "青岛城建档案馆";
planArchive.boxID = boxID.Trim();
planArchive.boxNo = boxNo.Trim();
planArchive.archiveCode = "437402";
planArchive.bianzhiUnit = "青岛市规划局";
planArchive.yearNo = yearNo;
planArchive.archiveBoxCnt = Int32.Parse(archiveBoxCnt);
planArchive.archiveBoxNo = Int32.Parse(archiveBoxNo);
long max_ID = db_plan.PlanArchiveBox.Max(d => d.ID);
planArchive.ID = int.Parse(max_ID.ToString()) + 1; //新记录的ID+1，值唯一
planArchive.isNeibu = "是";
flag = planArchive.ID.ToString(); //将盒子的ID传到前台，以备后用
planArchive.status = "LR";
planArchive.classifyID = Int32.Parse(classifyID.Trim());
//try
//{
flag = planArchive.ID.ToString().Trim();
db_plan.PlanArchiveBox.Add(planArchive);
db_plan.SaveChanges();
return(flag); //保存成功
//}
//catch(Exception ex)
//{
// flag = "2";
// return flag;//保存失败
//}
}
return(flag);
}
// GET: PlanArchiveBoxes/Create
public ActionResult Create(int?ID, int?classifyID, string id3)
{
var UserID = User.Identity.GetUserId();//获取当前用户
var user = db_user.AspNetUsers.Find(UserID);
ViewBag.lururen = user.UserName;
var test = from ad in db_plan.PlanArchiveBox
where ad.status == "LR"
where ad.seqNo == 0
where ad.classifyID == classifyID
where ad.lururen == user.UserName
orderby ad.ID descending
select ad; //查找状态为录入且录入人为当前用户的记录，并按year排(降)序
int clas = Convert.ToInt32(classifyID);
var test1 = from b in db_plan.PlanArchiveClassify //为了拼接出盒号
where b.classifyID == clas
select b;
PlanArchiveBox planArchiveBox = test.FirstOrDefault <PlanArchiveBox>();
if (ID != 0 && ID != null && id3 == "0")//加入标识符id3的目的是判断它是从添加下一卷的按钮来的，而不是从录入完卷内目录返回而来
{
var test2 = from a in db_plan.PlanArchiveBox
where a.ID == ID
select a;
planArchiveBox = test2.First();
int?cnt = Convert.ToInt32(test2.First().archiveBoxNo) + 1;
planArchiveBox.archiveBoxNo = cnt;
}
if (ID != 0 && ID != null)//卷内文件录入完毕，返回案卷录入，保留之前录入的信息
{
var test3 = from a in db_plan.PlanArchiveBox
where a.ID == ID
select a;
planArchiveBox = test3.First();
}
ViewBag.ID = 0;
ViewBag.classifyID = classifyID;
ViewBag.classify = test1.First().classifyName.Trim();
ViewBag.box = test1.First().classifyName.Trim() + "-" + test1.First().classifySX.Trim();//盒号（注意是显示盒号的一部分，并不是数据库中完整的盒号boxNo）
return(View(planArchiveBox));
}
// GET: PlanArchiveBoxes/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
PlanArchiveBox planArchiveBox = db_plan.PlanArchiveBox.Find(id);
List <SelectListItem> list = new List <SelectListItem> {
};
for (int i = 1; i < 6; i++)
{
SelectListItem item = new SelectListItem();
item.Text = i.ToString() + "厘米";
item.Value = i.ToString();
list.Add(item);
}
ViewBag.ArchiveThick = new SelectList(list, "Value", "Text", planArchiveBox.ArchiveThick);
//档案密级
ViewBag.securityID = new SelectList(db_urban.SecurityClassification, "securityID", "securityName", planArchiveBox.securityID);
//保管年限(注意这里与)
ViewBag.retentionPeriodID = new SelectList(db_urban.RetentionPeriod, "retentionPeriodNo", "retentionPeriodName", planArchiveBox.retentionPeriodID);
//是否为内部文件
List <SelectListItem> listNeibu = new List <SelectListItem> {
new SelectListItem {
Text = "公开", Value = "0"
},
new SelectListItem {
Text = "内部", Value = "1"
},
new SelectListItem {
Text = "公开/内部", Value = "2"
}
};
ViewBag.isNeibu = new SelectList(listNeibu, "Value", "Text", planArchiveBox.isNeibu.ToString().Trim());
if (planArchiveBox == null)
{
return(HttpNotFound());
}
return(View(planArchiveBox));
}
public ActionResult Edit(string action, [Bind(Include = "isNeibu,seqNo,boxNo,archiveNo,regisNo,paijiaNo,archiveTitle,archiveCode,bianzhiUnit,bianzhiDate,securityID,retentionPeriodID,archiveBoxCnt,archiveBoxNo,pageCnt,inchCnt,classifyID,isArchive,textMatirial,drawing,photo,status,yearNo,classify,boxID,projectCnt,projectNo,ID,ArchiveThick,storeLocation,receiveTime,luruTime,classSeqNo,isYD")] PlanArchiveBox planArchiveBox)
{
List <SelectListItem> list = new List <SelectListItem> {
};
for (int i = 1; i < 6; i++)
{
SelectListItem item = new SelectListItem();
item.Text = i.ToString() + "厘米";
item.Value = i.ToString();
list.Add(item);
}
ViewBag.ArchiveThick = new SelectList(list, "Value", "Text", planArchiveBox.ArchiveThick);
//是否异地
//档案密级
ViewBag.securityID = new SelectList(db_urban.SecurityClassification, "securityID", "securityName", planArchiveBox.securityID);
//保管年限(注意这里与)
ViewBag.retentionPeriodID = new SelectList(db_urban.RetentionPeriod, "retentionPeriodNo", "retentionPeriodName", planArchiveBox.retentionPeriodID);
//是否为内部文件
List <SelectListItem> listNeibu = new List <SelectListItem> {
new SelectListItem {
Text = "公开", Value = "0"
},
new SelectListItem {
Text = "内部", Value = "1"
},
new SelectListItem {
Text = "公开/内部", Value = "2"
}
};
ViewBag.isNeibu = new SelectList(listNeibu, "Value", "Text", planArchiveBox.isNeibu.ToString().Trim());
ViewBag.box = planArchiveBox.boxNo;//将boxNo的盒号部分传递给前台显示
if (action == "修改并提交")
{
if (ModelState.IsValid)
{
var classifyID = planArchiveBox.classifyID;
db_plan.Entry(planArchiveBox).State = EntityState.Modified;
db_plan.SaveChanges();
ViewData["div1"] = "display:block";
ViewData["fengpi"] = true;
ViewData["beikaobiao"] = false;
ViewData["juanneimulu"] = true;
return(Content("<script>alert('修改成功');window.location.href='/PlanArchiveBoxes/Index/?classifyID=" + classifyID + "';</script>"));
}
}
if (action == "该卷文件目录")
{
return(RedirectToAction("Index", "PlanProjects", new { archiveID = planArchiveBox.ID, classifyID = planArchiveBox.classifyID }));
}
//if (action == "删除该案卷")
//{
// PlanArchiveBox planArchiveBox_remove = db_plan.PlanArchiveBox.Find(planArchiveBox.ID);
// db_plan.PlanArchiveBox.Remove(planArchiveBox_remove);
// var planProject_temp = db_plan.PlanProject.Where(d => d.archiveID == planArchiveBox.ID).ToList();
// foreach (var item in planProject_temp)//删除案卷的同时删除相关卷内目录
// {
// db_plan.PlanProject.Remove(item);
// }
// db_plan.SaveChanges();
// return Content("<script>alert('删除成功');window.location.href='" + url + "';</script>");
//}
if (action == "打印备考表")
{
return(RedirectToAction("beikaobiao", new { id = planArchiveBox.ID }));
}
if (action == "打印案卷封皮")
{
return(RedirectToAction("GuiHuaAnJuanFengPi", new { id = planArchiveBox.ID }));
}
if (action == "打印案卷（工程）封皮")
{
return(RedirectToAction("GuiHuaAnJuanGongChengFengPi", new { id = planArchiveBox.ID }));
}
if (action == "打印工程封皮")
{
return(RedirectToAction("GuiHuaGongChengFengPi", new { id = planArchiveBox.ID }));
}
if (action == "打印卷内目录")
{
return(RedirectToAction("JuanNeiMuLu", new { id = planArchiveBox.ID }));
}
if (action == "返回")
{
var UserID = User.Identity.GetUserId();//获取当前用户
var user = db_user.AspNetUsers.Find(UserID).RoleName;
var classifyID = planArchiveBox.classifyID;
if (user == "高级用户")
{
classifyID = null;
}
return(RedirectToAction("Index", new { status = planArchiveBox.status.Trim(), archiveID = planArchiveBox.ID, classifyID = classifyID }));//返回上一页面
}
return(View(planArchiveBox));
}
// GET: PlanArchiveBoxes/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
PlanArchiveBox planArchiveBox = db_plan.PlanArchiveBox.Find(id);
if (planArchiveBox == null)
{
return(HttpNotFound());
}
List <SelectListItem> list = new List <SelectListItem> {
};
for (int i = 1; i < 6; i++)
{
SelectListItem item = new SelectListItem();
item.Text = i.ToString() + "厘米";
item.Value = i.ToString();
list.Add(item);
}
ViewBag.ArchiveThick = new SelectList(list, "Value", "Text", planArchiveBox.ArchiveThick);
//是否异地
//档案密级
ViewBag.securityID = new SelectList(db_urban.SecurityClassification, "securityID", "securityName", planArchiveBox.securityID);
//保管年限(注意这里与)
ViewBag.retentionPeriodID = new SelectList(db_urban.RetentionPeriod, "retentionPeriodNo", "retentionPeriodName", planArchiveBox.retentionPeriodID);
//是否为内部文件
List <SelectListItem> listNeibu = new List <SelectListItem> {
new SelectListItem {
Text = "公开", Value = "0"
},
new SelectListItem {
Text = "内部", Value = "1"
},
new SelectListItem {
Text = "公开/内部", Value = "2"
}
};
ViewBag.isNeibu = new SelectList(listNeibu, "Value", "Text", planArchiveBox.isNeibu.ToString().Trim());
ViewBag.box = planArchiveBox.boxNo;//将boxNo的盒号部分传递给前台显示
if (planArchiveBox.status.ToString().Trim() == "LR")
{
ViewData["div1"] = "display:block";
ViewData["fengpi"] = true;
ViewData["beikaobiao"] = false;
ViewData["juanneimulu"] = true;
//jsy
return(View(planArchiveBox));
}
if (planArchiveBox.ToString().Trim() == "GD")
{
ViewData["div1"] = "display:block";
ViewData["fengpi"] = false;
ViewData["beikaobiao"] = false;
ViewData["juanneimulu"] = false;
//jsy
return(View(planArchiveBox));
}
return(View(planArchiveBox));
}
