示例#1
0
        /// <summary>
        /// 得到一个对象实体
        /// </summary>
        public big_data.Model.UnifiedAddressLibrary GetModel(int ID)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("select  top 1 UnifiedAddressLibraryUUID,ID,oid,SOURCEADDRESS,CITY,COUNTY,TOWN,COMMUNITY,SQUAD,VILLAGE,SZONE,STREET,DOOR,RESREGION,BUILDING,BUILDING_NUM,UNIT,FLOOR,ROOM,GRID_CODE,BUILDING_CODE,HOUSE_CODE,CODE,CREATETIME,UPDATETIME,ISVALID,FROM_STATUS,TO_STATUS,BUILDING_PATH,DATASOURCE,REVERSE1,REVERSE2,LON,LAT,Z,ROOM_FLOOR,ADDRTYPE,GUID,INSERTTIME,SYSTEMID,ISDELETE,BELONG_BUILDING,ADDRESS_TYPE,REMARK,AddTime from UnifiedAddressLibrary ");
            strSql.Append(" where ID=@ID");
            SqlParameter[] parameters =
            {
                new SqlParameter("@ID", SqlDbType.Int, 4)
            };
            parameters[0].Value = ID;

            big_data.Model.UnifiedAddressLibrary model = new big_data.Model.UnifiedAddressLibrary();
            DataSet ds = DbHelperSql.Query(strSql.ToString(), parameters);

            if (ds.Tables[0].Rows.Count > 0)
            {
                return(DataRowToModel(ds.Tables[0].Rows[0]));
            }
            else
            {
                return(null);
            }
        }
示例#2
0
 /// <summary>
 /// 得到一个对象实体
 /// </summary>
 public big_data.Model.UnifiedAddressLibrary DataRowToModel(DataRow row)
 {
     big_data.Model.UnifiedAddressLibrary model = new big_data.Model.UnifiedAddressLibrary();
     if (row != null)
     {
         if (row["UnifiedAddressLibraryUUID"] != null && row["UnifiedAddressLibraryUUID"].ToString() != "")
         {
             model.UnifiedAddressLibraryUUID = new Guid(row["UnifiedAddressLibraryUUID"].ToString());
         }
         if (row["ID"] != null && row["ID"].ToString() != "")
         {
             model.ID = int.Parse(row["ID"].ToString());
         }
         if (row["oid"] != null)
         {
             model.oid = row["oid"].ToString();
         }
         if (row["SOURCEADDRESS"] != null)
         {
             model.SOURCEADDRESS = row["SOURCEADDRESS"].ToString();
         }
         if (row["CITY"] != null)
         {
             model.CITY = row["CITY"].ToString();
         }
         if (row["COUNTY"] != null)
         {
             model.COUNTY = row["COUNTY"].ToString();
         }
         if (row["TOWN"] != null)
         {
             model.TOWN = row["TOWN"].ToString();
         }
         if (row["COMMUNITY"] != null)
         {
             model.COMMUNITY = row["COMMUNITY"].ToString();
         }
         if (row["SQUAD"] != null)
         {
             model.SQUAD = row["SQUAD"].ToString();
         }
         if (row["VILLAGE"] != null)
         {
             model.VILLAGE = row["VILLAGE"].ToString();
         }
         if (row["SZONE"] != null)
         {
             model.SZONE = row["SZONE"].ToString();
         }
         if (row["STREET"] != null)
         {
             model.STREET = row["STREET"].ToString();
         }
         if (row["DOOR"] != null)
         {
             model.DOOR = row["DOOR"].ToString();
         }
         if (row["RESREGION"] != null)
         {
             model.RESREGION = row["RESREGION"].ToString();
         }
         if (row["BUILDING"] != null)
         {
             model.BUILDING = row["BUILDING"].ToString();
         }
         if (row["BUILDING_NUM"] != null)
         {
             model.BUILDING_NUM = row["BUILDING_NUM"].ToString();
         }
         if (row["UNIT"] != null)
         {
             model.UNIT = row["UNIT"].ToString();
         }
         if (row["FLOOR"] != null)
         {
             model.FLOOR = row["FLOOR"].ToString();
         }
         if (row["ROOM"] != null)
         {
             model.ROOM = row["ROOM"].ToString();
         }
         if (row["GRID_CODE"] != null)
         {
             model.GRID_CODE = row["GRID_CODE"].ToString();
         }
         if (row["BUILDING_CODE"] != null)
         {
             model.BUILDING_CODE = row["BUILDING_CODE"].ToString();
         }
         if (row["HOUSE_CODE"] != null)
         {
             model.HOUSE_CODE = row["HOUSE_CODE"].ToString();
         }
         if (row["CODE"] != null)
         {
             model.CODE = row["CODE"].ToString();
         }
         if (row["CREATETIME"] != null)
         {
             model.CREATETIME = row["CREATETIME"].ToString();
         }
         if (row["UPDATETIME"] != null)
         {
             model.UPDATETIME = row["UPDATETIME"].ToString();
         }
         if (row["ISVALID"] != null && row["ISVALID"].ToString() != "")
         {
             model.ISVALID = int.Parse(row["ISVALID"].ToString());
         }
         if (row["FROM_STATUS"] != null)
         {
             model.FROM_STATUS = row["FROM_STATUS"].ToString();
         }
         if (row["TO_STATUS"] != null)
         {
             model.TO_STATUS = row["TO_STATUS"].ToString();
         }
         if (row["BUILDING_PATH"] != null)
         {
             model.BUILDING_PATH = row["BUILDING_PATH"].ToString();
         }
         if (row["DATASOURCE"] != null)
         {
             model.DATASOURCE = row["DATASOURCE"].ToString();
         }
         if (row["REVERSE1"] != null)
         {
             model.REVERSE1 = row["REVERSE1"].ToString();
         }
         if (row["REVERSE2"] != null)
         {
             model.REVERSE2 = row["REVERSE2"].ToString();
         }
         if (row["LON"] != null)
         {
             model.LON = row["LON"].ToString();
         }
         if (row["LAT"] != null)
         {
             model.LAT = row["LAT"].ToString();
         }
         if (row["Z"] != null)
         {
             model.Z = row["Z"].ToString();
         }
         if (row["ROOM_FLOOR"] != null)
         {
             model.ROOM_FLOOR = row["ROOM_FLOOR"].ToString();
         }
         if (row["ADDRTYPE"] != null)
         {
             model.ADDRTYPE = row["ADDRTYPE"].ToString();
         }
         if (row["GUID"] != null)
         {
             model.GUID = row["GUID"].ToString();
         }
         if (row["INSERTTIME"] != null)
         {
             model.INSERTTIME = row["INSERTTIME"].ToString();
         }
         if (row["SYSTEMID"] != null)
         {
             model.SYSTEMID = row["SYSTEMID"].ToString();
         }
         if (row["ISDELETE"] != null && row["ISDELETE"].ToString() != "")
         {
             model.ISDELETE = int.Parse(row["ISDELETE"].ToString());
         }
         if (row["BELONG_BUILDING"] != null)
         {
             model.BELONG_BUILDING = row["BELONG_BUILDING"].ToString();
         }
         if (row["ADDRESS_TYPE"] != null)
         {
             model.ADDRESS_TYPE = row["ADDRESS_TYPE"].ToString();
         }
         if (row["REMARK"] != null)
         {
             model.REMARK = row["REMARK"].ToString();
         }
         if (row["AddTime"] != null)
         {
             model.AddTime = row["AddTime"].ToString();
         }
     }
     return(model);
 }
示例#3
0
        /// <summary>
        /// 更新一条数据
        /// </summary>
        public bool Update(big_data.Model.UnifiedAddressLibrary model)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("update UnifiedAddressLibrary set ");
            strSql.Append("UnifiedAddressLibraryUUID=@UnifiedAddressLibraryUUID,");
            strSql.Append("oid=@oid,");
            strSql.Append("SOURCEADDRESS=@SOURCEADDRESS,");
            strSql.Append("CITY=@CITY,");
            strSql.Append("COUNTY=@COUNTY,");
            strSql.Append("TOWN=@TOWN,");
            strSql.Append("COMMUNITY=@COMMUNITY,");
            strSql.Append("SQUAD=@SQUAD,");
            strSql.Append("VILLAGE=@VILLAGE,");
            strSql.Append("SZONE=@SZONE,");
            strSql.Append("STREET=@STREET,");
            strSql.Append("DOOR=@DOOR,");
            strSql.Append("RESREGION=@RESREGION,");
            strSql.Append("BUILDING=@BUILDING,");
            strSql.Append("BUILDING_NUM=@BUILDING_NUM,");
            strSql.Append("UNIT=@UNIT,");
            strSql.Append("FLOOR=@FLOOR,");
            strSql.Append("ROOM=@ROOM,");
            strSql.Append("GRID_CODE=@GRID_CODE,");
            strSql.Append("BUILDING_CODE=@BUILDING_CODE,");
            strSql.Append("HOUSE_CODE=@HOUSE_CODE,");
            strSql.Append("CODE=@CODE,");
            strSql.Append("CREATETIME=@CREATETIME,");
            strSql.Append("UPDATETIME=@UPDATETIME,");
            strSql.Append("ISVALID=@ISVALID,");
            strSql.Append("FROM_STATUS=@FROM_STATUS,");
            strSql.Append("TO_STATUS=@TO_STATUS,");
            strSql.Append("BUILDING_PATH=@BUILDING_PATH,");
            strSql.Append("DATASOURCE=@DATASOURCE,");
            strSql.Append("REVERSE1=@REVERSE1,");
            strSql.Append("REVERSE2=@REVERSE2,");
            strSql.Append("LON=@LON,");
            strSql.Append("LAT=@LAT,");
            strSql.Append("Z=@Z,");
            strSql.Append("ROOM_FLOOR=@ROOM_FLOOR,");
            strSql.Append("ADDRTYPE=@ADDRTYPE,");
            strSql.Append("GUID=@GUID,");
            strSql.Append("INSERTTIME=@INSERTTIME,");
            strSql.Append("SYSTEMID=@SYSTEMID,");
            strSql.Append("ISDELETE=@ISDELETE,");
            strSql.Append("BELONG_BUILDING=@BELONG_BUILDING,");
            strSql.Append("ADDRESS_TYPE=@ADDRESS_TYPE,");
            strSql.Append("REMARK=@REMARK,");
            strSql.Append("AddTime=@AddTime");
            strSql.Append(" where ID=@ID");
            SqlParameter[] parameters =
            {
                new SqlParameter("@UnifiedAddressLibraryUUID", SqlDbType.UniqueIdentifier,  16),
                new SqlParameter("@oid",                       SqlDbType.VarChar,          255),
                new SqlParameter("@SOURCEADDRESS",             SqlDbType.VarChar,          255),
                new SqlParameter("@CITY",                      SqlDbType.VarChar,          255),
                new SqlParameter("@COUNTY",                    SqlDbType.VarChar,          255),
                new SqlParameter("@TOWN",                      SqlDbType.VarChar,          255),
                new SqlParameter("@COMMUNITY",                 SqlDbType.VarChar,          255),
                new SqlParameter("@SQUAD",                     SqlDbType.VarChar,          255),
                new SqlParameter("@VILLAGE",                   SqlDbType.VarChar,          255),
                new SqlParameter("@SZONE",                     SqlDbType.VarChar,          255),
                new SqlParameter("@STREET",                    SqlDbType.VarChar,          255),
                new SqlParameter("@DOOR",                      SqlDbType.VarChar,          255),
                new SqlParameter("@RESREGION",                 SqlDbType.VarChar,          255),
                new SqlParameter("@BUILDING",                  SqlDbType.VarChar,          255),
                new SqlParameter("@BUILDING_NUM",              SqlDbType.VarChar,          255),
                new SqlParameter("@UNIT",                      SqlDbType.VarChar,          255),
                new SqlParameter("@FLOOR",                     SqlDbType.VarChar,          255),
                new SqlParameter("@ROOM",                      SqlDbType.VarChar,          255),
                new SqlParameter("@GRID_CODE",                 SqlDbType.VarChar,          255),
                new SqlParameter("@BUILDING_CODE",             SqlDbType.VarChar,          255),
                new SqlParameter("@HOUSE_CODE",                SqlDbType.VarChar,          255),
                new SqlParameter("@CODE",                      SqlDbType.VarChar,          255),
                new SqlParameter("@CREATETIME",                SqlDbType.VarChar,          255),
                new SqlParameter("@UPDATETIME",                SqlDbType.VarChar,          255),
                new SqlParameter("@ISVALID",                   SqlDbType.Int,                4),
                new SqlParameter("@FROM_STATUS",               SqlDbType.VarChar,          255),
                new SqlParameter("@TO_STATUS",                 SqlDbType.VarChar,          255),
                new SqlParameter("@BUILDING_PATH",             SqlDbType.VarChar,          255),
                new SqlParameter("@DATASOURCE",                SqlDbType.VarChar,          255),
                new SqlParameter("@REVERSE1",                  SqlDbType.VarChar,          255),
                new SqlParameter("@REVERSE2",                  SqlDbType.VarChar,          255),
                new SqlParameter("@LON",                       SqlDbType.VarChar,          255),
                new SqlParameter("@LAT",                       SqlDbType.VarChar,          255),
                new SqlParameter("@Z",                         SqlDbType.VarChar,          255),
                new SqlParameter("@ROOM_FLOOR",                SqlDbType.VarChar,          255),
                new SqlParameter("@ADDRTYPE",                  SqlDbType.VarChar,          255),
                new SqlParameter("@GUID",                      SqlDbType.VarChar,          255),
                new SqlParameter("@INSERTTIME",                SqlDbType.VarChar,          255),
                new SqlParameter("@SYSTEMID",                  SqlDbType.VarChar,          255),
                new SqlParameter("@ISDELETE",                  SqlDbType.Int,                4),
                new SqlParameter("@BELONG_BUILDING",           SqlDbType.VarChar,          255),
                new SqlParameter("@ADDRESS_TYPE",              SqlDbType.VarChar,          255),
                new SqlParameter("@REMARK",                    SqlDbType.VarChar,          255),
                new SqlParameter("@AddTime",                   SqlDbType.VarChar,          255),
                new SqlParameter("@ID",                        SqlDbType.Int, 4)
            };
            parameters[0].Value  = model.UnifiedAddressLibraryUUID;
            parameters[1].Value  = model.oid;
            parameters[2].Value  = model.SOURCEADDRESS;
            parameters[3].Value  = model.CITY;
            parameters[4].Value  = model.COUNTY;
            parameters[5].Value  = model.TOWN;
            parameters[6].Value  = model.COMMUNITY;
            parameters[7].Value  = model.SQUAD;
            parameters[8].Value  = model.VILLAGE;
            parameters[9].Value  = model.SZONE;
            parameters[10].Value = model.STREET;
            parameters[11].Value = model.DOOR;
            parameters[12].Value = model.RESREGION;
            parameters[13].Value = model.BUILDING;
            parameters[14].Value = model.BUILDING_NUM;
            parameters[15].Value = model.UNIT;
            parameters[16].Value = model.FLOOR;
            parameters[17].Value = model.ROOM;
            parameters[18].Value = model.GRID_CODE;
            parameters[19].Value = model.BUILDING_CODE;
            parameters[20].Value = model.HOUSE_CODE;
            parameters[21].Value = model.CODE;
            parameters[22].Value = model.CREATETIME;
            parameters[23].Value = model.UPDATETIME;
            parameters[24].Value = model.ISVALID;
            parameters[25].Value = model.FROM_STATUS;
            parameters[26].Value = model.TO_STATUS;
            parameters[27].Value = model.BUILDING_PATH;
            parameters[28].Value = model.DATASOURCE;
            parameters[29].Value = model.REVERSE1;
            parameters[30].Value = model.REVERSE2;
            parameters[31].Value = model.LON;
            parameters[32].Value = model.LAT;
            parameters[33].Value = model.Z;
            parameters[34].Value = model.ROOM_FLOOR;
            parameters[35].Value = model.ADDRTYPE;
            parameters[36].Value = model.GUID;
            parameters[37].Value = model.INSERTTIME;
            parameters[38].Value = model.SYSTEMID;
            parameters[39].Value = model.ISDELETE;
            parameters[40].Value = model.BELONG_BUILDING;
            parameters[41].Value = model.ADDRESS_TYPE;
            parameters[42].Value = model.REMARK;
            parameters[43].Value = model.AddTime;
            parameters[44].Value = model.ID;

            int rows = DbHelperSql.ExecuteSql(strSql.ToString(), parameters);

            if (rows > 0)
            {
                return(true);
            }
            else
            {
                return(false);
            }
        }
示例#4
0
        /// <summary>
        /// 增加一条数据
        /// </summary>
        public int Add(big_data.Model.UnifiedAddressLibrary model)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("insert into UnifiedAddressLibrary(");
            strSql.Append("UnifiedAddressLibraryUUID,oid,SOURCEADDRESS,CITY,COUNTY,TOWN,COMMUNITY,SQUAD,VILLAGE,SZONE,STREET,DOOR,RESREGION,BUILDING,BUILDING_NUM,UNIT,FLOOR,ROOM,GRID_CODE,BUILDING_CODE,HOUSE_CODE,CODE,CREATETIME,UPDATETIME,ISVALID,FROM_STATUS,TO_STATUS,BUILDING_PATH,DATASOURCE,REVERSE1,REVERSE2,LON,LAT,Z,ROOM_FLOOR,ADDRTYPE,GUID,INSERTTIME,SYSTEMID,ISDELETE,BELONG_BUILDING,ADDRESS_TYPE,REMARK,AddTime)");
            strSql.Append(" values (");
            strSql.Append("@UnifiedAddressLibraryUUID,@oid,@SOURCEADDRESS,@CITY,@COUNTY,@TOWN,@COMMUNITY,@SQUAD,@VILLAGE,@SZONE,@STREET,@DOOR,@RESREGION,@BUILDING,@BUILDING_NUM,@UNIT,@FLOOR,@ROOM,@GRID_CODE,@BUILDING_CODE,@HOUSE_CODE,@CODE,@CREATETIME,@UPDATETIME,@ISVALID,@FROM_STATUS,@TO_STATUS,@BUILDING_PATH,@DATASOURCE,@REVERSE1,@REVERSE2,@LON,@LAT,@Z,@ROOM_FLOOR,@ADDRTYPE,@GUID,@INSERTTIME,@SYSTEMID,@ISDELETE,@BELONG_BUILDING,@ADDRESS_TYPE,@REMARK,@AddTime)");
            strSql.Append(";select @@IDENTITY");
            SqlParameter[] parameters =
            {
                new SqlParameter("@UnifiedAddressLibraryUUID", SqlDbType.UniqueIdentifier,  16),
                new SqlParameter("@oid",                       SqlDbType.VarChar,          255),
                new SqlParameter("@SOURCEADDRESS",             SqlDbType.VarChar,          255),
                new SqlParameter("@CITY",                      SqlDbType.VarChar,          255),
                new SqlParameter("@COUNTY",                    SqlDbType.VarChar,          255),
                new SqlParameter("@TOWN",                      SqlDbType.VarChar,          255),
                new SqlParameter("@COMMUNITY",                 SqlDbType.VarChar,          255),
                new SqlParameter("@SQUAD",                     SqlDbType.VarChar,          255),
                new SqlParameter("@VILLAGE",                   SqlDbType.VarChar,          255),
                new SqlParameter("@SZONE",                     SqlDbType.VarChar,          255),
                new SqlParameter("@STREET",                    SqlDbType.VarChar,          255),
                new SqlParameter("@DOOR",                      SqlDbType.VarChar,          255),
                new SqlParameter("@RESREGION",                 SqlDbType.VarChar,          255),
                new SqlParameter("@BUILDING",                  SqlDbType.VarChar,          255),
                new SqlParameter("@BUILDING_NUM",              SqlDbType.VarChar,          255),
                new SqlParameter("@UNIT",                      SqlDbType.VarChar,          255),
                new SqlParameter("@FLOOR",                     SqlDbType.VarChar,          255),
                new SqlParameter("@ROOM",                      SqlDbType.VarChar,          255),
                new SqlParameter("@GRID_CODE",                 SqlDbType.VarChar,          255),
                new SqlParameter("@BUILDING_CODE",             SqlDbType.VarChar,          255),
                new SqlParameter("@HOUSE_CODE",                SqlDbType.VarChar,          255),
                new SqlParameter("@CODE",                      SqlDbType.VarChar,          255),
                new SqlParameter("@CREATETIME",                SqlDbType.VarChar,          255),
                new SqlParameter("@UPDATETIME",                SqlDbType.VarChar,          255),
                new SqlParameter("@ISVALID",                   SqlDbType.Int,                4),
                new SqlParameter("@FROM_STATUS",               SqlDbType.VarChar,          255),
                new SqlParameter("@TO_STATUS",                 SqlDbType.VarChar,          255),
                new SqlParameter("@BUILDING_PATH",             SqlDbType.VarChar,          255),
                new SqlParameter("@DATASOURCE",                SqlDbType.VarChar,          255),
                new SqlParameter("@REVERSE1",                  SqlDbType.VarChar,          255),
                new SqlParameter("@REVERSE2",                  SqlDbType.VarChar,          255),
                new SqlParameter("@LON",                       SqlDbType.VarChar,          255),
                new SqlParameter("@LAT",                       SqlDbType.VarChar,          255),
                new SqlParameter("@Z",                         SqlDbType.VarChar,          255),
                new SqlParameter("@ROOM_FLOOR",                SqlDbType.VarChar,          255),
                new SqlParameter("@ADDRTYPE",                  SqlDbType.VarChar,          255),
                new SqlParameter("@GUID",                      SqlDbType.VarChar,          255),
                new SqlParameter("@INSERTTIME",                SqlDbType.VarChar,          255),
                new SqlParameter("@SYSTEMID",                  SqlDbType.VarChar,          255),
                new SqlParameter("@ISDELETE",                  SqlDbType.Int,                4),
                new SqlParameter("@BELONG_BUILDING",           SqlDbType.VarChar,          255),
                new SqlParameter("@ADDRESS_TYPE",              SqlDbType.VarChar,          255),
                new SqlParameter("@REMARK",                    SqlDbType.VarChar,          255),
                new SqlParameter("@AddTime",                   SqlDbType.VarChar, 255)
            };
            parameters[0].Value  = Guid.NewGuid();
            parameters[1].Value  = model.oid;
            parameters[2].Value  = model.SOURCEADDRESS;
            parameters[3].Value  = model.CITY;
            parameters[4].Value  = model.COUNTY;
            parameters[5].Value  = model.TOWN;
            parameters[6].Value  = model.COMMUNITY;
            parameters[7].Value  = model.SQUAD;
            parameters[8].Value  = model.VILLAGE;
            parameters[9].Value  = model.SZONE;
            parameters[10].Value = model.STREET;
            parameters[11].Value = model.DOOR;
            parameters[12].Value = model.RESREGION;
            parameters[13].Value = model.BUILDING;
            parameters[14].Value = model.BUILDING_NUM;
            parameters[15].Value = model.UNIT;
            parameters[16].Value = model.FLOOR;
            parameters[17].Value = model.ROOM;
            parameters[18].Value = model.GRID_CODE;
            parameters[19].Value = model.BUILDING_CODE;
            parameters[20].Value = model.HOUSE_CODE;
            parameters[21].Value = model.CODE;
            parameters[22].Value = model.CREATETIME;
            parameters[23].Value = model.UPDATETIME;
            parameters[24].Value = model.ISVALID;
            parameters[25].Value = model.FROM_STATUS;
            parameters[26].Value = model.TO_STATUS;
            parameters[27].Value = model.BUILDING_PATH;
            parameters[28].Value = model.DATASOURCE;
            parameters[29].Value = model.REVERSE1;
            parameters[30].Value = model.REVERSE2;
            parameters[31].Value = model.LON;
            parameters[32].Value = model.LAT;
            parameters[33].Value = model.Z;
            parameters[34].Value = model.ROOM_FLOOR;
            parameters[35].Value = model.ADDRTYPE;
            parameters[36].Value = model.GUID;
            parameters[37].Value = model.INSERTTIME;
            parameters[38].Value = model.SYSTEMID;
            parameters[39].Value = model.ISDELETE;
            parameters[40].Value = model.BELONG_BUILDING;
            parameters[41].Value = model.ADDRESS_TYPE;
            parameters[42].Value = model.REMARK;
            parameters[43].Value = model.AddTime;

            object obj = DbHelperSql.GetSingle(strSql.ToString(), parameters);

            if (obj == null)
            {
                return(0);
            }
            else
            {
                return(Convert.ToInt32(obj));
            }
        }
示例#5
0
        /// <summary>
        /// 地址库数据区域数据匹配
        /// </summary>
        public void UnifiedAddressLibraryQuYuinfo()
        {
            DataSet dss = unifiedAddressLibrarybll.GetList("1=1");

            if (dss.Tables[0].Rows.Count > 0)
            {
                for (int i = 0; i < dss.Tables[0].Rows.Count; i++)
                {
                    string  UnifiedAddressLibraryID = dss.Tables[0].Rows[i]["ID"].ToString();
                    double  xinfo = Convert.ToDouble(dss.Tables[0].Rows[i]["LON"].ToString());
                    double  yinfo = Convert.ToDouble(dss.Tables[0].Rows[i]["LAT"].ToString());
                    DataSet dssab = regionInfosbll.GetList("1=1");
                    if (dssab.Tables[0].Rows.Count > 0)
                    {
                        for (int i1 = 0; i1 < dssab.Tables[0].Rows.Count; i1++)
                        {
                            string ids        = dssab.Tables[0].Rows[i1]["ID"].ToString();
                            string xyinfolist = dssab.Tables[0].Rows[i1]["RegionXYInfo"].ToString();
                            if (xyinfolist != "")
                            {
                                string[] listitem = xyinfolist.Split('|');
                                if (listitem.Length > 0)
                                {
                                    Point   point11 = new Point(xinfo, yinfo);
                                    Point[] ps      = new Point[listitem.Length];
                                    for (int i2 = 0; i2 < listitem.Length; i2++)
                                    {
                                        string[] xylist = listitem[i2].Split(',');
                                        if (xylist.Length > 0)
                                        {
                                            ps[i2] = new Point(Convert.ToDouble(xylist[0]), Convert.ToDouble(xylist[1]));
                                        }
                                    }
                                    if (PointInFences(point11, ps))
                                    {
                                        regionInfosmodel = regionInfosbll.GetModel(Convert.ToInt32(ids));
                                        if (!("," + regionInfosmodel.UnifiedAddressLibraryID + ",").Contains("," + UnifiedAddressLibraryID + ","))
                                        {
                                            if (regionInfosmodel.UnifiedAddressLibraryID != "")
                                            {
                                                regionInfosmodel.UnifiedAddressLibraryID += "," + UnifiedAddressLibraryID;
                                            }
                                            else
                                            {
                                                regionInfosmodel.UnifiedAddressLibraryID = UnifiedAddressLibraryID;
                                            }
                                            regionInfosmodel.AddTime = DateTime.Now;
                                            regionInfosbll.Update(regionInfosmodel);
                                        }
                                    }
                                }
                            }
                        }
                    }
                    unifiedAddressLibrarymodel         = unifiedAddressLibrarybll.GetModel(Convert.ToInt32(UnifiedAddressLibraryID));
                    unifiedAddressLibrarymodel.REMARK  = "1";
                    unifiedAddressLibrarymodel.AddTime = DateTime.Now.ToString();
                    unifiedAddressLibrarybll.Update(unifiedAddressLibrarymodel);
                }
            }
            //AlertAndStay("数据更新完成!!!");
            LogHelper.WriteLog(typeof(FrmMainServer), "数据更新完成!!!");
        }