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();
}
}
