public void TongTienNhanVien()
{
try
{
List <Entities.BCLaiLoChiTiet> ctLaiLoList = new List <Entities.BCLaiLoChiTiet>();
nam = int.Parse(cbbnam.Text);
thang = int.Parse(cbbthang.Text);
for (int i = 0; i < hdbanhang.Length; i++)
{
int namht = hdbanhang[i].NgayBan.Year;
int thanght = hdbanhang[i].NgayBan.Month;
Entities.BCLaiLoChiTiet laiLoChiTiet = new Entities.BCLaiLoChiTiet();
if (nam == namht && thanght == thang)
{
laiLoChiTiet.DoanhSo = (double.Parse(hdbanhang[i].TongTienThanhToan) - double.Parse(hdbanhang[i].ThueGTGT)).ToString();
laiLoChiTiet.Ngay = hdbanhang[i].NgayBan.ToShortDateString();
double giaVon = 0;
for (int j = 0; j < chitiethdbanhang.Length; j++)
{
if (hdbanhang[i].MaHDBanHang.Equals(chitiethdbanhang[j].MaHDBanHang))
{
if (LayGiaVonHangHoa(chitiethdbanhang[j]) == 0)
{
if (LayGiaVonGoiHang(chitiethdbanhang[j], goihang) == 0)
{
giaVon = 0;
}
else
{
giaVon += LayGiaVonGoiHang(chitiethdbanhang[j], goihang);
}
}
else
{
giaVon += LayGiaVonHangHoa(chitiethdbanhang[j]);
}
}
}
laiLoChiTiet.GiaVon = giaVon.ToString();
laiLoChiTiet.LaiGop = (double.Parse(laiLoChiTiet.DoanhSo) - double.Parse(laiLoChiTiet.GiaVon)).ToString();
ctLaiLoList.Add(laiLoChiTiet);
}
}
List <string> Ltem = new List <string>();
foreach (Entities.BCLaiLoChiTiet item in ctLaiLoList)
{
if (!Ltem.Contains(DateTime.Parse(item.Ngay).ToShortDateString()))
{
Ltem.Add(DateTime.Parse(item.Ngay).ToShortDateString());
}
}
List <Entities.BCLaiLoChiTiet> Fixhienthi = new List <Entities.BCLaiLoChiTiet>();
int ii = 0;
foreach (string item1 in Ltem)
{
Entities.BCLaiLoChiTiet bientam = new Entities.BCLaiLoChiTiet();
bientam.HanhDong = ii.ToString();
ii++;
double doanhso = 0; double giavon = 0; double laigop = 0;
foreach (Entities.BCLaiLoChiTiet item2 in ctLaiLoList)
{
if (item2.Ngay.Equals(item1))
{
bientam.Ngay = item2.Ngay;
doanhso += double.Parse(item2.DoanhSo);
giavon += double.Parse(item2.GiaVon);
laigop += double.Parse(item2.LaiGop);
}
}
bientam.DoanhSo = new Common.Utilities().FormatMoney(doanhso);
bientam.GiaVon = new Common.Utilities().FormatMoney(giavon);
bientam.LaiGop = new Common.Utilities().FormatMoney(laigop);
Fixhienthi.Add(bientam);
}
/// Lay Datasour cho BC.
foreach (Entities.BCLaiLoChiTiet item in (Entities.BCLaiLoChiTiet[])Fixhienthi.ToArray())
{
try
{
DateTime ngay = DateTime.Parse(DateTime.Parse(item.Ngay).ToShortDateString());
double doanhSo = double.Parse(item.DoanhSo);
double giaVon = double.Parse(item.GiaVon);
double laiGop = double.Parse(item.LaiGop);
Entities.BCLaiLo laiLo = new Entities.BCLaiLo(ngay, doanhSo, giaVon, laiGop);
hienthibaocao.Add(laiLo);
}
catch (Exception)
{ }
}
Entities.BCLaiLoChiTiet tongCong = new Entities.BCLaiLoChiTiet();
double tongDoanhSo = 0;
double tongGiaVon = 0;
double tongLaiGop = 0;
foreach (Entities.BCLaiLoChiTiet item in (Entities.BCLaiLoChiTiet[])Fixhienthi.ToArray())
{
tongDoanhSo += double.Parse(item.DoanhSo);
tongGiaVon += double.Parse(item.GiaVon);
tongLaiGop += double.Parse(item.LaiGop);
}
tongCong.DoanhSo = new Common.Utilities().FormatMoney(tongDoanhSo);
tongCong.GiaVon = new Common.Utilities().FormatMoney(tongGiaVon);
tongCong.LaiGop = new Common.Utilities().FormatMoney(tongLaiGop);
tongCong.Ngay = "Tổng Cộng:";
Fixhienthi.Add(tongCong);
dtgvhienthi.DataSource = (Entities.BCLaiLoChiTiet[])Fixhienthi.ToArray();
if (Fixhienthi.ToArray().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
{
List<Entities.BCLaiLoChiTiet> ctLaiLoList = new List<Entities.BCLaiLoChiTiet>();
nam = int.Parse(cbbnam.Text);
thang = int.Parse(cbbthang.Text);
for (int i = 0; i < hdbanhang.Length; i++)
{
int namht = hdbanhang[i].NgayBan.Year;
int thanght = hdbanhang[i].NgayBan.Month;
Entities.BCLaiLoChiTiet laiLoChiTiet = new Entities.BCLaiLoChiTiet();
if (nam == namht && thanght == thang)
{
laiLoChiTiet.DoanhSo = (double.Parse(hdbanhang[i].TongTienThanhToan) - double.Parse(hdbanhang[i].ThueGTGT)).ToString();
laiLoChiTiet.Ngay = hdbanhang[i].NgayBan.ToShortDateString();
double giaVon = 0;
for (int j = 0; j < chitiethdbanhang.Length; j++)
{
if (hdbanhang[i].MaHDBanHang.Equals(chitiethdbanhang[j].MaHDBanHang))
{
if (LayGiaVonHangHoa(chitiethdbanhang[j]) == 0)
{
if (LayGiaVonGoiHang(chitiethdbanhang[j], goihang) == 0)
{
giaVon = 0;
}
else
{
giaVon += LayGiaVonGoiHang(chitiethdbanhang[j], goihang);
}
}
else
{
giaVon += LayGiaVonHangHoa(chitiethdbanhang[j]);
}
}
}
laiLoChiTiet.GiaVon = giaVon.ToString();
laiLoChiTiet.LaiGop = (double.Parse(laiLoChiTiet.DoanhSo) - double.Parse(laiLoChiTiet.GiaVon)).ToString();
ctLaiLoList.Add(laiLoChiTiet);
}
}
List<string> Ltem = new List<string>();
foreach (Entities.BCLaiLoChiTiet item in ctLaiLoList)
{
if (!Ltem.Contains(DateTime.Parse(item.Ngay).ToShortDateString()))
{
Ltem.Add(DateTime.Parse(item.Ngay).ToShortDateString());
}
}
List<Entities.BCLaiLoChiTiet> Fixhienthi = new List<Entities.BCLaiLoChiTiet>();
int ii = 0;
foreach (string item1 in Ltem)
{
Entities.BCLaiLoChiTiet bientam = new Entities.BCLaiLoChiTiet();
bientam.HanhDong = ii.ToString();
ii++;
double doanhso = 0; double giavon = 0; double laigop = 0;
foreach (Entities.BCLaiLoChiTiet item2 in ctLaiLoList)
{
if (item2.Ngay.Equals(item1))
{
bientam.Ngay = item2.Ngay;
doanhso += double.Parse(item2.DoanhSo);
giavon += double.Parse(item2.GiaVon);
laigop += double.Parse(item2.LaiGop);
}
}
bientam.DoanhSo = new Common.Utilities().FormatMoney(doanhso);
bientam.GiaVon = new Common.Utilities().FormatMoney(giavon);
bientam.LaiGop = new Common.Utilities().FormatMoney(laigop);
Fixhienthi.Add(bientam);
}
/// Lay Datasour cho BC.
foreach (Entities.BCLaiLoChiTiet item in (Entities.BCLaiLoChiTiet[])Fixhienthi.ToArray())
{
try
{
DateTime ngay = DateTime.Parse(DateTime.Parse(item.Ngay).ToShortDateString());
double doanhSo = double.Parse(item.DoanhSo);
double giaVon = double.Parse(item.GiaVon);
double laiGop = double.Parse(item.LaiGop);
Entities.BCLaiLo laiLo = new Entities.BCLaiLo(ngay, doanhSo, giaVon, laiGop);
hienthibaocao.Add(laiLo);
}
catch (Exception)
{ }
}
Entities.BCLaiLoChiTiet tongCong = new Entities.BCLaiLoChiTiet();
double tongDoanhSo = 0;
double tongGiaVon = 0;
double tongLaiGop = 0;
foreach (Entities.BCLaiLoChiTiet item in (Entities.BCLaiLoChiTiet[])Fixhienthi.ToArray())
{
tongDoanhSo += double.Parse(item.DoanhSo);
tongGiaVon += double.Parse(item.GiaVon);
tongLaiGop += double.Parse(item.LaiGop);
}
tongCong.DoanhSo = new Common.Utilities().FormatMoney(tongDoanhSo);
tongCong.GiaVon = new Common.Utilities().FormatMoney(tongGiaVon);
tongCong.LaiGop = new Common.Utilities().FormatMoney(tongLaiGop);
tongCong.Ngay = "Tổng Cộng:";
Fixhienthi.Add(tongCong);
dtgvhienthi.DataSource = (Entities.BCLaiLoChiTiet[])Fixhienthi.ToArray();
if (Fixhienthi.ToArray().Length > 0)
{
tsslexcel.Enabled = tsslPdf.Enabled = tsslWord.Enabled = tsslchitiet.Enabled = true;
}
else
{
tsslexcel.Enabled = tsslPdf.Enabled = tsslWord.Enabled = tsslchitiet.Enabled = false;
}
}
catch
{
}
finally
{
fix();
}
}