public void update(PhieuGiaoDichDTO info) { string updateCommand = "UPDATE PhieuGiaoDich " + "SET MaDaiLy = '" + info.MaDaiLy + "', " + " NgayLapPhieu = '" + info.NgayLapPhieu + "', " + " LoaiPhieu = '" + info.LoaiPhieu + "', " + " WHERE MaPhieu = '" + info.MaPhieu + "'"; executeNonQuery(updateCommand); }
protected override object GetDataFromDataRow(DataTable dt, int i) { PhieuGiaoDichDTO pgd = new PhieuGiaoDichDTO(); pgd.MaPhieu = dt.Rows[i]["MaPhieu"].ToString(); pgd.MaDaiLy = dt.Rows[i]["MaDaiLy"].ToString(); pgd.NgayLapPhieu = DateTime.Parse(dt.Rows[i]["NgayLapPhieu"].ToString()); pgd.LoaiPhieu = dt.Rows[i]["LoaiPhieu"].ToString(); return (object)pgd; }
public void insert(PhieuGiaoDichDTO info) { string insertCommand = "INSERT INTO PhieuGiaoDich VALUES('" + info.MaPhieu + "', '" + info.MaDaiLy + "', '" + info.NgayLapPhieu + "', '" + info.LoaiPhieu + ")"; executeNonQuery(insertCommand); }