GIS_cs/WWPipeLine/WWPipeLine.Map/Tools/Conditions/Locations/SearchOnJDPT.cs

using SuperMap.Data;
using SuperMap.Mapping;
using SuperMap.UI;
using System;
using System.Collections.Generic;
using System.Data;
using System.Drawing;
using WeifenLuo.WinFormsUI.Docking;
using WWPipeLine.MapBasic.Conditions;
using WWPipeLine.MapBasic;
using System.Windows.Forms;

namespace WWPipeLine.MapTools.Conditions.Locations
{
	public class SearchOnJDPT : ConditionPanel
	{
		public SearchOnJDPT() : base()
		{
			this.ConditionPanelName = "按照供水节点组合查询";
			this.SetSize(800, 400);
			InitializeComponent();
		}
		private DatasetVector _dv = ComsStatic.dvJSJDPT;
		private GroupBox groupBox1;
		private CheckedListBox clbDZMS;
		private GroupBox groupBox2;
		private CheckedListBox clbCZ;
		private GroupBox groupBox3;
		private CheckedListBox clbXH;
		private GroupBox groupBox4;
		private CheckedListBox clbGG;
		 


		protected override void OnLoad(EventArgs e)
		{
			if (_dv == null)
			{
				Sunny.UI.UIMessageTip.ShowError("当前数据源中不包含相应的矢量数据集", 5000);
				this.ParentForm.Close();
				return;
			}
			 
			if (!ComsStatic.HasField(_dv, "xh") || !ComsStatic.HasField(_dv, "cz") || !ComsStatic.HasField(_dv, "gg") || !ComsStatic.HasField(_dv, "dzms"))
			{
				Sunny.UI.UIMessageTip.ShowError("当前矢量数据集没有相应的信息", 5000);
				this.ParentForm.Close();
				return;
			}
			ComsStatic.BindDataTableOnCheckedListBox(_dv, clbXH, "xh");
			ComsStatic.BindDataTableOnCheckedListBox(_dv, clbCZ, "cz");
			ComsStatic.BindDataTableOnCheckedListBox(_dv, clbGG, "gg");
			ComsStatic.BindDataTableOnCheckedListBox(_dv, clbDZMS, "dzms");
		}

		public override object Do(DockPanel dockPanel = null)
		{
			string sql = " 1=1 ";
			#region 组合AND OR　多选项查询条件
			if (clbXH.CheckedItems.Count > 0)
			{
				sql += " AND (1=2 ";
				foreach (string str in clbXH.CheckedItems)
				{
					sql += string.Format(" OR XH='{0}'", str);
				}
				sql += " ) ";
			}
			if (clbCZ.CheckedItems.Count > 0)
			{
				sql += " AND (1=2 ";
				foreach (string str in clbCZ.CheckedItems)
				{
					sql += string.Format(" OR CZ='{0}'", str);
				}
				sql += " ) ";
			}
			if (clbGG.CheckedItems.Count > 0)
			{
				sql += " AND (1=2 ";
				foreach (string str in clbGG.CheckedItems)
				{
					sql += string.Format(" OR GG='{0}'", str);
				}
				sql += " ) ";
			}
			if (clbDZMS.CheckedItems.Count > 0)
			{
				sql += " AND (1=2 ";
				foreach (string str in clbDZMS.CheckedItems)
				{
					sql += string.Format(" OR DZMS='{0}'", str);
				}
				sql += " ) ";
			}

			#endregion
			return ComsStatic.QueryDataTable(_dv, sql, new string[] { "xh", "cz", "gg", "dzms", "fldm", "sblx", "yl", "ms" });
		}
		#region 界面布局
		private void InitializeComponent()
		{
			this.groupBox1 = new System.Windows.Forms.GroupBox();
			this.clbDZMS = new System.Windows.Forms.CheckedListBox();
			this.groupBox2 = new System.Windows.Forms.GroupBox();
			this.clbCZ = new System.Windows.Forms.CheckedListBox();
			this.groupBox3 = new System.Windows.Forms.GroupBox();
			this.clbXH = new System.Windows.Forms.CheckedListBox();
			this.groupBox4 = new System.Windows.Forms.GroupBox();
			this.clbGG = new System.Windows.Forms.CheckedListBox();
			this.groupBox1.SuspendLayout();
			this.groupBox2.SuspendLayout();
			this.groupBox3.SuspendLayout();
			this.groupBox4.SuspendLayout();
			this.SuspendLayout();
			// 
			// groupBox1
			// 
			this.groupBox1.Controls.Add(this.clbDZMS);
			this.groupBox1.Location = new System.Drawing.Point(601, 5);
			this.groupBox1.Name = "groupBox1";
			this.groupBox1.Size = new System.Drawing.Size(194, 350);
			this.groupBox1.TabIndex = 14;
			this.groupBox1.TabStop = false;
			this.groupBox1.Text = "地址描述";
			// 
			// clbDZMS
			// 
			this.clbDZMS.Dock = System.Windows.Forms.DockStyle.Fill;
			this.clbDZMS.Location = new System.Drawing.Point(3, 25);
			this.clbDZMS.Name = "clbDZMS";
			this.clbDZMS.Size = new System.Drawing.Size(188, 322);
			this.clbDZMS.TabIndex = 0;
			// 
			// groupBox2
			// 
			this.groupBox2.Controls.Add(this.clbCZ);
			this.groupBox2.Location = new System.Drawing.Point(205, 5);
			this.groupBox2.Name = "groupBox2";
			this.groupBox2.Size = new System.Drawing.Size(194, 350);
			this.groupBox2.TabIndex = 15;
			this.groupBox2.TabStop = false;
			this.groupBox2.Text = "材质";
			// 
			// clbCZ
			// 
			this.clbCZ.Dock = System.Windows.Forms.DockStyle.Fill;
			this.clbCZ.Location = new System.Drawing.Point(3, 25);
			this.clbCZ.Name = "clbCZ";
			this.clbCZ.Size = new System.Drawing.Size(188, 322);
			this.clbCZ.TabIndex = 0;
			// 
			// groupBox3
			// 
			this.groupBox3.Controls.Add(this.clbXH);
			this.groupBox3.Location = new System.Drawing.Point(7, 5);
			this.groupBox3.Name = "groupBox3";
			this.groupBox3.Size = new System.Drawing.Size(194, 350);
			this.groupBox3.TabIndex = 15;
			this.groupBox3.TabStop = false;
			this.groupBox3.Text = "型号";
			// 
			// clbXH
			// 
			this.clbXH.Dock = System.Windows.Forms.DockStyle.Fill;
			this.clbXH.Location = new System.Drawing.Point(3, 25);
			this.clbXH.Name = "clbXH";
			this.clbXH.Size = new System.Drawing.Size(188, 322);
			this.clbXH.TabIndex = 0;
			// 
			// groupBox4
			// 
			this.groupBox4.Controls.Add(this.clbGG);
			this.groupBox4.Location = new System.Drawing.Point(403, 5);
			this.groupBox4.Name = "groupBox4";
			this.groupBox4.Size = new System.Drawing.Size(194, 350);
			this.groupBox4.TabIndex = 15;
			this.groupBox4.TabStop = false;
			this.groupBox4.Text = "规格";
			// 
			// clbGG
			// 
			this.clbGG.Dock = System.Windows.Forms.DockStyle.Fill;
			this.clbGG.Location = new System.Drawing.Point(3, 25);
			this.clbGG.Name = "clbGG";
			this.clbGG.Size = new System.Drawing.Size(188, 322);
			this.clbGG.TabIndex = 0;
			// 
			// SearchOnJDPT
			// 
			this.Controls.Add(this.groupBox4);
			this.Controls.Add(this.groupBox2);
			this.Controls.Add(this.groupBox3);
			this.Controls.Add(this.groupBox1);
			this.FillColor = System.Drawing.Color.FromArgb(((int)(((byte)(242)))), ((int)(((byte)(242)))), ((int)(((byte)(244)))));
			this.Name = "SearchOnJDPT";
			this.RectColor = System.Drawing.Color.FromArgb(((int)(((byte)(140)))), ((int)(((byte)(140)))), ((int)(((byte)(140)))));
			this.Size = new System.Drawing.Size(800, 379);
			this.Style = Sunny.UI.UIStyle.Gray;
			this.groupBox1.ResumeLayout(false);
			this.groupBox2.ResumeLayout(false);
			this.groupBox3.ResumeLayout(false);
			this.groupBox4.ResumeLayout(false);
			this.ResumeLayout(false);

		}
		#endregion

	}
}