using Common; using Oracle.DataAccess.Client; using System; using System.Collections.Generic; using System.Data.Common; namespace Dao { public class GwRptCodeDao : IDisposable { public List LoadRptCodeList() { List list = new List(); using (OracleDataReader reader = OracleHelper.ExecuteReader("SELECT * FROM GW_RPT_CODE ORDER BY CREATE_TIME ASC", OracleHelper.Connection)) { while (reader != null && ((DbDataReader) reader).Read()) { OracleReaderWrapper oracleReaderWrapper = new OracleReaderWrapper(reader); list.Add(new RptCode() { NewCode = oracleReaderWrapper.GetString("NEW_CODE", ""), OldCode = oracleReaderWrapper.GetString("OLD_CODE", ""), CreateTime = oracleReaderWrapper.GetDateTime("CREATE_TIME"), Remark = oracleReaderWrapper.GetString("REMARK", "") }); } } return list; } public void Dispose() { } public RptCode GetRptCode(string oldCode) { using (OracleDataReader reader = OracleHelper.ExecuteReader("SELECT * FROM GW_RPT_CODE WHERE OLD_CODE=:OLD_CODE", OracleHelper.Connection, new OracleParameter(":OLD_CODE", (object) oldCode))) { if (reader != null && ((DbDataReader) reader).Read()) { OracleReaderWrapper oracleReaderWrapper = new OracleReaderWrapper(reader); return new RptCode() { NewCode = oracleReaderWrapper.GetString("NEW_CODE", ""), OldCode = oracleReaderWrapper.GetString("OLD_CODE", ""), CreateTime = oracleReaderWrapper.GetDateTime("CREATE_TIME"), Remark = oracleReaderWrapper.GetString("REMARK", "") }; } } return (RptCode) null; } public bool UpdateCode(RptCode code) { return OracleHelper.ExecuteSql("UPDATE GW_RPT_CODE SET NEW_CODE =:NEW_CODE,REMARK=:REMARK WHERE OLD_CODE=:OLD_CODE", OracleHelper.Connection, new OracleParameter(":NEW_CODE", (object) code.NewCode), new OracleParameter(":OLD_CODE", (object) code.OldCode), new OracleParameter(":REMARK", (object) code.Remark)) > 0; } public bool DeleteCode(string oldCode) { return OracleHelper.ExecuteSql("DELETE FROM GW_RPT_CODE WHERE OLD_CODE = :OLD_CODE", OracleHelper.Connection, new OracleParameter(":OLD_CODE", (object) oldCode)) > 0; } public bool AddCode(RptCode code) { return OracleHelper.ExecuteSql("INSERT INTO GW_RPT_CODE(OLD_CODE,NEW_CODE,CREATE_TIME,REMARK) VALUES(:OLD_CODE,:NEW_CODE,SYSDATE,:REMARK)", OracleHelper.Connection, new OracleParameter(":OLD_CODE", (object) code.OldCode), new OracleParameter(":NEW_CODE", (object) code.NewCode), new OracleParameter(":REMARK", (object) code.Remark)) > 0; } public List LoadErrCodeList() { List list = new List(); using (OracleDataReader reader = OracleHelper.ExecuteReader("SELECT * FROM GW_ERR_CODE ORDER BY TYPE,CODE ASC", OracleHelper.Connection)) { while (reader != null && ((DbDataReader) reader).Read()) { OracleReaderWrapper oracleReaderWrapper = new OracleReaderWrapper(reader); list.Add(new ErrCode() { Code = oracleReaderWrapper.GetString("CODE", ""), Remark = oracleReaderWrapper.GetString("REMARK", ""), Type = oracleReaderWrapper.GetInt("TYPE", 0) }); } } return list; } } }