private void gridView1_CellValueChanged(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e) { GridView view = sender as GridView; int[] selectedRowHandles = view.GetSelectedRows(); string maHD = view.GetRowCellValue(selectedRowHandles[0], "MAHOADON").ToString(); for (int i = 0; i < editedHD.Count; i++) { if (editedHD[i].MaHD == maHD) { editedHD[i].NgayThu = Convert.ToDateTime(view.GetRowCellValue(selectedRowHandles[0], "NGAYTHU").ToString()).ToString("yyyy-MM-dd"); editedHD[i].NguoiGH = view.GetRowCellValue(selectedRowHandles[0], "NGUOIGH").ToString(); editedHD[i].DiaChi = view.GetRowCellValue(selectedRowHandles[0], "DIACHI").ToString(); editedHD[i].Sdt = view.GetRowCellValue(selectedRowHandles[0], "SDT").ToString(); return; } } string ngayThu = Convert.ToDateTime(view.GetRowCellValue(selectedRowHandles[0], "NGAYTHU").ToString()).ToString("yyyy-MM-dd"); string nguoiGH = view.GetRowCellValue(selectedRowHandles[0], "NGUOIGH").ToString(); string diaCHi = view.GetRowCellValue(selectedRowHandles[0], "DIACHI").ToString(); string sdt = view.GetRowCellValue(selectedRowHandles[0], "SDT").ToString(); DTO_HoaDonInfo hdif = new DTO_HoaDonInfo(maHD, ngayThu, nguoiGH, diaCHi, sdt); editedHD.Add(hdif); EnableResetAndSaveButton(); }
public bool UpdateHoaDonInfo(DTO_HoaDonInfo hdif) { try { _conn.Open(); SqlCommand cmd = new SqlCommand("sp_UpdateHoaDonInfo", _conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@MAHOADON", hdif.MaHD); cmd.Parameters.AddWithValue("@NGAYTHU", hdif.NgayThu); cmd.Parameters.AddWithValue("@NGUOIGH", hdif.NguoiGH); cmd.Parameters.AddWithValue("@DIACHI", hdif.DiaChi); cmd.Parameters.AddWithValue("@SDT", hdif.Sdt); if (cmd.ExecuteNonQuery() > 0) { return(true); } } catch (Exception) { } finally { _conn.Close(); } return(false); }
public bool UpdateHoaDonInfo(DTO_HoaDonInfo hdif) { return(dao.UpdateHoaDonInfo(hdif)); }