public int insert_dmdouong(DMDOUONG_PUBLIC dmdouong_public)
{
int parameter = 1;
string[] name = new string[parameter];
object[] values = new object[parameter];
name[0] = "@TENDM";
values[0] = dmdouong_public.TENDM;
string sql = "INSERT_DANHMUC";
return(ketnoi.Excute_Data(sql, name, values, parameter));
}
public int insert_hinhnv(HINHNV_PUBLIC hinhnv_public)
{
int parameter = 2;
string[] name = new string[parameter];
object[] values = new object[parameter];
name[0] = "@HINH";
name[1] = "@IDNV";
values[0] = hinhnv_public.HINH;
values[1] = hinhnv_public.IDNV;
string sql = "INSERT_HINHNV";
return(ketnoi.Excute_Data(sql, name, values, parameter));
}
public int insert_douong(DOUONG_PUBLIC douong_public)
{
int parameter = 3;
string[] name = new string[parameter];
object[] values = new object[parameter];
name[0] = "@IDDM";
name[1] = "@TENDOUONG";
name[2] = "@DONGIA";
values[0] = douong_public.IDDM;
values[1] = douong_public.TENDOUONG;
values[2] = douong_public.DONGIA;
string sql = "INSERT_DOUONG";
return(ketnoi.Excute_Data(sql, name, values, parameter));
}
public int insert_ban(BAN_PUBLIC ban_public)
{
int parameter = 3;
string[] name = new string[parameter];
object[] values = new object[parameter];
name[0] = "@TEN";
name[1] = "@TRANGTHAI";
name[2] = "@ODER";
values[0] = ban_public.TEN;
values[1] = ban_public.TRANGTHAI;
values[2] = ban_public.ODER;
string sql = "INSERT_BAN";
return(ketnoi.Excute_Data(sql, name, values, parameter));
}
public int insert_cthd_old(CTHD_OLD_PUBLIC cthd_old)
{
int parameter = 3;
string[] name = new string[parameter];
object[] values = new object[parameter];
name[0] = "@IDHD_OLD";
name[1] = "@IDDOUONG";
name[2] = "@SOLUONG";
values[0] = cthd_old.IDHOADON_OLD;
values[1] = cthd_old.IDDOUONG;
values[2] = cthd_old.SOLUONG;
string sql = "INSERT_CTHD_OLD";
return(ketnoi.Excute_Data(sql, name, values, parameter));
}
public int insert_hoadon(HOADON_PUBLIC hoadon_public)
{
int parameter = 4;
string[] name = new string[parameter];
object[] values = new object[parameter];
name[0] = "@IDBAN";
name[1] = "@IDNV";
name[2] = "@NGAYLAP";
name[3] = "@TRANGTHAI";
values[0] = hoadon_public.IDBAN;
values[1] = hoadon_public.IDNV;
values[2] = hoadon_public.NGAYLAP;
values[3] = hoadon_public.TRANGTHAI;
string sql = "INSERT_HOADON";
return(ketnoi.Excute_Data(sql, name, values, parameter));
}
public int insert_taikhoan(TAIKHOAN_PUBLIC taikhoan_public)
{
int parameter = 4;
string[] name = new string[parameter];
object[] values = new object[parameter];
name[0] = "@TENTK";
name[1] = "@MATKHAU";
name[2] = "@QUYEN";
name[3] = "@IDNV";
values[0] = taikhoan_public.TENTK;
values[1] = taikhoan_public.MATKHAU;
values[2] = taikhoan_public.QUYEN;
values[3] = taikhoan_public.IDNV;
string sql = "INSERT_TAIKHOAN";
return(ketnoi.Excute_Data(sql, name, values, parameter));
}
public int insert_nhanvien(NHANVIEN_PUBLIC nhanvien_public)
{
int parameter = 5;
string[] name = new string[parameter];
object[] values = new object[parameter];
name[0] = "@IDNV";
name[1] = "@TENNV";
name[2] = "@NGAYSINH";
name[3] = "@SDT";
name[4] = "@GIOITINH";
values[0] = nhanvien_public.IDNV;
values[1] = nhanvien_public.TENNV;
values[2] = nhanvien_public.NGAYSINH;
values[3] = nhanvien_public.SDT;
values[4] = nhanvien_public.GIOITINH;
string sql = "INSERT_NHANVIEN";
return(ketnoi.Excute_Data(sql, name, values, parameter));
}
public int insert_hoadon_old(HOADON_OLD_PUBLIC hd_old)
{
int parameter = 6;
string[] name = new string[parameter];
object[] values = new object[parameter];
name[0] = "@IDHOADON";
name[1] = "@IDBAN";
name[2] = "@IDNV";
name[3] = "@NGAYLAP";
name[4] = "@TRANGTHAI";
name[5] = "@TONGTIEN";
values[0] = hd_old.IDHOADON;
values[1] = hd_old.IDBAN;
values[2] = hd_old.IDNV;
values[3] = hd_old.NGAYLAP;
values[4] = hd_old.TRANGTHAI;
values[5] = hd_old.TONGTIEN;
string sql = "INSERT_HOADON_OLD";
return(ketnoi.Excute_Data(sql, name, values, parameter));
}