private void hienthikhachhang()
{
//Tao chuoi sql doc du lieu tu bang NHANVIEN
String sql = "Select makh,tenkh From khachhang order by tenkh";
//Lay du lieu tu DataSet do vao DataGridView
cbb_makh.DataSource = lib.reDataSet(sql).Tables[0].DefaultView;
cbb_makh.DisplayMember = "tenkh";
cbb_makh.ValueMember = "makh";
}
private void HienThiChucVu()
{
//Tao chuoi sql doc du lieu tu bang NHANVIEN
String sql = "Select * From chucvu where tencv !='admin' order by macv";
//Lay du lieu tu DataSet do vao DataGridView
cbb_chucvu.DataSource = lib.reDataSet(sql).Tables[0].DefaultView;
cbb_chucvu.DisplayMember = "tencv";
cbb_chucvu.ValueMember = "macv";
}
private void hienthipnchoxl()
{
//Tao chuoi sql doc du lieu tu bang NHANVIEN
String sql = "Select * From phieunhan join khachhang on phieunhan.makh=khachhang.makh join nhanvien on phieunhan.manv=nhanvien.manv join xuly on phieunhan.maphieu=xuly.maphieu join trangthai on xuly.matt=trangthai.matt where xuly.ghichu=N'' and xuly.matt=N'DN' order by phieunhan.maphieu";
//Tat che do tu dong tao ra Column cua DataGridView
dgv_pnchuaxl.AutoGenerateColumns = false;
//Lay du lieu tu DataSet do vao DataGridView
dgv_pnchuaxl.DataSource = lib.reDataSet(sql).Tables[0].DefaultView;
}
public frm_in_phieunhan()
{
InitializeComponent();
crp_in_phieunhan sv = new crp_in_phieunhan();
String sql = "Select khachhang.tenkh, maphieu, serisp, tensp, nhanvien.tennv,yeucaukh, ngaynhanhs, ngayhentra, ghichu From phieunhan join nhanvien On phieunhan.manv=nhanvien.manv join khachhang on phieunhan.makh=khachhang.makh where maphieu=(select max (maphieu) from phieunhan)";
if (lib.reDataSet(sql).Tables[0].Rows.Count == 0)
{
MessageBox.Show("No data", "Reporting", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
sv.SetDataSource(lib.reDataSet(sql).Tables[0]);
crystalReportViewer1.ReportSource = sv;
}
private void btt_dn_Click(object sender, EventArgs e)
{
String tk = txt_tk.Text;
String mk = txt_mk.Text.Trim();
//if (String.IsNullOrEmpty(tk) && String.IsNullOrEmpty(mk))
if (tk == "" || mk == "")
{
MessageBox.Show("Tài khoản & Mật khẩu không được rỗng", "THÔNG BÁO", MessageBoxButtons.OK, MessageBoxIcon.Warning);
txt_tk.Focus();
}
else
{
String mk_md5 = lib.cryMD5(mk);
String sql = "Select * from nhanvien Where manv=N'" + tk + "' and matkhau=N'" + mk_md5 + "'";
if (lib.reDataSet(sql).Tables[0].Rows.Count != 0)
{
//MessageBox.Show("Đăng nhập thành công", "Thông Báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
frm_main frmchinh = new frm_main(tk);
this.Hide();
frmchinh.ShowDialog();
try { this.Show(); }
catch { }
}
else
{
MessageBox.Show("Đăng nhập thất bại/n Do tài khoản hoặc mật khẩu sai", "THÔNG BÁO", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
public frm_bc_pn()
{
InitializeComponent();
crp_bc_pn sv = new crp_bc_pn();
DateTime nnhs = DateTime.Today;
String ngaynhs = String.Format("{0:MM/dd/yyyy}", nnhs);
String sql = "Select khachhang.tenkh, maphieu, serisp, tensp, nhanvien.tennv,yeucaukh, ngaynhanhs, ngayhentra, ghichu From phieunhan join nhanvien On phieunhan.manv=nhanvien.manv join khachhang on phieunhan.makh=khachhang.makh where ngaynhanhs='" + ngaynhs + "'";
if (lib.reDataSet(sql).Tables[0].Rows.Count == 0)
{
MessageBox.Show("No data", "Reporting", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
sv.SetDataSource(lib.reDataSet(sql).Tables[0]);
crystalReportViewer1.ReportSource = sv;
}
public frm_inhoadon(String mahd)
{
dungchung lib = new dungchung();
InitializeComponent();
//KHai bao chuoi sql
String sql = "Select hoadon.mahd,hoadon.maphieu,nhanvien.tennv,ngaylaphd,spdv.tenspdv,chitiethd.soluong,chitiethd.dongia from (hoadon join nhanvien on hoadon.manv=nhanvien.manv) join chitiethd on hoadon.mahd=chitiethd.mahd join spdv on chitiethd.maspdv=spdv.maspdv where hoadon.mahd='" + mahd + "'";
crp_hoadon Inhoadon = new crp_hoadon();
if (lib.reDataSet(sql).Tables[0].Rows.Count == 0)
{
MessageBox.Show("No data.", "QLBH", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
Inhoadon.SetDataSource(lib.reDataSet(sql).Tables[0].DefaultView);
crv_inhoadon.ReportSource = Inhoadon;
}
private void HienThiSPDV()
{
//Tao chuoi sql doc du lieu tu bang NHANVIEN
String sql = "Select * From spdv";
//Tat che do tu dong tao ra Column cua DataGridView
dgv_spdv.AutoGenerateColumns = false;
//Lay du lieu tu DataSet do vao DataGridView
dgv_spdv.DataSource = lib.reDataSet(sql).Tables[0].DefaultView;
}
private void HienThiKhachHang()
{
//Tao chuoi sql doc du lieu tu bang NHANVIEN
String sql = "Select * From khachhang order by makh";
//Tat che do tu dong tao ra Column cua DataGridView
dgv_khachhang.AutoGenerateColumns = false;
//Lay du lieu tu DataSet do vao DataGridView
dgv_khachhang.DataSource = lib.reDataSet(sql).Tables[0].DefaultView;
}
