datetble转json追加对象

帮助类转换

public void test()
{
   DataTable Td = DataService.SystemDatabase.GetDataTable(sql);
        IList<Ztree> list = Help<Ztree>.ConvertToModel(Td);
        IList<UserInfoBase> Info = null;
        foreach (Ztree item in list)
        {
            string tree = item.DEPARTMENTCODE.ToString();
            string sqls = "select t.*, t.rowid from liquidgis_rbac_user t where t.departmentid='" + tree + "'";
            DataTable Tdate = DataService.SystemDatabase.GetDataTable(sqls);
            Info = Help<UserInfoBase>.ConvertToModel(Tdate);
            item.user = Info;
        }}
        //实体类
	public class Ztree
	{
    public string DEPARTMENTID { get; set; }
    public string PARENTDEPARTMENTID { get; set; }
    IList<UserInfoBase>  user {get;set;}
    }
    //子类
      public class UserInfoBase
{
    public string USERID { get; set; }
    public string USERNAME { get; set; }
    public string PASSWORD { get; set; }
    }
    //转换帮助类
     public class Help<T> where T : new()
{
    public static IList<T> ConvertToModel(DataTable dt)
    {

        IList<T> ts = new List<T>();// 定义集合
        Type type = typeof(T); // 获得此模型的类型
        string tempName = "";
        foreach (DataRow dr in dt.Rows)
        {
            T t = new T();
            PropertyInfo[] propertys = t.GetType().GetProperties();// 获得此模型的公共属性
            foreach (PropertyInfo pi in propertys)
            {
                tempName = pi.Name;
                if (dt.Columns.Contains(tempName))
                {
                    if (!pi.CanWrite) continue;
                    object value = dr[tempName];
                    if (value != DBNull.Value)
                        pi.SetValue(t, value, null);
                }
            }
            ts.Add(t);
        }
        return ts;
    }
}