コード例 #1
0
        private BoqItemDefaultFormulas()
        {
            string str1  = BoqItemFormulaEvaluator.variableFromField("escalationCost");
            string str2  = BoqItemFormulaEvaluator.variableFromField("offeredPrice");
            string str3  = BoqItemFormulaEvaluator.variableFromField("totalCost");
            string str4  = BoqItemFormulaEvaluator.variableFromField("assemblyTotalCost");
            string str5  = BoqItemFormulaEvaluator.variableFromField("materialTotalCost");
            string str6  = BoqItemFormulaEvaluator.variableFromField("subcontractorTotalCost");
            string str7  = BoqItemFormulaEvaluator.variableFromField("equipmentTotalCost");
            string str8  = BoqItemFormulaEvaluator.variableFromField("laborTotalCost");
            string str9  = BoqItemFormulaEvaluator.variableFromField("consumableTotalCost");
            string str10 = BoqItemFormulaEvaluator.variableFromField("markup");
            string str11 = BoqItemFormulaEvaluator.variableFromField("productivity");
            string str12 = BoqItemFormulaEvaluator.variableFromField("prodFactor");
            string str13 = BoqItemFormulaEvaluator.variableFromField("mhoursFactor");
            string str14 = BoqItemFormulaEvaluator.variableFromField("adjustedProd");
            string str15 = BoqItemFormulaEvaluator.variableFromField("duration");
            string str16 = BoqItemFormulaEvaluator.variableFromField("unitManhours");
            string str17 = BoqItemFormulaEvaluator.variableFromField("laborManhours");
            string str18 = BoqItemFormulaEvaluator.variableFromField("rate");
            string str19 = BoqItemFormulaEvaluator.variableFromField("unit");
            string str20 = BoqItemFormulaEvaluator.variableFromField("secondRate");
            string str21 = BoqItemFormulaEvaluator.variableFromField("unitsDiv");
            string str22 = BoqItemFormulaEvaluator.variableFromField("quantity");
            string str23 = BoqItemFormulaEvaluator.variableFromField("secondQuantity");
            string str24 = BoqItemFormulaEvaluator.variableFromField("measuredQuantity");
            string str25 = BoqItemFormulaEvaluator.variableFromField("estimatedQuantity");
            string str26 = BoqItemFormulaEvaluator.variableFromField("assemblyRate");
            string str27 = BoqItemFormulaEvaluator.variableFromField("materialRate");
            string str28 = BoqItemFormulaEvaluator.variableFromField("subcontractorRate");
            string str29 = BoqItemFormulaEvaluator.variableFromField("equipmentRate");
            string str30 = BoqItemFormulaEvaluator.variableFromField("laborRate");
            string str31 = BoqItemFormulaEvaluator.variableFromField("consumableRate");
            string str32 = BoqItemFormulaEvaluator.variableFromField("fixedCost");

            this.fieldToFormulaMap["totalCost"]              = "(" + str18 + "*" + str22 + ")+" + str32;
            this.fieldToFormulaMap["offeredPrice"]           = str3 + "+" + str1 + "+" + str10;
            this.fieldToFormulaMap["quantityLoss"]           = "IF(AND(" + str24 + "<>0," + str25 + "<>0),(ABS(" + str24 + "-" + str25 + ")),0)";
            this.fieldToFormulaMap["quantity"]               = "IF(" + str24 + "<>0," + str24 + "," + str25 + ")";
            this.fieldToFormulaMap["rate"]                   = str29 + "+" + str28 + "+" + str27 + "+" + str30 + "+" + str31;
            this.fieldToFormulaMap["secondRate"]             = str18 + "*" + str21;
            this.fieldToFormulaMap["secondQuantity"]         = "IF(UNITS_DIV<>0," + str22 + "/" + str21 + ",0)";
            this.fieldToFormulaMap["secondUnit"]             = "UNIT1_TO_UNIT2(" + str19 + ")";
            this.fieldToFormulaMap["unitsDiv"]               = "UNIT1_TO_UNIT2_DIV(" + str19 + ")";
            this.fieldToFormulaMap["offeredRate"]            = "IF(" + str22 + "<>0," + str2 + "/" + str22 + ",0)";
            this.fieldToFormulaMap["offeredSecondRate"]      = "IF(" + str23 + "<>0," + str2 + "/" + str23 + ",0)";
            this.fieldToFormulaMap["productivity"]           = "IF(" + str15 + "<>0,IF(" + str12 + "<>0,(" + str22 + "/" + str15 + ")/" + str12 + "," + str22 + "/" + str15 + "),0)";
            this.fieldToFormulaMap["duration"]               = "IF(" + str14 + "<>0," + str22 + "/" + str14 + ",0)";
            this.fieldToFormulaMap["mhoursFactor"]           = "IF(" + str12 + "<>0," + '\x0001' + "/" + str12 + ",0)";
            this.fieldToFormulaMap["prodFactor"]             = "IF(" + str13 + "<>0," + '\x0001' + "/" + str13 + ",0)";
            this.fieldToFormulaMap["adjustedProd"]           = "IF(" + str12 + "<>0," + str11 + "*" + str12 + "," + str11 + ")";
            this.fieldToFormulaMap["assemblyTotalCost"]      = str26 + "*" + str22;
            this.fieldToFormulaMap["materialTotalCost"]      = str27 + "*" + str22;
            this.fieldToFormulaMap["subcontractorTotalCost"] = str28 + "*" + str22;
            this.fieldToFormulaMap["equipmentTotalCost"]     = str29 + "*" + str22;
            this.fieldToFormulaMap["laborTotalCost"]         = str30 + "*" + str22;
            this.fieldToFormulaMap["consumableTotalCost"]    = str31 + "*" + str22;
            this.fieldToFormulaMap["unitManhours"]           = "IF(" + str22 + "<>0,IF(" + str12 + "<>0,(" + str17 + "/" + str22 + ")*" + str12 + "," + str17 + "/" + str22 + "),0)";
            this.fieldToFormulaMap["adjustedUnitManhours"]   = "IF(" + str22 + "<>0," + str17 + "/" + str22 + ",0)";
        }
コード例 #2
0
 private string variableFromField(string paramString)
 {
     return(BoqItemFormulaEvaluator.variableFromField(paramString));
 }