/// <summary>
/// 删除BOM关联零件表
/// </summary>
/// <param name="jumbly">一条LINQ的记录集</param>
/// <param name="error">出错时返回错误信息，无错时返回null</param>
/// <returns>删除成功返回True，删除失败返回False</returns>
public bool DeleteJumbly(P_JumblyBomGoods jumbly, out string error)
{
try
{
error = null;
DepotManagementDataContext ctx = CommentParameter.DepotDataContext;
var varJumbly = from a in ctx.P_JumblyBomGoods
where a.ID == jumbly.ID
select a;
if (varJumbly.Count() != 1)
{
error = "此数据不存在或者不唯一";
return(false);
}
else
{
P_JumblyBomGoods lnqGoods = varJumbly.Single();
ctx.P_JumblyBomGoods.DeleteOnSubmit(lnqGoods);
ctx.SubmitChanges();
}
return(true);
}
catch (Exception ex)
{
error = ex.Message;
return(false);
}
}
/// <summary>
/// 更新BOM关联零件表
/// </summary>
/// <param name="jumbly">一条LINQ的记录集</param>
/// <param name="error">出错时返回错误信息，无错时返回null</param>
/// <returns>更新成功返回True，更新失败返回False</returns>
public bool UpdateJumbly(P_JumblyBomGoods jumbly, out string error)
{
try
{
error = null;
DepotManagementDataContext ctx = CommentParameter.DepotDataContext;
var varData = from a in ctx.P_JumblyBomGoods
where a.ID == jumbly.ID
select a;
if (varData.Count() != 1)
{
error = "数据为空或者不唯一";
return(false);
}
else
{
P_JumblyBomGoods lnqGoods = varData.Single();
lnqGoods.IsJumbly = jumbly.IsJumbly;
lnqGoods.BomGoodsCode = jumbly.BomGoodsCode;
lnqGoods.BomGoodsName = jumbly.BomGoodsName;
lnqGoods.BomSpec = jumbly.BomSpec;
lnqGoods.IsStock = jumbly.IsStock;
lnqGoods.JumblyGoodsID = jumbly.JumblyGoodsID;
lnqGoods.Quato = jumbly.Quato;
lnqGoods.IsMath = jumbly.IsMath;
lnqGoods.Remark = jumbly.Remark;
ctx.SubmitChanges();
}
return(true);
}
catch (Exception ex)
{
error = ex.Message;
return(false);
}
}
/// <summary>
/// 添加BOM关联零件表
/// </summary>
/// <param name="jumbly">一条P_JumblyBomGoods的LINQ记录集</param>
/// <param name="error">出错时返回错误信息，无错时返回null</param>
/// <returns>添加成功返回True，添加失败返回False</returns>
public bool AddJumbly(P_JumblyBomGoods jumbly, out string error)
{
try
{
error = null;
DepotManagementDataContext ctx = CommentParameter.DepotDataContext;
ctx.P_JumblyBomGoods.InsertOnSubmit(jumbly);
ctx.SubmitChanges();
}
catch (Exception ex)
{
error = ex.Message;
return(false);
throw;
}
return(true);
}