132
double[] KKK = new double[14]; double[] EEE = new double[14];
double[] B = new double[14]; double[] BB = 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];
B[j0] = Beta[i];
EE[j0] = E[i];
j0++;
}
chi = 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)
{
KKK[j0] = KK[i];
EEE[j0] = EE[i];
BB[j0] = B[i];
j0++;
}
chi += Math.Pow(KK[i] - EE[i], 2) / EE[i];
133
}
return BB;
}
public static double[] XX(double[] M, int sss, double[] K, double[] E)
//пересчет коэффициентов
{
double[] z = new double[sss];
for (int i=0;i<sss;i++)
{
z[i] = Ch(K, E)[i] / Ch(K, E)[sss-1];
}
return z;
}
public static string scoring(double[] XXX, double[] MMM, int sss)
//принятие решения по модели
{
double ss = 0;
for (int i=0;i<sss;i++)
{
ss += XXX[i] * MMM[i]/100;
}
if (Math.Log(ss,10)>0.7) { return "одобрена"; }
else return "отклонена";
// return Math.Log(ss,10).ToString();
134
}
private void button2_Click(object sender, EventArgs e)
{
string strSQL = "DELETE FROM ZP 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 = "DELETE FROM Tasks WHERE (Id_клиента = " +
Program.f1.analiz + ")";
ds = new DataSet();
using (SqlConnection cn = new SqlConnection(Program.f2.strConn))
{
SqlDataAdapter da = new SqlDataAdapter(strSQL, cn);
da.Fill(ds, "T");
}
strSQL = "DELETE FROM Kredits WHERE (Id_клиента = " +
Program.f1.analiz + ")";
ds = new DataSet();
using (SqlConnection cn = new SqlConnection(Program.f2.strConn))
{
SqlDataAdapter da = new SqlDataAdapter(strSQL, cn);
da.Fill(ds, "T");
}
135
strSQL = "DELETE FROM Jobs WHERE (Id_клиента = " +
Program.f1.analiz + ")";
ds = new DataSet();
using (SqlConnection cn = new SqlConnection(Program.f2.strConn))
{
SqlDataAdapter da = new SqlDataAdapter(strSQL, cn);
da.Fill(ds, "T");
}
strSQL = "DELETE FROM Guarantor WHERE (Id_клиента = " +
Program.f1.analiz + ")";
ds = new DataSet();
using (SqlConnection cn = new SqlConnection(Program.f2.strConn))
{
SqlDataAdapter da = new SqlDataAdapter(strSQL, cn);
da.Fill(ds, "T");
}
strSQL = "DELETE FROM Klients WHERE (Id_клиента = " +
Program.f1.analiz + ")";
ds = new DataSet();
using (SqlConnection cn = new SqlConnection(Program.f2.strConn))
{
SqlDataAdapter da = new SqlDataAdapter(strSQL, cn);
da.Fill(ds, "T");
}
ActiveForm.Text = "Заявка успешно удалена";
strSQL = "SELECT * FROM [Tasks]";
ds = new DataSet();
using (SqlConnection cn = new SqlConnection(Program.f2.strConn))
136
{
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 = "Менеджер";
}
}
}
}
Модуль администратора
Form1.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.IO;
using System.Data.SqlClient;
using System.Collections;
namespace WindowsFormsApp2
137
{
public partial class Form1 : Form
{
public Form1()
{
Program.f1 = this;
InitializeComponent();
}
public string strConn = "";
private void Form1_Load(object sender, EventArgs e)
{
string strSQL;
StreamReader objReader = new StreamReader("string.string");
string sLine = "";
while (sLine != null)
{
sLine = objReader.ReadLine();
if (sLine != null)
strConn = sLine;
}
objReader.Close();
if (strConn == "")
{
Form2 Form02 = new Form2();
Form02.ShowDialog();
}
if (strConn != "")
{
138
strSQL = "SELECT [ФИО], Пароль FROM [Users] WHERE
(Категория LIKE 'администратор')";
DataSet ds = new DataSet();
using (SqlConnection cn = new SqlConnection(strConn))
{
SqlDataAdapter da = new SqlDataAdapter(strSQL, cn);
da.Fill(ds, "Users");
Grid.AutoGenerateColumns = true;
Grid.DataSource = ds;
Grid.DataMember = "Users";
}
if ((Grid.Rows[0].Cells[0].ToString() == "DataGridViewTextBoxCell
{ ColumnIndex=0, RowIndex=0 }") && (Grid.Rows.Count == 1))
{
Form3 Form03 = new Form3();
Form03.Show();
};
if (Grid.Rows.Count > 1)
{
for (int i = 0; i < Grid.Rows.Count - 1; i++)
{
comboBox1.Items.Add(Grid.Rows[i].Cells[0].Value.ToString());
}
139
};
}
}
private void button1_Click(object sender, EventArgs e)
{
string strSQL = "SELECT [ФИО], Пароль FROM [Users] WHERE
(ФИО LIKE N'" + comboBox1.SelectedItem + "') AND (Пароль LIKE '" +
textBox2.Text + "')";
DataSet ds = new DataSet();
using (SqlConnection cn = new SqlConnection(strConn))
{
SqlDataAdapter da = new SqlDataAdapter(strSQL, cn);
da.Fill(ds, "Users");
Grid.AutoGenerateColumns = true;
Grid.DataSource = ds;
Grid.DataMember = "Users";
}
if (Grid.Rows.Count == 2)
{
Form3 Form03 = new Form3();
Form03.Show();
}
}
}
}
Form2.cs
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
140
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using System.IO;
namespace WindowsFormsApp2
{
public partial class Form2 : Form
{
public Form2()
{
InitializeComponent();
}
private void button1_Click(object sender, EventArgs e)
{
StreamWriter writeInfo = new StreamWriter("string.string");
writeInfo.WriteLine(richTextBox1.Text);
writeInfo.Close();
ActiveForm.Close();
Application.Exit();
}
}
}
Form3.cs
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
141
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using System.Data.SqlClient;
namespace WindowsFormsApp2
{
public partial class Form3 : Form
{
public Form3()
{
Program.f3 = this;
InitializeComponent();
}
private void Form3_Load(object sender, EventArgs e)
{
string strSQL = "SELECT [ФИО] FROM [Users]";
DataSet ds = new DataSet();
using (SqlConnection cn = new SqlConnection(Program.f1.strConn))
{
SqlDataAdapter da = new SqlDataAdapter(strSQL, cn);
da.Fill(ds, "Users");
Program.f1.Grid.AutoGenerateColumns = true;
Program.f1.Grid.DataSource = ds;
Program.f1.Grid.DataMember = "Users";
}
if (Program.f1.Grid.Rows.Count > 1)
{