private void btnGetInfo_Click(object sender, EventArgs e) { if (txtIDCus.Text == "") { MessageBox.Show("Please insert value!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.None); } else { DBService db = new DBService(); db.openconn(); string sql = "SELECT* FROM KhachHang WHERE KH_id='" + txtIDCus.Text + "'"; SqlDataReader dr = db.getDataReader(sql); if (dr.HasRows) { dr.Read(); dr.GetString(0); txtNameCus.Text = dr.GetString(1).ToString(); txtPhone.Text = dr.GetString(2).ToString(); txtEmail.Text = dr.GetString(3).ToString(); txtAddress.Text = dr.GetString(4).ToString(); txtDebt.Text = dr.GetDouble(5).ToString(); } else { MessageBox.Show("Not found!"); txtIDCus.Text = txtNameCus.Text = txtAddress.Text = txtPhone.Text = txtEmail.Text = txtDebt.Text = ""; } db.openconn(); } }
public SqlDataReader Tim_TheoMa(string ma) { string sql = "select * from PHIEUNHAP where PN_id = '" + ma + "'"; DBService db = new DBService(); db.openconn(); SqlDataReader rd = db.getDataReader(sql); return(rd); }
public SqlDataReader Tim_TheoTen(string ten) { string sql = "select DSSACH.Sach_id as [Mã sách], DSSACH.Sach_name as [Tên sách], DSSACH.Sach_theloai as [Thể loại], DSSACH.Sach_tacgia as [Tác giả], DSSACH.Sach_number as [Số lượng tồn], DSSACH.Sach_giaban as [Đơn giá] from dbo.DSSACH DSSACH where Sach_name = N'" + ten + "'"; DBService db = new DBService(); SqlDataReader rd = null; db.openconn(); rd = db.getDataReader(sql); //db.closeconn(); return(rd); }
public void loadds_PN() { gCtrl_PhieuNS.DataSource = null; gView_PhieuNS.Columns.Clear(); string sql = "select PN.PN_id as [Mã phiếu], PN.PN_date as [Ngày lập phiếu] from PHIEUNHAP PN"; DBService db = new DBService(); db.openconn(); gCtrl_PhieuNS.DataSource = db.getDataReader(sql); db.closeconn(); }
public void loadds_PN_TheoKhoangNgay(string d1, string d2) { gCtrl_PhieuNS.DataSource = null; gView_PhieuNS.Columns.Clear(); string sql = "select PN.PN_id as [Mã phiếu], PN.PN_date as [Ngày lập phiếu] from PHIEUNHAP PN where PN.PN_date >= convert(datetime,'" + d1 + "',103) and PN.PN_date <= convert(datetime,'" + d2 + "',103)"; DBService db = new DBService(); db.openconn(); gCtrl_PhieuNS.DataSource = db.getDataReader(sql); db.closeconn(); }
public void load_ds() { gCtrlDSSach.DataSource = null; gViewDSSach.Columns.Clear(); DBService db = new DBService(); db.openconn(); string sql = "select DSSach.Sach_id as [Mã sách], DSSach.Sach_name as [Tên sách], DSSach.Sach_theloai as [Thể loại], DSSach.Sach_tacgia as [Tác giả], DSSach.Sach_nxb as [Năm xuất bản], DSSach.Sach_gianhap as [Giá nhập], DSSach.Sach_giaban as [Giá bán], DSSach.Sach_number as [Số lượng], DSSach.Sach_noidung as [Nội dung], DSSach.Sach_nhaxuatban as [Nhà xuất bản] from dbo.DSSach DSSach"; gCtrlDSSach.DataSource = db.getDataReader(sql); db.closeconn(); }
public void load_dssach() { gridControlSach.DataSource = null; gridView_DSSach.Columns.Clear(); DBService db = new DBService(); db.openconn(); string sql = "select DSSach.Sach_id as [Mã sách], DSSach.Sach_name as [Tên sách],DSSach.Sach_theloai as [Thể loại], DSSach.Sach_tacgia as [Tác giả],DSSach.Sach_nxb as [Năm xuất bản],DSSach.Sach_giaban as [Giá bán], DSSach.Sach_noidung as [Nội dung] from dbo.DSSach DSSach"; gridControlSach.DataSource = db.getDataReader(sql); db.closeconn(); }
private void btnTim_Click(object sender, EventArgs e) { gControl_TheLoaiSach.DataSource = null; gView_TheLoaiSach.Columns.Clear(); DBService db = new DBService(); db.openconn(); string sql = "select NHOMTHELOAI.NTL_id as [Mã thể loại], NHOMTHELOAI.NTL_name as [Tên thể loại], NHOMTHELOAI.NTL_note as [Ghi chú] from dbo.NHOMTHELOAI NHOMTHELOAI where NHOMTHELOAI.NTL_name = '" + txtTimKiem.Text + "'"; gControl_TheLoaiSach.DataSource = db.getDataReader(sql); db.closeconn(); }
public void load_dstls() { gControl_TheLoaiSach.DataSource = null; gView_TheLoaiSach.Columns.Clear(); DBService db = new DBService(); db.openconn(); string sql = "select NHOMTHELOAI.NTL_id as [Mã thể loại], NHOMTHELOAI.NTL_name as [Tên thể loại], NHOMTHELOAI.NTL_note as [Ghi chú] from dbo.NHOMTHELOAI NHOMTHELOAI"; gControl_TheLoaiSach.DataSource = db.getDataReader(sql); db.closeconn(); }
public SqlDataReader Tim_TheoNgay(string d) { //string sql = "select S.MASACH as [Mã sách], S.TENSACH as [Tên sách], S.THELOAI as [Thể loại], S.TACGIA as [Tác giả], CT.SOLUONGNHAP as [Số lượng nhập] from SACH S join CHITIETPHIEUNHAP CT on S.MASACH = CT.MASACH join PHIEUNHAP PN on CT.MaPHIEUNHAP = PN.MaPHIEUNHAP where PN.NGAYNHAP = convert(datetime,'"+d+"',103)"; string sql = "select * from PHIEUNHAP where PN_date = convert(datetime,'" + d + "',103)"; DBService db = new DBService(); SqlDataReader rd = null; db.openconn(); rd = db.getDataReader(sql); //db.closeconn(); return(rd); }
private void btnTim_Click(object sender, EventArgs e) { gridControl_NXB.DataSource = null; gridView_NXB.Columns.Clear(); DBService db = new DBService(); db.openconn(); string sql = "select * from dbo.NhomNhaXuatBan nxb where nxb.NXB_name = N'" + txtTimKiem.Text + "'"; gridControl_NXB.DataSource = db.getDataReader(sql); db.closeconn(); }
public void load_dsnxb() { gridControl_NXB.DataSource = null; gridView_NXB.Columns.Clear(); DBService db = new DBService(); db.openconn(); string sql = "select NhomNhaXuatBan.NXB_id as [Mã Nhà xuất bản], NhomNhaXuatBan.NXB_name as [Tên nhà xuất bản], NhomNhaXuatBan.NXB_number as [Số điện thoại], NhomNhaXuatBan.NXB_address as [Địa chỉ],NhomNhaXuatBan.NXB_note as [Ghi chú] from dbo.NhomNhaXuatBan NhomNhaXuatBan"; gridControl_NXB.DataSource = db.getDataReader(sql); db.closeconn(); }
private void btnTim_Click(object sender, EventArgs e) { gCtrlDSSach.DataSource = null; gViewDSSach.Columns.Clear(); DBService db = new DBService(); db.openconn(); string sql = "select * from dbo.DSSach DSSach where Sach_name = '" + txtTimKiem.Text + "'"; gCtrlDSSach.DataSource = db.getDataReader(sql); db.closeconn(); }
public void load_dstacgia() { gridControlTG.DataSource = null; gridView1.Columns.Clear(); DBService db = new DBService(); db.openconn(); string sql = "select NHOMTACGIA.NTG_id as [Mã tác giả], NHOMTACGIA.NTG_name as [Tên tác giả],NHOMTACGIA.NTG_note as [Ghi chú] from dbo.NHOMTACGIA NHOMTACGIA"; gridControlTG.DataSource = db.getDataReader(sql); db.closeconn(); }
public void load_dsnv() { gCtrl_DSNV.DataSource = null; gView_DSNV.Columns.Clear(); DBService db = new DBService(); db.openconn(); string sql = "select NhanVien.NV_id as [Mã nhân viên], NhanVien.NV_name as [Họ và tên],NhanVien.NV_gender as [Giới tính], NhanVien.NV_birthday as [Ngày sinh],NhanVien.NV_datework as [Ngày làm],NhanVien.NV_number as [Số điện thoại],NhanVien.NV_address as [Địa chỉ], NhanVien.NV_note as [Ghi chú], tk.Username as [Tài khoản], tk.Pass as [Mật khẩu], tk.Acc_Type as [Chức vụ] from dbo.NhanVien NhanVien join TaiKhoan tk on NhanVien.NV_id = tk.NV_id"; gCtrl_DSNV.DataSource = db.getDataReader(sql); db.closeconn(); }
private void btnTim_Click(object sender, EventArgs e) { gCtrl_DSNV.DataSource = null; gView_DSNV.Columns.Clear(); DBService db = new DBService(); db.openconn(); string sql = "select * from dbo.NhanVien Nv join TaiKhoan tk on nv.NV_id = tk.NV_id where nv.NV_name = N'" + txtTimKiem.Text + "'"; gCtrl_DSNV.DataSource = db.getDataReader(sql); db.closeconn(); }
public void load_dskh() { gControl_DSKH.DataSource = null; gView_DSKH.Columns.Clear(); DBService db = new DBService(); db.openconn(); string sql = "select KhachHang.KH_id as [Mã khách hàng],KhachHang.KH_name as [Tên khách hàng],KhachHang.KH_number as [Số điện thoại],KhachHang.KH_mail as [Email], KhachHang.KH_note as [Ghi chú], KhachHang.KH_scores as [Số tiền nợ] from dbo.KhachHang KhachHang"; gControl_DSKH.DataSource = db.getDataReader(sql); db.closeconn(); }
private void btnTim_Click(object sender, EventArgs e) { gControl_DSKH.DataSource = null; gView_DSKH.Columns.Clear(); DBService db = new DBService(); db.openconn(); string sql = "select KhachHang.KH_id as [Mã khách hàng],KhachHang.KH_name as [Tên khách hàng],KhachHang.KH_number as [Số điện thoại],KhachHang.KH_mail as [Email], KhachHang.KH_note as [Ghi chú], KhachHang.KH_scores as [Số tiền nợ] from dbo.KhachHang KhachHang where KH_id = '" + txtTimKiem.Text + "'"; gControl_DSKH.DataSource = db.getDataReader(sql); db.closeconn(); }
private void fmPhieuThuTien_Load(object sender, EventArgs e) { string sql = "select * from QUYDINH"; DBService db = new DBService(); db.openconn(); SqlDataReader rd = db.getDataReader(sql); rd.Read(); lblQD4.Visible = rd.GetBoolean(4); db.closeconn(); }
private void btnTim_Click(object sender, EventArgs e) { gridControlTG.DataSource = null; gridView1.Columns.Clear(); DBService db = new DBService(); db.openconn(); string sql = "select * from dbo.NhomTacGia tg where tg.NTG_name = N'" + txtTimKiem.Text + "'"; gridControlTG.DataSource = db.getDataReader(sql); db.closeconn(); }
public void load_dsncc() { gCtrol_NCC.DataSource = null; gView_NCC.Columns.Clear(); DBService db = new DBService(); db.openconn(); string sql = "select NHOMNHACUNGCAP.NCC_id as [Mã NCC], NHOMNHACUNGCAP.NCC_name as [Tên NCC], NHOMNHACUNGCAP.NCC_number as [Số điện thoại], NHOMNHACUNGCAP.NCC_address as [Địa chỉ], NHOMNHACUNGCAP.NCC_note as [Ghi chú] from dbo.NHOMNHACUNGCAP NHOMNHACUNGCAP"; gCtrol_NCC.DataSource = db.getDataReader(sql); db.closeconn(); }
private void btnTim_Click(object sender, EventArgs e) { gCtrol_NCC.DataSource = null; gView_NCC.Columns.Clear(); DBService db = new DBService(); db.openconn(); string sql = "select NHOMNHACUNGCAP.NCC_id as [Mã NCC], NHOMNHACUNGCAP.NCC_name as [Tên NCC], NHOMNHACUNGCAP.NCC_number as [Số điện thoại], NHOMNHACUNGCAP.NCC_address as [Địa chỉ], NHOMNHACUNGCAP.NCC_note as [Ghi chú] from dbo.NHOMNHACUNGCAP NHOMNHACUNGCAP where NCC_id = '" + txtTimKiem.Text + "'"; gCtrol_NCC.DataSource = db.getDataReader(sql); db.closeconn(); }
private void fmThongTinHDBS_Load(object sender, EventArgs e) { string sql = "select * from QUYDINH"; DBService db = new DBService(); db.openconn(); SqlDataReader rd = db.getDataReader(sql); rd.Read(); notoida = rd.GetInt32(2); db.closeconn(); lblTienNoKH.Text = notoida.ToString(); }
public bool ktMaHD(string ma) { string sql = "select * from HOADON where HD_id = '" + ma + "'"; DBService db = new DBService(); db.openconn(); SqlDataReader rd = db.getDataReader(sql); if (rd.HasRows) { return(true); } return(false); }
public bool ktMaPTT(string ma) { string sql = "select * from PHIEUTHUTIEN where PhieuThuTien_id = '" + ma + "'"; DBService db = new DBService(); db.openconn(); SqlDataReader rd = db.getDataReader(sql); if (rd.HasRows) { return(true); } return(false); }
public void load_DSHD(string ma) { gCtrl_HDBS.DataSource = null; gView_HDBS.Columns.Clear(); //gCtrl_DSNV.DataMember = "DSNV"; //gCtrl_DSNV.DataSource = sqlDS_loadDSNV.Result; DBService db = new DBService(); db.openconn(); string sql = "select s.Sach_id as [Mã sách], s.Sach_name as [Tên sách], s.Sach_theloai as [Thể loại], ctphd.CTPHD_number as [Số lượng], s.Sach_giaban as [Đơn giá], s.Sach_giaban*ctphd.CTPHD_number as [Thành tiền] from HOADON hd join CTHoaDon ctphd on hd.HD_id = ctphd.HD_id join DSSACH s on ctphd.Sach_id = s.Sach_id where hd.HD_id ='" + ma + "'"; gCtrl_HDBS.DataSource = db.getDataReader(sql); db.closeconn(); }
public void load_dsSach() { gCtrl_DSSach.DataSource = null; gView_DSSach.Columns.Clear(); //gCtrl_DSNV.DataMember = "DSNV"; //gCtrl_DSNV.DataSource = sqlDS_loadDSNV.Result; DBService db = new DBService(); db.openconn(); string sql = "select SACH.Sach_id as [Mã sách], SACH.Sach_name as [Tên sách], SACH.Sach_theloai as [Thể loại], SACH.Sach_tacgia as [Tác giả], SACH.Sach_number as [Số lượng tồn], SACH.Sach_giaban as [Đơn giá] from dbo.DSSACH SACH"; gCtrl_DSSach.DataSource = db.getDataReader(sql); db.closeconn(); }
private void fmHoaDonBS_Load(object sender, EventArgs e) { string sql = "select * from QUYDINH"; DBService db = new DBService(); db.openconn(); SqlDataReader rd = db.getDataReader(sql); rd.Read(); tonsauban = rd.GetInt32(3); db.closeconn(); lblText.Text += tonsauban.ToString(); }
public void load_DSPN() { gCtrl_DSachPN.DataSource = null; gView_DSPN.Columns.Clear(); //DB_PHIEUNHAP db1 = new DB_PHIEUNHAP(); //gCtrl_DSPN.DataSource = db1.Tim_TheoNgay("24/6/2017"); ////txtGia.Text = dati.Text; string sql = "select PhieuNhap.PN_id as [Mã phiếu nhập], DSSach.Sach_id as [Mã sách], DSSach.Sach_name as [Tên sách], DSSach.Sach_theloai as [Thể loại], DSSach.Sach_tacgia as [Tác giả], CTPhieuNhap.CTPN_number as [Số lượng nhập] from ((dbo.PhieuNhap PhieuNhap inner join dbo.CTPhieuNhap CTPhieuNhap on (CTPhieuNhap.PN_id = PhieuNhap.PN_id)) inner join dbo.DSSach DSSach on (DSSach.Sach_id = CTPhieuNhap.Sach_id)) where PhieuNhap.PN_id = '" + txtMaPhieu.Text + "'"; DBService db = new DBService(); db.openconn(); gCtrl_DSachPN.DataSource = db.getDataReader(sql); db.closeconn(); }
private void fmLapPhieuNhap_Load(object sender, EventArgs e) { load_DSPN(); string sql = "select * from QUYDINH"; DBService db = new DBService(); db.openconn(); SqlDataReader rd = db.getDataReader(sql); rd.Read(); nhaptt = rd.GetInt32(0); tontruocnhap = rd.GetInt32(1); db.closeconn(); lblNhaptt.Text = nhaptt.ToString(); lblTonTruocNhap.Text = tontruocnhap.ToString(); }