public List <BaoCaoTheoChungTu> getListBaoCaoTheoHangHoa(int check, string maKho) { string sql; if (check == 0) { sql = "SELECT ct.MaHang, ct.TenHang, ct.DonVi, ct.SoLuong,hh.GiaMua, nh.TenNhom, kh.TenKho, " + " ct.DonGia, ct.ThanhToan FROM CT_PHIEUXUAT ct, THONGTIN_PHIEU_BANHANG tt, HANGHOA_DICHVU hh, NHOMHANG nh, KHOHANG kh " + "WHERE ct.MaPhieuXuat = tt.MaPhieu and hh.MaHang = ct.MaHang and hh.MaHang = ct.MaHang and hh.MaNhom = nh.MaNhom and tt.MaKho = kh.MaKho"; } else { sql = string.Format("SELECT ct.MaHang, ct.TenHang, ct.DonVi, ct.SoLuong,hh.GiaMua, nh.TenNhom, kh.TenKho, " + " ct.DonGia, ct.ThanhToan FROM CT_PHIEUXUAT ct, THONGTIN_PHIEU_BANHANG tt, HANGHOA_DICHVU hh, NHOMHANG nh, KHOHANG kh " + "WHERE ct.MaPhieuXuat = tt.MaPhieu and hh.MaHang = ct.MaHang and hh.MaHang = ct.MaHang and hh.MaNhom = nh.MaNhom and tt.MaKho = kh.MaKho and tt.MaKho = '{0}'", maKho); } DataTable data = ConnectionDB.getData(sql); List <BaoCaoTheoChungTu> ListBaoCaoTheoHangHoa = new List <BaoCaoTheoChungTu>(); if (data.Rows.Count > 0) { foreach (DataRow dataRow in data.Rows) { BaoCaoTheoChungTu x = new BaoCaoTheoChungTu(); x.MaHang = dataRow["MaHang"].ToString(); x.TenHang = dataRow["TenHang"].ToString(); x.DonVi = dataRow["DonVi"].ToString(); x.SoLuong = (dataRow["SoLuong"].ToString()); x.DonGiaNhap = (dataRow["GiaMua"].ToString()); x.TongTienNhap = (int.Parse(x.SoLuong) * float.Parse(x.DonGiaNhap)).ToString(); x.DonGiaXuat = (dataRow["DonGia"].ToString()); x.TongTienXuat = (int.Parse(x.SoLuong) * float.Parse(x.DonGiaXuat)).ToString(); x.ChenhLech = (float.Parse(x.TongTienXuat) - float.Parse(x.TongTienNhap)).ToString(); x.KhoHang = dataRow["TenKho"].ToString(); x.NhomHang = dataRow["TenNhom"].ToString(); ListBaoCaoTheoHangHoa.Add(x); } } return(ListBaoCaoTheoHangHoa); }
public List <BaoCaoTheoChungTu> getListBaoCaoTheoNgay(int check, DateTime a, DateTime b) { List <DateTime> listDateMuaBan = new List <DateTime>(); if (check == 0) { listDateMuaBan = getListDateMuaBan(); } else { listDateMuaBan = getListDateMuaBanFromDate(a, b); } List <BaoCaoTheoChungTu> ListBaoCaoTheoNgay = new List <BaoCaoTheoChungTu>(); for (int i = 0; i < listDateMuaBan.Count; i++) { BaoCaoTheoChungTu x = new BaoCaoTheoChungTu(); x.NgayLap = listDateMuaBan[i].ToString(); x.TongTienNhap = sumTienMua(listDateMuaBan[i]).ToString(); x.TongTienXuat = sumTienBan(listDateMuaBan[i]).ToString(); ListBaoCaoTheoNgay.Add(x); } return(ListBaoCaoTheoNgay); }
public List <BaoCaoTheoChungTu> getListBaoCao(int check, DateTime a, DateTime b) { List <string> ListMaPhieuSell; if (check == 0) { ListMaPhieuSell = getMaPhieuInSell(); } else { ListMaPhieuSell = getMaPhieuInSellNgay(a, b); } List <BaoCaoTheoChungTu> listBaoCaoTheoChungTu = new List <BaoCaoTheoChungTu>(); for (int i = 0; i < ListMaPhieuSell.Count; i++) { DataTable data = getListBaoCao(ListMaPhieuSell[i]); BaoCaoTheoChungTu y = new BaoCaoTheoChungTu(); y.TenKH = data.Rows[0]["TenKH"].ToString(); y.MaKH = data.Rows[0]["MaKH"].ToString(); y.MaPhieu = data.Rows[0]["MaPhieuXuat"].ToString(); y.NgayLap = (data.Rows[0]["NgayLap"].ToString()); y.TienHang = (data.Rows[0]["TongTienBan"].ToString()); y.CK = (data.Rows[0]["CK"].ToString()); y.VAT = (data.Rows[0]["VAT"].ToString()); y.DoanhSo = (data.Rows[0]["TongTienNhan"].ToString()); float giaTriXuatKho = 0; foreach (DataRow dataRow in data.Rows) { giaTriXuatKho += (int.Parse(dataRow["SoLuong"].ToString()) * float.Parse(dataRow["GiaMua"].ToString())); } y.GiaTriXuatKho = giaTriXuatKho.ToString(); y.LoiNhuan = (Convert.ToDouble(y.DoanhSo) - Convert.ToDouble(y.GiaTriXuatKho)).ToString(); listBaoCaoTheoChungTu.Add(y); if (data.Rows.Count > 0) { foreach (DataRow dataRow in data.Rows) { BaoCaoTheoChungTu x = new BaoCaoTheoChungTu(); x.TenKH = dataRow["TenKH"].ToString(); x.MaKH = dataRow["MaKH"].ToString(); x.MaPhieu = dataRow["MaPhieuXuat"].ToString(); x.MaHang = dataRow["MaHang"].ToString(); x.TenHang = dataRow["TenHang"].ToString(); x.DonVi = dataRow["DonVi"].ToString(); x.SoLuong = (dataRow["SoLuong"].ToString()); x.DonGiaNhap = (dataRow["GiaMua"].ToString()); x.TongTienNhap = (int.Parse(x.SoLuong) * float.Parse(x.DonGiaNhap)).ToString(); x.DonGiaXuat = (dataRow["DonGia"].ToString()); x.TongTienXuat = (int.Parse(x.SoLuong) * float.Parse(x.DonGiaXuat)).ToString(); x.ChenhLech = (float.Parse(x.TongTienXuat) - float.Parse(x.TongTienNhap)).ToString(); listBaoCaoTheoChungTu.Add(x); } } } return(listBaoCaoTheoChungTu); }