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);
}
