/// <summary>
/// Select all screen on database which is the main screen for set authorize
/// </summary>
/// <param name="database"></param>
/// <param name="userLangCD"></param>
/// <param name="defLangCD"></param>
/// <returns></returns>
public DatabaseScreenList SelectScreenWithAuthorize(Database database, NZString userLangCD, NZString defLangCD)
{
Database db = this.UseDatabase(database);
StringBuilder sb = new StringBuilder();
sb.AppendLine(" SELECT ");
sb.AppendLine(" SCREEN_CD ");
sb.AppendLine(" ,SCREEN_NAME ");
sb.AppendLine(" ,IMAGE_CD ");
sb.AppendLine(" ,SCREEN_TYPE ");
sb.AppendLine(" ,SCREEN_ACTION ");
sb.AppendLine(" ,EXT_PROGRAM ");
sb.AppendLine(" ,CRT_BY ");
sb.AppendLine(" ,CRT_DATE ");
sb.AppendLine(" ,CRT_MACHINE ");
sb.AppendLine(" ,UPD_BY ");
sb.AppendLine(" ,UPD_DATE ");
sb.AppendLine(" ,UPD_MACHINE ");
sb.AppendLine(String.Format(" ,{0}FNZ_GET_SCREEN_DESC(T.SCREEN_CD,:LANG_CD, :DEF_LANG_CD) AS SCREEN_DESC",
(db.Credential.Provider == DatabaseProvider.SQLSERVER) ? "dbo." : string.Empty));
sb.AppendLine(" ,ORIGINAL_TITLE ");
sb.AppendLine(" FROM TZ_SCREEN_MS T");
sb.AppendLine(" WHERE T.IS_AUTHORIZE = '1' ");
sb.AppendLine(" ORDER BY T.SCREEN_CD");
DataRequest request = new DataRequest(sb.ToString());
request.Parameters.Add("LANG_CD", DataType.NVarChar, userLangCD.Value);
request.Parameters.Add("DEF_LANG_CD", DataType.NVarChar, defLangCD.Value);
DataTable table = db.ExecuteQuery(request);
DatabaseScreenList listDatabaseScreen = new DatabaseScreenList();
for (int i = 0; i < table.Rows.Count; i++)
{
DatabaseScreen screen = new DatabaseScreen();
screen.ScreenCD.Value = table.Rows[i][ScreenDTO.eColumns.SCREEN_CD.ToString()];
screen.ScreenName.Value = table.Rows[i][ScreenDTO.eColumns.SCREEN_NAME.ToString()];
screen.ImageCD.Value = table.Rows[i][ScreenDTO.eColumns.IMAGE_CD.ToString()];
object obj = table.Rows[i][ScreenDTO.eColumns.SCREEN_TYPE.ToString()];
screen.ScreenType = (eScreenType)Enum.Parse(typeof(eScreenType), obj.ToString());
obj = table.Rows[i][ScreenDTO.eColumns.SCREEN_ACTION.ToString()];
screen.ShowAction = (eShowAction)Enum.Parse(typeof(eShowAction), obj.ToString());
screen.ExternalProgram.Value = table.Rows[i][ScreenDTO.eColumns.EXT_PROGRAM.ToString()];
screen.ScreenDescription.Value = table.Rows[i][ScreenLangDTO.eColumns.SCREEN_DESC.ToString()];
listDatabaseScreen.Add(screen);
}
return(listDatabaseScreen);
}
