private void btnlogin_Click(object sender, EventArgs e)
{
#region Nhan bien nguoi dung nhap
txtusername.Focus();
string username = txtusername.Text;
string password = txtpassword.Text;
#endregion
#region Kiem tra gia tri nhap vao
if (string.IsNullOrEmpty(username))
{
MessageBox.Show("Nhập tên đăng nhập!", "Cảnh báo", MessageBoxButtons.OKCancel, MessageBoxIcon.Warning);
txtusername.Focus();
return;
}
if (string.IsNullOrEmpty(password))
{
MessageBox.Show("Nhập mật khẩu!", "Cảnh báo", MessageBoxButtons.OKCancel, MessageBoxIcon.Warning);
txtpassword.Focus();
return;
}
#endregion
#region Ket noi CSDL va truy van
String sql = "select * from nhanvien a, quyennhanvien b where a.nv_id = b.nv_id and nv_tentaikhoan ='" + username + "' and nv_matkhau ='" + mahoa(password) + "'";
String sql2 = "select * from nhanvien where nv_tentaikhoan ='" + username + "' and nv_matkhau ='" + mahoa(password) + "'";
DataTable data = func.getdata(sql);
DataTable data2 = func.getdata(sql2);
if (data.Rows.Count > 0)
{
int tongquyen = data.Rows.Count;
int[] quyen = new int[tongquyen];
int i = 0;
foreach (DataRow row in data.Rows)
{
quyen[i] = Convert.ToInt32(row["q_id"]);
i++;
}
foreach (DataRow row2 in data2.Rows)
{
index index_ = new index();
index_.getdata(row2["nv_id"].ToString(), row2["nv_hoten"].ToString(), quyen);
index_.Show();
this.Hide();
}
}
else
{
MessageBox.Show("Đăng nhập thất bại!", "Error", MessageBoxButtons.OKCancel, MessageBoxIcon.Error);
}
#endregion
}
private void load()
{
string sql = "select dt_ma, dt_ten,dt_mota, k_ten from daotao a, khoa b where a.k_id = b.k_id";
DataTable data = func.getdata(sql);
dataGridView1.DataSource = data;
string sql2 = "select * from khoa ";
DataTable data2 = func.getdata(sql2);
foreach (DataRow row in data2.Rows)
{
cbkhoa.Items.Add(row["k_ten"]);
}
}
private void load()
{
string sql = "select nv_hoten, nv_ngaysinh,case when nv_gioitinh =1 then 'Nam' else 'Nữ' end as nv_gioitinh, nv_diachi, nv_dienthoai, nv_email, k_ten from nhanvien a, khoa b where a.k_id = b.k_id";
DataTable data = func.getdata(sql);
dataGridView1.DataSource = data;
string sql2 = "select * from khoa ";
DataTable data2 = func.getdata(sql2);
foreach (DataRow row in data2.Rows)
{
txtkhoa.Items.Add(row["k_ten"]);
}
}
private void UserControl1_Load(object sender, EventArgs e)
{
String sql = "select nv_hoten, case WHEN nv_gioitinh =0 then 'Nam' ELSE 'Nữ' END as nv_gioitinh ,nv_dienthoai,nv_diachi, nv_email, q_ten from nhanvien a, quyennhanvien b, quyen c where a.nv_id = b.nv_id and b.q_id = c.q_id";
DataTable data = func.getdata(sql);
this.dataGridView2.DataSource = data;
}
private void load()
{
string sql = "select dk_id, sv_hoten, case when sv_gioitinh = 0 then 'Nam' else 'Nữ' end as sv_gioitinh, sv_dienthoai, dt_ten, dk_trangthai from sinhvien a , dangky b , daotao c where a.sv_id = b.sv_id and b.dt_id = c.dt_id";
DataTable data = func.getdata(sql);
dataGridView1.DataSource = data;
}
private void button1_Click(object sender, EventArgs e)
{
string sql = "select SUM(kq_tichluy) as tichluy, a.sv_hoten, case when a.sv_gioitinh =1 then 'Nam' else 'Nữ' end as sv_gioitinh,a.sv_ngaysinh, a.sv_diachi from sinhvien a, ketqua b where a.sv_id = b.sv_id GROUP by a.sv_hoten,a.sv_gioitinh,a.sv_ngaysinh, a.sv_diachi HAVING tichluy >2";
DataTable data = func.getdata(sql);
reportViewer1.LocalReport.ReportEmbeddedResource = "WindowsFormsApplication1.bangtotnghiep.rdlc";
reportViewer1.LocalReport.DataSources.Add(new ReportDataSource("DataSet1", data));
reportViewer1.RefreshReport();
}
public void show_data()
{
string sql = "select * from nhanvien where nv_id =" + id;
DataTable data = func.getdata(sql);
foreach (DataRow row in data.Rows)
{
this.txthoten.Text = row["nv_hoten"].ToString();
this.txtsdt.Text = row["nv_dienthoai"].ToString();
this.txtgioitinh.Text = (Convert.ToInt32(row["nv_gioitinh"]) == 1) ? "Nam" : "Nữ";
this.txtdiachi.Text = row["nv_diachi"].ToString();
this.txtemail.Text = row["nv_email"].ToString();
this.txttaikhoan.Enabled = false;
this.txttaikhoan.Text = row["nv_tentaikhoan"].ToString();
}
}
