public void QueryTest()
{
UpdateTest();
WfMatrixQueryParamCollection dict = new WfMatrixQueryParamCollection(_wfMatrixInstance.MatrixID);
var wfMatrixQuery = WfMatrixAdapter.Instance.Query(dict);
Assert.AreEqual(this._matrixRowNum, wfMatrixQuery.Rows.Count);
dict.Add(new WfMatrixQueryParam()
{
QueryName = _wfMatrixInstance.Rows[0].Cells[0].Definition.DimensionKey,
QueryValue = _wfMatrixInstance.Rows[0].Cells[0].StringValue
});
dict.Add(new WfMatrixQueryParam()
{
QueryName = _wfMatrixInstance.Rows[0].Cells[1].Definition.DimensionKey,
QueryValue = _wfMatrixInstance.Rows[0].Cells[1].StringValue
});
wfMatrixQuery = WfMatrixAdapter.Instance.Query(dict);
WfMatrixRowUsersCollection rowUserCollection = wfMatrixQuery.Rows.GenerateRowsUsers();
foreach (var rowUsers in rowUserCollection)
{
Console.WriteLine(rowUsers.Users[0].DisplayName);
Assert.AreEqual(rowUsers.Users.Count, 1);
}
Assert.AreEqual(wfMatrixQuery.Rows.Count, _matrixRowNum);
}
public void Test()
{
WfMatrixQueryParamCollection queryParams = new WfMatrixQueryParamCollection("957e9597-b7f7-4ffa-ad77-2dbf10ac3497");
queryParams.Add(new WfMatrixQueryParam()
{
QueryName = "支付方式",
QueryValue = "网银"
});
queryParams.Add(new WfMatrixQueryParam()
{
QueryName = "成本中心",
QueryValue = "成1"
});
queryParams.Add(new WfMatrixQueryParam()
{
QueryName = "部门",
QueryValue = "商务部"
});
var matrix = WfMatrixAdapter.Instance.Query(queryParams);
}
public void Test()
{
WfMatrixQueryParamCollection queryParams = new WfMatrixQueryParamCollection("957e9597-b7f7-4ffa-ad77-2dbf10ac3497");
queryParams.Add(new WfMatrixQueryParam()
{
QueryName = "支付方式",
QueryValue = "网银"
});
queryParams.Add(new WfMatrixQueryParam()
{
QueryName = "成本中心",
QueryValue = "成1"
});
queryParams.Add(new WfMatrixQueryParam()
{
QueryName = "部门",
QueryValue = "商务部"
});
var matrix = WfMatrixAdapter.Instance.Query(queryParams);
}
protected void Button1_Click(object sender, EventArgs e)
{
WfMatrixQueryParamCollection queryParams = new WfMatrixQueryParamCollection(this.txtID.Text.Trim());
queryParams.Add(new WfMatrixQueryParam()
{
QueryName = "支付方式",
QueryValue = txtPaymentType.Text.Trim()
});
queryParams.Add(new WfMatrixQueryParam()
{
QueryName = "成本中心",
QueryValue = txtCostCenter.Text.Trim()
});
queryParams.Add(new WfMatrixQueryParam()
{
QueryName = "部门",
QueryValue = txtDepartment.Text.Trim()
});
var matrix = WfMatrixAdapter.Instance.Query(queryParams);
if (matrix == null)
{
Label1.Text = "未找到相应的数据";
}
else
{
Label1.Text = "";
foreach (var row in matrix.Rows)
{
Label1.Text += row.OperatorType.ToString() + "/" + row.Operator + "<br/>";
}
}
}
public void QueryTest()
{
UpdateTest();
WfMatrixQueryParamCollection dict = new WfMatrixQueryParamCollection(_wfMatrixInstance.MatrixID);
var wfMatrixQuery = WfMatrixAdapter.Instance.Query(dict);
Assert.AreEqual(this._matrixRowNum, wfMatrixQuery.Rows.Count);
dict.Add(new WfMatrixQueryParam()
{
QueryName = _wfMatrixInstance.Rows[0].Cells[0].Definition.DimensionKey,
QueryValue = _wfMatrixInstance.Rows[0].Cells[0].StringValue
});
dict.Add(new WfMatrixQueryParam()
{
QueryName = _wfMatrixInstance.Rows[0].Cells[1].Definition.DimensionKey,
QueryValue = _wfMatrixInstance.Rows[0].Cells[1].StringValue
});
wfMatrixQuery = WfMatrixAdapter.Instance.Query(dict);
WfMatrixRowUsersCollection rowUserCollection = wfMatrixQuery.Rows.GenerateRowsUsers();
foreach (var rowUsers in rowUserCollection)
{
Console.WriteLine(rowUsers.Users[0].DisplayName);
Assert.AreEqual(rowUsers.Users.Count, 1);
}
Assert.AreEqual(wfMatrixQuery.Rows.Count, _matrixRowNum);
}
/// <summary>
/// 得到矩阵
/// </summary>
/// <returns></returns>
public WfMatrix GetMatrix()
{
WfMatrix matrix = null;
if (this.Descriptor.Properties.GetValue("UseMatrix", true))
{
matrix = WfMatrixAdapter.Instance.GetByProcessKey(this.Descriptor.Key);
if (matrix != null)
{
if (IsApplicationParametersAvailableForMatrix(matrix))
{
WfMatrixQueryParamCollection queryParams = new WfMatrixQueryParamCollection(matrix.MatrixID);
foreach (WfMatrixDimensionDefinition dd in matrix.Definition.Dimensions)
{
if (dd.DimensionKey != "OperatorType" && dd.DimensionKey != "Operator" && dd.DimensionKey != "ProcessKey" && dd.DimensionKey != "ActivityKey")
{
WfMatrixQueryParam qp = new WfMatrixQueryParam();
qp.QueryName = dd.DimensionKey;
qp.QueryValue = this.ApplicationRuntimeParameters.GetValueRecursively(dd.DimensionKey, string.Empty);
queryParams.Add(qp);
}
}
matrix = WfMatrixAdapter.Instance.Query(queryParams);
}
}
}
return matrix;
}
