pipeline-cs/WWPipeLine/WWPipeLine.Map/Tools/Conditions/ShuJuChuLi/PCPeiZhi.cs

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Drawing;
using System.Data;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using WWPipeLine.MapBasic.Conditions;
using WeifenLuo.WinFormsUI.Docking;
using WWPipeLine.MapBasic;
using SuperMap.Data;
using SuperMap.Mapping;
using Sunny.UI;
namespace WWPipeLine.MapTools.Conditions.ShuJuChuLi
{
	public partial class PCPeiZhi : ConditionPanel
	{
		Recordset rd = null;
		DataTable dtCopy;
		public PCPeiZhi()
		{
			this.ConditionPanelName = "普查数据检查配置";
			InitializeComponent();
			this.SetSize(800, 500);
			this.IsShowResultWindow = false;
		}
		protected override void OnLoad(EventArgs e)
		{
			ComsStatic.setUIDataGridView(uidgv);
			uidgv.ReadOnly = false;
			//rd = ComsStatic.dvConfig.Query(" pzlx='普查数据检查配置' and gxlx='管点表' ", CursorType.Dynamic);
			rd = ComsStatic.QueryRecordsetDynamic(ComsStatic.dvConfig, " pzlx='普查数据检查配置' and gxlx='管点表' ", new string[] { "gxlx", "gxcz", "pzkey", "pzvalue", "gxspjj", "gxczjj" });
			DataTable dt = ComsStatic.RecordsetToDataTable(rd, false);
			dtCopy = dt.Copy();
			uidgv.DataSource = dt;
			for (int i = 0; i < uidgv.Columns.Count; i++)
			{
				uidgv.Columns[i].SortMode = DataGridViewColumnSortMode.NotSortable;
				switch (uidgv.Columns[i].Name.ToLower())
				{
					case "gxlx": uidgv.Columns[i].HeaderText = "普查表类型"; uidgv.Columns[i].ReadOnly = true; break;
					case "gxcz": uidgv.Columns[i].HeaderText = "字段类型"; uidgv.Columns[i].ReadOnly = true; break;
					case "pzkey": uidgv.Columns[i].HeaderText = "字段标识"; uidgv.Columns[i].ReadOnly = true; break;
					case "pzvalue": uidgv.Columns[i].HeaderText = "普查标准"; uidgv.Columns[i].ReadOnly = true; break;
					case "gxspjj": uidgv.Columns[i].HeaderText = "数值字段最小值"; uidgv.Columns[i].ReadOnly = false; break;
					case "gxczjj": uidgv.Columns[i].HeaderText = "数值字段最大值"; uidgv.Columns[i].ReadOnly = false; break;
					default: uidgv.Columns[i].Visible = false; break;
				}
			}
		}
		public override object Do(DockPanel dockPanel = null)
		{
			try
			{
				int smid = 0;
				for (int i = 0; i < uidgv.Rows.Count; i++)
				{
					smid = ComsStatic.StringToInt(dtCopy.Rows[i]["smid"]);
					if (smid == 0) continue;

					if (uidgv.Rows[i].Cells["gxspjj"].Value?.ToString() != dtCopy.Rows[i]["gxspjj"]?.ToString() || uidgv.Rows[i].Cells["gxczjj"].Value?.ToString() != dtCopy.Rows[i]["gxczjj"]?.ToString())
					{
						rd.SeekID(smid);
						rd.Edit();
						rd.SetFieldValue("gxspjj", ComsStatic.StringToDouble(uidgv.Rows[i].Cells["gxspjj"].Value));
						rd.SetFieldValue("gxczjj", ComsStatic.StringToDouble(uidgv.Rows[i].Cells["gxczjj"].Value));
						rd.Update();
					}
				}
				ComsStatic.ShowOKLog("配置更改成功"); return true;
			}
			catch (Exception e)
			{
				ComsStatic.ShowErrorLog("配置更改失败", e.Message); return false;
			}

		}
		public override void AfterClose()
		{
			ComsStatic.RecordsetDispose(rd);
			base.AfterClose();
		}
	}
}