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