protected void uploadProgress_DoUploadProgress(HttpPostedFile file, UploadProgressResult result)
{
string tag = uploadProgress.Tag;
const int baseRowIndex = 3;
ExceptionHelper.FalseThrow(Path.GetExtension(file.FileName).ToLower() == ".xml",
"'{0}' must be a xml file.", file.FileName);
WorkbookNode workbook = new WorkbookNode();
workbook.Load(file.InputStream);
ExceptionHelper.FalseThrow(workbook.Worksheets.Contains("PC Tracker Form"),
"The workbook must contains a 'PC Tracker Form' worksheet.");
Dictionary<string, CellLocation> fieldLocations = BuildNameColumnDictionary(workbook);
TableNode table = workbook.Worksheets["PC Tracker Form"].Table;
StringBuilder strB = new StringBuilder();
if (table.Rows.Count > 3)
{
int currentRowIndex = baseRowIndex;
UploadProgressStatus status = new UploadProgressStatus();
status.CurrentStep = 1;
status.MinStep = 0;
status.MaxStep = table.Rows.Count - currentRowIndex;
int currentVirtualRow = baseRowIndex;
for (int i = status.MinStep; i < status.MaxStep; i++)
{
currentRowIndex = baseRowIndex + i;
RowNode row = table.Rows[currentRowIndex];
if (row.Index > 0)
currentVirtualRow = row.Index;
else
currentVirtualRow++;
if (strB.Length > 0)
strB.Append("\n");
strB.AppendFormat("Processed={0}, Row={1}:", (i + 1), currentVirtualRow);
foreach (KeyValuePair<string, CellLocation> kp in fieldLocations)
{
CellNode cell = row.GetCellByIndex(kp.Value.Column);
strB.AppendFormat(";Name={0}, Value={1}", kp.Key, cell != null ? cell.Data.Value : string.Empty);
}
status.CurrentStep = i;
status.Response();
int ms = 1000;
if (Request.Form["longProgress"] == "true")
ms = 2000;
Thread.Sleep(ms); //假装等待
}
status.CurrentStep = status.MaxStep;
status.Response();
}
result.DataChanged = true;
result.CloseWindow = false;
result.ProcessLog = strB.ToString();
}
/// <summary>
/// 导出到Excel Xml中，非OpenXml
/// </summary>
/// <param name="coll"></param>
/// <param name="propertySheetName"></param>
/// <returns></returns>
public static WorkbookNode ExportToExcelXml(SOARolePropertyDefinitionCollection definition, string propertySheetName)
{
WorkbookNode workbook = new WorkbookNode();
string filePath = HttpContext.Current.Server.MapPath("RolePropertyTemplate.xml");
workbook.Load(filePath);
ExportToExcelXml(workbook, definition, propertySheetName);
return workbook;
}
/// <summary>
/// 导入Excel Xml格式的文件
/// </summary>
/// <param name="stream"></param>
private void ImportFromXml(Stream stream)
{
WorkbookNode workbook = new WorkbookNode();
workbook.Load(stream);
ExceptionHelper.FalseThrow(workbook.Worksheets.Contains("Matrix"),
"The workbook must contains a 'Matrix' worksheet.");
SOARole role = null;
ServiceBrokerContext.Current.SaveContextStates();
try
{
if (this.AppCodeName.IsNotEmpty() && this.RoleCodeName.IsNotEmpty())
role = new SOARole(this.AppCodeName + ":" + this.RoleCodeName);
else
role = new SOARole(this.Definition) { ID = RoleID };
role.Rows.Clear();
NamedLocationCollection fieldLocations = workbook.Names.ToLocations();
TableNode table = workbook.Worksheets["Matrix"].Table;
int baseRowIndex = GetStartRow(fieldLocations);
RowNode titleRow = table.GetRowByIndex(baseRowIndex);
int currentRowIndex = table.Rows.IndexOf(titleRow) + 1;
if (table.Rows.Count > currentRowIndex)
{
UploadProgressStatus status = new UploadProgressStatus();
status.CurrentStep = 1;
status.MinStep = 0;
status.MaxStep = table.Rows.Count - currentRowIndex;
int currentVirtualRow = baseRowIndex;
for (int i = status.MinStep; i < status.MaxStep; i++)
{
RowNode row = table.Rows[currentRowIndex];
if (row.Index > 0)
currentVirtualRow = row.Index;
else
currentVirtualRow++;
GenerateMatrixRow(role, row, fieldLocations, i);
status.CurrentStep = i;
status.Response();
currentRowIndex++;
}
status.CurrentStep = status.MaxStep;
status.Response();
}
//插入记录
SOARolePropertiesAdapter.Instance.Update(role);
}
finally
{
ServiceBrokerContext.Current.RestoreSavedStates();
}
}
protected void uploadProgress_DoUploadProgress(HttpPostedFile file, UploadProgressResult result)
{
ExceptionHelper.FalseThrow(Path.GetExtension(file.FileName).ToLower() == ".xml",
"'{0}' must be a xml file.", file.FileName);
WorkbookNode workbook = new WorkbookNode();
workbook.Load(file.InputStream);
ExceptionHelper.FalseThrow(workbook.Worksheets.Contains("Matrix"),
"The workbook must contains a 'Matrix' worksheet.");
NamedLocationCollection fieldLocations = workbook.Names.ToLocations();
TableNode table = workbook.Worksheets["Matrix"].Table;
StringBuilder strB = new StringBuilder();
int baseRowIndex = GetStartRow(fieldLocations);
RowNode titleRow = table.GetRowByIndex(baseRowIndex);
int currentRowIndex = table.Rows.IndexOf(titleRow) + 1;
if (table.Rows.Count > currentRowIndex)
{
UploadProgressStatus status = new UploadProgressStatus();
status.CurrentStep = 1;
status.MinStep = 0;
status.MaxStep = table.Rows.Count - currentRowIndex;
int currentVirtualRow = baseRowIndex;
for (int i = status.MinStep; i < status.MaxStep; i++)
{
RowNode row = table.Rows[currentRowIndex];
if (row.Index > 0)
currentVirtualRow = row.Index;
else
currentVirtualRow++;
if (strB.Length > 0)
strB.Append("\n");
strB.AppendFormat("Processed={0}, Row={1}:", (i + 1), currentVirtualRow);
foreach (CellLocation location in fieldLocations)
{
CellNode cell = row.GetCellByIndex(location.Column);
strB.AppendFormat(";Name={0}, Value={1}", location.Name, cell != null ? cell.Data.Value : string.Empty);
}
status.CurrentStep = i;
status.Response();
currentRowIndex++;
}
status.CurrentStep = status.MaxStep;
status.Response();
}
result.DataChanged = true;
result.CloseWindow = false;
result.ProcessLog = strB.ToString();
}
