/// <summary>
/// 获取销售统计的汇总信息
/// </summary>
/// <param name="AllPeopleNum">总人数</param>
/// <param name="AllFinanceSum">总金额</param>
/// <param name="QueryModel">查询实体</param>
/// <param name="us">用户信息集合</param>
public void GetSumSalesStatistics(ref int AllPeopleNum, ref decimal AllFinanceSum
, Model.StatisticStructure.MQuerySalesStatistics QueryModel, string us)
{
if (QueryModel == null || QueryModel.CompanyId <= 0)
{
return;
}
string strSql = " select sum(PeopleNumber) as PeopleNumber,sum(FinanceSum) as FinanceSum from [View_SalesStatistics] ";
string strWhere = this.GetSqlWhere(QueryModel, us);
if (!string.IsNullOrEmpty(strWhere))
{
strSql += " where 1 = 1 and " + strWhere;
}
DbCommand dc = this._db.GetSqlStringCommand(strSql);
using (IDataReader dr = DbHelper.ExecuteReader(dc, this._db))
{
if (dr.Read())
{
if (!dr.IsDBNull(0))
{
AllPeopleNum = dr.GetInt32(0);
}
if (!dr.IsDBNull(1))
{
AllFinanceSum = dr.GetDecimal(1);
}
}
}
}
/// <summary>
/// 获取销售统计的汇总信息
/// </summary>
/// <param name="AllPeopleNum">总人数</param>
/// <param name="AllFinanceSum">总金额</param>
/// <param name="QueryModel">查询实体</param>
public void GetSumSalesStatistics(ref int AllPeopleNum, ref decimal AllFinanceSum
, Model.StatisticStructure.MQuerySalesStatistics QueryModel)
{
if (QueryModel == null || QueryModel.CompanyId <= 0)
{
return;
}
dal.GetSumSalesStatistics(ref AllPeopleNum, ref AllFinanceSum, QueryModel, HaveUserIds);
}
/// <summary>
/// 获取销售统计列表
/// </summary>
/// <param name="PageSize">每页记录数</param>
/// <param name="PageIndex">当前页数</param>
/// <param name="RecordCount">总记录数</param>
/// <param name="QueryModel">查询实体</param>
/// <returns></returns>
public IList <Model.StatisticStructure.MSalesStatistics> GetSalesStatistics(int PageSize, int PageIndex
, ref int RecordCount, Model.StatisticStructure.MQuerySalesStatistics QueryModel)
{
if (QueryModel == null || QueryModel.CompanyId <= 0)
{
return(null);
}
return(dal.GetSalesStatistics(PageSize, PageIndex, ref RecordCount, QueryModel, HaveUserIds));
}
