using Kingdee.BOS;
using Kingdee.BOS.ServiceHelper;
using XhOA.Extension;
using XhOA.Models;
using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Text;
using System.Threading.Tasks;


namespace XhOA.DBService
{
    public class BigTicketProjectService
    {
       
        public decimal GetReceiveBillRate(Context ctx, long proId)
        {
            string sql = $"select t2.F_PXDF_Decimal from  t_AR_receivable t1 left join t_AR_receivableEntry t2 on t1.fid=t2.fid where t1.fdocumentstatus='C' and t2.FProjectNo='{proId}' ";
            //LogHelper.Info("GetReceiveBillRate:" + sql);
            return DBServiceHelper.ExecuteScalar(ctx, sql, 0);
        }
    }
}