public void Update(DS_OrderDetail OrderDetail) { using (var ct = new DS_OrderDetailDataContext(DbHelperSQL.Connection)) { ct.DS_OrderDetail.Attach(OrderDetail, true); ct.SubmitChanges(); } }
public void Add(DS_OrderDetail OrderDetail) { using (var ct = new DS_OrderDetailDataContext(DbHelperSQL.Connection)) { ct.DS_OrderDetail.InsertOnSubmit(OrderDetail); ct.SubmitChanges(); } }
public void Delete(int ID) { using (var ct = new DS_OrderDetailDataContext(DbHelperSQL.Connection)) { DS_OrderDetail st = ct.DS_OrderDetail.Single(a => a.ID == ID); ct.DS_OrderDetail.DeleteOnSubmit(st); ct.SubmitChanges(); } }
private DS_OrderDetail CreateOrderDetail(int ProductID, int ProNum) { var productbl = new DS_ProductsDataContext(DBUtility.DbHelperSQL.Connection); var product = productbl.DS_Products.Single(a => a.ID.Equals(ProductID)); var OrderDetail = new DS_OrderDetail(); OrderDetail.ProNum = ProNum; OrderDetail.ProductID = ProductID; OrderDetail.Price = GetPrice(product.PriceRang, ProNum); OrderDetail.ProName = product.Title; OrderDetail.ImgUrl = product.Img1; OrderDetail.OrderNum = string.Empty; OrderDetail.State = (byte)State.待卖家确认订单; OrderDetail.CreateDate = DateTime.Now; OrderDetail.Amount = Math.Round(double.Parse(ProNum.ToString()) * OrderDetail.Price); OrderDetail.PriceRang = GetPriceRang(product.PriceRang, ProNum); return(OrderDetail); }