/// <summary>
/// 修改父表信息，质管批准
/// </summary>
/// <param name="djh">变更单号</param>
/// <param name="error">出错时返回错误信息，无错时返回null</param>
/// <returns>修改成功返回True，修改失败返回False</returns>
public bool AuthorizeBill(string djh, out string error)
{
error = null;
try
{
DepotManagementDataContext ctx = CommentParameter.DepotDataContext;
var varData = from a in ctx.P_ProductChangeBill
where a.DJH == djh
select a;
if (varData.Count() == 1)
{
P_ProductChangeBill lnqPlan = varData.Single();
lnqPlan.DJZT = "单据已完成";
lnqPlan.PZRQ = ServerTime.Time;
lnqPlan.PZRY = BasicInfo.LoginID;
}
ctx.SubmitChanges();
return(true);
}
catch (Exception ex)
{
error = ex.Message;
return(false);
}
}
/// <summary>
/// 添加父表信息
/// </summary>
/// <param name="inProductChange">产品型号变更信息</param>
/// <param name="planList">明细信息</param>
/// <param name="error">出错时返回错误信息，无错时返回null</param>
/// <returns>添加成功返回True，添加失败返回False</returns>
public bool AddBill(P_ProductChangeBill inProductChange, DataTable planList, out string error)
{
error = null;
try
{
DepotManagementDataContext ctx = CommentParameter.DepotDataContext;
if (!IsRepeatBillID(inProductChange.DJH))
{
if (!UpdateBill(ctx, inProductChange, planList, out error))
{
return(false);
}
}
else
{
if (!DeletePlanList(ctx, inProductChange.DJH, out error))
{
return(false);
}
if (!AddPlanList(ctx, planList, out error))
{
return(false);
}
P_ProductChangeBill lnqPlan = new P_ProductChangeBill();
lnqPlan.DJH = inProductChange.DJH;
lnqPlan.DJZT = "等待主管审核";
lnqPlan.LRRY = BasicInfo.LoginID;
lnqPlan.LRRQ = ServerTime.Time;
lnqPlan.DJLX = inProductChange.DJLX;
lnqPlan.Remark = inProductChange.Remark;
ctx.P_ProductChangeBill.InsertOnSubmit(lnqPlan);
}
ctx.SubmitChanges();
}
catch (Exception ex)
{
error = ex.Message;
return(false);
}
return(true);
}
/// <summary>
/// 修改父表信息
/// </summary>
/// <param name="ctx">数据上下文</param>
/// <param name="inProductChange">产品型号变更信息</param>
/// <param name="planList">明细信息</param>
/// <param name="error">出错时返回错误信息，无错时返回null</param>
/// <returns>修改成功返回True，修改失败返回False</returns>
public bool UpdateBill(DepotManagementDataContext ctx, P_ProductChangeBill inProductChange,
DataTable planList, out string error)
{
error = null;
try
{
var varData = from a in ctx.P_ProductChangeBill
where a.DJH == inProductChange.DJH
select a;
if (varData.Count() == 1)
{
if (!DeletePlanList(ctx, inProductChange.DJH, out error))
{
return(false);
}
if (!AddPlanList(ctx, planList, out error))
{
return(false);
}
P_ProductChangeBill lnqPlan = varData.Single();
lnqPlan.DJZT = "等待主管审核";
lnqPlan.LRRY = BasicInfo.LoginID;
lnqPlan.LRRQ = ServerTime.Time;
lnqPlan.SHRQ = null;
lnqPlan.SHRY = null;
lnqPlan.PZRQ = null;
lnqPlan.PZRY = null;
lnqPlan.DJLX = inProductChange.DJLX;
lnqPlan.Remark = inProductChange.Remark;
ctx.SubmitChanges();
}
}
catch (Exception ex)
{
error = ex.Message;
return(false);
}
return(true);
}
