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