public DataTable GetAllChuyenKhoByMaPhieuChuyen(ChuyenKhoO ck)
{
SqlParameter param = new SqlParameter();
param.ParameterName = "@MaPhieuChuyen";
param.Value = ck.MaPhieuChuyen;
return(conn.executeSelectQuery("proGetChuyenKho_Kho_NhanVien_IfMaPhieuChuyen", param));
}
void LayChuyenKhoByMaPhieuChuyen(ChuyenKhoO ck)
{
CK = chuyenKhoBUS.getOneChuyenKhoByMaPhieuChuyen(ck);
//dua du lieu len textbox,lookupedit
txtMaPhieuChuyen.Text = CK.MaPhieuChuyen;
deNgayLapPhieu.EditValue = CK.NgayLapPhieu;
txtGhiChu.Text = CK.GhiChu;
lueKhoChuyen.EditValue = CK.MaKhoChuyen;
lueKhoNhan.EditValue = CK.MaKhoNhan;
lueNguoiChuyen.EditValue = CK.MaNguoiChuyen;
lueNguoiNhan.EditValue = CK.MaNguoiNhan;
}
public UCLichSuChuyenKho()
{
InitializeComponent();
ucck = new UCChuyenKho();
CK = new ChuyenKhoO();
CTCK = new ChiTietChuyenKhoO();
TK = new TonKhoO();
chuyenKhoBUS = new ChuyenKhoBUS();
chiTietChuyenKhoBUS = new ChiTietChuyenKhoBUS();
tonKhoBUS = new TonKhoBUS();
}
public bool CapNhatChuyenKho(ref string err, ChuyenKhoO ck)
{
return(conn.MyExecuteNonQuery("proSuaChuyenKho",
CommandType.StoredProcedure, ref err,
new SqlParameter("@MaPhieuChuyen", ck.MaPhieuChuyen),
new SqlParameter("@NgayLapPhieu", ck.NgayLapPhieu),
new SqlParameter("@GhiChu", ck.GhiChu),
new SqlParameter("@MaKhoChuyen", ck.MaKhoChuyen),
new SqlParameter("@MaKhoNhan", ck.MaKhoNhan),
new SqlParameter("@MaNguoiChuyen", ck.MaNguoiChuyen),
new SqlParameter("@MaNguoiNhan", ck.MaNguoiNhan)
));
}
void initObjectBUS()
{
CK = new ChuyenKhoO();
CTCK = new ChiTietChuyenKhoO();
HH = new HangHoaO();
DV = new DonViO();
TK = new TonKhoO();
chuyenKhoBUS = new ChuyenKhoBUS();
chiTietChuyenKhoBUS = new ChiTietChuyenKhoBUS();
nhanVienBUS = new NhanVienBUS();
khoBUS = new KhoBUS();
hangHoaBUS = new HangHoaBUS();
donViBUS = new DonViBUS();
tonKhoBUS = new TonKhoBUS();
}
public ChuyenKhoO getOneChuyenKhoByMaPhieuChuyen(ChuyenKhoO ck)
{
DataTable dt = new DataTable();
dt = chuyenKhoDAO.GetAllChuyenKhoByMaPhieuChuyen(ck);
if (dt != null)
{
//DataRow[] result = dt.Select("MaHangHoa= '" + hh.MaHangHoa + "'");
DataRow row = dt.Rows[0];
ck.MaPhieuChuyen = row["MaPhieuChuyen"].ToString();
ck.NgayLapPhieu = Convert.ToDateTime(row["NgayLapPhieu"]);
ck.GhiChu = row["GhiChu"].ToString();
ck.MaKhoChuyen = row["MaKhoChuyen"].ToString();
ck.MaKhoNhan = row["MaKhoNhan"].ToString();
ck.MaNguoiChuyen = row["MaNguoiChuyen"].ToString();
ck.MaNguoiNhan = row["MaNguoiNhan"].ToString();
}
return(ck);
}
public bool XoaChuyenKhoBUS(ref string err, ChuyenKhoO ck)
{
return(chuyenKhoDAO.XoaChuyenKho(ref err, ck));
}
public bool CapNhatChuyenKhoBUS(ref string err, ChuyenKhoO ck)
{
return(chuyenKhoDAO.CapNhatChuyenKho(ref err, ck));
}
void LayChiTietChuyenKhoByMaPhieuChuyen(ChuyenKhoO ck)
{
CTCK.MaPhieuChuyen = ck.MaPhieuChuyen;
dt = chiTietChuyenKhoBUS.GetAllChiTietChuyenKhoByMaPhieuChuyenBUS(CTCK);
gridControlChuyenKho.DataSource = dt;
}
public void TruyenChuyenKho_MaPhieuChuyen(ChuyenKhoO ck)
{
this.CK = ck;
}
public bool XoaChuyenKho(ref string err, ChuyenKhoO ck)
{
return(conn.MyExecuteNonQuery("proXoaChuyenKho",
CommandType.StoredProcedure, ref err,
new SqlParameter("@MaPhieuChuyen", ck.MaPhieuChuyen)));
}
