public static string PrepareCause(CauseObject_MCE_B_ASSETS_CONTRACT_PAY cause, out OracleParameter[] parameters) { //平台自动生成代码 System.Text.StringBuilder strBuf = new System.Text.StringBuilder(); ArrayList paramList = new ArrayList(); OracleParameter param = null; #region Push Block if (cause.PERIODS != ConstLibrary.Template.UndefineDecimal) { strBuf.Append(" And MCE_B_ASSETS_CONTRACT_PAY.PERIODS = :C_PERIODS"); param = new OracleParameter(); param.ParameterName = ":C_PERIODS"; param.OracleType = System.Data.OracleClient.OracleType.Number; param.Size = 22; param.Value = cause.PERIODS; paramList.Add(param); } if (cause.HasINValue("PERIODS")) { strBuf.Append(cause.GetINSQL("MCE_B_ASSETS_CONTRACT_PAY", "PERIODS")); } if (!string.IsNullOrEmpty(cause.BASE_ID)) { strBuf.Append(" And MCE_B_ASSETS_CONTRACT_PAY.BASE_ID ").Append((cause.BASE_ID.StartsWith("%") || cause.BASE_ID.EndsWith("%")) ? " like " : " = ").Append(" :C_BASE_ID"); param = new OracleParameter(); param.ParameterName = ":C_BASE_ID"; param.OracleType = System.Data.OracleClient.OracleType.Char; param.Size = 36; param.Value = cause.BASE_ID; paramList.Add(param); } if (cause.HasINValue("BASE_ID")) { strBuf.Append(cause.GetINSQL("MCE_B_ASSETS_CONTRACT_PAY", "BASE_ID")); } if (cause.PLAN_PAY_DATE != null) { if (cause.PLAN_PAY_DATE.Begin != null) { strBuf.Append(" And MCE_B_ASSETS_CONTRACT_PAY.PLAN_PAY_DATE >= :C_PLAN_PAY_DATE_BEGIN"); param = new OracleParameter(); param.ParameterName = ":C_PLAN_PAY_DATE_BEGIN"; param.OracleType = System.Data.OracleClient.OracleType.DateTime; param.Size = 7; param.Value = cause.PLAN_PAY_DATE.Begin; paramList.Add(param); } if (cause.PLAN_PAY_DATE.End != null) { strBuf.Append(" And MCE_B_ASSETS_CONTRACT_PAY.PLAN_PAY_DATE < :C_PLAN_PAY_DATE_END"); param = new OracleParameter(); param.ParameterName = ":C_PLAN_PAY_DATE_END"; param.OracleType = System.Data.OracleClient.OracleType.DateTime; param.Size = 7; param.Value = cause.PLAN_PAY_DATE.End; paramList.Add(param); } } if (cause.HasINValue("PLAN_PAY_DATE")) { strBuf.Append(cause.GetINSQL("MCE_B_ASSETS_CONTRACT_PAY", "PLAN_PAY_DATE")); } if (!string.IsNullOrEmpty(cause.COMMENTS)) { strBuf.Append(" And MCE_B_ASSETS_CONTRACT_PAY.COMMENTS ").Append((cause.COMMENTS.StartsWith("%") || cause.COMMENTS.EndsWith("%")) ? " like " : " = ").Append(" :C_COMMENTS"); param = new OracleParameter(); param.ParameterName = ":C_COMMENTS"; param.OracleType = System.Data.OracleClient.OracleType.VarChar; param.Size = 200; param.Value = cause.COMMENTS; paramList.Add(param); } if (cause.HasINValue("COMMENTS")) { strBuf.Append(cause.GetINSQL("MCE_B_ASSETS_CONTRACT_PAY", "COMMENTS")); } if (cause.STATE != ConstLibrary.Template.UndefineDecimal) { strBuf.Append(" And MCE_B_ASSETS_CONTRACT_PAY.STATE = :C_STATE"); param = new OracleParameter(); param.ParameterName = ":C_STATE"; param.OracleType = System.Data.OracleClient.OracleType.Number; param.Size = 22; param.Value = cause.STATE; paramList.Add(param); } if (cause.HasINValue("STATE")) { strBuf.Append(cause.GetINSQL("MCE_B_ASSETS_CONTRACT_PAY", "STATE")); } if (cause.MONEY != ConstLibrary.Template.UndefineDecimal) { strBuf.Append(" And MCE_B_ASSETS_CONTRACT_PAY.MONEY = :C_MONEY"); param = new OracleParameter(); param.ParameterName = ":C_MONEY"; param.OracleType = System.Data.OracleClient.OracleType.Number; param.Size = 22; param.Value = cause.MONEY; paramList.Add(param); } if (cause.HasINValue("MONEY")) { strBuf.Append(cause.GetINSQL("MCE_B_ASSETS_CONTRACT_PAY", "MONEY")); } if (!string.IsNullOrEmpty(cause.ID)) { strBuf.Append(" And MCE_B_ASSETS_CONTRACT_PAY.ID ").Append((cause.ID.StartsWith("%") || cause.ID.EndsWith("%")) ? " like " : " = ").Append(" :C_ID"); param = new OracleParameter(); param.ParameterName = ":C_ID"; param.OracleType = System.Data.OracleClient.OracleType.Char; param.Size = 36; param.Value = cause.ID; paramList.Add(param); } if (cause.HasINValue("ID")) { strBuf.Append(cause.GetINSQL("MCE_B_ASSETS_CONTRACT_PAY", "ID")); } if (cause.ACTUAL_PAY_DATE != null) { if (cause.ACTUAL_PAY_DATE.Begin != null) { strBuf.Append(" And MCE_B_ASSETS_CONTRACT_PAY.ACTUAL_PAY_DATE >= :C_ACTUAL_PAY_DATE_BEGIN"); param = new OracleParameter(); param.ParameterName = ":C_ACTUAL_PAY_DATE_BEGIN"; param.OracleType = System.Data.OracleClient.OracleType.DateTime; param.Size = 7; param.Value = cause.ACTUAL_PAY_DATE.Begin; paramList.Add(param); } if (cause.ACTUAL_PAY_DATE.End != null) { strBuf.Append(" And MCE_B_ASSETS_CONTRACT_PAY.ACTUAL_PAY_DATE < :C_ACTUAL_PAY_DATE_END"); param = new OracleParameter(); param.ParameterName = ":C_ACTUAL_PAY_DATE_END"; param.OracleType = System.Data.OracleClient.OracleType.DateTime; param.Size = 7; param.Value = cause.ACTUAL_PAY_DATE.End; paramList.Add(param); } } if (cause.HasINValue("ACTUAL_PAY_DATE")) { strBuf.Append(cause.GetINSQL("MCE_B_ASSETS_CONTRACT_PAY", "ACTUAL_PAY_DATE")); } if (!string.IsNullOrEmpty(cause.GetCustomCondition())) { strBuf.Append(cause.GetCustomCondition()); } #endregion parameters = new OracleParameter[paramList.Count]; paramList.CopyTo(parameters); return(strBuf.ToString()); }