| | |
|---|
| | | MaterOutSumReport com = JsonConvert.DeserializeObject<MaterOutSumReport>(sWhere.ToString()); |
|---|
| | | |
|---|
| | | string sql = "" + |
|---|
| | | "( (染厂出站日期 between ''" + com.HBeginDate + "'' and ''" + com.HEndDate + "'') or (''" + com.HBeginDate + "'' = '''' and ''" + com.HEndDate + "''='''') ) " + |
|---|
| | | "( (生产订单日期 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.HProductName + "'' or ''" + com.HProductName + "''='''') " + |
|---|
