private void Lay_danh_sach_qc_cua_website()
{
XmlDocument Tai_lieu1 = new XmlDocument();
XmlElement website = null;
string arr_quangcao = "";
Tai_lieu1.Load(Server.MapPath("WEBSITE.xml"));
website = Tai_lieu1.DocumentElement;
String strExp = "//WEBSITE//ThongTin[@Ten='" + Request["Ten_website"] + "']";
XmlNode nodeAdv = website.SelectSingleNode(strExp);
XL_THE Kq = new XL_THE("QUANG_CAO");
if (nodeAdv != null)
{
foreach (XmlNode node in nodeAdv.ChildNodes)
{
string ten_quang_cao = node.Attributes["Ten"].Value.ToString();
XmlDocument Tai_lieu = new XmlDocument();
XmlElement Quang_cao = null;
Tai_lieu.Load(Server.MapPath("QUANG_CAO.xml"));
Quang_cao = Tai_lieu.DocumentElement;
String strExp1 = "//QUANG_CAO//ThongTin[@Ten='" + ten_quang_cao + "']";
XmlNode _node = Quang_cao.SelectSingleNode(strExp1);
if (_node.Attributes["TinhTrang"].Value.ToString() == "1")
{
XL_THE Kq1 = new XL_THE("ThongTin");
//arr_quangcao += ten_quang_cao + "-";
XL_THUOC_TINH Thuoc_tinh = new XL_THUOC_TINH("Logo", _node.Attributes["Logo"].Value.ToString());
Kq1.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Thuoc_tinh = new XL_THUOC_TINH("Website", _node.Attributes["Website"].Value.ToString());
Kq1.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Kq.Danh_sach_the.Add(Kq1);
}
}
}
XL_CHUOI.XuatXML(Response, Kq.Chuoi());
}
protected void LayDSHTKM()
{
HinhThucKhuyenMaiDTO[] DsHTKM = htkmBus.LayDanhSachHTKM();
XL_THE Kq = new XL_THE("DANH_SACH");
for (int i = 0; i < DsHTKM.Length; i++)
{
XL_THE Kq1 = new XL_THE("HinhThucKhuyenMai");
HinhThucKhuyenMaiDTO htkm = DsHTKM[i];
XL_THUOC_TINH Thuoc_tinh = new XL_THUOC_TINH("MaHinhThucKhuyenMai", htkm.Ma_hinh_thuc_khuyen_mai.ToString());
Kq1.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Thuoc_tinh = new XL_THUOC_TINH("TenHinhThucKhuyenMai", htkm.Ten_hinh_thuc_khuyen_mai);
Kq1.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Kq.Danh_sach_the.Add(Kq1);
}
XL_CHUOI.XuatXML(Response, Kq.Chuoi());
}
protected void LayDSHTTT()
{
HinhThucThanhToanDTO[] DsHTTT = htttBus.LayDanhSachHTTT();
XL_THE Kq = new XL_THE("DANH_SACH");
for (int i = 0; i < DsHTTT.Length; i++)
{
XL_THE Kq1 = new XL_THE("HinhThucThanhToan");
HinhThucThanhToanDTO HTTT = DsHTTT[i];
XL_THUOC_TINH Thuoc_tinh = new XL_THUOC_TINH("MaHinhThucThanhToan", HTTT.Mahinh_thuc_tt.ToString());
Kq1.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Thuoc_tinh = new XL_THUOC_TINH("TenHinhThucThanhToan", HTTT.Ten_hinh_thuc_tt);
Kq1.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Kq.Danh_sach_the.Add(Kq1);
}
XL_CHUOI.XuatXML(Response, Kq.Chuoi());
}
private void LayDSThucDon()
{
ThucDonYeuDauBUS tdydBus = new ThucDonYeuDauBUS();
ThucDonUaThich[] arr = tdydBus.LayDSThucDonYeuThich(int.Parse(Session["MaNguoiDung"].ToString()));
if (arr == null)
{
return;
}
XL_THE Kq = new XL_THE("DANH_SACH");
for (int i = 0; i < arr.Length; i++)
{
XL_THE Kq1 = new XL_THE("ThucDon");
ThucDonUaThich ThucDonUT = (ThucDonUaThich)arr[i];
ThucDonDTO thucdon = thucdonbus.ChiTietThucDon(ThucDonUT.Ma_thuc_don);
//ThucDonDTO thucdon = thucdonbus.ChiTietThucDon((int)arr[i]);
XL_THUOC_TINH Thuoc_tinh = new XL_THUOC_TINH("Ma_thuc_don", thucdon.Ma_thuc_don.ToString());
Kq1.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Thuoc_tinh = new XL_THUOC_TINH("Ten_thuc_don", thucdon.Ten_thuc_don);
Kq1.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Thuoc_tinh = new XL_THUOC_TINH("Hinh_anh_minh_hoa", thucdon.Hinh_anh_minh_hoa);
Kq1.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Thuoc_tinh = new XL_THUOC_TINH("Gia", thucdon.Gia.ToString());
Kq1.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Thuoc_tinh = new XL_THUOC_TINH("Tinh_trang", thucdon.Tinh_trang.ToString());
Kq1.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Thuoc_tinh = new XL_THUOC_TINH("Diem_binh_chon", thucdon.Diem_binh_chon.ToString());
Kq1.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Kq.Danh_sach_the.Add(Kq1);
}
XL_CHUOI.XuatXML(Response, Kq.Chuoi());
}
private void LuuThamSo()
{
ThamSoBUS bus = new ThamSoBUS();
ThamSoDTO dto = new ThamSoDTO();
dto.GiaTriDiemSo = decimal.Parse(Request["GiaTriDiemSo"].ToString());
dto.DiemKhachHangThanThiet = int.Parse(Request["DiemKhachHangThanThiet"].ToString());
dto.TiLeGiamGiaThucDon = float.Parse(Request["TiLeGiamGiaThucDon"].ToString()) / 100;
dto.Thue = float.Parse(Request["Thue"].ToString()) / 100;
dto.GiaTriDoiDiemKhuyenMai = decimal.Parse(Request["GiaTriDoiDiemKhuyenMai"].ToString());
dto.GioiHanDoiDiemKhuyenMai = float.Parse(Request["GioiHanDoiDiemKhuyenMai"].ToString()) / 100;
bool flag = bus.LuuThamSo(dto);
XL_THE the = new XL_THE("goc");
XL_THUOC_TINH thuoctinh = new XL_THUOC_TINH("kq", flag ? "1" : "0");
the.Danh_sach_thuoc_tinh.Add(thuoctinh);
string chuoi = the.Chuoi();
XL_CHUOI.XuatChuoi(Response, chuoi);
}
private void Chi_tiet_mon_an()
{
int ma_mon = int.Parse(Session["MaMon"].ToString());
//oFFS_BUS_WS.WebService service = new oFFS_BUS_WS.WebService();
MonAnBUS monanBUS = new MonAnBUS();
MonAnDTO MonAn = monanBUS.ChiTietMonAn(ma_mon);
XL_THE Kq = new XL_THE("DANH_SACH");
XL_THE Kq1 = new XL_THE("MonAn");
XL_THUOC_TINH Thuoc_tinh = new XL_THUOC_TINH("Ma_mon", MonAn.Ma_mon.ToString());
Kq1.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Thuoc_tinh = new XL_THUOC_TINH("Ten_mon", MonAn.Ten_mon);
Kq1.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Thuoc_tinh = new XL_THUOC_TINH("Hinh_anh_minh_hoa", MonAn.Hinh_anh_minh_hoa);
Kq1.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Thuoc_tinh = new XL_THUOC_TINH("Mo_ta", MonAn.Mo_ta);
Kq1.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Thuoc_tinh = new XL_THUOC_TINH("Diem_binh_chon", MonAn.Diem_binh_chon.ToString());
Kq1.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Thuoc_tinh = new XL_THUOC_TINH("Don_vi_tinh", MonAn.Don_vi_tinh);
Kq1.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Thuoc_tinh = new XL_THUOC_TINH("Gia", MonAn.Gia.ToString());
Kq1.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Thuoc_tinh = new XL_THUOC_TINH("Ma_loai_mon", MonAn.Ma_loai_mon.ToString());
Kq1.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Thuoc_tinh = new XL_THUOC_TINH("Tinh_trang", MonAn.Tinh_trang.ToString());
Kq1.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Thuoc_tinh = new XL_THUOC_TINH("Trang_thai_hien_thi", MonAn.Trang_thai_hien_thi.ToString());
Kq1.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Kq.Danh_sach_the.Add(Kq1);
XL_CHUOI.XuatXML(Response, Kq.Chuoi());
}
private void LayDSMonAn()
{
MonAnYeuDauBUS maydBus = new MonAnYeuDauBUS();
MonAnYeuDauDTO[] arr = maydBus.LayDSMonAnYeuThich(int.Parse(Session["MaNguoiDung"].ToString()));
if (arr == null)
{
return;
}
XL_THE Kq = new XL_THE("DANH_SACH");
for (int i = 0; i < arr.Length; i++)
{
XL_THE Kq1 = new XL_THE("MonAn");
MonAnYeuDauDTO MonAnYeuDau = (MonAnYeuDauDTO)arr[i];
MonAnDTO monan = monanbus.ChiTietMonAn(MonAnYeuDau.Ma_mon);
XL_THUOC_TINH Thuoc_tinh = new XL_THUOC_TINH("Ma_mon", monan.Ma_mon.ToString());
Kq1.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Thuoc_tinh = new XL_THUOC_TINH("Ten_mon", monan.Ten_mon);
Kq1.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Thuoc_tinh = new XL_THUOC_TINH("Hinh_anh_minh_hoa", monan.Hinh_anh_minh_hoa);
Kq1.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Thuoc_tinh = new XL_THUOC_TINH("Gia", monan.Gia.ToString());
Kq1.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Thuoc_tinh = new XL_THUOC_TINH("Tinh_trang", monan.Tinh_trang.ToString());
Kq1.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Thuoc_tinh = new XL_THUOC_TINH("Diem_binh_chon", monan.Diem_binh_chon.ToString());
Kq1.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Kq.Danh_sach_the.Add(Kq1);
}
XL_CHUOI.XuatXML(Response, Kq.Chuoi());
}
protected void ThemThucDon()
{
ThucDonDTO dto = new ThucDonDTO();
dto.Ten_thuc_don = XL_CHUOI.Nhap(Request, "ten");
dto.Ma_loai_thuc_don = int.Parse(XL_CHUOI.Nhap(Request, "maloai"));
dto.Mo_ta = XL_CHUOI.Nhap(Request, "mota");
dto.Hinh_anh_minh_hoa = XL_CHUOI.Nhap(Request, "hinhanh");
dto.Gia = decimal.Parse(XL_CHUOI.Nhap(Request, "gia"));
dto.Tinh_trang = bool.Parse(XL_CHUOI.Nhap(Request, "tinhtrang"));
dto.Trang_thai_hien_thi = bool.Parse(XL_CHUOI.Nhap(Request, "hienthi"));
String strTag = XL_CHUOI.Nhap(Request, "tag");
String strDsMaMonAn = XL_CHUOI.Nhap(Request, "dsmamonan");
String[] M = strDsMaMonAn.Split(new String[] { "-" }, StringSplitOptions.RemoveEmptyEntries);
ThucDonBUS bus = new ThucDonBUS();
int Kq = bus.ThemThucDon(dto, M, strTag);
XL_THE the = new XL_THE("goc");
XL_THUOC_TINH thuoc_tinh;
if (Kq != 0)
{
thuoc_tinh = new XL_THUOC_TINH("kq", "true");
}
else
{
thuoc_tinh = new XL_THUOC_TINH("kq", "false");
}
the.Danh_sach_thuoc_tinh.Add(thuoc_tinh);
string chuoi = the.Chuoi();
XL_CHUOI.XuatChuoi(Response, chuoi);
}
private void Lay_danh_sach()
{
ThucDonBUS thucdonBUS = new ThucDonBUS();
ThucDonDTO[] DsThucDon = thucdonBUS.DanhSachThucDon();
XL_THE Kq = new XL_THE("DANH_SACH");
for (int i = 0; i < DsThucDon.Length; i++)
{
XL_THE Kq1 = new XL_THE("ThucDon");
ThucDonDTO ThucDon = DsThucDon[i];
if (ThucDon.Trang_thai_hien_thi == false)
{
continue;
}
XL_THUOC_TINH Thuoc_tinh = new XL_THUOC_TINH("Ma_thuc_don", ThucDon.Ma_thuc_don.ToString());
Kq1.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Thuoc_tinh = new XL_THUOC_TINH("Ten_thuc_don", ThucDon.Ten_thuc_don);
Kq1.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Thuoc_tinh = new XL_THUOC_TINH("Hinh_anh_minh_hoa", ThucDon.Hinh_anh_minh_hoa);
Kq1.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Thuoc_tinh = new XL_THUOC_TINH("Gia", ThucDon.Gia.ToString());
Kq1.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Thuoc_tinh = new XL_THUOC_TINH("Ma_loai_thuc_don", ThucDon.Ma_loai_thuc_don.ToString());
Kq1.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Thuoc_tinh = new XL_THUOC_TINH("Tinh_trang", ThucDon.Tinh_trang.ToString());
Kq1.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Thuoc_tinh = new XL_THUOC_TINH("Trang_thai_hien_thi", ThucDon.Trang_thai_hien_thi.ToString());
Kq1.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Kq.Danh_sach_the.Add(Kq1);
}
XL_CHUOI.XuatXML(Response, Kq.Chuoi());
}
private void DS_thuc_don_theo_tag()
{
TagThucDonBUS tagthucdonBUS = new TagThucDonBUS();
ThucDonDTO[] dsThucDon = tagthucdonBUS.DSThucDonTheoTag(int.Parse(Session["Tag"].ToString()));
XL_THE Kq = new XL_THE("DANH_SACH");
for (int i = 0; i < dsThucDon.Length; i++)
{
XL_THE Kq1 = new XL_THE("ThucDon");
ThucDonDTO ThucDon = dsThucDon[i];
if (ThucDon.Trang_thai_hien_thi == false)
{
continue;
}
XL_THUOC_TINH Thuoc_tinh = new XL_THUOC_TINH("Ma_thuc_don", ThucDon.Ma_thuc_don.ToString());
Kq1.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Thuoc_tinh = new XL_THUOC_TINH("Ten_thuc_don", ThucDon.Ten_thuc_don);
Kq1.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Thuoc_tinh = new XL_THUOC_TINH("Hinh_anh_minh_hoa", ThucDon.Hinh_anh_minh_hoa);
Kq1.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Thuoc_tinh = new XL_THUOC_TINH("Gia", ThucDon.Gia.ToString());
Kq1.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Thuoc_tinh = new XL_THUOC_TINH("Ma_loai_thuc_don", ThucDon.Ma_loai_thuc_don.ToString());
Kq1.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Thuoc_tinh = new XL_THUOC_TINH("Tinh_trang", ThucDon.Tinh_trang.ToString());
Kq1.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Thuoc_tinh = new XL_THUOC_TINH("Trang_thai_hien_thi", ThucDon.Trang_thai_hien_thi.ToString());
Kq1.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Kq.Danh_sach_the.Add(Kq1);
}
XL_CHUOI.XuatXML(Response, Kq.Chuoi());
}
public void LayDSTenThucDon()
{
ThucDonBUS bus = new ThucDonBUS();
ThucDonDTO[] DsThucDon = bus.DanhSachThucDon();
XL_THE Kq = new XL_THE("DANH_SACH");
for (int i = 0; i < DsThucDon.Length; i++)
{
XL_THE Kq1 = new XL_THE("ThucDon");
ThucDonDTO dto = DsThucDon[i];
XL_THUOC_TINH Thuoc_tinh = new XL_THUOC_TINH("MaThucDon", dto.Ma_thuc_don.ToString());
Kq1.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Thuoc_tinh = new XL_THUOC_TINH("TenThucDon", dto.Ten_thuc_don);
Kq1.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Kq.Danh_sach_the.Add(Kq1);
}
XL_CHUOI.XuatXML(Response, Kq.Chuoi());
}
protected void DsThucDonThuocLoaiThucDon()
{
ThucDonBUS thuc_donBUS = new ThucDonBUS();
ArrayList dsThucDon = thuc_donBUS.LayDSThucDonThuocLoaiThucDonBatKy(int.Parse(Session["LoaiThucDon"].ToString()));
XL_THE Kq = new XL_THE("DANH_SACH");
for (int i = 0; i < dsThucDon.Count; i++)
{
XL_THE Kq1 = new XL_THE("ThucDon");
ThucDonDTO ThucDon = (ThucDonDTO)dsThucDon[i];
if (ThucDon.Trang_thai_hien_thi == false)
{
continue;
}
XL_THUOC_TINH Thuoc_tinh = new XL_THUOC_TINH("Ma_thuc_don", ThucDon.Ma_thuc_don.ToString());
Kq1.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Thuoc_tinh = new XL_THUOC_TINH("Ten_thuc_don", ThucDon.Ten_thuc_don);
Kq1.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Thuoc_tinh = new XL_THUOC_TINH("Hinh_anh_minh_hoa", ThucDon.Hinh_anh_minh_hoa);
Kq1.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Thuoc_tinh = new XL_THUOC_TINH("Gia", ThucDon.Gia.ToString());
Kq1.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Thuoc_tinh = new XL_THUOC_TINH("Ma_loai_thuc_don", ThucDon.Ma_loai_thuc_don.ToString());
Kq1.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Thuoc_tinh = new XL_THUOC_TINH("Tinh_trang", ThucDon.Tinh_trang.ToString());
Kq1.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Thuoc_tinh = new XL_THUOC_TINH("Trang_thai_hien_thi", ThucDon.Trang_thai_hien_thi.ToString());
Kq1.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Kq.Danh_sach_the.Add(Kq1);
}
XL_CHUOI.XuatXML(Response, Kq.Chuoi());
}
protected void LayDanhSach()
{
TagDTO[] ds = tag.LayDanhSachTag();
XL_THE Kq = new XL_THE("DANH_SACH");
for (int i = 0; i < ds.Length; i++)
{
XL_THE Kq1 = new XL_THE("Tag");
TagDTO dto = ds[i];
XL_THUOC_TINH Thuoc_tinh = new XL_THUOC_TINH("Ma_tag", dto.Ma_tag.ToString());
Kq1.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Thuoc_tinh = new XL_THUOC_TINH("Ten_tag", dto.Ten_tag);
Kq1.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Thuoc_tinh = new XL_THUOC_TINH("Do_uu_tien", dto.Do_uu_tien.ToString());
Kq1.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Kq.Danh_sach_the.Add(Kq1);
}
XL_CHUOI.XuatXML(Response, Kq.Chuoi());
}
protected void ThemMonMoi()
{
MonAnDTO monanDTO = new MonAnDTO();
monanDTO.Ten_mon = XL_CHUOI.Nhap(Request, "tenmon");
monanDTO.Ma_loai_mon = int.Parse(XL_CHUOI.Nhap(Request, "loaimon"));
monanDTO.Hinh_anh_minh_hoa = XL_CHUOI.Nhap(Request, "hinhanh");
monanDTO.Mo_ta = XL_CHUOI.Nhap(Request, "mota");
monanDTO.Gia = Decimal.Parse(XL_CHUOI.Nhap(Request, "gia"));
monanDTO.Don_vi_tinh = XL_CHUOI.Nhap(Request, "donvitinh");
String strTag = XL_CHUOI.Nhap(Request, "tag");
monanDTO.Diem_binh_chon = 0;
monanDTO.Tinh_trang = bool.Parse(XL_CHUOI.Nhap(Request, "tinhtrang"));
monanDTO.Trang_thai_hien_thi = bool.Parse(XL_CHUOI.Nhap(Request, "hienthi"));
MonAnBUS monanBUS = new MonAnBUS();
int Kq = monanBUS.ThemMonAn(monanDTO, strTag);
XL_THE the = new XL_THE("goc");
XL_THUOC_TINH thuoc_tinh;
if (Kq != 0)
{
thuoc_tinh = new XL_THUOC_TINH("kq", "true");
}
else
{
thuoc_tinh = new XL_THUOC_TINH("kq", "false");
}
the.Danh_sach_thuoc_tinh.Add(thuoc_tinh);
string chuoi = the.Chuoi();
XL_CHUOI.XuatChuoi(Response, chuoi);
}
private void LayDanhSachNguoiDung()
{
// Xử lý request
NguoiDungBUS bus = new NguoiDungBUS();
int tongSoNguoiDung = bus.TongSoNguoiDung();
int pageSize = tongSoNguoiDung;
int pageNum = 1;
NguoiDungDTO[] kq = bus.LayDanhSachNguoiDung(pageNum, pageSize);
XL_THE ds = new XL_THE("DANH_SACH");
foreach (NguoiDungDTO dto in kq)
{
XL_THE the = new XL_THE("TaiKhoan");
XL_THUOC_TINH Thuoc_tinh = new XL_THUOC_TINH("Username", dto.Username);
the.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
ds.Danh_sach_the.Add(the);
}
XL_CHUOI.XuatXML(Response, ds.Chuoi());
}
public void LayDSTenMonAn()
{
MonAnBUS monanBUS = new MonAnBUS();
MonAnDTO[] DsMonAn = monanBUS.DanhSachMonAn();
XL_THE Kq = new XL_THE("DANH_SACH");
for (int i = 0; i < DsMonAn.Length; i++)
{
XL_THE Kq1 = new XL_THE("MonAn");
MonAnDTO MonAn = DsMonAn[i];
XL_THUOC_TINH Thuoc_tinh = new XL_THUOC_TINH("MaMon", MonAn.Ma_mon.ToString());
Kq1.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Thuoc_tinh = new XL_THUOC_TINH("TenMon", MonAn.Ten_mon);
Kq1.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Kq.Danh_sach_the.Add(Kq1);
}
XL_CHUOI.XuatXML(Response, Kq.Chuoi());
}
protected void Lay_danh_sach_thuc_don_tu_tao()
{
int makhachhang = int.Parse(Session["MaNguoiDung"].ToString());
ThucDonBUS thucdonbus = new ThucDonBUS();
ThucDonCaNhanBUS thcnBus = new ThucDonCaNhanBUS();
ThucDonCaNhanDTO[] arr = thcnBus.LayDSThucDonYeuThich(makhachhang);
if (arr == null)
{
return;
}
XL_THE Kq = new XL_THE("DANH_SACH");
for (int i = 0; i < arr.Length; i++)
{
XL_THE Kq1 = new XL_THE("ThucDon");
ThucDonCaNhanDTO ThucDonCaNhan = (ThucDonCaNhanDTO)arr[i];
//ThucDonDTO thucdon = thucdonbus.ChiTietThucDon(ThucDonCaNhan.Ma_thuc_don_ca_nhan);
XL_THUOC_TINH Thuoc_tinh = new XL_THUOC_TINH("Ma_thuc_don", ThucDonCaNhan.Ma_thuc_don_ca_nhan.ToString());
Kq1.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Thuoc_tinh = new XL_THUOC_TINH("Ten_thuc_don", ThucDonCaNhan.Ten_thuc_don);
Kq1.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Thuoc_tinh = new XL_THUOC_TINH("Hinh_anh_minh_hoa", ThucDonCaNhan.Hinh_anh);
Kq1.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Thuoc_tinh = new XL_THUOC_TINH("Gia", ThucDonCaNhan.Gia.ToString());
Kq1.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Kq.Danh_sach_the.Add(Kq1);
}
XL_CHUOI.XuatXML(Response, Kq.Chuoi());
}
protected void DuyetCayLoaiMon()
{
// Xử lý request
int pageSize = 10;
if (Request["results"] != null)
{
pageSize = int.Parse((string)Request["results"]);
}
int pageNum = 1;
int startIndex = 0;
if (Request["startIndex"] != null)
{
startIndex = int.Parse((string)Request["startIndex"]);
pageNum = (startIndex / pageSize) + 1;
}
//Duyệt cây loại món
ArrayList ds = new ArrayList();
LoadLoaiMonDeQui(-1, 0, ds);
XL_THE Kq = new XL_THE("DANH_SACH");
XL_THUOC_TINH Thuoc_tinh = new XL_THUOC_TINH("totalRecords", ds.Count.ToString());
Kq.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
int n = startIndex + pageSize;
n = (n < ds.Count) ? n : ds.Count;
for (int i = startIndex; i < n; i++)
{
LoaiMonItem lmItem = (LoaiMonItem)ds[i];
XL_THE the = new XL_THE("Record");
Thuoc_tinh = new XL_THUOC_TINH("MaLoaiMon", lmItem.MaLoaiMon.ToString());
the.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Thuoc_tinh = new XL_THUOC_TINH("TenLoaiMon", lmItem.TenLoaiMon.ToString());
the.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Thuoc_tinh = new XL_THUOC_TINH("LaLoaiMonLa", lmItem.LaLoaiMonLa.ToString());
the.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
if (lmItem.LaLoaiMonLa == true)
{
Thuoc_tinh = new XL_THUOC_TINH("SoLuongMonCon", lmItem.SoLuongMonCon.ToString());
}
else
{
Thuoc_tinh = new XL_THUOC_TINH("SoLuongMonCon", "-");
}
the.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Kq.Danh_sach_the.Add(the);
}
XL_CHUOI.XuatXML(Response, Kq.Chuoi());
}
protected void Dat_hang_customer()
{
DonHangDTO donhang = new DonHangDTO();
DonHangDinhKyDTO donhangdk = new DonHangDinhKyDTO();
//Xac dinh tham so
viewKhachHangDTO vkhDto = (viewKhachHangDTO)Session["khachhang"];
donhang.Ma_khach_hang = vkhDto.Ma_nguoi_dung;
donhang.Ngay_gio_lap = DateTime.Parse(Request["Ngay_lap"].ToString());
donhang.Dia_chi_nhan = Request["Dia_chi_nhan"];
donhang.Nguoi_nhan = Request["Nguoi_nhan"];
donhang.Hinh_thuc_khuyen_mai = int.Parse(Request["HTKM"].ToString());
donhang.Tien_khuyen_mai = decimal.Parse(Request["Tien_khuyen_mai"].ToString());
donhang.Gia_tri = decimal.Parse(Request["Gia_tri"].ToString());
donhang.Ma_hinh_thuc_thanh_toan = int.Parse(Request["HTTT"].ToString());
int loaiyeucau = int.Parse(Request["Loai_yeu_cau"].ToString());
if (loaiyeucau == 0 || loaiyeucau == 1) //lưu or đặt hàng bình thường
{
donhang.Loai_don_dat_hang = 0; //don hang binh thuong
donhang.Ngay_gio_giao_hang = DateTime.Parse(Request["Ngay_giao"].ToString());
if (loaiyeucau == 0)
{
donhang.Da_dat_hang = false;
}
else
{
donhang.Da_dat_hang = true;
}
}
else if (loaiyeucau == 2 || loaiyeucau == 3) //lưu or đặt hàng định kỳ
{
donhang.Loai_don_dat_hang = 1; //đơn hàng định kỳ
if (loaiyeucau == 2)
{
donhang.Da_dat_hang = false;
}
else
{
donhang.Da_dat_hang = true;
}
donhangdk.Loai_dinh_ky = Request["Loai_dk"].ToString();
donhangdk.Ngay_bat_dau = DateTime.Parse(Request["Ngay_bd"].ToString());
donhangdk.Ngay_ket_thuc = DateTime.Parse(Request["Ngay_kt"].ToString());
if (donhangdk.Loai_dinh_ky == "Hang Tuan")
{
donhangdk.Thu_giao = Request["Thoi_gian_giao"].ToString();
}
else if (donhangdk.Loai_dinh_ky == "Hang Thang")
{
donhangdk.Ngay_giao = Request["Thoi_gian_giao"].ToString();
}
donhangdk.Gio_giao = DateTime.Parse(Request["Gio_giao"].ToString());
donhangdk.Tinh_trang = true;
}
donhang.Da_thanh_toan = false;
donhang.Da_giao_hang = false;
donhang.Tien_thue = decimal.Parse(Request["Tien_thue"].ToString());
int madonhang;
Gio_hang_online gio_hang = (Gio_hang_online)Session["Gio_hang"];
Gio_hang_online gio_qua_tang = new Gio_hang_online();
if (Session["Gio_qua_tang"] != null)
{
gio_qua_tang = (Gio_hang_online)Session["Gio_qua_tang"];
}
XL_THE the = new XL_THE("goc");
XL_THUOC_TINH thuoc_tinh;
try
{
madonhang = (new DonHangBUS()).ThemDonHang(donhang);
}
catch (Exception ex)
{
the.Danh_sach_thuoc_tinh.Add(new XL_THUOC_TINH("kq", "Dat hang loi"));
the.Danh_sach_thuoc_tinh.Add(new XL_THUOC_TINH("flag", "false"));
string chuoi = the.Chuoi();
XL_CHUOI.XuatChuoi(Response, chuoi);
return;
}
//lưu or đặt hàng định kỳ
if (donhang.Loai_don_dat_hang == 1)
{
donhangdk.Ma_don_hang = madonhang;
try
{
(new DonHangDinhKyBUS()).ThemDonHangDinhKy(donhangdk);
}
catch (Exception ex)
{
(new DonHangDinhKyBUS()).XoaDonHang(madonhang); //rollback
the.Danh_sach_thuoc_tinh.Add(new XL_THUOC_TINH("kq", "Dat hang dinh ky loi"));
the.Danh_sach_thuoc_tinh.Add(new XL_THUOC_TINH("flag", "false"));
string chuoi = the.Chuoi();
XL_CHUOI.XuatChuoi(Response, chuoi);
return;
}
}
try
{
CTDonHangDTO ctdonhang = new CTDonHangDTO();
CTDonHangBUS ctdhBUS = new CTDonHangBUS();
TagBUS tagbus = new TagBUS();
for (int i = 0; i < gio_hang.DsMonAn.Count; i++)
{
Item_online item = (Item_online)gio_hang.DsMonAn[i];
ctdonhang.Ma_don_hang = madonhang;
ctdonhang.Ma_item = item.Ma_item;
ctdonhang.So_luong = item.So_luong;
ctdonhang.Thanh_tien = item.So_luong * item.Gia;
ctdonhang.Loai_item = item.Loai_item;
ctdonhang.La_qua_tang = false;
ctdhBUS.ThemChiTietDonHang(ctdonhang);
tagbus.CapNhatDoUuTien(ctdonhang.Ma_item, ctdonhang.Loai_item);
}
if (gio_qua_tang.DsMonAn != null)
{
for (int i = 0; i < gio_qua_tang.DsMonAn.Count; i++)
{
Item_online item = (Item_online)gio_qua_tang.DsMonAn[i];
ctdonhang.Ma_don_hang = madonhang;
ctdonhang.Ma_item = item.Ma_item;
ctdonhang.So_luong = item.So_luong;
ctdonhang.Thanh_tien = item.So_luong * item.Gia;
ctdonhang.Loai_item = item.Loai_item;
ctdonhang.La_qua_tang = true;
ctdhBUS.ThemChiTietDonHang(ctdonhang);
}
}
int diemmoi = (new DonHangBUS()).CapNhatDiemKMTheoQuiDinh(donhang.Ma_khach_hang, vkhDto.Diem_khuyen_mai, donhang.Gia_tri, donhang.Tien_khuyen_mai);
vkhDto.Diem_khuyen_mai = diemmoi;
}
catch (Exception ex)
{
if (donhang.Loai_don_dat_hang == 1)
{
(new DonHangDinhKyBUS()).XoaDonHangDinhKy(madonhang); //rollback
}
else
{
(new DonHangBUS()).XoaDonHang(madonhang); //rollback
}
(new KhachHangBUS()).CapNhatDiemKhuyenMai(donhang.Ma_khach_hang, vkhDto.Diem_khuyen_mai); //rollback
the.Danh_sach_thuoc_tinh.Add(new XL_THUOC_TINH("kq", "Dat hang loi"));
the.Danh_sach_thuoc_tinh.Add(new XL_THUOC_TINH("flag", "false"));
string chuoi = the.Chuoi();
XL_CHUOI.XuatChuoi(Response, chuoi);
return;
}
//neu ko fai chon luu dh
if (donhang.Da_dat_hang == true)
{
// Dat hang thanh cong + chon thanh toan = the tin dung -> tien hanh thanh toan
int Thanh_toan = int.Parse(Request["Thanh_toan"].ToString());
if (Thanh_toan == 1)
{
WS_CardSystem.CardDTO cardDto1 = new WS_CardSystem.CardDTO();
//Neu su dung the khac
int The_khac = int.Parse(Request["The_khac"].ToString());
ThanhToanTheTinDungDTO thett = new ThanhToanTheTinDungDTO();
if (The_khac == 1)
{
thett.Ma_don_hang = madonhang; //don hang vua them
thett.Ma_loai_the = int.Parse(Request["Ma_loai_the"].ToString());
thett.So_the = Request["So_the"].ToString();
thett.Ngay_het_han = DateTime.Parse(Request["Ngay_hh"].ToString());
//them vao csdl the su dung
try
{
(new ThanhToanTheTinDungBUS()).ThemThanhToanTheTinDung(thett);
}
catch (Exception ex)
{
if (donhang.Loai_don_dat_hang == 1)
{
(new DonHangDinhKyBUS()).XoaDonHangDinhKy(madonhang); //rollback
}
else
{
(new DonHangBUS()).XoaDonHang(madonhang); //rollback
}
(new KhachHangBUS()).CapNhatDiemKhuyenMai(donhang.Ma_khach_hang, vkhDto.Diem_khuyen_mai); //rollback
the.Danh_sach_thuoc_tinh.Add(new XL_THUOC_TINH("kq", "Dat hang loi"));
the.Danh_sach_thuoc_tinh.Add(new XL_THUOC_TINH("flag", "false"));
string chuoi = the.Chuoi();
XL_CHUOI.XuatChuoi(Response, chuoi);
return;
}
//The khac
cardDto1.Code = thett.So_the;
string tenloaithe = Request["Ten_loai_the"].ToString();
cardDto1.Type = tenloaithe;
}
else
{
//the mac dinh
cardDto1.Code = vkhDto.So_the;
cardDto1.Type = vkhDto.Ten_loai_the;
}
//thanh toan
bool kq = ThanhToan(donhang.Gia_tri, the, cardDto1);
if (kq == true)
{
(new DonHangBUS()).CapNhatTrangThaiDaThanhToan(madonhang, true);
}
else
{
(new ThanhToanTheTinDungBUS()).XoaThanhToanTheTinDung(thett.Ma_don_hang);
if (donhang.Loai_don_dat_hang == 1)
{
(new DonHangDinhKyBUS()).XoaDonHangDinhKy(madonhang); //rollback
}
else
{
(new DonHangBUS()).XoaDonHang(madonhang); //rollback
}
(new KhachHangBUS()).CapNhatDiemKhuyenMai(donhang.Ma_khach_hang, vkhDto.Diem_khuyen_mai); //rollback
the.Danh_sach_thuoc_tinh.Add(new XL_THUOC_TINH("kq", "Thanh toan loi, dat hang khong thanh cong \n Vui long kiem tra lai the su dung"));
the.Danh_sach_thuoc_tinh.Add(new XL_THUOC_TINH("flag", "false"));
string chuoi = the.Chuoi();
XL_CHUOI.XuatChuoi(Response, chuoi);
return;
}
}
thuoc_tinh = new XL_THUOC_TINH("kq", "Dat hang thanh cong");
}
else
{
Session["madonhangluu"] = madonhang; //luu lại mã đh để trh khách hàng chọn đặt mua sau đó
thuoc_tinh = new XL_THUOC_TINH("kq", "Luu don hang thanh cong");
}
the.Danh_sach_thuoc_tinh.Add(thuoc_tinh);
the.Danh_sach_thuoc_tinh.Add(new XL_THUOC_TINH("flag", "true"));
XL_CHUOI.XuatChuoi(Response, the.Chuoi());
Session["Gio_qua_tang"] = null;
Session["Gio_hang"] = null;
Session["FormDatHangDinhKy"] = null;
Session["FormDatHang"] = null;
return;
}
private void LayDanhSachDonHang(int request)
{
DonHangBUS bus = new DonHangBUS();
DonHangDinhKyBUS dhdkBUS = new DonHangDinhKyBUS();
XemDanhSachDonHang[] arrFuncXemDanhSach = new XemDanhSachDonHang[]
{ bus.DanhSachDonHangDaLuu, bus.DanhSachDonHangDaDatChuaThanhToan,
bus.DanhSachDonHangDaThanhToanChuaGiao, bus.DanhSachDonHangDaHoanTat,
bus.DanhSachDonHangTrongNgay, dhdkBUS.DanhSachDonHangDinhKy };
TongDonHang[] arrFuncTongDonHang = new TongDonHang[]
{
bus.TongDonHangDaLuu, bus.TongDonHangDaDatChuaThanhToan,
bus.TongDonHangDaThanhToanChuaGiao, bus.TongDonHangDaHoanTat,
bus.TongDonHangTrongNgay, bus.TongDonHangDinhKy
};
int maKhachHang = (int)Session["MaNguoiDung"];
// Xử lý request
int pageSize = 10;
if (Request["results"] != null)
{
pageSize = int.Parse((string)Request["results"]);
}
int pageNum = 1;
if (Request["startIndex"] != null)
{
pageNum = (int.Parse((string)Request["startIndex"]) / pageSize) + 1;
}
// Lấy danh sách đơn hàng
DonHangDTO[] kq = arrFuncXemDanhSach[request](maKhachHang, pageNum, pageSize);
int tongDonHang = arrFuncTongDonHang[request](maKhachHang);
XL_THE Kq = new XL_THE("DANH_SACH");
XL_THUOC_TINH Thuoc_tinh = new XL_THUOC_TINH("totalRecords", tongDonHang.ToString());
Kq.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
foreach (DonHangDTO dto in kq)
{
XL_THE the = new XL_THE("DonHang");
Thuoc_tinh = new XL_THUOC_TINH("MaDonHang", dto.Ma_don_hang.ToString());
the.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Thuoc_tinh = new XL_THUOC_TINH("NgayGioLap", dto.Ngay_gio_lap.ToString());
the.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Thuoc_tinh = new XL_THUOC_TINH("DiaChiNhan", dto.Dia_chi_nhan);
the.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Thuoc_tinh = new XL_THUOC_TINH("NguoiNhan", dto.Nguoi_nhan);
the.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Thuoc_tinh = new XL_THUOC_TINH("NgayGioGiaoHang", dto.Ngay_gio_giao_hang.ToString());
the.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Thuoc_tinh = new XL_THUOC_TINH("GiaTri", dto.Gia_tri.ToString());
the.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
if (request == 5) // đơn hàng định kỳ
{
DonHangDinhKyDTO dhdk = (DonHangDinhKyDTO)dto;
Thuoc_tinh = new XL_THUOC_TINH("LoaiDinhKy", dhdk.Loai_dinh_ky);
the.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Thuoc_tinh = new XL_THUOC_TINH("NgayBatDau", dhdk.Ngay_bat_dau.ToString());
the.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Thuoc_tinh = new XL_THUOC_TINH("NgayKetThuc", dhdk.Ngay_ket_thuc.ToString());
the.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Thuoc_tinh = new XL_THUOC_TINH("NgayGiao", dhdk.Ngay_giao.ToString());
the.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Thuoc_tinh = new XL_THUOC_TINH("ThuGiao", dhdk.Thu_giao.ToString());
the.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Thuoc_tinh = new XL_THUOC_TINH("GioGiao", dhdk.Gio_giao.ToString());
the.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Thuoc_tinh = new XL_THUOC_TINH("TinhTrang", dhdk.Tinh_trang ? "1" : "0");
the.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
}
Kq.Danh_sach_the.Add(the);
}
XL_CHUOI.XuatXML(Response, Kq.Chuoi());
}
protected void DsMonAnThuocLoaiMonBatKy()
{
int pageSize = 5;
if (Request["results"] != null)
{
pageSize = int.Parse((string)Request["results"]);
}
int pageNum = 1;
int startIndex = 0;
if (Request["startIndex"] != null)
{
startIndex = int.Parse((string)Request["startIndex"]);
pageNum = (startIndex / pageSize) + 1;
}
MonAnBUS mon_anBUS = new MonAnBUS();
ArrayList dsMonAn = new ArrayList();
int index = 0;
int loaimon = -1;
if (Session["LoaiNguoiDung"].ToString() == "NhanVien")
{
loaimon = int.Parse((string)Request["LoaiMon"]);
}
else
{
loaimon = int.Parse(Session["LoaiMon"].ToString());
}
dsMonAn = mon_anBUS.LayDSMonAnThuocLoaiMonBatKy(loaimon);
int n = dsMonAn.Count;
XL_THE Kq = new XL_THE("DANH_SACH");
if (Session["LoaiNguoiDung"].ToString() == "NhanVien") //co phan trang
{
index = startIndex;
n = startIndex + pageSize;
n = (n < dsMonAn.Count) ? n : dsMonAn.Count;
XL_THUOC_TINH Thuoc_tinh = new XL_THUOC_TINH("totalRecords", dsMonAn.Count.ToString());
Kq.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
}
for (int i = index; i < n; i++)
{
XL_THE Kq1 = new XL_THE("MonAn");
MonAnDTO MonAn = (MonAnDTO)dsMonAn[i];
if (MonAn.Trang_thai_hien_thi == false)
{
continue;
}
XL_THUOC_TINH Thuoc_tinh = new XL_THUOC_TINH("Ma_mon", MonAn.Ma_mon.ToString());
Kq1.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Thuoc_tinh = new XL_THUOC_TINH("Ten_mon", MonAn.Ten_mon);
Kq1.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Thuoc_tinh = new XL_THUOC_TINH("Hinh_anh_minh_hoa", MonAn.Hinh_anh_minh_hoa);
Kq1.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Thuoc_tinh = new XL_THUOC_TINH("Mo_ta", MonAn.Mo_ta);
Kq1.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Thuoc_tinh = new XL_THUOC_TINH("Diem_binh_chon", MonAn.Diem_binh_chon.ToString());
Kq1.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Thuoc_tinh = new XL_THUOC_TINH("Don_vi_tinh", MonAn.Don_vi_tinh);
Kq1.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Thuoc_tinh = new XL_THUOC_TINH("Gia", MonAn.Gia.ToString());
Kq1.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Thuoc_tinh = new XL_THUOC_TINH("Ma_loai_mon", MonAn.Ma_loai_mon.ToString());
Kq1.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Thuoc_tinh = new XL_THUOC_TINH("Tinh_trang", MonAn.Tinh_trang.ToString());
Kq1.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Thuoc_tinh = new XL_THUOC_TINH("Trang_thai_hien_thi", MonAn.Trang_thai_hien_thi.ToString());
Kq1.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Kq.Danh_sach_the.Add(Kq1);
}
XL_CHUOI.XuatXML(Response, Kq.Chuoi());
}
void LayDanhSachNguoiDung()
{
// Xử lý request
int pageSize = 10;
if (Request["results"] != null)
{
pageSize = int.Parse((string)Request["results"]);
}
int pageNum = 1;
if (Request["startIndex"] != null)
{
pageNum = (int.Parse((string)Request["startIndex"]) / pageSize) + 1;
}
// Lấy thông tin toàn bộ người dùng (nhân viên, quản lý, quản trị, ...)
NguoiDungBUS bus = new NguoiDungBUS();
NguoiDungDTO[] kq = bus.LayDanhSachNguoiDung(pageNum, pageSize);
LoaiNguoiDungBUS loainguoidungbus = new LoaiNguoiDungBUS();
LoaiNguoiDungDTO[] dsLoaiNguoiDung = loainguoidungbus.LayDanhSachLoaiNguoiDung();
int tongSoNguoiDung = bus.TongSoNguoiDung();
XL_THE Kq = new XL_THE("DANH_SACH");
XL_THUOC_TINH Thuoc_tinh = new XL_THUOC_TINH("totalRecords", tongSoNguoiDung.ToString());
Kq.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
foreach (NguoiDungDTO dto in kq)
{
XL_THE the = new XL_THE("TaiKhoan");
Thuoc_tinh = new XL_THUOC_TINH("MaNguoiDung", dto.Ma_nguoi_dung.ToString());
the.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Thuoc_tinh = new XL_THUOC_TINH("Username", dto.Username);
the.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Thuoc_tinh = new XL_THUOC_TINH("HoTen", dto.Ho_ten);
the.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
int i;
string strPhanLoai = "";
for (i = 0; i < dsLoaiNguoiDung.Length; ++i)
{
if (dsLoaiNguoiDung[i].Ma_loai_nguoi_dung == dto.Ma_loai_nguoi_dung)
{
break;
}
}
if (i == dsLoaiNguoiDung.Length)
{
strPhanLoai = dto.Ma_loai_nguoi_dung.ToString() + " Không có loại người dùng tương ứng";
}
else
{
strPhanLoai = dsLoaiNguoiDung[i].Ten_loai_nguoi_dung;
}
Thuoc_tinh = new XL_THUOC_TINH("PhanLoai", strPhanLoai);
the.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Thuoc_tinh = new XL_THUOC_TINH("KichHoat", dto.Tinh_trang_kich_hoat ? "1" : "0");
the.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Kq.Danh_sach_the.Add(the);
}
XL_CHUOI.XuatXML(Response, Kq.Chuoi());
}
protected void DsMonAnThuocLoaiMon()
{
// Xử lý request
int pageSize = 5;
if (Request["results"] != null)
{
pageSize = int.Parse((string)Request["results"]);
}
int pageNum = 1;
int startIndex = 0;
if (Request["startIndex"] != null)
{
startIndex = int.Parse((string)Request["startIndex"]);
pageNum = (startIndex / pageSize) + 1;
}
MonAnBUS mon_anBUS = new MonAnBUS();
ArrayList dsMonAn = new ArrayList();
int index = 0;
int loaimon = -1;
if (Session["LoaiNguoiDung"] == "NhanVien" || Session["LoaiNguoiDung"] == "QuanLy")
{
loaimon = int.Parse((string)Request["LoaiMon"]);
}
else
{
loaimon = int.Parse(Session["LoaiMon"].ToString());
}
dsMonAn = mon_anBUS.LayDSMonAnThuocLoaiMonBatKy(loaimon);
int n = dsMonAn.Count;
XL_THE Kq = new XL_THE("DANH_SACH");
if (Session["LoaiNguoiDung"] == "NhanVien" || Session["LoaiNguoiDung"] == "QuanLy") //co phan trang
{
index = startIndex;
n = startIndex + pageSize;
n = (n < dsMonAn.Count) ? n : dsMonAn.Count;
XL_THUOC_TINH Thuoc_tinh = new XL_THUOC_TINH("totalRecords", dsMonAn.Count.ToString());
Kq.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
}
LoaiMonDTO lmDto = (new LoaiMonBUS()).ChiTietLoaiMon(loaimon); //chu íu lấy tên loại món
for (int i = index; i < n; i++)
{
XL_THE Kq1 = new XL_THE("MonAn");
MonAnDTO MonAn = (MonAnDTO)dsMonAn[i];
// if (MonAn.Trang_thai_hien_thi == false)
// continue;
XL_THUOC_TINH Thuoc_tinh = new XL_THUOC_TINH("MaMonAn", MonAn.Ma_mon.ToString());
Kq1.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Thuoc_tinh = new XL_THUOC_TINH("TenMonAn", MonAn.Ten_mon);
Kq1.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Thuoc_tinh = new XL_THUOC_TINH("LoaiMonAn", lmDto.Ten_loai_mon);
Kq1.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Thuoc_tinh = new XL_THUOC_TINH("MoTa", MonAn.Mo_ta);
Kq1.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Thuoc_tinh = new XL_THUOC_TINH("HinhAnhMinhHoa", MonAn.Hinh_anh_minh_hoa);
Kq1.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Thuoc_tinh = new XL_THUOC_TINH("Gia", MonAn.Gia.ToString());
Kq1.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Thuoc_tinh = new XL_THUOC_TINH("TrangThaiHienThi", MonAn.Trang_thai_hien_thi ? "1" : "0");
Kq1.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Thuoc_tinh = new XL_THUOC_TINH("TinhTrang", MonAn.Tinh_trang ? "1": "0");
Kq1.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Kq.Danh_sach_the.Add(Kq1);
}
XL_CHUOI.XuatXML(Response, Kq.Chuoi());
}
protected void TimKiem()
{
MonAnBUS monanBUS = new MonAnBUS();
ArrayList arr = (ArrayList)Session["info"];
MonAnDTO[] dsMonAn;
if (arr.Count == 1)
{
string ten_mon = arr[0].ToString();
dsMonAn = monanBUS.TimKiemMonAnTheoTen(ten_mon);
}
else
{
string ten_mon = "";
int ma_loai_mon = -1;
string tag = "";
double gia_min = -1;
double gia_max = -1;
if (arr[0].ToString() != "null")
{
ten_mon = arr[0].ToString();
}
if (arr[1].ToString() != "null")
{
ma_loai_mon = int.Parse(arr[1].ToString());
}
if (arr[2].ToString() != "null")
{
tag = arr[2].ToString();
}
if (arr[3].ToString() != "null")
{
gia_min = double.Parse(arr[3].ToString());
}
if (arr[4].ToString() != "null")
{
gia_max = double.Parse(arr[4].ToString());
}
dsMonAn = monanBUS.TimKiemMonAnNangCao(ten_mon, ma_loai_mon, tag, gia_min, gia_max);
}
XL_THE Kq = new XL_THE("DANH_SACH");
for (int i = 0; i < dsMonAn.Length; i++)
{
XL_THE Kq1 = new XL_THE("MonAn");
MonAnDTO MonAn = dsMonAn[i];
if (MonAn.Trang_thai_hien_thi == false)
{
continue;
}
XL_THUOC_TINH Thuoc_tinh = new XL_THUOC_TINH("Ma_mon", MonAn.Ma_mon.ToString());
Kq1.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Thuoc_tinh = new XL_THUOC_TINH("Ten_mon", MonAn.Ten_mon);
Kq1.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Thuoc_tinh = new XL_THUOC_TINH("Hinh_anh_minh_hoa", MonAn.Hinh_anh_minh_hoa);
Kq1.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Thuoc_tinh = new XL_THUOC_TINH("Mo_ta", MonAn.Mo_ta);
Kq1.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Thuoc_tinh = new XL_THUOC_TINH("Diem_binh_chon", MonAn.Diem_binh_chon.ToString());
Kq1.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Thuoc_tinh = new XL_THUOC_TINH("Don_vi_tinh", MonAn.Don_vi_tinh);
Kq1.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Thuoc_tinh = new XL_THUOC_TINH("Gia", MonAn.Gia.ToString());
Kq1.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Thuoc_tinh = new XL_THUOC_TINH("Ma_loai_mon", MonAn.Ma_loai_mon.ToString());
Kq1.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Thuoc_tinh = new XL_THUOC_TINH("Tinh_trang", MonAn.Tinh_trang.ToString());
Kq1.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Thuoc_tinh = new XL_THUOC_TINH("Trang_thai_hien_thi", MonAn.Trang_thai_hien_thi.ToString());
Kq1.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Kq.Danh_sach_the.Add(Kq1);
}
XL_CHUOI.XuatXML(Response, Kq.Chuoi());
}
private void LayThongTinDonHang()
{
DonHangBUS bus = new DonHangBUS();
int maDonHang = int.Parse(Request["MaDonHang"]);
DonHangDTO dhDTO = bus.LayThongTinDonHang(maDonHang);
XL_THE kq = new XL_THE("DonHang");
NguoiDungBUS ndBUS = new NguoiDungBUS();
NguoiDungDTO ndDTO = ndBUS.ThongTinNguoiDung(dhDTO.Ma_khach_hang);
XL_THUOC_TINH Thuoc_tinh = new XL_THUOC_TINH("TenKhachHang", ndDTO.Ho_ten);
kq.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Thuoc_tinh = new XL_THUOC_TINH("NgayGioLap", dhDTO.Ngay_gio_lap.ToString());
kq.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Thuoc_tinh = new XL_THUOC_TINH("DiaChiNhan", dhDTO.Dia_chi_nhan.ToString());
kq.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Thuoc_tinh = new XL_THUOC_TINH("NguoiNhan", dhDTO.Nguoi_nhan);
kq.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
string tinhTrang = "";
// Đã đặt hàng nhưng chưa thanh toán
if (dhDTO.Da_dat_hang == true && dhDTO.Da_thanh_toan == false && dhDTO.Da_giao_hang == false)
{
tinhTrang = "0";
}
// Đã thanh toán nhưng chưa giao hàng
else if (dhDTO.Da_dat_hang == true && dhDTO.Da_thanh_toan == true && dhDTO.Da_giao_hang == false)
{
tinhTrang = "1";
}
// Đã hoàn tất
else if (dhDTO.Da_dat_hang == true && dhDTO.Da_thanh_toan == true && dhDTO.Da_giao_hang == true)
{
tinhTrang = "2";
}
Thuoc_tinh = new XL_THUOC_TINH("NgayGioGiaoHang", tinhTrang == "2" ? dhDTO.Ngay_gio_giao_hang.ToString() : "chưa");
kq.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
HinhThucKhuyenMaiBUS htkmBus = new HinhThucKhuyenMaiBUS();
HinhThucKhuyenMaiDTO htkmDto = htkmBus.ThongTinHTKM(dhDTO.Hinh_thuc_khuyen_mai);
string tenHinhThucKhuyenMai = "Không có";
if (htkmDto != null)
{
tenHinhThucKhuyenMai = htkmDto.Ten_hinh_thuc_khuyen_mai;
}
Thuoc_tinh = new XL_THUOC_TINH("HinhThucKhuyenMai", tenHinhThucKhuyenMai);
kq.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Thuoc_tinh = new XL_THUOC_TINH("TienKhuyenMai", dhDTO.Tien_khuyen_mai.ToString());
kq.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Thuoc_tinh = new XL_THUOC_TINH("GiaTri", dhDTO.Gia_tri.ToString());
kq.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Thuoc_tinh = new XL_THUOC_TINH("TienThue", dhDTO.Tien_thue.ToString());
kq.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Thuoc_tinh = new XL_THUOC_TINH("TinhTrang", tinhTrang);
kq.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
XL_CHUOI.XuatXML(Response, kq.Chuoi());
}
void LayDanhSachThucDon()
{
// Xử lý request
int pageSize = 10;
if (Request["results"] != null)
{
pageSize = int.Parse((string)Request["results"]);
}
int pageNum = 1;
if (Request["startIndex"] != null)
{
pageNum = (int.Parse((string)Request["startIndex"]) / pageSize) + 1;
}
ThucDonBUS bus = new ThucDonBUS();
ThucDonDTO[] kq = bus.DanhSachThucDon(pageNum, pageSize);
LoaiThucDonBUS ltdBus = new LoaiThucDonBUS();
int tongSoThucDon = bus.TongSoThucDon();
XL_THE Kq = new XL_THE("DANH_SACH");
XL_THUOC_TINH Thuoc_tinh = new XL_THUOC_TINH("totalRecords", tongSoThucDon.ToString());
Kq.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
foreach (ThucDonDTO dto in kq)
{
XL_THE the = new XL_THE("ThucDon");
Thuoc_tinh = new XL_THUOC_TINH("MaThucDon", dto.Ma_thuc_don.ToString());
the.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Thuoc_tinh = new XL_THUOC_TINH("TenThucDon", dto.Ten_thuc_don);
the.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
LoaiThucDonDTO ltdDto = ltdBus.ChiTietLoaiThucDon(dto.Ma_loai_thuc_don);
Thuoc_tinh = new XL_THUOC_TINH("LoaiThucDon", ltdDto.Ten_loai_thuc_don);
the.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Thuoc_tinh = new XL_THUOC_TINH("MoTa", dto.Mo_ta);
the.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Thuoc_tinh = new XL_THUOC_TINH("HinhAnhMinhHoa", dto.Hinh_anh_minh_hoa);
the.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Thuoc_tinh = new XL_THUOC_TINH("Gia", dto.Gia.ToString());
the.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Thuoc_tinh = new XL_THUOC_TINH("TrangThaiHienThi", dto.Trang_thai_hien_thi ? "1" : "0");
the.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Thuoc_tinh = new XL_THUOC_TINH("TinhTrang", dto.Tinh_trang ? "1" : "0");
the.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Kq.Danh_sach_the.Add(the);
}
XL_CHUOI.XuatXML(Response, Kq.Chuoi());
}
private void LayThongTinDonHang()
{
DonHangBUS bus = new DonHangBUS();
int maDonHang = int.Parse(Request["MaDonHang"]);
DonHangDTO dhDTO = bus.LayThongTinDonHang(maDonHang);
XL_THE kq = new XL_THE("DonHang");
NguoiDungBUS ndBUS = new NguoiDungBUS();
NguoiDungDTO ndDTO = ndBUS.ThongTinNguoiDung(dhDTO.Ma_khach_hang);
XL_THUOC_TINH Thuoc_tinh = new XL_THUOC_TINH("TenKhachHang", ndDTO.Ho_ten);
kq.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Thuoc_tinh = new XL_THUOC_TINH("NgayGioLap", dhDTO.Ngay_gio_lap.ToString());
kq.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Thuoc_tinh = new XL_THUOC_TINH("DiaChiNhan", dhDTO.Dia_chi_nhan.ToString());
kq.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Thuoc_tinh = new XL_THUOC_TINH("NguoiNhan", dhDTO.Nguoi_nhan);
kq.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
HinhThucKhuyenMaiBUS htkmBus = new HinhThucKhuyenMaiBUS();
HinhThucKhuyenMaiDTO htkmDto = htkmBus.ThongTinHTKM(dhDTO.Hinh_thuc_khuyen_mai);
string tenHinhThucKhuyenMai = "Không có";
if (htkmDto != null)
{
tenHinhThucKhuyenMai = htkmDto.Ten_hinh_thuc_khuyen_mai;
}
Thuoc_tinh = new XL_THUOC_TINH("HinhThucKhuyenMai", tenHinhThucKhuyenMai);
kq.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Thuoc_tinh = new XL_THUOC_TINH("TienKhuyenMai", dhDTO.Tien_khuyen_mai.ToString());
kq.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Thuoc_tinh = new XL_THUOC_TINH("GiaTri", dhDTO.Gia_tri.ToString());
kq.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Thuoc_tinh = new XL_THUOC_TINH("TienThue", dhDTO.Tien_thue.ToString());
kq.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
string loai = dhDTO.Ngay_gio_giao_hang.ToString();
string ngayGioGiaoHang = "chưa có";
if (dhDTO.Loai_don_dat_hang == 1)
{
loai = "5"; // " (Đơn hàng định kỳ)";
}
else if (dhDTO.Da_dat_hang == false && dhDTO.Da_thanh_toan == false && dhDTO.Da_giao_hang == false)
{
loai = "0"; //"Đã lưu";
}
else if (dhDTO.Da_dat_hang == true && dhDTO.Da_thanh_toan == false && dhDTO.Da_giao_hang == false)
{
loai = "1"; //"Đã đặt hàng nhưng chưa thanh toán";
}
else if (dhDTO.Da_dat_hang == true && dhDTO.Da_thanh_toan == true && dhDTO.Da_giao_hang == false)
{
loai = "2"; //"Đã thanh toán nhưng chưa giao hàng";
}
else if (dhDTO.Da_dat_hang == true && dhDTO.Da_thanh_toan == true && dhDTO.Da_giao_hang == true)
{
loai = "3"; //Đã hoàn tất";
ngayGioGiaoHang = dhDTO.Ngay_gio_giao_hang.ToString();
}
else
{
loai = "4"; //Trong ngày (đã đặt hàng)";
}
if (loai == "5")
{
DonHangDinhKyBUS dhdkBus = new DonHangDinhKyBUS();
DonHangDinhKyDTO dhdk = dhdkBus.LayThongTinDonHangDinhKy(dhDTO.Ma_don_hang);
Thuoc_tinh = new XL_THUOC_TINH("LoaiDinhKy", dhdk.Loai_dinh_ky);
kq.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Thuoc_tinh = new XL_THUOC_TINH("NgayBatDau", dhdk.Ngay_bat_dau.ToString());
kq.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Thuoc_tinh = new XL_THUOC_TINH("NgayKetThuc", dhdk.Ngay_ket_thuc.ToString());
kq.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
string thoiDiem = "";
if (dhdk.Loai_dinh_ky.ToUpper().Trim() == "Tuần")
{
thoiDiem = dhdk.Thu_giao;
}
else
{
thoiDiem = dhdk.Ngay_giao;
}
Thuoc_tinh = new XL_THUOC_TINH("ThoiDiemGiao", thoiDiem);
kq.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Thuoc_tinh = new XL_THUOC_TINH("GioGiao", dhdk.Gio_giao.ToString());
kq.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Thuoc_tinh = new XL_THUOC_TINH("TinhTrang", dhdk.Tinh_trang ? "1" : "0");
kq.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
}
Thuoc_tinh = new XL_THUOC_TINH("loai", loai);
kq.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Thuoc_tinh = new XL_THUOC_TINH("NgayGioGiaoHang", ngayGioGiaoHang);
kq.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
XL_CHUOI.XuatXML(Response, kq.Chuoi());
}
private void LayCTDonHang()
{
int maDonHang = int.Parse(Request["MaDonHang"]);
XL_THE kq = new XL_THE("DanhSachCTDonHang");
CTDonHangBUS ctdhbus = new CTDonHangBUS();
CTDonHangDTO[] arrCtdhDto = ctdhbus.DanhSachCTDonHang(maDonHang);
foreach (CTDonHangDTO ctdh in arrCtdhDto)
{
XL_THE the = new XL_THE("CTDonHang");
// mã chi tiết đơn hàng
XL_THUOC_TINH Thuoc_tinh = new XL_THUOC_TINH("MaCTDonHang", ctdh.Ma_ct_don_hang.ToString());
the.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
string loai = "";
string ten = "";
switch (ctdh.Loai_item)
{
case 0: // món ăn
loai = "Món ăn";
MonAnBUS maBus = new MonAnBUS();
MonAnDTO ma = maBus.ChiTietMonAn(ctdh.Ma_item);
if (ma != null)
{
ten = ma.Ten_mon;
}
else
{
ten = "Món ăn này không tồn tại";
}
break;
case 1: // thực đơn
loai = "Thực đơn";
ThucDonBUS tdBus = new ThucDonBUS();
ThucDonDTO tdDto = tdBus.ChiTietThucDon(ctdh.Ma_item);
if (tdDto != null)
{
ten = tdDto.Ten_thuc_don;
}
else
{
ten = "Thực đơn này không tồn tại";
}
break;
case 2: // thực đơn cá nhân
loai = "Thực đơn cá nhân";
ThucDonCaNhanBUS tdcnBus = new ThucDonCaNhanBUS();
ThucDonCaNhanDTO tdcnDto = tdcnBus.ChiTietThucDonCaNhan(ctdh.Ma_item);
if (tdcnDto != null)
{
ten = tdcnDto.Ten_thuc_don;
}
else
{
ten = "Thực đơn cá nhân này không tồn tại";
}
break;
}
// Tên món hoặc tên thực đơn
Thuoc_tinh = new XL_THUOC_TINH("Ten", ten);
the.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
// Loại đơn hàng
Thuoc_tinh = new XL_THUOC_TINH("LoaiItem", loai);
the.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
// Số lượng
Thuoc_tinh = new XL_THUOC_TINH("SoLuong", ctdh.So_luong.ToString());
the.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
// Thành tiền
Thuoc_tinh = new XL_THUOC_TINH("ThanhTien", ctdh.Thanh_tien.ToString());
the.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
kq.Danh_sach_the.Add(the);
}
XL_CHUOI.XuatXML(Response, kq.Chuoi());
}
private void LayDanhSachDonHang(int request)
{
DonHangBUS bus = new DonHangBUS();
DonHangDinhKyBUS dhdkBUS = new DonHangDinhKyBUS();
XemDanhSachDonHang[] arrFuncXemDanhSach = new XemDanhSachDonHang[]
{ bus.DanhSachDonHangChuaThanhToanChuaGiao, bus.DanhSachDonHangDaThanhToanChuaGiao,
bus.DanhSachDonHangDaHoanTatTrongNgay };
TongDonHang[] arrFuncTongDonHang = new TongDonHang[]
{
bus.TongDonHangChuaThanhToanChuaGiao, bus.TongDonHangDaThanhToanChuaGiao,
bus.TongDonHangDaHoanTatTrongNgay
};
// Xử lý request
int pageSize = 10;
if (Request["results"] != null)
{
pageSize = int.Parse((string)Request["results"]);
}
int pageNum = 1;
if (Request["startIndex"] != null)
{
pageNum = (int.Parse((string)Request["startIndex"]) / pageSize) + 1;
}
// Lấy danh sách đơn hàng
DonHangDTO[] kq = arrFuncXemDanhSach[request](pageNum, pageSize);
int tongDonHang = arrFuncTongDonHang[request]();
XL_THE Kq = new XL_THE("DANH_SACH");
XL_THUOC_TINH Thuoc_tinh = new XL_THUOC_TINH("totalRecords", tongDonHang.ToString());
Kq.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
foreach (DonHangDTO dto in kq)
{
XL_THE the = new XL_THE("DonHang");
Thuoc_tinh = new XL_THUOC_TINH("MaDonHang", dto.Ma_don_hang.ToString());
the.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
NguoiDungBUS ndBus = new NguoiDungBUS();
NguoiDungDTO ndDTO = ndBus.ThongTinNguoiDung(dto.Ma_khach_hang);
Thuoc_tinh = new XL_THUOC_TINH("TenKhachHang", ndDTO.Ho_ten);
the.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Thuoc_tinh = new XL_THUOC_TINH("NgayGioLap", dto.Ngay_gio_lap.ToString());
the.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Thuoc_tinh = new XL_THUOC_TINH("DiaChiNhan", dto.Dia_chi_nhan);
the.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Thuoc_tinh = new XL_THUOC_TINH("NguoiNhan", dto.Nguoi_nhan);
the.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Thuoc_tinh = new XL_THUOC_TINH("NgayGioGiaoHang", dto.Ngay_gio_giao_hang.ToString());
the.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Thuoc_tinh = new XL_THUOC_TINH("GiaTri", dto.Gia_tri.ToString());
the.Danh_sach_thuoc_tinh.Add(Thuoc_tinh);
Kq.Danh_sach_the.Add(the);
}
XL_CHUOI.XuatXML(Response, Kq.Chuoi());
}
