/// <summary>
/// 向供应商配额设置表中添加数据
/// </summary>
/// <param name="inLeast">供应商物品采购配额信息</param>
/// <param name="error">出错时返回错误信息，无错时返回null</param>
/// <returns>操作是否成功的标志</returns>
public bool AddInfo(B_GoodsLeastPackAndStock inLeast, out string error)
{
error = null;
try
{
DepotManagementDataContext ctx = CommentParameter.DepotDataContext;
var varData = from a in ctx.B_GoodsLeastPackAndStock
where a.GoodsID == inLeast.GoodsID &&
a.Provider == inLeast.Provider
select a;
if (varData.Count() > 0)
{
error = "数据重复";
return(false);
}
else
{
ctx.B_GoodsLeastPackAndStock.InsertOnSubmit(inLeast);
}
ctx.SubmitChanges();
return(true);
}
catch (Exception ex)
{
error = ex.Message;
return(false);
}
}
/// <summary>
/// 修改供应商配额设置表中的一条数据
/// </summary>
/// <param name="inLeast">供应商物品采购配额信息</param>
/// <param name="error">出错时返回错误信息，无错时返回null</param>
/// <returns>操作是否成功的标志</returns>
public bool UpdateInfo(B_GoodsLeastPackAndStock inLeast, out string error)
{
error = null;
try
{
DepotManagementDataContext ctx = CommentParameter.DepotDataContext;
var varData = from a in ctx.B_GoodsLeastPackAndStock
where a.ID == inLeast.ID
select a;
var varDataTest = from a in ctx.B_GoodsLeastPackAndStock
where a.GoodsID == inLeast.GoodsID &&
a.Provider == inLeast.Provider &&
a.ID != inLeast.ID
select a;
if (varDataTest.Count() > 0)
{
error = "数据重复";
return(false);
}
else
{
B_GoodsLeastPackAndStock lnqNew = varData.Single();
lnqNew.GoodsID = inLeast.GoodsID;
lnqNew.LeastPack = inLeast.LeastPack;
lnqNew.LeastStock = inLeast.LeastStock;
lnqNew.StockQuota = inLeast.StockQuota;
lnqNew.Provider = inLeast.Provider;
lnqNew.ProductDay = inLeast.ProductDay;
lnqNew.ProviderLv = inLeast.ProviderLv;
}
ctx.SubmitChanges();
return(true);
}
catch (Exception ex)
{
error = ex.Message;
return(false);
}
}
