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/MesInvItemStocks.cs
@@ -8,194 +8,194 @@ [SugarTable("MES_INV_ITEM_STOCKS")] public class MesInvItemStocks { /// <summary> /// </summary> [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)] /// <summary> /// </summary> [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)] public decimal Id { get; set; } /// <summary> /// 生产订单 /// </summary> [SugarColumn(ColumnName = "TASK_NO")] /// <summary> /// 生产订单 /// </summary> [SugarColumn(ColumnName = "TASK_NO")] public string TaskNo { get; set; } /// <summary> /// 物料条码 /// </summary> [SugarColumn(ColumnName = "ITEM_BARCODE")] /// <summary> /// 物料条码 /// </summary> [SugarColumn(ColumnName = "ITEM_BARCODE")] public string ItemBarcode { 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> /// 子库id /// </summary> [SugarColumn(ColumnName = "DEPOTS_ID")] /// <summary> /// 子库id /// </summary> [SugarColumn(ColumnName = "DEPOTS_ID")] public decimal? DepotsId { get; set; } /// <summary> /// 货位id /// </summary> [SugarColumn(ColumnName = "DEPOT_SECTIONS_ID")] /// <summary> /// 货位id /// </summary> [SugarColumn(ColumnName = "DEPOT_SECTIONS_ID")] public decimal? DepotSectionsId { 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 = "CUSTOMER_NO")] /// <summary> /// 客户编码 /// </summary> [SugarColumn(ColumnName = "CUSTOMER_NO")] public string CustomerNo { get; set; } /// <summary> /// 重量 /// </summary> [SugarColumn(ColumnName = "ITEM_WT")] /// <summary> /// 重量 /// </summary> [SugarColumn(ColumnName = "ITEM_WT")] public decimal? ItemWt { get; set; } /// <summary> /// 子库CODE /// </summary> [SugarColumn(ColumnName = "DEPOTS_CODE")] /// <summary> /// 子库CODE /// </summary> [SugarColumn(ColumnName = "DEPOTS_CODE")] public string DepotsCode { get; set; } /// <summary> /// 货位CODE /// </summary> [SugarColumn(ColumnName = "DEPOT_SECTIONS_CODE")] /// <summary> /// 货位CODE /// </summary> [SugarColumn(ColumnName = "DEPOT_SECTIONS_CODE")] public string DepotSectionsCode { get; set; } /// <summary> /// 检验日期 /// </summary> [SugarColumn(ColumnName = "CHECK_DATE")] /// <summary> /// 检验日期 /// </summary> [SugarColumn(ColumnName = "CHECK_DATE")] public DateTime? CheckDate { get; set; } /// <summary> /// 0 物料 1 半成品 2 成品 /// </summary> [SugarColumn(ColumnName = "ITEM_TYPE")] /// <summary> /// 0 物料 1 半成品 2 成品 /// </summary> [SugarColumn(ColumnName = "ITEM_TYPE")] public short? ItemType { get; set; } /// <summary> /// 入库日期 /// </summary> [SugarColumn(ColumnName = "INDEP_DATE")] /// <summary> /// 入库日期 /// </summary> [SugarColumn(ColumnName = "INDEP_DATE")] public DateTime? IndepDate { 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 = "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> /// 冻结提交重检，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")] /// <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")] /// <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 = "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> /// 半成品入库单号 /// </summary> [SugarColumn(ColumnName = "BILL_NO")] /// <summary> /// 半成品入库单号 /// </summary> [SugarColumn(ColumnName = "BILL_NO")] public string BillNo { 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/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/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/bin/Debug/net8.0/MES.Service.dllBinary files differ
MES.Service/bin/Debug/net8.0/MES.Service.pdbBinary files differ
MES.Service/bin/Release/net8.0/MES.Service.dllBinary files differ
MES.Service/bin/Release/net8.0/MES.Service.pdbBinary files differ
MES.Service/service/GetErpParametersServer.cs
@@ -13,13 +13,16 @@ private readonly MesInvItemInCDetailsManager _invItemInCDetailsServer = new(); private readonly MesInvItemOutsManager _invItemOutsServer = new(); private readonly MessageCenterManager _messageCenterServer = new(); public List<MessageCenter> GetErpParameters(List<MessageCenter> data) { var centers = new List<MessageCenter>(); //获取第一个请求 //获取主请求 var center = data.Find(p => p.Seq == 1); //解析URL @@ -28,34 +31,70 @@ //提取参数 var queryParameters = HttpUtility.ParseQueryString(queryString); var strings = center.TableName.Split("_"); MessageCenter mesToErp = null; var query = new WarehouseQuery(); switch (center.TableName) { //采购入库单审核 case "MES_INV_ITEM_INS_A": //采购入库单反审核 case "MES_INV_ITEM_INS_B": var strings = center.TableName.Split("_"); var query = new WarehouseQuery(); //获取到类型（审核还是反审核） query.Type = strings[^1]; //获取url中附带的参数 query.id = Convert.ToDecimal(queryParameters["id"]); query.billNo = queryParameters["billNo"]; var mesToErp = _invItemInCDetailsServer.MesToErpParam(query); //重新获取请求的数据 mesToErp = _invItemInCDetailsServer.MesToErpParam(query); //赋值主id mesToErp.Id = center.Id; centers.Add(mesToErp); //更新剩下的请求的参数 var messageCenter = data[0]; var json = new JObject(); json.Add(new JProperty("id", query.id)); json.Add(new JProperty("billNo", query.billNo)); var json = new JObject { new JProperty("id", query.id), new JProperty("billNo", query.billNo) }; messageCenter.Data = json.ToString(); centers.Add(messageCenter); break; //采购退料单审核 case "MES_INV_ITEM_OUTS_A": //采购退料单反审核 case "MES_INV_ITEM_OUTS_B": //获取到类型（审核还是反审核） query.Type = strings[^1]; query.id = Convert.ToDecimal(queryParameters["id"]); query.billNo = queryParameters["itemOutNo"]; //重新获取请求的数据 mesToErp = _invItemOutsServer.MesToErpParam(query); //更正为主id mesToErp.Id = center.Id; //添加到请求集合中 centers.Add(mesToErp); //获取剩余的请求 var find = data.FindAll(s => s.Seq != 1); var result = new JObject { new JProperty("id", query.id), new JProperty("billNo", query.billNo) }; find.ForEach(s => { s.Data = result.ToString(); centers.Add(s); }); break; default: throw new Exception("无法识别TableName类型"); } MES.Service/service/Warehouse/MesInvItemOutsManager.cs
@@ -192,9 +192,10 @@ private bool Update(WarehouseQuery entity) { var userName = entity.userName ?? "system"; return Db.Updateable<MesInvItemOuts>() .SetColumns(s => s.Status == entity.status) .SetColumns(s => s.CheckUser == entity.userName) .SetColumns(s => s.CheckUser == userName) .SetColumns(s => s.CheckDate == DateTime.Now) .Where(s => s.Id == entity.id).ExecuteCommand() > 0; } MESApplication/bin/Debug/net8.0/MES.Service.dllBinary files differ
MESApplication/bin/Debug/net8.0/MES.Service.pdbBinary files differ
MESApplication/bin/Debug/net8.0/MESApplication.dllBinary files differ
MESApplication/bin/Debug/net8.0/MESApplication.exeBinary files differ
MESApplication/bin/Debug/net8.0/MESApplication.pdbBinary files differ
MESApplication/bin/Release/net8.0/MES.Service.dllBinary files differ
MESApplication/bin/Release/net8.0/MES.Service.pdbBinary files differ
MESApplication/bin/Release/net8.0/MESApplication.dllBinary files differ
MESApplication/bin/Release/net8.0/MESApplication.exeBinary files differ
MESApplication/bin/Release/net8.0/MESApplication.pdbBinary files differ
MESApplication/bin/Release/net8.0/publish/MES.Service.dllBinary files differ
MESApplication/bin/Release/net8.0/publish/MES.Service.pdbBinary files differ
MESApplication/bin/Release/net8.0/publish/MESApplication.dllBinary files differ
MESApplication/bin/Release/net8.0/publish/MESApplication.exeBinary files differ
MESApplication/bin/Release/net8.0/publish/MESApplication.pdbBinary files differ
