useraddress.cs

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

namespace PowerEasy.SqlServerDal.Analytics.Report
{
    using PowerEasy.Common;
    using PowerEasy.SqlServerDal;
    using System;
    using System.Collections.Generic;
    using System.Data;

    public class UserAddress : AbstractUserDataReport
    {
        public override Dictionary<string, int> GetList(int startRowIndexId, int maxiNumRows)
        {
            return base.GetDictionary(startRowIndexId, maxiNumRows, "PE_StatAddress", "TAddress", "TAddNum");
        }

        public override string MaxValue
        {
            get
            {
                string str = string.Empty;
                using (NullableDataReader reader = DBHelper.ExecuteReader(CommandType.Text, "Select Top 1 * From PE_StatAddress Order By TAddNum DESC", null))
                {
                    if (reader.Read())
                    {
                        str = reader.GetString("TAddress") + " (" + reader.GetInt32("TAddNum").ToString() + ")";
                    }
                }
                return str;
            }
        }

        public override int Sum
        {
            get
            {
                return DataConverter.CLng(DBHelper.ExecuteScalarSql("select sum(TAddNum) from PE_StatAddress"));
            }
        }
    }
}