public void HeaderRefresh()
{
_fromDate = (DateTime)rdBKM.FromDate;
_toDate = (DateTime)rdBKM.ToDate;
try
{
//diremarks oleh halim - javasign..
//membuat/menambahkan kolom lebih baik tidak menggunakan SP
//Untuk Menambah kolom Attachment apabila kolom tersebut belum ada
//using (Database db = new Database(GlobalVar.DBName))
//{
// db.Commands.Add(db.CreateCommand("usp_Bukti_ADDCOLUMN"));
// db.Commands[0].ExecuteDataTable();
//}
this.Cursor = Cursors.WaitCursor;
dtBKK = new DataTable();
using (Database db = new Database(GlobalVar.DBName))
{
dtBKK = BKK.ListHeader(db, _fromDate, _toDate);
}
//DataColumn cNoDOAndFlag = new DataColumn("NoDOAndFlag", Type.GetType("System.String"));
//cNoDOAndFlag.Expression = "NoDO + ' ' + FlagDO";
//dtDO.Columns.Add(cNoDOAndFlag);
if (dtBKK.Rows.Count > 0)
{
dtBKK.DefaultView.Sort = "TglBukti, Pos, NoBukti";
dgHeaderBKK.DataSource = dtBKK.DefaultView;
DetailRefresh();
}
else
{
dtBKKDetail.Clear();
dgDetailBKK.DataSource = dtBKKDetail.DefaultView;
}
}
catch (Exception ex)
{
Error.LogError(ex);
}
finally
{
this.Cursor = Cursors.Default;
}
}
