public void RefreshRowDataGridDetail(Guid RowID_)
{
DataTable dt = new DataTable();
DataTable dtRefresh;
using (Database db = new Database())
{
db.Commands.Add(db.CreateCommand("usp_CF_RencanaPembayaranHutangDetail_List"));
db.Commands[0].Parameters.Add(new Parameter("@RowID", SqlDbType.UniqueIdentifier, RowID_));
dtRefresh = db.Commands[0].ExecuteDataTable();
}
if (dtRefresh.Rows.Count > 0)
{
GVRencana.RefreshDataRow(dtRefresh.Rows[0], "RowID", RowID_.ToString());
GVRencana.FindRow("RowID3", RowID_.ToString());
dtD.AcceptChanges();
DataRowView dv = (DataRowView)GVPL.SelectedCells[0].OwningRow.DataBoundItem;
DataRow dr = dv.Row;
dr.BeginEdit();
dr["SaldoUSD"] = Convert.ToDouble(dr["NominalUSD"]) - Convert.ToDouble(dtD.Compute("SUM(USDNominal)", ""));
dr["SaldoIDR"] = Convert.ToDouble(dr["NominalIDR"]) - Convert.ToDouble(dtD.Compute("SUM(IDRNominal)", ""));
GVPL.SelectedCells[0].OwningRow.Cells["SaldoUSD"].Value = dr["SaldoUSD"];
GVPL.SelectedCells[0].OwningRow.Cells["SaldoIDR"].Value = dr["SaldoIDR"];
dr.EndEdit();
dr.AcceptChanges();
dtH.AcceptChanges();
GVPL.RefreshEdit();
}
}
public void RefreshRowDataGridDetail(Guid RowID_)
{
DataTable dt = new DataTable();
DataTable dtRefresh;
using (Database db = new Database())
{
db.Commands.Add(db.CreateCommand("usp_CF_RencanaGlobal_Detail"));
db.Commands[0].Parameters.Add(new Parameter("@RowID", SqlDbType.UniqueIdentifier, RowID_));
dtRefresh = db.Commands[0].ExecuteDataTable();
}
if (dtRefresh.Rows.Count > 0)
{
GVRencana.RefreshDataRow(dtRefresh.Rows[0], "RowID", RowID_.ToString());
GVRencana.FindRow("RowID3", RowID_.ToString());
dtD.AcceptChanges();
}
}
