public string GetTdj()
{
DataSet ds = bll.GetAllDJtdjDS(PublicModels.XmGuid);
DataTable dt = ds.Tables[0];
DataTable dt_XM = new DataTable("XM");
dt_XM.Columns.Add("IDDJtdj", System.Type.GetType("System.String"));
dt_XM.Columns.Add("XM_MC", System.Type.GetType("System.String"));
dt_XM.Columns.Add("Rzsj", System.Type.GetType("System.String"));
dt_XM.Columns.Add("Pzh", System.Type.GetType("System.String"));
dt_XM.Columns.Add("Rzkm", System.Type.GetType("System.String"));
dt_XM.Columns.Add("RzkmD", System.Type.GetType("System.String"));
dt_XM.Columns.Add("Zy", System.Type.GetType("System.String"));
dt_XM.Columns.Add("Yxpzje", System.Type.GetType("System.String"));
dt_XM.Columns.Add("Ftbl", System.Type.GetType("System.String"));
dt_XM.Columns.Add("Pzje", System.Type.GetType("System.String"));
dt_XM.Columns.Add("Fph", System.Type.GetType("System.String"));
dt_XM.Columns.Add("Bz", System.Type.GetType("System.String"));
dt_XM.Columns.Add("Xmxl", System.Type.GetType("System.String"));
DataColumn dc = new DataColumn("children", System.Type.GetType("System.String"));
dt_XM.Columns.Add(dc);
DataSet dsXM = new ZdcwxmManager().GetAllZdcwxm_DS("10");
foreach (DataRow item in dsXM.Tables[0].Rows)
{
string xmdm= item["XM_DM"].ToString();
string xmmc=item["XM_MC"].ToString();
DataView dv = new DataView(dt);
string filter = "Xmxl='"+xmdm+"'";
dv.RowFilter=filter;
int c = dv.Count;
if (c>0)
{
string json1 = Newtonsoft.Json.JsonConvert.SerializeObject(dv.ToTable());
DataRow dr = dt_XM.NewRow();
dr["IDDJtdj"] = "0";
dr["XM_MC"] = xmmc;
dr["Rzsj"] = "";
dr["Pzh"] = "";
dr["Rzkm"] = "";
dr["RzkmD"] = "";
dr["Zy"] = "";
dr["Yxpzje"] = "0";
dr["Ftbl"] = "0";
dr["Pzje"] = "0";
dr["Fph"] = "";
dr["Bz"] = "";
dr["Xmxl"] = "";
dr["children"] = json1;
dt_XM.Rows.Add(dr);
}
}
string json = Newtonsoft.Json.JsonConvert.SerializeObject(dt_XM);
return json;
{
DataSet ds = bll.GetAllDJtdjDS(PublicModels.XmGuid);
DataTable dt = ds.Tables[0];
DataTable dt_XM = new DataTable("XM");
dt_XM.Columns.Add("IDDJtdj", System.Type.GetType("System.String"));
dt_XM.Columns.Add("XM_MC", System.Type.GetType("System.String"));
dt_XM.Columns.Add("Rzsj", System.Type.GetType("System.String"));
dt_XM.Columns.Add("Pzh", System.Type.GetType("System.String"));
dt_XM.Columns.Add("Rzkm", System.Type.GetType("System.String"));
dt_XM.Columns.Add("RzkmD", System.Type.GetType("System.String"));
dt_XM.Columns.Add("Zy", System.Type.GetType("System.String"));
dt_XM.Columns.Add("Yxpzje", System.Type.GetType("System.String"));
dt_XM.Columns.Add("Ftbl", System.Type.GetType("System.String"));
dt_XM.Columns.Add("Pzje", System.Type.GetType("System.String"));
dt_XM.Columns.Add("Fph", System.Type.GetType("System.String"));
dt_XM.Columns.Add("Bz", System.Type.GetType("System.String"));
dt_XM.Columns.Add("Xmxl", System.Type.GetType("System.String"));
DataColumn dc = new DataColumn("children", System.Type.GetType("System.String"));
dt_XM.Columns.Add(dc);
DataSet dsXM = new ZdcwxmManager().GetAllZdcwxm_DS("10");
foreach (DataRow item in dsXM.Tables[0].Rows)
{
string xmdm= item["XM_DM"].ToString();
string xmmc=item["XM_MC"].ToString();
DataView dv = new DataView(dt);
string filter = "Xmxl='"+xmdm+"'";
dv.RowFilter=filter;
int c = dv.Count;
if (c>0)
{
string json1 = Newtonsoft.Json.JsonConvert.SerializeObject(dv.ToTable());
DataRow dr = dt_XM.NewRow();
dr["IDDJtdj"] = "0";
dr["XM_MC"] = xmmc;
dr["Rzsj"] = "";
dr["Pzh"] = "";
dr["Rzkm"] = "";
dr["RzkmD"] = "";
dr["Zy"] = "";
dr["Yxpzje"] = "0";
dr["Ftbl"] = "0";
dr["Pzje"] = "0";
dr["Fph"] = "";
dr["Bz"] = "";
dr["Xmxl"] = "";
dr["children"] = json1;
dt_XM.Rows.Add(dr);
}
}
string json = Newtonsoft.Json.JsonConvert.SerializeObject(dt_XM);
return json;
}
其实得到这样的json也没用,实际应用中不会是这样的,需要动态加载,并且带有操作栏。白白浪费了时间