public void update(QuanDTO info)
{
string updateCommand = "UPDATE Quan " +
"SET TenQuan = '" + info.TenQuan + "', " +
"SoDaiLyToiDa = '" + info.SoDaiLyToiDa + "', " +
" WHERE MaQuan = '" + info.MaQuan + "'";
executeNonQuery(updateCommand);
}
protected override object GetDataFromDataRow(DataTable dt, int i)
{
QuanDTO quan = new QuanDTO();
quan.MaQuan = dt.Rows[i]["MaQuan"].ToString();
quan.TenQuan = dt.Rows[i]["TenQuan"].ToString();
quan.SoDaiLyToiDa = int.Parse(dt.Rows[i]["SoDaiLyToiDa"].ToString());
return (object)quan;
}
public void insert(QuanDTO info)
{
string insertCommand = "INSERT INTO Quan VALUES('" +
info.MaQuan + "', '" +
info.TenQuan + "', '" +
info.SoDaiLyToiDa + ")";
executeNonQuery(insertCommand);
}
