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(); } }