public ActionResult subreadwriteedit(subreadwrite chks, string sysflag, int?page, string orderdata, string orderdata1) { ModelState.Clear(); page = ((!page.HasValue || page < 1) ? 1 : page); ViewBag.page = page; if (string.IsNullOrWhiteSpace(orderdata)) { orderdata = "srwid"; } if (string.IsNullOrWhiteSpace(orderdata1)) { orderdata1 = "asc"; } ViewBag.orderdata = orderdata; ViewBag.orderdata1 = orderdata1; string qsublevelname = ""; if (!string.IsNullOrWhiteSpace(Request["qsublevelname"])) { qsublevelname = Request["qsublevelname"].Trim(); ViewBag.qsublevelname = qsublevelname; } NDcommon dbobj = new NDcommon(); string tmpsid = dbobj.checknumber(Request["tmpsid"]); int tmpsid1 = 0; int tmpsrwid = int.Parse(Request["srwid"].ToString()); if (!string.IsNullOrEmpty(tmpsid)) { tmpsid1 = int.Parse(tmpsid); } if (sysflag != "E") { using (Aitag_DBContext con = new Aitag_DBContext()) { var data = con.subreadwrite.Where(r => r.srwid == tmpsrwid).FirstOrDefault(); subreadwrite esublevel1s = con.subreadwrite.Find(tmpsrwid); if (esublevel1s == null) { return(HttpNotFound()); } return(View(esublevel1s)); } } else { if (!ModelState.IsValid) { return(View(chks)); } else { using (Aitag_DBContext con = new Aitag_DBContext()) { chks.sid = int.Parse(Request["tmpsid"].ToString()); chks.dptgroup = Request["dptgroup"]; chks.empgroup = Request["empgroup"]; chks.comid = Session["comid"].ToString(); chks.BMODID = Session["tempid"].ToString(); chks.BMODDATE = DateTime.Now; con.Entry(chks).State = EntityState.Modified; con.SaveChanges(); //系統LOG檔 //================================================= // SqlConnection sysconn = dbobj.get_conn("Aitag_DBContext"); string sysrealsid = Request["sysrealsid"].ToString(); string syssubname = dbobj.get_sysmenuname(sysconn, sysrealsid, "2"); string sysnote = "調整id:" + Request["tmpsid"].ToString() + "的權限"; dbobj.systemlog(sysconn, syssubname, sysnote, Session["tempid"].ToString(), Session["sldate"].ToString(), Session["sfip"].ToString(), sysflag); sysconn.Close(); sysconn.Dispose(); //================================================= string tmpform = ""; tmpform = "<body onload=qfr1.submit();>"; tmpform += "<form name='qfr1' action='/sublevel1/subreadwritelist' method='post'>"; tmpform += "<input type=hidden name='sysflag' id='sysflag' value='" + sysflag + "'>"; tmpform += "<input type=hidden name='page' id='page' value='" + page + "'>"; tmpform += "<input type=hidden name='orderdata' id='orderdata' value='" + orderdata + "'>"; tmpform += "<input type=hidden name='orderdata1' id='orderdata1' value='" + orderdata1 + "'>"; tmpform += "<input type=hidden id='qsublevelname' name='qsublevelname' value='" + qsublevelname + "'>"; tmpform += "<input type=hidden name='tmpsid' id='tmpsid' value='" + Request["tmpsid"].ToString() + "'>"; tmpform += "</form>"; tmpform += "</body>"; return(new ContentResult() { Content = @"<script>alert('修改成功!!');</script>" + tmpform }); } } } }
public ActionResult subreadwriteadd(subreadwrite col, string sysflag, int?page, string orderdata, string orderdata1) { ModelState.Clear(); page = ((!page.HasValue || page < 1) ? 1 : page); ViewBag.page = page; if (string.IsNullOrWhiteSpace(orderdata)) { orderdata = "srwid"; } if (string.IsNullOrWhiteSpace(orderdata1)) { orderdata1 = "asc"; } ViewBag.orderdata = orderdata; ViewBag.orderdata1 = orderdata1; string qsublevelname = ""; if (!string.IsNullOrWhiteSpace(Request["qsublevelname"])) { qsublevelname = Request["qsublevelname"].Trim(); ViewBag.qsublevelname = qsublevelname; } if (sysflag != "A") { subreadwrite newcol = new subreadwrite(); return(View(newcol)); } else { if (!ModelState.IsValid) { return(View(col)); } else { Aitag.Models.NDcommon dbobj = new Aitag.Models.NDcommon(); col.dptgroup = Request["dptgroup"]; col.empgroup = Request["empgroup"]; col.sid = int.Parse(Request["tmpsid"].ToString()); col.comid = Session["comid"].ToString(); col.BMODID = Session["tempid"].ToString(); col.BMODDATE = DateTime.Now; using (Aitag_DBContext con = new Aitag_DBContext()) { con.subreadwrite.Add(col); con.SaveChanges(); //系統LOG檔 //================================================= // SqlConnection sysconn = dbobj.get_conn("Aitag_DBContext"); string sysrealsid = Request["sysrealsid"].ToString(); string syssubname = dbobj.get_sysmenuname(sysconn, sysrealsid, "2"); string sysnote = "主目錄id:" + Request["tmpsid"]; dbobj.systemlog(sysconn, syssubname, sysnote, Session["tempid"].ToString(), Session["sldate"].ToString(), Session["sfip"].ToString(), sysflag); sysconn.Close(); sysconn.Dispose(); //================================================= } string tmpform = ""; tmpform = "<body onload=qfr1.submit();>"; tmpform += "<form name='qfr1' action='/sublevel1/subreadwritelist' method='post'>"; tmpform += "<input type=hidden name='sysflag' id='sysflag' value='" + sysflag + "'>"; tmpform += "<input type=hidden name='page' id='page' value='" + page + "'>"; tmpform += "<input type=hidden name='orderdata' id='orderdata' value='" + orderdata + "'>"; tmpform += "<input type=hidden name='orderdata1' id='orderdata1' value='" + orderdata1 + "'>"; tmpform += "<input type=hidden id='qsublevelname' name='qsublevelname' value='" + qsublevelname + "'>"; tmpform += "<input type=hidden id='tmpsid' name='tmpsid' value='" + Request["tmpsid"] + "'>"; tmpform += "</form>"; tmpform += "</body>"; string tgourl = "/sublevel1/List?page=" + page + "&qsublevelname=" + qsublevelname; return(new ContentResult() { Content = @"<script>alert('新增成功!!');</script>" + tmpform }); // return RedirectToAction("List"); } } }