From c54d869fe4c5e2a805624a9ade4f9057c916f358 Mon Sep 17 00:00:00 2001 From: dengjunjie <dengjunjie@hnkhzn.com> Date: 星期六, 25 五月 2024 14:13:15 +0800 Subject: [PATCH] 添加数据库清除历史数据事务 --- 代码管理/PCS/WCS_Server/WIDESEA_Entity/DomainModels/ToMES/dt_mes_detail_hty.cs | 8 ++++++++ 代码管理/PCS/WCS_Server/WIDESEA_WCS/JobsPart/Common/AutoUpdateWork.cs | 4 +++- 代码管理/WMS/WMS_Server/WIDESEA_Entity/DomainModels/ToMES/dt_mes_detail_hty.cs | 8 ++++++++ 代码管理/WMS/WMS_Server/WIDESEA_Entity/DomainModels/ToMES/dt_mes_head_hty.cs | 8 +++++++- 代码管理/WMS/WMS_Client/src/api/http.js | 2 +- 代码管理/PCS/WCS_Server/WIDESEA_Entity/DomainModels/ToMES/dt_mes_head_hty.cs | 8 +++++++- 6 files changed, 34 insertions(+), 4 deletions(-) diff --git "a/\344\273\243\347\240\201\347\256\241\347\220\206/PCS/WCS_Server/WIDESEA_Entity/DomainModels/ToMES/dt_mes_detail_hty.cs" "b/\344\273\243\347\240\201\347\256\241\347\220\206/PCS/WCS_Server/WIDESEA_Entity/DomainModels/ToMES/dt_mes_detail_hty.cs" index 73fe824..c13dd9c 100644 --- "a/\344\273\243\347\240\201\347\256\241\347\220\206/PCS/WCS_Server/WIDESEA_Entity/DomainModels/ToMES/dt_mes_detail_hty.cs" +++ "b/\344\273\243\347\240\201\347\256\241\347\220\206/PCS/WCS_Server/WIDESEA_Entity/DomainModels/ToMES/dt_mes_detail_hty.cs" @@ -113,5 +113,13 @@ [Column(TypeName = "nvarchar(20)")] [Editable(true)] public string Status { get; set; } + + /// <summary> + ///鎿嶄綔鏃堕棿 + /// </summary> + [Display(Name = "鎿嶄綔鏃堕棿")] + [Column(TypeName = "datetime")] + [Editable(true)] + public DateTime? completedate { get; set; } } } \ No newline at end of file diff --git "a/\344\273\243\347\240\201\347\256\241\347\220\206/PCS/WCS_Server/WIDESEA_Entity/DomainModels/ToMES/dt_mes_head_hty.cs" "b/\344\273\243\347\240\201\347\256\241\347\220\206/PCS/WCS_Server/WIDESEA_Entity/DomainModels/ToMES/dt_mes_head_hty.cs" index ef459b6..e0edb36 100644 --- "a/\344\273\243\347\240\201\347\256\241\347\220\206/PCS/WCS_Server/WIDESEA_Entity/DomainModels/ToMES/dt_mes_head_hty.cs" +++ "b/\344\273\243\347\240\201\347\256\241\347\220\206/PCS/WCS_Server/WIDESEA_Entity/DomainModels/ToMES/dt_mes_head_hty.cs" @@ -251,6 +251,12 @@ [Editable(true)] public string compeletor { get; set; } - + /// <summary> + ///鎿嶄綔鏃堕棿 + /// </summary> + [Display(Name = "鎿嶄綔鏃堕棿")] + [Column(TypeName = "datetime")] + [Editable(true)] + public DateTime? completedate { get; set; } } } \ No newline at end of file diff --git "a/\344\273\243\347\240\201\347\256\241\347\220\206/PCS/WCS_Server/WIDESEA_WCS/JobsPart/Common/AutoUpdateWork.cs" "b/\344\273\243\347\240\201\347\256\241\347\220\206/PCS/WCS_Server/WIDESEA_WCS/JobsPart/Common/AutoUpdateWork.cs" index abb82b5..73ba95a 100644 --- "a/\344\273\243\347\240\201\347\256\241\347\220\206/PCS/WCS_Server/WIDESEA_WCS/JobsPart/Common/AutoUpdateWork.cs" +++ "b/\344\273\243\347\240\201\347\256\241\347\220\206/PCS/WCS_Server/WIDESEA_WCS/JobsPart/Common/AutoUpdateWork.cs" @@ -117,9 +117,10 @@ jobID = mes_Detail.jobID, mes_detail_id = mes_Detail.mes_detail_id, mes_headID = mes_Detail.mes_headID, - operatetype = operatetype, + operatetype = string.IsNullOrEmpty(mes_Detail.Status) ? "瓒呮椂娓呯悊" : operatetype, SN = mes_Detail.SN, Status = mes_Detail.Status, + completedate = DateTime.Now, }; mes_Details_hty.Add(mes_Detail_Hty); mes_DetailRepository.Delete(mes_Detail, true); @@ -155,6 +156,7 @@ reqIDLineNo = mes_Head.reqIDLineNo, typeID = mes_Head.typeID, workOrder = mes_Head.workOrder, + completedate = DateTime.Now, }; mes_Head_HtyRepository.Add(mes_Head_Hty, true); mes_HeadRepository.Delete(mes_Head, true); diff --git "a/\344\273\243\347\240\201\347\256\241\347\220\206/WMS/WMS_Client/src/api/http.js" "b/\344\273\243\347\240\201\347\256\241\347\220\206/WMS/WMS_Client/src/api/http.js" index eb0a016..9b0280d 100644 --- "a/\344\273\243\347\240\201\347\256\241\347\220\206/WMS/WMS_Client/src/api/http.js" +++ "b/\344\273\243\347\240\201\347\256\241\347\220\206/WMS/WMS_Client/src/api/http.js" @@ -12,7 +12,7 @@ let loadingInstance; let loadingStatus = false; if (process.env.NODE_ENV == 'development') { - axios.defaults.baseURL = 'http://192.168.12.101:8098/'; + axios.defaults.baseURL = 'http://192.168.12.118:8098/'; } else if (process.env.NODE_ENV == 'debug') { axios.defaults.baseURL = 'http://192.168.12.101:8098/'; diff --git "a/\344\273\243\347\240\201\347\256\241\347\220\206/WMS/WMS_Server/WIDESEA_Entity/DomainModels/ToMES/dt_mes_detail_hty.cs" "b/\344\273\243\347\240\201\347\256\241\347\220\206/WMS/WMS_Server/WIDESEA_Entity/DomainModels/ToMES/dt_mes_detail_hty.cs" index 73fe824..c13dd9c 100644 --- "a/\344\273\243\347\240\201\347\256\241\347\220\206/WMS/WMS_Server/WIDESEA_Entity/DomainModels/ToMES/dt_mes_detail_hty.cs" +++ "b/\344\273\243\347\240\201\347\256\241\347\220\206/WMS/WMS_Server/WIDESEA_Entity/DomainModels/ToMES/dt_mes_detail_hty.cs" @@ -113,5 +113,13 @@ [Column(TypeName = "nvarchar(20)")] [Editable(true)] public string Status { get; set; } + + /// <summary> + ///鎿嶄綔鏃堕棿 + /// </summary> + [Display(Name = "鎿嶄綔鏃堕棿")] + [Column(TypeName = "datetime")] + [Editable(true)] + public DateTime? completedate { get; set; } } } \ No newline at end of file diff --git "a/\344\273\243\347\240\201\347\256\241\347\220\206/WMS/WMS_Server/WIDESEA_Entity/DomainModels/ToMES/dt_mes_head_hty.cs" "b/\344\273\243\347\240\201\347\256\241\347\220\206/WMS/WMS_Server/WIDESEA_Entity/DomainModels/ToMES/dt_mes_head_hty.cs" index ef459b6..e0edb36 100644 --- "a/\344\273\243\347\240\201\347\256\241\347\220\206/WMS/WMS_Server/WIDESEA_Entity/DomainModels/ToMES/dt_mes_head_hty.cs" +++ "b/\344\273\243\347\240\201\347\256\241\347\220\206/WMS/WMS_Server/WIDESEA_Entity/DomainModels/ToMES/dt_mes_head_hty.cs" @@ -251,6 +251,12 @@ [Editable(true)] public string compeletor { get; set; } - + /// <summary> + ///鎿嶄綔鏃堕棿 + /// </summary> + [Display(Name = "鎿嶄綔鏃堕棿")] + [Column(TypeName = "datetime")] + [Editable(true)] + public DateTime? completedate { get; set; } } } \ No newline at end of file -- Gitblit v1.9.3