public string EvaluateFormula_Base(string formula, BaseClasses.Data.BaseRecord dataSourceForEvaluate, string format, System.Collections.Generic.IDictionary<string, object> variables, bool includeDS) { FormulaEvaluator e = new FormulaEvaluator(); // add variables for formula evaluation if (variables != null) { System.Collections.Generic.IEnumerator<System.Collections.Generic.KeyValuePair<string, object>> enumerator = variables.GetEnumerator(); while (enumerator.MoveNext()) { e.Variables.Add(enumerator.Current.Key, enumerator.Current.Value); } } if (includeDS) { } e.CallingControl = this; // All variables referred to in the formula are expected to be // properties of the DataSource. For example, referring to // UnitPrice as a variable will refer to DataSource.UnitPrice e.DataSource = dataSourceForEvaluate; // Define the calling control. e.CallingControl = this; object resultObj = e.Evaluate(formula); if (resultObj == null) return ""; if ( !string.IsNullOrEmpty(format) && (string.IsNullOrEmpty(formula) || formula.IndexOf("Format(") < 0) ) { return FormulaUtils.Format(resultObj, format); } else { return resultObj.ToString(); } }
/** * * Returns the Formatted value of a cell as a <tt>String</tt> regardless * of the cell type. If the Excel FormatBase pattern cannot be Parsed then the * cell value will be Formatted using a default FormatBase. * * When passed a null or blank cell, this method will return an empty * String (""). Formula cells will be evaluated using the given * {@link HSSFFormulaEvaluator} if the evaluator is non-null. If the * evaluator is null, then the formula String will be returned. The caller * is responsible for setting the currentRow on the evaluator * * * @param cell The cell (can be null) * @param evaluator The HSSFFormulaEvaluator (can be null) * @return a string value of the cell */ public String FormatCellValue(Cell cell, FormulaEvaluator evaluator) { if (cell == null) { return ""; } CellType cellType = cell.CellType; if (evaluator != null && cellType == CellType.FORMULA) { try { cellType = evaluator.EvaluateFormulaCell(cell); } catch (Exception e) { throw new Exception("Did you forGet to set the current" + " row on the HSSFFormulaEvaluator?", e); } } switch (cellType) { case CellType.FORMULA: // should only occur if evaluator is null return cell.CellFormula; case CellType.NUMERIC: if (DateUtil.IsCellDateFormatted(cell)) { return GetFormattedDateString(cell); } return GetFormattedNumberString(cell); case CellType.STRING: return cell.RichStringCellValue.String; case CellType.BOOLEAN: return cell.BooleanCellValue.ToString().ToUpper(); case CellType.BLANK: return ""; } throw new Exception("Unexpected celltype (" + cellType + ")"); }
public virtual string EvaluateFormula(string formula, BaseClasses.Data.BaseRecord dataSourceForEvaluate, System.Collections.Generic.IDictionary <string, object> variables, FormulaEvaluator e) { return(this.EvaluateFormula(formula, dataSourceForEvaluate, null, variables, true, e)); }
public virtual string EvaluateFormula(string formula, BaseClasses.Data.BaseRecord dataSourceForEvaluate, string format, System.Collections.Generic.IDictionary <string, object> variables, bool includeDS, FormulaEvaluator e) { if (e == null) { e = new FormulaEvaluator(); } e.Variables.Clear(); // add variables for formula evaluation if (variables != null) { System.Collections.Generic.IEnumerator <System.Collections.Generic.KeyValuePair <string, object> > enumerator = variables.GetEnumerator(); while (enumerator.MoveNext()) { e.Variables.Add(enumerator.Current.Key, enumerator.Current.Value); } } if (includeDS) { } // All variables referred to in the formula are expected to be // properties of the DataSource. For example, referring to // UnitPrice as a variable will refer to DataSource.UnitPrice if (dataSourceForEvaluate == null) { e.DataSource = this.DataSource; } else { e.DataSource = dataSourceForEvaluate; } // Define the calling control. This is used to add other // related table and record controls as variables. e.CallingControl = this; object resultObj = e.Evaluate(formula); if (resultObj == null) { return(""); } if (!string.IsNullOrEmpty(format) && (string.IsNullOrEmpty(formula) || formula.IndexOf("Format(") < 0)) { return(FormulaUtils.Format(resultObj, format)); } else { return(resultObj.ToString()); } }
public virtual void SetFieldTripId() { string selectedValue = null; // figure out the selectedValue // Set the FieldTripId QuickSelector on the webpage with value from the // DatabaseOLR_db%dbo.FieldTripOptions database record. // this.DataSource is the DatabaseOLR_db%dbo.FieldTripOptions record retrieved from the database. // this.FieldTripId is the ASP:QuickSelector on the webpage. // You can modify this method directly, or replace it with a call to // base.SetFieldTripId(); // and add your own custom code before or after the call to the base function. // Default Value could also be NULL. if (this.DataSource != null && this.DataSource.IsCreated) { selectedValue = this.DataSource.FieldTripId.ToString(); } else { selectedValue = EvaluateFormula("URL(\"FieldTripId\")"); } // Add the Please Select item. if (selectedValue == null || selectedValue == "") { MiscUtils.ResetSelectedItem(this.FieldTripId, new ListItem(this.Page.GetResourceValue("Txt:PleaseSelect", "OLR"), "--PLEASE_SELECT--")); } // Populate the item(s) to the control this.FieldTripId.SetFieldMaxLength(50); System.Collections.Generic.IDictionary <string, object> variables = new System.Collections.Generic.Dictionary <string, object>(); FormulaEvaluator evaluator = new FormulaEvaluator(); if (selectedValue != null && selectedValue.Trim() != "" && !MiscUtils.SetSelectedValue(this.FieldTripId, selectedValue) && !MiscUtils.SetSelectedDisplayText(this.FieldTripId, selectedValue)) { // construct a whereclause to query a record with DatabaseOLR_db%dbo.FieldTrips.FieldTripId = selectedValue CompoundFilter filter2 = new CompoundFilter(CompoundFilter.CompoundingOperators.And_Operator, null); WhereClause whereClause2 = new WhereClause(); filter2.AddFilter(new BaseClasses.Data.ColumnValueFilter(FieldTripsTable.FieldTripId, selectedValue, BaseClasses.Data.BaseFilter.ComparisonOperator.EqualsTo, false)); whereClause2.AddFilter(filter2, CompoundFilter.CompoundingOperators.And_Operator); // Execute the query try { FieldTripsRecord[] rc = FieldTripsTable.GetRecords(whereClause2, new OrderBy(false, false), 0, 1); System.Collections.Generic.IDictionary <string, object> vars = new System.Collections.Generic.Dictionary <string, object> (); // if find a record, add it to the dropdown and set it as selected item if (rc != null && rc.Length == 1) { FieldTripsRecord itemValue = rc[0]; string cvalue = null; string fvalue = null; if (itemValue.FieldTripIdSpecified) { cvalue = itemValue.FieldTripId.ToString(); } Boolean _isExpandableNonCompositeForeignKey = FieldTripOptionsTable.Instance.TableDefinition.IsExpandableNonCompositeForeignKey(FieldTripOptionsTable.FieldTripId); if (_isExpandableNonCompositeForeignKey && FieldTripOptionsTable.FieldTripId.IsApplyDisplayAs) { fvalue = FieldTripOptionsTable.GetDFKA(itemValue, FieldTripOptionsTable.FieldTripId); } if ((!_isExpandableNonCompositeForeignKey) || (String.IsNullOrEmpty(fvalue))) { fvalue = itemValue.Format(FieldTripsTable.Description); } if (fvalue == null || fvalue.Trim() == "") { fvalue = cvalue; } MiscUtils.ResetSelectedItem(this.FieldTripId, new ListItem(fvalue, cvalue)); } } catch { } } string url = this.ModifyRedirectUrl("../FieldTrips/FieldTrips-QuickSelector.aspx", "", true); url = this.Page.ModifyRedirectUrl(url, "", true); url += "?Target=" + this.FieldTripId.ClientID + "&DFKA=" + (this.Page as BaseApplicationPage).Encrypt("Description") + "&IndexField=" + (this.Page as BaseApplicationPage).Encrypt("FieldTripId") + "&EmptyValue=" + (this.Page as BaseApplicationPage).Encrypt("--PLEASE_SELECT--") + "&EmptyDisplayText=" + (this.Page as BaseApplicationPage).Encrypt(this.Page.GetResourceValue("Txt:PleaseSelect")) + "&Mode=" + (this.Page as BaseApplicationPage).Encrypt("FieldValueSingleSelection") + "&RedirectStyle=" + (this.Page as BaseApplicationPage).Encrypt("Popup"); this.FieldTripId.Attributes["onClick"] = "initializePopupPage(this, '" + url + "', " + Convert.ToString(FieldTripId.AutoPostBack).ToLower() + ", event); return false;"; }
public virtual string EvaluateFormula(string formula) { FormulaEvaluator e = new FormulaEvaluator(); e.DataSource = this.DataSource; // Define the calling control. This is used to add other // related table and record controls as variables. e.CallingControl = this; object resultObj = e.Evaluate(formula); if (resultObj == null) return ""; return resultObj.ToString(); }
//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 Subtotal(IXLRange range, bool summaryAbove, GroupTag[] groupTags = null, FormulaEvaluator evaluator = null) { _range = range; _summaryAbove = summaryAbove; _groupTags = groupTags; _evaluator = evaluator; Sheet.Outline.SummaryVLocation = _summaryAbove ? XLOutlineSummaryVLocation.Top : XLOutlineSummaryVLocation.Bottom; var workbook = Sheet.Workbook; const string tempsheet = "__tempsheet"; if (!workbook.Worksheets.TryGetWorksheet(tempsheet, out _tempSheet)) { _tempSheet = workbook.AddWorksheet(tempsheet); _tempSheet.Style = Sheet.Style; _tempSheet.Hide(); } }
//JAVA TO C# CONVERTER WARNING: Method 'throws' clauses are not available in C#: //ORIGINAL LINE: private void loadCSI95(org.hibernate.Session paramSession, String paramString) throws Exception private void loadCSI95(Session paramSession, string paramString) { Console.WriteLine("\n\n\n\nLoading CSI 1995"); 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++) { string str4; string str3; string str2; 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(1)); if (StringUtils.isEmpty(str1)) { string str = notNull(hSSFRow.getCell(3)); int k = str.IndexOf(" -- ", StringComparison.Ordinal); if (k == -1) { continue; } str2 = str.Substring(0, k); str2 = StringUtils.replaceAll(str2, "Division ", ""); if (str2.Length == 1) { str2 = "0" + str2; } str3 = StringUtils.replaceAll(str, " -- ", " "); str4 = str2 + "000"; } else if (str1.Equals("00")) { str2 = str4 = notNull(hSSFRow.getCell(2)); str3 = notNull(hSSFRow.getCell(4)); str2 = str4.Substring(0, 2) + "." + str4.Substring(2, 1); str3 = StringUtils.replaceAll(str3, " - ", " "); } else { str2 = str4 = notNull(hSSFRow.getCell(2)); str3 = notNull(hSSFRow.getCell(5)); string str = str2.Substring(2, 1); str = str + "."; str2 = str4.Substring(0, 2) + "." + str + str4.Substring(3, 2); str3 = StringUtils.replaceAll(str3, " - ", " "); } GroupCodeTable groupCodeTable = (GroupCodeTable)addGroupCode1(str2, str3, str4); long?long = (long?)paramSession.save(groupCodeTable); groupCodeTable.GroupCodeId = long; this.csi95Map[str4] = groupCodeTable.ToString(); Console.WriteLine(str2 + " = " + str4 + " = " + str3); continue; } }
//JAVA TO C# CONVERTER WARNING: Method 'throws' clauses are not available in C#: //ORIGINAL LINE: private void loadWorkgroups(org.hibernate.Session paramSession, String paramString) throws Exception private void loadWorkgroups(Session paramSession, string paramString) { Console.WriteLine("\n\n\n\nLoading Workgroups"); 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(4); int i = getRealNumberOfRows(hSSFSheet); int j; for (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 = toCostOSUoM(notNull(hSSFRow.getCell(2))); decimal bigDecimal1 = notNullBigDecimal(hSSFRow.getCell(3), 0.0D); decimal bigDecimal2 = notNullBigDecimal(hSSFRow.getCell(4), 1.0D); string str4 = notNull(hSSFRow.getCell(5)); string str5 = notNull(hSSFRow.getCell(8)); string str6 = ""; if (str5.Length >= 2 && !StringUtils.isBlank(str5)) { str6 = "0" + str5.Substring(0, 2) + "00"; } if (acceptProject(str1)) { AssemblyTable assemblyTable = BlankResourceInitializer.createBlankAssembly(null); assemblyTable.ItemCode = str2; assemblyTable.Title = str4; assemblyTable.Unit = str3; assemblyTable.Quantity = bigDecimal1; assemblyTable.Project = str1; assemblyTable.Currency = "USD"; assemblyTable.ActivityBased = false; assemblyTable.AssemblyChildSet = new HashSet <object>(); 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>(); assemblyTable.EditorId = "ccc"; assemblyTable.CreateUserId = "ccc"; assemblyTable.LastUpdate = this.lastUpdate; assemblyTable.CreateDate = this.lastUpdate; assemblyTable.CustomText1 = "Workgroup"; if (this.csi95Map.ContainsKey(str6)) { assemblyTable.GroupCode = (string)this.csi95Map[str6]; } else if (!StringUtils.isBlank(str6)) { Console.WriteLine("CSI Not Found: " + str6); } long?long = (long?)paramSession.save(assemblyTable); assemblyTable = (AssemblyTable)paramSession.load(assemblyTable.GetType(), long); this.operationsMap[str1 + str2] = assemblyTable; } } hSSFSheet = hSSFWorkbook.getSheetAt(3); i = getRealNumberOfRows(hSSFSheet); for (j = 1; j < i; j++) { if (j % this.rowsToCommit == 0) { paramSession.Transaction.commit(); paramSession.Transaction.begin(); Console.WriteLine("Processing next " + this.rowsToCommit + " - " + j + "/" + i + "..."); } 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 = notNull(hSSFRow.getCell(3)); string str5 = notNull(hSSFRow.getCell(4)); decimal bigDecimal = notNullBigDecimal(hSSFRow.getCell(5), 0.0D); AssemblyTable assemblyTable = (AssemblyTable)this.operationsMap[str1 + str2]; ResourceTable resourceTable = (ResourceTable)this.resourcesMap[str1 + str3]; if (assemblyTable == null) { Console.Error.WriteLine("Workgroup not found: " + str2 + ", project: " + str1); continue; } if (resourceTable == null) { resourceTable = (ResourceTable)this.operationsMap[str1 + str3]; if (resourceTable == null) { Console.Error.WriteLine("Operation or Resource not found: " + str3 + ", project: " + str1); continue; } } if (BigDecimalMath.cmp(BigDecimalMath.ZERO, assemblyTable.Quantity) == 0) { Console.WriteLine("Divide by zero error on workgroup: " + str2 + ", operation or resource: " + str3 + ", project: " + str1); bigDecimal = BigDecimalMath.ONE; } else { bigDecimal = BigDecimalMath.div(bigDecimal, assemblyTable.Quantity); } assignToResource(paramSession, assemblyTable, resourceTable, bigDecimal); paramSession.flush(); assemblyTable = (AssemblyTable)paramSession.load(assemblyTable.GetType(), assemblyTable.Id); assemblyTable.recalculate(); paramSession.update(assemblyTable); continue; } }
//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 void Part2() { Assert.Equal(9966990988262, StringListRetriever.Retreive("InputList18.txt").Select(x => FormulaEvaluator.EvaluateAdvanced(x)).Sum()); }
public void Part1() { Assert.Equal(280014646144, StringListRetriever.Retreive("InputList18.txt").Select(x => FormulaEvaluator.Evaluate(x)).Sum()); }
public void Part1Sample() { List <string> formulas = GetPart1SampleData(); Assert.Equal(71, FormulaEvaluator.Evaluate(formulas[0])); Assert.Equal(51, FormulaEvaluator.Evaluate(formulas[1])); Assert.Equal(26, FormulaEvaluator.Evaluate(formulas[2])); Assert.Equal(437, FormulaEvaluator.Evaluate(formulas[3])); Assert.Equal(12240, FormulaEvaluator.Evaluate(formulas[4])); Assert.Equal(13632, FormulaEvaluator.Evaluate(formulas[5])); Assert.Equal(71 + 51 + 26 + 437 + 12240 + 13632, GetPart1SampleData().Select(x => FormulaEvaluator.Evaluate(x)).Sum()); Assert.Equal(72077, FormulaEvaluator.Evaluate("9 + 2 * ((7 + 9 + 5 + 7) * 3 + (5 * 3 * 6 * 5 + 6) + (9 * 4 + 9 * 6 + 9)) * 8 + 5")); }
public void WrongExpressionShouldThrowParseException() { var eval = new FormulaEvaluator(); Assert.Throws <ParseException>(() => eval.Evaluate("{{missing}}")); }