Дипломная работа: Автоматизация учета рабочего времени сотрудников в ТОО "Профессиональные охранные системы"

Скачать файл

Заказать новую работу

Внимание! Если размещение файла нарушает Ваши авторские права, то обязательно сообщите нам

117

Приложение 2. Листинг программы

namespace WorkersTimes

{

using System;

using System.Collections.Generic;

using System.ComponentModel.DataAnnotations;

using System.ComponentModel.DataAnnotations.Schema;

using System.Data.Entity.Spatial;

public partial class Workers

{

[System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage",

"CA2214:DoNotCallOverridableMethodsInConstructors")]

public Workers()

{

Departments = new HashSet<Departments>();

Visits = new HashSet<Visits>();

Brigades = new HashSet<Brigades>();

Departments1 = new HashSet<Departments>();

}

[Key]

public int WorkerId { get; set; }

[StringLength(50)]

public string Name { get; set; }

[StringLength(50)]

public string Surname { get; set; }

[StringLength(50)]

public string Phone { get; set; }

[Column(TypeName = "money")]

public decimal? Salary { get; set; }

[StringLength(50)]

public string Address { get; set; }

[StringLength(50)]

public string Position { get; set; }

[System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage",

"CA2227:CollectionPropertiesShouldBeReadOnly")]

public virtual ICollection<Departments> Departments { get; set; }

[System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage",

"CA2227:CollectionPropertiesShouldBeReadOnly")]

public virtual ICollection<Visits> Visits { get; set; }

[System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage",

"CA2227:CollectionPropertiesShouldBeReadOnly")]

public virtual ICollection<Brigades> Brigades { get; set; }

[System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage",

"CA2227:CollectionPropertiesShouldBeReadOnly")]

public virtual ICollection<Departments> Departments1 { get; set; }

}

namespace WorkersTimes

{

118

using System;

using System.Collections.Generic;

using System.ComponentModel.DataAnnotations;

using System.ComponentModel.DataAnnotations.Schema;

using System.Data.Entity.Spatial;

public partial class Visits

{

[Key]

[Column(Order = 0, TypeName = "date")]

public DateTime Date { get; set; }

[Key]

[Column(Order = 1)]

[DatabaseGenerated(DatabaseGeneratedOption.None)]

public int WorkerId { get; set; }

public TimeSpan? Time_out { get; set; }

public TimeSpan? Time_in { get; set; }

public virtual Workers Workers { get; set; }

}

namespace WorkersTimes

{

using System;

using System.Collections.Generic;

using System.ComponentModel.DataAnnotations;

using System.ComponentModel.DataAnnotations.Schema;

using System.Data.Entity.Spatial;

public partial class sysdiagrams

{

[Required]

[StringLength(128)]

public string name { get; set; }

public int principal_id { get; set; }

[Key]

public int diagram_id { get; set; }

public int? version { get; set; }

public byte[] definition { get; set; }

}

using System;

using System.Collections.Generic;

using System.Linq;

using System.Threading.Tasks;

using System.Windows.Forms;

namespace WorkersTimes

{

static class Program

{

/// <summary>

/// Главная точка входа для приложения.

/// </summary>

[STAThread]

static void Main()

{

119

Application.EnableVisualStyles();

Application.SetCompatibleTextRenderingDefault(false);

Application.Run(new Login());

}

namespace WorkersTimes

{

using System;

using System.Data.Entity;

using System.ComponentModel.DataAnnotations.Schema;

using System.Linq;

public partial class Model1 : DbContext

{

public Model1()

: base("name=dbModel")

{

}

public virtual DbSet<Admins> Admins { get; set; }

public virtual DbSet<Brigades> Brigades { get; set; }

public virtual DbSet<Departments> Departments { get; set; }

public virtual DbSet<sysdiagrams> sysdiagrams { get; set; }

public virtual DbSet<Visits> Visits { get; set; }

public virtual DbSet<Workers> Workers { get; set; }

protected override void OnModelCreating(DbModelBuilder modelBuilder)

{

modelBuilder.Entity<Admins>()

.Property(e => e.Password)

.IsUnicode(false);

modelBuilder.Entity<Admins>()

.Property(e => e.email)

.IsUnicode(false);

modelBuilder.Entity<Brigades>()

.Property(e => e.Name)

.IsUnicode(false);

modelBuilder.Entity<Departments>()

.HasMany(e => e.Workers1)

.WithMany(e => e.Departments1)

.Map(m => m.ToTable("DepartmentsOfWorkers").MapLeftKey("Departmen-

tId").MapRightKey("WorkerId"));

modelBuilder.Entity<Visits>()

.Property(e => e.Time_out)

.HasPrecision(0);

modelBuilder.Entity<Visits>()

.Property(e => e.Time_in)

.HasPrecision(0);

modelBuilder.Entity<Workers>()

.Property(e => e.Name)

.IsUnicode(false);

modelBuilder.Entity<Workers>()

.Property(e => e.Surname)

.IsUnicode(false);

modelBuilder.Entity<Workers>()

120

.Property(e => e.Phone)

.IsUnicode(false);

modelBuilder.Entity<Workers>()

.Property(e => e.Salary)

.HasPrecision(19, 4);

modelBuilder.Entity<Workers>()

.Property(e => e.Address)

.IsUnicode(false);

modelBuilder.Entity<Workers>()

.Property(e => e.Position)

.IsUnicode(false);

modelBuilder.Entity<Workers>()

.HasMany(e => e.Departments)

.WithOptional(e => e.Workers)

.HasForeignKey(e => e.WorkerId);

modelBuilder.Entity<Workers>()

.HasMany(e => e.Visits)

.WithRequired(e => e.Workers)

.WillCascadeOnDelete(false);

modelBuilder.Entity<Workers>()

.HasMany(e => e.Brigades)

.WithMany(e => e.Workers)

.Map(m => m.ToTable("BrigadesOfWorkers").MapLeft-

Key("WorkerId").MapRightKey("BrigadeId"));

}

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

namespace WorkersTimes

{

static class Global

{

public static int KeyAvtor;

}

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

namespace WorkersTimes

{

static class Global

{

public static int KeyAvtor;

}

namespace WorkersTimes

{

using System;

using System.Collections.Generic;

using System.ComponentModel.DataAnnotations;

121

using System.ComponentModel.DataAnnotations.Schema;

using System.Data.Entity.Spatial;

public partial class Brigades

{

[System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage",

"CA2214:DoNotCallOverridableMethodsInConstructors")]

public Brigades()

{

Workers = new HashSet<Workers>();

}

[Key]

public int BrigadeId { get; set; }

[StringLength(50)]

public string Name { get; set; }

public int? DepartmentId { get; set; }

public virtual Departments Departments { get; set; }

[System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage",

"CA2227:CollectionPropertiesShouldBeReadOnly")]

public virtual ICollection<Workers> Workers { get; set; }

}

namespace WorkersTimes

{

using System;

using System.Collections.Generic;

using System.ComponentModel.DataAnnotations;

using System.ComponentModel.DataAnnotations.Schema;

using System.Data.Entity.Spatial;

public partial class Admins

{

[Key]

public int AdminId { get; set; }

[StringLength(50)]

public string Password { get; set; }

[StringLength(50)]

public string email { get; set; }

}

using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

using System.Windows.Forms;

namespace WorkersTimes

{

public partial class WorkTime : Form

{

Model1 DB = new Model1();

public WorkTime()

{

Источник: https://baza.diplomsite.ru/previewfile/2420

Смотрите также:

_3 тема - Диффузия
'Заповит' Рейнгольда Глиэра: стилистические особенности
'Создание и продвижение интернет - платформы реферальной системы' на примере компании Бартер–кард
[БИЛЕТЫ] IMK №3
[ТЕСТЫ] ИМК №1 по физиологии (база 1 семестр и на экз)
[ТЕСТЫ] Спланхнология
00363
00601
01. Концепция БД
02_ЛР