From 6f6f118881771a70feb186061ebb4ccd03a47e68 Mon Sep 17 00:00:00 2001
From: schangxiang@126.com <schangxiang@126.com>
Date: 周四, 04 9月 2025 15:12:31 +0800
Subject: [PATCH] 优化查询
---
wcs/yunneiWCS/yunneiWCS/ORM/dbmodel.cs | 86 +++++++++++++++++++++++++++++-------------
1 files changed, 59 insertions(+), 27 deletions(-)
diff --git a/wcs/yunneiWCS/yunneiWCS/ORM/dbmodel.cs b/wcs/yunneiWCS/yunneiWCS/ORM/dbmodel.cs
index 735ac14..c678b6a 100644
--- a/wcs/yunneiWCS/yunneiWCS/ORM/dbmodel.cs
+++ b/wcs/yunneiWCS/yunneiWCS/ORM/dbmodel.cs
@@ -1,17 +1,14 @@
-锘縩amespace yunneiWCS.ORM
-{
- using System;
- using System.Data.Entity;
- using System.ComponentModel.DataAnnotations.Schema;
- using System.Linq;
+using System.Data.Entity;
+namespace yunneiWCS.ORM
+{
public partial class dbmodel : DbContext
{
public dbmodel()
: base("name=dbmodel")
{
}
-
+ public virtual DbSet<v_srmStockdetails> v_srmStockdetails { get; set; }
public virtual DbSet<BasicDataSet> BasicDataSet { get; set; }
public virtual DbSet<inStockOrder> inStockOrder { get; set; }
public virtual DbSet<inStockOrderList> inStockOrderList { get; set; }
@@ -33,45 +30,52 @@
public virtual DbSet<user> user { get; set; }
public virtual DbSet<userVsRole> userVsRole { get; set; }
public virtual DbSet<Wms_outInStockRecord> Wms_outInStockRecord { get; set; }
+ public virtual DbSet<Wms_outInStockRecord_Details_V2_Mes> Wms_outInStockRecord_Details_V2_Mes { get; set; }
+ public virtual DbSet<Wms_outInStockRecord_V2_Mes> Wms_outInStockRecord_V2_Mes { get; set; }
public virtual DbSet<outInStockRecord> outInStockRecord { get; set; }
public virtual DbSet<userAndRole> userAndRole { get; set; }
public virtual DbSet<v_inStockOrder> v_inStockOrder { get; set; }
public virtual DbSet<v_outStockList> v_outStockList { get; set; }
public virtual DbSet<VproductStock> VproductStock { get; set; }
- public virtual DbSet<Wms_outInStockRecord_V2_Mes> Wms_outInStockRecord_V2_Mes { get; set; }
-
- public virtual DbSet<Wms_outInStockRecord_Details_V2_Mes> Wms_outInStockRecord_Details_V2_Mes { get; set; }
-
protected override void OnModelCreating(DbModelBuilder modelBuilder)
{
- modelBuilder.Entity<Wms_outInStockRecord_Details_V2_Mes>()
- .Property(e => e.productCode)
- .IsUnicode(false);
+ modelBuilder.Entity<v_srmStockdetails>()
+ .Property(e => e.productName)
+ .IsUnicode(false);
- modelBuilder.Entity<Wms_outInStockRecord_Details_V2_Mes>()
- .Property(e => e.Creator)
+ modelBuilder.Entity<v_srmStockdetails>()
+ .Property(e => e.serialNumber)
.IsUnicode(false);
- modelBuilder.Entity<Wms_outInStockRecord_Details_V2_Mes>()
- .Property(e => e.LastModifier)
+ modelBuilder.Entity<v_srmStockdetails>()
+ .Property(e => e.positionName)
.IsUnicode(false);
- modelBuilder.Entity<Wms_outInStockRecord_V2_Mes>()
- .Property(e => e.outInFlagName)
- .IsUnicode(false);
-
- modelBuilder.Entity<Wms_outInStockRecord_V2_Mes>()
+ modelBuilder.Entity<v_srmStockdetails>()
.Property(e => e.materialCode)
.IsUnicode(false);
- modelBuilder.Entity<Wms_outInStockRecord_V2_Mes>()
- .Property(e => e.Creator)
+ modelBuilder.Entity<v_srmStockdetails>()
+ .Property(e => e.materialName)
.IsUnicode(false);
- modelBuilder.Entity<Wms_outInStockRecord_V2_Mes>()
- .Property(e => e.LastModifier)
+ modelBuilder.Entity<v_srmStockdetails>()
+ .Property(e => e.productCode)
.IsUnicode(false);
+
+ modelBuilder.Entity<v_srmStockdetails>()
+ .Property(e => e.containerCode)
+ .IsUnicode(false);
+
+ modelBuilder.Entity<v_srmStockdetails>()
+ .Property(e => e.supplier)
+ .IsUnicode(false);
+
+ modelBuilder.Entity<v_srmStockdetails>()
+ .Property(e => e.version)
+ .IsUnicode(false);
+
modelBuilder.Entity<BasicDataSet>()
.Property(e => e.BasicDataType)
.IsFixedLength()
@@ -353,6 +357,34 @@
.Property(e => e.LastModifier)
.IsUnicode(false);
+ modelBuilder.Entity<Wms_outInStockRecord_Details_V2_Mes>()
+ .Property(e => e.productCode)
+ .IsUnicode(false);
+
+ modelBuilder.Entity<Wms_outInStockRecord_Details_V2_Mes>()
+ .Property(e => e.Creator)
+ .IsUnicode(false);
+
+ modelBuilder.Entity<Wms_outInStockRecord_Details_V2_Mes>()
+ .Property(e => e.LastModifier)
+ .IsUnicode(false);
+
+ modelBuilder.Entity<Wms_outInStockRecord_V2_Mes>()
+ .Property(e => e.outInFlagName)
+ .IsUnicode(false);
+
+ modelBuilder.Entity<Wms_outInStockRecord_V2_Mes>()
+ .Property(e => e.materialCode)
+ .IsUnicode(false);
+
+ modelBuilder.Entity<Wms_outInStockRecord_V2_Mes>()
+ .Property(e => e.Creator)
+ .IsUnicode(false);
+
+ modelBuilder.Entity<Wms_outInStockRecord_V2_Mes>()
+ .Property(e => e.LastModifier)
+ .IsUnicode(false);
+
modelBuilder.Entity<outInStockRecord>()
.Property(e => e.taskName)
.IsUnicode(false);
--
Gitblit v1.9.3