// lay danh sach cac phieu nhap public ObservableCollection <vo_PhieuNhapHang> GetAllPhieuNhapHang() { try { dao_PhieuNhapHang dal = new dao_PhieuNhapHang(); DataTable dt = dal.GetAllPhieuNhap(); ObservableCollection <vo_PhieuNhapHang> listVo = new ObservableCollection <vo_PhieuNhapHang>(); if (dt != null && dt.Rows.Count > 0) { foreach (DataRow dr in dt.Rows) { vo_PhieuNhapHang vo_phieuNhap = new vo_PhieuNhapHang(); vo_phieuNhap.DaTra = int.Parse(dr["DATRA"].ToString()); vo_phieuNhap.GhiChu = dr["GHICHU"].ToString(); vo_phieuNhap.Id = int.Parse(dr["ID"].ToString()); vo_phieuNhap.MaNhaCungCap = dr["MANHACUNGCAP"].ToString(); vo_phieuNhap.NhaCungCap = dr["TENNHACUNGCAP"].ToString(); vo_phieuNhap.TenNhanVien = dr["HOTEN"].ToString(); vo_phieuNhap.MaNhanVien = dr["MANHANVIEN"].ToString(); vo_phieuNhap.MaPhieuNhap = dr["MAPHIEUNHAP"].ToString(); vo_phieuNhap.ThoiGian = Utilities.DotNetToVietNam(dr["THOIGIAN"].ToString()); vo_phieuNhap.TongGiam = int.Parse(dr["TONGGIAM"].ToString()); vo_phieuNhap.TongTien = int.Parse(dr["TONGTIENCANTRA"].ToString()); listVo.Add(vo_phieuNhap); } } return(listVo); } catch (Exception ex) { throw ex; } }
// delete phieu nhap public int DeltetePhieuNhap(int _id) { try { dao_PhieuNhapHang dao = new dao_PhieuNhapHang(); int id = dao.deletePhieuNhap(_id); return(id); } catch (Exception ex) { throw ex; } }
//update ghi chu phieu nhap public int UpdateGhiChuPhieuNhap(vo_PhieuNhapHang _vo) { try { dao_PhieuNhapHang dao = new dao_PhieuNhapHang(); int id = dao.UpdateGhiChuPhieuNhap(_vo); return(id); } catch (Exception ex) { throw ex; } }
/// <summary> /// tao ma phieu nhap /// </summary> /// <param name="id"></param> /// <returns></returns> public string GenerateMaPhieuNhap() { try { dao_PhieuNhapHang dao = new dao_PhieuNhapHang(); int id = dao.GetLastesPhieuNhapId() + 1; string code = "PN" + String.Format("{0:000000}", id); return(code); } catch (Exception ex) { throw ex; } }
// them phieu nhap va chi tiet phieu nhap public int AddPhieuNhapHang(vo_PhieuNhapHang vo) { try { dao_PhieuNhapHang dao = new dao_PhieuNhapHang(); vo.ThoiGian = Utilities.DotNetToVietNam(DateTime.Now.ToString()); int id = dao.InsertPhieuNhap(vo); // neu insert phieu nhap thanh cong va tra ve id > 0 thi insert chi tiet if (id > 0) { int num = dao.InsertChiTietPhieuNhap(vo); // tra ve so hang hoa da dc them vao return(num); } return(0); } catch (Exception ex) { throw ex; } }
// lay chi tiet phieu nhap hang public vo_PhieuNhapHang GetChiTietPhieuNhapHang(string _code) { try { dao_PhieuNhapHang dao = new dao_PhieuNhapHang(); vo_PhieuNhapHang vo_phieuNhap = new vo_PhieuNhapHang(); //lay thong tin phieu nhap DataTable dt = dao.GetPhieuNhapById(_code); if (dt != null && dt.Rows.Count > 0) { vo_phieuNhap.DaTra = int.Parse(dt.Rows[0]["DATRA"].ToString()); vo_phieuNhap.GhiChu = dt.Rows[0]["GHICHU"].ToString(); vo_phieuNhap.Id = int.Parse(dt.Rows[0]["ID"].ToString()); vo_phieuNhap.MaNhaCungCap = dt.Rows[0]["MANHACUNGCAP"].ToString(); vo_phieuNhap.NhaCungCap = dt.Rows[0]["TENNHACUNGCAP"].ToString(); vo_phieuNhap.MaNhanVien = dt.Rows[0]["MANHANVIEN"].ToString(); vo_phieuNhap.TenNhanVien = dt.Rows[0]["HOTEN"].ToString(); vo_phieuNhap.MaPhieuNhap = dt.Rows[0]["MAPHIEUNHAP"].ToString(); vo_phieuNhap.ThoiGian = Utilities.DotNetToVietNam(dt.Rows[0]["THOIGIAN"].ToString()); vo_phieuNhap.TongGiam = int.Parse(dt.Rows[0]["TONGGIAM"].ToString()); vo_phieuNhap.TongTien = int.Parse(dt.Rows[0]["TONGTIENCANTRA"].ToString()); vo_phieuNhap.DsHangHoa = new ObservableCollection <vo_HangHoa>(); } // lay danh sach hang hoa trong phieu nhap DataTable dtDsHangHoa = dao.GetDanhSachHangHoaByPhieuNhap(_code); if (dtDsHangHoa != null && dtDsHangHoa.Rows.Count > 0) { foreach (DataRow dr in dtDsHangHoa.Rows) { vo_HangHoa vo = new vo_HangHoa(); // lay nhung du lieu can thiet vo.MaHangHoa = dr["MAHANGHOA"].ToString(); vo.TenHangHoa = dr["TENHANGHOA"].ToString(); vo.SoLuong = int.Parse(dr["SOLUONG"].ToString()); //don gia vo.GiaVon = int.Parse(dr["DONGIA"].ToString()); //gia giam if (string.IsNullOrEmpty(dr["GIAGIAM"].ToString())) { vo.GiaGiam = 0; } else { vo.GiaGiam = int.Parse(dr["GIAGIAM"].ToString()); } vo.LoaiHangHoa = dr["LOAIHANGHOA"].ToString(); vo_phieuNhap.DsHangHoa.Add(vo); } } return(vo_phieuNhap); } catch (Exception ex) { throw ex; } }