private void SaveItem() { int id = GetQueryIntValue("id"); string t = GetQueryValue("t"); using (var appdb = new AppContext()) { if (t == "pmh") { ProBomHeader pmh = appdb.probombase.Where(u => u.SN == id).FirstOrDefault(); pmh.Remark = tbxRemark.Text.Trim(); appdb.SaveChanges(); } else if (t == "pmd") { ProBomDetail pmd = appdb.probomdtl.Where(u => u.SN == id).FirstOrDefault(); pmd.Remark = tbxRemark.Text.Trim(); appdb.SaveChanges(); } else if (t == "probmd") { BomDetail pmd = appdb.bomdtl.Where(u => u.SN == id).FirstOrDefault(); pmd.Remark = tbxRemark.Text.Trim(); pmd.IsValid = 1; appdb.SaveChanges(); } } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { int pid = GetQueryIntValue("sn"); using (var appdb = new AppContext()) { ProBomHeader item = appdb.probombase.Where(u => u.SN == pid).FirstOrDefault(); prono = item.ProNo; proname = item.ProName; sdate = item.BomDate.Value.ToString("yyyy-MM-dd"); ver = item.Ver.ToString(); fileno = item.FileNo; inputer = item.Inputer; inputerdate = item.InputeDate.Value.ToString("yyyy-MM-dd"); } LoadData(); } }