public ActionResult SeeSettle(long?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
var test = from ad in db.vw_archiveQueryList
where (ad.projectID == id)
select ad;
vw_archiveQueryList archive = test.First();
//文本框赋值
ViewData["character1cm"] = archive.character1cm;
ViewData["character2cm"] = archive.character2cm;
ViewData["character3cm"] = archive.character3cm;
ViewData["character4cm"] = archive.character4cm;
ViewData["character5cm"] = archive.character5cm;
ViewData["drawing1cm"] = archive.drawing1cm;
ViewData["drawing2cm"] = archive.drawing2cm;
ViewData["drawing3cm"] = archive.drawing3cm;
ViewData["drawing4cm"] = archive.drawing4cm;
ViewData["drawing5cm"] = archive.drawing5cm;
if (archive == null)
{
return(HttpNotFound());
}
return(View(archive));
}
public ActionResult SeeSettle([Bind(Include = "InchCountDetail,characterVolumeCount,character1cm,character2cm,character3cm,character4cm,character5cm,originalVolumeCount,originalInchCount,drawingVolumeCount,drawing1cm,drawing2cm,drawing3cm,drawing4cm,drawing5cm,copyInchCount")] vw_archiveQueryList archiveQueryList, string action, long?id, string id2)
{
var paper = from ad in db.PaperArchives
where (ad.projectID == id)
select ad;
PaperArchives paperArchive = paper.First();
var project = from ac in db.ProjectInfo
where (ac.projectID == id)
select ac;
ProjectInfo projectinfo = project.First();
paperArchive.InchCountDetail = archiveQueryList.InchCountDetail;
paperArchive.character1cm = archiveQueryList.character1cm;
paperArchive.character2cm = archiveQueryList.character2cm;
paperArchive.character3cm = archiveQueryList.character3cm;
paperArchive.character4cm = archiveQueryList.character4cm;
paperArchive.character5cm = archiveQueryList.character5cm;
//ViewData["characterVolumeCount"] = archiveQueryList.character2cm + archiveQueryList.character3cm + archiveQueryList.character4cm + archiveQueryList.character5cm;
paperArchive.characterVolumeCount = archiveQueryList.character1cm + archiveQueryList.character2cm + archiveQueryList.character3cm + archiveQueryList.character4cm + archiveQueryList.character5cm;
paperArchive.drawing1cm = archiveQueryList.drawing1cm;
paperArchive.drawing2cm = archiveQueryList.drawing2cm;
paperArchive.drawing3cm = archiveQueryList.drawing3cm;
paperArchive.drawing4cm = archiveQueryList.drawing4cm;
paperArchive.drawing5cm = archiveQueryList.drawing5cm;
//ViewData["drawingVolumeCount"] = archiveQueryList.drawing2cm + archiveQueryList.drawing3cm + archiveQueryList.drawing4cm + archiveQueryList.drawing5cm;
paperArchive.drawingVolumeCount = archiveQueryList.drawing1cm + archiveQueryList.drawing2cm + archiveQueryList.drawing3cm + archiveQueryList.drawing4cm + archiveQueryList.drawing5cm;
//ViewData["originalVolumeCount"] = paperArchive.characterVolumeCount + paperArchive.drawingVolumeCount;
//ViewData["originalInchCount"] = (archiveQueryList.character2cm + archiveQueryList.drawing2cm) * 2 + (archiveQueryList.character3cm + archiveQueryList.drawing3cm) * 3 + (archiveQueryList.character4cm + archiveQueryList.drawing4cm) * 4 + (archiveQueryList.character5cm + archiveQueryList.drawing5cm) * 5;
paperArchive.originalVolumeCount = archiveQueryList.character2cm + archiveQueryList.character3cm + archiveQueryList.character4cm + archiveQueryList.character5cm + archiveQueryList.drawing2cm + archiveQueryList.drawing3cm + archiveQueryList.drawing4cm + archiveQueryList.drawing5cm;
paperArchive.originalInchCount = (archiveQueryList.character2cm + archiveQueryList.drawing2cm) * 2 + (archiveQueryList.character3cm + archiveQueryList.drawing3cm) * 3 + (archiveQueryList.character4cm + archiveQueryList.drawing4cm) * 4 + (archiveQueryList.character5cm + archiveQueryList.drawing5cm) * 5;
paperArchive.copyInchCount = archiveQueryList.copyInchCount;
paperArchive.archivesCount = (paperArchive.characterVolumeCount + paperArchive.drawingVolumeCount).ToString();
if (action == "修改")
{
if (Convert.ToInt32(projectinfo.status) == 3 || Convert.ToInt32(projectinfo.status) == 5)
{
ViewData["onlyread"] = false;
}
else
{
ViewData["onlyread"] = true;
}
if (Convert.ToInt32(projectinfo.status) == 4)
{
projectinfo.status = "9";
}
if (ModelState.IsValid)
{
db.Entry(paperArchive).State = EntityState.Modified;
db.Entry(projectinfo).State = EntityState.Modified;
db.SaveChanges();
if (id2 == "1")
{
return(Content("<script >alert('修改成功');window.location.href='../StatisticalAndRetrieval/StatisticalAndAnalysis';</script >"));
}
if (id2 == "2")
{
return(Content("<script >alert('修改成功');window.location.href='../StatisticalAndRetrieval/AllArchives';</script >"));
}
}
}
if (action == "返回")
{
if (id2 == "2")
{
return(RedirectToAction("AllArchives"));
}
else
{
return(RedirectToAction("StatisticalAndAnalysis"));
}
}
return(View());
}
public ActionResult SeeSettle([Bind(Include = "InchCountDetail,characterVolumeCount,character2cm,character3cm,character4cm,character5cm,originalVolumeCount,originalInchCount,drawingVolumeCount,drawing2cm,drawing3cm,drawing4cm,drawing5cm,copyInchCount")] vw_archiveQueryList archiveQueryList, string action, long?id)
{
var paper = from ad in bb.gxPaperArchives
where (ad.projectID == id)
select ad;
gxPaperArchives paperArchive = paper.First();
var project = from ac in bb.gxProjectInfo
where (ac.projectID == id)
select ac;
gxProjectInfo projectinfo = project.First();
paperArchive.InchCountDetail = archiveQueryList.InchCountDetail;
paperArchive.character2cm = archiveQueryList.character2cm;
paperArchive.character3cm = archiveQueryList.character3cm;
paperArchive.character4cm = archiveQueryList.character4cm;
paperArchive.character5cm = archiveQueryList.character5cm;
//ViewData["characterVolumeCount"] = archiveQueryList.character2cm + archiveQueryList.character3cm + archiveQueryList.character4cm + archiveQueryList.character5cm;
paperArchive.characterVolumeCount = archiveQueryList.character2cm + archiveQueryList.character3cm + archiveQueryList.character4cm + archiveQueryList.character5cm;
paperArchive.drawing2cm = archiveQueryList.drawing2cm;
paperArchive.drawing3cm = archiveQueryList.drawing3cm;
paperArchive.drawing4cm = archiveQueryList.drawing4cm;
paperArchive.drawing5cm = archiveQueryList.drawing5cm;
//ViewData["drawingVolumeCount"] = archiveQueryList.drawing2cm + archiveQueryList.drawing3cm + archiveQueryList.drawing4cm + archiveQueryList.drawing5cm;
paperArchive.drawingVolumeCount = archiveQueryList.drawing2cm + archiveQueryList.drawing3cm + archiveQueryList.drawing4cm + archiveQueryList.drawing5cm;
//ViewData["originalVolumeCount"] = paperArchive.characterVolumeCount + paperArchive.drawingVolumeCount;
//ViewData["originalInchCount"] = (archiveQueryList.character2cm + archiveQueryList.drawing2cm) * 2 + (archiveQueryList.character3cm + archiveQueryList.drawing3cm) * 3 + (archiveQueryList.character4cm + archiveQueryList.drawing4cm) * 4 + (archiveQueryList.character5cm + archiveQueryList.drawing5cm) * 5;
paperArchive.originalVolumeCount = archiveQueryList.character2cm + archiveQueryList.character3cm + archiveQueryList.character4cm + archiveQueryList.character5cm + archiveQueryList.drawing2cm + archiveQueryList.drawing3cm + archiveQueryList.drawing4cm + archiveQueryList.drawing5cm;
paperArchive.originalInchCount = (archiveQueryList.character2cm + archiveQueryList.drawing2cm) * 2 + (archiveQueryList.character3cm + archiveQueryList.drawing3cm) * 3 + (archiveQueryList.character4cm + archiveQueryList.drawing4cm) * 4 + (archiveQueryList.character5cm + archiveQueryList.drawing5cm) * 5;
paperArchive.copyInchCount = archiveQueryList.copyInchCount;
paperArchive.archivesCount = (paperArchive.characterVolumeCount + paperArchive.drawingVolumeCount).ToString();
if (action == "修改")
{
if (Convert.ToInt32(projectinfo.status) == 3 || Convert.ToInt32(projectinfo.status) == 5)
{
ViewData["onlyread"] = false;
}
else
{
ViewData["onlyread"] = true;
}
if (Convert.ToInt32(projectinfo.status) == 4)
{
projectinfo.status = "9";
}
if (ModelState.IsValid)
{
bb.Entry(paperArchive).State = EntityState.Modified;
bb.Entry(projectinfo).State = EntityState.Modified;
bb.SaveChanges();
return(RedirectToAction("informationzhengli", "gxPaperSettle"));
}
}
if (action == "返回")
{
return(RedirectToAction("StatisticalAndAnalysis"));
}
return(View());
}
