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();; } } } } }
// key: reportName value:int public static Dictionary <string, string> GetDictUserReportNameAndFileNameReportss(int userId) { Dictionary <string, string> dictToReturn = new Dictionary <string, string>(); string qeuryReportNameAndFileName = string.Empty; EmDomainType userDomainType = GetUserDomainType(userId); if (userDomainType == EmDomainType.SysAdmin) { qeuryReportNameAndFileName = @" SELECT distinct pdmReportWebPublish.ReportName, pdmReportWebPublish.ReportFileName FROM pdmReportWebPublish "; } else { qeuryReportNameAndFileName = string.Format(@" SELECT distinct pdmReportWebPublish.ReportName, pdmReportWebPublish.ReportFileName FROM pdmReportPublishSecurity INNER JOIN pdmReportWebPublish ON pdmReportPublishSecurity.ReportID = pdmReportWebPublish.ReportID where 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); SqlDataAdapter adapter = new SqlDataAdapter(cmd); System.Data.DataTable resultTabel = new DataTable(); adapter.Fill(resultTabel); if (resultTabel.Rows.Count > 0) { foreach (DataRow row in resultTabel.Rows) { string reportname = row["ReportName"].ToString(); string reportFileName = row["ReportFileName"].ToString(); if (!dictToReturn.ContainsKey(reportname)) { dictToReturn.Add(reportname, reportFileName); } } } } return(dictToReturn); }
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); }
public void ConfigureCrystalReportParameters(ReportDocument customerReport) { if (_UId.HasValue) { SetupReportParameter(customerReport, DDSetup.ReportParameterUid, this._UId.Value); string userName; int? v2kuid; string timeZoneInfoToken = string.Empty; EmDomainType aDomainType = DDSetup.GetDomainTypeAndV2kUID(_UId, out v2kuid, out userName, out timeZoneInfoToken); if (!string.IsNullOrEmpty(userName)) { if (IsExistParaName(customerReport, DDSetup.ReportParameterCurrentUserName)) { SetupReportParameter(customerReport, DDSetup.ReportParameterCurrentUserName, userName); } else // try to setup _MutipleProductReferenceIDs { SetupReportParameter(customerReport, DDSetup.ReportParameterCurrentUserName, userName); } } if (v2kuid.HasValue) { if (aDomainType == EmDomainType.Vendor) { SetupReportParameter(customerReport, DDSetup.ReportParameterVendorID, v2kuid.Value); } else if (aDomainType == EmDomainType.Customer) { } } if (!string.IsNullOrEmpty(timeZoneInfoToken)) { if (IsExistParaName(customerReport, DDSetup.ReportParameterClientTimeZonekey)) { SetupReportParameter(customerReport, DDSetup.ReportParameterClientTimeZonekey, timeZoneInfoToken); } } if (!string.IsNullOrEmpty(this._ProductReferenceId)) { if (IsExistParaName(customerReport, DDSetup.ReportParameterProductReferenceID)) { SetupReportParameter(customerReport, DDSetup.ReportParameterProductReferenceID, _ProductReferenceId); } else// try to setup _MutipleProductReferenceIDs { SetupReportParameter(customerReport, DDSetup.ReportParameterMutipleProductReferenceIDs, _ProductReferenceId); } } // new add 2014-02-17 report paramters if (!string.IsNullOrEmpty(this._MainReferenceID)) { if (IsExistParaName(customerReport, DDSetup.QueryReportParameterMainReferenceID)) { SetupReportParameter(customerReport, DDSetup.QueryReportParameterMainReferenceID, _MainReferenceID); } } if (!string.IsNullOrEmpty(this._MasterReferenceID)) { if (IsExistParaName(customerReport, DDSetup.QueryReportParameterMasterReferenceID)) { SetupReportParameter(customerReport, DDSetup.QueryReportParameterMasterReferenceID, _MasterReferenceID); } } if (!string.IsNullOrEmpty(this._MutipleProductReferenceIDs)) { if (IsExistParaName(customerReport, DDSetup.ReportParameterMutipleProductReferenceIDs)) { SetupReportParameter(customerReport, DDSetup.ReportParameterMutipleProductReferenceIDs, _MutipleProductReferenceIDs); } else// try to setup _MutipleProductReferenceIDs { SetupReportParameter(customerReport, DDSetup.ReportParameterProductReferenceID, _MutipleProductReferenceIDs); } } // need to set up ReportParameterApplicationServerUrl for report iamge url if (IsExistParaName(customerReport, DDSetup.ReportParameterImageUrl)) { SetupReportParameter(customerReport, DDSetup.ReportParameterImageUrl, DDSetup.ReorptSetup.ReportingServerImageUrl); } // if( this._ProductReferenceId } }
public static EmDomainType GetDomainTypeAndV2kUID(int?uid, out int?matchV2kUserID, out string currentUserName, out string timeZoneInfoToken) { EmDomainType aDomainType = EmDomainType.Anonymous; matchV2kUserID = null; currentUserName = string.Empty; timeZoneInfoToken = string.Empty; using (SqlConnection conn = new SqlConnection(PLMConnectionString)) { conn.Open(); string qeuryDynamicReportRepositoryPath = string.Format(@" select pdmSecurityWebUser.TimeZoneInfoToken, pdmSecurityRegDomain.PersonType, pdmSecurityWebUser.UserID, pdmSecurityWebUser.UserName, MatchV2kUserID FROM pdmSecurityWebUser INNER JOIN pdmSecurityRegDomain ON pdmSecurityWebUser.DomainID = pdmSecurityRegDomain.DomainID where UserID= {0}", uid); SqlCommand cmd = new SqlCommand(qeuryDynamicReportRepositoryPath, conn); SqlDataAdapter adapter = new SqlDataAdapter(cmd); System.Data.DataTable resultTabel = new DataTable(); adapter.Fill(resultTabel); if (resultTabel.Rows.Count > 0) { DataRow aRow = resultTabel.Rows[0]; object v2kid = aRow["MatchV2kUserID"]; object personType = aRow["PersonType"]; currentUserName = aRow["UserName"] as string; timeZoneInfoToken = aRow["TimeZoneInfoToken"] as string; if (v2kid != null && personType != null) { int domainType = int.Parse(personType.ToString()); int result; if (int.TryParse(v2kid.ToString(), out result)) { matchV2kUserID = result; } if (domainType == (int)EmDomainType.Employee) { aDomainType = EmDomainType.Employee; } else if (domainType == (int)EmDomainType.Vendor) { aDomainType = EmDomainType.Vendor; } else if (domainType == (int)EmDomainType.Customer) { aDomainType = EmDomainType.Customer; } else if (domainType == (int)EmDomainType.Agent) { aDomainType = EmDomainType.Agent; } else if (domainType == (int)EmDomainType.SysAdmin) { aDomainType = EmDomainType.SysAdmin; } else if (domainType == (int)EmDomainType.AppAdmin) { aDomainType = EmDomainType.AppAdmin; } } } } //WriteReportTrace(currentUserName); return(aDomainType); }
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 } }