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);
}
