public static List <PlotDO> ReadyByUnitStratum(Datastore 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 = @p1") .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 = @p1") .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 = @p1 AND Stratum.Code = @p2") .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); }
public static int DeleteStratum(Datastore dal, StratumDO stratum) { // check tree table for data if (dal.GetRowCount("Tree", "WHERE Stratum_CN = @p1", stratum.Stratum_CN) > 0) { return(-1); } // check plot table for data if (dal.GetRowCount("Plot", "WHERE Stratum_CN = @p1", stratum.Stratum_CN) > 0) { return(-1); } // Check Count table for each sample group if (dal.GetRowCount("CountTree", "JOIN SampleGroup ON CountTree.SampleGroup_CN = SampleGroup.SampleGroup_CN WHERE SampleGroup.Stratum_CN = @p1 AND CountTree.TreeCount > 0", stratum.Stratum_CN) > 0) { return(-1); } //Delete sample groups for stratum List <SampleGroupDO> allSGInStratum = dal.From <SampleGroupDO>() .Where("Stratum_CN = @p1") .Read(stratum.Stratum_CN).ToList(); //.Read<SampleGroupDO>("WHERE Stratum_CN = ?", stratum.Stratum_CN); foreach (SampleGroupDO Sg in allSGInStratum) { //Delete Count Records for stratum List <CountTreeDO> allCountInSG = dal.From <CountTreeDO>() .Where("SampleGroup_CN = @p1") .Read(Sg.SampleGroup_CN).ToList(); //.Read<CountTreeDO>("WHERE SampleGroup_CN = ?", Sg.SampleGroup_CN); foreach (CountTreeDO Cnt in allCountInSG) { Cnt.Delete(); } Sg.Delete(); } //Delete stratum stats for stratum List <StratumStatsDO> allStratumStatsInStratum = dal.From <StratumStatsDO>() .Where("Stratum_CN = @p1") .Read(stratum.Stratum_CN) .ToList(); //.Read<StratumStatsDO>( //"WHERE Stratum_CN = ?", stratum.Stratum_CN); foreach (StratumStatsDO StratumStats in allStratumStatsInStratum) { StratumStats.DeleteStratumStats(dal, StratumStats.StratumStats_CN); } stratum.Delete(); return(0); }
public int DeleteSampleGroup(Datastore dal, long?SampleGroup_CN) { // check tree table for data if (dal.GetRowCount("Tree", "WHERE SampleGroup_CN = @p1", SampleGroup_CN) > 0) { return(-1); } // Check Count table for each sample group if (dal.GetRowCount("CountTree", "WHERE SampleGroup_CN = @p1 AND TreeCount > 0", SampleGroup_CN) > 0) { return(-1); } //Delete Count Records for stratum var allCountInSg = dal.From <CountTreeDO>() .Where("SampleGroup_CN = @p1") .Read(SampleGroup_CN).ToList(); foreach (CountTreeDO Cnt in allCountInSg) { Cnt.Delete(); } Delete(); return(0); }
public static void CleanupErrorLog(Datastore db) { foreach (var el in db.From <ErrorLog>().Where("CN_Number != 0").Query()) { if (db.GetRowCount(el.TableName, "WHERE rowID = @p1", el.CN_Number) == 0) { db.Delete(el); } } }
public static List <StratumDO> ReadByUnitCode(Datastore dal, String code) { if (dal == null) { return(null); } return(dal.From <StratumDO>() .Join("CuttingUnitStratum", "USING (Stratum_CN)") .Join("CuttingUnit", "USING (CuttingUnit_CN)") .Where("CuttingUnit.Code = @p1") .Read(code).ToList()); }
public static List <CuttingUnitDO> ReadByStratumCode(Datastore dal, String code) { if (dal == null) { return(null); } return(dal.From <CuttingUnitDO>() .Join("CuttingUnitStratum", "USING (CuttingUnit_CN)") .Join("Stratum", "Using (Stratum_CN)") .Where("Stratum.Code = @p1") .Read(code).ToList()); //.Read<CuttingUnitDO>("JOIN CuttingUnitStratum JOIN Stratum WHERE CuttingUnit.CuttingUnit_CN = CuttingUnitStratum.CuttingUnit_CN AND CuttingUnitStratum.Stratum_CN = Stratum.Stratum_CN AND Stratum.Code = ?;", (object)code); }
public int DeleteStratumStats(Datastore dal, long?StratumStats_CN) { //Delete sample group stats for stratum var allSGStatsInStratumStats = dal.From <SampleGroupStatsDO>() .Where("StratumStats_CN = @p1") .Read(StratumStats_CN).ToList(); foreach (SampleGroupStatsDO SgStats in allSGStatsInStratumStats) { SgStats.Delete(); } Delete(); return(0); }