public ActionResult Edit(SupplierType obj) { try { List<SuppliersProductType> list1 = Newtonsoft.Json.JsonConvert.DeserializeObject<List<SuppliersProductType>>(obj.rows); NSession.Update(obj); NSession.Flush(); NSession.Delete("from SuppliersProductType where SId='" + obj.Id + "'"); NSession.Flush(); NSession.Clear(); foreach (SuppliersProductType product in list1) { product.SId = obj.Id; NSession.Save(product); NSession.Flush(); } } catch (Exception ee) { return Json(new { IsSuccess = false, ErrorMsg = "出错了" }); } return Json(new { IsSuccess = true }); }
private void SaveSupplier(PurchasePlanType obj) { object exit = NSession.CreateQuery("from SupplierType where SuppliersName='"+obj.Suppliers+"'").UniqueResult(); if (exit==null) { SupplierType super = new SupplierType { SuppliersName = obj.Suppliers }; NSession.Save(super); NSession.Flush(); SuppliersProductType product = new SuppliersProductType { SId = super.Id, SKU = obj.SKU, Price = obj.Price, Web = obj.ProductUrl }; NSession.Save(product); NSession.Flush(); } else { IList<SupplierType> list = NSession.CreateQuery("from SupplierType where SuppliersName='" + obj.Suppliers + "'").List<SupplierType>(); object productexit = NSession.CreateQuery("from SuppliersProductType where SId='" +list[0].Id+ "' and SKU='"+obj.SKU+"' ").UniqueResult(); if (productexit == null) { SuppliersProductType product = new SuppliersProductType { SId = list[0].Id, SKU = obj.SKU, Price = obj.Price, Web = obj.ProductUrl }; NSession.Save(product); NSession.Flush(); } } }