| | |
|---|
| | | this.sWhere += " and 关闭人<>''"; |
|---|
| | | } |
|---|
| | | } |
|---|
| | | if (this.hform.BenginHCreateDate) { |
|---|
| | | this.sWhere += " and CONVERT(varchar(100),日期, 23) >= '" + this.hform.BenginHCreateDate + "'"; |
|---|
| | | if (this.hform.HBeginDate) { |
|---|
| | | this.sWhere += " and CONVERT(varchar(100),日期, 23) >= '" + this.hform.HBeginDate + "'"; |
|---|
| | | } |
|---|
| | | if (this.hform.EndHCreateDate) { |
|---|
| | | this.sWhere += " and CONVERT(varchar(100),日期, 23) >= '" + this.hform.EndHCreateDate + "'"; |
|---|
| | | if (this.hform.HEndDate) { |
|---|
| | | this.sWhere += " and CONVERT(varchar(100),日期, 23) >= '" + this.hform.HEndDate + "'"; |
|---|
| | | } |
|---|
| | | if (this.hform.HBillNo) { |
|---|
| | | this.sWhere += " and 单据号 like '%" + this.hform.HBillNo + "%'"; |
|---|
