public void TestMethod1()
{
var excelList = Sample02.Run();
var resultList = excelList.GetEmpty().ToList();
resultList.Add(new Sample02.ExcelModel {
序号 = "1", 部门 = "事业1部", 部门负责人 = "赵六", 部门负责人确认签字 = "娃娃"
});
resultList.Add(new Sample02.ExcelModel {
序号 = "2", 部门 = "事业2部", 部门负责人 = "赵六", 部门负责人确认签字 = "菲菲"
});
resultList.Add(new Sample02.ExcelModel {
序号 = "3", 部门 = "事业3部", 部门负责人 = "王五", 部门负责人确认签字 = "佩琪"
});
resultList.Add(new Sample02.ExcelModel {
序号 = "4", 部门 = "事业4部", 部门负责人 = "jam", 部门负责人确认签字 = "jam"
});
resultList.Add(new Sample02.ExcelModel {
序号 = "6", 部门 = "事业6部", 部门负责人 = "jack", 部门负责人确认签字 = "菲菲"
});
resultList.Add(new Sample02.ExcelModel {
序号 = "7", 部门 = "事业7部", 部门负责人 = "jack", 部门负责人确认签字 = "jack"
});
resultList.Add(new Sample02.ExcelModel {
序号 = "8", 部门 = "事业8部", 部门负责人 = "王五2号", 部门负责人确认签字 = "佩琪"
});
CollectionAssert.AreEqual(excelList, resultList);
}
static void Main(string[] args)
{
string demo = "Sample11";
switch (demo)
{
case "Sample1": Sample01.Demo();
break;
case "Sample2": Sample02.Demo();
break;
case "Sample3":
Sample03.Demo();
break;
case "Sample4":
Sample04.Demo();
break;
case "Sample5":
Sample05.Demo();
break;
case "Sample6":
Sample06.Demo();
break;
case "Sample7":
Sample07.Demo();
break;
case "Sample8":
Sample08.Demo();
break;
case "Sample9":
Sample09.Demo();
break;
case "Sample10":
Sample10.Demo();
break;
case "Sample11":
Sample11.Demo();
break;
default:
break;
}
}
private void CreateGUI()
{
var root = rootVisualElement;
root.styleSheets.Add(styleSheet);
visualTree.CloneTree(root);
root.Bind(new SerializedObject(this));
root.Q <Button>("sample01").clicked += async() =>
{
var ret = await Sample01.OnClick(out code);
result = $"{ret}";
};
root.Q <Button>("sample02").clicked += async() =>
{
var ret = await Sample02.OnClick(out code);
result = $"{ret}";
};
root.Q <Button>("sample03").clicked += async() =>
{
var ret = await Sample03.OnClick(out var c, out var globals);
code = $"{c}, {globals}";
result = $"{ret}";
};
root.Q <Button>("sample04").clicked += () =>
{
result = Sample04.OnClick(out code);
};
root.Q <Button>("sample05").clicked += () =>
{
var ret = Sample05.OnClick(out code);
result = string.Join("\n", ret.Select(e => e.Name));
};
}
public void CreateCrmAccount2_Test()
{
//ARRANGE - set up everything our test needs
//first - set up a mock service to act like the CRM organization service
var serviceMock = new Mock <IOrganizationService>();
IOrganizationService service = serviceMock.Object;
//next - set a name and account number for our fake account record to create
string accountName = "Lucas Demo Company";
string accountNumber = "LPA1234";
//next - create a guid that we want our mock service Create method to return when called
Guid idToReturn = Guid.NewGuid();
//next - create an object that will allow us to capture the account object that is passed to the Create method
Entity createdAccount = new Entity();
//next - create an entity object that will allow us to capture the task object that is passed to the Create method
Entity createdTask = new Entity();
//next - create an mock account record to pass back to the Retrieve method
Entity mockReturnedAccount = new Entity("account");
mockReturnedAccount["name"] = accountName;
mockReturnedAccount["accountnumber"] = accountNumber;
mockReturnedAccount["accountid"] = idToReturn;
mockReturnedAccount.Id = idToReturn;
//finally - tell our mock service what to do when the CRM service methods are called
//handle the account creation
serviceMock.Setup(t =>
t.Create(It.Is <Entity>(e => e.LogicalName.ToUpper() == "account".ToUpper()))) //only match an entity with a logical name of "account"
.Returns(idToReturn) //return the idToReturn guid
.Callback <Entity>(s => createdAccount = s); //store the Create method invocation parameter for inspection later
//handle the task creation
serviceMock.Setup(t =>
t.Create(It.Is <Entity>(e => e.LogicalName.ToUpper() == "task".ToUpper()))) //only match an entity with a logical name of "task"
.Returns(Guid.NewGuid()) //can return any guid here
.Callback <Entity>(s => createdTask = s); //store the Create method invocation parameter for inspection later
//handle the retrieve account operation
serviceMock.Setup(t =>
t.Retrieve(
It.Is <string>(e => e.ToUpper() == "account".ToUpper()),
It.Is <Guid>(e => e == idToReturn),
It.IsAny <Microsoft.Xrm.Sdk.Query.ColumnSet>())
) //here we match on logical name of account and the correct id
.Returns(mockReturnedAccount);
//ACT - do the thing(s) we want to test
//call the CreateCrmAccount2 method like usual, but supply the mock service as an invocation parameter
Sample02.CreateCrmAccount2(accountName, service);
//ASSERT - verify the results are correct
//verify the entity created inside the CreateCrmAccount method has the name we supplied
Assert.AreEqual(accountName, createdAccount["name"]);
//verify task regardingobjectid is the same as the id we returned upon account creation
Assert.AreEqual(idToReturn, ((Microsoft.Xrm.Sdk.EntityReference)createdTask["regardingobjectid"]).Id);
Assert.AreEqual("Finish account set up for " + accountName + " - " + accountNumber, (string)createdTask["subject"]);
}
static void Main(string[] args)
{
Console.Title = Constants.AppName;
ILogger logger = new Logger(Constants.AppName, new ILog[] { new FileLog(), new ColoredConsoleLog() })
{
Deep = LogDeep.OnlyApplicationCalls, Status = LogStatus.Running
};
logger.Debug(">Start Logging<");
// 01. Generate sample 01
logger.Info("");
logger.Info("> Shows the use of how creates a report");
Sample01.Generate(logger);
// 02. Generate sample 02
logger.Info("");
logger.Info("> Shows the use of how creates a report with minicharts");
Sample02.Generate(logger);
// 03. Generate sample 03
logger.Info("");
logger.Info("> Shows the use of how creates a report with minicharts and conditional inserts");
Sample03.Generate(logger);
// 04. Generate sample 04
logger.Info("");
logger.Info("> Shows the use of how serialize and deserialize global settings, styles, pictures, shapes and mini-charts");
Sample04.Generate(logger);
// 05. Generate sample 05
logger.Info("");
logger.Info("> Shows the use of how insert an autofilter");
Sample05.Generate(logger);
// 06. Generate sample 06
logger.Info("");
logger.Info("> Shows how to use insert datatable and generic collections");
Sample06.Generate(logger);
// 07. Generate sample 07
logger.Info("");
logger.Info("> Shows how to insert a pictures");
Sample07.Generate(logger);
// 08. Generate sample 08
logger.Info("");
logger.Info("> Shows how to insert a shapes with shape effects");
Sample08.Generate(logger);
// 09. Generate sample 09
logger.Info("");
logger.Info("> Shows how to insert an image from uri (stream)");
Sample09.Generate(logger);
// 10. Generate sample 10
logger.Info("");
logger.Info("> Shows how to insert a pictures with shape effects");
Sample10.Generate(logger);
// 11. Generate sample 11
logger.Info("");
logger.Info("> Shows how to copy ranges");
Sample11.Generate(logger);
// 12. Generate sample 12
logger.Info("");
logger.Info("> Shows how to transpose a range of data");
Sample12.Generate(logger);
// 13.Generate sample 13
logger.Info("");
logger.Info("> Shows how to use aggregate functions with a data range");
Sample13.Generate(logger);
// 14.Generate sample 14
logger.Info("");
logger.Info("> Shows the use stacked charts");
Sample14.Generate(logger);
// 15.Generate sample 15
logger.Info("");
logger.Info("> Shows the use charts with more than one chart type and secondary axis");
Sample15.Generate(logger);
logger.Info("");
logger.Debug(">End Logging<");
Console.ReadKey();
}
static void Main(string[] args)
{
Console.Title = Constants.AppName;
ILogger logger = new Logger(Constants.AppName, new ILog[] { new FileLog(), new ColoredConsoleLog() })
{
Deep = LogDeep.OnlyApplicationCalls, Status = LogStatus.Running
};
logger.Debug(">Start Logging<");
// 01. Generate sample 01 report
logger.Info("");
logger.Info("> Start Pdf Sample 01");
logger.Info(" > Shows the use of text and image replacement");
Sample01.Generate(logger);
// 02. Generate sample 02 report
logger.Info("");
logger.Info("> Start Pdf Sample 02");
logger.Info(" > Shows the use of html table replacement in a pdf document");
Sample02.Generate(logger);
// 03. Generate sample 03 report
logger.Info("");
logger.Info("> Start Pdf Sample 03");
logger.Info(" > Shows the use of merge action");
Sample03.Generate(logger);
// 04. Generate sample 04 report
logger.Info("");
logger.Info("> Start Pdf Sample 04");
logger.Info(" > Shows the header replacement after merge action");
Sample04.Generate(logger);
// 05. Generate sample 05 report
logger.Info("");
logger.Info("> Start Pdf Sample 05");
logger.Info(" > Shows the use of System Tags such as page number");
Sample05.Generate(logger);
// 06. Generate sample 06 report
logger.Info("");
logger.Info("> Start Pdf Sample 06");
logger.Info(" > Shows the use of test mode");
Sample06.Generate(logger, useTestMode: YesNo.Yes);
// 07.Generate sample 07 report
logger.Info("");
logger.Info("> Start Pdf Sample 07");
logger.Info(" > Shows the use of save as zip a input with user-defined filename");
Sample07.Generate(logger);
// 08. Generate sample 08 report
logger.Info("");
logger.Info("> Start Pdf Sample 08");
logger.Info(" > Shows the use of save as zip merged output");
Sample08.Generate(logger);
// 09. Generate sample 09 report
logger.Info("");
logger.Info("> Start Pdf Sample 09");
logger.Info(" > Shows the use of compression threshold (>2MB) when merge and zip files (NO zipped)");
Sample09.Generate(logger);
// 10.Generate sample 10 report
logger.Info("");
logger.Info("> Start Pdf Sample 10");
logger.Info(" > Shows the use of save as zip a input with random name");
Sample10.Generate(logger);
// 12. Generate sample 12 report
logger.Info("");
logger.Info("> Start Pdf Sample 12");
logger.Info(" > Shows the use of how serialize and deserialize text, image and table styles");
Sample12.Generate(logger);
logger.Info("");
logger.Debug(">End Logging<");
Console.ReadKey();
}
