public static string PrepareCause(CauseObject_MCE_B_ASSETS_WRITE_OFF_ATTACH cause, out OracleParameter[] parameters) { //平台自动生成代码 System.Text.StringBuilder strBuf = new System.Text.StringBuilder(); ArrayList paramList = new ArrayList(); OracleParameter param = null; #region Push Block if (!string.IsNullOrEmpty(cause.BASE_ID)) { strBuf.Append(" And MCE_B_ASSETS_WRITE_OFF_ATTACH.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_WRITE_OFF_ATTACH", "BASE_ID")); } if (cause.CREATE_DATE != null) { if (cause.CREATE_DATE.Begin != null) { strBuf.Append(" And MCE_B_ASSETS_WRITE_OFF_ATTACH.CREATE_DATE >= :C_CREATE_DATE_BEGIN"); param = new OracleParameter(); param.ParameterName = ":C_CREATE_DATE_BEGIN"; param.OracleType = System.Data.OracleClient.OracleType.DateTime; param.Size = 7; param.Value = cause.CREATE_DATE.Begin; paramList.Add(param); } if (cause.CREATE_DATE.End != null) { strBuf.Append(" And MCE_B_ASSETS_WRITE_OFF_ATTACH.CREATE_DATE < :C_CREATE_DATE_END"); param = new OracleParameter(); param.ParameterName = ":C_CREATE_DATE_END"; param.OracleType = System.Data.OracleClient.OracleType.DateTime; param.Size = 7; param.Value = cause.CREATE_DATE.End; paramList.Add(param); } } if (cause.HasINValue("CREATE_DATE")) { strBuf.Append(cause.GetINSQL("MCE_B_ASSETS_WRITE_OFF_ATTACH", "CREATE_DATE")); } if (!string.IsNullOrEmpty(cause.SAVENAME)) { strBuf.Append(" And MCE_B_ASSETS_WRITE_OFF_ATTACH.SAVENAME ").Append((cause.SAVENAME.StartsWith("%") || cause.SAVENAME.EndsWith("%")) ? " like " : " = ").Append(" :C_SAVENAME"); param = new OracleParameter(); param.ParameterName = ":C_SAVENAME"; param.OracleType = System.Data.OracleClient.OracleType.VarChar; param.Size = 300; param.Value = cause.SAVENAME; paramList.Add(param); } if (cause.HasINValue("SAVENAME")) { strBuf.Append(cause.GetINSQL("MCE_B_ASSETS_WRITE_OFF_ATTACH", "SAVENAME")); } if (!string.IsNullOrEmpty(cause.USER_ID)) { strBuf.Append(" And MCE_B_ASSETS_WRITE_OFF_ATTACH.USER_ID ").Append((cause.USER_ID.StartsWith("%") || cause.USER_ID.EndsWith("%")) ? " like " : " = ").Append(" :C_USER_ID"); param = new OracleParameter(); param.ParameterName = ":C_USER_ID"; param.OracleType = System.Data.OracleClient.OracleType.Char; param.Size = 36; param.Value = cause.USER_ID; paramList.Add(param); } if (cause.HasINValue("USER_ID")) { strBuf.Append(cause.GetINSQL("MCE_B_ASSETS_WRITE_OFF_ATTACH", "USER_ID")); } if (!string.IsNullOrEmpty(cause.FILE_NAME)) { strBuf.Append(" And MCE_B_ASSETS_WRITE_OFF_ATTACH.FILE_NAME ").Append((cause.FILE_NAME.StartsWith("%") || cause.FILE_NAME.EndsWith("%")) ? " like " : " = ").Append(" :C_FILE_NAME"); param = new OracleParameter(); param.ParameterName = ":C_FILE_NAME"; param.OracleType = System.Data.OracleClient.OracleType.VarChar; param.Size = 300; param.Value = cause.FILE_NAME; paramList.Add(param); } if (cause.HasINValue("FILE_NAME")) { strBuf.Append(cause.GetINSQL("MCE_B_ASSETS_WRITE_OFF_ATTACH", "FILE_NAME")); } if (!string.IsNullOrEmpty(cause.ID)) { strBuf.Append(" And MCE_B_ASSETS_WRITE_OFF_ATTACH.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_WRITE_OFF_ATTACH", "ID")); } if (!string.IsNullOrEmpty(cause.GetCustomCondition())) { strBuf.Append(cause.GetCustomCondition()); } #endregion parameters = new OracleParameter[paramList.Count]; paramList.CopyTo(parameters); return(strBuf.ToString()); }