c#Linqleftjoin多个条件连接查询
如下面的sql用查询表达式怎么写?
SELECTA.*,B.ITEM_NAMEASMoneyType_DESC,C.ITEM_NAMEASPayMentType_DESC,D.ITEM_NAMEASApplyType_DESC
FROMDFZFORMT055A
LEFTJOINFM_CODE_LISTBONA.MoneyType=B.ITEM_VALUEANDB.FORM_KIND='DFZ.FORM.T055'ANDB.FIELD_NAME='MoneyType'
LEFTJOINFM_CODE_LISTCONA.PayMentType=C.ITEM_VALUEANDC.FORM_KIND='DFZ.FORM.T055'ANDC.FIELD_NAME='PayMentType'
LEFTJOINFM_CODE_LISTDONA.APPLYTYPE=D.ITEM_VALUEANDD.FORM_KIND='DFZ.FORM.T055'ANDD.FIELD_NAME='ApplyType'
WHEREA.form_no=9
自己搞定了,还是要谢谢w362435819和fansui1983
varquery=fromMainTableinT055
joinBin(fromcodelistinCODELISTwherecodelist.FORM_KIND=="DFZ.FORM.T055"&&codelist.ITEM_NAME=="MoneyType"selectcodelist)
onMainTable.MoneyTypeequalsB.ITEM_VALUEintoB_Join
fromBBinB_Join.DefaultIfEmpty()
joinCin(fromcodelistinCODELIST2wherecodelist.FORM_KIND=="DFZ.FORM.T055"&&codelist.ITEM_NAME=="PayMentType"selectcodelist)
onMainTable.PayMentTypeequalsC.ITEM_VALUEintoC_Join
fromCCinC_Join.DefaultIfEmpty()
joinDin.
whereMainTable.FORM_NO==m_intFormNo