private void rdbTatCa_CheckedChanged(object sender, EventArgs e)
{
if (rdbTatCa.Checked == true)
{
txtTimKiem.Text = "";
if (ctBCXH_Search.Length > 0)
{
tsslchitiet.Enabled = true;
tsslPdf.Enabled = true;
tsslExcel.Enabled = true;
tsslWord.Enabled = true;
}
else
{
tsslchitiet.Enabled = false;
tsslPdf.Enabled = false;
tsslExcel.Enabled = false;
tsslWord.Enabled = false;
}
///////////////////////////////MRK FIX
List<Entities.BCXuatHangTheoMatHang> tem0 = new List<BCXuatHangTheoMatHang>();
double tong0 = 0;
foreach (Entities.BCXuatHangTheoMatHang item in ctBCXH_Search)
{
tong0 += item.TongSoLuongXuat;
tem0.Add(item);
}
Entities.BCXuatHangTheoMatHang tem1 = new BCXuatHangTheoMatHang();
tem1.TenHangHoa = "Tổng: ";
tem1.TongSoLuongXuat = (int)tong0;
tem0.Add(tem1);
//////////////////////////////////////
//dtgvhienthi.DataSource = ctBCXH_Search;
dtgvhienthi.DataSource = tem0.ToArray();
ctBCXH_Search_In = ctBCXH_Search;
FixDatagridview();
}
}
private void btnhienthi_Click(object sender, EventArgs e)
{
if (KiemTra())
{
LayNgay();
//Xuất hủy
PhieuXuatHuy();
ChiTietXuatHuy();
//HĐ bán hàng
HDBanHang1();
ChiTietHDBanHang();
//Trả lại NCC
TraLaiNCC();
ChiTietTraLaiNCC();
HangHoa1();
GoiHang();
ChiTietGoiHang();
TongTienNhanVien();
LayChiTiet_HangHoaXuat_TheoNhomHang();
///////////////////////////////MRK FIX
List<Entities.BCXuatHangTheoMatHang> tem0 = new List<BCXuatHangTheoMatHang>();
double tong0 = 0;
foreach (Entities.BCXuatHangTheoMatHang item in temp)
{
if (item == null)
{
continue;
}
tong0 += item.TongSoLuongXuat;
tem0.Add(item);
}
Entities.BCXuatHangTheoMatHang tem1 = new BCXuatHangTheoMatHang();
tem1.TenHangHoa = "Tổng: ";
tem1.TongSoLuongXuat = (int)tong0;
tem0.Add(tem1);
//////////////////////////////////////
//dtgvhienthi.DataSource = temp;
dtgvhienthi.DataSource = tem0.ToArray();
FixDatagridview();
ctBCXH_Search = temp;
ctBCXH_Search_In = temp;
if (temp.Length > 0)
{
tsslchitiet.Enabled = true;
tsslPdf.Enabled = true;
tsslExcel.Enabled = true;
tsslWord.Enabled = true;
}
else
{
tsslchitiet.Enabled = false;
tsslPdf.Enabled = false;
tsslExcel.Enabled = false;
tsslWord.Enabled = false;
}
}
}
public void TongTienNhanVien()
{
try
{
nam = int.Parse(cbbnam.Text);
thang = int.Parse(cbbthang.Text);
List<Entities.BCXuatHangTheoMatHang> l = new List<Entities.BCXuatHangTheoMatHang>();
foreach (Entities.HangHoa hh in this.hanghoa)
{
int tongxuat = 0;
//Xuất Hủy
foreach (Entities.PhieuXuatHuy item in this.phieuxuathuy)
{
int _nam = item.NgayLap.Year;
int _thang = item.NgayLap.Month;
if ((_nam == this.nam) && (_thang == this.thang) && (item.TrangThai == true))
{
foreach (Entities.ChiTietXuatHuy item1 in this.chitietxuathuy)
{
if (item1.MaPhieuXuatHuy.Equals(item.MaPhieuXuatHuy) && (item1.MaHangHoa.Equals(hh.MaHangHoa)))
{
tongxuat += item1.SoLuong;
}
}
}
}
//Hóa đơn bán hàng
foreach (Entities.HDBanHang item in this.hdbanhang)
{
int _nam = item.NgayBan.Year;
int _thang = item.NgayBan.Month;
if ((_nam == this.nam) && (_thang == this.thang))
{
foreach (Entities.ChiTietHDBanHang item1 in this.chitiethdbanhang)
{
if (item1.MaHDBanHang.Equals(item.MaHDBanHang))
{
if (GoiHangOrHangHoa(item1.MaHangHoa))
{//là gói hàng
foreach (Entities.GoiHang gh in this.goihang)
{
foreach (Entities.ChiTietGoiHang ctgh in this.chitietgoihang)
{
if (gh.MaGoiHang.Equals(ctgh.MaGoiHang) && ctgh.MaGoiHang.Equals(item1.MaHangHoa))
{
if (ctgh.MaHangHoa.Equals(hh.MaHangHoa))
{
tongxuat += item1.SoLuong * ctgh.SoLuong;
}
}
}
}
}
else
{//là hàng hóa
if (item1.MaHangHoa.Equals(hh.MaHangHoa))
{
tongxuat += item1.SoLuong;
}
}
}
}
}
}
//Trả lại nhà cung cấp
foreach (Entities.TraLaiNCC item in this.tralaincc)
{
int _nam = item.Ngaytra.Year;
int _thang = item.Ngaytra.Month;
if ((_nam == this.nam) && (_thang == this.thang))
{
foreach (Entities.ChiTietTraLaiNhaCungCap item1 in this.chitiettralaincc)
{
if (item1.MaHDTraLaiNCC.Equals(item.MaHDTraLaiNCC) && item1.MaHangHoa.Equals(hh.MaHangHoa))
{
tongxuat += item1.SoLuong;
}
}
}
}
if (tongxuat == 0)
{//Nếu hàng hóa này không có sự xuất đi thì không hiển thị
continue;
}
else
{
Entities.BCXuatHangTheoMatHang bientam = new BCXuatHangTheoMatHang();
bientam.MaHangHoa = hh.MaHangHoa;
bientam.TenHangHoa = hh.TenHangHoa;
bientam.TongSoLuongXuat = tongxuat;
l.Add(bientam);
}
}
hienthibaocao = new Entities.BCXuatHangTheoMatHang[l.Count];
for (int i = 0; i < l.Count; i++)
{
hienthibaocao[i] = l[i];
}
///////////////////////////////MRK FIX
List<Entities.BCXuatHangTheoMatHang> tem0 = new List<Entities.BCXuatHangTheoMatHang>();
double tong0 = 0;
foreach (Entities.BCXuatHangTheoMatHang item in hienthibaocao)
{
tong0 += item.TongSoLuongXuat;
tem0.Add(item);
}
Entities.BCXuatHangTheoMatHang tem1 = new Entities.BCXuatHangTheoMatHang();
tem1.TenHangHoa = "Tổng: ";
tem1.TongSoLuongXuat = (int)tong0;
tem0.Add(tem1);
//////////////////////////////////////
//dtgvhienthi.DataSource = hienthibaocao;
dtgvhienthi.DataSource = tem0.ToArray();
}
catch { }
//try
//{
// double sddk, sddkhh, sdckhh, sdck, tongxuat, tongnhap;
// double nhapmua, nhaptralai, nhapkhac;
// double xuatban, xuattralai, xuatkhac;
// nhapmua = nhaptralai = nhapkhac = xuatban = xuattralai = xuatkhac = 0;
// sdckhh = sddkhh = sdck = sddk = 0;
// int sotang = 0;
// hienthi = new Entities.BCXuatNhapTonTheoKho[khohang.Length];
// for (int i = 0; i < khohang.Length; i++)
// {
// for (int j = 0; j < chitietkhohang.Length; j++)
// {
// if (chitietkhohang[j].Makho == khohang[i].MaKho)
// {
// for (int k = 0; k < hanghoa.Length; k++)
// {
// if (hanghoa[k].MaHangHoa == chitietkhohang[j].Mahanghoa)
// {
// sotang++; //Đếm số hàng hóa trong kho
// }
// }
// }
// }
// }
// int sohanghoatrongkho = sotang;
// hienthibaocao = new Entities.BCXuatHangTheoMatHang[sotang];
// sotang = 0;
// for (int i = 0; i < khohang.Length; i++)
// {
// tongxuat = tongnhap = sddk = 0;
// for (int j = 0; j < chitietkhohang.Length; j++)
// {
// if (chitietkhohang[j].Makho == khohang[i].MaKho)
// {
// for (int k = 0; k < hanghoa.Length; k++)
// {
// if (hanghoa[k].MaHangHoa == chitietkhohang[j].Mahanghoa)
// {
// sdckhh = sddkhh = sdck = 0;
// // xuất hàng - phiếu xuất hủy
// nhapmua = nhaptralai = nhapkhac = xuatban = xuattralai = xuatkhac = 0;
// for (int l = 0; l < phieuxuathuy.Length; l++)
// {
// for (int o = 0; o < chitietxuathuy.Length; o++)
// {
// int namphieu = phieuxuathuy[l].NgayLap.Year;
// int thangphieu = phieuxuathuy[l].NgayLap.Month;
// if (thang == thangphieu && phieuxuathuy[l].TrangThai == true && phieuxuathuy[l].MaKho == khohang[i].MaKho)
// {
// if (chitietxuathuy[o].MaHangHoa == hanghoa[k].MaHangHoa)
// {
// xuatban += chitietxuathuy[o].SoLuong;
// }
// }
// }
// }
// // xuất hàng - hóa đơn bán hàng
// for (int l = 0; l < hdbanhang.Length; l++)
// {
// for (int o = 0; o < chitiethdbanhang.Length; o++)
// {
// int namphieu = hdbanhang[l].NgayBan.Year;
// int thangphieu = hdbanhang[l].NgayBan.Month;
// if (chitiethdbanhang[o].MaHDBanHang == hdbanhang[l].MaHDBanHang &&
// nam == namphieu && thang == thangphieu &&
// hdbanhang[l].MaKho == khohang[i].MaKho)
// {
// ////////////////////////////////////////////////MRK FIX
// //kiểm tra nó là hàng hóa hay mã hàng
// if (this.GoiHangOrHangHoa(chitiethdbanhang[o].MaHangHoa))
// { //là gói hàng
// for (int for6 = 0; for6 < goihang.Length; for6++)
// {
// for (int for7 = 0; for7 < chitietgoihang.Length; for7++)
// {
// if (goihang[for6].MaGoiHang.Equals(chitietgoihang[for7].MaGoiHang) && chitietgoihang[for7].MaGoiHang.Equals(chitiethdbanhang[o].MaHangHoa))
// {
// //-------
// if (chitietgoihang[for7].MaHangHoa == hanghoa[k].MaHangHoa)
// {
// xuatban += (chitietgoihang[for7].SoLuong * chitiethdbanhang[o].SoLuong);
// }
// }
// }
// }
// }
// else
// { //là hàng hóa
// if ((chitiethdbanhang[o].MaHangHoa == hanghoa[k].MaHangHoa) && (hdbanhang[l].MaKho == khohang[i].MaKho))
// {
// xuatban += chitiethdbanhang[o].SoLuong;
// }
// }
// //End kiểm tra
// ////////////////////////////////////////////////MRK FIX
// }
// }
// }
// // xuất hàng - trả lại nhà cung cấp
// for (int l = 0; l < tralaincc.Length; l++)
// {
// for (int o = 0; o < chitiettralaincc.Length; o++)
// {
// int namphieu = tralaincc[l].Ngaytra.Year;
// int thangphieu = tralaincc[l].Ngaytra.Month;
// if (thang == thangphieu && tralaincc[l].MaKho == khohang[i].MaKho)
// {
// if (chitiettralaincc[o].MaHangHoa == hanghoa[k].MaHangHoa)
// {
// xuatban += chitiettralaincc[o].SoLuong;
// }
// }
// }
// }
// // xuất hàng - phiếu điều chuyển kho nội bộ
// for (int l = 0; l < phieudieuchuyenkhonoibo.Length; l++)
// {
// if (phieudieuchuyenkhonoibo[l].TuKho == khohang[i].MaKho)
// {
// for (int o = 0; o < chitietphieudieuchuyenkho.Length; o++)
// {
// int namphieu = phieudieuchuyenkhonoibo[l].NgayDieuChuyen.Year;
// int thangphieu = phieudieuchuyenkhonoibo[l].NgayDieuChuyen.Month;
// if (nam == namphieu && thang == thangphieu && phieudieuchuyenkhonoibo[l].TuKho == khohang[i].MaKho)
// {
// ////////////////////////////////////////////////MRK FIX
// //kiểm tra nó là hàng hóa hay mã hàng
// if (this.GoiHangOrHangHoa(chitietphieudieuchuyenkho[o].MaHangHoa))
// { //là gói hàng
// for (int for6 = 0; for6 < goihang.Length; for6++)
// {
// for (int for7 = 0; for7 < chitietgoihang.Length; for7++)
// {
// if (goihang[for6].MaGoiHang.Equals(chitietgoihang[for7].MaGoiHang) && chitietgoihang[for7].MaGoiHang.Equals(chitietphieudieuchuyenkho[o].MaHangHoa))
// {
// //-------
// if (chitietgoihang[for7].MaHangHoa == hanghoa[k].MaHangHoa)
// {
// xuatban += (chitietgoihang[for7].SoLuong * chitietphieudieuchuyenkho[o].SoLuong);
// }
// }
// }
// }
// }
// else
// { //là hàng hóa
// if (chitietphieudieuchuyenkho[o].MaHangHoa == hanghoa[k].MaHangHoa
// && phieudieuchuyenkhonoibo[l].TuKho == khohang[i].MaKho)
// {
// xuatban += chitietphieudieuchuyenkho[o].SoLuong;
// }
// }
// //End kiểm tra
// ////////////////////////////////////////////////MRK FIX
// }
// }
// }
// }
// hienthibaocao[sotang] = new Entities.BCXuatHangTheoMatHang(hanghoa[k].MaHangHoa, hanghoa[k].TenHangHoa,Convert.ToInt32(xuatban));
// sotang++;
// }
// }
// }
// }
// }
// ///////////////////////////////MRK FIX
// List<Entities.BCXuatHangTheoMatHang> tem0 = new List<Entities.BCXuatHangTheoMatHang>();
// double tong0 = 0;
// foreach (Entities.BCXuatHangTheoMatHang item in hienthibaocao)
// {
// tong0 += item.TongSoLuongXuat;
// tem0.Add(item);
// }
// Entities.BCXuatHangTheoMatHang tem1 = new BCXuatHangTheoMatHang();
// tem1.TenHangHoa = "Tổng: ";
// tem1.TongSoLuongXuat = (int)tong0;
// tem0.Add(tem1);
// //////////////////////////////////////
// //dtgvhienthi.DataSource = hienthibaocao;
// dtgvhienthi.DataSource = tem0.ToArray();
//}
//catch
//{
//}
}
public frmBCXuatHangTheoHangHoa()
{
InitializeComponent();
try
{
datesv = DateServer.Date();
for (int i = 0; i < cbbthang.Items.Count; i++)
{
if (cbbthang.Items[i].ToString() == datesv.Month.ToString())
{
cbbthang.SelectedIndex = i;
break;
}
}
for (int i = 0; i < cbbnam.Items.Count; i++)
{
if (cbbnam.Items[i].ToString() == datesv.Year.ToString())
{
cbbnam.SelectedIndex = i;
break;
}
}
nam = datesv.Year;
thang = datesv.Month;
//cbbthang.Text = thang.ToString();
//cbbnam.Text = nam.ToString();
LayNgay();
//Xuất hủy
PhieuXuatHuy();
ChiTietXuatHuy();
//HĐ bán hàng
HDBanHang1();
ChiTietHDBanHang();
//Trả lại NCC
TraLaiNCC();
ChiTietTraLaiNCC();
HangHoa1();
GoiHang();
ChiTietGoiHang();
TongTienNhanVien();
LayChiTiet_HangHoaXuat_TheoNhomHang();
///////////////////////////////MRK FIX
List<Entities.BCXuatHangTheoMatHang> tem0 = new List<BCXuatHangTheoMatHang>();
double tong0 = 0;
foreach (Entities.BCXuatHangTheoMatHang item in temp)
{
tong0 += item.TongSoLuongXuat;
tem0.Add(item);
}
Entities.BCXuatHangTheoMatHang tem1 = new BCXuatHangTheoMatHang();
tem1.TenHangHoa = "Tổng: ";
tem1.TongSoLuongXuat = (int)tong0;
tem0.Add(tem1);
//////////////////////////////////////
//dtgvhienthi.DataSource = temp;
dtgvhienthi.DataSource = tem0.ToArray();
FixDatagridview();
ctBCXH_Search = temp;
ctBCXH_Search_In = temp;
if (temp.Length > 0)
{
tsslchitiet.Enabled = true;
tsslPdf.Enabled = true;
tsslExcel.Enabled = true;
tsslWord.Enabled = true;
}
else
{
tsslchitiet.Enabled = false;
tsslPdf.Enabled = false;
tsslExcel.Enabled = false;
tsslWord.Enabled = false;
}
}
catch { }
}
public void LayChiTiet_HangHoaXuat_TheoNhomHang()
{
try
{
int sl = 0;
temp = new Entities.BCXuatHangTheoMatHang[hienthibaocao.Length];
for (int i = 0; i < hienthibaocao.Length; i++)
{
if (hienthibaocao[i].TongSoLuongXuat != 0)
{
temp[sl] = hienthibaocao[i];
sl++;
}
}
Entities.BCXuatHangTheoMatHang[] baocao = new Entities.BCXuatHangTheoMatHang[sl];
for (int i = 0; i < sl; i++)
{
baocao[i] = temp[i];
}
}
catch
{
}
}
private void txtTimKiem_TextChanged(object sender, EventArgs e)
{
if (rdbTen.Checked == true)
{
if (ctBCXH_Search == null)
{
BCXuatHangTheoMatHang[] tkkt = new BCXuatHangTheoMatHang[0];
dtgvhienthi.DataSource = tkkt;
FixDatagridview();
tsslchitiet.Enabled = false;
tsslExcel.Enabled = false;
tsslPdf.Enabled = false;
tsslWord.Enabled = false;
}
else
if (ctBCXH_Search != null)
{
if (txtTimKiem.Text.Length == 0)
{
BCXuatHangTheoMatHang[] tkkt = new BCXuatHangTheoMatHang[0];
dtgvhienthi.DataSource = tkkt;
FixDatagridview();
tsslchitiet.Enabled = false;
tsslExcel.Enabled = false;
tsslPdf.Enabled = false;
tsslWord.Enabled = false;
}
else
{
int ctBCXH_Search_count = 0;
for (int i = 0; i < ctBCXH_Search.Length; i++)
{
int index = -1;
index = ctBCXH_Search[i].TenHangHoa.ToLower().IndexOf(txtTimKiem.Text.Trim().ToLower());
if (index >= 0)
{
ctBCXH_Search_count++;
}
}
BCXuatHangTheoMatHang[] ctBCXH_Search1 = new BCXuatHangTheoMatHang[ctBCXH_Search_count];
ctBCXH_Search_count = 0;
for (int i = 0; i < ctBCXH_Search.Length; i++)
{
int index = -1;
index = ctBCXH_Search[i].TenHangHoa.ToLower().IndexOf(txtTimKiem.Text.Trim().ToLower());
if (index >= 0)
{
ctBCXH_Search1[ctBCXH_Search_count] = ctBCXH_Search[i];
ctBCXH_Search_count++;
}
}
if (ctBCXH_Search_count == 0)
{
tsslchitiet.Enabled = false;
tsslExcel.Enabled = false;
tsslPdf.Enabled = false;
tsslWord.Enabled = false;
}
else
{
tsslchitiet.Enabled = true;
tsslExcel.Enabled = true;
tsslPdf.Enabled = true;
tsslWord.Enabled = true;
}
///////////////////////////////MRK FIX
List<Entities.BCXuatHangTheoMatHang> tem0 = new List<BCXuatHangTheoMatHang>();
double tong0 = 0;
foreach (Entities.BCXuatHangTheoMatHang item in ctBCXH_Search1)
{
tong0 += item.TongSoLuongXuat;
tem0.Add(item);
}
Entities.BCXuatHangTheoMatHang tem1 = new BCXuatHangTheoMatHang();
tem1.TenHangHoa = "Tổng: ";
tem1.TongSoLuongXuat = (int)tong0;
tem0.Add(tem1);
//////////////////////////////////////
//dtgvhienthi.DataSource = ctBCXH_Search1;
dtgvhienthi.DataSource = tem0.ToArray();
ctBCXH_Search_In = ctBCXH_Search1;
FixDatagridview();
}
}
}
else
if (rdbMa.Checked == true)
{
if (ctBCXH_Search == null)
{
BCXuatHangTheoMatHang[] tkkt = new BCXuatHangTheoMatHang[0];
dtgvhienthi.DataSource = tkkt;
FixDatagridview();
tsslchitiet.Enabled = false;
tsslExcel.Enabled = false;
tsslPdf.Enabled = false;
tsslWord.Enabled = false;
}
else
if (ctBCXH_Search != null)
{
if (txtTimKiem.Text.Length == 0)
{
BCXuatHangTheoMatHang[] tkkt = new BCXuatHangTheoMatHang[0];
dtgvhienthi.DataSource = tkkt;
FixDatagridview();
tsslchitiet.Enabled = false;
tsslExcel.Enabled = false;
tsslPdf.Enabled = false;
tsslWord.Enabled = false;
}
else
{
int ctBCXH_Search_count = 0;
for (int i = 0; i < ctBCXH_Search.Length; i++)
{
int index = -1;
index = ctBCXH_Search[i].MaHangHoa.ToLower().IndexOf(txtTimKiem.Text.Trim().ToLower());
if (index >= 0)
{
ctBCXH_Search_count++;
}
}
BCXuatHangTheoMatHang[] ctBCXH_Search1 = new BCXuatHangTheoMatHang[ctBCXH_Search_count];
ctBCXH_Search_count = 0;
for (int i = 0; i < ctBCXH_Search.Length; i++)
{
int index = -1;
index = ctBCXH_Search[i].MaHangHoa.ToLower().IndexOf(txtTimKiem.Text.Trim().ToLower());
if (index >= 0)
{
ctBCXH_Search1[ctBCXH_Search_count] = ctBCXH_Search[i];
ctBCXH_Search_count++;
}
}
if (ctBCXH_Search_count == 0)
{
tsslchitiet.Enabled = false;
tsslExcel.Enabled = false;
tsslPdf.Enabled = false;
tsslWord.Enabled = false;
}
else
{
tsslchitiet.Enabled = true;
tsslExcel.Enabled = true;
tsslPdf.Enabled = true;
tsslWord.Enabled = true;
}
///////////////////////////////MRK FIX
List<Entities.BCXuatHangTheoMatHang> tem0 = new List<BCXuatHangTheoMatHang>();
double tong0 = 0;
foreach (Entities.BCXuatHangTheoMatHang item in ctBCXH_Search1)
{
tong0 += item.TongSoLuongXuat;
tem0.Add(item);
}
Entities.BCXuatHangTheoMatHang tem1 = new BCXuatHangTheoMatHang();
tem1.TenHangHoa = "Tổng: ";
tem1.TongSoLuongXuat = (int)tong0;
tem0.Add(tem1);
//////////////////////////////////////
//dtgvhienthi.DataSource = ctBCXH_Search1;
dtgvhienthi.DataSource = tem0.ToArray();
ctBCXH_Search_In = ctBCXH_Search1;
FixDatagridview();
}
}
}
}
