if(!
sQuery.IsEmpty())
{
SQL+=
"where InsCode='"+sQuery+
"'";
}
if(!
sProvider.IsEmpty())
{
if(SQL.Pos(
"where")!=
0)
{
SQL+=
" and Provider='"+sProvider+
"'";
}
else
{
SQL+=
" where Provider='"+sProvider+
"'";
}
}
AnsiString SQL =
"select * from TEV_Stock_In where 1=1 ";
if(RzComboBox2->ItemIndex==
1)
{
sQuery =
GetInsCodeByHelpSign(sQuery);
}
if(!
sQuery.IsEmpty())
{
SQL+=
" and InsCode='"+sQuery+
"'";
}
if(!
sProvider.IsEmpty())
{
SQL+=
" and Provider='"+sProvider+
"'";
}
转载于:https://www.cnblogs.com/luyuxibaby/p/5217306.html
