private void dtgvhienthi_CellDoubleClick(object sender, DataGridViewCellEventArgs e) { this.Enabled = false; if (i < 0) { return; } try { int sl = 0; for (int j = 0; j < hienthibaocao.ToArray().Length; j++) { if (hienthibaocao[j].MaNhomHang == dtgvhienthi.Rows[i].Cells["MaNhomHang"].Value.ToString()) { sl++; } } Entities.BCDTTheoNhomHang[] a = new Entities.BCDTTheoNhomHang[sl]; sl = 0; for (int j = 0; j < hienthibaocao.ToArray().Length; j++) { if (hienthibaocao[j].MaNhomHang == dtgvhienthi.Rows[i].Cells["MaNhomHang"].Value.ToString()) { a[sl] = hienthibaocao[j]; sl++; } } frmBaoCaorpt b = new frmBaoCaorpt(a, truoc, sau); b.ShowDialog(); } catch { } finally { this.Enabled = true; } }
private void txttimkiem_TextChanged(object sender, EventArgs e) { try { if (rdbtimkiem3.Checked == true) { return; } if (txttimkiem.Text.Length == 0) { dtgvhienthi.DataSource = new Entities.BCDTTheoNhomHang[0]; return; } int soluong = 0; if (hienthibaocao != null) { if (rdbtimkiem1.Checked == true) { for (int i = 0; i < hienthibaocao.ToArray().Length; i++) { int kiemtra = hienthibaocao[i].MaNhomHang.ToString().ToUpper().IndexOf(txttimkiem.Text.ToUpper()); if (kiemtra >= 0) { soluong++; } } if (soluong == 0) { dtgvhienthi.DataSource = new Entities.BCDTTheoNhomHang[0]; return; } Entities.BCDTTheoNhomHang[] hienthitheoid = new Entities.BCDTTheoNhomHang[soluong]; soluong = 0; for (int i = 0; i < hienthibaocao.ToArray().Length; i++) { int kiemtra = hienthibaocao[i].MaNhomHang.ToString().ToUpper().IndexOf(txttimkiem.Text.ToUpper()); if (kiemtra >= 0) { hienthitheoid[soluong] = hienthibaocao[i]; soluong++; } } dtgvhienthi.DataSource = hienthitheoid; } if (rdbtimkiem2.Checked == true) { for (int i = 0; i < hienthibaocao.ToArray().Length; i++) { int kiemtra = hienthibaocao[i].TenNhomHang.ToString().ToUpper().IndexOf(txttimkiem.Text.ToUpper()); if (kiemtra >= 0) { soluong++; } } if (soluong == 0) { dtgvhienthi.DataSource = new Entities.BCDTTheoNhomHang[0]; return; } Entities.BCDTTheoNhomHang[] hienthitheoma = new Entities.BCDTTheoNhomHang[soluong]; soluong = 0; for (int i = 0; i < hienthibaocao.ToArray().Length; i++) { int kiemtra = hienthibaocao[i].TenNhomHang.ToString().ToUpper().IndexOf(txttimkiem.Text.ToUpper()); if (kiemtra >= 0) { hienthitheoma[soluong] = hienthibaocao[i]; soluong++; } } dtgvhienthi.DataSource = hienthitheoma; } 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 TongTienNhomHang(DateTime batdau, DateTime ketthuc) { try { List <Entities.BCDTTheoNhomHang> dtNhomHang = new List <Entities.BCDTTheoNhomHang>(); // lay tat ca hang hoa trong hoa don. for (int i = 0; i < hdbanhang.Length; i++) { DateTime hientai = hdbanhang[i].NgayBan; if (hientai.Date >= batdau.Date && hientai.Date <= ketthuc.Date) { for (int j = 0; j < chitiethdbanhang.Length; j++) { if (chitiethdbanhang[j].MaHDBanHang.Equals(hdbanhang[i].MaHDBanHang)) { string tenHangHoa = chitiethdbanhang[j].TenHangHoa; string maHangHoa = chitiethdbanhang[j].MaHangHoa; string maHoaDonBanHang = hdbanhang[i].MaHDBanHang; DateTime ngayBan = hdbanhang[i].NgayBan; double tienHang = chitiethdbanhang[j].SoLuong * double.Parse(chitiethdbanhang[j].DonGia); double giaTriCK = (tienHang * chitiethdbanhang[j].PhanTramChietKhau) / 100; double giaTriVAT = ((tienHang - giaTriCK) * double.Parse(chitiethdbanhang[j].Thue)) / 100; double thanhTien = tienHang - giaTriCK + giaTriVAT; Entities.BCDTTheoNhomHang dtnh = new Entities.BCDTTheoNhomHang(); dtnh.MaHDBanHang = maHoaDonBanHang; dtnh.NgayBan = ngayBan; dtnh.MaHangHoa = maHangHoa; dtnh.TenHangHoa = tenHangHoa; dtnh.ThanhToanNgay = thanhTien; dtNhomHang.Add(dtnh); } } } } // gan tat ca hang hoa cho nhom cua no khi la hang hoa. List <Entities.BCDTTheoNhomHang> dtTemp = new List <Entities.BCDTTheoNhomHang>(); foreach (Entities.BCDTTheoNhomHang item in dtNhomHang.ToArray()) { foreach (Entities.HangHoa hh in nv) { if (hh.MaHangHoa.Equals(item.MaHangHoa)) { foreach (Entities.NhomHang nhTep in nh) { if (hh.MaNhomHangHoa.Equals(nhTep.MaNhomHang)) { item.MaNhomHang = nhTep.MaNhomHang; item.TenNhomHang = nhTep.TenNhomHang; break; } } dtTemp.Add(item); break; } } } // gan tat ca hang hoa cho nhom cua no khi la goi hang. foreach (Entities.BCDTTheoNhomHang item in dtNhomHang.ToArray()) { foreach (Entities.GoiHang gh in goihang) { if (gh.MaGoiHang.Equals(item.MaHangHoa)) { foreach (Entities.NhomHang nhTep in nh) { if (gh.MaNhomHang.Equals(nhTep.MaNhomHang)) { item.MaNhomHang = nhTep.MaNhomHang; item.TenNhomHang = nhTep.TenNhomHang; break; } } dtTemp.Add(item); break; } } } // lay nhom Group trong List Hang hoa. List <string> groupList = new List <string>(); foreach (Entities.BCDTTheoNhomHang item in dtTemp.ToArray()) { if (!groupList.Contains(item.MaNhomHang)) { groupList.Add(item.MaNhomHang); } } // tinh doanh thu theo tung nhom List <Entities.BCDTTheoNhomHang> dtHienThiList = new List <Entities.BCDTTheoNhomHang>(); foreach (string group in groupList.ToArray()) { double thanhToanNgay = 0; string tenNhom = string.Empty; string maNhom = string.Empty; foreach (Entities.BCDTTheoNhomHang item in dtTemp.ToArray()) { if (group.Equals(item.MaNhomHang)) { thanhToanNgay += item.ThanhToanNgay; maNhom = item.MaNhomHang; tenNhom = item.TenNhomHang; } } Entities.BCDTTheoNhomHang temp = new Entities.BCDTTheoNhomHang(); temp.ThanhToanNgay = thanhToanNgay; temp.MaNhomHang = maNhom; temp.TenNhomHang = tenNhom; dtHienThiList.Add(temp); } hienthibaocao = dtHienThiList; //////////////////////////////////////////////Mrk FIX List <Entities.BCDTTheoNhomHang> tem0 = new List <Entities.BCDTTheoNhomHang>(); double tong0 = 0; for (int i = 0; i < dtHienThiList.ToArray().Length; i++) { if (dtHienThiList[i] == null) { break; } tong0 += dtHienThiList[i].ThanhToanNgay; tem0.Add(dtHienThiList[i]); } Entities.BCDTTheoNhomHang tem1 = new Entities.BCDTTheoNhomHang(); tem1.ThanhToanNgay = tong0; tem1.TenNhomHang = "Tổng Cộng: "; tem0.Add(tem1); ////////////////////////////////////////////////////// dtgvhienthi.DataSource = tem0.ToArray(); if (tem0.ToArray().Length > 0) { tsslexcel.Enabled = tsslPdf.Enabled = tsslWord.Enabled = tsslchitiet.Enabled = true; } else { tsslexcel.Enabled = tsslPdf.Enabled = tsslWord.Enabled = tsslchitiet.Enabled = false; } fix(); } catch { } }
public void TongTienNhomHang(DateTime batdau, DateTime ketthuc) { try { List<Entities.BCDTTheoNhomHang> dtNhomHang = new List<Entities.BCDTTheoNhomHang>(); // lay tat ca hang hoa trong hoa don. for (int i = 0; i < hdbanhang.Length; i++) { DateTime hientai = hdbanhang[i].NgayBan; if (hientai.Date >= batdau.Date && hientai.Date <= ketthuc.Date) { for (int j = 0; j < chitiethdbanhang.Length; j++) { if (chitiethdbanhang[j].MaHDBanHang.Equals(hdbanhang[i].MaHDBanHang)) { string tenHangHoa = chitiethdbanhang[j].TenHangHoa; string maHangHoa = chitiethdbanhang[j].MaHangHoa; string maHoaDonBanHang = hdbanhang[i].MaHDBanHang; DateTime ngayBan = hdbanhang[i].NgayBan; double tienHang = chitiethdbanhang[j].SoLuong * double.Parse(chitiethdbanhang[j].DonGia); double giaTriCK = (tienHang * chitiethdbanhang[j].PhanTramChietKhau) / 100; double giaTriVAT = ((tienHang - giaTriCK) * double.Parse(chitiethdbanhang[j].Thue)) / 100; double thanhTien = tienHang - giaTriCK + giaTriVAT; Entities.BCDTTheoNhomHang dtnh = new Entities.BCDTTheoNhomHang(); dtnh.MaHDBanHang = maHoaDonBanHang; dtnh.NgayBan = ngayBan; dtnh.MaHangHoa = maHangHoa; dtnh.TenHangHoa = tenHangHoa; dtnh.ThanhToanNgay = thanhTien; dtNhomHang.Add(dtnh); } } } } // gan tat ca hang hoa cho nhom cua no khi la hang hoa. List<Entities.BCDTTheoNhomHang> dtTemp = new List<Entities.BCDTTheoNhomHang>(); foreach (Entities.BCDTTheoNhomHang item in dtNhomHang.ToArray()) { foreach (Entities.HangHoa hh in nv) { if (hh.MaHangHoa.Equals(item.MaHangHoa)) { foreach (Entities.NhomHang nhTep in nh) { if (hh.MaNhomHangHoa.Equals(nhTep.MaNhomHang)) { item.MaNhomHang = nhTep.MaNhomHang; item.TenNhomHang = nhTep.TenNhomHang; break; } } dtTemp.Add(item); break; } } } // gan tat ca hang hoa cho nhom cua no khi la goi hang. foreach (Entities.BCDTTheoNhomHang item in dtNhomHang.ToArray()) { foreach (Entities.GoiHang gh in goihang) { if (gh.MaGoiHang.Equals(item.MaHangHoa)) { foreach (Entities.NhomHang nhTep in nh) { if (gh.MaNhomHang.Equals(nhTep.MaNhomHang)) { item.MaNhomHang = nhTep.MaNhomHang; item.TenNhomHang = nhTep.TenNhomHang; break; } } dtTemp.Add(item); break; } } } // lay nhom Group trong List Hang hoa. List<string> groupList = new List<string>(); foreach (Entities.BCDTTheoNhomHang item in dtTemp.ToArray()) { if (!groupList.Contains(item.MaNhomHang)) { groupList.Add(item.MaNhomHang); } } // tinh doanh thu theo tung nhom List<Entities.BCDTTheoNhomHang> dtHienThiList = new List<Entities.BCDTTheoNhomHang>(); foreach (string group in groupList.ToArray()) { double thanhToanNgay = 0; string tenNhom = string.Empty; string maNhom = string.Empty; foreach (Entities.BCDTTheoNhomHang item in dtTemp.ToArray()) { if (group.Equals(item.MaNhomHang)) { thanhToanNgay += item.ThanhToanNgay; maNhom = item.MaNhomHang; tenNhom = item.TenNhomHang; } } Entities.BCDTTheoNhomHang temp = new Entities.BCDTTheoNhomHang(); temp.ThanhToanNgay = thanhToanNgay; temp.MaNhomHang = maNhom; temp.TenNhomHang = tenNhom; dtHienThiList.Add(temp); } hienthibaocao = dtHienThiList; //////////////////////////////////////////////Mrk FIX List<Entities.BCDTTheoNhomHang> tem0 = new List<Entities.BCDTTheoNhomHang>(); double tong0 = 0; for (int i = 0; i < dtHienThiList.ToArray().Length; i++) { if (dtHienThiList[i] == null) { break; } tong0 += dtHienThiList[i].ThanhToanNgay; tem0.Add(dtHienThiList[i]); } Entities.BCDTTheoNhomHang tem1 = new Entities.BCDTTheoNhomHang(); tem1.ThanhToanNgay = tong0; tem1.TenNhomHang = "Tổng Cộng: "; tem0.Add(tem1); ////////////////////////////////////////////////////// dtgvhienthi.DataSource = tem0.ToArray(); if (tem0.ToArray().Length > 0) { tsslexcel.Enabled = tsslPdf.Enabled = tsslWord.Enabled = tsslchitiet.Enabled = true; } else { tsslexcel.Enabled = tsslPdf.Enabled = tsslWord.Enabled = tsslchitiet.Enabled = false; } fix(); } catch { } }
private void txttimkiem_TextChanged(object sender, EventArgs e) { try { if (rdbtimkiem3.Checked == true) { return; } if (txttimkiem.Text.Length == 0) { dtgvhienthi.DataSource = new Entities.BCDTTheoNhomHang[0]; return; } int soluong = 0; if (hienthibaocao != null) { if (rdbtimkiem1.Checked == true) { for (int i = 0; i < hienthibaocao.ToArray().Length; i++) { int kiemtra = hienthibaocao[i].MaNhomHang.ToString().ToUpper().IndexOf(txttimkiem.Text.ToUpper()); if (kiemtra >= 0) { soluong++; } } if (soluong == 0) { dtgvhienthi.DataSource = new Entities.BCDTTheoNhomHang[0]; return; } Entities.BCDTTheoNhomHang[] hienthitheoid = new Entities.BCDTTheoNhomHang[soluong]; soluong = 0; for (int i = 0; i < hienthibaocao.ToArray().Length; i++) { int kiemtra = hienthibaocao[i].MaNhomHang.ToString().ToUpper().IndexOf(txttimkiem.Text.ToUpper()); if (kiemtra >= 0) { hienthitheoid[soluong] = hienthibaocao[i]; soluong++; } } dtgvhienthi.DataSource = hienthitheoid; } if (rdbtimkiem2.Checked == true) { for (int i = 0; i < hienthibaocao.ToArray().Length; i++) { int kiemtra = hienthibaocao[i].TenNhomHang.ToString().ToUpper().IndexOf(txttimkiem.Text.ToUpper()); if (kiemtra >= 0) { soluong++; } } if (soluong == 0) { dtgvhienthi.DataSource = new Entities.BCDTTheoNhomHang[0]; return; } Entities.BCDTTheoNhomHang[] hienthitheoma = new Entities.BCDTTheoNhomHang[soluong]; soluong = 0; for (int i = 0; i < hienthibaocao.ToArray().Length; i++) { int kiemtra = hienthibaocao[i].TenNhomHang.ToString().ToUpper().IndexOf(txttimkiem.Text.ToUpper()); if (kiemtra >= 0) { hienthitheoma[soluong] = hienthibaocao[i]; soluong++; } } dtgvhienthi.DataSource = hienthitheoma; } 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 dtgvhienthi_CellDoubleClick(object sender, DataGridViewCellEventArgs e) { this.Enabled = false; if (i < 0) return; try { int sl = 0; for (int j = 0; j < hienthibaocao.ToArray().Length; j++) { if (hienthibaocao[j].MaNhomHang == dtgvhienthi.Rows[i].Cells["MaNhomHang"].Value.ToString()) { sl++; } } Entities.BCDTTheoNhomHang[] a = new Entities.BCDTTheoNhomHang[sl]; sl = 0; for (int j = 0; j < hienthibaocao.ToArray().Length; j++) { if (hienthibaocao[j].MaNhomHang == dtgvhienthi.Rows[i].Cells["MaNhomHang"].Value.ToString()) { a[sl] = hienthibaocao[j]; sl++; } } frmBaoCaorpt b = new frmBaoCaorpt(a, truoc, sau); b.ShowDialog(); } catch { } finally { this.Enabled = true; } }