private void tsslexcel_Click(object sender, EventArgs e)
{
this.Enabled = false;
try
{
saveFileDialog1.Filter = "Excel |*.xls"; saveFileDialog1.FileName = "";
if (saveFileDialog1.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
///////////////////////////////MRK FIX Hiển thị
List <Entities.BCKhachHangTraHang> tem0 = ((Entities.BCKhachHangTraHang[])dtgvhienthi.DataSource).ToList();
//Entities.BCKhachHangTraHang dau = new Entities.BCKhachHangTraHang();
//dau = tem0[0];
Entities.BCKhachHangTraHang cuoi = new Entities.BCKhachHangTraHang();
cuoi = tem0[tem0.Count - 1];
//tem0.Remove(dau);
tem0.Remove(cuoi);
////////////////////////////////////////////////
hienthibaocao = tem0.ToArray();
//hienthibaocao = (Entities.BCKhachHangTraHang[])dtgvhienthi.DataSource;
frmBaoCaorpt a = new frmBaoCaorpt(hienthibaocao, truoc, sau, saveFileDialog1.FileName, "Excel");
}
}
catch
{
}
finally
{
this.Enabled = true;
}
}
private void tsslchitiet_Click(object sender, EventArgs e)
{
this.Enabled = false;
try
{
///////////////////////////////MRK FIX Hiển thị
List <Entities.BCKhachHangTraHang> tem0 = ((Entities.BCKhachHangTraHang[])dtgvhienthi.DataSource).ToList();
//Entities.BCKhachHangTraHang dau = new Entities.BCKhachHangTraHang();
//dau = tem0[0];
Entities.BCKhachHangTraHang cuoi = new Entities.BCKhachHangTraHang();
cuoi = tem0[tem0.Count - 1];
//tem0.Remove(dau);
tem0.Remove(cuoi);
////////////////////////////////////////////////
hienthibaocao = tem0.ToArray();
//hienthibaocao = (Entities.BCKhachHangTraHang[])dtgvhienthi.DataSource;
frmBaoCaorpt a = new frmBaoCaorpt(hienthibaocao, truoc, sau);
a.ShowDialog();
}
catch
{
}
finally
{
this.Enabled = true;
}
}
private void rdbtimkiem3_CheckedChanged(object sender, EventArgs e)
{
try
{
if (hienthi == null)
{
dtgvhienthi.DataSource = new Entities.BCKhachHangTraHang[0];
return;
}
///////////////////////////////MRK FIX
List <Entities.BCKhachHangTraHang> tem0 = new List <Entities.BCKhachHangTraHang>();
double tong0 = 0;
double tong1 = 0;
foreach (Entities.BCKhachHangTraHang item in hienthi)
{
tong0 += double.Parse(item.SoLuong);
tong1 += item.ThanhTien;
tem0.Add(item);
}
Entities.BCKhachHangTraHang tem1 = new Entities.BCKhachHangTraHang();
tem1.MaChungTu = "Tổng: ";
tem1.SoLuong = tong0.ToString();
tem1.ThanhTien = tong1;
tem0.Add(tem1);
//////////////////////////////////////
//dtgvhienthi.DataSource = hienthi;
dtgvhienthi.DataSource = tem0.ToArray();
}
catch
{
}
finally
{
fix();
}
}
public void TongTienNhanVien()
{
try
{
List<Entities.BCKhachHangTraHang> temp = new List<Entities.BCKhachHangTraHang>();
foreach (Entities.KhachHangTraLai item in khachhangtralai)
{
if (truoc.Date <= item.NgayNhap && item.NgayNhap <= sau.Date)//item.NgayNhap.Date >= truoc.Date && item.NgayNhap.Date <= sau.Date
{
foreach (Entities.ChiTietKhachHangTraLai item1 in chitietkhachhangtralai)
{
if (item.MaKhachHangTraLai == item1.MaKhachHangTraLai)
{
Entities.BCKhachHangTraHang bc = new Entities.BCKhachHangTraHang();
bc.MaChungTu = item.MaKhachHangTraLai;
bc.MaKhachHang = item.MaKhachHang;
bc.NgayChungTu = item.NgayNhap.ToString("dd/MM/yyyy");
bc.SoLuong = item1.SoLuong.ToString();
bc.DonGia = item1.DonGia;
bc.TenHang = item1.TenHangHoa;
bc.Thue = item1.Thue;
bc.TenKhachHang = item.TenKhachHang;
double tienhang = double.Parse(bc.SoLuong) * double.Parse(bc.DonGia);
double thanhtien = tienhang + (double.Parse(bc.Thue) * tienhang) / 100;
bc.ThanhTien = thanhtien;
temp.Add(bc);
}
}
}
}
hienthi = (Entities.BCKhachHangTraHang[])temp.ToArray();
///////////////////////////////MRK FIX
List<Entities.BCKhachHangTraHang> tem0 = new List<Entities.BCKhachHangTraHang>();
double tong0 = 0;
double tong1 = 0;
foreach (Entities.BCKhachHangTraHang item in hienthi)
{
tong0 += double.Parse(item.SoLuong);
tong1 += item.ThanhTien;
tem0.Add(item);
}
Entities.BCKhachHangTraHang tem1 = new Entities.BCKhachHangTraHang();
tem1.MaChungTu = "Tổng: ";
tem1.SoLuong = tong0.ToString();
tem1.ThanhTien = tong1;
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();
}
}
private void txttimkiem_TextChanged(object sender, EventArgs e)
{
try
{
if (rdbtimkiem3.Checked == true)
{
return;
}
if (txttimkiem.Text.Length == 0)
{
dtgvhienthi.DataSource = new Entities.BCKhachHangTraHang[0];
return;
}
int soluong = 0;
if (hienthi != null)
{
if (rdbtimkiem1.Checked == true)
{
for (int i = 0; i < hienthi.Length; i++)
{
int kiemtra = hienthi[i].MaKhachHang.ToString().ToUpper().IndexOf(txttimkiem.Text.ToUpper());
if (kiemtra >= 0)
{
soluong++;
}
}
if (soluong == 0)
{
dtgvhienthi.DataSource = new Entities.BCKhachHangTraHang[0];
return;
}
Entities.BCKhachHangTraHang[] hienthitheoid = new Entities.BCKhachHangTraHang[soluong];
soluong = 0;
for (int i = 0; i < hienthi.Length; i++)
{
int kiemtra = hienthi[i].MaKhachHang.ToString().ToUpper().IndexOf(txttimkiem.Text.ToUpper());
if (kiemtra >= 0)
{
hienthitheoid[soluong] = hienthi[i];
soluong++;
}
}
///////////////////////////////MRK FIX
List<Entities.BCKhachHangTraHang> tem0 = new List<Entities.BCKhachHangTraHang>();
double tong0 = 0;
double tong1 = 0;
foreach (Entities.BCKhachHangTraHang item in hienthitheoid)
{
tong0 += double.Parse(item.SoLuong);
tong1 += item.ThanhTien;
tem0.Add(item);
}
Entities.BCKhachHangTraHang tem1 = new Entities.BCKhachHangTraHang();
tem1.MaChungTu = "Tổng: ";
tem1.SoLuong = tong0.ToString();
tem1.ThanhTien = tong1;
tem0.Add(tem1);
//////////////////////////////////////
//dtgvhienthi.DataSource = hienthi;
dtgvhienthi.DataSource = tem0.ToArray();
}
if (dtgvhienthi.RowCount > 0)
{
tsslexcel.Enabled = tsslPdf.Enabled = tsslWord.Enabled = tsslchitiet.Enabled = true;
}
else
{
tsslexcel.Enabled = tsslPdf.Enabled = tsslWord.Enabled = tsslchitiet.Enabled = false;
}
}
}
finally
{
fix();
}
}
private void tsslWord_Click(object sender, EventArgs e)
{
this.Enabled = false;
try
{
saveFileDialog1.Filter = "Word |*.doc"; saveFileDialog1.FileName = "";
if (saveFileDialog1.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
///////////////////////////////MRK FIX Hiển thị
List<Entities.BCKhachHangTraHang> tem0 = ((Entities.BCKhachHangTraHang[])dtgvhienthi.DataSource).ToList();
//Entities.BCKhachHangTraHang dau = new Entities.BCKhachHangTraHang();
//dau = tem0[0];
Entities.BCKhachHangTraHang cuoi = new Entities.BCKhachHangTraHang();
cuoi = tem0[tem0.Count - 1];
//tem0.Remove(dau);
tem0.Remove(cuoi);
////////////////////////////////////////////////
hienthibaocao = tem0.ToArray();
//hienthibaocao = (Entities.BCKhachHangTraHang[])dtgvhienthi.DataSource;
frmBaoCaorpt a = new frmBaoCaorpt(hienthibaocao, truoc, sau, saveFileDialog1.FileName, "Word");
}
}
catch
{
}
finally
{
this.Enabled = true;
}
}
private void tsslchitiet_Click(object sender, EventArgs e)
{
this.Enabled = false;
try
{
///////////////////////////////MRK FIX Hiển thị
List<Entities.BCKhachHangTraHang> tem0 = ((Entities.BCKhachHangTraHang[])dtgvhienthi.DataSource).ToList();
//Entities.BCKhachHangTraHang dau = new Entities.BCKhachHangTraHang();
//dau = tem0[0];
Entities.BCKhachHangTraHang cuoi = new Entities.BCKhachHangTraHang();
cuoi = tem0[tem0.Count - 1];
//tem0.Remove(dau);
tem0.Remove(cuoi);
////////////////////////////////////////////////
hienthibaocao = tem0.ToArray();
//hienthibaocao = (Entities.BCKhachHangTraHang[])dtgvhienthi.DataSource;
frmBaoCaorpt a = new frmBaoCaorpt(hienthibaocao, truoc, sau);
a.ShowDialog();
}
catch
{
}
finally
{
this.Enabled = true;
}
}
private void rdbtimkiem3_CheckedChanged(object sender, EventArgs e)
{
try
{
if (hienthi == null)
{
dtgvhienthi.DataSource = new Entities.BCKhachHangTraHang[0];
return;
}
///////////////////////////////MRK FIX
List<Entities.BCKhachHangTraHang> tem0 = new List<Entities.BCKhachHangTraHang>();
double tong0 = 0;
double tong1 = 0;
foreach (Entities.BCKhachHangTraHang item in hienthi)
{
tong0 += double.Parse(item.SoLuong);
tong1 += item.ThanhTien;
tem0.Add(item);
}
Entities.BCKhachHangTraHang tem1 = new Entities.BCKhachHangTraHang();
tem1.MaChungTu = "Tổng: ";
tem1.SoLuong = tong0.ToString();
tem1.ThanhTien = tong1;
tem0.Add(tem1);
//////////////////////////////////////
//dtgvhienthi.DataSource = hienthi;
dtgvhienthi.DataSource = tem0.ToArray();
}
catch
{
}
finally
{
fix();
}
}
public void TongTienNhanVien()
{
try
{
List <Entities.BCKhachHangTraHang> temp = new List <Entities.BCKhachHangTraHang>();
foreach (Entities.KhachHangTraLai item in khachhangtralai)
{
if (truoc.Date <= item.NgayNhap && item.NgayNhap <= sau.Date)//item.NgayNhap.Date >= truoc.Date && item.NgayNhap.Date <= sau.Date
{
foreach (Entities.ChiTietKhachHangTraLai item1 in chitietkhachhangtralai)
{
if (item.MaKhachHangTraLai == item1.MaKhachHangTraLai)
{
Entities.BCKhachHangTraHang bc = new Entities.BCKhachHangTraHang();
bc.MaChungTu = item.MaKhachHangTraLai;
bc.MaKhachHang = item.MaKhachHang;
bc.NgayChungTu = item.NgayNhap.ToString("dd/MM/yyyy");
bc.SoLuong = item1.SoLuong.ToString();
bc.DonGia = item1.DonGia;
bc.TenHang = item1.TenHangHoa;
bc.Thue = item1.Thue;
bc.TenKhachHang = item.TenKhachHang;
double tienhang = double.Parse(bc.SoLuong) * double.Parse(bc.DonGia);
double thanhtien = tienhang + (double.Parse(bc.Thue) * tienhang) / 100;
bc.ThanhTien = thanhtien;
temp.Add(bc);
}
}
}
}
hienthi = (Entities.BCKhachHangTraHang[])temp.ToArray();
///////////////////////////////MRK FIX
List <Entities.BCKhachHangTraHang> tem0 = new List <Entities.BCKhachHangTraHang>();
double tong0 = 0;
double tong1 = 0;
foreach (Entities.BCKhachHangTraHang item in hienthi)
{
tong0 += double.Parse(item.SoLuong);
tong1 += item.ThanhTien;
tem0.Add(item);
}
Entities.BCKhachHangTraHang tem1 = new Entities.BCKhachHangTraHang();
tem1.MaChungTu = "Tổng: ";
tem1.SoLuong = tong0.ToString();
tem1.ThanhTien = tong1;
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();
}
}
private void txttimkiem_TextChanged(object sender, EventArgs e)
{
try
{
if (rdbtimkiem3.Checked == true)
{
return;
}
if (txttimkiem.Text.Length == 0)
{
dtgvhienthi.DataSource = new Entities.BCKhachHangTraHang[0];
return;
}
int soluong = 0;
if (hienthi != null)
{
if (rdbtimkiem1.Checked == true)
{
for (int i = 0; i < hienthi.Length; i++)
{
int kiemtra = hienthi[i].MaKhachHang.ToString().ToUpper().IndexOf(txttimkiem.Text.ToUpper());
if (kiemtra >= 0)
{
soluong++;
}
}
if (soluong == 0)
{
dtgvhienthi.DataSource = new Entities.BCKhachHangTraHang[0];
return;
}
Entities.BCKhachHangTraHang[] hienthitheoid = new Entities.BCKhachHangTraHang[soluong];
soluong = 0;
for (int i = 0; i < hienthi.Length; i++)
{
int kiemtra = hienthi[i].MaKhachHang.ToString().ToUpper().IndexOf(txttimkiem.Text.ToUpper());
if (kiemtra >= 0)
{
hienthitheoid[soluong] = hienthi[i];
soluong++;
}
}
///////////////////////////////MRK FIX
List <Entities.BCKhachHangTraHang> tem0 = new List <Entities.BCKhachHangTraHang>();
double tong0 = 0;
double tong1 = 0;
foreach (Entities.BCKhachHangTraHang item in hienthitheoid)
{
tong0 += double.Parse(item.SoLuong);
tong1 += item.ThanhTien;
tem0.Add(item);
}
Entities.BCKhachHangTraHang tem1 = new Entities.BCKhachHangTraHang();
tem1.MaChungTu = "Tổng: ";
tem1.SoLuong = tong0.ToString();
tem1.ThanhTien = tong1;
tem0.Add(tem1);
//////////////////////////////////////
//dtgvhienthi.DataSource = hienthi;
dtgvhienthi.DataSource = tem0.ToArray();
}
if (dtgvhienthi.RowCount > 0)
{
tsslexcel.Enabled = tsslPdf.Enabled = tsslWord.Enabled = tsslchitiet.Enabled = true;
}
else
{
tsslexcel.Enabled = tsslPdf.Enabled = tsslWord.Enabled = tsslchitiet.Enabled = false;
}
}
}
finally
{
fix();
}
}
