62,041
社区成员
发帖
与我相关
我的任务
分享
if (obj.name != null && obj.name != "")
{
Where += " and pt.name like '" + obj.name + "%'";
}
if (obj.piz != null && obj.piz != "")
{
Where += " and pt.piz like '" + obj.piz + "%'";
}
if (obj.wer != null && obj.wer != "")
{
Where += " and pt.wer like '" + obj.wer + "%'";
}
//这里需要查询另外一个表,两者之间的关联是Cus.id,这样写是不对的,应该怎么表述才对呢
if (obj.telephone != null && obj.telephone !="")
{
Where += "and linkman.phone_home like '" + obj.telephone + "%' or linkman.phone_office like '" + obj.telephone + "%' (select * from linkman)";
}
Sql = " pt.*,";
//查询条件
Where += "and pt.id in (select id from linkman where phone_home like '" + obj.telephone + "%' or phone_office like '" + obj.telephone + "%')";