//JAVA TO C# CONVERTER WARNING: Method 'throws' clauses are not available in C#: //ORIGINAL LINE: private void processSponCostItem(Desktop.common.nomitech.common.migration.spon.SponLineItem paramSponLineItem, org.hibernate.Session paramSession) throws Exception private void processSponCostItem(SponLineItem paramSponLineItem, Session paramSession) { MaterialTable materialTable = null; SubcontractorTable subcontractorTable = null; EquipmentTable equipmentTable = null; if (paramSponLineItem.Material != null && paramSponLineItem.Material.Value != 0.0D) { materialTable = saveOrUpdateMaterialTable(paramSession, paramSponLineItem); } if (paramSponLineItem.Labor != null && paramSponLineItem.Labor.Value != 0.0D) { subcontractorTable = saveOrSubcontractorTable(paramSession, paramSponLineItem, paramSponLineItem.Labor); } if (paramSponLineItem.Plant != null && paramSponLineItem.Plant.Value != 0.0D) { equipmentTable = saveOrUpdateEquipmentTable(paramSession, paramSponLineItem); } if ((materialTable != null && subcontractorTable != null) || (materialTable != null && equipmentTable != null) || (equipmentTable != null && subcontractorTable != null)) { saveOrUpdateAssemblyTable(paramSession, paramSponLineItem, materialTable, subcontractorTable, equipmentTable); } else if (paramSponLineItem.Total != null && paramSponLineItem.Total.Value != 0.0D && materialTable == null && subcontractorTable == null && equipmentTable == null) { saveOrSubcontractorTable(paramSession, paramSponLineItem, paramSponLineItem.Total); } }
public DBHelper(string connectionString, LogFunc log = null) : base(connectionString, log) { _AppLogTable = new AppLogTable(connectionString, log); _CompanyTable = new CompanyTable(connectionString, log); _MaterialTable = new MaterialTable(connectionString, log); _ReceiptTable = new ReceiptTable(connectionString, log); _RecordTable = new RecordTable(connectionString, log); }
private static void MutateValue_Gem(WorldObject wo) { var materialMod = MaterialTable.GetValueMod(wo.MaterialType); var workmanshipMod = WorkmanshipChance.GetModifier(wo.ItemWorkmanship); wo.Value = (int)(wo.Value * materialMod * workmanshipMod); }
public virtual object clone(bool relations) { BoqItemMaterialTable obj = new BoqItemMaterialTable(); obj.ParamItemId = ParamItemId; obj.BoqItemMaterialId = BoqItemMaterialId; obj.FinalRate = FinalRate; obj.FinalMaterialRate = FinalMaterialRate; obj.FinalFabricationRate = FinalFabricationRate; obj.FinalShipmentRate = FinalShipmentRate; obj.FinalEscalationRate = FinalEscalationRate; obj.Escalation = Escalation; obj.TotalMaterialCost = TotalMaterialCost; obj.TotalFabricationCost = TotalFabricationCost; obj.TotalShipmentCost = TotalShipmentCost; obj.TotalEscalationCost = TotalEscalationCost; obj.TotalCost = TotalCost; obj.Factor1 = Factor1; obj.Factor2 = Factor2; obj.Factor3 = Factor3; obj.QuantityPerUnit = QuantityPerUnit; obj.QuantityPerUnitFormula = QuantityPerUnitFormula; obj.QuantityPerUnitFormulaState = QuantityPerUnitFormulaState; obj.TotalUnits = TotalUnits; obj.HasUserTotalUnits = HasUserTotalUnits; obj.ExchangeRate = ExchangeRate; obj.LocalFactor = LocalFactor; obj.LocalCountry = LocalCountry; obj.LocalStateProvince = LocalStateProvince; obj.LastUpdate = LastUpdate; obj.FixedCost = FixedCost; obj.FinalFixedCost = FinalFixedCost; obj.VariableCost = VariableCost; obj.Comment = Comment; obj.PvVars = PvVars; obj.ProjectId = ProjectId; if (relations) { if (BoqItemTable != null) { obj.BoqItemTable = (BoqItemTable)BoqItemTable.clone(); } if (MaterialTable != null) { obj.MaterialTable = (MaterialTable)MaterialTable.clone(); } } return(obj); }
public T Select <T>(T type, int primaryKey) where T : new() { Type entType = type.GetType(); if (entType == typeof(City)) { return((T)Convert.ChangeType(CityTable.Select(primaryKey), typeof(T))); } if (entType == typeof(Customer)) { return((T)Convert.ChangeType(CustomerTable.Select(primaryKey), typeof(T))); } if (entType == typeof(Distillation)) { return((T)Convert.ChangeType(DistillationTable.Select(primaryKey), typeof(T))); } if (entType == typeof(District)) { return((T)Convert.ChangeType(DistrictTable.Select(primaryKey), typeof(T))); } if (entType == typeof(Material)) { return((T)Convert.ChangeType(MaterialTable.Select(primaryKey), typeof(T))); } if (entType == typeof(Period)) { return((T)Convert.ChangeType(PeriodTable.Select(primaryKey), typeof(T))); } if (entType == typeof(Region)) { return((T)Convert.ChangeType(RegionTable.Select(primaryKey), typeof(T))); } if (entType == typeof(Reservation)) { return((T)Convert.ChangeType(ReservationTable.Select(primaryKey), typeof(T))); } if (entType == typeof(Season)) { return((T)Convert.ChangeType(SeasonTable.Select(primaryKey), typeof(T))); } if (entType == typeof(UserInfo)) { return((T)Convert.ChangeType(UserInfoTable.Select(primaryKey), typeof(T))); } return(default(T)); }
public ICollection <T> SelectAll <T>(T type) where T : new() { Type entType = type.GetType(); if (entType == typeof(City)) { return((ICollection <T>)CityTable.Select()); } if (entType == typeof(Customer)) { return((ICollection <T>)CustomerTable.Select()); } if (entType == typeof(Distillation)) { return((ICollection <T>)DistillationTable.Select()); } if (entType == typeof(District)) { return((ICollection <T>)DistrictTable.Select()); } if (entType == typeof(Material)) { return((ICollection <T>)MaterialTable.Select()); } if (entType == typeof(Period)) { return((ICollection <T>)PeriodTable.Select()); } if (entType == typeof(Region)) { return((ICollection <T>)RegionTable.Select()); } if (entType == typeof(Reservation)) { return((ICollection <T>)ReservationTable.Select()); } if (entType == typeof(Season)) { return((ICollection <T>)SeasonTable.Select()); } if (entType == typeof(UserInfo)) { return((ICollection <T>)UserInfoTable.Select()); } return(null); }
public int Insert <T>(T entity) { Type type = entity.GetType(); if (type == typeof(City)) { return(CityTable.Insert(entity as City)); } if (type == typeof(Customer)) { return(CustomerTable.Insert(entity as Customer)); } if (type == typeof(Distillation)) { return(DistillationTable.Insert(entity as Distillation)); } if (type == typeof(District)) { return(DistrictTable.Insert(entity as District)); } if (type == typeof(Material)) { return(MaterialTable.Insert(entity as Material)); } if (type == typeof(Period)) { return(PeriodTable.Insert(entity as Period)); } if (type == typeof(Region)) { return(RegionTable.Insert(entity as Region)); } if (type == typeof(Reservation)) { return(ReservationTable.Insert(entity as Reservation)); } if (type == typeof(Season)) { return(SeasonTable.Insert(entity as Season)); } if (type == typeof(UserInfo)) { return(UserInfoTable.Insert(entity as UserInfo)); } return(0); }
protected override Result RunCommand(RhinoDoc doc, RunMode mode) { RhinoApp.WriteLine("The {0} command will run now", EnglishName); MaterialTable materialTable = doc.Materials; List <double> totalAreas = new List <double>(); double cumulativeArea = 0; foreach (Material m in materialTable) { doc.Objects.UnselectAll(); string command = string.Format("_-SelMaterialName {0}", m.Name); RhinoApp.RunScript(command, true); IEnumerable <RhinoObject> selectedObjects = doc.Objects.GetSelectedObjects(false, false); double totalArea = 0; foreach (RhinoObject obj in selectedObjects) { if (obj.ObjectType == ObjectType.Brep) { Brep brepGeom = (Brep)obj.Geometry; double area = AreaMassProperties.Compute(brepGeom).Area; totalArea += area; } } cumulativeArea += totalArea; totalAreas.Add(totalArea); } List <double> areaPercent = new List <double>(); totalAreas.ForEach(area => areaPercent.Add(area / cumulativeArea)); string path = Path.Combine(Environment.GetFolderPath(Environment.SpecialFolder.Desktop), "materialAreas.txt"); using (StreamWriter sw = File.CreateText(path)) { for (int i = 0; i < areaPercent.Count; i++) { string line = string.Format("Material: {0}, Area: {1}", materialTable[i], areaPercent[i]); } } doc.Views.Redraw(); RhinoApp.WriteLine("The curves were rebuilt"); return(Result.Success); }
public MaterialForm(int idMaterial) { InitializeComponent(); MaterialTable = new MaterialTable(); if (idMaterial != -1) { Material = MaterialTable.SelectByIdMaterial(idMaterial); BindData(); predmetComboBox.Hide(); uzivatelComboBox.Hide(); } else { smazat.Hide(); PredmetBox.Hide(); UzivatelBox.Hide(); FillComboBox(); Material = new Material { MId = -1, Predmet = null, Uzivatel = null }; } }
//JAVA TO C# CONVERTER WARNING: Method 'throws' clauses are not available in C#: //ORIGINAL LINE: private void loadResources(org.hibernate.Session paramSession, String paramString) throws Exception private void loadResources(Session paramSession, string paramString) { Console.WriteLine("\n\n\n\nLoading RESOURSES"); 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); int i = getRealNumberOfRows(hSSFSheet); for (int j = 1; j < i; j++) { if (j % this.rowsToCommit == 0) { paramSession.Transaction.commit(); paramSession.Transaction.begin(); Console.WriteLine("Processing next " + this.rowsToCommit + "..."); } HSSFRow hSSFRow = hSSFSheet.getRow(j); string str1 = notNull(hSSFRow.getCell(0)); string str2 = notNull(hSSFRow.getCell(1)); string str3 = notNull(hSSFRow.getCell(2)); string str4 = toCostOSUoM(notNull(hSSFRow.getCell(3))); decimal bigDecimal1 = notNullBigDecimal(hSSFRow.getCell(4), 0.0D); string str5 = notNull(hSSFRow.getCell(7)); decimal bigDecimal2 = notNullBigDecimal(hSSFRow.getCell(17), 0.0D); string str6 = notNull(hSSFRow.getCell(14)); string str7 = ""; if (str6.Length >= 2 && !StringUtils.isBlank(str6)) { str7 = "0" + str6.Substring(0, 2) + "00"; } if (acceptProject(str1) && !str4.Equals("")) { SubcontractorTable subcontractorTable = null; if (str5.Equals("F&O")) { subcontractorTable = BlankResourceInitializer.createBlankEquipment(null); ((EquipmentTable)subcontractorTable).Currency = "USD"; ((EquipmentTable)subcontractorTable).FuelRate = bigDecimal1; } else if (str5.Equals("LAB") && str4.Equals("HOUR")) { LaborTable laborTable = BlankResourceInitializer.createBlankLabor(null); ((LaborTable)laborTable).Currency = "USD"; ((LaborTable)laborTable).Rate = bigDecimal1; } else if (str5.Equals("STF") && str4.Equals("DAY")) { LaborTable laborTable = BlankResourceInitializer.createBlankLabor(null); ((LaborTable)laborTable).Currency = "USD"; ((LaborTable)laborTable).Rate = bigDecimal1; } else if (str5.Equals("STF") && str4.Equals("MONTH")) { LaborTable laborTable = BlankResourceInitializer.createBlankLabor(null); ((LaborTable)laborTable).Currency = "USD"; ((LaborTable)laborTable).Rate = bigDecimal1; } else if (str5.Equals("GEN") || str5.Equals("REC")) { ConsumableTable consumableTable = BlankResourceInitializer.createBlankConsumable(null); ((ConsumableTable)consumableTable).Currency = "USD"; ((ConsumableTable)consumableTable).Rate = bigDecimal1; } else if (str5.Equals("LOC") || str5.Equals("IMP")) { MaterialTable materialTable = BlankResourceInitializer.createBlankMaterial(null); ((MaterialTable)materialTable).Currency = "USD"; ((MaterialTable)materialTable).Rate = bigDecimal1; } else if (str5.Equals("S/C")) { SubcontractorTable subcontractorTable1 = BlankResourceInitializer.createBlankSubcontractor(null); ((SubcontractorTable)subcontractorTable1).Currency = "USD"; ((SubcontractorTable)subcontractorTable1).Rate = bigDecimal1; } else if (str5.Equals("PLA")) { subcontractorTable = BlankResourceInitializer.createBlankEquipment(null); ((EquipmentTable)subcontractorTable).Currency = "USD"; ((EquipmentTable)subcontractorTable).ReservationRate = bigDecimal1; } else { subcontractorTable = BlankResourceInitializer.createBlankSubcontractor(null); ((SubcontractorTable)subcontractorTable).Currency = "USD"; ((SubcontractorTable)subcontractorTable).Rate = bigDecimal1; } subcontractorTable.ItemCode = str2; subcontractorTable.Title = str3; subcontractorTable.Project = str1; subcontractorTable.Quantity = bigDecimal2; subcontractorTable.Unit = str4; subcontractorTable.GekCode = str5 + " - " + str5; if (this.csi95Map.ContainsKey(str7)) { subcontractorTable.GroupCode = (string)this.csi95Map[str7]; } else if (!StringUtils.isBlank(str7)) { Console.WriteLine("CSI Not Found: " + str7); } subcontractorTable.LastUpdate = this.lastUpdate; subcontractorTable.CreateDate = this.lastUpdate; subcontractorTable.EditorId = "ccc"; subcontractorTable.CreateUserId = "ccc"; long?long = (long?)paramSession.save(subcontractorTable); ResourceTable resourceTable = (ResourceTable)paramSession.load(subcontractorTable.GetType(), long); this.resourcesMap[str1 + str2] = resourceTable; } } }
public virtual MaterialTable convertToMaterialTable(ProjectDBProperties prop) { MaterialTable obj = BlankResourceInitializer.createBlankMaterial(null); BoqItemTable boqItemTable = BoqItemTable; QuotationTable quotationTable = QuotationTable; double[] projectGeoPosition = StringUtils.extractDoubles(prop.getProperty("project.geolocation")); double[] supplierGeoPosition = StringUtils.extractDoubles(quotationTable.GeoLocation); double distanceKm = HaversineDistanceUtil.distance(HaversineDistanceUtil.KM_DISTANCE, projectGeoPosition, supplierGeoPosition); if (Title.IndexOf(boqItemTable.Title, StringComparison.Ordinal) != -1 && Title.IndexOf(boqItemTable.Description, StringComparison.Ordinal) != -1) { obj.Title = StringUtils.makeShortTitle(boqItemTable.Title); } else { obj.Title = StringUtils.makeShortTitle(Title); } obj.DatabaseId = DatabaseId; if (DatabaseCreationDate == null) { obj.DatabaseCreationDate = 100L; //ResourceUtil.MISSING_DB_CREATE_DATE); } else { obj.DatabaseCreationDate = DatabaseCreationDate; } obj.Weight = BigDecimalMath.ZERO; obj.WeightUnit = "KG"; obj.GroupCode = boqItemTable.GroupCode; obj.GekCode = boqItemTable.GekCode; obj.Project = prop.getProperty("project.code") + " - " + prop.getProperty("project.name"); obj.Description = boqItemTable.Description; obj.Notes = boqItemTable.Notes; obj.EditorId = DatabaseDBUtil.Properties.UserId; obj.Country = quotationTable.Country; obj.StateProvince = quotationTable.StateProvince; obj.Rate = Rate; obj.DistanceToSite = new BigDecimalFixed("" + distanceKm); obj.DistanceUnit = "KM"; obj.RawMaterial = MaterialTable.UNSPECIFIED_RAWMAT; obj.RawMaterialReliance = BigDecimalMath.ZERO; obj.CreateUserId = quotationTable.EditorId; if (quotationTable.ReceivedDate != null) { obj.LastUpdate = quotationTable.ReceivedDate; obj.CreateDate = quotationTable.ReceivedDate; } else { obj.LastUpdate = DateTime.Now; obj.CreateDate = obj.LastUpdate; } if (quotationTable.OnSiteDelivery.Value) { if (ShipmentCost != null) { decimal indirectRate = BigDecimalMath.ZERO; if (IndirectCost != null) { decimal qty = Quantity; if (BigDecimalMath.cmpCheckNulls(qty, BigDecimalMath.ZERO) == 0) { qty = BigDecimalMath.ONE; } obj.ShipmentRate = BigDecimalMath.div(shipmentCost, qty); } // double qty = getQuantity().doubleValue(); // if ( qty == 0 ) // qty = 1; // double srate = shipmentCost.doubleValue()/getQuantity().doubleValue(); // obj.setShipmentRate(new BigDecimalFixed(""+srate)); } else { obj.ShipmentRate = BigDecimalMath.ZERO; } obj.Inclusion = MaterialTable.SHIPMENT_INCLUSION; } else { obj.Inclusion = MaterialTable.NONE_INCLUSION; obj.ShipmentRate = BigDecimalMath.ZERO; } obj.FabricationRate = BigDecimalMath.ZERO; obj.TotalRate = obj.Rate + obj.ShipmentRate; obj.Quantity = Quantity; obj.Unit = Unit; obj.Currency = quotationTable.Currency; obj.Accuracy = MaterialTable.QUOTED_ACCURACY; obj.ExtraCode1 = boqItemTable.ExtraCode1; obj.ExtraCode2 = boqItemTable.ExtraCode2; obj.ExtraCode3 = boqItemTable.ExtraCode3; obj.ExtraCode4 = boqItemTable.ExtraCode4; obj.ExtraCode5 = boqItemTable.ExtraCode5; obj.ExtraCode6 = boqItemTable.ExtraCode6; obj.ExtraCode7 = boqItemTable.ExtraCode7; obj.ExtraCode8 = boqItemTable.ExtraCode8; obj.ExtraCode9 = boqItemTable.ExtraCode9; obj.ExtraCode10 = boqItemTable.ExtraCode10; boqItemTable.loadBimMaterialsAndTypes(); obj.BimMaterial = boqItemTable.BimMaterial; obj.BimType = boqItemTable.BimType; obj.recalculate(); return(obj); }
//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(); } }
public double Density() //根據 Material Type 計算 density { return(MaterialTable.Density(_materialType)); }
private static void MutateValue_Gem(WorldObject wo) { wo.Value = (int)(wo.Value * MaterialTable.GetValueMod(wo.MaterialType) * wo.ItemWorkmanship); }
//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 void MaterialFunc(object sender, MaterialEventArgs e) { _mType = e.MaterialType; txtMaterial.Text = e.MaterialName; txtDensity.Text = MaterialTable.Density(e.MaterialType).ToString(); }
private void setMaterialProperties(object sender, SetMaterialEventArgs e) { _mType = e.MType; txtMaterial.Text = MaterialTable.Name(e.MType); txtDensity.Text = MaterialTable.Density(e.MType).ToString(); }
public MaterialyGridForm() { InitializeComponent(); MaterialTable = new MaterialTable(); }