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

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Drawing;
using System.Data;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using WWPipeLine.MapBasic.Conditions;
using WeifenLuo.WinFormsUI.Docking;
using WWPipeLine.MapBasic;
using Sunny.UI;
using SuperMap.Data;

namespace WWPipeLine.MapTools.Conditions.Statistics
{
	public partial class TJStatistics : ConditionPanel
	{
		DatasetVector dv;
		public TJStatistics()
		{
			this.ConditionPanelName = "条件统计";
			InitializeComponent();
			this.SetSize(660, 600);
		}
		protected override void OnLoad(EventArgs e)
		{
			uibtndengyu.Click += uibtnCaoZuoFu_Click;
			uibtnbudengyu.Click += uibtnCaoZuoFu_Click;
			uibtnLike.Click += uibtnCaoZuoFu_Click;
			uibtndayu.Click += uibtnCaoZuoFu_Click;
			uibtnxiaoyu.Click += uibtnCaoZuoFu_Click;
			uibtnAnd.Click += uibtnCaoZuoFu_Click;
			uibtndydy.Click += uibtnCaoZuoFu_Click;
			uibtnxydy.Click += uibtnCaoZuoFu_Click;
			uibtnOr.Click += uibtnCaoZuoFu_Click;
			uibtnzuokuohao.Click += uibtnCaoZuoFu_Click;
			uibtnyoukuohao.Click += uibtnCaoZuoFu_Click;
			uibtnIs.Click += uibtnCaoZuoFu_Click;
			uibtnbaifenhao.Click += uibtnCaoZuoFu_Click;
			uibtnNot.Click += uibtnCaoZuoFu_Click;
			uibtnNull.Click += uibtnCaoZuoFu_Click;

			uilbLayers.ValueMember = "LayerDatasetName";
			uilbLayers.DisplayMember = "LayerCaption";
			uilbLayers.DataSource = ComsStatic.getLayers();
			uilbLayers.SelectedIndex = 0;
		}

		public override object Do(DockPanel dockPanel = null)
		{
			string fieldKey = (uicbxTongji.SelectedItem as DoListItem).Key;
			if (dv is null || string.IsNullOrEmpty(uitbSql.Text))
			{
				UIMessageTip.ShowError("请先选择需要查询的图层,并设定查询条件"); return false;
			}
			Recordset rd = ComsStatic.QueryRecordset(dv, uitbSql.Text, new string[] { fieldKey }, new string[] { fieldKey }, new string[] { fieldKey });
			DataTable dt = new DataTable();
			dt.Columns.Add("类别"); dt.Columns.Add("数量");
			rd.MoveFirst();
			string fc = string.Empty;
			DataRow dr;
			while (!rd.IsEOF)
			{
				dr = dt.NewRow();
				fc = rd.GetFieldValue(fieldKey)?.ToString();
				if (string.IsNullOrEmpty(fc))
				{
					dr[0] = "未知";
					dr[1] = dv.Query(string.Format("{0} is null", fieldKey), CursorType.Static).RecordCount;
				}
				else
				{
					dr[0] = fc;
					dr[1] = dv.Query(string.Format("{0}='{1}'", fieldKey, fc), CursorType.Static).RecordCount;
				}
				dt.Rows.Add(dr);
				rd.MoveNext();

			}
			dr = dt.NewRow();
			dr[0] = "总量"; dr[1] = dv.RecordCount;
			dt.Rows.Add(dr);
			return dt;
		}

		private void uibtnSqltest_Click(object sender, EventArgs e)
		{
			if (dv is null || string.IsNullOrEmpty(uitbSql.Text))
			{
				UIMessageTip.ShowError("请先选择需要查询的图层,并设定查询条件"); return;
			}
			Recordset rd = ComsStatic.QueryRecordset(dv, uitbSql.Text);
			if (rd.IsEmpty)
			{
				ComsStatic.ShowErrorLog("条件错误或者查询结果为空", uitbSql.Text); return;
			}
			else
			{
				ComsStatic.ShowOKLog("查询语句设置正确", uitbSql.Text); return;
			}
		}

		private void uilbLayers_SelectedIndexChanged(object sender, EventArgs e)
		{
			dv = ComsStatic.Datasource.Datasets[uilbLayers.SelectedValue.ToString()] as DatasetVector;
			if (dv is null) { UIMessageTip.ShowError("当前选择的图层没有匹配的数据源"); return; }
			uicbxFields.Items.Clear();
			foreach (FieldInfo info in dv.FieldInfos)
			{
				if (ComsStatic.HideEnableTag.Contains("," + info.Name.ToLower() + ",") || info.IsSystemField) continue;
				uicbxFields.Items.Add(new DoListItem(info.Name, info.Caption));
				uicbxTongji.Items.Add(new DoListItem(info.Name, info.Caption));
			}
			uicbxFields.SelectedIndex = 0; uicbxTongji.SelectedIndex = 0;
		}

		private void uicbxFields_SelectedIndexChanged(object sender, EventArgs e)
		{
			string fieldValue = (uicbxFields.SelectedItem as DoListItem).Key;
			Recordset rd = ComsStatic.QueryRecordset(dv, string.Format(" {0} is not null", fieldValue), new string[] { fieldValue }, new string[] { fieldValue }, new string[] { fieldValue });
			uilbValues.Items.Clear();
			rd.MoveFirst();
			while (!rd.IsEOF)
			{
				uilbValues.Items.Add(rd.GetFieldValue(fieldValue).ToString());
				rd.MoveNext();
			}
		}

		private void uilbxValues_ItemClick(object sender, EventArgs e)
		{
			uitbSql.Text += uilbValues.SelectedItem?.ToString();
		}
		private void uibtnCaoZuoFu_Click(object sender, EventArgs e)
		{
			UIButton uiBtn = sender as UIButton;
			if (uiBtn.Tag?.ToString() == "hasField")
			{
				string fieldValue = (uicbxFields.SelectedItem as DoListItem).Key;
				uitbSql.Text = string.Format(" {0} {1} {2} ", uitbSql.Text, fieldValue, uiBtn.Text);

			}
			else
				uitbSql.Text = string.Format(" {0} {1} ", uitbSql.Text, uiBtn.Text);
		}
		private void uibtnSqlClear_Click(object sender, EventArgs e)
		{
			uitbSql.Text = "";
		}

	}
}