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); }
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); }