using Sugar.Enties;
using SqlSugar;
using System;
using System.Collections.Generic;

/// <summary>
/// 供应商扩展申请管理类
/// </summary>
public  class zzSupplierExManager : DbContext<zzSupplierEx>
{
    /// <summary>
    /// 根据供应商编号获取其对应所有项目
    /// </summary>
    /// <param name="supplierCode"></param>
    /// <returns></returns>
    public List<Project> GetProjectBySupplierCode(string supplierCode)
    {
        //通过供应商编号查询其签下的所有合同。根据合同查询其对应的项目
        var sql = $"SELECT * FROM project WHERE ProjectCode IN (SELECT ProjectCode  FROM dbo.Contract  WHERE SupplierCode='{supplierCode}' GROUP BY ProjectCode)";
        var list = Db.Ado.SqlQuery<Project>(sql);
        return list;
    }

    public List<zzSupplierExDTO> GetzzSupplierExDTOList(string supplierCode)
    {
        var sql = $"SELECT a.*,b.ProjectName FROM dbo.zzSupplierEx a INNER JOIN dbo.Project b ON a.ProjectCode=b.ProjectCode where a.supplierCode='{supplierCode}' order by a.createdate desc  ";
        var list = Db.Ado.SqlQuery<zzSupplierExDTO>(sql);
        return list;
    }

}