public DataTable get_sw_list() { webservice_helloworld.show_helloworld show_helloworld = new webservice_helloworld.show_helloworld(); string jsonStr = show_helloworld.getSwlbjk("1"); //反序列化 WaterClass waterClassObject = JLcms.Common.JsonHelper.FromJson <WaterClass>(jsonStr); DataTable dt_waterinfo = new DataTable(); dt_waterinfo.Columns.Add("name"); dt_waterinfo.Columns.Add("water_deep"); foreach (WaterData w in waterClassObject.data) { string name = w.DEPARTMENT; string water_deep = w.LASTWATERLEVEL; DataRow row = dt_waterinfo.NewRow(); row["name"] = name; row["water_deep"] = water_deep; dt_waterinfo.Rows.Add(row); } return(dt_waterinfo); }
public DataTable JsonToDataTable1() { WaterClass water = new WaterClass(); DataTable dt = new DataTable(); dt.Columns.Add("wx"); dt.Columns.Add("lastWaterLevel"); water = Newtonsoft.Json.JsonConvert.DeserializeObject <WaterClass>(JsonToDataTable2()); var water_info = new { id = "", WATERSTATIONNAME = "", WATERSTATIONX = "", WATERSTATIONY = "", TERSERIESNUMBER = "", XTYPE = "", ALARMTYPE = "", DEPARTMENT = "", LASTWATERLEVEL = "", TERVOLTAGE = "" }; // var anonArray = new[] { new { name = "apple", diam = 4 }, new { name = "grape", diam = 1 } }; var anonymous = new { count = 0, data = new[] { new { id = "", WATERSTATIONNAME = "", WATERSTATIONX = "", WATERSTATIONY = "", TERSERIESNUMBER = "", XTYPE = "", ALARMTYPE = "", DEPARTMENT = "", LASTWATERLEVEL = "", TERVOLTAGE = "" } }, success = false, message = "" }; //IEnumerator e = anonymous.data.GetEnumerator(); var o = Newtonsoft.Json.JsonConvert.DeserializeAnonymousType(JsonToDataTable2(), anonymous); string s = o.data[0].ALARMTYPE; foreach (WaterData w in water.data) { DataRow row = dt.NewRow(); row["wx"] = water.data[0].WATERSTATIONNAME; row["lastWaterLevel"] = water.data[0].DEPARTMENT; dt.Rows.Add(row); dt.AcceptChanges(); } foreach (var w in anonymous.data) { DataRow row = dt.NewRow(); row["wx"] = water.data[0].WATERSTATIONNAME; dt.Rows.Add(row); } JLcms.Common.JsonToDataTable jtd = new JLcms.Common.JsonToDataTable(); DataTable tempTbl = jtd.JsonFormatDataTable(JsonToDataTable2()); //WaterTestList testList = new WaterTestList(); //foreach (WaterData w in testList) //{ // //w.ALARMTYPE //} return(dt); }