zs
2025-05-06 2fd8242a14241beba63e71c6f4222b702f0e2f30
Weben_CMS专用代码生成器/Code/DataBaseFactory/Default/MySqlDataBaseServiceHandle.cs
@@ -23,7 +23,8 @@
                $"AND c.TABLE_NAME = kcu.TABLE_NAME " +
                $"AND c.COLUMN_NAME = kcu.COLUMN_NAME " +
                $"AND kcu.CONSTRAINT_NAME = 'PRIMARY' " +
                $"WHERE c.TABLE_NAME = '{tableName}'";
                $"WHERE c.TABLE_NAME = '{tableName}'"+
                $"ORDER BY c.ORDINAL_POSITION";
            List<ColumnModel> columnList = new List<ColumnModel>();
@@ -77,7 +78,7 @@
                        model.Description = dt.Rows[n]["Description"].ToString();
                        if (dt.Rows[n]["IsNullable"].ToString() != "")
                        {
                            if ((dt.Rows[n]["IsNullable"].ToString() == "1") || (dt.Rows[n]["IsNullable"].ToString().ToLower() == "true"))
                            if ((dt.Rows[n]["IsNullable"].ToString() == "1") || (dt.Rows[n]["IsNullable"].ToString().ToLower() == "true") || (dt.Rows[n]["IsNullable"].ToString().ToLower() == "yes"))
                            {
                                model.IsNullable = true;
                            }