public HeroEquipmentFormat GetRandomEquipmentByQualityGrade(EQUIPMENT_TYPE equipmentType, int quality) { var _equipmentTableList = EquipmentTableReader.Instance.FindDefault(equipmentType, (short)quality); int _weightMax = 0; for (int i = 0; i < _equipmentTableList.Count; i++) { _weightMax += _equipmentTableList [i].Weights; } int _random = Random.Range(1, _weightMax + 1); EquipmentTable _equipmentTable = null; int point = 0; for (int i = 0; i < _equipmentTableList.Count; i++) { if (point <= _random && _random <= point + _equipmentTableList [i].Weights) { _equipmentTable = _equipmentTableList [i].CloneEx(); break; } point += _equipmentTableList [i].Weights; } var _equipmentAttributeList = EquipmentAttributesTableReader.Instance.FindDefaultByEquipmentID(_equipmentTable.ID); List <EquipmentAttribute> equipmentAttributeBaseList = new List <EquipmentAttribute> (); for (int i = 0; i < _equipmentAttributeList.Count; i++) { int attribute = CalculateAttributeOffSet(_equipmentAttributeList[i].ParameterA, _equipmentAttributeList[i].ParameterB); equipmentAttributeBaseList.Add(new EquipmentAttribute(_equipmentAttributeList[i].AttributeType, attribute)); } List <EquipmentAttribute> _equipmentAttrubuteOffsetList = new List <EquipmentAttribute>(); HeroEquipmentFormat _heroEquipment = new HeroEquipmentFormat(_equipmentTable, equipmentAttributeBaseList, _equipmentAttrubuteOffsetList); return(_heroEquipment); }
private void EquipmentExport_button_Click(object sender, RoutedEventArgs e) { EquipmentTable.ExportExcel("select * from ArmsInfo", Str, "装备信息表.xlsx"); }
//JAVA TO C# CONVERTER WARNING: Method 'throws' clauses are not available in C#: //ORIGINAL LINE: private void saveOrUpdateAssemblyTable(org.hibernate.Session paramSession, Desktop.common.nomitech.common.migration.spon.SponLineItem paramSponLineItem, nomitech.common.db.local.MaterialTable paramMaterialTable, nomitech.common.db.local.SubcontractorTable paramSubcontractorTable, nomitech.common.db.local.EquipmentTable paramEquipmentTable) throws Exception private void saveOrUpdateAssemblyTable(Session paramSession, SponLineItem paramSponLineItem, MaterialTable paramMaterialTable, SubcontractorTable paramSubcontractorTable, EquipmentTable paramEquipmentTable) { SponLineItem sponLineItem; for (sponLineItem = (SponLineItem)paramSponLineItem.Parent; string.ReferenceEquals(sponLineItem.WbsCode, null); sponLineItem = (SponLineItem)sponLineItem.Parent) { ; } AssemblyTable assemblyTable = BlankResourceInitializer.createBlankAssembly(null); assemblyTable.AssemblyId = null; assemblyTable.Title = paramSponLineItem.makeShortTitle(); string str = convertToCostOSUnit(paramSponLineItem.Unit); if (string.ReferenceEquals(str, null)) { throw new Exception("FATAL: UNIT WAS NULL FOR " + paramSponLineItem.Unit); } assemblyTable.GroupCode = sponLineItem.WbsCode + " - " + sponLineItem.makeShortTitle(); assemblyTable.GekCode = ""; assemblyTable.Unit = str; assemblyTable.EditorId = "spon"; assemblyTable.StateProvince = ""; assemblyTable.Country = "GB"; assemblyTable.Currency = "GBP"; assemblyTable.Productivity = BigDecimalMath.ZERO; assemblyTable.Project = ""; assemblyTable.PublishedRate = new BigDecimalFixed("" + convertToCostOSRate(paramSponLineItem.Unit, paramSponLineItem.Total)); assemblyTable.PublishedRevisionCode = paramSponLineItem.Code; assemblyTable.Notes = "SPON Major Rate"; assemblyTable.Description = paramSponLineItem.makeFullDescription() + "\nCODE: " + paramSponLineItem.Code; assemblyTable.Virtual = false; assemblyTable.VirtualEquipment = false; assemblyTable.VirtualSubcontractor = false; assemblyTable.VirtualLabor = false; assemblyTable.VirtualMaterial = false; assemblyTable.VirtualConsumable = false; assemblyTable.LastUpdate = this.lastUpdate; assemblyTable.Quantity = new BigDecimalFixed("0"); assemblyTable.Accuracy = "enum.quotation.accuracy.estimated"; assemblyTable.CreateDate = assemblyTable.LastUpdate; assemblyTable.CreateUserId = "spon"; Serializable serializable = assemblyTable.AssemblyId; if (serializable == null) { serializable = paramSession.save(assemblyTable); } else { paramSession.update(assemblyTable); } assemblyTable = (AssemblyTable)paramSession.load(typeof(AssemblyTable), serializable); if (paramSubcontractorTable != null) { paramSubcontractorTable = (SubcontractorTable)DatabaseDBUtil.loadBulk(typeof(SubcontractorTable), new long?[] { paramSubcontractorTable.SubcontractorId })[0]; AssemblySubcontractorTable assemblySubcontractorTable = new AssemblySubcontractorTable(); assemblySubcontractorTable.Factor1 = BigDecimalMath.ONE; assemblySubcontractorTable.Factor2 = BigDecimalMath.ONE; assemblySubcontractorTable.Factor3 = BigDecimalMath.ONE; assemblySubcontractorTable.QuantityPerUnit = BigDecimalMath.ONE; assemblySubcontractorTable.QuantityPerUnitFormula = ""; assemblySubcontractorTable.QuantityPerUnitFormulaState = ResourceToAssignmentTable.QTYPUFORM_NOFORMULA; assemblySubcontractorTable.LocalFactor = BigDecimalMath.ONE; assemblySubcontractorTable.LocalCountry = ""; assemblySubcontractorTable.LocalStateProvince = ""; assemblySubcontractorTable.LastUpdate = assemblyTable.LastUpdate; long?long = (long?)paramSession.save(assemblySubcontractorTable); assemblySubcontractorTable.AssemblySubcontractorId = long; if (DatabaseDBUtil.LocalCommunication) { paramSubcontractorTable.AssemblySubcontractorSet.Add(assemblySubcontractorTable); paramSession.saveOrUpdate(paramSubcontractorTable); assemblyTable.AssemblySubcontractorSet.Add(assemblySubcontractorTable); paramSession.saveOrUpdate(assemblyTable); assemblySubcontractorTable.SubcontractorTable = paramSubcontractorTable; assemblySubcontractorTable.AssemblyTable = assemblyTable; paramSession.saveOrUpdate(assemblySubcontractorTable); } else { assemblySubcontractorTable = (AssemblySubcontractorTable)DatabaseDBUtil.associateAssemblyResource(assemblyTable, paramSubcontractorTable, assemblySubcontractorTable); assemblyTable = (AssemblyTable)paramSession.load(typeof(AssemblyTable), assemblyTable.Id); } } if (paramMaterialTable != null) { paramMaterialTable = (MaterialTable)DatabaseDBUtil.loadBulk(typeof(MaterialTable), new long?[] { paramMaterialTable.MaterialId })[0]; AssemblyMaterialTable assemblyMaterialTable = new AssemblyMaterialTable(); assemblyMaterialTable.Factor1 = BigDecimalMath.ONE; assemblyMaterialTable.Factor2 = BigDecimalMath.ONE; assemblyMaterialTable.Factor3 = BigDecimalMath.ONE; assemblyMaterialTable.QuantityPerUnit = BigDecimalMath.ONE; assemblyMaterialTable.QuantityPerUnitFormula = ""; assemblyMaterialTable.QuantityPerUnitFormulaState = ResourceToAssignmentTable.QTYPUFORM_NOFORMULA; assemblyMaterialTable.LocalFactor = BigDecimalMath.ONE; assemblyMaterialTable.LocalCountry = ""; assemblyMaterialTable.LocalStateProvince = ""; assemblyMaterialTable.LastUpdate = assemblyTable.LastUpdate; long?long = (long?)paramSession.save(assemblyMaterialTable); assemblyMaterialTable.AssemblyMaterialId = long; if (DatabaseDBUtil.LocalCommunication) { paramMaterialTable.AssemblyMaterialSet.Add(assemblyMaterialTable); paramSession.saveOrUpdate(paramMaterialTable); assemblyTable.AssemblyMaterialSet.Add(assemblyMaterialTable); paramSession.saveOrUpdate(assemblyTable); assemblyMaterialTable.MaterialTable = paramMaterialTable; assemblyMaterialTable.AssemblyTable = assemblyTable; paramSession.saveOrUpdate(assemblyMaterialTable); } else { assemblyMaterialTable = (AssemblyMaterialTable)DatabaseDBUtil.associateAssemblyResource(assemblyTable, paramMaterialTable, assemblyMaterialTable); assemblyTable = (AssemblyTable)paramSession.load(typeof(AssemblyTable), assemblyTable.Id); } } if (paramEquipmentTable != null) { paramEquipmentTable = (EquipmentTable)DatabaseDBUtil.loadBulk(typeof(EquipmentTable), new long?[] { paramEquipmentTable.EquipmentId })[0]; AssemblyEquipmentTable assemblyEquipmentTable = new AssemblyEquipmentTable(); assemblyEquipmentTable.Factor1 = BigDecimalMath.ONE; assemblyEquipmentTable.Factor2 = BigDecimalMath.ONE; assemblyEquipmentTable.Factor3 = BigDecimalMath.ONE; assemblyEquipmentTable.QuantityPerUnit = BigDecimalMath.ONE; assemblyEquipmentTable.QuantityPerUnitFormula = ""; assemblyEquipmentTable.QuantityPerUnitFormulaState = ResourceToAssignmentTable.QTYPUFORM_NOFORMULA; assemblyEquipmentTable.LocalFactor = BigDecimalMath.ONE; assemblyEquipmentTable.LocalCountry = ""; assemblyEquipmentTable.LocalStateProvince = ""; assemblyEquipmentTable.EnergyPrice = BigDecimalMath.ZERO; assemblyEquipmentTable.FuelRate = BigDecimalMath.ZERO; assemblyEquipmentTable.LastUpdate = assemblyTable.LastUpdate; long?long = (long?)paramSession.save(assemblyEquipmentTable); assemblyEquipmentTable.AssemblyEquipmentId = long; if (DatabaseDBUtil.LocalCommunication) { paramEquipmentTable.AssemblyEquipmentSet.Add(assemblyEquipmentTable); paramSession.saveOrUpdate(paramEquipmentTable); assemblyTable.AssemblyEquipmentSet.Add(assemblyEquipmentTable); paramSession.saveOrUpdate(assemblyTable); assemblyEquipmentTable.EquipmentTable = paramEquipmentTable; assemblyEquipmentTable.AssemblyTable = assemblyTable; paramSession.saveOrUpdate(assemblyEquipmentTable); } else { assemblyEquipmentTable = (AssemblyEquipmentTable)DatabaseDBUtil.associateAssemblyResource(assemblyTable, paramEquipmentTable, assemblyEquipmentTable); assemblyTable = (AssemblyTable)paramSession.load(typeof(AssemblyTable), assemblyTable.Id); } } assemblyTable = (AssemblyTable)paramSession.load(typeof(AssemblyTable), assemblyTable.Id); assemblyTable.recalculate(); paramSession.update(assemblyTable); }
public EquipmentsMib(string baseOid, int equipmentsCount) { Mib = new List <MibObject>(); equipments = new EquipmentTable(baseOid, equipmentsCount); }
//JAVA TO C# CONVERTER WARNING: Method 'throws' clauses are not available in C#: //ORIGINAL LINE: private void loadLineItems(org.hibernate.Session paramSession, String paramString) throws Exception private void loadLineItems(Session paramSession, string paramString) { POIFSFileSystem pOIFSFileSystem = new POIFSFileSystem(new FileStream(paramString, FileMode.Open, FileAccess.Read)); HSSFWorkbook hSSFWorkbook = new HSSFWorkbook(pOIFSFileSystem); this.o_evaluator = hSSFWorkbook.CreationHelper.createFormulaEvaluator(); HSSFSheet hSSFSheet = hSSFWorkbook.getSheetAt(0); Console.WriteLine("Loading Line Items..."); int i = getRealNumberOfRows(hSSFSheet); string str1 = null; string str2 = null; GroupCodeTable groupCodeTable = null; string str3 = null; for (int j = 1; j < i; j++) { if (j % this.rowsToCommit == 0) { paramSession.Transaction.commit(); paramSession.Transaction.begin(); Console.WriteLine("Processing next 500..."); } HSSFRow hSSFRow = hSSFSheet.getRow(j); string str4 = notNull(hSSFRow.getCell(0)); string str5 = notNull(hSSFRow.getCell(1)); if (!str4.StartsWith("Group", StringComparison.Ordinal)) { string str6 = notNull(hSSFRow.getCell(2)); string str7 = notNull(hSSFRow.getCell(3)); if (!StringUtils.isNullOrBlank(str4)) { Console.WriteLine(str6 + " - " + str7); str1 = str4; str1 = StringUtils.replaceAll(str1, ".", ""); str1 = StringUtils.replaceAll(str1, "-", ""); str1 = str1.Substring(0, 4); str3 = str1; GroupCode groupCode = addGroupCode1(str1, str7); this.dprPhaseMap[str6] = groupCode; paramSession.save(groupCode); } else if (!StringUtils.isNullOrBlank(str5)) { Console.WriteLine(str6 + " - " + str7); str2 = str5; str2 = StringUtils.replaceAll(str2, ".", ""); str2 = StringUtils.replaceAll(str2, "-", ""); str1 = str2.Substring(0, 4); str2 = str2.Substring(4, str2.Length - 4); GroupCode groupCode = addGroupCode1(str3 + "." + str2, str7); this.dprPhaseMap[str6] = groupCode; long?long = (long?)paramSession.save(groupCode); groupCodeTable = (GroupCodeTable)groupCode; groupCodeTable.GroupCodeId = long; } else { decimal bigDecimal1 = notNullBigDecimal(hSSFRow.getCell(4), 1.0D); string str8 = toCorrectUnit(notNull(hSSFRow.getCell(5))); string str9 = notNull(hSSFRow.getCell(6)); decimal bigDecimal2 = notNullBigDecimal(hSSFRow.getCell(7), 0.0D); string str10 = toCorrectUnit(notNull(hSSFRow.getCell(8))); decimal bigDecimal3 = notNullBigDecimal(hSSFRow.getCell(9), 0.0D); string str11 = toCorrectUnit(notNull(hSSFRow.getCell(10))); decimal bigDecimal4 = notNullBigDecimal(hSSFRow.getCell(11), 0.0D); string str12 = notNull(hSSFRow.getCell(12)).ToUpper(); decimal bigDecimal5 = notNullBigDecimal(hSSFRow.getCell(13), 0.0D); string str13 = toCorrectUnit(notNull(hSSFRow.getCell(14))); decimal bigDecimal6 = notNullBigDecimal(hSSFRow.getCell(15), 0.0D); decimal bigDecimal7 = notNullBigDecimal(hSSFRow.getCell(16), 1.0D); string str14 = toCorrectUnit(notNull(hSSFRow.getCell(17))); decimal bigDecimal8 = notNullBigDecimal(hSSFRow.getCell(18), 1.0D); string str15 = toCorrectUnit(notNull(hSSFRow.getCell(19))); decimal bigDecimal9 = notNullBigDecimal(hSSFRow.getCell(20), 0.0D); string str16 = toCorrectUnit(notNull(hSSFRow.getCell(21))); decimal bigDecimal10 = notNullBigDecimal(hSSFRow.getCell(22), 0.0D); decimal bigDecimal11 = notNullBigDecimal(hSSFRow.getCell(23), 0.0D); string str17 = toCorrectUnit(notNull(hSSFRow.getCell(24))); decimal bigDecimal12 = notNullBigDecimal(hSSFRow.getCell(25), 0.0D); string str18 = toCorrectUnit(notNull(hSSFRow.getCell(26))); decimal bigDecimal13 = notNullBigDecimal(hSSFRow.getCell(27), 0.0D); string str19 = toCorrectUnit(notNull(hSSFRow.getCell(28))); decimal bigDecimal14 = notNullBigDecimal(hSSFRow.getCell(29), 0.0D); string str20 = toCorrectUnit(notNull(hSSFRow.getCell(30))); decimal bigDecimal15 = notNullBigDecimal(hSSFRow.getCell(31), 0.0D); decimal bigDecimal16 = notNullBigDecimal(hSSFRow.getCell(32), 1.0D); string str21 = toCorrectUnit(notNull(hSSFRow.getCell(33))); decimal bigDecimal17 = notNullBigDecimal(hSSFRow.getCell(34), 0.0D); string str22 = toCorrectUnit(notNull(hSSFRow.getCell(35))); decimal bigDecimal18 = notNullBigDecimal(hSSFRow.getCell(36), 1.0D); string str23 = toCorrectUnit(notNull(hSSFRow.getCell(37))); decimal bigDecimal19 = notNullBigDecimal(hSSFRow.getCell(38), 0.0D); string str24 = toCorrectUnit(notNull(hSSFRow.getCell(39))); decimal bigDecimal20 = notNullBigDecimal(hSSFRow.getCell(40), 0.0D); decimal bigDecimal21 = notNullBigDecimal(hSSFRow.getCell(41), 0.0D); string str25 = toCorrectUnit(notNull(hSSFRow.getCell(42))); decimal bigDecimal22 = notNullBigDecimal(hSSFRow.getCell(43), 0.0D); string str26 = toCorrectUnit(notNull(hSSFRow.getCell(44))); decimal bigDecimal23 = notNullBigDecimal(hSSFRow.getCell(45), 0.0D); string str27 = toCorrectUnit(notNull(hSSFRow.getCell(46))); decimal bigDecimal24 = notNullBigDecimal(hSSFRow.getCell(47), 0.0D); string str28 = toCorrectUnit(notNull(hSSFRow.getCell(48))); decimal bigDecimal25 = notNullBigDecimal(hSSFRow.getCell(49), 0.0D); decimal bigDecimal26 = notNullBigDecimal(hSSFRow.getCell(50), 0.0D); string str29 = toCorrectUnit(notNull(hSSFRow.getCell(51))); decimal bigDecimal27 = notNullBigDecimal(hSSFRow.getCell(52), 0.0D); Console.WriteLine(str6 + " - " + str7 + " " + str8 + " " + bigDecimal1 + " " + str9 + " " + bigDecimal27); string str30 = notNull(hSSFRow.getCell(53)); string str31 = notNull(hSSFRow.getCell(54)); string str32 = notNull(hSSFRow.getCell(55)); string str33 = notNull(hSSFRow.getCell(56)); string str34 = notNull(hSSFRow.getCell(57)); string str35 = notNull(hSSFRow.getCell(58)); string str36 = notNull(hSSFRow.getCell(59)); AssemblyTable assemblyTable = BlankResourceInitializer.createBlankAssembly(null); assemblyTable.ItemCode = str6; assemblyTable.PublishedRevisionCode = str6; assemblyTable.Title = str7; assemblyTable.Unit = str8; assemblyTable.Currency = "USD"; assemblyTable.Country = "US"; assemblyTable.Quantity = bigDecimal1; assemblyTable.LastUpdate = this.lastUpdate; assemblyTable.Description = ""; assemblyTable.LastUpdate = this.lastUpdate; assemblyTable.CreateDate = this.lastUpdate; assemblyTable.CreateUserId = "admin"; assemblyTable.EditorId = "admin"; if (groupCodeTable != null) { assemblyTable.GroupCode = groupCodeTable.ToString(); } assemblyTable.AssemblyEquipmentSet = new HashSet <object>(); assemblyTable.AssemblySubcontractorSet = new HashSet <object>(); assemblyTable.AssemblyLaborSet = new HashSet <object>(); assemblyTable.AssemblyMaterialSet = new HashSet <object>(); assemblyTable.AssemblyConsumableSet = new HashSet <object>(); long?long = (long?)paramSession.save(assemblyTable.clone()); assemblyTable = (AssemblyTable)paramSession.load(typeof(AssemblyTable), long); if (!StringUtils.isNullOrBlank(str9)) { LaborTable laborTable = (LaborTable)this.laborCache[str9]; if (laborTable == null) { laborTable = BlankResourceInitializer.createBlankLabor(null); laborTable.Title = str9; laborTable.Unit = "HOUR"; laborTable.Rate = bigDecimal5; laborTable.IKA = BigDecimalMath.ZERO; laborTable.Currency = "USD"; laborTable.Country = "US"; laborTable.LastUpdate = this.lastUpdate; laborTable.CreateDate = this.lastUpdate; laborTable.CreateUserId = "admin"; laborTable.EditorId = "admin"; long = (long?)paramSession.save(laborTable.clone()); laborTable.Id = long; this.laborCache[str9] = laborTable; } else { laborTable = (LaborTable)paramSession.load(typeof(LaborTable), laborTable.Id); } if (BigDecimalMath.cmp(bigDecimal4, BigDecimalMath.ZERO) <= 0 && BigDecimalMath.cmp(bigDecimal2, BigDecimalMath.ZERO) > 0) { bigDecimal4 = BigDecimalMath.div(BigDecimalMath.ONE, bigDecimal2); } laborTable = (LaborTable)paramSession.load(typeof(LaborTable), laborTable.Id); AssemblyLaborTable assemblyLaborTable = new AssemblyLaborTable(); assemblyLaborTable.Factor1 = BigDecimalMath.ONE; assemblyLaborTable.Factor2 = BigDecimalMath.ONE; assemblyLaborTable.Factor3 = BigDecimalMath.ONE; assemblyLaborTable.ExchangeRate = BigDecimalMath.ONE; assemblyLaborTable.QuantityPerUnit = bigDecimal4; assemblyLaborTable.QuantityPerUnitFormula = ""; assemblyLaborTable.QuantityPerUnitFormulaState = ResourceToAssignmentTable.QTYPUFORM_NOFORMULA; assemblyLaborTable.LocalFactor = BigDecimalMath.ONE; assemblyLaborTable.LocalCountry = ""; assemblyLaborTable.LocalStateProvince = ""; assemblyLaborTable.LastUpdate = assemblyTable.LastUpdate; long = (long?)paramSession.save(assemblyLaborTable); assemblyLaborTable.AssemblyLaborId = long; assemblyTable.AssemblyLaborSet.Add(assemblyLaborTable); paramSession.saveOrUpdate(assemblyTable); assemblyLaborTable.LaborTable = laborTable; assemblyLaborTable.AssemblyTable = assemblyTable; paramSession.saveOrUpdate(assemblyLaborTable); } if (bigDecimal14 != null && BigDecimalMath.cmp(bigDecimal14, BigDecimalMath.ZERO) > 0) { if (bigDecimal11 != null && BigDecimalMath.cmp(bigDecimal11, BigDecimalMath.ZERO) > 0) { decimal bigDecimal = bigDecimal13; if (BigDecimalMath.cmp(bigDecimal, BigDecimalMath.ZERO) <= 0 && BigDecimalMath.cmp(bigDecimal11, BigDecimalMath.ZERO) > 0) { bigDecimal = BigDecimalMath.div(BigDecimalMath.ONE, bigDecimal11); } if (str8.Equals("DAY")) { bigDecimal14 = BigDecimalMath.mult(bigDecimal14, BigDecimalMath.div(BigDecimalMath.ONE, HOURS_OF_DAY)); } else if (str8.Equals("WEEK") || str8.Equals("WK")) { bigDecimal14 = BigDecimalMath.mult(bigDecimal14, BigDecimalMath.div(BigDecimalMath.ONE, HOURS_OF_WEEK)); } else if (str8.Equals("MONTH") || str8.Equals("MO")) { bigDecimal14 = BigDecimalMath.mult(bigDecimal14, BigDecimalMath.div(BigDecimalMath.ONE, HOURS_OF_MONTH)); } if (str20.Equals("WEEK")) { bigDecimal = BigDecimalMath.mult(bigDecimal, HOURS_OF_WEEK); } else if (str20.Equals("MO") || str20.Equals("MONTH")) { bigDecimal = BigDecimalMath.mult(bigDecimal, HOURS_OF_MONTH); } else if (str20.Equals("DAY")) { bigDecimal = BigDecimalMath.mult(bigDecimal, HOURS_OF_DAY); } EquipmentTable equipmentTable = BlankResourceInitializer.createBlankEquipment(assemblyTable); equipmentTable.Title = assemblyTable.Title; equipmentTable.Unit = str20; equipmentTable.ReservationRate = bigDecimal14; equipmentTable.Currency = "USD"; equipmentTable.EditorId = "admin"; equipmentTable.Country = "US"; equipmentTable.LastUpdate = this.lastUpdate; equipmentTable.CreateDate = this.lastUpdate; equipmentTable.CreateUserId = "admin"; equipmentTable.EditorId = "admin"; long = (long?)paramSession.save(equipmentTable.clone()); equipmentTable.Id = long; equipmentTable = (EquipmentTable)paramSession.load(typeof(EquipmentTable), long); AssemblyEquipmentTable assemblyEquipmentTable = new AssemblyEquipmentTable(); assemblyEquipmentTable.Factor1 = BigDecimalMath.ONE; assemblyEquipmentTable.Factor2 = BigDecimalMath.ONE; assemblyEquipmentTable.Factor3 = BigDecimalMath.ONE; assemblyEquipmentTable.ExchangeRate = BigDecimalMath.ONE; assemblyEquipmentTable.QuantityPerUnit = bigDecimal; assemblyEquipmentTable.QuantityPerUnitFormula = ""; assemblyEquipmentTable.QuantityPerUnitFormulaState = ResourceToAssignmentTable.QTYPUFORM_NOFORMULA; assemblyEquipmentTable.LocalFactor = BigDecimalMath.ONE; assemblyEquipmentTable.LocalCountry = ""; assemblyEquipmentTable.LocalStateProvince = ""; assemblyEquipmentTable.EnergyPrice = BigDecimalMath.ZERO; assemblyEquipmentTable.FuelRate = BigDecimalMath.ZERO; assemblyEquipmentTable.LastUpdate = assemblyTable.LastUpdate; long = (long?)paramSession.save(assemblyEquipmentTable); assemblyEquipmentTable.AssemblyEquipmentId = long; assemblyTable.AssemblyEquipmentSet.Add(assemblyEquipmentTable); paramSession.saveOrUpdate(assemblyTable); assemblyEquipmentTable.EquipmentTable = equipmentTable; assemblyEquipmentTable.AssemblyTable = assemblyTable; paramSession.saveOrUpdate(assemblyEquipmentTable); } else { createSubcontractor(paramSession, assemblyTable, "Equipment: " + assemblyTable.Title, bigDecimal14, str20, bigDecimal13); } } if (bigDecimal9 != null && BigDecimalMath.cmp(bigDecimal9, BigDecimalMath.ZERO) > 0) { MaterialTable materialTable = BlankResourceInitializer.createBlankMaterial(assemblyTable); materialTable.Title = assemblyTable.Title; materialTable.Unit = str16; materialTable.Rate = bigDecimal9; materialTable.Currency = "USD"; materialTable.EditorId = "admin"; materialTable.Country = "US"; materialTable.LastUpdate = this.lastUpdate; materialTable.CreateDate = this.lastUpdate; materialTable.CreateUserId = "admin"; materialTable.EditorId = "admin"; long = (long?)paramSession.save(materialTable.clone()); materialTable.Id = long; materialTable = (MaterialTable)paramSession.load(typeof(MaterialTable), long); AssemblyMaterialTable assemblyMaterialTable = new AssemblyMaterialTable(); assemblyMaterialTable.Factor1 = BigDecimalMath.ONE; assemblyMaterialTable.Factor2 = BigDecimalMath.ONE; assemblyMaterialTable.Factor3 = BigDecimalMath.ONE; assemblyMaterialTable.ExchangeRate = BigDecimalMath.ONE; assemblyMaterialTable.QuantityPerUnit = bigDecimal8; assemblyMaterialTable.QuantityPerUnitFormula = ""; assemblyMaterialTable.QuantityPerUnitFormulaState = ResourceToAssignmentTable.QTYPUFORM_NOFORMULA; assemblyMaterialTable.LocalFactor = BigDecimalMath.ONE; assemblyMaterialTable.LocalCountry = ""; assemblyMaterialTable.LocalStateProvince = ""; assemblyMaterialTable.LastUpdate = assemblyTable.LastUpdate; long = (long?)paramSession.save(assemblyMaterialTable); assemblyMaterialTable.AssemblyMaterialId = long; assemblyTable.AssemblyMaterialSet.Add(assemblyMaterialTable); paramSession.saveOrUpdate(assemblyTable); assemblyMaterialTable.MaterialTable = materialTable; assemblyMaterialTable.AssemblyTable = assemblyTable; paramSession.saveOrUpdate(assemblyMaterialTable); } if (bigDecimal24 != null && BigDecimalMath.cmp(bigDecimal24, BigDecimalMath.ZERO) > 0) { createSubcontractor(paramSession, assemblyTable, assemblyTable.Title, bigDecimal24, str28, bigDecimal23); } if (bigDecimal19 != null && BigDecimalMath.cmp(bigDecimal19, BigDecimalMath.ZERO) > 0) { ConsumableTable consumableTable = BlankResourceInitializer.createBlankConsumable(assemblyTable); consumableTable.Title = assemblyTable.Title; consumableTable.Unit = str24; consumableTable.Rate = bigDecimal19; consumableTable.Currency = "USD"; consumableTable.EditorId = "admin"; consumableTable.Country = "US"; consumableTable.LastUpdate = this.lastUpdate; consumableTable.CreateDate = this.lastUpdate; consumableTable.CreateUserId = "admin"; consumableTable.EditorId = "admin"; long = (long?)paramSession.save(consumableTable.clone()); consumableTable.Id = long; consumableTable = (ConsumableTable)paramSession.load(typeof(ConsumableTable), long); AssemblyConsumableTable assemblyConsumableTable = new AssemblyConsumableTable(); assemblyConsumableTable.Factor1 = BigDecimalMath.ONE; assemblyConsumableTable.Factor2 = BigDecimalMath.ONE; assemblyConsumableTable.Factor3 = BigDecimalMath.ONE; assemblyConsumableTable.ExchangeRate = BigDecimalMath.ONE; assemblyConsumableTable.QuantityPerUnit = bigDecimal18; assemblyConsumableTable.QuantityPerUnitFormula = ""; assemblyConsumableTable.QuantityPerUnitFormulaState = ResourceToAssignmentTable.QTYPUFORM_NOFORMULA; assemblyConsumableTable.LocalFactor = BigDecimalMath.ONE; assemblyConsumableTable.LocalCountry = ""; assemblyConsumableTable.LocalStateProvince = ""; assemblyConsumableTable.LastUpdate = assemblyTable.LastUpdate; long = (long?)paramSession.save(assemblyConsumableTable); assemblyConsumableTable.AssemblyConsumableId = long; assemblyTable.AssemblyConsumableSet.Add(assemblyConsumableTable); paramSession.saveOrUpdate(assemblyTable); assemblyConsumableTable.ConsumableTable = consumableTable; assemblyConsumableTable.AssemblyTable = assemblyTable; paramSession.saveOrUpdate(assemblyConsumableTable); } if (DatabaseDBUtil.LocalCommunication) { assemblyTable.recalculate(); paramSession.saveOrUpdate(assemblyTable); } } } } if (hSSFWorkbook != null) { hSSFWorkbook.close(); } }
static public void LoadTable() { if (null == QTESequenceTableAsset) { TextAsset asset = GameData.LoadConfig <TextAsset>("QTESequenceTable"); QTESequenceTableAsset = new QTESequenceTable(); QTESequenceTableAsset.Load(asset.bytes); } if (null == FlyingItemTableAsset) { TextAsset asset = GameData.LoadConfig <TextAsset>("FlyingObjBehaviorTable"); FlyingItemTableAsset = new FlyingItemTable(); FlyingItemTableAsset.Load(asset.bytes); } if (null == StageTableAsset) { TextAsset asset = GameData.LoadConfig <TextAsset>("StageTable"); StageTableAsset = new StageTable(); StageTableAsset.Load(asset.bytes); } if (null == RoomAttrTableAsset) { TextAsset asset = GameData.LoadConfig <TextAsset>("RoomAttrTable"); RoomAttrTableAsset = new RoomAttrTable(); RoomAttrTableAsset.Load(asset.bytes); } if (null == SkillTableAsset) { TextAsset asset = GameData.LoadConfig <TextAsset>("SkillTable"); SkillTableAsset = new SkillTable(); SkillTableAsset.Load(asset.bytes); } if (null == VocationTableAsset) { TextAsset asset = GameData.LoadConfig <TextAsset>("VocationTable"); VocationTableAsset = new VocationTable(); VocationTableAsset.Load(asset.bytes); } if (null == NPCInfoTableAsset) { TextAsset asset = GameData.LoadConfig <TextAsset>("NPCInfoTable"); NPCInfoTableAsset = new NPCInfoTable(); NPCInfoTableAsset.Load(asset.bytes); } if (null == TrapInfoTableAsset) { TextAsset asset = GameData.LoadConfig <TextAsset>("TrapInfoTable"); TrapInfoTableAsset = new TrapInfoTable(); TrapInfoTableAsset.Load(asset.bytes); } if (null == HeroInfoTableAsset) { TextAsset asset = GameData.LoadConfig <TextAsset>("HeroInfoTable"); HeroInfoTableAsset = new HeroInfoTable(); HeroInfoTableAsset.Load(asset.bytes); } //if (null == AnimWeightTableAsset) //{ // TextAsset asset = GameData.LoadConfig<TextAsset>("AnimWeight"); // AnimWeightTableAsset = new AnimWeightTable(); // AnimWeightTableAsset.Load(asset.bytes); //} if (null == SceneInfoTableAsset) { TextAsset asset = GameData.LoadConfig <TextAsset>("SceneInfoTable"); SceneInfoTableAsset = new SceneInfoTable(); SceneInfoTableAsset.Load(asset.bytes); } //if (null == DungeonInfoTableAsset) //{ // TextAsset asset = GameData.LoadConfig<TextAsset>("DungeonInfoTable"); // DungeonInfoTableAsset = new DungeonInfoTable(); // DungeonInfoTableAsset.Load(asset.bytes); //} if (null == SkillResultTableAsset) { TextAsset asset = GameData.LoadConfig <TextAsset>("SkillResultTable"); SkillResultTableAsset = new SkillResultTable(); SkillResultTableAsset.Load(asset.bytes); } if (null == AnimationTownAsset) { TextAsset asset = GameData.LoadConfig <TextAsset>("AnimationTown"); AnimationTownAsset = new AnimationTable(); AnimationTownAsset.Load(asset.bytes); } if (null == AnimationFightAsset) { TextAsset asset = GameData.LoadConfig <TextAsset>("AnimationFight"); AnimationFightAsset = new AnimationTable(); AnimationFightAsset.Load(asset.bytes); } AnimationTableAsset = AnimationFightAsset; if (null == ActionRelationTableAsset) { TextAsset asset = GameData.LoadConfig <TextAsset>("ActionRelation"); ActionRelationTableAsset = new ActionRelationTable(); ActionRelationTableAsset.Load(asset.bytes); } if (null == EquipTableAsset) { TextAsset obj = GameData.LoadConfig <TextAsset>("EquipBaseData"); EquipTableAsset = new EquipTable(); EquipTableAsset.Load(obj.bytes); } if (null == ModelInfoTableAsset) { TextAsset obj = GameData.LoadConfig <TextAsset>("ModelInfoTable"); ModelInfoTableAsset = new ModelInfoTable(); ModelInfoTableAsset.Load(obj.bytes); } if (null == WeaponInfoTableAsset) { TextAsset obj = GameData.LoadConfig <TextAsset>("WeaponInfoTable"); WeaponInfoTableAsset = new WeaponInfoTable(); WeaponInfoTableAsset.Load(obj.bytes); } if (null == UILoadInfoTableAsset) { TextAsset obj = GameData.LoadConfig <TextAsset>("UILoadInfoTable"); UILoadInfoTableAsset = new UILoadInfoTable(); UILoadInfoTableAsset.Load(obj.bytes); } if (null == IconTableAsset) { TextAsset obj = GameData.LoadConfig <TextAsset>("IconTable"); IconTableAsset = new IconTable(); IconTableAsset.Load(obj.bytes); } if (null == BuffTableAsset) { TextAsset obj = GameData.LoadConfig <TextAsset>("Buff"); BuffTableAsset = new BuffTable(); BuffTableAsset.Load(obj.bytes); } if (null == BuffRelationTableAsset) { TextAsset obj = GameData.LoadConfig <TextAsset>("BuffReplaceRelation"); BuffRelationTableAsset = new BuffRelationTable(); BuffRelationTableAsset.Load(obj.bytes); } if (null == BuffEffectTableAsset) { TextAsset obj = GameData.LoadConfig <TextAsset>("BuffEffect"); BuffEffectTableAsset = new BuffEffectTable(); BuffEffectTableAsset.Load(obj.bytes); } //if (null == CheckInfoTableAsset) //{ // TextAsset obj = GameData.LoadConfig<TextAsset>("Checkinfo"); // CheckInfoTableAsset = new CheckInfoTable(); // CheckInfoTableAsset.Load(obj.bytes); //} //if (null == NpcSayTableAsset) //{ // TextAsset obj = GameData.LoadConfig<TextAsset>("NpcSay"); // NpcSayTableAsset = new NpcSayTable(); // NpcSayTableAsset.Load(obj.bytes); //} //if (null == ShopTableAsset) //{ // TextAsset obj = GameData.LoadConfig<TextAsset>("NpcShop"); // ShopTableAsset = new ShopTable(); // ShopTableAsset.Load(obj.bytes); //} if (null == MissionTableAsset) { TextAsset obj = GameData.LoadConfig <TextAsset>("Task"); MissionTableAsset = new MissionTable(); MissionTableAsset.Load(obj.bytes); } if (null == AptitudeTableAsset) { TextAsset obj = GameData.LoadConfig <TextAsset>("Aptitude"); AptitudeTableAsset = new AptitudeTable(); AptitudeTableAsset.Load(obj.bytes); } if (null == StringTableAsset) { TextAsset obj = GameData.LoadConfig <TextAsset>("StringTable"); StringTableAsset = new StringTable(); StringTableAsset.Load(obj.bytes); } if (null == WorldParamTableAsset) { TextAsset obj = GameData.LoadConfig <TextAsset>("WorldParamTable"); WorldParamTableAsset = new WorldParamTable(); WorldParamTableAsset.Load(obj.bytes); } if (null == CDTableAsset) { TextAsset obj = GameData.LoadConfig <TextAsset>("CDTable"); CDTableAsset = new CDTable(); CDTableAsset.Load(obj.bytes); } //if (null == ServerTableAsset) //{ // TextAsset obj = GameData.LoadConfig<TextAsset>("Servers"); // ServerTableAsset = new ServerTable(); // ServerTableAsset.Load(obj.bytes); //} //if (null == SceneMapNumericTableAsset) //{ // TextAsset obj = GameData.LoadConfig<TextAsset>("Coordinate"); // SceneMapNumericTableAsset = new SceneMapNumericTable(); // SceneMapNumericTableAsset.Load(obj.bytes); //} //if (null == EquipExpMoneyTableAsset) //{ // TextAsset obj = GameData.LoadConfig<TextAsset>("EquipExpMoney"); // EquipExpMoneyTableAsset = new EquipExpMoneyTable(); // EquipExpMoneyTableAsset.Load(obj.bytes); //} //if (null == ShakeTableAsset) //{ // TextAsset obj = GameData.LoadConfig<TextAsset>("Shake"); // ShakeTableAsset = new ShakeTable(); // ShakeTableAsset.Load(obj.bytes); //} //if (null == PlayerGuideTableAsset) //{ // TextAsset obj = GameData.LoadConfig<TextAsset>("PlayerGuide"); // PlayerGuideTableAsset = new PlayerGuideTable(); // PlayerGuideTableAsset.Load(obj.bytes); //} //if (null == IllumeTableAsset) //{ // TextAsset obj = GameData.LoadConfig<TextAsset>("Illume"); // IllumeTableAsset = new IllumeTable(); // IllumeTableAsset.Load(obj.bytes); //} //if (null == BossTableAsset) //{ // TextAsset obj = GameData.LoadConfig<TextAsset>("BOSS"); // BossTableAsset = new BossTable(); // BossTableAsset.Load(obj.bytes); //} //if (null == SandTableInfoTableAsset) //{ // TextAsset obj = GameData.LoadConfig<TextAsset>("SandTableInfoTable"); // SandTableInfoTableAsset = new SandTableInfoTable(); // SandTableInfoTableAsset.Load(obj.bytes); //} if (null == LevelUpTableAsset) { TextAsset obj = GameData.LoadConfig <TextAsset>("LvUpExp"); LevelUpTableAsset = new LevelUpTable(); LevelUpTableAsset.Load(obj.bytes); } //if (null == DungeonEventTableAsset) //{ // TextAsset obj = GameData.LoadConfig<TextAsset>("DungeonEvent"); // DungeonEventTableAsset = new DungeonEventTable(); // DungeonEventTableAsset.Load(obj.bytes); //} //if (null == DungeonEventResultTableAsset) //{ // TextAsset obj = GameData.LoadConfig<TextAsset>("DungeonEventResult"); // DungeonEventResultTableAsset = new DungeonEventResultTable(); // DungeonEventResultTableAsset.Load(obj.bytes); //} //if (null == DungeonFilesAsset) //{ // TextAsset obj = GameData.LoadConfig<TextAsset>("DungeonFiles"); // DungeonFilesAsset = new DungeonFiles(); // DungeonFilesAsset.Load(obj.bytes); //} if (null == RarityRelativeAsset) { TextAsset obj = GameData.LoadConfig <TextAsset>("RarityRelative"); RarityRelativeAsset = new RarityRelativeTable(); RarityRelativeAsset.Load(obj.bytes); } if (null == OccupationInfoAsset) { TextAsset obj = GameData.LoadConfig <TextAsset>("OccupationInfoTable"); OccupationInfoAsset = new OccupationInfoTable(); OccupationInfoAsset.Load(obj.bytes); } if (null == PlayerRandomNameAsset) { TextAsset obj = GameData.LoadConfig <TextAsset>("PlayerRandomName"); PlayerRandomNameAsset = new PlayerRandomNameTable(); PlayerRandomNameAsset.Load(obj.bytes); } if (null == ZoneInfoTableAsset) { TextAsset obj = GameData.LoadConfig <TextAsset>("ZoneInfo"); ZoneInfoTableAsset = new ZoneInfoTable(); ZoneInfoTableAsset.Load(obj.bytes); } if (null == StageInfoTableAsset) { TextAsset obj = GameData.LoadConfig <TextAsset>("StageInfo"); StageInfoTableAsset = new StageInfoTable(); StageInfoTableAsset.Load(obj.bytes); } if (null == FloorInfoTableAsset) { TextAsset obj = GameData.LoadConfig <TextAsset>("FloorInfo"); FloorInfoTableAsset = new FloorInfoTable(); FloorInfoTableAsset.Load(obj.bytes); } if (null == ItemTableAsset) { TextAsset obj = GameData.LoadConfig <TextAsset>("Item"); ItemTableAsset = new ItemTable(); ItemTableAsset.Load(obj.bytes); } if (null == floorRankTableAsset) { TextAsset obj = GameData.LoadConfig <TextAsset>("FloorRankTable"); floorRankTableAsset = new FloorRankTable(); floorRankTableAsset.Load(obj.bytes); } if (null == ScoreParamTableAsset) { TextAsset obj = GameData.LoadConfig <TextAsset>("ScoreParamTable"); ScoreParamTableAsset = new ScoreParamTable(); ScoreParamTableAsset.Load(obj.bytes); } if (null == BagTableAsset) { TextAsset obj = GameData.LoadConfig <TextAsset>("BagTable"); BagTableAsset = new BagTable(); BagTableAsset.Load(obj.bytes); } if (null == RaceInfoTableAsset) { TextAsset obj = GameData.LoadConfig <TextAsset>("RaceInfoTable"); RaceInfoTableAsset = new RaceInfoTable(); RaceInfoTableAsset.Load(obj.bytes); } if (null == EquipmentTableAsset) { TextAsset obj = GameData.LoadConfig <TextAsset>("Equipment"); EquipmentTableAsset = new EquipmentTable(); EquipmentTableAsset.Load(obj.bytes); } if (null == playerAttrTableAsset) { TextAsset obj = GameData.LoadConfig <TextAsset>("PlayerAttrTable"); playerAttrTableAsset = new PlayerAttrTable(); playerAttrTableAsset.Load(obj.bytes); } if (null == loadingTipsAsset) { TextAsset obj = GameData.LoadConfig <TextAsset>("LoadingTips"); loadingTipsAsset = new LoadingTipsTable(); loadingTipsAsset.Load(obj.bytes); } if (null == MagicStoneTableAsset) { TextAsset obj = GameData.LoadConfig <TextAsset>("MagicStonePrice"); MagicStoneTableAsset = new MagicStoneTable(); MagicStoneTableAsset.Load(obj.bytes); } if (null == RingExchangeTableAsset) { TextAsset obj = GameData.LoadConfig <TextAsset>("RingExchangeTable"); RingExchangeTableAsset = new RingExchangeTable(); RingExchangeTableAsset.Load(obj.bytes); } // if (null == SceneRoomTableAsset) // { // TextAsset obj = GameData.LoadConfig<TextAsset>("SceneRoomTable"); // SceneRoomTableAsset = new SceneRoomTable(); // SceneRoomTableAsset.Load(obj.bytes); // } // if (null == SceneBridgeTableAsset) // { // TextAsset obj = GameData.LoadConfig<TextAsset>("SceneBridgeTable"); // SceneBridgeTableAsset = new SceneBridgeTable(); // SceneBridgeTableAsset.Load(obj.bytes); // } // if (null == SceneGateTableAsset) // { // TextAsset obj = GameData.LoadConfig<TextAsset>("SceneGateTable"); // SceneGateTableAsset = new SceneGateTable(); // SceneGateTableAsset.Load(obj.bytes); // } // if (null == SceneTeleportTableAsset) // { // TextAsset obj = GameData.LoadConfig<TextAsset>("SceneTeleportTable"); // SceneTeleportTableAsset = new SceneTeleportTable(); // SceneTeleportTableAsset.Load(obj.bytes); // } if (null == MessageRespondTableAsset) { TextAsset obj = GameData.LoadConfig <TextAsset>("MessageRespondTable"); MessageRespondTableAsset = new MessageRespondTable(); MessageRespondTableAsset.Load(obj.bytes); } if (null == IconInfoTableAsset) { TextAsset obj = GameData.LoadConfig <TextAsset>("Icon"); IconInfoTableAsset = new IconInfoTable(); IconInfoTableAsset.Load(obj.bytes); } if (null == attrRatioTableAsset) { TextAsset obj = GameData.LoadConfig <TextAsset>("AttrRatioTable"); attrRatioTableAsset = new AttrRatioTable(); attrRatioTableAsset.Load(obj.bytes); } if (null == ComboSwordSoulAsset) { TextAsset obj = GameData.LoadConfig <TextAsset>("ComboSwordSoulTable"); ComboSwordSoulAsset = new ComboSwordSoulTable(); ComboSwordSoulAsset.Load(obj.bytes); } if (null == eventItemAsset) { TextAsset obj = GameData.LoadConfig <TextAsset>("EventItem"); eventItemAsset = new EventItemTable(); eventItemAsset.Load(obj.bytes); } if (null == gradeUpRequireAsset) { TextAsset obj = GameData.LoadConfig <TextAsset>("GradeUpRequireTable"); gradeUpRequireAsset = new GradeUpRequireTable(); gradeUpRequireAsset.Load(obj.bytes); } if (null == qualityRelativeAsset) { TextAsset obj = GameData.LoadConfig <TextAsset>("QualityRelativeTable"); qualityRelativeAsset = new QualityRelativeTable(); qualityRelativeAsset.Load(obj.bytes); } if (null == cardTypeVariationAsset) { TextAsset obj = GameData.LoadConfig <TextAsset>("CardTypeVariationTable"); cardTypeVariationAsset = new CardTypeVariationTable(); cardTypeVariationAsset.Load(obj.bytes); } if (null == cardLevelVariationAsset) { TextAsset obj = GameData.LoadConfig <TextAsset>("CardLevelupVariationTable"); cardLevelVariationAsset = new CardLevelVariationTable(); cardLevelVariationAsset.Load(obj.bytes); } if (null == yellowPointParamAsset) { TextAsset obj = GameData.LoadConfig <TextAsset>("YellowPointParam"); yellowPointParamAsset = new YellowPointParamTable(); yellowPointParamAsset.Load(obj.bytes); } //加载随机地图相关表数据 LoadRandMapTableData(); int id = 70; int level = 12; int yellow = 3; int hp = BattleFormula.GetHp(id, level, yellow); int phyAttack = BattleFormula.GetPhyAttack(id, level, yellow); int magAttack = BattleFormula.GetMagAttack(id, level, yellow); int magDefend = BattleFormula.GetMagDefend(id, level, yellow); int phyDEFEND = BattleFormula.GetPhyDefend(id, level, yellow); Debug.Log("magDefend:" + magDefend); Debug.Log("magAttack:" + magAttack); Debug.Log("phyDEFEND:" + phyDEFEND); Debug.Log("phyAttack:" + phyAttack); Debug.Log("hp:" + hp); }
public bool GetEquipmentTable(int id, out EquipmentTable table) { return(_mapEquipmentTable.TryGetValue(id, out table)); }