public override void WriteHeaderLineToClosedXmlWorkSheet(ClosedXML.Excel.IXLWorksheet worksheet, int row)
{
char cell = 'A';
string cellKey;
cellKey = GetCellKey(row, cell++);
worksheet.Cell(cellKey).Value = "MapItemCategory";
cellKey = GetCellKey(row, cell++);
worksheet.Cell(cellKey).Value = "Identifiers";
cellKey = GetCellKey(row, cell++);
worksheet.Cell(cellKey).Value = "Name";
cellKey = GetCellKey(row, cell++);
worksheet.Cell(cellKey).Value = "AddressType";
cellKey = GetCellKey(row, cell++);
worksheet.Cell(cellKey).Value = "Address";
cellKey = GetCellKey(row, cell++);
worksheet.Cell(cellKey).Value = "SpatialLocation";
cellKey = GetCellKey(row, cell++);
worksheet.Cell(cellKey).Value = "Url";
}
bool SaveSequence(ClosedXML.Excel.IXLWorksheet sheet, int row)
{
sheet.Cell(row, 1).Value = TempPokemon.No;
sheet.Cell(row, 2).Value = TempPokemon.Name;
sheet.Cell(row, 3).Value = TempPokemon.Character;
sheet.Cell(row, 4).Value = TempPokemon.Item;
sheet.Cell(row, 5).Value = TempPokemon.Ability;
for (int i = 0; i < 6; i++)
{
sheet.Cell(row, i + 10).Value = TempPokemon.EffortValue[i];
sheet.Cell(row, i + 16).Value = TempPokemon.IndividualValue[i];
sheet.Cell(row, i + 22).Value = TempPokemon.Statistics[i];
}
for (int i = 0; i < 4; i++)
{
try
{
sheet.Cell(row, i + 6).Value = TempPokemon.Weapon[i];
}
catch (IndexOutOfRangeException)
{
System.Windows.Forms.MessageBox.Show("ワザの入力が正しくありません");
for (int j = 1; j <= 27; j++)
{
sheet.Cell(row, j).Value = "";
}
return(false);
}
}
return(true);
}
public override void WriteDataItemToClosedXmlWorkSheet(ClosedXML.Excel.IXLWorksheet worksheet, MSBuildLogsExtended.DataSourceEntities.BuildLog.Default dataItem, int row)
{
char cell = 'A';
string cellKey;
cellKey = Framework.Services.ClosedXmlHelper.GetCellKey(row, cell++);
worksheet.Cell(cellKey).Value = dataItem.Build_1_Name;
cellKey = Framework.Services.ClosedXmlHelper.GetCellKey(row, cell++);
worksheet.Cell(cellKey).Value = dataItem.Id;
cellKey = Framework.Services.ClosedXmlHelper.GetCellKey(row, cell++);
worksheet.Cell(cellKey).Value = dataItem.Solution_1Id;
cellKey = Framework.Services.ClosedXmlHelper.GetCellKey(row, cell++);
worksheet.Cell(cellKey).Value = dataItem.Solution_1_Name;
cellKey = Framework.Services.ClosedXmlHelper.GetCellKey(row, cell++);
worksheet.Cell(cellKey).Value = dataItem.BuildEventCode_1_Name;
cellKey = Framework.Services.ClosedXmlHelper.GetCellKey(row, cell++);
worksheet.Cell(cellKey).Value = dataItem.BuildId;
cellKey = Framework.Services.ClosedXmlHelper.GetCellKey(row, cell++);
worksheet.Cell(cellKey).Value = dataItem.BuildEventCodeId;
cellKey = Framework.Services.ClosedXmlHelper.GetCellKey(row, cell++);
worksheet.Cell(cellKey).Value = dataItem.Message;
cellKey = Framework.Services.ClosedXmlHelper.GetCellKey(row, cell++);
worksheet.Cell(cellKey).Value = dataItem.EventTime;
}
/// <summary>
/// Write ACL evolution into worksheet.
/// </summary>
/// <param name="worksheet"></param>
/// <param name="hostname"></param>
/// <param name="shareName"></param>
/// <param name="remark"></param>
/// <param name="level"></param>
/// <param name="ACLEvolution"></param>
/// <param name="row">Row number to start from</param>
/// <param name="lastScan">List of ACE_ID of the first scan</param>
/// <returns></returns>
static int InsertACLEvolution(ClosedXML.Excel.IXLWorksheet worksheet, string hostname, string shareName, string remark, int level, Dictionary <DateTime, Dictionary <string, Dictionary <string, string> > > ACLEvolution, int row, List <string> lastScan = null)
{
int count = 1;
List <string> nextScan;
foreach (Dictionary <string, Dictionary <string, string> > acl in ACLEvolution.Values)
{
if (ACLEvolution.Count > count)
{
nextScan = ACLEvolution[ACLEvolution.Keys.ToList()[count]].Keys.ToList();
count++;
}
else
{
nextScan = null;
}
row = InsertACL(
worksheet,
hostname,
shareName,
remark,
level,
acl,
row,
lastScan,
nextScan
);
lastScan = acl.Keys.ToList();
}
return(row);
}
public override void WriteDataItemToClosedXmlWorkSheet(ClosedXML.Excel.IXLWorksheet worksheet, Elmah.DataSourceEntities.MapItem dataItem, int row)
{
char cell = 'A';
string cellKey;
cellKey = GetCellKey(row, cell++);
worksheet.Cell(cellKey).Value = dataItem.MapItemCategory;
cellKey = GetCellKey(row, cell++);
worksheet.Cell(cellKey).Value = dataItem.Identifiers;
cellKey = GetCellKey(row, cell++);
worksheet.Cell(cellKey).Value = dataItem.Name;
cellKey = GetCellKey(row, cell++);
worksheet.Cell(cellKey).Value = dataItem.AddressType;
cellKey = GetCellKey(row, cell++);
worksheet.Cell(cellKey).Value = dataItem.Address;
cellKey = GetCellKey(row, cell++);
worksheet.Cell(cellKey).Value = Framework.Helpers.GeoHelperSinglton.Instance.GeographyToGmlV3(dataItem.SpatialLocation);
cellKey = GetCellKey(row, cell++);
worksheet.Cell(cellKey).Value = dataItem.Url;
}
public override void WriteDataItemToClosedXmlWorkSheet(ClosedXML.Excel.IXLWorksheet worksheet, MSBuildExtensionPack.DataSourceEntities.BuildLog.DefaultGroupedDataView dataItem, int row)
{
char cell = 'A';
string cellKey;
cellKey = Framework.Services.ClosedXmlHelper.GetCellKey(row, cell++);
worksheet.Cell(cellKey).Value = dataItem.BuildId;
cellKey = Framework.Services.ClosedXmlHelper.GetCellKey(row, cell++);
worksheet.Cell(cellKey).Value = dataItem.BuildEventCodeId;
cellKey = Framework.Services.ClosedXmlHelper.GetCellKey(row, cell++);
worksheet.Cell(cellKey).Value = dataItem.CountPerFK;
cellKey = Framework.Services.ClosedXmlHelper.GetCellKey(row, cell++);
worksheet.Cell(cellKey).Value = dataItem.Name;
cellKey = Framework.Services.ClosedXmlHelper.GetCellKey(row, cell++);
worksheet.Cell(cellKey).Value = dataItem.Solution_1Id;
cellKey = Framework.Services.ClosedXmlHelper.GetCellKey(row, cell++);
worksheet.Cell(cellKey).Value = dataItem.Organization_1Id;
cellKey = Framework.Services.ClosedXmlHelper.GetCellKey(row, cell++);
worksheet.Cell(cellKey).Value = dataItem.Organization_2Id;
}
public override void WriteHeaderLineToClosedXmlWorkSheet(ClosedXML.Excel.IXLWorksheet worksheet, int row)
{
char cell = 'A';
string cellKey;
cellKey = Framework.Services.ClosedXmlHelper.GetCellKey(row, cell++);
worksheet.Cell(cellKey).Value = "BuildId";
cellKey = Framework.Services.ClosedXmlHelper.GetCellKey(row, cell++);
worksheet.Cell(cellKey).Value = "BuildEventCodeId";
cellKey = Framework.Services.ClosedXmlHelper.GetCellKey(row, cell++);
worksheet.Cell(cellKey).Value = "CountPerFK";
cellKey = Framework.Services.ClosedXmlHelper.GetCellKey(row, cell++);
worksheet.Cell(cellKey).Value = "Name";
cellKey = Framework.Services.ClosedXmlHelper.GetCellKey(row, cell++);
worksheet.Cell(cellKey).Value = "Solution_1Id";
cellKey = Framework.Services.ClosedXmlHelper.GetCellKey(row, cell++);
worksheet.Cell(cellKey).Value = "Organization_1Id";
cellKey = Framework.Services.ClosedXmlHelper.GetCellKey(row, cell++);
worksheet.Cell(cellKey).Value = "Organization_2Id";
}
public static void ClosedXmlReader(string inFile, string outFile)
{
var workbook = new ClosedXML.Excel.XLWorkbook(inFile);
ClosedXML.Excel.IXLWorksheet sheet = workbook.Worksheets.Worksheet(1);
var sb = new StringBuilder();
var rows = sheet.LastRowUsed().RangeAddress.FirstAddress.RowNumber;
var columns = sheet.LastColumnUsed().RangeAddress.FirstAddress.ColumnNumber;
foreach (var row in sheet.Rows())
{
foreach (var cell in row.Cells())
{
string s = cell.GetString();
if (s.Contains('\n'))
{
sb.Append("\"" + s + "\"\t");
}
else
{
sb.Append(s + "\t");
}
}
sb.Remove(sb.Length - 1, 1);
sb.Append("\n");
}
File.WriteAllText(outFile, sb.ToString());
}
/// <summary>
/// 選擇檔案後觸發的上傳檔案事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void rauXLSXUpload_FileUploaded(object sender, Telerik.Web.UI.FileUploadedEventArgs e)
{
if (rauXLSXUpload.UploadedFiles.Count > 0) // 判斷是否有上傳檔案
{
List <string> lsTempPath = new List <string>();
foreach (Telerik.Web.UI.UploadedFile postedFile in rauXLSXUpload.UploadedFiles) // 巡覽上傳的所有檔案
{
if (postedFile != null)
{
string extensionName = System.IO.Path.GetExtension(postedFile.FileName);
if (extensionName.Equals(".xls") || extensionName.Equals(".xlsx")) // 沒有
{
using (FileStream filestream = postedFile.InputStream as FileStream)
using (ClosedXML.Excel.XLWorkbook wb = new ClosedXML.Excel.XLWorkbook(filestream))
{
lsTempPath.Add(filestream.Name);
ClosedXML.Excel.IXLWorksheet sheet = null;
try
{
sheet = wb.Worksheets.Worksheet("Sheet1");
}
catch
{
sheet = wb.Worksheets.Worksheet("工作表1");
}
if (sheet == null) // 找不到工作表就離開
{
break;
}
ktxtTABLE_NAME.Text = sheet.Cell(1, 1).GetString(); // 表格名稱
int rowIndex = 3;
DataTable dtSource = getDefalutTable(); // 每次都當最新的
while (!sheet.Cell(rowIndex, 2).IsEmpty()) // 欄位名稱是空的
{
DataRow ndr = dtSource.NewRow();
ndr["PK"] = sheet.Cell(rowIndex, 1).GetString().ToUpper().Trim(); // 鍵值
ndr["COLUMN_NAME"] = sheet.Cell(rowIndex, 2).GetString().ToUpper().Trim(); // 欄位名稱
ndr["DATA_TYPE"] = sheet.Cell(rowIndex, 3).GetString().ToUpper().Trim(); // 欄位類型
ndr["ALLOW_NULL"] = sheet.Cell(rowIndex, 4).GetString().ToUpper().Trim(); // 允許NULL
ndr["DEFAULT_VALUE"] = ""; // 預設值
ndr["COLUMN_DESC"] = sheet.Cell(rowIndex, 5).GetString().ToUpper().Trim(); // 說明
dtSource.Rows.Add(ndr);
rowIndex++;
}
ViewState["gvColumns"] = dtSource;
gvColumns.DataSource = ViewState["gvColumns"];
gvColumns.DataBind();
}
}
}
}
// 刪除暫存檔
foreach (string _tmpPath in lsTempPath)
{
File.Delete(_tmpPath);
}
}
}
public static void ClosedXmlWriter(string inFile, string outFile)
{
var workbook = new ClosedXML.Excel.XLWorkbook();
ClosedXML.Excel.IXLWorksheet sheet = workbook.Worksheets.Add("Sheet1");
using (var sr = new StreamReader(File.OpenRead(inFile)))
{
int r = 1;
string line = "";
string s;
bool ifInner = false;
while ((s = sr.ReadLine()) != null)
{
if (ifInner)
{
line += "\n" + s;
if (s.Contains("\"\t"))
{
ifInner = false;
}
else
{
continue;
}
}
else
{
line = s;
}
int pos;
if ((pos = s.LastIndexOf('\t')) > -1 && pos != s.Length - 1)
{
if (s[pos + 1] == '"' && s[s.Length - 1] != '"')
{
ifInner = true;
continue;
}
}
var row = sheet.Row(r);
string[] columns = line.Split('\t');
for (var c = 0; c < columns.Length; c++)
{
if (double.TryParse(columns[c], out double value))
{
row.Cell(c + 1).Value = value;
}
else
{
row.Cell(c + 1).Value = columns[c].Trim('"');
}
}
r++;
}
}
workbook.SaveAs(outFile);
}
public override void WriteHeaderLineToClosedXmlWorkSheet(ClosedXML.Excel.IXLWorksheet worksheet, int row)
{
char cell = 'A';
string cellKey;
cellKey = GetCellKey(row, cell++);
worksheet.Cell(cellKey).Value = "Host";
}
public override void WriteHeaderLineToClosedXmlWorkSheet(ClosedXML.Excel.IXLWorksheet worksheet, int row)
{
char cell = 'A';
string cellKey;
cellKey = GetCellKey(row, cell++);
worksheet.Cell(cellKey).Value = "ElmahApplication_Name";
cellKey = GetCellKey(row, cell++);
worksheet.Cell(cellKey).Value = "ErrorId";
cellKey = GetCellKey(row, cell++);
worksheet.Cell(cellKey).Value = "ElmahHost_Name";
cellKey = GetCellKey(row, cell++);
worksheet.Cell(cellKey).Value = "ElmahSource_Name";
cellKey = GetCellKey(row, cell++);
worksheet.Cell(cellKey).Value = "ElmahStatusCode_Name";
cellKey = GetCellKey(row, cell++);
worksheet.Cell(cellKey).Value = "ElmahType_Name";
cellKey = GetCellKey(row, cell++);
worksheet.Cell(cellKey).Value = "ElmahUser_Name";
cellKey = GetCellKey(row, cell++);
worksheet.Cell(cellKey).Value = "Application";
cellKey = GetCellKey(row, cell++);
worksheet.Cell(cellKey).Value = "Host";
cellKey = GetCellKey(row, cell++);
worksheet.Cell(cellKey).Value = "Type";
cellKey = GetCellKey(row, cell++);
worksheet.Cell(cellKey).Value = "Source";
cellKey = GetCellKey(row, cell++);
worksheet.Cell(cellKey).Value = "Message";
cellKey = GetCellKey(row, cell++);
worksheet.Cell(cellKey).Value = "User";
cellKey = GetCellKey(row, cell++);
worksheet.Cell(cellKey).Value = "StatusCode";
cellKey = GetCellKey(row, cell++);
worksheet.Cell(cellKey).Value = "TimeUtc";
cellKey = GetCellKey(row, cell++);
worksheet.Cell(cellKey).Value = "Sequence";
cellKey = GetCellKey(row, cell++);
worksheet.Cell(cellKey).Value = "AllXml";
}
public override void WriteDataItemToClosedXmlWorkSheet(ClosedXML.Excel.IXLWorksheet worksheet, Elmah.DataSourceEntities.ElmahHost dataItem, int row)
{
char cell = 'A';
string cellKey;
cellKey = GetCellKey(row, cell++);
worksheet.Cell(cellKey).Value = dataItem.Host;
}
public override void WriteDataItemToClosedXmlWorkSheet(ClosedXML.Excel.IXLWorksheet worksheet, Elmah.DataSourceEntities.ELMAH_Error.Default dataItem, int row)
{
char cell = 'A';
string cellKey;
cellKey = GetCellKey(row, cell++);
worksheet.Cell(cellKey).Value = dataItem.ElmahApplication_Name;
cellKey = GetCellKey(row, cell++);
worksheet.Cell(cellKey).Value = dataItem.ErrorId;
cellKey = GetCellKey(row, cell++);
worksheet.Cell(cellKey).Value = dataItem.ElmahHost_Name;
cellKey = GetCellKey(row, cell++);
worksheet.Cell(cellKey).Value = dataItem.ElmahSource_Name;
cellKey = GetCellKey(row, cell++);
worksheet.Cell(cellKey).Value = dataItem.ElmahStatusCode_Name;
cellKey = GetCellKey(row, cell++);
worksheet.Cell(cellKey).Value = dataItem.ElmahType_Name;
cellKey = GetCellKey(row, cell++);
worksheet.Cell(cellKey).Value = dataItem.ElmahUser_Name;
cellKey = GetCellKey(row, cell++);
worksheet.Cell(cellKey).Value = dataItem.Application;
cellKey = GetCellKey(row, cell++);
worksheet.Cell(cellKey).Value = dataItem.Host;
cellKey = GetCellKey(row, cell++);
worksheet.Cell(cellKey).Value = dataItem.Type;
cellKey = GetCellKey(row, cell++);
worksheet.Cell(cellKey).Value = dataItem.Source;
cellKey = GetCellKey(row, cell++);
worksheet.Cell(cellKey).Value = dataItem.Message;
cellKey = GetCellKey(row, cell++);
worksheet.Cell(cellKey).Value = dataItem.User;
cellKey = GetCellKey(row, cell++);
worksheet.Cell(cellKey).Value = dataItem.StatusCode;
cellKey = GetCellKey(row, cell++);
worksheet.Cell(cellKey).Value = dataItem.TimeUtc;
cellKey = GetCellKey(row, cell++);
worksheet.Cell(cellKey).Value = dataItem.Sequence;
cellKey = GetCellKey(row, cell++);
worksheet.Cell(cellKey).Value = dataItem.AllXml;
}
public override void WriteHeaderLineToClosedXmlWorkSheet(ClosedXML.Excel.IXLWorksheet worksheet, int row)
{
char cell = 'A';
string cellKey;
cellKey = Framework.Services.ClosedXmlHelper.GetCellKey(row, cell++);
worksheet.Cell(cellKey).Value = "Build_1_Name";
cellKey = Framework.Services.ClosedXmlHelper.GetCellKey(row, cell++);
worksheet.Cell(cellKey).Value = "Id";
cellKey = Framework.Services.ClosedXmlHelper.GetCellKey(row, cell++);
worksheet.Cell(cellKey).Value = "Solution_1Id";
cellKey = Framework.Services.ClosedXmlHelper.GetCellKey(row, cell++);
worksheet.Cell(cellKey).Value = "Solution_1_Name";
cellKey = Framework.Services.ClosedXmlHelper.GetCellKey(row, cell++);
worksheet.Cell(cellKey).Value = "Organization_1_UniqueidentifierColumn";
cellKey = Framework.Services.ClosedXmlHelper.GetCellKey(row, cell++);
worksheet.Cell(cellKey).Value = "Organization_1_UniqueIdentifier";
cellKey = Framework.Services.ClosedXmlHelper.GetCellKey(row, cell++);
worksheet.Cell(cellKey).Value = "Organization_1Id";
cellKey = Framework.Services.ClosedXmlHelper.GetCellKey(row, cell++);
worksheet.Cell(cellKey).Value = "Organization_1_Name";
cellKey = Framework.Services.ClosedXmlHelper.GetCellKey(row, cell++);
worksheet.Cell(cellKey).Value = "Organization_2_UniqueidentifierColumn";
cellKey = Framework.Services.ClosedXmlHelper.GetCellKey(row, cell++);
worksheet.Cell(cellKey).Value = "Organization_2Id";
cellKey = Framework.Services.ClosedXmlHelper.GetCellKey(row, cell++);
worksheet.Cell(cellKey).Value = "Organization_2_UniqueIdentifier";
cellKey = Framework.Services.ClosedXmlHelper.GetCellKey(row, cell++);
worksheet.Cell(cellKey).Value = "Organization_2_Name";
cellKey = Framework.Services.ClosedXmlHelper.GetCellKey(row, cell++);
worksheet.Cell(cellKey).Value = "BuildEventCode_1_Name";
cellKey = Framework.Services.ClosedXmlHelper.GetCellKey(row, cell++);
worksheet.Cell(cellKey).Value = "BuildId";
cellKey = Framework.Services.ClosedXmlHelper.GetCellKey(row, cell++);
worksheet.Cell(cellKey).Value = "BuildEventCodeId";
cellKey = Framework.Services.ClosedXmlHelper.GetCellKey(row, cell++);
worksheet.Cell(cellKey).Value = "Message";
cellKey = Framework.Services.ClosedXmlHelper.GetCellKey(row, cell++);
worksheet.Cell(cellKey).Value = "EventTime";
}
private void setHeaderStyle(ClosedXML.Excel.IXLWorksheet sheet, int startCellRow, int startCellCol, int endCellRow, int endCellCol)
{
var rang = sheet.Range(startCellRow, startCellCol, endCellRow, endCellCol);
rang.Style.Font.Bold = true;
rang.Style.Font.FontColor = ClosedXML.Excel.XLColor.White;
rang.Style.Fill.BackgroundColor = ClosedXML.Excel.XLColor.LightGray;
formateCells(rang);
}
public override void WriteDataItemToClosedXmlWorkSheet(ClosedXML.Excel.IXLWorksheet worksheet, MSBuildLogsExtended.DataSourceEntities.Build.UpdateNameRequest dataItem, int row)
{
char cell = 'A';
string cellKey;
cellKey = Framework.Services.ClosedXmlHelper.GetCellKey(row, cell++);
worksheet.Cell(cellKey).Value = dataItem.Id;
cellKey = Framework.Services.ClosedXmlHelper.GetCellKey(row, cell++);
worksheet.Cell(cellKey).Value = dataItem.Name;
}
public override void WriteHeaderLineToClosedXmlWorkSheet(ClosedXML.Excel.IXLWorksheet worksheet, int row)
{
char cell = 'A';
string cellKey;
cellKey = Framework.Services.ClosedXmlHelper.GetCellKey(row, cell++);
worksheet.Cell(cellKey).Value = "Id";
cellKey = Framework.Services.ClosedXmlHelper.GetCellKey(row, cell++);
worksheet.Cell(cellKey).Value = "EventCode";
}
public override void WriteDataItemToClosedXmlWorkSheet(ClosedXML.Excel.IXLWorksheet worksheet, MSBuildExtensionPack.DataSourceEntities.BuildEventCode.KeyInformation dataItem, int row)
{
char cell = 'A';
string cellKey;
cellKey = Framework.Services.ClosedXmlHelper.GetCellKey(row, cell++);
worksheet.Cell(cellKey).Value = dataItem.Id;
cellKey = Framework.Services.ClosedXmlHelper.GetCellKey(row, cell++);
worksheet.Cell(cellKey).Value = dataItem.EventCode;
}
/// <summary>
/// Write a share ACL into worksheet and the evolution of his ACL.
/// </summary>
/// <param name="worksheet"></param>
/// <param name="shareACL"></param>
/// <param name="row">Row number to start from</param>
/// <returns>First free row number</returns>
static int WriteShare(ClosedXML.Excel.IXLWorksheet worksheet, SMBShareACL shareACL, int row)
{
if (Config.Debug)
{
Console.WriteLine("[*] Writing share on " + row.ToString() + " " + shareACL.share.ToString() + " ACLs ...");
}
int col = 1;
if (shareACL.shareACL.Count > 0)
{
row = InsertACL(
worksheet,
shareACL.share.hostname,
shareACL.share.ToString(),
shareACL.share.shareInfo.shi1_remark,
0,
shareACL.shareACL,
row,
null,
(shareACL.shareACLEvolution.Count > 0) ? shareACL.shareACLEvolution.First().Value.Keys.ToList() : null
);
}
else
{
worksheet.Cell(row, col++).Value = shareACL.share.hostname;
worksheet.Cell(row, col++).Value = shareACL.share.ToString();
worksheet.Cell(row, col++).Value = shareACL.share.shareInfo.shi1_remark;
worksheet.Cell(row, col++).Value = 0;
worksheet.Cell(row, col++).Value = "No ACE";
worksheet.Cell(row, col++).Value = "";
worksheet.Cell(row, col++).Value = shareACL.discoveryDateTime;
row++;
}
if (shareACL.shareACLEvolution.Count > 0)
{
row = InsertACLEvolution(
worksheet,
shareACL.share.hostname,
shareACL.share.ToString(),
shareACL.share.shareInfo.shi1_remark,
0,
shareACL.shareACLEvolution,
row,
shareACL.shareACL.Keys.ToList()
);
}
return(row);
}
public override void WriteDataItemToClosedXmlWorkSheet(ClosedXML.Excel.IXLWorksheet worksheet, MSBuildExtensionPack.DataSourceEntities.Build.Default dataItem, int row)
{
char cell = 'A';
string cellKey;
cellKey = Framework.Services.ClosedXmlHelper.GetCellKey(row, cell++);
worksheet.Cell(cellKey).Value = dataItem.Solution_1_Name;
cellKey = Framework.Services.ClosedXmlHelper.GetCellKey(row, cell++);
worksheet.Cell(cellKey).Value = dataItem.Id;
cellKey = Framework.Services.ClosedXmlHelper.GetCellKey(row, cell++);
worksheet.Cell(cellKey).Value = dataItem.Organization_1Id;
cellKey = Framework.Services.ClosedXmlHelper.GetCellKey(row, cell++);
worksheet.Cell(cellKey).Value = dataItem.Organization_1_UniqueIdentifier;
cellKey = Framework.Services.ClosedXmlHelper.GetCellKey(row, cell++);
worksheet.Cell(cellKey).Value = dataItem.Organization_1_UniqueidentifierColumn;
cellKey = Framework.Services.ClosedXmlHelper.GetCellKey(row, cell++);
worksheet.Cell(cellKey).Value = dataItem.Organization_1_Name;
cellKey = Framework.Services.ClosedXmlHelper.GetCellKey(row, cell++);
worksheet.Cell(cellKey).Value = dataItem.Organization_2Id;
cellKey = Framework.Services.ClosedXmlHelper.GetCellKey(row, cell++);
worksheet.Cell(cellKey).Value = dataItem.Organization_2_UniqueIdentifier;
cellKey = Framework.Services.ClosedXmlHelper.GetCellKey(row, cell++);
worksheet.Cell(cellKey).Value = dataItem.Organization_2_UniqueidentifierColumn;
cellKey = Framework.Services.ClosedXmlHelper.GetCellKey(row, cell++);
worksheet.Cell(cellKey).Value = dataItem.Organization_2_Name;
cellKey = Framework.Services.ClosedXmlHelper.GetCellKey(row, cell++);
worksheet.Cell(cellKey).Value = dataItem.SolutionId;
cellKey = Framework.Services.ClosedXmlHelper.GetCellKey(row, cell++);
worksheet.Cell(cellKey).Value = dataItem.Name;
cellKey = Framework.Services.ClosedXmlHelper.GetCellKey(row, cell++);
worksheet.Cell(cellKey).Value = dataItem.Description;
cellKey = Framework.Services.ClosedXmlHelper.GetCellKey(row, cell++);
worksheet.Cell(cellKey).Value = dataItem.BuildStartTime;
}
public override void WriteDataItemToClosedXmlWorkSheet(ClosedXML.Excel.IXLWorksheet worksheet, MSBuildLogsExtended.DataSourceEntities.Solution dataItem, int row)
{
char cell = 'A';
string cellKey;
cellKey = Framework.Services.ClosedXmlHelper.GetCellKey(row, cell++);
worksheet.Cell(cellKey).Value = dataItem.Id;
cellKey = Framework.Services.ClosedXmlHelper.GetCellKey(row, cell++);
worksheet.Cell(cellKey).Value = dataItem.ExternalParentId;
cellKey = Framework.Services.ClosedXmlHelper.GetCellKey(row, cell++);
worksheet.Cell(cellKey).Value = dataItem.Name;
cellKey = Framework.Services.ClosedXmlHelper.GetCellKey(row, cell++);
worksheet.Cell(cellKey).Value = dataItem.Description;
}
public override void WriteHeaderLineToClosedXmlWorkSheet(ClosedXML.Excel.IXLWorksheet worksheet, int row)
{
char cell = 'A';
string cellKey;
cellKey = Framework.Services.ClosedXmlHelper.GetCellKey(row, cell++);
worksheet.Cell(cellKey).Value = "Organization_1_UniqueIdentifier";
cellKey = Framework.Services.ClosedXmlHelper.GetCellKey(row, cell++);
worksheet.Cell(cellKey).Value = "Organization_1_UniqueidentifierColumn";
cellKey = Framework.Services.ClosedXmlHelper.GetCellKey(row, cell++);
worksheet.Cell(cellKey).Value = "Organization_1_Name";
cellKey = Framework.Services.ClosedXmlHelper.GetCellKey(row, cell++);
worksheet.Cell(cellKey).Value = "Id";
cellKey = Framework.Services.ClosedXmlHelper.GetCellKey(row, cell++);
worksheet.Cell(cellKey).Value = "Organization_2Id";
cellKey = Framework.Services.ClosedXmlHelper.GetCellKey(row, cell++);
worksheet.Cell(cellKey).Value = "Organization_2_UniqueIdentifier";
cellKey = Framework.Services.ClosedXmlHelper.GetCellKey(row, cell++);
worksheet.Cell(cellKey).Value = "Organization_2_UniqueidentifierColumn";
cellKey = Framework.Services.ClosedXmlHelper.GetCellKey(row, cell++);
worksheet.Cell(cellKey).Value = "Organization_2_Name";
cellKey = Framework.Services.ClosedXmlHelper.GetCellKey(row, cell++);
worksheet.Cell(cellKey).Value = "ExternalParentId";
cellKey = Framework.Services.ClosedXmlHelper.GetCellKey(row, cell++);
worksheet.Cell(cellKey).Value = "Name";
cellKey = Framework.Services.ClosedXmlHelper.GetCellKey(row, cell++);
worksheet.Cell(cellKey).Value = "Description";
cellKey = Framework.Services.ClosedXmlHelper.GetCellKey(row, cell++);
worksheet.Cell(cellKey).Value = "OrganizationId";
}
public override void WriteHeaderLineToClosedXmlWorkSheet(ClosedXML.Excel.IXLWorksheet worksheet, int row)
{
char cell = 'A';
string cellKey;
cellKey = Framework.Services.ClosedXmlHelper.GetCellKey(row, cell++);
worksheet.Cell(cellKey).Value = "Id";
cellKey = Framework.Services.ClosedXmlHelper.GetCellKey(row, cell++);
worksheet.Cell(cellKey).Value = "SolutionId";
cellKey = Framework.Services.ClosedXmlHelper.GetCellKey(row, cell++);
worksheet.Cell(cellKey).Value = "Name";
cellKey = Framework.Services.ClosedXmlHelper.GetCellKey(row, cell++);
worksheet.Cell(cellKey).Value = "Description";
cellKey = Framework.Services.ClosedXmlHelper.GetCellKey(row, cell++);
worksheet.Cell(cellKey).Value = "BuildStartTime";
}
public string[,] OpenExcel(string filename)
{
using (ClosedXML.Excel.XLWorkbook workbook = new ClosedXML.Excel.XLWorkbook(filename))
{
ClosedXML.Excel.IXLWorksheet worksheet = workbook.Worksheet(1);
int rc = worksheet.RangeUsed().RowCount();
int cc = worksheet.RangeUsed().Row(1).CellCount();
string[,] buff = new string[rc, cc];
for (int i = 0; i < rc; i++)
{
ClosedXML.Excel.IXLRow row = worksheet.Row(i + 1);
for (int j = 0; j < cc; j++)
{
ClosedXML.Excel.IXLCell cell = row.Cell(j + 1);
string value = cell.GetValue <string>();
buff[i, j] = value;
}
}
return(buff);
}
}
/// <summary>
/// Write the first row on the Excel worksheet.
/// </summary>
/// <param name="worksheet">An Excel worksheet object on which we write</param>
/// <param name="row">The row number where to write</param>
/// <param name="col">The column number where to write</param>
/// <returns>The next empty row</returns>
private static int WriteHeader(ClosedXML.Excel.IXLWorksheet worksheet, int row = 1, int col = 1)
{
worksheet.Cell(row, col++).Value = "Hostname";
worksheet.Cell(row, col++).Value = "UNC Path";
worksheet.Cell(row, col++).Value = "Remark";
worksheet.Cell(row, col++).Value = "Level";
worksheet.Cell(row, col++).Value = "ACE status";
worksheet.Cell(row, col++).Value = "ACE_ID";
worksheet.Cell(row, col++).Value = "DateTime";
worksheet.Cell(row, col++).Value = "AccessControlType";
worksheet.Cell(row, col++).Value = "CompactReadableFileSystemRights";
worksheet.Cell(row, col++).Value = "ReadableFileSystemRights";
worksheet.Cell(row, col++).Value = "ReadableIdentityReference";
worksheet.Cell(row, col++).Value = "IdentityReference";
worksheet.Cell(row, col++).Value = "Owner";
worksheet.Cell(row, col++).Value = "OwnerSID";
worksheet.Cell(row, col++).Value = "IsInherited";
worksheet.Cell(row, col++).Value = "InheritanceFlags";
worksheet.Cell(row, col++).Value = "PropagationFlags";
col = 1;
return(++row);
}
private void ScriviOre(
ClosedXML.Excel.IXLWorksheet meseSheet, List <RowExcel> dataOutput)
{
int row = 3;
var it = new CultureInfo("it-IT");
while (dataOutput.Count() > 0)
{
var itemRowOutput = dataOutput.Select(a => a).OrderBy(a => a.Data).FirstOrDefault();
dataOutput.Remove(itemRowOutput);
if (!meseSheet.Cell(row, 4).IsEmpty())
{
meseSheet.Row(row).InsertRowsBelow(1);
row++;
}
meseSheet.Cell(row, 1).Value = itemRowOutput.Data.ToString("dd/MM/yyyy");
meseSheet.Cell(row, 2).Value = itemRowOutput.Data.ToString("ddd", it);
meseSheet.Cell(row, 3).Value = System.Globalization.ISOWeek.GetWeekOfYear(itemRowOutput.Data);
meseSheet.Cell(row, 4).Value = itemRowOutput.Commessa;
meseSheet.Cell(row, 6).Value = itemRowOutput.NumeroOre;
meseSheet.Cell(row, 5).Value = itemRowOutput.SedeLavoro;
if (itemRowOutput.Pasto)
{
Pernotto(meseSheet, row);
}
row++;
}
}
public override void WriteHeaderLineToClosedXmlWorkSheet(ClosedXML.Excel.IXLWorksheet worksheet, int row)
{
char cell = 'A';
string cellKey;
cellKey = Framework.Services.ClosedXmlHelper.GetCellKey(row, cell++);
worksheet.Cell(cellKey).Value = "Id";
cellKey = Framework.Services.ClosedXmlHelper.GetCellKey(row, cell++);
worksheet.Cell(cellKey).Value = "Name";
cellKey = Framework.Services.ClosedXmlHelper.GetCellKey(row, cell++);
worksheet.Cell(cellKey).Value = "IsSystemBuiltIn";
cellKey = Framework.Services.ClosedXmlHelper.GetCellKey(row, cell++);
worksheet.Cell(cellKey).Value = "UniqueIdentifier";
cellKey = Framework.Services.ClosedXmlHelper.GetCellKey(row, cell++);
worksheet.Cell(cellKey).Value = "BitColumn";
cellKey = Framework.Services.ClosedXmlHelper.GetCellKey(row, cell++);
worksheet.Cell(cellKey).Value = "UniqueidentifierColumn";
}
public override void WriteDataItemToClosedXmlWorkSheet(ClosedXML.Excel.IXLWorksheet worksheet, MSBuildExtensionPack.DataSourceEntities.Organization.KeyInformation dataItem, int row)
{
char cell = 'A';
string cellKey;
cellKey = Framework.Services.ClosedXmlHelper.GetCellKey(row, cell++);
worksheet.Cell(cellKey).Value = dataItem.Id;
cellKey = Framework.Services.ClosedXmlHelper.GetCellKey(row, cell++);
worksheet.Cell(cellKey).Value = dataItem.Name;
cellKey = Framework.Services.ClosedXmlHelper.GetCellKey(row, cell++);
worksheet.Cell(cellKey).Value = dataItem.IsSystemBuiltIn;
cellKey = Framework.Services.ClosedXmlHelper.GetCellKey(row, cell++);
worksheet.Cell(cellKey).Value = dataItem.UniqueIdentifier;
cellKey = Framework.Services.ClosedXmlHelper.GetCellKey(row, cell++);
worksheet.Cell(cellKey).Value = dataItem.BitColumn;
cellKey = Framework.Services.ClosedXmlHelper.GetCellKey(row, cell++);
worksheet.Cell(cellKey).Value = dataItem.UniqueidentifierColumn;
}
/// <summary>
/// Write ACL into worksheet.
/// </summary>
/// <param name="worksheet"></param>
/// <param name="hostname"></param>
/// <param name="shareName"></param>
/// <param name="remark"></param>
/// <param name="level"></param>
/// <param name="acl"></param>
/// <param name="row">Row number to start from</param>
/// <param name="lastScan">List of ACE_ID of the previous scan</param>
/// <param name="nextScan">List of ACE_ID of the scan after the current one</param>
/// <returns></returns>
static int InsertACL(ClosedXML.Excel.IXLWorksheet worksheet, string hostname, string shareName, string remark, int level, Dictionary <string, Dictionary <string, string> > acl, int row, List <string> lastScan = null, List <string> nextScan = null)
{
int col = 1;
if (acl.Count > 0)
{
foreach (var entry in acl)
{
if (Config.Debug && entry.Key != "noACE")
{
Console.WriteLine("[*] Writing share ACE on " + row.ToString() + " " + entry.Value["AccessControlType"] + " " + entry.Value["ReadableFileSystemRights"] + " to " + entry.Value["ReadableIdentityReference"] + " on " + shareName);
}
worksheet.Cell(row, col++).Value = hostname;
worksheet.Cell(row, col++).Value = shareName;
worksheet.Cell(row, col++).Value = remark;
worksheet.Cell(row, col++).Value = level;
if (entry.Key == "noACE")
{
worksheet.Cell(row, col++).Value = "No ACE";
worksheet.Cell(row, col++).Value = "";
worksheet.Cell(row, col++).Value = entry.Value["DiscoveryDateTime"];
}
else
{
if (nextScan != null && lastScan != null)
{
if (lastScan.Contains(entry.Value["IdentityReference"] + "-" + entry.Value["FileSystemRights"]) && nextScan.Contains(entry.Value["IdentityReference"] + "-" + entry.Value["FileSystemRights"]))
{
worksheet.Cell(row, col++).Value = "No change";
}
else if (!lastScan.Contains(entry.Value["IdentityReference"] + "-" + entry.Value["FileSystemRights"]) && nextScan.Contains(entry.Value["IdentityReference"] + "-" + entry.Value["FileSystemRights"]))
{
worksheet.Cell(row, col++).Value = "New ACE";
}
else if (lastScan.Contains(entry.Value["IdentityReference"] + "-" + entry.Value["FileSystemRights"]) && !nextScan.Contains(entry.Value["IdentityReference"] + "-" + entry.Value["FileSystemRights"]))
{
worksheet.Cell(row, col++).Value = "ACE Removed ";
}
else
{
worksheet.Cell(row, col++).Value = "ACE Removed";
}
}
else if (nextScan != null)
{
worksheet.Cell(row, col++).Value = nextScan.Contains(entry.Value["IdentityReference"] + "-" + entry.Value["FileSystemRights"]) ? "New ACE" : "ACE removed";
}
else if (lastScan != null)
{
worksheet.Cell(row, col++).Value = lastScan.Contains(entry.Value["IdentityReference"] + "-" + entry.Value["FileSystemRights"]) ? "No change" : "New ACE";
}
else
{
worksheet.Cell(row, col++).Value = "New ACE";
}
worksheet.Cell(row, col++).Value = entry.Value["IdentityReference"] + "-" + entry.Value["FileSystemRights"];
worksheet.Cell(row, col++).Value = entry.Value["DiscoveryDateTime"];
worksheet.Cell(row, col++).Value = entry.Value["AccessControlType"];
worksheet.Cell(row, col++).Value = entry.Value["CompactReadableFileSystemRights"];
worksheet.Cell(row, col++).Value = entry.Value["ReadableFileSystemRights"];
worksheet.Cell(row, col++).Value = (entry.Value["ReadableIdentityReference"].StartsWith("S-1-5")) ? TranslateSid(entry.Value["ReadableIdentityReference"]) : entry.Value["ReadableIdentityReference"];
worksheet.Cell(row, col++).Value = entry.Value["IdentityReference"];
worksheet.Cell(row, col++).Value = (entry.Value["Owner"].StartsWith("S-1-5")) ? TranslateSid(entry.Value["Owner"]) : entry.Value["Owner"];
worksheet.Cell(row, col++).Value = entry.Value["OwnerSID"];
worksheet.Cell(row, col++).Value = entry.Value["IsInherited"];
worksheet.Cell(row, col++).Value = entry.Value["InheritanceFlags"];
worksheet.Cell(row, col++).Value = entry.Value["PropagationFlags"];
}
col = 1;
row++;
}
}
return(row);
}
