private void btntaomoi_Click(object sender, EventArgs e)
{
cbMaLoaiKH.DropDownStyle = ComboBoxStyle.DropDown;
dtbase = new BanHang2017.Classes.DataProcess();
btnthem.Enabled = true;
btnsua.Enabled = false;
btnxoa.Enabled = true;
string s1 = "select *from dbo.LoaiKH";
DataTable h = new DataTable();
h = dtbase.SelectTable(s1);
int k = h.Rows.Count;
int max = Convert.ToInt32(h.Rows[0][0]);
for (int i = Convert.ToInt32(h.Rows[0][0]); i <= Convert.ToInt32(h.Rows[k - 1][0]); i++)
{
if (max < i)
{
max = i;
}
}
cbMaLoaiKH.Text = "" + (max + 1) + "";
tbTenLoaiKH.Text = "";
tbghichu.Text = "";
cbMaLoaiKH.Enabled = false;
}
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 btntaomoi_Click(object sender, EventArgs e)
{
ok = 1;
cbmakh.DropDownStyle = ComboBoxStyle.DropDown;
btnthem.Enabled = true;
btnxoa.Enabled = false;
btnsua.Enabled = false;
btnlichsu.Enabled = false;
tbdiachi.Enabled = true;
tbemail.Enabled = true;
tbtenkh.Enabled = true;
tbsdt.Enabled = true;
BanHang2017.Classes.DataProcess dtbase = new BanHang2017.Classes.DataProcess();
Random rd = new Random();
b2: string s = "KH"+rd.Next(1,10000).ToString()+"";
string kt = "select KhachHang.MaKH,TenKH,DiaChi,Email,SDT,LoaiKH from dbo.KhachHang inner join dbo.LoaiKH on dbo.KhachHang.MaLoaiKH=dbo.LoaiKH.MaLoaiKH where MaKH='"+s+"'";
DataTable k1 = new DataTable();
k1 = dtbase.SelectTable(kt);
if (k1.Rows.Count == 0) cbmakh.Text = s;
else goto b2;
tbtenkh.Text = "";
tbdiachi.Text = "";
tbemail.Text = "";
tbsdt.Text = "";
cbloaikh.Text = "";
cbmakh.Enabled = false;
DataTable m = new DataTable();
m = dtbase.SelectTable("select* from LoaiKH");
cbloaikh.DataSource = m;
cbloaikh.DisplayMember = "MaLoaiKH";
cbloaikh.ValueMember = "MaLoaiKH";
}
private void FormLoaiKH_Load(object sender, EventArgs e)
{
if (ểvedasxag5B.quyen == 2 || ểvedasxag5B.quyen == 3)
{
btnexit.Visible = false;
btnchitiet.Visible = false;
btnre.Visible = false;
btntaomoi.Visible = false;
btnxoa.Visible = false;
btnsua.Visible = false;
btnthem.Visible = false;
}
cbMaLoaiKH.Enabled = true;
cbMaLoaiKH.DropDownStyle = ComboBoxStyle.DropDownList;
DataTable h = new DataTable();
DataTable h1 = new DataTable();
string sq = "select *from dbo.LoaiKH";
dtbase = new BanHang2017.Classes.DataProcess();
h = dtbase.SelectTable(sq);
dtg2.DataSource = h;
cbMaLoaiKH.DataSource = h;
cbMaLoaiKH.DisplayMember = "MaLoaiKH";
cbMaLoaiKH.ValueMember = "MaLoaiKH";
dtg2.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
}
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 btnthem_Click(object sender, EventArgs e)
{
BanHang2017.Classes.DataProcess dtbase = new BanHang2017.Classes.DataProcess();
if (ok==1)
{
int k = 0;
if (tbdiachi.Text == "" || tbemail.Text == "" || tbtenkh.Text == "" || tbsdt.Text == "")
{
k = 1;
MessageBox.Show("Bạn cần nhập đủ thông tin", "TB");
if (tbtenkh.Text == "") tbtenkh.Focus();
if (tbsdt.Text == "") tbsdt.Focus();
if (tbemail.Text == "") tbemail.Focus();
if (tbdiachi.Text == "") tbdiachi.Focus();
}
else if (k == 0)
{
string ss = "INSERT dbo.KhachHang VALUES('" + cbmakh.Text + "',N'" + tbtenkh.Text + "','" + tbdiachi.Text + "','" + tbemail.Text + "','" + tbsdt.Text + "'," + cbloaikh.Text + ")";
dtbase.UpdateData(ss);
MessageBox.Show("Bạn đã thêm thành công", "Thông báo");
btnxoa.Enabled = true;
btnsua.Enabled = true;
btnlichsu.Enabled = true;
string l = "" + cbmakh.Text + "";
FormKhachHang_Load(sender, e);
cbmakh.SelectedValue = l;
ok = 0;
}
}
else
{
int k = 0;
if (tbdiachi.Text == "" || tbemail.Text == "" || tbtenkh.Text == "" || tbsdt.Text == "")
{
k = 1;
MessageBox.Show("Thông Tin Không Được Để Trống!", "TB");
if (tbtenkh.Text == "") tbtenkh.Focus();
if (tbsdt.Text == "") tbsdt.Focus();
if (tbemail.Text == "") tbemail.Focus();
if (tbdiachi.Text == "") tbdiachi.Focus();
}
else if(k==0)
{
string q = " update dbo.KhachHang set TenKH = N'" + tbtenkh.Text + "',DiaChi = N'" + tbdiachi.Text + "',Email = '" + tbemail.Text + "',SDT = '" + tbsdt.Text + "',MaLoaiKH = " + cbloaikh.Text + " where MaKH = '" + cbmakh.Text + "'";
dtbase.UpdateData(q);
MessageBox.Show("Bạn đã sửa thành công", "Thông báo");
btnxoa.Enabled = true;
btnsua.Enabled = true;
btnlichsu.Enabled = true;
cbmakh.DropDownStyle = ComboBoxStyle.DropDownList;
string l = "" + cbmakh.Text + "";
FormKhachHang_Load(sender, e);
cbmakh.SelectedValue = l;
}
}
}
private void btnlichsu_Click(object sender, EventArgs e)
{
DataTable hk = new DataTable();
BanHang2017.Classes.DataProcess dtbase = new BanHang2017.Classes.DataProcess();
string sqlqr = "select dbo.HoaDonBan.MaHDB,dbo.NhanVien.TenNV,dbo.KhachHang.TenKH,dbo.SanPham.TenSP,dbo.CTHoaDonBan.GiaBan,dbo.CTHoaDonBan.SoLuong,dbo.HoaDonBan.NgayLap from(((dbo.HoaDonBan inner join dbo.CTHoaDonBan on dbo.HoaDonBan.MaHDB= dbo.CTHoaDonBan.MaHDB) inner join dbo.NhanVien on dbo.HoaDonBan.MaNV = dbo.NhanVien.MaNV) inner join dbo.SanPham on dbo.CTHoaDonBan.MaSP = dbo.SanPham.MaSP) inner join dbo.KhachHang on dbo.HoaDonBan.MaKH = dbo.KhachHang.MaKH where dbo.HoaDonBan.MaKH='" + cbmakh.Text+"'";
hk = dtbase.SelectTable(sqlqr);
dtg1.DataSource = hk;
}
private void btnchitiet_Click(object sender, EventArgs e)
{
dtbase = new BanHang2017.Classes.DataProcess();
string sq = "select MaKH,TenKH,DiaChi,Email,SDT from dbo.KhachHang where dbo.KhachHang.MaLoaiKH='" + Convert.ToInt32(cbMaLoaiKH.Text) + "'";
DataTable h = new DataTable();
h = dtbase.SelectTable(sq);
dtg2.DataSource = h;
}
private void btnsua_Click(object sender, EventArgs e)
{
BanHang2017.Classes.DataProcess dtbase = new BanHang2017.Classes.DataProcess();
tbdiachi.Enabled = true;
tbemail.Enabled = true;
tbtenkh.Enabled = true;
tbsdt.Enabled = true;
btnthem.Enabled = true;
DataTable m = new DataTable();
m = dtbase.SelectTable("select* from LoaiKH");
cbloaikh.DataSource = m;
cbloaikh.DisplayMember = "MaLoaiKH";
cbloaikh.ValueMember = "MaLoaiKH";
}
private void btnxoa_Click(object sender, EventArgs e)
{
BanHang2017.Classes.DataProcess dtbase = new BanHang2017.Classes.DataProcess();
DialogResult d=MessageBox.Show("Bạn có muốn xóa không?", "Thông báo", MessageBoxButtons.YesNo,MessageBoxIcon.Question);
if (d == DialogResult.Yes)
{
MessageBox.Show("Bạn đã xóa thành công!", "Thông Báo");
string s = "DELETE FROM dbo.KhachHang WHERE MaKH= '" + cbmakh.Text.ToString() + "'";
dtbase.UpdateData(s);
FormKhachHang_Load(sender, e);
}
}
private void tbuser1_TextChanged(object sender, EventArgs e)
{
BanHang2017.Classes.DataProcess dtbase = new BanHang2017.Classes.DataProcess();
DataTable h = new DataTable();
string sql = "select *from dbo.NhanVien inner join dbo.[User] on dbo.NhanVien.MaNV=dbo.[User].MaNV where Username='******'";
h = dtbase.SelectTable(sql);
if (h.Rows.Count == 0)
{
tbnv1.Text = "";
}
else
{
tbnv1.Text = h.Rows[0][1].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 FormKhachHang_Load(object sender, EventArgs e)
{
cbmakh.DropDownStyle = ComboBoxStyle.DropDownList;
cbmakh.Enabled = true;
DataTable h = new DataTable();
BanHang2017.Classes.DataProcess dtbase = new BanHang2017.Classes.DataProcess();
string sqlqr = "select KhachHang.MaKH,TenKH,DiaChi,Email,SDT,LoaiKH from dbo.KhachHang inner join dbo.LoaiKH on dbo.KhachHang.MaLoaiKH=dbo.LoaiKH.MaLoaiKH";
h = dtbase.SelectTable(sqlqr);
dtg1.DataSource = h;
cbmakh.DataSource = h;
cbmakh.DisplayMember = "MaKH";
cbmakh.ValueMember = "MaKH";
dtg1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
tbdiachi.Enabled = false;
tbemail.Enabled = false;
tbtenkh.Enabled = false;
tbsdt.Enabled = false;
rbmakh.Checked = false;
rbtenkh.Checked = false;
rbtinh.Checked = false;
lbtim.Text = "";
tbtimkiem.Enabled = false;
btnthem.Enabled = false;
}
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();
}
}
}
