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