GIS_cs/WWPipeLine/WWPipeLine.Map/Tools/Conditions/Sercher/SercherOnGXDZMS.cs

using SuperMap.Data;

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

namespace WWPipeLine.MapTools.Conditions.Sercher
{
	public class SercherOnGXDZMS : ConditionPanel
	{
		private System.Windows.Forms.CheckedListBox clb;

		public SercherOnGXDZMS() : base()
		{
			this.ConditionPanelName = "按管线的地址描述查询";
			this.SetSize(200, 400);
			InitializeComponent();
		}

		protected override void OnLoad(EventArgs e)
		{
			if (!ComsStatic.HasField(ComsStatic.dvJSLK, "dzms"))
			{
				Sunny.UI.UIMessageTip.ShowError("当前矢量数据集没有地址描述信息"); return;
			}
			ComsStatic.BindDataTableOnCheckedListBox(ComsStatic.dvJSLK, clb, "dzms");
		}

		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 dzms is null ", str);
					else
						sql += string.Format(" OR dzms='{0}'", str);
				}
			}
			#endregion
			return ComsStatic.QueryDataTable(ComsStatic.dvJSLK, 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(500, 300);
			this.clb.TabIndex = 0;
			this.clb.MouseMove += new System.Windows.Forms.MouseEventHandler(ComsStatic.CheckedListBox_MouseMove);
			// 
			// SercherOnGXDZMS
			// 
			this.Controls.Add(this.clb);
			this.Name = "SercherOnGXDZMS";
			this.Size = new System.Drawing.Size(500, 300);
			this.ResumeLayout(false);

		}
	}
}