Merge remote-tracking branch 'origin/master'
¶Ô±ÈÐÂÎļþ |
| | |
| | | using MES.Service.Modes; |
| | | |
| | | namespace MES.Service.Dto.service; |
| | | |
| | | public class MesBomDto |
| | | { |
| | | public string? Type { get; set; } |
| | | public MesBomMaster? Main { get; set; } |
| | | public List<MesBomDetail1>? DT1 { get; set; } |
| | | public List<MesBomDetail2>? DT2 { get; set; } |
| | | |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | using MES.Service.Modes; |
| | | |
| | | namespace MES.Service.Dto.service; |
| | | |
| | | public class CgsqDto |
| | | { |
| | | public string? Type { get; set; } |
| | | public Cgsq? CgsqMain { get; set; } |
| | | |
| | | public List<CgsqDetail>? CgsqDT { get; set; } |
| | | |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | using System; |
| | | using System.Collections.Generic; |
| | | using System.Linq; |
| | | using SqlSugar; |
| | | namespace MES.Service.Modes |
| | | { |
| | | /// <summary> |
| | | /// |
| | | ///</summary> |
| | | [SugarTable("MES_BOM_DETAIL1")] |
| | | public class MesBomDetail1 |
| | | { |
| | | /// <summary> |
| | | /// SEQ_BOM |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "ID", OracleSequenceName = "SEQ_BOM", |
| | | IsPrimaryKey = true)] |
| | | public decimal Id { get; set; } |
| | | |
| | | /// <summary> |
| | | /// mid |
| | | ///</summary> |
| | | [SugarColumn(ColumnName = "MID")] |
| | | public decimal? Mid { get; set; } |
| | | |
| | | /// <summary> |
| | | /// erpid |
| | | ///</summary> |
| | | [SugarColumn(ColumnName = "ERPID")] |
| | | public decimal? Erpid { get; set; } |
| | | /// <summary> |
| | | /// erphid |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="ERPHID" )] |
| | | public decimal? Erphid { get; set; } |
| | | /// <summary> |
| | | /// 项次 |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="FREPLACEGROUP" )] |
| | | public string? Freplacegroup { get; set; } |
| | | /// <summary> |
| | | /// å卿èçï¼å¦ 0.05 表示 5%ï¼ |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="FSCRAPRATE" )] |
| | | public decimal? Fscraprate { get; set; } |
| | | /// <summary> |
| | | /// ä½ç½®å· |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="FPOSITIONNO" )] |
| | | public string? Fpositionno { get; set; } |
| | | /// <summary> |
| | | /// åé¡¹ç©æç¼ç |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="FMATERIALIDCHILD" )] |
| | | public string? Fmaterialidchild { get; set; } |
| | | /// <summary> |
| | | /// ç¨éåå |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="FNUMERATOR" )] |
| | | public decimal? Fnumerator { get; set; } |
| | | /// <summary> |
| | | /// ç¨é忝 |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="FDENOMINATOR" )] |
| | | public decimal? Fdenominator { get; set; } |
| | | /// <summary> |
| | | /// åé¡¹ç©æåç§° |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="FCHILDITEMNAME" )] |
| | | public string? Fchilditemname { get; set; } |
| | | /// <summary> |
| | | /// åé¡¹ç©æå±æ§ |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="FCHILDITEMPROPERTY" )] |
| | | public string? Fchilditemproperty { get; set; } |
| | | /// <summary> |
| | | /// ä¾åºç±»å |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="FSUPPLYTYPE" )] |
| | | public string? Fsupplytype { get; set; } |
| | | /// <summary> |
| | | /// å项类å |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="FMATERIALTYPE" )] |
| | | public string? Fmaterialtype { get; set; } |
| | | /// <summary> |
| | | /// æ åç¹æ° |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="F_UNW_BZDS_1" )] |
| | | public decimal? FUnwBzds1 { get; set; } |
| | | /// <summary> |
| | | /// å项åä½ |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="FCHILDUNITID" )] |
| | | public string? Fchildunitid { get; set; } |
| | | /// <summary> |
| | | /// ç¨éç±»å |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="FDOSAGETYPE" )] |
| | | public string? Fdosagetype { get; set; } |
| | | /// <summary> |
| | | /// å项 BOM çæ¬ |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="FBOMID" )] |
| | | public string? Fbomid { get; set; } |
| | | /// <summary> |
| | | /// 夿³¨ |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="FMEMO" )] |
| | | public string? Fmemo { get; set; } |
| | | /// <summary> |
| | | /// é»è®¤åæä»åº |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="FSTOCKID" )] |
| | | public string? Fstockid { get; set; } |
| | | /// <summary> |
| | | /// è·³å±ï¼Y/Nï¼ |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="FISSKIP" )] |
| | | public string? Fisskip { get; set; } |
| | | /// <summary> |
| | | /// åå¨å¤ä¸ªæ¿ä»£æ¹æ¡ï¼Y/Nï¼ |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="FISMULCSD" )] |
| | | public string? Fismulcsd { get; set; } |
| | | /// <summary> |
| | | /// çææ¥æ |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="FEFFECTDATE" )] |
| | | public DateTime? Feffectdate { get; set; } |
| | | /// <summary> |
| | | /// å¤±ææ¥æ |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="FEXPIREDATE" )] |
| | | public DateTime? Fexpiredate { get; set; } |
| | | /// <summary> |
| | | /// åææ¹å¼ |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="FISSUETYPE" )] |
| | | public string? Fissuetype { get; set; } |
| | | /// <summary> |
| | | /// åéæ±æ¯ä¾ |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="FNETDEMANDRATE" )] |
| | | public decimal Fnetdemandrate { get; set; } |
| | | /// <summary> |
| | | /// è´´çå·¥èºï¼åé¡¹ï¼ |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="F_UNW_TEXT_TPGY_Z" )] |
| | | public string? FUnwTextTpgyZ { get; set; } |
| | | /// <summary> |
| | | /// å岿¶æº |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="FBACKFLUSHTYPE" )] |
| | | public string? Fbackflushtype { get; set; } |
| | | /// <summary> |
| | | /// è¶
åæ§å¶æ¹å¼ |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="FOVERCONTROLMODE" )] |
| | | public string? Fovercontrolmode { get; set; } |
| | | /// <summary> |
| | | /// æå°åææ¹é |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="FBPMINISSUEQTY" )] |
| | | public decimal? Fbpminissueqty { get; set; } |
| | | /// <summary> |
| | | /// æ¯å¦èèæå°åæï¼Y/Nï¼ |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="FISMINISSUEQTY" )] |
| | | public string? Fisminissueqty { get; set; } |
| | | /// <summary> |
| | | /// æ¯å¦åæèï¼Y/Nï¼ |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="FISGETSCRAP" )] |
| | | public string? Fisgetscrap { get; set; } |
| | | /// <summary> |
| | | /// å·¥åºåºå |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="FOPTQUEUE" )] |
| | | public string? Foptqueue { get; set; } |
| | | /// <summary> |
| | | /// å·¥åºID |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="FOPERID" )] |
| | | public string? Foperid { get; set; } |
| | | /// <summary> |
| | | /// ä½ä¸ID |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="FPROCESSID" )] |
| | | public string? Fprocessid { get; set; } |
| | | /// <summary> |
| | | /// è®¡ä»·ç¹æ° |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="F_UNW_JJDS_1" )] |
| | | public decimal? FUnwJjds1 { get; set; } |
| | | } |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | using System; |
| | | using System.Collections.Generic; |
| | | using System.Linq; |
| | | using SqlSugar; |
| | | namespace MES.Service.Modes |
| | | { |
| | | /// <summary> |
| | | /// |
| | | ///</summary> |
| | | [SugarTable("MES_BOM_DETAIL2")] |
| | | public class MesBomDetail2 |
| | | { |
| | | /// <summary> |
| | | /// SEQ_BOM |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "ID", OracleSequenceName = "SEQ_BOM", |
| | | IsPrimaryKey = true)] |
| | | public decimal Id { get; set; } |
| | | /// <summary> |
| | | /// mid |
| | | ///</summary> |
| | | [SugarColumn(ColumnName = "MID")] |
| | | public decimal? Mid { get; set; } |
| | | /// <summary> |
| | | /// erpid |
| | | ///</summary> |
| | | [SugarColumn(ColumnName = "ERPID")] |
| | | public decimal? Erpid { get; set; } |
| | | /// <summary> |
| | | /// epihid |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="ERPHID" )] |
| | | public decimal? Erphid { get; set; } |
| | | /// <summary> |
| | | /// é¶æ¢¯ç¨é-å¯å§æ°é |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="FSTARTQTY" )] |
| | | public decimal? Fstartqty { get; set; } |
| | | /// <summary> |
| | | /// é¶æ¢¯ç¨é-æªæ¢æ°é |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="FENDQTY" )] |
| | | public decimal? Fendqty { get; set; } |
| | | /// <summary> |
| | | /// å项åä½ |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="FUNITIDLOT" )] |
| | | public string? Funitidlot { get; set; } |
| | | /// <summary> |
| | | /// åºå®æè |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="FFIXSCRAPQTYLOT" )] |
| | | public decimal? Ffixscrapqtylot { get; set; } |
| | | /// <summary> |
| | | /// å卿èç |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="FSCRAPRATELOT" )] |
| | | public decimal? Fscrapratelot { get; set; } |
| | | /// <summary> |
| | | /// ç¨éï¼åå |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="FNUMERATORLOT" )] |
| | | public long? Fnumeratorlot { get; set; } |
| | | /// <summary> |
| | | /// ç¨éï¼åæ¯ |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="FDENOMINATORLOT" )] |
| | | public long? Fdenominatorlot { get; set; } |
| | | /// <summary> |
| | | /// åé¡¹ç©æç¼ç |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="FMATERIALIDLOTBASED" )] |
| | | public string? Fmaterialidlotbased { get; set; } |
| | | /// <summary> |
| | | /// åºå· |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="LINE_NUMBER" )] |
| | | public decimal? LineNumber { get; set; } |
| | | } |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | using System; |
| | | using System.Collections.Generic; |
| | | using System.Linq; |
| | | using SqlSugar; |
| | | namespace MES.Service.Modes |
| | | { |
| | | /// <summary> |
| | | /// |
| | | ///</summary> |
| | | [SugarTable("MES_BOM_MASTER")] |
| | | public class MesBomMaster |
| | | { |
| | | /// <summary> |
| | | /// SEQ_BOM |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "ID", OracleSequenceName = "SEQ_BOM", |
| | | IsPrimaryKey = true)] |
| | | public decimal Id { get; set; } |
| | | |
| | | /// <summary> |
| | | /// |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="ERPID")] |
| | | public decimal? Erpid { get; set; } |
| | | /// <summary> |
| | | /// åæ®ç±»å |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="FBILLTYPE" )] |
| | | public string? Fbilltype { get; set; } |
| | | /// <summary> |
| | | /// BOMåç±» |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="FBOMCATEGORY" )] |
| | | public string? Fbomcategory { get; set; } |
| | | /// <summary> |
| | | /// BOMç¨é |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="FBOMUSE" )] |
| | | public string? Fbomuse { get; set; } |
| | | /// <summary> |
| | | /// BOMåç» |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="FGROUP" )] |
| | | public string? Fgroup { get; set; } |
| | | /// <summary> |
| | | /// BOMç¼ç |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="FNUMBER" )] |
| | | public string? Fnumber { get; set; } |
| | | /// <summary> |
| | | /// BOMçæ¬å· |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="F_UNW_BOM_BB" )] |
| | | public string? FUnwBomBb { get; set; } |
| | | /// <summary> |
| | | /// çææ¥æ |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="EFFECTIVE_DATE" )] |
| | | public DateTime? EffectiveDate { get; set; } |
| | | /// <summary> |
| | | /// å¤±ææ¥æ |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="EXPIRATION_DATE" )] |
| | | public DateTime? ExpirationDate { get; set; } |
| | | /// <summary> |
| | | /// ç¶é¡¹ç©æç¼ç |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="FMATERIALID" )] |
| | | public string? Fmaterialid { get; set; } |
| | | /// <summary> |
| | | /// ç¶é¡¹ç©æåç§° |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="FITEMNAME" )] |
| | | public string? Fitemname { get; set; } |
| | | /// <summary> |
| | | /// 计éåä½ |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="FBASEUNITID" )] |
| | | public string? Fbaseunitid { get; set; } |
| | | /// <summary> |
| | | /// å建人 |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="FCREATORID" )] |
| | | public string? Fcreatorid { get; set; } |
| | | /// <summary> |
| | | /// å建æ¶é´ |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="FCREATEDATE" )] |
| | | public DateTime? Fcreatedate { get; set; } |
| | | /// <summary> |
| | | /// ç©æå±æ§ |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="FITEMPPROPERTY" )] |
| | | public string? Fitempproperty { get; set; } |
| | | /// <summary> |
| | | /// æè¿° |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="FDESCRIPTION" )] |
| | | public string? Fdescription { get; set; } |
| | | /// <summary> |
| | | /// ä¿®æ¹äºº |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="FMODIFIERID" )] |
| | | public string? Fmodifierid { get; set; } |
| | | /// <summary> |
| | | /// ä¿®æ¹æ¶é´ |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="FMODIFYDATE" )] |
| | | public DateTime? Fmodifydate { get; set; } |
| | | /// <summary> |
| | | /// å®¡æ ¸äºº |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="FAPPROVERID" )] |
| | | public string? Fapproverid { get; set; } |
| | | /// <summary> |
| | | /// å®¡æ ¸æ¶é´ |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="FAPPROVEDATE" )] |
| | | public DateTime? Fapprovedate { get; set; } |
| | | /// <summary> |
| | | /// ç¦ç¨åå |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="FFORBIDRESON" )] |
| | | public string? Fforbidreson { get; set; } |
| | | /// <summary> |
| | | /// ç¦ç¨ç¶æ |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="FFORBIDSTATUS" )] |
| | | public string? Fforbidstatus { get; set; } |
| | | /// <summary> |
| | | /// ç¦ç¨äºº |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="FFORBIDDERID" )] |
| | | public string? Fforbidderid { get; set; } |
| | | /// <summary> |
| | | /// ç¦ç¨æ¥æ |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="FFORBIDDATE" )] |
| | | public DateTime? Fforbiddate { get; set; } |
| | | /// <summary> |
| | | /// å建ç»ç» |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="CREATE_ORGANIZATION" )] |
| | | public string? CreateOrganization { get; set; } |
| | | /// <summary> |
| | | /// 使ç¨ç»ç» |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="USING_ORGANIZATION" )] |
| | | public string? UsingOrganization { get; set; } |
| | | /// <summary> |
| | | /// å·¥èºè·¯çº¿ |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="ROUTING" )] |
| | | public string? Routing { get; set; } |
| | | /// <summary> |
| | | /// è´´çå·¥èº |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="F_UNW_TEXT_TPGY" )] |
| | | public string? FUnwTextTpgy { get; set; } |
| | | /// <summary> |
| | | /// BOMæ´æ°ç±»å |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="BOM_UPDATE_TYPE" )] |
| | | public string? BomUpdateType { get; set; } |
| | | } |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | using System; |
| | | using System.Collections.Generic; |
| | | using System.Linq; |
| | | using SqlSugar; |
| | | namespace MES.Service.Modes |
| | | { |
| | | /// <summary> |
| | | /// |
| | | ///</summary> |
| | | [SugarTable("MES_CGSQ")] |
| | | public class Cgsq |
| | | { |
| | | /// <summary> |
| | | /// |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="ERPID", IsPrimaryKey = true)] |
| | | public decimal? ERPID { get; set; } |
| | | /// <summary> |
| | | /// åæ®ç±»å |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="FBILLTYPEID" )] |
| | | public string? Fbilltypeid { get; set; } |
| | | /// <summary> |
| | | /// åæ®ç¼å· |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="FBILLNO" )] |
| | | public string? Fbillno { get; set; } |
| | | /// <summary> |
| | | /// ç³è¯·æ¥æ |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="FAPPLICATIONDATE" )] |
| | | public DateTime? Fapplicationdate { get; set; } |
| | | /// <summary> |
| | | /// ç³è¯·ç±»å |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="FREQUESTTYPE" )] |
| | | public string? Frequesttype { get; set; } |
| | | /// <summary> |
| | | /// æ²»å
·æ¨¡å
·å å·¥åéè´ |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="F_UNW_COMBO_ZJMJ" )] |
| | | public string? FUnwComboZjmj { get; set; } |
| | | /// <summary> |
| | | /// ç³è¯·ç»ç» |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="APPLYING_ORGANIZATION_ID" )] |
| | | public string? ApplyingOrganizationId { get; set; } |
| | | /// <summary> |
| | | /// ç³è¯·é¨é¨ |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="FAPPLICATIONDEPTID" )] |
| | | public string? Fapplicationdeptid { get; set; } |
| | | /// <summary> |
| | | /// ç³è¯·äºº |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="FAPPLICANTID" )] |
| | | public string? Fapplicantid { get; set; } |
| | | /// <summary> |
| | | /// å¸å« |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="FCURRENCYID" )] |
| | | public string? Fcurrencyid { get; set; } |
| | | /// <summary> |
| | | /// éªæ¶æ¹å¼ |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="FACCTYPE" )] |
| | | public string? Facctype { get; set; } |
| | | /// <summary> |
| | | /// åæ®ç¶æ |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="FDOCUMENTSTATUS" )] |
| | | public string? Fdocumentstatus { get; set; } |
| | | /// <summary> |
| | | /// 夿³¨ |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="FNOTE" )] |
| | | public string? Fnote { get; set; } |
| | | /// <summary> |
| | | /// å建人 |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="FCREATORID" )] |
| | | public string? Fcreatorid { get; set; } |
| | | /// <summary> |
| | | /// åå»ºæ¥æ |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="FCREATEDATE" )] |
| | | public DateTime? Fcreatedate { get; set; } |
| | | /// <summary> |
| | | /// å®¡æ ¸äºº |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="FAPPROVERID" )] |
| | | public string? Fapproverid { get; set; } |
| | | /// <summary> |
| | | /// å®¡æ ¸æ¥æ |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="FAPPROVEDATE" )] |
| | | public DateTime? Fapprovedate { get; set; } |
| | | /// <summary> |
| | | /// å
³éç¶æ |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="FCLOSESTATUS" )] |
| | | public string? Fclosestatus { get; set; } |
| | | /// <summary> |
| | | /// å
³éæ¥æ |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="FCLOSEDATE" )] |
| | | public DateTime? Fclosedate { get; set; } |
| | | /// <summary> |
| | | /// å
³é人 |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="FCLOSERID" )] |
| | | public string? Fcloserid { get; set; } |
| | | /// <summary> |
| | | /// å
³éåå |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="FCLOSEREASON" )] |
| | | public string? Fclosereason { get; set; } |
| | | /// <summary> |
| | | /// ä¿®åä¿®æ¹äºº |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="FMODIFIERID" )] |
| | | public string? Fmodifierid { get; set; } |
| | | /// <summary> |
| | | /// ä¿®åä¿®æ¹æ¥æ |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="FMODIFYDATE" )] |
| | | public DateTime? Fmodifydate { get; set; } |
| | | /// <summary> |
| | | /// æå·¥å
³é |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="FMANUALCLOSE" )] |
| | | public string? Fmanualclose { get; set; } |
| | | } |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | using System; |
| | | using System.Collections.Generic; |
| | | using System.Linq; |
| | | using SqlSugar; |
| | | namespace MES.Service.Modes |
| | | { |
| | | /// <summary> |
| | | /// |
| | | ///</summary> |
| | | [SugarTable("MES_CGSQ_DETAIL")] |
| | | public class CgsqDetail |
| | | { |
| | | /// <summary> |
| | | /// |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="ERPID", IsPrimaryKey = true )] |
| | | public decimal? ERPID { get; set; } |
| | | /// <summary> |
| | | /// |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="ERPHID")] |
| | | public decimal? ERPHID { get; set; } |
| | | /// <summary> |
| | | /// åºå· |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="LINE_NUMBER" )] |
| | | public decimal? LineNumber { get; set; } |
| | | /// <summary> |
| | | /// éå®è®¢åå· |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="F_UNW_TEXT_XSDDH" )] |
| | | public string? FUnwTextXsddh { get; set; } |
| | | /// <summary> |
| | | /// éæ±ç»ç» |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="OWNER_ORGANIZATION_ID" )] |
| | | public string? OwnerOrganizationId { get; set; } |
| | | /// <summary> |
| | | /// ç©æç¼ç |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="FMATERIALID" )] |
| | | public string? Fmaterialid { get; set; } |
| | | /// <summary> |
| | | /// è§æ ¼åå· |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="FMATERIALMODEL" )] |
| | | public string? Fmaterialmodel { get; set; } |
| | | /// <summary> |
| | | /// ç©æåç§° |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="FMATERIALNAME" )] |
| | | public string? Fmaterialname { get; set; } |
| | | /// <summary> |
| | | /// ç³è¯·åä½ |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="FUNITID" )] |
| | | public string? Funitid { get; set; } |
| | | /// <summary> |
| | | /// ç³è¯·æ°é |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="FREQQTY" )] |
| | | public decimal? Freqqty { get; set; } |
| | | /// <summary> |
| | | /// æ¹åæ°é |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="FAPPROVEQTY" )] |
| | | public decimal? Fapproveqty { get; set; } |
| | | /// <summary> |
| | | /// å°è´§æ¥æ |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="FARRIVALDATE" )] |
| | | public DateTime? Farrivaldate { get; set; } |
| | | /// <summary> |
| | | /// 建议éè´æ¥æ |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="FSUGGESTPURDATE" )] |
| | | public DateTime? Fsuggestpurdate { get; set; } |
| | | /// <summary> |
| | | /// éè´ç»ç» |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="BUYER_ORGANIZATION_ID" )] |
| | | public string? BuyerOrganizationId { get; set; } |
| | | /// <summary> |
| | | /// 建议ä¾åºå |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="FSUGGESTSUPPLIERID" )] |
| | | public string? Fsuggestsupplierid { get; set; } |
| | | /// <summary> |
| | | /// æ¶æç»ç» |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="WAREHOUSE_ID" )] |
| | | public string? WarehouseId { get; set; } |
| | | /// <summary> |
| | | /// åºååä½ |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="FREQSTOCKUNITID" )] |
| | | public string? Freqstockunitid { get; set; } |
| | | /// <summary> |
| | | /// åºåå使°é |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="FREQSTOCKQTY" )] |
| | | public decimal? Freqstockqty { get; set; } |
| | | /// <summary> |
| | | /// 计价åä½ |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="FPRICEUNITID" )] |
| | | public string? Fpriceunitid { get; set; } |
| | | /// <summary> |
| | | /// 计价æ°é |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="FPRICEUNITQTY" )] |
| | | public decimal? Fpriceunitqty { get; set; } |
| | | /// <summary> |
| | | /// æåæ |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="FLEADTIME" )] |
| | | public decimal? Fleadtime { get; set; } |
| | | /// <summary> |
| | | /// 计åè·è¸ªå· |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="FMTONO" )] |
| | | public string? Fmtono { get; set; } |
| | | /// <summary> |
| | | /// éæ±è·è¸ªå· |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="FREQTRACENO" )] |
| | | public string? Freqtraceno { get; set; } |
| | | /// <summary> |
| | | /// 鿱忮ç¼å· |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="FDEMANDBILLNO" )] |
| | | public string? Fdemandbillno { get; set; } |
| | | /// <summary> |
| | | /// 鿱忮è¡å· |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="FDEMANDBILLENTRYSEQ" )] |
| | | public decimal? Fdemandbillentryseq { get; set; } |
| | | /// <summary> |
| | | /// ä¸å¡ç»æ¢ |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="FMRPTERMINATESTATUS" )] |
| | | public string? Fmrpterminatestatus { get; set; } |
| | | /// <summary> |
| | | /// ç»æ¢äºº |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="FTERMINATERID" )] |
| | | public string? Fterminaterid { get; set; } |
| | | /// <summary> |
| | | /// ç»æ¢æ¥æ |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="FTERMINATEDATE" )] |
| | | public DateTime? Fterminatedate { get; set; } |
| | | } |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | using SqlSugar; |
| | | using System; |
| | | using System.Collections.Generic; |
| | | using MES.Service.DB; |
| | | using MES.Service.Modes; |
| | | |
| | | namespace MES.Service.service |
| | | { |
| | | public class MesBomDetail1Manager : Repository<MesBomDetail1> |
| | | { |
| | | |
| | | //å½å类已ç»ç»§æ¿äº Repository å¢ãå ãæ¥ãæ¹çæ¹æ³ |
| | | |
| | | //è¿éé¢åç代ç ä¸ä¼ç»è¦ç,妿è¦éæ°çæè¯·å é¤ MesBomDetail1Manager.cs |
| | | |
| | | |
| | | #region æå¦æ¹æ³ |
| | | /// <summary> |
| | | /// ä»å¨æ¹æ³æ»¡è¶³ä¸äºå¤æä¸å¡éæ±ï¼ä¸å¡ä»£ç 请å¨è¿éé¢å®ä¹æ¹æ³ |
| | | /// </summary> |
| | | public void Study() |
| | | { |
| | | |
| | | /*********æ¥è¯¢*********/ |
| | | |
| | | var data1 = base.GetById(1);//æ ¹æ®IDæ¥è¯¢ |
| | | var data2 = base.GetList();//æ¥è¯¢ææ |
| | | var data3 = base.GetList(it => 1 == 1); //æ ¹æ®æ¡ä»¶æ¥è¯¢ |
| | | //var data4 = base.GetSingle(it => 1 == 1);//æ ¹æ®æ¡ä»¶æ¥è¯¢ä¸æ¡,妿è¶
è¿ä¸æ¡ä¼æ¥é |
| | | |
| | | var p = new PageModel() { PageIndex = 1, PageSize = 2 };// å页æ¥è¯¢ |
| | | var data5 = base.GetPageList(it => 1 == 1, p); |
| | | Console.Write(p.TotalCount);//è¿åæ»æ° |
| | | |
| | | var data6 = base.GetPageList(it => 1 == 1, p, it => SqlFunc.GetRandom(), OrderByType.Asc);// å页æ¥è¯¢å æåº |
| | | Console.Write(p.TotalCount);//è¿åæ»æ° |
| | | |
| | | List<IConditionalModel> conModels = new List<IConditionalModel>(); //ç»è£
æ¡ä»¶æ¥è¯¢ä½ä¸ºæ¡ä»¶å®ç° å页æ¥è¯¢å æåº |
| | | conModels.Add(new ConditionalModel() { FieldName= typeof(MesBomDetail1).GetProperties()[0].Name, ConditionalType = ConditionalType.Equal, FieldValue = "1" });//id=1 |
| | | var data7 = base.GetPageList(conModels, p, it => SqlFunc.GetRandom(), OrderByType.Asc); |
| | | |
| | | base.AsQueryable().Where(x => 1 == 1).ToList();//æ¯æäºè½¬æ¢æqueryable,æä»¬å¯ä»¥ç¨queryableå®ç°å¤æåè½ |
| | | |
| | | |
| | | |
| | | /*********æå
¥*********/ |
| | | var insertData = new MesBomDetail1() { };//æµè¯åæ° |
| | | var insertArray = new MesBomDetail1[] { insertData }; |
| | | base.Insert(insertData);//æå
¥ |
| | | base.InsertRange(insertArray);//æ¹éæå
¥ |
| | | var id = base.InsertReturnIdentity(insertData);//æå
¥è¿åèªå¢å |
| | | base.AsInsertable(insertData).ExecuteCommand();//æä»¬å¯ä»¥è½¬æ Insertableå®ç°å¤ææå
¥ |
| | | |
| | | |
| | | |
| | | /*********æ´æ°*********/ |
| | | var updateData = new MesBomDetail1() { };//æµè¯åæ° |
| | | var updateArray = new MesBomDetail1[] { updateData };//æµè¯åæ° |
| | | base.Update(updateData);//æ ¹æ®å®ä½æ´æ° |
| | | base.UpdateRange(updateArray);//æ¹éæ´æ° |
| | | //base.Update(it => new MesBomDetail1() { ClassName = "a", CreateTime = DateTime.Now }, it => it.id==1);// åªæ´æ°ClassNameååCreateTimeåï¼å
¶å®å䏿´æ°ï¼æ¡ä»¶id=1 |
| | | base.AsUpdateable(updateData).ExecuteCommand(); //转æUpdateableå¯ä»¥å®ç°å¤æçæå
¥ |
| | | |
| | | |
| | | |
| | | /*********å é¤*********/ |
| | | var deldata = new MesBomDetail1() { };//æµè¯åæ° |
| | | base.Delete(deldata);//æ ¹æ®å®ä½å é¤ |
| | | base.DeleteById(1);//æ ¹æ®ä¸»é®å é¤ |
| | | base.DeleteById(new int[] { 1,2});//æ ¹æ®ä¸»é®æ°ç»å é¤ |
| | | base.Delete(it=>1==2);//æ ¹æ®æ¡ä»¶å é¤ |
| | | base.AsDeleteable().Where(it=>1==2).ExecuteCommand();//转æDeleteableå®ç°å¤æçæä½ |
| | | } |
| | | #endregion |
| | | |
| | | |
| | | } |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | using SqlSugar; |
| | | using System; |
| | | using System.Collections.Generic; |
| | | using MES.Service.DB; |
| | | using MES.Service.Modes; |
| | | |
| | | namespace MES.Service.service |
| | | { |
| | | public class MesBomDetail2Manager : Repository<MesBomDetail2> |
| | | { |
| | | |
| | | //å½å类已ç»ç»§æ¿äº Repository å¢ãå ãæ¥ãæ¹çæ¹æ³ |
| | | |
| | | //è¿éé¢åç代ç ä¸ä¼ç»è¦ç,妿è¦éæ°çæè¯·å é¤ MesBomDetail2Manager.cs |
| | | |
| | | |
| | | #region æå¦æ¹æ³ |
| | | /// <summary> |
| | | /// ä»å¨æ¹æ³æ»¡è¶³ä¸äºå¤æä¸å¡éæ±ï¼ä¸å¡ä»£ç 请å¨è¿éé¢å®ä¹æ¹æ³ |
| | | /// </summary> |
| | | public void Study() |
| | | { |
| | | |
| | | /*********æ¥è¯¢*********/ |
| | | |
| | | var data1 = base.GetById(1);//æ ¹æ®IDæ¥è¯¢ |
| | | var data2 = base.GetList();//æ¥è¯¢ææ |
| | | var data3 = base.GetList(it => 1 == 1); //æ ¹æ®æ¡ä»¶æ¥è¯¢ |
| | | //var data4 = base.GetSingle(it => 1 == 1);//æ ¹æ®æ¡ä»¶æ¥è¯¢ä¸æ¡,妿è¶
è¿ä¸æ¡ä¼æ¥é |
| | | |
| | | var p = new PageModel() { PageIndex = 1, PageSize = 2 };// å页æ¥è¯¢ |
| | | var data5 = base.GetPageList(it => 1 == 1, p); |
| | | Console.Write(p.TotalCount);//è¿åæ»æ° |
| | | |
| | | var data6 = base.GetPageList(it => 1 == 1, p, it => SqlFunc.GetRandom(), OrderByType.Asc);// å页æ¥è¯¢å æåº |
| | | Console.Write(p.TotalCount);//è¿åæ»æ° |
| | | |
| | | List<IConditionalModel> conModels = new List<IConditionalModel>(); //ç»è£
æ¡ä»¶æ¥è¯¢ä½ä¸ºæ¡ä»¶å®ç° å页æ¥è¯¢å æåº |
| | | conModels.Add(new ConditionalModel() { FieldName= typeof(MesBomDetail2).GetProperties()[0].Name, ConditionalType = ConditionalType.Equal, FieldValue = "1" });//id=1 |
| | | var data7 = base.GetPageList(conModels, p, it => SqlFunc.GetRandom(), OrderByType.Asc); |
| | | |
| | | base.AsQueryable().Where(x => 1 == 1).ToList();//æ¯æäºè½¬æ¢æqueryable,æä»¬å¯ä»¥ç¨queryableå®ç°å¤æåè½ |
| | | |
| | | |
| | | |
| | | /*********æå
¥*********/ |
| | | var insertData = new MesBomDetail2() { };//æµè¯åæ° |
| | | var insertArray = new MesBomDetail2[] { insertData }; |
| | | base.Insert(insertData);//æå
¥ |
| | | base.InsertRange(insertArray);//æ¹éæå
¥ |
| | | var id = base.InsertReturnIdentity(insertData);//æå
¥è¿åèªå¢å |
| | | base.AsInsertable(insertData).ExecuteCommand();//æä»¬å¯ä»¥è½¬æ Insertableå®ç°å¤ææå
¥ |
| | | |
| | | |
| | | |
| | | /*********æ´æ°*********/ |
| | | var updateData = new MesBomDetail2() { };//æµè¯åæ° |
| | | var updateArray = new MesBomDetail2[] { updateData };//æµè¯åæ° |
| | | base.Update(updateData);//æ ¹æ®å®ä½æ´æ° |
| | | base.UpdateRange(updateArray);//æ¹éæ´æ° |
| | | //base.Update(it => new MesBomDetail2() { ClassName = "a", CreateTime = DateTime.Now }, it => it.id==1);// åªæ´æ°ClassNameååCreateTimeåï¼å
¶å®å䏿´æ°ï¼æ¡ä»¶id=1 |
| | | base.AsUpdateable(updateData).ExecuteCommand(); //转æUpdateableå¯ä»¥å®ç°å¤æçæå
¥ |
| | | |
| | | |
| | | |
| | | /*********å é¤*********/ |
| | | var deldata = new MesBomDetail2() { };//æµè¯åæ° |
| | | base.Delete(deldata);//æ ¹æ®å®ä½å é¤ |
| | | base.DeleteById(1);//æ ¹æ®ä¸»é®å é¤ |
| | | base.DeleteById(new int[] { 1,2});//æ ¹æ®ä¸»é®æ°ç»å é¤ |
| | | base.Delete(it=>1==2);//æ ¹æ®æ¡ä»¶å é¤ |
| | | base.AsDeleteable().Where(it=>1==2).ExecuteCommand();//转æDeleteableå®ç°å¤æçæä½ |
| | | } |
| | | #endregion |
| | | |
| | | |
| | | } |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | using SqlSugar; |
| | | using System; |
| | | using System.Collections.Generic; |
| | | using MES.Service.DB; |
| | | using MES.Service.Modes; |
| | | using MES.Service.Dto.service; |
| | | using System.Globalization; |
| | | |
| | | namespace MES.Service.service |
| | | { |
| | | public class MesBomMasterManager : Repository<MesBomMaster> |
| | | { |
| | | private readonly MesBomDetail1Manager MesBomDetail1Manager = new(); |
| | | private readonly MesBomDetail2Manager MesBomDetail2Manager = new(); |
| | | |
| | | public bool Save(MesBomDto MesBom) |
| | | { |
| | | // var MesBomDto = MesBom.Main; |
| | | var mesMesBom = ConvertErpToMesBom(MesBom); |
| | | var mesMesBomDatas1 = ConvertErpToMesBomDetail1(MesBom); |
| | | var mesMesBomDatas2 = ConvertErpToMesBomDetail2(MesBom); |
| | | |
| | | return UseTransaction(db => |
| | | { |
| | | switch (MesBom.Type) |
| | | { |
| | | // case "2": |
| | | // return InsertData(db, mesSalesReturn, mesSalesReturnDatas, |
| | | // rohInErpRohIn.FBILLTYPE) |
| | | // ? 1 |
| | | // : 0; |
| | | case "3": |
| | | return UpdateData(db, mesMesBom, mesMesBomDatas1, mesMesBomDatas2) ? 1 : 0; |
| | | case "2": |
| | | case "4": |
| | | return SaveOrUpdateData(db, mesMesBom, mesMesBomDatas1, mesMesBomDatas2, MesBom.Type) |
| | | ? 1 |
| | | : 0; |
| | | default: |
| | | throw new NotImplementedException( |
| | | $"type没æ{MesBom.Type}è¿ä¸ªç±»å"); |
| | | } |
| | | }) > 0; |
| | | } |
| | | |
| | | private bool UpdateData(SqlSugarScope db, MesBomMaster mesMesBom, |
| | | List<MesBomDetail1> mesMesBomDatas1, List<MesBomDetail2> mesMesBomDatas2) |
| | | { |
| | | |
| | | //å é¤ç¸åERPIDç¸åBOMæ´æ°ç±»åçåæ® |
| | | var query = db.Queryable<MesBomMaster>() |
| | | .Where(s => s.Erpid == mesMesBom.Erpid); |
| | | |
| | | if (mesMesBom.BomUpdateType != "1") |
| | | { |
| | | if (string.IsNullOrEmpty(mesMesBom.BomUpdateType)) |
| | | { |
| | | query = query.Where(s => string.IsNullOrEmpty(s.BomUpdateType)); |
| | | } |
| | | else |
| | | { |
| | | query = query.Where(s => s.BomUpdateType == mesMesBom.BomUpdateType); |
| | | } |
| | | |
| | | decimal? ID = query.Select(s => s.Id).First(); |
| | | |
| | | var update = base.DeleteById(ID); |
| | | |
| | | var insertOrUpdate1 = db.Deleteable<MesBomDetail1>() |
| | | .Where(s => s.Mid == ID) |
| | | .ExecuteCommand() > 0; |
| | | |
| | | var insertOrUpdate2 = true; |
| | | |
| | | if (mesMesBomDatas2.Count > 0) |
| | | { |
| | | insertOrUpdate2 = db.Deleteable<MesBomDetail2>() |
| | | .Where(s => s.Mid == ID) |
| | | .ExecuteCommand() > 0; ; |
| | | // deleted 为 true 表示æè®°å½è¢«å é¤ |
| | | } |
| | | |
| | | if (update && insertOrUpdate1 && insertOrUpdate2) return true; |
| | | throw new NotImplementedException("æ´æ°å¤±è´¥"); |
| | | } |
| | | return true; |
| | | } |
| | | |
| | | // æå
¥ææ´æ°æ°æ®çæ¹æ³ |
| | | private bool SaveOrUpdateData(SqlSugarScope db, MesBomMaster mesMesBom, |
| | | List<MesBomDetail1> mesMesBomDatas1, List<MesBomDetail2> mesMesBomDatas2, string type) |
| | | { |
| | | //ç¸åERPIDä¸åBOMæ´æ°ç±»åçåæ®ä¿ç |
| | | var query = db.Queryable<MesBomMaster>() |
| | | .Where(s => s.Erpid == mesMesBom.Erpid); |
| | | |
| | | if (string.IsNullOrEmpty(mesMesBom.BomUpdateType)) |
| | | { |
| | | query = query.Where(s => string.IsNullOrEmpty(s.BomUpdateType)); |
| | | } |
| | | else |
| | | { |
| | | query = query.Where(s => s.BomUpdateType == mesMesBom.BomUpdateType); |
| | | } |
| | | |
| | | decimal? ID = query.Select(s => s.Id).First(); |
| | | |
| | | if (ID != null) |
| | | { |
| | | if (mesMesBom.Erpid != null) |
| | | db.Deleteable<MesBomMaster>() |
| | | .Where(s => s.Id == ID) |
| | | .ExecuteCommand(); |
| | | |
| | | if (mesMesBomDatas1.Count > 0) |
| | | db.Deleteable<MesBomDetail1>() |
| | | .Where(s => s.Mid == ID).ExecuteCommand(); |
| | | |
| | | if (mesMesBomDatas2.Count > 0) |
| | | db.Deleteable<MesBomDetail2>() |
| | | .Where(s => s.Mid == ID).ExecuteCommand(); |
| | | } |
| | | |
| | | |
| | | //var orUpdate = base.Insert(mesMesBom); |
| | | //var baOrUpdate = MesBomDetail1Manager.InsertRange(mesMesBomDatas1); |
| | | //if (orUpdate && baOrUpdate) return true; |
| | | var update_res = UseTransaction(db => |
| | | { |
| | | //è·å主表æå
¥åçä¸»é® |
| | | var insertedId = db.Insertable(mesMesBom).ExecuteReturnIdentity(); |
| | | |
| | | for (int i = 0; i < mesMesBomDatas1.Count; i++) |
| | | { |
| | | var item = mesMesBomDatas1[i]; |
| | | item.Mid = insertedId; |
| | | db.Insertable(item).IgnoreColumns(true).ExecuteCommand(); |
| | | } |
| | | |
| | | |
| | | for (int i = 0; i < mesMesBomDatas2.Count; i++) |
| | | { |
| | | var item = mesMesBomDatas2[i]; |
| | | item.Mid = insertedId; |
| | | db.Insertable(item).IgnoreColumns(true).ExecuteCommand(); |
| | | } |
| | | |
| | | return 1; |
| | | }); |
| | | |
| | | if (update_res == 1) return true; |
| | | throw new NotImplementedException("æå
¥ææ´æ°å¤±è´¥"); |
| | | } |
| | | |
| | | // æ¹éä¿åè®°å½çæ¹æ³ |
| | | public bool SaveList(List<MesBomDto> MesBomOrder) |
| | | { |
| | | var result = MesBomOrder.Select(Save).ToList(); |
| | | return result.All(b => b); |
| | | } |
| | | |
| | | private MesBomMaster ConvertErpToMesBom( |
| | | MesBomDto erpDto) |
| | | { |
| | | DateTime parsedDate; |
| | | |
| | | var main = erpDto.Main; |
| | | var MesBomOrder = new MesBomMaster |
| | | { |
| | | Erpid = main.Erpid, |
| | | Fbilltype = main.Fbilltype, |
| | | Fbomcategory = main.Fbomcategory, |
| | | Fbomuse = main.Fbomuse, |
| | | Fgroup = main.Fgroup, |
| | | Fnumber = main.Fnumber, |
| | | FUnwBomBb = main.FUnwBomBb, |
| | | EffectiveDate = main.EffectiveDate, |
| | | ExpirationDate = main.ExpirationDate, |
| | | Fmaterialid = main.Fmaterialid, |
| | | Fitemname = main.Fitemname, |
| | | Fbaseunitid = main.Fbaseunitid, |
| | | Fcreatorid = main.Fcreatorid, |
| | | Fcreatedate = main.Fcreatedate, |
| | | Fitempproperty = main.Fitempproperty, |
| | | Fdescription = main.Fdescription, |
| | | Fmodifierid = main.Fmodifierid, |
| | | Fmodifydate = main.Fmodifydate, |
| | | Fapproverid = main.Fapproverid, |
| | | Fapprovedate = main.Fapprovedate, |
| | | Fforbidreson = main.Fforbidreson, |
| | | Fforbidstatus = main.Fforbidstatus, |
| | | Fforbidderid = main.Fforbidderid, |
| | | Fforbiddate = main.Fforbiddate, |
| | | CreateOrganization = main.CreateOrganization, |
| | | UsingOrganization = main.UsingOrganization, |
| | | Routing = main.Routing, |
| | | FUnwTextTpgy = main.FUnwTextTpgy, |
| | | BomUpdateType = main.BomUpdateType |
| | | }; |
| | | |
| | | // var single = base.GetSingle(it => it.Erpid == main.Erpid); |
| | | // if (single != null) MesBomOrder.Erpid = single.Erpid; |
| | | |
| | | return MesBomOrder; |
| | | } |
| | | |
| | | private List<MesBomDetail1> ConvertErpToMesBomDetail1( |
| | | MesBomDto erpDtoList) |
| | | |
| | | { |
| | | var MesBomOrderSubList = |
| | | new List<MesBomDetail1>(); |
| | | |
| | | |
| | | foreach (var erpDto in erpDtoList.DT1) |
| | | { |
| | | var MesBomOrderSub = new MesBomDetail1 |
| | | { |
| | | Erpid = erpDto.Erpid, |
| | | Erphid = erpDto.Erphid, |
| | | Freplacegroup = erpDto.Freplacegroup, |
| | | Fscraprate = erpDto.Fscraprate, |
| | | Fpositionno = erpDto.Fpositionno, |
| | | Fmaterialidchild = erpDto.Fmaterialidchild, |
| | | Fnumerator = erpDto.Fnumerator, |
| | | Fdenominator = erpDto.Fdenominator, |
| | | Fchilditemname = erpDto.Fchilditemname, |
| | | Fchilditemproperty = erpDto.Fchilditemproperty, |
| | | Fsupplytype = erpDto.Fsupplytype, |
| | | Fmaterialtype = erpDto.Fmaterialtype, |
| | | FUnwBzds1 = erpDto.FUnwBzds1, |
| | | Fchildunitid = erpDto.Fchildunitid, |
| | | Fdosagetype = erpDto.Fdosagetype, |
| | | Fbomid = erpDto.Fbomid, |
| | | Fmemo = erpDto.Fmemo, |
| | | Fstockid = erpDto.Fstockid, |
| | | Fisskip = erpDto.Fisskip, |
| | | Fismulcsd = erpDto.Fismulcsd, |
| | | Feffectdate = erpDto.Feffectdate, |
| | | Fexpiredate = erpDto.Fexpiredate, |
| | | Fissuetype = erpDto.Fissuetype, |
| | | Fnetdemandrate = erpDto.Fnetdemandrate, |
| | | FUnwTextTpgyZ = erpDto.FUnwTextTpgyZ, |
| | | Fbackflushtype = erpDto.Fbackflushtype, |
| | | Fovercontrolmode = erpDto.Fovercontrolmode, |
| | | Fbpminissueqty = erpDto.Fbpminissueqty, |
| | | Fisminissueqty = erpDto.Fisminissueqty, |
| | | Fisgetscrap = erpDto.Fisgetscrap, |
| | | Foptqueue = erpDto.Foptqueue, |
| | | Foperid = erpDto.Foperid, |
| | | Fprocessid = erpDto.Fprocessid, |
| | | FUnwJjds1 = erpDto.FUnwJjds1 |
| | | |
| | | }; |
| | | |
| | | /*var single = MesBomDetail1Manager.GetSingle(it => |
| | | it.Erpid == MesBomOrderSub.Erpid); |
| | | if (single != null) MesBomOrderSub.Erpid = single.Erpid;*/ |
| | | |
| | | MesBomOrderSubList.Add(MesBomOrderSub); |
| | | } |
| | | |
| | | return MesBomOrderSubList; |
| | | } |
| | | |
| | | |
| | | |
| | | |
| | | private List<MesBomDetail2> ConvertErpToMesBomDetail2( |
| | | MesBomDto erpDtoList) |
| | | |
| | | { |
| | | var MesBomOrderSubList = |
| | | new List<MesBomDetail2>(); |
| | | |
| | | foreach (var erpDto in erpDtoList.DT2) |
| | | { |
| | | var MesBomOrderSub = new MesBomDetail2 |
| | | { |
| | | Erpid = erpDto.Erpid, |
| | | Erphid = erpDto.Erphid, |
| | | Fstartqty = erpDto.Fstartqty, |
| | | Fendqty = erpDto.Fendqty, |
| | | Funitidlot = erpDto.Funitidlot, |
| | | Ffixscrapqtylot = erpDto.Ffixscrapqtylot, |
| | | Fscrapratelot = erpDto.Fscrapratelot, |
| | | Fnumeratorlot = erpDto.Fnumeratorlot, |
| | | Fdenominatorlot = erpDto.Fdenominatorlot, |
| | | Fmaterialidlotbased = erpDto.Fmaterialidlotbased, |
| | | LineNumber = erpDto.LineNumber |
| | | |
| | | }; |
| | | |
| | | /*var single = MesBomDetail2Manager.GetSingle(it => |
| | | it.Erpid == MesBomOrderSub.Erpid); |
| | | if (single != null) MesBomOrderSub.Erpid = single.Erpid;*/ |
| | | |
| | | MesBomOrderSubList.Add(MesBomOrderSub); |
| | | } |
| | | |
| | | return MesBomOrderSubList; |
| | | } |
| | | } |
| | | |
| | | |
| | | |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | using SqlSugar; |
| | | using System; |
| | | using System.Collections.Generic; |
| | | using MES.Service.DB; |
| | | using MES.Service.Modes; |
| | | |
| | | namespace MES.Service.service |
| | | { |
| | | public class CgsqDetailManager : Repository<CgsqDetail> |
| | | { |
| | | |
| | | //å½å类已ç»ç»§æ¿äº Repository å¢ãå ãæ¥ãæ¹çæ¹æ³ |
| | | |
| | | //è¿éé¢åç代ç ä¸ä¼ç»è¦ç,妿è¦éæ°çæè¯·å é¤ CgsqDetailManager.cs |
| | | |
| | | |
| | | #region æå¦æ¹æ³ |
| | | /// <summary> |
| | | /// ä»å¨æ¹æ³æ»¡è¶³ä¸äºå¤æä¸å¡éæ±ï¼ä¸å¡ä»£ç 请å¨è¿éé¢å®ä¹æ¹æ³ |
| | | /// </summary> |
| | | public void Study() |
| | | { |
| | | |
| | | /*********æ¥è¯¢*********/ |
| | | |
| | | var data1 = base.GetById(1);//æ ¹æ®IDæ¥è¯¢ |
| | | var data2 = base.GetList();//æ¥è¯¢ææ |
| | | var data3 = base.GetList(it => 1 == 1); //æ ¹æ®æ¡ä»¶æ¥è¯¢ |
| | | //var data4 = base.GetSingle(it => 1 == 1);//æ ¹æ®æ¡ä»¶æ¥è¯¢ä¸æ¡,妿è¶
è¿ä¸æ¡ä¼æ¥é |
| | | |
| | | var p = new PageModel() { PageIndex = 1, PageSize = 2 };// å页æ¥è¯¢ |
| | | var data5 = base.GetPageList(it => 1 == 1, p); |
| | | Console.Write(p.TotalCount);//è¿åæ»æ° |
| | | |
| | | var data6 = base.GetPageList(it => 1 == 1, p, it => SqlFunc.GetRandom(), OrderByType.Asc);// å页æ¥è¯¢å æåº |
| | | Console.Write(p.TotalCount);//è¿åæ»æ° |
| | | |
| | | List<IConditionalModel> conModels = new List<IConditionalModel>(); //ç»è£
æ¡ä»¶æ¥è¯¢ä½ä¸ºæ¡ä»¶å®ç° å页æ¥è¯¢å æåº |
| | | conModels.Add(new ConditionalModel() { FieldName= typeof(CgsqDetail).GetProperties()[0].Name, ConditionalType = ConditionalType.Equal, FieldValue = "1" });//id=1 |
| | | var data7 = base.GetPageList(conModels, p, it => SqlFunc.GetRandom(), OrderByType.Asc); |
| | | |
| | | base.AsQueryable().Where(x => 1 == 1).ToList();//æ¯æäºè½¬æ¢æqueryable,æä»¬å¯ä»¥ç¨queryableå®ç°å¤æåè½ |
| | | |
| | | |
| | | |
| | | /*********æå
¥*********/ |
| | | var insertData = new CgsqDetail() { };//æµè¯åæ° |
| | | var insertArray = new CgsqDetail[] { insertData }; |
| | | base.Insert(insertData);//æå
¥ |
| | | base.InsertRange(insertArray);//æ¹éæå
¥ |
| | | var id = base.InsertReturnIdentity(insertData);//æå
¥è¿åèªå¢å |
| | | base.AsInsertable(insertData).ExecuteCommand();//æä»¬å¯ä»¥è½¬æ Insertableå®ç°å¤ææå
¥ |
| | | |
| | | |
| | | |
| | | /*********æ´æ°*********/ |
| | | var updateData = new CgsqDetail() { };//æµè¯åæ° |
| | | var updateArray = new CgsqDetail[] { updateData };//æµè¯åæ° |
| | | base.Update(updateData);//æ ¹æ®å®ä½æ´æ° |
| | | base.UpdateRange(updateArray);//æ¹éæ´æ° |
| | | //base.Update(it => new CgsqDetail() { ClassName = "a", CreateTime = DateTime.Now }, it => it.id==1);// åªæ´æ°ClassNameååCreateTimeåï¼å
¶å®å䏿´æ°ï¼æ¡ä»¶id=1 |
| | | base.AsUpdateable(updateData).ExecuteCommand(); //转æUpdateableå¯ä»¥å®ç°å¤æçæå
¥ |
| | | |
| | | |
| | | |
| | | /*********å é¤*********/ |
| | | var deldata = new CgsqDetail() { };//æµè¯åæ° |
| | | base.Delete(deldata);//æ ¹æ®å®ä½å é¤ |
| | | base.DeleteById(1);//æ ¹æ®ä¸»é®å é¤ |
| | | base.DeleteById(new int[] { 1,2});//æ ¹æ®ä¸»é®æ°ç»å é¤ |
| | | base.Delete(it=>1==2);//æ ¹æ®æ¡ä»¶å é¤ |
| | | base.AsDeleteable().Where(it=>1==2).ExecuteCommand();//转æDeleteableå®ç°å¤æçæä½ |
| | | } |
| | | #endregion |
| | | |
| | | |
| | | } |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | using SqlSugar; |
| | | using System; |
| | | using System.Collections.Generic; |
| | | using MES.Service.DB; |
| | | using MES.Service.Modes; |
| | | using MES.Service.Dto.webApi; |
| | | using System.Globalization; |
| | | using MES.Service.Dto.service; |
| | | |
| | | namespace MES.Service.service |
| | | { |
| | | public class CgsqManager : Repository<Cgsq> |
| | | { |
| | | |
| | | private readonly CgsqDetailManager CgsqDetailManager = new(); |
| | | |
| | | public bool Save(CgsqDto Cgsq) |
| | | { |
| | | // var CgsqDto = Cgsq.CgsqMain; |
| | | var mesCgsq = ConvertErpToCgsq(Cgsq); |
| | | var mesCgsqDatas = ConvertErpToCgsqDetail(Cgsq); |
| | | |
| | | return UseTransaction(db => |
| | | { |
| | | switch (Cgsq.Type) |
| | | { |
| | | // case "2": |
| | | // return InsertData(db, mesSalesReturn, mesSalesReturnDatas, |
| | | // rohInErpRohIn.FBILLTYPE) |
| | | // ? 1 |
| | | // : 0; |
| | | case "3": |
| | | return UpdateData(db, mesCgsq, mesCgsqDatas) ? 1 : 0; |
| | | case "2": |
| | | case "4": |
| | | return SaveOrUpdateData(db, mesCgsq, mesCgsqDatas, Cgsq.Type) |
| | | ? 1 |
| | | : 0; |
| | | default: |
| | | throw new NotImplementedException( |
| | | $"type没æ{Cgsq.Type}è¿ä¸ªç±»å"); |
| | | } |
| | | }) > 0; |
| | | } |
| | | |
| | | private bool UpdateData(SqlSugarScope db, Cgsq mesCgsq, |
| | | List<CgsqDetail> mesCgsqDatas) |
| | | { |
| | | var decimals = mesCgsqDatas.Select(s => s.ERPID).ToArray(); |
| | | var update = base.DeleteById(mesCgsq.ERPID); |
| | | var insertOrUpdate = db |
| | | .Deleteable<CgsqDetail>().In(decimals) |
| | | .ExecuteCommand() > 0; |
| | | |
| | | if (update && insertOrUpdate) return true; |
| | | throw new NotImplementedException("æ´æ°å¤±è´¥"); |
| | | } |
| | | |
| | | // æå
¥ææ´æ°æ°æ®çæ¹æ³ |
| | | private bool SaveOrUpdateData(SqlSugarScope db, Cgsq mesCgsq, |
| | | List<CgsqDetail> mesCgsqDatas, string type) |
| | | { |
| | | if (mesCgsq.ERPID != null) |
| | | base.DeleteById(mesCgsq.ERPID); |
| | | |
| | | if (mesCgsqDatas.Count > 0) |
| | | db.Deleteable<CgsqDetail>() |
| | | .Where(s => s.ERPHID == mesCgsq.ERPID).ExecuteCommand(); |
| | | |
| | | //var orUpdate = base.Insert(mesCgsq); |
| | | //var baOrUpdate = CgsqDetailManager.InsertRange(mesCgsqDatas); |
| | | //if (orUpdate && baOrUpdate) return true; |
| | | |
| | | var update_res = UseTransaction(db => |
| | | { |
| | | |
| | | db.Insertable(mesCgsq).ExecuteCommand(); |
| | | |
| | | for (int i = 0; i < mesCgsqDatas.Count; i++) |
| | | { |
| | | var item = mesCgsqDatas[i]; |
| | | //item.PID = id; |
| | | db.Insertable(item).IgnoreColumns(true).ExecuteCommand(); |
| | | } |
| | | |
| | | return 1; |
| | | }); |
| | | |
| | | if (update_res == 1) return true; |
| | | throw new NotImplementedException("æå
¥ææ´æ°å¤±è´¥"); |
| | | } |
| | | |
| | | // æ¹éä¿åè®°å½çæ¹æ³ |
| | | public bool SaveList(List<CgsqDto> CgsqOrder) |
| | | { |
| | | var result = CgsqOrder.Select(Save).ToList(); |
| | | return result.All(b => b); |
| | | } |
| | | |
| | | private Cgsq ConvertErpToCgsq( |
| | | CgsqDto erpDto) |
| | | { |
| | | DateTime parsedDate; |
| | | |
| | | // æ¶é´æ ¼å¼è½¬æ¢å½æ°ï¼ERPæ¶é´æ ¼å¼ä¸º "yyyy-MM-dd HH:mm:ss" |
| | | DateTime? ParseDateTime(string dateStr) |
| | | { |
| | | if (DateTime.TryParseExact(dateStr, "yyyy-MM-dd HH:mm:ss", |
| | | CultureInfo.InvariantCulture, |
| | | DateTimeStyles.None, |
| | | out parsedDate)) |
| | | return parsedDate; |
| | | |
| | | return null; // å¦æè½¬æ¢å¤±è´¥ï¼è¿ånull |
| | | } |
| | | var main = erpDto.CgsqMain; |
| | | var CgsqOrder = new Cgsq |
| | | { |
| | | ERPID=main.ERPID, |
| | | Fbilltypeid = main.Fbilltypeid, |
| | | Fbillno = main.Fbillno, |
| | | Fapplicationdate = main.Fapplicationdate, |
| | | Frequesttype = main.Frequesttype, |
| | | FUnwComboZjmj = main.FUnwComboZjmj, |
| | | ApplyingOrganizationId = main.ApplyingOrganizationId, |
| | | Fapplicationdeptid = main.Fapplicationdeptid, |
| | | Fapplicantid = main.Fapplicantid, |
| | | Fcurrencyid = main.Fcurrencyid, |
| | | Facctype = main.Facctype, |
| | | Fdocumentstatus = main.Fdocumentstatus, |
| | | Fnote = main.Fnote, |
| | | Fcreatorid = main.Fcreatorid, |
| | | Fcreatedate = main.Fcreatedate, |
| | | Fapproverid = main.Fapproverid, |
| | | Fapprovedate = main.Fapprovedate, |
| | | Fclosestatus = main.Fclosestatus, |
| | | Fclosedate = main.Fclosedate, |
| | | Fcloserid = main.Fcloserid, |
| | | Fclosereason = main.Fclosereason, |
| | | Fmodifierid = main.Fmodifierid, |
| | | Fmodifydate = main.Fmodifydate, |
| | | Fmanualclose = main.Fmanualclose |
| | | }; |
| | | |
| | | // var single = base.GetSingle(it => it.ERPID == main.ERPID); |
| | | // if (single != null) CgsqOrder.ERPID = single.ERPID; |
| | | |
| | | return CgsqOrder; |
| | | } |
| | | |
| | | private List<CgsqDetail> ConvertErpToCgsqDetail( |
| | | CgsqDto erpDtoList) |
| | | |
| | | { |
| | | var CgsqOrderSubList = |
| | | new List<CgsqDetail>(); |
| | | |
| | | DateTime parsedDate; |
| | | // æ¶é´æ ¼å¼è½¬æ¢å½æ°ï¼ERPæ¶é´æ ¼å¼ä¸º "yyyy-MM-dd HH:mm:ss" |
| | | DateTime? ParseDateTime(string dateStr) |
| | | { |
| | | if (DateTime.TryParseExact(dateStr, "yyyy-MM-dd HH:mm:ss", |
| | | CultureInfo.InvariantCulture, |
| | | DateTimeStyles.None, |
| | | out parsedDate)) |
| | | return parsedDate; |
| | | |
| | | return null; // å¦æè½¬æ¢å¤±è´¥ï¼è¿ånull |
| | | } |
| | | |
| | | |
| | | |
| | | foreach (var erpDto in erpDtoList.CgsqDT) |
| | | { |
| | | var CgsqOrderSub = new CgsqDetail |
| | | { |
| | | ERPID = erpDto.ERPID, |
| | | ERPHID = erpDto.ERPHID, |
| | | LineNumber = erpDto.LineNumber, |
| | | FUnwTextXsddh = erpDto.FUnwTextXsddh, |
| | | OwnerOrganizationId = erpDto.OwnerOrganizationId, |
| | | Fmaterialid = erpDto.Fmaterialid, |
| | | Fmaterialmodel = erpDto.Fmaterialmodel, |
| | | Fmaterialname = erpDto.Fmaterialname, |
| | | Funitid = erpDto.Funitid, |
| | | Freqqty = erpDto.Freqqty, |
| | | Fapproveqty = erpDto.Fapproveqty, |
| | | Farrivaldate = erpDto.Farrivaldate, |
| | | Fsuggestpurdate = erpDto.Fsuggestpurdate, |
| | | BuyerOrganizationId = erpDto.BuyerOrganizationId, |
| | | Fsuggestsupplierid = erpDto.Fsuggestsupplierid, |
| | | WarehouseId = erpDto.WarehouseId, |
| | | Freqstockunitid = erpDto.Freqstockunitid, |
| | | Freqstockqty = erpDto.Freqstockqty, |
| | | Fpriceunitid = erpDto.Fpriceunitid, |
| | | Fpriceunitqty = erpDto.Fpriceunitqty, |
| | | Fleadtime = erpDto.Fleadtime, |
| | | Fmtono = erpDto.Fmtono, |
| | | Freqtraceno = erpDto.Freqtraceno, |
| | | Fdemandbillno = erpDto.Fdemandbillno, |
| | | Fdemandbillentryseq = erpDto.Fdemandbillentryseq, |
| | | Fmrpterminatestatus = erpDto.Fmrpterminatestatus, |
| | | Fterminaterid = erpDto.Fterminaterid, |
| | | Fterminatedate = erpDto.Fterminatedate |
| | | |
| | | }; |
| | | |
| | | /*var single = CgsqDetailManager.GetSingle(it => |
| | | it.ERPID == CgsqOrderSub.ERPID); |
| | | if (single != null) CgsqOrderSub.ERPID = single.ERPID;*/ |
| | | |
| | | CgsqOrderSubList.Add(CgsqOrderSub); |
| | | } |
| | | |
| | | return CgsqOrderSubList; |
| | | } |
| | | |
| | | } |
| | | } |
| | |
| | | using MES.Service.DB; |
| | | using Masuit.Tools.Models; |
| | | using MES.Service.DB; |
| | | using MES.Service.Dto.service; |
| | | using MES.Service.Modes; |
| | | using MES.Service.util; |
| | |
| | | |
| | | if (!string.IsNullOrEmpty(qsItemOqcReq.FcheckResu)) |
| | | { |
| | | throw new Exception("该æ£éªåå·²" + qsItemOqcReq.FcheckResu + "ï¼ä¸è¿è¡ä¿®æ¹ç»æ"); |
| | | throw new Exception("该æ£éªåå·²" + qsItemOqcReq.FcheckResu + "ï¼ä¸å
许修æ¹ç»æ"); |
| | | } |
| | | |
| | | var oracle = SqlSugarHelper.UseTransactionWithOracle(db => |
| | |
| | | /// womdaa å·²ç产é DAA011å åæ¡ç æ¥å·¥æ°é |
| | | /// MES_SCGD_GX æ£éªæ è¯ CHECK_FLAGï¼('â','Ã') |
| | | /// éè¿mes_inv_item_in_c_details2çMES_SCGD_GX_IDè¿æ¥ |
| | | /// |
| | | /// 20250602æ´æ° ç°å¨ä¸åæ ¼ä¸ä¼æ´æ°å·¥åç产æ°éï¼åæ ¼ä¼å¢å 对åºå·¥åç产æ°é |
| | | ///</summary> |
| | | private void setBarCodes(string? FcheckResu, QsItemOqcItemDetail detail, |
| | | SqlSugarClient db) |
| | |
| | | var barCodes = mesInvItemInsList.Select(s => s.ItemBarcode).ToList(); |
| | | |
| | | var count = db.Queryable<MesInvItemBarcodes>() |
| | | .Where(s => barCodes.Contains(s.ItemBarcode) && s.WorkFlg == 0) |
| | | .Where(s => barCodes.Contains(s.ItemBarcode)) |
| | | .Count(); |
| | | |
| | | var gxId = mesInvItemInsList.Select(s => s.MesScgdGxId).ToList(); |
| | |
| | | |
| | | if (count <= 0) return; |
| | | |
| | | //åæ¶mes_inv_item_barcodes çæ¥å·¥æ è¯ WORK_FLG ä½¿ç¨æ¡ç |
| | | //æ´æ°mes_inv_item_barcodes çæ¥å·¥æ è¯ WORK_FLG ä½¿ç¨æ¡ç |
| | | var executeCommand = db.Updateable<MesInvItemBarcodes>() |
| | | .SetColumns(a => a.WorkFlg == 1) |
| | | .Where(a => barCodes.Contains(a.ItemBarcode)) |
| | |
| | | |
| | | if (executeCommand > 0) |
| | | { |
| | | //womdaa å·²ç产é DAA011å åæ¡ç æ¥å·¥æ°é |
| | | //womdaa å·²ç产é DAA011å 䏿¡ç æ¥å·¥æ°é |
| | | db.Updateable<Womdaa>() |
| | | .SetColumns(b => b.Daa011 == b.Daa011 + sumQty) |
| | | .SetColumns(b => b.Daa011 == SqlFunc.IsNull(b.Daa011, 0) + sumQty) |
| | | .Where(b => b.Daa001 == qsItemOqcReq.Daa001) |
| | | .ExecuteCommand(); |
| | | |
| | | //夿æ¯å¦å®å·¥ |
| | | var complete = db.Queryable<Womdaa>() |
| | | .Where(a => a.Daa008 == a.Daa011 && a.Daa001== qsItemOqcReq.Daa001) |
| | | .Count(); |
| | | |
| | | var WqtQty = db.Queryable<Womdab>() |
| | | .Where(a => a.Dab001 == qsItemOqcReq.Daa001) |
| | | .Sum(a => a.Dab006- SqlFunc.IsNull(a.Dab007, 0)); |
| | | |
| | | if (complete > 0 && WqtQty == 0) //é½å¥ä¸å·¥åç产æ°é=工忰éï¼å·¥åæ´æ¹ä¸ºå®å·¥ |
| | | { |
| | | db.Updateable<Womdaa>() |
| | | .SetColumns(b => b.Daa018 == "å®å·¥") |
| | | .SetColumns(b => b.Daa017 == DateTime.Now) |
| | | .Where(b => b.Daa001 == qsItemOqcReq.Daa001) |
| | | .ExecuteCommand(); |
| | | } |
| | | } |
| | | } |
| | | else if ("ä¸åæ ¼".Equals(FcheckResu)) |
| | |
| | | .Where(a => barCodes.Contains(a.ItemBarcode)) |
| | | .ExecuteCommand(); |
| | | |
| | | if (executeCommand > 0) |
| | | /*if (executeCommand > 0) |
| | | { |
| | | //womdaa å·²ç产é DAA011å åæ¡ç æ¥å·¥æ°é |
| | | //womdaa å·²ç产é DAA011æ£é¤æ¡ç æ¥å·¥æ°é |
| | | db.Updateable<Womdaa>() |
| | | .SetColumns(b => b.Daa011 == b.Daa011 - sumQty) |
| | | .Where(b => b.Daa001 == qsItemOqcReq.Daa001) |
| | | .ExecuteCommand(); |
| | | } |
| | | }*/ |
| | | } |
| | | } |
| | | |
| | |
| | | |
| | | if (!string.IsNullOrEmpty(qsItemOqcReq.FcheckResu)) |
| | | { |
| | | throw new Exception("该æ£éªåå·²" + qsItemOqcReq.FcheckResu + "ï¼ä¸è¿è¡ä¿®æ¹ç»æ"); |
| | | throw new Exception("该æ£éªåå·²" + qsItemOqcReq.FcheckResu + "ï¼ä¸å
许修æ¹ç»æ"); |
| | | } |
| | | |
| | | var withOracle = SqlSugarHelper.UseTransactionWithOracle(db => |
| | |
| | | }); |
| | | } |
| | | |
| | | public int saveItem(RKJDto rkjDto) |
| | | public int saveItem(RKJDto rkjDto) //èªå¨çæåæ ¼çæ£éªé¡¹ |
| | | { |
| | | var items = rkjDto.items; |
| | | var userNo = rkjDto.userNo; |
| | |
| | | SetQSItemDetail(detail); |
| | | }); |
| | | |
| | | //å 为é»è®¤åæ ¼ï¼å¨è¿éå¢å å·¥åç产æ°é |
| | | var db = SqlSugarHelper.GetInstance(); |
| | | var oqcReqList = db.Queryable<QsItemOqcReq, MesInvItemIns, Womdaa>( |
| | | (a, b, c) => |
| | | new JoinQueryInfos( |
| | | JoinType.Left, a.BillNo == b.BillNo, |
| | | JoinType.Left, c.Daa001 == b.RbillNo |
| | | )) |
| | | .Where(a => a.Id == rkjDto.gid) |
| | | .Select((a, b, c) => |
| | | new |
| | | { |
| | | a.Id, |
| | | a.BillNo, |
| | | c.Daa001 |
| | | }) |
| | | .First(); |
| | | |
| | | if (oqcReqList.Id is null or 0) return 0; |
| | | |
| | | //æ¥è¯¢æ£éªæ°é |
| | | var sumQty = db |
| | | .Queryable<MesInvItemIns, MesInvItemInCDetails2>((a, b) => |
| | | new JoinQueryInfos( |
| | | JoinType.Left, a.Id == b.ItemInId)) |
| | | .Where((a, b) => a.BillNo == oqcReqList.BillNo) |
| | | .Select((a, b) => new {b.Quantity }) |
| | | .MergeTable().Sum( a=> a.Quantity); |
| | | |
| | | /* |
| | | //æ´æ°ç产é |
| | | db.Updateable<Womdaa>() |
| | | .SetColumns(b => b.Daa011 == SqlFunc.IsNull(b.Daa011, 0) + sumQty) |
| | | .Where(b => b.Daa001 == oqcReqList.Daa001) |
| | | .ExecuteCommand(); |
| | | |
| | | //夿æ¯å¦å®å·¥ |
| | | var complete = db.Queryable<Womdaa>() |
| | | .Where(a => a.Daa008 == a.Daa011 && a.Daa001 == oqcReqList.Daa001) |
| | | .Count(); |
| | | |
| | | if (complete > 0) |
| | | { |
| | | db.Updateable<Womdaa>() |
| | | .SetColumns(b => b.Daa018 == "å®å·¥") |
| | | .Where(b => b.Daa001 == oqcReqList.Daa001) |
| | | .ExecuteCommand(); |
| | | } |
| | | |
| | | */ |
| | | |
| | | return Convert.ToInt32(rkjDto.gid); |
| | | } |
| | | |
| | | public int cleanReqResult(RKJDto dto) |
| | | public int cleanReqResult(RKJDto dto) //æ¸
餿£éªç»æ |
| | | { |
| | | if (isRk(dto.gid)) throw new Exception("å·²ææ¡ç å
¥åºï¼ä¸å
许æ¸
餿£éªç»æ"); |
| | | |
| | | var db = SqlSugarHelper.GetInstance(); |
| | | //æ¥è¯¢æ£éªç»æ |
| | | var oqcReqList = db.Queryable<QsItemOqcReq, MesInvItemIns, Womdaa>( |
| | | (a, b, c) => |
| | | new JoinQueryInfos( |
| | | JoinType.Left, a.BillNo == b.BillNo, |
| | | JoinType.Left, c.Daa001 == b.RbillNo |
| | | )) |
| | | .Where(a => a.Id == dto.gid) |
| | | .Select((a, b, c) => |
| | | new |
| | | { |
| | | a.FcheckResu, |
| | | a.Id, |
| | | a.BillNo, |
| | | c.Daa001 |
| | | }) |
| | | .First(); |
| | | |
| | | if (oqcReqList.Id is null or 0) return 0; |
| | | |
| | | var FcheckResu = oqcReqList.FcheckResu; //æ£éªç»æ |
| | | |
| | | //æ¥è¯¢æ£éªæ°é |
| | | var mesInvItemInsList = db |
| | | .Queryable<MesInvItemIns, MesInvItemInCDetails2>((a, b) => |
| | | new JoinQueryInfos( |
| | | JoinType.Left, a.Id == b.ItemInId)) |
| | | .Where((a, b) => a.BillNo == oqcReqList.BillNo) |
| | | .Select((a, b) => new |
| | | { b.ItemBarcode, b.Quantity, b.MesScgdGxId }) |
| | | .ToList(); |
| | | |
| | | var barCodes = mesInvItemInsList.Select(s => s.ItemBarcode).ToList(); |
| | | |
| | | var count = db.Queryable<MesInvItemBarcodes>() |
| | | .Where(s => barCodes.Contains(s.ItemBarcode)) |
| | | .Count(); |
| | | |
| | | var gxId = mesInvItemInsList.Select(s => s.MesScgdGxId).ToList(); |
| | | |
| | | var sumQty = mesInvItemInsList.Sum(s => s.Quantity); |
| | | |
| | | |
| | | //æ ¹æ®å·¥åºidæ´æ°å·¥åºè¡¨çæ£éªç»æ |
| | | db.Updateable<MesScgdGx>() |
| | | .SetColumns(s => s.CheckFlag == "æªæ£éª") |
| | | .Where(s => gxId.Contains(s.Id)) |
| | | .ExecuteCommand(); |
| | | |
| | | if (count <= 0) return 0; |
| | | |
| | | //æ´æ°mes_inv_item_barcodes çæ¥å·¥æ è¯ WORK_FLG 为已æ¥å·¥ï¼ä¸»è¦æ¯é对ä¸åæ ¼çæ£éªç»æï¼ |
| | | var executeCommand = db.Updateable<MesInvItemBarcodes>() |
| | | .SetColumns(a => a.WorkFlg == 1) |
| | | .Where(a => barCodes.Contains(a.ItemBarcode)) |
| | | .ExecuteCommand(); |
| | | |
| | | |
| | | if ("åæ ¼".Equals(FcheckResu)) //æ£éªåæ ¼çååéç产æ°é |
| | | { |
| | | //womdaa å·²ç产é DAA011æ£é¤æ¡ç æ¥å·¥æ°é |
| | | db.Updateable<Womdaa>() |
| | | .SetColumns(b => b.Daa011 == SqlFunc.IsNull(b.Daa011, 0) - sumQty) |
| | | .Where(b => b.Daa001 == oqcReqList.Daa001) |
| | | .ExecuteCommand(); |
| | | |
| | | //å·¥åç¶ææ´æ¹ä¸ºå¼å·¥ |
| | | db.Updateable<Womdaa>() |
| | | .SetColumns(b => b.Daa018 == "å¼å·¥") |
| | | .SetColumns(b => b.Daa017 == null) |
| | | .Where(b => b.Daa001 == oqcReqList.Daa001) |
| | | .ExecuteCommand(); |
| | | } |
| | | |
| | | |
| | | return SqlSugarHelper.UseTransactionWithOracle(db => |
| | | { |
| | |
| | | return db |
| | | .Queryable<MesQualityStandard>() |
| | | .Where(b => b.QsType == "2" |
| | | && b.ItemNo == itemNo).Select( |
| | | && b.ItemNo == itemNo |
| | | && b.ProcId == procid).Select( |
| | | b => new QsQaItemXj01 |
| | | { |
| | | ProjName = b.ProjName, |
¶Ô±ÈÐÂÎļþ |
| | |
| | | using Microsoft.AspNetCore.Mvc; |
| | | using Microsoft.Extensions.Logging; |
| | | using SqlSugar; |
| | | using System; |
| | | using System.Collections.Generic; |
| | | using System.Linq; |
| | | using System.Threading.Tasks; |
| | | using System.Dynamic; |
| | | using MES.Service.Modes; |
| | | using MES.Service.service; |
| | | using MES.Service.util; |
| | | using MES.Service.Dto.service; |
| | | using Newtonsoft.Json; |
| | | |
| | | namespace MESApplication.Controllers |
| | | { |
| | | [ApiController] |
| | | [Route("api/[controller]")] |
| | | public class MesBomMasterController : ControllerBase |
| | | { |
| | | |
| | | private MesBomMasterManager m = new MesBomMasterManager(); |
| | | |
| | | private readonly MessageCenterManager _manager = new(); |
| | | |
| | | private readonly string METHOD = "POST"; |
| | | |
| | | private readonly string TableName = "MesBomMaster"; |
| | | |
| | | private readonly string URL = "http://localhost:10054/api/MesBomMaster/"; |
| | | |
| | | /***è¿å
¥æ¨¡ç管çå¯ä»¥ä¿®æ¹æ¨¡ç***/ |
| | | |
| | | [HttpPost("Save")] |
| | | public ResponseResult Save(MesBomDto MesBomOrder) |
| | | { |
| | | var entity = new MessageCenter(); |
| | | entity.TableName = TableName; |
| | | entity.Url = URL + "Save"; |
| | | entity.Method = METHOD; |
| | | entity.Status = 1; |
| | | entity.CreateBy = "PL017"; |
| | | try |
| | | { |
| | | dynamic resultInfos = new ExpandoObject(); |
| | | var save = m.Save(MesBomOrder); |
| | | |
| | | resultInfos.tbBillList = save; |
| | | |
| | | entity.Result = 0; |
| | | if (save) entity.Result = 1; |
| | | |
| | | entity.DealWith = 1; |
| | | entity.Data = JsonConvert.SerializeObject(MesBomOrder); |
| | | _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("SaveList")] |
| | | public ResponseResult SaveList(List<MesBomDto> units) |
| | | { |
| | | var entity = new MessageCenter(); |
| | | entity.TableName = TableName; |
| | | entity.Url = URL + "SaveList"; |
| | | entity.Method = METHOD; |
| | | entity.Data = JsonConvert.SerializeObject(units); |
| | | entity.Status = 1; |
| | | entity.CreateBy = "PL017"; |
| | | try |
| | | { |
| | | dynamic resultInfos = new ExpandoObject(); |
| | | var save = m.SaveList(units); |
| | | resultInfos.tbBillList = 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); |
| | | } |
| | | } |
| | | |
| | | |
| | | /***è¿å
¥æ¨¡ç管çå¯ä»¥ä¿®æ¹æ¨¡ç***/ |
| | | |
| | | /// <summary> |
| | | /// è·åææ |
| | | /// </summary> |
| | | /// <returns></returns> |
| | | [HttpPost("GetList")] |
| | | public ResponseResult GetList() |
| | | { |
| | | try |
| | | { |
| | | dynamic resultInfos = new ExpandoObject(); |
| | | resultInfos.tbBillList = m.GetList(); |
| | | return new ResponseResult |
| | | { |
| | | status = 0, |
| | | message = "OK", |
| | | data = resultInfos |
| | | }; |
| | | } |
| | | catch (Exception ex) |
| | | { |
| | | return ResponseResult.ResponseError(ex); |
| | | } |
| | | } |
| | | |
| | | |
| | | /// <summary> |
| | | /// æ ¹æ®ä¸»é®è·å |
| | | /// </summary> |
| | | /// <returns></returns> |
| | | [HttpPost("GetById")] |
| | | public ResponseResult GetById(int id) |
| | | { |
| | | try |
| | | { |
| | | dynamic resultInfos = new ExpandoObject(); |
| | | resultInfos.tbBillList = m.GetById(id); |
| | | return new ResponseResult |
| | | { |
| | | status = 0, |
| | | message = "OK", |
| | | data = resultInfos |
| | | }; |
| | | } |
| | | catch (Exception ex) |
| | | { |
| | | return ResponseResult.ResponseError(ex); |
| | | } |
| | | } |
| | | |
| | | /// <summary> |
| | | /// æ ¹æ®ä¸»é®å é¤ |
| | | /// </summary> |
| | | /// <returns></returns> |
| | | [HttpPost("DeleteByIds")] |
| | | public ResponseResult DeleteByIds([FromBody] object[] ids) |
| | | { |
| | | try |
| | | { |
| | | dynamic resultInfos = new ExpandoObject(); |
| | | resultInfos.tbBillList = m.DeleteByIds(ids); |
| | | return new ResponseResult |
| | | { |
| | | status = 0, |
| | | message = "OK", |
| | | data = resultInfos |
| | | }; |
| | | } |
| | | catch (Exception ex) |
| | | { |
| | | return ResponseResult.ResponseError(ex); |
| | | } |
| | | } |
| | | |
| | | /// <summary> |
| | | /// æ·»å |
| | | /// </summary> |
| | | /// <returns></returns> |
| | | [HttpPost("Insert")] |
| | | public ResponseResult Add([FromBody] MesBomMaster data) |
| | | { |
| | | try |
| | | { |
| | | dynamic resultInfos = new ExpandoObject(); |
| | | resultInfos.tbBillList = m.Insert(data); |
| | | return new ResponseResult |
| | | { |
| | | status = 0, |
| | | message = "OK", |
| | | data = resultInfos |
| | | }; |
| | | } |
| | | catch (Exception ex) |
| | | { |
| | | return ResponseResult.ResponseError(ex); |
| | | } |
| | | } |
| | | /// <summary> |
| | | /// æ·»å è¿åèªå¢ |
| | | /// </summary> |
| | | /// <returns></returns> |
| | | [HttpPost("InsertReturnIdentity")] |
| | | public ResponseResult InsertReturnIdentity([FromBody] MesBomMaster data) |
| | | { |
| | | try |
| | | { |
| | | dynamic resultInfos = new ExpandoObject(); |
| | | resultInfos.tbBillList = m.InsertReturnIdentity(data); |
| | | return new ResponseResult |
| | | { |
| | | status = 0, |
| | | message = "OK", |
| | | data = resultInfos |
| | | }; |
| | | } |
| | | catch (Exception ex) |
| | | { |
| | | return ResponseResult.ResponseError(ex); |
| | | } |
| | | } |
| | | |
| | | /// <summary> |
| | | /// ä¿®æ¹ |
| | | /// </summary> |
| | | /// <returns></returns> |
| | | [HttpPost("Update")] |
| | | public ResponseResult Update([FromBody] MesBomMaster data) |
| | | { |
| | | try |
| | | { |
| | | dynamic resultInfos = new ExpandoObject(); |
| | | resultInfos.tbBillList = m.Update(data); |
| | | return new ResponseResult |
| | | { |
| | | status = 0, |
| | | message = "OK", |
| | | data = resultInfos |
| | | }; |
| | | } |
| | | catch (Exception ex) |
| | | { |
| | | return ResponseResult.ResponseError(ex); |
| | | } |
| | | } |
| | | } |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | using Microsoft.AspNetCore.Mvc; |
| | | using Microsoft.Extensions.Logging; |
| | | using SqlSugar; |
| | | using System; |
| | | using System.Collections.Generic; |
| | | using System.Linq; |
| | | using System.Threading.Tasks; |
| | | using System.Dynamic; |
| | | using MES.Service.Modes; |
| | | using MES.Service.service; |
| | | using MES.Service.util; |
| | | using MES.Service.service.BasicData; |
| | | using MES.Service.Dto.webApi; |
| | | using Newtonsoft.Json; |
| | | using MES.Service.Dto.service; |
| | | |
| | | namespace MESApplication.Controllers |
| | | { |
| | | [ApiController] |
| | | [Route("api/[controller]")] |
| | | public class CgsqController : ControllerBase |
| | | { |
| | | |
| | | private CgsqManager m = new CgsqManager(); |
| | | |
| | | private readonly MessageCenterManager _manager = new(); |
| | | |
| | | private readonly string METHOD = "POST"; |
| | | |
| | | private readonly string TableName = "MES_CGSQ"; |
| | | |
| | | private readonly string URL = "http://localhost:10054/api/CGSQ/"; |
| | | |
| | | /***è¿å
¥æ¨¡ç管çå¯ä»¥ä¿®æ¹æ¨¡ç***/ |
| | | |
| | | [HttpPost("Save")] |
| | | public ResponseResult Save(CgsqDto CgsqOrder) |
| | | { |
| | | var entity = new MessageCenter(); |
| | | entity.TableName = TableName; |
| | | entity.Url = URL + "Save"; |
| | | entity.Method = METHOD; |
| | | entity.Data = JsonConvert.SerializeObject(CgsqOrder); |
| | | entity.Status = 1; |
| | | entity.CreateBy = "PL017"; |
| | | try |
| | | { |
| | | dynamic resultInfos = new ExpandoObject(); |
| | | var save = m.Save(CgsqOrder); |
| | | |
| | | resultInfos.tbBillList = 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("SaveList")] |
| | | public ResponseResult SaveList(List<CgsqDto> units) |
| | | { |
| | | var entity = new MessageCenter(); |
| | | entity.TableName = TableName; |
| | | entity.Url = URL + "SaveList"; |
| | | entity.Method = METHOD; |
| | | entity.Data = JsonConvert.SerializeObject(units); |
| | | entity.Status = 1; |
| | | entity.CreateBy = "PL017"; |
| | | try |
| | | { |
| | | dynamic resultInfos = new ExpandoObject(); |
| | | var save = m.SaveList(units); |
| | | resultInfos.tbBillList = 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); |
| | | } |
| | | } |
| | | |
| | | /// <summary> |
| | | /// è·åææ |
| | | /// </summary> |
| | | /// <returns></returns> |
| | | [HttpPost("GetList")] |
| | | public ResponseResult GetList() |
| | | { |
| | | try |
| | | { |
| | | dynamic resultInfos = new ExpandoObject(); |
| | | resultInfos.tbBillList = m.GetList(); |
| | | return new ResponseResult |
| | | { |
| | | status = 0, |
| | | message = "OK", |
| | | data = resultInfos |
| | | }; |
| | | } |
| | | catch (Exception ex) |
| | | { |
| | | return ResponseResult.ResponseError(ex); |
| | | } |
| | | } |
| | | |
| | | |
| | | /// <summary> |
| | | /// æ ¹æ®ä¸»é®è·å |
| | | /// </summary> |
| | | /// <returns></returns> |
| | | [HttpPost("GetById")] |
| | | public ResponseResult GetById(int id) |
| | | { |
| | | try |
| | | { |
| | | dynamic resultInfos = new ExpandoObject(); |
| | | resultInfos.tbBillList = m.GetById(id); |
| | | return new ResponseResult |
| | | { |
| | | status = 0, |
| | | message = "OK", |
| | | data = resultInfos |
| | | }; |
| | | } |
| | | catch (Exception ex) |
| | | { |
| | | return ResponseResult.ResponseError(ex); |
| | | } |
| | | } |
| | | |
| | | /// <summary> |
| | | /// æ ¹æ®ä¸»é®å é¤ |
| | | /// </summary> |
| | | /// <returns></returns> |
| | | [HttpPost("DeleteByIds")] |
| | | public ResponseResult DeleteByIds([FromBody] object[] ids) |
| | | { |
| | | try |
| | | { |
| | | dynamic resultInfos = new ExpandoObject(); |
| | | resultInfos.tbBillList = m.DeleteByIds(ids); |
| | | return new ResponseResult |
| | | { |
| | | status = 0, |
| | | message = "OK", |
| | | data = resultInfos |
| | | }; |
| | | } |
| | | catch (Exception ex) |
| | | { |
| | | return ResponseResult.ResponseError(ex); |
| | | } |
| | | } |
| | | |
| | | /// <summary> |
| | | /// æ·»å |
| | | /// </summary> |
| | | /// <returns></returns> |
| | | [HttpPost("Insert")] |
| | | public ResponseResult Add([FromBody] Cgsq data) |
| | | { |
| | | try |
| | | { |
| | | dynamic resultInfos = new ExpandoObject(); |
| | | resultInfos.tbBillList = m.Insert(data); |
| | | return new ResponseResult |
| | | { |
| | | status = 0, |
| | | message = "OK", |
| | | data = resultInfos |
| | | }; |
| | | } |
| | | catch (Exception ex) |
| | | { |
| | | return ResponseResult.ResponseError(ex); |
| | | } |
| | | } |
| | | /// <summary> |
| | | /// æ·»å è¿åèªå¢ |
| | | /// </summary> |
| | | /// <returns></returns> |
| | | [HttpPost("InsertReturnIdentity")] |
| | | public ResponseResult InsertReturnIdentity([FromBody] Cgsq data) |
| | | { |
| | | try |
| | | { |
| | | dynamic resultInfos = new ExpandoObject(); |
| | | resultInfos.tbBillList = m.InsertReturnIdentity(data); |
| | | return new ResponseResult |
| | | { |
| | | status = 0, |
| | | message = "OK", |
| | | data = resultInfos |
| | | }; |
| | | } |
| | | catch (Exception ex) |
| | | { |
| | | return ResponseResult.ResponseError(ex); |
| | | } |
| | | } |
| | | |
| | | /// <summary> |
| | | /// ä¿®æ¹ |
| | | /// </summary> |
| | | /// <returns></returns> |
| | | [HttpPost("Update")] |
| | | public ResponseResult Update([FromBody] Cgsq data) |
| | | { |
| | | try |
| | | { |
| | | dynamic resultInfos = new ExpandoObject(); |
| | | resultInfos.tbBillList = m.Update(data); |
| | | return new ResponseResult |
| | | { |
| | | status = 0, |
| | | message = "OK", |
| | | data = resultInfos |
| | | }; |
| | | } |
| | | catch (Exception ex) |
| | | { |
| | | return ResponseResult.ResponseError(ex); |
| | | } |
| | | } |
| | | } |
| | | } |
| | |
| | | </PropertyGroup> |
| | | <PropertyGroup> |
| | | <ActiveDebugProfile>IIS Express</ActiveDebugProfile> |
| | | <NameOfLastUsedPublishProfile>E:\Tool\SG\StandardPda\MESApplication\Properties\PublishProfiles\FolderProfile.pubxml</NameOfLastUsedPublishProfile> |
| | | <NameOfLastUsedPublishProfile>C:\Users\qewqer\Desktop\MES\SG\StandardPda\MESApplication\Properties\PublishProfiles\FolderProfile.pubxml</NameOfLastUsedPublishProfile> |
| | | </PropertyGroup> |
| | | </Project> |
| | |
| | | --> |
| | | <Project> |
| | | <PropertyGroup> |
| | | <_PublishTargetUrl>E:\Tool\SG\StandardPda\MESApplication\bin\Release\net8.0\publish\</_PublishTargetUrl> |
| | | <History>True|2025-04-21T04:10:43.8803364Z||;True|2025-04-21T08:27:37.2394337+08:00||;True|2025-04-12T12:05:38.9937329+08:00||;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> |
| | | <_PublishTargetUrl>C:\Users\qewqer\Desktop\MES\SG\StandardPda\MESApplication\bin\Release\net8.0\publish\</_PublishTargetUrl> |
| | | <History>True|2025-06-18T01:47:48.5357496Z||;True|2025-06-17T13:53:55.5209159+08:00||;True|2025-06-17T11:08:10.7233967+08:00||;True|2025-06-17T10:48:28.8756667+08:00||;True|2025-06-10T09:07:47.8637042+08:00||;True|2025-06-05T10:50:28.9704970+08:00||;True|2025-06-04T11:12:37.7820473+08:00||;True|2025-06-04T10:40:36.9727573+08:00||;True|2025-06-04T09:08:36.9811358+08:00||;True|2025-06-03T09:11:10.9455312+08:00||;True|2025-06-02T19:49:37.3433823+08:00||;True|2025-06-02T19:45:06.8170643+08:00||;True|2025-06-02T19:33:16.6029887+08:00||;True|2025-06-02T17:37:59.2348839+08:00||;True|2025-05-30T18:48:45.3222297+08:00||;True|2025-05-28T19:29:45.5972248+08:00||;True|2025-05-07T09:38:52.4250140+08:00||;True|2025-04-21T12:10:43.8803364+08:00||;True|2025-04-21T08:27:37.2394337+08:00||;True|2025-04-12T12:05:38.9937329+08:00||;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> |
| | |
| | | </summary> |
| | | <returns></returns> |
| | | </member> |
| | | <member name="M:MESApplication.Controllers.MesBomMasterController.GetList"> |
| | | <summary> |
| | | è·åææ |
| | | </summary> |
| | | <returns></returns> |
| | | </member> |
| | | <member name="M:MESApplication.Controllers.MesBomMasterController.GetById(System.Int32)"> |
| | | <summary> |
| | | æ ¹æ®ä¸»é®è·å |
| | | </summary> |
| | | <returns></returns> |
| | | </member> |
| | | <member name="M:MESApplication.Controllers.MesBomMasterController.DeleteByIds(System.Object[])"> |
| | | <summary> |
| | | æ ¹æ®ä¸»é®å é¤ |
| | | </summary> |
| | | <returns></returns> |
| | | </member> |
| | | <member name="M:MESApplication.Controllers.MesBomMasterController.Add(MES.Service.Modes.MesBomMaster)"> |
| | | <summary> |
| | | æ·»å |
| | | </summary> |
| | | <returns></returns> |
| | | </member> |
| | | <member name="M:MESApplication.Controllers.MesBomMasterController.InsertReturnIdentity(MES.Service.Modes.MesBomMaster)"> |
| | | <summary> |
| | | æ·»å è¿åèªå¢ |
| | | </summary> |
| | | <returns></returns> |
| | | </member> |
| | | <member name="M:MESApplication.Controllers.MesBomMasterController.Update(MES.Service.Modes.MesBomMaster)"> |
| | | <summary> |
| | | ä¿®æ¹ |
| | | </summary> |
| | | <returns></returns> |
| | | </member> |
| | | <member name="M:MESApplication.Controllers.CgsqController.GetList"> |
| | | <summary> |
| | | è·åææ |
| | | </summary> |
| | | <returns></returns> |
| | | </member> |
| | | <member name="M:MESApplication.Controllers.CgsqController.GetById(System.Int32)"> |
| | | <summary> |
| | | æ ¹æ®ä¸»é®è·å |
| | | </summary> |
| | | <returns></returns> |
| | | </member> |
| | | <member name="M:MESApplication.Controllers.CgsqController.DeleteByIds(System.Object[])"> |
| | | <summary> |
| | | æ ¹æ®ä¸»é®å é¤ |
| | | </summary> |
| | | <returns></returns> |
| | | </member> |
| | | <member name="M:MESApplication.Controllers.CgsqController.Add(MES.Service.Modes.Cgsq)"> |
| | | <summary> |
| | | æ·»å |
| | | </summary> |
| | | <returns></returns> |
| | | </member> |
| | | <member name="M:MESApplication.Controllers.CgsqController.InsertReturnIdentity(MES.Service.Modes.Cgsq)"> |
| | | <summary> |
| | | æ·»å è¿åèªå¢ |
| | | </summary> |
| | | <returns></returns> |
| | | </member> |
| | | <member name="M:MESApplication.Controllers.CgsqController.Update(MES.Service.Modes.Cgsq)"> |
| | | <summary> |
| | | ä¿®æ¹ |
| | | </summary> |
| | | <returns></returns> |
| | | </member> |
| | | <member name="M:MESApplication.Controllers.MesRfPrnbarcodeController.GetList"> |
| | | <summary> |
| | | è·åææ |
| | |
| | | "SqlSugarCore": "5.1.4.169" |
| | | }, |
| | | "runtime": { |
| | | "MES.Service.dll": { |
| | | "assemblyVersion": "1.0.0", |
| | | "fileVersion": "1.0.0.0" |
| | | } |
| | | "MES.Service.dll": {} |
| | | } |
| | | }, |
| | | "Kingdee.CDP.WebApi.SDK/8.0.6.0": { |
| | |
| | | </summary> |
| | | <returns></returns> |
| | | </member> |
| | | <member name="M:MESApplication.Controllers.MesBomMasterController.GetList"> |
| | | <summary> |
| | | è·åææ |
| | | </summary> |
| | | <returns></returns> |
| | | </member> |
| | | <member name="M:MESApplication.Controllers.MesBomMasterController.GetById(System.Int32)"> |
| | | <summary> |
| | | æ ¹æ®ä¸»é®è·å |
| | | </summary> |
| | | <returns></returns> |
| | | </member> |
| | | <member name="M:MESApplication.Controllers.MesBomMasterController.DeleteByIds(System.Object[])"> |
| | | <summary> |
| | | æ ¹æ®ä¸»é®å é¤ |
| | | </summary> |
| | | <returns></returns> |
| | | </member> |
| | | <member name="M:MESApplication.Controllers.MesBomMasterController.Add(MES.Service.Modes.MesBomMaster)"> |
| | | <summary> |
| | | æ·»å |
| | | </summary> |
| | | <returns></returns> |
| | | </member> |
| | | <member name="M:MESApplication.Controllers.MesBomMasterController.InsertReturnIdentity(MES.Service.Modes.MesBomMaster)"> |
| | | <summary> |
| | | æ·»å è¿åèªå¢ |
| | | </summary> |
| | | <returns></returns> |
| | | </member> |
| | | <member name="M:MESApplication.Controllers.MesBomMasterController.Update(MES.Service.Modes.MesBomMaster)"> |
| | | <summary> |
| | | ä¿®æ¹ |
| | | </summary> |
| | | <returns></returns> |
| | | </member> |
| | | <member name="M:MESApplication.Controllers.CgsqController.GetList"> |
| | | <summary> |
| | | è·åææ |
| | | </summary> |
| | | <returns></returns> |
| | | </member> |
| | | <member name="M:MESApplication.Controllers.CgsqController.GetById(System.Int32)"> |
| | | <summary> |
| | | æ ¹æ®ä¸»é®è·å |
| | | </summary> |
| | | <returns></returns> |
| | | </member> |
| | | <member name="M:MESApplication.Controllers.CgsqController.DeleteByIds(System.Object[])"> |
| | | <summary> |
| | | æ ¹æ®ä¸»é®å é¤ |
| | | </summary> |
| | | <returns></returns> |
| | | </member> |
| | | <member name="M:MESApplication.Controllers.CgsqController.Add(MES.Service.Modes.Cgsq)"> |
| | | <summary> |
| | | æ·»å |
| | | </summary> |
| | | <returns></returns> |
| | | </member> |
| | | <member name="M:MESApplication.Controllers.CgsqController.InsertReturnIdentity(MES.Service.Modes.Cgsq)"> |
| | | <summary> |
| | | æ·»å è¿åèªå¢ |
| | | </summary> |
| | | <returns></returns> |
| | | </member> |
| | | <member name="M:MESApplication.Controllers.CgsqController.Update(MES.Service.Modes.Cgsq)"> |
| | | <summary> |
| | | ä¿®æ¹ |
| | | </summary> |
| | | <returns></returns> |
| | | </member> |
| | | <member name="M:MESApplication.Controllers.MesRfPrnbarcodeController.GetList"> |
| | | <summary> |
| | | è·åææ |
| | |
| | | "SqlSugarCore": "5.1.4.169" |
| | | }, |
| | | "runtime": { |
| | | "MES.Service.dll": { |
| | | "assemblyVersion": "1.0.0", |
| | | "fileVersion": "1.0.0.0" |
| | | } |
| | | "MES.Service.dll": {} |
| | | } |
| | | }, |
| | | "Kingdee.CDP.WebApi.SDK/8.0.6.0": { |
| | |
| | | </summary> |
| | | <returns></returns> |
| | | </member> |
| | | <member name="M:MESApplication.Controllers.MesBomMasterController.GetList"> |
| | | <summary> |
| | | è·åææ |
| | | </summary> |
| | | <returns></returns> |
| | | </member> |
| | | <member name="M:MESApplication.Controllers.MesBomMasterController.GetById(System.Int32)"> |
| | | <summary> |
| | | æ ¹æ®ä¸»é®è·å |
| | | </summary> |
| | | <returns></returns> |
| | | </member> |
| | | <member name="M:MESApplication.Controllers.MesBomMasterController.DeleteByIds(System.Object[])"> |
| | | <summary> |
| | | æ ¹æ®ä¸»é®å é¤ |
| | | </summary> |
| | | <returns></returns> |
| | | </member> |
| | | <member name="M:MESApplication.Controllers.MesBomMasterController.Add(MES.Service.Modes.MesBomMaster)"> |
| | | <summary> |
| | | æ·»å |
| | | </summary> |
| | | <returns></returns> |
| | | </member> |
| | | <member name="M:MESApplication.Controllers.MesBomMasterController.InsertReturnIdentity(MES.Service.Modes.MesBomMaster)"> |
| | | <summary> |
| | | æ·»å è¿åèªå¢ |
| | | </summary> |
| | | <returns></returns> |
| | | </member> |
| | | <member name="M:MESApplication.Controllers.MesBomMasterController.Update(MES.Service.Modes.MesBomMaster)"> |
| | | <summary> |
| | | ä¿®æ¹ |
| | | </summary> |
| | | <returns></returns> |
| | | </member> |
| | | <member name="M:MESApplication.Controllers.CgsqController.GetList"> |
| | | <summary> |
| | | è·åææ |
| | | </summary> |
| | | <returns></returns> |
| | | </member> |
| | | <member name="M:MESApplication.Controllers.CgsqController.GetById(System.Int32)"> |
| | | <summary> |
| | | æ ¹æ®ä¸»é®è·å |
| | | </summary> |
| | | <returns></returns> |
| | | </member> |
| | | <member name="M:MESApplication.Controllers.CgsqController.DeleteByIds(System.Object[])"> |
| | | <summary> |
| | | æ ¹æ®ä¸»é®å é¤ |
| | | </summary> |
| | | <returns></returns> |
| | | </member> |
| | | <member name="M:MESApplication.Controllers.CgsqController.Add(MES.Service.Modes.Cgsq)"> |
| | | <summary> |
| | | æ·»å |
| | | </summary> |
| | | <returns></returns> |
| | | </member> |
| | | <member name="M:MESApplication.Controllers.CgsqController.InsertReturnIdentity(MES.Service.Modes.Cgsq)"> |
| | | <summary> |
| | | æ·»å è¿åèªå¢ |
| | | </summary> |
| | | <returns></returns> |
| | | </member> |
| | | <member name="M:MESApplication.Controllers.CgsqController.Update(MES.Service.Modes.Cgsq)"> |
| | | <summary> |
| | | ä¿®æ¹ |
| | | </summary> |
| | | <returns></returns> |
| | | </member> |
| | | <member name="M:MESApplication.Controllers.MesRfPrnbarcodeController.GetList"> |
| | | <summary> |
| | | è·åææ |