/// <summary>
/// 通过编号获取财务统计表明细
/// </summary>
/// <param name="SysNo"></param>
/// <returns></returns>
public override Model.FinancialStatistics.CBFnStatistics GetCBFnStatisticMod(int SysNo)
{
string sql = "select * from FnStatistics where SysNo = '" + SysNo + "'";
Hyt.Model.FinancialStatistics.CBFnStatistics cbStatisticMod =
Context.Sql(sql).QuerySingle <Model.FinancialStatistics.CBFnStatistics>();
cbStatisticMod.SaleOrSpendList = GetCBFnSalesOrSpendStatistics(SysNo);
return(cbStatisticMod);
}
public override CBFnStatistics GetCBFnStatisticMod(DateTime dateTime)
{
string sql = "select * from FnStatistics where year(BindTime) = " + dateTime.Year
+ " and MONTH(BindTime) = " + dateTime.Month + " ";
Hyt.Model.FinancialStatistics.CBFnStatistics cbStatisticMod =
Context.Sql(sql).QuerySingle <Model.FinancialStatistics.CBFnStatistics>();
if (cbStatisticMod != null)
{
cbStatisticMod.SaleOrSpendList = GetCBFnSalesOrSpendStatistics(cbStatisticMod.SysNo);
}
return(cbStatisticMod);
}