| | |
| | | using System.Text; |
| | | using Model; |
| | | using Common; |
| | | using Oracle.DataAccess.Client; |
| | | using Oracle.ManagedDataAccess.Client; |
| | | using System.Data.Common; |
| | | |
| | | namespace Dao |
| | |
| | | if (!string.IsNullOrEmpty(bean.DictType)) |
| | | { |
| | | builder.Append(" and DICT_TYPE = '" + bean.DictType + "'"); |
| | | } |
| | | |
| | | if (bean.ParanSource == -1) |
| | | { |
| | | builder.Append(" AND (PARAN_SOURCE != " + bean.ParanSource + " OR PARAN_SOURCE IS NULL) "); |
| | | } |
| | | else |
| | | { |
| | | builder.Append(" AND PARAN_SOURCE = " + bean.ParanSource + " "); |
| | | } |
| | | |
| | | if (bean.Status == -1) |
| | |
| | | o.DictLabel = oracleReaderWrapper.GetString("DICT_LABEL", ""); |
| | | o.DictType = oracleReaderWrapper.GetString("DICT_TYPE", ""); |
| | | o.DictSort = oracleReaderWrapper.GetInt("DICT_SORT", 1); |
| | | o.ParanSource = oracleReaderWrapper.GetInt("PARAN_SOURCE", 1); |
| | | o.DelFlag = oracleReaderWrapper.GetInt("DEL_FLAG", 0); |
| | | o.Status = oracleReaderWrapper.GetInt("STATUS", 0); |
| | | o.CreateBy = oracleReaderWrapper.GetString("CREATE_BY", ""); |