Exemplo n.º 1
0
 private void PictureBox1_Click(object sender, EventArgs e)
 {
     ///ToDo: не пускать этот код в продакшн
     using (kipEntities context = new kipEntities())
     {
         Worker worker = context.WorkerSet.Include("Position").Where(b => b.PersonnelNumber == 11179474).SingleOrDefault();
         if (worker == null)
         {
             Position pos = context.PositionSet.Where(b => b.name == "Администратор").SingleOrDefault();
             if (pos == null)
             {
                 pos = new Position
                 {
                     name = "Администратор",
                 };
                 context.PositionSet.Add(pos);
             }
             worker = new Worker
             {
                 Position        = pos,
                 Name            = "Тестовый",
                 Family          = "Профиль",
                 Patronymic      = "Администатора",
                 PersonnelNumber = 11100000,
                 PinCodeHash     = ""
             };
             context.WorkerSet.Add(worker);
             context.SaveChanges();
         }
         var position = worker.Position.Id;
         GetNextForm(position, worker);
     }
 }
Exemplo n.º 2
0
        private void FillNotWorkedList(string NodeText)
        {
            NotWorkedList.Items.Clear();
            LastSystemType = NodeText;

            using (kipEntities context = new kipEntities())
            {
                var equipments = from eqType in context.EquipmentSet
                                 where eqType.EquipmentType.name == NodeText
                                 select eqType;
                var nonWorked = from eq in equipments
                                where eq.isFree
                                select eq;
                foreach (var block in nonWorked)
                {
                    string str   = String.Format(" {0:P2}", block.GetRemainingLife());
                    var    color = block.GetColor();
                    if (!block.isWorking)
                    {
                        color = Color.DarkRed;
                        str   = " неиспр.";
                    }
                    NotWorkedList.Items.Add(block.EquipmentType.name + " " + block.number + str).ForeColor = color;
                }
            }

            foreach (ListViewItem item in InRepair.Items)
            {
                string str = item.Text;
                var    toRemoveFromList = NotWorkedList.FindItemWithText(str);
                NotWorkedList.Items.Remove(toRemoveFromList);
            }
        }
Exemplo n.º 3
0
        private void FillForm()
        {
            UserLabel.Text                 = worker.Family + " " + worker.Name + " " + worker.Patronymic;
            PersonnelNumberlLabel.Text     = worker.PersonnelNumber.ToString();
            PositionLabel.Text             = worker.Position.name;
            PersonnelNumberlLabel.Location = new Point(UserLabel.Location.X + UserLabel.Width + 20, PersonnelNumberlLabel.Location.Y);
            PositionLabel.Location         = new Point(UserLabel.Location.X + UserLabel.Width + 20, PositionLabel.Location.Y);

            using (kipEntities context = new kipEntities())
            {
                DateTime date = DateTime.Today.Date;

                var shed = context.SheduleSet.Where(b => b.date == date).SingleOrDefault();
                dayMVPSList.Items.Clear();

                if (shed != null)
                {
                    foreach (var to3 in shed.MVPS_Maintenance)
                    {
                        dayMVPSList.Items.Add("ТО3 " + to3.GetSeries());
                    }
                    foreach (var tr1 in shed.MVPS_Repair)
                    {
                        dayMVPSList.Items.Add("ТР1 " + tr1.GetSeries());
                    }
                }
                else
                {
                    dayMVPSList.Items.Add("Рассписания пока нет");
                }
            }
        }
Exemplo n.º 4
0
        public static void DoRepairOrCheck(Worker worker, List <string> descriptions, bool isRepair_)
        {
            int i = 0;

            foreach (var item in Items.GetItems)
            {
                using (kipEntities context = new kipEntities())
                {
                    Guid guid      = Guid.Parse(item.Block.Id);
                    var  eq        = context.EquipmentSet.Where(b => b.Id == guid).SingleOrDefault();
                    var  performer = context.WorkerSet.Where(b => b.Id == worker.Id).SingleOrDefault();
                    if (eq == null)
                    {
                        throw new Exception("Не найден блок с идентификатором " + guid.ToString());
                    }
                    else
                    {
                        eq.isWorking   = true;
                        eq.serviceDate = DateTime.Today.Date;
                        var service = new ServiceLog
                        {
                            date        = DateTime.Now,
                            description = descriptions[i++],
                            Equipment   = eq,
                            isRepair    = isRepair_,
                            Performer   = performer
                        };
                        context.ServiceLogSet.Add(service);
                        eq.ServiceLog.Add(service);
                        context.SaveChanges();
                    }
                }
            }
        }
Exemplo n.º 5
0
        private void Replacing(kipEntities context, Guid InEquipment, Guid OutEquipment, MVPS mvps, string input)
        {
            bool onShed = false;

            if (input == "По сроку.")
            {
                onShed = true;
            }

            Equipment InEq  = context.EquipmentSet.Where(b => b.Id == InEquipment).Single();
            Equipment OutEq = context.EquipmentSet.Where(b => b.Id == OutEquipment).Single();

            Worker performer = context.WorkerSet.Where(b => b.Id == worker.Id).Single();

            ReplacingLog replacing = new ReplacingLog
            {
                date        = DateTime.Now,
                description = input,
                Installed   = InEq,
                MVPS        = mvps,
                onShedule   = onShed,
                Removed     = OutEq,
                Worker      = performer
            };

            context.ReplacingLogSet.Add(replacing);
        }
Exemplo n.º 6
0
        private void FillEntity(int id)
        {
            using (kipEntities context = new kipEntities())
            {
                rule = context.EquipmentRuleSet.Where(b => b.Id == id).SingleOrDefault();

                for (int i = 0; i < MVPSRoleBox_.Items.Count; i++)
                {
                    if (MVPSRoleBox_.Items[i].ToString() == rule.MVPSRole.name)
                    {
                        MVPSRoleBox_.SelectedIndex = i;
                    }
                }

                for (int i = 0; i < MVPSTypeBox_.Items.Count; i++)
                {
                    if (MVPSTypeBox_.Items[i].ToString() == rule.MVPSType.name)
                    {
                        MVPSTypeBox_.SelectedIndex = i;
                    }
                }

                foreach (EquipmentType eq in rule.EquipmentType)
                {
                    EquipmentTypeBox.Items.Add(eq.name);
                    InRuleEqId.Add(eq.Id);
                }

                AddButton.Text = "Сохранить";
            }
        }
Exemplo n.º 7
0
 private void FillForm()
 {
     using (kipEntities context = new kipEntities())
     {
         try
         {
             var mvpsRole   = context.MVPSRoleSet.ToList();
             var mvpsType   = context.MVPSTypeSet.ToList();
             var systemType = context.SystemTypeSet.ToList();
             roleId.Clear();
             typeId.Clear();
             sysTypeId.Clear();
             foreach (MVPSRole role in mvpsRole)
             {
                 MVPSRoleBox_.Items.Add(role.name);
                 roleId.Add(role.Id);
             }
             foreach (MVPSType type in mvpsType)
             {
                 MVPSTypeBox_.Items.Add(type.name);
                 typeId.Add(type.Id);
             }
             foreach (SystemType type in systemType)
             {
                 SystemTypeBox.Items.Add(type.name);
                 sysTypeId.Add(type.Id);
             }
         }
         catch (Exception ex)
         {
             MessageBox.Show(ex.Message);
         }
     }
 }
Exemplo n.º 8
0
        private void FillForm()
        {
            using (kipEntities context = new kipEntities())
            {
                try
                {
                    var positions = context.PositionSet.ToList();

                    PositionBox.Items.Clear();

                    foreach (Position pos in positions)
                    {
                        PositionBox.Items.Add(pos.name);
                    }

                    if (worker != null)
                    {
                        NameBox.Text            = worker.Name;
                        FamilyBox.Text          = worker.Family;
                        PatronymicBox.Text      = worker.Patronymic;
                        PersonnelNumberBox.Text = worker.PersonnelNumber.ToString();
                        worker = null;
                    }
                }
                catch (Exception ex)
                {
                    MessageBox.Show(ex.Message);
                }
            }
        }
Exemplo n.º 9
0
        private void FillEntity(int id)
        {
            using (kipEntities context = new kipEntities())
            {
                type = context.EquipmentTypeSet.Where(b => b.Id == id).SingleOrDefault();

                for (int i = 0; i < SysTypeBox.Items.Count; i++)
                {
                    if (SysTypeBox.Items[i].ToString() == type.SystemType.name)
                    {
                        SysTypeBox.SelectedIndex = i;
                    }
                }

                for (int i = 0; i < ManufactBox.Items.Count; i++)
                {
                    if (ManufactBox.Items[i].ToString() == type.Manufacturer.name)
                    {
                        ManufactBox.SelectedIndex = i;
                    }
                }

                DescriptionBox.Text        = type.description;
                NameBox.Text               = type.name;
                VerificationPeriodBox.Text = type.verfPeriod.ToString();
                ServicePeriodBox.Text      = type.servicePeriod.ToString();

                AddButton.Text = "Сохранить";
            }
        }
Exemplo n.º 10
0
        private void FillEntity(Guid id)
        {
            using (kipEntities context = new kipEntities())
            {
                mVPS           = context.MVPSSet.Where(b => b.Id == id).SingleOrDefault();
                NumberBox.Text = mVPS.number;
                SeriesBox.Text = mVPS.series;

                for (int i = 0; i < RoleBox.Items.Count; i++)
                {
                    if (RoleBox.Items[i].ToString() == mVPS.MVPSRole.name)
                    {
                        RoleBox.SelectedIndex = i;
                    }
                }

                for (int i = 0; i < TypeBox.Items.Count; i++)
                {
                    if (TypeBox.Items[i].ToString() == mVPS.MVPSType.name)
                    {
                        TypeBox.SelectedIndex = i;
                    }
                }

                AddButton.Text = "Сохранить";
                IdBox.Text     = mVPS.Id.ToString();
            }
        }
Exemplo n.º 11
0
        private void RuleBox_SelectedIndexChanged(object sender, EventArgs e)
        {
            using (kipEntities context = new kipEntities())
            {
                try
                {
                    if ((TypeBox.SelectedIndex == -1) || (RoleBox.SelectedIndex == -1))
                    {
                        throw new Exception("Необходимо выбрать роль и тип МВПС");
                    }

                    int key   = currentRules[RuleBox.SelectedIndex].Id;
                    var types = context.EquipmentRuleSet.Where(b => b.Id == key).SingleOrDefault();
                    RuleList.Items.Clear();
                    foreach (EquipmentType type in types.EquipmentType)
                    {
                        RuleList.Items.Add(type.name);
                    }
                }
                catch (Exception ex)
                {
                    MessageBox.Show(ex.Message);
                }
            }
        }
Exemplo n.º 12
0
 private void DoServiceButton_Click(object sender, EventArgs e)
 {
     if (CheckAllInRepair(false))
     {
         var result = MessageBox.Show("Открыть дефектные ведомости?", "Ремонт оборудования", MessageBoxButtons.YesNo);
         foreach (ListViewItem item in InRepair.Items)
         {
             string[] vs = item.Text.Split(' ');
             using (kipEntities context = new kipEntities())
             {
                 string type = vs[0], number = vs[1];
                 var    eq = context.EquipmentSet.Where(b => b.EquipmentType.name == type && b.number == number).SingleOrDefault();
                 if (eq == null)
                 {
                     throw new Exception("Что-то пошло не так, не найден блок с типом " + vs[0] + " и номером" + vs[1]);
                 }
                 else
                 {
                     Items.CreateItem(vs[0], vs[1], eq.Id.ToString(), false);
                 }
             }
         }
         if (result == DialogResult.Yes)
         {
             Docs.OpenDocs(Items.GetItems);
         }
         Repair.DoRepairOrCheck(worker, Comments, false);
         Comments.Clear();
         InRepair.Clear();
         FillNotWorkedList(LastSystemType);
     }
 }
Exemplo n.º 13
0
        private void FillList()
        {
            using (kipEntities context = new kipEntities())
            {
                DateTime date = dateTimePicker1.Value.Date;

                var shed = context.SheduleSet.Where(b => b.date == date).SingleOrDefault();
                DayMVPSList.Items.Clear();

                if (shed != null)
                {
                    foreach (var to3 in shed.MVPS_Maintenance)
                    {
                        DayMVPSList.Items.Add("ТО3 " + to3.GetSeries());
                    }
                    foreach (var tr1 in shed.MVPS_Repair)
                    {
                        DayMVPSList.Items.Add("ТР1 " + tr1.GetSeries());
                    }
                }
                else
                {
                    DayMVPSList.Items.Add("Рассписания пока нет");
                }
            }
        }
Exemplo n.º 14
0
 private void FillForm(Guid id)
 {
     using (kipEntities context = new kipEntities())
     {
         var eq = context.EquipmentSet.Where(b => b.Id == id).SingleOrDefault();
         FillByEquipment(eq);
     }
 }
Exemplo n.º 15
0
 private void AddButton_Click(object sender, EventArgs e)
 {
     using (kipEntities context = new kipEntities())
     {
         try
         {
             CheckFields();
             if (manufacturer != null)
             {
                 int          key      = manufacturer.Id;
                 Manufacturer freshMan = context.ManufacturerSet.Where(b => b.Id == key).SingleOrDefault();
                 string       str      = ManufacturerNameBox.Text;
                 if ((freshMan.name != str) && (str != ""))
                 {
                     freshMan.name = str;
                 }
                 if ((ManufacturerAddressBox.Text != "") && (ManufacturerAddressBox.Text != freshMan.address))
                 {
                     freshMan.address = ManufacturerAddressBox.Text;
                 }
                 if ((ManufacturerPhoneBox.Text != "") && (ManufacturerPhoneBox.Text != freshMan.phone))
                 {
                     freshMan.phone = ManufacturerPhoneBox.Text;
                 }
                 if ((ManufacturerEmailBox.Text != "") && (ManufacturerEmailBox.Text != freshMan.email))
                 {
                     freshMan.email = ManufacturerEmailBox.Text;
                 }
                 context.SaveChanges();
             }
             else
             {
                 CheckFields();
                 string str = ManufacturerNameBox.Text;
                 if (str != "")
                 {
                     Manufacturer freshMan = new Manufacturer
                     {
                         name    = str,
                         address = ManufacturerAddressBox.Text,
                         phone   = ManufacturerPhoneBox.Text,
                         email   = ManufacturerEmailBox.Text,
                     };
                     context.ManufacturerSet.Add(freshMan);
                     context.SaveChanges();
                 }
             }
         }
         catch (Exception ex)
         {
             MessageBox.Show(ex.Message);
         }
         finally
         {
             Close();
         }
     }
 }
Exemplo n.º 16
0
 private void FillForm(int id)
 {
     using (kipEntities context = new kipEntities())
     {
         var service = context.ServiceLogSet.Where(b => b.Id == id).SingleOrDefault();
         var eq      = service.Equipment;
         FillByEquipment(eq);
     }
 }
Exemplo n.º 17
0
 private void AddButton_Click(object sender, EventArgs e)
 {
     using (kipEntities context = new kipEntities())
     {
         try
         {
             if (SystemTypeNameBox.Text == "Введите название системы")
             {
                 throw new Exception("Введите коректное название системы");
             }
             if (SystemTypeDescriptionBox.Text == "Введите описание системы")
             {
                 throw new Exception("Введите коректное описание системы");
             }
             if (type != null)
             {
                 int        key          = type.Id;
                 SystemType freshSysType = context.SystemTypeSet.Where(b => b.Id == key).SingleOrDefault();
                 string     str          = SystemTypeNameBox.Text;
                 if (str != "")
                 {
                     if (str != freshSysType.name)
                     {
                         freshSysType.name = str;
                     }
                     if (SystemTypeDescriptionBox.Text != freshSysType.description)
                     {
                         freshSysType.description = SystemTypeDescriptionBox.Text;
                     }
                     context.SaveChanges();
                 }
             }
             else
             {
                 string str = SystemTypeNameBox.Text;
                 if (str != "")
                 {
                     SystemType freshSysType = new SystemType
                     {
                         name        = str,
                         description = SystemTypeDescriptionBox.Text
                     };
                     context.SystemTypeSet.Add(freshSysType);
                     context.SaveChanges();
                 }
             }
         }
         catch (Exception ex)
         {
             MessageBox.Show(ex.Message);
         }
         finally
         {
             Close();
         }
     }
 }
Exemplo n.º 18
0
 private void FillEntity(int id)
 {
     using (kipEntities context = new kipEntities())
     {
         role             = context.MVPSRoleSet.Where(b => b.Id == id).SingleOrDefault();
         MVPSRoleBox.Text = role.name;
     }
     AddButton.Text = "Сохранить";
 }
Exemplo n.º 19
0
        private void FillForm()
        {
            using (kipEntities context = new kipEntities())
            {
                try
                {
                    var           roles        = context.MVPSRoleSet.ToList();
                    var           types        = context.MVPSTypeSet.ToList();
                    var           seriesSet    = context.MVPSSet.Select(b => b.series).ToList();
                    List <string> unicalSeries = new List <string>();

                    MVPSRoleBox.Items.Add("Любой");
                    MVPSTypeBox.Items.Add("Любой");

                    foreach (MVPSRole role in roles)
                    {
                        MVPSRoleBox.Items.Add(role.name);
                    }
                    foreach (MVPSType type in types)
                    {
                        MVPSTypeBox.Items.Add(type.name);
                    }
                    foreach (string series in seriesSet)
                    {
                        if (unicalSeries.Find(b => b == series) != series)
                        {
                            unicalSeries.Add(series);
                        }
                    }
                    DateTime date         = DateTime.Today.Date;
                    var      todayShedule = context.SheduleSet.Where(b => b.date == date).SingleOrDefault();

                    foreach (string str in unicalSeries)
                    {
                        if (worker != null)
                        {
                            if (todayShedule != null)
                            {
                                if (todayShedule.ContainSeries(str))
                                {
                                    MVPSSeriesBox.Items.Add(str);
                                }
                            }
                        }
                        else
                        {
                            MVPSSeriesBox.Items.Add(str);
                        }
                    }
                }
                catch (Exception ex)
                {
                    MessageBox.Show(ex.Message);
                }
            }
        }
Exemplo n.º 20
0
 private void FillEntity(int id)
 {
     using (kipEntities context = new kipEntities())
     {
         type = context.SystemTypeSet.Where(b => b.Id == id).SingleOrDefault();
         SystemTypeNameBox.Text        = type.name;
         SystemTypeDescriptionBox.Text = type.description;
     }
     AddButton.Text = "Сохранить";
 }
Exemplo n.º 21
0
        private void FillForm()
        {
            using (kipEntities context = new kipEntities())
            {
                try
                {
                    IdBox.Text = Guid.NewGuid().ToString();
                    //TypeBox & RoleBox
                    var types        = context.MVPSTypeSet.ToList();
                    var roles        = context.MVPSRoleSet.ToList();
                    var currentRules = context.EquipmentRuleSet.ToList();

                    foreach (MVPSRole role in roles)
                    {
                        RoleBox.Items.Add(role.name);
                        roleIds.Add(role.Id);
                    }

                    foreach (MVPSType type in types)
                    {
                        TypeBox.Items.Add(type.name);
                        typeIds.Add(type.Id);
                    }

                    if (mVPS != null)
                    {
                        for (int i = 0; i < RoleBox.Items.Count; i++)
                        {
                            if (RoleBox.Items[i].ToString() == mVPS.MVPSRole.name)
                            {
                                RoleBox.SelectedIndex = i;
                            }
                        }

                        for (int i = 0; i < TypeBox.Items.Count; i++)
                        {
                            if (TypeBox.Items[i].ToString() == mVPS.MVPSType.name)
                            {
                                TypeBox.SelectedIndex = i;
                            }
                        }

                        GetRuleList();
                        SeriesBox.Text = mVPS.series;
                    }
                    mVPS = null;
                }
                catch (Exception ex)
                {
                    MessageBox.Show(ex.Message);
                }
            }
        }
Exemplo n.º 22
0
 private void FillEntity(int id)
 {
     using (kipEntities context = new kipEntities())
     {
         manufacturer                = context.ManufacturerSet.Where(b => b.Id == id).SingleOrDefault();
         ManufacturerNameBox.Text    = manufacturer.name;
         ManufacturerAddressBox.Text = manufacturer.address;
         ManufacturerPhoneBox.Text   = manufacturer.phone;
         ManufacturerEmailBox.Text   = manufacturer.email;
     }
     AddButton.Text = "Сохранить";
 }
Exemplo n.º 23
0
        private void FillForm()
        {
            using (kipEntities context = new kipEntities())
            {
                var types = context.EquipmentTypeSet.ToList();
                typeIds.Clear();
                foreach (var type in types)
                {
                    TypeBox.Items.Add(type.name);
                    typeIds.Add(type.Id);
                }

                IdBox.Text = Guid.NewGuid().ToString();

                if (eq != null)
                {
                    try
                    {
                        IsWorking.Checked = eq.isWorking;
                        IsFree.Checked    = eq.isFree;

                        for (int i = 0; i < TypeBox.Items.Count; i++)
                        {
                            if (TypeBox.Items[i].ToString() == eq.EquipmentType.name)
                            {
                                TypeBox.SelectedIndex = i;
                            }
                        }
                        DateTime date;
                        if (eq.nextVerificationDate.HasValue)
                        {
                            date = eq.nextVerificationDate.Value;
                            VerificationDate.Text = date.ToString("dd.MM.yy");
                        }
                        if (eq.termDate.HasValue)
                        {
                            date = eq.termDate.Value;
                            TerminationDate.Text = date.ToString("dd.MM.yy");
                        }
                        RepairDate.Text  = eq.repairDate.ToString("dd.MM.yy");
                        ServiceDate.Text = eq.serviceDate.ToString("dd.MM.yy");
                    }
                    catch (Exception ex)
                    {
                        MessageBox.Show(ex.Message);
                    }
                    finally
                    {
                        eq = null;
                    }
                }
            }
        }
Exemplo n.º 24
0
        private bool checkUnStaffed(MVPS mvp, kipEntities context)
        {
            var mvps = context.MVPSSet.Where(b => b.series == mvp.series);

            foreach (var m in mvps)
            {
                if (!m.IsStaffed())
                {
                    return(false);
                }
            }
            return(true);
        }
Exemplo n.º 25
0
        private void FillGrid()
        {
            mvpsGuid = Guid.Empty;

            if (CheckAllSelected())
            {
                using (kipEntities context = new kipEntities())
                {
                    try
                    {
                        var type   = MVPSTypeBox.SelectedItem.ToString();
                        var series = MVPSSeriesBox.SelectedItem.ToString();
                        var number = MVPSNumberBox.SelectedItem.ToString();

                        MVPS mvps = context.MVPSSet.Where(b => (b.series == series) &&
                                                          (b.MVPSType.name == type) && (b.number == number)).SingleOrDefault();

                        mvpsGuid = mvps.Id;

                        var rules = mvps.EquipmentRule.EquipmentType.ToList();
                        int i     = 0;
                        mvpsGrid.Rows.Clear();
                        foreach (var rule in rules)
                        {
                            string cell1 = null, cell2 = null, cell3 = null, cell4 = null;
                            var    block = mvps.Equipment.Where(b => b.EquipmentType == rule).SingleOrDefault();
                            Guid?  cell0 = null;
                            cell1 = rule.name;
                            cell2 = rule.SystemType.name;
                            if (block != null)
                            {
                                cell0 = block.Id;
                                cell3 = block.number;
                                cell4 = block.serviceDate.ToString("dd.MM.yy");
                            }

                            mvpsGrid.Rows.Add(cell0, cell1, cell2, cell3, cell4);
                            i++;
                        }

                        FillEquipmentGrid(mvpsGrid[1, 0].Value.ToString());
                        //var equipments = mvps.Equipment
                    }
                    catch (Exception ex)
                    {
                        MessageBox.Show(ex.Message);
                    }
                }
            }
        }
Exemplo n.º 26
0
        private void MvpsGrid_CellDoubleClick(Object sender, DataGridViewCellEventArgs e)
        {
            if (CheckAllSelected() && !CheckEmpty())
            {
                using (kipEntities context = new kipEntities())
                {
                    Guid      id        = Guid.Parse(mvpsGrid[0, e.RowIndex].Value.ToString());
                    Equipment equipment = context.EquipmentSet.Where(b => b.Id == id).SingleOrDefault();

                    DialogResult result = MessageBox.Show("Нажмите \"Да\", если блок снимается по неисправности. Если блок снимается по другой причине - нажмите \"Нет\"", "Снимаем " + equipment.EquipmentType.name + " № " + equipment.number, MessageBoxButtons.YesNoCancel);

                    MVPS mvps = context.MVPSSet.Where(b => b.Id == mvpsGuid).SingleOrDefault();

                    equipment.isFree = true;
                    mvps.Equipment.Remove(equipment);
                    context.SaveChanges();

                    switch (result)
                    {
                    case DialogResult.Yes:
                        equipment.isWorking = false;
                        equipment.isFree    = true;
                        mvps.Equipment.Remove(equipment);
                        if (worker != null)
                        {
                            OutGuid = equipment.Id;
                            input   = Microsoft.VisualBasic.Interaction.InputBox("Введите комментарий к замене", "Замена оборудования", "По сроку.", -1, -1);
                        }
                        context.SaveChanges();
                        break;

                    case DialogResult.No:
                        equipment.isFree = true;
                        mvps.Equipment.Remove(equipment);
                        if (worker != null)
                        {
                            OutGuid = equipment.Id;
                            input   = Microsoft.VisualBasic.Interaction.InputBox("Введите комментарий к замене", "Замена оборудования", "По сроку.", -1, -1);
                        }
                        context.SaveChanges();
                        break;

                    case DialogResult.Cancel:
                        break;
                    }
                }
                FillGrid();
            }
        }
Exemplo n.º 27
0
        private void FillForm()
        {
            UserLabel.Text                 = worker.Family + " " + worker.Name + " " + worker.Patronymic;
            PersonnelNumberlLabel.Text     = worker.PersonnelNumber.ToString();
            PositionLabel.Text             = worker.Position.name;
            PersonnelNumberlLabel.Location = new Point(UserLabel.Location.X + UserLabel.Width + 20, PersonnelNumberlLabel.Location.Y);
            PositionLabel.Location         = new Point(UserLabel.Location.X + UserLabel.Width + 20, PositionLabel.Location.Y);

            using (kipEntities context = new kipEntities())
            {
                ServiceableEquipmentCount.Text = context.EquipmentSet.Where(b => b.isFree && b.isWorking).Count().ToString();
                InstalledEquipmentCount.Text   = context.EquipmentSet.Where(b => !b.isFree && b.isWorking).Count().ToString();
                FaultyEquipment.Text           = context.EquipmentSet.Where(b => !b.isWorking).Count().ToString();
            }
        }
Exemplo n.º 28
0
        public DataGridViewRow GetRow()
        {
            var row = new DataGridViewRow();

            using (kipEntities context = new kipEntities()) {
                string remStr    = null;
                string insStr    = null;
                string mvpsStr   = null;
                string workerStr = null;
                //тут что то не так.
                Equipment rem = context.EquipmentSet.Where(b => b.Id == Removed.Id).SingleOrDefault();
                Equipment ins = context.EquipmentSet.Where(b => b.Id == Installed.Id).SingleOrDefault();
                if (rem != null)
                {
                    remStr = rem.EquipmentType.name + " № " + rem.number;
                }
                if (ins != null)
                {
                    insStr = ins.EquipmentType.name + " № " + ins.number;
                }

                mvpsStr   = MVPS.MVPSType.name + " " + MVPS.series + " " + MVPS.number;
                workerStr = Worker.GetFIO();

                row.Cells.Add(new DataGridViewTextBoxCell {
                    Value = Id
                });
                row.Cells.Add(new DataGridViewTextBoxCell {
                    Value = date.ToString("dd.MM.yy H:mm")
                });
                row.Cells.Add(new DataGridViewTextBoxCell {
                    Value = remStr
                });
                row.Cells.Add(new DataGridViewTextBoxCell {
                    Value = insStr
                });
                row.Cells.Add(new DataGridViewTextBoxCell {
                    Value = description
                });
                row.Cells.Add(new DataGridViewTextBoxCell {
                    Value = mvpsStr
                });
                row.Cells.Add(new DataGridViewTextBoxCell {
                    Value = workerStr
                });
            }
            return(row);
        }
Exemplo n.º 29
0
 private void TypeBox_SelectedIndexChanged(object sender, EventArgs e)
 {
     using (kipEntities context = new kipEntities())
     {
         int typeId = typeIds[TypeBox.SelectedIndex];
         var type   = context.EquipmentTypeSet.Where(b => b.Id == typeId).SingleOrDefault();
         if ((!type.verfPeriod.HasValue) || (type.verfPeriod.Value == 0))
         {
             VerificationDate.Enabled = false;
         }
         else
         {
             VerificationDate.Enabled = true;
         }
     }
 }
Exemplo n.º 30
0
 private void FillEquipmentGrid(string v)
 {
     using (kipEntities context = new kipEntities())
         try
         {
             var equipments = context.EquipmentSet.Where(b => (b.EquipmentType.name == v) && (b.isFree) && (b.isWorking)).ToList();
             equipmentGrid.Rows.Clear();
             foreach (var eq in equipments)
             {
                 equipmentGrid.Rows.Add(eq.Id, eq.EquipmentType.name, eq.number.ToString(), eq.serviceDate.ToString("dd.MM.yy"));
             }
         }
         catch (Exception ex)
         {
             MessageBox.Show(ex.Message);
         }
 }