/// <summary>
///
/// </summary>
/// <param name="details"></param>
/// <returns></returns>
public bool CreateNewBuyDetails(int buyId,List<BBuyDetail> details)
{
bool result = false;
if (this.CurrentUserPermission.ADD_BUY == 0)
{
throw new KMJXCException("没有权限创建验货单");
}
if (details == null)
{
throw new KMJXCException("输入错误");
}
using (KuanMaiEntities db = new KuanMaiEntities())
{
foreach (BBuyDetail detail in details)
{
var d = from bdo in db.Buy_Detail where bdo.Buy_ID==buyId && bdo.Buy_Order_ID == detail.Buy_Order_ID && bdo.Product_ID == detail.Product.ID select bdo;
if (d != null && d.ToList<Buy_Detail>().Count > 0)
{
continue;
}
//if (buyId<=0)
//{
// var d2 = from bdo in db.Buy_Detail where bdo.Buy_Order_ID == detail.Buy_Order_ID select bdo;
// List<Buy_Detail> existed = d2.ToList<Buy_Detail>();
// if (existed.Count > 0)
// {
// buyId = existed[0].Buy_ID;
// }
//}
Buy_Detail dbDetail = new Buy_Detail();
dbDetail.Create_Date = KM.JXC.Common.Util.DateTimeUtil.ConvertDateTimeToInt(DateTime.Now);
dbDetail.Buy_ID = buyId;
dbDetail.Buy_Order_ID = detail.Buy_Order_ID;
dbDetail.Create_Date = detail.CreateDate;
dbDetail.Price = detail.Price;
dbDetail.Product_ID = detail.Product.ID;
dbDetail.Quantity = detail.Quantity;
dbDetail.Parent_Product_ID = detail.Parent_Product_ID;
db.Buy_Detail.Add(dbDetail);
Buy_Order_Detail boDetail = null;
var d3 = from bod in db.Buy_Order_Detail where bod.Buy_Order_ID == detail.Buy_Order_ID && bod.Product_ID == detail.Product.ID select bod;
if (d3.ToList<Buy_Order_Detail>().Count == 1)
{
boDetail = d3.ToList<Buy_Order_Detail>()[0];
}
boDetail.Status = 1;
}
db.SaveChanges();
}
return result;
}
/// <summary>
/// Create single buy detail
/// </summary>
/// <param name="detail"></param>
/// <returns></returns>
public bool CreateNewBuyDetail(int buyId,BBuyDetail detail)
{
bool ret = false;
if (this.CurrentUserPermission.ADD_BUY == 0)
{
throw new KMJXCException("没有权限创建验货单信息");
}
using (KuanMaiEntities db = new KuanMaiEntities())
{
var d = from bdo in db.Buy_Detail where bdo.Buy_Order_ID == detail.Buy_Order_ID && bdo.Product_ID == detail.Product.ID select bdo;
if (d != null && d.ToList<Buy_Detail>().Count > 0)
{
throw new KMJXCException("已经验过货");
}
if (buyId<=0)
{
var d2 = from bdo in db.Buy_Detail where bdo.Buy_Order_ID == detail.Buy_Order_ID select bdo;
List<Buy_Detail> existed = d2.ToList<Buy_Detail>();
if (existed.Count > 0)
{
buyId = existed[0].Buy_ID;
}
}
Buy_Detail dbDetail = new Buy_Detail();
dbDetail.Buy_ID = buyId;
dbDetail.Buy_Order_ID = detail.Buy_Order_ID;
dbDetail.Create_Date = detail.CreateDate;
dbDetail.Price = detail.Price;
dbDetail.Product_ID = detail.Product.ID;
dbDetail.Quantity = detail.Quantity;
db.Buy_Detail.Add(dbDetail);
Buy_Order_Detail boDetail = null;
var d3 = from bod in db.Buy_Order_Detail where bod.Buy_Order_ID == detail.Buy_Order_ID && bod.Product_ID == detail.Product.ID select bod;
if (d3.ToList<Buy_Order_Detail>().Count == 1)
{
boDetail = d3.ToList<Buy_Order_Detail>()[0];
}
boDetail.Status = 1;
db.SaveChanges();
//Verify buy order status
this.VerifyBuyOrder((int)detail.Buy_Order_ID);
ret = true;
}
return ret;
}