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