using Models;
using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace DAL
{
    public class grouopExceedViewService
    {
        /// <summary>
        /// 查询所有
        /// </summary>
        /// <param name="sql">sql语句</param>
        /// <param name="param">可变参数数组</param>
        /// <returns>返回集合</returns>
        List<grouopExceedView> excuteSql(string sql, params SqlParameter[] param)
        {
            return ServiceBase<grouopExceedView>.excuteSql(new grouopExceedView(), "grouopExceedView", sql, CommandType.Text, param);
        }
        /// <summary>
        /// 根据diid查询超支导出数据
        /// </summary>
        /// <param name="id">对象编号</param>
        /// <returns>返回空或者单个对象信息</returns>
        public List<grouopExceedView> GetGrouopExceedByDiId(int DiId)
        {
            //调用获取单个对象的方法
            return excuteSql("select d.TeamName,g.operatorsDate,g.PriceType,g.PriceName,g.Coefficient,g.Price,(select Name from SetData where g.currency=id) as Currency,c.DayRate,c.RMBPrice,g.remark from grouopExceed g left join CreditCardPayment c on g.id=c.CId and c.CTable=805 left join DelegationInfo d on g.DIID=d.Id where g.IsDel=0 and g.DIID=@DiId", new SqlParameter("@DiId", DiId));
        }
    }
}