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);
}
void Achieve() // 일정 수를 넘으면 포인트 획득하는걸로
{
if (a_time > 3600)
{
Tb.SetActive(true);
}
if (a_time > 7200)
{
Ts.SetActive(true);
}
if (a_time > 10800)
{
Tg.SetActive(true);
}
if (a_UsedItem > 50)
{
Ub.SetActive(true);
}
if (a_UsedItem > 150)
{
Us.SetActive(true);
}
if (a_UsedItem > 350)
{
Ug.SetActive(true);
}
if (a_Score > 1000)
{
Sb.SetActive(true);
}
if (a_Score > 3000)
{
Ss.SetActive(true);
}
if (a_Score > 5000)
{
Sg.SetActive(true);
}
}
