/// <summary>
/// 获得单一的BOM清单信息
/// </summary>
/// <param name="listGoods">BOM物品信息列表</param>
/// <returns>返回Table</returns>
public DataTable SetSingleBom(List <string> listGoods)
{
DepotManagementDataContext dataContext = CommentParameter.DepotDataContext;
ClearTempTable();
foreach (string goodsInfo in listGoods)
{
int goodsID = Convert.ToInt32(goodsInfo.Substring(0, goodsInfo.IndexOf("-")));
int parentGoodsID = Convert.ToInt32(goodsInfo.Substring(goodsInfo.IndexOf("-") + 1));
var varData = from a in dataContext.BASE_BomStruct
where a.GoodsID == goodsID &&
a.ParentID == parentGoodsID
select a;
if (varData.Count() == 1)
{
S_ForWantingReportTemp lnqFor = new S_ForWantingReportTemp();
lnqFor.GoodsID = goodsID;
lnqFor.Count = varData.Single().Usage;
dataContext.S_ForWantingReportTemp.InsertOnSubmit(lnqFor);
}
}
dataContext.SubmitChanges();
return(null);
}
/// <summary>
/// 插入临时表
/// </summary>
/// <param name="code">产品型号</param>
/// <param name="count">数量</param>
public void AddTempTable(string code, decimal count)
{
DepotManagementDataContext dataContext = CommentParameter.DepotDataContext;
S_ForWantingReportTemp lnqFor = new S_ForWantingReportTemp();
IBasicGoodsServer serverGoods = ServerModuleFactory.GetServerModule <IBasicGoodsServer>();
string error = "";
View_F_GoodsPlanCost tempLnq = serverGoods.GetGoodsInfo(code, "", out error);
lnqFor.GoodsID = tempLnq == null ? 0 : tempLnq.序号;
lnqFor.Count = count;
dataContext.S_ForWantingReportTemp.InsertOnSubmit(lnqFor);
dataContext.SubmitChanges();
}
