public static EmDomainType GetUserDomainType(int?userId)
{
string userName;
int? v2kuid;
string timeZoneInfoToken = string.Empty;
EmDomainType aDomainType = DDSetup.GetDomainTypeAndV2kUID(userId, out v2kuid, out userName, out timeZoneInfoToken);
return(aDomainType);
}
public static void SetupDDReportRuntimeParameter(ReportRuntime ddRuntime, int?aUId)
{
if (aUId != null)
{
if (ddRuntime.Parameters[DDSetup.ReportParameterUid] != null)
{
ddRuntime.Parameters[DDSetup.ReportParameterUid].CurrentValue = aUId;
}
//string userName;
//int? v2kuid;
//EmDomainType aDomainType = DDSetup.GetDomainTypeAndV2kUID(aUId, out v2kuid, out userName);
string userName = string.Empty;
string timeZoneInfoToken = string.Empty;
int? v2kuid;
EmDomainType aDomainType = DDSetup.GetDomainTypeAndV2kUID(aUId, out v2kuid, out userName, out timeZoneInfoToken);
if (ddRuntime.Parameters[DDSetup.ReportParameterCurrentUserName] != null)
{
ddRuntime.Parameters[DDSetup.ReportParameterCurrentUserName].CurrentValue = userName;
}
if (ddRuntime.Parameters[DDSetup.ReportParameterClientTimeZonekey] != null)
{
ddRuntime.Parameters[DDSetup.ReportParameterClientTimeZonekey].CurrentValue = timeZoneInfoToken;;
}
if (v2kuid.HasValue)
{
if (ddRuntime.Parameters[DDSetup.ReportParameterCurrentUserName] != null)
{
ddRuntime.Parameters[DDSetup.ReportParameterCurrentUserName].CurrentValue = userName;
}
if (aDomainType == EmDomainType.Vendor)
{
if (ddRuntime.Parameters[DDSetup.ReportParameterVendorID] != null)
{
ddRuntime.Parameters[DDSetup.ReportParameterVendorID].CurrentValue = v2kuid.Value.ToString();
}
}
else if (aDomainType == EmDomainType.Customer)
{
if (ddRuntime.Parameters[DDSetup.ReportParameterCustomerID] != null)
{
ddRuntime.Parameters[DDSetup.ReportParameterCustomerID].CurrentValue = v2kuid.Value.ToString();;
}
}
}
}
}
public static string GetUserReportFileName(int userId, object reportId)
{
string dictToReturn = string.Empty;
string qeuryReportNameAndFileName = string.Empty;
// EmDomainType userDomainType = GetUserDomainType(userId);
string userName;
int? v2kuid;
string timeZoneInfoToken = string.Empty;
EmDomainType userDomainType = DDSetup.GetDomainTypeAndV2kUID(userId, out v2kuid, out userName, out timeZoneInfoToken);
if (userDomainType == EmDomainType.SysAdmin)
{
qeuryReportNameAndFileName = @" SELECT pdmReportWebPublish.ReportFileName FROM pdmReportWebPublish where ReportId=@ReportId ";
}
else
{
qeuryReportNameAndFileName = string.Format(@" SELECT
pdmReportWebPublish.ReportFileName
FROM pdmReportPublishSecurity INNER JOIN
pdmReportWebPublish ON pdmReportPublishSecurity.ReportID = pdmReportWebPublish.ReportID
where pdmReportWebPublish.ReportID = @ReportId and ( pdmReportPublishSecurity.SecurityWebUserID = {0} or
pdmReportPublishSecurity.SecurityUserGroupID in (
SELECT pdmSecurityGroupMember.GroupID
FROM pdmSecurityGroupMember where pdmSecurityGroupMember.UserID ={1}
))
", userId, userId);
}
using (SqlConnection conn = new SqlConnection(PLMConnectionString))
{
conn.Open();
SqlCommand cmd = new SqlCommand(qeuryReportNameAndFileName, conn);
cmd.Parameters.Add(new SqlParameter("@ReportId", reportId));
dictToReturn = cmd.ExecuteScalar() as string;
}
WriteReportTrace(userName, dictToReturn);
return(dictToReturn);
}
private static void ConfigureCrystalReportParamter(ReportDocument crystalReportDocument, int?aUId, string productReferenceId, string PdmRequestRegisterID, string mainReferenceID, string masterReferenceID)
{
if (aUId.HasValue)
{
SetupReportParameter(crystalReportDocument, DDSetup.ReportParameterUid, aUId);
string userName;
int? v2kuid;
string timeZoneInfoToken = string.Empty;
EmDomainType aDomainType = DDSetup.GetDomainTypeAndV2kUID(aUId, out v2kuid, out userName, out timeZoneInfoToken);
if (!string.IsNullOrEmpty(userName))
{
if (IsExistParaName(crystalReportDocument, DDSetup.ReportParameterCurrentUserName))
{
SetupReportParameter(crystalReportDocument, DDSetup.ReportParameterCurrentUserName, userName);
}
else // try to setup _MutipleProductReferenceIDs
{
SetupReportParameter(crystalReportDocument, DDSetup.ReportParameterCurrentUserName, userName);
}
}
if (v2kuid.HasValue)
{
if (aDomainType == EmDomainType.Vendor)
{
SetupReportParameter(crystalReportDocument, DDSetup.ReportParameterVendorID, v2kuid.Value);
}
else if (aDomainType == EmDomainType.Customer)
{
}
}
if (!string.IsNullOrEmpty(productReferenceId))
{
if (IsExistParaName(crystalReportDocument, DDSetup.ReportParameterProductReferenceID))
{
SetupReportParameter(crystalReportDocument, DDSetup.ReportParameterProductReferenceID, productReferenceId);
}
else// try to setup _MutipleProductReferenceIDs
{
SetupReportParameter(crystalReportDocument, DDSetup.ReportParameterMutipleProductReferenceIDs, productReferenceId);
}
}
// need 2014-02-17 to add two paramters to mainReferenceID,masterReferenceID
if (!string.IsNullOrEmpty(mainReferenceID))
{
if (IsExistParaName(crystalReportDocument, DDSetup.QueryReportParameterMainReferenceID))
{
SetupReportParameter(crystalReportDocument, DDSetup.QueryReportParameterMainReferenceID, mainReferenceID);
}
}
if (!string.IsNullOrEmpty(timeZoneInfoToken))
{
if (IsExistParaName(crystalReportDocument, DDSetup.ReportParameterClientTimeZonekey))
{
SetupReportParameter(crystalReportDocument, DDSetup.ReportParameterClientTimeZonekey, timeZoneInfoToken);
}
}
if (!string.IsNullOrEmpty(masterReferenceID))
{
if (IsExistParaName(crystalReportDocument, DDSetup.QueryReportParameterMasterReferenceID))
{
SetupReportParameter(crystalReportDocument, DDSetup.QueryReportParameterMasterReferenceID, masterReferenceID);
}
}
if (!string.IsNullOrEmpty(PdmRequestRegisterID))
{
// need format like this '1,2,3,4,6'
SetupCrystalReportRequestRegisterId(crystalReportDocument, PdmRequestRegisterID);
}
// need to set up ReportParameterApplicationServerUrl for report iamge url
if (IsExistParaName(crystalReportDocument, DDSetup.ReportParameterImageUrl))
{
SetupReportParameter(crystalReportDocument, DDSetup.ReportParameterImageUrl, DDSetup.ReorptSetup.ReportingServerImageUrl);
}
// if( this._ProductReferenceId
}
}
