private void Delete2(Guid ROwID_) { string NoBukti = GVSubDetail.SelectedCells[0].OwningRow.Cells["TglRencana"].Value.ToString(); if (MessageBox.Show("Hapus Rencana Tanggal " + NoBukti + " ?", "DELETE", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { try { using (Database db = new Database()) { db.Commands.Add(db.CreateCommand("[usp_CF_RencanaPembayaranUangMukaSubDetail_DELETE]")); db.Commands[0].Parameters.Add(new Parameter("@RowID", SqlDbType.UniqueIdentifier, ROwID_)); db.Commands[0].ExecuteNonQuery(); } int i = 0; int n = 0; i = GVSubDetail.SelectedCells[0].RowIndex; n = GVSubDetail.SelectedCells[0].ColumnIndex; DataRowView dv = (DataRowView)GVSubDetail.SelectedCells[0].OwningRow.DataBoundItem; DataRow dr = dv.Row; dr.Delete(); dtS.AcceptChanges(); GVSubDetail.Focus(); if (GVRencana.RowCount > 0) { if (i == 0) { GVSubDetail.CurrentCell = GVRencana.Rows[0].Cells[n]; GVSubDetail.RefreshEdit(); } else { GVSubDetail.CurrentCell = GVRencana.Rows[i - 1].Cells[n]; GVSubDetail.RefreshEdit(); } GVSubDetail.RefreshEdit(); } } catch (Exception ex) { Error.LogError(ex); } } }
public void RefreshRowDataGridDetail2(Guid RowID_) { DataTable dt = new DataTable(); DataTable dtRefresh; using (Database db = new Database()) { db.Commands.Add(db.CreateCommand("usp_CF_RencanaPembayaranUangMukaSubDetail_List")); db.Commands[0].Parameters.Add(new Parameter("@RowID", SqlDbType.UniqueIdentifier, RowID_)); db.Commands[0].Parameters.Add(new Parameter("@PerusahaanID", SqlDbType.UniqueIdentifier, GlobalVar.PerusahaanRowID)); dtRefresh = db.Commands[0].ExecuteDataTable(); } if (dtRefresh.Rows.Count > 0) { GVSubDetail.RefreshDataRow(dtRefresh.Rows[0], "RowID", RowID_.ToString()); GVSubDetail.FindRow("RowIDSubDetail", RowID_.ToString()); dtD.AcceptChanges(); DataRowView dv = (DataRowView)GVSubDetail.SelectedCells[0].OwningRow.DataBoundItem; dtS.AcceptChanges(); GVSubDetail.RefreshEdit(); } }