修正 PNL表列表 Set表列表 日期查询字段结束日期判定为结束日0点的问题
| | |
| | | sWhere += " and 鏉$爜缂栧彿 like '%" + HBarCode + "%'"; |
| | | } |
| | | if (HBeginDate != "" && HEndDate != "") { |
| | | sWhere += "and 鍒涘缓鏃堕棿 between '" + HBeginDate + "' and '" + HEndDate + "'"; |
| | | sWhere += "and 鍒涘缓鏃堕棿 between '" + HBeginDate + " 00:00:00' and '" + HEndDate + " 23:59:59'"; |
| | | } |
| | | if (GetDataCols != "") { |
| | | sWhere += GetDataCols; |
| | |
| | | sWhere += " and 鏉$爜缂栧彿 like '%" + HBarCode + "%'"; |
| | | } |
| | | if (HBeginDate != "" && HEndDate != "") { |
| | | sWhere += "and 鍒涘缓鏃堕棿 between '" + HBeginDate + "' and '" + HEndDate + "'"; |
| | | sWhere += "and 鍒涘缓鏃堕棿 between '" + HBeginDate + " 00:00:00' and '" + HEndDate + " 23:59:59'"; |
| | | } |
| | | if (GetDataCols != "") { |
| | | sWhere += GetDataCols; |