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 FormKm_Load(object sender, EventArgs e)
{
if (ểvedasxag5B.quyen == 2 || ểvedasxag5B.quyen == 3)
{
btluu.Visible = false;
btthem.Visible = false;
btxoa.Visible = false;
btsua.Visible = false;
btthoat.Visible = false;
}
//load combo km
DataTable h = new DataTable();
h = dtbase.SelectTable("select *from ChuongTrinhKhuyenMai");
cbmakm.DataSource = h;
cbmakm.DisplayMember = "MaCTKM";
cbmakm.ValueMember = "MaCTKM";
dtgkm.DataSource = h;
dtgkm.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
tbgiamgia.Enabled = false;
tbtenkm.Enabled = false;
dtped.Enabled = false;
dtpst.Enabled = false;
cktt.Checked = false;
cbmakm.DropDownStyle = ComboBoxStyle.DropDownList;
cbmakm.Enabled = true;
ok = 0;
}
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)
{
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 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 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 FormQuanLytk_Load(object sender, EventArgs e)
{
/*,dbo.NhanVien.TenNV,Username,Password from dbo.[User] inner join dbo.NhanVien on dbo.[User].MaNV = dbo.NhanVien.MaNV*/
DataTable h = new DataTable();
h = dtbase.SelectTable("select dbo.NhanVien.MaNV,dbo.NhanVien.TenNV,Username,Password from dbo.[User] inner join dbo.NhanVien on dbo.[User].MaNV = dbo.NhanVien.MaNV");
cbmanv1.DataSource = h;
cbmanv1.DisplayMember = "MaNV";
cbmanv1.ValueMember = "MaNV";
dtglogin.DataSource = h;
dtglogin.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
btthem.Enabled = false;
cbmanv1.DropDownStyle = ComboBoxStyle.DropDownList;
}
private void button1_Click(object sender, EventArgs e)
{
Label[] lb = { lb1, lb2, lb3, lb4, lb5, lb6, lb7, lb8, lb9, lb10 };
labelct.Text = "Chú Thích";
reset(lb);
chart1.Series["Sản Phẩm"].Points.Clear();
if (radioButton1.Checked == true)
{
string m = "select top " + cbtop.Text + " dbo.SanPham.MaSP,TenSP,sum(dbo.CTHoaDonBan.SoLuong) as soluong from (dbo.CTHoaDonBan inner join dbo.HoaDonBan on dbo.CTHoaDonBan.MaHDB=dbo.HoaDonBan.MaHDB) inner join dbo.SanPham on SanPham.MaSP=dbo.CTHoaDonBan.MaSP " +
"where MONTH(dbo.HoaDonBan.NgayLap)= " + cbthang.Text + " and YEAR(dbo.HoaDonBan.NgayLap)= " + cbnam.Text + " " +
"group by dbo.SanPham.MaSP,TenSP order by soluong desc ";
DataTable chart = new DataTable();
chart = dtbase.SelectTable(m);
int p = chart.Rows.Count;
for (int i = 0; i < p; i++)
{
this.chart1.Series["Sản Phẩm"].Points.AddXY("" + chart.Rows[i][0].ToString() + "(" + chart.Rows[i][2] + ")", chart.Rows[i][2]);
lb[i].Text = ("" + chart.Rows[i][0] + ":" + chart.Rows[i][1] + "");
}
label6.Text = "Biểu Đồ Thống Kê Top " + p + " Sản Phẩm Bán Chạy Nhất (Giảm Dần) Trong Tháng " + cbthang.Text + " Năm " + cbnam.Text + "";
}
else if (radioButton2.Checked == true)
{
string m = "select top " + cbtop.Text + " dbo.SanPham.MaSP,TenSP,sum(dbo.CTHoaDonBan.SoLuong) as soluong from (dbo.CTHoaDonBan inner join dbo.HoaDonBan on dbo.CTHoaDonBan.MaHDB=dbo.HoaDonBan.MaHDB) inner join dbo.SanPham on SanPham.MaSP=dbo.CTHoaDonBan.MaSP " +
"where dbo.HoaDonBan.NgayLap between '" + Convert.ToDateTime(dateTimePicker1.Text.ToString()) + "' and '" + Convert.ToDateTime(dateTimePicker2.Text.ToString()) + "' " +
"group by dbo.SanPham.MaSP,TenSP order by soluong desc ";
DataTable chart = new DataTable();
chart = dtbase.SelectTable(m);
int p = chart.Rows.Count;
for (int i = 0; i < p; i++)
{
this.chart1.Series["Sản Phẩm"].Points.AddXY("" + chart.Rows[i][0].ToString() + "(" + chart.Rows[i][2] + ")", chart.Rows[i][2]);
lb[i].Text = ("" + chart.Rows[i][0] + ":" + chart.Rows[i][1] + "");
}
label6.Text = "Biểu Đồ Thống Kê Top " + p + " Sản Phẩm Bán Chạy Nhất (Giảm Dần) Từ Ngày " + dateTimePicker1.Text + "" +
" Đến Ngày " + dateTimePicker2.Text + "";
}
}
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 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 btnxoa_Click(object sender, EventArgs e)
{
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)
{
DataTable h = new DataTable();
string s1 = "select *from dbo.KhachHang where MaLoaiKH='" + cbMaLoaiKH.Text + "'";
h = dtbase.SelectTable(s1);
if (h.Rows.Count > 0)
{
MessageBox.Show("Có khách hàng đang tồn tại loại này bạn hãy xóa hết khách hàng thuộc loại này!", "TB");
}
else
{
MessageBox.Show("Bạn đã xóa thành công!", "Thông Báo");
string s = "DELETE FROM dbo.LoaiKH WHERE dbo.LoaiKH.MaLoaiKH= '" + cbMaLoaiKH.Text.ToString() + "'";
dtbase.UpdateData(s);
FormLoaiKH_Load(sender, e);
}
}
}
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();
}
}
}
private void FormHDBan_Load(object sender, EventArgs e)
{
string sql1;
if (ểvedasxag5B.quyen == 3)
{
string q = "select *from dbo.[User] where username='******'";
DataTable u = new DataTable();
u = dtbase.SelectTable(q);
sql1 = "select* from dbo.HoaDonBan where MaNV='" + u.Rows[0][0] + "'";
}
else
{
sql1 = "select* from dbo.HoaDonBan ";
}
DataTable h = new DataTable();
h = dtbase.SelectTable(sql1);
cbmahd.DataSource = h;
cbmahd.DisplayMember = "MaHDB";
cbmahd.ValueMember = "MaHDB";
//load masp
string sql2 = "select *from dbo.SanPham";
DataTable k = new DataTable();
k = dtbase.SelectTable(sql2);
cbmasp.DataSource = k;
cbmasp.DisplayMember = "MaSP";
cbmasp.ValueMember = "MaSP";
groupBox2.Enabled = true;
tbsl.Text = "";
ok = 0;
cbmahd.Enabled = true;
cbmahd.DropDownStyle = ComboBoxStyle.DropDownList;
dtp.Enabled = false;
if (ểvedasxag5B.quyen == 2)
{
bthem.Visible = false;
btluu.Visible = false;
bthuy.Visible = false;
btthanhtoan.Visible = false;
btin.Visible = false;
btthoat.Visible = false;
}
}