public DataTable dembnngay(PHIEUKHAMdto p)
{
int thamso = 1;
string[] name = new string[thamso];
object[] value = new object[thamso];
name[0] = "@ngaykham";
value[0] = p.Ngaykham;
return ketnoi.laydulieu("dembnngay", name, value, thamso);
}
public DataTable laymapk_hientai(PHIEUKHAMdto p)
{
int thamso = 1;
string[] name = new string[thamso];
object[] value = new object[thamso];
name[0] = "@ngaykham";
value[0] = p.Ngaykham;
return ketnoi.laydulieu("laymapkh_hientai", name,value, thamso);
}
public DataTable inphieukham(PHIEUKHAMdto p)
{
int thamso = 1;
string[] name = new string[thamso];
object[] value = new object[thamso];
name[0] = "@mapk";
value[0] = p.Maphieukham;
return ketnoi.laydulieu("phieukhambenh", name, value, thamso);
}
public int insert_pk(PHIEUKHAMdto p)
{
int thamso = 7;
string[] name = new string[thamso];
object[] value = new object[thamso];
name[0] = "@maphieukham";
name[1] = "@maphongkham";
name[2] = "@mabn";
name[3] = "@ngaykham";
name[4] = "@yeucaukham";
name[5] = "@chiphikham";
name[6] = "@bnthanhtoan";
value[0] = p.Maphieukham;
value[1] = p.Maphongkham;
value[2] = p.Mabn;
value[3] = p.Ngaykham;
value[4] = p.Yeucaukham;
value[5] = p.Chiphikham;
value[6] = p.Ghichu;
return ketnoi.update("insert_pk", name, value, thamso);
}
public DataTable timkiempk(PHIEUKHAMdto p)
{
int thamso = 2;
string[] name = new string[thamso];
object[] value = new object[thamso];
name[0] = "@thamso";
name[1] = "@ngaykham";
value[0] = p.Maphieukham;
value[1] = p.Ngaykham;
return ketnoi.laydulieu("timkiempk", name, value, thamso);
}
public DataTable timpk_ngaykham(PHIEUKHAMdto p, DateTime a, DateTime b)
{
int thamso = 3;
string[] name = new string[thamso];
object[] value = new object[thamso];
name[0] = "@tungay";
name[1] = "@denngay";
name[2] = "@mabn";
value[0] = a;
value[1] = b;
value[2] = p.Mabn;
return ketnoi.laydulieu("timpk_ngaykham", name, value, thamso);
}
public DataTable timkiempk(PHIEUKHAMdto p)
{
return pk.timkiempk(p);
}
public DataTable timpk_ngaykham(PHIEUKHAMdto p, DateTime a, DateTime b)
{
return pk.timpk_ngaykham(p,a, b);
}
public DataTable laymapk_hientai(PHIEUKHAMdto p)
{
return pk.laymapk_hientai(p);
}
public DataTable laybn_ngay(PHIEUKHAMdto p)
{
return pk.laybn_ngay(p);
}
public int insert_pk(PHIEUKHAMdto p)
{
return pk.insert_pk(p);
}
public DataTable inphieukham(PHIEUKHAMdto p)
{
return pk.inphieukham(p);
}
public DataTable dembnngay(PHIEUKHAMdto p)
{
return pk.dembnngay(p);
}