public override CBPmProcurementOrder GetCBPmProcurementOrder(int SysNo)
{
CBPmProcurementOrder order = Context.Sql(" select PmProcurementOrder.*,SyUser.UserName as CreateName from PmProcurementOrder inner join SyUser on PmProcurementOrder.Po_CreateBy=SyUser.SysNo where PmProcurementOrder.SysNo='" + SysNo + "' ").QuerySingle <CBPmProcurementOrder>();
order.orderItemList = GetCBProcurementOrderItemList(SysNo);
List <int> itemSysNos = new List <int>();
foreach (PmProcurementOrderItem item in order.orderItemList)
{
itemSysNos.Add(item.SysNo);
}
order.webPriceList = GetProcurementWebPriceList(itemSysNos.ToArray());
return(order);
}
/// <summary>
/// 添加采购单信息
/// </summary>
/// <param name="order"></param>
/// <param name="itemList"></param>
public void CreateOrUpdatePmProcurementOrder(CBPmProcurementOrder order)
{
int sysno = 0;
///创建采购申请单
if (order.SysNo == 0)
{
sysno = IPmProcurementDao.Instance.CreatePmProcurementOrder(order);
order.SysNo = sysno;
}
else
{
sysno = order.SysNo;
IPmProcurementDao.Instance.UpdatePmProcurementOrder(order);
}
///采购申请单明细
foreach (PmProcurementOrderItem item in order.orderItemList)
{
item.Poi_PSysNo = sysno;
int itemSysNo = 0;
if (item.SysNo == 0)
{
itemSysNo = IPmProcurementDao.Instance.CreatePmProcurementOrderItem(item);
}
else
{
itemSysNo = item.SysNo;
IPmProcurementDao.Instance.UpdatePmProcurementOrderItem(item);
}
///相关商品网上参考价格
var priceModList = order.webPriceList.FindAll(p => p.Pwp_ProSysNo == item.Poi_ProSysNo);
if (priceModList != null)
{
foreach (var priceMod in priceModList)
{
priceMod.Pwp_OrderItemSysNo = itemSysNo;
if (priceMod.SysNo == 0)
{
IPmProcurementDao.Instance.CreatePmProcurementWebPrice(priceMod);
}
else
{
IPmProcurementDao.Instance.UpdatePmProcurementWebPrice(priceMod);
}
}
}
}
}
/// <summary>
///
/// </summary>
/// <param name="s"></param>
/// <returns></returns>
public override CBPmProcurementOrder GetCBPmProcurementOrder(string pmNumber)
{
CBPmProcurementOrder order = Context.Sql(
" select PmProcurementOrder.*,SyUser.UserName as CreateName from PmProcurementOrder inner join SyUser on PmProcurementOrder.Po_CreateBy=SyUser.SysNo where PmProcurementOrder.Po_Number='" + pmNumber + "' ").QuerySingle <CBPmProcurementOrder>();
if (order != null)
{
order.orderItemList = GetCBProcurementOrderItemList(order.SysNo);
order.pointOrderList = PmPointsOrderDaoImpl.Instance.GetPointsOrderListBySinglePSysNo(order.SysNo);
List <int> itemSysNos = new List <int>();
foreach (PmProcurementOrderItem item in order.orderItemList)
{
itemSysNos.Add(item.SysNo);
}
order.webPriceList = GetProcurementWebPriceList(itemSysNos.ToArray());
}
return(order);
}
