-
Notifications
You must be signed in to change notification settings - Fork 0
/
ReportsList.cs
126 lines (109 loc) · 3.7 KB
/
ReportsList.cs
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
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 Hospital
{
public partial class ReportsList : Form
{
mainClass mainClass = new mainClass();
SqlCommand cmd = new SqlCommand();
SqlConnection conn = new SqlConnection();
SqlDataAdapter da = new SqlDataAdapter();
DataSet ds = new DataSet();
CurrencyManager cr;
public ReportsList()
{
InitializeComponent();
}
private void ReportsList_Load(object sender, EventArgs e)
{
conn.ConnectionString = @"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=D:\C#\Hospital\report.mdf;Integrated Security=True";
conn.Open();
reportShow();
}
public void reportShow(string s = "select * from report")
{
try
{
cmd.CommandText = s;
cmd.Connection = conn;
da.SelectCommand = cmd;
ds.Clear();
da.Fill(ds , "report");
dataGridView1.DataBindings.Clear();
dataGridView1.DataBindings.Add("datasource", ds, "report");
txtreport.DataBindings.Clear();
txtreport.DataBindings.Add("text", ds, "report.reports");
txtposition.DataBindings.Clear();
txtposition.DataBindings.Add("text", ds, "report.position");
txtname.DataBindings.Clear();
txtname.DataBindings.Add("text", ds, "report.name");
txtlastname.DataBindings.Clear();
txtlastname.DataBindings.Add("text", ds, "report.lastname");
txtsubject.DataBindings.Clear();
txtsubject.DataBindings.Add("text", ds, "report.subject");
cr = (CurrencyManager)this.BindingContext[ds, "report"];
}
catch
{
MessageBox.Show("Error");
}
finally { conn.Close(); }
}
//private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
//{
// cr.Position = e.RowIndex;
//}
void search()
{
string command = "select * from report where " + comboBox1.Text + " like '" + txtsearch.Text + "%'";
reportShow(command);
}
public void setCurrentRecord(int curRec)
{
if (curRec < 0 || curRec >= cr.Count)
{
return;
}
else
{
cr.Position = curRec;
dataGridView1.CurrentCell = dataGridView1.Rows[curRec].Cells[0];
}
}
private void dataGridView1_KeyUp(object sender, KeyEventArgs e)
{
setCurrentRecord(dataGridView1.CurrentCell.RowIndex);
}
private void btnclear_Click(object sender, EventArgs e)
{
mainClass.clearReportData();
btnreload_Click(null, null);
}
private void btnreload_Click(object sender, EventArgs e)
{
reportShow();
}
private void btnsearch_Click(object sender, EventArgs e)
{
search();
}
private void txtsearch_TextChanged(object sender, EventArgs e)
{
btnsearch_Click(null, null);
}
private void button2_Click(object sender, EventArgs e)
{
schedulesForm sch = new schedulesForm();
sch.Show();
this.Close();
}
}
}