private void frmQuanLySanPham_Load(object sender, EventArgs e) { cmbDanhMuc.DataSource = DanhMucBUS.GetList(); cmbDanhMuc.DisplayMember = "TenDanhMuc"; cmbDanhMuc.ValueMember = "MaDanhMuc"; cmbTrangThai.Text = "Tất cả trạng thái"; }
private void btnThem_Click(object sender, EventArgs e) { if (txtTenDanhMuc.Text.Length == 0) { MessageBox.Show("Bạn Chưa Nhập Tên Danh Mục!", "Cảnh báo!"); } else { DanhMucDTO danhMuc = new DanhMucDTO(); danhMuc.TenDanhMuc = txtTenDanhMuc.Text; DanhMucBUS.Insert(danhMuc); MessageBox.Show("Thêm thành công!", "Thông báo!"); this.Refresh(); } }
void treelist_ThemDanhMuc() { TreeNode all = new TreeNode(); all.Text = "Tất cả"; all.Tag = "Tất cả"; treedanhmuc.Nodes.Add(all); List <DanhMucDTO> dm = DanhMucBUS.DanhMuc_List(); foreach (DanhMucDTO item in dm) { TreeNode node = new TreeNode(); node.Text = item.Dm_ten; node.Tag = item.Dm_id.ToString(); treedanhmuc.Nodes.Add(node); } }
private void btnImport_Click(object sender, EventArgs e) { try { if (!rdNew.Checked && !rdUpdate.Checked) { MessageBox.Show("Please select type of import"); return; } SanPhamBUS spBus = new SanPhamBUS(); foreach (DataGridViewRow row in this.dtgvCvsData.Rows) { SanPhamDTO sp = new SanPhamDTO(); sp.MaSanPham = row.Cells["name"].Value.ToString(); if (row.Cells["image"].Value.ToString() != "") { string[] splitHinhAnh = row.Cells["image"].Value.ToString().Split('/'); if (splitHinhAnh.Length > 2) { sp.HinhAnh = splitHinhAnh[3]; } else { sp.HinhAnh = row.Cells["image"].Value.ToString().Substring(2).ToLower(); } } else { sp.HinhAnh = ""; } string[] splitTrongLuong = row.Cells["weight"].Value.ToString().Split('.'); sp.TrongLuong = Int32.Parse(splitTrongLuong[0]); sp.MauSac = row.Cells["mau_sac"].Value.ToString(); string[] splitSoLuong = row.Cells["qty"].Value.ToString().Split('.'); //if (rdNew.Checked == true) //{ // sp.SoLuong = 100; //} //else //{ // sp.SoLuong = Int32.Parse(splitSoLuong[0]); //} sp.SoLuong = Int32.Parse(splitSoLuong[0]); sp.TrangThai = Int32.Parse(row.Cells["is_in_stock"].Value.ToString()); string[] splitGiaLe = row.Cells["price"].Value.ToString().Split('.'); sp.GiaLe = long.Parse(splitGiaLe[0]); string[] splitGiaSi = row.Cells["gia_si"].Value.ToString().Split('.'); sp.GiaSi = long.Parse(splitGiaSi[0]); if (sp.GiaSi == 0) { double a = (sp.GiaLe / 3) * 2; sp.GiaSi = (long)Math.Round(a); } sp.GiaGoc = sp.GiaSi / 2; sp.NgayNhap = System.DateTime.Now; sp.NguoiNhap = frmDangNhap.gUserName; sp.NgayCapNhat = System.DateTime.Now; sp.NguoiCapNhat = frmDangNhap.gUserName; DanhMucBUS dmBUS = new DanhMucBUS(); if (sp.MaSanPham.Substring(0, 1) == "N") { sp.MaDanhMuc = dmBUS.LayMaDanhMuc(@"Nhẫn").MaDanhMuc; } if (sp.MaSanPham.Substring(0, 1) == "X") { sp.MaDanhMuc = dmBUS.LayMaDanhMuc(@"Hình Xăm").MaDanhMuc; } if (sp.MaSanPham.Substring(0, 2) == "BT") { sp.MaDanhMuc = dmBUS.LayMaDanhMuc(@"Bông Tai").MaDanhMuc; } if (sp.MaSanPham.Substring(0, 2) == "DC") { sp.MaDanhMuc = dmBUS.LayMaDanhMuc(@"Dây Chuyền").MaDanhMuc; } if (sp.MaSanPham.Substring(0, 2) == "VT") { sp.MaDanhMuc = dmBUS.LayMaDanhMuc(@"Vòng Tay").MaDanhMuc; } if (sp.MaSanPham.Substring(0, 2) == "DL") { sp.MaDanhMuc = dmBUS.LayMaDanhMuc(@"Dây Lưng").MaDanhMuc; } if (sp.MaSanPham.Substring(0, 2) == "BA") { sp.MaDanhMuc = dmBUS.LayMaDanhMuc(@"Túi Xách").MaDanhMuc; } if (sp.MaSanPham.Substring(0, 2) == "KT") { sp.MaDanhMuc = dmBUS.LayMaDanhMuc(@"Phụ Kiện Tóc").MaDanhMuc; } if (sp.MaSanPham.Substring(0, 2) == "CA") { sp.MaDanhMuc = dmBUS.LayMaDanhMuc(@"Cài Áo").MaDanhMuc; } if (sp.MaSanPham.Substring(0, 2) == "BK") { sp.MaDanhMuc = dmBUS.LayMaDanhMuc(@"Bikini").MaDanhMuc; } if (sp.MaSanPham.Substring(0, 2) == "DH") { sp.MaDanhMuc = dmBUS.LayMaDanhMuc(@"Đồng Hồ").MaDanhMuc; } if (sp.MaSanPham.Substring(0, 2) == "MK") { sp.MaDanhMuc = dmBUS.LayMaDanhMuc(@"Móc Khóa").MaDanhMuc; } if (sp.MaSanPham.Substring(0, 2) == "KQ") { sp.MaDanhMuc = dmBUS.LayMaDanhMuc(@"Khăn Quàng Cổ").MaDanhMuc; } if (spBus.KiemTraTonTai(sp.MaSanPham) == true) { spBus.Update(sp); } else { spBus.Insert(sp); } } MessageBox.Show("Import dữ liệu thành công!", "Thông báo!"); } catch (System.Exception ex) { MessageBox.Show(ex.Message); return; } }