public bool CapNhatNhaCungCap(ref string err, NhaCungCapO ncc) { return(conn.MyExecuteNonQuery("proSuaNhaCungCap", CommandType.StoredProcedure, ref err, new SqlParameter("@MaNhaCungCap", ncc.MaNhaCungCap), new SqlParameter("@TenNhaCungCap", ncc.TenNhaCungCap), new SqlParameter("@MaKhuVuc", ncc.MaKhuVuc), new SqlParameter("@DiaChi", ncc.DiaChi), new SqlParameter("@MaSoThue", ncc.MaSoThue), new SqlParameter("@Fax", ncc.Fax), new SqlParameter("@SoDienThoai", ncc.SoDienThoai), new SqlParameter("@SoDiDong", ncc.SoDiDong), new SqlParameter("@Email", ncc.Email), new SqlParameter("@Website", ncc.Website), new SqlParameter("@TaiKhoan", ncc.TaiKhoan), new SqlParameter("@NganHang", ncc.NganHang), new SqlParameter("@GioiHanNo", ncc.GioiHanNo), new SqlParameter("@NoHienTai", ncc.NoHienTai), new SqlParameter("@ChietKhau", ncc.ChietKhau), new SqlParameter("@NguoiLienHe", ncc.NguoiLienHe), new SqlParameter("@ChucVu", ncc.ChucVu), new SqlParameter("@ThongTinKhac", ncc.ThongTinKhac), new SqlParameter("@ConQuanLy", ncc.ConQuanLy) )); }
private void lueNhaCungCap_EditValueChanged(object sender, EventArgs e) { NCC.MaNhaCungCap = lueNhaCungCap.EditValue.ToString(); NCC = nhaCungCapBUS.getOneNhaCungCap(NCC); txtTenNhaCungCap.Text = NCC.TenNhaCungCap; txtDiaChi.Text = NCC.DiaChi; txtSoDienThoai.Text = NCC.SoDienThoai; }
public FormNhaCungCap() { InitializeComponent(); themOrSua = 1; nhaCungCapBUS = new NhaCungCapBUS(); NCC = new NhaCungCapO(); khuVucBUS = new KhuVucBUS(); // load lookupEdit khu vuc lueKhuVuc.Properties.DataSource = khuVucBUS.getAllKhuVuc(); lueKhuVuc.Properties.DisplayMember = "TenKhuVuc"; lueKhuVuc.Properties.ValueMember = "MaKhuVuc"; }
public NhaCungCapO getOneNhaCungCap(NhaCungCapO ncc) { DataTable dt = new DataTable(); dt = nhaCungCapDAO.GetAllNhaCungCap(); DataRow[] result = dt.Select("MaNhaCungCap= '" + ncc.MaNhaCungCap + "'"); DataRow row = result[0]; NCC.MaNhaCungCap = row["MaNhaCungCap"].ToString(); NCC.TenNhaCungCap = row["TenNhaCungCap"].ToString(); NCC.SoDienThoai = row["SoDienThoai"].ToString(); NCC.DiaChi = row["DiaChi"].ToString(); return(NCC); }
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(); }
public UCNhaCungCap() { InitializeComponent(); nhaCungCapBUS = new NhaCungCapBUS(); ncc = new NhaCungCapO(); }
public bool XoaNhaCungCap(ref string err, NhaCungCapO ncc) { return(conn.MyExecuteNonQuery("proXoaNhaCungCap", CommandType.StoredProcedure, ref err, new SqlParameter("@MaNhaCungCap", ncc.MaNhaCungCap))); }
public bool XoaNhaCungCapBUS(ref string err, NhaCungCapO ncc) { return(nhaCungCapDAO.XoaNhaCungCap(ref err, ncc)); }
public NhaCungCapBUS() { nhaCungCapDAO = new NhaCungCapDAO(); NCC = new NhaCungCapO(); }