Проектирование и администрирование хранилищ и баз данных для предприятий

В первом случае сначала нужно выбирать данные из таблиц, которые должны располагаться в форме.

Рис.30. Экранная форма
Далее нужно выбрать вид формы.

Рис.31. Создание формы

Модуль AddApplication.cs using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
namespace Информационная_система_транспортной_компании {
public partial class AddApplications : Form {
public AddApplications()
{
InitializeComponent();
this.StartPosition = FormStartPosition.CenterScreen; string Date1 = DateTime.Now.ToLongDateString(); label13.Text = Date1;
}
Calendar a = new Calendar();
private static void DriverInfo(string DriverName)
{
// название процедуры
string sqlExpression = "DriverInfo";
using (SqlConnection connection = new SqlConnection(Connect.ConnectionString))
{
connection.Open();
SqlCommand command = new SqlCommand(sqlExpression,
connection);
command.CommandType = System.Data.CommandType.StoredProcedure;
SqlParameter DriverNameParam = new SqlParameter {
ParameterName = "@Driver_Name",
Value = DriverName
};
command.Parameters.Add(DriverNameParam);
connection.Close();
}
}
private static void DriverAvailableNo_Update(string DriverName)
{
// название процедуры
string sqlExpression = "DriverAvailableNo_Update";using (SqlConnection connection = new SqlConnection(Connect.ConnectionString))
{
connection.Open();
SqlCommand command = new SqlCommand(sqlExpression, connection);
command.CommandType = System.Data.CommandType.StoredProcedure;
SqlParameter DriverNameParam = new
SqlParameter
{
ParameterName = "@DriverName",
Value = DriverName
};
command.Parameters.Add(DriverNameParam); var result = command.ExecuteNonQuery(); connection.Close();
}
}
private static void AddApplication(DateTime Paydate, string DriverName, string NameClient, string Cargo_Name, string AmountSpace, double Cargo_weightInt, double Cargo_volumeInt, int Temperature_regimeInt, string TypePackage, string
ReqTypeRollingStock, int QuantityRollingStockInt, int DueDateInt, int OverPaymentInt, string SpecCond, string Charge_address, DateTime ChargeDate, string Discharge_address, DateTime DischargeDate, long CostInt, DateTime DateApplication, string TimeRemaining)
{
// название процедуры
string sqlExpression = "addApplication";
using (SqlConnection connection = new SqlConnection(Connect.ConnectionString))
{
connection.Open();
try
{
SqlCommand command = new SqlCommand(sqlExpression, connection);
command.CommandType = System.Data.CommandType.StoredProcedure;
SqlParameter DriverNameParam = new
SqlParameter
{
ParameterName = "@DriverName",
Value = DriverName
};
command.Parameters.Add(DriverNameParam);
{
ParameterName = "@PayDate",
Value = Paydate
};
command.Parameters.Add(PayDateParam); SqlParameter NameClientParam = new
SqlParameter
{
ParameterName = "@Client_Name",
Value = NameClient
};
command.Parameters.Add(NameClientParam);
SqlParameter CargoNameParam = new SqlParameter {
ParameterName = "@Cargo_Name",
Value = Cargo_Name
};
command.Parameters.Add(CargoNameParam); SqlParameter AmountSpaceParam = new
SqlParameter
{
ParameterName = "@AmountSpace",
Value = AmountSpace
};
command.Parameters.Add(AmountSpaceParam); SqlParameter CargoWeightParam = new
SqlParameter
{
ParameterName = "@Cargo_weight",
Value = Cargo_weightInt
};
command.Parameters.Add(CargoWeightParam); SqlParameter CargoVolumeParam = new
SqlParameter
{
ParameterName = "@Cargo_volume",
Value = Cargo_volumeInt
};
command.Parameters.Add(CargoVolumeParam);
SqlParameter TempRegParam = new SqlParameter {
ParameterName = "@Temperature_regime", Value = Temperature_regimeInt
};
command.Parameters.Add(TempRegParam);SqlParameter TypePackageParam = new
SqlParameter
{
ParameterName = "@TypePackage",
Value = TypePackage
};
command.Parameters.Add(TypePackageParam); SqlParameter ReqTypeRollingStockParam = new
SqlParameter
{
ParameterName = "@ReqTypeRollingStock", Value = ReqTypeRollingStock
};
command.Parameters.Add(ReqTypeRollingStockParam);
SqlParameter QuantityRollingStockIntParam =
new SqlParameter
{
ParameterName = "@QuantityRollingStock", Value = QuantityRollingStockInt
};
command.Parameters.Add(QuantityRollingStockIntParam);
SqlParameter DueDateIntParam = new
SqlParameter
{
ParameterName = "@DueDate",
Value = DueDateInt
};
command.Parameters.Add(DueDateIntParam); SqlParameter OverPaymentIntParam = new
SqlParameter
{
ParameterName = "@OverPayment",
Value = OverPaymentInt
};
command.Parameters.Add(OverPaymentIntParam);
SqlParameter SpecCondParam = new SqlParameter {
ParameterName = "@SpecCond",
Value = SpecCond
};
command.Parameters.Add(SpecCondParam);
SqlParameter ChargeAddressParam = new {ParameterName = "@Charge_address",
Value = Charge_address
};
command.Parameters.Add(ChargeAddressParam); SqlParameter ChargeDateParam = new
SqlParameter
{
ParameterName = "@Charge_date",
Value = ChargeDate
};
command.Parameters.Add(ChargeDateParam);
SqlParameter DischargeAddressParam = new
SqlParameter
{
ParameterName = "@Discharge_address",
Value = Discharge_address
};
command.Parameters.Add(DischargeAddressParam); SqlParameter DischargeDateParam = new
SqlParameter
{
ParameterName = "@Discharge_date",
Value = DischargeDate
};
command.Parameters.Add(DischargeDateParam);
SqlParameter CostIntParam = new SqlParameter {
ParameterName = "@Cost",
Value = CostInt
};
command.Parameters.Add(CostIntParam); SqlParameter DateApplicationParam = new
SqlParameter
{
ParameterName = "@DateApplication",
Value = DateApplication
};
command.Parameters.Add(DateApplicationParam); SqlParameter TimeRemainingParam = new
SqlParameter
{
ParameterName = "@TimeRemaining",
Value = TimeRemaining
};var result = command.ExecuteNonQuery(); connection.Close();
MessageBox.Show("Загрузка успешно добавлена”);
}
catch (Exception)
{
MessageBox.Show("Ошибка заполнения"); connection.Close();
}
}
}
private void календарьToolStripMenuItem_Click(object sender, EventArgs e)
{
ShowDialog();
}
private void aTIToolStripMenuItem_Click(object sender, EventArgs e)
{
System.Diagnostics.Process.Start("http://ati.su/");
}
private void калькуляторToolStripMenuItem_Click(object sender, EventArgs e)
{
System.Diagnostics.Process.StartCcalc.exe");
}
private void картаToolStripMenuItem_Click(object sender, EventArgs e)
{
System.Diagnostics.Process.Start("https://yandex.ru/maps/");
}
private void Form6_FormClosed(object sender, FormClosedEventArgs e)
{
ApplicationList b = new ApplicationList(); this.Hide();
Show();
}
private void AddApplications_Load(object sender, EventArgs {
this.clientTableAdapter2.Fill(this.tC3DataSet4.Client);
this.driversTableAdapter2.FillBy(this.tC3DataSet3.Drivers);
}private void comboBox1_SelectionChangeCommitted(object sender, EventArgs e)
{
SqlConnection sqlconnection = new SqlConnection(Connect.ConnectionString); sqlconnection.Open(); string DriverName =
Convert.ToString(comboBox1.SelectedValue);
string sqlExpression = "DriverInfo";
SqlCommand command = new SqlCommand(sqlExpression, sqlconnection);
command.CommandType = System.Data.CommandType.StoredProcedure;
SqlParameter DriverNameParam = new SqlParameter {
ParameterName = "@Driver_Name",
Value = DriverName
};
command.Parameters.Add(DriverNameParam);
SqlDataReader dataReader = command.ExecuteReader(); while (dataReader.Read())
{
textBox20.Text = dataReader.GetString(2); textBox21.Text = dataReader.GetString(3); textBox18.Text = dataReader.GetString(4); textBox19.Text = dataReader.GetString(5); long a = dataReader.GetInt64(6); textBox22.Text = Convert.ToString(a);
}
dataReader.Close();
sqlconnection.Close();
}
private void pictureBox3_Click(object sender, EventArgs e) {
SqlConnection sqlconnection = new SqlConnection(Connect.ConnectionString);
ApplicationList b = new ApplicationList(); try {
sqlconnection.Open(); string DriverName =
Convert.ToString(comboBox1.SelectedValue);
string Cargo_Name = textBox1.Text; string AmountSpace = textBox2.Text; string Cargo_weight = textBox10.Text; string Cargo_volume = textBox11.Text; string Temperature_regime = textBox12.Text; string TypePackage = textBox13.Text; string ReqTypeRollingStock = textBox14.Text; string QuantityRollingStock = textBox15.Text; string DueDate = textBox16.Text;
string Overpayment = textBox17.Text; string SpecCond = textBox23.Text; string FIO = textBox20.Text; string NameClient =
Convert.ToString(comboBox2.SelectedValue);
string Charge_address = textBox4.Text; string Charge_date = textBox3.Text; string Discharge_address = textBox5.Text; string Discharge_date = textBox6.Text; string CostStr = textBox8.Text; long CostInt = Convert.ToInt64(CostStr); double Cargo_weightInt = Convert.ToDouble(Cargo_weight);
double Cargo_volumeInt = Convert.ToDouble(Cargo_volume);
int Temperature_regimeInt = Convert.ToInt32(Temperature_regime);
int QuantityRollingStockInt = Convert.ToInt32(QuantityRollingStock);
int DueDateInt = Convert.ToInt32(DueDate); int OverPaymentInt = Convert.ToInt32(OverPayment); DateTime ChargeDate = Convert.ToDateTime(Charge_date);
DateTime DischargeDate = Convert.ToDateTime(Discharge_date);
DateTime DateApplication = DateTime.Now; string TimeRemaining; string q, c, d, f, w; int z, x, v;
DateTime date2, date3;
TimeSpan delta;
q = Convert.ToString(DateApplication);
w = Convert.ToString(DischargeDate);
date2 = DateTime.Parse(q);
date3 = DateTime.Parse(w);
delta = date3 - date2;
c = delta.Days.ToString();
d = delta.Hours.ToString();
f = delta.Minutes.ToString();
z = Convert.ToInt32(c);
x = Convert.ToInt32(d);
v = Convert.ToInt32(f);
if (z <= 0 && x <= 0 && v <= 0)
{
TimeRemaining = "Заказ выполнен”;
}
TimeRemaining = c + " дн. " + d + " ч. " + f + "
мин. ";
DateTime PayDate, date1;
date1 = DischargeDate.AddDays(DueDateInt);
PayDate = date1;
AddApplication(PayDate, DriverName, NameClient, Cargo_Name, AmountSpace, Cargo_weightInt, Cargo_volumeInt,
Temperature_regimeInt, TypePackage, ReqTypeRollingStock, QuantityRollingStockInt, DueDateInt, OverPaymentInt, SpecCond, Charge_address, ChargeDate, Discharge_address, DischargeDate, CostInt, DateApplication, TimeRemaining);
DriverAvailableNo_Update(DriverName);
sqlconnection.Close();
}
catch (Exception)
{
MessageBox.Show("Ошибка ввода"); sqlconnection.Close();
}
this.Hide();
b.Show();
}
private void pictureBox2_Click(object sender, EventArgs e) {
textBox1.Text = ""; textBox2.Text = ""; textBox3.Text = ""; textBox4.Text = ""; textBox5.Text = ""; textBox6.Text = ""; textBox8.Text = ""; textBox10.Text = ""; textBox11.Text = ""; textBox12.Text = ""; textBox13.Text = ""; textBox14.Text = ""; textBox15.Text = ""; textBox16.Text = ""; textBox17.Text = "";
}
private void pictureBox1_Click(object sender, EventArgs e) {
ApplicationList b = new ApplicationList();
this.Hide();
b.Show();
}
}
}


ПРИЛОЖЕНИЕ 2. РУКОВОДСТВО СИСТЕМНОГО ПРОГРАММИСТА

Для эксплуатации программного продукта необходимо наличие следующих компонентов:
1. Операционная система семейства Microsoft®Windows® (не ниже 2000).
2. Установленный и сконфигурированный программный продукт Microsoft Office с MS Access.
Работа выполнена мной ____________, закончена и сдана __________

Ф.И.О., _______________________









3



e

(дата)

(подпись)