public ActionResult AddCustomer(Customer_reltab newobj) { using (var db = new DBSession("default")) { ISession session = db.Session; try { session.Save(newobj); } catch (Exception eX) { db.Rollback = true; return ErrorContent(eX.Message); } return Json(newobj); } }
public ActionResult InitialTestData() { Stock_reltab sr1 = new Stock_reltab() { StockNo = 1004, Price = 6750.00M, TaxRate = 2, }; Stock_reltab sr2 = new Stock_reltab() { StockNo = 1011, Price = 4500.23M, TaxRate = 2 }; Stock_reltab sr3 = new Stock_reltab() { StockNo = 1534, Price = 2234.00M, TaxRate = 2 }; Stock_reltab sr4 = new Stock_reltab() { StockNo = 1535, Price = 3456.23M, TaxRate = 2 }; Stock_reltab[] srs = new Stock_reltab[] { sr1, sr2, sr3, sr4 }; Customer_reltab cr1 = new Customer_reltab() { CustNo = 1, CustName = "Jean Nance", Street = "2 Avocet Drive", City = "Redwood Shores", State = "CA", Zip = "95054", Phone1 = "415-555-1212", Phone2 = "", Phone3 = "" }; Customer_reltab cr2 = new Customer_reltab() { CustNo = 2, CustName = "John Nike", Street = "323 College Drive", City = "Edison", State = "NJ", Zip = "08820", Phone1 = "609-555-1212", Phone2 = "201-555-1212", Phone3 = "" }; Customer_reltab[] crs = new Customer_reltab[]{ cr1, cr2 }; using (ISession session = this.CreateSessionFactory().OpenSession()) { using (ITransaction trans = session.BeginTransaction()) { try { foreach (var c in crs) { session.Save(c); } foreach (var sr in srs) { session.Save(sr); } trans.Commit(); session.Close(); ViewBag.message = "初始化数据完成"; } catch (Exception eX) { trans.Rollback(); session.Close(); ViewBag.message = "初始化数据失败:" + eX.Message; } } } return View("Index"); }
public ActionResult UpdateCustomer(Customer_reltab updobj) { using (var db = new DBSession("default")) { ISession session = db.Session; Customer_reltab old = session.Get<Customer_reltab>(updobj.CustNo); if (null != old) { try { session.Evict(old); session.Update(updobj); } catch (Exception eX) { db.Rollback = true; return ErrorContent(eX.Message); } return Content("更新成功"); } else { return ErrorContent("要更新的客户信息不存在"); } } }