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