/// <summary> /// 删除营销计划交货期 /// </summary> /// <param name="marketingPlanDelivery">交货期数据集</param> /// <param name="error">错误信息</param> /// <returns>成功返回True,失败返回False</returns> public bool DeleteDelivery(S_MarketingPlanDelivery marketingPlanDelivery, out string error) { error = null; try { DepotManagementDataContext dataContext = CommentParameter.DepotDataContext; var varData = from a in dataContext.S_MarketingPlanDelivery where a.Delivery == marketingPlanDelivery.Delivery && a.DJH == marketingPlanDelivery.DJH && a.GoodsID == marketingPlanDelivery.GoodsID && a.Month == marketingPlanDelivery.Month select a; dataContext.S_MarketingPlanDelivery.DeleteAllOnSubmit(varData); dataContext.SubmitChanges(); return(true); } catch (Exception ex) { error = ex.Message; return(false); } }
/// <summary> /// 插入交货期数据 /// </summary> /// <param name="marketingPlanDelivery">交货期数据集</param> /// <param name="error">错误信息</param> /// <returns>成功返回True,失败返回False</returns> public bool AddDelivery(S_MarketingPlanDelivery marketingPlanDelivery, out string error) { error = null; try { DepotManagementDataContext dataContext = CommentParameter.DepotDataContext; var varData = from a in dataContext.S_MarketingPlanDelivery where a.Delivery == marketingPlanDelivery.Delivery && a.DJH == marketingPlanDelivery.DJH && a.GoodsID == marketingPlanDelivery.GoodsID && a.Month == marketingPlanDelivery.Month select a; if (varData.Count() > 0) { error = "不能插入重复记录"; return(false); } else { dataContext.S_MarketingPlanDelivery.InsertOnSubmit(marketingPlanDelivery); dataContext.SubmitChanges(); } return(true); } catch (Exception ex) { error = ex.Message; return(false); } }