GIS_cs/WWPipeLine/WWPipeLine.Map/Tools/Conditions/Sercher/SercherOnTJ.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.Sercher
{
	public partial class SercherOnTJ : ConditionPanel
	{
		DatasetVector dv;
		public SercherOnTJ()
		{
			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)
		{
			if (string.IsNullOrEmpty(uilbLayers.SelectedValue.ToString()) || string.IsNullOrEmpty(uitbSql.Text))
			{
				UIMessageTip.ShowError("请先选择需要查询的图层,并设定查询条件"); return false;
			}
			return ComsStatic.QueryDataTable(dv, uitbSql.Text);
		}

		private void uibtnSqltest_Click(object sender, EventArgs e)
		{
			if (string.IsNullOrEmpty(uilbLayers.SelectedValue?.ToString()) || 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));
			}
			uicbxFields.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 = "";
		}

	}
}