using System;
using System.Collections.Generic;
using System.Text;
using System.Drawing;
using GeoScene.Data;
using GeoScene.Engine;
using GeoScene.Globe;
using System.IO;
using System.Windows.Forms;
using System.Collections;
using System.Data;
using System.Xml;
using System.Net.NetworkInformation;
using System.Net;
using System.Security.Cryptography;
namespace Cyberpipe
{
public class Utility
{
//public static string ConnectionString;
public static string dbdatabase;
public static string userID;
public static Hashtable Pipe_QueryFields;
public static string DBPassword;
public static string DBServer;
public static string DBBackUp;
public static string serverip;
public static int serverport;
public static string localicenseserverip;
public static int localicenseserverport;
public static GSODataSource dataSource;
public static List<LayerChild> LayerChilds;
public static ArrayList LayerLabels;
public static ArrayList LayerNames;
public static ArrayList TerrainsName;
public static ArrayList LayerNamesList;
public static Hashtable LayerLabel_LayerIDs;
public static Hashtable Query_Fields = new Hashtable();
public static Hashtable Pipe_Code = new Hashtable();
public static List<PipelineType> listPipelineType;
public static string PicRootURL;
public static string PicDefaultURL;
public static double dFlyAboveLine = 2;
public static string projectStr;
public static string userId;
public static string userName;
public static string userRole;
public static List<Annex> AnnexList;
public static List<string> PipeLineNameList;
public static List<Location> locationList;
//数据配置
public static List<databaseClass> listDb;
public static string backupurl;
public static string backuppath;
//上传下载配置
public static string udserviceurl;
public static string uploadpath;
//传感器配置
public static string sensorConnectString;
public static string sensorDatabase;
public static List<MarkerLayer> sensorMarkerLayers;
//管线类型
public static string pipelinetype;
//审核库配置
public static string sgdbip;
public static string sgdbname;
public static string sgdbuser;
public static string sgdbpwd;
//规划库配置
public static string ghdbip;
public static string ghdbname;
public static string ghdbuser;
public static string ghdbpwd;
//系统综合配置
// public static string LoginImgPath;
// public static string TitleImagePath;
// public static string SysnameVersion;
// public static string Copyright;
// public static string LegendImgPath;
public static string RoleServer;
public static string AppId;
public static void SetBallons(GSOBalloon featureTooltip, GSOBalloonEx balloonEx)
{
featureTooltip.CacheFilePath = Application.StartupPath + "/GeoScene/Globe/Temp";
featureTooltip.SetSize(EnumSizeIndex.ROUNDED_CX, 0);
featureTooltip.SetSize(EnumSizeIndex.ROUNDED_CY, 0);
featureTooltip.SetSize(EnumSizeIndex.MARGIN_CX, 3);
featureTooltip.SetSize(EnumSizeIndex.MARGIN_CY, 3);
featureTooltip.SetSize(EnumSizeIndex.ANCHOR_HEIGHT, 0);
featureTooltip.SetSize(EnumSizeIndex.ANCHOR_WIDTH, 0);
featureTooltip.SetSize(EnumSizeIndex.ANCHOR_MARGIN, 0);
featureTooltip.SetSize(EnumSizeIndex.ANCHOR_OFFSET_CX, 1);
featureTooltip.SetSize(EnumSizeIndex.ANCHOR_OFFSET_CY, -1);
featureTooltip.SetDirection(EnumToolTipDirection.TD_BOTTOMEDGE_LEFT);
featureTooltip.EscapeSequencesEnabled = true;
featureTooltip.HyperlinkEnabled = true;
featureTooltip.Opaque = 30;
featureTooltip.MaxWidth = 300;
featureTooltip.SetShadow(0, 0, 50, true, 0, 0);
balloonEx.SetSize(EnumSizeIndexEx.CONTENT_CX, 500);
balloonEx.SetSize(EnumSizeIndexEx.CONTENT_CY, 300);
balloonEx.Opaque = 5;
balloonEx.SetBorder(Color.White, 1, 1);
balloonEx.SetColorBkType(EnumBkColorTypeEx.SKY);
}
public static GSOFeature FindFeatureByUserID(GSOFeatureDataset featdataset, string fieldname, string value)
{
GSOFeatures feats = featdataset.GetAllFeatures();
for (int i = 0; i < feats.Length; i++)
{
GSOFeature feat = feats[i];
if (feat.GetFieldAsString(fieldname) == value)
{
return feat;
}
}
return null;
}
public static GSOPoint2d XYZ_2_Latlon(double x, double y)
{
int id = GSOProjectManager.AddProject(projectStr);
// GeoScene.Data.GSOProjectManager.SetCurProject(id);
GSOPoint2d pt2d = new GSOPoint2d(x, y);
GSOPoint2d result = GSOProjectManager.Inverse(pt2d, id);
return result;
}
public static GSOPoint2d Latlon_2_XYZ(double lon, double lat)
{
int id = GSOProjectManager.AddProject(projectStr);
GSOPoint2d pt2d = new GSOPoint2d(lon, lat);
GSOPoint2d result = GSOProjectManager.Forward(pt2d, id);
return result;
}
/// <summary>
/// MD5加密
/// </summary>
/// <param name="pToEncrypt">要加密字符串</param>
/// <returns></returns>
public static string MD5Encrypt(string pToEncrypt)
{
string sKey = "12345678";//默认8位加密密匙
DESCryptoServiceProvider des = new DESCryptoServiceProvider();
byte[] inputByteArray = Encoding.Default.GetBytes(pToEncrypt);
des.Key = Encoding.ASCII.GetBytes(sKey);
des.IV = Encoding.ASCII.GetBytes(sKey);
MemoryStream ms = new MemoryStream();
CryptoStream cs = new CryptoStream(ms, des.CreateEncryptor(), CryptoStreamMode.Write);
cs.Write(inputByteArray, 0, inputByteArray.Length);
cs.FlushFinalBlock();
StringBuilder ret = new StringBuilder();
foreach (byte b in ms.ToArray())
{
ret.AppendFormat("{0:X2}", b);
}
ret.ToString();
return ret.ToString();
}
/// <summary>
/// MD5加密
/// </summary>
/// <param name="pToEncrypt">要加密字符串</param>
/// <returns></returns>
public static string MD5Encrypt3(string pToEncrypt)
{
MD5CryptoServiceProvider md5 = new MD5CryptoServiceProvider();
byte[] bs = Encoding.UTF8.GetBytes(pToEncrypt);
bs = md5.ComputeHash(bs);
StringBuilder s = new StringBuilder();
foreach (byte b in bs)
{
s.Append(b.ToString("x2"));
}
return s.ToString();
}
//
//MD5加密
//
public static string MD5Encrypt2(string pToEncrypt)
{
byte[] inputByteArray = Encoding.Default.GetBytes(pToEncrypt);
MD5 md5 = new MD5CryptoServiceProvider();
byte[] output = md5.ComputeHash(inputByteArray);
string ret = BitConverter.ToString(output).Replace("-", "");
ret = ret.ToLower();
return ret;
}
public static GSOFeatures Table2Features(DataTable table, string currentQueryLayer, GSOGlobeControl globeControl1)
{
GSOFeatures features = new GSOFeatures();
for (int i = 0; i < table.Rows.Count; i++)
{
DataRow row = table.Rows[i];
string featureName = row["编号"].ToString();
featureName = featureName.Trim();
//GSOLayer layer = globeControl1.Globe.Layers.GetLayerByID((int)(Utility.LayerLabel_LayerIDs[currentQueryLayer]));
GSOLayer layer = globeControl1.Globe.Layers.GetLayerByCaption(currentQueryLayer);
GSOFeatures tempfeatures = layer.GetFeatureByName(featureName, false);
if (tempfeatures.Length > 0)
{
features.Add(tempfeatures[0]);
}
}
return features;
}
public static string filename = Application.StartupPath + "\\Config.xml";
public static string filenameSensor = Application.StartupPath + "\\sensorConfig.xml";
public static string filenamePipelineType = Application.StartupPath + "\\PipelineType.xml";
public static string filenameDbconfig = Application.StartupPath + "\\databaseConfig.xml";
public static string filenameAnnex = Application.StartupPath + "\\annex.xml";
public static string filenamePipeLineName = Application.StartupPath + "\\PipeLineName.xml";
public static string filenameLocation = Application.StartupPath + "\\Location.xml";
//程序启动的时候读取配置文件
public static void SetParams()
{
#region 读取 filename "Config.xml"
LayerChilds = new List<LayerChild>();
LayerLabels = new ArrayList();
TerrainsName = new ArrayList();
LayerNames = new ArrayList();
LayerNamesList = new ArrayList();
LayerLabel_LayerIDs = new Hashtable();
if (File.Exists(filename))
{
XmlTextReader XmlReader = new XmlTextReader(filename);
try
{
while (XmlReader.Read())
{
if (XmlReader.Name == "database")
{
dbdatabase = XmlReader.ReadElementString();
}
else if (XmlReader.Name == "dbpassword")
{
DBPassword = XmlReader.ReadElementString();
}
else if (XmlReader.Name == "user")
{
userID = XmlReader.ReadElementString();
}
else if (XmlReader.Name == "locaserverip")
{
serverip = XmlReader.ReadElementString();
}
else if (XmlReader.Name == "locaserverport")
{
serverport = Convert.ToInt32(XmlReader.ReadElementString());
}
else if (XmlReader.Name == "localicenseserverip")
{
localicenseserverip = XmlReader.ReadElementString();
}
else if (XmlReader.Name == "localicenseserverport")
{
localicenseserverport = Convert.ToInt32(XmlReader.ReadElementString());
}
else if (XmlReader.Name == "dbbackuppath")
{
DBBackUp = XmlReader.ReadElementString();
}
else if (XmlReader.Name == "layerchild")
{
LayerChild child = new LayerChild();
child.attriLabel = XmlReader["label"].Trim();
child.attriLayer = XmlReader["layer"].Trim();
child.attriType = XmlReader["type"].Trim();
LayerChilds.Add(child);
LayerLabels.Add(XmlReader["label"].Trim());
LayerNames.Add(XmlReader["layer"].Trim());
string layername = XmlReader["layer"].Trim();
if (layername.EndsWith("管线"))
{
LayerNamesList.Add(layername.Substring(0, layername.Length - 2));
}
}
else if (XmlReader.Name == "Terrain")
{
TerrainsName.Add(XmlReader.ReadElementString());
}
else if (XmlReader.Name == "dbserver")
{
DBServer = XmlReader.ReadElementString();
}
else if (XmlReader.Name == "rooturl")
{
PicRootURL = XmlReader.ReadElementString();
}
else if (XmlReader.Name == "defaultimgurl")
{
PicDefaultURL = XmlReader.ReadElementString();
}
else if (XmlReader.Name == "queryfield")
{
Query_Fields.Add(XmlReader["label"], XmlReader.ReadElementString());
}
else if (XmlReader.Name == "pipelineCode")
{
Pipe_Code.Add(XmlReader["label"], XmlReader.ReadElementString());
}
else if (XmlReader.Name == "projectStr")
{
projectStr = XmlReader.ReadElementString();
}
else if (XmlReader.Name == "backupserverurl")
{
backupurl = XmlReader.ReadElementString();
}
else if (XmlReader.Name == "backuppath")
{
backuppath = XmlReader.ReadElementString();
}
else if (XmlReader.Name == "uploadpath")
{
uploadpath = XmlReader.ReadElementString();
}
else if (XmlReader.Name == "udserviceurl")
{
udserviceurl = XmlReader.ReadElementString();
}
else if (XmlReader.Name == "pipelinetype")
{
pipelinetype = XmlReader.ReadElementString();
}
else if (XmlReader.Name == "shdbip")
{
sgdbip = XmlReader.ReadElementString();
}
else if (XmlReader.Name == "shdbname")
{
sgdbname = XmlReader.ReadElementString();
}
else if (XmlReader.Name == "shdbuser")
{
sgdbuser = XmlReader.ReadElementString();
}
else if (XmlReader.Name == "shdbpwd")
{
sgdbpwd = XmlReader.ReadElementString();
}
else if (XmlReader.Name == "ghdbip")
{
ghdbip = XmlReader.ReadElementString();
}
else if (XmlReader.Name == "ghdbname")
{
ghdbname = XmlReader.ReadElementString();
}
else if (XmlReader.Name == "ghdbuser")
{
ghdbuser = XmlReader.ReadElementString();
}
else if (XmlReader.Name == "ghdbpwd")
{
ghdbpwd = XmlReader.ReadElementString();
}
}
}
catch (Exception ex)
{
//LogError.PublishError(ex);
}
finally
{
XmlReader.Close();
}
}
else
{
MessageBox.Show("配置文件" + filename + "不存在！", "提示");
}
#endregion
#region 读取 filenameSensor "sensorConfig.xml"
sensorMarkerLayers = new List<MarkerLayer>();
if (File.Exists(filenameSensor))
{
XmlTextReader XmlReader = new XmlTextReader(filenameSensor);
try
{
while (XmlReader.Read())
{
if (XmlReader.Name == "ConnectString")
{
string dbserver = XmlReader["dbserver"].Trim();
string dbserverport = XmlReader["dbserverport"].Trim();
string database = XmlReader["database"].Trim();
string username = XmlReader["username"].Trim();
string password = XmlReader["password"].Trim();
sensorDatabase = database;
sensorConnectString = "Server=" + dbserver + ";Port=" + dbserverport + ";Database=" + database + ";Uid=" + username + ";Pwd=" + password + "";
}
else if (XmlReader.Name == "MarkerLayer")
{
MarkerLayer markerLayer = new MarkerLayer();
string layerName = XmlReader["layerName"].Trim();
string tableName = XmlReader["tableName"].Trim();
markerLayer.layerName = layerName;
markerLayer.tableName = tableName;
Dictionary<string, string> fields = new Dictionary<string, string>();
XmlReader.ReadSubtree();
while (XmlReader.Read())
{
if (XmlReader.Name == "field")
{
string name = XmlReader["name"].Trim();
string label = XmlReader["label"].Trim();
fields.Add(name, label);
}
else if (XmlReader.Name == "MarkerLayer")
{
break;
}
}
markerLayer.fields = fields;
sensorMarkerLayers.Add(markerLayer);
}
}
}
catch (Exception ex)
{
//LogError.PublishError(ex);
}
finally
{
XmlReader.Close();
}
}
else
{
MessageBox.Show("配置文件" + filenameSensor + "不存在！", "提示");
}
#endregion
#region 读取 filenamePipelineType "PipelineType.xml"
listPipelineType = new List<PipelineType>();
if (File.Exists(filenamePipelineType))
{
XmlTextReader XmlReader = new XmlTextReader(filenamePipelineType);
try
{
while (XmlReader.Read())
{
if (XmlReader.Name == "PipelineCode")
{
string pipelinecode = XmlReader["code"] == null ? null : XmlReader["code"].Trim();
string pipelinename = XmlReader["name"] == null ? null : XmlReader["name"].Trim();
string pipelinetype = XmlReader["type"] == null ? null : XmlReader["type"].Trim();
if (pipelinecode != null && pipelinename != null && pipelinetype != null)
{
PipelineType pipelineType = new PipelineType(pipelinecode, pipelinename, pipelinetype);
if (listPipelineType.Contains(pipelineType) == false)
{
listPipelineType.Add(pipelineType);
}
}
}
}
}
catch (Exception ex)
{
//LogError.PublishError(ex);
}
finally
{
XmlReader.Close();
}
}
else
{
MessageBox.Show("配置文件" + filenamePipelineType + "不存在！", "提示");
}
#endregion
#region 读取 database "databaseConfig.xml"
listDb = new List<databaseClass>();
if (File.Exists(filenameDbconfig))
{
try
{
XmlDocument doc = new XmlDocument();
doc.Load(filenameDbconfig);
XmlNode xn = doc.SelectSingleNode("Database");
// 得到根节点的所有子节点
//if (xn == null) return;//增加为空判断
XmlNodeList xnl = xn.ChildNodes;
foreach (XmlNode xn1 in xnl)
{
databaseClass model = new databaseClass();
XmlElement xe = (XmlElement)xn1;// 将节点转换为元素，便于得到节点的属性值
model.title = xe.GetAttribute("title");
// 得到database节点的所有子节点
XmlNodeList xnl0 = xe.ChildNodes;
model.dbip = xnl0.Item(0).InnerText;
model.database = xnl0.Item(1).InnerText;
model.dbuser = xnl0.Item(2).InnerText;
model.dbpassword = xnl0.Item(3).InnerText;
listDb.Add(model);
}
}
catch (Exception ex)
{
//LogError.PublishError(ex);
}
//finally
//{
// doc.Close();
//}
}
else
{
MessageBox.Show("配置文件" + filenameDbconfig + "不存在！", "提示");
}
#endregion
#region 读取管线附属物名称
XmlTextReader XmlReaderAnnex = null;
try
{
if (File.Exists(filenameAnnex))
{
AnnexList = new List<Annex>();
AnnexList.Add(new Annex("", ""));
XmlReaderAnnex = new XmlTextReader(filenameAnnex);
while (XmlReaderAnnex.Read())
{
if (XmlReaderAnnex.Name == "annex")
{
string name = XmlReaderAnnex["name"] == null ? null : XmlReaderAnnex["name"].Trim();
string pipe = XmlReaderAnnex["pipe"] == null ? null : XmlReaderAnnex["pipe"].Trim();
if (name != null && pipe != null)
{
AnnexList.Add(new Annex(pipe, name));
}
}
}
}
}
catch (Exception ex)
{
//LogError.PublishError(ex);
}
finally
{
if (null != XmlReaderAnnex)
{
XmlReaderAnnex.Close();
}
}
#endregion
#region 读取管线名称
XmlTextReader XmlReaderPipe = null;
try
{
if (File.Exists(filenamePipeLineName))
{
PipeLineNameList = new List<string>();
PipeLineNameList.Add("");
XmlReaderPipe = new XmlTextReader(filenamePipeLineName);
while (XmlReaderPipe.Read())
{
if (XmlReaderPipe.Name == "pipeline")
{
string name = XmlReaderPipe["name"] == null ? null : XmlReaderPipe["name"].Trim();
if (name != null)
{
PipeLineNameList.Add(name);
}
}
}
}
}
catch (Exception ex)
{
//LogError.PublishError(ex);
}
finally
{
if (null != XmlReaderPipe)
{
XmlReaderPipe.Close();
}
}
#endregion
#region 读取快速定位点
XmlTextReader XmlReaderLocation = null;
try
{
if (File.Exists(filenameLocation))
{
locationList = new List<Location>();
locationList.Add(new Location("", "", "", ""));
XmlReaderLocation = new XmlTextReader(filenameLocation);
while (XmlReaderLocation.Read())
{
if (XmlReaderLocation.Name == "location")
{
string name = XmlReaderLocation["name"] == null ? null : XmlReaderLocation["name"].Trim();
string x = XmlReaderLocation["x"] == null ? null : XmlReaderLocation["x"].Trim();
string y = XmlReaderLocation["y"] == null ? null : XmlReaderLocation["y"].Trim();
string z = XmlReaderLocation["z"] == null ? null : XmlReaderLocation["z"].Trim();
if (name != null)
{
locationList.Add(new Location(name, x, y, z));
}
}
}
}
}
catch (Exception ex)
{
//LogError.PublishError(ex);
}
finally
{
if (null != XmlReaderLocation)
{
XmlReaderLocation.Close();
}
}
#endregion
}
/// <summary>
/// 获取Config.xml配置文件中的roleurl、titleimgpath、sysname、copyright配置
/// </summary>
/// <returns></returns>
public static void SysInfoConfig()
{
if (!File.Exists(filename)) return;
XmlTextReader xmlReader = new XmlTextReader(filename);
try
{
while (xmlReader.Read())
{
if (xmlReader.Name.Equals("roleurl"))
{
RoleServer = xmlReader.ReadElementString();
}
else if (xmlReader.Name.Equals("appid"))
{
AppId = xmlReader.ReadElementString();
}
// else if (xmlReader.Name.Equals("titleimgpath"))
// {
// TitleImagePath = xmlReader.ReadElementString();
// }
// else if (xmlReader.Name.Equals("sysname"))
// {
// SysnameVersion = xmlReader.ReadElementString();
// }
// else if (xmlReader.Name.Equals("copyright"))
// {
// Copyright = xmlReader.ReadElementString();
// }
// else if (xmlReader.Name.Equals("legendimg"))
// {
// LegendImgPath = xmlReader.ReadElementString();
// }
// else if (xmlReader.Name.Equals("loginimgpath"))
// {
// LoginImgPath = xmlReader.ReadElementString();
// }
}
}
catch (Exception ex)
{
LogHelper.WriteLog(typeof(Utility),"获取系统配置信息出错！");
}
finally
{
xmlReader.Close();
}
}
public static bool isNetworkConnectionSuccess(string ipAdress)
{
return true;
//if (ipAdress == null)
//{
// return false;
//}
//if (ipAdress.Contains("\\"))
//{
// ipAdress = ipAdress.Substring(0, ipAdress.LastIndexOf('\\'));
//}
///if (ipAdress.Trim() == "localhost" || ipAdress.Trim() == "127.0.0.1" || ipAdress.Trim() == Dns.GetHostName())
//{
// return true;
//}
//Ping ping = new Ping();
//try
//{
// PingReply pr = ping.Send(ipAdress.Trim(), 3000);
// if (pr.Status == IPStatus.Success)
// {
// return true;
// }
// else
// {
// return false;
// }
//}
//catch (Exception ex)
//{
// LogError.PublishError(ex);
// return false;
// }
}
////根据图层中的对象特征来划分内容
public static string getCodeByName(string name)
{
string code = "";
if (listPipelineType != null)
{
List<PipelineType> list = listPipelineType;
for (int i = 0; i < list.Count; i++)
{
PipelineType pipelineType = listPipelineType[i];
if (name == pipelineType.name)
{
code = pipelineType.code;
break;
}
else
{
continue;
}
}
}
return code;
}
//根据附属物图层名字得到里面含有的附属物
public static string[] getAccStrsByLayer(string layername)
{
string[] accStrs = null;
string sql = "select 附属物名称 from " + layername + " group by 附属物名称";
//DataTable table = OledbHelper.QueryTable(sql);
DataSet dataset = OledbHelper.getDataSet(sql, layername);
if (dataset != null)
{
accStrs = new string[dataset.Tables[0].Rows.Count];
for (int i = 0; i < dataset.Tables[0].Rows.Count; i++)
{
accStrs[i] = dataset.Tables[0].Rows[i][0].ToString();
}
return accStrs;
}
else
{
return accStrs;
}
}
//删除内存图层中指定名称的feature
public static void RemoveFeatureFromName(GSOGlobeControl globeControl1, string featureName)
{
GSOFeatures features = globeControl1.Globe.MemoryLayer.GetFeatureByName(featureName, true);
if (features != null)
{
for (int i = features.Length - 1; i >= 0; i--)
{
GSOFeature feature = features[i];
if (feature != null)
{
globeControl1.Globe.MemoryLayer.RemoveFeatureByID(feature.ID);
}
}
}
globeControl1.Refresh();
}
}
}
