Merge branch 'master' of http://43.142.96.171:8080/r/~yhj/HM_JK
# Conflicts:
# StandardInterface/MES.Service/Modes/LtsLlj.cs
# StandardInterface/MES.Service/Modes/MesQaItemsDetect01.cs
# StandardInterface/MES.Service/service/QC/LljService.cs
| | |
| | | |
| | | //夿³¨ |
| | | public string? Remarks { get; set; } |
| | | //ç¹æ®å¤æ³¨ |
| | | public string? Meom { get; set; } |
| | | |
| | | //========================================== |
| | | //å·¡æ£ä¸»å表éè¦çæ°æ® |
| | |
| | | public string? XS_CN { get; set; } //å°æ¶äº§è½ |
| | | public string? SJ_xs { get; set; } //å®é
ç©´æ° |
| | | public string? NEXT_Gx { get; set; } //ä¸éå·¥åº |
| | | public string? RKS { get; set; } //å
¥åºæ° |
| | | ////å§å¤å段 |
| | | //public string? F_ZJXF_DATETIME_YHRQ { get; set; } |
| | | //public string? F_ZJXF_BASE_KH { get; set; } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | namespace MES.Service.Dto.webApi; |
| | | |
| | | public class ErpKc |
| | | { |
| | | public string? FMaterialId { get; set; } |
| | | public string? FStockId { get; set; } |
| | | public string? FMtoNo { get; set; } |
| | | public string? FLot { get; set; } |
| | | public string? FStockUnitId { get; set; } |
| | | public string? FBaseUnitId { get; set; } |
| | | public string? FStockStatusId { get; set; } |
| | | public string? FBASEQTY { get; set; } |
| | | public string? FSTOREURNOM { get; set; } |
| | | public string? FSTOREURNUM { get; set; } |
| | | // public string? FOwnerId { get; set; } // æ°å¢è´§ä¸»ç¼ç åæ®µ |
| | | public string? FStockOrgId { get; set; } // æ°å¢åºåç»ç»å段 |
| | | |
| | | |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | namespace MES.Service.Dto.webApi; |
| | | |
| | | public class Inventory |
| | | { |
| | | public string? ItemNo { get; set; } // æå· |
| | | public string? DepotCode { get; set; } // ä»åº |
| | | public string? StockOrgNumber { get; set; } // ç¨äºåºåç»ç»è¿æ»¤ |
| | | //public string? OwnerNumber { get; set; } // æ°å¢è´§ä¸»ç¼ç |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | namespace MES.Service.Dto.webApi.SRM; |
| | | |
| | | public class DeliveryItem |
| | | { |
| | | public string? DeliveryNo { get; set; } |
| | | public string? ItemNo { get; set; } |
| | | } |
| | |
| | | public string? FBillNo { get; set; } |
| | | public string? OrderlineId { get; set; } |
| | | public string? DepotNo { get; set; } |
| | | |
| | | public string? IsGift { get; set; } |
| | | } |
| | |
| | | </ItemGroup> |
| | | |
| | | <ItemGroup> |
| | | <Folder Include="Dto\webApi\SRM\" /> |
| | | <Folder Include="Modes\SRM\" /> |
| | | <Folder Include="service\SRM\" /> |
| | | </ItemGroup> |
¶Ô±ÈÐÂÎļþ |
| | |
| | | using SqlSugar; |
| | | |
| | | namespace MES.Service.Modes; |
| | | |
| | | [SugarTable("ERP_MES_KC")] |
| | | public class ErpMesKc |
| | | { |
| | | [SugarColumn(ColumnName = "ID", OracleSequenceName = "SEQ_ERP_KC", IsPrimaryKey = true)] |
| | | public decimal Id { get; set; } |
| | | |
| | | [SugarColumn(ColumnName = "FNUMBER")] |
| | | public string? FNumber { get; set; } |
| | | |
| | | [SugarColumn(ColumnName = "FQTY")] |
| | | public decimal? FQty { get; set; } |
| | | |
| | | [SugarColumn(ColumnName = "FBASEUNIT")] |
| | | public string? FBaseUnit { get; set; } |
| | | |
| | | [SugarColumn(ColumnName = "FSTOCKUNIT")] |
| | | public string? FStockUnit { get; set; } |
| | | |
| | | [SugarColumn(ColumnName = "FSTOCKNUMBER")] |
| | | public string? FStockNumber { get; set; } |
| | | |
| | | [SugarColumn(ColumnName = "CREATE_DATE")] |
| | | public DateTime? CreateDate { get; set; } |
| | | |
| | | [SugarColumn(ColumnName = "FBATCHNO")] |
| | | public string? FBatchno { get; set; } |
| | | |
| | | [SugarColumn(ColumnName = "FMTONO")] |
| | | public string? FMtono { get; set; } |
| | | |
| | | [SugarColumn(ColumnName = "FSTOCKSTATUS")] |
| | | public string? FStockStatus { get; set; } |
| | | |
| | | [SugarColumn(ColumnName = "FSTOREURNOM")] |
| | | public decimal? FStoreUrnom { get; set; } |
| | | |
| | | [SugarColumn(ColumnName = "FSTOREURNUM")] |
| | | public decimal? FStoreUrnum { get; set; } |
| | | [SugarColumn(ColumnName = "FOWNERID")] |
| | | public string? FOwnerId { get; set; } |
| | | [SugarColumn(ColumnName = "FSTOCKORGID")] |
| | | public string? FStockOrgId { get; set; } |
| | | |
| | | |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | using System; |
| | | using System.Collections.Generic; |
| | | using System.Linq; |
| | | using SqlSugar; |
| | | namespace MES.Service.Modes |
| | | { |
| | | /// <summary> |
| | | /// |
| | | ///</summary> |
| | | [SugarTable("IQC_BEFORE")] |
| | | public class IqcBefore |
| | | { |
| | | /// <summary> |
| | | /// |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="ID" ,IsPrimaryKey = true )] |
| | | public decimal Id { get; set; } |
| | | /// <summary> |
| | | /// |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="SID" )] |
| | | public decimal? Sid { get; set; } |
| | | /// <summary> |
| | | /// |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="ITEM_ID" )] |
| | | public decimal? ItemId { get; set; } |
| | | /// <summary> |
| | | /// |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="PID" )] |
| | | public decimal? Pid { get; set; } |
| | | } |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | using System; |
| | | using System.Collections.Generic; |
| | | using System.Linq; |
| | | using SqlSugar; |
| | | namespace MES.Service.Modes |
| | | { |
| | | /// <summary> |
| | | /// |
| | | ///</summary> |
| | | [SugarTable("IQC_BEFORE_FROM")] |
| | | public class IqcBeforeFrom |
| | | { |
| | | /// <summary> |
| | | /// |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="ID" ,IsPrimaryKey = true )] |
| | | public decimal Id { get; set; } |
| | | /// <summary> |
| | | /// |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="SID" )] |
| | | public decimal? Sid { get; set; } |
| | | /// <summary> |
| | | /// |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="USER_NAME" )] |
| | | public string UserName { get; set; } |
| | | /// <summary> |
| | | /// |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="ORGANIZE_ID" )] |
| | | public string OrganizeId { get; set; } |
| | | /// <summary> |
| | | /// |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="CHECK_USER" )] |
| | | public string CheckUser { get; set; } |
| | | /// <summary> |
| | | /// |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="CHECK_DATE" )] |
| | | public DateTime? CheckDate { get; set; } |
| | | /// <summary> |
| | | /// |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="STATUS" )] |
| | | public short? Status { get; set; } |
| | | } |
| | | } |
| | |
| | | /// </summary> |
| | | [SugarColumn(IsIgnore = true)] |
| | | public string? NewFngDesc { get; set; } |
| | | [SugarColumn(IsIgnore = true)] |
| | | //ç´§æ¥æ¾è¡æ è¯ |
| | | /// <summary> |
| | | /// ç´§æ¥æ¾è¡æ è¯ |
| | | /// </summary> |
| | | public int EMERGENCY { get; set; } |
| | | |
| | | } |
| | |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "MANAGER_USER")] |
| | | public string? ManagerUser { get; set; } |
| | | |
| | | /// <summary> |
| | | /// ç´§æ¥æ¾è¡ |
| | | /// ç»çå®¡æ ¸äºº |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "MANAGER_USER")] |
| | | public int EMERGENCY { get; set; } |
| | |
| | | public DateTime? LastupdateDate { get; set; } |
| | | |
| | | [SugarColumn(IsIgnore = true)] public int? Unqualified { get; set; } |
| | | /// <summary> |
| | | /// 夿³¨ |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "MEOM")] |
| | | public string? Meom { get; set; } |
| | | } |
| | |
| | | //æ¶è´§ä»åº |
| | | [SugarColumn(ColumnName = "DEPOT_CODE")] |
| | | public string? DepotCode { get; set; } |
| | | |
| | | //æ¯å¦èµ å |
| | | [SugarColumn(ColumnName = "IS_GIFT")] |
| | | public string? IsGift { get; set; } |
| | | } |
| | |
| | | /// ä¸éå·¥åº |
| | | ///</summary> |
| | | [SugarColumn(ColumnName = "NEXT_GX")] |
| | | public string Nextgx { get; set; } |
| | | public string Nextgx { get; set; } |
| | | /// <summary> |
| | | /// ä¸éå·¥åº |
| | | ///</summary> |
| | | [SugarColumn(ColumnName = "RKS")] |
| | | public string Rks { get; set; } |
| | | } |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | |  |
| | | using Kingdee.CDP.WebApi.SDK; |
| | | using MES.Service.DB; |
| | | using MES.Service.Dto.webApi; |
| | | using MES.Service.Modes; |
| | | using SqlSugar; |
| | | using System.Text; |
| | | |
| | | namespace MES.Service.service.Kingdee; |
| | | |
| | | public class ErpKcManager : Repository<ErpMesKc> |
| | | { |
| | | public bool QueryStocks(Inventory inventory) |
| | | { |
| | | List<ErpKc> erpKc = GetErpInventory(inventory); |
| | | |
| | | // æ£æ¥è¿åç»ææ¯å¦ä¸ºç©º |
| | | if (erpKc == null || erpKc.Count == 0) |
| | | { |
| | | throw new NotImplementedException("è¿åç»æä¸ºç©º"); |
| | | } |
| | | else |
| | | { |
| | | var baseObjects = MapErpCABtoWomcab(erpKc); |
| | | |
| | | return UseTransaction(db => |
| | | { |
| | | return SaveData(db, baseObjects) ? 1 : 0; |
| | | }) > 0; |
| | | } |
| | | } |
| | | |
| | | #region 1.è·å峿¶åºå |
| | | public List<ErpKc> GetErpInventory(Inventory inventory) |
| | | { |
| | | //注æ 1ï¼æ¤å¤ä¸å使ç¨åæ°å½¢å¼ä¼ å
¥ç¨æ·ååå¯ç çææä¿¡æ¯ï¼æ¹ä¸ºå¨ç»å½é
ç½®æä»¶ä¸è®¾ç½®ã |
| | | //注æ 2ï¼å¿
é¡»å
é
ç½®ç¬¬ä¸æ¹ç³»ç»ç»å½ææä¿¡æ¯åï¼åè¿è¡ä¸å¡æä½ï¼è¯¦æ
åèåè¯è¨çæ¬SDKä»ç»ä¸çç»å½é
ç½®æä»¶è¯´æã |
| | | //读åé
ç½®ï¼åå§åSDK |
| | | K3CloudApi client = new K3CloudApi(); |
| | | //ç¨äºè®°å½ç»æ |
| | | StringBuilder Info = new StringBuilder(); |
| | | //ä¸å¡å¯¹è±¡æ è¯ |
| | | string formId = "STK_Inventory"; |
| | | DateTime dt = DateTime.Now; |
| | | //æ¥è¯¢å段éåï¼å³è¿ååªäºæ°æ®ï¼ä¸è½ä¸ºç©ºï¼æ ¹æ®ä¸åä¸å¡åæ®å¡«åä¸åçåæ®µåï¼ä»¥ä¸ä»
ä¸ºç¤ºä¾ |
| | | //string fieldKeys = "FCode,FFileId,FRelevantObject"; |
| | | //string FilterString = "FID='-2146304'"; |
| | | string fieldKeys = "FMaterialId.FNumber,FMtoNo,FStockId.FNumber,FLot.FNumber,FStockUnitId.FNumber,FBaseUnitId.FNumber,FStockStatusId.FName,FBASEQTY,FMaterialid.FSTOREURNOM,FMaterialid.FSTOREURNUM,FStockOrgId.FNumber"; |
| | | string FilterString = string.Format(@"FMaterialId.FNumber like '%{0}%' and FStockId.FNumber like '%{1}%' and FBaseQty>0 and FStockOrgId.FNumber like'%{2}%'", inventory.ItemNo,inventory.DepotCode, inventory.StockOrgNumber); |
| | | string OrderString = ""; |
| | | int TopRowCount = 0; |
| | | int StartRow = 0; |
| | | int Limit = 0; |
| | | |
| | | var param = new QueryParam() |
| | | { |
| | | FormId = formId, |
| | | FieldKeys = fieldKeys, |
| | | FilterString = FilterString, |
| | | OrderString = OrderString, |
| | | TopRowCount = TopRowCount, |
| | | StartRow = StartRow, |
| | | Limit = Limit |
| | | }; |
| | | //è°ç¨æ¥å£ |
| | | var result = client.ExecuteBillQuery(param.ToJson()); |
| | | |
| | | return result.Select(s => |
| | | { |
| | | var entity = new ErpKc |
| | | { |
| | | FMaterialId = s[0]?.ToString(), |
| | | FMtoNo = s[1]?.ToString(), |
| | | FStockId = s[2]?.ToString(), |
| | | FLot = s[3]?.ToString(), |
| | | FStockUnitId = s[4]?.ToString(), |
| | | FBaseUnitId = s[5]?.ToString(), |
| | | FStockStatusId = s[6]?.ToString(), |
| | | FBASEQTY = s[7]?.ToString() , |
| | | FSTOREURNOM = s[8]?.ToString(), |
| | | FSTOREURNUM = s[9]?.ToString(), |
| | | // FOwnerId = s[10]?.ToString() |
| | | FStockOrgId = s[10]?.ToString() |
| | | }; |
| | | return entity; |
| | | }).ToList(); |
| | | } |
| | | #endregion |
| | | |
| | | |
| | | private List<ErpMesKc> MapErpCABtoWomcab(List<ErpKc> dtoList) |
| | | { |
| | | var ErpMesKcList = new List<ErpMesKc>(); |
| | | |
| | | foreach (var dto in dtoList) |
| | | { |
| | | var kc = new ErpMesKc |
| | | { |
| | | FNumber = dto.FMaterialId, |
| | | // FQty = Convert.ToDecimal(dto.FBASEQTY), |
| | | FQty = SafeParseDecimal(dto.FBASEQTY), |
| | | FBaseUnit=dto.FBaseUnitId, |
| | | FStockUnit=dto.FStockUnitId, |
| | | FStockNumber=dto.FStockId, |
| | | CreateDate=DateTime.Now, |
| | | FBatchno=dto.FLot, |
| | | FMtono=dto.FMtoNo, |
| | | FStockStatus=dto.FStockStatusId, |
| | | FStoreUrnom= Convert.ToDecimal(dto.FSTOREURNOM), |
| | | FStoreUrnum= Convert.ToDecimal(dto.FSTOREURNUM), |
| | | //FOwnerId=dto.FOwnerId, |
| | | FStockOrgId = dto.FStockOrgId, |
| | | |
| | | }; |
| | | |
| | | ErpMesKcList.Add(kc); |
| | | } |
| | | |
| | | return ErpMesKcList; |
| | | } |
| | | |
| | | |
| | | private decimal SafeParseDecimal(string? input) |
| | | { |
| | | if (string.IsNullOrWhiteSpace(input)) return 0; |
| | | |
| | | if (decimal.TryParse( |
| | | input, |
| | | System.Globalization.NumberStyles.Float, |
| | | System.Globalization.CultureInfo.InvariantCulture, |
| | | out var result)) |
| | | return result; |
| | | |
| | | return 0; // è·³è¿éè¯¯åæ®µï¼ç»é»è®¤å¼ |
| | | } |
| | | |
| | | // æå
¥ææ´æ°æ°æ®çæ¹æ³ |
| | | private bool SaveData(SqlSugarScope db, List<ErpMesKc> kcc) |
| | | { |
| | | var save = base.InsertRange(kcc); |
| | | if (save) return true; |
| | | throw new NotImplementedException("æå
¥å¤±è´¥"); |
| | | } |
| | | |
| | | } |
| | |
| | | // UserName = i.Fname != null || i.Fname != "" ? i.Fname : g.Fname, |
| | | // CreateUserName = e.Fname |
| | | // }, true) |
| | | .ToPageList(queryObj.PageIndex, queryObj.Limit, ref totalCount); |
| | | .ToPageList(queryObj.PageIndex, queryObj.Limit, ref totalCount); |
| | | |
| | | var emergencyValues = pageList.Select(item => item.EMERGENCY).ToList(); |
| | | //return (pageList, totalCount); |
| | | var emergencyValues = pageList.Select(item => item.EMERGENCY).ToList(); |
| | | return (pageList, totalCount); |
| | | } |
| | | |
| | |
| | | |
| | | } |
| | | //ç´§æ¥æ¾è¡ |
| | | //public string[] EmergencyRelease(int id) |
| | | //{ |
| | | // var db = SqlSugarHelper.GetInstance(); |
| | | |
| | | |
| | | // int emergencyStatus = db.Queryable<MesQaItemsDetect01>() |
| | | // .Where(t => t.Id == id) |
| | | // .Select(t => t.EMERGENCY) |
| | | // .First(); |
| | | |
| | | // if (emergencyStatus != 0) |
| | | // { |
| | | // return new string[] { "1", "éç´§æ¥ç¶æï¼æ æ³æ§è¡ç´§æ¥æ¾è¡" }; |
| | | // } |
| | | |
| | | |
| | | // var outputResult = new SugarParameter("PO_RESULT", null, |
| | | // DbType.Int32, ParameterDirection.Output, 4000); |
| | | |
| | | // var outputMessage = new SugarParameter("PO_MSG", null, |
| | | // DbType.String, ParameterDirection.Output, 4000); |
| | | |
| | | // var parameters = new List<SugarParameter> |
| | | //{ |
| | | // new("P_ID", id, DbType.Int32, ParameterDirection.Input), |
| | | // outputResult, |
| | | // outputMessage |
| | | //}; |
| | | |
| | | // db.Ado.ExecuteCommand( |
| | | // "BEGIN prc_MES_QA_ITEMS_update1(:P_ID, :PO_RESULT, :PO_MSG); END;", |
| | | // parameters.ToArray()); |
| | | |
| | | // var lotNo1 = db.Queryable<MesQaItemsDetect01>() |
| | | // .Where(t => t.Id == id) |
| | | // .Select(t => t.LotNo1) |
| | | // .First(); |
| | | |
| | | // var resultValue = outputResult.Value?.ToString(); |
| | | // var messageValue = outputMessage.Value?.ToString(); |
| | | // return new string[] { resultValue, messageValue, lotNo1?.ToString() ?? "" }; |
| | | //} |
| | | |
| | | //public string[] WithdrawEmergencyRelease(int id) |
| | | //{ |
| | | // var db = SqlSugarHelper.GetInstance(); |
| | | |
| | | |
| | | // int emergencyStatus = db.Queryable<MesQaItemsDetect01>() |
| | | // .Where(t => t.Id == id) |
| | | // .Select(t => t.EMERGENCY) |
| | | // .First(); |
| | | |
| | | // if (emergencyStatus != 0) |
| | | // { |
| | | // return new string[] { "1", "éç´§æ¥ç¶æï¼æ 鿤å" }; |
| | | // } |
| | | |
| | | // var outputResult = new SugarParameter("PO_RESULT", null, |
| | | // DbType.Int32, ParameterDirection.Output, 4000); |
| | | |
| | | // var outputMessage = new SugarParameter("PO_MSG", null, |
| | | // DbType.String, ParameterDirection.Output, 4000); |
| | | |
| | | // var parameters = new List<SugarParameter> |
| | | //{ |
| | | // new("P_ID", id, DbType.Int32, ParameterDirection.Input), |
| | | // outputResult, |
| | | // outputMessage |
| | | //}; |
| | | |
| | | // db.Ado.ExecuteCommand( |
| | | // "BEGIN prc_MES_QA_ITEMS_update2(:P_ID, :PO_RESULT, :PO_MSG); END;", |
| | | // parameters.ToArray()); |
| | | |
| | | // var lotNo1 = db.Queryable<MesQaItemsDetect01>() |
| | | // .Where(t => t.Id == id) |
| | | // .Select(t => t.LotNo1) |
| | | // .First(); |
| | | |
| | | |
| | | // var resultValue = outputResult.Value?.ToString(); |
| | | // var messageValue = outputMessage.Value?.ToString(); |
| | | // return new string[] { resultValue, messageValue, lotNo1?.ToString() ?? "" }; |
| | | //} |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | public string[] EmergencyRelease(int id) |
| | | { |
| | | var db = SqlSugarHelper.GetInstance(); |
| | | |
| | | |
| | | int emergencyStatus = db.Queryable<MesQaItemsDetect01>() |
| | | |
| | | int emergencyStatus = db.Queryable<MesQaItemsDetect01>() |
| | | .Where(t => t.Id == id) |
| | | .Select(t => t.EMERGENCY) |
| | | .Select(t => t.EMERGENCY) |
| | | .First(); |
| | | |
| | | if (emergencyStatus != 0) |
| | |
| | | return new string[] { "1", "éç´§æ¥ç¶æï¼æ æ³æ§è¡ç´§æ¥æ¾è¡" }; |
| | | } |
| | | |
| | | |
| | | |
| | | var outputResult = new SugarParameter("PO_RESULT", null, |
| | | DbType.Int32, ParameterDirection.Output, 4000); |
| | | |
| | |
| | | { |
| | | var db = SqlSugarHelper.GetInstance(); |
| | | |
| | | |
| | | int emergencyStatus = db.Queryable<MesQaItemsDetect01>() |
| | | |
| | | int emergencyStatus = db.Queryable<MesQaItemsDetect01>() |
| | | .Where(t => t.Id == id) |
| | | .Select(t => t.EMERGENCY) |
| | | .Select(t => t.EMERGENCY) |
| | | .First(); |
| | | |
| | | if (emergencyStatus != 0) |
| | |
| | | .Where(t => t.Id == id) |
| | | .Select(t => t.LotNo1) |
| | | .First(); |
| | | |
| | | |
| | | |
| | | var resultValue = outputResult.Value?.ToString(); |
| | | var messageValue = outputMessage.Value?.ToString(); |
| | | return new string[] { resultValue, messageValue, lotNo1?.ToString() ?? "" }; |
| | | } |
| | | } |
| | | |
| | | private string ExtractSubstring(string input, char startChar, char endChar) |
| | | { |
| | |
| | | a.FreQty, |
| | | a.CheckQyt, |
| | | a.FcheckResu, |
| | | a.FcheckItemDesc,a.Funit |
| | | a.FcheckItemDesc, |
| | | a.Funit, |
| | | a.Meom |
| | | }).Select((a, b) => new MesQaItemsDetectDetail5 |
| | | { |
| | | Id = a.Id, |
| | |
| | | FcheckResu = a.FcheckResu, |
| | | // FcheckItemDesc = a.FcheckItemDesc |
| | | FcheckItemDesc = a.FspecRequ, |
| | | Funit =a.Funit |
| | | Funit = a.Funit, |
| | | Meom = a.Meom, |
| | | }).ToList(); |
| | | } |
| | | |
| | |
| | | it.Funit == dto.Remarks) //SetColumnsæ¯å¯ä»¥å å ç å2个就2ä¸ªåæ®µèµå¼ |
| | | .Where(it => it.Id == dto.pid) |
| | | .ExecuteCommand(); |
| | | return db.Updateable<MesQaItemsDetectDetail5>() |
| | | .SetColumns(it => |
| | | it.Meom == dto.Meom) |
| | | .Where(it => it.Id == dto.pid) |
| | | .ExecuteCommand(); |
| | | }); |
| | | } |
| | | |
| | |
| | | return result.All(b => b); |
| | | } |
| | | |
| | | public dynamic DeleteByItem(DeliveryItem dt) |
| | | { |
| | | return UseTransaction(db => |
| | | { |
| | | return DeleteDataByItem(db, dt) ? 1 : 0; |
| | | }) > 0; |
| | | } |
| | | |
| | | public dynamic DeleteListByItem(List<DeliveryItem> dts) |
| | | { |
| | | var result = dts.Select(DeleteByItem).ToList(); |
| | | return result.All(b => b); |
| | | } |
| | | |
| | | // å 餿°æ®çæ¹æ³ |
| | | private bool DeleteDataByItem(SqlSugarScope db, DeliveryItem dt) |
| | | { |
| | | var del = db.Deleteable<MesDeliveryNoteBarcode>().Where(s => s.DeliveryNo == dt.DeliveryNo && s.ProductCode==dt.ItemNo).ExecuteCommand() > 0; |
| | | |
| | | if (del) |
| | | { |
| | | return true; |
| | | } |
| | | throw new NotImplementedException("å é¤å¤±è´¥"); |
| | | } |
| | | |
| | | // å 餿°æ®çæ¹æ³ |
| | | private bool DeleteData(SqlSugarScope db, ErpBarcode barcode) |
| | | { |
| | |
| | | // å 餿°æ®çæ¹æ³ |
| | | private bool DeleteDataByShd(SqlSugarScope db, ErpDelivery delivery) |
| | | { |
| | | var del = db.Deleteable<MesDeliveryNoteBarcode>().Where(s => s.DeliveryNo == delivery.DeliveryNo).ExecuteCommand() > 0; |
| | | var del = db.Deleteable<MesDeliveryNoteBarcode>(). |
| | | Where(s => s.DeliveryNo == delivery.DeliveryNo) |
| | | .ExecuteCommand() > 0; |
| | | |
| | | if (del) |
| | | { |
| | |
| | | CreateDate = DateTime.Now, |
| | | PurchaseQty = Convert.ToDecimal(s.PurchaseQty), |
| | | IncludeQty = Convert.ToDecimal(s.IncludeQty), |
| | | DepotCode = s.DepotNo |
| | | DepotCode = s.DepotNo, |
| | | IsGift = s.IsGift |
| | | }; |
| | | return entity; |
| | | }).ToList(); |
| | |
| | | Jt=dto.JT, |
| | | Xscn=dto.XS_CN, |
| | | Sjxs=dto.SJ_xs, |
| | | Nextgx=dto.NEXT_Gx |
| | | Nextgx=dto.NEXT_Gx, |
| | | Rks=dto.RKS, |
| | | //æ²å°æ°å¢ |
| | | // WR_F_SCDD_SCTZD = dto.F_SCDD_SCTZD |
| | | //WR_F_SCDD_XH = dto.F_SCDD_XH |
| | |
| | | entity.Data = JsonConvert.SerializeObject(rohIn); |
| | | entity.Status = 1; |
| | | entity.CreateBy = "PL017"; |
| | | entity.Route= rohIn.OrderDto.FBillNo; |
| | | try |
| | | { |
| | | dynamic resultInfos = new ExpandoObject(); |
¶Ô±ÈÐÂÎļþ |
| | |
| | | using MES.Service.Dto.service; |
| | | using MES.Service.Dto.webApi; |
| | | using MES.Service.Modes; |
| | | using MES.Service.service; |
| | | using MES.Service.service.Kingdee; |
| | | using MES.Service.util; |
| | | using Microsoft.AspNetCore.Mvc; |
| | | using Newtonsoft.Json; |
| | | using System.Dynamic; |
| | | |
| | | namespace MESApplication.Controllers.Kingdee; |
| | | |
| | | |
| | | [ApiController] |
| | | [Route("api/[controller]")] |
| | | public class ErpKcController : ControllerBase |
| | | { |
| | | private readonly MessageCenterManager _manager = new(); |
| | | private readonly ErpKcManager kc = new(); |
| | | private readonly string METHOD = "POST"; |
| | | private readonly string TableName = "ERPKC"; |
| | | private readonly string URL = "http://localhost:10054/api/ErpKc/"; |
| | | |
| | | |
| | | // |
| | | [HttpPost("Save")] |
| | | public ResponseResult Save(Inventory inventory) |
| | | { |
| | | try |
| | | { |
| | | dynamic resultInfos = new ExpandoObject(); |
| | | resultInfos = kc.QueryStocks(inventory); |
| | | |
| | | return new ResponseResult |
| | | { |
| | | status = 0, |
| | | message = "OK", |
| | | data = resultInfos |
| | | }; |
| | | } |
| | | catch (Exception ex) |
| | | { |
| | | return ResponseResult.ResponseError(ex); |
| | | } |
| | | } |
| | | } |
| | |
| | | } |
| | | } |
| | | |
| | | [HttpPost("DeleteByItem")] |
| | | public ResponseResult DeleteByItem(DeliveryItem dt) |
| | | { |
| | | var entity = new MessageCenter(); |
| | | entity.TableName = TableName; |
| | | entity.Url = URL + "DeleteByItem"; |
| | | entity.Method = METHOD; |
| | | entity.Data = JsonConvert.SerializeObject(dt); |
| | | entity.Status = 1; |
| | | entity.CreateBy = "PL017"; |
| | | try |
| | | { |
| | | dynamic resultInfos = new ExpandoObject(); |
| | | var save = m.DeleteByItem(dt); |
| | | resultInfos = save; |
| | | |
| | | entity.Result = 0; |
| | | if (save) entity.Result = 1; |
| | | |
| | | entity.DealWith = 1; |
| | | _manager.save(entity); |
| | | |
| | | return new ResponseResult |
| | | { |
| | | status = 0, |
| | | message = "OK", |
| | | data = resultInfos |
| | | }; |
| | | } |
| | | catch (Exception ex) |
| | | { |
| | | entity.Result = 0; |
| | | |
| | | entity.DealWith = 0; |
| | | |
| | | entity.ResultData = ex.Message; |
| | | |
| | | _manager.save(entity); |
| | | |
| | | return ResponseResult.ResponseError(ex); |
| | | } |
| | | } |
| | | |
| | | [HttpPost("DeleteListByItem")] |
| | | public ResponseResult DeleteListByItem(List<DeliveryItem> dts) |
| | | { |
| | | var entity = new MessageCenter(); |
| | | entity.TableName = TableName; |
| | | entity.Url = URL + "DeleteListByItem"; |
| | | entity.Method = METHOD; |
| | | entity.Data = JsonConvert.SerializeObject(dts); |
| | | entity.Status = 1; |
| | | entity.CreateBy = "PL017"; |
| | | try |
| | | { |
| | | dynamic resultInfos = new ExpandoObject(); |
| | | var save = m.DeleteListByItem(dts); |
| | | resultInfos = save; |
| | | |
| | | entity.Result = 0; |
| | | if (save) entity.Result = 1; |
| | | |
| | | entity.DealWith = 1; |
| | | _manager.save(entity); |
| | | |
| | | return new ResponseResult |
| | | { |
| | | status = 0, |
| | | message = "OK", |
| | | data = resultInfos |
| | | }; |
| | | } |
| | | catch (Exception ex) |
| | | { |
| | | entity.Result = 0; |
| | | |
| | | entity.DealWith = 0; |
| | | |
| | | entity.ResultData = ex.Message; |
| | | |
| | | _manager.save(entity); |
| | | |
| | | return ResponseResult.ResponseError(ex); |
| | | } |
| | | } |
| | | |
| | | |
| | | |
| | | |
| | | } |
| | | |