using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace BLL
{
    public class CPTListService
    {
        /// <summary>
        /// 根据合同号获取NetValue和
        /// </summary>
        /// <param name="fo"></param>
        /// <returns></returns>
        public static decimal? getSumNetValueByFo(string fo)
        {
            return (from x in Funs.DB.SESList
                    join y in Funs.DB.CPTList on x.CPT_No equals y.CPT_No
                    where y.Contract_No == fo
                    select x.Net_Value).Sum();
        }
    }
}