//[HttpGet] //public ActionResult Add() //{ // ViewBag.Ifboss = Session["Ifboss"].ToString(); // ViewBag.Msid = Session["Msid"].ToString(); // workitem col = new workitem(); // return View(col); //} //[HttpPost] public ActionResult add(workitem 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 = "corp_no"; } if (string.IsNullOrWhiteSpace(orderdata1)) { orderdata1 = "desc"; } ViewBag.orderdata = orderdata; ViewBag.orderdata1 = orderdata1; string qcorp_no = "", qworkitem = ""; if (!string.IsNullOrWhiteSpace(Request["qcorp_no"])) { qcorp_no = Request["qcorp_no"].Trim(); ViewBag.qcorp_no = qcorp_no; } if (!string.IsNullOrWhiteSpace(Request["qworkitem"])) { qworkitem = Request["qworkitem"].Trim(); ViewBag.qworkitem = qworkitem; } if (sysflag != "A") { workitem newcol = new workitem(); return(View(newcol)); } else { if (!ModelState.IsValid) { return(View(col)); } else { Aitag.Models.NDcommon dbobj = new Aitag.Models.NDcommon(); SqlConnection conn = dbobj.get_conn("AitagBill_DBContext"); SqlDataReader dr; SqlCommand sqlsmd = new SqlCommand(); sqlsmd.Connection = conn; string sqlstr = "select corp_no from workitem where corp_no = '" + col.corp_no + "' and work_no_code = '" + col.work_no_code + "'"; sqlsmd.CommandText = sqlstr; dr = sqlsmd.ExecuteReader(); if (dr.Read()) { ModelState.AddModelError("", "項目代碼重複!"); return(View(col)); } dr.Close(); dr.Dispose(); sqlsmd.Dispose(); conn.Close(); conn.Dispose(); col.comid = Session["comid"].ToString(); col.bmodid = Session["tempid"].ToString(); col.hourgroup = Request["hourgroup"].Trim(); col.bmoddate = DateTime.Now; using (AitagBill_DBContext con = new AitagBill_DBContext()) { con.workitem.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 = "所屬公司:" + col.corp_no + "項目代碼:" + col.work_no_code + "項目名稱:" + col.workitemname; 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='/workitem/List' 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='qcorp_no' name='qcorp_no' value='" + qcorp_no + "'>"; tmpform += "<input type=hidden id='qworkitem' name='qworkitem' value='" + qworkitem + "'>"; tmpform += "</form>"; tmpform += "</body>"; return(new ContentResult() { Content = @"" + tmpform }); // return RedirectToAction("List"); } } }
public ActionResult Edit(workitem 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 = "corp_no"; } if (string.IsNullOrWhiteSpace(orderdata1)) { orderdata1 = "desc"; } ViewBag.orderdata = orderdata; ViewBag.orderdata1 = orderdata1; string qcorp_no = "", qwork_no_code = "", qworkitemname = ""; if (!string.IsNullOrWhiteSpace(Request["qcorp_no"])) { qcorp_no = Request["qcorp_no"].Trim(); ViewBag.qcorp_no = qcorp_no; } if (!string.IsNullOrWhiteSpace(Request["qwork_no_code"])) { qwork_no_code = Request["qwork_no_code"].Trim(); ViewBag.qwork_no_code = qwork_no_code; } if (!string.IsNullOrWhiteSpace(Request["qworkitemname"])) { qworkitemname = Request["qworkitemname"].Trim(); ViewBag.qwork_no_code = qworkitemname; } if (sysflag != "E") { using (AitagBill_DBContext con = new AitagBill_DBContext()) { var data = con.workitem.Where(r => r.corp_no == chks.corp_no && r.work_no_code == chks.work_no_code).FirstOrDefault(); if (data == null) { return(HttpNotFound()); } return(View(data)); } } else { if (!ModelState.IsValid) { return(View(chks)); } else { using (AitagBill_DBContext con = new AitagBill_DBContext()) { NDcommon dbobj = new NDcommon(); chks.hourgroup = Request["hourgroup"].Trim(); 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 = "所屬公司:" + chks.corp_no + "項目代碼:" + chks.work_no_code + "項目名稱:" + chks.workitemname; 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='/workitem/List' 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='qcorp_no' name='qcorp_no' value='" + qcorp_no + "'>"; tmpform += "<input type=hidden id='qwork_no_code' name='qwork_no_code' value='" + qwork_no_code + "'>"; tmpform += "<input type=hidden id='qworkitemname' name='qworkitemname' value='" + qworkitemname + "'>"; tmpform += "</form>"; tmpform += "</body>"; return(new ContentResult() { Content = @"" + tmpform }); //return RedirectToAction("List"); } } } }