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);
|
}
|
}
|
}
|
