pipeline-cs/WWPipeLine/WWPipeLine.Map/Tools/Conditions/Sercher/SercherOnGXGJ.cs

using SuperMap.Data;

using System;
using System.Collections.Generic;
using WeifenLuo.WinFormsUI.Docking;
using WWPipeLine.MapBasic.Conditions;
using WWPipeLine.MapBasic;
using System.Windows.Forms;

namespace WWPipeLine.MapTools.Conditions.Sercher
{
	public class SercherOnGXGJ : ConditionPanel
	{
		private CheckedListBox clb;
	 

		public SercherOnGXGJ() : base()
		{
			this.ConditionPanelName = "按管线的管径查询";
			this.SetSize(200, 400);
			InitializeComponent();
		}
		protected override void OnLoad(EventArgs e)
		{
			if (!ComsStatic.HasField(ComsStatic.gsGuanXian, "gj"))
			{
				Sunny.UI.UIMessageTip.ShowError("当前矢量数据集没有管径信息"); return;
			}
			 
			ComsStatic.BindDataTableOnCheckedListBox(ComsStatic.gsGuanXian, clb, "gj");
		}

		public override object Do(DockPanel dockPanel = null)
		{
			string sql = " 1=2 ";
			#region 组合AND OR　多选项查询条件
			if (clb.CheckedItems.Count > 0)
			{			 
				foreach (string str in clb.CheckedItems)
				{
					if (str == "未知")
						sql += string.Format(" OR gj is null ", str);
					else
						sql += string.Format(" OR gj='{0}' ", str);
				}
			 
			}
			#endregion
			return ComsStatic.QueryDataTable(ComsStatic.gsGuanXian, sql, ComsStatic.resultFieldsGX);
		}

		private void InitializeComponent()
		{
			this.clb = new System.Windows.Forms.CheckedListBox();
			this.SuspendLayout();
			// 
			// clb
			// 
			this.clb.CheckOnClick = true;
			this.clb.Dock = System.Windows.Forms.DockStyle.Fill;
			this.clb.Location = new System.Drawing.Point(0, 0);
			this.clb.Name = "clb";
			this.clb.Size = new System.Drawing.Size(314, 155);
			this.clb.TabIndex = 0;
			// 
			// SercherOnGXGJ
			// 
			this.Controls.Add(this.clb);
			this.Name = "SercherOnGXGJ";
			this.Size = new System.Drawing.Size(314, 155);
			this.ResumeLayout(false);

		}
	}
}