private void cbmakh_SelectedIndexChanged(object sender, EventArgs e)
{
BanHang2017.Classes.DataProcess dtbase = new BanHang2017.Classes.DataProcess();
SqlConnection con = dtbase.laycon();
con.Open();
string sq = "select KhachHang.MaKH,TenKH,DiaChi,Email,SDT,dbo.LoaiKH.MaLoaiKH from dbo.KhachHang inner join dbo.LoaiKH on dbo.KhachHang.MaLoaiKH=dbo.LoaiKH.MaLoaiKH where MaKH='" + cbmakh.Text + "'";
DataTable l = new DataTable();
l = dtbase.SelectTable(sq);
cbloaikh.DataSource = l;
cbloaikh.DisplayMember = "MaLoaiKH";
cbloaikh.ValueMember = "MaLoaiKH";
SqlCommand cm1 = new SqlCommand(sq, con);
SqlDataReader reader = cm1.ExecuteReader();
if (reader.HasRows)
{
reader.Read();
tbtenkh.Text = reader.GetString(1).ToString();
tbdiachi.Text = reader.GetString(2).ToString();
tbemail.Text = reader.GetString(3).ToString();
tbsdt.Text = reader.GetString(4).ToString();
cbloaikh.Text = reader.GetInt32(5).ToString();
}
}
private void cbmakm_SelectedIndexChanged(object sender, EventArgs e)
{
string s = "select *from ChuongTrinhKhuyenMai where MaCTKM='" + cbmakm.Text + "'";
DataTable k = new DataTable();
k = dtbase.SelectTable(s);
cbmadtkh.DataSource = k;
cbmadtsp.DataSource = k;
cbmadtkh.DisplayMember = "MaDTKH";
cbmadtkh.ValueMember = "MaDTKH";
cbmadtsp.DisplayMember = "MaDTSP";
cbmadtsp.ValueMember = "MaDTSP";
SqlConnection con = dtbase.laycon();
con.Open();
SqlCommand cm = new SqlCommand(s, con);
SqlDataReader r = cm.ExecuteReader();
if (r.HasRows)
{
r.Read();
tbtenkm.Text = r.GetString(1).ToString();
dtpst.Text = r.GetDateTime(2).ToString();
dtped.Text = r.GetDateTime(3).ToString();
cbmadtkh.Text = r.GetInt32(4).ToString();
cbmadtsp.Text = r.GetString(5).ToString();
tbgiamgia.Text = r.GetDouble(6).ToString();
}
}
private void btlogin_Click(object sender, EventArgs e)
{
BanHang2017.Classes.DataProcess dtbase = new BanHang2017.Classes.DataProcess();
SqlConnection con = dtbase.laycon();
con.Open();
string sq = "select *from dbo.[User] where Username='******'";
SqlCommand cm = new SqlCommand(sq, con);
SqlDataReader reader = cm.ExecuteReader();
DataTable h = new DataTable();
h = dtbase.SelectTable(sq);
if (h.Rows.Count == 0)
{
lbhien.Text = "Thông Tin Tài Khoản Mật Khẩu Không Chính Xác";
tbuser1.Focus();
}
if (reader.HasRows)
{
reader.Read();
if (tbpw1.Text == reader.GetString(2).ToString())
{
this.Hide();
//MessageBox.Show("đăng nhập thành công");
FormKhachHang frmKH = new FormKhachHang();
frmKH.Show();
}
else
{
lbhien.Text = "Thông Tin Tài Khoản Mật Khẩu Không Chính Xác";
tbpw1.Focus();
}
}
}
private void cbmahd_SelectedIndexChanged(object sender, EventArgs e)
{
DataTable h1 = new DataTable();
string sql1 = "select* from dbo.HoaDonBan where MaHDB='" + cbmahd.Text + "' ";
h1 = dtbase.SelectTable(sql1);
cbmanv.DataSource = h1;
cbmanv.DisplayMember = "MaNV";
cbmanv.ValueMember = "MaNV";
cbmakh.DataSource = h1;
cbmakh.DisplayMember = "MaKH";
cbmakh.ValueMember = "MaKH";
SqlConnection con = dtbase.laycon();
con.Open();
SqlCommand cm = new SqlCommand(sql1, con);
SqlDataReader rd = cm.ExecuteReader();
if (rd.HasRows)
{
rd.Read();
dtp.Text = rd.GetDateTime(3).ToString();
cbmanv.Text = rd.GetString(1).ToString();
cbmakh.Text = rd.GetString(2).ToString();
}
string s = "select ao.MaSP,SanPham.TenSP,GiaBan,SoLuong,Sale,(GiaBan*SoLuong*((100-sale)/100)) as thanhtien from ao inner join dbo.SanPham on dbo.SanPham.MaSP=ao.MaSP where MaHDB='" + cbmahd.Text + "'";
DataTable l = new DataTable();
l = dtbase.SelectTable(s);
dtgview.DataSource = l;
dtgview.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
dtgview.Columns[0].HeaderText = "Mã SP";
dtgview.Columns[1].HeaderText = "Tên Sản Phẩm";
dtgview.Columns[2].HeaderText = "Đơn Giá";
dtgview.Columns[3].HeaderText = "Số Lượng";
dtgview.Columns[4].HeaderText = "Giảm Giá";
dtgview.Columns[5].HeaderText = "Thành Tiền";
DataTable kk = new DataTable();
kk = dtbase.SelectTable(" select sum(GiaBan*SoLuong*((100-sale)/100)) as thanhtien from ao where MaHDB = '" + cbmahd.Text + "'");
tbtotal.Text = kk.Rows[0][0].ToString();
}
private void cbMaLoaiKH_SelectedIndexChanged(object sender, EventArgs e)
{
dtbase = new BanHang2017.Classes.DataProcess();
SqlConnection con = dtbase.laycon();
con.Open();
string s1 = "select *from dbo.LoaiKH where MaLoaiKH='" + cbMaLoaiKH.Text.ToString() + "'";
SqlCommand cm = new SqlCommand(s1, con);
SqlDataReader r1 = cm.ExecuteReader();
if (r1.HasRows)
{
r1.Read();
tbTenLoaiKH.Text = r1.GetString(1).ToString();
tbghichu.Text = r1.GetString(2).ToString();
}
}
private void cbmanv1_SelectedIndexChanged(object sender, EventArgs e)
{
DataTable h = new DataTable();
SqlConnection con = dtbase.laycon();
con.Open();
string s = "select dbo.NhanVien.MaNV,dbo.NhanVien.TenNV,Username,Password from dbo.[User] inner join dbo.NhanVien on dbo.[User].MaNV=dbo.NhanVien.MaNV where dbo.NhanVien.MaNV='" + cbmanv1.Text + "'";
SqlCommand cm = new SqlCommand(s, con);
SqlDataReader reader = cm.ExecuteReader();
if (reader.HasRows)
{
reader.Read();
tbtennv1.Text = reader.GetString(1).ToString();
tbuser.Text = reader.GetString(2).ToString();
tbpass.Text = reader.GetString(3).ToString();
}
}
private void btntim_Click(object sender, EventArgs e)
{
BanHang2017.Classes.DataProcess dtbase = new BanHang2017.Classes.DataProcess();
if (rbmakh.Checked==true)
{
SqlConnection con = dtbase.laycon();
con.Open();
string sq = "select KhachHang.MaKH,TenKH,DiaChi,Email,SDT,LoaiKH from dbo.KhachHang inner join dbo.LoaiKH on dbo.KhachHang.MaLoaiKH=dbo.LoaiKH.MaLoaiKH where MaKH LIKE N'%" + tbtimkiem.Text.ToString() + "%'";
SqlCommand cm1 = new SqlCommand(sq, con);
SqlDataReader reader = cm1.ExecuteReader();
if (reader.HasRows)
{
reader.Read();
cbmakh.Text = reader.GetString(0).ToString();
DataTable h = new DataTable();
h = dtbase.SelectTable(sq);
dtg1.DataSource = h;
}
else
{
MessageBox.Show("Mã bạn nhập không khớp. Vui lòng nhập lại!","Thông báo");
tbtimkiem.Focus();
}
}
if (rbtenkh.Checked == true)
{
SqlConnection con = dtbase.laycon();
con.Open();
string sq = "select KhachHang.MaKH,TenKH,DiaChi,Email,SDT,LoaiKH from dbo.KhachHang inner join dbo.LoaiKH on dbo.KhachHang.MaLoaiKH=dbo.LoaiKH.MaLoaiKH where TenKH LIKE N'%" + tbtimkiem.Text.ToString() + "%'";
SqlCommand cm1 = new SqlCommand(sq, con);
SqlDataReader reader = cm1.ExecuteReader();
if (reader.HasRows)
{
reader.Read();
cbmakh.Text = reader.GetString(0).ToString();
DataTable h1 = new DataTable();
h1 = dtbase.SelectTable(sq);
dtg1.DataSource = h1;
}
else
{
MessageBox.Show("Tên bạn nhập không hợp lệ. Vui lòng nhập lại!", "Thông báo");
tbtimkiem.Focus();
}
}
if (rbtinh.Checked == true)
{
SqlConnection con = dtbase.laycon();
con.Open();
string sq = "select KhachHang.MaKH,TenKH,DiaChi,Email,SDT,LoaiKH from dbo.KhachHang inner join dbo.LoaiKH on dbo.KhachHang.MaLoaiKH=dbo.LoaiKH.MaLoaiKH where DiaChi LIKE N'%" + tbtimkiem.Text.ToString() + "%'";
SqlCommand cm1 = new SqlCommand(sq, con);
SqlDataReader reader = cm1.ExecuteReader();
if (reader.HasRows)
{
reader.Read();
cbmakh.Text = reader.GetString(0).ToString();
DataTable h1 = new DataTable();
h1 = dtbase.SelectTable(sq);
dtg1.DataSource = h1;
}
else
{
MessageBox.Show("Tên tỉnh bạn nhập không hợp lệ. Vui lòng nhập lại!", "Thông báo");
tbtimkiem.Focus();
}
}
}