pipeline-cs/WWPipeLine/WWPipeLine.Map/Tools/Conditions/Statistics/GXMSRQStatistics.cs

using SuperMap.Data;
using System;
using System.Collections.Generic;
using System.Data;
using WeifenLuo.WinFormsUI.Docking;
using WWPipeLine.MapBasic.Conditions;
using WWPipeLine.MapBasic;

namespace WWPipeLine.MapTools.Conditions.Statistics
{
    public partial class GXMSRQStatistics : ConditionPanel
    {
        public GXMSRQStatistics() : base()
        {
            this.ConditionPanelName = "按管线的埋设日期统计";
            this.SetSize(200, 400);
            InitializeComponent();
        }
        protected override void OnLoad(EventArgs e)
        {
            if (!ComsStatic.HasField(ComsStatic.gsGuanXian, "msrq"))
            {
                Sunny.UI.UIMessageTip.ShowError("当前矢量数据集没有管径信息"); return;
            }
            this.dpRQStart.Value = new System.DateTime(DateTime.Now.Year - 5, DateTime.Now.Month, DateTime.Now.Day);
            this.dpRQEnd.Value = new System.DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day);
        }
        public override object Do(DockPanel dockPanel = null)
        {
            string sql = string.Format(" MSRQ BETWEEN '{0}' AND '{1}' ", dpRQStart.Value.ToString("yyyy/MM/dd"), dpRQEnd.Value.ToString("yyyy/MM/dd"));
            DataTable dtFinal = new DataTable();
            dtFinal.Columns.Add("埋设日期"); dtFinal.Columns.Add("查询结果");
            DataRow drcd = dtFinal.NewRow(); drcd["埋设日期"] = "长度";
            DataRow drsl = dtFinal.NewRow(); drsl["埋设日期"] = "数量";
            Recordset rd = ComsStatic.QueryRecordset(ComsStatic.gsGuanXian, sql);
            drcd["查询结果"] = Math.Round(rd.Statistic("cd", StatisticMode.Sum), 2);
            drsl["查询结果"] = rd.RecordCount;
            dtFinal.Rows.Add(drcd); dtFinal.Rows.Add(drsl);
            ComsStatic.RecordsetDispose(rd);
            return dtFinal;
        }
    }
}