public void update(CongNoDaiLyDTO info) { string updateCommand = "UPDATE BaoCaoCongNo " + "SET MaDaiLy = '" + info.MaDaiLy + "', " + " Thang = '" + info.Thang + "', " + " NoDau = '" + info.NoDau + "', " + " PhatSinh = '" + info.PhatSinh + "', " + " NoCuoi = '" + info.NoCuoi + " WHERE MaBaoCao = '" + info.MaBaoCao + "'"; executeNonQuery(updateCommand); }
protected override object GetDataFromDataRow(DataTable dt, int i) { CongNoDaiLyDTO cndl = new CongNoDaiLyDTO(); cndl.MaBaoCao = dt.Rows[i]["MaBaoCao"].ToString(); cndl.MaDaiLy = dt.Rows[i]["MaDaiLy"].ToString(); cndl.Thang = DateTime.Parse(dt.Rows[i]["Thang"].ToString()); cndl.NoDau = int.Parse(dt.Rows[i]["NoDau"].ToString()); cndl.PhatSinh = int.Parse(dt.Rows[i]["PhatSinh"].ToString()); cndl.NoCuoi = int.Parse(dt.Rows[i]["NoCuoi"].ToString()); return (object)cndl; }
public void insert(CongNoDaiLyDTO info) { string insertCommand = "INSERT INTO BaoCaoCongNo VALUES('" + info.MaBaoCao + "', '" + info.MaDaiLy + "', '" + info.Thang + "', '" + info.NoDau + "', '" + info.PhatSinh + "', '" + info.NoCuoi + ")"; executeNonQuery(insertCommand); }