MES.Service/Dto/service/WarehouseQuery.cs
@@ -19,8 +19,8 @@ public string? Type { get; set; } public string? DepotCode { get; set; } public string? SuppNo { get; set; } public string Factory { get; set; } public string Company { get; set; } } MES.Service/Modes/MesInvBusiness2.cs
@@ -8,220 +8,220 @@ [SugarTable("MES_INV_BUSINESS2")] public class MesInvBusiness2 { /// <summary> /// ID(seq_inv_id) /// </summary> [SugarColumn(ColumnName = "ID", OracleSequenceName = "SEQ_ID", /// <summary> /// ID(seq_inv_id) /// </summary> [SugarColumn(ColumnName = "ID", OracleSequenceName = "SEQ_ID", IsPrimaryKey = true)] public decimal Id { get; set; } /// <summary> /// 状态|0-未交易1-已交易 /// </summary> [SugarColumn(ColumnName = "STATUS")] /// <summary> /// 状态|0-未交易1-已交易 /// </summary> [SugarColumn(ColumnName = "STATUS")] public decimal? Status { get; set; } /// <summary> /// 单据类型ID /// </summary> [SugarColumn(ColumnName = "BILL_TYPE_ID")] /// <summary> /// 单据类型ID /// </summary> [SugarColumn(ColumnName = "BILL_TYPE_ID")] public decimal? BillTypeId { get; set; } /// <summary> /// 事务类型编码 /// </summary> [SugarColumn(ColumnName = "TRANSACTION_CODE")] /// <summary> /// 事务类型编码 /// </summary> [SugarColumn(ColumnName = "TRANSACTION_CODE")] public string TransactionCode { get; set; } /// <summary> /// 交易类型|1-入库0-转库-1出库 /// </summary> [SugarColumn(ColumnName = "BUSINESS_TYPE")] /// <summary> /// 交易类型|1-入库0-转库-1出库 /// </summary> [SugarColumn(ColumnName = "BUSINESS_TYPE")] public decimal? BusinessType { get; set; } /// <summary> /// 单据ID /// </summary> [SugarColumn(ColumnName = "BILL_ID")] /// <summary> /// 单据ID /// </summary> [SugarColumn(ColumnName = "BILL_ID")] public decimal? BillId { get; set; } /// <summary> /// 单据编码 /// </summary> [SugarColumn(ColumnName = "BILL_NO")] /// <summary> /// 单据编码 /// </summary> [SugarColumn(ColumnName = "BILL_NO")] public string BillNo { get; set; } /// <summary> /// 生产订单号 /// </summary> [SugarColumn(ColumnName = "TASK_NO")] /// <summary> /// 生产订单号 /// </summary> [SugarColumn(ColumnName = "TASK_NO")] public string TaskNo { get; set; } /// <summary> /// 客户编号 /// </summary> [SugarColumn(ColumnName = "CUSTOMER_NO")] /// <summary> /// 客户编号 /// </summary> [SugarColumn(ColumnName = "CUSTOMER_NO")] public string CustomerNo { get; set; } /// <summary> /// 单据行ID /// </summary> [SugarColumn(ColumnName = "BILL_LINE_ID")] /// <summary> /// 单据行ID /// </summary> [SugarColumn(ColumnName = "BILL_LINE_ID")] public decimal? BillLineId { get; set; } /// <summary> /// 物料条码 /// </summary> [SugarColumn(ColumnName = "ITEM_BARCODE")] /// <summary> /// 物料条码 /// </summary> [SugarColumn(ColumnName = "ITEM_BARCODE")] public string ItemBarcode { get; set; } /// <summary> /// 本司物料编码 /// </summary> [SugarColumn(ColumnName = "ITEM_NO")] /// <summary> /// 本司物料编码 /// </summary> [SugarColumn(ColumnName = "ITEM_NO")] public string ItemNo { get; set; } /// <summary> /// 客户物料编码 /// </summary> [SugarColumn(ColumnName = "C_ITEM_CODE")] /// <summary> /// 客户物料编码 /// </summary> [SugarColumn(ColumnName = "C_ITEM_CODE")] public string CItemCode { get; set; } /// <summary> /// 厂家批次 /// </summary> [SugarColumn(ColumnName = "LOT_NO")] /// <summary> /// 厂家批次 /// </summary> [SugarColumn(ColumnName = "LOT_NO")] public string LotNo { get; set; } /// <summary> /// 是否环保(0:否,1:是) /// </summary> [SugarColumn(ColumnName = "EP_FLAG")] /// <summary> /// 是否环保(0:否,1:是) /// </summary> [SugarColumn(ColumnName = "EP_FLAG")] public short? EpFlag { get; set; } /// <summary> /// 数量 /// </summary> [SugarColumn(ColumnName = "QUANTITY")] /// <summary> /// 数量 /// </summary> [SugarColumn(ColumnName = "QUANTITY")] public decimal? Quantity { get; set; } /// <summary> /// 源子库CODE /// </summary> [SugarColumn(ColumnName = "FROM_INV_DEPOTS_CODE")] /// <summary> /// 源子库CODE /// </summary> [SugarColumn(ColumnName = "FROM_INV_DEPOTS_CODE")] public string FromInvDepotsCode { get; set; } /// <summary> /// 源货位CODE /// </summary> [SugarColumn(ColumnName = "FROM_INV_DEPOT_SECTIONS_CODE")] /// <summary> /// 源货位CODE /// </summary> [SugarColumn(ColumnName = "FROM_INV_DEPOT_SECTIONS_CODE")] public string FromInvDepotSectionsCode { get; set; } /// <summary> /// 目的子库CODE /// </summary> [SugarColumn(ColumnName = "TO_INV_DEPOTS_CODE")] /// <summary> /// 目的子库CODE /// </summary> [SugarColumn(ColumnName = "TO_INV_DEPOTS_CODE")] public string ToInvDepotsCode { get; set; } /// <summary> /// 目的货位CODE /// </summary> [SugarColumn(ColumnName = "TO_INV_DEPOT_SECTIONS_CODE")] /// <summary> /// 目的货位CODE /// </summary> [SugarColumn(ColumnName = "TO_INV_DEPOT_SECTIONS_CODE")] public string ToInvDepotSectionsCode { get; set; } /// <summary> /// 交易异常信息 /// </summary> [SugarColumn(ColumnName = "DESCRIPTION")] /// <summary> /// 交易异常信息 /// </summary> [SugarColumn(ColumnName = "DESCRIPTION")] public string Description { get; set; } /// <summary> /// 创建人 /// </summary> [SugarColumn(ColumnName = "CREATE_BY")] /// <summary> /// 创建人 /// </summary> [SugarColumn(ColumnName = "CREATE_BY")] public string CreateBy { get; set; } /// <summary> /// 创建时间 /// </summary> [SugarColumn(ColumnName = "CREATE_DATE")] /// <summary> /// 创建时间 /// </summary> [SugarColumn(ColumnName = "CREATE_DATE")] public DateTime? CreateDate { get; set; } /// <summary> /// 最后更新人 /// </summary> [SugarColumn(ColumnName = "LASTUPDATE_BY")] /// <summary> /// 最后更新人 /// </summary> [SugarColumn(ColumnName = "LASTUPDATE_BY")] public string LastupdateBy { get; set; } /// <summary> /// 最后更新时间 /// </summary> [SugarColumn(ColumnName = "LASTUPDATE_DATE")] /// <summary> /// 最后更新时间 /// </summary> [SugarColumn(ColumnName = "LASTUPDATE_DATE")] public DateTime? LastupdateDate { get; set; } /// <summary> /// 超损统计标识 /// </summary> [SugarColumn(ColumnName = "ULLAGE_STAT_FLAG")] /// <summary> /// 超损统计标识 /// </summary> [SugarColumn(ColumnName = "ULLAGE_STAT_FLAG")] public short? UllageStatFlag { get; set; } /// <summary> /// 分厂编码 /// </summary> [SugarColumn(ColumnName = "FACTORY")] /// <summary> /// 分厂编码 /// </summary> [SugarColumn(ColumnName = "FACTORY")] public string Factory { get; set; } /// <summary> /// 公司代码 /// </summary> [SugarColumn(ColumnName = "COMPANY")] /// <summary> /// 公司代码 /// </summary> [SugarColumn(ColumnName = "COMPANY")] public string Company { get; set; } /// <summary> /// 箱号条码 /// </summary> [SugarColumn(ColumnName = "ITEM_BARCODE2")] /// <summary> /// 箱号条码 /// </summary> [SugarColumn(ColumnName = "ITEM_BARCODE2")] public string ItemBarcode2 { get; set; } /// <summary> /// 卡板条码 /// </summary> [SugarColumn(ColumnName = "ITEM_BARCODE3")] /// <summary> /// 卡板条码 /// </summary> [SugarColumn(ColumnName = "ITEM_BARCODE3")] public string ItemBarcode3 { get; set; } /// <summary> /// 任务单号 /// </summary> [SugarColumn(ColumnName = "WORK_NO")] /// <summary> /// 任务单号 /// </summary> [SugarColumn(ColumnName = "WORK_NO")] public string WorkNo { get; set; } /// <summary> /// 任务单行号 /// </summary> [SugarColumn(ColumnName = "WORK_LINE")] /// <summary> /// 任务单行号 /// </summary> [SugarColumn(ColumnName = "WORK_LINE")] public decimal? WorkLine { get; set; } /// <summary> /// 供应商 /// </summary> [SugarColumn(ColumnName = "SUPP_NO")] /// <summary> /// 供应商 /// </summary> [SugarColumn(ColumnName = "SUPP_NO")] public string SuppNo { get; set; } /// <summary> /// 生产线 /// </summary> [SugarColumn(ColumnName = "LINE_NO")] /// <summary> /// 生产线 /// </summary> [SugarColumn(ColumnName = "LINE_NO")] public string LineNo { get; set; } /// <summary> /// 采购订单id /// </summary> [SugarColumn(ColumnName = "EBELN_K3ID")] /// <summary> /// 采购订单id /// </summary> [SugarColumn(ColumnName = "EBELN_K3ID")] public decimal? EbelnK3id { get; set; } /// <summary> /// 采购订单行id /// </summary> [SugarColumn(ColumnName = "LINE_K3ID")] /// <summary> /// 采购订单行id /// </summary> [SugarColumn(ColumnName = "LINE_K3ID")] public decimal? LineK3id { get; set; } } MES.Service/Modes/MesInvItemArn.cs
@@ -8,232 +8,232 @@ [SugarTable("MES_INV_ITEM_ARN")] public class MesInvItemArn { /// <summary> /// ID(SEQ_INV_ID) /// </summary> [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)] /// <summary> /// ID(SEQ_INV_ID) /// </summary> [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)] public decimal Id { get; set; } /// <summary> /// 到货单号 /// </summary> [SugarColumn(ColumnName = "BILL_NO")] /// <summary> /// 到货单号 /// </summary> [SugarColumn(ColumnName = "BILL_NO")] public string BillNo { get; set; } /// <summary> /// 状态|0-未审核1-审核入库\结案 /// </summary> [SugarColumn(ColumnName = "STATUS")] /// <summary> /// 状态|0-未审核1-审核入库\结案 /// </summary> [SugarColumn(ColumnName = "STATUS")] public short? Status { get; set; } /// <summary> /// 原因 /// </summary> [SugarColumn(ColumnName = "REASON")] /// <summary> /// 原因 /// </summary> [SugarColumn(ColumnName = "REASON")] public string Reason { get; set; } /// <summary> /// 创建人 /// </summary> [SugarColumn(ColumnName = "CREATE_BY")] /// <summary> /// 创建人 /// </summary> [SugarColumn(ColumnName = "CREATE_BY")] public string CreateBy { get; set; } /// <summary> /// 创建时间 /// </summary> [SugarColumn(ColumnName = "CREATE_DATE")] /// <summary> /// 创建时间 /// </summary> [SugarColumn(ColumnName = "CREATE_DATE")] public DateTime? CreateDate { get; set; } /// <summary> /// 最后更新人 /// </summary> [SugarColumn(ColumnName = "LASTUPDATE_BY")] /// <summary> /// 最后更新人 /// </summary> [SugarColumn(ColumnName = "LASTUPDATE_BY")] public string LastupdateBy { get; set; } /// <summary> /// 最后更新时间 /// </summary> [SugarColumn(ColumnName = "LASTUPDATE_DATE")] /// <summary> /// 最后更新时间 /// </summary> [SugarColumn(ColumnName = "LASTUPDATE_DATE")] public DateTime? LastupdateDate { get; set; } /// <summary> /// 单据类型ID /// </summary> [SugarColumn(ColumnName = "BILL_TYPE_ID")] /// <summary> /// 单据类型ID /// </summary> [SugarColumn(ColumnName = "BILL_TYPE_ID")] public decimal? BillTypeId { get; set; } /// <summary> /// 事务类型ID /// </summary> [SugarColumn(ColumnName = "TRANSACTION_ID")] /// <summary> /// 事务类型ID /// </summary> [SugarColumn(ColumnName = "TRANSACTION_ID")] public decimal? TransactionId { get; set; } /// <summary> /// 备注 /// </summary> [SugarColumn(ColumnName = "REMARK")] /// <summary> /// 备注 /// </summary> [SugarColumn(ColumnName = "REMARK")] public string Remark { get; set; } /// <summary> /// 送货单号 /// </summary> [SugarColumn(ColumnName = "PAPER_BILL_NO")] /// <summary> /// 送货单号 /// </summary> [SugarColumn(ColumnName = "PAPER_BILL_NO")] public string PaperBillNo { get; set; } /// <summary> /// 退料人工号 /// </summary> [SugarColumn(ColumnName = "USER_NO_BACK")] /// <summary> /// 退料人工号 /// </summary> [SugarColumn(ColumnName = "USER_NO_BACK")] public string UserNoBack { get; set; } /// <summary> /// 提交人 /// </summary> [SugarColumn(ColumnName = "CHECK_USER")] /// <summary> /// 提交人 /// </summary> [SugarColumn(ColumnName = "CHECK_USER")] public string CheckUser { get; set; } /// <summary> /// 提交日期 /// </summary> [SugarColumn(ColumnName = "CHECK_DATE")] /// <summary> /// 提交日期 /// </summary> [SugarColumn(ColumnName = "CHECK_DATE")] public DateTime? CheckDate { get; set; } /// <summary> /// 入库日期 /// </summary> [SugarColumn(ColumnName = "INS_DATE")] /// <summary> /// 入库日期 /// </summary> [SugarColumn(ColumnName = "INS_DATE")] public DateTime? InsDate { get; set; } /// <summary> /// 检验结果 /// </summary> [SugarColumn(ColumnName = "CHECK_RES")] /// <summary> /// 检验结果 /// </summary> [SugarColumn(ColumnName = "CHECK_RES")] public string CheckRes { get; set; } /// <summary> /// 已捡数量 /// </summary> [SugarColumn(ColumnName = "CHECK_QTY")] /// <summary> /// 已捡数量 /// </summary> [SugarColumn(ColumnName = "CHECK_QTY")] public decimal? CheckQty { get; set; } /// <summary> /// 仓库编码 /// </summary> [SugarColumn(ColumnName = "DEPOTS_CODE")] /// <summary> /// 仓库编码 /// </summary> [SugarColumn(ColumnName = "DEPOTS_CODE")] public string DepotsCode { get; set; } /// <summary> /// 事务类型编码 /// </summary> [SugarColumn(ColumnName = "TRANSCTION_NO")] /// <summary> /// 事务类型编码 /// </summary> [SugarColumn(ColumnName = "TRANSCTION_NO")] public string TransctionNo { get; set; } /// <summary> /// 供应商编码 /// </summary> [SugarColumn(ColumnName = "SUPP_NO")] /// <summary> /// 供应商编码 /// </summary> [SugarColumn(ColumnName = "SUPP_NO")] public string SuppNo { get; set; } /// <summary> /// 提交状态 /// </summary> [SugarColumn(ColumnName = "FSTATUS")] /// <summary> /// 提交状态 /// </summary> [SugarColumn(ColumnName = "FSTATUS")] public short? Fstatus { get; set; } /// <summary> /// 工厂编码 /// </summary> [SugarColumn(ColumnName = "FACTORY")] /// <summary> /// 工厂编码 /// </summary> [SugarColumn(ColumnName = "FACTORY")] public string Factory { get; set; } /// <summary> /// 是否已回写SAP /// </summary> [SugarColumn(ColumnName = "SAPSTATUS")] /// <summary> /// 是否已回写SAP /// </summary> [SugarColumn(ColumnName = "SAPSTATUS")] public short? Sapstatus { get; set; } /// <summary> /// 确认入库日期 /// </summary> [SugarColumn(ColumnName = "INS_DATE")] /// <summary> /// 确认入库日期 /// </summary> [SugarColumn(ColumnName = "INS_DATE")] public DateTime? Insdate { get; set; } /// <summary> /// 是否检验 /// </summary> [SugarColumn(ColumnName = "ISCHECK")] /// <summary> /// 是否检验 /// </summary> [SugarColumn(ColumnName = "ISCHECK")] public decimal? Ischeck { get; set; } /// <summary> /// 审核入库人 /// </summary> [SugarColumn(ColumnName = "INSBY")] /// <summary> /// 审核入库人 /// </summary> [SugarColumn(ColumnName = "INSBY")] public string Insby { get; set; } /// <summary> /// 公司代码 /// </summary> [SugarColumn(ColumnName = "COMPANY")] /// <summary> /// 公司代码 /// </summary> [SugarColumn(ColumnName = "COMPANY")] public string Company { get; set; } /// <summary> /// 急料标识 /// </summary> [SugarColumn(ColumnName = "URGENT_FLAG")] /// <summary> /// 急料标识 /// </summary> [SugarColumn(ColumnName = "URGENT_FLAG")] public short? UrgentFlag { get; set; } /// <summary> /// 冲销事务类型编码 /// </summary> [SugarColumn(ColumnName = "MTTRANSCTION_NO")] /// <summary> /// 冲销事务类型编码 /// </summary> [SugarColumn(ColumnName = "MTTRANSCTION_NO")] public decimal? MttransctionNo { get; set; } /// <summary> /// IQC检验单号 /// </summary> [SugarColumn(ColumnName = "IQC_RELEASE_NO")] /// <summary> /// IQC检验单号 /// </summary> [SugarColumn(ColumnName = "IQC_RELEASE_NO")] public string IqcReleaseNo { get; set; } /// <summary> /// 是否显示 /// </summary> [SugarColumn(ColumnName = "IS_VISUAL")] /// <summary> /// 是否显示 /// </summary> [SugarColumn(ColumnName = "IS_VISUAL")] public decimal? IsVisual { get; set; } /// <summary> /// 0=采购，1=委外 /// </summary> [SugarColumn(ColumnName = "F_TYPE")] /// <summary> /// 0=采购，1=委外 /// </summary> [SugarColumn(ColumnName = "F_TYPE")] public decimal? FType { get; set; } /// <summary> /// ERP到货单ID /// </summary> [SugarColumn(ColumnName = "EBELN_K3ID")] /// <summary> /// ERP到货单ID /// </summary> [SugarColumn(ColumnName = "EBELN_K3ID")] public string EbelnK3id { get; set; } /// <summary> /// 条码条印进度 /// </summary> [SugarColumn(ColumnName = "BARCODE_RATIO")] /// <summary> /// 条码条印进度 /// </summary> [SugarColumn(ColumnName = "BARCODE_RATIO")] public decimal? BarcodeRatio { get; set; } /// <summary> /// ERP单号 /// </summary> [SugarColumn(ColumnName = "ERPNO")] /// <summary> /// ERP单号 /// </summary> [SugarColumn(ColumnName = "ERPNO")] public string Erpno { get; set; } /// <summary> /// 是否已退货0-未退货，1-退货 /// </summary> [SugarColumn(ColumnName = "THSTATUS")] /// <summary> /// 是否已退货0-未退货，1-退货 /// </summary> [SugarColumn(ColumnName = "THSTATUS")] public short? Thstatus { get; set; } /// <summary> /// ERP退货单号 /// </summary> [SugarColumn(ColumnName = "ERPTHNO")] /// <summary> /// ERP退货单号 /// </summary> [SugarColumn(ColumnName = "ERPTHNO")] public string Erpthno { get; set; }
@@ -8,453 +8,453 @@ [SugarTable("MES_INV_ITEM_BARCODES")] public class MesInvItemBarcodes { /// <summary> /// SEQ_BARCODE_PSN_ID /// </summary> [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)] /// <summary> /// SEQ_BARCODE_PSN_ID /// </summary> [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)] public decimal Id { get; set; } /// <summary> /// 物料条码 /// </summary> [SugarColumn(ColumnName = "ITEM_BARCODE")] /// <summary> /// 物料条码 /// </summary> [SugarColumn(ColumnName = "ITEM_BARCODE")] public string ItemBarcode { get; set; } /// <summary> /// 客户成品编码 /// </summary> [SugarColumn(ColumnName = "C_PRODUCT_CODE")] /// <summary> /// 客户成品编码 /// </summary> [SugarColumn(ColumnName = "C_PRODUCT_CODE")] public string CProductCode { get; set; } /// <summary> /// 客户物料条码 /// </summary> [SugarColumn(ColumnName = "C_ITEM_BARCODE")] /// <summary> /// 客户物料条码 /// </summary> [SugarColumn(ColumnName = "C_ITEM_BARCODE")] public string CItemBarcode { get; set; } /// <summary> /// 客户物料编码 /// </summary> [SugarColumn(ColumnName = "C_ITEM_CODE")] /// <summary> /// 客户物料编码 /// </summary> [SugarColumn(ColumnName = "C_ITEM_CODE")] public string CItemCode { get; set; } /// <summary> /// 本司物料编码 /// </summary> [SugarColumn(ColumnName = "ITEM_NO")] /// <summary> /// 本司物料编码 /// </summary> [SugarColumn(ColumnName = "ITEM_NO")] public string ItemNo { get; set; } /// <summary> /// 厂家批次 /// </summary> [SugarColumn(ColumnName = "LOT_NO")] /// <summary> /// 厂家批次 /// </summary> [SugarColumn(ColumnName = "LOT_NO")] public string LotNo { get; set; } /// <summary> /// 数量 /// </summary> [SugarColumn(ColumnName = "QUANTITY")] /// <summary> /// 数量 /// </summary> [SugarColumn(ColumnName = "QUANTITY")] public decimal? Quantity { get; set; } /// <summary> /// 是否环保(0:否,1:是) /// </summary> [SugarColumn(ColumnName = "EP_FLAG")] /// <summary> /// 是否环保(0:否,1:是) /// </summary> [SugarColumn(ColumnName = "EP_FLAG")] public short? EpFlag { get; set; } /// <summary> /// 生产工单 /// </summary> [SugarColumn(ColumnName = "TASK_NO")] /// <summary> /// 生产工单 /// </summary> [SugarColumn(ColumnName = "TASK_NO")] public string TaskNo { get; set; } /// <summary> /// 创建人 /// </summary> [SugarColumn(ColumnName = "CREATE_BY")] /// <summary> /// 创建人 /// </summary> [SugarColumn(ColumnName = "CREATE_BY")] public string CreateBy { get; set; } /// <summary> /// 创建时间 /// </summary> [SugarColumn(ColumnName = "CREATE_DATE")] /// <summary> /// 创建时间 /// </summary> [SugarColumn(ColumnName = "CREATE_DATE")] public DateTime? CreateDate { get; set; } /// <summary> /// 最后更新人 /// </summary> [SugarColumn(ColumnName = "LASTUPDATE_BY")] /// <summary> /// 最后更新人 /// </summary> [SugarColumn(ColumnName = "LASTUPDATE_BY")] public string LastupdateBy { get; set; } /// <summary> /// 最后更新时间 /// </summary> [SugarColumn(ColumnName = "LASTUPDATE_DATE")] /// <summary> /// 最后更新时间 /// </summary> [SugarColumn(ColumnName = "LASTUPDATE_DATE")] public DateTime? LastupdateDate { get; set; } /// <summary> /// 客户编号 /// </summary> [SugarColumn(ColumnName = "CUST_NO")] /// <summary> /// 客户编号 /// </summary> [SugarColumn(ColumnName = "CUST_NO")] public string CustNo { get; set; } /// <summary> /// 物料条码注释行[冗余，条码重打使用] /// </summary> [SugarColumn(ColumnName = "ITEM_BARCODE_TEXT")] /// <summary> /// 物料条码注释行[冗余，条码重打使用] /// </summary> [SugarColumn(ColumnName = "ITEM_BARCODE_TEXT")] public string ItemBarcodeText { get; set; } /// <summary> /// 原PSN物料条码 /// </summary> [SugarColumn(ColumnName = "OLD_ITEM_BARCODE")] /// <summary> /// 原PSN物料条码 /// </summary> [SugarColumn(ColumnName = "OLD_ITEM_BARCODE")] public string OldItemBarcode { get; set; } /// <summary> /// SAP收货物料凭证号 --采购单号 /// </summary> [SugarColumn(ColumnName = "MBLNR")] /// <summary> /// SAP收货物料凭证号 --采购单号 /// </summary> [SugarColumn(ColumnName = "MBLNR")] public string Mblnr { get; set; } /// <summary> /// SAP收货物料凭证行号 --采购单行号 /// </summary> [SugarColumn(ColumnName = "ZEILE")] /// <summary> /// SAP收货物料凭证行号 --采购单行号 /// </summary> [SugarColumn(ColumnName = "ZEILE")] public decimal? Zeile { get; set; } /// <summary> /// 收料表ID /// </summary> [SugarColumn(ColumnName = "ROH_IN_ID")] /// <summary> /// 收料表ID /// </summary> [SugarColumn(ColumnName = "ROH_IN_ID")] public decimal? RohInId { get; set; } /// <summary> /// 0为有效条码；1为无效条码 /// </summary> [SugarColumn(ColumnName = "BARCODESTATUS")] /// <summary> /// 0为有效条码；1为无效条码 /// </summary> [SugarColumn(ColumnName = "BARCODESTATUS")] public short? Barcodestatus { get; set; } /// <summary> /// 原始数量 /// </summary> [SugarColumn(ColumnName = "OLDQTY")] /// <summary> /// 原始数量 /// </summary> [SugarColumn(ColumnName = "OLDQTY")] public decimal? Oldqty { get; set; } /// <summary> /// 使用数量 /// </summary> [SugarColumn(ColumnName = "USEQTY")] /// <summary> /// 使用数量 /// </summary> [SugarColumn(ColumnName = "USEQTY")] public decimal? Useqty { get; set; } /// <summary> /// 0在库，1在线，2作废 /// </summary> [SugarColumn(ColumnName = "LOCATION")] /// <summary> /// 0在库，1在线，2作废 /// </summary> [SugarColumn(ColumnName = "LOCATION")] public short? Location { get; set; } /// <summary> /// 单位 /// </summary> [SugarColumn(ColumnName = "UNIT")] /// <summary> /// 单位 /// </summary> [SugarColumn(ColumnName = "UNIT")] public string Unit { get; set; } /// <summary> /// 重量（单位：公斤） /// </summary> [SugarColumn(ColumnName = "WEIGHT_UNIT")] /// <summary> /// 重量（单位：公斤） /// </summary> [SugarColumn(ColumnName = "WEIGHT_UNIT")] public decimal? WeightUnit { get; set; } /// <summary> /// 单价 /// </summary> [SugarColumn(ColumnName = "PRICE")] /// <summary> /// 单价 /// </summary> [SugarColumn(ColumnName = "PRICE")] public decimal? Price { get; set; } /// <summary> /// 原条码数量 /// </summary> [SugarColumn(ColumnName = "OLD_BAR_QUANTITY")] /// <summary> /// 原条码数量 /// </summary> [SugarColumn(ColumnName = "OLD_BAR_QUANTITY")] public decimal? OldBarQuantity { get; set; } /// <summary> /// 汇总条码 /// </summary> [SugarColumn(ColumnName = "SUM_BARCODE")] /// <summary> /// 汇总条码 /// </summary> [SugarColumn(ColumnName = "SUM_BARCODE")] public string SumBarcode { get; set; } /// <summary> /// 生产日期 /// </summary> [SugarColumn(ColumnName = "LOT_DATE")] /// <summary> /// 生产日期 /// </summary> [SugarColumn(ColumnName = "LOT_DATE")] public string LotDate { get; set; } /// <summary> /// 模号 /// </summary> [SugarColumn(ColumnName = "MOCODE")] /// <summary> /// 模号 /// </summary> [SugarColumn(ColumnName = "MOCODE")] public string Mocode { get; set; } /// <summary> /// 来源 /// </summary> [SugarColumn(ColumnName = "MEMO")] /// <summary> /// 来源 /// </summary> [SugarColumn(ColumnName = "MEMO")] public string Memo { get; set; } /// <summary> /// 供应商编码 /// </summary> [SugarColumn(ColumnName = "SUPP_NO")] /// <summary> /// 供应商编码 /// </summary> [SugarColumn(ColumnName = "SUPP_NO")] public string SuppNo { get; set; } /// <summary> /// 档位低值 /// </summary> [SugarColumn(ColumnName = "SPOSTION")] /// <summary> /// 档位低值 /// </summary> [SugarColumn(ColumnName = "SPOSTION")] public string Spostion { get; set; } /// <summary> /// 档位高值 /// </summary> [SugarColumn(ColumnName = "EPOSTION")] /// <summary> /// 档位高值 /// </summary> [SugarColumn(ColumnName = "EPOSTION")] public string Epostion { get; set; } /// <summary> /// 物料简称 /// </summary> [SugarColumn(ColumnName = "ITEM_SNAME")] /// <summary> /// 物料简称 /// </summary> [SugarColumn(ColumnName = "ITEM_SNAME")] public string ItemSname { get; set; } /// <summary> /// 是否已冻结,1冻结 /// </summary> [SugarColumn(ColumnName = "VISABLE")] /// <summary> /// 是否已冻结,1冻结 /// </summary> [SugarColumn(ColumnName = "VISABLE")] public short? Visable { get; set; } /// <summary> /// 供应商批次 /// </summary> [SugarColumn(ColumnName = "TR_LOTNO")] /// <summary> /// 供应商批次 /// </summary> [SugarColumn(ColumnName = "TR_LOTNO")] public string TrLotno { get; set; } /// <summary> /// 冻结时间 /// </summary> [SugarColumn(ColumnName = "FLEZZ_DATE")] /// <summary> /// 冻结时间 /// </summary> [SugarColumn(ColumnName = "FLEZZ_DATE")] public DateTime? FlezzDate { get; set; } /// <summary> /// 冻结原因 /// </summary> [SugarColumn(ColumnName = "FLEZZ_REASON")] /// <summary> /// 冻结原因 /// </summary> [SugarColumn(ColumnName = "FLEZZ_REASON")] public string FlezzReason { get; set; } /// <summary> /// 冻结人 /// </summary> [SugarColumn(ColumnName = "FLEZZ_BY")] /// <summary> /// 冻结人 /// </summary> [SugarColumn(ColumnName = "FLEZZ_BY")] public string FlezzBy { get; set; } /// <summary> /// 延长保质期 /// </summary> [SugarColumn(ColumnName = "DELANY_MONTH")] /// <summary> /// 延长保质期 /// </summary> [SugarColumn(ColumnName = "DELANY_MONTH")] public decimal? DelanyMonth { get; set; } /// <summary> /// 最小包装标识 /// </summary> [SugarColumn(ColumnName = "MINPACK_FLAG")] /// <summary> /// 最小包装标识 /// </summary> [SugarColumn(ColumnName = "MINPACK_FLAG")] public short? MinpackFlag { get; set; } /// <summary> /// 打印ID，用来区分打印次数 /// </summary> [SugarColumn(ColumnName = "PRINT_ID")] /// <summary> /// 打印ID，用来区分打印次数 /// </summary> [SugarColumn(ColumnName = "PRINT_ID")] public string PrintId { get; set; } /// <summary> /// 环保项目 /// </summary> [SugarColumn(ColumnName = "EP_ITEM")] /// <summary> /// 环保项目 /// </summary> [SugarColumn(ColumnName = "EP_ITEM")] public string EpItem { get; set; } /// <summary> /// 工厂编号 /// </summary> [SugarColumn(ColumnName = "FACTORY")] /// <summary> /// 工厂编号 /// </summary> [SugarColumn(ColumnName = "FACTORY")] public string Factory { get; set; } /// <summary> /// 公司编号 /// </summary> [SugarColumn(ColumnName = "COMPANY")] /// <summary> /// 公司编号 /// </summary> [SugarColumn(ColumnName = "COMPANY")] public string Company { get; set; } /// <summary> /// 卡板编码 /// </summary> [SugarColumn(ColumnName = "CB_NO")] /// <summary> /// 卡板编码 /// </summary> [SugarColumn(ColumnName = "CB_NO")] public string CbNo { get; set; } /// <summary> /// 厂家生产线 /// </summary> [SugarColumn(ColumnName = "LINFLINE")] /// <summary> /// 厂家生产线 /// </summary> [SugarColumn(ColumnName = "LINFLINE")] public string Linfline { get; set; } /// <summary> /// 有效期 /// </summary> [SugarColumn(ColumnName = "VALID_TIME")] /// <summary> /// 有效期 /// </summary> [SugarColumn(ColumnName = "VALID_TIME")] public DateTime? ValidTime { get; set; } /// <summary> /// 质检结果 /// </summary> [SugarColumn(ColumnName = "IQC_STATUS")] /// <summary> /// 质检结果 /// </summary> [SugarColumn(ColumnName = "IQC_STATUS")] public string IqcStatus { get; set; } /// <summary> /// 小车条码 /// </summary> [SugarColumn(ColumnName = "FCAR")] /// <summary> /// 小车条码 /// </summary> [SugarColumn(ColumnName = "FCAR")] public string Fcar { get; set; } /// <summary> /// 毛重 /// </summary> [SugarColumn(ColumnName = "GWEIGHT")] /// <summary> /// 毛重 /// </summary> [SugarColumn(ColumnName = "GWEIGHT")] public string Gweight { get; set; } /// <summary> /// 净重 /// </summary> [SugarColumn(ColumnName = "NWEIGHT")] /// <summary> /// 净重 /// </summary> [SugarColumn(ColumnName = "NWEIGHT")] public string Nweight { get; set; } /// <summary> /// 保质期 /// </summary> [SugarColumn(ColumnName = "EXT_DATE")] /// <summary> /// 保质期 /// </summary> [SugarColumn(ColumnName = "EXT_DATE")] public decimal? ExtDate { get; set; } /// <summary> /// 供应商、赠品、客供料、委外 /// </summary> [SugarColumn(ColumnName = "BARCODETYPE")] /// <summary> /// 供应商、赠品、客供料、委外 /// </summary> [SugarColumn(ColumnName = "BARCODETYPE")] public string Barcodetype { get; set; } /// <summary> /// 供应商名称 /// </summary> [SugarColumn(ColumnName = "SUPP_NAME")] /// <summary> /// 供应商名称 /// </summary> [SugarColumn(ColumnName = "SUPP_NAME")] public string SuppName { get; set; } /// <summary> /// 到货单号/入库单号 /// </summary> [SugarColumn(ColumnName = "BILL_NO")] /// <summary> /// 到货单号/入库单号 /// </summary> [SugarColumn(ColumnName = "BILL_NO")] public string BillNo { get; set; } /// <summary> /// 急料标识 /// </summary> [SugarColumn(ColumnName = "URGENT_FLAG")] /// <summary> /// 急料标识 /// </summary> [SugarColumn(ColumnName = "URGENT_FLAG")] public short? UrgentFlag { get; set; } /// <summary> /// 颜色 /// </summary> [SugarColumn(ColumnName = "COLOR_NAME")] /// <summary> /// 颜色 /// </summary> [SugarColumn(ColumnName = "COLOR_NAME")] public string ColorName { get; set; } /// <summary> /// 产品型号 /// </summary> [SugarColumn(ColumnName = "BOARD_STYLE")] /// <summary> /// 产品型号 /// </summary> [SugarColumn(ColumnName = "BOARD_STYLE")] public string BoardStyle { get; set; } /// <summary> /// 来料日期 /// </summary> [SugarColumn(ColumnName = "INS_DATE")] /// <summary> /// 来料日期 /// </summary> [SugarColumn(ColumnName = "INS_DATE")] public DateTime? InsDate { get; set; } /// <summary> /// 到货单行号 /// </summary> [SugarColumn(ColumnName = "WORK_LINE")] /// <summary> /// 到货单行号 /// </summary> [SugarColumn(ColumnName = "WORK_LINE")] public decimal? WorkLine { get; set; } /// <summary> /// 不良原因 /// </summary> [SugarColumn(ColumnName = "MEMO_BAD")] /// <summary> /// 不良原因 /// </summary> [SugarColumn(ColumnName = "MEMO_BAD")] public string MemoBad { get; set; } /// <summary> /// 任务单号 /// </summary> [SugarColumn(ColumnName = "WORK_NO")] /// <summary> /// 任务单号 /// </summary> [SugarColumn(ColumnName = "WORK_NO")] public string WorkNo { get; set; } /// <summary> /// 条码来源标识，0-初期物料,1-采购入库，2、生产退料，3、其它入库，4-客供料,5-在库分料，6-制程条码 /// </summary> [SugarColumn(ColumnName = "COME_FLG")] /// <summary> /// 条码来源标识，0-初期物料,1-采购入库，2、生产退料，3、其它入库，4-客供料,5-在库分料，6-制程条码 /// </summary> [SugarColumn(ColumnName = "COME_FLG")] public short? ComeFlg { get; set; } /// <summary> /// 生产线体 /// </summary> [SugarColumn(ColumnName = "LINE_NO")] /// <summary> /// 生产线体 /// </summary> [SugarColumn(ColumnName = "LINE_NO")] public string LineNo { get; set; } /// <summary> /// 丝印次数 /// </summary> [SugarColumn(ColumnName = "SILK_PQTY")] /// <summary> /// 丝印次数 /// </summary> [SugarColumn(ColumnName = "SILK_PQTY")] public decimal? SilkPqty { get; set; } /// <summary> /// 丝印次数比 /// </summary> [SugarColumn(ColumnName = "SILK")] /// <summary> /// 丝印次数比 /// </summary> [SugarColumn(ColumnName = "SILK")] public string Silk { get; set; } /// <summary> /// 丝印派工从表ID /// </summary> [SugarColumn(ColumnName = "SILK_ID")] /// <summary> /// 丝印派工从表ID /// </summary> [SugarColumn(ColumnName = "SILK_ID")] public decimal? SilkId { get; set; } /// <summary> /// 已报工标识 /// </summary> [SugarColumn(ColumnName = "WORK_FLG")] /// <summary> /// 已报工标识 /// </summary> [SugarColumn(ColumnName = "WORK_FLG")] public decimal? WorkFlg { get; set; } /// <summary> /// 最后工序 /// </summary> [SugarColumn(ColumnName = "WORK_LAST")] /// <summary> /// 最后工序 /// </summary> [SugarColumn(ColumnName = "WORK_LAST")] public decimal? WorkLast { get; set; } /// <summary> /// 0-未合并打印，1-合并打印 /// </summary> [SugarColumn(ColumnName = "HBDY")] /// <summary> /// 0-未合并打印，1-合并打印 /// </summary> [SugarColumn(ColumnName = "HBDY")] public decimal? Hbdy { get; set; } /// <summary> /// 0-有效条码，1-合并拆分的条码，无效 /// </summary> [SugarColumn(ColumnName = "HBDYTM")] /// <summary> /// 0-有效条码，1-合并拆分的条码，无效 /// </summary> [SugarColumn(ColumnName = "HBDYTM")] public decimal? Hbdytm { get; set; } /// <summary> /// 报工时间 /// </summary> [SugarColumn(ColumnName = "WORK_FLGTIME")] /// <summary> /// 报工时间 /// </summary> [SugarColumn(ColumnName = "WORK_FLGTIME")] public string WorkFlgtime { get; set; } } MES.Service/Modes/MesInvItemInCItems.cs
@@ -8,141 +8,141 @@ [SugarTable("MES_INV_ITEM_IN_C_ITEMS")] public class MesInvItemInCItems { /// <summary> /// SEQ_OUT /// </summary> [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)] /// <summary> /// SEQ_OUT /// </summary> [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)] public decimal Id { get; set; } /// <summary> /// 入库单id /// </summary> [SugarColumn(ColumnName = "ITEM_IN_ID", IsPrimaryKey = true)] /// <summary> /// 入库单id /// </summary> [SugarColumn(ColumnName = "ITEM_IN_ID", IsPrimaryKey = true)] public decimal ItemInId { get; set; } /// <summary> /// 验收数量 /// </summary> [SugarColumn(ColumnName = "QUANTITY")] /// <summary> /// 验收数量 /// </summary> [SugarColumn(ColumnName = "QUANTITY")] public decimal? Quantity { get; set; } /// <summary> /// 创建人 /// </summary> [SugarColumn(ColumnName = "CREATE_BY")] /// <summary> /// 创建人 /// </summary> [SugarColumn(ColumnName = "CREATE_BY")] public string CreateBy { get; set; } /// <summary> /// 创建时间 /// </summary> [SugarColumn(ColumnName = "CREATE_DATE")] /// <summary> /// 创建时间 /// </summary> [SugarColumn(ColumnName = "CREATE_DATE")] public DateTime? CreateDate { get; set; } /// <summary> /// 最后更新人 /// </summary> [SugarColumn(ColumnName = "LASTUPDATE_BY")] /// <summary> /// 最后更新人 /// </summary> [SugarColumn(ColumnName = "LASTUPDATE_BY")] public string LastupdateBy { get; set; } /// <summary> /// 最后更新时间 /// </summary> [SugarColumn(ColumnName = "LASTUPDATE_DATE")] /// <summary> /// 最后更新时间 /// </summary> [SugarColumn(ColumnName = "LASTUPDATE_DATE")] public DateTime? LastupdateDate { get; set; } /// <summary> /// 物料编码 /// </summary> [SugarColumn(ColumnName = "ITEM_NO")] /// <summary> /// 物料编码 /// </summary> [SugarColumn(ColumnName = "ITEM_NO")] public string ItemNo { get; set; } /// <summary> /// 仓库编码 /// </summary> [SugarColumn(ColumnName = "DEPOT_CODE")] /// <summary> /// 仓库编码 /// </summary> [SugarColumn(ColumnName = "DEPOT_CODE")] public string DepotCode { get; set; } /// <summary> /// 货位编码 /// </summary> [SugarColumn(ColumnName = "DEPOT_SECTION_CODE")] /// <summary> /// 货位编码 /// </summary> [SugarColumn(ColumnName = "DEPOT_SECTION_CODE")] public string DepotSectionCode { get; set; } /// <summary> /// 特记事项 /// </summary> [SugarColumn(ColumnName = "REMARK")] /// <summary> /// 特记事项 /// </summary> [SugarColumn(ColumnName = "REMARK")] public string Remark { get; set; } /// <summary> /// 物料简称 /// </summary> [SugarColumn(ColumnName = "ITEM_SNAME")] /// <summary> /// 物料简称 /// </summary> [SugarColumn(ColumnName = "ITEM_SNAME")] public string ItemSname { get; set; } /// <summary> /// 单位 /// </summary> [SugarColumn(ColumnName = "UNIT")] /// <summary> /// 单位 /// </summary> [SugarColumn(ColumnName = "UNIT")] public string Unit { get; set; } /// <summary> /// 采购订单 /// </summary> [SugarColumn(ColumnName = "EBELN")] /// <summary> /// 采购订单 /// </summary> [SugarColumn(ColumnName = "EBELN")] public string Ebeln { get; set; } /// <summary> /// 入库单号 /// </summary> [SugarColumn(ColumnName = "BILL_NO")] /// <summary> /// 入库单号 /// </summary> [SugarColumn(ColumnName = "BILL_NO")] public string BillNo { get; set; } /// <summary> /// 分厂编码 /// </summary> [SugarColumn(ColumnName = "FACTORY")] /// <summary> /// 分厂编码 /// </summary> [SugarColumn(ColumnName = "FACTORY")] public string Factory { get; set; } /// <summary> /// 公司代码 /// </summary> [SugarColumn(ColumnName = "COMPANY")] /// <summary> /// 公司代码 /// </summary> [SugarColumn(ColumnName = "COMPANY")] public string Company { get; set; } /// <summary> /// 任务单号 /// </summary> [SugarColumn(ColumnName = "WORK_NO")] /// <summary> /// 任务单号 /// </summary> [SugarColumn(ColumnName = "WORK_NO")] public string WorkNo { get; set; } /// <summary> /// 行号 /// </summary> [SugarColumn(ColumnName = "EBELN_LINE_NO")] /// <summary> /// 行号 /// </summary> [SugarColumn(ColumnName = "EBELN_LINE_NO")] public decimal? EbelnLineNo { get; set; } /// <summary> /// 到货单号 /// </summary> [SugarColumn(ColumnName = "CBILL_NO")] /// <summary> /// 到货单号 /// </summary> [SugarColumn(ColumnName = "CBILL_NO")] public string CbillNo { get; set; } /// <summary> /// 任务单行号 /// </summary> [SugarColumn(ColumnName = "WORK_LINE")] /// <summary> /// 任务单行号 /// </summary> [SugarColumn(ColumnName = "WORK_LINE")] public decimal? WorkLine { get; set; } /// <summary> /// 生产工单 /// </summary> [SugarColumn(ColumnName = "TASK_NO")] /// <summary> /// 生产工单 /// </summary> [SugarColumn(ColumnName = "TASK_NO")] public string TaskNo { get; set; } /// <summary> /// 供应商 /// </summary> [SugarColumn(ColumnName = "SUPP_NO")] /// <summary> /// 供应商 /// </summary> [SugarColumn(ColumnName = "SUPP_NO")] public string SuppNo { get; set; } } MES.Service/Modes/MesInvItemMoves.cs
@@ -8,171 +8,171 @@ [SugarTable("MES_INV_ITEM_MOVES")] public class MesInvItemMoves { /// <summary> /// SEQ_INV_ID /// </summary> [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)] /// <summary> /// SEQ_INV_ID /// </summary> [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)] public decimal Id { get; set; } /// <summary> /// 移库单号 /// </summary> [SugarColumn(ColumnName = "BILL_NO")] /// <summary> /// 移库单号 /// </summary> [SugarColumn(ColumnName = "BILL_NO")] public string BillNo { get; set; } /// <summary> /// 移入子库id /// </summary> [SugarColumn(ColumnName = "INV_DEPOTS_ID")] /// <summary> /// 移入子库id /// </summary> [SugarColumn(ColumnName = "INV_DEPOTS_ID")] public decimal? InvDepotsId { get; set; } /// <summary> /// 移入货位id /// </summary> [SugarColumn(ColumnName = "INV_DEPOT_SECTIONS_ID")] /// <summary> /// 移入货位id /// </summary> [SugarColumn(ColumnName = "INV_DEPOT_SECTIONS_ID")] public decimal? InvDepotSectionsId { get; set; } /// <summary> /// 创建人 /// </summary> [SugarColumn(ColumnName = "CREATE_BY")] /// <summary> /// 创建人 /// </summary> [SugarColumn(ColumnName = "CREATE_BY")] public string CreateBy { get; set; } /// <summary> /// 创建时间 /// </summary> [SugarColumn(ColumnName = "CREATE_DATE")] /// <summary> /// 创建时间 /// </summary> [SugarColumn(ColumnName = "CREATE_DATE")] public DateTime? CreateDate { get; set; } /// <summary> /// 最后更新人 /// </summary> [SugarColumn(ColumnName = "LASTUPDATE_BY")] /// <summary> /// 最后更新人 /// </summary> [SugarColumn(ColumnName = "LASTUPDATE_BY")] public string LastupdateBy { get; set; } /// <summary> /// 最后更新时间 /// </summary> [SugarColumn(ColumnName = "LASTUPDATE_DATE")] /// <summary> /// 最后更新时间 /// </summary> [SugarColumn(ColumnName = "LASTUPDATE_DATE")] public DateTime? LastupdateDate { get; set; } /// <summary> /// 状态|0-制单1-过账 /// </summary> [SugarColumn(ColumnName = "STATUS")] /// <summary> /// 状态|0-制单1-过账 /// </summary> [SugarColumn(ColumnName = "STATUS")] public decimal? Status { get; set; } /// <summary> /// 备注 /// </summary> [SugarColumn(ColumnName = "REMARK")] /// <summary> /// 备注 /// </summary> [SugarColumn(ColumnName = "REMARK")] public string Remark { get; set; } /// <summary> /// 单据类型ID /// </summary> [SugarColumn(ColumnName = "BILL_TYPE_ID")] /// <summary> /// 单据类型ID /// </summary> [SugarColumn(ColumnName = "BILL_TYPE_ID")] public decimal? BillTypeId { get; set; } /// <summary> /// 事务类型ID /// </summary> [SugarColumn(ColumnName = "TRANSACTION_ID")] /// <summary> /// 事务类型ID /// </summary> [SugarColumn(ColumnName = "TRANSACTION_ID")] public decimal? TransactionId { get; set; } /// <summary> /// 审核人 /// </summary> [SugarColumn(ColumnName = "CHECKUSER")] /// <summary> /// 审核人 /// </summary> [SugarColumn(ColumnName = "CHECKUSER")] public string Checkuser { get; set; } /// <summary> /// 审核日期 /// </summary> [SugarColumn(ColumnName = "CHECKDATE")] /// <summary> /// 审核日期 /// </summary> [SugarColumn(ColumnName = "CHECKDATE")] public DateTime? Checkdate { get; set; } /// <summary> /// 移入子库code /// </summary> [SugarColumn(ColumnName = "INV_DEPOTS_CODE")] /// <summary> /// 移入子库code /// </summary> [SugarColumn(ColumnName = "INV_DEPOTS_CODE")] public string InvDepotsCode { get; set; } /// <summary> /// 移入货位code /// </summary> [SugarColumn(ColumnName = "INV_DEPOT_SECTIONS_CODE")] /// <summary> /// 移入货位code /// </summary> [SugarColumn(ColumnName = "INV_DEPOT_SECTIONS_CODE")] public string InvDepotSectionsCode { get; set; } /// <summary> /// 事务类型编码 /// </summary> [SugarColumn(ColumnName = "TRANSACTION_NO")] /// <summary> /// 事务类型编码 /// </summary> [SugarColumn(ColumnName = "TRANSACTION_NO")] public decimal? TransactionNo { get; set; } /// <summary> /// 移出子库code /// </summary> [SugarColumn(ColumnName = "FROM_DEPOTS_CODE")] /// <summary> /// 移出子库code /// </summary> [SugarColumn(ColumnName = "FROM_DEPOTS_CODE")] public string FromDepotsCode { get; set; } /// <summary> /// 工厂编码 /// </summary> [SugarColumn(ColumnName = "FACTORY_CODE")] /// <summary> /// 工厂编码 /// </summary> [SugarColumn(ColumnName = "FACTORY_CODE")] public string FactoryCode { get; set; } /// <summary> /// SAP返回单据 /// </summary> [SugarColumn(ColumnName = "SAPNO")] /// <summary> /// SAP返回单据 /// </summary> [SugarColumn(ColumnName = "SAPNO")] public string Sapno { get; set; } /// <summary> /// 已回写SAP /// </summary> [SugarColumn(ColumnName = "SAPSTATUS")] /// <summary> /// 已回写SAP /// </summary> [SugarColumn(ColumnName = "SAPSTATUS")] public short? Sapstatus { get; set; } /// <summary> /// SAP返回年份 /// </summary> [SugarColumn(ColumnName = "SAPYEAR")] /// <summary> /// SAP返回年份 /// </summary> [SugarColumn(ColumnName = "SAPYEAR")] public short? Sapyear { get; set; } /// <summary> /// SAP返回信息 /// </summary> [SugarColumn(ColumnName = "SAPTEXT")] /// <summary> /// SAP返回信息 /// </summary> [SugarColumn(ColumnName = "SAPTEXT")] public string Saptext { get; set; } /// <summary> /// 分厂编码 /// </summary> [SugarColumn(ColumnName = "FACTORY")] /// <summary> /// 分厂编码 /// </summary> [SugarColumn(ColumnName = "FACTORY")] public string Factory { get; set; } /// <summary> /// 公司代码 /// </summary> [SugarColumn(ColumnName = "COMPANY")] /// <summary> /// 公司代码 /// </summary> [SugarColumn(ColumnName = "COMPANY")] public string Company { get; set; } /// <summary> /// 反审核事务类型编码 /// </summary> [SugarColumn(ColumnName = "MTRANSACTION_NO")] /// <summary> /// 反审核事务类型编码 /// </summary> [SugarColumn(ColumnName = "MTRANSACTION_NO")] public decimal? MtransactionNo { get; set; } /// <summary> /// 自动保存字段 /// </summary> [SugarColumn(ColumnName = "ZD_NUM")] /// <summary> /// 自动保存字段 /// </summary> [SugarColumn(ColumnName = "ZD_NUM")] public decimal? ZdNum { get; set; } /// <summary> /// 是否推送ERP1-是，2-否 /// </summary> [SugarColumn(ColumnName = "TS")] /// <summary> /// 是否推送ERP1-是，2-否 /// </summary> [SugarColumn(ColumnName = "TS")] public decimal? Ts { get; set; } } MES.Service/Modes/MesInvItemMovesCDetails.cs
@@ -8,224 +8,225 @@ [SugarTable("MES_INV_ITEM_MOVES_C_DETAILS")] public class MesInvItemMovesCDetails { /// <summary> /// seq_inv_id /// </summary> [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)] /// <summary> /// seq_inv_id /// </summary> [SugarColumn(ColumnName = "ID", OracleSequenceName = "SEQ_INV_ID", IsPrimaryKey = true)] public decimal Id { get; set; } /// <summary> /// </summary> [SugarColumn(ColumnName = "ITEM_MOVE_ID")] /// <summary> /// </summary> [SugarColumn(ColumnName = "ITEM_MOVE_ID")] public decimal? ItemMoveId { get; set; } /// <summary> /// 物料条码 /// </summary> [SugarColumn(ColumnName = "ITEM_BARCODE")] public string ItemBarcode { get; set; } /// <summary> /// 物料条码 /// </summary> [SugarColumn(ColumnName = "ITEM_BARCODE")] public string? ItemBarcode { get; set; } /// <summary> /// 客户物料编码（无条码手工录入，有条码为冗余字段） /// </summary> [SugarColumn(ColumnName = "C_ITEM_CODE")] public string CItemCode { get; set; } /// <summary> /// 客户物料编码（无条码手工录入，有条码为冗余字段） /// </summary> [SugarColumn(ColumnName = "C_ITEM_CODE")] public string? CItemCode { get; set; } /// <summary> /// 信华物料编码（无条码手工录入，有条码为冗余字段） /// </summary> [SugarColumn(ColumnName = "ITEM_NO")] public string ItemNo { get; set; } /// <summary> /// 信华物料编码（无条码手工录入，有条码为冗余字段） /// </summary> [SugarColumn(ColumnName = "ITEM_NO")] public string? ItemNo { get; set; } /// <summary> /// 厂家批次 /// </summary> [SugarColumn(ColumnName = "LOT_NO")] public string LotNo { get; set; } /// <summary> /// 厂家批次 /// </summary> [SugarColumn(ColumnName = "LOT_NO")] public string? LotNo { get; set; } /// <summary> /// 数量（无条码手工录入，有条码为冗余字段） /// </summary> [SugarColumn(ColumnName = "QUANTITY")] /// <summary> /// 数量（无条码手工录入，有条码为冗余字段） /// </summary> [SugarColumn(ColumnName = "QUANTITY")] public decimal? Quantity { get; set; } /// <summary> /// 出库方式(1:有条码,0:无条码) /// </summary> [SugarColumn(ColumnName = "BARCODE_FLAG")] /// <summary> /// 出库方式(1:有条码,0:无条码) /// </summary> [SugarColumn(ColumnName = "BARCODE_FLAG")] public short? BarcodeFlag { get; set; } /// <summary> /// 环保标志（无条码手工录入，有条码为冗余字段） /// </summary> [SugarColumn(ColumnName = "EP_FLAG")] /// <summary> /// 环保标志（无条码手工录入，有条码为冗余字段） /// </summary> [SugarColumn(ColumnName = "EP_FLAG")] public short? EpFlag { get; set; } /// <summary> /// 创建人 /// </summary> [SugarColumn(ColumnName = "CREATE_BY")] public string CreateBy { get; set; } /// <summary> /// 创建人 /// </summary> [SugarColumn(ColumnName = "CREATE_BY")] public string? CreateBy { get; set; } /// <summary> /// 创建时间 /// </summary> [SugarColumn(ColumnName = "CREATE_DATE")] /// <summary> /// 创建时间 /// </summary> [SugarColumn(ColumnName = "CREATE_DATE")] public DateTime? CreateDate { get; set; } /// <summary> /// 最后更新人 /// </summary> [SugarColumn(ColumnName = "LASTUPDATE_BY")] public string LastupdateBy { get; set; } /// <summary> /// 最后更新人 /// </summary> [SugarColumn(ColumnName = "LASTUPDATE_BY")] public string? LastupdateBy { get; set; } /// <summary> /// 最后更新时间 /// </summary> [SugarColumn(ColumnName = "LASTUPDATE_DATE")] /// <summary> /// 最后更新时间 /// </summary> [SugarColumn(ColumnName = "LASTUPDATE_DATE")] public DateTime? LastupdateDate { get; set; } /// <summary> /// 子库id /// </summary> [SugarColumn(ColumnName = "INV_DEPOTS_ID")] /// <summary> /// 子库id /// </summary> [SugarColumn(ColumnName = "INV_DEPOTS_ID")] public decimal? InvDepotsId { get; set; } /// <summary> /// 货位id /// </summary> [SugarColumn(ColumnName = "INV_DEPOT_SECTIONS_ID")] /// <summary> /// 货位id /// </summary> [SugarColumn(ColumnName = "INV_DEPOT_SECTIONS_ID")] public decimal? InvDepotSectionsId { get; set; } /// <summary> /// 客户编码 /// </summary> [SugarColumn(ColumnName = "CUST_NO")] public string CustNo { get; set; } /// <summary> /// 客户编码 /// </summary> [SugarColumn(ColumnName = "CUST_NO")] public string? CustNo { get; set; } /// <summary> /// 任务令号 /// </summary> [SugarColumn(ColumnName = "TASK_NO")] public string TaskNo { get; set; } /// <summary> /// 任务令号 /// </summary> [SugarColumn(ColumnName = "TASK_NO")] public string? TaskNo { get; set; } /// <summary> /// 移出仓库编号 /// </summary> [SugarColumn(ColumnName = "FROM_DEPOTS_CODE")] public string FromDepotsCode { get; set; } /// <summary> /// 移出仓库编号 /// </summary> [SugarColumn(ColumnName = "FROM_DEPOTS_CODE")] public string? FromDepotsCode { get; set; } /// <summary> /// 移出库位编号 /// </summary> [SugarColumn(ColumnName = "FROM_DEPOT_SECTIONS_CODE")] public string FromDepotSectionsCode { get; set; } /// <summary> /// 移出库位编号 /// </summary> [SugarColumn(ColumnName = "FROM_DEPOT_SECTIONS_CODE")] public string? FromDepotSectionsCode { get; set; } /// <summary> /// 条码备注 /// </summary> [SugarColumn(ColumnName = "REMARK")] public string Remark { get; set; } /// <summary> /// 条码备注 /// </summary> [SugarColumn(ColumnName = "REMARK")] public string? Remark { get; set; } /// <summary> /// 分厂编码 /// </summary> [SugarColumn(ColumnName = "FACTORY")] public string Factory { get; set; } /// <summary> /// 分厂编码 /// </summary> [SugarColumn(ColumnName = "FACTORY")] public string? Factory { get; set; } /// <summary> /// 公司代码 /// </summary> [SugarColumn(ColumnName = "COMPANY")] public string Company { get; set; } /// <summary> /// 公司代码 /// </summary> [SugarColumn(ColumnName = "COMPANY")] public string? Company { get; set; } /// <summary> /// 箱号 /// </summary> [SugarColumn(ColumnName = "BOX_NO")] public string BoxNo { get; set; } /// <summary> /// 箱号 /// </summary> [SugarColumn(ColumnName = "BOX_NO")] public string? BoxNo { get; set; } /// <summary> /// 卡板号 /// </summary> [SugarColumn(ColumnName = "KO_NO")] public string KoNo { get; set; } /// <summary> /// 卡板号 /// </summary> [SugarColumn(ColumnName = "KO_NO")] public string? KoNo { get; set; } /// <summary> /// 移入仓库编号 /// </summary> [SugarColumn(ColumnName = "INV_DEPOTS_CODE")] public string InvDepotsCode { get; set; } /// <summary> /// 移入仓库编号 /// </summary> [SugarColumn(ColumnName = "INV_DEPOTS_CODE")] public string? InvDepotsCode { get; set; } /// <summary> /// 移入库位编号 /// </summary> [SugarColumn(ColumnName = "INV_DEPOT_SECTIONS_CODE")] public string InvDepotSectionsCode { get; set; } /// <summary> /// 移入库位编号 /// </summary> [SugarColumn(ColumnName = "INV_DEPOT_SECTIONS_CODE")] public string? InvDepotSectionsCode { get; set; } /// <summary> /// 质检结果 /// </summary> [SugarColumn(ColumnName = "IQC_STATUS")] public string IqcStatus { get; set; } /// <summary> /// 质检结果 /// </summary> [SugarColumn(ColumnName = "IQC_STATUS")] public string? IqcStatus { get; set; } /// <summary> /// 小车编号 /// </summary> [SugarColumn(ColumnName = "FCAR")] public string Fcar { get; set; } /// <summary> /// 小车编号 /// </summary> [SugarColumn(ColumnName = "FCAR")] public string? Fcar { get; set; } /// <summary> /// 入库日期 /// </summary> [SugarColumn(ColumnName = "INDEP_DATE")] /// <summary> /// 入库日期 /// </summary> [SugarColumn(ColumnName = "INDEP_DATE")] public DateTime? IndepDate { get; set; } /// <summary> /// 冻结提交重检，0：冻结未提交重检，1：冻结并提交重检 /// </summary> [SugarColumn(ColumnName = "VISABLE_SUBMIT")] /// <summary> /// 冻结提交重检，0：冻结未提交重检，1：冻结并提交重检 /// </summary> [SugarColumn(ColumnName = "VISABLE_SUBMIT")] public short? VisableSubmit { get; set; } /// <summary> /// 提交重检人 /// </summary> [SugarColumn(ColumnName = "VISABLE_SUBMIT_BY")] public string VisableSubmitBy { get; set; } /// <summary> /// 提交重检人 /// </summary> [SugarColumn(ColumnName = "VISABLE_SUBMIT_BY")] public string? VisableSubmitBy { get; set; } /// <summary> /// 提交重检时间 /// </summary> [SugarColumn(ColumnName = "VISABLE_SUBMIT_DATE")] /// <summary> /// 提交重检时间 /// </summary> [SugarColumn(ColumnName = "VISABLE_SUBMIT_DATE")] public DateTime? VisableSubmitDate { get; set; } /// <summary> /// 产品型号 /// </summary> [SugarColumn(ColumnName = "BOARD_STYLE")] public string BoardStyle { get; set; } /// <summary> /// 产品型号 /// </summary> [SugarColumn(ColumnName = "BOARD_STYLE")] public string? BoardStyle { get; set; } /// <summary> /// 任务单号 /// </summary> [SugarColumn(ColumnName = "WORK_NO")] public string WorkNo { get; set; } /// <summary> /// 任务单号 /// </summary> [SugarColumn(ColumnName = "WORK_NO")] public string? WorkNo { get; set; } /// <summary> /// 任务单行号 /// </summary> [SugarColumn(ColumnName = "WORK_LINE")] /// <summary> /// 任务单行号 /// </summary> [SugarColumn(ColumnName = "WORK_LINE")] public decimal? WorkLine { get; set; } /// <summary> /// 供应商编号 /// </summary> [SugarColumn(ColumnName = "SUPP_NO")] public string SuppNo { get; set; } /// <summary> /// 供应商编号 /// </summary> [SugarColumn(ColumnName = "SUPP_NO")] public string? SuppNo { get; set; } /// <summary> /// 调入 /// </summary> [SugarColumn(ColumnName = "MOVE_OK")] /// <summary> /// 调入 /// </summary> [SugarColumn(ColumnName = "MOVE_OK")] public decimal? MoveOk { get; set; } } MES.Service/Modes/MesInvItemStocks.cs
@@ -19,25 +19,25 @@ /// 生产订单 /// </summary> [SugarColumn(ColumnName = "TASK_NO")] public string TaskNo { get; set; } public string? TaskNo { get; set; } /// <summary> /// 物料条码 /// </summary> [SugarColumn(ColumnName = "ITEM_BARCODE")] public string ItemBarcode { get; set; } public string? ItemBarcode { get; set; } /// <summary> /// 客户物料编码（无条码手工录入，有条码为冗余字段） /// </summary> [SugarColumn(ColumnName = "C_ITEM_CODE")] public string CItemCode { get; set; } public string? CItemCode { get; set; } /// <summary> /// 本司物料编码（无条码手工录入，有条码为冗余字段） /// </summary> [SugarColumn(ColumnName = "ITEM_NO")] public string ItemNo { get; set; } public string? ItemNo { get; set; } /// <summary> /// 子库id @@ -55,7 +55,7 @@ /// 厂家批次 /// </summary> [SugarColumn(ColumnName = "LOT_NO")] public string LotNo { get; set; } public string? LotNo { get; set; } /// <summary> /// 数量 @@ -73,7 +73,7 @@ /// 客户编码 /// </summary> [SugarColumn(ColumnName = "CUSTOMER_NO")] public string CustomerNo { get; set; } public string? CustomerNo { get; set; } /// <summary> /// 重量 @@ -85,13 +85,13 @@ /// 子库CODE /// </summary> [SugarColumn(ColumnName = "DEPOTS_CODE")] public string DepotsCode { get; set; } public string? DepotsCode { get; set; } /// <summary> /// 货位CODE /// </summary> [SugarColumn(ColumnName = "DEPOT_SECTIONS_CODE")] public string DepotSectionsCode { get; set; } public string? DepotSectionsCode { get; set; } /// <summary> /// 检验日期 @@ -115,25 +115,25 @@ /// 工厂编号 /// </summary> [SugarColumn(ColumnName = "FACTORY")] public string Factory { get; set; } public string? Factory { get; set; } /// <summary> /// 公司编号 /// </summary> [SugarColumn(ColumnName = "COMPANY")] public string Company { get; set; } public string? Company { get; set; } /// <summary> /// 质检状态 /// </summary> [SugarColumn(ColumnName = "IQC_STATUS")] public string IqcStatus { get; set; } public string? IqcStatus { get; set; } /// <summary> /// 小车条码 /// </summary> [SugarColumn(ColumnName = "FCAR")] public string Fcar { get; set; } public string? Fcar { get; set; } /// <summary> /// 冻结提交重检，0：冻结未提交重检，1：冻结并提交重检 @@ -145,7 +145,7 @@ /// 提交重检人 /// </summary> [SugarColumn(ColumnName = "VISABLE_SUBMIT_BY")] public string VisableSubmitBy { get; set; } public string? VisableSubmitBy { get; set; } /// <summary> /// 提交重检时间 @@ -157,13 +157,13 @@ /// 产品型号 /// </summary> [SugarColumn(ColumnName = "BOARD_STYLE")] public string BoardStyle { get; set; } public string? BoardStyle { get; set; } /// <summary> /// 任务单号 /// </summary> [SugarColumn(ColumnName = "WORK_NO")] public string WorkNo { get; set; } public string? WorkNo { get; set; } /// <summary> /// 任务单行号 @@ -175,19 +175,19 @@ /// 供应商 /// </summary> [SugarColumn(ColumnName = "SUPP_NO")] public string SuppNo { get; set; } public string? SuppNo { get; set; } /// <summary> /// 生产线 /// </summary> [SugarColumn(ColumnName = "LINE_NO")] public string LineNo { get; set; } public string? LineNo { get; set; } /// <summary> /// 半成品入库单号 /// </summary> [SugarColumn(ColumnName = "BILL_NO")] public string BillNo { get; set; } public string? BillNo { get; set; } /// <summary> /// 采购订单id MES.Service/Modes/MesQaItemsDetect01.cs
@@ -8,324 +8,324 @@ [SugarTable("MES_QA_ITEMS_DETECT_01")] public class MesQaItemsDetect01 { /// <summary> /// </summary> [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)] /// <summary> /// </summary> [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)] public decimal Id { get; set; } /// <summary> /// 检验单号 /// </summary> [SugarColumn(ColumnName = "RELEASE_NO")] /// <summary> /// 检验单号 /// </summary> [SugarColumn(ColumnName = "RELEASE_NO")] public string ReleaseNo { get; set; } /// <summary> /// 检验日期 /// </summary> [SugarColumn(ColumnName = "FCHECK_DATE")] /// <summary> /// 检验日期 /// </summary> [SugarColumn(ColumnName = "FCHECK_DATE")] public DateTime? FcheckDate { get; set; } /// <summary> /// 检验人员 /// </summary> [SugarColumn(ColumnName = "FCHECK_BY")] /// <summary> /// 检验人员 /// </summary> [SugarColumn(ColumnName = "FCHECK_BY")] public string FcheckBy { get; set; } /// <summary> /// 物料编码 /// </summary> [SugarColumn(ColumnName = "ITEM_NO")] /// <summary> /// 物料编码 /// </summary> [SugarColumn(ColumnName = "ITEM_NO")] public string ItemNo { get; set; } /// <summary> /// 来料数量 /// </summary> [SugarColumn(ColumnName = "FBATCH_QTY")] /// <summary> /// 来料数量 /// </summary> [SugarColumn(ColumnName = "FBATCH_QTY")] public decimal? FbatchQty { get; set; } /// <summary> /// 判定结果 /// </summary> [SugarColumn(ColumnName = "FRECE_QTY")] /// <summary> /// 判定结果 /// </summary> [SugarColumn(ColumnName = "FRECE_QTY")] public string FreceQty { get; set; } /// <summary> /// </summary> [SugarColumn(ColumnName = "SUPP_NO")] /// <summary> /// </summary> [SugarColumn(ColumnName = "SUPP_NO")] public string SuppNo { get; set; } /// <summary> /// </summary> [SugarColumn(ColumnName = "FNG_DESC")] /// <summary> /// </summary> [SugarColumn(ColumnName = "FNG_DESC")] public string FngDesc { get; set; } /// <summary> /// 检验结果 /// </summary> [SugarColumn(ColumnName = "FCHECK_RESU")] /// <summary> /// 检验结果 /// </summary> [SugarColumn(ColumnName = "FCHECK_RESU")] public string FcheckResu { get; set; } /// <summary> /// </summary> [SugarColumn(ColumnName = "FREVIEW")] /// <summary> /// </summary> [SugarColumn(ColumnName = "FREVIEW")] public string Freview { get; set; } /// <summary> /// 检验水准 /// </summary> [SugarColumn(ColumnName = "SAMPLE_SIZE_NO")] /// <summary> /// 检验水准 /// </summary> [SugarColumn(ColumnName = "SAMPLE_SIZE_NO")] public string SampleSizeNo { get; set; } /// <summary> /// 检验水平 /// </summary> [SugarColumn(ColumnName = "FCHECK_LEVEL")] /// <summary> /// 检验水平 /// </summary> [SugarColumn(ColumnName = "FCHECK_LEVEL")] public string FcheckLevel { get; set; } /// <summary> /// 拒收水平 /// </summary> [SugarColumn(ColumnName = "FAC_LEVEL")] /// <summary> /// 拒收水平 /// </summary> [SugarColumn(ColumnName = "FAC_LEVEL")] public string FacLevel { get; set; } /// <summary> /// 抽检数量 /// </summary> [SugarColumn(ColumnName = "CHECK_QTY")] /// <summary> /// 抽检数量 /// </summary> [SugarColumn(ColumnName = "CHECK_QTY")] public string CheckQty { get; set; } /// <summary> /// 批次号 --到货单号 /// </summary> [SugarColumn(ColumnName = "LOT_NO")] /// <summary> /// 批次号 --到货单号 /// </summary> [SugarColumn(ColumnName = "LOT_NO")] public string LotNo { get; set; } /// <summary> /// 是否推送 /// </summary> [SugarColumn(ColumnName = "FMOVE")] /// <summary> /// 是否推送 /// </summary> [SugarColumn(ColumnName = "FMOVE")] public string Fmove { get; set; } /// <summary> /// 是否处理 /// </summary> [SugarColumn(ColumnName = "FHANDLE")] /// <summary> /// 是否处理 /// </summary> [SugarColumn(ColumnName = "FHANDLE")] public string Fhandle { get; set; } /// <summary> /// 创建人 /// </summary> [SugarColumn(ColumnName = "CREATE_BY")] /// <summary> /// 创建人 /// </summary> [SugarColumn(ColumnName = "CREATE_BY")] public string CreateBy { get; set; } /// <summary> /// 创建日期 /// </summary> [SugarColumn(ColumnName = "CREATE_DATE")] /// <summary> /// 创建日期 /// </summary> [SugarColumn(ColumnName = "CREATE_DATE")] public DateTime? CreateDate { get; set; } /// <summary> /// 更新人 /// </summary> [SugarColumn(ColumnName = "LASTUPDATE_BY")] /// <summary> /// 更新人 /// </summary> [SugarColumn(ColumnName = "LASTUPDATE_BY")] public string LastupdateBy { get; set; } /// <summary> /// 更新日期 /// </summary> [SugarColumn(ColumnName = "LASTUPDATE_DATE")] /// <summary> /// 更新日期 /// </summary> [SugarColumn(ColumnName = "LASTUPDATE_DATE")] public DateTime? LastupdateDate { get; set; } /// <summary> /// 是否审核 /// </summary> [SugarColumn(ColumnName = "MODIFY1_FLAG")] /// <summary> /// 是否审核 /// </summary> [SugarColumn(ColumnName = "MODIFY1_FLAG")] public decimal? Modify1Flag { get; set; } /// <summary> /// </summary> [SugarColumn(ColumnName = "MODIFY1_BY")] /// <summary> /// </summary> [SugarColumn(ColumnName = "MODIFY1_BY")] public string Modify1By { get; set; } /// <summary> /// </summary> [SugarColumn(ColumnName = "MODIFY1_DATE")] /// <summary> /// </summary> [SugarColumn(ColumnName = "MODIFY1_DATE")] public DateTime? Modify1Date { get; set; } /// <summary> /// </summary> [SugarColumn(ColumnName = "FACTORY")] /// <summary> /// </summary> [SugarColumn(ColumnName = "FACTORY")] public string Factory { get; set; } /// <summary> /// XRF测试报告编号 /// </summary> [SugarColumn(ColumnName = "FCHECK_REPNO")] /// <summary> /// XRF测试报告编号 /// </summary> [SugarColumn(ColumnName = "FCHECK_REPNO")] public string FcheckRepno { get; set; } /// <summary> /// 第三方报告 /// </summary> [SugarColumn(ColumnName = "FTHIRD_REP")] /// <summary> /// 第三方报告 /// </summary> [SugarColumn(ColumnName = "FTHIRD_REP")] public string FthirdRep { get; set; } /// <summary> /// 是否作废 /// </summary> [SugarColumn(ColumnName = "FCANCEL")] /// <summary> /// 是否作废 /// </summary> [SugarColumn(ColumnName = "FCANCEL")] public decimal? Fcancel { get; set; } /// <summary> /// 提交标识 /// </summary> [SugarColumn(ColumnName = "FSUBMIT")] /// <summary> /// 提交标识 /// </summary> [SugarColumn(ColumnName = "FSUBMIT")] public decimal? Fsubmit { get; set; } /// <summary> /// 检验依据 /// </summary> [SugarColumn(ColumnName = "FCHECK_ACCORD")] /// <summary> /// 检验依据 /// </summary> [SugarColumn(ColumnName = "FCHECK_ACCORD")] public string FcheckAccord { get; set; } /// <summary> /// 类型(0 来料 1 在库) /// </summary> [SugarColumn(ColumnName = "FTYPE")] /// <summary> /// 类型(0 来料 1 在库) /// </summary> [SugarColumn(ColumnName = "FTYPE")] public short? Ftype { get; set; } /// <summary> /// 单位 /// </summary> [SugarColumn(ColumnName = "ITEM_UNIT")] /// <summary> /// 单位 /// </summary> [SugarColumn(ColumnName = "ITEM_UNIT")] public string ItemUnit { get; set; } /// <summary> /// 出货日期 /// </summary> [SugarColumn(ColumnName = "OUT_DATE")] /// <summary> /// 出货日期 /// </summary> [SugarColumn(ColumnName = "OUT_DATE")] public string OutDate { get; set; } /// <summary> /// 是否免检 /// </summary> [SugarColumn(ColumnName = "FEXEMPTION")] /// <summary> /// 是否免检 /// </summary> [SugarColumn(ColumnName = "FEXEMPTION")] public decimal? Fexemption { get; set; } /// <summary> /// 档位标准 /// </summary> [SugarColumn(ColumnName = "FGEAR_STAND")] /// <summary> /// 档位标准 /// </summary> [SugarColumn(ColumnName = "FGEAR_STAND")] public string FgearStand { get; set; } /// <summary> /// 不良处理方法 /// </summary> [SugarColumn(ColumnName = "FNG_HANDLE")] /// <summary> /// 不良处理方法 /// </summary> [SugarColumn(ColumnName = "FNG_HANDLE")] public string FngHandle { get; set; } /// <summary> /// 管理编号 /// </summary> [SugarColumn(ColumnName = "FMANAGE_NO")] /// <summary> /// 管理编号 /// </summary> [SugarColumn(ColumnName = "FMANAGE_NO")] public string FmanageNo { get; set; } /// <summary> /// 转换数量 /// </summary> [SugarColumn(ColumnName = "FCOVERT_QTY")] /// <summary> /// 转换数量 /// </summary> [SugarColumn(ColumnName = "FCOVERT_QTY")] public string FcovertQty { get; set; } /// <summary> /// 版本 /// </summary> [SugarColumn(ColumnName = "FVERSION")] /// <summary> /// 版本 /// </summary> [SugarColumn(ColumnName = "FVERSION")] public decimal? Fversion { get; set; } /// <summary> /// </summary> [SugarColumn(ColumnName = "COMPANY")] /// <summary> /// </summary> [SugarColumn(ColumnName = "COMPANY")] public string Company { get; set; } /// <summary> /// </summary> [SugarColumn(ColumnName = "FSECOND_RESU")] /// <summary> /// </summary> [SugarColumn(ColumnName = "FSECOND_RESU")] public string FsecondResu { get; set; } /// <summary> /// 最大抽检数 /// </summary> [SugarColumn(ColumnName = "MAX_CHECK_QTY")] /// <summary> /// 最大抽检数 /// </summary> [SugarColumn(ColumnName = "MAX_CHECK_QTY")] public decimal? MaxCheckQty { get; set; } /// <summary> /// 特定修改是否审核 /// </summary> [SugarColumn(ColumnName = "MODIFY1_FLAG1")] /// <summary> /// 特定修改是否审核 /// </summary> [SugarColumn(ColumnName = "MODIFY1_FLAG1")] public decimal? Modify1Flag1 { get; set; } /// <summary> /// 特定修改审核人 /// </summary> [SugarColumn(ColumnName = "MODIFY1_BY1")] /// <summary> /// 特定修改审核人 /// </summary> [SugarColumn(ColumnName = "MODIFY1_BY1")] public string Modify1By1 { get; set; } /// <summary> /// 特定修改审核时间 /// </summary> [SugarColumn(ColumnName = "MODIFY1_DATE1")] /// <summary> /// 特定修改审核时间 /// </summary> [SugarColumn(ColumnName = "MODIFY1_DATE1")] public DateTime? Modify1Date1 { get; set; } /// <summary> /// 小批次号 /// </summary> [SugarColumn(ColumnName = "LOT_NO1")] /// <summary> /// 小批次号 /// </summary> [SugarColumn(ColumnName = "LOT_NO1")] public string LotNo1 { get; set; } /// <summary> /// 采购单号 /// </summary> [SugarColumn(ColumnName = "LOT_NO2")] /// <summary> /// 采购单号 /// </summary> [SugarColumn(ColumnName = "LOT_NO2")] public string LotNo2 { get; set; } /// <summary> /// 产品型号 /// </summary> [SugarColumn(ColumnName = "BOARD_STYLE")] /// <summary> /// 产品型号 /// </summary> [SugarColumn(ColumnName = "BOARD_STYLE")] public string BoardStyle { get; set; } /// <summary> /// 任务单号 /// </summary> [SugarColumn(ColumnName = "WORK_NO")] /// <summary> /// 任务单号 /// </summary> [SugarColumn(ColumnName = "WORK_NO")] public string WorkNo { get; set; } /// <summary> /// 到货时间 /// </summary> [SugarColumn(ColumnName = "DHA018")] /// <summary> /// 到货时间 /// </summary> [SugarColumn(ColumnName = "DHA018")] public string Dha018 { get; set; } /// <summary> /// 行号 /// </summary> [SugarColumn(ColumnName = "DHB002")] /// <summary> /// 行号 /// </summary> [SugarColumn(ColumnName = "DHB002")] public decimal? Dhb002 { get; set; } /// <summary> /// 到货单号 /// </summary> [SugarColumn(ColumnName = "DHB001")] /// <summary> /// 到货单号 /// </summary> [SugarColumn(ColumnName = "DHB001")] public string Dhb001 { get; set; } /// <summary> /// 供应商 /// </summary> [SugarColumn(ColumnName = "LIFNR")] /// <summary> /// 供应商 /// </summary> [SugarColumn(ColumnName = "LIFNR")] public string Lifnr { get; set; } /// <summary> /// 退料方式 /// </summary> [SugarColumn(ColumnName = "FMRMODE")] /// <summary> /// 退料方式 /// </summary> [SugarColumn(ColumnName = "FMRMODE")] public string Fmrmode { get; set; } } MES.Service/Modes/MesQaItemsDetectDetail5.cs
@@ -8,167 +8,167 @@ [SugarTable("MES_QA_ITEMS_DETECT_DETAIL5")] public class MesQaItemsDetectDetail5 { /// <summary> /// </summary> [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)] /// <summary> /// </summary> [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)] public decimal Id { get; set; } /// <summary> /// 标准值类型 /// </summary> [SugarColumn(ColumnName = "FTEXT_TYPE")] /// <summary> /// 标准值类型 /// </summary> [SugarColumn(ColumnName = "FTEXT_TYPE")] public string FtextType { get; set; } /// <summary> /// 标准值 /// </summary> [SugarColumn(ColumnName = "FSTAND")] /// <summary> /// 标准值 /// </summary> [SugarColumn(ColumnName = "FSTAND")] public decimal? Fstand { get; set; } /// <summary> /// 上公差 /// </summary> [SugarColumn(ColumnName = "FUP_ALLOW")] /// <summary> /// 上公差 /// </summary> [SugarColumn(ColumnName = "FUP_ALLOW")] public string FupAllow { get; set; } /// <summary> /// 下公差 /// </summary> [SugarColumn(ColumnName = "FDOWN_ALLOW")] /// <summary> /// 下公差 /// </summary> [SugarColumn(ColumnName = "FDOWN_ALLOW")] public string FdownAllow { get; set; } /// <summary> /// 检验水准 /// </summary> [SugarColumn(ColumnName = "SAMPLE_SIZE_NO")] /// <summary> /// 检验水准 /// </summary> [SugarColumn(ColumnName = "SAMPLE_SIZE_NO")] public string SampleSizeNo { get; set; } /// <summary> /// 检验水平 /// </summary> [SugarColumn(ColumnName = "FCHECK_LEVEL")] /// <summary> /// 检验水平 /// </summary> [SugarColumn(ColumnName = "FCHECK_LEVEL")] public string FcheckLevel { get; set; } /// <summary> /// 拒收水平 /// </summary> [SugarColumn(ColumnName = "FAC_LEVEL")] /// <summary> /// 拒收水平 /// </summary> [SugarColumn(ColumnName = "FAC_LEVEL")] public string FacLevel { get; set; } /// <summary> /// 检验项目 /// </summary> [SugarColumn(ColumnName = "FCHECK_ITEM")] /// <summary> /// 检验项目 /// </summary> [SugarColumn(ColumnName = "FCHECK_ITEM")] public string FcheckItem { get; set; } /// <summary> /// 规格要求 /// </summary> [SugarColumn(ColumnName = "FSPEC_REQU")] /// <summary> /// 规格要求 /// </summary> [SugarColumn(ColumnName = "FSPEC_REQU")] public string FspecRequ { get; set; } /// <summary> /// 抽检数量 /// </summary> [SugarColumn(ColumnName = "CHECK_QYT")] /// <summary> /// 抽检数量 /// </summary> [SugarColumn(ColumnName = "CHECK_QYT")] public decimal? CheckQyt { get; set; } /// <summary> /// 检验结果 /// </summary> [SugarColumn(ColumnName = "FCHECK_RESU")] /// <summary> /// 检验结果 /// </summary> [SugarColumn(ColumnName = "FCHECK_RESU")] public string FcheckResu { get; set; } /// <summary> /// AC数量 /// </summary> [SugarColumn(ColumnName = "FAC_QTY")] /// <summary> /// AC数量 /// </summary> [SugarColumn(ColumnName = "FAC_QTY")] public decimal? FacQty { get; set; } /// <summary> /// RE数量 /// </summary> [SugarColumn(ColumnName = "FRE_QTY")] /// <summary> /// RE数量 /// </summary> [SugarColumn(ColumnName = "FRE_QTY")] public decimal? FreQty { get; set; } /// <summary> /// 不合格数 /// </summary> [SugarColumn(ColumnName = "FNG_QTY")] /// <summary> /// 不合格数 /// </summary> [SugarColumn(ColumnName = "FNG_QTY")] public decimal? FngQty { get; set; } /// <summary> /// 不良率 /// </summary> [SugarColumn(ColumnName = "FNG_RATE")] /// <summary> /// 不良率 /// </summary> [SugarColumn(ColumnName = "FNG_RATE")] public decimal? FngRate { get; set; } /// <summary> /// 已录入数量 /// </summary> [SugarColumn(ColumnName = "FENTER_QTY")] /// <summary> /// 已录入数量 /// </summary> [SugarColumn(ColumnName = "FENTER_QTY")] public decimal? FenterQty { get; set; } /// <summary> /// </summary> [SugarColumn(ColumnName = "RELEASE_NO")] /// <summary> /// </summary> [SugarColumn(ColumnName = "RELEASE_NO")] public string ReleaseNo { get; set; } /// <summary> /// </summary> [SugarColumn(ColumnName = "COMPANY")] /// <summary> /// </summary> [SugarColumn(ColumnName = "COMPANY")] public string Company { get; set; } /// <summary> /// </summary> [SugarColumn(ColumnName = "FACTORY")] /// <summary> /// </summary> [SugarColumn(ColumnName = "FACTORY")] public string Factory { get; set; } /// <summary> /// 检验项目描述 /// </summary> [SugarColumn(ColumnName = "FCHECK_ITEM_DESC")] /// <summary> /// 检验项目描述 /// </summary> [SugarColumn(ColumnName = "FCHECK_ITEM_DESC")] public string FcheckItemDesc { get; set; } /// <summary> /// 工序号 /// </summary> [SugarColumn(ColumnName = "PROC_NO")] /// <summary> /// 工序号 /// </summary> [SugarColumn(ColumnName = "PROC_NO")] public string ProcNo { get; set; } /// <summary> /// 工作中心编码 /// </summary> [SugarColumn(ColumnName = "WORKSHOP_CENTER_CODE")] /// <summary> /// 工作中心编码 /// </summary> [SugarColumn(ColumnName = "WORKSHOP_CENTER_CODE")] public string WorkshopCenterCode { get; set; } /// <summary> /// 单位 /// </summary> [SugarColumn(ColumnName = "FUNIT")] /// <summary> /// 单位 /// </summary> [SugarColumn(ColumnName = "FUNIT")] public string Funit { get; set; } /// <summary> /// 特定修改 /// </summary> [SugarColumn(ColumnName = "GIVEN_MODIFY")] /// <summary> /// 特定修改 /// </summary> [SugarColumn(ColumnName = "GIVEN_MODIFY")] public short? GivenModify { get; set; } /// <summary> /// 检验工具 /// </summary> [SugarColumn(ColumnName = "FCHECK_TOOL")] /// <summary> /// 检验工具 /// </summary> [SugarColumn(ColumnName = "FCHECK_TOOL")] public string FcheckTool { get; set; } /// <summary> /// 更新人 /// </summary> [SugarColumn(ColumnName = "LASTUPDATE_BY")] /// <summary> /// 更新人 /// </summary> [SugarColumn(ColumnName = "LASTUPDATE_BY")] public string LastupdateBy { get; set; } /// <summary> /// 更新时间 /// </summary> [SugarColumn(ColumnName = "LASTUPDATE_DATE")] /// <summary> /// 更新时间 /// </summary> [SugarColumn(ColumnName = "LASTUPDATE_DATE")] public DateTime? LastupdateDate { get; set; } } MES.Service/Modes/Purdhb.cs
@@ -8,267 +8,267 @@ [SugarTable("PURDHB")] public class Purdhb { /// <summary> /// 单号 /// </summary> [SugarColumn(ColumnName = "DHB001")] /// <summary> /// 单号 /// </summary> [SugarColumn(ColumnName = "DHB001")] public string Dhb001 { get; set; } /// <summary> /// 序号 /// </summary> [SugarColumn(ColumnName = "DHB002")] /// <summary> /// 序号 /// </summary> [SugarColumn(ColumnName = "DHB002")] public string Dhb002 { get; set; } /// <summary> /// 物料编码 /// </summary> [SugarColumn(ColumnName = "DHB003")] /// <summary> /// 物料编码 /// </summary> [SugarColumn(ColumnName = "DHB003")] public string Dhb003 { get; set; } /// <summary> /// 物料名称 /// </summary> [SugarColumn(ColumnName = "DHB004")] /// <summary> /// 物料名称 /// </summary> [SugarColumn(ColumnName = "DHB004")] public string Dhb004 { get; set; } /// <summary> /// 物料规格 /// </summary> [SugarColumn(ColumnName = "DHB005")] /// <summary> /// 物料规格 /// </summary> [SugarColumn(ColumnName = "DHB005")] public string Dhb005 { get; set; } /// <summary> /// 交货数量 /// </summary> [SugarColumn(ColumnName = "DHB006")] /// <summary> /// 交货数量 /// </summary> [SugarColumn(ColumnName = "DHB006")] public decimal? Dhb006 { get; set; } /// <summary> /// 单位 /// </summary> [SugarColumn(ColumnName = "DHB007")] /// <summary> /// 单位 /// </summary> [SugarColumn(ColumnName = "DHB007")] public string Dhb007 { get; set; } /// <summary> /// 仓库 /// </summary> [SugarColumn(ColumnName = "DHB008")] /// <summary> /// 仓库 /// </summary> [SugarColumn(ColumnName = "DHB008")] public string Dhb008 { get; set; } /// <summary> /// 仓库名称 /// </summary> [SugarColumn(ColumnName = "DHB009")] /// <summary> /// 仓库名称 /// </summary> [SugarColumn(ColumnName = "DHB009")] public string Dhb009 { get; set; } /// <summary> /// 批号 /// </summary> [SugarColumn(ColumnName = "DHB010")] /// <summary> /// 批号 /// </summary> [SugarColumn(ColumnName = "DHB010")] public string Dhb010 { get; set; } /// <summary> /// 来源单号 /// </summary> [SugarColumn(ColumnName = "DHB011")] /// <summary> /// 来源单号 /// </summary> [SugarColumn(ColumnName = "DHB011")] public string Dhb011 { get; set; } /// <summary> /// 来源序号 /// </summary> [SugarColumn(ColumnName = "DHB012")] /// <summary> /// 来源序号 /// </summary> [SugarColumn(ColumnName = "DHB012")] public decimal? Dhb012 { get; set; } /// <summary> /// 清点数量 /// </summary> [SugarColumn(ColumnName = "DHB013")] /// <summary> /// 清点数量 /// </summary> [SugarColumn(ColumnName = "DHB013")] public decimal? Dhb013 { get; set; } /// <summary> /// 到厂日期 /// </summary> [SugarColumn(ColumnName = "DHB014")] /// <summary> /// 到厂日期 /// </summary> [SugarColumn(ColumnName = "DHB014")] public string Dhb014 { get; set; } /// <summary> /// 验收数量 /// </summary> [SugarColumn(ColumnName = "DHB015")] /// <summary> /// 验收数量 /// </summary> [SugarColumn(ColumnName = "DHB015")] public decimal? Dhb015 { get; set; } /// <summary> /// 验退数量 /// </summary> [SugarColumn(ColumnName = "DHB016")] /// <summary> /// 验退数量 /// </summary> [SugarColumn(ColumnName = "DHB016")] public decimal? Dhb016 { get; set; } /// <summary> /// 进货单价 /// </summary> [SugarColumn(ColumnName = "DHB017")] /// <summary> /// 进货单价 /// </summary> [SugarColumn(ColumnName = "DHB017")] public decimal? Dhb017 { get; set; } /// <summary> /// 进货金额 /// </summary> [SugarColumn(ColumnName = "DHB018")] /// <summary> /// 进货金额 /// </summary> [SugarColumn(ColumnName = "DHB018")] public decimal? Dhb018 { get; set; } /// <summary> /// 客户料号 /// </summary> [SugarColumn(ColumnName = "DHB019")] /// <summary> /// 客户料号 /// </summary> [SugarColumn(ColumnName = "DHB019")] public string Dhb019 { get; set; } /// <summary> /// 部门编号 /// </summary> [SugarColumn(ColumnName = "DHB020")] /// <summary> /// 部门编号 /// </summary> [SugarColumn(ColumnName = "DHB020")] public string Dhb020 { get; set; } /// <summary> /// 赠品数 /// </summary> [SugarColumn(ColumnName = "DHB021")] /// <summary> /// 赠品数 /// </summary> [SugarColumn(ColumnName = "DHB021")] public decimal? Dhb021 { get; set; } /// <summary> /// 更新ERP /// </summary> [SugarColumn(ColumnName = "DHB022")] /// <summary> /// 更新ERP /// </summary> [SugarColumn(ColumnName = "DHB022")] public string Dhb022 { get; set; } /// <summary> /// 检验状态 /// </summary> [SugarColumn(ColumnName = "DHB023")] /// <summary> /// 检验状态 /// </summary> [SugarColumn(ColumnName = "DHB023")] public string Dhb023 { get; set; } /// <summary> /// 备注 /// </summary> [SugarColumn(ColumnName = "DHB024")] /// <summary> /// 备注 /// </summary> [SugarColumn(ColumnName = "DHB024")] public string Dhb024 { get; set; } /// <summary> /// 审核 /// </summary> [SugarColumn(ColumnName = "AUDITING")] /// <summary> /// 审核 /// </summary> [SugarColumn(ColumnName = "AUDITING")] public decimal? Auditing { get; set; } /// <summary> /// ERP采购单号ID /// </summary> [SugarColumn(ColumnName = "DHB026")] /// <summary> /// ERP采购单号ID /// </summary> [SugarColumn(ColumnName = "DHB026")] public decimal? Dhb026 { get; set; } /// <summary> /// ERP采购序号ID /// </summary> [SugarColumn(ColumnName = "DHB027")] /// <summary> /// ERP采购序号ID /// </summary> [SugarColumn(ColumnName = "DHB027")] public decimal? Dhb027 { get; set; } /// <summary> /// ERP物料ID /// </summary> [SugarColumn(ColumnName = "DHB028")] /// <summary> /// ERP物料ID /// </summary> [SugarColumn(ColumnName = "DHB028")] public decimal? Dhb028 { get; set; } /// <summary> /// 待检数量 /// </summary> [SugarColumn(ColumnName = "DHB029")] /// <summary> /// 待检数量 /// </summary> [SugarColumn(ColumnName = "DHB029")] public decimal? Dhb029 { get; set; } /// <summary> /// 检验日期 /// </summary> [SugarColumn(ColumnName = "DHB030")] /// <summary> /// 检验日期 /// </summary> [SugarColumn(ColumnName = "DHB030")] public string Dhb030 { get; set; } /// <summary> /// 检验员 /// </summary> [SugarColumn(ColumnName = "DHB031")] /// <summary> /// 检验员 /// </summary> [SugarColumn(ColumnName = "DHB031")] public string Dhb031 { get; set; } /// <summary> /// 入库数量 /// </summary> [SugarColumn(ColumnName = "DHB032")] /// <summary> /// 入库数量 /// </summary> [SugarColumn(ColumnName = "DHB032")] public decimal? Dhb032 { get; set; } /// <summary> /// 入库人 /// </summary> [SugarColumn(ColumnName = "DHB033")] /// <summary> /// 入库人 /// </summary> [SugarColumn(ColumnName = "DHB033")] public string Dhb033 { get; set; } /// <summary> /// 入库时间 /// </summary> [SugarColumn(ColumnName = "DHB034")] /// <summary> /// 入库时间 /// </summary> [SugarColumn(ColumnName = "DHB034")] public string Dhb034 { get; set; } /// <summary> /// 退货数量 /// </summary> [SugarColumn(ColumnName = "DHB035")] /// <summary> /// 退货数量 /// </summary> [SugarColumn(ColumnName = "DHB035")] public decimal? Dhb035 { get; set; } /// <summary> /// ERPID /// </summary> [SugarColumn(ColumnName = "DHB037")] /// <summary> /// ERPID /// </summary> [SugarColumn(ColumnName = "DHB037")] public decimal? Dhb037 { get; set; } /// <summary> /// 退货人 /// </summary> [SugarColumn(ColumnName = "DHB036")] /// <summary> /// 退货人 /// </summary> [SugarColumn(ColumnName = "DHB036")] public string Dhb036 { get; set; } /// <summary> /// ERP原分录号 /// </summary> [SugarColumn(ColumnName = "DHB038")] /// <summary> /// ERP原分录号 /// </summary> [SugarColumn(ColumnName = "DHB038")] public decimal? Dhb038 { get; set; } /// <summary> /// ERP源单内码 /// </summary> [SugarColumn(ColumnName = "DHB039")] /// <summary> /// ERP源单内码 /// </summary> [SugarColumn(ColumnName = "DHB039")] public decimal? Dhb039 { get; set; } /// <summary> /// ERP源单类型 /// </summary> [SugarColumn(ColumnName = "DHB040")] /// <summary> /// ERP源单类型 /// </summary> [SugarColumn(ColumnName = "DHB040")] public decimal? Dhb040 { get; set; } /// <summary> /// ERP订单内码 /// </summary> [SugarColumn(ColumnName = "DHB041")] /// <summary> /// ERP订单内码 /// </summary> [SugarColumn(ColumnName = "DHB041")] public decimal? Dhb041 { get; set; } /// <summary> /// 自增列 /// </summary> [SugarColumn(ColumnName = "ID")] /// <summary> /// 自增列 /// </summary> [SugarColumn(ColumnName = "ID")] public decimal? Id { get; set; } /// <summary> /// 是否检验，1为已检 /// </summary> [SugarColumn(ColumnName = "ISCHECK")] /// <summary> /// 是否检验，1为已检 /// </summary> [SugarColumn(ColumnName = "ISCHECK")] public decimal? Ischeck { get; set; } /// <summary> /// 仓库 /// </summary> [SugarColumn(ColumnName = "DHB042")] /// <summary> /// 仓库 /// </summary> [SugarColumn(ColumnName = "DHB042")] public string Dhb042 { get; set; } } MES.Service/Modes/Purdka.cs
@@ -8,123 +8,123 @@ [SugarTable("PURDKA")] public class Purdka { /// <summary> /// 自增列 /// </summary> [SugarColumn(ColumnName = "ID")] /// <summary> /// 自增列 /// </summary> [SugarColumn(ColumnName = "ID")] public decimal? Id { get; set; } /// <summary> /// 创建人员 /// </summary> [SugarColumn(ColumnName = "CREATEUSER")] /// <summary> /// 创建人员 /// </summary> [SugarColumn(ColumnName = "CREATEUSER")] public string Createuser { get; set; } /// <summary> /// 创建时间 /// </summary> [SugarColumn(ColumnName = "CREATETIME")] /// <summary> /// 创建时间 /// </summary> [SugarColumn(ColumnName = "CREATETIME")] public string Createtime { get; set; } /// <summary> /// 修改时间 /// </summary> [SugarColumn(ColumnName = "MODIFYTIME")] /// <summary> /// 修改时间 /// </summary> [SugarColumn(ColumnName = "MODIFYTIME")] public string Modifytime { get; set; } /// <summary> /// 修改人员 /// </summary> [SugarColumn(ColumnName = "MODIFYUSER")] /// <summary> /// 修改人员 /// </summary> [SugarColumn(ColumnName = "MODIFYUSER")] public string Modifyuser { get; set; } /// <summary> /// 审核 /// </summary> [SugarColumn(ColumnName = "AUDITING")] /// <summary> /// 审核 /// </summary> [SugarColumn(ColumnName = "AUDITING")] public string Auditing { get; set; } /// <summary> /// 退货单号 /// </summary> [SugarColumn(ColumnName = "DKA001")] /// <summary> /// 退货单号 /// </summary> [SugarColumn(ColumnName = "DKA001")] public string Dka001 { get; set; } /// <summary> /// 退货类型 /// </summary> [SugarColumn(ColumnName = "DKA002")] /// <summary> /// 退货类型 /// </summary> [SugarColumn(ColumnName = "DKA002")] public string Dka002 { get; set; } /// <summary> /// 退货日期 /// </summary> [SugarColumn(ColumnName = "DKA003")] /// <summary> /// 退货日期 /// </summary> [SugarColumn(ColumnName = "DKA003")] public string Dka003 { get; set; } /// <summary> /// 退货时间 /// </summary> [SugarColumn(ColumnName = "DKA004")] /// <summary> /// 退货时间 /// </summary> [SugarColumn(ColumnName = "DKA004")] public string Dka004 { get; set; } /// <summary> /// 供应商 /// </summary> [SugarColumn(ColumnName = "DKA005")] /// <summary> /// 供应商 /// </summary> [SugarColumn(ColumnName = "DKA005")] public string Dka005 { get; set; } /// <summary> /// 供应商名称 /// </summary> [SugarColumn(ColumnName = "DKA006")] /// <summary> /// 供应商名称 /// </summary> [SugarColumn(ColumnName = "DKA006")] public string Dka006 { get; set; } /// <summary> /// 部门 /// </summary> [SugarColumn(ColumnName = "DKA007")] /// <summary> /// 部门 /// </summary> [SugarColumn(ColumnName = "DKA007")] public string Dka007 { get; set; } /// <summary> /// 审核者 /// </summary> [SugarColumn(ColumnName = "DKA008")] /// <summary> /// 审核者 /// </summary> [SugarColumn(ColumnName = "DKA008")] public string Dka008 { get; set; } /// <summary> /// 审核日期 /// </summary> [SugarColumn(ColumnName = "DKA009")] /// <summary> /// 审核日期 /// </summary> [SugarColumn(ColumnName = "DKA009")] public string Dka009 { get; set; } /// <summary> /// 退货状态，0或空为未退货，1为已退完 /// </summary> [SugarColumn(ColumnName = "DKA010")] /// <summary> /// 退货状态，0或空为未退货，1为已退完 /// </summary> [SugarColumn(ColumnName = "DKA010")] public string Dka010 { get; set; } /// <summary> /// ERPID /// </summary> [SugarColumn(ColumnName = "ERPID")] /// <summary> /// ERPID /// </summary> [SugarColumn(ColumnName = "ERPID")] public decimal? Erpid { get; set; } /// <summary> /// 保管员编码 /// </summary> [SugarColumn(ColumnName = "DKA011")] /// <summary> /// 保管员编码 /// </summary> [SugarColumn(ColumnName = "DKA011")] public string Dka011 { get; set; } /// <summary> /// 验收员编码 /// </summary> [SugarColumn(ColumnName = "DKA012")] /// <summary> /// 验收员编码 /// </summary> [SugarColumn(ColumnName = "DKA012")] public string Dka012 { get; set; } /// <summary> /// 是否推送红字入库1-推送，0-未推送 /// </summary> [SugarColumn(ColumnName = "DKA013")] /// <summary> /// 是否推送红字入库1-推送，0-未推送 /// </summary> [SugarColumn(ColumnName = "DKA013")] public decimal? Dka013 { get; set; } } MES.Service/service/Warehouse/MesInvItemMovesManager.cs
@@ -1,6 +1,7 @@ using MES.Service.DB; using MES.Service.Dto.service; using MES.Service.Modes; using MES.Service.util; using SqlSugar; namespace MES.Service.service.Warehouse; @@ -25,6 +26,193 @@ .OrderBy(it => it.Id, OrderByType.Desc).ToList(); } public OutItemDto ScanMoveBarcode(WarehouseQuery query) { var BillTypeId = 300; var TransctionNo = 301; query.Factory = "1000"; query.Company = "1000"; if (string.IsNullOrEmpty(query.billNo)) throw new Exception("请选单据号！"); var mesInvItemStocks = Db.Queryable<MesInvItemStocks>() .Where(s => s.ItemBarcode == query.barcode && s.Quantity > 0 && s.DepotsCode != null).First(); if (mesInvItemStocks == null) throw new Exception("库存中无此条码，请核对！" + query.barcode); var mesInvItemMoves = Db.Queryable<MesInvItemMoves>() .Where(d => d.TransactionNo == TransctionNo && SqlFunc.IsNull(d.Status, 0) == 1).First(); if (mesInvItemMoves == null) throw new Exception("出库单 " + query.billNo + "不存在，请确认！"); var count = Db.Queryable<MesInvItemMoves, MesInvItemMovesCDetails>( (a, b) => new JoinQueryInfos(JoinType.Inner, a.Id == b.ItemMoveId)) .Where((a, b) => b.ItemBarcode == query.barcode && a.TransactionNo == TransctionNo && SqlFunc.IsNull(a.Status, 0) == 0).Count(); if (count > 0) throw new Exception("条码重复扫描，请核对！"); count = Db.Queryable<MesInvItemMoves, MesInvItemMovesCDetails>((a, b) => new JoinQueryInfos(JoinType.Inner, a.Id == b.ItemMoveId)) .Where((a, b) => b.ItemBarcode == query.barcode && a.TransactionNo == TransctionNo && SqlFunc.IsNull(b.MoveOk, 0) == 0).Count(); if (count > 0) throw new Exception("条码重复扫描，请核对！"); if (mesInvItemMoves.FromDepotsCode != mesInvItemStocks.DepotsCode) throw new Exception("条码现存仓库与申请出货仓库不一致，请核对！"); var quantity = Db.Queryable<MesInvItemOutItems>() .Where(b => b.ItemNo == mesInvItemStocks.ItemNo && b.ItemOutId == mesInvItemMoves.Id) .Sum(b => b.Quantity); if (quantity == null) throw new Exception("扫码物料非本次申请物料，请核对！" + query.barcode); var sum = Db.Queryable<MesInvItemMovesCDetails>() .Where(b => b.ItemNo == mesInvItemStocks.ItemNo && b.ItemMoveId == mesInvItemMoves.Id) .Sum(b => b.Quantity) ?? 0; var sumqty = sum + (mesInvItemStocks.Quantity ?? 0); if (sumqty > quantity) throw new Exception( "已扫条码数量或本次扫码数量：" + sumqty + " 大于申请数量：" + quantity + "，请核对！"); List<InventoryItem> scanOutShowDb = null; UseTransaction(db => { SaveMesInvItemMovesCDetails(db, query, mesInvItemMoves, mesInvItemStocks); // Insert into mes_inv_business2 SaveMesInvBusiness2(db, query, BillTypeId, TransctionNo, mesInvItemStocks, mesInvItemMoves); if (TransctionNo == 303) db.Updateable<MesInvItemStocks>() .SetColumns(s => s.DepotSectionsCode == mesInvItemMoves.InvDepotsCode) .SetColumns(s => s.DepotsCode == mesInvItemMoves.InvDepotsCode) .Where(s => s.Id == mesInvItemStocks.Id) .ExecuteCommand(); else db.Updateable<MesInvItemStocks>() .SetColumns(s => s.DepotSectionsCode == null) .SetColumns(s => s.DepotsCode == null) .Where(s => s.Id == mesInvItemStocks.Id) .ExecuteCommand(); scanOutShowDb = ScanOutShowDb(query); if (CollectionUtil.IsNullOrEmpty(scanOutShowDb)) db.Updateable<MesInvItemMoves>() .SetColumns(s => s.Status == 1) .SetColumns(s => s.Checkdate == DateTime.Now) .SetColumns(s => s.Checkuser == query.userName) .Where(s => s.BillNo == query.billNo).ExecuteCommand(); return 1; }); var itemDto = new OutItemDto(); itemDto.SumItem = scanOutShowDb; if (TransctionNo == 201) itemDto.Quantity = mesInvItemStocks.Quantity; itemDto.ItemNo = mesInvItemStocks.ItemNo; return itemDto; } private void SaveMesInvBusiness2(SqlSugarScope Db, WarehouseQuery query, int BillTypeId, int TransctionNo, MesInvItemStocks mesInvItemStocks, MesInvItemMoves mesInvItemMoves) { var executeCommand = Db.Insertable(new MesInvBusiness2 { Status = 1, BillTypeId = BillTypeId, TransactionCode = TransctionNo.ToString(), BusinessType = 1, ItemBarcode = query.barcode, ItemNo = mesInvItemStocks.ItemNo, LotNo = mesInvItemStocks.LotNo, EpFlag = 1, Quantity = mesInvItemStocks.Quantity, FromInvDepotsCode = mesInvItemStocks.DepotsCode, FromInvDepotSectionsCode = mesInvItemStocks.DepotSectionsCode, ToInvDepotsCode = TransctionNo == 303 ? mesInvItemMoves.InvDepotsCode : null, ToInvDepotSectionsCode = TransctionNo == 303 ? mesInvItemMoves.InvDepotsCode : null, CreateBy = query.userName, CreateDate = DateTime.Now, LastupdateBy = query.userName, LastupdateDate = DateTime.Now, Factory = query.Factory, Company = query.Company, TaskNo = mesInvItemStocks.TaskNo, BillNo = query.billNo, WorkNo = mesInvItemStocks.WorkNo, WorkLine = mesInvItemStocks.WorkLine, SuppNo = mesInvItemStocks.SuppNo }).ExecuteCommand(); if (executeCommand <= 0) throw new Exception("写入MesInvBusiness2表失败"); } private void SaveMesInvItemMovesCDetails(SqlSugarScope Db, WarehouseQuery query, MesInvItemMoves mesInvItemMoves, MesInvItemStocks mesInvItemStocks) { var executeCommand = Db.Insertable(new MesInvItemMovesCDetails { ItemMoveId = mesInvItemMoves.Id, ItemBarcode = query.barcode, CItemCode = mesInvItemStocks.CItemCode, ItemNo = mesInvItemStocks.ItemNo, LotNo = mesInvItemStocks.LotNo, Quantity = mesInvItemStocks.Quantity, EpFlag = mesInvItemStocks.EpFlag, CreateBy = query.userName, CreateDate = DateTime.Now, LastupdateBy = query.userName, LastupdateDate = DateTime.Now, CustNo = mesInvItemStocks.CustomerNo, TaskNo = mesInvItemStocks.TaskNo, FromDepotsCode = mesInvItemStocks.DepotsCode, FromDepotSectionsCode = mesInvItemStocks.DepotSectionsCode, Factory = mesInvItemStocks.Factory, Company = mesInvItemStocks.Company, IqcStatus = mesInvItemStocks.IqcStatus, Fcar = mesInvItemStocks.Fcar, IndepDate = mesInvItemStocks.IndepDate, VisableSubmit = mesInvItemStocks.VisableSubmit, VisableSubmitBy = mesInvItemStocks.VisableSubmitBy, VisableSubmitDate = mesInvItemStocks.VisableSubmitDate, BoardStyle = mesInvItemStocks.BoardStyle, WorkNo = mesInvItemStocks.WorkNo, WorkLine = mesInvItemStocks.WorkLine, SuppNo = mesInvItemStocks.SuppNo }).ExecuteCommand(); if (executeCommand <= 0) throw new Exception("写入MesInvItemMovesCDetails表失败"); } //scan_out_show_DB public List<InventoryItem> ScanOutShowDb(WarehouseQuery query) { @@ -33,6 +221,8 @@ query.Factory = "1000"; query.Company = "1000"; if (string.IsNullOrEmpty(query.billNo)) throw new Exception("请选单据号！"); var sql = string.Format( "select f_get_sections_code({0}, {1}, b.item_no) sections_code , s.erp_item_no , S.ITEM_MODEL , to_char(nvl(b.quantity, 0) - nvl(quantity_ok, 0), 'FM9999999990.00') flist from mes_inv_item_moves a join mes_inv_item_out_items b on b.item_out_id = a.id join mes_items s on b.item_no = s.item_no left join (select ITEM_MOVE_ID, item_no, sum(quantity) quantity_ok from MES_INV_ITEM_MOVES_C_DETAILS group by ITEM_MOVE_ID, item_no) c on c.ITEM_MOVE_ID = a.id and b.item_no = c.item_no where 1 = 1 and a.bill_type_id = {2} and a.transaction_no = {3} and a.bill_no = {4} and nvl(b.quantity, 0) - nvl(quantity_ok, 0) > 0 and rownum < 500 AND A.STATUS = 1 order by f_get_sections_code({0}, {1}, b.item_no), s.erp_item_no ", query.Factory, query.Company, BillTypeId, TransctionNo, MES.Service/util/CollectionUtil.cs
@@ -8,7 +8,7 @@ */ public static bool IsNullOrEmpty<T>(List<T> list) { return list == null || !list.Any(); return list == null || list.Count == 0; } /** MESApplication/Controllers/Warehouse/MesInvItemMovesController.cs
@@ -13,6 +13,27 @@ { private readonly MesInvItemMovesManager m = new(); //ScanMoveBarcode [HttpPost("ScanMoveBarcode")] public ResponseResult ScanMoveBarcode(WarehouseQuery query) { try { dynamic resultInfos = new ExpandoObject(); resultInfos.tbBillList = m.ScanMoveBarcode(query); return new ResponseResult { status = 0, message = "OK", data = resultInfos }; } catch (Exception ex) { return ResponseResult.ResponseError(ex); } } // GetBillNo [HttpPost("GetBillNo")] public ResponseResult GetBillNo(WarehouseQuery query) @@ -33,7 +54,7 @@ return ResponseResult.ResponseError(ex); } } //ScanOutShowDb [HttpPost("ScanOutShowDb")] public ResponseResult ScanOutShowDb(WarehouseQuery query)
