112
Результатом проекта являются улучшения показателей работы компа-
нии, за счет автоматизации работы по генерации треков компании ООО “Све-
жий ветер”.
113
Список литературы
1. «Методология функционального моделирования IDEF0», Руководя-
щий документ, Госстандарт России.;
2. Мишенин А. И. «Теория экономических информационных систем»,
Москва: Финансы и статистика, 2007г. – 240 с.: ил.;
3. Микрюков В. Ю. «Информация, информатика, компьютер, информа-
ционные системы, сети», Москва: Феникс, 2007г. – 448 с.: ил.;
4. Лекция: Основные понятия технологии проектирования информаци-
онных систем (ИС) http://www.intuit.ru
5. Андреас Вайгенд «BIG DATA. Вся технология в одной книге»,
Москва: Эксмо, Бомбора, 2016 г. 120 – 180 с.: ил.;
6. Сайт московского исследовательского института системного проекти-
рования http://miisp.ru/index.php?option=content&task=view&id=491
7.http://www.microsoft.com/Rus/WindowsServer2003/evaluation/features/c
ompareeditions.mspx
8. ГОСТ Р ИСО/МЭК 12207-99 – «Информационная техноло-
гия. Процессы жизненного цикла программных средств» Руководящий доку-
мент, Госстандарт России, Москва, Переиздан июль 2008г.
9. АвторИцхак Калдерон Адизес – «Управление жизненным циклом
корпораций» Манн, Иванов И Фербер июль 2018г.
10. Гулиян Г.Б., Нестеров И.А. «Основы организации компьютерных
сетей. Часть 1.», Московская финансово-промышленная академия. – М., 2007г.
– 169 с. ил.;
11. http://www.rodnik.ru/product/server/rab_station/server/ Критерии вы-
бора серверной платформы.
12. Методология и технология ЖЦ http://cmcons.com/articles/ob-
shhie_stati_rup/
13. Сайт московского исследовательского института системного проек-
тирования http://miisp.ru/index.php?option=content&task=view&id=491
114
14. Хомоненко А. Д., Цыганков В. М., Мальцев М. Г. «Баз данных»,
Учебник, Корона – Век, 2010г. – 736 с.: ил.;
15. Томас Коннолли, Каролин Бегг – “Базы данных. Проектирование,
реализация и сопровождение. Теория и практика”, Вильямс 2016 г. -240 с.: ил;
16. Крис Дейт – «Введение в системы баз данных», Диалектика 2016 г. –
20 с.: ил.;
17. Тарасов Сергей Витальевич – «Сергей Тарасов: СУБД для програм-
миста. Базы данных изнутри», Солон-пресс 2015 г. – 60 с.: ил.;
18. О. С. Сухарев – “Теория эффективности экономики”, КУРС, Инфра-
М 2015 г. - 40 с.: ил..
115
ПРИЛОЖЕНИЕ А (Листинг программы)
namespace RadioManager
{
using System;
using System.Collections.Generic;
using System.ComponentModel.DataAnnotations;
using System.ComponentModel.DataAnnotations.Schema;
using System.Data.Entity.Spatial;
public partial class Performers
{
[System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2214:Do-
NotCallOverridableMethodsInConstructors")]
public Performers()
{
Tracks = new HashSet<Tracks>();
}
[Key]
public int PerformerId { get; set; }
[StringLength(60)]
public string Name { get; set; }
[StringLength(60)]
public string Surname { get; set; }
[Column(TypeName = "date")]
public DateTime? DateOfBirth { get; set; }
[System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2227:Col-
lectionPropertiesShouldBeReadOnly")]
public virtual ICollection<Tracks> Tracks { get; set; }
}
}
namespace RadioManager
{
using System;
using System.Collections.Generic;
using System.ComponentModel.DataAnnotations;
using System.ComponentModel.DataAnnotations.Schema;
using System.Data.Entity.Spatial;
public partial class PlayLetters
{
[System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2214:Do-
NotCallOverridableMethodsInConstructors")]
public PlayLetters()
{
PlayTracks = new HashSet<PlayTracks>();
}
[Key]
public int PlayLetterId { get; set; }
public int? CountTreck { get; set; }
public int? RadioStationId { get; set; }
116
[Column(TypeName = "date")]
public DateTime? DateCreate { get; set; }
[System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2227:Col-
lectionPropertiesShouldBeReadOnly")]
public virtual ICollection<PlayTracks> PlayTracks { get; set; }
public virtual RadioStations RadioStations { get; set; }
}
}
namespace RadioManager
{
using System;
using System.Collections.Generic;
using System.ComponentModel.DataAnnotations;
using System.ComponentModel.DataAnnotations.Schema;
using System.Data.Entity.Spatial;
public partial class PlayTracks
{
[Key]
[Column(Order = 0)]
[DatabaseGenerated(DatabaseGeneratedOption.None)]
public int Number { get; set; }
[Key]
[Column(Order = 1)]
[DatabaseGenerated(DatabaseGeneratedOption.None)]
public int PlayLetterId { get; set; }
[Key]
[Column(Order = 2)]
[DatabaseGenerated(DatabaseGeneratedOption.None)]
public int TrackId { get; set; }
public virtual PlayLetters PlayLetters { get; set; }
public virtual Tracks Tracks { get; set; }
}
}
namespace RadioManager
{
using System;
using System.Data.Entity;
using System.ComponentModel.DataAnnotations.Schema;
using System.Linq;
public partial class RadioManager : DbContext
{
public RadioManager()
: base("name=RadioManager")
{
}
public virtual DbSet<Genres> Genres { get; set; }
public virtual DbSet<Performers> Performers { get; set; }
public virtual DbSet<PlayLetters> PlayLetters { get; set; }
public virtual DbSet<PlayTracks> PlayTracks { get; set; }
public virtual DbSet<RadioStations> RadioStations { get; set; }
public virtual DbSet<sysdiagrams> sysdiagrams { get; set; }
public virtual DbSet<Tracks> Tracks { get; set; }
117
protected override void OnModelCreating(DbModelBuilder modelBuilder)
{
modelBuilder.Entity<PlayLetters>()
.HasMany(e => e.PlayTracks)
.WithRequired(e => e.PlayLetters)
.WillCascadeOnDelete(false);
modelBuilder.Entity<Tracks>()
.HasMany(e => e.PlayTracks)
.WithRequired(e => e.Tracks)
.WillCascadeOnDelete(false);
}
}
}
namespace RadioManager
{
using System;
using System.Collections.Generic;
using System.ComponentModel.DataAnnotations;
using System.ComponentModel.DataAnnotations.Schema;
using System.Data.Entity.Spatial;
public partial class RadioStations
{
[System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2214:Do-
NotCallOverridableMethodsInConstructors")]
public RadioStations()
{
PlayLetters = new HashSet<PlayLetters>();
}
[Key]
public int RadioStationId { get; set; }
[StringLength(60)]
public string Name { get; set; }
[System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2227:Col-
lectionPropertiesShouldBeReadOnly")]
public virtual ICollection<PlayLetters> PlayLetters { get; set; }
}
}
namespace RadioManager
{
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; }
118
}
}
namespace RadioManager
{
using System;
using System.Collections.Generic;
using System.ComponentModel.DataAnnotations;
using System.ComponentModel.DataAnnotations.Schema;
using System.Data.Entity.Spatial;
public partial class Tracks
{
[System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2214:Do-
NotCallOverridableMethodsInConstructors")]
public Tracks()
{
PlayTracks = new HashSet<PlayTracks>();
}
[Key]
public int TrackId { get; set; }
[StringLength(60)]
public string Name { get; set; }
[Column(TypeName = "date")]
public DateTime? DateOfIssue { get; set; }
[StringLength(60)]
public string Status { get; set; }
public int? GenreId { get; set; }
public int? PerformerId { get; set; }
public virtual Genres Genres { get; set; }
public virtual Performers Performers { get; set; }
[System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2227:Col-
lectionPropertiesShouldBeReadOnly")]
public virtual ICollection<PlayTracks> PlayTracks { 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 RadioManager
{
public partial class showListPlay : Form
{
RadioManager DB = new RadioManager();
public showListPlay()
{
InitializeComponent();
119
}
private void label14_Click(object sender, EventArgs e)
{
Owner.Show(); //Show the previous form
Hide();
}
private void dateTimePicker1_ValueChanged(object sender, EventArgs e)
{
var listTrack = DB.PlayLetters.Select(p => new {
Код_плейлиста = p.PlayLetterId,
Количество_треков =p.CountTreck,
Код_радиостанции = p.RadioStationId,
Дата_создания =p.DateCreate
}).Where(p2 => p2.Дата_создания.Value == dateTimePicker1.Value);
var pr1Q1 = listTrack.Take(300).ToList();
dataGridView1.DataSource = pr1Q1;
}
private void showListPlay_Load(object sender, EventArgs e)
{
var listTrack = DB.PlayLetters.Select(p => new
{
Код_плейлиста = p.PlayLetterId,
Количество_треков = p.CountTreck,
Код_радиостанции = p.RadioStationId,
Дата_создания = p.DateCreate
});
var pr1Q1 = listTrack.Take(300).ToList();
dataGridView1.DataSource = pr1Q1;
}
private void label7_Click(object sender, EventArgs e)
{
try
{
Microsoft.Office.Interop.Excel.Application excel = new Microsoft.Of-
fice.Interop.Excel.Application();
excel.Visible = true;
Microsoft.Office.Interop.Excel.Workbook workbook = excel.Work-
books.Add(System.Reflection.Missing.Value);
Microsoft.Office.Interop.Excel.Worksheet sheet1 = (Microsoft.Office.In-
terop.Excel.Worksheet)workbook.Sheets[1];
int StartCol = 1;
int StartRow = 1;
int j = 0, i = 0;
//Write Headers
for (j = 0; j < dataGridView1.Columns.Count; j++)
{
Microsoft.Office.Interop.Excel.Range myRange = (Microsoft.Office.In-
terop.Excel.Range)sheet1.Cells[StartRow, StartCol + j];
myRange.Value2 = dataGridView1.Columns[j].HeaderText;
}
StartRow++;
//Write datagridview content
for (i = 0; i < dataGridView1.Rows.Count; i++)
{
for (j = 0; j < dataGridView1.Columns.Count; j++)
120
{
try
{
Microsoft.Office.Interop.Excel.Range myRange = (Microsoft.Of-
fice.Interop.Excel.Range)sheet1.Cells[StartRow + i, StartCol + j];
myRange.Value2 = dataGridView1[j, i].Value == null ? "" :
dataGridView1[j, i].Value;
}
catch
{
;
}
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
}
}
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 RadioManager
{
public partial class Main : Form
{
GreatPlayearList frm2;
addTrekAndGarde frm3;
showListPlay frm4;
deleteTrackOrPlayList frm5;
Help frm6;
public Main()
{
InitializeComponent();
/*this.BackColor = Color.LimeGreen;
this.TransparencyKey = Color.LimeGreen;*/
}
private void label2_Click(object sender, EventArgs e)
{
if (frm3 == null)
{
frm3 = new addTrekAndGarde(); //Create form if not created
frm3.FormClosed += frm3_FormClosed; //Add eventhandler to cleanup after
form closes
}
frm3.Show(this); //Show Form assigning this form as the forms owner
Hide();
}
private void label1_Click(object sender, EventArgs e)
121
{
if (frm2 == null)
{
frm2 = new GreatPlayearList(); //Create form if not created
frm2.FormClosed += frm2_FormClosed; //Add eventhandler to cleanup after
form closes
}
frm2.Show(this); //Show Form assigning this form as the forms owner
Hide();
}
void frm2_FormClosed(object sender, FormClosedEventArgs e)
{
frm2 = null; //If form is closed make sure reference is set to null
Show();
}
void frm3_FormClosed(object sender, FormClosedEventArgs e)
{
frm3 = null; //If form is closed make sure reference is set to null
Show();
}
void frm4_FormClosed(object sender, FormClosedEventArgs e)
{
frm4 = null; //If form is closed make sure reference is set to null
Show();
}
void frm5_FormClosed(object sender, FormClosedEventArgs e)
{
frm5 = null; //If form is closed make sure reference is set to null
Show();
}
void frm6_FormClosed(object sender, FormClosedEventArgs e)
{
frm6 = null; //If form is closed make sure reference is set to null
Show();
}
private void label7_Click(object sender, EventArgs e)
{
Application.Exit();
}
private void label3_Click(object sender, EventArgs e)
{
if (frm4 == null)
{
frm4 = new showListPlay(); //Create form if not created
frm4.FormClosed += frm4_FormClosed; //Add eventhandler to cleanup after
form closes
}
frm4.Show(this); //Show Form assigning this form as the forms owner
Hide();
}
private void label4_Click(object sender, EventArgs e)
{
if (frm5 == null)
{
frm5 = new deleteTrackOrPlayList(); //Create form if not created
frm5.FormClosed += frm5_FormClosed; //Add eventhandler to cleanup after
form closes
}