ПРИЛОЖЕНИЕ Г
(рекомендуемое)
SQL-скрипт создания базы данных
CREATE DATABASE [financy] ON PRIMARY
( NAME = N'financy', FILENAME = N'D:\БГУИР\9-ый семестр\Курсовой\financy.mdf' , SIZE = 3072KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )
LOG ON
( NAME = N'financy_log', FILENAME = N'D:\ БГУИР\9-ый семестр\Курсовой\financy_log.ldf' , SIZE = 1024KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)
GO
CREATE TABLE [dbo].[FinansovayaSituaciya](
[IdFinansovayaSituaciya] [int] NOT NULL,
[TypeFinansovoySituacii] [varchar](50) NULL,
CONSTRAINT [PK_ FinansovayaSituaciya] PRIMARY KEY CLUSTERED
(
[IdFinansovayaSituaciya] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[Activi](
[IdActivi] [int] NOT NULL,
[Class1] [varchar](50) NULL,
[Class2] [varchar](50) NULL,
CONSTRAINT [PK_Activi] PRIMARY KEY CLUSTERED
(
[IdActivi] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
CREATE TABLE [dbo].[Oborachivaemost](
[IdOborachivaemost] [int] NOT NULL,
[Zapasov] [int] NULL,
[SobstvennihSredstv] [int] NULL,
CONSTRAINT [PK_Oborachivaemost] PRIMARY KEY CLUSTERED
(
[IdOborachivaemost] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
CREATE TABLE [dbo].[Zadoljennost](
[IdZadoljennost] [int] NOT NULL,
[Kreditorskaya] [int] NULL,
ПРИЛОЖЕНИЕ Г (продолжение)
[Debitorskaya] [int] NULL,
CONSTRAINT [PK_Zadoljennost] PRIMARY KEY CLUSTERED
(
[IdZadoljennost] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
CREATE TABLE [dbo].[Date](
[IdDate] [int] NOT NULL,
[Number] [int] NULL,
[Month] [varchar](50) NULL,
[Year] [int] NULL,
CONSTRAINT [PK_Date] PRIMARY KEY CLUSTERED
(
[IdDate] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
CREATE TABLE [dbo].[Koefficienty](
[IdKoefficienty] [int] NOT NULL,
[AbsolutnoyLikvidnosti] [int] NULL,
[PokritiyaObshiy] [int] NULL,
[PokritiyaPromejutochniy] [int] NULL,
[Oborachivaemosty] [int] NULL,
[RentabelnostiKapitala] [int] NULL,
[RentabelnostiSobstvennihSredstv] [int] NULL,
CONSTRAINT [PK_Koefficienty] PRIMARY KEY CLUSTERED
(
[IdKoefficienty] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
CREATE TABLE [dbo].[Sredstva](
[IdSredstva] [int] NOT NULL,
[Sobstvennie] [int] NULL,
[Osnovnie] [int] NULL,
[Zaemnie] [int] NULL,
[Oborotnie] [int] NULL,
[Materialnie] [int] NULL,
[Denejnie] [int] NULL,
[Kredity] [int] NULL,
CONSTRAINT [PK_Sredstva] PRIMARY KEY CLUSTERED
(
ПРИЛОЖЕНИЕ Г (продолжение)
[IdSredstva] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
CREATE TABLE [dbo].[Imushestvo](
[IdImushestvo] [int] NOT NULL,
[Stoimost] [int] NULL,
[Vsego] [int] NULL,
CONSTRAINT [PK_Imushestvo] PRIMARY KEY CLUSTERED
(
[IdImushestvo] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
CREATE TABLE [dbo].[Istochniki](
[IdIstochniki] [int] NOT NULL,
[SobstvennihSredstv] [int] NULL,
[ZapasyZatraty] [int] NULL,
[ObshayaVelichina] [int] NULL,
[IzlishekNedostatok] [int] NULL,
CONSTRAINT [PK_Istochniki] PRIMARY KEY CLUSTERED
(
[IdIstochniki] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
CREATE TABLE [dbo].[Realizaciya](
[IdRealizaciya] [int] NOT NULL,
[Viruchka] [int] NULL,
[Sebestoimost] [int] NULL,
CONSTRAINT [PK_Realizaciya] PRIMARY KEY CLUSTERED
(
[IdRealizaciya] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ПРИЛОЖЕНИЕ Д
(рекомендуемое)
Листинг программы
namespace ClientRyzhakovaAA
{
public partial class Form1 : Form
{
Boolean flagConnect;
Boolean flag;
String message = "";
Boolean connector = false;
string str2 = "";
Socket send = new Socket(AddressFamily.InterNetwork, SocketType.Stream,
ProtocolType.Tcp);
private System.Drawing.Printing.PrintDocument docToPrint =
new System.Drawing.Printing.PrintDocument();
public Form1()
{
InitializeComponent();
flagConnect = false;
flag = false;
}
public void Sender(String str)
{
if (flag)
{
byte[] msg = Encoding.UTF8.GetBytes(str);
int bytesSent = send.Send(msg);
}
}
public String Reciver()
{
byte[] bytes = new byte[1024];
String answer = null;
if (flag)
{
int bytesRecive = send.Receive(bytes);
answer = Encoding.UTF8.GetString(bytes, 0, bytesRecive);
}
return answer;
}
private void подкдючитьсяToolStripMenuItem_Click(object sender, EventArgs e)
{
if (!flagConnect)
{
byte[] bytes = new byte[1024];
try
{
IPHostEntry ipHost = Dns.Resolve("127.0.0.1");
IPAddress ipAdd = ipHost.AddressList[0];
IPEndPoint ipEndPoint = new IPEndPoint(ipAdd, 11000);
ПРИЛОЖЕНИЕ Д (продолжение)
send.Connect(ipEndPoint);
connector = true;
MessageBox.Show("Подключение успешно выполнено.", "Подключение", MessageBoxButtons.OK,
MessageBoxIcon.Information);
label1.Visible = false;
label2.Visible = false;
открытьToolStripMenuItem.Visible = true;
сохранитьToolStripMenuItem1.Visible = true;
}
catch (Exception ee)
{
Console.WriteLine(ee.ToString());
}
flagConnect = true;
}
flag = true;
}
// …
}
}
namespace ClientRyzhakovaAA
{
public partial class Graphic : Form
{
public Graphic()
{
InitializeComponent();
}
private void Graphic_Load(object sender, EventArgs e)
{
Form1 frm = new Form1();
frm = (Form1)this.Owner;
GraphPane myPane = zedGraphControl1.GraphPane;
myPane.CurveList.Clear();
PointPairList list = new PointPairList();
myPane.Title.Text = "График имущества";
myPane.XAxis.Title.Text = "год";
myPane.YAxis.Title.Text = "сумма, тыс.бел.руб";
for (int i = 0; i < frm.countStructImush(); i++)
list.Add(frm.year(i), frm.imushestvo(i));
LineItem myCurve = myPane.AddCurve("график", list, Color.Blue, SymbolType.None);
zedGraphControl1.AxisChange();
zedGraphControl1.Invalidate();
myPane.Fill = new Fill(Color.White, Color.FromArgb(220, 220, 255), 45F);
myPane.Chart.Fill = new Fill(Color.White, Color.LightGoldenrodYellow, 45F);
}
ПРИЛОЖЕНИЕ Д (продолжение)
private void button1_Click(object sender, EventArgs e)
{
SaveFileDialog dlg = new SaveFileDialog();
dlg.Filter = "*.png|*.png|*.jpg; *.jpeg|*.jpg;*.jpeg|*.bmp|*.bmp|Все файлы|*.*";
if (dlg.ShowDialog() == DialogResult.OK)
{
GraphPane pane = zedGraphControl1.GraphPane;
Bitmap bmp = pane.GetImage();
if (dlg.FileName.EndsWith(".png"))
{
bmp.Save(dlg.FileName, ImageFormat.Png);
}
else if (dlg.FileName.EndsWith(".jpg") || dlg.FileName.EndsWith(".jpeg"))
{
bmp.Save(dlg.FileName, ImageFormat.Jpeg);
}
else if (dlg.FileName.EndsWith(".bmp"))
{
bmp.Save(dlg.FileName, ImageFormat.Bmp);
}
else
{
bmp.Save(dlg.FileName);
}
}
}
}
}
namespace ServerRyzhakovaAA
{
class Program
{
static void Main(string[] args)
{
IPHostEntry ipHost = Dns.Resolve("localhost");
IPAddress ipAdd = ipHost.AddressList[0];
IPEndPoint ipEndPoint = new IPEndPoint(ipAdd, 11000);
Socket sListener = new Socket(AddressFamily.InterNetwork, SocketType.Stream,
ProtocolType.Tcp);
try
{
sListener.Bind(ipEndPoint);
sListener.Listen(10);
while (true)
{
Console.WriteLine("Ожидание соединения с портом " + ipEndPoint);
Socket handler = sListener.Accept();
ПРИЛОЖЕНИЕ Д (продолжение)
string data = null;
while (true)
{
Console.WriteLine("Клиент подключён.");
byte[] bytes = new byte[1024];
int bytesRec = handler.Receive(bytes);
data += Encoding.ASCII.GetString(bytes, 0, bytesRec);
// …
if (data.IndexOf("7") > -1)
{
string theReplyMessage = "Конец работы.";
byte[] message = Encoding.UTF8.GetBytes(theReplyMessage);
handler.Send(message);
break;
}
}
Console.WriteLine("Клиент окончил сессию.");
handler.Shutdown(SocketShutdown.Both);
handler.Close();
}
}
catch (Exception e)
{
Console.WriteLine(e.ToString()); Console.ReadKey(false);
}
}
}
}
Ведомость курсового проекта
|