diff --git a/GXBuilder.cs b/GXBuilder.cs index b2ec9b2..f085bdd 100644 --- a/GXBuilder.cs +++ b/GXBuilder.cs @@ -90,8 +90,13 @@ ? "" : feature.GetValue("DEVICEID").ToString(); String road = feature.GetValue("ROAD") == null ? "" : feature.GetValue("ROAD").ToString(); + String ownerName = feature.GetValue("ATTACHID") == null + ? "" : feature.GetValue("ATTACHID").ToString(); + if (deviceType == "" || ownerName == "") + { + return false; + } - //TODO LIST: string sqlCount = "select dbid from alarm_device_type where" + " typename = '" + deviceType + "'"; object dbid = OracleUtils.ExecuteScalar(OracleUtils.ConnectionString, @@ -101,11 +106,23 @@ return false; } int deviceTypeId = int.Parse(dbid.ToString()); + + //TODO LIST:查找对应的设备负责人: + string sqlPerson = "select dbid from alarm_accept_person where" + + " personname= '" + ownerName + "'"; + object dbid0 = OracleUtils.ExecuteScalar(OracleUtils.ConnectionString, + CommandType.Text, sqlPerson); + if (dbid0 == null) + { + return false; + } + int personId = int.Parse(dbid0.ToString()); + string sql = "Insert into alarm_device (DBID,ACTIVE,DEVCODE,DEVNAME,FACTORY," + - "INSTALLDATE,GAOCHENG,HEIGHT,LATITUDE,LONGTITUDE,DEVICETYPE_ID) " + + "INSTALLDATE,GAOCHENG,HEIGHT,LATITUDE,LONGTITUDE,DEVICETYPE_ID,ACCEPTPERSON_ID) " + "values (SEQ_DEVICE_ID.NEXTVAL, 1, '" + devCode + "', '" + deviceType + devCode + "', " + "'航天二院', " + "to_date('" + DateTime.Now.ToString() + "','yyyy/MM/dd hh24:mi::ss'), " - + "0, 0, 0, 0, " + deviceTypeId + ")"; + + "0, 0, 0, 0, " + deviceTypeId + ", "+personId+")"; OracleUtils.ExecuteNonQuery(OracleUtils.ConnectionString, CommandType.Text, sql); } @@ -124,6 +141,8 @@ ? "" : newFeature.GetValue("DEVICEID").ToString(); String road = newFeature.GetValue("ROAD") == null ? "" : newFeature.GetValue("ROAD").ToString(); + String ownerName = newFeature.GetValue("ATTACHID") == null + ? "" : newFeature.GetValue("ATTACHID").ToString(); feature.Geometry = newFeature.Geometry.Clone(); this.setFeatureValueByShapeFeature(newFeature,feature); @@ -139,9 +158,21 @@ } int deviceTypeId = int.Parse(dbid.ToString()); + //查找负责人ID + string sqlPerson = "select dbid from alarm_accept_person where" + + " personname= '" + ownerName + "'"; + object dbid0 = OracleUtils.ExecuteScalar(OracleUtils.ConnectionString, + CommandType.Text, sqlPerson); + if (dbid0 == null) + { + return false; + } + int personId = int.Parse(dbid0.ToString()); + string sql = "update alarm_device set FACTORY='" + road + "', DEVICETYPE_ID='" + deviceTypeId + "', DEVNAME='"+deviceType+devCode+"' "+ + ", ACCEPTPERSON_ID='"+personId+"' "+ "where devcode='" + devCode + "'"; OracleUtils.ExecuteNonQuery(OracleUtils.ConnectionString, CommandType.Text, sql); return true; diff --git a/GXBuilder.cs b/GXBuilder.cs index b2ec9b2..f085bdd 100644 --- a/GXBuilder.cs +++ b/GXBuilder.cs @@ -90,8 +90,13 @@ ? "" : feature.GetValue("DEVICEID").ToString(); String road = feature.GetValue("ROAD") == null ? "" : feature.GetValue("ROAD").ToString(); + String ownerName = feature.GetValue("ATTACHID") == null + ? "" : feature.GetValue("ATTACHID").ToString(); + if (deviceType == "" || ownerName == "") + { + return false; + } - //TODO LIST: string sqlCount = "select dbid from alarm_device_type where" + " typename = '" + deviceType + "'"; object dbid = OracleUtils.ExecuteScalar(OracleUtils.ConnectionString, @@ -101,11 +106,23 @@ return false; } int deviceTypeId = int.Parse(dbid.ToString()); + + //TODO LIST:查找对应的设备负责人: + string sqlPerson = "select dbid from alarm_accept_person where" + + " personname= '" + ownerName + "'"; + object dbid0 = OracleUtils.ExecuteScalar(OracleUtils.ConnectionString, + CommandType.Text, sqlPerson); + if (dbid0 == null) + { + return false; + } + int personId = int.Parse(dbid0.ToString()); + string sql = "Insert into alarm_device (DBID,ACTIVE,DEVCODE,DEVNAME,FACTORY," + - "INSTALLDATE,GAOCHENG,HEIGHT,LATITUDE,LONGTITUDE,DEVICETYPE_ID) " + + "INSTALLDATE,GAOCHENG,HEIGHT,LATITUDE,LONGTITUDE,DEVICETYPE_ID,ACCEPTPERSON_ID) " + "values (SEQ_DEVICE_ID.NEXTVAL, 1, '" + devCode + "', '" + deviceType + devCode + "', " + "'航天二院', " + "to_date('" + DateTime.Now.ToString() + "','yyyy/MM/dd hh24:mi::ss'), " - + "0, 0, 0, 0, " + deviceTypeId + ")"; + + "0, 0, 0, 0, " + deviceTypeId + ", "+personId+")"; OracleUtils.ExecuteNonQuery(OracleUtils.ConnectionString, CommandType.Text, sql); } @@ -124,6 +141,8 @@ ? "" : newFeature.GetValue("DEVICEID").ToString(); String road = newFeature.GetValue("ROAD") == null ? "" : newFeature.GetValue("ROAD").ToString(); + String ownerName = newFeature.GetValue("ATTACHID") == null + ? "" : newFeature.GetValue("ATTACHID").ToString(); feature.Geometry = newFeature.Geometry.Clone(); this.setFeatureValueByShapeFeature(newFeature,feature); @@ -139,9 +158,21 @@ } int deviceTypeId = int.Parse(dbid.ToString()); + //查找负责人ID + string sqlPerson = "select dbid from alarm_accept_person where" + + " personname= '" + ownerName + "'"; + object dbid0 = OracleUtils.ExecuteScalar(OracleUtils.ConnectionString, + CommandType.Text, sqlPerson); + if (dbid0 == null) + { + return false; + } + int personId = int.Parse(dbid0.ToString()); + string sql = "update alarm_device set FACTORY='" + road + "', DEVICETYPE_ID='" + deviceTypeId + "', DEVNAME='"+deviceType+devCode+"' "+ + ", ACCEPTPERSON_ID='"+personId+"' "+ "where devcode='" + devCode + "'"; OracleUtils.ExecuteNonQuery(OracleUtils.ConnectionString, CommandType.Text, sql); return true; diff --git a/LSPipeline.suo b/LSPipeline.suo index 92b5d7d..d03429a 100644 --- a/LSPipeline.suo +++ b/LSPipeline.suo Binary files differ diff --git a/GXBuilder.cs b/GXBuilder.cs index b2ec9b2..f085bdd 100644 --- a/GXBuilder.cs +++ b/GXBuilder.cs @@ -90,8 +90,13 @@ ? "" : feature.GetValue("DEVICEID").ToString(); String road = feature.GetValue("ROAD") == null ? "" : feature.GetValue("ROAD").ToString(); + String ownerName = feature.GetValue("ATTACHID") == null + ? "" : feature.GetValue("ATTACHID").ToString(); + if (deviceType == "" || ownerName == "") + { + return false; + } - //TODO LIST: string sqlCount = "select dbid from alarm_device_type where" + " typename = '" + deviceType + "'"; object dbid = OracleUtils.ExecuteScalar(OracleUtils.ConnectionString, @@ -101,11 +106,23 @@ return false; } int deviceTypeId = int.Parse(dbid.ToString()); + + //TODO LIST:查找对应的设备负责人: + string sqlPerson = "select dbid from alarm_accept_person where" + + " personname= '" + ownerName + "'"; + object dbid0 = OracleUtils.ExecuteScalar(OracleUtils.ConnectionString, + CommandType.Text, sqlPerson); + if (dbid0 == null) + { + return false; + } + int personId = int.Parse(dbid0.ToString()); + string sql = "Insert into alarm_device (DBID,ACTIVE,DEVCODE,DEVNAME,FACTORY," + - "INSTALLDATE,GAOCHENG,HEIGHT,LATITUDE,LONGTITUDE,DEVICETYPE_ID) " + + "INSTALLDATE,GAOCHENG,HEIGHT,LATITUDE,LONGTITUDE,DEVICETYPE_ID,ACCEPTPERSON_ID) " + "values (SEQ_DEVICE_ID.NEXTVAL, 1, '" + devCode + "', '" + deviceType + devCode + "', " + "'航天二院', " + "to_date('" + DateTime.Now.ToString() + "','yyyy/MM/dd hh24:mi::ss'), " - + "0, 0, 0, 0, " + deviceTypeId + ")"; + + "0, 0, 0, 0, " + deviceTypeId + ", "+personId+")"; OracleUtils.ExecuteNonQuery(OracleUtils.ConnectionString, CommandType.Text, sql); } @@ -124,6 +141,8 @@ ? "" : newFeature.GetValue("DEVICEID").ToString(); String road = newFeature.GetValue("ROAD") == null ? "" : newFeature.GetValue("ROAD").ToString(); + String ownerName = newFeature.GetValue("ATTACHID") == null + ? "" : newFeature.GetValue("ATTACHID").ToString(); feature.Geometry = newFeature.Geometry.Clone(); this.setFeatureValueByShapeFeature(newFeature,feature); @@ -139,9 +158,21 @@ } int deviceTypeId = int.Parse(dbid.ToString()); + //查找负责人ID + string sqlPerson = "select dbid from alarm_accept_person where" + + " personname= '" + ownerName + "'"; + object dbid0 = OracleUtils.ExecuteScalar(OracleUtils.ConnectionString, + CommandType.Text, sqlPerson); + if (dbid0 == null) + { + return false; + } + int personId = int.Parse(dbid0.ToString()); + string sql = "update alarm_device set FACTORY='" + road + "', DEVICETYPE_ID='" + deviceTypeId + "', DEVNAME='"+deviceType+devCode+"' "+ + ", ACCEPTPERSON_ID='"+personId+"' "+ "where devcode='" + devCode + "'"; OracleUtils.ExecuteNonQuery(OracleUtils.ConnectionString, CommandType.Text, sql); return true; diff --git a/LSPipeline.suo b/LSPipeline.suo index 92b5d7d..d03429a 100644 --- a/LSPipeline.suo +++ b/LSPipeline.suo Binary files differ diff --git a/bin/x64/Debug/LSPipeline.exe b/bin/x64/Debug/LSPipeline.exe index 76f838b..e69b6ec 100644 --- a/bin/x64/Debug/LSPipeline.exe +++ b/bin/x64/Debug/LSPipeline.exe Binary files differ diff --git a/GXBuilder.cs b/GXBuilder.cs index b2ec9b2..f085bdd 100644 --- a/GXBuilder.cs +++ b/GXBuilder.cs @@ -90,8 +90,13 @@ ? "" : feature.GetValue("DEVICEID").ToString(); String road = feature.GetValue("ROAD") == null ? "" : feature.GetValue("ROAD").ToString(); + String ownerName = feature.GetValue("ATTACHID") == null + ? "" : feature.GetValue("ATTACHID").ToString(); + if (deviceType == "" || ownerName == "") + { + return false; + } - //TODO LIST: string sqlCount = "select dbid from alarm_device_type where" + " typename = '" + deviceType + "'"; object dbid = OracleUtils.ExecuteScalar(OracleUtils.ConnectionString, @@ -101,11 +106,23 @@ return false; } int deviceTypeId = int.Parse(dbid.ToString()); + + //TODO LIST:查找对应的设备负责人: + string sqlPerson = "select dbid from alarm_accept_person where" + + " personname= '" + ownerName + "'"; + object dbid0 = OracleUtils.ExecuteScalar(OracleUtils.ConnectionString, + CommandType.Text, sqlPerson); + if (dbid0 == null) + { + return false; + } + int personId = int.Parse(dbid0.ToString()); + string sql = "Insert into alarm_device (DBID,ACTIVE,DEVCODE,DEVNAME,FACTORY," + - "INSTALLDATE,GAOCHENG,HEIGHT,LATITUDE,LONGTITUDE,DEVICETYPE_ID) " + + "INSTALLDATE,GAOCHENG,HEIGHT,LATITUDE,LONGTITUDE,DEVICETYPE_ID,ACCEPTPERSON_ID) " + "values (SEQ_DEVICE_ID.NEXTVAL, 1, '" + devCode + "', '" + deviceType + devCode + "', " + "'航天二院', " + "to_date('" + DateTime.Now.ToString() + "','yyyy/MM/dd hh24:mi::ss'), " - + "0, 0, 0, 0, " + deviceTypeId + ")"; + + "0, 0, 0, 0, " + deviceTypeId + ", "+personId+")"; OracleUtils.ExecuteNonQuery(OracleUtils.ConnectionString, CommandType.Text, sql); } @@ -124,6 +141,8 @@ ? "" : newFeature.GetValue("DEVICEID").ToString(); String road = newFeature.GetValue("ROAD") == null ? "" : newFeature.GetValue("ROAD").ToString(); + String ownerName = newFeature.GetValue("ATTACHID") == null + ? "" : newFeature.GetValue("ATTACHID").ToString(); feature.Geometry = newFeature.Geometry.Clone(); this.setFeatureValueByShapeFeature(newFeature,feature); @@ -139,9 +158,21 @@ } int deviceTypeId = int.Parse(dbid.ToString()); + //查找负责人ID + string sqlPerson = "select dbid from alarm_accept_person where" + + " personname= '" + ownerName + "'"; + object dbid0 = OracleUtils.ExecuteScalar(OracleUtils.ConnectionString, + CommandType.Text, sqlPerson); + if (dbid0 == null) + { + return false; + } + int personId = int.Parse(dbid0.ToString()); + string sql = "update alarm_device set FACTORY='" + road + "', DEVICETYPE_ID='" + deviceTypeId + "', DEVNAME='"+deviceType+devCode+"' "+ + ", ACCEPTPERSON_ID='"+personId+"' "+ "where devcode='" + devCode + "'"; OracleUtils.ExecuteNonQuery(OracleUtils.ConnectionString, CommandType.Text, sql); return true; diff --git a/LSPipeline.suo b/LSPipeline.suo index 92b5d7d..d03429a 100644 --- a/LSPipeline.suo +++ b/LSPipeline.suo Binary files differ diff --git a/bin/x64/Debug/LSPipeline.exe b/bin/x64/Debug/LSPipeline.exe index 76f838b..e69b6ec 100644 --- a/bin/x64/Debug/LSPipeline.exe +++ b/bin/x64/Debug/LSPipeline.exe Binary files differ diff --git a/bin/x64/Debug/LSPipeline.pdb b/bin/x64/Debug/LSPipeline.pdb index 28c81dc..a0bafd0 100644 --- a/bin/x64/Debug/LSPipeline.pdb +++ b/bin/x64/Debug/LSPipeline.pdb Binary files differ diff --git a/GXBuilder.cs b/GXBuilder.cs index b2ec9b2..f085bdd 100644 --- a/GXBuilder.cs +++ b/GXBuilder.cs @@ -90,8 +90,13 @@ ? "" : feature.GetValue("DEVICEID").ToString(); String road = feature.GetValue("ROAD") == null ? "" : feature.GetValue("ROAD").ToString(); + String ownerName = feature.GetValue("ATTACHID") == null + ? "" : feature.GetValue("ATTACHID").ToString(); + if (deviceType == "" || ownerName == "") + { + return false; + } - //TODO LIST: string sqlCount = "select dbid from alarm_device_type where" + " typename = '" + deviceType + "'"; object dbid = OracleUtils.ExecuteScalar(OracleUtils.ConnectionString, @@ -101,11 +106,23 @@ return false; } int deviceTypeId = int.Parse(dbid.ToString()); + + //TODO LIST:查找对应的设备负责人: + string sqlPerson = "select dbid from alarm_accept_person where" + + " personname= '" + ownerName + "'"; + object dbid0 = OracleUtils.ExecuteScalar(OracleUtils.ConnectionString, + CommandType.Text, sqlPerson); + if (dbid0 == null) + { + return false; + } + int personId = int.Parse(dbid0.ToString()); + string sql = "Insert into alarm_device (DBID,ACTIVE,DEVCODE,DEVNAME,FACTORY," + - "INSTALLDATE,GAOCHENG,HEIGHT,LATITUDE,LONGTITUDE,DEVICETYPE_ID) " + + "INSTALLDATE,GAOCHENG,HEIGHT,LATITUDE,LONGTITUDE,DEVICETYPE_ID,ACCEPTPERSON_ID) " + "values (SEQ_DEVICE_ID.NEXTVAL, 1, '" + devCode + "', '" + deviceType + devCode + "', " + "'航天二院', " + "to_date('" + DateTime.Now.ToString() + "','yyyy/MM/dd hh24:mi::ss'), " - + "0, 0, 0, 0, " + deviceTypeId + ")"; + + "0, 0, 0, 0, " + deviceTypeId + ", "+personId+")"; OracleUtils.ExecuteNonQuery(OracleUtils.ConnectionString, CommandType.Text, sql); } @@ -124,6 +141,8 @@ ? "" : newFeature.GetValue("DEVICEID").ToString(); String road = newFeature.GetValue("ROAD") == null ? "" : newFeature.GetValue("ROAD").ToString(); + String ownerName = newFeature.GetValue("ATTACHID") == null + ? "" : newFeature.GetValue("ATTACHID").ToString(); feature.Geometry = newFeature.Geometry.Clone(); this.setFeatureValueByShapeFeature(newFeature,feature); @@ -139,9 +158,21 @@ } int deviceTypeId = int.Parse(dbid.ToString()); + //查找负责人ID + string sqlPerson = "select dbid from alarm_accept_person where" + + " personname= '" + ownerName + "'"; + object dbid0 = OracleUtils.ExecuteScalar(OracleUtils.ConnectionString, + CommandType.Text, sqlPerson); + if (dbid0 == null) + { + return false; + } + int personId = int.Parse(dbid0.ToString()); + string sql = "update alarm_device set FACTORY='" + road + "', DEVICETYPE_ID='" + deviceTypeId + "', DEVNAME='"+deviceType+devCode+"' "+ + ", ACCEPTPERSON_ID='"+personId+"' "+ "where devcode='" + devCode + "'"; OracleUtils.ExecuteNonQuery(OracleUtils.ConnectionString, CommandType.Text, sql); return true; diff --git a/LSPipeline.suo b/LSPipeline.suo index 92b5d7d..d03429a 100644 --- a/LSPipeline.suo +++ b/LSPipeline.suo Binary files differ diff --git a/bin/x64/Debug/LSPipeline.exe b/bin/x64/Debug/LSPipeline.exe index 76f838b..e69b6ec 100644 --- a/bin/x64/Debug/LSPipeline.exe +++ b/bin/x64/Debug/LSPipeline.exe Binary files differ diff --git a/bin/x64/Debug/LSPipeline.pdb b/bin/x64/Debug/LSPipeline.pdb index 28c81dc..a0bafd0 100644 --- a/bin/x64/Debug/LSPipeline.pdb +++ b/bin/x64/Debug/LSPipeline.pdb Binary files differ diff --git a/bin/x64/Debug/glVersion.txt b/bin/x64/Debug/glVersion.txt index c004f47..6a37ce0 100644 --- a/bin/x64/Debug/glVersion.txt +++ b/bin/x64/Debug/glVersion.txt Binary files differ diff --git a/GXBuilder.cs b/GXBuilder.cs index b2ec9b2..f085bdd 100644 --- a/GXBuilder.cs +++ b/GXBuilder.cs @@ -90,8 +90,13 @@ ? "" : feature.GetValue("DEVICEID").ToString(); String road = feature.GetValue("ROAD") == null ? "" : feature.GetValue("ROAD").ToString(); + String ownerName = feature.GetValue("ATTACHID") == null + ? "" : feature.GetValue("ATTACHID").ToString(); + if (deviceType == "" || ownerName == "") + { + return false; + } - //TODO LIST: string sqlCount = "select dbid from alarm_device_type where" + " typename = '" + deviceType + "'"; object dbid = OracleUtils.ExecuteScalar(OracleUtils.ConnectionString, @@ -101,11 +106,23 @@ return false; } int deviceTypeId = int.Parse(dbid.ToString()); + + //TODO LIST:查找对应的设备负责人: + string sqlPerson = "select dbid from alarm_accept_person where" + + " personname= '" + ownerName + "'"; + object dbid0 = OracleUtils.ExecuteScalar(OracleUtils.ConnectionString, + CommandType.Text, sqlPerson); + if (dbid0 == null) + { + return false; + } + int personId = int.Parse(dbid0.ToString()); + string sql = "Insert into alarm_device (DBID,ACTIVE,DEVCODE,DEVNAME,FACTORY," + - "INSTALLDATE,GAOCHENG,HEIGHT,LATITUDE,LONGTITUDE,DEVICETYPE_ID) " + + "INSTALLDATE,GAOCHENG,HEIGHT,LATITUDE,LONGTITUDE,DEVICETYPE_ID,ACCEPTPERSON_ID) " + "values (SEQ_DEVICE_ID.NEXTVAL, 1, '" + devCode + "', '" + deviceType + devCode + "', " + "'航天二院', " + "to_date('" + DateTime.Now.ToString() + "','yyyy/MM/dd hh24:mi::ss'), " - + "0, 0, 0, 0, " + deviceTypeId + ")"; + + "0, 0, 0, 0, " + deviceTypeId + ", "+personId+")"; OracleUtils.ExecuteNonQuery(OracleUtils.ConnectionString, CommandType.Text, sql); } @@ -124,6 +141,8 @@ ? "" : newFeature.GetValue("DEVICEID").ToString(); String road = newFeature.GetValue("ROAD") == null ? "" : newFeature.GetValue("ROAD").ToString(); + String ownerName = newFeature.GetValue("ATTACHID") == null + ? "" : newFeature.GetValue("ATTACHID").ToString(); feature.Geometry = newFeature.Geometry.Clone(); this.setFeatureValueByShapeFeature(newFeature,feature); @@ -139,9 +158,21 @@ } int deviceTypeId = int.Parse(dbid.ToString()); + //查找负责人ID + string sqlPerson = "select dbid from alarm_accept_person where" + + " personname= '" + ownerName + "'"; + object dbid0 = OracleUtils.ExecuteScalar(OracleUtils.ConnectionString, + CommandType.Text, sqlPerson); + if (dbid0 == null) + { + return false; + } + int personId = int.Parse(dbid0.ToString()); + string sql = "update alarm_device set FACTORY='" + road + "', DEVICETYPE_ID='" + deviceTypeId + "', DEVNAME='"+deviceType+devCode+"' "+ + ", ACCEPTPERSON_ID='"+personId+"' "+ "where devcode='" + devCode + "'"; OracleUtils.ExecuteNonQuery(OracleUtils.ConnectionString, CommandType.Text, sql); return true; diff --git a/LSPipeline.suo b/LSPipeline.suo index 92b5d7d..d03429a 100644 --- a/LSPipeline.suo +++ b/LSPipeline.suo Binary files differ diff --git a/bin/x64/Debug/LSPipeline.exe b/bin/x64/Debug/LSPipeline.exe index 76f838b..e69b6ec 100644 --- a/bin/x64/Debug/LSPipeline.exe +++ b/bin/x64/Debug/LSPipeline.exe Binary files differ diff --git a/bin/x64/Debug/LSPipeline.pdb b/bin/x64/Debug/LSPipeline.pdb index 28c81dc..a0bafd0 100644 --- a/bin/x64/Debug/LSPipeline.pdb +++ b/bin/x64/Debug/LSPipeline.pdb Binary files differ diff --git a/bin/x64/Debug/glVersion.txt b/bin/x64/Debug/glVersion.txt index c004f47..6a37ce0 100644 --- a/bin/x64/Debug/glVersion.txt +++ b/bin/x64/Debug/glVersion.txt Binary files differ diff --git a/obj/Debug/DesignTimeResolveAssemblyReferencesInput.cache b/obj/Debug/DesignTimeResolveAssemblyReferencesInput.cache index b0cf5f9..01b91d5 100644 --- a/obj/Debug/DesignTimeResolveAssemblyReferencesInput.cache +++ b/obj/Debug/DesignTimeResolveAssemblyReferencesInput.cache Binary files differ diff --git a/GXBuilder.cs b/GXBuilder.cs index b2ec9b2..f085bdd 100644 --- a/GXBuilder.cs +++ b/GXBuilder.cs @@ -90,8 +90,13 @@ ? "" : feature.GetValue("DEVICEID").ToString(); String road = feature.GetValue("ROAD") == null ? "" : feature.GetValue("ROAD").ToString(); + String ownerName = feature.GetValue("ATTACHID") == null + ? "" : feature.GetValue("ATTACHID").ToString(); + if (deviceType == "" || ownerName == "") + { + return false; + } - //TODO LIST: string sqlCount = "select dbid from alarm_device_type where" + " typename = '" + deviceType + "'"; object dbid = OracleUtils.ExecuteScalar(OracleUtils.ConnectionString, @@ -101,11 +106,23 @@ return false; } int deviceTypeId = int.Parse(dbid.ToString()); + + //TODO LIST:查找对应的设备负责人: + string sqlPerson = "select dbid from alarm_accept_person where" + + " personname= '" + ownerName + "'"; + object dbid0 = OracleUtils.ExecuteScalar(OracleUtils.ConnectionString, + CommandType.Text, sqlPerson); + if (dbid0 == null) + { + return false; + } + int personId = int.Parse(dbid0.ToString()); + string sql = "Insert into alarm_device (DBID,ACTIVE,DEVCODE,DEVNAME,FACTORY," + - "INSTALLDATE,GAOCHENG,HEIGHT,LATITUDE,LONGTITUDE,DEVICETYPE_ID) " + + "INSTALLDATE,GAOCHENG,HEIGHT,LATITUDE,LONGTITUDE,DEVICETYPE_ID,ACCEPTPERSON_ID) " + "values (SEQ_DEVICE_ID.NEXTVAL, 1, '" + devCode + "', '" + deviceType + devCode + "', " + "'航天二院', " + "to_date('" + DateTime.Now.ToString() + "','yyyy/MM/dd hh24:mi::ss'), " - + "0, 0, 0, 0, " + deviceTypeId + ")"; + + "0, 0, 0, 0, " + deviceTypeId + ", "+personId+")"; OracleUtils.ExecuteNonQuery(OracleUtils.ConnectionString, CommandType.Text, sql); } @@ -124,6 +141,8 @@ ? "" : newFeature.GetValue("DEVICEID").ToString(); String road = newFeature.GetValue("ROAD") == null ? "" : newFeature.GetValue("ROAD").ToString(); + String ownerName = newFeature.GetValue("ATTACHID") == null + ? "" : newFeature.GetValue("ATTACHID").ToString(); feature.Geometry = newFeature.Geometry.Clone(); this.setFeatureValueByShapeFeature(newFeature,feature); @@ -139,9 +158,21 @@ } int deviceTypeId = int.Parse(dbid.ToString()); + //查找负责人ID + string sqlPerson = "select dbid from alarm_accept_person where" + + " personname= '" + ownerName + "'"; + object dbid0 = OracleUtils.ExecuteScalar(OracleUtils.ConnectionString, + CommandType.Text, sqlPerson); + if (dbid0 == null) + { + return false; + } + int personId = int.Parse(dbid0.ToString()); + string sql = "update alarm_device set FACTORY='" + road + "', DEVICETYPE_ID='" + deviceTypeId + "', DEVNAME='"+deviceType+devCode+"' "+ + ", ACCEPTPERSON_ID='"+personId+"' "+ "where devcode='" + devCode + "'"; OracleUtils.ExecuteNonQuery(OracleUtils.ConnectionString, CommandType.Text, sql); return true; diff --git a/LSPipeline.suo b/LSPipeline.suo index 92b5d7d..d03429a 100644 --- a/LSPipeline.suo +++ b/LSPipeline.suo Binary files differ diff --git a/bin/x64/Debug/LSPipeline.exe b/bin/x64/Debug/LSPipeline.exe index 76f838b..e69b6ec 100644 --- a/bin/x64/Debug/LSPipeline.exe +++ b/bin/x64/Debug/LSPipeline.exe Binary files differ diff --git a/bin/x64/Debug/LSPipeline.pdb b/bin/x64/Debug/LSPipeline.pdb index 28c81dc..a0bafd0 100644 --- a/bin/x64/Debug/LSPipeline.pdb +++ b/bin/x64/Debug/LSPipeline.pdb Binary files differ diff --git a/bin/x64/Debug/glVersion.txt b/bin/x64/Debug/glVersion.txt index c004f47..6a37ce0 100644 --- a/bin/x64/Debug/glVersion.txt +++ b/bin/x64/Debug/glVersion.txt Binary files differ diff --git a/obj/Debug/DesignTimeResolveAssemblyReferencesInput.cache b/obj/Debug/DesignTimeResolveAssemblyReferencesInput.cache index b0cf5f9..01b91d5 100644 --- a/obj/Debug/DesignTimeResolveAssemblyReferencesInput.cache +++ b/obj/Debug/DesignTimeResolveAssemblyReferencesInput.cache Binary files differ diff --git a/obj/Debug/LSPipeline.csproj.FileListAbsolute.txt b/obj/Debug/LSPipeline.csproj.FileListAbsolute.txt index 10baafa..e8e50c0 100644 --- a/obj/Debug/LSPipeline.csproj.FileListAbsolute.txt +++ b/obj/Debug/LSPipeline.csproj.FileListAbsolute.txt @@ -436,3 +436,145 @@ D:\LSPipeline\obj\Debug\GenerateResource.write.1.tlog D:\LSPipeline\bin\x64\Debug\LSPipeline.exe D:\LSPipeline\bin\x64\Debug\LSPipeline.pdb +F:\predator\codeReview\LSPipeline\bin\x64\Debug\LSPipeline.exe.config +F:\predator\codeReview\LSPipeline\obj\Debug\LSPipeline.exe +F:\predator\codeReview\LSPipeline\obj\Debug\LSPipeline.pdb +F:\predator\codeReview\LSPipeline\bin\x64\Debug\LSPipeline.exe +F:\predator\codeReview\LSPipeline\bin\x64\Debug\LSPipeline.pdb +F:\predator\codeReview\LSPipeline\obj\Debug\LSPipeline.csprojResolveAssemblyReference.cache +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.changeModelPathDlg.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.Forms.FrmPipelineModelDB.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmAboutUs.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmAddMultiModel.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmBaseLineProfillAnalysis.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmCheckPipelinePoint.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmMessageBox.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmMessageShow.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmTextureParamSetting.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmUpdateLayerFieldValues.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.HTForms.FrmAddWellShp.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.HTForms.FrmPipelineModelDB.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.HTForms.FrmValiData.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.CtrlBoxEntityParamPage.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.CtrlCylinderEntityParamPage.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.CtrlDataGridView.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.CtrlEllipCylinderEntityParamPage.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.CtrlEllipFrustumEntityParamPage.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.CtrlEllipsoidEntityParamPage.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.CtrlEntitySpaceInfo.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.CtrlEntityStylePage.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.CtrlFeatureAttribute.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.CtrlFountainParamPage.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.CtrlFrustumEntityParamPage.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.CtrlLineFieldsValuePage.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.CtrlLineStylePage.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.CtrlLineStylePreview.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.CtrlMarkerStylePage.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.CtrlMarkerTextPage.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.CtrlGeometryCameraState.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.CtrlParticleParamPage.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.CtrlSimpleLineStylePage.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.CtrlModelPathPage.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.CtrlPoint3DSpaceInfo.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.CtrlExtrudePage.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.CtrlPolygonStylePage.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.CtrlPolylineSpaceInfo.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.CtrlRangeEllipCylinderEntityParamPage.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.CtrlRangeEllipFrustumEntityParamPage.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.CtrlRangeEllipsoidEntityParamPage.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.CtrlSimpleLineStyleSetting.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.CtrlSphereEntityParamPage.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmWaterParamPage.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmAnalysisDigFill.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmTerrainExtra.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmFloodSubmergeAnalysis.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmSetFlyParams.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.MainFrm.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmSetPipelineStyle.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.Forms.FrmAddLayerFromDB.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.Forms.FrmAddPipeFitting.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.Forms.FrmAddWell.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.Forms.FrmCloneFeatureDatasetStructure.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.Forms.FrmMultiPipelineModelDB.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.Forms.FrmNewDBFeatureDataset.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.Forms.FrmCancelLayerjoint.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.Forms.FrmPaiShui2DB.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.Forms.FrmShp2KML.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.Forms.FrmFalseEastNorth.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmAddFieldToLayer.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmCreatePipeLineLayer.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.Forms.FrmAddValve.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmBatchCreateModel.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.Forms.FrmAddWellShp.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.Forms.FrmAddYuBiZiShp.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmAdjustLayer.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmSetArrowStyle.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmShowAtrributesByTable.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmBackupDatabase.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmBatchUpadateColor.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmBatchUpdateFieldValue.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmSetPipelineJointParams.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmShowValvesNeedClose.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmConnectServer.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmDatabaseParaSettingSqlServer.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmSetDateTime.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmDecjointPipeline.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmDeleteFieldFromLayer.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmDeleteLines.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmSetDigPit.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmElevateLayer.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmFeatureInfo.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmAnalysisFlow.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmCreateGenTopo.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmLabel.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmSetLayerVisibleAltitude.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmSetLineStyle.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmLineToPowerLine.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmMergeLayerLgdAndKml.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmOutEarth.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmBacthUpdateModelPath.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmParticalExportLayer.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmPipelineIndented.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmPipelineLayerButtjoint.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmBatchCreatePipeline.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmPlantTrees.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmSetPolygonStyle.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmPolygonToWater.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmProject.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmShowValveInformation.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmUnderGroundFloorSetting.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmUpdateFeatureNames.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmUpdateLayoutColor.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmUpdatePipelineColor.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmCopyFeatureDataset.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmEditLayerAttributes.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmAnalysisHengDuanMian.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmLogManager.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmBatchUpdatePipelineColor.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmEditLayerAttributesByTable.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmUnionFeatureDataset.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmSetGroundOpaque.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmAnalysisProfile.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.Properties.Resources.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmSetSceneLight.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmBatchExportLayerByZ.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmFlyToLatLonPos.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmSetLayerOpaque.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmShowSingleModel.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmSetObjectVisibleDistance.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmSetObjectVisiblePixelSize.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmPipedrain.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmBatchCreatePore.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmBatchCreatePipeDitch.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmAtrributeMapping1.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.CtrlLineStyleSetting.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.CtrlPipelineStyleSetting.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmQueryPipelineBySQL.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmAnalysisCollision.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmShowFeatureAttributesByTable.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmSetSelectLevel.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmSetOutlineStyle.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmBatchUpadateFontOfMarkers.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.CtrlExtentSectionlineStyleSetting.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmDatabaseParaSettingOracle.resources +F:\predator\codeReview\LSPipeline\obj\Debug\LSPipeline.csproj.GenerateResource.Cache diff --git a/GXBuilder.cs b/GXBuilder.cs index b2ec9b2..f085bdd 100644 --- a/GXBuilder.cs +++ b/GXBuilder.cs @@ -90,8 +90,13 @@ ? "" : feature.GetValue("DEVICEID").ToString(); String road = feature.GetValue("ROAD") == null ? "" : feature.GetValue("ROAD").ToString(); + String ownerName = feature.GetValue("ATTACHID") == null + ? "" : feature.GetValue("ATTACHID").ToString(); + if (deviceType == "" || ownerName == "") + { + return false; + } - //TODO LIST: string sqlCount = "select dbid from alarm_device_type where" + " typename = '" + deviceType + "'"; object dbid = OracleUtils.ExecuteScalar(OracleUtils.ConnectionString, @@ -101,11 +106,23 @@ return false; } int deviceTypeId = int.Parse(dbid.ToString()); + + //TODO LIST:查找对应的设备负责人: + string sqlPerson = "select dbid from alarm_accept_person where" + + " personname= '" + ownerName + "'"; + object dbid0 = OracleUtils.ExecuteScalar(OracleUtils.ConnectionString, + CommandType.Text, sqlPerson); + if (dbid0 == null) + { + return false; + } + int personId = int.Parse(dbid0.ToString()); + string sql = "Insert into alarm_device (DBID,ACTIVE,DEVCODE,DEVNAME,FACTORY," + - "INSTALLDATE,GAOCHENG,HEIGHT,LATITUDE,LONGTITUDE,DEVICETYPE_ID) " + + "INSTALLDATE,GAOCHENG,HEIGHT,LATITUDE,LONGTITUDE,DEVICETYPE_ID,ACCEPTPERSON_ID) " + "values (SEQ_DEVICE_ID.NEXTVAL, 1, '" + devCode + "', '" + deviceType + devCode + "', " + "'航天二院', " + "to_date('" + DateTime.Now.ToString() + "','yyyy/MM/dd hh24:mi::ss'), " - + "0, 0, 0, 0, " + deviceTypeId + ")"; + + "0, 0, 0, 0, " + deviceTypeId + ", "+personId+")"; OracleUtils.ExecuteNonQuery(OracleUtils.ConnectionString, CommandType.Text, sql); } @@ -124,6 +141,8 @@ ? "" : newFeature.GetValue("DEVICEID").ToString(); String road = newFeature.GetValue("ROAD") == null ? "" : newFeature.GetValue("ROAD").ToString(); + String ownerName = newFeature.GetValue("ATTACHID") == null + ? "" : newFeature.GetValue("ATTACHID").ToString(); feature.Geometry = newFeature.Geometry.Clone(); this.setFeatureValueByShapeFeature(newFeature,feature); @@ -139,9 +158,21 @@ } int deviceTypeId = int.Parse(dbid.ToString()); + //查找负责人ID + string sqlPerson = "select dbid from alarm_accept_person where" + + " personname= '" + ownerName + "'"; + object dbid0 = OracleUtils.ExecuteScalar(OracleUtils.ConnectionString, + CommandType.Text, sqlPerson); + if (dbid0 == null) + { + return false; + } + int personId = int.Parse(dbid0.ToString()); + string sql = "update alarm_device set FACTORY='" + road + "', DEVICETYPE_ID='" + deviceTypeId + "', DEVNAME='"+deviceType+devCode+"' "+ + ", ACCEPTPERSON_ID='"+personId+"' "+ "where devcode='" + devCode + "'"; OracleUtils.ExecuteNonQuery(OracleUtils.ConnectionString, CommandType.Text, sql); return true; diff --git a/LSPipeline.suo b/LSPipeline.suo index 92b5d7d..d03429a 100644 --- a/LSPipeline.suo +++ b/LSPipeline.suo Binary files differ diff --git a/bin/x64/Debug/LSPipeline.exe b/bin/x64/Debug/LSPipeline.exe index 76f838b..e69b6ec 100644 --- a/bin/x64/Debug/LSPipeline.exe +++ b/bin/x64/Debug/LSPipeline.exe Binary files differ diff --git a/bin/x64/Debug/LSPipeline.pdb b/bin/x64/Debug/LSPipeline.pdb index 28c81dc..a0bafd0 100644 --- a/bin/x64/Debug/LSPipeline.pdb +++ b/bin/x64/Debug/LSPipeline.pdb Binary files differ diff --git a/bin/x64/Debug/glVersion.txt b/bin/x64/Debug/glVersion.txt index c004f47..6a37ce0 100644 --- a/bin/x64/Debug/glVersion.txt +++ b/bin/x64/Debug/glVersion.txt Binary files differ diff --git a/obj/Debug/DesignTimeResolveAssemblyReferencesInput.cache b/obj/Debug/DesignTimeResolveAssemblyReferencesInput.cache index b0cf5f9..01b91d5 100644 --- a/obj/Debug/DesignTimeResolveAssemblyReferencesInput.cache +++ b/obj/Debug/DesignTimeResolveAssemblyReferencesInput.cache Binary files differ diff --git a/obj/Debug/LSPipeline.csproj.FileListAbsolute.txt b/obj/Debug/LSPipeline.csproj.FileListAbsolute.txt index 10baafa..e8e50c0 100644 --- a/obj/Debug/LSPipeline.csproj.FileListAbsolute.txt +++ b/obj/Debug/LSPipeline.csproj.FileListAbsolute.txt @@ -436,3 +436,145 @@ D:\LSPipeline\obj\Debug\GenerateResource.write.1.tlog D:\LSPipeline\bin\x64\Debug\LSPipeline.exe D:\LSPipeline\bin\x64\Debug\LSPipeline.pdb +F:\predator\codeReview\LSPipeline\bin\x64\Debug\LSPipeline.exe.config +F:\predator\codeReview\LSPipeline\obj\Debug\LSPipeline.exe +F:\predator\codeReview\LSPipeline\obj\Debug\LSPipeline.pdb +F:\predator\codeReview\LSPipeline\bin\x64\Debug\LSPipeline.exe +F:\predator\codeReview\LSPipeline\bin\x64\Debug\LSPipeline.pdb +F:\predator\codeReview\LSPipeline\obj\Debug\LSPipeline.csprojResolveAssemblyReference.cache +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.changeModelPathDlg.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.Forms.FrmPipelineModelDB.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmAboutUs.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmAddMultiModel.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmBaseLineProfillAnalysis.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmCheckPipelinePoint.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmMessageBox.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmMessageShow.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmTextureParamSetting.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmUpdateLayerFieldValues.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.HTForms.FrmAddWellShp.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.HTForms.FrmPipelineModelDB.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.HTForms.FrmValiData.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.CtrlBoxEntityParamPage.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.CtrlCylinderEntityParamPage.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.CtrlDataGridView.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.CtrlEllipCylinderEntityParamPage.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.CtrlEllipFrustumEntityParamPage.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.CtrlEllipsoidEntityParamPage.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.CtrlEntitySpaceInfo.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.CtrlEntityStylePage.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.CtrlFeatureAttribute.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.CtrlFountainParamPage.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.CtrlFrustumEntityParamPage.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.CtrlLineFieldsValuePage.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.CtrlLineStylePage.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.CtrlLineStylePreview.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.CtrlMarkerStylePage.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.CtrlMarkerTextPage.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.CtrlGeometryCameraState.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.CtrlParticleParamPage.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.CtrlSimpleLineStylePage.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.CtrlModelPathPage.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.CtrlPoint3DSpaceInfo.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.CtrlExtrudePage.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.CtrlPolygonStylePage.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.CtrlPolylineSpaceInfo.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.CtrlRangeEllipCylinderEntityParamPage.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.CtrlRangeEllipFrustumEntityParamPage.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.CtrlRangeEllipsoidEntityParamPage.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.CtrlSimpleLineStyleSetting.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.CtrlSphereEntityParamPage.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmWaterParamPage.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmAnalysisDigFill.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmTerrainExtra.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmFloodSubmergeAnalysis.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmSetFlyParams.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.MainFrm.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmSetPipelineStyle.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.Forms.FrmAddLayerFromDB.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.Forms.FrmAddPipeFitting.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.Forms.FrmAddWell.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.Forms.FrmCloneFeatureDatasetStructure.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.Forms.FrmMultiPipelineModelDB.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.Forms.FrmNewDBFeatureDataset.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.Forms.FrmCancelLayerjoint.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.Forms.FrmPaiShui2DB.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.Forms.FrmShp2KML.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.Forms.FrmFalseEastNorth.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmAddFieldToLayer.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmCreatePipeLineLayer.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.Forms.FrmAddValve.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmBatchCreateModel.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.Forms.FrmAddWellShp.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.Forms.FrmAddYuBiZiShp.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmAdjustLayer.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmSetArrowStyle.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmShowAtrributesByTable.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmBackupDatabase.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmBatchUpadateColor.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmBatchUpdateFieldValue.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmSetPipelineJointParams.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmShowValvesNeedClose.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmConnectServer.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmDatabaseParaSettingSqlServer.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmSetDateTime.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmDecjointPipeline.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmDeleteFieldFromLayer.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmDeleteLines.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmSetDigPit.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmElevateLayer.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmFeatureInfo.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmAnalysisFlow.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmCreateGenTopo.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmLabel.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmSetLayerVisibleAltitude.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmSetLineStyle.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmLineToPowerLine.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmMergeLayerLgdAndKml.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmOutEarth.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmBacthUpdateModelPath.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmParticalExportLayer.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmPipelineIndented.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmPipelineLayerButtjoint.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmBatchCreatePipeline.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmPlantTrees.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmSetPolygonStyle.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmPolygonToWater.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmProject.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmShowValveInformation.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmUnderGroundFloorSetting.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmUpdateFeatureNames.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmUpdateLayoutColor.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmUpdatePipelineColor.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmCopyFeatureDataset.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmEditLayerAttributes.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmAnalysisHengDuanMian.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmLogManager.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmBatchUpdatePipelineColor.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmEditLayerAttributesByTable.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmUnionFeatureDataset.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmSetGroundOpaque.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmAnalysisProfile.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.Properties.Resources.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmSetSceneLight.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmBatchExportLayerByZ.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmFlyToLatLonPos.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmSetLayerOpaque.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmShowSingleModel.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmSetObjectVisibleDistance.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmSetObjectVisiblePixelSize.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmPipedrain.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmBatchCreatePore.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmBatchCreatePipeDitch.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmAtrributeMapping1.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.CtrlLineStyleSetting.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.CtrlPipelineStyleSetting.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmQueryPipelineBySQL.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmAnalysisCollision.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmShowFeatureAttributesByTable.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmSetSelectLevel.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmSetOutlineStyle.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmBatchUpadateFontOfMarkers.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.CtrlExtentSectionlineStyleSetting.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmDatabaseParaSettingOracle.resources +F:\predator\codeReview\LSPipeline\obj\Debug\LSPipeline.csproj.GenerateResource.Cache diff --git a/obj/Debug/LSPipeline.csproj.GenerateResource.Cache b/obj/Debug/LSPipeline.csproj.GenerateResource.Cache new file mode 100644 index 0000000..458a46c --- /dev/null +++ b/obj/Debug/LSPipeline.csproj.GenerateResource.Cache Binary files differ diff --git a/GXBuilder.cs b/GXBuilder.cs index b2ec9b2..f085bdd 100644 --- a/GXBuilder.cs +++ b/GXBuilder.cs @@ -90,8 +90,13 @@ ? "" : feature.GetValue("DEVICEID").ToString(); String road = feature.GetValue("ROAD") == null ? "" : feature.GetValue("ROAD").ToString(); + String ownerName = feature.GetValue("ATTACHID") == null + ? "" : feature.GetValue("ATTACHID").ToString(); + if (deviceType == "" || ownerName == "") + { + return false; + } - //TODO LIST: string sqlCount = "select dbid from alarm_device_type where" + " typename = '" + deviceType + "'"; object dbid = OracleUtils.ExecuteScalar(OracleUtils.ConnectionString, @@ -101,11 +106,23 @@ return false; } int deviceTypeId = int.Parse(dbid.ToString()); + + //TODO LIST:查找对应的设备负责人: + string sqlPerson = "select dbid from alarm_accept_person where" + + " personname= '" + ownerName + "'"; + object dbid0 = OracleUtils.ExecuteScalar(OracleUtils.ConnectionString, + CommandType.Text, sqlPerson); + if (dbid0 == null) + { + return false; + } + int personId = int.Parse(dbid0.ToString()); + string sql = "Insert into alarm_device (DBID,ACTIVE,DEVCODE,DEVNAME,FACTORY," + - "INSTALLDATE,GAOCHENG,HEIGHT,LATITUDE,LONGTITUDE,DEVICETYPE_ID) " + + "INSTALLDATE,GAOCHENG,HEIGHT,LATITUDE,LONGTITUDE,DEVICETYPE_ID,ACCEPTPERSON_ID) " + "values (SEQ_DEVICE_ID.NEXTVAL, 1, '" + devCode + "', '" + deviceType + devCode + "', " + "'航天二院', " + "to_date('" + DateTime.Now.ToString() + "','yyyy/MM/dd hh24:mi::ss'), " - + "0, 0, 0, 0, " + deviceTypeId + ")"; + + "0, 0, 0, 0, " + deviceTypeId + ", "+personId+")"; OracleUtils.ExecuteNonQuery(OracleUtils.ConnectionString, CommandType.Text, sql); } @@ -124,6 +141,8 @@ ? "" : newFeature.GetValue("DEVICEID").ToString(); String road = newFeature.GetValue("ROAD") == null ? "" : newFeature.GetValue("ROAD").ToString(); + String ownerName = newFeature.GetValue("ATTACHID") == null + ? "" : newFeature.GetValue("ATTACHID").ToString(); feature.Geometry = newFeature.Geometry.Clone(); this.setFeatureValueByShapeFeature(newFeature,feature); @@ -139,9 +158,21 @@ } int deviceTypeId = int.Parse(dbid.ToString()); + //查找负责人ID + string sqlPerson = "select dbid from alarm_accept_person where" + + " personname= '" + ownerName + "'"; + object dbid0 = OracleUtils.ExecuteScalar(OracleUtils.ConnectionString, + CommandType.Text, sqlPerson); + if (dbid0 == null) + { + return false; + } + int personId = int.Parse(dbid0.ToString()); + string sql = "update alarm_device set FACTORY='" + road + "', DEVICETYPE_ID='" + deviceTypeId + "', DEVNAME='"+deviceType+devCode+"' "+ + ", ACCEPTPERSON_ID='"+personId+"' "+ "where devcode='" + devCode + "'"; OracleUtils.ExecuteNonQuery(OracleUtils.ConnectionString, CommandType.Text, sql); return true; diff --git a/LSPipeline.suo b/LSPipeline.suo index 92b5d7d..d03429a 100644 --- a/LSPipeline.suo +++ b/LSPipeline.suo Binary files differ diff --git a/bin/x64/Debug/LSPipeline.exe b/bin/x64/Debug/LSPipeline.exe index 76f838b..e69b6ec 100644 --- a/bin/x64/Debug/LSPipeline.exe +++ b/bin/x64/Debug/LSPipeline.exe Binary files differ diff --git a/bin/x64/Debug/LSPipeline.pdb b/bin/x64/Debug/LSPipeline.pdb index 28c81dc..a0bafd0 100644 --- a/bin/x64/Debug/LSPipeline.pdb +++ b/bin/x64/Debug/LSPipeline.pdb Binary files differ diff --git a/bin/x64/Debug/glVersion.txt b/bin/x64/Debug/glVersion.txt index c004f47..6a37ce0 100644 --- a/bin/x64/Debug/glVersion.txt +++ b/bin/x64/Debug/glVersion.txt Binary files differ diff --git a/obj/Debug/DesignTimeResolveAssemblyReferencesInput.cache b/obj/Debug/DesignTimeResolveAssemblyReferencesInput.cache index b0cf5f9..01b91d5 100644 --- a/obj/Debug/DesignTimeResolveAssemblyReferencesInput.cache +++ b/obj/Debug/DesignTimeResolveAssemblyReferencesInput.cache Binary files differ diff --git a/obj/Debug/LSPipeline.csproj.FileListAbsolute.txt b/obj/Debug/LSPipeline.csproj.FileListAbsolute.txt index 10baafa..e8e50c0 100644 --- a/obj/Debug/LSPipeline.csproj.FileListAbsolute.txt +++ b/obj/Debug/LSPipeline.csproj.FileListAbsolute.txt @@ -436,3 +436,145 @@ D:\LSPipeline\obj\Debug\GenerateResource.write.1.tlog D:\LSPipeline\bin\x64\Debug\LSPipeline.exe D:\LSPipeline\bin\x64\Debug\LSPipeline.pdb +F:\predator\codeReview\LSPipeline\bin\x64\Debug\LSPipeline.exe.config +F:\predator\codeReview\LSPipeline\obj\Debug\LSPipeline.exe +F:\predator\codeReview\LSPipeline\obj\Debug\LSPipeline.pdb +F:\predator\codeReview\LSPipeline\bin\x64\Debug\LSPipeline.exe +F:\predator\codeReview\LSPipeline\bin\x64\Debug\LSPipeline.pdb +F:\predator\codeReview\LSPipeline\obj\Debug\LSPipeline.csprojResolveAssemblyReference.cache +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.changeModelPathDlg.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.Forms.FrmPipelineModelDB.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmAboutUs.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmAddMultiModel.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmBaseLineProfillAnalysis.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmCheckPipelinePoint.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmMessageBox.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmMessageShow.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmTextureParamSetting.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmUpdateLayerFieldValues.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.HTForms.FrmAddWellShp.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.HTForms.FrmPipelineModelDB.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.HTForms.FrmValiData.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.CtrlBoxEntityParamPage.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.CtrlCylinderEntityParamPage.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.CtrlDataGridView.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.CtrlEllipCylinderEntityParamPage.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.CtrlEllipFrustumEntityParamPage.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.CtrlEllipsoidEntityParamPage.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.CtrlEntitySpaceInfo.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.CtrlEntityStylePage.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.CtrlFeatureAttribute.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.CtrlFountainParamPage.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.CtrlFrustumEntityParamPage.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.CtrlLineFieldsValuePage.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.CtrlLineStylePage.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.CtrlLineStylePreview.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.CtrlMarkerStylePage.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.CtrlMarkerTextPage.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.CtrlGeometryCameraState.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.CtrlParticleParamPage.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.CtrlSimpleLineStylePage.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.CtrlModelPathPage.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.CtrlPoint3DSpaceInfo.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.CtrlExtrudePage.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.CtrlPolygonStylePage.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.CtrlPolylineSpaceInfo.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.CtrlRangeEllipCylinderEntityParamPage.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.CtrlRangeEllipFrustumEntityParamPage.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.CtrlRangeEllipsoidEntityParamPage.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.CtrlSimpleLineStyleSetting.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.CtrlSphereEntityParamPage.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmWaterParamPage.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmAnalysisDigFill.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmTerrainExtra.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmFloodSubmergeAnalysis.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmSetFlyParams.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.MainFrm.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmSetPipelineStyle.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.Forms.FrmAddLayerFromDB.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.Forms.FrmAddPipeFitting.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.Forms.FrmAddWell.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.Forms.FrmCloneFeatureDatasetStructure.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.Forms.FrmMultiPipelineModelDB.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.Forms.FrmNewDBFeatureDataset.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.Forms.FrmCancelLayerjoint.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.Forms.FrmPaiShui2DB.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.Forms.FrmShp2KML.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.Forms.FrmFalseEastNorth.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmAddFieldToLayer.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmCreatePipeLineLayer.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.Forms.FrmAddValve.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmBatchCreateModel.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.Forms.FrmAddWellShp.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.Forms.FrmAddYuBiZiShp.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmAdjustLayer.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmSetArrowStyle.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmShowAtrributesByTable.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmBackupDatabase.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmBatchUpadateColor.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmBatchUpdateFieldValue.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmSetPipelineJointParams.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmShowValvesNeedClose.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmConnectServer.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmDatabaseParaSettingSqlServer.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmSetDateTime.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmDecjointPipeline.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmDeleteFieldFromLayer.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmDeleteLines.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmSetDigPit.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmElevateLayer.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmFeatureInfo.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmAnalysisFlow.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmCreateGenTopo.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmLabel.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmSetLayerVisibleAltitude.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmSetLineStyle.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmLineToPowerLine.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmMergeLayerLgdAndKml.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmOutEarth.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmBacthUpdateModelPath.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmParticalExportLayer.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmPipelineIndented.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmPipelineLayerButtjoint.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmBatchCreatePipeline.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmPlantTrees.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmSetPolygonStyle.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmPolygonToWater.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmProject.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmShowValveInformation.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmUnderGroundFloorSetting.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmUpdateFeatureNames.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmUpdateLayoutColor.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmUpdatePipelineColor.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmCopyFeatureDataset.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmEditLayerAttributes.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmAnalysisHengDuanMian.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmLogManager.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmBatchUpdatePipelineColor.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmEditLayerAttributesByTable.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmUnionFeatureDataset.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmSetGroundOpaque.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmAnalysisProfile.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.Properties.Resources.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmSetSceneLight.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmBatchExportLayerByZ.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmFlyToLatLonPos.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmSetLayerOpaque.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmShowSingleModel.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmSetObjectVisibleDistance.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmSetObjectVisiblePixelSize.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmPipedrain.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmBatchCreatePore.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmBatchCreatePipeDitch.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmAtrributeMapping1.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.CtrlLineStyleSetting.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.CtrlPipelineStyleSetting.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmQueryPipelineBySQL.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmAnalysisCollision.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmShowFeatureAttributesByTable.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmSetSelectLevel.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmSetOutlineStyle.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmBatchUpadateFontOfMarkers.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.CtrlExtentSectionlineStyleSetting.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmDatabaseParaSettingOracle.resources +F:\predator\codeReview\LSPipeline\obj\Debug\LSPipeline.csproj.GenerateResource.Cache diff --git a/obj/Debug/LSPipeline.csproj.GenerateResource.Cache b/obj/Debug/LSPipeline.csproj.GenerateResource.Cache new file mode 100644 index 0000000..458a46c --- /dev/null +++ b/obj/Debug/LSPipeline.csproj.GenerateResource.Cache Binary files differ diff --git a/obj/Debug/LSPipeline.csprojResolveAssemblyReference.cache b/obj/Debug/LSPipeline.csprojResolveAssemblyReference.cache new file mode 100644 index 0000000..cf9ba46 --- /dev/null +++ b/obj/Debug/LSPipeline.csprojResolveAssemblyReference.cache Binary files differ diff --git a/GXBuilder.cs b/GXBuilder.cs index b2ec9b2..f085bdd 100644 --- a/GXBuilder.cs +++ b/GXBuilder.cs @@ -90,8 +90,13 @@ ? "" : feature.GetValue("DEVICEID").ToString(); String road = feature.GetValue("ROAD") == null ? "" : feature.GetValue("ROAD").ToString(); + String ownerName = feature.GetValue("ATTACHID") == null + ? "" : feature.GetValue("ATTACHID").ToString(); + if (deviceType == "" || ownerName == "") + { + return false; + } - //TODO LIST: string sqlCount = "select dbid from alarm_device_type where" + " typename = '" + deviceType + "'"; object dbid = OracleUtils.ExecuteScalar(OracleUtils.ConnectionString, @@ -101,11 +106,23 @@ return false; } int deviceTypeId = int.Parse(dbid.ToString()); + + //TODO LIST:查找对应的设备负责人: + string sqlPerson = "select dbid from alarm_accept_person where" + + " personname= '" + ownerName + "'"; + object dbid0 = OracleUtils.ExecuteScalar(OracleUtils.ConnectionString, + CommandType.Text, sqlPerson); + if (dbid0 == null) + { + return false; + } + int personId = int.Parse(dbid0.ToString()); + string sql = "Insert into alarm_device (DBID,ACTIVE,DEVCODE,DEVNAME,FACTORY," + - "INSTALLDATE,GAOCHENG,HEIGHT,LATITUDE,LONGTITUDE,DEVICETYPE_ID) " + + "INSTALLDATE,GAOCHENG,HEIGHT,LATITUDE,LONGTITUDE,DEVICETYPE_ID,ACCEPTPERSON_ID) " + "values (SEQ_DEVICE_ID.NEXTVAL, 1, '" + devCode + "', '" + deviceType + devCode + "', " + "'航天二院', " + "to_date('" + DateTime.Now.ToString() + "','yyyy/MM/dd hh24:mi::ss'), " - + "0, 0, 0, 0, " + deviceTypeId + ")"; + + "0, 0, 0, 0, " + deviceTypeId + ", "+personId+")"; OracleUtils.ExecuteNonQuery(OracleUtils.ConnectionString, CommandType.Text, sql); } @@ -124,6 +141,8 @@ ? "" : newFeature.GetValue("DEVICEID").ToString(); String road = newFeature.GetValue("ROAD") == null ? "" : newFeature.GetValue("ROAD").ToString(); + String ownerName = newFeature.GetValue("ATTACHID") == null + ? "" : newFeature.GetValue("ATTACHID").ToString(); feature.Geometry = newFeature.Geometry.Clone(); this.setFeatureValueByShapeFeature(newFeature,feature); @@ -139,9 +158,21 @@ } int deviceTypeId = int.Parse(dbid.ToString()); + //查找负责人ID + string sqlPerson = "select dbid from alarm_accept_person where" + + " personname= '" + ownerName + "'"; + object dbid0 = OracleUtils.ExecuteScalar(OracleUtils.ConnectionString, + CommandType.Text, sqlPerson); + if (dbid0 == null) + { + return false; + } + int personId = int.Parse(dbid0.ToString()); + string sql = "update alarm_device set FACTORY='" + road + "', DEVICETYPE_ID='" + deviceTypeId + "', DEVNAME='"+deviceType+devCode+"' "+ + ", ACCEPTPERSON_ID='"+personId+"' "+ "where devcode='" + devCode + "'"; OracleUtils.ExecuteNonQuery(OracleUtils.ConnectionString, CommandType.Text, sql); return true; diff --git a/LSPipeline.suo b/LSPipeline.suo index 92b5d7d..d03429a 100644 --- a/LSPipeline.suo +++ b/LSPipeline.suo Binary files differ diff --git a/bin/x64/Debug/LSPipeline.exe b/bin/x64/Debug/LSPipeline.exe index 76f838b..e69b6ec 100644 --- a/bin/x64/Debug/LSPipeline.exe +++ b/bin/x64/Debug/LSPipeline.exe Binary files differ diff --git a/bin/x64/Debug/LSPipeline.pdb b/bin/x64/Debug/LSPipeline.pdb index 28c81dc..a0bafd0 100644 --- a/bin/x64/Debug/LSPipeline.pdb +++ b/bin/x64/Debug/LSPipeline.pdb Binary files differ diff --git a/bin/x64/Debug/glVersion.txt b/bin/x64/Debug/glVersion.txt index c004f47..6a37ce0 100644 --- a/bin/x64/Debug/glVersion.txt +++ b/bin/x64/Debug/glVersion.txt Binary files differ diff --git a/obj/Debug/DesignTimeResolveAssemblyReferencesInput.cache b/obj/Debug/DesignTimeResolveAssemblyReferencesInput.cache index b0cf5f9..01b91d5 100644 --- a/obj/Debug/DesignTimeResolveAssemblyReferencesInput.cache +++ b/obj/Debug/DesignTimeResolveAssemblyReferencesInput.cache Binary files differ diff --git a/obj/Debug/LSPipeline.csproj.FileListAbsolute.txt b/obj/Debug/LSPipeline.csproj.FileListAbsolute.txt index 10baafa..e8e50c0 100644 --- a/obj/Debug/LSPipeline.csproj.FileListAbsolute.txt +++ b/obj/Debug/LSPipeline.csproj.FileListAbsolute.txt @@ -436,3 +436,145 @@ D:\LSPipeline\obj\Debug\GenerateResource.write.1.tlog D:\LSPipeline\bin\x64\Debug\LSPipeline.exe D:\LSPipeline\bin\x64\Debug\LSPipeline.pdb +F:\predator\codeReview\LSPipeline\bin\x64\Debug\LSPipeline.exe.config +F:\predator\codeReview\LSPipeline\obj\Debug\LSPipeline.exe +F:\predator\codeReview\LSPipeline\obj\Debug\LSPipeline.pdb +F:\predator\codeReview\LSPipeline\bin\x64\Debug\LSPipeline.exe +F:\predator\codeReview\LSPipeline\bin\x64\Debug\LSPipeline.pdb +F:\predator\codeReview\LSPipeline\obj\Debug\LSPipeline.csprojResolveAssemblyReference.cache +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.changeModelPathDlg.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.Forms.FrmPipelineModelDB.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmAboutUs.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmAddMultiModel.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmBaseLineProfillAnalysis.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmCheckPipelinePoint.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmMessageBox.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmMessageShow.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmTextureParamSetting.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmUpdateLayerFieldValues.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.HTForms.FrmAddWellShp.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.HTForms.FrmPipelineModelDB.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.HTForms.FrmValiData.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.CtrlBoxEntityParamPage.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.CtrlCylinderEntityParamPage.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.CtrlDataGridView.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.CtrlEllipCylinderEntityParamPage.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.CtrlEllipFrustumEntityParamPage.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.CtrlEllipsoidEntityParamPage.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.CtrlEntitySpaceInfo.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.CtrlEntityStylePage.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.CtrlFeatureAttribute.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.CtrlFountainParamPage.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.CtrlFrustumEntityParamPage.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.CtrlLineFieldsValuePage.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.CtrlLineStylePage.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.CtrlLineStylePreview.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.CtrlMarkerStylePage.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.CtrlMarkerTextPage.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.CtrlGeometryCameraState.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.CtrlParticleParamPage.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.CtrlSimpleLineStylePage.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.CtrlModelPathPage.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.CtrlPoint3DSpaceInfo.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.CtrlExtrudePage.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.CtrlPolygonStylePage.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.CtrlPolylineSpaceInfo.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.CtrlRangeEllipCylinderEntityParamPage.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.CtrlRangeEllipFrustumEntityParamPage.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.CtrlRangeEllipsoidEntityParamPage.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.CtrlSimpleLineStyleSetting.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.CtrlSphereEntityParamPage.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmWaterParamPage.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmAnalysisDigFill.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmTerrainExtra.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmFloodSubmergeAnalysis.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmSetFlyParams.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.MainFrm.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmSetPipelineStyle.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.Forms.FrmAddLayerFromDB.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.Forms.FrmAddPipeFitting.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.Forms.FrmAddWell.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.Forms.FrmCloneFeatureDatasetStructure.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.Forms.FrmMultiPipelineModelDB.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.Forms.FrmNewDBFeatureDataset.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.Forms.FrmCancelLayerjoint.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.Forms.FrmPaiShui2DB.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.Forms.FrmShp2KML.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.Forms.FrmFalseEastNorth.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmAddFieldToLayer.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmCreatePipeLineLayer.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.Forms.FrmAddValve.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmBatchCreateModel.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.Forms.FrmAddWellShp.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.Forms.FrmAddYuBiZiShp.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmAdjustLayer.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmSetArrowStyle.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmShowAtrributesByTable.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmBackupDatabase.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmBatchUpadateColor.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmBatchUpdateFieldValue.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmSetPipelineJointParams.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmShowValvesNeedClose.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmConnectServer.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmDatabaseParaSettingSqlServer.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmSetDateTime.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmDecjointPipeline.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmDeleteFieldFromLayer.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmDeleteLines.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmSetDigPit.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmElevateLayer.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmFeatureInfo.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmAnalysisFlow.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmCreateGenTopo.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmLabel.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmSetLayerVisibleAltitude.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmSetLineStyle.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmLineToPowerLine.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmMergeLayerLgdAndKml.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmOutEarth.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmBacthUpdateModelPath.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmParticalExportLayer.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmPipelineIndented.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmPipelineLayerButtjoint.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmBatchCreatePipeline.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmPlantTrees.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmSetPolygonStyle.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmPolygonToWater.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmProject.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmShowValveInformation.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmUnderGroundFloorSetting.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmUpdateFeatureNames.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmUpdateLayoutColor.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmUpdatePipelineColor.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmCopyFeatureDataset.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmEditLayerAttributes.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmAnalysisHengDuanMian.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmLogManager.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmBatchUpdatePipelineColor.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmEditLayerAttributesByTable.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmUnionFeatureDataset.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmSetGroundOpaque.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmAnalysisProfile.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.Properties.Resources.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmSetSceneLight.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmBatchExportLayerByZ.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmFlyToLatLonPos.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmSetLayerOpaque.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmShowSingleModel.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmSetObjectVisibleDistance.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmSetObjectVisiblePixelSize.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmPipedrain.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmBatchCreatePore.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmBatchCreatePipeDitch.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmAtrributeMapping1.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.CtrlLineStyleSetting.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.CtrlPipelineStyleSetting.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmQueryPipelineBySQL.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmAnalysisCollision.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmShowFeatureAttributesByTable.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmSetSelectLevel.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmSetOutlineStyle.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmBatchUpadateFontOfMarkers.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.CtrlExtentSectionlineStyleSetting.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmDatabaseParaSettingOracle.resources +F:\predator\codeReview\LSPipeline\obj\Debug\LSPipeline.csproj.GenerateResource.Cache diff --git a/obj/Debug/LSPipeline.csproj.GenerateResource.Cache b/obj/Debug/LSPipeline.csproj.GenerateResource.Cache new file mode 100644 index 0000000..458a46c --- /dev/null +++ b/obj/Debug/LSPipeline.csproj.GenerateResource.Cache Binary files differ diff --git a/obj/Debug/LSPipeline.csprojResolveAssemblyReference.cache b/obj/Debug/LSPipeline.csprojResolveAssemblyReference.cache new file mode 100644 index 0000000..cf9ba46 --- /dev/null +++ b/obj/Debug/LSPipeline.csprojResolveAssemblyReference.cache Binary files differ diff --git a/obj/Debug/LSPipeline.exe b/obj/Debug/LSPipeline.exe index 76f838b..e69b6ec 100644 --- a/obj/Debug/LSPipeline.exe +++ b/obj/Debug/LSPipeline.exe Binary files differ diff --git a/GXBuilder.cs b/GXBuilder.cs index b2ec9b2..f085bdd 100644 --- a/GXBuilder.cs +++ b/GXBuilder.cs @@ -90,8 +90,13 @@ ? "" : feature.GetValue("DEVICEID").ToString(); String road = feature.GetValue("ROAD") == null ? "" : feature.GetValue("ROAD").ToString(); + String ownerName = feature.GetValue("ATTACHID") == null + ? "" : feature.GetValue("ATTACHID").ToString(); + if (deviceType == "" || ownerName == "") + { + return false; + } - //TODO LIST: string sqlCount = "select dbid from alarm_device_type where" + " typename = '" + deviceType + "'"; object dbid = OracleUtils.ExecuteScalar(OracleUtils.ConnectionString, @@ -101,11 +106,23 @@ return false; } int deviceTypeId = int.Parse(dbid.ToString()); + + //TODO LIST:查找对应的设备负责人: + string sqlPerson = "select dbid from alarm_accept_person where" + + " personname= '" + ownerName + "'"; + object dbid0 = OracleUtils.ExecuteScalar(OracleUtils.ConnectionString, + CommandType.Text, sqlPerson); + if (dbid0 == null) + { + return false; + } + int personId = int.Parse(dbid0.ToString()); + string sql = "Insert into alarm_device (DBID,ACTIVE,DEVCODE,DEVNAME,FACTORY," + - "INSTALLDATE,GAOCHENG,HEIGHT,LATITUDE,LONGTITUDE,DEVICETYPE_ID) " + + "INSTALLDATE,GAOCHENG,HEIGHT,LATITUDE,LONGTITUDE,DEVICETYPE_ID,ACCEPTPERSON_ID) " + "values (SEQ_DEVICE_ID.NEXTVAL, 1, '" + devCode + "', '" + deviceType + devCode + "', " + "'航天二院', " + "to_date('" + DateTime.Now.ToString() + "','yyyy/MM/dd hh24:mi::ss'), " - + "0, 0, 0, 0, " + deviceTypeId + ")"; + + "0, 0, 0, 0, " + deviceTypeId + ", "+personId+")"; OracleUtils.ExecuteNonQuery(OracleUtils.ConnectionString, CommandType.Text, sql); } @@ -124,6 +141,8 @@ ? "" : newFeature.GetValue("DEVICEID").ToString(); String road = newFeature.GetValue("ROAD") == null ? "" : newFeature.GetValue("ROAD").ToString(); + String ownerName = newFeature.GetValue("ATTACHID") == null + ? "" : newFeature.GetValue("ATTACHID").ToString(); feature.Geometry = newFeature.Geometry.Clone(); this.setFeatureValueByShapeFeature(newFeature,feature); @@ -139,9 +158,21 @@ } int deviceTypeId = int.Parse(dbid.ToString()); + //查找负责人ID + string sqlPerson = "select dbid from alarm_accept_person where" + + " personname= '" + ownerName + "'"; + object dbid0 = OracleUtils.ExecuteScalar(OracleUtils.ConnectionString, + CommandType.Text, sqlPerson); + if (dbid0 == null) + { + return false; + } + int personId = int.Parse(dbid0.ToString()); + string sql = "update alarm_device set FACTORY='" + road + "', DEVICETYPE_ID='" + deviceTypeId + "', DEVNAME='"+deviceType+devCode+"' "+ + ", ACCEPTPERSON_ID='"+personId+"' "+ "where devcode='" + devCode + "'"; OracleUtils.ExecuteNonQuery(OracleUtils.ConnectionString, CommandType.Text, sql); return true; diff --git a/LSPipeline.suo b/LSPipeline.suo index 92b5d7d..d03429a 100644 --- a/LSPipeline.suo +++ b/LSPipeline.suo Binary files differ diff --git a/bin/x64/Debug/LSPipeline.exe b/bin/x64/Debug/LSPipeline.exe index 76f838b..e69b6ec 100644 --- a/bin/x64/Debug/LSPipeline.exe +++ b/bin/x64/Debug/LSPipeline.exe Binary files differ diff --git a/bin/x64/Debug/LSPipeline.pdb b/bin/x64/Debug/LSPipeline.pdb index 28c81dc..a0bafd0 100644 --- a/bin/x64/Debug/LSPipeline.pdb +++ b/bin/x64/Debug/LSPipeline.pdb Binary files differ diff --git a/bin/x64/Debug/glVersion.txt b/bin/x64/Debug/glVersion.txt index c004f47..6a37ce0 100644 --- a/bin/x64/Debug/glVersion.txt +++ b/bin/x64/Debug/glVersion.txt Binary files differ diff --git a/obj/Debug/DesignTimeResolveAssemblyReferencesInput.cache b/obj/Debug/DesignTimeResolveAssemblyReferencesInput.cache index b0cf5f9..01b91d5 100644 --- a/obj/Debug/DesignTimeResolveAssemblyReferencesInput.cache +++ b/obj/Debug/DesignTimeResolveAssemblyReferencesInput.cache Binary files differ diff --git a/obj/Debug/LSPipeline.csproj.FileListAbsolute.txt b/obj/Debug/LSPipeline.csproj.FileListAbsolute.txt index 10baafa..e8e50c0 100644 --- a/obj/Debug/LSPipeline.csproj.FileListAbsolute.txt +++ b/obj/Debug/LSPipeline.csproj.FileListAbsolute.txt @@ -436,3 +436,145 @@ D:\LSPipeline\obj\Debug\GenerateResource.write.1.tlog D:\LSPipeline\bin\x64\Debug\LSPipeline.exe D:\LSPipeline\bin\x64\Debug\LSPipeline.pdb +F:\predator\codeReview\LSPipeline\bin\x64\Debug\LSPipeline.exe.config +F:\predator\codeReview\LSPipeline\obj\Debug\LSPipeline.exe +F:\predator\codeReview\LSPipeline\obj\Debug\LSPipeline.pdb +F:\predator\codeReview\LSPipeline\bin\x64\Debug\LSPipeline.exe +F:\predator\codeReview\LSPipeline\bin\x64\Debug\LSPipeline.pdb +F:\predator\codeReview\LSPipeline\obj\Debug\LSPipeline.csprojResolveAssemblyReference.cache +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.changeModelPathDlg.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.Forms.FrmPipelineModelDB.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmAboutUs.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmAddMultiModel.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmBaseLineProfillAnalysis.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmCheckPipelinePoint.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmMessageBox.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmMessageShow.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmTextureParamSetting.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmUpdateLayerFieldValues.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.HTForms.FrmAddWellShp.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.HTForms.FrmPipelineModelDB.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.HTForms.FrmValiData.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.CtrlBoxEntityParamPage.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.CtrlCylinderEntityParamPage.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.CtrlDataGridView.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.CtrlEllipCylinderEntityParamPage.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.CtrlEllipFrustumEntityParamPage.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.CtrlEllipsoidEntityParamPage.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.CtrlEntitySpaceInfo.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.CtrlEntityStylePage.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.CtrlFeatureAttribute.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.CtrlFountainParamPage.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.CtrlFrustumEntityParamPage.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.CtrlLineFieldsValuePage.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.CtrlLineStylePage.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.CtrlLineStylePreview.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.CtrlMarkerStylePage.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.CtrlMarkerTextPage.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.CtrlGeometryCameraState.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.CtrlParticleParamPage.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.CtrlSimpleLineStylePage.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.CtrlModelPathPage.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.CtrlPoint3DSpaceInfo.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.CtrlExtrudePage.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.CtrlPolygonStylePage.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.CtrlPolylineSpaceInfo.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.CtrlRangeEllipCylinderEntityParamPage.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.CtrlRangeEllipFrustumEntityParamPage.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.CtrlRangeEllipsoidEntityParamPage.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.CtrlSimpleLineStyleSetting.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.CtrlSphereEntityParamPage.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmWaterParamPage.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmAnalysisDigFill.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmTerrainExtra.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmFloodSubmergeAnalysis.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmSetFlyParams.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.MainFrm.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmSetPipelineStyle.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.Forms.FrmAddLayerFromDB.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.Forms.FrmAddPipeFitting.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.Forms.FrmAddWell.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.Forms.FrmCloneFeatureDatasetStructure.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.Forms.FrmMultiPipelineModelDB.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.Forms.FrmNewDBFeatureDataset.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.Forms.FrmCancelLayerjoint.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.Forms.FrmPaiShui2DB.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.Forms.FrmShp2KML.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.Forms.FrmFalseEastNorth.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmAddFieldToLayer.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmCreatePipeLineLayer.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.Forms.FrmAddValve.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmBatchCreateModel.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.Forms.FrmAddWellShp.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.Forms.FrmAddYuBiZiShp.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmAdjustLayer.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmSetArrowStyle.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmShowAtrributesByTable.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmBackupDatabase.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmBatchUpadateColor.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmBatchUpdateFieldValue.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmSetPipelineJointParams.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmShowValvesNeedClose.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmConnectServer.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmDatabaseParaSettingSqlServer.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmSetDateTime.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmDecjointPipeline.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmDeleteFieldFromLayer.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmDeleteLines.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmSetDigPit.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmElevateLayer.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmFeatureInfo.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmAnalysisFlow.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmCreateGenTopo.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmLabel.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmSetLayerVisibleAltitude.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmSetLineStyle.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmLineToPowerLine.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmMergeLayerLgdAndKml.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmOutEarth.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmBacthUpdateModelPath.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmParticalExportLayer.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmPipelineIndented.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmPipelineLayerButtjoint.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmBatchCreatePipeline.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmPlantTrees.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmSetPolygonStyle.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmPolygonToWater.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmProject.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmShowValveInformation.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmUnderGroundFloorSetting.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmUpdateFeatureNames.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmUpdateLayoutColor.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmUpdatePipelineColor.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmCopyFeatureDataset.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmEditLayerAttributes.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmAnalysisHengDuanMian.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmLogManager.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmBatchUpdatePipelineColor.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmEditLayerAttributesByTable.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmUnionFeatureDataset.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmSetGroundOpaque.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmAnalysisProfile.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.Properties.Resources.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmSetSceneLight.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmBatchExportLayerByZ.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmFlyToLatLonPos.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmSetLayerOpaque.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmShowSingleModel.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmSetObjectVisibleDistance.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmSetObjectVisiblePixelSize.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmPipedrain.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmBatchCreatePore.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmBatchCreatePipeDitch.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmAtrributeMapping1.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.CtrlLineStyleSetting.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.CtrlPipelineStyleSetting.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmQueryPipelineBySQL.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmAnalysisCollision.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmShowFeatureAttributesByTable.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmSetSelectLevel.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmSetOutlineStyle.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmBatchUpadateFontOfMarkers.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.CtrlExtentSectionlineStyleSetting.resources +F:\predator\codeReview\LSPipeline\obj\Debug\WorldGIS.FrmDatabaseParaSettingOracle.resources +F:\predator\codeReview\LSPipeline\obj\Debug\LSPipeline.csproj.GenerateResource.Cache diff --git a/obj/Debug/LSPipeline.csproj.GenerateResource.Cache b/obj/Debug/LSPipeline.csproj.GenerateResource.Cache new file mode 100644 index 0000000..458a46c --- /dev/null +++ b/obj/Debug/LSPipeline.csproj.GenerateResource.Cache Binary files differ diff --git a/obj/Debug/LSPipeline.csprojResolveAssemblyReference.cache b/obj/Debug/LSPipeline.csprojResolveAssemblyReference.cache new file mode 100644 index 0000000..cf9ba46 --- /dev/null +++ b/obj/Debug/LSPipeline.csprojResolveAssemblyReference.cache Binary files differ diff --git a/obj/Debug/LSPipeline.exe b/obj/Debug/LSPipeline.exe index 76f838b..e69b6ec 100644 --- a/obj/Debug/LSPipeline.exe +++ b/obj/Debug/LSPipeline.exe Binary files differ diff --git a/obj/Debug/LSPipeline.pdb b/obj/Debug/LSPipeline.pdb index 28c81dc..a0bafd0 100644 --- a/obj/Debug/LSPipeline.pdb +++ b/obj/Debug/LSPipeline.pdb Binary files differ