private void tsslchitiet_Click(object sender, EventArgs e)
{
this.Enabled = false;
try
{
///////////////////////////////MRK FIX Hiển thị
List <Entities.BCTraLaiNCC> tem0 = ((Entities.BCTraLaiNCC[])dtgvhienthi.DataSource).ToList();
//Entities.BCTraLaiNCC dau = new Entities.BCTraLaiNCC();
//dau = tem0[0];
Entities.BCTraLaiNCC cuoi = new Entities.BCTraLaiNCC();
cuoi = tem0[tem0.Count - 1];
//tem0.Remove(dau);
tem0.Remove(cuoi);
////////////////////////////////////////////////
hienthibaocao = tem0.ToArray();
//hienthibaocao = (Entities.BCTraLaiNCC[])dtgvhienthi.DataSource;
frmBaoCaorpt a = new frmBaoCaorpt(hienthibaocao, truoc, sau);
a.ShowDialog();
}
catch { }
finally
{
this.Enabled = true;
}
}
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.BCTraLaiNCC> tem0 = ((Entities.BCTraLaiNCC[])dtgvhienthi.DataSource).ToList();
//Entities.BCTraLaiNCC dau = new Entities.BCTraLaiNCC();
//dau = tem0[0];
Entities.BCTraLaiNCC cuoi = new Entities.BCTraLaiNCC();
cuoi = tem0[tem0.Count - 1];
//tem0.Remove(dau);
tem0.Remove(cuoi);
////////////////////////////////////////////////
hienthibaocao = tem0.ToArray();
//hienthibaocao = (Entities.BCTraLaiNCC[])dtgvhienthi.DataSource;
frmBaoCaorpt a = new frmBaoCaorpt(hienthibaocao, truoc, sau, saveFileDialog1.FileName, "Excel");
}
}
catch
{
}
finally
{
this.Enabled = true;
}
}
private void rdbtimkiem3_CheckedChanged(object sender, EventArgs e)
{
try
{
if (hienthi == null)
{
dtgvhienthi.DataSource = new Entities.BCTraLaiNCC[0];
return;
}
///////////////////////////////MRK FIX
List <Entities.BCTraLaiNCC> tem0 = new List <Entities.BCTraLaiNCC>();
double tong0 = 0;
double tong1 = 0;
foreach (Entities.BCTraLaiNCC item in hienthi)
{
tong0 += double.Parse(item.SoLuong);
tong1 += item.ThanhTien;
tem0.Add(item);
}
Entities.BCTraLaiNCC tem1 = new Entities.BCTraLaiNCC();
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.BCTraLaiNCC> temp = new List <Entities.BCTraLaiNCC>();
foreach (Entities.TraLaiNCC item in tralaincc)
{
if (item.Ngaytra.Date >= truoc.Date && item.Ngaytra.Date <= sau.Date && item.MaKho == makho)
{
foreach (Entities.ChiTietTraLaiNhaCungCap item1 in chitiettralaincc)
{
if (item.MaHDTraLaiNCC == item1.MaHDTraLaiNCC)
{
Entities.BCTraLaiNCC bc = new Entities.BCTraLaiNCC();
bc.ChietKhau = item1.PhanTramChietKhau;
foreach (Entities.HangHoa item2 in hanghoa)
{
if (item1.MaHangHoa == item2.MaHangHoa)
{
bc.DonGia = Format(double.Parse(item2.GiaNhap));
bool kt = false;
foreach (Entities.Thue item3 in thue)
{
if (item2.MaThueGiaTriGiaTang == item3.MaThue)
{
bc.Thue = item3.GiaTriThue;
bc.TenHang = item2.TenHangHoa;
kt = true;
break;
}
}
if (!kt)
{
bc.Thue = "0";
}
break;
}
}
bc.MaChungTu = item.MaHDTraLaiNCC;
bc.NgayChungTu = item.Ngaytra.ToString("dd/MM/yyyy");
bc.SoLuong = item1.SoLuong.ToString();
bc.MaNCC = item.MaNCC;
bc.TenNCC = item.TenNCC;
double dongiadachietkhau = (double.Parse(bc.DonGia) - ((double.Parse(bc.DonGia) * double.Parse(bc.ChietKhau)) / 100));
double dongiabaogomthue = dongiadachietkhau + ((dongiadachietkhau * double.Parse(bc.Thue)) / 100);
bc.ThanhTien = dongiabaogomthue * double.Parse(bc.SoLuong);
temp.Add(bc);
}
}
}
}
hienthi = (Entities.BCTraLaiNCC[])temp.ToArray();
///////////////////////////////MRK FIX
List <Entities.BCTraLaiNCC> tem0 = new List <Entities.BCTraLaiNCC>();
double tong0 = 0;
double tong1 = 0;
foreach (Entities.BCTraLaiNCC item in hienthi)
{
tong0 += double.Parse(item.SoLuong);
tong1 += item.ThanhTien;
tem0.Add(item);
}
Entities.BCTraLaiNCC tem1 = new Entities.BCTraLaiNCC();
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.BCTraLaiNCC[0];
return;
}
int soluong = 0;
if (hienthi != null)
{
if (rdbtimkiem1.Checked == true)
{
for (int i = 0; i < hienthi.Length; i++)
{
int kiemtra = hienthi[i].MaNCC.ToString().ToUpper().IndexOf(txttimkiem.Text.ToUpper());
if (kiemtra >= 0)
{
soluong++;
}
}
if (soluong == 0)
{
dtgvhienthi.DataSource = new Entities.BCTraLaiNCC[0];
return;
}
Entities.BCTraLaiNCC[] hienthitheoid = new Entities.BCTraLaiNCC[soluong];
soluong = 0;
for (int i = 0; i < hienthi.Length; i++)
{
int kiemtra = hienthi[i].MaNCC.ToString().ToUpper().IndexOf(txttimkiem.Text.ToUpper());
if (kiemtra >= 0)
{
hienthitheoid[soluong] = hienthi[i];
soluong++;
}
}
///////////////////////////////MRK FIX
List <Entities.BCTraLaiNCC> tem0 = new List <Entities.BCTraLaiNCC>();
double tong0 = 0;
double tong1 = 0;
foreach (Entities.BCTraLaiNCC item in hienthitheoid)
{
tong0 += double.Parse(item.SoLuong);
tong1 += item.ThanhTien;
tem0.Add(item);
}
Entities.BCTraLaiNCC tem1 = new Entities.BCTraLaiNCC();
tem1.MaChungTu = "Tổng: ";
tem1.SoLuong = tong0.ToString();
tem1.ThanhTien = tong1;
tem0.Add(tem1);
//////////////////////////////////////
//dtgvhienthi.DataSource = hienthitheoid;
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();
}
}
public void TongTienNhanVien()
{
try
{
List<Entities.BCTraLaiNCC> temp = new List<Entities.BCTraLaiNCC>();
foreach (Entities.TraLaiNCC item in tralaincc)
{
if (item.Ngaytra.Date >= truoc.Date && item.Ngaytra.Date <= sau.Date && item.MaKho == makho)
{
foreach (Entities.ChiTietTraLaiNhaCungCap item1 in chitiettralaincc)
{
if (item.MaHDTraLaiNCC == item1.MaHDTraLaiNCC)
{
Entities.BCTraLaiNCC bc = new Entities.BCTraLaiNCC();
bc.ChietKhau = item1.PhanTramChietKhau;
foreach (Entities.HangHoa item2 in hanghoa)
{
if (item1.MaHangHoa == item2.MaHangHoa)
{
bc.DonGia = Format(double.Parse(item2.GiaNhap));
bool kt = false;
foreach (Entities.Thue item3 in thue)
{
if (item2.MaThueGiaTriGiaTang == item3.MaThue)
{
bc.Thue = item3.GiaTriThue;
bc.TenHang = item2.TenHangHoa;
kt = true;
break;
}
}
if (!kt)
bc.Thue = "0";
break;
}
}
bc.MaChungTu = item.MaHDTraLaiNCC;
bc.NgayChungTu = item.Ngaytra.ToString("dd/MM/yyyy");
bc.SoLuong = item1.SoLuong.ToString();
bc.MaNCC = item.MaNCC;
bc.TenNCC = item.TenNCC;
double dongiadachietkhau =(double.Parse(bc.DonGia) -((double.Parse(bc.DonGia) * double.Parse(bc.ChietKhau))/100));
double dongiabaogomthue = dongiadachietkhau + ((dongiadachietkhau * double.Parse(bc.Thue)) / 100);
bc.ThanhTien = dongiabaogomthue * double.Parse(bc.SoLuong);
temp.Add(bc);
}
}
}
}
hienthi = (Entities.BCTraLaiNCC[])temp.ToArray();
///////////////////////////////MRK FIX
List<Entities.BCTraLaiNCC> tem0 = new List<Entities.BCTraLaiNCC>();
double tong0 = 0;
double tong1 = 0;
foreach (Entities.BCTraLaiNCC item in hienthi)
{
tong0 += double.Parse(item.SoLuong);
tong1 += item.ThanhTien;
tem0.Add(item);
}
Entities.BCTraLaiNCC tem1 = new Entities.BCTraLaiNCC();
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.BCTraLaiNCC[0];
return;
}
int soluong = 0;
if (hienthi != null)
{
if (rdbtimkiem1.Checked == true)
{
for (int i = 0; i < hienthi.Length; i++)
{
int kiemtra = hienthi[i].MaNCC.ToString().ToUpper().IndexOf(txttimkiem.Text.ToUpper());
if (kiemtra >= 0)
{
soluong++;
}
}
if (soluong == 0)
{
dtgvhienthi.DataSource = new Entities.BCTraLaiNCC[0];
return;
}
Entities.BCTraLaiNCC[] hienthitheoid = new Entities.BCTraLaiNCC[soluong];
soluong = 0;
for (int i = 0; i < hienthi.Length; i++)
{
int kiemtra = hienthi[i].MaNCC.ToString().ToUpper().IndexOf(txttimkiem.Text.ToUpper());
if (kiemtra >= 0)
{
hienthitheoid[soluong] = hienthi[i];
soluong++;
}
}
///////////////////////////////MRK FIX
List<Entities.BCTraLaiNCC> tem0 = new List<Entities.BCTraLaiNCC>();
double tong0 = 0;
double tong1 = 0;
foreach (Entities.BCTraLaiNCC item in hienthitheoid)
{
tong0 += double.Parse(item.SoLuong);
tong1 += item.ThanhTien;
tem0.Add(item);
}
Entities.BCTraLaiNCC tem1 = new Entities.BCTraLaiNCC();
tem1.MaChungTu = "Tổng: ";
tem1.SoLuong = tong0.ToString();
tem1.ThanhTien = tong1;
tem0.Add(tem1);
//////////////////////////////////////
//dtgvhienthi.DataSource = hienthitheoid;
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.BCTraLaiNCC> tem0 = ((Entities.BCTraLaiNCC[])dtgvhienthi.DataSource).ToList();
//Entities.BCTraLaiNCC dau = new Entities.BCTraLaiNCC();
//dau = tem0[0];
Entities.BCTraLaiNCC cuoi = new Entities.BCTraLaiNCC();
cuoi = tem0[tem0.Count - 1];
//tem0.Remove(dau);
tem0.Remove(cuoi);
////////////////////////////////////////////////
hienthibaocao = tem0.ToArray();
//hienthibaocao = (Entities.BCTraLaiNCC[])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.BCTraLaiNCC> tem0 = ((Entities.BCTraLaiNCC[])dtgvhienthi.DataSource).ToList();
//Entities.BCTraLaiNCC dau = new Entities.BCTraLaiNCC();
//dau = tem0[0];
Entities.BCTraLaiNCC cuoi = new Entities.BCTraLaiNCC();
cuoi = tem0[tem0.Count - 1];
//tem0.Remove(dau);
tem0.Remove(cuoi);
////////////////////////////////////////////////
hienthibaocao = tem0.ToArray();
//hienthibaocao = (Entities.BCTraLaiNCC[])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.BCTraLaiNCC[0];
return;
}
///////////////////////////////MRK FIX
List<Entities.BCTraLaiNCC> tem0 = new List<Entities.BCTraLaiNCC>();
double tong0 = 0;
double tong1 = 0;
foreach (Entities.BCTraLaiNCC item in hienthi)
{
tong0 += double.Parse(item.SoLuong);
tong1 += item.ThanhTien;
tem0.Add(item);
}
Entities.BCTraLaiNCC tem1 = new Entities.BCTraLaiNCC();
tem1.MaChungTu = "Tổng: ";
tem1.SoLuong = tong0.ToString();
tem1.ThanhTien = tong1;
tem0.Add(tem1);
//////////////////////////////////////
//dtgvhienthi.DataSource = hienthi;
dtgvhienthi.DataSource = tem0.ToArray();
}
catch
{
}
finally
{
fix();
}
}