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); }
public static string Serialize(FeedFormula feedFormula) { XmlSerializer xmlSerializer = new XmlSerializer(typeof(FeedFormula)); StringWriter textWriter = new StringWriter(); xmlSerializer.Serialize(textWriter, feedFormula); return(textWriter.ToString()); }
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); }
public static FeedFormula getFeedFormula(String name) { return(FeedFormula.Create(Database.getRows("Select * From tableFeedFormula WHERE FormulaName='" + name + "'")[0])); }
public static FeedFormula getFeedFormula(int index) { return(FeedFormula.Create(Database.getRows(string.Format("Select * From tableFeedFormula WHERE ID={0}", index))[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); }