コード例 #1
0
        public static FeedFormula DeSerialize(string str)
        {
            StringReader  reader     = new StringReader(str);
            XmlSerializer serializer = new XmlSerializer(typeof(FeedFormula));
            FeedFormula   obj        = (FeedFormula)serializer.Deserialize(reader);

            return(obj);
        }
コード例 #2
0
        public static string Serialize(FeedFormula feedFormula)
        {
            XmlSerializer xmlSerializer = new XmlSerializer(typeof(FeedFormula));
            StringWriter  textWriter    = new StringWriter();

            xmlSerializer.Serialize(textWriter, feedFormula);
            return(textWriter.ToString());
        }
コード例 #3
0
        public static FeedFormula[] getFeedFormula()
        {
            DataRowCollection dataRowCollection = Database.getRows("Select * From tableFeedFormula ORDER BY ID ASC");

            FeedFormula[] fList = new FeedFormula[dataRowCollection.Count];
            for (int i = 0; i < fList.Length; i++)
            {
                FeedFormula f = FeedFormula.Create(dataRowCollection[i]);
                fList[i] = f;
            }

            return(fList);
        }
コード例 #4
0
 public static FeedFormula getFeedFormula(String name)
 {
     return(FeedFormula.Create(Database.getRows("Select * From tableFeedFormula WHERE FormulaName='" + name + "'")[0]));
 }
コード例 #5
0
 public static FeedFormula getFeedFormula(int index)
 {
     return(FeedFormula.Create(Database.getRows(string.Format("Select * From tableFeedFormula WHERE ID={0}", index))[0]));
 }
コード例 #6
0
        public static FeedFormula Create(DataRow dataRow)
        {
            FeedFormula ff = new FeedFormula();

            ff.FormulaName   = dataRow.Field <string>("FormulaName");
            ff.DM_Min        = dataRow.Field <double>("DM_Min");
            ff.DM_Max        = dataRow.Field <double>("DM_Max");
            ff.CP_Min        = dataRow.Field <double>("CP_Min");
            ff.CP_Max        = dataRow.Field <double>("CP_Max");
            ff.RUP_Min       = dataRow.Field <double>("RUP_Min");
            ff.RUP_Max       = dataRow.Field <double>("RUP_Max");
            ff.CF_Min        = dataRow.Field <double>("CF_Min");
            ff.CF_Max        = dataRow.Field <double>("CF_Max");
            ff.EE_Min        = dataRow.Field <double>("EE_Min");
            ff.EE_Max        = dataRow.Field <double>("EE_Max");
            ff.ADF_Min       = dataRow.Field <double>("ADF_Min");
            ff.ADF_Max       = dataRow.Field <double>("ADF_Max");
            ff.NDF_Min       = dataRow.Field <double>("NDF_Min");
            ff.NDF_Max       = dataRow.Field <double>("NDF_Max");
            ff.NDF_Min       = dataRow.Field <double>("eNDF_Min");
            ff.NDF_Max       = dataRow.Field <double>("eNDF_Max");
            ff.TDNCattle_Min = dataRow.Field <double>("TDNCattle_Min");
            ff.TDNCattle_Max = dataRow.Field <double>("TDNCattle_Max");
            ff.TDNSheep_Min  = dataRow.Field <double>("TDNSheep_Min");
            ff.TDNSheep_Max  = dataRow.Field <double>("TDNSheep_Max");
            ff.DESheep_Min   = dataRow.Field <double>("DESheep_Min");
            ff.DESheep_Max   = dataRow.Field <double>("DESheep_Max");
            ff.MECattle_Min  = dataRow.Field <double>("MECattle_Min");
            ff.MECattle_Max  = dataRow.Field <double>("MECattle_Max");
            ff.MESheep_Min   = dataRow.Field <double>("MESheep_Min");
            ff.MESheep_Max   = dataRow.Field <double>("MESheep_Max");
            ff.NEmCattle_Min = dataRow.Field <double>("NEmCattle_Min");
            ff.NEmCattle_Max = dataRow.Field <double>("NEmCattle_Max");
            ff.NEgCattle_Min = dataRow.Field <double>("NEgCattle_Min");
            ff.NEgCattle_Max = dataRow.Field <double>("NEgCattle_Max");
            ff.NElCattle_Min = dataRow.Field <double>("NElCattle_Min");
            ff.NElCattle_Max = dataRow.Field <double>("NElCattle_Max");
            ff.MEPoultry_Min = dataRow.Field <double>("MEPoultry_Min");
            ff.MEPoultry_Max = dataRow.Field <double>("MEPoultry_Max");
            ff.DEHorse_Min   = dataRow.Field <double>("DEHorse_Min");
            ff.DEHorse_Max   = dataRow.Field <double>("DEHorse_Max");
            ff.DEPig_Min     = dataRow.Field <double>("DEPig_Min");
            ff.DEPig_Max     = dataRow.Field <double>("DEPig_Max");
            ff.MEPig_Min     = dataRow.Field <double>("MEPig_Min");
            ff.MEPig_Max     = dataRow.Field <double>("MEPig_Max");
            ff.Arg_Min       = dataRow.Field <double>("Arg_Min");
            ff.Arg_Max       = dataRow.Field <double>("Arg_Max");
            ff.His_Min       = dataRow.Field <double>("His_Min");
            ff.His_Max       = dataRow.Field <double>("His_Max");
            ff.Iso_L_Min     = dataRow.Field <double>("Iso_L_Min");
            ff.Iso_L_Max     = dataRow.Field <double>("Iso_L_Max");
            ff.Leu_Min       = dataRow.Field <double>("Leu_Min");
            ff.Leu_Max       = dataRow.Field <double>("Leu_Max");
            ff.Lys_Min       = dataRow.Field <double>("Lys_Min");
            ff.Lys_Max       = dataRow.Field <double>("Lys_Max");
            ff.Met_Min       = dataRow.Field <double>("Met_Min");
            ff.Met_Max       = dataRow.Field <double>("Met_Max");
            ff.Cys_Min       = dataRow.Field <double>("Cys_Min");
            ff.Cys_Max       = dataRow.Field <double>("Cys_Max");
            ff.Phe_Min       = dataRow.Field <double>("Phe_Min");
            ff.Phe_Max       = dataRow.Field <double>("Phe_Max");
            ff.Tyr_Min       = dataRow.Field <double>("Tyr_Min");
            ff.Tyr_Max       = dataRow.Field <double>("Tyr_Max");
            ff.Thr_Min       = dataRow.Field <double>("Thr_Min");
            ff.Thr_Max       = dataRow.Field <double>("Thr_Max");
            ff.Trp_Min       = dataRow.Field <double>("Trp_Min");
            ff.Trp_Max       = dataRow.Field <double>("Trp_Max");
            ff.Val_Min       = dataRow.Field <double>("Val_Min");
            ff.Val_Max       = dataRow.Field <double>("Val_Max");
            ff.Gly_Min       = dataRow.Field <double>("Gly_Min");
            ff.Gly_Max       = dataRow.Field <double>("Gly_Max");
            ff.Ser_Min       = dataRow.Field <double>("Ser_Min");
            ff.Ser_Max       = dataRow.Field <double>("Ser_Max");
            ff.Ca_Min        = dataRow.Field <double>("Ca_Min");
            ff.Ca_Max        = dataRow.Field <double>("Ca_Max");
            ff.Cl_Min        = dataRow.Field <double>("Cl_Min");
            ff.Cl_Max        = dataRow.Field <double>("Cl_Max");
            ff.Mg_Min        = dataRow.Field <double>("Mg_Min");
            ff.Mg_Max        = dataRow.Field <double>("Mg_Max");
            ff.P_Min         = dataRow.Field <double>("P_Min");
            ff.P_Max         = dataRow.Field <double>("P_Max");
            ff.K_Min         = dataRow.Field <double>("K_Min");
            ff.K_Max         = dataRow.Field <double>("K_Max");
            ff.Na_Min        = dataRow.Field <double>("Na_Min");
            ff.Na_Max        = dataRow.Field <double>("Na_Max");
            ff.S_Min         = dataRow.Field <double>("S_Min");
            ff.S_Max         = dataRow.Field <double>("S_Max");
            ff.Co_Min        = dataRow.Field <double>("Co_Min");
            ff.Co_Max        = dataRow.Field <double>("Co_Max");
            ff.Cu_Min        = dataRow.Field <double>("Cu_Min");
            ff.Cu_Max        = dataRow.Field <double>("Cu_Max");
            ff.I_Min         = dataRow.Field <double>("I_Min");
            ff.I_Max         = dataRow.Field <double>("I_Max");
            ff.Fe_Min        = dataRow.Field <double>("Fe_Min");
            ff.Fe_Max        = dataRow.Field <double>("Fe_Max");
            ff.Mn_Min        = dataRow.Field <double>("Mn_Min");
            ff.Mn_Max        = dataRow.Field <double>("Mn_Max");
            ff.Se_Min        = dataRow.Field <double>("Se_Min");
            ff.Se_Max        = dataRow.Field <double>("Se_Max");
            ff.Zn_Min        = dataRow.Field <double>("Zn_Min");
            ff.Zn_Max        = dataRow.Field <double>("Zn_Max");
            ff.VitA_Min      = dataRow.Field <double>("VitA_Min");
            ff.VitA_Max      = dataRow.Field <double>("VitA_Max");
            ff.VitD_Min      = dataRow.Field <double>("VitD_Min");
            ff.VitD_Max      = dataRow.Field <double>("VitD_Max");
            ff.VitE_Min      = dataRow.Field <double>("VitE_Min");
            ff.VitE_Max      = dataRow.Field <double>("VitE_Max");
            ff.VitK_Min      = dataRow.Field <double>("VitK_Min");
            ff.VitK_Max      = dataRow.Field <double>("VitK_Max");
            ff.Biotin_Min    = dataRow.Field <double>("Biotin_Min");
            ff.Biotin_Max    = dataRow.Field <double>("Biotin_Max");
            ff.Choline_Min   = dataRow.Field <double>("Choline_Min");
            ff.Choline_Max   = dataRow.Field <double>("Choline_Max");
            ff.Folic_Min     = dataRow.Field <double>("Folic_Min");
            ff.Folic_Max     = dataRow.Field <double>("Folic_Max");
            ff.Niacin_Min    = dataRow.Field <double>("Niacin_Min");
            ff.Niacin_Max    = dataRow.Field <double>("Niacin_Max");
            ff.Pantot_Min    = dataRow.Field <double>("Pantot_Min");
            ff.Pantot_Max    = dataRow.Field <double>("Pantot_Max");
            ff.VitB2_Min     = dataRow.Field <double>("VitB2_Min");
            ff.VitB2_Max     = dataRow.Field <double>("VitB2_Max");
            ff.VitB1_Min     = dataRow.Field <double>("VitB1_Min");
            ff.VitB1_Max     = dataRow.Field <double>("VitB1_Max");
            ff.VitB6_Min     = dataRow.Field <double>("VitB6_Min");
            ff.VitB6_Max     = dataRow.Field <double>("VitB6_Max");
            ff.VitB12_Min    = dataRow.Field <double>("VitB12_Min");
            ff.VitB12_Max    = dataRow.Field <double>("VitB12_Max");
            ff.Category      = dataRow.Field <string>("Category");
            ff.ID            = dataRow.Field <int>("ID");
            return(ff);
        }