using SuperMap.Data; using System; using System.Collections.Generic; using WeifenLuo.WinFormsUI.Docking; using WWPipeLine.MapBasic.Conditions; using WWPipeLine.MapBasic; using Sunny.UI; using System.Windows.Forms; using System.Data; namespace WWPipeLine.MapTools.Conditions.XiTongGuanLi { public class PeiZhiYuJing : ConditionPanel { private Sunny.UI.UIDataGridView uiDGVjslkpz; private Sunny.UI.UIPanel uiPanel1; private Sunny.UI.UIButton uiButton3; private Sunny.UI.UIButton uiButton2; private Sunny.UI.UIButton uiButton1; private Sunny.UI.UILabel uiLabel1; private Sunny.UI.UILabel uiLabel3; private Sunny.UI.UILabel uiLabel4; private Sunny.UI.UITextBox uiTByjnx; private Sunny.UI.UITextBox uiTBbznx; private Sunny.UI.UIPanel uiPanel2; private Sunny.UI.UIComboBox uiCBcz; private Recordset _rd; private int _rdsmid = 0; private DataTable m_dt; public PeiZhiYuJing() : base() { this.ConditionPanelName = "管线年限预警配置"; this.SetSize(300, 400); InitializeComponent(); IsShowPanelFooter = false; } protected override void OnLoad(EventArgs e) { QueryParameter queryParameter = new QueryParameter { AttributeFilter = " pzlx='年限预警配置' ", ResultFields = new string[] { "smid", "pzlx", "gxcz", "gxyjnx", "gxbznx" }, OrderBy = new string[] { "smid" }, CursorType = CursorType.Dynamic }; _rd = ComsStatic.dvConfig.Query(queryParameter); m_dt = ComsStatic.RecordsetToDataTable(_rd, false); ComsStatic.setUIDataGridView(uiDGVjslkpz, m_dt, null, ",pzlx,smid,"); uiDGVjslkpz.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill; ComsStatic.BindDataTableOnComboBox(ComsStatic.gsGuanXian, uiCBcz, "cz"); } private void uiButton3_Click(object sender, EventArgs e) { if (_rdsmid == 0) { UIMessageTip.ShowError("请先选择需要删除的信息!"); return; } if (_rd.SeekID(_rdsmid)) { ComsStatic.ShowUIMessageTipOKorError(_rd.Delete(), "管线年限预警删除"); OnLoad(e); } else { Sunny.UI.UIMessageTip.ShowError("信息在删除选择时失败!"); } } private void uiButton2_Click(object sender, EventArgs e) { string strCZ = uiCBcz.SelectedItem.ToString(); if (string.IsNullOrEmpty(uiTByjnx.Text) || string.IsNullOrEmpty(uiTBbznx.Text)) { UIMessageTip.ShowError("请输入正确的预警年限数据!"); return; } if (_rd.SeekID(_rdsmid)) { _rd.Edit(); _rd.SetFieldValue("gxcz", strCZ); _rd.SetFieldValue("gxyjnx", ComsStatic.StringToDouble(uiTByjnx.Text)); _rd.SetFieldValue("gxbznx", ComsStatic.StringToDouble(uiTBbznx.Text)); ComsStatic.ShowUIMessageTipOKorError(_rd.Update(), "管线年限预警编辑"); OnLoad(e); } else { Sunny.UI.UIMessageTip.ShowError("信息在编辑选择时失败!"); } } public override void AfterClose() { ComsStatic.RecordsetDispose(_rd); base.AfterClose(); } private void uiButton1_Click(object sender, EventArgs e) { string strCZ = uiCBcz.SelectedItem.ToString(); if (string.IsNullOrEmpty(uiTByjnx.Text) || string.IsNullOrEmpty(uiTBbznx.Text)) { UIMessageTip.ShowError("请输入正确的预警年限数据!"); return; } if (m_dt.Select(string.Format(" gxcz='{0}'", strCZ)).Length > 0) { UIMessageTip.ShowError("已经存在管线的预警年限信息!"); return; } _rd.AddNew(new GeoPoint(0, 0)); _rd.SetFieldValue("pzlx", "年限预警配置"); _rd.SetFieldValue("gxcz", uiCBcz.SelectedItem); _rd.SetFieldValue("gxyjnx", ComsStatic.StringToDouble(uiTByjnx.Text)); _rd.SetFieldValue("gxbznx", ComsStatic.StringToDouble(uiTBbznx.Text)); ComsStatic.ShowUIMessageTipOKorError(_rd.Update(), "管线年限预警新增"); OnLoad(e); } private void uiDGVjslkpz_SelectIndexChange(object sender, int index) { var selectRows = (sender as UIDataGridView).SelectedRows; if (selectRows == null || selectRows.Count != 1) return; _rdsmid = ComsStatic.StringToInt(selectRows[0].Cells["SmID"].Value.ToString()); if (_rdsmid != 0 && _rd.SeekID(_rdsmid)) { uiCBcz.SelectedItem = _rd.GetFieldValue("gxcz").ToString(); uiTByjnx.Text = _rd.GetFieldValue("gxyjnx").ToString(); uiTBbznx.Text = _rd.GetFieldValue("gxbznx").ToString(); } else { Sunny.UI.UIMessageTip.ShowError("信息错误!"); } } private void InitializeComponent() { System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle1 = new System.Windows.Forms.DataGridViewCellStyle(); System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle2 = new System.Windows.Forms.DataGridViewCellStyle(); System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle3 = new System.Windows.Forms.DataGridViewCellStyle(); System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle4 = new System.Windows.Forms.DataGridViewCellStyle(); System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle5 = new System.Windows.Forms.DataGridViewCellStyle(); this.uiDGVjslkpz = new Sunny.UI.UIDataGridView(); this.uiPanel1 = new Sunny.UI.UIPanel(); this.uiPanel2 = new Sunny.UI.UIPanel(); this.uiCBcz = new Sunny.UI.UIComboBox(); this.uiTByjnx = new Sunny.UI.UITextBox(); this.uiTBbznx = new Sunny.UI.UITextBox(); this.uiLabel4 = new Sunny.UI.UILabel(); this.uiLabel3 = new Sunny.UI.UILabel(); this.uiLabel1 = new Sunny.UI.UILabel(); this.uiButton3 = new Sunny.UI.UIButton(); this.uiButton2 = new Sunny.UI.UIButton(); this.uiButton1 = new Sunny.UI.UIButton(); ((System.ComponentModel.ISupportInitialize)(this.uiDGVjslkpz)).BeginInit(); this.uiPanel1.SuspendLayout(); this.uiPanel2.SuspendLayout(); this.SuspendLayout(); // // uiDGVjslkpz // dataGridViewCellStyle1.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(235)))), ((int)(((byte)(243)))), ((int)(((byte)(255))))); this.uiDGVjslkpz.AlternatingRowsDefaultCellStyle = dataGridViewCellStyle1; this.uiDGVjslkpz.BackgroundColor = System.Drawing.Color.White; this.uiDGVjslkpz.ColumnHeadersBorderStyle = System.Windows.Forms.DataGridViewHeaderBorderStyle.Single; dataGridViewCellStyle2.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleCenter; dataGridViewCellStyle2.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(80)))), ((int)(((byte)(160)))), ((int)(((byte)(255))))); dataGridViewCellStyle2.Font = new System.Drawing.Font("微软雅黑", 12F); dataGridViewCellStyle2.ForeColor = System.Drawing.Color.White; dataGridViewCellStyle2.SelectionBackColor = System.Drawing.Color.FromArgb(((int)(((byte)(80)))), ((int)(((byte)(160)))), ((int)(((byte)(255))))); dataGridViewCellStyle2.SelectionForeColor = System.Drawing.SystemColors.HighlightText; dataGridViewCellStyle2.WrapMode = System.Windows.Forms.DataGridViewTriState.True; this.uiDGVjslkpz.ColumnHeadersDefaultCellStyle = dataGridViewCellStyle2; this.uiDGVjslkpz.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.AutoSize; dataGridViewCellStyle3.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleLeft; dataGridViewCellStyle3.BackColor = System.Drawing.SystemColors.Window; dataGridViewCellStyle3.Font = new System.Drawing.Font("微软雅黑", 12F); dataGridViewCellStyle3.ForeColor = System.Drawing.Color.FromArgb(((int)(((byte)(48)))), ((int)(((byte)(48)))), ((int)(((byte)(48))))); dataGridViewCellStyle3.SelectionBackColor = System.Drawing.Color.FromArgb(((int)(((byte)(155)))), ((int)(((byte)(200)))), ((int)(((byte)(255))))); dataGridViewCellStyle3.SelectionForeColor = System.Drawing.Color.FromArgb(((int)(((byte)(48)))), ((int)(((byte)(48)))), ((int)(((byte)(48))))); dataGridViewCellStyle3.WrapMode = System.Windows.Forms.DataGridViewTriState.False; this.uiDGVjslkpz.DefaultCellStyle = dataGridViewCellStyle3; this.uiDGVjslkpz.Dock = System.Windows.Forms.DockStyle.Fill; this.uiDGVjslkpz.EnableHeadersVisualStyles = false; this.uiDGVjslkpz.Font = new System.Drawing.Font("微软雅黑", 12F); this.uiDGVjslkpz.GridColor = System.Drawing.Color.FromArgb(((int)(((byte)(80)))), ((int)(((byte)(160)))), ((int)(((byte)(255))))); this.uiDGVjslkpz.Location = new System.Drawing.Point(0, 0); this.uiDGVjslkpz.Name = "uiDGVjslkpz"; dataGridViewCellStyle4.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleLeft; dataGridViewCellStyle4.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(235)))), ((int)(((byte)(243)))), ((int)(((byte)(255))))); dataGridViewCellStyle4.Font = new System.Drawing.Font("微软雅黑", 12F); dataGridViewCellStyle4.ForeColor = System.Drawing.Color.FromArgb(((int)(((byte)(48)))), ((int)(((byte)(48)))), ((int)(((byte)(48))))); dataGridViewCellStyle4.SelectionBackColor = System.Drawing.Color.FromArgb(((int)(((byte)(80)))), ((int)(((byte)(160)))), ((int)(((byte)(255))))); dataGridViewCellStyle4.SelectionForeColor = System.Drawing.Color.White; dataGridViewCellStyle4.WrapMode = System.Windows.Forms.DataGridViewTriState.True; this.uiDGVjslkpz.RowHeadersDefaultCellStyle = dataGridViewCellStyle4; dataGridViewCellStyle5.BackColor = System.Drawing.Color.White; this.uiDGVjslkpz.RowsDefaultCellStyle = dataGridViewCellStyle5; this.uiDGVjslkpz.RowTemplate.Height = 23; this.uiDGVjslkpz.SelectedIndex = -1; this.uiDGVjslkpz.ShowGridLine = true; this.uiDGVjslkpz.Size = new System.Drawing.Size(300, 365); this.uiDGVjslkpz.TabIndex = 0; this.uiDGVjslkpz.SelectIndexChange += new Sunny.UI.UIDataGridView.OnSelectIndexChange(this.uiDGVjslkpz_SelectIndexChange); // // uiPanel1 // this.uiPanel1.Controls.Add(this.uiDGVjslkpz); this.uiPanel1.Dock = System.Windows.Forms.DockStyle.Fill; this.uiPanel1.Font = new System.Drawing.Font("微软雅黑", 12F); this.uiPanel1.Location = new System.Drawing.Point(0, 0); this.uiPanel1.Margin = new System.Windows.Forms.Padding(4, 5, 4, 5); this.uiPanel1.MinimumSize = new System.Drawing.Size(1, 1); this.uiPanel1.Name = "uiPanel1"; this.uiPanel1.Size = new System.Drawing.Size(300, 365); this.uiPanel1.TabIndex = 1; this.uiPanel1.Text = "uiPanel1"; this.uiPanel1.TextAlignment = System.Drawing.ContentAlignment.MiddleCenter; // // uiPanel2 // this.uiPanel2.Controls.Add(this.uiCBcz); this.uiPanel2.Controls.Add(this.uiTByjnx); this.uiPanel2.Controls.Add(this.uiTBbznx); this.uiPanel2.Controls.Add(this.uiLabel4); this.uiPanel2.Controls.Add(this.uiLabel3); this.uiPanel2.Controls.Add(this.uiLabel1); this.uiPanel2.Controls.Add(this.uiButton3); this.uiPanel2.Controls.Add(this.uiButton2); this.uiPanel2.Controls.Add(this.uiButton1); this.uiPanel2.Dock = System.Windows.Forms.DockStyle.Bottom; this.uiPanel2.Font = new System.Drawing.Font("微软雅黑", 12F); this.uiPanel2.Location = new System.Drawing.Point(0, 245); this.uiPanel2.Margin = new System.Windows.Forms.Padding(4, 5, 4, 5); this.uiPanel2.MinimumSize = new System.Drawing.Size(1, 1); this.uiPanel2.Name = "uiPanel2"; this.uiPanel2.Size = new System.Drawing.Size(300, 120); this.uiPanel2.TabIndex = 2; this.uiPanel2.Text = null; this.uiPanel2.TextAlignment = System.Drawing.ContentAlignment.MiddleCenter; // // uiCBcz // this.uiCBcz.DataSource = null; this.uiCBcz.FillColor = System.Drawing.Color.White; this.uiCBcz.Font = new System.Drawing.Font("微软雅黑", 12F); this.uiCBcz.Location = new System.Drawing.Point(89, 5); this.uiCBcz.Margin = new System.Windows.Forms.Padding(4, 5, 4, 5); this.uiCBcz.MinimumSize = new System.Drawing.Size(63, 0); this.uiCBcz.Name = "uiCBcz"; this.uiCBcz.Padding = new System.Windows.Forms.Padding(0, 0, 30, 2); this.uiCBcz.Size = new System.Drawing.Size(107, 29); this.uiCBcz.TabIndex = 9; this.uiCBcz.TextAlignment = System.Drawing.ContentAlignment.MiddleLeft; // // uiTByjnx // this.uiTByjnx.Cursor = System.Windows.Forms.Cursors.IBeam; this.uiTByjnx.FillColor = System.Drawing.Color.White; this.uiTByjnx.Font = new System.Drawing.Font("微软雅黑", 12F); this.uiTByjnx.Location = new System.Drawing.Point(89, 39); this.uiTByjnx.Margin = new System.Windows.Forms.Padding(4, 5, 4, 5); this.uiTByjnx.Maximum = 2147483647D; this.uiTByjnx.MaxLength = 2; this.uiTByjnx.Minimum = -2147483648D; this.uiTByjnx.MinimumSize = new System.Drawing.Size(1, 1); this.uiTByjnx.Name = "uiTByjnx"; this.uiTByjnx.Size = new System.Drawing.Size(46, 29); this.uiTByjnx.TabIndex = 8; this.uiTByjnx.Text = "0"; this.uiTByjnx.TextAlignment = System.Drawing.ContentAlignment.MiddleLeft; // // uiTBbznx // this.uiTBbznx.Cursor = System.Windows.Forms.Cursors.IBeam; this.uiTBbznx.FillColor = System.Drawing.Color.White; this.uiTBbznx.Font = new System.Drawing.Font("微软雅黑", 12F); this.uiTBbznx.Location = new System.Drawing.Point(235, 39); this.uiTBbznx.Margin = new System.Windows.Forms.Padding(4, 5, 4, 5); this.uiTBbznx.Maximum = 2147483647D; this.uiTBbznx.MaxLength = 2; this.uiTBbznx.Minimum = -2147483648D; this.uiTBbznx.MinimumSize = new System.Drawing.Size(1, 1); this.uiTBbznx.Name = "uiTBbznx"; this.uiTBbznx.Size = new System.Drawing.Size(51, 29); this.uiTBbznx.TabIndex = 8; this.uiTBbznx.Text = "0"; this.uiTBbznx.TextAlignment = System.Drawing.ContentAlignment.MiddleLeft; // // uiLabel4 // this.uiLabel4.Font = new System.Drawing.Font("微软雅黑", 12F); this.uiLabel4.Location = new System.Drawing.Point(150, 39); this.uiLabel4.Name = "uiLabel4"; this.uiLabel4.Size = new System.Drawing.Size(98, 28); this.uiLabel4.TabIndex = 6; this.uiLabel4.Text = "标准年限:"; this.uiLabel4.TextAlign = System.Drawing.ContentAlignment.MiddleLeft; // // uiLabel3 // this.uiLabel3.Font = new System.Drawing.Font("微软雅黑", 12F); this.uiLabel3.Location = new System.Drawing.Point(4, 39); this.uiLabel3.Name = "uiLabel3"; this.uiLabel3.Size = new System.Drawing.Size(98, 28); this.uiLabel3.TabIndex = 5; this.uiLabel3.Text = "预警年限:"; this.uiLabel3.TextAlign = System.Drawing.ContentAlignment.MiddleLeft; // // uiLabel1 // this.uiLabel1.Font = new System.Drawing.Font("微软雅黑", 12F); this.uiLabel1.Location = new System.Drawing.Point(4, 6); this.uiLabel1.Name = "uiLabel1"; this.uiLabel1.Size = new System.Drawing.Size(98, 28); this.uiLabel1.TabIndex = 3; this.uiLabel1.Text = "管线材质:"; this.uiLabel1.TextAlign = System.Drawing.ContentAlignment.MiddleLeft; // // uiButton3 // this.uiButton3.Cursor = System.Windows.Forms.Cursors.Hand; this.uiButton3.Font = new System.Drawing.Font("微软雅黑", 12F); this.uiButton3.Location = new System.Drawing.Point(216, 81); this.uiButton3.MinimumSize = new System.Drawing.Size(1, 1); this.uiButton3.Name = "uiButton3"; this.uiButton3.Size = new System.Drawing.Size(70, 30); this.uiButton3.TabIndex = 2; this.uiButton3.Text = "删除"; this.uiButton3.Click += new System.EventHandler(this.uiButton3_Click); // // uiButton2 // this.uiButton2.Cursor = System.Windows.Forms.Cursors.Hand; this.uiButton2.Font = new System.Drawing.Font("微软雅黑", 12F); this.uiButton2.Location = new System.Drawing.Point(126, 81); this.uiButton2.MinimumSize = new System.Drawing.Size(1, 1); this.uiButton2.Name = "uiButton2"; this.uiButton2.Size = new System.Drawing.Size(70, 30); this.uiButton2.TabIndex = 1; this.uiButton2.Text = "修改"; this.uiButton2.Click += new System.EventHandler(this.uiButton2_Click); // // uiButton1 // this.uiButton1.Cursor = System.Windows.Forms.Cursors.Hand; this.uiButton1.Font = new System.Drawing.Font("微软雅黑", 12F); this.uiButton1.Location = new System.Drawing.Point(37, 81); this.uiButton1.MinimumSize = new System.Drawing.Size(1, 1); this.uiButton1.Name = "uiButton1"; this.uiButton1.Size = new System.Drawing.Size(70, 30); this.uiButton1.TabIndex = 0; this.uiButton1.Text = "新增"; this.uiButton1.Click += new System.EventHandler(this.uiButton1_Click); // // PeiZhiYuJing // this.Controls.Add(this.uiPanel2); this.Controls.Add(this.uiPanel1); this.Name = "PeiZhiYuJing"; this.Size = new System.Drawing.Size(300, 365); ((System.ComponentModel.ISupportInitialize)(this.uiDGVjslkpz)).EndInit(); this.uiPanel1.ResumeLayout(false); this.uiPanel2.ResumeLayout(false); this.ResumeLayout(false); } } }