查找空库位，查找库存

zs

2025-05-09 14f9c8378bde7d9a8d8f1fcc393e0e8d49eced82

 HIAWms/server/src/CMS.Plugin.HIAWms.MySQL/Migrations/20250429025531_InitialCreate.cs

@@ -110,7 +110,7 @@
                columns: table => new
                {
                    Id = table.Column<Guid>(type: "char(36)", nullable: false, collation: "ascii_general_ci"),
                    MaterialCode = table.Column<string>(type: "varchar(64)", maxLength: 64, nullable: false, comment: "物料编码（唯一标识）")
                    MaterialNo = table.Column<string>(type: "varchar(64)", maxLength: 64, nullable: false, comment: "物料编码（唯一标识）")
                        .Annotation("MySql:CharSet", "utf8mb4"),
                    MaterialName = table.Column<string>(type: "varchar(128)", maxLength: 128, nullable: false, comment: "物料名称")
                        .Annotation("MySql:CharSet", "utf8mb4"),
@@ -265,9 +265,9 @@
                column: "ContainerType");

            migrationBuilder.CreateIndex(
                name: "IX_scms_wmsmaterials_MaterialCode",
                name: "IX_scms_wmsmaterials_MaterialNo",
                table: "scms_wmsmaterials",
                column: "MaterialCode",
                column: "MaterialNo",
                unique: true);

            migrationBuilder.CreateIndex(