public WfMatrix BuildWfMatrix() { var matrixDef = BuildNewMatrixDef(_matrixColumnNum); WfMatrix matrixInstance = new WfMatrix(matrixDef) { CreatorID = "testCreatorID1", CreatorName = "testCreatorName1", MatrixID = UuidHelper.NewUuidString(), ProcessKey = "testProcessKey", ActivityKey = "testActivityKey" }; for (int i = 0; i < _matrixRowNum; i++) { var row = new WfMatrixRow() { RowNumber = i, OperatorType = WfMatrixOperatorType.Person, Operator = "wanhw" }; if (i % 2 == 0) { row.Operator = "fanhy"; } for (int j = 0; j < matrixDef.Dimensions.Count; j++) { row.Cells.Add(new WfMatrixCell(matrixDef.Dimensions[j]) { StringValue = "String" + j.ToString() }); } matrixInstance.Rows.Add(row); } return(matrixInstance); }
private static WfMatrixRow AddMatrixRow(WfMatrix matrix, params string[] values) { WfMatrixRow row = new WfMatrixRow(matrix); row.RowNumber = matrix.Rows.Count; for (int i = 0; i < matrix.Definition.Dimensions.Count; i++) { WfMatrixDimensionDefinition dd = matrix.Definition.Dimensions[i]; WfMatrixCell cell = new WfMatrixCell(dd); if (i < values.Length) cell.StringValue = values[i]; row.Cells.Add(cell); } matrix.Rows.Add(row); return row; }
private static WfMatrixRow AddMatrixRow(WfMatrix matrix, params string[] values) { WfMatrixRow row = new WfMatrixRow(matrix); row.RowNumber = matrix.Rows.Count; for (int i = 0; i < matrix.Definition.Dimensions.Count; i++) { WfMatrixDimensionDefinition dd = matrix.Definition.Dimensions[i]; WfMatrixCell cell = new WfMatrixCell(dd); if (i < values.Length) { cell.StringValue = values[i]; } row.Cells.Add(cell); } matrix.Rows.Add(row); return(row); }
protected void uploadProgress_DoUploadProgress(HttpPostedFile file, UploadProgressResult result) { ExceptionHelper.FalseThrow(Path.GetExtension(file.FileName).ToLower() == ".xml", "'{0}'权限矩阵必须是xml电子表格", file.FileName); WorkbookNode workbook = new WorkbookNode(); workbook.Load(file.InputStream); //矩阵在文件第1个sheet,sheet名称为矩阵引用的定义名称 TableNode table = workbook.Worksheets[0].Table; var matrixDef = WfMatrixDefinitionAdapter.Instance.Load(workbook.Worksheets[0].Name); WfMatrix matrix = new WfMatrix(matrixDef) { MatrixID = Guid.NewGuid().ToString() }; if (table.Rows.Count <= 1) { PrepareResultInfo(result, "没有数据或格式不正确"); return; } UploadProgressStatus status = new UploadProgressStatus(); status.CurrentStep = 1; status.MinStep = 0; status.MaxStep = table.Rows.Count; for (int i = status.CurrentStep; i < status.MaxStep; i++) { var newRow = new WfMatrixRow() { RowNumber = i }; for (int j = 0; j < table.Rows[i].Cells.Count; j++) { if (table.Rows[0].Cells[j].Data.InnerText == "操作人") { newRow.Operator = table.Rows[i].Cells[j].Data.InnerText; continue; } var newCell = new WfMatrixCell(matrixDef.Dimensions[table.Rows[0].Cells[j].Data.InnerText]) { StringValue = table.Rows[i].Cells[j].Data.InnerText }; newRow.Cells.Add(newCell); } matrix.Rows.Add(newRow); status.CurrentStep = i; status.Response(); Thread.Sleep(100); } status.CurrentStep = status.MaxStep; status.Response(); WfMatrixAdapter.Instance.Update(matrix); string logInfo = string.Format("导入成功,权限矩阵名称:{0}{1}共导入{2}行数据.", matrix.MatrixID, Environment.NewLine, table.Rows.Count - 1); PrepareResultInfo(result, logInfo); }
public WfMatrix BuildWfMatrix() { var matrixDef = WfMatrixDefinitionAdapterTest.BuildNewMatrixDef(_matrixColumnNum); WfMatrix matrixInstance = new WfMatrix(matrixDef) { CreatorID = "testCreatorID1", CreatorName = "testCreatorName1", MatrixID = UuidHelper.NewUuidString(), ProcessKey = "testProcessKey", ActivityKey = "testActivityKey" }; for (int i = 0; i < _matrixRowNum; i++) { var row = new WfMatrixRow() { RowNumber = i, OperatorType = WfMatrixOperatorType.Person, Operator = "wanhw" }; if (i % 2 == 0) { row.Operator = "fanhy"; } for (int j = 0; j < matrixDef.Dimensions.Count; j++) { row.Cells.Add(new WfMatrixCell(matrixDef.Dimensions[j]) { StringValue = "String" + j.ToString() }); } matrixInstance.Rows.Add(row); } return matrixInstance; }