statistics.cs

动易SiteFactory&#8482 网上商店系统1.0源代码

                    item.SubTotal = reader.GetDecimal("SubTotal");
                    list.Add(item);
                }
            }
            this.m_TotalOfMemberOrderliness = (int) database.GetParameterValue(storedProcCommand, "@Total");
            return list;
        }

        public IList<MemberOrdersInfo> GetMemberOrdersList(int startRowIndexId, int maxNumberRows)
        {
            Database database = DatabaseFactory.CreateDatabase();
            DbCommand storedProcCommand = database.GetStoredProcCommand("PR_Shop_Statistics_GetList");
            database.AddInParameter(storedProcCommand, "@StartRows", DbType.Int32, startRowIndexId);
            database.AddInParameter(storedProcCommand, "@PageSize", DbType.Int32, maxNumberRows);
            database.AddInParameter(storedProcCommand, "@SortColumn", DbType.String, "COUNT(O.OrderID)");
            database.AddInParameter(storedProcCommand, "@StrColumn", DbType.String, "Max(U.UserName) as UserName, COUNT(O.OrderID) AS OrderCount");
            database.AddInParameter(storedProcCommand, "@Sorts", DbType.String, "DESC");
            database.AddInParameter(storedProcCommand, "@TableName", DbType.String, "PE_Users AS U INNER JOIN  PE_Orders AS O ON O.UserName = U.UserName");
            database.AddInParameter(storedProcCommand, "@Filter", DbType.String, "(O.Status <> 3) and O.MoneyReceipt >= O.MoneyTotal");
            database.AddInParameter(storedProcCommand, "@ID", DbType.String, "U.UserID");
            database.AddInParameter(storedProcCommand, "@Group", DbType.String, "GROUP BY U.UserID");
            database.AddOutParameter(storedProcCommand, "@Total", DbType.Int32, maxNumberRows);
            IList<MemberOrdersInfo> list = new List<MemberOrdersInfo>();
            using (NullableDataReader reader = new NullableDataReader(database.ExecuteReader(storedProcCommand)))
            {
                while (reader.Read())
                {
                    MemberOrdersInfo item = new MemberOrdersInfo();
                    item.UserName = reader.GetString("UserName");
                    item.OrderNum = reader.GetInt32("OrderCount");
                    list.Add(item);
                }
            }
            this.m_TotalOfMemberOrders = (int) database.GetParameterValue(storedProcCommand, "@Total");
            return list;
        }

        public IList<ProductHitsInfo> GetProductHitsList(int startRowIndexId, int maxNumberRows)
        {
            Database database = DatabaseFactory.CreateDatabase();
            DbCommand storedProcCommand = database.GetStoredProcCommand("PR_Shop_Statistics_GetList");
            database.AddInParameter(storedProcCommand, "@StartRows", DbType.Int32, startRowIndexId);
            database.AddInParameter(storedProcCommand, "@PageSize", DbType.Int32, maxNumberRows);
            database.AddInParameter(storedProcCommand, "@SortColumn", DbType.String, "M.Hits");
            database.AddInParameter(storedProcCommand, "@StrColumn", DbType.String, "P.ProductName,M.Hits");
            database.AddInParameter(storedProcCommand, "@Sorts", DbType.String, "DESC");
            database.AddInParameter(storedProcCommand, "@TableName", DbType.String, "PE_CommonProduct P inner join PE_CommonModel M on P.TableName = M.TableName and P.ProductID = M.ItemID");
            database.AddInParameter(storedProcCommand, "@Filter", DbType.String, "P.ProductType<>4 and M.LinkType = 0 and M.Hits<>0");
            database.AddInParameter(storedProcCommand, "@ID", DbType.String, "P.ProductID");
            database.AddInParameter(storedProcCommand, "@Group", DbType.String, "");
            database.AddOutParameter(storedProcCommand, "@Total", DbType.Int32, maxNumberRows);
            IList<ProductHitsInfo> list = new List<ProductHitsInfo>();
            using (NullableDataReader reader = new NullableDataReader(database.ExecuteReader(storedProcCommand)))
            {
                while (reader.Read())
                {
                    ProductHitsInfo item = new ProductHitsInfo();
                    item.ProductName = reader.GetString("ProductName");
                    item.Hits = reader.GetInt32("Hits");
                    list.Add(item);
                }
            }
            this.m_TotalOfProductHits = (int) database.GetParameterValue(storedProcCommand, "@Total");
            return list;
        }

        public IList<ProductOrderNumberInfo> GetProductOrderNumberList(int startRowIndexId, int maxNumberRows)
        {
            Database database = DatabaseFactory.CreateDatabase();
            DbCommand storedProcCommand = database.GetStoredProcCommand("PR_Shop_Statistics_GetList");
            database.AddInParameter(storedProcCommand, "@StartRows", DbType.Int32, startRowIndexId);
            database.AddInParameter(storedProcCommand, "@PageSize", DbType.Int32, maxNumberRows);
            database.AddInParameter(storedProcCommand, "@SortColumn", DbType.String, "OrderNum");
            database.AddInParameter(storedProcCommand, "@StrColumn", DbType.String, "ProductName, OrderNum");
            database.AddInParameter(storedProcCommand, "@Sorts", DbType.String, "DESC");
            database.AddInParameter(storedProcCommand, "@TableName", DbType.String, "PE_CommonProduct");
            database.AddInParameter(storedProcCommand, "@Filter", DbType.String, "OrderNum > 0");
            database.AddInParameter(storedProcCommand, "@ID", DbType.String, "ID");
            database.AddInParameter(storedProcCommand, "@Group", DbType.String, "");
            database.AddOutParameter(storedProcCommand, "@Total", DbType.Int32, maxNumberRows);
            IList<ProductOrderNumberInfo> list = new List<ProductOrderNumberInfo>();
            using (NullableDataReader reader = new NullableDataReader(database.ExecuteReader(storedProcCommand)))
            {
                while (reader.Read())
                {
                    ProductOrderNumberInfo item = new ProductOrderNumberInfo();
                    item.ProductName = reader.GetString("ProductName");
                    item.OrderNumber = reader.GetInt32("OrderNum");
                    list.Add(item);
                }
            }
            this.m_TotalOfProductOrderNumber = (int) database.GetParameterValue(storedProcCommand, "@Total");
            return list;
        }

        public decimal GetSaleOfDay(DateTime saleTime)
        {
            return DataConverter.CDecimal(DBHelper.ExecuteScalarSql("select Sum(MoneyTotal) as Sale from PE_Orders  Where datediff(dd,InputTime,@SaleTime)=0 and MoneyReceipt >= MoneyTotal", new Parameters("@SaleTime", DbType.DateTime, saleTime)));
        }

        public decimal GetSaleOfMonth(DateTime saleTime)
        {
            return DataConverter.CDecimal(DBHelper.ExecuteScalarSql("select Sum(MoneyTotal) as Sale from PE_Orders  Where datediff(m,InputTime,@SaleTime)=0 and MoneyReceipt >= MoneyTotal", new Parameters("@SaleTime", DbType.DateTime, saleTime)));
        }

        public decimal GetSaleOfYear(DateTime saleTime)
        {
            return DataConverter.CDecimal(DBHelper.ExecuteScalarSql("select Sum(MoneyTotal) as Sale from PE_Orders  Where datediff(yy,InputTime,@SaleTime)=0 and MoneyReceipt >= MoneyTotal", new Parameters("@SaleTime", DbType.DateTime, saleTime)));
        }

        public int GetTotalHits()
        {
            return DBHelper.ObjectToInt32(DBHelper.ExecuteScalarSql("SELECT SUM(C.Hits) AS Hits FROM  PE_CommonModel AS C INNER JOIN  PE_CommonProduct AS P ON C.TableName = P.TableName AND C.ItemID = P.ProductID"));
        }

        public int GetTotalMember()
        {
            return DBHelper.ObjectToInt32(DBHelper.ExecuteScalarSql("select Count(*) from PE_Users"));
        }

        public decimal GetTotalMoney(DateTime beginDate, DateTime endDate)
        {
            Parameters cmdParams = new Parameters();
            cmdParams.AddInParameter("@BeginDate", DbType.DateTime, beginDate);
            cmdParams.AddInParameter("@EndDate", DbType.DateTime, endDate);
            return DataConverter.CDecimal(DBHelper.ExecuteScalarSql("select Sum(MoneyTotal) as MoneyTotal from PE_Orders  Where InputTime>@BeginDate and InputTime<=@EndDate and MoneyReceipt >= MoneyTotal", cmdParams));
        }

        public int GetTotalOfCategorySaleroom()
        {
            return this.m_TotalOfCategorySaleroom;
        }

        public int GetTotalOfCompareHitsOrderNumber()
        {
            return this.m_TotalOfCompareHitsOrderNumber;
        }

        public int GetTotalOfMemberExpenditure()
        {
            return this.m_TotalOfMemberExpenditure;
        }

        public int GetTotalOfMemberOrderliness()
        {
            return this.m_TotalOfMemberOrderliness;
        }

        public int GetTotalOfMemberOrders()
        {
            return this.m_TotalOfMemberOrders;
        }

        public int GetTotalOfProductHits()
        {
            return this.m_TotalOfProductHits;
        }

        public int GetTotalOfProductOrderNumber()
        {
            return this.m_TotalOfProductOrderNumber;
        }

        public int GetTotalOrder(DateTime beginDate, DateTime endDate)
        {
            Parameters cmdParams = new Parameters();
            cmdParams.AddInParameter("@BeginDate", DbType.DateTime, beginDate);
            cmdParams.AddInParameter("@EndDate", DbType.DateTime, endDate);
            return DBHelper.ObjectToInt32(DBHelper.ExecuteScalarSql("select Count(*) from PE_Orders Where InputTime>@BeginDate and InputTime<=@EndDate and MoneyReceipt >= MoneyTotal", cmdParams));
        }
    }
}