/// <summary> /// 获得实体集数据 /// </summary> void GetMessage() { m_lnqProductReleases = new ZL_ProductReleases(); m_lnqProductReleases.BillNo = txtBillNo.Text; m_lnqProductReleases.BillStatus = lbDJZT.Text; m_lnqProductReleases.FaultPhenomenon = txtFaultPhenomenon.Text; m_lnqProductReleases.ProductCode = txtProductCode.Text; m_lnqProductReleases.ProductModel = cmbEdition.Text; m_lnqProductReleases.Remark = txtRemark.Text; }
/// <summary> /// 提交单据 /// </summary> /// <param name="produtctReleases">LINQ实体集</param> /// <param name="error">错误信息</param> /// <returns>成功返回True,失败返回False</returns> public bool SubmitBill(ZL_ProductReleases produtctReleases, out string error) { error = null; DepotManagementDataContext ctx = CommentParameter.DepotDataContext; try { var varData = from a in ctx.ZL_ProductReleases where a.BillNo == produtctReleases.BillNo select a; ZL_ProductReleases lnqProductReleases = new ZL_ProductReleases(); if (varData.Count() == 0) { lnqProductReleases.BillNo = m_serverAssginBillNo.AssignNewNo(this, CE_BillTypeEnum.线不合格品放行单.ToString()); lnqProductReleases.BillStatus = "等待审核"; lnqProductReleases.FaultPhenomenon = produtctReleases.FaultPhenomenon; lnqProductReleases.ProductCode = produtctReleases.ProductCode; lnqProductReleases.ProductModel = produtctReleases.ProductModel; lnqProductReleases.Proposer = BasicInfo.LoginName; lnqProductReleases.ProposerDate = ServerTime.Time; lnqProductReleases.Remark = produtctReleases.Remark; ctx.ZL_ProductReleases.InsertOnSubmit(lnqProductReleases); } else if (varData.Count() == 1) { lnqProductReleases = varData.Single(); switch (lnqProductReleases.BillStatus) { case "新建单据": lnqProductReleases.BillStatus = "等待审核"; lnqProductReleases.FaultPhenomenon = produtctReleases.FaultPhenomenon; lnqProductReleases.ProductCode = produtctReleases.ProductCode; lnqProductReleases.ProductModel = produtctReleases.ProductModel; lnqProductReleases.Proposer = BasicInfo.LoginName; lnqProductReleases.ProposerDate = ServerTime.Time; lnqProductReleases.Remark = produtctReleases.Remark; break; case "等待审核": lnqProductReleases.BillStatus = "等待批准"; lnqProductReleases.Auditing = BasicInfo.LoginName; lnqProductReleases.AuditingDate = ServerTime.Time; break; case "等待批准": lnqProductReleases.BillStatus = "已完成"; lnqProductReleases.Authorize = BasicInfo.LoginName; lnqProductReleases.AuthorizeDate = ServerTime.Time; break; ; default: break; } } ctx.SubmitChanges(); return(true); } catch (Exception ex) { error = ex.Message; return(false); } }