public int themdulieu(EC_hopdong ec)
{
string sql = "themhd";
int so_luong = 4;
string[] Name = new string[so_luong];
object[] Values = new string[so_luong];
Name[0] = "@ma"; Values[0] = ec.Ma;
Name[1] = "@nhanvienma"; Values[1] = ec.Nhanvienma;
Name[2] = "@ngayki"; Values[2] = ec.Ngayki.ToString();
Name[3] = "@ngayhethan"; Values[3] = ec.Ngayhethan.ToString();
return(kn.StoProc(sql, Name, Values, so_luong));
}
//hàm xóa
public void xoadulieu(EC_hopdong et)
{
sql.xoadulieu(et);
}
//hàm sửa
public void suadulieu(EC_hopdong et)
{
sql.suadulieu(et);
}
public void themdulieu(EC_hopdong et)
{
sql.themdulieu(et);
}
public void suadulieu(EC_hopdong ec)
{
kn.ThucThiCauLenhSQL("update hopdong set nhanvienma =N'" + ec.Nhanvienma + "', ngayki = N'" + ec.Ngayki + "' ,ngayhethan =N'" + ec.Ngayhethan + "' where ma='" + ec.Ma + "'");
}
public void xoadulieu(EC_hopdong ec)
{
kn.ThucThiCauLenhSQL("delete hopdong where ma='" + ec.Ma + "'");
}
