public bool RenameFolder(ReportGroup folder, string oldPath)
{
ReportingService2010.ReportingService2010 CurrentService = new ReportingService2010.ReportingService2010();
CurrentService.Credentials = System.Net.CredentialCache.DefaultCredentials;
//set the credentials
string UserReportID = ConfigurationManager.AppSettings["userReportID"];
string UerReportPassword = ConfigurationManager.AppSettings["userReportPassword"];
string UserReportDomain = ConfigurationManager.AppSettings["userReportDomain"];
string PathName = folder.PathName;
if (PathName.Substring(PathName.Length - 1) == "/")
{
PathName = PathName.Substring(0, PathName.Length - 1);
}
string OldPathName = oldPath;
if (OldPathName.Substring(OldPathName.Length - 1) == "/")
{
OldPathName = OldPathName.Substring(0, OldPathName.Length - 1);
}
CurrentService.Credentials = new NetworkCredential(UserReportID, UerReportPassword, UserReportDomain);
CurrentService.MoveItem("/" + OldPathName, "/" + PathName);
return(true);
}
public void OnGet(int?id)
{
Group = new ReportGroup()
{
ParentID = id
};
}
private static string GetDirectoryName()
{
ReportGroup reportGroup = TestReportCreate.GetMonthReportGroup();
ReportFileBase file = new MonitorReportFile(reportGroup);
return(Path.GetDirectoryName(file.ReportInfo.FullName));
}
public async static Task <IDTO> AddUpdateMode(ReportGroup bank)
{
string SPName = "";
string message = "";
OracleDynamicParameters oracleParams = new OracleDynamicParameters();
ComplateOperation <int> complate = new ComplateOperation <int>();
if (bank.ID.HasValue)
{
oracleParams.Add(ReportGroupSpParams.PARAMETER_ID, OracleDbType.Int64, ParameterDirection.Input, (object)bank.ID ?? DBNull.Value);
SPName = ReportGroupSPName.SP_UPADTE_ReportGroup;
message = "Updated Successfully";
}
else
{
oracleParams.Add(ReportGroupSpParams.PARAMETER_ID, OracleDbType.Int64, ParameterDirection.Output);
SPName = ReportGroupSPName.SP_INSERT_ReportGroup;
message = "Inserted Successfully";
}
oracleParams.Add(ReportGroupSpParams.PARAMETER_NAME, OracleDbType.Varchar2, ParameterDirection.Input, (object)bank.Name ?? DBNull.Value, 500);
oracleParams.Add(ReportGroupSpParams.PARAMETER_NAME2, OracleDbType.Varchar2, ParameterDirection.Input, (object)bank.Name2 ?? DBNull.Value, 500);
oracleParams.Add(ReportGroupSpParams.PARAMETER_ORDER_BY, OracleDbType.Varchar2, ParameterDirection.Input, (object)bank.OrderBy ?? DBNull.Value, 50);
if (await NonQueryExecuter.ExecuteNonQueryAsync(SPName, oracleParams) == -1)
{
complate.message = message;
}
else
{
complate.message = "Operation Failed";
}
return(complate);
}
public void CreateReportGroup(ReportGroupDto reportGroupDto)
{
var reportGroup = new ReportGroup(reportGroupDto.GroupName, reportGroupDto.DisplayName,
reportGroupDto.Description, reportGroupDto.CreatedBy);
this._reportGroupRepository.Add(reportGroup);
}
public void ReportInfoTest()
{
ReportGroup reportGroup = GetMonthReportGroup();
ReportFileBase file = new MonitorReportFile(reportGroup);
Assert.IsTrue(CheckReportInfo(reportGroup, file.ReportInfo));
}
private void Seed()
{
using (var context = new DatabaseContext(databaseContextOptions, httpAccessorMock.Object)) {
context.Database.EnsureDeleted();
context.Database.EnsureCreated();
argumentQuery = new ReportArgumentQuery()
{
ArgQuery = "query", ReportArgumentQueryId = 1
};
reportArgument = new ReportArgument {
Name = "date", ReportArgumentId = 1, ArgType = "DateTime", ReportId = 1
};
group = new ReportGroup()
{
Name = "groupName", ReportGroupId = 1
};
report = new Report()
{
Description = "someDescription",
Name = "someName",
ReportId = reportArgument.ReportId,
ReportArguments = new List <ReportArgument>()
{
reportArgument
},
ReportGroupId = group.ReportGroupId
};
context.AddRange(argumentQuery, reportArgument, group, report);
context.SaveChanges();
}
}
public void DailyReportFileByExcelTest()
{
ReportGroup reportGroup = GetDailyReportGroup();
ReportFileBase file = new MonitorReportFile(reportGroup);
ReportTaskResult result = file.CreateNewFile();
Assert.IsTrue(CheckResult(reportGroup, result));
}
private bool CheckReportInfo(ReportGroup reportGroup, ReportInfo reportInfo)
{
Console.WriteLine("ID：{0}，名称：{1}，全名称:{2}", reportInfo.Id, reportInfo.Name, reportInfo.FullName);
return((reportInfo.DateType == reportGroup.Config.DateType) &&
(reportInfo.OrgId == reportGroup.Config.OrgId) &&
(reportInfo.StructureId == reportGroup.Config.StructId) &&
(reportInfo.Statue == !reportGroup.Config.IsNeedConfirmed));
}
private bool CheckResult(ReportGroup reportGroup, ReportTaskResult result)
{
if (result.Result != Result.Successful)
{
return(false);
}
return(CheckReportInfo(reportGroup, result.ReportInfo));
}
/// <summary>
/// Criar novo relatorio
/// </summary>
/// <param name="formTypeAction"></param>
public XtraForm1(String descricaoRelatorio, ReportGroup grupo)
: this()
{
this.grupo = grupo;
this.descricaoRelatorio = descricaoRelatorio;
reportDesigner1.CreateNewReport();
reportDesigner1.ActiveDesignPanel.Report.DisplayName = descricaoRelatorio;
}
public static void MarshalMembers(ReportGroupFolder updatedFolder, ReportGroup newValues)
{
updatedFolder.AccessLevel = newValues.AccessLevel;
//updatedFolder.Color = newValues.Color;
updatedFolder.FullPath = newValues.PathName;
updatedFolder.IsTemp = (newValues.Name == "Temp");
updatedFolder.Name = newValues.Name;
updatedFolder.RowIdentifier = newValues.RowIdentifier;
}
public Report(String name, String method, Boolean canHardCopy, AuthorizationLevel authorization, ReportGroup group)
{
this.name = name;
this.method = method;
this.canHardCopy = canHardCopy;
this.authorization = authorization;
this.parameters = new Dictionary <string, Type>();
this.subreports = new List <IReport>();
this.group = group;
}
public MonitorReportFile(ReportGroup reportGroup)
: base(reportGroup)
{
organization = DataAccess.GetOrganizationInfo(reportGroup.Config.OrgId);
structure = DataAccess.GetStructureInfo(reportGroup.Config.StructId);
// factor = DataAccess.GetFactorInfoById(reportGroup.Config.FactorId);
createDate = reportGroup.CreateDate;
fileFullName = GetReportFullName(reportGroup.Config.IsNeedConfirmed, reportGroup.Config.ReportName, reportGroup.Config.DateType);
getDataHour = Convert.ToDouble(reportGroup.Config.GetDataTime);
reportInfo = this.GetReportInfo();
}
private bool CanDeleteReport(object item)
{
ReportGroup reportsReportGroup = null;
if (selectedReport != null)
{
reportsReportGroup = (from x in myContext.ReportGroups
where x.Code == selectedReport.GroupCode
select x).FirstOrDefault();
}
return(selectedReport != null && reportsReportGroup != null && !selectedReport.IsStandard && reportsReportGroup.AccessLevel >= ReportGroupAccessLevelType.Delete);
}
private bool CanPublishReport(object item)
{
ReportGroup reportsReportGroup = null;
if (selectedReport != null)
{
reportsReportGroup = (from x in myContext.ReportGroups
where x.Code == selectedReport.GroupCode
select x).FirstOrDefault();
}
return(selectedReport != null && reportsReportGroup != null && reportsReportGroup.AccessLevel > ReportGroupAccessLevelType.ReadOnly);
}
/// <summary>
/// Alterar ou cria o relatorio
/// </summary>
/// <param name="grupo"></param>Grupo de relatorio
private void showReport(ReportGroup grupo)
{
//crie o relatório
if (this.ReportImage == null)
{
this.ReportImage = new ReportImage(txtDescricaoRelatorio.Text, grupo);
}//altere o relatorio
else
{
//atualiza
ReportImage.ReportDescription = txtDescricaoRelatorio.Text;
ReportImage.IdGrpReport = grupo.IdGrpReport;
}
}
/// <summary>
/// Alterar ou cria o dashboard
/// </summary>
/// <param name="grupo"></param>Grupo do relatório
private void showDashboard(ReportGroup grupo)
{
//crie o dashboard
if (this.DashboardImage == null)
{
this.DashboardImage = new DashboardImage(txtDescricaoRelatorio.Text, grupo);
}//altere o dashboard
else
{
//atualiza
DashboardImage.ReportDescription = txtDescricaoRelatorio.Text;
DashboardImage.IdGrpReport = grupo.IdGrpReport;
}
}
public bool DeleteReport(ReportGroup folder, Report reportItem)
{
ReportingService2010.ReportingService2010 CurrentService = new ReportingService2010.ReportingService2010();
CurrentService.Credentials = System.Net.CredentialCache.DefaultCredentials;
//set the credentials
string UserReportID = ConfigurationManager.AppSettings["userReportID"];
string UerReportPassword = ConfigurationManager.AppSettings["userReportPassword"];
string UserReportDomain = ConfigurationManager.AppSettings["userReportDomain"];
CurrentService.Credentials = new NetworkCredential(UserReportID, UerReportPassword, UserReportDomain);
CurrentService.DeleteItem("/" + folder.PathName + reportItem.Name);
return(true);
}
public async static Task <IDTO> DeleteReportGroupAsync(ReportGroup reportGroup)
{
OracleDynamicParameters oracleParams = new OracleDynamicParameters();
ComplateOperation <int> complate = new ComplateOperation <int>();
var dyParam = new OracleDynamicParameters();
dyParam.Add(ReportGroupSpParams.PARAMETER_ID, OracleDbType.Int64, ParameterDirection.Input, (object)reportGroup.ID ?? DBNull.Value);
if (await NonQueryExecuter.ExecuteNonQueryAsync(ReportGroupSPName.SP_DELETE_ReportGroup, dyParam) == -1)
{
complate.message = "Operation Successed";
}
else
{
complate.message = "Operation Failed";
}
return(complate);
}
public void TestBuildGroup()
{
var builder = new ReportGroupBuilder();
builder.Name = "Somewhereville";
builder.CategoryId = 8;
builder.QueryKey = "Z";
ValidationResults r = Validation.Validate(builder);
Assert.IsTrue(r.IsValid);
ReportGroup group = builder.Build();
Assert.AreEqual("Somewhereville", group.Name);
Assert.AreEqual(8, group.CategoryId);
}
public void LoadMultipleReports()
{
const int RPT_COUNT = 3;
const string RPT_NAME_PREFIX = "RPT";
XDocument settingsDocument = CreateSettingsDocumentWithMultipleReports(RPT_NAME_PREFIX, RPT_COUNT);
string settingsFilePath = CreateSettingsFile(settingsDocument);
Settings settings = Settings.Load(settingsFilePath);
ReportGroup reportGroup = settings.ReportGroups[0];
Assert.That(reportGroup.Reports, Has.Count.EqualTo(RPT_COUNT));
for (int i = 0; i < RPT_COUNT; i++)
{
string reportName = RPT_NAME_PREFIX + i;
Assert.That(reportGroup.Reports.Count(g => g.Name == reportName), Is.EqualTo(1));
}
}
private ReportTreeNode CopyGroup(Serialization.Node src, int businessUnitId)
{
ReportGroup dst = new ReportGroup();
CopyFields(dst, src);
foreach (Serialization.Node node in src.Content.Items)
{
ReportTreeNode child = Copy(node, businessUnitId);
if (child != null)
{
dst.Children.Add(child);
}
}
return(dst);
}
public void GetReportGroupShouldReturnObject()
{
//arrange
var reportGroup = new ReportGroup()
{
Name = "someGroup",
ReportGroupId = 1
};
serviceMock.Setup(s => s.GetReportGroup(It.IsAny <int>())).Returns(reportGroup);
//act
var result = reportGroupController.Get(1);
//assert
var viewResult = result.Should().BeAssignableTo <ObjectResult>();
viewResult.Which.Value.Should().BeEquivalentTo(reportGroup);
serviceMock.Verify(s => s.GetReportGroup(It.IsAny <int>()), Times.Once);
}
public bool InsertFolder(ReportGroup folder)
{
ReportingService2010.ReportingService2010 CurrentService = new ReportingService2010.ReportingService2010();
CurrentService.Credentials = System.Net.CredentialCache.DefaultCredentials;
//set the credentials
string UserReportID = ConfigurationManager.AppSettings["userReportID"];
string UerReportPassword = ConfigurationManager.AppSettings["userReportPassword"];
string UserReportDomain = ConfigurationManager.AppSettings["userReportDomain"];
string ParentPath = folder.ParentPath;
if (ParentPath.Substring(ParentPath.Length - 1) == "/")
{
ParentPath = ParentPath.Substring(0, ParentPath.Length - 1);
}
CurrentService.Credentials = new NetworkCredential(UserReportID, UerReportPassword, UserReportDomain);
CatalogItem newFolder = CurrentService.CreateFolder(folder.Name, "/" + ParentPath, null);
return(true);
}
public static ReportGroup GetMonthReportGroup()
{
ReportGroup reportGroup = new ReportGroup();
//reportGroup.Config = new ReportConfig();
//reportGroup.Templates = new List<ReportTemplate>();
reportGroup.Config.DateType = DateType.Month;
reportGroup.Config.ReportName = "myTestReport";
reportGroup.Config.IsNeedConfirmed = true;
reportGroup.Config.OrgId = 17;
reportGroup.Config.StructId = 23;
reportGroup.Config.Id = 99;
reportGroup.CreateDate = new DateTime(2014, 8, 1);
ReportTemplate template = new ReportTemplate();
template.Name = "StructureMonthlyReport.docx";
template.HandleName = "StructureMonthlyReportTemplateHandler";
reportGroup.Templates.Add(template);
return(reportGroup);
}
public static ReportGroup GetDailyReportGroup()
{
ReportGroup reportGroup = new ReportGroup();
//reportGroup.Config = new ReportConfig();
//reportGroup.Templates = new List<ReportTemplate>();
reportGroup.Config.DateType = DateType.Day;
reportGroup.Config.ReportName = "myTestExcelReport";
reportGroup.Config.IsNeedConfirmed = false;
reportGroup.Config.OrgId = 15;
reportGroup.Config.StructId = 3;
reportGroup.Config.Id = 7;
reportGroup.CreateDate = new DateTime(2014, 8, 1);
ReportTemplate template = new ReportTemplate();
template.Name = "测斜监测日模板.xls";
template.HandleName = "CxDailyReport";
template.FactorId = 10;
reportGroup.Templates.Add(template);
return(reportGroup);
}
public void TestSaveAndDeleteReportInfo()
{
ReportGroup reportGroup = TestReportCreate.GetMonthReportGroup();
ReportFileBase file = new MonitorReportFile(reportGroup);
Assert.IsTrue(ReportConfigDal.SaveReportInfo(file.ReportInfo));
int fileRec;
using (var db = new DW_iSecureCloud_EmptyEntities())
{
fileRec = db.T_REPORT_COLLECTION.Where(r => r.Name == file.ReportInfo.Name).ToList().Count;
}
Assert.IsTrue(fileRec > 0);
Assert.IsTrue(ReportConfigDal.DeleteOldReportInfo(file.ReportInfo.Name));
using (var db = new DW_iSecureCloud_EmptyEntities())
{
fileRec = db.T_REPORT_COLLECTION.Where(r => r.FileFullName == file.ReportInfo.FullName).ToList().Count;
}
Assert.IsTrue(fileRec == 0);
}
public FakeReportGroupPermissionsViewModel()
{
OKButtonCommand = new RelayCommand(cmd => { });
ApplyButtonCommand = new RelayCommand(cmd => { });
CancelButtonCommand = new RelayCommand(cmd => { });
permissions = new ObservableCollection <string>
{
ReportGroupAccessLevelType.Admin.ToString(),
ReportGroupAccessLevelType.Delete.ToString(),
ReportGroupAccessLevelType.None.ToString(),
ReportGroupAccessLevelType.ReadOnly.ToString(),
ReportGroupAccessLevelType.Update.ToString(),
"Inherit"
};
currentReportGroup = new ReportGroup {
Name = "Dave Group 1", PathName = "RootGroup/Parent Group/Dave Group 1/"
};
currentUser = new MCUser {
Name = "Ian Brown"
};
currentPermission = ReportGroupAccessLevelType.Admin;
users = new ObservableCollection <MCUser>()
{
new MCUser {
Name = "dhays"
},
new MCUser {
Name = "jandrews"
},
new MCUser {
Name = "jbuxton"
}
};
selectedUser = users[0];
selectedPermission = "ReadOnly";
}
//等級報表轉換
public static List <ReportGroup> ConvertReportGroupModel(List <GradeReport> models)
{
List <ReportGroup> reportGroups = new List <ReportGroup>();
foreach (var model in models)
{
ReportGroup reportGroup = new ReportGroup()
{
group_name = model.GradeName,
BetNum = model.GradeBetNum,
PrepaidNum = model.GradeDepositNum,
PrepaidMoney = model.GradeDepositMoney,
OutMoney = model.GradeWithdrawMoney,
BetMoney = model.GradeBetMoney,
WinMoney = model.GradeWinMoney,
BetOrderNum = model.GradeBetCount,
ActivityDiscountAccountMoney = model.GradeActivityMoney,
Out_RebateAccount = model.GradeRebateMoney
};
reportGroups.Add(reportGroup);
}
return(reportGroups);
}
private ICollection<int> GenerateGroup(ExcelWriter xlWriter, ReportGroup group)
{
ICollection<int> results = null;
xlWriter.PutGroupHead(group.Name);
foreach (var reporRow in group.ReportRows)
{
var rowResult = GenerateRow(xlWriter, reporRow);
results = results == null ? rowResult : SummarizeResults(results, rowResult);
}
xlWriter.PutGroupResults(results);
return results;
}
