/// <summary> /// 工装业务处理 /// </summary> /// <param name="ctx">LINQ数据上下文</param> /// <param name="billNo">单据号</param> /// <param name="error">出错时返回错误信息,无错时返回null</param> /// <returns>操作成功返回True,操作失败返回False</returns> bool FinishFrock(DepotManagementDataContext ctx, string billNo, out string error) { error = null; try { var varData = from a in ctx.S_MaterialListReturnedInTheDepot where a.Bill_ID == billNo select a; bool blFlag = false; foreach (var item in varData) { if (UniversalFunction.IsInStandingBook(item.GoodsID, false)) { blFlag = true; if (!m_serverFrockStandingBook.IsOperationCountMateBillCount(item.GoodsID, item.Bill_ID, Convert.ToDecimal(item.ReturnedAmount))) { error = "领料数量与工装业务编号数不一致,请重新确认数量的一致性"; return(false); } } } if (blFlag) { string strSql = "select b.* from S_MaterialListReturnedInTheDepot as a inner join S_FrockOperation as b " + " on a.Bill_ID = b.BillID and a.GoodsID = b.GoodsID where a.Bill_ID = '" + billNo + "'"; if (!m_serverFrockStandingBook.UpdateFrockStandingBookStock(ctx, GlobalObject.DatabaseServer.QueryInfo(strSql), true, out error)) { return(false); } var varReport = from a in ctx.S_FrockOperation where a.BillID == billNo select a; foreach (var itemReport in varReport) { itemReport.IsTrue = true; } } return(true); } catch (Exception ex) { error = ex.Message; return(false); } }