public XmlElement Tao_Du_lieu_cua_Ung_dung_Quan_ly_Ban_hang() { var Chuoi_XML = Du_lieu_Dich_vu.OuterXml; var Tai_lieu = new XmlDocument(); Tai_lieu.LoadXml(Chuoi_XML); var Du_lieu = Tai_lieu.DocumentElement; var Cua_hang = (XmlElement)Du_lieu.GetElementsByTagName("Cong_ty")[0]; var Danh_sach_Nguoi_dung = (XmlElement)Cua_hang.GetElementsByTagName("Danh_sach_Nguoi_dung")[0]; var DS_Nguoi_dung = XL_NGHIEP_VU.Tao_Danh_sach(Danh_sach_Nguoi_dung, "Nguoi_dung"); foreach (XmlElement Nguoi_dung in DS_Nguoi_dung) { if (Nguoi_dung.SelectSingleNode("Nhom_Nguoi_dung/@Ma_so").Value != "QUAN_LY_BAN_HANG" && Nguoi_dung.SelectSingleNode("Nhom_Nguoi_dung/@Ma_so").Value != "BAN_HANG") { Danh_sach_Nguoi_dung.RemoveChild(Nguoi_dung);// Xóa Các Người dùng không thuộc Nhóm tương ứng } } foreach (XmlElement Lap_top in Du_lieu.GetElementsByTagName("Laptop")) { var Danh_sach_Ban_hang = (XmlElement)Lap_top.GetElementsByTagName("Danh_sach_Ban_hang")[0]; Lap_top.RemoveChild(Danh_sach_Ban_hang); var Danh_sach_Nhap_hang = (XmlElement)Lap_top.GetElementsByTagName("Danh_sach_Dat_hang")[0]; Lap_top.RemoveChild(Danh_sach_Nhap_hang); }// Xóa Tất các Nhập hàng, Bán hàng return(Du_lieu); }
public static List <XmlElement> Tao_Danh_sach_Lap_top_cua_Nguoi_dung( XmlElement Nguoi_dung, XmlElement Danh_sach_Tat_ca_Lap_top) { var Danh_sach = new List <XmlElement>(); var DS_Tat_ca_Lap_top = Tao_Danh_sach(Danh_sach_Tat_ca_Lap_top, "Laptop"); Danh_sach = DS_Tat_ca_Lap_top.FindAll( Lap_top => Lap_top.SelectSingleNode("Nhom_Lap_top/@Ma_so").Value == Nguoi_dung.GetAttribute("Ma_so")); return(Danh_sach); }
public static XmlElement Tim_Lap_top( string Ma_so, XmlElement Du_lieu) { var Danh_sach_Lap_top = (XmlElement)Du_lieu.GetElementsByTagName("Danh_sach_Lap_top")[0]; var Kq = (XmlElement)null; foreach (XmlElement Lap_top in Danh_sach_Lap_top.GetElementsByTagName("Laptop")) { if (Ma_so == Lap_top.GetAttribute("Ma_so")) { Kq = Lap_top; } } return(Kq); }
public static string Tao_Chuoi_HTML_Danh_sach_Lap_top_Chon(List <XmlElement> Danh_sach) { var Chuoi_HTML_Danh_sach = "<div class='row'>"; var Chuoi_Chuc_nang_Dat_hang = $"<div style='margin-left:10px' ><form method='post'>" + "<input name='Th_Ma_so_Chuc_nang' type='hidden' value='DAT_HANG' />" + $"<button type='submit' class='btn btn-danger' >Đặt hàng</button>" + "</form></div>"; if (Danh_sach.Count > 0) { Chuoi_HTML_Danh_sach += Chuoi_Chuc_nang_Dat_hang; } Danh_sach.ForEach(Lap_top => { var Ten = Lap_top.GetAttribute("Ten"); var Ma_so = Lap_top.GetAttribute("Ma_so"); var Don_gia_Ban = long.Parse(Lap_top.GetAttribute("Don_gia_Ban")); var So_luong_Ton = int.Parse(Lap_top.GetAttribute("So_luong_Ton")); var So_luong = int.Parse(Lap_top.GetAttribute("So_luong")); var Dinh_dang_Trang_thai = ""; var Chuoi_Trang_thai = ""; var Chuoi_Chuc_nang_Giam_So_luong = $"<form method='post'>" + "<input name='Th_Ma_so_Chuc_nang' type='hidden' value='GIAM_SO_LUONG_LAP_TOP' />" + $"<input name='Th_Ma_so_Lap_top' type='hidden' value='{Ma_so}' />" + $"<button type='submit' class='btn btn-danger' >-</button>" + "</form>"; var Chuoi_Hinh = $"<img src='{Dia_chi_Media}/{ Ma_so}.png' " + "style='width:90px;height:90px;' />"; var Chuoi_Thong_tin = $"<div class='btn' style='text-align:left'> " + $"{ Ten}" + $"<br />Đơn giá Bán { Don_gia_Ban.ToString("n0", Dinh_dang_VN) }" + $"<br />Số lượng Đặt { So_luong.ToString("n0", Dinh_dang_VN) }" + $"<br />{ Chuoi_Trang_thai }" + $"</div>"; var Chuoi_HTML = $"<div class='col-md-4' style='margin-bottom:10px;{Dinh_dang_Trang_thai}' >" + $"{Chuoi_Hinh}" + $"{Chuoi_Thong_tin}" + $"{Chuoi_Chuc_nang_Giam_So_luong}" + "</div>"; Chuoi_HTML_Danh_sach += Chuoi_HTML; }); Chuoi_HTML_Danh_sach += "</div>"; return(Chuoi_HTML_Danh_sach); }
public static string Tao_Chuoi_HTML_Danh_sach_Lap_top_Xem(List <XmlElement> Danh_sach) { var Chuoi_HTML_Danh_sach = "<div class='row'>"; Danh_sach.ForEach(Lap_top => { var Ten = Lap_top.GetAttribute("Ten"); var Ma_so = Lap_top.GetAttribute("Ma_so"); var Don_gia_Ban = long.Parse(Lap_top.GetAttribute("Don_gia_Ban")); var So_luong_Ton = int.Parse(Lap_top.GetAttribute("So_luong_Ton")); var Dinh_dang_Trang_thai = ""; var Chuoi_Trang_thai = ""; var Chuoi_Chuc_nang_Chon = $"<form method='post'>" + "<input name='Th_Ma_so_Chuc_nang' type='hidden' value='CHON_LAP_TOP' />" + $"<input name='Th_Ma_so_Lap_top' type='hidden' value='{Ma_so}' />" + $"<button type='submit' class='btn btn-danger' >Chọn</button>" + "</form>"; if (So_luong_Ton == 0) { Dinh_dang_Trang_thai = ";opacity:0.7";; Chuoi_Trang_thai = "Tạm thời hết hàng"; Chuoi_Chuc_nang_Chon = ""; } var Chuoi_Hinh = $"<img src='{Dia_chi_Media}/{ Ma_so}.png' " + "style='width:90px;height:90px;' />"; var Chuoi_Thong_tin = $"<div class='btn' style='text-align:left'> " + $"<div style='width:300px;white-space: nowrap;overflow: hidden;text-overflow: ellipsis;'>{ Ten}" + $"</div>" + $"Đơn giá Bán { Don_gia_Ban.ToString("n0", Dinh_dang_VN) }" + $"<br />{ Chuoi_Trang_thai }" + $"</div>"; var Chuoi_HTML = $"<div class='col-md-4' style='margin-bottom:10px;{Dinh_dang_Trang_thai}' >" + $"{Chuoi_Hinh}" + $"{Chuoi_Thong_tin}" + $"{Chuoi_Chuc_nang_Chon}" + "</div>"; Chuoi_HTML_Danh_sach += Chuoi_HTML; }); Chuoi_HTML_Danh_sach += "</div>"; return(Chuoi_HTML_Danh_sach); }
public static string Tao_Chuoi_HTML_Danh_sach_Lap_top_Xem(List <XmlElement> Danh_sach) { var Chuoi_HTML_Danh_sach = "<div class='row'>"; Danh_sach.ForEach(Lap_top => { var Ten = Lap_top.GetAttribute("Ten"); var Ma_so = Lap_top.GetAttribute("Ma_so"); var Don_gia_Ban = long.Parse(Lap_top.GetAttribute("Don_gia_Ban")); var So_luong_Ton = int.Parse(Lap_top.GetAttribute("So_luong_Ton")); var Doanh_thu = long.Parse(Lap_top.GetAttribute("Doanh_thu")); var Dinh_dang_Trang_thai = ""; if (So_luong_Ton == 0) { Dinh_dang_Trang_thai = ";opacity:0.7";; } var Chuoi_Hinh = $"<img src='{Dia_chi_Media}/{ Ma_so}.png' " + "style='width:90px;height:90px;' />"; var Chuoi_Thong_tin = $"<div class='btn' style='text-align:left'> " + $"<div style='width:300px;white-space: nowrap;overflow: hidden;text-overflow: ellipsis;'>{ Ten}" + $"</div>" + $"Đơn giá Bán { Don_gia_Ban.ToString("n0", Dinh_dang_VN) }" + $"<br />Số lượng Tồn { So_luong_Ton.ToString("n0", Dinh_dang_VN) }" + $"<br />Doanh thu { Doanh_thu.ToString("n0", Dinh_dang_VN) }" + $"</div>"; var Chuoi_Chuc_nang_Ban_hang = $"<form method='post'> " + $"<input name='Th_Ma_so_Chuc_nang' type='hidden' value='GHI_BAN_HANG_MOI' /> " + $"<input name='Th_Ma_so_Lap_top' type='hidden' value='{Ma_so}' /> " + $"<input name='Th_So_luong' required='required' autocomplete='off' " + $"style='border:none;border-bottom:solid 1px blue'" + $"type='number' min='1' max='100' value='10' /> " + $"</form>"; var Chuoi_HTML = $"<div class='col-md-4' style='margin-bottom:10px;{Dinh_dang_Trang_thai}' >" + $"{Chuoi_Hinh}" + $"{Chuoi_Thong_tin}" + $"{Chuoi_Chuc_nang_Ban_hang}" + "</div>"; Chuoi_HTML_Danh_sach += Chuoi_HTML; }); Chuoi_HTML_Danh_sach += "</div>"; return(Chuoi_HTML_Danh_sach); }
void Khoi_dong_Du_lieu_cua_Dich_vu() { var Du_lieu_Luu_tru = XL_LUU_TRU.Doc_Du_lieu(); var Chuoi_XML = Du_lieu_Luu_tru.OuterXml; var Tai_lieu = new XmlDocument(); Tai_lieu.LoadXml(Chuoi_XML); Du_lieu_Dich_vu = Tai_lieu.DocumentElement; var Danh_sach_Lap_top = (XmlElement)Du_lieu_Dich_vu.GetElementsByTagName("Danh_sach_Lap_top")[0]; var Cua_hang = (XmlElement)Du_lieu_Dich_vu.GetElementsByTagName("Cong_ty")[0]; var Danh_sach_Nhom_Lap_top = (XmlElement)Cua_hang.GetElementsByTagName("Danh_sach_Nhom_Lap_top")[0]; var Danh_sach_Nguoi_dung = (XmlElement)Cua_hang.GetElementsByTagName("Danh_sach_Nguoi_dung")[0]; // ===================== Bổ sung thông tin =============================== foreach (XmlElement Lap_top in Danh_sach_Lap_top.GetElementsByTagName("Laptop")) { var So_luong_Ton = XL_NGHIEP_VU.Tinh_So_luong_Ton_Lap_top(Lap_top); Lap_top.SetAttribute("So_luong_Ton", So_luong_Ton.ToString()); var Doanh_thu = XL_NGHIEP_VU.Tinh_Doanh_thu_Lap_top(Lap_top, DateTime.Today); Lap_top.SetAttribute("Doanh_thu", Doanh_thu.ToString()); } foreach (XmlElement Nhom_Lap_top in Danh_sach_Nhom_Lap_top.GetElementsByTagName("Nhom_Lap_top")) { var Danh_sach_Lap_top_cua_Nhom_Lap_top = XL_NGHIEP_VU.Tao_Danh_sach_Lap_top_cua_Nhom_Lap_top(Nhom_Lap_top, Danh_sach_Lap_top); var So_luong_Ton = XL_NGHIEP_VU.Tinh_So_luong_Ton_Danh_sach_Lap_top(Danh_sach_Lap_top_cua_Nhom_Lap_top); Nhom_Lap_top.SetAttribute("So_luong_Ton", So_luong_Ton.ToString()); var Doanh_thu = XL_NGHIEP_VU.Tinh_Doanh_thu_Danh_sach_Lap_top(Danh_sach_Lap_top_cua_Nhom_Lap_top, DateTime.Today); Nhom_Lap_top.SetAttribute("Doanh_thu", Doanh_thu.ToString()); } foreach (XmlElement Nguoi_dung in Danh_sach_Nguoi_dung.GetElementsByTagName("Nguoi_dung")) { foreach (XmlElement Nhom_Lap_top in Nguoi_dung.SelectNodes("Danh_sach_Nhom_Lap_top/Nhom_Lap_top")) { var Danh_sach_Lap_top_cua_Nhom_Lap_top = XL_NGHIEP_VU.Tao_Danh_sach_Lap_top_cua_Nhom_Lap_top(Nhom_Lap_top, Danh_sach_Lap_top); var So_luong_Ton = XL_NGHIEP_VU.Tinh_So_luong_Ton_Danh_sach_Lap_top(Danh_sach_Lap_top_cua_Nhom_Lap_top); Nhom_Lap_top.SetAttribute("So_luong_Ton", So_luong_Ton.ToString()); var Doanh_thu = XL_NGHIEP_VU.Tinh_Doanh_thu_Danh_sach_Lap_top(Danh_sach_Lap_top_cua_Nhom_Lap_top, DateTime.Today); Nhom_Lap_top.SetAttribute("Doanh_thu", Doanh_thu.ToString()); } } }
public XmlElement Tao_Du_lieu_cua_Ung_dung_Khach_Tham_quan() { var Chuoi_XML = Du_lieu_Dich_vu.OuterXml; var Tai_lieu = new XmlDocument(); Tai_lieu.LoadXml(Chuoi_XML); var Du_lieu = Tai_lieu.DocumentElement; var Cua_hang = (XmlElement)Du_lieu.GetElementsByTagName("Cong_ty")[0]; //var Danh_sach_Nguoi_dung = (XmlElement)Cua_hang.GetElementsByTagName("Danh_sach_Nguoi_dung")[0]; //Cua_hang.RemoveChild(Danh_sach_Nguoi_dung); foreach (XmlElement Lap_top in Du_lieu.GetElementsByTagName("Laptop")) { var Danh_sach_Ban_hang = (XmlElement)Lap_top.GetElementsByTagName("Danh_sach_Ban_hang")[0]; Lap_top.RemoveChild(Danh_sach_Ban_hang); var Danh_sach_Nhap_hang = (XmlElement)Lap_top.GetElementsByTagName("Danh_sach_Dat_hang")[0]; Lap_top.RemoveChild(Danh_sach_Nhap_hang); }// Xóa Tất các Nhập hàng, Bán hàng return(Du_lieu); }
//============= Xử lý Chức năng ======== public string Ghi_Phieu_Dat_hang_Moi(string Ho_ten, string Dia_chi, string Dien_thoai, XL_KHACH_THAM_QUAN Khach) { var Chuoi_XML = "<PHIEU_DAT />"; var Tai_lieu = new XmlDocument(); Tai_lieu.LoadXml(Chuoi_XML); var Phieu_dat = Tai_lieu.DocumentElement; Phieu_dat.SetAttribute("Ma_so", ""); Phieu_dat.SetAttribute("Ngay", DateTime.Now.ToString()); Phieu_dat.SetAttribute("Trang_thai", "CHUA_GIAO_HANG"); var Khach_hang = (Tai_lieu.CreateElement("Khach_hang")); Khach_hang.SetAttribute("Ho_ten", Ho_ten); Khach_hang.SetAttribute("Dien_thoai", Dien_thoai); Khach_hang.SetAttribute("Dia_chi", Dia_chi); Phieu_dat.AppendChild(Khach_hang); var Ds = Tai_lieu.CreateElement("Danh_sach_Lap_top"); Phieu_dat.AppendChild(Ds); Khach.Danh_sach_Lap_top_Chon.ForEach(Lap_top => { var QA = Tai_lieu.CreateElement("Laptop"); QA.SetAttribute("Ma_so", Lap_top.GetAttribute("Ma_so")); QA.SetAttribute("Ten", Lap_top.GetAttribute("Ten")); var Nhom_Lap_top = Tai_lieu.CreateElement("Nhom_Lap_top"); Nhom_Lap_top.SetAttribute("Nhom_Lap_top", Lap_top.SelectSingleNode("Nhom_Lap_top/@Ma_so").Value); QA.AppendChild(Nhom_Lap_top); var Don_Gia = long.Parse(Lap_top.GetAttribute("Don_gia_Ban")); var So_luong = long.Parse(Lap_top.GetAttribute("So_luong")); var Tien = Don_Gia * So_luong; QA.SetAttribute("Don_gia", Lap_top.GetAttribute("Don_gia_Ban")); QA.SetAttribute("So_luong", Lap_top.GetAttribute("So_luong")); QA.SetAttribute("Tien", Tien.ToString()); Ds.AppendChild(QA); /*var tailieu = new XmlDocument(); * tailieu.LoadXml(Lap_top.OuterXml); * tailieu.remoa * var Lap_top1 = tailieu.DocumentElement; * var Lap_top2 = Tai_lieu.ImportNode(Lap_top1, true); * Ds.AppendChild(Lap_top2);*/ }); Phieu_dat.AppendChild(Ds); var Kq_Ghi = XL_LUU_TRU.Ghi_Phieu_Dat_hang_moi(Phieu_dat); Khach.Thong_bao = ""; if (Kq_Ghi == "OK") { Khach.Thong_bao = "Đặt phiếu Thành công"; Khach.Danh_sach_Lap_top_Chon = new List <XmlElement>(); } else { Khach.Thong_bao = "Lỗi Hệ thống - Xin Thực hiện lại "; } var Chuoi_HTML = XL_THE_HIEN.Tao_chuoi_HTML_Thong_bao(Khach.Thong_bao); return(Chuoi_HTML); }