public void update(LoaiDaiLyDTO info)
{
string updateCommand = "UPDATE LoaiDaiLy " +
"SET TenLoai = '" + info.TenLoaiDaiLy + "', " +
" SoTienNoToiDa = '" + info.SoTienNoToiDa + "', " +
" WHERE MaLoai = '" + info.MaLoaiDaiLy + "'";
executeNonQuery(updateCommand);
}
protected override object GetDataFromDataRow(DataTable dt, int i)
{
LoaiDaiLyDTO loai = new LoaiDaiLyDTO();
loai.MaLoaiDaiLy = dt.Rows[i]["MaLoai"].ToString();
loai.TenLoaiDaiLy = dt.Rows[i]["TenLoai"].ToString();
loai.SoTienNoToiDa = int.Parse(dt.Rows[i]["SoTienNoToiDa"].ToString());
return (object)loai;
}
public void insert(LoaiDaiLyDTO info)
{
string insertCommand = "INSERT INTO LoaiDaiLy VALUES('" +
info.MaLoaiDaiLy + "', '" +
info.TenLoaiDaiLy + "', '" +
info.SoTienNoToiDa + ")";
executeNonQuery(insertCommand);
}
