コード例 #1
0
        public bool ZoneInProgram_Update(ZoneInProgram Zone)
        {
            var Result       = false;
            int rowsAffected = 0;

            Connector.GetProcedureResultInt32("config.ZoneInProgram_Update",
                                              new IDataParameter[] {
                Connector.CreateParameter("ProgramID", Zone.ProgramID),
                Connector.CreateParameter("FertQuant", Zone.FertQuant),
                Connector.CreateParameter("FertTime", Zone.FertTime),
                Connector.CreateParameter("OrderNumber", Zone.OrderNumber),
                Connector.CreateParameter("WaterAfter", Zone.WaterAfter),
                Connector.CreateParameter("WaterBefore", Zone.WaterBefore),
                Connector.CreateParameter("WaterQuantity", Zone.WaterQuantity),
                Connector.CreateParameter("WaterDuration", Zone.WaterDuration),
                Connector.CreateParameter("WaterPrecipitation_Duration", Zone.WaterPrecipitation_Duration),
                Connector.CreateParameter("WaterPrecipitation_Quantity", Zone.WaterPrecipitation_Quantity),
                Connector.CreateParameter("ZoneNumber", Zone.ZoneNumber)
            }
                                              ,
                                              out rowsAffected,
                                              out Result);

            return(Result);
        }
コード例 #2
0
 public ZoneInProgramView(ZoneInProgram z)
 {
     if (z == null)
     {
         return;
     }
     ZoneNumber             = z.ZoneNumber;
     OrderNumber            = z.OrderNumber;
     ID                     = z.ID;
     WaterQuantity          = z.WaterQuantity;
     FertQuant              = z.FertQuant;
     FertTime               = z.FertTime;
     WaterBefore            = z.WaterBefore;
     WaterAfter             = z.WaterAfter;
     WaterDuration          = z.WaterDuration;
     Precipitation_Duration = z.WaterPrecipitation_Duration;
     Precipitation_Quantity = z.WaterPrecipitation_Quantity;
 }
コード例 #3
0
        public int GetDurationTime(WaterMeter_FlowType?FlowTypeID, decimal?FlowValue, WaterMeter_PulseType PulseTypeID, WaterProgramType WaterUnitID, ZoneSetting zoneSetting, ZoneInProgram Zoneitem)
        {
            int WaterDuration_Seconds = 0;

            switch (WaterUnitID)
            {
            case WaterProgramType.Duration:
                WaterDuration_Seconds = Zoneitem.WaterDuration;
                break;

            case WaterProgramType.Quantity:
                WaterDuration_Seconds = ConvertQuantityToDuration(Zoneitem.WaterQuantity, FlowTypeID, FlowValue, PulseTypeID);
                break;

            case WaterProgramType.Quantity_Precipitation:
                var WaterQuantity = ConvertPrecipitationToQuantity(zoneSetting.IrrigrationArea, Zoneitem.WaterPrecipitation_Quantity);
                WaterDuration_Seconds = ConvertQuantityToDuration(WaterQuantity, FlowTypeID, FlowValue, PulseTypeID);
                break;

            case WaterProgramType.Duration_Precipitation:
                WaterDuration_Seconds = ConvertPrecipitationToDuration(zoneSetting.PrecipitationRate, Zoneitem.WaterPrecipitation_Duration);
                break;
            }

            return(WaterDuration_Seconds);
        }
コード例 #4
0
        public bool SaveSettings(string sN, long programID, ProgramSettingView setting)
        {
            var result = false;

            #region ProgramSetting

            var psetting = new ProgramSetting()
            {
                Name                  = setting.Name,
                WaterUnitID           = (byte)setting.ProgramType,
                ProgramID             = programID,
                ProgramNumber         = setting.ProgramNumber,
                Priority              = setting.Priority,
                IsFertilizerON        = setting.IsFertilizerON,
                StatusID              = (byte)setting.Status,
                FertUnitID            = (byte)setting.FertExecutionType,
                WaterFactor           = setting.WaterFactor,
                HoursExecutionsTypeID = (byte)setting.HoursExecution,
                DaysExecutionsTypeID  = (byte)setting.DaysExecutionType,
                FinalEndDateLimit     = setting.Advanced.FinalEndDateLimit.HasValue ? (DateTime?)TimeConvertor.GetDateTime(setting.Advanced.FinalEndDateLimit.Value) : null,
                FinalStartDateLimit   = setting.Advanced.FinalStartDateLimit.HasValue ? (DateTime?)TimeConvertor.GetDateTime(setting.Advanced.FinalStartDateLimit.Value) : null,
                FinalStartHoursLimit  = setting.Advanced.FinalStartHoursLimit,
                FinalStopHoursLimit   = setting.Advanced.FinalStopHoursLimit,
                HourlyCyclesPerDay    = setting.HourlyCycle.HourlyCyclesPerDay,
                HourlyCyclesStartTime = setting.HourlyCycle.HourlyCyclesStartTime,
                HourlyCyclesStopTime  = setting.HourlyCycle.HourlyCycleTime,
                HourlyCycleTime       = setting.HourlyCycle.HourlyCyclesStopTime
            };

            result = _AdminRepository.ProgramSetting_Update(psetting);

            if (!result)
            {
                return(result);
            }
            #endregion

            #region cyclicsetting

            var cyclicsetting = new CyclicDayProgram()
            {
                ProgramID    = programID,
                DaysInterval = setting.CyclicDayProgram.DaysInterval,
                StartDate    = TimeConvertor.GetDateTime(setting.CyclicDayProgram.StartDate)
            };

            result = _AdminRepository.CyclicDayProgram_Update(cyclicsetting);

            if (!result)
            {
                return(result);
            }
            #endregion

            #region ExecutionHours

            var ExecutionHours = setting.ExecutionHours.Select(e => new ExecutionHours {
                ExecTime = e
            }).ToArray();

            result = _AdminRepository.ExecutionHoursProgram_Update(programID, ExecutionHours);

            if (!result)
            {
                return(result);
            }

            #endregion

            #region WeeklyDaysProgram

            var w_days            = setting.WeeklyDaysProgram.Days;
            var WeeklyDaysProgram = new WeeklyProgramSetting()
            {
                ProgramID = programID,
                Sunday    = w_days[0].IsEnabled,
                Monday    = w_days[1].IsEnabled,
                Tuesday   = w_days[2].IsEnabled,
                Wednesday = w_days[3].IsEnabled,
                Thursday  = w_days[4].IsEnabled,
                Friday    = w_days[5].IsEnabled,
                Saturday  = w_days[6].IsEnabled
            };

            result = _AdminRepository.WeeklyProgramSetting_Update(WeeklyDaysProgram);

            if (!result)
            {
                return(result);
            }

            #endregion

            #region ZoneInProgram
            //GET All zone in program from DB
            var zone_dbList = _AdminRepository.ZonesInProgram_Get(programID).ToList();


            for (int i = 0; i < setting.ZoneInProgram.Length; i++)
            {
                var zone = setting.ZoneInProgram[i];
                zone_dbList.RemoveAll(s => s.ZoneNumber == zone.ZoneNumber);
                var zone_db = new ZoneInProgram()
                {
                    FertQuant     = zone.FertQuant,
                    FertTime      = zone.FertTime,
                    OrderNumber   = zone.OrderNumber,
                    ProgramID     = programID,
                    WaterAfter    = zone.WaterAfter,
                    WaterBefore   = zone.WaterBefore,
                    WaterDuration = zone.WaterDuration,
                    WaterPrecipitation_Duration = zone.Precipitation_Duration,
                    WaterPrecipitation_Quantity = zone.Precipitation_Quantity,
                    WaterQuantity = zone.WaterQuantity,
                    ZoneNumber    = zone.ZoneNumber
                };

                result = _AdminRepository.ZoneInProgram_Update(zone_db);
                if (!result)
                {
                    return(result);
                }
            }

            if (zone_dbList.Count > 0)
            {
                foreach (var item in zone_dbList)
                {
                    result = _AdminRepository.ZoneInProgram_Delete(item.ZoneNumber, programID);
                    if (!result)
                    {
                        return(result);
                    }
                }
            }

            #endregion

            return(true);
        }
コード例 #5
0
ファイル: DeviceTest.DAL.cs プロジェクト: relip83/WebGSI-Temp
        public void ProgramStory4_Test() //one program
                                         //Interval in day 2
                                         //StartTime at 7 am
                                         //Interval time 3Hour

        {
            var SN = "33560133-c6eb-4d66-a";

            if (string.IsNullOrEmpty(SN))
            {
                var device = CreateDevice();
                SN = device.SN;
            }

            var plist = Repository.DevicePrograms_Get(SN);

            Assert.IsTrue(plist != null && plist.Length > 0);
            // set only one to be active
            for (int i = 1; i < plist.Length; i++)
            {
                var p_fromList = plist[i];
                var ProgramID  = p_fromList.ProgramID;

                var program = Repository.ProgramSetting_Get(ProgramID);
                program.StatusID = 0;
                Assert.IsTrue(Repository.ProgramSetting_Update(program));
            }

            var Program = plist[0];

            Program.DaysExecutionsTypeID = 1;
            var CyclicDay = new CyclicDayProgram()
            {
                DaysInterval = 3,
                ProgramID    = Program.ProgramID,
                StartDate    = new DateTime(2016, 9, 18)
            };

            Repository.CyclicDayProgram_Update(CyclicDay);

            Program.HoursExecutionsTypeID = 1;
            Program.HourlyCyclesPerDay    = 2;
            Program.HourlyCyclesStartTime = 25200; //7 am
            Program.HourlyCycleTime       = 10800; //Interval time 3  Hour
            Repository.ProgramSetting_Update(Program);


            var list_zone = new List <ZoneInProgram>();

            for (int x = 0; x < 4; x++)
            {
                var zone = new ZoneInProgram()
                {
                    FertQuant     = 1.1m,
                    FertTime      = 12,
                    OrderNumber   = x,
                    ProgramID     = Program.ProgramID,
                    WaterAfter    = 3,
                    WaterBefore   = 5,
                    WaterDuration = 3600,
                    WaterPrecipitation_Duration = 4,
                    WaterPrecipitation_Quantity = 3,
                    WaterQuantity = 6,
                    ZoneNumber    = (byte)x,
                };
                list_zone.Add(zone);
                Assert.IsTrue(Repository.ZoneInProgram_Update(zone));
            }
        }
コード例 #6
0
ファイル: DeviceTest.DAL.cs プロジェクト: relip83/WebGSI-Temp
        public void ProgramStory3_Test() //one program
                                         //CyclicDay type every3 day,
                                         //2  exec time - one cross-midnight

        {
            var SN = "c32ad0de-9610-419c-8";

            if (string.IsNullOrEmpty(SN))
            {
                var device = CreateDevice();
                SN = device.SN;
            }

            var plist = Repository.DevicePrograms_Get(SN);

            Assert.IsTrue(plist != null && plist.Length > 0);
            // set only one to be active
            for (int i = 1; i < plist.Length; i++)
            {
                var p_fromList = plist[i];
                var ProgramID  = p_fromList.ProgramID;

                var program = Repository.ProgramSetting_Get(ProgramID);
                program.StatusID = 0;
                Assert.IsTrue(Repository.ProgramSetting_Update(program));
            }

            var Program = plist[0];

            Program.DaysExecutionsTypeID = 1;
            var CyclicDay = new CyclicDayProgram()
            {
                DaysInterval = 3,
                ProgramID    = Program.ProgramID,
                StartDate    = new DateTime(2016, 9, 18)
            };

            Repository.CyclicDayProgram_Update(CyclicDay);

            var ExecutionHours = new ExecutionHours[] {
                new ExecutionHours()
                {
                    ExecTime = 28800
                },                                                                                         //8 am
                new ExecutionHours()
                {
                    ExecTime = 82800
                }                                                                                          //11 pm 23:00
                                                                                                           //{ ExecTime = 64800 } 6 pm ,18:00
            };

            Assert.IsTrue(Repository.ExecutionHoursProgram_Update(Program.ProgramID, ExecutionHours));
            Repository.ProgramSetting_Update(Program);


            var list_zone = new List <ZoneInProgram>();

            for (int x = 0; x < 4; x++)
            {
                var zone = new ZoneInProgram()
                {
                    FertQuant     = 1.1m,
                    FertTime      = 12,
                    OrderNumber   = x,
                    ProgramID     = Program.ProgramID,
                    WaterAfter    = 3,
                    WaterBefore   = 5,
                    WaterDuration = 3600,
                    WaterPrecipitation_Duration = 4,
                    WaterPrecipitation_Quantity = 3,
                    WaterQuantity = 6,
                    ZoneNumber    = (byte)x,
                };
                list_zone.Add(zone);
                Assert.IsTrue(Repository.ZoneInProgram_Update(zone));
            }
        }
コード例 #7
0
ファイル: DeviceTest.DAL.cs プロジェクト: relip83/WebGSI-Temp
        public void ProgramStory2_Test() //one program
                                         //Weekly type ,
                                         //Interval in day 2
                                         //StartTime at 7 am
                                         //Interval time 3Hour

        {
            var SN = "ff852d37-cda7-4295-a";

            if (string.IsNullOrEmpty(SN))
            {
                var device = CreateDevice();
                SN = device.SN;
            }

            var plist = Repository.DevicePrograms_Get(SN);

            Assert.IsTrue(plist != null && plist.Length > 0);
            // set only one to be active
            for (int i = 1; i < plist.Length; i++)
            {
                var p_fromList = plist[i];
                var ProgramID  = p_fromList.ProgramID;

                var program = Repository.ProgramSetting_Get(ProgramID);
                program.StatusID = 0;
                Assert.IsTrue(Repository.ProgramSetting_Update(program));
            }

            var Program = plist[0];

            Program.DaysExecutionsTypeID  = 0;
            Program.HoursExecutionsTypeID = 1;
            Program.HourlyCyclesPerDay    = 2;
            Program.HourlyCyclesStartTime = 25200; //7 am
            Program.HourlyCycleTime       = 10800; //Interval time 3  Hour
            Repository.ProgramSetting_Update(Program);
            var WeeklyDaysProgram = new WeeklyProgramSetting()
            {
                ProgramID = Program.ProgramID
            };

            WeeklyDaysProgram.Sunday    = true;
            WeeklyDaysProgram.Monday    = false;
            WeeklyDaysProgram.Thursday  = true;
            WeeklyDaysProgram.Wednesday = false;
            WeeklyDaysProgram.Thursday  = true;
            WeeklyDaysProgram.Friday    = false;
            WeeklyDaysProgram.Saturday  = true;

            Assert.IsTrue(Repository.WeeklyProgramSetting_Update(WeeklyDaysProgram));

            var list_zone = new List <ZoneInProgram>();

            for (int x = 0; x < 4; x++)
            {
                var zone = new ZoneInProgram()
                {
                    FertQuant     = 1.1m,
                    FertTime      = 12,
                    OrderNumber   = x,
                    ProgramID     = Program.ProgramID,
                    WaterAfter    = 3,
                    WaterBefore   = 5,
                    WaterDuration = 3600,
                    WaterPrecipitation_Duration = 4,
                    WaterPrecipitation_Quantity = 3,
                    WaterQuantity = 6,
                    ZoneNumber    = (byte)x,
                };
                list_zone.Add(zone);
                Assert.IsTrue(Repository.ZoneInProgram_Update(zone));
            }
        }
コード例 #8
0
ファイル: DeviceTest.DAL.cs プロジェクト: relip83/WebGSI-Temp
        public void ProgramStory1_Test() //one program
                                         //Weekly type ,
                                         //2  exec time - one cross-midnight

        {
            var SN = "0da20764-60b2-4081-8";

            if (string.IsNullOrEmpty(SN))
            {
                var device = CreateDevice();
                SN = device.SN;
            }

            var plist = Repository.DevicePrograms_Get(SN);

            Assert.IsTrue(plist != null && plist.Length > 0);
            // set only one to be active
            for (int i = 1; i < plist.Length; i++)
            {
                var p_fromList = plist[i];
                var ProgramID  = p_fromList.ProgramID;

                var program = Repository.ProgramSetting_Get(ProgramID);
                program.StatusID = 0;
                Assert.IsTrue(Repository.ProgramSetting_Update(program));
            }

            var Program = plist[0];

            Program.DaysExecutionsTypeID = 0;

            Repository.ProgramSetting_Update(Program);
            var WeeklyDaysProgram = new WeeklyProgramSetting()
            {
                ProgramID = Program.ProgramID
            };

            WeeklyDaysProgram.Sunday    = true;
            WeeklyDaysProgram.Monday    = false;
            WeeklyDaysProgram.Thursday  = true;
            WeeklyDaysProgram.Wednesday = false;
            WeeklyDaysProgram.Thursday  = true;
            WeeklyDaysProgram.Friday    = false;
            WeeklyDaysProgram.Saturday  = true;

            Assert.IsTrue(Repository.WeeklyProgramSetting_Update(WeeklyDaysProgram));

            var ExecutionHours = new ExecutionHours[] {
                new ExecutionHours()
                {
                    ExecTime = 28800
                },                                                                                         //8 am
                new ExecutionHours()
                {
                    ExecTime = 82800
                }                                                                                          //11 pm 23:00
                                                                                                           //{ ExecTime = 64800 } 6 pm ,18:00
            };

            Assert.IsTrue(Repository.ExecutionHoursProgram_Update(Program.ProgramID, ExecutionHours));

            var list_zone = new List <ZoneInProgram>();

            for (int x = 0; x < 4; x++)
            {
                var zone = new ZoneInProgram()
                {
                    FertQuant     = 1.1m,
                    FertTime      = 12,
                    OrderNumber   = x,
                    ProgramID     = Program.ProgramID,
                    WaterAfter    = 3,
                    WaterBefore   = 5,
                    WaterDuration = 3600,
                    WaterPrecipitation_Duration = 4,
                    WaterPrecipitation_Quantity = 3,
                    WaterQuantity = 6,
                    ZoneNumber    = (byte)x,
                };
                list_zone.Add(zone);
                Assert.IsTrue(Repository.ZoneInProgram_Update(zone));
            }
        }
コード例 #9
0
ファイル: DeviceTest.DAL.cs プロジェクト: relip83/WebGSI-Temp
        public void Program_Test()
        {
            var SN = "0b257467-640b-47db-a";

            if (string.IsNullOrEmpty(SN))
            {
                var device = CreateDevice();
                SN = device.SN;
            }

            var plist = Repository.DevicePrograms_Get(SN);

            Assert.IsTrue(plist != null && plist.Length > 0);
            for (int i = 0; i < plist.Length; i++)
            {
                var p_fromList = plist[i];
                var ProgramID  = p_fromList.ProgramID;

                var program = Repository.ProgramSetting_Get(ProgramID);
                isProgramEqual(program, p_fromList);

                var now = DateTime.Now;
                var CyclicDayProgram = new CyclicDayProgram()
                {
                    ProgramID = ProgramID
                };
                var WeeklyDaysProgram = new WeeklyProgramSetting()
                {
                    ProgramID = ProgramID
                };


                for (int j = 0; j < 2; j++)
                {
                    #region setting

                    program.DaysExecutionsTypeID  = (byte)(i % 2 == 0 ? 0 : 1);
                    program.FinalEndDateLimit     = now.AddMonths(i);
                    program.FinalStartDateLimit   = now.AddMonths(-i);
                    program.FinalStartHoursLimit  = i % 2 == 0 ? 10 : 100;
                    program.FinalStopHoursLimit   = i % 2 == 0 ? 2 : 234;
                    program.HourlyCyclesPerDay    = (byte)(i % 2 == 0 ? 11 : 12);
                    program.HourlyCyclesStartTime = i % 2 == 0 ? 12 : 34;
                    program.HourlyCyclesStopTime  = i % 2 == 0 ? 34 : 345;
                    program.HourlyCycleTime       = i % 2 == 0 ? 34 : 67;
                    program.HoursExecutionsTypeID = (byte)(i % 2 == 0 ? 1 : 0);
                    program.IsFertilizerON        = i % 2 == 0;
                    program.Name        = "name _" + i.ToString();
                    program.Priority    = (byte)(i % 2 == 0 ? 17 : 0);
                    program.StatusID    = (byte)(i % 2 == 0 ? 1 : 0);
                    program.WaterFactor = (byte)(i % 2 == 0 ? 45 : 78);
                    program.WaterUnitID = (byte)(i % 2 == 0 ? 0 : 1);

                    Assert.IsTrue(Repository.ProgramSetting_Update(program));
                    var program_db = Repository.ProgramSetting_Get(ProgramID);

                    isProgramEqual(program, program_db);

                    #endregion

                    #region CyclicDayProgram

                    CyclicDayProgram.DaysInterval = (byte)(2);
                    CyclicDayProgram.StartDate    = now.AddDays(i);
                    Assert.IsTrue(Repository.CyclicDayProgram_Update(CyclicDayProgram));
                    var c_db = Repository.CyclicDayProgram_Get(ProgramID);
                    Assert.IsTrue(CyclicDayProgram.DaysInterval == c_db.DaysInterval);
                    Assert.IsTrue(EqualsDate(CyclicDayProgram.StartDate, c_db.StartDate));

                    #endregion

                    #region  WeeklyDaysProgram

                    WeeklyDaysProgram.Sunday    = (i % 2 == 0);
                    WeeklyDaysProgram.Monday    = !(i % 2 == 0);
                    WeeklyDaysProgram.Thursday  = (i % 2 == 0);
                    WeeklyDaysProgram.Wednesday = !(i % 2 == 0);
                    WeeklyDaysProgram.Thursday  = (i % 2 == 0);
                    WeeklyDaysProgram.Friday    = !(i % 2 == 0);
                    WeeklyDaysProgram.Saturday  = (i % 2 == 0);

                    Assert.IsTrue(Repository.WeeklyProgramSetting_Update(WeeklyDaysProgram));
                    var w_db = Repository.WeeklyProgramSetting_Get(ProgramID);
                    Assert.IsTrue(WeeklyDaysProgram.Sunday == w_db.Sunday);
                    Assert.IsTrue(WeeklyDaysProgram.Monday == w_db.Monday);
                    Assert.IsTrue(WeeklyDaysProgram.Tuesday == w_db.Tuesday);
                    Assert.IsTrue(WeeklyDaysProgram.Wednesday == w_db.Wednesday);
                    Assert.IsTrue(WeeklyDaysProgram.Thursday == w_db.Thursday);
                    Assert.IsTrue(WeeklyDaysProgram.Friday == w_db.Friday);
                    Assert.IsTrue(WeeklyDaysProgram.Saturday == w_db.Saturday);

                    #endregion

                    #region ExecutionHours

                    var ExecutionHours = new ExecutionHours[] {
                        new ExecutionHours()
                        {
                            ExecTime = i
                        },
                        new ExecutionHours()
                        {
                            ExecTime = 10800
                        },
                        new ExecutionHours()
                        {
                            ExecTime = 28800
                        },
                        new ExecutionHours()
                        {
                            ExecTime = 50400
                        }
                    };

                    Assert.IsTrue(Repository.ExecutionHoursProgram_Update(ProgramID, ExecutionHours));

                    var e_db = Repository.ExecutionHoursProgram_Get(ProgramID);
                    Assert.IsTrue(e_db.Length == ExecutionHours.Length);
                    foreach (var item_db in e_db)
                    {
                        var item = ExecutionHours.Where(e => e.ExecTime == item_db.ExecTime).FirstOrDefault();
                        Assert.IsTrue(item != null);
                    }

                    #endregion

                    #region ZoneInProgram
                    var list_zone = new List <ZoneInProgram>();

                    for (int x = 0; x < 4; x++)
                    {
                        var zone = new ZoneInProgram()
                        {
                            FertQuant     = (i % 2 == 0 ? 0.9m : 1.1m),
                            FertTime      = (i % 2 == 0 ? 11 : 12),
                            OrderNumber   = x,
                            ProgramID     = ProgramID,
                            WaterAfter    = (i % 2 == 0 ? 3 : 4),
                            WaterBefore   = (i % 2 == 0 ? 2 : 5),
                            WaterDuration = (i % 2 == 0 ? 23 : 34),
                            WaterPrecipitation_Duration = (i % 2 == 0 ? 3 : 4),
                            WaterPrecipitation_Quantity = (i % 2 == 0 ? 6 : 8),
                            WaterQuantity = (i % 2 == 0 ? 7 : 99),
                            ZoneNumber    = (byte)x,
                        };
                        list_zone.Add(zone);
                        Assert.IsTrue(Repository.ZoneInProgram_Update(zone));
                    }

                    var list_zone_db = Repository.ZonesInProgram_Get(ProgramID);

                    Assert.IsTrue(list_zone_db.Length == list_zone.Count);

                    foreach (var item_db in list_zone_db)
                    {
                        var item = list_zone.Where(s => s.ZoneNumber == item_db.ZoneNumber).FirstOrDefault();
                        Assert.IsTrue(item != null);
                        Assert.IsTrue(item.FertQuant == item_db.FertQuant);
                        Assert.IsTrue(item.FertTime == item_db.FertTime);
                        Assert.IsTrue(item.OrderNumber == item_db.OrderNumber);
                        Assert.IsTrue(item.WaterAfter == item_db.WaterAfter);
                        Assert.IsTrue(item.WaterBefore == item_db.WaterBefore);
                        Assert.IsTrue(item.WaterDuration == item_db.WaterDuration);
                        Assert.IsTrue(item.WaterPrecipitation_Duration == item_db.WaterPrecipitation_Duration);
                        Assert.IsTrue(item.WaterPrecipitation_Quantity == item_db.WaterPrecipitation_Quantity);
                        Assert.IsTrue(item.WaterQuantity == item_db.WaterQuantity);
                    }


                    #endregion
                }
            }
        }