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