/// <summary> /// 增加一条数据 /// </summary> public bool Add(Entity.SYSTEMLOG model) { StringBuilder strSql = new StringBuilder(); DbAPI dbHelper = new DbAPI(); strSql.Append("insert into SYSTEMLOG("); strSql.Append("LOG_ID,LOGNAME,TYPE,CONTENT,F_ACCOUNT,REMARK,DATETIME"); strSql.Append(") values ("); strSql.Append(":LOG_ID,:LOGNAME,:TYPE,:CONTENT,:F_ACCOUNT,:REMARK,:DATETIME"); strSql.Append(") "); OracleParameter[] parameters = { new OracleParameter(":LOG_ID", OracleType.VarChar, 36), new OracleParameter(":LOGNAME", OracleType.VarChar, 256), new OracleParameter(":TYPE", OracleType.VarChar, 36), new OracleParameter(":CONTENT", OracleType.VarChar, 1000), new OracleParameter(":F_ACCOUNT", OracleType.VarChar, 36), new OracleParameter(":REMARK", OracleType.VarChar, 128), new OracleParameter(":DATETIME", OracleType.DateTime) }; parameters[0].Value = dbHelper.GUID(); parameters[1].Value = model.LOGNAME; parameters[2].Value = model.TYPE; parameters[3].Value = model.CONTENT; parameters[4].Value = model.F_ACCOUNT; parameters[5].Value = model.REMARK; parameters[6].Value = model.DATETIME; try { dbHelper.OpenConn(""); int result = dbHelper.ExecuteNonQuery(strSql.ToString(), parameters); dbHelper.CloseConn(); if (result > 0) { return(true); } else { return(false); } } catch (Exception ex) { LogBN.WriteLog(typeof(SYSTEMLOG_BN), "Add 程序段的异常" + ex); return(false); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Entity.SYSTEMLOG model) { StringBuilder strSql = new StringBuilder(); DbAPI dbHelper = new DbAPI(); strSql.Append("update SYSTEMLOG set "); strSql.Append(" LOG_ID = :LOG_ID , "); strSql.Append(" LOGNAME = :LOGNAME , "); strSql.Append(" TYPE = :TYPE , "); strSql.Append(" CONTENT = :CONTENT , "); strSql.Append(" F_ACCOUNT = :F_ACCOUNT , "); strSql.Append(" REMARK = :REMARK , "); strSql.Append(" DATETIME = :DATETIME "); strSql.Append(" where "); OracleParameter[] parameters = { new OracleParameter(":LOG_ID", OracleType.VarChar, 36), new OracleParameter(":LOGNAME", OracleType.VarChar, 256), new OracleParameter(":TYPE", OracleType.VarChar, 36), new OracleParameter(":CONTENT", OracleType.VarChar, 1000), new OracleParameter(":F_ACCOUNT", OracleType.VarChar, 36), new OracleParameter(":REMARK", OracleType.VarChar, 128), new OracleParameter(":DATETIME", OracleType.DateTime) }; parameters[0].Value = model.LOG_ID; parameters[1].Value = model.LOGNAME; parameters[2].Value = model.TYPE; parameters[3].Value = model.CONTENT; parameters[4].Value = model.F_ACCOUNT; parameters[5].Value = model.REMARK; parameters[6].Value = model.DATETIME; int rows = dbHelper.ExecuteNonQuery(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Entity.SYSTEMLOG GetModel() { StringBuilder strSql = new StringBuilder(); DbAPI dbHelper = new DbAPI(); strSql.Append("select LOG_ID, LOGNAME, TYPE, CONTENT, F_ACCOUNT, REMARK, DATETIME "); strSql.Append(" from SYSTEMLOG "); strSql.Append(" where "); OracleParameter[] parameters = { }; Entity.SYSTEMLOG model = new Entity.SYSTEMLOG(); DataTable ds = dbHelper.GetDataTable(strSql.ToString(), parameters); if (ds.Rows.Count > 0) { model.LOG_ID = ds.Rows[0]["LOG_ID"].ToString(); model.LOGNAME = ds.Rows[0]["LOGNAME"].ToString(); model.TYPE = ds.Rows[0]["TYPE"].ToString(); model.CONTENT = ds.Rows[0]["CONTENT"].ToString(); model.F_ACCOUNT = ds.Rows[0]["F_ACCOUNT"].ToString(); model.REMARK = ds.Rows[0]["REMARK"].ToString(); if (ds.Rows[0]["DATETIME"].ToString() != "") { model.DATETIME = DateTime.Parse(ds.Rows[0]["DATETIME"].ToString()); } return(model); } else { return(null); } }