Esempio n. 1
0
 private void btnDelete_Click(object sender, EventArgs e)
 {
     try
     {
         using (IDbConnection cnn = new SqlConnection(HelperStatic.LoadConnectionString()))
         {
             string sql = $@"DELETE FROM  Unit  WHERE UnitID = {_mainFormUnit.UnitID}";
             cnn.Execute(sql);
         }
         string DeletePath = Application.StartupPath + @"\Data\Units\image\" + "\\" + _mainFormUnit.UnitID + ".jpg";
         File.Delete(DeletePath);
         DeletePath = Application.StartupPath + @"\Data\Units\pid\" + "\\" + _mainFormUnit.UnitID + ".pdf";
         File.Delete(DeletePath);
     }
     catch (Exception ex)
     {
         MessageBox.Show(ex.Message);
     }
     this.Close();
 }
Esempio n. 2
0
        public void frmTagFinder_Load(object sender, EventArgs e)
        {
            loadIsFinished = false;

            if (firstLoad)
            {
                #region reposition
                btnExit.Top  = 0;
                btnExit.Left = this.Width - btnExit.Width;

                btnMinimize.Top  = 0;
                btnMinimize.Left = btnExit.Left - btnExit.Width - 2;

                pnlTop.Height      = btnExit.Height = btnMinimize.Height = this.Height * 5 / 100;
                pnlUnit.Width      = btnEdit.Left + btnEdit.Width;
                pnlEquipment.Width = btnEditEquipmentType.Left + btnEditEquipmentType.Width;

                unitImagePictureBox.Dock = DockStyle.Fill;
                #endregion

                #region Binding

                /*unitBindingSource.DataSource = _CurrentUnit;
                 * unitBindingSource.ResetBindings(true);
                 *
                 * equipmentTypeBindingSource.DataSource = _CurrentEquipmentType;
                 * equipmentTypeBindingSource.ResetBindings(true);
                 *
                 * equipmentBindingSource.DataSource = _CurrentEquipment;
                 * equipmentBindingSource.ResetBindings(true);*/
                #endregion

                #region loadAllUnits
                using (IDbConnection cnn = new SqlConnection(HelperStatic.LoadConnectionString()))
                {
                    var p = new DynamicParameters();
                    p.Add("@tblName", "Unit");
                    string sql = "[dbo].[SelectTable]";
                    _AllUnins = cnn.Query <Unit>(sql, p,
                                                 commandType: CommandType.StoredProcedure).ToList();
                }
                #endregion

                #region loadAllEquipmentType
                using (IDbConnection cnn = new SqlConnection(HelperStatic.LoadConnectionString()))
                {
                    var p = new DynamicParameters();
                    p.Add("@tblName", "EquipmentType");
                    string sql = "[dbo].[SelectTable]";
                    _AllEquipmentTypes = cnn.Query <EquipmentType>(sql, p,
                                                                   commandType: CommandType.StoredProcedure).ToList();
                }
                #endregion

                #region loadAllEquipment
                using (IDbConnection cnn = new SqlConnection(HelperStatic.LoadConnectionString()))
                {
                    var p = new DynamicParameters();
                    p.Add("@tblName", "Equipment");
                    string sql = "[dbo].[SelectTable]";
                    _AllEquipments = cnn.Query <Equipment>(sql, p,
                                                           commandType: CommandType.StoredProcedure).ToList();
                    tagComboBox.DataSource = _AllEquipments.Select(x => x.Tag).ToList();
                }
                #endregion

                this.equipmentNameComboBox.SelectedIndexChanged += new System.EventHandler(this.equipmentNameComboBox_SelectedIndexChanged);
                this.unitNameComboBox.SelectedIndexChanged      += new System.EventHandler(this.unitNameComboBox_SelectedIndexChanged);
                equipmentNameComboBox_SelectedIndexChanged(sender, null);
                unitNameComboBox_SelectedIndexChanged(sender, null);

                unitNameComboBox.DataSource =
                    _AllUnins.OrderBy(x => x.UnitName).Select(x => x.UnitName).ToList();

                equipmentNameComboBox.DataSource =
                    _AllEquipmentTypes.OrderBy(x => x.EquipmentName).Select(x => x.EquipmentName).ToList();
                //test_Timer.Start();
                firstLoad = false;
            }

            List <Equipment> _AllSelectedEquipments = new List <Equipment>();// = _AllEquipments;
            switch (my_SelectEquipments)
            {
            case SelectEquipments.UnitSelected:
                _AllSelectedEquipments = _AllEquipments.Where(x => x.UnitID == _CurrentUnit.UnitID).ToList();
                break;

            case SelectEquipments.UnitAndType:
                _AllSelectedEquipments = _AllEquipments.Where(x => x.UnitID == _CurrentUnit.UnitID && x.EquipmentTypeID == _CurrentEquipmentType.EquipmentTypeID).ToList();
                break;

            case SelectEquipments.onlyOneTag:
                _AllSelectedEquipments = _AllEquipments.Where(x => x.Tag == _CurrentEquipment.Tag).ToList();
                break;

            /*case SelectEquipments.TypeSelected:
             *  break;
             * case SelectEquipments.nulll:
             *  break;*/
            default:
                break;
            }
            unitImagePictureBox.Controls.Clear();
            _AllSelectedEquipments = currectPositionEquipments(_AllSelectedEquipments);
            foreach (Equipment equipment in _AllSelectedEquipments)
            {
                int x = 0;
                Int32.TryParse(equipment.XOffset.ToString(), out x);
                int y = 0;
                Int32.TryParse(equipment.YOffset.ToString(), out y);
                MouseEventArgs e1 = new MouseEventArgs(MouseButtons.Left, 1, x, y, 1);
                my_clickedTask = ClickedTask.AddEquipment;
                unitImagePictureBox_MouseDown(sender, e1);
            }
            loadIsFinished = true;
        }
Esempio n. 3
0
        private List <Equipment> currectPositionEquipments(List <Equipment> allSelectedEquipments)
        {
            List <Equipment> TTTallSelectedEquipments = new List <Equipment>();// allSelectedEquipments;

            foreach (Equipment equipment in allSelectedEquipments)
            {
                TTTallSelectedEquipments.Add(equipment);
            }
            if (allSelectedEquipments.Where(x => x.IsDatum != true).Count() == 0)
            {
                return(TTTallSelectedEquipments);// = allSelectedEquipments;
            }
            List <Equipment> allDatums = _AllEquipments.Where(x => x.IsDatum == true && x.UnitID == allSelectedEquipments[0].UnitID).ToList();

            frmEquipment.isValidUintArea isValidUintArea1 = new frmEquipment.isValidUintArea();
            isValidUintArea1.left   = allDatums.Min(x => x.XOffset).Value;
            isValidUintArea1.right  = allDatums.Max(x => x.XOffset).Value;
            isValidUintArea1.top    = allDatums.Min(x => x.YOffset).Value;
            isValidUintArea1.bottom = allDatums.Max(x => x.YOffset).Value;


            if (isValidUintArea1.isValid)
            {
                TTTallSelectedEquipments.Clear();// = allDatums;//.Clear();
                foreach (Equipment equipment in allSelectedEquipments)
                {
                    if (equipment.IsDatum == true)
                    {
                        TTTallSelectedEquipments.Add(equipment);
                    }
                    else
                    {
                        double t1 = Convert.ToDouble(100 / equipment.XPercent);
                        var    p1 = (isValidUintArea1.right - isValidUintArea1.left);
                        double a  = isValidUintArea1.left + p1 / t1;

                        double t2 = Convert.ToDouble(100 / equipment.YPercent);
                        var    p2 = (isValidUintArea1.bottom - isValidUintArea1.top);
                        double b  = isValidUintArea1.top + p2 / t2;

                        if (equipment.XOffset - a > 5 && equipment.YOffset - b > 5)
                        {
                            try
                            {
                                using (IDbConnection cnn = new SqlConnection(HelperStatic.LoadConnectionString()))
                                {
                                    string sql     = $@"DELETE FROM  Equipment  WHERE EquipmentID = {equipment.EquipmentID}";
                                    int    deleted = cnn.Execute(sql);

                                    //INSERT INTO [dbo].[Equipment] (EquipmentID ,EquipmentTypeID,UnitID,Latitude,Longitude,XOffset,YOffset,IsDatum,Tag) VALUES (@EquipmentID ,@EquipmentTypeID2,@UnitID2,@Latitude,@Longitude,@XOffset,@YOffset,@IsDatum,@Tag)
                                    sql = $@"INSERT INTO [dbo].[Equipment] (EquipmentTypeID,UnitID,Latitude,Longitude,XOffset,YOffset,IsDatum,Tag) " +
                                          $@"VALUES (@EquipmentTypeID,@UnitID,@Latitude,@Longitude,@XOffset,@YOffset,@IsDatum,@Tag)";
                                    if (deleted > 0)
                                    {
                                        cnn.Execute(sql, equipment);
                                    }
                                }
                            }
                            catch (Exception ex)
                            {
                                throw ex;
                            }
                        }
                        TTTallSelectedEquipments.Add(equipment);
                    }
                }
            }

            return(TTTallSelectedEquipments);
        }