/// <summary>
/// 添加父表信息
/// </summary>
/// <param name="marketingPlan">计划主表信息</param>
/// <param name="planList">计划明细表信息</param>
/// <param name="error">出错时返回错误信息，无错时返回null</param>
/// <returns>添加成功返回True，添加失败返回False</returns>
public bool AddBill(S_MarketingPlanBill marketingPlan, DataTable planList, out string error)
{
error = null;
try
{
DepotManagementDataContext ctx = CommentParameter.DepotDataContext;
if (!IsRepeatBillID(marketingPlan.DJH))
{
if (!UpdateBill(ctx, marketingPlan, planList, out error))
{
return(false);
}
}
else
{
if (!DeletePlanList(ctx, marketingPlan.DJH, out error))
{
return(false);
}
if (!AddPlanList(ctx, planList, out error))
{
return(false);
}
if (!CheckBillType(ctx, marketingPlan.YearAndMonth, marketingPlan.BillType, out error))
{
return(false);
}
S_MarketingPlanBill lnqPlan = new S_MarketingPlanBill();
lnqPlan.DJH = marketingPlan.DJH;
lnqPlan.YearAndMonth = marketingPlan.YearAndMonth;
lnqPlan.BillType = marketingPlan.BillType;
lnqPlan.DJZT = "等待采购计划批准";
lnqPlan.BZR = BasicInfo.LoginName;
lnqPlan.BZRQ = ServerTime.Time;
lnqPlan.FirstMonthSumCount = marketingPlan.FirstMonthSumCount;
lnqPlan.SecondMonthSumCount = marketingPlan.SecondMonthSumCount;
lnqPlan.ThirdMonthSumCount = marketingPlan.ThirdMonthSumCount;
lnqPlan.Remark = marketingPlan.Remark;
lnqPlan.FileNo = marketingPlan.FileNo;
ctx.S_MarketingPlanBill.InsertOnSubmit(lnqPlan);
}
ctx.SubmitChanges();
return(true);
}
catch (Exception ex)
{
error = ex.Message;
return(false);
}
}
/// <summary>
/// 更改状态
/// </summary>
/// <param name="billStatus">单据状态</param>
/// <param name="billIDList">计划单号列表</param>
/// <param name="error">出错时返回错误信息，无错时返回null</param>
/// <returns>更改成功返回True，更改失败返回False</returns>
public bool UpdateBill(string billStatus, DataTable billIDList, out string error)
{
error = null;
try
{
DepotManagementDataContext ctx = CommentParameter.DepotDataContext;
for (int i = 0; i < billIDList.Rows.Count; i++)
{
var varData = from a in ctx.S_MarketingPlanBill
where a.DJH == billIDList.Rows[i]["单据号"].ToString()
select a;
if (varData.Count() == 1)
{
S_MarketingPlanBill lnqMkPlan = varData.Single();
if (billStatus != lnqMkPlan.DJZT)
{
error = "单据状态错误，请重新刷新单据确认单据状态";
return(false);
}
switch (lnqMkPlan.DJZT)
{
case "等待主管审核":
lnqMkPlan.DJZT = "等待领导批准";
lnqMkPlan.SHR = BasicInfo.LoginName;
lnqMkPlan.SHRQ = ServerTime.Time;
break;
case "等待领导批准":
lnqMkPlan.DJZT = "等待采购计划批准";
lnqMkPlan.PZR = BasicInfo.LoginName;
lnqMkPlan.PZRQ = ServerTime.Time;
break;
default:
break;
}
ctx.SubmitChanges();
}
}
return(true);
}
catch (Exception ex)
{
error = ex.Message;
return(false);
}
}
/// <summary>
/// 修改父表信息
/// </summary>
/// <param name="ctx">数据上下文</param>
/// <param name="inMkPlan">采购计划主表信息</param>
/// <param name="planList">采购计划明细信息</param>
/// <param name="error">出错时返回错误信息，无错时返回null</param>
/// <returns>修改成功返回True，修改失败返回False</returns>
private bool UpdateBill(DepotManagementDataContext ctx, S_MarketingPlanBill inMkPlan, DataTable planList, out string error)
{
error = null;
try
{
var varData = from a in ctx.S_MarketingPlanBill
where a.DJH == inMkPlan.DJH
select a;
if (varData.Count() == 1)
{
if (!DeletePlanList(ctx, inMkPlan.DJH, out error))
{
return(false);
}
if (!AddPlanList(ctx, planList, out error))
{
return(false);
}
if (!CheckBillType(ctx, inMkPlan.YearAndMonth, inMkPlan.BillType, out error))
{
return(false);
}
S_MarketingPlanBill lnqPlan = varData.Single();
lnqPlan.DJZT = "等待采购计划批准";
lnqPlan.BillType = inMkPlan.BillType;
lnqPlan.YearAndMonth = inMkPlan.YearAndMonth;
lnqPlan.BZR = BasicInfo.LoginName;
lnqPlan.BZRQ = ServerTime.Time;
lnqPlan.FirstMonthSumCount = inMkPlan.FirstMonthSumCount;
lnqPlan.SecondMonthSumCount = inMkPlan.SecondMonthSumCount;
lnqPlan.ThirdMonthSumCount = inMkPlan.ThirdMonthSumCount;
lnqPlan.Remark = inMkPlan.Remark;
lnqPlan.FileNo = inMkPlan.FileNo;
ctx.SubmitChanges();
}
return(true);
}
catch (Exception ex)
{
error = ex.Message;
return(false);
}
}
public void UpdateFilePath(string billNo, string fileNo)
{
DepotManagementDataContext ctx = CommentParameter.DepotDataContext;
var varData = from a in ctx.S_MarketingPlanBill
where a.DJH == billNo
select a;
if (varData.Count() == 1)
{
S_MarketingPlanBill tempInfo = varData.Single();
tempInfo.FileNo = fileNo;
}
ctx.SubmitChanges();
}
/// <summary>
/// 删除单据
/// </summary>
/// <param name="djh">计划单号</param>
/// <param name="error">出错时返回错误信息，无错时返回null</param>
/// <returns>删除成功返回True，删除失败返回False</returns>
public bool DeleteBill(string djh, out string error)
{
error = null;
try
{
DepotManagementDataContext ctx = CommentParameter.DepotDataContext;
var varData = from a in ctx.S_MarketingPlanBill
where a.DJH == djh
select a;
if (varData.Count() == 1)
{
S_MarketingPlanBill lnqMarketingPlan = varData.Single();
if (DeletePlanList(ctx, djh, out error))
{
ctx.S_MarketingPlanBill.DeleteOnSubmit(lnqMarketingPlan);
ctx.SubmitChanges();
}
else
{
return(false);
}
}
else
{
error = "数据不唯一";
return(false);
}
return(true);
}
catch (Exception ex)
{
error = ex.Message;
return(false);
}
}