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; }