public int insert_benhnhan(BENHNHANdto p)
{
int thamso = 10;
string[] name = new string[thamso];
object[] value = new object[thamso];
name[0] = "@mabn";
name[1] = "@tenbn";
name[2] = "@ngsinh";
name[3] = "@gioitinh";
name[4] = "@cmnd";
name[5] = "@diachi";
name[6] = "@nghenghiep";
name[7] = "@honnhan";
name[8] = "@dantoc";
name[9] = "@checkBHYT";
value[0] = p.Mabn;
value[1] = p.Tenbn;
value[2] = p.Ngsinh;
value[3] = p.Gioitinh;
value[4] = p.Cmnd;
value[5] = p.Diachi;
value[6] = p.Nghenghiep;
value[7] = p.Honnhan;
value[8] = p.Dantoc;
value[9] = p.CheckBHYT;
return cls.update("insert_bn", name, value, thamso);
}
public DataTable laybntheoma(BENHNHANdto p)
{
int thamso = 1;
string[] name = new string[thamso];
object[] value = new object[thamso];
name[0] = "@mabn";
value[0] = p.Mabn;
return cls.laydulieu("laybntheoma", name, value, thamso);
}
public DataTable dsbn_gioitinh(BENHNHANdto p)
{
int thamso = 1;
string[] name = new string[thamso];
object[] value = new object[thamso];
name[0] = "@gioitinh";
value[0] = p.Gioitinh;
return cls.laydulieu("dsbn_gioitinh", name, value, thamso);
}
public DataTable dsbn_bhyt(BENHNHANdto p)
{
int thamso = 1;
string[] name = new string[thamso];
object[] value = new object[thamso];
name[0] = "@checkbhyt";
value[0] = p.CheckBHYT;
return cls.laydulieu("dsbn_BHYT", name, value, thamso);
}
public DataTable laymakb_tenbn(BENHNHANdto p)
{
return bnDAO.laymakb_tenbn(p);
}
public DataTable laydsbntheoma(BENHNHANdto bn)
{
return bnDAO.laydsbntheoma(bn);
}
public int insert_bn(BENHNHANdto bn)
{
return bnDAO.insert_benhnhan(bn);
}
public DataTable dspxv_mabn(BENHNHANdto p)
{
return bnDAO.dspxv_mabn(p);
}
public DataTable dsbn_gioitinh(BENHNHANdto p)
{
return bnDAO.dsbn_gioitinh(p);
}
public DataTable timkiembn_gg(BENHNHANdto p)
{
int thamso = 1;
string[] name = new string[thamso];
object[] value = new object[thamso];
name[0] = "@tenbn";
value[0] = p.Tenbn;
return cls.laydulieu("timkiemtenbn_gg", name, value, thamso);
}
public DataTable timkiembn_gg(BENHNHANdto p)
{
return bnDAO.timkiembn_gg(p);
}
public DataTable ttpk_mabn(BENHNHANdto p)
{
return bnDAO.ttpk_mabn(p);
}
public int xoabn(BENHNHANdto p)
{
int thamso = 1;
string[] name = new string[thamso];
object[] value = new object[thamso];
name[0] = "@mabn";
value[0] = p.Mabn;
return cls.update("xoabn", name, value, thamso);
}
public DataTable timtenbn_ngkham(BENHNHANdto p, DateTime a, DateTime b)
{
int thamso = 3;
string[] name = new string[thamso];
object[] value = new object[thamso];
name[0] = "@tenbn";
name[1] = "@tungay";
name[2] = "@denngay";
value[0] = p.Tenbn;
value[1] = a;
value[2] = b;
return cls.laydulieu("timtenbn_ngkham", name, value, thamso);
}
public int sua_bn(BENHNHANdto bn)
{
return bnDAO.sua_benhnhan(bn);
}
public int xoabn(BENHNHANdto bn)
{
return bnDAO.xoabn(bn);
}
public DataTable timkiembntheoma(BENHNHANdto bn)
{
return bnDAO.timkiembntheoma(bn);
}
public DataTable dsbn_bhyt(BENHNHANdto p)
{
return bnDAO.dsbn_bhyt(p);
}
public DataTable timtenbn_ngkham(BENHNHANdto p, DateTime a, DateTime b)
{
return bnDAO.timtenbn_ngkham(p, a, b);
}
public DataTable laymakb_tenbn(BENHNHANdto p)
{
int thamso = 1;
string[] name = new string[thamso];
object[] value = new object[thamso];
name[0] = "@tenbn";
value[0] = p.Tenbn;
return cls.laydulieu("laymakb_tenbn", name, value, thamso);
}
