public string GetSqlSelectDocumentVariableKey(
string ModuleName, string VariableName)
{
return(string.Concat(
"SELECT DocumentKey FROM _System_RoleModuleDocument WHERE ProductName=",
Dp.FormatSqlValue(BaseFramework.ProductName),
" AND RoleName=", Dp.FormatSqlValue(_CurrentRole),
" AND ModuleName=", Dp.FormatSqlValue(ModuleName),
" AND VariableName=", Dp.FormatSqlValue(VariableName)));
}
protected override string GetBrowseFilter()
{
switch (FormMode)
{
case enFormPerintahBayar.PerintahBayar:
return(string.Empty);
default: //enFormPerintahBayar.PengeluaranUang:
return("Status=" +
Dp.FormatSqlValue(enStatusPerintahBayar.SudahDibayar));
}
}
protected override void GetDataSource(out string DataSource,
out string DataSourceOrder, List <FieldParam> Parameters)
{
DataSource = string.Concat(
@"SELECT NoAkun,NamaAkun,LevelAkun,UrutanCetak,Posting,",
Dp.GetSqlCoalesce("Saldo", 0), @" as Saldo FROM (SELECT UrutanCetak,
NoAkun,NamaAkun,LevelAkun,Posting,Aktif,(SELECT SUM(Debit-Kredit)
FROM (", BaseGL.RingkasanAkun.SqlPosisiAkun(_TglNeraca, "1", Parameters),
@") pp WHERE pp.IdAkun=qq.IdAkun OR pp.IdAkun LIKE qq.IdAkun
+'.%') as Saldo FROM Akun qq WHERE LevelAkun<=@0 AND JenisAkun<>",
Dp.FormatSqlValue(enJenisAkun.Laba__Rugi), ") zz WHERE Aktif<>0");
Parameters.Add(new FieldParam("0", _LevelCetak));
DataSourceOrder = "UrutanCetak";
}