protected void odsINVTransaction_Selecting(object sender, ObjectDataSourceSelectingEventArgs e)
{
String fe = String.Empty;
if (OverviewItemID > 0 && INVStoreUnitID > 0)
{
String fe1 = SqlExpressionBuilder.PrepareFilterExpression("INVTransaction." + INVTransactionEntity.FLD_NAME_StoreUnitID, INVStoreUnitID.ToString(), SQLMatchType.Equal);
String fe2 = SqlExpressionBuilder.PrepareFilterExpression("INVTransaction." + INVTransactionEntity.FLD_NAME_ItemID, OverviewItemID.ToString(), SQLMatchType.Equal);
String fe3 = SqlExpressionBuilder.PrepareFilterExpression("INVStore." + INVTransactionEntity.FLD_NAME_ProjectID, OverviewProjectID.ToString(), SQLMatchType.Equal);
fe = SqlExpressionBuilder.PrepareFilterExpression(fe1, SQLJoinType.AND, fe2);
fe = SqlExpressionBuilder.PrepareFilterExpression(fe, SQLJoinType.AND, fe3);
}
fe = BuildFilterArgument(fe);
e.InputParameters["filterExpression"] = fe;
}
protected void odsINVStoreIssueNoteItemMap_Selecting(object sender, ObjectDataSourceSelectingEventArgs e)
{
String fe = string.Empty;
String fe1 = SqlExpressionBuilder.PrepareFilterExpression("INVStoreIssueNoteItemMap." + INVStoreIssueNoteItemMap_DetailedEntity.FLD_NAME_ItemID, OverviewItemID.ToString(), SQLMatchType.Equal);
String fe2 = SqlExpressionBuilder.PrepareFilterExpression("INVStoreIssueNoteItemMap." + INVStoreIssueNoteItemMap_DetailedEntity.FLD_NAME_ReceivedByEmployeeID, OverviewReceivedByEmployeeID.ToString(), SQLMatchType.Equal);
String fe3 = SqlExpressionBuilder.PrepareFilterExpression("INVStoreIssueNoteItemMap." + INVStoreIssueNoteItemMap_DetailedEntity.FLD_NAME_IssuedFromStoreUnitID, OverviewIssuedFromStoreUnitID.ToString(), SQLMatchType.Equal);
fe = SqlExpressionBuilder.PrepareFilterExpression(fe1, SQLJoinType.AND, fe2);
fe = SqlExpressionBuilder.PrepareFilterExpression(fe, SQLJoinType.AND, fe3);
e.InputParameters["filterExpression"] = fe;
}
