using KGIS.Framework.Views; using Kingo.Plugin.NYYP.Common; using System; using System.Collections.Generic; using System.Drawing; using System.Linq; using System.Text; using System.Threading.Tasks; using System.Windows; using System.Windows.Controls; using System.Windows.Data; using System.Windows.Documents; using System.Windows.Input; using System.Windows.Media; using System.Windows.Media.Imaging; using System.Windows.Navigation; using System.Windows.Shapes; using KGIS.Framework.Platform; using System.ComponentModel; using System.Data; using KGIS.Framework.Utils.Interface; using ESRI.ArcGIS.Geodatabase; using ESRI.ArcGIS.Controls; using KGIS.Framework.Maps; using ESRI.ArcGIS.Carto; using KGIS.Framework.Utils; using KGIS.Framework.Utils.Helper; using KGIS.Framework.DBOperator; using KGIS.Framework.Utils.Utility; using Kingo.PluginServiceInterface; namespace Kingo.Plugin.NYYP.View { /// /// UCYWTBYPDetails.xaml 的交互逻辑 /// public partial class UCYWTBYPDetails : UserControl, IDockPanel2, INotifyPropertyChanged { public bool showDetail { get; set; } private int m_DataIndex { get; set; } private int m_DataCount { get; set; } public List Items { get; set; } public List m_dic = null; public List VirtualTree { get; set; } #region 接口实现 public Guid ID { get; set; } public DockStyle DockAreas { get; set; } public System.Drawing.Size FloatSize { get; set; } public int DockWidth { get; set; } public int DockHeight { get; set; } public DockStyle DefaultArea { get; set; } public bool ShowCloseButton { get; set; } public bool ShowAutoHideButton { get; set; } public string Title { get; set; } public event EventHandler CloseViewHandler; public event PropertyChangedEventHandler PropertyChanged; private void OnPropertyChanged(string propertyName) { PropertyChanged?.Invoke(this, new PropertyChangedEventArgs(propertyName)); } public bool IsShowInMap { get; set; } #endregion public UCYWTBYPDetails() { DevExpress.Xpf.Core.ThemeManager.SetTheme(this, DevExpress.Xpf.Core.Theme.Office2013LightGray); InitializeComponent(); this.DockAreas = KGIS.Framework.Views.DockStyle.DockRight; this.FloatSize = new System.Drawing.Size(390, 800); this.DefaultArea = KGIS.Framework.Views.DockStyle.DockRight; this.ShowCloseButton = true; this.ShowAutoHideButton = true; this.Title = "图斑详情(疑问图斑判读)"; this.DockWidth = 390; showDetail = true; GetDic(); Items = GetDatas(); VirtualTree = new List(); foreach (var node in Items) { if (node.Items != null) { VirtualTree.Add(new KeyValueData() { NodeID = node.ID, NodeName = node.Name }); CreateVirtualTree(node); } } this.cmbCtr.ItemsSource = VirtualTree; } public void CreateVirtualTree(TreeData node) { node.Items.ForEach(it => { var newname = it.Name; if (node.Name.StartsWith("--")) { var jc = node.Name.Count(x => x == '-') + 1; for (int i = 0; i < jc; i++) { newname = "-" + newname; } } else { newname = "--" + newname; } VirtualTree.Add(new KeyValueData() { NodeID = it.ID, NodeName = " " + newname }); CreateVirtualTree(it); }); } private void GetDic() { try { IRDBHelper rdbHelper = null; m_dic = new List(); try { string connStr = string.Format(SysConfigsOprator.GetDBConnectionByName("MDBOledbConnection"), (MapsManager.Instance.MapService.GetProjectInfo() as ProjectInfo).GetDicDataPath()); rdbHelper = RDBFactory.CreateDbHelper(connStr, DatabaseType.MSAccess); if (rdbHelper == null) { throw new Exception("数据库连接打开失败:" + connStr); } DataTable dt = rdbHelper.ExecuteDatatable("dt", "SELECT * FROM Sys_DicManage where ALIASNAME='" + "DLBM" + "'", true); if (dt != null && dt.Rows.Count > 0) { DataTable dt2 = rdbHelper.ExecuteDatatable("dt2", "SELECT * FROM Sys_DicDetail where OWNERDIC='" + dt.Rows[0]["ID"] + "'", true); dt2.DefaultView.Sort = "CODE ASC"; dt2 = dt2.DefaultView.ToTable(); Dic d1 = new Dic(); d1.ID = ""; d1.PID = ""; d1.CODE = ""; d1.NAME = ""; m_dic.Add(d1); foreach (DataRow item in dt2.Rows) { Dic d = new Dic(); d.ID = item["ID"].ToString(); d.PID = item["PID"].ToString(); d.CODE = item["CODE"].ToString(); d.NAME = item["CODE"].ToString() + "-" + item["NAME"].ToString(); m_dic.Add(d); } } } catch (Exception ex) { LogAPI.Debug("查询字典失败:" + ex); } finally { if (rdbHelper != null) { rdbHelper.DisConnect(); } } } catch (Exception ex) { LogAPI.Debug("查询字典失败:" + ex); } } private List GetDatas(string parentId = "") { List dataList = null; try { dataList = new List(); for (int i = 0; i < m_dic.Count; i++) { TreeData data = new TreeData(); if (parentId == "") { if (false == string.IsNullOrEmpty(m_dic[i].PID)) { continue; } else if (string.IsNullOrEmpty(m_dic[i].PID) && string.IsNullOrEmpty(m_dic[i].ID)) { data.ID = ""; data.Name = ""; data.Items = null; dataList.Add(data); } else { data.ID = m_dic[i].CODE; data.Name = m_dic[i].NAME; data.Items = GetDatas(m_dic[i].ID); dataList.Add(data); } } else { if (parentId.Trim().Equals(m_dic[i].PID.Trim())) { data.ID = m_dic[i].CODE; data.Name = m_dic[i].NAME; data.Items = GetDatas(m_dic[i].ID); dataList.Add(data); } } } } catch (Exception ex) { throw ex; } return dataList; } /// /// 绑定“图斑变更信息”数据 /// public void BindData(DataRow data, int pDataIndex, int pDataCount) { m_DataIndex = pDataIndex; m_DataCount = pDataCount; if (data.Table.Columns.Contains("SFJZ")) { string sfjz = data["SFJZ"].ToString(); if (!string.IsNullOrWhiteSpace(sfjz)) { if(sfjz == "1") { rbtnWYTrue.IsChecked = true; } else { rbtnWYFalse.IsChecked = true; } } else { rbtnWYTrue.IsChecked = false; rbtnWYFalse.IsChecked = false; } } else { rbtnWYTrue.IsChecked = false; rbtnWYFalse.IsChecked = false; } if (data.Table.Columns.Contains("NYYPDL")) { string nyypdl = data["NYYPDL"].ToString(); if (VirtualTree != null) { var selectnode = VirtualTree.Find(p => p.NodeID == nyypdl); if (selectnode != null) { this.cmbCtr.SelectedItem = selectnode as KeyValueData; } else { this.cmbCtr.SelectedItem = null; } } } YWTBInfo.DataContext = data; } private void BtnSave_Click(object sender, RoutedEventArgs e) { if (SaveData() == false) { return; } if (m_DataIndex == m_DataCount) { MessageHelper.Show("当前为最后一条数据!"); return; } //通知举证图斑列表显示下一条数据 Platform.Instance.SendMsg(new NotifyMsgPackage() { Content = "NextData", MsgType = "YWTBDetailView" }); } private void BtnPrev_Click(object sender, RoutedEventArgs e) { if (SaveData()==false) { return; } if (m_DataIndex == 1) { MessageHelper.Show("当前为第一条数据!"); return; } //通知举证图斑列表显示上一条数据 Platform.Instance.SendMsg(new NotifyMsgPackage() { Content = "PrevData", MsgType = "YWTBDetailView" }); } private void BtnNext_Click(object sender, RoutedEventArgs e) { if (SaveData() == false) { return; } if (m_DataIndex == m_DataCount) { MessageHelper.Show("当前为最后一条数据!"); return; } //通知举证图斑列表显示下一条数据 Platform.Instance.SendMsg(new NotifyMsgPackage() { Content = "NextData", MsgType = "YWTBDetailView" }); } private bool SaveData() { IFeatureCursor ywtbFeatureCursor = null; try { if (rbtnWYTrue.IsChecked == false && rbtnWYFalse.IsChecked == false) { MessageHelper.ShowWarning("请选择是否外业"); return false; } IFeature feature = null; IFeatureClass ywtbFC = MapsManager.Instance.MapService.GetFeatureClassByName("YWTB"); if (YWTBInfo.DataContext is DataRow) { DataRow dataRow = YWTBInfo.DataContext as DataRow; int obj = Convert.ToInt32(dataRow["OBJECTID"]); IQueryFilter queryFilter = new QueryFilterClass(); queryFilter.WhereClause = string.Format(" OBJECTID = {0}", obj); ywtbFeatureCursor = ywtbFC.Update(queryFilter, true); feature = ywtbFeatureCursor.NextFeature(); if (feature == null) return false; int index = ywtbFC.FindField("SFJZ"); if (index == -1) { IField pField = new FieldClass(); IFieldEdit pFieldEdit = pField as IFieldEdit; pFieldEdit.Name_2 = "SFJZ"; pFieldEdit.AliasName_2 = "是否举证"; pFieldEdit.Type_2 = esriFieldType.esriFieldTypeString; pFieldEdit.Length_2 = 1; ywtbFC.AddField(pField); index = ywtbFC.FindField("SFJZ"); } if (!dataRow.Table.Columns.Contains("SFJZ")) { DataColumn col = new DataColumn(); col.ColumnName = "SFJZ"; col.Caption = "是否举证"; col.MaxLength = 1; dataRow.Table.Columns.Add(col); } if (rbtnWYTrue.IsChecked == true) { feature.Value[index] = "1"; dataRow["SFJZ"] = "1"; } else if (rbtnWYFalse.IsChecked == true) { feature.Value[index] = "0"; dataRow["SFJZ"] = "0"; } index = ywtbFC.FindField("NYYPDL"); if (index == -1) { IField pField = new FieldClass(); IFieldEdit pFieldEdit = pField as IFieldEdit; pFieldEdit.Name_2 = "NYYPDL"; pFieldEdit.AliasName_2 = "内业预判地类"; pFieldEdit.Type_2 = esriFieldType.esriFieldTypeString; pFieldEdit.Length_2 = 10; ywtbFC.AddField(pField); index = ywtbFC.FindField("NYYPDL"); } if (this.cmbCtr.SelectedItem != null) { KeyValueData selectnyypdl = this.cmbCtr.SelectedItem as KeyValueData; if (selectnyypdl != null) { if (dataRow.Table.Columns.Contains("NYYPDL")) { dataRow["NYYPDL"] = selectnyypdl.NodeID; } feature.Value[index] = selectnyypdl.NodeID; } } index = ywtbFC.FindField("NYJY"); if (index == -1) { IField pField = new FieldClass(); IFieldEdit pFieldEdit = pField as IFieldEdit; pFieldEdit.Name_2 = "NYJY"; pFieldEdit.AliasName_2 = "内业建议"; pFieldEdit.Type_2 = esriFieldType.esriFieldTypeString; pFieldEdit.Length_2 = 500; ywtbFC.AddField(pField); index = ywtbFC.FindField("NYJY"); } if (dataRow.Table.Columns.Contains("NYJY")) { feature.Value[index] = dataRow["NYJY"]; } ywtbFeatureCursor.UpdateFeature(feature); ywtbFeatureCursor.Flush(); return true; } } catch (Exception ex) { LogAPI.Debug("基础信息保存失败:" + ex.Message); return false; } finally { if (ywtbFeatureCursor != null) { System.Runtime.InteropServices.Marshal.ReleaseComObject(ywtbFeatureCursor); } } return true; } public void ShowPanel() { showDetail = true; Platform.Instance.OpenView(this, false); } public void ClosePanel() { showDetail = false; Platform.Instance.CloseView(this); } public void ClosePanelInvoke() { CloseViewHandler?.Invoke(this, null); } } }