102
string strSQL;
strSQL = "SELECT * FROM [Tasks]";
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";
dataGridView1.Columns[0].HeaderText = "Номер";
dataGridView1.Columns[1].HeaderText = "Дата";
dataGridView1.Columns[2].HeaderText = "Клиент";
dataGridView1.Columns[3].HeaderText = "Статус";
dataGridView1.Columns[4].HeaderText = "Менеджер";
}
}
private void Form1_FormClosed(object sender, FormClosedEventArgs e)
{
Application.Exit();
}
private void button3_Click(object sender, EventArgs e)
{
Form3 Form03 = new Form3();
Form03.ShowDialog();
}
103
private void button4_Click(object sender, EventArgs e)
{
}
private void dataGridView1_CellClick(object sender,
DataGridViewCellEventArgs e)
{
analiz = dataGridView1.Rows[e.RowIndex].Cells[0].Value.ToString();
fio_analiz =
dataGridView1.Rows[e.RowIndex].Cells[2].Value.ToString();
Form8 Form08 = new Form8();
Form08.ShowDialog();
}
private void button2_Click(object sender, EventArgs e)
{
string strSQL;
if ((textBox1.Text!="") && (comboBox2.SelectedIndex==-1)) {
strSQL = "SELECT * FROM [Tasks] WHERE (фио_клиента LIKE
N'%"+ textBox1.Text + "%')";
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";
104
dataGridView1.Columns[0].HeaderText = "Номер";
dataGridView1.Columns[1].HeaderText = "Дата";
dataGridView1.Columns[2].HeaderText = "Клиент";
dataGridView1.Columns[3].HeaderText = "Статус";
dataGridView1.Columns[4].HeaderText = "Менеджер";
}
}
if ((textBox1.Text == "") && (comboBox2.SelectedIndex != -1))
{
strSQL = "SELECT * FROM [Tasks] WHERE (статус LIKE '"+
comboBox2.SelectedItem + "')";
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";
dataGridView1.Columns[0].HeaderText = "Номер";
dataGridView1.Columns[1].HeaderText = "Дата";
dataGridView1.Columns[2].HeaderText = "Клиент";
dataGridView1.Columns[3].HeaderText = "Статус";
dataGridView1.Columns[4].HeaderText = "Менеджер";
}
}
if ((textBox1.Text != "") && (comboBox2.SelectedIndex != -1))
105
{
strSQL = "SELECT * FROM [Tasks] WHERE (фио_клиента LIKE
N'%"+ textBox1.Text + "%') AND (статус LIKE '" + comboBox2.SelectedItem + "')";
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";
dataGridView1.Columns[0].HeaderText = "Номер";
dataGridView1.Columns[1].HeaderText = "Дата";
dataGridView1.Columns[2].HeaderText = "Клиент";
dataGridView1.Columns[3].HeaderText = "Статус";
dataGridView1.Columns[4].HeaderText = "Менеджер";
}
}
}
private void button1_Click(object sender, EventArgs e)
{
string strSQL = "SELECT * FROM [Tasks]";
DataSet ds = new DataSet();
using (SqlConnection cn = new SqlConnection(Program.f2.strConn))
{
SqlDataAdapter da = new SqlDataAdapter(strSQL, cn);
da.Fill(ds, "Tasks");
106
dataGridView1.DataSource = ds;
dataGridView1.DataMember = "Tasks";
dataGridView1.Columns[0].HeaderText = "Номер";
dataGridView1.Columns[1].HeaderText = "Дата";
dataGridView1.Columns[2].HeaderText = "Клиент";
dataGridView1.Columns[3].HeaderText = "Статус";
dataGridView1.Columns[4].HeaderText = "Менеджер";
}
}
private void groupBox1_Enter(object sender, EventArgs e)
{
}
}
}
Form2.cs
using System;
using System.IO;
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.Threading.Tasks;
using System.Windows.Forms;
namespace WindowsFormsApp1
{
107
public partial class Form2 : Form
{
public Form2()
{
Program.f2 = this;
InitializeComponent();
}
public string strConn = "";
public string Manager = "";
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");
dataGridView1.AutoGenerateColumns = true;
dataGridView1.DataSource = ds;
dataGridView1.DataMember = "Users";
}
if (dataGridView1.Rows.Count == 2)
{
Manager = comboBox1.SelectedItem.ToString();
Form1 Form02 = new Form1();
ActiveForm.Hide();
Form02.Show();
108
}
else timer1.Enabled = true;
}
private void Form2_Load(object sender, EventArgs e)
{
StreamReader objReader = new StreamReader("string.string");
string sLine = "";
while (sLine != null)
{
sLine = objReader.ReadLine();
if (sLine != null)
strConn = sLine;
}
objReader.Close();
string 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");
dataGridView1.AutoGenerateColumns = true;
dataGridView1.DataSource = ds;
dataGridView1.DataMember = "Users";
}
for (int i = 0; i < dataGridView1.Rows.Count - 1; i++)
109
{
comboBox1.Items.Add(dataGridView1.Rows[i].Cells[0].Value.ToString());
}
}
private void timer1_Tick(object sender, EventArgs e)
{
ActiveForm.Text = "Неверный пароль";
timer1.Enabled = false;
timer2.Enabled = true;
}
private void timer2_Tick(object sender, EventArgs e)
{
ActiveForm.Text = "Авторизация";
timer2.Enabled = false;
}
}
}
Form3.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;
110
namespace WindowsFormsApp1
{
public partial class Form3 : Form
{
public Form3()
{
Program.f3 = this;
InitializeComponent();
}
public int idklienta;
public string klient = "";
private void label3_Click(object sender, EventArgs e)
{
}
private void checkBox1_CheckedChanged(object sender, EventArgs e)
{
if (checkBox1.Checked == true) { panel4.Visible = true; }
else { panel4.Visible = false; };
}
private void button1_Click(object sender, EventArgs e)
{
Form4 Form04 = new Form4();
Form04.ShowDialog();
}
private void button2_Click(object sender, EventArgs e)
{
111
Form5 Form05 = new Form5();
Form05.ShowDialog();
}
private void button3_Click(object sender, EventArgs e)
{
Form6 Form06 = new Form6();
Form06.ShowDialog();
}
private void panel3_Paint(object sender, PaintEventArgs e)
{
}
private void button5_Click(object sender, EventArgs e)
{
int r=0;
if (comboBox2.SelectedIndex==0) { r =
Convert.ToInt32(textBox3.Text); }
if (comboBox2.SelectedIndex == 1) { r =
Convert.ToInt32(textBox3.Text)*12; }
string strSQL="";
if (checkBox1.Checked == true)
{
strSQL = "INSERT INTO Kredits " +
"(Id_клиента, цель, сумма, валюта, срок, недвижимость,
стоимость, валюта2) " +