/// <summary> /// 报废单据 /// </summary> /// <param name="djh">单据号</param> /// <param name="error">出错时返回错误信息,无错时返回null</param> /// <returns>报废单据成功返回True,报废单据失败返回False</returns> public bool ScarpData(string djh, out string error) { error = null; DepotManagementDataContext dataContxt = CommentParameter.DepotDataContext; try { var varData = from a in dataContxt.S_MessMessageFeedback where a.DJH == djh select a; if (varData.Count() == 1) { S_MessMessageFeedback lnqMess = varData.Single(); lnqMess.DJZT = "单据已报废"; dataContxt.SubmitChanges(); } return(true); } catch (Exception ex) { error = ex.Message; return(false); } }
private void 新建单据ToolStripMenuItem_Click(object sender, EventArgs e) { 质量信息反馈单 form = new 质量信息反馈单(""); form.ShowDialog(); m_blFlag = true; m_lnqMess = form.LnqMess; }
private void dataGridView1_DoubleClick(object sender, EventArgs e) { m_strDJH = dataGridView1.CurrentRow.Cells["单据号"].Value.ToString(); if (m_strDJH != "" || m_strDJH != null) { 质量信息反馈单 form = new 质量信息反馈单(m_strDJH); form.ShowDialog(); m_lnqMess = form.LnqMess; m_blFlag = false; } }
/// <summary> /// 插入记录 /// </summary> /// <param name="inMessMessage">反馈单信息</param> /// <param name="error">出错时返回错误信息,无错时返回null</param> /// <returns>插入成功返回True,插入失败返回False</returns> public bool InsertData(S_MessMessageFeedback inMessMessage, out string error) { error = null; try { DepotManagementDataContext dataContext = CommentParameter.DepotDataContext; dataContext.S_MessMessageFeedback.InsertOnSubmit(inMessMessage); dataContext.SubmitChanges(); return(true); } catch (Exception ex) { error = ex.Message; return(false); } }
public 质量信息反馈单(string strDJH) { InitializeComponent(); if (strDJH != "") { m_lnqMess = m_serverMess.GetData(strDJH); m_lnqViewCheck = m_serverMess.GetCheckInDepotBill(m_lnqMess.InDepotBillID); } else { m_blFlag = true; txtDJH.Text = "系统自动生成"; txtName.Enabled = true; txtBatchNo.Enabled = true; groupBox4.Text = groupBox6.Text; groupBox6.Text = ""; } }
/// <summary> /// 插入新数据 /// </summary> /// <param name="inMess">反馈单信息</param> /// <param name="error">出错时返回错误信息,无错时返回null</param> /// <returns>插入成功返回True,插入失败返回False</returns> public bool AddData(S_MessMessageFeedback inMess, out string error) { error = null; try { DepotManagementDataContext ctx = CommentParameter.DepotDataContext; var varData = from a in ctx.S_MessMessageFeedback where a.InDepotBillID == inMess.InDepotBillID select a; ctx.S_MessMessageFeedback.DeleteAllOnSubmit(varData); S_MessMessageFeedback lnqMess = new S_MessMessageFeedback(); lnqMess.DJH = inMess.DJH; lnqMess.ForGoodsStatus = inMess.ForGoodsStatus; lnqMess.MessageFromStatus = inMess.MessageFromStatus; lnqMess.DisqualificationDepict = inMess.DisqualificationDepict; lnqMess.QCRY = BasicInfo.LoginID; lnqMess.QCRQ = ServerTime.Time; lnqMess.DJZT = "等待STA意见"; lnqMess.InDepotBillID = inMess.InDepotBillID; ctx.S_MessMessageFeedback.InsertOnSubmit(lnqMess); ctx.SubmitChanges(); return(true); } catch (Exception ex) { error = ex.Message; return(false); } }
/// <summary> /// 回退单据 /// </summary> /// <param name="djh">单据号</param> /// <param name="flag">回退状态</param> /// <param name="error">出错时返回错误信息,无错时返回null</param> /// <param name="rebackReason">回退原因</param> /// <returns>回退成功返回True,回退失败返回False</returns> public bool ReturnData(string djh, string flag, out string error, string rebackReason) { error = null; DepotManagementDataContext dataContxt = CommentParameter.DepotDataContext; try { var varData = from a in dataContxt.S_MessMessageFeedback where a.DJH == djh select a; if (varData.Count() == 1) { S_MessMessageFeedback lnqMess = varData.Single(); switch (flag) { case "等待QC质量信息提交": lnqMess.DJZT = "等待QC质量信息提交"; lnqMess.SQERQ = null; lnqMess.SQERY = null; lnqMess.SQEYZRQ = null; lnqMess.SQEYZRY = null; lnqMess.QEQRRQ = null; lnqMess.QEQRRY = null; lnqMess.SQEvalidateMessage = null; lnqMess.SQEMindStatus = null; lnqMess.SQEElseMindMessage = null; lnqMess.ForGoodsStatus = null; lnqMess.MessageFromStatus = null; lnqMess.Picture = null; lnqMess.DisqualificationDepict = null; break; case "等待STA意见": lnqMess.DJZT = "等待STA意见"; lnqMess.SQEYZRQ = null; lnqMess.SQEYZRY = null; lnqMess.QEQRRQ = null; lnqMess.QEQRRY = null; lnqMess.SQEvalidateMessage = null; lnqMess.AllCount = null; lnqMess.DefectiveRate = null; lnqMess.Picture = null; lnqMess.SQEMindStatus = null; lnqMess.SQEElseMindMessage = null; break; case "等待质管部意见": lnqMess.DJZT = "等待质管部意见"; lnqMess.SQEYZRQ = null; lnqMess.SQEYZRY = null; lnqMess.QEQRRQ = null; lnqMess.QEQRRY = null; lnqMess.SQEvalidateMessage = null; break; case "等待STA验证": lnqMess.DJZT = "等待STA验证"; lnqMess.QEQRRQ = null; lnqMess.QEQRRY = null; lnqMess.SQEvalidateMessage = null; break; default: break; } dataContxt.SubmitChanges(); } return(true); } catch (Exception ex) { error = ex.Message; return(false); } }
/// <summary> /// 更新数据库 /// </summary> /// <param name="inMessMessage">反馈单信息</param> /// <param name="flag">更新状态</param> /// <param name="error">出错时返回错误信息,无错时返回null</param> /// <returns>更新成功返回True,更新失败返回False</returns> public bool UpdateData(S_MessMessageFeedback inMessMessage, string flag, out string error) { error = null; try { DepotManagementDataContext dataContxt = CommentParameter.DepotDataContext; var varData = from a in dataContxt.S_MessMessageFeedback where a.DJH == inMessMessage.DJH select a; if (varData.Count() == 1) { S_MessMessageFeedback lnqMess = varData.Single(); switch (flag) { case "不合格品信息": lnqMess.DJH = inMessMessage.DJH; lnqMess.ForGoodsStatus = inMessMessage.ForGoodsStatus; lnqMess.MessageFromStatus = inMessMessage.MessageFromStatus; lnqMess.DisqualificationDepict = inMessMessage.DisqualificationDepict; lnqMess.QCRY = BasicInfo.LoginID; lnqMess.QCRQ = ServerTime.Time; lnqMess.DJZT = "等待STA意见"; break; case "STA意见": lnqMess.LinkEmail = inMessMessage.LinkEmail; lnqMess.LinkMan = inMessMessage.LinkMan; lnqMess.LinkPhone = inMessMessage.LinkPhone; lnqMess.JLRD_LinkEmail = inMessMessage.JLRD_LinkEmail; lnqMess.JLRD_LinkMan = inMessMessage.JLRD_LinkMan; lnqMess.JLRD_LinkPhone = inMessMessage.JLRD_LinkPhone; lnqMess.RevertTime = inMessMessage.RevertTime; lnqMess.SQEMindStatus = inMessMessage.SQEMindStatus; lnqMess.SQEElseMindMessage = inMessMessage.SQEElseMindMessage; lnqMess.AllCount = inMessMessage.AllCount; lnqMess.DefectiveRate = inMessMessage.DefectiveRate; lnqMess.Picture = inMessMessage.Picture; lnqMess.SQERY = BasicInfo.LoginID; lnqMess.SQERQ = ServerTime.Time; lnqMess.DJZT = "等待STA验证"; break; case "STA验证": lnqMess.SQEvalidateMessage = inMessMessage.SQEvalidateMessage; lnqMess.SQEYZRY = BasicInfo.LoginID; lnqMess.SQEYZRQ = ServerTime.Time; lnqMess.DJZT = "等待质管部确认"; break; case "质管部确认": lnqMess.QEAffirmMessage = inMessMessage.QEAffirmMessage; lnqMess.QEQRRY = BasicInfo.LoginID; lnqMess.QEQRRQ = ServerTime.Time; lnqMess.DJZT = "单据已完成"; break; default: break; } dataContxt.SubmitChanges(); } return(true); } catch (Exception ex) { error = ex.Message; return(false); } }