private void GVHeader_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
if (GVHeader.SelectedCells.Count == 0)
{
return;
}
switch (e.ColumnIndex)
{
case 9:
// DataRowView dv = (DataRowView)GVHeader.SelectedCells[0].OwningRow.DataBoundItem;
//DataRow drr = dv.Row;
DataRow drr = (DataRow)(GVHeader.Rows[e.RowIndex].DataBoundItem as DataRowView).Row;
double RpIden_ = Convert.ToDouble(drr["RpIden"]);
if (Convert.ToBoolean(drr["Ok"]) == true && RpIden_ > 0)
{
if (dtIden.Select("RowID='" + drr["RowID"].ToString() + "'").Length > 0)
{
MessageBox.Show("Sudah Ada di IdenTifikasi");
return;
}
DataRow drN = dtIden.NewRow();
foreach (DataColumn dc in drN.Table.Columns)
{
drN[dc.ColumnName] = drr[dc.ColumnName];
}
drr.Delete();
dtHeader.AcceptChanges();
dtIden.Rows.Add(drN);
dtIden.AcceptChanges();
GVDetail.RefreshEdit();
}
break;
}
}
public void RefreshDetail(Guid RowID)
{
if (GVHeader.Rows.Count > 0)
{
using (Database db = new Database())
{
db.Commands.Add(db.CreateCommand("usp_PenerimaanLeasingDetail"));
db.Commands[0].Parameters.Add(new Parameter("@PenerimaanUangRowID", SqlDbType.UniqueIdentifier, (Guid)GVHeader.SelectedCells[0].OwningRow.Cells["RowID"].Value));
dtDetail = db.Commands[0].ExecuteDataTable();
}
GVDetail.DataSource = dtDetail;
if (RowID != Guid.Empty)
{
GVDetail.FindRow("RowIDD", RowID.ToString());
}
}
else
{
GVDetail.DataSource = new DataTable();
}
}
private void RefreshHeader2(Guid RowID)
{
if (v_cbLeasing == true)
{
DataTable dtHeader2 = new DataTable();
using (Database db = new Database())
{
db.Commands.Add(db.CreateCommand("usp_PenerimaanLeasingTab2Header"));
//db.Commands[0].Parameters.Add(new Parameter("@RowID", SqlDbType.UniqueIdentifier, (Guid)GVHeader.SelectedCells[0].OwningRow.Cells["RowID"].Value));
db.Commands[0].Parameters.Add(new Parameter("@LeasingRowID", SqlDbType.UniqueIdentifier, (Guid)Tools.isNull(cb_Leasing.SelectedValue, Guid.Empty)));
db.Commands[0].Parameters.Add(new Parameter("@FromDate", SqlDbType.DateTime, rangeDateBox1.FromDate.Value));
db.Commands[0].Parameters.Add(new Parameter("@ToDate", SqlDbType.DateTime, rangeDateBox1.ToDate.Value));
dtHeader2 = db.Commands[0].ExecuteDataTable();
}
GVHeader2.DataSource = dtHeader2;
txt_SaldoPiutang.Text = dtHeader2.DefaultView.ToTable().Compute("SUM(SaldoSBD) +SUM(SaldoLSG) ", "").ToString();
if (RowID != Guid.Empty)
{
GVDetail.FindRow("RowIDD", RowID.ToString());
}
}
}
public void RefreshDetail(Guid RowIDD)
{
try
{
DataTable dt = new DataTable();
using (Database db = new Database())
{
db.Commands.Add(db.CreateCommand("usp_IdenPengajuanBBN_ListDetail"));
db.Commands[0].Parameters.Add(new Parameter("@RowID", SqlDbType.UniqueIdentifier, (Guid)GVHeader.SelectedCells[0].OwningRow.Cells["RowID"].Value));
dt = db.Commands[0].ExecuteDataTable();
}
_DataDetail = dt;
GVDetail.DataSource = dt;
if (dt.Rows.Count > 0 && RowIDD != Guid.Empty)
{
GVDetail.FindRow("RowID_PU", RowIDD.ToString());
}
}
catch (Exception ex)
{
Error.LogError(ex);
}
}
