public List <T> Query <T>(string sql, params object[] parameterValues)
{
using (var ct = new DS_ProductsDataContext(DbHelperSQL.Connection))
{
return(ct.ExecuteQuery <T>(sql, parameterValues).ToList());//ct.DS_Products.Where(c=>System.Data.Linq.SqlClient.SqlMethods.Like(字段,"%A%"))
}
}
public DS_Products GetSingle(int ID)
{
using (var ct = new DS_ProductsDataContext(DbHelperSQL.Connection))
{
return(ct.DS_Products.Single(a => a.ID == ID));
}
}
public void Update(DS_Products Products)
{
using (var ct = new DS_ProductsDataContext(DbHelperSQL.Connection))
{
ct.DS_Products.Attach(Products, true);
ct.SubmitChanges();
}
}
public void Add(DS_Products Products)
{
using (var ct = new DS_ProductsDataContext(DbHelperSQL.Connection))
{
ct.DS_Products.InsertOnSubmit(Products);
ct.SubmitChanges();
}
}
public void Delete(int ID)
{
using (var ct = new DS_ProductsDataContext(DbHelperSQL.Connection))
{
var st = ct.DS_Products.Single(a => a.ID == ID);
ct.DS_Products.DeleteOnSubmit(st);
ct.SubmitChanges();
}
}
public void Delete(string Ids)
{
using (var ct = new DS_ProductsDataContext(DbHelperSQL.Connection))
{
string[] idarray = Ids.Split(',');
var list = ct.DS_Products.Where(a => idarray.Contains(a.ID.ToString()));
ct.DS_Products.DeleteAllOnSubmit(list);
ct.SubmitChanges();
}
}
public List <DS_Products> Query(string condition, string orderby, params object[] param)
{
using (var ct = new DS_ProductsDataContext(DbHelperSQL.Connection))
{
IQueryable <DS_Products> ProductsList = ct.DS_Products;
if (!string.IsNullOrEmpty(condition))
{
ProductsList = ProductsList.Where(condition, param);
}
if (!string.IsNullOrEmpty(orderby))
{
ProductsList = ProductsList.OrderBy(orderby);
}
return(ProductsList.ToList());
}
}
public List <DS_Products> Query(string condition, string orderby, int startIndex, int pageSize, ref int pageCount, params object[] param)
{
using (var ct = new DS_ProductsDataContext(DbHelperSQL.Connection))
{
IQueryable <DS_Products> ProductsList = ct.DS_Products;
if (!string.IsNullOrEmpty(condition))
{
ProductsList = ProductsList.Where(condition, param);
}
if (!string.IsNullOrEmpty(orderby))
{
ProductsList = ProductsList.OrderBy(orderby);
}
pageCount = ProductsList.Count();
return(ProductsList.Skip(startIndex).Take(pageSize).ToList());
}
}
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);
}
/// <summary>
/// 加入进货单
/// </summary>
/// <param name="ProductID">产品ID</param>
/// <param name="ProNum">产品数量</param>
/// <param name="ProTotalCount">添加商品后反回进货单中的总商品数</param>
/// <param name="ProTotalAmount">添加商品后反回进货单中的总金额</param>
/// <param name="CurrentProAmount">当前产品ID的总金额</param>
public OrderInfo Add(int ProductID, int ProNum)
{
var odinfo = new OrderInfo();
var orderDetail = CreateOrderDetail(ProductID, ProNum);
odinfo.CrtPriceRang = orderDetail.PriceRang;
var productbl = new DS_ProductsDataContext(DBUtility.DbHelperSQL.Connection);
var memberbl = new View_MembersDataContext(DBUtility.DbHelperSQL.Connection);
var product = productbl.DS_Products.Single(a => a.ID.Equals(orderDetail.ProductID));
var existod = Orders.Where(a => a.MemberID.Equals(product.MemberID));
if (existod.Count().Equals(0))//检查订单中是否存在相同公司
{
var order = new DS_Orders();
order.MemberID = product.MemberID;
var member = memberbl.View_Members.Single(a => a.ID.Equals(product.MemberID));
order.CompanyName = member.CompanyName;
order.QQ = member.QQ;
order.ProNum = orderDetail.ProNum;
order.PurchaseID = 0;
order.Amount = orderDetail.Amount;
order.CreateDate = DateTime.Now;
order.ID = id++;
odinfo.ID = order.ID;
Orders.Add(order);
orderDetail.OrderID = order.ID;
orderDetail.MemberID = order.MemberID;
orderDetail.OrderNum = DS_Orders_Br.GetSerial();
OrderDetail.Add(orderDetail);
}
else
{
var order = existod.Single();
orderDetail.OrderID = order.ID;
orderDetail.MemberID = order.MemberID;
odinfo.ID = order.ID;
//检查购物车中是否已存在相同商品
var existoddt = OrderDetail.Where(a => a.ProductID.Equals(orderDetail.ProductID));
if (existoddt.Count().Equals(0))
{
order.Amount += orderDetail.Amount;
order.ProNum += orderDetail.ProNum;
orderDetail.OrderNum = DS_Orders_Br.GetSerial();
OrderDetail.Add(orderDetail);
}
else
{
var oddt = existoddt.Single();
order.Amount -= Math.Round(double.Parse(oddt.ProNum.ToString()) * oddt.Price);
oddt.ProNum += orderDetail.ProNum;
oddt.Price = GetPrice(product.PriceRang, oddt.ProNum);
oddt.PriceRang = GetPriceRang(product.PriceRang, oddt.ProNum);
odinfo.CrtPriceRang = oddt.PriceRang;
oddt.Amount = Math.Round(double.Parse(oddt.ProNum.ToString()) * oddt.Price);
order.Amount += oddt.Amount;
order.ProNum += orderDetail.ProNum;
}
}
odinfo.PurTotalCount = Orders.Sum(a => a.ProNum);
odinfo.CrtProAmount = OrderDetail.Where(a => a.ProductID.Equals(ProductID)).Sum(a => a.Amount);
odinfo.PurTotalAmount = Orders.Sum(a => a.Amount);
odinfo.CrtOrderAmount = Orders.Where(a => a.ID.Equals(orderDetail.OrderID)).Sum(a => a.Amount);
return(odinfo);
}
