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