private void FrmTongQuan_Load(object sender, EventArgs e)
{
HDBanBUS bus = new HDBanBUS();
HDBanDTO dto = bus.DemMaHDBan();
txtDemHDB.Text = dto.MaHDBan;
//Load SO HD Nhap
HDNhapBUS bus1 = new HDNhapBUS();
HDNhapDTO dto1 = bus1.DemMaHDNhap();
txtDemHDN.Text = dto1.MaHDNhap;
//Load TongSP Da Ban
SanPhamBUS bus2 = new SanPhamBUS();
SP_CTHDBDTO dto2 = bus2.TongSoSPBan();
txtTongSPBan.Text = dto2.SLSP.ToString();
//Load TongSP Da Nhap
SanPhamBUS bus3 = new SanPhamBUS();
SP_CTHDN_LSP_HDN dto3 = bus3.TongSoSPNhap();
txtTongSPDaNhap.Text = dto3.TongSL.ToString();
//Load HD huy
HDBanBUS bus4 = new HDBanBUS();
HDBanDTO dto4 = bus4.DemSoHDHuy();
txtTongSPDaNhap.Text = dto4.MaHDBan.ToString();
//loadTongDoanhThu
HDBanBUS bus5 = new HDBanBUS();
HDBanDTO dto5 = bus5.TongDoanhThuTrongNgay();
txtTongDT.Text = dto5.TongTien.ToString("#.##");
}
public SP_CTHDN_LSP_HDN TongSPNhap()
{
SP_CTHDN_LSP_HDN dto = null;
string truyvan = "EXEC dbo.Proc_DemSoSPDaNhap ";
SqlConnection con = DataProvider.TaoKetNoi();
SqlDataReader sr = DataProvider.TruyVanDuLieu(truyvan, con);
while (sr.Read())
{
dto = new SP_CTHDN_LSP_HDN();
dto.TongSL = int.Parse(sr["SOSP"].ToString());
}
sr.Close();
con.Close();
return(dto);
}
public List <SP_CTHDN_LSP_HDN> LOADCTHDXUAT(string mahdn)
{
List <SP_CTHDN_LSP_HDN> ls = new List <SP_CTHDN_LSP_HDN>();
string truyvan = " select sp.TenSP , lsp.TenLoaiSP,ct.* From SAN_PHAM sp , CHI_TIET_HDNHAP ct , LOAI_SAN_PHAM lsp WHERE sp.MaSP = ct.MaSP AND sp.MaLoaiSP = lsp.MaLoaiSP And MaHDNhap= '" + mahdn + "' ";
SqlConnection con = DataProvider.TaoKetNoi();
SqlDataReader sr = DataProvider.TruyVanDuLieu(truyvan, con);
while (sr.Read())
{
SP_CTHDN_LSP_HDN dto = new SP_CTHDN_LSP_HDN();
dto.MaHDN = sr["MaHDNhap"].ToString();
dto.TenLoaiSP = sr["TenLoaiSP"].ToString();
dto.TongSL = int.Parse(sr["SoLuong"].ToString());
dto.DonGia = double.Parse(sr["DonGia"].ToString());
dto.TenSP = sr["TenSP"].ToString();
if (dto.MaHDN == mahdn)
{
ls.Add(dto);
}
}
sr.Close();
con.Close();
return(ls);
}
