public ActionResult certifyformdo(string barcode) { certifystampstock cer = _db.Certifystampstock.Where(e => e.barcode == barcode && e.ifrand == "n").SingleOrDefault(); looknumber look = _db.lookNumber.Where(e => e.barcode == barcode).SingleOrDefault(); string item = ""; if (cer == null) { return(RedirectToAction("certifynon", "certify")); } else { if (look != null) { look.lookno += 1; look.bmoddate = DateTime.Now; _db.Entry(look).State = System.Data.Entity.EntityState.Modified; _db.SaveChanges(); } else { looknumber _looknumber = new looknumber() { barcode = barcode, lookno = 1, bmoddate = DateTime.Now }; _db.lookNumber.Add(_looknumber); _db.SaveChanges(); } } return(RedirectToAction("certification", "certify", new { @barcode = barcode, @randno = item, @codno = cer.codno, @codid = cer.codid })); }
//[HttpGet] //public ActionResult Add() //{ // ViewBag.Ifboss = Session["Ifboss"].ToString(); // ViewBag.Msid = Session["Msid"].ToString(); // certifystampstock col = new certifystampstock(); // return View(col); //} //[HttpPost] public ActionResult add(certifystampstock 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 = "csid"; } if (string.IsNullOrWhiteSpace(orderdata1)) { orderdata1 = "desc"; } ViewBag.orderdata = orderdata; ViewBag.orderdata1 = orderdata1; string qbarcode = "", qcerno = ""; if (!string.IsNullOrWhiteSpace(Request["qbarcode"])) { qbarcode = Request["qbarcode"].Trim(); ViewBag.qbarcode = qbarcode; } if (!string.IsNullOrWhiteSpace(Request["qcerno"])) { qcerno = Request["qcerno"].Trim(); ViewBag.qcerno = qcerno; } if (sysflag != "A") { certifystampstock newcol = new certifystampstock(); return(View(newcol)); } else { if (!ModelState.IsValid) { return(View(col)); } else { Aitag.Models.NDcommon dbobj = new Aitag.Models.NDcommon(); /* * SqlConnection conn = dbobj.get_conn("Aitag_DBContext"); * SqlDataReader dr; * SqlCommand sqlsmd = new SqlCommand(); * sqlsmd.Connection = conn; * string sqlstr = "select * from certifystampstock where 1<>1"; * sqlsmd.CommandText = sqlstr; * dr = sqlsmd.ExecuteReader(); * * if (dr.Read()) * { * * ModelState.AddModelError("", "no"); * return View(col); * } * dr.Close(); * dr.Dispose(); * sqlsmd.Dispose(); * conn.Close(); * conn.Dispose(); */ col.comid = Session["comid"].ToString(); col.bmodid = Session["tempid"].ToString(); //col.badddate = DateTime.Now; col.bmoddate = DateTime.Now; using (Aitag_DBContext con = new Aitag_DBContext()) { con.certifystampstock.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.barcode; 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='/certifystampstock/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='qbarcode' name='qbarcode' value='" + qbarcode + "'>"; tmpform += "<input type=hidden id='qcerno' name='qcerno' value='" + qcerno + "'>"; tmpform += "</form>"; tmpform += "</body>"; return(new ContentResult() { Content = @"" + tmpform }); // return RedirectToAction("List"); } } }
public ActionResult Edit(certifystampstock 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 = "cerno"; } if (string.IsNullOrWhiteSpace(orderdata1)) { orderdata1 = "desc"; } ViewBag.orderdata = orderdata; ViewBag.orderdata1 = orderdata1; string qbarcode = "", qcerno = ""; if (!string.IsNullOrWhiteSpace(Request["qbarcode"])) { qbarcode = Request["qbarcode"].Trim(); ViewBag.qbarcode = qbarcode; } if (!string.IsNullOrWhiteSpace(Request["qcerno"])) { qcerno = Request["qcerno"].Trim(); ViewBag.qcerno = qcerno; } if (sysflag != "E") { using (Aitag_DBContext con = new Aitag_DBContext()) { var data = con.certifystampstock.Where(r => r.cerno == chks.cerno).FirstOrDefault(); certifystampstock ecertifystampstocks = con.certifystampstock.Find(chks.cerno); if (ecertifystampstocks == null) { return(HttpNotFound()); } return(View(ecertifystampstocks)); } } else { if (!ModelState.IsValid) { return(View(chks)); } else { //string oldmsid = Request["oldmsid"]; using (Aitag_DBContext con = new Aitag_DBContext()) { NDcommon dbobj = new NDcommon(); //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 = "標章認證編號:" + chks.barcode; 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='/certifystampstock/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='qbarcode' name='qbarcode' value='" + qbarcode + "'>"; tmpform += "<input type=hidden id='qcerno' name='qcerno' value='" + qcerno + "'>"; tmpform += "</form>"; tmpform += "</body>"; return(new ContentResult() { Content = @"" + tmpform }); //return RedirectToAction("List"); } } } }