| | |
| | | //string sql = "" + |
| | | // "( (日期 between ''" + com.HBeginDate + "'' and ''" + com.HEndDate + "'') or (''" + com.HBeginDate + "'' = '''' and ''" + com.HEndDate + "''='''') ) " + |
| | | // "and (产品代码=''" + com.HMaterNumber + "'' or ''" + com.HMaterNumber + "''='''') " + |
| | | // "and (单据号=''" + com.HBillNo + "'' or ''"+ com.HBillNo + "''='''') " + |
| | | // "and (单据号=''" + com.HBillNo + "'' or ''" + com.HBillNo + "''='''') " + |
| | | // "and (产品名称=''" + com.HProductName + "'' or ''" + com.HProductName + "''='''') " + |
| | | // "and (规格型号=''" + com.HProductModel + "'' or ''" + com.HProductModel + "''='''') " + com.RandomSearch + |
| | | // " " + com.OtherSearch; |