//获取当前时间
var NewDates = System.DateTime.Now.ToString("d");
/多表查询
string v1 = busiessesRepositiry.Select.From<BdSLLPlanEntity, SjCampaignEntity>((b, p, c) => b
.InnerJoin(b => b.Id == p.PlanId && b.BusiessesDeleMoneyTime.ToString("d") == NewDates && b.DayIsDeleMoney == false)
.InnerJoin(b => p.CampaignName == c.campaignName)).ToSql();
#多表语句对应的sql
SELECT a.`Id`, a.`CreatedUserId`, a.`CreatedUserName`, a.`CreatedTime`, a.`ModifiedUserId`, a.`ModifiedUserName`, a.`ModifiedTime`, a.`IsDeleted`, a.`TenantId`, a.`Name`, a.`BusiessesName`, a.`BusiessesID`, a.`BusiessesMoney`, a.`BusiessesFrozenMoney`, a.`BusiessesServeMoney`, a.`BusiessesNote`, a.`BusiessesBaidu`, a.`BusiessesSll`, a.`BusiessesUser`, a.`BusiessesPwd`, a.`BusiessesDeleMoneyTime`, a.`BusiessesZServeMoney`, a.`BusiessesZServeNum`, a.`DayIsDeleMoney`
FROM `app_Busiesses` a INNER JOIN `app_Plan` p ON a.`Id` = p.`PlanId` AND a.`DayIsDeleMoney` = 0 INNER JOIN `app_Campaign` c ON p.`CampaignName` = c.`campaignName`