Ejemplo n.º 1
0
        public static bool download()
        {
            DataSet ds = MySqlHelper.GetDataSet(MySqlHelper.ConnectionStringManager, "show TABLES;", null);
            DataTable dt = ds.Tables.Count > 0 ? ds.Tables[0] : null;
            if (dt == null)
            {
                return false;
            }
            for (int i = 0; i < dt.Rows.Count; i++)
            {
                tablenames.Add(dt.Rows[i][0].ToString());
            }
            //查询所有的表结构
            for (int i = 0; i < tablenames.Count; i++)
            {
                ds = MySqlHelper.GetDataSet(MySqlHelper.ConnectionStringManager, "desc "+tablenames[i]+";", null);
                dt = ds.Tables.Count > 0 ? ds.Tables[0] : null;
                if (dt == null)
                {
                    return false;
                }
                List<DBField> fields = new List<DBField>();
                for(int j=0;j<dt.Rows.Count;j++)
                {
                    DBField field = new DBField();
                    field.name = dt.Rows[j][0].ToString();
                    field.type = dt.Rows[j][1].ToString().Split('(')[0];
                    fields.Add(field);
                }
                tables.Add(tablenames[i], fields);
            }

            return true;
        }