public MuaHangO getOneMuaHangByMaPhieu(MuaHangO mh) { DataTable dt = new DataTable(); MuaHangO MH = new MuaHangO(); dt = muaHangDAO.GetAllMuaHangByMaPhieu(mh); if (dt != null) { //DataRow[] result = dt.Select("MaHangHoa= '" + hh.MaHangHoa + "'"); DataRow row = dt.Rows[0]; MH.MaPhieu = row["MaPhieu"].ToString(); MH.TenPhieu = row["TenPhieu"].ToString(); MH.NgayLapPhieu = Convert.ToDateTime(row["NgayLapPhieu"]); MH.SoHoaDonVAT = row["SoHoaDonVAT"].ToString(); MH.SoPhieuVietTay = (row["SoPhieuVietTay"]).ToString(); MH.MaThanhToan = row["MaThanhToan"].ToString(); MH.MaHinhThuc = row["MaHinhThuc"].ToString(); MH.MaNhaCungCap = row["MaNhaCungCap"].ToString(); MH.ThoiHanThanhToan = Convert.ToDateTime(row["ThoiHanThanhToan"]); MH.GhiChu = row["GhiChu"].ToString(); MH.MaNhanVien = row["MaNhanVien"].ToString(); MH.MaKho = row["MaKho"].ToString(); MH.TongTien = Convert.ToDouble(row["TongTien"]); MH.PTramCK = Convert.ToInt32(row["PTramCK"]); MH.Thue = Convert.ToInt32(row["Thue"]); MH.TuongDuongTien = Convert.ToDouble(row["TuongDuongTien"]); MH.TienThanhToan = Convert.ToDouble(row["TienThanhToan"]); } return(MH); }
public DataTable GetAllMuaHangByMaPhieu(MuaHangO mh) { SqlParameter param = new SqlParameter(); param.ParameterName = "@MaPhieu"; param.Value = mh.MaPhieu; return(conn.executeSelectQuery("proGetMuaHang_NhaCC_Kho_IfMaPhieu", param)); }
public UCLichSuMuaHang() { InitializeComponent(); ucmh = new UCMuaHang(); MH = new MuaHangO(); CTPMH = new ChiTietPhieuMuaHangO(); TK = new TonKhoO(); muaHangBUS = new MuaHangBUS(); nhaCungCapBUS = new NhaCungCapBUS(); chiTietPhieuMuaHangBUS = new ChiTietPhieuMuaHangBUS(); tonKhoBUS = new TonKhoBUS(); }
void initObjectBUS() { MH = new MuaHangO(); NCC = new NhaCungCapO(); HH = new HangHoaO(); DV = new DonViO(); CTPMH = new ChiTietPhieuMuaHangO(); TK = new TonKhoO(); muaHangBUS = new MuaHangBUS(); nhaCungCapBUS = new NhaCungCapBUS(); nhanVienBUS = new NhanVienBUS(); khoBUS = new KhoBUS(); hangHoaBUS = new HangHoaBUS(); donViBUS = new DonViBUS(); tonKhoBUS = new TonKhoBUS(); chiTietPhieuMuaHangBUS = new ChiTietPhieuMuaHangBUS(); kieuThanhToanBUS = new KieuThanhToanBUS(); hinhThucThanhToanBUS = new HinhThucThanhToanBUS(); }
void LayMuaHangByMaPhieu(MuaHangO mh) { MH = muaHangBUS.getOneMuaHangByMaPhieu(mh); //dua du lieu len textbox,lookupedit txtMaPhieu.Text = MH.MaPhieu; txtTenPhieu.Text = MH.TenPhieu; deNgayLapPhieu.EditValue = MH.NgayLapPhieu; txtSoHoaDonVAT.Text = MH.SoHoaDonVAT; txtSoPhieuVietTay.Text = MH.SoPhieuVietTay; lueKieuThanhToan.EditValue = MH.MaThanhToan; lueNhaCungCap.EditValue = MH.MaNhaCungCap; deThoiHanThanhToan.EditValue = MH.ThoiHanThanhToan; lueHinhThucThanhToan.EditValue = MH.MaHinhThuc; lueNhanVien.EditValue = MH.MaNhanVien; lueKho.EditValue = MH.MaKho; txtGhiChu.Text = MH.GhiChu; }
public bool CapNhatMuaHang(ref string err, MuaHangO mh) { return(conn.MyExecuteNonQuery("proSuaMuaHang", CommandType.StoredProcedure, ref err, new SqlParameter("@MaPhieu", mh.MaPhieu), new SqlParameter("@TenPhieu", mh.TenPhieu), new SqlParameter("@NgayLapPhieu", mh.NgayLapPhieu.Date), new SqlParameter("@SoHoaDonVAT", mh.SoHoaDonVAT), new SqlParameter("@SoPhieuVietTay", mh.SoPhieuVietTay), new SqlParameter("@MaThanhToan", mh.MaThanhToan), new SqlParameter("@MaHinhThuc", mh.MaHinhThuc), new SqlParameter("@MaNhaCungCap", mh.MaNhaCungCap), new SqlParameter("@ThoiHanThanhToan", mh.ThoiHanThanhToan.Date), new SqlParameter("@GhiChu", mh.GhiChu), new SqlParameter("@MaNhanVien", mh.MaNhanVien), new SqlParameter("@MaKho", mh.MaKho), new SqlParameter("@TongTien", mh.TongTien), new SqlParameter("@PTramCK", mh.PTramCK), new SqlParameter("@Thue", mh.Thue), new SqlParameter("@TuongDuongTien", mh.TuongDuongTien), new SqlParameter("@TienThanhToan", mh.TienThanhToan) )); }
public bool XoaMuaHang(ref string err, MuaHangO mh) { return(conn.MyExecuteNonQuery("proXoaMuaHang", CommandType.StoredProcedure, ref err, new SqlParameter("@MaPhieu", mh.MaPhieu))); }
void LayChiTietPhieuMuaHangByMaPhieu(MuaHangO mh) { CTPMH.MaPhieu = mh.MaPhieu; dt = chiTietPhieuMuaHangBUS.GetAllChiTietPhieuMuaHangByMaPhieuBUS(CTPMH); gridControlMuaHang.DataSource = dt; }
public void TruyenMuaHang_MaPhieu(MuaHangO mh) { this.MH = mh; }
public bool XoaMuaHangBUS(ref string err, MuaHangO mh) { return(muaHangDAO.XoaMuaHang(ref err, mh)); }
public bool CapNhatMuaHangBUS(ref string err, MuaHangO mh) { return(muaHangDAO.CapNhatMuaHang(ref err, mh)); }
public DataTable getAllMuaHangByMaNhaCungCapBUS(MuaHangO mh) { return(muaHangDAO.GetAllMuaHangByMaPhieu(mh)); }