/// <summary>
/// 修改合同物品信息中的合同号
/// </summary>
/// <param name="dataContext">数据库上下文</param>
/// <param name="id">合同物品ID</param>
/// <param name="newBargainNumber">新合同号</param>
/// <param name="error">错误信息, 没有则为null</param>
/// <returns>操作是否成功的标志</returns>
public bool UpdateBargainNumber(DepotManagementDataContext dataContext, int id, string newBargainNumber, out string error)
{
error = null;
try
{
var result = from r in dataContext.B_BargainGoods
where r.ID == id
select r;
if (result.Count() == 0)
{
error = "找不到指定物品信息，无法进行此操作！";
return(false);
}
B_BargainGoods record = result.Single();
record.BargainNumber = newBargainNumber;
if (AutoSubmitToDatabase)
{
dataContext.SubmitChanges();
}
return(true);
}
catch (Exception exce)
{
error = exce.Message;
return(false);
}
}
/// <summary>
/// 修改合同物品信息
/// </summary>
/// <param name="goodsID">物品ID</param>
/// <param name="newGoods">新合同物品</param>
/// <param name="returnBargainGoods">返回查询到的合同物品信息</param>
/// <param name="error">错误信息, 没有则为null</param>
/// <returns>操作是否成功的标志</returns>
public bool UpdateBargainGoods(int goodsID, B_BargainGoods newGoods,
out IQueryable <View_B_BargainGoods> returnBargainGoods, out string error)
{
DepotManagementDataContext dataContxt = CommentParameter.DepotDataContext;
return(UpdateBargainGoods(dataContxt, goodsID, newGoods, out returnBargainGoods, out error));
}
/// <summary>
/// 添加合同物品信息
/// </summary>
/// <param name="bargainGoods">合同物品信息</param>
/// <param name="returnBargainGoods">返回查询到的合同物品信息</param>
/// <param name="error">错误信息, 没有则为null</param>
/// <returns>操作是否成功的标志</returns>
public bool AddBargainGoods(B_BargainGoods bargainGoods, out IQueryable <View_B_BargainGoods> returnBargainGoods, out string error)
{
returnBargainGoods = null;
error = null;
try
{
DepotManagementDataContext dataContxt = CommentParameter.DepotDataContext;
if (bargainGoods.GoodsID == 0)
{
error = "请录入物品";
return(false);
}
var varBill = from a in dataContxt.B_BargainInfo
where a.BargainNumber == bargainGoods.BargainNumber
select a;
if (varBill.Count() != 1)
{
error = "请先添加合同，再添加物品";
return(false);
}
dataContxt.B_BargainGoods.InsertOnSubmit(bargainGoods);
if (AutoSubmitToDatabase)
{
dataContxt.SubmitChanges();
}
return(GetBargainGoods(bargainGoods.BargainNumber, out returnBargainGoods, out error));
}
catch (Exception exce)
{
error = exce.Message;
return(false);
}
}
/// <summary>
/// 修改合同物品信息
/// </summary>
/// <param name="dataContext">LINQ 数据库上下文</param>
/// <param name="goodsID">物品ID</param>
/// <param name="newGoods">新合同物品</param>
/// <param name="returnBargainGoods">返回查询到的合同物品信息</param>
/// <param name="error">错误信息, 没有则为null</param>
/// <returns>操作是否成功的标志</returns>
public bool UpdateBargainGoods(DepotManagementDataContext dataContext, int goodsID,
B_BargainGoods newGoods, out IQueryable <View_B_BargainGoods> returnBargainGoods, out string error)
{
returnBargainGoods = null;
error = null;
try
{
var result = from r in dataContext.B_BargainGoods
where r.GoodsID == goodsID &&
r.BargainNumber == newGoods.BargainNumber
select r;
if (result.Count() == 0)
{
error = "找不到指定物品信息，无法进行此操作！";
return(false);
}
B_BargainGoods record = result.Single();
record.BargainNumber = newGoods.BargainNumber;
record.UnitPrice = newGoods.UnitPrice;
record.Amount = newGoods.Amount;
record.Remark = newGoods.Remark;
if (AutoSubmitToDatabase)
{
dataContext.SubmitChanges();
}
return(GetBargainGoods(newGoods.BargainNumber, out returnBargainGoods, out error));
}
catch (Exception exce)
{
error = exce.Message;
return(false);
}
}
