Exemple #1
0
 protected object[] Take(PositionsEntity position)
 {
     return(new object[] {
         "@DepID", position.DepID,
         "@PosName", position.PosName,
         //  "@Temp",position.Temp,
     });
 }
Exemple #2
0
        //private static readonly string connectionString = ConfigurationManager.ConnectionStrings["MyMvcDbConnection"].ConnectionString;
        //public static bool CheckUnique(string posName)
        //{
        //    bool check = false;
        //    string query = string.Format("Select PosName FROM [POSITION] WHERE REPLACE(PosName, ' ', '') = '{0}'", posName);
        //    using (SqlConnection connection = new SqlConnection(connectionString))
        //    {
        //        SqlCommand cmd = new SqlCommand(query, connection);
        //        connection.Open();
        //        SqlDataReader sdr = cmd.ExecuteReader();
        //        check = sdr.HasRows;
        //        connection.Close();
        //        return (check);
        //    }
        //}
        public bool InsertPosition(PositionsEntity position)
        {
            string sql = @"sp_position_INSERT";

            using (TransactionScope ts = new TransactionScope())
            {
                try { Db.Insert(sql, Take(position)); ts.Complete(); return(true); }
                catch { return(false); }
            }
        }
Exemple #3
0
 public static PositionModel ToDto(PositionsEntity entity)
 {
     return(new PositionModel
     {
         PosID = entity.PosID,
         DepID = entity.DepID,
         PosName = entity.PosName,
         DepName = entity.DepName,
         //  Temp = entity.Temp
     });
 }
Exemple #4
0
        public bool InsertPosandRole(PositionsEntity position, PosInRoleDetailDto[] list, string UPDATEDATA)
        {
            string sql      = @"sp_position_INSERT";
            string sql_role = @"sp_PosAndRole_INSERT";

            string retID = "";

            if (UPDATEDATA.Equals("INSERT"))
            {
                using (TransactionScope ts = new TransactionScope())
                {
                    retID = Db.InsertReturnID(sql, Take(position));
                    if (retID != null)
                    {
                        foreach (var ls in list)
                        {
                            object[] obj = { "@RoleID", ls.RoleID, "@PosID", retID };
                            try
                            {
                                Db.Insert(sql_role, obj);
                            }
                            catch
                            {
                                return(false);
                            }
                        }
                        ts.Complete();
                        return(true);
                    }
                    else
                    {
                        return(false);
                    }
                }
            }
            else if (UPDATEDATA.Equals("UPDATE"))
            {
                string sql_upd = @"sp_PosAndRole_UPDATE";
                using (TransactionScope ts = new TransactionScope())
                {
                    DeletePosition(position.PosID);
                    {
                        foreach (var ls in list)
                        {
                            object[] obj = { "@RoleID", ls.RoleID, "@PosID", position.PosID };
                            Db.Insert(sql_upd, obj);
                        }
                        ts.Complete();
                        return(true);
                    }
                }
            }
            return(false);
        }
Exemple #5
0
 public bool UpdatePosition(PositionsEntity position)
 {
     throw new NotImplementedException();
 }
        /// <summary>
        /// 获取电子围栏内所有摄像头信息
        /// </summary>
        public string GetElectricFenceCameraList(SafeworkcontrolEntity data)
        {
            string ComerId = string.Empty;

            try
            {
                //三维监控点位服务接口地址
                DataItemDetailBLL pdata   = new DataItemDetailBLL();
                var             ThreeDApi = pdata.GetItemValue("kbsThreeMonitoringPoints");
                space           sp        = new space();
                spacedata       sds       = new spacedata();
                List <spacegeo> geolist   = new List <spacegeo>();
                List <spacepnt> pntlist   = new List <spacepnt>();
                var             comList   = new KbscameramanageBLL().GetPageList("").Where(a => a.State == "在线" && a.CameraType == "枪机" && a.MonitoringArea != null).ToList();
                spacegeo        geo       = new spacegeo();
                geo.id = data.ID;
                if (data.Areacode != null)
                {//电子围栏坐标点
                    PositionsEntity alist = JsonConvert.DeserializeObject <PositionsEntity>(data.Areacode);
                    List <double>   dlist = new List <double>();
                    if (data.Areastate == 0)
                    {//矩形
                        geo.type     = 1;
                        geo.distance = 0;
                        //第一个点
                        dlist.Add(alist.positions[0].x);
                        dlist.Add(alist.positions[0].z);
                        //第二个点
                        dlist.Add(alist.positions[1].x);
                        dlist.Add(alist.positions[0].z);
                        //第三个点
                        dlist.Add(alist.positions[1].x);
                        dlist.Add(alist.positions[1].z);
                        //第四个点
                        dlist.Add(alist.positions[0].x);
                        dlist.Add(alist.positions[1].z);
                        //回到原点
                        dlist.Add(alist.positions[0].x);
                        dlist.Add(alist.positions[0].z);
                        geo.coor = dlist;
                        geolist.Add(geo);
                    }
                    else if (data.Areastate == 1)
                    {//圆形
                        geo.type = 0;
                        dlist.Add(alist.positions[0].x);
                        dlist.Add(alist.positions[0].z);
                        geo.distance = Convert.ToInt32(data.Radius);
                        geo.coor     = dlist;
                        geolist.Add(geo);
                    }
                    else if (data.Areastate == 2)
                    {//手绘多边形
                        foreach (var ac in alist.positions)
                        {
                            dlist.Add(ac.x);
                            dlist.Add(ac.z);
                        }
                        //闭合回到原点
                        dlist.Add(alist.positions[0].x);
                        dlist.Add(alist.positions[0].z);
                        geo.coor     = dlist;
                        geo.type     = 1;
                        geo.distance = 0;
                        geolist.Add(geo);
                    }

                    foreach (var com in comList)
                    {//摄像头坐标点集
                        PositionsEntity alist1 = JsonConvert.DeserializeObject <PositionsEntity>(com.MonitoringArea);
                        if (alist1.floorID == alist.floorID)
                        {
                            List <double> dlist1 = new List <double>();
                            foreach (var ac in alist1.positions)
                            {
                                dlist1.Add(ac.x);
                                dlist1.Add(ac.z);
                            }
                            //闭合回到原点
                            dlist1.Add(alist1.positions[0].x);
                            dlist1.Add(alist1.positions[0].z);
                            spacepnt pnt = new spacepnt()
                            {
                                id   = com.CameraId,
                                x    = 0,
                                y    = 0,
                                coor = dlist1
                            };
                            pntlist.Add(pnt);
                        }
                    }
                }
                sds.geo = geolist;
                sds.pnt = pntlist;
                sp.type = "2";
                sp.data = sds;
                string          rtn = HttpUtillibKbs.HttpThreeDPost(ThreeDApi, JsonConvert.SerializeObject(sp));
                List <RtnSpace> rss = JsonConvert.DeserializeObject <List <RtnSpace> >(rtn);
                foreach (var item in rss)
                {
                    if (string.IsNullOrEmpty(item.pntId))
                    {
                        continue;
                    }
                    ComerId += item.pntId + ',';
                }
                return(ComerId);
            }
            catch (Exception er)
            {
                return(ComerId);
            }
        }