public DataTable laydsbntheopnv(PHIEUNHAPVIENdto p)
{
int thamso = 1;
string[] name = new string[thamso];
object[] values = new object[thamso];
name[0] = "@MaPhieuNV";
values[0] = p.Maphieunv;
return kn.laydulieu("laydsbntheopnv", name, values, thamso);
}
public int insert_pnv(PHIEUNHAPVIENdto p)
{
int thamso = 8;
string[] name = new string[thamso];
object[] values = new object[thamso];
name[0] = "@maphieunv";
name[1] = "@ngaynhapvien";
name[2] = "@makhoa";
name[3] = "@manv";
name[4] = "@mapdt";
name[5] = "@magdt";
name[6] = "@lydovaovien";
name[7] = "@makhambenh";
values[0] = p.Maphieunv;
values[1] = p.Ngaynhapvien;
values[2] = p.Makhoa;
values[3] = p.Manv;
values[4] = p.Maphongdt;
values[5] = p.Magiuongdt;
values[6] = p.Lydovaovien;
values[7] = p.Makhambenh;
return kn.update("insert_phieunhapvien", name, values, thamso);
}
public DataTable laydspnvtheoma(PHIEUNHAPVIENdto p)
{
int thamso = 1;
string[] name = new string[thamso];
object[] values = new object[thamso];
name[0] = "@makhoa";
values[0] = p.Makhoa;
return kn.laydulieu("laydspnvtheoma", name, values, thamso);
}
public DataTable pnvtheophong(PHIEUNHAPVIENdto p)
{
int thamso = 1;
string[] name = new string[thamso];
object[] values = new object[thamso];
name[0] = "@phong";
values[0] = p.Maphongdt;
return kn.laydulieu("pnv_phong", name, values, thamso);
}
public DataTable pnvtheophong(PHIEUNHAPVIENdto p)
{
return nv.pnvtheophong(p);
}
public DataTable load_phieutheodoi(PHIEUNHAPVIENdto p)
{
int thamso = 1;
string[] name = new string[thamso];
object[] values = new object[thamso];
name[0] = "@maphieunv";
values[0] = p.Maphieunv;
return kn.laydulieu("load_phieutheodoi", name, values, thamso);
}
public DataTable load_phieutheodoi(PHIEUNHAPVIENdto p)
{
return nv.load_phieutheodoi(p);
}
public DataTable pnvtheoma(PHIEUNHAPVIENdto p)
{
return nv.laydspnvtheoma(p);
}
public DataTable laydsbntheopnv(PHIEUNHAPVIENdto p)
{
return nv.laydsbntheopnv(p);
}
public int insert_pnv(PHIEUNHAPVIENdto p)
{
return nv.insert_pnv(p);
}
public DataTable inphieunv(PHIEUNHAPVIENdto p)
{
return nv.inphieunv(p);
}
public DataTable dspnv(PHIEUNHAPVIENdto p)
{
return nv.dspnv(p);
}
public DataTable chitietpnv(PHIEUNHAPVIENdto p)
{
return nv.chitietpnv(p);
}