public static DatHangChiTiet Insert(DatHangChiTiet item) { var Item = new DatHangChiTiet(); var obj = new SqlParameter[8]; obj[0] = new SqlParameter("DHCT_ID", item.ID); obj[1] = new SqlParameter("DHCT_DH_ID", item.DH_ID); obj[2] = new SqlParameter("DHCT_HH_ID", item.HH_ID); obj[3] = new SqlParameter("DHCT_HH_Ten", item.HH_Ten); obj[4] = new SqlParameter("DHCT_HH_SoLuong", item.HH_SoLuong); obj[5] = new SqlParameter("DHCT_HH_Gia", item.HH_Gia); obj[6] = new SqlParameter("DHCT_HH_Tong", item.HH_Tong); if (item.NgayTao > DateTime.MinValue) { obj[7] = new SqlParameter("DHCT_NgayTao", item.NgayTao); } else { obj[7] = new SqlParameter("DHCT_NgayTao", DBNull.Value); } using (IDataReader rd = SqlHelper.ExecuteReader(DAL.con(), CommandType.StoredProcedure, "sp_tblDatHangChiTiet_Insert_InsertNormal_linhnx", obj)) { while (rd.Read()) { Item = getFromReader(rd); } } return(Item); }
public static DatHangChiTiet SelectById(Guid DHCT_ID) { var Item = new DatHangChiTiet(); var obj = new SqlParameter[1]; obj[0] = new SqlParameter("DHCT_ID", DHCT_ID); using (IDataReader rd = SqlHelper.ExecuteReader(DAL.con(), CommandType.StoredProcedure, "sp_tblDatHangChiTiet_Select_SelectById_linhnx", obj)) { while (rd.Read()) { Item = getFromReader(rd); } } return(Item); }
public static DatHangChiTiet getFromReader(IDataReader rd) { var Item = new DatHangChiTiet(); if (rd.FieldExists("DHCT_ID")) { Item.ID = (Guid)(rd["DHCT_ID"]); } if (rd.FieldExists("DHCT_DH_ID")) { Item.DH_ID = (Guid)(rd["DHCT_DH_ID"]); } if (rd.FieldExists("DHCT_HH_ID")) { Item.HH_ID = (Guid)(rd["DHCT_HH_ID"]); } if (rd.FieldExists("DHCT_HH_Ten")) { Item.HH_Ten = (String)(rd["DHCT_HH_Ten"]); } if (rd.FieldExists("DHCT_HH_SoLuong")) { Item.HH_SoLuong = (Int32)(rd["DHCT_HH_SoLuong"]); } if (rd.FieldExists("DHCT_HH_Gia")) { Item.HH_Gia = (Int32)(rd["DHCT_HH_Gia"]); } if (rd.FieldExists("DHCT_HH_Tong")) { Item.HH_Tong = (Int32)(rd["DHCT_HH_Tong"]); } if (rd.FieldExists("DHCT_NgayTao")) { Item.NgayTao = (DateTime)(rd["DHCT_NgayTao"]); } Item._HangHoa = HangHoaDal.getFromReader(rd); return(Item); }
protected void Page_Load(object sender, EventArgs e) { string act = Request["act"]; string _ID = Request["ID"]; string _SoLuong = Request["SoLuong"]; string _Ten = Request["Ten"]; string _Gia = Request["Gia"]; string _Img = Request["Img"]; string _Email = Request["Email"]; string _Mobile = Request["Mobile"]; string _DiaChi = Request["DiaChi"]; string _GhiChu = Request["GhiChu"]; var gh = new GioHang(); var item = new HangHoa(); var _dele = new SendEmailDele(sendmailThongbao); var sb = new StringBuilder(); switch (act) { case "add": #region add item = HangHoaDal.SelectById(new Guid(_ID)); gh.Add(item, _SoLuong); break; #endregion case "save": #region save var itemDh = new DatHang { ID=Guid.NewGuid(), GiaoHang = false, GiaTri = gh.Total, KH_DiaChi = _DiaChi, KH_Email = _Email, KH_Mobile = _Mobile, KH_Ten = _Ten, NgayTao = DateTime.Now, PhiVanChuyen = gh.ShipCost, Readed = false, Tong = gh.Total + gh.ShipCost, NgayGiao = DateTime.Now }; itemDh = DatHangDal.Insert(itemDh); var itemDhCt = new DatHangChiTiet(); var sbDh = new System.Text.StringBuilder(); sbDh.AppendFormat(@"Khách hàng: {0}<br/>Email: {1}<br/>Mobile: {2}<br/>Địa chỉ: {3}<br/>Ghi chú: {4}<br/>Ngày đặt hàng: {5}<br/><h3>Chi tiết</h3>" ,_Ten,_Email,_Mobile,_DiaChi, _GhiChu,DateTime.Now); foreach (GioHangItem ghItem in gh.List.Values) { itemDhCt = new DatHangChiTiet(); itemDhCt.ID = Guid.NewGuid(); itemDhCt.DH_ID = itemDh.ID; itemDhCt.HH_Gia = ghItem.Gia; itemDhCt.HH_SoLuong = ghItem.SoLuong; itemDhCt.HH_Ten = ghItem.Ten; itemDhCt.HH_Tong = ghItem.Gia * ghItem.SoLuong; itemDhCt.NgayTao = DateTime.Now; DatHangChiTietDal.Insert(itemDhCt); sbDh.AppendFormat("Món:{0} - {1}<br/>Số lượng: {2}<br/>Tổng: {3}<hr/>", ghItem.Ten, ghItem.Gia, ghItem.SoLuong, ghItem.Gia * ghItem.SoLuong); } sbDh.AppendFormat(@"Tổng:{0}<br/>Phí vận chuyển: {1}<br/>Tổng cộng: {2}" , gh.Total, gh.ShipCost, gh.Total + gh.ShipCost); _dele.BeginInvoke("*****@*****.**" , string.Format("mamvui.com - Đặt hàng mới: {0} {1} [{2}.000đ]", _Ten, DateTime.Now.ToString("hh:mm-dd/MM/yy"),gh.Total + gh.ShipCost) , sbDh.ToString() , null, null); gh.Clear(); break; #endregion case "UpSl": #region UpSl item = HangHoaDal.SelectById(new Guid(_ID)); gh.UpdateSl(item, _SoLuong); break; #endregion case "del": #region add gh.Remove(_ID); break; #endregion case "clear": #region add gh.Clear(); break; #endregion case "get": #region get break; #endregion default: break; } //sb.Append(format_gioHang(gh)); sb.AppendFormat("({0})", JavaScriptConvert.SerializeObject(gh)); rendertext(sb, "text/plain"); }
protected void Page_Load(object sender, EventArgs e) { var act = Request["act"]; var Ten = Request["Ten"]; var Ho = Request["Ho"]; var ID = Request["ID"]; var XungHo = Request["XungHo"]; var NgaySinh = Request["NgaySinh"]; var Mobile = Request["Mobile"]; var FacebookUid = Request["FacebookUid"]; var NguonGoc_ID = Request["NguonGoc_ID"]; var KhuVuc_ID = Request["KhuVuc_ID"]; var DiaChi = Request["DiaChi"]; var NgungTheoDoi = Request["NgungTheoDoi"]; var HH_ID = Request["HH_ID"]; var GhiChu = Request["GhiChu"]; var FacebookUrl = Request["FacebookUrl"]; var UuTien = Request["UuTien"]; var NgayGiao = Request["NgayGiao"]; var NgayGiaoYeuCau = Request["NgayGiaoYeuCau"]; var NgayDat = Request["NgayDat"]; NgungTheoDoi = !string.IsNullOrEmpty(NgungTheoDoi) ? "true" : "false"; switch (act) { case "add": #region add if(Security.IsAuthenticated()) { KhachHang item; if(string.IsNullOrEmpty(ID)) { item=new KhachHang(); item.ID = Guid.NewGuid(); item.NgayTao = DateTime.Now; } else { item = KhachHangDal.SelectById(new Guid(ID)); } item.NguoiTao = Security.Username; item.Ten = Ten; item.Mobile = Mobile; item.FacebookUid = FacebookUid; item.DiaChi = DiaChi; if(!string.IsNullOrEmpty(NguonGoc_ID)) { item.NguonGoc_ID=new Guid(NguonGoc_ID); } if (!string.IsNullOrEmpty(KhuVuc_ID)) { item.KhuVuc_ID = new Guid(KhuVuc_ID); } item.NgungTheoDoi = Convert.ToBoolean(NgungTheoDoi); item.NgayCapNhat = DateTime.Now; item = string.IsNullOrEmpty(ID) ? KhachHangDal.Insert(item) : KhachHangDal.Update(item); rendertext(item.ID.ToString()); } break; #endregion case "xoa": #region add if (Security.IsAuthenticated()) { KhachHangDal.DeleteById(new Guid(ID)); } break; #endregion case "addAndShip": #region add if (Security.IsAuthenticated()) { var item = new KhachHang { ID = Guid.NewGuid(), NgayTao = DateTime.Now, NguoiTao = Security.Username, Ten = Ten, Mobile = Mobile, FacebookUid = FacebookUid, DiaChi = DiaChi, Ma = CaptchaImage.GenerateRandomCode(CaptchaType.Numeric, 10) }; if (!string.IsNullOrEmpty(NguonGoc_ID)) { item.NguonGoc_ID = new Guid(NguonGoc_ID); } if (!string.IsNullOrEmpty(KhuVuc_ID)) { item.KhuVuc_ID = new Guid(KhuVuc_ID); } item.NgungTheoDoi = Convert.ToBoolean(NgungTheoDoi); item = KhachHangDal.Insert(item); var hh = docsoft.entities.HangHoaDal.SelectById(new Guid(HH_ID)); var dh = new DatHang { GiaTri = Convert.ToInt32(hh.GNY), ID = Guid.NewGuid(), KH_DiaChi = DiaChi, KH_ID = item.ID, KH_Mobile = Mobile, KH_Ten = Ten, Readed = false, Tong = Convert.ToInt32(hh.GNY), PhiVanChuyen = 0, NgayTao = DateTime.Now, Username = Security.Username, GhiChu = GhiChu, FacebookUrl = FacebookUrl, Ma = CaptchaImage.GenerateRandomCode(CaptchaType.Numeric, 10), UuTien = Convert.ToInt32(string.IsNullOrEmpty(UuTien) ? "1" : UuTien) }; if (!string.IsNullOrEmpty(NgayGiaoYeuCau)) { dh.NgayGiaoYeuCau = Convert.ToDateTime(NgayGiaoYeuCau, new CultureInfo("vi-vn")); } if (!string.IsNullOrEmpty(NgayDat)) { dh.NgayDat = Convert.ToDateTime(NgayDat, new CultureInfo("vi-vn")); } else { dh.NgayDat = DateTime.Now; } if (!string.IsNullOrEmpty(NgayGiao)) { dh.NgayGiao = Convert.ToDateTime(NgayGiao, new CultureInfo("vi-vn")); } if (!string.IsNullOrEmpty(NguonGoc_ID)) { dh.NguonGoc_ID = new Guid(NguonGoc_ID); } dh = DatHangDal.Insert(dh); var dhct = new DatHangChiTiet { DH_ID = dh.ID, HH_ID = hh.ID, HH_Gia = Convert.ToInt32(hh.GNY), HH_SoLuong = 1, HH_Ten = hh.Ten, HH_Tong = Convert.ToInt32(hh.GNY), ID = Guid.NewGuid(), NgayTao = DateTime.Now }; dhct = DatHangChiTietDal.Insert(dhct); var ship = new Shipping() { ID = Guid.NewGuid() , DH_ID = dh.ID , DH_Ma = dh.Ma , Ma = CaptchaImage.GenerateRandomCode(CaptchaType.Numeric, 10) , DaGiao = false , DiaChi = dh.KH_DiaChi , HD_ID = dhct.HH_ID , NgayGiao = DateTime.Now , NgayTao = DateTime.Now , NguoiTao = Security.Username , Phi = dh.PhiVanChuyen , Readed = false , TraTien = false , PhaiThu = dh.Tong }; ship = ShippingDal.Insert(ship); // Xuất nhập var danhMucLoaiXuatNhap = DanhMucDal.SelectByMa("LXN-X"); var xn = XuatNhapDal.SelectByDraff(true); xn.TVDV_ID = dh.ID; xn.ChietKhau = 0; xn.ChuyenDoi = false; xn.ConNo = 0; xn.CongTienHang = dh.Tong; xn.DauKy = false; xn.DienGiai = string.Format("Thêm hóa đơn bán lẻ cho đặt hàng {0}", dh.Ma); xn.ID = Guid.NewGuid(); xn.KHO_ID = KhoHangDal.SelectAll()[0].ID; xn.KH_ID = dh.KH_ID; xn.KH_Ten = dh.KH_Ten; xn.NgayCapNhat = DateTime.Now; xn.NgayHoaDon = DateTime.Now; xn.NgayTao = DateTime.Now; xn.NguoiCapNhat = Security.Username; xn.NguoiTao = Security.Username; xn.NhanVien = Security.Username; xn.NoiBo = false; xn.ThanhToan = dh.Tong; xn.TuVanVien = Security.Username; xn.VAT = 0; xn.Xuat = true; xn.LOAI_ID = danhMucLoaiXuatNhap.ID; xn = XuatNhapDal.Insert(xn); // Xuất nhập chi tiết var itemXnCt = new XuatNhapChiTiet { ID = Guid.NewGuid(), CKTien = Convert.ToDouble(0), CKTyLe = Convert.ToDouble(0), DonGia = Convert.ToDouble(dhct.HH_Gia), HH_ID = dhct.HH_ID, GhiChu = GhiChu, NgayCapNhat = DateTime.Now, NguoiCapNhat = Security.Username, SoLuong = Convert.ToDouble(dhct.HH_SoLuong), Tong = Convert.ToDouble(dhct.HH_Tong), VAT = Convert.ToDouble(0), KH_ID = dh.KH_ID }; itemXnCt = XuatNhapChiTietDal.Update(itemXnCt); // Thu chi var thuChi = ThuChiDal.SelectByXnId(xn.ID.ToString()); thuChi.LoaiQuy = Convert.ToInt32(0); thuChi.P_ID = xn.KH_ID; thuChi.NgayTao = DateTime.Now; thuChi.SoTien = dh.Tong; if (thuChi.ID == Guid.Empty) { var ndtcItem = DanhMucDal.SelectByMa("NDTC-THU-KHANGTRA"); thuChi = ThuChiDal.SelectByDraff(true); thuChi.LoaiCandoi = 0; thuChi.Mota = string.Format("{0}: {1}", ndtcItem.Ten, item.Ma); thuChi.NDTC_ID = ndtcItem.ID; thuChi.Thu = true; thuChi.XN_ID = item.ID; thuChi.NguoiTao = Security.Username; thuChi.NguoiSua = Security.Username; thuChi.NgaySua = DateTime.Now; thuChi.isCandoi = false; ThuChiDal.Insert(thuChi); } else { thuChi.NguoiSua = Security.Username; thuChi.NgaySua = DateTime.Now; ThuChiDal.Update(thuChi); } rendertext(dh.ID.ToString()); } break; #endregion case "addAndHoaDon": #region addAndHoaDon if (Security.IsAuthenticated()) { var item = new KhachHang { ID = Guid.NewGuid(), NgayTao = DateTime.Now, NguoiTao = Security.Username, Ten = Ten, Mobile = Mobile, FacebookUid = FacebookUid, DiaChi = DiaChi, Ma = CaptchaImage.GenerateRandomCode(CaptchaType.Numeric, 10) }; if (!string.IsNullOrEmpty(NguonGoc_ID)) { item.NguonGoc_ID = new Guid(NguonGoc_ID); } if (!string.IsNullOrEmpty(KhuVuc_ID)) { item.KhuVuc_ID = new Guid(KhuVuc_ID); } item.NgungTheoDoi = Convert.ToBoolean(NgungTheoDoi); item = KhachHangDal.Insert(item); var hh = docsoft.entities.HangHoaDal.SelectById(new Guid(HH_ID)); var dh = new DatHang { GiaTri = Convert.ToInt32(hh.GNY), ID = Guid.NewGuid(), KH_DiaChi = DiaChi, KH_ID = item.ID, KH_Mobile = Mobile, KH_Ten = Ten, Readed = false, Tong = Convert.ToInt32(hh.GNY), PhiVanChuyen = 0, NgayTao = DateTime.Now, Username = Security.Username, GhiChu = GhiChu, FacebookUrl = FacebookUrl, Ma = CaptchaImage.GenerateRandomCode(CaptchaType.Numeric, 10), UuTien = Convert.ToInt32(string.IsNullOrEmpty(UuTien) ? "1" : UuTien) }; if (!string.IsNullOrEmpty(NgayGiaoYeuCau)) { dh.NgayGiaoYeuCau = Convert.ToDateTime(NgayGiaoYeuCau, new CultureInfo("vi-vn")); } if (!string.IsNullOrEmpty(NgayDat)) { dh.NgayDat = Convert.ToDateTime(NgayDat, new CultureInfo("vi-vn")); } else { dh.NgayDat = DateTime.Now; } if (!string.IsNullOrEmpty(NgayGiao)) { dh.NgayGiao = Convert.ToDateTime(NgayGiao, new CultureInfo("vi-vn")); } if (!string.IsNullOrEmpty(NguonGoc_ID)) { dh.NguonGoc_ID = new Guid(NguonGoc_ID); } dh = DatHangDal.Insert(dh); var dhct = new DatHangChiTiet { DH_ID = dh.ID, HH_ID = hh.ID, HH_Gia = Convert.ToInt32(hh.GNY), HH_SoLuong = 1, HH_Ten = hh.Ten, HH_Tong = Convert.ToInt32(hh.GNY), ID = Guid.NewGuid(), NgayTao = DateTime.Now }; dhct = DatHangChiTietDal.Insert(dhct); var ship = new Shipping() { ID = Guid.NewGuid() , DH_ID = dh.ID , DH_Ma = dh.Ma , Ma = CaptchaImage.GenerateRandomCode(CaptchaType.Numeric, 10) , DaGiao = false , DiaChi = dh.KH_DiaChi , HD_ID = dhct.HH_ID , NgayGiao = DateTime.Now , NgayTao = DateTime.Now , NguoiTao = Security.Username , Phi = dh.PhiVanChuyen , Readed = false , TraTien = false , PhaiThu = dh.Tong }; ship = ShippingDal.Insert(ship); rendertext(dh.ID.ToString()); } break; #endregion default: break; } }
protected void Page_Load(object sender, EventArgs e) { var act = Request["act"]; var GhiChu = Request["GhiChu"]; var GiaTri = Request["GiaTri"]; var GiaoHang = Request["GiaoHang"]; var ID = Request["ID"]; var KH_DiaChi = Request["KH_DiaChi"]; var KH_ID = Request["KH_ID"]; var DH_ID = Request["DH_ID"]; var KH_Mobile = Request["KH_Mobile"]; var KH_Ten = Request["KH_Ten"]; var Ma = Request["Ma"]; var NguonGoc_ID = Request["NguonGoc_ID"]; var PhiVanChuyen = Request["PhiVanChuyen"]; var Readed = Request["Readed"]; var TT_ID = Request["TT_ID"]; var FacebookUrl = Request["FacebookUrl"]; var UuTien = Request["UuTien"]; var NgayGiao = Request["NgayGiao"]; var NgayGiaoYeuCau = Request["NgayGiaoYeuCau"]; var NgayDat = Request["NgayDat"]; var HH_SoLuong = Request["HH_SoLuong"]; var HH_ID = Request["HH_ID"]; var HH_Gia = Request["HH_Gia"]; var q = Request["q"]; if (string.IsNullOrEmpty(HH_SoLuong)) HH_SoLuong = "1"; GiaoHang = !string.IsNullOrEmpty(GiaoHang) ? "true" : "false"; Readed = !string.IsNullOrEmpty(Readed) ? "true" : "false"; switch (act) { case "add": #region add if (Security.IsAuthenticated()) { DatHang item; if (string.IsNullOrEmpty(ID)) { item = new DatHang(); item.ID = Guid.NewGuid(); item.NgayTao = DateTime.Now; } else { item = DatHangDal.SelectById(new Guid(ID)); } if (!string.IsNullOrEmpty(NguonGoc_ID)) { item.NguonGoc_ID = new Guid(NguonGoc_ID); } if (!string.IsNullOrEmpty(TT_ID)) { item.TT_ID = new Guid(TT_ID); } item.GhiChu = GhiChu; item.FacebookUrl = FacebookUrl; item.GiaTri = Convert.ToInt32(GiaTri); item.KH_DiaChi = KH_DiaChi; if (!string.IsNullOrEmpty(KH_ID)) { item.KH_ID = new Guid(KH_ID); } item.KH_Mobile = KH_Mobile; item.KH_Ten = KH_Ten; item.Ma = Ma; if (!string.IsNullOrEmpty(NgayGiaoYeuCau)) { item.NgayGiaoYeuCau = Convert.ToDateTime(NgayGiaoYeuCau, new CultureInfo("vi-vn")); } if (!string.IsNullOrEmpty(NgayDat)) { item.NgayDat = Convert.ToDateTime(NgayDat, new CultureInfo("vi-vn")); } else { item.NgayDat = DateTime.Now; } if (!string.IsNullOrEmpty(NgayGiao)) { item.NgayGiao = Convert.ToDateTime(NgayGiao, new CultureInfo("vi-vn")); } item.PhiVanChuyen = Convert.ToInt32(PhiVanChuyen); item.UuTien = Convert.ToInt32(UuTien); item.Readed = Convert.ToBoolean(Readed); item.GiaoHang = Convert.ToBoolean(GiaoHang); item = string.IsNullOrEmpty(ID) ? DatHangDal.Insert(item) : DatHangDal.Update(item); rendertext(item.ID.ToString()); } break; #endregion case "addHang": #region addHang if (Security.IsAuthenticated()) { var item = new DatHangChiTiet { DH_ID = new Guid(DH_ID), HH_ID = new Guid(HH_ID), HH_Gia = Convert.ToInt32(HH_Gia), HH_SoLuong = Convert.ToInt32(HH_SoLuong), ID = Guid.NewGuid() }; item.HH_Tong = item.HH_SoLuong * item.HH_Gia; item.NgayTao = DateTime.Now; item = DatHangChiTietDal.Insert(item); HangHoaItem1.Visible = true; HangHoaItem1.Item = item; } break; #endregion case "removeHang": #region removeHang DatHangChiTietDal.DeleteById(new Guid(ID)); break; #endregion case "search": #region get var pagerSearch = DatHangDal.pagerNormal(string.Empty, false, null, q, Convert.ToInt32(100)); rendertext(JavaScriptConvert.SerializeObject(pagerSearch.List)); break; #endregion case "xoa": #region add if (Security.IsAuthenticated()) { DatHangDal.DeleteById(new Guid(ID)); } break; #endregion default: break; } }
protected void Page_Load(object sender, EventArgs e) { string act = Request["act"]; string _ID = Request["ID"]; string _SoLuong = Request["SoLuong"]; string _Ten = Request["Ten"]; string _Gia = Request["Gia"]; string _Img = Request["Img"]; string _Email = Request["Email"]; string _Mobile = Request["Mobile"]; string _DiaChi = Request["DiaChi"]; string _GhiChu = Request["GhiChu"]; var gh = new GioHang(); var item = new HangHoa(); var _dele = new SendEmailDele(sendmailThongbao); var sb = new StringBuilder(); switch (act) { case "add": #region add item = HangHoaDal.SelectById(new Guid(_ID)); gh.Add(item, _SoLuong); break; #endregion case "addWishList": #region add if(Security.IsAuthenticated()) { var yt = new YeuThich() { HH_ID = new Guid(_ID) , ID = Guid.NewGuid() , NgayTao = DateTime.Now , Username = Security.Username }; YeuThichDal.Insert(yt); sb.Append("1"); } else { sb.Append("0"); } break; #endregion case "save": #region save var itemDh = new DatHang { ID=Guid.NewGuid(), GiaoHang = false, GiaTri = gh.Total, KH_DiaChi = _DiaChi, KH_Email = _Email, KH_Mobile = _Mobile, KH_Ten = _Ten, NgayTao = DateTime.Now, PhiVanChuyen = gh.ShipCost, Readed = false, Tong = gh.Total + gh.ShipCost, NgayGiao = DateTime.Now, Username = Security.Username }; itemDh = DatHangDal.Insert(itemDh); var itemDhCt = new DatHangChiTiet(); var sbDh = new System.Text.StringBuilder(); sbDh.AppendFormat(@"Customer: {0}<br/>Email: {1}<br/>Mobile: {2}<br/>Address: {3}<br/>Note: {4}<br/>Date of purchase: {5}<br/><h3>Chi tiết</h3>" ,_Ten,_Email,_Mobile,_DiaChi, _GhiChu,DateTime.Now); foreach (var _ghItem in gh.List) { var ghItem = _ghItem.Value; itemDhCt = new DatHangChiTiet(); itemDhCt.ID = Guid.NewGuid(); itemDhCt.DH_ID = itemDh.ID; itemDhCt.HH_ID = new Guid(_ghItem.Key); itemDhCt.HH_Gia = ghItem.Gia; itemDhCt.HH_SoLuong = ghItem.SoLuong; itemDhCt.HH_Ten = ghItem.Ten; itemDhCt.HH_Tong = ghItem.Gia * ghItem.SoLuong; itemDhCt.NgayTao = DateTime.Now; DatHangChiTietDal.Insert(itemDhCt); sbDh.AppendFormat("Item:{0} - {1}<br/>Quality: {2}<br/>Sub total: {3}<hr/>", ghItem.Ten, ghItem.Gia, ghItem.SoLuong, ghItem.Gia * ghItem.SoLuong); } sbDh.AppendFormat(@"Total:{0}<br/>Shipping cost: {1}<br/>Total amout: {2}" , gh.Total, gh.ShipCost, gh.Total + gh.ShipCost); _dele.BeginInvoke("*****@*****.**" , string.Format("Leenaa - New Order: {0} {1} [{2}.000]", _Ten, DateTime.Now.ToString("hh:mm-dd/MM/yy"),gh.Total + gh.ShipCost) , sbDh.ToString() , null, null); gh.Clear(); if(itemDh.Tong != 0) { itemDh.Tong = itemDh.Tong/1141; } sb.AppendFormat("({0})",JavaScriptConvert.SerializeObject(itemDh)); rendertext(sb, "text/plain"); break; #endregion case "UpSl": #region UpSl item = HangHoaDal.SelectById(new Guid(_ID)); gh.UpdateSl(item, _SoLuong); break; #endregion case "del": #region add gh.Remove(_ID); break; #endregion case "delWishList": #region delWishList if (Security.IsAuthenticated()) { YeuThichDal.DeleteById(new Guid(_ID)); } break; #endregion case "clear": #region add gh.Clear(); break; #endregion case "get": #region get break; #endregion default: break; } //sb.Append(format_gioHang(gh)); sb.AppendFormat("({0})", JavaScriptConvert.SerializeObject(gh)); rendertext(sb, "text/plain"); }