public void SetValues(TreeFieldSetupDO obj) { if(obj == null) { return; } Field = obj.Field; FieldOrder = obj.FieldOrder; ColumnType = obj.ColumnType; Heading = obj.Heading; Width = obj.Width; Format = obj.Format; Behavior = obj.Behavior; }
protected List<TreeFieldSetupDO> GetSelectedTreeFieldsDefault(StratumDO stratum) { //select from TreeFieldSetupDefault where method = stratum.method List<TreeFieldSetupDefaultDO> treeFieldDefaults = this.Database.Read<TreeFieldSetupDefaultDO>("TreeFieldSetupDefault", "WHERE Method = ? ORDER BY FieldOrder", stratum.Method); List<TreeFieldSetupDO> treeFields = new List<TreeFieldSetupDO>(); foreach (TreeFieldSetupDefaultDO tfd in treeFieldDefaults) { TreeFieldSetupDO tfs = new TreeFieldSetupDO(); tfs.Stratum_CN = stratum.Stratum_CN; tfs.Field = tfd.Field; tfs.FieldOrder = tfd.FieldOrder; tfs.ColumnType = tfd.ColumnType; tfs.Heading = tfd.Heading; tfs.Width = tfd.Width; tfs.Format = tfd.Format; tfs.Behavior = tfd.Behavior; treeFields.Add(tfs); } return treeFields; }
public TreeFieldSetupDO(TreeFieldSetupDO obj) : this() { SetValues(obj); }
public void getTreeFieldSetup(DAL cDAL, DAL fsDAL, StratumStatsDO myStStats) { //select from TreeFieldSetupDefault where method = stratum.method List<TreeFieldSetupDefaultDO> treeFieldDefaults = new List<TreeFieldSetupDefaultDO>(cDAL.Read < TreeFieldSetupDefaultDO >("TreeFieldSetupDefault", "WHERE Method = ? ORDER BY FieldOrder", myStStats.Method)); foreach (TreeFieldSetupDefaultDO tfd in treeFieldDefaults) { TreeFieldSetupDO tfs = new TreeFieldSetupDO(); tfs.Stratum_CN = thisStrCN; tfs.Field = tfd.Field; tfs.FieldOrder = tfd.FieldOrder; tfs.ColumnType = tfd.ColumnType; tfs.Heading = tfd.Heading; tfs.Width = tfd.Width; tfs.Format = tfd.Format; tfs.Behavior = tfd.Behavior; treeFields.Add(tfs); } fsDAL.Save(treeFields); }
public IEnumerable<TreeFieldSetupDO> ReadTreeFields() { var fields = DAL.From<TreeFieldSetupDO>() .Join("CuttingUnitStratum", "USING (Stratum_CN)") .Where("CuttingUnit_CN = ?") .GroupBy("Field") .OrderBy("FieldOrder") .Query(CuttingUnit_CN).ToList(); if (fields.Count == 0) { fields.AddRange(Constants.DEFAULT_TREE_FIELDS); } //if unit has multiple tree strata //but stratum column is missing if (this.TreeStrata.Count > 1 && fields.FindIndex(x => x.Field == "Stratum") == -1) { //find the location of the tree number field int indexOfTreeNum = fields.FindIndex(x => x.Field == CruiseDAL.Schema.TREE.TREENUMBER); //if user doesn't have a tree number field, fall back to the last field index if (indexOfTreeNum == -1) { indexOfTreeNum = fields.Count - 1; }//last item index //add the stratum field to the filed list TreeFieldSetupDO tfs = new TreeFieldSetupDO() { Field = "Stratum", Heading = "St", Format = "[Code]" }; fields.Insert(indexOfTreeNum + 1, tfs); } return fields; }
public IEnumerable<TreeFieldSetupDO> GetSelectedTreeFieldsDefault() { //select from TreeFieldSetupDefault where method = stratum.method var treeFieldDefaults = this.DAL.From<TreeFieldSetupDefaultDO>() .Where("Method = ?") .OrderBy("FieldOrder") .Query(Method); foreach (var tfd in treeFieldDefaults) { var tfs = new TreeFieldSetupDO(); tfs.Stratum_CN = Stratum_CN; tfs.Field = tfd.Field; tfs.FieldOrder = tfd.FieldOrder; tfs.ColumnType = tfd.ColumnType; tfs.Heading = tfd.Heading; tfs.Width = tfd.Width; tfs.Format = tfd.Format; tfs.Behavior = tfd.Behavior; yield return tfs; } }
private void copyPopulations(DAL cDAL, DAL rDAL, DAL fsDAL, bool reconData, string[] stRecCode) { TreeDefaultValueDO currentTDV = new TreeDefaultValueDO(); List<StratumStatsDO> cdStratumStats = new List<StratumStatsDO>(cDAL.Read<StratumStatsDO>("StratumStats", "JOIN Stratum ON StratumStats.Stratum_CN = Stratum.Stratum_CN AND StratumStats.Method = Stratum.Method AND StratumStats.Used = 1 ORDER BY Stratum.Code", null)); List<PlotDO> myPlots = new List<PlotDO>(); List<TreeDO> myTree = new List<TreeDO>(); BindingList<TreeFieldSetupDO> treeFields = new BindingList<TreeFieldSetupDO>(); bool first; string method = ""; foreach (StratumStatsDO myStStats in cdStratumStats) { setRecData = false; first = true; // check if recon data is to be saved if (reconData) { string strCode = myStStats.Code; if (myStStats.Method == "PNT" || myStStats.Method == "PCM") method = "PNT"; else if (myStStats.Method == "FIX" || myStStats.Method == "FCM") method = "FIX"; foreach (string stRec in stRecCode) { if (stRec == strCode) { setRecData = true; myPlots = (rDAL.Read<PlotDO>("Plot", "JOIN Stratum ON Plot.Stratum_CN = Stratum.Stratum_CN WHERE Stratum.Method = ?", method)); if(myTree.Count == 0) myTree = (rDAL.Read<TreeDO>("Tree", null, null)); } } } // get fsDAl stratum record List<SampleGroupStatsDO> mySgStats = new List<SampleGroupStatsDO>(cDAL.Read<SampleGroupStatsDO>("SampleGroupStats", "Where StratumStats_CN = ?", myStStats.StratumStats_CN)); // loop through sample groups foreach (SampleGroupStatsDO sgStats in mySgStats) { SampleGroupDO fsSg = new SampleGroupDO(fsDAL); // save sample group information fsSg.Stratum_CN = sgStats.StratumStats.Stratum_CN; fsSg.Code = sgStats.Code; fsSg.Description = sgStats.Description; fsSg.CutLeave = sgStats.CutLeave; fsSg.UOM = sgStats.UOM; fsSg.PrimaryProduct = sgStats.PrimaryProduct; fsSg.SecondaryProduct = sgStats.SecondaryProduct; fsSg.DefaultLiveDead = sgStats.DefaultLiveDead; fsSg.KZ = sgStats.KZ; fsSg.InsuranceFrequency = sgStats.InsuranceFrequency; if (myStStats.Method == "PCM" || myStStats.Method == "FCM") { if (checkBoxFreq.Checked) { fsSg.SamplingFrequency = sgStats.SamplingFrequency; fsSg.BigBAF = 0; } else { fsSg.SamplingFrequency = 0; fsSg.BigBAF = Convert.ToInt32(sgStats.BigBAF); } } else { fsSg.SamplingFrequency = sgStats.SamplingFrequency; fsSg.BigBAF = Convert.ToInt32(sgStats.BigBAF); } // find treedefaultvalues sgStats.TreeDefaultValueStats.Populate(); foreach (TreeDefaultValueDO tdv in sgStats.TreeDefaultValueStats) { fsSg.TreeDefaultValues.Add(tdv); } fsSg.Save(); fsSg.TreeDefaultValues.Save(); // if recon can be saved if (setRecData) { getReconData(myStStats, sgStats, rDAL, fsDAL, myPlots, myTree, fsSg.SampleGroup_CN, first); // get plot data first = false; // get tree data // get log data } } //select from TreeFieldSetupDefault where method = stratum.method List<TreeFieldSetupDefaultDO> treeFieldDefaults = new List<TreeFieldSetupDefaultDO>(cDAL.Read < TreeFieldSetupDefaultDO >("TreeFieldSetupDefault", "WHERE Method = ? ORDER BY FieldOrder", myStStats.Method)); foreach (TreeFieldSetupDefaultDO tfd in treeFieldDefaults) { TreeFieldSetupDO tfs = new TreeFieldSetupDO(); tfs.Stratum_CN = myStStats.Stratum_CN; tfs.Field = tfd.Field; tfs.FieldOrder = tfd.FieldOrder; tfs.ColumnType = tfd.ColumnType; tfs.Heading = tfd.Heading; tfs.Width = tfd.Width; tfs.Format = tfd.Format; tfs.Behavior = tfd.Behavior; treeFields.Add(tfs); } } fsDAL.Save(treeFields); }