FreeSql用连表查询

最新推荐文章于 2024-03-25 16:28:52 发布

slilx

最新推荐文章于 2024-03-25 16:28:52 发布

阅读量339

点赞数

文章标签： c# 后端 mysql

本文链接：https://blog.csdn.net/slilx/article/details/132598887

版权

//获取当前时间
            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`