SqlSugar 直接执行sql脚本两种方式

纪寻川

已于 2023-08-14 10:33:30 修改

阅读量2.1k

点赞数

文章标签： sql java 前端

于 2023-08-14 10:31:14 首次发布

本文链接：https://blog.csdn.net/m0_37781450/article/details/132270866

版权

方式一：

string sql = $"select * from statistics_driver_daily_data where user_id={userId} and YEARWEEK(Time,1)=YEARWEEK('{input.Date}',1) ORDER BY TIME ;";

List<DriverDailyData> datas = _dddRep.ToListBySql(sql);

//底层方法：

/// <summary>
/// 执行Sql查询
/// </summary>
/// <param name="sql"></param>
/// <returns></returns>
public List<TEntity> ToListBySql(string sql)
{
    return Ado.SqlQuery<TEntity>(sql);
}

方法二：

string incomeSumSqlStr = $"select sum(payment_amount)as incomesum from order_info where driver_id in(select user_id from core_driver where merchant_id='{merchantId}' and is_delete=0 ) and is_delete=0";
using (var db = DbContext.GetInstance())
{
    var IncomeSumDt = db.Ado.GetDataTable(incomeSumSqlStr);
    if (IncomeSumDt != null)
    result.IncomeSum = Convert.ToDecimal(IncomeSumDt.Rows[0]["incomesum"] + "" == "" ? 0 : IncomeSumDt.Rows[0]["incomesum"]);
}

//底层方法
public class DbContext
{
    public static SqlSugarClient GetInstance()
    {
        var connectionStr = App.GetConfig<List<ConnectionConfig>>("ConnectionStrings:Sqlsugar")[0].ConnectionString;
        SqlSugarClient db = new SqlSugarClient(new ConnectionConfig() { ConnectionString = connectionStr, DbType = DbType.MySql, IsAutoCloseConnection = true });
        db.Ado.IsEnableLogEvent = true;
        return db;
    }
}