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