public Entities.BCNhapHangTheoNhomChiTiet[] ChiTietKho(string makho)
{
try
{
int sl = 0;
Entities.BCNhapHangTheoNhomChiTiet[] temp = new Entities.BCNhapHangTheoNhomChiTiet[hienthibaocao.Length];
for (int i = 0; i < hienthibaocao.Length; i++)
{
if (hienthibaocao[i].MaNhomHang == makho)
{
if (hienthibaocao[i].SoLuong > 0)
{
temp[sl] = hienthibaocao[i];
sl++;
}
}
}
Entities.BCNhapHangTheoNhomChiTiet[] baocao = new Entities.BCNhapHangTheoNhomChiTiet[sl];
for (int i = 0; i < sl; i++)
{
baocao[i] = temp[i];
}
return(baocao);
}
catch
{
return(new Entities.BCNhapHangTheoNhomChiTiet[0]);
}
}
public void TongTienNhanVien()
{
try
{
nam = int.Parse(cbbnam.Text);
thang = int.Parse(cbbthang.Text);
double tongnhap, nhap;
int sotang = 0;
hienthi = new Entities.BCNhapHangTheoNhom[nhomhang.Length];
for (int i = 0; i < nhomhang.Length; i++)
{
for (int k = 0; k < hanghoa.Length; k++)
{
if (hanghoa[k].MaNhomHangHoa == nhomhang[i].MaNhomHang)
{
sotang++;
}
}
}
hienthibaocao = new Entities.BCNhapHangTheoNhomChiTiet[sotang];
sotang = 0;
for (int i = 0; i < nhomhang.Length; i++)
{
tongnhap = 0;
for (int k = 0; k < hanghoa.Length; k++)
{
nhap = 0;
if (hanghoa[k].MaNhomHangHoa == nhomhang[i].MaNhomHang)
{
// nhập hàng - hóa đơn nhập
for (int l = 0; l < hoadonnhap.Length; l++)
{
for (int o = 0; o < chitiethoadonnhap.Length; o++)
{
int namphieu = hoadonnhap[l].NgayNhap.Year;
int thangphieu = hoadonnhap[l].NgayNhap.Month;
if (chitiethoadonnhap[o].MaHoaDonNhap == hoadonnhap[l].MaHoaDonNhap && nam == namphieu && thang == thangphieu)
{
if (chitiethoadonnhap[o].MaHangHoa == hanghoa[k].MaHangHoa)
{
tongnhap += chitiethoadonnhap[o].SoLuong;
nhap += chitiethoadonnhap[o].SoLuong;
}
}
}
}
// nhập hàng - khách hàng trả lại
for (int l = 0; l < khachhangtralai.Length; l++)
{
for (int o = 0; o < chitietkhachhangtralai.Length; o++)
{
int namphieu = khachhangtralai[l].NgayNhap.Year;
int thangphieu = khachhangtralai[l].NgayNhap.Month;
if (chitietkhachhangtralai[o].MaKhachHangTraLai == khachhangtralai[l].MaKhachHangTraLai && nam == namphieu && thang == thangphieu)
{
if (chitietkhachhangtralai[o].MaHangHoa == hanghoa[k].MaHangHoa)
{
tongnhap += chitietkhachhangtralai[o].SoLuong;
nhap += chitietkhachhangtralai[o].SoLuong;
}
////////////////////////////////////////////////MRK FIX
else
{ //là gói hàng
foreach (Entities.GoiHang gh in goihang)
{
foreach (Entities.ChiTietGoiHang ctgh in chitietgoihang)
{
if (gh.MaGoiHang.Equals(ctgh.MaGoiHang) && ctgh.MaGoiHang.Equals(chitietkhachhangtralai[o].MaHangHoa) && ctgh.MaHangHoa.Equals(hanghoa[k].MaHangHoa))
{
tongnhap += (chitietkhachhangtralai[o].SoLuong * ctgh.SoLuong);
nhap += (chitietkhachhangtralai[o].SoLuong * ctgh.SoLuong);
}
}
}
}
////////////////////////////////////////////////MRK FIX
}
}
}
// nhập hàng - phiếu điều chuyển kho nội bộ
for (int l = 0; l < phieudieuchuyenkhonoibo.Length; l++)
{
for (int o = 0; o < chitietphieudieuchuyenkho.Length; o++)
{
int namphieu = phieudieuchuyenkhonoibo[l].NgayDieuChuyen.Year;
int thangphieu = phieudieuchuyenkhonoibo[l].NgayDieuChuyen.Month;
if (chitietphieudieuchuyenkho[o].MaPhieuDieuChuyenKho == phieudieuchuyenkhonoibo[l].MaPhieuDieuChuyenKho && nam == namphieu && thang == thangphieu)
{
if (chitietphieudieuchuyenkho[o].MaHangHoa == hanghoa[k].MaHangHoa)
{
tongnhap += chitietphieudieuchuyenkho[o].SoLuong;
nhap += chitietphieudieuchuyenkho[o].SoLuong;
}
////////////////////////////////////////////////MRK FIX
else
{ //là gói hàng
foreach (Entities.GoiHang gh in goihang)
{
foreach (Entities.ChiTietGoiHang ctgh in chitietgoihang)
{
if (gh.MaGoiHang.Equals(ctgh.MaGoiHang) && ctgh.MaGoiHang.Equals(chitietphieudieuchuyenkho[o].MaHangHoa) && ctgh.MaHangHoa.Equals(hanghoa[k].MaHangHoa))
{
tongnhap += (chitietphieudieuchuyenkho[o].SoLuong * ctgh.SoLuong);
nhap += (chitietphieudieuchuyenkho[o].SoLuong * ctgh.SoLuong);
}
}
}
}
////////////////////////////////////////////////MRK FIX
}
}
}
hienthibaocao[sotang] = new Entities.BCNhapHangTheoNhomChiTiet(nhomhang[i].MaNhomHang, nhomhang[i].TenNhomHang, hanghoa[k].MaHangHoa, hanghoa[k].TenHangHoa, nhap);
sotang++;
}
}
hienthi[i] = new Entities.BCNhapHangTheoNhom("", nhomhang[i].MaNhomHang, nhomhang[i].TenNhomHang, tongnhap.ToString());
}
Entities.BCNhapHangTheoNhom[] temp = new Entities.BCNhapHangTheoNhom[hienthi.Length];
int soluong = 0;
for (int i = 0; i < hienthi.Length; i++)
{
if (hienthi[i].TongNhap != "0")
{
temp[soluong] = hienthi[i];
soluong++;
}
}
hienthi = new Entities.BCNhapHangTheoNhom[soluong];
for (int i = 0; i < soluong; i++)
{
hienthi[i] = temp[i];
}
///////////////////////////////MRK FIX
List<Entities.BCNhapHangTheoNhom> tem0 = new List<Entities.BCNhapHangTheoNhom>();
double tong0 = 0;
foreach (Entities.BCNhapHangTheoNhom item in hienthi)
{
if (item == null)
{
continue;
}
tong0 += double.Parse(item.TongNhap);
tem0.Add(item);
}
Entities.BCNhapHangTheoNhom tem1 = new Entities.BCNhapHangTheoNhom();
tem1.TenNhomHang = "Tổng: ";
tem1.TongNhap = tong0.ToString();
tem0.Add(tem1);
//////////////////////////////////////
//dtgvhienthi.DataSource = hienthi;
dtgvhienthi.DataSource = tem0.ToArray();
if (hienthi.Length > 0)
{
tsslexcel.Enabled = tsslPdf.Enabled = tsslWord.Enabled = tsslchitiet.Enabled = true;
}
else
{
tsslexcel.Enabled = tsslPdf.Enabled = tsslWord.Enabled = tsslchitiet.Enabled = false;
}
}
catch { }
finally
{
fix();
}
}
public void TongTienNhanVien()
{
try
{
nam = int.Parse(cbbnam.Text);
thang = int.Parse(cbbthang.Text);
double tongnhap, nhap;
int sotang = 0;
hienthi = new Entities.BCNhapHangTheoNhom[nhomhang.Length];
for (int i = 0; i < nhomhang.Length; i++)
{
for (int k = 0; k < hanghoa.Length; k++)
{
if (hanghoa[k].MaNhomHangHoa == nhomhang[i].MaNhomHang)
{
sotang++;
}
}
}
hienthibaocao = new Entities.BCNhapHangTheoNhomChiTiet[sotang];
sotang = 0;
for (int i = 0; i < nhomhang.Length; i++)
{
tongnhap = 0;
for (int k = 0; k < hanghoa.Length; k++)
{
nhap = 0;
if (hanghoa[k].MaNhomHangHoa == nhomhang[i].MaNhomHang)
{
// nhập hàng - hóa đơn nhập
for (int l = 0; l < hoadonnhap.Length; l++)
{
for (int o = 0; o < chitiethoadonnhap.Length; o++)
{
int namphieu = hoadonnhap[l].NgayNhap.Year;
int thangphieu = hoadonnhap[l].NgayNhap.Month;
if (chitiethoadonnhap[o].MaHoaDonNhap == hoadonnhap[l].MaHoaDonNhap && nam == namphieu && thang == thangphieu)
{
if (chitiethoadonnhap[o].MaHangHoa == hanghoa[k].MaHangHoa)
{
tongnhap += chitiethoadonnhap[o].SoLuong;
nhap += chitiethoadonnhap[o].SoLuong;
}
}
}
}
// nhập hàng - khách hàng trả lại
for (int l = 0; l < khachhangtralai.Length; l++)
{
for (int o = 0; o < chitietkhachhangtralai.Length; o++)
{
int namphieu = khachhangtralai[l].NgayNhap.Year;
int thangphieu = khachhangtralai[l].NgayNhap.Month;
if (chitietkhachhangtralai[o].MaKhachHangTraLai == khachhangtralai[l].MaKhachHangTraLai && nam == namphieu && thang == thangphieu)
{
if (chitietkhachhangtralai[o].MaHangHoa == hanghoa[k].MaHangHoa)
{
tongnhap += chitietkhachhangtralai[o].SoLuong;
nhap += chitietkhachhangtralai[o].SoLuong;
}
////////////////////////////////////////////////MRK FIX
else
{ //là gói hàng
foreach (Entities.GoiHang gh in goihang)
{
foreach (Entities.ChiTietGoiHang ctgh in chitietgoihang)
{
if (gh.MaGoiHang.Equals(ctgh.MaGoiHang) && ctgh.MaGoiHang.Equals(chitietkhachhangtralai[o].MaHangHoa) && ctgh.MaHangHoa.Equals(hanghoa[k].MaHangHoa))
{
tongnhap += (chitietkhachhangtralai[o].SoLuong * ctgh.SoLuong);
nhap += (chitietkhachhangtralai[o].SoLuong * ctgh.SoLuong);
}
}
}
}
////////////////////////////////////////////////MRK FIX
}
}
}
// nhập hàng - phiếu điều chuyển kho nội bộ
for (int l = 0; l < phieudieuchuyenkhonoibo.Length; l++)
{
for (int o = 0; o < chitietphieudieuchuyenkho.Length; o++)
{
int namphieu = phieudieuchuyenkhonoibo[l].NgayDieuChuyen.Year;
int thangphieu = phieudieuchuyenkhonoibo[l].NgayDieuChuyen.Month;
if (chitietphieudieuchuyenkho[o].MaPhieuDieuChuyenKho == phieudieuchuyenkhonoibo[l].MaPhieuDieuChuyenKho && nam == namphieu && thang == thangphieu)
{
if (chitietphieudieuchuyenkho[o].MaHangHoa == hanghoa[k].MaHangHoa)
{
tongnhap += chitietphieudieuchuyenkho[o].SoLuong;
nhap += chitietphieudieuchuyenkho[o].SoLuong;
}
////////////////////////////////////////////////MRK FIX
else
{ //là gói hàng
foreach (Entities.GoiHang gh in goihang)
{
foreach (Entities.ChiTietGoiHang ctgh in chitietgoihang)
{
if (gh.MaGoiHang.Equals(ctgh.MaGoiHang) && ctgh.MaGoiHang.Equals(chitietphieudieuchuyenkho[o].MaHangHoa) && ctgh.MaHangHoa.Equals(hanghoa[k].MaHangHoa))
{
tongnhap += (chitietphieudieuchuyenkho[o].SoLuong * ctgh.SoLuong);
nhap += (chitietphieudieuchuyenkho[o].SoLuong * ctgh.SoLuong);
}
}
}
}
////////////////////////////////////////////////MRK FIX
}
}
}
hienthibaocao[sotang] = new Entities.BCNhapHangTheoNhomChiTiet(nhomhang[i].MaNhomHang, nhomhang[i].TenNhomHang, hanghoa[k].MaHangHoa, hanghoa[k].TenHangHoa, nhap);
sotang++;
}
}
hienthi[i] = new Entities.BCNhapHangTheoNhom("", nhomhang[i].MaNhomHang, nhomhang[i].TenNhomHang, tongnhap.ToString());
}
Entities.BCNhapHangTheoNhom[] temp = new Entities.BCNhapHangTheoNhom[hienthi.Length];
int soluong = 0;
for (int i = 0; i < hienthi.Length; i++)
{
if (hienthi[i].TongNhap != "0")
{
temp[soluong] = hienthi[i];
soluong++;
}
}
hienthi = new Entities.BCNhapHangTheoNhom[soluong];
for (int i = 0; i < soluong; i++)
{
hienthi[i] = temp[i];
}
///////////////////////////////MRK FIX
List <Entities.BCNhapHangTheoNhom> tem0 = new List <Entities.BCNhapHangTheoNhom>();
double tong0 = 0;
foreach (Entities.BCNhapHangTheoNhom item in hienthi)
{
if (item == null)
{
continue;
}
tong0 += double.Parse(item.TongNhap);
tem0.Add(item);
}
Entities.BCNhapHangTheoNhom tem1 = new Entities.BCNhapHangTheoNhom();
tem1.TenNhomHang = "Tổng: ";
tem1.TongNhap = tong0.ToString();
tem0.Add(tem1);
//////////////////////////////////////
//dtgvhienthi.DataSource = hienthi;
dtgvhienthi.DataSource = tem0.ToArray();
if (hienthi.Length > 0)
{
tsslexcel.Enabled = tsslPdf.Enabled = tsslWord.Enabled = tsslchitiet.Enabled = true;
}
else
{
tsslexcel.Enabled = tsslPdf.Enabled = tsslWord.Enabled = tsslchitiet.Enabled = false;
}
}
catch { }
finally
{
fix();
}
}
public Entities.BCNhapHangTheoNhomChiTiet[] ChiTietKho(string makho)
{
try
{
int sl = 0;
Entities.BCNhapHangTheoNhomChiTiet[] temp = new Entities.BCNhapHangTheoNhomChiTiet[hienthibaocao.Length];
for (int i = 0; i < hienthibaocao.Length; i++)
{
if (hienthibaocao[i].MaNhomHang == makho)
{
if (hienthibaocao[i].SoLuong > 0)
{
temp[sl] = hienthibaocao[i];
sl++;
}
}
}
Entities.BCNhapHangTheoNhomChiTiet[] baocao = new Entities.BCNhapHangTheoNhomChiTiet[sl];
for (int i = 0; i < sl; i++)
{
baocao[i] = temp[i];
}
return baocao;
}
catch
{
return new Entities.BCNhapHangTheoNhomChiTiet[0];
}
}