// Hàm tự viết // Xóa đơn hàng public void Xoa(DonDH ddh) { string sql = "Delete DonDH where MaDonDH=@MaDonDH"; SqlParameter madondh = new SqlParameter("@MaDonDH", ddh.MaDonDH); SqlDatabase.ExecuteNonQuery(sql, CommandType.Text, madondh); }
public List <DonDH> TimKiem_TinhTrang(string tinhtrang) { List <DonDH> data = new List <DonDH>(); string sql = string.Format("select * from DonDH where TinhTrang=N'{0}'", tinhtrang); SqlDataReader rd = SqlDatabase.ExecuteQueryWithDataReader(sql, CommandType.Text); if (rd.HasRows) { while (rd.Read()) { DonDH ddh = new DonDH() { DonDH_ID = int.Parse(rd[0].ToString()), MaDonDH = rd[1].ToString(), HoTenKH = rd[2].ToString(), DiaChi = rd[3].ToString(), DienThoai = rd[4].ToString(), Email = rd[5].ToString(), NgayDat = DateTime.Parse(rd[6].ToString()), NgayGiao = DateTime.Parse(rd[7].ToString()), GhiChu = rd[8].ToString(), TinhTrang = rd[9].ToString(), TongTien = float.Parse(rd[10].ToString()) }; data.Add(ddh); } } return(data); }
public void SuaTongTien(DonDH ddh) { string sql = "update DonDH set TongTien=@TongTien where MaDonDH=@MaDonDH"; SqlParameter madondh = new SqlParameter("@MaDonDH", ddh.MaDonDH); SqlParameter tongtien = new SqlParameter("@TongTien", ddh.TongTien); SqlDatabase.ExecuteNonQuery(sql, CommandType.Text, madondh, tongtien); }
// Hàm tự viết // Cập nhật tình trạng đơn hàng public void SuaTinhTrang(DonDH ddh) { string sql = "update DonDH set TinhTrang=@TinhTrang where MaDonDH=@MaDonDH"; SqlParameter madondh = new SqlParameter("@MaDonDH", ddh.MaDonDH); SqlParameter tinhtrang = new SqlParameter("@TinhTrang", ddh.TinhTrang); SqlDatabase.ExecuteNonQuery(sql, CommandType.Text, madondh, tinhtrang); }
public List<DonDH> HienThiDonDH() { List<DonDH> data = new List<DonDH>(); string sql = "select * from DonDH"; SqlDataReader rd = SqlDatabase.ExecuteQueryWithDataReader(sql, CommandType.Text); if (rd.HasRows) // kiem tra xem co rows nao k { while (rd.Read()) { DonDH ddh = new DonDH() { DonDH_ID = int.Parse(rd[0].ToString()), MaDonDH = rd[1].ToString(), HoTenKH = rd[2].ToString(), DiaChi = rd[3].ToString(), DienThoai = rd[4].ToString(), Email = rd[5].ToString(), NgayDat = DateTime.Parse(rd[6].ToString()), NgayGiao = DateTime.Parse(rd[7].ToString()), GhiChu = rd[8].ToString(), TinhTrang = rd[9].ToString(), TongTien = float.Parse(rd[10].ToString()) }; data.Add(ddh); } } return data; }
public void Them(DonDH ddh) { string sql = "insert into DonDH values(@MaDonDH,@HoTenKH,@DiaChi,@DienThoai,@Email,@NgayDat,@NgayGiao,@GhiChu,@TinhTrang,@TongTien,@ID_NguoiDung)"; SqlParameter madondh = new SqlParameter("@MaDonDH", ddh.MaDonDH); SqlParameter hotenkh = new SqlParameter("@HoTenKH", ddh.HoTenKH); SqlParameter diachi = new SqlParameter("@DiaChi", ddh.DiaChi); SqlParameter dienthoai = new SqlParameter("@DienThoai", ddh.DienThoai); SqlParameter email = new SqlParameter("@Email", ddh.Email); SqlParameter ngaydat = new SqlParameter("@NgayDat", ddh.NgayDat); SqlParameter ngaygiao = new SqlParameter("@NgayGiao", ddh.NgayGiao); SqlParameter ghichu = new SqlParameter("@GhiChu", ddh.GhiChu); SqlParameter tinhtrang = new SqlParameter("@TinhTrang", ddh.TinhTrang); SqlParameter tongtien = new SqlParameter("@TongTien", ddh.TongTien); SqlParameter iD_NguoiDung = new SqlParameter("@ID_NguoiDung", ddh.ID_NguoiDung); SqlDatabase.ExecuteNonQuery(sql, CommandType.Text, madondh, hotenkh, diachi, dienthoai, email, ngaydat, ngaygiao, ghichu, tinhtrang, tongtien, iD_NguoiDung); }
public List<DonDH> TimKiem(string madondh, DateTime ngaydat) { List<DonDH> data = new List<DonDH>(); string sql = ""; if (madondh != "") { sql = string.Format("select * from DonDH where MaDonDH='{0}'", madondh); } else { sql = string.Format("select * from DonDH where NgayDat='{0}'", ngaydat); } SqlDataReader rd = SqlDatabase.ExecuteQueryWithDataReader(sql, CommandType.Text); if (rd.HasRows) { while (rd.Read()) { DonDH ddh = new DonDH() { DonDH_ID = int.Parse(rd[0].ToString()), MaDonDH = rd[1].ToString(), HoTenKH = rd[2].ToString(), DiaChi = rd[3].ToString(), DienThoai = rd[4].ToString(), Email = rd[5].ToString(), NgayDat = DateTime.Parse(rd[6].ToString()), NgayGiao = DateTime.Parse(rd[7].ToString()), GhiChu = rd[8].ToString(), TinhTrang = rd[9].ToString(), TongTien = float.Parse(rd[10].ToString()) }; data.Add(ddh); } } return data; }