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; } }
public void HeaderRefresh() { _fromDate = (DateTime)rdBKM.FromDate; _toDate = (DateTime)rdBKM.ToDate; try { this.Cursor = Cursors.WaitCursor; dtBKK = new DataTable(); using (Database db = new Database(GlobalVar.DBFinance)) { 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; } }