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.gsGuanXian, "dzms")) { Sunny.UI.UIMessageTip.ShowError("当前矢量数据集没有地址描述信息"); return; } ComsStatic.BindDataTableOnCheckedListBox(ComsStatic.gsGuanXian, 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.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(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); } } }