public static int add(PhieuNhap phieunhap) { try { using (EntitiesDataContext db = new EntitiesDataContext()) { var phieu = new PHIEUNHAP() { masonxb = phieunhap.NXB.MaSoNXB, ngaylap = phieunhap.NgayLap, nguoigiaosach = phieunhap.NguoiGiao, tongtien = phieunhap.ChiTiet.Sum(ct => ct.SoLuong * ct.DonGia), trangthai = 0 }; db.PHIEUNHAPs.InsertOnSubmit(phieu); db.SubmitChanges(); ChiTiet.add(phieunhap.ChiTiet, phieu.masophieunhap); return(phieu.masophieunhap); } }catch (Exception ex) { Console.WriteLine(ex.Message); return(0); } }
public void DeleteCTUpdateHang(string manx, string mah) { try { using (QLCuaHangDataContext cuahang = new QLCuaHangDataContext()) { //Cập nhật số lượng ở hàng. ChiTiet c = cuahang.ChiTiets.SingleOrDefault(ct => ct.MaNX == manx && ct.MaHang == mah); Hang h = cuahang.Hangs.SingleOrDefault(ha => ha.MaHang == c.MaHang); if (manx.Substring(0, 1) == "N") //Xoá ChiTiet của Nhập. { h.GhiChu += "\n Ngày: " + DateTime.Now.ToString("dd/MM/yyyy") + " xoá Chi Tiết phiếu Nhập thay đổi sl: " + (h.SoLuong - c.SoLuong) + " => " + h.SoLuong; h.SoLuong -= c.SoLuong; } else // Xoá ChiTiet của Xuất. { h.GhiChu += "\n Ngày: " + DateTime.Now.ToString("dd/MM/yyyy") + " xoá Chi Tiết phiếu Xuất thay đổi sl: " + (h.SoLuong + c.SoLuong) + " => " + h.SoLuong; h.SoLuong += c.SoLuong; } //Tiến hành xoá chitiet. cuahang.ChiTiets.DeleteOnSubmit(c); cuahang.SubmitChanges(); } }catch (Exception ex) { myme.ShowError(ex); } }
//=============Xem chi tiết LS==================== public List <ChiTiet> ChiTietLichSu(string id) { List <Models.ChiTiet> chitiet = new List <Models.ChiTiet>(); XDocument xmlDoc = XDocument.Load("C:/Users/Administrator/Desktop/KLTN_UDQLKH/KLTN_UDQLKH/KLTN_UDQLKH/Data/LICH_SU.xml"); XDocument xmlDocCT = XDocument.Load("C:/Users/Administrator/Desktop/KLTN_UDQLKH/KLTN_UDQLKH/KLTN_UDQLKH/Data/CT_HOADON.xml"); XDocument xmlDocSP = XDocument.Load("C:/Users/Administrator/Desktop/KLTN_UDQLKH/KLTN_UDQLKH/KLTN_UDQLKH/Data/SAN_PHAM.xml"); var Node = (from ls in xmlDoc.Descendants("lichsu") join cthd in xmlDocCT.Descendants("chitiet") on(string) ls.Element("idhoadon") equals(string) cthd.Attribute("idhoadon") join sp in xmlDocSP.Descendants("sanpham") on(string) cthd.Attribute("idsp") equals(string) sp.Attribute("id") where (string)ls.Element("idhoadon").Value == id select new { id = (string)cthd.Attribute("id"), tensp = (string)sp.Element("tensp"), dongia = (int)sp.Element("dongia"), soluongmua = (int)cthd.Element("soluongmua") }).ToList(); foreach (var i in Node) { ChiTiet ct = new ChiTiet(); ct.id = i.id; ct.tensp = i.tensp; ct.dongia = i.dongia; ct.soluongmua = i.soluongmua; chitiet.Add(ct); } return(chitiet); }
public static bool edit(PhieuNhap phieu) { try { using (EntitiesDataContext db = new EntitiesDataContext()) { PHIEUNHAP px; px = (from p in db.PHIEUNHAPs where p.masophieunhap.Equals(phieu.MaSoPhieuNhap) select p).SingleOrDefault(); if (px == null) { return(false); } px.masonxb = phieu.MaSoNXB; px.ngaylap = phieu.NgayLap; px.nguoigiaosach = phieu.NguoiGiao; px.trangthai = phieu.TrangThai; px.tongtien = phieu.ChiTiet.Sum(ct => ct.SoLuong * ct.DonGia); // tính tổng tiền các chi tiết db.CHITIETPHIEUNHAPs.DeleteAllOnSubmit(px.CHITIETPHIEUNHAPs); db.SubmitChanges(); foreach (ChiTietPhieuNhap ct in phieu.ChiTiet) { ct.MaSoPhieuNhap = phieu.MaSoPhieuNhap; ChiTiet.add(ct); } return(true); } } catch (Exception ex) { Console.WriteLine(ex.Message); return(false); } }
public static int add(HoaDonNXB hoadon) { try { using (EntitiesDataContext db = new EntitiesDataContext()) { var hd = new HOADONNXB { masonxb = hoadon.MaSoNXB, ngaylap = hoadon.NgayLap, tongtien = hoadon.ChiTiet.Sum(ct => ct.SoLuong * ct.DonGia), trangthai = 0 }; db.HOADONNXBs.InsertOnSubmit(hd); db.SubmitChanges(); foreach (ChiTietHoaDonNXB ct in hoadon.ChiTiet) { ChiTiet.add(ct, hd.masohoadon); } return(hd.masohoadon); } } catch (Exception ex) { Console.WriteLine(ex.Message); return(0); } }
public static bool edit(HoaDonNXB hoadon) { try { using (EntitiesDataContext db = new EntitiesDataContext()) { HOADONNXB hd; hd = (from p in db.HOADONNXBs where p.masohoadon.Equals(hoadon.MaSoHoaDon) select p).SingleOrDefault(); if (hd == null) { return(false); } hd.masonxb = hoadon.MaSoNXB; hd.ngaylap = hoadon.NgayLap; hd.trangthai = hoadon.TrangThai; hd.tongtien = hoadon.ChiTiet.Sum(ct => ct.SoLuong * ct.DonGia); // tính tổng tiền các chi tiết db.CHITIETHOADONNXBs.DeleteAllOnSubmit(hd.CHITIETHOADONNXBs); db.SubmitChanges(); foreach (ChiTietHoaDonNXB ct in hoadon.ChiTiet) { ChiTiet.add(ct, hoadon.MaSoHoaDon); } return(true); } } catch (Exception ex) { Console.WriteLine(ex.Message); return(false); } }
public ResultsData <List <Model.ChiTiet> > view_chi_tiet(string id_kho_hang) { ResultsData <List <Model.ChiTiet> > results = new ResultsData <List <Model.ChiTiet> >(); try { var data = from chitiet in db.tbl_chi_tiet_khos where chitiet.kh_id == id_kho_hang join hanghoa in db.tbl_hang_hoas on chitiet.hh_id equals hanghoa.hh_id select new { ct_id = chitiet.ct_id, hh_id = hanghoa.hh_id, hh_ten = hanghoa.hh_ten, hh_nha_cung_cap = hanghoa.hh_noi_san_xuat, ngay_cap_nhat = chitiet.ngay_cap_nhat, ct_soluong = chitiet.ct_so_luong }; if (data.Count() > 0) { List <ChiTiet> list = new List <ChiTiet>(); foreach (var item in data) { Model.ChiTiet row = new ChiTiet(); row.ct_id = item.ct_id; row.hh_id = item.hh_id; row.hh_ten = item.hh_ten; row.hh_nha_cung_cap = item.hh_nha_cung_cap; row.ngay_cap_nhat = item.ngay_cap_nhat; row.ct_soluong = (double)item.ct_soluong; Share.Constant.tong_kho_chua += row.ct_soluong; list.Add(row); } results.data = list.ToList(); results.err_desc = Share.Constant.func_rs_success; results.err_code = ErrorCode.success; } else { results.data = null; results.err_desc = Share.Constant.func_rs_empty; results.err_code = ErrorCode.empty; Share.Constant.tong_kho_chua = 0; } } catch (Exception ex) { results.data = null; results.err_desc = ex.ToString(); results.err_code = ErrorCode.fail; Share.Constant.tong_kho_chua = 0; } return(results); }
// POST: odata/ChiTiets public IHttpActionResult Post(ChiTiet chiTiet) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } db.ChiTiets.Add(chiTiet); db.SaveChanges(); return(Created(chiTiet)); }
public List <ChiTiet> GetDetailPhieuNhapByIdPhieu(int id) { List <ChiTiet> cthdlist = new List <ChiTiet>(); string query = "select TENVATTU, DVT, SO_LUONG, PARSENAME(convert(varchar,convert(money,DONGIA),1),2 ) as DONGIA, PARSENAME(convert(varchar,convert(money,THANH_TIEN),1),2 ) as THANH_TIEN from VATTU ,CHITIETPHIEUNHAP where VATTU.ID_VATTU = CHITIETPHIEUNHAP.ID_VATTU and ID_PHIEU = '" + id + "'"; DataTable data = DataProvider.Instance.ExecuteQuery(query, new object[] { id }); foreach (DataRow item in data.Rows) { ChiTiet cthd = new ChiTiet(item); cthdlist.Add(cthd); } return(cthdlist); }
public void DeleteCTWithMaNX(string manx) { try { using (QLCuaHangDataContext cuahang = new QLCuaHangDataContext()) { ChiTiet c = cuahang.ChiTiets.SingleOrDefault(ct => ct.MaNX == manx); cuahang.ChiTiets.DeleteOnSubmit(c); cuahang.SubmitChanges(); } } catch (Exception ex) { myme.ShowError(ex); } }
// DELETE: odata/ChiTiets(5) public IHttpActionResult Delete([FromODataUri] int key) { ChiTiet chiTiet = db.ChiTiets.Find(key); if (chiTiet == null) { return(NotFound()); } db.ChiTiets.Remove(chiTiet); db.SaveChanges(); return(StatusCode(HttpStatusCode.NoContent)); }
//GetChiTiet public JsonResult GetChiTiet(string id) { using (CoffeeEntities db = new CoffeeEntities()) { if (id != null) { int idHoaDonBanHang; if (int.TryParse(id, out idHoaDonBanHang)) { ChiTiet model = new ChiTiet(); model.ChiTietThucDons = db.ORDER_ChiTietHoaDonBanHang.Where(p => p.idHoaDonBanHang == idHoaDonBanHang).ToList(); model.ChiTietNhanViens = db.ORDER_ChiTietNhanVienHoaDonBanHang.Where(p => p.idHoaDonBanHang == idHoaDonBanHang).ToList(); return(Json(model, JsonRequestBehavior.AllowGet)); } } return(null); } }
public bool addDetail(Sach sach, decimal soluong) { var chitiet = new ChiTietPhieuXuat { MaSoSach = sach.MaSoSach, Sach = sach, SoLuong = soluong, DonGia = sach.GiaBan }; foreach (var ct in ChiTiet) { if (ct.Equals(chitiet)) { ct.SoLuong += chitiet.SoLuong; return(true); } } ChiTiet.Add(chitiet); return(true); }
public ActionResult GhiNhan() { Ban ban = db.Ban.SingleOrDefault(n => n.MaBan == ThongTin.MaBan); if (ban.TinhTangBan == 1) { return(RedirectToAction("Index", "Ban")); } ban.TinhTangBan = 1; HoaDon hoadon = new HoaDon(); hoadon.TenKH = ThongTin.HoTen; hoadon.NgayDat = DateTime.Now; hoadon.TongTien = TongHoaDon.TongTien; hoadon.SDT = ThongTin.SDT; hoadon.TinhTrang = 0; db.HoaDon.Add(hoadon); db.SaveChanges(); //int MaHoaDon = hoadon.MaHD; int id = hoadon.MaHD; List <HoaDonChiTiet> lstHoaDonChiTiet = LayHoaDonChiTiet(); ban.MaHD = hoadon.MaHD; ban.GhiChu = ThongTin.GhiChu; db.SaveChanges(); foreach (var item in lstHoaDonChiTiet) { ChiTiet chitiet = new ChiTiet(); chitiet.MaMon = item.iMaMon; chitiet.SoLuong = item.SoLuong; chitiet.ThanhTien = item.ThanhTien; chitiet.MaHD = hoadon.MaHD; db.ChiTiet.Add(chitiet); db.SaveChanges(); } Session.RemoveAll(); return(RedirectToAction("Index", "Ban")); }
// PUT: odata/ChiTiets(5) public IHttpActionResult Put([FromODataUri] int key, Delta <ChiTiet> patch) { Validate(patch.GetEntity()); if (!ModelState.IsValid) { return(BadRequest(ModelState)); } ChiTiet chiTiet = db.ChiTiets.Find(key); if (chiTiet == null) { return(NotFound()); } patch.Put(chiTiet); try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!ChiTietExists(key)) { return(NotFound()); } else { throw; } } return(Updated(chiTiet)); }