/// <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); } }