public int taoHoaDon(string[] param) { String[] name = { "@MAHD", "@MANV", "@MAKH", "@MAKHO", "@MAVT", "@SOLUONG", "@DONGIA" }; int i = Access.ExecuteNonQuery(SP_TAO_HOADON, name, param, 7); return(i); }
public int taoHoaDon(string[] param) { String[] name = { "@XmlData" }; int i = Access.ExecuteNonQuery(SP_TAO_PHIEUXUAT, name, param, 1); return(i); }
//chuyển nhân viên sang chi nhánh khác để làm việc public int ChuyenNV(string[] param) { string[] name = { "@MANV", "@MACN", "@TENLOGIN", "@ROLE" }; int x = Access.ExecuteNonQuery(SP_CHUYEN_NV, name, param, 4); return(x); }
public int taoKhachHang(string[] param) { String[] name = { "@MAKH", "@TENKH", "@SODT", "@DIACHI" }; int i = Access.ExecuteNonQuery(SP_TAO_KH, name, param, 4); return(i); }
public int DoiMatKhau(string[] param) // doi mat khau { string[] name = { "@oldpassword", "@newpassword", "@login" }; int x = Access.ExecuteNonQuery(SP_DOIMATKHAU, name, param, 3); return(x); }
public int InserCusomer(string[] param) { string[] name = { "@HO", "@TEN", "@PHAI", "@NGAYSINH", "@DIACHI", "@SDT", "@LGNAME", "@PASS", "@ROLE" }; int x = Access.ExecuteNonQuery("SP_TAOTAIKHOAN_NHANVIEN", name, param, 9); return(x); }
public int CreatePhieuNhap(string[] param) { string[] name = { "@XmlData" }; int x = Access.ExecuteNonQuery(SP_TAO_PHIEUNHAP, name, param, 1); return(x); }
public int Create_DonHang(string[] param) { string[] name = { "@XmlData" }; int x = Access.ExecuteNonQuery("SP_TAO_DONHANG", name, param, 1); return(x); }
public int Create_DonHang(string[] param) { string[] name = { "@MADDH", "@MAVT", "@SOLUONG", "@MANV", "@MAKHO", "@NHACC" }; int x = Access.ExecuteNonQuery("SP_TAO_DONHANG", name, param, 6); return(x); }
public int ThemVTNCC(string[] param) { string[] name = { "@MANCC", "@MAVT" }; int x = Access.ExecuteNonQuery(SP_THEM_VT_NCC, name, param, 2); return(x); }
public int xoaVTNCC(string[] param) { string[] name = { "MANCC", "MAVT" }; int x = Access.ExecuteNonQuery(SP_XOA_VT_NCC, name, param, 2); return(x); }
//tao nha cung cap public int CreateNCC(string[] param) { string[] name = { "@MANCC", "@TENNCC", "@DIACHI", "@SDT", "@MAVT" }; int x = Access.ExecuteNonQuery(SP_TAO_NCC, name, param, 5); return(x); }
public int CreatePhieuNhap(string[] param) { string[] name = { "@MAPN", "@MADDH", "@MAVT", "@MANV", "@SL_NHAP", "@DONGIA_NHAP" }; int x = Access.ExecuteNonQuery(SP_TAO_PHIEUNHAP, name, param, 6); return(x); }