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); }