categorymanagercontrol.cs

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

namespace PowerEasy.WebSite.Controls
{
    using PowerEasy.Common;
    using PowerEasy.Contents;
    using PowerEasy.Controls;
    using PowerEasy.Enumerations;
    using PowerEasy.Model.Contents;
    using PowerEasy.Model.UserManage;
    using PowerEasy.UserManage;
    using PowerEasy.Web.UI;
    using System;
    using System.Collections.Generic;
    using System.Data;
    using System.Text;
    using System.Web.UI.HtmlControls;
    using System.Web.UI.WebControls;

    public class CategoryManagerControl : BaseUserControl
    {
        protected Button BtnSubmit;
        protected CompareValidator CompareValidator1;
        protected DatePicker DpkEndDate;
        protected DatePicker DpkStartDate;
        protected DropDownList DrpCategory;
        protected HtmlGenericControl SpanCount;

        protected void BtnSubmit_Click(object sender, EventArgs e)
        {
            if (this.Page.IsValid)
            {
                int nodeId = DataConverter.CLng(this.DrpCategory.SelectedValue);
                IList<NodeInfo> nodeList = new List<NodeInfo>();
                if (nodeId > 0)
                {
                    NodeInfo item = new NodeInfo();
                    item.NodeId = nodeId;
                    item.NodeName = PowerEasy.Contents.Nodes.GetCacheNodeById(nodeId).NodeName;
                    nodeList.Add(item);
                }
                else
                {
                    nodeList = PowerEasy.Contents.Nodes.GetNodesList(NodeType.Container);
                }
                DataTable dataTable = ContentManage.GetCountByNodeAndEditor(nodeId, "", DataConverter.CDate(this.DpkStartDate.Text.Trim()), DataConverter.CDate(this.DpkEndDate.Text.Trim()));
                IList<AdministratorInfo> adminList = Administrators.AdminList(0, 0);
                StringBuilder sb = new StringBuilder("<table class=\"border\" id=\"statistics\" cellspacing=\"1\" width=\"100%\" cellpadding=\"2\" border=\"0\">");
                this.BuildTableHead(sb, adminList);
                this.BuildTableBody(sb, dataTable, nodeList, adminList);
                this.BuildTableFooter(sb, adminList.Count);
                sb.Append("</table>");
                this.SpanCount.InnerHtml = sb.ToString();
            }
        }

        private void BuildTableBody(StringBuilder sb, DataTable dataTable, IList<NodeInfo> nodeList, IList<AdministratorInfo> adminList)
        {
            foreach (NodeInfo info in nodeList)
            {
                this.BuildTableTd(sb, dataTable, adminList, info.NodeName);
            }
        }

        private void BuildTableFooter(StringBuilder sb, int length)
        {
            sb.Append("<tr class=\"tdbg\" align=\"center\"><td >合计</td>");
            for (int i = 0; i <= length; i++)
            {
                sb.Append("<td></td>");
            }
            sb.Append("</tr>");
        }

        private void BuildTableHead(StringBuilder sb, IList<AdministratorInfo> adminList)
        {
            sb.Append("<tr align=\"center\" class='title'><td >栏目名称</td>");
            foreach (AdministratorInfo info in adminList)
            {
                sb.Append("<td>");
                sb.Append(info.AdminName);
                sb.Append("</td>");
            }
            sb.Append("<td>合计</td></tr>");
        }

        private void BuildTableTd(StringBuilder sb, DataTable dataTable, IList<AdministratorInfo> adminList, string nodeName)
        {
            int num = 0;
            sb.Append("<tr class=\"tdbg\" align=\"center\">");
            sb.Append("<td>");
            sb.Append(nodeName);
            sb.Append("</td>");
            for (int i = 0; i < adminList.Count; i++)
            {
                sb.Append("<td>");
                DataRow[] rowArray = dataTable.Select("NodeName='" + nodeName + "' AND Editor='" + adminList[i].AdminName + "'");
                if (rowArray.Length > 0)
                {
                    num += DataConverter.CLng(rowArray[0]["Count"]);
                    sb.Append(rowArray[0]["Count"]);
                }
                else
                {
                    sb.Append("0");
                }
                sb.Append("</td>");
            }
            sb.Append("<td >");
            sb.Append(num.ToString());
            sb.Append("</td>");
            sb.Append("</tr>");
        }

        protected void Page_Load(object sender, EventArgs e)
        {
            if (!base.IsPostBack)
            {
                this.DrpCategory.DataSource = PowerEasy.Contents.Nodes.GetNodeNameForContainerItems();
                this.DrpCategory.DataTextField = "NodeName";
                this.DrpCategory.DataValueField = "NodeId";
                this.DrpCategory.DataBind();
                this.DrpCategory.Items.Insert(0, new ListItem("所有栏目", "0"));
                this.DpkStartDate.Text = DateTime.Now.ToString("yyyy") + "-01-01";
                this.DpkEndDate.Text = DateTime.Now.ToString("yyyy-MM-dd");
            }
        }
    }
}