protected
String searchTdgh(Map<String, String>
map) {
StringBuffer
search =
new
StringBuffer();
String
mailNum = map.get(
"mailNum"
);
//
邮件号
String
tdghsinglemailmum = map.get(
"tdghsinglemailmum"
);
if
(mailNum !=
null
&& !(mailNum.isEmpty()))
{
search.append(
"
and mailNum like '%"
+ mailNum +
"%'"
);
}
if
(tdghsinglemailmum !=
null
&& !(tdghsinglemailmum.isEmpty()))
{
String[]
tdghmulmailmum = tdghsinglemailmum.split(
"\n|\r\n|\r"
);
StringBuffer
searchmulmailmum =
new
StringBuffer();
for
(String singlemailmum : tdghmulmailmum) {
if
(singlemailmum
.equalsIgnoreCase(tdghmulmailmum[tdghmulmailmum.length
-
1
]))
{
searchmulmailmum.append(
"'"
+singlemailmum.trim()+
"'"
);
}
else
{
searchmulmailmum.append(
"'"
+singlemailmum.trim()
+
"',"
);
}
}
search.append(
"
and mailNum IN ("
+ searchmulmailmum.toString() +
")"
);
}
return
search.toString();
}