private IDictionary<string, decimal> GetPaymentDictionary(N_Order_QuoteInfo ContractInfo, N_Order_QuoteEx OwnerInfo, decimal ProCost, string stringFormat = @"f2")
{
List<Payment> PaymentList = base.GetPaymentList(ContractInfo, OwnerInfo, decimal.Parse(this.ProCost));
IDictionary<string, decimal> dictionary = base.GetPaymentDictionary(PaymentList);
return dictionary;
}
/// <summary>
/// 获取工程款列表
/// </summary>
protected List<Payment> GetPaymentList(N_Order_QuoteInfo ContractInfo, N_Order_QuoteEx OwnerInfo, decimal ProCost)
{
List<Payment> PaymentList = new List<Payment>();
string sqlWhere = " and SRCTAB.IsDel=0 and psd.IsDel=0 and SRCTAB.SchemeCategory=1 and SRCTAB.status=1 and psi.IsDel=0 ";
if (ContractInfo.SuitID == 0)
{
sqlWhere += " and SRCTAB.SchemeType=1";
}
if (ContractInfo.SuitID > 0)
{
sqlWhere += " and SRCTAB.SchemeType=0";
}
List<ORM.Base.QueryResult> qres = new List<ORM.Base.QueryResult>();
EBS.Interface.Model.N_Payment_SchemeInfo psi = new Interface.Model.N_Payment_SchemeInfo();
qres = psi.LEFT_JOIN(EBS.Interface.Model.N_Payment_SchemeDetail.TableInfo, "psd", "SRCTAB.id = psd.SchemeId").LEFT_JOIN(EBS.Interface.Model.N_Payment_SchemeItem.TableInfo, "psi", "psd.ID = psi.DetailId").Where("SRCTAB.CityID=@cityid " + sqlWhere, new object[] { OwnerInfo.CityID }).List("psi.OrderStateCode,psi.sort asc");
//若无该城市收款配置，则使用全国收款配置 cityid=0
if (qres.Count <= 0)
{
psi = new Interface.Model.N_Payment_SchemeInfo();
qres = new List<ORM.Base.QueryResult>();
qres = psi.LEFT_JOIN(EBS.Interface.Model.N_Payment_SchemeDetail.TableInfo, "psd", "SRCTAB.id = psd.SchemeId ").LEFT_JOIN(EBS.Interface.Model.N_Payment_SchemeItem.TableInfo, "psi", "psd.ID = psi.DetailId").Where("SRCTAB.CityID=@cityid " + sqlWhere, new object[] { 0 }).List("psi.OrderStateCode,psi.sort asc");
}
foreach (var item in qres)
{
var psiinfo = item.Get<EBS.Interface.Model.N_Payment_SchemeItem>();
PaymentList.Add(new Payment()
{
StateCode = psiinfo.OrderStateCode,
StateName = psiinfo.OrderStateName,
Rate = psiinfo.Rate,
Money = ProCost * psiinfo.Rate
});
}
return PaymentList;
}
/// <summary>
/// 合同预览，取数据表时间
/// </summary>
/// <param name="ContractInfo">The contract information.</param>
public void SetPreviewConstructionContractDate(N_Order_QuoteInfo ContractInfo)
{
if (ContractInfo != null && !ContractInfo.ConstructionContractingTime.Equals(DateTime.Parse("1900/1/1")))
{
this.SetConstructionContractDate(ContractInfo.ConstructionContractingTime);
}
}
protected string GetContractValidity(N_Order_QuoteInfo ContractInfo)
{
DateTime endDate = ContractInfo.DesignContractingTime.Year == 1900 ? DateTime.Parse("1900-01-01") : ContractInfo.DesignContractingTime.AddMonths(2);
StringBuilder ContractValidity = new StringBuilder();
ContractValidity.Append(ContractInfo.DesignContractingTime.ToLongDateString());
ContractValidity.Append("至");
ContractValidity.Append(endDate.ToLongDateString());
return ContractValidity.ToString();
}