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));
}
