public void Xoa(QL_DuAn_InFo duan)
{
SqlCommand s = new SqlCommand("Delete from DuAn where MaDuAn = @ma");
s.Parameters.Add("@ma", SqlDbType.Int).Value = duan.MaDuAn;
//ds.Load(s);
//return ds;
ds.Execute(s);
}
public void Sua(QL_DuAn_InFo duan)
{
SqlCommand s = new SqlCommand("Update DuAn set TenDuAn = @ten, MaLoaiDuAn = @loai, DiaDiemXayDung = @diadiem, ThoiGian = @thoigian, NanglucThietKe = @nangluc, TongVon = @tongvon, MaDoanhNghiep = @madoanhnghiep where MaDuAn = @ma");
s.Parameters.Add("@ma", SqlDbType.Int).Value = duan.MaDuAn;
s.Parameters.Add("@ten", SqlDbType.NVarChar, 255).Value = duan.TenDuAn;
s.Parameters.Add("@loai", SqlDbType.Int).Value = duan.Loaiduan.MaLoaiDuAn;
s.Parameters.Add("@diadiem", SqlDbType.NVarChar, 200).Value = duan.DiaDiemXayDung;
s.Parameters.Add("@thoigian", SqlDbType.NVarChar, 50).Value = duan.ThoiGian;
s.Parameters.Add("@nangluc", SqlDbType.NVarChar, 200).Value = duan.NangLucThietKe;
s.Parameters.Add("@tongvon", SqlDbType.Int).Value = duan.TongVon;
s.Parameters.Add("@madoanhnghiep", SqlDbType.Int).Value = duan.Doanhnghiep.MaDoanhNghiep;
//ds.Load(s);
//return ds;
ds.Execute(s);
}
public void Them(QL_DuAn_InFo duan)
{
SqlCommand s = new SqlCommand("INSERT INTO DuAn(MaDuAn, TenDuAn, MaLoaiDuAn, DiaDiemXayDung, ThoiGian, NangLucThietKe, TongVon, MaDoanhNghiep) "
+ "VALUES(@ma, @ten, @loai, @diadiem, @thoigian, @nangluc, @tongvon, @madoanhnghiep)");
s.Parameters.Add("@ma", SqlDbType.Int).Value = duan.MaDuAn;
s.Parameters.Add("@ten", SqlDbType.NVarChar, 255).Value = duan.TenDuAn;
s.Parameters.Add("@loai", SqlDbType.Int).Value = duan.Loaiduan.MaLoaiDuAn;
s.Parameters.Add("@diadiem", SqlDbType.NVarChar, 200).Value = duan.DiaDiemXayDung;
s.Parameters.Add("@thoigian", SqlDbType.NVarChar, 50).Value = duan.ThoiGian;
s.Parameters.Add("@nangluc", SqlDbType.NVarChar, 200).Value = duan.NangLucThietKe;
s.Parameters.Add("@tongvon", SqlDbType.Int).Value = duan.TongVon;
s.Parameters.Add("@madoanhnghiep", SqlDbType.Int).Value = duan.Doanhnghiep.MaDoanhNghiep;
//ds.Load(s);
//return ds;
ds.Execute(s);
}
public void Sua(QL_DuAn_InFo duan)
{
data.Sua(duan);
}
public void Xoa(QL_DuAn_InFo duan)
{
data.Xoa(duan);
}
public void Them(QL_DuAn_InFo duan)
{
data.Them(duan);
}
