public TraHangO getOneTraHangByMaPhieuTra(TraHangO bh)
{
DataTable dt = new DataTable();
TraHangO BH = new TraHangO();
dt = traHangDAO.GetAllTraHangByMaPhieuTra(bh);
if (dt != null)
{
DataRow row = dt.Rows[0];
BH.MaPhieuTra = row["MaPhieuTra"].ToString();
BH.NgayLapPhieu = Convert.ToDateTime(row["NgayLapPhieu"]);
BH.MaKhachHang = row["MaKhachHang"].ToString();
BH.MaNhanVien = row["MaNhanVien"].ToString();
BH.MaKho = row["MaKho"].ToString();
BH.GhiChu = row["GhiChu"].ToString();
BH.TongTien = Convert.ToDouble(row["TongTien"]);
BH.PTramCK = Convert.ToInt32(row["PTramCK"]);
BH.Thue = Convert.ToInt32(row["Thue"]);
BH.TuongDuongTien = Convert.ToDouble(row["TuongDuongTien"]);
BH.TienThanhToan = Convert.ToDouble(row["TienThanhToan"]);
}
return(BH);
}
public DataTable GetAllTraHangByMaPhieuTra(TraHangO bh)
{
SqlParameter param = new SqlParameter();
param.ParameterName = "@MaPhieuTra";
param.Value = bh.MaPhieuTra;
return(conn.executeSelectQuery("proGetTraHang_KhachHang_Kho_IfMaPhieuTra", param));
}
public UCLichSuTraHang()
{
InitializeComponent();
ucth = new UCTraHang2();
KH = new KhachHangO();
TH = new TraHangO();
CTTH = new ChiTietTraHangO();
TK = new TonKhoO();
traHangBUS = new TraHangBUS();
khachHangBUS = new KhachHangBUS();
chiTietPhieuTraHangBUS = new ChiTietPhieuTraHangBUS();
tonKhoBUS = new TonKhoBUS();
}
public bool CapNhatTraHang(ref string err, TraHangO bh)
{
return(conn.MyExecuteNonQuery("proSuaTraHang",
CommandType.StoredProcedure, ref err,
new SqlParameter("@MaPhieuTra", bh.MaPhieuTra),
new SqlParameter("@NgayLapPhieu", bh.NgayLapPhieu),
new SqlParameter("@GhiChu", bh.GhiChu),
new SqlParameter("@MaKhachHang", bh.MaKhachHang),
new SqlParameter("@MaNhanVien", bh.MaNhanVien),
new SqlParameter("@MaKho", bh.MaKho),
new SqlParameter("@TongTien", bh.TongTien),
new SqlParameter("@PTramCK", bh.PTramCK),
new SqlParameter("@Thue", bh.Thue),
new SqlParameter("@TuongDuongTien", bh.TuongDuongTien),
new SqlParameter("@TienThanhToan", bh.TienThanhToan)
));
}
void initObjectBUS()
{
TH = new TraHangO();
KH = new KhachHangO();
HH = new HangHoaO();
DV = new DonViO();
CTTH = new ChiTietTraHangO();
TK = new TonKhoO();
traHangBUS = new TraHangBUS();
khachHangBUS = new KhachHangBUS();
nhanVienBUS = new NhanVienBUS();
khoBUS = new KhoBUS();
hangHoaBUS = new HangHoaBUS();
donViBUS = new DonViBUS();
tonKhoBUS = new TonKhoBUS();
chiTietPhieuTraHangBUS = new ChiTietPhieuTraHangBUS();
kieuThanhToanBUS = new KieuThanhToanBUS();
hinhThucThanhToanBUS = new HinhThucThanhToanBUS();
}
void LayTraHangByMaPhieuTra(TraHangO TH)
{
TH = traHangBUS.getOneTraHangByMaPhieuTra(TH);
//dua du lieu len textbox,lookupedit
lueKhachHang.EditValue = TH.MaKhachHang;
txtTenKhachHang.Text = KH.TenKhachHang;
deNgayLapPhieu.EditValue = TH.NgayLapPhieu;
txtGhiChu.Text = TH.GhiChu;
txtMaPhieuTra.Text = TH.MaPhieuTra;
txtDiaChi.Text = KH.DiaChi;
txtSoDienThoai.Text = KH.SoDienThoai;
lueNhanVien.EditValue = TH.MaNhanVien;
lueKho.EditValue = TH.MaKho;
txtTongTien.Text = TH.TongTien.ToString();
txtPhanTramChuyenKhoan.Text = TH.PTramCK.ToString();
txtPhanTramThue.Text = TH.Thue.ToString();
txtTuongDuongTien.Text = TH.TuongDuongTien.ToString();
txtTienThanhToan.Text = TH.TienThanhToan.ToString();
}
public void TruyenTraHang_MaPhieuTra(TraHangO TH)
{
this.TH = TH;
}
void LayChiTietPhieuTraHangByMaPhieuTra(TraHangO TH)
{
CTTH.MaPhieuTra = TH.MaPhieuTra;
dt = chiTietPhieuTraHangBUS.GetAllChiTietPhieuTraHangByMaPhieuTraBUS(CTTH);
gridControlTraHang.DataSource = dt;
}
public void TruyenTraHang_MaPhieuTra(TraHangO bh)
{
this.TH = bh;
}
public bool XoaTraHangBUS(ref string err, TraHangO bh)
{
return(traHangDAO.XoaTraHang(ref err, bh));
}
public bool CapNhatTraHangBUS(ref string err, TraHangO bh)
{
return(traHangDAO.CapNhatTraHang(ref err, bh));
}
public DataTable getAllTraHangByMaPhieuTraBUS(TraHangO bh)
{
return(traHangDAO.GetAllTraHangByMaPhieuTra(bh));
}
public bool XoaTraHang(ref string err, TraHangO bh)
{
return(conn.MyExecuteNonQuery("proXoaTraHang",
CommandType.StoredProcedure, ref err,
new SqlParameter("@MaPhieuTra", bh.MaPhieuTra)));
}