private SqlCommand GetInstUiFieldCommand()
{
string sql = @"SELECT DUIP.INST_CODE, DUIV.DUIV_VERSION_VALUE, DUI.DUI_NAME, DUI.DUI_CODE
FROM TLK_DYNAMICUI_FIELDS DUIF
INNER JOIN TLK_DYNAMICUI_VERSIONS DUIV
ON DUIF.DUIV_CODE=DUIV.DUIV_CODE
INNER JOIN TLK_DATASOURCES_FIELDS DSF
ON DSF.DSF_CODE=DUIF.DSF_CODE AND DSF.DSF_FIELDNAME=@field_name
INNER JOIN TLK_DYNAMICUI_DEPL_PROP DUIP
ON DUIP.DUIP_CODE = DUIV.DUIP_CODE AND DUIP.INST_CODE=@inst_code
INNER JOIN TLK_DYNAMICUI DUI
ON DUI.DUI_CODE=DUIP.DUI_CODE AND DUI.DUI_NAME=@dui_name
INNER JOIN TLK_UI_ROLES UIR
ON UIR.UIR_INTERNAL_DESC=DUIV.DUIV_VERSION_VALUE AND UIR.UIR_DESCRIPTION=@version_value";
if (VersionValue.Equals("#BASE_VERSION#"))
{
sql = @"SELECT DUIP.INST_CODE, DUIV.DUIV_VERSION_VALUE, DUI.DUI_NAME, DUI.DUI_CODE, DSRC.DSRC_NAME, DSRC.DSRC_CODE
FROM TLK_DYNAMICUI DUI
INNER JOIN TLK_DYNAMICUI_DEPL_PROP DUIP
ON DUIP.DUI_CODE = DUI.DUI_CODE AND DUIP.INST_CODE=@inst_code
INNER JOIN TLK_DYNAMICUI_VERSIONS DUIV
ON DUIV.DUIP_CODE=DUIP.DUIP_CODE AND DUIV.DUIV_VERSION_VALUE='#BASE_VERSION#'
INNER JOIN TLK_DATASOURCES DSRC
ON DUI.DSRC_CODE = DSRC.DSRC_CODE
WHERE DUI.DUI_NAME=@dui_name";
}
SqlCommand command = new SqlCommand(sql);
command.Parameters.Add("@version_value", SqlDbType.NVarChar, 50).Value = VersionValue;
command.Parameters.Add("@field_name", SqlDbType.NVarChar, 50).Value = FieldName;
command.Parameters.Add("@dui_name", SqlDbType.NVarChar, 50).Value = DynamicUIName;
command.Parameters.Add("@inst_code", SqlDbType.Int).Value = InstallationCode;
return(command);
}
