| | |
| | | using SqlSugar; |
| | | |
| | | namespace MES.Service.Modes; |
| | | |
| | | namespace MES.Service.Modes |
| | | { |
| | | /// <summary> |
| | | /// 生产订单表(委外) |
| | | /// </summary> |
| | |
| | | /// <summary> |
| | | /// SEQ_ORDER |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "ID", OracleSequenceName = "SEQ_ORDER", |
| | | IsPrimaryKey = true)] |
| | | [SugarColumn(ColumnName = "ID",OracleSequenceName = "SEQ_ORDER", IsPrimaryKey = true)] |
| | | public decimal Id { get; set; } |
| | | |
| | | /// <summary> |
| | |
| | | /// 工单数量 |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "WORK_ORDER_QTY")] |
| | | public decimal? WorkOrderQty { get; set; } |
| | | public double? WorkOrderQty { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 计划组 |
| | |
| | | /// 入库上限 |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "STORAGE_UPPER_LIMIT")] |
| | | public decimal? StorageUpperLimit { get; set; } |
| | | public double? StorageUpperLimit { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 入库下限 |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "STORAGE_LOWER_LIMIT")] |
| | | public decimal? StorageLowerLimit { get; set; } |
| | | public double? StorageLowerLimit { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 计划跟踪号 |
| | |
| | | /// 标准点数 |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "STANDARDPOINTS")] |
| | | public decimal? StandardPoints { get; set; } |
| | | public decimal? Standardpoints { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 计价点数 |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "PRICINGPOINTS")] |
| | | public decimal? PricingPoints { get; set; } |
| | | public decimal? Pricingpoints { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 入库数量 |
| | |
| | | /// 未入库数量 |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "NOSTOCKINQTY")] |
| | | public decimal? NoStockInQty { get; set; } |
| | | public double? NoStockInQty { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 入库货主 |
| | |
| | | [SugarColumn(ColumnName = "STOCKOWNER")] |
| | | public string? StockOwner { get; set; } |
| | | } |
| | | } |
| | |
| | | using SqlSugar; |
| | | |
| | | namespace MES.Service.Modes; |
| | | |
| | | namespace MES.Service.Modes |
| | | { |
| | | /// <summary> |
| | | /// 生产订单表(委外)子表 |
| | | /// </summary> |
| | |
| | | /// <summary> |
| | | /// SEQ_ORDER |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "ID", OracleSequenceName = "SEQ_ORDER", |
| | | IsPrimaryKey = true)] |
| | | [SugarColumn(ColumnName = "ID",OracleSequenceName = "SEQ_ORDER", IsPrimaryKey = true)] |
| | | public decimal Id { get; set; } |
| | | |
| | | /// <summary> |
| | |
| | | /// 需领用量 |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "REQUIRED_QTY")] |
| | | public decimal? RequiredQty { get; set; } |
| | | public double? RequiredQty { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 已领用量 |
| | |
| | | /// 分子 |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "NUMERATOR")] |
| | | public long? Numerator { get; set; } |
| | | public double? Numerator { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 分母 |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "DENOMINATOR")] |
| | | public long? Denominator { get; set; } |
| | | public double? Denominator { get; set; } |
| | | |
| | | /// <summary> |
| | | /// ERPID |
| | |
| | | [SugarColumn(ColumnName = "SUPPLYING_ORG_2")] |
| | | public string? SupplyingOrg2 { get; set; } |
| | | } |
| | | } |
| | |
| | | BusinessStatus = erpDto.FStatus, |
| | | ProductCode = erpDto.FMaterialId, |
| | | Unit = erpDto.FUnitID, |
| | | WorkOrderQty = Convert.ToDecimal(erpDto.FQty), |
| | | WorkOrderQty = Convert.ToDouble(erpDto.FQty), |
| | | PlanningGroup = erpDto.FWorkGroupId, |
| | | Planner = erpDto.FPlannerID, |
| | | EstimatedStartTime = |
| | | ParseDateTime(erpDto.FPlanStartDate) ?? null, |
| | | EstimatedEndTime = |
| | | ParseDateTime(erpDto.FPlanFinishDate) ?? null, |
| | | StorageUpperLimit = Convert.ToDecimal(erpDto.FStockInLimitH), |
| | | StorageLowerLimit = Convert.ToDecimal(erpDto.FStockInLimitL), |
| | | StorageUpperLimit = Convert.ToDouble(erpDto.FStockInLimitH), |
| | | StorageLowerLimit = Convert.ToDouble(erpDto.FStockInLimitL), |
| | | TrackingNo = erpDto.FMTONO, |
| | | BatchNo = erpDto.FLot, |
| | | BomVersion = erpDto.FBomId, |
| | |
| | | ErpProductionEntryCode = erpDto.FSUBENTRYID, |
| | | PurchaseOrderNo = erpDto.FPurOrderNo, |
| | | PurchaseOrderEntrySeq = long.Parse(erpDto.FPurOrderEntrySeq), |
| | | StandardPoints = |
| | | Convert.ToDecimal(erpDto.F_UNW_BaseProperty_bzds), |
| | | PricingPoints = |
| | | Convert.ToDecimal(erpDto.F_UNW_BaseProperty_jjds), |
| | | // StandardPoints = |
| | | // Convert.ToDecimal(erpDto.F_UNW_BaseProperty_bzds), |
| | | // PricingPoints = |
| | | // Convert.ToDecimal(erpDto.F_UNW_BaseProperty_jjds), |
| | | StockInQty = Convert.ToDecimal(erpDto.FBaseStockInQty), |
| | | NoStockInQty = Convert.ToDecimal(erpDto.FBaseNoStockInQty), |
| | | NoStockInQty = Convert.ToDouble(erpDto.FBaseNoStockInQty), |
| | | StockOwner = erpDto.FInStockOwnerId |
| | | }; |
| | | |
| | |
| | | { |
| | | SequenceNo = long.Parse(erpDto.FSEQ), |
| | | MaterialCode = erpDto.FMaterialID2, |
| | | RequiredQty = Convert.ToDecimal(erpDto.FMustQty), |
| | | RequiredQty = Convert.ToDouble(erpDto.FMustQty), |
| | | IssuedQty = Convert.ToDecimal(erpDto.FPickedQty), |
| | | LocationNo = erpDto.FPositionNO, |
| | | StockOwner = erpDto.FOwnerID, |
| | |
| | | Process = erpDto.F_UNW_Text_tpgy_Z, |
| | | Unit = erpDto.FUnitID2, |
| | | SupplyingType = erpDto.FSupplyType, |
| | | Numerator = long.Parse(erpDto.FNumerator), |
| | | Denominator = long.Parse(erpDto.FDenominator), |
| | | Numerator = Convert.ToDouble(erpDto.FNumerator), |
| | | Denominator = Convert.ToDouble(erpDto.FDenominator), |
| | | ErpId = erpDto.FPPOMENTRYID, |
| | | ErpHeaderId = erpDto.FPPOMID, |
| | | FixedLoss = Convert.ToDecimal(erpDto.FFixScrapQty), |
| | |
| | | private readonly string TableName = "PRODUCTION_ORDER"; |
| | | |
| | | private readonly string URL = |
| | | "http://localhost:10054/api/PRODUCTION_ORDER/"; |
| | | "http://localhost:10054/api/ProductionOrder/"; |
| | | |
| | | // |
| | | [HttpPost("Save")] |
| | |
| | | </summary> |
| | | <returns></returns> |
| | | </member> |
| | | <member name="T:MESApplication.ActionFilter"> |
| | | <member name="T:MESApplication.Filter.ActionFilter"> |
| | | <summary> |
| | | 方法过滤器 |
| | | </summary> |
| | | </member> |
| | | <member name="P:MESApplication.ActionFilter.LoggerMonitor"> |
| | | <member name="P:MESApplication.Filter.ActionFilter.LoggerMonitor"> |
| | | <summary> |
| | | 监控日志 |
| | | </summary> |
| | | </member> |
| | | <member name="P:MESApplication.ActionFilter.LoggerError"> |
| | | <member name="P:MESApplication.Filter.ActionFilter.LoggerError"> |
| | | <summary> |
| | | 错误日志 |
| | | </summary> |
| | | </member> |
| | | <member name="M:MESApplication.ActionFilter.OnActionExecuting(Microsoft.AspNetCore.Mvc.Filters.ActionExecutingContext)"> |
| | | <member name="M:MESApplication.Filter.ActionFilter.OnActionExecuting(Microsoft.AspNetCore.Mvc.Filters.ActionExecutingContext)"> |
| | | <summary> |
| | | 方法执行前 |
| | | </summary> |
| | | <param name="context"></param> |
| | | <exception cref="T:System.NotImplementedException"></exception> |
| | | </member> |
| | | <member name="M:MESApplication.ActionFilter.CreateRequestLogText(System.String,System.String,System.String,System.String,System.String)"> |
| | | <member name="M:MESApplication.Filter.ActionFilter.CreateRequestLogText(System.String,System.String,System.String,System.String,System.String)"> |
| | | <summary> |
| | | 创建请求日志文本 |
| | | </summary> |
| | |
| | | <param name="actionArgs"></param> |
| | | <returns></returns> |
| | | </member> |
| | | <member name="M:MESApplication.ActionFilter.CreateResponseLogText(System.String,System.String,System.String,System.Object)"> |
| | | <member name="M:MESApplication.Filter.ActionFilter.CreateResponseLogText(System.String,System.String,System.String,System.Object)"> |
| | | <summary> |
| | | 创建响应日志文本 |
| | | </summary> |
| | |
| | | <param name="result"></param> |
| | | <returns></returns> |
| | | </member> |
| | | <member name="M:MESApplication.ErrorLog.Write(System.String,System.String,System.Exception)"> |
| | | <member name="M:MESApplication.Filter.ErrorLog.Write(System.String,System.String,System.Exception)"> |
| | | <summary> |
| | | 写入操作日志到文件中 |
| | | </summary> |
| | |
| | | <param name="message">错误文本信息</param> |
| | | <param name="ex">异常</param> |
| | | </member> |
| | | <member name="M:MESApplication.ErrorLog.Write(System.String,System.Exception)"> |
| | | <member name="M:MESApplication.Filter.ErrorLog.Write(System.String,System.Exception)"> |
| | | <summary> |
| | | 写入操作日志到文件中 |
| | | </summary> |
| | | <param name="moduleName">模块名字</param> |
| | | <param name="ex">异常</param> |
| | | </member> |
| | | <member name="M:MESApplication.ErrorLog.Write(System.String)"> |
| | | <member name="M:MESApplication.Filter.ErrorLog.Write(System.String)"> |
| | | <summary> |
| | | 写入过程数据或说明到文件中,以便跟踪 |
| | | </summary> |
| | | <param name="moduleName">模块名字</param> |
| | | <param name="ex">异常</param> |
| | | </member> |
| | | <member name="M:MESApplication.ErrorLog.LogToFile(System.String,System.String)"> |
| | | <member name="M:MESApplication.Filter.ErrorLog.LogToFile(System.String,System.String)"> |
| | | <summary> |
| | | 文本写入 |
| | | </summary> |
| | |
| | | </summary> |
| | | <returns></returns> |
| | | </member> |
| | | <member name="T:MESApplication.ActionFilter"> |
| | | <member name="T:MESApplication.Filter.ActionFilter"> |
| | | <summary> |
| | | 方法过滤器 |
| | | </summary> |
| | | </member> |
| | | <member name="P:MESApplication.ActionFilter.LoggerMonitor"> |
| | | <member name="P:MESApplication.Filter.ActionFilter.LoggerMonitor"> |
| | | <summary> |
| | | 监控日志 |
| | | </summary> |
| | | </member> |
| | | <member name="P:MESApplication.ActionFilter.LoggerError"> |
| | | <member name="P:MESApplication.Filter.ActionFilter.LoggerError"> |
| | | <summary> |
| | | 错误日志 |
| | | </summary> |
| | | </member> |
| | | <member name="M:MESApplication.ActionFilter.OnActionExecuting(Microsoft.AspNetCore.Mvc.Filters.ActionExecutingContext)"> |
| | | <member name="M:MESApplication.Filter.ActionFilter.OnActionExecuting(Microsoft.AspNetCore.Mvc.Filters.ActionExecutingContext)"> |
| | | <summary> |
| | | 方法执行前 |
| | | </summary> |
| | | <param name="context"></param> |
| | | <exception cref="T:System.NotImplementedException"></exception> |
| | | </member> |
| | | <member name="M:MESApplication.ActionFilter.CreateRequestLogText(System.String,System.String,System.String,System.String,System.String)"> |
| | | <member name="M:MESApplication.Filter.ActionFilter.CreateRequestLogText(System.String,System.String,System.String,System.String,System.String)"> |
| | | <summary> |
| | | 创建请求日志文本 |
| | | </summary> |
| | |
| | | <param name="actionArgs"></param> |
| | | <returns></returns> |
| | | </member> |
| | | <member name="M:MESApplication.ActionFilter.CreateResponseLogText(System.String,System.String,System.String,System.Object)"> |
| | | <member name="M:MESApplication.Filter.ActionFilter.CreateResponseLogText(System.String,System.String,System.String,System.Object)"> |
| | | <summary> |
| | | 创建响应日志文本 |
| | | </summary> |
| | |
| | | <param name="result"></param> |
| | | <returns></returns> |
| | | </member> |
| | | <member name="M:MESApplication.ErrorLog.Write(System.String,System.String,System.Exception)"> |
| | | <member name="M:MESApplication.Filter.ErrorLog.Write(System.String,System.String,System.Exception)"> |
| | | <summary> |
| | | 写入操作日志到文件中 |
| | | </summary> |
| | |
| | | <param name="message">错误文本信息</param> |
| | | <param name="ex">异常</param> |
| | | </member> |
| | | <member name="M:MESApplication.ErrorLog.Write(System.String,System.Exception)"> |
| | | <member name="M:MESApplication.Filter.ErrorLog.Write(System.String,System.Exception)"> |
| | | <summary> |
| | | 写入操作日志到文件中 |
| | | </summary> |
| | | <param name="moduleName">模块名字</param> |
| | | <param name="ex">异常</param> |
| | | </member> |
| | | <member name="M:MESApplication.ErrorLog.Write(System.String)"> |
| | | <member name="M:MESApplication.Filter.ErrorLog.Write(System.String)"> |
| | | <summary> |
| | | 写入过程数据或说明到文件中,以便跟踪 |
| | | </summary> |
| | | <param name="moduleName">模块名字</param> |
| | | <param name="ex">异常</param> |
| | | </member> |
| | | <member name="M:MESApplication.ErrorLog.LogToFile(System.String,System.String)"> |
| | | <member name="M:MESApplication.Filter.ErrorLog.LogToFile(System.String,System.String)"> |
| | | <summary> |
| | | 文本写入 |
| | | </summary> |