~yhj/HM_JK.git - Gitblit

			@@ -1,9 +1,11 @@
			using SqlSugar;

			namespace MES.Service.Modes;

			using System;
			using System.Collections.Generic;
			using System.Linq;
			using SqlSugar;
			namespace MES.Service.Modes
			{
			/// <summary>
			/// 工单子表
			/// 任务单物料表
			/// </summary>
			[SugarTable("WOMCAB")]
			public class Womcab
			@@ -11,282 +13,301 @@
			/// <summary>
			/// 自增列
			/// </summary>
			[SugarColumn(ColumnName = "ID", IsPrimaryKey = true,
			OracleSequenceName = "SEQ_CAB")]
			public decimal? Id { get; set; }

			[SugarColumn(ColumnName="ID" ,IsPrimaryKey = true )]
			public decimal Id { get; set; }
			/// <summary>
			/// ERPID
			/// 生产用料清单行内码
			/// </summary>
			[SugarColumn(ColumnName = "ERPID")]
			public decimal? Erpid { get; set; }

			/// <summary>
			/// 单号
			/// 工单单号
			/// </summary>
			[SugarColumn(ColumnName = "CAB001")]
			public string? Cab001 { get; set; }

			public string Cab001 { get; set; }
			/// <summary>
			/// 序号
			/// </summary>
			[SugarColumn(ColumnName = "CAB002")]
			public string? Cab002 { get; set; }

			public string Cab002 { get; set; }
			/// <summary>
			/// 材料编码
			/// </summary>
			[SugarColumn(ColumnName = "CAB003")]
			public string? Cab003 { get; set; }

			public string Cab003 { get; set; }
			/// <summary>
			/// 需领用量
			/// </summary>
			[SugarColumn(ColumnName = "CAB006")]
			public decimal? Cab006 { get; set; }

			/// <summary>
			/// 已领用量
			/// </summary>
			[SugarColumn(ColumnName = "CAB007")]
			public decimal? Cab007 { get; set; }

			/// <summary>
			/// 工艺
			/// </summary>
			[SugarColumn(ColumnName = "CAB008")]
			public string? Cab008 { get; set; }

			public string Cab008 { get; set; }
			/// <summary>
			/// 单位
			/// </summary>
			[SugarColumn(ColumnName = "CAB009")]
			public string? Cab009 { get; set; }

			public string Cab009 { get; set; }
			/// <summary>
			/// 组成用量
			/// </summary>
			[SugarColumn(ColumnName = "CAB012")]
			public decimal? Cab012 { get; set; }

			/// <summary>
			/// 是否替料
			/// </summary>
			[SugarColumn(ColumnName = "CAB014")]
			public string? Cab014 { get; set; }

			public decimal? Cab014 { get; set; }
			/// <summary>
			/// PID
			/// 生产订单行内码
			/// </summary>
			[SugarColumn(ColumnName = "PID")]
			public decimal? Pid { get; set; }

			/// <summary>
			/// ERP头ID
			/// 生产订单行内码
			/// </summary>
			[SugarColumn(ColumnName = "EID")]
			public decimal? Eid { get; set; }

			/// <summary>
			/// 位置号
			/// </summary>
			[SugarColumn(ColumnName = "POSITION_NO")]
			public string? PositionNo { get; set; }

			public string PositionNo { get; set; }
			/// <summary>
			/// 发料组织
			/// </summary>
			[SugarColumn(ColumnName = "ISSUING_ORGANIZATION")]
			public string? IssuingOrganization { get; set; }

			public string IssuingOrganization { get; set; }
			/// <summary>
			/// 供应组织
			/// </summary>
			[SugarColumn(ColumnName = "SUPPLY_ORGANIZATION")]
			public string? SupplyOrganization { get; set; }

			public string SupplyOrganization { get; set; }
			/// <summary>
			/// 货主
			/// </summary>
			[SugarColumn(ColumnName = "OWNER_ID")]
			public string? OwnerId { get; set; }

			public string OwnerId { get; set; }
			/// <summary>
			/// 计划跟踪号
			/// </summary>
			[SugarColumn(ColumnName = "MTONO")]
			public string? Mtono { get; set; }

			public string Mtono { get; set; }
			/// <summary>
			/// 批号
			/// </summary>
			[SugarColumn(ColumnName = "LOT")]
			public string? Lot { get; set; }

			public string Lot { get; set; }
			/// <summary>
			/// 仓库
			/// </summary>
			[SugarColumn(ColumnName = "DEPOT_CODE")]
			public string? DepotCode { get; set; }

			public string DepotCode { get; set; }
			/// <summary>
			/// 发料方式
			/// </summary>
			[SugarColumn(ColumnName = "ISSUE_TYPE")]
			public string? IssueType { get; set; }

			public string IssueType { get; set; }
			/// <summary>
			/// 供应类型
			/// 供应类型 C采购 Z自制 W委外
			/// </summary>
			[SugarColumn(ColumnName = "SUPPLY_TYPE")]
			public string? SupplyType { get; set; }

			public string SupplyType { get; set; }
			/// <summary>
			/// 分子
			/// </summary>
			[SugarColumn(ColumnName = "NUMERATOR")]
			public decimal? Numerator { get; set; }

			/// <summary>
			/// 分母
			/// </summary>
			[SugarColumn(ColumnName = "DENOMINATOR")]
			public decimal? Denominator { get; set; }

			/// <summary>
			/// 固定损耗
			/// </summary>
			[SugarColumn(ColumnName = "SCRAPQTY")]
			public decimal? SCRAPQTY { get; set; }

			public decimal? Scrapqty { get; set; }
			/// <summary>
			/// 变动损耗率
			/// </summary>
			[SugarColumn(ColumnName = "SCRAPRATE")]
			public decimal? SCRAPRATE { get; set; }


			public decimal? Scraprate { get; set; }
			/// <summary>
			/// 应发数量
			/// 销售订单号
			/// </summary>
			[SugarColumn(ColumnName = "Must_Qty")]
			public decimal? MustQty { get; set; }

			[SugarColumn(ColumnName="SALES_ORDER" )]
			public string SalesOrder { get; set; }
			/// <summary>
			/// 项次号
			/// 需求单据
			/// </summary>
			[SugarColumn(ColumnName = "FREPLACEGROUP")]
			public int? Freplacegroup { get; set; }

			[SugarColumn(ColumnName="F_WWC_TEXT1" )]
			public string FWwcText1 { get; set; }
			/// <summary>
			/// 使用比例（%）
			/// 计划完工日期
			/// </summary>
			[SugarColumn(ColumnName = "USE_RATE")]
			public decimal? UseRate { get; set; }

			[SugarColumn(ColumnName="F_WWC_DATE" )]
			public DateTime? FWwcDate { get; set; }
			/// <summary>
			/// 旧物料编码
			///</summary>
			[SugarColumn(ColumnName="F_WWC_BASEPROPERTY" )]
			public string FWwcBaseproperty { get; set; }
			/// <summary>
			/// 使用比例
			///</summary>
			[SugarColumn(ColumnName="FUSERATE" )]
			public decimal? Fuserate { get; set; }
			/// <summary>
			/// 子项类型 1标准件 2返还件 3替代件
			/// </summary>
			[SugarColumn(ColumnName = "MATERIAL_TYPE")]
			public string? MaterialType { get; set; }

			[SugarColumn(ColumnName="FMATERIALTYPE" )]
			public decimal? Fmaterialtype { get; set; }
			/// <summary>
			/// A，创建 B，审核中 C，已审核 D，重新审核 Z，暂存
			/// 子项单位
			/// </summary>
			[SugarColumn(ColumnName = "TYPEB")]
			public string? Typeb { get; set; }


			[SugarColumn(ColumnName="FUNITID3" )]
			public string Funitid3 { get; set; }
			/// <summary>
			/// A，创建 B，审核中 C，已审核 D，重新审核 Z，暂存
			/// 子项单位
			/// </summary>
			[SugarColumn(ColumnName = "WR_F_XIFG_BASE_QTR")]
			public string? WR_F_XIFG_Base_qtr { get; set; }

			[SugarColumn(ColumnName="FUNITID2" )]
			public string Funitid2 { get; set; }
			/// <summary>
			/// A，创建 B，审核中 C，已审核 D，重新审核 Z，暂存
			/// 生产通知单
			/// </summary>
			[SugarColumn(ColumnName = "WR_F_XIFG_BASE_83G")]
			public string? WR_F_XIFG_Base_83g { get; set; }


			/////----委外新增

			[SugarColumn(ColumnName="F_XIFG_BASE_RE5" )]
			public string FXifgBaseRe5 { get; set; }
			/// <summary>
			/// 是否发损耗 -- 委外新增
			/// 货主类型
			/// </summary>
			[SugarColumn(ColumnName = "FISGETSCRAP")]
			public string? Fisgetscrap { get; set; }

			[SugarColumn(ColumnName="FOWNERTYPEID" )]
			public string Fownertypeid { get; set; }
			/// <summary>
			/// 是否关键件 -- 委外新增
			/// ERP生产订单分录内码 -- 委外新增
			/// </summary>
			[SugarColumn(ColumnName = "FISKEYCOMPONENT")]
			public string? Fiskeycomponent { get; set; }

			[SugarColumn(ColumnName="ERP_PRODUCTION_ENTRY_CODE" )]
			public string ErpProductionEntryCode { get; set; }
			/// <summary>
			/// 拨出组织 -- 委外新增
			/// 用料清单备注 -- 委外新增
			/// </summary>
			[SugarColumn(ColumnName = "FSRCTRANSORGID")]
			public string? Fsrctransorgid { get; set; }

			[SugarColumn(ColumnName="FMEMO" )]
			public string Fmemo { get; set; }
			/// <summary>
			/// 拨出仓库 -- 委外新增
			/// 预留类型 -- 委外新增
			/// </summary>
			[SugarColumn(ColumnName = "FSRCTRANSSTOCKID")]
			public string? Fsrctransstockid { get; set; }

			/// <summary>
			/// 库存状态 -- 委外新增
			/// </summary>
			[SugarColumn(ColumnName = "FSTOCKSTATUSID")]
			public string? Fstockstatusid { get; set; }

			[SugarColumn(ColumnName="FRESERVETYPE" )]
			public string Freservetype { get; set; }
			/// <summary>
			/// 需求日期 -- 委外新增
			/// </summary>
			[SugarColumn(ColumnName = "FNEEDDATE")]
			public DateTime? Fneeddate { get; set; }
			/// <summary>
			/// 库存状态 -- 委外新增
			///</summary>
			[SugarColumn(ColumnName="FSTOCKSTATUSID" )]
			public string Fstockstatusid { get; set; }
			/// <summary>
			/// 拨出仓库 -- 委外新增
			///</summary>
			[SugarColumn(ColumnName="FSRCTRANSSTOCKID" )]
			public string Fsrctransstockid { get; set; }
			/// <summary>
			/// 拨出组织 -- 委外新增
			///</summary>
			[SugarColumn(ColumnName="FSRCTRANSORGID" )]
			public string Fsrctransorgid { get; set; }
			/// <summary>
			/// 是否关键件 -- 委外新增
			///</summary>
			[SugarColumn(ColumnName="FISKEYCOMPONENT" )]
			public string Fiskeycomponent { get; set; }
			/// <summary>
			/// 是否发损耗 -- 委外新增
			///</summary>
			[SugarColumn(ColumnName="FISGETSCRAP" )]
			public string Fisgetscrap { get; set; }
			/// <summary>
			/// 状态
			///</summary>
			[SugarColumn(ColumnName="WR_F_XIFG_BASE_83G" )]
			public string WrFXifgBase83g { get; set; }
			/// <summary>
			/// 状态
			///</summary>
			[SugarColumn(ColumnName="WR_F_XIFG_BASE_QTR" )]
			public string WrFXifgBaseQtr { get; set; }
			/// <summary>
			/// 状态
			///</summary>
			[SugarColumn(ColumnName="TYPEB" )]
			public string Typeb { get; set; }
			/// <summary>
			/// 子项类型 1标准件 2返还件 3替代件
			///</summary>
			[SugarColumn(ColumnName="MATERIAL_TYPE" )]
			public string MaterialType { get; set; }
			/// <summary>
			/// 使用比例（%）
			///</summary>
			[SugarColumn(ColumnName="USE_RATE" )]
			public decimal? UseRate { get; set; }
			/// <summary>
			/// 项次号
			///</summary>
			[SugarColumn(ColumnName="FREPLACEGROUP" )]
			public decimal? Freplacegroup { get; set; }
			/// <summary>
			/// 应发数量
			///</summary>
			[SugarColumn(ColumnName="MUST_QTY" )]
			public decimal? MustQty { get; set; }
			/// <summary>
			/// 未领数
			///</summary>
			[SugarColumn(ColumnName="WLSL" )]
			public string Wlsl { get; set; }

			/// <summary>
			/// 预留类型 -- 委外新增
			/// 客户物料代码
			/// </summary>
			[SugarColumn(ColumnName = "FRESERVETYPE")]
			public string? Freservetype { get; set; }
			[SugarColumn(ColumnName = "KHWLBM")]
			public string Khwlbm { get; set; }

			/// <summary>
			/// 用料清单备注 -- 委外新增
			/// 客户物料名称
			/// </summary>
			[SugarColumn(ColumnName = "FMEMO")]
			public string? Fmemo { get; set; }
			[SugarColumn(ColumnName = "KHWLMC")]
			public string Khwlmc { get; set; }

			/// <summary>
			/// ERP生产订单分录内码 -- 委外新增
			/// 需求组织
			/// </summary>
			[SugarColumn(ColumnName = "ERP_PRODUCTION_ENTRY_CODE")]
			public string? ErpProductionEntryCode { get; set; }
			[SugarColumn(ColumnName = "XQZZ")]
			public string Xqzz { get; set; }

			/// <summary>
			/// 货主类型
			/// 需求部门
			/// </summary>
			[SugarColumn(ColumnName = "FOWNERTYPEID")]
			public string? FOWNERTYPEID { get; set; }

			[SugarColumn(ColumnName = "XQBM")]
			public string Xqbm { get; set; }
			/// <summary>
			/// 生产通知单
			/// 收料组织
			/// </summary>
			[SugarColumn(ColumnName = "F_XIFG_BASE_RE5")]
			public string? F_XIFG_BASE_RE5 { get; set; }

			[SugarColumn(ColumnName = "SLZZ")]
			public string Slzz { get; set; }
			/// <summary>
			/// 子项单位
			/// 收料部门
			/// </summary>
			[SugarColumn(ColumnName = "FUNITID2")]
			public string? FUNITID2 { get; set; }

			/// <summary>
			/// 子项单位
			/// </summary>
			[SugarColumn(ColumnName = "FUNITID3")]
			public string? FUNITID3 { get; set; }
			[SugarColumn(ColumnName = "SLBM")]
			public string Slbm { get; set; }
			}
			}