Example #1
0
        protected void Page_Load(object sender, EventArgs e)
        {
            //TODO:目前读取CD.xml和ContentModel的XML ,取出信息不全,可能会和数据库中有一定差异,无法读取table的描述
            result.Append("[");
            foreach (var item in Assistant.DicForTable().Values)
            {
                result.Append("{\"Table\":\"" + item.CurObject.TableName + "\",\"Desc\":\"" + item.CurObject.Description + "\",\"PK\":\"" + item.CurObject.PrimaryKeyName + "\",\"Columns\":[");

                foreach (var p in item.CurObject.PropertyDict)
                {
                    if (p.Value.Name.ToUpper() != "ID")
                    {
                        result.Append("\"" + p.Value.Name + "\",");
                    }
                }
                if (result.ToString().LastIndexOf(",") > 0)
                {
                    result.Remove(result.ToString().LastIndexOf(","), 1);
                }
                result.Append("]},");
            }
            if (result.ToString().LastIndexOf(",") > 0)
            {
                result.Remove(result.ToString().LastIndexOf(","), 1);
            }

            result.Append("]");
        }