string sql = @"select x.*,y.shoufeijine as sfxm_shoufeijine,y.leixing as sfxm_leixing,y.sfxm_dic_id,y.sfxm_dic_value as sfxm_dic_name,y.shoufeimingcheng as sfxmName from YlyShoufeiModuleMx x left join (select a.*,b.DictValue as sfxm_dic_value from YlyShouofeixiangmu a
left join (select * from SysDataDictDetail where DictType='sfxmgl') b on a.sfxm_dic_id=b.DictKey) y on x.sfxmId=y.Id where 1=1 ";
//var _list = await this.BaseRepository().FindList<ShoufeiModuleMxEntity>(sql + whereSql + orderStr);
var dbConnection = ef.Database.GetDbConnection();
var reader = await new DbHelper(ef, dbConnection).ExecuteReadeAsync(CommandType.Text, sql + whereSql + orderStr);
List<ShoufeiModuleMxEntity> list = DatabasesExtension.IDataReaderToList<ShoufeiModuleMxEntity>(reader);