/// <summary>
/// xử lý hiển thị
/// </summary>
public void HienThiTongThe()
{
try
{
phatsinhno = phatsinhco = sdck = sddk = 0;
try
{
hienthi = new Entities.SoQuy[pt.Length + pc.Length + bl.Length + bb.Length + hdn.Length + kh.Length + tl.Length + pttkh.Length + pttncc.Length + 1];
}
catch { }
if (kt == false)
{
for (int i = 0; i < sodu.Length; i++)
{
string monthsodu = sodu[i].NgayKetChuyen.Month.ToString();
string yearsodu = sodu[i].NgayKetChuyen.Year.ToString();
if (month == monthsodu && year == yearsodu)
{
sddk = Convert.ToDouble(sodu[i].SoDuDauKy);
break;
}
}
}
int soluong = 0;
// Phiếu Thu
for (int i = 0; i < pt.Length; i++)
{
string month1 = pt[i].NgayLap.Month.ToString();
string year1 = pt[i].NgayLap.Year.ToString();
if (month == month1 && year == year1)
{
phatsinhno = Convert.ToDouble(pt[i].TongTienThanhToan);
string ngaylap = new Common.Utilities().XuLy(2, pt[i].NgayLap.ToShortDateString());
hienthi[soluong] = new Entities.SoQuy(ngaylap, pt[i].MaPhieuThu, "1111", "Tiền mặt việt nam",
Format(phatsinhno), Format(phatsinhco), pt[i].GhiChu, "PhieuThu");
soluong++;
}
}
phatsinhno = phatsinhco = 0;
// Phiếu Chi
for (int i = 0; i < pc.Length; i++)
{
string month1 = pc[i].NgayLap.Month.ToString();
string year1 = pc[i].NgayLap.Year.ToString();
if (month == month1 && year == year1)
{
phatsinhco = Convert.ToDouble(pc[i].TongTienThanhToan);
string ngaylap = new Common.Utilities().XuLy(2, pc[i].NgayLap.ToShortDateString());
hienthi[soluong] = new Entities.SoQuy(ngaylap, pc[i].MaPhieuThu, "1111", "Tiền mặt việt nam",
Format(phatsinhno), Format(phatsinhco), pc[i].GhiChu, "PhieuChi");
soluong++;
}
}
phatsinhno = phatsinhco = 0;
// Bán Lẻ
for (int i = 0; i < bl.Length; i++)
{
string month1 = bl[i].NgayBan.Month.ToString();
string year1 = bl[i].NgayBan.Year.ToString();
if (month == month1 && year == year1)
{
List <double> bientam = TienIch.TinhDoanhThu(Convert.ToDouble(bl[i].TongTienThanhToan), Convert.ToDouble(bl[i].GiaTriThe), Convert.ToDouble(bl[i].GiaTriTheGiaTri));
phatsinhno = bientam[3]; //bl[i].ThanhToanNgay
string ngaylap = new Common.Utilities().XuLy(2, bl[i].NgayBan.ToShortDateString());
hienthi[soluong] = new Entities.SoQuy(ngaylap, bl[i].MaHDBanHang, "1111", "Tiền mặt việt nam",
Format(phatsinhno), Format(phatsinhco), bl[i].GhiChu, "BanLe");
soluong++;
}
}
phatsinhno = phatsinhco = 0;
// Bán Buôn
for (int i = 0; i < bb.Length; i++)
{
string month1 = bb[i].NgayBan.Month.ToString();
string year1 = bb[i].NgayBan.Year.ToString();
if (month == month1 && year == year1)
{
double a = Convert.ToDouble(bb[i].TongTienThanhToan);
double b = Convert.ToDouble(bb[i].ThanhToanKhiLapPhieu);
if (b > a)
{
b = a;
}
phatsinhno = b;
string ngaylap = new Common.Utilities().XuLy(2, bb[i].NgayBan.ToShortDateString());
hienthi[soluong] = new Entities.SoQuy(ngaylap, bb[i].MaHDBanHang, "1111", "Tiền mặt việt nam",
Format(phatsinhno), Format(phatsinhco), bb[i].GhiChu, "BanBuon");
soluong++;
}
}
phatsinhno = phatsinhco = 0;
// Hóa Đơn Nhập
for (int i = 0; i < hdn.Length; i++)
{
string month1 = hdn[i].NgayNhap.Month.ToString();
string year1 = hdn[i].NgayNhap.Year.ToString();
if (month == month1 && year == year1)
{
double a = Convert.ToDouble(hdn[i].TongTien);
double b = Convert.ToDouble(hdn[i].ThanhToanNgay);
if (b > a)
{
b = a;
}
phatsinhco = b;
string ngaylap = new Common.Utilities().XuLy(2, hdn[i].NgayNhap.ToShortDateString());
hienthi[soluong] = new Entities.SoQuy(ngaylap, hdn[i].MaHoaDonNhap, "1111", "Tiền mặt việt nam",
Format(phatsinhno), Format(phatsinhco), hdn[i].GhiChu, "HoaDonNhap");
soluong++;
}
}
phatsinhno = phatsinhco = 0;
// Khách Hàng Trả Lại
for (int i = 0; i < kh.Length; i++)
{
string month1 = kh[i].NgayNhap.Month.ToString();
string year1 = kh[i].NgayNhap.Year.ToString();
double a = Convert.ToDouble(kh[i].TienBoiThuong);
double b = double.Parse(kh[i].ThanhToanNgay);
if (b > a)
{
b = a;
}
double a1 = b;
if (month == month1 && year == year1)
{
phatsinhco = a1;
string ngaylap = new Common.Utilities().XuLy(2, kh[i].NgayNhap.ToShortDateString());
hienthi[soluong] = new Entities.SoQuy(ngaylap, kh[i].MaKhachHangTraLai, "1111", "Tiền mặt việt nam",
Format(phatsinhno), Format(phatsinhco), kh[i].GhiChu, "KHTL");
soluong++;
}
}
phatsinhno = phatsinhco = 0;
// Trả Lại Nhà Cung Cấp
for (int i = 0; i < tl.Length; i++)
{
string month1 = tl[i].Ngaytra.Month.ToString();
string year1 = tl[i].Ngaytra.Year.ToString();
double a = Convert.ToDouble(tl[i].TienBoiThuong);
double b = Convert.ToDouble(tl[i].ThanhToanNgay);
if (b > a)
{
b = a;
}
double a1 = b;
if (month == month1 && year == year1)
{
phatsinhno = a1;
string ngaylap = new Common.Utilities().XuLy(2, tl[i].Ngaytra.ToShortDateString());
hienthi[soluong] = new Entities.SoQuy(ngaylap, tl[i].MaHDTraLaiNCC, "1111", "Tiền mặt việt nam",
Format(phatsinhno), Format(phatsinhco), tl[i].GhiChu, "TLNCC");
soluong++;
}
}
phatsinhno = phatsinhco = 0;
// Phiếu thanh toán nhà cung cấp
for (int i = 0; i < pttncc.Length; i++)
{
string month1 = pttncc[i].NgayLap.Month.ToString();
string year1 = pttncc[i].NgayLap.Year.ToString();
//double a1 = double.Parse(pttncc[i].NoHienThoi);
double a1 = TongThanhToanCuaPhieuThanhToan("NCC", pttncc[i].MaPhieuTTNCC);
if (month == month1 && year == year1)
{
phatsinhco = a1;
string ngaylap = new Common.Utilities().XuLy(2, pttncc[i].NgayLap.ToShortDateString());
hienthi[soluong] = new Entities.SoQuy(ngaylap, pttncc[i].MaPhieuTTNCC, "1111", "Tiền mặt việt nam",
Format(phatsinhno), Format(phatsinhco), pttncc[i].GhiChu, "PTTNCC");
soluong++;
}
}
phatsinhno = phatsinhco = 0;
// Phiếu thanh toán khách hàng
for (int i = 0; i < pttkh.Length; i++)
{
string month1 = pttkh[i].NgayLap.Month.ToString();
string year1 = pttkh[i].NgayLap.Year.ToString();
//double a1 = double.Parse(pttkh[i].NoHienThoi);
double a1 = TongThanhToanCuaPhieuThanhToan("KH", pttkh[i].MaPhieuTTCuaKH);
if (month == month1 && year == year1)
{
phatsinhno = a1;
string ngaylap = new Common.Utilities().XuLy(2, pttkh[i].NgayLap.ToShortDateString());
hienthi[soluong] = new Entities.SoQuy(ngaylap, pttkh[i].MaPhieuTTCuaKH, "1111", "Tiền mặt việt nam",
Format(phatsinhno), Format(phatsinhco), pttkh[i].GhiChu, "PTTKH");
soluong++;
}
}
phatsinhno = phatsinhco = 0;
List <Entities.SoQuy> l = new List <Entities.SoQuy>();
foreach (Entities.SoQuy item in hienthi)
{
if (item != null)
{
l.Add(item);
}
}
hienthi = l.ToArray();
//Tính toán
if (hienthi.Length == 0)
{//Chỉ có số dư đầu kỳ
if (sddk == 0 && sdck == 0)
{
soquy = new Entities.SoQuy[0];
}
else
{
soquy = new Entities.SoQuy[1];
soquy[0] = new Entities.SoQuy("0", "0", "Tổng Cộng", Format(sddk), Format(sdck));
}
}
else
{
soquy = new Entities.SoQuy[2];
for (int i = 0; i < hienthi.Length; i++)
{
phatsinhco += Convert.ToDouble(hienthi[i].PhatSinhCo);
phatsinhno += Convert.ToDouble(hienthi[i].PhatSinhNo);
sdck = sddk + phatsinhno - phatsinhco;
soquy[0] = new Entities.SoQuy("1111", "Tiền mặt việt nam", Format(sddk), Format(phatsinhno), Format(phatsinhco), Format(sdck), "TongHop");
}
if (phatsinhno == 0 && phatsinhco == 0)
{
sdck = sddk + phatsinhno - phatsinhco;
soquy[1] = new Entities.SoQuy("0", "0", "Tổng Cộng", Format(sddk), Format(sdck));
}
else if (phatsinhno == 0 && phatsinhco != 0)
{
soquy[1] = new Entities.SoQuy("0", Format(phatsinhco), "Tổng Cộng", Format(sddk), Format(sdck));
}
else if (phatsinhno != 0 && phatsinhco == 0)
{
soquy[1] = new Entities.SoQuy(Format(phatsinhno), "0", "Tổng Cộng", Format(sddk), Format(sdck));
}
else if (phatsinhno != 0 && phatsinhco != 0)
{
soquy[1] = new Entities.SoQuy(Format(phatsinhno), Format(phatsinhco), "Tổng Cộng", Format(sddk), Format(sdck));
}
a = soquy[1].DuCuoiKy;
}
dtgvsoquy.DataSource = soquy;
}
catch
{
dtgvsoquy.DataSource = new Entities.SoQuy[0];
}
finally
{
fix();
}
}
public void TongTienNhanVien(DateTime batdau, DateTime ketthuc)
{
try
{
int sotang = 0;
for (int i = 0; i < nv.Length; i++)
{
for (int j = 0; j < bcnv.Length; j++)
{
DateTime hientai = bcnv[j].NgayBan;
if (hientai.Date >= batdau.Date && hientai.Date <= ketthuc.Date && bcnv[j].MaNhanVien == nv[i].MaNhanVien)
{
sotang++;
}
}
}
Entities.BCDTTheoNhanVien[] bcdt = new Entities.BCDTTheoNhanVien[sotang];
sotang = 0;
double tongtien;
for (int i = 0; i < nv.Length; i++)
{
tongtien = 0;
for (int j = 0; j < bcnv.Length; j++)
{
DateTime hientai = bcnv[j].NgayBan;
if (hientai.Date >= batdau.Date && hientai.Date <= ketthuc.Date && bcnv[j].MaNhanVien == nv[i].MaNhanVien)
{
List <double> bientam = TienIch.TinhDoanhThu(bcnv[j].TongTienThanhToan, bcnv[j].GiaTriThe, bcnv[j].GiaTriTheGiaTri);
tongtien += bientam[3]; //bcnv[j].ThanhToanNgay
}
}
if (tongtien != 0)
{
bcdt[sotang] = new Entities.BCDTTheoNhanVien("", nv[i].MaNhanVien, nv[i].TenNhanVien, new Common.Utilities().FormatMoney(tongtien));
sotang++;
}
}
hienthi = new Entities.BCDTTheoNhanVien[sotang];
for (int i = 0; i < hienthi.Length; i++)
{
hienthi[i] = bcdt[i];
}
//////////////////////////////////////////////Mrk FIX
List <Entities.BCDTTheoNhanVien> tem0 = new List <Entities.BCDTTheoNhanVien>();
double tong0 = 0;
for (int i = 0; i < bcdt.Length; i++)
{
if (bcdt[i] == null)
{
break;
}
tong0 += double.Parse(bcdt[i].TongTien.Replace(",", ""));
tem0.Add(bcdt[i]);
}
Entities.BCDTTheoNhanVien tem1 = new Entities.BCDTTheoNhanVien();
tem1.TongTien = new Common.Utilities().FormatMoney(tong0);
tem1.TenNhanVien = "Tổng Cộng: ";
tem0.Add(tem1);
//foreach (Entities.BCDTTheoNhanVien item in tem0)
//{
// hienthi[i] = item;
//}
//////////////////////////////////////////////////////
//dtgvhienthi.DataSource = hienthi;
if (tem0.Count == 1 && tem0[0].TenNhanVien.Equals("Tổng Cộng: "))
{
//tem0.Remove(tem0[0]);
tem0 = new List <Entities.BCDTTheoNhanVien>();
}
else if (tem0.Count > 1)
{
foreach (Entities.BCDTTheoNhanVien item in tem0)
{
if (item.TenNhanVien.Equals("Tổng Cộng: "))
{
item.GiaTriThe = 0;
}
}
}
dtgvhienthi.DataSource = tem0.ToArray();
if (bcdt.Length > 0)
{
tsslexcel.Enabled = tsslPdf.Enabled = tsslWord.Enabled = tsslchitiet.Enabled = true;
}
else
{
tsslexcel.Enabled = tsslPdf.Enabled = tsslWord.Enabled = tsslchitiet.Enabled = false;
}
fix();
}
catch
{
}
}