public List<DTODSDonHang> LayDSCongNoBH()
{
List<DTODSDonHang> ds = new List<DTODSDonHang>();
string lenh = "Select * from DonDH dh, KhachHang kh, LoaiKH l, ThanhToan tt where dh.MaDH=tt.MaDH and dh.CongNoDH > 0 and dh.TrangThai!=N'Đóng' and dh.MaKH=kh.MaKH and kh.MaLKH=l.MaLKH";
ketnoi.TaoKetNoi();
DataTable bang = new DataTable();
try
{
ketnoi.LenhKetNoi = new SqlCommand(lenh, ketnoi.KetNoi);
//dong bo lenh ket noi voi du lieu trong database
ketnoi.TichHopCSDL = new SqlDataAdapter(ketnoi.LenhKetNoi);
ketnoi.TichHopCSDL.Fill(bang);
foreach (DataRow dongDL in bang.Rows)
{
DTODSDonHang dtoct = new DTODSDonHang(dongDL);
ds.Add(dtoct);
}
}
catch
{
throw;
}
finally
{
ketnoi.DongKetNoi();
}
return ds;
}
public DTODSDonHang PhieuGiaoHang(string ma)
{
ketnoi.TaoKetNoi();
DTODSDonHang dtoDH = null;
try
{
string lenh = "Select * from DonDH dh, KhachHang kh, LoaiKH l, ThanhToan tt where dh.MaKH=kh.MaKH and kh.MaLKH=l.MaLKH and dh.MaDH=tt.MaDH and dh.MaDH=@ma";
ketnoi.LenhKetNoi = new SqlCommand(lenh, ketnoi.KetNoi);
ketnoi.LenhKetNoi.Parameters.Add("@ma", SqlDbType.VarChar);
ketnoi.LenhKetNoi.Parameters["@ma"].Value = ma;
DataTable bang = new DataTable();
ketnoi.TichHopCSDL = new SqlDataAdapter(ketnoi.LenhKetNoi);
ketnoi.TichHopCSDL.Fill(bang);
DataRow dong = bang.Rows[0];
dtoDH = new DTODSDonHang(dong);
}
catch (Exception)
{
throw;
}
finally
{
ketnoi.DongKetNoi();
}
return dtoDH;
}
