/// <summary>
/// 获取标签生成器
/// </summary>
protected override TagBuilder GetTagBuilder()
{
var builder = new CellBuilder();
Config(builder);
return(builder);
}
/// <summary>
/// Returns a file containing the exported identity information
/// Encoding is iso-8859-1
/// </summary>
/// <param name="items"></param>
/// <returns></returns>
private byte[] GetIdentityCsv(List <ExportItem> items)
{
StringBuilder builder = new StringBuilder();
builder.AppendLine("title,firstName,middleName,lastName,address1,address2,address3,city,state,postalCode,country,company,email,phone,ssn,username,passportNumber,licenseNumber");
foreach (ExportItem item in items)
{
builder.AppendLine(CellBuilder.BuildCells(
item.Object.Identity.Title,
item.Object.Identity.FirstName,
item.Object.Identity.MiddleName,
item.Object.Identity.LastName,
item.Object.Identity.Adress1,
item.Object.Identity.Adress2,
item.Object.Identity.Adress3,
item.Object.Identity.City,
item.Object.Identity.State,
item.Object.Identity.PostalCode,
item.Object.Identity.Country,
item.Object.Identity.Company,
item.Object.Identity.EMail,
item.Object.Identity.Phone,
item.Object.Identity.SSN,
item.Object.Identity.Username,
item.Object.Identity.PassportNumber,
item.Object.Identity.LicenseNumber).Join(","));
}
return(Encoding.GetEncoding("iso-8859-1").GetBytes(builder.ToString()));
}
/// <summary>
/// 添加单元格配置
/// </summary>
private void AddCell(TagBuilder builder)
{
if (_autoCreateCell == false)
{
return;
}
var cellBuilder = new CellBuilder();
builder.AppendContent(cellBuilder);
var type = _config.GetValue <TableColumnType?>(UiConst.Type);
var column = _config.GetValue(UiConst.Column);
switch (type)
{
case TableColumnType.Bool:
AddBoolCell(cellBuilder, column);
return;
case TableColumnType.Date:
AddDateCell(cellBuilder, column);
return;
default:
AddDefaultCell(cellBuilder, column);
return;
}
}
public override void Do()
{
if (Cell.StoreEnegry > MoveEnergy)
{
Cell.StoreEnegry -= MoveEnergy;
CellBuilder.TryToMove(Cell, GetDirection());
}
}
// Update is called once per frame
void Update()
{
if (!God.Cells.Any())
{
var cell = CellBuilder.GetDefaultCell();
God.Cells.Add(cell);
Burn(cell);
}
}
public void BuildEmptyCube()
{
CellBuilder builder = new CellBuilder(new GameMaster(0));
builder.BuildCells(new Form1(), new Panel());
int cells = 0;
Assert.AreEqual(cells, builder.GameMaster.Cells.Count);
}
/// <summary>
/// 添加单元格配置
/// </summary>
private void AddCell(TagBuilder builder)
{
if (_autoCreateCell == false)
{
return;
}
var cellBuilder = new CellBuilder();
cellBuilder.AppendContent($"{{{{ row.{_config.GetValue( UiConst.Column )} }}}}");
builder.AppendContent(cellBuilder);
}
/// <summary>
/// 配置单选框单元格
/// </summary>
private void ConfigRadioCell(TagBuilder builder)
{
var radioBuilder = new RadioButtonBuilder();
radioBuilder.AddAttribute("(click)", "$event.stopPropagation()");
radioBuilder.AddAttribute("(change)", $"$event?{_tableId}.checkRow(row):null");
radioBuilder.AddAttribute("[checked]", $"{_tableId}.checkedSelection.isSelected(row)");
var cellBuilder = new CellBuilder();
cellBuilder.AppendContent(radioBuilder);
builder.AppendContent(cellBuilder);
}
/// <summary>
/// 配置复选框单元格
/// </summary>
private void ConfigCheckboxCell(TagBuilder builder)
{
var checkBoxBuilder = new CheckBoxBuilder();
checkBoxBuilder.AddAttribute("(click)", "$event.stopPropagation()");
checkBoxBuilder.AddAttribute("(change)", $"$event?{_tableId}.selection.toggle(row):null");
checkBoxBuilder.AddAttribute("[checked]", $"{_tableId}.selection.isSelected(row)");
var cellBuilder = new CellBuilder();
cellBuilder.AppendContent(checkBoxBuilder);
builder.AppendContent(cellBuilder);
}
/// <summary>
/// Returns a file containing the exported secure notes
/// Encoding is iso-8859-1
/// </summary>
/// <param name="items"></param>
/// <returns></returns>
private byte[] GetSecureNoteCsv(List <ExportItem> items)
{
StringBuilder builder = new StringBuilder();
builder.AppendLine("title,note");
foreach (ExportItem item in items)
{
builder.AppendLine(CellBuilder.BuildCells(
item.Object.Name,
item.Object.Notes).Join(","));
}
return(Encoding.GetEncoding("iso-8859-1").GetBytes(builder.ToString()));
}
public override void Do()
{
if (Cell.StoreEnegry > BiteEnergyCost)
{
var cells = CellBuilder.NearCells(Cell);
//TODO
if (!cells.Any())
{
return;
}
var index = _random.Next(0, cells.Count());
var enemy = cells[index];
enemy.LifePoint -= 3;
Cell.StoreEnegry += BiteEnergyProfit;
}
}
private ICell CreateCellAndLinkItToCellsInItsRowColAndSqr()
{
var rowStub = MockRepository.GenerateStub <IRow>();
var colStub = MockRepository.GenerateStub <ICol>();
var sqrStub = MockRepository.GenerateStub <ISqr>();
rowStub.Expect(x => x.Cells).Return(new List <ICell> {
_otherCellInMyRowStub
});
colStub.Expect(x => x.Cells).Return(new List <ICell> {
_otherCellInMyColStub
});
sqrStub.Expect(x => x.Cells).Return(new List <ICell> {
_otherCellInMySqrStub
});
return(CellBuilder.CreateCell(11).LinkedTo(rowStub).LinkedTo(colStub).LinkedTo(sqrStub));
}
/// <summary>
/// Returns a file that contains credit card information
/// Encoding is iso-8859-1
/// </summary>
/// <param name="items"></param>
/// <returns></returns>
private byte[] GetCardCsv(List <ExportItem> items)
{
StringBuilder builder = new StringBuilder();
builder.AppendLine("cardholderName,brand,number,expMonth,expYear,code");
foreach (ExportItem item in items)
{
builder.AppendLine(CellBuilder.BuildCells(
item.Object.Card.CardholderName,
item.Object.Card.Brand,
item.Object.Card.Number,
item.Object.Card.ExpiryMonth,
item.Object.Card.ExpiryYear,
item.Object.Card.Code).Join(","));
}
return(Encoding.GetEncoding("iso-8859-1").GetBytes(builder.ToString()));
}
static void Main(string[] args)
{
var rule = new Rule();
var builder = new CellBuilder(rule);
var cells = builder.BuildCells(
rowLength: 20,
colLength: 20,
percentOfLivingCells: 30);
var grid = new Grid(cells);
var writer = new StreamWriter(Console.OpenStandardOutput(), Encoding.ASCII);
var drawer = new ConsoleDrawer(writer);
while (!Console.KeyAvailable)
{
drawer.DrawCells(grid.Cells);
grid.ToNextGen();
Thread.Sleep(200);
}
}
/// <summary>
/// Returns a file that contains credit card information
/// Encoding is iso-8859-1
/// </summary>
/// <param name="items"></param>
/// <returns></returns>
private byte[] GetCardCsv(List <ExportItem> items)
{
StringBuilder builder = new StringBuilder();
builder.AppendLine("title,card number,expiry date (MM/YYYY),cardholder name,PIN,bank name,CVV,notes");
foreach (ExportItem item in items)
{
builder.AppendLine(CellBuilder.BuildCells(
item.Object.Card.Brand,
item.Object.Card.Number,
new DateTime(int.Parse(item.Object.Card.ExpiryYear), int.Parse(item.Object.Card.ExpiryMonth), 1).ToString("MM/yyyy"),
item.Object.Card.CardholderName,
item.Object.Card.Code,
string.Empty,
string.Empty,
item.Object.Notes).Join(","));
}
return(Encoding.GetEncoding("iso-8859-1").GetBytes(builder.ToString()));
}
public void Cell()
{
CellBuilder configBuilder = new CellBuilder(null);
CellConfig config = null;
TableEntity entity = new TableEntity();
_builderFactory.CellBuilder(Arg.Do <CellConfig>(c => config = c)).Returns(configBuilder);
CellBuilder builder = _builder.Cell(() => entity.Property);
_builderFactory.Received(1).CellBuilder(Arg.Any <CellConfig>());
_configs.Should().HaveCount(1);
_configs.Should().ContainKey("Property");
CellConfig cellConfig = _configs["Property"];
cellConfig.Should().BeSameAs(config);
cellConfig.CssClasses.Should().BeEmpty();
cellConfig.State.Should().Be(ContextualState.Default);
builder.Should().BeSameAs(configBuilder);
}
/// <summary>
/// Returns a file containing login information
/// Encoding is iso-8859-1
/// </summary>
/// <param name="items"></param>
/// <returns></returns>
private byte[] GetLoginCsv(List <ExportItem> items)
{
StringBuilder builder = new StringBuilder();
builder.AppendLine("folder,favorite,type,name,notes,fields,login_uri,login_username,login_password,login_totp");
foreach (ExportItem item in items)
{
builder.AppendLine(CellBuilder.BuildCells(
item.Folder?.Name,
item.Object.IsFavorite ? 1 : 0,
item.Object.Type.ToString(),
item.Object.Name,
item.Object.Notes,
item.Object.Fields?.Select(x => $"{x.Name}: {x.Value}").Join("; "),
item.Object.Login?.Uris?.Select(x => x.Uri).Join(";"),
item.Object.Login?.Username,
item.Object.Login?.Password,
item.Object.Login?.Totp).Join(","));
}
return(Encoding.GetEncoding("iso-8859-1").GetBytes(builder.ToString()));
}
/// <summary>
/// Returns a file containing login information
/// Encoding is iso-8859-1
/// </summary>
/// <param name="items"></param>
/// <returns></returns>
private byte[] GetLoginCsv(List <ExportItem> items)
{
StringBuilder builder = new StringBuilder();
builder.AppendLine("title,website,username,password,notes");
foreach (ExportItem item in items)
{
List <string> lstCells = new List <string>()
{
item.Object.Name,
item.Object.Login?.Uris?.Select(x => x.Uri).Join(";"),
item.Object.Login?.Username,
item.Object.Login?.Password,
item.Object.Notes
};
lstCells.AddRangeIfNotNull(item.Object.Fields?.Select(x => $"{x.Name}:{x.Value}"));
builder.AppendLine(CellBuilder.BuildCells(lstCells.ToArray()).Join(","));
}
return(Encoding.GetEncoding("iso-8859-1").GetBytes(builder.ToString()));
}
public static void SetTemplate(Stream templateStream)
{
Template = templateStream.ReadAllBytes();
MemoryStream memoryStream = new MemoryStream();
memoryStream.WriteAllBytes(Template);
using (SpreadsheetDocument document = SpreadsheetDocument.Open(memoryStream, true))
{
document.PackageProperties.Creator = "";
document.PackageProperties.LastModifiedBy = "";
WorkbookPart workbookPart = document.WorkbookPart !;
WorksheetPart worksheetPart = document.GetWorksheetPartById("rId1");
Worksheet worksheet = worksheetPart.Worksheet;
CellBuilder = new CellBuilder()
{
CellFormatCount = document.WorkbookPart !.WorkbookStylesPart !.Stylesheet.CellFormats !.Count !,
DefaultStyles = new Dictionary <DefaultStyle, UInt32Value>
{
{ DefaultStyle.Title, worksheet.FindCell("A1").StyleIndex ! },
public static void WriteDataInExcelFile(ResultTable results, Stream stream)
{
if (results == null)
{
throw new ApplicationException(ExcelMessage.ThereAreNoResultsToWrite.NiceToString());
}
using (SpreadsheetDocument document = SpreadsheetDocument.Open(stream, true))
{
document.PackageProperties.Creator = "";
document.PackageProperties.LastModifiedBy = "";
WorkbookPart workbookPart = document.WorkbookPart !;
if (workbookPart.CalculationChainPart != null)
{
workbookPart.Workbook.CalculationProperties !.ForceFullCalculation = true;
workbookPart.Workbook.CalculationProperties !.FullCalculationOnLoad = true;
}
WorksheetPart worksheetPart = document.GetWorksheetPartBySheetName(ExcelMessage.Data.NiceToString());
CellBuilder cb = PlainExcelGenerator.CellBuilder;
SheetData sheetData = worksheetPart.Worksheet.Descendants <SheetData>().SingleEx();
List <ColumnData> columnEquivalences = GetColumnsEquivalences(document, sheetData, results);
UInt32Value headerStyleIndex = worksheetPart.Worksheet.FindCell("A1").StyleIndex !;
//Clear sheetData from the template sample data
sheetData.InnerXml = "";
sheetData.Append(new Sequence <Row>()
{
(from columnData in columnEquivalences
select cb.Cell(columnData.Column.Column.DisplayName, headerStyleIndex)).ToRow(),
from r in results.Rows
select(from columnData in columnEquivalences
select cb.Cell(r[columnData.Column], cb.GetDefaultStyle(columnData.Column.Column.Type), columnData.StyleIndex)).ToRow()
}.Cast <OpenXmlElement>());
var pivotTableParts = workbookPart.PivotTableCacheDefinitionParts
.Where(ptpart => ptpart.PivotCacheDefinition.Descendants <WorksheetSource>()
.Any(wss => wss.Sheet !.Value == ExcelMessage.Data.NiceToString()));
foreach (PivotTableCacheDefinitionPart ptpart in pivotTableParts)
{
PivotCacheDefinition pcd = ptpart.PivotCacheDefinition;
WorksheetSource wss = pcd.Descendants <WorksheetSource>().FirstEx();
wss.Reference !.Value = "A1:" + GetExcelColumn(columnEquivalences.Count(ce => !ce.IsNew) - 1) + (results.Rows.Count() + 1).ToString();
pcd.RefreshOnLoad = true;
pcd.SaveData = false;
pcd.Save();
}
workbookPart.Workbook.Save();
document.Close();
}
}
