112
" VALUES(" + Program.f3.idklienta + ", N'" + textBox1.Text + "', " +
textBox2.Text + ", '" + comboBox1.SelectedItem + "', " + r + ", N'" + textBox4.Text +
"', " + textBox5.Text + ", '" + comboBox3.SelectedItem + "')";
}
if (checkBox1.Checked == false)
{
strSQL = "INSERT INTO Kredits " +
"(Id_клиента, цель, сумма, валюта, срок) " +
" VALUES(" + Program.f3.idklienta + ", N'" + textBox1.Text + "', " +
textBox2.Text + ", '" + comboBox1.SelectedItem + "', " + r + ")";
}
DataSet ds = new DataSet();
using (SqlConnection cn = new SqlConnection(Program.f2.strConn))
{
SqlDataAdapter da = new SqlDataAdapter(strSQL, cn);
da.Fill(ds, "Klients");
}
strSQL = "INSERT INTO Tasks " +
"(Id_клиента, Дата, фио_клиента, статус, фио_менеджера) " +
" VALUES(" + Program.f3.idklienta + ",
'"+DateTime.Today.ToString("yyyy.MM.dd") +"', N'"+ Program.f3.klient + "',
'обрабатывается', N'"+Program.f2.Manager+"')";
ds = new DataSet();
using (SqlConnection cn = new SqlConnection(Program.f2.strConn))
{
SqlDataAdapter da = new SqlDataAdapter(strSQL, cn);
da.Fill(ds, "task");
113
}
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 = "Статус";
Program.f1.dataGridView1.Columns[4].HeaderText = "Менеджер";
}
}
private void Form3_Load(object sender, EventArgs e)
{
}
private void timer1_Tick(object sender, EventArgs e)
{
ActiveForm.Text = "Данные сохранены";
timer1.Enabled = false;
timer2.Enabled = true;
114
}
private void timer2_Tick(object sender, EventArgs e)
{
ActiveForm.Text = "Кредитная заявка - Кредитный консультант";
timer2.Enabled = false;
}
private void button4_Click(object sender, EventArgs e)
{
}
}
}
Form4.cs
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;
using System.Data.SqlClient;
namespace WindowsFormsApp1
{
public partial class Form4 : Form
{
115
public Form4()
{
InitializeComponent();
}
private void Form4_Load(object sender, EventArgs e)
{
string strSQL = "SELECT * FROM Klients";
DataSet ds = new DataSet();
using (SqlConnection cn = new SqlConnection(Program.f2.strConn))
{
SqlDataAdapter da = new SqlDataAdapter(strSQL, cn);
da.Fill(ds, "Users");
dataGridView1.AutoGenerateColumns = true;
dataGridView1.DataSource = ds;
dataGridView1.DataMember = "Users";
}
}
private void button2_Click(object sender, EventArgs e)
{
int k;
if (checkBox1.Checked == true) { k = 1; } else k = 0;
string strSQL = "INSERT INTO Klients (Id_клиента, ФИО_клиента,
[Дата рождения], [Домашний адрес], Съемное,"
+" Телефоны, Образование, [Семейное положение], Дети, [Номер
паспорта], [Дата выдачи], [Кем выдан])"+
" VALUES("+dataGridView1.RowCount+", N'" + textBox1.Text+"',
'"+dateTimePicker2.Value.ToString("yyyy.MM.dd") + "', N'" + textBox2.Text + "',
"+k+", N'" + textBox3.Text + "', '"+comboBox1.SelectedItem+ "', '" +
comboBox2.SelectedItem + "', " +
116
"'" + comboBox3.SelectedItem + "','" + textBox4.Text + "', '" +
dateTimePicker1.Value.ToString("yyyy.MM.dd") + "', N'" + textBox5.Text + "')";
DataSet ds = new DataSet();
using (SqlConnection cn = new SqlConnection(Program.f2.strConn))
{
SqlDataAdapter da = new SqlDataAdapter(strSQL, cn);
da.Fill(ds, "Klients");
Program.f3.klient = textBox1.Text;
Program.f3.idklienta = dataGridView1.RowCount;
}
Program.f3.button2.Enabled = true;
Program.f3.timer1.Enabled = true;
ActiveForm.Close();
}
}
}
Form5.cs
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;
117
using System.Data.SqlClient;
namespace WindowsFormsApp1
{
public partial class Form5 : Form
{
public Form5()
{
InitializeComponent();
}
private void button1_Click(object sender, EventArgs e)
{
string strSQL = "INSERT INTO Jobs " +
"(Id_клиента, категория, организация, улица, пункт, район,
область, " +
"трудоустройство, стаж, должность) " +
"VALUES(" + Program.f3.idklienta + ", '" + checkedListBox1.SelectedItem + "',
N'" + textBox1.Text + "', N'" + textBox2.Text + "', " +
"N'" + textBox3.Text + "', N'" + textBox4.Text + "', N'" + textBox5.Text + "', N'"
+ comboBox1.SelectedItem + "', " + textBox6.Text + ", N'" + textBox7.Text + "')";
DataSet ds = new DataSet();
using (SqlConnection cn = new SqlConnection(Program.f2.strConn))
{
SqlDataAdapter da = new SqlDataAdapter(strSQL, cn);
da.Fill(ds, "Klients");
}
for (int m=0;m<dataGridView1.RowCount-1;m++) {
strSQL = "INSERT INTO ZP " +
118
"(Id_клиента, [месяц и год], начислено) " +
"VALUES(" + Program.f3.idklienta + ",
'"+dataGridView1.Rows[m].Cells[0].Value.ToString()+ "', " +
dataGridView1.Rows[m].Cells[1].Value.ToString() + ")";
ds = new DataSet();
using (SqlConnection cn = new SqlConnection(Program.f2.strConn))
{
SqlDataAdapter da = new SqlDataAdapter(strSQL, cn);
da.Fill(ds, "Klients2");
}
}
Program.f3.button3.Enabled = true;
Program.f3.timer1.Enabled = true;
ActiveForm.Close();
}
private void Form5_Load(object sender, EventArgs e)
{
}
private void button2_Click(object sender, EventArgs e)
{
}
}
}
Form6.cs
using System;
using System.Collections.Generic;
119
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using System.Data.SqlClient;
namespace WindowsFormsApp1
{
public partial class Form6 : Form
{
public Form6()
{
InitializeComponent();
}
private void button1_Click(object sender, EventArgs e)
{
for (int m = 0; m < dataGridView1.RowCount - 1; m++)
{
string strSQL = "INSERT INTO Guarantor " +
"(Id_клиента, поручитель, телефон, работа, отношение)" +
"VALUES(" + Program.f3.idklienta + ", N'" +
dataGridView1.Rows[m].Cells[1].Value.ToString() + "', N'" +
dataGridView1.Rows[m].Cells[1].Value.ToString() + "', N'" +
dataGridView1.Rows[m].Cells[2].Value.ToString() + "', N'" +
dataGridView1.Rows[m].Cells[3].Value.ToString() + "')";
DataSet ds = new DataSet();
using (SqlConnection cn = new SqlConnection(Program.f2.strConn))
{
120
SqlDataAdapter da = new SqlDataAdapter(strSQL, cn);
da.Fill(ds, "Klients");
}
}
Program.f3.button5.Enabled = true;
Program.f3.timer1.Enabled = true;
ActiveForm.Close();
}
private void dataGridView1_CellContentClick(object sender,
DataGridViewCellEventArgs e)
{
}
private void Form6_Load(object sender, EventArgs e)
{
}
}
}
Form8.cs
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
121
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using System.Data.SqlClient;
using System.Drawing.Printing;
namespace WindowsFormsApp1
{
public partial class Form8 : Form
{
public Form8()
{
InitializeComponent();
}
double[] K = new double[14]; // матрица переменных скоринга
double[] E = new double[14];
double[] Beta = new double[14];
double[] M = new double[14];
int sss;
int kk = 0;
private void Form8_Load(object sender, EventArgs e)
{
ActiveForm.Text = "Заявка на кредит - "+ Program.f1.fio_analiz;
string strSQL = "SELECT top 1 Klients.ФИО_клиента,
Klients.[Дата рождения], Klients.Съемное, "+
"Klients.Образование, Klients.[Семейное положение], Klients.Дети,
Kredits.сумма, "+