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; }