122
"Kredits.валюта, Kredits.срок, Kredits.стоимость, Jobs.категория,
Jobs.трудоустройство, Jobs.стаж, Tasks.фио_менеджера, "+
"Tasks.Дата, Klients.[Номер паспорта] FROM Klients INNER JOIN "+
"Tasks ON Klients.Id_клиента = Tasks.Id_клиента INNER JOIN Guarantor ON
Klients.Id_клиента = Guarantor.Id_клиента INNER JOIN "+
"Kredits ON Klients.Id_клиента = Kredits.Id_клиента INNER JOIN ZP ON
Klients.Id_клиента = ZP.Id_клиента INNER JOIN "+
"Jobs ON Klients.Id_клиента = Jobs.Id_клиента WHERE
Klients.Id_клиента="+ Program.f1.analiz;
DataSet ds = new DataSet();
using (SqlConnection cn = new SqlConnection(Program.f2.strConn))
{
SqlDataAdapter da = new SqlDataAdapter(strSQL, cn);
da.Fill(ds, "Tasks");
dataGridView1.DataSource = ds;
dataGridView1.DataMember = "Tasks";
}
strSQL = "SELECT Klients.Id_клиента, Guarantor.поручитель " +
"FROM Guarantor INNER JOIN " +
"Klients ON Guarantor.Id_клиента = Klients.Id_клиента WHERE
Klients.Id_клиента=" + Program.f1.analiz;
ds = new DataSet();
using (SqlConnection cn = new SqlConnection(Program.f2.strConn))
{
SqlDataAdapter da = new SqlDataAdapter(strSQL, cn);
da.Fill(ds, "Tasks");
dataGridView2.DataSource = ds;
dataGridView2.DataMember = "Tasks";
123
}
label28.Text = (dataGridView2.RowCount - 1).ToString();
strSQL = "SELECT Klients.Id_клиента, ZP.начислено " +
"FROM Klients INNER JOIN " +
"ZP ON Klients.Id_клиента = ZP.Id_клиента WHERE
Klients.Id_клиента=" + Program.f1.analiz;
ds = new DataSet();
using (SqlConnection cn = new SqlConnection(Program.f2.strConn))
{
SqlDataAdapter da = new SqlDataAdapter(strSQL, cn);
da.Fill(ds, "Tasks");
dataGridView2.DataSource = ds;
dataGridView2.DataMember = "Tasks";
}
for (int i = 0; i < dataGridView2.RowCount; i++) { kk +=
Convert.ToInt32(dataGridView2.Rows[i].Cells[1].Value); }
label27.Text = kk.ToString()+" руб.";
label16.Text = dataGridView1.Rows[0].Cells[0].Value.ToString();
label17.Text =
dataGridView1.Rows[0].Cells[1].Value.ToString().Substring(0,10);
label6.Text = dataGridView1.Rows[0].Cells[2].Value.ToString();
label19.Text = dataGridView1.Rows[0].Cells[3].Value.ToString();
label20.Text = dataGridView1.Rows[0].Cells[4].Value.ToString();
label21.Text = dataGridView1.Rows[0].Cells[5].Value.ToString();
label22.Text = dataGridView1.Rows[0].Cells[6].Value.ToString() + " " +
dataGridView1.Rows[0].Cells[7].Value.ToString();
124
label23.Text = dataGridView1.Rows[0].Cells[8].Value.ToString() + "
мес.";
label24.Text = dataGridView1.Rows[0].Cells[9].Value.ToString();
label25.Text = dataGridView1.Rows[0].Cells[10].Value.ToString() + "
("+ dataGridView1.Rows[0].Cells[11].Value.ToString()+")";
label26.Text = dataGridView1.Rows[0].Cells[12].Value.ToString() + "
лет";
label29.Text = dataGridView1.Rows[0].Cells[13].Value.ToString();
label31.Text =
dataGridView1.Rows[0].Cells[14].Value.ToString().Substring(0, 10);
label18.Text = dataGridView1.Rows[0].Cells[15].Value.ToString();
if (label24.Text == "") { label24.Text = "----"; }
}
private void button1_Click(object sender, EventArgs e)
{
}
private System.Drawing.Printing.PrintDocument docToPrint = new
System.Drawing.Printing.PrintDocument();
private PrintDocument printDocument1 = new PrintDocument();
private void button1_Click_1(object sender, EventArgs e)
{
printDocument1.PrintPage += new
PrintPageEventHandler(printDocument1_PrintPage);
CaptureScreen();
125
printDialog1.ShowHelp = true;
printDialog1.Document = printDocument1;
DialogResult result = printDialog1.ShowDialog();
if (result == DialogResult.OK)
{
printDocument1.Print();
}
}
Bitmap memoryImage;
//Методы для распечатки.
private void CaptureScreen()
{
Graphics myGraphics = this.CreateGraphics();
Size s = this.Size;
memoryImage = new Bitmap(s.Width, s.Height, myGraphics);
Graphics memoryGraphics = Graphics.FromImage(memoryImage);
memoryGraphics.CopyFromScreen(this.Location.X, this.Location.Y, 0,
0, s);
}
private void printDocument1_PrintPage(System.Object sender,
System.Drawing.Printing.PrintPageEventArgs e)
{
e.Graphics.DrawImage(memoryImage, 0, 0);
}
private void button4_Click(object sender, EventArgs e)
{
//занесение переменных в скоринговую модель
int temp = 0;
126
K[0] = Convert.ToInt32(dataGridView1.Rows[0].Cells[8].Value);
if (label19.Text == "среднее общее") { temp = 1; }
if (label19.Text == "среднее профессиональное") { temp = 2; }
if (label19.Text == "высшее") { temp = 3; }
if (label19.Text == "послевузовское") { temp = 4; }
K[1] = temp;
if (label20.Text == "холост/незамужем") { temp = 0; } else temp = 1;
K[2] = temp;
if (label21.Text == "да") { temp = 0; } else temp = 1;
K[3] = temp;
K[4] = Convert.ToInt32(label28.Text);
K[5] = Convert.ToInt32(dataGridView1.Rows[0].Cells[6].Value);
if (dataGridView1.Rows[0].Cells[7].Value.ToString() == "EUR") { temp
= 1; }
if (dataGridView1.Rows[0].Cells[7].Value.ToString() == "USD") { temp
= 2; }
if (dataGridView1.Rows[0].Cells[7].Value.ToString() == "RUB") { temp
= 3; }
K[6] = temp;
K[7] = 40 - (DateTime.Today.Year -
Convert.ToInt32(label17.Text.Substring(6,4)));
127
if (dataGridView1.Rows[0].Cells[9].Value.ToString() == "") { temp = 0;
} else temp = Convert.ToInt32(dataGridView1.Rows[0].Cells[9].Value);
K[8] = temp;
if (dataGridView1.Rows[0].Cells[10].Value.ToString() == "собственное
дело") { temp = 1; }
if (dataGridView1.Rows[0].Cells[10].Value.ToString() ==
"индивидуальный предприниматель") { temp = 2; }
if (dataGridView1.Rows[0].Cells[10].Value.ToString() == "по найму") {
temp = 3; }
K[9] = temp;
if (dataGridView1.Rows[0].Cells[11].Value.ToString() == "договор
ГПХ") { temp = 1; }
if (dataGridView1.Rows[0].Cells[11].Value.ToString() == "трудовой
договор") { temp = 2; }
K[10] = temp;
K[11] = Convert.ToInt32(dataGridView1.Rows[0].Cells[12].Value);
K[12] = kk;
if (label6.Text == "true") { temp = 0; } else temp = 1;
K[13] = temp;
//занесение желаемых значений модели
E[0] = 6; E[1] = 4; E[2] = 1; E[3] = 1; E[4] = 2; E[5] = 1000000; E[6] =
3; E[7] = 40; E[8] = 1000000; E[9] = 3; E[10] = 2; E[11] = 3;
E[12] = 200000; E[13] = 1;
//занесение весов модели
Beta[0] = 80; Beta[1] = 20; Beta[2] = 50; Beta[3] = 60; Beta[4] = 60;
Beta[5] = 100; Beta[6] = 100; Beta[7] = 80; Beta[8] = 100;
128
Beta[9] = 50; Beta[10] = 10; Beta[11] = 50; Beta[12] = 70; Beta[13] =
100;
//расчет модели
M = Ch(K, E);
sss = j0;
//запись значения в базу данных
ActiveForm.Text += " - "+scoring(XX(M, sss, K, E), B(K, E, Beta), sss);
string strSQL = "UPDATE Tasks SET статус = '"+ scoring(XX(M, sss,
K, E), B(K, E, Beta), sss) + "' WHERE (Id_клиента = " + Program.f1.analiz + ")";
DataSet ds = new DataSet();
using (SqlConnection cn = new SqlConnection(Program.f2.strConn))
{
SqlDataAdapter da = new SqlDataAdapter(strSQL, cn);
da.Fill(ds, "T");
}
strSQL = "SELECT * FROM [Tasks]";
ds = new DataSet();
using (SqlConnection cn = new SqlConnection(Program.f2.strConn))
{
SqlDataAdapter da = new SqlDataAdapter(strSQL, cn);
da.Fill(ds, "Tasks");
Program.f1.dataGridView1.DataSource = ds;
Program.f1.dataGridView1.DataMember = "Tasks";
Program.f1.dataGridView1.Columns[0].HeaderText = "Номер";
Program.f1.dataGridView1.Columns[1].HeaderText = "Дата";
Program.f1.dataGridView1.Columns[2].HeaderText = "Клиент";
Program.f1.dataGridView1.Columns[3].HeaderText = "Статус";
129
Program.f1.dataGridView1.Columns[4].HeaderText = "Менеджер";
}
}
static int j0;
public static double[] perem(double[] K, double[] E) // проверка
переменных по хи-квадрат
{
double chi = 0;
j0 = 0;
double[] KK = new double[14]; double[] EE = new double[14];
double[] KKK = new double[14]; double[] EEE = new double[14];
for (int i=0;i<14;i++) {
if (chi+Math.Pow(K[i]-E[i],2)/E[i]>0.5) {
KK[j0] = K[i];
EE[j0] = E[i];
j0++;
}
chi += Math.Pow(K[i] - E[i], 2) / E[i];
}
int k = j0 - 1;
j0 = 0;
chi = 0;
for (int i = 0; i <= k; i++)
{
if (Math.Sqrt((chi + Math.Pow(KK[i] - EE[i], 2) / EE[i])/((k+1)*k)) >
0.2)
{
130
KKK[j0] = KK[i];
EEE[j0] = EE[i];
j0++;
}
chi += Math.Pow(KK[i] - EE[i], 2) / EE[i];
}
return KKK;
}
public static double[] Ch(double[] K, double[] E) // вывод значений хи-
квадрат
{
double chi = 0;
j0 = 0;
double[] KK = new double[14]; double[] EE = new double[14];
double[] KKK = new double[14]; double[] EEE = new double[14];
double[] chh = new double[14];
for (int i = 0; i < 14; i++)
{
if (chi + Math.Pow(K[i] - E[i], 2) / E[i] > 0.5)
{
KK[j0] = K[i];
EE[j0] = E[i];
j0++;
}
chi = chi+ Math.Pow(K[i] - E[i], 2) / E[i];
131
}
int k = j0 - 1;
j0 = 0;
chi = 0;
for (int i = 0; i <= k; i++)
{
if (Math.Sqrt((chi + Math.Pow(KK[i] - EE[i], 2) / EE[i]) / ((k + 1) * k))
> 0.2)
{
KKK[j0] = KK[i];
EEE[j0] = EE[i];
chh[j0] = chi+ Math.Pow(KK[i] - EE[i], 2) / EE[i];
j0++;
}
chi += Math.Pow(KK[i] - EE[i], 2) / EE[i];
}
return chh;
}
public static double[] B(double[] K, double[] E, double[] Beta) // вывод
значений весов
{
double chi = 0;
j0 = 0;
double[] KK = new double[14]; double[] EE = new double[14];