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