public void update(PhieuXuatHangDTO info) { string updateCommand = "UPDATE PhieuXuatHang " + "SET TongTienXuat = '" + info.TongTienXuat + "', " + " WHERE MaPhieu = '" + info.MaPhieuXuatHang + "'"; executeNonQuery(updateCommand); }
protected override object GetDataFromDataRow(DataTable dt, int i) { PhieuXuatHangDTO ptt = new PhieuXuatHangDTO(); ptt.MaPhieuXuatHang = dt.Rows[i]["MaPhieu"].ToString(); ptt.TongTienXuat = int.Parse(dt.Rows[i]["TongTienXuat"].ToString()); return (object)ptt; }
public void insert(PhieuXuatHangDTO info) { string insertCommand = "INSERT INTO PhieuXuatHang VALUES('" + info.MaPhieuXuatHang + "', '" + info.TongTienXuat + ")"; executeNonQuery(insertCommand); }