/// <summary>
/// 构建搜索条件
/// </summary>
/// <param name="p"></param>
/// <returns></returns>
private string AppendWhere(object p)
{
string sqlWhere = " 1=1 ";
if (p != null)
{
SAPRecord obj = p as SAPRecord;
sqlWhere += string.IsNullOrEmpty(obj.Werks) ? "" : " AND Werks LIKE '%" + obj.Werks + "%' ";
sqlWhere += string.IsNullOrEmpty(obj.Zpltn) ? "" : " AND Zpltn LIKE '%" + obj.Zpltn + "%' ";
sqlWhere += string.IsNullOrEmpty(obj.Matnr) ? "" : " AND Matnr LIKE '%" + obj.Matnr + "%' ";
sqlWhere += string.IsNullOrEmpty(obj.Exidv) ? "" : " AND Exidv LIKE '%" + obj.Exidv + "%' ";
sqlWhere += string.IsNullOrEmpty(obj.ZlgortOri) ? "" : " AND ZlgortOri LIKE '%" + obj.ZlgortOri + "%' ";
sqlWhere += string.IsNullOrEmpty(obj.ZlgortTar) ? "" : " AND ZlgortTar LIKE '%" + obj.ZlgortTar + "%' ";
sqlWhere += string.IsNullOrEmpty(obj.StartTime) ? "" : " AND created>=" + obj.StartTime;
sqlWhere += string.IsNullOrEmpty(obj.EndTime) ? "" : " AND created<=" + obj.EndTime;
}
return(sqlWhere);
}
public void SearchWhere(SAPRecord theRfid_tag)
{
sAPRecord = theRfid_tag;
}
