/// <summary>
/// 质管确认修改TCU返修信息
/// </summary>
/// <param name="billNo">单号</param>
/// <param name="error">错误信息</param>
/// <returns>成功返回true，失败返回false</returns>
public bool ConfirmUpdateData(string billNo, out string error)
{
error = "";
try
{
DepotManagementDataContext dataContxt = CommentParameter.DepotDataContext;
var result = from a in dataContxt.TCU_RepairInfo
where a.ID == Convert.ToInt32(billNo)
select a;
if (result.Count() > 0)
{
TCU_RepairInfo lnq = result.Single();
lnq.Confirmor = BasicInfo.LoginID;
lnq.ConfirmTime = ServerTime.Time;
lnq.Statua = "已完成";
dataContxt.SubmitChanges();
}
return(true);
}
catch (Exception ex)
{
error = ex.Message;
return(false);
}
}
/// <summary>
/// 添加一条TCU返修信息
/// </summary>
/// <param name="repairInfo">TCU返修信息数据集</param>
/// <param name="error">错误信息</param>
/// <returns>成功返回true，失败返回false</returns>
public bool InsertData(TCU_RepairInfo repairInfo, out string error)
{
error = "";
try
{
DepotManagementDataContext dataContxt = CommentParameter.DepotDataContext;
var result = from a in dataContxt.TCU_RepairInfo
where a.TCUVersions == repairInfo.TCUVersions && a.AssociatedBillNo == repairInfo.AssociatedBillNo
select a;
if (result.Count() > 0)
{
error = repairInfo.AssociatedBillNo + "关联单号的" + repairInfo.TCUVersions + "版本已经存在！";
return(false);
}
dataContxt.TCU_RepairInfo.InsertOnSubmit(repairInfo);
dataContxt.SubmitChanges();
return(true);
}
catch (Exception ex)
{
error = ex.Message;
return(false);
}
}
/// <summary>
/// 通过单号修改TCU返修信息(先删后增)
/// </summary>
/// <param name="repairInfo">TCU返修信息数据集</param>
/// <param name="error">错误信息</param>
/// <returns>成功返回true，失败返回false</returns>
public bool UpdateData(TCU_RepairInfo repairInfo, out string error)
{
error = "";
try
{
DepotManagementDataContext dataContxt = CommentParameter.DepotDataContext;
var result = from a in dataContxt.TCU_RepairInfo
where a.ID == repairInfo.ID
select a;
if (result.Count() > 0)
{
dataContxt.TCU_RepairInfo.DeleteAllOnSubmit(result);
}
dataContxt.TCU_RepairInfo.InsertOnSubmit(repairInfo);
dataContxt.SubmitChanges();
return(true);
}
catch (Exception ex)
{
error = ex.Message;
return(false);
}
}
