/// <summary> /// 添加信息 /// </summary> /// <param name="logistic">LINQ数据</param> /// <param name="error">错误信息</param> /// <returns>成功返回True,失败返回False</returns> public bool AddInfo(S_LogisticSafeStock logistic, out string error) { error = null; try { DepotManagementDataContext ctx = CommentParameter.DepotDataContext; var varData = from a in ctx.S_LogisticSafeStock where a.GoodsID == logistic.GoodsID select a; if (varData.Count() != 0) { error = "数据重复"; return(false); } else { ctx.S_LogisticSafeStock.InsertOnSubmit(logistic); ctx.SubmitChanges(); } return(true); } catch (Exception ex) { error = ex.Message; return(false); } }
/// <summary> /// 获得信息 /// </summary> void GetMessage() { m_lnqLogistc = new S_LogisticSafeStock(); m_lnqLogistc.GoodsID = Convert.ToInt32(tbsGoods.Tag); m_lnqLogistc.MaxValue = numMaxValue.Value; m_lnqLogistc.MinValue = numMinValue.Value; m_lnqLogistc.Remark = txtRemark.Text; }
/// <summary> /// 更新信息 /// </summary> /// <param name="updateGoodsID">旧物品ID</param> /// <param name="logistic">LINQ信息</param> /// <param name="error">错误信息</param> /// <returns>成功返回True,失败返回False</returns> public bool UpdateInfo(int updateGoodsID, S_LogisticSafeStock logistic, out string error) { error = null; try { DepotManagementDataContext ctx = CommentParameter.DepotDataContext; var varData = from a in ctx.S_LogisticSafeStock where a.GoodsID == updateGoodsID select a; if (varData.Count() != 1) { error = "数据不唯一"; return(false); } else { S_LogisticSafeStock lnqLogistic = varData.Single(); lnqLogistic.GoodsID = logistic.GoodsID; lnqLogistic.MaxValue = logistic.MaxValue; lnqLogistic.MinValue = logistic.MinValue; lnqLogistic.Remark = logistic.Remark; ctx.SubmitChanges(); } return(true); } catch (Exception ex) { error = ex.Message; return(false); } }