public List <DonHangModel> GetOdersByShop(string mashop, int pageIndex, int pageSize, out long total)
        {
            var kq = isp.GetDonHangByShop(mashop, pageIndex, pageSize, out total);

            foreach (var item in kq)
            {
                item.Tonggiatri = 0;
                item.TongDonVi  = 0;
                item.chitiet    = isp.getctbymadonhang(item.MaDH);
                {
                    for (int i = 0; i < item.chitiet.Count; i++)
                    {
                        item.Tonggiatri += item.chitiet[i].DonGia * item.chitiet[i].SoLuong;
                        item.TongDonVi  += item.chitiet[i].SoLuong;
                    }
                }
                if (item.MaKH != null)
                {
                    item.thongtinkh = isp2.getbyid(item.MaKH);
                }
                else
                {
                    item.thongtinkh          = new KhachHangModel();
                    item.thongtinkh.tk       = new TaiKhoanModel();
                    item.thongtinkh.HoTen    = item.TenKH;
                    item.thongtinkh.tk.Email = item.Email;
                }
                if (item.MaDiaChi != null)
                {
                    item.diachinhanhang         = isp2.Getdcbyid(item.MaDiaChi.Value);
                    item.diachinhanhang.tttinh  = isp2.GetTinh(item.diachinhanhang.Tinh);
                    item.diachinhanhang.tthuyen = isp2.GetHuyen(item.diachinhanhang.Huyen);
                    item.diachinhanhang.ttxa    = isp2.GetXa(item.diachinhanhang.Xa);
                }
                else
                {
                    item.diachinhanhang             = new DiaChiModel();
                    item.diachinhanhang.tttinh      = isp2.GetTinh(item.Tinh.Value);
                    item.diachinhanhang.tttinh      = isp2.GetTinh(item.Tinh.Value);
                    item.diachinhanhang.ttxa        = isp2.GetXa(item.Xa.Value);
                    item.diachinhanhang.tthuyen     = isp2.GetHuyen(item.Huyen.Value);
                    item.diachinhanhang.ChiTiet     = item.DCChitiet;
                    item.diachinhanhang.SoDienThoai = item.SoDienThoai;
                }
            }
            return(kq);
        }
Exemplo n.º 2
0
        public KhachHangModel DangNhap(string tk, string mk, string email)
        {
            var kh = _res.DangNhap(tk, mk, email);

            if (kh != null)
            {
                kh.dsdiachi = _res.GeDiachi(kh.MaKhachHang);
                foreach (var dc in kh.dsdiachi)
                {
                    dc.tttinh  = _res.GetTinh(dc.Tinh);
                    dc.tthuyen = _res.GetHuyen(dc.Huyen);
                    dc.ttxa    = _res.GetXa(dc.Xa);
                }
                kh.tk = _res.GetTaiKhoan(kh.MaKhachHang);
            }
            return(kh);
        }
        public ThongKeModel ThongkeThang(string mashop, int thang)
        {
            int doanhthutheoloai = 0; int chiphitheoloai = 0;
            var kq = new ThongKeModel();

            kq = tk.TongQuanThang(mashop, thang);
            kq.incomebycates = l.GetDataAll();
            kq.sphethang     = tk.Sphethang(mashop);
            kq.spbanchay     = tk.Spbanchay(mashop, thang);
            kq.dsdh          = tk.donhangtheothang(mashop, thang);
            kq.dshdn         = tk.phieunhaptheothang(mashop, thang);
            foreach (var item in kq.spbanchay)
            {
                item.dsgiaban   = sp.GetGiaBans(item.MaSanPham);
                item.giahientai = sp.Getgiahientai(item.MaSanPham);
                item.kho        = sp.Getkhobysp(item.MaSanPham);
                item.danhmuc    = sp.getloaibySanPham(item.MaSanPham);
                item.loaicon1   = sp.getloai1bySanPham(item.MaSanPham);
                item.loaicon2   = sp.getloai2bySanPham(item.MaSanPham);
            }
            foreach (var item in kq.sphethang)
            {
                item.dsgiaban   = sp.GetGiaBans(item.MaSanPham);
                item.giahientai = sp.Getgiahientai(item.MaSanPham);
                item.kho        = sp.Getkhobysp(item.MaSanPham);
                item.danhmuc    = sp.getloaibySanPham(item.MaSanPham);
                item.loaicon1   = sp.getloai1bySanPham(item.MaSanPham);
                item.loaicon2   = sp.getloai2bySanPham(item.MaSanPham);
            }
            foreach (var item in kq.dsdh)
            {
                item.Tonggiatri = 0;
                item.TongDonVi  = 0;
                item.chitiet    = dh.getctbymadonhang(item.MaDH);
                {
                    for (int i = 0; i < item.chitiet.Count; i++)
                    {
                        item.Tonggiatri += item.chitiet[i].DonGia * item.chitiet[i].SoLuong;
                        item.TongDonVi  += item.chitiet[i].SoLuong;
                    }
                }
                if (item.MaKH != null)
                {
                    item.thongtinkh = kh.getbyid(item.MaKH);
                }
                else
                {
                    item.thongtinkh          = new KhachHangModel();
                    item.thongtinkh.tk       = new TaiKhoanModel();
                    item.thongtinkh.HoTen    = item.TenKH;
                    item.thongtinkh.tk.Email = item.Email;
                }
                if (item.MaDiaChi != null)
                {
                    item.diachinhanhang         = kh.Getdcbyid(item.MaDiaChi.Value);
                    item.diachinhanhang.tttinh  = kh.GetTinh(item.diachinhanhang.Tinh);
                    item.diachinhanhang.tthuyen = kh.GetHuyen(item.diachinhanhang.Huyen);
                    item.diachinhanhang.ttxa    = kh.GetXa(item.diachinhanhang.Xa);
                }
                else
                {
                    item.diachinhanhang             = new DiaChiModel();
                    item.diachinhanhang.tttinh      = kh.GetTinh(item.Tinh.Value);
                    item.diachinhanhang.tttinh      = kh.GetTinh(item.Tinh.Value);
                    item.diachinhanhang.ttxa        = kh.GetXa(item.Xa.Value);
                    item.diachinhanhang.tthuyen     = kh.GetHuyen(item.Huyen.Value);
                    item.diachinhanhang.ChiTiet     = item.DCChitiet;
                    item.diachinhanhang.SoDienThoai = item.SoDienThoai;
                }
            }
            foreach (var item in kq.dshdn)
            {
                item.Tongdonvi  = 0;
                item.Tongchiphi = 0;
                item.chitiet    = hdn.GetCtHDN(item.MaHDN);
                for (int i = 0; i < item.chitiet.Count; i++)
                {
                    item.Tongdonvi  += item.chitiet[i].Soluong;
                    item.Tongchiphi += item.chitiet[i].Soluong * item.chitiet[i].DonGia;
                }
            }
            foreach (var i in kq.incomebycates)
            {
                tk.doanhthutheoloaitheothang(mashop, i.MaLoai, thang, out doanhthutheoloai, out chiphitheoloai);
                i.income = doanhthutheoloai;
                i.chiphi = chiphitheoloai;
            }
            return(kq);
        }