public static List<PlotDO> ReadyByUnitStratum(DatastoreRedux dal, String unit, String stratum) { if (dal == null) { return null; } if (String.IsNullOrEmpty(unit)) { return dal.From<PlotDO>() .Join("Stratum", "USING (Stratum_CN)") .Where("Stratum.Code = ?") .Read(stratum).ToList(); //.Read<PlotDO>("JOIN Stratum WHERE Plot.Stratum_CN = Stratum.Stratum_CN AND Stratum.Code = ?;", (object)stratum); } else if (String.IsNullOrEmpty(stratum)) { return dal.From<PlotDO>() .Join("CuttingUnit", "USING (CuttingUnit_CN)") .Where("CuttingUnit.Code = ?") .Read(unit).ToList(); //.Read<PlotDO>("JOIN CuttingUnit WHERE Plot.CuttingUnit_CN = CuttingUnit.CuttingUnit_CN AND CuttingUnit.Code = ?;", (object)unit); } return dal.From<PlotDO>() .Join("CuttingUnit", "USING (CuttingUnit_CN)") .Join("Stratum", "USING (Stratum_CN)") .Where("CuttingUnit.Code = ? AND Stratum.Code = ?") .Read(unit, stratum).ToList(); //.Read<PlotDO>("JOIN CuttingUnit JOIN Stratum WHERE Plot.CuttingUnit_CN = CuttingUnit.CuttingUnit_CN AND CuttingUnit.Code = ? AND Plot.Stratum_CN = Stratum.Stratum_CN AND Stratum.Code = ?;", (object)unit, stratum); }
protected override void OnDALChanged(DatastoreRedux newDAL) { base.OnDALChanged(newDAL); if (_treeAuditValueCollection != null) { _treeAuditValueCollection.DAL = newDAL; } }
protected override void OnDALChanged(DatastoreRedux newDAL) { base.OnDALChanged(newDAL); if (_TreeDefaultValueStats != null) { _TreeDefaultValueStats.DAL = newDAL; } }
public int DeleteStratumStats(DatastoreRedux dal, long? StratumStats_CN) { //Delete sample group stats for stratum var allSGStatsInStratumStats = dal.From<SampleGroupStatsDO>() .Where("StratumStats_CN = ?") .Read(StratumStats_CN).ToList(); foreach (SampleGroupStatsDO SgStats in allSGStatsInStratumStats) { SgStats.Delete(); } Delete(); return (0); }
public CuttingUnitStratumDO(DatastoreRedux DAL) : base(DAL) {}
public TreeCalculatedValuesDO(DatastoreRedux DAL) : base(DAL) {}
public QualityAdjEquationDO(DatastoreRedux DAL) : base(DAL) {}
public BiomassEquationDO(DatastoreRedux DAL) : base(DAL) {}
public VolumeEquationDO(DatastoreRedux DAL) : base(DAL) {}
public FixCNTTallyPopulationDO(DatastoreRedux DAL) : base(DAL) {}
public MessageLogDO(DatastoreRedux DAL) : base(DAL) {}
public ErrorLogDO(DatastoreRedux DAL) : base(DAL) {}
public ForestsDO(DatastoreRedux DAL) : base(DAL) {}
public RegionsDO(DatastoreRedux DAL) : base(DAL) {}
public UOMCodesDO(DatastoreRedux DAL) : base(DAL) {}
public TreeEstimateDO(DatastoreRedux DAL) : base(DAL) {}
public FixCNTTallyClassDO(DatastoreRedux DAL) : base(DAL) {}
public GlobalsDO(DatastoreRedux DAL) : base(DAL) {}
public SaleDO(DatastoreRedux DAL) : base(DAL) {}
public ComponentDO(DatastoreRedux DAL) : base(DAL) {}
public StratumDO(DatastoreRedux DAL) : base(DAL) {}
public TreeDefaultValueDO(DatastoreRedux DAL) : base(DAL) {}
public ValueEquationDO(DatastoreRedux DAL) : base(DAL) {}
public SampleGroupTreeDefaultValueDO(DatastoreRedux DAL) : base(DAL) {}
public ReportsDO(DatastoreRedux DAL) : base(DAL) {}
public PlotDO(DatastoreRedux DAL) : base(DAL) {}
public LCDDO(DatastoreRedux DAL) : base(DAL) {}
public CountTreeDO(DatastoreRedux DAL) : base(DAL) {}
public PRODO(DatastoreRedux DAL) : base(DAL) {}
public TallyDO(DatastoreRedux DAL) : base(DAL) {}