/// <summary>
/// 责任部门确认，修改表
/// </summary>
/// <param name="billID">单据号</param>
/// <param name="dutyPerson">责任人</param>
/// <param name="finish">完成要求</param>
/// <param name="stock">库存产品意见</param>
/// <param name="error">出错时返回错误信息，无错时返回null</param>
/// <returns>操作成功返回True，操作失败返回False</returns>
public bool UpdateDutyDept(string billID, string dutyPerson, string finish,
string stock, out string error)
{
error = "";
try
{
WebSeverDataContext dataContxt = WebDatabaseParameter.WebDataContext;
var varData = from a in dataContxt.S_ServiceFeedBack
where a.FK_Bill_ID == billID
select a;
if (varData.Count() != 1)
{
error = "数据有错误！";
return(false);
}
else
{
S_ServiceFeedBack list = varData.Single();
list.DutyDeptCharge = BasicInfo.LoginID;
list.DutyPerson = dutyPerson;
list.FinishClaim = finish;
list.StockSuggestion = stock;
list.DutyDeptChargeDate = ServerTime.Time;
list.Status = "等待责任人确认";
dataContxt.SubmitChanges();
}
}
catch (Exception ex)
{
error = ex.Message;
return(false);
}
return(true);
}
/// <summary>
/// 责任人确认，修改表信息
/// </summary>
/// <param name="back">数据集对象</param>
/// <param name="error">出错时返回错误信息，无错时返回null</param>
/// <returns>操作成功返回True，操作失败返回False</returns>
public bool UpdateDutyPerson(S_ServiceFeedBack back, out string error)
{
error = "";
try
{
WebSeverDataContext dataContxt = WebDatabaseParameter.WebDataContext;
var varData = from a in dataContxt.S_ServiceFeedBack
where a.FK_Bill_ID == back.FK_Bill_ID
select a;
if (varData.Count() != 1)
{
error = "数据有错误！";
return(false);
}
else
{
S_ServiceFeedBack list = varData.Single();
list.Temporary = back.Temporary;
list.Analyse = back.Analyse;
//list.foreverImplement = back.foreverImplement;
list.IsFMEAfile = back.IsFMEAfile;
list.IsOpen = back.IsOpen;
list.Status = "等待质管检查";
list.DutyPersonDate = DateTime.Now;
dataContxt.SubmitChanges();
}
}
catch (Exception ex)
{
error = ex.Message;
return(false);
}
return(true);
}
/// <summary>
/// 质管部检验，修改表信息
/// </summary>
/// <param name="billID">单据号</param>
/// <param name="cloes">是否关闭</param>
/// <param name="practice">落实情况</param>
/// <param name="error">出错时返回错误信息，无错时返回null</param>
/// <returns>操作成功返回True，操作失败返回False</returns>
public bool UpdateZGCheck(string billID, string cloes, string practice, out string error)
{
error = "";
try
{
WebSeverDataContext dataContxt = WebDatabaseParameter.WebDataContext;
var varData = from a in dataContxt.S_ServiceFeedBack
where a.FK_Bill_ID == billID
select a;
if (varData.Count() != 1)
{
error = "数据有错误！";
return(false);
}
else
{
S_ServiceFeedBack list = varData.Single();
list.ZGCheckName = BasicInfo.LoginID;
list.IsClose = cloes;
list.Practicable = practice;
list.Status = "单据完成";
list.ZGCheckDate = DateTime.Now;
dataContxt.SubmitChanges();
}
}
catch (Exception ex)
{
error = ex.Message;
return(false);
}
return(true);
}
/// <summary>
/// 质管部确认，修改表信息
/// </summary>
/// <param name="billID">单据号</param>
/// <param name="ChargeSuggestion">质管部意见</param>
/// <param name="dutyDept">责任部门</param>
/// <param name="replyTime">要求回复时间</param>
/// <param name="appCount">出现次数</param>
/// <param name="associatedBillNo">问题相似的关联单据</param>
/// <param name="error">出错时返回错误信息，无错时返回null</param>
/// <returns>操作成功返回True，操作失败返回False</returns>
public bool UpdateZGAffirm(string billID, string ChargeSuggestion, string dutyDept,
DateTime replyTime, int appCount, string associatedBillNo, out string error)
{
error = "";
try
{
WebSeverDataContext dataContxt = WebDatabaseParameter.WebDataContext;
var varData = from a in dataContxt.S_ServiceFeedBack
where a.FK_Bill_ID == billID
select a;
if (varData.Count() != 1)
{
error = "数据有错误！";
return(false);
}
else
{
S_ServiceFeedBack list = varData.Single();
list.ZGChargeSuggestion = ChargeSuggestion;
list.DutyDept = dutyDept;
list.ReplyTime = replyTime;
list.AppearCount = appCount;
list.SignatureDate = ServerTime.Time;
list.Signature = BasicInfo.LoginID;
if (associatedBillNo == null)
{
list.Status = "等待责任部门确认";
}
else
{
list.Status = "单据完成";
var resultList = from c in dataContxt.S_ServiceFeedBack
where c.FK_Bill_ID == associatedBillNo
select c;
if (resultList.Count() == 1)
{
S_ServiceFeedBack feedback = resultList.Single();
list.Analyse = feedback.Analyse;
//list.foreverImplement = feedback.foreverImplement;
list.FinishClaim = feedback.FinishClaim;
list.IsFMEAfile = feedback.IsFMEAfile;
list.IsOpen = feedback.IsOpen;
list.Temporary = feedback.Temporary;
list.StockSuggestion = feedback.StockSuggestion;
list.SameBillNo = associatedBillNo;
list.DutyPerson = feedback.DutyPerson;
list.DutyDept = feedback.DutyDept;
list.Practicable = feedback.Practicable;
list.IsClose = "是";
}
}
dataContxt.SubmitChanges();
}
}
catch (Exception ex)
{
error = ex.Message;
return(false);
}
return(true);
}
