Example #1
0
        public TallyMode GetSampleGroupTallyMode()
        {
            TallyMode mode = TallyMode.Unknown;

            if (base.DAL.GetRowCount("CountTree", "WHERE SampleGroup_CN = @p1", SampleGroup_CN) == 0)
            {
                return(TallyMode.None);
            }

            if (base.DAL.GetRowCount("CountTree",
                                     "WHERE SampleGroup_CN = @p1 AND ifnull(TreeDefaultValue_CN, 0) == 0",
                                     SampleGroup_CN) > 0)
            {
                mode = mode | TallyMode.BySampleGroup;
            }
            if (base.DAL.GetRowCount("CountTree",
                                     "WHERE SampleGroup_CN = @p1 AND TreeDefaultValue_CN NOT NULL AND TreeDefaultValue_CN > 0",
                                     this.SampleGroup_CN) > 0)
            {
                mode = mode | TallyMode.BySpecies;
            }
            if (base.DAL.GetRowCount("CountTree",
                                     "WHERE SampleGroup_CN = @p1 AND TreeCount > 0", this.SampleGroup_CN) > 0)
            {
                mode = mode | TallyMode.Locked;
            }

            return(mode);
        }
Example #2
0
        public TallyMode GetSampleGroupTallyMode()
        {
            TallyMode mode = TallyMode.Unknown;

            if (DAL.GetRowCount("CountTree", "WHERE SampleGroup_CN = @p1", SampleGroup_CN) == 0)
            {
                if (Stratum.Method == CruiseDAL.Schema.CruiseMethods.STR)
                {
                    return(TallyMode.BySampleGroup);
                }
                else if (CruiseDAL.Schema.CruiseMethods.THREE_P_METHODS.Contains(Stratum.Method))
                {
                    return(TallyMode.BySpecies);
                }

                return(TallyMode.None);
            }

            if (DAL.GetRowCount("CountTree",
                                "WHERE SampleGroup_CN = @p1 AND ifnull(TreeDefaultValue_CN, 0) == 0",
                                SampleGroup_CN) > 0)
            {
                mode = mode | TallyMode.BySampleGroup;
            }
            if (DAL.GetRowCount("CountTree",
                                "WHERE SampleGroup_CN = @p1 AND TreeDefaultValue_CN NOT NULL AND TreeDefaultValue_CN > 0",
                                this.SampleGroup_CN) > 0)
            {
                mode = mode | TallyMode.BySpecies;
            }
            //if (DAL.GetRowCount("CountTree",
            //    "WHERE SampleGroup_CN = ? AND TreeCount > 0", this.SampleGroup_CN) > 0)
            //{
            //    mode = mode | TallyMode.Locked;
            //}

            return(mode);
        }