/// <summary>
/// 获得数据
/// </summary>
void GetMessage()
{
if (lbBillNo.Text == "")
{
return;
}
m_lnqBill = new ZL_UnProductTestingSingleBill();
m_lnqBill.Amount = numAmount.Value;
m_lnqBill.Bill_ID = lbBillNo.Text;
m_lnqBill.BillStatus = lbBillStatus.Text;
m_lnqBill.Designer = txtDesigner.Text;
m_lnqBill.GoodsID = txtCode.Tag == null ? 0 : Convert.ToInt32(txtCode.Tag);
m_lnqBill.InspectorVerdict = txtInspectorVerdict.Text;
if (rbNo.Checked)
{
m_lnqBill.IsOK = false;
}
else if (rbYes.Checked)
{
m_lnqBill.IsOK = true;
}
m_lnqBill.JudgeInfo = txtJudgeInfo.Text;
m_lnqBill.ProvingVerdict = txtProvingVerdict.Text;
m_lnqBill.Remark = txtRemark.Text;
m_dtIn = (DataTable)dataGridViewIn.DataSource;
m_dtPro = (DataTable)dataGridViewPro.DataSource;
}
private void 非产品件检验单明细_Load(object sender, EventArgs e)
{
if (m_blSaveFlag)
{
toolStrip1.Visible = false;
}
if (m_strBillNo == null)
{
lbBillStatus.Text = "新建单据";
m_strBillNo = m_billNoControl.GetNewBillNo();
lbBillNo.Text = m_strBillNo;
}
m_lnqBill = m_serverUnProductTesting.GetInfo(m_strBillNo);
m_dtIn = m_serverUnProductTesting.GetListInfo(m_strBillNo, "检验");
m_dtPro = m_serverUnProductTesting.GetListInfo(m_strBillNo, "验证");
ShowMessage();
}
/// <summary>
/// 保存信息
/// </summary>
/// <param name="lnqBill">LINQ数据集</param>
/// <param name="InspectionTable">检验记录表</param>
/// <param name="ProvingTable">验证记录表</param>
/// <param name="error">错误信息</param>
/// <returns>成功返回True，失败返回False</returns>
public bool SaveInfo(ZL_UnProductTestingSingleBill lnqBill, DataTable InspectionTable, DataTable ProvingTable, out string error)
{
error = null;
try
{
DepotManagementDataContext ctx = CommentParameter.DepotDataContext;
if (lnqBill == null)
{
error = "数据为空无法保存";
return(false);
}
if (lnqBill.BillStatus == null)
{
error = "单据状态为空无法判断";
return(false);
}
var varData = from a in ctx.ZL_UnProductTestingSingleBill
where a.Bill_ID == lnqBill.Bill_ID
select a;
ZL_UnProductTestingSingleBill lnqTemp = new ZL_UnProductTestingSingleBill();
switch (lnqBill.BillStatus)
{
case "新建单据":
if (varData.Count() > 1)
{
error = "单据号重复";
return(false);
}
else if (varData.Count() == 0)
{
lnqTemp.Bill_ID = lnqBill.Bill_ID;
lnqTemp.BillStatus = lnqBill.BillStatus;
lnqTemp.GoodsID = lnqBill.GoodsID;
lnqTemp.Amount = lnqBill.Amount;
lnqTemp.Designer = lnqBill.Designer;
lnqTemp.Remark = lnqBill.Remark;
lnqTemp.Proposer = BasicInfo.LoginName;
lnqTemp.ProposerTime = ServerTime.Time;
ctx.ZL_UnProductTestingSingleBill.InsertOnSubmit(lnqTemp);
}
else if (varData.Count() == 1)
{
lnqTemp = varData.Single();
lnqTemp.GoodsID = lnqBill.GoodsID;
lnqTemp.Amount = lnqBill.Amount;
lnqTemp.Designer = lnqBill.Designer;
lnqTemp.Remark = lnqBill.Remark;
lnqTemp.Proposer = BasicInfo.LoginName;
lnqTemp.ProposerTime = ServerTime.Time;
}
break;
case "等待检验要求":
lnqTemp = varData.Single();
lnqTemp.InspectorRequest = BasicInfo.LoginName;
lnqTemp.InspectorRequestTime = ServerTime.Time;
SaveDataTableInfo(ctx, lnqBill.Bill_ID, InspectionTable, "检验");
break;
case "等待检验":
lnqTemp = varData.Single();
lnqTemp.Inspector = BasicInfo.LoginName;
lnqTemp.InspectorTime = ServerTime.Time;
lnqTemp.InspectorVerdict = lnqBill.InspectorVerdict;
SaveDataTableInfo(ctx, lnqBill.Bill_ID, InspectionTable, "检验");
break;
case "等待验证要求":
lnqTemp = varData.Single();
lnqTemp.ProvingRequest = BasicInfo.LoginName;
lnqTemp.ProvingRequestTime = ServerTime.Time;
SaveDataTableInfo(ctx, lnqBill.Bill_ID, ProvingTable, "验证");
break;
case "等待验证":
lnqTemp = varData.Single();
lnqTemp.Proving = BasicInfo.LoginName;
lnqTemp.ProvingTime = ServerTime.Time;
lnqTemp.ProvingVerdict = lnqBill.ProvingVerdict;
SaveDataTableInfo(ctx, lnqBill.Bill_ID, ProvingTable, "验证");
break;
case "等待最终判定":
lnqTemp = varData.Single();
lnqTemp.IsOK = lnqBill.IsOK;
lnqTemp.JudgeInfo = lnqBill.JudgeInfo;
lnqTemp.FinalJudge = BasicInfo.LoginName;
lnqTemp.FinalJudgeTime = ServerTime.Time;
break;
default:
break;
}
ctx.SubmitChanges();
return(true);
}
catch (Exception ex)
{
error = ex.Message;
return(false);
}
}
/// <summary>
/// 单据流程
/// </summary>
/// <param name="billNo">单据号</param>
/// <param name="error">错误信息</param>
/// <returns>成功返回True，失败返回False</returns>
public bool FlowBill(string billNo, out string error)
{
error = null;
try
{
DepotManagementDataContext ctx = CommentParameter.DepotDataContext;
var varData = from a in ctx.ZL_UnProductTestingSingleBill
where a.Bill_ID == billNo
select a;
if (varData.Count() != 1)
{
error = "单据号不存在或者重复";
return(false);
}
ZL_UnProductTestingSingleBill lnqBill = varData.Single();
switch (lnqBill.BillStatus)
{
case "新建单据":
lnqBill.BillStatus = "等待检验要求";
lnqBill.Proposer = BasicInfo.LoginName;
lnqBill.ProposerTime = ServerTime.Time;
break;
case "等待检验要求":
lnqBill.BillStatus = "等待检验";
lnqBill.InspectorRequest = BasicInfo.LoginName;
lnqBill.InspectorRequestTime = ServerTime.Time;
break;
case "等待检验":
lnqBill.BillStatus = "等待验证要求";
lnqBill.Inspector = BasicInfo.LoginName;
lnqBill.InspectorTime = ServerTime.Time;
break;
case "等待验证要求":
lnqBill.BillStatus = "等待验证";
lnqBill.ProvingRequest = BasicInfo.LoginName;
lnqBill.ProvingRequestTime = ServerTime.Time;
break;
case "等待验证":
lnqBill.BillStatus = "等待最终判定";
lnqBill.Proving = BasicInfo.LoginName;
lnqBill.ProvingTime = ServerTime.Time;
break;
case "等待最终判定":
lnqBill.BillStatus = "单据已完成";
lnqBill.FinalJudge = BasicInfo.LoginName;
lnqBill.FinalJudgeTime = ServerTime.Time;
break;
default:
break;
}
ctx.SubmitChanges();
return(true);
}
catch (Exception ex)
{
error = ex.Message;
return(false);
}
}
