/// <summary>
///
/// </summary>
private void LocKhoHang()
{
try
{
LayKhoHang("KhoHang", "MaKho", "TenKho");
Entities.HienThiBaoCao[] hienthi = null;
if (kt.Length > 0)
{
ArrayList list = new ArrayList();
for (int k = 0; k < kt.Length; k++)
{
Entities.HienThiBaoCao lay = new Entities.HienThiBaoCao();
lay.Ma = kt[k].Khoachinh;
lay.Ten = kt[k].Giatri;
int sl = 0;
for (int j = 0; j < khohang.Length; j++)
{
if (kt[k].Khoachinh == khohang[j].MaKho)
{
sl += int.Parse(khohang[j].SoLuong);
}
else
{ continue; }
}
lay.Soluong = sl.ToString();
list.Add(lay);
}
int n = list.Count;
if (n == 0) { hienthi = null; }
hienthi = new Entities.HienThiBaoCao[n];
for (int i = 0; i < n; i++)
{
hienthi[i] = (Entities.HienThiBaoCao)list[i];
}
ArrayList list2 = new ArrayList();
Entities.HienThiBaoCao[] baocaokho = null;
for (int x = 0; x < hienthi.Length; x++)
{
if (hienthi[x].Soluong != "0")
{
Entities.HienThiBaoCao lay = new Entities.HienThiBaoCao();
lay.Ma = hienthi[x].Ma;
lay.Ten = hienthi[x].Ten;
lay.Soluong = hienthi[x].Soluong;
list2.Add(lay);
}
}
int w = list2.Count;
if (w == 0) { baocaokho = null; }
baocaokho = new Entities.HienThiBaoCao[w];
for (int t = 0; t < w; t++)
{
baocaokho[t] = (Entities.HienThiBaoCao)list2[t];
}
if (baocaokho.Length > 0)
{
dgvBaoCaoNhap.DataSource = baocaokho;
}
else
{
Entities.HienThiBaoCao[] g = new Entities.HienThiBaoCao[0];
dgvBaoCaoNhap.DataSource = g;
}
fixDatagridview();
}
}
catch (Exception ex)
{
string s = ex.Message;
Entities.HienThiBaoCao[] g = new Entities.HienThiBaoCao[0];
dgvBaoCaoNhap.DataSource = g;
fixDatagridview();
}
}
/// <summary>
///
/// </summary>
/// <param name="nh"></param>
private Entities.HienThiBaoCao[] LayThongTinNhom(Entities.HienThiBaoCao[] nh)
{
Entities.HienThiBaoCao[] tra = new Entities.HienThiBaoCao[1];
try
{
cl = new Server_Client.Client();
this.client = cl.Connect(Luu.IP, Luu.Ports);
clientstrem = cl.SerializeObj(this.client, "KiemTraNhomHangHoa", nh);
tra = (Entities.HienThiBaoCao[])cl.DeserializeHepper(clientstrem, tra);
client.Close();
clientstrem.Close();
}
catch (Exception ex)
{
string s = ex.Message.ToString();
tra = new Entities.HienThiBaoCao[0];
}
return tra;
}
private void frmBaoCaoNhap_Load(object sender, EventArgs e)
{
try
{
this.cbxThang.Items.AddRange(new object[] { "1", "2", "3", "4", "5", "6", "7", "8", "9", "10", "11", "12" });
cbxThang.SelectedIndex = 0;
this.cbxNam.Items.AddRange(new object[] { "2011", "2012", "2013", "2014", "2015", "2016", "2017", "2018", "2019", "2020" });
cbxNam.SelectedIndex = 0;
thongtin = Congty("");
switch (reportName)
{
//=============================================================================
case "BaoCaoNhapTheoKhoHang":
{
Entities.HienThiBaoCao[] lay = new Entities.HienThiBaoCao[0];
dgvBaoCaoNhap.DataSource = lay;
fixDatagridview();
lblTieuDe.Text = "Báo Cáo Nhập Hàng Theo Kho Hàng Theo Kỳ";
} break;
//=============================================================================
case "BaoCaoNhapTheoNhomHang":
{
Entities.HienThiBaoCao[] lay = new Entities.HienThiBaoCao[0];
dgvBaoCaoNhap.DataSource = lay;
fixDatagridview();
lblTieuDe.Text = "Báo Cáo Nhập Hàng Theo Nhóm Hàng Theo Kỳ";
} break;
//=============================================================================
case "BaoCaoNhapTheoMatHang":
{
Entities.HienThiBaoCao[] lay = new Entities.HienThiBaoCao[0];
dgvBaoCaoNhap.DataSource = lay;
fixDatagridview();
lblTieuDe.Text = "Báo Cáo Nhập Hàng Theo Mat Hàng Theo Kỳ";
} break;
//=============================================================================
case "XuatNhapTonTheoNhomHang":
{
Entities.HienThiBaoCao[] g = new Entities.HienThiBaoCao[0];
dgvBaoCaoNhap.DataSource = g;
fixDatagridviewNhom();
lblTieuDe.Text = "Báo Cáo Xuất Nhập Tồn Hàng Theo Nhóm Hàng Theo Kỳ";
} break;
default:
{
MessageBox.Show("Không có tên báo cáo.Ứng dụng sẽ đóng");
this.Close();
} break;
}
if (thongtin.TenCongTy == "")
{ MessageBox.Show("Thông tin công ty chưa có hãy kiểm tra lại"); return; }
}
catch (Exception ex)
{ string s = ex.Message; }
}
/// <summary>
/// tim theo mat hang
/// </summary>
/// <param name="tungay"></param>
/// <param name="denngay"></param>
private void TimTheo_MatHang(string tungay, string denngay)
{
try
{
Entities.TruyenGiaTri top = new Entities.TruyenGiaTri();
cl = new Server_Client.Client();
this.client = cl.Connect(Luu.IP, Luu.Ports);
top = new Entities.TruyenGiaTri("Select", tungay, denngay);
clientstrem = cl.SerializeObj(this.client, "BaoCaoNhapHangTheoTungKhoTheoThoiGian", top);
mathang = new Entities.BaoCaoNhapHangTheoTungKhoTheoThoiGian[1];
mathang = (Entities.BaoCaoNhapHangTheoTungKhoTheoThoiGian[])cl.DeserializeHepper(clientstrem, mathang);
client.Close();
clientstrem.Close();
if (mathang.Length <= 0)
{
mathang = null;
Entities.HienThiBaoCao[] lay = new Entities.HienThiBaoCao[0];
dgvBaoCaoNhap.DataSource = lay;
fixDatagridview();
}
}
catch (Exception ex)
{
string s = ex.Message; mathang = null; mathang = null;
Entities.HienThiBaoCao[] lay = new Entities.HienThiBaoCao[0];
dgvBaoCaoNhap.DataSource = lay;
fixDatagridview();
}
}
/// <summary>
/// tim kiem
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnTimKiem_Click(object sender, EventArgs e)
{
try
{
//gan gia tri khoi tao===================================
hang = null;
nhom = null;
nhacungcap = null;
khachhangtralai = null;
banbuon = null;
banle = null;
//=======================================================
string thang = cbxThang.SelectedItem.ToString();
string nam = cbxNam.SelectedItem.ToString();
//=======================================================
switch (reportName)
{
case "BaoCaoNhapTheoKhoHang":
{
this.Enabled = false;
TimTheo_KhoHang(thang, nam);
this.Enabled = true;
if (khohang.Length > 0)
{
this.Enabled = false;
LocKhoHang();
this.Enabled = true;
}
else
{
MessageBox.Show("Không có dữ liệu"); khohang = null;
Entities.HienThiBaoCao[] lay = new Entities.HienThiBaoCao[0];
dgvBaoCaoNhap.DataSource = lay;
fixDatagridview();
this.Enabled = true;
}
} break;
//=============================================================================
case "BaoCaoNhapTheoNhomHang":
{
this.Enabled = false;
LayNhomHang("NhomHang", "MaNhomHang", "TenNhomHang");
LayHangHoa("HangHoa", "MaHangHoa", "MaNhomHangHoa");
TimTheo_NhomHang(thang, nam);
this.Enabled = true;
if (nhomhang.Length > 0)
{
this.Enabled = false;
LocXuatNhapTonNhomHang();
this.Enabled = true;
}
else
{
Entities.HienThiBaoCao[] g = new Entities.HienThiBaoCao[0];
dgvBaoCaoNhap.DataSource = g;
fixDatagridviewNhom();
MessageBox.Show("Không có dữ liệu");
this.Enabled = true;
}
} break;
//=============================================================================
case "BaoCaoNhapTheoMatHang":
{
this.Enabled = false;
TimTheo_MatHang(thang, nam);
this.Enabled = true;
if (mathang.Length > 0)
{
this.Enabled = false;
LocMatHang();
this.Enabled = true;
}
else
{
MessageBox.Show("Không có dữ liệu"); mathang = null;
Entities.HienThiBaoCao[] lay = new Entities.HienThiBaoCao[0];
dgvBaoCaoNhap.DataSource = lay;
fixDatagridview();
this.Enabled = true;
}
} break;
//=============================================================================
case "XuatNhapTonTheoNhomHang":
{
this.Enabled = false;
BindingData(thang, nam);
Tim_XuatNhapTonTheoNhom(thang, nam);
this.Enabled = true;
if (nhomhang.Length > 0)
{
this.Enabled = false;
LocXuatNhapTonNhomHang();
this.Enabled = true;
}
else
{
Entities.HienThiBaoCao[] g = new Entities.HienThiBaoCao[0];
dgvBaoCaoNhap.DataSource = g;
fixDatagridviewNhom();
MessageBox.Show("Không có dữ liệu");
this.Enabled = true;
}
} break;
//=============================================================================
default: { MessageBox.Show("Không tìm thấy tên báo cáo"); this.Close(); } break;
}
}
catch (Exception ex)
{
string s = ex.Message;
this.Enabled = true;
}
}
/// <summary>
///
/// </summary>
private void LocXuatNhapTonNhomHang()
{
try
{
Entities.HienThiBaoCao[] hienthi = null;
if (nhom.Length > 0)
{
ArrayList list = new ArrayList();
for (int k = 0; k < nhom.Length; k++)
{
Entities.HienThiBaoCao lay = new Entities.HienThiBaoCao();
lay.STT = "Select";
lay.Ma = nhom[k].Khoachinh;
lay.Ten = nhom[k].Giatri;
int sl = 0;
for (int j = 0; j < nhom.Length; j++)
{
if (nhom[k].Khoachinh == hang[j].Giatri)
{
for (int f = 0; f < nhomhang.Length; f++)
{
if (hang[j].Giatri == nhomhang[f].MaHangHoa)
{
sl += int.Parse(nhomhang[f].SoLuong);
}
else
{ continue; }
}
}
else
{ continue; }
}
lay.Soluong = sl.ToString();
list.Add(lay);
}
int n = list.Count;
if (n == 0) { hienthi = null; }
hienthi = new Entities.HienThiBaoCao[n];
for (int i = 0; i < n; i++)
{
hienthi[i] = (Entities.HienThiBaoCao)list[i];
}
if (hienthi.Length > 0)
{
dgvBaoCaoNhap.DataSource = hienthi;
// LayThongTinNhom(hienthi);
}
else
{
Entities.HienThiBaoCao[] g = new Entities.HienThiBaoCao[0];
dgvBaoCaoNhap.DataSource = g;
}
fixDatagridviewNhom();
}
}
catch (Exception ex)
{
string s = ex.Message;
Entities.HienThiBaoCao[] g = new Entities.HienThiBaoCao[0];
dgvBaoCaoNhap.DataSource = g;
fixDatagridviewNhom();
}
}
