| | |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "DAA008")] |
| | | public decimal? Daa008 { get; set; } |
| | | |
| | | [SugarColumn(ColumnName = "CAA015")] |
| | | public string? Caa015 { get; set; } |
| | | |
| | | [SugarColumn(ColumnName = "CUST")] |
| | | public string? Cust { get; set; } |
| | | |
| | | [SugarColumn(ColumnName = "XJ_GEN_FLAG")] |
| | | public int? XjGenFlag { get; set; } |
| | | |
| | | [SugarColumn(IsIgnore = true)] public string? SearchValue { get; set; } |
| | | |
¶Ô±ÈÐÂÎļþ |
| | |
| | | using System; |
| | | using System.Collections.Generic; |
| | | using System.Linq; |
| | | using SqlSugar; |
| | | namespace MES.Service.Modes |
| | | { |
| | | /// <summary> |
| | | /// æ»è£
ä»»å¡åä¸å±å段表 |
| | | ///</summary> |
| | | [SugarTable("EX_ZZ_CAA_FILED")] |
| | | public class ExZzCaaFiled |
| | | { |
| | | /// <summary> |
| | | /// ä»»å¡åERPID |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="ERPID" )] |
| | | public decimal? Erpid { get; set; } |
| | | /// <summary> |
| | | /// å®¢æ· |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="CUST" )] |
| | | public string? Cust { get; set; } |
| | | /// <summary> |
| | | /// ææ é¢æäºº |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="DB_PICKER" )] |
| | | public string? DbPicker { get; set; } |
| | | } |
| | | } |
| | |
| | | [SugarColumn(IsIgnore = true)] public decimal? ItemInId { get; set; } |
| | | |
| | | [SugarColumn(IsIgnore = true)] public string? Bgr { get; set; } |
| | | |
| | | [SugarColumn(IsIgnore = true)] public string? Caa015 { get; set; } |
| | | |
| | | [SugarColumn(IsIgnore = true)] public string? cust { get; set; } |
| | | } |
| | |
| | | ColumnName = "ID")] //ç¨äºSqlSugar |
| | | public decimal? Id { get; set; } |
| | | |
| | | |
| | | [SugarColumn(ColumnName = "SJID")] |
| | | public decimal? Sjid { get; set; } |
| | | |
| | | /// <summary> |
| | | /// æ£éªåå· |
| | | /// </summary> |
| | |
| | | [SugarColumn(IsIgnore = true)] public string? ItemName { get; set; } |
| | | |
| | | [SugarColumn(IsIgnore = true)] public string? ItemModel { get; set; } |
| | | |
| | | [SugarColumn(IsIgnore = true)] public string? Caa015 { get; set; } |
| | | |
| | | [SugarColumn(IsIgnore = true)] public string? cust { get; set; } |
| | | } |
| | |
| | | using SqlSugar; |
| | | |
| | | namespace MES.Service.Modes; |
| | | |
| | | /// <summary> |
| | | /// å·¥å表 |
| | | /// </summary> |
| | | [SugarTable("WOMCAA")] |
| | | public class Womcaa |
| | | namespace MES.Service.Modes |
| | | { |
| | | /// <summary> |
| | | /// èªå¢å SEQ_AOI |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "ID", IsPrimaryKey = true, |
| | | /// ä»»å¡å表 |
| | | ///</summary> |
| | | [SugarTable("WOMCAA")] |
| | | public class Womcaa |
| | | { |
| | | /// <summary> |
| | | /// èªå¢å |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="ID", IsPrimaryKey = true, |
| | | OracleSequenceName = "SEQ_AOI")] |
| | | public decimal? Id { get; set; } |
| | | |
| | | /// <summary> |
| | | /// ERPID |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "ERPID")] |
| | | public decimal? Erpid { get; set; } |
| | | |
| | | /// <summary> |
| | | /// åå· |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "CAA001")] |
| | | public string? Caa001 { get; set; } |
| | | |
| | | /// <summary> |
| | | /// åæ®ç±»å 1ãç´æ¥å
¥åº-æ®éç产 SCDD03_SYS2ãç´æ¥å
¥åº-è¿å·¥ç产 SCDD04_SYS3ãå·¥åºæ±æ¥-æ®éç产 |
| | | /// SCDD01_SYS4ãå·¥åºæ±æ¥-è¿å·¥ç产 SCDD02_SYS |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "CAA004")] |
| | | public string? Caa004 { get; set; } |
| | | |
| | | /// <summary> |
| | | /// å¼åæ¥æ |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "CAA005")] |
| | | public string? Caa005 { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 产åç¼ç |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "CAA006")] |
| | | public string? Caa006 { get; set; } |
| | | |
| | | /// <summary> |
| | | /// åä½ |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "CAA009")] |
| | | public string? Caa009 { get; set; } |
| | | |
| | | /// <summary> |
| | | /// é¢è®¡å¼å·¥æ¶é´ |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "CAA010")] |
| | | public string? Caa010 { get; set; } |
| | | |
| | | /// <summary> |
| | | /// é¢è®¡å®å·¥æ¶é´ |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "CAA011")] |
| | | public string? Caa011 { get; set; } |
| | | |
| | | /// <summary> |
| | | /// æ°é |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "CAA012")] |
| | | public decimal? Caa012 { get; set; } |
| | | |
| | | /// <summary> |
| | | /// BOMçæ¬¡ |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "CAA013")] |
| | | public string? Caa013 { get; set; } |
| | | |
| | | /// <summary> |
| | | /// éå®è®¢åå· |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "CAA015")] |
| | | public string? Caa015 { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 夿³¨ |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "CAA016")] |
| | | public string? Caa016 { get; set; } |
| | | |
| | | /// <summary> |
| | | /// å·²ææ°é |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "CAA017")] |
| | | public decimal? Caa017 { get; set; } |
| | | |
| | | /// <summary> |
| | | /// ERPæºåID |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "CAA018")] |
| | | public decimal? Caa018 { get; set; } |
| | | |
| | | /// <summary> |
| | | /// ERPæºåè¡å· |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "CAA019")] |
| | | public decimal? Caa019 { get; set; } |
| | | |
| | | /// <summary> |
| | | /// ERPæºååå·(ä»»å¡åå·) |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "CAA020")] |
| | | public string? Caa020 { get; set; } |
| | | |
| | | /// <summary> |
| | | /// å·¥ä½è½¦é´ |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "CAA021")] |
| | | public string? Caa021 { get; set; } |
| | | |
| | | /// <summary> |
| | | /// å®¡æ ¸ç |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "FSTATUS")] |
| | | public decimal? Fstatus { get; set; } |
| | | |
| | | /// <summary> |
| | | /// å®¡æ ¸æ¥æ |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "CHECK_DATE")] |
| | | public DateTime? CheckDate { get; set; } |
| | | |
| | | /// <summary> |
| | | /// å®¡æ ¸äºº |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "CHECK_USER")] |
| | | public string? CheckUser { get; set; } |
| | | |
| | | /// <summary> |
| | | /// æªææ°é |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "CAA022")] |
| | | public decimal? Caa022 { get; set; } |
| | | |
| | | /// <summary> |
| | | /// ç¶æ å®å·¥ï¼æªå®å·¥ |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "CAA023")] |
| | | public string? Caa023 { get; set; } |
| | | |
| | | /// <summary> |
| | | /// å·²å
¥åºæ°é |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "CAA024")] |
| | | public decimal? Caa024 { get; set; } |
| | | |
| | | /// <summary> |
| | | /// å·¥èºè·¯çº¿ |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "ROUTING_ID")] |
| | | public string? RoutingId { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 产线 |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "WORK_SHOP_ID")] |
| | | public string? WorkShopId { get; set; } |
| | | |
| | | /// <summary> |
| | | /// ä»åº |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "DEPOT_CODE")] |
| | | public string? DepotCode { get; set; } |
| | | |
| | | /// <summary> |
| | | /// åæ®æ¥æ |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "CREATE_DATE")] |
| | | public string? CreateDate { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 计åç» |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "WORK_GROUP_ID")] |
| | | public string? WorkGroupId { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 计åå |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "PLAN_ID")] |
| | | public string? PlanId { get; set; } |
| | | |
| | | /// <summary> |
| | | /// å
¥åºä¸é |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "STOCK_INLIMITH")] |
| | | public string? StockInlimith { get; set; } |
| | | |
| | | /// <summary> |
| | | /// å
¥åºä¸é |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "STOCK_INLIMITL")] |
| | | public string? StockInlimitl { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 计åè·è¸ªå· |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "MTONO")] |
| | | public string? Mtono { get; set; } |
| | | |
| | | /// <summary> |
| | | /// æ¹å· |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "LOT")] |
| | | public string? Lot { get; set; } |
| | | |
| | | /// <summary> |
| | | /// éå®è®¢åè¡å· |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "CAA015_HEAD")] |
| | | public string? Caa015Head { get; set; } |
| | | |
| | | /// <summary> |
| | | /// çææ¹å¼ |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "CREATE_TYPE")] |
| | | public string? CreateType { get; set; } |
| | | |
| | | /// <summary> |
| | | /// æºåç±»å |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "SRC_BILL_TYPE")] |
| | | public string? SrcBillType { get; set; } |
| | | |
| | | /// <summary> |
| | | /// æºåç¼å· |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "SRC_BILL_NO")] |
| | | public string? SrcBillNo { get; set; } |
| | | |
| | | /// <summary> |
| | | /// æºååå½è¡å· |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "SRC_BILLENTRYSEQ")] |
| | | public string? SrcBillentryseq { get; set; } |
| | | |
| | | /// <summary> |
| | | /// éæ±åæ®å· |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "SALE_ORDER_NO")] |
| | | public string? SaleOrderNo { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 鿱忮è¡å· |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "SALE_ORDER_ENTRYSEQ")] |
| | | public string? SaleOrderEntryseq { get; set; } |
| | | |
| | | /// <summary> |
| | | /// ç»æ¡äºº |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "FORCE_CLOSERID")] |
| | | public string? ForceCloserid { get; set; } |
| | | |
| | | /// <summary> |
| | | /// ç»æ¡ç±»å |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "CLOSE_TYPE")] |
| | | public string? CloseType { get; set; } |
| | | |
| | | /// <summary> |
| | | /// æºæå订åç¼å· |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "SRC_SPLIT_BILLNO")] |
| | | public string? SrcSplitBillno { get; set; } |
| | | |
| | | /// <summary> |
| | | /// ç产订åè¡å
ç |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "FMOENTRYID")] |
| | | public decimal? FMOENTRYID { get; set; } |
| | | } |
| | | public decimal? Id { get; set; } |
| | | /// <summary> |
| | | /// ERPID |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="ERPID" )] |
| | | public decimal? Erpid { get; set; } |
| | | /// <summary> |
| | | /// åæ®ç¼å· |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="CAA001" )] |
| | | public string? Caa001 { get; set; } |
| | | /// <summary> |
| | | /// åæ®ç±»å |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="CAA004" )] |
| | | public string? Caa004 { get; set; } |
| | | /// <summary> |
| | | /// 计åä¸è¾¾æ¥æ |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="CAA005" )] |
| | | public string? Caa005 { get; set; } |
| | | /// <summary> |
| | | /// 产åç¼ç |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="CAA006" )] |
| | | public string? Caa006 { get; set; } |
| | | /// <summary> |
| | | /// åä½ |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="CAA009" )] |
| | | public string? Caa009 { get; set; } |
| | | /// <summary> |
| | | /// é¢è®¡å¼å·¥æ¶é´ |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="CAA010" )] |
| | | public string? Caa010 { get; set; } |
| | | /// <summary> |
| | | /// é¢è®¡å®å·¥æ¶é´ |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="CAA011" )] |
| | | public string? Caa011 { get; set; } |
| | | /// <summary> |
| | | /// 工忰é |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="CAA012" )] |
| | | public decimal? Caa012 { get; set; } |
| | | /// <summary> |
| | | /// BOMçæ¬¡ |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="CAA013" )] |
| | | public string? Caa013 { get; set; } |
| | | /// <summary> |
| | | /// éå®è®¢åå· |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="CAA015" )] |
| | | public string? Caa015 { get; set; } |
| | | /// <summary> |
| | | /// 夿³¨ |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="CAA016" )] |
| | | public string? Caa016 { get; set; } |
| | | /// <summary> |
| | | /// å·²ææ°éï¼å¼ç¨ï¼ |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="CAA017" )] |
| | | public decimal? Caa017 { get; set; } |
| | | /// <summary> |
| | | /// ERPç产订åID |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="CAA018" )] |
| | | public decimal? Caa018 { get; set; } |
| | | /// <summary> |
| | | /// ERPç产订ååºå· |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="CAA019" )] |
| | | public decimal? Caa019 { get; set; } |
| | | /// <summary> |
| | | /// ERPç产订ååå· |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="CAA020" )] |
| | | public string? Caa020 { get; set; } |
| | | /// <summary> |
| | | /// çäº§è½¦é´ |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="CAA021" )] |
| | | public string? Caa021 { get; set; } |
| | | /// <summary> |
| | | /// å®¡æ ¸ç |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="FSTATUS" )] |
| | | public decimal? Fstatus { get; set; } |
| | | /// <summary> |
| | | /// å®¡æ ¸æ¥æ |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="CHECK_DATE" )] |
| | | public DateTime? CheckDate { get; set; } |
| | | /// <summary> |
| | | /// å®¡æ ¸äºº |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="CHECK_USER" )] |
| | | public string? CheckUser { get; set; } |
| | | /// <summary> |
| | | /// æªææ°éï¼å¼ç¨ï¼ |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="CAA022" )] |
| | | public decimal? Caa022 { get; set; } |
| | | /// <summary> |
| | | /// "å·¥åç¶æ 1ã计å 2ã计å确认 3ãä¸è¾¾ 4ãå¼å·¥ 5ãå®å·¥ 6ãç»æ¡ 7ãç»ç®" |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="CAA023" )] |
| | | public string? Caa023 { get; set; } |
| | | /// <summary> |
| | | /// å·²å
¥åºæ°é |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="CAA024" )] |
| | | public decimal? Caa024 { get; set; } |
| | | /// <summary> |
| | | /// å·¥èºè·¯çº¿ |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="ROUTING_ID" )] |
| | | public string? RoutingId { get; set; } |
| | | /// <summary> |
| | | /// 产线 |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="WORK_SHOP_ID" )] |
| | | public string? WorkShopId { get; set; } |
| | | /// <summary> |
| | | /// ä»åº |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="DEPOT_CODE" )] |
| | | public string? DepotCode { get; set; } |
| | | /// <summary> |
| | | /// åæ®æ¥æ |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="CREATE_DATE" )] |
| | | public string? CreateDate { get; set; } |
| | | /// <summary> |
| | | /// 计åç» |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="WORK_GROUP_ID" )] |
| | | public string? WorkGroupId { get; set; } |
| | | /// <summary> |
| | | /// 计åå |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="PLAN_ID" )] |
| | | public string? PlanId { get; set; } |
| | | /// <summary> |
| | | /// å
¥åºä¸é |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="STOCK_INLIMITH" )] |
| | | public string? StockInlimith { get; set; } |
| | | /// <summary> |
| | | /// å
¥åºä¸é |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="STOCK_INLIMITL" )] |
| | | public string? StockInlimitl { get; set; } |
| | | /// <summary> |
| | | /// 计åè·è¸ªå· |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="MTONO" )] |
| | | public string? Mtono { get; set; } |
| | | /// <summary> |
| | | /// æ¹å· |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="LOT" )] |
| | | public string? Lot { get; set; } |
| | | /// <summary> |
| | | /// éå®è®¢åè¡å· |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="CAA015_HEAD" )] |
| | | public string? Caa015Head { get; set; } |
| | | /// <summary> |
| | | /// çææ¹å¼ |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="CREATE_TYPE" )] |
| | | public string? CreateType { get; set; } |
| | | /// <summary> |
| | | /// æºåç±»å |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="SRC_BILL_TYPE" )] |
| | | public string? SrcBillType { get; set; } |
| | | /// <summary> |
| | | /// æºåç¼ç |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="SRC_BILL_NO" )] |
| | | public string? SrcBillNo { get; set; } |
| | | /// <summary> |
| | | /// æºååå½è¡å· |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="SRC_BILLENTRYSEQ" )] |
| | | public string? SrcBillentryseq { get; set; } |
| | | /// <summary> |
| | | /// éæ±åæ®å· |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="SALE_ORDER_NO" )] |
| | | public string? SaleOrderNo { get; set; } |
| | | /// <summary> |
| | | /// 鿱忮è¡å· |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="SALE_ORDER_ENTRYSEQ" )] |
| | | public string? SaleOrderEntryseq { get; set; } |
| | | /// <summary> |
| | | /// ç»æ¡äºº |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="FORCE_CLOSERID" )] |
| | | public string? ForceCloserid { get; set; } |
| | | /// <summary> |
| | | /// ç»æ¡ç±»å |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="CLOSE_TYPE" )] |
| | | public string? CloseType { get; set; } |
| | | /// <summary> |
| | | /// æºæå订åç¼å· |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="SRC_SPLIT_BILLNO" )] |
| | | public string? SrcSplitBillno { get; set; } |
| | | /// <summary> |
| | | /// ç产订åè¡å
ç |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="FMOENTRYID" )] |
| | | public decimal? Fmoentryid { get; set; } |
| | | /// <summary> |
| | | /// æäº§çº¿å« |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="PROD_LINE" )] |
| | | public string? ProdLine { get; set; } |
| | | } |
| | | } |
| | |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)] |
| | | public decimal? Id { get; set; } |
| | | |
| | | /// <summary> |
| | | /// æäº§ID |
| | | /// </summary> |
| | | /// æäº§ID |
| | | ///</summary> |
| | | [SugarColumn(ColumnName = "PID")] |
| | | public decimal? Pid { get; set; } |
| | | |
| | | /// <summary> |
| | | /// åå· |
| | | /// </summary> |
| | | /// åå· |
| | | ///</summary> |
| | | [SugarColumn(ColumnName = "DAA001")] |
| | | public string? Daa001 { get; set; } |
| | | |
| | | public string Daa001 { get; set; } |
| | | /// <summary> |
| | | /// 产åID |
| | | /// </summary> |
| | | /// 产åID |
| | | ///</summary> |
| | | [SugarColumn(ColumnName = "DAA002")] |
| | | public string? Daa002 { get; set; } |
| | | |
| | | public string Daa002 { get; set; } |
| | | /// <summary> |
| | | /// 产ååç§° |
| | | /// </summary> |
| | | /// 产ååç§° |
| | | ///</summary> |
| | | [SugarColumn(ColumnName = "DAA003")] |
| | | public string? Daa003 { get; set; } |
| | | |
| | | public string Daa003 { get; set; } |
| | | /// <summary> |
| | | /// 产åè§æ ¼ |
| | | /// </summary> |
| | | /// 产åè§æ ¼ |
| | | ///</summary> |
| | | [SugarColumn(ColumnName = "DAA004")] |
| | | public string? Daa004 { get; set; } |
| | | |
| | | public string Daa004 { get; set; } |
| | | /// <summary> |
| | | /// åä½ |
| | | /// </summary> |
| | | /// åä½ |
| | | ///</summary> |
| | | [SugarColumn(ColumnName = "DAA005")] |
| | | public string? Daa005 { get; set; } |
| | | |
| | | public string Daa005 { get; set; } |
| | | /// <summary> |
| | | /// ERPé¢è®¡å¼å·¥æ¶é´ |
| | | /// </summary> |
| | | /// ERPé¢è®¡å¼å·¥æ¶é´ |
| | | ///</summary> |
| | | [SugarColumn(ColumnName = "DAA006")] |
| | | public DateTime? Daa006 { get; set; } |
| | | |
| | | /// <summary> |
| | | /// ERPé¢è®¡å®å·¥æ¶é´ |
| | | /// </summary> |
| | | /// ERPé¢è®¡å®å·¥æ¶é´ |
| | | ///</summary> |
| | | [SugarColumn(ColumnName = "DAA007")] |
| | | public DateTime? Daa007 { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 工忰é |
| | | /// </summary> |
| | | /// 工忰é |
| | | ///</summary> |
| | | [SugarColumn(ColumnName = "DAA008")] |
| | | public decimal? Daa008 { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 夿³¨ |
| | | /// </summary> |
| | | /// 夿³¨ |
| | | ///</summary> |
| | | [SugarColumn(ColumnName = "DAA009")] |
| | | public string? Daa009 { get; set; } |
| | | |
| | | public string Daa009 { get; set; } |
| | | /// <summary> |
| | | /// å
¥åºæ°é |
| | | /// </summary> |
| | | /// å
¥åºæ°é |
| | | ///</summary> |
| | | [SugarColumn(ColumnName = "DAA010")] |
| | | public decimal? Daa010 { get; set; } |
| | | |
| | | /// <summary> |
| | | /// å·²ç产é |
| | | /// </summary> |
| | | /// å·²ç产é |
| | | ///</summary> |
| | | [SugarColumn(ColumnName = "DAA011")] |
| | | public decimal? Daa011 { get; set; } |
| | | |
| | | /// <summary> |
| | | /// æ¥åºæ°é |
| | | /// </summary> |
| | | /// æ¥åºæ°é |
| | | ///</summary> |
| | | [SugarColumn(ColumnName = "DAA012")] |
| | | public decimal? Daa012 { get; set; } |
| | | |
| | | /// <summary> |
| | | /// å·¥ä½è½¦é´ |
| | | /// </summary> |
| | | /// å·¥ä½è½¦é´ |
| | | ///</summary> |
| | | [SugarColumn(ColumnName = "DAA013")] |
| | | public string? Daa013 { get; set; } |
| | | |
| | | public string Daa013 { get; set; } |
| | | /// <summary> |
| | | /// ææååå· |
| | | /// </summary> |
| | | /// ææååå· |
| | | ///</summary> |
| | | [SugarColumn(ColumnName = "DAA014")] |
| | | public string? Daa014 { get; set; } |
| | | |
| | | public string Daa014 { get; set; } |
| | | /// <summary> |
| | | /// çäº§çº¿å« |
| | | /// </summary> |
| | | /// çäº§çº¿å« |
| | | ///</summary> |
| | | [SugarColumn(ColumnName = "DAA015")] |
| | | public string? Daa015 { get; set; } |
| | | |
| | | public string Daa015 { get; set; } |
| | | /// <summary> |
| | | /// å®é
å¼å·¥æ¥ |
| | | /// </summary> |
| | | /// å®é
å¼å·¥æ¥ |
| | | ///</summary> |
| | | [SugarColumn(ColumnName = "DAA016")] |
| | | public DateTime? Daa016 { get; set; } |
| | | |
| | | /// <summary> |
| | | /// å®é
å®å·¥æ¥ |
| | | /// </summary> |
| | | /// å®é
å®å·¥æ¥ |
| | | ///</summary> |
| | | [SugarColumn(ColumnName = "DAA017")] |
| | | public DateTime? Daa017 { get; set; } |
| | | |
| | | /// <summary> |
| | | /// å·¥åç¶æ |
| | | /// </summary> |
| | | /// å·¥åç¶æ |
| | | ///</summary> |
| | | [SugarColumn(ColumnName = "DAA018")] |
| | | public string? Daa018 { get; set; } |
| | | |
| | | public string Daa018 { get; set; } |
| | | /// <summary> |
| | | /// é½å¥ç¶æ |
| | | /// </summary> |
| | | /// é½å¥ç¶æ |
| | | ///</summary> |
| | | [SugarColumn(ColumnName = "DAA019")] |
| | | public string? Daa019 { get; set; } |
| | | |
| | | public string Daa019 { get; set; } |
| | | /// <summary> |
| | | /// å®¡æ ¸ç |
| | | /// </summary> |
| | | /// å®¡æ ¸ç |
| | | ///</summary> |
| | | [SugarColumn(ColumnName = "FSTATUS")] |
| | | public decimal? Fstatus { get; set; } |
| | | |
| | | /// <summary> |
| | | /// å®¡æ ¸æ¥æ |
| | | /// </summary> |
| | | /// å®¡æ ¸æ¥æ |
| | | ///</summary> |
| | | [SugarColumn(ColumnName = "CHECK_DATE")] |
| | | public DateTime? CheckDate { get; set; } |
| | | |
| | | /// <summary> |
| | | /// å®¡æ ¸äºº |
| | | /// </summary> |
| | | /// å®¡æ ¸äºº |
| | | ///</summary> |
| | | [SugarColumn(ColumnName = "CHECK_USER")] |
| | | public string? CheckUser { get; set; } |
| | | |
| | | public string CheckUser { get; set; } |
| | | /// <summary> |
| | | /// 线å«ç¼ç |
| | | /// </summary> |
| | | /// 线å«ç¼ç |
| | | ///</summary> |
| | | [SugarColumn(ColumnName = "DAA020")] |
| | | public string? Daa020 { get; set; } |
| | | |
| | | public string Daa020 { get; set; } |
| | | /// <summary> |
| | | /// ä»»å¡ååå· |
| | | /// </summary> |
| | | /// ä»»å¡ååå· |
| | | ///</summary> |
| | | [SugarColumn(ColumnName = "DAA021")] |
| | | public string? Daa021 { get; set; } |
| | | |
| | | public string Daa021 { get; set; } |
| | | /// <summary> |
| | | /// éç¥å¤æï¼0-æªéç¥ï¼1-éç¥ |
| | | /// </summary> |
| | | /// éç¥å¤æï¼0-æªéç¥ï¼1-éç¥ |
| | | ///</summary> |
| | | [SugarColumn(ColumnName = "DAA022")] |
| | | public decimal? Daa022 { get; set; } |
| | | |
| | | /// <summary> |
| | | /// ç产åºå· |
| | | /// </summary> |
| | | /// ç产åºå· |
| | | ///</summary> |
| | | [SugarColumn(ColumnName = "DAA023")] |
| | | public decimal? Daa023 { get; set; } |
| | | |
| | | /// <summary> |
| | | /// æäº§æ¥æ |
| | | /// </summary> |
| | | /// æäº§æ¥æ |
| | | ///</summary> |
| | | [SugarColumn(ColumnName = "DAA024")] |
| | | public string? Daa024 { get; set; } |
| | | |
| | | public string Daa024 { get; set; } |
| | | /// <summary> |
| | | /// é¦ä»¶æ¯å¦æ£éª1-æ£éªï¼0æªæ£éª |
| | | /// </summary> |
| | | /// é¦ä»¶æ¯å¦æ£éª1-æ£éªï¼0æªæ£éª |
| | | ///</summary> |
| | | [SugarColumn(ColumnName = "DAA025")] |
| | | public string? Daa025 { get; set; } |
| | | |
| | | public string Daa025 { get; set; } |
| | | /// <summary> |
| | | /// é¦ä»¶æ£éªç»æ |
| | | /// </summary> |
| | | /// é¦ä»¶æ£éªç»æ |
| | | ///</summary> |
| | | [SugarColumn(ColumnName = "DAA026")] |
| | | public string? Daa026 { get; set; } |
| | | |
| | | public string Daa026 { get; set; } |
| | | /// <summary> |
| | | /// å·²æ¥æ£ï¼0-æªæ¥æ£ï¼1-å·²æ¥æ£ |
| | | /// </summary> |
| | | /// å·²æ¥æ£ï¼0-æªæ¥æ£ï¼1-å·²æ¥æ£ |
| | | ///</summary> |
| | | [SugarColumn(ColumnName = "IS_REPORTCHECK")] |
| | | public decimal? IsReportcheck { get; set; } |
| | | |
| | | /// <summary> |
| | | /// æ¥æ£äºº |
| | | /// </summary> |
| | | /// æ¥æ£äºº |
| | | ///</summary> |
| | | [SugarColumn(ColumnName = "USNAME")] |
| | | public string? Usname { get; set; } |
| | | |
| | | public string Usname { get; set; } |
| | | /// <summary> |
| | | /// æ¥æ£æ¶é´ |
| | | /// </summary> |
| | | /// æ¥æ£æ¶é´ |
| | | ///</summary> |
| | | [SugarColumn(ColumnName = "REPORTTIME")] |
| | | public DateTime? Reporttime { get; set; } |
| | | |
| | | /// <summary> |
| | | /// æºå°ç¼å· |
| | | /// </summary> |
| | | /// æºå°ç¼å· |
| | | ///</summary> |
| | | [SugarColumn(ColumnName = "MACHINE_NO")] |
| | | public string? MachineNo { get; set; } |
| | | |
| | | public string MachineNo { get; set; } |
| | | /// <summary> |
| | | /// 夿宿1-宿ï¼0æªå®æ |
| | | /// </summary> |
| | | /// 夿宿1-宿ï¼0æªå®æ |
| | | ///</summary> |
| | | [SugarColumn(ColumnName = "DAA027")] |
| | | public decimal? Daa027 { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 夿宿æ¶é´ |
| | | /// </summary> |
| | | /// 夿宿æ¶é´ |
| | | ///</summary> |
| | | [SugarColumn(ColumnName = "DAA028")] |
| | | public string? Daa028 { get; set; } |
| | | |
| | | public string Daa028 { get; set; } |
| | | /// <summary> |
| | | /// æ åå·¥æ¶ |
| | | /// </summary> |
| | | /// æ åå·¥æ¶ |
| | | ///</summary> |
| | | [SugarColumn(ColumnName = "PROD_HOUR")] |
| | | public decimal? ProdHour { get; set; } |
| | | |
| | | /// <summary> |
| | | /// åäººå°æ¶äº§è½ |
| | | /// </summary> |
| | | /// åäººå°æ¶äº§è½ |
| | | ///</summary> |
| | | [SugarColumn(ColumnName = "PERSON_HOUR_CAPACITY")] |
| | | public decimal? PersonHourCapacity { get; set; } |
| | | |
| | | /// <summary> |
| | | /// ç论æ 产 |
| | | /// </summary> |
| | | /// ç论æ 产 |
| | | ///</summary> |
| | | [SugarColumn(ColumnName = "THE_CAPACITY")] |
| | | public decimal? TheCapacity { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 计åç¨äººæ° |
| | | /// </summary> |
| | | /// 计åç¨äººæ° |
| | | ///</summary> |
| | | [SugarColumn(ColumnName = "PLAN_PERSONNEL")] |
| | | public decimal? PlanPersonnel { get; set; } |
| | | |
| | | /// <summary> |
| | | /// è®¡åæ åäº§è½ |
| | | /// </summary> |
| | | /// è®¡åæ åäº§è½ |
| | | ///</summary> |
| | | [SugarColumn(ColumnName = "PLAN_CAPACITY")] |
| | | public decimal? PlanCapacity { get; set; } |
| | | |
| | | /// <summary> |
| | | /// çè®ºç¨æ¶/M |
| | | /// </summary> |
| | | /// çè®ºç¨æ¶/M |
| | | ///</summary> |
| | | [SugarColumn(ColumnName = "THE_MIN")] |
| | | public decimal? TheMin { get; set; } |
| | | |
| | | /// <summary> |
| | | /// çè®ºç¨æ¶/H |
| | | /// </summary> |
| | | /// çè®ºç¨æ¶/H |
| | | ///</summary> |
| | | [SugarColumn(ColumnName = "THE_HOUR")] |
| | | public decimal? TheHour { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 线ä½ç±»å« |
| | | /// </summary> |
| | | /// 线ä½ç±»å« |
| | | ///</summary> |
| | | [SugarColumn(ColumnName = "LINE_TYPE")] |
| | | public string? LineType { get; set; } |
| | | |
| | | public string LineType { get; set; } |
| | | /// <summary> |
| | | /// æ åäººæ° |
| | | /// </summary> |
| | | /// æ åäººæ° |
| | | ///</summary> |
| | | [SugarColumn(ColumnName = "PERSONNEL")] |
| | | public decimal? Personnel { get; set; } |
| | | |
| | | /// <summary> |
| | | /// æ¢çº¿æ¶é´ |
| | | /// </summary> |
| | | /// æ¢çº¿æ¶é´ |
| | | ///</summary> |
| | | [SugarColumn(ColumnName = "CHANGE_LINE_TIME")] |
| | | public decimal? ChangeLineTime { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 伿¯æ¶é´ |
| | | /// </summary> |
| | | /// 伿¯æ¶é´ |
| | | ///</summary> |
| | | [SugarColumn(ColumnName = "REST_TIME")] |
| | | public decimal? RestTime { get; set; } |
| | | |
| | | /// <summary> |
| | | /// æäº§åºå· |
| | | /// </summary> |
| | | /// æäº§åºå· |
| | | ///</summary> |
| | | [SugarColumn(ColumnName = "SCHEDULE_ORDER")] |
| | | public decimal? ScheduleOrder { get; set; } |
| | | |
| | | /// <summary> |
| | | /// MESé¢è®¡å¼å·¥æ¶é´ |
| | | /// </summary> |
| | | /// MESé¢è®¡å¼å·¥æ¶é´ |
| | | ///</summary> |
| | | [SugarColumn(ColumnName = "MES_START_PROD")] |
| | | public DateTime? MesStartProd { get; set; } |
| | | |
| | | /// <summary> |
| | | /// MESé¢è®¡å®å·¥æ¶é´ |
| | | /// </summary> |
| | | /// MESé¢è®¡å®å·¥æ¶é´ |
| | | ///</summary> |
| | | [SugarColumn(ColumnName = "MES_END_PROD")] |
| | | public DateTime? MesEndProd { get; set; } |
| | | /// <summary> |
| | | /// æäº§æ¨éæ è¯ |
| | | ///</summary> |
| | | [SugarColumn(ColumnName = "PRODTS")] |
| | | public decimal? Prodts { get; set; } |
| | | /// <summary> |
| | | /// é¢è®¡å¤ææ¶é´ |
| | | ///</summary> |
| | | [SugarColumn(ColumnName = "PREPARE_TIME")] |
| | | public DateTime? PrepareTime { get; set; } |
| | | /// <summary> |
| | | /// æä»¶æå
¥äººæ° |
| | | ///</summary> |
| | | [SugarColumn(ColumnName = "CJ_WORKER")] |
| | | public decimal? CjWorker { get; set; } |
| | | /// <summary> |
| | | /// æä»¶è®¡åæå
¥äººæ° |
| | | ///</summary> |
| | | [SugarColumn(ColumnName = "P_CJ_WORKER")] |
| | | public decimal? PCjWorker { get; set; } |
| | | /// <summary> |
| | | /// æä»¶æ¥äº§é |
| | | ///</summary> |
| | | [SugarColumn(ColumnName = "CJ_DAILY_OUT")] |
| | | public decimal? CjDailyOut { get; set; } |
| | | /// <summary> |
| | | /// æä»¶æ åå·¥æ¶ |
| | | ///</summary> |
| | | [SugarColumn(ColumnName = "CJ_STD_HOUR")] |
| | | public decimal? CjStdHour { get; set; } |
| | | /// <summary> |
| | | /// é¡çæå
¥äººæ° |
| | | ///</summary> |
| | | [SugarColumn(ColumnName = "HX_WORKER")] |
| | | public decimal? HxWorker { get; set; } |
| | | /// <summary> |
| | | /// é¡ç计åæå
¥äººæ° |
| | | ///</summary> |
| | | [SugarColumn(ColumnName = "P_HX_WORKER")] |
| | | public decimal? PHxWorker { get; set; } |
| | | /// <summary> |
| | | /// é¡çæ¥äº§é |
| | | ///</summary> |
| | | [SugarColumn(ColumnName = "HX_DAILY_OUT")] |
| | | public decimal? HxDailyOut { get; set; } |
| | | /// <summary> |
| | | /// é¡çæ åå·¥æ¶ |
| | | ///</summary> |
| | | [SugarColumn(ColumnName = "HX_STD_HOUR")] |
| | | public decimal? HxStdHour { get; set; } |
| | | /// <summary> |
| | | /// æä»¶æ°é |
| | | ///</summary> |
| | | [SugarColumn(ColumnName = "CJ_NUM")] |
| | | public decimal? CjNum { get; set; } |
| | | /// <summary> |
| | | /// å®¢æ· |
| | | ///</summary> |
| | | [SugarColumn(ColumnName = "CUST")] |
| | | public string Cust { get; set; } |
| | | /// <summary> |
| | | /// æ»è£
å·¥åº 1ææ 4å å·¥ 2ç»è£
3å
è£
|
| | | ///</summary> |
| | | [SugarColumn(ColumnName = "ZZ_GX")] |
| | | public decimal? ZzGx { get; set; } |
| | | /// <summary> |
| | | /// éç¥å¤ææ¶é´ |
| | | ///</summary> |
| | | [SugarColumn(ColumnName = "DAA029")] |
| | | public DateTime? Daa029 { get; set; } |
| | | /// <summary> |
| | | /// éå®è®¢åå·ï¼ç®å䏿¥¼å¢è¡¥ä½¿ç¨ï¼ |
| | | ///</summary> |
| | | [SugarColumn(ColumnName = "XSDDH")] |
| | | public string Xsddh { get; set; } |
| | | /// <summary> |
| | | /// |
| | | ///</summary> |
| | | [SugarColumn(ColumnName = "TEST")] |
| | | public decimal? Test { get; set; } |
| | | |
| | | } |
| | |
| | | |
| | | var qsItemOqcReqs = db |
| | | .Queryable<QsItemOqcReq, MesItems, MesInvItemIns, MesInvTransaction, |
| | | RKJDaa001, Womdaa, VLineUser,MesDeptUser>( |
| | | (a, b, c, ca, m, da, z,d) => new JoinQueryInfos( |
| | | RKJDaa001, Womdaa, VLineUser,MesDeptUser, Womcaa, ExZzCaaFiled>( |
| | | (a, b, c, ca, m, da, z,d, caa,zf) => new JoinQueryInfos( |
| | | JoinType.Left, a.ItemNo == b.ItemNo, |
| | | JoinType.Left, a.BillNo == c.BillNo, |
| | | JoinType.Left, |
| | |
| | | JoinType.Left, c.Id == m.ItemInId && a.ItemNo == m.ItemNo, |
| | | JoinType.Left, da.Daa001 == c.RbillNo, |
| | | JoinType.Left, da.Daa015 == z.LineNo, |
| | | JoinType.Left,c.Bgr == d.UserNo |
| | | JoinType.Left,c.Bgr == d.UserNo, |
| | | JoinType.Left, da.Daa021 == caa.Caa020, |
| | | JoinType.Left, caa.Erpid == zf.Erpid |
| | | )) |
| | | // .WhereIF(lineNo != null && lineNo.Length > 0, |
| | | // (a, b, c, ca, m, da) => lineNo.Contains(da.Daa015)) |
| | | .WhereIF(!"PL017".Equals(queryObj.createUser), |
| | | (a, b, c, ca, m, da, z,d) => lineNo.Contains(da.Daa015)) |
| | | (a, b, c, ca, m, da, z, d, caa, zf) => lineNo.Contains(da.Daa015)) |
| | | .WhereIF(!string.IsNullOrEmpty(queryObj.id), |
| | | (a, b, c, ca, m, da, z,d) => a.Id.ToString() == queryObj.id) |
| | | (a, b, c, ca, m, da, z, d, caa, zf) => a.Id.ToString() == queryObj.id) |
| | | .WhereIF( |
| | | StringUtil.IsNotNullOrEmpty(queryObj.result) && |
| | | "æªå®æ".Equals(queryObj.result), |
| | | (a, b, c, ca, m, da, z,d) => a.FcheckResu == null) |
| | | (a, b, c, ca, m, da, z, d, caa, zf) => a.FcheckResu == null) |
| | | .WhereIF( |
| | | StringUtil.IsNotNullOrEmpty(queryObj.result) && |
| | | !"æªå®æ".Equals(queryObj.result), |
| | | (a, b, c, ca, m, da, z,d) => a.FcheckResu != null) |
| | | (a, b, c, ca, m, da, z, d, caa, zf) => a.FcheckResu != null) |
| | | //å ç鿡件,æ ¹æ®ä¾åºåï¼ç©æç¼ç ï¼ç©æåç§°æç´¢ |
| | | //.WhereIF(queryObj.SearchValue!=null && queryObj.SearchValue!="", (a) => a.SuppName == queryObj.SearchValue|| a.ItemName == queryObj.SearchValue || a.ItemNo == queryObj.SearchValue ) |
| | | .WhereIF(queryObj.SearchValue != null && queryObj.SearchValue != "", |
| | | (a, b, c, ca, m, da, z, d) => b.ItemName.ToLower().Contains(queryObj.SearchValue.ToLower()) |
| | | (a, b, c, ca, m, da, z, d, caa, zf) => b.ItemName.ToLower().Contains(queryObj.SearchValue.ToLower()) |
| | | || a.ItemNo.ToLower().Contains(queryObj.SearchValue.ToLower())) |
| | | .Select((a, b, c, ca, m, da, z,d) => new QsItemOqcReq |
| | | .Select((a, b, c, ca, m, da, z, d, caa, zf) => new QsItemOqcReq |
| | | { |
| | | BillNo = a.BillNo, |
| | | Fsubmit = a.Fsubmit, |
| | |
| | | Daa015 = da.Daa015, |
| | | LineNo = c.LineNo, |
| | | Quantity = m.Quantity, |
| | | Caa015 = caa.Caa015, |
| | | cust = da.Cust == null ? zf.Cust : da.Cust, |
| | | Bgr = d.UserName |
| | | }) |
| | | .OrderBy(a => a.CreateDate, OrderByType.Desc) |
| | |
| | | using MES.Service.Modes; |
| | | using MES.Service.util; |
| | | using SqlSugar; |
| | | using System.Data; |
| | | using DbType = System.Data.DbType; |
| | | |
| | | namespace MES.Service.service.QC; |
| | | |
| | |
| | | |
| | | return withOracle; |
| | | } |
| | | |
| | | public bool QaSubmit(LLJDto dto) |
| | | { |
| | | |
| | | try |
| | | { |
| | | // å®ä¹è¾åºåæ° |
| | | var outputResult = new SugarParameter("C_RES", null, |
| | | DbType.Int32, ParameterDirection.Output, |
| | | 4000); |
| | | |
| | | var outputMessage = new SugarParameter("C_MSG", null,DbType.String, |
| | | ParameterDirection.Output, 4000); |
| | | |
| | | // å®ä¹è¾å
¥åæ° |
| | | var parameters = new List<SugarParameter> |
| | | { |
| | | |
| | | new("P_ID", dto.id, DbType.String, |
| | | ParameterDirection.Input), |
| | | new("P_USER", dto.userNo, DbType.String, |
| | | ParameterDirection.Input), |
| | | outputResult, |
| | | outputMessage |
| | | }; |
| | | |
| | | var db = SqlSugarHelper.GetInstance(); |
| | | |
| | | // ä½¿ç¨ SqlSugar æ§è¡åå¨è¿ç¨ |
| | | db.Ado.ExecuteCommand( |
| | | "BEGIN PRC_FPI_OK_GEN_IPI(:P_ID, :P_USER, :C_RES, :C_MSG); END;", |
| | | parameters.ToArray()); |
| | | |
| | | // è·åè¾åºåæ°çå¼ |
| | | var resultValue = outputResult.Value?.ToString(); |
| | | var messageValue = outputMessage.Value?.ToString(); |
| | | |
| | | if ("1".Equals(resultValue)) throw new Exception(messageValue); |
| | | |
| | | return true; |
| | | } |
| | | catch (Exception ex) |
| | | { |
| | | throw new Exception(ex.Message); |
| | | } |
| | | } |
| | | } |
| | |
| | | |
| | | return db |
| | | .Queryable<QsQaItemXj, Womdaa, MesLine, |
| | | MesItems>((s, a, c, b) => |
| | | MesItems,Womcaa, ExZzCaaFiled>((s, a, c, b,ca,zf) => |
| | | new JoinQueryInfos( |
| | | JoinType.Inner, s.BillNo == a.Daa001, |
| | | JoinType.Left, a.Daa015 == c.LineNo, |
| | | JoinType.Left, s.ItemId == b.Id |
| | | JoinType.Left, s.ItemId == b.Id, |
| | | JoinType.Left, a.Daa021 == ca.Caa020, |
| | | JoinType.Left, ca.Erpid == zf.Erpid |
| | | ) |
| | | ) |
| | | .WhereIF(lineNo != null && lineNo.Length > 0, |
| | | (s, a, c, b) => lineNo.Contains(c.LineNo)) |
| | | (s, a, c, b, ca, zf) => lineNo.Contains(c.LineNo)) |
| | | .WhereIF( |
| | | StringUtil.IsNotNullOrEmpty(queryObj.result) && |
| | | "æªå®æ".Equals(queryObj.result), |
| | | (s, a, c, b) => s.FcheckResu == null) |
| | | (s, a, c, b, ca, zf) => s.FcheckResu == null) |
| | | .WhereIF( |
| | | StringUtil.IsNotNullOrEmpty(queryObj.result) && |
| | | !"æªå®æ".Equals(queryObj.result), |
| | | (s, a, c, b) => s.FcheckResu != null) |
| | | .WhereIF(id > 0, (s, a, c, b) => s.Id == id) |
| | | (s, a, c, b, ca, zf) => s.FcheckResu != null) |
| | | .WhereIF(id > 0, (s, a, c, b, ca, zf) => s.Id == id) |
| | | //å ç鿡件,æ ¹æ®ä¾åºåï¼ç©æç¼ç ï¼ç©æåç§°æç´¢ |
| | | //.WhereIF(queryObj.SearchValue!=null && queryObj.SearchValue!="", (a) => a.SuppName == queryObj.SearchValue|| a.ItemName == queryObj.SearchValue || a.ItemNo == queryObj.SearchValue ) |
| | | .WhereIF(queryObj.SearchValue != null && queryObj.SearchValue != "", |
| | | (s,a,c,b) => (b.ItemName.ToLower().Contains(queryObj.SearchValue.ToLower()) |
| | | (s, a, c, b, ca, zf) => (b.ItemName.ToLower().Contains(queryObj.SearchValue.ToLower()) |
| | | || b.ItemNo.ToLower().Contains(queryObj.SearchValue.ToLower()))) |
| | | .Select((s, a, c, b) => new QsQaItemXj |
| | | .Select((s, a, c, b, ca, zf) => new QsQaItemXj |
| | | { |
| | | Daa020 = c.LineNo, |
| | | Id = s.Id, |
| | |
| | | ItemModel = b.ItemModel, |
| | | FcheckBy = s.FcheckBy, |
| | | FcheckResu = s.FcheckResu, |
| | | Caa015 = ca.Caa015, |
| | | cust = a.Cust == null ? zf.Cust : a.Cust, |
| | | Remarks = s.Remarks |
| | | }).OrderBy(s => s.CreateDate, OrderByType.Desc) |
| | | .ToPageList(queryObj.PageIndex, queryObj.Limit); |
| | |
| | | Caa018 = Convert.ToDecimal(dto.planId), |
| | | Caa019 = Convert.ToDecimal(dto.planSeq), |
| | | Caa020 = dto.planNum, |
| | | FMOENTRYID = Convert.ToDecimal(dto.FMOENTRYID) |
| | | Fmoentryid = Convert.ToDecimal(dto.FMOENTRYID) |
| | | }; |
| | | |
| | | var single = base.GetSingle(it => it.Erpid == entity.Erpid); |
| | |
| | | public ResponseResult SetQSItems([FromBody] JObject data) |
| | | { |
| | | var itemNo = data["itemNo"].ToString(); |
| | | var lineNo = data["lineNo"].ToString(); |
| | | var lineNo = data["lineNo"]?.ToString(); |
| | | try |
| | | { |
| | | dynamic resultInfos = new ExpandoObject(); |
| | |
| | | return ResponseResult.ResponseError(ex); |
| | | } |
| | | } |
| | | |
| | | //QaSubmit |
| | | [HttpPost("qaSubmit")] |
| | | public ResponseResult qaSubmit([FromBody] LLJDto dto) |
| | | { |
| | | try |
| | | { |
| | | dynamic resultInfos = new ExpandoObject(); |
| | | var tbBillList = |
| | | new SJService().QaSubmit(dto); |
| | | resultInfos.tbBillList = tbBillList; |
| | | return new ResponseResult |
| | | { |
| | | status = 0, |
| | | message = "OK", |
| | | data = resultInfos |
| | | }; |
| | | } |
| | | catch (Exception ex) |
| | | { |
| | | return ResponseResult.ResponseError(ex); |
| | | } |
| | | } |
| | | } |
| | |
| | | <Project> |
| | | <PropertyGroup> |
| | | <_PublishTargetUrl>C:\Users\qewqer\Desktop\MES\SG\StandardPda\MESApplication\bin\Release\net8.0\publish\</_PublishTargetUrl> |
| | | <History>True|2025-03-20T09:58:14.2077893Z||;True|2025-03-15T00:59:39.9999573+08:00||;True|2025-03-07T15:42:21.8276566+08:00||;True|2025-02-27T10:43:45.2314689+08:00||;True|2025-02-21T16:39:35.2452658+08:00||;True|2025-01-13T15:35:48.6521519+08:00||;True|2025-01-08T16:15:03.8764923+08:00||;True|2024-12-30T15:00:59.8090011+08:00||;True|2024-12-06T16:11:01.2090466+08:00||;True|2024-11-26T09:07:33.5654976+08:00||;True|2024-11-20T15:49:27.1100474+08:00||;True|2024-11-16T18:18:42.4224922+08:00||;True|2024-11-15T09:32:12.6287354+08:00||;True|2024-11-13T10:19:32.3283327+08:00||;True|2024-09-06T14:40:56.3762241+08:00||;True|2024-08-20T17:12:00.2924570+08:00||;True|2024-08-17T10:57:05.6670396+08:00||;True|2024-08-17T10:56:46.8068041+08:00||;True|2024-08-16T14:09:17.0526491+08:00||;True|2024-08-15T08:40:32.8134665+08:00||;True|2024-08-14T10:00:27.7017207+08:00||;True|2024-08-14T08:54:44.8284031+08:00||;True|2024-08-07T10:32:10.3689256+08:00||;True|2024-08-05T15:45:03.0864530+08:00||;True|2024-08-03T09:59:13.7916520+08:00||;True|2024-07-31T17:27:28.1965929+08:00||;True|2024-07-31T15:27:34.7943845+08:00||;True|2024-07-30T15:04:50.5849235+08:00||;True|2024-07-30T14:09:06.2877325+08:00||;True|2024-07-29T16:11:30.4493940+08:00||;True|2024-07-23T14:30:34.4591002+08:00||;True|2024-07-22T14:17:39.8186158+08:00||;True|2024-04-10T12:55:31.3963752+08:00||;True|2024-04-08T13:59:25.5487203+08:00||;True|2024-04-06T09:30:09.5350539+08:00||;True|2024-04-06T08:46:05.8814658+08:00||;True|2024-04-05T14:06:52.0448024+08:00||;True|2024-04-05T12:47:46.0561601+08:00||;True|2024-02-26T08:46:22.0988887+08:00||;True|2024-02-24T19:17:13.6770376+08:00||;True|2024-02-24T14:32:37.4450337+08:00||;True|2024-02-23T10:22:06.5150173+08:00||;True|2024-02-22T13:19:56.6997993+08:00||;True|2024-02-22T10:53:17.7929585+08:00||;True|2024-02-21T17:08:06.5553444+08:00||;True|2024-02-19T16:24:37.4912012+08:00||;True|2024-02-02T10:07:23.2726075+08:00||;True|2024-02-02T08:36:49.2904460+08:00||;True|2024-01-29T17:44:43.6800769+08:00||;True|2024-01-23T09:47:26.7811926+08:00||;True|2024-01-18T16:23:30.3373836+08:00||;True|2024-01-17T14:22:04.2552286+08:00||;True|2024-01-16T16:54:42.2316892+08:00||;True|2024-01-16T16:37:23.8028858+08:00||;True|2024-01-16T09:25:24.4007775+08:00||;True|2024-01-15T10:18:57.3362616+08:00||;True|2024-01-15T10:07:14.2044763+08:00||;True|2024-01-10T14:03:36.4451130+08:00||;True|2024-01-09T16:45:32.9601815+08:00||;True|2024-01-06T14:16:34.2732220+08:00||;True|2024-01-06T14:11:45.2134717+08:00||;True|2024-01-06T11:30:58.9198887+08:00||;</History> |
| | | <History>True|2025-04-12T04:05:38.9937329Z||;True|2025-04-11T16:26:37.5266569+08:00||;True|2025-03-20T17:58:14.2077893+08:00||;True|2025-03-15T00:59:39.9999573+08:00||;True|2025-03-07T15:42:21.8276566+08:00||;True|2025-02-27T10:43:45.2314689+08:00||;True|2025-02-21T16:39:35.2452658+08:00||;True|2025-01-13T15:35:48.6521519+08:00||;True|2025-01-08T16:15:03.8764923+08:00||;True|2024-12-30T15:00:59.8090011+08:00||;True|2024-12-06T16:11:01.2090466+08:00||;True|2024-11-26T09:07:33.5654976+08:00||;True|2024-11-20T15:49:27.1100474+08:00||;True|2024-11-16T18:18:42.4224922+08:00||;True|2024-11-15T09:32:12.6287354+08:00||;True|2024-11-13T10:19:32.3283327+08:00||;True|2024-09-06T14:40:56.3762241+08:00||;True|2024-08-20T17:12:00.2924570+08:00||;True|2024-08-17T10:57:05.6670396+08:00||;True|2024-08-17T10:56:46.8068041+08:00||;True|2024-08-16T14:09:17.0526491+08:00||;True|2024-08-15T08:40:32.8134665+08:00||;True|2024-08-14T10:00:27.7017207+08:00||;True|2024-08-14T08:54:44.8284031+08:00||;True|2024-08-07T10:32:10.3689256+08:00||;True|2024-08-05T15:45:03.0864530+08:00||;True|2024-08-03T09:59:13.7916520+08:00||;True|2024-07-31T17:27:28.1965929+08:00||;True|2024-07-31T15:27:34.7943845+08:00||;True|2024-07-30T15:04:50.5849235+08:00||;True|2024-07-30T14:09:06.2877325+08:00||;True|2024-07-29T16:11:30.4493940+08:00||;True|2024-07-23T14:30:34.4591002+08:00||;True|2024-07-22T14:17:39.8186158+08:00||;True|2024-04-10T12:55:31.3963752+08:00||;True|2024-04-08T13:59:25.5487203+08:00||;True|2024-04-06T09:30:09.5350539+08:00||;True|2024-04-06T08:46:05.8814658+08:00||;True|2024-04-05T14:06:52.0448024+08:00||;True|2024-04-05T12:47:46.0561601+08:00||;True|2024-02-26T08:46:22.0988887+08:00||;True|2024-02-24T19:17:13.6770376+08:00||;True|2024-02-24T14:32:37.4450337+08:00||;True|2024-02-23T10:22:06.5150173+08:00||;True|2024-02-22T13:19:56.6997993+08:00||;True|2024-02-22T10:53:17.7929585+08:00||;True|2024-02-21T17:08:06.5553444+08:00||;True|2024-02-19T16:24:37.4912012+08:00||;True|2024-02-02T10:07:23.2726075+08:00||;True|2024-02-02T08:36:49.2904460+08:00||;True|2024-01-29T17:44:43.6800769+08:00||;True|2024-01-23T09:47:26.7811926+08:00||;True|2024-01-18T16:23:30.3373836+08:00||;True|2024-01-17T14:22:04.2552286+08:00||;True|2024-01-16T16:54:42.2316892+08:00||;True|2024-01-16T16:37:23.8028858+08:00||;True|2024-01-16T09:25:24.4007775+08:00||;True|2024-01-15T10:18:57.3362616+08:00||;True|2024-01-15T10:07:14.2044763+08:00||;True|2024-01-10T14:03:36.4451130+08:00||;True|2024-01-09T16:45:32.9601815+08:00||;True|2024-01-06T14:16:34.2732220+08:00||;True|2024-01-06T14:11:45.2134717+08:00||;True|2024-01-06T11:30:58.9198887+08:00||;</History> |
| | | <LastFailureDetails /> |
| | | </PropertyGroup> |
| | | </Project> |
¶Ô±ÈÐÂÎļþ |
| | |
| | | 2025-04-11 14:01:00:726 æ¥å£å¼å¸¸ï¼{"ClassName":"System.NullReferenceException","Message":"Object reference not set to an instance of an object.","Data":null,"InnerException":null,"HelpURL":null,"StackTraceString":" at MESApplication.Controllers.QC.SJController.SetQSItems(JObject data) in C:\\Users\\qewqer\\Desktop\\MES\\SG\\StandardPda\\MESApplication\\Controllers\\QC\\SJController.cs:line 66\r\n at lambda_method191(Closure, Object, Object[])\r\n at Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor.SyncObjectResultExecutor.Execute(ActionContext actionContext, IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments)\r\n at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeActionMethodAsync()\r\n at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)\r\n at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeNextActionFilterAsync()","RemoteStackTraceString":null,"RemoteStackIndex":0,"ExceptionMethod":null,"HResult":-2147467261,"Source":"MESApplication","WatsonBuckets":null} |
| | | 2025-04-11 14:01:00:732 å¼å¸¸æç¤ºä¿¡æ¯ï¼"Object reference not set to an instance of an object." |
| | | ================================================================================================================================== |
| | | 2025-04-11 14:02:16:421 æ¥å£å¼å¸¸ï¼{"ClassName":"System.NullReferenceException","Message":"Object reference not set to an instance of an object.","Data":null,"InnerException":null,"HelpURL":null,"StackTraceString":" at MESApplication.Controllers.QC.SJController.SetQSItems(JObject data) in C:\\Users\\qewqer\\Desktop\\MES\\SG\\StandardPda\\MESApplication\\Controllers\\QC\\SJController.cs:line 66\r\n at lambda_method191(Closure, Object, Object[])\r\n at Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor.SyncObjectResultExecutor.Execute(ActionContext actionContext, IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments)\r\n at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeActionMethodAsync()\r\n at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)\r\n at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeNextActionFilterAsync()","RemoteStackTraceString":null,"RemoteStackIndex":0,"ExceptionMethod":null,"HResult":-2147467261,"Source":"MESApplication","WatsonBuckets":null} |
| | | 2025-04-11 14:02:16:422 å¼å¸¸æç¤ºä¿¡æ¯ï¼"Object reference not set to an instance of an object." |
| | | ================================================================================================================================== |
| | | 2025-04-11 14:03:06:811 æ¥å£å¼å¸¸ï¼{"ClassName":"System.NullReferenceException","Message":"Object reference not set to an instance of an object.","Data":null,"InnerException":null,"HelpURL":null,"StackTraceString":" at MESApplication.Controllers.QC.SJController.SetQSItems(JObject data) in C:\\Users\\qewqer\\Desktop\\MES\\SG\\StandardPda\\MESApplication\\Controllers\\QC\\SJController.cs:line 66\r\n at lambda_method191(Closure, Object, Object[])\r\n at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeActionMethodAsync()\r\n at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)\r\n at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeNextActionFilterAsync()","RemoteStackTraceString":null,"RemoteStackIndex":0,"ExceptionMethod":null,"HResult":-2147467261,"Source":"MESApplication","WatsonBuckets":null} |
| | | 2025-04-11 14:03:06:811 å¼å¸¸æç¤ºä¿¡æ¯ï¼"Object reference not set to an instance of an object." |
| | | ================================================================================================================================== |