protected void odsACCPrePayableStatementDetail_Selecting(object sender, ObjectDataSourceSelectingEventArgs e) { if (e.ExecutingSelectCount == false) { UpdatePayableStatementDetail(); } String fe = String.Empty; String fe1 = ACCPostPayableStatementDetailEntity.FLD_NAME_ACCPayableApprovalStatusID + " <> " + MasterDataConstants.ACCPrePayableStatementApprovalStatus.APPROVED.ToString(); String fe2 = SqlExpressionBuilder.PrepareFilterExpression(ACCPostPayableStatementDetailEntity.FLD_NAME_PostPayableStatementID, ACCPostPayableStatementID.ToString(), SQLMatchType.Equal); fe = SqlExpressionBuilder.PrepareFilterExpression(fe1, SQLJoinType.AND, fe2); if (OverviewACCPostPayableStatementDetailID > 0) { String fe3 = SqlExpressionBuilder.PrepareFilterExpression(ACCPostPayableStatementDetailEntity.FLD_NAME_PostPayableStatementDetailID, OverviewACCPostPayableStatementDetailID.ToString(), SQLMatchType.Equal); fe = SqlExpressionBuilder.PrepareFilterExpression(fe, SQLJoinType.AND, fe3); } e.InputParameters["filterExpression"] = fe; }
protected void odsACCPostPayableStatementDetail_Selecting(object sender, ObjectDataSourceSelectingEventArgs e) { String fe = SqlExpressionBuilder.PrepareFilterExpression(ACCPostPayableStatementEntity.FLD_NAME_PostPayableStatementID, ACCPostPayableStatementID.ToString(), SQLMatchType.Equal); if (OverviewACCPostPayableStatementDetailID > 0) { String fe1 = SqlExpressionBuilder.PrepareFilterExpression(ACCPostPayableStatementDetailEntity.FLD_NAME_PostPayableStatementDetailID, OverviewACCPostPayableStatementDetailID.ToString(), SQLMatchType.Equal); fe = SqlExpressionBuilder.PrepareFilterExpression(fe, SQLJoinType.AND, fe1); } e.InputParameters["filterExpression"] = fe; }