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();
}
}
