/// <summary>

/// 医疗版块运营数据(标准化)-各医院每日运营数据汇总

/// </summary>

[SugarTable("hospital_operation_day", TableDescription = "医疗版块运营数据(标准化)-各医院每日运营数据汇总")]

[Tenant(SqlSugarConst.DB_MainConfigId)]

//普通索引

[SugarIndex("unique_hospital_operation_day_rq", nameof(F_Rq), OrderByType.Desc)]

[SugarIndex("unique_hospital_operation_day_companyuuid", nameof(F_Company_Uuid), OrderByType.Desc)]

public class HospitalOperationDayDataEntity : HospitalOperationBaseDataEntity

{

    /// <summary>

    /// 日期

    /// </summary>

    [SugarColumn(IsPrimaryKey = true, ColumnName = "f_rq", Length = 10, ColumnDescription = "主键，日期")]

    public string F_Rq { get; set; }

    /// <summary>

    /// 所属企业uuid

    /// </summary>

    [SugarColumn(IsPrimaryKey = true, ColumnName = "f_company_uuid", Length = 50, ColumnDescription = "主键，所属企业uuid")]

    public string F_Company_Uuid { get; set; }

    /// <summary>

    /// 门诊总收入-门诊药品收入

    /// </summary>

    [SugarColumn(ColumnName = "f_mzypsr", DecimalDigits = 6, ColumnDescription = "门诊总收入-门诊药品收入")]

    public decimal? F_Mzypsr { get; set; } = 0;

}

//大数据保存（插入或者更新）

await db.Fastest<HospitalOperationDayDataEntity>().PageSize(50000).BulkMergeAsync(groupMzypsrData, x => new { x.F_Rq, x.F_Company_Uuid }, x => new { x.F_Mzypsr });

使用pgsql，生成的语句为：UPDATE  "hospital_operation_day"    SET "F_Mzypsr"=TE."F_Mzypsr"  FROM   mytemptable  AS TE  WHERE "hospital_operation_day"."f_rq"=TE."f_rq" AND "hospital_operation_day"."f_company_uuid"=TE."f_company_uuid"

出错了