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;
        }
Exemple #2
0
        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;
        }