示例#1
0
//JAVA TO C# CONVERTER WARNING: Method 'throws' clauses are not available in C#:
//ORIGINAL LINE: public org.boris.expr.Expr evaluate(org.boris.expr.IEvaluationContext paramIEvaluationContext, org.boris.expr.Expr[] paramArrayOfExpr) throws org.boris.expr.ExprException
        public virtual Expr evaluate(IEvaluationContext paramIEvaluationContext, Expr[] paramArrayOfExpr)
        {
            assertArgCount(paramArrayOfExpr, 0);
            try
            {
                string str = null;
                if (paramIEvaluationContext is ExprAbstractEvaluationContext)
                {
                    ProjectUrlTable projectUrlTable = ((ExprAbstractEvaluationContext)paramIEvaluationContext).ProjectUrlTable;
                    if (projectUrlTable != null)
                    {
                        str = projectUrlTable.DatabaseName;
                    }
                    else if (string.ReferenceEquals(str, null))
                    {
                        str = ((ProjectServerDBUtil)ProjectDBUtil.currentProjectDBUtil()).ProjectUrl.DatabaseName;
                    }
                }
                return((string.ReferenceEquals(str, null)) ? new ExprString("") : new ExprString(str));
            }
            catch (Exception)
            {
                return(new ExprString("-"));
            }
        }
示例#2
0
//JAVA TO C# CONVERTER WARNING: Method 'throws' clauses are not available in C#:
//ORIGINAL LINE: public org.boris.expr.Expr evaluate(org.boris.expr.IEvaluationContext paramIEvaluationContext, org.boris.expr.Expr[] paramArrayOfExpr) throws org.boris.expr.ExprException
        public virtual Expr evaluate(IEvaluationContext paramIEvaluationContext, Expr[] paramArrayOfExpr)
        {
            assertArgCount(paramArrayOfExpr, 0);
            try
            {
                int?integer = null;
                if (paramIEvaluationContext is ExprAbstractEvaluationContext)
                {
                    ProjectUrlTable projectUrlTable = ((ExprAbstractEvaluationContext)paramIEvaluationContext).ProjectUrlTable;
                    if (projectUrlTable != null)
                    {
                        integer = projectUrlTable.ProjectInfoTable.PaymentDuration;
                    }
                    else if (integer == null)
                    {
                        integer = Convert.ToInt32(ProjectDBUtil.currentProjectDBUtil().Properties.getIntProperty("project.constructionduration"));
                    }
                }
                return((integer == null) ? new ExprInteger(1) : new ExprInteger(integer.Value));
            }
            catch (Exception)
            {
                return(new ExprInteger(1));
            }
        }
        //	public AssemblyTableList convertToLineItemList(ProjectDBUtil prjDBUtil, boolean persistNew) {
        //		return convertToLineItemList(prjDBUtil, persistNew, 100L);
        //	}

        public virtual AssemblyTableList convertToLineItemList(ProjectDBUtil prjDBUtil, bool persistNew, bool keepIds)
        {
            AssemblyTable[] items = new AssemblyTable[_o_items.Length];

            //System.out.println("Starting conversion...");
            for (int i = 0; i < _o_items.Length; i++)
            {
                items[i] = _o_items[i].convertToAssembly(prjDBUtil, currencyCode, persistNew, false, false, keepIds);
                if (!keepIds)
                {
                    items[i].DatabaseCreationDate = 100L;                     // That is a missing definition ResourceUtil.MISSING
                    items[i].DatabaseId           = null;
                }

                if (items[i].ActivityBased.Value == false)
                {
                    items[i].Productivity = decimal.One;
                }
                //System.out.println("I converted: "+items[i].getTitle()+" it now has "+items[i].getResourceAssignments(null).size()+" before "+
                //		_o_items[i].getResourceAssignments(null).size()
                //		);
            }

            return(new AssemblyTableList(items));
        }
示例#4
0
//JAVA TO C# CONVERTER WARNING: Method 'throws' clauses are not available in C#:
//ORIGINAL LINE: public org.boris.expr.Expr evaluate(org.boris.expr.IEvaluationContext paramIEvaluationContext, org.boris.expr.Expr[] paramArrayOfExpr) throws org.boris.expr.ExprException
        public virtual Expr evaluate(IEvaluationContext paramIEvaluationContext, Expr[] paramArrayOfExpr)
        {
            assertArgCount(paramArrayOfExpr, 0);
            try
            {
                long?long = null;
                if (paramIEvaluationContext is ExprAbstractEvaluationContext)
                {
                    ProjectUrlTable projectUrlTable = ((ExprAbstractEvaluationContext)paramIEvaluationContext).ProjectUrlTable;
                    if (projectUrlTable != null)
                    {
                        long = projectUrlTable.Id;
                    }
                    else if (long == null)
                    {
                        long = ProjectDBUtil.currentProjectDBUtil().ProjectUrlId;
                    }
                }
                return(new ExprInteger(long.Value));
            }
            catch (Exception)
            {
                return(new ExprString("-"));
            }
        }
//JAVA TO C# CONVERTER WARNING: Method 'throws' clauses are not available in C#:
//ORIGINAL LINE: public org.boris.expr.Expr evaluate(org.boris.expr.IEvaluationContext paramIEvaluationContext, org.boris.expr.Expr[] paramArrayOfExpr) throws org.boris.expr.ExprException
        public virtual Expr evaluate(IEvaluationContext paramIEvaluationContext, Expr[] paramArrayOfExpr)
        {
            assertArgCount(paramArrayOfExpr, 0);
            DateTime date = null;

            try
            {
                if (paramIEvaluationContext is ExprAbstractEvaluationContext)
                {
                    ProjectUrlTable projectUrlTable = ((ExprAbstractEvaluationContext)paramIEvaluationContext).ProjectUrlTable;
                    if (projectUrlTable != null)
                    {
                        date = projectUrlTable.ProjectInfoTable.SubmissionDate;
                    }
                    else if (date == null)
                    {
                        date = ProjectDBUtil.currentProjectDBUtil().Properties.getDateProperty("project.submission.date");
                    }
                }
                return((date == null) ? new ExprDouble(ExcelDate.toExcelDate((DateTime.Now).Ticks)) : new ExprDouble(ExcelDate.toExcelDate(date.Ticks)));
            }
            catch (Exception)
            {
                return(new ExprDouble(ExcelDate.toExcelDate(date.Ticks)));
            }
        }
示例#6
0
//JAVA TO C# CONVERTER WARNING: Method 'throws' clauses are not available in C#:
//ORIGINAL LINE: public org.boris.expr.Expr evaluate(org.boris.expr.IEvaluationContext paramIEvaluationContext, org.boris.expr.Expr[] paramArrayOfExpr) throws org.boris.expr.ExprException
        public virtual Expr evaluate(IEvaluationContext paramIEvaluationContext, Expr[] paramArrayOfExpr)
        {
            assertArgCount(paramArrayOfExpr, 0);
            try
            {
                string str = null;
                if (paramIEvaluationContext is ExprAbstractEvaluationContext)
                {
                    ProjectUrlTable projectUrlTable = ((ExprAbstractEvaluationContext)paramIEvaluationContext).ProjectUrlTable;
                    if (projectUrlTable != null)
                    {
                        str = projectUrlTable.ProjectInfoTable.Code;
                    }
                    else if (string.ReferenceEquals(str, null))
                    {
                        str = ProjectDBUtil.currentProjectDBUtil().Properties.getProperty("project.code");
                    }
                }
                return((string.ReferenceEquals(str, null)) ? new ExprString("") : new ExprString(str));
            }
            catch (Exception)
            {
                return(new ExprString("-"));
            }
        }
示例#7
0
 public WBSCache(ProjectDBUtil prjDBUtil, bool initCaches)
 {
     o_prjDbUtil = prjDBUtil;
     if (initCaches)
     {
         initCache(prjDBUtil.Properties.getProperty("project.code"), prjDBUtil.Properties.getProperty("project.name"));
     }
 }
        private static string constructKey(ProjectDBUtil paramProjectDBUtil, string paramString1, string paramString2, DateTime paramDate)
        {
            if (paramDate == null)
            {
                return(paramProjectDBUtil.ProjectUrlId + "_" + paramString1 + "_" + paramString2 + "_null");
            }
            GregorianCalendar gregorianCalendar = new GregorianCalendar();

            gregorianCalendar.Time = paramDate;
            return(paramProjectDBUtil.ProjectUrlId + "_" + paramString1 + "_" + paramString2 + "_" + gregorianCalendar.get(2) + "_" + gregorianCalendar.get(1));
        }
//JAVA TO C# CONVERTER WARNING: Method 'throws' clauses are not available in C#:
//ORIGINAL LINE: public org.boris.expr.Expr evaluate(org.boris.expr.IEvaluationContext paramIEvaluationContext, org.boris.expr.Expr[] paramArrayOfExpr) throws org.boris.expr.ExprException
        public virtual Expr evaluate(IEvaluationContext paramIEvaluationContext, Expr[] paramArrayOfExpr)
        {
            assertArgCount(paramArrayOfExpr, 0);
            string str = this.defValue;

            if (ProjectDBUtil.currentProjectDBUtil() != null)
            {
                str = ProjectDBUtil.currentProjectDBUtil().Properties.getProperty(this.key);
            }
            return(new ExprString(str));
        }
示例#10
0
        public ParamItemCache(ProjectDBUtil prjDBUtil)
        {
            o_prjDBUtil = prjDBUtil;

            try
            {
                initializeCache();
            }
            catch (Exception e)
            {
                Console.WriteLine(e.ToString());
                Console.Write(e.StackTrace);
            }
        }
//JAVA TO C# CONVERTER WARNING: Method 'throws' clauses are not available in C#:
//ORIGINAL LINE: public static void moveDataBackUpRestore(nomitech.common.ui.UIProgress paramUIProgress, nomitech.common.ProjectDBUtil paramProjectDBUtil1, nomitech.common.ProjectDBUtil paramProjectDBUtil2) throws Exception
        public static void moveDataBackUpRestore(UIProgress paramUIProgress, ProjectDBUtil paramProjectDBUtil1, ProjectDBUtil paramProjectDBUtil2)
        {
            ProjectDBCEPDataMover projectDBCEPDataMover = new ProjectDBCEPDataMover(paramUIProgress, paramProjectDBUtil1, paramProjectDBUtil2);

            try
            {
                projectDBCEPDataMover.backUpAndRestore();
            }
            catch (Exception exception)
            {
                Console.WriteLine("COULD NOT MOVE DATA USING BACKUP / RESTORE");
                Console.WriteLine(exception.ToString());
                Console.Write(exception.StackTrace);
                throw exception;
            }
        }
            public virtual void valueChanged(Range param1Range, Expr param1Expr)
            {
                string str = BoqItemFormulaEvaluator.fieldFromVariable(param1Range.Dimension1Name);

                if (!string.ReferenceEquals(str, null) && formulaFields.Contains(str + "Formula"))
                {
                    try
                    {
                        object @object = valueFromExpression(param1Expr);
                        if (@object is decimal)
                        {
                            @object = ((decimal)@object).setScale(10, 4);
                        }
                        BlankResourceInitializer.setFieldValue(outerInstance.boqTable, str, @object);
                    }
                    catch (Exception exception)
                    {
                        Console.WriteLine("CAN NOT EVALUATE: " + str + " = " + param1Expr + " = " + valueFromExpression(param1Expr));
                        Console.WriteLine(exception.ToString());
                        Console.Write(exception.StackTrace);
                    }
                }
                else
                {
                    ResourceToAssignmentTable resourceToAssignmentTable = (ResourceToAssignmentTable)outerInstance.assignmentsWithFormulasMap[param1Range.Dimension1Name];
                    if (resourceToAssignmentTable != null)
                    {
                        decimal bigDecimal = resourceToAssignmentTable.QuantityPerUnit.setScale(10, 4);
                        object  @object    = valueFromExpression(param1Expr);
                        if (@object is decimal)
                        {
                            decimal bigDecimal1 = (decimal)@object;
                            if (resourceToAssignmentTable.AssignmentResourceTable is nomitech.common.db.local.LaborTable || resourceToAssignmentTable.AssignmentResourceTable is nomitech.common.db.local.EquipmentTable)
                            {
                                bigDecimal1 = bigDecimal1 * (ProjectDBUtil.currentProjectDBUtil().Properties.getHoursFromUnit(resourceToAssignmentTable.AssignmentResourceTable.Unit));
                            }
                            bigDecimal1.setScale(10, 4);
                            if (BigDecimalMath.cmpCheckNulls(bigDecimal, bigDecimal1) != 0)
                            {
                                resourceToAssignmentTable.QuantityPerUnit = bigDecimal1;
                                outerInstance.updatedResourceToAssignmentQtyPerUnitSet.Add(resourceToAssignmentTable);
                                outerInstance.someAssignemntFormulaValueChanged = true;
                            }
                        }
                    }
                }
            }
示例#13
0
//JAVA TO C# CONVERTER WARNING: Method 'throws' clauses are not available in C#:
//ORIGINAL LINE: public org.boris.expr.Expr evaluate(org.boris.expr.IEvaluationContext paramIEvaluationContext, org.boris.expr.Expr[] paramArrayOfExpr) throws org.boris.expr.ExprException
        public virtual Expr evaluate(IEvaluationContext paramIEvaluationContext, Expr[] paramArrayOfExpr)
        {
            assertArgCount(paramArrayOfExpr, 0);
            string str = null;

            if (paramIEvaluationContext is ExprAbstractEvaluationContext)
            {
                ProjectUrlTable projectUrlTable = ((ExprAbstractEvaluationContext)paramIEvaluationContext).ProjectUrlTable;
                if (projectUrlTable != null)
                {
                    str = projectUrlTable.ProjectInfoTable.Currency;
                }
                else if (string.ReferenceEquals(str, null) && ProjectDBUtil.currentProjectDBUtil() != null)
                {
                    str = ProjectDBUtil.currentProjectDBUtil().Properties.getProperty("project.currency.symbol");
                    str = CurrencyHome.findBySymbol(str).Code;
                }
            }
            return((string.ReferenceEquals(str, null)) ? new ExprString("USD") : new ExprString(str));
        }
示例#14
0
//JAVA TO C# CONVERTER WARNING: Method 'throws' clauses are not available in C#:
//ORIGINAL LINE: public static void moveDataNotSameInstance(nomitech.common.ui.UIProgress paramUIProgress, nomitech.common.ProjectDBUtil paramProjectDBUtil1, nomitech.common.ProjectDBUtil paramProjectDBUtil2, java.util.Map<long, long> paramMap) throws Exception
        public static void moveDataNotSameInstance(UIProgress paramUIProgress, ProjectDBUtil paramProjectDBUtil1, ProjectDBUtil paramProjectDBUtil2, IDictionary <long, long> paramMap)
        {
            ProjectUrlTable projectUrlTable = paramProjectDBUtil2.ProjectUrl;

            if (projectUrlTable.ProjectUrlId == null)
            {
                projectUrlTable.ProjectUrlId = Convert.ToInt64(DateTimeHelper.CurrentUnixTimeMillis());
            }
            ProjectDBDataMover projectDBDataMover = new ProjectDBDataMover(paramUIProgress, paramProjectDBUtil1.ProjectUrl, paramProjectDBUtil2.ProjectUrl);

            if (paramProjectDBUtil1 is nomitech.common.ProjectFileDBUtil)
            {
                projectDBDataMover.sourceConnection            = paramProjectDBUtil1.createJdbcConnection();
                projectDBDataMover.sourceConnection.AutoCommit = false;
            }
            if (paramProjectDBUtil2 is nomitech.common.ProjectFileDBUtil)
            {
                projectDBDataMover.destConnection            = paramProjectDBUtil2.createJdbcConnection();
                projectDBDataMover.destConnection.AutoCommit = false;
            }
            projectDBDataMover.oldModelIdsToNew = paramMap;
            projectDBDataMover.moveDataNotSameInstance();
        }
示例#15
0
 public ProjectVariableCache(ProjectDBUtil prjDbUtil)
 {
     this.prjDbUtil = prjDbUtil;
     initCache();
 }
 private string constructInsertSuffixForTable(ProjectDBUtil paramProjectDBUtil, string paramString)
 {
     return((paramProjectDBUtil.CollaborationMode && paramProjectDBUtil.Configuration.getProperty("hibernate.connection.url").StartsWith("jdbc:jtds:")) ? (" SET IDENTITY_INSERT " + paramString + " OFF") : "");
 }
示例#17
0
//JAVA TO C# CONVERTER WARNING: Method 'throws' clauses are not available in C#:
//ORIGINAL LINE: public static void moveDataNotSameInstance(nomitech.common.ui.UIProgress paramUIProgress, nomitech.common.ProjectDBUtil paramProjectDBUtil1, nomitech.common.ProjectDBUtil paramProjectDBUtil2) throws Exception
        public static void moveDataNotSameInstance(UIProgress paramUIProgress, ProjectDBUtil paramProjectDBUtil1, ProjectDBUtil paramProjectDBUtil2)
        {
            moveDataNotSameInstance(paramUIProgress, paramProjectDBUtil1, paramProjectDBUtil2, null);
        }
//JAVA TO C# CONVERTER WARNING: Method 'throws' clauses are not available in C#:
//ORIGINAL LINE: public static void moveData(nomitech.common.ui.UIProgress paramUIProgress, nomitech.common.ProjectDBUtil paramProjectDBUtil1, nomitech.common.ProjectDBUtil paramProjectDBUtil2) throws Exception
        public static void moveData(UIProgress paramUIProgress, ProjectDBUtil paramProjectDBUtil1, ProjectDBUtil paramProjectDBUtil2)
        {
            ProjectDBCEPDataMover projectDBCEPDataMover = new ProjectDBCEPDataMover(paramUIProgress, paramProjectDBUtil1, paramProjectDBUtil2);

            projectDBCEPDataMover.moveClassData();
        }
//JAVA TO C# CONVERTER WARNING: Method 'throws' clauses are not available in C#:
//ORIGINAL LINE: public ProjectDBCEPDataMover(nomitech.common.ui.UIProgress paramUIProgress, nomitech.common.ProjectDBUtil paramProjectDBUtil1, nomitech.common.ProjectDBUtil paramProjectDBUtil2) throws Exception
        public ProjectDBCEPDataMover(UIProgress paramUIProgress, ProjectDBUtil paramProjectDBUtil1, ProjectDBUtil paramProjectDBUtil2)
        {
            this.progress = paramUIProgress;
            this.source   = paramProjectDBUtil1;
            this.dest     = paramProjectDBUtil2;
        }
示例#20
0
//JAVA TO C# CONVERTER WARNING: Method 'throws' clauses are not available in C#:
//ORIGINAL LINE: public void projectSaving(nomitech.common.ui.UIProgress paramUIProgress, nomitech.common.ProjectDBUtil paramProjectDBUtil) throws Exception
        public virtual void projectSaving(UIProgress paramUIProgress, ProjectDBUtil paramProjectDBUtil)
        {
        }
//JAVA TO C# CONVERTER WARNING: Method 'throws' clauses are not available in C#:
//ORIGINAL LINE: public org.boris.expr.Expr evaluate(org.boris.expr.IEvaluationContext paramIEvaluationContext, org.boris.expr.Expr[] paramArrayOfExpr) throws org.boris.expr.ExprException
        public virtual Expr evaluate(IEvaluationContext paramIEvaluationContext, Expr[] paramArrayOfExpr)
        {
            assertMinArgCount(paramArrayOfExpr, 4);
            for (sbyte b = 0; b < paramArrayOfExpr.Length; b++)
            {
                if (paramArrayOfExpr[b] is org.boris.expr.ExprEvaluatable)
                {
                    paramArrayOfExpr[b] = evalArg(paramIEvaluationContext, paramArrayOfExpr[b]);
                }
            }
            string        str1          = "p.IFCNUMVAL:unitFactorQuery";
            string        str2          = (paramArrayOfExpr[0] is ExprString) ? ((ExprString)paramArrayOfExpr[0]).str : paramArrayOfExpr[0].ToString();
            string        str3          = (paramArrayOfExpr[1] is ExprString) ? ((ExprString)paramArrayOfExpr[1]).str : paramArrayOfExpr[1].ToString();
            string        str4          = (paramArrayOfExpr[2] is ExprString) ? ((ExprString)paramArrayOfExpr[2]).str : paramArrayOfExpr[2].ToString();
            string        str5          = (paramArrayOfExpr[3] is ExprString) ? ((ExprString)paramArrayOfExpr[3]).str : paramArrayOfExpr[3].ToString();
            string        str6          = (paramArrayOfExpr.Length >= 5) ? ((paramArrayOfExpr[4] is ExprString) ? ((ExprString)paramArrayOfExpr[4]).str : paramArrayOfExpr[4].ToString()) : null;
            int           i             = findQtyType(str5);
            ProjectDBUtil projectDBUtil = ProjectDBUtil.currentProjectDBUtil();

            if (projectDBUtil == null)
            {
                return(new ExprTakeoff(-1.0D, null));
            }
            decimal bigDecimal = BigDecimalMath.ZERO;

            ConditionTable[] arrayOfConditionTable = null;
            bool             @bool = projectDBUtil.hasOpenedSession();

            try
            {
                string str7 = "SELECT e.IFCTITLE as \"title\", e.IFCDESCRIPTION as \"description\", e.IFCBUILDING as \"building\", e.IFCSTOREY as \"storey\", e.IFCLAYER as \"layer\", e.IFCLOCATION as \"location\", e.IFCMATERIAL as \"bimMaterial\", e.IFCOBJECTTYPE as \"bimType\",e.IFCFILE as \"databaseName\", '  ' as \"username\", '  ' as \"password\", e.IFCFNAME as \"host\", e.CNDID as \"bidNo\", e.CNDID as \"cndNo\", e.CNDID as \"cndId\", e.IFCID as \"globalId\", e.IFCOBJECTTYPE as \"cndType\", 'BIM' as \"takeOffType\", e.IFCQTY2 as \"quantity2\", e.IFCQTY3 as \"quantity3\", NULL as \"quantityF\",e.IFCQTYNAME2 as \"quantity2Name\", e.IFCQTYNAME3 as \"quantity3Name\", '  ' as \"quantityFName\",e.IFCUOM2 as \"unit2\", e.IFCUOM3 as \"unit3\", '  ' as \"unitF\", '  ' as \"formulaF\", p.IFCPROPNAME as \"quantity1Name\", ':unitParam' as \"unit1\", (:quantityQuery) as \"quantity1\", 1 as \"defaultQuantity\" FROM IFCELEMENT AS e INNER JOIN IFCPROPERTY p ON e.ELEMID = p.ELEMID WHERE e.PRJID = :prjId AND (p.IFCNUMVAL is not null AND e.IFCMODEL = ':modelName' AND p.IFCPROPNAME = :propertyNameParam AND e.IFCOBJECTTYPE = ':objectTypeParam' AND p.IFCQTYTYPE = :quantityTypeParam)";
                if (StringUtils.isNullOrBlank(str3))
                {
                    str7 = StringUtils.replaceAll(str7, "AND e.IFCOBJECTTYPE=':objectTypeParam'", "");
                }
                else
                {
                    str7 = StringUtils.replaceAll(str7, ":objectTypeParam", str3);
                }
                if (StringUtils.isNullOrBlank(str5))
                {
                    str7 = StringUtils.replaceAll(str7, "AND p.IFCQTYTYPE = :quantityTypeParam", "");
                }
                else
                {
                    str7 = StringUtils.replaceAll(str7, ":quantityTypeParam", "" + i);
                }
                str7 = StringUtils.replaceAll(str7, ":modelName", str2);
                int j = 5;
                if (!StringUtils.isNullOrBlank(str6))
                {
                    str7 = str7 + " AND (" + str6 + ")";
                    j    = 5 + StringUtils.numberOfOccurences(str6, '?');
                }
                int    k    = j;
                string str8 = (k < paramArrayOfExpr.Length) ? ((ExprString)paramArrayOfExpr[k]).str : null;
                if (!string.ReferenceEquals(str8, null))
                {
                    str7 = StringUtils.replaceAll(str7, ":quantityQuery", str8);
                }
                else
                {
                    str7 = StringUtils.replaceAll(str7, ":quantityQuery", str1);
                    str7 = StringUtils.replaceAll(str7, ":unitFactorQuery", makeUnitFactorQuery(i, str5));
                }
                if (!str4.StartsWith("QUERY", StringComparison.Ordinal))
                {
                    str7 = StringUtils.replaceAll(str7, ":propertyNameParam", "'" + str4 + "'");
                }
                else
                {
                    str4 = StringUtils.replace(str4, "QUERY", "");
                    str7 = StringUtils.replaceAll(str7, ":propertyNameParam", str4);
                }
                string str9  = (++k < paramArrayOfExpr.Length) ? ((ExprString)paramArrayOfExpr[k]).str : null;
                string str10 = (++k < paramArrayOfExpr.Length) ? ((ExprString)paramArrayOfExpr[k]).str : null;
                if (StringUtils.isNullOrBlank(str10))
                {
                    str7 = StringUtils.replaceAll(str7, ":unitParam", str5);
                }
                else
                {
                    str7 = StringUtils.replaceAll(str7, ":unitParam", str10);
                }
                str7 = StringUtils.replaceAll(str7, ":prjId", "" + projectDBUtil.ProjectUrlId);
                Query query = projectDBUtil.currentSession().createSQLQuery(str7);
                sbyte b1    = 5;
                for (b1 = 5; b1 < j; b1++)
                {
                    sbyte b3 = b1;
                    if (paramArrayOfExpr[b3] is ExprString)
                    {
                        query = query.setString(b3 - 5, ((ExprString)paramArrayOfExpr[b3]).str);
                    }
                    else if (paramArrayOfExpr[b3] is ExprDouble)
                    {
                        query = query.setDouble(b3 - 5, ((ExprDouble)paramArrayOfExpr[b3]).doubleValue());
                    }
                    else if (paramArrayOfExpr[b3] is ExprInteger)
                    {
                        query = query.setInteger(b3 - 5, ((ExprInteger)paramArrayOfExpr[b3]).intValue());
                    }
                    else if (paramArrayOfExpr[b3] is ExprBoolean)
                    {
                        query = query.setBoolean(b3 - 5, ((ExprBoolean)paramArrayOfExpr[b3]).booleanValue());
                    }
                    else if (paramArrayOfExpr[b3] is ExprArray)
                    {
                        Expr[] arrayOfExpr = ((ExprArray)paramArrayOfExpr[b3]).InternalArray;
                        if (arrayOfExpr.Length == 0)
                        {
                            return(new ExprTakeoff(bigDecimal.doubleValue(), arrayOfConditionTable));
                        }
                        List <object> arrayList = new List <object>(arrayOfExpr.Length);
                        foreach (Expr expr in arrayOfExpr)
                        {
                            if (expr is ExprNumber)
                            {
                                arrayList.Add(Convert.ToDouble(((ExprNumber)expr).doubleValue()));
                            }
                            else if (expr is ExprString)
                            {
                                arrayList.Add(((ExprString)paramArrayOfExpr[b3]).str);
                            }
                            else
                            {
                                arrayList.Add(paramArrayOfExpr[b3].ToString());
                            }
                        }
                        query = query.setParameter(b3 - 5, arrayList);
                    }
                    else
                    {
                        query = query.setString(b3 - 5, paramArrayOfExpr[b3].ToString());
                    }
                }
                System.Collections.IList list = query.list();
                arrayOfConditionTable = new ConditionTable[list.Count];
                sbyte b2 = 0;
                foreach (object[] arrayOfObject in list)
                {
                    ConditionTable conditionTable = new ConditionTable();
                    conditionTable.Title           = castToString(arrayOfObject[0]);
                    conditionTable.Description     = castToString(arrayOfObject[1]);
                    conditionTable.Building        = castToString(arrayOfObject[2]);
                    conditionTable.Storey          = castToString(arrayOfObject[3]);
                    conditionTable.Layer           = castToString(arrayOfObject[4]);
                    conditionTable.Location        = castToString(arrayOfObject[5]);
                    conditionTable.BimMaterial     = castToString(arrayOfObject[6]);
                    conditionTable.BimType         = castToString(arrayOfObject[7]);
                    conditionTable.DatabaseName    = castToString(arrayOfObject[8]);
                    conditionTable.Username        = castToString(arrayOfObject[9]);
                    conditionTable.Password        = castToString(arrayOfObject[10]);
                    conditionTable.Host            = castToString(arrayOfObject[11]);
                    conditionTable.BidNo           = (int?)arrayOfObject[12];
                    conditionTable.CndNo           = (int?)arrayOfObject[13];
                    conditionTable.CndId           = (int?)arrayOfObject[14];
                    conditionTable.GlobalId        = castToString(arrayOfObject[15]);
                    conditionTable.CndType         = castToString(arrayOfObject[16]);
                    conditionTable.TakeOffType     = castToString(arrayOfObject[17]);
                    conditionTable.Quantity2       = (decimal)arrayOfObject[18];
                    conditionTable.Quantity3       = (decimal)arrayOfObject[19];
                    conditionTable.QuantityF       = (decimal)arrayOfObject[20];
                    conditionTable.Quantity2Name   = castToString(arrayOfObject[21]);
                    conditionTable.Quantity3Name   = castToString(arrayOfObject[22]);
                    conditionTable.QuantityFName   = castToString(arrayOfObject[23]);
                    conditionTable.Unit2           = castToString(arrayOfObject[24]);
                    conditionTable.Unit3           = castToString(arrayOfObject[25]);
                    conditionTable.UnitF           = castToString(arrayOfObject[26]);
                    conditionTable.FormulaF        = castToString(arrayOfObject[27]);
                    conditionTable.Quantity1Name   = castToString(arrayOfObject[28]);
                    conditionTable.Unit1           = castToString(arrayOfObject[29]);
                    conditionTable.Quantity1       = (decimal)arrayOfObject[30];
                    conditionTable.PickType        = ConditionTable.PICK_ELEMENTS;
                    conditionTable.DefaultQuantity = Convert.ToInt32(1);
                    bigDecimal = bigDecimal + conditionTable.Quantity1;
                    if (!string.ReferenceEquals(str9, null))
                    {
                        conditionTable.Quantity1Name = str9;
                    }
                    arrayOfConditionTable[b2++] = conditionTable;
                }
            }
            catch (Exception exception)
            {
                Console.WriteLine(exception.ToString());
                Console.Write(exception.StackTrace);
                if (!@bool)
                {
                    projectDBUtil.closeSession();
                }
                throw new ExprException(exception.Message);
            }
            if (!@bool)
            {
                projectDBUtil.closeSession();
            }
            return(new ExprTakeoff(bigDecimal.doubleValue(), arrayOfConditionTable));
        }
示例#22
0
 public LocationCache(ProjectDBUtil prjDBUtil)
 {
 }
示例#23
0
//JAVA TO C# CONVERTER WARNING: Method 'throws' clauses are not available in C#:
//ORIGINAL LINE: public void projectClosing(nomitech.common.ui.UIProgress paramUIProgress, nomitech.common.ProjectDBUtil paramProjectDBUtil, boolean paramBoolean) throws Exception
        public virtual void projectClosing(UIProgress paramUIProgress, ProjectDBUtil paramProjectDBUtil, bool paramBoolean)
        {
        }
示例#24
0
//JAVA TO C# CONVERTER WARNING: Method 'throws' clauses are not available in C#:
//ORIGINAL LINE: public org.boris.expr.Expr evaluate(org.boris.expr.IEvaluationContext paramIEvaluationContext, org.boris.expr.Expr[] paramArrayOfExpr) throws org.boris.expr.ExprException
        public virtual Expr evaluate(IEvaluationContext paramIEvaluationContext, Expr[] paramArrayOfExpr)
        {
            assertMinArgCount(paramArrayOfExpr, 1);
            for (sbyte b = 0; b < paramArrayOfExpr.Length; b++)
            {
                if (paramArrayOfExpr[b] is org.boris.expr.ExprEvaluatable)
                {
                    paramArrayOfExpr[b] = evalArg(paramIEvaluationContext, paramArrayOfExpr[b]);
                }
            }
            if (!(paramArrayOfExpr[0] is ExprString))
            {
                throw new ExprException("Input " + paramArrayOfExpr[0].ToString() + " is not a String.");
            }
            string str = ((ExprString)paramArrayOfExpr[0]).str;
            bool   @bool;

            for (@bool = true; @bool < paramArrayOfExpr.Length; @bool++)
            {
                if (paramArrayOfExpr[@bool] is ExprVariable)
                {
                    paramArrayOfExpr[@bool] = paramIEvaluationContext.evaluateVariable((ExprVariable)paramArrayOfExpr[@bool]);
                }
                if (!(paramArrayOfExpr[@bool] is ExprString) && !(paramArrayOfExpr[@bool] is org.boris.expr.ExprNumber) && !(paramArrayOfExpr[@bool] is ExprBoolean))
                {
                    throw new ExprException("Invalid Parameter Value: " + paramArrayOfExpr[@bool]);
                }
            }
            @bool = true;
            Session       session       = null;
            ProjectDBUtil projectDBUtil = null;

            if (paramIEvaluationContext is ExprAbstractEvaluationContext)
            {
                session = ((ExprAbstractEvaluationContext)paramIEvaluationContext).ProjectDatabaseSession;
                if (session == null)
                {
                    projectDBUtil = ProjectDBUtil.currentProjectDBUtil();
                    if (projectDBUtil == null)
                    {
                        return(new DummyExprArray());
                    }
                    @bool   = projectDBUtil.hasOpenedSession();
                    session = projectDBUtil.currentSession();
                }
            }
            string[] arrayOfString = null;
            try
            {
                Query query = session.createQuery(str);
                query.Cacheable = true;
                for (sbyte b1 = 1; b1 < paramArrayOfExpr.Length; b1++)
                {
                    if (paramArrayOfExpr[b1] is ExprString)
                    {
                        query = query.setString(b1 - true, ((ExprString)paramArrayOfExpr[b1]).str);
                    }
                    else if (paramArrayOfExpr[b1] is ExprDouble)
                    {
                        query = query.setDouble(b1 - true, ((ExprDouble)paramArrayOfExpr[b1]).doubleValue());
                    }
                    else if (paramArrayOfExpr[b1] is ExprInteger)
                    {
                        query = query.setInteger(b1 - true, ((ExprInteger)paramArrayOfExpr[b1]).intValue());
                    }
                    else if (paramArrayOfExpr[b1] is ExprBoolean)
                    {
                        query = query.setBoolean(b1 - true, ((ExprBoolean)paramArrayOfExpr[b1]).booleanValue());
                    }
                }
                System.Collections.IList list = query.list();
                int i = 0;
                if (list.Count != 0)
                {
                    object @object = list[0];
                    if (@object is BaseEntity)
                    {
                        ClassMetadata classMetadata = ((SessionImplementor)session).Factory.getClassMetadata(@object.GetType());
                        arrayOfString = classMetadata.PropertyNames;
                        if (arrayOfString == null)
                        {
                            throw new Exception("Invalid class name: " + @object.GetType());
                        }
                        i = arrayOfString.Length;
                    }
                    else if (@object is object[])
                    {
                        i = (object[])@object.length;
                    }
                    else
                    {
                        i = 1;
                    }
                }
                ExprArray exprArray = new ExprArray(list.Count, i);
                sbyte     b2        = 0;
                foreach (object @object in list)
                {
                    if (@object is object[])
                    {
                        object[] arrayOfObject = (object[])@object;
                        for (sbyte b3 = 0; b3 < arrayOfObject.Length; b3++)
                        {
                            setArrayValue(exprArray, arrayOfObject[b3], b2, b3);
                        }
                    }
                    else if (@object is BaseEntity)
                    {
                        sbyte b3 = 0;
                        foreach (string str1 in arrayOfString)
                        {
                            object object1 = BlankResourceInitializer.getFieldValue((BaseEntity)@object, str1);
                            setArrayValue(exprArray, object1, b2, b3++);
                        }
                    }
                    else if (i == 1)
                    {
                        setArrayValue(exprArray, @object, b2, 0);
                    }
                    else
                    {
                        if (!@bool)
                        {
                            projectDBUtil.closeSession();
                        }
                        throw new ExprException("Not a persistent class: " + @object.GetType().Name);
                    }
                    b2++;
                }
                if (projectDBUtil != null && !@bool)
                {
                    projectDBUtil.closeSession();
                }
                return(exprArray);
            }
            catch (Exception exception)
            {
                Console.WriteLine(exception.ToString());
                Console.Write(exception.StackTrace);
                if (!@bool)
                {
                    projectDBUtil.closeSession();
                }
                throw new ExprException(exception.Message);
            }
        }
        public virtual BoqItemTable convertToBoqItem(DateTime projectStartDate, long?code, ProjectDBUtil currentDBUtil, bool online, bool useProductivity, bool replaceQuantity)
        {
            BoqItemTable boqTable = BlankResourceInitializer.createBlankBoqItem(this, code, projectStartDate, useProductivity);

            Timestamp updateTime = new Timestamp(DateTimeHelper.CurrentUnixTimeMillis());

            //if ( useProductivity ) {
            //	boqTable.setCalculationType(BoqItemTable.s_PRODUCTIVITY_METHOD);
            //}
            //else {
            //	boqTable.setCalculationType(BoqItemTable.s_TOTAL_UNITS_METHOD);
            //}
            //boqTable.setProductivity(BigDecimalMath.ONE);
            //boqTable.setQuantity(BigDecimalMath.ONE);
            //boqTable.setDuration(BigDecimalMath.ONE);

            boqTable.LastUpdate = updateTime;
            boqTable.CreateDate = updateTime;

            boqTable.BoqItemAssemblySet      = new HashSet <object>();
            boqTable.BoqItemEquipmentSet     = new HashSet <object>();
            boqTable.BoqItemSubcontractorSet = new HashSet <object>();
            boqTable.BoqItemLaborSet         = new HashSet <object>();
            boqTable.BoqItemMaterialSet      = new HashSet <object>();
            boqTable.BoqItemConsumableSet    = new HashSet <object>();
            boqTable.BoqItemConditionSet     = new HashSet <object>();

            ConditionTable        conditionTable    = (ConditionTable)convertToConditionTable();
            BoqItemConditionTable boqConditionTable = new BoqItemConditionTable();

            boqConditionTable.Factor1         = BigDecimalMath.ONE;
            boqConditionTable.Factor2         = BigDecimalMath.ONE;
            boqConditionTable.QuantityPerUnit = BigDecimalMath.ONE;
            boqConditionTable.Sumup           = BigDecimalMath.ZERO;

            if (replaceQuantity)
            {
                if (conditionTable.DefaultQuantity == null || conditionTable.DefaultQuantity == 0 || conditionTable.DefaultQuantity == 1)
                {
                    boqTable.Quantity = conditionTable.Quantity1;
                }
                else if (conditionTable.DefaultQuantity == 2)
                {
                    boqTable.Quantity = conditionTable.Quantity2;
                }
                else if (conditionTable.DefaultQuantity == 3)
                {
                    boqTable.Quantity = conditionTable.Quantity3;
                }
                else if (conditionTable.DefaultQuantity == 4)
                {
                    boqTable.Quantity = conditionTable.QuantityF;
                }
            }
            if (conditionTable.DefaultQuantity == null || conditionTable.DefaultQuantity == 0 || conditionTable.DefaultQuantity == 1)
            {
                boqConditionTable.SelectedUnit = BoqItemConditionTable.SELECTED_UNIT1;
                boqTable.Quantity         = conditionTable.Quantity1;
                boqTable.MeasuredQuantity = conditionTable.Quantity1;
                //boqTable.setEstimatedQuantity(conditionTable.getQuantity1());
                boqTable.Unit       = conditionTable.Unit1;
                boqTable.SecondUnit = Unit1ToUnit2Util.Instance.getUnit2(conditionTable.Unit1);
                boqTable.UnitsDiv   = Unit1ToUnit2Util.Instance.getUnitDiv(conditionTable.Unit1);
            }
            else if (conditionTable.DefaultQuantity == 2)
            {
                boqConditionTable.SelectedUnit = BoqItemConditionTable.SELECTED_UNIT2;
                boqTable.Quantity         = conditionTable.Quantity2;
                boqTable.MeasuredQuantity = conditionTable.Quantity2;
                //boqTable.setEstimatedQuantity(conditionTable.getQuantity2());
                boqTable.Unit       = conditionTable.Unit2;
                boqTable.SecondUnit = Unit1ToUnit2Util.Instance.getUnit2(conditionTable.Unit2);
                boqTable.UnitsDiv   = Unit1ToUnit2Util.Instance.getUnitDiv(conditionTable.Unit2);
            }
            else if (conditionTable.DefaultQuantity == 3)
            {
                boqConditionTable.SelectedUnit = BoqItemConditionTable.SELECTED_UNIT3;
                boqTable.Quantity = conditionTable.Quantity3;
                //boqTable.setEstimatedQuantity(conditionTable.getQuantity3());
                boqTable.MeasuredQuantity = conditionTable.Quantity3;
                boqTable.Unit             = conditionTable.Unit3;
                boqTable.SecondUnit       = Unit1ToUnit2Util.Instance.getUnit2(conditionTable.Unit3);
                boqTable.UnitsDiv         = Unit1ToUnit2Util.Instance.getUnitDiv(conditionTable.Unit3);
            }
            else if (conditionTable.DefaultQuantity == 4)
            {
                boqConditionTable.SelectedUnit = BoqItemConditionTable.SELECTED_UNITF;
                boqTable.Quantity = conditionTable.QuantityF;
                //boqTable.setEstimatedQuantity(conditionTable.getQuantity3());
                boqTable.MeasuredQuantity = conditionTable.QuantityF;
                boqTable.Unit             = conditionTable.UnitF;
                boqTable.SecondUnit       = Unit1ToUnit2Util.Instance.getUnit2(conditionTable.UnitF);
                boqTable.UnitsDiv         = Unit1ToUnit2Util.Instance.getUnitDiv(conditionTable.UnitF);
            }

            boqConditionTable.LastUpdate = updateTime;

            boqConditionTable.ConditionTable = conditionTable;
            boqConditionTable.BoqItemTable   = boqTable;

            boqTable.BoqItemConditionSet.Add(boqConditionTable);

            boqTable.recalculate();

            return(boqTable);
        }
示例#26
0
//JAVA TO C# CONVERTER WARNING: Method 'throws' clauses are not available in C#:
//ORIGINAL LINE: public static void mergeProjectsInOneDatabase(nomitech.common.ui.UIProgress paramUIProgress, String paramString1, String paramString2, String paramString3, nomitech.common.db.local.ProjectDbmsTable paramProjectDbmsTable, String paramString4, String paramString5, java.util.Set<String> paramSet, boolean paramBoolean1, boolean paramBoolean2) throws Exception
        public static void mergeProjectsInOneDatabase(UIProgress paramUIProgress, string paramString1, string paramString2, string paramString3, ProjectDbmsTable paramProjectDbmsTable, string paramString4, string paramString5, ISet <string> paramSet, bool paramBoolean1, bool paramBoolean2)
        {
            ProjectDBUtil.initDriver(ProjectDBUtil.SQLSERVER_DBMS);
            ProjectDBDataMover projectDBDataMover;

            (projectDBDataMover = new ProjectDBDataMover(paramUIProgress)).setProgress(paramUIProgress, "Connecting to master database " + paramString1 + " port " + paramString2 + "...");
            string     str         = ProjectDBUtil.createJdbcUrl(paramString1, paramString3, paramString2, ProjectDBUtil.SQLSERVER_DBMS);
            Connection connection1 = DriverManager.getConnection(str + ";useLOBs=false", paramString4, paramString5);

            connection1.AutoCommit = false;
            setProgress(paramUIProgress, "Connecting to project database " + paramString1 + " port " + paramString2 + "...");
            str = ProjectDBUtil.createJdbcUrl(paramProjectDbmsTable.HostName, paramProjectDbmsTable.DatabaseName, paramProjectDbmsTable.HostPort, ProjectDBUtil.SQLSERVER_DBMS);
            Connection connection2 = projectDBDataMover.loginDatabase(str + ";useLOBs=false", paramString4, paramString5);

            connection2.AutoCommit = false;
            setProgress(paramUIProgress, "Loading databases from master...");
            System.Collections.IList list            = projectDBDataMover.getAllProjectUrls(connection1, paramSet, false);
            ProjectUrlTable          projectUrlTable = new ProjectUrlTable();

            projectUrlTable.Dbms                = Convert.ToInt32(ProjectDBUtil.SQLSERVER_DBMS);
            projectUrlTable.DatabaseName        = paramProjectDbmsTable.DatabaseName;
            projectUrlTable.Hostname            = paramProjectDbmsTable.HostName;
            projectUrlTable.Port                = paramProjectDbmsTable.HostPort;
            projectUrlTable.DbmsName            = paramProjectDbmsTable.InstanceName;
            projectUrlTable.CreatesNewDatabases = Convert.ToBoolean(false);
            projectUrlTable.Username            = paramProjectDbmsTable.HostUsername;
            projectUrlTable.Password            = paramProjectDbmsTable.HostPassword;
            projectUrlTable.Url = str;
            setProgress(paramUIProgress, "Processing " + list.Count + " databases...");
            System.Collections.ICollection collection = projectDBDataMover.filterOutUrlsAlreadyInTarget(connection2, list);
            connection2.close();
            setProgress(paramUIProgress, "Target Database is " + projectUrlTable.DatabaseName + " and " + collection.Count + " will be processed...");
            foreach (ProjectUrlTable projectUrlTable1 in collection)
            {
                if (projectUrlTable1.DatabaseName.Equals(projectUrlTable.DatabaseName, StringComparison.OrdinalIgnoreCase))
                {
                    continue;
                }
                projectUrlTable.ProjectUrlId = projectUrlTable1.ProjectUrlId;
                setProgress(paramUIProgress, "\nMerging Database: " + projectUrlTable1.DatabaseName + ", Project ID: " + projectUrlTable1.Id + ", Name: " + projectUrlTable1.Name + " ...");
                try
                {
                    if (projectUrlTable1.Dbms == projectUrlTable.Dbms && projectUrlTable1.Hostname.Equals(projectUrlTable.Hostname))
                    {
                        projectDBDataMover.initialize(projectUrlTable1, projectUrlTable);
                        projectDBDataMover.moveDataSameInstance();
                    }
                    else
                    {
                        projectDBDataMover.initialize(projectUrlTable1, projectUrlTable);
                        projectDBDataMover.moveDataNotSameInstance();
                    }
                    projectDBDataMover.executeUpdateQuery(connection1, "UPDATE PROJECTURL SET DBSINGLE=0, DBNAME= '" + projectUrlTable.DatabaseName + "', DBSRV = " + projectUrlTable.Dbms + ", DBSRVNAME= '" + projectUrlTable.DbmsName + "', DBUSR= '******', DBPSWD= '" + projectUrlTable.Password + "', URL = '" + projectUrlTable.Url + "' WHERE PROJECTURLID=" + projectUrlTable.ProjectUrlId);
                    setProgress(paramUIProgress, "Done");
                }
                catch (Exception exception)
                {
                    Console.WriteLine("Could not merge " + projectUrlTable1.DatabaseName + " to " + projectUrlTable.DatabaseName);
                    Console.WriteLine(exception.ToString());
                    Console.Write(exception.StackTrace);
                }
                if (paramBoolean2 && projectUrlTable1.Dbms.Value == ProjectDBUtil.SQLSERVER_DBMS)
                {
                    try
                    {
                        setProgress(paramUIProgress, "Dropping " + projectUrlTable1.DatabaseName + " ...");
                        projectDBDataMover.executeUpdateQuery(connection1, "DROP DATABASE [" + projectUrlTable1.DatabaseName + "]");
                        setProgress(paramUIProgress, "Done");
                    }
                    catch (Exception)
                    {
                        Console.WriteLine("Could not drop " + projectUrlTable1.DatabaseName);
                    }
                }
            }
            connection1.close();
        }
示例#27
0
 public virtual IList <JComponent> getVisualizerToolBarButtons(ProjectDBUtil paramProjectDBUtil)
 {
     return(Collections.EMPTY_LIST);
 }
示例#28
0
//JAVA TO C# CONVERTER WARNING: Method 'throws' clauses are not available in C#:
//ORIGINAL LINE: public void projectCopying(nomitech.common.ui.UIProgress paramUIProgress, nomitech.common.ProjectDBUtil paramProjectDBUtil1, nomitech.common.ProjectDBUtil paramProjectDBUtil2) throws Exception
        public virtual void projectCopying(UIProgress paramUIProgress, ProjectDBUtil paramProjectDBUtil1, ProjectDBUtil paramProjectDBUtil2)
        {
        }
 public override object getProjectVariableValue(string paramString)
 {
     return(ProjectDBUtil.currentProjectDBUtil().ProjectVariableCache.ProjectVariableMap[paramString]);
 }
示例#30
0
 public virtual Component getVisualizerPanel(ProjectDBUtil paramProjectDBUtil)
 {
     return(null);
 }