123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382 |
- 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 Sunny.UI.UILabel uiLBsmid;
- private int _rdsmid = 0;
- private DataTable m_dt;
- public PeiZhiYuJing() : base()
- {
- this.ConditionPanelName = "管线使用年限预警配置";
- InitializeComponent();
- IsShowPanelFooter = false;
- }
- protected override void OnLoad(EventArgs e)
- {
- QueryParameter queryParameter = new QueryParameter
- {
- AttributeFilter = " pzlx='年限预警配置' ",
- ResultFields = new string[] { "smid", "gxlx", "pzlx", "gxcz", "gxyjnx", "gxbznx" },
- OrderBy = new string[] { "smid" },
- CursorType = CursorType.Dynamic,
- HasGeometry = true
- };
- _rd = ComsStatic.dvJSLK_PZ.Query(queryParameter);
- m_dt = ComsStatic.RecordsetToDataTable(_rd);
- ComsStatic.setUIDataGridView(uiDGVjslkpz, m_dt);
- ComsStatic.BindDataTableOnComboBox(ComsStatic.dvJSLK, 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) || uiTByjnx.Text == "0" || string.IsNullOrEmpty(uiTBbznx.Text) || uiTBbznx.Text == "0" || string.IsNullOrEmpty(strCZ))
- {
- UIMessageTip.ShowError("请输入正确的预警年限数据!"); return;
- }
- if (_rd.SeekID(_rdsmid))
- {
- _rd.Edit();
- _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);
- }
- else
- { Sunny.UI.UIMessageTip.ShowError("信息在编辑选择时失败!"); }
- }
- public override void AfterClose()
- {
- if (!(_rd is null)) _rd.Close(); _rd.Dispose();
- base.AfterClose();
- }
- private void uiButton1_Click(object sender, EventArgs e)
- {
- string strCZ = uiCBcz.SelectedItem?.ToString();
- if (string.IsNullOrEmpty(uiTByjnx.Text) || uiTByjnx.Text == "0" || string.IsNullOrEmpty(uiTBbznx.Text) || uiTBbznx.Text == "0" || string.IsNullOrEmpty(strCZ))
- {
- 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("gxlx", "供水管线");
- _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 uiTextBox2_KeyPress(object sender, System.Windows.Forms.KeyPressEventArgs e)
- {
- if ((e.KeyChar < 48 || e.KeyChar > 57) && (e.KeyChar < 96 || e.KeyChar > 105) && (e.KeyChar != 8))
- e.Handled = true;
- }
- 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))
- {
- uiLBsmid.Text = _rd.GetFieldValue("smid").ToString();
- 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.uiLBsmid = new Sunny.UI.UILabel();
- 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(500, 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(500, 365);
- this.uiPanel1.TabIndex = 1;
- this.uiPanel1.Text = "uiPanel1";
- this.uiPanel1.TextAlignment = System.Drawing.ContentAlignment.MiddleCenter;
- //
- // uiPanel2
- //
- this.uiPanel2.Controls.Add(this.uiLBsmid);
- 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, 271);
- 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(500, 94);
- this.uiPanel2.TabIndex = 2;
- this.uiPanel2.Text = null;
- this.uiPanel2.TextAlignment = System.Drawing.ContentAlignment.MiddleCenter;
- //
- // uiLBsmid
- //
- this.uiLBsmid.Font = new System.Drawing.Font("微软雅黑", 12F);
- this.uiLBsmid.Location = new System.Drawing.Point(7, 52);
- this.uiLBsmid.Name = "uiLBsmid";
- this.uiLBsmid.Size = new System.Drawing.Size(59, 23);
- this.uiLBsmid.TabIndex = 11;
- this.uiLBsmid.TextAlign = System.Drawing.ContentAlignment.MiddleLeft;
- this.uiLBsmid.Visible = false;
- //
- // 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(79, 11);
- 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(93, 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(290, 11);
- 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(42, 29);
- this.uiTByjnx.TabIndex = 8;
- this.uiTByjnx.Text = "0";
- this.uiTByjnx.TextAlignment = System.Drawing.ContentAlignment.MiddleLeft;
- this.uiTByjnx.KeyPress += new System.Windows.Forms.KeyPressEventHandler(this.uiTextBox2_KeyPress);
- //
- // 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(450, 11);
- 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(42, 29);
- this.uiTBbznx.TabIndex = 8;
- this.uiTBbznx.Text = "0";
- this.uiTBbznx.TextAlignment = System.Drawing.ContentAlignment.MiddleLeft;
- this.uiTBbznx.KeyPress += new System.Windows.Forms.KeyPressEventHandler(this.uiTextBox2_KeyPress);
- //
- // uiLabel4
- //
- this.uiLabel4.Font = new System.Drawing.Font("微软雅黑", 12F);
- this.uiLabel4.Location = new System.Drawing.Point(335, 11);
- this.uiLabel4.Name = "uiLabel4";
- this.uiLabel4.Size = new System.Drawing.Size(116, 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(175, 11);
- this.uiLabel3.Name = "uiLabel3";
- this.uiLabel3.Size = new System.Drawing.Size(110, 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, 11);
- this.uiLabel1.Name = "uiLabel1";
- this.uiLabel1.Size = new System.Drawing.Size(75, 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(340, 48);
- this.uiButton3.MinimumSize = new System.Drawing.Size(1, 1);
- this.uiButton3.Name = "uiButton3";
- this.uiButton3.Size = new System.Drawing.Size(100, 35);
- 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(212, 48);
- this.uiButton2.MinimumSize = new System.Drawing.Size(1, 1);
- this.uiButton2.Name = "uiButton2";
- this.uiButton2.Size = new System.Drawing.Size(100, 35);
- 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(89, 48);
- this.uiButton1.MinimumSize = new System.Drawing.Size(1, 1);
- this.uiButton1.Name = "uiButton1";
- this.uiButton1.Size = new System.Drawing.Size(100, 35);
- 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(500, 365);
- ((System.ComponentModel.ISupportInitialize)(this.uiDGVjslkpz)).EndInit();
- this.uiPanel1.ResumeLayout(false);
- this.uiPanel2.ResumeLayout(false);
- this.ResumeLayout(false);
- }
- }
- }
|