MES.Service/Dto/service/Material.cs
@@ -11,4 +11,5 @@ public string? Funit { get; set; } public decimal? FmesEntryId { get; set; } public decimal? Mid { get; set; } public string? UserName { 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,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/Modes/Purdkb.cs
@@ -8,135 +8,135 @@ [SugarTable("PURDKB")] public class Purdkb { /// <summary> /// 自增列 /// </summary> [SugarColumn(ColumnName = "ID")] /// <summary> /// 自增列 /// </summary> [SugarColumn(ColumnName = "ID")] public decimal? Id { get; set; } /// <summary> /// 审核 /// </summary> [SugarColumn(ColumnName = "AUDITING")] /// <summary> /// 审核 /// </summary> [SugarColumn(ColumnName = "AUDITING")] public string Auditing { get; set; } /// <summary> /// 创建时间 /// </summary> [SugarColumn(ColumnName = "CREATETIME")] /// <summary> /// 创建时间 /// </summary> [SugarColumn(ColumnName = "CREATETIME")] public string Createtime { get; set; } /// <summary> /// 创建人员 /// </summary> [SugarColumn(ColumnName = "CREATEUSER")] /// <summary> /// 创建人员 /// </summary> [SugarColumn(ColumnName = "CREATEUSER")] public string Createuser { get; set; } /// <summary> /// 单号 /// </summary> [SugarColumn(ColumnName = "DKB001")] /// <summary> /// 单号 /// </summary> [SugarColumn(ColumnName = "DKB001")] public string Dkb001 { get; set; } /// <summary> /// 序号 /// </summary> [SugarColumn(ColumnName = "DKB002")] /// <summary> /// 序号 /// </summary> [SugarColumn(ColumnName = "DKB002")] public string Dkb002 { get; set; } /// <summary> /// 物料编码 /// </summary> [SugarColumn(ColumnName = "DKB003")] /// <summary> /// 物料编码 /// </summary> [SugarColumn(ColumnName = "DKB003")] public string Dkb003 { get; set; } /// <summary> /// 物料名称 /// </summary> [SugarColumn(ColumnName = "DKB004")] /// <summary> /// 物料名称 /// </summary> [SugarColumn(ColumnName = "DKB004")] public string Dkb004 { get; set; } /// <summary> /// 物料规格 /// </summary> [SugarColumn(ColumnName = "DKB005")] /// <summary> /// 物料规格 /// </summary> [SugarColumn(ColumnName = "DKB005")] public string Dkb005 { get; set; } /// <summary> /// 应退数量 /// </summary> [SugarColumn(ColumnName = "DKB006")] /// <summary> /// 应退数量 /// </summary> [SugarColumn(ColumnName = "DKB006")] public decimal? Dkb006 { get; set; } /// <summary> /// 实退数量 /// </summary> [SugarColumn(ColumnName = "DKB007")] /// <summary> /// 实退数量 /// </summary> [SugarColumn(ColumnName = "DKB007")] public decimal? Dkb007 { get; set; } /// <summary> /// 待退数量 /// </summary> [SugarColumn(ColumnName = "DKB008")] /// <summary> /// 待退数量 /// </summary> [SugarColumn(ColumnName = "DKB008")] public decimal? Dkb008 { get; set; } /// <summary> /// 单位 /// </summary> [SugarColumn(ColumnName = "DKB009")] /// <summary> /// 单位 /// </summary> [SugarColumn(ColumnName = "DKB009")] public string Dkb009 { get; set; } /// <summary> /// 单价 /// </summary> [SugarColumn(ColumnName = "DKB010")] /// <summary> /// 单价 /// </summary> [SugarColumn(ColumnName = "DKB010")] public decimal? Dkb010 { get; set; } /// <summary> /// 金额 /// </summary> [SugarColumn(ColumnName = "DKB011")] /// <summary> /// 金额 /// </summary> [SugarColumn(ColumnName = "DKB011")] public decimal? Dkb011 { get; set; } /// <summary> /// 来源单号 /// </summary> [SugarColumn(ColumnName = "DKB012")] /// <summary> /// 来源单号 /// </summary> [SugarColumn(ColumnName = "DKB012")] public string Dkb012 { get; set; } /// <summary> /// 来源序号 /// </summary> [SugarColumn(ColumnName = "DKB013")] /// <summary> /// 来源序号 /// </summary> [SugarColumn(ColumnName = "DKB013")] public string Dkb013 { get; set; } /// <summary> /// 不良分类 /// </summary> [SugarColumn(ColumnName = "DKB014")] /// <summary> /// 不良分类 /// </summary> [SugarColumn(ColumnName = "DKB014")] public string Dkb014 { get; set; } /// <summary> /// 不良项目 /// </summary> [SugarColumn(ColumnName = "DKB015")] /// <summary> /// 不良项目 /// </summary> [SugarColumn(ColumnName = "DKB015")] public string Dkb015 { get; set; } /// <summary> /// 仓库编码 /// </summary> [SugarColumn(ColumnName = "DKB016")] /// <summary> /// 仓库编码 /// </summary> [SugarColumn(ColumnName = "DKB016")] public string Dkb016 { get; set; } /// <summary> /// 备注 /// </summary> [SugarColumn(ColumnName = "DKB017")] /// <summary> /// 备注 /// </summary> [SugarColumn(ColumnName = "DKB017")] public string Dkb017 { get; set; } /// <summary> /// 仓库名称 /// </summary> [SugarColumn(ColumnName = "DKB018")] /// <summary> /// 仓库名称 /// </summary> [SugarColumn(ColumnName = "DKB018")] public string Dkb018 { 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/Warehouse/MesInvItemArnDetailManager.cs
@@ -7,6 +7,13 @@ public class MesInvItemArnDetailManager : Repository<MesInvItemArnDetail> { //var result = db.Ado.GetString($"SELECT f_getseqnextvalue('{sequenceName}') FROM DUAL"); private readonly PurdhbManager purdhbManager = new(); private readonly PurdkaManager purdkaManager = new(); private readonly PurdkbManager purdkbManager = new(); private readonly MesQaItemsDetect01Manager rohInDataManager = new(); //当前类已经继承了 Repository 增、删、查、改的方法 //这里面写的代码不会给覆盖,如果要重新生成请删除 MesInvItemArnDetailManager.cs @@ -81,16 +88,9 @@ return result; } //var result = db.Ado.GetString($"SELECT f_getseqnextvalue('{sequenceName}') FROM DUAL"); private readonly PurdhbManager purdhbManager = new(); private readonly PurdkaManager purdkaManager = new(); private readonly PurdkbManager purdkbManager = new(); private readonly MesQaItemsDetect01Manager rohInDataManager = new(); public bool SetMaterial(Material material) { return UseTransaction(db => var b1 = UseTransaction(db => { var executeCommand = db.Updateable<MesInvItemArnDetail>() .SetColumns(s => s.CheckRes == "不合格") @@ -103,50 +103,94 @@ var mesQaItemsDetect01 = db.Queryable<MesQaItemsDetect01>() .Where(a => a.Id == material.FmesEntryId).Single(); if (mesQaItemsDetect01 == null) { return 0; } if (mesQaItemsDetect01 == null) return 0; var suppName = db.Queryable<MesSupplier>() .Where(b => b.SuppNo == mesQaItemsDetect01.SuppNo) .Select<string>(b => b.SuppName).First(); var CIdt = db.Ado.GetString( $"SELECT f_getseqnextvalue('mes_inv_item_ins') FROM DUAL"); "SELECT f_getseqnextvalue('mes_inv_item_ins') FROM DUAL"); var billNo = db.Ado.GetString( $"SELECT getbillcode1('1000', '1000', 'INV_IN_BACK') FROM DUAL"); "SELECT getbillcode1('1000', '1000', 'INV_IN_BACK') FROM DUAL"); // PURDKA var purdka = GetPurdka(CIdt, billNo, mesQaItemsDetect01, suppName); executeCommand += db.Insertable<Purdka>(purdka).ExecuteCommand(); executeCommand += db.Insertable(purdka).ExecuteCommand(); db.Queryable<Purdhb>() .Where(c => c.Dhb001 == mesQaItemsDetect01.LotNo && c.Dhb003 == mesQaItemsDetect01.ItemNo) .Select(c => new Purdhb { Dhb002 = c.Dhb002, Dhb003 = c.Dhb003, Dhb006 = c.Dhb006, Dhb007 = c.Dhb007, Dhb017 = c.Dhb017, Dhb018 = c.Dhb018, Dhb001 = c.Dhb001, Dhb042 = c.Dhb042 }).ToList(); executeCommand += InsertPurdkbs(db, mesQaItemsDetect01, billNo); executeCommand += db.Updateable<MesQaItemsDetect01>() .SetColumns(c => c.Modify1Flag == 1) .SetColumns(c => c.Modify1By == material.UserName) .SetColumns(c => c.Modify1Date == DateTime.Now) .SetColumns(c => c.FngHandle == "退货") .Where(c => c.ReleaseNo == mesQaItemsDetect01.ReleaseNo) .ExecuteCommand(); return executeCommand; }) > 3; }) >= 4; if (b1 == false) throw new NotImplementedException("推送失败，Mes方面出现问题"); return b1; } private int InsertPurdkbs(SqlSugarScope db, MesQaItemsDetect01 mesQaItemsDetect01, string billNo) { var purdhbs = db.Queryable<Purdhb>() .Where(c => c.Dhb001 == mesQaItemsDetect01.LotNo && c.Dhb003 == mesQaItemsDetect01.ItemNo) .Select(c => new Purdhb { Dhb002 = c.Dhb002, Dhb003 = c.Dhb003, Dhb006 = c.Dhb006, Dhb007 = c.Dhb007, Dhb017 = c.Dhb017, Dhb018 = c.Dhb018, Dhb001 = c.Dhb001, Dhb042 = c.Dhb042 }).ToList(); var list = new List<Purdkb>(); purdhbs.ForEach(s => { var id = db.Ado.GetString( "SELECT f_getseqnextvalue('MES_INV_ITEM_IN_C_DETAILS') FROM DUAL"); var purdkb = new Purdkb(); purdkb.Id = Convert.ToDecimal(id); purdkb.Dkb001 = billNo; purdkb.Dkb002 = s.Dhb002; purdkb.Dkb003 = s.Dhb003; purdkb.Dkb006 = s.Dhb006; purdkb.Dkb007 = s.Dhb006; purdkb.Dkb008 = 0; purdkb.Dkb009 = s.Dhb007; purdkb.Dkb010 = s.Dhb017; purdkb.Dkb011 = s.Dhb018; purdkb.Dkb012 = s.Dhb001; purdkb.Dkb013 = s.Dhb002; purdkb.Dkb016 = s.Dhb042; list.Add(purdkb); }); var insertRange = db.Insertable(list).ExecuteCommand(); return insertRange == purdhbs.Count ? 1 : 0; } private static Purdka GetPurdka(string CIdt, string billNo, MesQaItemsDetect01 mesQaItemsDetect01, string suppName) { var date = DateTime.Now.ToString("yyyy-MM-dd"); Purdka purdka = new Purdka(); var purdka = new Purdka(); purdka.Id = Convert.ToDecimal(CIdt); purdka.Dka001 = billNo; purdka.Dka002 = "采购退货"; MES.Service/service/Warehouse/PurdhbManager.cs
@@ -1,6 +1,5 @@ using MES.Service.DB; using MES.Service.Modes; using SqlSugar; namespace MES.Service.service.Warehouse; @@ -9,6 +8,4 @@ //当前类已经继承了 Repository 增、删、查、改的方法 //这里面写的代码不会给覆盖,如果要重新生成请删除 PurdhbManager.cs } MES.Service/service/Warehouse/PurdkaManager.cs
@@ -1,6 +1,5 @@ using MES.Service.DB; using MES.Service.Modes; using SqlSugar; namespace MES.Service.service.Warehouse; @@ -9,5 +8,4 @@ //当前类已经继承了 Repository 增、删、查、改的方法 //这里面写的代码不会给覆盖,如果要重新生成请删除 PurdkaManager.cs } MES.Service/service/Warehouse/PurdkbManager.cs
@@ -1,6 +1,5 @@ using MES.Service.DB; using MES.Service.Modes; using SqlSugar; namespace MES.Service.service.Warehouse;
@@ -54,6 +54,27 @@ } } //SetMaterial [HttpPost("SetMaterial")] public ResponseResult SetMaterial(Material material) { try { dynamic resultInfos = new ExpandoObject(); resultInfos.tbBillList = m.SetMaterial(material); return new ResponseResult { status = 0, message = "OK", data = resultInfos }; } catch (Exception ex) { return ResponseResult.ResponseError(ex); } } /// <summary> /// 获取所有 /// </summary> 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
