public List <CTHDBan> LayCTHDBan(CTHDBan cthdb) { List <CTHDBan> list = cthdbDAL.GetData(); List <CTHDBan> kq = new List <CTHDBan>(); if (cthdb.maHDB == null) { kq = list; } if (cthdb.maHDB != null) { for (int i = 0; i < list.Count; ++i) { if (list[i].maHDB == cthdb.maHDB) { kq.Add(new CTHDBan(list[i])); } } } else { kq = null; } return(kq); }
public void Insert(CTHDBan cthdb) { StreamWriter sw = File.AppendText(txtfile); sw.WriteLine(cthdb.maHDB + "\t" + cthdb.maMT + "\t" + cthdb.soLuong + "\t" + cthdb.donGia + "\t" + cthdb.thanhTien); sw.Close(); }
public void ThemCTHDBan(CTHDBan cthdb) { if (cthdb.maHDB != "" && cthdb.maMT != "") { cthdb.maHDB = CongCu.ChuanHoaMa(cthdb.maHDB); cthdb.maMT = CongCu.ChuanHoaMa(cthdb.maMT); cthdbDAL.Insert(cthdb); } else { throw new Exception("Dữ liệu sai."); } }
public List <CTHDBan> GetCTHDBanByHoaDonBan(string maHDBan) { List <CTHDBan> list = new List <CTHDBan>(); string query = "SELECT MaCTHDBan, MaHDBan, TenSP, SoLuong FROM dbo.CTHDBan INNER JOIN dbo.SanPham ON CTHDBan.Ma = SanPham.MaSP WHERE MaHDBan = '" + maHDBan + "'"; DataTable data = DataProvider.Instance.ExecuteQuery(query); foreach (DataRow item in data.Rows) { CTHDBan CTHDBan = new CTHDBan(item); list.Add(CTHDBan); } return(list); }
public List <CTHDBan> GetListCTHDBan() { List <CTHDBan> list = new List <CTHDBan>(); string query = "SELECT * FROM dbo.CTHDBan"; DataTable data = DataProvider.Instance.ExecuteQuery(query); foreach (DataRow item in data.Rows) { CTHDBan CTHDBan = new CTHDBan(item); list.Add(CTHDBan); } return(list); }
public long GetBanPT() { long result = 0; List <CTHDBan> list = new List <CTHDBan>(); string query = "SELECT MaCTHDBan, SoLuong * DonGia as BanPT FROM dbo.CTHDBan JOIN dbo.PhuTung ON CTHDBan.Ma = PhuTung.Ma"; DataTable data = DataProvider.Instance.ExecuteQuery(query); foreach (DataRow item in data.Rows) { CTHDBan CTHDBan = new CTHDBan(item, "pt"); list.Add(CTHDBan); } foreach (CTHDBan item in list) { result += item.BanPT; } return(result); }
public void Nhap(int x, int y, ConsoleColor background_color, ConsoleColor text_color) { do { Console.BackgroundColor = background_color; Console.ForegroundColor = text_color; IHDBanBLL hdban = new HDBanBLL(); INhanVienBLL nhanvien = new NhanVienBLL(); IKhachHangBLL khachhang = new KhachHangBLL(); IMayTinhBLL maytinh = new MayTinhBLL(); IHDNhapBLL hdnhap = new HDNhapBLL(); FormNhanVien fnv = new FormNhanVien(); FormKhachHang fkh = new FormKhachHang(); FormMayTinh fmt = new FormMayTinh(); NhanVienBLL nvBLL = new NhanVienBLL(); KhachHangBLL khBLL = new KhachHangBLL(); MayTinhBLL mtBLL = new MayTinhBLL(); FormHDNhap fhdn = new FormHDNhap(); ICTHDBanBLL cthdban = new CTHDBanBLL(); HDBanBLL hdbBLL = new HDBanBLL(); HDBan hdb = new HDBan(); CTHDBan cthdb = new CTHDBan(); HDBan hd; Console.Clear(); IO.Box(0, 0, 28, 114, ConsoleColor.Black, ConsoleColor.White); IO.BoxTitle(" NHẬP THÔNG TIN HÓA ĐƠN BÁN", x, y, 10, 112); IO.Writexy("Mã nhân viên:", x + 2, y + 3); IO.Writexy("Mã khách hàng:", x + 28, y + 3); IO.Writexy("Ngày bán:", x + 55, y + 3); IO.Writexy("Tổng tiền:", x + 83, y + 3); IO.Writexy("--------------------------------------------------------------------------------------------------------------", x + 1, y + 4); IO.Writexy("Mã máy tính:", x + 2, y + 5); IO.Writexy("Số lượng:", x + 28, y + 5); IO.Writexy("Đơn giá:", x + 55, y + 5); IO.Writexy("Thành tiền:", x + 83, y + 5); IO.Writexy("--------------------------------------------------------------------------------------------------------------", x + 1, y + 6); IO.Writexy("Nhập ! để thoát...", x + 4, y + 8); fnv.Hien(x, y + 10, nhanvien.LayDSNhanVien(), 5, 0); do { Console.SetCursorPosition(x + 16, y + 3); hdb.maNV = Console.ReadLine(); if (hdb.maNV == null) { IO.Clear(x + 3, y + 7, 60, ConsoleColor.Black); IO.Writexy("Nhập lại mã nhân viên...", x + 4, y + 7, ConsoleColor.Black, ConsoleColor.White); } else if (hdb.maNV == "!") { return; } else { if (nvBLL.KT_MaNhanVien(CongCu.ChuanHoaMa(hdb.maNV)) == false) { IO.Writexy("Không tồn tại mã nhân viên này...", x + 4, y + 7, ConsoleColor.Black, ConsoleColor.White); IO.Clear(x + 15, y + 3, 12, ConsoleColor.Black); } else { break; } } } while (hdb.maNV == null || nvBLL.KT_MaNhanVien(CongCu.ChuanHoaMa(hdb.maNV)) == false); IO.Clear(x + 3, y + 7, 60, ConsoleColor.Black); IO.Clear(x + 3, y + 8, 60, ConsoleColor.Black); fkh.Hien(x + 16, y + 10, khachhang.LayDSKhachHang(), 5, 0); do { Console.SetCursorPosition(x + 43, y + 3); hdb.maKH = Console.ReadLine(); if (hdb.maKH == null) { IO.Clear(x + 3, y + 7, 60, ConsoleColor.Black); IO.Writexy("Nhập lại mã khách hàng...", x + 4, y + 7, ConsoleColor.Black, ConsoleColor.White); } else { if (khBLL.KT_MaKhachHang(CongCu.ChuanHoaMa(hdb.maKH)) == false) { IO.Writexy("Không tồn tại mã khách hàng này...", x + 4, y + 7, ConsoleColor.Black, ConsoleColor.White); IO.Clear(x + 42, y + 3, 12, ConsoleColor.Black); } else { break; } } } while (hdb.maKH == null || khBLL.KT_MaKhachHang(CongCu.ChuanHoaMa(hdb.maKH)) == false); IO.Clear(x + 3, y + 7, 60, ConsoleColor.Black); fhdn.Hien(x + 13, y + 10, hdnhap.LayDSHDNhap(), 5, 0); IO.Writexy("Nhập ngày bán định dạng 'dd/MM/yyyy'...", x + 4, y + 8, ConsoleColor.Black, ConsoleColor.White); do { Console.SetCursorPosition(x + 65, y + 3); hdb.ngayBan = Console.ReadLine(); if (hdb.ngayBan == null || CongCu.CheckDate(hdb.ngayBan) == false) { IO.Writexy("Nhập lại ngày bán...", x + 4, y + 7, ConsoleColor.Black, ConsoleColor.White); IO.Clear(x + 64, y + 3, 18, ConsoleColor.Black); } } while (hdb.ngayBan == null || CongCu.CheckDate(hdb.ngayBan) == false); hdban.ThemHDBan(hdb); while (true) { hd = hdbBLL.LayMaHDB(hdb.maNV, hdb.maKH, hdb.ngayBan); cthdb.maHDB = hd.maHDB; IO.Clear(x + 3, y + 7, 60, ConsoleColor.Black); fmt.Hien(x + 11, y + 10, maytinh.LayDSMayTinh(), 5, 0); do { IO.Clear(x + 14, y + 5, 13, ConsoleColor.Black); Console.SetCursorPosition(x + 15, y + 5); cthdb.maMT = Console.ReadLine(); if (cthdb.maMT == null) { IO.Clear(x + 3, y + 7, 60, ConsoleColor.Black); IO.Writexy("Nhập lại mã máy tính...", x + 4, y + 7, ConsoleColor.Black, ConsoleColor.White); } else { if (mtBLL.KT_MaMayTinh(CongCu.ChuanHoaMa(cthdb.maMT)) == false) { IO.Writexy("Không tồn tại mã máy tính này...", x + 4, y + 7, ConsoleColor.Black, ConsoleColor.White); IO.Clear(x + 14, y + 5, 13, ConsoleColor.Black); } else { break; } } } while (cthdb.maMT == null || mtBLL.KT_MaMayTinh(CongCu.ChuanHoaMa(cthdb.maMT)) == false); IO.Clear(x + 3, y + 8, 60, ConsoleColor.Black); IO.Clear(x + 3, y + 7, 60, ConsoleColor.Black); MayTinh mt = mtBLL.LayMayTinh(CongCu.ChuanHoaMa(cthdb.maMT)); do { IO.Clear(x + 37, y + 5, 14, ConsoleColor.Black); cthdb.soLuong = int.Parse(IO.ReadNumber(x + 38, y + 5)); if (cthdb.soLuong <= 0 || mt.sLCon <= 0 || cthdb.soLuong > mt.sLCon) { IO.Writexy("Nhập lại số lượng...", x + 4, y + 7, ConsoleColor.Black, ConsoleColor.White); IO.Clear(x + 37, y + 5, 14, ConsoleColor.Black); } } while (cthdb.soLuong <= 0 || mt.sLCon <= 0 || cthdb.soLuong > mt.sLCon); IO.Clear(x + 3, y + 7, 60, ConsoleColor.Black); IO.Clear(x + 63, y + 5, 16, ConsoleColor.Black); cthdb.donGia = mt.giaBan; IO.Writexy(cthdb.donGia.ToString(), x + 64, y + 5); IO.Clear(x + 3, y + 7, 60, ConsoleColor.Black); IO.Clear(x + 94, y + 5, 16, ConsoleColor.Black); IO.Writexy(cthdb.thanhTien.ToString(), x + 95, y + 5); cthdban.ThemCTHDBan(cthdb); if (mtBLL.KT_MaMayTinh(cthdb.maMT) == true) { mtBLL.TruSoLuong(mt, cthdb.soLuong); } IO.Clear(x + 3, y + 7, 60, ConsoleColor.Black); Console.SetCursorPosition(x + 34, y + 7); IO.Writexy("Nhập tiếp? (C/K)...", x + 4, y + 7); ConsoleKeyInfo c = Console.ReadKey(); if (c.KeyChar != 'c') { break; } } IO.Clear(x + 93, y + 5, 16, ConsoleColor.Black); IO.Writexy(hdbBLL.TTien(cthdb.maHDB).ToString(), x + 94, y + 3); hdb.tongTien = hdbBLL.TTien(cthdb.maHDB); IO.Clear(x + 3, y + 7, 60, ConsoleColor.Black); IO.Writexy("Enter để nhập, Esc để thoát...", x + 4, y + 7); Console.SetCursorPosition(x + 34, y + 7); ConsoleKeyInfo kt = Console.ReadKey(); if (kt.Key == ConsoleKey.Escape) { break; } else if (kt.Key == ConsoleKey.Enter) { IO.Clear(x + 3, y + 7, 60, ConsoleColor.Black); IO.Writexy("Hóa đơn bán đã được thêm...", x + 4, y + 7); hdban.XoaHDBan(cthdb.maHDB); hdban.ThemHDBan(hdb); Hien(x + 13, y + 10, hdban.LayDSHDBan(), 5, 1); } } while (true); }