//p判断现有库存数量大于出库数量 //库存单的构建schema H3.DataModel.BizObjectSchema schema = this.Request.Engine.BizObjectManager.GetPublishedSchema("D150516Schrygddhktx2lwxq4squp2zl2"); string sql = "select * from i_D150516Schrygddhktx2lwxq4squp2zl2 where joinMaterial= joinMaterial and address= address"; System.Data.DataTable table = this.Engine.Query.QueryTable(sql, null); if(table != null && table.Rows.Count > 0) { //new 一个库存单的对象 H3.DataModel.BizObject targetBo = new H3.DataModel.BizObject(this.Engine, schema, this.Request.UserContext.UserId); foreach(System.Data.DataRow row in table.Rows) { targetBo = H3.DataModel.BizObject.Load(this.Request.UserContext.UserId, this.Engine, "D150516Schrygddhktx2lwxq4squp2zl2", row["objectid"] + string.Empty, false); //获取到入库单子表的数组对象 H3.DataModel.BizObject[] childBo = (H3.DataModel.BizObject[]) this.Request.BizObject["D150516receive"]; foreach(H3.DataModel.BizObject child in childBo) { if((int) Convert.ToInt32(targetBo["inventoryMains"]) > (int) Convert.ToInt32(child["number"])) { break; } else { response.Errors.Add("现有数量不足!!!"); } base.OnSubmit(actionName, postValue, response); } } }