public override void ImportAmasisData() { const string strSql = "SELECT RTRIM(R.PROTCOD) NAME,RTRIM(R.PROTLIB) DESCRIPTION FROM AMSFCSCVAL.FMPROT R"; using (var conn = new Db2Conn(GetDb2Connection())) { AmasisDatas = conn.GetSqlDatas<AircraftSeriesDTO>(strSql); } }
public override void ImportAmasisData() { const string strSql = "SELECT 1 as ID,RTRIM(KXLIBELLE) NAME,RTRIM(KXPOSAV) ITEMNO,RTRIM(KXFIN) FINUMBER, 1 ISLIFE,RTRIM(KXLIBELLE) DESCRIPTION FROM AMSFCSCVAL.FRKXS"; using (var conn = new Db2Conn(GetDb2Connection())) { AmasisDatas = conn.GetSqlDatas<Item>(strSql).ToList(); } }
public override void ImportAmasisData() { const string strSql = "SELECT RTRIM(P.NMPN) PN,RTRIM(P.NMATA) ATA,RTRIM(P.NMCODFAB) VENDOR,RTRIM(P.NMDESIGN) DESCRIPTION," + "RTRIM(P.NMCODTYPM) FROM AMSFCSCVAL.FRNMPF P WHERE P.NMCODTYPM != '1'"; using (var conn = new Db2Conn(GetDb2Connection())) { AmasisDatas = conn.GetSqlDatas<PnRegDTO>(strSql); } }
public override void ImportAmasisData() { const string strSql = "SELECT RTRIM(SN.PSPN) PN,RTRIM(SN.PSSN) SN,RTRIM(SN.PSNUMAP) SERIALNUMBER, RTRIM(AC.AVIMMATR) REGNUMBER,SN.PSCODSIT STATUS,DATE(RTRIM(SN.PSA4)||'-'||RTRIM(SN.PSMM)||'-'||RTRIM(SN.PSJJ)) LATESTREMOVEDATE,SN.PSCSN CSN,SN.PSCSO CSO,SN.PSTSN TSN,SN.PSTSO TSO,AT.ATACD ATA FROM AMSFCSCVAL.FRPS AS SN " + " LEFT JOIN AMSFCSCVAL.FRAV AS AC ON AC.AVNUMAP=SN.PSNUMAP LEFT JOIN AMSFCSCVAL.FRNMPF PN ON RTRIM(SN.PSPN)=RTRIM(PN.NMPN) LEFT JOIN AMSFCSCVAL.FRATA AS AT ON AT.ATACD=PN.NMATA WHERE Pn.NMCODTYPM != '1' AND Pn.NMATA <'81' AND Pn.NMATA >='70'"; using (var conn = new Db2Conn(GetDb2Connection())) { AmasisDatas = conn.GetSqlDatas<PartSn>(strSql); } }
public override void ImportAmasisData() { const int step = 1; const string strSql = "SELECT RTRIM(A.AVSN) MSN,RTRIM(A.AVNUMAP) SN,RTRIM(A.AVOFFICIEL) ACREG,LOG.AVHVAB TotalFH,LOG.AVHVBB TotalBH," + " LOG.AVCY TotalCycles,LOG.RMCPT1F ApuMM,LOG.RMCPT2F ApuCycle,LEG.RMA4 FD_YEAR,LEG.RMMM FD_MONTH,LEG.RMJJ FD_DAY," + " Date(RTRIM(LEG.RMA4)||'-'||RTRIM(LEG.RMMM)||'-'||RTRIM(LEG.RMJJ)) FlightDate," + " RTRIM(LEG.RMDOC) LOGNO,RTRIM(LEG.VOORD) LEGNO,RTRIM(LEG.VOVOLNUM) FlightNum,RTRIM(LEG.VOAERODEP) DepartureAirport,RTRIM(LEG.VOBBDEP) BlockOn," + " RTRIM(LEG.VOABDEP) TakeOff,RTRIM(LEG.VOAEROARR) ArrivalAirport,RTRIM(LEG.VOABARR) Landing,RTRIM(LEG.VOBBARR) BlockStop,1 AS Cycle," + " LEG.VOTOGO ToGoNumber,RTRIM(LEG.VOABTPS) FH_HHMM,RTRIM(LEG.VOABTPSC) FlightHours,RTRIM(LEG.VOBBTPS) BLOCK_HHMM,RTRIM(LEG.VOBBTPSC) BlockHours," + " LEG.VOOILMO1D ENG1OilDep,LEG.VOOILMO1A ENG1OilArr,LEG.VOOILMO2D ENG2OilDep,LEG.VOOILMO2A ENG2OilArr,LEG.VOOILAPUD ApuOilDep," + " LEG.VOOILAPUA ApuOilArr FROM AMSFCSCVAL.FRVO AS LEG LEFT JOIN AMSFCSCVAL.FRRM AS LOG ON LEG.AVNUMAP = LOG.AVNUMAP AND LEG.RMDOC = LOG.RMDOC Left join" + " AMSFCSCVAL.FRAV A ON LEG.AVNUMAP=A.AVNUMAP"; var queryConditionForSeveralDays = " WHERE A.AVNUMAP = LEG.AVNUMAP AND (Char(Date(RTRIM(LEG.RMA4)||'-'||RTRIM(LEG.RMMM)||'-'||RTRIM(LEG.RMJJ)))> Char(current date -" + step + " MONTH))" + " ORDER by AcReg,FlightDate desc,TotalFH desc "; QueryStr = strSql + queryConditionForSeveralDays; using (var conn = new Db2Conn(GetDb2Connection())) { AmasisDatas = conn.GetSqlDatas<FlightLog>(QueryStr).ToList(); } }
public void GetPnRegFromAmasis() { const string strSql = "SELECT RTRIM(NMPN) PN,RTRIM(NMDESIGN) DESCRIPTION FROM AMSFCSCVAL.FRNMPF WHERE NMATA <'81' AND NMATA >='70'"; using (var conn = new Db2Conn(GetDb2Connection())) { AmasisDatas = conn.GetSqlDatas<PartPn>(strSql); } }
public void GetSnHistoryFromAmasis() { //依照AMASIS中的拆装类型来换分,拆下的类型mpcodtdoc包括:X3,X6,TODO:川航提供相应的信息之后,待完善 const string strSqlForRemoval = "select mp.pspn PN,mp.pssn SN,Date(RTRIM(mp.mpA4)||'-'||RTRIM(mp.mpMM)||'-'||RTRIM(mp.mpJJ)) MOVEmentDATE,mp.mpnumdoc1||mp.mpnumdoc2 ACtionNo,AC.AVIMMATR REGNUMBER,mp.mpcodtdoc DocType,parm.parlib DOCDescription,mp.mpcodtop MOVEType,mv.mvtlib Description,mp.Usrcre CreateDate,mp.HEucre CreateTIme,mp.DatMaj UpdateDate,mp.HEUMAJ updateTIme from amsfcscval.frmp mp left join mglg091561.frmvl as mv on mv.mvtcod=mp.mpcodtop left join mglg091561.ifrparm as parm on mp.mpcodtdoc=parm.parfic and parm.parnom='MVTDOC' left join AMSFCSCVAL.FRBOPF AS P ON mp.mpNUMDOC1=P.BONUMDOC1 AND mp.mpNUMDOC2=P.BONUMDOC2 LEFT JOIN AMSFCSCVAL.FRAV AS AC ON P.BONUMAP=AC.AVNUMAP WHERE P.BOCODMM<='80' AND P.BOCODMM>='70' ORDER BY MPNUMDOC2;"; //依照AMASIS中的拆装类型来换分,装机相关的移动类型mpcodtdoc包括:Y1,TODO:川航提供相应的信息之后,待完善 const string strSqlForInstallation = "select mp.pspn PN,mp.pssn SN,Date(RTRIM(mp.mpA4)||'-'||RTRIM(mp.mpMM)||'-'||RTRIM(mp.mpJJ)) MOVEmentDATE,mp.mpnumdoc1||mp.mpnumdoc2 ACtionNo,AC.AVIMMATR REGNUMBER,mp.mpcodtdoc DocType,parm.parlib DOCDescription,mp.mpcodtop MOVEType,mv.mvtlib Description,mp.Usrcre CreateDate,mp.HEucre CreateTIme,mp.DatMaj UpdateDate,mp.HEUMAJ updateTIme from amsfcscval.frmp mp left join mglg091561.frmvl as mv on mv.mvtcod=mp.mpcodtop left join mglg091561.ifrparm as parm on mp.mpcodtdoc=parm.parfic and parm.parnom='MVTDOC' left join AMSFCSCVAL.FRBOPF AS P ON mp.mpNUMDOC1=P.BONUMDOC1 AND mp.mpNUMDOC2=P.BONUMDOC2 LEFT JOIN AMSFCSCVAL.FRAV AS AC ON P.BONUMAP=AC.AVNUMAP WHERE P.BOCODMM<='80' AND P.BOCODMM>='70' ORDER BY MPNUMDOC2;"; using (var conn = new Db2Conn(GetDb2Connection())) { Removals = conn.GetSqlDatas<Movement>(strSqlForRemoval).ToList(); Installations = conn.GetSqlDatas<Movement>(strSqlForInstallation).ToList(); } }
public override void ImportAmasisData() { const string strSql = @"SELECT RTRIM(P.BONUMDOC1)||RTRIM(P.BONUMDOC2) ACTIONNO,RTRIM(K.KXLIBELLE) POSITION,RTRIM(AC.AVOFFICIEL) REGNUMBER FROM AMSFCSCVAL.FRBOPF AS P LEFT JOIN AMSFCSCVAL.FRAV AC ON P.BONUMAP=AC.AVNUMAP LEFT JOIN AMSFCSCVAL.FRKXS AS K ON P.BOPOSAV=K.KXPOSAV WHERE P.BOCODMM<='80' AND P.BOCODMM>='70';"; using (var conn = new Db2Conn(GetDb2Connection())) { AmasisDatas = conn.GetSqlDatas<SnRemInstRecordDTO>(strSql).ToList(); } }