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